← All prebuilt solutions
Planning & Finance

Multi-Project Budget & Stacked Forecast

Price and phase every project, then stack them into one forecast of profit, cash and capacity

£20

Secure checkout. Your file is ready in your client portal as soon as payment clears.

Multi-Project Budget & Stacked Forecast

Overview

Most forecasting spreadsheets cope with one business plan. Real businesses win and lose individual jobs, contracts and projects – each with its own price, start date, phasing and payment terms. This workbook gives every project its own tab, then stacks them all into a single forecast so you can see what the year looks like with only confirmed work, with likely work added, or with every opportunity weighted by its chance of going ahead. It also checks your team has the capacity to deliver, compares actual results with budget, and produces a quote for any project.

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

Project Register

Every project in one list, with status, probability, value and dates. What you do: one row per project or contract.

Project Register
Stacked Forecast

Step 2

Stacked Forecast

All projects stacked into one month-by-month forecast of profit and cash. What you do: choose the view – nothing else to enter.

Step 3

Capacity

Hours needed by role each month against the hours your team has. What you do: nothing to enter – red months need attention.

Capacity

Step 4

Who it is for

Made for people like you

  • Example – text
  • Builders, contractors and trades – See how the jobs you have won – and the ones you are quoting – add up month by month, and when the cash arrives.
  • Agencies and consultancies – Stack client retainers and projects to see whether you can afford the next hire.
  • Businesses bidding for contracts – Weight every bid by its chance of winning for a realistic forecast to show the bank.
  • Accountants and advisers – Build a project-based forecast with a client in one sitting.

Quick start

Up and running in minutes

  1. Example – text
  1. Settings – Enter your business name, the first month of the forecast, your overheads and the roles in your team.
  2. Project Register – List each project with its status (confirmed, likely or possible) and probability.
  3. Project tabs – For each project, enter the price, costs, hours by role, the months it runs and when the customer pays.
  4. Stacked Forecast – Choose confirmed, likely or weighted and read the month-by-month profit and cash.
  5. Capacity – Check no month needs more hours than your team has.
  6. Actual vs Budget – Each month, enter actual sales and costs to see how you are doing.

Key features

  • Up to 20 projects, each phased over up to 24 months with its own pricing method, cash timing and probability – stacked over a 36-month forecast.
  • Stacked forecast of sales, direct costs, gross profit, overheads, net profit and cash – switch between confirmed, likely and weighted views.
  • Capacity check of hours needed against hours available by role, flagging overloaded months.
  • Actual vs budget by month and a ready-to-send project quote.

What’s included

  • Dashboard – The stacked forecast at a glance
  • Settings – Start month, scenario, roles, overheads and defaults
  • Project Register – All 20 projects on one page
  • Project 1 – Project 20 – Price, phase and time the cash for each project
  • Stacked Forecast – Month-by-month revenue, profit and cash
  • Capacity – Hours needed vs hours available by role
  • Actual vs Budget – Track the real figures
  • Quote – Client-ready quotation for any project
  • Guide – How to use this workbook

How buying works

Your file is only released to your client portal 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 file is ready in your client portal as soon as payment clears, and we email you your invoice with a link to the portal.

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