group consolidation and reporting