The Club Treasurer Master is set up to make your job about as quick and simple as possible. Here's how to use it:

Start in the 'Info Page' sheet. Only change the cells that are coloured yellow. This sheet sets up numbers that are calculated elsewhere. Add your information, your club infomation, current members, expected members and expected new members. Then down to enter the current exchange rate (err on the side of caution, and include two decimal places).  Then bank account information.

Go to the 'Club Budget' sheet. Only change the cells that are coloured yellow. Consult last years budget/actuals to help guide you on estimating these numbers. When estimating expenses, round up to be conservative. If any items are not applicable, just leave them as '0' (rather than deleting the row). You can also change the assumptions next to the yellow cells only.

By now on these two tabs, you will see your Membership Renewal Fee and New Member Fee will have calculated. And you will have a presentable budget - feel free to export it to PDF to take to your club meeting.

In September and February, use the 'Renewals Invoice' to generate an invoice for members. The two dates can be changed, and there is a dropdown to pick the renewal period. You will see the club bank details have populated below.

There are two 'Schedule of Fees' tabs. If you are a club that charges a new member fee, use the'Community Club' option. If you are a club that does not charge a new member fee, use the 'Advanced Club' option. You can change the copy under the 'What You Need to Know' heading. Include a PDF version of your Schedule of Fees in the guest kit at the club!

The 'Reimbursement Request' sheet contains a printable form if your club requires a paper trail if/when members purchase items for the club.

'Transactions' is where you can import the transactions from your bank account and use the 'Category' column to categorise the expenses and monitor actual spend throughout the year.

Those categorised transactions are then compiled in the 'Summary' sheet. This will compare the budget to actual spend, and reconcile payments against the bank balance. Note the 'Checks' box at the bottom. You only need to enter the actual, current bank balance on this sheet.

Use the 'Renewals Tracker' to keep yourself organised as members pay the club and you pay TI their fees. It can be helpful to not have to keep all that information in your head, rather in any one place. Yes, if a member does not intend to renew, they are crossed out!

Lastly, the 'Fee Lookup' you likely won't need. It powers the Member Fee calculator, but you can also have a look at the profit/loss table if you're a bit of a numbers nerd like us!