QuickBooks Online is one of the most popular accounting tools for SMEs — easy to start with, affordable, and connected to your bank. But that ease of use has a flip side: it’s just as easy to create a mess as it is to create a clean file. Most messy QuickBooks files weren’t caused by carelessness. They were caused by reasonable people clicking reasonable-looking buttons without knowing the consequences.
After reviewing many SME files, we see the same problems again and again. Here are the most common ones — what causes them, how to spot them, and how to fix them.
Problem 1: Duplicate transactions
How it happens: a transaction is entered manually and imported via the bank feed; or a bank feed disconnects and re-imports overlapping periods; or an invoice payment is recorded twice — once as “Receive payment” and once directly from the feed.
How to spot it: your bank balance in QuickBooks doesn’t match the real bank. Income or expenses look inflated. The same amount appears twice on close dates.
How to fix it: run the bank register, sort by amount, and review pairs. Delete the duplicate that isn’t matched to the bank feed. Then reconcile the account month by month — reconciliation is the only reliable way to confirm duplicates are gone.
Problem 2: Unreconciled (or never-reconciled) bank accounts
How it happens: the file owner uses bank feeds and assumes “accepted” means “reconciled”. It doesn’t. Reconciliation is the formal check that your book balance equals the bank statement.
How to fix it: start from the last reconciled month (often the beginning of the file) and reconcile forward, month by month, against actual statements. Yes, it’s tedious. It’s also the single highest-value cleanup task — every other error tends to surface here.
Practical example: an Amsterdam consultancy had never reconciled in three years of trading. The cleanup surfaced €6,200 of duplicated expenses and four missing sales invoices. Their “marginal” year was actually comfortably profitable.
Problem 3: Negative or nonsense balances on the balance sheet
A negative bank balance (when the real account isn’t overdrawn), negative debtors, or a huge “Uncategorised Asset” balance are all signs that transactions were posted to the wrong place.
Typical causes: customer payments recorded without linking to invoices (creating unapplied credits), transfers between own accounts booked as income or expense, or the infamous Opening Balance Equity account still carrying values years after setup.
How to fix it: open each suspicious account and read the transactions. Link unapplied payments to their invoices. Rebook transfers as transfers. Opening Balance Equity should normally end at zero — anything left there needs to be allocated properly, ideally with your accountant’s input.
Problem 4: A chart of accounts that grew wild
When anyone can add accounts, files end up with “Marketing”, “Marketing costs”, “Advertising” and “Ads — Google” all in use simultaneously. Reports become meaningless because costs are scattered.
How to fix it: design the chart of accounts you actually need (usually 40–80 accounts for an SME), merge duplicates, and deactivate the rest. QuickBooks lets you merge accounts by renaming one to exactly match the other — historic transactions move with it.
Problem 5: VAT codes applied inconsistently
This is the most expensive problem on the list. Common patterns we find in Dutch and EU files: standard-rate VAT claimed on EU purchases that should use the reverse-charge mechanism, zero-rated sales coded as exempt (or vice versa), and VAT claimed on items where it isn’t recoverable.
How to fix it: run the VAT detail report for each filed period and scan for codes that don’t fit the transaction type. Fix the settings (default codes on products, customers and suppliers), not just the individual entries — otherwise the error returns next month. For corrections to filed returns, the right route depends on your situation, so verify with a qualified tax advisor.
Problem 6: Old open invoices and bills that aren’t real
A debtor list full of 2023 invoices usually means payments were received but never matched. A creditor list full of ancient bills usually means they were paid outside the system or entered twice.
How to fix it: work the lists oldest-first. Match, credit, or — only when genuinely uncollectible and properly documented — write off.
Common mistakes when attempting a DIY cleanup
- Deleting transactions to “make it match”. Deleting a reconciled or VAT-filed transaction changes history and creates new differences. Correct with journals or credits instead.
- Cleaning the current year while prior years are still wrong. Opening balances carry errors forward; start where the mess starts.
- Fixing symptoms, not settings. If a supplier’s default VAT code is wrong, fixing March’s bill doesn’t fix April’s.
- No backup or notes. Export reports before you start and document every correction — your accountant will ask.
Your QuickBooks cleanup checklist
- Reconcile every bank, credit card and payment platform account, month by month
- Hunt and remove duplicates (register sorted by amount)
- Clear Uncategorised Income / Expense / Asset to zero
- Resolve Opening Balance Equity with your accountant
- Rationalise the chart of accounts; merge duplicates
- Review VAT detail reports per filed period; fix default codes
- Work the aged debtors and creditors lists oldest-first
- Document all corrections and lock cleaned periods
How SlimCijfers Analytics can help
QuickBooks cleanup is one of our core services. We diagnose the file, fix the errors, correct the settings that caused them, and hand you a short report of what changed and why — plus the routines to keep it clean. And if your team wants to run QuickBooks confidently themselves, our practical QuickBooks training is built around real SME scenarios.
Frequently asked questions
How do I know if my QuickBooks file needs a cleanup?
Three quick tests: does every bank account reconcile to the real statement? Is Uncategorised anything near zero? Do you trust your profit figure enough to make a hiring decision on it? Two or more “no” answers means a cleanup will pay for itself.
Will a cleanup affect my filed VAT returns?
It can reveal differences with what was filed. Those differences should be documented and corrected through the proper route — your tax advisor can confirm the right approach for your situation.
How long does a QuickBooks cleanup take?
Small files with one messy year: often one to two weeks. Multi-year, multi-account files: typically three to four weeks. A short diagnostic review first gives you a reliable estimate.
Should I just start a new QuickBooks file instead?
Sometimes — if the file is beyond economic repair. But a fresh start still requires correct opening balances, which means the old file must be at least partially understood. It’s a last resort, not a shortcut.
Can you prevent the mess from coming back?
Yes: correct default settings, a monthly reconciliation routine, and a short month-end checklist solve most of it. We set these up as part of every cleanup.
Suspect your QuickBooks file needs attention? Book a Finance Review with SlimCijfers Analytics — we’ll tell you honestly what shape it’s in and what it would take to fix.
Leave a Reply