If you are looking for a way to easily calculate your beginning and ending inventory this template is here to help! If you have to file a schedule C tax form in the US, you’ll need to know what your beginning and ending inventory is and there are several different ways to go about doing this.
This template is one way you can track your inventory, and is designed for someone who does an actual physical inventory of their items/materials at the end of the year.
The best part about this template that will save you a ton of time, is a macro inside the template that will ‘reset’ your inventory at the end of each year. So as the new year starts, your ending inventory turns into your beginning inventory for the new year. Instead of having to transfer all your ending inventory to now show as beginning inventory, the macro will do this for you.