Importing Hourly Payments using CSV file

To import hourly payments each pay period, go to Payroll > Batch > Import Pay Records from CSV File > Import Hourly Payments:

1) Browse to the location of your CSV File

2) Select the required file and click 'Open'

3) Your employee data will be displayed on screen. For each column, choose the payment 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
Also indicate whether you would like to replace the equivalent pay items that are already present on the employees' payslips with the new amounts being imported in by selecting/de-selecting 'Replace Existing'
Should you wish to remember your column selection for future imports, instruct BrightPay to 'Remember Columns'. BrightPay will subsequently remember the column selection used in the previous import when next importing a CSV file.
Should you wish to reset your column selection at any time, select 'Reset All Columns'.

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

Fields which can be imported into BrightPay using the 'Hourly Payments' CSV File option are:

For matching to employee record:

Employee first name

Employee surname

Employee PPSN

Employee works number

Payment using employer hourly rate:

Number of hours at an hourly rate set up within the Employer utility

Payment 1:

Rate per hour (if different from standard rate)

Description

Number of normal hours

Number of time and a half hours

Number of time and a third hours

Number of time and a quarter hours

Number of double time hours

Number of triple time hours

Number of quadruple time hours

Department

Is tax deductible

Is employee PRSI deductible

Is employer PRSI deductible

Is USC deductible

Is ASC deductible

Is pension deductible

Payment 2:

Rate per hour (if different from standard rate)

Description

Number of normal hours

Number of time and a half hours

Number of time and a third hours

Number of time and a quarter hours

Number of double time hours

Number of triple time hours

Number of quadruple time hours

Department

Is tax deductible

Is employee PRSI deductible

Is employer PRSI deductible

Is USC deductible

Is ASC deductible

Is pension deductible

Payment 3:

Rate per hour (if different from standard rate)

Description

Number of normal hours

Number of time and a half hours

Number of time and a third hours

Number of time and a quarter hours

Number of double time hours

Number of triple time hours

Number of quadruple time hours

Department

Is tax deductible

Is employee PRSI deductible

Is employer PRSI deductible

Is USC deductible

Is ASC deductible

Is pension deductible

Payment 4:

Rate per hour (if different from standard rate)

Description

Number of normal hours

Number of time and a half hours

Number of time and a third hours

Number of time and a quarter hours

Number of double time hours

Number of triple time hours

Number of quadruple time hours

Department

Is tax deductible

Is employee PRSI deductible

Is employer PRSI deductible

Is USC deductible

Is ASC deductible

Is pension deductible

Payment 5:

Rate per hour (if different from standard rate)

Description

Number of normal hours

Number of time and a half hours

Number of time and a third hours

Number of time and a quarter hours

Number of double time hours

Number of triple time hours

Number of quadruple time hours

Department

Is tax deductible

Is employee PRSI deductible

Is employer PRSI deductible

Is USC deductible

Is ASC deductible

Is pension deductible

Need help? Support is available at 01 8352074 or [email protected].

Coronavirus (Covid-19) - Guidance for BrightPay users

Level 5 Restrictions - Possible Payroll Implications BrightPay's Covid-19 Resources Hub Employment Wage Subsidy Scheme (EWSS) - effective from 1st September 2020Temporary Covid-19 Wage Subsidy Scheme (TWSS) - effective until 31st August 2020Layoff and Short-time Working under Covid-19 Returning staff to work How to use BrightPay if you need to work from home

Introduction to BrightPay BrightPay Licence Terms and Conditions 2020 Budget - Employer Summary 2020 Payroll Calendar Installing BrightPay

Installing the software on to your PC Setting Up BrightPay for Multiple Users

Importing from the Previous Tax Year

Importing from BrightPay 2019

Moving from Thesaurus Payroll Manager to BrightPay

Importing from Thesaurus Payroll Manager - start of year Importing from Thesaurus Payroll Manager to BrightPay - mid tax year

Moving to BrightPay from another payroll software

Employee Data that can be imported into BrightPay Importing Multiple Employers from CSV File

Moving BrightPay to a new PC Bureau Enhancements - Additional Functionality

BrightPay Start Up Window Client Details Importing Multiple Employers from CSV File Bureau Statistics Report

Payroll Deductions

PAYE PRSILocal Property Tax (LPT)USCAdditional Superannuation Contribution (ASC)

Employer

Adding a New Company (using the New Company wizard)Adding Employees using a Revenue Payroll Notification (RPN)Additional Employer Information Adding/ Amending Departments Setting up 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 Employer Calendar

Employer Calendar 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

Employee

Personal Employment Revenue Details Payment HR CSO Setting up Employees using the RPN Re-hiring an Employee

Employee Calendar Revenue Payroll Notifications (RPNs)

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

Processing Payroll

Processing Weekly Payroll Processing Fortnightly Payroll Processing Monthly Payroll Processing 4-Weekly Payroll Net to Gross Payments Finalising Payslips Allocating an Employee's Pay across Departments Entering Pension Deductions Cycle to Work Scheme Week 53

Payroll Submission Requests (PSRs)

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

Distributing Payslips

Printing Payslips Emailing Payslips Exporting Payslips

Paying Employees SEPA format - Banks catered for in BrightPay Making Corrections to Payroll

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

Revenue Payments

Remittance to Revenue - Overview Viewing/Accepting your Monthly Statement in ROS Payment Due Dates Making Payment to Revenue - Payment OptionsRevenue Payments - Finalised totals Revenue Payments - Revenue Reconciliation

Analysis

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

Payroll Journals

Payroll Journals - Overview Quickbooks SAGE Xero

Importing Pay Data from a 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

Processing Starters

Setting up a new employee mid-year

Processing Leavers Benefit in Kind

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

Illness Benefit

Illness Benefit - Employer Responsibilities 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

Parenting Benefits

Maternity Leave & Benefit Adoptive Leave & Pay Paternity Leave and Benefit Parent's Leave & Benefit

Pensions

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

Switching an Employee's Pay Frequency Backing Up & Restoring Data Files

Backing Up Your Payroll Data Restoring a Payroll Data File

CSO

EHECS (EARNINGS, HOURS & EMPLOYMENT COSTS SURVEY)

Holidays

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

Leave Entitlements

Holiday Entitlements Maternity Leave Paternity Leave Parental Leave Adoption Leave Carers Leave Parent's Leave

Employment Law

Employment - General Organisation of Working Time Act, 1997 Minimum Wage Minimum Notice, Dismissals etc.Children & Young Persons Sample HR templates and forms Workplace Relations Commission

Year End

Year End - Frequently Asked Questions The P60 Replacement Do I need to file a P35 annual return?Do I have a Week 53?Year End Summary Report Making an Advance Payment in 2020 for 2021 How do I start processing 2021 payroll?When will 2021 BrightPay be available?Will my ROS digital certificate import over to 2021 BrightPay?Revenue Payroll Notifications - Transition to the new tax year Why are my employees on Emergency Basis at the start of the 2021 tax year?

Ordering for Next Tax Year Revenue - Contact Telephone Numbers Glossary of Terms (Pre 2019) - Foreign Language Help Sheets

Cantonese Czech English Hungarian Latvian Lithuanian Mandarin Polish Portuguese Romanian Russian

BrightPay Connect

Registering for BrightPay Connect Connecting 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 Backing Up to BrightPay Connect Restoring from a BrightPay Connect Backup Employer Self Service PortalEmployee Self Service PortalConnect for BureausUploading Previous Year Data to BrightPay Connect Deleting a Company in BrightPay Connect

GDPR

Frequently Asked Questions GDPR and Thesaurus Software GDPR and the Payroll Bureau Data Processor Agreement

Importing Hourly Payments using CSV file

Fields which can be imported into BrightPay using the 'Hourly Payments' CSV File option are:

Thanks!

Thanks!

Thanks!

Thanks!

Thanks!

Thanks!