Getting started

Combine Spending From Several Cards and Accounts: A UK Monthly Ritual

Pick one day each month, download every statement, and merge them into one sheet. A worked pound example shows columns, transfers and a final check.

Editorial illustration for Combine Spending From Several Cards and Accounts: A UK Monthly Ritual

A single view of spending comes from a ritual, not a clever tool: choose one day a month, download every statement, and merge them into one list with consistent columns. Do it on the same day each time and it takes about half an hour. Skip a month and you will feel the gap.

When should the ritual be?

Choose a day after most statements have closed, such as the 5th. By then your card cycles have rolled and your current account is up to date. Put it in your calendar as a recurring entry, like a bill.

Which columns do I need?

Keep it to five: Date, Description, Amount, Account, Category. Use the same order for every account so you can paste statements in one beneath the other. Amounts leaving an account are positive spending; money coming in can be negative or sit in a separate column, but pick one way and stay with it.

What does the sheet look like?

DateDescriptionAmountAccountCategory
02 NovSupermarket£54.20Card AGroceries
03 NovRail ticket£23.80CurrentTransport
07 NovStreaming£12.99Card BSubscriptions
15 NovCard A payment£400.00CurrentTransfer

The last row is a repayment of a card, so it is a transfer and stays out of spending. Without that label, spending would be inflated by £400.

How do I check I have not missed an account?

Compare totals against each statement's own figures. Say the Card A statement shows purchases of £812.60 for the cycle. In your sheet, filter Account to Card A and total the purchases: =SUMIFS($C$2:$C$500, $D$2:$D$500, "Card A", $E$2:$E$500, "<>Transfer"). It should say 812.60 if the amounts are stored as numbers. If it does not, a line is missing or duplicated.

What if two accounts show the same payment?

This happens when you repay a friend from a card and the friend's repayment lands in your current account. Mark both sides sensibly, and look for lines that match in amount and date across accounts before you total anything.

When does a spreadsheet stop being enough?

When you have hundreds of lines, several accounts and a wish for reports. SpendixAI keeps bank, credit card, cash, wallet and UPI accounts in one workspace, but it is built around India and INR, so it is not a promise for UK users. Use that as a checklist item: can the tool hold many account types together?

How do I handle refunds and reversals?

A refund of £29.99 for returned shoes appears as money in on the card. Record it against the same category as the purchase, so the net spending for Clothing is correct. If you treat it as income, the purchase stays in your totals and the refund inflates what you earned.

Look for refunds whenever a total looks too high. They are easy to overlook because they are small and unannounced. Searching your list for the same amount as an earlier purchase finds most of them.

How many accounts is too many?

If merging takes more than an hour, ask whether every account earns its place. A card you use twice a year might be better closed, or just reviewed quarterly rather than monthly. Fewer places for money to hide makes the ritual lighter, and the combined view more accurate.

The end-of-ritual list

  1. Every account has been downloaded.
  2. Card payments are marked as transfers.
  3. Totals agree with each statement.
  4. Categories look sensible.
  5. The sheet is saved with the month's name.

This article covers habits, not bank charges or interest; those are on your statements.

SPENDIXAI JOURNAL

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

Explore your reports