The QuickBooks Cleanup Checklist We Run Before Every Close
Key takeaways
- Almost every broken QuickBooks file breaks in the same seven places: the fix is a checklist, not detective work.
- Reconcile first. Every other check is meaningless if the accounts do not tie to real statements.
- A growing Undeposited Funds balance means income is recorded twice or deposits were never matched.
- Opening Balance Equity should be zero after setup. Anything sitting there is an unresolved plug.
- Run the checklist monthly and the annual close becomes a formality instead of a reconstruction.
We see a lot of QuickBooks files. Files that have been running for a decade, files set up last quarter, files maintained by careful bookkeepers and files maintained by nobody in particular.
The striking thing is how few ways there are to break one. Almost every problem file has the same handful of issues, in some combination. So rather than treating each one as a mystery, we run a checklist: in this order, because each step depends on the one before it.
1. Reconcile every account: first, always
Nothing else matters until this is done. Every bank account, credit card, line of credit, loan and merchant processor, reconciled to an actual statement.
Two things to watch for:
- Old uncleared transactions. A check from fourteen months ago that never cleared is usually a duplicate, a voided payment nobody removed, or a genuine outstanding item that needs investigating.
- Reconciliation discrepancies. QuickBooks reports these when a previously reconciled transaction is later edited or deleted. It is the clearest signal that someone changed history.
2. Clear Undeposited Funds
Undeposited Funds is a holding account. Payments land there when received, then leave when you record the deposit that groups them.
Used properly, the balance returns to zero or near it after each deposit. A balance that only grows means one of two things:
- Payments were received into Undeposited Funds, and the bank deposit was then entered separately from the feed, so income is recorded twice
- Payments were recorded but never matched to a deposit at all
Either way, both your income and your bank balance are wrong. This single issue accounts for more overstated revenue than anything else we encounter.
3. Resolve Opening Balance Equity
QuickBooks creates this account during setup to hold balances that do not yet have a home. After setup is complete it should be zero.
If there is a balance sitting in it, something was entered without a proper offsetting account, usually beginning balances that were never allocated to retained earnings or owner equity. Trace it to its components and reclassify. Do not simply journal it away, because whatever is hiding in there is often a genuine error.
Quick test
Run a Balance Sheet, click into Opening Balance Equity, and sort by date. The oldest entries usually reveal exactly what went wrong during setup, and it is nearly always the same week.
4. Hunt duplicates from bank feed rules
Bank rules are useful and dangerous in equal measure. The classic failure: a bill is entered manually, then the bank feed imports the payment and a rule categorizes it as a new expense. The expense is now recorded twice and the bill sits open forever.
Check for:
- Vendors with an unusually high transaction count for the period
- Open bills that are clearly already paid
- Two identical amounts to the same payee within a few days
5. Empty "Ask My Accountant" and "Uncategorized"
These are parking spaces, not destinations. Every transaction in them is a decision nobody made, and a decision deferred long enough becomes a guess.
Work through them monthly while the context is still fresh. If you genuinely do not know what something was, that is worth knowing too: it usually means a receipt process is not working.
6. Read the balance sheet line by line
The P&L gets all the attention. The balance sheet is where errors actually hide, because a wrong balance sheet almost always means a wrong P&L somewhere behind it.
| Check | What a problem indicates |
|---|---|
| Negative asset balances | Payments recorded against the wrong account |
| Negative liability balances | Usually an overpayment or a double-recorded payment |
| Loan balances vs. lender statement | Principal and interest not being split correctly |
| Payroll liabilities that never clear | Payroll entries not matching actual tax deposits |
| Sales tax payable vs. filed returns | Collected tax not being remitted, or wrong rate applied |
| Accounts receivable aging | Invoices already paid but never marked as such |
7. Close the period and lock it
Once the month is reconciled and reviewed, set a closing date with a password. This is the step almost nobody does, and it is the reason files drift.
Without it, anyone can edit a transaction from eight months ago and silently change a period you already reported on: to a lender, to a board, or on a filed tax return. With it, corrections must be made deliberately, in the current period, where they belong.
Why the order matters
Each step depends on the one before it. Chasing duplicates before reconciling means you cannot tell a duplicate from a legitimate transaction. Reviewing the balance sheet before clearing Undeposited Funds means reviewing numbers you already know are wrong.
Run this monthly and it takes perhaps an hour once you are in rhythm. Run it once a year and it is not a checklist any more: it is a reconstruction, and it costs accordingly.
Dariel Kingsley
Managing Director · Kingsley Accounting Group
Dariel Kingsley has led Kingsley Accounting Group since 2017. Before founding the firm she managed audit and advisory services at PM+M Accounting LLP, served as Chief Financial Officer at Bekaert & Holland Accounting LLP, and worked in finance at Whitley Penn Accounting LLP. She holds a BS in Accounting and Finance from California State University, Fresno.
