| A | B | C | D | E | F | G | H | I | J | K | L | M | N | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | a | |||||||||||||
2 | Welcome to the Club Balance Tracker | |||||||||||||
3 | ||||||||||||||
4 | This document is read-only but will help you to better understand your club finances | |||||||||||||
5 | ||||||||||||||
6 | Overview of contents | |||||||||||||
7 | ||||||||||||||
8 | Sheet Name | Purpose | ||||||||||||
9 | Club Balance | See your last available Club Balance | ||||||||||||
10 | Outstanding Debits/Credits | See all the payments that have been made as a proforma but not yet been allocated to your club account See which sponsorship contract amounts are outstanding for collection | ||||||||||||
11 | Tranactions (FY XXXX) | List of all transactions that are processed in each SA Financial year | ||||||||||||
12 | ||||||||||||||
13 | Notes | |||||||||||||
14 | - The SA Financial year starts in August and ends in July, therefore our financial periods are structured such that 2019/001 is the first month of the SA financial year which ends during 2019 | |||||||||||||
15 | - This means 2019/001 refers to August 2018 | |||||||||||||
16 | - Balances are calculated by adding all recognized trasactions your club incurred in a given period to the end balance of the prior period | |||||||||||||
17 | - While some of your supplier payments have been paid, they may not show up here until they are recognized (Eg. Hotel stays are only recognized after the stay and not at the point of payment) | |||||||||||||
18 | - Often payments like these are for Pro-forma invoices | |||||||||||||
19 | ||||||||||||||
20 | Common reports you my require | |||||||||||||
21 | ||||||||||||||
22 | 1. Club Report | Go to the relevant Transactions tab and filter on Column M using your club name, be sure to also account for any sponsorships that are in the transactions yet to be collected and any proforma that have been paid but are yet to be allocated to your account, info on these can be found on the Outstanding debits/credits sheet | ||||||||||||
23 | ||||||||||||||
24 | 2. Event Report | Go to the relevant Transactions tab and filter on Column N using your club name, be sure to also account for any sponsorships that are in the transactions yet to be collected and any proforma that have been paid but are yet to be allocated to your account, info on these can be found on the Outstanding debits/credits sheet | ||||||||||||
25 | ||||||||||||||
26 | 2. Period Club Report | After getting a Club Report, go to column P and select the relevant period, keep in mind the note regarding the SA Financial year | ||||||||||||
27 | ||||||||||||||