KodjoFinance & Data
  1. Projects
  2. 2027 budget for a 12-person agency
Demo project · fictional data

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

  1. The owner enters the assumptions once a year.
  2. Each month, they drop the accounting export into the folder and refresh.
  3. The dashboard shows the drifting lines and the year-to-date total.

File extract

Budget_2027.xlsxExtract: April 2027 tracking
LineBudgetActualVarianceVariance %
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€00.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.