T4/T4A Summary and Total Reporting
The T4/T4A Summary and Total Reporting is used for generating T4/T4A values to be used in pre balancing of the T4 and T4As. The Total option will generate just the grand totals per numeric box for the T4 or T4A run to be balanced against the payroll history. The Summary option will create a one line per employee summary of only the numerically defined fields. Profile items with no mask definition are omitted as nonnumeric. The size of the numeric fields is taken from the definition in the Tax Forms Parameters. The header and control totals information are 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 printing statements. If T4 Summary Extraction 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 print parameters, for example omitting the 'BLANK' without affecting your true tax form profile.
NOTE: This T4/T4A Summary and Total report follows the same process as the T4/T4A run and will also report a summary of any negative box values that will be omitted by the T4/T4A Generation process.
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.
Payroll ID code
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 Tax Group To Process [6/7/8]
Only tax groups 6, 7 or 8 can be chosen.
These tax groups correspond with the profiles created in Tax Forms Format Parameters as well as the group used when defining the income tax deduction. The tax group must also correspond to the Group defined on the applicable income tax deduction code.
Enter Taxation Year [YYYY]
Enter the applicable four digit taxation year.
Print Summary Or Totals Only [S/T]
- Enter 'S' to create a one line per employee summary.
- Enter 'T' to only produce the control totals for the T4/T4A's.
Report on Year To Date History or Existing T4 Slips [Y/E]
- Enter 'Y' to produce the Total or Summary based on information from the employee's YTD history.
- Enter 'E' to produce the Total or Summary based on previously generated T4/T4A slip information.
When report on ‘Y’td history was selected the next two prompts appear:
Enter Start Period [YYYYPP]
Enter the starting pay period for a range of periods of information to include. The first pay period for the tax year entered, as defined in the payroll calendar, will be displayed by default.
Enter End Period [YYYYPP]
Enter the ending pay period of the pay period range. The last pay period for the tax year entered, as defined in the payroll calendar, will be displayed by default.
Select By Income Tax Deduction Code
Selection by tax code is only required when more than one T4 or T4A tax code exists per payroll.
Enter <Enter> when only one tax group exists for this payroll. Leave this prompt blank on a T4A run when only one T4A deduction exists on this payroll.
Enter the income tax deduction code number that corresponds to the tax group to be processed. This deduction code selection combined with the tax group selection allows you to produce T4/T4A's for each of your tax groups when more than one tax group is used in a specific payroll.
Entering a tax deduction number here will also specify the Pension Adjustment record for the specified taxation year. When the tax deduction code is not entered, the pension adjustment amount will be taken from the first record for the employee for the specified taxation year.
The T4 program has been designed to look at each employee's history period record to determine the tax code used in that historical period. Historical periods that include the specified tax code will be included in the accumulation of values for the T4 run. When a historical period does not include a tax code, that period's values are included with the last tax code that was found.
When report 'S'ummary was selected the next three prompts will appear:
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.
Include Employee Names On Summary
Enter 'N' to omit the employee names on the summary reporting.
Enter 'Y' to include the employee names on the summary reporting.
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.
When T4 entries are being processed:
The current settings of the Maximum CPP and Maximum EI values, as per the selected T4 Tax profile are displayed to allow a visual verification of the correct value per taxation year.
Accept to continue or Cancel to exit and adjust the applicable T4 Tax profile.
The report lists the following:
- Employee number
- Employee name, if applicable
- One column per numerical value defined in profile
- Total per numerical column