Days per Reorder: Enter the days between order and receipt for each vendor and item.Total Inventory Value: Check to ensure that your inventory’s total value is correct by adding together the total value of all items.Total Value: Check to ensure that each inventory item’s total value is correct by multiplying item quantity and cost per item.Cost per Item: Enter the cost per item for each inventory item.Stock Quantity: Enter the in-stock number for each item.Vendor: Enter vendor contact details, item number, and unit information for each item.Date of Last Order: Enter the specific date of each item’s most recent order.Description: Enter a brief description of the item.Item Name: Enter a name for each inventory item.Item Number: Enter a unique number for each item in your inventory.Reorder: Enter reorder details, including an item’s auto-fill threshold and whether the item is currently on order.

A Google Sheets inventory template can help alert you when inventory items need to be reordered and keep your inventory proactively stocked.Ī Google Sheets inventory template typically includes the following details for managing and tracking your inventory: Whatever your role in inventory management, you know how critical it is to have accurate data and keep sufficient stock on hand. It also helps you track costs per item, stock quantities, and reorder levels, and calculates total inventory value. Getting started with the Smartsheet APIĪ Google Sheets inventory template helps you track and manage inventory items by name, number, reorder status, and vendor information.ENGAGE Smartsheet ENGAGE brings together our global customers, experts, and partners to share their experiences, ideas, and best practices.

Smartsheet events Your hub for Smartsheet events, webinars, Q&As, and user groups.

Partners Learn about the Smartsheet partner program and access our partner directory.

Community Explore user-generated content and stay updated on our latest product features.

Help and Learning A comprehensive knowledge base, including articles, tutorials, videos, and other resources that cover a range of topics related to using Smartsheet.

Content Center Articles and guides about project management, collaboration, automation, and other topics to help you make the most of the Smartsheet platform.

Home inventory list excel template