How do I reconcile bank statements from prior years?
Start with the oldest unreconciled period and work forward month by month. This matters because errors compound. A missing deposit in March throws off April, May, and every month after. If you start with December, you’ll chase discrepancies that originated months earlier and waste time adjusting entries that will change again once you fix the root cause.
Gather all bank statements for the periods you need to reconcile. Download them from your bank’s online portal or request copies if they’re beyond the typical online retention window. You’ll also need your accounting records for each period, specifically the general ledger detail for your bank account.
For each month, compare the ending balance on the bank statement to the ending balance in your books. The difference represents your total discrepancy. Then work through the components: deposits per the bank versus deposits per your books, withdrawals and checks per the bank versus what you recorded.
Common issues you’ll find include transactions recorded in your books but not on the statement, or vice versa. Some are timing differences that resolved themselves in subsequent months. Others are genuine errors like duplicate entries, transactions recorded to the wrong account, or expenses that were never recorded at all.
Make a list of every discrepancy before you start entering adjustments. You need to understand the full picture before changing anything. Some apparent errors offset each other. Others require research to determine whether the bank or your books were correct.
When you find transactions on the bank statement that aren’t in your books, add them with the original transaction date. When you find transactions in your books that don’t belong, void or delete them. When amounts differ, adjust to match the bank unless you have documentation showing the bank made an error.
After correcting a month, the reconciled balance should match the bank statement exactly. Then move to the next month. Each subsequent period should be easier because you’ve already corrected upstream errors.
If you’re years behind, consider whether full historical reconciliation is worth the effort. Sometimes drawing a line and starting fresh with a journal entry that forces the book balance to match the bank makes more practical sense. Premium business accounting in Boca Raton often involves making this judgment call based on materiality and how the records will be used going forward.
The harder question is what to do with discrepancies you can’t explain. If you’ve researched a $500 difference from 2021 and can’t determine the cause, you eventually need to write it off to an income or expense account and move on. Document what you know and what you tried.
This type of work falls under financial records cleanup and can be time-consuming depending on how many months need attention and how messy the records became. The goal is accurate, reconciled financials that you can trust going forward, even if the historical path to get there required some judgment calls.
Premium Controller & CFO Advisory Firm
Next Step:
Let's Talk About Your Business
Tell us about your business and your goals. We'll discuss how Jargo can support your financial operations and growth.
More Questions
How long does it take to clean up years of bad bookkeeping?
Timeline depends on how many years need work, transaction volume, and how messy the records are. A single year with moderate transactions might take a few weeks. Multiple years with high volume and poor documentation can take several months.
Read answerHow do I fix duplicate entries in my accounting software?
Run a transaction detail report sorted by amount and date to identify duplicates, then delete or void the extra entries. Reconciling accounts monthly prevents most duplicates from happening in the first place.
Read answerWhat business expenses can I deduct on my tax return?
Most costs that are ordinary and necessary for running your business are deductible. This includes rent, payroll, supplies, professional services, insurance, and many other operating costs. The key is proper documentation and correct categorization.
Read answerHow does pass-through taxation work for my LLC?
Pass-through taxation means your LLC doesn't pay federal income tax itself. Instead, profits and losses flow through to your personal tax return where you pay tax at your individual rate.
Read answerWhen should I hire a controller instead of a bookkeeper?
Hire a controller when you need financial oversight, not just data entry. If you're reviewing your own books for errors, making decisions without trusted numbers, or preparing for growth that requires better reporting, a controller adds the strategic layer bookkeeping alone can't provide.
Read answerHow do I determine nexus for sales tax purposes?
Nexus depends on your physical presence and economic activity in each state. Physical connections like employees or inventory create nexus, and so do sales above certain thresholds in most states since the 2018 Wayfair decision.
Read answer
