Here are the most common QuickBooks mistakes we see in client files coming in for cleanup, what each one costs, and how to fix it.
1. Duplicate transactions
The most common mistake we see — and one of the easiest to make. Duplicates happen when:
- The same transaction is recorded manually AND imported through the bank feed
- A bank feed import was re-run and double-recorded
- A receipt was entered, then the bank transaction was categorized again separately
- Vendors are duplicated under slightly different names (a vendor is paid twice but recorded under different names)
What it costs: Inflated expenses (overstating deductions, which the IRS can disallow on audit), inaccurate financial reports, reconciliations that won't balance.
How to fix it: Use QuickBooks' built-in duplicate detection. Sort by date and amount to spot identical transactions. Remove the duplicate, not the original. For complex cases with overlapping bank feeds and manual entries, the fix can be tedious — this is one of the common reasons people hire a bookkeeper to clean up.
2. Wrong categorization
Expenses get coded to the wrong account. Software ends up under "Office Expense" sometimes and "Subscriptions" other times. Meals get coded as "Office Supplies." Owner draws get coded as "Wages."
What it costs: Inaccurate financial reports (you can't see where money is actually going), missed tax deductions (because the CPA can't find them), inflated expense categories that may trigger audit attention.
How to fix it: Build a clean chart of accounts that matches your actual business — not the QuickBooks default. Set up bank feed rules to auto-categorize recurring transactions correctly. Review categorizations monthly, not at year-end. If your file has years of miscategorization, this is a cleanup project.
3. Mixed personal and business transactions
Personal lunches, family Netflix, the kid's Amazon order — all running through the business credit card. Then a few business expenses on the personal card. Then it gets really fun.
What it costs: Lost tax deductions, weakened LLC liability protection (commingling), hours of cleanup work every year, higher audit risk.
How to fix it: Going forward — open a business bank account and credit card, use them exclusively for business, never run personal expenses through. For the existing mess — recode personal transactions through the business account as owner draws, recode business transactions through personal accounts as owner contributions. Tedious but fixable.
4. Unreconciled accounts
The bank feed imports transactions, you categorize them, and you assume that means the account is reconciled. It doesn't. Reconciliation specifically means matching your QuickBooks records to your actual bank statement and confirming nothing is missing or extra.
What it costs: Inaccurate financial reports, undetected fraud or bank errors, accounts that won't balance, books that the CPA refuses to use for tax filing.
How to fix it: Reconcile every bank and credit card account every month. Compare each transaction in QuickBooks to the statement. Investigate discrepancies before moving on. If multiple months are unreconciled, fix them in order from oldest to newest — don't try to reconcile December if October is broken.
5. The chart of accounts is a mess
QuickBooks comes with a default chart of accounts that doesn't fit most businesses. Owners customize it without planning — adding accounts on the fly, never cleaning up, ending up with 300 accounts where 50 would do.
Signs of a broken chart of accounts:
- Duplicate accounts (Office Supplies AND Office Supply AND Supplies)
- Vague catch-all accounts (Miscellaneous, Other, Uncategorized)
- Income or expense categories that don't match the business
- Accounts that were used once and never again
What it costs: Reports that don't tell you anything useful, slow categorization decisions, errors that compound over time.
How to fix it: Set aside time to redesign the chart of accounts to match your business — typically 30–50 accounts for a small business, not 300. Merge duplicates. Inactivate accounts you don't use. Map transactions from old accounts to new ones. This is one of the biggest "before you start monthly bookkeeping" cleanup tasks.
6. Misusing the "Undeposited Funds" account
This is a QuickBooks-specific trap. Undeposited Funds is a holding account for payments received that haven't been deposited yet. When used correctly, it lets you group multiple customer payments into a single bank deposit (matching how the bank sees it).
When used incorrectly, it becomes a graveyard of stuck transactions — payments recorded as received but never moved to the bank account, leaving the account balance growing year after year.
What it costs: Inflated asset balances, broken reconciliations, double-counted income.
How to fix it: Review the Undeposited Funds register. Group payments that should have been deposited together and create a deposit entry to move them to the bank account. If transactions are clearly miscategorized (the deposit already exists), delete the duplicate Undeposited Funds entry.
7. Owner pay coded as an expense
Sole props and single-member LLCs pay themselves through owner draws — equity transactions, not expenses. S-corp owners pay themselves through W-2 salary (expense) AND distributions (equity). Both get misclassified constantly.
What we see:
- Sole prop owner pulls $5,000 from the business and codes it as "Wages" or "Officer Compensation"
- S-corp owner takes a $10,000 distribution and codes it as "Wages"
- LLC member pulls money and codes it as "Loans" without proper documentation
What it costs: Inflated expenses, understated profit, confused tax filing, owner equity that doesn't reflect reality.
How to fix it: Reclassify owner draws to the appropriate equity account (Owner's Draw, Member's Draw, Shareholder Distribution). For S-corp owners, ensure W-2 salary is going through payroll and distributions are properly recorded as equity.
(Full pay-yourself walkthrough →)
8. No fixed asset tracking
Equipment, vehicles, computers, and other long-lived assets get recorded as expenses instead of as fixed assets to be depreciated.
What it costs: Lost depreciation deductions over multiple years (or wrong-year deductions), assets invisible on the balance sheet, broken tax returns.
How to fix it: Identify equipment purchases above a reasonable threshold (often $500 or $2,500 depending on policy). Reclassify them from expense accounts to fixed asset accounts. Set up depreciation schedules. Coordinate with your CPA on Section 179 and bonus depreciation elections.
9. Sales tax mishandled
Sales tax collected from customers is a liability, not revenue. It belongs to the state, not the business.
What goes wrong:
- Sales tax collected is recorded as income, inflating revenue
- Sales tax paid to the state is recorded as an expense, when it should reduce the liability
- Sales tax owed isn't accruing correctly, leading to underpayment
What it costs: Inflated revenue, missed tax payments, potential penalties from the state.
How to fix it: Set up sales tax through QuickBooks' Sales Tax Center (or equivalent in Online). Configure tax rates by jurisdiction. Sales tax collected should hit a liability account, not revenue. Sales tax payments to the state should reduce that liability, not be expensed.
10. Old, stale data still in the file
Inactive vendors, customers, accounts, and products clutter the file. Old uncategorized transactions sit in the bank feed. Old to-do items in the dashboard.
What it costs: Slow software, confusing reports, harder navigation, easier to make mistakes.
How to fix it: Annual cleanup — inactivate (don't delete) old customers and vendors, retire unused accounts, clear out old bank feed items. This is part of year-end maintenance.
What if my QuickBooks is too far gone?
Honest answer: some QuickBooks files reach a state where a clean restart is cheaper than trying to fix the existing file. Indicators:
- Years of unreconciled accounts
- Hundreds of duplicate transactions
- A chart of accounts no one understands
- The Balance Sheet shows numbers that don't make any sense
- Your CPA has said the records aren't usable
In those cases, a QuickBooks cleanup project may involve setting up a fresh file with cleaned data, rather than fixing every individual error in the old file. (How cleanup works →)
Frequently asked questions
Depends entirely on scope. A few months of issues might be a few hundred to a couple thousand dollars. Years of issues, multiple accounts, missing receipts, and a tangled chart of accounts can run into the thousands. A diagnostic review is usually the first step — it's faster and cheaper to scope the work than to guess.
Some issues, yes. Simple duplicates, missing categorizations, and basic reconciliations are doable if you have time and patience. Deeper structural issues — broken chart of accounts, cross-year miscategorizations, owner pay reclassifications — usually take a bookkeeper to fix without making it worse.
Usually no. For most small businesses, QuickBooks is the most-supported platform with the widest CPA familiarity. Switching platforms doesn't fix bookkeeping problems — it just migrates them. Cleanup first, then evaluate.
Run a Profit & Loss for the year and a Balance Sheet as of today. If either has numbers that don't match what you know about the business, the file needs cleanup. If you can't even run the reports because the data is too broken, definitely cleanup.
Where to start
If your QuickBooks file has any of these issues, the fix isn't more DIY effort — it's a clear look at what's broken and a plan to fix it. Most cleanup projects pay for themselves through recovered tax deductions, faster CPA work, and decisions made on real numbers.
SoFlo360 specializes in QuickBooks cleanup for small businesses — and the ongoing monthly bookkeeping that keeps these issues from returning. Spanish-friendly support is available for owners who'd rather handle financial conversations in Spanish.
Book a free consultation or learn more about our QuickBooks cleanup service.