Importing Multiple Employers from CSV File


Clients moving to BrightPay from another payroll software can import all employers into BrightPay using a CSV file.

To import employers, simply click on the ‘Import Employer(s)’ button at the bottom of the ‘Open Employer’ screen and select 'Import Employers from CSV File'

 

 

1) Browse to the location of your employer CSV File

2) Select the required file and click 'Open'

3) The employer information will be displayed on screen. For each column, choose the data it represents. Ignore any columns and uncheck any rows you do not wish to be imported.

To assist with column selection, simply select 'Match Header Row'. BrightPay will try and match as many columns as it can for you.


 

Please note: should you have more than one employer CSV file to import simply instruct BrightPay to 'Remember Columns'. BrightPay will subsequently remember the column selection used in the previous import when next importing a new employer CSV file.

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

 

Employer Fields which can be imported into BrightPay using CSV file format are:

Name

PAYE Reference

Accounts Office Reference

Automatic re-enrolment date

Is exempt from Auto Enrolment

Auto Enrolment Declaration of Compliance date

Trading name

Address line 1

Address line 2

Address line 3

Address line 4

Postcode

Country

HMRC office name

HMRC office phone number

Unique Tax Reference

Corporation Tax reference

BACS Service User Number

Qualifies for Small Employers' Relief

HMRC contact title

HMRC contact name

HMRC contact middle name

HMRC contact surname

HMRC contact phone number

HMRC contact fax number

HMRC contact email address

HMRC Sender ID

HMRC Sender Password

BrightPay Profile

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

24-25 BrightPay - System Requirements24-25 BrightPay - DownloadIntroduction to BrightPayImportant Information for Mac UsersStarting the New Tax YearImporting From The Previous Tax YearInstalling BrightPayMoving to BrightPay from another payroll softwareBureau Enhancements - Useful Functionality for Bureau Licence HoldersEmployer DetailsEmployee DetailsCoding NoticesPayroll CalendarProcessing PayrollImporting Pay Data using CSV FileDistributing PayslipsPaying EmployeesRTICommon HMRC Error MessagesAnalysisPayroll JournalsHMRC PaymentsMaking Corrections to PayrollScheduling Future PaymentsSwitching an Employee's Pay FrequencyDirectorsOff-Payroll Working (IR35)StartersLeaversStudent Loan DeductionsPostgraduate Loan DeductionsStatutory PaymentsAttachment of EarningsExpenses & BenefitsPensions (outside of Automatic Enrolment)Payroll GivingYear EndRates & Thresholds at a GlanceTaxNational InsuranceNational Minimum/Living WageMileage Allowance Payments (MAPs)Employment AllowanceApprenticeship LevyTermination Awards & Sporting TestimonialsGender Pay Gap ReportingLeave Reporting & Employee CalendarAnnual LeavePayslip TranslationsBacking Up/Restoring Your PayrollConstruction Industry Scheme (CIS)Automatic EnrolmentBrightPay ConnectGDPRBright Terms and Conditions and BrightPay End User Licence AgreementBright ID