Reconcile a Bank Statement Without Guessing
Compare the same account and date range, check opening and closing balances, and investigate transaction differences before changing any records.
By Keel · Everyday money ·
Free 7-day trial. No card required. Subscribe for $4.99/month to continue; no charge unless you subscribe.
Define the comparison precisely
Choose one account and a fixed statement period. Separate posted rows from pending activity and note which balance definition the bank uses. A budgeting summary of selected categories is not necessarily the same as every cash movement on a bank statement. Compare like with like before deciding that an apparent difference is a calculation error.
Check the balance equation
An invented opening balance of $600 plus $1,200 of posted inflows minus $1,450 of posted outflows produces a $350 closing balance. If the provider’s statement does not match your calculation, inspect missing rows, reversals, fees and the period boundary. Do not force the balance by deleting a similar-looking transaction.
| Component | Amount |
|---|---|
| Opening | $600 |
| Inflows | +$1,200 |
| Outflows | −$1,450 |
| Closing | $350 |
Investigate discrepancies one at a time
Compare date, description, amount, account identity and status. Two equal purchases can be legitimate; a pending authorization and a posted settlement may describe one purchase. Keep evidence and contact the provider through a verified channel about an unexplained charge. Official consumer guidance emphasizes reviewing account terms and unauthorized-activity concerns promptly rather than ignoring them.[1] [2]
Use Keel’s records in their proper scope
Review Transactions for bank and manual activity, and separate card activity in Accounts where the app provides it. Keep manual additions distinct from imported records so you do not add the same purchase again. Keel’s category views help with planning, but they are not a certified bank reconciliation service or a substitute for the provider’s statement.
Keep an unresolved list
Write down each unmatched item and its evidence instead of making several speculative edits at once. Recheck after pending activity settles and after any provider correction. Preserve the original record for comparison. A trustworthy reconciliation explains the difference; it does not merely produce the number you expected.
Footnotes and sources
U.S. consumer education. Sources checked . General education, not an individual financial or legal recommendation.