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 retainer payments in accounting?
Retainers are recorded as a liability when received, not as income. You only recognize revenue as you perform work against the retainer, moving money from the liability account to revenue over time.
Read answerHow do I set up classes and locations in QuickBooks?
Classes track types of work or departments. Locations track physical places. Enable both in QuickBooks settings under Advanced, but plan your structure before creating them.
Read answerShould my bookkeeper have industry experience?
Industry experience isn't strictly required, but it matters significantly for businesses with specialized needs. A bookkeeper who knows your industry already understands your chart of accounts, key metrics, and common compliance requirements.
Read answerWhat is TOT and how do I track it?
TOT stands for Transient Occupancy Tax. It's a local tax on short-term lodging that you collect from guests and remit to the city. In San Diego, the rate is 10.5% and you need to track it separately from your rental income.
Read answerHow do I transition from DIY bookkeeping to a professional?
Gather what you have, provide software access, and be honest about where things stand. You don't need to clean up your books first. A professional can sort through messy records faster than you can.
Read answerShould I hire an in-house bookkeeper or outsource?
Most small businesses don't generate enough bookkeeping work to justify a full-time hire. Outsourcing typically costs a fraction of an employee while providing broader expertise and consistent coverage.
Read answer