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
5 Ways Smart Use of Credit Data Can Save Businesses Money
Different Software Testing Strategies When Creating AI Applications
Business Analytics – Opposition or Proposition?
To Our Data Perfectionists
CRM Software: Does Visualization Matter?

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

A video introduction to R for Excel users

3 Min Read

Big Data Is More Valuable with Kapow

6 Min Read

Spreadsheets: Use Them, Don’t Abuse Them

10 Min Read
spreadsheet
Best PracticesBusiness IntelligenceBusiness RulesCollaborative DataData ManagementExclusive

Five Reasons Excel Is Your Worst Enemy for Budgeting and Forecasting

8 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 and chatbots
Chatbots and SEO: How Can Chatbots Improve Your SEO Ranking?
Artificial Intelligence Chatbots Exclusive
ai in ecommerce
Artificial Intelligence for eCommerce: A Closer Look
Artificial Intelligence

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?