Catch-up bookkeeping: how to clean up months of messy books

A new client arrives with eight months of unreconciled bank feeds, a carrier bag of receipts, two overdue returns, and a letter from the tax authority. This is catch-up bookkeeping, and it goes wrong in one of two ways: the bookkeeper quotes before looking and loses money, or starts in the middle and fixes the same errors twice. Done in the right order it is slow but mechanical. This guide sets out that order: a diagnostic before any price, the choice between repairing the file and restarting it, the month-by-month sequence, and what to do about documents and returns that are missing. Software behaviour and tax authority guidance are linked in the Sources section.

Catch-up and clean-up

The two terms get used for the same job, but they are different problems.

• Catch-up means the books are behind. Transactions happened and were never recorded.
• Clean-up means the books are wrong. Transactions were recorded badly: duplicated, miscoded, matched to the wrong thing, or forced through a reconciliation.

Most rescue jobs are both, and clean-up is the expensive half. A blank eight months is quicker to complete than eight months someone has half-done.

Start with a paid diagnostic

Never quote a rescue from a conversation. Ask for adviser access to the ledger and sell a fixed-price diagnostic that answers these questions:

1. What is the last reliable date? The most recent point at which the ledger agreed to something outside it: filed annual accounts, or a filed VAT or GST return whose figures match the ledger.
2. How far is each bank and card account reconciled, and does the reconciled balance agree to the statement on that date?
3. Are bank statements complete for every account across the whole gap?
4. What is in suspense, clearing, and undeposited funds?
5. Which returns are overdue, for which periods, and are penalties already running?
6. What does payroll look like? Run outside the ledger, inside it, or not recorded at all?
7. How many transactions and documents are in the gap, per month?
8. Who changed what? Look at the ledger’s change history for edits to reconciled periods.

On the last question the ledgers differ. QuickBooks Online’s audit log records sign-ins, settings changes, and edits and deletions of transactions, cannot be switched off, and keeps events for two years ^[1] . Xero’s History and notes report shows changes to transactions by date and user, is open only to administrators, and returns up to 1,000 results per search ^[2] .

The output is a one-page findings memo: the last reliable date, the list of problems, the approach, and a price. The client pays for the diagnostic whether or not they go ahead.

Repair or restart

A restart is less drastic than it sounds. In Xero you choose a conversion date and enter each account’s balance as at the day before it, from a trial balance; the balances can be keyed, imported with the chart of accounts, or handled by a conversion specialist ^[3] . The old file stays as an archive. Agree the restart with the client’s accountant, because the opening balances should be the closing balances of the last accounts they filed.

The order of work

1. Fix the starting point

Agree the opening position at the last reliable date and lock everything before it, so that nothing you do can disturb periods already filed. In Xero that is a lock date; in QuickBooks Online, Close the books with a closing date and password ^{[4] [5]} .

2. Get complete bank data

Collect statements for every bank, card, loan, and payment-processor account for the whole gap. Check continuity: each statement’s opening balance must equal the previous closing balance. A gap in the statements is a gap in the books, and no amount of coding will close it.

3. Work oldest month first, bank first

The bank statement is the one record that is complete and independent, so everything hangs from it. For each month in turn:

1. Reconcile every bank and card account to its statement. See the walkthroughs for Xero and QuickBooks Online.
2. Sales and receivables: every invoice raised, every receipt matched to its invoice, the aged listing agreed to the control account.
3. Purchases and payables: bills entered from documents, payments matched to bills, the aged listing agreed.
4. Payroll: the journal for each pay run, and liabilities agreed to what was paid to the tax authority.
5. Tax control accounts agreed to each return that was filed, or prepared for each return that was not.
6. Adjustments: accruals, prepayments, depreciation.
7. Review and lock the month.

Do not start month two until month one is locked. Working across all eight months at once feels faster and is how errors get fixed twice.

4. Undo what was forced

In a clean-up you will find reconciliations that were completed by accepting a difference, and reconciled transactions that were later changed. QuickBooks lists the causes of a beginning balance that is off: a wrong opening balance, a reconciled transaction that was edited, deleted, voided, moved, or unreconciled, a categorised bank transaction sent back to pending, or an old transaction reconciled manually ^[6] .

Where a past reconciliation cannot be trusted, undo it and redo it. In QuickBooks Online, undoing a whole reconciliation is done from History by account, and QuickBooks warns that it is irreversible and deletes the saved reports and attachments, so download them first ^[7] . Undo the latest month first and work backwards to the last good one, then reconcile forwards.

In Xero, prove each month with the Bank Reconciliation Summary: enter the real statement balance and check that the calculated balance is not out ^[8] .

Rules that keep it moving

• Use bank rules for anything that repeats. Rent, loan repayments, and bank charges across eight months are one rule each.
• Batch by supplier. Enter all of one supplier’s bills together; the pattern makes gaps and duplicates obvious.
• Never guess. Anything you cannot identify goes to a suspense account with a line on the query list. A plausible guess is harder to find later than an honest unknown.
• One query list a week. Send the client a single numbered list, with date, amount, and payee for each item, and a deadline.
• Keep a decisions log. Where you made a judgement, write down what and why. It becomes part of the file; see workpapers and audit trail.

When documents are missing

Old receipts are the first casualty of a backlog.

• Ask for duplicates. Suppliers reissue invoices, online accounts hold order histories, and banks reissue statements.
• Record from the bank regardless. The books must reconcile whether or not the document exists. Note that none is held.
• Be strict on input tax. VAT or GST generally cannot be reclaimed without the invoice the rules require. The country record-keeping guides set out what each authority accepts: UK, Australia, New Zealand, Canada, Singapore.
• Know the rule on estimates. In the UK, HMRC’s guidance is to get copies of as much as possible. Where figures cannot be confirmed, the return must say in its “Any other information” box whether figures are provisional (to be confirmed later) or estimated (cannot be confirmed), and interest and penalties may apply if they prove wrong ^[9] . Other authorities have their own positions.

Overdue returns

A backlog usually means late filings, and the client will want them gone first. Hold the line on order:

1. Get authority to act with the tax authority before anything else. The steps by country are in the client onboarding checklist.
2. Find out what the authority already knows: which returns are outstanding, what has been estimated or assessed, and what penalties have been charged.
3. File from reconciled figures only. A return prepared from an unreconciled month will need amending, which is a second problem on top of the first.
4. Work in period order, because each return’s figures depend on the one before.
5. Bring in the client’s accountant or tax adviser on penalties, payment arrangements, and any disclosure. Those are advice, not bookkeeping.

Deadlines and penalty regimes by country are in the tax deadline guides, for example UK tax deadlines and Australian tax deadlines.

Pricing the work

Catch-up is a project. Keep it out of the monthly fee.

• Diagnostic: fixed price, paid upfront.
• Backlog: quoted per month of arrears, banded by transaction volume, with clean-up of existing errors priced on top. Hourly billing is also defensible here, because the scope is uncertain by nature.
• Deposit before work starts, with the balance staged by months completed.
• Monthly service starts only when the backlog is locked.

More on building the numbers is in pricing bookkeeping services.

Handing over to business as usual

When the last backlog month is locked, the client is a normal client and should be onboarded as one: a document route, a calendar, a close date. Skip that step and the backlog returns within a year. The routine is the month-end close process.

Where ExpenseFlow fits

ExpenseFlow helps with one part of a rescue: the pile of documents. A backlog of bills and receipts can be uploaded in batches, forwarded to the client file’s email address, or pulled from Google Drive. Each document is read line by line and given an account and tax treatment, checked against the others for likely duplicates, and held in a review queue beside the original. After approval it syncs to Xero or QuickBooks Online. In Xero the image is attached to the transaction, so every bill entered during the catch-up carries its evidence.

It does not do the rest. ExpenseFlow does not reconcile bank accounts, undo reconciliations, correct entries that are already in the ledger, or file returns. Steps 1 to 4 above happen in the ledger.