It's budget season. The finance lead opens "Budget_2027_v7_FINAL_rev.xlsx", sales is working from v6 with their own numbers, and total costs don't match what operations sent over. If you run budgeting and forecasting in Excel, you've probably lived this moment: spreadsheets are flexible and familiar, but once they become the backbone of financial planning they carry risks you only notice when it's too late.
Below are the six most common risks for a finance team, each with a practical fix you can apply right away. At the end, we'll look at when it makes sense to go one step further.
Why Excel budgets are everywhere (and why they break)
Excel is the natural place to plan: cost lines in rows, months in columns, a few formulas for totals. Everyone knows how to use it, and you can start in minutes.
Trouble starts as the business grows. The budget model expands from one sheet to ten, from one person to five departments, from one assumption to three scenarios. At that point the file is no longer a calculation: it's a small financial planning system held together by hand. And like any improvised system, it has predictable weak spots.
Risk 1: formula errors nobody catches
A SUM range that misses the row added last week. An absolute reference copied where a relative one was needed. A number typed over a formula "just this once". These are small mistakes, but in a forecast they ripple through every month that follows.
The spreadsheet won't warn you. The figure looks plausible, so it gets approved.
The practical fix:
- keep input cells (color-coded) separate from calculated ones, and lock the calculated cells;
- add check rows that compare row and column totals;
- never hard-code assumptions inside formulas: growth rates and percentages belong on a dedicated sheet.
Risk 2: multiple versions of the same budget
"v3", "v3_mark", "v4_final", "v4_final_ok". When the file travels by email or sits in shared folders, every department ends up with its own copy. When it's time to close, nobody is sure which one is right.
We covered the broader issue in Sharing business files by email: the risks nobody considers. With a budget it's worse, because each version encodes different financial decisions.
The practical fix: keep a single master file in one location, with a strict naming rule. Contributors don't send copies back: they fill in their own section of the master within an agreed time window.
Risk 3: manual consolidation of department figures
A company budget is built from sales, purchasing, headcount and production numbers. In Excel that usually means collecting several files and pasting values into a summary sheet. Every paste is a chance to go wrong: a shifted column, a skipped month, a file updated after consolidation.
The practical fix:
- give every department the same template (same columns, same lines, same order);
- lock the template's structure so people can only enter values;
- link the summary to the source data with formulas or queries instead of pasted values;
- before closing, reconcile each department's totals against the consolidated view.
Risk 4: uncontrolled access to sensitive data
Budget files hold sensitive information: payroll costs, margins by customer, investment plans. Yet the file is often open to anyone who can reach the folder, and Excel's password protection was never designed as real access control.
So the person who should only see their department's costs can also see salaries, and anyone can change a key assumption.
The practical fix: split sensitive data into separate files, tighten folder permissions, and keep an up-to-date list of who can view and who can edit. If personal data is involved, see also Excel and GDPR: the risks of client data in shared spreadsheets.
Risk 5: assumptions that change without a trail
In March, the revenue forecast moves by 10%. Who changed the assumption, and why? In Excel the answer is often "no idea". Without a record of changes, explaining the gap between budget, forecast and actuals to management or the bank becomes painful.
The practical fix:
- keep an "Assumptions" sheet logging date, author and reason for every change;
- freeze a read-only copy of each approved forecast (end of quarter, end of half-year);
- compare each new forecast with the previous one, not just with the original budget.
Risk 6: relying on one person
Many budget models are built over years by the same person: macros, hidden sheets, external links only they understand. When that person is on holiday, changes role or leaves, the model turns into a black box nobody dares to touch.
The practical fix: document how the file works (where data comes from, what each sheet calculates, which macros exist), remove unnecessary external links, and make sure at least one other person runs the full budget cycle.
When good habits aren't enough
These fixes reduce the risk, but they depend on constant discipline: everyone following conventions, manual checks, someone keeping watch. The more departments and scenarios you add, the more that discipline costs you, as we explain in The hidden cost of Excel.
The telltale sign: you spend more time checking that the numbers are consistent than actually analyzing them.
Nitor: your budget model, without the limits of a file
Nitor starts from the Excel file you already use and turns it into an online business app, hosted and maintained by Nitor. Your logic stays the same; what changes is how the data is handled:
- one up-to-date version: no more departmental copies, everyone works on the same data;
- real-time collaboration: sales, purchasing and operations enter their numbers at the same time, with no manual consolidation;
- users and permissions: each person sees and edits only what they should, starting with payroll data;
- cloud data with backups: your budget no longer lives on someone's laptop or in someone's folder;
- extensions: add features as your planning process grows.
If you're weighing the move, Replacing Excel in finance: when it pays off and how to do it walks through a practical path.
In short
Budgeting and forecasting in Excel works while the model is small and one person owns it. Once several departments and scenarios are involved, six risks keep coming back: formula errors, multiple versions, manual consolidation, uncontrolled access, untracked changes and reliance on a single person.
Clear rules, checks and documentation will reduce them. But when maintaining the file takes more effort than analyzing the numbers, it's time to give your planning process a tool built for teamwork.