Rewarding partners and sales personnel with commissions for closing sales is a tried and tested method of boosting employee morale and enhancing overall sales productivity. Without an automated system to keep track of commissions due and their payouts, though, it becomes really hard to keep track of sales team performance and earned royalties.
The Oracle NetSuite ERP comes with an Incentive Management module, which provides an easy to use solution for creating and maintaining complex multi-tiered commission plans, including the management and calculation of sales compensation, based on various criteria such as quota, quantity sold, service item, product profitability, and one-time incentives, among others. This module also provides a clear view of incentives/commissions to employees, thereby ensuring that your sales team is fully aware of the latest status of their incentives.
In this post, I’ll show you how to set up partner commission in your NetSuite account. Just follow the steps listed below to do so.
Note: You will need access to the Commission Module in NetSuite in order to set up partner commissions. If you don’t have this module installed already, you will need to buy it from NetSuite. If you want to know more about it, head to our detailed guide on NetSuite Modules.
How to Set Up Partner Commission in NetSuite?
- First, enable the ‘Partner Commissions/Royalties’ feature in NetSuite.
- Then, set your commissions preferences at Setup > Sales > Sales Management > Commissions. These preferences will determine how and when you pay commissions and will affect all commissions set up in your NetSuite account.
- Create a Commission Schedule by going to List–>Commission –> Partner Schedule
The Partner Schedule defines the basis for commission calculations (basically the formula used to calculate commissions).
- Next, create Commission Plan from List–> Commission –> Partner Plan
The Partner Plan is where you associate the Commission Schedule with each Partner, so that whenever that particular partner or partners are found at the transaction level (such as invoices, payments, etc.) their commission for that transaction is automatically calculated.
- Authorize Partner Commissions from Transaction –> Commissions –> Authorize Partner Commission
Now the Partner Commissions are fully setup and their payment process has also been initiated, so whenever an Authorize Partner Commission transaction occurs from now on, the respective partner’s commission will be automatically calculated and will be available for payment in NetSuite.
- To Pay the Commission, just head over to Transaction –> Payables–> Pay Bills
How to Clear Commissions Pending Authorization without Paying Them Out
Once a commission amount has been generated from a sale that meets the commission criteria, it must be authorized in order for it to be available for payment.
If you want to clear these pending commissions without making them available for payment, you just need to enter an offset amount on the ‘Other Transactions’ tab when authorizing the commission. To do that, just follow the steps below.
- Navigate to Transactions > Commissions > Individual Employee Commission.
- In the Employee field, select the salesperson who is meant to receive the commission.
- On the By Transaction or By Period tab, select the amount of commission that you want to clear.
- On the Other Commissions tab, enter an offset amount.
- Click Save.
How to Apply VAT on Partner Commissions
To apply VAT on Partner Commissions, just perform the following steps.
- Create a bill for the VAT amount only.
O Navigate to Transactions > Purchases/Suppliers > Enter Bills
O Select Vendor name & enter the other required information on the Main tab
O On the Expenses tab and the Account column, set the values for the following:
O VAT account
O Amount column = enter 0.00
O On the Tax Code column, select the appropriate VAT code
O On Tax Amount column, enter the tax amount for the commission
O Click Add
O Click Save
What you’ve basically done above is create an additional Payable amount in addition to recognizing VAT on the commission.
- Then, Link the Bill and the Commission by following the steps below.
O Navigate to Transactions > Purchases/Vendors > Pay Single Vendor
O Select ‘Vendor’ on the Payee
O On Apply tab, select the bill and the commission
O Click Save
Recalculating Commissions
Whenever any changes are made that affect commissions, the commission amounts are automatically recalculated in NetSuite. Whenever you make changes to a commission plan or schedule for example, the commission is recalculated. These changes can include:
- Changing the date range for a commission plan assigned to a rep
- Assigning new sales reps to a commission plan
- Editing a commission schedule that is assigned to a plan
- Adding or removing commission schedules from a plan
Changes to transactions can also cause commission recalculation. These transaction changes include:
- Changes to dates, amounts, and other transaction fields
- Changing the order transactions are entered in. For example, backdating a transaction to a previous month will require an update to YTD Quota schedules.
However, not all changes to transaction cause commissions to be recalculated. The following changes for example, do not result in commission recalculation:
- Changes in the sales rep hierarchy (for example, a change in supervisors)
- Changes to quotas
- Adjustments to profits and the Cost of Goods Sold (COGS)
- Item fulfillment
Commission recalculations are performed on a nightly basis. You can see all the commission plans and partner schedules that are set to be recalculated in the Recalculation column on the commission plan and in the commission schedule lists. If a commission recalculation transaction encounters a problem, or if you are recalculating a plan covering a long time period or a plan with complex commission plans, the recalculation process take longer to complete.
You can also initiate commission recalculations manually by clicking the Recalc button when viewing a commission schedule or a commission plan.
Commission is automatically recalculated whenever an order is billed. If you calculate commissions based on profitability or total profit, and bill or invoice customers before fulfillment, then you must manually recalculate commissions prior to payout authorization.
Conclusion
Setting up partner commissions in NetSuite ensures that your sales partners are accurately rewarded for their contributions while maintaining transparency and compliance. By carefully configuring commission rules, assigning partners to relevant transactions, and monitoring payouts, businesses can improve partner satisfaction and strengthen relationships.
Automating this process reduces errors, saves time, and provides actionable insights into partner performance. With NetSuite’s flexible commission management tools, organizations can adapt their commission plans as business needs evolve, ensuring fair and efficient compensation for all partners.
Ready to Streamline Your Partner Commissions? Get in Touch with us
Managing partner commissions manually can be time-consuming and error-prone. NetSuite allows you to automate calculations, track performance, and ensure accurate payouts with minimal effort.
Our experts can guide you in configuring, customizing, and optimizing your partner commission setup so you can focus on growing your business while keeping partners motivated and satisfied. Take control of your partner programs today and maximize performance with NetSuite.
FAQs
1. How do I fix incorrect commission calculations in NetSuite?
Incorrect calculations usually result from misconfigured commission rules or partner assignments. Check the commission schedules, transaction types, and partner roles, and ensure the correct percentages or tiers are applied. Testing with sample transactions before going live helps prevent errors.
2. Can commissions be applied to multiple partners for a single sale?
Yes, NetSuite allows splitting commissions among multiple partners. You need to define multiple partners on the transaction and assign the percentage or fixed amount for each. This ensures fair distribution and accurate reporting.
3. How can I track partner performance efficiently?
Use NetSuite reports and dashboards to monitor commissions earned, pending payouts, and performance metrics. Saved Searches or SuiteAnalytics Workbooks can provide detailed insights into top-performing partners and identify areas for improvement.
4. What should I do if a partner disputes a commission?
NetSuite maintains transaction-level records for all commissions. Review the relevant transaction, partner assignment, and commission rules to resolve discrepancies. Having clear rules and audit trails makes dispute resolution faster and more transparent.
5. How do I update commission rules without affecting historical data?
NetSuite allows you to create new commission schedules or rules while preserving historical transactions. Make changes carefully and test on new transactions to ensure that past commissions remain unaffected.
6. How do I handle commission adjustments or retroactive changes?
Use commission adjustment records or scripting to update historical transactions.
Steps:
- Go to Transactions → Financial → Commission Adjustment.
- Select transaction and adjust commission manually or via CSV import.
- For automated adjustments, use SuiteScript to recalculate:
var oldCommission = record.getValue({ fieldId: 'custbody_partner_commission' });
var newRate = 0.06; // new rate
var totalAmount = record.getValue({ fieldId: 'total' });
record.setValue({ fieldId: 'custbody_partner_commission', value: totalAmount * newRate });
7. How can I validate that commissions are calculated correctly?
Validation can be done via Saved Searches or Workbooks.
Steps:
- Create a Saved Search for transactions with commissions:
- Filters: Transaction Type = Sales, Commission not empty
- Columns: Partner, Transaction Amount, Commission Amount
- Cross-check totals against expected percentages.
- Optionally, export to Excel and use formulas for verification.
Output:
- Detects discrepancies or misconfigurations quickly
- Ensures payouts match intended commission rules
8. How do I implement tiered or performance-based commissions?
Tiered commissions require either multiple commission schedules or custom SuiteScript logic.
Steps:
- Define commission tiers in schedules (e.g., 5% for sales < $10k, 7% for sales ≥ $10k).
- Assign schedules to partners based on roles or sales volume.
- For dynamic tiers, use SuiteScript to calculate tiered rates:
var salesAmount = record.getValue({ fieldId: 'total' });
var commission = 0;
if(salesAmount < 10000) commission = salesAmount * 0.05;
else commission = salesAmount * 0.07;
record.setValue({ fieldId: 'custbody_partner_commission', value: commission });
Output:
- Commission automatically scales with performance
- Accurate tier-based payouts and reporting
