Product guides

Using an amount range to find the odd one out

When a total looks wrong but nothing stands out, an amount range filter helps you home in on the entry that does not belong.

Editorial illustration for Using an amount range to find the odd one out

A monthly total can look wrong without any single entry looking wrong. The only way to find the cause is to search by size. The filter sheet lets you set a minimum and maximum transaction amount, and used cleverly it narrows a long list down to the few entries worth inspecting.

How the amount filter works

The amount filter has two fields, minimum and maximum. Enter either or both. If the minimum is higher than the maximum, the sheet tells you so. It notes that amounts are compared using each transaction's own currency, before any conversion. That is important if you track more than one currency, since a figure of 1,000 in one currency is not the same as 1,000 in another.

Combine the amount range with other filters, such as type or date range, to restrict the search to exactly the slice you care about.

Three ways to use it

**Hunting big items.** Set a high minimum, perhaps a few multiples of your usual payment. The result is a short list of unusually large transactions. Read each. Is it genuine? Is it categorised sensibly? Is it duplicated?

**Hunting tiny items.** Set a low maximum. Very small amounts often hide fees, trial charges or repeated micro-payments that add up. A pile of small entries can matter more than a single large one.

**Hunting exact amounts.** If you suspect a duplicate or want to match a receipt, set the minimum and maximum close together, around the figure you are looking for.

A worked example

A month's food spending seems 2,000 units higher than usual. No single entry looks odd in the category view. Setting the filter to food, then a minimum of 500 units, produces nine entries. Two are for 1,200 units on consecutive days, with the same merchant. On inspection, one is a duplicate caused by an import overlap. Removing it brings the total back in line.

Without the amount filter, the pair could have stayed hidden in a list of seventy items.

Pair with the duplicates screen

If the odd one out turns out to be a duplicate, Spendix has a dedicated duplicates view that lists suspicious pairs. The amount filter is for general investigation, while the duplicates view specifically compares similar entries. Use them together: the filter for hunches, the duplicates view for confirmation.

GoalFilter setting
Find unusually large paymentsHigh minimum
Find tiny chargesLow maximum
Match an exact figureNarrow min and max around it
Check a typical dayRange around your usual spend

Practical cautions

Remember that refunds and income share the list with expenses unless you filter by type. If you see an amount that seems wrong, check whether it is a credit. And as with all filters, clear them when finished. A forgotten amount range is a common reason for a mysteriously short list later.

Small amounts add up

Do not dismiss the low end of the range. A scatter of small charges, each unremarkable alone, can quietly rival a large purchase over a month. Set the maximum low and look at how many entries remain and what they share. If several come from one source, a single decision, such as cancelling a service, can remove all of them at once.

Make it routine

Once a month, apply a high-minimum filter to the previous month and read through the results. It takes two minutes and reliably surfaces anything that deserves a second look.

SPENDIXAI JOURNAL

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

Explore your reports