Quickbooks-Paying a Rep

Posted on 2011-04-23
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
    LVL 6

    Accepted Solution

    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  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

    Cool beans...let me give it a whirl!

    Author Closing Comment

    Perfect and thanks

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    By Linda Saltz Customized item descriptions from bills DO import into a customer invoice!   This is a wonderful tip for companies that want to use generic items like Hardware, Software, Mileage, Travel in their item list which helps keep the i…
    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…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

    732 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

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now