Importing Hours from Text or CSV File

Importing Hours from a Text File

To access this utility go to Utilities > Import Hours> from text file

The import file name must be wimport.txt
Within this utility, simply click 'Find Import File' in order to browse to the drive and folder where the import file has been saved to.
The option 'Get Employee List' will provide you with a list of your employees (on the pay frequency you are currently in) and their corresponding works number. It will also indicate which employees have been issued with a P45. This list can be copied to Excel via the clipboard and sorted as desired.
The import file detail is shown to the user on a similar grid.

Please note: there is no checking that the names/works numbers are correct. It is up to the user to determine that the works numbers on the import data file match the works numbers of the corresponding employees in the payroll. The employee works numbers are shown on the grid.

The file spec

ascii text file - zero filled

bytes name

02 period - week or month number

04 employee number

06 Standard hours (123.56)

06 hours x 1.5 (123.56)

06 double time (123.56)

02 weekly or monthly marker (1 is weekly, 2 is monthly)

06 hours x 1.3333

30 filler

02 carriage return/line feed

total record size is 64 bytes

Importing Hours from CSV File

To access this utility go to Utilities > Import Hours > from CSV file

The file spec

Works No, Hours at standard rate, at time & half, at double time, at time & third

e.g.

0001,40,,,

0002,40,4,2,

0003,40,,,3

or

0001,40

0002,35

To record fractional hours then these should be shown in decimal format

e.g.

0001,40.50,,,

The above would record 40 1/2 standard hours for employee with the works number 1

Click 'Locate File' and the grid will populate with the contents of the chosen CSV file
Click 'Validate' and the program will see if it can match works numbers with employees
Click 'Import' when you are happy that it is OK to import

The hours imported will be used when you next update the payroll.

Need help? Support is available at 01 8352074 or thesauruspayrollsupport@brightsg.com.

Help 2019 Thesaurus Payroll Manager - System Requirements 2019 Budget - Employer Summary Payroll Calendar Payroll Deductions

Universal Social Charge (USC)Universal Social Charge (USC) - Calculations USC Exempt Status v USC Exempt Income PAYE PRSI Local Property Tax (LPT)Bike to Work Scheme

Getting started

Getting Started

Importing from previous year

Importing Your Company and Employee details from the previous tax year

Importing from other Payroll Software

Importing from SAGE Micropay - Start of Year Importing from Big Red Book - Start of Year Importing from SAGE QuickPay - Start of Year

Migrating to Thesaurus Payroll Manager Mid Tax-Year Company Setup

Adding a company (using the New Company wizard)Adding a company using a backup Adding a company using a CSV File Additional PAYE registration numbers Setting up a ROS sub cert for your additional PAYE registration Migrating Employees to a new PAYE Registration Number

Digital Certificates

Why do I need to add my Digital Certificate?Adding a Digital Certificate - Employers Adding a Digital Certificate - Agents Saving a ROS digital certificate on to your computer Transferring a ROS digital certificate from one computer to another Setting up a ROS sub cert for your additional PAYE registration Thesaurus Payroll Manager Bureau version and Agent ROS Digital certificates Digital Certificates - Common Support Queries

Add/ Amend Employees

Entering Personal details Entering Revenue details Importing your Employees' Revenue Information from Revenue (RPNs)Setting up Additions Setting up Deductions Setting up Departments Entering Mid Year Cumulatives Entering HR Details Entering CSO Details Setting up Employees using an RPN Leavers Re-joining

Revenue Payroll Notifications (RPNs)

What is a Revenue Payroll Notification (RPN)?Employment Identifier RPN Number Retrieving your Employees' Revenue Details from Revenue (RPNs) each pay period Setting up Employees using an RPN RPN Logs & Reminders

Processing Payroll

Weekly Payroll Monthly Payroll Fortnightly Payroll Quick Edit Entry Net to Gross Payments Payroll Preview Finalising the Pay Period Payslip Workings Computational Anomaly Specifying end dates for additions or deductions Directors Fees Share Based Remuneration Importing Hours from Text or CSV File Full periodic CSV Import

Payroll Submission Requests (PSRs)

What is a Payroll Submission Request (PSR)?Submitting your periodic pay data to Revenue Recheck Payroll Submissions Correction PSRs Check Revenue Record PSR Control Panel Viewing your Payroll Submissions in ROS

Distributing Payslips

Printing Payslips Emailing payslips Payslip Workings

Paying Employees

Paying Employees - Reporting Paying Employees using a Bank Payment File - SEPA Paying Employees with a Non-Irish Bank Account - SEPA Paying Employees using a Bank Payment File - Bankline

Corrections - Overview Do it all again!New Employee Payment was different Wrong PPS Number Wrong PRSI Class Employee has left

Revenue Payments

Remittance to Revenue - Overview Viewing/Accepting your Monthly Statement in ROS Payment Due Dates Making Payment to Revenue - Payment OptionsTax Details Report - Monthly/Quarterly Details Query Revenue Record Revenue Payments Record Returns Look Up

Payroll Summary/Audit Trail Tax Details Report - Monthly/Quarterly Details Pensions Additions/Deductions Other Reports Register of Employees Year End Summary

Processing Starters Processing Leavers

Processing a Leaver (in current pay run)Processing a Leaver (mid pay period)Processing a Leaver (taxable/non-taxable lump sum payment on termination)Processing a Post Cessation Payment

Benefit in Kind

Benefit in Kind - General Information BIK Cars and Vans BIK Preferential Loans BIK Annual Benefits BIK One Off Benefits

Illness Benefit

Illness Benefit - Employer Responsibilities Employer Does Not Pay Sick Leave Employer pays Employee while out sick Employer receives Illness Benefit payment

Maternity Benefit

Taxation of Maternity Benefit

Paternity Benefit

Taxation of Paternity Benefit

Setting Up Pension Deductions Entering a Pension Tracing Number NECI Pensions Normal Pension Report Remittance (Pension)CWPS

Changing an Employee's Pay Frequency Year End - 2019

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 2019 for 2020 How do I start processing 2020 payroll?When will 2020 Thesaurus Payroll Manager be available?Will my ROS digital certificate import over to 2020 Thesaurus Payroll Manager?Revenue Payroll Notifications - Transition to the new tax year Why are my employees on Emergency Basis at the start of the 2020 tax year?

Backup and Restore

Backing up your payroll data Restoring your payroll data Backup ALL Companies

Holiday Entitlements - Useful Information Processing holiday pay Force early return from holidays Holiday calculator Holiday planner Accrual of Annual Leave Whilst on Sick Leave

Leave Entitlements

Holiday Entitlements Maternity Leave Paternity Leave Parental Leave Adoption Leave Carers Leave

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

Ordering for the new tax year Payroll Upgrades Calculator Civil Service Mileage Rates Exporting payroll journals to accounts software Gift Cards - Integration and tracking Forgotten your password?Amending an Employee's Surname

Glossary of Terms (Pre 2019)

English Cantonese Czech Hungarian Latvian Lithuanian Mandarin Polish Portuguese Romanian Russian

Revenue - Contact Telephone Numbers Transferring Payroll Manager from one PC to another

Transferring Payroll Manager using a backup file Transferring Payroll Manager using the installation folder

Thesaurus Connect

Thesaurus Connect - Overview Registering for Thesaurus Connect Connecting an Employer to Thesaurus Connect Customising your Thesaurus Connect Account Assigning a New User in Thesaurus Connect Editing/Deleting a User from Thesaurus 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 Thesaurus Connect Restoring from a Thesaurus Connect Backup Employer Self Service PortalEmployee Self Service PortalRegistering for Thesaurus Connect (Traditional Method)

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

End User Licence Agreement for Thesaurus Payroll Manager