Workbook preview: a complete fictional fundraising plan
Riverton Community Workshop is an invented community arts organization planning its 2027 workshops. It needs $26,000 in cash available for the program, after the direct costs of its fundraising events and paid sessions. Every amount below is an illustrative target; no grant, sponsor, gift, or other receipt is committed.
The download has a blank Plan sheet and a filled Example sheet. The preview below summarizes the same cash channels. The workbook lays January through December across columns and keeps each owner, next action, date, and assumption beside the figures.
Scroll the table sideways to see all columns.
| Cash channel | Owner | Annual target (USD) | Planning assumption |
|---|---|---|---|
| Grants | Maya | $12,000 | Planned receipts in March and September; no awards committed. |
| Sponsorships | Jordan | $4,000 | Three proposed receipts; no sponsor agreements confirmed. |
| Individual giving | Sam | $4,000 | $250 per month, plus $1,000 in December; all targets uncommitted. |
| Events (net proceeds) | Jordan | $3,000 | Two events: $2,500 receipts less $1,000 costs each; no receipts confirmed. |
| Earned income (net) | Luis | $3,000 | March–December: $500 receipts less $200 costs per month; uncommitted. |
| Other cash | Maya | $0 | No other cash source planned; zero is intentional. |
| Total planned cash | Maya reviews the overall plan | $26,000 | All targets uncommitted. Planned cash is not money available to spend. |
The 12-month plan: receipts, owners, and next actions
Each amount belongs to the month the team hopes to receive the cash. The action dates are internal planning dates, not real funder deadlines. Applications and sponsor conversations begin earlier; confirm actual decision and payment dates. The Example sheet includes this monthly action schedule below the cash and in-kind tables.
Scroll the table sideways to see all columns.
| Month (2027) | Planned cash (USD) | Owner | Next action and internal date |
|---|---|---|---|
| January | $250 | Maya | Verify grant eligibility and the full-year cash need before drafting. Internal review: 2027-01-15. |
| February | $2,250 | Jordan | Check the planned sponsor receipt; finalize March materials and event costs. Internal review: 2027-02-15. |
| March | $8,550 | Maya | Verify the grant decision and payment date before making spending commitments. Internal review: 2027-03-15. |
| April | $550 | Luis | Compare session income with costs and confirm May room arrangements. Internal review: 2027-04-15. |
| May | $2,050 | Jordan | Reconcile event receipts and costs; prepare the June sponsorship follow-up. Internal review: 2027-05-15. |
| June | $1,550 | Jordan | Confirm sponsor payment timing and record any shortfall for review. Internal review: 2027-06-15. |
| July | $550 | Maya | Review autumn grant rules and prepare the September request in time. Internal review: 2027-07-15. |
| August | $550 | Luis | Review participation, delivery costs, and remaining paid-session capacity. Internal review: 2027-08-15. |
| September | $4,550 | Maya | Check the autumn grant decision and expected receipt; revise the gap if needed. Internal review: 2027-09-15. |
| October | $1,550 | Jordan | Confirm sponsor timing and November event costs before committing funds. Internal review: 2027-10-15. |
| November | $2,050 | Sam | Reconcile event proceeds and prepare the December donor appeal. Internal review: 2027-11-15. |
| December | $1,550 | Maya | Compare receipts with targets, record open commitments, and plan next year. Internal review: 2027-12-15. |
Keep donated resources separate from cash
The fictional team also wants these resources. They add no dollars to the $26,000 cash target. If a donation replaces a planned purchase, revise the expense budget so the same need is not counted twice. If it falls through, fund the purchase or adjust the project scope.
Scroll the table sideways to see all columns.
| Resource | Quantity and needed-by date | Owner and next action |
|---|---|---|
| Sketchbooks | 40; 2027-03-01 | Jordan: Check size and paper, then ask a supplier. Planned; not confirmed. |
| Room sessions | 4; 2027-05-01 | Luis: Confirm access, dates, and host approval. Planned; not confirmed. |
Use the workbook for your own planning year
Download and open the XLSX workbook in Excel. Keep the Example sheet as a reference and enter your own figures in Plan. Name Month 1 through Month 12 for your planning year.
Enter your cash channels, owners, next actions, and action dates. Put each target in its expected receipt month, using your own donor history, program rules, and capacity.
Replace the illustrative assumptions. For events and earned income, use net amounts after direct costs. Review whether restricted receipts can fund the intended work.
Use a numeric zero when no cash is planned; leave unknown targets blank and explain them in Status and assumptions. Year and monthly totals calculate from numeric inputs.
Record goods and services in the separate in-kind section. For a monthly action schedule, adapt the schedule on Example and check that its dates match your planning year.
Review actual receipts and commitments separately each month. This workbook plans fundraising targets; it does not reconcile bank receipts or model expenditure timing.
If the proposed $8,000 March grant does not come through and no other target changes, planned cash falls from $26,000 to $18,000. That leaves an $8,000 gap against the program’s $26,000 cash need. Maya would check alternatives and revise scope or timing before the team commits to spending. Moving an unconfirmed receipt to another month does not close the gap.
Start with the work and the funding gap
Confirm the program scope and working budget before choosing revenue targets. List the resources already committed and the remaining gap. Keep restricted support attached to the purpose it can fund; a large organization-wide total can hide an unfunded activity or a timing problem.
Choose the 12-month period explicitly. The workbook provides Month 1 through Month 12 so it can follow your fiscal year or project season. Name those months when you begin. The fictional example demonstrates the structure rather than predicting what your organization can raise.
Choose channels you can actually pursue
Scroll the table sideways to see all columns.
| Channel | Evidence to gather | Planning decision |
|---|---|---|
| Grants | Current program rules, prior fit, invitation or eligibility status | Which applications deserve preparation time? |
| Sponsorships | Relevant business priorities and permitted partner benefits | What specific project support will you ask for? |
| Individual giving | Your own past giving and realistic stewardship capacity | Which existing relationships can you responsibly support? |
| Events or earned income | Delivery costs, staff capacity, and realistic net proceeds | Does the activity contribute enough after costs? |
| In-kind support | Specific quantity, suitability, timing, and delivery requirements | Which real need can this resource meet? |
Separate an ask from money available to spend
An application deadline, funding decision, and payment date can be different. Place a cash target in the month you plan to receive it, then record the related proposal or relationship work earlier in the schedule. Mark uncertainty in the notes instead of treating an application as a confirmed award.
Keep donated goods and services in their own resource plan. They can meet a specific need, but adding an estimated in-kind value to cash receipts can make available spending money look larger than it is. The workbook keeps those two views separate.
Assign the next action
The team needs materials for a spring workshop series. Jordan will confirm quantities and delivery dates, then prepare a request to a local supplier. A separate owner checks whether a project grant can cover teaching time. Neither source is counted as committed until the team has confirmation.
Review the plan each month
- Compare expected support with confirmed receipts and commitments.
- Revisit opportunities whose timing, requirements, or fit have changed.
- Check the staff time needed for applications, follow-up, and grant reporting.
- Keep the next action, owner, due date, and source evidence current.
- Escalate a funding gap early enough to change project scope or timing deliberately.