You can analyse any credit card statement in five passes, whoever issued the card: tidy the rows, label each one, total by category, look for fees and repeats, and compare with last month. A Capital One statement or any other follows the same logic, but we will not describe any issuer's layout; check how your own statement is arranged, and use the steps below as a method.
Pass one: get the rows into a table
Download the statement as PDF, or CSV if offered. You want one row per transaction with a date, a description and an amount. Remove opening and closing balances from the list; they are not spending. If your statement is in a currency other than rupees, keep each amount in its own currency and note the rate if the issuer shows one.
Pass two: label each row
Give each row a category: Food, Fuel, Shopping, Bills, Travel, Subscriptions, Other. Start with the repeated merchants and then deal with the rest. Credits and refunds should be negative, not spending.
Pass three: total by category
Say your statement has seven rows. Groceries 3,200; Fuel 2,400; Streaming 649; Dinner 1,850; Refund minus 1,200; Groceries 2,100; Fuel 1,800. Food and groceries is 3,200 plus 1,850 plus 2,100, which is 7,150. Fuel is 2,400 plus 1,800, which is 4,200. Streaming is 649. The refund of 1,200 reduces the total. Net spend is 7,150 plus 4,200 plus 649 minus 1,200, which is 10,799.
| Category | Rows | Amount |
|---|---|---|
| Food and groceries | 3 | ₹7,150 |
| Fuel | 2 | ₹4,200 |
| Streaming | 1 | ₹649 |
| Refund | 1 | -₹1,200 |
| Net | 7 | ₹10,799 |
Pass four: look for fees and repeats
- Any interest or late-payment line: note the amount and find the explanation in your card terms
- Annual or joining fees
- Foreign transaction lines
- The same merchant charging twice in two days
- Small recurring debits you do not recognise
Pass five: compare with last month
Put this month's totals next to last month's. A jump in one category is the question to answer: one-off, seasonal, or a habit? If the jump is a festival month, note that, so next year's comparison is fair.
When a manual pass is too slow
If you have several cards, an app can do the labelling. SpendixAI accepts card statements as PDF, CSV or Excel, lets you pick the account first, and shows the rows for review before saving. Unusual layouts may need a manual check, so we would not promise that every statement parses perfectly.
What counts as a good result?
The goal of the analysis is not a perfect number but a decision. After the five passes, you should be able to say one sentence: my biggest category was groceries at ₹7,150, fuel was ₹4,200, and the one recurring charge I had forgotten was ₹649. Then you pick one action. If your analysis ends without a sentence like that, it was a report, not an analysis.
Do the exercise for three months in a row before drawing conclusions. One month can be distorted by a trip, a festival or a one-off purchase. Three months give you a pattern you can trust enough to set a budget for the category.
Common mistakes in a manual analysis
- Counting a payment you made to the card as spending, when it is a transfer between your accounts
- Forgetting that a refund appears as a credit and should lower the category total
- Reading a pending item twice, once pending and once settled
- Mixing two currencies in one column
- Treating a fee line as a purchase instead of a cost of holding the card
If the card payment line is in your list, remove it from spending, otherwise your total is overstated by the amount you paid. Say you paid ₹10,000 last month and left it in the list: your new month would show ₹10,000 of phantom spending.
What to do with the result
- Set one category target for next month
- Cancel one recurring charge you no longer use
- Keep the statement and your analysis together for the year
Useful ideas start with a clearer picture of your own spending.
Explore your reports

