Education & Government
Diana Baker Freeman Image
Diana Baker Freeman
Sr. Manager, Modern Governance Advocacy & Iniatives

Expert tips for leveraging data for school board budgets

December 19, 2023
0 min read
Expert tips for leveraging data for school board budgets

School board members are entrusted with making the most of a community's resources for the education of its children. They are expected to oversee the use of these resources, ensuring that they are used effectively and efficiently for the future of the community. By budgeting wisely, they can plan for the best use of these resources.

The resources are, of course, property that the school district owns as well as revenues that come from either state or local taxes depending on the state. These revenues are used to keep the district running, purchase instructional materials, pay staff, provide support services and cover the district's debt.

Who is involved in the district budgeting process?

Essentially, a school budget describes a district's plan for the upcoming year as it relates to anticipated revenues and expenditures. Board members, typically with little background in financial dealings outside of a personal or household budget, are not expected to develop this plan alone or even take the lead. The district typically charges the superintendent with developing a draft budget that supports the goals of the district, presenting it to the board and administering it throughout the year.

For the board, best practices include having a working knowledge of the budget and following a schedule. These practices should become embedded along with the agenda cycle, so that they are second nature and something board members do consistently. That also allows them to keep a careful, ongoing eye on the overall financial situation of the district.

The National School Board Association's Center for Public Education has examined the work of school boards for more than 20 years and created Eight Characteristics of Effective School Boards. One of the characteristics included states: “Effective boards are data savvy; they embrace and monitor data, even when the information is negative, and use it to drive continuous improvement.”

A school district budget involves many different individuals and entities across several levels. Budget discussions will involve school administrators, superintendents, business officials, building principals, other school employees and the board, with the opportunity for input also available to community members.

Again, the importance of this collaboration has been noted by the Center for Public Education: Effective school boards lead as a united team along with the superintendent, each from their respective roles, with strong collaboration and mutual trust. Ultimately it is the board members’ signatures that go on the budget and tax ratification, so it is incumbent on the board members to be informed.

Since the 2008 recession, U.S. schools have generally been struggling. While there has been a slight increase in funding since 2015, educational dollars have never fully recovered. Combined with the fact that costs have risen alongside the student population, this creates a near-crisis state for schools when it comes to wisely leveraging resources.

While Covid funding helped, it was needed to compensate for the learning loss and additional expenses the Covid shutdown created. As federal dollars allotted to deal with Covid expenses wind down, another fiscal cliff is looming. This makes it particularly crucial that district leadership makes the best decisions about how to use the remaining funds.

When should budget development begin?

While the fiscal year has a defined beginning and end date, the reality is that budget preparation is an ongoing process that takes place throughout the year. For the purposes of this discussion, we will assume a summer/early fall start to the fiscal year. In this case, during the winter months, the board needs to discuss its goals for the next year (short term) or series of years (long term or strategic).

Once these goals have been decided on, priorities can be set and administrators can begin an analysis of the resources needed to make progress toward these goals. This goal-setting process is now more important than ever before. Looking at the cuts that are sure to come over the next couple of years, a board's priorities must be set to ensure that funds are maximized toward progress on the goals, even if they cannot be fully realized yet.

In his book, Financial Health for School Districts, Dr. Jess Butler suggests a year-round cycle of planning, preparation and evaluation, to be outlined on a financial planning calendar. He suggests a series of reports that will assist board members and administrators in looking at trends across time to make the best decisions for the ongoing financial health of a district.

Once goals are developed and adopted, and a calendar or timeline developed to have the budget completed and adopted by the deadline for the new fiscal year, the leadership team can look at reports and data that will guide decisions.

Data needed for budget development

While specific budget lines and items vary from district to district and from state to state, there are broad general categories that apply to most schools. These categories include, but are not limited to:

  • Historic financial documents: trend line of district revenue & expenditures, fund balance, investments
  • Instruction: provides for students to have qualified teachers, teachers to have instructional aides and classrooms to have supplies
  • Facilities: to ensure that students attend schools that are clean and well maintained
  • School leadership and support: provides for the principal, assistant principals and administrative support staff
  • Transportation: buses and drivers to transport students
  • Energy: to ensure that the school is lit during the day, heated during the winter and cooled during the summer
  • Health and safety: provides for the school nurse, who cares for ill students, and security measures to keep staff and students safe
  • Curriculum and staff development: provides curriculum, training and instructional support to ensure teachers can provide students with necessary knowledge and skills
  • Food services: provides for nutritious, affordable breakfasts and lunches
  • Counseling services: provides counselors for testing prep, college prep, drug/alcohol abuse programs, and supporting family needs in seeking outside counseling

Having a good idea in advance about what is needed for these areas is essential to planning. To understand whether the best decisions are being made, district leadership needs to look at trends within their own district. Snapshots of current year data are helpful, but there are times when looking at trends can help make educated predictions of resources that will be needed.

Useful reports to review

The first report to look at is a five-year trend line of revenues and expenditures for the general fund. A list of all revenue from federal, state and local sources can be compiled and examined for the most recent five years. Many districts only look at data for the prior year, and slight increases or decreases may be explained away.

A visual representation of the expenditure trend overlaid with the revenue trend gives a truer picture of where the district is headed. While slight upticks or downturns in a single year may not matter, expenditures continuing to exceed revenue will put the district on a collision course with disaster.

If this trend emerges when looking at data, the district needs to design a budget reduction plan. This does not take into account planned expenditures in the short term for specific projects or responses to emergencies. A plan is needed when the lines cross, showing ongoing expenditures outstripping revenues.

Another report that closely parallels the expenditure/revenue history is a trend line on fund balance. Fund balances affect bond ratings and allow for responses to emergencies. It is recommended that districts maintain a minimum of two months' operating expenditures to be kept in the fund balance as best practice.

These reports, along with the expenditure/revenue history and the fund balance trend line, can be obtained from the district auditors. It should be noted that historical trend lines are important, but forecasts of expenditures vs. revenue and the corresponding fund balance should be developed as well. The historical trend is the starting point, but some time should be spent on future plans as well.

Another crucial report to examine is a 10-year trend line comparing the total number of district employees to student enrollment. The general public tends to think smaller schools can operate less expensively. While this is not always the case, stagnant or decreasing enrollment without changes to staffing could lead a district into dire financial straits quickly if it is not curtailed.

No one likes to be faced with a RIF, so an eye on the historical trends can help a district plan for reduced staffing through attrition should the need occur. Currently, K-12 enrollment is down from pre-COVID numbers. However, there is an increase in special needs students resulting in higher teacher needs (regular education classes are typically a teacher pupil ration of 1 to 20 to 25 students, where special needs classes have a ratio of one teacher plus a paraprofessional to no more than 8 students). This results in not only a strain on staffing, but also facilities.

It can be useful to compare your district to others

Analysis of comparable districts in terms of revenue, expenditures and student figures could also be helpful. Looking at peer districts is important because the demographics affect both expenditures and revenue. Sometimes looking at peer districts can be useful in learning ways to expand revenue.

For example, if one district spends more on school lunches, but in turn, brings in more revenue due to more students eating in the cafeteria, then that is something of note for a district. While this data may be more difficult to obtain, salary, staffing and cost per pupil should be available publicly. A report like this may be informative when looking at ways to maximize revenue and to spot potential warning signs.

While many of the aforementioned reports can be garnered from in-house data, sometimes it is beneficial to contract with external entities to look at some data. A school district should have in hand a recent facilities study with plans for recommended maintenance and upgrades and a schedule for when those need to be written into the budget.

If a district maintains a bus fleet, they should also keep a schedule of maintenance and upgrades/replacements. This is helpful for any district-owned vehicles, but crucial if a bus fleet is used to transport students to and from school. Additionally, an external demographic study with projections can help a district plan for shifts in needed services for future student populations.

Since the primary purpose of a school district is to educate children, the reports linking student success and failure in state-required assessments and/or local measures are of utmost importance. Again, post-COVID, looking at trends over time will give the leadership team a good sense of what might be an anomaly (e.g., a one-year dip in scores due to absence or other factors), as opposed to what might require attention (e.g., a long-term dip in scores of certain areas or grades).

In addition to results on bigger assessments, it is also important to look at local classroom or grade-level failures as well as dropout figures. An additional investment in dropout prevention, academic labs, tutors or support staff may be needed to address situations that will lead to a drop in revenue, but more importantly, a failure on the part of the district for a child.

This report should lead to an examination of classroom staffing ratios — not only total staffing, but what support staff are needed in different areas as well as student attendance reports. Since many districts funded tutors, academic labs and other similar programs with federal COVID dollars, they are going to have to determine how to supplant these funds.

Ongoing information to guide budget discussions

While all of this information can seem overwhelming, information is the key to making needed adjustments on an ongoing basis. Most boards receive monthly financial reports at board meetings and in their board materials. Looking at data within the context of ongoing planning is needed so that it does not become overwhelming all at once during budget season.

A general balance sheet, cash flow projection, investment report and enrollment/attendance figures are all needed in incremental reports throughout the year. Budget amendments can be viewed in the broader context when the need arises.

Today's digital landscape allows for easy data storage and access and provides the means to maintain historical data. Comparisons and month-to-month numbers can be charted and maintained with quick retrieval. New board members and administrators just joining the district will not be subject to tracking down needed information and depending on someone else's filing system if the data is housed in a web-based system with open accessibility.

Managing district resources is the starting point for every other job a board member or administrator has. Any information that helps guide decision-making is good information. The district governance and management are dependent on good data for the ongoing life of the district and its educational services. Boards can examine the list of reports to determine which are most needed in their district. These reports can then serve as the basis of discussions in budget workshops.

The right board portal solution offers built-in tools for budget preparation, collaboration, efficiency and security, so boards can focus on governing effectively and delivering successful outcomes for their students.

We at Diligent are here to support you as you use technology to become an even more effective board. Learn how Diligent Community can help your school board during your budgeting process.


Your Data Matters

At our core, transparency is key. We prioritize your privacy by providing clear information about your rights and facilitating their exercise. You're in control, with the option to manage your preferences and the extent of information shared with us and our partners.

© 2024 Diligent Corporation. All rights reserved.