How To Create Commission Reports In Quickbooks Desktop And Online?

By Author: Jack Edwards
Total Articles: 14
Comment this article

It can be difficult to handle employee and sales representative commissions without the proper resources to do so. That’s the good news – thanks to its robust features,  QuickBooks makes it possible to meticulously track, calculate, and report on commissions.

In this post, we will go over how to create Expanded Commission Reports Quickbooks, along with detailing how to customize reports in QuickBooks for better financial insight.

What is Commission Tracking in QuickBooks?

There is no built-in commission report in QuickBooks, but once you have the basis of one, you can just customize any financial report to show that information. Commissions can be traced based on custom fields, sales transactions, or mapping items and classes for sales reps.

Set Up Sales Reps:

On the toolbar, click Lists > Customer & Vendor Profile Lists > Sales Rep List.

Attach each initial or name of each salesperson.

Allocate transactions to sales reps:

Be sure to enter the applicable sales rep for each transaction when you are building ...
... invoices or sales receipts.

Customize a Sales Report:

Navigate to Reports > Sales > Sales by Rep Summary.

This will provide you with the total of revenue from each rep.

For a more detailed list, click Sales by Rep Detail.

Manually Adding Commission Rates:

Export the report to Excel.

Write a formula to multiply total sales by each rep’s commission rate.

Use this to determine individual commission outside of QuickBooks.

Save Your Custom Report:

Once you have customized the report to your specifications, click the Memorize button to save it for use later.

How to Record Commission Reports in QuickBooks Online?

QuickBooks Online doesn’t offer native commission tracking, but you can compensate for this using custom fields and reports.

Add a Custom Field:

Navigate to Settings > Custom Fields, and set up a field titled: “Sales Rep.

Assign Sales Reps on Transactions:

Enter the sales rep into the sales rep field on all invoices or sales receipts.

Run a Sales Report:

Reports > Sales by Customer Summary or Sales by Product/Service Summary.

Personalize the report with new filters on the custom “Sales Rep” field.

Excel Export for Commission Calculations:

As with the Desktop version, you can export the data and create your commission formula in Excel.

Automating with Third-Party Tools (optional) If you don't want to manually follow the steps above every single time you check your modifications in, then the following third-party tools might help.

Customizing Reports QuickBooks For A Clearer Picture Of Your Business

You can quickly and easily Customize Reports in Quickbooks Desktop and Online versions Intuit’s QuickBooks In both QuickBooks Desktop and QuickBooks Online, you are able to customize reports by either:-based on the information that is most important to your business.

• Adding/removing columns

• You can filter by customer, sales rep, or item

• Data set at rep, date,  location

• Saving custom templates for re-use

This flexibility allows you to transform typical Financial Reports QuickBooks statements found in QuickBooks, into valuable commission tracking reports that work for your business.