Credit card statement PDF to Excel, CSV or QuickBooks file
A credit card statement is laid out differently from a bank statement, and that is where conversions go wrong. Here is what to watch for and how Statemento handles it.
Why credit card statements trip up converters
On a bank statement, money out is a minus and money in is a plus. On a credit card statement the balance is what you owe, so a charge raises it and a payment lowers it. A converter that copies the numbers as printed can flip every sign, and the totals stop making sense.
Statements also carry lines that are not purchases: payments, interest charges, fees, and sometimes interest lines of $0.00 that only clutter your books.
What Statemento does with a credit card statement
- Signs: charges come out as negative amounts and payments and credits as positive, the same as a bank export, so one spreadsheet can hold both.
- Interest and fees: they stay as their own rows, so you can see and categorize them.
- $0.00 lines: zero-dollar interest lines are left out.
- Balance check: the rows are checked against the opening and closing balances printed on the statement, and you see the result on screen before you download.
- Accounting files: QBO, QFX, OFX and QIF files are written as credit card accounts, with the closing balance shown as the amount owed, not as a bank balance.
What we have checked
We have run credit card statements from American Express and Bank of America through Statemento and checked every row, sign, date and balance against the PDF. The tool reads each page for its layout instead of using bank templates, so other issuers work the same way. See the banks and card issuers we have converted.
How to convert a credit card statement
- Download the statement as a PDF from your card issuer. It has to be a digital PDF where you can select the text, not a scan or a photo.
- Drop the PDF on Statemento. You can try one statement free without an account.
- Check the result line under the file name. It says whether the opening and closing balances reconcile, and it warns you if a row looks missing.
- Download the format you need: CSV or Excel for a spreadsheet, or QBO, QFX, OFX or QIF for accounting software. Which file do you need?
Limits to know
Statemento reads digital PDFs only. Scanned or photographed statements are not supported yet. Whether your accounting software accepts a given file depends on the software and its version, so check its import page.
Try one statement free, no account needed. Your PDF is read in memory and never stored.