Import advances from EXCEL
Allows you to create an Excel spreadsheet in which you can show the total to be deducted from each employee who received an advance on his/her wages or who owes money for goods purchased from you. The data can then be imported from the spreadsheet for inclusion in the payslips. Only items which will be DEDUCTED from employees' wages can be entered in this way. These items should all be of the same kind (e.g. "Wage advance") because you will have to select a description from the "Pay item description" list when importing the data and this description will appear on all the relevant payslips. If you need more than one description for the various entries, rather use the "Advances/sales/payments" button on the "Advances" menu.
 Create empty EXCEL spreadsheet
Creates and opens an Excel spreadsheet containing all the employees' numbers, names and employee groups. You can then enter the amounts which must be deducted from the employees' wages in the "Advance amount" column 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 letters ADV followed by the current system date and time and the extension .XLS (e.g. ADV20080605AT1240.XLS).
|
|
 Pay item description
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 deductions (e.g.. "Wage advance"). This item description must already exist. It will appear on the payslips of all the employees for whom entries were made in the "Advance amount" column of the spreadsheet.
|
|
 Date
The date is applicable only during import of the spreadsheet data. It is the date on which the deductions must be made from the employees' wages.
|
|
 Calendar
Displays a calendar from which you can select a date.
|
|
 Import advances from EXCEL spreadsheet
Choose the item description which must appear on the payslips when they are generated, enter the date on which the deductions must be made and press this button. Select the required file from the window that opens, and the data will be imported into the clocking system. The letters "DONE" will then be added to the file name to indicate that the data is already in the system and must not be imported again. Using the example file name in item (3) above, the new name will be ADV20080605AT1240DONE.XLS.
|
|
 Close
Close the window.
|
|
