Amex Statement to QBO: Convert American Express PDF Statements for QuickBooks

American Express does hand you a QuickBooks download, but only for your recent activity and the past six billing statements. Everything older, and every closed card, exists as a PDF and nothing else. Upload that PDF here and get a real .QBO Web Connect file QuickBooks accepts. Start free, no credit card.

Free to try, no credit card
Reaches past the six-statement limit
QBO, QFX, OFX, CSV, and Excel output

Last updated July 2026

PDF, JPG, PNG, BMP, HEIC, TIFF, MT940

Upload your bank statement

Extract:
|
|

How do you convert an Amex statement to QBO?

Upload the American Express PDF statement to BankXLSX and choose QBO as the download format. Amex lets you download recent activity and the past six billing statements to Quicken, QuickBooks, or CSV, so anything inside that window you can pull natively. The reason people convert is everything outside it: a year-end cleanup, an audit, a closed card, or a bookkeeper who was handed the statement and has no Amex login. The converted file imports into a QuickBooks credit card account exactly like a bank download.

Where American Express Stops Short of QuickBooks

Amex is unusual in this lineup: its native QuickBooks download genuinely works. The catch is how little of your history it covers, and how much of the record lives outside that window.

The Download Stops at Six Billing Statements

American Express states it plainly: you can download your recent activity and the past six billing statements to Quicken, QuickBooks, or as a CSV file. Six statements is roughly six months. A tax year is twelve, and a cleanup is often longer.

The Statements Themselves Go Back Years

On business accounts, Amex says program administrators can download statements up to seven years in the past at no fee. So the record exists. It is just a PDF, and the QuickBooks download will not reach it.

QuickBooks Will Not Backfill Past 90 Days

This ceiling is Intuit's, not Amex's. A newly connected card feed typically brings in about the last 90 days, and older activity has to be added from a file you upload. Connect the feed in July and the first half of the year stays empty.

A Closed or Cancelled Card Has No Download at All

Cancel the card and the download menu goes with it. The statements you saved are the only surviving record, which is exactly when a bookkeeper needs them most.

Charges Import With the Wrong Sign

Amex writes its exports from its own point of view, so purchases come out positive. A QuickBooks credit card account reads a positive amount as a payment toward the balance, so an untouched file walks the card balance the wrong way.

Bookkeepers Rarely Get the Login

Clients forward the PDF. They do not hand over Amex credentials, and on a business account the program administrator may be the only person who can pull a download at all.

How BankXLSX Turns an Amex Statement Into a QBO File

Upload the official American Express statement and get back a valid Web Connect file, for any period Amex ever issued a statement for.

A Real Web Connect File

You get an actual .qbo file with the structure QuickBooks expects, the only format QuickBooks Desktop Web Connect will import.

No Six-Statement Limit

A statement PDF carries no download window with it. If Amex issued the statement, its transactions convert, whether that was last month or five years ago.

Charges Signed Correctly

Purchases, fees, and interest come out negative and payments and credits positive, so the card balance moves the right way on import.

Handles Employee Cards

Business accounts put supplementary cardholders on one statement. Each charge keeps its cardholder detail in the description so you can attribute spend.

Keeps Fees and Interest

Annual fees, late fees, interest by rate, and foreign transaction fees all sit on the PDF and all come across as their own lines.

Private by Default

256-bit encryption in transit, and you can delete your uploaded statements whenever you want.

Convert an Amex Statement to QBO in 3 Steps

No software to install and no credit card to start.

1

Download the Amex Statement

Sign in at americanexpress.com, open Statements & Activity, pick the billing period, and save the PDF. A statement a client forwarded works just as well. Drag it into the box above.

Tip: Business program administrators can reach statements going back years.

2

Choose QBO

Once the transactions are read, pick QBO as the download format. QFX, OFX, CSV, and Excel sit next to it.

Tip: Pick QFX if the target is Quicken.

3

Import into QuickBooks

QuickBooks Online: Transactions, Bank transactions, Upload from file. Desktop: File, Utilities, Import, Web Connect Files. Select the Amex credit card account, not a checking account.

Tip: One card per file.

Who Converts Amex Statements to QBO

American Express is the card US businesses put their spend on, so the people converting its statements are almost always doing accounting work: a bookkeeper catching up a year, a controller pulling an audit trail, or a business owner who cancelled a card and still has to close the books on it.

Bookkeepers and Accountants

You get the PDF, not the login. Convert whatever the client sends, for whatever period, without waiting on Amex access that may never arrive.

Small Businesses on Amex Business Cards

Business Platinum, Business Gold, Blue Business Plus. One statement, several employee cards, and a year of spend that has to land in QuickBooks correctly.

Catch-Up and Cleanup Work

Twelve or twenty-four months behind is normal. The native download gives you six statements, so the rest of the rebuild comes from converted PDFs.

QuickBooks Desktop Shops

Desktop imports Web Connect files and nothing else. A converted statement is a proper .qbo, so Pro, Premier, Enterprise, and Accountant editions all take it.

Common Search Terms

amex statement to qbo convert amex statement to quickbooks import amex transactions into quickbooks american express quickbooks amex statement converter amex pdf to qbo

Transaction Types We Handle

Card purchases
Payments and credits
Annual and late fees
Interest charges
Foreign transaction fees
Employee card spend
Statement credits
Pay Over Time activity

Does American Express connect to QuickBooks?

Yes. American Express connects to QuickBooks Online as a bank feed, and Amex also offers a direct download of your transactions into Quicken and QuickBooks from its website. If your card is open, your feed is healthy, and you only care about recent months, you do not need this page. What sends people here is the size of the window. Amex says you can download your recent activity and the past six billing statements to Quicken, QuickBooks, or as a CSV file. Six statements covers about half a tax year, and the feed will not reach back past roughly 90 days when you first connect it. Everything before that is a PDF sitting in your statement archive.

What each Amex path to QuickBooks actually reaches

PathFile or methodHistory reachWorks with QuickBooks Desktop?
Amex bank feed in QuickBooks OnlineLive connectionForward, and Intuit will not pull past 90 daysNo
Amex website downloadQuickBooks, Quicken, or CSVRecent activity plus the past six billing statementsOnly within that window
Amex statement archivePDFUp to seven years back for business program administratorsNo, a PDF is not importable
Converted statement PDFA real .QBO Web Connect fileEvery statement Amex issuedYes

Read it as a division of labor. The feed owns the current month. The Amex download owns the last six statements. Conversion owns the part neither of them will touch, which happens to be most of what a cleanup, a tax return, or an audit actually needs.

How far back can I get Amex statements?

Further than the download window, which is the whole point. On business accounts American Express says program administrators can download statements up to seven years in the past with no fee. On a personal card, the previous two years of transactions can be viewed electronically and sorted, filtered, and saved as PDF, Excel, or CSV. In both cases the statement archive outruns the QuickBooks download by years. That gap is why converting the PDF is not a workaround so much as the only route into QuickBooks for older periods.

Why do my Amex charges import as payments?

Because they came in positive. In a QuickBooks credit card account a charge has to be a negative number and a payment or refund has to be positive. Card issuers write exports from their own perspective and list purchases as positive amounts, so an untouched file posts every purchase as money paid toward the card, and the balance moves in the wrong direction. You can fix a spreadsheet with a helper column that multiplies the amount by negative one, or use the four column layout with separate Debit and Credit columns. A converted .qbo file arrives already signed correctly, so the question never comes up.

Employee cards and business accounts

An Amex Business account usually carries supplementary cards, and every one of them lands on the same statement. That is convenient for paying the bill and awkward for bookkeeping, because the spend has to be attributed before anyone can approve it. The statement identifies the cardholder against each charge, and the converted file keeps that detail in the description, so you can filter or class the rows by cardholder in QuickBooks rather than guessing from a merchant name. Annual fees, late fees, and interest each come across as their own lines rather than being folded into a total.

Is Amex a bank?

American Express is a bank as well as a card issuer. American Express National Bank is a Member FDIC institution, and it is what sits behind Amex Business Checking and the personal savings products. That matters here for one practical reason: a checking statement and a card statement are different account types in QuickBooks. Card statements go into a credit card account, and checking statements go into a bank account. Convert each to its own file and import each to its matching account, because QuickBooks maps one Web Connect file to one account.

Avoiding duplicate Amex transactions

Duplicates are the standard failure when a live feed and a converted file overlap. Open the register, find the oldest transaction the feed brought in, and end your converted file the day before it. Load history behind the feed, never on top of it. QuickBooks does try to catch duplicates on a Web Connect import, but it matches on amount, date, and reference, so a reworded description or a posting date that shifted by a day will slip through. If you are rebuilding a busy year, check how many transactions QuickBooks accepts at once before you start, because a QuickBooks Online upload caps at 1,000 lines.

Where else the converted statement goes

The same upload produces more than a QuickBooks file. Take XLSX or CSV instead with the American Express statement to Excel converter when you want to sort and total a year for a tax return. Other issuers follow the same route: Discover, which no longer offers any QuickBooks download at all, plus the full walkthrough for importing credit card transactions into QuickBooks and the bank statement to QBO converter for checking and savings. For the step-by-step version of this page, see how to import American Express transactions into QuickBooks, and if the 90-day wall is what sent you here, why QuickBooks only imports 90 days of transactions explains what each connection type reaches.

When the file you have is not a PDF

If you already pulled the Amex CSV and simply need it in Web Connect form, a dedicated CSV to QBO converter does that single job. When statements from several institutions are all heading into the same QuickBooks file, a purpose-built bank statement to QuickBooks converter runs the PDF to QBO workflow across all of them.

Why People Convert Amex Statements Instead of Retyping

6 statements
all the Amex QuickBooks download reaches
No login
a forwarded statement is enough
Under 1 min
to convert a typical statement

Security & Privacy

  • 256-bit encryption on every upload
  • Delete your files at any time
  • No reselling or sharing of your financial data
  • Runs in your browser, nothing to install

Amex Statement to QBO: Common Questions

Yes. Amex connects to QuickBooks Online as a bank feed, and its website also offers a direct download into QuickBooks and Quicken. The limit is reach: Amex says the download covers your recent activity and the past six billing statements, and a newly connected feed will not pull past roughly 90 days. Older periods have to come from a converted statement.

Six billing statements, plus recent activity. That is American Express's own stated limit for downloading to Quicken, QuickBooks, or CSV. Your statement archive goes back much further, up to seven years for business program administrators, but only as PDFs, which QuickBooks cannot import without conversion.

Only as a Web Connect .qbo file. QuickBooks Desktop has no native CSV import for card transactions and will not take a QIF for a credit card account. Convert the Amex statement PDF to a .qbo, then import it under File, Utilities, Import, Web Connect Files and point it at the Amex credit card account.

Because the amounts were positive. QuickBooks reads a positive number in a credit card account as money paid toward the balance, and Amex exports purchases as positive figures. Flip the sign, or use separate Debit and Credit columns. A converted .qbo file comes out signed correctly already.

Yes, and it is one of the most common reasons people convert. A cancelled card has no feed to connect and no download menu left, so the PDF statements you saved are the only record. Converting them is the only way that spend reaches QuickBooks.

The statement identifies the cardholder against each charge on a business account, and that detail carries into the description of the converted file. You can then filter, class, or tag the rows by cardholder in QuickBooks instead of guessing from merchant names.

Yes. American Express National Bank is a Member FDIC institution and sits behind Amex Business Checking and the personal savings accounts. Remember that a checking statement imports to a bank account in QuickBooks while a card statement imports to a credit card account, so convert and import them separately.

Related Resources

Other Bank Statement Converters

ICICI Bank JPMorgan Chase Bank of America Citigroup Wells Fargo Goldman Sachs Morgan Stanley U.S. Bancorp PNC Financial Services Truist Financial Capital One TD Bank Charles Schwab Fidelity Vanguard E*TRADE TD Ameritrade Bank of New York Mellon State Street BMO USA Ally Financial Regions Financial Fifth Third Bank Huntington Bancshares KeyBank Citizens Financial Group First Citizens BancShares Synchrony Financial M&T Bank First Horizon Cathay Bank USAA Navy Federal Comerica Zions Bancorporation East West Bancorp First National of Nebraska Cullen Frost Bankers BOK Financial Fulton Financial Associated Banc-Corp Valley National Bancorp Wintrust Financial First Midwest Bancorp Commerce Bancshares UMB Financial Pinnacle Financial Partners Webster Financial Cadence Bank Old National Bancorp First Interstate BancSystem Umpqua Holdings First Hawaiian Bank Prosperity Bancshares SouthState Corporation First Merchants First Bank Holding Glacier Bancorp First Financial Bancorp Independent Bank Columbia Banking System Western Alliance Bancorporation Pacific Premier Bancorp Bank OZK United Community Banks Customers Bancorp Texas Capital Bancshares SVB Financial Group Signature Bank First Republic Bank New York Community Bancorp Sterling Bancorp First Bank Bank United First Commonwealth Financial Flagstar Bank Synovus Bank Santander Bank Commonwealth Bank (CommBank) ANZ Bank Westpac NAB ServisFirst Bancshares Renasant Corporation Simmons First National Trustmark Corporation First Busey Community Bank System First Mid Bancshares Ameris Bancorp Hancock Whitney First BanCorp Third Coast Bancshares Home Bancshares Byline Bancorp Simmons Bank United Bankshares Peoples United Financial American Express HSBC Bank USA

Z tej samej rodziny narzędzi