Processing Agent Commissions

Processing Travel Agent commissions can be handled in IDPMS. IDPMS uses the Accounts Payable Module for this function.  A valid AP license is required and Accounts Payable Module needs to be activated.

Financial Settings for Accounts Payable - Commission Handling

Go to Settings-> Financial- >Maingroup. A total of five Maingroups need to be setup for commission processing.

Main Groups

1. COM-Commission

 

Link appropriate Budget Group and Book Account number.

2. COMBP- Commission Batch Payment

 

Check credit option

 

Link appropriate Budget Group and Book Account number

3.  COMCP- Commission Counterposting

 

4. COMPP – Commission Prepaid (used if Agents send in room prepayment less their commission % amount)

 

5. COMTRF – Commission Transfer

 Check Credit option

Check Is A/P Maingroup

6. COMGST – This is used for Hotels inCanada that pay GST on commissions

 

Post Groups

Under Settings-> Financial-> Postgroup-> set up the five Postgroups for Commission handling as follows;

  1. COM- Commission

 

  1. COMBP- Commission Batch Pay

 

  1. COMCP- Commission Counterposting

 

  1. COMPP- Commission Pre Paid

 

Check Payment Type

  1. COMTRF- Commission Transfer to AP

 

Check Payment Type

 

6. COMGST - Commission GST - Needed for Hotels that pay GST on commission.

Articles

Under, Settings-> Financial,->Articles, set up the Commission handling articles as follows and link them to the corresponding Main and Post Groups;

 

 

 

 

 

Article sample 899 below is only required for hotels that have commission plans where GST tax is calculated. This article will then need to be used in the commission plans that calculate GST % and have a separate chargeplan.

 

Setting-Up Commission Plans

Go to settings-> Financial-> Commission Plan.

Create a new plan

 

Create the breakdown for the Plan

 

Maingroup: Link to the Room Revenue Maingroup (were the % commission calculation occurs)

Note-  If the hotel, has multiple Maingroups for room revenue distribution, a separate line in the commission breakdown for each and every one of the room revenue maingroups will need to be created.

Percentage/Amount: Enter the commission type (percentage or flat amount)

Percentage: Enter the %

Amount: Enter the flat $ amount

Article: Link to the commission Article PLU # (see Financial settings section)

Description: Description of the commission plan (limited to 30 characters)

Excluding VAT: Check if VAT should be excludes in the room commission calculation.(only used in Europe)

 

Note: Fields in Blue are mandatory.

Sample of a Commission Plan where there are multiple Maingroups for room revenue is outlined below. The example includes a 10% commission plan where commission is calculated as 10% of the room revenue.  This plan is also linked to article 899 which has a special charge plan that handles GST tax in addition to the commission.

 

In Canada, many Canadian Travel Agents get paid GST on the commission amounts. In order to set this up, a special article and charge plan need to be created.

 

The Article is linked to the Commission Main and Post Groups. It is also linked to a charge plan ‘COMGST’

 

It is important to link the GST tax to a separate POSTGROUP in the charge plan as shown below.

Setting Up A Charge Plan that Calculates GST on Commissions.

The Charge plan calculates 5% GST on the commission.

Many Hotels may want to have a separate article and main group for GST on Commissions for reporting purposes.

Setting Up Commission Payment Type

In settings-> Financial-> Batch Commission Payment, add the type of commission payment required. Hotels who will pay commissions in a check batch should set up CHECK as the batch payment.  Hotels using third party commission payables can set up the batch payment for PEGAGUS or PEROT Systems. (see samples below)

 

 

 

 

Note: Hotels can only use one Batch Payment Type and NOT a combination of more than one.

Relation- Travel Agent Profile

The Agent Relations that are commissionable need to be set up as follows;

1.                  Assign a default comm.. Plan. By selecting a default commission plan and linking it to the Agent Profile, each time a reservation is linked to that Agent, the default plan will be assigned to the folio.

 

2.                  Batch comm.: A type of Batch commission payment needs to be assigned.

 

3.                  IATA Number: Enter the Agent IATA number.

 

 

Registering Accounts Payable

All invoices that have been checked-out that are commissionable will remain in a suspense account until they are registered to Accounts Payable.

To register, go to Back Office, Accounts Payable,

Enter the date span to register invoices.

 

Select the Green Check mark to register.

 

Creating Commission Batch

Commission batches can be created once the folios have been checked out and settled to accounts payable. Commission is posted on Sub folio E once an Agent and Commission Plan are linked to a folio. Once room revenue is posted, commission will also be posted for the applicable folios.

Sample of a checked out folio with Commission posting.

 

Prepare Commission Batch for Pegasus Payment

From the Back Office Menu, select Accounts Payable, Commission Handling, Prepare Commission Batch.

 

Select the Cutoff date

 

 Select the Payment Type

 

 

Select and highlight all lines to include in the batch (use Shift key)

 

Select Green Check Mark.

 

Select ‘Yes’

Commission Batch is created and assigned a Number.

 

   

Reviewing Batch Details

To Review a Commission batch, go to Back Office, Accounts, Payable, Commission handling, Batch details.

Select Payment Type.

 

Select Green Check Mark.

All unprocessed batches are listed.

Select the Batch for review and select the breakdown icon.

 

Moving Commission Batch to IDCRS for Pegasus Handling

Go to Back Office, Accounts Payable, Commission Handling, Process Batches.

Select Payment Type.

 

 

Select green Check Mark

 

Select ‘Yes’

 

This will then Transfer the Commissions to IDCRS. The Commissions will then be handled at Central Reservations.

Moving Commission Batch from IDCRS to Pegasus

In IDCRS, go to Extra->Commission Handling->Pending Commissions.

This will show all pending commissions.

 

A special commission transfer tool (.exe) will be used to process and send the commission batches to Pegasus or other third party commission processor.

Commission Transfer Tool

This tool is only used from within the IDCRS application.

Launch the Comtransfer.exe

 

Login with username and password (same as used in IDPMS)

Select Green checkmark to process commissions.