Consolidate subscription snapshots for reporting coordinators before run

Your subscription snapshot rows land in a raw sheet, causing stale reports and missed reconciliations. Give reporting coordinators reconciled snapshot rows before the next reporting run.