Bulk Salary Entry
The Bulk Salary Entry screen is a convenient tool that allows you to record Salary for multiple employees simultaneously using Excel. This saves time and speeds up the data entry process.
Steps for Bulk Salary Entry
Follow the steps below to perform Bulk Salary Entry.
- Download Blank Salary Template:
- Go to the Data Transfers > Salary Entries page.
- Click the Download Blank Salary Template File button.
- The Excel file will be downloaded to your computer.
- Fill in Salary Information:
- Open the downloaded Excel file.
- Starting from the first empty row, enter the data for each employee to be recorded for Salary, considering the following warnings.
- Salary Information must be filled according to the column headers in the template.
- Employee Code must match the system records.
- Employee Codes and information will be found on the "Employee List" sheet in the template Excel file. You can copy the Employee Codes from here.
- For Currency No, enter the relevant numbers indicated on the "Currency No" sheet in Excel.
- Start Date should be in the format "Day.Month.Year". Example: 01.04.2024
- End Date should be in the format "Day.Month.Year". Example: 01.04.2025
- Leave the End Date blank for indefinite salary entries.
- For Salary Type No, enter the relevant numbers indicated on the "Salary Type" sheet in Excel.
- Fill in the Description field.
- Save the Excel file after filling in the salary data.
💡
For smooth operation of Salary Calculation, the employee's last salary entry should be indefinite, meaning it should not have an end date.
- Start Bulk Registration Process:
- Return to the Bulk Salary Entry page.
- Click the Select File field.
- Select the filled Excel file and click the Open button.
- Click the Upload Filled Salary Template File button.
- Click the Start Bulk Salary Transfer button.
- Check Process Result:
- When the process is complete, an information window containing the process result and summary will open.
- Process Result:
- If all rows are recorded, it will say "Successful".
- If there are erroneous rows, it will give a "Error!" warning.
- Error-free records will be saved. No further action is required.
- Bulk Process Summary:
- Total Rows: Total number of rows uploaded in the template.
- Successful Transactions: Number of rows successfully recorded.
- Erroneous Transactions: Number of erroneous rows not recorded.
- Process Result:
- Rows with incorrect formatting or missing mandatory information will not be processed.
- When the process is complete, an information window containing the process result and summary will open.
- Correct Erroneous Rows:
- If there are erroneous rows, they will be returned as an Excel file.
- Click the Download Excel File button to download and open the file containing only the erroneous rows.
- The reason for the error will be written at the end of each row.
- Correct the errors and save the Excel file.
- Start the Bulk Registration Process for the saved file.
💡
You can check the successfully recorded Salary entries on the Reports > Personnel Salary List screen.