Inventory
A free Excel inventory template is a count of what is on the shelf. Harbor Goods stocks twenty everyday products in the sample. You type the item, how many you have, the reorder point, and the unit cost. The sheet calculates stock value and marks a row Reorder when the count is at or below that point.
The free Excel inventory template is one workbook, not a warehouse system. Ballpoint pens and notebooks A5 are enough of a name if that is what you would say to a clerk. Use the same name every time you count.
Unit cost is what you paid, not the shelf price. Stock value is quantity times that cost. When a row says Reorder, that is the cue to open a free purchase order template, not to change the formula.
Google Sheets opens the same file. Add a product inside the list and extend the totals so the new row is included. A row typed under the total is invisible to the formula.
Open the free Excel inventory template and replace the twenty sample rows. Other guides are on the blog.
Workbooks for a small shop, a freelancer, or a contractor. Sample amounts are in dollars.
Yes. Download the free Excel inventory template and type over the Harbor Goods rows.
A row is Reorder when the quantity on hand is at or below the reorder point you typed.
Yes. Upload the same .xlsx file to Drive and open it with Google Sheets.