Costs and pricing
Part of Finance content budgeting in England: separate cost views
A finance creator budget template that keeps commitments and cash dates apart
Use a finance-creator budget template that separates commitments, cash dates, recoverable VAT, staff time, economic cost and scenario changes.
A finance creators budget template should answer three questions without mixing them: what has been committed, when cash moves and what resources the work consumes. Use separate columns for VAT and internal time, then keep low, working and high scenarios alongside actuals.
This template was prepared on 5 September 2026 for an England-based business. Its sample values are hypothetical arithmetic, not market prices, recommendations or recorded results. Tax and accounting treatment must be reviewed for the actual entity.
What to take away
- Keep commitments, cash dates and resources in separate views so the template never mixes them.
- Use low, working and high scenarios beside actuals, and never vary every row by the same percentage.
- Give contingency a release rule tied to a documented scope change and a named budget owner.
- Reconcile forecasts with invoices, payroll and recorded hours at least weekly rather than overwriting them.
Set up the input sheet
Give every line these fields:
Input sheet fields
- Cost ID, work package, owner
- Supplier or internal team
- Quantity, unit, dated source
- Net amount, VAT paid, recoverable assumption
- Order, invoice, payment, service dates
- Committed, forecast or actual status
- Low, working and high quantity
| Column | What goes in it | Worked example |
|---|---|---|
| Cost ID | Unique line reference | C-014 |
| Work package | Deliverable group | September video set |
| Owner | Named budget owner | A. Patel |
| Supplier or team | Payee or internal team | Freelance editor |
| Quantity | Number of units | 4 |
| Unit | Unit of measure | Finished video |
| Dated source | Quote or contract date | 2 Sep 2026 |
| Net amount | Amount before VAT | £750 |
| VAT paid | VAT on the invoice | £150 |
| VAT recoverable assumption | Expected reclaim | 20% if VAT-registered |
| Order date | When work was committed | 3 Sep 2026 |
| Invoice date | When the invoice arrives | 28 Sep 2026 |
| Payment date | When cash leaves | 12 Oct 2026 |
| Service date | When work is delivered | 30 Sep 2026 |
| Status | Committed, forecast or actual | Committed |
| Low | Low scenario quantity | 3 |
| Working | Working scenario quantity | 4 |
| High | High scenario quantity | 6 |
| Notes | Cancellation, renewal and currency | GBP, 30-day terms |
Link a quote, contract, payroll report or assumption note. Never type a total without its units. Lock the formula cells and keep manual overrides visible.
Split the outputs into three views
The commitment view shows signed orders and unavoidable minimum terms. The cash view shows gross payments and expected receipts by date. The economic view adds internal labour and other resources used, while removing recoverable VAT only where that treatment has been checked.
HMRC says a VAT-registered business can reclaim VAT on qualifying business purchases subject to evidence and restrictions. Its business-expense guidance also covers mixed use and exempt supplies. The standard VAT rate is 20% for most goods and services, with reduced and zero rates for some items.
For employees, bring in allocated gross pay and the applicable on-costs rather than a guessed uplift.
For 2025-26, employer secondary Class 1 NICs were 15% on earnings above a £5,000 secondary threshold. Automatic enrolment minimum contributions were 8% of qualifying earnings, with at least 3% from the employer, on earnings between £6,240 and £50,270.
HMRC publishes current employer rates and thresholds. Add pension contributions and leave according to the worker and scheme. The Pensions Regulator says employers must monitor eligible staff and maintain automatic-enrolment contributions.
Add a labelled example
Assume, only for demonstrating the sheet, that a short campaign has £3,000 of external invoices before VAT, £500 of rights and review, and 20 internal hours valued at an assumed £25 each. The external amount is £3,500 before VAT. Internal time adds £500, giving a £4,000 economic view before any reviewed VAT adjustment.
If gross supplier payments include £700 VAT, the cash view initially shows £4,200 paid externally. Every number in this paragraph is fictional.
Build scenario switches
Choose inputs that can genuinely change: production days, revision rounds, review hours, paid-media use, licensed territories, subscriber volume, refunds and delayed delivery. Do not vary every row by the same percentage. A licence may jump at a territory boundary, while staff time may rise gradually.
Low
- Production days
- 4
- Revision rounds
- 1
- Review hours
- 8
- Paid media
- £0
- Licensed territories
- 1
- Subscriber volume
- 2,000
- Refunds
- 0%
- Delayed delivery
- 0 days
Working
- Production days
- 6
- Revision rounds
- 2
- Review hours
- 20
- Paid media
- £500
- Licensed territories
- 1
- Subscriber volume
- 5,000
- Refunds
- 2%
- Delayed delivery
- 5 days
High
- Production days
- 9
- Revision rounds
- 4
- Review hours
- 32
- Paid media
- £1,500
- Licensed territories
- 3
- Subscriber volume
- 12,000
- Refunds
- 5%
- Delayed delivery
- 15 days
At the assumed £25 hourly rate, review hours add £200 in the low case, £500 in the working case and £800 in the high case. With the £3,500 external spend from the example, the economic view is £3,700 low, £4,000 working and £4,300 high before any reviewed VAT adjustment.
Give contingency a release rule. For example, only the budget owner may release a stated amount after a documented scope change. Unused contingency is not an expense or proof of a saving.
Reconcile rather than overwrite
At least weekly, replace forecasts with invoices, payroll allocation and recorded hours. Keep the original assumption beside the actual and record the reason for variance. Check that the invoice contains the required details described in the GOV.UK invoicing guide.
Close the period by reconciling commitments, payments, recoverable VAT, internal time and outstanding work. Preserve the source documents and version.
Before you act
- Give every line a cost ID, owner and dated source.
- Lock formula cells and keep manual overrides visible.
- Split outputs into commitment, cash and economic views.
- Bring in allocated gross pay and on-costs, not a guessed uplift.
- Replace forecasts with invoices and recorded hours weekly.
- Preserve source documents and version for each period.
Common questions
What three questions should a finance creator budget template answer?
It should answer what has been committed, when cash moves and what resources the work consumes, without mixing them. Use separate columns for VAT and internal time, then keep low, working and high scenarios alongside actuals so each question stays visible.
How should internal labour be valued in the economic view?
Bring in allocated gross pay and the applicable on-costs rather than a guessed uplift. Add pension contributions and leave according to the worker and scheme. HMRC publishes current employer rates and thresholds, and The Pensions Regulator sets automatic-enrolment duties for eligible staff.
Why should recoverable VAT not be removed from cost automatically?
The recoverable amount could be different or nil depending on registration, invoice validity, business use and the nature of supplies. A pending reclaim may lower economic cost but still creates a cash outflow first, so the treatment must be checked before any adjustment.
