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
What's the difference between a bookkeeper and a controller?
A bookkeeper handles day-to-day transaction entry and reconciliations. A controller provides financial oversight, reviews the bookkeeper's work, makes adjusting entries, and ensures accurate financial statements.
Read answerHow do I file taxes for a multi-member LLC?
By default, a multi-member LLC files as a partnership using Form 1065 and issues Schedule K-1 to each member. The LLC itself doesn't pay federal income tax, but the members report their share of profits on their personal returns.
Read answerWhat's the difference between a fractional CFO and a controller?
A controller ensures your financial records are accurate and your books are closed properly each month. A fractional CFO uses those accurate numbers to guide strategic decisions about growth, cash flow, and the future direction of your business.
Read answerWhen are Florida sales tax returns due?
Florida sales tax returns are due on the 1st of the month following the reporting period and become late after the 20th. Filing by the 20th gives you a collection allowance discount of up to 2.5%.
Read answerHow do I clean up undeposited funds in QuickBooks?
Start by running a report to see what's stuck in undeposited funds, then either create proper bank deposits for legitimate payments or delete duplicate entries. The account should match actual cash waiting to be deposited.
Read answerWhat financial analysis should a CFO provide monthly?
Monthly CFO analysis goes beyond reports to deliver actionable insight. Expect variance analysis, cash flow forecasting, KPI tracking, and strategic commentary that explains what happened and what to do about it.
Read answer
