Smoldering stuff is not sexy, delicious, or fun.įrom my experience, making an insurance claim is a bit$h without knowing exactly what you own and how much you paid for it.

Both his belongings and family home were reduced to ash. He watched his family home burn to the ground in a massive house fire. My “better half” has lost everything too. The thieves even took my dang Chia Pet – you know, the pottery that grows? I came home after an exam to find everything of value stolen. It happened to me about 12 years ago while still a student. Losing one’s personal possessions doesn’t just happen to other people, it can happen to you. Checked By: Enter the name of the employee who checked each inventory item’s quantity, condition, and other relevant details.Watching your home burn down in a fiery blaze is a downer.Counted By: Enter the name of the employee who counted each individual inventory item.Stock Location: Enter stock-location details for each inventory item.Item Status: Specify whether each item is available or has been discontinued.Item Reorder Quantity: Enter the quantity to be reordered for each item.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 2023 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.

Insurance inventory checklist