Money tips

Track your largest transactions month by month in Australian dollars

Find the largest transactions this month in Australia and compare them with earlier months using MAXIFS, with an A$ example of how a top five shifts.

Editorial illustration for Track your largest transactions month by month in Australian dollars

Finding the biggest transaction in one month tells you little. Finding it in three months in a row shows you whether a cost is creeping up. Work out the largest transaction, and the top five, for each month, and compare the totals.

What do you compare?

Use the same definition each time: the five largest transactions in the month, with the same exclusions. Say you list rent as a fixed cost, so you leave it out of the comparison, because it would always be first and would add nothing new.

A worked comparison

Hypothetical numbers over three months, rent excluded.

MonthTop five (A$)Total
First month420, 310, 190, 150, 120A$1,190
Second month265, 240, 210, 130, 110A$955
Third month510, 330, 295, 180, 140A$1,455

Check the totals: 420 + 310 + 190 + 150 + 120 = 1,190; 265 + 240 + 210 + 130 + 110 = 955; 510 + 330 + 295 + 180 + 140 = 1,455. The third month's top five are A$500 above the second month's (1,455 - 955), and A$265 above the first month's (1,455 - 1,190). That is the month to investigate, and the top line, A$510, is the first place to look.

How do I find each month's biggest with a formula?

Put dates in column A, amounts in column C and categories in column D. Put the first day of the month you want to examine in cell F2, for example the 1st of March. Then:

=MAXIFS($C$2:$C$400,$A$2:$A$400,">="&F2,$A$2:$A$400,"<="&EOMONTH(F2,0),$D$2:$D$400,"<>Rent")

MAXIFS returns the largest amount that meets every condition: on or after the first of the month, on or before the last day, and not categorised as Rent. EOMONTH(F2,0) gives the last day of that month. MAXIFS is available in Excel 2019 and 365 and in Google Sheets; older Excel versions do not have it.

For the second, third, fourth and fifth largest, the simplest route is to sort that month's rows, or to filter the month and use LARGE on the filtered list.

What should I do when one month jumps?

  1. Open the biggest line in the jumping month and confirm that it is real and correct.
  2. Ask whether it is one-off, such as an annual bill or a repair, or whether it will recur.
  3. If it will recur, add it to your planned fixed costs.
  4. If it is one-off, note it so next month's comparison is not a false alarm.
  5. Check the description text on the statement for anything you cannot read: bank descriptions can be short and cryptic, so match the date and amount against your emails instead.

Do I need three months?

Two is the minimum for a comparison. Three starts to show a direction. Six lets you see seasons, such as higher costs around school terms or holidays. Do not read too much into a single jump, but do not ignore a pattern of three.

Spotting the slow creep

Sometimes it is not one line that grows but the same line repeating at higher amounts: an insurance renewal, a vet visit, an annual subscription that went up. Keep the largest line of each month in a running list with a one-word label. If you see the same label in the third position, then the second, then the first, you have found a trend before it became a problem.

Closing checklist

  • Same definition each month, written down.
  • Rent and other fixed items excluded or shown separately.
  • Largest and top-five totals recorded each month.
  • Any line that jumped has a note explaining why.
  • A receipt or confirmation kept for the largest line.

SpendixAI offers a Report builder and CSV download for filtering and grouping, though it is built around India and INR; the same comparison is easy in any sheet for Australian dollars.

SPENDIXAI JOURNAL

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

Explore your reports