What Your CPA Wishes You'd Stop Doing in QuickBooks

Spend a few hours on r/Accounting and a pattern emerges. Tax pros have a love-hate relationship with QuickBooks. They love that their clients try. They hate what their clients actually do.

A working accountant captured the universal frustration:

"Yes, the info is technically in QuickBooks. But so is chaos. So is confusion. So is my slow descent into madness."

This post is the honest list of QuickBooks behaviors that drive your CPA insane — gathered from r/Accounting, r/Bookkeeping, and 2,200+ Level engagements — and the fixes that make tax season cost less.

1. Treating "categorized" as "done"

The single biggest pattern. Owners click "accept" on suggested categories from the bank feed and assume the bookkeeping is complete.

What CPAs see:

• 60% of expenses coded as "Miscellaneous" or "Uncategorized Expense"
• "Owner Expense" account containing personal AND business mixed
• Vendor names that match nothing on the W-9 / 1099 file
• Income items routed to expense accounts

The fix:

• Build a chart of accounts that reflects your actual business (don't just use defaults)
• Assign a real account to every transaction (no "uncategorized")
• Use vendor names consistently — pick one spelling per vendor
• Reconcile categorizations to your management P&L expectations monthly

2. Not reconciling the bank account

Bank feed pulling transactions is not the same as reconciling. Recall:

"Well I log into their QB and the last bank rec was done in February. It is now November." — bookkeeper, r/Bookkeeping

What CPAs see:

• Trial balance that doesn't tie to bank statements
• Phantom uncleared transactions years old
• Cash balance per books that doesn't match the bank
• Sales tax remitted on incorrect revenue numbers

The fix:

• Reconcile every bank, credit card, and loan account every month
• Generate a written reconciliation report (PDF) — keep them for 7 years
• Investigate uncleared transactions older than 60 days
• Use QB's reconciliation history (Banking → Reconcile → History) to verify it's actually happening

3. Mixing personal and business

Owners using business credit cards for personal expenses, or paying business expenses from personal accounts.

"A $5,000 'business meal' at Disney World — including park tickets, souvenirs, and all. Netflix subscription categorized under 'Professional Services.'" — bookkeeper, r/Accounting

What CPAs see:

• Audit risk on every "business meal"
• Charitable contributions that don't deserve the deduction
• Travel that mixed business with personal in undocumented ways
• Personal expenses on business cards that should be reclassified as owner draw

The fix:

• Separate cards completely (business cards for business, personal cards for personal)
• If you accidentally use the wrong card, reclassify immediately as "Owner Draw" (asset, not expense)
• Keep contemporaneous documentation for any expense you intend to deduct
• Don't try to deduct things you can't document — the audit cost exceeds the savings

4. Letting AR pile up without action

QuickBooks shows you're owed $400K. The actual collectible is closer to $250K. Nobody has chased the $150K of AR over 90 days.

What CPAs see:

• AR aging full of dead invoices that should be written off
• Bad debt expense never recorded
• Revenue that overstates what was actually earned
• Tax computed on revenue that won't be collected

The fix:

• Run AR aging report monthly
• Investigate anything over 60 days
• Write off uncollectible invoices (with proper bad debt entry)
• Don't let AR be a graveyard of forgotten invoices

5. No A/P discipline (or all unpaid bills entered late)

Some owners enter every bill in QuickBooks the day it arrives. Others enter no bills and just record payments when they hit the bank. Both extremes cause problems.

What CPAs see:

• Cash basis vs. accrual basis confusion
• December bills entered in January (income shifted between tax years)
• Vendor balances that don't match vendor statements
• 1099 vendor totals wrong because bills weren't recorded properly

The fix:

• Pick a system: enter all bills as they arrive (accrual) or just record payments (cash) — but pick one
• For accrual: enter bills within 5 business days of receipt
• Reconcile vendor balances to vendor statements quarterly
• Make sure 1099-eligible vendors are flagged correctly throughout the year

6. Fake reconciliation tactics

The most damaging one. Some bookkeepers (and software users) "reconcile" by:

"Once a month the prior bookkeeper entered a journal entry for all the expenses (one line per category) and then 'reconciled' the bank by doing a second journal entry for revenue by math" — bookkeeper, r/Bookkeeping

What CPAs see:

• Reconciliation reports that "balance" but don't represent actual transaction matching
• Journal entries that plug differences instead of resolving them
• Books that look clean on paper but can't be audited or substantiated

The fix:

• Real reconciliation matches actual cleared transactions to bank statement
• Differences are investigated, not plugged
• Journal entries are exceptional, documented, and approved — not the primary recording method

7. Not flagging vendors for 1099

QuickBooks needs to know which vendors get 1099s. If they're not flagged correctly, January becomes a fire drill.

What CPAs see:

• Vendors paid $600+ without W-9 collected
• 1099-NEC vs. 1099-MISC confusion (they're different forms)
• Last-minute scramble to issue corrected 1099s
• Penalties for late or missing 1099s

The fix:

• Collect W-9 from every new vendor before paying them
• Mark vendor as "Track for 1099" in QuickBooks setup
• Run 1099 vendor report quarterly to verify accuracy
• Issue 1099s by January 31 (deadline is firm)

8. Loans booked as income (or vice versa)

A surprisingly common error. The owner gets a loan, the cash hits the bank, and the bookkeeper categorizes it as "Other Income" because they don't know what else to do.

What CPAs see:

• Phantom income that triggers tax on borrowed money
• Or: real income classified as loans (worse — fraud risk)
• Loan principal payments classified as interest expense
• Bank loans not appearing on the balance sheet at all

The fix:

• Loan proceeds: liability account on balance sheet (e.g., "Bank Loan — Wells Fargo")
• Loan principal payments: reduce the liability (not an expense)
• Loan interest payments: interest expense (deductible)
• Get the loan agreement; book it correctly

9. Misusing "Owner's Equity" accounts

QuickBooks defaults give you owner's equity, owner's contributions, and owner's draw. Most users dump everything into "Owner's Equity" and create a mess.

What CPAs see:

• Owner contributions and draws mixed
• Distributions for S-corp not properly tracked
• Year-end basis calculation impossible
• Partners' capital accounts unmaintained for partnerships

The fix:

• Separate accounts: Owner Contributions (money in), Owner Draws (money out), Distributions (S-corp), Owner Salary (S-corp W-2)
• For partnerships: separate capital accounts per partner
• Annual rollup of contributions/distributions/income to maintain basis

10. Skipping the close (just leaving everything open)

Most QuickBooks files have everything wide open all the time. Owners can change transactions from 3 years ago. Numbers shift between when the CPA looks at them.

What CPAs see:

• Trial balance that changes between meetings
• Prior-period tax filings becoming inaccurate as old transactions are modified
• No control over who's changing what
• Audit trail that doesn't actually trail

The fix:

• Use the closing date feature (Settings → Account → Closing Date)
• Set a closing date password so prior periods can't be modified accidentally
• Close each month after reconciliation is complete
• Reopen only with explicit decision and documentation

What good books look like to a CPA

Five characteristics of "easy to work with" books from a CPA's perspective:

1. Trial balance ties to bank statements for every cash, credit, and loan account
2. Chart of accounts is meaningful — not 200 accounts, not 20, but the right ~50-80 for the business
3. Expense categories match tax categories so transferring to Form 1120/1065/Schedule C is mechanical
4. AR and AP are real and current — not full of zombie invoices
5. Owner activity is properly classified — separate contribution, draw, distribution, salary

If your books have these five things, your CPA's life is dramatically easier and your tax prep cost is lower. If they don't, your CPA spends hours every spring fixing what should have been done monthly.

When to call Level

Level isn't a tax preparer — that's CPA work. But we make sure the books your CPA receives are clean enough to actually work from. For most $1-30M service businesses, this means:

• Initial chart of accounts review and cleanup
• Monthly close discipline with real reconciliation
• AR/AP aging and management
• Vendor management including W-9 collection
• Year-end packet preparation for the CPA

Many of our clients save more on CPA fees (by giving them clean books) than they spend on Level's monthly fees.

FAQ

Can my CPA do my bookkeeping too? Some can, but the economics are usually wrong. CPAs charge $200-500/hour. Bookkeeping doesn't need that level of expertise. Most CPAs would rather you have a competent bookkeeper than try to do bookkeeping themselves.

Should I switch from QuickBooks to a "better" software? Not based on bookkeeping problems alone. The software isn't usually the issue — the discipline and skill of the user is. We've seen Xero, NetSuite, and Sage all run by users with the same issues. Fix the discipline first, then evaluate software.

How often should I look at my QuickBooks file? Owners should look at financial statements (not the QB file directly) once a month with their bookkeeper or CFO. The actual data entry should happen in real-time or daily, by the bookkeeper. Owners spending hours in QB themselves is usually a sign that the bookkeeping function isn't working.

Related reading:

• Year-End Is in 7 Weeks. Your Last Bank Rec Was in February.
• Why QuickBooks Is Failing Small Businesses
• When to Outgrow QuickBooks