Bank Reconciliation Calculator
Print
Maintain precise internal cash controls and streamline monthly bookkeeping audits. Use this Bank Reconciliation Calculator to match bank statement ending balances against company general ledger balances, accounting for outstanding checks, deposits in transit, bank fees, and interest accrued.
The Formula for Adjusted Bank and Book Balances
A bank reconciliation aligns the bank statement ending balance with the internal book balance through dual mathematical adjustments:
Adjusted Bank Balance = Bank Statement Ending Balance + Deposits in Transit - Outstanding Checks ± Bank Errors
Adjusted Book Balance = General Ledger Cash Balance + Interest Earned + Direct Collections - Bank Service Charges - NSF Checks ± Book Errors
Goal: Adjusted Bank Balance must equal Adjusted Book Balance.
Bank vs. Book Reconciliation Adjustments Matrix
Refer to the lookup table below to properly classify common ledger items during your monthly reconciliation audit:
| Adjustment Item | Side Adjusted | Mathematical Action | Accounting Rationale |
|---|---|---|---|
| Deposits in Transit | Bank Side | Add to Bank Balance | Cash received and recorded in books, but not yet processed by the bank. |
| Outstanding Checks | Bank Side | Deduct from Bank Balance | Checks written and recorded in books, but not yet cashed by the payee. |
| Bank Service Charges / Fees | Book Side | Deduct from Book Balance | Fees deducted by the bank not previously recorded in general ledger. |
| Non-Sufficient Funds (NSF) Checks | Book Side | Deduct from Book Balance | Bounced customer checks deducted by bank that must be restored to A/R. |
| Interest Earned | Book Side | Add to Book Balance | Interest paid by bank credited to statement not yet journalized. |
Step-by-Step Bank Reconciliation Example
Suppose a company has a bank statement ending balance of $42,500 and an unadjusted general ledger book balance of $40,150 on March 31st:
- Gather Bank Adjustments: Deposits in transit = $3,200; Outstanding checks = $5,800.
Adjusted Bank Balance = $42,500 + $3,200 - $5,800 = $39,900 - Gather Book Adjustments: Bank service charge = $50; Interest earned = $200; NSF customer check = $400.
Adjusted Book Balance = $40,150 + $200 - $50 - $400 = $39,900 - Verify Equal Balances: Both Adjusted Bank Balance and Adjusted Book Balance equal $39,900. The account is fully reconciled.
Frequently Asked Questions
Why is a bank reconciliation necessary for businesses?
Performing a monthly bank reconciliation ensures cash balance accuracy, prevents fraud, detects unauthorized bank withdrawals, catches accounting entry errors, and prevents bounced checks.
What is a Non-Sufficient Funds (NSF) check?
An NSF check is a customer check that was deposited into your account but bounced due to insufficient funds in the payer’s bank account. The bank deducts this amount from your statement balance.
How do you handle bank errors during reconciliation?
If the bank erroneously debits or credits your account, adjust the bank side of the reconciliation statement to reflect the correct figure and immediately notify your banking institution for correction.
Do outstanding checks affect your general ledger cash balance?
No, outstanding checks have already been deducted from your general ledger cash account when written. They only require adjustment on the bank statement side of the reconciliation.