• Finished Inventory and Sales Summary Spreadsheet - Multi Venue Fee Tracking
  • Finished Inventory and Sales Summary Spreadsheet - Multi Venue Fee Tracking
  • Finished Inventory and Sales Summary Spreadsheet - Multi Venue Fee Tracking

Inventory and Sales Management, Inventory Tracking Spreadsheet

(1 customer review)

$19.00

This system was developed for someone managing finished items inventory and tracking sales. This can be used by someone who is selling handmade items (or not), but will not track the raw materials going into the finished items, just the actual finished items being sold.

Personalize with Name or Company Name *

Description

If you are looking for a system to help with tracking your finished items inventory and sales, this template is set up to help with both. This template can be used by anyone who is in direct sales, or looking to track their inventory. The file will work with up to 10,000 sales.

Features

Several pages of the worksheet are linked together, to save you time with data entry and to update your inventory after a sale is entered.

*Inventory Tracking – There is a page to enter your items, item ID’s or SKU’s, and assign each item to a venue. If you have the same items at different venues, they will need a slightly different item ID. For example 12B for an item at a boutique and 12E for the same item on Etsy. As you replenish your inventory for the same items, you will just keep adding a cumulative number to the quantity in the same row – The Inventory page is set up for 1 row per unique item/venue.

*FEE Tracking – You will be able to add up to 15 different venues and their associate fees, as a percentage and/or a flat rate of your sales.

*Sales Tracking – This page will link to the inventory page and your fee page, so when you enter the Item ID/SKU of something that sold, several columns will automatically populate (see grey columns) based on what you’ve already entered. Just fill out the final sale price, quantity sold and shipping income. You will also be able to add sales tax. The last column will show your net profit – Your order total minus total fees and shipping costs. Several totals are tracked at the top of the page, including Total Sales, Total Sales Tax collected, Total shipping Income, Total Shipping Cost, Total Fees and Total Profit.

*Sales Summary – The summary page will summarize all your sales data to give you a nice snapshot of your total sales by month, sales by venue and by product. See 1st slide.

After you’ve entered your sales data, you can go back into the inventory page to see which items you are sold out of or running low on, as the inventory available will continue to update based on your sales.

Each page is already set to print.

You will receive an Excel Spreadsheet and a PDF with directions, an open office version of the template is available upon request.

*All templates are for your use only, and will come personalized with your name or business name. Please do not distribute.

Additional information

Materials

,

1 review for Inventory and Sales Management, Inventory Tracking Spreadsheet

  1. Christy Grosso

    Erin is beyond helpful and her customer service is 10 stars. I ordered the wrong template and she went back and forth with a million times until we found the right one.

Add a review

Your email address will not be published. Required fields are marked *