Built for sponsored programs teams who seek automation

Faster reporting. Cleaner closeouts. Audit-ready records.

A Microsoft 365 workflow for interim reports and closeouts, plus Power BI dashboards for pre-award and post-award. On the tenant your campus already runs.

Where interim reports and closeouts go sideways

Most of the work still happens by hand.

Pre-award and compliance run on their own systems. Post-award, in most offices, still runs on spreadsheets, shared drives, and email. The work gets done. It just gets done manually and inconsistently. And in both, the numbers leadership asks for get rebuilt by hand every quarter.

Interim and final reports are coordinated via email.

Financial reports have a variety of formats. Each one pulls numbers from the ledger, gets routed to a reviewer, who then approves and submits it by the deadline. Most teams stitch this together without a workflow underneath it.

F&A recovery drifts.

Ensuring that your F&A recovery is accurate can be time and labor consuming if rates change mid-project, or exceptions are not properly excluded or included. The variance is rarely visible until someone goes looking.

Reconstructing a sponsored project's financial history a year later is mostly searching.

A year after a project ends, the question of who reviewed what, what got reclassified, and why a cost was disallowed turns into a search across inboxes and shared drives. The answer exists. It's just not in one place.

What it looks like in practice

Inside the workflow.

Four views of how Quorum handles interim reporting and closeouts once it's deployed.

Stylized reporting queue showing sample funds with sponsor names, report types, due dates, and status pills. Generic data, not a screenshot.
The reporting queue. Every fund with interim reports or closeouts coming due, the sponsor, who's reviewing it, and where it stands.
Stylized fringe and F&A reconciliation table by fiscal year and object code, with red rows flagging under-recovery and a totals row showing recoverable variance. Generic data.
Fringe and F&A reconciliation by fiscal year and object code. Under-recovery is flagged before the report is due, not after the fund closes.
Stylized vertical timeline of one interim report or financial closeout from due-date alert through sponsor acknowledgment, with each event timestamped. Generic data.
The audit trail for one report or financial closeout, end to end. Every event timestamped, from the due-date alert through sponsor acknowledgment.
Stylized horizontal flow diagram of the eight steps of interim reports or financial closeouts from alert through sponsor submission, with icon and label on each step.
The eight steps of interim reports or financial closeouts, from "this fund is due in 90 days" through reviewer sign-off and sponsor submission.

Pre-award and post-award, in one view

Power BI for research administration.

Quorum designs the semantic model. Quorum builds the report pages and deploys them in Power BI, on the tenant your campus already runs. Pre-award pipeline, award portfolio, and salary coverage, built on extracts from the systems your office already reports from, scoped during Discovery. The workflow keeps the record clean. The dashboards show what the record says.

  • A semantic model and measures built the way your office counts.
  • Report pages with synced slicers, fiscal-year logic, and drill paths.
  • Report files deployed in your tenant and owned by your team.
Stylized post-award portfolio report with cards for sponsored awards, awarded funding and expiring funding, a sponsor mix matrix by research group, awarded funding by fiscal year, and a group scorecard showing PI headcount, awards per PI and success rate. Illustrative data, not a screenshot.
The award portfolio. Sponsored awards, obligated funding, and what expires this fiscal year, with a group scorecard showing PI headcount, awards per PI, and success rate.
Stylized pre-award report with cards for total submissions, funding success rate, on-time rate and pending requested dollars, plus submissions by fiscal year, amount requested by sponsor type, and submissions by research group. Illustrative data.
The pre-award pipeline. Submission volume, funding success rate, on-time rate, and pending requested dollars, split by fiscal year, sponsor type, and research group.
Stylized labor and fund report with cards for personnel, fiscal-year labor, percent extramural support and funding ending this fiscal year, a salary coverage chart split between departmental and extramural sources, and a labor detail table by fund. Illustrative data.
Salary coverage. Who is paid from sponsored funds, how much of each salary the awards carry, and how many people lose coverage as funds end.

All figures shown are synthetic sample data. These are not screenshots of any institution's reports.

The numbers behind the manual work

Automation moves three numbers that matter.

Across knowledge workers globally, automation has measurable effects on time, accuracy, and satisfaction. The research is recent, the samples are large, and the numbers point in one direction.

90%

of workers using automation at work say it saves them time

Microsoft & LinkedIn, 2024 Work Trend Index Annual Report

39%

of workers report more accurate work outputs after adopting automation

UiPath 2024 Global Knowledge Worker Survey

81%

higher job satisfaction among daily automation users versus non-users

Slack Workforce Index, June 2025

Who's building this

Built by someone with 17+ years in research administration.

Quorum is a one-person practice. The person on the Discovery call is the same person who designs and runs the build.

Ady Villegas-Estrada is currently an Associate Director in the Office of Research Services at the University of Pennsylvania, where he serves as an Authorized Organizational Representative across a roughly $400M sponsored portfolio. Before Penn, he spent close to two decades at Weill Cornell Medicine. During his run at Cornell Radiology, NIH funding grew 422% and the department moved into the national top five for radiology research.

He chaired the NCURA Region II Annual Meeting in 2023. He holds a Ph.D. in Chemistry from the University of Notre Dame, is a Certified Research Administrator, and has co-authored work in JAMA Network Open and Academic Medicine.

Why he's building Quorum: most interim reporting and financial closeouts still happen by hand, even at well-resourced offices. Post-Award Administrators reconstruct fund history from spreadsheets and route reports through email. The tools to automate the routine parts of that work sit inside Microsoft 365, which most institutions already license. Quorum exists to build them.

Ady Villegas-Estrada, founder of Quorum Research Partners

What working with Quorum actually means

The Quorum difference.

What buyers usually want to know before the Discovery call.

Quorum builds interim reporting and financial closeout workflows for sponsored programs offices on Microsoft 365: SharePoint, Teams, Power Automate, Power BI, the tenant your campus already runs. Quorum also designs and builds the Power BI reporting on top, for pre-award submissions as well as the award portfolio. We read your expenditure ledger, and where the reporting calls for it, extracts from your ERA system and payroll. We don't replace your ERA system. What comes out the other side is a consistent, automated, timestamped record of every report and financial closeout, including who reviewed it and what was submitted.

How engagements are shaped

Four ways to work together.

Every engagement starts with Discovery, scoped to what you are building. Build is implementation against the Discovery-approved architecture. Dashboards run inside Build or as a standalone engagement. Managed Services keeps the workflow current after go-live.

Next step

Thirty minutes to talk through your reporting and financial closeout cycle.

Bring the part of interim reporting or financial closeouts you're trying to fix. We'll tell you whether Quorum is the right fit before either side writes a statement of work.

Follow-up within 1–2 business days. We'll send you a tailored Discovery scope.