Summarize payouts by month
summarize_payoutsUse this when the user attaches or pastes a Stripe, PayPal, Shopify Payments, Etsy, Gumroad or Square transaction, balance or payout export and wants a Stripe monthly report, PayPal transaction history to Excel, a monthly income summary for bookkeeping or taxes, or what their 1099-K should show. Detects the export type from the headers and returns, per month and per currency: gross sales, refunds, chargebacks, fees, other adjustments, net and payouts, added in the smallest currency unit; a check of the totals against the export's Net column with any residual; a 1099-K view (gross payments per platform per year); an Excel workbook (Months, cleaned Transactions, 1099-K view) and a PDF summary. Several exports can be combined. Does not connect to accounts, read PDF statements or screenshots, convert currencies, or give tax advice.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file | No | The payout or transaction export the user attached, CSV or Excel (.xlsx): Stripe balance history, PayPal activity download, Shopify payouts, Etsy monthly statement, Gumroad sales or Square transactions, e.g. stripe-balance-2025.csv. | |
| year | No | Optional: keep only this calendar year, e.g. 2025 (useful for a 1099-K check). Default: every date in the export. | |
| files | No | Optional: more exports to combine in one summary, e.g. a Stripe CSV and a PayPal CSV for the same year. Each currency and platform stays separate. | |
| currency | No | Optional: currency for an export with no currency column, e.g. USD (default) or EUR. Currencies in the file always win; nothing is converted. | |
| platform | No | Optional: the platform when the headers do not show it, e.g. Stripe, PayPal, Shopify, Etsy, Gumroad, Square. Default: detected from the headers. | |
| date_order | No | Optional: order of numeric dates like 03/04/2026: MDY (US, default) or DMY (day first). | |
| transactions | No | Pasted export rows when no file is attached: the CSV text including its header line, e.g. "Date,Type,Gross,Fee,Net,Currency\n01/05/2026,Express Checkout Payment,49.00,-2.20,46.80,USD", or a list of objects like [{"date":"2026-01-05","type":"charge","amount":49,"fee":1.72,"currency":"USD"}], or lines such as "Jan 2026 sales 1200 fees 35". |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| months | Yes | ||
| totals | Yes | ||
| sources | Yes | ||
| headline | Yes | ||
| warnings | Yes | ||
| downloads | No | ||
| currencies | Yes | ||
| form_1099k | Yes | ||
| form_1099k_note | Yes |