fileforge

Bank statement to Excel › Guides

Convert a credit card statement PDF to CSV

Credit card statements differ from bank statements: purchases are usually printed as positive numbers, there are two dates per line, and there is often no running balance. Here is how to get a clean CSV of purchases and payments on your own computer.

Verified sample The sample below was produced by running this site's converter on a synthetic card statement. It is not real data.

Steps

  1. Download the statement PDF from your card issuer. It must be the PDF the issuer generates, not a photo of a paper statement.
  2. Open the bank statement converter and drop the PDF on it. Nothing is uploaded; the file is read in your browser.
  3. Tick "Credit card: positive amounts are purchases". This makes purchases negative (money out) and payments or refunds positive, so the sign means the same as in a bank statement. Leave it off if your issuer already prints purchases as negative.
  4. Check the columns it found. The page says which columns it used. With a transaction date and a post date, the transaction date becomes the Date column.
  5. Check the preview against the statement. A card statement has no running balance to check against, so compare the totals: the sum of purchases in the preview should match the statement's purchases total.
  6. Download CSV or Excel. With several statements, tick "Combine files into one list" to get one sheet for the year.

Sample: a synthetic card statement

Date	Description	Amount
2026-04-02	TRANSFER TO SAVINGS	-300.00
2026-04-03	TRANSFER FROM SAVINGS	36.50
2026-04-04	INTEREST PAID	1830.25
2026-04-05	RENT PAYMENT LANDLORD LLC	-4.75
2026-04-07	COFFEE HOUSE 0098	-62.18
2026-04-08	ELECTRIC UTILITY AUTOPAY	-54.32

28 transactions. Positive amounts were treated as money out (credit-card style).

What to check

Open the bank statement converter