TODO: To change the footer's content go to Dr.Explain menu Options : Project Settings : HTML (CHM) Export : Setup HTML Template and Layout
Import advances/purchases 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 pay slips. 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 pay slips.
Should the advance item be an hour/unit based pay item?
Choose the correct group/team/company who should be included on the Excel spreadsheet. An empty file is created with the correct column headings and employee information. Save the file in a fitting folder (standard is on the Desktop, but this can be changed). Add the advance totals on the Excel spreadsheet.
The only thing to be added on the spreadsheet is the 'Advance amount'. DO NOT change the employee number, name or surname. It will not be imported correctly. If there is a mistake on one of the employee's information, correct this in Africlock.
This is applicable only during the import of the spreadsheet data. Choose the wording which must be used on the pay slips to describe the reason for the advance (e.g.. 'Wage advance'). This item description must already exist. It will appear on the pay slips of all the employees for whom entries were made in the 'Advance amount' column of the spreadsheet (unless you've used the 'Description' field - then this will be used as the pay item's name on the pay slip.
The date is applicable only during import of the spreadsheet data. It is the date on which the advance must be added. This date must fall within the pay period.
Choose the item description which must appear on the pay slips when they are generated, enter the date on which the advance happened 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 for example: ADV20080605AT1240DONE.XLS.
