Other Payroll: Uploading your payroll register

The Employer Dashboard allows you to securely upload your payroll files directly into our system. In the 'Contributions' tab, you can provide contribution instructions by uploading your payroll register with contribution details for each employee. 

Before you run your payroll

Log in to the Employer Dashboard to see if you have any pending Employee Requests (such as a change in their RRSP or TFSA contribution amount). Update your payroll system with any new requests, and run your payroll.

After you run your payroll

Log in to the Employer Dashboard and go to the 'Contributions' tab

1. Insert the 'Pay period start date' and the 'Pay period end date', and the 'pay date'.
2. Upload the payrollregister.xlsx template and populate it with the contribution information from your payroll system. Be sure to upload your payrollregister.xlsx file (within 3 business days of running your payroll).
3. Before you submit your file, you will be able to review the payroll contribution amounts for each employee, and the total contribution amount for that pay period.

Completing your update

After you've uploaded your file in the 'Contributions' tab of the Employer Dashboard:

1. Review the on-screen summary of total contributions, the split between employee and employer contributions, and the pay period before uploading the file.
2. Click the green “Submit” button in the bottom right corner of the screen. Make sure you see the Success message before you log out.

Through the Employer Dashboard

The Employer Dashboard allows you to securely upload your payroll files directly into our system. In the 'Pay Contributions' tab, you can provide contribution instructions by uploading your payroll register with contribution details for each employee. 

Before you run your payroll

Log in to the Employer Dashboard to see if you have any pending Employee Requests (such as a change in their RRSP or TFSA contribution amount). Update your payroll system with any new requests, and run your payroll.

After you run your payroll

Log in to the Employer Dashboard and go to the 'Pay Contributions' tab

1. Download the payrollregister.xlsx template, and populate it with the contribution information from your payroll system.
2. Upload your payrollregister.xlsx file (within 3 business days of running your payroll). Before you submit your file, you will be able to review the payroll contribution amounts for each employee, and the total contribution amount for that pay period.

Completing your update

1. Review the on-screen summary of total contributions, the split between employee and employer contributions, and the pay period before uploading the file.
2. Click the green “Submit” button in the bottom right corner of the screen. Make sure you see the Success message before you log out.

Once your payroll register is uploaded, instructions go to Canadian Western Trust to automatically withdraw funds from your account for contributions and fees owing to Common Wealth.

Note: This step must be performed for every payroll cycle. If there have been no changes since your last payroll upload, you can download the previously submitted file, update the file name if necessary, and submit it on the contributions page, ensuring you use the correct pay period date in the appropriate fields.

Payroll register file dos and don’ts

Do

• Be sure your payroll start and end dates don’t overlap
• Include two decimal points in your contribution columns
• Include both member and employer matching amounts, if applicable

Don’t

• Update or paste over the column headers
• Include formulas or cell references in your file
• Use negative values. If you’ve entered these by mistake, please contact us for help with making corrections.
• Leave any empty rows in your file or include an employee without a contribution

Next step>>