Financial Journals for TEAM use_05 Oct 2011
Both the Financial Journal for TEAM use and the Financial Journal_ SAMPLE consist of the following 6 sheets within the overall worksheet:
1. A Summary page with Actuals compared to the team’s budgeted amount – with links to the 2nd sheet. As indicated on this page, there is a colour-coding scheme that applies to all sheets within this worksheet or file.
2. A Team Revenues & Expenses sheet – effectively a cash receipts and disbursements journal – with the totals linked up to the Summary sheet
3. A Team Deposits sheet – for teams to record their total amount of each deposit made during each month, as applicable
4. A Sponsors & Related Credits sheet – for teams to track their sponsorship funds and player credits, if and where applicable.
5. A Parent Contributions sheet – to allocate funds deposited by the team to either the appropriate player or to the team as a whole (Team Revenues) where revenues are not attributable to a specific player and that should agree to the teams total deposits as per the next sheet (hence the check digit at cell D35).
6. A Payout Calculation sheet – to calculate the Return of Excess Parent Contributions at the end of the season. This sheet should work provided the players on the team do not change during the year – that is, where there are no post-tryout releases of players and/or late players additions to the team – and where all parents have paid their necessary parent contributions (so that there are no negative cheque amounts in column Q). Where there are post-tryout releases of players and/or late players additions to the team or where there is one or more negative cheque amounts in column Q, the AAA Treasurer may need to assist the team in making the final calculation – although the AAA Treasurer should be given the opportunity to review all team payout calculations before they are made to ensure that they are done appropriately.