Microsoft Dynamics GP Year End Release 2013: Canadian Payroll Year End Close

  • Comments 2

I have included below, some tips to help you with the year end process in Canadian Payroll. Please note the 2013 Canadian Year-End file has not been released just yet.  
This is targeted to release the week ending December 16, 2013.

Keep checking back to the Year-End Schedule post for up to date information.

Here is what will be changing related to the Year End Update for Canadian Payroll:
***At this time, there are no required table changes needed for the update***

T4, T4A and RL-1 XML changes
No T4 or T4A form changes

2013 Bulk ROE format changes released by Rev Canada
- Blocks 10, 11 & 12 have had their date format changed
- Block 15C now needs to be blank
- Zero Pay Periods now have to be blank
-XML file format

Tax Changes for 2014
- Canada Employment Insurance (EI)
- Canada Pension Plan (CPP)
- Canada Income Tax
- British Columbia
- New Brunswick
- Newfoundland and Labrador
- Northwest Territories
- Nunavut
- Ontario
- QPIP Tax
- QPP Tax
- Quebec Provincial tax
- Saskatchewan
- Yukon

What steps should I take to close the year?
1.Complete all the pay runs for the current year.
2.Complete any necessary 2013 Payroll reports.
3.Make a backup of the data.
4.Install the 2013 Canadian Payroll Year-End Update/2014 Tax Update.
5.Complete the "Year End File Reset" process.
6.Make a backup of the data.
7.Create the T4, T4A, and RL-1 statements, and print the T4, T4A, and RL-1 reports.
8.Edit the T4, T4A, and RL-1 records as necessary.
9.Create T4, T4A, and RL-1 Summary records.
10.Print the T4, T4A, RL-1 reports and create T4, T4A and RL-1 XML file, if appropriate.
11.Verify that the Pay periods for 2014 are setup correctly.

Key Points to remember:

1.When you do the year end close it moves all your current year data into the Last Year (LY) tables and it doesn't take the date into consideration. For this reason it is very important that you complete ALL 2013 Payrolls (step 1) and then complete at least through the year end file reset (step 5) before doing any 2014 payrolls.
2.It is vital to do your install before the Year End Reset (Steps 4 and 5) because you are prompted during the Year End Reset to update Basic Personal Amounts. If you miss this you will need to restore from a backup.
3.When you do the year end file reset it changes the Basic Personal Amounts for employees. Depending on the Province it will either add a fixed amount or increase the amount by an indexation factor as determined by the Provincial Authority.
4.The 2013 Quebec Software number is not yet available but when it is issued you can find it on the Year End Release found in the Resources below.
5.Be sure to make backups when indicated in the complete steps.

Assistance for Canadian Payroll Year End Close:

Microsoft Dynamics GP Blog -
Microsoft Dynamics Community -
Microsoft Dynamics Support -


Year-end closing procedure for the Canadian Payroll module in Microsoft Dynamics GP:

Partner Download:


Customer Download:


Back by popular demand...Microsoft Dynamics GP Year-End Closing Blog Series for 2013!

Be sure to check back to the Year-End Schedule post for current posted blogs and upcoming blog posts related to Year-End Closing for Dynamics GP.

Good luck and have a great Year-End 2013!

Warmest Regards,

Deseree Krumm | Microsoft Dynamics GP Support | Senior Support Engineer

  • Too bad the release wasnt until the 20th of december...leaving many customers struggling to run payroll and get the updates installed

  • I apologize for the timing Tami but unfortunately we are at the mercy of the CRA when they release the changes to software providers.  We do our best to have the most diligent turnaround to you, so you can proceed with the update in a timely fashion.