Skip to content
Toolspike

Credit card statement to Excel

Card statements list purchases, refunds, fees and payments, usually without a running balance. The converter reads each row, keeps charges and credits apart, and checks that the previous balance plus charges, less payments, comes to the total amount due printed on the statement.

No sign-up to read and check a statement, and 5 pages a day download free with a free account. A PDF with text is read in your browser and not uploaded; scans and photos go to AI only if you choose.

5 statement pages free every day with a free account, and every row and the balance check to see first. A Statement Pass covers bigger jobs, paid once.

  • Stays on your deviceA PDF with text is read in this browser and never uploaded. A scan is sent to our AI provider only if you choose.
  • Checked against the balanceEvery row has to land on the running balance the bank printed, so a misread figure shows up before it reaches your books.
  • Nothing keptNo statement or download is stored on our servers, and a password only opens the file.

See it before you upload

From PDF lines to rows your books accept

The first rows of the made-up sample statement, as printed and as you download them. Press “Try a sample statement” above to open all of it.

What the statement prints

  1. 08/01POS PURCHASE BLUE DOOR COFFEE #12 SEATTLE WA5.45Withdrawals
  2. 08/02CHECK 10451,200.00Withdrawals
  3. 08/03ACH DEPOSIT NORTHWIND LLC PAYROLL2,500.00Deposits
  4. 08/05WIRELESS BILL AUTOPAY89.99Withdrawals
  5. 08/08POS PURCHASE BLUE DOOR COFFEE #12 SEATTLE WA6.10Withdrawals

What you download

  1. Blue Door Coffee SeattleRestaurants and takeaway−$5.45Aug 1
  2. Check 1045Uncategorized−$1,200.00Aug 2
  3. Northwind LLC PayrollPayroll and wages+$2,500.00Aug 3
  4. Wireless Bill AutopayPhone and internet−$89.99Aug 5
  5. Blue Door Coffee SeattleRestaurants and takeaway−$6.10Aug 8

Reconciled: every running balance matches

Opens in the software you use

  • QuickBooks OnlineQBO or CSV
  • QuickBooks DesktopQBO or IIF
  • XeroOFX or CSV
  • QuickenQFX
  • SageCSV
  • WaveCSV
  • FreeAgentCSV
  • MYOBOFX or QIF
  • Zoho BooksCSV, OFX or QIF
  • GnuCashOFX or QIF
  • Excel and Google SheetsXLSX or CSV
  • TallyXML

Product names belong to their owners; Toolspike is not connected with them. Each file is one that program’s own import reads.

Insights on every statement

Average daily balance
$7,103.26
Biggest spending category
Rent and mortgage, $2,000.00
Recurring payment found
Blue Door Coffee Seattle, weekly, about $5.45
Returned, NSF or overdraft rows
1

Figures from the made-up sample. Your own statements get the same panel, and the full lists in the Insights sheet of the Excel download.

What comes out

  • Purchases, fees and interest in the debit column
  • Payments, refunds and cashback in the credit column
  • A check of previous balance, charges and payments against the amount due
  • Real dates, even when the statement prints day and month only
  • Several statements merged into one sheet
  • The same data as CSV, QBO, OFX or QIF if you need it

How charges and credits are told apart

Card statements mark credits in different ways: Cr after the amount, a minus sign, brackets, or a separate column. All of these are read. When an amount carries no mark at all, it is treated as a charge, since that is what most rows on a card statement are, and you can change any row in the table.

Dates without a year

Many card statements print dates such as 28 Dec with no year. The converter takes the year from the statement period, so a statement running from December into January puts December rows in the old year and January rows in the new one.

Questions

Why does it say "Totals match" instead of "Reconciled"?

Card statements rarely print a balance after each row, so single rows cannot be checked. What can be checked is the whole statement: previous balance plus charges, less payments and refunds, must equal the amount due, and that is what "Totals match" confirms.

Are foreign transactions shown in my own currency?

The amount is taken from the column the statement bills you in, such as US dollars on a US card. A foreign-currency amount printed beside the description stays part of the description, so the original figure is still there to see.

Can I import a card statement into QuickBooks?

Yes. Choose the QBO format and the file uses QuickBooks’ credit card layout, with purchases as charges and payments as credits. Link it to your credit card account when QuickBooks asks.

What if my statement is protected with a password?

Type the password when asked and the statement opens in your browser. Some issuers, mostly outside the US, use part of your name with your date of birth as the password. It is not stored or sent anywhere.