Working Capital Gap

Why this question matters

Growth often creates payments before it creates receipts. Stock may need to be ordered, staff paid and delivery arranged while customers still have time to settle invoices. This tool compares a simple three month cash requirement with the cash and receipts expected to be available. It helps identify whether the plan leaves enough room for a chosen reserve. It is especially useful before a seasonal purchase, a larger order or a new operating commitment.

Start with cash the business can actually use at the beginning of the period. Exclude money held for someone else, restricted balances and facilities that have not been committed. Expected receipts should follow likely collection dates rather than invoice dates. A signed order, an issued invoice and money available in the bank are different stages. If a large receipt is uncertain, retain a conservative version of the scenario so the dependence is visible.

Operating payments should represent cash leaving the business each month. Enter debt payments separately to avoid losing sight of financing commitments, and check that they have not already been included in operating payments. Committed purchases cover additional amounts outside the recurring monthly figures. The reserve is your desired closing cash cushion. It is a planning choice, not a statutory requirement or a benchmark supplied by this tool.

Understand the method

1. Quarterly outflows = 3 × (monthly operating payments + monthly debt payments) + committed purchases.
2. Funding gap = max(0, outflows + reserve − opening cash − expected quarterly receipts).

The calculation multiplies monthly operating and debt payments by three, then adds the committed purchases. It compares those total outflows plus the reserve with opening cash and expected quarterly receipts. Any positive difference is the funding gap. A negative difference is displayed as zero gap because the stated cash sources cover the entered requirement. The separate cash before reserve figure helps distinguish a genuine operating deficit from a shortfall against your chosen cushion.

Read the result as a question about the plan. A funding gap can be addressed through several routes: changing the timing of commitments, collecting earlier under agreed terms, reducing avoidable stock exposure, adjusting the scope of growth or arranging appropriate funding. Borrowing is one possible response, not the automatic conclusion. Investigate which part of the gap is temporary and which would repeat if the business continued operating in the same way.

Next, move the important dates into a weekly cash schedule. Place opening cash in week one, add receipts when they are expected to arrive, and subtract payments when they are due. Carry the closing balance into the following week. The lowest weekly balance matters because a quarter that ends with sufficient cash may still contain a week when payroll or a supplier cannot be paid. The quarterly tool is an initial view, not a replacement for that timing work.

Keep the result in perspective

This is a transparent planning calculation or self assessment, not a sector benchmark, professional valuation or a prediction of an outcome.

A quarterly total can hide a cash shortfall in an earlier week. Prepare a dated cash forecast before committing expenditure.

The model assumes that the monthly operating and debt payments entered repeat for three months. It does not automatically vary them with sales or account for irregular tax, maintenance, annual subscriptions or delayed customer payments. Include relevant committed amounts without counting the same item twice. If a payment schedule is uneven, the quarterly total may remain correct while the practical funding requirement changes considerably.

A zero displayed gap does not prove that the business can afford every commitment. It means only that the totals entered cover the totals modelled. Receipts may arrive late, costs may change and reserves may be insufficient for the risks being considered. Treat an unconfirmed customer payment as an assumption to verify. Avoid using the result as a promise to a supplier or lender.

Read the full limitations or explore how Ayodeji approaches this work.