T4/T4A Merge Summary and Total Reporting

The T4/T4A Merge Summary and Total Reporting is used for extracting existing merged T4/T4A values to be used in balancing of the merged T4 and T4As.

The Total option will generate just the grand totals per numeric box for the T4 or T4A selected.

The Summary option will create an extract with one line per employee summary of only the numerically defined fields. Profile items with no mask definition are omitted as non-numeric. The size of the numeric fields on the printed report is taken from the mask definition in the Tax Forms Parameters. The header and control totals information is also included. The Summary option is intended to allow review of the T4/T4A results in a column format to check for accurate results before proceeding with the statements.

When T4 Summary is selected, all Other fields are produced for each employee even if the employee does not have a value for the applicable Other set. You may want to use one of the Alternate tax form profile for generation of the summary information to control what information is included. Using the Alternate tax form profile will allow you to change the profile print parameters, for example omitting the 'BLANK' without affecting your true tax form profile.

This menu option does not generate the T4/T4A print, email or work files.

When output to disk is selected on a Summary or Total Only generation, the results will be generated at your default directory under the file ######.LST, where ###### is the job number.

This report includes the automatic generation of the export file, ######.CSV, where ###### is the job number. The export file is generated where the logical ATRIEVEERP$OPSWRK is defined and is available to be emailed from the Payroll Email File Process. All fields within the export file have any extra spaces removed from the front and back of the fields and all fields are separated by a comma.

The export file includes the following fields:

Header detailing column content.

RP Number

Employee number

Employee name

Employee SIN

Numeric T4/T4A values defined per profile

Column Totals, formula to total each numeric column

Report Totals per numeric column, fixed values as defined on the report

The Total export option contains the header and Report Total line only.

Print T4 or T4A

Process 'T4' entries.
Process 'T4A' entries.

Enter The RP Number To Process

Enter the RP number to process. The RP number entered must be defined under the Employer Constants (field Payroll Account Number) for the current payroll. The Employer Constant match then determines the tax group being used for the current payroll.

Enter Taxation Year

Enter the applicable four digit taxation year.

Print Summary Or Totals Only

Enter 'S' to create a one line per employee summary.
Enter 'T' to only produce the control totals for the T4/T4A's.

When report 'S'ummary was selected the next prompt will appear:

Include Employee Names on Summary

This prompt only applies to the printed report, the extract always includes the employee's name.

Enter 'N' to omit the employee names on the summary reporting.
Enter 'Y' to include the employee names on the summary reporting.

Sort By Employee #/Name/Location

Enter 'E' to sort by employee number.
Enter 'N' to sort by employee name.
Enter 'L' to sort by employee location.

When sort by 'L'ocation was selected:

Sort by Employee # or Name within Location

Enter 'E' to sort by employee number within location.
Enter 'N' to sort by employee name within location.

Use Regular or Alternate Profile

Enter 'R' to process the Totals or Summary using the regular tax form profile.
Enter 'A' to generate the Totals or Summary using the alternate tax form profile.

The use of the alternate tax form profile is intended to allow the generation of Summary information using a different set of print criteria without affecting the true tax form profile settings.
When 'A'lternate Profile was selected:

Enter Alternate Profile Code

Enter a letter from A to E to determine which alternate profile is to be used.

The report lists the following:

Employee number
Employee name, if applicable
One column per numerical value defined in profile
Total per numerical column