Best regards,
@seareidhunt I would make my own ... I could make one for you, would only need to know what info you wanted on it. Of course you would have to maintain it and there is no way I could get it to you via this forum ...
@seareidhunt My experience is that canned spreadsheets often lack the type of info I prefer ...
I keep track of my sales based on the inventory lots I acquire. The spreadsheet I developed does the following:
-calculates the average gross sale needed to hi my 50% target margin
-I input the total number of listings and as an item sells it draws down the remaining lot total
-I have a sold price column and net column based on ebay fees, promotion fees, etc
-Shipping is usually break even so I don't use any info on that, JUST the item selling price which is more valuable to me then a total order price
-I have columns for date (sold), internal category, description. I simply copy and paste the item title into the Description field so I know what it was
-it generates my running profit margin
-it generates gross and net item sales totals
I also have a monthly sales spreadsheet where I simply copy and paste from the inventory spreadsheets to the monthly. I also have a master sales spreadsheet from the first day I started selling (August 2015) ... it has the monthly totals (from aforementioned spreadsheet) meaning total number of sales and total item dollar amounts (not net, just gross). From that one I can see monthly trends over the years all on one screen. eBay would have nothing like that.
