Group consolidation and reporting