Product guides

The Health category in the report library

The built-in reports can answer many health-money questions without custom work. Knowing which view answers which question saves time.

Editorial illustration for The Health category in the report library

Questions first, reports second

People often open the report library and wander. A faster route is to start from the question and find the matching view. Health spending raises several recurring questions, and the standard reports are well suited to most of them when the category structure is set up sensibly.

This article assumes that your Health transactions are categorised, with sub-categories or tags for episodes.

Which view answers which question

QuestionLook at
How much do we spend on health each month?Category totals over time, filtered to Health
Is the cost rising?Trend view across several months
Which sub-areas cost most?Breakdown by sub-category
What did a particular illness cost?Tag-based filter on the episode tag
Which merchants do we pay most?Merchant ranking within Health

The monthly trend

A line or bar chart of Health spending by month shows rhythm and spikes. Add a moving average if it is available, because it smooths the lumpy months. Look for steps rather than spikes: a step up that persists means a new regular cost.

The breakdown

A breakdown by sub-category, such as medicines, consultations, tests, dental and eye, shows where the money goes. A pie chart can be misleading when there are many small slices, so prefer a ranked bar view if it exists. The top two or three items usually deserve most of your attention.

Episode reports

Filtering by the episode tag gives a total that spans months and categories. Use it at the end of a treatment to see the full cost and to attach the summary to the file. Compare the result with the original estimate, if one existed.

Merchant ranking

If one pharmacy or lab accounts for a big share of spending, that is a place to compare prices or check for pattern changes. The ranking also helps you spot duplicates and merchants whose names appear in several forms, which a clean-up of merchant aliases can merge.

Exporting for others

To share with an insurer, an adviser or a sibling, export the filtered report in the format needed. Remove columns with sensitive notes that are not required. A focused export communicates better than a full dump.

Save the reports you use often so that next time you need only open and read them. A small library of three or four saved health reports is usually enough.

Setting up saved views

Create three saved views and name them clearly: a monthly trend for Health, a sub-category breakdown and a tag-based view for current episodes. Save them, so they are always a click away. Adjust the period when you open them. Having them ready lowers the effort of checking, and what is easy to check is checked more often.

If the library offers presets for common reports, start from those and adjust the filters rather than building from scratch.

Reading with context

Reports show numbers; they do not show reasons. Pair each reading with a note or a memory of what happened. A spike in the chart should lead to the list of transactions, and then to the receipts or notes that explain it. If no explanation exists, add one now while you remember.

Over time, the habit of annotating makes reports far more useful to anyone who reads them later, including you. A chart with a few notes beside the peaks tells a story, while a bare chart is only a picture.

Limits of the report

Reports are only as good as the categorisation behind them. If many health payments sit in Miscellaneous, the Health charts will understate. Spend a few minutes each month moving stray entries into the right place, and check that merchants are labelled properly. Clean data is the foundation of every useful report.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports