Commission Settings Explained

Commission Settings Explained

When creating agency records in Tourwriter, you have the option to assign agent commission settings for each agency you work with. The commission settings you assign will automatically calculate your agent’s commission or markup for any itineraries you add them to. You will only be able to apply one setting per agent and we recommend applying the setting that has been agreed in your contractual agreement with your agency.

This article explains the agency pricing calculations for each agency commission type dropdown option. To learn how to select a default option for an agency, see Creating an agency. To add the agency to an itinerary, see Adding an agency to an itinerary.

Within the agency record, the Default commission setup section has 4 agency commission types to choose from:

  1. Calculate commission from gross.
  2. Calculate commission on top of gross.
  3. Agency adds markup themselves.
  4. Overwrite supplier markup.

The first and second options require you to define an agency commission percent based off your Gross prices, whereas the third and fourth options require you to define an agency commission percent based on the Net price.

If By product type is enabled, then you can setup commission independently for every Product type.
If it is disabled, the same commission will be applied for all the Product types.
By product type is available only for 1, 2, and 4 above.


Agency commission settings at a glance:

SettingWhen to use this setting
Calculate commission from grossWhen you have an agreement with an agent to pay them a set amount of commission and want to pay this as a split of your usual margin.
Calculate commission on top of gross
When you have an agreement with an agent to pay them a set amount of commission and wish to keep the usual margin from an itinerary for yourself.
Agency adds markup themselves
Perfect if you are offering your agent the same net rate that you usually offer to direct travellers, and allow the agencies to add their own markup before onselling to the traveller.
Overwrite supplier markupOverwrite the standard Supplier markup with an Agent markup. Offer your agent an agent net that is based on Net + Agent markup. 


What’s the difference between agency commission, margin and markup?

The primary difference between agency commission and markup is that markup is added to the purchase price whereas commission is deducted from the sale priceMargin is the value of the profit relative to cost and revenue. Let’s look at some key pointers:

  • Markup % is the ratio of the profit made to the cost paid. It is always added to the purchase price
  • Agency commission % is the percentage based renumeration paid to the sales agent. It is always calculated from the sale price, and not on the purchase price
  • Margin $ is the dollar value difference between the purchase price and the sale price

Calculate sale price using markup %

The markup is added to the purchase price to calculate the sale price. So, if you wish to markup the purchase price by 20%, you will add 20% to the purchase price directly. Let’s say your purchase price is $1000. The sale price after adding the 20% markup would be:

So the formula is:        cost + cost x markup / 100 =  revenue
  • $1200 + $1000 x 25% = $1500.  (Markup is 25%)

Calculating margin using commission %

To calculate the margin (agent commission) using commission % we use a very basic calculation revolving around percentages. Just take the sale price, multiply it by the commission percentage, and divide it by 100.

Let’s say your purchase price is $1500 and you wish to earn a 20% commission. An example calculation: an itinerary sells to the traveller for $1500. The Agency sells for a commission of 20%, which amounts to $300.

So the formula is:       sale price × commission percentage / 100 = commission amount
  • $1500 x 20% / 100 = $300 (Commission is 20%)

More information

  • Commission type options Agency adds markup themselves and Overwrite supplier markup activate the agent markup field in the itemised pricing table. Whereas the options Calculate commission from gross and Calculate commission on top of gross activates the agency commission field.
  • The total agent price displays at the bottom of the itemised pricing table, however, unlike the net, markup and gross fields, the total agent price, total agent markup % or agent commission % cannot be edited.
  • The agent price, agent markup or agent commission % cannot be locked individually for each row, as they are actively calculated based on other figures in the row. However, selecting the Lock all option from the Options menu (three dots at the end of the row) locks all agency pricing fields along with the other pricing fields.
  • On adding an agency to an itinerary, the agent pricing columns are based on the fields the selected agency commission type of that agency at that time and the values in the existing pricing table.
  • Fields that are edited or locked prior to adding an agency, will remain locked or edited.
  • On removing an agency from an itinerary, the agent pricing columns are cleared, the edits and locks of net, markup and gross, will remain.
  • Items will not be automatically recalculated when an agency is added. If you want to recalculate prices, ensure that items are unlocked and press refresh.
jj
    • Related Articles

    • Booking email settings explained

      Tourwriter’s booking features allow you to effortlessly send booking requests to your suppliers, and receive responses all from within the software. In this article, learn how to customise the booking email settings to you and your team’s needs. ...
    • Calculate commission from gross

      This commission type lets you calculate the agent price based on an agent commission which will be subtracted from your gross price. Your gross price will be calculated as per the usual setup of net + markup = gross. Then the agent commission ...
    • Calculate commission from gross

      This commission type lets you calculate the agent price based on an agent commission which will be subtracted from your gross price. Your gross price will be calculated as per the usual setup of net + markup = gross. Then the agent commission ...
    • Calculate commission on top of gross

      Similar to the calculate commission from gross commission type, the calculate commission on top of gross option fetches the agent commission percentage from the agency commission type setup. With this scenario you will still take home your usual ...
    • Calculate commission on top of gross

      Similar to the calculate commission from gross commission type, the calculate commission on top of gross option fetches the agent commission percentage from the agency commission type setup. With this scenario you will still take home your usual ...