The first configuration of the worksheet before you start controlling your locations is the complete registration of your equipment. In addition to the name of each of them, you must also place the purchase price, date of purchase, depreciation rate and the amount of the daily, weekly and monthly lease.
Customer and Supplier Registration
Then, you must register all your suppliers and customers. These data will be important for the correct completion of each location.
For each month of the year, you will have a tab to register all of your equipment rentals for that period. For each rental, you can fill the customer, date of withdrawal, delivery date that the worksheet will calculate the earnings automatically.
Monthly Earnings Report
Automatically, the worksheet will aggregate all data from the rental record tabs and will generate a earnings report per machine per month and also a total earnings per customer.
Return By Equipment Report
In this report, you will be able to see the total generated by each equipment and check if it has already covered the purchase price of the same.
Finally, the spreadsheet will generate a location dashboard in which you can analyze each piece of equipment for the time period you want, and check how many rents were made, the revenue generated, and the idle rate.