How to Import American Express Statements into QuickBooks

Getting American Express transactions into QuickBooks is straightforward for recent activity - AmEx supports direct bank feeds and QBO file exports. The gap appears when you need historical data: older statement periods that the bank feed never captured. This guide covers every path, including how to handle AmEx PDFs from prior years when the live connection falls short.

American Express is better than most card issuers about giving you your own data - they export in QBO, OFX, CSV, and QFX formats. But like every bank, there's a date ceiling on what the live export covers. Below is the full map of options, so you can pick the right method for the period you need.

Option 1: QuickBooks bank feed (ongoing, automatic)

The cleanest long-term setup is a direct bank feed connection between QuickBooks and your AmEx account. Once connected, QuickBooks pulls in new AmEx transactions automatically on a daily basis, and you review and categorize them inside QuickBooks.

Setting up the AmEx bank feed in QuickBooks Online

• In QuickBooks Online, go to Transactions and click Connect account (or Add account).
• Search for American Express in the bank list.
• Enter your AmEx login credentials. QuickBooks connects via a read-only data link and downloads recent transactions.
• Match the AmEx card to the correct QuickBooks account (create a new liability account if it doesn't exist yet).
• QuickBooks will import recent transactions - typically 90 days - and continue pulling new ones going forward.

The limitation to understand: the bank feed only brings in transactions from the point the connection was established (plus a short historical window). It does not automatically import your statement history from prior years. For past periods, use one of the options below.

Option 2: AmEx QBO file export (QuickBooks Desktop)

If you use QuickBooks Desktop (Pro, Premier, or Enterprise), the most compatible format is the QBO (Web Connect) file that AmEx can export directly. This method works for recent activity within AmEx's export window.

How to export a QBO file from AmEx

• Sign in at americanexpress.com and open the card account.
• Go to Statements and Activity.
• Click the Download or Export button near the transaction list.
• Choose QuickBooks (.QBO) as the format.
• Set the date range and download the file.

Importing the QBO file into QuickBooks Desktop

• In QuickBooks Desktop, go to File and choose Utilities, then Import, then Web Connect Files.
• Browse to the downloaded QBO file and open it.
• QuickBooks will ask you to match it to an existing account or create a new one.
• The transactions are imported into the register, ready to categorize and match.

Option 3: CSV import into QuickBooks Online (manual)

QuickBooks Online can import transactions from a CSV file via the manual upload feature. This is useful when you have recent AmEx data in CSV format - either from AmEx's own CSV export or from a converted PDF.

• In QuickBooks Online, go to Transactions, open the bank account or card account you want to import into, and choose Upload from file.
• Select the CSV file.
• Map the columns (Date, Description, Amount) to the QuickBooks fields.
• QuickBooks imports the rows and adds them to the account register for review and categorization.

One important note: QuickBooks Online's CSV import checks for duplicates against existing transactions, but it's worth reviewing the import window carefully to avoid double-counting if you also have a bank feed active on the same account.

Option 4: Convert AmEx PDF statements for older periods

For statement periods outside AmEx's export window - prior tax years, quarters from before you set up the bank feed, or any period the live export doesn't reach - the official PDF statement is your source. American Express keeps multiple years of statements available under Statements and Activity on americanexpress.com.

Step 1: Download the statement PDF

• Sign in at americanexpress.com.
• Go to Statements and Activity and use the period dropdown to find the month you need.
• Download the PDF and save it to your computer.

Step 2: Convert the PDF to a QuickBooks-compatible format

A PDF statement needs to be extracted into rows of transactions before QuickBooks can use it. Copying and pasting from a PDF into a spreadsheet rarely produces clean results - the multi-column layout of an AmEx statement creates a scrambled paste.

A local PDF converter reads the statement structure and produces clean output: either a CSV for QuickBooks Online import or a QBO file for QuickBooks Desktop. The critical advantage of a local converter is that the PDF never has to leave your computer - no upload to a third-party server, no sharing of your AmEx credentials.

Quill handles American Express PDF statements for both personal and business cards. Drop in the PDF, review and adjust the auto-categorized transactions, and export directly to a QuickBooks-compatible format. Everything runs on your own machine - no AmEx login to share, no upload.

Business AmEx and QuickBooks: a few extra considerations

Business AmEx accounts (Business Platinum, Business Gold, Blue Business Plus, Business Prime) have some QuickBooks-specific wrinkles:

• Multiple employee cards. The primary statement consolidates all employee card spending. When you import into QuickBooks, you may want to split charges by employee or department. The easiest way is to add a "Card Member" column to the CSV before importing, then use QuickBooks classes or tags to track by employee.
• Statement credits and rewards. AmEx often applies credits (airline credits, dining credits, annual credits) as negative line items on the statement. These should be posted to an income or contra-expense account in QuickBooks, not treated as purchase reversals, to keep your books accurate.
• Currency. If you travel internationally and your AmEx statement includes foreign transactions, the statement shows both the foreign currency amount and the USD equivalent charged to the card. Import the USD column into QuickBooks to keep everything in your functional currency.

For the companion guide on exporting AmEx data in CSV format, see how to convert an American Express statement PDF to CSV. For a general reference on the PDF-to-QuickBooks workflow across banks, see how to export bank transactions to QuickBooks.