To see credit card spending by category, take one statement cycle, remove the lines that are not spending (your own bill payment, refunds you will net off), give every remaining line a category, and total each category against the full amount. The result is a short list you can read in a minute: where the card money actually went. Here is the routine, with a made-up month to show the arithmetic.
What should I do with the statement first?
Start with one complete cycle, not a calendar month, so the total matches the figure the bank shows as spends. Then clean it.
- Pick the cycle and download the statement as PDF, CSV or Excel from your own card channel.
- Note the total of purchases printed on the statement. You will tie your category total back to this number.
- Mark the payment you made towards the card as a transfer. It shows up as a credit, but it is you settling the bill, not income and not a negative expense.
- Look for fees, interest and GST on charges. Keep them, but give them their own category so they do not hide inside shopping.
- Check for refunds. A refund of a returned order belongs in the category of the original purchase, so that the net spend there is right.
If you use SpendixAI, you choose the card as the account before importing, upload the statement, and review the rows before anything is saved. Each transaction then keeps the card it came from, so card spending stays separate from your salary account.
How do I label each line?
Labelling is where most of the time goes, so make it cheaper by grouping lines the same way every month. A short list of categories is enough: groceries, fuel, dining, online shopping, subscriptions, travel, and other. When the same merchant appears again next month, it should get the same label without a second thought. SpendixAI categorises in stages: your own rules first, then your history and similar merchants, and only if AI is switched on, a model for what is left, working from the merchant name and an amount band rather than your name or account numbers. You can turn AI off and have unmatched lines held for review instead. Either way, a correction you make becomes history for next time.
What does a worked example look like?
Say one cycle's purchases come to ₹35,000 across seven categories. These numbers are invented for illustration.
| Category | Spend | Share of total |
|---|---|---|
| Groceries | ₹9,200 | 26.3% |
| Online shopping | ₹7,800 | 22.3% |
| Dining | ₹6,300 | 18.0% |
| Fuel | ₹4,500 | 12.9% |
| Travel | ₹3,600 | 10.3% |
| Other | ₹2,500 | 7.1% |
| Subscriptions | ₹1,100 | 3.1% |
| Total | ₹35,000 | 100.0% |
Each share is the category divided by 35,000; for instance 9,200 divided by 35,000 is 0.263, or 26.3%. Add the rows and you get back to ₹35,000. If your category total is off from the statement by even a small amount, a line is missing or a refund has been counted twice.
How do I read the category chart?
A bar or doughnut chart is just this table drawn out, so read it the same way. In the example, groceries and online shopping together are ₹17,000, which is 48.6% of the card, so a change there moves the whole month. Fuel at ₹4,500 is fairly steady for most people, so a jump deserves a look at the dates. Dining at ₹6,300 and subscriptions at ₹1,100 are the easiest places to notice drift. Compare the same category across months before drawing conclusions, since one festival month or a single big purchase can distort a single cycle.
What should I do when a line does not fit?
- A wallet top-up or gift card is not the end spend; keep it in its own category or note what it was used for
- An EMI conversion on the card should be one clear category so principal and charges are not mixed with shopping
- Foreign-currency purchases can stay in their own currency, with totals shown in your base currency using the rate saved with each transaction, if you use multi-currency
- Split purchases, such as a supermarket bill that includes both groceries and household items, are fine to leave in the bigger category unless the detail matters to you
A monthly routine that takes ten minutes
- Import the new statement when it is generated
- Review unlabelled rows and correct them
- Tie the total back to the statement
- Open the category report and note the top two categories
- Write one line on anything surprising, such as a one-off trip
Do this on the same day each cycle and the chart becomes comparable month to month. If GST appears in your reports, treat it as an estimate and confirm it against invoices with your CA.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
