Two Payroll Accounts with CRA (RP0001 and RP0002)

We have two payroll accounts with CRA (RP0001 -Standard EI Employer rate and RP0002 - Reduced EI Employer rate). 

Does anyone have suggestions on how I can identify CPP/EI/TAX owing for each separate account?  Is there a report I can run after each pay period possibly that can identify employees by their EI Employer Rate entered in their employee record?

I have Sage 50C Premium 2021

  • We have been looking for this answer for nearly a year now and have not found one. We have seen others asking the same question for years without an answer so it appears as though Sage 50C Premium is not setup to manage this nor is anyone interested in adding the functionality to the program. We now have to manually calculate the T4's for the year and submit them for each account. The archaic program we dropped for Sage 50 managed this functionality perfectly. If there is a Sage product that does this I would like to know. Maybe we have to upgrade again.

  • in reply to Terry Cooper

    We have several clients who use Sage for their bookkeeping, but Paydirt for their payroll.  This lets them keep their existing bookkeeping setup, and Sage's (relatively) inexpensive cost, while moving up a level for payroll only.

    There is some setup required for Paydirt, but once it's set up it easily handles (a) multiple RP numbers, (b) complex calculations, (c) automatically allocating management salaries to multiple departments or projects, (d) %-based calculations, (e) 27 biweekly or 53 weekly pay periods in a year, (f) multi-province employees.  After each payroll, Paydirt produces a general journal entries that can be imported into Sage after each payroll.

  • in reply to Terry Cooper

    Open a new set of books and run payroll thru that - this is what I have done and it works great!

  • Ally L:

    I haven't attempted this but I believe there was a way to have 2 payroll CRA numbers using Payroll Expense Groups. Use the sample company and try it out with some practice employees and practice payroll expense groups.

  • in reply to C White

    So if Paydirt can do this for free for the first year and then you pay $245 in subsequent years for new tax tables, why can't Sage do it for the $1,600 annual subscription price?

  • in reply to Kootrac

    If I do this how to I merge the reporting into one database or monthly reports?

  • in reply to Agate

    Would this give me two remittance accounts, the capability of generating T4's and a T4 summary for each account? Would it also be able to generate the report needed to pay the portion of the EI premium that is owed to the employees?