Setting up two Payroll identification account numbers canadian

Hi tyhere RTlastrope,

it's vital for all your payroll to be entered correctly so that you can correctly file to the government. QuickBooks Desktop is a great tool able to help you create paycheques and calculate the deductions owed on each pay run. I can provide some information about the CRA Payroll number in QuickBooks Desktop.

There can only be one CRA payroll number associated with your company file. In order to change this information, you can click on the Company drop-down menu, then select Company Information. There will be a box there to enter that information.

If you'd like to keep track of separate companies within QuickBooks Desktop, you can follow these steps in order to create a new QuickBooks Desktop company file.

If you have any other questions, feel free to reach out here. 

Hello @RTlastrope ,

Although you can only have one RP # in QBD, you can work around it.  Here's what I have done in the past:

1. Create a custom field in 'Edit Employee' called RP# or something similar.  Identify each employee as RP0001 or RP0002.
2. Ensure you have two payroll vendors, i.e. Receiver General - Payroll RP0001 and Receiver General - Payroll RP0002.  Enter your business number into each with the appropriate RP0001 or RP0002 appending it.  The numbers will show in the Memo field of each liability cheque payment you make to the CRA so you can identify which payments were made to which programs.
3. Create memorized reports for each group so you can do your remittances correctly, as both program numbers must be remitted separately.  Create two reports for Gross Earnings, choosing all the payroll items that make up your gross earnings and filtering one by RP0001 and one by RP0002.  Do the same for your CPP, EI and Tax (I usually keep these all on one report, sub-totalling by payroll item) and filter for each program.  Because these will be memorized reports, all you have to do each remittance is change the date range to your remitting period.
4. Ensure that the totals of the two sets of reports are equal to your PD7A report for the remitting period.
5. Finally, when running T4's at the end of the year, choose only the RP0001 employees to review and print T4's.  When those are complete, go to Company-->Company Information and in the bottom right of the window, change the CRA Payroll Account # to XXXXXXXXX RP0002.  Go back to your T4's and choose only the RP0002 employees.  Review and print these.
6. When filing T4's, you will have to do the same thing.  Change the RP # in the Company info for whichever program you are filing for as they do have to be filed separately, just like the remittances.

I hope that helps somewhat.  It sounds like a lot, but once you have it all set up and have the reports memorized, it actually is a breeze.  It wouldn't hurt to also set up an Employee details report, filtering to display only the RP# just so you can have a list of which employees belong to which number.  If you need any more help, don't hesitate to reach out.