By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData CollectiveSmartData CollectiveSmartData Collective
  • Analytics
    AnalyticsShow More
    data-driven white label SEO
    Does Data Mining Really Help with White Label SEO?
    7 Min Read
    marketing analytics for hardware vendors
    IT Hardware Startups Turn to Data Analytics for Market Research
    9 Min Read
    big data and digital signage
    The Power of Big Data and Analytics in Digital Signage
    5 Min Read
    data analytics investing
    Data Analytics Boosts ROI of Investment Trusts
    9 Min Read
    football data collection and analytics
    Unleashing Victory: How Data Collection Is Revolutionizing Football Performance Analysis!
    4 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-23 SmartData Collective. All Rights Reserved.
Reading: Why Budgeting Is “Mission Critical” in Higher Education
Share
Notification Show More
Aa
SmartData CollectiveSmartData Collective
Aa
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
Last updated: 2013/07/19 at 8:05 AM
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

Spice Up Your Spreadsheets: Boosting BI with Google Spreadsheets

5 Reasons Why Excel Isn’t Enough for Financial Reporting
Five Reasons Excel Is Your Worst Enemy for Budgeting and Forecasting
IBM’s 2013 Vision Bodes Well for Finance
Don’t Gloat Over Excel Model Failures

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: budgeting, excel, higher education, spreadsheets
LServen@XLerant.com July 19, 2013 July 19, 2013
Share This Article
Facebook Twitter Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

RN coders for hosptial data
RN Coders Can Improve Hospital Data Strategies
Big Data
cloud technology in education
How Cloud Technology Can Be Integrating in Schools
IT
big data and IP laws
Big Data & AI In Collision Course With IP Laws – A Complete Guide
Big Data
ai in marketing
4 Ways AI Can Enhance Your Marketing Strategies
Marketing

Stay Connected

1.2k Followers Like
33.7k Followers Follow
222 Followers Pin

You Might also Like

Spice Up Your Spreadsheets: Boosting BI with Google Spreadsheets

8 Min Read
Image
Uncategorized

5 Reasons Why Excel Isn’t Enough for Financial Reporting

14 Min Read
spreadsheet
Best PracticesBusiness IntelligenceBusiness RulesCollaborative DataData ManagementExclusive

Five Reasons Excel Is Your Worst Enemy for Budgeting and Forecasting

8 Min Read

IBM’s 2013 Vision Bodes Well for Finance

13 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-23 SmartData Collective. All Rights Reserved.
Go to mobile version
Welcome Back!

Sign in to your account

Lost your password?