The PEBT Payroll Interface Reconciliation generates a report detailing the difference between the PEBT Payroll Interface deduction amounts and the accumulated history deduction amounts taken. For each payroll id to be included, a range of history pay periods is defined. For each Benefit Type code in the PEBT Payroll Interface the corresponding deduction code (as defined by the Benefit Type code data base) history values are accumulated, per employee. The Benefit Type values is compared to the history values taken and the difference is reported. The totals on this report include all entries, even those entries suppressed when the difference is zero.
The PEBT Payroll interface file, report detailing the values from the PEBT Payroll interface file, BAMPYRLxxx.TXT , where xxx is are an internal number generated by Morneau. This file can be stored at the location defined by the Location of PEBT Import Files field of the PEBT Profile or by default the system will look at the location defined by the logical SRB$Export.
Enter District Number for File Name
-
Enter the two-digit district number for the import file name to be accessed. By default, the district number as defined under the Human Resources Master Profile will display.
Enter Name of PEBT Payroll File
-
Enter the full PEBT Payroll Interface file name. Automatically, all PEBT Payroll Interface files for the defined district number will be displayed, as shown below. You may scroll up and down to select the correct file. Use look-up to access the PEBT Payroll Interface file list.
Enter Payroll Location ID
-
Enter one or multiple payroll ID's along with the pay period range per payroll to be reported. All payroll ids selected must have the PEBT Profile defined and active.
Omit Reporting Balanced (zero) Details
-
Enter 'N' to include all details on the report.
-
Enter 'Y' to omit reporting deduction details per employee where there is no difference. The deduction amounts suppress on the report will still be reflected in the totals of the report.
The report lists the following:
-
The report header includes the PEBT Payroll Interface file used.
-
Payroll Id code
-
Employee number and name, B.A.G. and Employee Group Code
-
Deduction code, blank when no deduction can be determined
-
Benefit Type code and description
-
Employee deduction amount for range of pay periods per payroll
-
Employer deduction amount for range of pay periods per payroll
-
Taxable benefit portion for range of pay periods per payroll
-
PEBT import employee deduction amount
-
PEBT import employer deduction amount
-
PEBT import taxable portion
-
Difference of pay history amounts less PEBT import amount.
-
'R' – retro marker for onetime adjustments.
-
Total zeros, total details suppress when difference is zero, when applicable
-
Total number of entries reported and report totals
-
Total errors such as unknown employees, invalid numeric. Errors are included in the processing log.
-
File Trailer values, the totals as defined by the import file trailer record.
The report includes a Benefit Type Summary:
-
Payroll Id and Benefit Type code and description.
-
Totals for all categories compressed by payroll id and benefit type code.
-
Total Retro adjustment values per payroll and Benefit Type code