To analyse a credit card statement, copy every line into a sheet, give each one a category, separate purchases from payments, refunds and interest, and check that the lines add up to the new balance printed on the statement. That works for any UK card statement, including an HSBC one, and it takes about half an hour for a month.
What do I need before I start?
- The statement as a PDF, or a CSV or Excel download if your bank offers it
- A blank sheet with columns for date, merchant, category and amount
- The statement's printed totals: previous balance, payments, new balance
- About ten minutes to read the layout of your own statement before you type anything
We will not describe how any bank lays out its statements, because that changes. Read yours and note where purchases end and other lines begin.
How do I sort the lines into types?
Add a column called Type with these values: Purchase, Payment, Refund, Interest or Fee. Everything that is not a purchase should be easy to filter out, because purchases are what you categorise and budget.
- Mark card payments you made as Payment.
- Mark money returned by a shop as Refund, with a negative amount.
- Mark any interest or fee line as such, whatever the statement calls it.
- Everything else is a Purchase; give it a category.
Worked example in pounds
Say the previous balance was £860.00 and you paid it in full. The new purchases below are invented.
| Category | Amount (£) |
|---|---|
| Groceries | 312.40 |
| Transport | 96.00 |
| Subscriptions | 41.97 |
| Dining | 187.25 |
| Shopping | 248.00 |
| Purchases total | 885.62 |
Now the rest of the statement: a refund of £35.00 and an interest line of £12.30. The new balance should be £885.62 - £35.00 + £12.30 = £862.92. If your sheet says £862.92 and the statement agrees, nothing is missing. If the statement says £1,000.00 you are short by £137.08, so look for a missed page or a purchase you skipped.
Which spreadsheet formulas do the heavy lifting?
- Total for one category in Excel or Google Sheets: =SUMIFS($D$2:$D$300, $C$2:$C$300, "Dining", $E$2:$E$300, "Purchase") where D is the amount, C the category and E the type
- Count of purchases: =COUNTIFS($C$2:$C$300, "Dining", $E$2:$E$300, "Purchase")
- Largest single purchase in a category: =MAXIFS($D$2:$D$300, $C$2:$C$300, "Shopping") in Excel 2019 or later and in Google Sheets
What should I look for once it is categorised?
- Interest or fee lines, which you can only judge against your own card agreement
- Subscriptions that renew every month, and any you no longer use
- The same merchant and amount on two nearby dates, which may be a duplicate to query
- Category totals that moved a lot since last month
How do I handle foreign-currency lines?
If a purchase was made abroad, your statement may show it in pounds only, or with the original amount beside it. Add a column for the original currency and amount when it is shown, and keep the pound figure as your main amount. Then check that the pound figure is what was actually charged. You can compare months by pound totals without worrying about the exchange rate that day, but keep the original so a dispute with a merchant has the evidence it needs.
What comes after one month?
Do three months before drawing conclusions. A single month with a holiday booking tells you little. Put the months side by side and keep the same categories each time.
SpendixAI is built around India and INR, so it is not aimed at UK statements. If you are in India and want the same analysis for a rupee card, upload the statement, review the rows and use the category reports there. For a UK card, the sheet method above does the job.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

