Statement converter
American Express statement to Excel
An Amex statement is previous balance, payments and credits, new charges, and a new balance. Annual fees, airline charges, and credits all have to be in the sum. Leaving a fee out is exactly the kind of miss the balance check is there to catch.
Download it from American Express
In the Amex account, open Statements & Activity and download the PDF for the period. The statement period is often written with the word to, as in May 1, 2025 to May 31, 2025. Payments and Credits is a section of amounts that reduce the balance. New Charges increase it.
The check
Previous balance plus charges minus payments has to equal the new balance. In the spreadsheet that is opening plus the signed amount column. A reconciled badge means those numbers agree to the cent. An out-of-balance badge shows the difference, so you can find the missing row or the misread amount and edit it.
The QBO export treats the account as a credit card. Charges become negative OFX amounts, which is what QuickBooks expects when it imports card activity.
Questions
Are you affiliated with American Express?
No. Northline is an independent converter. American Express is a trademark of its owner. We are not endorsed by them.
Northline is not affiliated with the bank named on this page. This is not tax or financial advice. Compare the export to the original statement. Read the disclaimer.