How To Build A Daily Cash Count Sheet

1. Decide What The Sheet Proves

Before designing anything, write down what you will use it for. Proving a deposit composition, supporting a variance investigation, evidencing segregation of duties and satisfying an auditor are different jobs, and a sheet built for all four without thought becomes long enough that it is completed carelessly.

Keeping It Completable

Aim for something a tired cashier finishes accurately in two minutes. Every field you add costs completion quality across every sheet, so each one has to earn its place by answering a question you will genuinely be asked.

• Write the purpose down before designing the layout.
• Target two minutes of completion time.
• Remove any field you cannot name a use for.
• Test it with the person who will complete it daily.

2. Head It With Business Details

Business or site name, till or location identifier, the date, the shift and the trading period covered. A sheet without an identifier is unfilable, and a sheet without a shift cannot support any variance investigation involving more than one person.

Making Filing Work

Use a consistent naming pattern so sheets sort correctly, typically date first then location then shift. Consistency matters more than the specific format, because it is what lets someone retrieve a specific sheet in seconds rather than searching a folder.

• Identify site, till, date, shift and period.
• Use one consistent naming pattern across all sheets.
• Put the identifier where it is visible when filed.
• Match the naming to your saved count labels.

3. List Denominations In Order

Pre print every denomination in a fixed order, highest to lowest, notes then coins. Pre printing prevents a row being forgotten, and a fixed order makes two sheets directly comparable without reading the labels each time.

Handling Duplicate Values

Where a face value circulates as both a note and a coin, give it two clearly labelled rows. Merging them saves a line and destroys the sheet usefulness for deposit preparation, since notes and coins are strapped, bagged and banked entirely differently.

• Pre print every denomination rather than leaving blank rows.
• Keep one fixed order across all sheets.
• Separate note and coin rows for duplicate face values.
• Include a line for other cash and one for unfit notes.

4. Leave Room For Quantities

The quantity column is the one people actually write in, so give it space. Cramped boxes produce ambiguous digits, and an ambiguous seven or one on a count sheet is exactly the kind of thing that gets misread during a later review.

Writing Versus Printing

Where the count is done on screen, printing the completed report is better than transcribing figures onto a paper form. Transcription introduces a second chance to make an error and adds nothing, so keep handwritten sheets for sites without a device.

• Give the quantity column generous width.
• Avoid transcribing screen figures onto paper by hand.
• Print the completed report where a device is available.
• Keep a blank paper version as a fallback.

5. Show Subtotals Not Just A Total

Each row needs its own subtotal. This is what makes the sheet auditable, because a query can be narrowed to one denomination instead of forcing a full recount. A sheet showing quantities and a single grand total is much weaker than it looks.

Why It Matters Later

When a bank credits a different figure, the subtotal column is what lets you say which denomination is in dispute. Without it you can only argue about a total, which almost always ends with the bank figure standing. See preparing a business bank deposit.

• Include a subtotal column beside every quantity.
• Show note and coin totals separately.
• Show the piece count as well as the value.
• Keep the grand total visually distinct.

6. Add The Expected Cash Line

Include a clearly labelled expected cash figure and a variance line beneath the total. Label it explicitly as cash only, because the single most common reason a sheet produces a meaningless variance is an expected figure that quietly included card settlements.

Space For The Explanation

Leave two or three lines for a written note on the variance. That note is what makes the sheet useful during a review weeks later, when nobody remembers the evening and a bare number invites suspicion. Investigation order is in over or short causes and fixes.

• Label the expected figure as cash only.
• Show the variance as its own line with a direction.
• Leave room for a written explanation.
• Include space to list refunds and paid outs.

7. Include Signature Blocks

Counted by, verified by and the date and time of the count. Two signatures evidence segregation of duties, and the time distinguishes the count from the trading period, which matters when a shift crosses midnight or a drawer is counted the following morning.

Making Signatures Mean Something

Print the name alongside the signature, since signatures are frequently unreadable. A verifier should have looked at something specific before signing, so a small tick box confirming a spot recount turns the signature into evidence rather than decoration.

• Provide counted by, verified by and date and time.
• Print names alongside signatures.
• Add a tick box confirming a spot recount was done.
• Never allow one person to sign both lines.

8. Set A Retention Rule

Decide how long sheets are kept and where, then write it on the procedure rather than leaving it to whoever manages the filing cabinet. Retention periods are usually driven by tax and accounting requirements that differ by jurisdiction and by document type.

Digital Versus Paper

A CSV export or PDF is easier to retain, search and back up than paper, provided the storage itself is durable and access is controlled. Where signatures are required in wet ink, keep the paper original and the digital copy together.

• Write the retention period into the procedure.
• Follow local accounting and tax requirements.
• Store digitally with a backup where signatures allow it.
• Keep the count sheet with its sales and deposit records.

Worked Example

A four block layout covering a single till for a single shift. Everything below the denomination table fits on a third of a page, which keeps completion realistic.

Printing the report from the Change Counter calculator produces the first four blocks automatically with the sign off lines included, so the only handwriting needed is the variance explanation and the signatures.

Final Checklist

1. Write down what the sheet needs to prove.
2. Head every sheet with site, till, date and shift.
3. Pre print all denominations in one fixed order.
4. Separate note and coin rows for duplicate values.
5. Include a subtotal beside every quantity.
6. Add a cash only expected figure and a variance line.
7. Provide counted by and verified by blocks with printed names.
8. Set and document a retention period.

Design it once, test it for a week with the people completing it, then fix whatever they had to ask about. A sheet that survives that process will still be in use in a year.

Frequently Asked Questions

Is a printed report enough, or do we need a separate form?

A printed denomination report with sign off lines covers most of what a count sheet needs. Add a separate form only if you require fields the report cannot carry, such as a specific refund breakdown or an internal reference. Avoid transcribing figures between the two.

Should the sheet include card takings?

Keep card figures off the cash count sheet and reconcile them separately against the terminal settlement. Mixing them is the most common reason a count sheet produces a variance nobody can explain, because the expected figure stops representing cash alone.

How long should count sheets be retained?

That depends on your jurisdiction and on whether the sheet supports a tax relevant record, so check with your accountant rather than adopting a general figure. Whatever period you choose, write it down and keep the sheets with the related sales and deposit paperwork.

Put It Into Practice

Take your current sheet and remove every field nobody has looked at in the past year. Shorter forms get completed properly, and a properly completed short form beats a long one filled in from memory.

Keep reading: Event Cash Reconciliation For Tickets And Donations, Restaurant Cash Drawer Closing Guide For Managers, How To Count Cash On Your Phone Accurately, Common Cash Counting Errors And How To Stop Them. The full cash counting guide library collects all fifteen walkthroughs, and the Change Counter calculator is always one click away.