π¦ Bank Reconciliation Calculator
Book balance vs bank balance, reconciled.
True cash balance both sides should reach
Estimates for planning only, not financial advice.
A bank reconciliation proves your books and the bank agree by adjusting both sides for timing and missed items. Start with a $12,450 book balance: add $12 of interest, subtract a $92 bank fee and a $200 NSF check, and the adjusted book balance is $12,170. Start with the $13,020 bank balance: add $2,300 of deposits in transit, subtract $3,150 of outstanding checks, and the adjusted bank balance is $12,170. Both sides land on $12,170, so the books are right and the cash is real.
How to Use This Calculator
Enter the unadjusted book and bank balances, then the reconciling items: deposits in transit and outstanding checks adjust the bank side; interest, fees, NSF checks, and error corrections adjust the book side. The calculator shows both adjusted balances and whether they match, plus the journal entries the book side needs.
Enter the book balance from your accounting and the ending balance from the bank statement.
Enter deposits in transit and outstanding checks (bank side), then interest, fees, NSF checks, and any book errors (book side).
Check the match. If the sides differ, the difference amount usually names the culprit: hunt it with the error tricks below. Book the book-side adjustments as journal entries so next month starts clean.
The Reconciliation Format
The two sides adjust for different reasons. The book side fixes things you did not know: the bank charged a fee, paid you interest, or bounced a customer's check, all without telling your books until the statement arrived. The bank side fixes timing: your deposit and your checks exist in your books but have not hit the bank's processing yet. Errors can land on either side, which is why the format keeps them separate.
Worked Example: $12,170 Both Sides
Book side: $12,450 + $12 interest - $92 fee - $200 NSF = $12,170. Bank side: $13,020 + $2,300 deposits in transit - $3,150 outstanding checks = $12,170. Match. The journal entries to book: debit cash $12 and credit interest income $12; debit bank fees $92 and credit cash $92; debit accounts receivable $200 and credit cash $200 (the NSF goes back on the customer's tab).
Now suppose the bank side came to $12,260 instead, a $90 difference. Suspects: a $90 fee never entered, or a transposition (difference divisible by 9: 90 / 9 = 10, whole number, so check for swapped digits like $540 vs $450). The difference-first approach beats re-checking everything: let the number interrogate the suspects.
Common Reconciling Items
| Item | Side | Action |
|---|---|---|
| Deposits in transit | Bank: add | Verify they clear next statement |
| Outstanding checks | Bank: subtract | Follow up if older than 90 days |
| Bank fees | Book: subtract | Journal entry; review fee schedule |
| Interest earned | Book: add | Journal entry |
| NSF checks | Book: subtract | Re-bill customer + fees |
| Book errors | Book: correct | Fix and note the cause |
Making Reconciliation a Control, Not a Chore
The reconciliation's real job is fraud and error detection, which only works with two disciplines: the person reconciling should not be the person writing checks or recording deposits (segregation of duties), and old outstanding items must be investigated, not carried forward forever. A deposit in transit that never clears was never a deposit; an outstanding check from 8 months ago needs voiding and reissue.
Do it monthly without fail, the week the statement arrives, and keep the signed-off recs filed: lenders and auditors ask for them, and a clean history is worth real money in a financing or sale process. For businesses, pair the discipline with solid invoicing hygiene, since most NSF and dispute items start as sloppy billing. Our invoice generator keeps the billing side clean, and the AR days calculator tracks whether customers actually pay what the reconciled cash says they should.
Reconciliation Red Flags
The monthly reconciliation is also a fraud and error detector if you read it that way. Stale outstanding checks older than six months may indicate unclaimed property obligations or checks that were never received. Deposits in transit that never clear suggest recording errors or, worse, deposits that never happened. Round-number adjustments and journal entries posted directly to cash without support deserve a second look every time.
Bank errors are rare but real: double-posted deposits, misread check amounts, and fees that contradict the account agreement all surface in reconciliation. The discipline is resolving every reconciling item, not just the balance: an item that rolls forward month after month is a problem being ignored, not a timing difference. In multi-account businesses, reconcile every account including payroll and merchant accounts; fraudsters count on the accounts nobody checks.
Estimates for planning only, not financial advice.
Frequently Asked Questions
What is a bank reconciliation?
A bank reconciliation proves your book balance and the bank statement agree after timing differences: deposits in transit, outstanding checks, bank fees, and errors. A book balance of $12,450 with $12 of interest, a $92 bank fee, and a $200 NSF check adjusts to $12,170; a bank balance of $13,020 with $2,300 in transit and $3,150 outstanding also adjusts to $12,170. Both sides matching is the proof.
How do you do a bank reconciliation step by step?
Start with the book balance: add interest earned and collections, subtract fees, NSF checks, and errors. Start with the bank balance: add deposits in transit, subtract outstanding checks, adjust for bank errors. The two adjusted balances must match. If they do not, the difference is an error or a missed item on one side.
What are deposits in transit?
Deposits you recorded but the bank has not processed yet: a check dropped in the night depository on the 31st, or an ACH that posts the next business day. They are added to the bank balance in the reconciliation because the money is legitimately yours, just not yet on the statement.
What are outstanding checks?
Checks you wrote and recorded that recipients have not cashed yet. They are subtracted from the bank balance because the bank still shows the money as yours while your books correctly show it as spent. Old outstanding checks (6-plus months) may need to be voided and reissued; stale checks can escheat to the state.
Why does my book balance never match the bank?
The top culprits in order: bank fees and interest you never recorded, NSF checks from customers, deposits in transit, outstanding checks, data-entry errors (transposed digits are classic), and duplicate entries. Work the list systematically: the difference often reveals the cause (a $90 difference with a $92 fee and $2 interest is not a coincidence).
How often should bank recs be done?
Monthly, for every account, as soon as the statement arrives. Businesses with high volume or fraud concerns reconcile weekly or even daily for disbursement accounts. A reconciliation older than 45 days is where errors go to hide and fraud goes to grow.
What is the point if accounting software auto-reconciles?
Software matches what it can; judgment handles the rest. Auto-rec still needs a human to investigate unmatched items, confirm the outstanding list is real, and sign off. The control value of a reconciliation, an independent check that the money is where the books say, disappears if nobody reviews it.
How do NSF checks affect the reconciliation?
The bank deducts the bounced check from your balance, so you subtract it from the book balance too, then chase the customer for payment plus your bank's NSF fee. Repeat NSF offenders get cash-only terms. In the reconciliation it is a book-side adjustment: the bank already removed the money.
What are common bank reconciliation errors?
Transposed digits ($540 entered as $450, difference divisible by 9), missing bank fees, recording a deposit twice, outstanding checks that actually cleared, and prior-period adjustments carried forward wrong. The divisible-by-9 trick catches transpositions fast: divide the difference by 9, and a whole number means digits were swapped somewhere.
Do I need to reconcile credit cards too?
Yes, same concept: match the card statement to your books, catching missed charges, duplicate charges, and fraud. Unreconciled cards are where subscription creep and phantom charges live. Monthly, same discipline as the bank accounts.