- Projects
- 2027 budget for a 12-person agency
2027 budget for a 12-person agency
Line-by-line budget over 12 months, actuals imported in one click, variances in euros and percent. Any line more than 5% over budget turns orange.
- Excel
- Power Query
- Variance alerts
The context
A fictional 12-person communications agency. Its budget lived in a spreadsheet sent once a year by the accountant, and nobody compared it with actual spending.
The problem
Overspending only showed up in the year-end accounts, too late to act. In April, subcontracting on a large project pushed costs more than 10% over budget and nobody noticed.
What I built
- A monthly budget by line, with editable assumptions: salaries, rent, subcontracting, software.
- A Power Query import that loads the monthly accounting export in one click.
- A tracking tab comparing budget and actuals, in euros and percent, monthly and year to date.
- A colour alert as soon as a line runs more than 5% over budget.
How it works
- The owner enters the assumptions once a year.
- Each month, they drop the accounting export into the folder and refresh.
- The dashboard shows the drifting lines and the year-to-date total.
File extract
| Line | Budget | Actual | Variance | Variance % |
|---|---|---|---|---|
| Salaries and payroll taxes | €48,000 | €48,400 | +€400 | +0.8% |
| Subcontracting | €9,000 | €14,600 | +€5,600 | +62.2% |
| Rent | €3,200 | €3,200 | €0 | 0.0% |
| Software | €1,800 | €2,050 | +€250 | +13.9% |
| Travel | €2,000 | €2,750 | +€750 | +37.5% |
| Total | €64,000 | €71,000 | +€7,000 | +10.9% |
Orange cells: line more than 5% over budget.
Got a project in mind?
Describe what you need in a few lines. I reply within 24 hours with a call proposal.