If you are looking at maximizing your fundraising efforts for supporting smaller communities and charities, then you need to have some organized solution to monitor your achievements in comparison with the set targets as you progress. Spreadsheet123's Event Fundraising Template helps to keep track of donations, donor names as well as overall progress for achieving your goals.

Every fundraiser event involves a lot of monetary transactions. Therefore it is important to maintain a record of each transaction carefully. The charity intended funds must always be accounted for, specifically for audits and inspections. This template makes a fundraiser event a transparent process. It is best suited for small-scale fundraising events, including charity events, parties, or school fundraising events. However, you can also use it for medium or large events.

Download the Event Fundraiser

Excel 2003 (xls) - 2003 or newer (PC or Mac)

Excel 2007 (xlsx) - 2007 or newer (PC or Mac)

Google Sheets - Google Sheets

OpenOffice.org Calc (ots) - OpenOffice.org Calc

DOWNLOAD

Using Event Fundraiser

Event Fundraiser template enables you to monitor the progress against the targets. Begin with setting the name of event, mode of payments and contact preference in the Setting sheet. Then record the set target in Fundraiser sheet. This sheet provides a graphical description of the funds received against the target. You can easily monitor progress at any point of time by reading the overall achievement percentage. You can also watch the funds collected during a selected period.

All you need to do is to record each transaction in the table on the Fundraiser sheet. Here you can record the Date of transaction, Name of contributor, Amount contributed, Payment Type along with the payment reference. You can also record your comments with each contribution, like if the contributor can be approached again for other events or they want the details of contribution and contributor remain discrete, etc.

During the fundraising events, you might want to record the contributor's personal details like address along with their email , phone number, and preferred contact method. This is sometimes required when you manage multiple fundraising events and you need to approach some of the contributors for the other events.

This template also secures you legally from any unaccounted money complications. With this type of tracking method, you will always stay organised and have a reliable record of transactions to answer all queries at any point of time, even in future.

Function used in template

• SUM (number1, [number2], [number3], [number4], ...)
• TODAY()
• IF(logical_test, value_if_true, [value_if_false])
• SERIES(name_ref, categories, values, plot_order)
• SUMIFS(sum_range, criteria_range1, criteria1,[criteria_range2, criteria2],...)

Related Content