Workflow · Reconcile · Opening soon
Match Etsy payouts to QuickBooks
Compare your Etsy payout export with your QuickBooks deposit export in one table. See which deposits agree and which ones need a check.
Someone typed
“match etsy payouts from the payment account to our quickbooks deposits and show every deposit with a Status that says "Agrees" when it matches, else a short reason for what’s off”
The agent read it as
match Etsy payouts from the payment account to our QuickBooks deposits and show every deposit with a Status that says "Agrees" when it matches, else a short reason for what's off
What the agent built
4 steps, each one an ordinary Mammoth step you can open and change.
File
QuickBooks deposits
CSV export · 14 rows
File
Etsy payouts
CSV export · 14 rows
Step
Keep deposit rows
Step 1
Step
Keep paid payouts
Step 2
Join
Bring over payout amounts
14 of 14 paired
Step
Set status
Step 4
Result
Etsy deposit matches
14 rows · 1 flagged
Schedule
Runs when you say
Proposed
- FileQuickBooks depositsCSV export · 14 rows
- FileEtsy payoutsCSV export · 14 rows
- StepKeep deposit rowsStep 1
- StepKeep paid payoutsStep 2
- JoinBring over payout amounts14 of 14 paired
- StepSet statusStep 4
- ResultEtsy deposit matches14 rows · 1 flagged
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 14 rows came out, and the join paired 14 of 14 rows.
- Download QuickBooks deposits sample (14 rows)QuickBooks Online: Reports > Deposit Detail > Export to Excel
- Download Etsy payouts sample (14 rows)Etsy: Finances > Payment account > Payouts > Download CSV
What you get back
The result of that run, the rows to look at first.
Etsy deposit matchesSample data14 rows
13 agrees1 amount off
| Deposit date | Deposit memo | Deposit amount | Etsy deposit date | Etsy payout amount | Status |
|---|---|---|---|---|---|
| 2026-10-24 | Etsy payout dp_20261024_01 | 1,475 | 2026-10-24 | 1,490 | Amount off |
| 2026-09-04 | Etsy payout dp_20260904_01 | 840 | 2026-09-04 | 840 | Agrees |
| 2026-09-11 | Etsy payout dp_20260911_01 | 1,125.50 | 2026-09-11 | 1,125.50 | Agrees |
| 2026-09-18 | Etsy payout dp_20260918_01 | 760 | 2026-09-18 | 760 | Agrees |
| 2026-09-25 | Etsy payout dp_20260925_01 | 1,480.25 | 2026-09-25 | 1,480.25 | Agrees |
| 2026-10-02 | Etsy payout dp_20261002_01 | 930 | 2026-10-02 | 930 | Agrees |
| 2026-10-09 | Etsy payout dp_20261009_01 | 1,675.75 | 2026-10-09 | 1,675.75 | Agrees |
| 2026-10-16 | Etsy payout dp_20261016_01 | 1,240 | 2026-10-16 | 1,240 | Agrees |
| 2026-10-17 | Etsy payout dp_20261017_01 | 560 | 2026-10-17 | 560 | Agrees |
| 2026-10-22 | Etsy payout dp_20261022_01 | 995 | 2026-10-22 | 995 | Agrees |
| 2026-10-26 | Etsy payout dp_20261026_01 | 1,210 | 2026-10-26 | 1,210 | Agrees |
| 2026-10-27 | Etsy payout dp_20261027_01 | 960 | 2026-10-27 | 960 | Agrees |
How do you reconcile Etsy payouts in QuickBooks?
Export your Etsy payouts and your QuickBooks deposits, then load both files into the workflow. It keeps the deposit rows, keeps paid payouts, brings over payout amounts, and sets a Status for each match. Rows that match show Agrees, and rows that do not match show a short reason.
How it works
How to use the Etsy deposit matches 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.
Etsy deposit matches: questions
Which export should you use from Etsy and QuickBooks?
Use the payout or deposits export from Etsy and the deposits export from QuickBooks. The workflow reads the exported files, so you do not need to copy rows by hand.
What happens to rows that do not match?
They stay in the result and get a Status that explains the difference in short words, such as Amount off or Missing match. You can review those rows and decide what to fix.
How do you change the matching rules?
Edit the rule steps in words, for example keep different rows, match on a different field, or compare a different amount. Then run the workflow again with the same kind of exported files.
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 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 Square deposits to QuickBooksMatch Square transfers to QuickBooks deposits and flag anything off by amount or missing.See the workflow Built by the agent
- Match Stripe payouts to Xero bank depositsMatch Stripe payouts to Xero bank deposits by amount and date, and flag payouts that never landed in the bank feed.See the workflow Built by the agent