bump.….anyone have an answer?  We are setting up the separate bank accounts this month so I really need to figure out how to do this before I have to pay July source deductions next month.

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

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?

Hi Nancy:

This will work if departments are set up for each employee and departments must be setup for your payroll ledger accounts I.E. EI, CPP & IT or if you additional deductions or benefits. You can run a G/L, TB, BS or IS which will show you the departmental breakdown.

Hope this helps!

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.

thanks.  I created a test version of my file and created a couple of departments and assigned employees.   That all seems to work ok.   The only thing is when I run a balance sheet or income statement it shows every single account broken down by department.   Is there any way to only have certain items showing departments?  I already have separate expense accounts for everything else so I don't really need to use departments for regular income and general expenses.  Would just want to show those for which I've allocated to departments to be broken down.

Hi Nancy:

Just run a G/L by account for the accounts and departments you would like.

Nancy Fischer

When you first set up the departments assign the GL accounts you want to use with the department. See the screen shot as an example:

yes, that did it!  thanks!

Excellent and you are welcome!