Skip to main content

Good morning y’all!

I was wondering if it’s possible, when setting up a travel agency, to calculate the commission only on amounts excluding VAT and solely on the room prices. Afterward, I want to be able to see the commission amount on the invoice. The issue is that I’m not sure how to approach this. Is there anyone who has worked out a practical example and might be willing to share it? That would be great. Thank you!

Warm regards

Pierrick Robyn
Hotel Pavillon Du Zoute
Knokke-Heist (Belgium)

Hi ​@Pierrick,

Not sure if I understand the case correctly, but you could create a relative product that calculates the price of the product (i.e. commission) based on Night and or products and add that via a product rule.

It’s important to know that Mews has trouble with the “rule of three” so if you need to calculate on the actual net value, you need to calculate the percentage accordingly..

Let me know if you need more context or if I misunderstood the issue completely.

Best
Svenja


Good afternoon Svenja,

Thank you for your response. However, this is not the solution we are looking for.

Let me clarify the specific case:

  • We have a supplier who organizes team-building events and contacts us for accommodation arrangements.
  • This supplier works with five sales representatives.
  • When he places an order, we have a pre-negotiated price with this supplier
  • On this negotiated price, the sales representative receives a 10% commission/fee on the room charges.
  • This amount of the room charge is need to be calculated excluding VAT.
  • After the client's stay, I want this calculation to be clearly noted on the invoice, both for the end client and for our accounting records.

My question is: How can I manage this?

Warm regards

Pierrick


Hi ​@Pierrick,

I think I understand even less now, sorry.. 🙈

Could you put that into an example/numbers and what should be where?

Like the rate is 100€ we need x percent of that or on top of that as a separate line item, etc. ?

Best
Svenja

 


Reply