Saved

Press the star next to a tool's name to save it.

All my tools

Bank Reconciliation Calculator

Use this bank reconciliation calculator to reconcile a bank statement with your cash book, with the adjusted balances and the unreconciled difference.

Restored your last values ·

Enter the closing balance on the bank statement and in your cash book. Add the deposits in transit and the unpresented cheques on the bank side, and the bank items that are not yet in your book on the cash book side.

Everything is worked out in your browser. Nothing you type is sent anywhere.

–

–

Enter the bank and cash book balances and the items that differ, then press Reconcile the account.

See full result

A bank reconciliation calculator checks that the balance in your cash book agrees with the balance on your bank statement. Enter both balances and the items that explain the difference, such as deposits that have not reached the bank, cheques that have not been paid, and bank charges that you have not recorded, and the calculator gives the adjusted balances and the difference. It follows the standard textbook method.[1] It runs in your browser and nothing you enter is sent anywhere.

How to use the bank reconciliation calculator

  1. Enter the balance on the bank statement and the balance in the cash book.
  2. On the bank side, enter the deposits in transit and the unpresented cheques.
  3. On the cash book side, enter the bank charges, returned cheques, automatic payments, interest and receipts collected by the bank.
  4. Press Reconcile the account.

Why the two balances differ

Your cash book and the bank's statement are two records of the same money, and they differ for a few reasons. Some items are in your book but not yet at the bank: deposits that you have made but the bank has not yet recorded, called deposits in transit, and cheques that you have written but that have not yet been paid, called unpresented or outstanding cheques. Other items are at the bank but not yet in your book: bank charges, interest, payments made automatically and amounts that the bank collected for you.

The adjustments

On the bank side, a financial accounting textbook adds the deposits in transit, deducts the outstanding cheques, and adjusts for any errors by the bank. On the cash book side, it deducts bank service charges and returned (NSF) cheques, and adds interest and notes collected by the bank for the depositor.[1] This calculator also deducts automatic payments on the cash book side, which is our own working and treats them like bank charges. When the two adjusted balances are equal, the unreconciled difference is zero, and the textbook says the two sides must agree to finish.[1]

Worked example

Our worked example is a business in January 2023. The bank balance is 10,505. Two deposits in transit of 450 and 435 are added, which makes 885, and three unpresented cheques of 100, 876 and 100 are deducted, which makes 1,076. The adjusted bank balance is 10,505 plus 885 minus 1,076, which is 10,314. The cash book balance is 10,321, and a withdrawal fee of 7 that has not been recorded is deducted, which gives 10,314. The two agree, and the difference is zero.

If the difference is not zero

A difference means that something is missing or wrong. Check each item against the bank statement and the cash book. Look for amounts that have been entered twice or not at all, for figures that were typed wrongly, such as two digits swapped, and for items that appear in one record and not the other. Tick off each item as you match it. The reconciliation is finished only when the difference is zero.[1]

Why reconcile

A regular reconciliation helps you to find mistakes and fraud, to see what money you really have available, and to keep the accounts correct. Businesses often do it every month. The method is the standard textbook one, and a small business or a household can use it each month. It describes general accounting practice, not rules of any bank, a tax authority or an auditor.

Reading the result

The calculator shows the adjusted bank balance, the adjusted cash book balance, the difference between them and a message that says whether the account is reconciled. When the difference is zero, the message says so, and you can record the adjustments in your cash book. If it shows a difference, the amount is a clue: a difference equal to one of your items suggests that the item has been left out or put on the wrong side.

Updating the cash book

After you reconcile, the items that were at the bank but not in your book need to be recorded in the cash book, such as the bank charges, the interest, the automatic payments and the returned cheques. The deposits in transit and the unpresented cheques do not need an entry, since they are already in your book, and they will appear on the next bank statement when they clear.

Using the calculator monthly

Do the reconciliation when you receive each bank statement. Take last month's unpresented cheques and deposits in transit, and check that they cleared. Items that are still outstanding after a few months may be lost or may need to be cancelled, so follow them up. Keep your working papers with the accounts, in case you are asked to show them.

Common mistakes

  • Adding the outstanding cheques. They are taken off the bank balance.
  • Counting an item on both sides. Each item belongs on one side only.
  • Forgetting bank charges and interest. They are in the bank statement but not in your book.
  • Stopping when the figures look close. The difference must be zero.

What next

Use this often? Add Bank Reconci to your Home screen.

Frequently asked questions

What is a bank reconciliation calculator?

A tool that compares the balance in your cash book with your bank statement after adjusting for items that differ.

How do you work out the adjusted bank balance?

Bank balance + deposits in transit − unpresented cheques.

How do you work out the adjusted cash book balance?

Cash book balance minus bank charges, returned cheques and automatic payments, plus interest and receipts collected by the bank.

What should the difference be?

Zero. The adjusted bank balance and the adjusted cash book balance must agree to finish the reconciliation.

What is a deposit in transit?

Money you have deposited that the bank has not yet recorded.

What went wrong?

We only receive the reason you pick, never what you typed into the tool.

Thanks for your feedback.

More Finance Tools