Convert credit card statements to CSV, Excel and QBO
Card issuers let you download recent activity, but older statements only come as PDFs. Drop one below and get every charge, payment, fee and interest charge back as a spreadsheet, signed the way your books expect.
Click to upload or drag & drop
your bank statement PDF
Select PDF filePDF only · up to 6 pages · 10 MB max
Need more than the demo? Start free with 10 pages
Why a card statement needs its own converter
A credit card statement runs the other way from a bank statement. A charge is the normal entry, and a payment or refund carries the minus sign or a CR. A converter that treats it like a checking account books every refund as a purchase and every payment as a charge.
Card statements also print two dates on each line, split business cards into one section per cardholder, and add interest and fees in a summary box instead of the transaction list.
CapyParse reads all of that. Charges come out as money out, payments and refunds as money in, and the result is checked against the statement: previous balance plus charges, minus payments and credits, has to equal the new balance.
What card issuers let you download
Every major issuer has an activity download for recent months. The full history is in the PDF statements.
| Issuer | Activity download | PDF statements |
|---|---|---|
| Chase | CSV, QFX and QBO for about the last 24 months | Up to 7 years |
| American Express | CSV, Excel, QFX and QBO for roughly 12 to 18 months | Up to 10 years on most cards |
| Capital One | CSV and QFX for a rolling 90 days | Up to 7 years |
| Citi | CSV, QFX and QBO. The window varies by card. | Up to 7 years |
| Discover | CSV for a date range you pick. QFX and QBO were discontinued. | Up to 7 years with paperless, about 24 months without |
Issuer download options as of August and September 2026. Each issuer page has the details.
Built for the way cards print statements
These are the details that break a generic converter, and how each one comes out.
Signs that import correctly
Charges export as negative amounts and payments and refunds as positive ones. That is the convention QuickBooks uses for credit card accounts.
Separate Charges and Credits columns
Some business cards print charges and credits in two unsigned columns. Each amount keeps the direction of the column it was printed in.
Both dates on every line
When a card prints a transaction date and a posting date, the export keeps both: Posted Date for your books and Transaction Date beside it.
Employee cards
On a business statement with several cardholders, each cardholder’s section comes out as its own account. Export them separately or combine them.
Interest and fees
Interest charges and fees become rows in the export, so the total you import matches the statement.
Foreign transactions
The original currency and exchange rate lines stay with the charge they belong to instead of turning into stray rows.
Getting a card statement into QuickBooks
- 1Download the statement PDFs from your card account. Upload one or a whole year at once.
- 2Check the rows next to the original pages. The statement shows whether it matches the printed new balance.
- 3Export QBO. The file is marked as a credit card account, so charges increase the balance you owe.
- 4In QuickBooks Online, upload it to the card account from Bank transactions. In QuickBooks Desktop, use File > Utilities > Import > Web Connect Files.
Other formats
- CSV with the QuickBooks preset gives the three columns QuickBooks Online asks for: Date, Description and Amount.
- Excel puts each account on its own sheet, ready for a pivot table by merchant or month.
- Xero, Sage and spreadsheets take the standard CSV with separate Debit and Credit columns if you prefer them.
Review everything before you export
Every extracted transaction appears next to the original statement page, with anything unusual flagged for a second look. Nothing goes into your books until you have seen it.
50,000+
Pages converted
1,000+
Banks & credit unions
5
Export formats
Uploads are encrypted in transit, documents stay in your account until you delete them, and your data is never sold. How we handle files
Questions
How do I convert a credit card statement PDF to CSV?
Drop the PDF into the converter on this page. Every transaction comes back as a row that you can download as CSV. A free account adds Excel and QBO export and batch uploads.
Why are charges negative in the export?
The export writes money out as negative and money in as positive. On a card, a charge is money out and a payment or refund is money in, which is also how QuickBooks expects a credit card file.
Can I download more than 90 days of card transactions?
Not from every issuer. Capital One’s download covers 90 days and Chase’s about 24 months. The PDF statements usually go back 7 years, and those are what this converter reads.
Does it handle business cards with employee cards?
Yes. Each cardholder’s section becomes its own account with its own rows. You can export them one by one or combine them into one file.
Which card issuers does it support?
Chase, American Express, Capital One, Citi, Discover, Bank of America, Wells Fargo, Synchrony store cards and many more. There are no templates to set up for a new issuer.
What happens to my files?
Uploads are encrypted in transit. Documents stay in your account until you delete them, and your data is never sold.
Keep going
Convert your card statements
Try a page right here with no signup. A free account gives you 10 pages, batch uploads and Excel and QBO export.
Start free