--- title: "How to Set Up Roll-Up Reporting Across Your Chapter Network" url: https://tidyhq.com/blog/how-to-set-up-roll-up-reporting-chapters date: 2026-08-24 updated: 2026-07-12 author: "Isaak Dury" categories: ["Governance", "Club Operations"] excerpt: "Roll-up reporting aggregates chapter-level data into a network-wide view. Here's how to define metrics, standardise collection, and build reports that inform decisions." --- # How to Set Up Roll-Up Reporting Across Your Chapter Network > Roll-up reporting aggregates chapter-level data into a network-wide view. Here's how to define metrics, standardise collection, and build reports that inform decisions. ![Yapoura by Victor Vasarely, illustrating How to Set Up Roll-Up Reporting Across Your Chapter Network](https://cdn.sanity.io/images/bp0k7h82/production/f31f52e232c8ac2a5eb084544aab4aa60ae32b38-473x500.jpg?w=1200&fm=webp) ## Key takeaways - Roll-up reporting means defining 5-8 standard metrics that every chapter reports, then aggregating them into a network dashboard - The metrics must be objectively measurable (not self-assessed) and automatically collectible (not manually compiled) - Start with three metrics - membership count, event activity, and compliance status - before adding more - Reports should serve three audiences: the board (summary), staff (operational detail), and chapters (their own performance) The board of a national association asked for a simple number: total membership across all chapters\. The operations team spent three days compiling data from 24 chapters \- 18 submitted by the deadline, 4 submitted late, and 2 didn't submit at all\. The final number came with a footnote: "estimated, based on 92% of chapters reporting\." Roll\-up reporting replaces this quarterly scramble with a system where chapter data aggregates automatically into network\-wide reports\. Here's how to set it up\. ## Step 1: Define the metrics Limit your roll\-up to 5\-8 metrics\. More than that and chapters won't report consistently\. Start with these three, then expand: **Membership count\.** Total financial members by chapter\. This is the metric everyone needs \- the board, the staff, funders, and the chapters themselves\. **Event activity\.** Number of events held and total attendees per chapter per reporting period\. This measures whether chapters are active and engaging their members\. **Compliance status\.** Percentage of compliance items current per chapter\. This measures whether chapters are meeting their governance obligations\. Once these three are working, consider adding: retention rate, new member acquisition, financial position, committee completeness, and service/community impact hours\. ## Step 2: Standardise definitions Ambiguity kills data quality\. Define every metric precisely: - **"Financial member"**: A member whose dues are current or within a 90\-day grace period\. Not "anyone who was ever a member\." Not "anyone on the mailing list\." - **"Event"**: A chapter\-organised activity with a defined date, time, and attendee count\. Not "an informal coffee catch\-up" unless you want those counted\. - **"Compliant"**: All required compliance items current and documented in the system\. Not "we think we're compliant" without evidence\. Document these definitions and share them with every chapter\. When a chapter asks "does our AGM count as an event?", the definition should answer the question without requiring a phone call to the national office\. ## Step 3: Choose the collection method Three options, in order of preference: **Automatic \(best\)\.** Chapters use a shared platform \(like TidyHQ\) for their operations\. The data exists because the chapter is managing their members, events, and compliance through the platform\. TidyConnect aggregates it automatically\. No reporting action required from chapters\. **Semi\-automatic\.** Chapters use their own systems but submit data through a standardised online form \(not a spreadsheet attachment, not an email\)\. The national office imports the data into a dashboard\. This requires chapter action but minimises the format inconsistency\. **Manual \(worst but common\)\.** Chapters email spreadsheets to the national office\. Someone manually compiles them into a consolidated report\. This is error\-prone, time\-consuming, and what most organisations do today\. ## Step 4: Build the dashboard The dashboard should serve three audiences: **Board summary\.** One page showing network totals, trends, and chapters requiring attention\. The board should be able to read it in 60 seconds\. **Staff operational view\.** Detailed data by chapter, sortable and filterable\. The operations team uses this for day\-to\-day management and intervention planning\. **Chapter self\-view\.** Each chapter can see their own data \- how they're performing and how they compare to benchmarks \(not necessarily to named other chapters\)\. ## Step 5: Set the cadence **Real\-time** is ideal if you're using automatic collection\. The dashboard updates as chapters operate\. **Monthly** is the minimum useful cadence for manual or semi\-automatic collection\. Quarterly is too infrequent \- problems that would have been caught at one month old are three months old by the time they appear in a quarterly report\. ## Choosing the right visualisation How you present roll\-up data matters as much as what you collect\. **For the board:** Use summary cards with large numbers and directional arrows\. "47,832 members \(up 2\.1%\)" is instantly readable\. A 14\-column spreadsheet is not\. **For staff:** Use sortable tables with traffic\-light colour coding\. Staff need to filter, drill down, and identify specific chapters that need attention\. **For chapters:** Use a simple scorecard showing the chapter's performance against benchmarks\. "Your retention rate: 78% \(benchmark: 80%\)" tells the chapter exactly where they stand and what to work on\. **For funders and external stakeholders:** Use clean charts showing trends over time\. A line graph showing three years of membership growth is more credible than a single number\. ## Common pitfalls **Too many metrics\.** If you ask chapters to report on 20 items, they'll report on none\. Keep it tight\. **Inconsistent definitions\.** If chapters count membership differently, the aggregated number is meaningless\. **Punishing reporters\.** If the chapter that diligently reports gets scrutinised while the chapter that doesn't report gets ignored, you've created a disincentive to report\. **Never acting on the data\.** If the reports don't lead to decisions \(resource allocation, support for struggling chapters, recognition for thriving ones\), the reporting system becomes performative\. ## Frequently asked questions ### What if chapters refuse to report? First, make reporting easier \(ideally automatic\)\. Second, demonstrate value \- show chapters what the aggregated data enables \(better board decisions, stronger funding applications\)\. Third, create incentives \- chapters that report automatically \(through a shared platform\) are exempt from manual quarterly reports\. ### How do we handle incomplete data? Report what you have and note the gaps\. "Based on data from 22 of 24 chapters \(representing 91% of estimated membership\)" is honest and sufficient\. Don't estimate or fill in gaps \- that compromises the data's credibility\. ### Should we benchmark chapters against each other? Benchmark against standards, not against each other\. A chapter with 30 members shouldn't be compared to a chapter with 300 \- but both can be measured against retention rate benchmarks, event frequency minimums, and compliance thresholds\. ## How TidyHQ helps TidyConnect eliminates Steps 2\-3 entirely\. When chapters manage their operations in TidyHQ, the membership count, event activity, and compliance status are already in the system\. TidyConnect aggregates them into the network dashboard automatically\. No manual reporting\. No quarterly spreadsheets\. No three days of compilation\. The board asks "how many members?" and the answer takes ten seconds\. Roll\-up reporting sounds complicated\. It's not\. It's three metrics, a consistent definition, a collection method, and a dashboard\. The complexity comes from doing it manually\. The simplicity comes from doing it automatically\. --- Header image: *Yapoura* by Victor Vasarely, via [WikiArt](https://www.wikiart.org/en/victor-vasarely) --- Canonical: https://tidyhq.com/blog/how-to-set-up-roll-up-reporting-chapters | Retrieved from: https://tidyhq.com/blog/how-to-set-up-roll-up-reporting-chapters.md | Published by TidyHQ (https://tidyhq.com)