Workforce.com supports custom timesheet export formats, allowing you to integrate with any payroll system that accepts some form of flat-file timesheet import. The majority of payroll systems will accept a file with a .csv or .txt file extension.
Before building your own, review our out-of-the-box payroll integrations.
Building a new custom export integration
To create a custom timesheet export format, navigate to Settings > Integrations > + New Payroll Integration. Select 'Build Your Own' from the list.
Configuring your export file
Tip: You can rearrange columns by dragging and dropping the boxes.
1 - The default columns that will be exported. These can be excluded by clicking 'Don't include.'
2 - Additional columns that are available to be included in the timesheet export. Click 'Include' to have them appear in the columns to be exported.
3 - Add a custom text field. This is useful if your payroll system requires a fixed value or spacing on each row. i.e exporting the value 'Weekly' on each row to signal the pay cycle the employee is to be paid on.
4 - This allows you to add a column to your export with the name of an earnings rule or allowance. This can be filtered to only export the name of specific earnings rules. Commonly used to export the name of leave types.
5 - Manage integration global settings. This allows you to name the export file, choose the file format and how the file is sorted.
The file extension in the file name will dictate the format of your file. (i.e export.csv, export.txt, export.mif) All comma-separated exports (csv, xls, xslx) should have the file type of CSV. All document type exports (txt, mif) should have the file type of Document.
Some payroll systems require a header row for an import file. This is commonly used to store company information and details relevant to the pay cycle. The 'Custom Header Rows' can be used to store multiple headers in order of when they are added.
In order to separate your Custom Headers into separate columns, add a , in between the text content as seen in the provided image.