For a condition that lasts years, start a fresh sheet every year with the same headings, carry over only the open items, and keep each year's sheet as it was. A single endless sheet gets slow, hard to read and easy to break. One sheet per year gives clean totals, easy comparisons and a tidy file if anyone ever asks about a particular year.
Why not keep one long sheet?
A long-running sheet picks up changes along the way: a new column here, a renamed heading there. After three or four years, nobody remembers what a column meant, and formulas quietly stop covering new rows. A yearly sheet resets all that. Its natural boundary also matches the April to March financial year, if you prefer that, or the calendar year, whichever your household uses. Pick one and stay with it.
What should the fixed headings be?
| Column | What it holds | Why it stays fixed |
|---|---|---|
| Date | Date on the bill | Allows monthly totals |
| Type | Medicine, test, consultation, procedure, travel, equipment | Allows comparison year to year |
| Provider | Doctor, lab or chemist | Shows where money goes |
| Amount | Rupees paid | The core figure |
| Paid by | Which account or person | Matches statements |
| Claim status | Not claimed, submitted, received, rejected | Tracks open items |
| Amount received | Reimbursed amount, if any | Shows net cost |
| Paper | Where the bill or report is saved | Helps you find it later |
Copy the previous year's sheet, delete the rows, and keep the headings. If you decide you need a new column, add it at the end, and add it in the template as well, so future years have it too.
How do you roll over open items?
An open item is something still waiting, such as a claim submitted but not settled. On the last day of the year, filter the claim status column for submitted and list those items on a short carry-over page at the top of next year's sheet. Say two items total ₹14,000 and ₹9,500 and are still pending. The carry-over is ₹23,500. When money arrives, record it in the year it was received, and tick the item off on the carry-over list. Never edit the earlier year's total after you close it.
How do you compare two years?
With the same headings, a short summary of totals by type for each year fits on one page. Say the medicine total was ₹28,000 last year and ₹31,500 this year, an increase of ₹3,500. Consultations went from ₹9,000 to ₹7,200, a decrease of ₹1,800. A summary like this helps you see where the cost moves. It does not say why; for that, go back to your notes and the doctor.
- Totals by type for the year, side by side with the previous year.
- The highest single month and the reason for it.
- Net cost: total paid minus amount received.
- Number of visits and tests, as a count.
- Open items carried forward, with their total.
A little sheet hygiene helps. Freeze the header row, keep dates as real dates rather than typed text, and use one tab for entries and another for the summary. Back the file up in two places and name it with the person's initials and the year. If more than one person in the family has a long-term condition, keep a separate file for each, so totals never mix.
Where does an app fit?
A sheet per year suits many families. When bills come from several accounts and cash, SpendixAI offers statement import with review, manual entry, receipts kept with transactions and reports you can filter by date, which makes a year's totals quick to produce. It is one option, not a requirement.
Year-end routine
- Enter every bill received before the year end.
- Filter by claim status and list open items.
- Total each type and the whole year.
- Save the sheet under the year's name and set it read-only.
- Copy the headings into a new sheet and add the carry-over page.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


