Free Excel template

Free team fundraising tracker template

Q: How do I calculate the percentage of a fundraising goal in Excel?

Divide the amount raised by the goal, for example =F2/B2, and format the cell as a percentage. Wrap it in IF(B2>0,...,0) so an empty goal does not show #DIV/0!.

For booster clubs, school groups, sports teams and charity challenge teams where every participant raises money toward one goal. Enter each person's goal, what they have pledged and what has actually been collected; the template shows the percentage of the campaign goal raised, whether you are on pace for the deadline, how much is needed per day, and which team is leading.

cellwise-team-fundraising-tracker-template.xlsxExcel workbook · 5.6 KB · works in Excel, Google Sheets, Numbers and LibreOffice · no signup

Download free template

Preview and try it

This is the template's sheet, calculated by the same engine as the Cellwise app. Change any number to see the formulas react before you download.

	A	B	C	D	E	F	G	H
1	Team fundraising tracker: spring band trip
2	Campaign goal	10000		Collected so far		6620
3	Campaign start	Oct 1, 2026		% of goal raised		0.662
4	Campaign end	Nov 30, 2026		% of campaign time used		0.53333333333
5	Report date	Nov 2, 2026		Pace		On pace
6				Needed per day to finish		120.71
7
8	Participant	Team	Personal goal	Pledged	Collected	Still to collect	% of goal	Status
9	Ella Brooks	Blue	500	620	540	80	1.08	Goal reached
10	Noah Price	Blue	500	410	410	0	0.82	Keep going
11	Ava Reyes	Blue	500	750	600	150	1.2	Goal reached
12	Liam Chen	Blue	500	180	120	60	0.24	Follow up pledges
13	Mia Patel	Gold	500	520	520	0	1.04	Goal reached
14	Ethan Ross	Gold	500	300	150	150	0.3	Follow up pledges
15	Zoe Turner	Gold	500	890	760	130	1.52	Goal reached
16	Owen Diaz	Gold	500	95	95	0	0.19	Keep going
17	Lily Foster	Green	500	640	500	140	1	Goal reached
18	Jack Rivera	Green	500	460	460	0	0.92	Keep going
19	Chloe Park	Green	500	0	0	0	0	Not started
20	Ben Walsh	Green	500	1150	980	170	1.96	Goal reached

How the formulas work

Percent of the goal raised

F3=IF(B2>0,F2/B2,0)

Money collected divided by the campaign goal, formatted as a percentage. The sample has raised $6,620 of $10,000, or 66%. Count only money you have in hand here; pledges are tracked separately because some never arrive. The IF returns 0 instead of #DIV/0! while the goal cell is empty.

Are we on pace for the deadline?

F4=MIN(1,MAX(0,(B5-B3)/(B4-B3)))

Days since the start divided by the length of the campaign gives the share of time used. MAX and MIN keep it between 0% and 100% before the start and after the end. F5 compares the two: if you have raised a bigger share of the money than you have used of the time, you are On pace. On November 2 the sample is 53% through the time and 66% of the way to the money.

Money still needed per day

F6=IF(B4-B5>0,ROUND(MAX(0,B2-F2)/(B4-B5),2),MAX(0,B2-F2))

What is left to raise, divided by the days left until the end date. MAX(0,...) stops the figure going negative once you pass the goal. After the end date there are no days left, so it simply shows the shortfall. A daily target is easier to rally a team around than a lump sum.

Per-participant status

H9=IF(D9=0,"Not started",IF(E9>=C9,"Goal reached",IF(F9>0,"Follow up pledges","Keep going")))

Nobody pledged yet is Not started. Anyone whose collected money meets their personal goal is Goal reached. Someone with pledges not yet collected (column F) gets Follow up pledges, which is usually the fastest money in a campaign. Everyone else is Keep going.

Team totals and the leading team

C33=INDEX(A28:A31,MATCH(MAX(C28:C31),C28:C31,0))

Each team row uses SUMIF to add collected money for that team and COUNTIF to count members. MAX finds the highest team total, MATCH finds which row it is in, and INDEX returns the team name. Teams of different sizes are fairer to compare on the Avg per member column.

Make it yours

Add a row per participant by inserting rows inside the list (above row 24) so every total and team SUMIF stretches automatically.
Show the goal as a progress bar: select F3, then Home > Conditional Formatting > Data Bars. Or select G9:G24 to put a bar in every participant row.
If people raise money in several payments, keep a separate payments sheet (date, participant, amount) and replace the Collected numbers with =SUMIF(Payments!B:B,A9,Payments!C:C).
Before you send a leaderboard to parents or members, check that everyone is comfortable having their amount shared. You can hide column E and share only the % of goal.

FAQ

How do I calculate the percentage of a fundraising goal in Excel?

Divide the amount raised by the goal, for example =F2/B2, and format the cell as a percentage. Wrap it in IF(B2>0,...,0) so an empty goal does not show #DIV/0!.

Should pledges count toward the goal?

Most groups report money collected as the headline number and track pledges separately, because some pledges are never paid. This template does both and shows the collection rate (collected divided by pledged).

How do I see how much we need to raise per day?

Subtract what you have collected from the goal and divide by the days left: =(goal-collected)/(end_date-report_date). Dates in Excel are numbers, so subtracting them gives days.

Functions used

Related guides

More free templates

Updated November 2, 2026