Close the Living Pipeline After Realisation
This lesson shows how to close a bequest record in the CRM after Course 3’s estate-administration process has run: mark the record realised, preserve the history, remove it from living-pipeline reports and stop it from distorting future stewardship or forecasting.
Listen to the lesson
Realised does not mean “keep it in the pipeline”
A bequest record should not sit in the living pipeline after the estate-administration process has run.
That sounds obvious. It often does not happen.
Some records remain in “confirmed bequest” forever because no one closes the stage. Some are counted twice: once as a living disclosed intention and again as realised estate income. Some stay in stewardship lists after the donor has died. Some keep an old forecast value attached even after the actual distribution has been received. Some lose the living-donor history because the estate case overwrites the relationship record.
This lesson is not about estate administration.
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.
This lesson starts after that work has produced a clean internal handover back to the CRM: the estate workflow reference, the realised-gift outcome, the finance treatment, and the instruction that the living-pipeline record can now be closed.
The Facts Pack warns that realised bequest income is delayed and lumpy. Estate values fluctuate. A gift discussed years earlier may arrive at a different value, or not arrive at all. That uncertainty is one reason the living pipeline must stay separate from realised income.
Closeout is the final proof of that discipline.
The CRM should preserve the donor’s story and administrative history without leaving the record active, forecastable or contactable as though the donor were still in the living pipeline.
The seven controls for realised closeout
Use these seven controls once Course 3 has completed the estate-administration process or has provided the approved internal handover needed to close the living-pipeline record. Do not use this framework to run the estate process itself.
- 1 Course 3 workflow reference What it is: The CRM closeout must point to the Course 3 estate-administration workflow, not repeat it. How to use it: Record the estate case ID, handover date, responsible estate-administration owner, and closeout instruction. Do not copy sensitive estate correspondence, legal analysis or dispute notes into the living-pipeline record unless your organisation’s permissions and policies require it. What it looks like: “Course 3 workflow reference: Estate case C3-2027-041. Estate administration completed by Estate Gifts Officer, 12 August 2027. Course 3 closeout instruction received: mark living-pipeline record realised and remove from active pipeline.” What it prevents: It stops the CRM team from re-deciding matters that belong to Course 3. It also gives future staff a clear trail without turning the donor record into an estate-law file.
- 2 Final living-pipeline stage closure What it is: The record must move to Stage 6 — Realised / closed to living pipeline. How to use it: Close the living stage only after the approved handover exists. Do not move a record to realised merely because an estate notification arrived. Estate notification triggers Course 3. Realised closeout follows Course 3. What it looks like: “Pipeline stage changed from Stage 5 — Disclosed current inclusion to Stage 6 — Realised / closed to living pipeline, 14 August 2027. Reason: Course 3 workflow completed and finance handover recorded.” What it prevents: It stops estate-notification records from being prematurely treated as realised income. It also stops realised records from lingering as active donor intentions.
- 3 Realised outcome field What it is: The CRM should record the realised outcome in a controlled field, not as a loose note that can be confused with an estimate. How to use it: Record only the outcome confirmed through Course 3 and finance procedures: realised amount, date received or recognised, gift type if supplied by Course 3, and finance reference. Do not interpret restrictions, validity, family issues or legal identity here. What it looks like: “Realised outcome: $1,840,000 received through estate distribution. Finance reference: FIN-BEQ-2027-118. Outcome supplied by Course 3/Finance handover. Do not edit from pipeline screen.” What it prevents: It separates actual realised income from living-pipeline estimates, donor-disclosed intentions or internal averages.
- 4 Forecast and report removal What it is: The record must be removed from all living-pipeline forecasts, stage counts, active opportunity lists and board pipeline totals. How to use it: Record the removal date and the reports affected. What it looks like: “Forecast/reporting treatment: remove from living-pipeline reports from Q1 FY2028 onward. Do not include in Stage 5 count. Do not include in active disclosed-intender list. Realised income appears only in finance and Course 3 estate reporting.” What it prevents: It stops double counting. The gift cannot be both an active living-pipeline record and realised estate income.
- 5 Stewardship and contact suppression What it is: The donor must be suppressed from living-donor stewardship, solicitation, recognition invitations and ordinary supporter journeys unless a separate Course 3 or memorial-stewardship process explicitly governs next steps. How to use it: Set the deceased flag, suppress automated donor communications, close open living-donor tasks, and check linked household records carefully. What it looks like: “Donor status: deceased. Suppress from appeals, newsletters, gifts-in-wills updates, event invitations, birthday messages, tax appeal journeys, phone lists, volunteer call sheets and legacy recognition invitations. Close all living-donor tasks. Linked household contact: none with donor-permitted stewardship role recorded.” What it prevents: It stops painful administrative failures: mail sent to a deceased donor, phone calls made from old call lists, or recognition invitations triggered by the realised gift.
- 6 History preservation What it is: Closeout should preserve the living relationship history without rewriting it through the realised amount. How to use it: Keep the original disclosure, motivations, permissions, stage movements and cadence history. Add the realised closeout as a final chapter. Do not overwrite the old record with “major bequest donor” if the living record showed no such relationship. What it looks like: “Living-pipeline history retained: original Stage 1 solicitor information request, 8 February 2021; no living donor contact permission; no recognition permission; no disclosed amount during lifetime. Do not replace historical notes with realised gift value.” What it prevents: It stops the organisation from learning the wrong lesson. A large realised gift does not prove the donor was a major-donor prospect during life.
- 7 Data-quality closeout check What it is: The final closeout should check that the CRM no longer contains active contradictions. How to use it: Before marking complete, check stage, forecast status, deceased status, task queue, communications suppressions, linked records, reporting lists, recognition lists and duplicate records. What it looks like: “Closeout QA completed 15 August 2027. Stage 6 applied. Forecast value removed. Active tasks closed. Deceased suppression applied. Duplicate solicitor-created constituent merged into estate case reference. Recognition lists checked: donor not listed. Board pipeline report updated.” What it prevents: It catches the errors that happen after the legal work is finished: duplicate records, old tasks, campaign lists, stale forecast values and accidental recognition.
The transformational gift that should not rewrite the pipeline
A regional education access charity receives a Course 3 handover after a complex estate matter has been completed. The charity supports scholarships, tutoring and transport subsidies for students in remote communities.
The donor is not a long-loyal supporter.
Harriet Okafor was not on the charity’s active donor file. Five years earlier, her solicitor contacted the organisation before death to verify the full legal name and ABN for will drafting. The CRM record created at the time said:
“Solicitor enquiry, 8 February 2021. Solicitor states client has consented to request correct legal name and ABN. No donor contact details beyond name. No permission for direct donor contact. No amount, gift type or intention details disclosed. Send approved organisational details only. Exclude from forecast.”
The record was correctly held in Stage 1 — Information enquiry, then later closed as inactive because no further living-pipeline evidence arrived.
In 2027, Course 3 completes the estate-administration workflow and sends the CRM team this internal handover:
“Estate case C3-2027-041 completed. Donor: Harriet Okafor. Final distribution received: $1,840,000. Finance reference: FIN-BEQ-2027-118. Living-pipeline closeout approved. Do not run estate-administration checks from CRM; Course 3 file is the source of truth.”
The first CRM update says:
“Transformational bequest donor. Upgrade to top legacy segment. Add to major donor history. Include $1.84m in bequest pipeline total. Create task to find family for stewardship.”
That update is wrong in several ways.
It treats a realised gift as a living-pipeline opportunity. It uses the realised amount to rewrite the donor’s lifetime relationship. It creates a family-contact task without permission. It risks double counting by leaving the gift in the pipeline after finance has already received the realised-income handover. It also tries to start estate-related follow-up from the CRM, which belongs to Course 3 or to a separate approved memorial-stewardship process.
A correct closeout entry would read:
“Stage 6 — Realised / closed to living pipeline. Course 3 workflow reference: Estate case C3-2027-041. Course 3 handover received 14 August 2027. Donor: Harriet Okafor. Finance reference: FIN-BEQ-2027-118. Realised outcome supplied by Course 3/Finance handover: $1,840,000 final distribution received. Prior living-pipeline history: solicitor enquiry on 8 February 2021 requesting correct legal name and ABN with client consent; no donor contact permission; no disclosed amount, gift type or lifetime intention details recorded; record previously closed as inactive due to no further living-pipeline evidence. Closeout action: keep realised outcome in controlled realised-gift field; do not rewrite living history as major-donor relationship. Forecast/reporting treatment: remove from all living-pipeline counts, forecasts, active disclosed-intender lists and opportunity reports from Q1 FY2028 onward. Realised income to appear only in finance reporting and Course 3 estate reporting. Contact/suppression: donor status deceased; suppress from appeals, newsletters, gifts-in-wills updates, event invitations, recognition invitations, call lists and automated supporter journeys. Family/adviser contact: no permission in living-pipeline record to contact family, executor, solicitor or adviser; any estate-related or memorial contact must be governed by Course 3 or an approved post-estate stewardship process, not by this pipeline record. Data-quality checks: close active tasks, remove any forecast value, check duplicate solicitor-created constituent record, confirm donor not on recognition or board pipeline lists. Owner: CRM Manager. Backup owner: Gifts-in-Wills Lead. Closeout QA due: 21 August 2027.”
That entry lets the organisation learn from the gift without corrupting the pipeline.
Harriet’s realised gift is transformational. The living-pipeline record was not. Both facts can be true.
The correct administrative move is not to make the pipeline look better in hindsight. It is to close the record cleanly, preserve the evidence trail, remove the gift from active pipeline reporting, and leave Course 3’s estate file as the source of truth for the estate process.
Create a realised-closeout checklist
Before the next estate handover, build a realised-closeout checklist that the CRM owner must complete after Course 3 has run its process.
Use these fields.
1. Course 3 reference:
Estate case ID:
Course 3 owner:
Handover date:
Closeout instruction received:
2. Pipeline closure:
Previous living-pipeline stage:
New stage:
Closure date:
Reason for closure:
3. Realised outcome:
Amount or outcome supplied by Course 3/Finance:
Finance reference:
Date received or recognised:
Controlled field updated:
4. Forecast and reporting:
Removed from living-pipeline report:
Removed from disclosed-intender list:
Removed from forecast/model:
Board dashboard updated:
Double-counting risk checked:
5. Contact suppression:
Deceased flag applied:
Appeals suppressed:
Newsletters suppressed:
Legacy updates suppressed:
Events suppressed:
Phone lists suppressed:
Automated journeys suppressed:
6. History preservation:
Original donor signal retained:
Permissions retained:
Motivation retained if known:
No lifetime relationship inflated from realised amount:
No family/adviser contact created without authority:
7. Data-quality QA:
Open tasks closed:
Duplicate records checked:
Recognition lists checked:
Linked household records reviewed:
Owner assigned:
Backup owner assigned:
QA completion date:
Do not treat this as clerical aftercare. The closeout checklist is what stops the organisation from double counting, contacting the deceased, overwriting evidence, or teaching leadership the wrong lesson about the pipeline.
A realised bequest should leave the living pipeline cleanly: Stage 6 applied, forecast removed, stewardship suppressed, history preserved, and Course 3 retained as the source of truth for estate administration.
What closeout protects
Realised closeout protects the integrity of the pipeline after the money has arrived or the estate process has produced its final internal handover.
The record should not remain in Stage 4 or Stage 5. It should not stay in forecasts. It should not appear in living-donor stewardship lists. It should not be rewritten as though the charity had known more during the donor’s lifetime than it actually knew.
The seven controls are the Course 3 workflow reference, final stage closure, realised outcome field, forecast and report removal, stewardship and contact suppression, history preservation, and data-quality closeout check.
The closeout principle is simple: the estate process belongs to Course 3; the realised income belongs to finance reporting; the living pipeline must be closed, cleaned and protected from hindsight.