How to convert a credit card statement PDF to CSV

A credit card statement looks like a bank statement but follows different rules. Here is how to get it into a spreadsheet without flipping signs or losing rows.

What is different about a card statement

On a bank account, deposits raise the balance. On a card, purchases raise the balance you owe and payments and refunds lower it. Many statements print purchases as plain positive numbers and payments with a minus sign, a trailing CR, or parentheses. If a converter treats every number as a deposit, the signs come out backwards.

Card statements also tend to list a transaction date and a posting date, then a merchant name that often wraps onto a second line, and sometimes foreign-currency details underneath a purchase. Those extras are where most conversion errors start.

Steps

Download the PDF from your card issuer rather than taking a photo or a print-to-scan copy. You need a text-based PDF, which you can test by trying to select a line of text in a PDF viewer.
Find the summary box. Note the previous balance, the total of purchases, the total of payments and credits, any fees and interest, and the new balance. These numbers are your check.
Convert the transaction table to CSV with a tool of your choice. Look at the result before trusting it: is each purchase on one row, and is each payment negative (or in its own column)?
Decide on one sign convention and apply it to the whole file. Most accounting imports want money leaving you as negative.
Prove it. Previous balance + purchases + fees + interest − payments − credits should equal the new balance, to the cent. A gap means a row is missing, duplicated, or has the wrong sign.
Keep interest and fees. They are easy to drop because they sit in a separate block from the purchases but they are part of the balance.

If the numbers do not tie

A gap equal to one amount on the statement usually means a missing row. A gap equal to double an amount usually means one sign flipped. Our guide on why converted totals don't match walks through both cases.

Where PennyTie fits

PennyTie is one way to do this. It reads a text-based card or bank statement PDF in your browser, writes the rows to CSV, and checks opening balance plus transactions against the closing balance. Rows it is unsure about are flagged so you can look at them against the PDF. Nothing is uploaded; the file is processed on your device.

Limits

It reads text PDFs only. There is no OCR, so scanned or photographed statements will not work.
Layouts vary between issuers. Review any flagged rows and confirm the sign of payments and refunds before importing.
A tie-out proves the arithmetic, not that each merchant name or date was read correctly. Skim the file once.

Try it: open PennyTie, drop a text-based statement PDF (or use the built-in fictional sample) and see whether the totals tie out. Free for statements up to 5 pages; nothing is uploaded.