Originally published Apr 25, 2017; updated Jan 16, 2019.

What is the best way to track 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 tracker 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 create a fully customized commission tracker designed to manage your specific sales needs. This customization process can be performed on your own or by Method’s customization services team, depending on the complexity of your commission structure.

What does the commission tracker look like?

The commission tracker 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.

Additionally, Method:CRM integrates seamlessly with QuickBooks and pulls any necessary sales or customer information into the system to help make the commission calculation process easier.

Learn how creating a customized sales commission tracker can save hours for your business.

How do I get started?

First, make sure you’ve integrated your QuickBooks sales data with Method:CRM. If you don’t have an account, you can start a free 30-day trial. During your trial, check out Method’s other sales features, which includes lead and opportunity management, customer management for your sales reps, and custom reporting.

Once you’ve synced your QuickBooks account with Method:CRM, chat with our customization team and share what you are looking for in a sales commission tracker. You’ll receive 1 free hour of customization services to help you get started!

Ready to get started with customized commission tracking?

Sign up for a free 30-day trial of Method:CRM, rated the #1 CRM by QuickBooks users on apps.com.

Method CRM free trial button

Includes a free demo and 1 free hour of customization services.

Image credit