What this calculator does
A bank reconciliation confirms that the cash balance in your own records (the book or ledger balance) agrees with the ending balance shown on your bank statement, once you account for items that have not yet cleared or been recorded on one side. This tool applies the standard two-column method: it adjusts the bank balance for timing items and adjusts the book balance for entries the bank has already applied, then compares the two.
The two adjustments
The bank side and the book side are each corrected separately, then checked against each other:
- Adjusted bank balance = Bank statement balance + Deposits in transit − Outstanding checks. Deposits in transit are receipts you have recorded but the bank has not yet posted; outstanding checks are checks you have written that have not yet cleared.
- Adjusted book balance = Book (ledger) balance + Interest and credits earned − Bank fees and service charges. These are items the bank has already applied that you have not yet entered in your books.
- Reconciled when the two adjusted balances are equal, so the difference is $0.00.
Interpreting the output
If the difference is zero, the account is reconciled: every timing item and every unrecorded bank entry has been accounted for. If the difference is not zero, one or more items are still missing or misentered. Recheck each adjustment against the statement and the ledger — an overlooked deposit in transit, an uncleared check, an unrecorded fee or interest credit, a transposed digit, or a transaction posted twice are the usual causes.
Next steps
- After reconciling, record the bank fees and interest in your ledger so your books carry the adjusted book balance going forward
- Keep the list of deposits in transit and outstanding checks so you can confirm they clear on the next statement
- Reconcile every statement period, and cross-check with an accountant for high-stakes or year-end close work