Excel

Credit card statement PDF to Excel

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.

Files deleted after 1 hourNever stored or used for trainingBalance check on every file
Processed in memory, never stored
No statement handy? See the result on a fictional one first:

1. Download your statement

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.

2. Upload and verify

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.

3. Import into Excel

  1. Download the CSV from your results page. It's formatted for Excel.
  2. Open it in Excel. Dates and amounts come through as real dates and numbers, so you can sort, filter and pivot right away.
  3. Save as .xlsx if you want to keep formulas or formatting.

Why Excel?

Open the CSV in Excel to tag expenses, split business and personal charges, or hand your accountant a clean list of card spending.

How to convert a credit card statement PDF to Excel

  1. Download the statement PDF from your card issuer's website or app. Business cards and personal cards work the same way.
  2. Upload it above. Utilly reads every section of the statement (payments and credits, purchases, fees, interest) and checks Previous Balance − payments and credits + charges = New Balance. The first rows preview free.
  3. Download the CSV and open it in Excel (File → Open, or double-click). Dates and amounts come through as real dates and numbers. Use File → Save As → Excel Workbook if you want a .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.

Charges, payments and refunds: how each row is signed

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 statementIn ExcelExample from the sample statement
PurchaseNegative2026-09-02, DELTA AIR LINES 0062 ATLANTA GA, -418.60
Payment to the cardPositive2026-09-05, PAYMENT THANK YOU - WEB, 1500.00
Refund or returnPositive2026-09-14, OFFICE DEPOT RETURN AUSTIN TX, 42.18
Interest chargeNegative2026-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.

What you get in Excel, and the other downloads

DownloadWhat's in it
CSV for ExcelDate (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 CSVIntuit'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 CSVXero'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 CSVDate, Description, Amount with card purchases positive, the way Wave's CSV upload asks for card accounts. See statement PDF to Wave.
FreshBooks CSVDate (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.

Try it on a sample card statement

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.

Card issuers tested

IssuerWhat's different on its statement
American ExpressPayments, Credits and New Charges in separate sections; credits printed as −$ amounts
ChaseAccount Activity split into payments and other credits, purchases and interest
Capital OneA transaction date and a post date on every row; the transaction date is used
CitiPayments with only a post date, and a rewards box beside the transactions that's left out
DiscoverGroup 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.

Common problems with credit card statements in Excel

ProblemFix
Excel shows one long column, or dates look like textOpen 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 OnlineThat'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 enoughCard 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 statementThe 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 ExcelPaste the rows into the free credit card reconciliation template.
You have the card's QFX or OFX download, not a PDFUse 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.

Pricing

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.

FAQ

Questions

Can I convert a credit card statement PDF to Excel for free?

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).

How do you handle payments and refunds on a card statement?

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.

Why not just copy and paste from the PDF?

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.

Is my statement stored?

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.

Do scanned statements work?

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.

What if it doesn't balance?

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.

Do I get an .xlsx file?

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.

Which credit card statements work?

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.

Why are charges negative in Excel?

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.

Is there a Balance column?

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.

Why aren't the rows in date order?

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.

Related guides

More bookkeeping tools