- Design a Product
It's easy to filter your Sales Overview to view your payment details. You can filter the Sales Overview to view the details for any month. Let's take a look at the steps to view the details for the October 15, 2012 payment date in Microsoft Excel.
Q: Why do I have to hover over the cells? Can't I just use SUM()?
A: Unfortunately, Excel's SUM() feature ignores any filters you've applied. This causes the SUM'd amount to include any Cancelled orders that were placed, and thus gives you an inaccurate number.
Q: Will this work with LibreOffice/Google Docs or another spreadsheet program?
A: It should. The steps may be different, however, as we haven't run through the same process in other office applications.
Q: After going through the steps you outlined above, my payment numbers still don't match!!
A: If you're still having issues, please Contact Customer Service.
Q: How come 'Total Markup Vat', 'Markup Earned', 'Markup Fee (VAT Excluded)', and 'Markup Fee (VAT Included)' are not available in the Sales Overview sheet?
A: We're currently working on making these columns available in the Sales Overview sheet, we appreciate you hanging in there with us!
Q: Why are all of your screenshots taken on a Mac? PC FTW!!
A: Some of us use Mac's, some PC's! No need to hate.