Workflow · Reconcile · Opening soon

Match an Amex statement to QuickBooks

Export your Amex statement and your QuickBooks credit card charges, then match them line by line. You get a status for every line, so you can see what agrees, what is missing, and what was entered twice.

Book a demo

Someone typed

“match the amex statement to quickbooks credit card charges by date, payee, and amount, and show every line with a status: Agrees for matched ones, Not entered for missing ones, Duplicate for charges entered twice”

The agent read it as

match the Amex statement lines to QuickBooks credit card charges by date, payee, and amount, and show every line with a status: Agrees for matched ones, Not entered for missing ones, Duplicate for charges entered twice

What the agent built

4 steps, each one an ordinary Mammoth step you can open and change.

File

Amex statement lines

CSV export · 14 rows

File

QuickBooks credit card charges

CSV export · 13 rows

Step

Group matching charges

Step 1

Step

Extract payee

Step 2

Join

Join charge counts

10 of 14 paired

Step

Add status

Step 4

Result

Amex card match

14 rows · 5 flagged

Schedule

Runs when you say

Proposed

File
Amex statement lines
CSV export · 14 rows
File
QuickBooks credit card charges
CSV export · 13 rows
Step
Extract payee
Step 2
Step
Group matching charges
Step 1
Join
Join charge counts
10 of 14 paired
Step
Add status
Step 4
Result
Amex card match
14 rows · 5 flagged
Schedule
Runs when you say
Proposed

Checked on the sample files: every step ran, 14 rows came out, and the join paired 10 of 14 rows.

Download Amex statement lines sample (14 rows)Amex: Statements > Select statement period > Download CSV
Download QuickBooks credit card charges sample (13 rows)QuickBooks: Banking > Credit card transactions > Filter card > Export to CSV

What you get back

The result of that run, the rows to look at first.

Amex card matchSample data14 rows

9 agrees1 duplicate4 not entered

Date	Description	Reference	Amount	Status
2026-09-12	City Transit Monthly Pass	AMX-483018	92	Not entered
2026-09-29	Pixel Ads Platform	AMX-483401	315	Not entered
2026-10-16	Northside Catering	AMX-483865	412	Not entered
2026-10-24	Lumen Cloud Services	AMX-484061	225	Not entered
2026-10-08	Jetstream Air	AMX-483688	680	Duplicate
2026-09-05	Harbor Fuel - Interstate 8	AMX-482901	84.60	Agrees
2026-09-09	Papertrail Supply	AMX-482944	126.75	Agrees
2026-09-18	Bluebird Coffee Roasters	AMX-483104	24.80	Agrees
2026-09-23	Summit Hotel - Denver	AMX-483267	428.19	Agrees
2026-10-03	Greenleaf Market	AMX-483512	58.44	Agrees
2026-10-13	QuickFix Hardware	AMX-483799	147.32	Agrees
2026-10-19	Metro Parking	AMX-483921	38	Agrees

14 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How do you reconcile an Amex statement with QuickBooks?

Export the Amex statement and the QuickBooks credit card charges, then load both files into the workflow. It matches rows by date, payee, and amount, and flags each line as Agrees, Not entered, or Duplicate.

How it works

How to use the Amex card match workflow

1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Amex card match: questions

Which export should you use from Amex and QuickBooks?

Use the statement export from Amex and the credit card charges export from QuickBooks. The workflow reads the exported rows and compares the fields in them.

What happens to rows that do not match?

Rows that do not find a matching charge in QuickBooks are marked Not entered. Rows that appear more than once in QuickBooks are marked Duplicate.

How do you change the matching rules?

You change the rules by editing the words that define the match, such as date, payee, and amount. You can also change what status labels are used for matched, missing, or duplicate rows.