Bank statements

How to import a American Express India statement into an expense tracker

Import an American Express India card statement into an expense tracker: download it, pick the card account, review rows and tie them to the total due.

Editorial illustration for How to import a American Express India statement into an expense tracker

To import an American Express India statement into an expense tracker, download the card statement you are entitled to as a PDF, CSV or Excel file, add a card account in the tracker, upload the file and read every row in the preview before saving. Then compare purchases, payments and the total due with the figures printed on the statement.

Where do I get the statement?

Sign in to your own card account on your own device and look for statements or billing history. Menu names move around, so search by those words. Many card issuers also e-mail a statement each cycle. Download the file itself rather than taking screenshots, because screenshots cannot be imported cleanly.

We do not know every layout American Express India uses, and we will not pretend to. Treat the first import as a trial and use the checks below.

Why does a card statement need different handling?

A bank account shows money coming in and going out. A card statement shows what you owe. Purchases push the amount owed up. Payments and refunds bring it down. Many files list payments as negative numbers or as credits, so make sure your tracker treats a payment as a payment and not as spending.

  • Purchases: spending, to be categorised.
  • Payments received: not spending, they settle what you owe.
  • Refunds and reversals: reduce the spending in the category they belong to.
  • Fees and interest charged by the issuer: spending in a bank-charges category.

What are the steps inside the tracker?

  1. Create or choose the card as its own account. SpendixAI asks you to pick the account (bank, card or wallet) before importing, and each transaction keeps it.
  2. Upload the statement. If you are catching up, upload several months as one batch.
  3. Review the preview. Check the first and last transaction dates and the largest purchase.
  4. Confirm and save, then open the import history for the status.

How does the statement cycle affect my months?

Card statements run from one billing date to the next, which may not be the 1st to the 31st. Look at the period printed on the statement. Your tracker will place each purchase on its transaction date, so a statement can include the end of one calendar month and the start of the next. That is normal. Do not be alarmed if the monthly total in a report differs from one statement's total. They cover different dates.

How do I check the import against the statement?

Take a hypothetical cycle. The previous balance is ₹8,000, you paid ₹8,000, new purchases total ₹23,450, and a refund of ₹1,200 was credited. The amount due is 8,000 - 8,000 + 23,450 - 1,200 = ₹22,250. Compare this with the total due on the statement, allowing for any fees or interest that sit on it. Then confirm the imported purchases add up to ₹23,450 and the refund appears once.

What about foreign-currency charges?

If you use the card abroad or on overseas sites, some lines may be in another currency, with a rupee amount alongside. Decide before importing which currency your tracker uses as its base. Each expense can carry its own currency, but trackers usually fix the base currency once transactions exist, so choose it carefully.

  • Check that the rupee amount on your statement matches the converted amount in the tracker, within a small difference for rounding.
  • Look for a separate line for any foreign-use charge, and categorise it as bank charges.
  • Use the Foreign-currency spend report to see these lines together.

What should I do afterwards?

  • Set categories for the merchants you use most.
  • Add the card payment from your bank account as a transfer so it is not counted twice.
  • Repeat at the end of every billing cycle.
SPENDIXAI JOURNAL

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

Explore your reports