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
What payroll taxes do I need to pay in California?
California employers pay four state-specific payroll taxes on top of federal requirements. Unemployment Insurance and Employment Training Tax come from your pocket, while SDI and Personal Income Tax get withheld from employees.
Read answerHow do I set up payroll for my small business?
Start with an EIN from the IRS, then register with your state's tax and employment agencies. You'll need to set up withholding calculations, choose a payroll system, and establish a schedule for tax deposits and filings.
Read answerWhen 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 answerMy books are a mess—where do I start?
Start by gathering your bank and credit card statements for the period you need to clean up. Bank reconciliation comes first because it establishes what actually happened. From there, you can categorize transactions and work toward usable financial statements.
Read answerHow do I track profitability by client?
Client profitability requires tracking both revenue and costs by client. For service businesses, this means time tracking combined with accounting software configured to assign income and expenses to each client.
Read answerDo I need to collect sales tax on services?
In California, most services aren't subject to sales tax. However, services that produce tangible goods or are bundled with materials can become taxable. The distinction matters for contractors, fabricators, and businesses that combine products with service.
Read answer