I would actually prefer making a spreadsheet for this. It maybe be easier to do in ingame, I used addons for guild management in the past, and while they did make some things easier, I never was comfortable with them.
I much prefer keeping everything on a spreadsheet, which can easily be backed up onto a thumbdrive or something and also be shared with the guild if needed.
Maybe not really an answer to the question, but just thought I'd mention this