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
Create the Import File:
On the desktop of your computer, right click the screen > new > Text document. it should make a new .TXT file.
The file has the following format:
Column 1 | Employee id |
Column 2 | Pay category |
Column 3 | Numbers of Hours |
Column 4 | Amount |
If the value is not there leave them blank.
Create a new import interface:
Steps:
- Go to Configuration > Interfaces > Paycard import interfaces.
- Click on (+) sign to create a new interface.
- On Details tab add Code and 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 Source field from the drop down list and enter the source column from the file.
- Click “Add” button to add new line.
- Click on the Save button.
Batch the payroll using new interface:
Steps:
- Go to Payroll > Process Paycards > Batch Payroll.
- 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
- 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.