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.

Owners often ask some version of this: if everything is already in QuickBooks, why does tax prep still take so long? The short answer is that the information is in the file, but it is not organized, reconciled, or classified in a way a CPA can use without rework.

This post is the honest list of QuickBooks behaviors that drive your CPA insane, drawn from recurring themes in public accounting and bookkeeping forums such as r/Accounting and r/Bookkeeping and from common cleanup patterns, 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:

• A large share 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. A common owner question: the bank feed is connected and up to date, so aren't the books reconciled? Not necessarily. A file can have a current feed while its last completed reconciliation was many months ago. Operator check: open the reconciliation history for each account and note the last statement date that was reconciled.

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) and keep it with your records. Seven years is a common conservative retention practice; confirm the period that applies to you with your CPA
• Investigate uncleared transactions older than 60 days
• Use QuickBooks' reconciliation history report to verify it's actually happening. Menu names vary by edition and change over time, so check Intuit's current help article for your version

3. Mixing personal and business

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

A common owner question: if a family trip included a client dinner, can the whole trip go on the business card as a business meal? Generally no. Fictional example: a $5,000 vacation charge with a $300 client dinner inside it is mostly personal. Likewise, a streaming subscription coded to Professional Services is a classification error, not a deduction.

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)
• When a business card pays a personal expense, reclassify the personal portion as owner draw or, where appropriate, shareholder distribution. Have your CPA review corporate treatment, payroll and any documented repayment. It is not a deductible business expense.
• When a personal card pays a documented business expense, record the business expense with an owner contribution, a payable to the owner or an approved reimbursement, as appropriate to the entity and repayment policy. This is the opposite direction from an owner draw.
• 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

Fictional example: QuickBooks shows you're owed $400K. After reviewing the aging, you estimate only about $250K is collectible, because nobody has chased the $150K of AR over 90 days. Your own split will differ, so build it from your aging report, not from this example.

What CPAs see:

• AR aging full of dead invoices that should be written off
• Bad debt expense never recorded
• Revenue and receivables that overstate what will actually be collected
• On accrual-basis returns, tax computed on revenue that may never be collected (on cash-basis returns, unpaid invoices were never taxable income)

The fix:

• Run AR aging report monthly
• Investigate anything over 60 days
• Write off uncollectible invoices (with proper bad debt entry). A tax bad-debt deduction generally requires that the amount was previously included in income, so unpaid invoices are usually not deductible for cash-basis filers (see IRS Topic 453). Confirm the treatment with your CPA
• A book write-off does not waive your legal right to collect. Check contract notice and lien deadlines, which override any internal aging schedule
• Don't let AR be a graveyard of forgotten invoices

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

Entering a valid bill promptly is not an accounting problem. The risks are missing, duplicated, misdated or unsupported bills, and confusing the recordkeeping workflow with the reporting or tax basis.

What CPAs see:

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

The fix:

• Record valid bills and payments consistently without duplicate expense. Maintaining AP does not itself elect accrual tax treatment: QuickBooks can support cash-basis reporting from bill/payment records, while deductible timing still follows your CPA's tax method and applicable rules
• 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

A damaging pattern is a forced balance that skips transaction matching.

A common owner question: if the bank balance matches at month end, isn't the account reconciled? Not if the match was forced. One pattern looks like this: a single monthly journal entry for all expenses, one line per category, then a second journal entry for revenue set to whatever amount makes the bank balance tie. The balance matches, but no actual transaction was matched to the statement.

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 at or above the 1099-NEC reporting threshold without a W-9 collected. The threshold is $600 for payments made in 2025 and $2,000 for payments made in 2026, per the IRS Form 1099-NEC FAQ
• 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 the vendor for 1099 tracking in the vendor record (the setting is labeled "Track for 1099" or similar, depending on the QuickBooks edition)
• Run 1099 vendor report quarterly to verify accuracy
• File and furnish Form 1099-NEC by January 31. Other 1099 forms, including many 1099-MISC filings, have different due dates, so check the current IRS instructions for the form and tax year
• Qualifying payment-card or third-party-network transactions subject to section 6050W are excluded from your 1099-NEC and handled under Form 1099-K rules. An ordinary app transfer is not automatically a qualifying network transaction. Confirm each exception with your CPA

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 (generally deductible when the loan is for business use)
• 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 equity accounts: Owner Contributions (money in), Owner Draws (money out), Distributions (S-corp)
• Owner Salary (S-corp W-2) is not an equity account. Run it through payroll so it lands in wage expense and payroll tax liabilities
• 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. In QuickBooks Online it sits under Account and settings, Advanced, Close the books. Menu names vary by edition, so check Intuit's current help article
• Set a closing-date password to add a warning/authorization control; permitted users can still change prior transactions, so review audit history and prior-period changes
• 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 is supported by reconciliations for every cash, credit and loan account, including legitimate outstanding items
2. Chart of accounts is meaningful, not 200 accounts, not 20, but the right ~50-80 for the business
3. Expense categories have a documented tax mapping, with book-tax differences and nondeductible items reviewed before return preparation
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; return preparation stays with your CPA or tax professional. 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

To see whether clean books pay for themselves in your case, measure it. Ask your CPA how many hours last year's return spent on cleanup, multiply by their hourly rate, and compare that to what monthly bookkeeping costs. Fictional example: 20 cleanup hours at $300/hour is $6,000 of avoidable CPA time.

FAQ

Can my CPA do my bookkeeping too? Some can, but the economics are usually wrong. As an illustrative planning assumption only, if your CPA bills $200-500/hour, routine data entry at that rate is expensive. Check your CPA's actual rate against a bookkeeper's. 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. The same issues can show up in Xero, NetSuite, or Sage, because every ledger depends on the same reconciliation and classification habits. 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