Managed Payments Payouts report may include foreign currency amounts

[clarkphilatelics]

Seller Hub Managed Payments All Transactions from foreign eBay sites with listings created by  Webinterpret display "Amount" and "Fees" only in a the local currency. The "Net" column is in dollars as well as the local currency. The conversion rate from the foreign currency to dollars in "information" pop up does not yield the correct sale price.  It appears that the difference is about 3 percent, suggesting that the foreign conversion fee was not bundled into the "Fees" column.  The foreign amount equivalent to the 30 cent "interchange" or swipe fee included in the "Fees" column varies from country to country and is difficult determine.

Unfortunately, the eBay Payouts reports only total the "Net" amount paid to the seller. The "Amount" or sales price column and he "Fees" columns are not totaled. unconverted foreign currency amount becomes another obstacle to reconciling Managed Payments payouts.

In 2019 with no foreign transactions, the sum of the "Net" amounts deposited to the bank exactly matched the 1099-K amount reported by eBay.  The sum of the "Amounts" would be sales and the sum of "Fees" would be an expense. Why is it that no one at eBay noticed that not including a total for the "Amount" and "Fee" columns could inconvenience sellers? Who in their wildest dreams would believe that eBay would leave unconverted foreign currency amounts is Payout reporting details? Does the Payouts download also report "Amount" and "Fee" in mixed currencies? Whatever eBay is doing, it does not add up.

Downloaded Payments reports exhibit the same defects. Worse, additional quirks in the data would make it more difficult than ever to import the data into a simple spreadsheet or a relational database. So much for tracking income and expenses. Is there anyone at eBay  who can present a simple way to extract useable data from the data mess they have created?