Product guides

From a report figure down to the transactions behind it

Every number in a report comes from real transactions. Use drill-in to trace a figure to its source and confirm, correct or question it.

Editorial illustration for From a report figure down to the transactions behind it

A report summarises. A transaction list details. The path between them is drill-in: tapping a slice, a bar or a row to see exactly which entries it contains. Many reports label their sections as tap to drill in, which is a small prompt for one of the most useful habits in the app.

Why drilling matters

A figure you cannot trace is a figure you cannot trust. When a report says travel cost a large amount, the natural question is why. Drilling in answers it. You see the transactions, their dates, their merchants and their amounts. Often one or two entries explain most of the figure.

Drilling also guards against a quiet failure: categories that look reasonable but are full of misfiled items. Only reading the entries reveals that.

Two common drilling routes

Reports typically offer two ways in. A breakdown view lets you tap a category or other grouping to see its transactions. A by-month view lets you tap a month's bar to see what happened then. The first answers what; the second answers when.

Combine them. Start with the breakdown to find the category that grew, then switch to the month view to find when it grew, then open the month's entries to find what changed.

What to do with what you find

Once you are in the list of transactions, you have several options.

  • **Confirm.** The entries match the figure and make sense. Nothing to do.
  • **Correct.** An entry is in the wrong category or has a wrong amount. Fix it, and the report updates.
  • **Question.** An entry looks unfamiliar. Open it, check the receipt or note, and compare with your bank.
  • **Automate.** A pattern of corrections suggests a merchant default or a rule.

A short example

A monthly report shows a rise in household spending of about 1,500 units. Tapping the household slice lists thirty entries. One is a single payment of 1,400 units for a repair, the rest are routine. The explanation takes ten seconds, and the conclusion is that nothing about daily habits changed. Without the drill, the same rise might have prompted unnecessary worry or a pointless budget cut.

Keep track of context

The list you reach by drilling is a filtered view. It reflects the report's period and settings. If you then wander off into the full transaction list, remember the earlier filter might still apply. Clear filters when you are done, so the next look at the main list is not unexpectedly narrow.

You seeDrill into
A large sliceThat category's entries
A tall barThat month's entries
A sudden changeThe entries nearest the change
A small slice you do not recogniseThe entries; it might be miscategorised

When the numbers do not add up

Occasionally the entries behind a figure do not seem to sum to it. Check three things: the report may exclude some items you can see in the main list, such as transfers kept out of reports; the period may differ by a day; or a filter may still be active. Resolving the gap usually teaches you something about how the report is built.

If it still looks wrong, note the figure, the period and the settings, and compare against a plain list for the same slice.

Make it a reflex

Whenever a figure matters enough to act on, drill first. It adds a minute and removes the risk of acting on a misunderstanding. Over time the habit builds an accurate mental picture of what lies behind each total, which makes every report quicker to read.

SPENDIXAI JOURNAL

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

Explore your reports