Navigate Year-End Payroll with Dynamics GP: A Canadian Closing Guide

Table of Contents

Successfully completing year-end payroll is a critical process for any Canadian organization utilizing Microsoft Dynamics GP. This comprehensive guide outlines the recommended procedures for the integrated Canadian Payroll module, ensuring a smooth transition into the new fiscal year. Adhering to these steps is essential for compliance, accurate reporting, and minimizing potential errors.

The information provided here applies specifically to Microsoft Dynamics GP, drawing upon established best practices. It is imperative to read through this entire article before initiating any of the outlined procedures to gain a complete understanding of the workflow. Should any questions arise during the process, consulting Microsoft Dynamics Technical Support is highly recommended.

Important Considerations Before You Begin:

Before commencing your year-end payroll closing, several crucial points require your attention. This preparation will help safeguard your data and ensure the integrity of your financial records. A proactive approach will prevent common pitfalls and facilitate a more efficient closing process.

Always ensure you possess a complete, verified backup copy of your database before undertaking any of these steps. This backup acts as a safety net, allowing for quick data recovery if any unforeseen issues or power fluctuations occur during the year-end closing procedure. Protecting your financial data is paramount during this critical period.

The year-end update for Canadian Payroll typically incorporates essential tax updates and changes to reporting forms. This update is vital for ensuring your system is compliant with the latest regulatory requirements. Once released, you can download the necessary files to prepare your system for the year-end processes.

Payroll Year-End Closing Checklist¶

The following checklist details the systematic steps required to complete the year-end closing procedures for Microsoft Dynamics GP Canadian Payroll. Each step builds upon the previous one, forming a coherent workflow. Following this sequence carefully will help maintain data accuracy and streamline your year-end tasks.

Step	Description
1	Complete all pay runs for the current year.
2	Complete any necessary payroll reports.
3	Make a backup of the data (Pre-update).
4	Install the Canadian year-end update.
5	Complete the Year End File Reset process.
6	Make another backup of the data (Post-reset).
7	Create T4, T4A, and RL-1 statements and print reports.
8	Edit T4, T4A, and RL-1 records as necessary.
9	Create T4, T4A, and RL-1 Summary records.
10	Print final T4, T4A, RL-1 reports and create XML files.
11	Verify pay periods are set correctly for the new year.

1. Complete All Pay Runs for the Current Year¶

The initial and most fundamental step is to ensure that all pay runs pertaining to the current calendar year have been fully processed. This includes all regular payrolls, as well as any special runs for bonuses, adjustments, or final payments. Verifying the completion of all pay runs guarantees that all employee earnings and deductions are accurately recorded for the year. An incomplete record at this stage will inevitably lead to discrepancies in year-end statements.

2. Complete Any Necessary Payroll Reports¶

Before proceeding with the official year-end closing, generate and review any internal payroll reports deemed necessary for your organization. These reports might include gross-to-net reports, payroll tax summaries, or departmental expense breakdowns. Completing these reports at this stage provides an opportunity to reconcile figures and identify any potential inconsistencies before formal statements are produced. This also serves as a final internal audit of your payroll data for the year.

3. Make a Backup of the Data (Pre-update)¶

Creating a comprehensive backup of your data is a critical safeguard before installing any updates. This backup provides a secure, permanent snapshot of your company’s financial standing at the close of the year, prior to any system modifications. Should any issues arise during the update installation or subsequent processes, you can restore your system to this stable state without significant data loss. This backup should be stored in a safe, permanent location, clearly labeled, for future reference.

To create this backup within Microsoft Dynamics GP, navigate to Maintenance on the Microsoft Dynamics GP menu, then select Backup. In the Company Name list, carefully select the correct company. You may choose to change the default path for the backup file to a preferred secure location before selecting OK to initiate the backup process. It is highly recommended to name this specific backup “Pre Year-End Tax Update” to easily distinguish it from other backups you might have.

4. Install the Canadian Year-End Update¶

The Canadian year-end update is a mandatory installation that incorporates the latest tax changes, updated forms, and any regulatory adjustments required by federal and provincial authorities. This update ensures that your Microsoft Dynamics GP system is compliant for the upcoming tax year and can accurately generate year-end statements. Installing this update at the appropriate time, after all current year pay runs but before any new year payroll, is crucial for data integrity. The update files can typically be downloaded from the official Microsoft Dynamics GP support portal.

5. Complete the Year End File Reset Process¶

The Year End File Reset process is a pivotal step that prepares your payroll module for the new year while preserving historical data. This routine handles the transition of current year data into historical records, allowing for prior-year inquiries. It also updates critical tax-related information for the coming year.

To perform a year-end file reset, first ensure all users have closed all Canadian Payroll windows in Microsoft Dynamics GP. Users may continue working in other Dynamics GP modules if needed. Access the routine by pointing to Tools on the Microsoft Dynamics GP menu, then Routines > Payroll - Canada, and finally selecting Year End File Reset.

Within the Payroll Reset Files window, begin by selecting Copy Files to History. This action is essential as it generates the necessary data for viewing previous year inquiries within Canadian Payroll, which can be accessed later via Inquiry menu > Payroll Canada > Employee Last Year Information. Be aware that this step requires significant disk space, often twice the amount currently used by your data and project directories, so confirm availability.

Next, select Tax Credit Indexation Factors. In the subsequent window, verify the basic personal factor, often referred to as the Cost of Living Factor, against the Canada Customs and Revenue Agency document T4127. After confirming the accuracy of these numbers, select OK. It is important to note that these TD1 Basic Personal amounts should typically update automatically after installing the Canadian Payroll Year-End Update file; however, verification is still recommended.

Proceed to select Reset Employee Master. This process is vital for adjusting employee TD1 Basic Personal amounts based on the new indexation factors and must be run before processing any pay runs for the new year. When prompted to reset the Employee User Numeric fields, choose Yes or No according to your company’s preference. You can later review these fields by navigating to the Cards menu, pointing to Payroll-Canada, and selecting Employee, then entering an Employee ID, choosing Miscellaneous, and finally User Data. It is critically important that if any errors occur during this Year-End Reset process, you immediately restore from your pre-reset backup to prevent data corruption.

6. Make Another Backup of the Data (Post-reset)¶

After successfully completing the Year End File Reset process, it is imperative to create another complete backup of your data. This backup serves as a new baseline, representing your company’s payroll data after all year-end updates and resets have been applied. It is a crucial point for recovery should any issues arise during the subsequent steps of generating tax forms. This backup, like the previous one, should be placed into safe, permanent storage.

To create this post-reset backup, follow the same steps as before: In Microsoft Dynamics GP, select Maintenance on the Microsoft Dynamics GP menu, and then select Backup. From the Company Name list, choose your company. Adjust the backup file path if necessary, then select OK. To clearly distinguish this from your earlier backup, name this one “Post Year-End Tax Update.”

7. Create the T4, T4A, and RL-1 Statements, and Print the T4, T4A, and RL-1 Reports¶

This stage involves generating the initial versions of your year-end tax statements and verification reports. These reports are crucial for reviewing and confirming the accuracy of all payroll figures before final submission. This process is divided into creating and printing T4 and RL-1 reports, followed by T4A reports.

Creating and Printing T4 and RL-1 Reports:
To begin, navigate in Microsoft Dynamics GP to Tools on the Microsoft Dynamics GP menu, then point to Routines > Payroll - Canada, and select T4 and R1 Creation. From this window, select Create T4’s and then Create R1’s to generate the initial statements. For verification, select Print T4 Report and Print R1 Report to produce the respective verification reports. After completing these steps, select OK to exit. Further detailed review can be done by printing the T4 Edit List; access this via Reports menu > Payroll-Canada > Routines > Routines Reports, then select T4 Edit Report.

Creating and Printing T4A Reports:
For T4A reports, go to Tools on the Microsoft Dynamics GP menu, then point to Routines > Payroll - Canada > T4A Routines, and select T4A Setup. From here, select Create T4A’s to generate the statements. To print the T4A Verification Report, select Print T4A Report. These verification reports are indispensable for identifying and rectifying any potential errors early in the process.

8. Edit the T4, T4A, and RL-1 Records as Necessary¶

After generating the initial T4, T4A, and RL-1 statements and their corresponding edit lists or verification reports, a thorough review is essential. It is common to find minor discrepancies or omissions that require manual adjustment. Microsoft Dynamics GP provides dedicated windows for editing these records to ensure their accuracy before final submission.

Modifying T4 Statements:
To make any necessary modifications to your T4 statements, navigate in Microsoft Dynamics GP to Tools on the Microsoft Dynamics GP menu, then point to Routines > Payroll - Canada, and select T4 Edit. This window allows you to review and adjust individual T4 records as identified during your verification process.

Modifying T4A Statements:
For editing T4A statements, access Tools on the Microsoft Dynamics GP menu, then point to Routines > Payroll - Canada > T4A Routines, and select T4A Record Edit. This interface provides the functionality to correct any inaccuracies found in the T4A records.

Modifying RL-1 Amounts:
To modify RL-1 amounts based on your edit list, go to Tools on the Microsoft Dynamics GP menu, then point to Routines > Payroll - Canada, and select R1 Edit. This window enables you to make precise adjustments to ensure your RL-1 reports are compliant with Quebec provincial requirements. Careful editing at this stage prevents delays and penalties associated with incorrect filings.

9. Create T4, T4A, and RL-1 Summary Records¶

Once individual T4, T4A, and RL-1 records have been created and edited to ensure accuracy, the next step is to generate their corresponding summary records. These summary records aggregate the data from individual slips, providing an overview that is often required for reporting to government agencies. They consolidate all figures into a concise format, which is essential for final verification and submission.

Creating Summary Information for T4 and RL-1 Reports:
To create the summary information for your T4 and RL-1 reports, navigate in Microsoft Dynamics GP to Tools on the Microsoft Dynamics GP menu, then point to Routines > Payroll - Canada, and select T4 and R1 Summary. Within this window, select Create T4 Summary Records and then Create R1 Summary Records. This action compiles the aggregated data needed for official summary filings.

Creating Summary Information for T4A Reports:
For T4A summary information, access Tools on the Microsoft Dynamics GP menu, then point to Routines > Payroll - Canada > T4A Routines, and select T4A Summary. From here, select Create T4A Summary Records. This will generate the necessary consolidated data for your T4A reporting requirements.

10. Print the T4, T4A, RL-1 Reports and Create T4, T4A and RL-1 XML Files, If Appropriate¶

The final stage of year-end reporting involves printing the official T4, T4A, and RL-1 reports for distribution to employees and for your records, as well as generating electronic (XML) files for submission to the respective government agencies. This step ensures compliance with both federal and provincial reporting mandates. Accuracy and proper formatting are paramount during this final output phase.

Printing Final T4 Reports:
To print the final T4 reports, navigate in Microsoft Dynamics GP to Tools on the Microsoft Dynamics GP menu, then point to Routines > Payroll - Canada, and select T4 and R1 Print. In the Employer Number field, select the appropriate employer. Then, select T4 Slip Type to choose the correct form. To print the individual T4 Statements, select T4 Slips, following any prompts for alignment tests. Additionally, select T4 Summary and T4 Segment to print these summary reports, noting they are not designed for pre-printed forms. To generate the electronic T4 file, select Electronic T4’s, complete the Payroll Electronic Transfer T4 window, and choose either Verify Only or Verify and Generate.

Printing RL-1 Reports:
For printing RL-1 reports, return to the T4 and R1 Print window via Tools > Routines > Payroll - Canada. Select the appropriate Employer Number. Choose R1 Slip Type and select Laser. To print individual R1 statements, select R1 Slips. To print the R1 Summary report, select R1 Summary; remember, this report is not for pre-printed forms. For electronic submission, select Electronic R1’s, complete the Payroll Electronic Transfer R1 window by entering all required fields, including the Software Developer Authorization Number, then choose Verify Only or Verify and Generate.

Printing T4A Reports:
To print T4A reports, go to Tools on the Microsoft Dynamics GP menu, then point to Routines > Payroll - Canada > T4A Routines, and select T4A Print. Select the correct Employer Number. For T4A Slip Type, choose either Laser Employee or Laser CCRA. For Microsoft Dynamics GP 2015 and higher, ensure you enter a value in the RL-1 Auth Number field (refer to the FAQ for more details). To print the T4A statements, select T4A Slips. You can also print T4A Segment and T4A Summary reports. Finally, to generate the electronic T4A files, select Electronic T4A’s, complete the Payroll Electronic Transfer T4A window, and choose either Verify Only or Verify and Generate.

11. Verify That Pay Periods Are Set Correctly¶

The final step in your year-end closing procedure is to confirm that the pay periods for the upcoming new year are accurately configured within Microsoft Dynamics GP. Incorrectly set pay periods can lead to errors in payroll processing from the very first run of the new year. This verification ensures that employees are paid on the correct schedule and that all associated calculations are aligned with your company’s payroll calendar.

To verify these settings, navigate in Microsoft Dynamics GP to Tools on the Microsoft Dynamics GP menu, then point to Setup > Payroll - Canada > Control, and finally select Frequency. Carefully review the displayed pay period frequencies and ensure they reflect your intended payroll schedule for the new year. Any discrepancies should be corrected immediately to prevent future payroll issues.

Frequently Asked Questions (FAQ)¶

Q1: When should I install the Year-End Update?¶

A1: The optimal time to install the year-end update is after all pay runs for the current year have been completed and verified. It is crucial to install the update and subsequently complete the Year-End File Reset process (Step 5 in the checklist) before initiating any pay runs for the new year. This sequence ensures that all basic personal amounts are updated, and the new tax codes included in the update are active and correctly applied for the upcoming payroll cycles. Following these steps precisely prevents discrepancies and ensures compliance from the first pay run of the new year.

Q2: What should I do if the Year-End Reset was done AFTER a pay run was made in the new year?¶

A2: If a pay run for the new year was processed before the Year-End Reset, corrective action is required to ensure data integrity and compliance. You must restore your system to a backup taken before the Year-End Reset was performed. After restoring, you will need to void the pay run that was made for the new year. Once the system is back to its pre-reset state and the incorrect pay run is voided, proceed to execute the Year-End Reset process as outlined in the checklist. This will correctly move the current year’s data to history and update all employee basic personal amounts with the new year’s indexation factors. Only then should you re-process the pay run for the new year. Be aware that the recalculated pay run may produce different amounts due to updated tax rates and employees potentially reaching different maximums based on the new year’s figures.

Q3: Why do I have to key in the RL-1 Auth Number?¶

A3: The RL-1 Auth Number field was introduced to the Payroll T4/R1 Print- Canada window as an editable field to streamline the year-end reporting process. Users are now required to manually enter the RL-1 Slip number in this designated field. This authorization number serves a vital purpose: it is used by Revenue Quebec to identify that the submitted forms originated from Microsoft Dynamics GP. This number is stored within a specific SQL table ([CPY20100]) on a per-year basis, ensuring its availability for any necessary reprints of the forms. Furthermore, any updates to the RL-1 Auth Number field will automatically adjust the Last Updated Date to the current system date, and the RL-1 Report (P_CPY_SETP_R1_Laser) has been modified to incorporate this new authorization number.

Q4: Why do the taxes calculated in Dynamics GP differ from the CRA online calculator? How are Income Taxes calculated in Canadian Payroll?¶

A4: Differences between tax calculations in Dynamics GP and the CRA online calculator can arise due to several factors. Dynamics GP uses a specific methodology and algorithms to compute income taxes based on the tax tables and parameters provided in the year-end updates. These calculations involve federal and provincial tax rates, personal tax credits (TD1 forms), and various deductions. The CRA online calculator, while accurate for general estimates, might simplify certain complex scenarios or use slightly different rounding rules.

Canadian Payroll in Dynamics GP calculates income taxes by first determining an employee’s total taxable earnings. It then applies the appropriate federal and provincial tax rates, considering all declared personal tax credits from their TD1 forms. Other statutory deductions, such as Canada Pension Plan (CPP) contributions and Employment Insurance (EI) premiums, are also factored into the overall tax calculation. The system often projects annual earnings and deductions to determine the correct marginal tax rate, aiming for accurate withholdings over the entire year. It is crucial to ensure that all employee information, including TD1 forms and provincial tax elections, is accurately maintained in Dynamics GP to ensure the most precise tax calculations possible.

We hope this guide provides a clear and detailed roadmap for navigating your year-end payroll with Microsoft Dynamics GP. Your feedback is invaluable in helping us improve these resources. Please share any comments, questions, or experiences you have with these procedures in the section below.