Diabetes care has a rhythm of predictable costs: medicines every month, test strips on whatever schedule your doctor sets, lab tests every few months and consultation fees. A monthly sheet with one row for each of these, plus a yearly total beside it, shows the real figure and prevents surprises when a big test month arrives.
What should the monthly sheet list?
Keep the rows the same every month, so months can be compared. The sheet below uses invented amounts, which you should replace with your own. Do not change the headings from month to month.
| Item | Jan (₹) | Feb (₹) | Mar (₹) | Notes |
|---|---|---|---|---|
| Medicines | 1,450 | 1,450 | 1,600 | Dose change in March |
| Test strips | 600 | 0 | 600 | One box every two months |
| Lab tests | 0 | 0 | 1,900 | Quarterly panel |
| Doctor consultation | 0 | 700 | 0 | Every second month |
| Monthly total | 2,050 | 2,150 | 4,100 | Sum of the rows above |
The March total is ₹1,600 plus ₹600 plus ₹1,900, which is ₹4,100. The sheet shows a simple truth: costs are lumpy, not flat. A quarterly test makes one month look expensive though the yearly figure is steady.
How do you work out the yearly total and a monthly average?
Add the twelve monthly totals. Say the year totals ₹33,600. The monthly average is ₹33,600 divided by 12, which is ₹2,800. In a sheet with months in columns B to M and the total row in row 6, =SUM(B6:M6) gives the yearly total and =AVERAGE(B6:M6) gives the average. When you plan a household budget, use the average and also keep a cushion for the heavier months.
How do you plan for refills?
Add a small column of refill dates. If a pack of tablets lasts thirty days and you collected it on the third, mark the second or third of the next month as the next date. Planning this way means you buy before running out, and it helps you notice when a chemist's price changes from one visit to the next. Ask your doctor or pharmacist about the right quantity and brand; this sheet only records what you actually bought.
- Write the strip box count and the date opened, so you can see how many days one box lasts.
- Record the brand or strength bought, as this may change over time.
- Note any home-monitor purchase or battery replacement as a separate line.
- Keep the lab reports in date order alongside the sheet.
- Add a row for any extra visit, such as a foot or eye check, so it shows in the yearly figure.
Eye, foot and kidney checks are sometimes advised on a yearly rhythm. If your doctor has set any, give each its own row with the month it is due, so the cost does not arrive as a surprise. Also note the small extras around a lab visit, such as the trip itself, and keep any receipt for a phone consultation under the same consultation row.
Is a spreadsheet enough?
For one person, usually yes. If purchases come from several accounts or cash, SpendixAI can take a bank or card statement upload for review and lets you add cash chemist bills by hand, with a custom category for diabetes care and monthly reports. Treat it as an option when the sheet stops being easy to keep up.
What to do at year end
- Total each row for the year, then the whole sheet.
- Check the highest month and note why, for example a quarterly test or a dose change.
- Compare with last year's row totals, if you have them.
- Keep the year's bills in one envelope in case an insurer or adviser asks.
- Start the next year's sheet with the same headings.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


