Getting started

Counting your monthly payments: a quick way to see how often you spend

Work out how many card and bank payments you made last month in euros, split by weekday and by recurring or chosen, using simple spreadsheet formulas.

Editorial illustration for Counting your monthly payments: a quick way to see how often you spend

Try a small test before you open any statement: write down how many times you think money left your account last month. Then count the rows. The gap between the guess and the count is the useful part, because the number shows how often you decide to spend, and that is a habit rather than a budget line.

Where do I get the list to count?

Your bank's website or app will let you export a period as CSV or a spreadsheet file. Do this for each current account and card, set the dates from the first to the last day of the month, and paste the results below each other in one sheet. Keep a column for the account so you can tell them apart later. Remove transfers between your own accounts and any lump payment that clears a credit card balance, since the purchases on the card already sit in the list.

How do I count payments per weekday?

Spending often has a rhythm that a monthly total hides. Put dates in column A and amounts in column C. In column F add =TEXT(A2,"ddd") and fill it down; this returns Mon, Tue and so on. In Google Sheets the same formula works, though weekday names follow your sheet's language setting. Then count each day with =COUNTIF($F$2:$F$300,"Fri").

Here is a made-up month of 66 payments.

WeekdayPayments
Monday9
Tuesday7
Wednesday8
Thursday6
Friday14
Saturday17
Sunday5

The days add up to 66. Friday and Saturday carry 31 of them, nearly half, so a change to weekend habits would move the count more than anything done on a weekday.

Which payments did I actually choose?

Some rows are not decisions at all. Rent, a phone contract and a streaming plan arrive on their own. Add a column G and type R for recurring or C for chosen. Then =COUNTIF($G$2:$G$300,"R") and =COUNTIF($G$2:$G$300,"C") split the month. Suppose 7 of the 66 rows are recurring. That leaves 59 moments when you decided to pay, and those 59 are where any change in habit has to come from.

Does fewer, bigger payments mean spending less?

Not by itself. Take a household that goes to the shop five times a week for about €16.80 each time. Over a week that is €84.00 in five rows. One planned weekly shop of €84.00 is a single row and the same money. The count falls from five to one while the total does not move. What changes is the number of chances to add an unplanned item, so a lower count can help, but check the total before you celebrate.

Is a high count always a problem?

No. A count is a description, not a grade. Someone who pays for everything by card, including a single coffee, will show far more rows than someone who withdraws cash once a week, with no difference in how much they spend. The count becomes useful when you compare it with your own earlier months. If it climbs from 66 to 90 while the total stays flat, the change is in how you pay or how often you shop, and that is a question you can answer by reading the new rows.

What should I do with the result?

  • Log the count and total each month, one row per month, so you can see drift.
  • Choose one weekday to treat differently for a month, and recount.
  • List the recurring rows and decide which still earn their place.
  • If your count is far above your guess, take a week to note each purchase as it happens and compare with the statement.

The aim is not a smaller number for its own sake. It is to know how often you spend, so that nothing about your own month surprises you.

SPENDIXAI JOURNAL

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

Explore your reports