Daily Cash-Up Sheet: Free Template and How to Use It

A cash-up sheet is a one-page form you fill in at closing time: what was in the till this morning, what the till says you sold, what is physically in the drawer now, and whether those numbers agree. It takes under ten minutes once it becomes habit, and it is the single cheapest control a cash-handling business can have. This page gives you the sheet for free — as a printable page and as a spreadsheet — and shows you exactly how to use it, including what to do on the nights the numbers refuse to match.

Why count the till every single day

Because errors don't announce themselves — they accumulate quietly. A €5 note given as change instead of €10. A card sale rung up as cash. A supplier paid from the drawer and never written down. Each one is small; a month of them is a hole. Here is the arithmetic that convinces most owners: if your till drifts by just €6 a day — one bad change-giving, one forgotten note — that is roughly €180 a month and over €2,000 a year, vanished without a single dramatic event. Daily counting doesn't prevent every error, but it shrinks the search window from 'sometime this month' to 'today, between open and close'. A discrepancy found the same day is a puzzle; found three weeks later, it's just a loss. There is also a quieter benefit: staff behave differently in a shop where everyone knows the drawer is counted every night. Not because anyone is accused of anything — but because ambiguity is where both honest mistakes and bad habits live, and daily counting removes the ambiguity.

Download the cash-up sheet (print and spreadsheet)

The template is free and comes in two formats. The printable version fits one day per page — many owners print a month's worth, clip them to a board by the till, and file completed sheets in a folder. The spreadsheet version (Excel and Google Sheets) has one row per day and calculates the expected total and the difference automatically, so a month becomes one readable page. Both versions carry the same fields: date and counted-by at the top; opening float; a denomination grid for counting notes and coins; card terminal total; cash paid out during the day; expected cash; actual cash; and the difference, with two lines to note the likely reason. Use whichever version you will actually touch at 7 p.m. — the paper one has a surprising advantage: it is always exactly where the money is.

Step by step: from float to final figure

• Write the date and the name of whoever is counting. If the numbers are off next Tuesday, you'll want to know who to ask — not to blame, but because they may remember the odd transaction.
• Note the opening float — the amount the till started with this morning. If your float is a fixed €100 every day, this becomes automatic; fixed floats are strongly recommended for exactly this reason.
• Count the drawer using the denomination grid: how many €50 notes, how many €20s, and so on down to the coins. Counting by denomination is faster and far more accurate than counting a mixed pile.
• Write the day's cash sales total from your till or your sales log, and the card total from the terminal's end-of-day report. Keep them separate — mixing them hides errors.
• List any cash paid out of the drawer today: the €15 to the window cleaner, the €8 courier. These are the most commonly forgotten numbers in every shop.
• Calculate expected cash: opening float, plus cash sales, minus cash paid out.
• Compare expected with counted. Write the difference — even when it is zero. A page of recorded zeros is what makes the one €40 gap impossible to ignore.
• Set aside tomorrow's float, bag the rest for banking or the safe, and sign the sheet. Done — usually in eight minutes.

What to do when the numbers don't match

First: don't panic, and don't round it away. Small differences happen in every cash business on earth. Recount once — miscounting the count is the most common cause of all. Then check the usual suspects in order: a card sale recorded as cash (compare the terminal report with your sales log), a paid-out that never got written down (ask everyone who worked today, kindly), and a change-giving error at a busy moment. If the gap survives all that, write it down honestly — 'short €7.50, cause unknown' — and move on. One unexplained shortage is noise. The sheet's real power appears over time: a pattern of shortages on the same shift, the same weekday, or the same size is signal, and you can only see a pattern if you recorded the noise. Set yourself a tolerance — many small shops use €2 to €5 — below which you note the difference and let it go without an investigation. The goal is a trustworthy record, not a nightly interrogation.

Turning daily counts into a weekly picture

Once daily counting is routine, the sheets start paying a second dividend: trend data. Every Sunday, spend five minutes reading the week's seven sheets side by side (the spreadsheet version does this automatically). Three questions get answered fast. Which days actually carry your week — is Saturday really your best day, or does it just feel busiest? What share of your money arrives in cash versus card — this shifts every year, and it changes how much float and banking you need. And are differences trending anywhere — seven small shortages that lean the same direction are worth a closer look, while random small wobbles in both directions are just life. Owners who do this for a couple of months consistently report the same surprise: the shop they thought they had and the shop the sheets describe are not quite the same shop. The sheets are how you find out which one is real.