What Is a Cash Sheet? Daily Cash Counts, Petty Cash Logs, and Cash Books Explained
One question, asked daily
A cash sheet is a daily financial log that records cash movements — opening balance, cash received, cash paid out, closing total — so a business can answer one question with confidence: is the cash that should be here actually here? When the answer is no, the cash sheet is also the document that says by how much, since when, and at which drawer.
It's one of the oldest controls in retail and food service, and it earns its keep the first time a drawer comes up short. Businesses that skip it don't have fewer discrepancies — they just find out later, when the trail is cold.
The three classic cash sheets
- Daily cash count sheet. The end-of-shift reconciliation of a physical register drawer. Count every denomination — bills and coins — multiply by face value, sum it, and compare against what the register says should be there. The difference is the over/short, and it's the number managers actually watch. We wrote a full walkthrough of the counting workflow.
- Petty cash log. The running record of the small cash box: who took cash out, for what, with which receipt, and what's left. The failure mode isn't fraud so much as evaporation — five undocumented coffees and a missing receipt at a time.
- Cash book (digital cash sheet). The generalized version: dated entries with cash in (debits) and cash out (credits) and a net position. It's the bridge between "counting the till" and proper bookkeeping — many small businesses run their whole cash picture on one.
What a good cash sheet requires
Every version shares the same skeleton: a dated row per event, an expected figure, an actual figure, and arithmetic connecting them. The quality bar is about protecting that arithmetic:
- The math must be beyond argument. A denomination row is face value × count. The moment someone can typo a total, the sheet stops settling disputes and starts creating them. Computed columns beat mental math.
- Cents must be exact. Spreadsheet floating-point is notorious for shaving pennies off large sums. A reconciliation document that's wrong by a cent is wrong — an honest cash sheet stores money in exact cents, not approximations.
- Categories must be closed lists. "Ofice", "office", and "Office supplies" are three categories to a spreadsheet and one to a human. Dropdowns with defined choices keep month-end grouping honest.
- Receipts must live with entries. A petty cash log that says "see shoebox" isn't an audit trail. The receipt belongs attached to the row it explains.
- Yesterday must be tamper-evident. Over/short only means something if last Tuesday's sheet still says what it said last Tuesday.
The Excel trap
Excel can do all of this — on day one. The trouble is day ninety: a formula gets overwritten with a hard number and nobody notices; an amount typed as text silently drops out of a SUM; the file forks into cash_count_FINAL_v3.xlsx; and the one person who understands the sheet goes on vacation. None of these are Excel bugs. They're what happens when a control document has no guardrails.
Templates with the guardrails built in
This is exactly the job we built CashSheet Workbooks for. The three cash sheets above ship as one-click templates: the Daily Cash Count with the full denomination counter and computed totals, the Petty Cash Log with dropdown categories and receipts attached to each row, and the Cash Book with a computed net per entry. Currency cells store exact integer cents, formulas can't be typed over, and everything imports from and exports back to CSV or Excel. Open Workbooks and start from a template — the count math is already done.
