I'm not sure what the best way is to go about solving this problem, so I thought I'd ask and see if anyone could put me in the right direction.

The problem: We are an organization that collects money from people for different events. But, we have always had people pay separately for each event due to our budget line item structure and how we were recording things. Yes, that's a problem.

EXAMPLE:
Mr. Doe wants to buy Event A, Event B, and Event C. He sends in a payment for A, another payment for B, and another payment for C. We record each of those payments in separate tracking spreadsheets.

The solution: We will have each person send one check for all events that they want and we will break it out into one tracking spreadsheet.

EXAMPLE:
Date Name Total Event A Event B Event C Event D
8-1-13 Mr. Doe $60 X X X


So, we need to be able to enter the person's information and then check off each event that they purchase. This data entry page (if it's a page and not a form) would be ongoing. Therefore every day we get a purchase, we just add it to the next line down.

We must also have subsequent pages to track the purchasing of each event so that we can run reports or create a daily report page from the data.

I hope I've explained myself well enough. I'd love to hear feedback on what you think would be the best way (as well as easiest way) to do this. Thanks!