How to Track Diwali Sales and Product Performance

Diwali is a busy time for businesses, with more customers, special offers, and higher demand for popular products. However, higher sales do not always mean higher profits. You need to track which products sell well, how discounts affect margins, and how much stock remains. Effective Diwali sales tracking helps you make better decisions while the festive season is still on. With the right reports, you can manage stock, review offers, and understand which products bring the most value to your business.

1. Define the sales metrics to track

Before you check your reports, choose what you want to track. Too many numbers can confuse you. Pick a few key numbers and check them each day.

Here are the six numbers to track.

First, margin. You can only work out gross margin if you know what each item costs you. If you do not have cost data for every item, start with your top 10 sellers. Say a gift hamper costs you ₹600 and you sell it for ₹1,000. You keep ₹400, so your gross margin is 40%.

Second, follow the same rules throughout the season. Count returns and discounts the same way each day. This keeps your sales performance tracking clear and correct. For example, count a sale at the same stage each time, whether before or after payment.

Also, check that every bill has the item name, quantity, price, discount, and date. These details help you make clear and correct sales reports.

2. Track sales by product and category

A total sales figure hides a lot. It tells you how much you earned, but not from what. To see that, you need two views.

A product-wise sales report lists each item with the units sold and the revenue earned. A category report groups items by category, such as decor, gifting, or sweets. Together, they show which items and which groups drive your sales.

Here is a simple example. A home decor shop looks at its first six days of Diwali sales.

Now look at what the table says.

• Rangoli colours sold the most units, 150. But they earned only ₹12,000, about 8% of revenue.
• Gift hampers sold just 40 units. They earned ₹60,000, about 39% of revenue.
• By category, decor earned ₹93,000. Gifting earned ₹60,000 from only 40 units.

If you looked only at units, you would push rangoli colours. If you looked only at revenue, you would push hampers. The right call needs both views, plus a margin. Rangoli colours may bring people into the shop. Hampers may bring in the money. Both jobs matter.

Also, check the bottom of the list. Items down there are either hard to see, priced too high or not wanted. The next sections help you find out which. To learn more about the reports you can use, read about reports in TallyPrime.

3. Compare sales with previous periods

A number on its own says little. Is ₹153,000 good? You only know when you compare it. Three comparisons help with festive sales analysis.

1. The previous week. Compare this week with the week before. This shows how quickly sales rise as Diwali approaches.
2. A similar festive period. Compare with another festive stretch, such as the days around Dussehra.
3. Last year’s Diwali. This is the best one. It is the same festival with a similar mood.

But the comparison must be fair. Check these before you trust it.

• Dates. Diwali follows the lunar calendar, so it falls on a different date each year. Compare the same stretch around the festival, such as the six days before it, not the same calendar dates.
• Promotions. If you ran a big offer this year and none last year, sales will differ for that reason.
• Prices. If prices went up, revenue could rise even when units fall.
• Range and size. New products, a new shop or a new online channel change the base.

Here is an example. Last year’s matching six days brought ₹120,000 and 400 units. This year, you have ₹153,000 and 460 units. Revenue is up 27.5%. Units are up 15%. Revenue grew faster than unit sales, so the average price per item increased. That may be due to higher prices or more hampers being sold. Your sales-by-item report will show which.

Keep a short note each year of what you did, such as offers, new items, and stockouts. Next year, that note makes the comparison fair.

4. Monitor stock alongside sales

Sales show demand. Stock shows what you can actually sell. You need both on the same page. A fast seller with no stock earns nothing. A slow seller with lots of stock ties up your money.

Sort your items into three groups.

• Fast movers: items that sell quickly.
• Stockout risks: items that are likely to run out soon.
• Slow movers: items that barely sell.

To identify stockout risks, calculate how many days of stock you have left. Divide the stock in hand by the average daily sales. Here is the same shop after six days.

Rangoli colours, hampers, and LED lights are nearing stockout. Now compare that with your supplier’s delivery time. If the supplier takes three days, you need to order today. Scented candles have 15 days of stock, but Diwali will be over much sooner. That stock may be left over after the festival.

For slow movers, look at how old the stock is. TallyPrime has a stock ageing report that shows an age-wise breakdown of stock, helping you spot old items. Its Stock Summary report shows stock balances and the profit on stock items, either by item or by group. You can also read more about inventory management in TallyPrime.

5. Measure the impact of discounts and offers

Festive season discounts can lift your sales. They can also quietly cut your profit. The only way to know is to compare units sold, revenue, and margin before and during the offer.

Here is an example. A shop sells an item for ₹1,000. It costs ₹600. The shop then gives a 20% discount for a week.

Units rose by 50%. Revenue rose by 20%. But the shop earned ₹10,000 less in margin. To earn the same ₹40,000 at ₹200 per unit, the shop would need to sell 200 units. That is the break-even point. And this does not count extra costs, such as ads, packing or free gifts. Those make the result worse.

Look at the results with care. Diwali can bring more sales even without an offer. Some of the extra 50 items may have sold anyway. To check this, compare them with a similar item that had no offer. You can also check sales from the days before the offer started.

If you are wondering how to plan Diwali offers so that they do not hurt profit, check five things before you start:

• Know the cost of every item in the offer.
• Set the lowest price you will not go below.
• Work out how many units you need to sell to break even.
• Add any extra costs, like ads or gifts.
• Fix an end date, and review the numbers on that day.

6. Track returns, cancellations, and payment collections

Gross sales can mislead you. It is the total of all billed items. It does not remove returns or cancelled orders. It also does not tell you if the customer has paid.

First, work out your net sales. Subtract returns and cancelled orders from your total sales. For example, your gross sales are ₹153,000. Customers return goods worth ₹6,000, and you cancel orders worth ₹4,000. Your net sales come to ₹143,000.

Next, check how much money you have received. Some customers may pay later. If ₹38,000 is still unpaid, you have received ₹105,000 so far. You can use this money to pay your suppliers and staff.

Watch returns closely. If one item comes back often, there may be a problem with its quality, size or description. If goods come back, the seller usually issues a credit note. Check the current rules on the GST portal or with your accountant.

Festive credit can pile up quietly. If you want to spot cash flow problems early, keep a list of unpaid bills and follow up on them every week.

7. Turn sales insights into action

Reports only help if you act on them. Use each finding to make one clear decision.

A clear festive sales promotion strategy comes from this table. Push what earns well. Fix what returns often. Clear what does not sell. Good Diwali sales management means doing this every day, not once at the end.

Keep a simple routine. Spend five minutes each morning on yesterday’s sales and stock. Spend more time once a week on offers and payments. After Diwali, do a full review. Write down which items sold out, which were left over, and which offers worked. Use that note to buy for next year based on facts, not guesses.

Wrapping up

Diwali can bring more buyers to your shop. Check your sales each day to see what sells best and when to order more stock. Offers can help you sell more, but they can also lower your profit. Review each offer and its cost to ensure your business earns more. When the season ends, keep your numbers. They are your plan for next year. TallyPrime helps you record sales, track stock, and view reports in one place. Explore TallyPrime and see how it can support your next festive season.