Daily sales report template
A free Excel sheet for closing the day. Enter gross sales, discounts, refunds and orders for each store or channel, then what came in by card, cash and other payments. The sheet calculates net sales, average order and the difference between sales and payments, so a short cash drawer shows up the same day.
What's in the sheet
Sample rows. Shaded columns calculate themselves.
| Date | Store or channel | Gross sales | Discounts | Refunds | Net sales | Orders | Avg order | Card | Cash | Other | Payments | Difference | Closed by | Notes |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2026-09-15 | Downtown store | $4,820.50 | $212.00 | $45.00 | $4,563.50 | 118 | $38.67 | $3,890.25 | $610.25 | $63.00 | $4,563.50 | $0.00 | Mia | |
| 2026-09-15 | Airport kiosk | $1,975.00 | $40.00 | $0.00 | $1,935.00 | 96 | $20.16 | $1,720.00 | $180.00 | $20.00 | $1,920.00 | $15.00 | Jordan | Cash is $15 short. Recount before the deposit. |
| 2026-09-15 | Web store | $3,310.80 | $150.80 | $120.00 | $3,040.00 | 41 | $74.15 | $0.00 | $0.00 | $3,040.00 | $3,040.00 | $0.00 | Mia | Paid through the store checkout |
What each column is for
- Date
- The business day you are closing.
- Store or channel
- The store, kiosk or online channel.
- Gross sales
- Sales before discounts and refunds.
- Discounts
- Discounts given.
- Refunds
- Refunds given.
- Net salesCalculated
- Gross minus discounts minus refunds.
- Orders
- Number of tickets or orders.
- Avg orderCalculated
- Net sales divided by orders.
- Card
- Card payments from the processor report.
- Cash
- Cash you counted, not what the register expects.
- Other
- Gift cards, delivery apps, online checkout.
- PaymentsCalculated
- Card plus cash plus other.
- DifferenceCalculated
- Net sales minus payments. It should be zero.
- Closed by
- Who closed the day.
- Notes
- The reason for any difference.
How to use it
- 1At close, take gross sales, discounts, refunds and orders from the POS or channel report.
- 2Count the cash drawer and enter the counted amount, then card and other totals from the processor.
- 3Check Difference. Anything other than zero gets a note before the deposit.
- 4The Total row adds up every location for the day.
Where the spreadsheet stops helping
- Every store reports in its own way: a photo of the end-of-day report, a text, a spreadsheet.
- Differences get noticed at month end, when nobody remembers the day.
- The numbers get reported, but the reason behind a bad day is not written anywhere.
In Markhub
Let an agent read the POS exports
- 1Post each store’s POS export in a Markhub hub at close.
- 2The POS Manager agent reads the exports and lays the day’s numbers side by side by store and channel.
- 3It posts the summary in the hub and points out what looks off. A person checks it and signs off.
Start free, then add the POS Manager from the agent library in your workspace.
Questions
What is the difference between gross and net sales?
Gross sales are everything rung up. Net sales are gross minus discounts and refunds, which is what the payments should add up to.
Why is my difference not zero?
Common reasons are a miscounted drawer, a cash refund rung up as a card refund, tips entered as sales, or a payment that settles the next day. Write the reason down the same day.
Can I close online and in-store sales together?
Yes. Use one row per store or channel. The Total row adds them up, and you can still see each one on its own.
Does it work in Google Sheets?
Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. The formulas and dropdowns carry over. The CSV has the same sample rows as plain values.
More templates
- Shift handover templateHand over what is open, what is blocked and what the next shift has to do by when.
- Equipment maintenance log templateRecord inspections, faults and repairs with downtime, parts cost and the next check date.
- Decision log templateRecord what was decided, why, and what happens next, so a month later you can still answer why.