To get a credit card statement into Excel, convert the PDF to a spreadsheet, then check that the previous balance plus charges and fees, minus payments, equals the new balance. A card statement differs from a bank statement: it prints two dates per line, shows no running balance, and treats charges as the positive amounts.
How is a credit card statement laid out differently?
A credit card statement lists purchases, payments, interest and fees in separate blocks, usually with two dates per line and no running balance. Those three differences change which columns you keep and how you prove the conversion is complete.
Two dates on every line
Most card statements print a transaction date, which is the day you made the purchase, and a post date, which is the day the card issuer recorded it. A purchase on the last day of a month often posts on the first of the next. Keep both dates in separate columns. Choose one as the "date" for your reports and stay with it. If you sort by the wrong one, a March purchase can land in April, and your monthly totals will disagree with the statement.
Blocks instead of one list
A bank statement is usually one long list. A card statement often splits the lines under headings such as Payments and Credits, Purchases, Fees Charged and Interest Charged. The headings are not transactions. When a converter reads the page, a heading can end up as a row with no amount, and a subtotal can end up as a row with an amount that is not a transaction. Delete heading rows, and delete subtotal rows only after you have used them to check your own totals.
No running balance
A bank statement prints a balance after each line, so you can test every row. A card statement normally gives you only a summary box: previous balance, payments, purchases, fees, interest and new balance. That box is your check. Opening figure plus charges and fees, minus payments and credits, must equal the new balance. If it does not, a line is missing or doubled, but the statement cannot tell you which one. The gap is the size of the missing line, so look for a charge with that amount.
A worked check on the summary box
The figures below are an example, not a real statement.
| Summary line | Amount |
|---|---|
| Previous balance | 500.00 |
| Purchases | 156.05 |
| Fees and interest | 0.00 |
| Payments | -300.00 |
| New balance | 356.05 |
If your spreadsheet adds up to 356.05 from the previous balance, the conversion is complete. If it says 333.05, you are missing a 23.00 line, and you know what to look for.
Signs for charges and payments on a credit card sheet
On a card statement, a charge is a positive amount and a payment or refund is a negative one, because the statement reports how much you owe. A bank statement works the other way round: a deposit is positive, a withdrawal negative. Mixing the two conventions in one workbook gives wrong totals.
Why the sign flips
A card account is a debt. Spending raises the balance you owe, so spending shows as positive. A payment lowers it, so it shows as negative, often printed with a minus sign or in brackets, such as (300.00) or 300.00CR. Your bank account is an asset, so spending lowers it. The same purchase therefore has opposite signs in the two places.
Choosing one convention
Decide before you build any formulas. If you track expenses, positive for spending is natural, and a card sheet already follows it. If you merge card lines with bank lines in one sheet, flip the card amounts by multiplying by -1 so that money out is negative everywhere. Write the choice in a note at the top of the sheet.
Whether to keep one signed amount column or split debits and credits is a separate question about bank layouts, and one or two amount columns is covered in the bank statement guide. For cards, one signed column is usually simpler, since there are only charges and payments.
Trailing minus and CR markers
Some statements print the minus sign after the number, or write CR after a credit. Excel stores these as text, so they will not sum. Convert them to proper numbers before you total anything. The post on turning a PDF into an Excel spreadsheet you can sort and total shows a readiness check that catches this.
Interest, fees and cash advances in a credit card export
Interest, fees and cash advances belong in your export, but keep them apart from purchases. They are charges the issuer adds, not things you bought, and mixing them into merchant totals hides what the card costs you.
Where they appear on the page
Many statements put interest and fees in their own block near the end, and a summary table called something like "Interest Charge Calculation" sits close to it. That table lists annual rates and balances. It is a calculation, not a list of transactions, and it should not become rows in your sheet. Only the dollar amount of interest charged, which also appears in the fee and interest block, is a transaction.
Add a type column
The simplest fix is one extra column, Type, with values such as Purchase, Payment, Fee, Interest and Cash advance. Fill it from the block each line came from. Then a pivot or a SUMIFS can separate "what I spent" from "what the card cost me", and you can total each month's interest in one formula.
Example lines
These are example lines, with invented amounts:
| Post date | Description | Type | Amount |
|---|---|---|---|
| 2026-03-31 | PURCHASE INTEREST CHARGE | Interest | 12.40 |
| 2026-03-31 | LATE PAYMENT FEE | Fee | 29.00 |
| 2026-03-18 | CASH ADVANCE ATM | Cash advance | 200.00 |
A cash advance is a charge, and often comes with a separate fee line. Keep both rows. If you drop the fee because it looks small, the statement summary will no longer tie to your sheet.
Foreign currency lines on a credit card statement
A foreign purchase on a card statement often prints an extra line giving the original amount, the currency and the exchange rate, and sometimes a separate foreign transaction fee. The extra line is information, not a second charge, so it needs care or you will count the purchase twice.
What the extra line looks like
Here is an example. Under a purchase for 43.60 in dollars, the statement may print "EUR 40.00 @ 1.0900". The 43.60 is what the card charged. The euro amount and the rate explain how it got there. If your conversion turns that explanatory line into its own row, and the 40.00 lands in the amount column, your total is wrong.
Keep the charge, store the rest
Keep the dollar charge as the amount. Put the original currency, the original amount and the rate in extra columns, or in a note next to the row. Treat a foreign transaction fee, if one is printed as its own line, as a Fee row tied to that purchase. In this example the fee might be 1.31, a made-up figure that is about 3 percent of 43.60.
Check with the summary
After removing explanatory lines, run the summary check again. Purchases in the summary should equal the sum of your Purchase rows in the card's own currency. If the check is off by exactly the original foreign amount, an explanatory line was kept as a charge.
Can you total credit card spending by merchant in Excel?
Yes. Add a Merchant column with a clean merchant name, then use SUMIFS to add up the amounts for each name, or a pivot table. The work is in the cleaning: card descriptions carry store numbers, dates and city names, so the same shop appears under several spellings.
Worked example: five transactions and a SUMIFS
These five lines are an example, with made-up merchants and amounts. Put them in Excel with the columns shown:
| A: Post date | B: Merchant | C: Type | D: Amount | |
|---|---|---|---|---|
| 2 | 2026-03-03 | GREEN LEAF MARKET | Purchase | 54.20 |
| 3 | 2026-03-06 | FUEL STOP | Purchase | 38.75 |
| 4 | 2026-03-10 | GREEN LEAF MARKET | Purchase | 41.10 |
| 5 | 2026-03-13 | PAYMENT THANK YOU | Payment | -300.00 |
| 6 | 2026-03-16 | CITY TRANSIT | Purchase | 22.00 |
To total spending at one merchant, type this formula in a spare cell:
=SUMIFS(D2:D6, B2:B6, "GREEN LEAF MARKET", C2:C6, "Purchase")
The result is 95.30, which is 54.20 plus 41.10. The third condition, Type equal to Purchase, keeps a refund or a payment from a merchant with the same name out of the total. To total all purchases at once, drop the merchant condition:
=SUMIFS(D2:D6, C2:C6, "Purchase")
That returns 156.05, matching the Purchases line in the summary example above.
Cleaning merchant names
Real statements print "GREEN LEAF MARKET #0412 SPRINGFIELD" on one line and "GREEN LEAF MKT 0388" on another. SUMIFS matches text exactly, so these count as two merchants. Build the Merchant column from the Description column by hand or with a helper formula, such as taking the text before the first number sign with LEFT and FIND. Wildcards also help: a criterion of "GREEN LEAF*" matches any description that starts with those words. Spot-check by sorting the Merchant column; near-duplicates sit next to each other.
When a pivot table is faster
If you have more than a few merchants, a pivot table with Merchant in the rows, Amount in the values and Type as a filter gives every merchant total in one pass. Use SUMIFS when you need one figure in a fixed cell, and a pivot when you want the whole list.
Getting the statement into Excel first
Everything above assumes the statement already sits in a spreadsheet. FastBankConvert reads a statement's layout rather than a fixed list of banks, and its FAQ says it is built for credit card statements as well as checking and savings. It is getting ready to open, and the homepage shows a sample conversion.
Whatever tool you use, apply the checks in this post to the result: summary box tied out, signs consistent, heading and subtotal rows removed, and the Type column filled. A year of card statements is long enough that it is worth reading how to convert a large PDF to Excel without duplicates before you start. If you plan to send the result to a colleague or open it in the browser, the guide to moving a statement into Google Sheets or Excel covers the import steps and the locale settings.