You can find your real number in about ten minutes. Download last month's statements from every current account and card you use, paste the rows into one sheet and count the lines where money went out. That count, set beside the total, shows whether your month is a handful of big decisions or a few hundred small taps.
What counts as one transaction?
Every line on a statement is one transaction: a contactless tap, a direct debit, a bank transfer to a friend, a standing order, even a refund coming back in. For a spending count you want money out only, and you want each pound counted once. That means two exclusions. Transfers between your own accounts are not spending, and neither is the payment you make to clear a credit card, because the card purchases it covers are already in the list.
Wait until pending items have settled before you copy anything. A tap on the last evening of the month can post two days into the next one, so use the posted date and be consistent.
How do I count them in a spreadsheet?
- Download the last full calendar month as CSV or a spreadsheet from each account and each card.
- Paste everything into one sheet with the columns Date, Description, Money out, Money in and Account, so Money out sits in column C.
- Add a column F called Skip and type Y beside own-account transfers and card repayments.
- Count the spending rows with =COUNTIFS($C$2:$C$400,">0",$F$2:$F$400,"<>Y").
- Total them with =SUMIFS($C$2:$C$400,$F$2:$F$400,"<>Y").
- Divide the total by the count to get the average payment.
Those formulas work the same way in Excel and Google Sheets. If your bank gives you a single signed amount column instead of separate money in and out columns, count the negative numbers by changing ">0" to "<0" in the first formula.
What does a real month look like?
Here is a made-up month with 71 spending rows after the exclusions. Group them by size with =COUNTIFS($C$2:$C$400,">=5",$C$2:$C$400,"<20",$F$2:$F$400,"<>Y") and its siblings.
| Payment size | Count | Total |
|---|---|---|
| Under £5 | 23 | £71.50 |
| £5 to £19.99 | 31 | £402.00 |
| £20 to £99.99 | 14 | £688.00 |
| £100 and over | 3 | £1,360.00 |
| All spending | 71 | £2,521.50 |
The average is £2,521.50 divided by 71, which is £35.51. Yet 54 of the 71 payments are under £20, and the three largest rows make up just over half the money. Both facts are true at once, which is why the count and the total need to be read together.
Why is the average misleading?
An average is dragged upward by a few large payments. The middle payment, the median, describes a typical tap better. In Excel 365 or 2021 use =MEDIAN(FILTER($C$2:$C$400,($C$2:$C$400>0)*($F$2:$F$400<>"Y"))). In Google Sheets the same idea is =MEDIAN(FILTER($C$2:$C$400,$C$2:$C$400>0,$F$2:$F$400<>"Y")). If you use an older Excel, sort the money out column and read the value halfway down.
What can I do with the number?
- Compare it month to month. A jump from 71 to 96 rows with a flat total usually means more small purchases, not bigger ones.
- Pick one habit with many rows, such as daily takeaway coffee, and see what it adds up to over the month.
- Note how many rows are recurring, like subscriptions and direct debits. Those are the ones you can cancel in one stroke.
- Check the three largest rows. If they explain half the total, the other 68 are not where the money is going.
What if my bank splits one purchase into two rows?
It happens with hotel stays, fuel and online orders: an authorisation appears first, then the final amount replaces it, or a delivery is charged as two parcels. Sort by description and look at rows with the same merchant and date. If one is a hold that later disappeared, delete it from the count. If both are real, keep both, because the count is meant to describe what the statement shows, not what you remember doing.
A five-minute monthly routine
- On the first weekend of the month, download last month's statements.
- Paste, mark the skips, run the two formulas.
- Write the count, total and average in a small log with one row per month.
- Circle one thing to watch next month.
After three months you will know your own normal range, and a strange month will stand out immediately.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

