Product guides

Last month or full year: picking the report range

Range changes what a report means. Match the range to the question, and learn when to compare a short view with a long one.

Editorial illustration for Last month or full year: picking the report range

Reports let you choose a range, often with options like last month and full year. The choice looks trivial, but it changes what the numbers can tell you. A figure that is alarming over one month may be ordinary over twelve, and a quiet year may hide a lively month. Picking the range deliberately is part of reading a report correctly.

Last month: precision and freshness

Last month is a completed, recent slice. It is best for questions about behaviour you can still influence: did I overspend, did the new habit work, which bills landed. Because it is recent, you remember the context, so surprises can be explained from memory.

Its weakness is volatility. One unusual payment can dominate. Treat a single month as a data point, not a verdict.

Full year: pattern and scale

A full-year range smooths out noise and exposes annual patterns: festival months, school fees, insurance renewals. It shows the total cost of recurring things, which is often startling when a small monthly charge is multiplied by twelve. It is also the range for annual summaries and tax preparation.

Its weakness is lag. A trend that began two months ago barely shows in twelve months of data. Use a shorter range to catch recent changes.

Using both together

The most informative practice is to read both. Put last month's figure beside the yearly average, found by dividing the annual total by the number of months. If last month is far above the average, ask why. If it is close, you are on pattern.

For example, an annual spend of 144,000 units implies a monthly average of 12,000. A month at 15,000 is a quarter above average. Whether that matters depends on whether the extra came from a one-off or a creeping habit, which drilling into the transactions will reveal.

Partial years and new accounts

If you started tracking mid-year, the full-year range includes only the months with data. The total will look low, and the average per month computed over twelve will be wrong. Divide by the number of months with records instead. The same applies to any account that was added late.

Align with how the money actually flows

Some people are paid mid-month, and cycles for cards run from one date to another. If calendar months do not match your cycle, a custom range that aligns with it can answer questions more truthfully. A month defined by payday to payday often matches your experience of money better than the calendar does.

QuestionRange
Did last month's plan work?Last month
What is my normal spending?Full year, divided by months
What does a subscription really cost?Full year
Did a recent change help?Last month against the prior one
Preparing annual figuresFull year

Rolling ranges for ongoing tracking

If your reports allow ranges such as the last three months or the last twelve, these rolling views avoid the cliff edges of calendar boundaries. A rolling twelve months always contains one of each seasonal month, so it behaves like an annual view that updates every month. For ongoing tracking this is often more informative than waiting for a financial year to close.

Use calendar ranges for filing and rolling ranges for monitoring.

One more caution

Keep the range constant when comparing two reports. Putting a month beside a year is meaningful only when you convert to a common unit, such as a monthly average. Without that, the year always looks huge and the month always looks small, which says nothing about your habits.

SPENDIXAI JOURNAL

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

Explore your reports