multiple source deduction categories

SOLVED

I have a client who has 2 locations for their business.   They are now going to split them out to keep all income and expenses separate (used to be combined).   Not a problem for the income and expenses as I can create separate accounts for each location.

They are also setting up a separate bank account for each location.

The problem I have now is for payroll.   I know I can set up payroll expense groups to track their salaries, EI, CPP & WCB expense separately but I don't know how to deal with the source deductions part.   Sage only allows the 1 set of existing EI, CPP, tax and WCB payable accounts to link to (far as I know).  However as each location will pay their own source deductions (they will be setting up a 2nd payroll account under the existing business number) I need to be able to record the payables separately but I don't know how or whether Sage can do that?    If it can, where do I do that?

Parents Reply Children
  • 0 in reply to Nancy Fischer

    Hi Nancy Fischer

    What version of Sage 50 are you using? Pro, Premium or Quantum?

    If you are using Premium or Quantum you could set up Departments for the 2 locations to be able to track the Balance Sheet accounts. The payroll expense groups are only for the Income Statement accounts not the Balance Sheet accounts. I am also assuming your employees only work at one location.

    Once departments are set up a department is assigned to the employee in the employee record.

    Jo Anne

  • 0 in reply to Nancy Fischer

    I am using premium.   I thought I had read a post somewhere that said Sage could only have 1 set of CPP, EI & tax payable accounts on the balance sheet regardless of how many departments are set up.   It has not been an issue to now as everything was paid from the same bank account but they are now going to have separate banks for each location so I need to be able to split out the payables.   Can that be done using departments?

  • 0 in reply to Nancy Fischer

    Hi Nancy Fischer

    Yes it can be done using departments (making sure the department is turned on for the payroll liability accounts and the payroll expense accounts). I also use categories too, for running the employee detail report. I created categories for reporting purposes only for each department, because you cannot run an employee detail report by department.