How to convert a credit card statement to CSV
Credit card statements have their own quirks: payments, refunds, interest and a billing cycle. Here's how to turn one into a clean CSV you can trust.
Key takeaways
- On a credit card statement, purchases increase the balance and payments and refunds reduce it — the signs are the reverse of a checking account.
- A good CSV keeps one row per transaction with a date, description, signed amount and the original text.
- Card payments from checking should be marked as transfers so they don't count as spending.
A credit card statement looks like a bank statement, but it reads differently. Getting those differences right is what separates a CSV you can analyse from one that quietly gives you the wrong totals.
What's different about card statements
- Signs are reversed: purchases increase what you owe, payments and refunds reduce it.
- There are separate sections for payments, purchases, fees and interest — and sometimes one per cardholder.
- The period follows a billing cycle, such as the 14th to the 13th, not a calendar month.
- Foreign purchases may show the original currency and an exchange rate on extra lines.
What a clean CSV should contain
Aim for one row per transaction with a consistent set of columns. Merging the statement's sections into a single list makes it sortable, but keep enough information to tell a purchase from a payment.
- Date — the transaction date, in one consistent format such as YYYY-MM-DD.
- Description — the merchant text as printed.
- Amount — one signed column, with purchases negative and payments and refunds positive.
- Type — expense, income (refunds, cashback) or transfer (card payments).
Getting the data out
Many card issuers let you download recent activity as CSV from their website. For older statements, closed cards or issuers that only provide PDFs, you'll need to convert the PDF — the same options apply as for bank statements to Excel. PaperSpend reads card statements from any issuer, normalises the signs and exports CSV or Excel.
Reconcile before you trust it
Check the CSV against the statement: previous balance, plus purchases, fees and interest, minus payments and credits, should equal the new balance. If your issuer splits transactions by cardholder, make sure every section made it in.
Don't count the payment twice
If you also track your checking account, the card payment will appear on both. Mark it as a transfer on both sides or your monthly spending will be inflated — here's the full explanation.
Frequently asked questions
Can I download my credit card transactions as CSV?
Most issuers offer CSV downloads for recent activity in online banking. Older statements and closed accounts often only exist as PDFs, which need converting.
Should credit card purchases be positive or negative in a CSV?
Pick one convention and stick to it. Treating purchases as negative and payments and refunds as positive matches how most bank exports and accounting tools read money leaving you.
Is a refund on a credit card income?
A refund is money coming back to you, so it reduces your spending. Many people record it as a credit against the original category rather than as income.
