A bank reconciliation proves that two independent records of the same cash agree. Your ledger says one thing, the bank says another, and the difference is almost never an error — it is timing. You recorded a cheque the day you wrote it; the bank records it the day it clears. This calculator applies the standard adjustments to both sides and reports whether they meet, and by how much they miss if they do not.
Arb Digital built it as a working tool rather than a template. It separates the two sides properly, so it is obvious which adjustments are timing differences that need no entry and which are real transactions that must be posted to the ledger. That distinction is the part people most often get wrong, and getting it wrong means either double-counting or leaving a permanent unexplained gap. If you are looking at the cash position more broadly, our personal cash flow calculator and working capital calculator cover different questions entirely.
What This Bank Reconciliation Calculator Does
It takes the bank statement balance and adjusts it for the items the bank has not yet seen: deposits in transit are added, outstanding payments are subtracted, and any bank error is applied with its own sign. That gives the adjusted bank balance, which is the true cash figure.
It then takes your book balance and adjusts it for the items you have not yet seen: credits the bank applied, charges it deducted, payments it reversed, and any error in your own recording. That gives the adjusted book balance. When the reconciliation is complete the two are identical, and the tool reports the difference to the tolerance you set.
It also reports the net adjustment on each side separately, which is a useful diagnostic in its own right. A large net bank-side adjustment means a lot of items are in flight, which is normal at a month end and a warning sign in the middle of a quiet month. A large book-side adjustment means the ledger was materially incomplete, and that is worth understanding rather than simply correcting.
How to Use It
- Take both balances at exactly the same cut-off date. A reconciliation between a statement dated the 31st and a ledger run on the 2nd will never balance, and the difference will not be informative.
- Tick off every item that appears on both records. What is left on the bank statement but not in the ledger goes into the book-side fields; what is in the ledger but not on the statement goes into the bank-side fields.
- Enter outstanding payments, charges and returned items as positive numbers. The tool subtracts them, so entering them as negatives will double the error.
- Use the signed error fields only for genuine mistakes, and be precise about which side made the mistake. A bank error is corrected on the bank side and reported to the bank; a book error is corrected on your side with a journal entry.
- Read the unexplained difference. If it is not zero, the reconciliation is not finished, and the notes underneath suggest the usual causes.
The Formula
Two adjusted balances, computed independently and then compared:
Adjusted bank = statement balance + deposits in transit − outstanding payments ± bank errors
Adjusted book = book balance + unrecorded credits − charges − returned items ± book errors
A worked example on the default figures. The statement shows 15,420.50. Add deposits in transit of 3,250.00 and subtract outstanding payments of 1,875.25, giving an adjusted bank balance of 16,795.25. The ledger shows 16,470.00. Add a collected note of 500.00, subtract charges of 45.00 and a returned payment of 129.75, giving an adjusted book balance of 16,795.25. The two agree, so the reconciliation is complete and the true cash figure is 16,795.25.
Notice that the two starting balances differ by 1,049.50 and neither of them is the real cash position. That is the normal state of affairs, and it is why the reconciliation exists. OpenStax sets out the purpose and the journal entries in its section on preparing a bank reconciliation.
Only One Side Produces Journal Entries
This is the rule that catches people. The bank-side adjustments — deposits in transit and outstanding payments — are already in your books. You recorded them when they happened. They are simply not yet in the bank's records, and they will be within days. Posting a journal entry for them would record the same transaction twice.
The book-side adjustments are the opposite: they are real transactions that have already hit the bank account and are missing from your ledger. Every one of them needs an entry. Bank charges become an expense, collected interest becomes income, a returned customer payment reverses the receipt and puts the receivable back.
A reliable habit is to treat the book side as a to-do list and the bank side as an explanation. If an item is on the bank side of your reconciliation for a second consecutive month, it has stopped being a timing difference and has become something else — a lost cheque, a deposit that never arrived, or a payment that was cancelled without being reversed in the ledger.
Chasing a Difference That Will Not Close
When the two adjusted balances do not agree, the difference itself usually identifies the cause. Four patterns cover most cases.
If the difference is exactly divisible by nine, look for a transposition: 5,940 entered as 5,490 differs by 450, and 450 divides by nine. This works because swapping any two digits always produces a multiple of nine, and it is the fastest test available.
If the difference is exactly twice a transaction on your list, the item has been applied with the wrong sign — added where it should have been subtracted. If it is exactly equal to a transaction, the item has simply been missed on one side. And if it is a small, persistent, unchanging amount month after month, it is almost certainly an old error that was never cleared and is being carried forward in the opening balance, which means the reconciliation needs to be rebuilt from a known-good date rather than patched.
Never post a plug to force agreement. An unexplained difference written off to a suspense account is a permanent hole in the accounts, and it grows.
Why This Is a Control, Not Just a Tidy-Up
Reconciliation is one of the oldest internal controls in accounting, and its value is in the independence of the two records. Anyone inside the business can alter the ledger. Nobody inside the business can alter the bank statement. Comparing them regularly is therefore one of the few checks that detects both errors and misappropriation.
That control weakens sharply when one person records the transactions, banks the money and prepares the reconciliation. Separating those duties matters far more than the arithmetic on this page. So does frequency: a monthly reconciliation finds a problem up to thirty days old, and a weekly one finds it inside seven. For a business with high transaction volume, weekly is not excessive.
It also underpins the accounts themselves. The cash figure on a balance sheet is the adjusted balance, not the statement balance and not the raw ledger balance, and every ratio built on cash inherits that. The IRS sets out the accounting-method framework that governs when items are recognised in Publication 538, Accounting Periods and Methods.
Edge Cases the Simple Template Misses
Several situations need thought before the numbers go in. A stale cheque that has been outstanding for months should usually be cancelled and reinstated as a payable rather than left on the reconciliation forever, but the timing rules on that differ by jurisdiction and by bank.
Foreign currency accounts add a revaluation that is neither a timing difference nor an error; reconcile in the account's own currency first, then translate, or the exchange movement will contaminate the difference. Card settlements often net fees before they arrive, so the deposit on the statement is smaller than the sale recorded, and the fee belongs on the book side. Accounts with sweep arrangements move money automatically overnight, and the sweep must be recorded even though nobody instructed it.
Finally, an overdrawn account reconciles identically with negative balances; the arithmetic does not change, and this calculator handles negatives without complaint. What changes is the reading, since the adjusted balance is then a liability rather than an asset for ratio purposes. Our current ratio calculator and net worth calculator both depend on getting that classification right.
Arb Digital builds free tools like this one because useful pages earn attention. If you want tools, calculators or content built for your own audience, we can help.
Browse All Free Tools Talk to Arb DigitalCommon Mistakes to Avoid
- Adjusting the wrong side — a bank charge is a book-side item and a deposit in transit is a bank-side item. Swapping them produces a difference of exactly twice the amount, every time.
- Posting journal entries for timing differences — outstanding cheques and deposits in transit are already in your ledger, and entering them again double-counts the transaction.
- Using different cut-off dates — the statement date and the ledger date must be identical, or the difference includes ordinary activity and tells you nothing.
- Plugging the difference — forcing agreement with a suspense entry converts a findable error into a permanent one that carries forward and grows.
- Letting one person do everything — the control value of a reconciliation comes from the independence of the two records, and it largely disappears when the same person records, banks and reconciles.
Related Free Tools From Arb Digital
Track the flows behind the balance with the personal cash flow calculator, measure liquidity with the working capital calculator and the current ratio calculator, and check collection speed with the accounts receivable turnover calculator. Compare profit with cash generated using the accrual ratio calculator and the free cash flow calculator, total everything with the net worth calculator, and browse the full free online tools hub.
Frequently Asked Questions
Adjust the bank statement balance by adding deposits in transit, subtracting outstanding payments and applying any bank error. Adjust the book balance by adding unrecorded credits, subtracting charges and returned items and applying any book error. When the reconciliation is complete the two adjusted figures are identical.
Only the book-side ones. Charges, collected interest, returned payments and your own recording errors are real transactions missing from the ledger, so each needs an entry. Deposits in transit and outstanding payments are already recorded and are waiting on the bank, so posting them would double-count.
Test whether it divides exactly by nine, which indicates a transposed pair of digits. Then check whether it equals a single transaction on your list, meaning the item was missed, or exactly twice one, meaning it was applied with the wrong sign. Those three tests find most differences.
Money you have received and recorded, and banked, that the bank has not yet credited by the statement date. It is added to the bank balance because the bank will show it shortly. It is a timing difference, not an error, and it needs no entry in your ledger.
Investigate it rather than carrying it forward. A cheque that never clears is usually lost, cancelled or never sent, and the usual treatment is to void it and reinstate the amount as a payable. The rules on when a cheque becomes stale differ by jurisdiction and by bank, so check locally.
Monthly is the common minimum and matches the statement cycle. Weekly is better for any business with high transaction volume, because it limits how old an error or an unauthorised payment can be before it is found. The frequency is a control decision, not an accounting rule.
Yes, and the arithmetic is unchanged; the balances are simply negative. What changes is the presentation, because an overdrawn balance is a liability rather than a cash asset, and any liquidity ratio built on it needs to reflect that classification.
Keep it at one currency unit or below. A tolerance exists to absorb genuine rounding in currency conversion, not to make a reconciliation look finished. Anything larger hides exactly the small persistent differences that indicate a structural error in the process.
This tool is provided for informational and educational use only. It is not accounting, audit or tax advice, and it does not verify that any balance is correct or that any transaction is genuine. Treatment of stale items, foreign currency and error correction differs by jurisdiction and by accounting framework. Consult a qualified accountant on your own records and controls.
