Cookies help us display personalized product recommendations and ensure you have great shopping experience.

By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData CollectiveSmartData Collective
  • Analytics
    AnalyticsShow More
    image fx (67)
    Improving LinkedIn Ad Strategies with Data Analytics
    9 Min Read
    big data and remote work
    Data Helps Speech-Language Pathologists Deliver Better Results
    6 Min Read
    data driven insights
    How Data-Driven Insights Are Addressing Gaps in Patient Communication and Equity
    8 Min Read
    pexels pavel danilyuk 8112119
    Data Analytics Is Revolutionizing Medical Credentialing
    8 Min Read
    data and seo
    Maximize SEO Success with Powerful Data Analytics Insights
    8 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-25 SmartData Collective. All Rights Reserved.
Reading: Why Budgeting Is “Mission Critical” in Higher Education
Share
Notification
Font ResizerAa
SmartData CollectiveSmartData Collective
Font ResizerAa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Data Management > Best Practices > Why Budgeting Is “Mission Critical” in Higher Education
Best PracticesBig DataBusiness IntelligenceData ManagementSoftware

Why Budgeting Is “Mission Critical” in Higher Education

LServen@XLerant.com
LServen@XLerant.com
5 Min Read
SHARE

budgeting tool

budgeting tool

You can’t pick up a newspaper without reading about how higher education is under pressure to keep tuition costs in line.  In the past, higher education institutions were able to pass along cost increases to students.  No more.  Now these institutions must learn to do more with the same resources or, in some cases, with less resources.   This puts pressure on the institution to make sure that it creates a financial plan that allows it to maximize its services at the most efficient cost. 

In addition, college presidents are crafting strategies for their institutions.  These strategies are essential to meeting their short-term and long-term goals as administrators.  In the past, faculty and staff have been more prone to doing what they have always done rather than thinking about strategy.  They tended to budget to politics and history. 

More Read

Image
A Cloudburst of Financial Advisor CRM Options: What to Look For
How Do You Turn Supply Chain Data into Actionable Information?
Role of Qualitative Research in the Scope of Big Data
Performance Measurement Gap
Big Data to Play Key Role in Future of Bankruptcy Proceedings

The budget process is at the vortex of this issue.  The budget must tie to the strategic plan.  It is the next 12 months’ operational plan of that strategic vision and plan. The previous sentence initially was difficult for me to understand but I get it now: if the budget does not tie to the strategy, it is essentially not doing its job. Plus, the budget, being the blueprint for the next 12 months’ operational plan, is the place where institutions need to focus their attention in learning to do more with the same or less resources. 

Most higher education institutions are limited in their budgeting process. They still use Microsoft Excel spreadsheets as the basis of the budget process. Excel was fine for the old days, but can not meet the needs of today’s higher education institutions. There are several reasons for this:

  • Excel does not have “budget intelligence”.  It is a simple two-dimensional spreadsheet that does not inherently understand the budget process or workflow.  It does not understand accounts, departments, time periods, versions, spreading, salary planning, asset planning, users, consolidation, approval or many of the other functions required of more sophisticated budgeting. 
  • It is not a database.  So financial people become the database and must manually manage, consolidate and report data. 
  • It does not check for errors in the budget process and complex formulas, which can be difficult to understand even by their authors, can wreak havoc on the process.  Several institutions have reported submitting budgets to the board that had to be recalled based on the discovery of such errors
  • Excel does not have the flexibility to let various faculty and staff members budget their unique departments the way they think about those departments.  The math department budgets differently than the music department, which are both different from how the library budgets, which is different than the admissions department, which is different from the athletics department, which is different from student housing and on and on.
  • Excel does not easily account for documentation, justification or validation to strategic tenants. 
  • Upwards of 79% of a higher education budget is salary and benefits related.  Yet Excel does not inherently understand headcount and salary planning, how to give raises, calculate state and local taxes, benefits, special arrangements like recruiting fees, relocation and the like.

So the process needs to be upgraded to help colleges and universities better manage revenue and expenses and make sure that faculty and staff budget to strategy and not history or politics. 

But higher education also is slow to change.  People are reluctant to improve their approaches and cling to past practices in spite of the need to do so.  So they limp along claiming that change is too difficult or that that their current approach is not “that bad”.  These institutions will fall behind in their ability to adapt to a changing world and the people who are reluctant to make the changes will be left behind. 

All applications in all industries change over time.  The institutions that lead the change are the winners while the ones who resist these changes tend to be the ones who face crisis after crisis. 

Budgeting is a “mission critical” and strategic application in higher education.  It must be treated as such.  And institutions need to shed their reliance on spreadsheets if they want to keep pace with peer institutions. 

TAGGED:budgetingexcelhigher educationspreadsheets
Share This Article
Facebook Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

image fx (2)
Monitoring Data Without Turning into Big Brother
Big Data Exclusive
image fx (71)
The Power of AI for Personalization in Email
Artificial Intelligence Exclusive Marketing
image fx (67)
Improving LinkedIn Ad Strategies with Data Analytics
Analytics Big Data Exclusive Software
big data and remote work
Data Helps Speech-Language Pathologists Deliver Better Results
Analytics Big Data Exclusive

Stay Connected

1.2kFollowersLike
33.7kFollowersFollow
222FollowersPin

You Might also Like

excel model failure
AnalyticsCommentaryCulture/LeadershipNewsStatistics

Don’t Gloat Over Excel Model Failures

6 Min Read

Big Data Is More Valuable with Kapow

6 Min Read
spreadsheet
Best PracticesBusiness IntelligenceBusiness RulesCollaborative DataData ManagementExclusive

Five Reasons Excel Is Your Worst Enemy for Budgeting and Forecasting

8 Min Read

A video introduction to R for Excel users

3 Min Read

SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

ai is improving the safety of cars
From Bolts to Bots: How AI Is Fortifying the Automotive Industry
Artificial Intelligence
data-driven web design
5 Great Tips for Using Data Analytics for Website UX
Big Data

Quick Link

  • About
  • Contact
  • Privacy
Follow US
© 2008-25 SmartData Collective. All Rights Reserved.
Go to mobile version
Welcome Back!

Sign in to your account

Username or Email Address
Password

Lost your password?