Skip to content
Workflow · Match two lists · Opening soon

Stripe monthly revenue summary from balance transactions

Export your Stripe balance transactions and Stripe payouts, then upload them to Mammoth. It groups rows by month and currency, calculates gross charges, refunds, disputes, Stripe fees, and net, then compares net with payouts for each month.

Early access opens shortly. Check back soon.

Someone typed

“show each month and currency from the stripe balance transactions and payouts, net, payouts, and open disputes; status Agrees when payouts match net within 100, Not paid out when there are no payouts, Net differs otherwise, plus one row for each open dispute”

The agent read it as

Show each month and currency from the Stripe balance transactions and Stripe payouts, net, payouts, and open disputes; status Agrees when payouts match net within 100, Not paid out when there are no payouts, Net differs otherwise, plus one row for each open dispute.

What the agent built

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

  1. File
    Stripe balance transactions
    CSV export · 25 rows
  2. File
    Stripe payouts
    CSV export · 11 rows
  3. Step
    Make monthly net and dispute rows
    Step 1
  4. Step
    Total payouts by month
    Step 2
  5. Join
    Bring in monthly payouts
    5 of 7 paired
  6. Step
    Set payout status
    Step 4
  7. Result
    Stripe monthly reconciliation
    7 rows · 7 flagged
  8. Schedule
    Runs when you say
    Proposed

On the sample files, every step runs and the result has 7 rows.

What you get back

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

Stripe monthly reconciliationSample data7 rows
3 net differs3 open dispute1 not paid out
MonthCurrencyStatusNetPayoutsOpen dispute amount
2026-10-01eurNot paid out3,6940·
2026-08-01usdNet differs11,03010,000·
2026-09-01usdNet differs11,8699,600·
2026-10-01usdNet differs11,14013,300·
2026-09-01usdOpen dispute··-350
2026-10-01eurOpen dispute··-180
2026-10-01usdOpen dispute··-275
7 rows in the result. Sample data: illustrative figures, not business results.

How it works

How to use the Stripe monthly reconciliation workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and working on sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Stripe monthly reconciliation: questions

How do you summarize Stripe balance transactions by month?
Export your Stripe balance transactions and Stripe payouts, then upload them to Mammoth. It groups rows by month and currency, calculates gross charges, refunds, disputes, Stripe fees, and net, then compares net with payouts for each month.
Which Stripe export should you use?
Use the Stripe balance transactions export for charges, refunds, disputes, fees, and net. Use the Stripe payouts export for payout amounts by month.
What happens if a month or currency does not match?
Rows still appear in the summary. If payouts match net within 100, the row is marked Agrees. If there are no payouts, it is marked Not paid out. Otherwise it is marked Net differs.
How do you change the rules?
You change the words that define how rows are grouped and compared. For example, you can change the month rule, the currency rule, the matching threshold, or which rows count as open disputes.

Get early access to this workflow

It opens already built and working on sample files. Swap in your own exports to see your result.

Early access opens shortly. Check back soon.