User tip: Hertz New Zealand operations need to have Thermeon's Support Dept. set up the GVT record "NZRVSRPT" which turns off the Royalty credit. Additionally, for the LDW to be subject to the same percentage split as the T & K, the "Rentback CDW" field in Foreign Vehicle Defaults must be set to
"P".
Details about the calculations and the data reported can be found at the end of this chapter.
To access the program, type RVSRPT (RET) at any menu "OPTION:" field or the appropriate number on the Hertz Reports Menu. The screen will then display:
| OPTION: REVENUE SHARE REPORT 1 My Company 00 2 Other Company ALL 3 Start Date 12-01-16 4 End Date 12-31-16 5 Detail/Summary D 6 Print/Display/CSV P Printer: /dev/tty 7 Oracle Account 1BEGIN 2 3ERASE 4 5BACKUP 6 7HELP 8 |
Enter data as follows:
|
1. MY COMPANY |
This field defaults to the Posting Company of your current location. Enter a different Posting Company number or press (RET) to accept the default. All locations having the same Posting Company as the one in this field are referred to as "base locations" in the discussion of the report at the end of this chapter. EXAMPLE: Press (RET) |
|
2 OTHER COMPANY |
Enter another Posting Company number or press (RET) to include "ALL" other posting companies. All locations having the same Posting Company as the one in this field are referred to as "split locations" in the discussion of the report at the end of this chapter. EXAMPLE: Type 01 (RET) |
|
3. START DATE |
Using your selected date format, enter the Starting Date. Press RET to default to the first day of the previous month. EXAMPLE: Type 110116 (RET) User tip: Records are selected by the RA charge DBR date. |
|
4. END DATE |
Using your selected date format, enter the Ending Date. Press RET to default to the last day of the previous month. EXAMPLE: Type 113016 (RET) |
|
5. DETAIL/ SUMMARY |
Enter 1 alpha character to select the report format. D = Detailed Report S = Summary Report
EXAMPLE: Type D(RET) |
|
6. PRINT/ |
Enter:
EXAMPLE: Type P (RET) |
| 7. ORACLE ACCOUNT |
This field is only used when the report is being run for locations in New Zealand and when the previous field has the value "I". Enter the G/L Account that will be used for the invoices created for Oracle Financials. EXAMPLE: Type (RET) |
The screen will then display:
| OPTION: REVENUE SHARE REPORT 1 My Company 00 2 Other Company 01 3 Start Date 11-01-16 4 End Date 11-30-16 5 Detail/Summary D 6 Print/Display/CSV P Printer: /dev/tty 7 Oracle Account 1BEGIN 2 3ERASE 4 5BACKUP 6 7HELP 8 |
PRESS "F1" AT "OPTION:" TO BEGIN .
Notes about this report:
Prior to actually producing the report, the program sorts transactions into the following types:
Type 1: Our rentals (rentals by My Company) involving Other Company vehicles.
These rentals opened at a base location using vehicles whose owning location is one of the split locations. This is true whether the vehicle was the original one on the RA or placed on the RA through a vehicle exchange.
Type 2: Our rentals (rentals by My Company) that closed at an Other Company location.
These rentals opened at a base location and either closed at a split location or had an exchange that occurred at a split location.
Type 3: Other Company rentals of our vehicles (My Company vehicles).
These rentals opened at a split location and the vehicle (whether the original vehicle or an exchange) has an owning location that is a base location.
Type 4: Other Company rentals that closed at one of our locations (My Company locations).
These rentals opened at a split location and either closed at a base location or an exchange occurred at a base location.
Once these transactions have been sorted into the above Types, the report lists them in two sections:
SECTION ONE: Vehicle revenue split transactions are listed as follows:
Type 1 transactions: Our rental of an Other Company vehicle.
These are listed as negative amounts (we owe a revenue split to the owning location.)
Type 3 transactions: Other Company rental of our vehicle.
These are listed as positive amounts (revenue split owed to us)
RAs are sorted according to the Posting Company number of the vehicle's owning location. Within each Posting Company, RAs are sorted by RA number. Each Posting Company starts on a new page.
One line of data is shown for each RA with the columns being:
RA#
Opening Location
Closing Location
DBR Date
Vehicle License #
Owning Location
Revenue split percentage
Total T & K (less discounts) allotted to the vehicle
T & K Split amount
If percentages are calculated using splits from
Edit Miscellaneous Control Flags. It is the posting company of the owning vehicle's percenages that are used not the default from company 00.Drop charge Split amount (the split percentage from the Foreign Vehicle Defaults Field 5 record applies to the Drop Charge.)
LDW amount (the split percentage from the Foreign Vehicle Defaults Field 4 record applies to LDW.)
Damage/Option ( Includes any damage charge plus the Rentback Option Code defined in Field 9 of Foreign Vehicle Defaults and/or the Rentback Option Set defined in Field 22 of Foreign Vehicle Defaults. These are always 100% owed to the vehicle's owner.)
GST
Royalty Adjustment Amount (as a negative for Australia operations; this column will be always be zero for Hertz New Zealand operations.)
Total
Vehicle exchanges: Discounted T & K (Time + Kms - Discount - Cust. Srv.. Adj. - Promos) is prorated based on the number of minutes the vehicle was on the RA. Therefore, for exchanges, the T&K on the report is only the prorated portion (not the total T&K from the RA.) See more on vehicle exchanges in the special section below.
Royalty Adjustment: ( Hertz New Zealand does not do the Royalty Adjustment).
When the report is run with Company 00 as "My Company" or as "Other Company", a Royalty Adjustment is calculated. The revenue split total is found by adding these items together:
T & K split, Drop Charge split, LDW and Damage (providing that these options are marked in the Edit Option Items File that they are subject to royalty.)
This total is then multiplied by the Licensee Royalty percentage amount from the Edit Licensee Fees record for the Posting Company other than Company 00. This percentage may vary by Fleet Type and effective date. (The effective date refers to the RA charge DBR date.)
The result of this calculation is the additional royalty owed by the licensee for revenue split revenue.
The amount is subtracted from the revenue split amount owed to the licensee and the final result is shown in the Total column.
SECTION TWO: Close Revenue Splits
Type 2 transactions: Our company rentals that closed at the Other Company locations.
These are negative amounts.
Type 4 transactions: Other company rentals that closed at our company locations.
These are positive amounts.
Like the transactions listed in Section 1, RAs are sorted according to the Posting Company number of the vehicle's owning location. Within each Posting Company, RAs are sorted by RA number.
One line of data is shown for each RA with the columns being:
RA#
Opening Location
Closing Location
DBR Date
Vehicle License #
Collection Charge (does not apply to exchanges) This is listed as positive in that we owe this to the closing location)
Fuel Charge at Close (on exchanges, this is the fuel charge added at the time of the exchange) This is listed as positive in that we owe this to the closing or exchange location.
GST
Cash at Close Total of cash type FOP's taken at Close. Listed as a negative in that the closing location owes us the cash on our RA.
Royalty Adjustment Amount
Australia: calculated if fuel or collection are defined as Royalty payable.
New Zealand: does not apply; will always be zeroTotal
All columns are subtotaled. Cash at Close is deducted from the revenue the reporting location owes the owning/closing location.
A grand total completes each section by adding the following columns together from Sections One and Two:
GST
Royalty Adjustment
Total
MORE ON VEHICLE EXCHANGES IN THE REVENUE SHARE REPORT
The Revenue Share Report is designed to report revenue that must be shared when an operator uses a unit that is not owned by him. As a result there are special rules that apply when vehicle exchanges occur. See the examples below:
- Location GOT60 rents one of its own vehicles for 4 days = GOT60 gets 100% of the revenue, there is no revenue split
- Location GOT60 rents one of its own vehicles for 4 days after exactly 2 days a vehicle exchange happens at location COO60 but the vehicle used is also owned by Location GOT60 = GOT60 gets 100% of the reveue for the first 2 days and the revenue for the last two days is split between GOT60 and COO60.
- Location GOT60 rents one of its own vehicles for 4 days after exactly 2 days a vehicle exchange happens at location COO60 but the vehicle used is owned by Location C0060 = GOT60 gets 100% of the revenue for the first 2 days and COO60 gets 100% of the revenue for the last two days.
- Location GOT60 rents one of its own vehicles for 4 days after exactly 2 days a vehicle exchange happens at location COO60 but the vehicle used is owned by Location ABC60 = GOT60 gets 100% of the revenue for the first 2 days and COO60 and ABC60 will split the revenue for the last two days.
- Obviously the calculation gets even more complicated if GOT60 starts the rental with an unowned car and the exchange occurs at an unowned location = then both the revenue for the first 2 days and the revenue for the last two days may be shared.