|
In the Report journal, you have the possibility to import transaction data (e.g., current expenses, etc.) directly via Excel Import into Report journal.
It can now be done in Allocated salary as well.
How do you go about this?
❑ To process the transaction data, you will receive an Excel file from your employees, department managers or foreign employees
❑ Save the Excel file to your drive.
❑ Click Journal rows from Excel or Allocated salary from Excel in the Report journal or Allocated Salary.
❑ Select the saved Excel file in the ‘Excel import file’ field and click the adjacent button ‘Determine the rows used in the Excel import file’. The system checks the Excel file and automatically writes the number of rows it was able to read from it into the From row/To row field.
❑ Under column setup, the fields are linked to the corresponding Excel.
❑ Click OK and the data will be imported into the Report journal or into Allocated salary.
Explanation of fields in Excel import:
Excel import file
|
Select the desired Excel file
|
Determine the rows used in the Excel import file
|
This function checks and activates the desired Excel file
|
Line of/to
|
The system shows the row from/to which the Excel gets data
|
Rolling distance
|
An example for understanding:
Let’s assume that the employee ID is in column A in Excel. Salary type number is in column B, etc. The salary type number appears in column 7 again. This means that the salary type number should be imported again on a rolling basis every 7 columns. This cycle is repeated 4 times.
Enter the number of columns and the frequency at which the data is repeated (e.g., every 7 columns)
|
Rolling quantity
|
The number of times this process repeats itself (according to our example for understanding, 4 times)
|
Rolling
|
(According to our example for understanding) Not all columns necessarily repeat themselves. E.g., employee ID and the document date may only be recorded once per line. The remaining data is repeated on a rolling basis every 7 columns and for a total of 4 times. So, uncheck the ‘Rolling’ box next to the employee ID and document date.
|
Follow-up Salary Type
|
❑calculate: Resulting salary types are moved automatically (by default)
❑do not calculate: Resulting salary types are archived, so that only the main salary type is imported. |
Journal line for resignated employees
|
You have the opportunity to determine what should happen to records of employees who have resigned.
•Show messages
If you import a data record of an employee who has resigned, the corresponding message ‘Employee has resigned. Make an entry anyway’ is displayed and the data record is imported.
•Ignore messages
If you import a data record of an employee who has resigned, the message ‘Employee has resigned. Make an entry anyway’ is not displayed and the data record is imported.
•Do not import
Data record of the employee who has resigned is not imported.
|
|