Our Non-profit (a school) holds many fundraisers each year. I need to keep track of how much money each student raises in each fundraiser. I’ll need to report on which student has raised the most for each fundraiser and also which student has raised the most overall.
These fundraisers involve the students getting sponsors to donate a certain amount.
I will need to issue receipts to each donor (the payer). So I can’t put the student’s name as the payer (since they aren’t anyway).
I thought of using a tracking code for each fundraiser and adding a custom field on the receipts where I’d input the name of the student sponsored for that amount.
I hope this set-up will allow me to see which student has raised the most for a given fundraiser. Will it also let me see which student has raised the most across all the fundraisers ?
Also, I don’t really know how to generate these reports.
I really want to avoid having to create a separate spreadsheet to keep track of amounts I’ll be entering into Manager anyway.
Your help would be very much appreciated.