Contents
1 Payroll Year-End Processing Overview
2 Year-End Processing Checklist
3 Working with Rollovers
4 Working with Employment Insurance History Integrity
- Verifying Employment Insurance History Integrity
- Revising Employment Insurance History
- Working with Employment Insurance Hour Integrity
5 Reposting Historical Information
- Reposting Tax Area Information
- Reposting Tax Ledger Information
- Reposting Pay Types to the Payroll Month
- Reposting DBAs to the Payroll Month
- Reposting DBAs to the Calendar Month
- Reposting DBAs to the Fiscal and Anniversary History Summary
- Reposting the Workers Compensation Summary
- Updating Tax Records to Avoid Multiple T4s
- Before You Begin
- To Repost the Tax ID
- To Update the Tax ID in the Taxation Summary History by Province Table
- To Update the Tax ID in the Payroll Month PDBA Summary History Table
- To Update the Tax ID in the Calendar Month DBA Summary History Table
- To Update the Tax ID in the Tax Area Transaction Summary History Table
6 Year-End Setup
- Verifying Employee Names and Addresses
- Setting up Native Indian Employees
- Verifying Company Information
- Verifying User Defined Codes
- Verifying Pension Plan Numbers
- Verifying Special Handling Pay Codes
- Verifying Province of Employment
- Verifying T4 and T4A Other Information Codes
- Verifying T4 Employment Codes
- Verifying RL-1 Case O Codes
- Verifying RL-2 Source of Income Codes
- Verifying Country Codes
- Setting Up the EI Reduced Rate
- Verifying Cheque Route Codes
- Setting Up Pension Records
- Working with Special Handling
- Setting up Non-Resident Secondary/Joint Information
- Setting Up Non-Resident Account Information
- Setting Up T4A Beneficiary/Dependent Information
- Setting Up Integrated File System (IFS) Directories
7 Workfile Setup
8 Year-End Review
- Reviewing Year-End Information
- Reviewing Year-End Reports
- Reviewing the XML Integrity Reports
- Revising Year-End Information
- Resetting Year-End Workfile Versions
9 Year-End Reporting
- Printing Year-End Forms
- Creating the XML File
- Transferring and Submitting the XML Workfile
10 Year-End Archiving
11 System Table Overview
- Control Table
- Permanent Tables
- F07727 - Canadian Pension Information File
- F07730 - T4 Archival File
- F07731 - Relevé 1 (Provincial) Archival File
- F07732 - T4A Archival File
- F07733 - Relevé 2 Archival File
- F07734 - NR4 Archival File
- F07740 - T4 Adjustments Archival File
- F07741 - Relevé 1 Adjustment Archival File
- F07742 - T4A Adjustment Archival File
- F07743 - Relevé 2 Adjustment Archival File
- F07744 - NR4 Adjustment Archival File
- Workfile Tables
- T07730 - T4 Workfile
- T07731 - Relevé 1 Workfile
- T07732 - T4A Workfile
- T07733 - Relevé 2 Workfile
- T07734 - NR4 Workfile
- T07740 - T4 Adjustments Workfile
- T07741 - Relevé 1 Adjustment Workfile
- T07742 - T4A Adjustment Workfile
- T07743 - Relevé 2 Adjustment Workfile
- T07744 - NR4 Adjustment Workfile
- T07760X - T4 XML File
- T07765X - T4A XML File
- T07770X - Relevé 1 XML File
- T07775X - Relevé 2 XML File
- T07761 - T4 XML Audit File
- T07766 - T4A XML Audit File
- T07771 - Relevé 1 XML Audit File
- T07776 - Relevé 2 XML Audit File
12 Sample Forms
- T4 - Statement of Remuneration Paid
- T4A - Statement of Pension, Retirement, Annuity and Other Income
- Relevé 1 - Revenus d'emploi et revenus divers (Provincial Wage and Income Earnings Statement)
- Relevé 2 - Revenus de retraite et rentes (Provincial Pension, Retirement and Annuity Statement)
- NR4 - Statement of Amounts Paid or Credited to Non-Residents of Canada
13 Information Sources for Forms
14 Frequently Asked Questions
15 Processing Options
- Repost DBAs to Fiscal and Anniversary (P06147A)
- Employment Insurance History Rev. (P06176)
- Calendar Month Rollover (P063913)
- Special Handling Code Table (P067204)
- Assign Special Handling Code Tables (P067203)
- Repost DBAs to Calendar Month F06145 (P07145)
- Repost DBAs to Payroll Month F06146 (P07146)
- Repost Pay Types to Payroll Month F06146 (P071461)
- Repost DBAs to Tax Area Summary F06148 (P07148)
- EI Integrity Validation (P077015)
- EI Hour Integrity Report (P077020)
- Payroll Month PDBAs Integrity (F06146) (P077021)
- T4/Relevé Workfiles Version Review (P07725)
- Assign Special Handling Code Tables (P077206)
- Pension Batch Update (P077271)
- Calendar Month DBAs Integrity (F06145) (P077031)
- T4 Summary Report (P07746)
- T4A Summary Report (P07747)
- Relevé 1 Summary Report (P07748)
- Relevé 2 Summary Report (P07749)
- NR4 Summary Report (P07750)
- T4 XML and Audit File Build (P07760X)
- T4 XML Audit Report (P07761X)
- T4A XML and Audit File Build (P07765X)
- T4A XML Audit Report (P07766X)
- Canada Laser Forms - Employee Copies (P07770A)
- Canada Forms Alignment - Employer copy (P07770C)
- Relevé 1 XML and Audit File Build (P07770X)
- Taxation History Integrity (F0713) (P077011)
- Relevé 1 XML Audit Report (P07771X)
- Relevé 2 XML and Audit File Build (P07775X)
- Relevé 2 XML Audit Report (P07776X)
- Repost Tax ID to Tax Ledger F0716 (P07990)
- T4 Print Special Forms (P077321)