If you are a small business that needs an easy to use way to track your inventory, this spreadsheet is the perfect solution for you.

This product is an inventory tracker excel template is designed to help you track your quantity on hand, monthly and year sales, profits, and purchases.

- Easy to use register to input sales, finished products, and purchases for each item.
- Summary schedules that automatically calculate sales, average cost of each item, and your profit by item.
- Customizable inventory names. Easily add as many products as you need.
- Summary schedule that tracks your quantity on hand, and status updates to show when you need to re-order or make new items.
- Monthly schedules that show sales, quantity sold, total purchases and quantities purchased by item.
- Includes a drop down summary schedule that shows sales by each item, as well as the average cost and sale price of each item.
- Customizable fiscal year.

To see a step by step walkthrough of this template, please go to: https://youtu.be/65DsyvhZzIA .

As with all my templates, if you have any small modifications, or if you have any questions or issues, please feel free to reach out to me.

Thank you for reviewing my listing!

Andrew