alphabold
One would think that tracking sales commissions in NetSuite without the ‘Commissions / Incentive Management’ module can be challenging; consequently, many companies resort to managing commission calculations in Excel. At AlphaBOLD, we try to do everything that we can to keep your reporting and commission tracking in the system while avoiding the need for Excel.
This short article is the first in a two-part series. It is intended for NetSuite Administrators and Sales Managers who:
In the first part, we will show you how to create commission schedules by using NetSuite’s custom records. The schedules, along with the sales data (actuals), can then be transferred to any BI tool which will manage complex calculations and presentations.
In our example, we are using a simple schedule with basic fields that will allow you to:
We created our ‘custom record type’ by following this navigation path:
Below is what the finished product will look like:
Let AlphaBOLD guide you through optimizing your commission processes. Contact us today to explore our comprehensive NetSuite services and solutions.
Request a DemoOnce we import the schedule data, this is what it will look like for each of our employees:
We attached the schedule to the employee record so that the Sales Manager or the Administrator can easily adjust them.
Now that this is completed let us create a simple Analytics dataset, ‘schedule’ data that we can use in future calculations.
Streamline your ERP selection process with our comprehensive checklist, ensuring you make informed decisions for your business's future success.
Learn more
Now that we have a ‘Commissions Schedule’ dataset, we need to create a dataset/report for our actual sales. This is a simple task with SuiteAnalytics Workbooks.
To create a new dataset, just like above:
Contact us to capitalize on our NetSuite Support Services tailored to your business's unique challenges.
Request a Demo
Please note, we will tie actuals to our sales rep commission schedules through our Sales Rep / Employee fields. Our next task is to join the datasets that we built together into a single report and perform appropriate commission calculations. Read more about how we can accomplish this in our second part of the ‘How to handle commissions in NetSuite’ article.
Thanks for your time, and feel free to provide feedback and questions in the comments section below.
In this blog post, we learned how to create and commission schedules using NetSuite custom records. Read more about how we can accomplish this in the second part of the ‘How to handle commissions in NetSuite’ article. Thanks for your time, and feel free to provide feedback and questions in the comments section below.
Read the next part, How to handle commissions in NetSuite (Part 2)
