Import performance bonuses and penalties from EXCEL

The date indicates when the bonuses/penalties must appear on the payslips and is also used to create a default file name for the spreadsheet .

 

Displays a calendar from which you can select a date.

 

Creates and opens an empty Excel spreadsheet in which the headings for columns A to I have been set up by the system. Enter your data and save the spreadsheet. The system will suggest a file name and folder to use but you can change them to suit yourself. The default folder is REPORTS\EXCEL in your Africlock folder, and the default file name consists of the word BONUS followed by the date you typed into the date field (item 1 above) with an .XLS extension (e.g. BONUS20080602.XLS).

 

???This is applicable only during import of the spreadsheet data. Choose the wording which must be used on the payslips to describe the reason for the payments or deductions e.g. "Production Bonus/Penalty". Obviously, this item description must already exist. It will appear on the payslips of all the employees for whom entries were made in the "Advances: Bonuses and Penalties" column of the spreadsheet.???

 

Press this button when you have chosen the correct pay item description. Select the required file from the window that opens, and the data will be imported into the clocking system. The file name will be changed to indicate that the data is already in the system and must not be imported again. Using the example file name given in item (3) above, the new name will be BONUS20080602DONEAT1511.XLS (where "1511" indicates the time on the computer's clock when the data was imported.

 

Close the window.