How to Convert a Credit Card Statement to Excel

4 min read · Updated October 29, 2026 · By the StatementCheap team

Credit card statements are harder to work with than bank statements. The balance runs backwards (it's what you owe), transactions are split into sections, and there are often two dates per line. If you need the transactions in Excel, for an expense report, a tax return, a budget, or a client's books, this guide shows how to get a clean sheet and how to check it.

What makes card statements different

• The balance is a debt. "New balance" is what you owe. Purchases increase it. Payments and refunds reduce it.
• Transactions come in sections. Payments and credits, purchases, cash advances, fees and interest are often listed separately. In the US, Regulation Z requires fees and interest to be grouped under the headings "Fees" and "Interest Charged", with totals for the period and the year to date. Those sections are easy to miss when you copy data.
• Two dates. Many statements show a transaction date (when you bought) and a posting date (when the issuer recorded it). Pick one and stick with it. The posting date is the one that lines up with the statement period.
• Several cardholders. Statements for accounts with authorized users or employee cards often group transactions by card, with a subtotal for each.
• Foreign currency lines. A purchase abroad may show the original amount and currency on a second line, plus a separate foreign transaction fee.
• No running balance. Unlike most bank statements, card statements rarely print a balance after each transaction, so you can't check row by row. You check the totals instead.

Your options

1. Download from the card issuer

Most card issuers let you download recent activity as CSV or Excel from their website. If the dates you need are covered, start there. The catch is that downloads usually cover a limited window, and they may not include fees and interest the same way the statement does. Bank-specific steps are on our pages for American Express, Chase, Capital One, Citi and Discover.

2. Copy and paste from the PDF

Works for a short statement. Expect to fix wrapped descriptions, foreign currency lines and the section headers that land in the middle of your data. Copy each section separately so you don't lose the fees and interest. Our PDF to Excel guide covers this method and Excel's Get Data from PDF in detail.

3. Use a converter

A statement converter reads every section, merges them into one list, and applies a consistent sign. It's the fastest route for long statements, business cards with several cardholders, or a year of history.

Pick a sign convention

This is the decision that causes the most trouble later. The common convention, and the one StatementCheap uses, treats the card from the cardholder's point of view:

• Purchases, fees and interest are negative. Money going out of your pocket.
• Payments, refunds and credits are positive. Money coming back.

With that convention, the statement checks out like this: new balance owed = previous balance owed - sum of all amounts.

The opposite convention (purchases positive) is also fine, as long as every row follows it. Mixing the two is what breaks totals and imports.

Example and check formulas

A statement shows a previous balance of 1,204.56 and a new balance of 351.94. Here are the transactions in Excel, with dates in column A, descriptions in B and amounts in C:

Put the previous balance in F2 and the new balance in F3. Then:

• Payments and credits: =SUMIFS(C:C,C:C,">0") gives 1,229.56.
• Purchases, fees and interest: =SUMIFS(C:C,C:C,"<0") gives -376.94.
• Check: =ROUND(F2-SUM(C2:C6)-F3,2) should return 0. Here, 1,204.56 - 852.62 - 351.94 = 0.

Also compare the two SUMIFS results with the summary box on the statement. If purchases are short, a section was probably skipped. Fees and interest are the usual suspects. If the statement shows separate totals for each cardholder, add a Cardholder column and compare each subtotal with =SUMIFS(C:C,D:D,"Jane").

Make the sheet useful

• Add a Category column. Type categories yourself, or use a lookup table that maps merchant keywords to categories with XLOOKUP or VLOOKUP.
• Add a Month column with =TEXT(A2,"yyyy-mm") and build a PivotTable by month and category.
• Flag business expenses with a Yes/No column, then total them with =SUMIFS(C:C,E:E,"Yes") for an expense report or tax return.
• Keep the statement period in a column when you combine several months, so you can trace any row back to its PDF.

Common mistakes

• Treating the payment as income. A payment to the card is a transfer from your bank account, not money earned. If you total "money in" across bank and card sheets, exclude card payments or you'll count them twice.
• Dropping the interest and fees. They sit in their own sections and are easy to leave behind when copying. They're also the lines you most need for a business tax return.
• Using the wrong year. Card statements often print dates as month and day only. A statement that closes in early January will include December purchases.
• Double counting refunds. A refund shows as a credit. Don't also delete the original purchase, or your totals won't tie to the statement.

Importing card transactions into accounting software

If the data is headed to QuickBooks or Xero, import it into a credit card account, not a checking account. In QuickBooks Online, choose the credit card account when you upload. In Xero, payments to the card are positive and purchases negative, the same as the convention above. Reversed signs almost always mean the file went into the wrong type of account. See importing into QuickBooks Online and Xero's CSV format.

Convert a card statement now

StatementCheap reads PDF credit card statements, combines every section into one list with purchases negative and payments positive, and checks the result against the statement's previous and new balances. Download it as Excel, CSV, QBO, Xero CSV or OFX. The first 5 pages each day are free with a free account, and files are processed in memory and not stored. Upload a statement, or read more about credit card statements to Excel and pricing.