Report the Pipeline Without Turning It Into Cash
This lesson gives boards, finance teams and fundraising leaders a reporting model that shows bequest pipeline health, activity and opportunity without converting living-donor intentions into budget-year revenue.
Listen to the lesson
Leadership needs visibility, not fantasy
A bequest pipeline that never appears in leadership reporting will be underfunded, misunderstood and easy to neglect.
A bequest pipeline that appears as expected income will be misread.
Lesson 1 established that a disclosed intention is not income. Lesson 3 built the CRM stages that protect that distinction. This lesson turns the same discipline into board and finance reporting.
The reporting challenge is real. Bequests are not minor. Research for the JBWere Bequest Report estimates that about $150 billion passes through inheritances in Australia each year, while only about $1.3 billion — roughly 1% — goes to charity. The Productivity Commission estimated that about $3.5 trillion in assets will change hands by 2050. Sector bodies also cite strong long-run returns from gifts-in-wills fundraising, sometimes around $28 returned for every $1 invested, while warning that results vary and play out over long timeframes.
Leadership should care about that.
But those figures describe opportunity and long-horizon return. They are not a licence to book living-pipeline records as income.
Australian sources cluster around 6.5–8% of wills containing a charitable gift, while roughly a third of Australians say they would consider one. Wishart and James found that bequest intentions are volatile; donors can add, remove or change charitable gifts as circumstances shift. The Facts Pack also warns that realised bequest income is delayed and lumpy. Estate values move. Family circumstances change. Timing is uncertain.
The reporting task is to hold both truths at once.
The pipeline is strategically important.
The pipeline is not cash.
The five controls of honest bequest reporting
Use these five controls whenever bequest pipeline information goes to a board, CEO, finance committee, campaign cabinet or senior fundraising meeting.
- 1 Name the report purpose before showing the number What it is: Every bequest report must say what kind of decision it is meant to support. A number without a purpose will be used for the nearest leadership anxiety: budget gap, campaign target, income forecast or staff-performance pressure. How to use it: Label the report as one of three types before presenting data. Type 1 — Activity report: Shows what the team did and what donors did during a period. What it looks like: “Quarter 1 activity: 42 gifts-in-wills information requests, 17 approved wording packs sent, 9 new active-consideration records, 4 disclosed intentions recorded, 0 living-pipeline records included in revenue forecast.” Type 2 — Pipeline-health report: Shows the condition of the system. What it looks like: “Pipeline health at 30 September 2026: 186 live records; 22 records missing permission status; 14 tasks overdue by more than 14 days; 9 records paused due to donor preference or supporter-care trigger; 0 records with unsupported forecast value.” Type 3 — Finance treatment report: Shows what, if anything, may be included in financial planning. What it looks like: “Finance treatment: Stages 1–5 are living-pipeline records and are excluded from budget-year income forecast. Stage 6 records are closed to the living pipeline and handled through Course 3 and finance procedures. Realised estate income is reported separately when recognised under approved finance policy.” Why it matters: A board can use the same pipeline data for three different decisions. Labelling the purpose prevents the activity report from being mistaken for a cash report.
- 2 Count evidence categories, not imagined value What it is: Living-pipeline reporting should count records by evidence strength, not by hoped-for gift size. The six CRM stages from Lesson 3 already provide the evidence categories. How to use it: Report stage counts, movement between stages, and missing-data risks. Do not multiply records by an average gift amount unless there is a board-approved finance methodology that explicitly governs long-range modelling and states the uncertainty. What it looks like: “Living bequest pipeline by evidence stage: Stage 1 — Information enquiry: 61 Stage 2 — Values interest: 74 Stage 3 — Active consideration: 28 Stage 4 — Disclosed intention in progress: 11 Stage 5 — Disclosed current inclusion: 7 Stage 6 — Realised / closed to living pipeline: 3 handed to Course 3 workflow this quarter.” What not to write: “7 confirmed bequests worth estimated $1.4m.” Why it matters: Stage counts are evidence. Estimated values on unvalued living intentions are usually confidence theatre.
- 3 Use forecast exclusion as the default setting What it is: The default finance treatment for Stages 1–5 is exclusion from income forecast. That does not mean the records are unimportant. It means the organisation does not control timing, value or final outcome. How to use it: Put the forecast rule in the report, not only in the CRM. Finance and board readers should not have to infer it. What it looks like: “Forecast treatment: All living-pipeline records in Stages 1–5 are excluded from budget-year revenue forecasts. No value or probability score has been attached to donor intentions. The pipeline is reported for long-term fundraising health, stewardship workload and future resilience.” What to do if leadership asks for long-range modelling: Separate modelling from forecasting. A responsible modelling note might say: “Scenario modelling may be used to test long-term investment capacity, but it is not a revenue forecast. It must be shown as a range, based on documented assumptions, and must not be attached to individual donor records unless the donor has disclosed relevant information.” Why it matters: Forecast exclusion protects both sides of the organisation. Fundraising can argue for long-term investment without promising cash. Finance can plan responsibly without ignoring the pipeline.
- 4 Report movement and leakage, not only totals What it is: A useful bequest report shows whether the pipeline is being managed. Total record count can rise while quality declines. Movement and leakage reveal the real operating condition. How to use it: Include a short movement section in every quarterly report. What it looks like: “Quarterly movement: New Stage 1 enquiries: 42 Stage 1 moved to Stage 2: 13 Stage 2 moved to Stage 3: 5 Stage 3 moved to Stage 4: 2 Stage 4 moved to Stage 5: 1 Records paused: 6 Records closed due to insufficient evidence: 8 Records handed to Course 3 workflow after estate notification: 3 Records with overdue tasks reduced from 21 to 9.” What to watch: A healthy report does not only celebrate upgrades. It also shows repair, pause, closure and handover. Removing unsupported records is not failure. It is data hygiene. Why it matters: Boards often ask, “How many legacy prospects do we have?” A better question is, “Is the pipeline becoming more accurate, more permission-safe and better managed?”
- 5 Separate living-pipeline reporting from estate-administration reporting What it is: This course owns the living pipeline up to estate notification and the CRM closeout after Course 3’s process has run. Course 3, “After the Will Is Read,” owns estate notification, internal estate workflow, realised-gift distribution handover, restricted-gift escalation, charity-identity risk, family-provision risk, legal-identity checks and gift-acceptance judgment. How to use it: Create a reporting boundary between living-pipeline metrics and estate-administration metrics. What it looks like: “Living pipeline report: Stages 1–5, including activity, stage movement, permissions, tasks, pauses and forecast exclusion. Course 3 estate-administration report: Estate notifications, realised gifts, distributions, restrictions, legal-identity checks, family-risk escalation and finance recognition. CRM closeout report: Stage 6 records removed from living pipeline after Course 3 workflow reference is recorded.” What not to do: Do not include live estate disputes, restricted-gift interpretation, legal-name problems or family-provision risk inside the living-pipeline report. That is Course 3 territory. Why it matters: A board report that blends living donor intentions with estate administration will confuse three different realities: relationship pipeline, legal administration and recognised income.
The board pack that turns a pipeline into a budget patch
Riverbank Women’s Legal Centre is preparing papers for its finance committee. The centre supports women navigating housing insecurity, debt, family violence and workplace exploitation. Demand is rising, and the CEO wants a credible case for long-term fundraising investment.
The gifts-in-wills pipeline has improved over the past year. The CRM now shows:
Stage 1 — Information enquiry: 39
Stage 2 — Values interest: 52
Stage 3 — Active consideration: 16
Stage 4 — Disclosed intention in progress: 8
Stage 5 — Disclosed current inclusion: 5
Stage 6 — Realised / closed to living pipeline: 1 record handed to Course 3 this quarter
One Stage 5 donor is Rosalind Vale, a retired tenancy advocate and long-loyal donor. Her record says:
“Letter received 5 June 2026. Rosalind Vale wrote: ‘My current will includes Riverbank Women’s Legal Centre. Please keep that private. I spent my working life watching women lose housing because they had no one beside them early enough, and I want that help to keep existing.’ No amount, percentage, clause or solicitor details provided. No public recognition permission. Annual private update by post permitted. Exclude from income forecast.”
The development director drafts this board-pack line:
“Bequest pipeline now includes 13 confirmed or likely gifts. Using a conservative internal average, expected future income is estimated at $2.1m. Recommend finance include $300k in the outer year of the three-year forecast.”
The line is tempting because the organisation needs the money and the pipeline has genuinely improved.
It is still wrong.
The 8 Stage 4 records are intentions in progress, not current confirmed inclusion. The 5 Stage 5 records are stronger, but still unvalued, untimed and revocable. Rosalind’s record explicitly says private, unvalued and excluded from forecast. The proposed report also smuggles in a probability model without naming its assumptions.
A stronger board-pack section would read:
“Gifts-in-wills pipeline health has improved, but no living-pipeline records are included in the revenue forecast.
At 30 September 2026, Riverbank holds 120 live gifts-in-wills records:
Stage 1 — Information enquiry: 39
Stage 2 — Values interest: 52
Stage 3 — Active consideration: 16
Stage 4 — Disclosed intention in progress: 8
Stage 5 — Disclosed current inclusion: 5
One Stage 6 record was handed to the Course 3 estate-administration workflow this quarter and has been removed from the living pipeline.
Forecast treatment:
Stages 1–5 are excluded from budget-year and three-year revenue forecasts. No value or probability score is attached to living donor intentions. Estate notifications and realised income are reported through Course 3 and finance procedures.
Pipeline-health indicators:
– 18 new information enquiries this quarter
– 6 records moved from Stage 1 to Stage 2
– 3 records moved from Stage 3 to Stage 4
– 2 records paused due to donor contact preferences
– 7 records missing recognition-permission fields
– 4 tasks overdue by more than 14 days
Board decision requested:
Approve continued investment in gifts-in-wills administration and stewardship capacity because the pipeline is growing and record quality is improving. Do not treat the living pipeline as revenue relief for the current deficit.”
That version still makes the case.
It gives leadership evidence of work, movement and risk. It names the opportunity without inventing timing. It protects donor privacy. It tells finance exactly how the records should be treated. It lets the board support a long-horizon program without pretending that Rosalind’s private estate decision is a receivable.
Build the board-ready bequest dashboard
Create a one-page bequest dashboard with four sections. Use the same structure every quarter so leadership learns how to read the pipeline.
Section 1 — Strategic context
Use two or three sourced facts only.
### Example:
“Research for the JBWere Bequest Report estimates that about $150 billion passes through inheritances in Australia each year, with around $1.3 billion — roughly 1% — going to charity. Australian sources cluster around 6.5–8% of wills containing a charitable gift, while roughly a third of Australians say they would consider one. Bequest fundraising is therefore a long-term opportunity, not a short-term revenue fix.”
Section 2 — Living-pipeline evidence
Report stage counts and movement.
### Example:
“Live records: 120.
Stage 1: 39
Stage 2: 52
Stage 3: 16
Stage 4: 8
Stage 5: 5
New records this quarter: 18
Records moved forward: 9
Records paused: 2
Records closed due to insufficient evidence: 4.”
Section 3 — Management health
Report whether the system is safe.
### Example:
“Overdue tasks: 4.
Records missing permission fields: 7.
Records with unsupported value attached: 0.
Records missing next action: 3.
Records needing data repair before next board report: 10.”
Section 4 — Finance treatment
Use a fixed line every time.
### Example:
“Stages 1–5 are living-pipeline records and are excluded from budget-year income forecasts. No value or probability score is attached to unvalued donor intentions. Estate notifications and realised income are handled through Course 3 and finance procedures.”
Then add one decision line.
### Good decision line:
“Decision requested: maintain investment in gifts-in-wills administration and stewardship capacity so pipeline quality, donor care and long-term resilience continue to improve.”
### Weak decision line:
“Decision requested: recognise future bequest income.”
The dashboard should make the pipeline visible without making it spendable.
A board should be able to see whether the bequest pipeline is growing, clean, permission-safe and actively managed. It should not be invited to treat private, revocable intentions as forecast income.
What honest reporting protects
Honest bequest reporting protects the donor, the fundraiser, finance and leadership.
It gives the board visibility without false comfort. It gives finance clear forecast boundaries. It gives fundraising a way to argue for long-term investment. It gives the CRM team a reason to fix missing permissions, overdue tasks and unsupported stage labels.
The five controls are simple: name the report purpose, count evidence categories rather than imagined value, default living-pipeline records to forecast exclusion, report movement and leakage, and keep estate-administration reporting separate under Course 3.
The strongest bequest report does not say, “Here is money we can count on.”
It says, “Here is the long-term pipeline we are managing, here is the evidence behind it, here is the risk we are reducing, and here is what we are not allowed to claim.”