A sales pipeline is a cash flow forecast nobody reads.

The only forward-looking information most businesses own is sitting in the sales pipeline, while the cash forecast is built from the receivables ledger — a record of decisions already taken. The future is in one room and the forecast is in another.

IN SHORT

A pipeline answers how much. A cash forecast needs to know when. Connecting the two means weighting opportunities by conversion rates measured from your own history, adding the lag between winning work and invoicing it, and using each customer’s actual payment behaviour rather than the terms on the invoice — so the business sees a cash gap thirteen weeks out, while there is still a choice about it.

SECTION 01

The pattern

In most businesses, two meetings happen in the same week and never meet. In the first, the sales pipeline is reviewed: names, values, who is close, who has gone quiet. In the second, the cash position is reviewed: the bank balance, the receivables listing, what must be paid and when. Both meetings are about the same company and the same months. Neither one uses anything from the other.

The cash forecast is built from the receivables ledger because that is where the reliable numbers live. But a receivables ledger can only contain invoices that have already been raised, for work that has already been done, arising from decisions taken weeks or months ago. It is a record of the past presented as a view of the future, and its horizon is limited to whatever is already owed. Beyond that point the forecast simply stops, or fills in with a number somebody is comfortable with.

Meanwhile the pipeline — the one piece of genuinely forward-looking information the business owns — is kept as a list of names and round figures, frequently in a notebook or a phone, occasionally in a spreadsheet, and discussed in terms of enthusiasm rather than dates. It can tell you that there is two hundred million in play. It cannot tell you which week any of it becomes money in the account, which is the only question the finance meeting is actually asking.

Between a name on a pipeline and cash in the bank sit three separate conversions, and each has its own probability and its own delay. The opportunity has to be won. The won work has to be delivered and invoiced. The invoice has to be paid. Businesses that forecast at all usually model the first of these and ignore the other two, which is precisely why a quarter in which everything was won can still produce a cash squeeze in the quarter that follows.

The practical consequence is a forecast horizon of two to four weeks in a business whose financing decisions need ninety days’ notice. The gap is discovered late, and by the time it is visible, the cheap responses have expired. What remains are the expensive ones: emergency overdraft, discounting receivables to collect early, stretching suppliers who will remember it, and delaying the statutory payments that carry interest and penalties.

SECTION 02

The Caribbean variant

Six conditions make the gap between pipeline and cash wider here, and the consequences of missing it more severe.

The pipeline is genuinely in one person’s head. Selling in this region is relationship work conducted by the principal or a long-serving director. That knowledge is real and valuable, and it is also undocumented, which means the business’s entire forward view walks out of the building at the end of each day and occasionally does not come back.

Stated terms and actual behaviour are different things. An invoice may say thirty days while the customer has paid at sixty-five for four years. Forecasting on terms rather than on behaviour produces a document that is arithmetically correct and practically useless, and it is the single most common reason a forecast is abandoned after two months.

Large institutional customers pay certainly but unpredictably. Government agencies, statutory bodies and large corporates are good credit and slow process. A contract won in March may not convert to cash until well into the second half, and the delay is procedural rather than negotiable. Winning that work without modelling its cash profile is how a business celebrates its way into a squeeze.

Working capital is paid out in advance and in foreign currency. Where stock is imported, the business funds it before it sells it, often in United States dollars, and then sells on local-currency credit. The cash gap is structural rather than occasional, which means it has to be planned rather than managed when it appears.

Revenue arrives in compressed windows. Tourism seasons, crop cycles, back-to-school, Christmas trade. The annual figures look balanced while the months do not, and a forecast built on averages will show comfort in exactly the weeks when the account is at its thinnest.

Financing is slow, secured and relationship-dependent. Extending a facility is not a same-week decision. It requires statements, security, and a conversation with a manager who will ask how long this has been foreseeable. A business that can only see three weeks ahead is asking for credit at the worst possible moment and from the weakest possible position.

SECTION 03

What it costs

The cost of a short forecast horizon is rarely recorded as a loss. It shows up as the price of decisions taken under time pressure, each of which looked unavoidable at the moment it was taken.

Indicative figures, drawn from advisory experience across the region rather than from survey data:

A two to four week horizon where the business’s own financing decisions require sixty to ninety days of notice to be made on reasonable terms
Two to five per cent of invoice value surrendered in early-settlement discounts offered to pull cash forward in a week when it was needed
Supplier discounts foregone and premium pricing accepted, where purchasing is timed by the bank balance rather than by the requirement
One to three days each month rebuilding a forecast by hand in a spreadsheet that one person maintains and nobody else can operate
Opportunity declined — the mirror-image cost, where a business holds cash defensively and turns down work because it cannot see what is coming

The largest item has no invoice attached. Growth consumes cash before it produces it: more work means more labour, more stock and more receivables, all funded ahead of collection. A business that cannot forecast cannot distinguish between growth it can fund and growth that will exhaust it, and the two look identical on an order book. The failure does not usually announce itself as a bad decision. It announces itself as a good month that could not be paid for.

A pipeline says how much. A forecast needs to know when. The distance between those two questions is where profitable businesses run out of money.

SECTION 04

What the capability actually does

Six mechanisms turn a list of opportunities into a forecast that can be relied on for a decision.

One document chain, from opportunity to receipt. The opportunity becomes a quote, the quote becomes an order, the order becomes a delivery and an invoice, the invoice is settled by a receipt — each document created from the one before it and carrying its reference. The forecast then reads a chain that already exists rather than being assembled from three systems and a conversation.

Conversion rates are measured, not asserted. What proportion of opportunities at each stage actually closed, calculated from the last year or two of the company’s own history. A stage that converts at forty per cent is weighted at forty per cent, however confident the person holding it happens to be this week.

The lag between winning and invoicing is modelled explicitly. This is the step almost every forecast omits. Work won in one month may be delivered over three and invoiced in the fourth, and where that lag is not modelled the cash arrives a quarter later than the forecast showed. Held per job type, it is the difference between a forecast that is roughly right and one that is confidently early.

Expected payment dates come from behaviour, not from terms. Each customer carries an average and a spread drawn from their own payment history. The forecast then uses what this customer does rather than what the invoice says, and a customer whose behaviour changes is visible as a trend rather than as a surprise.

A rolling thirteen-week view, refreshed rather than rebuilt. Committed inflows from invoices raised, weighted inflows from the pipeline, and outflows drawn from the ledger — payables, payroll, statutory obligations and debt service. Refreshed weekly from source data, so preparing it is not a project and no one person owns the file.

Variance is fed back into the assumptions. Last month’s forecast is compared with what actually happened, by category, and the conversion and collection assumptions are adjusted. This is what separates a forecast that improves from one that is merely defended, and it usually takes two or three cycles before the model earns trust.

Two limits worth stating plainly

A weighted pipeline is not a promise, and the forecast is only as honest as the stage discipline behind it: where deals are parked at ninety per cent because that is what the meeting rewards, the output will be wrong with considerable precision. Each stage needs an evidence test — a document, a date, a decision — rather than a feeling. And the forecast identifies the gap; it does not decide what to do about it. Whether to finance, defer, accelerate collection or decline work remains a management judgment, taken earlier and with better information.

SECTION 05

How the Accounting Services BPO Division delivers it

Horizon and cadence are agreed before anything is configured. Thirteen weeks rolling, refreshed weekly, is the standard for most trading businesses; project and construction businesses often need longer. The horizon should be set by how long the company’s own financing and purchasing decisions take, not by convention.

Stage definitions are written down with the person who sells. Each stage carries an evidence test that can be verified by someone other than the salesperson. This is a commercial conversation rather than a systems one, and it is where the credibility of every subsequent number is established.

History is extracted before assumptions are set. Twelve to twenty-four months of conversion, delivery and collection data are analysed to calibrate the model. The business is usually surprised by at least one of the three, and the surprise is itself a finding worth having before any forecast is issued.

Outflows are drawn from the ledger, not estimated. Payables, payroll, statutory obligations and debt service are loaded from the accounting records the Division already maintains. A forecast that estimates its outflows is only half a forecast, and it is always the half that fails in a difficult month.

The weekly issue carries commentary, not just a number. What changed since last week and why: deals moved, an invoice settled early, a customer slipped. A forecast without commentary is a document people stop opening by the fourth week.

A monthly variance review keeps the model honest. Forecast against actual, by category, with assumptions adjusted and the adjustment recorded. Over a few cycles the model tightens, and the business learns which of its own beliefs about conversion and collection were never true.

SECTION 06

Where to start

Days 0 to 30 — three numbers from your own history. From the last twelve months: the proportion of quoted work that was won; the average days from winning work to raising the invoice; and the average days from invoice to payment, split between your largest customer type and everyone else. Then build one thirteen-week sheet by hand using those three numbers. It will be imperfect, and it will still show you more than the receivables listing has ever shown you.

Days 30 to 90 — put the pipeline somewhere it can be read. One place, agreed stages with evidence tests, and the document chain linked so that orders become invoices without re-keying. Weekly refresh established. Customer payment behaviour loaded from history rather than from terms.

Beyond 90 days — use it before you need it. The forecast in the monthly pack beside job margin. The variance review running. And the conversation with the bank held when the gap is ninety days away rather than three weeks — which is the difference between negotiating a facility and requesting one.

The question at the end is not what the pipeline is worth. Every business can answer that, and the answer is always encouraging. The question is which week the money lands, and whether the account can meet the Tuesday before it does.

FREQUENTLY ASKED QUESTIONS

Six questions this raises

Do we need to buy a CRM for this, and will our sales people use it?

You need the pipeline to exist somewhere other than a phone, with agreed stages and dates. For a small sales team that can be a structured part of the platform you already run rather than a separate product. Adoption follows from keeping what is asked for minimal: stage, expected value, expected date, and what evidences the stage.

We win a few large contracts rather than many small ones. Does weighting work?

Not on its own. With a small number of large deals, a weighted average describes an outcome that cannot actually occur, so the forecast is run as scenarios instead — expected, without the largest deal, and without the two largest. The discipline of dates and lags matters more in a lumpy business than the arithmetic of probability does.

Our customers pay when they pay, whatever the terms say. What use is a forecast?

That is precisely the case the forecast is built for. Irregular payment is still patterned: customers have averages, spreads and seasons, and those can be measured from your own ledger. The forecast then plans for the behaviour rather than repeating the terms, and the variance review tightens it each month.

Is a thirteen-week forecast excessive for a business of our size?

The horizon should match the lead time of your decisions, not the size of the business. If arranging a facility, ordering stock or committing to a hire takes sixty days, then a four-week forecast cannot inform any of them. Smaller businesses often need the longer horizon more, because their access to short-notice financing is weaker.

Who maintains this — our team or yours?

The pipeline is yours: only the people selling can say what stage a deal is at. The Division maintains the model, loads outflows from the ledger, refreshes the forecast weekly and issues it with commentary. The division of labour is the same as everywhere else in this series — you hold the judgments, we hold the process.

How is it priced?

Fixed monthly by scope — forecast horizon, refresh cadence, number of entities and the complexity of the customer base — rather than by the hour. The initial history analysis and model build are quoted separately as a one-time project, and scope is established by the Finance Function Diagnostic before any fee is quoted.

Next step

Request the Finance Function Diagnostic.

A 45-minute scoping conversation covering pipeline structure, customer payment behaviour, forecast horizon, entities and reporting cadence; a written recommendation on scope, division of labour and transition plan; and a fixed-scope service proposal priced by process, with service levels and exit terms stated.

Dawgen Global · Accounting Services BPO Division

[email protected] · dawgen.global/contact-us

Caribbean (876) 926-5210 | (876) 929-3670 · United States 855-354-2447

Big firm capability without the big firm price.

Continue reading: One Login for Finance, People and Sales Is Not a Convenience. It Is a Control. (Article 11) · Nine Days to Close, Not Ninety. (Article 19) · The Monthly Management Pack, Page by Page. (Article 20)

Indicative figures are drawn from advisory experience across the region and are not survey output. This series addresses patterns observed across accounting and advisory engagements and does not comment on any specific client.

About Dawgen Global

Dawgen Global is an independent, integrated multidisciplinary professional services firm headquartered at 47 Trinidad Terrace, New Kingston, Jamaica, serving more than 15 territories across the Caribbean. Founded and led by Dr. Dawkins Brown, Executive Chairman, the firm is independent and not affiliated with any international network. It delivers a full suite of professional services under one roof: audit and assurance; tax advisory; IT and digital transformation; risk management; cybersecurity; actuarial and insurance regulatory advisory; HR advisory; mergers and acquisitions; corporate recovery; business advisory and strategy; accounting BPO and virtual CFO services; and legal process outsourcing.

The proposition is simple: big-firm capability without the big-firm price. Dawgen Global’s integrated approach is built for the specific complexities and opportunities of the Caribbean market, helping organizations make sharper, better-informed decisions that drive measurable progress.

To explore a partnership, reach out: