Adding New Employees from a CSV File

To access this utility, go to Employees > Import & Export > Import/Update 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.

Note:

In order for BrightPay to match row data against existing employees, it will use the 'identity columns'. These 'identity columns' are:

Name
Surname
Works Number
PPS Number

At least one of the above columns must be selected by the user to trigger a match attempt. Rows will be deemed to match only if the values for all selected identity columns equal those for the employee.

To assist with column selection, simply select 'Match Header Row'. BrightPay will try and match as many columns as it can for you
Should you have employee CSV files to import for more than one company e.g. you are moving a number of companies across from a previous software, simply instruct BrightPay to 'Remember Columns'. BrightPay will subsequently remember the column selection used in the previous import when next importing a new employee CSV file.
Should you wish to reset your column selection at any time, select 'Reset All Columns'.
Should you not wish to import employees with a leave date in a previous year, select this within 'Options'

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

Employee data which can be imported in to update existing employee records are:

Personal Details:

Title

Middle Name

Gender

Date of Birth

Nationality

Passport Number

Contact Details:

Address Line 1

Address Line 2

Address Line 3

County

Eircode

Country

Email Address

Phone Number

Employment Details:

Employment ID

Department

Directorship

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 on EWSS

Shadow Payroll

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

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

Starter/Leaver:

Start Date

Previous Employment Taxable Pay

Previous Employment Tax

Previous Employment USC-able Pay

Previous Employment USC

Previous Employment ASC-able Pay

Previous Employment ASC

Leave Date

Is Deceased

Payment:

Payment Frequency

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

HR:

Job Title

Document Password

Next Review Date

Medical Information

Notes

Additional fields which can be imported if a MID-YEAR setup:

Mid Year Cumulative Notional Pay

Mid Year Cumulative Medical Insurance

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

BrightPay (Cloud) System Requirements What's New in BrightPay?

Logging into BrightPay with your Bright ID

Two Factor Authentication - Organisation

Enabling Two Factor Authentication Selecting Method to Receive Verification Code Two Factor Authentication FAQs

What's happening to BrightPay for Windows?Introduction to BrightPay Getting Started

Getting Set up in BrightPay Creating an Organisation Add or Import an Employer

Importing Into BrightPay from BrightPay Windows Moving to BrightPay from another payroll software

Importing into BrightPay from Thesaurus Payroll ManagerImporting Employees - List of Employee Data that can be Imported into BrightPay Adding your ROS Certificate - Employer Adding your ROS Certificate - Agent Setting up Employees using the RPN Setting up Employees using a CSV File

User Management

Overview of User Roles & Permissions Team Member Roles Inviting a User

MultiUser Enhancements Employer Details

Adding a New Employer Adding/Amending Employer Details Adding/Amending Departments Adding/Amending Hourly Rates Adding/Amending Daily Rates Adding/Amending Piece Rates Adding/Amending Deduction Types Adding/Amending Addition Types Adding/Amending Savings Scheme Adding/Amending Bank Accounts Adding/Amending Pension Schemes Employer Calendar

Employee Details

Personal Employment Payment PAYE Details HR Generating Employee Works Numbers Adding New Employees from a CSV File Adding Employees from an RPN

Digital Certificates

Why do I need to add my Revenue Digital Certificate?Adding a Revenue Digital Certificate - Employers Adding a Revenue Digital Certificate - Agents Saving a ROS Digital Certificate on to your computer Transferring a ROS Digital Certificate from one computer to another

Revenue Payroll Notifications (RPNs)

What is a Revenue Payroll Notification (RPN)?Employment Identifier RPN Number Retrieving your Employee RPNs each pay period

Processing Payroll

Setting up your Payment Schedule Weekly Payroll Fortnightly Payroll 4-weekly Payroll Monthly Payroll Quarterly Payroll Annual/Yearly Payroll Period Summary View (Payroll Preview)

Payroll Submission Requests (PSRs)

What is a Payroll Submission Request (PSR)?Submitting your periodic pay data to Revenue Correction PSRs

Importing Pay Data using CSV File

Importing Periodic Payments using CSV file Importing Daily Payments using CSV File Importing Hourly Payments using CSV File Importing Additions using CSV File Importing Deductions using CSV File Importing Notes using CSV File Importing Payments, Additions & Deductions in a single CSV File CSV Import Preferences

Distributing Payslips

Printing Payslips Emailing Payslips Exporting Payslips Customising Payslips

Paying Employees

Paying Employees by Cash Paying Employees by Cheque Paying Employees by Credit Transfer & Creating a Bank File Paying Employees by Modulr

Making Corrections in Payroll

Correction PSRs Re-opening the last pay period for one or more employees Re-opening more than one pay period for one or more employees

Payroll Calendar 2025 Benefit in Kind

Benefit in Kind - General Information Company Cars/Vans Preferential Loans Accommodation Medical Insurance - Annual Medical Insurance - One Off Shared Based Remuneration Annual Benefits One Off Benefits

Employee Self Service Portal

BrightPay Employee Self Service Portal - Overview Manager's PortalEnabling Employee Access to Self Service Portal Disabling/Editing Employee Access to Self Service Configuring Employee Self Service Options Inviting Employees to use Self ServiceEmployee Self Service Portal

BrightPay (Cloud) Service Infrastructure Payroll Journals

Payroll Journals - Overview

Analysis

Saved Reports

Payroll Deductions

PAYE PRSI Local Property Tax (LPT)USC

National Minimum Living Wage Pensions

Adding/Amending Pension Schemes Entering Normal Pension Deductions Normal Pensions Report CWPS

Switching an Employee's Pay Frequency Enhanced Reporting Requirements (ERR)

ERR Overview ERR Categories Enhanced Reporting Requirements (ERR) FAQs

BrightExpenses

Signing Up for your Bright ID Sending Expense/Benefit details from BrightPay to BrightExpenses BrightPay to BrightExpenses Tutorial

Payslip Translations 2025 Budget - Employer Focus 2026 Budget - Employer Focus Annual Leave

Processing Holiday Pay - Current Pay Period Processing Holiday Pay - Pre-paying in Advance Recording an Employee's Annual Leave Batch Processing of Employee Annual Leave on the Calendar Holiday Entitlements - Useful Information Accrual of Annual Leave Whilst on Sick Leave

Employment Law - Information

Employment - General Organisation of Working Time Act, 1997 Minimum Wage

SEPA format - Banks catered for in BrightPay Two Factor Authentication - Employees

Enabling Two Factor Authentication for Employees Selecting Method to Receive Verification Code Employee Two Factor Authentication FAQs

Auto Enrolment

Auto Enrolment FAQ's Help Guide Processing Auto Enrolment Auto Enrolment Webinar Q&A

Adding New Employees from a CSV File

Thanks!

Thanks!

Thanks!

Thanks!

Thanks!

Thanks!