suggestions for payable/receivable for nonprofit sport team?

[Guest]

I need a basic accounting worksheet to track monthly dues, tournament fees,
etc. for a non-profit baseball team. This team only consist of 15 players.
Would you suggest that I just set it up in Excel? I would also want to be
able to run a report by sorting information. This sounds easy and probably
is but I am looking for suggestions on what the best program would be to
use... Thanks for any information you can provide.

 

[Guest]

Sounds like just the thing for Excel. Just a matter of how you want to set
it up and what you want to add or sort. I take it each player must pay both
monthly and tournament fees? I'd create three columns to start. The left
most column (A) I'd enter the players names (last name 1st, then 1st name).
The 2nd column (B) could be monthly dues and the 3rd column (C) could be
tournament dues. You could then have the 4th column (D) be a totals column
that would total the fees paid by each player. Is that the type of thing you
are after?