Sales Pipeline Audit for Founders: A Worked Review
Nour
Founder, Coachful
A sales pipeline audit for founders checks whether the portfolio can support a real decision. It reconciles duplicate and closed records, examines buyer evidence, separates opportunity value from cash, and asks whether the team could deliver the work it is pursuing.
Coachful is our #1 recommendation for keeping a coaching practice's lead conversations, follow-ups and eventual delivery handoff connected. Use its records alongside a clearly defined audit sheet and the appropriate financial records. A pipeline label is not a bank balance, a contract interpretation or a capacity reservation.
The worked audit below covers eight rows, seven unique opportunities, two dated reviews and an actual decision about an advance supplier payment. All numbers and events are fictional. The point is to improve decisions without manufacturing a stronger-looking forecast.
Start with the decision and the measurement boundary
Write the decision first: whether to reserve a contractor, accept a start date, change sales effort or revise a cash plan. Then define the period, service, currency and unit. An opportunity is a possible purchase, not necessarily a unique contact or a proposal version.
Keep four measures separate. Face value is the amount under discussion. A new-contract target concerns agreements reached in a defined period. Revenue recognition follows the appropriate accounting treatment. Cash concerns actual or forecast payments on particular dates.
The SBA's business-finance guidance distinguishes cash and accrual recording and identifies receivables, payables, available cash and bank reconciliation as responsibilities to manage. Your accountant should apply the relevant treatment; this operating audit does not establish when revenue must be recognized.
Take a dated snapshot before changing records. Keep the original classification and the reason for each correction. Otherwise a smaller pipeline may look like deteriorating demand when the actual change was removing a duplicate and admitting that a sale had already been lost.
Use six evidence questions rather than six compulsory columns
Audit the following areas across your existing stages. These are operating questions, not a claim that every sale must pass through an identical sequence or that these are Coachful's default stage names.
| Audit area | Evidence to inspect | Useful next output |
|---|---|---|
| 1. Fit | What service or problem is actually under discussion? | A clear fit decision or a defined question |
| 2. Discovery | What did the buyer confirm or correct? | A shared scope summary |
| 3. Decision route | Who evaluates, approves spending and signs? | Named dependencies without invented authority |
| 4. Proposal | Which version, price and inclusions are being reviewed? | The exact current document and review step |
| 5. Procurement and delivery | Which checks, dates and resources are still required? | A feasible conditional handoff |
| 6. Outcome and timing | Won, lost, deferred or active, based on what? | Honest forecast treatment and follow-up |
Ask for the last meaningful buyer action, not just the last activity in your system. A founder sending three reminders creates activity; it does not establish three signs of buying progress. An internal proposal rewrite is also different from a buyer agreeing to review it.
For stage design itself, use the separate coaching sales pipeline guide. Here the task is auditing a live portfolio against its evidence.
Worked example: reconcile the first snapshot
Fictional case: Talia runs a coaching and leadership-workshop practice. On 2 November 2026, she wants to know whether she can responsibly make a nonrefundable $6,000 advance payment to reserve an additional delivery supplier. The decision is due on 13 November. Her new-contract target for November is $40,000.
All case amounts are US dollars. For this simplified illustration, no sales tax applies to these fictional transactions. The later cash schedule includes the practice's existing tax and operating payments. It is a planning model, not a tax determination or advice about another business.
| Row | Face value | Evidence on 2 November | Initial audit treatment |
|---|---|---|---|
| P1 Aster | $30,000 | Learning manager requested an outline; no confirmed budget or decision date | Active exploratory discussion; remove claimed imminent close |
| P2 Birch | $18,000 | Buyer agreed to review proposal version 2 on 10 November | Active proposal review |
| P3 Cedar | $24,000 | Security reviewer accepted a review appointment on 20 November | Active procurement; signature timing unknown |
| P4 Dune | $12,000 | Service preferred, but purchase order and signed terms outstanding | Active approval process; no executed agreement |
| P5 Elm | $8,000 | Buyer declined on 21 October | Lost; exclude from active value |
| P6 Fern | $10,000 | Buyer and Talia agreed a review on 12 January 2027 | Deferred; exclude from November active pursuit |
| P7 Grove | $6,000 | Agreement signed 28 October; $3,000 received 30 October | Prior-period win; keep remaining delivery and receipt separately |
| P8 Aster draft | $30,000 | A second proposal-version row for the same P1 purchase | Duplicate opportunity, not another $30,000 sale |
The raw total is $138,000. Removing the $30,000 duplicate leaves seven unique opportunities worth $108,000. Excluding Elm's $8,000 loss, Fern's $10,000 deferral and Grove's $6,000 prior win leaves four active opportunities worth $84,000.
Grove's remaining $3,000 is due on 11 December after the contracted delivery. It is not new November pipeline or a November cash receipt. Its October deposit is already reflected in the later opening balance; adding it again would count the same cash twice.
Talia preserves the earlier raw figure with an explanation of the changes. She does not erase Elm's loss or call the duplicate a new rejection. These are corrections to different record problems.
Complete the uncertain buyer conversation
Aster had been the most optimistic row. Talia's contact, Anika, likes the proposed work and requested an outline, but has not said that funding is approved. Talia cannot turn that enthusiasm into a November purchase date.
She sends the requested outline on 4 November with this question:
Here is the outline we discussed. Before I propose delivery dates, could you tell me how the scope will be reviewed and whether there is an approved budget? If timing is still exploratory, I can record that and avoid reserving a start date you have not requested.
On 5 November, Anika replies that no funding decision is possible before February 2027. She asks Talia not to chase in November and agrees to a short check on 2 February. Talia acknowledges that arrangement the same day and records it.
The completed output is a deferred opportunity with a specific future check, not a lost sale and not a pending November close. The $30,000 remains the discussed scope value; it is excluded from the active pursuit total at the next cutoff. No February purchase is assumed.
A contrasting case is Cedar. Its long interval contains an actual accepted security-review step. That is meaningful activity, even though it does not establish a signature date. Age alone would not justify deleting Cedar, just as a recent friendly exchange did not justify treating Aster as near-certain.
Audit the current proposal and dependencies
At Birch's 10 November review, the buyer confirms that version 2 describes the requested scope. The spending decision is still scheduled for an internal vote on 17 November. Talia records the actual scope confirmation and future vote separately. The buyer has not signed or promised a payment date.
For Dune, the purchasing contact completes a document check on 12 November but cannot yet give a purchase-order issue date. The unsigned terms remain unsigned at the 13 November cutoff. The buyer would like a 30 November start. Talia explains by ordinary email that the date remains provisional pending the required approvals and her delivery confirmation.
She does not provide a categorical legal opinion about whether every verbal statement is binding. She checks the actual agreement requirements with the appropriate adviser and preserves the current status rather than inventing an executed document.
For a corporate purchase, identify the operating contact, budget authority, signatory and any specialist reviewer. Do not ask a champion to guarantee another team's response. A security review date is not an approval date, and a proposal deadline written by the seller is not automatically a buyer commitment.
The corporate coaching contracting guide develops the scope and approval discussion. Keep the version, requirements and delivery assumptions visible when handing an opportunity to operations.
Reconcile the second snapshot before calculating coverage
At 13 November, P1 and P6 are deferred, P5 is lost and P7 is the prior-period win. P2, P3 and P4 remain active. Their values are $18,000, $24,000 and $12,000, totaling $54,000.
The seven unique opportunities still total $108,000: $54,000 active, $40,000 deferred, $8,000 lost and $6,000 already won in October. The audit has changed classifications and removed a duplicate; it has not generated a new purchase.
For the $40,000 November new-contract target, the original raw ratio was $138,000 ÷ $40,000 = 3.45. The current active-value ratio is $54,000 ÷ $40,000 = 1.35. Calling either number sufficient November coverage would ignore timing and evidence.
Talia separately identifies Birch and Dune as provisional November decision candidates because their buyers have described that aim. Their combined value is $30,000, or 0.75 times the target. That is a defined candidate set, not a forecast that either will sign. Cedar's review remains active, but the buyer has not supplied a decision month.
Cedar also represents $24,000 ÷ $54,000, approximately 44.4% of active face value. That concentration matters when discussing uncertainty. A portfolio of many small opportunities and this three-opportunity portfolio would not carry identical dependence on one purchase.
Use conversion history with the right denominator
Talia's fictional earlier comparison cohort contains eight resolved opportunities with an original combined value of $80,000. Two were won, totaling $24,000. This gives a count conversion of 2 ÷ 8 = 25%, and a value conversion of $24,000 ÷ $80,000 = 30%.
The two historical wins were $10,000 and $14,000. The six losses were $8,000, $8,000, $8,000, $10,000, $10,000 and $12,000. Those loss values total $56,000, reconciling the full $80,000 cohort. Retaining them prevents the audit from deriving a conversion rate from wins alone.
The historical values range from $8,000 to $14,000. Current Cedar and Birch are larger, so even this same-practice history is an imperfect comparison. Talia records the difference rather than describing 30% as a calibrated probability. A larger current contract might have different review requirements, timing and delivery work.
Those percentages answer different questions. Applying the count rate to dollars is not justified simply because it is easier to remember. Nor do eight historical opportunities supply a reliable probability for every current buyer.
If she uses the 30% historical value rate as a rough sensitivity assumption, $54,000 × 30% = $16,200. That modeled figure is not signed value, recognized revenue or cash. It does not establish the month in which a purchase or payment might occur.
Check comparability before using history: service size, buyer type, stage definition, acquisition route and observation period. Include resolved losses rather than selecting only successful examples. A cohort still containing open opportunities needs an explicit treatment of those records and elapsed time.
Use a few assumptions to explore exposure, not decimals to conceal weak evidence. An improved audit can conclude that there is not enough comparable history for a defensible weighted forecast. That is useful information for the founder's decision.
Build the cash bridge without inserting the pipeline
Talia's finance owner, Uma, prepares a dated November cash schedule from existing records. Australia's business.gov.au cash-flow guidance describes recording the opening balance, timing incoming and outgoing cash, clearly labeling estimates and calculating the closing balance. These are planning mechanics; a forecast receipt remains uncertain until received.
At 2 November the model contains the following amounts. The two expected receipts concern earlier invoiced work outside the eight-row opportunity snapshot. They are not Aster, Birch, Cedar, Dune or Grove's December balance.
| Date | Cash movement | Modeled balance without new advance |
|---|---|---|
| 2 November | Opening bank balance $14,000 | $14,000 |
| 6 November | Expected earlier-invoice receipt $5,000 | $19,000 |
| 10 November | Existing payments $8,000 | $11,000 |
| 16 November | Expected earlier-invoice receipt $7,000 | $18,000 |
| 20 November | Existing payments $9,000 | $9,000 |
| 27 November | Existing payments $5,000 | $4,000 |
The arithmetic is $14,000 + $12,000 incoming − $22,000 outgoing = $4,000 forecast closing cash. Uma's outgoing totals include the existing wages, taxes, fees and operating commitments in this simplified case. This is not a profit calculation or the founder's freely spendable income.
By 13 November, the $5,000 has actually arrived and the $8,000 has actually been paid. The observed balance is $11,000. The $7,000 due on 16 November and later outflows remain forecast events. Talia does not call the whole month's schedule actual.
Adding a $6,000 advance on 13 November would reduce the modeled closing balance from $4,000 to minus $2,000, even if both expected receipts arrive. It also creates exposure to a late receipt. The active pipeline's $54,000, or the modeled $16,200 conversion figure, cannot fill that cash gap without actual agreements and payment timing.
Test a delayed receipt on its date
Uma also models the $7,000 receipt arriving on 24 November instead of 16 November. This is an unobserved stress assumption, not a newly reported late payment. Without the advance, the $11,000 balance after 10 November falls to $2,000 when the $9,000 payment leaves on 20 November. The delayed receipt then raises it to $9,000, before the final $5,000 payment leaves $4,000.
If Talia had paid the additional $6,000 on 13 November, that same path would instead be $5,000, then minus $4,000 on 20 November, then $3,000 after the delayed receipt, and minus $2,000 after the final payment. The lowest modeled balance is worse than the month-end figure. A positive annual sales target would not remove that dated shortage.
They do not assume a loan, overdraft, accelerated client payment or delayed wage payment will fill it. Each would require its own actual feasibility and authorization. The completed audit decision can be to avoid the new commitment while the founder obtains stronger evidence, rather than to manufacture an optimistic receipt date.
Check delivery capacity as a separate gate
Talia tests a scenario in which all three active opportunities require work in the week of 30 November through 4 December. No buyer has secured that combined calendar. Talia has forty working hours available and retains four as contingency. Existing delivery and fixed business work already use twenty-four hours, leaving twelve planned hours for new work.
Dune would require eight hours that week: three live, three preparation and two follow-through. Birch would require twelve: four live, five preparation and three follow-through. Cedar would require twenty: six live, eight preparation and six follow-through. These are full-work estimates for that week, not only session lengths.
Accepting all three would require twenty-four existing hours plus forty new hours, totaling sixty-four. That exceeds the thirty-six-hour planned ceiling by twenty-eight. Dune alone would leave four planned hours; Birch alone would use all twelve; Cedar alone would exceed the available twelve by eight.
The supplier advance would be one possible way to explore additional capacity, but no additional staff time is assumed available merely because a payment is proposed. Scope, actual availability, quality, confidentiality and commercial terms would still need checking. Cash feasibility and delivery feasibility are separate decisions.
On 13 November Talia declines to make the nonrefundable advance and tells the supplier she has not reserved their capacity. She also confirms to the three active buyers that start dates remain subject to the outstanding process and her separate delivery confirmation. She does not replace an unfunded reservation with an unconditional client promise.
Save the completed decision sheet and follow-through
| Decision field | Completed 13 November entry |
|---|---|
| Portfolio | Seven unique opportunities; three active worth $54,000 |
| Near-term candidate set | Birch and Dune $30,000; buyer-described November aim, no executed agreements |
| Cash authority | Uma's dated schedule; observed balance $11,000, later receipt and payments still forecast |
| Advance decision | Do not pay $6,000 or reserve the supplier; supplier informed |
| Delivery gate | No unconditional overlapping starts; twelve planned hours remain before new work |
| Next evidence | Birch's future 17 November vote, Cedar's future 20 November review, Dune's unresolved purchase-order timing |
| Deferred contacts | Aster 2 February check and Fern 12 January review, as agreed with each buyer |
The completed audit produces a spending decision, accurate records and specific future checks. At this cutoff no new contract, future collection, delivered workshop or contractor arrangement has been established. The audit improves visibility without claiming that it improves conversion by a measured amount.
Keep the operating record useful in Coachful
- Open the correct lead. In the released navigation, use Sell > People to follow up with > Leads. Older demo images may say Prospects. Check the actual person and opportunity before adding another record for a revised document.
- Inspect actual source material. Forms Submitted shows the lead's submitted forms and answers. Record the buyer's confirmation and material uncertainty in the relevant notes; do not interpret form completion as purchase approval.
- Schedule a specific follow-up. In the lead's call and follow-up area, use a useful note, date and time, with a reminder if needed. The founder's internal reminder is not evidence that the buyer accepted an appointment.
- Record what happened. The supported follow-up outcome note can capture the actual response after completing a follow-up. For Aster, the meaningful result is no funding decision before February and the agreed future check, not “proposal sent, likely won.”
- Keep financial and service gates distinct. A stage change is not a payment, signed agreement or delivery grant. When a purchase is actually ready, configure the real Offer inclusions and terms, then verify its separate agreement, payment and access process.
These are source-based product instructions, not a claim of account execution. Explore the relevant Coachful features while keeping the audit sheet's assumptions and finance schedule explicit.
Troubleshoot the next review
Everything is near closing. Ask for the buyer action, current document and unresolved approval. A weak quarter is a reason to improve the sales plan, not to move uncertain value into committed cash.
Old opportunities dominate. Compare age with the buying process and last meaningful action. Distinguish deferred timing, a live procurement dependency, a confirmed loss and no response. None requires insulting labels or a universal sixty-day purge.
A large deal crowds out smaller work. Show its share of value, capacity and founder attention. Keep alternatives visible without assuming a high-value buyer has a high probability of purchase.
Follow-up becomes unwanted marketing. Respect the actual request and preference. The ICO's business-to-business marketing guidance, currently under review, distinguishes subscriber types and explains that personal-data rules and objections can still apply. Do not treat every business address or earlier conversation as permission for every campaign.
Frequently asked questions
What is a good pipeline coverage ratio?
There is no universal number that validates a portfolio. Define eligible value, period and target, then examine conversion history, timing and concentration. Talia's raw 3.45 ratio included records that could not support the November decision.
Should a proposal always be reviewed in a live call?
No. Use a format that helps the buyer and fits their process. What matters is understandable scope and an actual review route, rather than a seller-imposed presentation rule.
Can a weighted pipeline fund a payment commitment?
It is not available cash. Examine actual balances, dated expected receipts, obligations and downside scenarios with the responsible finance person. A modeled conversion figure does not establish collection timing.
Should deferred opportunities be deleted?
Not automatically. Record the actual status and proportionate future arrangement. Aster has a February check; Cedar has a nearer procurement review. Their different timing should remain visible rather than be forced into one aging rule.
How do I know the audit is finished?
Reconcile the chosen snapshot, preserve the reasons for changes and complete the decision it was meant to support. Identify future evidence explicitly. Finishing an audit does not require a buyer to purchase or a forecast event to have already occurred.
