When you import a card statement into an expense tracker, the main risk is counting money twice: once when you buy something and again when you pay the card bill. Pick CSV over PDF if you can, check how purchases and refunds are signed, mark the card payment as a transfer, and reconcile to the statement balance. The example below uses US dollars.
Which file should you use?
Check the statement download options on your own account and prefer CSV or Excel; they are cleaner than PDF. we are not describing any issuer's screens or file layout, so open the file and read the column headings yourself. Look for a date, a description and an amount, and see whether debits and credits are in one column or two.
How are purchases and refunds signed?
Some files show purchases as positive numbers and payments and refunds as negative; others do the reverse. If your tracker reads them the wrong way round, your spending appears as income. Test with one row you recognise: a purchase of $42.10 should land as an expense, and a refund of $15.00 should reduce spending, not add to it. If it is reversed, flip the sign column before importing.
A worked example: the double-count trap
Say a month on a card shows this:
| Date | Description | Amount | Type |
|---|---|---|---|
| 04/03 | Groceries | $84.20 | Purchase |
| 09/03 | Fuel | $46.50 | Purchase |
| 15/03 | Online order | $129.30 | Purchase |
| 18/03 | Refund of online order | -$129.30 | Refund |
| 25/03 | Payment, thank you | -$260.00 | Card payment |
Purchases total $84.20 + $46.50 + $129.30 = $260.00. The refund of $129.30 cancels the online order, so real spending is $84.20 + $46.50 = $130.70. The $260.00 payment is not spending; it moves money from your bank account to the card. If you also import your bank statement, the same $260.00 appears there as an outgoing payment. Count it as spending in both places and you have double-counted $260.00.
- Mark the card payment line as a transfer, or leave it out.
- Keep the refund linked to the same category as the original purchase.
- Import the bank account separately, with the card payment marked as a transfer there too.
- Check the end balance: the statement's new balance should equal the opening balance plus purchases minus refunds and payments.
Where does SpendixAI fit?
An honest note: SpendixAI is built around India and the rupee. It accepts bank and card statements as PDF, CSV or Excel, and you choose the account and base currency before importing, which cannot be changed once transactions exist. Whether it suits a dollar card is for you to check; a spreadsheet or a tool made for your country may be a safer start.
What if a statement shows fees or interest?
Interest and fees appear as their own rows. Give them a category of their own, such as Card charges, so you can see how much the card costs to hold. Find the exact figures on your statement and do not assume. If you see the same charge repeating and it is not clear why, ask the issuer through its official channel, and note the date and reply in your records so you can follow up.
Checklist before you save
- Dates are read in the right order, day first or month first.
- Purchases appear as expenses, and refunds reduce them.
- The card payment is marked as a transfer.
- Totals match the statement.
- The file came from the final statement, not a pending view.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

