Convert a credit card statement PDF to Excel

Upload the PDF and download an Excel file with every charge, payment and refund in its own row. Before you download, the statement is checked against its own totals, for each currency. Your first 10 pages each day are free.

Convert a statement

What’s in the Excel file

Transactions sheet
One row per transaction: Date, Description, Debit, Credit, Amount, Balance and Currency.
Charges and payments
Charges go in Debit; payments and refunds go in Credit. Amount is signed, so charges are negative.
Currency
Each row carries its currency, so a card that bills in two currencies stays in one file.
Summary sheet
One line per currency: previous balance, charges, payments, the new balance we calculated, the one printed on the statement, and whether they match.
Dates
Real Excel dates, shown as month/day/year, so you can sort and filter them.

How a card statement is checked

A card statement doesn’t print a balance on every page, so it’s checked as a whole: previous balance, plus charges, minus payments, has to equal the new balance. If the statement bills in more than one currency, each one is checked on its own.

If the totals don’t match, you see by how much before you download, and you can fix the row in the table and check again.

CSV and QuickBooks too

The same statement downloads as a CSV with the same columns, or as a QuickBooks CSV. A QuickBooks account has one currency, so that file carries the statement’s main one.

Convert it in three steps

  1. Upload the PDF on StatementTally. Scanned statements work too.
  2. Review it. The previous balance, plus charges, minus payments, has to equal the new balance, for each currency. If it doesn’t, you see by how much, and you can fix it.
  3. Download Excel, CSV or a QuickBooks CSV, as many times as you need.

Your PDF is deleted as soon as it’s read, and your transactions are removed within 24 hours. Security

Questions

Which cards does it work with?

Any card. There’s no list of supported issuers: we read the statement itself and check it against its own totals.

Does it handle statements in two currencies?

Yes. Each row has its currency, and each currency is checked on its own.

Does it work with scanned statements?

Yes. Scanned PDFs work too; a clean scan reads best.

Is it free?

Yes, for 10 pages a day, with no account. After that, a page pack is US$2.99 for 20 pages and never expires, or Pro is US$24 a month for 600 pages.

What happens to my statement?

The PDF is deleted as soon as it’s read. The transactions are kept for up to 24 hours so you can review and download them, then they’re removed. You can delete them sooner yourself.

More ways to convert