270 likes | 289 Views
TCA Implementation - 2007/08 FS Note Disclosure - Data up to March 31,2007 - 7 month period (Sep 08 - Mar 09) - 12 month period (Sep 08 - Aug 09) - Revisions to TCA guide. PUT TITLE HERE.
E N D
TCA Implementation - 2007/08 FS Note Disclosure - Data up to March 31,2007 - 7 month period (Sep 08 - Mar 09) - 12 month period (Sep 08 - Aug 09) - Revisions to TCA guide PUT TITLE HERE Information Session for School Board Finance Staff and External Auditors Transfer Payments & Financial Reporting Branch Fall 2008
PUT TITLE HERE 2007-08 Financial Statement Note Disclosure
TANGIBLE CAPITAL ASSET NOTE DISCLOSURE • Public Sector Handbook Section PS 3150 requires boards to report for fiscal years beginning on or after January 1, 2009: • Historical cost • Accumulated Amortization of tangible capital assets • PSG-7 requires government to disclose information on tangible capital asset information that is available during the transitional period
TCA CONTINUITY SCHEDULE • Schedule ? in EFIS summarizes information required to be disclosed in the notes to financial statements • Schedule has two sections: • Land and Building Assets • Other Tangible Capital Assets • Schedule does not have to be audited
LAND AND BUILDINGS • Information is preloaded using the information submitted to the Ministry in the 5 and 7 Month Capital Activity Excel files beginning March 2005 to March 2008
OTHER TANGIBLE CAPITAL ASSETS • Includes Furniture, Equipment, Computers, and Vehicles • Boards can complete this schedule and disclose information if it is available • Boards are not required to disclose this information in the 2007-08 Financial Statements if it is not available; however this information will be required for 2008-09
EXAMPLE • Gross Book Value Section: • Combine “Additions” and “Transfers” columns from EFIS schedule and include in “Additions” Column in the note schedule • Amortization Section: • Combine “Write-offs & Adjustments” and “Disposals” columns from EFIS schedule and include in the “Disposals, Write-offs, & Adjustments” column in the note schedule • Disclose assets Permanently Removed from Service and Write-Offs separately
PUT TITLE HERE TCA Implementation - Review of Data Up to March 31, 2007
Data • What is it? • March 31, 2005 to March 31, 2007 • Data output from BVC (as of March 31, 2005) + following data collection periods: • April 2005 to August 2005 • September 2005 to March 2006 • April 2006 to August 2006 • September 2006 to March 2007 • Buildings, portables, land and land improvements • Different tabs for each asset type (does not include CIP, PAC/PCC) • Where is it ? • EFIS • Go to submission….Reports….Static Reports • March 31, 2005 to March 31, 2007 Capital Asset Data
Where to start ? • Access file • Manipulate data to suit you • Excel File contains 10 tabs 1) Buildings & Land Definitions 2) Portables Definitions 3) Buildings & Land Input File 4) Portables Input File 5) Buildings & Land Output File 6) Portables Output File 7) Buildings Continuity 8) Land Continuity 9) Land Improvement Continuity 10) Portables Continuity Input into BVC Output from BVC Calculations will be provided shortly
Where to Focus Land Buildings Portables Land Improvements Land Buildings Portables Data at March 31, 2007 BVC Input BVC Output Excel Data =
Where to Focus Land Buildings Portables BVC Input • Year of purchase • GFA • Building condition • Cost • Portables: • Year of manufacture • GFA
Where to Focus BVC Output Don’t Audit the Black Box Don’t try to replicate the values X
Where to Focus Land Buildings Portables Land Improvements Excel Data • Additions / disposals by cycle • Ask auditors what additional work they will require • Get together back-up
Where to Focus FOR REASONABLENESS Data at March 31, 2007 • Contact Ministry: • Look at groups of assets, not one at a time • Form for missed assets • Asset Type • RSL • GBV • AA MISTAKES
Where to Focus Land Buildings Portables Land Improvements Land Buildings Portables Data at March 31, 2007 BVC Input BVC Output Excel Data = X • Asset Type • RSL • GBV • AA • Additions / disposals by cycle • Ask auditors what additional work they will require • Year of purchase • GFA • Building condition • Portables: • Year of manufacture • GFA FOR REASONABLENESS
Additional Information • For additional information, please refer to the following website: http://tpfr.edu.gov.on.ca/CAImplementation.htm • Contact: Sangita Barman 416-325-858 sangita.barman@ontario.ca
PUT TITLE HERE 7 Month Period (September 2008 – March 2009)
REPORTING REQUIREMENTS • Paragraph .13 of Asset Guide we indicated that the last period that we would be collecting capital asset information from boards is April – August 2008 period • Amending this paragraph as we will be asking board to complete a 7 Month Capital Activity Report for the September 2008 to March 2009 period
SUBMISSION REQUIREMENTS • No change • Require: • Specified Procedures • 7 Month Excel Capital Activity Report • Due Date: May 15, 2009
PUT TITLE HERE 12 Month Period (September 2008 – August 2009)
Tangible Capital Asset Data Collection • Ministry will be collecting summarized tangible capital asset information from school boards in order to support their continuity schedules • File Format: • Pipe Delimited File • Require details on an asset by asset basis • This file will be uploaded into EFIS • Details being discussed by the Ministry: • Process of assigning of new asset id numbers to assets
PUT TITLE HERE Revisions to TCA Guide
FIRST TIME EQUIPPING ASSET CLASS • In Appendix C of the Asset Guide (page 51 of 81 – May 2008 Release) we stated that: • “First time equipping costs should NOT include computer hardware and computer software, excluding those in the classroom.” • Amending this to state that: • “First time equipping costs should NOT include computer hardware and computer software.”
LEASEHOLD IMPROVEMENTS • Paragraph .236 we state that: • “Betterments made to an asset subject to a capital lease where ownership is expected to transfer to the lessee, should be classified as betterments. The cost of the betterments must be capitalized as part of the cost of the tangible capital asset and amortized over the lease term.”
LEASEHOLD IMPROVEMENTS • Amending this paragraph to state: • “Betterments made to an asset subject to a capital lease where ownership is expected to transfer to the lessee, should be classified as betterments. The cost of the betterments must be capitalized as part of the cost of the tangible capital asset and amortized over the useful life of the asset.”
QUESTIONS Sangita Barman 416-325-8584 Sangita.barman@ontario.ca