Skip to main content
All CollectionsPayroll Integrations
Export employee timesheets to payroll using a custom format
Export employee timesheets to payroll using a custom format

Customise a flat-file timesheet export format using the Build Your Own Exporter.

Updated over a year ago

Tanda 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.

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 award rule or allowance. This can be filtered to only export the name of specific award 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 seperate your Custom Headers into seperate columns, add a , in between the text content as seen in the provided image.

Did this answer your question?