Having trouble with your employee data importing?

This guide will bring you through all of the different fields in the employee data importing sheets - which fields need to follow our fixed formatting templates and which do not. 😃

Using Importing Sheets in Talenox to Create Employee Profiles in Bulk

To learn how to add employees and open up our employee data importing sheets for mass importing of employee profiles into Talenox, you can refer to our guide on How to Add Employees?

Simply head to Profiles > Manage my database > Employee Listing > Import > Import Employees and select the type of importing sheet you'd like to use (e.g. Excel/Google Sheet):

Employee Importing Sheet Formats

Talenox currently has 2 types of importing sheet formats that you can utilise to mass create employee profiles:

Excel - most frequently used due to ease of transfer of data; most users have their employee data keyed into existing excel sheets
Google Sheets - most accurate for importing

You can select the format that you are most comfortable with using for the importing process. The fields in each type of importing sheet are exactly the same.

Employee Importing Fields

In the importing sheet, there are some fields which have a dropdown list of options to select from:

These fields have a specific template of formatting that it follows. Please always utilise our dropdown list options to fill in each field for employees.

Each column is sensitive to the following inputs (when done manually):

Capitalisation (Capital letter placements)
Spacings between and after letters
Date formatting (Must be in the format of DD/MM/YYYY)

Importing Fields Criteria

You can find the list important of importing sheet fields and the needed criteria to take note of for successful import:

Importing Fields	Criteria for Import	Column in Sheet
First Name	No template; compulsory for import	B
Last Name	No template; compulsory for import	C
Email	No template; needed for user invites to be sent (in Column G)	F
Invite User	Fixed template; Compulsory for import	G
Birth Date	Fixed format (DD/MM/YYYY); Compulsory for import	P
Identification Number	No template; compulsory for import	R
Immigration Status	Fixed template; Compulsory for import	S
Disabled Individual	Fixed template; Compulsory for import	T
Disabled Spouse	Fixed template; Compulsory for import	U
Contributing EPF	Fixed template; Compulsory for import	V
EPF Number	No template; compulsory for import	W
Employee EPF Setting	Fixed template; Compulsory for import	X
Employer EPF Setting	Fixed template; Compulsory for import	Y
PCB No. (Income tax no.)	No template; compulsory for import	Z
PCB Borne by Employer	Fixed template; Compulsory for import	AA
Socso Category	Fixed template; Compulsory for import	AB
Employment Insurance System (EIS)	Fixed template; Compulsory for import	AC
Job Title	No template; compulsory for import	AM
Hired Date	Fixed format (DD/MM/YYYY); Compulsory for import	AN
Rate of Pay	Fixed template; Compulsory for import	AU
Currency of Salary	Fixed template; Compulsory for import	AV
Basic Salary	Fixed template; Compulsory for import	AW
Payment Method	Fixed template; Compulsory for import	BA
Bank Type	Fixed template; Compulsory for import	BB
Bank Account Holder’s Name	No template; compulsory for import	BC
Bank Account No.	No template; compulsory for import	BD
Accumulated remuneration/Benefit-In-Kind (BIK)/Value Of Living Accommodation (VOLA)	No template; compulsory for import	BQ
Accumulated MTD paid (including MTD on additional remuneration)	No template; compulsory for import	BS
Accumulated SOCSO Contribution	No template; compulsory for import	BT
Accumulated Zakat paid	No template; compulsory for import	BU

Hope this helps to ease the process of importing your employees into Talenox!