Finance & approvals
Department budget template: plan next year and track it monthly
A department budget sets out, line by line, how much a team expects to spend over the next financial year and why. Once approved, it becomes the yardstick for every spending request during the year and the baseline you compare actual spending against each month.
This free Excel budget template is built for small and mid-sized companies planning by team, department or project, not for personal or household budgets. It puts last year's actual spending next to next year's budget, calculates the change, records the assumptions behind each number, splits the total by quarter, adds a contingency line and includes approval fields and a monthly budget-versus-actual sheet.
What is a department budget?
A department budget is a planning document that answers four questions with numbers: what the money is for, why it is needed, how much, and when it will be spent. Lines follow your chart of accounts, such as payroll, advertising, travel, software subscriptions, training and client entertainment, and every line shows how it was calculated, for example headcount times rate or monthly cost times twelve.
Unlike a personal budget, a business budget is about approval and accountability. Each line has an owner, spending above the approved amount needs extra sign-off, and someone must explain the variance when actuals drift away from plan. That makes the budget a tool you open every month, not a file you submit once in December and forget.
When do you need a budget template?
- At year end, when each department submits its annual budget to the owner or finance team
- Before launching a project, product or campaign that needs its own ring-fenced funding
- At mid-year, when first-half results mean the second-half budget has to be re-forecast
- When an investor, lender or grant application asks for a spending plan
What the budget template includes
The download contains these fields in this order. Rename the account lines to match your bookkeeping; once you enter the amounts, totals and percentage changes calculate automatically.
Header and assumptions
| Field | What to enter | Example |
|---|---|---|
| Department or project | The team or project that will spend the money. | Marketing |
| Budget period | The financial year or project dates. | Jan 1 to Dec 31, 2027 |
| Prepared by and budget owner | Who wrote it and who is accountable for spending it. | Prepared by Priya Shah; owner Daniel Reyes |
| Key goals | The measurable outcomes this budget pays for; link them to your OKRs. | Grow qualified leads 30%; exhibit at 2 trade shows |
| Main assumptions | Headcount, pay rise, exchange rates and key unit prices used in the math. | Headcount flat at 4; 3.5% pay rise |
| Quarterly phasing | How the annual total is split across quarters. | Q1 24% / Q2 26% / Q3 22% / Q4 28% |
Budget lines
| Field | What to enter | Example |
|---|---|---|
| Account line | A cost category from your chart of accounts. | Advertising and marketing |
| Basis or assumption | The calculation behind the number. | Search ads $6,000/month + 2 trade shows × $15,000 |
| Last year actual | What was really spent on this line last year, not last year's budget. | $96,000 |
| Next year budget | The amount produced by the calculation. | $102,000 |
| Change and reason | Difference from last year in money and percent, plus a one-line reason. | +6.3%, one extra trade show |
| Capex flag | Mark purchases that become assets, such as equipment, so they are planned separately. | 2 replacement laptops → capex sheet |
Approval and monitoring
| Field | What to enter | Example |
|---|---|---|
| Approvals | Sign-off chain: preparer, department head, finance, owner or CEO. | Approved in e-approval on Dec 15, 2026 |
| Approved total | The final total after any cuts or adjustments. | $588,330 |
| Monthly actuals | Actual spending per line, entered every month. | January advertising: $7,850 |
| Variance | Budget minus actual, and the percentage of budget used so far. | Q1 spend at 92% of plan |
| Overspend rule | What happens when a line will exceed its budget. | Owner approval when a line runs 10% over |
| Review dates | When the budget is formally reviewed or re-forecast. | Quarter-end reviews; re-forecast in July |
Budget template example
A filled annual budget for a four-person marketing team. The figures are illustrative; each line shows its basis so the approver can check the math at a glance.
| Department | Marketing (4 people) |
|---|---|
| Budget period | Jan 1 to Dec 31, 2027 |
| Key goals | Grow qualified leads 30%; exhibit at 2 trade shows |
| Quarterly phasing | Q1 24% / Q2 26% / Q3 22% / Q4 28% |
| Budget owner | Daniel Reyes, Head of Marketing |
Budget by line
| Account line | Basis | Last year actual | 2027 budget |
|---|---|---|---|
| Salaries and benefits | 4 FTE, 3.5% pay rise | $412,000.00 | $426,420.00 |
| Advertising and marketing | Search ads $6,000 × 12 + 2 trade shows × $15,000 | $96,000.00 | $102,000.00 |
| Travel | 24 domestic trips × $650 + 2 international × $4,200 | $21,800.00 | $24,000.00 |
| Software subscriptions | 8 SaaS tools, $1,150 × 12 months | $12,600.00 | $13,800.00 |
| Training | $1,500 × 4 people | $4,200.00 | $6,000.00 |
| Client meals and entertainment | $700 × 12 months | $9,100.00 | $8,400.00 |
| Contingency | 5% of all non-payroll lines | $0.00 | $7,710.00 |
| Total | $555,700.00 | $588,330.00 |
The total rises from $555,700 actual last year to a $588,330 budget for 2027, an increase of $32,630 (5.9%). Most of the increase comes from the pay rise and the extra trade show; client entertainment is trimmed because only part of business meal costs is usually tax-deductible.
Free download
Free, no sign-up. Opens in Excel, Google Sheets, Numbers, Word, Google Docs and LibreOffice.
Open the downloaded file in Nobami, our web office, to edit it right away.
How to build a department budget
- Pull last year's actuals. Export real spending by account from your bookkeeping system or expense reports. Starting from actuals, not last year's budget, keeps the numbers grounded.
- Write down goals and assumptions first. Agree on next year's targets, headcount plan, pay rise and key prices before you fill in amounts. When an assumption changes, you can see which lines to update.
- Calculate every line from its basis. Avoid "last year plus 10%". Use quantity times rate or monthly cost times twelve, and attach quotes for new activities.
- Add contingency and phase by quarter. Hold back roughly 3–5% of the variable lines as contingency, and split the year so heavy months, such as trade-show season, show up in the right quarter.
- Get approval and lock the baseline. Route the budget through the department head, finance and the owner. Record any cuts and the reasons, so the approved figure is clear to everyone.
- Compare with actuals every month. Enter actuals at month end, check the variance and spend rate, and request extra approval early if a line is heading over.
Tax notes: deductible expenses in the US and UK
In the United States, business expenses are generally deductible when they are ordinary and necessary for your trade, but some budget lines have special rules. Business meals are usually only 50% deductible, and entertainment such as event tickets is generally not deductible at all, so budget them knowing part of the cost will not reduce taxable profit. The IRS page on deducting business expenses explains the main categories.
In the United Kingdom, client entertainment is not an allowable expense for Corporation Tax or self-assessment, while staff entertainment and training can be. Capital purchases such as equipment are handled through capital allowances rather than as a running cost, which is another reason to keep capex in a separate section of the budget. GOV.UK also lists finance and support schemes for small businesses, and the US Small Business Administration has a practical guide to managing business finances.
Sources
- IRS: Deducting business expenses (checked November 18, 2026)
- U.S. Small Business Administration: Manage your finances (checked November 18, 2026)
- GOV.UK: Business finance and support (checked November 18, 2026)
This is general information as of November 18, 2026, not accounting or tax advice. Deduction rules change and depend on your business structure, so check with your accountant before relying on them.
Common budgeting mistakes
- Copying last year's budget and adding the same 5–10% to every line, which locks in spending nobody has questioned
- Leaving out contingency, so every small surprise needs a budget transfer request
- Lines with no named owner, so nobody watches the spend rate
- Getting the budget approved and never comparing it with actuals until the year-end close
- Mixing capital purchases, such as laptops and machinery, with monthly operating costs, which distorts both depreciation and cash planning
Budget template FAQ
What is the difference between top-down and bottom-up budgeting?
Top-down means leadership sets a company-wide total and allocates it to departments. Bottom-up means each department builds its own request from detailed assumptions. Most small companies mix the two: the owner gives a target envelope, departments build bottom-up detail, and the gap is negotiated before approval.
When should we use zero-based budgeting?
Zero-based budgeting ignores last year's figures and makes every line justify itself from zero. It takes time, so many teams apply it only when costs need a hard reset or to lines that tend to creep upward, such as software subscriptions and advertising.
How should we handle an overspend?
Ask for approval before the money is spent, stating the amount and the reason. Record whether it is a transfer from another line that is underspent or an increase to the total; this keeps the year-end explanation simple.
How much contingency is reasonable?
There is no fixed rule, but 3–5% of variable costs is a common starting point. Using contingency should still need approval, otherwise it becomes free money.
How does the budget connect to monthly reporting?
Treat the approved budget as the baseline and report actuals, spend rate and variance reasons per line in each monthly report. In Workbami you can route the budget through e-approval and later review spending approvals and monthly reports for the same department.