This is the first time I tried to reply to a post or a private message.
You have come to the right person. I have experience as Treasurer of several Clubs and have created a spreadsheet as required. I think something simple would be appropriate. This would have a date; a description;then an income section with say 5 headings; an expenditure section with the same headings; a total income; a total expenditure; and a net balance.
Have you any idea how many entries per year there would be?