All Collections
Payroll & Accounting Integrations
Other Payroll & Accounting (in alphabetical order)
SFTP for Payroll
SFTP for Payroll

How to set up SFTP payroll integration for exporting timesheets and importing leave balances and staff

Maclin Irvine avatar
Written by Maclin Irvine
Updated over a week ago

Overview

  • Tanda’s SFTP services allow you to automatically send and receive files from a server.

  • Tanda does not host its own server so you will either need to create your own or utilise your payroll system’s server if it provides this as a service.

  • SFTP is available to use with any payroll integration in Tanda that has a flat-file export (e.g. a file downloads to your computer) or that would normally let you import staff or leave balances for.

  • This guide explains how integration via SFTP for exporting works and steps you through the setup process.

Step by step setup

  1. SFTP can apply to any existing flat file export. Start by setting up your normal flat-file integration in Tanda. This can be done via Settings > Integrations > Payroll Integrations > + New payroll integration

  2. Once you have chosen the file type, select advanced options at the bottom of the page:
    ​

  3. Fill your server details into the below fields:
    ​

  4. If you would prefer to use a public key instead of entering a password, you can enter Tanda’s public key against your own server to retrieve the file. This can be obtained by contacting support@tanda.co

  5. Next, ensure the directories follow the format of the greyed-out text e.g:

  6. Note that if the export accepts a staff import or leave balance import, you will be able to see the file import pathway fields for each option respectively.

  7. Tick auto-import staff and/or automatically export onboarded employees if you want staff to auto-import/export hourly (if a file is there), e.g:

  8. Leave balances will import 5 am and 5 pm daily if the file is there.

  9. When you try to save the integration with these details, Tanda will automatically test to see if it can connect using those details. If the details are incorrect or the server does not respond to Tanda then the details will not save.

  10. Export to payroll like you normally would and it will send the file to the SFTP server you entered.

Troubleshooting Issues

If you are having issues connecting your SFTP integration, here are some steps for resolving common errors:

  1. Double-check your server details to confirm that these are identical to those entered in Tanda (this includes the port number)

  2. Ensure that your server has not black listed Tanda. To prevent this you will need to whitelist the my.tanda.co domain or get in contact with our team at support@tanda.co for a list of the IP addresses we use.

  3. Check that you have specifically enabled SFTP services on the server you are using.

If you have successfully connected your integration by saving the details in Tanda but you are still issues with the file transfer, confirm the following details:

  1. The file you are trying to import matches the required formatting and does not have any additional characters or spacing.

  2. Your server is not using a form of at rest encryption like GPG or PGP.

  3. Your server is not using an encryption algorithm deemed unsecure. You can find the list of encryption algorithms supported by Tanda here

Did this answer your question?