Importing Employees from a CSV File

To access this utility, go to File > Import/ Export Data > Import Employees from a CSV File.

1) Browse to the location of your Employee CSV File

2) Select the required file and click 'Open'

3) Your employee information will be displayed on screen. For each column, choose the employee data it represents. Ignore any columns and uncheck any rows you do not wish to be imported:

4) Click Import to complete the import of your employee information.

Fields which can be imported into BrightPay using CSV file format are:

Title

Name

Middle Name

Surname

Address Line 1

Address Line 2

Address Line 3

Address Line 4

Postcode

Country

Foreign Country

Gender

Date of Birth

Marital Status

Nationality

Passport Number

Phone Number

Email Address

Works Number

Start Date

Starter Declaration

Seconded to Work in UK

Is EEA Citizen

Is EPM 6 Scheme

Leave Date

Is Deceased

Department

Annual Leave Year Start Date

Number of Days Holiday Carried Over from Previous Year

Number of Days Holiday in Year

Typical Number of Hours in Working Day

Is Monday a Typical Working Day

Is Tuesday a Typical Working Day

Is Wednesday a Typical Working Day

Is Thursday a Typical Working Day

Is Friday a Typical Working Day

Is Saturday a Typical Working Day

Is Sunday a Typical Working Day

Tax Code

Week/Month 1 Basis

National Insurance Number

National Insurance Table

Is a Director

Director Start Date

Director End Date

Is Using Alternate Director NI Calculation

Is Exempt From Employer NICs

Is Student Loan Deductible

Payment Frequency

Payment Calculation Method

Annual Pay Rate

Period Pay Rate

Daily Pay Rate

Hourly Pay Rate

Payment Method

Payment Bank Name

Payment Bank Branch

Payment Bank Sort Code

Payment Bank Account Name

Payment Bank Account Number

Payment Bank Reference

Contracted Hours Worked

Is Irregular Payment Pattern

Job Title

Recruitment Date

Starting Salary

Employment Arrangements

Next Review Date

Document Password

Medical Information

Notes

Mid Year Cumulative SSP

Mid Year Cumulative SMP

Mid Year Cumulative OSPP

Mid Year Cumulative ASPP

Mid Year Cumulative SAP

Mid Year Cumulative Gross Pay

Mid Year Cumulative Free Pay

Mid Year Cumulative Taxable Pay

Mid Year Cumulative Tax

Mid Year Cumulative NIC-able Pay

Mid Year Cumulative Student Loan Deductions

Mid Year Cumulative Pensionable Pay

Mid Year Cumulative Employee Pension

Mid Year Cumulative Employee Additional Voluntary Pension

Mid Year Cumulative Employer Pension

Mid Year Cumulative Net Pay

Mid Year Cumulative Pay

Mid Year Cost to Employer

Taxable Pay in Previous Employment

Tax in Previous Employment