User Rating 0.0 ★★★★★

Total Usage 0 times

Category Finance & Calculations

Bank Statement Side

Bank Statement Ending Balance

Deposits in Transit (add to bank)

Outstanding Checks (subtract from bank)

Bank Errors (±)

Book (Ledger) Side

Book Ending Balance

Interest Earned (add to book)

EFT / Direct Deposits (add to book)

Service Charges (subtract from book)

NSF / Returned Checks (subtract from book)

Book Errors (±)

Is this tool helpful?

Your feedback helps us improve.

★ ★ ★ ★ ★

About

Bank reconciliation resolves the difference between a company's cash book balance and the bank statement balance at a given date. Discrepancies arise from timing differences: checks issued but not yet cleared (O = outstanding checks), deposits recorded in books but not yet credited by the bank (D = deposits in transit), bank charges (C) deducted by the bank but not yet recorded in books, and interest earned (I) credited by the bank but not recorded. Failing to reconcile monthly exposes a business to undetected fraud, duplicated payments, and cash flow misstatements. The adjusted balance method used here brings both sides to an identical figure. If the final discrepancy is not 0.00, a recording error or omission exists and must be investigated before closing the period.

This tool assumes all amounts are in a single currency and does not account for foreign exchange adjustments. Pro tip: reconcile within 5 business days of statement date to catch errors before they compound across periods.

Formulas

The adjusted balance method reconciles both sides to a common correct figure:

Adjusted Bank Balance = Bank Statement Balance + D − O ± E_bank

Adjusted Book Balance = Book Balance + I + EFT − C − NSF ± E_book

Discrepancy = Adjusted Bank Balance − Adjusted Book Balance

Where D = deposits in transit, O = outstanding checks, E_bank = bank errors (add if understated, subtract if overstated), I = interest earned, EFT = electronic fund transfers received, C = service charges, NSF = returned checks, E_book = book errors. When Discrepancy = 0, the accounts are reconciled.

Reference Data

Reconciling Item	Adjusts	Direction	Common Source
Outstanding Checks	Bank Balance	Subtract	Checks issued, not yet cleared
Deposits in Transit	Bank Balance	Add	Receipts recorded, not yet credited
Bank Service Charges	Book Balance	Subtract	Monthly maintenance fees
NSF Checks (Returned)	Book Balance	Subtract	Customer checks bounced
Interest Earned	Book Balance	Add	Bank credits interest
Direct Deposits / EFT Credits	Book Balance	Add	Customer wire transfers
Automatic Loan Payments	Book Balance	Subtract	Auto-debit by bank
Collection by Bank	Book Balance	Add	Notes receivable collected
Bank Errors	Bank Balance	Add or Subtract	Misposted amounts by bank
Book Errors	Book Balance	Add or Subtract	Transposition, omission
Check Printing Charges	Book Balance	Subtract	Charged by bank quarterly
Wire Transfer Fees	Book Balance	Subtract	Outgoing wire costs
Overdraft Fees	Book Balance	Subtract	Insufficient funds penalty
Deposit Correction	Bank Balance	Add or Subtract	Bank corrects prior error
Post-dated Checks	Bank Balance	Subtract	Issued for future date

Frequently Asked Questions

A non-zero discrepancy means that after adjusting both the bank statement balance and book balance for all known reconciling items, an unexplained difference remains. This typically indicates a recording error (transposition of digits, omitted entry), a duplicated transaction, or an item categorized on the wrong side. Systematically compare individual adjusted items until the difference is isolated. A common trick: if the discrepancy is divisible by 9, suspect a transposition error.

Deposits in transit are recorded in the company books before the bank credits them. If a deposit of, say, $5,000 is made on the last business day of the month, it appears in the book balance but not on the bank statement. This inflates the apparent discrepancy. The adjusted bank balance adds these deposits back, aligning both sides. Failure to identify deposits in transit overstates the discrepancy and may trigger unnecessary error investigations.

Monthly reconciliation is the minimum standard for most businesses under GAAP. High-volume operations (e.g., retail with daily deposits exceeding 50 transactions) benefit from weekly or even daily reconciliation. More frequent reconciliation reduces the window for fraud detection from 30 days to as few as 1-2 days. The cost of delayed detection compounds: a fraudulent check undetected for 30 days may clear multiple accounts.

An NSF check was originally recorded as a deposit in the company books, increasing the book balance. When the bank returns it, the bank debits the account, but the company may not know until the statement arrives. During reconciliation, the NSF amount is subtracted from the book balance. The journal entry debits Accounts Receivable (the customer still owes) and credits Cash. If the NSF check is for $250, the adjusted book balance decreases by $250.

A transposition error occurs when two digits are swapped during recording, e.g., writing $1,350 as $1,530. The difference between the correct and incorrect amount is always divisible by 9. In this example: $1,530 − $1,350 = $180, and 180 ÷ 9 = 20. If your final discrepancy is divisible by 9, scan recent entries for swapped digits. This rule applies to any base-10 positional number system.

Yes. An outstanding check issued in January may not clear the bank until March. It should appear as a reconciling item every month until it clears. If a check remains outstanding for more than 6 months, most jurisdictions require the company to void the check and re-credit the liability. Stale-dated checks (typically older than 180 days) are not honored by banks and must be written back into the books.