Business

Expense tracker for a kirana store owner in India: what to record

How a kirana store owner in India can track purchases, rent, helper pay, udhaar and own-use stock, with a hypothetical month's profit worked out in rupees.

Editorial illustration for Expense tracker for a kirana store owner in India: what to record

A kirana store has two kinds of numbers: what you bought to sell and what it cost to keep the shop open. A tracker that keeps them apart shows the gross margin first and the running costs after, and then tells you how much the family took from the shelf. Most shops lose track of that last part.

What does a kirana store actually spend on?

  • Purchases from wholesalers and distributors, the largest line by far.
  • Shop rent and the electricity bill, including the fridge and the freezer.
  • A helper's wages and a delivery boy's pay and fuel.
  • Carry bags, packing material, rolls for the billing machine.
  • Festival stock for Diwali, Holi or Eid that may not all sell.
  • Spoilage and expiry: milk, bread, bakery items, packets past date.
  • Repairs: a weighing scale, a fridge compressor, shelves.
  • Phone, a UPI sound box or QR stand, if there is a monthly fee.

Where does cash end and UPI begin?

Most shops take both. Record cash sales from the day's counter total and UPI sales from the settlement or bank statement, and keep the two lines apart. If the days total higher than your deposits, you have either spent cash from the till on expenses or taken it for the family. Either is fine, as long as it is written down.

What does a hypothetical month look like?

Say sales are ₹4,20,000, with ₹1,50,000 in cash and ₹2,70,000 by UPI. Purchases are ₹3,45,000. Sales minus purchases is ₹75,000, which is the gross margin. Running costs: rent ₹18,000, electricity ₹6,500, helper ₹9,000, carry bags ₹1,500 and delivery fuel ₹2,000. Those add to ₹37,000. The month leaves ₹38,000. Of the ₹3,45,000 in purchases, ₹3,000 was rice, dal and tea the family used. Move that to a separate line, because otherwise your cost of selling looks higher than it is.

How should udhaar be recorded?

CustomerAmount owedLast payment
Regular customer A₹4,500Ten days ago
Regular customer B₹7,200Three weeks ago
Regular customer C₹10,300A month ago

That sample list totals ₹22,000. Udhaar is sold stock you have not been paid for. Keep a separate ledger, so the figure is visible at month-end. A rise from ₹22,000 to ₹30,000 means you funded ₹8,000 of customers' needs, even if sales looked strong.

What about festival stock and spoilage?

Before Diwali or Eid, shops stock up on dry fruits, sweets, oil and gift packs. Some of it will not sell. Record festival purchases in their own category, and write down what is left once the season is over. If you mark down leftover stock or throw away what has expired, note the cost on a spoilage line. A month with a big festival purchase will look weak, then recover when the stock sells, so judge the season as a whole.

Which categories keep a kirana owner organised?

  • Stock purchases, split between groceries, dairy and bakery, and non-food.
  • Rent and utilities.
  • Staff and delivery.
  • Packing and bags.
  • Repairs and equipment.
  • Spoilage and expiry.
  • Own use from stock.

What is a realistic routine for a busy shop?

  1. At night, write the day's cash total and pay-outs from the till.
  2. Weekly, add wholesaler bills and any payment made.
  3. At month-end, upload the bank statement and tick the UPI settlements.
  4. Update udhaar and stock.

SpendixAI can import the statement, take hand-entered cash costs in batches, and keep your categories, which suits a shop with many small entries. It does not replace your billing machine.

SPENDIXAI JOURNAL

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

Explore your reports