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 USC Cut-Off Point 1

Annual USC Cut-Off Point 2

Annual USC 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 BrightPay

Installing the software on to your PC Setting Up BrightPay for Multiple Users Download Sample Employer Files

General

2017 Budget - Employer Summary Payroll Calendar Minimum Wage Pension Related Deduction (PRD)Ordering for Next Year

Getting Started

Introduction to BrightPay Setting up an employer and its employees using a ROS P2C File

Importing from Previous Year

Importing from BrightPay 2016 Importing from Thesaurus Payroll Manager

Switching from Thesaurus Payroll Manager to BrightPay mid year Importing employee data from another payroll package

Employee Data that can be Imported into BrightPay Migrating from SAGE Micropay to BrightPay

Employer

Adding a New Company Additional Employer Information Setup Initial Rates of pay Adding/ Amending Hourly Rates Adding/ Amending Daily Rates Adding/ Amending Piece Rates Adding/ Amending Addition Types Adding/ Amending Deduction Types Adding/ Amending Pension Schemes Adding/ Amending Savings Schemes Adding/ Amending Bank Accounts Adding/ Amending Departments

Employee

Exporting a P2C file from ROS Importing a P2C file Personal Employment Payment Revenue Details HR CSO

Payroll Deductions

Universal Social Charge Universal Social Charge - Calculations USC Exempt Status v USC Exempt Income PAYE - Pay As You Earn Cumulative Basis/Week 1 Basis/Temporary Basis Emergency Tax Basis PRSI PRSI - 2017 Tables Local Property Tax (LPT)Bike to Work Scheme

Payroll

Processing Weekly Payroll Processing Fortnightly Payroll Processing Monthly Payroll Processing 4-Weekly Payroll Net to Gross Payments Entering Pension Deductions Allocating An Employee's Pay across Departments Importing Pay Data from a CSV File Finalising Payslips Printing Payslips Emailing Payslips Exporting Payslips Paying Employees

Mid-year Starters

Setting up a new employee mid-year Preparing a P45 Part 3 for ROS Preparing a P46 for ROS Submitting a P46/P45 Part 3 to ROS

Leavers

Issuing a P45 Printing a P45 Reversing a P45 Submitting a P45 to ROS

Pensions

Adding/ Amending Pension Schemes Entering Normal Pension Deductions Entering a CWPS Pension Entering a NECI Pension Normal Pensions Report CWPS & NECI Reports

Illness Benefit

Illness Benefit - General Employer does not pay employee while out sick Employer pays employee while out sick but employee retains the illness benefit Employer pays employee while out sick and receives the illness benefit Making adjustments to previously paid illness benefit

Benefit in Kind

Benefit in Kind - General Information Vehicles Loans Accommodation Medical Insurance - Annual Medical Insurance - One-Off Share Based Remuneration Annual Benefits One-Off Benefits

Parenting Leave

Adoptive Leave & Pay Maternity Leave & Pay Paternity Leave and Pay

Holidays

Holiday Entitlements - Useful Information Processing Holiday Pay Accrual of Annual Leave Whilst on Sick Leave

Employee Calendar Making Corrections to Payroll

Re-defining Schedule of Periods Re-opening Payslips

P30 Returns

Monthly P30 Return Quarterly P30 Return P30 ROS File

Analysis

Saved Reports Creating a New Report Viewing Reports Editing Reports Saving Reports Printing Reports Exporting Reports

Backing Up & Restoring Data Files

Backing Up Your Payroll Data Restoring a Payroll Data File

Year End

Preparing a P35 ROS File Submitting a P35 to ROS P60s Week 53 Medical Insurance Eligible for Tax Relief

Glossary of Terms - Foreign Language Help Sheets

Cantonese Czech English Hungarian Latvian Lithuanian Mandarin Polish Portuguese Romanian Russian

CSO

EHECS (EARNINGS, HOURS & EMPLOYMENT COSTS SURVEY)

BrightPay Connect

Employee Data that can be Imported into BrightPay

Thanks!

Thanks!

Thanks!

Thanks!

Thanks!

Thanks!