...
NOTE: if using a .CSV open with Notepad as the leading zero will disappear if the column format is not Text type type Step 1:
Create the
...
Import File:
On the desktop of your computer, right click the screen > new > Text document. it should make a new .TXT 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 |
...
Numbers of Hours | |
Column 4 |
...
Amount |
If the value is not there leave
...
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)
...
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.