If your payroll provider isn't supported by our integrations, you can build your own custom payroll exporter using these built-in tools in Deputy.
What we'll cover
- Getting Started
- Setup your Export
- Select the Deputy Data you want to Export
- Add custom column
- Data Sources
To build your own custom payroll export file, go to the Timesheets tab and select Export Timesheets. Choose the date range and select the timesheets you want to export, then click on the Export Selected Items button.
Here you’ll find a list of options to export timesheets, such as:
- 3rd party integrations; Xero, ADP, Gusto, etc.
- CSV export
- Custom payroll exporter
Search and select Custom payroll exporter (if it’s not selected already).
You will see a preview of the pre-selected data sources. Click Edit to start building out the exporter.
Note: The filename defaults to the selected date range.
Setup your Export
Click on Settings to set up the following:
- File type - choose the file you’ll be exporting as
- Fixed width - do you require your columns to be a fixed length? For each column, you will need to specify the column length, left or right justify and any padding characters. Delimiter selection will be hidden if this is selected. (note: Fixed width is only available for .txt and .dat file formats)
- Encapsulation - text will be enclosed by double quotes when using delimiters to group data
- Remove header columns - select this if your exporter doesn’t require the headers of each column
- Delimiters - if you have selected .txt or .dat file type, you will need to choose the delimiter
Select the Deputy Data you want to Export
The left panel is a catalogue of all the data you can export for your payroll provider. You can use the search field to filter the data sources.
Add custom column
Custom columns allow you to add a blank column to your payroll export for placeholder purposes. This is useful when your payroll system requires a column, but that specific data source doesn’t exist in Deputy.
When adding a custom column, you can also add a column header name, and set up fixed-width (if it’s enabled). We'll review fixed-width again later in this article.
You should now see your data sources on the right panel. Check each data source to make sure they have been set up correctly before exporting. You can also do the following:
- Drag and reorder
- Add column header name
- Choose the format modifier
- Set up fixed width
Drag and reorder
Reorder the column tiles to make sure they’re in the correct order. The tile at the top will be the first column in your export.
Add header name
If Deputy names a specific column something different than your payroll provider, you can match that name here. Otherwise, you can leave it blank and the headers will be the same as Deputy.
3. Choose the format modifier, we’ve provided a list of different formats for date & time. Other data sources will have options like numerical (decimal count) and text (upper case vs lower case).
4. Set up fixed width
With .txt files, you can specify the length of a column.
Choose left or right justification, character limit, and adjust the padding character to reach the required column length.
Can you select the same data source more than once?
Yes, if you need the same data in more than one column you can.
Does this tool support Shift Questions / Custom Timesheet Fields?
Yes, these fields are marked with a "Custom" prefix in the list of data sources.