Treat each credit card as its own account inside one tracker, use the same category list for all of them, and look at a monthly total per card. That gives you one place to see where the money went and one number per card to check against its bill. Without it, spending is split across statements that name merchants differently and arrive on different dates.
Why does the confusion start?
Each card has its own billing cycle and statement date, so the same calendar month straddles two bills. A purchase made on the 28th could fall in this month's statement on one card and next month's on another. If you try to add statements in the order they arrive, your monthly totals will not match your actual spending by the calendar.
What setup keeps it clear?
- Create one account per card, named with the card and the last four digits, such as "Card A 4321".
- Use one shared category list so Food on Card A is the same as Food on Card B.
- Record each purchase by its transaction date, not the statement date.
- Record the bill payment as a transfer between your bank account and the card, not as spending.
- Reconcile each card against its statement once a month.
Step four is the one people skip. A card bill payment is not a new expense; it settles purchases you already recorded. If you count it as spending, every rupee is counted twice.
What does the monthly per-card view look like?
Say you hold three cards. These totals are invented.
| Category | Card A (₹) | Card B (₹) | Card C (₹) | All cards (₹) |
|---|---|---|---|---|
| Groceries | 6,200 | 0 | 1,800 | 8,000 |
| Fuel | 0 | 3,500 | 0 | 3,500 |
| Online shopping | 2,400 | 1,100 | 5,000 | 8,500 |
| Bills | 900 | 0 | 1,300 | 2,200 |
| Total | 9,500 | 4,600 | 8,100 | 22,200 |
Add the card totals: 9,500 + 4,600 + 8,100 = 22,200. If your spreadsheet has the card name in column D, the category in column C and the amount in column E, the Card A total for a category is =SUMIFS($E$2:$E$500, $D$2:$D$500, "Card A", $C$2:$C$500, "Groceries").
How do I match my records to a card statement?
At month end, filter your tracker to one card and the statement's date range. The total should equal the statement's total of purchases, minus refunds and credits. If it does not, look for missed entries, double entries or a charge that posted after the cut-off. Your card's statement date decides which bill a purchase falls into, so check it on each statement.
Can I import statements instead of typing?
You can upload a statement as PDF, CSV or Excel into SpendixAI after choosing the card as the account, review the rows before saving, and each transaction keeps its card. Statement layouts vary, so check the rows rather than assuming every one was read correctly. Possible duplicate imports are flagged, which helps if two statements overlap in dates.
What should I watch out for?
- Refunds: record them against the same card and category as the purchase.
- Annual fees and interest: give them their own category so they are visible.
- EMI conversions on a card: note the original purchase and the instalment separately.
- Add-on cards: tag the user so you can see who spent what.
A monthly routine
Reconcile one card at a time, starting with the one whose bill is due first. Mark each as done in a small checklist. Then glance at the all-cards view to see where the month went.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
