Break out the spreadsheets and small font, because budget season is just around the corner.
For school districts around the country the process goes a little something like this:
- Determine how much money you have (or don’t have) for the upcoming fiscal year.
- Calculate your site-level budget targets.
- Create and disseminate spreadsheets — sometimes hundreds of them — to your budget owners so they can build line item budgets for their schools, departments, programs and grant funds.
- Wait… patiently.
- Collect those hundreds of spreadsheets back via email and start aggregating all those account codes and budgeted amounts.
- Cross your fingers and load all that data into your financial system and hope you come out with a balanced budget.
Doesn’t it seem like there should be a better process?
That’s what I thought, too. In my former role as Executive Director of Budget for Denver Public Schools, I was constantly looking for ways to improve the site-level budget development process. There had to be a way to rid the district of all those spreadsheets.
My philosophy was that building a budget should be as easy as using TurboTax to file my taxes. That’s not to say the decisions that go into creating a budget are easy — they aren’t! But the process to assign dollars and headcount to all those account codes should not cause heart palpitations and gray hairs.
There are several key pain points I needed to see addressed if I was going to abandon my Excel spreadsheets and purchase a budgeting tool, and I suspect you have these same challenges and needs too, including:
A Reliance on Excel
For many people, Excel is a scary little beast. Unless you’re a spreadsheet expert, like many financial staff, using it can feel daunting. I needed a product that made budget builders from all departments and schools feel comfortable and confident in the process. Instead, I kept finding products that touted the look and feel of Excel, but I wanted my budget owners to feel as far removed from Excel as possible.
Access to Historical Information
A new budget is the product of the budget that came before it. It’s grounded in staffing plans, strategies, and purchases from the year before that are adjusted to meet the needs of the next fiscal year. To accurately plan for the upcoming year, access to historical spending is critical.
Do your budget owners have access to their historical spending to know what to tweak for the future?
Which accounts were typically overspent or underspent? Which positions are changing in purpose based on a new strategy?
To build an accurate budget, historical information is necessary.
Efficiency in the Reconciliation Process
District charts of accounts contain thousands of account codes, each with a unique and valuable purpose. My staff would spend nearly two weeks reconciling each account code to make sure it was used appropriately, ensuring that we met funding guidelines and balanced the budget to its total allocation of funds. A budget tool should streamline that process and take any guesswork out of reconciling your accounts.
A Holistic View of Funds
One of the biggest challenges with Excel spreadsheets is their inability to allow budget owners to see and plan for all funding sources at the same time. A school principal would sometimes receive 3-5 separate Excel forms to encompass the various sources of funding. Imagine paying for a tank of gasoline with three different credit cards. Without all of the funding sources being simultaneously visible to the budget manager, principals have little ability to plan for their total expenditures and create the budget.
Flexibility to Build a Budget at the Individual Site Level
Schools, departments, programs, and funding sources all add a slightly different twist on how a budget is built. I needed a tool that was agile enough to handle the nuances of all of these different micro-businesses within the district, like using average vs. actual salaries, varied staffing models, and numerous funding restrictions, just to name a few. The products I looked at could each handle some of these variations, but there was nothing available that could solve for all these budgeting methods in a single tool.
Transparency and Collaboration Developing the Budget
In an Excel-based budget process, collaboration means emailing a spreadsheet back and forth, which means version control and loss of functionality with any complicated formulas are prevalent problems.
From a budget director’s standpoint, a budgeting tool needs to allow the budget to be viewed by the various stakeholders. If there was one place where everyone could see and develop the budget, and challenge and modify line items as a budget building team, our process would be more strategic and streamlined.
Visibility During the Process
One of my most nerve-wracking months as a budget director was the annual lull between sending out those hundreds of budget forms and waiting, seemingly forever, while everyone completed their individual line item budgets. It was only after all those forms came back that I could put Humpty Dumpty back together again in all his spreadsheet glory and see my $1.7 billion dollar budget in its entirety. I wanted to see budget owners actively working to build their budgets. It was important to understand what they were budgeting for so we could gain a sense of how large or small our staffing changes might be, and ensure that planned contracts were being funded appropriately.
Strategic Planning and Resource Allocation
The biggest issue with an Excel-based process is that it forces budget builders to think of rows and columns rather than big picture about the overall plan. School and department leaders get completely tied up in the process of filling out their spreadsheets, funding rules and deadlines that they aren’t able to thoughtfully engage in the process to ensure the most effective use of funds.
The Perfect Budgeting Tool
In my search for the perfect budgeting tool, I poured over websites and listened to numerous demos from companies promising ways they could make this process easier, but I couldn’t find anyone who fully lived up to their pitch. Sure, there are lots of budget tools out there, but I couldn’t find a solution that met all my needs within the same application. In the end, I returned the funds approved for a budgeting tool back to the district. Until a comprehensive solution was available, I wasn’t willing spend resources to solve half a problem. If Allovue’s budgeting tool had been available back then, the search would have been over. Our new Balance Budget Module checks all the boxes in an online, user-friendly platform, and has the potential to rid the budget development process of spreadsheets.
About the Author
Kate Kotaska is a Senior District Partner for Allovue, Inc. Before joining Allovue, Kate spent the majority of her career in Denver Public Schools shaping the district’s resource allocation model and building a backbone of financial support known as the Financial Partner Network. Kate earned her undergraduate degree from Pace University in Pleasantville, NY.