A daily sales report is one row for each day you trade, filled in at closing, that answers four questions while the day is still fresh. How much did we sell, and by which kind of payment? How much of that was tax and refunds, which aren't ours to keep? How many sales was it, and what was the average? And does the cash in the drawer match what the till says it took? Each answer takes a number or two from the till's end-of-day printout. Written down every day, they turn into the things a small business can't see otherwise: which days are worth opening for, whether the average sale is moving, and the exact day a deposit went missing. Below is a report for a made-up cafe, what each column is for, and the template.
The short version
- One row a day, filled in at closing, before anyone goes home.
- Sales split by cash, card, and online or other.
- Tax collected and refunds come off to give net sales.
- Transactions, and the average sale.
- Cash counted against cash sales: over or short.
- A note for anything unusual: weather, an event, a broken card reader.
- TaroStack tracks what was made and what it cost, beside what was sold. More below.
An example
| Date | Cash | Card | Online | Total | Tax | Refunds | Net sales | Sales | Average | Over or short |
|---|---|---|---|---|---|---|---|---|---|---|
| Nov 16 | $412.50 | $1,386.25 | $164.00 | $1,962.75 | $139.07 | $28.00 | $1,795.68 | 143 | $12.56 | −$2.00 |
| Nov 17 | $388.00 | $1,522.75 | $210.50 | $2,121.25 | $150.24 | $0.00 | $1,971.01 | 151 | $13.05 | $0.00 |
| Nov 18 | $455.25 | $1,701.00 | $98.00 | $2,254.25 | $159.72 | $45.50 | $2,049.03 | 162 | $12.65 | $5.00 |
The tax figures are made up for the example. Use your till's.
What each column is for
Cash, card, online. Each is checked against something different. Cash against the drawer. Card against the processor's deposit. Online against the platform's payout. Keeping them apart is what lets you find a missing $400: you look for the day the card column and the deposit disagree.
Total sales is the three added up, and it should equal the till's own total. If it doesn't, something was keyed under the wrong payment type.
Tax collected was never your money. It comes off before you call anything sales.
Refunds come off as well, on the day they're given.
Net sales is total sales less tax and refunds: what the business earned that day.
Transactions and average sale. Net sales divided by the number of sales. November 17 had more customers than the 16th and a higher average, $13.05 against $12.56. If the average drifts down over a month while the count holds, people are buying less each visit, and that's a different problem from fewer people coming in.
Over or short. Count the drawer, take out the opening float, and compare what's left with the till's cash sales. On the 16th the drawer was $2.00 short. On the 18th it was $5.00 over, which the note explains: a tip left in the drawer. A few dollars either way is ordinary. The same person short on the same shift every week isn't.
The closing routine
- Run the till's end-of-day report.
- Count the drawer. Set aside tomorrow's float.
- Fill in the row from the report and the count.
- Write a note if the day was unusual.
- Put the cash for deposit in a marked bag with the amount on it.
Do it in the same order every night. A fuller checklist for the end of the day is in opening and closing checklist for a kitchen.
What to do with a month of rows
- Add up by weekday. A cafe that nets $1,800 on Mondays and $2,600 on Saturdays staffs them differently.
- Match deposits. Tick each card total against the processor's deposit, and each cash bag against the bank.
- Forecast. Last year's rows for the same weeks are the best guess at this year's: see sales forecast template.
- Set it beside cost. Net sales less what the goods cost is what's left: see what is a good food cost percentage and food inventory template.
Get the template
Download the daily sales report. One sheet and a read-me: type the till's figures and the cash you counted, and the sheet works out total sales, net sales, the average sale and over or short. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
The report says what came in. It says nothing about what went out to earn it. A $2,254 Saturday that used $900 of food is a better day than a $2,400 one that used $1,200, and the sales report can't tell them apart. For that you need what was made, what it was made from and what those ingredients cost, on the same day.
How TaroStack does it
TaroStack keeps the cost side that a sales report leaves out.
Every batch is costed from what it used, at what you paid for it.
Margins by product, on real cost, so you know which of the things you sold a lot of made money.
Stock value by month, and a count that shows what a difference is worth.
Receiving records what came in and what it cost, so a rise in a supplier's price shows before the month ends.
It connects to Square.
| The question | Sales report | In TaroStack |
|---|---|---|
| What did we take | Yes | No: that's the till's job |
| What did the goods cost | No | From each batch |
| Which products make money | No | Margin by product |
| What's left on the shelves | No | Stock, kept current |
TaroStack doesn't run the till, take payments or reconcile deposits. Recipes, batches, costs and margins are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
