NetSuite Changelog
Employee ManagementNew FeatureRelease Notes

Employee Commission Data Import Process in NetSuite

Import employee commission data in NetSuite using a CSV template to streamline your sales compensation processes.

·2 min read·View Oracle Docs

You can import precalculated commission data as a CSV file into NetSuite. This process enables you to integrate commission data seamlessly, enhancing how you manage and incentivize your sales team.

Steps to Import Commission Data

  1. Export Current Commission Data: Begin by exporting your commission data from your existing system. This forms the basis for your import into NetSuite.
  2. Modify Data for NetSuite: Adjust your data to align with NetSuite's import specifications before importing.
  3. Import the CSV File: To import commission data, navigate to Transactions > Commissions > Authorize Employee Commissions. Then click Import and follow the link to download a CSV template. After importing commission amounts, NetSuite will modify the commission basis and calculated commission amounts on related transactions, adjusting them to show $0.

CSV Template Structure

When preparing your CSV file, ensure it contains the following columns:

ColumnPurposeRequirements
ASales RepEnter the employee's name. Ensure the Sales Rep box is checked on the employee record to import data.
BTransaction TypeSelect a transaction type: Invoice, Cash Sale, Cash Refund, or Credit Memo.
CTransaction NumberEnter the transaction number for which the commission applies.
DAmountInput the commission amount. For negative amounts, precede the figure with a -.

Key Considerations

  • Feature Enablement: To utilize the Employee Commissions feature, an administrator must enable it at Setup > Company > Setup Tasks > Enable Features, found under the Employees subtab.
  • Commissions Preferences: Be sure to set your commissions preferences at Setup > Sales > Sales Management > Commissions (Administrator). These settings influence how you compensate employees and apply to all commissions in your account.
  • Commission Schedules: Create employee commission schedules to define how commissions are calculated based on various metrics, such as total sales or percentage of quota met.

Related Topics

Familiarize yourself with these related topics to enhance your understanding of employee commissions in NetSuite:

  • Commissions Overview
  • Split Commission
  • Approving and Rejecting Employee Commissions
  • Viewing Commission Statuses
  • Commission and Advanced Billing

By effectively managing commission imports, you ensure that your sales team is motivated and correctly compensated, optimizing their performance and contributing to your organization’s success.

Frequently Asked Questions (4)

Do I need to enable any specific feature to import employee commission data in NetSuite?
Yes, you need to enable the Employee Commissions feature. This can be done by navigating to Setup > Company > Setup Tasks > Enable Features and then accessing the Employees subtab.
What permissions are required to import commission data into NetSuite?
The article does not specify exact permissions required. However, typically importing data would require appropriate roles or permissions that allow access to the Commissions and setup tasks in NetSuite.
What should I do if the imported commission amounts show as $0 in NetSuite?
After importing commission amounts, NetSuite automatically modifies the commission basis and calculated commission amounts on related transactions, adjusting them to show $0. This is expected behavior upon import.
How do commission preferences affect commission data imports in NetSuite?
Commission preferences, set at Setup > Sales > Sales Management > Commissions (Administrator), influence how employee commissions are managed and applied across all your account's transactions.
Source: Importing Employee Commission Data — Oracle NetSuite Help Center. This article was generated from official Oracle documentation and enriched with additional context and best practices.

Was this article helpful?

More in Employee Management

View all Employee Management articles →