Get documents about "Producer Recording Contract
W
Description
Producer Recording Contract document sample
Document Sample
This Financial Reporting Template is for reporting financial information required under your
funding agreement with the Australia Council and/or your State or Territory funding body.
Please complete this spreadsheet and return it to your Program Manager via e-mail by: 13
June 2008
PURPOSE OF THE TEMPLATE:
The template records your organisation's financial data over a three-year period:
Actual figures (audited data) for the previous year
Estimated figures for the current year
Budget forecast figures for the next year
WHAT DOES THIS TEMPLATE CONTAIN?
The template consists of six worksheets. To go to each worksheet either click on the appropriate tab at the
bottom of the screen or click on the heading below.
1• YOUR REPORT INFORMATION
2• INCOME
3• EXPENDITURE
4• BALANCE SHEET
5• SUMMARY
6• CORE COSTS
Plus PROJECT SPREADSHEETS which are generated by the CORE COSTS sheet
HOW TO COMPLETE THE VARIOUS WORKSHEETS ON THIS TEMPLATE:
1. YOUR REPORT INFORMATION:
On this sheet you record the following: (enter the information in the white cells on this worksheet)
The name of the State or Territory Arts Funding Body from which you receive funding (if applicable)
The name of the Australia Council board or committee from which you receive funding
The name of your organisation
The date of the most recent audited financial year (usually 30 June or 31 December)
Whether the report is for the entire organisation or the arts program only
2. INCOME
Enter figures for each relevant income category and for each year. Yellow coloured cells will sum
automatically. Entries for the forthcoming budget year will be automatically calculated from the figures in the
CORE COSTS sheet and your PROJECT sheets.
3. EXPENDITURE
Enter figures for each relevant expenditure category and for each year. Yellow coloured cells will sum
automatically. Entries for the forthcoming budget year will be automatically calculated from the figures in the
CORE COSTS sheet and your PROJECT sheets.
4. BALANCE SHEET
Enter figures for each relevant balance sheet entry, for each year. Yellow coloured cells will sum
automatically.
The Net Assets figures in each separate year should match. To ensure this, adjust your balance sheet figures
for the current and next years.
5. SUMMARY
The figures on this page will sum automatically. You do not have to enter data on this page.
6. CORE COSTS
This sheet, in addition to your individual project sheets, will provide the details for the forthcoming budget year.
Figures entered here, and on the project page, will sum automatically on the INCOME and EXPENDITURE
sheets.
USE the CORE COSTS page to enter budget details for your CORE or ADMINISTRATION costs for the
forthcoming year.
Then click on the 'Add Worksheet for Project 1 ' button. This will insert a new worksheet for your first project
(titled 'Project 1').
Use the Project 1 page to enter budget details for the first project or production your organisation is
undertaking in the next year.
Enter the name of each project in the white cell at the top of the worksheet.
Enter figures in each relevant income and expenditure category. Yellow coloured cells will sum automatically.
To enter details for your next project, click on the button titled 'Add Worksheet for Project 2 '. This will add
another worksheet. Repeat for each project your organisation is undertaking in the forthcoming year.
When completed, please email this Financial Reporting Template to your program manager.
e9de5420-aa0d-470e-82cf-d89ea292d35a.xls 1. YOUR REPORT INFORMATION
Enter the name of your State / Terr Funding Agency:
(choose from the drop down list)
Arts SA
Enter the name of the relevant Australia Council
Board or Section: (choose from the drop down list)
Other
Enter the name of your organisation:
The organisation's most recent audit was for the
30 June
year ending:
The financial information and budget is for: (choose
Entire organisation
from the drop down list)
7/11/2011 3:19 PM 1. YOUR REPORT INFORMATION Page 2
e9de5420-aa0d-470e-82cf-d89ea292d35a.xls 2. INCOME
: Income Budget
Enter figures for each relevant income category and for each year. 2007 2008 2009
Yellow coloured cells will sum automatically. Entries for the Actuals Revised Total Budget
forthcoming budget year will be automatically calculated from the Estimates
figures in the CORE COSTS sheet and your PROJECT sheets.
Earned Income
Audience Sales Box Office & Entry Fees - -
Contract / co-producer fees - -
Recording B/cast Fees -
Fees & Services Participants / Workshop Fees -
Admin and Management Fees -
Consultancies and Commissions -
Membership Fees -
Merchandising and Retail Publication/Program Sales -
Sales -
Beverage & Food sales -
Resources Income Venue Hire -
Instruments & Equipment Hire -
Licensing and Royalties -
Other Usage Income -
Sub-total - - -
Sponsorship and Philanthropic Income
Sponsorship Cash - - -
Non-Cash (In-kind) - - -
Gifts and Donations - - -
Fundraising - - -
Sub-total - - -
Other Earned Income
Interest -
Reimbursements and Recoveries -
Other -
Sub-Total - - -
TOTAL NON-GRANT INCOME - - -
Grants and Subsidies
Australia Council Triennial / Annual Program Funding - - -
Project Funding - - -
Other Australia Council Funding - - -
Other Commonwealth Annual / Multi-Year - - -
Project - - -
Arts SA Annual / Multi-Year Arts Funding - - -
Project Arts Funding - - -
Non-Cash (In-Kind) Subsidy - - -
Other States Funding Annual / Multi-Year - - -
Other Project - - -
Local Government - - -
Overseas - - -
Philanthropic and Other - - -
TOTAL GRANT INCOME - - -
TOTAL INCOME - - -
7/11/2011 3:19 PM 2. INCOME Page 3
e9de5420-aa0d-470e-82cf-d89ea292d35a.xls 3. EXPENDITURE
: Expenditure Budget
Enter figures for each relevant income category and for each year. 2007 2008 2009
Yellow coloured cells will sum automatically. Entries for the forthcoming
budget year will be automatically calculated from the figures in the Actuals Revised Estimates Total Budget
CORE COSTS sheet and your PROJECT sheets.
TOTAL INCOME - - -
SALARIES, WAGES & FEES
Creative personnel / Consultants -
Performers/Artists/Artsworkers -
Production/Technical -
Management/Administrative -
Marketing/Promotion/Development -
Fees, Allowances and On-Costs -
SUBTOTAL - - -
PROGRAM, PRODUCTION, EXHIBITION & TOURING
Venue, Exhibition Space -
Equipment, Lighting and Audio Visual Costs -
Scenic, Staging and Materials -
Other Development and Creative Costs -
Travel, Freight, Bump In/Out Costs -
Other Production, Exhibition, Touring Costs -
items for non-producing/presenting organisations/activities
Conferences and Workshops -
Mentorship / Professional Development Programs -
Industry and Community Advocacy -
Community projects and programs -
Publications / Recordings / Cost of Sales -
Evaluation and Research Costs -
SUBTOTAL - - -
MARKETING, PROMOTION & DOCUMENTATION
Advertising (all media) -
Promotional material -
Website, Publications and Documentation -
Marketing and PR -
Fundraising Expenses -
Other Promotional and Marketing Costs -
SUBTOTAL - - -
INFRASTRUCTURE COSTS (ADMINISTRATION)
Office Rent and Running Costs -
Office Consumables and Resources -
Communications -
Travel -
Insurance -
Legal, Finance and Governance Costs -
Depreciation -
Sundries -
SUBTOTAL - - -
TOTAL EXPENDITURE - - -
OPERATING RESULT BEFORE ABNORMALS - - -
ABNORMALS AND ADJUSTMENTS (NETT) - -
OPERATING RESULT AFTER ABNORMALS - - -
7/11/2011 3:19 PM 3. EXPENDITURE Page 4
e9de5420-aa0d-470e-82cf-d89ea292d35a.xls 4. BALANCE SHEET
-
Balance Sheet
Enter figures for each relevant balance sheet entry, for each year. Yellow coloured cells will sum
automatically.
The Net Assets figures in each separate year should match. To ensure this, adjust your balance sheet
figures for the current and next years.
Jun 2007 Jun 2008 Jun 2009
CURRENT ASSETS Actuals Revised Estimates Budget
Cash
Receivables
Inventory and Work in Progress
Other
TOTAL CURRENT ASSETS - - -
NON-CURRENT ASSETS
Long Term Investments
Property, plant & equipment
Intangibles and Other Non-Current Assets
TOTAL NON-CURRENT ASSETS - - -
TOTAL ASSETS - - -
CURRENT LIABILITIES
Payables
Short Term Borrowings
Income received in advance
Subsidies received in advance / unexpended grants
Deposits and Funds Held in Trust
Tax and Other Withholdings
Provisions
Other Current Liabilities
TOTAL CURRENT LIABILITIES - - -
LONG-TERM LIABILITIES
Long Term Borrowings
Provisions
Other Long Term Liabilities
TOTAL LONG-TERM LIABILITIES - - -
TOTAL LIABILITIES - - -
NET ASSETS - - -
ACCUMULATED FUNDS
Reserves and designated funds - - -
Retained Surplus (Deficit) - - -
NET ASSETS - - -
7/11/2011 3:19 PM 4. BALANCE SHEET Page 5
e9de5420-aa0d-470e-82cf-d89ea292d35a.xls 5. SUMMARY
Financial Report Summary
The figures on this page will sum automatically. You do not have to enter data on this page.
Organisation 0
The basis of this financial report for is financial year ending on 30 June
The financial information and budget is for: Entire organisation
Financial Summary
Jun 2007 Jun 2008 Jun 2009
Actuals Revised Estimates Budget
Total expenditure - - -
Total Non-Grant Income - - -
Total Grant Income - - -
Operating surplus/(deficit) - - -
Accumulated Funds - - -
Financial Health Indicators
Reserves Ratio (benchmark 20%)
Working Capital (benchmark 2:1)
Earned Income as %
7/11/2011 3:19 PM 5. SUMMARY Page 6
Projects
PROJECT NAME: Core/Admin Costs
EARNED INCOME SALARIES, WAGES & FEES
Audience Sales Box Office & Entry Fees - Creative personnel / Consultants -
Contract / co-producer fees - Performers/Artists/Artsworkers -
Recording B/cast Fees - Production/Technical -
Fees & Services Participants / Workshop Fees - Management/Administrative -
Admin and Management Fees - Marketing/Promotion/Development -
Consultancies and Commissions - Fees, Allowances and On-Costs -
Membership Fees - -
Merchandising and
-
Retail Publication/Program Sales Sub-total -
Sales -
Beverage & Food sales - PROGRAM, PRODUCTION, EXHIBITION & TOURING
Resources Income Venue Hire - Venue, Exhibition Space -
Instruments & Equipment Hire - Equipment, Lighting and AV Costs -
Licensing and Royalties - Scenic, Staging and Materials -
Other Usage Income - Other Development and Creative Costs -
Sub-total - Travel, Freight, Bump In/Out Costs -
Other Production, Exhibition, Touring Costs -
SPONSORSHIP & PHILANTHROPIC INCOME items for non-producing/presenting organisations/activities
Sponsorship Cash - Conferences and Workshops -
Non-Cash (Contra) - Mentorship / Professional Development -
Gifts and Donations - Industry and Community Advocacy -
Fundraising - Community projects and programs -
Sub-total - Publications / Recordings / Cost of Sales -
Evaluation and Research Costs -
OTHER EARNED INCOME Sub-total -
Interest -
Reimbursements and Recoveries - MARKETING, PROMOTION & DOCUMENTATION
Other - Advertising (all media) -
Sub-Total - Promotional material -
TOTAL NON-GRANT INCOME - Website, Publications and Documentation -
-
GRANT INCOME Marketing and PR -
Australia Council Triennial / Annual Program Funding - Fundraising Expenses -
Project Funding - Other Promotional and Marketing Costs -
Other Australia Council Funding - Sub-total -
Other Commonwealth Annual / Multi-Year -
Project - INFRASTRUCTURE COSTS (ADMINISTRATION)
Arts SA Annual / Multi-Year Arts Funding - Office Rent and Running Costs -
Project Arts Funding - Office Consumables and Resources -
Non-Cash (In-Kind) Subsidy - Communications -
Other States Funding Annual / Multi-Year - Travel -
Other Project - Insurance -
Local Government - Legal, Finance and Governance Costs -
Overseas - Depreciation -
Philanthropic and Other - Sundries -
TOTAL GRANT INCOME - Sub-total -
TOTAL INCOME - TOTAL EXPENDITURE -
OPERATING RESULT BEFORE
-
ABNORMALS
ABNORMALS AND ADJUSTMENTS (NETT) -
OPERATING RESULT AFTER ABNORMALS -
