Accounting & Financial Statement Analysis Statement Preparation & Reconciliation ASC 305 cash · UCC Article 4 statement review

Bank Reconciliation Calculator

Enter your bank statement balance and your general ledger cash balance and this calculator works both columns of the reconciliation at once: deposits in transit and outstanding checks against the bank figure, then interest, collections, service charges and returned checks against the book figure. It returns the adjusted cash balance that belongs on your balance sheet, the exact journal entry your ledger still owes, and any unexplained difference — together with the divide-by-two and divide-by-nine tests that pinpoint a wrong-side posting or a transposed digit.

Calculator

This calculator runs in your browser. Enable JavaScript for live results — the inputs, formula and worked example below remain fully readable without it.

Inputs this calculator takes, with typical values
InputWhat to enterExample
Balance per bank statementThe closing balance printed on the statement for the period end, before any of your adjustments.24875.3 $
Deposits in transitReceipts you recorded and sent to the bank on or before the cut-off that do not appear on this statement.3410.0 $
Outstanding checksTotal of checks and cleared-funds payments you have issued that have not yet been presented to the bank.5120.45 $
Bank errorsSigned: enter a positive amount if the bank understated your balance, negative if it overstated it.0 $
Balance per general ledgerThe cash account balance in your books at the same cut-off date, before any reconciling entries.22342.7 $
Interest and collections by the bankInterest credited, notes collected for you, and card or ACH settlements on the statement but not yet in your ledger.1242.15 $
Service charges and feesAccount analysis fees, wire fees, per-item charges and any returned-item fee the bank has already taken.35.0 $
NSF checks returnedFace value of customer checks the bank returned unpaid; put the bank's returned-item fee in the fees field instead.385.0 $
Ledger errorsSigned: positive if your own ledger understated cash, negative if it overstated cash.0 $

It returns

  • Adjusted cash balance — The true cash figure for the balance sheet, reached from the bank statement side.
  • Adjusted book balance — The same figure reached from your ledger side. It must equal the adjusted bank balance.
  • Unreconciled difference — Adjusted bank minus adjusted book. Anything other than zero means an item is still missing.
  • Net journal entry to the ledger — The net debit or credit your cash account still needs before you close the period.
  • Net timing items at the bank — Deposits in transit less outstanding checks. These never generate a journal entry.
  • Raw gap you started with — Bank statement balance minus ledger balance, before any reconciling item.

The formula

Adjusted bank=statement balance+deposits in transitoutstanding checks±bank errors
Adjusted book=ledger balance+creditschargesNSF±ledger errors
difference=adjusted bankadjusted book=0

In plain text: Adjusted bank balance = Bank statement balance + Deposits in transit − Outstanding checks ± Bank errors

  • Adjusted bankTrue cash per the bank column — the balance-sheet figure ($)
  • Adjusted bookTrue cash per the ledger column, after the reconciling journal entry ($)
  • DITDeposits in transit: recorded by you, not yet by the bank ($)
  • OCOutstanding checks: issued by you, not yet presented ($)
  • NSFCustomer checks returned unpaid for insufficient funds ($)

The reconciliation is a two-column proof, not a single formula. Both columns start from a different recorded balance and must arrive at the same adjusted figure; the difference between them is the amount still unexplained.

Updated Category Statement Preparation & Reconciliation Verified against published test cases Reading time 13 min

What a bank reconciliation actually proves

A bank reconciliation proves that one number — cash — is right. Your ledger and the bank both claim to track the same account, they almost never agree on the closing balance, and the reconciliation explains every dollar of the gap. When it works, you get the single figure that belongs on the balance sheet as cash and cash equivalents under ASC 305, and a short list of journal entries you still owe. When it refuses to work, you have found either an error or a theft, and both matter.

The gap has exactly two causes and they behave differently. Timing differences mean both parties are right but not yet in sync: you have recorded a deposit the bank has not credited, or written a check nobody has cashed. These correct themselves and never touch your books. Recording differences mean one party knows something the other does not: the bank has taken a service charge, credited interest, collected a note, or returned a customer check unpaid. These do touch your books, and every one of them becomes a journal entry.

Cash is the account most exposed to fraud, so the reconciliation is also a control rather than just arithmetic. Standard practice is that whoever prepares the reconciliation neither signs checks nor posts cash receipts, and that a second person reviews and initials it. That separation is what makes the reconciliation evidence instead of paperwork.

Why the reconciliation has two columns instead of one formula

You cannot reconcile cash with a single equation because the two balances are wrong for different reasons. The bank column starts from the statement balance and fixes what the bank does not know yet. The book column starts from your ledger balance and fixes what you do not know yet. Both columns converge on the same adjusted figure, and that convergence is the proof.

Work out the sign of each adjustment from whose records are behind, not from memory. A deposit in transit is money you already have and the bank has not credited, so the bank balance is too low: add it. An outstanding check is money you have already given away and the bank has not yet paid, so the bank balance is too high: deduct it. On the book side, interest and collections are money the bank has already put in that you have not recorded: add them. Service charges and NSF returns are money the bank has already taken out: deduct them.

The signs of the two error lines follow the same logic. A bank error that understated your balance — a deposit posted for less than you handed over — gets added to the bank column, and you notify the bank rather than journalising it. A ledger error that understated cash — a $520 receipt posted as $250 — gets added to the book column and does need a correcting entry. Keep the two error lines separate, because only one of them ever hits your general ledger.

The order of the two columns does not matter, but the discipline does: never plug the difference. Forcing the two sides to agree with a balancing entry destroys the only control the reconciliation provides. If you genuinely cannot find a small residual, record it as a cash short-and-over item with a written explanation, and treat a recurring residual as a control failure to escalate.

Worked example: a $24,875.30 statement against a $22,342.70 ledger

A distributor closes March with a bank statement balance of $24,875.30 and a general ledger cash balance of $22,342.70 — a raw gap of $2,532.60. The March 31 deposit of $3,410.00 went into the night drop and appears on the April statement. Three checks totalling $5,120.45 are still uncashed. The statement shows $42.15 of interest, a $1,200.00 note the bank collected from a customer, a $35.00 account analysis fee, and a customer check for $385.00 returned for insufficient funds.

  1. Start the bank column. Statement balance $24,875.30.
  2. Add the deposit in transit. $24,875.30 + $3,410.00 = $28,285.30.
  3. Deduct the outstanding checks. $28,285.30 − $5,120.45 = $23,164.85 adjusted bank balance.
  4. Start the book column. Ledger balance $22,342.70.
  5. Add what the bank put in. Interest $42.15 + note collected $1,200.00 = $1,242.15. $22,342.70 + $1,242.15 = $23,584.85.
  6. Deduct what the bank took out. Analysis fee $35.00 + returned check $385.00 = $420.00. $23,584.85 − $420.00 = $23,164.85 adjusted book balance.
  7. Compare. $23,164.85 − $23,164.85 = $0. Reconciled.

Now write the entry the ledger still needs. Debit Cash $1,242.15 and credit Interest revenue $42.15 and Notes receivable $1,200.00. Debit Bank service charge expense $35.00 and credit Cash. Debit Accounts receivable $385.00 and credit Cash, because the customer still owes you that money. The net movement in the cash account is $1,242.15 − $35.00 − $385.00 = $822.15, which takes the ledger from $22,342.70 to $23,164.85. Nothing at all is journalised for the deposit in transit or the outstanding checks.

Check the arithmetic against the raw gap as a sanity test: $2,532.60 of difference = $3,410.00 in transit − $5,120.45 outstanding + $822.15 of book-side items − nothing else, and $3,410.00 − $5,120.45 + $822.15 = −$888.30... which does not equal $2,532.60. That mismatch is the point of the sign discipline: the timing items adjust the bank column downward by $1,710.45 while the book items adjust the ledger upward by $822.15, and $24,875.30 − $1,710.45 = $22,342.70 + $822.15. Always compare the two adjusted totals, never the two adjustment totals.

How to read the result: what the difference is telling you

Zero is the only acceptable answer, so treat the difference as a diagnostic rather than a result. Four tests find most residuals in under ten minutes.

Does the difference equal one of your figures exactly? Then that item is counted twice, missed entirely, or sitting in the wrong column. This is the single most common cause and the fastest to check.

Is the difference divisible by two? Half of it is the amount to hunt for. An item added where it should have been deducted moves the total by twice its value, so a $770.00 difference points at a $385.00 item on the wrong side — typically an NSF check added instead of subtracted.

Is the difference divisible by nine? Then suspect two transposed digits. Keying $5,120.45 as $5,102.45 produces a difference of $18.00, and every digit transposition produces a multiple of nine in the smallest currency unit. This calculator runs that test on the cents.

Is the difference a round multiple of ten? A decimal point or a trailing zero has probably moved: $4,300.00 keyed as $430.00 leaves $3,870.00, which is nine times $430.00 and also a multiple of ten. A single amount off by a factor of ten is called a slide.

Size matters less than persistence. A $0.02 residual from a rounded wire fee is a nuisance; the same $0.02 appearing every month means a process is broken. And a reconciliation that balances only after several rounds of edits deserves a second look, because compensating errors balance too.

Which column each reconciling item belongs in

Every reconciling item, the column it adjusts, its direction, and whether it becomes a journal entry.
Reconciling itemColumnDirectionJournal entry required
Deposit in transitBankAddNo — already in your ledger
Outstanding checkBankDeductNo — already in your ledger
Bank understated your balanceBankAddNo — notify the bank in writing
Bank overstated your balanceBankDeductNo — notify the bank in writing
Interest credited by the bankBookAddDebit Cash, credit Interest revenue
Note or receivable collected by the bankBookAddDebit Cash, credit Notes receivable
Service, analysis or wire feeBookDeductDebit Bank charges expense, credit Cash
Customer check returned NSFBookDeductDebit Accounts receivable, credit Cash
Returned-item fee charged to youBookDeductDebit Bank charges expense, credit Cash
Automatic loan or lease paymentBookDeductDebit Note payable and Interest expense, credit Cash
Your ledger understated cashBookAddDebit Cash, credit the account misposted
Your ledger overstated cashBookDeductDebit the account misposted, credit Cash

Rule of thumb: if the bank does not know about it, fix the bank column. If you do not know about it, fix your books — and that fix is always a journal entry.

You have a limited window to report a bank error

Reconciling late can cost you money, not just accuracy. Under Article 4 of the Uniform Commercial Code, a customer who is sent a statement has a duty to examine it with reasonable promptness and to notify the bank of an unauthorised signature or an alteration. Fail to do so and the loss can shift from the bank to you, particularly where the same wrongdoer forges again before you speak up. Deposit account agreements commonly narrow the window further, to 30 or 60 days.

Consumer electronic transfers run on a different and shorter clock under Regulation E, and business accounts generally do not get that protection at all. The practical rule is the same either way: reconcile every account every month, in writing, close to the statement date.

Mistakes that leave a reconciliation out of balance

  • Plugging the difference. A balancing entry with no explanation converts a control into a decoration. Leave it out of balance and investigate.
  • Journalising deposits in transit or outstanding checks. They are already in your ledger. Recording them again double-counts cash and guarantees next month fails too.
  • Sending an NSF check to bad debt expense. The correct entry restores accounts receivable, because the customer still owes you. Write it off later only if it proves uncollectible — see the bad debt expense calculator.
  • Netting an overdraft against another cash account. A negative bank balance is a short-term borrowing and belongs in current liabilities, which is why it drags on the current ratio.
  • Reconciling to the wrong cut-off. If the statement runs to the 25th and your books close on the 31st, you are comparing two different periods. Ask the bank for a calendar-month cycle.
  • Ignoring stale outstanding checks. A check uncashed for six months is usually void under the bank agreement and may be unclaimed property under state law. Escheatment deadlines are real and audited.
  • Reconciling only the operating account. Payroll, merchant settlement, escrow and petty cash accounts all need the same treatment; fraud tends to live in the account nobody reconciles.
  • Letting one person prepare, review and post. Separation of duties over cash is the reason the reconciliation exists. A reviewer who signs without recalculating adds nothing.

What a reconciliation does not catch, and what to run next

A balanced reconciliation proves that the cash account agrees with the bank. It does not prove the entries are right. Four errors survive a perfect reconciliation: a payment posted to the wrong expense account, a transaction omitted from both records, two errors that happen to offset, and a genuine but fraudulent disbursement that the bank paid exactly as instructed. Reconciling cash catches recording and timing failures; it does not catch classification failures or an authorised payment to the wrong party.

That is why the reconciliation is one step in a close, not the close. Once cash agrees, prove the ledger as a whole with the trial balance calculator, confirm the balance sheet still balances with the accounting equation calculator, and roll equity forward with the retained earnings calculator. If cash is what you are really worried about, the reconciled balance feeds straight into the cash ratio and the indirect-method operating cash flow calculator.

For larger volumes the same logic scales but the tooling changes. Bank feeds and BAI2 or ISO 20022 statement files let accounting software match transactions automatically, leaving only exceptions for a human. That does not change the arithmetic on this page; it only shortens the list you work through. And it makes the two remaining judgements more important, not less: whether an old outstanding check should still be outstanding, and whether an unexplained residual is rounding or a symptom.

Key terms

Deposit in transit
A receipt recorded in your books and delivered to the bank, but not yet credited on the statement. Adds to the bank column.
Outstanding check
A check you have issued and recorded that has not yet been presented for payment. Deducts from the bank column.
NSF check
A customer check the bank returned because the drawer had insufficient funds. It reverses your earlier cash receipt and restores the receivable.
Adjusted cash balance
The figure both columns converge on. This is the cash reported on the balance sheet, not the statement balance and not the unadjusted ledger balance.
Transposition error
Two digits keyed in the wrong order. The resulting difference is always a multiple of nine in the smallest currency unit.
Slide
A decimal point moved, so an amount is out by a factor of ten. The resulting difference is nine times the smaller of the two amounts, which makes it a multiple of nine as well.
Cash short and over
An expense or revenue account used to absorb small, documented, unexplainable cash residuals. Never a substitute for investigating a material difference.

Frequently asked questions

Which balance goes on the balance sheet, the bank balance or the book balance?

Neither — the adjusted balance does. Both starting figures are incomplete: the statement balance ignores your deposits in transit and outstanding checks, and the ledger balance ignores fees, interest, collections and returned checks the bank has already processed. Once both columns are adjusted they agree, and that single figure is your reported cash. In the worked example above it is $23,164.85, which appears in neither the statement nor the unadjusted ledger.

Do deposits in transit and outstanding checks need journal entries?

No. You already recorded both when they happened, which is exactly why they show up as differences — the bank has not caught up. Journalising them again would double-count cash and push next month's reconciliation out of balance by the same amount. Only book-side items generate entries: interest, collections, service charges, NSF returns, automatic payments and your own recording errors.

What is the journal entry for an NSF check?

Debit Accounts receivable and credit Cash for the face value of the check. The original sale stands and the customer still owes you, so the receivable comes back; nothing goes to bad debt expense unless and until you decide the amount is uncollectible. If the bank charged you a returned-item fee, debit bank charges expense for it — or debit accounts receivable if your terms let you pass the fee to the customer.

My difference is divisible by 9. What does that mean?

You have probably transposed two digits. Swapping any two adjacent digits changes an amount by nine times the difference between them, so the error is always a multiple of nine in the smallest currency unit: $5,120.45 keyed as $5,102.45 leaves exactly $18.00. Scan your entered amounts against the statement for two digits in the wrong order before checking anything else. The same test flags a slide, where a decimal point has moved.

How often should I reconcile a bank account?

Every account, every month, within a few days of the statement date. Monthly is the practical minimum because bank agreements and Article 4 of the Uniform Commercial Code both give you a limited window to report unauthorised items, often 30 to 60 days, after which the loss can shift to you. High-volume merchant, payroll and trust accounts are commonly reconciled weekly or daily, since the value of catching an error falls sharply with time.

Can a bank reconciliation balance and still be wrong?

Yes, and this is the limitation worth understanding. A reconciliation proves your cash account agrees with the bank; it says nothing about whether each payment was coded to the right expense, whether a transaction was omitted from both records, or whether two errors happened to offset. It also cannot detect a fraudulent payment the bank executed exactly as instructed. Reconciling cash is a completeness and timing control, not a classification or authorisation control.

What do I do with a check that has been outstanding for a year?

Stop carrying it as outstanding and investigate it. Most deposit agreements make a check stale-dated after six months, and the bank may refuse it. Contact the payee and reissue if the debt is real; if the payee cannot be found, the amount is usually unclaimed property under your state's escheatment statute, with its own reporting deadlines. What you must not do is write it back to income to make the reconciliation tidy — the liability to the payee still exists.

How is a bank reconciliation different from a proof of cash?

A bank reconciliation ties two ending balances at a single date. A proof of cash, sometimes called a four-column reconciliation, ties beginning balances, receipts, disbursements and ending balances for the whole period, so it also proves that the total cash in and out agrees. Auditors use a proof of cash when they suspect unrecorded receipts or disbursements — a plain reconciliation can balance even when both sides are missing the same transaction.

Why is my bank balance always higher than my book balance?

Because outstanding checks usually exceed deposits in transit. You record a payment the moment you write the check, while the bank does not deduct it until someone deposits it, so at any cut-off the bank still shows money you have already spent. A business that pays by check will show a bank balance above its ledger balance almost every month. If the pattern reverses persistently, look at whether deposits are being held before they reach the bank.

References

  • Uniform Commercial Code, Article 4 — Bank Deposits and Collections (customer's duty to examine statements and report unauthorised items) — American Law Institute and Uniform Law Commission
  • FASB Accounting Standards Codification Topic 305, Cash and Cash Equivalents — Financial Accounting Standards Board
  • Regulation CC — Availability of Funds and Collection of Checks, 12 CFR Part 229 — Board of Governors of the Federal Reserve System
  • Intermediate Accounting, 18th ed. — cash and cash controls — Wiley (Kieso, Weygandt and Warfield)