To convert a credit card statement PDF to Excel, upload the PDF here, check that it ties to the New Balance, then download a CSV that opens in Excel with one row per charge, payment, refund, fee and interest charge: date, description and one signed amount. Free preview, no sign-up.
Grab the PDF statement from your card issuer's website or app (usually under Statements). Downloaded statements are text-based and convert exactly; scanned PDFs (up to 10 pages) are read with OCR.
Utilly reads every transaction, then checks that opening balance + transactions = closing balance. You'll see Balanced ✓ or exactly how far off it is, before you pay anything.
Open the CSV in Excel to tag expenses, split business and personal charges, or hand your accountant a clean list of card spending.
.xlsx. The same results page also has a QuickBooks Online CSV, a Xero CSV, a Wave CSV and a FreshBooks CSV of the same rows. One credit covers all of them.A card statement prints most amounts without a sign, or puts payments in their own section with a minus. The spreadsheet gives every row one signed Amount, as money in or out of your pocket:
| On the statement | In Excel | Example from the sample statement |
|---|---|---|
| Purchase | Negative | 2026-09-02, DELTA AIR LINES 0062 ATLANTA GA, -418.60 |
| Payment to the card | Positive | 2026-09-05, PAYMENT THANK YOU - WEB, 1500.00 |
| Refund or return | Positive | 2026-09-14, OFFICE DEPOT RETURN AUSTIN TX, 42.18 |
| Interest charge | Negative | 2026-09-30, PURCHASE INTEREST CHARGE, -21.36 |
Add up the Amount column and you get Previous Balance minus New Balance. On the sample: 1,542.18 of payments and credits, −1,939.94 of charges and interest, a net −397.76, which is exactly 2,846.12 − 3,243.88. If a row were missing, the results page would show the difference before you pay.
| Download | What's in it |
|---|---|
| CSV for Excel | Date (YYYY-MM-DD), Description, Amount (charges negative), Balance (blank: card statements don't print a running balance). Rows are in statement order, so sort by Date for one timeline. Open in Excel, then File → Save As → Excel Workbook for a .xlsx. |
| QuickBooks Online CSV | Intuit's 3-column upload: Date (MM/DD/YYYY), Description, Amount, sorted by date, with characters that can block an upload removed. Upload it into the credit card account, not a bank account. Intuit warns card CSVs can import with amounts reversed, so check the first rows on the review screen. |
| Xero CSV | Xero's statement template headings (*Date, *Amount, Payee, Description, Reference), dates as YYYY/MM/DD, charges negative. Import it into a Credit Card bank account in Xero. |
| Wave CSV | Date, Description, Amount with card purchases positive, the way Wave's CSV upload asks for card accounts. See statement PDF to Wave. |
| FreshBooks CSV | Date (MM/DD/YYYY), Description and one signed Amount in date order, up to 500 rows per file. See statement PDF to FreshBooks. |
Need a file instead of a spreadsheet? The same results page has a credit-card .QBO Web Connect file, an .IIF for QuickBooks Desktop, a Quicken .QIF and an OFX.
Click Sample credit card statement under the upload box to run a fictional statement (Example Community Bank Business Cash Rewards card ending 7316, September 2026, 21 transactions) through the converter, with every download unlocked. You can also open the sample card statement PDF or download its clean CSV directly. For comparison, this sample issuer-style CSV shows what a card's own download often looks like: an account line above the table, Transaction Date and Post Date, a Type column. More test files and their known totals are on sample credit card statement PDF. Don't import sample files into your real books.
| Issuer | What's different on its statement |
|---|---|
| American Express | Payments, Credits and New Charges in separate sections; credits printed as −$ amounts |
| Chase | Account Activity split into payments and other credits, purchases and interest |
| Capital One | A transaction date and a post date on every row; the transaction date is used |
| Citi | Payments with only a post date, and a rewards box beside the transactions that's left out |
| Discover | Group labels (Merchandise, Restaurants, Gasoline…) beside the first row of each group |
Another issuer? Any text-based card statement PDF can be read; the balance check tells you whether every row was captured before you pay.
| Problem | Fix |
|---|---|
| Excel shows one long column, or dates look like text | Open the converted .csv with Data → From Text/CSV (delimiter comma) so Date and Amount come through as real dates and numbers. Our dates are year-first (YYYY-MM-DD). |
| Purchases show up as payments in QuickBooks Online | That's the reversed-amounts issue Intuit warns about for card CSVs. Make sure you uploaded into the credit card account, then check the file with the free QuickBooks Online CSV checker: choose Credit card and tick Flip signs if needed. |
| The issuer's CSV doesn't go back far enough | Card downloads usually cover a year or two while statements stay online longer, so older months start from the PDF. See catch-up bookkeeping from statements. |
| The totals don't match the statement | The results page shows how far off it is before you pay. For a CSV from somewhere else, the balance checker finds the likely cause. |
| You need to reconcile the card in Excel | Paste the rows into the free credit card reconciliation template. |
| You have the card's QFX or OFX download, not a PDF | Use the OFX / QFX to Excel converter, free up to 100 transactions. |
Just need a Clean CSV (scripts, Wave, Zoho, FreshBooks)? Use credit card statement PDF to CSV. Converting a checking or savings statement instead? Use bank statement PDF to Excel. Want more options (From PDF, copy-paste, issuer download)? See how to convert a credit card statement PDF to Excel.
Preview any statement free, and your first 3 full statements are free with your email. A $9 pack unlocks 5 full statements in every format, with no expiry and no subscription. Bookkeepers with many clients can go unlimited for $19/month. See pricing.
You can preview every statement free: we show the balance check and the first 5 transactions with no sign-up. Unlocking the full file costs one credit ($9 for 5 statements).
Charges, fees and interest come out as negative amounts (money out) and payments, refunds and statement credits as positive. We then check Previous Balance − payments/credits + charges = New Balance, so you know every row was captured.
Copying from a PDF usually scrambles columns, merges descriptions and drops minus signs. Utilly keeps each transaction on one row with a signed amount, and the balance check tells you nothing was missed.
No. The PDF is read in memory and never written to disk, and extracted results are deleted after 1 hour. We never use your data for AI training.
Yes, as a PDF of up to 10 pages. A scan has no text layer, so Utilly reads it with OCR (text recognition running on our server; the file isn't sent anywhere else) and then runs the same balance check, so a misread digit shows up as a difference instead of slipping into your books. A PDF downloaded from online banking is still the most reliable. Phone photos (JPG or PNG) need saving as a PDF first.
You'll see exactly how far off it is before paying. If a paid conversion is wrong and we can't fix it, email support@version1.io for a refund.
You get a CSV laid out for Excel: Date, Description, Amount (charges negative) and Balance (blank on card statements), one transaction per row. Excel opens it directly with real dates and numbers; use File → Save As → Excel Workbook to keep it as .xlsx.
Any text-based card statement PDF: the layout is read from the page, not from a fixed list. Statements from American Express, Chase, Capital One, Citi and Discover have been tested section by section (links above). Scanned statements are read with OCR, up to 10 pages.
The spreadsheet uses the money-out-is-negative convention most bookkeeping expects: purchases, fees and interest are negative, payments, refunds and statement credits are positive. The sum of all rows equals Previous Balance minus New Balance, which is how the balance check works.
The column is there so the file has the same layout as a bank statement spreadsheet, but it's blank on card statements: card statements don't print a running balance after each transaction, only the Previous and New Balance, which the results page checks for you.
They come out in the order the statement prints them, usually payments and credits first, then purchases, then interest. Sort by the Date column in Excel if you want one date-ordered list. The QuickBooks Online CSV on the same results page is already sorted by date.
Step-by-step guide →
Step-by-step guide →
Step-by-step guide →
Step-by-step guide →
Step-by-step guide →
Step-by-step guide →
Step-by-step guide →
Step-by-step guide →
Step-by-step guide →