Reconciliation compares two records of the same account: the bank’s statement and your own transaction log. A difference does not automatically mean money is missing. Some transactions are recorded at different times; other differences come from fees, duplicates, or errors. The goal is to identify the cause, not force the totals to match with an unexplained entry.
A fully worked example
| Bank-side adjustment | Amount |
|---|---|
| Statement ending balance | $1,250 |
| Deposit recorded in ledger, not statement | +$100 |
| Payment recorded in ledger, not statement | −$200 |
| Adjusted bank balance | $1,150 |
| Ledger-side adjustment | Amount |
|---|---|
| Ledger ending balance | $1,180 |
| Bank fee on statement, missing from ledger | −$30 |
| Adjusted ledger balance | $1,150 |
Both adjusted records now show $1,150. The $100 deposit and $200 payment are timing items in this illustration, so they adjust the comparison rather than being recorded twice in your ledger. The $30 fee is a missing ledger transaction and needs an actual ledger entry. Keep those categories separate.
A repeatable reconciliation
- Use the same cutoff date for the statement and ledger. Save opening and closing balances.
- Match transactions by amount, date, and description, noting that a posting date can differ from the purchase date.
- List unmatched items individually. Separate legitimate timing items from missing or incorrect entries.
- Record confirmed bank charges and other omissions in the ledger once.
- Compare adjusted balances and investigate any residual difference without creating a balancing “miscellaneous” charge.
What not to assume about available cash
A reconciled historical balance is not necessarily today’s spendable balance. Pending debit card transactions, scheduled payments, holds, and deposits awaiting availability can change what you can safely use. Build a current cash-flow view after finishing the historical comparison. Avoid treating a pending deposit as cleared cash without checking the bank’s availability terms.
If a transaction is unfamiliar, contact the bank through its official channel promptly and follow its instructions. This worksheet does not decide whether a transaction is unauthorized or what deadline applies. Preserve records and do not publish account numbers when seeking help.
Leave an audit trail for yourself
Write the statement month, unmatched transaction list, adjustment explanation, and the date you checked whether timing items later cleared. A payment that remains unmatched in the next statement deserves another look. Repeating the same unknown item month after month hides a problem instead of resolving it.
Assumptions and limits
Test one deliberately wrong entry
Take the example’s $1,150 adjusted balance and deliberately omit the $30 fee from the ledger adjustment. The ledger remains $1,180, leaving a $30 difference. Adding a miscellaneous $30 adjustment would hide the cause; recording the actual fee explains it. Now try reversing the sign on the outstanding $200 payment. You would overstate the adjusted bank balance by $400 relative to subtracting it correctly.
Use the downloadable worksheet to mark each item as a timing difference or a missing ledger entry. Keep the statement cutoff fixed while comparing both sides. Then review the next statement to see whether the timing items actually cleared. A repeated unresolved item is a question to investigate, not a permanent adjustment to copy forward.
Use the worksheet
Download the blank CSV and fill it in privately in a spreadsheet app. It is an organizational template; it contains no automatic formulas. Use account nicknames, not account numbers. Do not upload the completed file to this website.
Download this guide’s worksheet (CSV) · Browse all worksheets
Suggested fields: Statement cutoff, Transaction nickname, Amount, In statement, In ledger, Timing or missing entry, Correction, Cleared later.
