Auto-renewal for 2025 licences is now in process, and we’re experiencing higher-than-usual wait times on our phone lines. For FAQs, visit this link.

Full periodic CSV Import

 

To access this utility go to Utilities > Full Periodic CSV Import 

 

The file spec

Works No, Standard - Hours, Time & 1/2 - Hours, Double Time - Hours, Time & 1/3 - Hours, Hourly Rate, Other Overtime, Basic Pay, Holiday Pay, Unpaid Weeks, Taxable Addition 1, Taxable Addition 2, Taxable Addition 3, Taxable Addition 4, Non Taxable Addition 1, Non Taxable Addition 2, Non Taxable Addition 3, Non Taxable Addition 4, Pension, Allowable Deduction 2, Allowable Deduction 3, Allowable Deduction 4, Non Allowable Deduction 1, Non Allowable Deduction 2, Non Allowable Deduction 3, Non Allowable Deduction 4

 

e.g.

0001,40,0,2,0,15.50,0,0,575.35,,,,,,50,,,,,,,,

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 employee payroll record will be updated with all hours, additions and deductions as per the import file.

  

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

HelpYear End 20222023 Thesaurus Payroll Manager - System RequirementsSigning into Connect for 20232023 Budget - Employer Summary2023 Payroll Manager - AvailabilityStarting the New Tax YearImporting from the previous yearMoving to Thesaurus Payroll Manager from another softwareGetting started - First Time UsersCompany SetupDigital CertificatesAdd/ Amend EmployeesRevenue Payroll Notifications (RPNs)Payroll CalendarProcessing PayrollPayroll DeductionsPayroll Submission Requests (PSRs)Distributing PayslipsPaying EmployeesCorrectionsRevenue PaymentsRevenue - Contact Telephone NumbersReportsProcessing StartersProcessing LeaversBenefit in KindStatutory Sick Pay (SSP)Illness BenefitParenting BenefitsPensionsChanging an Employee's Pay FrequencyPayroll JournalsBackup and RestoreTransferring Payroll Manager from one PC to anotherCSOHolidaysLeave EntitlementsEmployment LawGeneralGlossary of Terms (Pre 2019)Thesaurus ConnectGDPRLicence Agreement for Thesaurus Payroll ManagerBright ID