NOTE: You are viewing documentation for a previous tax year version of BrightPay. Click here to view the documentation for the current 2024/25 tax year version.

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

To assist with column selection, under 'Options', simply select 'Try and Match Columns to CSV Header Row Titles'. BrightPay will try and match as many columns as it can for you.

Please note: 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 Column Selections' under the 'Options' menu. BrightPay will subsequently remember the column selection used in the previous import when next importing a new employee CSV file.

Alternatively, should you wish to reset your column selection, select 'Reset All Columns'.

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 Name

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

Taxable Pay in Previous Employment

Tax in Previous Employment

Leave Date

Is Deceased

Department

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 Hours 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

Student Loan Plan

Student Loan Start Date

Student Loan Stop Date

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

Payroll ID (RTI)

Contracted Hours Worked

Is Irregular Payment Pattern

Is Flexibly Accessing Pension Rights

Job Title

Starting Salary

Employment Arrangements

Next Review Date

Document Password

Medical Information

Notes

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

SSP to Date (Mid Year)

SMP to Date (Mid Year)

SPP to Date (Mid Year)

SAP to Date (Mid Year)

ShPP to Date (Mid Year)

Gross Pay to Date (Mid Year)

Taxable Pay (including Free Pay) to Date (Mid Year)

Free Pay to Date (Mid Year)

Tax to Date (Mid Year)

NIC-able Pay to Date (Mid Year) (Current NI Table)

Earnings to LEL to Date (Mid Year) (Current NI Table)

Earnings from LEL to PT to Date (Mid Year) (Current NI Table)

Earnings from PT to UEL to Date (Mid Year) (Current NI Table)

Employee NI Contributions to Date (Mid Year) (Current NI Table)

Employer NI Contributions to Date (Mid Year) (Current NI Table)

Total NI Contributions to Date (Mid Year) (Current NI Table)

National Insurance Table (Preceding)

NIC-able Pay to Date (Mid Year) (Preceding NI Table)

Earnings to LEL to Date (Mid Year) (Preceding NI Table)

Earnings from LEL to PT to Date (Mid Year) (Preceding NI Table)

Earnings from PT to UEL to Date (Mid Year) (Preceding NI Table)

Employee NI Contributions to Date (Mid Year) (Preceding NI Table)

Employer NI Contributions to Date (Mid Year) (Preceding NI Table)

Total NI Contributions to Date (Mid Year) (Preceding NI Table)

Student Loan Deductions to Date (Mid Year)

Employee Pensionable Pay to Date (Mid Year)

Employer Pensionable Pay to Date (Mid Year)

Employee Pension to Date (Mid Year)

Employee Additional Voluntary Pension to Date (Mid Year)

Employer Pension to Date (Mid Year)

Net Pay to Date (Mid Year)

Take Home Pay to Date (Mid Year)

Cost to Employer to Date (Mid Year)

Need help? Support is available at 0345 9390019 or [email protected].

Important Information for Free Licence Users Important Information for Mac Users Bureau Enhancements - Additional Functionality Bureau Licence Holders (Only)

Agent Settings Client Details BrightPay Startup Window Batch RTI Submissions Exporting Client Documents Importing Multiple Employers from CSV File

Installing BrightPay

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

Ordering for The New Tax Year Importing From The Previous Tax Year Moving to BrightPay from another payroll software

Preparing for your move to BrightPay - Useful Guidance List of Employer Data that can be Imported into BrightPay List of Employee Data that can be Imported into BrightPay Moving to BrightPay mid-year - Recoverable Amounts to Date Moving to BrightPay mid-year - Employment Allowance Moving to BrightPay - Continuing Auto Enrolment from a previous software Importing from HMRC Basic PAYE Tools Importing from IRISImporting from MoneysoftImporting from SAGE Importing using a CSV File - Other software Importing using an FPS File - Other Software

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 Addition Types Adding/ Amending Deduction Types Adding/ Amending Savings Schemes Adding/ Amending Bank Accounts

Employee Details

Personal Employment Starter/Leaver Payment Tax, NICs, RTI HR, Other Coding Notices Importing Employees from a CSV File Employee Count Report Employee Address Labels

Processing Payroll

Weekly Payroll Fortnightly Payroll 4-weekly Payroll Monthly Payroll Quarterly Payroll Annual/Yearly Payroll Net to Gross Payments Allocating An Employee's Pay across Departments Processing Pension Deductions (outside of AE)Importing Pay Data from a CSV File Additions and Deductions Zeroising Payslips Finalising Payslips Printing Payslips Emailing Payslips Exporting Payslips Paying Employees Childcare Vouchers

Payroll Calendar Payslip Translations Making Corrections to Payroll

Re-opening Payslips Re-defining Schedule of Periods

Pre-paying an Employee Scheduling Future Payments Switching an Employee's Pay Frequency RTI

Reporting Contracted Hours - Hourly Bands for FPS Full Payment Submission (FPS)Additional Full Payment Submission Employer Payment Summary (EPS)NINO Verification Request (NVR)Earlier Year Update (EYU)Marking RTI Submissions as already sent to HMRC

Common HMRC Error Messages HMRC Payments

Recording Payments to HMRC P30 & P32

Analysis

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

Payroll Journals

Payroll Journals - Overview Exact Kashflow Quickbooks Sage Xero Creating a Generic Payroll Journal

Starters

Setting up a new employee mid-year New Starter Checklist Tax Codes to use for New Employees New Starters and Recruitment Templates

Leavers

Processing a Leaver Processing Payments After Leaving

Student Loan Deductions Statutory Payments

Statutory Sick Pay Statutory Maternity Pay Statutory Adoption Pay Statutory Paternity Pay (Birth)Statutory Paternity Pay (Adoption)Statutory Shared Parental Pay (Birth)Statutory Shared Parental Pay (Adoption)Statutory Pay Calculation & Schedule Report

Pensions

CISR Pensions COSR Pensions Freestanding AVCs Group Pension Policy Personal Pensions Stakeholder Pensions Other Traditional Schemes

Attachment of Earnings

Attachment of Earnings (Northern Ireland)Child Support Deductions from Earnings Order (DEO)Civil Judgment Debt Attachment of Earnings Order (County Court)Council Tax Attachment of Earnings Order (CTAEO)Current Maintenance Arrestment (CMA)Direct Earnings Attachment Earnings Arrestment (EA) (Scotland)Magistrates Court Attachment of Earnings Order Maintenance Attachment of Earnings Order Other Attachment of Earnings Orders Attachment Order Summary Report

Expenses & Benefits

Payrolling BenefitsP11D & P11D(b)

Payroll Giving Directors

Setting Up a Director Directors' NIC Directors appointed during the Tax Year

Employee Calendar Holidays

Processing Holiday Pay Recording Annual Leave on the Calendar Annual Leave Entitlement Methods in BrightPay Adjusting an Employee's Leave Entitlement Viewing/ Printing Employees' Annual Leave Entitlement Holiday Entitlements - Useful Information Annual Leave Request Form

Tax

Tax Codes - The Basics Tax Rates and Bands Marriage Allowance Scottish Rate of Income Tax (SRIT)50% Overriding Regulatory Limit

Scottish Rate of Income Tax (SRIT)National Insurance

NIC Category Letters NIC Thresholds & Rates Directors' NICs State Pension Age

Employment Allowance Apprenticeship Levy National Minimum/Living Wage

National Minimum Wage and National Living Wage Minimum Wage Flagging and Reporting

Off-Payroll Working in the Public Sector Rates & Thresholds at a Glance

Rates & Thresholds 2015-16 Rates & Thresholds 2016-17 Rates & Thresholds 2017-18

Mileage Allowance Payments (MAPs)Year End

Year-End Procedure For Tax Year 2013-14 Year-End Procedure for Tax Year 2014-15 Year-End Procedure for Tax Year 2015-16 Year-End Procedure for Tax Year 2016-17 Year-End Procedure for Tax Year 2017-18

Backing Up/ Restoring Your Payroll BrightPay Licence Terms and Conditions Construction Industry Scheme (CIS)

CIS

Automatic Enrolment

Entering your Staging Date in BrightPay Entering your Pension Scheme in BrightPay Performing a Pre Staging Assessment in BrightPay Processing Eligible Jobholders in BrightPay Processing Non-Eligible Jobholders in BrightPay Processing Entitled Workers in BrightPay Postponing Employees in BrightPay Batch Processing of Employees in BrightPay Processing Opt-out Notices in BrightPay Preparing Enrolment Files/ Contribution Files in BrightPay Applying a Salary Sacrifice Arrangement in BrightPay Dedicated Pension Providers in BrightPay - GuidanceAutomatic Enrolment - Useful GuidanceSalary Sacrifice for Auto Enrolment

BrightPay Connect

BrightPay Connect - Overview Registering for BrightPay Connect Linking an Employer to BrightPay Connect Customising your BrightPay Connect Account Assigning a New User in BrightPay Connect Editing/Deleting a User from BrightPay Connect Enabling Employee Access to Self Service Configuring Employee Self Service Options Disabling/Editing Employee Access to Self Service Inviting Employees to use Self Service Automated Cloud Backup Restoring from a Cloud Backup Employer Self Service PortalEmployee Self Service Portal

GDPR

Frequently Asked Questions GDPR and BrightPay GDPR and the Payroll Bureau

Importing Employees from a CSV File

Thanks!

Thanks!

Thanks!

Thanks!

Thanks!

Thanks!