Every POS produces a daily report, and most owners glance at one number: total sales. That number tells you whether today was busy, but not whether it was profitable, whether cash is safe, or what to fix tomorrow. A well-read daily sales report for a retail store takes about ten minutes and answers all three. This guide explains which figures to track each evening, how to calculate and interpret them with examples, and how to turn the report into decisions rather than a habit of scrolling.
The Ten-Minute Evening Routine
- Net sales versus same day last week.
- Number of bills and average bill value.
- Payment mix and closing variance.
- Discounts, returns and voids.
- Gross margin for the day.
- Top and bottom items or categories.
- Stockouts and low stock on key items.
- One action for tomorrow.
The last step matters most. A report that does not lead to an action is just a ritual.
The Eight Figures to Read Each Evening
1. Net Sales, Not Just Gross Sales
Gross sales are the total of all bills before discounts and returns. Net sales are what you actually earned:
Net sales = Gross sales minus discounts minus returns (usually shown excluding GST).
Suppose a hypothetical store shows gross sales of ₹68,400, discounts of ₹2,900 and returns of ₹1,500. Net sales are ₹64,000. Compare net sales with the same weekday last week rather than with yesterday: Saturdays and Tuesdays are not comparable, but this Saturday and last Saturday are.
2. Bills and Average Bill Value
Sales can be broken into two drivers:
Net sales = Number of bills x Average bill value
| Day | Bills | Average bill (₹) | Net sales (₹) |
|---|---|---|---|
| Last Saturday | 210 | 310 | 65,100 |
| This Saturday | 232 | 276 | 64,032 |
Sales look flat, but the story changed. More customers came (footfall is up), but each spent less. Perhaps a promotion attracted small-basket buyers, or a popular high-value item was out of stock. That is a very different problem from fewer customers. Also track items per bill; falling items per bill suggests cross-selling or availability issues.
3. Payment Mix and Closing Variance
Look at how today's sales were paid: cash, UPI, card, credit and others. Then check the closing variance for each counter. A store that is usually 60 percent UPI suddenly showing 40 percent UPI and higher cash may have had a payment outage, or bills recorded under the wrong mode. Any variance above your tolerance should have an explanation before you close the day. Our cash drawer reconciliation checklist covers how to investigate.
4. Discounts, Returns and Voids
Express each as a percentage of gross sales and compare with your normal level:
- Discount percentage: ₹2,900 on ₹68,400 is 4.2 percent. If your normal is 2 percent, find out why: a promotion, or one cashier giving unauthorised discounts.
- Return percentage: watch for spikes and for cash refunds.
- Voids after payment: should be rare; each one should have a reason.
5. Gross Margin
Sales without margin can mislead. Gross margin is net sales minus the cost of goods sold. If the POS knows each item's cost, it can calculate this daily.
Suppose net sales are ₹64,000 and cost of goods sold is ₹51,200. Gross margin is ₹12,800, or 20 percent. If your usual margin is 22 percent, a 2-point drop on ₹64,000 is ₹1,280 a day, over ₹38,000 a month. Causes include heavy promotions, a shift in mix towards low-margin items, or wrong cost prices in the system after a supplier price change.
Margin is only as good as your cost data. Make sure purchase entries update item costs correctly.
6. Top and Bottom Items
Look at the top 10 items by sales and by margin. Then glance at the categories:
- Is a usually strong category weak today? Check stock and display.
- Is an item selling unusually fast? Check stock for tomorrow.
- Is a promoted item selling as expected? If not, the promotion may need better visibility.
Weekly, look at the bottom: items with no sales in 30 or 60 days. They tie up cash and shelf space.
7. Stockouts and Low Stock
A stockout on a fast-moving item is lost sales you never see in the report, because nothing was billed. Check the low-stock list for your top 50 items every evening and make sure orders or transfers are placed. Suppose a store sells 25 units a day of a ₹120 item. Being out for two days loses ₹6,000 of sales, and some customers may not come back.
8. Hourly Sales
Hourly sales show when customers come. Use them weekly for staffing: if 40 percent of bills happen between 6 pm and 9 pm, schedule your best cashiers and open all counters then. Daily, an unusual dip at a normally busy hour may indicate a problem: a system outage, a closed counter, or a road closure outside.
A Sample Daily Summary Layout
| Metric | Today | Same day last week | Change |
|---|---|---|---|
| Net sales (₹) | 64,000 | 65,100 | -1.7% |
| Bills | 232 | 210 | +10.5% |
| Average bill (₹) | 276 | 310 | -11.0% |
| Discount % | 4.2% | 2.1% | Up |
| Gross margin % | 20.0% | 22.3% | Down |
| Cash variance (₹) | -80 | +20 | Within tolerance |
| Stockouts on top 50 items | 3 | 1 | Up |
Reading this, the action is clear: investigate the discount spike, which probably explains both the lower average bill and lower margin, and fix the three stockouts.
Setting Simple Targets
Numbers mean more when compared with a target. Set a few monthly targets and break them into daily ones. If your monthly net sales target is ₹19.5 lakh over 30 days, the average daily target is ₹65,000, but weekends may carry ₹90,000 and weekdays ₹55,000. Set weekday-specific targets based on past patterns, so that a normal Tuesday does not look like a failure next to a Saturday. Add a margin target and a discount ceiling, so that sales are not chased at any cost.
Reading Reports Across Multiple Stores
With more than one store, compare stores on the same measures: net sales, bills, average bill, margin percentage, discount percentage and stockouts. A store with similar footfall but a lower average bill may need better displays or cross-selling. A store with a much higher discount percentage needs a closer look at counter practices. Rank stores weekly, but discuss the reasons with store managers rather than only the ranking.
Trusting the Numbers
A report is only as reliable as the data behind it. Three habits keep daily figures trustworthy: every sale goes through the POS (no side sales on paper), every purchase is entered on the day it arrives so costs are current, and every shift is closed properly so payments are not mixed between days. If your daily margin swings wildly from 12 percent one day to 30 percent the next with no obvious reason, the cause is almost always data, such as a purchase entered with the wrong cost or a bill posted on the wrong date, rather than a real change in the business. Fix the data before drawing conclusions.
Sharing Numbers With Your Team
Store staff often never see the numbers they influence. A short morning huddle with yesterday's bills, average bill and top stockouts gives cashiers and floor staff a reason to suggest add-ons, keep shelves full and avoid unnecessary discounts. Keep it positive and specific: "yesterday we ran out of 1 litre oil by 6 pm; today the reorder arrives at 11" is more useful than "sales were down".
Weekly and Monthly Views
The daily report catches today's problems. Weekly and monthly reports show trends:
- Weekly: sales by weekday, category trends, staff exceptions, slow movers.
- Monthly: margin by category, shrinkage from counts, stock value and ageing, customer retention if you run a loyalty program.
Common Mistakes
- Looking only at gross sales.
- Comparing with yesterday instead of the same weekday last week.
- Ignoring margin because cost prices are not maintained.
- Not checking stockouts, which never show up as sales.
- Reading the report but never writing down an action.
Practical Questions Owners Ask
What is a good average bill value for my store?
It depends on your format and location. Rather than comparing with other stores, track your own average bill by weekday and category, and look for changes after promotions, range changes or stockouts.
Should I track items per bill as well?
Yes. Items per bill shows basket depth. A falling figure often signals stockouts, weak cross-selling or a change in customer mix, even when total sales look stable.
How Fininvo Fits
Fininvo's Retail & POS workspace includes POS reports, end-of-day views and an owner reports library, with sales flowing into Fininvo ERP's reports and inventory. Some report modules are switched on per account, so check pricing.
Frequently Asked Questions
What should a daily sales report include?
Net sales, number of bills, average bill value, payment mix, closing variance, discounts, returns, voids, gross margin, top items and stockouts on key items.
What is average bill value?
Average bill value is net sales divided by the number of bills. It shows how much each customer spends per visit.
Why compare with the same day last week instead of yesterday?
Customer traffic follows a weekly pattern. Comparing Saturday with last Saturday removes the weekday effect and shows real changes.
How do I calculate daily gross margin?
Subtract the cost of goods sold from net sales, then divide by net sales. It requires accurate cost prices in your system.
How long should reviewing the daily report take?
Around ten minutes once the routine is set. Focus on changes versus last week and end with one action for tomorrow.
Share this article
Ready to automate your business?
Start your 14-day free trial and experience the power of unified ERP, HR, and Payroll.
Start Free Trial