Guides

How to Convert a Credit Card Statement to CSV (From a PDF)

A credit card statement is not a bank statement with a different logo. A bank statement lists money moving in and out of one account; a card statement mixes purchases, payments, refunds, interest, fees and foreign-currency charges, and the same number means something different depending on which column it sits in. Convert it the naive way — every row into one amount column — and your spreadsheet will tell you that you spent your payment and earned your purchases. This guide shows how to convert a credit card statement to CSV from a PDF, using a bank statement converter, so the file you get is one you can actually use: purchases as spending, payments as payments, and a balance check that proves the rows add up before the file goes anywhere near your books.

Why a credit card statement is not a bank statement

A bank statement follows one simple equation: opening balance, plus money in, minus money out, equals the closing balance. A card statement follows a different one. The balance is what you owe, not what you own: purchases, interest and fees increase it, while payments and credits reduce it. Previous balance, plus new charges, plus interest and fees, minus payments and credits, equals the new balance. Check a card file with the bank equation and it will never balance — and the failure tells you nothing, because you tested the wrong arithmetic.

The layout is different too. A bank statement is mostly one long list of transactions. A card statement groups its lines into sections — purchases, payments and credits, interest charged, fees — often across several pages, with summary boxes that repeat the same numbers in a different place. A converter that reads the pages top to bottom will pick up those summary rows as transactions unless they are recognised and left out.

  • Summary boxes repeat totals that also appear as individual lines — count them once, or not at all.
  • Foreign-currency purchases print on two lines: the amount in the original currency, then the converted amount. Only one belongs in your CSV.
  • Pending charges appear on some statements but are not final; only posted transactions belong in the file.
  • Minimum payment due and statement balance are amounts you owe, not transactions — neither is a row.

What a good credit card statement to CSV file looks like

Before converting anything, decide what the finished file should look like. A good card CSV has one row per posted transaction, a single signed amount column, and a type column that says what each row is. The type column is what makes the file usable: it lets you filter purchases away from payments in one click, instead of guessing from the description. Keep the running balance out of the file — it is a check, not a transaction.

DateDescriptionAmountType
2026-10-03AMAZON MKTPLACE SEATTLE WA-42.18Purchase
2026-10-05ONLINE PAYMENT RECEIVED250.00Payment
2026-10-09SHELL LONDON GB 12.40 GBP-15.82Purchase
2026-10-12INTEREST CHARGE ON PURCHASES-18.44Interest
2026-10-15RETURN - TARGET MINNEAPOLIS MN12.99Refund
One month of a card statement, converted the way your spreadsheet wants it.

The sign convention in the table is the budgeting convention: spending is negative, money coming back is positive. That is the convention this guide uses throughout, because most people convert a card statement to build a budget or an expense report. If you plan to import the file into accounting software as a credit card account instead, the signs run the other way — purchases positive, payments negative — and Step 2 shows how to flip them. Pick one convention and never mix the two in one file.

Step 1: Convert the credit card statement to CSV the balance-checked way

Start with the right PDF. Download the statement from your card issuer — Chase, American Express, Citi, Capital One, Discover and Barclaycard all offer a PDF download from online banking. Prefer the digital PDF over a scan or a phone photo of a paper statement: the digital file carries a text layer the converter can read exactly, while a scan has to be recognised character by character and misreads digits more often than words. Our guide to scanned vs digital bank statements explains how to tell which kind you have in ten seconds.

  1. Download the statement PDF for one card and one statement period. Never mix two cards in one file.
  2. Drop the PDF into the bank statement converter and let it read the transactions.
  3. Before downloading anything, check the preview: every row should have a date, a description and an amount, and the row count should be close to the number of transactions on the statement.
  4. Run the balance check: previous balance, plus purchases, plus interest and fees, minus payments and credits, should equal the new balance printed on the statement. If it does not, find the missing row before downloading.
  5. Download the CSV, then open it in Excel or Google Sheets and confirm it opens with one transaction per row and no descriptions split across two rows.
  6. Save the original PDF next to the CSV with the same name, so any row can be traced back to its page.

If the PDF is password-protected, unlock it once for the conversion; our guide to converting a password-protected bank statement PDF walks through it. For a year of statements, convert in batches — our guide to converting multiple bank statements at once shows how to keep the batch organised. The balance check itself is the test our guide on how to check a converted bank statement explains in full, and our guide to why a bank statement does not balance covers the common causes when the numbers refuse to agree.

Step 2: Fix the signs — purchases, payments, refunds and interest

This is the mistake that ruins the most card conversions, because the statement itself prints every number as a plain positive figure and leaves the meaning to the column it sits in. Purchases and payments look identical on the page; in your CSV they must be opposites. A payment recorded with the same sign as a purchase makes your spreadsheet think you spent the payment — and since a monthly payment is usually the largest number on the statement, the error is large enough to wreck a budget while looking plausible.

Row typeBudgeting CSV (this guide)Accounting import as a credit card
PurchaseNegativePositive
Payment to the cardPositiveNegative
Refund / creditPositiveNegative
Interest chargeNegativePositive
Fee (annual, late, foreign)NegativePositive
Cash advanceNegativePositive
Sign rules for each row type, under both conventions.

To flip a whole column in Excel, put -1 in an empty cell, copy it, select the amounts to flip, use Paste Special and multiply, then paste the results back as values. In Google Sheets the same result comes from a helper column with a formula such as =-A2, copied down and pasted as values. Do the flip once, for the whole file, before you categorise anything. If the first totals you compute show every expense as income, stop: the signs are reversed. Delete the import, flip the signs in the file, and start again.

Interest and fees are spending, not purchases. Keep them in their own type so a budget review can see what the card itself cost you this month.

Step 3: Split the sections your statement mixes together

A card statement is several small reports stapled together. The summary boxes at the top — previous balance, payments, new charges, new balance — are not transactions at all, and neither are the minimum payment due or the payment due date.

  • Delete every summary and totals row: previous balance, total purchases, total payments, new balance, minimum payment due.
  • Keep payments and credits as rows, marked with their type, so the balance equation can be checked against them.
  • Keep interest and fees as rows, marked with their type, so the true cost of the card stays visible.

Step 4: Clean the dates, descriptions and foreign-currency lines

Two dates appear on most card statements: the transaction date, when you made the purchase, and the posting date, when the issuer took the money. They are usually one or two days apart, but they can straddle a month boundary — a purchase made on 31 October that posts on 2 November belongs to October by transaction date and to November by posting date. For reconciling against the statement, use the posting date, because the statement's own totals are built on posted transactions. For a personal budget, either works, as long as you use the same one every month.

December into January needs the same care. Card statements print short dates such as 12/28 or 01/03 with no year, and a converter has to infer the year from the statement period. Check every row in the first week of January: a purchase dated 12/30 belongs to the old year. Our generic guide to converting a bank statement PDF to CSV covers the same date trap for bank statements.

  • Foreign-currency purchases: keep the converted amount in your own currency and delete the original-currency line, or keep the original amount in a separate note column — never total both.
  • Wrapped descriptions: a merchant name that wrapped over two lines on the PDF must become one cell, or the second half will look like a separate transaction with no amount.
  • Merchant codes: descriptions such as AMAZON MKTPLACE or SQ *COFFEE SHOP are normal — the letters after the asterisk are the payment processor, not a second merchant.
  • Remove currency symbols and commas inside numbers before importing anywhere; a cell that says $1,234.56 will break most importers.

Step 5: Check the file before it touches your books

A CSV is cheap to check and expensive to fix after it has been imported, categorised and reported on. Five minutes of checks now saves an afternoon of unpicking later. Run these checks on the finished file, not on the preview, because shaping and sign-flipping are exactly the steps where new errors creep in.

  1. Count the rows and compare with the statement: the number of transactions printed on the statement should match the purchase, payment, refund, interest and fee rows in the file.
  2. Add up the purchases and compare with the statement's total new charges — they should agree to the penny.
  3. Run the balance equation on the file itself: previous balance, plus purchases, plus interest and fees, minus payments and credits, should equal the new balance.
  4. Check the date range: the earliest and latest dates in the file should fall inside the statement period, with no rows from the previous month sneaking in.
  5. Spot-check five rows against the PDF — one purchase, one payment, one refund if there is one, one interest line and one foreign-currency line — and confirm the amount and the date on each.
If any check fails, the file was wrong before your budget or your books saw it. Go back to the conversion and shaping steps rather than fixing rows one by one in the finished file.

What to do with the CSV next

A clean card CSV has three common destinations, and each wants the file shaped slightly differently. For a budget in Excel or Google Sheets, the file as built here is ready: filter by the type column, total the purchases by merchant or category, and compare the monthly total with the statement's new charges. Our guide to converting a bank statement PDF to Excel shows the workbook version of the same workflow, and our guide to reconciling a bank statement in Excel after converting PDF to CSV shows how to match every line to your records until the balances agree.

For accounting software, the file needs the sign flip from Step 2: import it as a credit card account, with purchases positive and payments negative. Our guides to importing bank statements into QuickBooks and importing bank statements into Xero follow the same pattern — clean, balance-checked file, the target system's own layout, a defined date range. For an expense report, filter the file to purchases only, add a category column, and attach the statement PDF as the supporting document; the CSV is the detail, the PDF is the proof. And if you are choosing between CSV, OFX and QBO for the import, our comparison of OFX, QBO and QIF formats explains when each format earns its place.

Problems and fixes

ProblemLikely causeWhat to do
Spending total is far too highPayments recorded with the same sign as purchasesFlip the payment rows, then re-check the balance equation
Every expense shows as incomeSigns reversed for the whole fileFlip every amount in the file and re-import — do not fix rows one by one
The file will not balanceA summary row counted as a transaction, or a section missedDelete summary rows, then check each section against the statement
January spending looks wrongDecember purchases dated into the new yearMove late-December rows to the old year by posting date
Foreign purchases counted twiceOriginal-currency and converted lines both keptKeep the converted amount only; move the original to a note column
Missing transactionsA page skipped, or pending charges filtered outCount rows per page against the PDF and re-convert the missing page
Problems people hit when they convert a credit card statement to CSV, and the fix for each.

When a credit card statement will not convert cleanly

Most card statements convert cleanly from the digital PDF. A few do not, and knowing which kind you have saves a frustrating hour. Statements that combine several cards on one account, statements with a balance transfer that prints the same amount in three places, and very old scanned statements are the usual hard cases.

  • Combined multi-card statement: split the PDF by card first, or convert it whole and then split the CSV by the card number on each row.
  • Balance transfers: keep the transfer as one row and delete the summary lines that repeat it, then check the balance equation twice.
  • Old scanned statements: download the digital original from the issuer if it is still available — issuers usually keep at least a year of PDFs online.
  • Statements with heavy redactions cannot be converted from the redacted copy; use the unredacted download from online banking.

That is the whole job: download the digital PDF, convert it with the balance check running, fix the signs once, split the sections, clean the dates and the foreign-currency lines, and check the file before it goes anywhere. A card statement converted this way is not just a spreadsheet — it is a file whose numbers can be proved, row by row, against the statement it came from.

Sources and further reading

Put it into practice

Convert a statement now and watch the balance check run on your own file. The first 10 pages each month are free, and exports are never cut short.

Convert a statement See plans

More guides

How to Convert a Bank Statement PDF to CSV · How to Convert a Bank Statement PDF to Excel · How to Import Bank Statements into QuickBooks (QBO Files) · OFX vs. QBO vs. QIF: Which Format Should You Download? · Why a Converted Bank Statement Does Not Balance — and How to Fix It · How to Check a Converted Bank Statement Is Correct · Scanned vs. Digital Bank Statements: Why One Converts and the Other Does Not · How to Convert a Password-Protected Bank Statement PDF · How to Convert Many Bank Statements at Once (and Merge Them Cleanly) · Is It Safe to Convert Bank Statements Online? A Privacy Checklist · How to Import Bank Statements into Xero · How to Reconcile a Bank Statement in Excel After Converting PDF to CSV · How to Import Bank Statements into Sage from a PDF · How to Import Bank Statements into FreeAgent from a PDF · How to Import Bank Statements into Zoho Books from a PDF · How to Import Bank Statements into Wave from a PDF