For a parents' annual health checkup record, keep one row per parent per year with the lab or hospital, the package cost, add-on tests, follow-up doctor visits, the total, and a link or folder path to the reports. After three or four years, the table shows what a check-up costs, which add-ons keep recurring and where each year's reports sit, so nobody is hunting through old WhatsApp chats.
What columns does the yearly table need?
| Column | What goes in it |
|---|---|
| Year and date | The date the tests were done, not the booking date |
| Parent | Father or Mother, one row each |
| Lab or hospital | Name and branch, so you can find the report copy later |
| Package cost | What was paid for the basic package, as on the receipt |
| Add-on tests | Extra tests ordered during the visit, with their cost |
| Doctor visits | Consultation to review the results, and any follow-up |
| Total | Package plus add-ons plus visits |
| Reports | Folder path or link where the files sit |
What does a filled-in year look like?
Here are invented numbers to show the layout. Your parents' figures will be different.
- Father: package ₹3,800 plus add-on tests ₹1,700 plus doctor follow-up ₹800 = ₹6,300.
- Mother: package ₹3,800 plus add-on tests ₹2,400 plus doctor follow-up ₹1,200 = ₹7,400.
- Both parents for the year: ₹6,300 plus ₹7,400 = ₹13,700.
The same total in a sheet comes from =SUM(D2:F2) in the Total cell for each row if the package, add-ons and visits sit in columns D to F, and =SUM(G2:G3) for the year's combined figure.
How should the add-on tests be recorded?
Add-ons are where the cost moves from year to year, so give them their own cells and write which test it was, copied from the receipt. Do not decide which tests a parent needs. That is a decision for their doctor, who can tell you which ones to repeat and how often. Your sheet only has to show what was ordered, who ordered it (the package, the doctor or the lab's suggestion) and what it cost.
Does the insurer pay for a health check-up?
Some health policies include a check-up benefit and some do not, and the terms differ. Look at each parent's policy wording, and write in the sheet whether the benefit exists, what it covers and whether you must book through a particular network lab. If a benefit applies and a reimbursement arrives, add the date and amount in a notes column and lower the net cost for that row.
How do you compare one year with the next?
Cost comparisons are easy: add a Change column that shows this year's total minus last year's. For results, do not try to read trends yourself. Take the reports to the doctor and ask them to compare. In the sheet you can note 'discussed with doctor on 12 Nov, follow-up in 6 months' beside the row, which is the kind of line you will want to see later.
How can the sheet fit with day-to-day tracking?
The package payment is also an ordinary expense. If you track household spending in SpendixAI, you can add it with a category such as Medical, and keep the receipt with the transaction. The yearly table stays your summary, and the report files stay where you put them.
Before the next check-up
- Add a new row for each parent with the planned month.
- Ask the lab what the package includes, in writing.
- Book the doctor's review at the same time as the tests.
- After the visit, fill in costs and the report location the same day.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

