Business

Expense tracker for a pharmacy owner in India: what to record

Expense tracker for a pharmacy owner in India: stock purchases, expiry losses, rent, staff and delivery, with a worked month showing the real surplus.

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

A pharmacy owner's expense tracker has to treat stock differently from running costs. Stock bought from distributors is the biggest outflow and is not an expense until it sells or expires, so track it by itself. Then track rent, staff, power for the fridge, software, delivery and expiry losses as ordinary overheads. Keep family purchases off the shelf, or note them.

Why is a pharmacy not like other clinics?

A doctor's clinic sells time. A pharmacy sells stock, and stock ties up cash. You can pay a distributor ₹6,40,000 in a month and still have most of that on the shelf. If you subtract the whole payment from sales, you will think the month went badly. If you ignore stock entirely, you will think it went well. The fix is to count the stock at the start and the end of the month.

What categories does a pharmacy need?

  • Stock purchases from distributors.
  • Returns and credit notes from distributors.
  • Premises.
  • Pharmacist and counter staff.
  • Electricity, including the fridge.
  • Billing and inventory software.
  • Home delivery: fuel and rider cost.
  • Expiry and damage write-offs.
  • Charges deducted by card or UPI payment providers, if any.
  • Licence renewals, dues and small items.

How do you see the real result for a month?

Use a simple formula: cost of goods sold equals opening stock plus purchases minus closing stock. Say opening stock is ₹3,00,000, purchases are ₹6,40,000 and closing stock is ₹3,20,000. The cost of goods sold is ₹3,00,000 + ₹6,40,000 - ₹3,20,000 = ₹6,20,000. With sales of ₹8,00,000, the gross result is ₹1,80,000. All of this is invented. The point is the method.

LineHypothetical amount
Rent₹35,000
Staff₹55,000
Electricity₹12,000
Software₹3,000
Delivery₹8,000
Expiry write-offs₹6,000
Small items and dues₹4,000
Total overheads₹1,23,000

Gross result of ₹1,80,000 less overheads of ₹1,23,000 leaves ₹57,000 before loan payments and your own drawings. Note that this is a simplified view that ignores tax and anything your CA may adjust.

What does each shelf cost you in waiting?

Money sitting in slow stock is easy to overlook. Suppose a shelf of ₹40,000 of medicines sells only ₹5,000 worth in a month. At that speed it takes eight months to clear, since ₹40,000 divided by ₹5,000 is 8. In the meantime the packets edge towards expiry and the cash is not available for faster lines. A monthly list of items that did not move at all is one of the most useful reports a pharmacy can keep. Ask the distributor about return terms before the expiry date, not after.

What is personal use of stock?

Medicines you or your family take from the shelf are personal. Record them at purchase cost, either as drawings or in a personal-use log, and ask your CA how to show them. The same goes for items given to staff or relatives. If they are not written down, the stock count at month end will look short.

How do expiry losses show up in the numbers?

Expired packs are a cost that no bill announces. Say ₹6,000 of stock passed its date this month and ₹1,500 of it can be returned for credit. The net loss is ₹4,500, and the credit note should be on your list until the distributor actually issues it. Keep a dated list of what was written off, with batch and cost. If the same product expires month after month, you are ordering too much of it.

Which items get missed?

  • Cash paid to a delivery boy for fuel.
  • Small cash purchases from a neighbouring pharmacy when something is out of stock.
  • Credit notes for returned or near-expiry stock that the distributor has not yet issued.
  • Discounts given at the counter.
  • Annual renewal fees for licences and registrations that apply to you.

When you import the shop account's statement into SpendixAI, you can pick the account, review each row and set your own rules so that repeat distributors go into the stock-purchases category.

SPENDIXAI JOURNAL

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

Explore your reports