Combine T4s from multiple organizations into one

Combine T4s from multiple organizations into one

If you're an admin for multiple payroll organizations and all of the organizations are connected to ONE Rise account, you should combine all your T4s into one organization.

Let's say you have two organizations, Bi-Weekly Org and Semi-Monthly Org, and you want to combine both organization's T4s into Semi-Monthly Org.

1. Switch to Bi-Weekly Org.


2. Navigate to Payroll, then click Tax Form Runs.


3. Find the year you wish to export from, and click Edit.


4. Click Download CSV Tax Form Data


5. Open the downloaded CSV file and delete all data in the Employee ID row.


6. Save the CSV file and keep it open. Return to Rise and switch to Semi-Monthly Org


7. Navigate to Payroll, then click Tax Form Runs.


8. Find the year you wish to export from, and click Edit.


9. Click Download CSV Tax Form Data.


10. Return to the Bi-Weekly Org T4 CSV file and copy all rows (except the title row). Paste all these rows into the Semi-Monthly Org CSV file beneath the bottom row, and save the Semi-Monthly Org CSV file as a new file.

11. Return to Semi-Monthly Org and click Upload CSV Tax Form Data. Import your saved Semi-Monthly Org spreadsheet.


You're done!

I get a warning about duplicate employees when I try to upload my spreadsheet. 

Employees cannot have duplicate entries. If an employee was in both organizations throughout the year, their T4 data will need to be combined into one line.

I get a warning about duplicate Employee codes when I try to upload my spreadsheet.

If the same employee code is being used for multiple employees, simply create a new (fake) employee code for one of them. The employee code does not need to match the profile and does not appear anywhere on the T4 itself.