Your tracker total and your card statement total will rarely match unless you compare the same dates and the same kinds of line. The usual causes are different period dates, payments and refunds being counted differently, fees the tracker never saw, EMI conversions, and foreign charges booked at a different amount. Go through them in that order and the gap normally disappears.
Start by comparing like with like
A card statement covers a billing cycle, say the 28th of one month to the 27th of the next. A tracker report usually covers a calendar month. Those periods overlap by most of the days but not all, so two totals can differ by thousands without any error. Before anything else, set your tracker report to the exact statement dates.
What else can open a gap?
- Payments to the card: the money you paid towards last month's bill appears on the statement as a credit. It is not spending, and should not be in your spend total.
- Refunds: a returned item reduces the statement, but if the tracker missed the refund row it will overstate spending.
- Fees and finance charges: annual fees, late fees, interest, and GST on those may appear only on the statement.
- EMI conversions: a big purchase turned into an EMI shows as a single big charge, then monthly instalments with processing fees, and the tracker may hold the purchase in a different month.
- Foreign charges: a purchase in another currency may be recorded at one rate by you and posted at another, with a markup line, by the issuer.
- Duplicates: the same statement imported twice, or the same payment entered by hand and imported.
A worked reconciliation
Say the statement shows ₹48,300 of new charges for the cycle and your tracker, for the calendar month, shows ₹46,000. The gap is 48,300 - 46,000 = ₹2,300. Build the bridge from the tracker to the statement:
| Line | Amount | Why |
|---|---|---|
| Tracker total, calendar month | ₹46,000 | Starting point |
| Less: charges on the 28th to 30th | -₹3,400 | Fall in next cycle's statement |
| Add: charges on the 28th to 31st of last month | +₹4,100 | Fall in this cycle's statement |
| Add: annual fee and finance charges | +₹590 | On the statement only |
| Add: foreign purchase markup and rate difference | +₹510 | Posted higher than the amount you recorded |
| Add: EMI processing fee | +₹500 | On the statement only |
| Statement new charges | ₹48,300 | Matches |
Check the arithmetic: 46,000 - 3,400 + 4,100 + 590 + 510 + 500 = ₹48,300. The cycle difference alone nets to +₹700; the rest is fees and conversions. All figures here are invented to show the method.
Do the payments to the card cause double counting?
Yes, if you import both the bank account and the card. Paying the card from your bank shows up as a debit on the bank statement and a credit on the card statement. If both are counted as spending, the same money is counted twice: once when you swiped the card and once when you paid the bill. Keep the bill payment out of your spend total, and decide whether to treat it as a transfer.
What if the gap is still unexplained?
- Sort both lists by amount and tick off pairs one by one.
- Check dates: a transaction at midnight or at the end of the cycle can post a day later than you recorded.
- Look for the same merchant on adjacent days with the same amount.
- Check currency: a foreign charge may show on the statement in rupees at a rate you did not record.
- Ask your card issuer about any line you cannot match, using the number on your card.
In an app
If you use SpendixAI, pick the card as the account when you import its statement, so those rows stay with the card and do not mix with bank payments, and review the rows before saving. Possible duplicate imports are flagged, and the Possible duplicate charges report lists the same amount to the same merchant within two days.
A tidy-up checklist
- Set both reports to the statement dates.
- Exclude card payments from spending.
- Add fees and charges by hand if they are missing.
- Settle the EMI treatment once and keep it consistent.
- Keep a line in your notes for any gap you cannot explain, and revisit it next month.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


