← All prebuilt solutions
Planning & Finance

Annual Budget Builder

A detailed monthly budget, built from the ground up

£20

Secure checkout. Your download link is sent as soon as payment clears.

Annual Budget Builder

Overview

A budget is your plan for the year in numbers: what you expect to sell, what it will cost you, and how much profit should be left at the end. This workbook builds that plan from the ground up – revenue stream by revenue stream, person by person and cost by cost – and turns it into a monthly profit and loss budget. It shows the months where you're likely to make a loss, how your plan compares with last year, and once the year is underway it tracks your actual results against the budget so you can spot problems early. When you're happy with it, the Export sheet lays the budget out ready to paste into an AML Management Pack.

Price
£20
Who it’s for
Planning & Finance
Works with
Microsoft Excel for Windows and Mac
Buy now

See how it works

A walk through the main sheets

The sheets you will use most, in the order you will use them – shown with the sample data every workbook comes with.

Step 1

Income

Seasonality patterns, revenue streams and the direct costs (cost of sales) that go with them. What you do: edit the patterns and enter each stream in the yellow cells.

Income
Payroll

Step 2

Payroll

Every role with monthly pay, employer NI, Employment Allowance and pension. What you do: enter one line per person or group of similar staff.

Step 3

Overheads

All running costs, spread into the months they're actually paid. What you do: enter one line per cost.

Overheads
Capex & Loans

Step 4

Capex & Loans

Equipment purchases with depreciation, and loans with interest and capital repayments. What you do: enter purchases and loan details.

Who it is for

Made for people like you

  • Example – text
  • Hospitality & seasonal businesses – Seasonality patterns that put the busy and quiet months in the right place, with staff who start and leave mid-year.
  • Retail & product businesses – Revenue by stream with cost of sales as a % of sales, so gross margin is built in.
  • Service businesses & trades – A realistic payroll budget with employer NI, the Employment Allowance and pensions worked out for you.
  • Limited companies – Net profit before tax, an estimate of the corporation tax for the year and profit after tax.
  • Anyone talking to a bank or investor – A clear, professional monthly budget and a comparison with last year to back up your plans.

Quick start

Up and running in minutes

  1. Example – text
  1. Setup – Enter your business name, the first month of the budget year, the tax year for payroll rates, whether you claim the Employment Allowance and how many associated companies you have.
  2. Income – Check the seasonality patterns at the top, then add one line per revenue stream: a normal month's sales, monthly growth, the seasonality pattern and the direct cost %.
  3. Payroll – List every role or person with their annual salary, start and leave months, any pay rise and the employer pension %.
  4. Overheads – Add every running cost with the amount per payment, how often it's paid, the first month it's paid and any price rise.
  5. Capex & Loans – Add equipment you plan to buy and any loans you're repaying.
  6. Review the Budget P&L and Dashboard – Look at the profit for the year, the monthly pattern and the key percentages. Adjust until the plan is realistic and achievable.
  7. Compare with last year – Type last year's actual figures into the vs Last Year sheet to sense-check the plan.
  8. Track the year – Each month, enter your actual figures on Actual vs Budget and update 'Months completed'.

Key features

  • Revenue streams with growth, seasonality and direct costs; payroll by person with employer NI, Employment Allowance and pensions.
  • Overheads by frequency with price rises, capital purchases with depreciation, and loans with interest and repayments.
  • Monthly budget P&L with key percentages, corporation tax estimate and comparison with last year.
  • Actual vs budget tracking through the year, plus an export straight into the AML Management Pack.

What’s included

  • Dashboard – Budget at a glance
  • Setup – Settings and months
  • Income – Revenue streams and direct costs
  • Payroll – Staff costs
  • Overheads – Running costs
  • Capex & Loans – Equipment and borrowing
  • Budget P&L – Monthly budget
  • vs Last Year – Comparison with last year
  • Actual vs Budget – Track the year
  • Export – Into the Management Pack
  • Tax Rates – Payroll and tax rates
  • Guide – How to use this workbook

How buying works

Your file is only released once payment has cleared.

1

Click Buy now

You are taken to our secure checkout.

2

Pay securely

Checkout takes a minute and you get a receipt by email.

3

Download your file

Your download link arrives as soon as payment clears.

Explore the range

Need it tailored to your business?

We can adapt any prebuilt solution or build something bespoke, with a lifetime bug-free guarantee.

Part of AML Finance Group

Need an accountant too?

Our sister firm, AML Accountancy Solutions, is an award-winning accountancy practice helping businesses and individuals across the UK with their accounts, tax, bookkeeping and payroll.

Visit AML Accountancy Solutions