Getting started

American Express India statement to CSV: a clean-up guide

Turn an American Express India card statement into a clean CSV: choose the file format, fix debit and credit signs, handle foreign charges and check totals.

Editorial illustration for American Express India statement to CSV: a clean-up guide

The cleanest route is to download the statement in the spreadsheet or CSV format if your card account offers one, and fall back to the PDF only if it does not. Then fix the columns so every purchase is a positive spend and every refund is clearly negative, and check that your total matches the statement total. Menu names differ and change, so check your own statement and card account for the options available.

Which file should you download?

In order of preference: a CSV or Excel file, then a text-based PDF, then a scanned image. A CSV already has rows and columns. A text-based PDF can usually be converted, though tables sometimes break at page ends. A scanned image needs reading by character recognition, which makes mistakes, so check every number.

If you plan to use an expense tracker that accepts PDF, CSV or Excel, such as SpendixAI, you may not need to convert at all. Convert only if you want to work in a spreadsheet first.

What should the finished columns look like?

Aim for four working columns: Date, Description, Amount and Type, plus a Notes column if you like. Card statements often show purchases and payments in one column, with credits marked differently from debits. Decide your rule once. A common choice is spend positive and refunds or card payments negative, or the reverse, as long as you are consistent.

DateDescriptionAmountType
04-03-2026Restaurant dinner₹3,200.00Spend
06-03-2026Online store refund-₹1,150.00Refund
10-03-2026Card bill payment received-₹25,000.00Payment
12-03-2026Foreign merchant charge₹8,400.00Spend

These rows are invented. Note that the bill payment is not spending; if you sum it with purchases, your total will be wrong by that entire amount.

How do you check the result?

  1. Sum the Spend rows.
  2. Subtract refunds.
  3. Compare with the statement's total of new charges, if it shows one.
  4. If the totals differ, hunt for a skipped row, a duplicated row or a charge split across two pages.

Using the sample, spend is ₹3,200 plus ₹8,400, which is ₹11,600. Less the ₹1,150 refund gives ₹10,450 net spend. The ₹25,000 payment belongs to a different question: did you pay the bill?

How should foreign-currency lines be handled?

Statement lines for overseas purchases may show a foreign amount alongside the rupee amount. Keep the rupee amount in the Amount column, since that is what you owe, and put the foreign figure in Notes. Then your totals reconcile with the statement. SpendixAI lets each expense carry its own currency with a base-currency total, if you want the original amount kept.

What goes wrong most often?

  • Dates read as month first when they are day first.
  • Thousands commas turning amounts into text.
  • Statement cycle dates mistaken for calendar months, so a charge appears in the wrong month.
  • Reversals counted as new purchases.

How do you handle statement cycles?

Card statements run on a billing cycle, not a calendar month, so one statement might cover the 15th of one month to the 14th of the next. If you want true monthly spending, either work by transaction date and filter to the calendar month, or stay with the cycle and label it that way. Mixing the two makes month-to-month comparisons wrong by a few days of spending.

Say a statement runs from 15 March to 14 April and totals ₹38,000, while a transaction-date filter for March alone gives ₹33,600. Neither is wrong. They answer different questions, and your sheet should say which one it holds.

Next step

Once the CSV balances, add a Category column and fill it for the largest ten rows first. They usually account for most of the total, and the rest can follow gradually.

SPENDIXAI JOURNAL

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

Explore your reports