MYOB Payroll and Commission Calculations
Commissions and how they are calculated vary enormously from business to business. Your best approach is usually to generate a salesperson report in MYOB software that provides information in a format close to what you’re looking for, and from there send the report to Excel to make your commission calculations. Here are some tips: - Remember to complete the Salesperson field when recording sales.
- In the Sales menu, find the report that is closest to the one you’re looking for. Don’t hesitate to click the Design button and experiment with the different types of information you can display.
- Set up commission rates in the Custom Lists of each salesperson’s card (under the Card Details tab). Remember to display this custom field when generating reports.
- When the report looks close, click the Send To button and send the report to Excel. From there, you should be able to make minor adjustments to create the report you’re looking for.
- If you want to automate the process of customising this report in Excel, you should be able to create additional worksheets that link to the worksheet that MYOB software creates automatically every time.
Alternatively, if you find yourself doing significant hours of calculations by hand, or in additional spreadsheets, consider contacting an MYOB Certified Consultant that specialises in custom reporting or purchasing a ready-made add-on report. See our MYOB Add On Solutions page for more details. Employees and Salespeople Tip: Even if a salesperson isn't an employee, you need to select Employee as the Card Type when creating a new card for that salesperson. However, if you select Labour Hire as the Employment Basis in that salesperson's card, MYOB knows not to treat them as an employee when printing payment summaries at the end of the year. The contents from this page are taken from Making the Most of MYOB Payroll, 2nd edition, by Veechi Curtis, available online for only $19.95 << Back to MYOB Payroll page
|
