How to Convert an Amex Statement to Excel

TL;DR: American Express lets you download recent card activity in spreadsheet formats, which is the fastest route for current months. For older periods, or when you need data that matches the official statement, convert the PDF. Because Amex statements often group charges by cardholder and separate payments, credits, fees and interest, check that every section made it into your sheet.

American Express cards turn up constantly in small business bookkeeping. They're popular for business spending, they often have several employee cards on one account, and their statements are long. A busy month can run to many pages of charges split by cardholder. Retyping that is not a good use of anyone's afternoon.

Here's how we get Amex data into Excel reliably, and how we make the result useful for expense tracking, reconciliation and tax prep.

Know your Amex account type

Amex issues different kinds of products, and the statements reflect that:

• Charge cards (traditionally, many of the classic personal and business cards) generally expect the balance to be paid in full, though some now offer pay-over-time features.
• Credit cards carry a revolving balance with interest.
• Business cards often have multiple cardholders, with charges grouped per card.
• Savings and checking accounts exist too, through Amex's banking products, and convert like any bank statement.

For conversion, the important difference is structure. Card statements typically show a summary (previous balance, payments and credits, new charges, fees, interest, new balance) and then detail sections. Business statements may list each cardholder's charges in their own block with subtotals. All of that has to land in one flat table.

Option 1: download activity from the Amex website

For recent activity, the download is quick:

1. Sign in on the American Express website.
2. Open the card account and go to the statement or activity view.
3. Look for a download option. Amex usually offers formats such as CSV and Excel, plus formats for Quicken and QuickBooks.
4. Pick the period. Choosing a specific statement period rather than a custom date range makes the file line up with the PDF.
5. Open the file in Excel.

Exports often include extra columns that are genuinely useful, such as card member name, the account number the charge belongs to, extended merchant details, and sometimes a category. If you're on a business account with several cardholders, keep the card member column; it saves you from splitting the data later.

The limit is history. Downloads only reach back so far. For prior years, you'll need statements.

Option 2: convert the PDF statement

To get older months, or to match the official statement exactly:

1. Download the statement PDFs from the statements area of your account.
2. Upload them to the credit card statement converter.
3. The converter reads the summary, the payment and credit section, each cardholder's charges, and the fees and interest sections, and outputs one row per transaction.
4. It checks that the previous balance plus charges, fees and interest, minus payments and credits, equals the new balance.
5. Review anything flagged, then export to Excel.

Our American Express bank page lists the statement layouts we've tested.

The balance check for an Amex statement

Amex prints the key totals near the top of the statement. Use them:

Line	Where to find it	Sheet formula
Previous balance	Summary	typed in
Payments and credits	Summary	=SUMIFS(Amount,Type,"Payment")+SUMIFS(Amount,Type,"Credit")
New charges	Summary	=SUMIFS(Amount,Type,"Charge")
Fees	Summary	=SUMIFS(Amount,Type,"Fee")
Interest charged	Summary	=SUMIFS(Amount,Type,"Interest")
New balance	Summary	previous + all of the above

If you don't have a Type column, sign alone works: charges positive, payments and credits negative, and the sum of everything added to the previous balance should hit the new balance.

When there are multiple cardholders, each block usually has its own subtotal. Check each one. If the total is off and one cardholder's subtotal is off by the same amount, you've narrowed the search from hundreds of rows to a few dozen.

Making the workbook useful

Keep the cardholder

For business cards, the cardholder column is the most useful one after amount. It lets you produce per-person expense reports, chase missing receipts from the right person, and spot unusual spending.

If you converted from PDF and the cardholder appears only as a section heading, make sure the converter carried it onto each row. If not, fill it down: select the column, press F5, choose Special > Blanks, type = and the up arrow, then Ctrl+Enter. Every blank picks up the name above it.

Separate the merchant from the location

Amex descriptions often combine the merchant name, a city or phone number, and a state. For categorization, the merchant name is what matters. A quick =TRIM(LEFT([@Description],FIND(" ",[@Description]&" ")-1)) grabs everything before the first double space, which often isolates the merchant. Adjust to taste; descriptions vary.

Handle foreign charges

International charges usually show the US dollar amount you were billed, and sometimes the foreign currency amount and exchange rate in the description or on an extra line. Make sure the converter didn't turn the foreign amount into its own transaction. The balance check will catch it, since that would inflate charges, but it's easier to recognize the pattern up front.

If your card charges foreign transaction fees, they'll appear separately. Categorize them as bank fees rather than lumping them into the purchase.

Categorize

Amex exports sometimes include their own category, which is a decent starting point but doesn't map to your chart of accounts. We add our own Category column and use a keyword lookup. Our guide to Excel formulas for categorizing transactions has several patterns, from simple IF chains to lookup tables.

Getting Amex data into your accounting software

QuickBooks

In QuickBooks, Amex cards are set up as credit card accounts. If the card isn't connected via a feed, or you need historical months, import a file. A QBO (Web Connect) file is usually the cleanest choice because it carries the account type and transaction IDs, which QuickBooks uses to prevent duplicates. Our QuickBooks converter creates them. If you're on QuickBooks Desktop, read our IIF import guide before choosing IIF, because it writes straight to the register.

Xero

Xero accepts a CSV statement import on the card's account. Charges should be negative (money spent) and payments to the card positive. Check a few lines after importing. Our Xero CSV format guide explains the column layout.

Reconciliation

Whatever software you use, reconcile the card monthly against the statement's new balance. A card with multiple employees is exactly the kind of account where small errors accumulate. Our guide to credit card reconciliation in Excel walks through it.

A worked example with two cardholders

Let's walk through an invented business statement so the checks feel concrete.

The summary shows a previous balance of 6,412.30, payments and credits of 6,512.30, new charges of 7,845.66, fees of 0.00, and a new balance of 7,745.66. The detail pages list a payment of 6,412.30, a credit of 100.00 from a returned item, and then two cardholder blocks: Sam with charges totaling 3,120.40 and Priya with charges totaling 4,725.26.

After conversion, our sheet has 118 rows. We sum the charges and get 7,690.66, which is 155.00 short. We check the cardholder subtotals: Sam's rows sum to 3,120.40, a match. Priya's rows sum to 4,570.26, short by 155.00. So the problem is in Priya's block.

We filter to Priya and sort by date. Her charges on the statement continue onto a new page halfway through the month, and the first line on that page, a 155.00 hotel charge, is missing from our sheet. The converter had treated the page's top line as a continuation of the header. We add the row, the subtotal matches, and the full statement balances.

Without per-cardholder subtotals, we'd have been comparing 118 rows against the PDF. With them, we looked at about 60, and the page break pointed us at the exact line.

Building an expense report from the converted data

For businesses that reimburse or review employee card spending, the converted statement can double as the monthly expense report. Here's a layout that works well:

1. Data tab: every transaction, with Date, Cardholder, Merchant, Description, Amount, Category, Receipt (Y/N) and Business Purpose.
2. By person tab: a pivot with Cardholder in rows, Category in columns and the sum of Amount. Each manager sees their people's spending at a glance.
3. Missing receipts tab: a filtered view (or a FILTER formula, =FILTER(Data,Data[Receipt]="N")) listing what still needs documentation.
4. Exceptions tab: anything above a threshold, say charges over 500, and anything in categories that need approval, such as travel or entertainment.

Send each cardholder their filtered list early in the month and ask them to fill in the Business Purpose and confirm receipts. By the time the books close, the gaps are small.

Charge cards and the "paid in full" question

People sometimes ask us how to treat an Amex charge card in the books, since the balance is (usually) paid in full each month. In accounting software, set it up as a credit card account anyway. The charges are expenses when they happen, the card balance is a short-term liability, and the monthly payment from your bank is a transfer that clears the liability. This keeps expenses in the right month even when the payment happens in the next month.

If you instead record only the payment from the bank as one big expense, you lose all the detail, and your monthly expenses become lumpy. Converting the statement and importing the individual charges is what gives you accurate categories and accurate timing.

When the statement and the export disagree

Occasionally, an activity download and the PDF statement for the same period don't match perfectly. Common reasons:

• The download was taken by date range, not statement period, so it includes a day or two from the adjacent cycle.
• Pending charges were included in the download.
• A charge posted with a different amount than when it was pending, for example a restaurant tip or a hotel deposit.
• A dispute or adjustment was applied after the download.

The statement is the official record for the period. When in doubt, reconcile to the statement.

Common Amex conversion problems

Totals off by one cardholder's subtotal. A cardholder section was skipped, often because it started at the bottom of a page. Find the block and add it.

Duplicate lines for foreign charges. The foreign currency amount was read as a separate transaction. Delete the row with the foreign amount; keep the US dollar line.

Payments missing. Payments sometimes appear in a separate section near the summary rather than among charges. Make sure they're in the sheet with the correct sign.

Plan It or pay-over-time items. Some Amex accounts let you split purchases into installment plans, which appear as plan balances and monthly plan fees. These need careful handling in bookkeeping; the original purchase is still the expense, and the plan fee is a financing cost. Check with your accountant how they want them recorded.

Credits from offers. Statement credits from merchant offers or card benefits appear as credits. Keep them; they offset expenses.

Working with many months

If you're catching up on a year of Amex statements:

1. Convert in date order.
2. Confirm each statement balances.
3. Confirm each previous balance equals the prior statement's new balance.
4. Combine into one table with Statement, Cardholder and Category columns.
5. Build a pivot by month, cardholder and category.

With a business card, the pivot alone often answers questions people have been asking for months: who's spending what, on which vendors, and how it's trending. We go deeper on the process in catching up on months of statements.

Security

Amex statements reveal your spending patterns, the names of your employees, and your account number. Use a converter that encrypts uploads and deletes files after processing. Our security page describes what we do. Delete local copies you no longer need, and don't leave converted spreadsheets in open shared links.

Our take

For current months, the Amex download is excellent, especially with the card member column for business accounts. For history, convert the PDF, and use the summary totals to prove the conversion is complete. The extra two minutes of checking are what make the spreadsheet trustworthy enough to base expense reports, reimbursements and tax numbers on.

The free plan covers 3 pages a month, which is enough to test a short statement before committing.

Troubleshooting Amex conversions

Totals don't match the statement's new balance. Check that fees, interest and credits are included, and that payments are excluded from your spending total but included in the balance check.

Additional cardholders' charges are grouped. Add a Cardholder column so you can total by person, especially for expense reports.

Foreign currency charges. Use the amount in your billing currency. Keep the foreign amount in a notes column if needed.

Statement credits from offers. These reduce the balance. Tag them with the related purchase's category or as "Credits", so they don't look like payments.

Pay Over Time or plan balances. If parts of the balance are on a payment plan, they may appear in separate sections. Make sure your spreadsheet captures all sections when you check the totals.

A second worked example: a monthly expense report

A consultant uses an Amex card for client travel. Each month, she converts the statement, filters by the client project dates, tags each charge with a client code, and attaches receipts. A PivotTable by client gives the totals for her invoices. Charges without receipts are highlighted for follow-up before month-end, not at year-end.

Mini checklist

1. All sections of the statement included.
2. Payments and credits handled separately from spending.
3. Cardholders and clients tagged where needed.
4. Totals checked against the new balance.
5. Receipts matched to charges.

FAQ

Can I download Amex statements as Excel files?

American Express offers downloads of card activity in formats including CSV and Excel for recent periods. Older periods are available as PDF statements, which you can convert to Excel.

How do I convert an Amex PDF statement with multiple cardholders?

Use a converter that carries the cardholder name onto each transaction row, then check each cardholder's subtotal against the statement. If a subtotal is off, that section is where the problem is.

Why does my converted Amex statement show extra foreign charges?

Some statements print the foreign currency amount on a separate line. If a tool reads it as its own transaction, delete that row and keep the US dollar amount you were billed.

How do I verify an Amex statement conversion?

Take the previous balance, add new charges, fees and interest, subtract payments and credits, and confirm the result equals the new balance on the statement.

Can I import Amex statements into QuickBooks?

Yes. Use a bank feed for current activity, and for historical months import a QBO file or CSV into the card's credit card account. Check a few transactions afterward to confirm the signs are right.

What about Amex savings or checking statements?

They convert like any bank statement. Verify that the beginning balance plus deposits minus withdrawals equals the ending balance.