To analyse a credit card statement, split every line into three buckets: purchases, payments or credits, and anything the card issuer added, such as interest or fees. Total each bucket, then group the purchases by category and by merchant. You can do this with a pen, a spreadsheet or a tool. Read your own statement and the issuer's own terms for what each fee means; this article teaches the method, not any one bank's rules.
What are the parts of a card statement?
- A summary: previous balance, new charges, payments and credits, new balance.
- A list of transactions with a posting date, a description and an amount.
- A section for fees and interest charged, if any.
- A due date and a minimum payment figure.
- Sometimes a section showing foreign-currency transactions with the original amount.
Layouts differ from one issuer to another, so do not assume the order. Find the summary first: it is the figure you will check your own total against.
How do I check my own total?
The test is simple. Previous balance, plus new purchases, plus fees and interest, minus payments and credits, should equal the new balance. Say the previous balance is 1,200, you made purchases of 3,450, a fee of 25 was added and you paid 1,200. Then 1,200 plus 3,450 plus 25 minus 1,200 is 3,475, which should be the new balance. If your sheet shows another number, a line has been missed or counted twice.
| Bucket | Lines | Total (statement currency) |
|---|---|---|
| Purchases | 14 | 3,450 |
| Fees and interest | 1 | 25 |
| Payments and credits | 1 | 1,200 |
| Previous balance | - | 1,200 |
| New balance | - | 3,475 |
How do I group the purchases?
- Copy the date, description and amount of each purchase into a sheet.
- Add a category column and fill it in using the description. Start with broad groups such as food, travel, shopping, subscriptions and utilities.
- Add a column for the merchant, cleaned up: remove store numbers and city names.
- Sort by merchant to see repeats, then by category to see totals.
- Use a pivot table or SUMIF to total each category. For example =SUMIF($C$2:$C$200,"Food",$D$2:$D$200) adds all amounts in column D where column C says Food.
What patterns are worth looking for?
- Same merchant, same amount, every month: a subscription. Decide whether you still use it.
- Same amount, same merchant, two days in a row: possible duplicate. Check with the seller.
- A charge you do not recognise: look at the date, check your email for a receipt, then ask the issuer through its official channel.
- Interest or fees: note the amount and find the explanation in your agreement.
What if the statement is a PDF?
A PDF from the issuer is usually text you can select, which is easier to work with than a scan. Select the table and paste it into a sheet, then clean up the columns. If it was a photo or a scan, text selection will not work and you will need to key it in or use a tool that reads images. Check the result against the statement total either way.
Where can a tool help?
If you do this every month, a tool saves effort. SpendixAI accepts card statements as PDF, CSV or Excel, and you review the rows before saving. Each expense can be in its own currency, with totals in the base currency using the rate saved with the transaction, which suits a card that bills in another currency. Categorisation starts with your own rules, then your history, and uses AI only if you switch it on. Not every issuer layout will read perfectly, so review what it shows.
Monthly routine
- Download the statement.
- Match the summary to your own totals.
- Categorise and sort.
- Note anything to dispute.
- Save the statement and your sheet together.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

