Workflow · Reconcile · Opening soon
Match Stripe payouts to Xero bank deposits
Match Stripe payouts to Xero bank deposits by amount and date. See which payouts agree, and which ones do not.
Someone typed
“show every stripe payout matched to our xero bank deposits by amount and date, with Status saying "Agrees" when it lines up and a short reason when it doesn’t”
The agent read it as
show every Stripe payouts matched to our Xero bank deposits by amount and date, with Status saying "Agrees" when it lines up and a short reason when it doesn’t
What the agent built
2 steps, each one an ordinary Mammoth step you can open and change.
File
Stripe payouts
CSV export · 18 rows
File
Xero bank deposits
CSV export · 17 rows
Join
Link bank deposits
15 of 18 paired
Step
Set match status
Step 2
Result
Payout deposit match
19 rows · 3 flagged
Schedule
Runs when you say
Proposed
- FileStripe payoutsCSV export · 18 rows
- FileXero bank depositsCSV export · 17 rows
- JoinLink bank deposits15 of 18 paired
- StepSet match statusStep 2
- ResultPayout deposit match19 rows · 3 flagged
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 19 rows came out, and the join paired 15 of 18 rows.
- Download Stripe payouts sample (18 rows)Stripe: Balance > Payouts > Export
- Download Xero bank deposits sample (17 rows)Xero: Accounting > Bank accounts > Checking account > Account transactions > Export
What you get back
The result of that run, the rows to look at first.
Payout deposit matchSample data19 rows
16 agrees3 no matching deposit
| Payout id | Payout date | Payout amount | Deposit reference | Status |
|---|---|---|---|---|
| po_9f3a2c4u | 2026-10-20 | 996.35 | · | No matching deposit |
| po_9f3a2c7x | 2026-10-28 | 1,044.50 | · | No matching deposit |
| po_9f3a2c8y | 2026-10-29 | 912.14 | · | No matching deposit |
| po_9f3a2c1e | 2026-09-04 | 842.19 | DEP-7741 | Agrees |
| po_9f3a2c2f | 2026-09-08 | 615.40 | DEP-7742 | Agrees |
| po_9f3a2c3g | 2026-09-11 | 1,294.88 | DEP-7743 | Agrees |
| po_9f3a2c4h | 2026-09-16 | 720.10 | DEP-7744 | Agrees |
| po_9f3a2c5j | 2026-09-19 | 1,588.44 | DEP-7745 | Agrees |
| po_9f3a2c6k | 2026-09-23 | 934.27 | DEP-7746 | Agrees |
| po_9f3a2c7m | 2026-09-25 | 1,110.95 | DEP-7747 | Agrees |
| po_9f3a2c8n | 2026-09-30 | 675.22 | DEP-7748 | Agrees |
| po_9f3a2c9p | 2026-10-02 | 1,420.66 | DEP-7749 | Agrees |
How do you match Stripe payouts to Xero bank deposits?
Export your Stripe payouts and your Xero bank deposits, then load both files into the workflow. It matches rows by amount and date, then sets Status to Agrees when they line up and adds a short reason when they do not.
How it works
How to use the Payout deposit 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.
Payout deposit match: questions
What export should you use from Stripe and Xero?
Use a Stripe export with payouts, and a Xero export with bank deposits for the same period. The two files should include the payout amount and date, so the workflow can compare them.
What happens to payouts that do not match a deposit?
They stay in the output with a status that shows they did not match. The workflow also adds a short reason, so you can see whether the amount, date, or both did not line up.
How do you change the matching rules in words?
You rewrite the rule in plain language, for example, match by amount and date, or match by amount only. You can also change what status to set when rows match or do not match.
Get early access to this workflow
It will open already built and checked on the sample files. Swap in your own exports and see your result.
Workflows like this
Match two sets of records line by line, and see what agrees, what differs and what is missing on either side.
- Match Stripe payouts to QuickBooks depositsMatch Stripe payouts to QuickBooks deposits each Monday and flag anything missing, short, duplicate, or extra.See the workflow Built by the agent
- Match PayPal transfers to QuickBooksMatch PayPal transfers to QuickBooks deposits, and flag transfers that do not line up by date or amount.See the workflow Built by the agent
- Match Amazon settlements to QuickBooksMatch Amazon settlements to QuickBooks deposits, break out fees, refunds, and reserve holds, and flag missing, short, or duplicate payouts.See the workflow Built by the agent
- Match Etsy payouts to QuickBooksMatch Etsy payout exports to QuickBooks deposits, then mark each row as Agrees or show what is off.See the workflow Built by the agent
- Match Shopify payouts to XeroMatch Shopify payouts to Xero bank lines by date and amount, then flag mismatches and missing rows.See the workflow Built by the agent
- Match WooCommerce orders to Stripe chargesCheck WooCommerce orders against Stripe charges by amount, with status notes for matches, differences, and missing charges.See the workflow Built by the agent