How credit card statements differ from bank statements
A card statement looks like a bank statement but works the other way round. Purchases increase what you owe, so many US issuers print them as positive numbers and show payments and refunds as negative. Others print everything positive and mark payments with “CR”. There are usually two dates — when you bought something and when it posted — and the year is often missing from each line, appearing only in the statement period. There’s rarely a running balance.
Convert a card statement to Excel
- Download the statement PDF from your card account — a digital PDF, not a scan. Drop it on the converter above.
- Check the preview. Purchases should appear under Money out and payments under Money in. If your issuer prints purchases as positive numbers and they show as money in, tick Swap money in and money out.
- Fix anything the preview highlights, then download the Excel workbook.
Lines without a year are dated using the statement period, so a January statement’s “01/03” becomes 3 January of that year.
What the spreadsheet contains
| Column | What it holds |
|---|---|
| Date | The transaction date as an Excel date. |
| Description | The merchant, plus any detail printed on the line. |
| Debit | Purchases, fees and interest — money you owe — as positive numbers. |
| Credit | Payments and refunds as positive numbers. |
| Amount | One signed figure, negative for purchases, ready to total. |
Card statement problems to watch for
- Signs the wrong way round. Use the swap option above; it flips every row at once.
- Interest and fee sections. Many statements list fees and interest in a separate block. Check they were picked up, and add any missing line in the preview.
- Foreign currency lines. A purchase abroad may print the original currency amount and an exchange rate on a second line. Check that the amount in the row is the one in your card’s currency.
- Several cardholders. Statements with additional cards often group transactions by card number. Compare the transaction count with the statement to make sure every group was read.
- Scanned statements. If you can’t select the text in the PDF, follow the scanned statement guide instead.
Have a CSV download instead?
Most card issuers also offer a CSV of recent activity. That’s more exact than a PDF: use the bank statement converter, which reads card layouts from Chase, Citi, Capital One and others and can write Excel too.
Frequently asked questions
Why are my purchases showing as money in?
Many issuers print purchases as positive numbers. Tick “Swap money in and money out” in step 2 and every row is flipped.
My statement lines have no year. Is that a problem?
No. The year is taken from the statement period printed on the statement.
Does it work with Amex, Visa and Mastercard statements?
It works with digital PDF statements whose transactions are laid out as a table. Layouts vary between issuers, so always check the preview and totals.
Is my credit card statement uploaded?
No. The PDF is read in your browser and the spreadsheet is saved to your device.
Can I convert several months at once?
Convert each statement, then combine the results with the Combine CSV and Excel files tool, which also removes overlapping rows.