Deputy's integration with Sage enables you to export time and attendance data from Deputy into a formatted Excel file, which can be uploaded directly into either Sage 50 or Sage 200.
Before you begin
You will need to make sure that the Employee Payroll lD in Deputy matches the Employee Reference ID in Sage. You will also need to ensure that once you import your Deputy timesheet into Sage, the correct pay fields are identified and mapped out.
Matching employee Payroll ID in Deputy and Sage
Employee reference codes in Sage need to match Payroll ID codes in Deputy. To view your employee reference codes in Sage navigate to the Employee tab to view your Employee List. Employee Reference numbers should be visible next to each employee in the leftmost column by default.
These codes must be unique and match each employee’s Payroll ID in Deputy.
To set or update a team member's Payroll ID in Deputy:
1. On the People page and click on the team member you would like to update the Payroll ID for.
2. Select Employment from the left-hand menu and click on Edit.
3. In the Pay Details section of Employment you can see there are several options to configure:
Exporting Timesheets from Deputy
1. Once you have approved your timesheets, select Export Timesheets from the Timesheets tab.
2. Select the date range and team member's timesheets from the list on the left you wish to export and then click Export Selected Items.
3. Select either Sage 50 or Sage 200 from the dropdown menu.
4. Specify a file name if desired and click Export.
You will be prompted to download a CSV or Excel file which you should save to your desktop.
Importing into Sage
Once your timesheet export file has downloaded, return to Sage and select File > Advanced Data Import. Here you will be able to select your import template, where you must select the ‘Timesheet Payments’ template. Here, Sage will prompt you to select your recently exported timesheet file from Deputy.
Matching payroll fields in Sage
With your timesheet file uploaded, you will be prompted to confirm that the imported pay fields from Deputy match up with your existing payroll fields in Sage.
If the column names in your Deputy import file aren’t identical to the names you have set in Sage, you will need to manually map your import fields to match your Sage payroll fields using the dropdown lists. Note that there will be an extra row in the Import Field column for the employee’s full name, that will not have an equivalent value in the Payroll Field, so will be left blank. If the Import Field values are all blank you will need to convert the CSV file to a standard Excel file (.XLS) and upload again.
Once you’ve correctly mapped out your import fields to map your Sage payroll fields, click Save Map. This will keep a record of all your pay fields so that for your next pay run you can select this map to auto-populate your import fields.
With this step completed, click Finish to import your time and attendance data into Sage.