Manual Commissions and scheduling Prepaid Expense Amortization

By | November 25, 2021

Greytrix Sales Commission Application for Sage Intacct is beneficial for Sage Intacct users to calculate and pay a sales commission to the respective salesperson to achieve better efficiency and save time in calculating commission, excluding tedious work of manual commission calculation.

We will discuss the calculation of one of the types of Commissions that are not related to any AR or Sales Invoices. Such commissions can be calculated and posted through a separate screen/interface from our Sales Commission application.

Depending on the selected Commission Structure, the application will calculate commission for one or more salesperson /employees associated with the commission group.  If multiple salespeople are assigned to the Group, the commission will allocate as per the specified commission split percentage. Below is the custom interface designed by us. Upon saving the details, click the Calculate Commission button.

Manual Commission Header Information

Commissions will be calculated and the results will be displayed in the detail section below.  To override the commission percentage taken from the applied Commission structure is also possible through the “Override Commission Percent” field seen in the above screen.

A custom screen for setting up date wise target sales for employees/salespersons is a feature to offer additional commissions on the extra sales above the set targets.

Employee Commission Levels Information

After successful commission calculations, the employee commissions will be available to post. Click on Post Commission for posting the expenses to general ledger. For the GL entries, the accounts consumed will be as selected on commission group or global configuration of the application. Throughout the process, statuses are maintained to track the employee commissions are calculated, posted or paid.

Manual Commission HeaderPay Commission function designed for paying the commissions over Invoices is used to pay commission entries attached with manual commissions as well.

With our Sales Commission application, commission payments can be amortized by integrating it with Prepaid Expense Amortization. To amortize, check the” Generate PEA Schedule” flag seen in the Manual Commission add screen below.

Generate PEA Schedule

Prepaid Expense Amortization (PEA) Schedule will be generated with “ASC 606” prepaid expense class and manual commission amount, dimensions (customer, location, and department). User will need to manually generate the amortization schedule entries from the standard PEA Schedule screen and triggering the Generate Amortization Schedule.

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 | | 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 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 We will like to hear from you.