A yearly thyroid cost sheet has two parts: a steady monthly line for tablets and an occasional line for lab tests and consultations. Keep them on separate rows so a test month does not make the month look expensive, and let the yearly total and a monthly average tell you the true everyday figure.
How should the year be laid out?
Twelve columns for the months, and four rows: medicines, lab tests, consultations and the monthly total. The rows stay the same every year. The numbers below are invented, to show how a test spike behaves.
| Row | Jan (₹) | Feb (₹) | Mar (₹) | Apr (₹) | Jul (₹) | Oct (₹) |
|---|---|---|---|---|---|---|
| Medicines | 210 | 210 | 210 | 210 | 210 | 210 |
| Lab test | 0 | 0 | 900 | 0 | 0 | 900 |
| Consultation | 0 | 0 | 600 | 0 | 0 | 600 |
| Month total | 210 | 210 | 1,710 | 210 | 210 | 1,710 |
The months not shown, May, June, August, September, November and December, follow the same pattern of ₹210 for medicines. Across the year: medicines are twelve times ₹210, which is ₹2,520. Lab tests are two times ₹900, which is ₹1,800. Consultations are two times ₹600, which is ₹1,200. The yearly total is ₹2,520 plus ₹1,800 plus ₹1,200, which is ₹5,520, and the monthly average is ₹5,520 divided by 12, which is ₹460.
Why does the average matter?
If you only looked at March, you would think the condition costs ₹1,710 a month. If you only looked at April, it would seem to cost ₹210. Neither is right. The average of ₹460 is the number to use when you plan the household budget, and the test months are the ones to prepare for by setting a little aside each month.
How do you set money aside for the test months?
Take the cost of the occasional items and divide by twelve. Here tests and consultations add up to ₹3,000 a year, so ₹250 a month into a health reserve covers them. The sheet then has a reserve row showing the balance, and when a test comes, the reserve pays for it and the monthly line stays flat.
- Medicines row: record the actual amount paid, not the price you expect.
- Lab test row: note the test names and the lab in the notes, so repeats can be compared.
- Consultation row: include any follow-up visit fee.
- Reserve row: add the monthly set-aside and subtract the actual test and visit costs.
- Notes row: record any dose change, as it can change the medicine cost.
What papers should be kept with the sheet?
Keep the prescription, the lab report and the bill for each test in date order. Reports matter to your doctor and the bills matter to your records. If a doctor changes the dose or advises a repeat test earlier than planned, note the date and the reason on the sheet, so the spike in that month makes sense when you read it later.
Some people also have a scan or a specialist visit now and then. Give those their own row rather than hiding them inside the lab test row, and the sheet will still compare cleanly with next year. If a dose change raises or lowers the monthly tablet price, write the date of the change in the notes row and carry on; from that month, the new figure is the normal one.
When does a sheet stop being enough?
If several family members have different conditions and bills come from different accounts, a sheet gets crowded. SpendixAI offers statement import with review and manual entry, custom categories per person and a Report builder for grouping by month. A mention is all it needs; many people will do well with a sheet.
Year-end checklist
- Total each row and the whole year.
- Work out the monthly average and compare it with what you budgeted.
- List the tests and visits for next year as far as your doctor has advised.
- Move any unused reserve forward or release it.
- Save the sheet and start a new copy with the same headings.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

