Budget Model

Swansea University Sport requires all affiliated clubs to complete an annual budget model forecasting and recording all incoming and outgoing expenditure.

The Budget Model is split into several tabs to ensure that key data is recorded and can be used to inform decisions throughout the year.

The tabs required are:

Budget Model                

I Vs. E (Income Vs. Expenditure)
Members                        

Facilities
Inventory
Sales Report
Statement

Budget Model:

This tab is where the complete overview of the club finances is listed. Information such as the opening balance, final transaction number and overall profit and loss figures are listed here to enable you to have a quick view of key information.

Further information allows you to see an overview of your projected budget, on a line by line basis, as well as your actual budget, once updated. We recommend that you enter in the relevant data at least once a month.

I Vs. E (Income Vs. Expenditure)

This tab is used to record all income and expenditure and to allocate where the money has come from or is going to. The information is taken directly from the club statement and is then broken down into the respective columns identified at the beginning of the season. By the end of the season, the data on this page will form the main body of the Treasurer's Report at the club AGM. 

It is essential that the updates are recorded monthly as a minimum, so that it can be clearly identified if projected figures and actual costs are as accurate as possible.

Members

This tab is used to record all membership data of members payments. Information for this page can be found by running a 'sales report' through the club SGF system.

Information gathered includes members name, student number. Team / Squad, Membership Type, Fees and products / merchandise sales as an example. These areas can be amended / added to in consultation with you club SDO.

Facilities

This tab records your sessions throughout the year and which team / squad is using facilities. As more sessions take place throughout the year, the table is updated on the left and the fees are automatically calculated on the right.

This process allows the club to cross reference any invoices for facilities to ensure the charges are correct.

Inventory

This tab records all items of equipment and kit the club has purchased. This information is essential to ensure that the investment fund of the club is maintained to the level required to support ongoing costs of replacement and modernisation. 

Sales Report

This tab records the information generated by the SGF system and needs to be updated on a monthly basis. The information can be used to cross reference against incomes streams in the I Vs. E tab to ensure the breakdown of fees is allocated correctly to the squads and also to the Membership tab to record all members payment status.

Statement

This tab is used to hold a visual of all transactions to date. This should be requested monthly to ensure that all data can be added to the respective 'I Vs. E' tab and then consequently the 'Budget Model' tab.