Booksmrt / Cash and reconciliation

A bank reconciliation you can audit, not just approve

Most reconciliation guides end with a checklist. This one gives you the numbers, the bridge, the correcting entry, and the evidence standard a second reviewer should demand.

CLOSE FILE / 06$16,180

Two independent records.
One supported cash balance.

Open the workpaper ↓
RECONCILIATION WORKPAPERJUNE 30 · ILLUSTRATIVE

Bank statement

Ending balance
$18,410
Deposit in transit
+$1,250
Outstanding checks
−$3,480
Adjusted bank
$16,180

Company ledger

Cash balance
$16,225
Missing service fee
Not recorded
Timing entries needed
None
Corrected books
$16,225
Unexplained difference: $45

The bank side already ties. Use the statement to support one journal entry, then see whether the ledger agrees.

A bank reconciliation is complete only when the adjusted bank balance and the corrected book balance agree, every reconciling item has identifiable support, and book-side items have been posted. Matching a software screen to zero is not enough: deposits in transit and outstanding checks must clear after period-end, while bank fees, interest, and errors must be recorded in the ledger.

01

Start with two independent balances

The statement ending balance and the ledger cash balance are different evidence. The bank reports what cleared through its system by the cutoff date; the ledger reports what the business recorded. A reconciliation explains timing differences and errors without forcing either source to mimic the other.

In this worked file, the June 30 statement ends at $18,410 while the general ledger shows $16,225. That $2,185 gap is not itself an error. The question is whether named, dated items explain all of it and whether the items belong on the bank side or the book side.

Source notes: Publication 583: Starting a Business and Keeping Records

02

Build the bank-side bridge

Add deposits recorded in the books before June 30 that the bank processed in July. Subtract checks or electronic payments recorded in the books before June 30 that the bank processed later. The result is the adjusted bank balance, not a new ledger balance.

Here, a $1,250 card settlement dated June 30 reached the bank on July 1. Checks 1048 and 1051, totaling $3,480, were issued and recorded in June but cleared in July. The calculation is $18,410 + $1,250 − $3,480 = $16,180.

  • Trace the $1,250 deposit to the processor settlement and the July bank activity.
  • Trace each outstanding check to the check register, payee support, and later clearing date.
  • Escalate old items; a reconciling item is not permanent permission for a difference.

Source notes: Publication 583: Starting a Business and Keeping Records · How should I record my business transactions?

June 30 reconciliation bridgeA complete two-sided reconciliation with the journal entry separated from timing items.
LineBank sideBook sideEvidence
Ending balance$18,410$16,225June statement / June cash ledger
June 30 card deposit+$1,250—Processor batch P-0630; bank cleared July 1
Check 1048−$2,800—Vendor invoice; bank cleared July 2
Check 1051−$680—Repair invoice; bank cleared July 3
Bank service fee—−$45June statement; entry BR-0630
Adjusted / corrected balance$16,180$16,180Difference: $0
Booksmrt worked example. The amounts are illustrative; the reconciliation is arithmetically complete and every item has a defined evidence path.
03

Correct the books without plugging cash

The bank statement includes a $45 service fee that the company had not recorded. That is a book-side item: debit bank fees and credit cash for $45. The corrected ledger balance becomes $16,180.

Do not post a journal entry for the deposit in transit or the outstanding checks again. They already exist in the books. Recording them a second time would create the appearance of agreement while duplicating cash activity.

Source notes: How should I record my business transactions? · Publication 583: Starting a Business and Keeping Records

THE ONLY NEW ENTRY
Debit · Bank fees
$45
Credit · Cash
$45

Document: June statement · Posting reference: BR-0630

04

Prove the timing items after month-end

A reconciling item is a claim about what happened after the cutoff. Test that claim. The deposit should appear in the next bank period for the same amount. Outstanding payments should clear to the same payees and amounts, or remain on a documented follow-up list.

A reviewer should be able to move from the reconciliation to the June statement, ledger, deposit report, check images, and July statement without relying on a preparer's memory. The IRS recordkeeping guidance emphasizes that books should be supported by the documents created by business transactions.

Source notes: Publication 583: Starting a Business and Keeping Records

05

Review the pattern, not only the ending zero

Repeated deposits in transit may indicate a normal processor delay, but growing amounts can signal cutoff errors. Old outstanding checks may require reissuance, voiding, unclaimed-property review, or fraud investigation. Recurring unexplained bank adjustments can indicate that the account feed is incomplete.

The control objective is not merely a zero difference. It is a complete, timely, reproducible explanation of cash. Keep the reconciliation, statement, ledger detail, support for every open item, correcting entry, preparer, reviewer, and completion date together.

Source notes: Publication 583: Starting a Business and Keeping Records · What kind of records should I keep?

Try the calculator with your own amounts →

Put it into practice

  • Separate bank-side timing items from book-side corrections.
  • Never post a plug merely to make the reconciliation screen show zero.
  • Test deposits in transit and outstanding checks against the next statement.
  • Retain the evidence path and reviewer sign-off with the close package.

Scope and assumptions

  • The worked amounts are illustrative and are not client data.
  • Stale checks and unclaimed-property rules vary by state and require separate legal or tax review.
  • A reconciliation supports the cash balance; it does not prove that every payment was authorized or correctly classified.

Questions that come up

Should a deposit in transit create a journal entry?

Usually no. If it is already recorded in the ledger, it belongs on the bank side of the reconciliation until it clears. Posting it again would duplicate cash.

Why can a reconciliation show zero and still be wrong?

Unsupported plugs, duplicated entries, omitted accounts, or stale timing items can mathematically net to zero. The evidence behind each item is what makes the result reliable.

How soon should open items be checked?

Use the next available bank activity during close. Any item that does not clear in the expected window should remain visible with an owner and follow-up date.

About the evidence

We paraphrased current IRS recordkeeping guidance, constructed a two-sided illustrative reconciliation, reperformed every arithmetic step, and separated external source claims from Booksmrt's control recommendations.

The official-source captures are real. Booksmrt exercises and datasets are illustrative and contain no client records.

Sources

Educational information only. Booksmrt provides bookkeeping services, not tax, legal, audit, or investment advice. Confirm material accounting and tax decisions with the appropriate professional.