Acclaim - Import timesheet (Hours) from a file
Note: The file to be imported can ONLY be a .csv or a .txt file extension.
Steps:
Start Acclaim and login into your company.
Select the pay period : Payroll > select pay period > Save
Start payroll process: Payroll > Process payroll
From top menu click Batch > Batch Create Timesheet
Make your selection > click Batch
Confirm the overwriting to begin the process
Select the interface > select the File. Based on the interface select the entries will be different.
Note: The structure of the file is:If successful imported user will receive the following:
The paycard of employee will show the hours imported
NOTE:
Below is the description of the fields:
// Field "EMPLOYEE"
// ignore field "PEREND"
// ignore field "TIMECARD"
// ignore field "CATEGORY"
// ignore field "EARNED"
// ignore field "UNIQUE"
// Field Hours
// ignore the rest
The yellow fields are considered.
Example file:
H
H
"2","003", , , , , ,22.50,
"2","005", , , , , ,22.50,
"2","006", , , , , ,22.50,
NOTE:
1 - File should not have any empty lines at the end of the file
2 - " are required
3 - is one space in front of "," where fields are ignored