Credit card statement to Excel converter
Turn a PDF credit card statement into a spreadsheet of charges, payments and refunds, checked against the previous and new balance printed on the statement.
Converted in this browser. The PDF is never uploaded. Check it yourself
- Stays on your device. The PDF is read in your browser and never uploaded.
- Checked against the balance. Rows that don't add up to the printed balance turn red.
- Free for 5 pages a day. Excel and CSV, no account.
Download
QBO, OFX and Xero settings
QuickBooks Desktop matches the bank ID against its list of banks; if it refuses the file, enter your bank's ID. Credit card statements are exported as credit card accounts automatically. Xero reads CSV dates in your organisation's regional order, so pick the order your Xero organisation uses.
How it works
Drop the statement
Any card issuer's PDF statement with text in it.
Check the total
Previous balance plus charges minus payments and credits should equal the new balance.
Download
Excel or CSV for free; QBO and OFX as a credit card account with Pro, coming soon.
How card statements are read
Card statements print purchases as positive numbers and payments and refunds as negative ones (or with CR after them), because they count what you owe. The converter flips that into the accounting convention, where a purchase is money out (negative) and a payment or refund is money in (positive), so the file imports into bookkeeping software the right way round.
Many cards print two dates per line, the transaction date and the posting date. The first one is used. When a statement runs from December into January, dates without a year get the right year from the statement's closing date.
There's usually no running balance on a card statement, so the check compares previous balance, all transactions and new balance. If the total is off, a line is probably missing or misread; compare the table with the PDF.
Check that nothing is uploaded
You don't have to take our word for it. Two ways to see for yourself:
- Go offline. Once this page has loaded, turn off Wi-Fi or switch on airplane mode, then drop a statement in. It still converts, because the converter runs in your browser and the page keeps a copy of itself for offline use.
- Watch the network. Open your browser's developer tools (F12, or Cmd+Option+I on a Mac), choose the Network tab, then convert a file. You'll see no request carrying your PDF.
The one exception is AI repair, which you have to switch on yourself for a statement our parser couldn't read cleanly. It sends the text we extracted from the PDF (not the file) to our server, and only after you tick a box agreeing to it. Details are on the privacy page.
Free now, Pro coming soon
Everything in the Free column works today. Pro isn't on sale yet; this is what it will include.
| Free | Pro | |
|---|---|---|
| Pages converted in your browser | 5 a day | Unlimited |
| Balance check and editing | Yes | Yes |
| Excel and CSV | Yes | Yes |
| QBO, OFX, QuickBooks CSV, Xero CSV | No | Yes |
| Merge several statements into one file | No | Yes |
| AI repair (opt-in) | 2 pages a day | 500 pages a month |
| Account needed | No | A license key, sent by email |
Questions
Why are my purchases negative?
In accounting software, a card purchase is money going out, so it's negative. The statement shows it as positive because it counts what you owe. Payments to the card are positive here.
Can I import a credit card statement into QuickBooks?
Yes. The QBO download (part of Pro, coming soon) is written as a credit card account. Until then, the free CSV can be mapped in QuickBooks Online's bank upload.
Are interest and fees included?
Yes, when they're listed as lines with a date and amount, which they usually are.
Is my statement uploaded?
No. The PDF is opened and read by your browser, on your device. The only time anything leaves your device is AI repair, which you switch on yourself; it sends the extracted text, not the file, and we don't store it.
Does it work with scanned statements?
Not yet. The converter reads the text inside a PDF. A scan or a photo of a statement is an image with no text in it, so nothing comes out. Most statements downloaded from online banking are text-based.