Published Apr 25, 2017; last updated Apr 4, 2019.
What is the best way to calculate sales commissions in QuickBooks?
This is a challenge that many businesses face when handling payout for their sales teams.
Currently, QuickBooks does not offer any complete solution for calculating and tracking commissions. Of course, there are many workarounds that allow you to process these numbers — to an extent.
Here’s a common scenario many businesses face: how to track sales commissions on specific items, excluding any associated tax or shipping fees on an invoice. In order to calculate this payout, one would need to create a class within QuickBooks, then a subclass for every sales rep, manually calculate commissions for every item based on each person, and finally create a commission report.
Sounds tedious, right?
This is the reality of running commissions. In many cases, businesses are manually calculating with pen and paper or tracking numbers on spreadsheets in order to complete payout for their sales teams.
Is there a solution to make the process easier?
Given the multi-faceted nature of commissions, a ‘one-size-fits-all’ commission calculator does not exist. However, it is possible to condense endless spreadsheets, workarounds in QuickBooks, and time spent with your desktop calculator into one simple click.
How does this work?
With Method:CRM, you can save hours
What does the commission calculator look like?
The commission calculator app will be unique for every business, depending on your design preferences and end goals. You can include date ranges for running commissions, use a search function to check commission amounts by customer invoice, generate reports specifically for sales reps, and incorporate any other functions that are required.
How do I get started?
First, make sure you’ve integrated your QuickBooks sales data with Method
Once you’ve synced your QuickBooks account with Method
Ready to streamline your commission tracking?
Sign up for a free 30-day trial of Method:CRM, rated the #1 CRM by QuickBooks users on apps.com.
Includes a free demo and 1 free hour of customization services.