AllBusiness.com
    • Starting a Business
    • Career
    • Sales & Marketing
    • AI
    • Finance & Fundraising
    • M & A
    • Tech
    • Business Resources
    • Business Directory
    1. Home»
    2. Finance»
    3. Paying a Sales Rep»

    Paying a Sales Rep

    Brandon Morris
    FinanceLegacy

    I ran across this question with a local (one-on-one) client of mine the other day...actually it was last month early.  I got an e-mail from the business owner last week asking me if I could come back and show him again what we did.  Seems that his assistant never came back to work after spending that hour with me in his office.  Am I really that bad?  Just kidding...well, sort of...she really didn't ever return.



    Anyway, today I want to talk about paying sales reps...actually gets more into reporting than it does paying the sales rep, but it was an interesting question.



    His question was he had one sales rep he wanted to pay, he gets commission on the sales of the merchandise, any sales item, NOT including shipping/freight or sales tax.



    If you go run a sales by rep summary (1st one)below...which pulls off of the one invoice (2nd one)below...see the next two screenshots...




    Noice the bottom line item on the above report for $300.00 for Freight & Delivery...





    For example...if you have this invoice which includes shipping of $300.00 (highlighted)...you do not want to pay your sales rep a commission for this delivery charge.  So, what's a person to do...how do you get the total amount to calculate your reps commission?



    Sure, for one invoice, you subtract the $300.00 but in a month, what if you had 20 or more invoices to do...there would have to be an easier way of doing this otherwise, well, I wouldn't be blogging about it now would I?



    To get the shipping or anything else out that you didn't want to pay commissions on, you need to modify the report by filtering out the items that you do not want to include...in this case we want to include everything EXCEPT the delivery charge of $300.00.





    Notice, on the screenshot above, on the right - 'Current Filter Items' is selected...now in the middle...we have selected 'Multiple Items...'  When you select multiple items, you get a dropdown list of all your items you want to run your report on...in this case we check everything except the 'Delivery Charges' item we don't want to report on.



    The same is true for all other reports, modify your reports to get the data you need out of it.  QuickBooks should be working for you.  If you are putting the data into you, you should be able to get the data out in the way that you want to see it.  Honestly, it takes some getting used to.




    On nother note, I will be writing soon about customizing invoices and receipts, how to, why, etc.  I am gathering a handful of highly customized invoices and receipts now, if you or your associates have one they could send me I would appreciate it...something this is out of the norm that doesn't look like the generic QuickBooks form please send it to me...perhaps I'll have an opportunity to display it.  Send them to brandon@baronsinc.com.



    As always, if you have questions or a topic you'd like me to cover, send it to me...



    Thanks,



    Brandon Morris, Advanced Certified QuickBooks ProAdvisor


    Barons', Inc.



    Hot Stories

    Using ChatGPT to write business analysis prompts

    5 ChatGPT Prompts to Help You Perform Business Analysis

    Using ChatGPT to answer business questions

    5 Ways to Get Better Answers From ChatGPT About Business

    Profile: Brandon Morris

    Brandon Morris, Advanced Certified QuickBooks ProAdvisor, is co-founder and co-owner of Barons', Inc.

    BizBuySell
    logo
    AllBusiness.com is a premier business website dedicated to providing entrepreneurs, business owners, and business professionals with articles, insights, actionable advice,
    and cutting-edge guides and resources. Covering a wide range of topics, from starting a business, fundraising, sales and marketing, and leadership, to emerging AI
    technologies and industry trends, AllBusiness.com empowers professionals with the knowledge they need to succeed.
    About UsContact UsExpert AuthorsGuest PostEmail NewsletterAdvertiseCookiesIntellectual PropertyTerms of UsePrivacy Policy
    Copyright © AliBusiness.com All Rights Reserved.
    logo
    • Experts
      • Latest Expert Articles
      • Expert Bios
      • Become an Expert
      • Become a Contributor
    • Starting a Business
      • Home-Based Business
      • Online Business
      • Franchising
      • Buying a Business
      • Selling a Business
      • Starting a Business
    • AI
    • Sales & Marketing
      • Advertising, Marketing & PR
      • Customer Service
      • E-Commerce
      • Pricing and Merchandising
      • Sales
      • Content Marketing
      • Search Engine Marketing
      • Search Engine Optimization
      • Social Media
    • Finance & Fundraising
      • Angel and Venture Funding
      • Accounting and Budgeting
      • Business Planning
      • Financing & Credit
      • Insurance & Risk Management
      • Legal
      • Taxes
      • Personal Finance
    • Technology
      • Apps
      • Cloud Computing
      • Hardware
      • Internet
      • Mobile
      • Security
      • Software
      • SOHO & Home Businesses
      • Office Technology
    • Career
      • Company Culture
      • Compensation & Benefits
      • Employee Evaluations
      • Health & Safety
      • Hiring & Firing
      • Women in Business
      • Outsourcing
      • Your Career
      • Operations
      • Mergers and Acquisitions
    • Operations
    • Mergers & Acquisitions
    • Business Resources
      • AI Dictionary
      • Forms and Agreements
      • Guides
      • Company Profiles
        • Business Directory
        • Create a Profile
        • Sample Profile
      • Business Terms Dictionary
      • Personal Finance Dictionary
      • Slideshows
      • Entrepreneur Profiles
      • Product Reviews
      • Video
    • About Us
      • Create Company Profile
      • Advertise
      • Email Newsletter
      • Contact Us
      • About Us
      • Terms of Use
      • Contribute Content
      • Intellectual Property
      • Privacy
      • Cookies