Have a look at the pics in the attached links below.
1) In the first pic you'll see what part of my Daily Product Breakdown from yesterday looked like.
Note that there's a column called "Sell Price" and a column called "Sold Count".
2) Now have a look at the second pic. It's a screenshot of an inventory search in my back end for one of the times listed in the first pic.
Note that there's a column called "Buy Price".
Now...
It would be really nice if the Daily Product Breakdown report included columns for:
- Total Sales (Sell Price * Sold Count)
- Buy Price (value taken from back end)
- COGS (Sold Count * Buy Price)
- Profit (Total Sales - COGS)
- Profit Margin % (Buy Price/Total Sales*100)
and
- a final row at the bottom that totals up the relevant columns.
