A payout total that is not the sum of its lines: gross, fee and net in Excel™
A payout reaches the bank as one amount. Behind it are charges, fees, refunds and adjustments. If you add up the lines in the export and the answer is not the payout, something is missing from the lines you summed, or something belongs to a different payout.
Usual causes
- Fees missing from the lines, or already netted off so they never appear as a row.
- Refunds or adjustments in the platform report but not in the lines you summed.
- A payout whose lines straddle the export's date range, so some are in another export.
- Lines that belong to no payout, mixed in with lines that do.
- Net that is not gross minus fee, line by line.
Check by hand
These steps apply to Excel™ in Microsoft 365. Work on a copy. Assume Payout ID is in A, gross in D, fee in E and net in F.
- Check the arithmetic per line:
=ROUND(D2-E2-F2,2). Anything non-zero is a line where net is not gross minus fee. - Total per payout:
=SUMIFS(F:F,A:A,A2)for net, and similarly for gross and fee. - Compare each payout's net total with the bank deposit.
- Filter Payout ID for blanks, which are lines belonging to no payout.
- If the difference remains, check whether the export's date range cuts through a payout.
To put gross in, gross out, fee and net into separate columns, add columns with IF on the sign of the amount. Keep the originals untouched.
Split and check in the pane
Payout Export Cleaner checks that a payout total is the sum of charges, refunds, adjustments and fees (PO-01), that net is gross minus fee line by line (PO-02), missing or netted-off fees (PO-03), and lines that belong to no payout (PO-12). On Stripe's own "itemized" reports it can split each line into gross, fee and net across four new columns (PO-18), leaving your originals alone. The scan and explanations are free; the split is a paid fix. Shopify checks are warn-only because no real Shopify export has been confirmed yet.
See Payout Export Cleaner for Excel™
Microsoft, Excel and Microsoft 365 are trademarks of the Microsoft group of companies. Shopify is a trademark of Shopify Inc. and Stripe of Stripe, Inc. Payout Export Cleaner is an independent product, not affiliated with or endorsed by Microsoft or any payment platform it works with.