Comma-delimited file is a delimited text file that uses a comma to separate values. The file type can be .TXT or .CSV
NOTE: if using a .CSV open with Notepad as the leading zero will disappear if the column format is not Text type
Step 1: Create the import file
Example: (.TXT) file might change. It is depends on software provider
The file has the following format
Column 1 – Employee id
Column 2 – Pay category
Column 3 – Hourly Rate
Column 4 – Amount
If the value is not there leave the blank
Example: line 1 importing units; line 2 importing amounts
First line:
- Employee Code (1003)
- Payroll Category (107) This is hourly Type
- Hours (55) Number of Hours
Second line:
- Employee Code(1003)
- Payroll Category (117) This is Regular Type
- Live blank ,,
- Amount (700)
Step 2: Create a new import interface
Go to Configuration > Interfaces > Paycard import interfaces / Then click on (+) sign to create a new interface
On Detaills tab add Code, Name of the new layout
File Type= Comma delimited file
Additional settings: only check The file provides payroll category numbers
Click on “Filed mapping” tab. Select the Souce field from the drop down list and enter the source column from the file . Click “Add” button to add new line.Save
Step 3: Batch the payroll using new interface : Go to Payroll > Process Paycards > Batch Payroll and make the selection > click Next
Select import interface name and browse for the file to be imported. Click next (at the bottom)
Click Run Payroll
A successful import will produce the following screen
To check the imported data: Go to Payroll > Process Paycards > Edit Paycards and double click on your employee.
If the entry is incorrect review the import file. You can Overwrite on the Batch Paycard wizard as many time as you want.