Excel workbook previewNonprofit Budget Template
3 free downloads per account. Just your email and a 6-digit code.
About this template
A nonprofit budget is the board-approved plan of revenue and expenses for the coming year. Unlike a business budget, it must show which revenue comes with donor restrictions, how much restricted money will be released to pay for programs, and how spending splits between programs, management and fundraising. Boards, grantors and lenders ask for it, and it is the starting point for the year's financial reports.
This workbook builds the budget in the same line order as Form 990, Part VIII for revenue and Part IX for expenses, so the year-end return and the budget use one structure. Formulas split every expense by function, calculate the operating result, ratios and reserve months, preview Form 990 Part I, and phase the year by month. The line structure comes from the free IRS Form 990 and its instructions.
Who it is for
The executive director, finance manager or treasurer who has to put a nonprofit budget in front of the board or a grantor and needs it in a credible format.
What is inside
- Revenue sheet with 13 lines in Form 990 Part VIII order plus 4 blank rows, split into without and with donor restrictions, with prior year change by formula
- Expenses sheet with 25 lines in Form 990 Part IX order plus 4 blank rows, each split into program, management and general, and fundraising by percentage
- Row check that flags any expense line whose percentages do not add to 100 percent
- Summary sheet with the operating result without donor restrictions, the change in net assets with donor restrictions and the total change
- Program, management and fundraising shares, fundraising cost per dollar of contributions and months of operating reserve, all by formula
- Form 990 Part I preview for lines 8 to 19 (line 14 not used) calculated from the budget lines
- Monthly sheet that phases revenue and expenses over 12 months from a start date, with the lowest cumulative position
- Worked budget for an invented youth charity and a How to use sheet
How to use it
Replace the prior year actuals with your own, then enter next year's budget by line and restriction on the Revenue and Expenses sheets.
Files
- XLSXnonprofit-budget-template.xlsx18 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets, and LibreOffice. Built on free, official texts that anyone can read: laws, regulations, standards and guidance published by public bodies. A template to adapt, not legal, tax or accounting advice.
Questions about this template
Why split a nonprofit budget by donor restriction?
Revenue with donor restrictions can only be spent on the purpose or in the period the donor set, so it cannot cover general costs. Showing it separately, together with the planned releases from restriction, gives the operating result without donor restrictions, which is the figure the board needs to judge whether the plan is sustainable.
How do I split expenses between programs, management and fundraising in a budget?
Use the same bases you use at year end: staff time for salaries and benefits, floor space for occupancy and headcount for office costs. The Form 990 instructions require a reasonable, documented method. This template takes three percentages per line and checks that they add to 100 percent.
What does the fundraising cost per dollar measure?
It divides budgeted fundraising expenses by budgeted contributions, gifts and grants, the Form 990 Part VIII line 1h total. It shows how much the organization plans to spend to raise each dollar of contributions. It is a planning ratio for the board, not a legal limit.




