Commission calculation can be difficult. And there are so many people to get upset if it doesn’t calculate properly.

Three of our clients shared with us how CAL has helped them set up systems to streamline commission calculation:

  • Leslie Alt, Senior Software Support Specialist at Fidelux:

“In the past, commission calculation was done manually on spreadsheets. In Acumatica, we were able to build a tab into the sales order that integrates with accounts payable. Now, when payment is received for the invoice associated with the sales order, then the commission is paid. That way commissions are only paid after we have received the money. In the future, we may make some improvements to handle more complex multi-invoice scenarios, but already it has definitely been a big time saver for us. And the sales teams are happy because they get paid faster.”

Read the full case study: Lighting Manufacturer Saves Money with Rapid Implementation of Flexible Acumatica Cloud ERP System

  • Kerri Tiano, Financial Operations Manager, Crown Maple:

“The commission report was something that took me a bare minimum of 3 hours a month when I started. I had no idea what I was doing with it, and it was all manual. Every bit of it that I did was manual, and it was painful. So then I called CAL to see what they could do for me, and they were able to create this report, and literally, it takes me 10 minutes now. Ten minutes. It’s a couple of clicks, it’s done, I get the guys their commissions, they’re happy, we’re happy. It can’t be better.”

Read the full case study: Maple Syrup Manufacturer/Distributor Goes From Bark To Bottle With Microsoft Dynamics GP and SalesPad

  • Rich Larkin, Director of Operations, Innovative Medical Products:

IMP needed a way for their 35 outside sales reps to be able to see their commission data on a real-time basis. In the past, checks were mailed out monthly with a consolidation report to show how their commissions were calculated, and a second report of new invoices that came into the system. It took one IMP employee a solid three days each month to print, sort, staple, stuff, and mail the 500+ pages.

Rick Larkin, an experienced Microsoft Dynamics GP user, decided to build an online portal using Microsoft SQL Server Reporting Services (SSRS).  The sales reps now receive their checks electronically via ACH transfer, then securely log into the online site to see how their checks were calculated. “Microsoft Dynamics GP is so flexible. The SSRS report was up and running in about a week,” says Larkin.

Read the full case study: Medical Device Manufacturer & Distributor Increases Order Accuracy and Processing with Microsoft Dynamics GP and SalesPad Data Collection

How are you handling commission calculation? If you would like to discuss how to make this process more efficient in Microsoft Dynamics GP or Acumatica, contact CAL Business Solutions at 860-485-0910 x4 or

By CAL Business Solutions, Microsoft Dynamics GP and Acumatica Partner,