Inventory management template

Use this Google Sheets based template to track your current inventory as you check items in and out.

Click the button below to set up and start using. Inside the template installation page, you will have instructions on how to configure.

Inventory management template overview

inventory template automated dashboard

The Inventory Management spreadsheet is the master one. The dashboard contains sold out items, oversold items, total items in stock, and your top items. All tables are automated and will always show updated data.

inventory template google sheets

The Current Inventory List spreadsheet combines the Check-in and Check-out sheets to present your stock list. The list is automated and will always show updated data.

inventory template check in items

Use the Check-in spreadsheet to record and track items that you have checked in. In the tab “Check-in”, fill in all items that your company has removed from your inventory. You can bring the data from here to your master spreadsheet by the click of a button or you can schedule to do it automatically.

inventory template check out items

Just like the Check-in spreadsheet: the Check-out is independent and separated. Fill out the tab “Check-out” with the items that your company has removed from your inventory. You can bring the data from here to your master spreadsheet by the click of a button or you can schedule to do it automatically.

inventory template connected with check in and check out

This spreadsheet-based Inventory Management system is composed of three spreadsheets connected to each other using Sheetgo. This is the network view of the workflow that you created with Sheetgo to manage your Inventory.

inventory template google drive

Sheetgo will automatically organize the three spreadsheets in your Google Drive. Since these are spreadsheets you have total freedom to change and personalize your spreadsheets based Inventory Management system.

See who's using Sheetgo

This is a very reliable add-on. Sheetgo has incredible support. So happy to find something that finally works!

Svetha Janumpalli

Founder & CEO, New Incentives

Sheetgo is great. This product has allowed us to take business workflows and reporting to the next level.

Cullin McGrath

Process Manager, Tech Defenders

Excellent app to consolidate like-sheets. Keep your title heading simple, and the app does all the rest for you in 3-4 clicks!

Jimmy Webb

Finance Analyst, Quantum Spatial

Your spreadsheet workflows made easy.

What spreadsheets will you connect?

Create workflows from your spreadsheet

Don't hesitate to reach us anytime! [email protected]

© 2016-2019 SHEETGO EUROPE SL