Registration of Vehicles, Suppliers and Clients
To start using the spreadsheet, you must register your entire fleet (brand, color, purchase price, rental price), your suppliers (registration number, address, contact in general) and customers.
For each month, you can register all of your rents by associating each sale with a customer and vehicle. In addition, you will record the withdrawal and delivery dates for each of them, thus calculating the rental time and also the value. In this tab, it is also possible to control the payment status and the situation of each of the rents.
Then you can fill in all your monthly expenses. These, added to the revenue generated automatically from your rental control, will form your cash flow. In this area, you'll also be able to see the earnings per month with your customers.
Vehicle Performance Analysis
You will have a dynamic dashboard to analyze the return of each of the vehicles in your fleet. In it, you will get data like: amount of rents, total revenue, return on investment and more!
General Performance Dashboard
Finally, the spreadsheet will provide you with an overall performance dashboard of your car rental operation, informing you graphically of your monthly or annual result for each vehicle in your fleet.