A medical store's tracker has to handle something most shops do not: stock that expires. Purchases, returns and credit notes from distributors matter as much as sales, and a record that ignores expired stock will overstate profit. Track the cost of goods first, then the running costs, and then what slipped out of the date.
What does a medical store owner spend on?
- Stock bought from distributors, usually the largest line.
- Shop rent and electricity, including refrigerators that run all day.
- The pharmacist's salary and any helper or delivery boy.
- Billing software, a printer, paper rolls and a barcode scanner.
- Licence renewals and fees for registers or compliance, as your pharmacist and CA advise.
- Packaging such as covers and strips, and delivery fuel.
- Repairs and a standby power source.
How should expired stock and returns be tracked?
Expired medicines are often returned to the distributor for a credit note, sometimes only part of the cost. Keep a sheet of what you returned, the credit note amount and the date it was adjusted. Say you bought ₹4,78,000 of stock and received an ₹18,000 credit note for expiry returns. Net purchases are 4,78,000 minus 18,000, which is ₹4,60,000. If the credit is lower than the cost, the gap is a loss worth seeing on its own line.
Which categories suit a medical store?
| Category | What goes in it |
|---|---|
| Stock purchases | Distributor invoices |
| Returns and credit notes | Expiry returns and adjustments |
| Rent and utilities | Rent, electricity, internet |
| Staff | Pharmacist, helper, delivery |
| Software and billing | Billing app, printer, rolls |
| Licences and compliance | Renewals and registers |
| Packing | Covers, bags |
| Delivery | Fuel, repairs |
What does a hypothetical month look like?
Say sales are ₹5,50,000. Net purchases are ₹4,60,000, after the credit note above. Sales minus purchases is ₹90,000. Running costs: rent ₹30,000, pharmacist ₹22,000, electricity including the fridge ₹8,500, billing software ₹1,000, delivery ₹4,000 and licence and miscellaneous ₹1,500. Those add to ₹67,000. The month leaves ₹23,000. These are only sample numbers. Your margin depends on what you stock and how you buy, so compare your own months with each other.
How do credit customers and discounts fit?
Some customers, such as regular elderly patients or clinics, buy on credit and settle later. Keep a ledger with the name, the amount, the date and part-payments, the same way as for any trade credit. If you give a discount on a bill, make sure the bill shows it, and that your sales total reflects the discounted amount. A long list of unpaid accounts can tie up more cash than a slow month.
Which small items get missed at a medical store?
- Electricity spikes in summer, when refrigerators work harder.
- Cash paid to a delivery boy for a quick supply run.
- Stationery for prescriptions, bill rolls and printer ink.
- Courier charges for returns and urgent orders.
- Repairs to a fridge or an inverter paid by UPI with no bill.
Because margins on each sale are small, these items matter. A tracker that includes them gives a truer picture than one that only compares sales with purchases.
A routine that fits a busy counter
- Each evening, note the cash total and UPI total.
- Each week, file distributor bills and credit notes.
- Each month, list stock near expiry and what you plan to return.
- Upload the bank statement and tick distributor payments.
SpendixAI can import the statement after you choose the account and let you add cash costs in batches. Your billing software remains the source for sales.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


