IMPORT HOURS FROM TEXT FILE
To access this utility go to Utilities > Import Hours> from text file
The import file name must be wimport.txt
Within the payroll under the utility menu there is a browse type screen where the user selects the drive, folder, to find where the file is.
There is a grid which will show the employees name and number and if P45 issued. This can be copied to Excel or similar via the clipboard and sorted as desired
The import file detail is shown to the user on a similar grid.
There is no checking that the names/numbers are correct. It is up to the user to determine that the numbers on the import data file match the numbers of the corresponding employees in the payroll. The employee works numbers are shown on the grid.
The file spec
ascii text file - zero filled
bytes name
02 period - week or month number
04 employee number
06 Standard hours (123.56)
06 hours x 1.5 (123.56)
06 double time (123.56)
02 weekly or monthly marker (1 is weekly, 2 is monthly)
06 hours x 1.3333
30 filler
02 carriage return/line feed
total record size is 64 bytes
IMPORT HOURS FROM CSV FILE
To access this utility go to Utilities > Import Hours > from CSV file
The file spec ;
Works No, Hours at standard rate, at time & half, at double time, at time & third
e.g.
0001,40,,,
0002,40,4,2,
0003,40,,,3
or
0001,40
0002,35
To record fractional hours then these should be shown in decimal format
e.g.
0001,40.50,,,
The above would record 40 1/2 standard hours for employee with the works number 1
Click 'Locate File' and the grid will populate with the contents of the chosen CSV file
Click 'Validate' and the program will see if it can match works numbers with employees
Click 'Import' when you are happy that it is OK to import
The hours imported will be used when you next update the payroll.
Need help? Support is available at 01 8352074 or thesauruspayrollsupport@brightsg.com.
