Lesson 21 · The Grant Architect

21. Pipeline Management

30 min

By the end you'll be able to

  • Build a twelve-month grant pipeline in a spreadsheet or CRM.
  • Track prospects through stages (researched, qualified, drafting, submitted, awarded, declined).
  • Forecast probability-adjusted revenue and balance new submissions against renewal reports.
  • Run a thirty-minute monthly pipeline review with named owners and dated next actions.

A grant pipeline is a twelve-month rolling calendar of prospects, deadlines, submissions, and reports. Organizations that run one maintain steady funding. Organizations that do not experience boom-bust cycles where a single lost award triggers a crisis.

In this lesson you will learn to build a pipeline in a spreadsheet or a CRM with four core columns: prospect name, stage (researched, qualified, drafting, submitted, awarded, declined), next action with owner and date, and amount weighted by probability. You will learn to balance new submissions against renewal reports (post-award work eats more time than new development if you let it), to forecast cash on a probability-adjusted basis (a 30,000 of expected revenue, not $100,000), and to review the pipeline monthly with whoever owns development decisions.

By the end you should be able to stand up a working pipeline in an afternoon and run a monthly review meeting in under thirty minutes. The mistake to avoid is treating the pipeline as a list of wishes. A real pipeline only contains prospects that passed your eligibility checklist, with named owners and dated next actions. Everything else is noise, and noise is what turns pipelines into graveyards.

Common mistakes

These are the traps learners hit most often on this topic. Knowing them in advance is half the fix.

  • Treating the pipeline as a wish list.

    A pipeline that includes prospects you have not qualified inflates the forecast and hides the real workload. Only qualified prospects belong on the active pipeline.

  • Ignoring renewal reports until they are late.

    Post-award reports are non-negotiable and eat capacity from the same team that develops new proposals. If they are not on the pipeline, they will collide with submission deadlines.

Practice problems

Try each on paper first. Click Show solution only after you've made a real attempt.

  1. Problem 1
    Sketch the column structure for a basic grant pipeline spreadsheet.
    Show solution

    Columns prospect_name, funder_type, program_area, eligibility_passed (Y/N), stage (Researched/Qualified/Drafting/Submitted/Awarded/Declined), deadline, ask_amount, probability_percent, weighted_amount (ask multiplied by probability), owner, next_action, next_action_due_date, is_renewal_report (Y/N), notes. Filtering on stage gives you a working view; summing weighted_amount across all rows gives you a probability-adjusted forecast; filtering is_renewal_report = Y shows the post-award load competing for the same team capacity.

Practice quiz

  1. Question 1
    How does the lesson recommend you forecast pipeline revenue?
  2. Question 2
    Which of the following is NOT a pipeline stage in the lesson?
  3. Reflection 3
    Why does the lesson warn that pipelines without named owners and dated next actions become "graveyards"?

Lesson 21 recap

A pipeline is a twelve-month rolling calendar with named owners, dated actions, and probability-weighted forecasts. Run monthly, it turns prospect research into sustainable funding instead of a series of one-off scrambles.

Coming next: Lesson 22 — AI Spotlight

Next, we close Week 2 with an AI Spotlight on how to use AI tools to compress prospect research from hours into minutes without sacrificing accuracy.

Saved in your browser only — no account, no server.