Employee Data that can be Imported into BrightPay

If you are migrating to BrightPay from another payroll package, employee data can be imported into BrightPay via CSV file format. 

  • Once you have your employer file set up and opened, simply click File > Import/Export Data > Import employees from a CSV file’. 
  • Browse to the location of your Employee CSV file, select this and press Open.
  • For each column, choose the employee data it represents. Ignore any columns and uncheck any rows you do not wish to be imported.
  • When ready, click ‘Import’. Your employee data will now be imported and can now be accessed through the Employees tab.


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

Gender

Date of Birth

Nationality

Phone Number

Email Address

PPS Number

Works Number

Start Date

Leave Date

Department

Is a Director

Is Valid Certificate Held

Is Temporary

Calculation Basis

Is Exempt from PAYE

Is Exempt from USC

Has PAYE Exclusion Order

Has E101 Certificate

PRSI Class

Annual PAYE Credit

Annual PAYE Cut-Off Point

Annual PAYE Cut-Off Point 1

Annual PAYE Cut-Off Point 2

Annual PAYE Cut-Off Point 3

Total LPT to be Deducted

PRD Calculation Method

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

Annual Leave Entitlement Calculation Method

Leave Year Start Date

Is Annual Leave Carried Over From Previous Year

Number of Annual Leave Days Carried Over From Previous Year

Number of Annual Leave Days in Year

Number of Annual Leave Days in Month

Number of Hours in Working Day

Payment Frequency

Payment Calculation Method

Annual Pay Rate

Period Pay Rate

Standard Daily Rate of Pay

Standard Hourly Rate of Pay

Payment Method

Payment Bank Name

Payment Bank Branch

Payment Bank Sort Code

Payment Bank Account Name

Payment Bank Account Number

Payment Bank Reference

Payment BIC

Payment IBAN

Job Title

Starting Salary

Employment Arrangements

Next Review Date

Document Password

Medical Information

Notes

Previous Employment Employer Registration Number

Previous Employment Leave Date

Previous Employment PAYE-able Pay

Previous Employment PAYE

Previous Employment USC-able Pay

Previous Employment USC

Previous Employment PRD-able Pay

Previous Employment PRD

Previous Employment LPT

Mid Year Cumulative Notional Pay

Mid Year Cumulative Medical Insurance

Mid Year Cumulative Illness Benefit

Mid Year Cumulative Maternity Benefit

Mid Year Cumulative Adoption Benefit

Mid Year Cumulative PAYE-able Pay

Mid Year Cumulative PAYE

Mid Year Cumulative USC-able Pay

Mid Year Cumulative USC

Mid Year Cumulative PRD-able Pay

Mid Year Cumulative PRD

Mid Year Cumulative LPT

Mid Year Cumulative Employee PRSI-able Pay

Mid Year Cumulative Employee PRSI

Mid Year Cumulative Employer PRSI-able Pay

Mid Year Cumulative Employer PRSI

Mid Year PRSI Class 1

Mid Year Cumulative Insurable Weeks at PRSI Class 1

Mid Year PRSI Class 2

Mid Year Cumulative Insurable Weeks at PRSI Class 2

Mid Year PRSI Class 3

Mid Year Cumulative Insurable Weeks at PRSI Class 3

Mid Year PRSI Class 4

Mid Year Cumulative Insurable Weeks at PRSI Class 4

Mid Year Pension Scheme Type

Mid Year Cumulative Employee Pension

Mid Year Cumulative Employer Pension

 

 

 

 

Need help? Support is available at 01 8352074 or [email protected].

Installing BrightPayGeneralGetting StartedImporting from Previous YearSwitching from Thesaurus Payroll Manager to BrightPay mid yearImporting employee data from another payroll packageEmployerEmployeePayroll DeductionsPayrollMid-year StartersLeaversPensionsIllness BenefitBenefit in KindParenting LeaveHolidaysEmployee CalendarMaking Corrections to PayrollP30 ReturnsAnalysisBacking Up & Restoring Data FilesYear EndGlossary of Terms - Foreign Language Help SheetsCSO