Business

Expense tracker for a sweet shop owner in India: what to record

How a sweet shop owner in India can track milk, ghee, boxes, gas and wages, split business from home spending, and close each month cleanly.

Editorial illustration for Expense tracker for a sweet shop owner in India: what to record

A sweet shop owner needs an expense tracker that lists the real running costs (milk and khoya, sugar and ghee, gas, boxes, wages, rent), keeps home spending out, and takes ten minutes to update each night. Start with eight to ten categories, enter cash items the same evening, and total the month on the same day each time.

What are the real cost lines of a sweet shop?

Most of the money goes to raw material that spoils quickly, so purchases are frequent and often unbilled. Beyond ingredients, the lines that quietly add up are cylinders, packaging, hired hands for festival rush and the rent of the counter. Treat each as its own category so a bad month can be traced to one cause.

Which categories work best?

  1. Milk, khoya and paneer
  2. Sugar, ghee and oil
  3. Dry fruits and flavourings such as saffron and cardamom
  4. Gas and fuel for the kadhai
  5. Boxes, trays, foil and ribbons
  6. Wages and festival helpers
  7. Shop rent and electricity
  8. Transport and delivery
  9. Repairs and utensils
  10. Licence, cleaning and miscellaneous

What does a hypothetical month look like?

Say a shop's sales in a month are ₹2,60,000. The costs, entered through the month, come to the following.

CategoryAmount (₹)
Milk and khoya62,000
Sugar, ghee, dry fruits48,000
Boxes and packaging9,500
Gas cylinders14,400
Wages36,000
Rent22,000
Electricity7,800
Transport5,300
Total costs2,05,000

Sales minus costs is ₹2,60,000 minus ₹2,05,000, which leaves ₹55,000. That is not yet your income: loan repayments, your own drawings and yearly licence fees still have to come out of it.

Which items are most often missed?

  • Cash given to the milk vendor at the counter without any slip.
  • A cylinder delivered and paid in cash by the helper.
  • Advance paid to a halwai or a cook brought in for Diwali or Rakhi orders.
  • Sweets given away as gifts or samples, which cost you ingredients even though no sale is recorded.
  • UPI payments made from the personal account for shop needs.

How do you keep personal and shop money apart?

Use one bank account and one UPI handle only for the shop. When you pay a family bill from it, enter it as a personal draw, not as a shop cost. If the shop and home share a building, ask your CA how to split electricity rather than guessing a percentage yourself.

How do festival months change the tracker?

Diwali, Raksha Bandhan and wedding season can double the raw material you buy in a fortnight. Do not lump them in with ordinary days. Add a note beside the month, such as 'Diwali week, extra helpers, extra boxes', so that when you compare October with a quiet July you know why the numbers differ. Keep a short list of one-off items too: a rented display counter, extra gas cylinders, a temporary halwai. These are easy to forget by the time the festival is over.

What about wastage and sweets given away?

Milk-based sweets do not keep for long. Rather than hiding spoiled trays in the milk line, keep a small 'wastage and samples' note with the date, item and rough weight. You are not adding a new payment, only explaining why raw material spend looks higher than what was sold. Over three or four months it shows whether you are making too much of one item.

A ten-minute nightly routine

  • Count cash and match it with the day's sales slip.
  • Write down every payment made today, even small ones.
  • Photograph bills before the paper fades.
  • On the last day of the month, add up each category and compare with last month.

When a notebook stops being enough, SpendixAI lets you upload the shop's bank statement and add cash expenses by hand, several at once, so evenings at the counter stay short.

SPENDIXAI JOURNAL

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

Explore your reports