Browse
 
Tools
Rss Categories

Forecast Monthly Earnings Report

Reference Number: AA-00664 Views: 4834 Created: 2011-12-14 09:14 Last Updated: 2017-07-04 14:45 0 Rating/ Voters

In this section

Forecast Monthly Earnings Report

Generate a Forecast Monthly Earnings Report

Print a Forecast Monthly Earnings Report

Export a Forecast Monthly Earnings Report to Excel


Forecast Monthly Earnings Report

The Forecast Monthly Earnings Report displays sales figures by location and vehicle category over a selected date range. By default, the report will run over the current month.


Back to top

 

Generate a Forecast Monthly Earnings Report

To generate a Forecast Monthly Earnings Report first open the Forecast Monthly Earnings page (Reports > Hireage and Sales Reports > Forecast Monthly Earnings Report), see Fig. 1.

 


Fig. 1. Opening the Forecast Monthly Earnings Report page

 

On the Forecast Monthly Earnings Report page (see Fig. 2):

  • A. Select either a location or region. By default, location is set to your default location. When generating a report, if you have selected a region, Rental Car Manager will disregard the location
  • B. Select a brand to view the report for, by default all brands are selected.
  • C. By default, the report will display rentals in all vehicle categories. You may select a specific vehicle category, if needed.
  • D. Pickup date range is set to the current month by default. You may change the date range, if needed.
  • E. To generate forecast monthly earnings for agents only, click the Agent Booking Only box. 


Fig. 2. The Forecast Monthly Earnings Report page

 

Click "View" to generate a Forecast Monthly Earnings Report. The order of the report is controlled by the 'Ordering' field in the Vehicle Categories page under the Vehicle Maintenance menu (see Fig. 3).

 


Fig. 3. The Forecast Monthly Earnings Report

 

NOTE: For more details on vehicle categories, see the Vehicle Maintenance User Manual.

 

Once you generate the report, you can print it, export it to Excel and export it as a PDF.

 

NOTE: Table 1 shows descriptions of each column found on the Forecast Monthly Earnings Report.


Back to top

 

Print a Forecast Monthly Earnings Report

To print a Forecast Monthly Earnings Report first generate a report (see Generate a Forecast Monthly Earnings Report).

 

After generating the report, click the printer icon to display a printer-friendly version of the report (see Fig. 4).

 


Fig. 4. A Printer-Friendly Forecast Monthly Earnings Report

 

You may then print the report using your internet browser's built in printing functionality.


Back to top


Export a Forecast Monthly Earnings Report to Excel

To export a Forecast Monthly Earnings Report to Excel first generate a report (see Generate a Forecast Monthly Earnings Report).

 

After generating the report, click the Excel icon.

  

You may then open the report in Excel by locating the downloaded file and opening it in Microsoft Excel (see Fig. 5).

 


Fig. 5. A Forecast Monthly Earnings Report open in Excel

 

NOTE: Depending on the browser you are using to access Rental Car Manager, you may be prevented from opening an Excel file from the Internet on your computer. To resolve this problem, see the FAQ section on the Rental Car Manager Help Center.

 

Table 1. The Forecast Monthly Earnings Report columns

Column Name Description
Location The location or branch name 
Category The vehicle category description
Rental Revenue Total No. of Days x Daily Rate
Forecast Rental Revenue The expected rental revenue for the month
Extra Revenue Total of all extra fees charged excluding Recovered Expenses and Bond Fees
Forecast Extra Revenue The expected extra revenue for the month
Total Revenue  Rental Revenue + Extra Revenue


Back to top