Finance tool
Bank reconciliation calculator
Reconcile your bank and book balances with the standard formula — instantly see the adjusted totals and whether you're reconciled.
Start with the free manual tool. If you want the real document view after that, analyze a statement PDF.
Free tool
Reconcile bank and book balances with the standard formula
Plug in the numbers. The adjusted bank and adjusted book balances update live, and the status panel tells you whether you're reconciled or still off — plus the most common reasons a gap persists.
Reconciliation inputs
Enter the ending balances from your bank statement and books, then add the items that explain the gap.
Ending balances
Ending balance on your bank statement.
Ending balance in your books or ledger.
Bank-side adjustments
Deposits recorded in books but not yet on bank statement.
Checks written but not yet cleared.
Positive to add, negative to subtract (bank mistakes).
Book-side adjustments
Interest, refunds, or other credits not yet in books.
Service fees, overdraft fees, etc. not yet in books.
Bounced checks that were added to books but later returned.
Positive to add, negative to subtract (bookkeeping mistakes).
Adjusted bank balance equals adjusted book balance — the statement is reconciled.
Bank balance + deposits in transit − outstanding checks ± errors.
Book balance + unrecorded credits − fees − NSF ± errors.
No gap — fully reconciled.
The real, trustworthy cash position.
Natural next step
Need the transactions, not just the formula?
The hardest part of reconciliation is usually finding every unrecorded transaction before running the math. Upload the bank statement PDF and get every line categorized and laid out, ready for reconciliation.
What it gives you
Fast enough for a first pass
Each tool is intentionally narrow. The job here is a clean estimate, not a fake replacement for a full statement analysis.
Formula-based, not a black box
Adjusted bank and adjusted book balances update live as you type inputs.
Every input labelled and explained
Shows the full reconciliation equation so you understand the math, not just the answer.
Guides you when the gap won't close
Tells you the likely cause (transposition, duplicate entry, wrong period) if you're still off.
When it's useful
This calculator implements the standard bank-vs-book reconciliation formula. It's a pencil-and-paper alternative to full accounting software.
Small-business owners reconciling by hand
Useful when you're preparing a bank reconciliation statement without QuickBooks, Xero, or Sage — for example during month-end close in a spreadsheet.
Bookkeepers pressure-testing client books
Good for a quick sanity check when a bank-feed reconciliation in software seems off and you want to validate the adjusted-balance math independently.
Accounting students learning the formula
The adjusted-balance formula is more memorable once you see inputs change the result live. Every input is labelled with what it represents.
Anyone reviewing a bank statement manually
Helpful when you want to understand exactly why your bank statement and your own records disagree before deciding which one to trust.
Deeper context
How to use this calculator in a real reconciliation
The calculator is the math; the work is gathering the right numbers before you type them in.
Start with the bank statement, not the books
Open the bank statement for the period, write down the ending balance, and make a list of every transaction on the statement that isn't yet in your books (bank fees, interest, NSF returns). Those go into the book-side adjustments.
Then find what's in the books but not on the statement
Review your ledger for checks that haven't cleared and deposits that haven't landed. These are outstanding checks and deposits in transit — they go into the bank-side adjustments.
Run the calculator and see where you land
If the status shows reconciled, document the figures as your bank reconciliation statement. If it shows a gap, check for duplicate entries and transposition errors (division by 9 trick) before adding anything else.
Deeper context
Common mistakes this calculator surfaces
Reconciliation errors tend to be one of a small set of predictable problems.
Treating bank credits as book credits
Interest paid by the bank shows on the statement but usually hasn't been entered into the books yet. It's a book-side addition, not a bank-side item.
Forgetting NSF returns
A customer cheque that bounced was originally recorded as a deposit in your books. Until you reverse it, your books overstate cash. NSF returns subtract on the book side.
Using the wrong statement period
The bank balance you enter must match the same ending date as the book balance. Off-by-one-day or off-by-one-month errors produce persistent gaps that the adjustments can't explain.
FAQ