Reconcile Marketplace Seller Payouts Automatically
Pay sellers correctly — reconcile each period's marketplace sales, fees and refunds per seller and generate accurate payout statements.
- 1
Schedule the Payout Run
Add a
Schedule Triggeraligned to your payout cycle. - 2
Gather Transactions
Add a
Stripenode pulling the period's sales, fees and refunds tagged by seller. - 3
Compute Per-Seller Payouts
Add a
Codenode netting sales minus fees and refunds for each seller. - 4
Generate Statements
Add
Google SheetsandGmailnodes creating and emailing each seller their itemized statement. - 5
Activate and Test
Activate the workflow and run it for a test period. Confirm payouts and statements reconcile.
Frequently asked questions
How are sellers mapped to transactions?
Tag each transaction with the seller ID at checkout so reconciliation groups them correctly.
Can I trigger the actual payout?
Yes — use Stripe Connect transfers to pay verified sellers automatically after the statement is approved.
Log Stripe Payments from Zapier into a Google Sheets Accounting Ledger
An n8n workflow that receives successful Stripe charges relayed by Zapier, calculates fees and net amount, and appends a clean bookkeeping row to a Google Sheets ledger — giving small businesses a real-time revenue log without paying for accounting software.
Free recipeGenerate a Weekly Cohort Retention Report Automatically
Know if customers are sticking — build a weekly cohort retention report from your usage data and deliver it to the team without touching a spreadsheet formula.
Free recipeGet Alerted the Moment a Supplier Changes Their Prices
An n8n workflow that periodically fetches your suppliers' price lists, compares them to the last known prices, and alerts you to any increases or drops with the exact delta — so cost creep never silently erodes your margins and you can renegotiate or re-price in time.