Why Research Administration Teams Are Still Managing Million-Dollar Sponsored Research Portfolios in Spreadsheets

In a previous Attain Partners blog on ERP forecasting in research administration, we discussed why traditional ERP reports often fall short when teams need forward-looking visibility into sponsored project risk. This follow-up continues that conversation by looking at why spreadsheets still play such a central role in research administration and what their continued use reveals about the broader need for operational visibility.

Despite significant investments in enterprise systems, many research administration teams continue to rely heavily on spreadsheets to manage forecasting, effort tracking, reconciliations, compliance monitoring, and portfolio oversight. For those outside research administration, this may seem surprising. Yet across higher education, spreadsheets remain one of the most widely used operational tools in research administration.

Spreadsheets remain valuable operational tools; the real issue lies in what institutions are forced to compensate for: gaps left by systems that were not designed with the operational realities of research administration.

Systems Don’t Always Talk to Each Other

Research administration operates across a complex web of platforms, many of which were designed for different business functions and stakeholder groups. Financial data lives in the ERP. Effort information is tracked in a separate module or system. Payroll follows its own processes. Sponsor reporting adds yet another layer. The result is a persistent need for manual consolidation and significant administrative time spent assembling information before meaningful analysis can begin.

Enterprise Reporting Falls Short on Operational Visibility

Most enterprise reports excel at telling administrators what has already happened. They can surface account balances, posted expenses, encumbrances, payroll activity, and revenue transactions. What they rarely provide is the forward-looking operational insight that administrators need to manage a portfolio proactively.

Operational Information Research Administrators Need

• Expenditure forecasts and projected burn rates
• Effort commitments and upcoming personnel changes
• Award end-date risks and no-cost extension candidates
• Cost-sharing obligations and compliance exposure

Without that operational layer, administrators are left to build it themselves—and typically in spreadsheets.

Spreadsheets Become Operational Glue

Over time, what starts as a simple workaround evolves into something much more significant. Departments build offline forecasting models, PI portfolio dashboards, effort monitoring trackers, reconciliation workbooks, award closeout checklists, and risk monitoring tools. These spreadsheets become the operational infrastructure that connects information from multiple systems and multiple stakeholders.

The problem is not that these tools exist. The problem is that they are often maintained manually, updated inconsistently, and visible to only a small number of people, creating a risk that is difficult to see until something goes wrong.

Operational Risks Created by Spreadsheet-Dependent Processes

Spreadsheets are frequently criticized, but the tool itself is rarely the underlying problem. The real risks are:

• Inconsistent reporting logic across departments or awards
• Manual data dependencies that break when personnel change
• Duplicate data entry creates version control challenges
• Delayed updates that erode confidence in the numbers
• Limited visibility across the broader research enterprise

When critical decisions depend on multiple disconnected spreadsheets, institutions often find it difficult to maintain consistent visibility across the portfolio, and harder still to act on emerging risks before they escalate.

Operational Visibility Drives Better Research Administration Decisions

One of the most important reframes in research administration is recognizing that operational visibility enables better decision-making. Most institutions already produce reports. Administrators also need timely, actionable information that helps anticipate emerging risks and changing portfolio conditions.

That distinction matters because it changes what institutions should be looking for when evaluating technology investments, process improvements, or staffing models.

Modernizing Research Administration Operations

The future of research administration centers on reducing institutional risk by decreasing dependence on manually maintained spreadsheets. Institutions are increasingly exploring tools and strategies that reduce the manual effort required to maintain disconnected systems.

Capabilities That Improve Operational Visibility

• API-driven integrations that connect financial, payroll, and compliance data in one place
• Workflow automation that reduces manual hand-offs and data entry
• Centralized reporting environments that provide consistent visibility across the portfolio
• Automated risk monitoring for effort commitments, burn rates, and award milestones
• AI-assisted operational analysis that surfaces issues before they become findings

Real-time portfolio dashboards accessible to administrators, PIs, and institutional leadership. These technologies are intended to reduce administrative burden, not replace research administrators. The professionals who manage sponsored portfolios bring expertise, judgment, and institutional knowledge that no system can replicate.

The Future of Research Administration Requires Operational Visibility

Research administration continues to grow more complex. Sponsored portfolios are expanding, compliance expectations are rising, and institutional resources remain constrained. The organizations that succeed in this environment will be those that build the greatest operational visibility across their research enterprise.

Modernization builds on the tools administrators rely on today. The next step is investing in solutions that make those tools less necessary, and the risk they carry easier to manage.

Attain Partners – Research Administration Strategy and Operational Excellence

Attain Partners works with research-intensive institutions to improve operational effectiveness across sponsored programs administration through advisory and technology services that strengthen operational visibility, streamline processes, and support effective portfolio management.

About the Author

Drew Davis is a Senior Associate at Attain Partners with more than nine years of experience in research administration, focused on serving higher education institutions. His expertise covers the full post-award lifecycle, from initial setup to closeout, and includes work with federal, state, industry, and foundation sponsors.