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

Bills
DenominationQuantityTotal
$100.00$0.00
$50.00$0.00
$20.00$0.00
$10.00$0.00
$5.00$0.00
$1.00$0.00
Coins
DenominationQuantityTotal
$1.00$0.00
$0.50$0.00
$0.25$0.00
$0.10$0.00
$0.05$0.00
$0.01$0.00
From the system (POS)

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

  1. Enter what the system says

    Record the opening float, cash sales, cash refunds, cash drops and petty cash paid out during the shift.

  2. Count the cash

    Enter how many bills and coins of each denomination are in the drawer, plus card slips, transfers and gift cards.

  3. 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.