Cash count template
Count the cash by denomination, compare it with what the POS recorded and document every overage or shortage. Count online or download the template for Excel or Google Sheets.
- Excel and Google Sheets
- US dollars and Latin American currencies
- History by cashier

Count your till online
| Denomination | Quantity | Total |
|---|---|---|
| $100.00 | $0.00 | |
| $50.00 | $0.00 | |
| $20.00 | $0.00 | |
| $10.00 | $0.00 | |
| $5.00 | $0.00 | |
| $1.00 | $0.00 |
| Denomination | Quantity | Total |
|---|---|---|
| $1.00 | $0.00 | |
| $0.50 | $0.00 | |
| $0.25 | $0.00 | |
| $0.10 | $0.00 | |
| $0.05 | $0.00 | |
| $0.01 | $0.00 |
What the template includes
Shift cash count
Count by bill and coin, card terminal slips, transfers and gift cards, expected cash from the POS and the result: balanced, over or short.
Cash count log
Record every count and summarize how many had a difference, total overages and shortages, and shortages by cashier.
Currencies by country
Denominations for the United States, Colombia, Mexico, Peru, Chile and Ecuador, ready to use and editable.
How to use it
Enter what the system says
Record the opening float, cash sales, cash refunds, cash drops and petty cash paid out during the shift.
Count the cash
Enter how many bills and coins of each denomination are in the drawer, plus card slips, transfers and gift cards.
Review the difference and sign
The template calculates expected cash and the difference. If the drawer is over or short, add a note and the signatures.
Frequently asked questions
What is a cash count?
It is the physical count of the money in a till, compared with what the system says should be there. It catches shortages, overages and errors before they pile up.
How is expected cash calculated?
Opening float plus cash sales, minus cash refunds, cash drops and petty cash paid out. The difference between that amount and the counted cash is the overage or shortage.
How often should you count a till?
At least at the end of every shift or day. Many retailers also run surprise counts during the shift, especially on tills with frequent differences.
What should I do if the drawer is short?
Count again, review the shift's voids, refunds and cash drops, and record a note signed by the cashier and the supervisor. If it repeats on the same till or cashier, investigate it.
Does it work in Google Sheets?
Yes. It only uses formulas supported by both Excel and Google Sheets. The Google Sheets button creates a copy in your account.
Balancing the tills of many stores every day?
Quantum matches every till's cash count with what the cash-in-transit carrier collects and what the bank deposits, and shows each shortage with the point where it started.