Kolumn

07 / 20 · Budget and finance

Business budget vs. actual

Budget, actuals and variance by month and year to date.

SEK 129

Incl. 25% Swedish VAT. Buyers outside the EU and EU businesses with a valid VAT number pay 20% less.

Also part of the bundle with all 20 templates for SEK 499. All 20 templates

Middle Earth Consulting AB contributes 1% of your purchase to removing carbon dioxide from the atmosphere.

What it does

Set the budget for the year month by month, enter the actuals when each month closes and see the variance straight away – per month and year to date.

What you get

Sheets
Budget, Actual, Variance
Each file also has an instructions sheet and a lists sheet.
Formulas
114
Files
2 × .xlsx: English and Swedish
Works in
Excel (Windows, Mac, web), Google Sheets, LibreOffice
Macros
None
Licence
One licence per business or household, unlimited internal users

Screenshots

English version with example data
English version with example data
Swedish version with example data
Swedish version with example data

How to use it

  1. Fill in the budget on the Budget sheet.
  2. Enter the actuals on the Actual sheet (from your bookkeeping) as each month closes.
  3. Choose the latest closed month (1–12) on the Variance sheet to see year to date.
  4. A positive variance on income and a negative one on costs is good.