File

We select the file, which we will import, which can only be in XLS format.

Employee

Column

It represents the format of the data in which we have written employee.

In XLS file where we can choose between:

• Reg. No: data that is identical to the data from Employee files from the field Reg. No./ID
• Number: data that is identical to the data from Employee files from the field Number
• ID Card: data that is identical to the data from Employee files from the field Card No.

If we have in XLS file of an employee written in a form of a number from the personal folder form the Number field, then we select the Number.

We select which column we have in XLS file of written employee. In our example, for a vertical layout, this is column A.

Position

Column

It represents the format of the data in which we have written Position.

In XLS file where we can choose between:

• Automatic: data that is identical to the data from Employee files from the field Position in Salary Parameters.
• ID: data that is identical to the data from Employee files from Position from the register Positions of Employment
• Name: data that is identical to the data from Employee files from Position from the register Positions of Employment.

We select which column we have in XLS file of written Position. In our example, for a vertical layout, this is column B.

Department

Column

In XLS file where we can choose between:

• None: data will not be transferred from the file. We can leave the field empty.
• Name: data that is identical to the data from Employee files from the field Dept. in Salary Parameters.

We select which column we have in XLS file of written Department. In our example, for a vertical layout, this is column C.

Cost Center

Column

In XLS file where we can choose between:

• None: data will not be transferred from the file. We can leave the field empty.
• Name: data that is identical to the data from Employee files from the field Cost Center.in Salary Parameters.

We select which column we have in XLS file of written Department. In our example, for a vertical layout, this is column D.

Report

We select the Report where we want to transfer the imported data. Here we can see only those Pay slips that are not finished yet (in Payroll preparation we do not have checked box “Finished”).

Group ET

The checker is active only in case there is already some kind of ET in the selected pay slip for data transfer at the time of preparing the pay slip for a particular employee, or that data has already been transferred.

In case the checker is confirmed, all ET’s will be transcribed for each worker by the new values in the pay slip preparation.  

If there is some ET in the transfer data of the preparation, which is no longer in XLS file, it will be deleted from the preparation next to the confirmed checker when resuming the transfer.

Group workspace, dept., cost ctr.

When the checkbox is confirmed than the program will group ET’s by workplace, department and/or cost center.

Eg.: when we have an employee with the same position but different department or cost center and we would like that every ET is calculated for the correct position, than we confirm this checkbox

Fix the ET values

Checkbox is active only in a case that in the selected calculation for the transfer of data the already exist an earning type in the payroll calculation for a specific employee or that the data have already been transferred.

In case the checkbox is confirmed all ET for individual employee will be transferred to the payroll preparation with the new ET values. With the transfer to the payroll preparation it will not overwrite existing ET in the fields Days, Hour, Amount and Index but it only correct the values.

Eg.: for ETs that are set in AP/Settings/Personnel/Payroll/Commute from Work, it does not overwrite Amount which is transferred form EF/Salary Parameters/ Commute to Work, but for eg. it enters only hours.

Overwrite Existing ET

Checkbox is active only in a case where in the selected calculation for transfer of data already exist a sort of earning type in the payroll preparation for a specific employee or that the data have already been transferred.

In case the checkbox is confirmed all ET for individual employee will be transferred with the new values.

Eg.: with repeated transfer of data to payroll preparation already exist an ET which is no longer in XLS that with the confirmed checkbox with repeated transfer this ET will be deleted from the payroll preparation.

Run

By pressing on the button, we import data from XLS file selected in a field File. Data are written on the second half of the forma.

Line

We enter the name of the item, which represents the earning type for example Vacation. We can enter up to 3 characters.

ET

In a drop down menu we select the Earning Type (eg. DOP) from the Earning Types register. 

Data Type1

We select the type of data, which we import. We can select from Hours, Days, Amount and Index. Based on selected type the information will be imported to the corresponding column.

Data Type2

We select the type of data, which we import. We can select from Hours, Days, Amount and Index. Based on selected type the information will be imported to the corresponding column. We use this Data Type if we already entered information in Data Type1.

Data Type3

We select the type of data, which we import. We can select from Hours, Days, Amount and Index. Based on selected type the information will be imported to the corresponding column.

Data Type4

We select the type of data, which we import. We can select from Hours, Days, Amount and Index. Based on selected type the information will be imported to the corresponding column.

Lines

Column

We enter the number of the column in which in XLS file the ET is located.

Values

1. Column
2. Column
3. Column
4. Column

We enter the number of the column in which in XLS file the Data Type is located.

Employee

From XLS file we import the employee. With double-clicking in this field, we open employee’s personal file. We cannot change the data here, it is meant only for reading.

Pos.

Employee’s last active position from the panel Position in Salary Parameter is shown. We can change it or leave it the same.

Position Name

The last employee's active position name from the panel Position in Salary Parameter. With double-clicking to this field, we open employee’s file for this employee. We cannot change the data here, it is meant only for reading.

ET

The earning type, which we set in the first half of the form in the entry from the column ET. With double-clicking we access the code table of earning types. We cannot change the data here, it is meant only for reading.

Days

From XLS file we import the days for an individual earning in case we have in the first half of the form in Data Type if we selected Days. We can change here the data.

Hours

From XLS file we import hours for an individual earning in case we have in the first half of the form in Data Type if we selected Hours. We can change here the data.

Amount

From XLS file we import the amount for an individual earning in case we have in the first half of the form in Data Type if we selected Amount. We can change here the data.

Index

From XLS file we import the index for an individual earning in case we have in the first half of the form in Data Type if we selected Index. We can change here the data.

Status

When importing data, various warnings and errors are written in the Status. Errors are separated by two degrees, which lines are also colored accordingly. The color can be randomly determined in Administration Panel | …| Payroll | Message Statuses – Payroll in the Critical Error, Error and Warning fields. In this way two kinds of messages appears Error and Warnings, which are briefly described. Errors cannot be corrected and cannot be transferred to payroll preparation, while warnings can be corrected and are subsequently marked for transfer to pay slip.

Critical errors are:

• Employee is not active (employee is not active or has no parameters for this calculation).
• Pos. is not in the period (the position is not in the period of a case, so at this moment of the entry changes Pos.)

Warnings are: 

• ET is already in the preparation (this earning type employee already has in a preparation, the data in the column ET is colored)
• Difference in Days (this employee already has for this ET, but the difference is in the days, the data is colored in Days column).
• Difference in Hours (this employee already has for this ET, but the difference is in the hours, the data is colored in Hours column).
• Already transferred (this employee has already the data transferred to the preparation, trough importing XLS  file)
• More active Pos. (this employee has more active positions, which are possible in this pay slip for this period; the data in the column Pos. is colored).

All other records are marked for transcription and are not colored. Coloring can also be changed as far as the box in column Sel. is checked and the warning color changes so only the remainder of the data where the Warning occurred. Always remains colored field Employee with the color for warnings.

Sel.

We check the box in case we want the selected positons to be transferred in the payroll preparation.

By pressing the button, the data will be transferred in the pay slip preparation and the program will display the information, which we confirm.