Convert a PDF Credit Card Statement to CSV

Why a credit card PDF isn't usable data

A card issuer sends a statement as a PDF built for reading, not for accounting. The charges are printed in a list, wrapped around summary boxes for the previous balance, minimum payment, and interest, so there is no clean column of amounts to total or a merchant field to sort. For anyone tracking business spending, that means either retyping every line or squinting through pages at tax time. Converting the statement to a CSV pulls each charge out as a proper row, so the card's activity becomes something you can categorize, total, and reconcile instead of a document you read.

What the CSV pulls out, and what to skip

The conversion extracts what actually matters per transaction: the date, often both the transaction date and the posting date, the merchant or description, and the amount. It leaves out the parts of a statement that are not transactions, the previous balance, the payment due and minimum, the APR table, and the interest-charge summary, which would only clutter the data. Two card-specific items are worth watching: payments and statement credits show up as credits rather than purchases, and refunds and foreign transaction fees appear as their own lines. Keeping those tagged separately keeps your expense totals from being overstated by a payment that is not a cost.

Categorizing business expenses

The reason most people convert a card statement is to categorize it. With every charge in a CSV you can sort by merchant, group the recurring subscriptions, and tag each purchase to an expense category or a general ledger account, which is exactly what turns a pile of charges into deductible business expenses at tax time. A pivot by category totals the year in seconds, and filtering by merchant catches the personal charge that slipped onto the business card. Doing this from structured rows is far faster and more defensible than highlighting a printed statement.

Reconciling and importing to your books

Once the charges are in a CSV, they slot into your bookkeeping. You can reconcile the card by matching the converted charges against what is recorded in your accounting software, or import them outright. QuickBooks Online and Xero both take a CSV upload, so the categorized transactions go straight in. For QuickBooks Desktop, which reads only Web Connect files, convert the CSV a step further to a QBO. Either way, the converted statement gives you the card's month as data your books can absorb rather than a PDF you reconcile by eye.

Accuracy and privacy

Card statements are dense, and a misread merchant or amount would throw off a category total, so every extracted transaction is shown for review before you rely on it, and scanned or image-only statements are read with OCR. That review is where a split line or an odd character gets fixed up front. Because a card statement is sensitive financial data, the file is processed to build the CSV and then deleted automatically, with nothing retained on a server afterward. For a bookkeeper converting a client's card statements, that automatic deletion keeps the account data out of a third-party tool.

Frequently Asked Questions