Daily Sales Report: Free Template for Retail and Restaurants
Quick Answer
A daily sales report summarizes one day's business: gross sales, discounts, refunds and voids, net sales, sales by payment type, number of transactions, average ticket, sales by category or hour, labor hours and labor cost percentage, comparisons to the same day last week and last year and notes about anything unusual. Complete it at close using your POS reports, reconcile it with the cash drawer and deposit and review the trends every week.
Your POS can spit out dozens of reports, but most owners and managers need a few numbers every day: how much did we sell, how did we get paid, how busy were we and how much did labor cost? A daily sales report pulls those numbers onto one page, so you can spot problems the next morning instead of at month-end.
This guide includes a free daily sales report template for retail stores and restaurants and explains each number, how to compare days, how to reconcile with cash and deposits and how to use the report to make better decisions.
What Is a Daily Sales Report?
A daily sales report is a one-page summary of a single day's sales and related numbers. It's usually completed by the closing manager using POS reports and reviewed by the owner or general manager the next day. Over time, the daily reports become a history of your business that shows trends, slow days and busy seasons.
Free Daily Sales Report Template
Daily Sales Report
Date: ______ | Day: ______ | Location: __________ | Manager: __________ | Weather / events: __________
Sales Summary
| Item | Today | Same day last week | Same day last year |
|---|---|---|---|
| Gross sales | |||
| Discounts and comps | |||
| Refunds and returns | |||
| Voids | |||
| Net sales | |||
| Sales tax collected | |||
| Tips (if applicable) |
Payment Types
| Payment type | Amount | Count |
|---|---|---|
| Cash | ||
| Credit and debit cards | ||
| Gift cards redeemed | ||
| Online / delivery apps | ||
| House accounts / other | ||
| Total |
Traffic and Ticket
| Measure | Today | Last week |
|---|---|---|
| Transactions or checks | ||
| Guests or covers (restaurants) | ||
| Average ticket (net sales ÷ transactions) | ||
| Items per transaction (retail) |
Labor
| Measure | Today | Target |
|---|---|---|
| Labor hours | ||
| Labor cost | ||
| Labor cost % (labor cost ÷ net sales) | ||
| Sales per labor hour |
Cash Reconciliation
| Item | Amount |
|---|---|
| Expected cash (per POS) | |
| Cash counted | |
| Over / (short) | |
| Deposit prepared | |
| Deposit bag # |
Notes (staffing, weather, events, problems): __________________________
Key Numbers Explained
| Number | What it means | Why it matters |
|---|---|---|
| Gross sales | Total sales before discounts and refunds | Overall volume |
| Net sales | Gross sales minus discounts, comps, refunds and voids | The number most reports are built on |
| Transactions | Number of sales or checks | Customer traffic |
| Average ticket | Net sales ÷ transactions | How much each customer spends |
| Labor cost % | Labor cost ÷ net sales | How efficiently you staffed the day |
| Sales per labor hour | Net sales ÷ labor hours | Productivity |
| Discounts and voids | Money given away or removed | Training, pricing and theft signals |
Example: Net sales of $4,800 from 160 transactions is an average ticket of $30. With $1,150 in labor cost, labor is about 24% of sales.
Comparing Days the Right Way
- Same day last week: compare Tuesday to last Tuesday, not to Saturday.
- Same day last year: shows growth, adjusting for holidays that move.
- Note weather and events: a rainy day or a local festival explains a lot.
- Watch the weekly total as well as single days.
A single slow day isn't a trend. Three slow Tuesdays in a row might be.
Sales by Category and Hour
Most POS systems can break sales down by category (such as food, beverage, retail items or departments) and by hour. Add these to the report once a week, or daily if you're actively working on staffing or menus.
| Hour | Sales | Transactions | Staff on |
|---|---|---|---|
| 11–12 | |||
| 12–1 | |||
| 1–2 | |||
| 5–6 | |||
| 6–7 |
Sales by hour show where you're over- or understaffed. See labor cost percentage and the scheduling tools.
Discounts, Voids and Refunds
These numbers deserve a close look every day. High voids or refunds can point to training gaps, order mistakes or, sometimes, theft. Track them by employee as well as total, and ask about anything unusual.
| Signal | Possible cause |
|---|---|
| Voids rising on one shift | Order entry mistakes or training needs |
| Many refunds without receipts | Policy not followed or possible fraud |
| Comps much higher than usual | Service problems or unauthorized discounts |
| Discounts not matching promotions | Pricing or POS setup errors |
For problems with returns and damaged items, see the damaged goods log.
Reconciling Sales With Cash and Deposits
- Run the end-of-day POS report.
- Count each cash drawer. See the cash drawer count sheet.
- Compare cash counted to expected cash.
- Prepare the deposit and record it. See the bank deposit log.
- Compare card totals with the processor batch.
- Record any differences on the daily report.
Daily Sales Report for Restaurants
| Add | Why |
|---|---|
| Covers and average check per guest | Restaurant traffic and spending |
| Sales by daypart (breakfast, lunch, dinner) | Staffing and menu decisions |
| Food and beverage split | Cost control |
| Comps and voids by server | Training and accountability |
| Tips and tip outs | Payroll accuracy |
For tips, see the tip out sheet.
Daily Sales Report for Retail
| Add | Why |
|---|---|
| Units per transaction | Selling effectiveness |
| Conversion rate (if you count traffic) | How many visitors buy |
| Sales by department | Merchandising decisions |
| Returns and exchanges | Product and service issues |
| Top sellers | Reordering and displays |
Turning Daily Numbers Into Action
- Adjust tomorrow's schedule if labor cost was high on a slow day.
- Follow up on unusual voids, discounts or cash differences.
- Restock top sellers before they run out.
- Plan promotions for slow days that keep showing up.
- Share wins with the team.
Review the week every Monday: total sales, labor cost, average ticket and anything that stood out. For longer-term tracking, build a simple dashboard. See tips for creating dashboards in Excel and Google Sheets.
Example: A Neighborhood Café
A café owner checked sales only at month-end and was surprised by low profits. She started a one-page daily sales report with net sales, transactions, labor cost and voids. Within two weeks, she saw that Monday and Tuesday afternoons ran labor above 40% of sales and that one opener's voids were three times higher than anyone else's. Adjusting the schedule and retraining the opener brought labor cost down and cut voids sharply.
Common Daily Sales Report Mistakes
- Only looking at gross sales.
- Comparing different days of the week.
- Ignoring voids, discounts and refunds.
- Skipping the cash reconciliation.
- No notes about weather, events or staffing.
- Filling out the report but never reviewing it.
Daily Sales Report Checklist
| Step | Done? |
|---|---|
| Run end-of-day POS reports | |
| Record gross and net sales, discounts, refunds and voids | |
| Record payment types, transactions and average ticket | |
| Record labor hours and labor cost % | |
| Reconcile cash and prepare the deposit | |
| Compare to last week and last year | |
| Add notes and review the next morning |
Sample Completed Daily Sales Report
| Item | Today (Tue) | Last Tue | Change |
|---|---|---|---|
| Gross sales | $5,120 | $4,780 | +7.1% |
| Discounts and comps | $180 | $150 | +20% |
| Refunds and voids | $95 | $60 | +58% |
| Net sales | $4,845 | $4,570 | +6.0% |
| Transactions | 162 | 155 | +4.5% |
| Average ticket | $29.91 | $29.48 | +1.5% |
| Labor cost | $1,210 | $1,240 | −2.4% |
| Labor % | 25.0% | 27.1% | −2.1 pts |
This sample uses made-up numbers. Sales and labor both moved in the right direction, but refunds and voids jumped, which is worth a quick look.
Weekly Sales Summary
| Day | Net sales | Transactions | Avg ticket | Labor % | Notes |
|---|---|---|---|---|---|
| Mon | |||||
| Tue | |||||
| Wed | |||||
| Thu | |||||
| Fri | |||||
| Sat | |||||
| Sun | |||||
| Week |
A weekly summary makes it easy to see your strongest and weakest days and plan staffing and promotions.
Spreadsheet Formulas for Daily Sales
| Calculation | Formula example |
|---|---|
| Net sales | =Gross-Discounts-Refunds-Voids |
| Average ticket | =Net_sales/Transactions |
| Labor % | =Labor_cost/Net_sales |
| Change vs. last week | =(Today-Last_week)/Last_week |
| Month to date | =SUM(B2:B31) |
For more formulas, see the Excel formulas cheat sheet.
Who Should See the Daily Report?
| Person | What they use it for |
|---|---|
| Owner | Overall performance, cash and labor control |
| General manager | Staffing, scheduling, problems to follow up |
| Kitchen or department lead | Category sales, waste and ordering |
| Bookkeeper | Reconciling sales, deposits and card batches |
Daily Sales Report Policy
Daily Sales Report Policy
• The closing manager completes the daily sales report before leaving.
• Cash is counted and reconciled before the report is finalized.
• Unusual discounts, voids, refunds or cash differences are explained in the notes.
• The owner or general manager reviews the report the next morning.
• Reports are filed by date and summarized weekly.
Setting Daily Sales Goals
Use your history to set realistic daily goals: the same day last year plus a growth target, adjusted for events and weather. Share goals with the team at pre-shift and post results at the end of the day. Goals turn the report from a record into something the whole team can work toward. See the daily huddle agenda.
Multiple Locations
If you run more than one location, use the same report format everywhere so results are comparable. A single summary with each location's net sales, labor % and average ticket shows quickly where to focus support.
| Location | Net sales | Labor % | Avg ticket | Cash over/short |
|---|---|---|---|---|
| Store 1 | ||||
| Store 2 | ||||
| Store 3 |
Reading Trends Over Time
One day's report tells you what happened. A month of reports tells you why. Once a month, look across your daily reports for:
- Day-of-week patterns: which days are consistently strong or weak.
- Average ticket trends: whether customers are spending more or less per visit.
- Labor drift: whether labor % creeps up on certain days.
- Discount and void patterns: by shift or employee.
- Weather and event effects: how much they move sales.
Use what you learn to set staffing, plan promotions and order inventory.
Daily Sales and Inventory
Daily sales by item tell you what to reorder and when. Fast sellers may need higher par levels; slow sellers may need a promotion or removal. Compare sales with inventory counts weekly to catch shrink early. See the inventory count sheet.
Training Closers on the Report
- Show where each number comes from in the POS.
- Practice completing the report with a manager.
- Explain how to reconcile cash and record differences.
- Explain what to write in the notes.
- Review the first few reports together.
Keep the steps in a written procedure so every closer completes the report the same way. See SOPs for small business.
Common Questions About Daily Sales Reports
- Should tips be in net sales? No. Track tips separately from sales.
- Should sales tax be included? Report it separately; net sales usually exclude tax.
- Do gift card sales count as sales? Many businesses record gift card sales when redeemed, not when sold. Ask your accountant.
- What if the POS and cash don't match? Record the difference, recount and investigate.
Daily Sales Report Quick Tips
- Use net sales, not just gross.
- Compare the same day of the week.
- Watch voids, discounts and refunds.
- Reconcile cash every day.
- Write notes about anything unusual.
Getting Started This Week
- Print the template or build it in a spreadsheet.
- Find each number in your POS end-of-day reports.
- Pull last week's and last year's numbers for comparison.
- Have closers complete it every night this week.
- Review each morning and summarize on Monday.
Within a few weeks, you'll have a clear picture of your best and worst days and where labor or discounts are slipping.
Using Daily Sales for Scheduling
Sales by day and hour are the best guide for next week's schedule. Staff up for the hours that consistently bring in the most sales and trim hours that run high labor % week after week. Compare scheduled hours with actual hours too; overtime and late clock-outs often explain labor creep. See scheduled vs. actual hours.
When Sales Drop Suddenly
- Check whether the POS recorded every sale correctly.
- Look for outside causes: weather, construction, events, competitors.
- Review service problems, such as long waits or out-of-stocks.
- Ask staff what they noticed.
- Compare with other locations, if you have them.
Paper vs. Spreadsheet vs. POS Reports
| Paper | Spreadsheet | POS dashboard | |
|---|---|---|---|
| Setup | None | A few hours | Depends on system |
| Comparisons | Manual | Formulas | Built in |
| Notes and context | Easy | Easy | Often limited |
| Labor data | Manual | Manual or imported | Sometimes integrated |
Many owners use POS reports for the raw numbers and a simple spreadsheet for the one-page summary, comparisons and notes. The format matters less than the habit of completing and reviewing it every day.
A Daily Habit That Pays Off
Five minutes at close and five minutes the next morning is all it takes. Over a year, those daily reports become the most useful record you have for staffing, pricing, purchasing and planning.
Sharing Results With Your Team
Post yesterday's sales, average ticket and a goal for today in the break room or share them at pre-shift. When employees see the numbers, they understand how their work, like suggesting add-ons or keeping lines moving, affects results. Keep it positive: celebrate good days and talk about what helped. Keep labor cost and cash details for managers only.
Daily Sales and Your Budget
Compare month-to-date sales from your daily reports with your monthly budget. If you're behind halfway through the month, you still have time to adjust staffing, run a promotion or cut spending. See the annual budget template.
Small adjustments made early in the month are much easier than trying to recover a whole month at the end. The daily report is what makes those early adjustments possible.
Start tonight with your closing manager.
Then review it together tomorrow morning and build the habit from there.
See Sales and Labor Together With Updoot
Updoot's employee time clock gives you accurate labor hours for every day, scheduling helps match staffing to sales and the KPI dashboard keeps your key numbers in one place.