Statement (Bank) Side
$
$
$
$
Other bank-side adjustments
| Description | Sign | Amount |
|---|
Tip: use positive sign for additions and negative sign for deductions on the bank statement side.
Books (Ledger) Side
$
$
$
$
$
Other book-side adjustments
| Description | Sign | Amount |
|---|
Tip: use positive sign for additions and negative sign for deductions on the books side.
Reconciliation Results
Adjusted bank balance
$0.00
= Statement + Deposits in transit − Outstanding checks ± Bank errors ± Other bank adjustments
Adjusted book balance
$0.00
= Book balance − Service charges + Interest − NSF ± Book errors ± Other book adjustments
Difference (bank − book)
$0.00
Status: —
| Line | Amount ($) |
|---|
Example Data (You can load these)
| Item | Value |
|---|---|
| Bank statement balance | 5000.00 |
| Deposits in transit | 1250.00 |
| Outstanding checks | 980.00 |
| Bank errors | -35.00 |
| Book balance | 4870.00 |
| Service charges | 15.00 |
| Interest earned | 5.00 |
| NSF items | 120.00 |
| Book errors | 40.00 |
| Other bank adjustments (net) | 0.00 |
| Other book adjustments (net) | 0.00 |
Formula used
Adjusted bank balance = Bank statement balance + Deposits in transit − Outstanding checks ± Bank-side errors ± Other bank-side adjustments.
Adjusted book balance = Book / ledger balance − Bank service charges + Interest earned − NSF items ± Book-side errors ± Other book-side adjustments.
When the reconciliation is complete, the adjusted bank balance should equal the adjusted book balance. Differences indicate missing items, timing differences, or data entry issues that must be resolved.
How to use this calculator
- Enter your period-end bank statement balance and the amounts for deposits in transit and outstanding checks.
- Record any bank errors affecting the statement (use negative for bank overstatement).
- Enter your book / ledger balance, plus fees and interest posted by the bank, NSF items, and any book errors.
- Use the “Other adjustments” tables to add additional reconciling items on either side.
- Press Calculate to compute adjusted balances, difference, results table, and the waterfall chart.
- Export the summary as CSV or PDF for records or attach to your close package.
All amounts are in the same currency. Positive = additions; negative = deductions. Rounding to two decimals is applied in displays.
FAQs
What is a bank reconciliation?
It is a process that compares bank statement cash to the organization’s books for the same period, adjusting for timing differences and errors until both balances match.
Which items appear on the bank side versus the book side?
Bank side typically includes deposits in transit, outstanding checks, and bank-side errors. Book side includes service charges, interest, NSF returns, and book-side errors.
How should I sign an adjustment?
Use positive for items that increase the balance and negative for items that decrease it. The labels above each section describe expected signs for common items.
Why do my adjusted balances not match?
Likely missing reconciling items, incorrect amounts, or cut‑off timing. Review uncleared checks, unrecorded bank fees or interest, and potential data entry mistakes.
Can I include many small items?
Yes. Use the “Other adjustments” tables to add multiple lines for either side. They are summed into the calculation and visualized in the chart as net adjustments.
Is this tool audit-friendly?
You can export a dated CSV and PDF summary that documents inputs and final balances. Keep supporting details (e.g., check listings) outside this summary as needed.