Bookkeeping
Months behind on reconciliations? A step-by-step cleanup plan
November 18, 2026 · 10 min read

Quick answer
Start with the oldest unreconciled month and work forward one month at a time, every account for that month before moving on. Before you reconcile anything, gather every statement and prove the opening balance matches the last statement you trust. Clear holding accounts and tie out payroll and sales tax as you go, then lock each month once it's done. How long it takes depends far more on transaction volume, missing statements and how wrong the starting point is than on the number of months.
You meant to reconcile in April. Then a big project landed, then summer, and now it's November and the last month anyone tied the bank to the books was March. Your CPA will want the year's numbers in a couple of months. And every time you open the bank feed there are a few hundred more transactions waiting.
This is one of the most common situations in small business bookkeeping, and it's very fixable. The trick is doing the work in the right order. Jump straight into categorizing the newest transactions and you'll spend weeks redoing work when an older error surfaces.
Here's the plan we'd follow: what to gather, the order of work, a worked example of a seven-month cleanup, and an honest look at what makes one take two weeks and another take two months.
Oldest first
Reconcile month by month from the last balance you trust
Every account
Bank, cards, loans and payment processors, each to a zero difference
March 15, 2027
When calendar-year S corp and partnership returns for 2026 are due
Is this a catch-up or a cleanup?
It matters, because the work is different. A catch-up means the books are simply behind: transactions are missing, but what was recorded is right. A cleanup means what's already there is wrong: duplicates, wrong categories, a bad opening balance, reconciliations someone forced to match.
Most "we're months behind" files turn out to be a bit of both. A quick test: if the last reconciled month still matches its bank statement today, you have a catch-up from that point. If even the old reconciled months no longer tie, you have a cleanup, and you start further back. Our post on catch-up vs cleanup bookkeeping goes deeper on the difference.
Step 1: Gather every statement before you touch the books
Don't reconcile from the bank feed. Feeds drop transactions, duplicate them, and can't tell you the official month-end balance. You need the actual statements.
Statements (PDF, every month you're behind plus the last good one)
- Every business checking and savings account
- Every business credit card, including cards that were closed during the year
- Loan and line of credit statements showing principal and interest
- Payment processors: Stripe, Square, PayPal, Shopify Payments payout reports
Payroll and tax
- Payroll provider registers and tax payment reports for each quarter
- Copies of each Form 941 and state payroll filing
- Sales tax returns filed and payment confirmations
Supporting detail
- Invoices sent and the accounts receivable list
- Supplier bills, especially unpaid ones
- Receipts for any card spending over a few hundred dollars
- A list of owner transfers in and out, and any personal spending on business cards
Missing statements are the single biggest source of delay in a cleanup. Request them all on day one. Banks can usually produce old statements quickly; processors and lenders sometimes take longer.
Step 2: Prove the opening balance
Find the last month where the books and the bank genuinely agreed. Then check that the ending balance for that month in your software matches that statement exactly. If it doesn't, the opening balance is wrong, and every month after it will be off by the same amount no matter how carefully you reconcile.
Intuit's help notes that a first reconciliation that won't balance is often caused by an incorrect opening balance, and that someone editing or adding transactions dated before the last reconciliation is another common cause. So before going forward, look for anything dated in the "good" months that was changed afterwards. In QuickBooks Online, the reconciliation discrepancy report shows these; in Xero, the account history and audit trail help.
If no month ever genuinely reconciled, pick a starting point (often the start of the fiscal year) and set the opening balance to that statement, with your accountant's agreement. Write down what you did and why.
Step 3: Reconcile month by month, oldest first
Now work forward. For each month, in this order:
- Bank and savings accounts. Match every statement line to a transaction in the books. Add what's missing, delete true duplicates (check the statement first), and fix dates.
- Credit cards. Same process. Watch for payments to the card recorded as an expense instead of a transfer.
- Payment processors. Record gross sales, fees and refunds separately, then reconcile the processor balance like a bank account.
- Loans. Split each payment into interest and principal and tie the balance to the lender.
- Holding accounts. Clear Undeposited Funds, Uncategorized and Ask My Accountant for the month.
Finish every account for April before you start May. It's tempting to run each account all the way through October, but then a fix to a transfer in June means reopening two accounts you thought were done.
The first month or two are always the slowest, while you set up bank rules and find the patterns behind the errors. Later months go much faster.
Step 4: Tie out payroll and sales tax as you go
Each time you finish a quarter, stop and check the liabilities:
- Payroll. Gross wages and employer taxes on the P&L should match the payroll provider's quarterly reports and the Form 941 filed. Payroll tax payable should be near zero after each tax payment.
- Sales tax. The liability should equal tax collected since the last payment. If it doesn't, find out before the next return is due.
These are the checks with real money attached. A reconciled bank account with a payroll liability that never clears can still mean a missed deposit with penalties growing.
Step 5: Review, then lock each month
When a month's accounts all reconcile, look at that month's P&L and balance sheet next to the month before. Does revenue look like your actual sales? Are rent and payroll where you'd expect? Any expense line that's double or zero is worth five minutes.
Then lock it. QuickBooks Online lets you set a closing date with a password, and Xero has lock dates. Locking stops a stray bank rule or a well-meaning edit from changing a month you've already fixed. Move the lock date forward as each month is finished.
A worked example: a seven-month cleanup
Say you run a six-person marketing agency. The books were last reconciled through March. It's now mid-November, so April through October (seven months) need work, across one checking account, one savings account, one credit card and Stripe. About 180 transactions a month, mostly card spending and Stripe payouts.
Here's what the hours could look like, month by month:
Cleanup hours by month, oldest first
A hypothetical six-person agency, seven months behind, four accounts
Hypothetical example. Total 45 hours. April is slowest because it includes fixing the opening balance and setting up bank rules.
Show the numbers
| Hours to reconcile and review | |
|---|---|
| Apr | 10 |
| May | 8 |
| Jun | 7 |
| Jul | 6 |
| Aug | 5 |
| Sep | 5 |
| Oct | 4 |
That's 45 hours in total. April takes 10 because it includes proving the March balance and setting up rules for recurring vendors. By October, most transactions match automatically and the month takes four.
Spread across five weeks of part-time work, the timeline looks like this:
Week 1
Gather and prove the start
Request every statement and payroll report. Confirm March still ties to its bank statement.
Week 2
April and May
Reconcile all four accounts for each month. Build bank rules for recurring vendors.
Week 3
June and the Q2 tie-out
Finish June, then tie payroll to the second-quarter Form 941. Lock April through June.
Week 4
July to September
Faster now that rules do most of the matching. Tie out Q3 payroll and sales tax.
Week 5
October, review and lock
Reconcile October, review the year to date P&L by month, lock through October.
Then
Stay current
Close November by early December, on a normal month-end routine.
How long does a cleanup take?
It depends on specific things. The number of months is a weaker predictor than you'd think. Seven quiet months can take less time than three busy ones.
| What drives the time | Faster | Slower |
|---|---|---|
| Transactions per month | A few dozen | Hundreds, or thousands from a processor |
| Statements | All available as PDFs | Missing months, closed accounts, slow lenders |
| Starting point | Last reconciled month still ties | Opening balance wrong or never set |
| What's already in the books | Just missing items | Duplicates, forced reconciliations, wrong categories |
| Payroll and sales tax | Provider files and pays, liabilities clear | Manual payments, multiple states, notices |
| Inventory or job costing | None | Counts or job reports to rebuild |
| Owner availability | Answers questions within a day | Questions sit for a week |
The last row matters more than people expect. Every cleanup produces a list of "what was this?" questions. If they're answered quickly, the work flows. If not, it stalls.
Common cleanup mistakes
Starting with the newest month. It feels urgent, but any fix to an earlier month changes the opening balance of every month after it, so you redo the work.
Reconciling to the bank feed instead of the statement. The feed is a convenience, not proof. Use the statement's ending balance.
Forcing a reconciliation to finish. QuickBooks and Xero will let you post an adjustment to make a stubborn reconciliation "balance." That adjustment hides a real error and usually distorts expenses.
Changing months your CPA already used. If a return was filed from those numbers, ask your CPA before changing them. The fix may belong in the current period.
Fixing everything and then not closing the next month. A cleanup without a monthly routine afterwards just resets the clock. Put a month-end close checklist in place the same month the cleanup finishes.
Should you do the cleanup yourself?
If you're two or three months behind, have one or two accounts and the last reconciled month still ties, doing it yourself is reasonable. Block out the time, follow the order above, and don't skip the opening balance check.
Get help if you're six months or more behind with several accounts, if the opening balance is in doubt, if payroll or sales tax doesn't tie, or if a tax deadline or loan application is close. At that point the hours you'd spend learning the fixes usually cost more than handing it over.
Fintrix Consulting handles catch-up and cleanup work in QuickBooks Online and Xero, priced separately from monthly bookkeeping, and then keeps the books current with a close by the 10th of each month. If you're not sure how deep your cleanup goes, book a free call and we can talk it through.
Frequently asked questions
What if I can't get an old statement?
Ask the bank, card issuer or processor first; most can produce old statements. If one really is unavailable, reconcile through the gap using the next statement's opening balance and write down what you did. Tell your CPA.
Can I just start fresh from today and ignore the old months?
Not if you need a tax return for those months, which you almost certainly do. The year's numbers have to be complete. You can sometimes simplify the older months, but they still need to reconcile.
How do I stop falling behind again?
Reconcile every month by a fixed date, lock each month after review, and keep the holding accounts at zero. A short monthly routine is far cheaper than a cleanup.
Do I need to fix last year too?
Only if last year's closing balances don't tie to statements, or don't match what your CPA used for the return. Check that first, before starting this year.
The bottom line
A reconciliation backlog looks overwhelming, but the method is simple: gather every statement, prove the starting balance, then work forward one month at a time, every account, tying out payroll and sales tax at each quarter and locking each month when it's done. How long it takes depends on volume, missing paperwork and how wrong the starting point is. Whatever the size, finish with a monthly routine, or you'll be back here next year.
Sources
This article is general information, not advice for your situation. Rules change and details matter, so talk to us or your CPA before acting on it.
More articles
- Journal entries and adjusting entries, with examples
November 19, 2026
- Reconciling accounts payable before year-end
November 19, 2026
- Bookkeeping automations worth setting up first
November 19, 2026
Have a question about this article?
Ask us. A real person will reply by email within one business day. Your question isn’t published.
Ready for books you can trust?
Book a free 30-minute consultation. We'll review where your finances stand today and show you exactly how we'd help.