Money tips

How much of your month sits in five payments? A euro Pareto check

Find the largest transactions this month in Europe, then measure how much of your spending the top five make up, with a euro example and a SUMPRODUCT formula.

Editorial illustration for How much of your month sits in five payments? A euro Pareto check

Find your five largest transactions, add them up and divide by the month's total. That share tells you how concentrated your spending is, and which handful of lines deserve a careful look before you spend time on the small ones.

The idea in one example

Say a month's spending totals €2,140 across many transactions. The five largest are €780, €310, €185, €140 and €96.

StepWorkingResult
Top five added together€780 + €310 + €185 + €140 + €96€1,511
Share of the month€1,511 / €2,140About 71 per cent
Everything else€2,140 - €1,511€629

Five lines make up roughly 71 per cent of that month, and the other €629 is spread across a long tail of small ones. In your own month the proportions will differ; the point is to measure it rather than assume.

What does the share tell you?

  • A high share means a few decisions drive your month: housing, a loan, a big annual bill. Checking those five for accuracy is worth more than any other effort.
  • A low share means the money is scattered over many small purchases. Then the most valuable step is grouping by merchant or category, not staring at the top of the list.
  • A share that changes sharply from one month to the next means a one-off, so find out which line moved.

How do I calculate it in a sheet?

With amounts in C2:C200, the top-five total is:

=SUMPRODUCT(LARGE($C$2:$C$200,{1,2,3,4,5}))

The curly brackets hold an array of ranks. LARGE returns the five biggest amounts and SUMPRODUCT adds them. The share is that divided by the month's total:

=SUMPRODUCT(LARGE($C$2:$C$200,{1,2,3,4,5}))/SUM($C$2:$C$200)

Format the cell as a percentage. This works in Excel and in Google Sheets. In some locales the separator inside the braces is a different character, so if you see an error, check how your sheet writes array constants. And if you have fewer than five transactions, LARGE will return an error, so keep the range to real data.

Which of the top five deserve a closer look?

Start from the one you least remember. For each line, confirm the date and amount against the order or booking confirmation, check that it sits in the right category, and note whether it is a one-off or repeats. If your accounts are in more than one currency, convert each line at the rate shown on its own statement line before ranking, otherwise a €90 purchase and a 90 unit foreign purchase will be compared as if they were equal.

And the long tail?

The €629 in the example may look harmless, but it is made of everything that can quietly grow. Sort that part by merchant and count how many payments went to each. Three coffee runs are a habit; thirty are a budget line. Also check for the same amount to the same merchant twice in one or two days, which can indicate a duplicate.

Tracking the share month by month

  1. Record the month's total and the top-five total.
  2. Write the share as a percentage.
  3. Note the names of the five.
  4. Next month, compare: which names are new, which have grown, which have gone?
  5. Keep the notes in the same sheet so the trend is visible after a quarter.

SpendixAI has a Report builder for filtering and grouping and a CSV download, which can supply the list for a calculation like this. It is built around India and INR, so it is aimed at readers in India and not at euro accounts.

SPENDIXAI JOURNAL

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

Explore your reports