Find a Help Topic

Deputy Integration


In this topic

Introduction

This topic describes how an employer can integrate Deputy with Payroll.

Deputy is a third party time capture and award interpretation application.

Interpreted timesheet data can be exported from Deputy into Payroll for processing each pay period.

Note: The following information is provided as is and is provided only in the interest of trying to assist you as much as possible as a valued client. However, as Deputy is a third party product we’re not experts on its use and can’t easily keep abreast of any changes that Deputy may make within their system from time to time. Should you have difficulty following this documentation, please seek the assistance of Deputy’s customer experience team and advise us if changes are required to this documentation.

How do I configure the Deputy/Payroll integration?

The Deputy integration is a flatfile integration. The flat file contains a row for each payment that needs to be made, including:

  • The employee code of the employee the payment relates to
  • The cost centre that the payment needs to be allocated to
  • The paycode that the payment relates
  • The number of units/hours for the payment

To configure the Deputy integration, you may need to update the your Employee, Cost Centre and Paycode codes in Deputy so that they match those in Payroll.

To obtain a list of the codes for your Payroll account, please contact your provider to request a Payroll Upload Codes report. If you have more than one employer, the codes will likely be different for each one so you will require a report for each employer.

Updating your employee codes in Deputy

To update your employee codes in Deputy, from the Home screen:

  1. Choose People from the header menu
  2. Click the Name of the person you want to edit
  3. Click the Edit Profile button
  4. Choose Pay rates and leave from the sidebar menu
  5. Enter the employee code at the Timesheet export code field
  6. Click Save

Note: Your employee codes may already be in Deputy, especially if you provided them to us during implementation.

Updating employee codes in Deputy

Updating your cost centre codes in Deputy

Did you know? In Deputy, cost centres are called Areas.

To update your cost centre codes in Deputy, from the Home screen:

  1. Choose Locations from the header menu
  2. Click the Areas menu item from the sidebar menu
  3. Click the Edit button next to the area whose cost centre code you need to review/edit
  4. Enter the Cost Centre code from Payroll into the Export Code (optional) field
  5. Click Save

Updating cost centre codes in Deputy

Updating your paycode codes in Deputy

Deputy has two concepts that are similar to Payroll’s paycodes:

  1. Leave Rules (where you can update the codes for various leave types)
  2. Pay Rates (where you can update the codes for other payment types like overtime, ordinary hours, etc).

You may need to make changes to both of these.

Updating Codes for Leave Rules

To update the codes for the Leave Rules:

  1. From the user menu at the top right, choose Global Settings
  2. Click the Leave tab if it is not already selected
  3. Click the Edit icon next to the leave type that you need to changes
  4. Update the Export Code field with the relevant paycode ID from Payroll
  5. Click the Save this Leave Condition button
  6. Click the Back to List button to continue editing other leave types.

Updating leave rule codes in Deputy

Updating Codes for Pay Rates

To update the codes for the pay rates, from the Home screen:

  1. Click the Timesheets -> Export Timesheets menu item
  2. Click the Select All button on the left hand side to choose all employee’s timsheets
  3. Click the Group by Pay Rate button to group the timesheet data by the relevant pay rates
  4. In the Export Code column, click the Edit button next to the pay rate whose code needs to be changed
  5. Update the Export Code field to match the relevant paycode ID from Payroll
  6. Click the Save button

Updating pay rate codes in Deputy

Exporting your payroll data from Deputy

To export your payroll data for processing in Payroll, from the Home screen:

  1. Click the Timesheets -> Export Timesheets menu item
  2. Choose the Date Range for the timesheets that you want paid in the payroll
  3. Click the Select All button on the left hand side to choose all employee’s timsheets or individually choose employees with timesheets to pay
  4. Click the Export Selected Items button
  5. Ensure that Aussiepay Export is selected in the format dropdown
  6. Click the Export button to download a file to be imported into Payroll

Note: It is important that the export file is never edited in Excel as doing so can corrupt the file. Should you need to edit the file, you should use a plain text editor like Notepad or Notepad++. We do not recommend editing the export file manually.

Exporting a payroll file

Uploading the export file into Payroll

To import the file into Payroll, you will need to:

  1. Log into Payroll
  2. Go to the Payroll -> Open Payrolls screen
  3. Click the Upload Data button
  4. If you have more than one pay cycle, ensure the correct payroll is selected in the Payroll dropdown
  5. In the Payroll File section, click the Choose File button and choose the file that you exported from Deputy
  6. In the Payroll File Section, click the Upload button
  7. Review the Event Listing for errors

After the file has been successfully imported without errors, you can run your payroll. Refer to the Processing a Normal Payroll help topic for more information about running your payroll.

Note: If there were any errors, they will need to be fixed and then the file will need to be imported again.

Note: When importing a file, it will typically override any data that is already in the payroll.

Importing a payroll file

Common Import Errors

Truncation errors for all rows, listing ‘NumPays’ as the erroring column

Example:

Bulk load data conversion error (truncation) for row 1, column 9 (NumPays).Bulk load data conversion error (truncation) for row 2, column 9 (NumPays).Bulk load data conversion error (truncation) for row 3, column 9 (NumPays).Bulk load data conversion error (truncation) for row 4, column 9 (NumPays).Bulk load data conversion error (truncation) for row 5, column 9 (NumPays).Bulk load: An u

The file format on your account is incorrectly configured. Please contact your provider to request your format be set to ‘CSV Format with Alt Rate’.

A single or couple of truncation errors only

Example:

Bulk load data conversion error (truncation) for row 3, column 3 (Paycode_ID) .Warning: Null value is eliminated by an aggregate or other SET operation.Warning:Null value is eliminated by an aggregate or other SET operation.Create Pay Sheet

One or more fields in your file are longer than is allowed. Code fields are usually limited to 10 characters, date fields are limited to 8 characters.

You will need to correct the file and any system where the file was produced, then upload it again.

Invalid Paycode ID

Example:

The Paycode_ID (1000077222) for employee (37) is not valid.

Either the paycode ID does not exist on your account or it exists but it is not available in the employee’s payment group. If the paycode ID does not exist, you will need to correct the configuration in the third party system where you produced the import file. If the paycode ID does exist on your account, ensure it is available in the affected employee’s payment group.

Date/Time conversion error

Example:

Conversion failed when converting date and/or time from character string.

This error indicates that there are one or more rows in the file which have an incorrectly formatted date. All date fields should be formatted as DDMMYYYY.

This error commonly occurs where a file has been opened/saved in Excel and leading zeros have been removed from a date. For example, 03/09/2020 should be in the file as 03092020 however if the file is opened then saved in Excel, Excel removes the leading zero and the value incorrectly becomes 3092020. In this case, you should either:

  1. Produce a new file to upload
  2. Manually edit the file in Notepad or Notepad++ to add in the missing leading zeros.