How to build a cash flow forecast for a UK grant

The grant deadline is tomorrow, and somebody asks: “Can we pay the team before the funding arrives?” Your project budget balances, and now you need to know whether your bank balance does too.

If you’re fitting the application around your day job and home life, another spreadsheet can feel like a lot. The method itself is simpler than it looks, and this guide walks you through it.

How do you build a cash flow forecast for a UK grant application?

A cash flow forecast estimates when money will enter and leave your organisation. For a grant application, it shows how you’ll cover project costs alongside existing commitments, including any wait for grant payments.

Start with your opening bank balance, add expected receipts and subtract payments for each month, then carry each closing balance forward. Test what happens if funding arrives late, keep restricted money separate, and ask your finance team to check your assumptions against the funder’s requirements.

Why cash timing matters

Profit measures income against costs over an accounting period. Cash flow tracks when money moves, while your project budget sets out what delivery will cost and how those costs will be funded.

An invoice can contribute to reported income before the customer pays it. Meanwhile, payroll still leaves the bank. A grant award can cover the project without arriving early enough to pay mobilisation costs.

That timing can cause cash shortages, even when the budget balances. That’s why assessors may need more than a balanced budget. They need confidence that delivery can start and continue.

The award email lands. There’s relief, a quick celebration, then somebody asks when recruitment starts.

Your forecast helps answer that question before you’ve made commitments. It shows whether working capital, the cash supporting day-to-day operations, can cover the wait between spending and reimbursement. Your finance team can check whether the organisation has the capacity to bridge any funding gap.

NCVO’s guidance on cashflow forecasting treats the forecast as a decision-making tool. Use it to inform financial management, spot pressure points, agree funding arrangements and set realistic start dates.

Build the forecast in five steps

Step 1: check the requirements and set your starting point

Requirements for funding applications vary by scheme, so read the application form, guidance, draft agreement and payment conditions together. A headline award amount won’t tell you when the money reaches your account.

Confirm whether the funder wants a project-only forecast, an organisation-wide forecast, or both. Check the required dates, format and supporting evidence. Larger applications may need a cash forecast alongside the project budget, but this isn’t a universal requirement.

NCVO’s grant budgeting guidance explains why project costs and funding sources need to be clear. The cash schedule then adds the timing.

Payment conditions for external funding affect your cash flow forecast. Check the triggers: is there an advance? Are payments linked to milestones? Must costs be paid before a claim? How long does claim processing take?

If the guidance leaves a material question unanswered, check it with your finance team and ask the funder in writing. Keep the response with your assumptions.

Our UK grant eligibility guidance can help you check the wider fit before spending evenings building a forecast for an unsuitable opportunity.

Choose the period the funder requests. Business.gov.uk’s funding application guidance recommends a forecast covering the next 12 months. Treat that as a starting point for financial planning, as your funder may ask for something different.

A longer project may need a longer forecast. Include mobilisation and the final payment period, especially if some funding arrives after delivery finishes.

Use monthly columns for the application unless instructed otherwise. Where cash is tight, a separate thirteen week forecast can reveal shortages hidden inside monthly totals.

Then establish the opening balance at the forecast start date. Use reconciled records from your accounting system (an old dashboard screenshot won’t do), and ask your finance team to confirm the figures.

For a forecast starting later, calculate the expected balance using receipts and payments before that date. Explain the calculation.

Identify restricted cash and committed spending. A positive bank balance can include money you can’t use for this project.

Don’t add an undrawn overdraft to opening cash. Show an approved borrowing facility separately, with its limit and any conditions.

Step 2: place receipts in the month they arrive

Record each expected cash inflow in the month you expect to receive it. An award date, claim submission date and payment date are different, so check the payment timing.

Follow the scheme’s payment arrangements. Some grants provide advance payments; others reimburse spending or release instalments after agreed milestones.

Allow time for the activities that trigger payment. That might include signing the agreement, submitting evidence or resolving claim queries.

Mark the forecast as conditional on the proposed award where appropriate. An application awaiting a decision isn’t confirmed funding.

Keep the grant calculation visible, so the receipt schedule can be checked against the amount requested.

Include existing contract receipts, sales invoices, trading income, donations, loans and cash match funding where relevant. Use realistic payment timing supported by recent experience, signed agreements or award letters.

Record pending external funding separately from confirmed receipts. A promising conversation won’t cover the wage bill.

In-kind contributions, such as donated venue use or volunteer hours, may count towards match funding if permitted. They don’t create a bank receipt.

Cash reserves already included in your opening balance mustn’t appear again as new income. That would count the same money twice.

Step 3: schedule the full cost of delivery

Work through the delivery plan with the people who will run it. Schedule recruitment, salaries, employer costs, equipment, venues, travel, accessibility, evaluation and reporting.

Use the dates money leaves the bank. A supplier deposit may fall due before activity starts. Annual insurance or software payments may all fall due in a single month.

Include the costs of supporting volunteers, where applicable. Training, expenses and supervision still need funding.

Keep full project costs, eligible costs and the grant request distinct. If the scheme excludes a necessary expense, identify another funding source. The bill doesn’t disappear because it sits outside the grant.

For an organisation-wide forecast, include existing payroll, rent, utilities, overhead costs, supplier payments, loan repayments and other commitments. Don’t duplicate costs already included elsewhere.

Schedule tax and VAT, including PAYE, pension payments and corporation tax where applicable. Ask your finance team to confirm the amounts and due dates.

Check VAT against your organisation’s recovery position and the funder’s rules. Recoverable and irrecoverable VAT can receive different treatment.

The bank forecast must reflect actual cash movements, with each cash outflow shown in the period it occurs. If VAT is paid first and recovered later, show both movements in the relevant periods.

Step 4: calculate and check the closing balance

Use a simple structure that another person can follow without a guided tour of the whole spreadsheet.

These rows give you a practical starting point for your cash flow forecast.

Forecast row	What to include
Opening bank balance	Cash at the start of the period
Grant receipts	Expected payments under the scheme’s terms
Other receipts	Contracts, donations, loans and cash contributions
Total receipts	All cash entering during the period
Project payments	Delivery costs paid during the period
Other payments	Existing commitments and applicable tax
Net cash movement	Total receipts minus total payments
Closing bank balance	Opening balance plus net cash movement

Carry the closing balance into the next column as its opening balance. Once the grant is awarded, maintain the schedule as a rolling forecast.

Pay most attention to the lowest balance, even if the year-end total looks comfortable. Check whether available unrestricted cash remains sufficient at that point.

An annual surplus can hide a cash shortage halfway through the project. Check every period, including the months before the first grant payment.

The British Business Bank’s forecasting steps provide a useful cross-check on receipts, payments and balances.

Keep formulas consistent across columns. Add a check that grant receipts reconcile to the expected award, allowing for payments outside the displayed period.

Step 5: test delayed funding and delivery changes

Build a base case for your cash flow forecast using your best-supported assumptions. Then test the changes most likely to affect the project and reveal potential cash shortages.

Move the first grant receipt into a later month. Delay a significant customer payment. Bring an equipment deposit forward if the supplier requires it.

Change one assumption at a time first. This shows which movement creates the problem. Then test a combined downside with several reasonable pressures. Revisit it as assumptions change.

Record the lowest available balance, when it occurs and how you’ll respond.

Possible responses include an approved cash contribution, an agreed facility, revised supplier terms or a permitted change to delivery timing. Confirm each response before relying on it.

If a scenario produces a shortfall, take its amount, timing, credible funding source and proposed response to the decision-maker. Don’t write “management will monitor” beside a gap that needs actual funding.

Keep the downside within the funder’s rules. Delaying activity may affect milestones or beneficiaries, so check the consequences as well as the cash.

Common mistakes that weaken evaluator confidence

Putting the whole grant in the award month, or counting uncertain receipts too early, can lead to cash shortages. Check the payment schedule before assuming the money is available.

Another mistake is treating all bank funds as free to spend. Restricted grants, committed partner contributions and designated reserves need careful review. Finance should confirm what’s available and what requires approval.

Watch for inconsistent documents. The narrative promises activity in April, recruitment costs start in June, and the forecast assumes delivery begins in May. Each document may look reasonable alone, but read together they raise questions.

Avoid smoothing every cost into equal monthly payments. Deposits, equipment purchases and annual renewals can create pressure points.

Don’t bury a shortfall beneath optimistic sales growth or pending awards. State the status of uncertain income and show what happens if it doesn’t arrive.

Finally, check version control. Several capable people editing different copies can leave you submitting figures nobody intended. Name the final version and make the budget, forecast and narrative agree.

Check and maintain the forecast

As part of responsible financial management, bring the finance team, delivery lead and bid lead together before submission. Each person owns information the others need. The bid manager shouldn’t have to guess payroll dates between school pick-up and the final upload.

Ask these questions against the same version:

• Does the opening balance have a clear, reconciled basis in your accounting system?
• Do receipts follow realistic payment dates and the scheme’s conditions?
• Are restricted funds and pending contributions clearly identified?
• Does the lowest available balance cover commitments, including the downside case?
• Do the forecast, budget, workplan and written answers agree?

For a small business, a spreadsheet is often enough for a grant application. Use the funder’s template where one exists. Otherwise, the Start Up Loans cash flow template offers a free starting structure to adapt.

Keep assumptions separate from formulas. Assign one person to keep the figures and master version up to date, and protect calculation cells where practical.

An accounting system such as Xero or QuickBooks can provide actual transactions and outstanding invoice information. Other software tools, such as Float, can help maintain a rolling view. Software still needs someone to check grant terms, restrictions and payment assumptions.

For several entities, build the forecast for the applicant first. A group’s combined cash balance doesn’t establish that money is available to the applicant. Check transfer permissions, approvals and timing.

After award, compare actual results with the forecast each month. Reconcile supplier payments, explain differences, update the remaining periods and extend the rolling forecast.

At Bidsmithery™, our evaluator-led grant application review checks the connections between evidence, delivery, outcomes and the funding case. Your organisation retains responsibility for financial approval and commitments.

Frequently asked questions

Key takeaways

• Build the forecast around bank movements and realistic payment dates.
• Show the full delivery cost, including spending the grant won’t cover.
• Separate restricted cash, pending income and in-kind contributions.
• Test delayed receipts and agree how any gap will be funded.
• Keep finance approval, delivery assumptions and the application in step.

Protect the delivery plan and your headspace

A strong cash flow forecast makes the timing clear before your organisation takes on commitments. Keep it updated after award so delivery commitments stay visible as plans change.

If deadlines keep arriving, our ongoing bid review support can provide a consistent second pair of eyes. Book a free fit call to discuss what would help your team.

An external red review is a practical way to protect your energy, confidence and headspace whilst keeping ownership of the work.