You open your accounting software for the first time in five months and the bank feed shows 412 transactions waiting for review. Invoices you are sure were paid still show as open. The profit and loss says you made money, but the bank balance disagrees.
Most owners in this spot avoid the file for another month. Don't. Tax returns, sales tax, VAT or GST filings, loan applications and your own decisions all rest on numbers that get less reliable every week.
Neglected books are very fixable, but order matters. If you start by categorizing transactions, you will redo that work once the bank accounts are reconciled and the opening balances are corrected.
How do you clean up books that are months behind?
Work in this sequence:
- Confirm a start date and the opening balances.
- Collect every bank, card and loan statement for the gap.
- Reconcile each account one month at a time, oldest first.
- Review and categorize the bank feed.
- Correct undeposited funds, receivables, payables, and payroll and sales tax liabilities.
- Review the monthly reports, then lock the period.
- Set a weekly and monthly routine so it does not happen again.
The sections below explain each step.
Confirm your start date and opening balances
Pick the last date you know the books were right, such as the last reconciled month, the last filed return, or the last time an accountant closed the period. Record the balance on that date for every bank account, credit card and loan, and check that the software shows the same figures.
This is where many cleanups quietly go wrong. An opening balance that is off by a small amount carries into every reconciliation after it. Before you change anything, export your chart of accounts, key reports and transaction lists so you have something to compare against later.
Gather source documents and keep them long enough
Download statements as PDFs straight from the bank for every month in the gap. Add payroll reports, loan statements, filed sales tax or VAT returns, and any invoices or receipts you have not recorded. The statement, not the feed, is the final word, because feeds miss transactions, duplicate them, or pull in pending items that later change.
Do not throw originals away once the cleanup is done. Retention rules differ by country. These reflect each authority's published guidance as of October 2026, and they can change:
- US: the IRS generally suggests keeping records for three years, and employment tax records for at least four.
- UK: HMRC says self-employed people must keep records for at least 5 years after the 31 January submission deadline for the tax year. Limited companies and VAT follow different rules.
- Canada: the CRA generally requires six years from the end of the last tax year the records relate to.
- Australia: the ATO says most records must be kept for five years, and ASIC requires companies to keep records for seven.
In Kenya and elsewhere, confirm the period with the local revenue authority or your accountant. If a statement is missing, ask the bank for a copy before estimating anything. HMRC, for one, expects you to flag estimated figures when you file.
Reconcile every bank and card account, oldest month first
This is the center of the job. Start with the first unreconciled month and work forward, ending each one with a difference of zero between your books and the statement.
Take Marcus Bell, a fictional landscaping owner who had not touched his books since March. When we started in August, his operating account had 387 unreviewed feed transactions, totaling 214,300 in deposits and 198,950 in payments. His reconciliations were off by amounts between 40 and 1,860, mostly from three causes:
- Duplicates, where a payment was entered manually and also arrived through the feed
- Transfers between savings and operating recorded as income in one account and an expense in the other
- Card payments entered at the invoice amount when the bank had deposited a different amount after fees
When a reconciliation will not balance, do not force it with an adjusting entry. Compare cleared transactions to the statement line by line, and look for amounts equal to the difference, half of it, or double it. A difference of 150 often points to a missing 150 transaction, and 300 can mean one was entered twice. Timing differences are normal: a cheque written on the 30th and cashed on the 4th simply clears next month.
Review the bank feed properly
Once a month reconciles, review and categorize its transactions. Start with the largest and most frequent vendors, since rules can handle those quickly. Avoid the "accept all" habit. Feeds will code things wrongly and move on, so check what each vendor maps to. A hardware store purchase sitting in office supplies might be materials, tools, repairs or something personal.
Personal spending needs special care. Groceries or a family phone plan paid from the business account should not sit in an expense account. Reclassify it to owner's draw, or the equivalent equity account for your entity type. In a company it may be a director's loan account, and the treatment varies by country, so confirm it with your accountant.
Fix the accounts that quietly collect errors
A reconciled bank account does not mean a correct balance sheet. These accounts need attention next.
Undeposited funds
Customer payments that were recorded but never matched to a bank deposit pile up here. In Marcus's file the account held 31 unmatched payments totaling 46,720. The money had reached the bank and been coded as income a second time through the feed, so revenue was overstated. Match each payment to its deposit and clear the balance to zero. A balance that never moves is a warning sign.
Accounts receivable
Run an aging report and look at everything over 90 days. Some of it needs collecting, some was paid long ago and never applied, and some will never be paid and should be written off. Contact the customer first for meaningful amounts, and link orphaned payments to their invoices so income is not counted twice.
Accounts payable
Check that bills you have already paid are not still open, then look for the opposite: unpaid bills missing from the books entirely. A vendor statement catches these quickly.
Payroll and sales tax liabilities
Unreviewed feeds do the most damage here. Payroll tax payments, tips and withheld amounts get coded as ordinary income or expense instead of liabilities, so the profit and loss looks wrong and the liability balances do not match what you owe.
Compare those accounts against your payroll provider's reports and the filings made to your tax authority (the IRS, HMRC, CRA, ATO or KRA, depending on where you operate). Check sales tax, VAT or GST accounts against filed returns the same way. If an earlier return used bad figures, ask your accountant whether an amendment is needed. Rules and deadlines differ by jurisdiction.
Parent accounts holding balances
When subaccounts are created later, balances often stay in the parent account. Move them to the correct level so the reports show what you expect.
Review the reports, then lock the period
Look at the profit and loss and balance sheet month by month, not just the totals. Revenue that doubled in one month, a utility expense that vanished, or a negative asset balance usually points to a coding error rather than a real event. Compare cash on the balance sheet to the bank statements one last time.
Then lock the period. QuickBooks Online lets you set a closing date, with an option to require a password for changes before it. Xero has two lock dates: a period lock date that stops everyone except advisers, and an adviser lock date that stops everyone, advisers included. Locking will not make the books perfect, but it stops someone quietly editing a reconciled month and undoing your work.
How do you stop the books falling behind again?
Cleanup is slow because it covers months of drift. Keeping up is fast by comparison. A weekly session of 20 to 30 minutes to review the feed, plus a reconciliation as soon as each statement arrives, is usually enough for a small business. Pick a fixed day for it, because books tend to fall behind when the task has no time attached.
Frequently asked questions
How long does a bookkeeping cleanup take?
It depends on how many months are behind, how many accounts are involved, and how many reconciliations refuse to balance. One clean account can take hours. Several accounts with payroll problems and duplicates can take days or longer.
Should I categorize transactions or reconcile first?
Reconcile first. Categorizing before the accounts are reconciled and the opening balances confirmed usually means redoing the work when duplicates and missing transactions surface.
Do I need to amend a tax return after a cleanup?
Not automatically. If a filed return relied on figures the cleanup shows were materially wrong, speak with your accountant or tax authority about amending it. Rules and deadlines differ by country.
Can I do the cleanup myself?
Often yes, if the problems are mostly categorization. If the file has years of issues, payroll liabilities that do not agree with your filings, or reconciliations that will not balance after repeated attempts, an experienced bookkeeper will usually finish faster and with fewer surprises.
If your books have slipped and you want a clear picture of what needs fixing, contact Isaiah to talk through your situation. A diagnostic review is often the quickest way to see what is wrong and in what order to fix it.
Written by Isaiah Githaiga, CPA (K), MBA, BSc BA, QuickBooks ProAdvisor.