How to Organize Inventory Sheets

As you operate a small business, your inventory -- the stock of goods or products -- forms the foundation of your enterprise. If your stock isn't too extensive, the task of taking inventory should be a straightforward process. Inventory sheets enable you to record and track materials, items in production and finished products to assist with the successful organization of your business. After taking inventory, organize inventory sheets to save this data. You have more than one option for storing inventory sheets.

  1. 1.

    Create a master inventory report. Use spreadsheet software if you want to track your inventory on a computer or use an inventory logbook with preprinted columns and rows if you prefer to organize inventory sheets manually. Divide the report into three separate sections of rows and columns. Label section one “Materials,” section two “Items in Production” and section three “Finished Products.”

  2. 2.

    Use a row for each item in each section and create column headers above the rows. Suggested column headers include the item name, the number of items in stock, the unit price, an expiration date of the item, if applicable, and the total value of the group of items.

  3. 3.

    Enter the first item name in the first row and column. Enter the number of items in the next column, the unit price in the next column, an expiration date in the following column (if applicable) and enter the total value of the entire group of items in the final column. Repeat this process for each item in each of the three sections.

  4. 4.

    Add the “total value” columns of inventory for each of the three sections. Enter the total values for each section at the bottom of the inventory sheet.

  5. 5.

    Add the total values for each section together to find a total for all the inventory in your business.