League of California Cities Case Study

League of California Cities

The League of California Cities cut a month off annual budget approval and reduced variance analysis by 30-40%.

About You

The League of California Cities is a nonprofit organization supporting and advocating for the interests of California’s 483 cities.

I am the Chief Financial Officer at the league. I own the budget and forecasting process, in concert with 6 other department heads, our CEO, and the Board of Directors.

Three members of the Finance team, 1 HR lead, 6 department heads, and 4 other managers are the key staff developing and maintaining annual budgets and updates.

Before Budgyt

Budgeting was driven by a complex Excel spreadsheet with many tabs and links.

Difficulties in the previous “system”

  • Risk of broken spreadsheet links – had to take extra caution to be sure any formula changes or location changes didn’t change essential calculations or invalidate links and formula ranges
  • Difficulty in tracing budget components back to their ultimate source
  • Ownership of updates had to be strictly controlled; budget managers (who knew their operations but were not Excel savvy) were not allowed to make updates, but had input sheets that were manually transferred to budget workbooks. It created a bottleneck where a small number of budget leads were manually touching all budget updates and changes
  • It was clunky, unwieldy, overly complex, antiquated
  • Salary allocations across programs were extremely difficult – initial allocations and especially updates

I had implemented Budgyt at my previous organization, so I knew immediately the best way to handle the Cal Cities FP&A shortcomings. At the previous stop, I knew an FP&A upgrade was necessary due to complaints about using the Excel-based, check-out / check-in, manual process for annual budgets.

Choosing Budgyt

I did an online search for FP&A tools and conducted my own needs assessment and evaluation of options.

Yes, other tools were considered. Budgyt seemed to have a fairly easy and straightforward implementation path, especially compared to some of the other more complex packages. Budgyt might not have all the same features of the more complex packages, but it had all that we need given our size and structure.

Competitive price, ease of use, broad functionality/configurability, ease of implementation, and online ratings all played a major role in us selecting Budgyt.

Getting Started

Onboarding and implementation were quick and simple. We provided a sample layout of our key financial statements, our chart of accounts, other accounting information (i.e. department/class/project structure, fiscal year, and our data structure). Budgyt set up the environment, the financial statements matching our existing format, and provided a template for the upload of budget and finance data.

Having used Budgyt previously, I was very quickly up and running. Other department heads embraced and adopted it right away, with a minimal learning curve supplemented by very good support from Budgyt and some collaborative sessions with me. I’d say the stronger department heads were functionally proficient in basic use (navigation, dashboard functionality, budget entry, notes) within 5-10 hours of using the product.

The general sense among the department heads is captured in comments like:

  • I love the comparison features
  • The flexibility is outstanding
  • Drilling down to get to transaction details is something we’ve never had before; love it
  • This is so much quicker and more intuitive than the prior process
  • This tool allows so much more operational visibility; very helpful

Results

Changes:

  • Getting better at utilizing the product
  • Better buy-in among department heads as they get more comfortable with the tool and its capabilities
  • I stopped having to ask our AP accountant for vendor or payment information, since it’s all contained in Budgyt and easily searchable (not reports by vendor per se, but the ability to see individual transactions)
  • I hardly ever sign in to our accounting system for ad hoc reporting or analysis, as I do almost all reporting and analysis out of Budgyt. The accounting system is still the system of record, and the source for audit materials. But management reporting, interim reports, Board reporting, etc. are much easier in Budgyt
  • The whole organization feels less stress about the annual budget process
  • Profit and loss at the individual project level (i.e. annual conference, city managers conference, website ad sales) became possible; impractical or onerous to track at that level previously

Time Saved:

  • I was able to shave a month off the annual budget approval process from Year 1 to Year 2 using Budgyt. Probably saved close to 3 weeks, even in Year 1, compared to the last year in the Excel method
  • Reduced the time to complete detailed variance analysis by 30-40%
  • Researching individual transactions is essentially real-time now, rather than a 10 or 15-minute conversation to track it down
  • Export features make the setup for analysis in Excel much quicker; maybe a 50% improvement in detailed analysis compared to using our accounting system exports

Surprises:

  • Initial surprise over how much functionality Budgyt delivers for a competitive price
  • How useful the search feature is to find a specific vendor invoice amount or expense item (for instance, using a board member’s last name pulls all their travel entries); or finding which departments use a specific vendor (i.e. Office Depot); or to see where an infrequently-purchased service was coded in the past
  • Great flexibility of the salary allocation function, including benefits costs; we allocate at a project level, and the setup is flexible enough to handle sometimes up to 15 separate allocations for a single employee
  • How useful it is to have multiple versions of scenarios. For instance, I take a snapshot at key interim periods that is used in Board reporting. I can always go to that snapshot to recreate or research results; without that snapshot, it wasn’t always easy to reconcile back to interim Board financials due to entries that come in after the snapshot was pulled.

Budgyt is absolutely worth it. Very competitive cost, great ease of use, quick and nearly painless implementation, intuitive use, flexible import and export function, rich in features, flexible, stable cloud environment, useful search feature, strong cost allocation functions, and excellent support from the Budgyt team.

Steve Maciel, Chief Financial Officer

Looking Ahead

We’ll continue to build out and gain more familiarity with Budgyt. With more years of history, trending analysis becomes more possible.

I want to load more past years’ annual results into the system as we transition off an older, desktop-based accounting system. Accounting records will be available via archive, but access will be much easier in Budgyt.

I was not able to try out the Visualizations and advanced reporting features that were available for a trial period. Might be interesting to see how those work.

We have some passthrough transactions that would be ideal for the “Function of another” calculation, but due to time pressure, I just manually calculated and recalculated those.

Latest Case Studies

Confident Finance Leaders. Risk-free results

See how finance teams ditched Excel chaos for bulletproof budgets and slept easier, every night.

League of California Cities

League of California Cities

The League of California Cities cut a month off annual budget approval and reduced variance analysis by...

Read more
The firm nonprofits call when Excel finally breaks

The firm nonprofits call when Excel finally breaks

How an employee-owned finance consultancy made Budgyt the backbone of its practice, rolling it out over a dozen...

Read more
From #REF! errors to defendable numbers

From #REF! errors to defendable numbers

How a finance leader at an AEC consulting firm swapped Excel anxiety for budgets that simply work, saving multiple...

Read more