Give recurring health supplies, such as test strips, lancets and gloves, their own line instead of mixing them into medicines. For each item note the pack size, the price, how many you use a day, how long a pack lasts, and a reorder date. Then your monthly supplies cost is a number you can see and plan for.
Why supplies deserve a separate line
Supplies are small, frequent and easy to overlook. A box here, a pack there, often bought from a different shop than the medicines. Mixed into one Health total, they make medicine costs look higher, and they make the supplies themselves invisible. Separate lines let you see each cost clearly and spot when one creeps up, say because usage went up or a different brand was bought.
What to record for each item
- Item and who uses it
- Pack size: how many pieces in the box
- Price paid and shop
- Pieces used per day, as advised by whoever is providing the care
- Days a pack lasts
- Date bought and the reorder date
- Expiry date printed on the pack, because some supplies carry one
How many to use, and how often, is for your doctor or nurse to say. The sheet only records what the household actually uses.
A worked example for one month
Say a household uses the following. Quantities and prices are made up, and a 30-day month is assumed.
| Item | Pack size | Pack price (Rs) | Cost per piece (Rs) | Used per day | Used in 30 days | Cost for 30 days (Rs) |
|---|---|---|---|---|---|---|
| Test strips | 50 | 600 | 12.00 | 2 | 60 | 720 |
| Lancets | 100 | 150 | 1.50 | 2 | 60 | 90 |
| Disposable gloves | 100 | 350 | 3.50 | 3 | 90 | 315 |
| Total | 3 items | - | - | - | - | 1,125 |
Test strips: ₹600 divided by 50 is ₹12 each, times 60 is ₹720. Lancets: 150 divided by 100 is ₹1.50, times 60 is ₹90. Gloves: 350 divided by 100 is ₹3.50, times 90 is ₹315. Altogether 720 + 90 + 315 = ₹1,125 a month.
How long does a pack last?
Divide the pack size by the pieces used per day. Strips: 50 divided by 2 is 25 days. Lancets: 100 divided by 2 is 50 days. Gloves: 100 divided by 3 is about 33 days. Notice that a box of strips runs out in 25 days, before the month does, so you buy a little more than one box a month. That is why reorder dates are useful: each item has its own rhythm.
The sheet and the formulas
Columns: A Item, B Pack size, C Pack price, D Used per day, E Date bought. In Excel or Google Sheets:
- Cost per piece in F2: =ROUND(C2/B2, 2)
- Cost for 30 days in G2: =F2*D2*30
- Days a pack lasts in H2: =B2/D2
- Reorder date in I2, a few days before it runs out: =E2+H2-3
- Total monthly cost of supplies: =SUM($G$2:$G$50)
Where does an app help?
If you pay by UPI or card, supply purchases show up in statements. SpendixAI lets you import them, put them in a Health sub-category of your own named Supplies, and attach the bill. For cash purchases from a local store, you can add the expense by hand. The reorder calendar and cost-per-piece working still live in the sheet.
When should I review the numbers?
- At each quarter's end, recompute the cost for 30 days from the latest bills.
- If usage changes, update the used-per-day figure at once.
- If the price per piece moves noticeably, note the shop and brand and compare.
- Keep the reorder date visible, on the fridge or in your phone, so you do not run out.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

