2/3 H2O Business Park, Lake View Drive, Nottingham
0115 758 8888

NetSuite tips – have you tried NetSuite’s commission feature?

#

Our NetSuite tips are designed to help you get the most out of using NetSuite. This month’s guide is all about NetSuite’s commission feature.

The commission module (‘incentive compensation management’) is available as an additional module to NetSuite customers. This feature allows employers to easily pay their sales reps / partner reps commission either as part of their wages or by payable cheque (treated as an accounts payable transaction).

This can be a really useful module for companies who need to motivate their sales team with an effective incentive. You don’t have to work with complicated spreadsheets or import data between applications, as your sales compensation can be easily handled within NetSuite. Here we explain how works and how you set it up.

Commissions

With NetSuite, you can design complex, multi-tiered commission plans that complement your company’s sales strategy.

The NetSuite sales compensation feature is seamlessly integrated with its accounting features. When deals are entered, commission is automatically calculated by the system based on how you have set it up.

Your team benefits from this integration because they will know how much commission they have earned before they receive it. With their NetSuite dashboard, sales reps can view estimated and actual commission in real time.

Using the Employee Commissions feature

To begin using the Employee Commissions feature, an administrator needs to turn on the feature at Setup > Company > Setup Tasks > Enable Features (Administrator). The feature is on the Employees subtab.

NetSuite _tips_enable_features

If your company offers incentives to partners for sales, you can also use the Partner Commissions & Royalties feature.

To begin using the Employee Commissions feature there are 3 key things you need to do:

  1. Set your commissions preferences at Setup > Sales > Sales Management > Commissions (Administrator). These preferences determine how and when you pay employee commissions and affect all commissions set up in your NetSuite account.
  2. Create employee commission schedules at Forecast > Commissions > Employee Schedules > New (Sales Administrator). Commission schedules define the rules that determine how commissions are calculated. Schedules can be based on total sales, percentage of quota met, quantity sold, total profit or on profitability.
  3. Create and assign employee commission plans at Forecast > Commissions > Employee Plans > New (Sales Administrator). Employee commission schedules are placed in commission plans that are assigned to your sales reps. You can include multiple commission schedules in a single plan, and you can assign more than one sales rep to a plan. You cannot, however, assign a sales rep to more than one commission plan for the same date range.

Setting your commission preferences

You can set company commissions preferences at Setup > Sales > Sales Management > Commissions. You can set the following preferences:

Commissions Paid By Default On – choose when commissions are eligible to be paid. Your options are:

  • Billings/Bookings – When the sales transaction is invoiced, or in the case of commission based on alternate sales amounts (ASA), when sales orders are booked and approved
  • Collections – When payment is received partially at billing / booking and partially upon receipt of payment

Note: Changing this preference does not affect existing schedules.

Allow Overwrite in Schedules – Tick this box if you want to overwrite commission schedules when commissions become eligible. If you leave this box unchecked, the Eligible Amount field on commission schedules is a read-only field.

Commission Eligibility Period – If you want to wait for a number of days after the sale is made or billed before paying commission to sales reps, enter the number of days here.

Calculate Commissions on Shipping Items – Tick this box to include shipping costs when calculating a transaction’s commission amount. (This preference will be applied to only new transactions).

Require Accounting Approval of Employee Commissions – Check this box to require your accounting department to approve employee commissions and payments.

Note:  Supervisor authorisation of commissions is required whether or not accounting approval is required.

Require Accounting Approval of Partner Commissions – Tick this box to require your accounting department to approve partner commissions and payments.

Maximum Commission Brackets – Enter the maximum number of brackets to include in commissions schedules.

Note: If you decrease this number after entering commission schedules, you can lose columns of data in the existing schedules.

Default Employee Commissions Expense Account – Select the expense account to which you want employee commission payments to post by default.

  • You can select a different account on the commission transaction.
  • Leave this box clear if you do not want a default account.

Default Partner Commissions Expense Account – Select the expense account to which you want partner commission payments to post by default.

  • You can select a different account on the commission transaction.
  • Leave this box clear if you do not want a default account.

You can choose to pay commissions on your employees’ regular paycheques if you use the NetSuite Payroll feature.

Company commission preferences apply to everyone with access to your NetSuite account.

Important

Sales transaction pages such as Sales Order, Invoice, Credit Memo, Cash Sales, Cash Refunds, and Return Authorisations have an ‘Exclude Commissions’ box. Ticking this check box excludes the transaction and its subordinate transactions from inclusion in all commission calculations.

Creating your Employee Commission Schedules

You can create employee commission schedules at Forecast > Commissions > Employee Schedules > New (Sales Administrator).

Your commission schedules determine how commission is calculated. You then combine these schedules in commission plans to which you assign your sales reps. You can include one or more commission schedules in a commission plan.

NetSuite_tips_employee_commission_schedules

During the period a sales rep is assigned to a commission plan, any transaction they enter is compared to the criteria in the commission schedules. If the sale qualifies, a commission amount is awarded. After commission is earned, it appears on commission reports and KPIs that can be viewed by you and your sales reps in real time.

Creating and assigning Employee Commission Plans

Commission payments are calculated by commission schedules that are assigned to a plan. Multiple schedules can be applied to a single commission plan. You must create commission schedules before creating a commission plan.

Sales reps are assigned to commission plans. A rep can be assigned to only one plan at the same time. If you decide to update a commission plan during the period of time it is active, commission is recalculated for each sales rep in the plan.

Authorising and approving Employee Commissions

The sales supervisor must confirm that the calculated commission amounts are correct and then create a commission payable transaction.

You can also set a preference to require accounting approval for commission payable transactions.

  • If you do not enable this preference, authorising the commission also approves a cheque to be prepared to pay the commission.
  • If you do enable the preference, when you authorise the commission it goes to the accounting approval queue before a cheque can be prepared.

NetSuite_tips_authorise_commissions

To require accounting approval before the payment of commissions, go to Setup > Sales > Commissions and select Require Accounting Approval of Employee Commissions.

NetSuite_tips_approving_employee_commissions

The accounts department must then approve the commission payments:

NetSuite_tips_approve_commissions

 

Paying Employee Commission

You can choose one of two methods to pay commissions to employees:

  • On paycheques – commission payments show on the cheque stub as a payroll earning item. (To pay commissions on paycheques, you must have the Payroll feature enabled.)
  • On payable cheques – commission payments are treated as an accounts payable transaction.

Commission Reports

You can run a variety of useful commission reports in NetSuite. Some of the standard reports you may wish to run are as follows:

  • Commission Overview Report
  • Authorised Commission Summary Report
  • Paid Employee Commission Summary Report
  • Commissions on A/P Aging Reports

I hope this has been a helpful walkthrough for managing commissions in NetSuite. If you would like to find out more about how NetSuite works, please don’t hesitate to get in touch with our team of experts or view our other ‘NetSuite tips’ guides below.

Feel free to share this guide with your colleagues or comment below.

Leave a comment