AppGarden Payout Export Cleaner logo AppGarden

Payout Export Cleaner

More than one currency in a payout export: check each one separately in Excel™

By Paul Kemp · Published

A payout export can hold lines in more than one currency. A customer may pay in one currency and the payout settle in another. A SUM over the whole column adds pounds to euros as if they were the same, and gives a total that matches nothing.

What to look for

Check by hand

These steps apply to Excel™ in Microsoft 365. Work on a copy. Assume the currency is in column B and the amount in D.

  1. Select the data and choose Insert → PivotTable. Put Currency in Rows and Amount in Values (Sum). Each currency gets its own total.
  2. Or use =SUMIFS(D:D,B:B,"GBP") for each currency code you find in the file.
  3. Compare each currency's total with the payout for that currency.
  4. Do not convert to a single currency by guesswork. Conversion needs a rate and a date, and which one you use is an accounting decision.
  5. If a line's customer currency differs from the settlement currency, check which amount column you are summing.

Flag them in the scan

Payout Export Cleaner flags more than one currency, or a customer currency that differs from settlement (PO-05). It never converts: currencies are flagged and checked separately. The scan and explanations are free, and the workbook is not uploaded.

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.