How do I reconcile old bank statements?
Reconciling old bank statements works the same as current ones, but you need to work chronologically and expect more detective work. Start with the oldest unreconciled month and move forward one period at a time. Don’t skip around or try to reconcile recent months first since each month builds on the previous one.
First, gather all the statements you need. Most banks let you download statements going back several years through online banking. If you can’t access them online, call the bank and request copies. You need the ending balance and full transaction list for each month.
In your accounting software, open the reconciliation window for the oldest unreconciled period. Enter the statement ending date and ending balance. The software will show transactions that are recorded but not yet cleared. Go through each item on your bank statement and check off the matching transaction in your books. When the difference between your book balance and bank balance reaches zero, that month is reconciled.
The problems start when things don’t match. Missing transactions are common with old statements because you’re trying to remember purchases from months ago. You’ll need to add these manually and categorize them correctly. Duplicates happen when transactions were entered by hand and also pulled in through a bank feed. You’ll need to delete the extras.
Unclear transactions are the hardest. A $247.83 charge from six months ago with a vague merchant name could be anything. Check email for receipts, search your card statements, or look for context clues in surrounding transactions. Sometimes you have to make your best guess and document it.
Work methodically through each month before moving to the next. Skipping months creates cumulative errors that compound and become nearly impossible to trace. A transaction you skip in March might be the reason April doesn’t balance.
If you’re more than three or four months behind, assess whether the task is worth your time. Catch-up bookkeeping services exist for exactly this situation. Sorting through a year of unreconciled transactions takes significant time and mental energy, and the frustration often isn’t worth it compared to having someone else bring your books current.
Once your accounts are reconciled and current, stay current. Reconcile monthly at minimum. At Fresh Ledger, we see the same pattern repeatedly. Someone falls a few months behind, the task feels overwhelming, and those few months turn into a year or more. Fifteen minutes of reconciliation monthly prevents hours of cleanup later.
The goal isn’t just matching numbers. Accurate historical records matter for tax preparation, loan applications, and understanding how your business actually performed. Unreconciled books hide problems like bank errors, fraudulent charges, or forgotten expenses. Regular reconciliation catches these while they’re still fixable.
San Diego's Small Business Bookkeeper
The Next Step:
A Short Conversation
A quick call to tell us about your business. We'll listen, answer your questions, and give you a clear price quote.
More Questions
When are California sales tax returns due?
California sales tax due dates depend on your filing frequency. Quarterly filers submit by the last day of the month following each quarter. Monthly filers submit by the last day of the following month.
Read answerWhat is nexus and how does it affect sales tax?
Nexus is the connection between your business and a state that triggers an obligation to collect sales tax there. You can establish nexus through physical presence or by exceeding economic thresholds based on sales volume.
Read answerWhat is the difference between a bookkeeper and a CPA?
Bookkeepers maintain your financial records throughout the year. CPAs are licensed professionals who prepare taxes and can represent you before the IRS. Most small businesses need both.
Read answerWhat documents do I need for bookkeeping cleanup?
Bank statements are essential. Credit card statements, prior tax returns, and existing bookkeeping records also help. You probably won't have everything perfectly organized, and that's okay.
Read answerWhat is a daily sales report?
A daily sales report is a summary of all revenue your business generated in a single day. It includes total sales, payment breakdowns, discounts, refunds, and tips to help you track cash flow and catch discrepancies quickly.
Read answerCan I switch bookkeepers mid-year?
Yes, you can switch bookkeepers anytime. Your books are your property. The transition is smoother than most business owners expect if you get the right files from your current bookkeeper.
Read answer