Bank Reconciliation Calculator

Reconcile your bank statement with your books to identify discrepancies

About the Bank Reconciliation Calculator

Internal accounting and bank records rarely match at the end of a month due to timing differences and undocumented fees. The Bank Reconciliation Calculator serves as a vital financial control tool for small business owners, bookkeepers, and individuals to ensure their internal records are accurate and to detect potential fraud or banking errors. By inputting the ending balance from your bank statement alongside your own ledger balance, you can systematically account for transactions that appear in one record but not the other.

This tool helps users identify exactly where discrepancies lie, whether they are 'deposits in transit' that haven't cleared the bank yet or 'outstanding checks' that haven't been cashed. It also forces the user to account for bank-initiated transactions, such as service fees, interest, and NSF checks, which are often discovered only when the statement arrives. Using this tool on a monthly basis ensures that the cash balance shown on your balance sheet represents the actual liquidity available to the entity, preventing overdrafts and financial reporting errors.

Formula

Adjusted Bank Balance = (Bank Statement Balance + Deposits in Transit) - Outstanding Checks

The reconciliation process requires two parallel calculations to reach a verified 'Adjusted Cash Balance.' The Bank side starts with the ending statement balance, adds funds you've sent to the bank that haven't posted yet (deposits in transit), and subtracts checks you've written that haven't been cashed (outstanding checks).

The Book side starts with your internal ledger balance. You must add any interest earned or notes collected by the bank on your behalf, then subtract bank service charges, NSF checks, and electronic fund transfer (EFT) payments not yet recorded. Once both sides are adjusted, they should equal each other exactly.

Worked examples

Example 1: A business has a bank statement balance of $4,300, a book balance of $4,665, a deposit in transit of $500, and $150 in outstanding checks. The bank also charged a $15 service fee.

Bank Side: $4,300 (Statement) + $500 (Deposit) - $150 (Checks) = $4,650 
Book Side: $4,665 (Ledger) - $15 (Service Fee) = $4,650

Result: Adjusted Balance is $4,650.00. Both records now match after accounting for the $500 delay and $150 in pending payments.

Common use cases

A small business owner needs to verify if all customer checks deposited on the last day of the month were processed.
An accountant is performing year-end closing and needs to document the variance between the general ledger and the bank statement.
A non-profit organization wants to ensure no unauthorized withdrawals or bank fees have occurred without being recorded in the budget.

Pitfalls and limitations

Forgetting to check for bank errors, such as a deposit being credited to the wrong account by the bank teller.
Failing to account for automatic monthly subscriptions or EFT payments that do not involve physical checks.
Inputting interest income as a deduction instead of an addition to the book balance.
Neglecting to adjust the internal ledger (books) after the reconciliation is complete to reflect the new fees and interest.

Frequently asked questions

how do i handle checks that haven't cleared the bank yet

Uncleared checks are payments you have recorded in your books that have not yet been processed or cashed by the bank. To reconcile, you subtract these amounts from your bank statement balance since the money will eventually leave the account.

do i add or subtract deposits in transit during reconciliation

Outstanding deposits, or deposits in transit, are funds you have received and recorded but which appeared after the bank statement cutoff date. You must add these to your bank statement balance to align it with your internal records.

why does my book balance not match my bank statement balance

Bank service fees and interest earned are usually only known after receiving the statement. You must subtract bank fees from your book balance and add any interest earned to your book balance to reach the adjusted book total.

what do i do with an nsf check on a bank reconciliation

An NSF (Non-Sufficient Funds) check occurs when a customer's payment bounces. You must subtract this amount from your book balance because the money you thought was deposited was never actually collected by the bank.

what happens if the adjusted balances don't match

If your adjusted bank balance and adjusted book balance do not match, the difference is your reconciliation error. Common causes include data entry typos, duplicated transactions, or forgotten bank fees.