How to catch up on 12 months of behind books

If your books are twelve months behind, the fix is not "work harder on the books this weekend." It is a sequence, and the sequence matters more than the effort. Do the steps out of order and you will categorize transactions that a bank feed later duplicates, chase receipts for months you have not opened yet, and reconcile a period whose opening balance is still wrong.

The reason a year of backlog feels impossible is that it is not one job. It is roughly five jobs stacked on each other, each of which needs the previous one finished. Below is the order.

1. Find the last month you actually trust

Before anything else, establish your starting line. Open the books and look backwards for the most recent month where the bank reconciliation was completed and the balance matched the statement. That month is your foundation. Everything after it is the backlog.

Owners routinely guess wrong here. "We stopped in March" usually means the reconciliation quietly broke in the previous November and March is just when data entry stopped. If the opening balance of your first backlog month is wrong, every month you rebuild on top of it will also be wrong, and you will find out in month nine.

Write down three things: the last reconciled month, the closing balance the bank confirms for that month, and the list of accounts in scope: every checking account, savings account, credit card, loan, merchant processor and payment platform. Missing one account is the most common way a catch-up has to be redone.

2. Assess the damage before you fix any of it

Now scope the work. You are looking for the size and shape of the mess, not fixing it yet.

• How many months, and how many transactions per month on average?
• How many bank and card accounts, and do the feeds still connect?
• Is there uncategorized income sitting in an undeposited-funds or clearing account?
• Are there loans, lines of credit or owner draws that were never split between principal and interest?
• Is payroll in the books at all, or only in the payroll provider?
• Are there open AR and AP that nobody has aged in a year?
• Does the chart of accounts still describe the business, or is it the default list plus forty ad-hoc accounts?

This assessment is what turns "we're a year behind" into a number of hours. It is also what makes a fixed price possible: nobody can quote a cleanup honestly without it.

3. Gather every statement for the entire period first

This is the step people skip, and skipping it is what stretches a six-week cleanup into six months.

Pull, for every account in scope, every monthly statement covering the whole backlog period. PDFs, not just CSV exports: the PDF is the authority when a feed disagrees with reality. Add year-end loan statements, payroll registers and quarterly returns from the payroll provider, merchant processor monthly summaries showing gross sales and fees separately, and any 1099s issued or received.

Do all of this collection at once, in one push, before any categorizing starts. Bank portals commonly limit how far back statements go online, and requesting older ones can take days or a fee. You want to discover that at the beginning, not in the middle.

Then decide the documentation standard you will actually hold to. For a year of backlog, receipt-level substantiation for every small transaction is usually not realistic to reconstruct. Statement-level accuracy plus receipts for large or unusual items is. Set that rule at the start and apply it consistently, and note where you deviated so it is visible later.

4. Rebuild chronologically, and close each month as you go

Start with the oldest unreconciled month. Not the most recent one, even though the most recent is the one you need for a loan application or an investor. Rebuilding backwards means every correction you make invalidates work you already did.

For each month, in this order:

1. Import or enter all transactions for every account.
2. Clear duplicates: the same expense arriving from a bank feed and a manual entry is the single most common error in a backlog.
3. Categorize against a chart of accounts you fixed before you started, not one you are inventing as you go.
4. Split the mixed items: loan payments into principal and interest, merchant deposits into gross sales and processor fees, owner activity into draws or contributions rather than expense.
5. Record payroll from the payroll register, not from the net bank withdrawal.
6. Reconcile the month against the statement, to the cent.
7. Lock the period so nothing drifts back into it.

That last step is not optional. In an open period, later edits silently change a month you already reconciled, and you will not notice until the totals stop matching a report you already sent someone.

Expect the first two or three months to be slow and the rest to accelerate sharply. Most of the difficulty is decisions: how a recurring vendor should be coded, how the owner's card gets handled, what a clearing account is really holding. Once those are decided, the remaining months are execution.

5. Close the year, then hand it to your CPA

When every month reconciles, do a final pass across the whole period. Age AR and write off what will genuinely never be collected. Age AP and confirm nothing is double-recorded. Check the balance sheet for the accounts that quietly absorb mistakes: suspense, ask-my-accountant, undeposited funds, uncategorized income and expense. Those should be at zero or explainable in one sentence each. Review the P&L month over month and look for a line that jumps: usually that is a coding change partway through the year, not a real change in the business.

Then stop, and send it to your CPA. Late filings, amended returns, penalty exposure, how to treat something with a tax consequence: those are their call, not a bookkeeping decision, and not one to resolve from a blog post. What you owe them is clean, reconciled books. That is the part that makes their work cheap instead of expensive. Day-to-day books and year-end tax strategy are two different jobs.

What this actually costs you in time

Rough arithmetic, so you can decide whether to do it yourself. A single-entity business with three accounts and 200 transactions a month has roughly 2,400 transactions in a year of backlog. Even at a brisk two seconds per transaction for clean categorization, you are at well over an hour of pure data handling per month of backlog, before duplicates, before splits, before reconciliation breaks, before the two weeks of statement chasing. Realistically it is a few evenings per month of backlog for someone who knows the business, and considerably more for someone who does not.

Which is why a cleanup usually goes badly when it is squeezed between running the company and doing the current month's books. Every hour spent on last February is an hour not spent on this month, and this month keeps arriving.

If you would rather not spend that time, that is the shape of engagement we built The Books Cleanup Crew for: fixed scope, fixed price, up to twelve months of backlog, quoted after the assessment in step two. The people who do it are degreed accountants and QuickBooks certified, working US business hours, and they run exactly the sequence above rather than starting with whatever is most visible. If the mess is ongoing rather than historical, ongoing support is a different engagement. See our service areas for how the two split.

Either way, the sequence does not change. Assess, gather, rebuild forward, reconcile each month, close, hand off. The only variable is who spends the hours.