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
    sales and data analytics
    How Data Analytics Improves Lead Management and Sales Results
    9 Min Read
    data analytics and truck accident claims
    How Data Analytics Reduces Truck Accidents and Speeds Up Claims
    7 Min Read
    predictive analytics for interior designers
    Interior Designers Boost Profits with Predictive Analytics
    8 Min Read
    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
  • 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

Big Data Analytics Touching Our Lives Everyday
Analytics Should Be a Primary Focus
Visual Complexity is a unified resource space for anyone…
If You Could Pick One Thing For Congress To Do Regarding CyberSecurity, What Would It Be?
Tensorflow – Google’s artificial intelligence system for large scale machine learning

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

sales and data analytics
How Data Analytics Improves Lead Management and Sales Results
Analytics Big Data Exclusive
ai in marketing
How AI and Smart Platforms Improve Email Marketing
Artificial Intelligence Exclusive Marketing
AI Document Verification for Legal Firms: Importance & Top Tools
AI Document Verification for Legal Firms: Importance & Top Tools
Artificial Intelligence Exclusive
AI supply chain
AI Tools Are Strengthening Global Supply Chains
Artificial Intelligence Exclusive

Stay Connected

1.2kFollowersLike
33.7kFollowersFollow
222FollowersPin

You Might also Like

Spice Up Your Spreadsheets: Boosting BI with Google Spreadsheets

8 Min Read

Big Data Is More Valuable with Kapow

6 Min Read
spreadsheet business intelligence tool
AnalyticsBig DataBusiness IntelligenceData ManagementITSoftwareSQLStatistics

Spreadsheets: Still the King of Business Intelligence Tools

4 Min Read

Hacking the Budget

6 Min Read

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

data-driven web design
5 Great Tips for Using Data Analytics for Website UX
Big Data
giveaway chatbots
How To Get An Award Winning Giveaway Bot
Big Data Chatbots Exclusive

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?