Credit card statement to Excel
Take the purchases, refunds and payments from your card's PDF statement to a spreadsheet, with the signs the right way round.
Check the table. If a column is wrong, change its type in the header: the spreadsheet is made from what you see.
Your statement never leaves your device
How to do it
- Download the card statement as a PDF from online banking or the card issuer’s website.
- Choose the file here. A credit card statement is recognised and purchases are read as money out.
- Check the Amounts setting above the table. If your card prints purchases with a minus sign, choose "bank account".
- Click "Download Excel" or "Download CSV".
Tips
- Purchases and fees are negative, payments and refunds positive, so the sum of the Amount column is what you paid back minus what you spent.
- In Excel, filter the Description column to see everything spent at one shop or on one subscription.
- The balance check compares the previous balance, the transactions and the new balance. If it fails, the Amounts setting is usually the wrong way round.
Questions
Why are purchases negative?
Because they are money going out. Card statements usually print purchases as positive, since they increase what you owe. Here a card uses the same rule as a bank account, so you can put both in one sheet.
How does it know it is a credit card statement?
It looks for words such as Minimum payment, Payment due or Credit limit, and for a single amount column where most amounts are positive. If it gets it wrong, change Amounts above the table.
Is my statement uploaded to a server?
No. Your browser reads the PDF and builds the file on your device. The statement is not sent anywhere: you can go offline after this page has loaded and it keeps working.
Does it work with scanned statements?
Not yet. Only digital statements downloaded from online banking work, because they have the text inside. A scan or a photo is just a picture and would need text recognition (OCR), which we do not offer for now.