A useful daily sales target has three levels: a floor at your break-even sales, a base at last month's average, and a stretch a little above it. Build them from last month's sheet and your monthly costs, so the target is anchored to what your shop actually did and what it must earn.
Step 1: last month's average day
Add up last month's sales and divide by the number of days you were open. Say total sales were ₹3,90,000 over 26 open days. The average is 3,90,000 divided by 26, which is ₹15,000 a day. In a sheet with daily sales in B2 to B32, the formula =AVERAGEIF($B$2:$B$32,">0") ignores days you were closed.
Step 2: your break-even sales
Break-even sales is the amount you must sell for your gross profit to cover your fixed costs, including your own pay if you want to count it. The formula is fixed costs divided by gross margin share.
Say fixed costs are ₹70,000 a month: rent, staff, electricity, phone and your own drawings. Say your gross margin, meaning sales less the cost of the goods sold, is 20% of sales. Then break-even sales are 70,000 divided by 0.20, which is ₹3,50,000 a month. Over 26 days that is about ₹13,460 a day, which you can round to ₹13,500.
Use your own margin, worked out from last month's purchases and stock change. A made-up 20% is only for the sum.
Step 3: put the three levels together
| Level | How it is set | Per day | Per 26-day month |
|---|---|---|---|
| Floor | Break-even sales | ₹13,500 | ₹3,51,000 |
| Base | Last month's average | ₹15,000 | ₹3,90,000 |
| Stretch | Base plus 10% | ₹16,500 | ₹4,29,000 |
Check the figures: 13,500 times 26 is 3,51,000. 15,000 times 1.10 is 16,500, and 16,500 times 26 is 4,29,000. The 10% is a made-up choice; pick a stretch you could genuinely reach, not a wish.
Share the floor, not the stretch, with staff at first. A floor is a plain fact about the shop's costs, while a stretch is a hope. Staff who know the floor understand why a very slow day matters, and you avoid turning a stretch figure into pressure to discount.
What do I do with festival weeks?
A festival week can sell much more than an ordinary one, so keep it out of the base average and set a separate target for it. Look at the same festival last year, if you kept a sheet, and use that week as your guide. After the festival, return to the base. If you leave festival days in, your ordinary days will always look as if they missed.
Do I need a different target per weekday?
Possibly. If Saturday regularly sells much more than Tuesday, a single daily figure will make Tuesdays feel like failures and Saturdays like easy wins. A simple fix is to keep one number and judge by the week, or to set weekday targets from the average of each weekday over the last four weeks.
For example, if Saturdays averaged ₹20,000 and Tuesdays ₹12,000 over the last four weeks, targets of ₹20,000 and ₹12,000 are fairer than ₹15,000 for both days.
That last figure is 70,000 divided by 0.15, which is 4,66,667, rounded. It shows why a lower margin makes the same sales fall short.
How do I use the target day to day?
- Write the base target at the top of each daily sheet.
- Mark each day as above floor, between floor and base, or above base.
- At week's end, count the days in each band, not just the total.
- Review the floor and base monthly, and when rent, staff pay or margin changes.
If you pay the shop's fixed costs from a bank account, add up last month's figures from your statement, or let a tracker like SpendixAI group them by category from an imported statement, and use the total in the break-even sum.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


