The aggregation problem
As a pass-through entity, you submit consolidated reports to your state or federal funder that aggregate data from every sub-grantee in your network. The funder sees one set of numbers. Behind those numbers are 10, 20, or 50 organizations, each submitting data in their own format, on their own timeline, with their own interpretation of the reporting requirements.
The typical process: chase sub-grantees for their data, reconcile inconsistencies, manually aggregate in Excel, format to the funder's template, and submit. The whole cycle takes days — sometimes a week — and introduces errors at every step. Miss one sub-grantee's data and your consolidated numbers are wrong.
Supported report types
WeavePulse supports the consolidated report types most commonly required of intermediary grantees, including programmatic progress reports, financial status reports (SF-425), performance measure summaries, and custom reports defined by your state funder.
Each report type has a defined data schema. When sub-grantees enter their data — either directly or through the “enter on behalf of” workflow — it flows into the correct fields automatically. No manual mapping, no copy-paste, no reconciliation spreadsheets.
From sub-grantee data to consolidated report
The consolidated report builder pulls data from every sub-grantee in the selected reporting period and aggregates it according to the report template. You can preview the consolidated numbers before submitting, drill into any line item to see which sub-grantees contributed what, and flag discrepancies for review.
If a sub-grantee hasn't submitted their data yet, the report builder shows you exactly what's missing. You can generate a partial report, send targeted reminders, or wait — but you always know where you stand instead of discovering gaps at the deadline.
Export and submission
Consolidated reports can be exported as PDF for submission, Excel for your own records, or CSV for import into other systems. The export format matches the template your funder expects, so you don't need to reformat after generating.
Every generated report is archived with a timestamp, the data snapshot it was built from, and the user who generated it. If your funder ever questions a number, you can trace it back to the specific sub-grantee data that produced it.