Get the free residential leas inventory and condition form

Welcome in this video we'll be discussing the new rental inventory tracker excel template this is a free excel template from in zurich our if you are a business owner of a rental business where you rent equipment or items to your customers then you will find this template useful to track inventory so this template can help you know how many items are being rented out already and how many items are currently in stock you can also determine how many items will be expected in the inventory in the future based on future dated rental contracts or rental orders you can use this template for any type of rental business whether it's renting furniture renting wearing items or even lending books in a library now in this video we will see how the template works and I will be using the template filled in with some sample data so that we can illustrate the features of this template so this is our excel template where I am in the home sheet which is the beginning sheet which has the list of instructions very very simple templates or very simple instructions and then we can go to the essays sheet this is where I have already entered a few sample assets so I have chairs and desks and tables and I have entered the number of items that we have for each of those assets so for example in our business we have 25 bamboo chairs to any desks and 10 round coffee tables and so on and the calculations here the last two columns are automatic they will calculate how many items have been rented out and how many are currently in stock and at the top you have the total number of items and total rented out and noticed in stock when you become using the template where you haven't entered any assets then these things will be 0 but these things will be updated based on what we will be entering in the orders sheet so let's go to the order sheet in this sheet we have this table where we will be entering each rental order or rental contract that we have from our customers so for example order number 1 on May 1st 2016 varies even order for renting two bamboo chairs and they wanted the specific set of chairs to be rented out from 15 may and they will return it back to us on 20th May so that is the specific rental order for order number one and order number three for example there are two sets of assets so they need three round coffee tables and four rectangular tables and they they they have different rent out and return dates but they also could have the same rent out and return dates and so each and every order we will list all the details here and then the last column you can use it to track any communications with a customer or contact information for the customer their phone number or email address or other things and you can add more columns by typing in another field name here in h7 and then you'll create a new columns they can keep adding new columns to store any information that you want about the orders or the customers the top section here is the availability check section...