How to catch up on 12 months of bookkeeping without losing your mind

Almost every client who calls us about catch-up work opens with some version of the same apology. They are embarrassed. They shouldn't be. In our experience the businesses that fall behind on bookkeeping are rarely the failing ones — they are the ones that grew faster than their admin, took on staff, moved premises, or spent eighteen months doing the work that actually generates revenue.

The problem is real, though. A year of unreconciled books means you cannot file accurately, you cannot borrow, you cannot value the business, and you genuinely do not know whether last quarter was profitable. So let's fix it.

The mistake almost everyone makes first

The instinct is to open the accounting software, look at the mountain of uncategorised transactions, and start clicking through them newest-first. It feels productive. It is almost always wrong.

Working newest-first means you are categorising transactions against balances you have not proven. If your opening bank balance in January was wrong — and in a neglected file it usually is — then every reconciliation you perform on top of it inherits that error. You will spend forty hours producing a file that looks finished and reconciles to nothing.

A backlog is rebuilt in the same direction time runs: oldest month first, each month closed and proven before the next one opens.

Step 1: Diagnose before you touch anything

Before a single transaction is categorised, establish four facts:

• The last date the books were genuinely correct. Not the last date someone logged in — the last date a bank reconciliation actually balanced. This is your starting line.
• Which accounts exist. Every bank account, credit card, loan, PayPal, Stripe, Wise and merchant account. Businesses routinely forget one, and a forgotten account is a permanent hole in the books.
• What source documents you can still get. More on this below — it is the single biggest constraint on how long the job takes.
• Whether there are prior-year filings to stay consistent with. If accounts were filed based on certain numbers, you cannot silently restate them without telling your accountant.

This diagnostic takes an hour or two and saves days. It is also the point where you find out the job is bigger or smaller than you feared, which matters if you are getting it quoted.

Step 2: Solve the bank statement problem early

Here is the constraint nobody warns you about. Automated bank feeds typically only pull 90 days of history when you first connect them — and some pull as little as 30. If you are twelve months behind, roughly nine of those months cannot be imported by just connecting the feed.

Your options, in order of preference:

1. Download CSV or OFX/QBO files from online banking. Most banks let you export two years or more. This is by far the cleanest route and should be your first attempt for every account.
2. Request statements from the bank. Slower, sometimes chargeable, but reliable. Start this on day one because it can take a week or two to arrive.
3. PDF statements converted to CSV. Workable, but conversion introduces errors and every converted line needs checking against the PDF. Treat as a fallback.
4. Manual entry from paper. The last resort, and the reason old backlogs cost what they cost.

Step 3: Prove the opening balance

Take the last date your books were genuinely correct. Every balance sheet account at that date — bank, cards, loans, debtors, creditors, VAT or sales tax control — needs a number you can support with a document.

If you cannot prove an opening balance, say so explicitly rather than guessing. Post the difference to a clearly labelled suspense account, document what you know about it, and flag it for your accountant. A documented unknown is a manageable problem. An undocumented guess buried in retained earnings is a landmine that detonates three years later during due diligence.

Step 4: Rebuild month by month, oldest first

For each month, in order, the sequence is always the same:

1. Import that month's transactions for every account.
2. Categorise them, using the chart of accounts you have agreed — not inventing new categories as you go.
3. Match receipts and invoices to transactions where you have them.
4. Reconcile every account to the statement closing balance.
5. Lock the period. Both QuickBooks Online and Xero let you set a lock date. Use it. This prevents the deeply demoralising experience of a "finished" month silently changing while you work on month seven.

Do not move to the next month until the current one reconciles exactly. Not approximately. Exactly. A £12 difference you promise to look at later becomes, by month nine, a £12 difference you can no longer locate.

Step 5: Batch the decisions, not the data entry

The slowest part of catch-up work is rarely typing — it is deciding. What is this £340 payment to a name nobody recognises? Is this laptop an expense or an asset? Was this transfer a drawing or a loan repayment?

Keep a running list of these questions rather than stopping dead on each one. Categorise the transaction to a holding account, note the question, and keep moving. Then work through the whole list in one session with whoever knows the answers. One thirty-minute conversation resolves what would otherwise be forty separate interruptions.

This is also the single biggest reason catch-up work is faster with a bookkeeper than alone: we have seen these patterns before and can usually identify a mystery vendor from the payment reference and amount without asking you at all.

Step 6: Fix the history, don't just add to it

If a previous bookkeeper coded things inconsistently — and in a neglected file this is near-universal — simply continuing their pattern makes your reports useless for comparison. Common examples we find constantly:

• Owner drawings posted to an expense account, inflating costs and hiding real profit.
• Equipment purchases expensed instead of capitalised, distorting a single month badly.
• Loan repayments posted entirely to expense, so principal never reduces on the balance sheet.
• Transfers between own accounts recorded as income and expense, inflating both.
• The same supplier under four spellings, so nobody can see what they actually cost you.

Fix these as you pass through each month. It costs very little extra while you are already in there, and it is what makes the difference between books that are current and books that are correct.

Step 7: Know when you are actually finished

The catch-up is complete when all of the following are true:

• Every bank, card and loan account reconciles to the statement for every month.
• The suspense account is empty, or its contents are documented and accepted.
• Debtor and creditor listings agree to the balance sheet control accounts.
• Every balance sheet line has a schedule behind it that explains what it is.
• Periods are locked so the closed months cannot drift.
• Your accountant has seen it and has no outstanding questions.

That last one matters more than people expect. Books are not finished when they look tidy to you; they are finished when the professional who has to file from them says so.

How long does it actually take?

For a typical small business with two or three accounts and moderate volume, budget roughly three to six hours per month of backlog if you are doing it yourself with reasonable software skills. Twelve months behind is therefore realistically a 36–72 hour project.

That number is the honest argument for outsourcing it. Not because you couldn't do it, but because 50 hours of your attention is almost certainly worth more deployed somewhere else — and because a specialist doing their fifteenth catch-up this year will be roughly three times faster and will find errors you would never think to look for.

Then never do it again

A backlog is a symptom, not a disease. Once you are current, the maintenance is genuinely small: connect live bank feeds, use a receipt-capture app so documents arrive automatically, set a fixed monthly close date, and lock each period once closed.

Most businesses that stay current spend under thirty minutes a month on bookkeeping admin. The year you just spent catching up was not caused by the work being hard. It was caused by there being no fixed date on which it had to be done.

---

Written by Pro Bookkeepers and reviewed by an ACCA-qualified accountant. General guidance only, not tax or accounting advice for your specific circumstances — talk to a professional who knows your business.