Full periodic CSV Import

 

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.

GeneralGlossary of TermsPayroll DeductionsGetting startedImporting from previous yearCompanyAdd/ Amend EmployeesNotifying ROS of new employeesProcessing PayrollBank FilesReportsP30sProcessing LeaversBenefit in KindIllness BenefitMaternity BenefitPaternity BenefitPensionsReversing the PayrollBackup and RestoreYear endCSOHolidaysLeave EntitlementsLegalTransferring Payroll Manager from one PC to anotherThesaurus ConnectGDPR