Skip to content

Daily Sales Report Template for a Small Business

A daily sales report template: sales by payment type, tax, refunds, net sales, average sale and the cash drawer, one row a day, with a free spreadsheet.

By Koa Sterling. Product specialist at TaroStack and small business owner. Yes, I am a real human, and I actually sit in front of a computer and write these articles. Reviewed November 21, 2026 · 5 min read

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

  1. Run the till's end-of-day report.
  2. Count the drawer. Set aside tomorrow's float.
  3. Fill in the row from the report and the count.
  4. Write a note if the day was unusual.
  5. 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.

Questions people also ask

What should a daily sales report include?

The date, sales by payment type, total sales, tax collected, refunds, net sales, the number of transactions, the average sale, the cash counted and whether the drawer was over or short, with a note for anything unusual.

How do you calculate net sales for a day?

Total sales less the tax collected and less refunds. In the example, $1,962.75 − $139.07 − $28.00 = $1,795.68.

What does over or short mean?

The difference between the cash counted in the drawer, after the float is taken out, and the cash sales the till recorded. A drawer $2.00 under is short. One $5.00 above is over.

We use AI to help with the research for these articles. Every one is read, checked against its sources and edited by Koa before it's published. Spot a mistake? Tell us and we'll fix it and say so. How we write these.

Let’s get your stack in order.

Get TaroStack

Sign up now for your free 14 day trial. No credit card required.