Business

Daily sales by category: five lines that show what really sells

Track daily sales by category with just five lines, tick sales into them through the day and total at closing, so a month shows your real sales mix.

Editorial illustration for Daily sales by category: five lines that show what really sells

You can learn what really sells in a small shop without writing down every item. Pick five broad categories, tick each sale's amount into the right one through the day, and total the five at closing. A month of those totals shows your sales mix, which is enough to guide what you stock and where you put it.

How do I choose the five categories?

Choose groups that behave differently for you, not a long list. For a made-up general store, they might be:

  1. Staples: rice, atta, dal, oil.
  2. Snacks and drinks.
  3. Household: soap, detergent, cleaners.
  4. Dairy and fresh.
  5. Other: everything that does not fit the four above.

Keep Other small. If it grows beyond a tenth of your sales, one of its items probably deserves a category of its own.

How do I tick sales through the day?

Keep a card or page by the counter with five columns. At each bill, write the amount in the column for the item category. If a bill mixes categories, write the main part where it belongs, or split it roughly if one category is clearly larger. At closing, add each column. The five column totals should add up to the day's total sales. If they do not, an amount was missed or written twice.

A check formula in a sheet, if B2 to B6 hold the five category totals and B7 holds the day's total sales from your main sheet: =SUM(B2:B6)-B7. It should be zero. Anything else is the amount to find.

On a busy day, tick as you go rather than rebuilding it from memory at closing. If you use a bill book, a quick alternative is to write the category letter on each bill's copy and total from those at the end. Either way the rule is the same: one amount, one category, nothing counted twice.

What does a month look like?

With made-up numbers, add each day's category totals into a monthly column. Say the month's sales were ₹4,00,000:

CategoryMonth's salesShare of sales
Staples₹1,60,00040%
Snacks and drinks₹1,00,00025%
Household₹60,00015%
Dairy and fresh₹60,00015%
Other₹20,0005%

The five add up: 160,000 plus 100,000 plus 60,000 plus 60,000 plus 20,000 is 4,00,000. The share formula is =B2/$B$7 with the cell formatted as a percentage, where B7 is the month's total.

What can I do with the mix?

  • See which categories are growing or shrinking month to month. A rise in snacks and drinks in summer, say, is something to plan stock for.
  • Notice festival effects. Compare Diwali month with an ordinary month, category by category.
  • Check space against sales. If household takes a third of your shelves and brings in 15% of sales, that is worth a second look.
  • Spot a category that sells but carries a thin margin, and look at its prices.

Will five lines miss things?

Yes, they will miss item-level detail, such as which brand of oil sells. That is the trade-off: five lines are quick enough to actually keep up at a busy counter, and item-wise entry usually is not. If after a few months you need more detail in one category, split only that one into two or three lines and leave the rest.

A routine that takes two minutes

  1. Morning: new card or new row with five blank columns.
  2. During the day: amount goes into a column at each bill.
  3. Closing: total each column, then check the five add up to the day's sales.
  4. Month end: add the days, work out the shares, and note one thing that surprised you.

After three months, compare the monthly mixes side by side. A shift you can see in your own numbers is far more useful than any general advice about what shops sell.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports