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!


Did this answer your question?