Quickbooks-Paying a Rep

Posted on 2011-04-23
Medium Priority
Last Modified: 2012-06-21
I have reps in the field that are paid a commission on the sales they write.  When we receive a sale, we assign that sale to a rep.  When the invoice is paid, the commission becomes due.  Is there a way to handle this in Quickbooks?
Question by:akbiro
  • 2

Accepted Solution

QBalance_QuickBooks_Advisor earned 2000 total points
ID: 35452968
There is not a way to have QB automatically calculate the commission payable
But below is  a report that many companies will memorize and run and export to excel and a commission rate assigned and calculated.

There are add-on software available
http://marketplace.intuit.com  which will help you track complex commission structure

The new APP Center has an commission application that integrates with QuickBooks.
I do not have experience with it

To determine the commissionable amount,
Run the following Reports > Sales by Rep (or Sales by Rep detail)
Click on Modify button on the report button bar
Change the date range to Last month
Click on the CASH Basis
Click on the filter tab >   Select the item filter
  Click on the down arrow next to the item filter and scroll up to select
  Multiple items,  click hold and drag down the mouse to select all items
  Then unselect the items you do not want to pay commission on such as

Linda Saltz

Author Comment

ID: 35453312
Cool beans...let me give it a whirl!

Author Closing Comment

ID: 35460459
Perfect and thanks

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You may need to view past transactions from previous QuickBooks files or other QuickBooks company files when:       1. you are working in another QuickBooks file       2. QuickBooks is closed QuickBooks users who would benefit from this artic…
Quickbooks hosting can do wonders to your enterprise but considering the points elaborated in the article which will help you to better analyze the outcomes. So scan your business, its needs and then move to the new world of limitless benefits.
Loops Section Overview
Screencast - Getting to Know the Pipeline
Suggested Courses
Course of the Month15 days, 13 hours left to enroll

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question