Consolidated Exchange Rates With Commissions

When NetSuite converts commission amounts to the base currency of the employee or partner's subsidiary, it uses consolidated exchange rates. You can view consolidated exchange rates at Lists > Accounting > Consolidated Exchange Rates.

For example, if a company has the following subsidiary hierarchy:

Three invoices qualify for commission:

Transaction	Subsidiary	Currency	Commission Amount
Invoice 1	U.S.	USD	$100
Invoice 2	U.K.	GBP	£100
Invoice 3	Germany	euro	€100

The estimated commission reports, commission plan, and commission transaction display the commission amounts converted to USD. This conversion is based on the consolidated exchange rates table for the period in which each transaction was booked:

Amount	Exchange Rate	USD Amount
$100	U.S. to U.S.: 1	$100
£100	U.K. to U.S.: 2	$200
€100	EURO to U.S.:.5	$50

Note:

NetSuite stores the exchange rates used for commission calculations. If the rate on the consolidated exchange rates table changes, the schedule must be recalculated to reflect the change.

A quota for a sales rep associated with the U.S. subsidiary would include sales made for the U.S. subsidiary and its child subsidiaries.

Related Topics