You can import clocking information from various providers into SimplePay as follows:
- Go to Employees > Bulk Actions > Clocking System Import
- The clocking imports page will default to imports for regular payslips. If you wish to import a clocking file for once-off payslips, click on Switch to once-off payslips. Please note that not all item types are applicable to once-off payslips. Currently, only Basic Salary and Custom Items with payslip inputs are supported.
- Select the pay frequency for which you want to import the data – if you have more than one, a separate import will need to be performed for each of them
- Select the correct pay period
- Select the format you would like to use
- Generic CSV* – for uploading your own custom spreadsheet based on this specification
- Deputy CSV – for importing CSV files originally exported from the Deputy time and attendance software.
- Click Choose File and select your clocking file
- Click Upload
*You can also use a StaffAny CSV export file if you make use of this clocking system, but you will need to manipulate the file first. Delete the first column and first two rows in the file and then save the file as a CSV again. Select the Generic CSV file format when you upload it.
When you upload your clocking file for the first time, you will need to map the information in the file to the relevant items in SimplePay. When using a clocking file format that requires you to set up mappings, please take note of the following:
- Columns in the CSV file can only be mapped to regular items with payslip inputs, e.g. Basic Salary which has inputs for hours worked.
- The regular item will need to be added to the payslip before the mapping is done
Once your file has uploaded successfully, follow the steps below:
- Click on Mapping Settings
- Allocate each column to its respective payslip item
- Upload the file again as above – this second upload is only necessary when setting up mappings
Once the file has been uploaded, the data will be displayed for you to verify. If you are happy that it is all correct, click Save. The system will then calculate the employees’ pay amounts accordingly – please consult the following section for further information: