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
How do I handle change orders in my accounting?
Track change orders separately from your original contract. Each change order needs its own cost codes so you can see profitability on the original scope versus additional work.
Read answerHow do I set up sales tax in QuickBooks?
Start by getting your California seller's permit, then enable the sales tax feature in QuickBooks Online and configure your business address. QuickBooks will calculate district-level rates automatically based on customer locations.
Read answerHow do I fix errors in QuickBooks?
The fix depends on the type of error. Duplicate transactions get deleted. Wrong categories get edited. Incorrect amounts get corrected on the original transaction. Missing entries get added back.
Read answerHow do I read a balance sheet?
A balance sheet shows what your business owns, what it owes, and what's left for you as the owner. The three sections always follow the equation Assets = Liabilities + Equity.
Read answerCan I use QuickBooks for job costing?
Yes, QuickBooks Online handles job costing through its Projects feature. The software tracks costs and revenue by job, but proper setup determines whether your reports actually show project profitability.
Read answerWhat qualifications should a bookkeeper have?
Formal certification isn't required for bookkeepers, but software proficiency, attention to detail, and industry experience matter most. The right qualifications depend on your business needs and how well the bookkeeper understands your specific situation.
Read answer