Reconcile a bank statement with your cash book.
Please do not make financial decisions based on these results.
What is the Bank Reconciliation Calculator?
Reconcile a bank statement with your cash book. To use the Bank Reconciliation Calculator, enter bank statement balance, deposits in transit, outstanding checks, book balance, bank fees not yet booked, interest not yet booked; it returns adjusted bank balance, adjusted book balance, difference, and shows them instantly as you type.
Where the Bank Reconciliation Calculator fits
Reconcile a bank statement with your cash book. The main figure it returns is the Adjusted bank balance, worked out from the values you enter.
It belongs with the other budget & planning tools. If you are comparing options or checking a result from another angle, try the Powerball Calculator, Budget Planner (50/30/20) or the Budget Calculator.
How to use the Bank Reconciliation Calculator
- Fill in the fields. You will need Bank statement balance ($), Deposits in transit ($), Outstanding checks ($), Book balance ($), Bank fees not yet booked ($), Interest not yet booked ($). Start with your real monthly figures, even if they are rounded. Fields marked optional can stay at zero.
- Read the result. The highlighted box gives the Adjusted bank balance, and the cards below show Adjusted book balance, Difference. Tables and charts break it down further.
- Test other scenarios. Results update as you type. Change one value at a time to see what drives the answer, and press Reset to go back to the defaults.
Formula and how it works
Example with real numbers
Here is the Bank Reconciliation Calculator using the default values shown in the calculator above:
Inputs
| Bank statement balance ($) | 12,500 |
|---|---|
| Deposits in transit ($) | 2,200 |
| Outstanding checks ($) | 1,650 |
| Book balance ($) | 13,050 |
| Bank fees not yet booked ($) | 25 |
| Interest not yet booked ($) | 10 |
Results
| Adjusted bank balance | $13,050.00 |
|---|---|
| Adjusted book balance | $13,035.00 |
| Difference | $15.00 |
With these inputs the calculator returns Adjusted bank balance: $13,050.00. Change any value in the calculator to see how the result moves.
What if you change one input?
Sensitivity check: raising Bank statement balance ($) from 12,500 to 15,000 (about 20% higher) and leaving everything else as in the example above changes the results like this:
| Result | Example | After the change | Change |
|---|---|---|---|
| Adjusted bank balance | $13,050.00 | $15,550.00 | +19.2% |
| Adjusted book balance | $13,035.00 | $13,035.00 | 0% |
| Difference | $15.00 | $2,515.00 | +16666.7% |
The input that moves the result most is the one to check twice. Change it in the calculator above to test your own case.
What the results tell you
The results panel of the Bank Reconciliation Calculator reports Adjusted bank balance, adjusted book balance and difference. Compare these figures while changing one input at a time, and use the related calculators below to look at the same situation from another angle.
Method and limits. This calculator applies the formula in the section above to your inputs, in your browser; nothing you enter is stored on our servers. Results are only as good as the figures you enter; use real recent numbers. It is for information, not financial, tax or legal advice.
Frequently asked questions
What should the two sides show?
The adjusted bank balance should equal the adjusted book balance.
Do my numbers leave my device?
No. Everything is calculated in your browser and nothing is stored on our servers.
How do I start a budget?
List your take-home income, list every regular expense, and compare. Adjust until spending is below income with room for savings.
Are the results guaranteed?
No. Results depend entirely on the numbers you enter and the formulas shown on this page. Please do not make financial decisions based on them alone; confirm important figures with a licensed professional.
Related budget & planning calculators
- Powerball Calculator
- Budget Planner (50/30/20)
- Budget Calculator
- Cost of Living Adjuster
- Net Worth Calculator
- Emergency Fund Calculator
- FIRE Calculator – Financial Independence, Retire Early
- Millionaire Calculator
- Savings Goal Calculator
- Savings Plan Calculator
- Simple Savings Calculator
- 70/20/10 Rule Money Calculator
All Budget & Planning calculators →