Fractional CFO Budgeting Example for UK E-commerce

A growing online retailer can look profitable on paper while becoming short of cash in the same month. Stock is paid for before it is sold, advertising costs rise with growth, and VAT or supplier payments can arrive just as a marketplace settlement is delayed. This fractional CFO budgeting example shows how a UK e-commerce business can turn those moving parts into a practical plan for profitable, controlled growth.

The purpose is not to produce an attractive spreadsheet for lenders or investors. A useful budget gives a director clear answers to commercial questions: Can we afford the next stock order? Which sales channels are genuinely profitable? When will cash become tight? What needs to change before the problem becomes urgent?

The business behind this fractional CFO budgeting example

Consider a UK limited company selling home and lifestyle products through Shopify, Amazon and a small wholesale channel. It has annual revenue of £2.4 million, five employees and a warehouse partner. The founders have built demand successfully, but planning has largely relied on prior-month sales, bank balance checks and instinct.

The company expects turnover to grow by 25% next year. That sounds positive, but growth creates pressure. More sales require more inventory. Paid acquisition becomes less predictable as competition increases. Amazon fees, merchant fees, returns, fulfilment charges and customer-service costs must all be considered before a sales target can be treated as profit.

A fractional CFO begins with management information that is current and consistent. Sales must be reconciled by channel, stock records need to be credible, and the chart of accounts should distinguish the costs that drive margin. Xero can provide a strong accounting foundation, but the value lies in how the data is interpreted and used for decisions.

Build the budget from operational drivers

A traditional budget may simply apply a percentage increase to last year's revenue and expenses. That is quick, but it can hide the commercial reasons behind the numbers. For e-commerce businesses, a driver-based budget is usually more reliable.

For this retailer, the starting point is monthly sales by channel, average order value, expected units sold and seasonal trading patterns. November and December are forecast separately because promotional activity and gifting demand materially affect sales, returns and stock requirements. The plan also allows for quieter periods after peak trading rather than assuming a smooth monthly run rate.

The finance lead then builds gross margin from product-level economics. This includes landed cost, import duty where applicable, inbound freight, packaging, fulfilment, marketplace commissions, payment processing and expected refunds. Marketing is not treated as a single vague overhead. It is assessed against channel performance, customer acquisition costs and the likely contribution from new and repeat customers.

The following simplified annual budget illustrates the structure:

| Budget area | Annual forecast | Planning assumption | |---|---:|---| | Shopify sales | £1,450,000 | 20% growth, supported by repeat customers and paid social | | Amazon sales | £1,100,000 | 30% growth, with controlled promotional discounting | | Wholesale sales | £450,000 | Two new retail accounts from quarter three | | Total revenue | £3,000,000 | 25% growth overall | | Cost of goods sold and landed costs | £1,170,000 | 39% of revenue | | Channel, fulfilment and payment costs | £510,000 | 17% of revenue | | Marketing spend | £450,000 | 15% of revenue, reviewed by channel | | People and operating overheads | £570,000 | Includes planned operations hire | | EBITDA before exceptional items | £300,000 | 10% of revenue |

At first glance, a £300,000 EBITDA forecast may appear healthy. A fractional CFO would test whether it is achievable. If gross margin falls by two percentage points because freight costs rise or discounting becomes more aggressive, the impact is £60,000 before considering VAT, corporation tax, finance costs or director remuneration. That is why a budget needs clear assumptions, not just totals.

Treat marketing as an investment with limits

Marketing frequently becomes the most contested budget line. A founder may see an opportunity to spend more because revenue is rising, while the finance team sees a declining return on ad spend. Both can be right, depending on contribution margin and cash availability.

In this example, the budget sets a monthly acquisition spend range rather than giving every channel an automatic annual increase. Paid social can be increased when contribution after product, fulfilment and advertising costs remains above the agreed threshold. It is reduced when returns rise, conversion falls or payback extends beyond the business's cash capacity.

This avoids an unhelpful rule such as cutting all marketing to protect the bank balance. It also avoids spending aggressively simply because top-line sales look strong.

Add the cash forecast that the profit and loss account cannot provide

Profit is not cash. The business may record sales in a strong month, yet receive marketplace funds later, pay suppliers on shorter terms and commit to a large production run before the next settlement arrives. A 13-week rolling cash-flow forecast is therefore central to effective CFO-level budgeting.

For the retailer above, the annual budget shows £300,000 EBITDA. The cash forecast reveals a potential low point of £85,000 in August. The cause is not poor trading. It is the timing of a £240,000 autumn inventory order, VAT due from the previous quarter and a planned deposit for Christmas warehouse capacity.

The forecast gives management time to act. They could negotiate staged supplier payments, move part of the order to a later delivery date, arrange an appropriate working-capital facility or reduce purchase quantities for slower-selling lines. Each option has a trade-off. Delaying inventory may protect cash but risk stock-outs; borrowing can preserve availability but has a financing cost; cutting the order may reduce exposure but limit peak-season revenue.

A good budget makes these choices visible early, when there is room to negotiate. It should separately show VAT, PAYE and National Insurance, corporation tax, debt repayments, capital expenditure, dividends and director loan movements. Leaving these items in a general overhead line creates avoidable surprises.

Use scenarios to make decisions before conditions change

A single budget is a plan, not a promise. A fractional CFO will normally prepare a base case, downside case and upside case, with a small number of meaningful variables changed in each one.

For this business, the downside case assumes revenue is 10% below plan, gross margin drops by one percentage point and inventory takes an extra 15 days to sell. The result is more serious than a simple revenue shortfall because cash is locked into stock while fixed costs continue. The model may show that discretionary recruitment should be paused if sales remain below target for two consecutive months.

The upside case assumes stronger demand from Amazon and wholesale. It is not automatically good news. It tests whether supplier lead times, warehouse capacity and customer-service resource can cope without creating expensive expedited freight or a poorer customer experience. Growth should be funded deliberately, not merely celebrated.

Establish a monthly operating rhythm

The budget becomes useful only when it is reviewed against actual performance. Monthly management accounts should compare actuals with budget and prior period, explain material variances and update the outlook for the remaining months. For a fast-moving e-commerce business, weekly trading and cash reviews may also be appropriate during peak periods.

The discussion should focus on decisions rather than reporting for its own sake. If Amazon revenue is ahead of budget but margin is lower, is pricing, advertising, fulfilment or product mix responsible? If stock is increasing faster than sales, does the purchasing plan need revising? If cash is behind forecast, is the issue timing or a genuine decline in profitability?

Clear ownership matters. The commercial lead may own conversion and sales targets, operations may own stock availability and fulfilment costs, and finance should maintain the forecast, challenge assumptions and quantify choices. This turns budgeting into a management process rather than an annual exercise that is ignored by February.

When fractional CFO support is most valuable

A full-time finance director may not be appropriate for a business at this stage, but bookkeeping alone will not resolve strategic questions about margin, funding and growth. Fractional CFO support is most valuable when a company is scaling channels, carrying increasing stock, preparing for finance, facing uneven cash flow or needing more confidence in its forecasts.

Fortis Accounting can combine the underlying accounting discipline with commercially focused planning, so directors can work from reliable figures rather than fragmented reports. The level of support should match the business: some companies need a monthly board pack and forecast review, while others need closer support through a funding round, international expansion or peak-season planning.

The most useful budget is one that changes a decision before cash pressure, missed margin or stock commitments force the issue. Start with the next trading cycle, identify the assumptions that matter most, and give each one an owner and a review date.