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

FieldWhat to enterExample
Department or projectThe team or project that will spend the money.Marketing
Budget periodThe financial year or project dates.Jan 1 to Dec 31, 2027
Prepared by and budget ownerWho wrote it and who is accountable for spending it.Prepared by Priya Shah; owner Daniel Reyes
Key goalsThe measurable outcomes this budget pays for; link them to your OKRs.Grow qualified leads 30%; exhibit at 2 trade shows
Main assumptionsHeadcount, pay rise, exchange rates and key unit prices used in the math.Headcount flat at 4; 3.5% pay rise
Quarterly phasingHow the annual total is split across quarters.Q1 24% / Q2 26% / Q3 22% / Q4 28%

Budget lines

FieldWhat to enterExample
Account lineA cost category from your chart of accounts.Advertising and marketing
Basis or assumptionThe calculation behind the number.Search ads $6,000/month + 2 trade shows × $15,000
Last year actualWhat was really spent on this line last year, not last year's budget.$96,000
Next year budgetThe amount produced by the calculation.$102,000
Change and reasonDifference from last year in money and percent, plus a one-line reason.+6.3%, one extra trade show
Capex flagMark purchases that become assets, such as equipment, so they are planned separately.2 replacement laptops → capex sheet

Approval and monitoring

FieldWhat to enterExample
ApprovalsSign-off chain: preparer, department head, finance, owner or CEO.Approved in e-approval on Dec 15, 2026
Approved totalThe final total after any cuts or adjustments.$588,330
Monthly actualsActual spending per line, entered every month.January advertising: $7,850
VarianceBudget minus actual, and the percentage of budget used so far.Q1 spend at 92% of plan
Overspend ruleWhat happens when a line will exceed its budget.Owner approval when a line runs 10% over
Review datesWhen 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.

DepartmentMarketing (4 people)
Budget periodJan 1 to Dec 31, 2027
Key goalsGrow qualified leads 30%; exhibit at 2 trade shows
Quarterly phasingQ1 24% / Q2 26% / Q3 22% / Q4 28%
Budget ownerDaniel Reyes, Head of Marketing

Budget by line

Account lineBasisLast year actual2027 budget
Salaries and benefits4 FTE, 3.5% pay rise$412,000.00$426,420.00
Advertising and marketingSearch ads $6,000 × 12 + 2 trade shows × $15,000$96,000.00$102,000.00
Travel24 domestic trips × $650 + 2 international × $4,200$21,800.00$24,000.00
Software subscriptions8 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
Contingency5% 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

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.
  6. 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

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.

Submit this form for approval in Workbami

Stop emailing spreadsheets around. Fill in, approve and file it in Workbami, where approvals, reports and team chat live together. Free during the beta.

Start free

Related templates

← All templates