Convert a credit-card statement to Excel

Get every charge, payment and refund from a credit-card statement PDF into Excel, with the totals checked against the previous and new balance.

Runs in your browser. Your file never leaves this device.

Loading the tool…

How card statements are handled

Card statements often show two dates (when you bought and when it posted) and print purchases as positive numbers. The converter keeps both dates and flips the signs so that purchases are negative and payments or refunds are positive, the same rule used for bank accounts.

It then checks the result: previous balance plus new charges minus payments and credits should equal the new balance printed on the statement.

Tips

  • Download the statement PDF from your card's website or app; a photo of a paper statement can't be read.
  • Use Excel's filter on the Description column to total spending by merchant.

What this tool does

Credit-card statements are laid out differently from bank statements. Most print a transaction date and a posting date, list purchases as positive numbers, show payments and refunds with a minus sign or a "CR", and end with a previous balance, new charges and a new balance instead of a running balance.

The converter reads that layout and gives you a spreadsheet with one row per charge, payment, refund, fee or interest line. Both dates are kept. Signs are made consistent with bank accounts, so purchases are negative and payments or refunds are positive, which is what accounting software expects when you import.

Then it does the arithmetic a card company does: previous balance plus charges minus payments and credits should equal the new balance. You see straight away whether every line was captured. The PDF stays on your device.

People use it for

  • Totalling business expenses on a card for an expense report
  • Matching card charges to receipts at month end
  • Finding recurring subscriptions across a year of statements
  • Giving a bookkeeper card transactions in a clean spreadsheet

How to use it

  1. Download the card statement PDF

    Get it from your card issuer's website or app. Monthly statements work best; a screenshot of recent activity has no totals to check against.

  2. Drop it and check the new balance

    The converter lists every line and compares its total with the new balance on the statement. A mismatch tells you by how much.

  3. Download Excel

    The workbook keeps dates and amounts as real numbers with a summary sheet. Filter or pivot by description to total spending by merchant.

What it works with

You give itYou get
Bank statement PDF (text)Excel (.xlsx)
Credit-card statement PDFCSV
Bank or card statement PDFOFX

Questions

Why are my purchases negative in the spreadsheet?

So that cards and bank accounts follow one rule: money out is negative, money in is positive. Payments to the card and refunds come out positive.

Are both the transaction date and the posting date kept?

Yes, when the statement prints both. The posting date is the one that matches the statement period.

What about interest, fees and foreign-currency charges?

They are rows like any other charge, with the description the statement prints and the amount from the statement's amount column.

How is the result checked?

Previous balance plus charges minus payments and credits must equal the new balance on the statement. If it doesn't, the difference is shown so you can find the missing line.

Is the card statement uploaded?

No. It is read in your browser and never leaves your device.

Guides