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 tool. For the real numbers from your own statement, analyze a statement PDF.
Pick the right tool
Need the transactions in a sheet?
Convert the statement PDF to Excel or CSV when you want every line in a spreadsheet before running the reconciliation.
Convert to Excel →Need the statement reviewed too?
Use the analyzer when you want categorized transactions, income and spending totals, and flags from the uploaded PDF.
Analyze a statement PDF →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).
Reconciliation status
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.
Reconciliation formula
- Adjusted bank = Bank bal + Deposits in transit − Outstanding checks ± Bank errors
- Adjusted book = Book bal + Credits − Fees − NSF ± Book errors
- Reconciled when Adjusted bank = Adjusted book
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.
- Every transaction from the real file
- Category totals and repeat charges
- Export to Excel or CSV
Fast enough for a first pass
Each tool does one job: a clean estimate, not a stand-in 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
Bookkeepers pressure-testing client books
Accounting students learning the formula
Anyone reviewing a bank statement manually
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.
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.
Bank reconciliation calculator: questions & answers
What is a bank reconciliation calculator?
A bank reconciliation calculator takes the ending balance from your bank statement and the ending balance from your books (or accounting software), plus the outstanding items that explain any difference, and computes the adjusted balances on both sides. When the adjusted bank balance equals the adjusted book balance, the account is reconciled.
What formula does this reconciliation calculator use?
Two formulas. Bank side: Adjusted bank balance = Bank statement ending balance + Deposits in transit − Outstanding checks ± Bank errors. Book side: Adjusted book balance = Book ending balance + Unrecorded credits (interest, refunds) − Bank fees − NSF returned checks ± Book errors. The account is reconciled when both adjusted figures are equal.
What counts as a deposit in transit vs an outstanding check?
A deposit in transit is money you recorded in your books but that hasn't posted on the bank statement yet (typically a deposit made near the end of the month). An outstanding check is a check you wrote and recorded in the books but that hasn't been cashed by the recipient yet, so it hasn't cleared the bank.
What if my adjusted balances still don't match?
Three common causes: duplicate entries in your books, transposed digits (try dividing the difference by 9 — if it divides evenly, it's usually a transposition), or a missing transaction on one side. Also double-check the statement period — using last month's ending balance with this month's bank statement is a frequent source of mismatches.
Is this a replacement for QuickBooks or Xero reconciliation?
No — it's a calculator, not bank-feed software. QuickBooks, Xero, and Sage each have built-in reconciliation flows that pull transactions from your bank feed and let you tick off cleared items. This calculator is useful when you're reconciling by hand, pressure-testing the math, preparing a manual reconciliation statement, or learning the formula.
Do I need bank statement reconciliation software for this?
Not for a single statement. This calculator plus a converted Excel or CSV export of the statement covers a one-off reconciliation: you have every transaction in a sheet and the adjusted-balance math here. Bank statement reconciliation software (QuickBooks, Xero, Sage) starts paying for itself when you match statements to a ledger every month, need a bank feed, and want the cleared items ticked off and stored as an audit trail.
How often should I reconcile?
Monthly is the standard for both businesses and individuals — reconcile at the end of each bank statement period. High-volume businesses may reconcile weekly or even daily. Going longer than 90 days without reconciling lets small errors compound into ones that are much harder to trace.
Does this calculator save my data?
No. The calculator runs entirely in your browser — nothing is sent to a server, saved, or shared. When you close the tab, every number you entered is gone.
Something else on your mind? Write to contact@mybankstatementanalysis.com.