Commission calculations and postings

By | December 24, 2021

Sales Commission App for Sage Intacct simplifies commission tracking and ensures accurate commission calculations and timely payment to sales representatives. So, after Setting up commission structure as the key component of our Sales Commission app., Sage Intacct users can easily do the commission calculations and automate commission Posting and payments on sales transactions.

In this blog, we will discuss how the commissions are calculated and posted in Sage Intacct using our Sales Commission app. Users are able to calculate the commissions on posting the sales transactions into the Sage Intacct. Our application is integrated with Order entry, Accounts Payable and General Ledger. For calculating the commission, our application provides you some custom screen to define commission structure. Once, the commission structure is defined as per your business requirement, the whole commission calculation process is automated and the user is able to process the post and pay commission function in the Greytrix Sales Commission App.

Commission Calculation
When the users post the sales transaction, users have to select the commission group and commission type for that particular transaction at line level as it is defined in the commission structure. For each line item, by clicking on ‘Show Details’, a panel will appear wherein you can select ‘Commission Plan’ and ‘Commission Type’.

AR-Line-Level

If no Commission Plan is selected, then the Commission Plan of the selected Customer will be applied to it. If no Commission Type is selected and the Account label used in the transaction has a Commission Type associated with it, then the associated Commission Type would be assigned as default for the line item. Otherwise, the Commission Type of selected Item will be applied by default.

Once, the user posts the sales transaction, our app calculates the commission. After posting these transactions as per the matrix defined automatically, the commission for the transaction is calculated.

Post Commission
After the commission is calculated, we have two custom screens:

1. Post commission
2. Pay commission


Post-commission means whatever commissions calculated for the sales transaction are allocated to the respective salesperson as defined into the commission structure.

Post Screen

The Post Commission screen displays Invoices from the ‘View Invoice Commission’ list with status as ‘Completed’. Here, the user can filter records using fields such as Invoice No., Invoice created date and Customer. On clicking ‘View’ button, we can see a list of Invoices that has commission of all line items calculated. If filters are used, only the list of Invoices within the filtered range will be displayed as shown below:

Post Commission Entries

On click of the ‘Post’ button, the Sales commission app distributes the calculated commission among all the salespersons. Along with this, the payable commission is posted as a GL entry using the expense account mapped in the configuration screen. Users can see the calculated commissions on the ‘View Invoice commission’ screen in Sales commission App or on the respective AR invoice.

About Us

Greytrix – a globally recognized and one of the oldest Sage Development Partner is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience and expertise, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation competence.

Greytrix has a wide product range for Sage Intacct- a Cloud ERP. This includes migrations from QuickBooks | Sage 50 | Sage 100 | Sage 300 to Sage Intacct. Our unique GUMU™ integrations include Sage Intacct for Sage CRM | Salesforce | FTP/SFTP | Rev.io | Checkbook | Dynamics 365 CRM | Magento | Rent Manager | Treez | Avalara Avatax | Blackline SFTP. We also offer best-in-class Sage Intacct Development Services, Consulting services, integrated apps like POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage Intacct to Sage business partners, resellers, and Sage PSG worldwide. Greytrix constantly develops apps, products, and add-ons to enhance user experience. Sage Intacct add-ons include AR Lockbox File Processing. Greytrix GUMU™ integration for Sage CRM – Sage Intacct, Sales Commission App for Sage Intacct, and Checkbook.io ACH/Digital Check Payments for Sage powered by GUMU™ are listed on Sage Intacct Marketplace.

The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for the processing and execution of application programs at the click of a button.

For more information on Sage Business Cloud Services, please contact us at sagecloud@greytrix.com. We will like to hear from you.