Fundraising Event Budget Template (Free Excel) for a Gala

The planning committee has a number: raise $62,000. The spreadsheet has ticket prices, a catering quote, the band, and a line for flowers. Then the event happens, and three people ask three different questions. The board asks whether it made money. A donor asks how much of the ticket is deductible. And in April, the Form 990 preparer asks for the event’s gross receipts, contributions, and direct costs by category.

A budget built only around cash can answer the first question. This fundraising event budget template is built to answer all three, from the same lines. It uses the same illustrative gala as our Schedule G walkthrough and our guide to fundraising event accounting, so you can follow one set of numbers from the plan to the return.

Download the fundraising event budget template

Budget the event the way the 990 will read it

A wedding budget counts the guests before it counts the flowers, because the guest count drives the biggest line. An event budget for a nonprofit needs one more number beside each ticket: the value of what the guest receives. That column is the reframe this template is built around. Cash tells you what the event kept; the value per guest tells you what the event was, in the terms the donor receipts and the return use.

The template does this split on every benefit line, using the actual quantities, and adds the gifts that came with no benefit, such as the paddle raise. The rule behind it is in the Form 990 Part VIII instructions for lines 1c and 8a; our event accounting guide shows the same split as journal entries.

How to set the value per guest

The value per guest is a good-faith estimate, and the IRS guidance on quid pro quo contributions allows any reasonable method applied in good faith. For something not sold commercially, you may use the value of similar or comparable goods or services. The IRS example values a private event in a museum room at the cost of renting a comparable hotel ballroom.

For a gala dinner, the caterer’s per-guest charge or the price of a comparable dinner are both reasonable starting points. Write down how you set it in the template’s note column; an auditor or a donor may ask to see it.

Costs, sorted by Schedule G line

Each direct cost goes on the line for its category, so the Schedule G tab can fill itself. The line definitions come from the Schedule G instructions.

Catering is the line that moves with the headcount, so the template multiplies the per-guest cost by the guests from your ticket and table lines. Donated auction items follow the IRS example in the Form 990 line 8c instructions: the item’s value when donated is a noncash contribution when it arrives, and when it sells, that value and the selling costs become direct expenses. The template’s self-check reproduces that example. One judgment call: invitations whose main job is to ask for gifts can be treated as fundraising costs in Part IX rather than direct event costs, so settle that line with your preparer.

The sample gala: budget against actual

Here is the illustrative gala as the template’s summary shows it. The plan assumed 220 individual tickets and a $5,000 paddle raise; 200 tickets sold, and the paddle raise brought in $6,000.

The event kept $37,360, and Schedule G will show ($5,280). That is not a mistake: line 11 sets the direct costs against the $17,360 value of benefits only, because the $42,640 of contributions is reported on its own line. Our Schedule G guide explains how to say that to the board in one sentence.

What about the direct cost per dollar raised? We know of no authoritative benchmark for a good number at a gala, so the template doesn’t grade it. Its use is comparison: this year’s event against last year’s, and the budget against the actual.

The receipt sentences it writes for you

A receipt is like a restaurant bill that also shows the tip: two amounts, each with a different job. The Donor disclosures tab writes one sentence per benefit line from the price and the value you entered.

The IRS requires this written disclosure for any payment over $75 that is partly a contribution and partly for goods or services, given with the solicitation or the receipt, and it can charge $10 per contribution, up to $5,000 per event or mailing, when it is missing, unless the failure was due to reasonable cause. The sponsor’s $3,440 gift also needs a written acknowledgment because it is $250 or more; our donation acknowledgment letter guide and donation receipt template cover the wording.

How to use it for your next event

Start with these steps for your next event, and add sections as your events grow. A short budget you update after every event beats a detailed one you avoid.

1. When you set the goalEnter ticket and table prices, the value per guest, and budget quantities. Get a per-guest quote from the caterer.
2. When the invitations go outPut the sentence from the Donor disclosures tab on the ticket page and the receipt.
3. The week after the eventEnter actual quantities, the paddle raise, auction sales, and every invoice on its Schedule G line.
4. At the board meetingReport both numbers from the summary: what the event kept, and what Schedule G will show.
5. When the 990 is preparedSend the Schedule G tab, and enter your other events in the $15,000 test.

Planning the rest of the year’s budget? Our nonprofit budget template covers the operating budget, and the grant budget template covers funder budgets.

How we can help with your event

If we keep your books, we can fill the actual column from the ledger after the event closes, and if we prepare your Form 990, the Schedule G tab can serve as the working paper for Schedule G. Form 990 preparation starts at $1,500 and monthly bookkeeping at $300 a month, with the full list on our pricing page.

GivingArc provides bookkeeping, Form 990 preparation, and nonprofit-specialized accounting for small and mid-size 501(c)(3) organizations across the US. The gala in this guide and all of its figures are illustrative. General information, not tax or legal advice. Reviewed by Min Kim, CPA.