Payment processing fees by method
“show the stripe payments by month and method, total sales and fees, calculate fee rate as fee divided by amount, and status Agrees when fee rate is under 5%, otherwise High fee”
Show the Stripe payments export by month and method, total sales and fees, calculate fee rate as fee divided by amount, and status Agrees when fee rate is under 5%, otherwise High fee
What the agent built
1 step, each one an ordinary Mammoth step you can open and change.
- FileStripe payments exportCSV export · 20 rows
- StepTotal fees by month and methodStep 1
- ResultMonthly Stripe Fee Review12 rows · 2 flagged
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 12 rows came out.
- Download Stripe payments export sample (20 rows)Stripe: Payments > All payments > Export
What you get back
The result of that run, the rows to look at first.
| Month | Method | Currency | Sales (currency) | Fees (currency) | Fee rate | Status |
|---|---|---|---|---|---|---|
| 2026-10-01 | afterpay_clearpay | USD | 260 | 13 | 0.1 | High fee |
| 2026-11-01 | afterpay_clearpay | USD | 305 | 15.25 | 0.1 | High fee |
| 2026-09-01 | card | USD | 992.50 | 31.10 | 0 | Agrees |
| 2026-09-01 | klarna | USD | 180 | 8.10 | 0 | Agrees |
| 2026-09-01 | sepa_debit | EUR | 410 | 1.60 | 0 | Agrees |
| 2026-09-01 | us_bank_account | USD | 1,560 | 1.95 | 0 | Agrees |
| 2026-10-01 | card | USD | 2,069 | 64.50 | 0 | Agrees |
| 2026-10-01 | sepa_debit | EUR | 705 | 2.12 | 0 | Agrees |
| 2026-10-01 | us_bank_account | USD | 390 | 0.49 | 0 | Agrees |
| 2026-11-01 | card | USD | 516 | 16.16 | 0 | Agrees |
| 2026-11-01 | klarna | USD | 560 | 25.20 | 0 | Agrees |
| 2026-11-01 | us_bank_account | USD | 1,180 | 1.48 | 0 | Agrees |
How do you total payment processing fees by method each month?
Export your Stripe payments file, then group rows by month and payment method. Total sales and fees, calculate fee rate as fees divided by amount, and mark each group as Agrees when the rate is under 5 percent, otherwise High fee.
How it works
How to use the Monthly Stripe Fee Review 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.
Monthly Stripe Fee Review: questions
Which export should you use?
What happens to rows that do not match the rule?
How do you change the rules?
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.
- Bank reconciliationEvery line matched, flagged for a date check, or missing from one sideSee the workflow Template
- Payment reconciliationEach payout matched to its bank deposit, flagged for a date check, or missingSee the workflow Template
- Cash reconciliationEach day's takings matched to a bank deposit, or flagged as not bankedSee the workflow Template
- Three-way matchEach PO line: matched, partly received, billed more than received, or price differsSee the workflow Template
- Invoice reconciliationEach invoice paid in full, part-paid, overpaid or not paid, and payments with no invoiceSee the workflow Template
- Credit card reconciliationEach charge matched, missing from expenses, or booked but not on the statementSee the workflow Template