Governance Reporting

This template has been built in consultation with the sector. It is designed to reflect the key information re
boards for the majority of organisations. It will need adapting for individual circumstances.

This is a governance document. It is designed to serve the needs of the board for clear, concise, aggregat
information. It is not a set of management accounts and nor does it provide the level of detail that may be
a finance sub-committee.
Any board should have made it clear to management what information is required. This should come from
measures in the strategic plan, the financial policies and delegations and any particular areas of risk that
board. The board and management should also have agreed on “lead’ measures such as staff and stakeho
satisfaction, retention levels, efficiency rates, renewals etc. which contribute to the higher level outcomes

Management should not be left guessing the information requirements of the board.
flect the key information required by
umstances.

or clear, concise, aggregated

level of detail that may be required by

ed. This should come from the

articular areas of risk that concerns the
s such as staff and stakeholder
the higher level outcomes.

s of the board.
Monthly Reporting Template
Proudly created by Hayes Knight

This report template provides a basic outline for the presentation of monthly reports, both financial and non financial. It is intended to be modified to fit the specific requriements
of each organisation.

Note that data should only be entered into cells coloured light blue:

Please enter the following information in the cells below. Other data can be made directly onto the worksheets, in the light blue cells.

Reporting entity name: Example Sporting Organisation

Reports for the 12 months begining : 1 July 14
Report for the month of: Aug-14

This template has four worksheets in addition to this introduction section:

Summary Report: A high level overview of key financial measures. No data input is required in this section but commentary can be added.
Financial Report: A detailed financial analysis of both the latest month and year to date, together with graphs relating to key items.
Non Financial Statistics: A detailed analysis of non financial metrics, including environmental and human resources.
Financial Data Input: Input required of monthly financial data and full year budgets. Enter data only in the blue cells.

Terminology:
The following terms are used within this template:
Working Capital: a measure of the entity's ability to pay its costs as they fall due. It is the sum of all current assets that the entity has (cash, accounts receivable)
less current liabilities (bank overdraft, accounts payable).
Days Covered by Net Liquid Assets: an indication of how many days an entity could handle short term cashflow problems. It calculates how many days operational expenditure can be
paid for from cash and other liquid assets held. A common benchmark is 90 days cover.
Equity: the sum of all the assets that the entity has, less all the liabilities that is has. Negative equity indicates that the entity is in an insolvent position.
Overdue Receivables: amounts collectable by the organisation for services performed or fees levied that should already have been received.
Overdue Payables: amounts payable by the organisation for goods or services received that should already have been paid.
Secured Revenue: income streams that have been contracted for prior to the commencement of the financial year.
Unsecured Revenue: income streams that are anticipated and budgeted for but have not been secured or contracted at the commencement of the financial year.

Traffic Light Colour Coding

In certain areas of the report, figures will be highlighted Green, Yellow or Red. Green shading applies to items that are equal to or better than forecast, yellow for items below forecast but
within 10% of forecast and red for items that are greater than 10% below forecast.

Note: As this template contains many automated features, adding or removing columns or rows may cause functionality to be lost. For queries regarding the template or to obtain
a quote to customise the template to meet your specific needs, please contact:

Tristan Dean
Hayes Knight North Limited
Email: tristan.dean@hayesknight.co.nz
Phone: 09 414 5444
Summary Monthly Report : Example Sporting Organisation [i
FINANCIAL

Reporting Month: Aug-14

Financial Performance Aug-14 YTD Financial P

Actual Budget Variance Actual Budget Variance

$3,500
Total Income $ 1,295 $ 1,650 -$ 355 $ 2,470 $ 3,177 -$ 707
$3,000
Total Expenses $ 1,029 $ 1,315 $ 286 $ 2,338 $ 2,630 $ 292
Net Surplus $ 266 $ 335 -$ 69 $ 132 $ 547 -$ 415 $2,500
$2,000
Remaining unsecured budgeted income: $ 2,000 $1,500
Percentage of full year unsecured income collected: 18.75% $1,000
Amount ahead/behind unsecured income budget: $ 50 $500
Latest expected full year surplus/shortfall in unsecured income: -$ 790 $-
Revenue
Income in August was higher than expected due to a one off grant being received from XYZ. However, program and training course expenses were significantly over budget due to having to
rewrite manuals and procedures.

Financial Position Aug-14

Cashflow Budget, Actual and Forecast Monthly Net Surplu
$1,400
$800
Cash On Hand $ 1,160 $1,200 $600
$1,000 Budget $400
Working Capital $ 1,301
$800 $200
Actual $-
Total Assets $ 2,801 $600
Total Liabilities $ 1,335 -$200 Jul-14 Sep-14 Nov-14
$400 Latest
Forecast -$400
Total Equity $ 1,466 $200 -$600
$- -$800
Overdue Receivables $ 350 Jul-14 Sep-14 Nov-14 Jan-15 Mar-15 May-15
-$200 -$1,000
Overdue Payables $ 170
-$1,200

Insert Commentary Insert Commentary Insert Commentary

S
Days Covered by Net Liquid Assets Immediate Cash Reserves/(Cash Shortfall)
90 $3,000
$1,200
80 $2,500
70 $1,000
$2,000
60 $1,500
Days $800
50
Cover $1,000
40 $600
$500
30 $-
Target $400
 Days $800 $1,500
50
Cover $1,000
40 $600
$500
30
Target $400 $-
20 Days
10 $200
0 $-
Jul-14 Sep-14 Nov-14 Jan-15 Mar-15 May-15
Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15

Insert Commentary Insert Commentary Insert Commentary

Summary Monthly Report : Example Sporting Organisation [i

DIVISIONAL RESULTS

Reporting Month: Aug-14

YTD Net Surplus By Division

$40
$35
$30
$25
$20
$15
$10
$5
$-
Division 1 Division 2 Division 3 Division 4 Division 5

Current Month Net Surplus by Division

$15

$10
 $15

$10

$5

$-
Division 1 Division 2 Division 3 Division 4 Division 5

-$5

-$10

Insert Commentary/Overall Summary

 [ insert logo here]

Financial Performance - Year to Date

Actual
Budget

Revenue Expenses Net Surplus

thly Net Surplus Budget, Actual and Latest Forecast

Budget

Actual
Sep-14 Nov-14 Jan-15 Mar-15 May-15
Latest
Forecast

Surplus Forecast
y

[ insert logo here]

Actual
Budget
Variance

5
 Actual
Budget
Variance

ion 5
Monthly Financial Report : Example Sporting Organisation [ inser
Financial Summary for This Month : Example Sporting Organisation

Statement of Financial Performance Aug-14 Aug-14 Aug-14 Aug-14 YTD YTD YTD YTD
Actual Budget Var $ Var % Actual Budget Var $ Var %
Income
Membership Fees 100 100 - 0% ü 215 200 15 8%
Sponsorship Income (Secured) 80 100 (20) -20% û 130 200 (70) -35%
Sponsorship Income (Unsecured) 75 100 (25) -25% û 225 200 25 13%
Grants (Secured) 800 950 (150) -16% û 1,300 1,777 (477) -27%
Grants (Unsecured) 75 100 (25) -25% û 225 200 25 13%
Event Income 80 100 (20) -20% û 130 200 (70) -35%
Other Income 75 100 (25) -25% û 225 200 25 13%
Other Income 10 100 (90) -90% û 20 200 (180) -90%
Other Income - - - 0% ü - - - 0%
Other Income - - - 0% ü - - - 0%
Other Income - - - 0% ü - - - 0%
Other Income - - - 0% ü - - - 0%
Other Income - - - 0% ü - - - 0%
Other Income - - - 0% ü - - - 0%

Total Income 1,295 1,650 (355) -22% û 2,470 3,177 (707) -22%

Expenses
Administration Costs 150 200 50 25% ü 350 400 50 13%
Advocacy 90 100 10 10% ü 190 200 10 5%
Audit Fees 3 3 - 0% ü 6 6 - 0%
Depreciation 150 200 50 25% ü 350 400 50 13%
Interest Charges 150 200 50 25% ü 350 400 50 13%
Programs and Training Courses 150 200 50 25% ü 350 400 50 13%
Talent Development 90 100 10 10% ü 190 200 10 5%
Monthly Financial Report : Example Sporting Organisation [ inser
Event Costs 3 3 - 0% ü 6 6 - 0%
Other 150 200 50 25% ü 350 400 50 13%
Other 90 100 10 10% ü 190 200 10 5%
Other 3 3 - 0% ü 6 6 - 0%
Other - 6 6 100% ü - 12 12 100%
Other - - - 0% ü - - - 0%
Other - - - 0% ü - - - 0%
Other - - - 0% ü - - - 0%
Other - - - 0% ü - - - 0%
Other - - - 0% ü - - - 0%
Other - - - 0% ü - - - 0%
Other - - - 0% ü - - - 0%
Other - - - 0% ü - - - 0%
Other - - - 0% ü - - - 0%

Total Expenses 1,029 1,315 286 22% ü 2,338 2,630 292 11%

Net Surplus / (Deficit) 266 335 (69) -21% û 132 547 (415) -76%

Variance Explanations and Commentary

Grants (Secured) - secured grant income was incorrectly budgeted for in the current month based on contracts in place at the beginning of the year. Likely to be as budgeted for the r
Program and Training courses - unexepcted costs incurred due to having to rewrite manuals for rule changes
Monthly Financial Report : Example Sporting Organisation [ inser

Total Income - Actual v Budget Total Expenses

$2,000 $3,000
$1,800
$1,600 $2,500
$1,400 $2,000
$1,200 Actual
Budget
$1,000 $1,500
$800
$1,000
$600
$400 $500
$200
$- $-
Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-1

Net Profit - Actual v Budget Total Grant Income - Actual v Budget

$400 $1,400

$200 $1,200
$- $1,000
Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15
-$200 Actual $800
Budget
-$400
$600
-$600
$400
-$800
$200
-$1,000

-$1,200 $-
Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15

Unsecured Sponsorship Income Profit Forecast

$160
$140 $2,623
$3,000
$2,208
$120 $2,500
 Unsecured Sponsorship Income Profit Forecast
Monthly Financial Report : Example Sporting Organisation [ inser
$160
$140 $2,623
$3,000
$2,208
$120 $2,500
$100 Actual $2,000
Budget $1,500
$80
$60 $1,000
$500
$40
$-
$20 YTD Actual + Remaining Budget Original Full Year Budget Latest F

$-
Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15

Unsecured Income Status

Remaining Unsecured Budgeted Income $ 2,000

$2,400
Year to Date Unsecured Income Received $ 450 $2,500

$ 400 $2,000
Year to Date Unsecured Income (Budget)
$1,500
YTD Variance against budget $ 50
$1,000 $450
$500

Percentage of full year budgeted unsecured income received: 18.75% $-

Total unsecured income required to meet full year budget: $ 1,950

Latest estimate of unsecured income for remainder of year: 1,160
Expected full year surplus/shortfall: -$ 790

Sponsorship Income Grant Funding

$3,000 $12,000

$2,500 $10,000

$2,000 $8,000
Budgeted
Confirmed
 $2,500 $10,000
Monthly Financial Report : Example Sporting Organisation [ inser
$2,000 $8,000
Budgeted
Confirmed
$1,500 Forecast $6,000

$1,000 $4,000

$500 $2,000

$- $-
Jul-14 Sep-14 Nov-14 Jan-15 Mar-15 May-15 Jul-14 Sep-14 Nov-14 Jan-15 Mar-15 May-

Unsecured Revenue, Grant and Sponsorship Commentary

Enter Commentary

Summary Statement of Financial Position Aug-14

Days Covered by Net Liquid Assets
Actual
90
80
Current Assets 2,581 70
Current Liabilities 1,280 60
Working Capital 1,301 50
40
30
Fixed and Long Term Assets 220 20
Term Liabilities 55 10
0
Jul-14 Sep-14 Nov-14 Jan-15 Mar-15 May-15
 20
Monthly Financial Report : Example Sporting Organisation 10
[ inser
0
Jul-14 Sep-14 Nov-14 Jan-15 Mar-15 May-15
Equity 1,466

Receivables Aging Profile

100%
Ratios and Analysis Actual Target Variance
80%
Working Capital Ratio 2.02 1.10 0.92
60%
40%
$ %
20%
Overdue Receivables 350 28.00% 15.00% -13.00%
170 14.53% 5.00% -9.53% 0%
Overdue Payables Jul-14 Sep-14 Nov-14 Jan-15 Mar-15 May-15

Cashflow Budget, Actual and Forecast

$1,400
Payables Aging Profile
$1,200 100%
$1,000 80%
Budget
$800 60%
Actual
$600 Latest Forecast 40%
$400 20%
$200 0%
Jul-14 Sep-14 Nov-14 Jan-15 Mar-15 May-15
$-
Jul-14 Sep-14 Nov-14 Jan-15 Mar-15 May-15
-$200

Variance Explanations and Commentary

Divisional Results
Monthly Financial Report : Example Sporting Organisation [ inser
Current Month Year to Date

Division 1 Actual Budget Variance Actual Budget Variance

Income 10 8 2 60 16 44
Expenses 5 5 - 28 10 18
Surplus (Deficit) 5 3 2 32 6 26

Division 2 Actual Budget Variance Actual Budget Variance

Income 10 7 3 65 14 51
Surplus (Deficit) 5 5 - 27 10 17
Surplus 5 2 3 38 4 34

Division 3 Actual Budget Variance Actual Budget Variance

Income 10 9 1 58 18 40
Expenses 5 5 - 26 10 16
Surplus (Deficit) 5 4 1 32 8 24

Division 4 Actual Budget Variance Actual Budget Variance

Income 10 10 - 57 20 37
Expenses 5 5 - 25 10 15
Surplus (Deficit) 5 5 - 32 10 22

Division 5 Actual Budget Variance Actual Budget Variance Income down on budget due to planned init
Costs will reduce going forward now that th
Income 10 20 (10) 56 40 16 hold indefinitely.
Expenses 5 5 - 24 10 14
Surplus (Deficit) 5 15 (10) 32 30 2

YTD Net Profit By Division

$40
$35
$30
$25
$20
 $35
Monthly$30
Financial Report : Example Sporting Organisation [ inser
$25
$20
$15
$10
$5
$-
Division 1 Division 2 Division 3 Division 4 Division 5
[ insert logo here]

YTD plus
Remaining Budget

ü 1,215
û 1,130
ü 1,225
û 9,526
ü 1,225
û 1,130
ü 1,225
û 1,020
ü -
ü -
ü -
ü -
ü -
ü -

û 17,696

ü 2,350
ü 1,190
ü 36
ü 2,350
ü 2,350
ü 2,350
ü 1,190
 [ insert logo here]
ü 36
ü 2,350
ü 1,190
ü 36
ü 60
ü -
ü -
ü -
ü -
ü -
ü -
ü -
ü -
ü -

ü 15,488

û 2,208

on contracts in place at the beginning of the year. Likely to be as budgeted for the rest of the year.
e changes
 [ insert logo here]

Total Expenses
$3,000

$2,500

$2,000
Actual
Budget
$1,500

$1,000

$500

$-
Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15

Total Grant Income - Actual v Budget

$1,400

$1,200

$1,000

$800 Actual
Budget

$600

$400

$200

$-
Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15

Profit Forecast

$2,623
$3,000
$2,208
$2,500
 Profit Forecast
[ insert logo here]
$2,623
$3,000
$2,208
$2,500
$2,000
$1,500
$1,000
$124
$500
$-
YTD Actual + Remaining Budget Original Full Year Budget Latest Full Year Forecast

Unsecured Income Status

$2,400
$2,500
$1,610
$2,000
$1,500
$1,000 $450
$500
$-

Grant Funding
$12,000

$10,000

$8,000
Budgeted
Confirmed
$10,000
[ insert logo here]
$8,000
Budgeted
Confirmed
$6,000 Forecast

$4,000

$2,000

$-
Jul-14 Sep-14 Nov-14 Jan-15 Mar-15 May-15

Days Covered by Net Liquid Assets

90
80
70
60 Days Cover
50
40
30 Target Days
20
10
0
Jul-14 Sep-14 Nov-14 Jan-15 Mar-15 May-15
 Target Days
20
10
0
[ insert logo here]
Jul-14 Sep-14 Nov-14 Jan-15 Mar-15 May-15

Receivables Aging Profile

100%
80% Three months or
more overdue
60%
Two months
40% overdue
20% One month
overdue
0%
Jul-14 Sep-14 Nov-14 Jan-15 Mar-15 May-15
Current

Payables Aging Profile

100%
80% Three months or
more overdue
60%
Two months
40% overdue
20%
One month overdue
0%
Jul-14 Sep-14 Nov-14 Jan-15 Mar-15 May-15
Current
 [ insert logo here]

Income down on budget due to planned initiative not taking place.

Costs will reduce going forward now that the project has been put on
hold indefinitely.

Profit By Division

Actual
Budget
Variance
 [ insert logo here]Actual
Budget
Variance

on 3 Division 4 Division 5
Monthly Non Financial Measures: Example Sporting Organisation
Human Capital KPIs Note: Enter data only in the cells coloured:

Employee Retention (% of total FTE Staff)

Jul 14 Aug 14 Sep 14 Oct 14 Nov 14 Dec 14 Jan 15 Feb 15 Mar 15 Apr 15
Total number of Staff 42 38 38 38 42
Total Staff Retention Rate 100.00% 91.00% 91.00% 91.00% 91.00%
Target Retention Rate 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%

Unplanned Absenteeism (Days)

Jul 14 Aug 14 Sep 14 Oct 14 Nov 14 Dec 14 Jan 15 Feb 15 Mar 15 Apr 15
Operational Staff 2 2 2 8 2
Administration Staff 2 2 6 2 2
Target Unplanned Absenteeism - - - - - - - - - -

Employee Hours Spent on Training and Development

Jul 14 Aug 14 Sep 14 Oct 14 Nov 14 Dec 14 Jan 15 Feb 15 Mar 15 Apr 15
Training Hours 10 10 10 10 10
Targeted Training Hours 15 15 15 15 15 15 15 15 15 15

Environmental

Electricity and Power Consumption (kWh of energy)

Jul 14 Aug 14 Sep 14 Oct 14 Nov 14 Dec 14 Jan 15 Feb 15 Mar 15 Apr 15
Current Year Actual 1,100 1,000 950 1,500 1,000
Current Year Target 1,200 1,300 1,150 1,200 952 900 900 900 900 900
Monthly Non Financial Measures: Example Sporting Organisation
Prior Year Usage 1,300 1,300 1,300 1,300 1,300 1,300 1,300 1,300 1,300 1,300
Variance on Prior Year (200) (300) (350) 200 (300) - - - - -
YTD Variance on Prior Year (200) (500) (850) (650) (950) (950) (950) (950) (950) (950)

Water Usage (m³ usage per day)

Jul 14 Aug 14 Sep 14 Oct 14 Nov 14 Dec 14 Jan 15 Feb 15 Mar 15 Apr 15
Current Year Actual 55 55 45 45 20
Current Year Target 40 40 40 40 40 40 40 40 40 40
Prior Year Usage 50 50 50 50 50 50 50 50 50 50
Variance on Prior Year 5 5 (5) (5) (30) - - - - -
YTD Variance on Prior Year 5 10 5 - (30) (30) (30) (30) (30) (30)

Plastic Rubbish (kg)

Jul 14 Aug 14 Sep 14 Oct 14 Nov 14 Dec 14 Jan 15 Feb 15 Mar 15 Apr 15
Current Year Actual 120 115 150 115 95
Current Year Target 120 120 120 120 120 120 120 120 120 120
Prior Year Usage 110 110 110 110 110 110 110 110 110 110
Variance on Prior Year 10 5 40 5 (15) - - - - -
YTD Variance on Prior Year 10 15 55 60 45 45 45 45 45 45
 [ insert logo here]

May 15 Jun 15

100.00% 100.00%

May 15 Jun 15

- -

May 15 Jun 15 Year to Date

50
15 15 180

May 15 Jun 15 Target

900 900
 [ insert logo here]
1,300 1,300
- -
(950) (950)

May 15 Jun 15

40 40
50 50
- -
(30) (30)

May 15 Jun 15

120 120
110 110
- -
45 45
Financial Summary for This Month : Example Sporting Organisation Note: Enter data only in the cells coloured:

Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15

Financial Performance - Actual

Income
Membership Fees 115 100 95 109 100
Sponsorship Income (Secured) 50 80 120 75 150
Sponsorship Income (Unsecured) 150 75 60 110 100
Grants (Secured) 500 800 1,200 750 1,100
Grants (Unsecured) 150 75 60 110 100
Event Income 50 80 120 75 150
Other Income 150 75 60 110 100
Other Income 10 10 10 10 10
Other Income - - - - -
Other Income - - - - -
Other Income - - - - -
Other Income - - - - -
Other Income - - - - -
Other Income - - - - -
Total Income 1,175 1,295 1,725 1,349 1,810 - - - -

Expenses
Administration Costs 200 150 175 220 190
Advocacy 100 90 250 30 10
Audit Fees 3 3 3 3 3
Depreciation 200 150 175 220 190
Interest Charges 200 150 175 220 190
Programs and Training Courses 200 150 175 220 2,100
Talent Development 100 90 250 30 10
Event Costs 3 3 3 3 3
Other 200 150 175 220 190
Other 100 90 250 30 10
Other 3 3 3 3 3
Other - - - - -
Financial Summary for This Month : Example Sporting Organisation Note: Enter data only in the cells coloured:

Other - - - - -
Other - - - - -
Other - - - - -
Other - - - - -
Other - - - - -
Other - - - - -
Other - - - - -
Other - - - - -
Other - - - - -
1,309 1,029 1,634 1,199 2,899 - - - -

Net Surplus / (Deficit) (134) 266 91 150 (1,089) - - - -

Financial Position - Actual Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15

Current Assets
Cash at Bank/(Bank Overdraft) 1,130 1,160 1,010 1,180 1,120
Inventory 20 20 20 20 20
Accounts Receivable 1,200 1,396 1,445 1,497 418
GST Receivable - - - - -
Other Current Assets 5 5 5 5 5
Other Current Assets - - - - -
Other Current Assets - - - - -
Other Current Assets - - - - -
Other Current Assets - - - - -
2,355 2,581 2,480 2,702 1,563 - - - -
Current Liabilities
Accounts Payable 1,200 1,170 978 1,050 1,200
GST Payable 50 50 50 50 50
Income Received in Advance 50 50 50 50 50
Other Current Liabilities 10 10 10 10 10
Other Current Liabilities - - - - -
Other Current Liabilities - - - - -
Financial Summary for This Month : Example Sporting Organisation Note: Enter data only in the cells coloured:

Other Current Liabilities - - - - -

Other Current Liabilities - - - - -
Other Current Liabilities - - - - -
1,310 1,280 1,088 1,160 1,310 - - - -

Working Capital 1,045 1,301 1,392 1,542 253 - - - -

Fixed Assets and Long Term Investments

Plant and Equipment 100 110 110 110 260
Intangible Assets 100 100 100 100 100
Other 10 10 10 10 10
Other - - - - -
Other - - - - -
Other - - - - -
Other - - - - -
210 220 220 220 370 - - - -
Term Liabilities
Bank Debt 50 50 50 50 50
Other 5 5 5 5 5
Other - - - - -
Other - - - - -
Other - - - - -
Other - - - - -
55 55 55 55 55 - - - -

Equity 1,200 1,466 1,557 1,707 568 - - - -

Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15

Receivables Aging
Current 900 900 900 900 1,200
One month overdue 100 100 100 75 100
Two months overdue 100 100 100 - 50
Three months or more overdue 100 150 - - 50
1,200 1,250 1,100 975 1,400 - - - -
Check Total Check Total Check Total Check Total
Financial Summary for This Month : Example Sporting Organisation Note: Enter data only in the cells coloured:

Payables Aging
Current 1,000 1,000 900 800 1,100
One month overdue 200 70 50 100 100
Two months overdue - 100 28 100 -
Three months or more overdue - - - 50 -
1,200 1,170 978 1,050 1,200 - - - -

Financial Performance - Budget Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15

Income
Membership Fees 100 100 100 100 100 100 100 100 100
Sponsorship Income (Secured) 100 100 100 100 100 100 100 100 100
Sponsorship Income (Unsecured) 100 100 100 100 100 100 100 100 100
Grants (Secured) 827 950 776 800 800 1,000 850 800 800
Grants (Unsecured) 100 100 100 100 100 100 100 100 100
Event Income 100 100 100 100 100 100 100 100 100
Other Income 100 100 100 100 100 100 100 100 100
Other Income 100 100 100 100 100 100 100 100 100
Other Income - - - - - - - - -
Other Income - - - - - - - - -
Other Income - - - - - - - - -
Other Income - - - - - - - - -
Other Income - - - - - - - - -
Other Income - - - - - - - - -
Other Income - - - - - - - - -
Total Income 1,527 1,650 1,476 1,500 1,500 1,700 1,550 1,500 1,500

Expenses
Administration Costs 200 200 200 200 200 200 200 200 200
Advocacy 100 100 100 100 100 100 100 100 100
Audit Fees 3 3 3 3 3 3 3 3 3
Depreciation 200 200 200 200 200 200 200 200 200
Financial Summary for This Month : Example Sporting Organisation Note: Enter data only in the cells coloured:

Interest Charges 200 200 200 200 200 200 200 200 200
Programs and Training Courses 200 200 200 200 200 200 200 200 200
Talent Development 100 100 100 100 100 100 100 100 100
Event Costs 3 3 3 3 3 3 3 3 3
Other 200 200 200 200 200 200 200 200 200
Other 100 100 100 100 100 100 100 100 100
Other 3 3 3 3 3 3 3 3 3
Other 6 6 6 6 6 6 6 6 6
Other - - - - - - - - -
Other - - - - - - - - -
Other - - - - - - - - -
Other - - - - - - - - -
Other - - - - - - - - -
Other - - - - - - - - -
Other - - - - - - - - -
Other - - - - - - - - -
Other - - - - - - - - -
Total Expenses 1,315 1,315 1,315 1,315 1,315 1,315 1,315 1,315 1,315

Net Surplus / (Deficit) 212 335 161 185 185 385 235 185 185

Cash Position and Requirements Forecast Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15

Budgeted Month End Cash Balance 120 100 (30) 100 120 90 60 90 85
Actual Month End Cash Balance 1,130 1,160 1,010 1,180 1,120 - - - -
Variance 1,010 1,060 1,040 1,080 1,000 1,000 1,000 1,000 1,000

Latest Projected Cash Position 1,130 1,160 1,010 1,180 1,120 1,090 1,060 1,090 1,085

Actual Month End Cash Position 1,130 1,160 1,010 1,180 1,120 - - - -
Short Term Cash Requirement 120 120 120 120 120
Cash Reserves/(Shortfall) 1,010 1,040 890 1,060 1,000 - - - -
Financial Summary for This Month : Example Sporting Organisation Note: Enter data only in the cells coloured:

Financial Performance Forecast Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15

Budgeted Surplus (Deficit) 212 335 161 185 185 385 235 185 185
Actual Surplus (134) 266 91 150 (1,089) - - - -
Latest Forecast Surplus (134) 266 91 150 (1,089) 550 100 30 50

Financial Position - Targets Annual

Working Capital Ratio Target 1.10 (Your target ratio of current assets to current liabilities)
Current Receivables Target 85.00% (Percentage of total Accounts Receivables expected to be paid on time rather than being overdue)
Current Payables Target 95.00% (Percentage of total Accounts Payable expected to be paid on time rather than being paid late)
Days Covered by Liquid Assets 90 (Benchmark days operating expenditure covered by net liquid assets)

Divisional Reporting - Actual Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15

Division 1

Income 10 10 10 10 20
Expenses 5 5 5 5 8
Surplus (Deficit) 5 5 5 5 12 - - - -

Division 2

Income 10 10 10 10 25
Surplus (Deficit) 5 5 5 5 7
Surplus 5 5 5 5 18 - - - -

Division 3

Income 10 10 10 10 18
Financial Summary for This Month : Example Sporting Organisation Note: Enter data only in the cells coloured:

Expenses 5 5 5 5 6
Surplus (Deficit) 5 5 5 5 12 - - - -

Division 4

Income 10 10 10 10 17
Expenses 5 5 5 5 5
Surplus (Deficit) 5 5 5 5 12 - - - -

Division 5

Income 10 10 10 10 16
Expenses 5 5 5 5 4
Surplus (Deficit) 5 5 5 5 12 - - - -

Divisional Reporting - Budget Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15

Division 1

Income 8 8 8 8 12 8 8 8 8
Expenses 5 5 5 5 5 5 5 5 5
Surplus (Deficit) 3 3 3 3 7 3 3 3 3

Division 2

Income 7 7 7 7 11 7 7 7 7
Expenses 5 5 5 5 5 5 5 5 5
Surplus (Deficit) 2 2 2 2 6 2 2 2 2

Division 3

Income 9 9 9 9 10 9 9 9 9
Financial Summary for This Month : Example Sporting Organisation Note: Enter data only in the cells coloured:

Expenses 5 5 5 5 5 5 5 5 5
Surplus (Deficit) 4 4 4 4 5 4 4 4 4

Division 4

Income 10 10 10 10 9 10 10 10 10
Expenses 5 5 5 5 5 5 5 5 5
Surplus (Deficit) 5 5 5 5 4 5 5 5 5

Division 5

Income 20 20 20 20 20 11 11 11 11
Expenses 5 5 5 5 5 5 5 5 5
Surplus (Deficit) 15 15 15 15 15 6 6 6 6

Grant Funding Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15

Budgeted YTD Total Grant Funding 927 1,977 2,853 3,753 4,653 5,753 6,703 7,603 8,503
Confirmed Total Grant Funding 650 1,525 2,785 3,645 4,845 4,845 4,845 4,845 4,845
Projected Total Grant Funding 650 1,525 2,785 3,645 4,845 5,500 6,200 6,800 7,000

Sponsorship Funding

Budgeted YTD Total Sponsorship Funding 200 400 600 800 1,000 1,200 1,400 1,600 1,800
Confirmed Total Sponsorship Funding 200 355 535 720 970 970 970 970 970
Projected Total Sponsorship Funding 200 355 535 720 970 1,300 1,450 1,680 1,890
Apr-15 May-15 Jun-15 Total

519
475
495
4,350
495
475
495
50
-
-
-
-
-
-
- - - 7,354

935
480
15
935
935
2,845
480
15
935
480
15
-
 -
-

-
-
-
-
-
- - - 8,070

- - - (716)

Apr-15 May-15 Jun-15

- - -
 - - -

- - -

- - -

- - -

- - -

Mar-15 Apr-15 May-15 Jun-15

- - -
 - - -

Apr-15 May-15 Jun-15 Total

100 100 100 1,200

100 100 100 1,200
100 100 100 1,200
800 800 800 10,003
100 100 100 1,200
100 100 100 1,200
100 100 100 1,200
100 100 100 1,200
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
1,500 1,500 1,500 18,403

200 200 200 2,400

100 100 100 1,200
3 3 3 36
200 200 200 2,400
 200 200 200 2,400
200 200 200 2,400
100 100 100 1,200
3 3 3 36
200 200 200 2,400
100 100 100 1,200
3 3 3 36
6 6 6 72
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
1,315 1,315 1,315 15,780

185 185 185 2,623

Apr-15 May-15 Jun-15

110 70 65
- - -
1,000 1,000 1,000

1,110 1,070 1,065

- - -

- - -
Apr-15 May-15 Jun-15 Total

185 185 185 2,623

- - - (716)
30 30 50 124

Apr-15 May-15 Jun-15 Total

60
28
- - - 32

65
27
- - - 38

58
 26
- - - 32

57
25
- - - 32

56
24
- - - 32

Apr-15 May-15 Jun-15 Total

8 8 8 100
5 5 5 60
3 3 3 40

7 7 7 88
5 5 5 60
2 2 2 28

9 9 9 109
 5 5 5 60
4 4 4 49

10 10 10 119
5 5 5 60
5 5 5 59

11 11 11 177
5 5 5 60
6 6 6 117

Apr-15 May-15 Jun-15

9,403 10,303 11,203

4,845 4,845 4,845
8,000 8,500 9,500

2,000 2,200 2,400

970 970 970
2,200 2,400 2,800