American Express (Amex) Statement to Excel Converter

Merchant reports let you choose the date basis — settlement date, transaction date or Amex date — along with format (CSV or XLS), locations, grouping and detail level.

That choice decides which month a sale falls in. When you reconcile, use the same basis as your books; the converted statement keeps each row's printed date so you can see which one you're working with.

In the savings account, the Documents tab lists statements, tax documents and notices, filtered by year, account and document type. Clicking a month's row opens its documents.

Filter by Statements and year, download the twelve PDFs, and upload them together for one proved workbook of the year.

American Express business cards — and the employee cards issued on them — produce statements with charges, payments and credits against a previous and new balance.

FlowParse checks each statement's summary and that the extracted charges add up to it, then gives each charge a category you can adjust before exporting to QuickBooks.

Whatever the statement type, each line becomes a row with its date, the description as printed and a signed amount: charges and withdrawals one way, payments, settlements and deposits the other.

Descriptions keep merchant names, merchant numbers and references, so matching to receipts, invoices and deposits still works after import.

For savings statements, the beginning balance plus every transaction must equal the ending balance. For card statements, the summary — previous balance, charges, fees, interest, payments and credits, new balance — must close and match the extracted lines.

If anything was missed, the preview shows the difference before export.

A merchant's bank statement shows Amex settlements as single deposits; the merchant statement shows what made them up. Reconciling the two is a monthly chore.

Upload both and Smart Merge lines them up by date, so each bank deposit can be matched to its settlement and the difference explained by fees and adjustments.

Smart Merge takes up to 100 PDFs and lays them out in date order with the file name on every row. Card statements chain from one new balance to the next previous balance; savings statements from one ending balance to the next beginning.

A missing month breaks the chain at exactly that point.

A restaurant in Chicago accepts American Express and wants to know what Amex actually cost last year. The owner has the bank statements and the merchant E-Statements. The figures here are an illustration.

She downloads twelve monthly E-Statements as PDF and uploads them with the bank statements. FlowParse returns one workbook; settlements pair with bank deposits and the year's fees and chargebacks total in two filters.

Check coverage: every month or cycle for each statement type. Check archives: @ Work downloads saved within fifteen days. Check reconciliation: each statement checked against its own totals.

Keep the PDFs. The spreadsheet is a working copy.

High Yield Savings interest is reported on a 1099-INT, available in the Documents tab under Tax Documents. The monthly statements show the interest month by month.

Converted and merged, interest lines total for the year — a quick check against the form.

Corporate card statements are where expense policy meets reality: every charge an employee made in the cycle.

Converted, charges sort by merchant and category, so out-of-policy spend and missing receipts stand out before the expense reports are approved.

Savings statements mailed on paper, or card statements printed for an audit, can be scanned flat, one per file. FlowParse reads them through OCR and checks each against its printed totals.

A misread digit shows up as a total that doesn't close.

@ Work offers CSV and merchant reports offer CSV or XLS. If they cover what you need, use them.

FlowParse earns its place with the PDF — when the statement itself must tie out, when the period is archived, or when you need a QBO file with the totals already checked.

The QBO file imports into QuickBooks; the CSV carries the same columns for Xero or a spreadsheet.

Each statement was checked against American Express's own totals first, so a difference in your reconciliation points at the bookkeeping, not the conversion.

American Express notes that for newly enrolled merchant users, payments data becomes available within four hours, while E-Statements start from the month after enrolment. A business that just started accepting the Card may find no statement for its first weeks.

Use the payments reports for that first month and the E-Statements from then on. Both convert, and the chain of monthly statements takes over once the first full month is issued.

Some businesses hold an American Express card for spending and park cash in American Express savings. The savings statement shows transfers in and out; the card statement shows the payments that cleared the balance.

Merged, transfers from savings to pay the card pair up across the two documents, so the business sees its real spending once and its cash reserve separately.

Auditors typically ask for a full fiscal year of card statements. On @ Work, twelve archives can be requested at once and kept for fifteen days.

Request them as soon as the audit is scheduled, download them the day they're ready, and convert them in one batch — the auditor gets the PDFs and a reconciled sheet together.

A corporate program can include dozens or hundreds of cards, each producing activity in the cycle. The statements tab on @ Work is where administrators collect them.

Converting them together turns a stack of PDFs into one list the finance team can sort by merchant, category and date — the starting point for policy reviews and accruals.

Corporate, merchant and savings statements from American Express each come from a different portal. FlowParse turns their PDFs into rows checked against each statement's own totals, ready for QuickBooks, Xero or NetSuite.