Refunds and disputes with the wrong sign in a payout export, checked in Excel™
A payout export lists charges, refunds, disputes, fees and adjustments. A refund should reduce the payout. If one is recorded with the wrong sign, or a transaction appears twice, the lines no longer add up to the payout, and the gap is hard to find by eye.
What to look for
- Refunds and disputes with a positive amount, where the rest of the file shows money out as negative.
- The same transaction twice, from overlapping exports or a repeated row.
- Transaction types you do not recognise, which may carry their own sign.
Check by hand
These steps apply to Excel™ in Microsoft 365. Work on a copy. Assume the type is in column C and the amount in D.
- Filter the type column for refunds and disputes (the labels depend on the platform's report). Read the amount column for those rows. Mixed signs deserve a look.
- Add
=SUMIFS(D:D,C:C,"refund")for each type to see subtotals by type. Adapt the label to match your file. - Find repeated transactions with a key:
=A2&"|"&B2&"|"&D2(an ID, a date and an amount), then=COUNTIF(E:E,E2). Filter for counts above 1. - Check whether the payout total equals the sum of the lines after fixing signs and removing true repeats.
Remove a repeat only when the transaction ID matches. Two similar charges on the same day can be genuine.
Flag them in the scan
Payout Export Cleaner flags refunds and disputes with the wrong sign (PO-04), the same transaction twice (PO-07), and transaction types it does not recognise (PO-10). The scan and every explanation are free, and the workbook stays on your machine. It never connects to the payment platform.
See Payout Export Cleaner for Excel™
Microsoft, Excel and Microsoft 365 are trademarks of the Microsoft group of companies. Payout Export Cleaner is an independent product, not affiliated with or endorsed by Microsoft or any payment platform it works with.