A local service marketing budget template with a 12-month cash grid and the VAT and tax dates that hit it

What to take away

Split every line into fixed, variable and one-off, then tag each with the month the money leaves the bank.
Put HMRC dates on the same gridVAT returns, and payments on account on 31 January and 31 July.
Score each line on cost per enquiry, speed to first lead and how fast it can be paused.
Keep a contingency of about one month of variable spend, and rebuild the sheet every quarter.

The template: columns and blocks

Use one tab per quarter and one row per line. Fill the blank columns below for each row, and keep the three blocks apart so fixed costs cannot hide inside variable ones.

Block	Example lines	Owner	Start month	End month	Monthly amount	Annual total	Pay month	Score
Fixed	Software, landline, vehicle livery, directory listing
Variable	Paid search, paid social, leaflet drops, print
One-off	New website, photography, shopfront refit
Contingency	One month of variable spend

Start with the costs you cannot stop inside a month. Those are the lines that keep running when enquiries slow. Advertising or marketing, for example website costs, counts as an allowable expense for the self-employed, so record each cost with its receipt.

A scoring rubric for each line

Score every line before you commit money. The weights below are an illustrative example, so set your own. A line scoring under 3 is a candidate for cutting when cash tightens. A return on investment review shows whether the scores held up.

Criterion	Score 1 to 5	Weight
Cost per enquiry	5 is cheapest	30%
Speed to first lead	5 is fastest	20%
Can be paused in 30 days	5 is easiest	25%
Fit with the area you serve	5 is closest	15%
Admin time needed	5 is least	10%

Worked example: a 12-month cash grid

Illustrative figures for a plumbing firm with quarterly VAT: a £400 monthly retainer, paid search at £300 in winter and £600 from March to October, a £3,000 listing paid in January, and £1,200 leaflet drops in April and September. These are example amounts, not market prices.

Month	Retainer	Paid search	Listing	Leaflets	Marketing total	HMRC dates (example)
Jan	£400	£300	£3,000		£3,700	31 Jan: payment on account, tax return and any balancing payment
Feb	£400	£300			£700	7 Feb: VAT due for quarter to 31 Dec
Mar	£400	£600			£1,000
Apr	£400	£600		£1,200	£2,200
May	£400	£600			£1,000	7 May: VAT due for quarter to 31 Mar
Jun	£400	£600			£1,000
Jul	£400	£600			£1,000	31 Jul: second payment on account
Aug	£400	£600			£1,000	7 Aug: VAT due for quarter to 30 Jun
Sep	£400	£600		£1,200	£2,200
Oct	£400	£600			£1,000
Nov	£400	£300			£700	7 Nov: VAT due for quarter to 30 Sep
Dec	£400	£300			£700

The annual total is £16,200: £4,800 retainer, £6,000 paid search, £3,000 listing and £2,400 leaflets. January is the heaviest month at £3,700, which a flat monthly average of £1,350 would hide.

Put the HMRC dates on the grid

Marketing is not the only January cash call. Payments on account are payments towards your next tax bill, including Class 4 National Insurance if you are self-employed. They are due by midnight on 31 January and 31 July. Each is half of the tax you owed last year.

A balancing payment is due by midnight on 31 January the following year.

The online Self Assessment return is due by 11:59pm on 31 January 2027 for the latest year. In the example, January carries the £3,700 marketing spend, a payment on account and possibly a balancing payment. Mark both HMRC months in a different colour so you see the squeeze coming.

VAT returns and the £90,000 threshold

A firm must register for VAT when its taxable turnover for the last 12 months goes over £90,000. A VAT-registered firm should add its return dates to the grid.

The VAT return deadline for submitting online is usually one calendar month and 7 days after the end of an accounting period, and that is also the deadline for paying HMRC. The grid above assumes quarters ending 31 March, 30 June, 30 September and 31 December, so the dates fall on 7 May, 7 August, 7 November and 7 February.

Put the payment in the month it is due, not the month the quarter ends. Check each marketing invoice for VAT, and enter the figure net or gross consistently across the whole sheet. Mixing the two is the commonest reason a grid does not match the bank.

Contingency and the quarterly rebuild

Set aside a contingency of roughly one month of variable spend. In the example that is about £600 to £1,800 depending on the season. A supplier price rise, a vehicle repair or a slow quarter can all arrive without warning, and the risk scenarios article lists the triggers worth rehearsing.

Review the sheet every quarter. Delete lines that scored badly and move money to the ones that produced enquiries, as shown in the key metrics view. Use a planning template to set the budget ceiling first, then let this grid show how it lands month by month.

Channel lines to check

Two variable lines deserve their own research before you fill a row. Facebook ad costs for UK local firms change by area and offer, and leaflet marketing has print, delivery and data-protection costs that sit in different months. Enter your own quotes in the template, with the quote date.

Common questions

How many lines should the template hold?

Enough to see the pattern, not so many that nobody updates it. Most small firms manage with 15 to 25 rows across fixed, variable and one-off.

Should the budget be monthly or annual?

Both. Set annual totals for planning, then spread them by the month the money leaves so you can see which months are heavy.

Who should own the template?

One named person, usually whoever signs off spend. Shared ownership is how lines go stale and double payments happen.