1 / 13

PUT TITLE HERE

PUT TITLE HERE. TCA Implementation - Review of Data. OASBO Finance Committee Workshop Transfer Payments & Financial Reporting Branch March 2008. Data. What is it? March 31, 2005 to March 31, 2007 Data output from BVC (as of March 31, 2005) + following data collection periods:

pmoton
Download Presentation

PUT TITLE HERE

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. PUT TITLE HERE TCA Implementation - Review of Data OASBO Finance Committee Workshop Transfer Payments & Financial Reporting Branch March 2008

  2. 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

  3. 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

  4. Where to Focus Land Buildings Portables Land Improvements Land Buildings Portables Data at March 31, 2007 BVC Input BVC Output Excel Data =

  5. Where to Focus Land Buildings Portables BVC Input • Year of purchase • GFA • Building condition • Cost • Portables: • Year of manufacture • GFA

  6. Where to Focus BVC Output Don’t Audit the Black Box Don’t try to replicate the values X

  7. 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

  8. 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

  9. 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

  10. Miscellaneous Items • Asset Serial Id # • PLEASE KEEP IT • Changes to RSL for Portables • Additions made to portables with 0 RSL • Ministry revised it based on $ investment amount • Immaterial for the Province • Portables - to pool or not to pool • Revisions to RSL • Data dump requests • At March • At August

  11. Changes to TCA Guide & Code of Accounts • See Handouts • School Board & School Authority TCA Guide Revisions (Release no 1) • Uniform Code of Accounts Amendments to capture Tangible Capital Asset Expenditures until full Implementation

  12. Amortization Expense Calculation • See Excel Document

More Related