Atrieve Payroll

Payroll T4 Processing Checklist

Pro-Tip!  Copy this checklist to Excel to create your own customizable copy.


PAYROLL T4 PROCESSING CHECKLIST:







(These are your internal T4 processing recommended guidelines.  Please update and maintain annually.)


(List your specific payroll IDs here)


PHASE

MENU

PROCEDURES


Step # in T4 Procedure Guide

TEAC

TTOC/ SUBS

SUPP

CASU




**Reminder - atrieveERP offers Parsing Service, place Support request








Setup

Payroll Employee Reporting > Invalid SIN / Birth Date Report

Invalid SIN Report








Setup

Payroll Demographics > Employee Changes

Correct Invalid SIN in Employee Changes








Setup

Payroll System Maintenance > Payroll Database Maintenance > Employer Constants

Employer Constants Database - review


1






Setup


Tech Contact


1






Setup


Transmitter Number


1






Setup

Payroll Demographics > Employee Changes

Edit T4 Statement field - Employee Changes


3






Setup

Payroll Demogrphics > Email Statement Field Changes

Employee Email T4 Statement Changes - global T4 statement change


3






Setup

T4/T4A Processing > T4/T4A Tax Forms Format Profile

T4 Tax Forms Format Profile


2






Balancing

T4/T4A Processing > T4/T4A Pre Validation Reporting

T4 Pre Validation Reporting


4






Balancing

T4/T4A Processing > T4/T4A Pre Validation Reporting

T4 Eligible Tax Reconciliation


5






Balancing

Payroll Employee Reporting > YTD Payroll Register 

YTD Payroll Register Report in 'S'ummary


6






Balancing

T4/T4A Processing > T4 Summary and Total Reporting

T4 Summary & Total Reporting - select TOTALS and YTD History


6






Balancing

T4/T4A Processing > T4/T4A Tax Forms Format Profile

Set up Balancing Alternate Profile (if required)


6






Balancing

T4/T4A Processing > T4 Summary and Total Reporting

Re-run T4 Totalling in Alternate Profile (if required)


6
















Pension Adustments

T4/T4A Processing > T4/T4A Pension Adjustment > Pension Adjustment Calculation Profile

Pension Adjustment Calculation Profile - review


7






Pension Adustments

T4/T4A Processing > T4/T4A Pension Adjustment > Pension Adjustment Calculation Process

Pension Adjustment Process - run


7






Pension Adustments

T4/T4A Processing > T4/T4A Pension Adjustment > Pension Adjustment Export (Import) Process

Pension Adjustment Export / Import (only if required)


7






Pension Adustments

T4/T4A Processing > T4/T4A Pension Adjustment > BC Pension Adjustment Upload

BC Pension Adjustment Upload (our BC customers only)


7






Pension Adustments


Non-Teacher Pension PA Calculation Verification


7






Pension Adustments


Teacher Pension PA Calculation Verification


7






Pension Adustments

T4/T4A Processing > T4/T4A Pension Adjustment > Pension Adjustment Changes

Pension Adjustment Changes (or additions if required)


7






Pension Adustments

T4/T4A Processing > T4/T4A Pension Adjustment > Pension Adjustment Report

Pension Adjustment Report (optional)


7
















T4 Processing

T4/T4A Processing > T4 Statement Creation

T4 Statement Creation


8






T4 Processing

T4/T4A Processing > T4 Statement Print

Test Print T4


8






T4 Processing

T4/T4A Processing > Build PDF / Email T4/T4A Statements

Test Email T4-Notification


8






T4 Processing

Payroll System Maintenance > Payroll Profile Maintenance > Global System Parameters > Global E-Mail Profile

Global Email Profile (Edit - if required)


15






T4 Processing

T4/T4A Processing > T4/T4A Tax Forms Format Profile

T4 Tax Forms Format Profile - adjustments if necessary








T4 Processing

T4/T4A Processing > T4 Statement Creation

Create T4 file again (caution - ONLY IF NECESSARY)


8






T4 Processing

T4/T4A Processing > T4/T4A Statement Maintenance

T4 Statement Maintenance


9






T4 Processing

T4/T4A Processing > T4/T4A Statement Regeneration

T4 Statement Regeneration


10
















T4 Merge (optional)

T4/T4A Processing > T4/T4A Merge Creation

T4 Merge Creation (if you decide to merge your T4s)


11






T4 Merge (optional)

T4/T4A Processing > T4/T4A Statement Maintenance

T4 Statement Maintenance (if required) select 'M'erged T4 for changes


12






T4 Merge (optional)

T4/T4A Processing > T4/T4A Merge Regeneration

T4 Merge Regeneration (if required)


13
















Distribution

T4/T4A Processing > T4 Statement Print

T4 Final Test Print


14






Distribution

T4/T4A Processing > T4 Statement Print

T4 Statement Print - final copies


14






Distribution


EPrint T4


14






Distribution

Payroll System Maintenance > Payroll Profile Maintenance > Global System Parameters > Global E-Mail Profile

Edit Global Email Profile (if required)


15






Distribution

T4/T4A Processing > Build PDF / Email T4/T4A Statements

Build PDF/Email T4 Statements and Web Notification - TEST


15






Distribution

T4/T4A Processing > Build PDF / Email T4/T4A Statements

Final distribution Build PDF/Email T4 Statements or Web Notification


15
















CRA Submission

T4/T4A Processing > T4/T4A XML File Creation

T4 XML File Creation


16






CRA Submission


Parse XML files (ensure signed quote returned to atrieve if required)


17






CRA Submission


Submit XML files to CRA using secure web site page


18








 








Amending


Amending T4s - only if required


19
















                     T4 SUMMARY VALUES FOR T4 BALANCING:



(List your specific tax groups here)





RP0001


GROUP?

GROUP?

GROUP?

GROUP?





RP0002


GROUP?

GROUP?

GROUP?

GROUP?





RP0003


GROUP?

GROUP?

GROUP?

GROUP?


CRA T4 Employer Guide


http://www.cra-arc.gc.ca/E/pub/tg/rc4120/rc4120-e.html


















Box Definitions


Box 14 – Employment income










Box 16 – Employee’s CPP










Box 18 – Employee’s EI premiums










Box 20 – RPP contributions










Box 22 – Income tax deducted










Box 24 – EI insurable earnings










Box 26 – CPP pensionable earnings










Box 28 – Exempt (CPP/QPP, EI, and PPIP)










Box 44 – Union dues










Box 50 – RPP or DPSP registration number










Box 52 – Pension adjustment









OTHER

Code 40 – Other taxable allowances and benefits

(edit to your applicable OTHER boxes)









Code ??










Code 77 – Workers’ compensation benefits repaid to employer










Code 85 – Employee-paid premiums for private health service plan










Code 57 - Employment Income March 15 to May 9










Code 58 - Employment Income May 10 to July 4










Code 59 - Employment Income July 5 to August 29










Code 60 - Employment Income August 30 to September 26





























NOTE:

Merged = 1 T4 per RP# & 1 XML file per RP#










Not Merged = 1 T4 per payroll & 1 XML file per Payroll per RP#