Bank Reconciliation Calculator

The bank reconciliation process involves adjusting two separate figures—your cash book balance and your bank statement balance—until they meet at a true, corrected ending balance. First, we compute the adjusted cash book balance by taking your initial cash book balance, adding any recorded receivables or interest earned, and subtracting automatic bank payments, bank charges, and NSF (non-sufficient funds) cheques: CbAdjusted = CashBookBalance + Receivable + InterestEarned - AutomaticBankPayments - BankCharges - NSFCheques. Second, we calculate the adjusted bank balance by taking the ending bank statement balance, adding deposits in transit, and subtracting outstanding cheques: AdjustedBankBalance = BankBalance + DepositInTransit - OutstandingCheques. Finally, the tool calculates the absolute unreconciled difference between these two adjusted figures: UnreconciledDifference = |AdjustedEndingBalanceBank - CbAdjustedEndingBalance|. If your records are completely accurate, this difference will equal zero.

Imagine you are closing your monthly business accounts. Your internal cash book balance stands at $10,000, and your official bank statement shows a balance of $9,500. Upon reviewing your logs, you find a deposit in transit of $2,000 and outstanding cheques totaling $1,000, giving an adjusted bank balance of $9,500 + $2,000 - $1,000 = $10,500. On the cash book side, you notice $800 in unrecorded receivables and $200 in interest earned, but you also need to subtract $300 for automatic monthly software payments, $50 in bank service charges, and a $250 NSF cheque from a client. Calculating your adjusted cash book balance yields $10,000 + $800 + $200 - $300 - $50 - $250 = $10,400. Because the adjusted bank balance ($10,500) and the adjusted cash book balance ($10,400) do not match, the calculator returns an unreconciled difference of $100, prompting you to investigate a missing transaction in that exact amount.

To make your reconciliation process seamless and error-free, always cross-verify your transaction dates to ensure deposits and withdrawals fall within the specific accounting period. Maintain strict segregation of duties where possible, ensuring the person recording cash receipts does not also perform the monthly bank reconciliation. Finally, investigate even minor unreconciled discrepancies immediately, as small variances can often mask larger systemic reporting errors or fraudulent activity.