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. Your statement is read in your browser; nothing is uploaded.
Free trial: 1 run of Bank Statement Converter every day. After that, 2 credits per run.
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 international transactions shown in rupees?
The amount is taken from the column the statement bills you in, which for an Indian card is rupees. 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. Card issuers often use part of your name with your date of birth. The password is not stored or sent anywhere.