Nonprofit Budget Template

Getting started takes about 15 minutes. Download the .xlsx file and open it in Excel or Google Sheets — no macros or plugins required. Begin with the Annual Budget sheet: review the pre-loaded revenue and expense categories and adjust them to match your organization's chart of accounts. Most nonprofits keep the structure as-is and rename a handful of line items to match their specific programs or grant categories. If your fiscal year runs July through June rather than January through December, update the column headers on the Budget vs Actual sheet — everything else stays the same.

Once the categories are set up, enter your projected revenue by source and your planned expenses by category and program. For grant income, use confirmed award letters as your baseline and flag pending applications separately so you're not planning against money you haven't received. Move to the Program Breakdown sheet and allocate staff time and direct costs to each program — this is worth doing carefully because it's the data you'll pull when a funder asks for a program-specific budget. Add your active grants to the Grant Tracker sheet with their deadlines and restrictions so you have a single place to monitor compliance.

The real value comes from the monthly comparison. Each month, enter your actual revenue received and expenses paid into the Budget vs Actual sheet. This takes about 20 minutes if you have your bank statements and accounting software export handy. The variance column will flag immediately if grant income is running behind projection or if any expense category is trending over budget. Review the Dashboard before every board meeting — the program expense ratio and operating reserve figures are the two numbers board members ask about most consistently, and having them calculated automatically means you're never scrambling to pull those numbers together the night before.

Nonprofit budgeting has a different set of pressures than for-profit budgeting. Revenue is unpredictable — grants arrive late, annual fund campaigns come in under goal, and government contracts sometimes reimburse months after services are delivered. At the same time, nonprofits face scrutiny on how they spend that revenue that most businesses don't: charity watchdogs like Charity Navigator and GuideStar publish your expense ratios publicly, major donors ask for program breakdowns before they give, and auditors review whether restricted grant funds were spent only on allowable expenses. A well-structured budget is the foundation of all of it.

The standard nonprofit budget organizes expenses into three buckets that match IRS Form 990 reporting: program services (the actual work of the mission), management and general (administration, finance, governance), and fundraising. Charity watchdogs generally look for program services to represent at least 65–75% of total expenses — the higher, the better. Fundraising costs are typically expected to stay below 15–20% of funds raised. These aren't hard rules, but they're the benchmarks that donors and grant reviewers apply when they evaluate your organization. This template calculates those ratios automatically so you can see where you land and make spending decisions accordingly.

The most important budget discipline for nonprofits is tracking restricted funds separately from unrestricted ones. When a foundation gives you $50,000 restricted to a specific program, that money cannot be used for admin or other programs without violating the grant terms — and violations can damage your relationship with that funder permanently. The grant tracker in this template is designed to prevent that by showing you, for each grant, how much has been spent and how much remains. Pair the tracker with the Budget vs Actual sheet and you have a monthly system for catching both overspending and underspending on grants before the reporting period closes.