Bank Reconciliation Calculator
Reconcile book balance against a bank statement using outstanding checks, deposits in transit, bank fees, interest income, and book adjustments.
In words: Ten thousand
In words: Nine thousand five hundred
Adjust the bank statement
In words: Eight hundred
In words: Five hundred
Adjust the cash book
In words: Fifty
In words: Twenty-five
In words: Zero
Use a negative number in “Other adjustment” to reduce books, such as to correct an over-recorded receipt. This tool is a worksheet; review source documents before posting entries.
Reconciliation still has a difference
Find and correct ₹775 of remaining differences.
₹10,300
Adjusted bank balance
In words: Ten thousand three hundred
₹9,525
Adjusted book balance
In words: Nine thousand five hundred twenty-five
₹775
Difference to investigate
In words: Seven hundred seventy-five
Not matched
Reconciliation status
Reconciliation summary
Bank: ₹10,000 + ₹800 − ₹500 = ₹10,300
Books: ₹9,500 + ₹50 − ₹25 + ₹0 = ₹9,525
Bank Reconciliation Calculator: Match Your Cash Book and Bank Statement
This bank reconciliation calculator helps you compare the cash balance in your accounting records with the balance reported by your bank. Enter the ending bank statement balance and cash book balance, then add common timing differences such as deposits in transit and outstanding checks. Add bank interest, deduct bank charges, and record any other book correction to see whether both adjusted balances match.
A monthly bank reconciliation is one of the simplest controls for finding missing transactions, recording bank charges, detecting duplicate entries, and keeping an accurate cash balance. The process is useful for small businesses, freelancers, nonprofits, clubs, and anyone maintaining a cash book, spreadsheet, or accounting system. This worksheet gives you a transparent reconciliation summary before you update your records.
What Is a Bank Reconciliation?
Bank reconciliation is the process of explaining why the bank statement balance and the company's cash book balance are different on a particular date. The balances often differ because transactions can be recorded by the business before the bank processes them, or because the bank has processed an item the business has not yet entered. Once these timing items and errors are identified, both sides should arrive at the same adjusted cash balance.
It is not merely a bookkeeping task. Reconciliation provides a reliable view of available cash, helps prevent overdrafts, supports accurate financial statements, and makes unusual transactions easier to investigate. Completing it regularly also means fewer old unexplained items at year-end.
How to Use the Bank Reconciliation Calculator
First, use the ending balance on the bank statement for the period. Then enter the ending cash balance from your ledger, cash book, or accounting software for the same date. The dates must match; reconciling a 31 March bank balance to a 30 March book balance will create an unnecessary difference.
Next, list deposits in transit: cash receipts your business recorded and deposited but which the bank has not yet included in the statement. Enter outstanding checks: payments recorded in your books but not yet cleared by the bank. On the book side, enter bank interest that appears only on the statement, subtract service charges or returned-item fees, and enter any signed correction required for a book error.
Bank Balance Adjustments: Deposits in Transit and Outstanding Checks
A deposit in transit increases the adjusted bank balance because the business has already recorded the receipt, but the bank has not posted it by the statement date. Common examples include card settlements, customer checks, cash deposits made late in the day, and electronic receipts that settle after month-end. Keep a deposit slip, merchant report, or receipt reference with the reconciliation.
Outstanding checks reduce the adjusted bank balance. These are checks, transfers, or electronic payments already entered in the cash book but not yet shown as cleared. Some may clear shortly after the statement date; old outstanding checks deserve follow-up because a payee may have lost the check or the transaction may need to be voided and reissued.
Book Balance Adjustments: Interest, Fees and Errors
The bank can process transactions before the business knows about them. Interest income increases the book balance and should be recorded as income. Monthly service fees, transaction fees, overdraft fees, returned checks, card processing charges, and loan deductions reduce the book balance. These are not usually adjustments to the bank statement because the bank has already reflected them there.
Book errors also need correction. Examples include recording a payment as 45 instead of 54, posting a receipt twice, or entering an amount in the wrong account. Use the signed other-adjustment field for the net cash correction, then make the correct journal entry in your bookkeeping system with documentation that explains the change.
Bank Reconciliation Formula
The bank side formula is: statement balance plus deposits in transit minus outstanding checks equals adjusted bank balance. The book side formula is: cash book balance plus bank interest minus bank fees plus or minus book corrections equals adjusted book balance. A completed reconciliation has equal adjusted balances.
If the calculator shows a difference, do not force the number to match. Work from the source documents: compare each bank statement transaction with the cash ledger, verify amounts, and look for transactions recorded twice or not at all. The difference itself is useful evidence that an item remains unresolved.
Common Reasons a Bank Reconciliation Does Not Balance
Frequent causes include a transposed number, a transaction entered on one side but not the other, a missing bank fee, an uncleared check, a deposit posted in the following period, or a duplicate entry. A difference that is divisible by nine can sometimes point to reversed digits, but this is only a clue, not proof. Start with larger, recent, and unusual transactions.
Also check the opening balance. If the prior month's reconciliation was not completed correctly, every later period may inherit the same error. Resolve older outstanding items rather than rolling them forward indefinitely, and make sure the statement period and book reporting date are identical.
Bank Reconciliation Example
Suppose the statement balance is 10,000. The business has 800 in deposits in transit and 500 in outstanding checks. The adjusted bank balance is 10,300. The cash book balance is 10,275, the statement shows 50 of bank interest and 25 of service fees, and there is no other adjustment. The adjusted book balance is also 10,300, so the account reconciles.
This example shows why the original balances do not need to be the same. The goal is not to change the bank statement. It is to identify legitimate timing differences and record items missing from the books until both adjusted balances agree.
Best Practices for Monthly Bank Reconciliation
Reconcile each bank and payment account every month soon after statements become available. Keep copies of statements, reconciliation reports, deposit support, payment registers, and notes for unusual entries. If more than one person handles cash, having a different person review or approve the reconciliation strengthens internal control.
Use a consistent cutoff date and label reconciliations clearly. For businesses with high transaction volume, reconcile more often, such as weekly. Regular review helps spot fraud, unauthorized payments, recurring fees, and cash-flow problems earlier than an annual clean-up.
Bank Reconciliation for Small Businesses and Freelancers
Even a sole proprietor can benefit from reconciliation. Separate personal and business banking, record every sale and expense, and compare your records with the bank every month. It improves visibility over profit and cash, helps prepare tax records, and reduces the time needed to answer questions from an accountant or lender.
Accounting software can automate much of the matching work, but automation still needs review. Merchant processor deposits may arrive net of fees, recurring subscriptions can change, and bank feeds can contain duplicates or categorization errors. A reconciliation worksheet remains a valuable final check.
Use This Calculator as a Reconciliation Worksheet
This calculator is designed for standard cash-account reconciliation. It does not replace accounting records, audit procedures, professional advice, or bank statements. Use it to organise the numbers, then post necessary entries in your accounting system and retain the supporting documents. For complex transactions, multiple currencies, loan accounts, or suspected fraud, ask a qualified accountant for help.
A reconciled bank balance gives you a dependable starting point for budgeting, paying bills, planning purchases, and reporting results. By checking the bank and book side systematically, you turn a confusing mismatch into a clear list of timing differences and corrections.
Frequently Asked Questions
What is a deposit in transit?
It is a receipt recorded in your cash book and deposited with the bank, but not yet included on the period-end bank statement.
What are outstanding checks?
They are payments recorded in the books that have not yet cleared the bank by the statement date.
Should bank fees adjust the bank balance or book balance?
Bank fees already appear on the bank statement, so they normally reduce the book balance when you record them.
Why should adjusted bank and book balances match?
Matching adjusted balances confirms that timing differences and missing book entries have been identified for the same reporting date.