Fundraising Plan Template

Prefer this source on Google

Goals tab of the fundraising plan template with five revenue sources, 2026 actuals, a 480,000 dollar 2027 goal, cost to raise, net revenue and a gap check against the calendar
Click to download · Goals tab

Get the fundraising plan template

An Excel workbook with a plan summary, revenue goals by source, a gift range chart, a 12-month fundraising calendar that checks itself against the goals, and a KPI tab with donor retention built in.

Download XLSX

XLSX · 6 tabs · free, no email

A fundraising plan is the document that turns a nonprofit's mission into a revenue number, splits that number across sources, and puts every ask on a date with an owner's name next to it. A fundraising strategy decides which sources of funding to grow and why. The fundraising plan is where that strategy becomes rows, months and dollar amounts that board members can check at board meetings.

This fundraising plan template is a free fundraising workbook in Excel, built around that idea. You set fundraising goals by source, size the major gifts you need with a gift range chart, schedule every campaign on a fundraising calendar, and track five key performance indicators.

The page covers the download, the six tabs, a seven-step process to create a fundraising plan, a full worked example, retention, digital fundraising, KPIs, common mistakes and the software question.

It's written for executive directors and development directors at small teams of one to ten people, board members who sign off on the annual budget, and volunteers who run fundraising events and need to know where their event sits in the year. Larger nonprofits with a donor CRM can still use it as the one-page view the board sees.

The stakes for nonprofits are concrete. Giving USA's 2026 report put total US giving at $617.2 billion for 2025, and the Fundraising Effectiveness Project found that only 42.9% of donors gave again the year after their gift in 2024. Successful fundraising depends on knowing early. A plan written down in January is how a nonprofit knows by June that it's behind, while there's still half a year and enough resources to recover.

Download the free fundraising plan template

Download the template (XLSX)Six tabs: instructions, a plan summary, revenue goals by source, a gift range chart, a 16-row fundraising calendar and a KPI tracker, pre-filled with the Harbor Literacy Project 2027 example.

Goals tab of the fundraising plan template with five revenue sources, 2026 actuals, a 480,000 dollar 2027 goal, cost to raise, net revenue and a gap check against the calendar
Click to download the template

The workbook opens in Excel, Google Sheets and LibreOffice Calc. It runs on SUM, SUMIF and plain division, so nothing breaks on import, and conditional formatting turns any gap between a goal and the calendar red. Delete the example values to create your own plan, and the formulas stay in place for your numbers.

What a fundraising plan is, and how it differs from a fundraising strategy

The two words get used as synonyms, and the confusion costs nonprofits a year of drift. A fundraising strategy is the big picture: which revenue sources the nonprofit will rely on, which donors it wants more of, and how fundraising supports its strategic priorities over three to five years. It answers "where should our money come from?" An effective fundraising strategy names three or four sources and the donor groups behind each.

A fundraising plan is the annual operating version. It answers "how much, from whom, by when, and who asks?" One strategy can produce five annual plans. A strategy with no annual plan underneath stays a slide deck. A plan written without a strategy usually repeats last year's calendar with a bigger number at the bottom.

QuestionFundraising strategyFundraising plan
Time horizonThree to five yearsOne fiscal year
Main outputTarget revenue mix and prioritiesDollar goals, dates, owners
Who signs offBoard, onceBoard, then reviewed monthly
Changes whenThe mission or market shiftsA campaign misses its number
Tab in this filePlan summaryGoals, Gift range, Calendar, KPIs

The template holds both. The Plan summary tab carries the strategy in six short fields, and the other four working tabs carry the plan. If you want a longer three-year strategy document first, the strategic plan template is the better starting point, and this file picks up where it ends.

What's inside the annual fundraising plan template

Six tabs, in the order you fill them in, cover the key components of a fundraising plan. Every number on the Goals and KPIs tabs is either an input you type or a formula that reads another tab, so there's one place to change each figure.

TabWhat you enterWhat it calculates
InstructionsNothingA brief overview of each tab and the order to fill them in
Plan summaryMission, case for support, strategic priorities, plan owner, top risksNone. This is the narrative the board reads first
GoalsLast year's actuals, this year's goal and cost to raise per sourceNet revenue, share of goal, change vs last year, scheduled total, gap
Gift rangeGift sizes and gifts needed per levelSubtotals, cumulative total, prospects needed at three per gift
CalendarMonth, activity, channel, donor segment, owner, source, revenue targetFeeds the scheduled total on the Goals tab
KPIsDonor counts, gift counts, retained donorsCost per dollar raised, donor retention rate, average gift size

The link between the Calendar and the Goals tab is the critical aspect of the design. Each calendar row names a revenue source, and the Goals tab sums every row for that source with SUMIF. If your fundraising goals say $190,000 from individual giving and the calendar only schedules $160,000, the gap column shows $30,000 in red before anyone presents the plan to the board.

Structure of the fundraising plan template: plan summary feeds revenue goals by source, goals feed the gift range chart and the fundraising calendar, and the calendar and KPI tab report back to the goals

How to create a fundraising plan in seven steps

Order matters in the planning stage. Nonprofits that start with the calendar end up with a list of events and no idea if the events add up to the budget gap. Start from the funding the mission needs and work outward to the fundraising activities that will raise it.

  1. Write the case for support. Two or three sentences on what the money pays for and what changes if you raise it. This goes in the Plan summary tab.
  2. Pull past results. Last year's revenue by source, cost to raise, donor count, retained donors and gift count. The KPIs tab needs all five.
  3. Set the funding goal. The gap between the operating budget and earned revenue, checked against last year's growth and the resources your team has.
  4. Split the goal by source. Individual giving, major gifts, events, grants, corporate sponsors and payroll giving each get their own row on the Goals tab.
  5. Size the major gifts. Build the gift range chart for the major gifts line and count the prospective donors you'd need.
  6. Schedule every ask. Put each campaign on the Calendar tab with a month, a segment, an owner and a revenue target, until the gap column reads zero.
  7. Agree the review rhythm. Monthly regular check-ins with staff, a quarterly report at board meetings, and one mid-year rewrite if a line is off by more than 15%.

Together the steps make up the whole fundraising process. Steps 1 to 3 take an afternoon if your donor data is clean. Step 6 takes a week, because the devil's in the details. It's usually the step where people discover the year-end appeal has been quietly carrying half the plan.

Download the template (XLSX)

Setting fundraising goals that hold up

Good fundraising goals are SMART goals, a format George T. Doran introduced in the November 1981 issue of Management Review. His letters stood for specific, measurable, assignable, realistic and time-related. "Grow individual giving" fails three of the five. "Raise $190,000 from individual giving by 31 December 2027, owned by the development director" passes all of them.

Realistic goals start from past results. Look at three years of actuals per source, because a single bequest or an emergency appeal can make one year look twice as good as the trend. A line that grew 6% a year for three years and is now planned at +38% is a red flag until the Plan summary names the reason, like a new employer partnership.

Then check the mix of funding sources. A strategy that leans on one funder or one gala puts all your eggs in one basket. Giving USA's figures show individuals gave 64% of US charitable dollars in 2025 (Candid's summary of the report), with foundations at 19%. For nonprofits, diversifying across sources means a lost grant costs you one row on the Goals tab and leaves the other four standing.

Time-bound goals per source. Give each source its own deadline. Grants have award dates, galas have event dates, and the year-end appeal closes on 31 December. Separate dates let you see in May that the gala missed, while the year-end appeal can still make it up.

Break the annual number into benchmarks. A $480,000 goal with nothing scheduled until December looks fine at every board meeting until the year comes down to the wire. The Calendar tab forces each source into monthly pieces, so the board sees a cumulative target it can compare with actual money in the bank each quarter.

Bar chart of the Harbor Literacy Project revenue mix, 2026 actuals against 2027 goals: individual giving 172,000 to 190,000, major and mid-level gifts 98,000 to 120,000, events 66,000 to 70,000, grants 55,000 to 60,000, corporate and workplace 29,000 to 40,000

The gift range chart: sizing major gifts before you ask

A gift range chart works backward from a goal to the number of gifts you need at each size. Kim Klein, writing in the Grassroots Fundraising Journal, gives the standard shape: one gift equal to 10% of the goal, the next two gifts together worth another 10%, and the next three to five gifts worth a further 10%. The top handful of donors carries 30% of the line.

Most plans meet reality in the prospect column. Klein's follow-up on starting a major gifts program recommends looking for about three times as many prospects as gifts needed, because some will say no and some will give less than asked. The template multiplies gifts by three automatically. If the prospect total is bigger than your list of people with the linkage, ability and interest to give, the goal is too high.

Major gifts depend on personal relationships and one-on-one asks to major donors, so the gift range chart is also a workload chart. Seventy-one gifts and 213 prospects means 213 conversations. For an executive director who also runs programs, the count of conversations sets the ceiling on the goal.

Gift range chart pyramid for a 120,000 dollar major gifts goal: one gift of 12,000, two of 6,000, four of 3,000, eight of 2,500, sixteen of 1,500 and forty of 1,000, needing 213 prospects at three per gift

The same table drives capital campaign planning, with steeper tiers. For a capital campaign, which raises one-off money for a building or endowment, the top gift often lands at 10% to 20% of the goal, and the chart usually runs to fewer, larger gifts. The template's Gift range tab works for both. Change the gift sizes and the counts, and the cumulative column tells you when you've reached the goal.

Building the fundraising calendar

The fundraising calendar keeps the team on the same page about what happens when, and it stops three asks from landing on the same donors in the same month. Mapping campaigns across 12 months is how you avoid donor fatigue on one side and a staff bottleneck on the other, since the same development director usually writes the appeal, runs the gala and files the grant report.

Mark key dates first, then fill the fundraising activities around them. Fixed dates in a typical US nonprofit year include grant deadlines, the gala, the fiscal year-end and GivingTuesday, which falls on 30 November 2027 (also written Giving Tuesday).

US donors gave $4.0 billion on GivingTuesday 2025, according to GivingTuesday's own data commons, so it belongs on any calendar with an online fundraising line. Harbor's plan uses the day for a matching-gift campaign to boost donations from its existing file.

Each Calendar row has seven columns, and every one earns its place in coordinating fundraising efforts:

  • Month, when the money is expected to arrive in the bank.
  • Activity, the specific fundraising initiative or fundraising campaign, such as "Spring email appeal".
  • Channel, from email campaigns and direct mail to events, grants and in-person asks.
  • Segment, the donor group the ask goes to, such as monthly donors, lapsed donors or major donors.
  • Owner, one named role per row, such as grants manager.
  • Source, which row on the Goals tab this activity counts toward.
  • Revenue target, the dollars expected from this row.

Review the calendar at every monthly check-in and move rows that slip. When a grant decision moves from March to May, move the row too. Left in March, it makes the first-quarter numbers look worse than they are and pushes the board into the wrong conversation.

Fundraising calendar for 2027 showing monthly revenue targets: 66,000 in January, 43,000 in March, 75,000 in April, 25,000 in June, 32,000 in July, 8,000 in August, 15,000 in September, 27,000 in October, 24,000 in November and 165,000 in December

Worked example: Harbor Literacy Project, 2027 annual fundraising plan

Here's the template filled in for one nonprofit. Harbor Literacy Project is a community literacy nonprofit with six staff, a $1.2 million operating budget and 1,240 donors in 2026. Program contracts cover most of the budget, and the board needs $480,000 from fundraising in 2027, up from $420,000 raised in 2026. This is the example pre-filled in the download, so every number below matches the file.

To get the ball rolling, the development director opens the Goals tab. Five sources, each with a 2026 actual, a 2027 goal and the cost to raise it:

Source2026 actual2027 goalCost to raiseNetShare of goalChange
Individual giving$172,000$190,000$21,000$169,00039.6%+10.5%
Major and mid-level gifts$98,000$120,000$4,000$116,00025.0%+22.4%
Events$66,000$70,000$20,000$50,00014.6%+6.1%
Grants$55,000$60,000$3,000$57,00012.5%+9.1%
Corporate and workplace$29,000$40,000$2,000$38,0008.3%+37.9%
Total$420,000$480,000$50,000$430,000100%+14.3%

The total rises 14.3%, and cost to raise is $50,000, so the plan spends 10.4 cents per dollar raised. Events cost the most per dollar, $20,000 to raise $70,000, which is why the plan holds events flat and puts the growth into major gifts and the corporate line.

That corporate line is the weakest number in the plan. It jumps 37.9% on the back of a payroll giving pitch to three local employers and two new corporate sponsors for the gala. The Plan summary lists it as the top risk, and the board agrees to cut the target to $32,000 at the September review if the August pitch hasn't produced a signed employer by then.

Next comes the gift range chart for the $120,000 major and mid-level gifts line, using Klein's shape and three prospects per gift:

Gift amountGifts neededProspects neededSubtotalCumulative
$12,00013$12,000$12,000
$6,00026$12,000$24,000
$3,000412$12,000$36,000
$2,500824$20,000$56,000
$1,5001648$24,000$80,000
$1,00040120$40,000$120,000
Total71213$120,000

Harbor has 140 donors who gave $500 or more in the last two years. That's short of 213, so the executive director and two board members commit to adding 75 prospective donors from the gala guest list and local business owners by March. Without that commitment, the plan would have dropped the line to about $80,000.

Finally the Calendar tab. Sixteen rows schedule all $480,000, and the gap column on the Goals tab reads zero for every source:

MonthActivityChannelOwnerSourceTarget
JanMonthly giving program, full yearOnlineDevelopment directorIndividual giving$36,000
JanRenewal visits with 2026 top donorsIn personExecutive directorMajor and mid-level$30,000
MarSpring email appealEmailDevelopment directorIndividual giving$18,000
MarCommunity foundation literacy grantGrantGrants managerGrants$25,000
AprSpring gala, 24 AprilEventBoard events committeeEvents$55,000
AprGala table and program sponsorsIn personExecutive directorCorporate and workplace$20,000
JunMid-year asks after impact reportIn personExecutive directorMajor and mid-level$25,000
JulSummer appeal with program resultsEmail, mailDevelopment directorIndividual giving$12,000
JulFamily foundation program grantGrantGrants managerGrants$20,000
AugPayroll giving pitch, three employersWorkplaceBoard chairCorporate and workplace$8,000
SepRead-a-thon peer to peer campaignOnlineVolunteer coordinatorEvents$15,000
OctState humanities council grantGrantGrants managerGrants$15,000
OctCorporate sponsor renewalsIn personExecutive directorCorporate and workplace$12,000
NovGivingTuesday match, 30 NovemberEmail, socialDevelopment directorIndividual giving$24,000
DecYear-end appealMail, emailDevelopment directorIndividual giving$100,000
DecYear-end major gift asksIn personExecutive directorMajor and mid-level$65,000

December carries $165,000, or 34% of the year. The year-end appeal and the December major gift asks create that concentration, and it's the plan's second risk. The board sets an October checkpoint: if the year to date is more than $40,000 behind the calendar, the development director adds a second year-end email and a board phone bank before Thanksgiving.

Download the template (XLSX)

Donor retention: the cheapest way to boost donations

Most fundraising plans count dollars and forget to count people. That's a costly blind spot, because a donor base that loses half its donors every year has to replace them before it can grow. The Fundraising Effectiveness Project put the sector's 2024 donor retention rate at 42.9%, its fifth straight year of decline.

Repeat giving is the lever, and studying donor behavior across first, second and third gifts shows why. FEP data reported by NonProfit PRO showed retention of 18.6% for donors who had given once, 38.1% for those who'd given twice and 61.2% for those who'd given three to six times. One-time donations are the leakiest part of the file, so the plan should schedule a second ask to every new donor within their first year and nip the drop-off in the bud.

Harbor retained 520 of its 1,180 donors from 2025, a 44.1% donor retention rate, slightly above the FEP figure. The 2027 target is 48%, which means keeping 595 of the 1,240 donors from 2026. The KPIs tab computes both numbers from donor counts, so the rate updates when someone enters the actuals.

Thank donors within 48 hours. Penelope Burk's research for Donor-Centered Fundraising found that donors who got a thank-you call from a board member within 48 hours gave 39% more the next time they were asked, according to Claire Axelrad's summary of the study. A board thank-you call list belongs on the Calendar tab as an activity with an owner.

Stewardship planning also means segmenting, which keeps your fundraising strategy and your donor communications consistent. First-time donors get a welcome sequence and a second-gift ask, monthly donors get impact updates without asks, and major donors often want a detailed impact report before they renew. Each of those is a row type on the calendar, so donor relationships get scheduled time on someone's calendar.

Digital fundraising, email campaigns and fundraising events

Online fundraising keeps growing from a small base. The Blackbaud Institute reported that online sources rose from almost 8% of giving in 2022 to over 12% for the average organization in 2023, and to nearly 17% for organizations under $1 million in revenue. A plan that puts 40% of its goal online is betting against the averages.

Digital fundraising in the template is split by channel so each can be judged on its own numbers:

  • Email campaigns reach the whole donor file for the cost of the platform, which makes them the cheapest second ask after a gift.
  • Monthly giving turns a $25 donor into $300 a year, and recurring gifts don't need a new ask every month.
  • Peer-to-peer campaigns, like Harbor's read-a-thon, let volunteers and families ask their own networks, which reaches new donors the nonprofit has never contacted.
  • Social media works best for GivingTuesday and event promotion, with a donation link that lets supporters accept donations straight from the post.
  • Direct mail stays on Harbor's calendar for the year-end appeal because its 2026 mail donors gave larger gifts than its email-only donors.

Fundraising events are the most expensive line per dollar and the best for visibility. Of all the fundraising efforts in the plan, they need the most volunteers and staff hours.

Track gross and cost separately on the Goals tab, plan event invitations at least six weeks out, and give every event a revenue target that covers its cost before anyone talks about awareness. If the gala's net drops below what a second appeal would raise, it's time to go back to the drawing board on the event.

Key performance indicators to measure success

Five KPIs are enough for small nonprofits, and they show where fundraising efforts pay off. Each one on the KPIs tab has a 2026 actual, a 2027 target and the formula that produces it, so the numbers can't drift from the data underneath:

KPIFormula2026 actual2027 target
Total raisedSum of all sources$420,000$480,000
Cost per dollar raisedCost to raise ÷ total raised$0.110$0.104
Donor retention rateRetained donors ÷ last year's donors44.1%48.0%
New donorsDonors minus retained donors720705
Average gift sizeIndividual giving ÷ number of gifts$83.90$88.37

Track donation volume and donor count together, since donations and donors can move in opposite directions. Total raised can rise while donors fall, the pattern FEP has reported for several years, and a nonprofit in that position depends on fewer people every year. Keep an eye on both lines at once. The average gift amount explains which of the two is moving.

Conversion rate is worth adding if you run online campaigns at scale: donations divided by visits to the donation page. The template leaves it as an optional row for small teams without clean page data. Review all five at every board meeting and adjust the calendar after each one.

Common fundraising plan mistakes

Most plans that fail were missing a column. These five gaps show up most often:

  1. Goals with no calendar behind them. The goal says $480,000, the scheduled campaigns add up to $410,000, and nobody notices until November. The gap column exists to catch this.
  2. One source carrying the year. If one gala or one foundation grant is over a third of the goal, write down what happens to the funding plan if it falls through.
  3. No owner per activity. Give every row one role, and have that person report on it at the monthly check-in.
  4. Counting gross event revenue as success. A $55,000 gala that costs $18,000 nets $37,000. Plan and report net, because successful fundraising is measured in money the mission can spend.
  5. Ignoring the team's size. A plan with 213 major-gift prospects and one part-time fundraiser bites off more than the team can chew. Fit the number of asks to the hours people have.

A sixth mistake is writing the plan and then filing it. Make the plan the first attachment in every board pack, so the board compares the bank balance with a target each quarter.

Download the template (XLSX)

Fundraising tools: Excel, Google Sheets or donor software

The right tools depend on the size of the donor file. A spreadsheet handles the plan itself at any size, because the plan has a few dozen rows. Donor data is different, and the tools that hold it split into four groups:

  • Donor management software keeps gift history, contact records and retention reports. Once you pass a few hundred donors, pull the KPIs tab's inputs from the donor software.
  • Online fundraising platforms host donation forms, monthly giving and peer-to-peer pages, and let a small nonprofit accept donations by card and bank transfer.
  • Event management software handles registration and ticket sales, and exports a net revenue figure for the Goals tab.
  • Email marketing tools segment the donor file and track opens and gifts per campaign.

Keep the plan in Excel or Google Sheets even after you buy software.

For small teams the spreadsheet stays the essential tool for the board view, since board members can open a spreadsheet without a login, the formulas are visible, and the plan doesn't change when you switch vendors. The financial plan template uses the same approach for the full operating budget, and the cash flow statement template shows when the December-heavy fundraising year leaves the bank account thin in summer.

For goal tracking across the whole organization, fundraising targets can sit as key results in an OKR tracker. To segment donors properly before writing the calendar, the customer segmentation template works for donor groups with its column names changed.

FAQ

What should be included in a fundraising plan?

A fundraising plan should include the case for support, the mission it serves, fundraising goals by revenue source, the cost to raise each one, a gift range chart for major gifts, a month-by-month fundraising calendar with owners, and the KPIs you'll report to the board. The template above has a tab for each.

How do I write a fundraising strategy?

Start with what the mission needs funded over three to five years, review past results by source, decide which sources to grow or reduce, and name the donor segments you want more of. Then turn year one of that fundraising strategy into an annual fundraising plan with dollar goals and dates. Revisit the strategy every few years, and the plan every year.

What are the most effective fundraising strategies?

For most nonprofits, the most effective fundraising strategies keep existing donors giving: prompt thank-yous, a second ask to first-time donors, monthly giving and personal major gift asks. FEP data shows retention climbing from 18.6% after one gift to 61.2% after three to six, so the plan should schedule a second and third ask to every donor who gives once.

What are the 5 steps of the fundraising cycle?

The donor cycle used in fundraising training runs identification, qualification, cultivation, solicitation and stewardship. Stewardship then leads back into cultivation for the next gift, which is why retention belongs inside the annual plan.

What are the three C's of fundraising?

Versions differ by author, but the usual three are connection, capacity and concern: a prospect who knows someone at the nonprofit, can afford the gift and cares about the cause. Prospect researchers often use the same idea under the name linkage, ability and interest.

How often should a fundraising plan be reviewed?

Review the calendar and KPIs monthly with staff and quarterly with the board. Rewrite the plan once at mid-year if any source is more than 15% behind its benchmark, and build next year's plan in the fourth quarter from this year's actuals.

Bottom line

Use this fundraising plan template when you have an annual goal to hit and two or more sources to hit it with. Its value is the link between the Goals tab and the Calendar tab, which shows every dollar of the goal sitting on a month with an owner, and the gift range chart, which tells you before January if you have enough prospects for the major gifts line.

If you're still deciding which revenue sources the nonprofit should depend on over several years, write the strategy first in a strategic plan and run a SWOT analysis on your fundraising program. If the plan is already set and you need to assign tasks week by week, an action plan template fits that job better.

⬇Download template