ValteraTools CFO services
  1. Valtera
  2. Tools
  3. Excel templates
  4. Budget vs actual
Excel template · Budget

Budget template: plan vs actual

Enter the annual plan month by month and add actual figures at the end of each month. The template calculates variances for the month you choose and for the year to date.

Updated:
Valtera_Budget_vs_actual_EN.xlsx · 15 KB · Sheets: Guide, Plan, Actual, Variance
Format: .xlsx · Excel, Google Sheets, LibreOffice · No sign-up required
Other languages: Azerbaijani · Russian
Valtera_Budget_vs_actual_EN.xlsx — Variance · Preview with sample data
Month (1–12)9
Line itemPlanActualVarianceVariance %Plan YTDActual YTDVariance YTD
Revenue100,000104,5004,5004.5%811,000806,500(4,500)
Cost of sales58,00061,8003,8006.6%470,380481,10010,720
Gross profit42,00042,7007001.7%340,620325,400(15,220)
Payroll and contributions15,00015,2002001.3%129,000129,800800
Rent and utilities3,2003,200-0.0%28,80029,650850
Marketing2,5002,6001004.0%22,50024,4001,900
Other expenses3,0003,1001003.3%27,00028,4001,400
Total expenses23,70024,1004001.7%207,300212,2504,950
Profit18,30018,6003001.6%133,320113,150(20,170)

What the template includes

  • Plan sheet: revenue, cost of goods, expenses and profit for 12 months.
  • Actual sheet: the same structure for actual figures.
  • Variance sheet: choose a month to see plan, actual, variance and percentage for the month and the year to date.

The sign of a variance is read by line item: a negative variance in revenue and a positive variance in expenses are unfavourable and highlighted in red.

A plan vs actual routine

  1. Close the previous month's actuals by the 5th.
  2. Write down the reason for variances above 10%: price, volume, a one-off event.
  3. In the meeting with management, discuss only significant variances and actions.
  4. Once a quarter, update the forecast for the rest of the year.

For one-page indicators: KPI dashboard.

Let us run the numbers

Valtera keeps the books and tax records of small and mid-sized companies and, as an outsourced CFO, takes responsibility for revenue growth and cash flow.