Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesNonprofit & CommunityFundraising & DonorsNonprofit Budget

SpreadsheetFundraising & DonorsFree

Nonprofit Budget

An annual operating budget with program, management and fundraising split, restricted funds, revenue mix and key ratios.

Shown with sample data

Colour

Nonprofit Budget

An annual operating budget with program, management and fundraising split, restricted funds, revenue mix and key ratios.

Total expenses
$963,500
Program expense ratio
72%
Share spent on programs
Admin ratio
14%
Fundraising ratio
14%
Total revenue
$972,000
Risk-adjusted revenue
$849,500
With donor restrictions
22%
Budgeted surplus
$8,500
Expenses by function
  • Program services$689,93072%
  • Fundraising$138,82014%
  • Management & general$134,75014%
Revenue mix by type
  • Individual giving$440,00045%
  • Earned income$178,00018%
  • Government grants$120,00012%
  • Events$95,00010%
  • Foundation grants$90,0009%
  • Corporate support$45,0005%
  • Other$4,0000%

How to use it

  1. 1List every expense line with its annual budget and how its cost splits between program and admin; the rest is treated as fundraising.
  2. 2Mark whether each expense is paid from restricted or unrestricted funds.
  3. 3List each revenue source with its type, donor restriction and how confident you are it will come in.
  4. 4Read the Summary sheet: check the surplus on risk-adjusted revenue, not just the headline number.
  5. 5Present the Functional split and Revenue mix charts to the board with the budget.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Build a budget the way funders, auditors and your Form 990 see it. Allocate each expense across program services, management and general, and fundraising; tag revenue by type, donor restriction and confidence. The sheets calculate the functional split and percentages, the revenue mix, a risk-adjusted surplus and the ratios boards ask about, such as program expense ratio and cost to raise a dollar.

Who it’s for

  • Annual budget approval by the board
  • Grant applications that ask for a program expense ratio
  • Checking a budget does not rely on one funder

What’s included

  • Expenses sheet: Every expense line and how it splits by function.
  • Revenue sheet: Every revenue source with its restriction and confidence.
  • Functional split sheet: Expenses by function, as reported on Form 990.
  • By revenue type sheet: Budget and the number of entries for each revenue type.
  • Summary sheet: The headline figures for the board.

How to use it

  1. 1List every expense line with its annual budget and how its cost splits between program and admin; the rest is treated as fundraising.
  2. 2Mark whether each expense is paid from restricted or unrestricted funds.
  3. 3List each revenue source with its type, donor restriction and how confident you are it will come in.
  4. 4Read the Summary sheet: check the surplus on risk-adjusted revenue, not just the headline number.
  5. 5Present the Functional split and Revenue mix charts to the board with the budget.

Tips

  • Allocate shared costs (rent, the executive director, software) with a reasonable basis such as time sheets or floor space, and use the same basis every year.
  • A budget that balances only if every “Possible” grant comes in is not balanced. Check the risk-adjusted surplus.
  • Do not starve overhead to hit a ratio. Funders increasingly accept 20–30% admin and fundraising for strong organisations.

Questions

What is a good program expense ratio?

Many watchdogs look for at least 65–75% of expenses going to program services. Very small or fast-growing organisations often run lower, and that is fine if you can explain it.

What are functional expenses?

Expenses grouped by purpose rather than type: program services, management and general (admin), and fundraising. US nonprofits report them this way on Form 990 and in audited statements.

What is the difference between restricted and unrestricted revenue?

Revenue with donor restrictions can only be used for the purpose or period the donor set, such as a grant for one program. Revenue without donor restrictions can be spent on any mission need, including overhead.

Should in-kind donations go in the budget?

If you include them, add the same value as both revenue and expense so they do not change your surplus. Many organisations show them separately for clarity.

Related searchesnonprofit budget templatenonprofit operating budgetfunctional expense allocationprogram expense rationonprofit budget excelrestricted vs unrestricted

Details

Format
Spreadsheet
Category
Fundraising & Donors
Sheets
5
Setup
30 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetFundraising & DonorsFree

Nonprofit Budget

An annual operating budget with program, management and fundraising split, restricted funds, revenue mix and key ratios.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Fundraising & Donors
Sheets
5
Setup
30 min
Level
Intermediate
Price
Free

Your copy is private to you.

More fundraising & donors templates

View all
Donor Database5 sheets

Raised this fiscal year

$15,325

Donor retention

67%

LYBUNT donors

2

ABCD
1DonorTypeLifetime givingGifts
2Margaret & Alan OkaforHousehold$2,5002
3Thomas WhitfieldIndividual$10,0002
4Harborview Community FoundationFoundation$22,5002
5Daniel ReyesIndividual$500.002
Donors
SpreadsheetFundraising & Donors

Donor Database

Track every donor and gift, with lifetime giving, LYBUNT and SYBUNT flags, giving levels and a suggested next ask.

20 min setupPreview

Organization Name Street Address · City, State ZIP · Phone · Website Tax ID (EIN): 00-0000000 · Organization Name is a tax-exempt organization under Section 501(c)(3) of the Internal Revenue Code.

Date

Re: Thank you for your gift of $500.00 received on November 12, 2026

Dear Ms. Okafor,

Thank you for your generous gift of $500.00 to Organization Name. Because of you, twelve children in our Reading Bridges after-school program will have a trained tutor beside them twice a week this winter, the kind

This is your fifth year standing with our students, and your loyalty means more than we can say. Gifts like yours are what keep our doors open on the afternoons when children need us most.

DocumentFundraising & Donors

Donation Acknowledgment Letter

A warm thank-you letter that doubles as a tax receipt, with a gift table and the goods-and-services statement donors need.

10 min setupPreview

Grant Proposal: Reading Bridges After-School Literacy Program

ApplicantRiverside Youth Alliance
Tax ID (EIN)00-0000000
ContactMaya Torres, Director of De

1. Executive Summary

Riverside Youth Alliance requests $45,000 to expand Reading Bridges, our after-school literacy program, from two to three elementary schools in East Riverside. In 2027, Reading Bridges will give 120 strugglin

2. Organization Background and Capacity

Founded in 2009, Riverside Youth Alliance serves 1,400 young people a year through mentoring, tutoring and summer learning. Our annual budget is $1.2 million and we employ 14 staff and 160 volunteers.

  • •Track record: Since 2021, 86% of Reading Bridges students have gained at lea
  • •Partnerships: We hold data-sharing agreements with Riverside Unified School Dis
  • •Leadership: Program Director Andre Wallace is a former reading specialist with
DocumentFundraising & Donors

Grant Proposal

A complete, funder-ready proposal: need statement, SMART objectives, methods, evaluation, budget table, narrative and sustainability.

45 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ