Format American Express CSV for QuickBooks

If you are trying to import a American Express statement into QuickBooks Online, you know it usually fails. The reason is simple: Amex uses a reversed sign convention where charges are positive and payments are negative, causing QuickBooks to record every purchase as income if imported without correction. This tool flips the Amex sign convention automatically so charges import as debits and payments import as credits in QuickBooks.

LedgerMatch works with Google Sheets™ for spreadsheet-based bank reconciliation. Send your bank and ledger data from a spreadsheet, match transactions, and review exceptions without connecting your bank account.

Read the American Express CSV CSV format guide

Add to Chrome — it’s free · Included with all plans Install Google Sheets™ add-on Install for Microsoft Edge