Just these help pages, not phone support or the product itself
Why did you give this rating?
Anything else you want to tell us about the help?
If you pay sales commission to staff, we've provided a template at the bottom of this page which lets you calculate commissions for a given period. You'll need to be using the Salesperson field on your invoices for commissions to be calculated.
All you need to do is add this template to your AccountRight report templates. Then when you run the Analyse Sales [Salesperson] report in AccountRight and export it to Excel, the report will display using the downloaded template.
Right-click the file ZSALSP.xlt at the bottom of this page and choose Save link as or Save Target as.
Save the file to the Spreadsheet folder here: C:\Users\<Username>\Documents\MYOB\AccountRight\201x.x\Reports\Spreadsheet
When prompted, choose to Replace the file in the destination. This will replace the existing template.
Double-click the ZSALSP.xlttemplate to open it in Excel.
In the table below the Calculate Commission button, change the sales and commission % to suit your needs. The default table values mean a 5% commission will be calculated on sales up to $500, a 10% commission on sales up to $800, etc.
Save your changes:
Go to the File menu and choose Save As.
Save the file in its original location (C:\Users\<Username>\Documents\MYOB\AccountRight\201x.x\Reports\Spreadsheet).
Ensure the File name is 'ZSALSP.xlt' and the Save as type is 'Excel 97-2003 template (*.xlt)'.
If prompted to overwrite or replace the existing file, click Yes.