How this instrument works
A bank statement balance and a company's own cash ledger almost never agree on any given day, and neither one is wrong. The gap is timing: money the company has already recorded moves through the bank on its own schedule. A deposit made on the last afternoon of the month might not post at the bank until the next business day. A check mailed to a vendor sits in the mail, then in the vendor's stack of bills to process, before it ever reaches the bank for payment. Bank reconciliation is the routine that closes that gap — it takes the bank's number and adjusts it for exactly those in-flight items until it matches what the books already say.
This instrument works the two adjustments that account for most of the gap in a normal month. Deposits in transit are amounts the company has recorded as received but the bank has not yet processed, so they get added back onto the bank's balance. Outstanding checks are amounts the company has recorded as paid but the payee has not yet cashed, so they get subtracted from the bank's balance. What is left is the adjusted, or true, cash position — the figure a bookkeeper signs off on before closing the books for the period.
A full month-end reconciliation done by an accountant also checks for bank service charges, interest earned, NSF (bounced) checks from customers, and outright bank or ledger errors — each requires its own line and its own correcting entry. This calculator isolates just the timing math so you can see how deposits in transit and outstanding checks move the number; it is a teaching and estimating tool, not a substitute for matching every transaction line by line against a real statement.
- Enter the balance shown on the bank statement in Bank statement balance, $.
- Enter Deposits in transit, $ — money the books show as received that has not yet cleared the bank.
- Enter Outstanding checks, $ — payments the books show as sent that have not yet been cashed.
- Read Adjusted (true) cash balance — the figure that should match the company's own ledger.
Worked example — closing the books at month-end
A small business's bank statement shows $15,000 at month-end. The bookkeeper's own ledger, though, already reflects a $1,200 customer deposit made on the final business day — too late for the bank to post before the statement cut — and two vendor checks totaling $800 that were mailed out but sit uncashed in the payees' inbox. Neither figure is a mistake; they simply have not finished moving through the banking system yet.
Reconciling means starting from the bank's $15,000, adding the $1,200 still in transit, and subtracting the $800 not yet cashed: 15,000 + 1,200 − 800 = $15,400. That $15,400 is the adjusted balance, and it is the number that should match the company's cash ledger before the books are closed for the period — if it does not, the difference points to an unrecorded fee, an error, or a transaction someone missed.
Questions
Why doesn't the bank statement match my books in the first place?
Timing. The bank only knows about a deposit or a check once it physically processes it, while your books record the transaction the moment you write the check or make the deposit. Mail time, bank processing cutoffs, and a payee who hasn't gotten around to cashing a check all create a lag — the two records catch up to each other, they just aren't in sync on any single day.
What counts as a deposit in transit?
Any deposit your books already show as received — cash, checks from customers, an end-of-day bank drop — that the bank has not yet posted to the account as of the statement date. It typically clears within one to two business days and should appear on the next statement without you doing anything further.
What counts as an outstanding check?
A check you have written and recorded in your ledger as paid, but that the recipient has not yet deposited or cashed. Checks can sit outstanding for weeks; a check outstanding for six months or more is often flagged as stale and may need to be voided and reissued rather than left open indefinitely.
What does this calculator leave out?
Bank service charges, interest the account earned, NSF (bounced) checks from customers, and bank or bookkeeping errors. A complete month-end reconciliation records each of these as its own adjusting entry; this instrument isolates only the two timing differences — deposits in transit and outstanding checks — that drive most of the everyday gap.
Why do businesses bother reconciling every month?
It is the standard internal control against both honest error and fraud: a missing deposit, a duplicated payment, or an altered check tends to surface the moment someone lines the bank's record up against the company's own. Auditors and lenders routinely expect to see a monthly reconciliation on file, and skipping it lets small discrepancies compound unnoticed.
What if the adjusted balance still doesn't match my books after this?
Check for the items this tool excludes — an unrecorded bank fee, interest credited but not yet logged, an NSF check reversing a deposit, or a data-entry slip on either side. Work through the bank statement line by line against the ledger; the unmatched amount is almost always traceable to one specific transaction rather than a systemic problem.
References
- SEC Investor.gov — Understanding financial statements and bookkeeping basics
- U.S. Small Business Administration — Manage your finances
- FDIC — Consumer resources on checking accounts and deposits
Read this first: This instrument shows arithmetic, not advice. Real offers add fees, taxes and terms that vary by lender and place — verify the figures against your actual paperwork before deciding anything.