Paul:

My preference is to always deliver financial reports that just work (new accts/depts. do not require user or consultant intervention). This requires a well designed chart of accounts and dept code structure.

Though the initial cost is higher, in the long run this solution is less expensive.

Where we have delivered this solution before, it's always using dept ranges and excluding inactive depts.