Fringe Benefits Tax Query by Payroll Year

The attached query (please log in to view files) was requested as part of the Payroll End of Year Rollover Webinar held in May 2019

The query has parametised criteria for the Payroll Year.

To apply this query to your instance of Synergetic :

1. Click on the above workbook > select Download > Save the workbook to a safe location you can access
2. Open the workbook and select Data > Queries & Connections > double click on "Query from Synergetic"

Select Definition > Connection string > delete everything after "DSN=Synergetic" > Select OK

The query will now connect with your instance of Synergetic. You can check this by reviewing the Connection string again.