Procon Case Study

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 hours every week.

The quick details

Challenge

  • Custom, headcount-driven budget model the accounting system couldn’t support
  • Excel formulas breaking without warning, caught after the fact
  • No reliable version of truth across linked workbooks and multiple contributors
  • Permission and sharing headaches every time a file went out
  • No affordable tool that could hold a custom model without enterprise pricing

Solution

  • Budgyt configured around Procon’s headcount-first budgeting process
  • Need-to-know user permissions without rebuilding files
  • Familiar, Excel-like experience for fast team adoption
  • Cost-effective against every alternative evaluated
  • Flat-file uploads with data mapping aligned to the accounting system

Results

  • Budget-versus-actual comparison from uploaded actuals
  • Rolling forecasts the team couldn’t run before
  • Drill-down to detail level, with reporting by division, dimension, and account
  • Easy data export, a major pain point with the accounting system
  • Balance sheet and executive board dashboard adopted as new features shipped
  • Time given back across the budgeting cycle
The Challenge

Spreadsheets you can't trust, and can't safely share

“Sometimes the formula is broken and you don’t know about it. You have so many different versions, you don’t know which one is the final version.”

When your budget runs on headcount and utilization, the tool has to fit the model. Most don’t.

Before Budgyt, Procon’s budget was a spreadsheet problem hiding as a finance process. Jenny and her team were dealing with challenges in multiple places at once:

  • Formulas that broke silently. A formula would go wrong and nobody would catch it. With inputs from different people and workbooks linked across files, Jenny couldn’t be confident the numbers were accurate.
  • Version chaos. Changes here, inputs there, and suddenly no one could say which workbook was the final version.
  • Sharing unknowns. Collaboration meant risk when sharing spreadsheets. Can you hide a tab, or do you have to rebuild the whole thing just to share one piece of it? Excel had no clean answer.

Underneath it all was a structural gap: Procon’s accounting system doesn’t do budgets, which is why the finance teams fell back to Excel in the first place.

Jenny needed a dedicated tool that sat outside the accounting system, didn’t cost a fortune, and made the data easy to access – without risking broken budgets.

The Solution

Excel's familiarity, without Excel's fragility

“It almost works like an Excel spreadsheet, but so much better, because you can set up user permissions. It’s very customizable based on our needs.”

It was the combination of cost-effectiveness and a tool that felt like Excel but behaved far better that drew Jenny to Budgyt. Three things made it click:

  • Permissions that actually protect the budget. Each contributor sees only what they need on a need-to-know basis – no more hiding tabs or rebuilding files to share safely.
  • A model built around her methodology. Jenny worked directly with Budgyt to customize the platform around her headcount-driven, bottom-up approach. Anything she’d been doing manually, we set up in the system for her.
  • Upload, map, and drill down. Jenny’s team can load a flat file, map it to Budgyt during onboarding, and from there can drill into detail, pull financials by division, by dimension and by account… seamlessly.

Adoption beyond the finance core was easy. When Jenny shared the tool with her teams, the reaction was simple: “this is amazing, this is so easy, you just upload a file.”

This visibility – and ease of use – was a sharp contrast to how hard it had been to get data out of their accounting system.

The Results

One tool. One transformational experience.

“It has been a transformational experience. Budgyt is saving so much of my time.”

Three years in, Jenny uses Budgyt to:

  • Work with actuals, not just plans. She uploads actuals, runs side-by-side comparisons, and builds rolling forecasts – none of which were easy to do inside their accounting system.
  • Get data out, fast. The ease of pulling information back out of the system is what makes Budgyt “such an awesome tool.”
  • Grow into new features. Since she joined, Budgyt has added a balance sheet and an executive board dashboard, and visualizations that are “really impressive.”

Her next goal is to present board-ready dashboards straight out of Budgyt instead of rebuilding them by hand.

Cost stayed firmly on the right side of the ledger too. Looking at other platforms, Jenny found them far more expensive. Budgyt, by contrast, “is very cost-effective and does what I need it to do. The perfect tool for me.”

Alongside the features and cost-effectiveness, it’s the people and the support who make Budgyt what it is. Working directly with founder and CEO James McCoy, Jenny says “he knows the system inside out” and is a genuine source of comfort, repeatedly turning her manual workarounds into something the system just does for her.

If you're still using Excel as your budgeting tool, that's definitely not ideal. There's a better tool, more cost-effective - and the experience is transformational. It works like Excel, but it's so much better.

Jenny Wang, VP of Finance
Latest Case Studies

Confident Finance Leaders. Risk-free results

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

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
Texas Stars, American Hockey League

Texas Stars, American Hockey League

Missing links put on...

Read more
United Way

United Way

Giving back time to...

Read more