Hong Life CalculatorsUnderstanding the bank reconciliation calculator — concept and principle
This calculator prepares a bank reconciliation: it adjusts the balance on your bank statement and the cash balance in your own books until both show the true cash figure. It reports the two adjusted balances, the difference (which should be zero) and the adjustment you need to record in your books. Bookkeepers, small-business owners and accounting students use it at month end.
How it is calculated
- Adjusted bank balance = statement balance + deposits in transit − outstanding checks ± bank errors
- Adjusted book balance = book balance + collections and interest credited by the bank − bank fees, NSF checks and charges ± book errors
- Difference = adjusted bank balance − adjusted book balance
- Adjustment to record = adjusted book balance − book balance
Enter bank and book errors with a sign: + if the error understated that side, − if it overstated it.
The principle
The bank and your books record the same cash, but at different times and with different information. A deposit you recorded today may reach the bank tomorrow; a check you wrote may not be cashed for weeks. These bank-side items clear by themselves. The bank also knows things you do not yet: interest earned, fees charged, a customer's check that bounced (NSF). Those book-side items, plus your own errors, need journal entries. When every item is accounted for, both adjusted balances are equal.
Worked example
Defaults: statement 77,040; deposits in transit 34,300; outstanding checks 19,620; bank error +320; book balance 32,760; collections 61,800; charges 2,280; book error −240.
- Adjusted bank = 77,040 + 34,300 − 19,620 + 320 = $92,040.00.
- Adjusted book = 32,760 + 61,800 − 2,280 − 240 = $92,040.00.
- Difference = $0.00, so the result is Reconciled — balances agree.
- Adjustment to record = 92,040 − 32,760 = $59,280.00.
| Balance on the bank statement | Adjusted bank balance |
|---|---|
| 19,260 | $34,260.00 |
| 38,520 | $53,520.00 |
| 57,780 | $72,780.00 |
| 77,040 | $92,040.00 |
| 96,300 | $111,300.00 |
| 115,560 | $130,560.00 |
| 154,080 | $169,080.00 |
How to read the result
A difference of zero means every timing item and error has been found. If it is not zero, look for a missing item: check for transposed digits (a difference divisible by 9 often points to one), entries recorded twice, or a fee you missed. The adjustment figure is the net amount of all book-side entries you must post so that your ledger matches the true balance.
Common mistakes
- Recording deposits in transit or outstanding checks as journal entries.
- Getting the sign of an error wrong.
- Forgetting bank charges, interest or bounced customer checks.
- Using a statement and a ledger that end on different dates.
Frequently asked questions
Which items need journal entries?
Only book-side items: bank collections, interest, fees, NSF checks and your own errors.
Why does a difference divisible by 9 matter?
Swapping two digits changes a number by a multiple of 9, so such a difference often signals a transposition error.
How often should I reconcile?
At least every month when the statement arrives, and more often for busy accounts.
Sources: OpenStax, Principles of Accounting, Volume 1: Financial Accounting, section 8.6 "Define the Purpose of a Bank Reconciliation, and Prepare a Bank Reconciliation and Its Associated Journal Entries"