Lending inventory template

Use this Google Sheets based Lending Inventory template to track your current inventory as you check borrowed 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.

Need guidance building your customized workflow?

Start automating every department in your business with our ready-to-use templates. If you need assistance building your own unique system, our experts can help. 

Lending inventory template overview

Inventory lending register items

The Check-out is independent. Fill out the items that your company/organization has removed from your lending inventory. Bring the data to the master Inventory by the click of a button, or schedule to do it automatically.

Summary of items in stock

The Current Lending Inventory list combines the Check-in and Check-out sheets to present you an updated stock list.

Summary of all lend out items

The data here is automatically generated so you can use this as another dashboard. In sum, the items out matrix gives you an overview of all the items lend out per person/organization.

Inventory lending template dashboard

The Lending Inventory spreadsheet is the master one. The dashboard tab contains borrowed out items, actual available items, and # of items out by the borrower.

Connected spreadsheets inventory

This spreadsheet-based Lending Inventory 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 Lending Inventory.

Inventory lending template in 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 Lending Inventory Management system.

How other users feel about Sheetgo

“We filter and process data from over 100 connected spreadsheets to provide automated forecasting for our business leaders around the world.”                                               
Jimmy Webb

Senior Finance Analyst, Quantum Spatial

“We pull data from our orders system to create automated work schedules for the 50 dashboards in our factory and generate orders for suppliers.”                          
Dawid Zacharzowski

Project manager, Eko Okna

"I use it to selectively share data and use the automatic update feature to update the sheet at midnight, so teachers always have the most current information."
Diana Boisvert

Centre Director, Grande Prairie Public Schools

Your spreadsheet workflows made easy.

What spreadsheets will you connect?

Connect spreadsheets, automate your work.

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

© 2016-2020 SHEETGO EUROPE SL