A family health checkup calendar is a sheet that lists each person, the month their doctor advises a check-up, the clinic, the cost last time and where the report is stored. Spread the months across the year so that the cost and the effort are not piled into one week. The dates and tests come from your own doctor, never from the sheet.
What columns does the calendar need?
| Column | What to write |
|---|---|
| Person | Name of each family member |
| Advised by | The doctor who set the schedule, and the date of that advice |
| Last done | The date of the last check-up |
| Next due | A formula from the last date and the interval the doctor gave |
| Clinic or lab | Name and area |
| Cost last time | Amount from the receipt |
| Reports | Folder path where the reports are filed |
How do you get the next due date automatically?
Put the last date in column C and the interval in months in column D, as advised by the doctor. In E2, enter =EDATE(C2, D2). EDATE returns the date that many months later, and it works in Excel and Google Sheets. Format column E as a date. For a yearly check-up, the interval is 12. A person whose doctor advises six-monthly review has 6.
How can the months be spread across the year?
If everyone's dates fall in the same month, costs bunch up and so do the appointments. Where the doctor allows it, you can use a date that helps: a birthday month, the month after a policy renewal, or a quiet month at work. Ask the doctor before shifting any date, because the interval may matter.
An invented spread: Father in April at ₹4,000, Mother in May at ₹4,500, you in August at ₹3,200, and your spouse in September at ₹3,200. The year's cost is ₹4,000 plus ₹4,500 plus ₹3,200 plus ₹3,200 = ₹14,900, and no month carries more than ₹4,500.
What about children and older relatives?
Add rows for them with the schedule the paediatrician or the family doctor has given, which may follow vaccination or growth checks, not a yearly pattern. For elders, ask the doctor how the schedule differs and write that beside the name.
How do you record the cost and the reports?
After each check-up, fill the Last done date, the cost from the receipt and the folder path of the report on the same day. A naming habit like 2026-11 Mother Annual Checkup saves search time. If your health policy has a check-up benefit, note in a column whether you used it and what was reimbursed, and check the policy for its terms instead of assuming.
In SpendixAI, you can add each check-up as an expense under a Medical category and keep the receipt with it, so the calendar stays a summary and the spending sits with your other records.
What if someone's schedule changes?
Doctors change intervals as health changes, so treat the Next due column as a prompt and not a rule. When a doctor moves a date earlier or later, change the interval in column D and write the reason and the date of the advice in a notes column. Keep one line for any new test a doctor adds to someone's routine, with the name of the test as written on the prescription. Over a few years this note column becomes a short medical timeline for the person that you can hand to any new doctor.
A yearly routine
- In April, review the sheet and update the due dates.
- Book the appointments for the next three months.
- After each visit, update the last date, cost and report path.
- Ask the doctor if the schedule should change after any new finding.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


