Yes, I created the comparison using the Account Groups. It gives me a column for each but the numbers for each are the totals for all the locations.

There are two colspec rows, one has the department number and the other has "BAL".

=-GLAMT(D$7,RNGMERGE($B9,STRCAT("-",D$5))) is the formula for the first line of the income statement. The formula for each location has the same formula, but with the last cell reference different (pointing to the department number).