# Annual Department Budget Template Excel

> Free Excel template for an annual budget by department: monthly phasing, actuals log, budget vs actual, variance, year-end forecast and over-budget alerts.

Source: https://softwiro.com/templates/annual-department-budget-tracker
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Annual Department Budget Template for Excel (Budget vs Actual)

A free annual department budget template for a finance manager, a department head, or a nonprofit or school administrator. You set each department's budget by account for the year and choose how it is spread across the months. You log what is actually spent, and the workbook shows budget vs actual for every line, every department and every month, with variance, percent used, a forecast to year end and a status that flags lines going over. A one-department view gives each head a page of their own. It opens in Excel, LibreOffice and Google Sheets, and works in any currency.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-annual-department-budget-tracker.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-annual-department-budget-tracker-blank.xlsx)

Excel file (.xlsx) · 168 KB · 10 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## Try the sheet here, on the example

The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.

## Example from the sheet

| Fiscal year | 2026 | As of | 46356 | Remaining budget | Change the year, the as-of date and the forecast method on Settings. |  |  |  |
| --- | --- | --- | --- | --- | --- | --- | --- | --- |
|  |  |  |  |  |  |  |  |  |
| Annual budget | 1,171,200.00 | Forecast vs annual (+ under, - over) |  | 24,301.00 |  |  |  |  |
| Budget to date | 1,069,836.00 | Departments over budget |  | 0 |  |  |  |  |
| Actual to date | 1,045,535.00 | Departments forecast over |  | 2 |  |  |  |  |
| Variance to date (+ under, - over) | 24,301.00 | Lines over budget |  | 3 |  |  |  |  |
| Share of annual budget used | 89.3% | Lines near limit |  | 4 |  |  |  |  |
| Forecast to year end | 1,146,899.00 | Lines forecast over |  | 2 |  |  |  |  |
| Largest department by spend | Programs | Actual rows to review |  | 0 |  |  |  |  |
| Department | Annual budget | Budget to date | Actual to date | Forecast year end | Month | Budget | Actual | Variance |
| Administration | 209,600.00 | 192,549.33 | 187,134.00 | 204,184.67 | Jan | 96,584.00 | 100,980.00 | -4,396.00 |
| Programs | 272,000.00 | 248,433.33 | 248,733.00 | 272,299.67 | Feb | 96,662.00 | 87,380.00 | 9,282.00 |
| Facilities | 202,000.00 | 184,033.33 | 184,371.00 | 202,337.67 | Mar | 97,086.00 | 95,900.00 | 1,186.00 |
| Fundraising | 147,000.00 | 131,520.00 | 109,704.00 | 125,184.00 | Apr | 96,740.00 | 89,980.00 | 6,760.00 |
| Technology | 172,000.00 | 158,750.00 | 165,264.00 | 178,514.00 | May | 97,164.00 | 92,760.00 | 4,404.00 |
| Communications | 105,000.00 | 96,250.00 | 95,436.00 | 104,186.00 | Jun | 97,048.00 | 88,980.00 | 8,068.00 |
| Volunteer Services | 63,600.00 | 58,300.00 | 54,893.00 | 60,193.00 | Jul | 93,808.00 | 88,880.00 | 4,928.00 |
|  |  |  |  |  | Aug | 97,472.00 | 85,330.00 | 12,142.00 |
|  |  |  |  |  | Sep | 98,436.00 | 101,565.00 | -3,129.00 |
|  |  |  |  |  | Oct | 99,206.00 | 117,680.00 | -18,474.00 |
|  |  |  |  |  | Nov | 99,630.00 | 96,100.00 | 3,530.00 |
|  |  |  |  |  | Dec | 101,364.00 | 0.00 |  |

Example from the “Dashboard” tab, with the numbers and formulas that are in the file.

## What is inside

- Dashboard: The summary for the finance office or the board: annual budget, budget to date, actual to date, variance, percent used, the year-end forecast, how many departments and lines are over or close, a list of the lines that need attention and three charts (by department, by month, and budget against forecast).
- Departments: One row per department with its head, annual budget, budget to date, actual, variance, percent used, forecast, forecast against the annual budget, a status and a count of lines over budget.
- Budget: The budget lines: a department, an account, the budget for the year and a phasing profile. It works out the twelve monthly budgets, the budget to date, actual to date, variance, percent used, what is left, the forecast and a status for each of up to 120 lines.
- Actuals: The log you type into: date, department, account, amount, vendor and a note. A Check column flags a row that cannot be counted. Room for 2,000 rows.
- Monthly: Budget by month, actual by month and variance by month for every department, with totals.
- Department View: Pick a department from a list to see only its lines, its monthly budget against actual and a chart.
- Phasing: The monthly profiles: Even, Front-loaded, Back-loaded, School year and one of your own. Each row must total 100%.
- Settings: Organization name, currency symbol, fiscal year, the as-of date, the forecast method, the warning level, and the lists of departments (with heads) and accounts.

The file opens on a start tab (“Start here”) that explains how to use it.

## What makes it different

Most department budget templates stop at a table of budget, actual and variance. This one adds the two things a department head actually asks: how much should have been spent by now, and where will we land in December. Each budget line can follow its own phasing, so a gala budget that falls in the autumn is not shown as underspent in March. The forecast can be the remaining budget or a run-rate, and you choose on one cell. The sample is a community center with seven departments and 30 lines, with spending to the end of November 2026.

## How do I make an annual budget by department in Excel?

List the departments, then list the accounts you spend on, such as salaries, supplies, travel, software and events. A budget line is one department plus one account with a figure for the year. On the Budget sheet you pick both from lists and type the amount. The sample has 30 lines that add up to 1,171,200 for the year, from 272,000 for Programs to 63,600 for Volunteer Services.

Then decide how each line is spread over the year. Salaries are even, insurance is paid early, a fundraising event falls in the autumn, a school spends little in July. Pick a phasing profile for the line and the monthly budgets are worked out. If your fiscal year does not start in January, treat the first month of the sheet as your first month and set the as-of date to match. Check your own rules for how a budget is approved.

## How do I compare budget vs actual by department?

Log each payment on the Actuals sheet with its department and account. The Budget sheet adds them up for the line, and the Departments and Monthly sheets add them up again by department and by month. Variance is budget to date minus actual to date, so a positive number is under budget and a negative number is over. In the sample, as of 30 November 2026, 1,045,535 has been spent against a budget to date of 1,069,836, which is 24,301 under, and 89.3% of the annual budget is used.

Looking at one department: Facilities has spent 184,371 against 184,033.33 budgeted to date, and its Repairs and maintenance line is at 33,400 against a 30,000 yearly budget after seven repair bills. Fundraising is well under (109,704 against 131,520) because its gala is budgeted late in the year with the Back-loaded profile.

## How do I forecast department spending to year end?

Pick the method on Settings. Remaining budget takes what has been spent so far and adds the budget still planned for the months left, so a line on plan lands on its annual budget and a line running ahead lands above it. Run-rate takes the average month so far and multiplies by 12, which suits steady costs such as payroll and software but not lumpy ones. With Remaining budget the sample forecast is 1,146,899; the same data on Run-rate gives 1,140,583.64.

Each line gets a status. Over budget means it has already spent more than the whole year. Near limit means it is at or above the warning level (95% in the sample). Forecast over means the forecast is above the annual budget. In the sample Repairs and maintenance, Technology software and Communications advertising are Over budget. For project work see [project budget tracking](https://softwiro.com/templates/project-budget-tracker) and for cash timing see [cash flow forecasting](https://softwiro.com/templates/cash-flow-forecast).

## How to use it

1. On the Settings sheet type the organization name, currency symbol, fiscal year, the "as of" date (use a month end), the forecast method (Remaining budget or Run-rate) and the warning level. Edit the list of departments (with the department head) and the list of accounts.
2. On the Phasing sheet check the monthly profiles. Even spreads a budget over 12 equal months; the others shift it to the front, the back or the school year. Each row must total 100%. Row 5 is Even; the last row is yours to edit.
3. On the Budget sheet add one row per department and account: pick the department, pick the account, type the budget for the whole year and pick a phasing profile. The twelve monthly budgets and the budget to date are worked out for you.
4. On the Actuals sheet add one row per bill or posting: date, department, account, amount, vendor and a note. The Check column tells you when a row cannot be counted.
5. Open Budget to see, for every line, actual to date, variance, percent used, the year-end forecast and a status. Departments and Monthly summarise the same numbers by department and by month.
6. Pick a department on Department View to see only its lines and months. Dashboard shows the totals, the lines that need attention and the charts.

**Before you start:**

- Capacity: 120 budget lines, 8 departments, 20 accounts, 2,000 actual rows, 5 phasing profiles.
- The sheet does not use TODAY(): type the as-of date on Settings. Months passed = the month of that date, so set it to a month end for a clean comparison.
- A budget line is a department plus an account. An actual row is counted only if its department and account match a budget line and its date is in the fiscal year; otherwise the Check column explains why.
- Variance = budget to date - actual to date, so a positive number is under budget and a negative number is over.
- Forecast to year end: Remaining budget = actual to date + the budget still planned for the months after the as-of date. Run-rate = actual to date / months passed x 12. Choose on Settings.
- Status: Over budget = actual is above the whole year. Near limit = actual is at or above the warning level. Forecast over = the forecast is above the yearly budget. Otherwise On track.
- Department View shows up to 15 budget lines for the chosen department.
- Use one currency in one workbook. The currency symbol on Settings is only a label.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-annual-department-budget-tracker.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-annual-department-budget-tracker-blank.xlsx)

Excel file (.xlsx) · 168 KB · 10 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## Still running this on Excel?

This sheet depends on someone entering journal entries accurately and reviewing them. In ProfAcc, double-entry postings are made automatically, periods are closed, and the financial statements are produced directly from the entries.

| In this sheet | In ProfAcc — Manufacturing Accounts |
| --- | --- |
| Changing any cell can alter the numbers of a period that has ended. | Correct double-entry from day one, with automatic posting and period closing that locks what has been closed. |
| Tax is calculated in one place and invoices live in another. | Every sales invoice calculates VAT within the journal entry that records it. |
| You only learn the stock balance after the month-end count. | Stock balances are live and move with every posting. |
| One file per company you serve, and the files can get mixed up. | Each company is created from a Google account in about a minute with nothing to install, its data is kept separate, and it is reached through its own link. |

[See ProfAcc — Manufacturing Accounts](https://softwiro.com/product/profacc) · [Ask for a demo](https://softwiro.com/contact)

## 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 |
| --- | --- |
| You type actuals into a log | Actuals come from the accounting records as they are posted |
| One finance person edits one file | Each department head has a login and sees only their own budget |
| A status flags a line after the fact | Spending above a limit needs approval first |
| Phasing is a list of percentages | Budgets follow your calendar, grants and funding rounds |
| The forecast is one of two formulas | Forecasts that include open orders and commitments |

### Extra features in the app

- Actuals post from the ledger, so nobody retypes them into a budget file
- Department heads see their own budget and spending, and nothing else
- Requests above a limit wait for approval before they are committed
- Budgets for several years and revisions kept side by side
- Month-end close that locks the period you have reviewed
- Reports for the board generated from the same data

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

## Frequently asked questions

### Is this department budget template free?

Yes. Download it, use it for your organization and change anything you like. There is nothing to sign up for to open the file.

### Does it work in Google Sheets and LibreOffice?

Yes. It uses ordinary formulas such as SUMIFS, COUNTIFS, INDEX and MATCH, so it works in Excel 2016 and later, LibreOffice and Google Sheets. In Google Sheets, upload the file to Drive and open it with Sheets.

### How many departments, budget lines and transactions can it hold?

8 departments, 120 budget lines, 20 accounts and 2,000 actual rows. Only rows dated in the fiscal year are counted, so you can start a new file for the next year.

### What is phasing and do I have to use it?

Phasing is how a yearly budget is spread over the months. Leave a line on Even for a flat 1/12 each month, or pick Front-loaded, Back-loaded or School year, or edit the Custom row. It changes the budget to date and the forecast, not the annual figure.

### Why is an actual not counted?

The Check column on Actuals says why: no amount, no date, no budget line for that department and account, or a date outside the fiscal year. Add the missing budget line or pick the department and account from the lists.

### Is the template free?

Yes, with no sign-up and no email address. Use it, edit it and share it as you like.

### Does it work in Google Sheets and on mobile?

The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.

### What is the difference between the white and the gray cells?

You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.

### Can I use the sheet from an AI assistant?

Yes. Add our MCP server (URL [https://softwiro.com/api/mcp](https://softwiro.com/api/mcp), no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: [https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html](https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html)

More free templates for: Accounting

## More free templates

- General Journal and Trial Balance Template for Excel
- Small Business Budget Template for Excel (Monthly)
- Cash flow forecast sheet
- Fixed assets register and depreciation sheet
- Accounting rules and equations summary sheet: double entry, statements and financial ratios
- Construction Project Tracker for Excel
- Production tracking sheet for home textiles factories
- Fabric requirements and marker sheet
- Customer accounts, credit sales and customer statement sheet
- Cash book and customer accounts sheet
- Student attendance sheet
- Study planner and lesson tracker
- Weekly study routine sheet

[All templates](https://softwiro.com/templates) · [Free tools](https://softwiro.com/tools)
