When I stepped into this work, the team already had budget tracking in place, but it was very fast and loose. Information lived across a handful of basic spreadsheets with limited detail that weren’t consolidated, consistently updated, or especially easy to understand. It technically worked, but only if you already knew the context and were willing to dig. Leadership was spending too much time trying to navigate the existing setup.

It was clear we needed something more intentional and built out. The goal was not to over-engineer a solution, but to create structure, visibility, and shared understanding across everyone involved in the budget throughout the year.

The Challenge: Budgeting Without a Clear System

• The existing approach created a few recurring challenges:

• Budget information was scattered and hard to reconcile

• High-level visibility required manual explanation rather than quick reference

• Tracking actuals against planned spend was time-consuming and error-prone

• Forecasting future needs lacked consistency across contributors

• Leadership needed clearer visibility to support review and collaboration

• We needed a system that could support day-to-day tracking while also scaling up to leadership-level conversations.

The Approach: Start Simple, Design for Real Use

I decided to start from scratch.

Rather than trying to retrofit the existing spreadsheets, I designed a new budgeting system with clear structure and distinct purposes for each component. The goal was to make the information easy to update, easy to understand, and useful for different audiences without duplicating work.

I built a set of connected spreadsheets that included:

• A high-level summary view with clear rollups and simple visualizations for quick understanding

• Detailed tabs for line-item tracking that I updated weekly with actuals

• Forecasting spreadsheets for upcoming fiscal years that TPMs used to input projected needs

Each piece served a specific role, from daily tracking to long-term planning, while still rolling up into a shared source of truth.

The Fix: A Shared Budgeting System With Clear Ownership

The final system gave the team a centralized, well-organized way to manage budget information throughout the year. It balanced detail with usability, allowing people to go deep when needed or stay high level when that was enough.

I worked closely with TPMs to make sure forecasting templates were clear and easy to complete, and partnered cross-functionally with finance as questions came up or adjustments were needed. My role was to act as the connective tissue between inputs, tracking, and review, keeping everything aligned and up to date.

The result was a budgeting system that felt supportive rather than intimidating, and one that people actually used.

The Outcome: Better Visibility, Stronger Alignment

With the new system in place, the team had:

• Clear, up-to-date visibility into current spend

• A reliable way to compare actuals against forecasts

• Consistent inputs that made planning and review easier

• Fewer ad hoc questions and less manual reconciliation

• Better collaboration with finance and leadership

Most importantly, the team could focus on making thoughtful decisions instead of trying to piece together the information needed to make them.

From Structure to Confidence

This project reinforced something I care deeply about in operations work. You don’t need flashy tools to build effective systems. You need empathy for the people using them, clarity around what information matters, and enough structure to keep things on track as priorities shift.

Sometimes the most impactful work is simply being the glue that holds everything together.