Cash drawer balance sheet: reconcile daily cash

A cash drawer balance sheet compares the bills and coins counted at closing with the cash that should remain after the day's transactions. It identifies an overage or shortage and preserves the records needed to investigate it. This is a daily business cash control; the company's cash balance sheet answers a different reporting question.

Set the boundary before counting

Use one worksheet for one location, drawer, and session. Record the business date, opening and closing times, drawer identifier, preparer, and reviewer. A shared store total makes it harder to establish when a difference arose.

Define cash receipts as physical cash received, including sales tax collected in cash. Exclude card, electronic, gift-card, and check tenders from this physical cash calculation. Reconcile those separately to their own supporting records.

The IRS daily cash receipts example uses the register tape or cash sales slips and distinguishes receipts from the beginning change fund. Preserve that distinction here: float funds the drawer but is not current-day sales.

Expected closing cash = Opening float + Cash receipts - Cash refunds - Authorized payouts - Cash drops

Drawer variance = Counted closing cash - Expected closing cash

A positive variance means over; a negative variance means short. All deductions below are entered as positive amounts and subtracted once.

Copy this worksheet layout

Put the field names in column A and their values or formulas in column B. Keep the supporting register report, refund references, payout approvals, and drop receipts with the completed sheet. These are example worksheet cells, so the formulas remain usable without a separate download.

This example is one US retail location on October 22, 2026. Its cash-handling policy permits the documented payout. If your policy prohibits drawer payouts, do not introduce them; investigate any such payment as an exception.

The $1,200 cash drop has already left the drawer before the final count. It reduces expected drawer cash, yet remains part of the session's cash to be deposited. A drop is a custody transfer, not an operating expense.

Count independently and fill the sheet

First, verify the opening float against the prior signed handover. Then obtain the cash-tender detail and identify whether refunds are already netted into its total. This layout assumes gross receipts and a separate cash refund deduction.

Next, match each payout and drop to its evidence. Count the remaining bills and coins without changing the transaction totals to match the physical result. A denomination schedule provides a reproducible count:

In a separate count area, put denomination in D2:D6 and quantity in E2:E6. The total feeding B8 is:

=SUMPRODUCT(D2:D6,E2:E6)

Expected closing cash is 200.00 + 1,842.50 - 42.50 - 25.00 - 1,200.00 = $775.00. The physical count is $770.00, making the variance 770.00 - 775.00 = -$5.00. The drawer is short by $5.00. All amounts use exact cents; no rounding adjustment is needed.

Prove the deposit bridge

The closing count leaves 770.00 - 200.00 = $570.00 available for the final deposit. Add the earlier $1,200.00 drop to obtain $1,770.00 of session cash for deposit, assuming that drop is also destined for the bank.

With opening and retained float equal, a second calculation must agree:

Session cash for deposit = Cash receipts - Refunds - Payouts + Drawer variance

The check is 1,842.50 - 42.50 - 25.00 - 5.00 = $1,770.00. The register movements before the shortage total $1,775.00; the $5.00 difference explains why the physical deposit is lower.

This proves the worksheet's bridge, not that the bank received the money. Match drop references and the closing deposit to the deposit confirmation separately. Penn State's change-fund procedure likewise separates the change fund from the cash being prepared for deposit.

Compare completed logs across locations

Combine completed sheets using one row per drawer session. Preserve the sign of every variance and add its absolute value in a separate column. Consider these subsequent review rows:

The net variance is zero, but Store A has $8.00 of shortages and Store B has $8.00 of overages. The $16.00 absolute total preserves the size of the differences. Investigate the separate sessions rather than treating the company total as proof that everything balanced.

Where it goes wrong

• Subtracting refunds twice. A net cash-tender report already includes them. Use gross receipts with a separate deduction, or net receipts without it.
• Forgetting a cash drop. Money moved to the safe is absent from the closing drawer count and needs its own documented deduction.
• Mixing float with sales. Keep both the opening float and retained closing float explicit.
• Netting unrelated shortages and overages. Preserve drawer and session detail before aggregating.
• Replacing evidence with a balancing entry. Keep the original count, document corrections, and obtain independent review. Penn's cash-control guidance calls for daily reconciliation, retained documentation, and supervisory review.

An unresolved difference on this sheet needs transaction and count investigation. A corporate balance sheet that does not balance requires a separate ledger reconciliation; changing the cash accounting basis does not resolve a drawer shortage.

Compare your daily cash logs in Covirage

Upload your completed drawer logs as a file, preserving location, date, expected cash, counted cash, and documented movements. Covirage maps the columns, and its tools compute and check the reconciliation figures; the external AI model explains recurring differences with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.

See Covirage for spreadsheet analysis for the supporting file-analysis context.