If you need to change employee information in bulk, you can easily do so through Excel.
Try changing basic information, work information, contract information, special notes, family information, and career • education.
When employee information is changed, a notification is sent to the employee, so please keep this in mind before making changes!
Basic Description
Click [Members] → [HR Information Management] → [Bulk Information Change] tab, then click [Change Information] in the upper right,
and click [Change via Excel] at the bottom.Download the Excel file, enter the information that needs to be changed, and upload the file to apply the changes.
When bulk changing information through the Excel template, employees are identified by their 'employee number'. Since employee numbers are difficult to bulk change via Excel, please first bulk change and update the employee number information through the Web, then bulk change other information via Excel!
There is a red indicator to the right of the employee number column, and you can view writing tips by hovering your mouse over it.
Please fill in values for the items you want to change. Items left blank will retain the existing information registered in flex.
Changing Basic Information
Click [Basic Information] and download the Excel file.
While filling in the Excel template, you can find the [Select from List] column. Click the dropdown button on the right to view multiple options.
Changing Work Information
Click [Work Information] and download the Excel file.
Choose one of the 'day off' types registered in flex and enter it. It must match exactly, including spaces.
Choose one of the 'work type' options registered in flex and enter it. It must match exactly, including spaces.
Enter the start date of the work type to be changed. (Please set the work type start date to the day the cycle begins!)
Changing Annual Leave Information
Click [Annual Leave Information] and download the Excel file.
Enter the employee number of the member whose annual leave policy you want to change, and the name of the newly added annual leave policy.
Enter the name of the annual leave policy added in flex exactly, including spaces.
Do not delete the example row; start entering from row 6.
When an annual leave policy is changed, annual leave is automatically recalculated as if the new policy had been applied from the beginning, so please change it carefully.
Changing Contract Information
Click [Contract Information] and download the Excel file.
When bulk changing information through the Excel template, employees are identified by their 'employee number'. If there is no employee number, information changes will be difficult, so please check that employee numbers have been assigned in advance.
Only enter values for the items you want to change; items left blank will retain the existing information registered in flex.
While filling in the Excel template, you can find the [Select from List] column. Click the dropdown button on the right to view multiple options.
For a comprehensive wage contract, set the contract status selection to Y.
For other items such as night, overtime, holiday, etc., enter the comprehensive wage contract hours. These hours are the values entered in the comprehensive wage contract section within the employee profile contract information.
For comprehensive wage contract items not contracted with the employee, enter 0 hours and upload.
Changing Salary Payment Information
Contract information and salary payment information are [separate]. Contract information is for entering the annual salary (monthly salary) and whether it is a standard or comprehensive wage contract, while salary payment information is for entering each employee's ordinary hourly wage, base salary, and if a comprehensive wage contract has been signed, the fixed overtime pay amount and individual payment items for each employee!
Click [Salary Payment Information] and download the Excel file.
When bulk changing information through the Excel template, employees are identified by their 'employee number'. If there is no employee number, information changes will be difficult, so please check that employee numbers have been assigned in advance.
Only enter values for the items you want to change; items left blank will retain the existing information registered in flex.
Changing Special Notes
Click [Special Notes] and download the Excel file.
In special notes changes, you can bulk change the following items:
Parental leave reduced working hours start date / end date
Foreigner flat tax rate start date / end date
Student loan repayment start date / end date
Annual mandatory student loan repayment amount
Monthly student loan withholding deduction amount
Income tax reduction type / income tax reduction start date / end date
Changing Family Information
Click [Family Information] and download the Excel file.
In family information changes, you can bulk change the following items:
Relationship
Resident registration number
Basic deduction target
Income deduction relationship code
Child tax credit
Health insurance dependent
Person with disability / national merit
Degree of disability
However, when uploading family information via Excel, you must fill in all fields in the Excel file. The information in flex will be overwritten exactly as you entered it. Items left blank after entering the employee number will have the information registered in flex deleted, so please be careful.
Changing Career · Education Information
Click [Career · Education] and download the Excel file.
In career · education changes, you can bulk change career and educational history prior to joining the company.
However, when uploading career · education information via Excel, you must fill in all fields in the Excel file. The information in flex will be overwritten exactly as you entered it. Items left blank after entering the employee number will have the information registered in flex deleted, so please be careful.
FAQ
I filled in all required information, but an error occurs when uploading the file.
I filled in all required information, but an error occurs when uploading the file.
Please check if any cells in the uploaded file have formatting or formulas applied.