1. Right-click the file ZSALSP.xlt at the bottom of this page and choose Save link as or Save Target as.

2. Save the file to the Spredsht folder in your AccountRight program folder. Here's the default location of the Spredsht folder:

   If you're using	The Spredsht folder is here (v19.12 or earlier)	The Spredsht folder is here (v19.13 or later, Australia only)
   AccountRight Standard	C:\Standard19\Spredsht	N/A
   AccountRight Plus	C:\Plus19\Spredsht	C:\PlusClassic\Spredsht
   AccountRight Premier	C:\Premier19\Spredsht	C:\PremierClassic\Spredsht
   AccountRight Enterprise	C:\Enterprise19\Spredsht	C:\EnterpriseClassic\Spredsht

3. When asked if you want to overwrite the existing file, click Yes. This will replace the existing template.
4. Double-click the template to open it in Excel.
5. 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.
   Image RemovedImage Added 
6. In the table below the Target Analysis button, update the sales targets for your employees.
   Image Added 
7. Save your changes:
   1. Go to the File menu and choose Save As.
   2. Save the file in its original location (see the table above).
   3. Ensure the File name is 'ZSALSP.xlt' and the Save as type is 'Excel 97-2003 template (*.xlt)'.
      
   4. If prompted to overwrite or replace the existing file, click Yes.

1. In your MYOB software, go to the Reports menu and choose Index to Reports.
2. Click the Sales tab.
3. Under the Salesperson heading, click the Analyse Sales report.
4. Filter the report for the period you wish to calculate commission for.
5. Click Display.
6. Click Send To and choose Excel.
7. When the information has filtered into the Excel worksheet, click the Calculate Commission button.
    
8. Click the Target Analysis button. For the automation to work, you must click Calculate Commission before Target Analysis.

Attachments

 ZSALSP.XLT