Processing commissions without integrated payroll

Hello, I'm a Long time user of Sage100/Mas200 (1999), this is my first post.

For the last 4-5 years we have not used the commissions reporting for accrual entry creation or payment to the sales team due to an previous controller created a process to export the report into excel and use pivot tables. He is gone and the process is overwhelming to our new controller.  We are in the process of upgrading from 2015 premium to 2019 and I would like to learn the correct process. I have read all the posts and documentation I can find, however I cannot find the correct process if you do not have payroll integrated.

Would someone please explain or point me in the direction of the commission reporting process for 2019 if I use an outside payroll processor.

Thanks in advance

  • 0

    Commission and payroll do not have to be tied together. We use commission reporting and do not use payroll and it works just fine. You just have to go to AR Options and in the Commission section decide what it is based on. Then just run the report. You can update to AP but as we use a web based payroll company we just enter the commission amount when doing payroll.

  • 0

    BigLouie thank you for the reply

    we currently have commission reporting and paid invoices only turned on and calc based on GP.

    1. If I turn on update commissions to other modules and link each salesperson to GL, when does the accrual entry take place?

    2. When I print the commission report for the values to give to HR for payroll processing, how/where does the record get flagged as commission paid, so I can track which invoices have commissions paid on and which do not.

    Appreciate the information.