Close Your Register in Five Minutes: The Daily Cash Count Template

The five-minute close, every night, by anyone

Closing a drawer is a ritual with one rule: the process has to be identical no matter who's counting. The moment each closer counts their own way — some by denomination, some by eyeballing a pile, some "we'll count it in the morning" — over/short numbers stop being comparable and start being noise. A good count sheet is less about math than about making the same five minutes happen every single night.

The Daily Cash Count template in CashSheet Workbooks is that ritual, pre-built. Here's the walkthrough.

Step 1: Count what's physical

Create a workbook from the Daily Cash Count template and you get a Count sheet with a row per denomination — $100, $50, $20, $10, $5, $1, then quarters, dimes, nickels, pennies. Each row has the face Value already filled in, a Count column, and a computed Total: ={Value} × {Count}.

The closer's entire job is the Count column. Twelve twenties? Type 12, and the row shows $240.00 before your hand leaves the key. No calculator, no mental math at 11 PM, no arguing later about whether 12 × 20 is 240 — the formula column can't be typed over, so the arithmetic is simply not up for debate.

Step 2: Reconcile against expected

The template's second sheet, Reconciliation, holds four lines: opening float, expected cash in drawer, counted cash, and over/short. Expected comes from your register's Z-report (or from CashSheet POS, which already tracks drawer floats and end-of-day totals); counted comes from the sheet you just filled. The difference is the number the morning manager reads first.

Because every amount is stored as exact integer cents — never spreadsheet floating point — a $0.03 short is a real three cents, not rounding noise. Small overs and shorts are normal; patterns of them are information. Same drawer, same shift, same direction: that's what the log exists to surface.

Step 3: Keep the history honest

One workbook per register, one dated count per close. The history accumulates in place — sortable and filterable by any column, so "show me every short over $5 this month" is a filter, not an archaeology project. Petty cash payouts that came from the drawer belong in the companion Petty Cash Log template, with the receipt photographed and attached to the row it explains — at audit time the answer is a download, not a shoebox.

Why not just Excel?

You can absolutely run this in Excel — most businesses have. The template earns its place with the guardrails Excel can't hold on its own: formula columns that can't be overwritten with a hard number, currency cells that refuse text and store exact cents, dropdowns that keep categories to a closed list, and one shared workbook instead of nine forked files. And nothing is locked in — any sheet exports to CSV or Excel whenever you want it.

Try it against tonight's close

Open Workbooks, create a workbook from Daily Cash Count, and run it side by side with your current close. If the totals argue with your paper sheet — trust the one where the multiplication is a formula. Where this goes next: expected-drawer figures flowing straight from CashSheet POS, so the only human input in the whole close is the physical count itself. If that workflow matters to you, tell us about your setup.