How to Do a Product Inventory Sheet

by Emily Weller

A product inventory sheet helps your small business keep track of items you use or sell. Each sheet lists a single product and keeps track of how much of the product is coming into your business and how much is going out. Make product inventory sheets for items you have for sale as well as for ingredients if you run a restaurant or other establishment that serves food. If you make items, such as clothing or jewelry, do inventory sheets for your materials and supplies as well.

1. Open the word processor, spreadsheet software or database software of your choice and create a new document. If using spreadsheet software, dedicate one sheet in the document to each product. In a word processor, give each product its own page. If you use database software, make a table for your product inventory.

2. Type the words "Product Name:" in the first column and first row of the first sheet of the spreadsheet or at the very top of the first page of the word processing document. If you are using database software, make "Product Name" one of the table's fields.

3. Type "Description" in the column next to "Product Name" on the spreadsheet or on the line below in a word processor document. Make "Description" a field in the table in a database. Add fields for "Cost" and "Price," or type those words into columns on the spreadsheet or on separate lines in a document.

4. Type "Date," "Quantity In," "Quantity Out" and "Total On Hand" in the other columns on the spreadsheet or as fields in the database table. In a word processing document, make a table with four columns. Type "Date," "Quantity In," "Quantity Out" and "Total On Hand" in the columns.

5. Record the name, product description, cost and price in the row below the words on the spreadsheet or in the table beneath the fields on a database. Type the name and description next to "Product Name:" and "Description" if you are using a word processor. Also type in the cost and price.

6. Write the date under the word "Date" on the sheet, then write how many of the product you have under "Total On Hand."

7. Record the appropriate amount in the "Quantity In" and "Quantity Out" columns with the date whenever you receive new amounts of product or sell any. Calculate the number you should have after receiving a shipment or selling items and record the total in the "Total On Hand" column.

Things Needed

  • Computer with word processing, spreadsheet or database software


  • Be as descriptive as you want on your product inventory sheets. For example, divide items into categories such as clothing/skirts or clothing/pants. If you make items from scratch, you may want to include the materials needed to make the item and the time it takes you to make the item on the sheet.

About the Author


Photo Credits

  • Jupiterimages/Comstock/Getty Images
Suggest an Article Correction