2009-10FINANCIAL STATEMENTS FORMS FOR ISOLATE BOARDS

The 2009-10 financial statements forms that are provided inExcel consist of four segments:

Schedules (1 to 23)

The schedules reflect financial information on the operations of the School Authority (Isolate Board), and include enrolment data in respect of the schools operated by the board.

Sections (1 to 19)

These sections calculate the allocations and grants entitlement of the board in accordance with the 2009-10 legislative grants regulation.

Data form E

This data form includes information used to report on how the funding allocated to the board has been used and how boards are spending in some program areas. They are an inherent part of the financial statements package and therefore have to be completed by all boards.

Appendices (B to H)

The appendices include additional supporting information relating to the financial statements and the calculation of the grant allocations. The appendices also capture certain data used by the ministry for statistical and detailed analysis purposes.

Restatement Sheets

The Restatement sheets are provided to assist boards in restating their prior year ending balances and 2009-10 budget figures to conform to PSAB reporting requirements.

An error message report is included in the package. Boards are required to clear all error messages on file before submitting their financial statements to the ministry. The application will not allow boards to submit their financial statements to the ministry where there are error messages on file.

Warning messages are to be reviewed before submission; any uncleared ones will be reviewed by Ministry Finance Officers and may be referred back to boards for adjustments and financial statement resubmission.

Boards are required to send two signed copies of:

  • Schedule 1
  • Schedule 1.1
  • Schedule 1.2
  • Schedule 1.3
  • Section 1

These forms are to be printed out from the Excel submission of the 2009-10 Financial Statements, including two copies of the audited financial statements including the auditors report and notes by December 31st, 2010 to:

Ms. Diane Strumila

Project Manager, Grant Services

Financial Analysis and Accountability Branch

17th Floor, Mowat Block, 900 Bay Street

Toronto, Ontario

M7A 1L2

Boards are required to send hard copy print-outs of their full submission.

Publication and Notice

Boards are required under S252(2) of the Education Act to publish their audited financial statements. As a minimum this would include the Consolidated Statement of Financial Position, Consolidated Statement of Operations, Consolidated Statement of Cash Flow, Consolidated Statement of Change in Net Debt, the Auditor’s report, and the notes to the financial statements. In addition boards are required to publish their annual report.

This information is the minimum to be published or made available under clauses 252(2)(a) or (b) of the Education Act; however a board may wish to publish further details.

As an alternative to publishing, a board may choose to meet the requirements of clause 252(2)(c) instead. For the purposes of this clause, a board may make the above information available to its supporters by publishing a notice in local newspaper(s). Such notice shall include the following minimum components:

-That copies of the financial statement package, auditor’s report, notes to the financial statements and the board’s annual report are available upon request,

-The board’s website address where the package etc. will be posted, and

-The school board office address and a phone number to call for requests for the information.

Where possible, the notice should state other locations where the above information may be obtained (e.g. at schools).

Boards are required to send an electronic copy of the financial statements, notes to the financial statements, Auditor’s Report and Board Annual Report as published to their Ministry Finance Officers.

Reporting under PSAB for local government

District school boards and school authorities are required to adopt Public Sector Accounting Board (PSAB) recommendations for local government as their financial standard and publish financial statements that accord with this standard. The exact presentation of these statements may vary from board to board, however, based on the individual board’s circumstances.

The Ministry of Education also requires boards to submit annual financial forms (Ministry Forms) in addition to publishing their audited financial statements. These Ministry Forms have been designed so that they accord with PSAB recommendations and provide reconciliations that comply with the funding requirements of the Education Act. Except for form of presentation, the figures in the Ministry Forms must correspond with the audited financial statements.

These instructions have been prepared to help boards and school authorities to understand how to complete the Ministry Forms.

Suggested Order of Entry

•Enrolment Schedules & Grant Sections

•Long Term Debt - Section 12

•Employee Benefits – Schedule 10G

•Tangible Capital Asset Continuity Schedule – Schedule 3C

•Detail of Accumulated Surplus/(Deficit) opening balances – Schedule 5

•Deferred Revenues – Schedule 5.1

•Operating Exp. - Schedules 10, 10ADJ, 10.1 and 10.2

•Capital Expenditures – Schedule 3

•Revenues – Schedule 9

•Restatement Forms

•Assets & Liabilities – Schedule 7

•Other Schedules – 1, 1.1, 1.2 and 1.3

•Data Form E

For user assistance on the Excel Forms, contact:

Tim Kielman

Tel: (800) 461-9570, ext. 6892

E-mail:

Summary of changes from Revised Estimates

  • The following schedules have been removed from the Financial Statements:

Schedule 2.1 – Schedule of Operating Fund

Schedule 2.2 – Schedule of Capital Fund

Schedule 2.3 – Schedule of Reserve Funds

Schedule 2.4 – Schedule of School Activities Fund

  • The following schedules have been renamed and/or modified in the Financial Statements. Some schedules were modified significantly, with a new purpose:

Schedule 1 Consolidated Statement of Financial Position

Schedule 1.1 – Consolidated Statement of Operations

Schedule 1.2 – Consolidated Statement of Cash Flow

Schedule 3 – Capital Expenditures

Schedule 5 – Detail of Accumulated Surplus/(Deficit)

Schedule 5.1 – Deferred Revenue Continuity

Schedule 7 – Detail of Consolidated Statement of Financial Position

Schedule 9 – Revenues

Schedule 10 – Expenses

Schedule 10ADJ – Adjustments for Compliance Purposes

Schedule 10.1/10.2 – Elementary/Secondary School Based Expenses

Schedule 10.3 – Textbooks, Classroom Supplies and Equipment Expenses

Schedule 10.4 – Supplementary Information on Salary and Benefit Expenses

Schedule 10A/B – Special Education Expenses – Elementary/Secondary

Schedule 10C – School Operations and Maintenance Expenses

Schedule 10F – Employee Benefits

Schedule 10G – Supplementary Information on Retirement benefits, Post-Employment Benefits, Compensated Absences and Termination Benefits

Section 1 – Summary of Allocation

  • The following schedules have been added to the Financial Statements:

Schedule 1.3 – Consolidated Statement of Change in Net Debt

Schedule 3C – Tangible Capital Asset Continuity Schedule

  • Schedule 1 – Consolidated Statement of Financial Position

The name of this form has been changed from the Statement of Financial Position, to Consolidated Statement of Financial Position. The presentation of the form has been changed to conform to public Sector Accounting Board (PSAB) section PS-1200 and guideline PSG-4with respect to the presentation of funds and reserves. As per PSG-4, paragraph 7, when a government chooses to provide information about any funds or reserves, it does so only in the notes and schedules and not on the statement of financial position. Therefore the following changes have been made.

  • The name of the difference between liabilities and financial assets (item 3) has been changed from Net Financial Asset (Liabilities), to Net Debt
  • The name of the sum of Net Debt (item 3) and Non-Financial Assets (item 4.4) has been changed from Net Assets, to Accumulated Surplus (Deficit)
  • Fund balances and Amounts to be recovered have been removed

In addition, the schedule will now include a line for Tangible Capital Assets under Non-Financial Assets (item 4.3) due to the implementation of TCA as of September 1, 2009. An additional item, Temporary investments (item 1.2) has also been added. Temporary investments are transitional orcurrent in nature, such as short-term investments made to obtain a return on a temporary basis (> 90 days and < 1 year). Due to the addition of the temporary investments account, Item 1.5 has been renamed to Long-Term Investments. Long-Term Investments are investments greater than one year from date of acquisition in organizations that do not form part of the government reporting entity.

The final addition, item 1.4 (Accounts Receivable – Government of Ontario – Approved Capital) has been added to segregate the portion of Accounts Receivable which relates to the Capital Wrap-Up.

  • Schedule 1.1 – Consolidated Statement of Operations

The name of this form has been changed from Statement of Financial Activities to Consolidated Statement of Operations. The presentation of the form has been changed to conform to public Sector Accounting Board (PSAB) sections PS-1200 and PSG-4 with respect to the presentation of funds and reserves.

As per PSG-4, paragraph 7, when a government chooses to provide information about any funds or reserves, it does so only in the notes and schedules and not on the statement of financial position. The creation of, addition to or deduction from funds and reserves does not create a revenue or expense, and would therefore not be reported on the statement of operations.

  • Schedule 1.2 – Consolidated Statement of Cash Flow

The name of this form has been changed from Statement of Financial Position to Consolidated Statement of Cash Flow. The presentation of the form has been changed to conform to public Sector Accounting Board (PSAB) sections PS-1200. Due to the presentation change, some of the terminology has changed and an additional classification has been added.

  • Item 1.1 has been changed to Annual Surplus (Deficit) which is forwarded from Schedule 1.1
  • A new item 2.1 has been created to add back the non-cash items (including amortization, write downs and gain/loss on disposal) which are now included in the Annual Surplus (Deficit)
  • New items 2.9 and 2.10 have been added to include the (increase) decreases in prepaid expenses and inventories of supplies.
  • Capital Transactions classification has been added to conform to PS-1200. New items 3.1 (Proceeds on sale of TCA) and 3.2 (Cash used to acquire TCA) have been created to include the capital cash flows.

2009-10 Actual Changes:

Two new input cells created under the 2009-10 Actuals are for Long-term liabilities issued (item 5.1) and Debt repaid and sinking fund contributions (item 5.3). In prior years these amounts were calculated however boards are required to input the balances in the current year.

See instructions below for amounts to input.

  • Schedule 1.3 – Consolidated Statement of Change in Net Debt

This form has been added to conform to public Sector Accounting Board (PSAB) sections PS-1200. Per PS1200.031, Financial statements should include a statement of financial position, a statement of operations, a statement of change in net debt, and a statement of cash flow.

The statement of change in net debt reports the acquisition of tangible capital assets in the accounting period as well as other significant (prepaid expenses and supplies inventories) items that explain the difference between the surplus or deficit for the accounting period and the change in net debt in the period. The schedule will track the Tangible Capital Asset activity as well as the other non-financial asset activity.

There is a requirement that budget comparatives be reported in this statement. However, given that this is the first year of implementation and that budget numbers are not readily available for proper disclosure, boards would not be required to report numbers under that column in theEXCEL forms.

The following schedules have been deleted to conform to Public Sector Accounting Board (PSAB) sections PS-1200 and PSG-4 with respect to the presentation of funds and reserves.

  • Schedule 2.1 – Schedule of Operating Fund
  • Schedule 2.2 – Schedule of Capital Fund
  • Schedule 2.3 – Schedule of Reserve Funds
  • Schedule 2.4 – Schedule of School Activities Fund

As per PSG-4, paragraph 7, the creation of, addition to or deduction from funds and reserves does not create a revenue or expense, and would therefore not be reported on the statement of operations. As a result, all revenues will be recorded on Schedule 9 (Revenues) and all expenses will be recorded on Schedule 10 (Expenses).

  • Schedule 3 - Capital Expenditures

The name of this form has been changed from Capital Fund – Expenditures and Financing to Capital Expenditures. The purpose of the form is to capture total capital expenditures (capitalized) incurred during the year. The schedule will help the ministry determine the capital expenditures on the different expenditure categories within the functional areas.

The summary section – Land, Buildings and Other TCA’s by Asset Class as well as columns 0.1.1 and 0.1.2 has been removed in light of information now provided in Schedule 3C.

The entire screen 2 has also been removed as funds will no longer be presented under PSAB (as per PS – 1200)

  • Schedule 3C – Tangible Capital Asset Continuity

This schedule has been revised for the full implementation of tangible capital assets reporting in the 2009-10 financial statements.

The 2009-10 forms include the following changes:

  • All cells for column ‘Adjustments to Opening Balance’ have been made available this year. This includes the adjustment to opening balances for Capital Leased Assets. This change enables boards to enter any required adjustments to the pre-populated opening balances.
  • A new column has been added to the forms in both the Cost and Accumulated Amortization screens.
  • Transfers between Asset Class – This column is used to report any transfers between Assets in Service and Assets Permanently Removed from Service. The amounts in the column should net to zero.
  • Leasehold Improvements: A new section has been added on all three screens to report assets under the Leasehold Improvement category.
  • Gains / losses are calculated from information provided in this schedule relating to disposals and proceeds of disposition.
  • Schedule 5 – Detail of Accumulated Surplus/(Deficit)

This schedule was formerly known as Reserve Funds (Internally Restricted) – Statement of Continuity. It has been deleted to conform to Public Sector Accounting Board (PSAB) sections PS-1200 and PSG-4 with respect to the presentation of funds and reserves. As per PSG-4, paragraph 7, the creation of, addition to or deduction from funds and reserves does not create a revenue or expense, and would therefore not be reported on the statement of operations. As a result, all revenues will be recorded on Schedule 9 (Revenues) and all expenses will be recorded on Schedule 10 (Expenses).

Schedule 5 will now be called Detail of Accumulated Surplus/Deficit. PS 1200, paragraph 37, requires boards to report, on their statement of financial position, their accumulated surplus or deficit. This amount is defined as the residual interest in assets after deducting liabilities.

Another way to express this is that the accumulated surplus (or deficit) is the sum of all prior annual surpluses (or deficits).

The schedule tracks the portion of the accumulated surplus/deficit that is:

(i) Available for Compliance – Unappropriated

(ii) Available for Compliance - Internally Appropriated

(iii) Unavailable for Compliance

This information is required for the determination of the board’s compliance with the BalancedBudget provision of the Education Act, section 231.(1), which is effective September 1, 2010.

  • Schedule 5.1 – Deferred Revenue Continuity

The title of this form has changed from Deferred Revenue (Externally Restricted Reserves) – Statement of Continuity, to Deferred Revenue Continuity.

Lines have been added to this schedule to have a comprehensive list of deferred revenues, under both the Operating and Capital sections (now categorized as Legislative Grants, Other Ministry of Education Grants, Other Provincial Grants and Third Party Grants). All deferred revenues are to be recorded on this schedule.

  • Schedule 7 – Detail of Consolidated Statement of Financial Position

The name of this form has changed from Statement of Assets, Liabilities and Non-Financial Assets, to Detail of Consolidated Statement of Financial Position. The presentation of the form has been changed to conform to public Sector Accounting Board (PSAB) section PS-1200.

The schedule will now include a line for Tangible Capital Assets under Non-Financial Assets (item 4.3) due to the implementation of TCA as of September 1, 2009.

The schedule will now also include a line for Temporary Investments (item 1.2). Temporary investments are transitional or current in nature, such as short-term investments made to obtain a return on a temporary basis, in government financial statements. Examples would be treasury bills or investment certificates.Temporary investments are carried on the Consolidated Statement of Financial Position at the lower of cost or market value.

Due to the addition of the temporary investments account, Item 1.4 has been renamed to Long-Term Investments. Long-Term Investments are investments greater than one year from date of acquisition in organizations that do not form part of the government reporting entity. Long-term investments are carried on the Consolidated Statement of Financial Position using the cost method.

Due to the addition of Schedule 5.2 (Accounts Receivable Continuity – Government of Ontario – Approved Capital) and the changes to Schedule 5.1 (Deferred Revenue Continuity) and Section 12 (Debt Charges), new items have been added on Schedule 7.

  • Items 1.3.4: Government of Ontario – Approved Capital item has been added to Accounts Receivable to include the balances owed from the Government of Ontario that relate to Capital. The balance is forwarded from Schedule 5.2, item 1.9, Col.3.
  • Items 2.5.4 and 2.5.5: Capital Loans and Leases are now split on Schedule 7. Capital Loans (item 2.5.4) is forwarded from Section 12, Col. 7, items 12.21.1 & 12.23 and Capital Leases is forwarded from Section 12, Col. 7, item 12.24
  • Item 2.6: Deferred Revenues are now on a single line. The amounts are being forwarded from Schedule 5.1, item 3, Col. 5
  • Schedule 9 –Revenues

The name of this form has changed from Operating Fund – Revenues to Revenues.

Since funds will no longer be presented under PSAB (as per PS – 1200), all of the operating revenues that were previously recorded in the funds (operating, capital, reserve and school activities) will now all be recorded on Schedule 9.

This schedule has been reorganized to align the headings in Schedule 9 with the summary categories presented on Schedule 1.1 (Consolidated Statement of Operations).