Nonprofit Budget Template

Most nonprofit budget templates are a blank grid with the word “budget” at the top. The useful part is not the grid, it is knowing which lines belong on it and which mistakes the structure should prevent.

This one comes with the lines filled in, twelve months across, and every total as a live formula.

What is in the spreadsheet

Every month column totals down, every line totals across, and a surplus or deficit row calculates at the bottom. Change one figure and everything updates.

Four structural decisions built into it

Events are shown at gross, with their costs in expenses. Netting a gala down to one number hides what fundraising actually costs you. A $40,000 event that cost $35,000 to run should be visible as both figures, not as $5,000. It also matters for your annual return, where gross receipts determine which Form 990 you file.

Recurring giving is separated from one-off donations. They behave completely differently. Recurring income is predictable enough to plan against, and separating it lets you see whether your base is growing or you are just having a good year.

Payroll taxes have their own line. Exemption from federal income tax is not exemption from payroll taxes. Those are owed in full, and burying them inside salaries is how organizations under-budget by fifteen per cent or more.

Bank and processing fees are a line, not an afterthought. On a small organization taking many small gifts, processing can quietly cost three to five per cent of everything raised. Our fee calculator works out what your typical gift actually costs you.

How to fill it in

Start with expenses, not income. Expenses are largely knowable, income is a forecast, and building income first tempts you to write down the number that makes the bottom line work.

Enter what you are contractually committed to first: salaries, rent, insurance, anything on a subscription. Then programme costs. Then the discretionary lines.

Now forecast income conservatively. Count grants only when awarded, not when applied for. Count recurring giving at your actual retention rate rather than assuming everyone stays.

The gap between the two is your real fundraising target, and it is more useful than any number you would have chosen first.

Budgeting for a surplus is not greed

A nonprofit that plans to spend exactly what it receives has no capacity to absorb a grant that pays late, and late payment is normal rather than exceptional in this sector.

Many funders now look for three to six months of operating reserves as evidence of competent management. Building toward that has to be a budget line, because it never happens by accident.

What this template does not do

• It is not fund accounting. If you hold restricted grants, you will eventually need to track restricted and unrestricted separately, which is a job for accounting software rather than a spreadsheet.
• It is not a cash flow forecast. A budget says what you will receive and spend over a year. Cash flow says when. An organization can be on budget and unable to make payroll in March.
• It does not produce your Form 990. It will make preparing one considerably easier, which is not the same thing.

A worked example

A small organization with one part-time coordinator, running a single programme and one annual event.

Two things this example is meant to show. The event grossed $12,000 and cost $7,500, so it netted $4,500 for a great deal of work, which is a conversation the board should have and cannot have if the event appears as a single net figure.

And a $350 surplus on $62,200 of income is a rounding error. One late grant payment and this organization cannot make payroll. That is not a badly built budget, it is what most small nonprofit budgets actually look like, which is why building reserves has to be deliberate.

Reading a budget against actuals

A budget is only useful if someone compares it to what happened. Once a month or once a quarter, put the two side by side and look at variance rather than absolute numbers.

Three variances worth acting on: income behind plan by more than about ten per cent at the halfway point, any expense line over plan without a decision behind it, and a programme line significantly under spent, which usually means the work is not happening rather than that you are saving money.

Restricted funds and why they break budgets

A restricted gift is money a donor has said must be spent on a particular thing. Once you accept it, that restriction is binding. You cannot decide later that the rent was more urgent.

This matters for budgeting because an organization can hold a healthy bank balance and still be unable to pay its staff, if most of that balance is restricted to a programme. The number that tells you whether you can operate is unrestricted income against unrestricted expense, not the total.

If a large share of your income is restricted, add a second view of the budget that shows unrestricted income against the costs that nothing else will cover. That is the view that tells you whether the organization survives the year.

Building reserves on purpose

An operating reserve is unrestricted money set aside to absorb a shock, a grant that arrives late, an unexpected repair, a funder that does not renew. Three months of operating expenses is the figure most commonly cited as a floor, and most small organizations hold considerably less.

Reserves are not built by having a good year. They are built by putting a reserve contribution in the budget as an expense line, funding it monthly, and treating it as unavailable. An organization that plans to save whatever is left at year end saves nothing, because there is never anything left.

On the example budget above, a $350 surplus is not a reserve. A deliberate $200 a month transfer, budgeted as a line, is $2,400 by year end. It is still not three months of cover, but it is the difference between a plan and a hope.

Cash flow is a separate question

A budget that balances over twelve months can still leave you unable to pay a bill in March. The budget answers whether the year works. Cash flow answers whether each month works, and they are not the same question.

The mismatch is usually timing. Grants arrive in instalments, sometimes in arrears against expenditure you have already made. Event income lands in one month against costs incurred over three. Payroll, rent and insurance are indifferent to all of it.

If more than about a third of your income arrives in irregular lumps, add a running cash balance row beneath the monthly totals in the spreadsheet, carrying the previous month forward. Any month where that row goes negative is a month you need to plan for now, by moving a payment, holding a reserve, or asking a funder to pay earlier.

Download this template

Free, no email address, no signup. The full text is on this page as well, so you can read it before you download it.

• Nonprofit budget template Twelve months, live formulas, income and expense lines already set up XLSX · 7 KB

Questions people ask

What should a nonprofit budget include?

Every source of income and every category of expense for a full fiscal year, at gross rather than net.

On the income side: individual donations, recurring giving, foundation grants, government grants, corporate support, earned revenue, events at gross, and investment income.

On the expense side: salaries, payroll taxes and benefits as a separate line, contractors, rent and utilities, insurance, programme costs, event costs, software, accounting, legal, marketing, travel, office and supplies, and payment processing fees.

The two lines people most often omit are payroll taxes and processing fees, and together they can account for a fifth of a small organization's real costs.

When should we start budgeting for the year?

Two to three months before your fiscal year begins, so the board can approve it before the year it governs.

For a calendar year organization that means drafting in October, reviewing in November and approving in December. Approving a budget in March for a year that started in January means running a quarter of the year without one.

Build in a mid-year review as well. A budget that is never revisited becomes a document nobody consults by about month four.

Should the board approve the budget?

Yes, and in most organizations the bylaws require it.

Budget approval is one of the clearest expressions of a board's fiduciary duty. It is the point at which the board decides what the organization will do with its money, and it should be a discussion rather than a formality.

Record the approval in the minutes with the date and the figures approved. That record matters if anyone later questions whether spending was authorised.

How detailed should the line items be?

Detailed enough to manage against, coarse enough that someone will actually maintain it.

Around twenty to thirty lines suits most small organizations, which is roughly what this template provides. Below about ten lines you cannot see where money is going. Above about fifty, the maintenance cost exceeds the insight.

A useful test: could you explain a variance on this line to your board without opening another document? If not, split it. If a line has been zero for two years, merge it into Other.

How do we budget for grants we have applied for but not won?

Do not count them as income. Track them separately as pipeline.

Putting unconfirmed grants into your budget produces a document that balances on paper and fails in reality, and it is the most common way small organizations end up over-committed.

A workable approach is two columns: a conservative budget counting only committed income, and a pipeline showing what is applied for with an expected decision date. Move an item across when the award letter arrives, not when you feel optimistic about it.

What is a reasonable overhead ratio?

This question has done real damage to the sector, and the honest answer is that there is no correct figure.

Ratings sites and some funders have historically pushed organizations toward minimal overhead, which has produced underinvestment in accounting, technology and staff development. The phrase for it is the nonprofit starvation cycle, and it is widely recognised as a problem rather than a standard.

Budget for what the work genuinely requires, including competent finance and administration. If a funder demands an arbitrary ratio, that is information about the funder.

Do we need different budgets for different funders?

You need one organizational budget, and project budgets that reconcile to it.

A funder supporting one programme will usually want a budget for that programme specifically, showing what their money buys. That is a subset of your organizational budget, not a separate exercise.

The critical discipline is that project budgets must add up to something consistent with the whole. Organizations that maintain unrelated budgets per funder lose the ability to answer the only question that matters, which is whether the organization as a whole can pay for itself.

Can we use this spreadsheet instead of accounting software?

For budgeting, yes, indefinitely for many small organizations.

For bookkeeping, no. A budget is a plan. Bookkeeping is the record of what actually happened, and your annual return depends on the second.

The point at which a spreadsheet stops being adequate for bookkeeping is usually when you hold restricted funds that must be tracked separately, when more than one person records transactions, or when you need an audit. Budgeting in a spreadsheet alongside proper bookkeeping elsewhere is a perfectly normal arrangement.

This is reference information, not legal or tax advice. Rules vary by state and change over time. For a decision that carries real consequences, check the current text at irs.gov or your state registry, and talk to a nonprofit attorney or CPA.