Agencies Commission Report

Agencies Commission Report

Purpose:

The Agencies Commission Report shows the commissions and payments due to or from your agents. It will help you identify the following situations:
  1. When an agent takes no payment from your customer at the time they sell the booking.
  2. When an agent takes part payment from your customer at the time they sell the booking.  
  3. When an agent takes full payment from your customer at the time they sell the booking.
This report also allows for managing Agent bookings in regard to payments. You can do any of the following from this report: 
  1. Record a payment you have made to the Agent
  2. Record a payment you have received from an Agent.
  3. Email an Invoice detailing the amount of money paid or is payable to the Agent.
  4. Delete a recorded payment from an Agent.

Accessing Agencies Commission Report:

Reports >> Monthly Financial Reports >> Agencies Commission Report

Parameters:


Pickup Location
Can be run for All Locations or a specific Pickup Location.
Any booking with this as their pickup location will display in the report.
Agency
Can be run for All Agents or a specific Agency.
Anybookings made against this Agency will display in the report. 
Agency Region
Can be run for all Agency Regions or a specific Agency Region.
The agency Region can be assigned at the Agency Branch level, and any bookings against an Agency Branch in this rgion will display in the report. 
Balances Due
You can chose to run this report for one of the following two options:
  1. Balance Due Only
  2. All Balances (includes $0 balances)
Category Type
Report on All Category Types or a specific Category Type.
Any booking against a vehicle of this Category Type will display in the report.
Category
Report on All Vehicle Categories or a specific Vehicle Category.
Any booking against this Category of vehicle will display in the report.
Brand
If you have Branding enabled in your RCM system, this report can be run for All Brands or a specific brand.
Any bookings made against this Brand will display in the report.
Date Type
This report can be run for either Pickup Date, Drop off Date, or Date Entered.
Date Range
This report will return any booking with the relevant date falling within this date range. 

Example:




Res
The Reservation number of the Agent Booking.
Status
The status of the reservation.
Un. Res
If this reservation started as an unallocated booking, then the unallocated booking number will appear here.
Ref #
The Reference number against the Agent Booking
RCMReferenceID
The RCMReferenceID against the booking.
Update
Clicking on the Update button will open the booking form, allowing you to update the reservation.
-
There are one of two buttons that may appear in this column, depending upon whether the Agent owes the Rental Car Company money or the other way around. The following calculation is done and the amount appears in the Balance Owing field:

Balance Owing = Comm Val - Agent Collect + Received from Agent
  1. Payment - If the Balance Owing amount is a negative amount, then this means that the Agent is owed money. Once payment has been made to them, it can be recorded against the booking by clicking on the Payment button that will appear in this field.

  2. Receipt - If the Balance Owing amount is a positive amount, then this means that the Agent owes money to the Rental Car Company. Once payment has been made to them, it can be recorded against the booking by clicking on the Receipt button that will appear in this field.
Date Booked
The date the reservation was created
Agency
The name of the Agency against the reservation
Branch
The Agent Branch against the reservation.
Booked
The name of the operator who created the reservation.
Hirer Name
The name of the customer against the reservation.
Category
Vehicle Category associated with this reservation.
Pickup
The pickup Location.
Pickup Date
The pickup date against the reservation.
Dropoff Date
The drop off date against the reservation.
# Days
The length of the booking in days. 
Extra
This is the total amount of the extra fees saved against this reservation.
Total Booking
The total cost of the reservation.
Comm Booking Value
The amount of money against the reservation that is used to calculate the Agent's commission.
This may be different to the Total Booking amount depending on how the Agent has been setup.
Comm Val
The agent commission amount for the reservation.
Agent Collect
The amount of money that the Agent has collected for this reservation.
Received from Agent
The amount of money that the Agent has paid to the Rental Car Company for this booking.
Balance Owing
This is the amount of money for this reservation that is owing to the Agent. 
It is not the balance owing for the booking.
It is calculated using the following formula Balance Owing = Comm Val - Agent Collect + Received from Agent
Email
Clicking on the Email button will send an Invoice through to the Agent.
Invoice Emailed Date
If the Agent Invoice has already been emailed out, then the date it was emailed will appear here.

If a payment has been made either to an agent or by an agent, then it will appear as a note under the booking in the report. This can be seen with the second booking in the image above. This note will show the payment reference number, date and amount. There is also a red Delete button, and clicking this button will remove the payment record from the booking. 

Points to Note:

It is important to note that the Balance Owing information will be calculated based upon the Agent Commission amount and any amounts that have been recorded as either a payment to an agent or an amount the agent has collected. It is not the Balance owing of the booking.

Printing/Exporting:

Click Here for details on how to print or export a report from RCM.



    Important Articles


      • Related Articles

      • Agencies Commission Report

        Purpose: The Agencies Commission Report shows the commissions and payments due to or from your agents. It will help you identify the following situations: When an agent takes no payment from your customer at the time they sell the booking. When an ...

      • Agent Commission Summary Report

        Purpose: The Agencies Commission Summary Report shows the summary of all commissions grouped by Agent and Branch. To view a detailed listing of individual bookings by Agent, click on the Agent Commissions tab. You are also able to print/email a ...

      • Referrals Commission Report

        Purpose: The Referrals Commission Report displays referrer's commissions based on the selected location, referrer and report period. The report uses the entries made in the Referrals menu Option of the System Setup Menu. The referrer is selected when ...

      • Payments to Agents Report

        Purpose: The Payments to Agent Report shows the amounts paid to your agents, who book reservations on your behalf and are paid on a commission basis per transaction. Using this report, you will be able to compute how much has been paid to your agents ...

      • Received From Agent Report

        Purpose: The Received from Agents Report shows the monthly summary of all booking fees and commissions due from your agents. This is particularly helpful if you have agents booking reservations on your behalf and being paid on a commission basis. It ...