How to Attach a Sales Rep Commission in QuickBooks

  • Small Business
  • Running a Business
  • ')" data-event="social share" data-info="Pinterest" aria-label="Share on Pinterest">
  • ')" data-event="social share" data-info="Reddit" aria-label="Share on Reddit">
  • ')" data-event="social share" data-info="Flipboard" aria-label="Share on Flipboard">

How to Add Retroactive Pay in QuickBooks

How to add payroll items to multiple employees in quickbooks, how to put aflac after tax items into quickbooks.

  • How to Reimburse Expenses to an Employee Using Payroll in Quickbooks
  • How to Build an Application for Payroll

When your sales representatives earn commission from a sale, you can add the value of the commission on top of their regular pay. Whether your sales representatives are independent contractors or employees, you can configure QuickBooks to pay them appropriately. Once the commission has been entered into QuickBooks, you can write a check or process payroll to render payments. Independent contractors should be added to your sales forms to provide better tracking. For employees, add a commission payroll item on the employee record.

Independent Contractors

Click "Vendor Center" to edit or add your sales reps information and ensure they are set up as a 1099 Vendor.

Double-click the name of a current vendor or select "New Vendor" and enter the sales rep's information.

Select the "Additional Info" tab and complete the Tax ID field. Select the "Vendor Eligible for 1099" check box. If you have other sales reps to add, click "Next." Otherwise, click "OK."

Click the "Lists" menu and "Customer & Vendor Profile Lists." Select "Sales Rep List" to add the sales rep to your Sales Rep list.

Click the "Sales Rep" button and click "New." Choose a name from the Sales Rep Name drop-down list and click "Next" to add another rep. Otherwise, click "OK."

Create your invoice as normal and select the "Rep" drop-down list. Add your sales rep to the invoice. If your invoice doesn't have a Rep field, you must add it. Click the "Lists" menu, "Templates" and "Edit." Click "Additional Customization" and select the "REP" check box. Click "OK" twice to add the Rep field to your sales receipt.

Click the "Reports" menu, "Sales" and "Sales by Rep Summary Report." Select "Filter" and "Name." Enter the name of the rep and run the report to determine the commission you owe.

Write a check to pay the contractor using the Pay Bills or Write Check window.

Select the "Employee Center" and the "Employees Tab." Click "New Employee."

Click the "Personal," "Address and Contact" and "Additional Info" tabs. Complete the information in each tab for your employee.

Set the "Type" drop-down list to "Regular."

Click the "Lists" menu and "Customer & Vendor Profiles Lists." Click "Sales Rep List."

Click the "Sales Rep" button and "New." Select the name of your employee from the drop-down list and click "Next" to add more employees or click "OK" to close the window.

Click the "Change Tabs" drop-down list and select "Payroll and Compensation Info." Complete the required information in the "Payroll Info" tab. Select the "Add a Commission Payroll Item" in the Earnings section. Enter a commission percentage in the Hourly/Annual field. If you haven't set up a commission payroll item, click "Lists" and "Payroll Item List." Select the "Payroll Item" button and "New." Select "Custom Setup" and "Next." Then, select "Commission Payroll Item" and follow the instructions. Click "Finish."

Select the "Reports" menu, "Sales" and "Sales by Rep Summary Report." Select "Filter" and "Name." Enter your employees name and run the report to determine the total sales amount.

Enter the total sales amount in the Quantity field when running payroll to pay your employee. The commission based on the sales amount and the percentage you entered into the employee's record are automatically calculated.

  • QuickBooks: Pay Commission to Sales Representatives
  • QuickBooks: Tracking and Paying Commissions Based on Sales
  • QuickBooks: Set Up a Commission
  • Information in this article applies to QuickBooks 2013. It may vary slightly or significantly with other versions or products.

Avery Martin holds a Bachelor of Music in opera performance and a Bachelor of Arts in East Asian studies. As a professional writer, she has written for Education.com, Samsung and IBM. Martin contributed English translations for a collection of Japanese poems by Misuzu Kaneko. She has worked as an educator in Japan, and she runs a private voice studio out of her home. She writes about education, music and travel.

Related Articles

How to add employees in quickbooks, how to pay employees on quickbooks for mac, how to do payroll checks in quickbooks, how to change an existing employee's withholdings in quickbooks, what report in quickbooks reconciles gross & net pay for employees on special days, how to accrue payroll for commissioned employees, where to enter vacation hours in quickbooks pro, how to use direct deposit in quickbooks with another provider, how to make an incentive chart, most popular.

  • 1 How to Add Employees in QuickBooks
  • 2 How to Pay Employees on QuickBooks for Mac
  • 3 How to Do Payroll Checks in QuickBooks
  • 4 How to Change an Existing Employee's Withholdings in QuickBooks

Tracking Sales Commissions in QuickBooks Online Explained

What is a commission tracker.

A commission tracker is a tool designed to help businesses keep track of their employee commission payments. It records all the details of each sale and gives a detailed view of how much each employee earned for a particular period of time.

This data can then be used to accurately calculate and pay out commissions directly to the appropriate employees. Commission trackers also enable businesses to better manage their payrolls by providing insights into their sales performance, customer trends, and other key indicators.

With this information, they can adjust their sales strategies accordingly and ensure that sales reps are being paid fairly based on their contributions to the organization.

Can you track commissions in QuickBooks Online?

Currently, QuickBooks Online does not offer a built-in sales commission calculation feature. However, according to this article from Quickbooks , you can monitor your sales by sales rep using Class Tracking and Location Tracking features.

Once you have the Class or Location list setup, you can assign each employee to a Class or Location. This will enable you to run sales reports by Class or Location that display how much each individual salesperson sold.

Now that you have how much each individual salesperson sold, you can multiply that number by each salesperson's commission percentage and then go to the Write Check window to pay your salesperson.

While this process may be straight-forward for a small business with flat-rate or single-rate commission structures, it will be difficult for a larger company with complex commissions and multiple incentive plans to track commissions effectively.

Is it worth investing in Quickbooks commission tracking software?

When it comes to your sales team, accurate and timely tracking of commissions is essential. Fortunately, commission tracking software can provide the data—and insights—that you need to keep on top of this process.

Here are 5 reasons any sales manager will want to consider investing in a robust commission tracking software for Quickbooks Online.

1. Streamline the process of tracking commissions for employees and sales reps

It can be a daunting task for businesses to keep track of commissions for their employees or sales representatives. With so many transactions happening on a daily basis, it's easy for things to get lost in the shuffle. However, streamlining the process of tracking commissions can make a significant difference in the efficiency of any organization.

By utilizing software and tools specifically designed for commission tracking, businesses can ensure they are accurately paying out commissions and reducing the chance of errors and disputes.

Providing a streamlined process also promotes transparency and accountability, which can lead to increased motivation and job satisfaction among employees and representatives.

2. Automatically calculate sales commissions to ensure accurate payments and timely delivery

When it comes to compensating sales people, accuracy and timeliness are key. Manual calculations leave ample room for error, leading to costly mistakes and unhappy employees.

That's where automatic sales commission calculations come in. By streamlining the process and removing the risk of human error, you can ensure that your sales team is paid correctly and on time.

With automated calculations, you'll be able to easily track performance and adjust sales commissions accordingly, while freeing up valuable time and resources that can be better spent elsewhere.

3. Reduce administrative costs by eliminating manual data entry

By eliminating the need for manual data entry, companies can save both time and money while also improving the accuracy and efficiency of their operations.

A commission tracking software, like Kinitro , can sync transactions from Quickbooks Online and automatically calculate commissions with variable commission rates, such as tier-rates, progressive rates, etc. Depending on your company settings, each transaction will be associated with a sales rep and can roll-up for team credit.

With our Quickbooks Online integration, each commission record will automatically be exported to Quickbooks depending on the accounting method you have setup reducing manual data entry.

4. Motivate staff by providing real-time visibility into their performance and progress

Motivating team members is essential for maintaining a productive and high-performing workforce. By offering real-time commission plan statements and dashboards, sales reps gain visibility into their performance.

With constant feedback on important performance metrics, team members can track their progress and understand where they need to improve. More importantly, the real-time feedback acknowledges and reinforces their efforts, making them feel valued and motivated to continue working hard.

Ultimately, by motivating sales reps through real-time visibility and feedback, managers can create a high-performing and collaborative team culture.

5. Easily generate reports for analysis so you can make more informed decisions about compensation structure

Analyzing your compensation structure can help you make decisions that promote fairness and increase productivity in your organization. Generating reports that illustrate key components of your compensation structure is crucial to arrive at accurate conclusions.

Armed with data-driven insights, you can make informed decisions about sales commission plans, improve retention rates, and ultimately drive better business results.

The best way to track and calculate sales commissions in QuickBooks

If you have a small team with one or two commission rates, then you may find it easy to track commissions in Quickbooks using location tracking or class tracking.

However, if you have a large team with variable commission structures , investing in commission tracking software for Quickbooks is an invaluable resource that has the potential to increase profitability and optimize business operations.

With commission tracking software for Quickbooks you can easily streamline commission calculations, provide real-time reporting for your sales reps, track payouts, and sync accounting records back to Quickbooks.

It provides detailed insights into key metrics that could otherwise be overlooked or difficult to track manually, allowing businesses to make informed decisions about how they allocate resources and compensate employees.

Related posts

commission vs salary

Sales Commission vs Salary vs Salary Plus Commission: Pros and Cons of Each

commissions paid report in quickbooks

A Guide to Typical Sales Commission Structures

commission-planning

The Top 7 Sales Commission Plans of 2023

Sales Commissions Explained

Sales commissions made easy.

Uncategorized

Calculating Sales Commissions With QuickBooks Online

commissions paid report in quickbooks

Do you need to calculate  sales commissions  using QuickBooks Online transactions? Perhaps you already are calculating commissions using CRM data, but found that payment status / amounts were often inaccurate? Or perhaps you’re manually calculating sales commissions from QuickBooks data, but no longer want to deal with manually generated, cumbersome sales commission spreadsheets?

Using  Sales Cookie , you can calculate sales commissions using QuickBooks Online data. Connecting to QuickBooks Online takes less than 1 minute. Each sales rep will get an online  incentive dashboard  they can use to review crediting, check payouts, and more – from any device. Your sales reps will always be paid the right amount – on time. Making changes to your commission plans and generating commission reports will be easy. Even the most advanced types of sales commissions are supported (those with tiers, draws, splits, formulas, etc.).

Here are the simple steps to use:

  • Verify QuickBooks Online readiness
  • Sign up for a free Sales Cookie account
  • Add a connection to QuickBooks Online
  • Add users and transactions from QuickBooks Online
  • Create sales incentive plans
  • Run commission calculations
  • View incentive dashboards
  • Generate commission reports

Note: while support for QuickBooks Pro / Enterprise is coming soon, this article is specifically about QuickBooks Online.

Verify QuickBooks Online Readiness

To calculate sales commissions, you must first select a data source. This could be QuickBooks Online, or it could be your CRM system. One key advantage of using QuickBooks Online as a data source for sales commission calculations is that amounts and payment status are often more accurate. Indeed, most CRM systems do not automatically sync with financial systems, so amounts or payment statuses can be outdated / incorrect. For example, an invoice may show as paid in QuickBooks online, but unpaid in CRM, which can result in errors when calculating sales commissions.

However, to calculate commissions using QuickBooks Online, we’ll need to credit each sales transaction (aka deal, order, invoice, contract, etc.) to users or teams / territories. What this means is that your QuickBooks Online tenant should include a custom field which specifies a rep or team / territory. This custom field can be a text field or a dropdown. You can use any type of identifier (ex: user name, employee ID, email address, etc.). If multiple reps or teams / territories need to be credited, create additional custom fields. If you are paying sales commissions based on territories alone, you may not need to add a custom field as existing fields such as “State” or “Country” may be sufficient.

Capture

Sign Up For a Free Account

Simply click  here  and select “Login” in the top right corner. Next, click on the “Sign up” tab (as shown below). If you sign up with a social account (ex: LinkedIn), you won’t even need to confirm your email address!

Capture

Add a Connection to QuickBooks Online

In Sales Cookie, go to [Settings -> Connections] and add a connection to QuickBooks Online by clicking on the “Add” button:

Capture

Next, click on the “Authorize Access” button:

Capture.PNG

Next, authorize Sales Cookie . As you can see, setting up a connection to QuickBooks Online is very easy. The whole process takes less than 1 minute.

Capture

Add Users and Transactions from QuickBooks Online

To add users (technically employees), go to [Users -> Add Users] in Sales Cookie, and select QuickBooks Online as a data source. All your QuickBooks employees will be listed in an (editable) spreadsheet. Choose a role for your users (ex: participant, admin) and click next.

Capture.PNG

To add QuickBooks sales transactions, go to [Transactions -> Add Transactions] in Sales Cookie, and select QuickBooks Online as a data source. You can choose to import either invoices or sales receipt. If you want to import both, perform separate import operations. Give it a minute to retrieve and analyze your QuickBooks Online data.

Next, you’ll need to map fields to different categories (ex: owner, revenue, territory, etc.). You only need to do this once. Your mappings confirm which field(s) should be used to credit users, which field represents total revenue, etc. If you select automated updates, changes will be synchronized every hour!

Capture

Create Sales Incentive Plans

Using Sales Cookie, you can create all kinds of sales compensation plans – from basic (ex: plans with a simple revenue-based quota) to advanced (ex: plans with scoring, formulas, draws, splits, caps, profitability, etc.).

Below are just a few sample plans created within Sales Cookie. The Sales Cookie team will configure incentive plans for you  free of charge  – just send them a detailed description of your incentive program. For example, they can help you configure your plan so that only those invoices which have been marked as paid are processed.

Untitled.png

Run Commission Calculations

To run a calculation, go to [Calculations -> Run Calculation] in Sales Cookie. Select a plan and a time period. Most commission  calculations  only take seconds to run and complete. When you open a calculation’s details, you will see additional information – credits, payouts, reports, etc. Your calculation is not “official” (nor visible) until you release it.

Capture

View Incentive Dashboards

For your reps to view their sales commissions, you must approve them. Go to your calculation and select “release rewards”. Your reps can now see relevant information on their personal incentive  dashboard .

Here is an example of what it could look like (depending on your customizations). This renders properly on any mobile device as well. Your reps can even submit inquiries, enroll into incentive plans (ex: with e-signature), and much more.

pid20.png

Generate Commission Reports

Using Sales Cookie, you can generate all types of reports in 3 categories:

  • Attainment reporting
  • Credit reporting
  • Spend reporting

Here are some of the built-in reports:

Capture

You can also create your own (complex) reports using  Microsoft Power BI . You can even generate reports using natural language queries and publish them to other users.

powerBIScreen.png

In Conclusion

Sales Cookie offers native integration with QuickBooks Online. Using Sales Cookie, you will be able to easily manage sales commissions for your sales team. You will be able to calculate accurate commissions, verify payouts, and publish them to incentive dashboards. You will be able to pay your sales reps the right amount – on time.

You will also benefit from advanced  reporting  capabilities (ex: quota attainment, transaction crediting, spend reporting, etc.). You will be able to change incentive models any time without writing any code or automation. And will no longer need to deal with messy, manual sales commission spreadsheets!

Share this:

Leave a comment cancel reply.

' src=

  • Already have a WordPress.com account? Log in now.
  • Subscribe Subscribed
  • Copy shortlink
  • Report this content
  • View post in Reader
  • Manage subscriptions
  • Collapse this bar

Call us: (216) 333-1303

facebook

  • There are no suggestions because the search field is empty.

Bookkeeping Services for Small and Growing Businesses

Get started

How to Accurately Track Sales Commissions

Apr 16, 2019 8:40:00 AM Penie Hildebrandt

How to Track Sales Commissions on a Laptop

While QuickBooks lacks a dedicated resource for tracking and reporting commissions, the following method using items and a commission payable transaction detail report is an accurate, streamlined way to capture commissions.

The first thing you will need to do is set up two items (Products/Services) in QuickBooks.  One will be named Commission Payable (a liability) and the other named Commission Expense (an expense). You must enter your sales commission percentage in decimals (.1 or .2 as opposed to 10% or 20%), while the expense will be negative.

You will then create a Group item using the Commission Payable and Commission Expense items you just created. You must assign your group a name, but don’t worry! It won’t print on your customer invoices, so you can name them anything you want to help you keep track of groups.

To begin recording and tracking commission on a Sales Order or Sales Invoice:

  • Add the item Group to the sales order or sales invoice
  • Copy/Paste the description
  • Put the Sales Margin $$ in the Quantity field
  • Change the commission to the correct % in the Price Each Field

The total Commission Expense and Payable will total $0 and have no effect on the invoice total.

QuickBooks Invoice Screen

When you are ready to pay commissions, create a Sales by Item report filtering for the Commission Payable account only. You will want to add the Paid field, Rep, and the CLR (cleared) field. The Paid and Unpaid column will tell you whether or not the invoice has been paid by the customer. If the invoice is Paid, then it is time to pay the commission to the salesperson. Export the report to excel and sort by Paid/Unpaid.

spreadsheet sorted by paid and unpaid

Enter a bill or pay the commission in payroll. The debit to the Commission Payable account will reduce the payable balance.

After the bill or payroll is recorded, go to the Commission Payable Account Register and Check Mark Cleared to keep track of what has been paid to the salesperson and the Uncleared items are the balance still owed.  

custom transaction detail report

Still confused about accounting for sales commissions, give us a call at 216-333-1303.

New Call-to-action

Written by Penie Hildebrandt

Subscribe to email updates, recent posts.

  • Mastering QuickBooks: Turning Financial Puzzles into Clear Solutions
  • Bookkeeping Tips for Accounting for Biotech and Technology Firms.
  • Unmasking QuickBooks Challenges: 3 Areas You Shouldn't Overlook!
  • Client Spotlight Interview: NeuroTherapia
  • Client Spotlight Interview: Abcon

Posts by Tag

  • Bookkeeping (157)
  • Small Business (128)
  • QuickBooks (96)
  • Financial Management (72)
  • For Accountants (62)
  • small business bookkeeping (37)
  • Budgeting (33)
  • Accounting (29)
  • Nonprofit (22)
  • Profitability (22)
  • Professional Services (15)
  • eCommerce (13)
  • Start-ups (12)
  • Cash Flow (6)
  • payroll (6)
  • Banking (5)
  • Biotech (4)
  • BusinessGrowth (4)
  • Grow your Business (4)
  • accounts receivable (4)
  • Cash Flow Statement (3)
  • Efficienies (3)
  • Social Engineering (2)
  • BusinessOperations (1)

Small Business Bookkeeping

How to track commission in QuickBooks Desktop

Man with earbuds talking in an office

If QuickBooks Desktop is your accounting software of choice and you pay your employees commission, then knowing how QuickBooks Desktop commission tracking works is a must. 

However, if your QuickBooks commission process isn’t concrete, tracking commissions can be challenging. The good news is that there are ways to improve your QuickBooks commission workflow to ensure accuracy and transparency.

In this article, you’ll learn how to track commission in QuickBooks Desktop to make QuickBooks payroll much simpler. Plus, you’ll get a glimpse at how sales commission tracking software automates your commission process to drive efficiency.

Does QuickBooks Desktop track sales commissions?

Before learning how to track commission in QuickBooks Desktop, we need to clarify whether QuickBooks Desktop tracks commission at all. 

Unfortunately, QuickBooks does not currently offer a commission tracker. For the most part, QuickBooks commission tracking is a manual process. 

That said, there are ways to get around this limitation and set up your QuickBooks Desktop commission in a way that makes tracking easier. 

Let’s dive deeper into how to track sales commission in QuickBooks Desktop.

While you can’t track commission in QuickBooks Desktop, you can set up commission items. This allows you to manually track employee commission. 

Setting up commissions in QuickBooks Desktop is a two-step process.

  • Set up a commission pay item. 
  • Add the pay item to your commissioned employee’s profile.

Let’s break down each of these steps outlining how to track commission in QuickBooks Desktop.

Step 1: Set up a commission pay item

The first step in learning how to track sales commission in Quickbooks Desktop is to set up a commission pay item. Here’s a step-by-step guide on how to do this:

  • In ‘Lists’, select ‘Payroll Item List’.
  • Under the ‘Payroll Item’ drop-down menu, click ‘New’.
  • Select ‘Custom Setup’, then click ‘Next’.
  • Select ‘Wage’, then click ‘Next’.
  • Select ‘Commission’, then click ‘Next’.
  • Enter the name of the item, then click ‘Next’.
  • Select the appropriate Expense account for the item, then click ‘Next’ and ‘Finish’.

From this point, you must add your pay item to the right employee’s profile. 

Step 2: Add pay item to commissioned employee’s profile

Before starting this part of the QuickBooks Desktop commission tracking process, make sure that you already have your employee set up in your account. From there, it just takes a few more steps:

  • Under ‘Employees’, select ‘Employee Center’.
  • Click on the appropriate employee.
  • Select ‘Payroll Info’.
  • In ‘Earnings’, add the payroll item that you created in Step 1, then click ‘OK’.

As you can see, the process is a bit lengthy, especially considering that you still have to manually track commission. 

Looking for an easier way to manage QuickBooks Desktop commission tracking? Automation’s the solution for you.

Why you need to automate commission tracking in QuickBooks Desktop

Dealing with commission in QuickBooks requires lots of manual entry to ensure accurate accounting and timely pay for your sales reps. This ends up costing you time and resources that are better spent on other tasks. 

So when you consider how to track commission in QuickBooks Desktop, automation should be top of mind. 

Automation tools such as commission tracking software allow for accurate commission tracking in QuickBooks without the need for constant manual data entry.

As a result, you reap benefits like:

  • Increased efficiency for your team.
  • Transparency for your sales reps.
  • Accurate accounting with less mistakes.  

There’s one commission tracking solution that delivers all of these benefits to QuickBooks users. 

QuickBooks Desktop commission tracking solution — Method

If the question is “how to track sales commission in QuickBooks Desktop,” the answer is Method.

Method is the best automation tool for QuickBooks Desktop commission tracking thanks to several unique features. 

Firstly, every business has a different commission structure, meaning software that’s fit for one business may not be right for another. What’s the solution? Customization.

Method is a fully customizable software solution, meaning that you can build a personalized commission tracker tailored to your business. Method’s platform enables you to customize it yourself, but you can also enlist the help of Method’s customization experts.

Custom commission tracker screen in Method:CRM

Next, if you already have your employee records set up in QuickBooks Desktop, you don’t want to have to duplicate your data in a separate sales commission software. With Method, you don’t need to worry about entering the same information twice.

Method’s two-way QuickBooks sync means that when you update information in Method, it automatically syncs to QuickBooks, and vice-versa. 

This means that your employee data will sync to Method, which calculates commissions for you. From there, that commission syncs to QuickBooks and is ready for payroll. This process eliminates the risk of double data entry and ensures accurate payroll. 

Other key features in Method include: 

  • Categorizing your sales and employees for better insights. 
  • Custom sales rep commission reports.
  • Several third-party integrations for an all-in-one solution.

Better yet, Method also works for QuickBooks Online. So if you’re also wondering how to set up commission in QuickBooks Online , look no further for a comprehensive solution.

QuickBooks Desktop commission tracking FAQs

How do i record commissions in quickbooks desktop.

To record commissions in QuickBooks Desktop, you must first set up a commission pay item. Once you do that you can add the pay item to the select employee’s profile.

What type of account are commissions?

For a business, commissions are an expense as they are part of payroll. The sales form that commission is calculated from is considered revenue. 

It’s important to keep this in mind when recording commission in QuickBooks payroll to ensure accurate accounting.  

How do you categorize commission paid?

The way you categorize commission paid depends on how your business structures commission.

When you pull up your commission reports in QuickBooks, you can categorize commission by:

With Method, you can generate custom reports for commission and other business data to provide you with data-driven insights. 

Wrap up: Why a commission tracking solution is your best bet

Calculating and recording commission is crucial in ensuring that your payroll is accurate and that your employees stay happy. That’s why learning how to track commission in QuickBooks Desktop should be your top priority.

A commission tracker is the best way to keep on top of your commission processing and ensure that nothing slips through the cracks. 

If you’re looking for a tool to strengthen your QuickBooks Desktop commission tracking and overall workflow, look no further than Method. 

Start your free trial of Method today!

Image credit: Rene Asmussen via Pexels

About The Author

' src=

Eilis McCann

Related posts.

Decorative

How to create an invoice in QuickBooks

A pair of red and white boxing gloves lying on a wooden floor.

3 ways you win with QuickBooks mobile access

Streamline your business with method.

Start your free trial — no credit card, no contract.

commissions paid report in quickbooks

How to Create Commission Reports for Sales Reps in QuickBooks

commissions paid report in quickbooks

Question: Can I create commission reports for sales reps in QuickBooks?

Answer: Yes, but it requires a workaround.

QuickBooks will tell you it is impossible, but I have discovered a workaround, one of many required for ad specialty distributors.

QuickBooks can run a report of gross profit by “class.” We can then create a class for each of your sales reps.

Take care to add the Customer:Job for each line item in each supplier purchase order to make sure the expenses tie back to the customer.

Then, export the report showing gross profit by class to Excel and calculate your commissions there to be entered back into QuickBooks.

It's a bit cumbersome, but at least there is an option.

Please email accounting questions you would like considered for the column to [email protected] with the subject line of "Ask the Accountant."

  • Categories:
  • Promo Products

Harriet Gatter, owner of Accounting Support LLC, was an ad specialty distributor for 23 years and an adjunct professor of accounting at Neumann University. She sold her ad specialty business in 2012, became certified as a QuickBooks ProAdvisor, and now works exclusively with ad specialty distributors nationwide on their QuickBooks, order management and accounting needs.

commissions paid report in quickbooks

commissions paid report in quickbooks

  • All-Access Subscriptions
  • Business Licensing
  • Lightroom Classic
  • Photoshop Elements
  • Crystal Reports
  • Interview Skills
  • Resume Skills
  • Excel for Lawyers
  • Outlook for Lawyers
  • QuickBooks for Lawyers
  • Word for Lawyers
  • Microsoft Office Suite
  • Outlook on the Web
  • Microsoft Project
  • Microsoft Teams
  • QuickBooks Online
  • QuickBooks Pro
  • Video Course Options
  • SUBSCRIPTIONS
  • Photoshop Elements 2024
  • Photoshop Elements 2023
  • Photoshop Elements 2022
  • Photoshop Elements 2021
  • Photoshop Elements 2020
  • Photoshop Elements 2019
  • Photoshop Elements 2018
  • Photoshop Elements 15
  • Google Classroom for Teachers
  • Google Docs
  • Google Drive
  • Google Forms
  • Google Sheets
  • Google Slides
  • Mac OS Keyboard Shortcuts
  • Excel Formulas and Functions
  • Excel Keyboard Shortcuts
  • Excel Tables PivotTables and Charts
  • Access for Microsoft 365
  • Excel for Microsoft 365
  • Microsoft Office 365
  • Outlook for Microsoft 365
  • PowerPoint for Microsoft 365
  • Publisher for Microsoft 365
  • Word for Microsoft 365
  • Access 2021
  • Microsoft Office 2021
  • Outlook 2021
  • PowerPoint 2021
  • Publisher 2021
  • Access 2019
  • Microsoft Office 2019
  • Outlook 2019
  • PowerPoint 2019
  • Publisher 2019
  • Access 2016
  • Microsoft Office 2016
  • OneNote 2016
  • Outlook 2016
  • PowerPoint 2016
  • Publisher 2016
  • Microsoft Office 2013
  • OneNote 2013
  • Outlook 2013
  • PowerPoint 2013
  • Microsoft Office for iPad
  • QuickBooks Pro 2024
  • QuickBooks Pro 2023
  • QuickBooks Pro 2022
  • QuickBooks Pro 2021
  • QuickBooks Pro 2020
  • QuickBooks Pro 2019
  • QuickBooks Pro 2018
  • QuickBooks Pro 2017
  • QuickBooks Pro 2016
  • QuickBooks Pro 2015
  • QuickBooks Pro 2014
  • Sage 50 Accounting
  • Windows 11 and 10 Keyboard Shortcuts
  • Chrome OS for Chromebooks
  • Word and Excel (Mac) 2022
  • Word and Excel (PC/Windows) 2021-2016 and 365
  • QuickBooks Desktop (PC/Windows) 2024
  • QuickBooks Desktop (PC/Windows) 2023
  • QuickBooks Desktop (PC/Windows) 2022-2015
  • Windows 11 and 10
  • Our History
  • Customer Service
  • Testimonials
  • Lost Password
  • Register a Product
  • Manage My Account
  • Member Login

Try the QuickBooks Online Course for Free!

Create a commission or bonus paycheck in quickbooks online, create a commission or bonus paycheck in quickbooks online: video.

            This video lesson, titled “ Creating Commission Only or Bonus Only Paychecks ,” shows you how to create a commission or bonus paycheck in QuickBooks Online. This video lesson is from our complete QuickBooks Online tutorial titled “ Mastering QuickBooks Online Made Easy .”

Overview of How to Create a Commission or Bonus Paycheck in QuickBooks Online

            To create a commission or bonus paycheck in QuickBooks Online if you subscribe to a QuickBooks Online Payroll service and have added the “Bonus” and/or “Commission” pay types for employees, hover over the “Payroll” link in the Navigation Bar and then click the “Employees” link in the side menu that appears to open the “Employees” page. Then click the drop-down arrow on the “Run payroll” button in the upper-right corner of the page. Then select either the “Bonus only” or “Commission only” command from the drop-down menu, as needed.

            If you select the “Bonus only” command, then the “Run Payroll: Bonus Only” window opens. This screen doesn’t appear for the “Commission only” choice. In this screen, you choose how to pay the bonus. To enter the “take-home pay” for the employee, or the amount left after any withholdings are removed, select the “As net pay” option. To enter the total pay for the bonus, or what the amount is before any withholdings are removed, select the “As gross pay” option, instead. After selecting your choice, click the “Continue” button in the lower-right corner of the window.

Select How to Pay and Whom to Pay

            For both types of pay, in the next screen, select the bank account from which to pay the bonus, if you created multiple bank accounts, from the “Pay from” drop-down at the top of the screen. Then enter the pay date by selecting it from the “Pay date” calendar selector.

            Then check the checkbox to the left of the name of the employee or employees to pay in this bonus or commission payroll run within the employees table below. Alternatively, uncheck the checkbox for the employees to not pay. To check or uncheck all checkboxes, click the checkbox at the top of the column of checkboxes in this table to select or unselect them all, respectively.

            For the selected employees, enter the amount of the bonus or commission for each employee into the “Bonus” or “Commission” column, as needed. You can enter an optional “Memo” for the pay into the “Memo” column. Optionally, to review the paycheck details for an employee, click the “pencil” icon at the right end of their row to make any adjustments needed in the “Paycheck details” window that opens and then click the “OK” button in the lower-right corner of that window to return to the “Run Payroll” window.

A picture showing how to create a commission or bonus paycheck in QuickBooks Online for selected employees.

A picture showing how to create a commission or bonus paycheck in QuickBooks Online for selected employees.

Set options and review paychecks.

            Optionally, to set any payroll options, click the pencil icon next to the “Payroll options” link below the employee table in the “Run Payroll” window. Check any payroll options you need to apply and then click the “Apply button that appears to apply them. Alternatively, click the “Cancel” button to close the payroll options section without applying any options.

            To continue, click the “Preview payroll” button in the lower-right corner of the “Run Payroll” window to show the “Review and Submit” screen. Make sure to thoroughly check your work! If desired, to preview the payroll details report, click the “Preview payroll details” link in the toolbar at the bottom of the window to open the payroll details report in a new window, which you can close after reviewing it for accuracy.

            If needed, to save your changes to this point and leave, click the drop-down arrow on the button in the lower-right corner of the window and select the “Save for later” command from the pop-up menu to save your changes and exit the “Run Payroll” window. Alternatively, to close the “Run Payroll” window without saving changes, click the “X” button in its upper-right corner to exit without saving changes.

Submit the Payroll

            After ensuring the information is correct in the “Review and Submit” screen of the “Run Payroll” window, click the “Submit payroll” button to then show the paycheck information onscreen. To print pay stubs, click the “Print pay stubs” button to show a preview of the pay stubs in a separate browser tab or window, where you can print them and then close it, when finished. If needed, to record check numbers if printing paper checks, type them into the “Check Number” field for the associated paycheck.

View Payroll Reports and Finish Payroll

            To view your payroll reports as individual worksheets within an exported Excel workbook, click the “View payroll reports” link in the toolbar at the bottom of the “Run Payroll” window to open a “Your payroll reports are ready” window that lists the available payroll reports.

            Check the checkboxes to the left of the names of the reports to export and then click the “Export to Excel” button to download them to your computer as worksheets in an Excel workbook. You can then click the “OK” button in the lower-right corner of the “Your payroll reports are ready” window to return to the “Run Payroll” window. To finish the payroll, click the “Finish payroll” button in the lower-right corner of the “Run Payroll” window.

Instructions on How to Create a Commission or Bonus Paycheck in QuickBooks Online

  • To create a commission or bonus paycheck in QuickBooks Online if you subscribe to a QuickBooks Online Payroll service and have added the “Bonus” and/or “Commission” pay types for employees , hover over the “Payroll” link in the Navigation Bar and then click the “Employees” link in the side menu that appears to open the “Employees” page.
  • Then click the drop-down arrow on the “Run payroll” button in the upper-right corner of the page.
  • Then select either the “Bonus only” or “Commission only” command from the drop-down menu, as needed.
  • If you select the “Bonus only” command , then the “Run Payroll: Bonus Only” window opens. This screen doesn’t appear for the “Commission only” choice.
  • To enter the “take-home pay” for the employee, or the amount left after any withholdings are remove d, select the “As net pay” option.
  • Alternatively, to enter the total pay for the bonus, or what the amount is before any withholdings are removed , select the “As gross pay” option, instead.
  • After selecting your choice, click the “Continue” button in the lower-right corner of the window.

How to Select How to Pay and Whom to Pay

  • For both types of pay, in the next screen , select the bank account from which to pay the bonus, if you created multiple bank accounts, from the “Pay from” drop-down at the top of the screen.
  • Then enter the pay date by selecting it from the “Pay date” calendar selector.
  • Then check the checkbox to the left of the name of the employee or employees to pay in this bonus or commission payroll run within the employees table below.
  • Alternatively, uncheck the checkbox for the employees to not pay.
  • To check or uncheck all checkboxes , click the checkbox at the top of the column of checkboxes in this table to select or unselect them all, respectively.
  • For the selected employees , enter the amount of the bonus or commission for each employee into the “Bonus” or “Commission” column, as needed.
  • You can enter an optional “Memo” for the pay into the “Memo” column.
  • Optionally, to review the paycheck details for an employee , click the “pencil” icon at the right end of their row to make any adjustments needed in the “Paycheck details” window that opens and then click the “OK” button in the lower-right corner of that window to return to the “Run Payroll” window.

How to Set Options and Review Paychecks

  • Optionally, to set any payroll options , click the pencil icon next to the “Payroll options” link below the employee table in the “Run Payroll” window.
  • Check any payroll options to apply and then click the “Apply button that appears to apply them.
  • Alternatively , click the “Cancel” button to close the payroll options section without applying any options.
  • To continue , click the “Preview payroll” button in the lower-right corner of the “Run Payroll” window to show the “Review and Submit” screen and make sure to thoroughly check your work.
  • If desired, to preview the payroll details report , click the “Preview payroll details” link in the toolbar at the bottom of the window to open the payroll details report in a new window, which you can close after reviewing it for accuracy.
  • If needed, to save your changes to this point and leave , click the drop-down arrow on the button in the lower-right corner of the window and select the “Save for later” command from the pop-up menu to save your changes and exit the “Run Payroll” window.
  • Alternatively, to close the “Run Payroll” window without saving changes , click the “X” button in its upper-right corner to exit without saving changes.

How to Submit the Payroll

  • After ensuring the information is correct in the “Review and Submit” screen of the “Run Payroll” window, click the “Submit payroll” button to then show the paycheck information onscreen.
  • To print pay stubs , click the “Print pay stubs” button to show a preview of the pay stubs in a separate browser tab or window, where you can print them and then close it, when finished.
  • If needed, to record check numbers if printing paper checks , type them into the “Check Number” field for the associated paycheck.

How to View Payroll Reports and Finish Payroll

  • To view your payroll reports as individual worksheets within an exported Excel workbook , click the “View payroll reports” link in the toolbar at the bottom of the “Run Payroll” window to open a “Your payroll reports are ready” window that lists the available payroll reports.
  • Check the checkboxes to the left of the names of the reports to export and then click the “Export to Excel” button to download them to your computer as worksheets in an Excel workbook.
  • You can then click the “OK” button in the lower-right corner of the “Your payroll reports are ready” window to return to the “Run Payroll” window.
  • To finish the payroll , click the “Finish payroll” button in the lower-right corner of the window.

' src=

About Joseph Brownell

Sale! One Year Online Entire Library $49. Click here for more info.

  • Managed Services
  • Quick Start
  • Integrations
  • How We Do It
  • Case Studies
  • News & Updates

Ranked #1 by Software Reviews. See the Report.

Commission Tracking Software for Your QuickBooks Workflow

Connect Core Commissions with QuickBooks for seamless data syncing.

Schedule a Demo

Simplify your quickbooks commissions process.

Integrate Core Commissions with QuickBooks to collect accounting, invoice, and sales data for easy commission tracking.

Pull all of your data from QuickBooks including invoices, product details, employees, customers, and vendors directly into Core.

Sync your data automatically on a set schedule or on an as-needed basis.

Keep track of attainment goals by assigning sales reps to invoices using our powerful RuleBot technology.

Choose exactly what data gets pulled into Core through our interactive user interface.

We don’t just promise to transform your commission management, we prove it! Ask about our Quick Start program or schedule a free demo .

Customized QuickBooks Integration

Core offers a customized integration experience with all of the functionality that you need to easily connect with QuickBooks accounting software.

Our advanced ETL tool allows us to pull, modify, or push any data needed from QuickBooks to easily merge metrics and accurately measure growth.

commissions paid report in quickbooks

Boost Commission Management

Integrating your business systems sets up your organization for a fully automated experience.                                                                                                  

  • Import sales commission data to and from an unlimited number of sources.
  • Calculate even the most complex incentive packages with the click of a button.
  • Generate reports for sales personnel and managers immediately.

Add Transparency to Commissions

Sales organizations of all sizes deliver a more transparent experience for sales reps and agents through Core Commissions’ tools.                                                                                                                                                                                              

  • Sales reps can view their commission reports at any time with web access to Core Portal.
  • Administrators streamline the commission dispute process using Trouble Ticket Management.
  • Users view every calculation in a single view through Automated Auditing features.

Blocks connect within the Core Commissions application to track, transform and calculate QuickBooks commission data.

Real Results

commissions paid report in quickbooks

Hear From Our Clients

commissions paid report in quickbooks

Paragon Dealer Services

commissions paid report in quickbooks

Western Resources Title

commissions paid report in quickbooks

8020 Consulting

commissions paid report in quickbooks

NEW FEATURE RELEASES: ASC 606 reports, Commission Lock, Pay Cycle Manager, Simplified CSV Import

commissions paid report in quickbooks

  • Varied Commissions
  • Multi-Currency Support

Sales Splits

  • Manager Override Commission
  • Commissions Draws
  • Paid When Paid Commissions
  • Commissions Clawbacks & Adjustments

Matrix Commissions

  • Suspend User Module
  • Commissions Catch Up
  • Commissions Target Required
  • Unpaid Commissions
  • Multistage Commissions
  • Commission Criteria Filtering
  • Commission Lookup Tables
  • Delayed Commission Payments
  • Future Commissions
  • Industry Solutions
  • Energy Sales
  • Payment Processing
  • Insurance Sales
  • Insurance Commission Tracker

Accounting Software

  • Invoiceberry
  • Microsoft Dynamics 365
  • Run my Accounts
  • Visma eAccounting
  • Google Sheets
  • Wealthbox CRM

E- Commerce

  • BigCommerce
  • Digistore 24
  • Woocommerce

Payment Software

commissions paid report in quickbooks

Do you want to calculate sales commissions with Quickbooks?

Commissionly integrates seamlessly with QuickBooks Online software with our direct integration – quick and easy.

commissions paid report in quickbooks

FEATURES AND BENEFITS

commissions paid report in quickbooks

Varied Commission Structures

Use our simple wizard to create complex commissions whether they are flat or tiered, revenue, profit or product based. Read more

Multicurrency Support

Choose a different currency for each sales rep or each deal as required, plus another one for your sales manager who receives overrides, all within the same system. Read more

With Commissionly, you can create split commissions for any opportunity and divide commission between individuals at the product level too. Read more

Manager Overrides

Manager overrides are easily handled within Commissionly. They can be setup as part of any commission plan in just a few simple steps. Read more

Calculate the remaining draw amounts as well as commission pay-outs and display the final commission amount, with the remaining draw in a report each month. Read more

Paid when Paid

Connect your invoicing or payment system and only pay out your commissions when you receive payment from customers. Read more

Clawbacks & Adjustments

Commissionly easily handles adjustments and clawbacks simply enter the amount and Commissionly will calculate the change automatically. Read more

Use multiple variables to set up commission rates e.g. by product sold to different departments in the same company. Read more

WHY COMMISSIONLY?

Software integration.

Commissionly software integrates with most systems instantly​

Tailored to your Business

We can customize to meet your needs regardless of the complexity of the commission structures you are working within​

Easy Set-Up

Your fit for purpose solution is quickly implemented with exceptional online training videos available to ensure maximum advantage for your team​

Exceptional Support

Throughout the process Commissionly is at hand, providing a stress-free switch that will transform the way you pay commission and enhance your business​

What our Customers Say

commissions paid report in quickbooks

The ideal tool for calculating the commissions

Commissionly delivers a great product at a very reasonable price

Commissionly has really had a huge effect on my business

A proven workflow for managing sales commissions

commissions paid report in quickbooks

commissions paid report in quickbooks

Close more deals with the latest sales trends and tips from Salesblazers.

What Is Sales Commission? Formulas, Examples, and Best Practices

People shaking hands while looking at a sales commission agreement

Learn the basics of strong, effective sales commission plans to attract top talent and drive business goals.

commissions paid report in quickbooks

Richard Harris

Share article.

  • Link Copied

The pressure is on. 

About 69% of sales professionals say selling is more difficult now than in previous years, according to Salesforce’s State of Sales report.

Even though it’s harder to sell, reps still need to hit their numbers. And in this ultra-competitive environment, morale can quickly take a dive. To keep your sales team motivated when things are tough, you need to reward them for their victories. That’s where sales commission comes into play. Done the right way, commissions can be a powerful incentive to give your best and go beyond your comfort zone.

In my 20-plus-year career, and as founder of the Harris Consulting Group, I’ve learned some valuable lessons, tips, and best practices when it comes to structuring sales commissions. I’ll walk you through all the factors you need to consider when setting a sales commission structure for your team.

What you’ll learn:

What is sales commission, benefits of sales commissions, why is sales commission important to understand, basics of an effective commission structure, 8 types of sales commissions and formulas for calculating, tips on deciding sales commission structure and rate.

  • How to put a sales commission structure in place

What to include in a sales commission agreement

Tips for faster commission achievement, speed up the sales cycle from quote to close.

Go from lead to inked deal in record time with automation that speeds up quoting, approvals, and contracting. 

commissions paid report in quickbooks

Sales commission is the additional money reps earn on top of a base salary for achieving specific goals. Commissions often push sellers to achieve sales goals and generate revenue .

For example, let’s say your leading rep’s base salary is $100,000. Your company offers a 10% commission for a product valued at $5,000. If they sell just one of those products, their net pay is $100,00 + (.1 x $5,000) = $100,500.

I believe commissions are a game-changer. Sales is one of the few professions where you can build the life and income you want based on the effort you put in. As Scott Leese, founder of Scott Leese Consulting, affirms: “In my experience, sales commissions add a level of excitement and positive reinforcement for sales teams.

( Back to top )

Commissions help organizations boost sales team morale and grow organizational revenue. But they offer a lot more. Leese offers the following benefits of commissions in sales:

  • Increase earning potential : Commissions create the opportunity to gain significant income beyond a base salary. Top salespeople can earn high commissions, and this high-earning potential is often a huge motivator for many sales professionals.
  • Reward performance: Commissions are directly tied to sales results, so they reward high performers. For competitive salespeople who want their compensation to directly reflect the work they put in, commissions are appealing.
  • Provide incentives: Commissions incentivize salespeople to generate more revenue. The lure of higher commissions can motivate staff to increase sales activities and close more deals .
  • Indicate level of success : Earning substantial commissions can be a visible indicator of success in sales. Additionally, top earners get bragging rights and peer recognition.
  • Create control over earnings: With commissions, salespeople feel more in control over their income potential. As a result, they have the power to boost their earnings rather than relying solely on a fixed salary.
  • Spark competition: Salespeople are often competitive. Because of this, commissions can turn sales into a competition where reps try to outsell one another to earn more. This can generate more deals and more revenue.

Let’s dig deeper to unlock the true power of commissions.

Because it’s core to their salary, understanding commissions is crucial for sellers. Consequently, businesses must understand the power commissions have on their workforce.

For instance, a 2022 Gartner survey found that 90% of sellers experience burnout, which can lead to resignations. Commissions may have the power to incentivize reps to stick with your company long-term. Certainly, some types of commission structures are more attractive than others and can give your company an advantage when attracting and retaining the best sellers. Leese believes the best commission plans align the salesperson’s interests with the company’s interests.

“While commissions provide financial incentives, well-designed plans encourage salespeople to take a long-term, customer-focused approach for a mutually beneficial relationship,” he said.

To achieve that alignment, businesses must strike a delicate balance between their commission rate and structure. I like to imagine commission as the dangling carrot. The challenge: If the commissions are out of line with the company goals, the carrot becomes the stick. Certainly, nobody is going to stay at a job where they’re reprimanded for not hitting unreasonable targets.

Commissions come in different shapes and sizes. Knowing your rep commission rate, structure, and payout gives sellers financial visibility and helps you align them with business objectives. But there’s a little more to it…

The stakes are incredibly high in sales. It’s one of the only roles where not meeting your quota will put you at risk of losing your job. Surviving in a make-or-break environment means salespeople must keep an eye out for their next employment opportunity, even if they are all-star sellers. That’s why you want to build a compensation plan that makes it impossible for someone to recruit your best seller. With the right approach, you can build commission rates and structures to promote smart behaviors and encourage retention rather than just immediate sales.

Here are a few things to be sure you include in your commission structure to ensure buy-in from your whole team:

  • Payout schedules: These can be structured to support longer-term goals. As an illustration, some payouts may be deferred or only paid on an account’s payment of their invoice(s).
  • “Clawback” provisions: These may be used to negate or recover commissions if a salesperson’s deal later causes problems, like failure to pay an invoice or contract cancellation. 
  • Ethics and conduct standards: These should align with company values, so reps don’t compromise integrity or compliance to earn commissions.
  • Training: If the expectation of the sales team is to grow revenue, then it is important for companies to heavily invest in sales training. Above all, the purpose of sales training is to ensure consistency in process, a common language, and the right ethical and consultative approach to sales.

Let’s take a look at some examples of commission types and how they’re calculated so you can see what would make the most sense for your business.

Trending Articles

Productivity icons like email and chat on an illustration of a laptop with a blue background

3 Ways Generative AI Will Help Marketers Connect With Customers

Illustrating of Einstein character surrounded by 3 Trailhead badges for AI skills

Learn AI Skills on Trailhead

Commission structures are not one size fits all. The right one for you depends on your business’s size, the products or services you offer, and your revenue goals. Below is a selection of the sales commissions I’ve encountered in my career that you could choose from.

1. Base salary + commission

Combines a guaranteed income with variable earnings for performance.

  • Formula: Base salary + commission
  • Example: Your annual salary is $40,000. You earn a 10% commission on all sales. If you sell $100,000 worth of products, your total for the year would be $40,000 + ($100,000 x 0.1) = $50,000.
  • Who’s it for? Teams or products with less predictable sales cycles
  • Pro: Provides financial stability and incentivizes overall sales while rewarding individual performance
  • Con: Can increase fixed costs without significant sales growth and high base salaries can lead to complacency

2. Commission calculated on exceeding quota

Combines a base salary with additional commission earned only on sales exceeding a set quota.

  • Formula: Base salary + (Sales exceeding quota x Commission rate)
  • Example: You have a $3,000 base salary per month and earn a 15% commission on sales exceeding your $10,000 quota. If you sell $12,000 worth of products, your total would be $3,000 + ($2,000 x 0.15) = $3,300.
  • Who’s it for? Established teams with ambitious targets
  • Pros: Motivates reps to exceed goals for increased pay; drives higher profitability
  • Con: Can create pressure and discourage collaboration if quota feels unattainable, leading to lower overall sales

3. Straight commission

Paid as a percentage of the total sales value.

  • Formula : Sales value x Commission rate (%)
  • Example: If you sell a product worth $1,000 with a 10% commission rate, your pay would be $1,000 x 0.1 = $100.
  • Who’s it for? Short sales cycles or independent salespeople with a high-risk tolerance
  • Pro: High earning potential directly tied to performance, leading to strong sales motivation
  • Con: Income instability and financial stress when sales are slow, potentially leading to unethical sales practices that prioritize individual gain over customer satisfaction. For example, reps could misrepresent a product by not disclosing its drawbacks or hidden fees just to close a sale.

4. Residual commission

Incentivizes salespeople with legacy clients and accounts.

  • Formula: Client account premium x Commission rate (%)
  • Example: Your legacy client continues to pay their $1,000 premiums each month. You receive a 5% commission or $50 each month.
  • Who’s it for? Established client bases and recurring revenue models
  • Pro: Long-term income from recurring sales incentivizes, building customer relationships and loyalty
  • Con: Might not provide immediate financial gratification, potentially demotivating some salespeople. This could lead to salespeople sitting on a book of business to collect money without feeling the need to get new business for the company.

5. Territory volume commission

Used for teams; a set rate for a defined region determines the sales team’s income.

  • Formula: (Your territory sales / total team sales) x Commission rate x Total sales revenue
  • Example: Your territory team has $50,000 in sales within your territory, the total team sales for the company are $500,000, and the commission rate is 10%. Your territory volume commission would be ($50,000/$500,000) x 0.1 x $500,000 = $5,000.
  • Who’s it for? Large sales teams managing geographically divided markets
  • Pro: Encourages local market development and ownership, aligning rep success with specific regions
  • Con: Might lead to resentment, competition, and neglect of shared opportunities if territories are poorly defined or one salesperson contributes the most and is getting paid the same as someone who contributed the least.

6. Tiered commission

Rates increase as sellers surpass sales goals, encouraging progressive effort.

  • Formula: (Tier 1 sales x Tier 1 rate) + (Tier 2 sales x Tier 2 rate) + … + (Tier n sales x Tier n rate)
  • Example: A tiered commission plan might have 5% for sales up to $5,000, 8% for sales between $5,000 and $10,000, and 12% for sales over $10,000.
  • Who’s it for? Teams dealing with complex sales with multiple touchpoints
  • Pro: Rewards high performers progressively, motivating exceptional effort for greater financial gains
  • Con: Can demotivate underachievers and create frustration if tiers feel unfair or unattainable

7. Gross margin commission

Profit from the sale determines the commission.

  • Formula: Gross margin per unit x Number of units sold x Commission rate (%)
  • Example: If a product has a $200 gross margin and a 15% commission rate, selling 10 units would earn you $200 x 10 x 0.15 = $300 in commission.
  • Who’s it for? High-margin products or situations where cost control is critical
  • Pro: Aligns sales focus with profitability, encouraging reps to sell high-margin products and services
  • Con: Can be complex to understand and calculate, potentially causing confusion and distrust

8. Draw against commission

Advance against future earnings, creating financial stability but requiring repayment through sales.

  • Formula: Commission earned – draw amount
  • Example: You receive a $2,000 draw against your commission. If you later earn $3,000 in commission, your total earnings would be $3,000 – $2,000 = $1,000.
  • Who’s it for? Salespeople in unpredictable income environments; particularly helpful for new reps or during sales dips
  • Pro: Provides financial security for new or underperforming reps while ensuring company commitment to employees
  • Con: Creates potential debt burden if sales fall short, leading to stress and decreased morale throughout the team.

Some of these seem complicated, but technology can help companies automate commission calculations and tracking. These platforms can save time and reduce errors for your sales team.

It’s one thing to offer commission. It takes an entirely different strategy to determine the best rate. According to Indeed , most sales commissions come within a sweet spot of 20% to 30% of gross margins, but the range stretches from 5% to 100%, depending on the setup.

In my experience, the perfect number for every industry does not exist. Commission is also not the only factor in hitting revenue targets. If there’s a sales team that gets 100% quota and its company goes out of business because they haven’t hit targets, it’s likely not the commission plan that’s the problem. I would assume the company has a whole host of issues that have nothing to do with the sales commission structure.

Instead of searching for that perfect number, choose a commission structure and rate by answering the following questions, then considering what comes next:

How are my competitors compensating their sales team?

Evaluate what your competitors are doing against each commission structure I shared above to see if it’s viable for your business. If your sales cycle tends to be longer and your sales team has a lower risk tolerance, then straight commission might not be the right choice. Certainly, don’t hesitate to ask your sales reps for their opinions.

Can I offer similar or even higher rates?

Top sales talent is hard to find and easy to lose, so you want to remain competitive. Once again, check in with your sales team. Ask them how they feel about the current rate and what it would take for them to stay loyal.

What is the size of my sales force?

You want to be able to scale your payouts so that everyone on your team is paid equitably for their duties. Review the job descriptions at your company. For example, the difference between sales reps vs. sales managers and sales enablement vs. sales partners roles. Consider the responsibilities for each position and balance that against your budget and current market rates.

Will the company remain profitable?

Don’t promise what you can’t pay. Confirm your sales budget and pay attention to sales forecasts , which can help you prepare for shifts in things like staffing, inventory, marketing budget, and sales capacity.

Can a sales rep easily understand the commission structure and payout?

Do you have a communication strategy? If not, it’s time to develop one. A communication strategy must spell out every detail of the commission structure and payment schedule so everyone can understand it and has an opportunity to ask questions.

Answering these questions helps you get a better picture of your competition and internal operations. With this knowledge, you’ll be able to set and adjust commission rates and structures for the highest benefit to your organization.

Get articles selected just for you, in your inbox

How to put a sales commission structure in place, step by step.

Implementing a successful commission compensation plan can be broken down into five steps:

1. Define your goals

The best practice for any plan is to define what success looks like. What are your ultimate sales targets ? Do you want to obtain new logos (prospects), conquer new markets, defend your territory, take customers from your competitors, or grow existing customer revenue?

Identify the specific sales behaviors you want to incentivize, like closing high-value deals or nurturing long-term relationships. Ensure everyone on the sales team understands what the endgame is for total alignment.

2. Set achievable quotas

Find the balance between challenging and attainable. You want your sales reps to be motivated, but you don’t want to set them up for failure.

Use CRM data to confirm what your sales team has sold in the past. Combine that research with buyer interest, the economy, and market trends to set goals that inspire your team to exceed sales expectations alongside their quotas.

Have a few of your best reps review the plan to look for problems before the whole team sees it. Make the adjustments as needed based on their feedback.

3. Calculate commission rates and payouts

Clarity is the name of the game for both your business and sales team. Make sure your budgets are accurate. When you promise a commission rate, deliver it. It’s not only poor etiquette to under-deliver; it will be interpreted as unethical and that will cause your top talent to push back on what you communicated upfront. And in many cases, start looking for the door. 

Choose a calculation method that resonates with your team. Confirm that everyone understands the formula, why it was chosen, how reps can earn big, and how and where they can track it.

4. Communicate the plan

Build trust with your sales team by providing every resource they need to succeed. Equip them with training, materials, and clear explanations of the plan. Address any questions promptly and openly to create trust and buy-in. Your sales team should have full commission timeline transparency, including the exact date when the plan begins, when it ends, and when they will be paid.

To build trust with your sales team, they should be involved in developing the commission plan. Sales reps will be able to identify where there are holes, so you don’t miss something simple and avoidable that could affect performance. And being part of the process helps them feel like they have a say.

5. Monitor and evaluate performance

Your commission plan should never be static. Monitor its effectiveness against your goals, and don’t hesitate to adjust the course based on performance and team feedback. A flexible plan that adapts to market shifts and sales reality creates sustained sales growth and employee satisfaction.

Use tools like Sales Cloud’s Revenue Intelligence to track quota attainment, open pipelines, and deal shifts in real-time. Get total visibility of pipeline, forecasting, and rep performance, so you can quickly turn insights into action items. Once implementation is underway, it is time to cement the structure in writing with a commission agreement.

As noted above, transparency is key. A commission agreement template defines commission plan terms, clarifies expectations for all parties, and streamlines administrative processes. The agreement should include the following:

  • Commission rate and structure: Clearly defines earning potential and incentivizes specific sales behaviors
  • Sales goals and quotas: Sets performance expectations and fosters a transparent understanding of targets
  • Payout schedule: Establishes timing of commission payments and ensures financial predictability for salespersons
  • Deductions and exclusions: Outlines any expenses or sales categories not eligible for commission, preventing confusion and disputes
  • Termination clause: Specifies terms for ending the agreement and protects all parties’ interests
  • Dispute resolution process: Provides a clear path for addressing disagreement and maintaining a harmonious working relationship
  • Signatures and effective date: Validates the agreement and confirms commitment from the company and the salesperson

Remember, the specific contents of a sales commission agreement can vary depending on your company’s industry, size, and sales structure. It should be reviewed and approved by legal counsel before being used.

Because trust is a two-way street, I suggest that businesses consider adding addendums that outline how the business will support the sales rep. I like to see a sense of accountability from companies in that document.

For example, if I’m behind on my goals, what is the accountability of my sales manager to help me reach my quota? Does the agreement specify that my manager will set up X number of meetings and Y number of resources for sales training?

I want to see what the onboarding process looks like, how many one-on-ones I’m expected to have, and so forth. You want your sales team to know the company is setting them up for success, and this is a perfect opportunity.

On a personal point, I recommend rewarding sales reps sooner to get to overachievement faster. For example, if you hit 50% of your goal, you get 40% of your commission. If you hit 70% of your goal, you get 65% of your commission.

I have a belief, although untested, that if my sales rep can get to 95% of their goal, I want to pay them 100%. However, the devil is in the details with this theory. It might work in some industries, but it might not work in others. You must consider the variables associated with your business, such as:

  • What are you selling? For example, hardware goods have a specific cost of goods sold (COGS) when compared to software, so commissions from these products will differ.
  • How much is your business investing in advertising? Higher advertising costs might lead to lower commission rates to maintain profit margins. By comparison, an effective brand awareness campaign could drive demand and increase sales volume. You should capitalize on that opportunity by choosing a commission structure that reaps the benefits of more qualified leads in the pipeline like a straight commission structure.
  • How long is your sales cycle ? If you have an 18-month sales cycle, reps will have to wait up to a year to receive their commission. On the flip side, with a transactional sale on a 30- or 45-day sale cycle, reps can receive their commissions faster.
  • How many reps are hitting quota? If your team is not consistently hitting quota, it’s possible to overcompensate the high performers to make up for lower performers. For example, if I have a rep who hits 95% of her goal, I pay her at 100%. By the same token, if she hits 105% of her goal, pay her 110%. In the end, one is theoretically not overpaying the team as a whole.

All of these things affect commissions and must be considered before you build your plan and start payouts. Once the decision is made, it’s time to test your commission structure’s effectiveness and share the plan with your sales team.

Accelerate business growth with an intentional sales commission structure

A successful commission structure is a win-win for your company and your sales team. While lucrative commission schemes help attract and retain reps who are motivated by earning potential, a commission structure that motivates everyone on your team is best for business. Strive to create a program that drives performance, boosts your profits, and builds a strong sales force as a result.

Get pipeline intel you can act on in any scenario

See how Revenue Intelligence helps you model the impact of adding or removing deals to make your forecast.

commissions paid report in quickbooks

Just For You

A customer receives several boxes from a delivery person: what is order management

What Is Order Management — And Why Should You Care?

Illustration of a chart, pencil and sales performance review metrics

7 Sales Performance Review Examples & Tips

commissions paid report in quickbooks

Explore related content by topic

  • Sales Operations
  • Sales Management
  • Sales Fundamentals
  • Salesblazer

commissions paid report in quickbooks

Richard has more than 20 years of SaaS experience and teaches revenue teams how to earn the right to ask questions, which questions to ask, and when to do it. Richard’s clients include Zoom, Salesforce, Google Cloud, PagerDuty, DoorDash, Salesloft, and Gainsight. He’s also the co-founder of Surf & Sales. Learn more at theharrisconsultinggroup.com.

Get the latest articles in your inbox.

commissions paid report in quickbooks

What Is Outside Sales? The Ultimate Guide

Sales rep charting the sales cycle on various graphs

What Is a Sales Cycle and How Do You Optimize It for Consistent Sales?

Sales reps looking at a screen together: sales playbook

The Ultimate Sales Playbook: How to Create Your Own with Examples for Success

Illustration of a person hitting their sales goals target with a bow and arrow

What Are Sales Goals? S.M.A.R.T. Strategies + Examples

A woman tasting a trade promotion sample at her local supermarket before making a purchase.

Everything You Know About Trade Promotion Management Is Wrong

Sales support reps having a conversation at a table.

Sales Support: What It Is and Why It’s Essential

Woman shaking hands during a consultative sales session

What Is Consultative Sales? Principles and Best Practices

Outbound sales rep making a call with an open laptop

What Is Outbound Sales? Strategies and Tips

commissions paid report in quickbooks

New to Salesforce?

  • What is Salesforce?
  • Best CRM software
  • Explore all products
  • What is cloud computing
  • Customer success
  • Product pricing

About Salesforce

  • Salesforce.org
  • Sustainability

Popular Links

  • Salesforce Mobile
  • AppExchange
  • CRM software
  • Salesforce LIVE
  • Salesforce for startups
  • América Latina (Español)
  • Brasil (Português)
  • Canada (English)
  • Canada (Français)
  • United States (English)

Europe, Middle East, and Africa

  • España (Español)
  • Deutschland (Deutsch)
  • France (Français)
  • Italia (Italiano)
  • Nederland (Nederlands)
  • Sverige (Svenska)
  • United Kingdom (English)
  • All other countries (English)

Asia Pacific

  • Australia (English)
  • India (English)
  • Malaysia (English)
  • ประเทศไทย (ไทย)

© Copyright 2024 Salesforce, Inc. All rights reserved.  Various trademarks held by their respective owners. Salesforce, Inc. Salesforce Tower, 415 Mission Street, 3rd Floor, San Francisco, CA 94105, United States

Firms must help menopausal workers, or face being sued

  • Published 3 days ago

A woman works in a studio

Menopause symptoms can be considered a disability and employers face being sued if they do not make "reasonable adjustments", a watchdog has said.

The Equality and Human Rights Commission (EHRC) issued the guidance to clarify the legal obligations to workers going through the menopause.

Symptoms can include hot flushes, brain fog and difficulty sleeping.

The EHRC said bosses should offer changes such as providing rest areas or flexible hours to help.

Relaxing uniform policies to allow women to wear cooler clothes could also help.

Menopause marks the end of a woman's menstrual cycle, and usually happens in her 40s or 50s.

Failing to make "reasonable adjustments" amounts to disability discrimination under the Equality Act 2010 if the symptoms have a "long-term and substantial impact" on a woman's ability to carry out their usual day-to-day activities, the EHRC said.

A video explaining the guidance says: "The costs of failing to make workplace adjustments for staff can run into hundreds of thousands of pounds when taking into account the loss of talent and costs of defending a claim."

What is the menopause and what are the signs?

The EHRC cited research showing that one in 10 women surveyed who worked during their menopause were forced to leave their job due to the symptoms.

Two-thirds of women between the ages of 40 and 60 experienced menopausal symptoms at work, which largely had a negative impact. Very few asked for adjustments during this time because they were concerned about the potential reaction, it added.

The EHRC adds that taking disciplinary action against women for a menopause related-absence could amount to discrimination, and that language that ridicules someone's symptoms could constitute harassment.

EHRC chairwoman Baroness Kishwer Falkner said the watchdog was "concerned both by how many women report being forced out of a role due to their menopause-related symptoms, and how many don't feel safe enough to request the workplace adjustments".

She added that employers "may not fully understand their responsibility to protect their staff going through the menopause", and that the new guidance had been issued to provide advice on how they can support their staff.

Women's health campaigner and author of Everything you need to know about the menopause (but were too afraid to ask) Kate Muir said the announcement was a "side alley" in the wider conversation around menopause.

"It's not a disability," she told the BBC's Today programme. "It's something every woman goes through and legislation is not going to give you your missing hormones back."

Ms Muir said the main focus should be promoting "menopause education" to inform women about "safer kinds of HRT which mean they don't need to have symptoms at all".

She argued the NHS should give women a "proper consultation" when they go through menopause, as she said "good HRT" protects against cardiovascular disease, diabetes and osteoporosis.

"Those are the messages we should be getting out to women so they can work, be powerful and go through this stage and be happy," she added.

Banner saying 'Get in touch'

Are you a worker going through the menopause? Please share your experiences by emailing [email protected] .

Please include a contact number if you are willing to speak to a BBC journalist. You can also get in touch in the following ways:

  • WhatsApp: +44 7756 165803
  • Tweet: @BBC_HaveYourSay
  • Upload pictures or video
  • Please read our terms & conditions and privacy policy

If you are reading this page and can't see the form you will need to visit the mobile version of the BBC website to submit your question or comment or you can email us at [email protected] . Please include your name, age and location with any submission.

Related Topics

  • Women's health
  • Employment discrimination

More on this story

  • Published 23 March 2023

Woman talking to her doctor

'I went through the menopause before my mum'

  • Published 27 January

Aisling Gallagher

  • Pre-Markets
  • U.S. Markets
  • Cryptocurrency
  • Futures & Commodities
  • Funds & ETFs
  • Health & Science
  • Real Estate
  • Transportation
  • Industrials

Small Business

Personal Finance

  • Financial Advisors
  • Options Action
  • Buffett Archive
  • Trader Talk
  • Cybersecurity
  • Social Media
  • CNBC Disruptor 50
  • White House
  • Equity and Opportunity
  • Business Day Shows
  • Entertainment Shows
  • Full Episodes
  • Latest Video
  • CEO Interviews
  • CNBC Documentaries
  • CNBC Podcasts
  • Digital Originals
  • Live TV Schedule
  • Trust Portfolio
  • Trade Alerts
  • Meeting Videos
  • Homestretch
  • Jim's Columns
  • Stock Screener
  • Market Forecast
  • Options Investing
  • Chart Investing

Credit Cards

Credit Monitoring

Help for Low Credit Scores

All Credit Cards

Find the Credit Card for You

Best Credit Cards

Best Rewards Credit Cards

Best Travel Credit Cards

Best 0% APR Credit Cards

Best Balance Transfer Credit Cards

Best Cash Back Credit Cards

Best Credit Card Welcome Bonuses

Best Credit Cards to Build Credit

Find the Best Personal Loan for You

Best Personal Loans

Best Debt Consolidation Loans

Best Loans to Refinance Credit Card Debt

Best Loans with Fast Funding

Best Small Personal Loans

Best Large Personal Loans

Best Personal Loans to Apply Online

Best Student Loan Refinance

All Banking

Find the Savings Account for You

Best High Yield Savings Accounts

Best Big Bank Savings Accounts

Best Big Bank Checking Accounts

Best No Fee Checking Accounts

No Overdraft Fee Checking Accounts

Best Checking Account Bonuses

Best Money Market Accounts

Best Credit Unions

All Mortgages

Best Mortgages

Best Mortgages for Small Down Payment

Best Mortgages for No Down Payment

Best Mortgages with No Origination Fee

Best Mortgages for Average Credit Score

Adjustable Rate Mortgages

Affording a Mortgage

All Insurance

Best Life Insurance

Best Homeowners Insurance

Best Renters Insurance

Best Car Insurance

Travel Insurance

All Credit Monitoring

Best Credit Monitoring Services

Best Identity Theft Protection

How to Boost Your Credit Score

Credit Repair Services

All Personal Finance

Best Budgeting Apps

Best Expense Tracker Apps

Best Money Transfer Apps

Best Resale Apps and Sites

Buy Now Pay Later (BNPL) Apps

Best Debt Relief

All Small Business

Best Small Business Savings Accounts

Best Small Business Checking Accounts

Best Credit Cards for Small Business

Best Small Business Loans

Best Tax Software for Small Business

Filing For Free

Best Tax Software

Best Tax Software for Small Businesses

Tax Refunds

Tax Brackets

Tax By State

Tax Payment Plans

All Help for Low Credit Scores

Best Credit Cards for Bad Credit

Best Personal Loans for Bad Credit

Best Debt Consolidation Loans for Bad Credit

Personal Loans if You Don't Have Credit

Best Credit Cards for Building Credit

Personal Loans for 580 Credit Score or Lower

Personal Loans for 670 Credit Score or Lower

Best Mortgages for Bad Credit

Best Hardship Loans

All Investing

Best IRA Accounts

Best Roth IRA Accounts

Best Investing Apps

Best Free Stock Trading Platforms

Best Robo-Advisors

Index Funds

Mutual Funds

EU reportedly set to fine Apple 500 million euros amid antitrust crackdown

thumbnail

  • The latest investigation focused on whether Apple had restricted apps from informing users about cheaper subscription alternatives outside of its App Store.
  • The Financial Times reported the European Commission will accuse Apple of abusing its power and will ban its "unfair trading conditions" in regard to its music service subscription policies.

In this article

The European Commission is set to fine Apple about 500 million euros ($539 million) over alleged breaches of EU competition law, the Financial Times reported on Sunday, citing unnamed sources with knowledge of the matter.

Brussels first launched an investigation into allegations that Apple hindered third-party music services on its devices and favored its own Apple Music service, after Spotify filed a formal complaint to regulators in 2019.

In most regions, Apple's App Store rules prohibit companies such as Spotify from billing users for subscriptions directly within the app, making them instead use Apple's App Store billing service, which takes a cut of up to 30%.

Brussels formally charged Apple in an anti-competitive probe in 2021, but narrowed the scope of the investigation last year, abandoning a charge of pushing developers to use its own in-app payment system.

The latest version of the probe focused on whether Apple had restricted apps from informing users about cheaper subscription alternatives outside of its native App Store and thus violated EU competition laws.

The findings of the investigation will lead to the Commission accusing Apple of abusing its powerful position and banning its "unfair trading conditions" regarding its music service subscription policies, sources told the FT.

If imposed, the fine would be one of the most substantial financial penalties the EU has imposed on a major technology company. It follows a series of large contested fines against Google .

While Apple has faced fines for antitrust behavior before — such as the €1.1 billion penalty in France that was later reduced to €372 million on appeal — this would mark its first such fine from Brussels.

Big tech preps for EU crackdown: Here's what you need to know

The reported fine is part of a broader crackdown in the EU and comes ahead of the enactment of the bloc's landmark Digital Markets Act set for March. The new law aims to address anti-competitive practices from big tech players deemed as "gatekeepers," including companies such as Apple, Amazon and Google.

Smaller internet firms and other tech businesses, such as Spotify, have long complained of being unfairly limited by these tech giant's business practices.

In Apple's case, the Digital Markets Act will require it to allow third-party developers to distribute apps outside the iOS Store and for those apps to bill their customers directly.

Apple has made moves to address EU regulations by announcing changes to its iOS, Safari and the App Store in the EU, and announced that it will soon allow software developers to distribute their apps to Apple devices via alternative stores.

In a separate antitrust case, the European Commission is looking into the way Apple restricts rivals from accessing its Apple Pay mobile system. Apple has already made concessions in relation to the case.

The timing of the Commission's announcement on the fines has not yet been set, but that will not change the direction of the antitrust investigation, according to the FT report.

Apple has the right to appeal the decision in EU courts. The tech giant declined to comment on the report, referring CNBC to a previous statement that it was pleased regulators narrowed the focus of the probe.

Read the full report from the Financial Times.

comscore

What's Hot

Wisconsin ethics commission says trump pac committed felonies: reports.

Sara Boboltz

Reporter, HuffPost

commissions paid report in quickbooks

His legal headaches keep piling up.

Wisconsin’s bipartisan ethics committee has reportedly accused President Donald Trump ’s Save America PAC of scheming with Wisconsin Republicans to circumvent campaign finance laws in a 2022 race to unseat a powerful Trump critic in the state — Wisconsin Assembly Speaker Robin Vos (R).

The Wisconsin Ethics Commission recommended Save America be charged with felonies alongside state Rep. Janel Brandtjen (R) and a string of others, as the blog WisPolitics first reported Friday.

The commission sent its recommendation to multiple county prosecutors on Tuesday, according to the Milwaukee Journal Sentinel . If those prosecutors do not charge the parties within 60 days, the commission can go over their heads, the paper noted.

The allegations stem from the 2022 primary race involving Vos and a Republican challenger, Adam Steen.

Vos earned Trump’s ire in 2020 when he pushed back on Trump’s efforts to overturn the results of the 2020 presidential election — after spending years trying to cement Republican power in his home state.

Wisconsin law stipulates that $1,000 is the most an individual can donate to a candidate for the state assembly. The commission alleged that larger individual donations were funneled to Steen’s campaign illegally by taking advantage of state laws that put no limits on the amount political parties can donate to candidates, per the Washington Post .

WisPolitics laid out how the scheme worked: Donors who wanted to support Steen were told to make out checks to the Langlade County GOP with “63” in the memo line, and that money would be directed toward Steen even if it was above the $1,000 limit. (The number refers to Vos’ district.)

Steen’s effort to unseat Vos was a big failure .

But the ethics panel’s recommendation comes as Vos continues to fight off challenges from Trump-aligned segments of his party. Last month, Trump allies in Wisconsin filed a petition seeking to recall Vos from office .

It also adds to the towering list of accusations involving the Republican presidential front-runner. Trump is currently facing 91 charges in multiple jurisdictions ahead of the 2024 presidential election in November.

Support HuffPost

Our 2024 coverage needs you.

At HuffPost, we believe that everyone needs high-quality journalism, but we understand that not everyone can afford to pay for expensive news subscriptions. That is why we are committed to providing deeply reported, carefully fact-checked news that is freely accessible to everyone.

Whether you come to HuffPost for updates on the 2024 presidential race, hard-hitting investigations into critical issues facing our country today, or trending stories that make you laugh, we appreciate you. The truth is, news costs money to produce, and we are proud that we have never put our stories behind an expensive paywall.

Would you join us to help keep our stories free for all? Your contribution of as little as $2 will go a long way.

As Americans head to the polls in 2024, the very future of our country is at stake. At HuffPost, we believe that a free press is critical to having well-informed voters. That's why our journalism is free for everyone, even though other newsrooms retreat behind expensive paywalls.

We cannot do this without your help. Support our newsroom by contributing as little as $2 to keep our news free for all.

As Americans head to the polls in 2024, the very future of our country is at stake. At HuffPost, we believe that a free press is critical to creating well-informed voters. That's why our journalism is free for everyone, even though other newsrooms retreat behind expensive paywalls.

Our journalists will continue to cover the twists and turns during this historic presidential election. With your help, we'll bring you hard-hitting investigations, well-researched analysis and timely takes you can't find elsewhere. Reporting in this current political climate is a responsibility we do not take lightly, and we thank you for your support.

Contribute as little as $2 to keep our news free for all.

Popular in the Community

From our partner, more in politics.

commissions paid report in quickbooks

IMAGES

  1. QuickBooks POS: Employee Commissions

    commissions paid report in quickbooks

  2. Accrual Method for Calculating Commissions in QuickBooks

    commissions paid report in quickbooks

  3. QuickBooks Online: Commissions Due Report

    commissions paid report in quickbooks

  4. QuickBooks Enterprise Advanced Reports: Commission Report with Tiered

    commissions paid report in quickbooks

  5. QuickBooks Online Tutorial: Tracking Commissions by Rep in Sales Transactions

    commissions paid report in quickbooks

  6. QuickBooks Financial Reports, Cash Flow and how…

    commissions paid report in quickbooks

VIDEO

  1. QuickBooks tutorial coming soon

  2. QuickBooks- Selling Accounting Services Virtually

  3. Customize Report 2045 QuickBooks Online 2024

  4. quickbooks online new company

  5. Transaction List by Date Report 4200 QuickBooks Online 2024

  6. Payroll & Employee Report 4160 QuickBooks Online 2024

COMMENTS

  1. Sales Rep Commission Report

    Go to the Reports menu, then go to Sales. Click Sales by Rep Detail. Select Customize Report, then choose Cash basis under the Display tab. Go to the Filters tab. In the Search Filters field, enter and select Transaction type. Under Transaction Type, select Invoice, then click OK. Change the To and From dates, then click Refresh .

  2. Track sales commissions in QuickBooks Online

    To find out how much each salesperson sold, you can run sales reports by Class or Location. You can also run Profit and Loss reports by Classor Location. To pay your salesperson their commissions, run the Sales by Class/Location report, and then multiply your salesperson's commission percentage by the amount they sold then go to the Write Check ...

  3. How to add a sales commission tracker in QuickBooks

    After putting it to the test, adding commissions in QuickBooks Desktop is a two-step process. First, you must set up a commission pay item. To do so, follow these instructions: In "Lists", select "Payroll Item List". Under the "Payroll Item" dropdown menu, click "New". Select "Custom Setup", then click "Next". Select ...

  4. How To Track Commissions In QuickBooks

    QuickBooks Desktop. To set up commission in QuickBooks Desktop, there are two steps. The first is to set up a commission pay item. To do this, follow these instructions: From 'Lists', select 'Payroll Item List'. Under the 'Payroll Item' drop-down menu, click 'New'. Select 'Custom Setup', then click 'Next'.

  5. How To Set Up Commission In QuickBooks Online

    Step 2: Start recording commissions in Payroll. Here's how to set up commissions in QuickBooks Online: From the 'Payroll' menu, go to 'Employees'. Select your employee. You should see 'Pay Types'. Select 'Start' or 'Edit'. From here, the process depends on whether commission is your employee's salary or additional pay.

  6. How to Record Sales Commission in QuickBooks

    Quickbooks asks for an item code on the invoicing screen (i.e. Stock item), but the properties are not owned by the estate agency. . A: You can only use items on Invoices. For commission earned, create an item and link it to income account. Then, you can enter a sales receipt to track the commission earned. Use Sales Commission as the item.

  7. QuickBooks Online Tutorial: Tracking Commissions by Rep in ...

    QuickBooks 30-day free trial + 30% off for 12 months: https://quickbooks.intuit.com/partners/irp/?cid=irp-4337#pricing Call our office 954-414-1524 to setup...

  8. How sales commissions are reported in the income statement

    A sales commission is the amount of compensation paid to a person based on the amount of sales generated. This is typically a percentage of sales, which is paid on top of a base salary. Accounting for Sales Commissions. Any commissions expense is recognized under the accrual basis of accounting as soon as the business has incurred the expense.

  9. How to Attach a Sales Rep Commission in QuickBooks

    6. Create your invoice as normal and select the "Rep" drop-down list. Add your sales rep to the invoice. If your invoice doesn't have a Rep field, you must add it. Click the "Lists" menu ...

  10. How do i record commissions to specific jobs and and pay ...

    Example if you pay the commission in a different period as the jobs were invoiced and you want to allocate the commission in that or those periods. For this example, you will need to create a payroll clearing account under your liabilities in your Balance Sheet and make at least 2 journal entries.

  11. Tracking Sales Commissions in QuickBooks Online Explained

    Here are 5 reasons any sales manager will want to consider investing in a robust commission tracking software for Quickbooks Online. 1. Streamline the process of tracking commissions for employees and sales reps. It can be a daunting task for businesses to keep track of commissions for their employees or sales representatives.

  12. Calculating Sales Commissions With QuickBooks Online

    Connecting to QuickBooks Online takes less than 1 minute. Each sales rep will get an online incentive dashboard they can use to review crediting, check payouts, and more - from any device. Your sales reps will always be paid the right amount - on time. Making changes to your commission plans and generating commission reports will be easy.

  13. How to Accurately Track Sales Commissions

    Commission rates often vary by item and your salespeople may only be paid when the customer has paid you, which complicates things even more! While QuickBooks lacks a dedicated resource for tracking and reporting commissions, the following method using items and a commission payable transaction detail report is an accurate, streamlined way to ...

  14. How To Track Commission In QuickBooks Desktop

    Step 1: Set up a commission pay item. The first step in learning how to track sales commission in Quickbooks Desktop is to set up a commission pay item. Here's a step-by-step guide on how to do this: In 'Lists', select 'Payroll Item List'. Under the 'Payroll Item' drop-down menu, click 'New'. Select 'Custom Setup', then ...

  15. Commission expense accounting

    Under the cash basis of accounting, you should record a commission when it is paid, so there is a credit to the cash account and a debit to the commission expense account.. If an employee is receiving a commission, then the company withholds income taxes on the amount of the commission paid to the employee. If the person receiving the commission is not an employee, then that person considers ...

  16. How to Create Commission Reports for Sales Reps in QuickBooks

    QuickBooks can run a report of gross profit by "class.". We can then create a class for each of your sales reps. Take care to add the Customer:Job for each line item in each supplier purchase order to make sure the expenses tie back to the customer. Then, export the report showing gross profit by class to Excel and calculate your ...

  17. Create a Commission or Bonus Paycheck in QuickBooks Online

    Then click the drop-down arrow on the "Run payroll" button in the upper-right corner of the page. Then select either the "Bonus only" or "Commission only" command from the drop-down menu, as needed. If you select the "Bonus only" command, then the "Run Payroll: Bonus Only" window opens. This screen doesn't appear for the ...

  18. QuickBooks Commission Tracking Software

    Core offers a customized integration experience with all of the functionality that you need to easily connect with QuickBooks accounting software. Our advanced ETL tool allows us to pull, modify, or push any data needed from QuickBooks to easily merge metrics and accurately measure growth. Integrating your business systems sets up your ...

  19. Quickbooks

    NEW FEATURE RELEASES: ASC 606 reports, Commission Lock, Pay Cycle Manager, Simplified CSV Import. Features. Varied Commissions; Multi-Currency Support; Sales Splits; Manager Override Commission; ... Commissionly integrates seamlessly with QuickBooks Online software with our direct integration - quick and easy. FEATURES AND BENEFITS .

  20. What Is Sales Commission? How Do You Calculate It?

    Commissions often push sellers to achieve sales goals and generate revenue. For example, let's say your leading rep's base salary is $100,000. Your company offers a 10% commission for a product valued at $5,000. If they sell just one of those products, their net pay is $100,00 + (.1 x $5,000) = $100,500. I believe commissions are a game ...

  21. Firms must help menopausal workers, or face being sued

    The Equality and Human Rights Commission (EHRC) issued the guidance to clarify the legal obligations to workers going through the menopause. Symptoms can include hot flushes, brain fog and ...

  22. Connect Easy-Commission with QuickBooks Online

    For Accounting, retain all data in one place and calculate commissions accurately. Pay commissions on time and make commissions available to reps online for easy access. Save time and effort in calculating commissions. Analyze and report on all data. For Sales Management, Track customer related activities and opportunities.

  23. EU set to fine Apple 500 million euros in antitrust crackdown: Report

    The European Commission is set to fine Apple a historic 500 million euros over alleged breaches of EU competition law, the Financial Times reports . ... Buy Now Pay Later (BNPL) Apps. Best Debt ...

  24. Properly entering Sales Commission income and categorizing

    line 1 CLIENT FUNDS DUE (author specific short-term liability account) = $85. 3. receive payment to the specific invoice. 4. pay client bill. This process shows that income account increased $15, client liability account increased $85 and then decreased $85, and results in an invoice, bill and check which I can track.

  25. Wisconsin Ethics Commission Says Trump PAC Committed Felonies: Reports

    Wisconsin's bipartisan ethics committee has reportedly accused President Donald Trump's Save America PAC of scheming with Wisconsin Republicans to circumvent campaign finance laws in a 2022 race to unseat a powerful Trump critic in the state — Wisconsin Assembly Speaker Robin Vos (R). The ...