Cash Budgeting: Building a Rolling Forecast

Learning objectives

By the end of this chapter you should be able to:

• Prepare a monthly cash budget that separates cash receipts and cash payments from credit transactions and accruals.
• Apply timing rules to build accurate receipts and payments schedules and reconcile them to sales and purchases patterns.
• Construct a rolling cash forecast that updates each month using actual results while keeping a constant forward horizon.
• Identify periods of tight liquidity and potential surplus, and quantify any funding requirement under different cash policies.
• Use a cash budget for monitoring and control through variance analysis and trigger levels.
• Perform quick “what-if” tests on key assumptions (collections, payment terms, costs, taxes, capital spending) to understand cash sensitivity.

Overview & key concepts

A business can report healthy profits and still run short of cash. Profit is measured on an accrual basis (income earned and costs incurred), whereas liquidity depends on when cash is actually received and paid. A cash budget is a forward plan of cash movements and cash balances. It supports day-to-day control (paying suppliers, wages, taxes) and medium-term planning (deciding whether to borrow, delay spending, or invest surplus cash).

A rolling forecast extends the cash budget into a continuous planning tool. Instead of producing a single budget for a fixed period and leaving it unchanged, a rolling forecast updates as soon as actual information becomes available, and then adds a new future month so the planning horizon stays constant.

Cash budget

A cash budget is a period-by-period forecast of:

• cash receipts (cash inflows expected to be collected), and
• cash payments (cash outflows expected to be paid),

showing opening cash, net cash movement for the period, and closing cash.

Key point: a cash budget is a planning document. Preparing a budget does not create journal entries. Accounting entries arise only when the underlying transactions occur (for example, when a customer pays cash, or when a supplier invoice is settled).

Rolling forecast

A rolling forecast is a cash budget that is continuously refreshed:

• once a month ends, replace that month’s forecast with actual cash receipts and actual payments,
• revise the remaining months using updated assumptions, and
• add an extra future month to keep the forecast horizon (for example, the next three months) unchanged.

The benefit is responsiveness: changes in demand, customer payment behaviour, supplier terms, payroll costs, tax dates, or capital spending are reflected quickly, allowing earlier management action.

Timing adjustments

Cash planning depends on timing rules. The budget must reflect when cash moves, not when sales are made or costs are incurred.

Typical timing items include:

• Credit sales: cash arrives later, so a receipts schedule must be built from expected collections.
• Credit purchases: cash leaves later, so a payments schedule must be built from expected settlement of supplier balances.
• Accruals and prepayments: expenses recognised in profit may not match the timing of cash payments.
• Capital expenditure: may be paid on order, on delivery, in stages, or through finance arrangements, so the cash pattern can differ from the asset’s “use” date.
• Taxes and interest: usually paid on specific dates (instalments or due dates) rather than evenly each month.
• Sales taxes (where relevant): VAT/sales tax collected from customers may be paid over to the tax authority later, creating a separate cash flow timing effect.

Cash buffer and overdraft limit

A business commonly sets a target minimum cash balance (a cash buffer) to reduce liquidity risk. The buffer is not a “spare” amount; it is a practical safeguard against uncertainty (late customer payments, unexpected repairs, seasonal fluctuations).

An overdraft limit is a ceiling on permitted bank borrowing through a current account facility. In cash planning, the forecast should show:

• whether the cash balance will fall below the buffer, and/or
• whether borrowing would exceed the agreed limit.

Both outcomes are triggers for action.

Variance analysis

Variance analysis compares:

• actual cash receipts/payments, and
• budgeted cash receipts/payments,

to explain why differences occurred and what they imply for future cash.

Cash variances are often caused by:

• timing(customers paid later than expected, or a supplier was paid early),
• volume(sales units or production volumes changed), and
• price/cost(sales prices, wage rates, input costs, or overhead spend differed from the plan).

A useful discipline is to separate a timing effect from a continuing (“real”) effect:

• Timing variance: cash shifts between months. Management action focuses on process and assumptions (credit control, payment runs, collection terms) and updating the forecast.
• Real variance: the underlying business level has changed. Management action focuses on revising expectations and decisions (pricing, cost base, volumes, staffing, spend approvals) and re-planning funding.

Core theory and frameworks

Building a cash budget

A practical build method is:

1. Choose the horizon(often 3–6 months for operational control).
2. List cash receipt categories, such as customer collections, cash sales, asset disposals, grants, or new borrowing.
3. List cash payment categories, such as supplier settlements, wages, overheads, taxes, interest, and capital expenditure.
4. Set timing rulesfor each category (for example, 40% collected in the month of sale and 60% in the following month).
5. Build schedulesfor receipts and payments using the timing rules.
6. Calculate net cash movementandclosing casheach month.
7. Review for risks and actions, including buffer breaches, overdraft headroom, and upcoming one-off payments.

Core relationship:

Closing cash = Opening cash + Total cash receipts − Total cash payments

Receipts schedule from credit sales

If sales are largely on credit, budgeted receipts are derived from sales using collection assumptions (for example, part collected in the month of sale and the balance collected later).

The receipts schedule is not revenue. It is a cash collection pattern, and it is the key step in converting an accrual-style sales forecast into a cash forecast.

Payments schedule from credit purchases

Cash paid to suppliers follows credit terms and payment practice (for example, one month after purchase, or part now and part later). This timing is usually different from cost of sales:

• cash-to-suppliers reflectswhen suppliers are settled, and
• cost of sales reflectswhen inventory is used/sold,

so they rarely match in the same month.

Capital expenditure timing nuance

Capital expenditure can be a common exam twist because the cash pattern may not be a single payment in one month. Possible cash profiles include:

• deposit on order and balance on delivery,
• staged payments (milestones),
• supplier credit terms on capital items,
• finance/lease arrangements where the cash outflow is periodic payments (and possibly an initial deposit).

In cash budgets, always use the payment schedule actually expected, not the accounting depreciation pattern.

Monthly refresh cycle in a rolling cash forecast

Treat the rolling forecast as a moving window rather than a document you “finish”. Each month, run a three-layer update:

• Replace: swap the completed month’s forecast lines for actual cash received and actual cash paid.
• Re-estimate: revise the drivers that affect timing and amounts (collections behaviour, supplier settlement pattern, payroll dates, tax due points, and known one-offs).
• Re-extend: add one new month at the end so the forecast always covers the same forward span (for example, the next 12 weeks or the next 3 months).

Finally, scan for decision points: buffer breaches, overdraft headroom, and internal liquidity limits.

Identifying peaks, troughs, and funding need

Two outputs matter most:

• thelowest forecast cash balance(tightest liquidity point), and
• thefunding requirement, which depends on the cash policy stated in the requirement.

Two common cases are tested:

If there is no minimum cash buffer (overdraft only):
Overdraft required = Max(0, −Forecast closing cash)

If a minimum cash buffer is required:
Funding required = Max(0, Cash buffer − Forecast closing cash)

Under a buffer policy, even a positive cash balance can imply funding is needed if it falls below the required minimum.

Monitoring, control, and trigger levels

A cash budget supports control when it is used actively:

• settrigger levels(for example, “forecast closing cash below £10k” or “within £5k of overdraft limit”),
• assign responsibilities (credit control, purchasing, payroll, treasury, and budget holders),
• investigate variances promptly, and
• update the rolling forecast so future months reflect what has been learned.

To make triggers operational, link them to a clear action owner and response (for example, “If forecast cash falls below buffer, credit control escalates collections and treasury prepares funding options within 48 hours”).

Sensitivity testing (“what-if”)

A cash forecast is only as useful as the questions it helps you answer. Stress-test the drivers that change cash fastest:

• Customer timing (DSO behaviour): if receipts slip by one month for a slice of sales, how quickly does headroom disappear?
• Supplier timing (DPO behaviour): what happens if a key supplier tightens terms, or if you choose to pay early for discount?
• Committed outflows: which payments are fixed-date and unavoidable (payroll, rent, tax), and which can be delayed without damaging operations?
• Large one-offs: what is the impact if a capital payment or tax instalment moves forward?

The goal isn’t a perfect number; it is to identify the assumptions that create liquidity pressure and the lead time needed to respond.

Worked example

Before preparing the cash budget table, convert the accrual-style sales and purchases forecast into cash receipts and cash payments using the timing assumptions.

Narrative scenario

A small manufacturing business begins April with £18,000 cash. Forecast figures are as follows (all amounts in £’000):

• Sales: March 60, April 80, May 70, June 90
• Purchases: March 36, April 40, May 38, June 50
• Wages: 12 per month, paid in the same month
• Overheads: 6 per month, paid in the same month
• Capital expenditure: 15 in May (paid in May)

Customer collections: 40% collected in the month of sale and 60% collected in the following month. Supplier payments: paid one month after purchase.

Required:

1. Compute cash receipts for each month (April to June).
2. Compute supplier payments for each month (April to June).
3. Prepare a cash budget for April to June.
4. Identify the lowest cash point and any borrowing requirement.
5. Suggest practical actions if a cash shortfall is forecast.

Solution

Step 1: Cash receipts schedule

April receipts:

April receipts = 40% of April sales + 60% of March sales
April receipts = 0.40 × 80 + 0.60 × 60 = 32 + 36 = 68

May receipts:

May receipts = 40% of May sales + 60% of April sales
May receipts = 0.40 × 70 + 0.60 × 80 = 28 + 48 = 76

June receipts:

June receipts = 40% of June sales + 60% of May sales
June receipts = 0.40 × 90 + 0.60 × 70 = 36 + 42 = 78

(All figures in £’000.)

Step 2: Supplier payments schedule

Supplier payments are one month after purchase:

• April supplier payments = March purchases = 36
• May supplier payments = April purchases = 40
• June supplier payments = May purchases = 38

(All figures in £’000.)

Step 3: Other cash payments

• Wages: 12 each month (April–June)
• Overheads: 6 each month (April–June)
• Capital expenditure: 15 in May only

(All figures in £’000.)

Step 4: Cash budget (April to June)

Exam-format layout (recommended): Opening cash → Receipts → Payments (by category) → Net cash flow → Closing cash.

Net cash flow = Receipts − Supplier payments − Wages − Overheads − Capital expenditure

(All figures in £’000.)

Interpretation

• The cash balance remains positive throughout April to June.
• The lowest cash point is £18k (opening balance at the start of April).
• There is no overdraft requirement in this forecast because closing cash never falls below zero.

If a minimum cash buffer were required, the funding requirement would be assessed against that buffer rather than against zero:

Funding required (with buffer) = Max(0, Cash buffer − Forecast closing cash)

In this scenario, any reasonable buffer below £18k is satisfied throughout; a higher buffer would need to be tested.

May is relatively tight because the capital expenditure absorbs most of the month’s operating inflow. This highlights why large one-off payments should be built into the forecast explicitly and reviewed with sensitivity tests (for example, slower customer collections or earlier supplier settlement).

Suggested actions if a shortfall were forecast

If the forecast showed cash falling below the buffer or becoming negative, practical responses include:

• accelerate collections (earlier invoicing, tighter credit control, proactive chasing),
• renegotiate supplier payment terms or spread large payments,
• defer or phase non-essential capital expenditure,
• reduce discretionary overhead spend,
• arrange short-term funding in advance (overdraft, short-term loan) rather than reacting late.

Common pitfalls and misunderstandings

• Treating sales as cash receipts and purchases as cash payments without applying timing rules.
• Missing the “previous month” effect (collections from last month’s sales and payments for last month’s purchases).
• Mixing accrual-based expenses with cash payments (for example, assuming “overheads expense” equals “cash paid”).
• Forgetting one-off items (capital expenditure, tax instalments, annual insurance, bonus payments, dividend payments).
• Ignoring VAT/sales tax timing where relevant (cash collected from customers may be paid over later).
• Assuming money is available immediately when paid in by customers (clearing delays can matter).
• Failing to investigate cash variances promptly, so the forecast remains unrealistic.
• Not extending the forecast window each month, leading to a plan that becomes stale.
• Using no buffer or an unrealistic buffer, creating false comfort.

Summary and further reading

Cash budgeting focuses on liquidity: when money will be received and when it must be paid. Accurate forecasts depend on separating credit transactions from cash movements and applying consistent timing rules for receipts and payments. A rolling forecast strengthens control by incorporating actual cash outcomes each month, updating assumptions, and extending the horizon so management always has a forward view. Funding need must be defined in line with the stated policy: against zero (overdraft requirement) or against a minimum cash balance (buffer requirement).

Further reading should focus on general financial planning, working capital management, and practical cash management guidance from reputable professional sources.

FAQ

What is the primary purpose of a cash budget?

A cash budget helps plan and control liquidity. It forecasts cash receipts and payments by period, shows expected cash balances, and highlights when management action may be required (for example, arranging funding or delaying spending). It is different from profit forecasting because it is driven by cash timing rather than accrual recognition.

How does a rolling forecast differ from a fixed budget?

A fixed budget is set for a defined period and typically remains unchanged. A rolling forecast is updated as each period ends: actual cash results replace forecasts, assumptions are revised, and an additional future period is added so the planning horizon stays constant.

Why are timing adjustments important?

Timing adjustments ensure the forecast reflects when cash is actually received or paid. Credit sales collected next month are not available this month, and purchases paid next month do not reduce this month’s cash. Without timing adjustments, the cash forecast can be materially wrong even if the profit forecast is accurate.

What are common causes of cash budget errors?

Frequent causes include using sales as cash, forgetting settlement lags, missing one-off payments, confusing accrual expenses with cash, missing VAT/sales tax or tax instalment timing, and failing to refresh assumptions after variances occur.

How can variance analysis improve cash management?

Variance analysis explains differences between actual and forecast cash and highlights what to do next. Timing-driven variances point to collection/payment processes and assumption updates. Real variances indicate that pricing, costs, or volumes have shifted and the business may need to re-plan operations and funding.

What is the role of a cash buffer?

A cash buffer is a target minimum cash balance that reduces the risk of missing payments due to uncertainty. It is especially important when cash inflows are volatile, payment dates are fixed, or the business is reliant on a small number of customers.

Summary (Recap)

This chapter explains how to build a cash budget and extend it into a rolling forecast. It focuses on converting sales and purchases information into cash receipts and cash payments using timing rules, then calculating month-by-month cash balances. It also shows how the cash budget supports control through variance analysis and trigger levels, and how “what-if” tests help assess cash sensitivity. The worked example demonstrates how to schedule receipts and payments and how to interpret the resulting cash profile. Funding need is defined in line with the question’s policy: against zero (overdraft requirement) or against a required minimum cash balance (buffer).

Marking focus checklist

Strong answers typically demonstrate:

• a clear, consistent layout (opening cash, receipts, payments, net movement, closing cash),
• correct application of timing rules (including prior month effects),
• consistent units throughout (for example, £’000 clearly stated and maintained),
• correct linkage between months (closing cash becomes next month’s opening cash),
• a correct funding assessment based on the policy stated (zero vs buffer),
• brief, relevant management actions linked to the forecast and variances.

Glossary

Cash budget
A forward plan of expected cash receipts and cash payments by period, showing opening and closing cash balances.

Rolling forecast
A continuously updated forecast that replaces completed periods with actual results and adds a new future period to maintain a constant planning horizon.

Timing adjustment
A budgeting adjustment that places a receipt or payment into the period when cash is expected to move, rather than when revenue is earned or cost is incurred.

Cash buffer
A target minimum cash balance maintained to reduce the risk of liquidity shortfalls.

Overdraft limit
The maximum permitted bank borrowing available under an overdraft facility.

Variance analysis
The process of comparing actual cash movements to the forecast and explaining the reasons for differences.

Cleared funds
Cash that has fully settled through the banking system and is available for use.

Net cash flow
The net movement in cash for a period (receipts minus payments).

Trigger level
A pre-set threshold (such as a minimum cash balance or overdraft headroom limit) that prompts management action when breached.

What-if analysis
A sensitivity test that changes key assumptions (such as collection rates, payment terms, tax timing, or capital payment dates) to evaluate the impact on forecast cash.