Workflow · Reconcile · Opening soon

Match Shopify payouts to QuickBooks deposits

Match your Shopify payouts to your QuickBooks deposits. See the net amount, the deposit amount, and the reason for any difference.

Book a demo

Someone typed

“match the shopify payouts to our quickbooks deposits, show net versus deposit amount and flag each payout as Agrees, Missing deposit, Short deposit, or Duplicate deposit”

The agent read it as

Match the Shopify payouts to our QuickBooks deposits, show net versus deposit amount and flag each payout as Agrees, Missing deposit, Short deposit, or Duplicate deposit, and flag deposits above the payout as Over deposit.

What the agent built

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

File

Shopify payouts

CSV export · 12 rows

File

QuickBooks deposits

CSV export · 14 rows

Step

Make payout key

Step 1

Step

Find deposits by payout ID

Step 2

Join

Bring in matching deposits

12 of 12 paired

Step

Flag payout deposits

Step 4

Result

Payout Deposit Flags

12 rows · 2 flagged

Schedule

Runs when you say

Proposed

File
Shopify payouts
CSV export · 12 rows
File
QuickBooks deposits
CSV export · 14 rows
Step
Make payout key
Step 1
Step
Find deposits by payout ID
Step 2
Join
Bring in matching deposits
12 of 12 paired
Step
Flag payout deposits
Step 4
Result
Payout Deposit Flags
12 rows · 2 flagged
Schedule
Runs when you say
Proposed

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

Download Shopify payouts sample (12 rows)Shopify admin: Finance > Payouts > Export
Download QuickBooks deposits sample (14 rows)QuickBooks Online: Banking > For review or Banking > Chart of accounts > View register > Export

What you get back

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

Payout Deposit FlagsSample data12 rows

10 agrees2 duplicate deposit

Payout ID	Status	Net	Deposit amount
po_1060	Duplicate deposit	6,969	6,969
po_1072	Duplicate deposit	5,579.69	11,159.38
po_1041	Agrees	4,518.60	4,518.60
po_1044	Agrees	5,111.69	5,111.69
po_1047	Agrees	4,414.07	4,414.07
po_1050	Agrees	5,680.69	5,680.69
po_1053	Agrees	5,346.31	5,346.31
po_1057	Agrees	4,655.66	4,655.66
po_1064	Agrees	3,785.38	3,785.38
po_1068	Agrees	6,061.45	6,061.45
po_1076	Agrees	4,966.21	4,966.21
po_1080	Agrees	4,274.06	4,274.06

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

How do you match Shopify payouts to QuickBooks deposits?

Export your Shopify payouts and your QuickBooks deposits, then load both files into the workflow. It makes a payout key, finds deposits by payout ID, brings in matching deposits, and flags each payout as Agrees, Missing deposit, Short deposit, or Duplicate deposit. It also flags deposits above the payout as Over deposit, so you can see fees and refunds that explain the difference.

How it works

How to use the Payout Deposit Flags 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 Flags: questions

Which exports should you use?

Use an export of Shopify payouts and an export of QuickBooks deposits. The workflow reads the exported rows and matches them by the payout key and payout ID.

What happens to rows that do not match?

Rows that do not match are still kept in the result, with a flag that shows why they did not match. For this workflow, that can be Missing deposit, Short deposit, Duplicate deposit, or Over deposit.

How do you change the matching rules?

You change the rules by editing the step text in words. You can change which fields make the payout key, how deposits are found, and which conditions create each flag.