Hi!
I'm a Marketplace seller and official Sales Report always confused me, that much, so I decided to make a small Python script, which does all calculations with money and grouped results by month.
Implemented logic:
- variables for old(70%) and new(88%) percentage
- Epic Refund Day = (01, July, 2018)
- all your deals would be refunded(with the next payment) after that date accordingly
- it looks at the balance at the end of the month
- if it >= $100 you will get time delta +45 days
- and will show you approximate date of payout
- (without correction for a weekends or paypal transaction time)
So here is a link:
and this is a test-link, to make sure what is it and how it looks like:
btw service doesn't store your data, check out the source:
If you have any suggestions, please feel free to open pull request or chat with me in the discord ;-)
Some caveats:
Epic's doesn't allow you to get report that the date range exceed 18 months, so you'll have to manually concatenate the CSV's from of your reports with schema like this:
{head}
{data-1}
{data-2}
{data-*}
{footer}