Workflow · Reconcile · Opening soon

Match Stripe payouts to QuickBooks deposits

Match last week’s Stripe payouts to QuickBooks deposits in one view. See which payouts agree and which ones need attention.

Book a demo

Someone typed

“every monday, match last week's stripe payouts to our quickbooks deposits and show each payout with a Status that says "Agrees" when the deposit matches the payout amount, else what's short, missing, duplicate, or extra.”

The agent read it as

every monday, match last week's Stripe payouts to our QuickBooks deposits and show each payout with a Status that says "Agrees" when the deposit matches the payout amount, else what's short, missing, duplicate, or extra.

What the agent built

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

File

Stripe payouts

CSV export · 14 rows

File

QuickBooks deposits

CSV export · 15 rows

Step

Group deposits by day

Step 1

Step

Keep last week's payouts

Step 2

Join

Bring in deposits

7 of 7 paired

Step

Set payout status

Step 4

Result

Stripe payout reconciliation

7 rows · 1 flagged

Schedule

Runs every monday

Proposed

File
Stripe payouts
CSV export · 14 rows
File
QuickBooks deposits
CSV export · 15 rows
Step
Keep last week's payouts
Step 2
Step
Group deposits by day
Step 1
Join
Bring in deposits
7 of 7 paired
Step
Set payout status
Step 4
Result
Stripe payout reconciliation
7 rows · 1 flagged
Schedule
Runs every monday
Proposed

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

Download Stripe payouts sample (14 rows)Stripe: Balance > Payouts > Export
Download QuickBooks deposits sample (15 rows)QuickBooks Online: Sales > Deposits > Export list

What you get back

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

Stripe payout reconciliationSample data7 rows

6 agrees1 duplicate, extra by 1265.8

Payout ID	Payout date	Payout amount	Deposit total	Deposit count	Status
po_01k8b7m7u4b5c6d7e8f9g0h1	2026-10-24	1,265.80	2,531.60	2	Duplicate, extra by 1265.8
po_01k8b7m8v5c6d7e8f9g0h1i2	2026-10-25	1,540.25	1,540.25	1	Agrees
po_01k8b7m3q9x1a2b3c4d5e6f7	2026-10-23	1,845.60	1,845.60	1	Agrees
po_01k8b7m4r1y2c3d4e5f6a7b8	2026-10-22	732.15	732.15	1	Agrees
po_01k8b7m5s2z3e4f5a6b7c8d9	2026-10-21	2,190.40	2,190.40	1	Agrees
po_01k8b7m6t3a4b5c6d7e8f9g0	2026-10-20	980	980	1	Agrees
po_01k8b7m9w6d7e8f9g0h1i2j3	2026-10-19	875.90	875.90	1	Agrees

7 rows in the result. Sample data: illustrative figures, not business results.

How do you match Stripe payouts to QuickBooks deposits?

Export last week’s Stripe payouts from Stripe and your deposits from QuickBooks, then upload both files. The workflow groups deposits by day, compares each payout to the deposits, and marks each one as Agrees when the amounts match. If they do not match, you see what is short, missing, duplicate, or extra.

How it works

How to use the Stripe payout reconciliation 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.

Stripe payout reconciliation: questions

What export should I use from Stripe and QuickBooks?

Use a payout export from Stripe and a deposits export from QuickBooks for the same date range. Keep the columns that show the payout date, deposit date, and amount so the workflow can compare them.

What happens to rows that do not match?

Rows that do not match are not hidden. They are shown with a status that explains the difference, such as short, missing, duplicate, or extra.

How do I change the matching rules?

You change the rules by editing the steps in the workflow. For example, you can change how deposits are grouped, which date range is kept, and what fields are used to compare amounts.