AppGarden Payout Export Cleaner logo AppGarden

Payout Export Cleaner

Refunds and disputes with the wrong sign in a payout export, checked in Excel™

By Paul Kemp · Published

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

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.

  1. 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.
  2. Add =SUMIFS(D:D,C:C,"refund") for each type to see subtotals by type. Adapt the label to match your file.
  3. 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.
  4. 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.