Budgeting

Your tracker total differs from the card statement total: why

Expense tracker total not matching your credit card statement? Check cycle dates, payments, refunds, fees, EMIs and foreign charges, with a worked ₹2,300 gap.

Editorial illustration for Your tracker total differs from the card statement total: why

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:

LineAmountWhy
Tracker total, calendar month₹46,000Starting point
Less: charges on the 28th to 30th-₹3,400Fall in next cycle's statement
Add: charges on the 28th to 31st of last month+₹4,100Fall in this cycle's statement
Add: annual fee and finance charges+₹590On the statement only
Add: foreign purchase markup and rate difference+₹510Posted higher than the amount you recorded
Add: EMI processing fee+₹500On the statement only
Statement new charges₹48,300Matches

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?

  1. Sort both lists by amount and tick off pairs one by one.
  2. Check dates: a transaction at midnight or at the end of the cycle can post a day later than you recorded.
  3. Look for the same merchant on adjacent days with the same amount.
  4. Check currency: a foreign charge may show on the statement in rupees at a rate you did not record.
  5. 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.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports