Workflow · Reconcile · Opening soon

Match Shopify payouts to Xero

Match each Shopify payout to the Xero bank line it landed as. See which rows agree and which ones need a check.

Someone typed

“show every shopify payout with our xero bank lines by date and amount, and add a Status that says "Agrees" when it matches cleanly, else a short reason for what to check”

The agent read it as

show every Shopify payouts with our Xero bank lines by date and amount, and add a Status that says "Agrees" when it matches cleanly, else a short reason for what to check

What the agent built

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

File

Shopify payouts

CSV export · 14 rows

File

Xero bank lines

CSV export · 16 rows

Step

Keep Shopify payout lines

Step 1

Step

Prepare payout keys

Step 2

Join

Bring in bank lines

14 of 14 paired

Step

Set match status

Step 4

Result

Shopify payout reconciliation

15 rows · 1 flagged

Schedule

Runs when you say

Proposed

File
Shopify payouts
CSV export · 14 rows
File
Xero bank lines
CSV export · 16 rows
Step
Prepare payout keys
Step 2
Step
Keep Shopify payout lines
Step 1
Join
Bring in bank lines
14 of 14 paired
Step
Set match status
Step 4
Result
Shopify payout reconciliation
15 rows · 1 flagged
Schedule
Runs when you say
Proposed

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

Download Shopify payouts sample (14 rows)Shopify admin: Finance > Payouts > Export
Download Xero bank lines sample (16 rows)Xero: Accounting > Bank accounts > Reconcile > Export statement lines

What you get back

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

Shopify payout reconciliationSample data15 rows

14 agrees1 amount differs

Payout ID	Payout date	Payout amount	Bank date	Bank amount	Status
po_7f3a4p	2026-10-27	667.64	2026-10-27	652.64	Amount differs
po_7f3a1c	2026-09-08	790.83	2026-09-08	790.83	Agrees
po_7f3a2d	2026-09-12	1,205.65	2026-09-12	1,205.65	Agrees
po_7f3a3e	2026-09-18	966.05	2026-09-18	966.05	Agrees
po_7f3a4f	2026-09-25	1,422.88	2026-09-25	1,422.88	Agrees
po_7f3a5g	2026-10-01	1,064.53	2026-10-01	1,064.53	Agrees
po_7f3a6h	2026-10-03	760.33	2026-10-03	760.33	Agrees
po_7f3a7i	2026-10-07	1,629.17	2026-10-07	1,629.17	Agrees
po_7f3a8j	2026-10-10	860.05	2026-10-10	860.05	Agrees
po_7f3a9k	2026-10-14	1,330.37	2026-10-14	1,330.37	Agrees
po_7f3a0l	2026-10-17	1,171.01	2026-10-17	1,171.01	Agrees
po_7f3a1m	2026-10-21	1,724.65	2026-10-21	1,724.65	Agrees

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

How do you match Shopify payouts to Xero bank lines?

Export your Shopify payouts and your Xero bank lines, then load both files into the workflow. It keeps the payout rows, prepares a match key from date and amount, and compares them to the bank lines. Each row gets a Status, with Agrees for a clean match and a short reason when it does not.

How it works

How to use the Shopify 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.

Shopify payout reconciliation: questions

Which export should you use from Shopify and Xero?

Use the payout export from Shopify and the bank line export from Xero. The workflow reads the rows from those exported files and compares the fields it needs.

What happens to rows that do not match?

Rows that do not match stay in the result. They get a status that explains the issue in a short way, such as an amount difference or a missing match.

How do you change the matching rules?

Edit the steps in words, for example which rows to keep, which fields to use as the match key, and what status text to set. Then rerun the workflow with the same exported files or new ones.