Home

View User Manual - Council of Ontario Universities

1. cccceeseeeeeeeeeeeeeeeeeeeeneeeeneeseneeeenseeeneeaeenenes 35 Templates Uploading and Approving the COFO Tempilate sscssssesssesseeeeesees 36 Step 1 Getting ready to Upload the Template ccccsseeceeeeceeseeceneesenseneeneeseneeeeas 36 Step 2 Uploading the Template cccccceeceeeeeeeneeeeseeeneeceneeeasseaseseneeseneeonsesenseonees 37 Step 3 Reviewing Validation Errors and Variances cccesseeeseeeeseceneeeneeseneeeeees 40 Step 4 Correcting Validation Errors cccccccescesseseeseeeneeceneeensecenesenesceeseneeeenesoneess 42 Optional Analysis Step Variance Analysis File and Filter Function for All Tables 44 Step 5 Explaining Variances cicivcvacicvesivinsvavciersonuiniiniviveinisistaiwanwenidaiseidiineeles 48 Option 1 Enter Variance Explanations Online cccccscsseeeeeesseeeeeceenseeeseeesseeeseoensseeeseoeaes 49 Option 2 Enter Variance Explanations using Excel Upload cccsssseeecesseeeeeenseeseeenees 54 Step 6 Changing the Status to Ready for Approveal c ccscesseeeseeeeseseneeeeeeseneees 58 Step 7 Uploading the Financial Statement Reports ccccseeseeseeeeeeeeseeeneeeees 60 Step 8 Approving the COFO Template Report ccccscsesseeeseenseeeneeeeseseneseneess 62 Templates COFO Elimination Entry University Uploads ccscesssseseeeeseeese
2. c ccccssccssecceseceseeceseceneeenseseseeeeeesenees 130 Uploading the Financial Health Survey Information cccccssseeeseeeeeneeseeseseeneesenees 130 Submitting the Financial Health Survey for Approveal ccccsseecssseseneeeeeseeeeneeseeneees 133 ApPPrOVINO the NG oa we setters esrsectioens Messe EA 134 Reviewing Previous Financial Health SUDMISSIONG ccsceeeeseeeeeeeeneeeeeneeeeneesenees 135 10 Financial Health Interactive Reporting ccccscseseseeeeeeeeeeeneeeeees 136 Updated September 2014 Page 4 TGT SOLUTIONS 1 Security Security Roles Defined in the Application The following Security Roles have been defined in the application A brief description of what each of the roles can do Is provided below COU User Roles These roles appear when the ALL COU Users Only option is selected in the Institution list 1 COU Admin Access to Add any type of User to any Institution or COU Access to Unlock Users Change passwords Upload Templates Maintain the Version Control number for the Reporting Year Change the Submission status on a template upload to Verified or Not Verified Approve individually or Mass Verify the survey submissions Run Reporting processes Run the Stats Canada File Generation processes 2 COU Vendor Admin Access to view data for all institutions View Security setup View the Organization hierarchy COFO User Rol
3. Yariance o 100 00 Explanation A AI Bru E A om Variance Explanation not required E Created at 5 11 2010 10 49 4M by sysadmin OK Cancel Last modified at 5 11 2010 2 13 PM by algoma reporter Updated September 2014 Page 51 When the attach file option is selected the following page appears Click browse and go to the applicable directory on your desktop and select the file to be attached Use this page to add attachments to an iter Name Browse OK Cancel Choose file F x Look ir Sy Variances fe gt EJ T kto p My Computer File name Variances doc dp d L De ee ek Then click on OK Use this page to add attachments to an item Name EMY DocumentsVariancesVariances dac Browse OK Cancel Updated September 2014 Page 52 TGT TGT SOLUTIONS If a file has been attached and it needs to be removed for any reason click on the delete option at the bottom of the Variance Report page Variance Report Revenue Attach File 7 Spelling Test Type Revenue Reporting fear 2008 2009 Template Type COFO Template OK Cancel indicates a required field Description Revenue variance of more than 50 must be explained Table Table 2 Column H Column Heading Operating Operating General Expendable Funds Row 16 Row Heading Basic Formula Grant Current 125256 Previous 0 Variance 125256 Yariance 100 00
4. Ancillary Enterprises Institution Ryerson University Survey Status Pending The second user can still review the tabs print the current report and print the previous survey They just cannot do any updates to the survey information Updated September 2014 Page 113 TGT TGT SOLUTIONS There are three options available to navigate thru the tabs which are i Clicking on the tabs at the top of the survey page Moves to any tab li Using the Next button in the bottom right hand corner of the page Moves forward one tab iii Using the Back button in the bottom left hand corner of the page Moves back one tab Previous Survey Print General Bookstores Retail Stores Food Services Beverages Residences Conferences Seasonal Conferences Year Round Parking Printing Other Food services include meal plans whether mandatory or not cash sales catering sales vending and franchises Please include all food sales in both the fall winter and summer operations Does your Institution have Food Services to report on a Yes b No Back At the top of each of the tabs is a question that asks if your Institution has any of the related services to report on For example in the following screen shot it asks if you have Bookstores to report on If you dont then you select No and move to the next tab Print General Bookstores Retail Stores Food Services Beverages Residences Conferences Seasonal Conferences Year Rou
5. Explanation Mot Required Attachments Cry Documents Variances Variances doc E Delete lt Once an explanation has been entered for the variance click on OK to save the information When all variances have been explained the Variances Requiring Explanation on the Submit Annual Report page will show 0 Variance Checks Total Validation Errors Total Variances Download Variances Requiring Explanation Updated September 2014 Page 53 TGT SOLUTIONS Option 2 Enter Variance Explanations using Excel Upload To enter variance explanations using Excel click on the Download button beside Total Variances to download the variances to excel COFO Annual Report Submission Status Submission Status Pending Variance Checks Yes Total Validation Errors 13 Total Variances Downkad Variances Requiring Explanation Financial Statements Uploaded Do you want to open or save this file Name Algoma University ariances xls Type Microsoft Office Excel 97 2003 Worksheet 67 5KB From cousit tgtsolutions com While files from the Intemnet can be useful some files can potentially harm Your computer IF you do not trust the source do not open or save this file What s the msk The excel file will list all of the variances found for the institution as well as all of the information associated with the variance Save the file to your desktop A E T D m OO M T Test Type
6. File Download Do you want to open or save this file Name Algoma University ariances xls TH Type Microsoft Office Excel 97 2003 Worksheet 67 5KB From cousit tgtsolutions com While files from the Internet can be useful some files can potentially harm Your computer IF you do not trust the source do not open or save this file What s the nek Updated September 2014 Page 40 In addition to clicking on the download button to review the Validation Errors and Variances they can also be reviewed by navigating to the Reports menu and selecting either Validation Report or Variance Report to see the detail ifi COFO Online Reporting This ist VakdatonReport Annual Report Files COFO Online Reporting gt Validation Report Validation Report Annual Report Submission Validation Brock University Filter By Institution Title Institution W Reporting Year Template Type Descript Table Passed Brock 2010 2011 COFO Note 3 Must agree with line 5 Total on Table 9 In line 05 Total Expendable column 8 must exactly equal Table 1 State University Template Endowment column 9 so that the sum of the two columns equals zero Passed Brock 2010 2011 COFO Note 7 Line 11 Balance End of the Year must equal line 16 Table 1 State University Template Passed Brock 2010 2011 COFO Note 1 If the university maintains the detail of benefit expense for all funds the detail should be reported in the Table State Uni
7. Once this message appears you have been disconnected from the application and you will have to log back in to resume your updates It is important to note that if you had not saved your updates prior to the system timing you out you will have lost any changes that were not saved Updated September 2014 Page 29 TGT TGT SOLUTIONS 2 Templates Obtaining a copy of the current year COFO Template or Elimination Entry Template Log into the COU COFO Online Reporting Application From the Home Page go to the Documents Section and select the COFO Templates menu option The following page will appear COFO Online Reporting 4 COFO Online Reporting This List COFO Templates Submit Report Met hE COFO Online Reporting gt COFO Templates COFO Templates emplate Type emplate Version COFO Templates COFO Elimination_template_2010 11 7 28 2011 11 02 AM sysadmin Elimination Entry 2011 1 reporting year _ institution _Elimination xls Annual Report Files ER COFO_template_2010 11 7 15 2011 3 51PM sysadmin COFO Template 2011 T 1 reporting year _ institution _Report xls Reports Click on the COFO Template or the Elimination Entry file under the Name column to download and save a copy to Excel COFO Online Reporting 4 COFO Online Reporting Submit Report Ee COFO Online Reporting gt COFO Templates COFO Templates Documents Type Name COFO Templates St COFO Elimination_templag m
8. TGT SOLUTIONS Council of Ontario Universities COFO Online Reporting System User Manual Updated September 2014 Page 1 TGT TGT SOLUTIONS Updated September 2014 Page 2 TGT TGT SOLUTIONS Table of Contents WiC UNO carci wa ec a a E E 5 Security Roles Defined in the Application cccsccceseseseeeeseeenseeeneeceseseasecnsesenseoenesens 5 Adding a New USO icsccssscccccascccescccscassccwencasesesaneessnessnevexvecsnesenttecncnsndeeasacthiensteameeciesesesneesesossie 7 Email Notification to a New USL ccccceseeceseeeeeeneeensseneeeneseeseenecensonseonesonssonesonseoneeoaes 10 Inactivating or Re activating a USP cccececeescceeeeeeseeeeeeenseeenesenseseaseoeneoenesenseeeneeonnenensens 11 Changing a Password for a USE cccsccceeseeceeeeceneeeeeseeeenseeeneeecenseseneeeensesonseesensesonnessons 15 Users Changing their OWN PaSSWOMG ccssseceeeeeeneeeneeenseeeaseeenseeaseeeaseeeeeeenesenseseneeseaes 21 Unlocking a USET aioe cect erence EAEE AEA 23 DEGUNG a2 USET aan OEE 25 System Time out Notification cccceeceeeeeeeeeeeeeeneeeeseseaseceneecsenenseeneeeesesoasesenseoneesoneesas 29 2 1 Fs een ee ee EE 30 Obtaining a copy of the current year COFO Template or Elimination Entry Template 30 Template Upload Process OVErvView cccccscceseceeseeeseeeeseeneeoeseeenseeeneeeneeonsesoaseneaeeonsenens 31 Reviewing Previous Template Submissions
9. The COFO Approver cannot change any of the values enter they can only view them Audit Fees Charged to Universities of Ontario Institution Brock University Survey Status Ready For Approval Include amounts expensed during the year Exclude GST HST but include out of pocket expenses If when filling out the survey for the current year you find information is missing or incorrect for the previous year please contact Marina Piao at COU to make the adjustments Actual Actual Actual 2007 2008 2008 2009 2009 2010 Regular Audits 72 030 72 062 0 Provincially Required Audits Enrolment 20 000 Capital 0 Other Provincial i 15 165 test 0 10 155 Special Audits Pension Plans 0 Total Other Special 20 Brock Foundation Audit 20 Internal Audits a o 22 000 Total 102 337 57 185 Auditor in current reporting year KPMG Did you change auditors within the last two years No Do you expect to tender within the next two years Yes Pending Approved Once the COFO Approver has reviewed the survey and is in agreement with the information entered they click on the Approved button at the bottom of the page This will change the Survey status to Approved and remove the Pending and Approved buttons from the bottom of the page The survey is then ready to be verified by COU lf the COFO Approver is not satisfied with the survey information then they click on the Pending button to change the Survey status back to Pending
10. To enter the Meal Plans offered by the Institution click on the 4 New Meal Plan hyperlink The following box appears Meal Plan Price of meal plan Number of meals per week Flex amount included in the meal plan Answer all of the questions and Save the page The information entered will appear on the Residence tab in the entry grid Updated September 2014 Page 119 TGT TGT SOLUTIONS To edit the information or to remove it completely click on the Edit hyperlink beside the Meal Plan to update or remove the information It is important to note that only 15 Meal Plans can be entered per Institution Printing Tab On the Printing tab all of the various Printing Services are listed on the left hand side of the entry grid It is important to note that only the questions for the Operations offered by the Institution need to be answered Leave blank any services that are not offered by your Institution Percentage split Type of Operation Revenue ieee cocsalicm Art Yo Specified Copiers Wi Specified Copy cards i Specified Print shop Mi Specified Stationary Not Specified Other Not Specified Sum of all percentages must be 100 For each type of Service that the Institution offers click on the Edit hyperlink beside the Service to answer the questions regarding this operation Once selected the following box appears Type of Operation Copiers Revenue Percentage split between operations Cancel Up
11. P Document Varniance Validation Validation wt Template Types Upload Variance Report Reporting Years Document Processed Submission Status Document Uploaded BA Validation Complete Institutions File successfully uploaded COFO Annual Report Submission Status Submission Status Pending Variance Checks No Total Validation Errors Oownload 13 Once the status of the Template upload changes for an Institution from Unpublished to Pending emails are sent to the COFO Reporter and COFO Approver for the Institution uploaded to advise them that the status has changed A sample of the email is as follows Approver Windsor Re Status Change on your COFO Submission to COU There has been a status change on the COFO Template submission for Windsor University of The previous status was Un Published The current Status is Pending The status was updated by sysadmin om 3 17 2010 Please contact COU if there are any questions or concerns Updated September 2014 Page 39 TGT TGT SOLUTIONS Step 3 Reviewing Validation Errors and Variances To review the detail on the Validation or Variance Errors click on the Download button beside Total Validation Errors or Total Variances COFO Annual Report Submission Status Submission Status Pending Variance Checks Wes Total Validation Errors Download Total Variances Download Variances Requiring Explanation Financial Statements Uploaded
12. amount of X XXX does not match the current value in the system It is important to note that the application stops checking and uploading rows when a blank row in found in the excel file So for example if you have 50 variances to define and you insert a new row at 25 the application will validate and upload row 2 to 24 Updated September 2014 Page 55 To upload the variance explanation file log into the COU COFO Online Reporting application and on the Submit Annual Report page click on the Type dropdown option and select the Variance Explanation Upload option COFO Online Reporting 4 COFO Online Reporting Submit Report le E COFO Templates Institution a Annual Report Files Year Type COFO Template Validation Report COFO Template Document Elimination Entr Variance Report Variance Explanation Upload System Reports Variance Validation Financial Statements a Template Types aah COFO Annual Report Submission Status Reporting Years Submission Status Instttons Submission Status Variance Checks Total Validation Errors Total Variances Download Variances Requiring Explanation Click on the Browse button to locate the variance explanation file on your desktop Then click on the Upload button to upload the file Updated September 2014 Page 56 TGT TGT SOLUTIONS Once uploaded the application will list how many rows were listed in the uploaded file how many variance explana
13. 0 26757 23074 126009 39603 164599 2r393 eto 1001 25 14626 164699 The Percentage By Row Percentage by Column and Percentage by Total Excel and PDF reports all display the same way as the Data Values reports Updated September 2014 Page 85 IGT GT SOLUTIONS 5 Customized Reporting Click on the Customized Reporting tab on the COFO UO Reports website to access the Customized Reporting options The following page appears STATIC REPORTS CUSTOMIZED REPORTS Table Distribution Table 1 SUMMARY OF REVENUE EXPENSES AND FUND BALANCE Data by Values Institution Reporting Year Fund Source Filter by Single Institution v Filter by single Year v Fund as a Column Source as a Row Total for System X 2009 2010 Select Funds Select Sources Run Report Reset To Default Settings Excel XLS v Export 2009 2010 Total for System Data by Values The settings that appear when you access the page have been set as defaults for the page Entering Criteria to Run a Report To run a report click on the dropdowns arrows and enter the criteria for the report you would like to run Select the Table Distribution Institution Reporting Year Fund s and Source s options that you would like to see For Institution Reporting Year Fund and Source you have the option to put these on either the row or the column To do this click on the down arrow beside the applicable criteria and select the Option required If y
14. Analysis by Table Financial Statements Uploaded Notes The document is not uploaded yet Updated September 2014 Page 36 TGT TGT SOLUTIONS Step 2 Uploading the Template The system defaults a number of the field values for you based on defaults set on the page and in your security settings Using the dropdown arrows beside each option you can change the defaulted values if more than one is available Click on Browse button beside the Document field and go to your desktop directory where the template is located that you wish to upload Once located select it In the Variance Validation field there are two options to choose from as noted above Validation will always be required but the COFO Reporter can select e Validation and Variance or e Validation Submit Annual Report Institution Brock University Year 2012 2013 Type COFO Template Document Browse Variance Validation Validation and Variance Validation and Variance Validation COFO Annual Report Submission Status Submission Status Variance Checks Total Validation Errors Total Variances Download Variances Requiring Explanation Variance Analysis by Table __Download Financial Statements Uploaded Pick one of the Variance Validation options and click on the Upload button The application will do the applicable Version Control Check and the Validation and or Variance checks based on what was selected and the Submi
15. Annual Report Files Year 2010 2011 Institution York University Reports Type COFO Template Validation Report p Document Browse Variance Report F Variance Validation Validation w Template Types Upload Reporting Years Document Processed Submission Status Document Uploaded Pi Validation Complete Institutions File successfully uploaded COFO Annual Report Submission Status Submission Status Pending Variance Checks Total Validation Errors Download It is important to note that when Validation is the option chosen the template cannot be submitted up to the next level Ready for Approval until both Validation and Variance have been run the Validation Errors have been corrected and all Variances have been explained Validation and Variance The Validation and Variance process will check that there are no validation errors in the template and it will identify any Variances that have to be explained The Variance process checks the following e Whether or not any of the salaries and wages and benefits in the submission change by 20 year over year and whether the change is equal to and greater or less than 100 000 e Whether or not any of the expenses excluding the salaries and wages and benefits in the submission change by 50 year over year and whether the change is equal to and greater or less than 100 000 e Whether or not any of the revenues in the submission change by 50 y
16. Files option 4 COFO Online Reporting Submit Report Bole ioe COFO Templates Annual Files Validation Report Variance Report Template Types Reporting Years Submission Status Institutions Updated September 2014 Submit Annual Report Institution Carleton University Year 2010 2011 Type COFO Template Document Variance Validation Validation and Variance w Upload COFO Annual Report Submission Status Submission Status Ready For Approval Variance Checks Yes Total Validation Errors Total Variances Download Variances Requiring Explanation Financial Statements Uploaded Notes The document is Ready For Approval by a COFO Approver Change Approved Page 62 TGT TGT SOLUTIONS The following page will appear showing the files uploaded and the status of the COFO Template Report COFO Online Reporting Welcome carleton er COFO Online Reporting Submit Report E COFO Online Reporting gt Annual Report Files Annual Report Files This List Annual Report Files Carleton University v Filter By Institution Documents ty Y a COFO Templates Name Institution W Vear Dennrt ea Report Annual Report Files 2010 2011 _Carleton_FS_2011 04 30 Carleton University Main consolidated FS 2 Carleton University 2010 2011 Financial Statements Reports 2010 2011 _Carleton_Report Carleton University 2010 2011 COFO Template Ready Fo
17. Password and the Confirm Password information and click on the Update User button The Password must conform to the standards defined by COU imi UserEdit Edit User User Information Username first Name Last Name Email address test tgtsolutions com Institution Knox College For Institution Organization users please select the primary institution from the drop down list For COU users choose ALL Change Password To change the password enter the new password and the confirm password below Leave these fields blank to keep the same password 7 Password must be at least 7 characters long and must contain both a number and Password hoe special character sons PO Password User Active Check the box if the user s account is active Once the page has been saved the application will send an email to the User with their updated password using the email address entered for the User Updated September 2014 Page 16 TGT TGT SOLUTIONS The email will come from cousupport tgtsolutions com and will contain the following information COU Reporting cousuppertitgtsolutions com To carol meni teolubons com ce Subject COFO Online Reporting Password Changed Hello Your password has been reset Please return to the COFO Online Reporting System and login using the new password below Password Password Note Please ensure you enter the password exactly as shown Once you have successfully logged
18. Report page will appear The User will see only the variances for their Institution on the page If you have access to more than one Institution click on the Filter by Institution to select the one you want Click on the specific row item under the Test Type column for the variance that you wish to explain COFO Online Reporting 4 COFO Online oe Submit Report I This List Variance Report v COFO Online Reporting gt Variance Report Variance Report Annual Report Submission Variance Checks COFO Templates Brock University v Filter By Institution Annual Report Files Reports a Validation Report Renorting Year able n Headina Negative 2010 2011 Brock Negative Table 10 14 Social Sciences F Operating University values require amp Humanities General Variance Report explanation Research Expendable Funds Council System Reports Negative 2010 2011 Brock Negative Table 10 14 Social Sciences G Other Non Credit Lists University values require amp Humanities General explanation Research Expendable Funds Council Reporting Years Negative 2010 2011 Brock Negative Table 10 14 Social Sciences J Entities Submission Stats University values require amp Humanities Consolidated explanation Research Sponsored a Institutions Council Research Restricted Expendable Funds Template Types Surveys Updated September 2014 Page 49 TGT SOLUTIONS The following page will appear with
19. Reporting Y Institution Description iTable Row Row Heading Column Column Heading Current Previo Variance Variance Explanation Negative 2010 2011 Algoma Univer Negative values require explanation iTable12 17 Ministry of Energy Science and Technology L Entities Consolidated Sponsored Research Restricted Expenc 11 Revenue 2010 201 Algoma Univer Revenue variance of more than 50 and t 100 008 Table 2 16 Basic Formula Grant H Operating Operating General Expendable Funds 1E 05 Revenue 2010 2011 Algoma Univer Revenue variance of more than 50 and t 100 008 Table 2 17 Other MTCU Grants amp Contracts H Operating Operating General Expendable Funds 95069 Revenue 2010 2011 Algoma Univer Revenue variance of more than 50 and t 100 008 Table 2 1 Other MTCU Grants amp Contracts L 1 Entities Consolidated Sponsored Research Restricted Espenc 2880 Revenue 2010 2011 Algoma Univer Revenue variance of more than 50 and t 100 00 Table 2 1 Other MTCU Grants amp Contracts 0 Trust Restricted Expendable Funds 1717 Revenue 2010 2011 Algoma Univer Revenue variance of more than 50 and t 100 008 Table 2 1 Other MTCU Grants amp Contracts P Capital Restricted Expendable Funds 15233 Revenue 2010 2011 Algoma Univer Revenue variance of more than 50 and t 100 008 Table 2 18 Other Ontario Government Grants and Contr H Operating Operating General Expendable Funds 38728 Revenue 2010 2011 Algoma Univer Revenue variance of more
20. Surveys Survey Institution Year Submission Status Modified Ancillary Enterprises Wilfrid Laurier University 2011 12 Un Published 5 8 2012 12 00 00 PM Audit Fees Charged to Universities of Ontario Wilfrid Laurier University 2011 12 Un Published 5 8 2012 12 00 00 PM Financial Health Wilfrid Laurier University 2011 12 Un Published 6 25 2012 2 54 58 PM Travel Reimbursements for the Universities of Ontario Wilfrid Laurier University 2011 12 Pending 7 13 2012 5 57 42 PM To access your Survey form click on the View hyperlink on the left hand side of the page and the applicable survey related page will appear Affiliates will only see the Ancillary Survey in their Survey list Pontifical Institute of Medieval Studies v All Surveys Go to Survey Report Survey Institution Year Submission Status Modified View Ancillary Enterprises Pontifical Institute of Medieval Studies 2009 10 Un Published 8 17 2011 9 00 00 A To return to the Survey Response List click on the Return to Survey List hyperlink in the top left corner of the page 1 Survey Response Return to Survey List Audit Fees Charged to Universities of Ontario Institution Trent University Survey Status Unpublished Updated September 2014 Page 94 IGT GT SOLUTIONS 6 Audit Survey Entering Audit Survey Information The Audit Survey form is comprised of eight different questions Two years of historical information are provided on the onlin
21. Uniwersity xls When a By Institution PDF is selected the PDF file will contain all of the tables for the Institution or Rollup selected In the example below the PDF report will display all of the tables for the Total for System report Updated September 2014 Page 81 SOLUTIONS TGT A Total_for_System 1 pdf Adobe Reader File Edit window Help E E F gt e fa4 57 8 ai H KA Ja View Document Tools Table 1 Summary of Revenue Expenses and Fund Balance Year 2008 2009 Distributions Data by Values 000s Total for System Total Revers Total Expense Lump Sum Faymenis Met Revenus Ewpensel nerui Transfers Met Varalan bn Aperapeiatcers let increas Decrease for ihe Year per DOFO Report Rei Reconiding Rens Balance Beginning of year as per PRIOR YEAR S COFO REPORT Prior Pedod Acjusiments Balance End of te Year PER FINANCIAL STATEMENTS Unpesticisd rlemally Rested mvestment n Capial Assets Externally Foesiricied Total Updated September 2014 Unaporopriaied Appropcriaked operating A Siher Operaling A Other honed ki Noritrescihi General General Linaporopraied Ancillary Seneral Expendable Fumis Expendatde Funds Expendable Furic 6 223 512 6 285 140 1753 igei 164 565 35 334 164 856 640 TST 286 H2123 1 7004 i1 070s g 35 854 139 534 p 1212025 7 wiz 1 238 425 Le 1S 45 g p 1 255425 B56 226 815 335 15 BO 4
22. a directory of the Static Reports that have been generated and are available for review and download If a year has not been run or has been taken offline the directory for the reporting year will disappear When the reporting process runs it creates two main groupings of reports By Institution and By Table Within the main groupings there are four sub groupings referred to as Distributions of reports Data Values Percentage by Column Percentage by Row and Percentage by Total Within the four sub groupings there are two report types available for selection Excel and PDF Within the report type directory the reports will appear in the following order 1 Total for System 2 Total for Universities 3 Total for Affiliates 4 Alphabetically by Institution STATIC REPORTS CUSTOMIZED REPORTS COFO Static Reports 2009 2010 By Institution Data Values Percentage by Column Percentage by Row Percentage by Total By Table j Data Values Percentage by Column Percentage by Row Percentage by Total 2008 2009 2007 2008 Updated September 2014 Page 79 TGT TGT SOLUTIONS Downloading Reports When a User selects a distribution type Data Values Percentage by Column Percentage by Row Percentage by Total they can choose to view or download either the PDF or Excel file for viewing COFO UO FINANCIAL REPORT OF ONTARIO UNIVERSITIES STATIC REPORTS CUSTOMIZED RE
23. all of the information associated with the variance row Click on the Edit Item option to add or change the explanation for the variance Variance Report Revenue C Edit Item Test Type Revenue Reporting fear 2008 20049 Template Type COFO Template Description Revenue variance of more than 50 must be explained Table Table 2 Column H Column Heading Operating Operating General Expendable Funds Row 16 Row Heading Basic Formula Grant Current 4902 Previous T Yariance Y ariance o Explanation Created at 5 11 2010 10 49 4M by sysadmin Last modified at 5 11 2010 10 54 AM by sysadmin Updated September 2014 Page 50 TGT TGT SOLUTIONS The following page will appear Enter an explanation for the variance in the Explanation box A spell check can be done on the explanation entered by clicking on Spelling at the top of the page A file can also be attached to support the variance explanation and to use as a reference for future uploads by clicking on the Attach file option top of the page Variance Report Revenue OK Cancel i Attach File 7 Spelling indicates a required Field Test Type Revenue Reporting Year 2008 2009 Template Type COFO Template Description Revenue variance of more than 50 must be explained Table Table 2 Column H Column Heading Operating Operating General Expendable Funds Row 16 Row Heading Basic Formula Grant Current 3902 Previous 0 Variance 3902
24. and document es and the status of the submission lz Approved and is lo Updated September 2014 Page 76 GI 3 COU Verifying the COFO Template or Elimination Entry Once the COFO Template or Elimination Entry has been Approved COU will review the information and at its fall meeting the Financial Reporting Committee FRC will review the Institutional submissions for accounting consistency If the information in the template is satisfactory COU will change the submission status to Verified by clicking on the Verify Button on the Submit Annual Report page Once the template has been verified by COU the Submission Status will change from Approved to Verified cd T De aa Lil mr wc COFO Online disik Submit Annual Report COFO Templates Institution Western Ontario University of Annual Report Files Year 2010 2011 Type COFO Template Validation Report pe Document Variance Report a System Reports Variance Validation Template Types ee AA COFO Annual Report Submission Status Submission Status Verified Variance Checks Yes Total Validation Errors Total Variances Download Variances Requiring Explanation Reporting Years e Submission Status u Insttutons Financial Statements Uploaded Notes The document is verified by COU and is complete Not Verfied Updated September 2014 Page 77 Gl OLUTIONS lf the COFO Template or Elimination Entry inf
25. in vou can change your password by clicking on the Welcome then My Settings link at the top of the page within the COFO Online Reporting System Thank you COU Updated September 2014 Page 17 Option 2 Users Requesting a New Password lf a User has forgotten their password they have to navigate to the Sign in page for the Online Reporting Application and click on the Forgot your Password Link Forgot your Password The Forgot your Password page will appear which will prompt the User to enter their email address Once the email address is entered click on the Reset Password button Forgot your Password To reset your password enter the email address associated with your account below and then click Reset Password You will receive an email with a new password within a few minutes emai iene Return to the login page The following page will appear advising the User that the new password was emailed to the email address they entered Thank you Your password has been emailed to you Return to the login page Updated September 2014 Page 18 GT SOLUTIONS The email will come from cousupport igtsolutions com and will contain the following information COFO Online Reporting Password Reset cousupport tgtsolutions com cousupport tatsolutions com Add to contacts amp 27PM gt To c_mcnall hotmail com Hello Your password has been reset Please return to t
26. operated outlets Arcade Not Specified Athletic equipment 14 ATM i4 Bank Not Specified Chiropractor Not Specified Clothing and sundry Not Specified Residences Tab There are two entry grids on the Residence tab The first entry grid is for question 4 4 List all residence styles ex Dorm single Townhouse shared Residence A Triple etc Residence fees charged for coming year Residence Style Fall Winter Summer Add New Residence Style To enter the Residence Styles offered by the Institution click on the Add New Residence Style hyperlink The following box appears ses ST Style Residence fees charged for coming year Fall Winter Summer Updated September 2014 Page 118 TGT TGT SOLUTIONS Answer all of the questions and Save the page The information entered will appear on the Residence tab in the entry grid 4 List all residence styles ex Dorm single Townhouse shared Residence A Triple etc Residence fees charged for coming year Residence Style Fall Winter Summer Edit Dorm single 3 500 00 1 275 00 Add New Residence Style To edit the information or to remove it completely click on the Edit hyperlink beside the Residence Style to update or remove the information The second entry grid is for question 7 7 Price of meal plan s including flex plan cash Flex amount included in the Meal Plan Price of meal plan Number of meals per week meal plan Add New Meal Plan
27. so the COFO Reporter can make the necessary changes and re submit it for Approval When the COFO Approver changes the status back to Pending an email is automatically sent to the COFO Reporter advising them that the status has changed on the survey Updated September 2014 Page 101 TGT TGT SOLUTIONS 7 Travel Survey Entering Travel Survey Information The Travel Survey form is comprised of five sections Each section contains questions that must be reviewed and answered if they apply to your University s policy The COFO Reporter at the University will open the Travel Survey form to enter the applicable information for the current year Section 1 is as follows Return to Survey List Travel Reimbursements for the Universities of Ontario Institution Wilfrid Laurier University Survey Status Pending Section 1 Automobile Travel The following questions relate to your institutions reimbursement policy on the use of personal automobiles for business travel 1 What is the amount of reimbursement paid by your institution for travel by personal automobile format e g 0 465 a Cents per kilometer 2 What is the effective date of relevant reimbursement policy The following questions relate to limitations on the amount of reimbursement paid 3 What is the eligible kilometrage a Actual distance travelled E O b The lesser of the actual distance travelled or i the difference between the actual travelled and t
28. template that the user is trying to upload does not agree to the Version Control Number associated with the Template type the application will not proceed to the next series of checks It will return a message to the user advising them that they are using the wrong template version and it has to be corrected in order to proceed See snapshot below for a copy of the message Submit Report i denied COFO Templates Institution Algoma University a Annual Report Files Year 2009 2010 Validation Report P Document Variance Report Vaniance Validation Validation and Variance a Template Types Reporting Years The template version you are uploading is not correct and Submission Status must be corrected in order to proceed Institutions COFO Annual Report Submission Status Submission Status Pending Variance Checks Yes Total Validation Errors Downkad 17 Total Variances Download Variances Requiring Explanation Updated September 2014 Page 31 TGT T SOLUTIONS T I Once the version control check is complete and successful the application will do the Validation or Validation and Variance checks depending on the options selected on the Submit Annual Report page Validation The validation check process performs two separate checks The first check looks at the Opening Balances on Table 1 to see if they agree to the Closing Balances from last year s Submission The second check process confi
29. templates are uploaded they will be stored in the Financial Health Survey History page which can be accessed from the Document menu section COFO Online Reporting gt Financial Health Survey History Financial Health Survey History Filter By Institution COFO Templates Annual Report Files 2011 2012_Algoma University_FHS Algoma University 2011 2012 Report Files History 2011 2012 Brock University FHS Brock University 2011 2012 Financial Health Survey Histor 2011 2012 _Carleton University_FHS Carleton University 2011 2012 This page will contain all of the submissions from 2011 12 forward Only the COU Administrator will see all institutions Universities will only see their own The submission can be opened by clicking on the File name and following the prompt boxes The Open option will request a second sign in which is not required to open the document so you can click on the X to close the box Updated September 2014 Page 135 TGT TGT SOLUTIONS 10 Financial Health Interactive Reporting Instead of creating a formal report for the Financial Health Survey information a new interactive reporting feature was added to the Online Application for analysis purposes This new feature is only available to Universities that have uploaded the Financial Health Survey template The new feature is very similar to the Customized Reporting that is available on the Public website Note each University will be able to vie
30. the submission status can be changed from Pending to Ready for Approval COFO Online Reporting 4 COFO Online Submit Annual Report COFO Templates Institution Brock University Annual Report Files Year 3012 27013 Report Files History Type COFO Template a Financial Health survey History Document Browse Vaniance Validation Validation and Variance Upload a Validation Report Variance Report System Reports COFO Annual Report Submission Status Financial Health Submission Status survey Interactive Reporting Variance Checks Total Validation Errors oa Downed ys Total Variances Reporting Years Variances Requiring Explanation s Submission Status Variance Analysis by Table Downkbad Insttutons Financial Statements Uploaded Notes The document contains variances All variances must be explained before it can be submitted for approval There are two options to enter Variance explanations which are as follows 1 Enter explanations for each variance on the Variance Report page within the application 2 Download the Variances to excel enter the explanations in the excel form and upload the information Both methods are described in the following sections Updated September 2014 Page 48 IGT GIT SOLUTIONS Option 1 Enter Variance Explanations Online On the COU COFO Online Reporting Home Page under the Reports menu click on the Variance Report The Variance
31. this point the COFO Reporter will click on the Ready for Approval button to change the status from Pending to Ready For Approval Submit Annual Report Institution Algoma University Year 2012 20135 Type COFO Template Document Browse Vanance Validation Validation and Variance Upload COFO Annual Report Submission Status Submission Status Pending Variance Checks Yes Total Validation Errors Total Variances Download Variances Requiring Explanation Variance Analysis by Table Doankad Financial Statements Uploaded Notes The document passes all validation and all variances hawe an explanation A COFO Reporter can update the status of this submission to Ready For Approval Change Status Ready For Approval When the Ready for Approval button is selected and the status changed emails will be sent to the COFO Reporter and COFO Approver for the Institution to advise them that the status for the submission has changed Updated September 2014 Page 58 TGT TGT SOLUTIONS The submission status on the Submit Annual Report page will change accordingly Submit Annual Report Institution Algoma University Year 2012 20135 Type COFO Template Document Browse Variance Validation Validation and Variance COFO Annual Report Submission Status Submission Status Ready For Approval Variance Checks Yes Total Validation Errors Total Variances Downkad Varia
32. this report does not replace the Variances requiring Explanation reporting or process It is being provided as an interactive analysis tool Updated September 2014 Page 44 IGT GT SOLUTIONS To review and work with the report click on the _Downiest_ button on the Variance Analysis by Table row When the File Download box appears select Open or Save File Download Do you want to open or save this file x Name 2012 2013 Brock University Variance Analysis xlsx H Type Microsoft Excel Worksheet 171KB From cousit tgtsolutions com 9n seve Canes While files from the Intemet can be useful some files can potentially ham your computer f you do not trust the source do not open or save this file What s the isk You may have to Enable Editing on your desktop depending on what version of Excel you are using The following file will appear B c D F TABLE 1 SUMMARY OF REVENUE EXPENSES 3ALANCE Year over Year Variance Analysis 000 s 2012 13 Brock University General Expendable Funds Operating amp Other Non Credit Ane Unappropriated o 2011 12 i i 2012 13 2011 12 Variance Variance 2012 13 2011 12 Variance Variance Total Revenue f 221 821 0 00 138 500 29 520 Total Expense f 215 872 0 00 217 511 29 874 0 00 354 011 354 0 00 16 200 220 0 00 15 000 0 Net Revenue Expense Interfund Transfers Net Variation in Appropriations i 2 j 174 2 00 Ne
33. 0 22 in Debt Financing Row 6 Column E cannot contain decimals The length of the Non Numeric value This is a test for 300 characters This is a test for 300 characters This is a test for 300 characters This is a test for 300 characters This is a test for 300 characters This is a test for 300 characters This is a test for 300 characters This is a test for 300 characters This is a test for 300 characters This is a test for 300 characters 300 in Debt Financing Row 41 Column D exceeds the maximum allowed characters 300 Updated September 2014 Page 131 TGT TGT SOLUTIONS Any errors found in the upload file will appear on the Survey tab as follows Return to Survey List Financial Health Survey Institution Northern Ontario School of Medicine Survey Status Un published Please click here to download the current Financial Health Survey Template Upload Survey Document Browse Upload Cancel There are errors with the submission Numeric value 1000 22 in Debt Financing Row 6 Column D cannot contain decimals Numeric value 1000 22 in Debt Financing Row 6 Column E cannot contain decimals Numeric value 1000 22 in Debt Financing Row 6 Column F cannot contain decimals a Numeric value 3000 66 in Debt Financing Row 6 Column H cannot contain decimals These errors have to be corrected in the template file and the revised file re uploaded into the application The templ
34. 1 221 621 23 81 0 00 138 500 29 520 2 Total Expense 02 215 872 2137 47 0 00 217 511 3 Lump Sum Payments 03 0i 40 000 0 00 0 00 2 000 4 Net Revenue Expense 04 2 049 9122 74 0 00 254 011 5 Interfund Transfers 05 5 703 38 103 668 12 0 00 16 200 6 Net Variation in Appropriations 06 2 697 4697 174 16 2 00 0 00 15 000 Net Increase Decrease for the Year per COFO UO Report O07 2 451 pitii iii 00 i 0 00 385 211 8 Net Reconciling Items 08 4 310 0 00 102 785 Balance Beginning of year as per PRIOR YEAR S COFO REPORT 09 30 934 6 761 1 8 28 116 5 i 10 61 0 0 Prior Period Adjustment Tao 0 0 26 116 0 00 The highlighted cells will change as the variance is updated When a Variance is entered into cell N2 or the box next to the Find Variance text the filter will locate variances on the tab that equal or exceed the value entered and highlight them to match the blue highlight Note the screen shot below shows all of the variances located that match or exceed the 250 variance entered B C D F TABLE 1 SUMMARY OF REVENUE EXPENSES BALANCE Year over Year Variance Analysis 000 s 2012 13 Brock University General Expendable Funds Operating amp Other Non Credit Unappropriated Unappropriated 2011 12 Variance Variance 2012 13 2011 12 Variance Variance 2012 13 2011 12 Variance Variance Total Revenue f 221 821 23 81 0 00 138 500 29 520 Total Expen
35. 3172 1979350 44206 2065720 234003 255122 2045922 4413 2065720 Total Expendable 10466911 10637066 15513 156965 35005 Oo 223973 99895 2881650 39803 2602903 144601 1 1881945 2146955 22014 2602903 Endo Page 83 TGT SOLUTIONS When a By Table PDF is selected and the PDF file is opened it will display the information in the same order as the directory structure Total for System Total for Universities Total for Affiliates followed by the Institutions in alphabetical order Table 1 Summary of Revenue Expenses and Fund Balance Year 2008 2009 Disinbutions Data by Values O00 s Total for System Unaperopated Approprlated Approgriated Sponsored Operating amp Other Operating amp Gihar Ancillary Research Trust Capital Non Credit Non Crediti Unappropriated General Restricted Restricted Restricted General General Anciliary General Expendable Expendable Expendable Expendable Total Expendable Funds Expendable Funds Expendable Funds Funds Funds Funds Funes Expendable Endowment Total Revenue 6 223 518 896 225 2 473 318 360 575 513 274 10 466 911 921 941 Total Expense 6 245 140 1 315 335 i 2425 53 382 438 787 319 10 637 156 o Lump Sum Payments 17 839 T 415 57 261 a 15 813 34 Net Revenue Expense 40 161 o 60 475 46 587 2 124 274 045 185 958 821 975 Interfund Transfers 164 569 1 40 47 1 4 265 i 183 087 35 005 35 005 Net Varlation In Appropelati
36. 441 795 e Incidentals including stationary 1 451 304 What type s of pricing policies for new textbooks is used More than one selection is allowed a Mark up from net price final price after deducting all discounts and rebates No b Mark down from suggested list price No c Suggested retail price Yes Please explain in what situations suggested retail price is used Can list price 50 Can net price x 1 35 US US net price x 1 35 x 1 35 transportation What is the dollar value of the bookstore inventory at year end 1 050 484 Is interest charged on inventory at year end No What is the number of full time equivalent staff working in the bookstore 15 00 Note If you are using the answers to the previous survey submitted to assist with the responses to the current survey please ensure that the questions have not changed from one survey to the next as they are updated to accommodate suggestions from the Institutions FRC and COU Updated September 2014 Page 126 TGT TGT SOLUTIONS Approving the Survey It is now up to the COFO Approver to review the University s submission and submit it as Approved to COU To complete the approval the COFO Approver logs into the COU COFO Online Reporting application and selects the Surveys menu item COFO Online Reporting aiai COFO Online Reporting Submit Report PoE d 4 Submit Annual Report COFO Templates Institution Algoma University Annual R
37. 75 Mo 47 TES 39 2153 S537 152 0434 a 156 252 bs 9 4551 a 1 156 352 Appronriahed Amciiery General Expencwshle Urs Sponsored search Resricied Expendable Funds 23473 3185 2425 53 coy 46 587 4 256 o 51 153 52 512 Trust esmi Expendable Funds 360 575 362 43 251 21234 7 268 g 03352 2378 275 523 o 214 152 21 515 1 35 o Th 27s 214 152 Dap Ral Resiicted Excemcsble Furs 513 274 TEn HS o 274 045 183 037 o 31 008 133 172 1 575 350 44 206 2 065 720 234 883 25 122 2 045 522 2 088 720 Total Expendable 10 466 911 10 637 066 16 813 TBS Ses 35 005 a 223 373 35 Fe 2 887 650 35 803 2602903 11 488 001 1 881 945 2 746 955 22 014 2 602 503 Encoament 824 544 o 34 521 575 35 005 o 228 570 S884 4 584 238 M773 3 825 450 D 631 551 o 9 1 885 3 828 450 Page 82 TGT SOLUTIONS When a By Institution Excel file is selected and the Excel file is opened the tables appear as tabs at the bottom of the workbook similar to the Template uploaded able 1 summary of Revenue Expenses and rund Balance Year 2006 2009 Distributions Data by Values 000 s Total for System Total Revenue Total Expense Lump Sum Payments Met Revenue Expense Interfund Transfers Met Variation in Appropriations Met Increase Decrease for the Year per COPO U0 Report Met Reconciling tems Balance Beginning o
38. Filter by Single Institution Select a University The first box defines where you would like the data displayed in the report grid and how much you want to see while the second box allows you to select the Universities you want to review Updated September 2014 Page 137 TGT SOLUTIONS The first box provides three options with the first option being the default Filter by Single Institution Institution as a Column O Institution as a Row If you pick either one of the last two options you can select multiple Universities The second box provides the list of Universities that are available for selection Remember only the Universities that filled in the survey will appear in the list The third set of options available for selection pertains to Reporting Years While the 2011 12 reporting year was the first year the templates were loaded into the Online Application four years of history information was converted from previous surveys completed by the group Again there are two boxes available to select the information and they work similar to the University section The fourth set of options available for selection pertains to the Funds or columns in the Financial Health Survey template The information displayed in this section will vary depending on which Tab was selected in the first box It is important to note that some of the Financial Health Survey tabs ask questions that are general in nature and do no
39. MENTS a i i Unrestricted o Cra BBO 043 943 15 nternaly Restricted ay amao ow oar 115 882 191883 165 089 19 nvestmentin Capital Assets PtP 20 Externally Restricted 4 6 E E Cie Ea Updated September 2014 Page 91 Obtaining Different Reporting Views After the report has been run the User has the option to drag and drop the Institution Year Fund or Source to move them from the row to the column or the column to the row Criteria can be moved around as required as long as one row or column value remains In the example below to move year from the column to the row click on year and drag it to the row Once the up and down arrows appear release it and the report will refresh moving it to the row Insiuton Reporting Tear Purg Fher by Sagie lnebtutien Teor at 6 Column Fund as a Column Total for Syatem Select Years Select Funds Run Reppert Reset To Oefauk Settings Total for System Data by Values Year Fund zpoza 1 620 302 1 025 314 1 7 GS 27 1 039 853 471 78 400 21 049 9 765 4 471 Updated September 2014 ai id t 170 399 28 320 3 921 3 720 Source Source DE p Ria celc Sources Excel MLS F 4 3 189 720 3 395 328 a31 i46 049 1 654 t4 573 149 a a 373 149 1 454 6 604 781 6 676 045 17 539 83 503 265 299 Page 92 TGT TGT SOLUTIONS 5 Survey Information Overview of Surve
40. Out Un check the box to un lock this user account Role s Choose one or more roles from the list below for this user A selection is required C coro Admin C COFO Approver COFO Guest L COFO Reporter Updated September 2014 Page 24 TGT TGT SOLUTIONS Deleting a User lf a user no longer requires access to the COU COFO Online Reporting Application they can be deleted from the application The COU Admin will be able to delete any user in the application while the COFO Administrators will only be able to delete users associated with their University or Affiliate It is important to note that the delete function only removes the User from the User page It does not remove any reference to the user in tables or logs if they completed various functions in the application e g entering Survey information Deleted users can be re added should the need arise Follow the Add user process to re add the user To delete a User log in to the COU COFO Online Reporting Application as COU Administrator or the COFO Administrator From the Home Page select the Users menu option COFO Online Reporting 4 COFO Online Reporting Submit Report Submit Annual Report COFO Templates Institution Algoma University a Annual Report Files Year 2012 2013 Report Files History ae COFO Template Financial Health Survey History Document Browse Variance Validation Validation and Variance Validation Report
41. PORTS COFO Static Reports 2009 2010 By Institution Data Values Excel sa POF Percentage by Column Percentage by Row Percentage by Total By Table Data Values Percentage by Column j Percentage by Row Percentage by Total 2008 2009 Updated September 2014 aS Total for System pdf aS Total for all Universities pdf aS Total for all Affiliates pdf aS Algoma University pdf xs Brescia University College pdf p Brock University pdf p Carleton Uniwersity pdf Conrad Grebel University College pdf A Dominican College pdf as Guelph University of pdf p Hearst Le Coll ge Universitaire de pdf aS Huntington University pdf Page 80 TGT TGT SOLUTIONS COFO UO FINANCIAL REPORT OF ONTARIO UNIVERSITIES STATIC REPORTS CUSTOMIZED REPORTS COFO Static Reports 2009 2010 Institution Data Values E Excel TS Percentage by Column Percentage by Row Percentage by Total al Table Data Values Percentage by Column j Percentage by Row 4 Percentage by Total 2008 2009 3 Total for System xls 3s Total for all Universities xls Total for all Affiliates xls 3 Algoma University xls Brescia University College xls 3 Brock University xls Carleton University xls 3 Conrad Grebel University College xls 3 Dominican College xls 3 Guelph University of xls 2 Hearst Le Coll ge Universitaire de xls Huntington
42. S O Text CSV 2008 2009 Total for System Data by Values Fund Operating General Other Non Credit Subtotal General Ancillary General Entities Consolidated So Expendable Funds General Expendable Expendable Funds Expendable Funds Sponsored Research Funds Restricted Expendable Funds tt Tt Tt Tt Tt Academic Ranks 2 043 129 16 101 2 059 230 101 870 Other Instruction amp Research Other Salaries amp Wages Total Salaries and Wages 347 312 17 882 365 194 326 550 1 754 659 57 867 1 812 526 178 554 240 290 4 145 100 91 850 4 236 950 178 554 668 710 Once the report has been exported to Excel all of the Excel tools are available to be used Unappropriated Appropriated Unappropriated Appropriated Sponsored Trust Restricted Capital Restricted Operating amp Other Operating amp Other Ancillary General Ancillary General Research Expendable Funds Expendable Funds Mon Crecit Mon Credity Expendable Funds Expendable Funds Restricted General Expendable General Expendable Expendable Funds Total Revenue 0 ooie U BEA per COFO UG Report Met Reconciling tems 235 450 Balance Beginning of year as per 57 O03 133 208 109 826 261 195 1 820 213 14 PRIOR YEAR S COFO REPORT l a Prior Period amp djustments 30 327 1 024 612 795 78 Qi 3 293 21 991 Balance End of the ear PER 797 206 1 312 029 163 043 161 729 112 948 275 923 1 979 350 16 FINANCIAL STATE
43. Upload load Oy a Variance Report system Reports COFO Annual Report Submission Status Financial Health Submission Status Un Published survey Interactive Reporting Variance Checks Total Validation Errors Total Variances Template Types a l l Variances Requiring Explanation Reporting Years Submission Status e Insttutons Variance Analysis by Table Financial Statements Uploaded Notes The document is not uploaded yet Updated September 2014 Page 25 TGT SOLUTIONS When the User List page appears click on the Username to be deleted Users Add New User Show 10 entries Search A Username First Name Last Name Email Institution Active Roles aaaa aaaa bbbb aaa tgtsolutions com Yes COU Admin COFO Admin COFO Survey COFO Approver COFO Survey COFO Survey CSAO Members algoma frc Algoma FRC carol mcnall tgtsolutions com Algoma University FRC Members algoma admin Algoma Admin carol mcnall tgtsolutions com Algoma University algoma approver Algoma Approver carol mcnall tgtsolutions com Algoma University algoma csao Algoma CSAO carol mcnall tgtsolutions com Algoma University algoma guest Algoma Guest carol mcnall tgtsolutions com Algoma University COFO Guest COFO Reporter COFO Survey COFO Reporter COFO Survey COFO Approver areddy Amanda Reddy carol mcnall tgtsolutions com Brock University COFO Guest COFO Reporter algoma reporter Algoma Reporter cmcnall tats
44. Year 2008 2009 Distributions Data by Values 0000 s Total for all Affiliates Unappropristed Appropriated Operating amp Other Operating amp Other Mon Crediti Mon Credit Unappropristed General General Ancillary General Expendable Funds Expendable Funds Expendable Funds Met Revenue Expense Interfund Transfers Met Variation in Appropriations Met Increase Decrease for the ear per COFO UO Report Met Reconciling tems Balance Beginning of year as per PRIOR YEAR S COFO REPORT Prior Period Adjustments Balance End of the Year PER FINANCIAL STATEMENTS Unrestricted 150790 165557 d 14760 32065 292 47340 35290 73845 12550 755 755 70832 44646 0 26186 11312 50 14824 13900 10179 0 Internally Restricted Investment in Capital Assets Externally Restricted Total Approapriated Ancillary General Expendable Funds M Total For System 4 Total for all Universities Total for all Affiliates Algoma University f Sponsored Research Restricted Expendable Funds 1359 1607 0 248 44 0 204 138 371 122 183 0 10 und Balance Trust Restricted Expendable Funds 5362 g01 oO 3539 5206 oO 1667 1662 47545 oO Capital Restricted Expendable Funds Bars 12386 0 5513 10021 0 4505 B4 43091 S247 5 100758 133 1204 100128 441 100758 Total Expendable En 235216 233097 0 2119 25906
45. a Reporting Years a Submission Status a Institutions Updated September 2014 File Download Variance Ci Do you want to open or save this file Name 2010 2011 Carleton Report xls Type Microsoft Office Excel 97 2003 Worksheet 461KB From cousit tgtsolutions com Always ask before opening this type of file r gt 1 While files from the Internet can be useful some files can potentially q harm your computer If you do not trust the source do not open or Ss save this file whats the tisk Page 74 Once the COFO Elimination Entry has been reviewed and the COFO Approver is satisfied that it is ready to be approved they change the status on the Submit Annual Report page by clicking on the Approved button at the bottom of the page 4 COFO Online Reporting Submit Report ole aes Submit Annual Report Institution Ottawa University of na Year 2010 2011 Type COFO Template Document Varniance Validation Validation and Variance Template Types Upload LL ing Years a COFO Annual Report Submission Status a Submission Status ee 7 Submission Status Pending Institutions p Variance Checks Yes Total Validation Errors Download 8 Total Variances Downkad 236 Variances Requiring Explanation 0 Financial Statements Uploaded D Notes The document contains validation errors All validation errors must be fixed and the report re submitted Elimination Entry Form Submission Stat
46. age 67 TGT TGT SOLUTIONS Templates COFO Elimination Entry University Uploads Step 1 Preparing to upload the Elimination Template When the Elimination Entry template is complete and ready to be uploaded the COFO Reporter will log into the COU COFO Online Reporting Application The application will display the Submit Annual Report Page The information pertaining to the Elimination Entry submission is on the bottom of this page under Elimination Entry Form Submission Status This section of the page is only displayed for Universities that have Affiliates associated with them Prior to Uploading the Elimination Entry for an Institution the status will be Un Published Only one Validation check is done on the elimination template and no Variance checking is completed Submit Annual Report Institution McMaster University Year 2012 20135 Type COFO Template Document Variance Validation Validation and Variance Upload COFO Annual Report Submission Status Submission Status Un Published Variance Checks Total Validation Errors Total Variances Variances Requiring Explanation Variance Analysis by Table Financial Statements Uploaded Notes The document is not uploaded yet Elimination Entry Form Submission Status Status Un Published Total Validation Errors o Notes The document is not uploaded yet Updated September 2014 Page 68 TGT SOLUTIONS Step 2 Uploading the Elimina
47. amp Humanities explanation Research Council Updated September 2014 Page 41 TGT TGT SOLUTIONS Step 4 Correcting Validation Errors When an upload has been completed and Validations errors are found in the submission as noted on the Submit Annual Report page they must be corrected in the underlying excel template file that was selected for uploading The validation error report lists exactly which row and column or validation check is failing Once the corrections are made to the excel file it must be uploaded again for Validation COFO Online Reporting 4 COFO Online Reporting Submit Report Po EE da Submit Annual Report COFO Templates Institution Brock University Annual Report Files Year 2010 2011 Type COFO Template a Validation Report Document Browse Variance Report System Reports Variance Validation Validation and Variance Upload Template Types i a COFO Annual Report Submission Status Reporting Years Submission Status Instttons Submission Status Variance Checks Total Validation Errors Ocwnload l 7 rere ry a Updated September 2014 Page 42 Once all of the Validation errors have been corrected the Total Validation Errors on the Submit Annual Report page will read 0 4 COFO Online Reporting Submit Report liege COFO Templates Annual Report Files Validation Report Variance a System Reports Template Types R
48. ancel Click on the Please click here to download the current Financial Health Survey Template to download the current excel template form Once all of the tabs in the Financial Health Survey template are populated return to the Survey menu and select the Financial Health Survey from the list Click on the _ Browse button to locate the file on the desktop Once the file is selected click Upload on the ution Updated September 2014 Page 130 TGT TGT SOLUTIONS Validation Checking The Upload process does a number of validation checks which are as follows 1 Confirms the Version number in the Template file matches the one defined in the application This ensures that the correct template is being loaded To correct the error download the correct version of the survey template and reenter copy the information over 2 Formats associated with the various spreadsheet cells are checked and if they don t match the standard an error message is returned The error message will tell you what the error is e g Numeric value cannot contain decimals what tab row and column it appears on e g Debt Financing Row 6 Column D and what the entry is that is causing the problem which will appear in brackets e g 1000 22 Examples of the errors are as follows There are errors with the submission e Numeric value 1000 22 in Debt Financing Row 6 Column D cannot contain decimals s Numeric value 100
49. and Approved buttons from the bottom of the page The survey is then ready to be verified by COU If the COFO Approver is not satisfied with the survey information then they click on the Pending button to change the Survey status back to Pending so the COFO Reporter can make the necessary changes and re submit it for Approval When the COFO Approver changes the status back to Pending an email is automatically sent to the COFO Reporter advising them that the status has changed on the survey Once all of the Ancillary Survey submissions are complete COU will verify them and generate the Ancillary Enterprises Survey reporting for the current reporting year and distribute it manually to all Institutions Updated September 2014 Page 129 T I 9 Financial Health Survey The Financial Health Survey is an Excel Template form submission that is filled in by each University and uploaded into the application once it is filled out Uploading the Financial Health Survey Information The COFO Reporter at the Institution can obtain a copy of the current year s survey form from the Survey menu in the application Select the Financial Health Survey from the Survey list the following page will appear Return to Survey List Financial Health Survey Institution Wilfrid Laurier University Survey Status Un published Please click here to download the current Financial Health Survey Template Upload Survey Document Browse Upload C
50. ariance Test Type Reporting fear Template Type Description Table Column Column Heading Row Row Heading Current Previous Variance Yariance Yo Explanation Revenue 00 2009 COFO Template Revenue variance of more than 50 must be explained Table 2 H Operating Operating General Expendable Funds 16 Basic Formula Grant 3902 0 3902 100 00 Variance Explanation not required Created at 5 11 2010 10 49 4M by sysadmin Last modified at 5 11 2010 2 17 PM by algoma reporter Updated September 2014 Page 65 IGT GT SOLUTIONS The second way to review the variances is to go to the Submit Annual Report page and select the applicable Institution if more than one is available Once the Institution is selected the system will display the information for that Institution The COFO Approver can then review the Variances by clicking on the Download button beside Total Variances and opening or downloading the file to Microsoft Office Excel Submit Annual Report Institution Algoma University Year 2012 20135 Type COFO Template Document Browse Vanance Validation Validation and Variance Upload COFO Annual Report Submission Status Submission Status Ready For Approval Variance Checks Yes Total Validation Errors Total Variances Download lt Variances Requiring Explanation Variance Analysis by Table Downkad Financial Statements Uploaded Notes The docum
51. ate can be re uploaded as many times as necessary to correct the errors Note each upload overwrites the previous upload Updated September 2014 Page 132 TGT TGT SOLUTIONS Submitting the Financial Health Survey for Approval Ready for Approval Once all of the errors are corrected in the upload file the Button will appear on the Financial Health Survey page Return to Survey List Financial Health Survey Institution McMaster University Survey Status Pending Please click here to download last uploaded survey Upload Survey Document E Browse Upload Cancel If the COFO Reporter is satisfied with the survey information they will click on the Ready for Approval button to change the Survey status to Ready for Approval The status will change an email will be sent to the COFO Approver and the Financial Health Survey page will not allow any more file uploads Return to Survey List Financial Health Survey Institution Nipissing University Survey Status Ready For Approval q ________ Please click here to download last uploaded survey Cancel Updated September 2014 Page 133 TGT SOLUTIONS Approving the Survey It is now up to the COFO Approver to review the University s submission and submit it as Approved to COU To complete the approval the COFO Approver logs into the COU COFO Online Reporting application and selects the Surveys menu item From the Survey menu
52. ate that the most economical transportation must be used and reimbursement is limited to the cost of it a Yes The following questions relate to your institution s policy on hospitality 1 Please provide the link to your institution s policy on hospitality 2 Is alcohol an eligible expense as part of a hospitality event a Yes b No Approved Pending Once the COFO Approver has reviewed the survey and is in agreement with the information entered they click on the Approved button at the bottom of the page This will change the Survey status to Approved and remove the Pending and Approved buttons from the bottom of the page The survey is then ready to be verified by COU lf the COFO Approver is not satisfied with the survey information then they click on the Pending button to change the Survey status back to Pending so the COFO Reporter can make the necessary changes and re submit it for Approval When the COFO Approver changes the status Updated September 2014 Page 110 F I back to Pending an email is automatically sent to the COFO Reporter advising them that the status has changed on the survey Once all of the Travel Survey submissions are complete COU will verify them and generate the Travel Survey reporting for the current reporting year and distribute it manually to the Universities Updated September 2014 Page 111 TGT T SOLUTIONS T I 8 Ancillary Survey Entering Ancillary Survey Informat
53. ation Checks Completed when the Ready for Approval button is Selected 99 Submitting the Audit Survey for Approval cccssccsssceceseeceeseeceneeseeseseeneeceseeeensesennessens 99 Approving the SUV SY ercsior cee otro cereus ten vonaliavivantnunimemeaeerssaccacttetasevsuseceemnecunauieeninesaieaveancua 100 Tc WNAVOSL QUEM CY E A E EE 102 Entering Travel Survey Information ccccscccssseeeseeceeseeeeseesenseeeeseeceseseeneesensesenseesoaees 102 Validation Checks Completed when the Confirm Submission button or the Ready for Approval button is SeleCted cceccceesecseeeeeeseeseeessesenseeeneeeneeeeassenseoesesonseneaseonseseaseoeees 106 Submitting the Travel Survey for Approval cccsseeceneeeceeecenseeceseeeenseseasescenesonneesens 108 8 Ancillary SUP VOY soiien onien aeaee 112 Entering Ancillary Survey Information ccccssecsesseeesseeceseesenseeeeseecenseeeneeseaseseeneesenees 112 Submitting the Ancillary Survey for Approval ccccsssecsssseeeeneeeeseeeeeeeeeaeeeeeneseeseeeaeeneas 123 Printing the Ancillary SUV OY ics ccicsecte case cesececcans uesmetiawewsvewoueneuttpusatcancnineutaestacseecessectaneeatex 123 Printing or Viewing the Previous Survey Submission ccccceeeeeeeeeeeeeeeeeeeeeneeseeeneeees 125 Approving the Survey sisesciccccanetcsicedesccne seme vsieccusseusernevenvetsndonaaneessiwensanoneaiecctaweusreussenesenseenss 127 9 Financial Health Survey
54. ayed on the page To display additional information such as when the variance was created when it was last modified and who last modified it click on the item under Test Type for the variance that is to be reviewed Submit Report aeia COU Online Reporting gt Variance Report Variance Report Documents a COFO Templates a Annual Report Files a Completed Reports Reports a Validation Report a Variance Report Template Types a Reporting Years a Submission Status a Institutions a Processing Test Annual Report Submission Variance Checks algama University Filter By Institution Test Type Reporting Year Revenue 2008 7009 2008 2009 Revenue Revenue 2008 7009 Updated September 2014 Institution WP Algoma University Algoma University Algoma University Description Table Rom Revenue Table 2 16 variance of mare than 50 must be explained Revenue variance of more than 50 must be explained Revenue variance of more than 50 must be explained Row Heading Column Basic Formula H Grant Other MTCU Grants amp Contracts Okher MTU Grants amp Contracts Column Heading Current Operating Operating General Expendable Funds 3 902 Operating Operating General Expendable Funds Entities Consolidated Sponsored Research Restricted Expendable Funds Page 64 The following page will appear displaying the additional information V
55. click on the View hyperlink on the left hand side of the page to select the Financial Health Survey The following page will appear Survey Response Return to Survey List Financial Health Survey Institution Nipissing University Survey Status Ready For Approval Please click here to download last uploaded survey Appraved Pending Cancel The COFO Approver can click on the Please click here to download last uploaded survey to review a copy of the submission or obtain a copy from the Reporter Once the COFO Approver has reviewed the survey and is in agreement with the information entered they click on the Approved button at the bottom of the page This will change the Survey status to Approved and remove the Pending and Approved buttons from the bottom of the page The survey is then ready to be verified by COU If the COFO Approver is not satisfied with the survey information then they click on the Pending button to change the Survey status back to Pending so the COFO Reporter can make the necessary changes and re submit it for Approval When the COFO Approver changes the status back to Pending an email is automatically sent to the COFO Reporter advising them that the status has changed on the survey Once all of the Financial Health Survey submissions are complete COU will verify them Updated September 2014 Page 134 TGT TGT SOLUTIONS Reviewing Previous Financial Health Submissions As the Financial Health Survey
56. dated September 2014 Page 120 TGT TGT SOLUTIONS Answer all of the questions and Save the page The information entered will appear on the Printing tab in the entry grid Other Tab To enter information about other Ancillary Operations offered by the Institution click on the Add New Operati f EW Operation hyperlink 1 Enter other ancillary operations Operation name Gross revenue Fee structure Are financial surpluses deficits carried over in an ancillary fund Add New Operation The following box appears Other Operation Gross revenue Are financial surpluses deficits carried over held in an ancillary fund a Yes b No Which fund is it transferred to Answer all of the questions and Save the page The information entered will appear on the Other tab in the entry grid 1 Enter other ancillary operations Operation name Gross Fee structure Are financial surpluses deficits revenue carried over in an ancillary fund Edit Campus Card 77 630 Fee per card of 10 00 Yes Add New Operation Updated September 2014 Page 121 TGT T SOLUTIONS T I To edit the information or to remove it completely click on the Edit hyperlink beside the Operation Name to update or remove the information Validation Checking As each tab is reviewed and the questions answered you have the option of reviewing the answers for completeness and fixing any errors noted by the system To do so click o
57. e bbbb Admin Approver CSAO FRC Guest Reporter Survey Reddy Smith Email aaa tgtsolutions com carol mcnall tgtsolutions com carol mcnall tgtsolutions com carol mcnall tgtsolutions com carol mcnall tgtsolutions com carol mcnall tgtsolutions com cmcnall tgtsolutions com carol mcnall tgtsolutions com carol mcnall tgtsolutions com carol mcnall tgtsolutions com Institution Algoma University Algoma University Algoma University Algoma University Algoma University Algoma University Algoma University Brock University Knox College Search Active Roles COU Admin COFO Admin COFO Survey COFO Approver COFO Survey COFO Survey CSAO Members FRC Members COFO Guest COFO Reporter COFO Survey COFO Reporter COFO Survey COFO Approver COFO Guest COFO Reporter COFO Admin COFO Reporter gt Page 8 TGT TGT SOLUTIONS When the UserAdd page appears enter the User Information The format for the User name should be first initial last name For example John Smith would be jsmith This is noted on the User Add page for reference The COU Administrator can select from the entire Institution list while the COFO Administrator s Institution will default automatically in the Institution box Enter a password for the new user keeping in mind that it follows the COU password standards The password standard is noted on the User Add page beside the Pas
58. e form for reference for each question General information to keep in mind when filling out the form is listed at the top of the page At various points on the page Information buttons are included to provide additional information about that specific row To view the information place your cursor over the information button and a text box will appear with the applicable information Audit Fees Charged to Universities of Ontario Institution Guelph University of Survey Status Un Published nclude amounts expensed during the year Exclude GST HST but include out of pocket expenses If when filling out the surv esing Or incorrect for the prea cg a a Ne hl lt Regular Audits should include general funds trust funds capital or plant funds and ancillary enterprises Costs of special audits which were not broken out in the audit Regular Audits invoice i e included with the cost of regular audits should be calculated or estimated and reported Provincially Require separately on rows 3A or 3B Enrolment Two sections on the Audit Survey 2c Other Provincial and 3b Total Other Special contain detail rows listing information on the audits done in previous years These sections also contain options to insert new rows using the dd new audit row hyperlink To remove a row added to either of these sections by mistake click on the button that appears at the front of the new row Other Provincial Ontario Stud
59. e new page to print the survey form nitp cousit tetsolutions com sites Ke poris Survey Survey ZUREs ponse aspx surveyid Jttyearid 1U Windows Internet Explorer about blank Ancillary Enterprises Institution Ryerson University Survey Status Pending General Ancillary operations are typically provided on a fee for service basis and include revenues and expenses of sales producing non teaching areas such as the bookstore food services residences parking university press publishing property rentals university facility rentals theatres and conference centres Does your Institution have Ancillary Operations to report on a Yes b No Bookstores Bookstores include all trade textbooks stationery and computer sales Does your Institution have Bookstores to report on a Yes b No Is the bookstore operated solely by the institution a Yes b No Who is the contractor Is there a separate student operated bookstore a Yes Once the survey is printed close the print page Updated September 2014 Page 124 TGT TGT SOLUTIONS Printing or Viewing the Previous Survey Submission Given the amount of information on the Ancillary Survey an option to view or print the previous survey submission for the University or Affiliate has been added To view or print the previous survey click on the Previous Survey link provided on the top left of the survey page Ancillary Enterprises Ins
60. e system to add the New User If a field is missing the system will prompt you to complete the required fields Updated September 2014 Page 9 TGT TGT SOLUTIONS Email Notification to a New User Once a new User has been defined and the User Add page saved the application will send an email to the new User with their User ID and their Password using the email address entered when the User was setup The email will come from cousupport tgtsolutions com and will contain the following information COU Reporting cousupportitgtsomutions com To carol mena tg tokutons com Le Subject COFO Online Reporting New User Welcome to the COFO Online Reporting System Your User Name is cou reporter Your Password is Password Note Please ensure vou enter the password exactly as shown Once vou have successfully logged in you can change your password by clicking on the Welcome then My Settings link at the top of the page within the COFO Online Reporting System Thank vou COU Updated September 2014 Page 10 TGT TGT SOLUTIONS Inactivating or Re activating a User Log in to the COU COFO Online Reporting Application as the COU Administrator or the COFO Administrator The COU Administrator can update all users in the application whereas the COFO Administrator can only update users associated with their Institution From the Home Page select the Users menu option COFO Online Reporting Submit Annual R
61. ear over year and whether the change is equal to and greater or less than 100 000 Once the process is complete the Submit Annual Report page will indicate what differences were found for each of the checks When the Validation and Variance option is selected the Updated September 2014 Page 33 system will indicate that this option was chosen by putting a Yes beside the Variance Checks Status 4 COFO Online Reporting Submit Report Bgl esas Submit Annual Report Institution York University 7 Year Document SSS Browse Varniance Validation Validation and Variance na Template Types Upload Reporting Years Document Processed Submission Status Document Uploaded o Validation Complete Institutions Variance Checks Complete File successfully uploaded COFO Annual Report Submission Status Submission Status Variance Checks Total Validation Errors Cownload Total Variances Download Variances Requiring Explanation Financial Statements Uploaded Updated September 2014 Page 34 IGT GT SOLUTIONS Reviewing Previous Template Submissions As each reporting year is rolled over for the next reporting year to start all of the annual template files submitted are moved to the Report Files History page which can be accessed from the Document menu section COFO Templates Annual Report Files 2009 2010_Algoma_Report Report Files History Financial Health Survey 2003 2010 _Brescia_Re
62. eeeeesees 68 Step 1 Preparing to upload the Elimination Template ccscesseesseeseeeseeeneeees 68 Step 2 Uploading the Elimination Entry cccecseeeseeeeeeeeneeeeneeeneeensesenseeeseneneees 69 Step 3 Changing the Status to Ready for Approval csssceeseeeeseceneeenseseneeeneees 71 Step 4 Approving the Elimination Template cccccssecseeeesseeensesenseeneeeeeeseneees 73 3 COU Verifying the COFO Template or Elimination Entry 77 A Stall ME DORUAG erosoan E EE 79 Downloading Reports sissors EER 80 Entering Criteria to Run a REpOlt ccccccsccessessseeeeeseeeeseseeeesesenseoeneeeesonsesenseoeneeonsesaseoeaes 86 RUNNIN Ne REDO sires noses coerce cree a a aaa 90 Updated September 2014 Page 3 TGT TGT SOLUTIONS Exporting the Report Data nis cieccie clase seeetee cesedenctedetednccdeteancedeteaveendevanteaddadensddeantencenmeeansadenene 91 Obtaining Different Reporting VieWS cccccsseecesesceseeseseeeeneecensesensesenseseeseeeensesonsesoees 92 Overview of Survey Functionality cccccssseeecsseescenseeeeeseescenseesoeseseaseeseeaseesoeneessoanees 93 0 AUO SUIN OY Anon nee ere eee eee ee ee 95 Entering Audit Survey Information ccccceseeceseeeeseesenseeeeseesenseeeeseeeaseseensesonseseeseesonnenes 95 Validation Checks Completed when the Survey page IS saved cccessceeeeeeeeeeeeeneeeeenes 98 Valid
63. ent Opportunity Trust Fund Ontario Trust for Student Support Public Service Pension Supplement OMAFRA Agreement 0 Add new audit row It is important to note that the button will only appear on rows that do not contain historical information Rows with historical information cannot be removed or updated without contacting COU Question 6 has a drop down list associated with the box that contains a list of Auditors used in previous years If the Auditor used by the University does not appear in the list the Other Updated September 2014 Page 95 TGT TGT SOLUTIONS option is to be selected Once selected a second text box will appear to enter the Auditor information Other Auditor in current reporting year The COFO Reporter at the University will open the Audit Survey form to enter the applicable information for the current year Return to Survey List Audit Fees Charged to Universities of Ontario Institution Laurentian University Survey Status Un Published Include amounts expensed during the year Exclude GST HST but include out of pocket expenses If when filling out the survey for the current year you find information is missing or incorrect for the previous year please contact Marina Piao at COU to make the adjustments Actual Actual Actual 2008 09 2009 10 2010 11 Regular Audits Jy 51 000 0 Provincially Required Audits Enrolment Capital Other Provincial Ontario Researc
64. ent is Ready For Approval by a COFO Approver The Variance report is Excel appears as follows fe Test Type 1 Test Type Reporting Yea Institution Description op Row Row Headi 2 Revenue 2008 2009 Algoma Universit Revenue variance of more than 50 must be explained Table 2 16 Basic Form Revenue 2008 2009 Algoma Universit Revenue variance of more than 50 must be explained Table 2 17 Other MTC Revenue 2008 2009 Algoma Universit Revenue variance of more than 50 must be explained Table 2 17 Other MTE 5 Revenue 2008 2009 Algoma Universit Revenue variance of more than 50 must be explained Table 2 17 Other MTE Ea Revenue 2008 2009 Algoma Universit Revenue variance of more than 50 must be explained Table 2 17 Other MTC 7 Revenue 2008 2009 Algoma Universit Revenue variance of more than 50 must be explained Table 2 17 Other MTC Revenue 2008 2009 Algoma Universit Revenue variance of more than 50 must be explained Table 2 18 Other Onta Revenue 2008 2009 Algoma Universit Revenue variance of more than 50 must be explained Table 2 18 Other Onta 10 Re ee noe 2009 Algoma Universit Revenue variance of more than 50 must be explained ale a Other Cntar Updated September 2014 Page 66 TGT TGT SOLUTIONS Once the COFO Template Report Variances and Financial Statement file have been reviewed and the COFO Approver is satisfied that it is ready for approval they change the status on the Submit Annual Report page by clicking
65. eport COFO Templates Institution Algoma University a Annual Report Files Year 2012 2013 Report Files History Type COFO Template a Financial Health survey History Document E Variance Validation Validation and Variance a Validation Report Variance Report system Reports COFO Annual Report Submission Status Financial Health Submission Status Un Published survey Interactive Reporting Variance Checks Total Validation Errors Total Variances Template Types l Ei Variances Requiring Explanation a Reporting Years e Submission Status e Insttutons Variance Analysis by Table Financial Statements Uploaded Notes The document is not uploaded yet Updated September 2014 Page 11 TGT SOLUTIONS When the User List page appears click on the Username of the User that you are going to inactivate or re activate The Active column on the right indicates the User s current status Users SS Add New User Show 10 YY entries Search First Name Last Name Email Institution Active Roles Username aaaa aaaa bbbb aaa tatsolutions com Yes COU Admin COFO Admin COFO Survey COFO Approver COFO Survey COFO Survey CSAO Members algoma admin Algoma Admin carol mcnall tgtsolutions com Algoma University Yes algoma approver Algoma Approver carol mcnall tgtsolutions com Algoma University Yes algoma csao Algoma CSAO carol mcnall tgtsolutions com Algoma Universit
66. eport Files Year 2011 2012 Report Files History Type COFO Template Financial Health survey History Document Browse Variance Validation Validation and Variance Validation Report Unload ploac Variance Report COFO Annual Report Submission Status Submission Status Reporting Years Variance Checks s Submission Status Total Validation Errors UGownload Institutions Total Variances Download Variances Requiring Explanation Template Types Financial Statements Uploaded Notes The following page will appear Note only the University the COFO Approver has access to will appear on the Survey Response List page ia Survey Response List Brock University All Surveys Survey Institution Year Submission Status PAL View Ancillary Enterprises Brock University 2009 10 Ready For Approval 9 27 2011 8 04 17 PM Updated September 2014 Page 127 TGT SOLUTIONS Click on the View hyperlink on the left hand side of the page to open the Ancillary Survey page The COFO Approver cannot change any of the values entered they can only view them urvey Response Return to Survey List Ancillary Enterprises Institution Toronto University of Hart House Survey Status Ready For Approval Previous Survey Print General Bookstores Retail Stores Food Services Beverages Residences Conferences Seasonal Conferences Year Round Parking Printing Other Bookst
67. eporting Years Submission Status Institutions Updated September 2014 Submit Annual Report Institution Algoma University Year 2010 2011 w Type COFO Template Document Variance Validation Validation and Variance vw Upload COFO Annual Report Submission Status Submission Status Variance Checks Total Validation Errors Total Variances Download Page 43 TGT TGT SOLUTIONS Optional Analysis Step Variance Analysis File and Filter Function for All Tables Once a template for the current reporting year has been uploaded into the application a Variance Analysis Report comparing the current year to the previous year for the institution is available on the Submit Report page The report is available when the _Downiest button appears beside the Variance Analysis by Table Prior to uploading a template the download button will not be visible Submit Annual Report Institution Brock University Year 2012 2013 Type COFO Template Document Browse Vaniance Validation Validation and Variance Upload COFO Annual Report Submission Status Submission Status Variance Checks Total Validation Errors Total Variances Uownlead Variances Requiring Explanation Variance Analysis by Table Download I Financial Statements Uploaded Notes The document contains variances All variances must be explained before it can be submitted for approval It is important to note that
68. equipment Not Specified ATM Not Specified Bank Not Specified Chiropractor Not Specified Clothing and sundry Not Specified Coffee shop Not Specified Convenience store Not Specified Dental office Not Specified Design centre Not Specified Dry cleaners Not Specified Electronic store Not Specified Insurance agency Not Specified Updated September 2014 Page 116 TGT TGT SOLUTIONS For each type of outlet that the Institution offers click on the Edit hyperlink beside the outlet name to answer the questions regarding this outlet type Once selected the following box appears Type of Outlet Total Square foot area covered Number of retail outlet locations Are the outlets university operated b No Is the space leased to the retail d Wes outlets b No Calculation of Lease Cost a Flat Fee b Flat Fee per sq foot c of sales d Cost Recovery Answer all of the questions and click on the Save button If the information is entered incorrectly for an outlet click on the Delete button to remove the information Updated September 2014 Page 117 TGI SOLUTIONS Once saved the information entered will display on the Retail tab for ease of reference and review Type of Outlet Total Number of Are the If outlet is contracted out Is the space If leased to retail outlets Square foot retail Outlets to whom leased to indicate Calculation of area outlet university the retail lease cost covered locations
69. es All COFO Roles are restricted to the associated Institution and affiliates where applicable 1 COFO Admin Access to Add Users for their Institution as COFO Reporters COFO Approvers and COFO Guests Ability to Maintain users for their Institution unlock change password inactivate or reactivate 2 COFO Reporter Access to upload and delete completed Excel Templates Ability to enter edit delete variance comments as required Change the Submission status on a template upload to Ready for Approval There can be multiple reporters per institution but only one at a time can submit data for processing 3 COFO Approver Access to view data belonging to their institution Access to view data belonging to any of the affiliates that are associated with their institution Access to authorize his her institution s data submission to the Approved level Updated September 2014 Page 5 TGT SOLUTIONS 4 COFO Guest Ability to view data in the system for the Institution assigned The COFO Administrator can add these users for their institution If these users are in the system already under another institution then they will have to be given a second User name for the COFO Guest access 5 COFO Survey Ability to access the Survey related pages This user role is used in connection with the COFO Reporter and COFO Approver If a COFO Reporter has the survey role they will be able to enter survey information for
70. f year as per PRIOR YEAR S COFO REPORT Prior Period Adjustments Balance End of the Year PER FINANCIAL STATEMENTS Unrestricted Internally Restricted Investment in Capital Assets Externally Restricted Total gt ni Table 14 Table 2 Table 3 4 Table 4 Table 5 Table 6 4 Table Table 10 Table t1 Table1z ooo E Updated September 2014 Unappropriated Operating amp Other Operating amp Other Non Credit General 6223518 6246140 17539 40161 164569 39534 164896 95640 797286 12193 1070015 1070013 0 Oo O 1070015 Appropriated Non Credit General Expendable Funds Expendable Funds 39834 39834 0 1312029 7912 1285425 0 1285425 0 0 1285425 Unappropriated Ancillary General Expendable Funds 696226 615335 416 50475 40471 T56 39218 32537 163043 0 156362 161023 4661 O 0 156362 Appropriated Ancillary General Expendable Funds a 161729 0 162515 a 61402 101033 a 162515 Sponsored Research Restricted Expendable Funds 24735318 2425534 597 46507 4266 oO 51153 52512 112948 122 111467 3609 110894 0 4182 111467 Trust Restricted Expendable Funds 360575 362435 261 2124 17265 Oo 19392 52376 275923 0 204153 21519 164361 0 1822ra 204153 Capital Restricted Expendable Funds 513274 foraig 274045 183037 971008 13
71. g fields are incomplete or invalid Section 5 Question 2 is required The validation checks completed on the page and the corresponding error messages returned are listed in the table below Section Validation Validation Check ErrorMessage ErrorMessage sen O eae be answered Section 1 Question 1 a is required Question 2 Must be answered Section 1 Question 2 is required Date must be Section 1 Question 2 must be a date MM DD YYYY format MM DD YYYY Must be answered Section 1 Question 3 is required Question 4 Must be answered Section 1 Question 4 is required If 4 a is selected a Section 1 Question 4 please specify maximum kilometrage maximum kilometrage amount paid by must be entered your institution Must be answered Section 1 Question 5 is required Updated September 2014 Page 106 t G j F O Ras te i O Fai wI Question 1 A minimum of 1 Section 2 Question 1 a minimum of selection is required one choice is required A maximum of only two Section 2 Question 1 a maximum of choices is allowed only two choices is allowed If 1a is selected at least Section 2 Question 1a please specify one per diem amount a Fund must be entered as well as a Fund name Section 2 Question 2 please provide at least one diem amount If 1 b is selected Section 2 Question 3 is required when questions 3 4 and 5 Section 2 Question 1 b is selected must be answered Section 2 Question 4
72. ge COFO UO FINANCIAL REPORT OF ONTARIO UNIVERSITIES STATIC REPORTS CUSTOMIZED REPORTS Table Distribution Table 4 SUMMARY OF EXPENSE BY FUND AND OBJECT OF EXPENSE Data by Values Institution Reporting Year Fund Source Filter by Single Institution Filter by single Year Fund as a Column Source as a Row Total for System 2008 2009 Select Funds Select Sources Run Report Reset To Default Settings Excel XLS v 2 043 129 16 101 2 059 230 0 101 870 347 312 17 882 365 194 0 326 550 1 754 659 57 867 1 812 526 178 554 240 290 4 145 100 91 850 4 236 950 178 554 668 710 864 954 12 497 877 451 38 181 77 674 5 010 054 104 347 5 114 401 216 735 746 384 160 656 171 160 827 0 2 067 153 344 154 838 19 902 192 811 Updated September 2014 Page 90 TGI SOLUTIONS Exporting the Report Data The User then has the option to Export the data to Excel or CSV by clicking on the dropdown beside the Export button and selecting Excel XLS or Text CSV and then clicking on the Export button The file can then be opened or saved OFO UO FINANCIA PORT OF ONTARIO UN STATIC REPORTS CUSTOMIZED REPORTS Table Distribution Table 4 SUMMARY OF EXPENSE BY FUND AND OBJECT OF EXPENSE Data by Values Institution Reporting Year Fund Source Filter by Single Institution hd Filter by single Year v Fund as a Column Source as a Row Total for System 2008 2009 E Select Funds Select Sources Run Report Reset To Default Settings Excel XLS M Excel XL
73. h amp Development Challenge Fund Ontario Trust for Student Support Special Audits Pension Plans Total Other Special J Centre national de formation en sant Internal Audits 0 Total 0 Auditor in current reporting year Did you change auditors within the last two years C Yes No Do you expect to tender within the next two years C Yes No Save As information is added the COFO Reporter can click on the Save Button at the bottom of the page to save the changes made to the survey so far After the initial save of the form the Survey Status will change from Un Published to Pending noted at the top of the page and on the Survey Response List page and a Ready for Approval button will appear on the bottom right hand side of the page Updated September 2014 Page 96 TGT TGT SOLUTIONS Audit Fees Charged to Universities of Ontario Institution Algoma University Survey Status Pending lt _ Auditor in current reporting year Deloitte v Did you change auditors within the last two years C Yes No Do you expect to tender within the next two years Yes C No Save Ready for Approval Updated September 2014 Page 97 TGT TGT SOLUTIONS Validation Checks Completed when the Survey page is saved It is important to note that there are a number of validation checks being done when the Audit Survey page Is saved If certain criteria are invalid or missing the User will receive erro
74. has any Ancillary Operations to report on If the answer is No across all of the tabs of information then No is selected on this tab and the survey is complete and Ready for Approval If the Institution offers at least one of the Ancillary Services listed e g Parking then the answer to this question must be Yes lf at anytime the answer on the General tab is changed from Yes to No then all of the answers entered for the Institution are cleared but not saved to the application until the Save button is selected Updated September 2014 Page 112 I Locking the Survey during Updates Since there may be a number of users contributing to the Ancillary Survey information a locking feature has been added to the Survey page to ensure that users don t overwrite other user s information during entry To start entering survey information the Please click HERE to edit the survey must be selected Return to Survey List Please click HERE to edit the survey Ancillary Enterprises Institution Ryerson University Survey Status Un published Once selected the survey will be locked by that user for 30 minutes As the Save or Confirm buttons are used the counter resets to another 30 minutes lf another user attempts to update the Ancillary survey while it is locked the following message appears Survey Response Return to Survey List This survey is currently locked by Ryerson Reporter
75. he COFO Online Reporting System and login using the new password below Password j R Meogp y4 Note Please ensure you enter the password exactly as shown Once you have successfully logged in you can change your password by clicking on the Welcome then My Settings link at the top of any page within the COFO Online Reporting System Thank you Cou From the Forgot your Password page there is a hyperlink back to the COFO Online Reporting Application login page which the User can use Lo oe E Thank you Your password has been emailed to you Return to the login page Once the COFO Online Reporting Application login page appears they reenter their User name and the new password provided in the email A cut and paste of the password to the sign in page works well as the passwords provided by the application are quite cryptic Updated September 2014 Page 19 TGT TGT SOLUTIONS If the email address entered is associated with more than one User name in the application COFO Reporter and a COFO Guest at another Institution then the application will return the following message when the Forgot your Password option is selected Forgot your Password To reset your password enter the email address associated with your account below and then click Reset Password You will receive an email with a new password within a few minutes usemame L_ Reset Password More than one user account exists for t
76. he application To unlock a User log in to the COU COFO Online Reporting Application as COU Administrator or the COFO Administrator From the Home Page select the Users menu option COFO Online Reporting 4 COFO Online Reporting Submit Report poles Submit Annual Report COFO Templates Institution Algoma University a Annual Report Files Year 2012 2013 Report Files History DoE COFO Template s Financial Health survey History Document Variance Validation Validation and Variance a Validation Report Uol oad Variance Report System Reports COFO Annual Report Submission Status Financial Health Submission Status Un Published survey Interactive Reporting Variance Checks Total Validation Errors Total Variances Template Types aE l Variances Requiring Explanation Reporting Years e Submission Status Insttutons Variance Analysis by Table Financial Statements Uploaded Notes The document is not uploaded yet Updated September 2014 Page 23 TGT TGT SOLUTIONS When the User List page appears click on the Username to be unlocked Users Add New User Show 10 entries Search First Name Last Name Email Institution Active Roles Username aaaa aaaa bbbb aaa tgtsolutions com Yes COU Admin COFO Admin COFO Survey COFO Approver COFO Survey COFO Survey CSAO Members algoma frc Algoma FRC carol mcnall tgtsoluti
77. he distance normally travelled to the workplace 4 Is there a maximum kilometrage amount paid by your institution a Yes Please specify b No O 5 Does your policy state that the most economical transportation must be used and reimbursement is limited to the cost of it a Yes b No T Updated September 2014 Page 102 TGT TGT SOLUTIONS Section 2 is as follows It is important to note that depending on the response to question 1 questions 2 to 5 may be greyed out on the page as they do not need to be answered Section 2 Meals The following questions relate to your institution s reimbursement policy on the limitations on the amount of reimbursement paid for meals during business travel 1 Does your institution reimburse for meal expenses based on a A per diem rate d Please specify which fundis it applies to b Actual expenses with a dollar maximum C c Actual expenses without a dollar maximum Pi Updated September 2014 Page 103 TGT TGT SOLUTIONS Section 3 and 4 are as follows It is important to note that for Section 4 the selections available in part b will be greyed out if a Not permitted is selected The following questions relate to your institutions reimbursement policy on the limitations on the amount of reimbursement paid for hotel or motel accommodation expenses for business travel 1 Are travelers required to request the lowest available rate when booking for example Government o
78. he email address carol mcnall tgtsolutions com Please enter the username for the account you wish to reset or contact the COU Security Administrator Return to the login page At that point the system will ask the User to enter the Username they want the application to change the password on If a User has two User names in the application they will have to reset the password on each User name account if they cannot remember either Updated September 2014 Page 20 TGT Users Changing their own Password Log in to the COU COFO Online Reporting Application Once logged in the system will display the Home Page Click on the drop down box in the upper right hand corner of the screen beside the Welcome message and select My Settings i al ee Wm OFO Online Reporting This Site C y My Settings N Report WELE L a J i LOgOU T rememo a Submit Annual Report ents password Log Institution Brescia University College My Y 2010 2011 w uoe ANAD Windows Type COFO Template v SharePoint Services Document Browse Variance Validation Validation and Variance v The My Settings Change Password page will appear Enter the new Password and the Confirm Password information and click on the Update User button The Password must conform to the standards defined by COU The standard is noted on the page beside the password boxes for ease of reference i M
79. i EM Pa GET Annual Report Files SF COFO_template_2010 1 Do you want to open or save this file Validation Report Name COFO template 2010 11 xIs fl Variance Report Type Microsoft Office Excel 97 2003 Worksheet 443KB a System Reports From cousit tgtsolutions com Template Types Reporting Years Submission Status Institutions Always ask before opening this type of file While files from the Internet can be useful some files can potentially harm your computer IF you do not trust the source do not open or save this file What s the risk Updated September 2014 Page 30 TGT TGT SOLUTIONS Template Upload Process Overview When the Institution has completed the update of the Templates in Excel they are ready to upload them into the COU COFO Online Reporting Application When entering information into the excel templates the following items must be kept in mind All numbers are to be entered as even thousands No decimals are to be entered in either template Do not enter dashes or spaces in any excel entry fields Do not enter negative numbers in the Elimination template They are added by the application during the upload process During the template upload process the application completes a series of checks and validations to ensure the integrity of the template submission The first check that the system completes is the Version Control Check Version Control Check If the version of the
80. ile being uploaded which is restricted to pdf and tif file extensions Updated September 2014 Page 60 TGT TGT SOLUTIONS Once uploaded the application will update the Financial Statements Uploaded information row under the report submission status section Submit Annual Report Institution Carleton University Year 2010 2011 Type Financial Statements Document Browse Vaniance Validation Validation and Variance Upload Document Uploaded COFO Annual Report Submission Status Submission Status Ready For Approval Variance Checks Yes Total Validation Errors o Total Variances Downkad Variances Requiring Explanation Financial Statements Uploaded Notes The document is Ready For Approval by a COFO Approver Only one Financial Statement file is required to allow the submission to be Approved But if the Institution provides more than one Financial Statement file to COU additional files can be uploaded using the process noted above As each incremental file is uploaded the file count will increase for the Financial Statements Updated September 2014 Page 61 Step 8 Approving the COFO Template Report Once the template has been submitted for Approval the COFO Approver has to approve it for it to go to COU as the completed version The COFO Approver signs into the COU COFO Online Reporting Application Once logged in they go to the Documents menu and select the Annual Report
81. ion The Ancillary Survey form is comprised of eleven sections or tabs Each tab contains questions that must be reviewed and answered if they apply to your Institution The COFO Reporter or the COFO Survey Ancillary user at the Institution will open the Ancillary Survey form to enter the applicable information for the survey year The Ancillary Survey form will appear Survey Response Return to Survey List Please click HERE to edit the survey Ancillary Enterprises Institution Ryerson University Survey Status Un published Previous Survey Print General Bookstores Retail Stores Food Services Beverages Residences Conferences Seasonal Conferences Year Round Parking Printing Other Ancillary operations are typically provided on a fee for service basis and include revenues and expenses of sales producing non teaching areas such as the bookstore food services residences parking university press publishing property rentals university facility rentals theatres and conference centres Does your Institution have Ancillary Operations to report on a Yes b No The tabs are noted across the top of the page As the tabs are selected the colour changes to identify the tab being worked on At the top of each tab there is some verbiage describing the activity that is to be included when answering the questions on each tab The General tab only contains one question which basically determines whether or not the Institution
82. ion checks and change the status to Ready for Approval Once the status is changed the Save Confirm Submission and Ready for Approval buttons will be removed from the bottom of the page and no additional changes are allowed At this point an email is automatically sent to the COFO Approver advising them that the survey is Ready for Approval The survey is then ready to be reviewed and Approved by the COFO Approver Updated September 2014 Page 108 TGT TGT SOLUTIONS Approving the Survey It is now up to the COFO Approver to review the University s submission and submit it as Approved to COU To complete the approval the COFO Approver logs into the COU COFO Online Reporting application and selects the Surveys menu item COFO Online Reporting 4 COFO Online Reporting Submit Report Peu Submit Annual Report COFO Templates Institution Laurentian University a Annual Report Files Year 2010 2011 Report Files History Type COFO Template Document a Validation Report Variance Report Variance Validation Validation and Variance Template Types a aia COFO Annual Report Submission Status Submission Status Un Published Variance Checks Total Validation Errors Reporting Years e Submission Status a Insttutons Total Variances Variances Requiring Explanation Financial Statements Uploaded Notes The following page will appear Note only the University the COFO App
83. is required when If 1 c is selected Section 2 Question 1 b or c is questions 4 and 5 must selected be answered Section 2 Question 5 is required when Section 2 Question 1 b or c is selected Section 2 Question 4 is required when Section 2 Question 1 b or c is selected Section 2 Question 5 is required when section 2 Question 1 b or c is selected Must be answered Section 3 Question 1 is required Must be answered Section 3 Question 2 is required Must be answered Section 3 Question 3 is required Updated September 2014 Page 107 TGT TGT SOLUTIONS Question 1 Must be answered Section 4 Question 1 is required A minimum of 1 Section 4 Question 1 a minimum of selection is required if one choice is required option b is selected Question 1 Must be answered Section 5 Question 1 is required Must be a valid link Section 5 Question 1 must be a valid url Must be answered Section 5 Question 2 is required Submitting the Travel Survey for Approval Once the COFO Reporter has completed all of the sections of the Travel Survey form and they are satisfied that the information is complete they can submit the survey for approval to the COFO Approver To submit the Survey click on the Ready for Approval button at the bottom of the page Note all validation checks must be corrected for the survey status to change Once the Ready for Approval button is selected the survey form will save re confirm all of the validat
84. ission Status Insttutons Updated September 2014 Submit Annual Report Institution Carleton University na Year 2010 2011 Type COFO Template Document Browse Varniance Validation Validation and Variance we Upload COFO Annual Report Submission Status Submission Status Ready For Approval Variance Checks Yes Total Validation Errors Total Variances Downkad Variances Requiring Explanation Financial Statements Uploaded Notes The document is Ready For Approval by a COFO Approver Change Status Approved Page 73 TGT TGT SOLUTIONS The following page will appear showing the status of the template submissions 2008 2009 Ottawa_Elimination 2008 2009 Ottawa Report Ottawa University of Ottawa University of Ready For 8 16 2010 4 19 F Aporoval Elimination Entry COFO Template Ready For 8 16 2010 4 19 P Approval To review the information for an Elimination Entry that is Ready for Approval click on the applicable item under Name and the COFO Approver will be able to open it for review or save it as a Microsoft Excel file COFO Online Reporting 4 COFO Online Reporting An teport Files COFO Online Reporting gt Annual Report Files Annual Report Files Filter By Institution Name COFO Templates Annual Report Files 2010 2011 Carleton _FS_2011 04 30 Carleton University 2010 2011_Carleton_Report a Validation Report Variance Report a Template Types
85. ks Complete File successfully uploaded COFO Annual Report Submission Status Submission Status Pending Variance Checks Total Validation Errors Download Total Variances Download Variances Requiring Explanation Financial Statements Uploaded Notes The document contains validation errors All validation errors must be fixed and the Flimination Entry Form Submission Status Status Total Validation Errors Notes The document passes all validation A COFO Reporter can update the status of this submission to Ready For Approval L Change Status Updated September 2014 Page 70 TGT TGT SOLUTIONS Step 3 Changing the Status to Ready for Approval When the Change Status on the Elimination Entry is Ready for Approval the COFO Reporter will click on the Ready for Approval button to change the status from Pending to Ready For Approval Submit Annual Report COFO Templates Institution Queen s University a Annual Report Files Year 2010 2011 Type Elimination Entry Validation R t Validation Repor Sn Pp Browse Variance Report System Reports Variance Validation Validation and Variance Template Types Document Processed a Validation Complete Submission Status Variance Checks Complete aes dearer File successfully uploaded COFO Annual Report Submission Status Submission Status Pending Variance Checks No Total Validation Errors Download 7 Total Variance
86. le it will confirm that the dates entered match the MMDDYYYY format It is important to note that if the date entered does not match this format the answer will not be saved Confirm Submission As soon as the survey is saved for the first time the Status at the top of the page will change from Un published to Pending and a green message will appear telling you your responses have been saved The survey responses have been updated Ancillary Enterprises Institution Ryerson University Survey Status Pending lt Updated September 2014 Page 115 TGT TGT SOLUTIONS Since the answers to some questions on the survey require the user to answer related questions for each answer entered entry grids have been added to the survey pages to accommodate this There are four tabs that contain entry grids which are as follows Retail Tab On the Retail tab all of the various Retail outlets are listed on the left hand side of the entry grid It is important to note that only the questions for the Outlets offered by the Institution need to be answered Leave blank any outlets that are not offered by your Institution Total Number of Are the If outlet is contracted out Is the space If leased to retail outlets Square foot retail Outlets to whom leased to indicate Calculation of area outlet university the retail lease cost covered locations operated outlets Arcade Not Specified Athletic
87. le Fund Fund as a Column Reporting Year Fund Filter by single Year Fund as a Column s 2009 2010 Reset To Default Settings Select Funds F Fund as a Row Distribution Data by Values Source D Filter by single Source A Source as a Column 9 Source as a Row Page 87 TGT TGT SOLUTIONS When the Filter by a Single Reporting Year Fund or Source is selected the User has to select a single value in the drop down box below the criteria option Example of the Reporting Year options note this is restricted to the reporting years that have been run and are on line or offline if you are the COU Administrator Click on the dropdown arrow beside the year listed and select the desired year STATIC REPORTS CUSTOMIZED REPORTS Table Table 4 SUMMARY OF EXPENSE BY FUND AND OBJECT OF EXPENSE Institution Reporting Year Filter by Single Institution Filter by single Year Total for System Run Report Reset To Default Settings 2009 2010 Total for System When the select the option As Row or As Column the User has to select the criteria desired from the list of options available For example the Fund as a Column was selected so the Select Funds option is available Table Table 4 SUMMARY OF EXPENSE BY FUND AND OBJECT OF EXPENSE Institution Reporting Year Fund Filter by Single Institution Filter by single Year Fund as a Co
88. lumn Select Funds lt Total for System Updated September 2014 Page 88 TGT TGT SOLUTIONS When the Select Funds option is selected a list of the Funds for that table will be displayed Select the funds you would like to see in the report and click OK Select All Select None lt _ operating General Expendable Funds lother Non Credit General Expendable Funds Elsubtotal General Expendable Funds lancillary General Expendable Funds lentities Consolidated Sponsored Research Restricted Expendable Funds lentities Not Consolidated Sponsored Research Restricted Expendable Funds Elsubtotal Sponsored Research Restricted Expendable Funds Trust Restricted Expendable Funds lc apital Restricted Expendable Funds Hota Updated September 2014 Page 89 Running the Report Once all of the criteria have been selected click on Run Report button to generate the report based on the criteria selected COFO UO FINANCIAL REPORT OF ONTARIO UNIVERSITIES STATIC REPORTS CUSTOMIZED REPORTS Table Table 4 SUMMARY OF EXPENSE BY FUND AND OBJECT OF EXPENSE Institution Reporting Year Fund Filter by Single Institution Filter by single Year Fund as a Column Algoma University 2008 2009 Select Funds Run Report Reset To Default Settings The report information will be displayed on the bottom section of the pa
89. m Un Published to Pending noted at the top of the page and on the Survey Response List page and a Ready for Approval button will appear on the bottom right hand side of the page Travel Reimbursements for the Universities of Ontario Institution Queen s University Survey Status Pending At any time during the survey entry the COFO Reporter can click on the Confirm Submission button in the middle at the bottom of the page This will verify that the answers entered for the University meet the validation controls that have been put into place for the different questions 2 Is alcohol an eligible expense as part of a hospitality ewent a Yes b No Save Confirm Submission Ready for Approval Updated September 2014 Page 105 TGT TGT SOLUTIONS Validation Checks Completed when the Confirm Submission button or the Ready for Approval button is selected It is important to note that there are a number of validation checks being done when the Confirm Submission or Ready for Approval buttons are selected If certain criteria is invalid or missing the COFO Reporter will see error messages and the survey cannot be marked Ready for Approval until the corrections are made The error messages will appear on the bottom of the page and the question that failed the controls will be marked in red An example is shown below 2 Is alcohol an eligible expense as part of a hospitality event a Yes b No The followin
90. n the Confirm Submission button at the bottom of the page This does take several seconds as it validates the entire survey If any issues are noted with the answers provided on any of the tabs three things will occur i The tab containing errors will appear in red at the top of the page li The question will appear in red that has to be reviewed iii Error messages listing all of the errors will appear at the bottom of each tab for reference to describe what the error is Bookstores Retail Stores Food Services Beverages Residences Conferences Seasonal Conferences Year Round Parking Printing Other Bookstores include all trade textbooks stationery and computer sales Does your Institution have Bookstores to report on a Yes b No 1 Is the bookstore operated solely by the institution a Yes b No Who is the contractor 2 Is there a separate student operated bookstore a Yes The following fields are incomplete or invalid a Section 2 Bookstores Question 1 is required a Section 2 Bookstores Question 2 is required a Section 2 Bookstores Question 3 at least one value is required Updated September 2014 Page 122 T I Submitting the Ancillary Survey for Approval Once the COFO Reporter has completed all of the tabs on the Ancillary Survey form and they are satisfied that the information is complete they can submit the survey for approval to the COFO Approver To submit the Sur
91. nces Requiring Explanation Variance Analysis by Table Download Financial Statements Uploaded Notes The document is Ready For Approval by a COFO Approver Updated September 2014 Page 59 TGT TGT SOLUTIONS Step 7 Uploading the Financial Statement Reports Prior to submitting the Template submission for Approval the Financial Statements for the Institution for the current reporting year have to be uploaded into the COU COFO Online Reporting Application To upload the Financial Statement file s log into the COU COFO Online Reporting application and on the Submit Annual Report page click on the Type dropdown option and select the Financial Statements option Submit Annual Report Institution Carleton University Year 2010 2011 Type COFO Template a COFO Template Document Elimination Entry Variance Explanation Upload Variance Validation age tte RS Wie Upload COFO Annual Report Submission Status Submission Status Ready For Approval Variance Checks Yes Total Validation Errors Total Variances Downkad Variances Requiring Explanation Financial Statements Uploaded Notes At least 1 Financial Statement needs to be uploaded for an institution before the COFO Template can be submitted for approval Click on the Browse button to locate the Financial Statement file s on your desktop network Then click on the Upload button to upload the file The system will only validate the type of f
92. nd Parking Printing Other Bookstores include all trade textbooks stationery and computer sales Does your Institution have Bookstores to report on a Yes b No Back Updated September 2014 Page 114 TGT TGT SOLUTIONS If you select Yes to the question that all of the related questions on the page will appear General Eookstores Retail Stores Food Services Beverages Residences Conferences Seasonal Conferences Year Round Parking Printing Other Bookstores include all trade textbooks stationery and computer sales Does your Institution have Bookstores to report on a Yes b No Is the bookstore operated solely by the institution a Yes b No Who is the contractor Is there a separate student operated bookstore a Yes New books are sold Used books are sold Both new and used books are sold b No 3 Institution s gross square footage of space utilized for a Selling of books b Storage office and other What is the dollar value of sales of the following a Core text books b Trade books c Used books All of the questions on the tab must then be answered The Save button at the bottom of the page can be selected at any time and the answers entered for the questions so far will be saved for the Institution The Save button confirms that the answers populated prior to the Save button match the various formats accepted by the question For examp
93. nda Reddy carol mcnall tgtsolutions com Brock University COFO Guest COFO Reporter algoma reporter Algoma Reporter cmcnall tgtsolutions com Algoma University algoma survey Algoma Survey carol mcnall tgtsolutions com Algoma University Updated September 2014 Page 14 TGT TGT SOLUTIONS Changing a Password for a User There are two ways a password can be updated for a User It can be changed on the User Edit page by the COU Administrator or the COFO Administrator if the User is associated with their Institution Or it can be requested from the application if the User has forgotten their password Option 1 Changing it using the User Edit page Log in to the COU COFO Online Reporting Application as the COU Administrator or the COFO Administrator From the Home Page select the Users menu option COFO Online Reporting 4 COFO Online Reporting Submit Report Submit Annual Report COFO Templates Institution Algoma University a Annual Report Files Year 32012 2013 Report Files History Te COFO Template Financial Health survey History Document Browse Variance Validation Validation and Variance Validation Report Te Uploa Variance Report P system Reports COFO Annual Report Submission Status Financial Health Submission Status Un Published survey Interactive Reporting Variance Checks Total Validation Errors Total Variances Template Types i Variances Requiring Explanation Rep
94. niver Revenue variance of more than 50 and t 100 008 Table 2 21 Municipal 1 Entities Consolidated Sponsored Research RestrictedExpenc 357 Revenue 2010 2011 Algoma Univer Revenue variance of more than 50 and t 100 00 Table2 22 Other Provinces Entities Consolidated Sponsored Research Restricted Espenc 254 Revenue 2010 2011 Algoma Univer Revenue variance of more than 50 and t 100 008 Table2 23 Foreign Operating Operating General Expendable Funds 285 Revenue 2010 2011 Algoma Univer Revenue variance of more than 50 and t 100 008 Table2 23 Foreign Entities Consolidated Sponsored Research Restricted Expenc 17312 Revenue 2010 2011 Algoma Univer Revenue variance of more than 50 and t 100 00 Table2 25 Tuition Fees Revenue 2010 2011 Algoma Univer Revenue variance of more than 50 and t 100 008 Table 2 28 Miscellaneous Fees Revenue 2010 2011 Algoma Univer Revenue variance of more than 50 and t 100 00 Table2 30 Donations and Non Government Grants and 1 Other Non Credit Operating General Expendable Funds 4212 Operating Operating General Expendable Funds 19320 Trust Restricted Expendable Funds 31372 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Updated September 2014 Page 54 TGT SOLUTIONS Using the excel variance file enter the explanations for each row in Column N Explanations can be uploaded intermittently as they are done or received from others When you are done and ready
95. o be Approved by the COFO Approver Updated September 2014 Page 99 TGT TGT SOLUTIONS Approving the Survey It is now up to the COFO Approver to review the University s submission and submit it as Approved to COU To complete the approval the COFO Approver logs into the COU COFO Online Reporting application and selects the Surveys menu item COFO Online Reporting 4 COFO Online Reporting Submit Report Peu Submit Annual Report COFO Templates Institution Laurentian University a Annual Report Files Year 2010 2011 Report Files History Type COFO Template Document a Validation Report Variance Report Variance Validation Validation and Variance Template Types Pl sia COFO Annual Report Submission Status Submission Status Un Published Variance Checks Reporting Years Submission Status e Instttons Total Validation Errors Total Variances Variances Requiring Explanation Financial Statements Uploaded Notes he document The following page will appear Note only the University the COFO Approver has access to will appear on the Survey Response List page Carleton University Survey Institution Year Submission Status View Audit Fees Charged to Universities of Ontario Carleton University 2009 2010 Ready For Approval Updated September 2014 Page 100 TGT TGT SOLUTIONS Click on the View hyperlink on the left hand side of the page to open the Audit Survey page
96. olutions com Algoma University algoma survey Algoma Survey carol mcnall tgtsolutions com Algoma University Updated September 2014 Page 26 The User Information page will appear Edit User User Information Username algoma approve First Name Algoma Last Name Approver Email address judy walters tgtsolutions com Institution Algoma University For Institution Organization users please select the primary institution from the drop down list For COU users choose ALL Change Password To change the password enter the new password and the confirm password below Leave these fields blank to keep the same password A Password must be at least 7 characters long and must contain both d Password a special character Confirm Password User Active Check the box if the user s account is active Role s Choose one or more roles from the list below for this user A selection is required E COFO Admin COFO Approver E COFO Guest COFO Reporter COFO Survey E cofo Su rvey Ancillary E CSAO Members FRC Members Cancel Delete User Delete User At the bottom of the page click on the appear confirming that you want to delete the user button The following message will Updated September 2014 Page 27 TGT TGT SOLUTIONS Click on the OK button to proceed the Cancel to return to the User Information page Once the user is deleted the application will return you to the User List page The
97. on the Approved button at the bottom of the page COFO Online Reporting 4 COFO Online Reporting Submit Report pt tr Submit Annual Report COFO Templates Institution Carleton University a Annual Report Files Year 2010 2011 Type COFO Template a Validation Report os Document Variance Report Variance Validation Validation and Variance Template Types Upload Reporting Years Submission Status e Insttutons COFO Annual Report Submission Status Submission Status Ready For Approval Variance Checks Yes Total Validation Errors Total Variances Download Variances Requiring Explanation Financial Statements Uploaded Notes The document is Ready For Approval by a COFO Approver Change Status Once the Template status is changed to Approved emails will be sent to the COFO Reporter and COFO Approver for the Institution to advise them that the status has changed The template is now ready to be verified by COU Once approved the template submission is locked down and a message appears on the Submit Annual Report page see below A new or revised template cannot be uploaded for that Institution for the current year as long as that document type has an approved status unless COU changes the submission to Not Verified A iaaa eee ie eee institution reporting year and document type and the status of the submission Is Approved and is locked Updated September 2014 P
98. ons 29 624 39 834 TBE o j o D o Met Imorease Decrease for ihe Year z Fer 3 rq yoo j ry E gt per COFCO Report 164 995 39 624 39 218 51 153 19 392 21 008 203 973 636 970 Net Reconciling Items 95 640 1 32 537 D 52 512 i 133 172 59 695 5 851 Balance Beginning of year as per aes 3 saa ess pee a PRIOR YEARS COFO REPORT 7S 2B 1 372 029 163 043 161 722 112 943 1 979 350 2 681 650 4 564 205 Prior Penod Adjustments 12 153 7 912 g D 122 i 44 205 39 603 34 T73 Balance End of the Year PER FINANCIAL STATEMENTS Unrestricted 1 070 015 J 161 023 D 3 609 21 519 234 563 1 445 011 o Intemially Restricted o 1 285 425 4 564 21482 110 804 164 351 255122 1 684 945 551 561 Investment in Capital Assets o 1 a 101 033 o D 25922 2 146 055 o Extemally Restricted o 1 a D 4182 15 272 441 22 014 3 144 889 Total 1 070 015 1 285 425 156362 162 515 111 467 204 153 2 065 720 2 602 903 3 826 450 1 070 075 1 295 425 156 362 162 515 117 467 204 153 2 066 720 2 602 503 3 926 450 Updated September 2014 Page 84 TGT TGT SOLUTIONS When a By Table Excel file is selected and the Excel file is opened the Rollups and the individual Institutions will appear on different tabs in the workbook in the same order as the directory structure Total for System Total for Universities Total for Affiliates followed by the Institutions in alphabetical order apie oluimmMary or Revenu XPenses ane
99. ons com Algoma University FRC Members algoma admin Algoma Admin carol mcnall tgtsolutions com Algoma University algoma approver Algoma Approver carol mcnall tgtsolutions com Algoma University algoma csao Algoma CSAO carol mcnall tgtsolutions com Algoma University algoma guest Algoma Guest carol mcnall tgtsolutions com Algoma University COFO Guest COFO Reporter COFO Survey COFO Reporter COFO Survey COFO Approver areddy Amanda Reddy carol mcnall tgtsolutions com Brock University COFO Guest COFO Reporter algoma reporter Algoma Reporter cmcnall tgtsolutions com Algoma University algoma survey Algoma Survey carol mcnall tgtsolutions com Algoma University The User Information page will appear Uncheck the Locked Out checkbox and click on the Update User button to save the change mai UserEdit Edit User User Information Username First Name Algoma Last Name Email address carol _mcnall tgtsolutions com Institution Algoma University k For Institution Organization users please select the primary institution from the drop down list For COU users choose ALL Change Password To change the password enter the new password and the confirm password below Leave these fields blank to keep the same password l 7 Password must be at least 7 characters long and must contain both a number and Password 1 special character Password User Active Check the box if the user s account is active Locked
100. ores include all trade textbooks stationery and computer sales Does your Institution have Bookstores to report on a Yes b No 1 Is the bookstore operated solely by the institution a Yes b No Who is the contractor 2 Is there a separate student operated bookstore a Yes New books are sold e Used books are sold e Both new and used books are sold b No 3 Institution s gross square footage of space utilized for a Selling of books 20 C e Please explain in what situations mark up from net price is used b Mark down from suggested list price e Specify mark down Please explain in what situations mark down from suggested list price is used c Suggested retail price e Please explain in what situations suggested retail price is used 6 What is the dollar value of the bookstore inventory at year end 7 Is interest charged on inventory at year end a Yes Specify b No 8 What is the number of full time equivalent staff working in the bookstore 9 Are financial surpluses deficits carried over held in an ancillary fund a Yes b No e Which fund is it transferred to Back Next Approved Pending Updated September 2014 Page 128 TGT SOLUTIONS Once the COFO Approver has reviewed the survey and is in agreement with the information entered they click on the Approved button at the bottom of the page This will change the Survey status to Approved and remove the Pending
101. ormation is not satisfactory COU sets the status to Not Verified by clicking on the Not Verified button at the bottom of the Submit Annual Report page Submit Annual Report COFO Templates Institution Western Ontario University of Annual Report Files Year 2010 2011 Type COFO Template Validation Report p Document Variance Report System Reports Variance Validation a Template Types pl vpe COFO Annual Report Submission Status Submission Status Variance Checks Reporting Years Submission Status e Insttutens Total Validation Errors Total Variances Download Variances Requiring Explanation Financial Statements Uploaded Notes The document is verified by COU and is complete Not Verified When a template status has been changed to Not Verified the information must be corrected at the Institution level and re submitted through the Approval process COFO Annual Report Submassen Status Total Validation Errors Total Variances EZ Yanances Buaquiring Explanatean a als Hal Weri The document has been set to Mot Verified by COU and must be re submitted lf COU changes an Institution s submission to Not Verified the application will send out an email to the COFO Approver and COFO Reporter for the Institution to advise them of the change in status Updated September 2014 Page 78 TGT SOLUTIONS 4 Static Reporting The Static Reports page contains
102. orting Years a Submission Status e Insttutons Variance Analysis by Table Financial Statements Uploaded Notes The document is not uploaded yet Updated September 2014 Page 15 TGT SOLUTIONS Select the User to be updated from the User list on the User List page by clicking in the Username field or the Username can be entered in the Search box on the right hand side to find the User in the list Users Add New User Show 10 entries Search amp Username First Name Last Name Email Institution Active Roles aaaa aaaa bbbb aaa tagtsolutions com COU Admin COFO Admin COFO Survey COFO Approver COFO Survey COFO Survey CSAO Members algoma frc Algoma FRC carol mcnall tgtsolutions com Algoma University FRC Members algoma admin Algoma Admin carol mcnall tgtsolutions com Algoma University algoma approver Algoma Approver carol mcnall tgtsolutions com Algoma University algoma csao Algoma CSAO carol mcnall tatsolutions com Algoma University algoma guest Algoma Guest carol mcnall tgtsolutions com Algoma University COFO Guest COFO Reporter COFO Survey COFO Reporter COFO Survey COFO Approver areddy Amanda Reddy carol mcnall tgtsolutions com Brock University COFO Guest COFO Reporter algoma reporter Algoma Reporter cmcnall tgtsolutions com Algoma University algoma survey Algoma Survey carol mcnall tgtsolutions com Algoma University When the User Edit page appears enter the new
103. ou select the Filter by a Single va ue option then this value will remain at the higher level like the Table criteria assuming that another Row or Column criteria exists The options for Institution are as follows STATIC REPORTS CUSTOMIZED REPORTS Table Table 4 SUMMARY OF EXPENSE BY FUND AND OBJ Institution Filter by Single Institution Institution as a Column Institution as a Row Updated September 2014 Page 86 The options for Reporting Year are as follows STATIC REPORTS CUSTOMIZED REPORTS Table Table 4 SUMMARY OF EXPENSE BY FUND AND OBJECT OF EXPENSE Institution Filter by Single Institution Total for System Run Report Reset To Default Settings The options for Fund are as follows STATIC REPORTS Table CUSTOMIZED REPORTS Reporting Year Filter by single Year Filter by single Year w Year as a Column L Year as a Row Table 4 SUMMARY OF EXPENSE BY FUND AND OBJECT OF EXPENSE Institution Filter by Single Institution Total for System Run Report Reporting Year 2009 2010 Reset To Default Settings The options for Source are as follows STATIC REPORTS Table CUSTOMIZED REPORTS Table 4 SUMMARY OF EXPENSE BY FUND AND OBJECT OF EXPENSE Institution Filter by Single Institution Total for System Run Report Updated September 2014 Filter by single Year Fund as a Column 2 Filter by sing
104. port Histor This page contains all of the submissions from 2008 2009 forward Only the COU Administrator will see all institutions Universities and Affiliates will only see their own The submission can be opened by clicking on the File name and following the prompt boxes The Open option will request a second sign in which is not required to open the document so you can click on the X to close the box Updated September 2014 Page 35 IGT GT SOLUTIONS Templates Uploading and Approving the COFO Template Step 1 Getting ready to Upload the Template Once a COFO template is complete in Excel and it is ready to be uploaded into the COU COFO Online Reporting Application the COFO Reporter will log into the application When you log into the system the Submit Annual Report Page appears If a User is already logged into the system they can click on the Submit Report tab to see the Submit Annual Report page COFO Online Reporting a c COFO Online A Prior to Uploading a template for an Institution the status will be Un Published for the Institution Year combination Submit Annual Report Institution Knox College Year 2012 2013 Type COFO Template Document Browse Vanance Validation Validation and Variance Upload COFO Annual Report Submission Status Submission Status Un Published Variance Checks Total Validation Errors Total Variances Variances Requiring Explanation Variance
105. r Password User Active Check the box if the user s account is active Role s Choose one or more roles from the list below for this user A selection is required 1 coro Admin L COFO Approver L COFO Guest COFO Reporter COFO Survey lf you are reactivating a User the Password should also be updated as it is highly likely the User will not remember their previous password Once the page is saved the system will send the updated User an email with their new password Updated September 2014 Page 13 TGT SOLUTIONS Once the change is saved the system will return you to the User List page where you can confirm that the change took effect by reviewing the information in the Active column Users Add New User Show 10 M entries E Username First Name Last Name Email Institution Roles aaaa aaaa bbbb aaa tgtsolutions com COU Admin COFO Admin COFO Survey COFO Approver COFO Survey COFO Survey CSAO Members algoma admin Algoma Admin carol mcnall tgtsolutions com Algoma University algoma approver Algoma Approver carol mcnall tgtsolutions com Algoma University algoma csao Algoma CSAO carol mcnall tgtsolutions com Algoma University algoma frc Algoma FRC carol mcnall tgtsolutions com Algoma University FRC Members algoma guest Algoma Guest carol mcnall tgtsolutions com Algoma University COFO Guest COFO Reporter COFO Survey COFO Reporter COFO Survey COFO Approver areddy Ama
106. r messages and the page cannot be saved and new rows cannot be added to the two sections until the corrections are made The error messages will appear on the bottom of the page An example is shown below The validation checks completed on the page and the corresponding error messages returned are listed in the table below Validation Check Error Message Negative amounts cannot be entered on Amount has to be greater than or equal to the permanent Survey question rows zero does not pertain to 2c or 3b Negative amounts or zero amounts cannot All rows added to the current year must be entered on new rows added in section have amounts greater than zero 2c or 3b Existing rows in these sections but not new ones Duplicate descriptions cannot be entered Description Description entered appears within section 2c or 3b more than once Description entered is the text entered by the User A new detail row has been added to Amount is mandatory for new rows section 2c or 3b and no dollar amount has been entered on the row A new detail row has been added to A description is mandatory for new rows section 2c or 3b and no description has been entered on the row Updated September 2014 Page 98 TGT SOLUTIONS Validation Checks Completed when the Ready for Approval button is Selected since it is assumed that the University will need to enter information and save it periodically not all of the validation checks are performed
107. r Approval 8 10 2011 4 52 Validation Report To review the information for a COFO Template Report that is Ready for Approval click on the applicable item under Name and the COFO Approver will be able to open it to review it or save it as a Microsoft Office Excel file COFO Online Reporting 4 COFO Online Reporting Annual Repor COFO Online Reporting gt Annual Report Files Annual Report Files Filter By Institution File Download Name Variance Cl 2010 2011 _Carleton_F _2011 04 30 Carleton University Do you want to open or save this file nts nja 2010 2011_Carleton_Report Yes T Name z2010 2011_Carleton_Report xls Validation Report erie aad HH Type Microsoft Office Excel 97 2003 Worksheet 461KB lila arts ele From cousit tgtsolutions com a Reporting Years Submission Siae Always ask before opening this type of file a Institutions rs While files from the Internet can be useful some files can potentially C2 harm your computer If you do not trust the source do not open or save this file whats the tisk Updated September 2014 Page 63 TGT TGT SOLUTIONS Once the COFO Approver has reviewed the information in the COFO Template Report there are two ways to review the Variance explanations From the COU COFO Online Reporting Home Page go to the Reports section and select Variance Report Select the applicable Institution if there is more than one available and the Variances will be displ
108. r CAUBO rates a Yes b No 2 Is the amount of reimbursement paid for hotel or motel accommodation generally limited to single occupancy for standard room rate a Yes b No 3 Are original itemized receipts required for reimbursement a Yes The following questions relate to your institution s policy on commercial air travel 1 When is business class seating permitted a Not permitted b Permitted only Section 5 is as follows The following questions relate to your institution s policy on hospitality 1 Please provide the link to your institution s policy on hospitality 2 Is alcohol an eligible expense as part of a hospitality event a Yes b No As the survey questions are answered the COFO Reporter can click on the Save Button on the bottom left hand side of the page to save the changes made so far 2 Is alcohol an eligible expense as part of a hospitality event a Yes amp b No Confirm Submission Ready for Approval Updated September 2014 Page 104 T I The Save button confirms that the answers populated prior to the Save button match the various formats accepted by the question For example it will confirm that the dates entered match the MMDDYYYY format Itis important to note that if the date entered does not match this format none of the answers to the questions will be saved After the initial save of the form the Survey Status will change fro
109. rms that all of the checks listed at the bottom of each table in the excel template are in a Passed status If any of the checks are in an Error status the validation process will report a validation error for this check It is important to note that Warning messages are not flagged as errors by the Validation process Note 1 Must agree with line 17 Total on Table 2 Note 2 Must agree with line 26 Total on Table 4 Note 3 Must agree with line 5 Total on Table 9 In line 05 Total Expendable column 8 must exactly equal Endowment column 9 so that the sum of the two columns equals zer Note 4 Net variations in appropriations must reconcile accordingly t 0 Note 5 Must agree with line 13 Total on Table 14 Note 6 Amounts in row 09 must be identical to the amounts reported as the Balance End of Year in last years COFO report lf amounts have been restated the differences should be reconciled on Table 14 Note 7 Line 11 Balance End of the Year must equal line 16 lf the Validation option is selected it will only check for Validation errors and will notify the user as to how many Validation errors were found The system will also indicate that Variance checks were not done by putting a No beside the Variance Check row Updated September 2014 Page 32 TGT TGT SOLUTIONS COFO Online Reporting 4 COFO Online Reporting Submit Report je Report Fi Submit Annual Report Documents COFO Templates a
110. rover has access to will appear on the Survey Response List page Guelph University of Go to Survey Report Survey Institution Year Submission Status Modified View Travel Reimbursements for the Universities of Ontario Guelph University of 2009 10 Ready For Approval 3 24 2011 1 59 22 PM Updated September 2014 Page 109 TGT TGT SOLUTIONS Click on the View hyperlink on the left hand side of the page to open the Travel Survey page The COFO Approver cannot change any of the values entered they can only view them Travel Reimbursements for the Universities of Ontario Institution Toronto University of Survey Status Ready For Approval Section 1 Automobile Travel The following questions relate to your institution s reimbursement policy on the use of personal automobiles for business travel 1 What is the amount of reimbursement paid by your institution for travel by personal automobile format e g 0 465 a Cents per kilometer 2 What is the effective date of relevant reimbursement policy The following questions relate to limitations on the amount of reimbursement paid 3 What is the eligible kilometrage a Actual distance travelled b The lesser of i the actual distance travelled or i the difference between the actual travelled and the distance normally travelled to the workplace 4 Is there a maximum kilometrage amount paid by your institution a Yes Please specify b No 5 Does your policy st
111. rt Files Report Files History Financial Health survey History a Validation Report Variance Report a System Reports a Financial Health survey Interactive Reporting Template Types Reporting Years e Submission Status u Insttutons Updated September 2014 Submit Annual Report Institution Algoma University Year 2012 20135 Type COFO Template Document Variance Validation Validation and Variance COFO Annual Report Submission Status Submission Status Un Published Variance Checks Total Validation Errors Total Variances Variances Requiring Explanation Variance Analysis by Table Financial Statements Uploaded Notes The document is not uploaded yet Page 7 The following User List page will appear If you are the COU Administrator you will be able to see all of the users in the system However if you are a COFO Administrator you will only be able to see the users associated with your Institution Click on the Add New User option at the top of the page to access the UserAdd setup page Users Add New User Show 10 YY entries A Username aaaa algoma admin algoma approver algoma csao algoma fre algoma guest algoma reporter algoma survey areddy ava smith First Name aaaa Algoma Algoma Algoma Algoma Algoma Algoma Algoma Amanda Ava Showing 1 to 10 of 131 entries Updated September 2014 Last Nam
112. s Downkad Variances Requiring Explanation Financial Statements Uploaded Notes The document contains validation errors All validation errors must be fixed and the report re submitted Elimination Entry Form Submission Status Status Pending Total Validation Errors D Notes The document passes all validation A COFO Reporter can update the status of this submission to Ready For Approval Change Status Ready For Approval When the Ready for Approval button is selected and the status has changed emails will be sent to the COFO Reporter and COFO Approver for the Institution to advise them that the status has changed for the Elimination Template Updated September 2014 Page 71 TGT TGT SOLUTIONS Once the template has a Submission status of Ready For Approval it is ready for approval by a COFO Approver Elimination Entry Form Submission Status Status Ready For Approval Total Validation Errors ia Updated September 2014 Page 72 Step 4 Approving the Elimination Template The elimination template is now ready for approval by the COFO Approver The COFO Approver signs into the COU COFO Online Reporting application and from the Home Page and selects the Annual Report Files menu from the Documents menu 4 COFO Online Reporting Submit Report ile da COFO Templates Annual Report Files Validation Report Variance Report Template Types Reporting Years Subm
113. se ai 215 872 0 00 217 511 Lump Sum Payments f ol 40 000 0 00 0 00 2 000 Net Revenue Expense f 5 949 i E 0 00 354 011 Interfund Transfers 5 703 38 103 0 00 16 200 Net Variation in Appropriations 2 697 4 697 2 0 00 15 000 Net Increase Decrease for the Year per r COFO UO Report 2 451 2 000 j 0 00 385 211 Net Reconciling Items 4 310 0 0 0 00 102 785 9 Balance Beginning of year as per PRIOR f YEAR S COFO REPORT 30 934 6 761 21 86 28 116 i 10 61 0 10 Prior Period Adjustment 0 0 00 26 116 11 Balance End of the Year PER FINANCIAL 7 O o ae VIEN ait nS 100 M The and variance checks work independently of each other To clear either of the variance highlights click on the entry cell K2 or N2 hit the space bar and enter All of the highlights will be removed 1 a 3 4 5 6 7 8 Each tab in the workbook has its own filter feature to allow the institutions to select different and amounts by table given the different information on the various tables Updated September 2014 Page 46 i As the Template is re uploaded with new information the Variance Analysis report will update with the changed information You will have to download the report each time to obtain the most up to date information Updated September 2014 Page 47 Gl Step 5 Explaining Variances All variances must be explained before
114. ssion Status will change to Pending The Section below the Upload button will provide information to the User on the results of the Uploaded template It will indicate that the document was processed it was uploaded successfully and what Validation and or Variance Checks were done Updated September 2014 Page 37 TIONS IGT SOLU Screen shots of how the Submit Annual Report page appears after selecting the different Validation or Variance options are as follows Validation and Variance 4 COFO Online Reporting Submit Report Be a os m Templates Annual Report Files a Validation Report e Variance Report Template Types Reporting Years Submission Status e Insttutons Updated September 2014 Submit Annual Report Institution York University Year 2010 2011 Type COFO Template Document Varniance Validation Validation and Variance Document Processed Document Uploaded Validation Complete Variance Checks Complete File successfully uploaded COFO Annual Report Submission Status Submission Status Variance Checks Total Validation Errors Download Total Variances Downkad Variances Requiring Explanation Page 38 TGT TGT SOLUTIONS Validation only COFO Online Reporting 4 COFO Online Reporting Submit Report e Submit Annual Report COFO Templates Institution York University a Annual Report Files Year 2010 2011 Type Validation Report
115. sword field Ensure that the User Active box is selected to activate the User Add User User Information Standard for User name is first initial followed by re last name of the user being added First Name Last Name Email address Institution Algoma University For Institution Organization users please select the primary institution from the drop down list For COU users choose ALL Password Password must be at least 7 characters long and must contain both a number and a special Password character User Active Check the box if the user s account is active Role s Choose one or more roles from the list below for this user A selection is required LJ coro Admin P COFO Approver C coro Guest C COFO Reporter coro Survey Cl coro su rvey Ancillary C CSAC Members C FRC Members Check the Role s that this User is being assigned and then click on the Add button The COU Administrator can select from all of the Roles in the application The COFO Administrator can only select the COFO Approver COFO Guest COFO Reporter COFO Survey and COFO Survey Ancillary role All of the other roles will be greyed out When setting up a COU user by selecting the ALL COU Users Only option in the Institution list only two roles are available COU Admin and COU Vendor Admin The COU Vendor Admin is used by TGT to support the application All of the fields displayed on the page must contain information for th
116. t Increase Decrease for the Year per i a E E COFO UO Report A 664 212 HHHHHHH 2 000 0 00 385 211 8 Net Reconciling Items f 585 z 0 0 0 00 102 785 0 0 Lump Sum Payments af j 0 0 00 2 000 0 0 0 0 oe oe Se oN DNAN The file contains all of the Template tables rows and columns with the following exceptions e Table 9 has been removed due to the data on the tab e The free form entry rows from Table 14 have been removed as well The file shows the information from the previous and current reporting years followed by dollar and percentage variance columns At the top of each tab in the workbook is a filter and highlight section that can be used by the Institutions for analysis purposes Updated September 2014 Page 45 Gl GT SOLUTIONS When a Variance is entered into cell K2 or the box next to the Find Variance text the filter will locate variances on the tab that equal or exceed the value entered and highlight them to match the yellow highlight Note the screen shot below shows all of the variances located that match or exceed the 50 000 variance TABLE 1 SUMMARY OF REVENUE EXPENSES 4LANCE Year over Year Variance Analysis 000 s 2012 13 Brock University General Expendable Funds Operating amp Other Non Credit Unappropnated Approprated Unappropnate s 3 2011 12 Variance Variance 2012 13 2011 12 Variance Variance 2012 13 2011 12 1 Total Revenue 0
117. t have an official heading This information is available in the Funds section under the heading Information The fifth set of options available for selection pertains to the Rows in the Financial Health Survey template The information displayed in this section will vary depending on which Tab was selected in the first box Once all of the selection sections have been completed click on the Run Report button to review the Financial Health information in the reporting grid Since the Financial Health Survey information contains both numeric date and text information it cannot all be displayed on the same tab in the report grid When date text information is selected in the Fund and Row Label sections two tabs will appear in the reporting grid The Data tab will display all of the numeric data values while the Text tab will display the date and text information If no date or text information is selected or does not appear on the tab selected then only the Data tab will appear in the reporting grid Updated September 2014 Page 138 TGT TGT SOLUTIONS On the Data tab you can move the selection criteria around between the rows columns and header of the grid by clicking and dragging the section name to over the other section name When the up and down arrows appear let go of the mouse 2010 2011 Carleton University Data Value Fund value of Capital Row Label east S The page display
118. than 50 and t 100 008 Table 2 18 Other Ontario Government Grants and Contr L 1 Entities Consolidated Sponsored Research Restricted Expenc 28302 Revenue 2010 2011 Algoma Univer Revenue variance of more than 50 and t 100 008 Table 2 18 Other Ontario Government Grants and Contr M 1 Entities Not Consolidated Sponsored Research RestrictedEx 4475 Revenue 2010 2011 Algoma Univer Revenue variance of more than 50 and t 100 008 Table 2 18 Other Ontario Government Grants and Contr P Capital Restricted Expendable Funds 3620 H L mI P L L H L l H m 128353 100 95069 100 2880 100 i 100 15233 100 38728 100 28302 100 4475 100 3620 100 423 100 123490 100 4488 100 2048 100 357 100 254 100 285 100 173121 100 4212 100 19320 100 31372 100 Ow D Oe wh Revenue 2010 2011 Algoma Univer Revenue variance of more than 50 and t 100 00 Table2 20 Federal Operating Operating General Expendable Funds 423 Revenue 2010 2011 Algoma Univer Revenue variance of more than 50 and t 100 00 Table2 20 Federal 1 Entities Consolidated Sponsored Research Restricted Expenc 1E 05 Revenue 2010 2011 Algoma Univer Revenue variance of more than 50 and t 100 00 Table2 20 Federal 1 Entities Not Consolidated Sponsored Research RestrictedEx 4488 Revenue 2010 2011 Algoma Univer Revenue variance of more than 50 and t 100 00 Table2 20 Federal Capital Restricted Expendable Funds 2048 Revenue 2010 2011 Algoma U
119. their Institution and mark it Ready for Approval If a COFO Approver has the survey role they will be able to review their Institution s submission and mark it Approved or put it back to Pending for changes 6 COFO Survey Ancillary Ability to access the Ancillary survey pages only This user will be able to view and edit the Ancillary Survey information as well as viewing the Previous year s survey report They will not be allowed to submit the survey for Approvals but they will be able to confirm the information entered 7 FRC Members Read only access to view all submissions to assist in verifying accounting consistency across institutions While they have access to view all institutions information they are still associated with a single institution on the User setup page FRC Members can only be added by the COU Administrator 8 CSAO Members this group was added primarily to receive email communications from the application This role can only be added by the COU Administrator It is assumed that users assigned to the role will not log in to the application however nothing stops them from doing so Updated September 2014 Page 6 Adding a New User Log in to the COU COFO Online Reporting Application as the COU Administrator or the COFO Administrator From the Home Page select the Users menu option COFO Online Reporting 4 COFO Online Reporting Submit Report EWE CE COFO Templates a Annual Repo
120. tion Entry The application will pre populate the Institution and Year automatically Select the Elimination Entry option in the Type field Click on Browse button beside the Document field to go to the desktop directory where the Elimination template is located that is to be uploaded and select it The Variance Validation option does not have to be changed from the default since no variance checking is done on the elimination template Once the variables have been entered click on the upload button The application will complete the Version Control check first see Template section above for additional information on this then the validation check It will then change the Submission Status to Pending If the submission passes the version and variance checks the Change Status line will change and the Ready For Approval Button will be displayed To correct any validation errors refer to Step 4 in the Uploading and Approving the COFO Template section Updated September 2014 Page 69 TGT TGT SOLUTIONS Once the status of the Elimination Entry upload changes from Unpublished to Pending emails are sent to the COFO Reporter and the COFO Approver for the Institution to advise them that the status has changed for the Elimination submission Submit Annual Report Institution Queen s University Year 2010 2011 Type Elimination Entry Document Vaniance Validation Document Processed Document Uploaded Validation Complete Variance Chec
121. tions were explained and uploaded and how many variances were not explained In addition the information under the report submission status will be updated COFO Online Reporting 4 COFO Online Reporting TES Submit Annual Report COFO Templates Institution Algoma University a Annual Report Files Year 32010 2011 Type Variance Explanation Upload Validation Report an Document Browse Variance Report System Reports Variance Validation Validation and Variance Template Types Reporting Years Total rows in the file 297 ae Total variances explained 128 Submission Status Total variances not explained 169 Institutions COFO Annual Report Submission Status Submission Status Variance Checks Total Validation Errors Total Variances Download Variances Requiring Explanation The upload process can be completed as often as required to explanation all of the variances or to update the variance explanations When all variances have been explained the Variances Requiring Explanation on the Submit Annual Report page will show 0 Updated September 2014 Page 57 TGT TGT SOLUTIONS Step 6 Changing the Status to Ready for Approval Once the COFO Template has been uploaded successfully with no Validation Errors and all Variances have been explained a Change Status section will appear at the bottom of the page and it will read Ready for Approval At
122. titution Ryerson University Survey Status Pending Previous Survey Print Printing Other General Bookstores Retail Stores Food Services Beverages Residences Conferences Seasonal Conferences Year Round Parking Bookstores include all trade textbooks stationery and computer sales Does your Institution have Bookstores to report on A new window will open to generate the report When the report is done creating the File Download dialog box will appear asking if you want to Open or Save the report When you select Open the pdf report will appear Updated September 2014 Page 125 TGT SOLUTIONS The report lists the previous survey s question and the institution s response to the question It does not list all of the options that were available for selection See example below for Bookstores Mer prse Institution Ryerson University Survey Year 2009 10 Bookstores Bookstores include all trade textbooks stationery and computer sales Does your Institution have Bookstores to report on Yes 1 Is the bookstore operated solely by the institution Yes 2 Is there a separate student operated bookstore Yes Used books are sold Institution s gross square footage of space utilized for a Selling of books 10 540 b Storage office and other 3 800 What is the dollar value of sales of the following a Core text books 9 086 608 b Trade books 90 856 c Used books 283 265 d Computing equipment and supplies 1
123. to upload the variance explanation file to the COU COFO Online Reporting application the application will complete the following checks to ensure the integrity of the uploaded file The file upload will fail and an error message will be displayed if one of the following has occurred e Additional column s were added to the file Error Message This file has an invalid number of columns e Duplicate rows were found in the file Error Message This file contains duplicate rows Row and e The Institution is not correct in all rows Error Message Selected institution does not match institution in the uploaded file e The Year is not correct in all rows Error Message Selected year does not match year in the uploaded file e The name on the workbook tab has been changed manually If the file passes the checks noted above all rows in the file will be checked Rows that are valid will be processed and the variance explanation updated if one has been provided Blank explanations are not updated If any rows fail the following validation checks an error message will be displayed for that row and the row s explanation will not be updated e Information in Columns A to in the spreadsheet does not match to what is in the application Error Message Row could not find a match for Table XX Row XXX Column X e The Current amount in the file is different than what is in the application Error Message Row The Current
124. us Status Ready For Approval Total Validation Errors o Notes The document is Ready For Approval by a COFO Approver Change Status Approved Updated September 2014 Page 75 IGT GT SOLUTIONS Once the status changes from Ready For Approval to Approved emails are sent out to the COFO Reporter and the COFO Approver for the Institution to notify them that the status has changed Submit Annual Report Institution Queen s University Year 2010 2011 7 Type Elimination Entry Document Variance Validation Validation and Variance E Upload COFO Annual Report Submission Status Submission Status Pending Variance Checks No Total Validation Errors Uownload 7 Total Variances Downbad Variances Requiring Explanation Financial Statements Uploaded Notes The document contains validation errors All validation errors must be fixed and the report re submitted Elimination Entry Form Submission Status Status Approved Total Validation Errors 0 Notes The document is Approved and waiting to be verified by COU Once approved the Elimination template submission is locked down and a message appears on the Submit Annual Report page see below A new or revised template cannot be uploaded for that Institution for the current year and document type due to the approved status unless COU changes the submission to Not Verified A submission existe fe the celected Institution reporting year
125. user removed will no longer appear in the list COFO Online Reporting gt User Management gt UserList User List Users Add New User Show 10 entries Username First Name apeters Alar Peteres AWhissell Andre Whissell Updated September 2014 Last Name Email arlap uwindsor ca AWhissell laurentian ca Search Institution Windsor University of Laurentian University Active Yes Yes Roles COFO Admin COFO Approver COFO Reporter COFO Admin COFO Approver COFO Reporter COFO Survey Page 28 T I System Time out Notification When you log into the application there are settings that track when you log in and whether or not your session is active To control connections the application is designed to time out your session if 60 minutes has passed with no activity About 10 seconds prior to the application timing you out the following message will appear to advise you that your session is about to expire Session Expiration Waring Your session will expire in 4 seconds Ck on OR to continue your session If you click on the OK button before the countdown gets to zero you will reset your timeout minutes to 60 and you can continue with what you were doing in the application If you don t click on the OK button the following message appears Session Expired Your session has expired Some data may have been lost Please review Click GK to retum io the login screen
126. versity Template appropriate column for each type to expense 13 Passed Brock 2010 2011 COFO Note 1 Must be the inverse of amount in Total Expendable column on line 11 Borrowings of Table 2 Table State University Template 14 Passed Brock 2010 2011 COFO Note 5 Must be the inverse of amount in Total Expendable column on line 5 Borrowing for long term debt of Table 2 State University Template Table 14 Passed Brock 2010 2011 COFO Note 7 Total of Column 6 Must agree with line 26 Total on Table 5c column 3 Table 2 State University Template Passed Brock 2010 2011 COFO Note 5 Amounts in the Employee Benefits row must agree with the corresponding amounts in the Total rowon Table 4 i COFO Online Reporting his st Variance Report A Annual Report Files COFO Online Reporting gt Variance Report Variance Report _ Brock University Filter By Institution Test Type Reporting Year Institution Y Description Table Row Row Heading Column Column Heading Current Previous Variance Negative 2010 2011 Brock Negative Table 10 14 Social Sciences F Operating 10 University values require amp Humanities General explanation Research Expendable Funds Council Negative 2010 2011 Brock Negative Social Sciences G Other Non Credit 10 University values require amp Humanities General explanation Research Expendable Funds Council Negative 2010 2011 Brock Negative Table 10 14 Social Sciences J University values require
127. vey click on the Ready for Approval button at the bottom of the page Note all validation checks must be corrected for the survey status to change Once the Ready for Approval button is selected the survey form will save re confirm all of the validation checks and change the status to Ready for Approval Once the status is changed the Save Confirm Submission and Ready for Approval buttons will be removed from the bottom of the page and no additional changes are allowed At this point an email is automatically sent to the COFO Approver advising them that the survey is Ready for Approval The survey is then ready to be reviewed and Approved by the COFO Approver Printing the Ancillary Survey Given the number of tabs in the Ancillary Survey a Print option to print the entire survey is provided at the top of the survey page Ancillary Enterprises Institution Ryerson University Survey Status Pending Previous Survey Print General Bookstores Retail Stores Food Services Beverages Residences Conferences Seasonal Conferences Year Round Parking Printing Other Bookstores include all trade textbooks stationery and computer sales Does your Institution have Bookstores to report on Click on the Print button on the top right hand corner Updated September 2014 Page 123 The Print option will open a new page and take all of the tabs and put them on a single page for printing Click on the Print link at the top of th
128. w the information for all of the Universities submitted To access the new feature click on the Interactive Reporting menu in the Reports section COFO Online Reporting 4 COFO Online R Submit Report poles COFO Templates Annual Report Files Report Files History Financial Health survey History Validation Report Variance Report a System Reports Interactive Reporting Updated September 2014 Page 136 This Site COFO Online Report COFO Online Reporting gt Survey gt Interactive Reporting iu Interactive Reporting Tab Net Assets Institution Reporting Year Fund Row Label Filter by Single Institution Filter by single Year Fund as a Column Row Label as a Row heed a teeny 2011 2012 Select Funds Select Row Labels Run Report Reset To Default Settings Excel XLS v Data The current filter selection does not return any data Please CLICK HERE to reload this page The top of the page has five selection sections available to query the Financial Health survey information The first section is called Tab This pertains to the tabs in the Financial Health Survey template The options available are as follows Net Assets Debt Financing Debt Servicing EFB Actuarial EFB FS Capital Endowment Other Data The second section pertains to the University information available There are two boxes provided to display and select this information Institution
129. when the Save button is used There are three validation checks completed when the Ready for Approval button is selected The validation checks completed on the page and the corresponding error messages returned are listed in the table below Validation Check Error Message Confirmation that an Auditor has been entered Auditor in the current reporting year Confirmation that a Yes or No answer was Did you change auditors within the last two provided to Question 7 years Confirmation that a Yes or No answer was Do you expect to tender within the next two provided to Question 8 years Submitting the Audit Survey for Approval Once the COFO Reporter has completed all of the sections of the Audit Survey form and they are satisfied that the information is complete they can submit the survey for approval to the COFO Approver To submit the Survey click on the Ready for Approval button at the bottom of the page Note all validation checks must be corrected for the survey status to change Once the Ready for Approval button is selected the survey form will save re confirm all of the validation checks and change the status to Ready for Approval Once the status is changed the Save and Ready for Approval buttons will be removed from the bottom of the page and no additional changes are allowed At this point an email is automatically sent to the COFO Approver advising them that the survey is Ready for Approval The survey is then ready t
130. will change for you It is important to note that this drag and drop functionality only applies to the Data tab not to the Text tab Once you get the information that you desire you have the option to download the information to an Excel or Text file See O05 Excel XLS Text CSV Updated September 2014 Page 139 TGT SOLUTIONS If you select Excel and you have both a Data and a Text tab in the reporting grid there will be two tabs in the excel file 1 Capital Carleton University oo hh Sis CS a e i id le BNE RS BRS am HH Data Text to g The Text option for export will only download the Data information Updated September 2014 Page 140
131. y algoma fre Algoma FRC carol mcnall tgtsolutions com Algoma University FRC Members algoma guest Algoma Guest carol mcnall tgtsolutions com Algoma University COFO Guest COFO Reporter COFO Survey COFO Reporter COFO Survey COFO Approver areddy Amanda Reddy carol mcnall tgtsolutions com Brock University COFO Guest COFO Reporter COFO Admin COFO Reporter Showing 1 to 10 of 131 entries gt algoma reporter Algoma Reporter cmcnall tgtsolutions com Algoma University algoma survey Algoma Survey carol mcnall tgtsolutions com Algoma University ava smith Ava Smith carol mcnall tgtsolutions com Knox College Updated September 2014 Page 12 TGT TGT SOLUTIONS When the User Edit page appears uncheck the User Active checkbox to inactivate the User Then click on the Update User button at the bottom of the page To activate a User that is currently inactive check the User Active checkbox Then click on the Update User button at the bottom of the page Edit User User Information Username First Name Last Name Reporter Email address cmecnall tgtsolutions com Institution Algoma University For Institution Organization users please select the primary institution from the drop down list For COU users choose ALL Change Password To change the password enter the new password and the confirm password below Leave these fields blank to keep the same password 4 special characte
132. y Functionality The COU Survey forms are in the process of being added to the COU COFO Online Reporting application for entry and approval by the Universities To access the Survey information log into the COU COFO Online application and select the Surveys menu item COFO Online Reporting 4 COFO Online Reporting Submit Report peels t Fi Submit Annual Report COFO Templates Institution Laurentian University Annual Report Files Year 2010 2011 Report Files History He COFO Template Document Validation Report Variance Report Variance Validation Validation and Variance Upload COFO Annual Report Submission Status Submission Status Un Published Variance Checks Total Validation Errors Template Types Reporting Years Submission Status Insttutons Total Variances Variances Requiring Explanation Financial Statements Uploaded Notes ME document l Updated September 2014 Page 93 TGT TGT SOLUTIONS The Survey Response List page will appear Any survey that has been initiated by the COU Administrator will appear in the list Only surveys for your Institution will appear in the list The Surveys follow the same submission and approval process as the Template process except that the surveys are filled out online and the Templates are uploaded Universities will see all four surveys in their Survey list 1 Survey Response List Wilfrid Laurier University All
133. ySettings My Settings Change Password User Information Username First Name Last Name Email address Institution Change Password To change the password enter the new password and the confirm password below Leave these fields blank to keep the same password nee Password must be at least 7 characters long and must contain both a number and Password fs special character iea Doo Password User Active Role s Choose one or more roles from the list below for this user A selection is required Update User Updated September 2014 Page 21 GT T SOLUTIONS User Account is Locked Out lf a User has tried to log in to the application five times and they have been unsuccessful each time the application will lock out the User name they were trying to log into the application with A message will be displayed on the log in page telling the User their account is locked At which time they will need to have the COU Administrator or the COFO Administrator for their University unlock their User name Your User ID is currently locked Please contact your COFO Administrator or COU to unlock your User ID and reset your password User name algoma admin Forgot your Password Updated September 2014 Page 22 TGT TGT SOLUTIONS Unlocking a User lf a user has tried to log in to the application five times and has been unsuccessful the user name they were trying to log into will be locked by t

View User Manual - Council of Ontario Universities

Contents

Download Pdf Manuals

Related Search

Related Contents