In this article, you will learn:
What is the Reports SFTP app
Which Reports can be sent to SFTP Servers
How to set up the Reports SFTP Integration
How to set up Reports to be sent via SFTP
Please note: The 'Reports SFTP' app is an integration available within the Integration Management section on Bizimply. Please contact your Bizimply Customer Success manager if you are interested in adding this feature to your package.
What is the Reports SFTP app
The Reports SFTP app is an integration that enables reports from Bizimply to be sent daily, weekly or monthly to any BI tool, external system or payroll provider that supports SFTP. This means that Account Admins can schedule standard reports to be uploaded from Bizimply to SFTP servers. The reports are sent between 3am and 5am.
Which Reports can be sent to SFTP Servers
The reports which can be sent are:
Employee Timecards
Timecard Analysis
Cost Analysis
Employee Export
Starter Report
Leaver Report
How to set up the Reports SFTP Integration
Please note: Only account administrators can set up this integration.
Sign into bizimply.com as an account administrator
Click your name at the top right of the screen
Select 'App Centre' from the drop down menu
Select the 'Integration Management' from the categories on the left hand side
Click the green 'Install' button on the 'Reports SFTP' app. (If you do not have the green Install button, please contact your Bizimply Account Manager who will assist you further)
6. Once installed, click on the 'Settings' gear icon as highlighted in red above
7. This will bring you to the SFTP Destinations page where you click the blue 'New SFTP Destination' button
8. Fill in a name for the configuration in the first text box
9. Enter the details for the server (host name and username)
10. Enter in name of folder into 'Upload Path' field if relevant. (This is an optional field which allows you to enter in the folder name if you have one SFTP destination with several folders)
11. Select the authentication type: 1. Password (enter in password) or 2. Key Pair (upload the key file)
12. Add an email address for any error messages to be sent to. Separate multiple email addresses by using commas.
How to set up Reports to be sent via SFTP
Sign into bizimply.com
Go to 'Reports' tab in navigation bar
Click into the relevant report e.g. Employee Timecards
Select export type as 'Recurring'
Enter in a descriptive name for your scheduled report. This will be identifiable in the 'Scheduled Reports' section.
Select Destination as SFTP and select the relevant host from the 'Select SFTP Destination' drop down menu.
Select the export period: 1 Week, 2 Weeks or Full Month
Select the export frequency: Daily, Weekly or Monthly. If you select 'Weekly', select which day of the week the report is sent. If you select 'Monthly', select which date you would like the report sent each month.
Select the relevant locations
Select the relevant payroll department(s) (only needed for the Employee Timecards Report)
Select the relevant employees. For the Employee Export Report, select whether you would like Active Employees, Inactive Employees or All Employees
Mark if you would like to Remove Meta Data. By checking this box, the column names will become the first row within the report and any meta data such as report title, export duration and other data shown by default will be removed from the top 5 rows. (This is needed for auto parsed reports used in some payroll and BI systems).
If exporting the Employee Timecards Report, select the relevant format for the reportClick the blue 'Schedule' button
Once scheduled, a green banner will appear to show that the report was scheduled successfully. The report will then be added to the 'Scheduled Reports' section.
Related Articles: