Stripe and Xero: Payout Settlement Export Template

A scheduled Spojit workflow breaks each Stripe payout into its charges and fees and posts the settlement as a journal entry in Xero, so your bank deposits match your books.

What It Builds

A Schedule trigger runs once a day and a Stripe Connector node pulls the latest payouts along with the charges and fees that make up each one. A Transform node groups those amounts into gross sales, processing fees, and the net deposit, then Spojit posts a balanced settlement journal into Xero through its API. Because Xero has no native tile, Miraxa connects to it using the http connector.

The Prompt

Paste this into Miraxa and it builds the workflow, connecting the tools for you:

Every morning at 7am, get yesterday's Stripe payouts and the charges and fees behind each one. Split each payout into gross sales, processing fees, and the net amount deposited, then post it as a balanced journal entry in Xero (connect to the Xero API) so the bank deposit reconciles against my books.

Connectors Used

Schedule trigger - runs the export on a daily cron in your timezone.
Stripe - reads payouts, charges, and fee details.
http - Miraxa connects to the Xero API to create the journal entry.

Customize It

Change the run time in the prompt, or swap the daily schedule for weekly to batch settlements. Adjust which Xero accounts receive sales, fees, and the clearing balance, and name your bank or clearing account so deposits land in the right ledger.

Tips

Give the Stripe connection read access to payouts and balance transactions so fees come through.
Keep the Stripe node in Direct mode for an exact, no-AI-cost pull; the journal math is deterministic in the Transform node.
Confirm each journal balances to zero before posting, so a mismatched fee never breaks the export.