Catch up bank reconciliation for months of missed statements
Three, six or twelve months behind on the bank rec? Upload each statement and one export of your books. BankReconciler reconciles the months in order, carries open items forward and gives you a signed report for every period.
No bank login. Works with QuickBooks, Xero, NetSuite and Excel.
Try one month now. Files encrypted, demo files deleted after 24 hours.
Start the catch upThe short answer
To catch up on bank reconciliations, reconcile the oldest missing month first and work forward, one statement at a time, so each month closes against its own ending balance. Software that matches the statement to your ledger export turns hours of ticking per month into minutes of review.
- Statement formats
- 7
- PDF, CSV, XLSX, OFX, QBO, MT940, CAMT.053
- Matching passes
- 6
- Exact, date window, one to many, check numbers
- Reports
- 1 per month
- PDF and XLSX, preparer and timestamp
Why catch up reconciliation takes so long by hand
Months pile up
A busy checking account has 150 to 400 lines a month. Twelve months behind means thousands of lines to tick against the books.
Errors carry forward
A wrong balance in March is still wrong in December. Every month inherits the open items and mistakes of the one before it.
Feeds have gaps
A bank feed that disconnected for weeks, or imported the same day twice, leaves missing and duplicate lines that the reconcile screen will not point out.
PDF only history
Older periods often exist only as PDF statements. By hand, that means reading each page and comparing it line by line on a second screen.
How to catch up on bank reconciliations with BankReconciler
-
1 Collect every missing statement
Start from the last month that was properly reconciled and download every statement after it. Online banking usually keeps a year or more of statements as PDF downloads. For older months, request copies from the bank early, since they can take a week or two to arrive.
-
2 Export the books for the whole period
One export of the bank account covers every month. In QuickBooks use Transaction Detail by Account, in Xero the Account Transactions report, in NetSuite a saved search on the cash account. A spreadsheet ledger works as it is.
-
3 Reconcile the oldest month first
Before any matching starts, the statement opening balance, movements and closing balance are checked to add up, and you compare the opening balance with last month's reconciled balance, so an old gap shows up at once instead of in month nine. Six matching passes pair the lines and leave you only the exceptions.
-
4 Carry open items forward and repeat
Outstanding checks and deposits in transit move into the next month on their own. Each month closes with suggested adjusting entries for fees, interest and returned checks, which you download as CSV for your ledger.
See every month of the backlog at a glance
The period status board marks each account and month as not started, in progress, reconciled or with differences. On a catch up project that is the to do list, and it is also what you show the client or the lender when they ask how far along you are.
Bookkeepers running cleanup work for several clients get a workspace per client on the Business and Firm plans. More on that in bank reconciliation for accountants.
Period status
2026
| Client | Jan | Feb | Mar | Apr |
|---|---|---|---|---|
| Harbor Dental | ||||
| Oak and Pine Studio | ||||
| Northline Freight | ||||
| Meridian Cafe | ||||
| Larkspur Clinic |
- Reconciled
- In progress
- With differences
- Not started
Who uses catch up bank reconciliation
Tax deadline
Owners filing late or on extension
Your CPA will not prepare a return from unreconciled books. Getting the bank accounts tied out is usually the first thing they ask for.
Financing
Loan and line of credit applications
Lenders compare your financials with your bank statements. A reconciliation report per month answers that question before it is asked.
Cleanup work
Bookkeepers taking over a messy file
A new client who has not reconciled since spring is a fixed fee project. The faster the matching, the better that fee pays.
Migration
Before switching accounting software
Moving to QuickBooks Online or Xero goes cleanly only when the opening balances are right. Reconcile the old file first.
Review
Year end review or audit
Reviewers want a reconciliation for every month, not just December. Each closed period gets its own PDF and XLSX report.
Turnover
After a bookkeeper leaves
When the person who knew the books is gone, the statements are the only reliable record. Rebuild from them month by month.
Three ways to clear a reconciliation backlog
| Approach | Time per busy account month | PDF statements | Report per month | Best when |
|---|---|---|---|---|
| Reconcile screen in your ledger, by hand | 1 to 3 hours | Read and tick by hand | Basic summary | One or two months behind on a quiet account |
| Hire a catch up bookkeeper | Their hours, billed at 50 to 150 USD an hour | Handled for you | Depends on the provider | The whole ledger needs rebuilding, not only the bank |
| BankReconciler | Minutes of review after matching | Read for you, scans on paid plans | PDF and XLSX with preparer and timestamp | The entries exist, but months were never reconciled |
If the books themselves are missing, with no entries for months, a bookkeeper has to post them first. If the entries are there and only the reconciliations were skipped, software does the heavy part. For a breakdown of what each route costs, read catch up bookkeeping cost, and see the plans on pricing.
Catch up bank reconciliation questions
How do I catch up on bank reconciliations?
Start with the oldest unreconciled statement and work forward one month at a time. Confirm the opening balance matches the last reconciled balance, match every line, record bank fees and interest, and carry outstanding checks and deposits in transit into the next month. Jumping between months is how duplicates and missed items creep in.
Can you reconcile multiple months at once?
You can load several months in one session, but each month should still close against its own statement ending balance. Lumping a year into one reconciliation hides where a difference started. BankReconciler takes one statement per month and one ledger export for the whole period, then works through the months in order.
How long does catch up bookkeeping take?
For the bank reconciliation part, most of the time goes into collecting statements. Once the files are in, matching a month of a busy checking account takes minutes instead of one to three hours by hand, so a year of one account fits into an afternoon of review. Posting missing entries is extra work on top.
What if the opening balance does not match the last reconciliation?
Something changed in a period that was already closed, usually an edited, deleted or backdated entry. Fix that first, because every later month inherits it. In QuickBooks Online the reconciliation discrepancy report shows what changed, and our guide to undoing a reconciliation in QuickBooks Online covers reopening a bad month.
Do I need to give you my bank login?
No. You upload the statements your bank already gives you, as PDF, CSV, XLSX, OFX, QBO, MT940 or CAMT.053. There is no bank connection to approve. Every format is listed on supported formats.
Get the backlog reconciled this week
Start with the oldest month. Upload the statement and your ledger export.