# Annual budget by department Excel (free)

> Free annual budget sheet by department and line: plan vs actual by month and year to date, revenue and expenses, over-budget alerts and a year forecast.

Source: https://softwiro.com/blog/annual-budget-departments-free-excel-online.html
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Annual budget by department in Excel (free): plan vs actual

Set a plan per department and line, log actuals, and see who is over budget and where the year will end.

13 November 2026 5 min read

## In short

- Plan each department and line over 12 months, then log actuals with date, department, line and amount.
- Compare plan and actual by month and year to date, per department and per line, for revenue and expenses.
- Positive variance is always in your favor; alerts flag departments and lines over plan and entries with no plan.
- Full-year forecast = actual to the chosen month + the remaining plan.

Halfway through the year, or near its end, you want to know which department has overspent its budget, which line is draining it, and where the year will land if spending continues like this. The free [annual budget by department sheet](https://softwiro.com/templates/annual-budget-departments) answers that: you set a plan per department and budget line over 12 months, log the actuals, and the sheet compares them by month and year to date and forecasts the year end.

## The problem it solves

A budget written in January and forgotten until December helps nobody. When each manager speaks about their department with different numbers, management cannot tell who overspent and who saved. You need one plan with the same names and lines, actuals recorded once, and a comparison that updates whenever you add an entry.

## How the sheet works, step by step

1. In Settings you type the year, the month you compare up to, and the alert percentages for expenses (near the limit) and for revenue.
2. In Lists you type your departments or cost centers and your budget lines, with each line's type: revenue or expense.
3. In Plan you add a row per department and line and type the planned amount for each month. The sheet totals the year and warns if a row is duplicated.
4. In Actual you log each transaction: date, department, line and amount. If the department or line is not in the lists, or has no plan, the row gets a warning.
5. You read By department and By line to see, for each, the period plan, actual, variance, spending percentage and status, and Departments monthly and Lines monthly for the detail of each month.
6. You open Budget summary for revenue, expenses, net, alerts and the year forecast.

## What each sheet holds

- Budget summary: revenue, expenses and net to the chosen month and for the full year with its forecast, the number of departments and lines over plan, the biggest overspenders, a monthly table, and four charts.
- By department and by line: one table for expenses and one for revenue, with the yearly plan and forecast.
- Departments monthly and Lines monthly: plan, actual and variance for each month.
- Plan, Actual, Lists and Settings: the sheets you type in.

## Walk-through on the sample numbers

This is sample data, not a real company: eight departments and ten lines, compared up to the end of October 2026 (month 10), plus a few early November entries that do not count in "to the chosen month":

- Expenses: plan to October 4,628,000, actual 4,598,230, a spending rate of 99.4%, with 29,770 variance in your favor. But two departments overspent: Marketing spent 749,200 against a plan of 700,000 (107.0%) and Operations 1,277,030 against 1,270,000 (100.6%). Administration is "near the limit" at 97.5%.
- Why: by line, "Advertising and marketing" is 457,000 against 400,000 (114.2%), "Maintenance" 159,550 against 140,000 (114.0%) and "Travel" 114,870 against 110,000 (104.4%). Marketing also has a 1,200 travel expense with no plan, which the sheet flags in yellow.
- Revenue: plan 5,379,000, actual 5,201,740 (96.7%), which is 177,260 short. "Product sales" is below plan at 95.2% while "Service revenue" met its plan (102.6%).
- Net: plan 751,000, actual 603,510, so the variance is 147,490 against the plan.
- Full year: plan revenue 6,685,000, expenses 5,596,000, net 1,089,000. The forecast (actual so far + remaining plan) is revenue 6,507,740, expenses 5,566,230 and net 941,510, which is the same 147,490 below plan.

The practical reading: Marketing and Operations need a decision before November, either cutting the rest of their advertising and maintenance or formally revising the plan. Sales should review product revenue.

## Why it helps

- Plan and actual with the same names: no manual matching between the manager's file and the accountant's.
- Month and year to date together: you see whether an overspend is a one-month blip or a build-up over the year.
- Both revenue and expense sides: you do not judge a department on cost alone if it earns revenue.
- Year-end forecast: it turns current numbers into a decision: change the plan or change the spending?
- Works in Excel 2016 and later, Google Sheets and LibreOffice, free with no sign-up.

## Common mistakes

- Logging actuals under names that differ from the plan: pick department and line from the list so they match.
- Mixing positive and negative variance: positive is always in your favor, plan minus actual for expenses and the reverse for revenue.
- Comparing actual with the full-year plan mid-year: compare it with the period plan, and use "consumed of the year" to see what is left.
- Forgetting a line you never planned: the "no plan" warning tells you; add a plan row or correct the department.
- Leaving the chosen month stale: change it in Settings every month.

## When to move to a system

The sheet suits a small or mid-sized company whose accountant collects numbers from departments and types them in. When invoices and payments multiply and become hard to carry over, [Accountwiro](https://softwiro.com/systems/budoor.html) records the invoice and the payment at the moment they happen and shows each customer's balance in one statement. If what matters now is the monthly expenses of one business, see the [business expenses and budget sheet](https://softwiro.com/templates/business-expenses-budget).

## Frequently asked

**How many departments and lines fit?** Twelve departments, twenty lines, 300 plan rows and 2,000 actual entries.

**Do I need a full year of actuals?** No. Choose the month you compare up to and the tables count up to that month.

**Can one department have revenue and expenses?** Yes; it shows in both tables according to the types of lines planned for it.

## Your next step

Open the [sheet](https://softwiro.com/templates/annual-budget-departments), type your departments and lines, copy this year's plan into the Plan sheet, then log last month's actuals and see which department goes over first.

## Free cheat sheet for this field

Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.

[![Cheat sheet: annual budget by department (1/3)](https://softwiro.com/uploads/cheatsheets/annual-budget-departments/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/annual-budget-departments/en-1.jpg)[![Cheat sheet: annual budget by department (2/3)](https://softwiro.com/uploads/cheatsheets/annual-budget-departments/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/annual-budget-departments/en-2.jpg)[![Cheat sheet: annual budget by department (3/3)](https://softwiro.com/uploads/cheatsheets/annual-budget-departments/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/annual-budget-departments/en-3.jpg)

0 downloads · 3 pages

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| One file that one person edits at a time, and copies travel by WhatsApp. | A program with a login for each user and permissions you set; everyone sees the same data live. |
| You type and check every number by hand, and one wrong cell breaks the result. | Screens built around your steps: each person records only their part, and the calculations run on their own. |
| Limited size; the file slows down as the data grows. | Holds years of data without slowing down, with instant search and filters. |
| Fixed columns and reports, as the sheet was designed. | Reports, alerts, printing and WhatsApp built around how you work. |
| Backups and security are your own responsibility. | A secured server with automatic backups and a log of who changed what and when. |

### Extra features in the app

- A login for each user with permissions, and a log of who changed what and when
- Automatic reminders and alerts by WhatsApp and email
- Photos, files and documents kept with each record
- Instant search and filters, with reports exported to PDF and Excel
- Works from a phone anywhere, with automatic backups

[Ask for your custom system](https://softwiro.com/contact)

## Questions this raises

### How are spending percentage and variance calculated?

Spending percentage = actual divided by the period plan. A positive variance is in your favor: plan minus actual for expenses, actual minus plan for revenue.

### How does the sheet forecast the year end?

Year forecast = actual to the chosen month + the plan of the remaining months, so any overspend so far carries into the forecast.

### Can a department have both revenue and expenses?

Yes. It appears in the expense table and the revenue table according to the types of lines planned for it.

### What if I log an expense for a department and line with no plan?

The row shows a "no plan for this department and line" warning. The actual still counts in the department and line totals, so add a plan row if it is intended.

## Have a system to build?

Softwiro designs, builds, and operates production systems. Describe what you need and we will come back with a scope rather than a slogan.

Start a project

[All writing](https://softwiro.com/blog.html)
