Sybiz Visipay – Hints and Tips

Sybiz Visipay

Superannuation on payslips

Sybiz currently provides an expected date of payment for superannuation payments on payslips. This was originally a requirement stipulated by the Government. Since then they have reversed this decision and it is therefore not a required field on payslips currently.

The Government is now intending that payroll providers show the actual date of payment of the super on the payslip. We, and other software companies, are making representations to the Australian Tax Office that this is very difficult to achieve, unless it is maintained manually, as there is no intelligence between payroll and accounting systems at a transactional level. We are hopeful that they will see the light and not impose this upon the payroll software community and will keep you informed as to the eventual decision.

Sybiz Business Intelligence Centre – Hints and Tips

Sybiz Vision Business Intelligence Centre

Templates

When developing a template, it is recommended to do so using Excel 2003 and to link the template back as an .xlt file. This will ensure that the template is compatible on all versions of Excel. However if you want to use Sparkline’s and slicers in your reports you need to make you templates Excel 2010 compatible.

1. Run out you standard report into Excel from the Report Manager.
2. Go back to your Report Manager and right select on the report you have run.
3. Select Un-link template.

20130201-BIC-01

4. The Excel Template is no longer linked to the report.
5. Right select on the Report again and select Create & Link Template.

20130201-BIC-02

6. Then select a workbook to Covert Template screen will open, select the workbook from the list. Select OK.

20130201-BIC-03

7. Select Yes, to place Parameters on the Second Sheet.

20130201-BIC-04

8. Select the Template File Format to use. This time select Excel 2007 (.xltx) this will ensure the template is compatible with Excel 2007 and Excel 2010. Allowing you now to use slicers and Sparkline’s in your reports.

20130201-BIC-05

9. Specify the Template name, you will notice it is now a (.xltx).

20130201-BIC-06

10. The Excel Template will be linked to the report as an Excel 2007 Template (*.xltx).

20130201-BIC-07