Free Nonprofit Budget Template (Excel)
What a Nonprofit Operating Budget Should Include
A nonprofit operating budget has two sides that a generic business budget doesn't need to separate the same way: revenue by source (grants, individual donations, corporate sponsorships, earned income, events) and expenses split by function - Program, Administrative, or Fundraising. Funders and board members typically want to see both.
That functional split matters because it's what feeds the overhead ratio, a number many grantmakers, auditors, and charity watchdogs look at directly when deciding whether an organization is spending efficiently on its mission versus on overhead.
Inside the Free Nonprofit Budget Template
The Revenue sheet is prefilled with 10 common sources - foundation grants, government grants, individual donations, corporate sponsorships, earned income and program fees, fundraising events, in-kind contributions, membership dues, investment income, and Other. Enter a budget and actual for each and the variance and percent-of-actual-revenue columns calculate on their own.
The Expenses sheet holds 30 rows, each tagged Program, Administrative, or Fundraising from a dropdown, with 12 categories prefilled to start (program staff, program supplies, direct client assistance, executive and admin salaries, accounting and legal, fundraising staff, event costs, and more). Budget and actual per category calculate a variance automatically.
Tracking Revenue by Source
For each revenue source, entering an actual amount automatically calculates that source's share of total actual revenue - useful for seeing at a glance whether the organization is overly dependent on one or two funding sources, which is a common risk flag for boards and funders alike.
The variance column shows how actual revenue compares to what was budgeted for each source, so a shortfall in one area (say, an unrenewed grant) is visible immediately rather than buried in a single total.
Program vs. Administrative Cost Split and Overhead Ratio
Because every expense row is tagged Program, Administrative, or Fundraising, the summary can total program spend on its own and calculate the overhead ratio - Administrative plus Fundraising costs, divided by total expenses - without any manual sorting.
Most funders and charity evaluators look for an overhead ratio somewhere under 25-35%, though the right number varies by organization size and mission. The summary also shows total revenue, total expenses, and the net result, so you can see the full operating picture on one sheet.
How to use it
- Budget revenue by source (grants, individual donations, corporate, earned income) on the Revenue sheet.
- Budget expenses by category and function (Program / Administrative / Fundraising) on the Expenses sheet.
- Let variance, revenue mix percent, and the overhead ratio calculate automatically as you enter actuals.
- Check the net result on the Expenses summary to see revenue minus expenses for the period.
Download the free Free Nonprofit Budget Template (Excel)
No spam — template updates and new free templates only. Unsubscribe anytime.
Small Business Bookkeeping & Tax Dashboard
This template covers budget planning. If you also want to log every transaction as it happens instead of just budget-vs-actual by category, the paid Bookkeeping & Tax Dashboard ($19) tracks up to 500 income and 1,000 expense entries, builds an automatic month-by-month P&L across 16 categories, and adds a CPA-ready export your accountant or auditor can use directly.
See the full versionFrequently asked questions
Can I use this nonprofit budget template in Google Sheets?
Yes. Upload the downloaded file to Google Drive, then open it and choose File > Save as Google Sheets. The variance and overhead-ratio formulas keep working.
Is this template really free?
Yes. You give an email address to download it, and then it's yours to use with no further cost.
What's a good overhead ratio for a nonprofit?
Many funders and charity watchdogs look for administrative-plus-fundraising costs under 25-35% of total expenses, but the right target depends on your organization's size and stage. Treat it as a benchmark, not a strict rule.
Is this specific to church budgets?
No. This is a general secular nonprofit budget built around grants, donations, and program/admin/fundraising categories. If you need tithe and offering line items specifically, use the dedicated church budget template instead.
Is this accounting or tax advice?
No. This template is for record-keeping and planning, not accounting or tax advice. Consult a licensed accountant familiar with nonprofit finance for guidance specific to your organization.