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

County

Eircode

Country

Gender

Date of Birth

Email Address

Phone Number

PPS Number

Employment ID

Works Number

Start Date

Leave Date

Is Deceased

Department

Directorship

Shadow Payroll

Calculation Basis

Has PAYE Exclusion Order

Has A1 Certificate

Annual Tax Credit

Annual Tax Cut-Off Point

Is Exempt from USC

Annual USC Cut-Off Point 1

Annual USC Cut-Off Point 2

Annual USC Cut-Off Point 3

PRSI Class

Is Exempt From PRSI

PRSI Exemption Reason

Total LPT to be Deducted

ASC 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

Nationality

Passport Number

Document Password

BrightPay Connect - Enable Self Service

BrightPay Connect - Is Confidential

Starting Salary

Employment Arrangements

Next Review Date

Medical Information

Notes

Previous Employment Tax-able Pay

Previous Employment Tax

Previous Employment USC-able Pay

Previous Employment USC

Previous Employment ASC-able Pay

Previous Employment ASC

Previous Employment LPT

Mid Year Cumulative Notional Pay

Mid Year Cumulative Maternity Benefit

Mid Year Cumulative Paternity Benefit

Mid Year Cumulative Adoption Benefit

Mid Year Cumulative Tax-able Pay

Mid Year Cumulative Tax

Mid Year Cumulative USC-able Pay

Mid Year Cumulative USC

Mid Year Cumulative ASC-able Pay

Mid Year Cumulative ASC

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].

Coronavirus (Covid-19) - Guidance for BrightPay usersIntroduction to BrightPayBrightPay Licence Terms and Conditions2020 Budget - Employer Summary2020 Payroll CalendarInstalling BrightPayImporting from the Previous Tax YearMoving from Thesaurus Payroll Manager to BrightPayMoving to BrightPay from another payroll softwareMoving BrightPay to a new PCBureau Enhancements - Additional FunctionalityPayroll DeductionsEmployerEmployer CalendarDigital CertificatesEmployeeEmployee CalendarRevenue Payroll Notifications (RPNs)Processing PayrollPayroll Submission Requests (PSRs)Distributing PayslipsPaying EmployeesSEPA format - Banks catered for in BrightPayMaking Corrections to PayrollRevenue PaymentsAnalysisPayroll JournalsImporting Pay Data from a CSV FileProcessing StartersProcessing LeaversBenefit in KindIllness BenefitParenting BenefitsPensionsSwitching an Employee's Pay FrequencyBacking Up & Restoring Data FilesCSOHolidaysLeave EntitlementsEmployment LawYear EndOrdering for Next Tax YearRevenue - Contact Telephone NumbersGlossary of Terms (Pre 2019) - Foreign Language Help SheetsBrightPay ConnectGDPR