Roundtable introduction capture
Sarah Okonkwo, Northstar's Major Gifts Officer, attends the Twin Cities Community Foundation's quarterly Education Funders Roundtable on Jan 14. Helen Park (TCCF Director of Programs) introduces her to Catherine Reyes, Senior Program Officer at the Wexford-Bell Foundation. Hallway conversation, 15 minutes. Catherine: "Send me an LOI — we're actively looking for college-readiness work this cycle." That same evening, Sarah opens Interface365 on her phone and creates the Lead by hand. Source attribution to the TCCF roundtable, conversation context captured verbatim, the next-action task fires automatically.
Source ("Education Funders Roundtable · TCCF") from the dropdown configured under Settings → Sources. The Twin Cities Community Foundation is captured separately as a Source Organization with Helen Park named as the convener — TCCF will earn relationship-credit + an invitation to next year's gala if any of these intros land, NOT cash compensation (this is a relationship-driven introduction, not a paid solicitor arrangement). Lead score 78/100 reflects: warm intro through a known convener (+25), explicit invitation to submit (+20), portfolio fit on college readiness (+18), Wexford-Bell's typical award scale matches Northstar's ask (+15). An auto-task fires on Sarah for "Submit LOI to Wexford-Bell within 14 days" — foundation expectation following an LOI invitation.Discovery call & lead enrichment
Sarah books a 30-minute discovery call with Catherine for Jan 21. Half listening, half taking notes — capture portfolio fit, decision dynamics, the trustee calendar, and the competitive landscape. The lead status flows New · Roundtable intro → Contacted → Active prospect — LOI drafting.
Lead conversion — one click, four entities
With the discovery call complete and the lead score climbing from 78 → 91, Sarah clicks Convert. Interface365 creates a Contact (Catherine Reyes) + Account (the Wexford-Bell Foundation) + Source Organization (Twin Cities Community Foundation) + Deal (the grant opportunity). The Wexford-Bell stakeholder map + Northstar internal team get layered on in Step 4.
Deal enrichment — funder + internal relationship map, custom fields, tags
A foundation grant is never one decision-maker. On the funder side: a technical program officer who drives the recommendation (Catherine), a board chair who signs the award (Eleanor), foundation counsel reviewing the MOU (Michael), an outside expert running site-visit due diligence (Dr. Ostrand). On Northstar's side: a deal-owner (Sarah), an ED who signs the cover letter (Rev. Marcus Daniels), a program lead who owns the technical pitch (Layla), a finance director who owns the budget (Tomas), and a board chair who must formally accept any grant above $100K (Patricia). Sarah maps them all with explicit roles so every email, document, and signature routes to the right person every time.
Expected first tranche: mid-April 2026 (~13 weeks post-intro)
LOI draft, supporting documents, and the notes that capture the strategic signal
Sarah, Layla, and Tomas spend two weeks drafting the LOI. The draft itself, the outcomes data spreadsheet, the audited financials, the 501(c)(3) determination letter, the most-recent Form 990, the theory-of-change one-pager, and the internal strategy notes all live on the deal record — nothing in side-channel emails, shared drives, or "I'll remember it" memory.
Source Organization · Convening Foundation for relationship-credit tracking — TCCF's roundtable is the warm-intro infrastructure for the entire local funding ecosystem; Northstar's relationship with TCCF is itself worth tracking (3 prior introductions YTD via TCCF roundtables, 1 already converted to a $90K grant from Driscoll Family Foundation last cycle). Quarterly stewardship-mention digest auto-includes TCCF.Tasks & follow-ups — never let a paperwork thread drop
Tasks attach to the deal with priority, due dates, and assignees. In foundation grant work the difference between "LOI submitted on Day 14" and "first tranche wired on Day 97" is a clean task list — board pre-authorization, outcomes-data refresh, audited financials package, site-visit prep, stewardship outreach to the convening foundation, all running in parallel across multiple departments.
Pipeline progression & stagnant-deal alerts
As the grant cycle advances, Sarah drags the deal through 8 stages: Lead → LOI Drafting → LOI Submitted → Full Proposal Invited → Proposal Submitted → Site Visit / Due Diligence → Award Pending (Trustee Decision) → Closed Won (First Tranche Wired). Foundation cycles are slow — Interface365 calibrates stagnant-alert windows to that reality: 21 days no activity post-LOI Submitted, 14 days post-Site Visit, 7 days post-Award Pending. The risk isn't that a faster competitor poaches the relationship; it's that a quiet desk produces no information to act on, the program officer's calendar fills up, and the cycle's award slot goes to a peer org. The Wexford-Bell deal is at "Proposal Submitted" — Catherine is reviewing (5 days in stage). Comfortably on track.
Proposal template library — 9 base templates, lifecycle-managed
Northstar's proposal template library — 9 base templates covering the most common funder + program-area combinations (Family Foundation Education Restricted, Family Foundation Capacity Unrestricted, Community Foundation Field-of-Interest, DOE 21st Century CCLC federal, Corporate Cause-Marketing Sponsorship, DAF Recommend Major Gift Letter, Federal Education Innovation RFP, MN Department of Education Continuation, International Strategic). Each template carries: typical narrative structure, budget format, outcomes-data templates, attachments checklist, funder-specific guidance. Lifecycle states: Active / Draft / Retired.
Full proposal submission — narrative, theory of change, 3-yr budget
Wexford-Bell's portal accepts a combined LOI-cover + Full-Proposal submission, so Sarah, Layla, and Tomas finalise the package as one document. Cover letter from Rev. Marcus Daniels (signed); 4-page LOI cover (org overview + program description + evidence base + scope summary); 14-page Full Proposal underneath (Executive Summary; Theory of Change; Logic Model; Outcomes Measurement Plan; Project Timeline 3-year scaling 6 → 9 → 12 → 14 schools; Detailed Budget by school, personnel, direct vs indirect, year; Sustainability Plan); and 7 attachments. Total ask: $1,200,000 over 3 years. Submitted to the Wexford-Bell portal on Day 14 (Jan 28) at 14:42 CT. Stage flips to Proposal Submitted. Catherine confirms acceptance Day 21 (Feb 4) and schedules a site visit.
| # | Budget line | Year | Schools | Cost type | Amount |
|---|---|---|---|---|---|
| 1 | Year-1 program delivery (9 schools) 9 site coordinators @ $45K + ~22% benefits ($54.9K loaded) · curriculum delivery · student-supplies + transit · 4-mo time-to-productivity ramp on 3 new hires | Y1 | 9 | Direct program | $314,000 |
| 2 | Year-2 program scaling (12 schools, +3 new site coordinators) Continuation of 9 + onboard 3 new site coordinators · curriculum + supplies for 3 new schools · steady-state delivery on Year-1 cohort | Y2 | 12 | Direct program | $326,000 |
| 3 | Year-3 program at full Phase-1 scale (14 schools, +2 new site coordinators) Continuation of 12 + onboard 2 new site coordinators · 14-school steady-state by month 32 · cohort persistence support through Year-3 cohort | Y3 | 14 | Direct program | $217,000 |
| 4 | Curriculum + outcomes-measurement system (3-yr) Curriculum refresh · Salesforce NPSP outcomes-tracking module · annual cohort dashboards · MN Statewide Longitudinal Data System data-sharing agreement | Y1–Y3 | all | Systems | $96,000 |
| 5 | Statewide impact-evaluation contract (Year 3) Independent evaluation by Wilder Research · quasi-experimental design vs comparison-school baseline · published Year-3 report for the field | Y3 | all | Evaluation | $48,000 |
| 6 | M&E coordinator role (0.4 FTE × 3 yrs) Dedicated monitoring + evaluation lead · 0.4 FTE @ $72K loaded · owns the outcomes data, reporting deliverables, month-12 quality-gate review | Y1–Y3 | all | Personnel | $43,000 |
| 7 | Indirect cost recovery @ 15% (federally-negotiated rate) Applied to direct program + systems + evaluation + M&E personnel · sub Wexford-Bell ceiling of 20% · supports finance/HR/IT/facilities pro-rata | Y1–Y3 | — | Indirect | $156,000 |
Site visit + scope-reduction squeeze — the 12-week fight that saves the grant
Full proposal submitted Day 14 at $1.2M. Site visit lands Day 35 (Feb 18) at Cedar-Riverside. Catherine + Dr. Ostrand spend 4 hours on site; Layla presents outcomes; Dr. Ostrand pushes hard on the scaling pace. Day 38 Catherine emails: cut the ask, slow the ramp, add a 6-month quality-gate. Day 56 Northstar learns through TCCF that Mosaic Youth Center has been declined — one slot left to win or lose. 30–40% of foundation grants stall after site visit when funders push for scope reductions. Northstar's structured response — take the rigour-uplift seriously, reframe the scaling pace as Phase-1 / Phase-2, hold the integrity of the program — saves the grant.
WB-RESTRICTED-COLLEGE-READINESS) for first-tranche tracking.First tranche wired — Closed Won 🏆
Day 97 · Apr 21 · 11:08 CT. Sarah sees the wire confirmation in Sage Intacct's bank-feed: "$250,000.00 received in account [WB-RESTRICTED-COLLEGE-READINESS] — US Bank Operating". Sarah ticks "First Tranche Received" — deal flips to Closed Won. Probability 100%. Revenue recognition begins from this minute. NOT the verbal yes from Catherine on Day 88. NOT the LOI approval. NOT the proposal submission. NOT the award letter signed Day 93. The wire confirmation is the only thing that starts the FASB ASC 958 conditional-contribution recognition clock + locks in Northstar's programmatic delivery commitments.
Webhooks fire — Slack, Sage Intacct, Salesforce NPSP mirror
The instant the deal flips to Won, Interface365 fires deal.won webhooks to every subscribed endpoint. Slack celebrates. Sage Intacct (Northstar's accounting system) creates the restricted-fund GL sub-account + the FASB ASC 958 conditional-contribution recognition schedule + the reporting calendar. Salesforce NPSP — the Nonprofit Success Pack used by ~30% of mid-sized US nonprofits as a compliance system-of-record — mirrors the full grant + funder + program map for audit-trail purposes. Interface365 stays the relationship + pipeline source of truth; Sage handles fund accounting; Salesforce NPSP is the auditor-facing record.
// POST https://hooks.sageintacct.com/restricted-grant // X-I365-Signature: sha256=... { "event": "deal.won", "timestamp": "2026-04-21T16:08:34Z", "data": { "deal_id": "d_wb26gr0184", "name": "Wexford-Bell — College-Readiness Expansion Grant", "funder_account": "SI-FUND-WB-26-0184", "grant_amount_total": 750000, "grant_amount_year1": 250000, "restriction_type": "restricted_program", "restricted_program": "college-readiness mentoring expansion", "restriction_period_months": 36, "indirect_cost_rate": 0.15, "reporting_cadence": "semi-annual interim, annual final", "first_tranche_at": "2026-04-21T16:08:34Z", "mou_signed_at": "2026-04-17", "board_resolution_at": "2026-04-17", "source_organization": "Twin Cities Community Foundation", "lead_sgo_id": "u_sarah_okonkwo", "program_lead_id": "u_layla_brennan", "fasb_treatment": "ASC 958 conditional contribution", "phase_2_unlock": "month 12 outcomes review" } }
$750K over 3 yrs. First $250K tranche just wired to US Bank restricted account. Deal owner: Sarah Okonkwo. Program lead: Layla Brennan. Source: Twin Cities Community Foundation roundtable (Helen Park's intro to Catherine Reyes at WBF). 97 days from intro to tranche.
Restricted-funds GL sub-account opened in Sage Intacct. Programmatic delivery commitments lock in: 10-school Phase 1 by month 12, outcomes review unlocks Phase 2 (4 schools, no new ask). Mosaic was declined this cycle — board went with Northstar.
Patricia signed the board resolution this morning. Site visit + scope-reduction squeeze survived intact. Coffee on Tuesday.
X-I365-Signature: sha256=... header so receivers can verify authenticity. Failed deliveries auto-retry with exponential backoff. The Settings → Webhooks → Delivery logs page shows every fire with status code, response, and retry count. Sage Intacct accepts the payload, opens the restricted GL sub-account + the FASB ASC 958 contingent-revenue schedule + the reporting calendar in one transaction. Salesforce NPSP receives the same payload to /services/data/v59.0/composite/tree/Account + creates a new npsp__Grant__c record with the full theory-of-change attachment for the audit trail.Active grant lifecycle + the peer-foundation referral cascade
Foundation grants don't end at "Closed Won" — that's where the stewardship really begins. The Active Grant Lifecycle pipeline lives in its own view (programmatic delivery · interim reporting · annual reporting · Phase-2 decision · closeout / renewal). Auto-tasks fire on reporting milestones, site coordinator hiring deadlines, and budget-tracking checkpoints. And 14 weeks post-award, the conversation that compounds everything that came before: at the next quarterly Education Funders Roundtable, Catherine recommends Northstar to two peer family foundations. Both close inside 90 days. $1.15M raised in 12 months from one warm introduction.
Late July 2026, week 14 post-award. Wexford-Bell hosts the next quarterly Education Funders Roundtable at Twin Cities Community Foundation. Catherine recommends Northstar to two peer family foundations she works with regularly: Vance Family Foundation ($80M endowment, education-focused) and Linden Trust ($24M endowment, capacity-building focus). Both invitations are warm — Catherine introduces Sarah at the roundtable and emails the program officers personally that week. Sarah captures both as new Leads on the deal record, both tagged "Wexford-Bell-referred" so the cascade is reportable.
Vance Family Foundation invites a parallel proposal for the same college-readiness program (technically additive funding to the Phase-1 10 schools — different funder, same program scope, separate restricted-fund GL sub-account). Sarah leverages the Wexford-Bell proposal template (Step 8 — PROP-FF-EDR-2026) and customises 4 sections — the deal closes in 48 days, much faster than Wexford-Bell because the outcomes evidence is already there + the proposal narrative is mostly transferable. Vance approves $300K total ($150K/yr × 2 yrs). Award letter signed Aug 28, first $150K wired Sep 5.
Linden Trust is structurally different — they fund unrestricted capacity-building grants, the highest-leverage gift type because the money can fund operations / staffing / systems / fundraising tech without programmatic restrictions. Sarah submits a tighter $100K capacity ask using the PROP-FF-CU-2026 template (Family Foundation Capacity Unrestricted). Linden approves; $100K wired Sep 25. Sarah marks the source organization on the deal: "Catherine Reyes / Wexford-Bell — peer-referred".
Total Wexford-Bell-influenced new funding: $750K direct + $300K Vance + $100K Linden = $1,150,000 in 12 months from one warm introduction at one quarterly roundtable. Cost-of-fundraising on the two follow-on grants combined: ~$22K (~5.5% blended CFR — well below industry benchmark, because the relationship + outcomes proof is already paid for). The Wexford-Bell program-officer relationship now compounds at every quarterly TCCF roundtable; Catherine has 3 more peer-foundation introductions queued for the Q4 cycle. The roundtable cost Northstar 90 minutes + 3 handshakes + a follow-up email — and produced more new institutional funding than Northstar's prior 18 months of cold outreach combined. Without the deal record + source-org credit + lifecycle-pipeline structure, Catherine's hallway introductions become "I'll follow up next week" emails that go cold; with it, every introduction has a dedicated workflow that closes inside 90 days. The Wexford-Bell grant was rescued from a site-visit scope reduction in Step 10 and compounded into $1.15M of new restricted + unrestricted funding inside 12 months.
Funder dashboard — Friday morning, week 47 (mid-November), Q4 board prep
It's a Friday morning in mid-November 2026 — week 47 of the calendar year, seven weeks after Linden Trust's $100K capacity grant landed (Sep 25) and two weeks before Northstar's quarterly board meeting. Northstar has 47 active institutional funders, $3.8M in restricted grants in active delivery, $1.6M in unrestricted operating support YTD, and 78% multi-year foundation retention. The Wexford-Bell grant + the Vance + Linden follow-ons land on the same dashboard as the rest of the institutional book.
What Northstar set up before any of this worked
Rewind to the prior summer's CRM rollout. Every screen you just walked through — the source dropdown on the new-lead form, the funder + Northstar role taxonomy, the 8-stage Foundation Grant Cycle pipeline, the 6-phase Active Grant Lifecycle pipeline, the proposal template library, the source-org tracking — was configured once by Northstar's Director of Finance (Tomas Reyes) over five weeks. Then it reused itself across 47 active institutional funders and 22 new grants YTD.
Entity relationship map
How every entity in this walkthrough connects
Ready to set this up for your non-profit?
14-day free trial · No credit card · Foundation-grant templates pre-loaded for 501(c)(3) charities, family foundations, community foundations, and federally-funded grantees.
Start free trial Read the reference guide →