Two kinds of health money
Health spending can be roughly divided into money spent to stay well and money spent to get better. Preventive spending includes checkups, vaccinations, screening tests and routine dental cleaning. Treatment spending includes consultations for illness, medicines for conditions, procedures and hospital stays. Seeing the balance between the two gives a more complete picture than the total alone.
Prevention does not guarantee lower treatment costs, and no spreadsheet can promise that. The table is only a way of seeing where the household’s health money goes.
Decide which items are which
Write a short rule: preventive means advised or scheduled to detect or avoid problems; treatment means responding to a problem. Some items straddle the line, such as follow-up tests after a screening. Decide a consistent treatment for each and note it.
Build the table
Using the last twelve months of health transactions, assign each to preventive or treatment, perhaps through a tag. Total each and note the proportion.
| Type | Examples | Amount for the year | Share |
|---|---|---|---|
| Preventive | Checkups, vaccinations, dental cleaning | 9,000 | 15% |
| Treatment | Consultations, medicines, procedures | 51,000 | 85% |
| Total | All of the above | 60,000 | 100% |
What to look for
A very small preventive share may suggest that routine care is being skipped, or simply that the household is young and healthy. A large preventive share is normal in a year with many vaccinations. The point is not to reach a target ratio but to notice what the numbers say and ask whether they fit your situation.
Look at the trend over years
A single year is a snapshot. Over three or four years, you may see the proportions shift as the household ages or as treatment needs change. Use the trend to plan reserves and to schedule routine care you may have delayed.
Do not skip needed care to improve the table
The table is a tool, not a goal. Do not reduce treatment spending by avoiding necessary care, and do not inflate preventive spending with services that a doctor has not recommended. Follow medical advice, and use the numbers to plan.
Plan next year’s preventive line
Ask your doctor what routine care is advisable for each family member over the next year, and put it on a calendar with estimated costs. Funding preventive care as a planned line gives it priority and makes sure it is not squeezed out when the month gets busy.
What counts as prevention for different ages
Preventive needs change with age. Children need vaccinations and growth checks, adults need periodic checkups and screening as advised by their doctors, and older relatives need regular reviews. Ask the family doctor to outline what is sensible for each person, and note it as a list with approximate costs. The table then reflects advice, not guesswork.
Include dental and eye checks in the preventive group, as they catch problems before they grow.
Balancing, not trading off
It would be wrong to treat prevention and treatment as competing for the same limited money, as though less of one will produce more of the other. Both are needed. The point of the table is to make sure that routine care is not squeezed out when the budget tightens and to show how much of the health spend is planned versus reactive.
A rising proportion of planned spending often means fewer last-minute decisions. That is a calmer way to manage health money, whatever the exact ratio.
Update the table each year, and use it to talk with your doctor about the right schedule for the household.
If the proportions seem odd, check the tagging first. A few large items assigned to the wrong group can distort the picture, and a fifteen-minute review of the biggest ten transactions usually corrects it.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


