Convert a credit card statement to Excel

Drop a PDF credit card statement below and get a spreadsheet with charges, payments, refunds, fees and interest as separate rows — with the signs the right way round and the totals checked against the statement's own summary.

Card statements are not current-account statements with a different logo. They are laid out differently, sign amounts differently, and usually carry no running balance at all, which is why converters built for bank statements tend to get them subtly and expensively wrong.

The sign problem, and why it matters

On a current account, money leaving is unambiguous. On a credit card it is genuinely ambiguous, because the statement is written from the issuer’s side of the ledger: a purchase increases what you owe, so it is printed as a positive number, and your payment reduces it, so that is the one marked CR.

Import that without thinking and every expense in your books is income. It is the kind of error that reconciles to zero at the account level and is completely wrong at every category below it — so it survives a quick check and turns up at year end.

We derive direction from how the statement marks the amount — the column it sits in, a trailing CR, a bracket, a minus — and never from what the description says. Then we write it from your point of view: money out negative, money in positive, consistently, on every row.

Reconciling without a running balance

A bank statement lets you check each row against the balance beside it. A card statement usually does not, so the check uses the summary box on the front page instead:

previous balance      1,204.18
+ purchases             842.60
+ fees and interest      31.45
− payments and credits  900.00
─────────────────────────────
= new balance         1,178.23   ✓ matches the statement

Every transaction has to land on the correct side for that to come out right, which makes it a stronger test than it looks: a single refund filed as a purchase throws the total out by twice its value, and the badge stays red until it is fixed.

What you can fix before exporting

Card descriptions are the worst on any statement — truncated merchant names, a payment processor’s name instead of the shop, a store number where the city should be. Every field in the table is editable, and anything the parser was unsure about is flagged for review rather than quietly accepted.

If you turn on remembered categories in your account, a correction you make to a merchant is applied to that merchant next month too. Only your own corrections are stored, never our guesses, and no amounts or dates go with them.

Questions

Why do my payments show as positive and my purchases as negative?

Because the file is written from your point of view rather than the card issuer's. A purchase takes money from you, so it is negative; a payment or a refund gives money back, so it is positive. Card statements print the opposite, because they are describing what you owe the issuer. If you want the issuer's convention, negate the amount column — one formula, applied once.

There is no running balance column. Is that a problem?

No. Most card statements do not print one, so we reconcile against the summary box instead: previous balance, plus purchases, plus fees and interest, minus payments and credits, should equal the new balance. That is the same guarantee, derived from a different set of numbers.

How do you know a transaction is a refund rather than a purchase?

From the statement's layout, not from the wording. Card statements mark credits with a trailing CR, a minus sign, a separate column, or a distinct section — and which one varies by issuer. Reading the layout is reliable; guessing from a description is not, which is why a refund from a shop called something ending in "Credit Union" does not confuse it.

Does it handle foreign currency transactions?

The amount charged to the card is what comes through, which is the figure that matters for reconciling. Where the statement also prints the original currency and amount, those stay in the description rather than becoming their own column, so the amount column remains one currency and still sums.

What about cash advances, interest and fees?

They come through as transactions like any other, with the fee and interest lines categorised as such. They have to: leave them out and the summary check fails, which is exactly what the check is for.

Other formats

• PDF bank statement to ExcelReal number and date cells, not text that looks like numbers.
• Bank statement to CSVUTF-8, quoted properly, opens the same everywhere.
• Bank statement to QuickBooksA QBO file for when bank feeds cannot reach the data.

Looking for your bank specifically? 150 institutions have their own download instructions — see the list.