Sales reports in Ebay are not adding up. Sales Numbers and Fees don't match.

[affordableappliancesandparts]

OK.  I hope someone can help.  For years, I have been looking for a report that would help me categorize my sales and expenses efficiently.  I always started with the sales and expense info from Sales Reports Plus.  I had to manually figure out my other expenses from my transaction report in Paypal.  It is time consuming.

I went to look for an alternative (as I do every year) and I found the Financial Statement report which has the payout info, sales minus fees (but fees are not stated), shipping costs, etc.  I also found the Seller Hub Sales report which also has some costs info like taxes collected. If you do the math on all the transactions on the Financial Statement, the final value fees do not match up to the number on the Seller Hub Report.

NONE of the sales numbers match up on either report.  The shipping costs in the Financial Statement are FedEx only.  NONE of the numbers of items sold match up on either report.  The fees in the Financial statement don't equal the fees on other reports.

I also looked at the Tax Report.  The insertion fees there match the fees on the Seller Hub Sales Report along with the subscription fee.  However, the shipping fees on the Tax Report match the fees on the Financial Statement but they don't match the shipping costs on the Seller Hub report.  I assume the Seller hub includes USPS as it is a greater number.  Why wouldn't USPS expenses be included in the Tax Report or the Financial Statement?

I can't even get these numbers to add up.  If I take the Sales Minus Fees from the Financial Statement and add the Ebay Fees from the Seller Hub Sales Report along with these odd Claim fees and Other Fees from the Financial Statement, it is STILL off by $6.91!

Am I missing something?  Shouldn't some of this match up?

I called Ebay and, of course, they were zero help after 40 minutes and explaining my issue to the associate 5 times.  Supposedly, a supervisor is supposed to contact me within 48 hours.  We will see about that.  I have zero faith in them returning my call.

[wooden_flower]

I would use the payments transaction report as a base. You can see the fees by order, do the math right on the report to see that the calculations are correct.  You know those amounts are correct because they tie into your payouts.  You have to add your own totals.  https://www.ebay.com/sh/fin/report

Part of the difference from one report to the next can be caused by refunds - some reports are reduced for refunds, others are not.  

Since what matters is supporting the cash you receive, I always worked to balance to the cash flow.  Although I sold in high volume, my sales were fairly simple. You can actually get all of the newer sources to balance, once you figure out which source includes or excludes which transactions.  I never tried to use the old sales reports plus.