
Use the Notes column to keep track of any information related to the order. Enter Rent Out Date (date when the asset needs to be given to customer) and Return Date (date when asset will be returned by the customer). When you begin, Rented Out will be 0 and all the items will be In Stock.Įnter Rental orders in Orders sheet Rental Inventory Tracker – Enter rental orders detailsĮnter Order Number, Order Date, Asset being rented and Quantity being rented in this excel equipment rental spreadsheet. The last two columns are automatically calculated. If you are new to Excel Tables, please read this article first: Introduction to Excel Tables.Įnter Asset Name, Description and # of Items you have of each asset. Enter Rental Equipment or Rental Assets Items
Simple inventory sheet how to#
How to track rental inventory in Excel Overview of Steps Rental Calendar – Available Quantity Free Download This Excel template is designed for Microsoft Excel, but if you are looking for a Google Sheet template, please visit Rental Inventory Tracker in Google Sheets. You can use this template for any rental business, such as event rental, party rental, equipment rental, furniture rental to parties or events, renting wedding items to weddings, construction equipment rental, audio video equipment rental, bike rental, sports equipment rental or book rental.
Simple inventory sheet software#
Use this free equipment rental software to get organized and be in control of your rental inventory. In addition to knowing the current inventory, you can also determine the expected inventory in future based on future dated rental orders/contracts. This Excel rental inventory management template can help you know how many items are in stock and how many have been rented out. If you are a business owner of a rental business where you rent equipment or assets to your customers, you will find this template handy in tracking inventory. Inventory Management Software 2023 for Rental Businesses



Simple inventory sheet pro#
