====== Customer Turnover (Commission) ======

**Navigation:** //Reports → Customer Reports → Customer Turnover (Commission)//

===== Purpose =====
To get turnover statistics per a customer per a destination (country) with a commission criteria.

===== Selection Criteria =====
  * From date, to date (Invoice (Offer) date within the selected period);
  * Customer;
  * Country;
  * Commission min & max;
  * Show Total Expense (if disabled, then Total Exp. is hidden from Grand Totals);
  * Show Grand Total (does not work).
{{:userdocs:travelwise:reporting:customer_reports:customer_turnover_c.png?nolink|}}

===== Sorting =====
  * By product code.

===== Data Output =====
  * Invoice (Offer) from/to date;
  * Min/Max commission;
  * Product Code;
  * Total;
  * Discount;
  * Discount%;
  * Grand Totals.

Total = Units * UnitSellPrice - Discount
Commision = ROUND (UnitSellPrice * Units - UnitSellPrice * Units - Discount)/(UnitSellPrice * Units)*100)
Total Expense = Units * UnitExpPrice

==== Grand Totals ====
  * Total Turnover (Sum of Total Sell Prices);
  * Total Coupons (Total Exp Price where product code is 'VK');
  * Coupons in Total (Total Coupons/Total Turnover ) * 100;
  * Total Handling Fee (Total Sell Price where product code is 'HF');
  * Total IATA (Net price, 'IATA' product code);
  * Total IATATAX (Net price, 'IATATAX' product code).

===== Report Preview =====
{{:userdocs:travelwise:reporting:customer_reports:customer_turnover.png?nolink|}}