This article explains how to export a report to ACE.
The ACE Payroll Report is already set up in the layout for ACE systems. If you are generating a report to be exported directly to ACE, then we suggest you leave the fields as they appear with no custom columns. If you are exporting the report for internal use, you can make any changes you require.
Click the Reports button on the main Header.
Scroll to the Staff Scheduler Reports box (this maybe a different heading depending on your Webcare setup) and click on ACE Payroll Report.
The ACE Payroll Report page will open.
Select the options for your ACE Payroll report.
1. Zone/Area - Leaving this blank will include ALL Zones. Otherwise you can use the dropdown list to select specific zones.
2. Staff - Like Zones/Area leaving this blank will include ALL Staff. Otherwise you can use the dropdown list to select specific staff.
3. Hours Type - For an ACE Payroll Report this will be Actual. This shows the hours actually completed by the staff.
4. Start and End Date - Select the date range for the report you are generating.
5. Group by Weeks - For an ACE Payroll report, you need to de-select this box. (ACE may reject the report if grouped)
6. Show Daily Totals - Tick if you would like to show daily totals in your report.
7. Show Subtotals - Tick if you would like to show subtotals in your report.
8. Generate Report - Once these options have been configured, click on Generate Report.
Once the report has been generated, if you are wanting the report for internal use, you can customise it by adding or removing columns. To do this click on the Show Customisation Window. This will bring up the Field Chooser box.
To add a column, simply drag a field from the Field Chooser box onto the report header and drop it.
To remove the column, select the column header, drag it back to the Field Chooser box and drop it.
Once you are happy with your report, export it by clicking on To CSV. This ensures it is in the correct format for ACE systems.