The Timesheet/Variable Deduction Export Process offers the ability to export out the Timesheets or Variable Deduction records from a selected batch into .CSV files. The .CSV export file is defined in the exact format as used by the Timesheet/Variable Deduction Interface Process.
Although batches of entries may be exported for many purposes, this process was generated to facilitate the moving of batch entries from one pay period to another. You can run this export and without transferring any files, run the Timesheet/Variable Deduction Interface using the location of SRB$OPSWRK: and the file name ######.CSV as supplied on the report header, to pull the entries into the another batch under the same or another pay period.
If necessary, the Excel icon can be used to open the CSV export file to adjust the entry values before importing them back into the payroll.
The Timesheet export includes the following fields:
-
Employee number
-
Entry Date
-
Pay code
-
Hours
-
Input rate
-
Cost Center code
-
GL account code
-
Function line number
-
Costing Distribution number
-
Occupation code
-
Shift code
-
Timesheet #
-
Salary Grid code
-
Position code
-
Employee name to right of data, not imported into timesheet but added for reference.
The Variable Deduction export includes the following fields:
-
Employee number
-
Date
-
Deduction code
-
Employee amount
-
Employer share
-
Eligible amount
-
Reason
-
Employee name to right of data, not imported into timesheet but added for reference.
Process Timesheets or Variable Deductions
Timesheets and Variable deduction must be exported separately as the entries must be imported separately in different formats.
-
Enter 'T' to export Timesheet Entry entries.
-
Enter 'V' to export Variable Deductions entries.
Enter Batch Code to Export
-
Enter a batch code to determine the timesheets or variables deduction entries to be exported.
Report All or Selected Employees
Include Generation of CSV Export File
-
Enter 'Y' to generate a CSV files containing the batch entries. The CSV file location and name is included on the header of the report.
-
Enter 'N' when the CSV export file is not required.
The Timesheet Entry report lists the following:
-
Timesheet # or SUSP on suspended entries
-
Date of the entry
-
Employee number and name
-
Shift code
-
Occupation code
-
Pay code and description
-
Timesheet hours
-
Input rate, includes premiums
-
Total premium amount
-
Total gross earnings
-
GL Account used
The Variable Deduction process report lists the following:
-
Override setting
-
Entry date
-
Employee number and name
-
Deduction code and description
-
Employee's variable deduction amount
-
Employer's amount
-
Employee's eligible amount
-
Reason for the variable deduction