CSV

Credit card statement PDF to CSV

To convert a credit card statement PDF to CSV, upload the PDF here, check that it ties to the New Balance, then download a CSV 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 CSV

  1. Download the CSV from your results page.
  2. Open it in Google Sheets, Numbers or Excel, or import it into any accounting tool that takes CSV.
  3. Columns: Date, Description, Amount (negative for money out) and Balance where available. Uploading to QuickBooks Online? Download the QuickBooks Online CSV instead: Intuit asks for 3 columns, so it leaves Balance out.

Why CSV?

A CSV with one signed Amount column (charges negative, payments positive) imports into almost anything: spreadsheets, Wave, Zoho Books, FreshBooks or a credit-card register.

How to convert a credit card statement PDF to CSV

  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. The clean CSV opens in Excel, Google Sheets or Numbers. The same results page 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 CSV gives every row one signed Amount, as money in or out of your pocket:

On the statementIn the CSVExample 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.

Which CSV to download for a card

DownloadWhat's in it
CSV / 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.
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 CSV? The same results page has a credit-card .QBO Web Connect file, an .IIF for QuickBooks Desktop, a Quicken .QIF and an OFX. Importing into QuickBooks Online or Desktop? See how to import credit card transactions into QuickBooks. Taking a card statement into Quicken? See how to import statements into Quicken. Into Monarch Money? The clean CSV's purchases are already negative, as Monarch wants: credit cards in Monarch. Into YNAB? Import it into the credit card account so purchases come in as outflows: credit cards in YNAB.

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 CSVs

ProblemFix
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 CSV into the free credit card reconciliation template.
You have the card's QFX or OFX download, not a PDFUse the OFX / QFX to CSV converter, free up to 100 transactions.

Want the Excel walkthrough instead? The credit card statement PDF to Excel converter downloads the same Clean CSV with Excel-first steps (open in Excel, Save As .xlsx). Converting a checking or savings statement instead? Use bank statement PDF to CSV. More options (From PDF, copy-paste, issuer download): 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 a CSV file 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.

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.

Do I need the Excel walkthrough?

No. This page downloads the same Clean CSV for spreadsheets, scripts or any importer that takes CSV. If you want Excel-first steps (open in Excel, Save As .xlsx), use the credit card statement PDF to Excel converter.

Why are charges negative in the CSV?

The CSV uses the money-out-is-negative convention most spreadsheets and accounting apps expect: 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 CSV, 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 or Google Sheets if you want one date-ordered list. The QuickBooks Online CSV is already sorted by date.

Can I get the CSV from my card issuer instead?

Often, for recent months. Chase's transaction download covers about the last two years and Discover.com shows 24 months, so older months, closed cards and year-end catch-up usually start from the PDF statements. A PDF converted here is also tied to the New Balance, which an issuer's CSV isn't.

Related guides

More bookkeeping tools