{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Yearly Data","Instructions","Signature Page","2.0.1","Required Packages","Resources","Summary","42. (Cont)","44. (Cont)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Yearly Data","index":0,"n_rows":88,"n_cols":3,"rows_kept":88,"cut":false,"hidden":true,"merged":[]}
["Year",2021]
[]
[]
["The following information must be reviewed and updated as necessary anually:"]
[]
["AGCY  CODE","AGENCY NAME","FY Added"]
["A010","LEGISLATIVE DEPARTMENT - THE SENATE"]
["A050","LEGISLATIVE DEPARTMENT - HOUSE OF REPRESENTATIVES"]
["A150","LEGISLATIVE DEPARTMENT - CODIFICATION OF LAWS & LEGISLATIVE COUNCIL"]
["A170","LEGISLATIVE DEPARTMENT - LEGISLATIVE SERVICES AGENCY"]
["A200","LEGISLATIVE DEPARTMENT - LEGISLATIVE AUDIT COUNCIL"]
["A850","EDUCATION OVERSIGHT COMMITTEE"]
["B040","JUDICIAL DEPARTMENT"]
["C050","ADMINISTRATIVE LAW JUDGES"]
["D050","GOVERNOR'S OFFICE--EXECUTIVE CONTROL OF STATE"]
["D100","GOVERNOR'S OFFICE--STATE LAW ENFORCEMENT DIVISION"]
["D170","GOVERNOR'S OFFICE-- EXECUTIVE POLICY & PROGRAMS"]
["D200","GOVERNOR'S OFFICE--MANSION & GROUNDS"]
["D250","INSPECTOR GENERAL"]
["D500","DEPARTMENT OF ADMINSTRATION"]
["E040","LIEUTENANT GOVERNOR'S OFFICE"]
["E080","SECRETARY OF STATE'S OFFICE"]
["E120","COMPTROLLER GENERAL'S OFFICE\n"]
["E160","STATE TREASURER'S OFFICE                                                                       "]
["E190","RETIREMENT SYSTEM  INVESTMENT COMMISSION"]
["E200","ATTORNEY GENERAL'S OFFICE"]
["E210","PROSECUTION COORDINATION  COMMISSION"]
["E230","COMMISSION ON INDIGENT DEFENSE "]
["E240","ADJUTANT GENERAL'S OFFICE"]
["E260","DEPARTMENT OF VETERAN'S AFFAIRS",2020]
["E280","ELECTION COMMISSION"]
["E500","REVENUE AND FISCAL AFFAIRS OFFICE"]
["E550","STATE FISCAL ACCOUNTABILITY AUTHORITY"]
["F270","STATE AUDITOR"]
["H030","COMMISSION ON HIGHER EDUCATION"]
["H060","HIGHER EDUCATION TUITION GRANTS COMMISSION"]
["H590","BOARD FOR TECHNICAL & COMPREHENSIVE EDUCATION"]
["H630","DEPARTMENT OF EDUCATION"]
["H670","EDUCATIONAL TELEVISION COMMISSION (ETV)"]
["H710","WIL LOU GRAY OPPORTUNITY SCHOOL"]
["H730","VOCATIONAL REHABILITATION"]
["H750","SCHOOL FOR THE DEAF AND BLIND"]
["H790","DEPARTMENT OF ARCHIVES AND HISTORY"]
["H870","STATE LIBRARY"]
["H910","ARTS COMMISSION"]
["H950","MUSEUM COMMISSION"]
["H960","CONFEDERATE RELIC ROOM AND MILITARY MUSEUM COMMISSION"]
["J020","DEPARTMENT OF HEALTH AND HUMAN SERVICES"]
["J040","DEPARTMENT OF HEALTH AND ENVIRONMENTAL CONTROL"]
["J120","DEPARTMENT OF MENTAL HEALTH"]
["J160","DEPARTMENT OF DISABILITIES AND SPECIAL NEEDS"]
["J200","DEPARTMENT OF ALCOHOL AND OTHER DRUG ABUSE SERVICES"]
["K050","DEPARTMENT OF PUBLIC SAFETY"]
["L040","DEPARTMENT OF SOCIAL SERVICES"]
["L060","DEPARTMENT ON AGING"]
["L080","CHILDREN'S ADVOCACY"]
["L120","JOHN DE LA HOWE SCHOOL"]
["L240","COMMISSION FOR THE BLIND"]
["L360","HUMAN AFFAIRS COMMISSION"]
["L460","STATE COMMISSION FOR MINORITY AFFAIRS"]
["N040","DEPARTMENT OF CORRECTIONS"]
["N080","DEPARTMENT OF PROBATION, PAROLE AND PARDON"]
["N120","DEPARTMENT OF JUVENILE JUSTICE"]
["N200","LAW ENFORCEMENT TRAINING COUNCIL"]
["P120","FORESTRY COMMISSION"]
["P160","DEPARTMENT OF AGRICULTURE"]
["P240","DEPARTMENT OF NATURAL RESOURCES"]
["P260","SEA GRANT CONSORTIUM"]
["P280","DEPARTMENT OF PARKS, RECREATION AND TOURISM"]
["P320","DEPARTMENT OF COMMERCE"]
["P400","SOUTH CAROLINA CONSERVATION BANK"]
["P450","RURAL INFASTRUCTURE AUTHORITY"]
["R040","PUBLIC SERVICE COMMISSION"]
["R060","OFFICE OF REGULATORY STAFF"]
["R080","WORKER'S COMPENSATION COMMISSION"]
["R160","SECOND INJURY FUND"]
["R200","DEPARTMENT OF INSURANCE"]
["R230","BOARD OF FINANCIAL INSTITUTIONS"]
["R280","DEPARTMENT OF CONSUMER AFFAIRS"]
["R360","DEPARTMENT OF LABOR, LICENSING, AND REGULATION"]
["R400","DEPARTMENT OF MOTOR VEHICLES"]
["R440","DEPARTMENT OF REVENUE AND TAXATION"]
["R520","STATE ETHICS COMMISSION"]
["R600","DEPARTMENT OF EMPLOYMENT WORKFORCE"]
["S600","PROCUREMENT REVIEW PANEL"]
["U300","AERONAUTICS DIVISION"]
["X220","AID TO SUBDIVISIONS-STATE TREASURER"]
["X440","AID TO SUBDIVISIONS--DEPARTMENT OF REVENUE   (Note 2)"]

{"sheet":"Instructions","index":1,"n_rows":108,"n_cols":10,"rows_kept":108,"cut":false,"hidden":false,"merged":[]}
["MASTER REPORTING PACKAGE CHECKLIST"]
["INSTRUCTIONS FOR COMPLETION"]
["Form 2.0.1"]
[null,"DUE DATE:",null,"2021-07-09"]
[]
[null,"PURPOSE AND OBJECTIVES"]
[null,"The purpose of this year-end reporting package is to help agencies determine which reporting packages"]
[null,"are required.  It also tells the Comptroller General's Office which reporting packages to expect from"]
[null,"an agency."]
[]
[null,"THIS FORM SHOULD NOT BE COMPLETED BY THE FOLLOWING:"]
[null,"Exempt entities:"]
[null,"F30 Employee Benefits Fund"]
[null,"F31 Capital Expenditure Fund"]
[null,"Audited Financial Statement Entities:"]
[null,"Department of Employment Workforce (Unemployment Compensation Benefits Fund Only)"]
[null,"Colleges, Universities, and Technical Colleges"]
[null,"Children's Trust of South Carolina"]
[null,"Department of Commerce, Division of Public Railways"]
[null,"Department of Commerce, Division of Savannah Valley Development"]
[null,"Department of Transportation"]
[null,"Education Assistance Authority"]
[null,"Employee Insurance Program of the South Carolina"]
[null,"First Steps"]
[null,"Housing Authority"]
[null,"Insurance Reserve Fund of the South Carolina"]
[null,"Jobs-Economic Development Authority"]
[null,"Local Government Investment Pool"]
[null,"Long-Term Disability Insurance Trust Fund (EIP, B&C Board)"]
[null,"Lottery Commission"]
[null,"Medical Malpractice Patients' Compensation Fund"]
[null,"Medical Malpractice Joint Underwriting Association"]
[null,"Patriots Point Development Authority"]
[null,"Ports Authority"]
[null,"Public Service Authority (Santee-Cooper)"]
[null,"Retiree Health Insurance Trust Fund (EIP)"]
[null,"Retirement Division of the South Carolina"]
[null,"State Accident Fund"]
[null,"Tobacco Settlement Revenue Management Authority"]
[null,"South Carolina Transportation Infrastructure Bank"]
[]
[null,"Refer to the Reporting Policies and Procedures Manual for further guidance and to assist in responding."]
[null,"If additional questions arise during the completion, please request guidance from the Comptroller "]
[null,"General's Office."]
[]
[null,"INSTRUCTIONS FOR COMPLETING THE FORM"]
[null,"This form should be the first on which work is performed and should be used to determine what "]
[null,"additional forms will need to be completed."]
[null,"Upon opening the file, be sure to enable macro's in the file."]
[]
[null,"Signature Page",null,null,null,null,null,null,null,"Signature Page"]
[null,"This form should be completed, printed, signed and a copy of the signed sheet sent via e-mail to the "]
[null,"Comptroller General's office.  The user should choose their agency, then type in the preparer's and "]
[null,"reviewers name, title, date prepared/reviewed, e-mail contact and phone number."]
[null,"Upon completion of the Year End Reporting Package, 2.0.1, information requested:"]
[null,"●  Both the preparer and reviewer certify that the information provided on the Checklist"]
[null,"is complete and accurate to the best of their knowledge by signing where indicated on the Signature Page."]
[null,{"$f":"CONCATENATE(\"● E-Mail the signed Signature Page to the Comptroller General's Office no later than \",TEXT(DUEDATE,\"DDDD\"),\", \",TEXT(DUEDATE,\"M/D/YYYY\"),\".\")","v":"● E-Mail the signed Signature Page to the Comptroller General's Office no later than Friday, 7/9/2021."}]
[]
[]
[null,"Year End Reporting Package",null,null,null,null,null,null,null,"2.0.1"]
[null,"The checklist walks the users through the thought process for identifying errors and omissions in the"]
[null,"agency's summarized financial records (accounting system trial balance) and identifies the areas for which "]
[null,"additional analysis and reporting is required.  It identifies the other reporting packages that are required"]
[null,"to be completed."]
[null,"Use of the Trial Balance as a control:"]
[null,null,"A trial balance provides the results of the transaction processing for the period through which the report"]
[null,null,"is generated.  The objective of internal control is the prevention of and detection within a timely period"]
[null,null,"of errors, omissions, and irregularities in the recording and reporting of transactions.  A review of the"]
[null,null,"results of the process in a timely manner is essential to achieve the objective of internal control."]
[null,null,"The trial balance should be run at a minimum at the agency level to identify any obvious errors in the "]
[null,null,"results of recording and reporting transactions."]
[null,null,"For financial reporting (Year-End Reporting Packages) an evaluation at the accounting fund (the level at"]
[null,null,"which information will be reported) is required to identify errors, omissions, irregularities, or areas "]
[null,null,"where additional analysis is required.  This also can be used by supervisors to refresh the knowledge "]
[null,null,"of the accounting affect of the operational transactions for which oversight of details was previously "]
[null,null,"delegated.  This evaluation should also provide identification of information necessary to respond to "]
[null,null,"the questions accurately."]
[null,null,"For managerial purposes the evaluation and review should be performed at minimum to the level of "]
[null,null,"detail that management has identified risks.  Risk assessment is an essential part of internal control and"]
[null,null,"provides direction as to the areas where resources should be expended to increase control procedures"]
[null,null,"and emphasis for processing should be focused.  Overtime management may be able to focus the"]
[null,null,"managerial review to specific general ledger accounts or cost centers or funded programs."]
[null,"● Follow the instructions for responding to the questions asked and moving through the checklist."]
[null,"● Enter the information requested by the descriptions of each field."]
[null,"○   Features within the form to assist in completion:"]
[null,"►    Drop-down menus are included for the Yes or No responses.  "]
[null,"Upon completion of the information requested:"]
[null,"● The individual completing the form should review the form for accuracy and completeness prior to "]
[null,"signing it as an assertion of the accuracy and completeness of the information reported.  "]
[null,"● The Finance Director or Executive Director should review and approve the Form indicating agreement "]
[null,"with the information’s accuracy and completeness before sending it to the Comptroller General's "]
[null,"Office."]
[null,"● E-Mail the completed Master Reporting Package Checklist, 2.0.1, saved in Microsoft Excel, to the "]
[null,{"$f":"CONCATENATE(\"Comptroller General's Office no later than \",TEXT(DUEDATE,\"DDDD\"),\", \",TEXT(DUEDATE,\"M/D/YYYY\"),\".\")","v":"Comptroller General's Office no later than Friday, 7/9/2021."}]
[null,"● The agency should retain a copy of the completed checklist as part of its year-end working papers.  The "]
[null,"Comptroller General's Office will contact the individual completing the checklist if there are any "]
[null,"questions.  The completed checklist is needed to determine which reporting packages to complete "]
[null,"later."]
[]
[null,"Required Packages",null,null,null,null,null,null,null,"Required Packages"]
[null,"Upon completion of the Year End Reporting Package, 2.0.1, The Required Packages tab can be printed to "]
[null,"show the user what packages and additional documentation are required to be submitted to the Comptroller "]
[null,"General's office.  Please do not delete this tab."]
[]
[null,"Resources",null,null,null,null,null,null,null,"Resources"]
[null,"This tab is provides the due dates of all packages, who to contact at the Comptroller General's office about "]
[null,"each package, the SCEIS report that will be provided and the date the report is scheduled to be sent."]

{"sheet":"Signature Page","index":2,"n_rows":41,"n_cols":6,"rows_kept":41,"cut":false,"hidden":false,"merged":[[40,1,40,5],[26,3,26,4],[28,0,28,5],[32,1,32,5],[34,1,34,5],[36,1,36,5],[38,1,38,5]]}
[null,null,"Master Reporting Package Checklist Signature Page"]
[]
[]
[null,null,"CAFR Reporting Period:",null,{"$f":"TEXT(DUEDATE,\"YYYY\")","v":"2021"}]
[null,null,"Agency Number:",null,"E120",{"$f":"IF(AgencyCode=\"\",\"*\",\"\")","v":""}]
[null,null,"Agency Name",null,{"$f":"IF(ISERROR(VLOOKUP(E5,'Yearly Data'!A7:B88,2,FALSE))=TRUE,\"\",VLOOKUP(E5,'Yearly Data'!A7:B88,2,FALSE))","v":"COMPTROLLER GENERAL'S OFFICE\n"}]
[]
[]
[]
[null,null,"Preparer","Date:","2021-07-08",{"$f":"IF(E10=\"\",\"*\",\"\")","v":""}]
[null,null,null,"Name:","Agency Preparer",{"$f":"IF(E11=\"\",\"*\",\"\")","v":""}]
[null,null,null,"Title:","Fiscal Manager",""]
[null,null,null,"e-mail:","agencypreparer@agency.gov",""]
[null,null,null,"Phone Number:","803 123-4567",""]
[null,null,null,"Signature:",null,"*"]
[]
[null,null,"Reviewer",null,"2021-07-09",{"$f":"IF(E17=\"\",\"*\",\"\")","v":""}]
[null,null,null,"Date Reviewed:","2021-07-08",""]
[null,null,null,"Name:","Agency Reviewer",""]
[null,null,null,"Title:","Director of Finance",""]
[null,null,null,"e-mail:","agencyreviewer@agency.gov",""]
[null,null,null,"Phone Number:","803 123-4567",""]
[null,null,null,"Signature:",null,"*"]
[]
[null,null,"Signatures are an assertion of the accuracy and completeness of the information reported.  "]
[]
[null,null,"*",{"$f":"IF(OR(F5=\"*\",F10=\"*\",F11=\"*\",F12=\"*\",F13=\"*\",F14=\"*\",F17=\"*\",F19=\"*\",F20=\"*\",F21=\"*\",F22=\"*\")=TRUE,\"Please complete the above page where indicated by a red star.\",\"Please print a copy of this signature page, have the preparer and reviewer sign, scan a copy of the signed Signature Page and e-mail it to CAFR@CG.SC.GOV.\")","v":"Please print a copy of this signature page, have the preparer and reviewer sign, scan a copy of the signed Signature Page and e-mail it to CAFR@CG.SC.GOV."}]
[]
["Your signature on this form certifies that the information provided on the reporting packages is complete and accurate to the best of your knowledge."]
[]
["Representations made by signing as the approver:"]
[]
[null,"I acknowledge and have fulfilled the responsibility for implementation and maintenance of internal control relevant to the preparation and fair presentation of the year end packets that are free from material misstatement, whether due to fraud or error."]
[]
[null,"We have recorded or disclosed all accounting estimates that could be material to the financial statements in accordance with the requirements of U.S. GAAP. "]
[]
[null,"All events occurring subsequent to the date of the financial statements and for which U.S. GAAP requires adjustment or disclosure have been adjusted or disclosed."]
[]
[null," Special and extraordinary items have been appropriately classified and reported."]
[]
[null," The agency has no transfers, reservations or designations of fund equity or interfund borrowings that were not properly authorized and approved, or uncollectible interfund loans that have not been properly reflected in the reporting packets or disclosed to you."]

{"sheet":"2.0.1","index":3,"n_rows":495,"n_cols":10,"rows_kept":495,"cut":false,"hidden":false,"merged":[[19,2,19,5],[12,2,12,5],[13,2,13,5],[15,2,15,5],[16,2,16,5],[17,2,17,5],[18,2,18,5],[11,2,11,5],[5,2,5,6],[6,2,6,5],[7,2,7,5],[9,2,9,5],[10,2,10,5],[3,0,3,7],[2,0,2,7],[1,0,1,7],[0,0,0,7],[4,0,4,7]]}
["STATE OF SOUTH CAROLINA"]
["YEAR-END REPORTING PACKAGE "]
["MASTER REPORTING PACKAGE CHECKLIST"]
[{"$f":"\"For the Fiscal Year Ended June 30, \"&Year","v":"For the Fiscal Year Ended June 30, 2021"}]
[]
["DUE",null,{"$f":"CONCATENATE(TEXT(DUEDATE,\"DDDD\"),\", \",TEXT(DUEDATE,\"M/D/YYYY\"))","v":"Friday, 7/9/2021"}]
["Agency:",null,{"$f":"IF(AgencyCode=\"\",\"\",AgencyCode)","v":"E120"}]
[null,null,{"$f":"IF(AgencyName=\"\",\"\",AgencyName)","v":"COMPTROLLER GENERAL'S OFFICE\n"}]
[]
["Preparer",null,{"$f":"IF('Signature Page'!E11=\"\",\"\",'Signature Page'!E11)","v":"Agency Preparer"}]
["Title",null,{"$f":"IF('Signature Page'!E12=\"\",\"\",'Signature Page'!E12)","v":"Fiscal Manager"}]
["Date",null,{"$f":"IF('Signature Page'!E10=\"\",\"\",'Signature Page'!E10)","v":"2021-07-08"}]
["email:",null,{"$f":"IF('Signature Page'!E13=\"\",\"\",'Signature Page'!E13)","v":"agencypreparer@agency.gov"}]
["Phone:",null,{"$f":"IF('Signature Page'!E14=\"\",\"\",'Signature Page'!E14)","v":"803 123-4567"}]
[]
["Reviewer",null,{"$f":"IF('Signature Page'!E19=\"\",\"\",'Signature Page'!E19)","v":"Agency Reviewer"}]
["Title",null,{"$f":"IF('Signature Page'!E20=\"\",\"\",'Signature Page'!E20)","v":"Director of Finance"}]
["Date",null,{"$f":"IF('Signature Page'!E17=\"\",\"\",'Signature Page'!E17)","v":"2021-07-09"}]
["email:",null,{"$f":"IF('Signature Page'!E21=\"\",\"\",'Signature Page'!E21)","v":"agencyreviewer@agency.gov"}]
["Phone:",null,{"$f":"IF('Signature Page'!E22=\"\",\"\",'Signature Page'!E22)","v":"803 123-4567"}]
[]
[]
[{"$f":"IF(B23=\"y\",COUNTA(B$27:B27),\"\")","v":""},null,"The following questions have been established in an outline hierarchy.  A NO response to a particular question advances to the next question of the same level (i.e. Number 1 response is NO move to Number 2, or NO is the response to part a of the question move to part b).  A YES response will require additional action through responses to additional questions at a sub-level, by completion of a Year-End Reporting Package, or by a requirement for submission of additional information with this Checklist."]
[]
["Saved File Naming Protocol"]
[]
[{"$f":"IF(B27=\"y\",COUNTA(B$27:B27),\"\")","v":1},"y",{"$f":"CONCATENATE(\"Is the file properly named with your Agency Business Area ID first (UPPER CASE) followed by packaged #? As in: \",AgencyCode,\"_2.0_Master Reporting Checklist_FY_21.xlsx\")","v":"Is the file properly named with your Agency Business Area ID first (UPPER CASE) followed by packaged #? As in: E120_2.0_Master Reporting Checklist_FY_21.xlsx"},null,null,null,"Yes",null,null,{"$f":"IF(LEFT(MID(CELL(\"filename\"),SEARCH(\"[\",CELL(\"filename\"))+1,SEARCH(\"]\",CELL(\"filename\"))-SEARCH(\"[\",CELL(\"filename\"))-1),4)=AgencyCode,\"Properly Saved\",CONCATENATE(\"Saved file name MUST begin with your Agency's Business Area Number (all UPPER CASE) followed by Package #: \",AgencyCode))","v":"Properly Saved"}]
[null,null,"*NOTE* ALL REPORTING PACKAGES SUBMITTED MUST FOLLOW THIS FORMAT"]
[{"$f":"IF(B29=\"y\",COUNTA(B$27:B29),\"\")","v":""}]
["Accounting and Auditing Best Practicies"]
[{"$f":"IF(B31=\"y\",COUNTA(B$27:B31),\"\")","v":""}]
[{"$f":"IF(B32=\"y\",COUNTA(B$27:B32),\"\")","v":2},"y","Each agency is responsible for designing and implementing processes, procedures, and controls to record and provide accurate and timely accounting information and to prevent and detect fraud.  As part of Best Practices for Internal Control, a review of the agency's general ledger either in detail or at a trial balance level should be performed at the beginning of the yearly closing procedures."]
[]
[null,null,"a.  Has a review of general ledger balances been performed at an agency wide level? ",null,null,null,"Yes"]
[{"$f":"IF(B35=\"y\",COUNTA(B$27:B35),\"\")","v":""}]
[null,null,"b.  Were any errors identified in the review performed for the beginning of year-end close for the current year ended June 30?",null,null,null,"No"]
[]
[{"$f":"IF(B38=\"y\",COUNTA(B$27:B38),\"\")","v":""},null,"Action:  Perform sufficient analysis and evaluation to identify and correct the errors prior to submission of related reporting package forms and the close of access to the general ledger.  "]
[{"$f":"IF(B39=\"y\",COUNTA(B$27:B39),\"\")","v":""}]
[{"$f":"IF(B40=\"y\",COUNTA(B$27:B40),\"\")","v":""}]
[{"$f":"IF(B41=\"y\",COUNTA(B$27:B41),\"\")","v":3},"y","As part of Best Practices for Internal Control, a review of the general ledger by detailed fund should be performed at the beginning and ending of the yearly closing procedures."]
[]
[null,null,"a.  Has a review of general ledger balances been performed at the accounting (detailed) fund level? ",null,null,null,"Yes"]
[]
[null,null,"b.  Were any errors identified in the review by fund for the beginning of year-end close for the current year ended June 30?",null,null,null,"No"]
[]
[{"$f":"IF(B47=\"y\",COUNTA(B$27:B47),\"\")","v":""},null,"Action:  Perform sufficient analysis and evaluation to identify and correct the errors prior to submission of related reporting package forms and the close of access to the general ledger.  "]
[{"$f":"IF(B48=\"y\",COUNTA(B$27:B48),\"\")","v":""}]
["3.01 Cash and Investments Reporting Package"]
[{"$f":"IF(B50=\"y\",COUNTA(B$27:B50),\"\")","v":""}]
[{"$f":"IF(B51=\"y\",COUNTA(B$27:B51),\"\")","v":4},"y","Is your agency authorized for a petty cash fund, cash on hand, or cash register change fund, collectively referred to as petty cash?  (Do not include a checking account used as petty cash.)",null,null,null,"Yes"]
[{"$f":"IF(B52=\"y\",COUNTA(B$27:B52),\"\")","v":""}]
[{"$f":"IF(B53=\"y\",COUNTA(B$27:B53),\"\")","v":""},null,"Action:  A Cash and Investments Reporting Package is required.  (See Section 3.01)"]
[]
[{"$f":"IF(B55=\"y\",COUNTA(B$27:B55),\"\")","v":5},"y","Does your agency have G/L account 1000050000 Petty Cash present on your Trial Balance (regardless of balance)?",null,null,null,"Yes"]
[{"$f":"IF(B56=\"y\",COUNTA(B$27:B56),\"\")","v":""}]
[{"$f":"IF(B57=\"y\",COUNTA(B$27:B57),\"\")","v":""},null,"Action:  A Cash and Investments Reporting Package is required.  (See Section 3.01)"]
[{"$f":"IF(B58=\"y\",COUNTA(B$27:B58),\"\")","v":""}]
[{"$f":"IF(B59=\"y\",COUNTA(B$27:B59),\"\")","v":6},"y","Does your agency have cash held in a bank account (including composite reservoir accounts) for which it receives periodic statements directly from the bank (cash on deposit with banks)?",null,null,null,"Yes"]
[{"$f":"IF(B60=\"y\",COUNTA(B$27:B60),\"\")","v":""}]
[{"$f":"IF(B61=\"y\",COUNTA(B$27:B61),\"\")","v":""},null,"Action:  A Cash and Investments Reporting Package is required.  (See Section 3.01)"]
[{"$f":"IF(B62=\"y\",COUNTA(B$27:B62),\"\")","v":""}]
[{"$f":"IF(B63=\"y\",COUNTA(B$27:B63),\"\")","v":7},"y","Does your agency have ownership in investments that are not managed or accounted for by the State Treasurer's Office? ",null,null,null,"Yes"]
[{"$f":"IF(B64=\"y\",COUNTA(B$27:B64),\"\")","v":""}]
[{"$f":"IF(B65=\"y\",COUNTA(B$27:B65),\"\")","v":""},null,"Action:  A Cash and Investments Reporting Package is required.  (See Section 3.01)"]
[{"$f":"IF(B66=\"y\",COUNTA(B$27:B66),\"\")","v":""}]
["3.02 Tax Revenue Reporting Package"]
[{"$f":"IF(B68=\"y\",COUNTA(B$27:B68),\"\")","v":""}]
[{"$f":"IF(B69=\"y\",COUNTA(B$27:B69),\"\")","v":8},"y","Did your agency collect and deposit any tax revenues during the fiscal year?  (If you collect sales taxes that are remitted to the South Carolina Department of Revenue for items sold in a gift shop, please answer no for this question.)",null,null,null,"Yes"]
[{"$f":"IF(B70=\"y\",COUNTA(B$27:B70),\"\")","v":""}]
[{"$f":"IF(B71=\"y\",COUNTA(B$27:B71),\"\")","v":""},null,"Action: A Tax Revenues Reporting Package is required.  (See Section 3.02)"]
[{"$f":"IF(B72=\"y\",COUNTA(B$27:B72),\"\")","v":""}]
[{"$f":"IF(B73=\"y\",COUNTA(B$27:B73),\"\")","v":9},"y","Is your agency required to pay interest on tax refunds?",null,null,null,"No"]
[]
[null,null,"Action:  Provide a schedule of the amounts paid as related to each tax source, detailed by accounting fund, general ledger (or object code), gross of related processing costs, with amounts paid to outside collection agencies as processing costs.  Submit the detailed schedule with the 3.02 Tax Revenue Reporting Package no later than August 9."]
[{"$f":"IF(B76=\"y\",COUNTA(B$27:B425),\"\")","v":""}]
["3.03 Grants and Contribution Revenue Reporting Package"]
[{"$f":"IF(B78=\"y\",COUNTA(B$27:B78),\"\")","v":""}]
[{"$f":"IF(B79=\"y\",COUNTA(B$27:B79),\"\")","v":10},"y","Did your agency receive resources from the federal government or other private granting organizations under an agreement which constitutes the service as a cash conduit (see Reporting Manual for further guidance on what constitutes a cash conduit) during the year?",null,null,null,"No"]
[]
[null,null,"Action:  A schedule of the total amount, by fund, passed through to non-State entities (as a cash conduit) is to be returned to the Comptroller General's Office with the Grants and Contributions Reporting Package.  "]
[]
[{"$f":"IF(B83=\"y\",COUNTA(B$27:B83),\"\")","v":""}]
[{"$f":"IF(B84=\"y\",COUNTA(B$27:B84),\"\")","v":11},"y","Did your agency receive funding from federal or private granting organizations through grant awards or contracts during the year?",null,null,null,"Yes"]
[{"$f":"IF(B85=\"y\",COUNTA(B$27:B85),\"\")","v":""}]
[{"$f":"IF(B86=\"y\",COUNTA(B$27:B86),\"\")","v":""},null,"Action:  A Grants and Contribution Revenue Reporting Package is required.  (See Section 3.03)"]
[{"$f":"IF(B87=\"y\",COUNTA(B$27:B87),\"\")","v":""}]
[{"$f":"IF(B88=\"y\",COUNTA(B$27:B88),\"\")","v":""}]
[{"$f":"IF(B89=\"y\",COUNTA(B$27:B89),\"\")","v":12},"y","Did your agency receive contributions or pledges (see Reporting Manual for definition and further guidance) during the fiscal year that were not received by June 30, but at June 30 were verifiable, measurable, and probable of collection?",null,null,null,"Yes"]
[{"$f":"IF(B90=\"y\",COUNTA(B$27:B90),\"\")","v":""}]
[{"$f":"IF(B91=\"y\",COUNTA(B$27:B91),\"\")","v":""},null,"Action:  A Grants and Contribution Revenue Reporting Package is required.  (See Section 3.03)"]
[{"$f":"IF(B92=\"y\",COUNTA(B$27:B92),\"\")","v":""}]
["3.04 Other Receivables Reporting Package"]
[]
[{"$f":"IF(B95=\"y\",COUNTA(B$27:B95),\"\")","v":13},"y","Does your agency have any other amounts owed to it as of June 30 from non-State entities (not accounted for in the previous 5 questions)?",null,null,null,"Yes"]
[{"$f":"IF(B96=\"y\",COUNTA(B$27:B96),\"\")","v":""}]
[{"$f":"IF(B97=\"y\",COUNTA(B$27:B97),\"\")","v":""},null,"Action:  A Other Receivables Reporting Package is required.  (See Section 3.04)"]
[]
[{"$f":"IF(B99=\"y\",COUNTA(B$27:B99),\"\")","v":""}]
[{"$f":"IF(B100=\"y\",COUNTA(B$27:B100),\"\")","v":14},"y","Does your agency have any interfund receivables individually under $100,000 not already in SCEIS?  Do not report amounts in account 1300020000 (ACCTS RECEIV – IDT) on any package. Amounts in account 1300020000 will be reclassified by the CG’s office as part of the Interfund procedures.",null,null,null,"Yes"]
[{"$f":"IF(B101=\"y\",COUNTA(B$27:B101),\"\")","v":""}]
[null,null,"Action:  A Other Receivables Reporting Package is required.  (See Section 3.04)"]
[{"$f":"IF(B103=\"y\",COUNTA(B$27:B103),\"\")","v":""}]
[{"$f":"IF(B104=\"y\",COUNTA(B$27:B104),\"\")","v":""}]
[{"$f":"IF(B105=\"y\",COUNTA(B$27:B105),\"\")","v":15},"y","Does your agency have a balance at year end in account 1300010000 (ACCOUNTS RECEIVABLE-CURRENT) and 1300030000 (ACCTS RECEIV CUR NR) in SCEIS?",null,null,null,"Yes"]
[{"$f":"IF(B106=\"y\",COUNTA(B$27:B106),\"\")","v":""}]
[{"$f":"IF(B107=\"y\",COUNTA(B$27:B107),\"\")","v":""},null,"Action:  A Other Receivables Reporting Package is required.  (See Section 3.04)"]
[{"$f":"IF(B108=\"y\",COUNTA(B$27:B108),\"\")","v":""}]
["3.05 Unearned Revenue Reporting Package"]
[{"$f":"IF(B110=\"y\",COUNTA(B$27:B110),\"\")","v":""}]
[{"$f":"IF(B111=\"y\",COUNTA(B$27:B111),\"\")","v":16},"y","Has your agency collected any unearned revenue as of June 30 for charges for goods and/or services collected in advance of the earnings process? ",null,null,null,"Yes"]
[{"$f":"IF(B112=\"y\",COUNTA(B$27:B112),\"\")","v":""}]
[{"$f":"IF(B113=\"y\",COUNTA(B$27:B113),\"\")","v":""},null,"Action:  A Unearned Revenue Reporting Package is required.  (See Section 3.05)"]
[{"$f":"IF(B114=\"y\",COUNTA(B$27:B114),\"\")","v":""}]
[{"$f":"IF(B115=\"y\",COUNTA(B$27:B115),\"\")","v":""}]
[{"$f":"IF(B116=\"y\",COUNTA(B$27:B116),\"\")","v":17},"y","Has your agency entered into a sale of receivables or factoring transaction (i.e. received a payment in exchange for surrendering the right to cash flows from collections of specific receivables or specific future revenues)?",null,null,null,"No"]
[{"$f":"IF(B117=\"y\",COUNTA(B$27:B117),\"\")","v":""}]
[{"$f":"IF(B118=\"y\",COUNTA(B$27:B118),\"\")","v":""},null,"Action:  Provide a description of the transaction (include the counter party of the transaction and any responsibilities for servicing retained by the agency) in an attachment to this Master Reporting Package Checklist to the Comptroller General's Office."]
[{"$f":"IF(B119=\"y\",COUNTA(B$27:B119),\"\")","v":""}]
["3.06 Inventory Reporting Package"]
[{"$f":"IF(B121=\"y\",COUNTA(B$27:B121),\"\")","v":""}]
[{"$f":"IF(B122=\"y\",COUNTA(B$27:B122),\"\")","v":18},"y","Did your agency have inventory on hand at year-end? ",null,null,null,"Yes"]
[{"$f":"IF(B123=\"y\",COUNTA(B$27:B123),\"\")","v":""}]
[{"$f":"IF(B124=\"y\",COUNTA(B$27:B124),\"\")","v":""},null,"Action: An Inventory Reporting Package is required (See Section 3.06)."]
[{"$f":"IF(B125=\"y\",COUNTA(B$27:B125),\"\")","v":""}]
[{"$f":"IF(B126=\"y\",COUNTA(B$27:B126),\"\")","v":""}]
[{"$f":"IF(B127=\"y\",COUNTA(B$27:B127),\"\")","v":19},"y","Did your agency have United States Department of Agriculture food supplies (commodities) at year-end?",null,null,null,"No"]
[{"$f":"IF(B128=\"y\",COUNTA(B$27:B128),\"\")","v":""}]
[{"$f":"IF(B129=\"y\",COUNTA(B$27:B129),\"\")","v":""},null,"Action: An Inventory Reporting Package is required (See Section 3.06)."]
[{"$f":"IF(B130=\"y\",COUNTA(B$27:B130),\"\")","v":""}]
["3.07 Prepaid Expenses Reporting Package"]
[{"$f":"IF(B132=\"y\",COUNTA(B$27:B132),\"\")","v":""}]
[{"$f":"IF(B133=\"y\",COUNTA(B$27:B133),\"\")","v":20},"y","At June 30, had your agency prepaid (paid prior to receipt of the good/service) any expenses that need to be reported? Agencies should not report a prepaid expense if 12 months of expenditures have already been recorded in the current year for recurring items that have been in existence. Agencies may exclude everything  individually under $10,000 up to $100,000 in aggregate from this reporting package (i.e., small items do not need to be reported as long as the total amount of items excluded does not exceed $100,000 for your agency).",null,null,null,"Yes"]
[]
[null,null,"Action: A Prepaid Expenses Reporting Package is required (See Section 3.07) ."]
[{"$f":"IF(B136=\"y\",COUNTA(B$27:B136),\"\")","v":""}]
["3.08 Capital Assets Reporting Package"]
[{"$f":"IF(B138=\"y\",COUNTA(B$27:B138),\"\")","v":""}]
[{"$f":"IF(B139=\"y\",COUNTA(B$27:B139),\"\")","v":21},"y","a. Were any capital assets reported by your agency at the end of the previous fiscal year through SCEIS reporting?",null,null,null,"Yes"]
[]
[{"$f":"IF(B141=\"y\",COUNTA(B$27:B141),\"\")","v":""},null,"Action:  A Capital Assets Reporting Package is required (See Section 3.08)."]
[]
[]
[null,null,"b. Were any capital assets reported by your agency at the end of the previous fiscal year through non-SCEIS reporting?",null,null,null,"No"]
[]
[{"$f":"IF(B146=\"y\",COUNTA(B$27:B146),\"\")","v":""},null,"Action:  A Capital Assets Reporting Package is required (See Section 3.08)."]
[{"$f":"IF(B147=\"y\",COUNTA(B$27:B147),\"\")","v":""}]
[{"$f":"IF(B148=\"y\",COUNTA(B$27:B148),\"\")","v":""}]
[{"$f":"IF(B149=\"y\",COUNTA(B$27:B149),\"\")","v":22},"y","Does your agency own any capital assets at June 30, recorded in SCEIS or other reporting?",null,null,null,"Yes"]
[{"$f":"IF(B150=\"y\",COUNTA(B$27:B150),\"\")","v":""}]
[{"$f":"IF(B151=\"y\",COUNTA(B$27:B151),\"\")","v":""},null,"Action:  A Capital Assets Reporting Package is required (See Section 3.08)."]
[{"$f":"IF(B152=\"y\",COUNTA(B$27:B152),\"\")","v":""}]
[{"$f":"IF(B153=\"y\",COUNTA(B$27:B153),\"\")","v":""}]
[{"$f":"IF(B154=\"y\",COUNTA(B$27:B154),\"\")","v":23},"y","Did your agency recognize any non-cash contributions or transfers of assets during the fiscal year?",null,null,null,"No"]
[{"$f":"IF(B155=\"y\",COUNTA(B$27:B155),\"\")","v":""}]
[{"$f":"IF(B156=\"y\",COUNTA(B$27:B156),\"\")","v":""},null,"Action:  A Capital Assets Reporting Package is required (See Section 3.08)."]
[{"$f":"IF(B157=\"y\",COUNTA(B$27:B157),\"\")","v":""}]
["3.09 Operating Lease Reporting Package"]
[{"$f":"IF(B159=\"y\",COUNTA(B$27:B159),\"\")","v":""}]
[{"$f":"IF(B160=\"y\",COUNTA(B$27:B160),\"\")","v":24},"y","Did your agency record any operating lease payments under lease agreements during the fiscal year?  This can include rental of PO Boxes, postage machines, etc.  Please use report provided by the CG's office as a guide for reporting rent and lease payment items.",null,null,null,"Yes"]
[null,null,"     "]
[{"$f":"IF(B162=\"y\",COUNTA(B$27:B162),\"\")","v":""},null,"Action:  An Operating Leases Reporting Package is required (See Section 3.09)."]
[{"$f":"IF(B163=\"y\",COUNTA(B$27:B163),\"\")","v":""}]
[{"$f":"IF(B164=\"y\",COUNTA(B$27:B164),\"\")","v":""}]
[{"$f":"IF(B165=\"y\",COUNTA(B$27:B165),\"\")","v":25},"y","Does your agency have noncancelable operating leases in effect at June 30 with future minimum required payments?",null,null,null,"No"]
[{"$f":"IF(B166=\"y\",COUNTA(B$27:B166),\"\")","v":""}]
[{"$f":"IF(B167=\"y\",COUNTA(B$27:B167),\"\")","v":""},null,"Action:  An Operating Leases Reporting Package is required (See Section 3.09)."]
[{"$f":"IF(B168=\"y\",COUNTA(B$27:B168),\"\")","v":""}]
[{"$f":"IF(B169=\"y\",COUNTA(B$27:B169),\"\")","v":""}]
[{"$f":"IF(B170=\"y\",COUNTA(B$27:B170),\"\")","v":26},"y","Did your agency collect any revenues from non-State parties under operating leases involving State-owned assets during the fiscal year?",null,null,null,"No"]
[{"$f":"IF(B171=\"y\",COUNTA(B$27:B171),\"\")","v":""}]
[{"$f":"IF(B172=\"y\",COUNTA(B$27:B172),\"\")","v":""},null,"Action:  An Operating Leases Reporting Package is required (See Section 3.09)."]
[{"$f":"IF(B173=\"y\",COUNTA(B$27:B173),\"\")","v":""}]
["Capital Lease - No Package Required at this time"]
[{"$f":"IF(B175=\"y\",COUNTA(B$27:B175),\"\")","v":""}]
[{"$f":"IF(B176=\"y\",COUNTA(B$27:B176),\"\")","v":27},"y","Are payments being made on lease agreements which meet the criteria for capital leases (see form Lease Register on the CG's website under GAAP Reporting?",null,null,null,"Yes"]
[null,null,null,null,{"$f":"IF(G176=\"\",\"\",IF(G176=\"Yes\",\"CONTINUE THE CHECKLIST WITH QUESTION 27.a.\",\"CONTINUE THE CHECKLIST WITH QUESTION 28.\"))","v":"CONTINUE THE CHECKLIST WITH QUESTION 27.a."}]
[null,null,"a.  Have the capital lease and terms of the contract been reported to the CG's office?",null,null,null,"Yes"]
[]
[null,null,{"$f":"IF(G178=\"\",\"\",IF(G178=\"Yes\",\"RESPOND AS NEEDED TO Sub-question I below.\",\"Action:    Provide the following:  Lease start date, amount of lease, vendor, equipment being leased,\"))","v":"RESPOND AS NEEDED TO Sub-question I below."}]
[]
[null,null,"i)  Are the assets acquired under capital leases reflected in the SCEIS Asset History Listing or other Asset Listing if not in SCEIS?",null,null,null,"Yes"]
[]
[null,null,{"$f":"IF(G182=\"\",\"\",IF(G182=\"No\",\"Action:  Provide the following information for the assets acquired under capital leases (even if not acquired in the current year).  Please provide the following information vendor, in-service date, value of asset, asset classification and life of asset..\",\"\"))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF(B192=\"y\",COUNTA(B$27:B192),\"\")","v":28},"y","Has the agency reviewed all leases entered into during the current fiscal year to determine if they have been properly classified as operating or capital lease?",null,null,null,"Yes"]
[]
["3.10 Loans Receivable Reporting Package"]
[{"$f":"IF(B195=\"y\",COUNTA(B$27:B195),\"\")","v":""}]
[{"$f":"IF(B196=\"y\",COUNTA(B$27:B196),\"\")","v":29},"y","Did your agency have any outstanding loans or notes receivable from non-State parties at the beginning of the year (July 1, 2020) OR end of the year (June 30, 2021)?",null,null,null,"Yes"]
[{"$f":"IF(B197=\"y\",COUNTA(B$27:B197),\"\")","v":""}]
[{"$f":"IF(B198=\"y\",COUNTA(B$27:B198),\"\")","v":""},null,"Action:  A Loan Receivables Reporting Package is required.  (See Section 3.10)"]
[{"$f":"IF(B199=\"y\",COUNTA(B$27:B199),\"\")","v":""}]
["3.12 Accounts Payable Reporting Package"]
[{"$f":"IF(B201=\"y\",COUNTA(B$27:B201),\"\")","v":""}]
[{"$f":"IF(B202=\"y\",COUNTA(B$27:B202),\"\")","v":30},"y","Did your agency receive goods or services prior to June 30 for which payment has not been made as of the close of A/P processing at year-end? In addition to payables due to outside entities, interfund payables individually under $100,000 are reported on 3.12.",null,null,null,"Yes"]
[{"$f":"IF(B203=\"y\",COUNTA(B$27:B203),\"\")","v":""}]
[{"$f":"IF(B204=\"y\",COUNTA(B$27:B204),\"\")","v":""},null,"Action:  An Accounts Payable Reporting Package is required (See Section 3.12) A/P processing continues past June 30 so a payable does not exist if amounts due as of June 30 were paid with that year’s funds i.e. paid during extended period 12 or period 13."]
[]
[{"$f":"IF(B206=\"y\",COUNTA(B$27:B206),\"\")","v":""}]
[{"$f":"IF(B207=\"y\",COUNTA(B$27:B207),\"\")","v":31},"y","Did your agency recognize expenditures in period 12 (June 1 - June 30) of the fiscal year? ",null,null,null,"Yes"]
[{"$f":"IF(B208=\"y\",COUNTA(B$27:B208),\"\")","v":""}]
[{"$f":"IF(B209=\"y\",COUNTA(B$27:B209),\"\")","v":""}]
[{"$f":"IF(B210=\"y\",COUNTA(B$27:B210),\"\")","v":32},"y","Did your agency receive goods or services prior to June 30 for which an invoice (billing) has not been received prior to the completion and submission of this checklist? In addition to payables due to outside entities, interfund payables individually under $100,000 are reported on 3.12.",null,null,null,"Yes"]
[{"$f":"IF(B211=\"y\",COUNTA(B$27:B211),\"\")","v":""}]
[]
[{"$f":"IF(B213=\"y\",COUNTA(B$27:B213),\"\")","v":""},null,"Action:  An Accounts Payable Reporting Package is required (See Section 3.12)Information relating to the billings for these goods and services should be reported based on billings received through the preparation of Section 3.12 and estimates should be reported for billings not received as of that date."]
[{"$f":"IF(B214=\"y\",COUNTA(B$27:B214),\"\")","v":""}]
["3.13 Litigation Reporting Package"]
[]
[{"$f":"IF(B217=\"y\",COUNTA(B$27:B217),\"\")","v":33},"y","Has your agency been involved in any litigation or made payments to private attorneys during the fiscal year?",null,null,null,"Yes"]
[{"$f":"IF(B218=\"y\",COUNTA(B$27:B218),\"\")","v":""}]
[{"$f":"IF(B219=\"y\",COUNTA(B$27:B219),\"\")","v":""},null,"Action:  The Litigation Reporting Package is required.  (See Section 3.13)"]
[{"$f":"IF(B220=\"y\",COUNTA(B$27:B261),\"\")","v":""}]
["3.14 Disallowances and Penalties Reporting Package"]
[{"$f":"IF(B222=\"y\",COUNTA(B$27:B222),\"\")","v":""}]
[{"$f":"IF(B223=\"y\",COUNTA(B$27:B223),\"\")","v":34},"y","Has your agency agreed to make payments or accept reduced revenues after year-end resulting from non-compliance with regulations or the violation of rules or federal program requirements that occurred before year-end?  (i.e. Has an agreement been reached to make payments or accept reduced revenues in a future State fiscal year as a result of past events that caused a disallowance or penalty?)",null,null,null,"Yes"]
[]
[{"$f":"IF(B225=\"y\",COUNTA(B$27:B225),\"\")","v":""},null,"Action:  A Disallowances and Penalties Reporting Package is required (See Section 3.14)."]
[{"$f":"IF(B226=\"y\",COUNTA(B$27:B226),\"\")","v":""}]
[{"$f":"IF(B227=\"y\",COUNTA(B$27:B227),\"\")","v":""}]
[{"$f":"IF(B228=\"y\",COUNTA(B$27:B228),\"\")","v":35},"y","Did your agency have any other disallowance or penalty situations that may require future payments or reduced revenues after June 30? (See section 3.14 of the Reporting Policies and Procedures Manual for other disallowance and penalty situations that will be reported as part of the subsequent events reporting package such as disallowances or penalties that are probable, reasonably possible, or occur after June 30.)",null,null,null,"No"]
[]
[{"$f":"IF(B230=\"y\",COUNTA(B$27:B230),\"\")","v":""},null,"Action: The subsequent events reporting package will request additional information, such as the fund(s) responsible for payment, State fiscal year amounts are due, a description of the situation, name of the entity assessing the disallowance or penalty, information about a receivable from outside the State reporting entity for a portion or all of this liability (if applicable), pass-through information (if applicable),timing of when the disallowance or penalty was identified, an estimate of the liability or estimate range or explanation why no estimate is available, and if an estimate range is used please also include if some amount within the range appears at the time to be a better estimate than any other amount within the range or if no amount within the range is a better estimate than any other amount. If possible, send a copy of related correspondences with the entity assessing the disallowance or penalty, the outside entity paying a portion or all of this liability (if applicable), and the pass-through entity (if applicable)."]
[]
["Payroll and Accrued Compensation Reporting"]
[{"$f":"IF(B233=\"y\",COUNTA(B$27:B233),\"\")","v":""}]
[{"$f":"IF(B234=\"y\",COUNTA(B$27:B234),\"\")","v":36},"y","Will the August or later payrolls include payments due to employees, including retirees, who terminated State employment on or before June 30?",null,null,null,"No"]
[{"$f":"IF(B235=\"y\",COUNTA(B$27:B235),\"\")","v":""}]
[null,null,"Action:  Provide the following information:"]
[]
[null,null,"Fund",null,"Employee Gross Pay",null,"Date to be paid"]
[]
[]
[{"$f":"IF(B241=\"y\",COUNTA(B$27:B241),\"\")","v":""}]
[{"$f":"IF(B242=\"y\",COUNTA(B$27:B242),\"\")","v":""}]
[{"$f":"IF(B243=\"y\",COUNTA(B$27:B243),\"\")","v":37},"y","Did your agency offer special termination benefits to any employees during the fiscal year for which the payout was NOT made on or before June 30?",null,null,null,"No"]
[{"$f":"IF(B244=\"y\",COUNTA(B$27:B244),\"\")","v":""}]
[null,null,"Action:  Provide the following information:"]
[]
[null,null,"Fund",null,"Amount to be paid",null,"Date to be paid"]
[]
[]
[{"$f":"IF(B250=\"y\",COUNTA(B$27:B250),\"\")","v":""}]
[{"$f":"IF(B251=\"y\",COUNTA(B$27:B251),\"\")","v":""}]
[{"$f":"IF(B252=\"y\",COUNTA(B$27:B252),\"\")","v":""}]
[{"$f":"IF(B253=\"y\",COUNTA(B$27:B253),\"\")","v":38},"y","Does another entity that is legally separate from the State of South Carolina make payments for salaries and benefits for employees who work to carry out your agency's programs?",null,null,null,"No"]
[{"$f":"IF(B254=\"y\",COUNTA(B$27:B254),\"\")","v":""}]
[null,null,"Action:  Provide the following information:"]
[]
[null,null,"Entity",null,"Amount to be paid",null,"Date to be paid"]
[]
[]
[{"$f":"IF(B260=\"y\",COUNTA(B$27:B260),\"\")","v":""}]
[{"$f":"IF(B261=\"y\",COUNTA(B$27:B261),\"\")","v":""}]
["3.15 Claims Reporting Package"]
[{"$f":"IF(B263=\"y\",COUNTA(B$27:B263),\"\")","v":""}]
[{"$f":"IF(B264=\"y\",COUNTA(B$27:B264),\"\")","v":39},"y","Does your agency have claims in excess of $100,000 for EITHER:",null,null,null,"Yes"]
[{"$f":"IF(B265=\"y\",COUNTA(B$27:B265),\"\")","v":""},null,"--  Any self-insured risk to which it is exposed?"]
[{"$f":"IF(B266=\"y\",COUNTA(B$27:B266),\"\")","v":""},null,"OR"]
[{"$f":"IF(B267=\"y\",COUNTA(B$27:B267),\"\")","v":""},null,"--  Any claim-paying program it manages?"]
[{"$f":"IF(B268=\"y\",COUNTA(B$27:B268),\"\")","v":""}]
[{"$f":"IF(B269=\"y\",COUNTA(B$27:B269),\"\")","v":""},null,"Action:  The Claims Reporting Package is required.  (See Section 3.15)"]
[{"$f":"IF(B270=\"y\",COUNTA(B$27:B270),\"\")","v":""}]
["3.16 Miscellaneous Loss Liabilities, Loss Contingencies, and Commitments Reporting Package"]
[{"$f":"IF(B272=\"y\",COUNTA(B$27:B272),\"\")","v":""}]
[{"$f":"IF(B273=\"y\",COUNTA(B$27:B273),\"\")","v":40},"y","Did your agency either ",null,null,null,"Yes"]
[null,null,"-- receive notification from a fee for service contract counter-part (typically the Federal "]
[null,null,"Government) of a rejection of submitted charges"]
[{"$f":"IF(B276=\"y\",COUNTA(B$27:B276),\"\")","v":""},null,"OR"]
[null,null,"-- incur any miscellaneous loss liabilities or miscellaneous loss contingencies  "]
[null,null,"during the fiscal year?"]
[null,null,"OR"]
[null,null,"-- have any miscellaneous commitments with outstanding balances at June 30?"]
[{"$f":"IF(B281=\"y\",COUNTA(B$27:B281),\"\")","v":""}]
[{"$f":"IF(B282=\"y\",COUNTA(B$27:B282),\"\")","v":""},null,"Action:  The Miscellaneous Loss Liabilities, Loss Contingencies, and Commitments Reporting Package is required.   (See Section 3.16)"]
[{"$f":"IF(B283=\"y\",COUNTA(B$27:B283),\"\")","v":""}]
[{"$f":"IF(B284=\"y\",COUNTA(B$27:B284),\"\")","v":""}]
[{"$f":"IF(B285=\"y\",COUNTA(B$27:B285),\"\")","v":41},"y","At June 30, have any events occurred for which your agency has yet to pay the related insurance deductible?",null,null,null,"No"]
[{"$f":"IF(B286=\"y\",COUNTA(B$27:B286),\"\")","v":""}]
[{"$f":"IF(B287=\"y\",COUNTA(B$27:B287),\"\")","v":""},null,"Action:  The Miscellaneous Loss Liabilities, Loss Contingencies, and Commitments Reporting Package is required.   (See Section 3.16.1)"]
[{"$f":"IF(B288=\"y\",COUNTA(B$27:B288),\"\")","v":""}]
[{"$f":"IF(B289=\"y\",COUNTA(B$27:B425),\"\")","v":""}]
["3.18 Interfund Payables and Receiables Reporting Package"]
[]
[{"$f":"IF(B292=\"y\",COUNTA(B$27:B292),\"\")","v":42},"y","Did your agency have unprocessed payment IDT's (unpaid) and/or disbursement vouchers individually over $100,000 to another agency within the State's financial reporting entity as of June 30?",null,null,null,"Yes"]
[{"$f":"IF(B293=\"y\",COUNTA(B$27:B293),\"\")","v":""}]
[{"$f":"IF(B294=\"y\",COUNTA(B$27:B294),\"\")","v":""},null,"Action:  The Interfund Payables Reporting Package is required (See Section 3.18)."]
[{"$f":"IF(B295=\"y\",COUNTA(B$27:B295),\"\")","v":""}]
[{"$f":"IF(B296=\"y\",COUNTA(B$27:B296),\"\")","v":""}]
[{"$f":"IF(B297=\"y\",COUNTA(B$27:B297),\"\")","v":""}]
[{"$f":"IF(B298=\"y\",COUNTA(B$27:B298),\"\")","v":43},"y","Has your agency entered into other transactions individually over $100,000 with other state agencies which would give rise to a receivable or payable owed to or from the other agency as of June 30?",null,null,null,"Yes"]
[{"$f":"IF(B299=\"y\",COUNTA(B$27:B299),\"\")","v":""}]
[{"$f":"IF(B300=\"y\",COUNTA(B$27:B300),\"\")","v":""},null,"Action:  The Interfund Payables Reporting Package is required (See Section 3.18)."]
[{"$f":"IF(B301=\"y\",COUNTA(B$27:B301),\"\")","v":""}]
[{"$f":"IF(B302=\"y\",COUNTA(B$27:B302),\"\")","v":""}]
[{"$f":"IF(B303=\"y\",COUNTA(B$27:B303),\"\")","v":""}]
[{"$f":"IF(B304=\"y\",COUNTA(B$27:B304),\"\")","v":44},"y","The Comptroller General's Office obtains information relating to inter-agency/interfund loans from the State Treasurer's Office and the Department of Administration as follows:"]
[{"$f":"IF(B305=\"y\",COUNTA(B$27:B305),\"\")","v":""}]
[{"$f":"IF(B306=\"y\",COUNTA(B$27:B306),\"\")","v":""},null,"Insurance Reserve Fund Loans"]
[null,null,"Capital Improvement Bond Proceeds Loans"]
[{"$f":"IF(B308=\"y\",COUNTA(B$27:B308),\"\")","v":""},null,"Office of Energy Loans"]
[]
[null,null,"Does your agency have any notes or loans payable or receivable outstanding at June 30 with other State agencies (including State universities and technical colleges) under any program NOT listed above?",null,null,null,"No"]
[{"$f":"IF(B311=\"y\",COUNTA(B$27:B311),\"\")","v":""}]
[{"$f":"IF(B312=\"y\",COUNTA(B$27:B312),\"\")","v":""},null,"Action:  Provide the following information (if additional space is needed, click the Show Worksheet 36. (Cont) button below)"]
[]
[null,null,"Is your agency the lender or borrower?"]
[null,null,"Name of counter-party (other agency involved)?"]
[null,null,"Original amount of the loan"]
[null,null,"Date of the original loan"]
[null,null,"Additional advances made"]
[null,null,"Dates of additional advances"]
[null,null,"Balance as of June 30"]
[null,null,"Number of Payments required"]
[null,null,"Frequency of payments required (selections in drop-down)"]
[null,null,"Copies of signed agreements (for new loans only)."]
[]
[{"$f":"IF(B325=\"y\",COUNTA(B$27:B325),\"\")","v":""},null,"SET MACRO'S TO ENABLE "]
[{"$f":"IF(B326=\"y\",COUNTA(B$27:B326),\"\")","v":""}]
["Additional Information to be submitted with this Master Reporting Package Checklist"]
[]
[{"$f":"IF(B329=\"y\",COUNTA(B$27:B329),\"\")","v":45},"y","Does your agency have any loans or notes payable/receivable at June 30 between funds within your agency?",null,null,null,"Yes"]
[{"$f":"IF(B330=\"y\",COUNTA(B$27:B330),\"\")","v":""}]
[{"$f":"IF(B331=\"y\",COUNTA(B$27:B331),\"\")","v":""},null,"Action:  Describe the situation in a letter or other attachment when you return this Master Reporting Package Checklist to the Comptroller General's Office.  Please provide copies of signed agreements for any new loans."]
[{"$f":"IF(B332=\"y\",COUNTA(B$27:B332),\"\")","v":""}]
[{"$f":"IF(B333=\"y\",COUNTA(B$27:B333),\"\")","v":""}]
[{"$f":"IF(B334=\"y\",COUNTA(B$27:B334),\"\")","v":46},"y","Has your agency provided resources to or received resources from another agency with an understanding that the resources were borrowed but no note or repayment contract was executed for the transaction?",null,null,null,"Yes"]
[{"$f":"IF(B335=\"y\",COUNTA(B$27:B335),\"\")","v":""}]
[{"$f":"IF(B336=\"y\",COUNTA(B$27:B336),\"\")","v":""},null,"Action:  Describe the situation in a letter or other attachment when you return this Master Reporting Package Checklist to the Comptroller General's Office.  Please provide details of your understanding with the other agency."]
[{"$f":"IF(B337=\"y\",COUNTA(B$27:B337),\"\")","v":""}]
[{"$f":"IF(B338=\"y\",COUNTA(B$27:B338),\"\")","v":""}]
[{"$f":"IF(B339=\"y\",COUNTA(B$27:B339),\"\")","v":47},"y","Have resources been provided by one fund within your agency to another fund within your agency with an understanding that the resources were borrowed but no note or repayment contract was executed for the transaction?",null,null,null,"Yes"]
[{"$f":"IF(B340=\"y\",COUNTA(B$27:B340),\"\")","v":""}]
[{"$f":"IF(B341=\"y\",COUNTA(B$27:B341),\"\")","v":""},null,"Action:  Describe the situation in a letter or other attachment when you return this Master Reporting Package Checklist to the Comptroller General's Office.  Please provide details of the plans for return of resources (repayment) between the funds within your agency."]
[{"$f":"IF(B342=\"y\",COUNTA(B$27:B342),\"\")","v":""}]
[{"$f":"IF(B343=\"y\",COUNTA(B$27:B343),\"\")","v":""}]
[{"$f":"IF(B344=\"y\",COUNTA(B$27:B344),\"\")","v":48},"y","The State Treasurer's Office Master Lease Program provides financing for equipment purchases of $100,000 or greater.  Borrowings under this program are notes rather than leases for accounting and reporting purposes.   Did your agency have any outstanding balance on financing agreements under the State Treasurer's Office Master Lease Program as of June 30?",null,null,null,"Yes"]
[{"$f":"IF(B345=\"y\",COUNTA(B$27:B345),\"\")","v":""}]
[{"$f":"IF(B346=\"y\",COUNTA(B$27:B346),\"\")","v":""},null,"a.   Did your agency have any loan proceeds held in an escrow account at June 30 for any loans under this program?",null,null,null,"No"]
[{"$f":"IF(B347=\"y\",COUNTA(B$27:B347),\"\")","v":""}]
[{"$f":"IF(B348=\"y\",COUNTA(B$27:B348),\"\")","v":""},null,"Action:  Provide the following information (if additional space is needed, click the Show Worksheet 42. (Cont) button below)"]
[]
[{"$f":"IF(B350=\"y\",COUNTA(B$27:B350),\"\")","v":""},null,"Lease ID #"]
[{"$f":"IF(B351=\"y\",COUNTA(B$27:B351),\"\")","v":""},null,"Amount held in escrow"]
[{"$f":"IF(B352=\"y\",COUNTA(B$27:B352),\"\")","v":""}]
[{"$f":"IF(B353=\"y\",COUNTA(B$27:B353),\"\")","v":""},null,"b.   Did your agency have an escrow account for this program closed out during the fiscal year?",null,null,null,"No"]
[{"$f":"IF(B354=\"y\",COUNTA(B$27:B354),\"\")","v":""}]
[{"$f":"IF(B355=\"y\",COUNTA(B$27:B355),\"\")","v":""},null,"Action:  Provide the following information (if additional space is needed, click the Show Worksheet 42. (Cont) button below)"]
[]
[{"$f":"IF(B357=\"y\",COUNTA(B$27:B357),\"\")","v":""},null,"Lease ID #(s)"]
[{"$f":"IF(B358=\"y\",COUNTA(B$27:B358),\"\")","v":""},null,"Date the escrow account was closed checklist."]
[]
[null,null,"c.  Was an asset(s) established in the SCEIS system?",null,null,null,"Yes"]
[]
[null,null,{"$f":"IF(G360=\"\",\"\",IF(G360=\"Yes\",\"Action:   Please provide Asset(s) number(s) below.\",\"Action:  Please provide the following information vendor, in-service date, value of asset, asset classification and life of asset.\"))","v":"Action:   Please provide Asset(s) number(s) below."}]
[]
[]
[]
[]
[]
[]
[{"$f":"IF(B369=\"y\",COUNTA(B$27:B369),\"\")","v":""}]
[{"$f":"IF(B370=\"y\",COUNTA(B$27:B370),\"\")","v":""},null,"SET MACRO'S TO ENABLE "]
[{"$f":"IF(B371=\"y\",COUNTA(B$27:B371),\"\")","v":""}]
[{"$f":"IF(B372=\"y\",COUNTA(B$27:B372),\"\")","v":49},"y","Did your agency have any outstanding loan balance on any loans under the State Treasurer's Office Master Lease Program at the beginning of the year?",null,null,null,"Yes"]
[{"$f":"IF(B373=\"y\",COUNTA(B$27:B373),\"\")","v":""}]
[{"$f":"IF(B374=\"y\",COUNTA(B$27:B374),\"\")","v":""},null,"a.  Did your agency pay off any loans under this program during the fiscal year ended June 30?",null,null,null,"No"]
[{"$f":"IF(B375=\"y\",COUNTA(B$27:B375),\"\")","v":""}]
[{"$f":"IF(B376=\"y\",COUNTA(B$27:B376),\"\")","v":""},null,"Action:  Provide a listing including Lease ID #(s), amount(s), and payment date(s) as an attachment when you return this Master Reporting Package Checklist to the Comptroller General's Office."]
[]
[null,null,"b.   Did your agency have an escrow account for this program closed out during the fiscal year?",null,null,null,"No"]
[]
[{"$f":"IF(B380=\"y\",COUNTA(B$27:B380),\"\")","v":""},null,"Action:  Provide the following information (if additional space is needed, attach a sheet)"]
[]
[{"$f":"IF(B382=\"y\",COUNTA(B$27:B382),\"\")","v":""},null,"Lease ID #(s)"]
[{"$f":"IF(B383=\"y\",COUNTA(B$27:B383),\"\")","v":""},null,"Date the escrow account was closed checklist."]
[{"$f":"IF(B384=\"y\",COUNTA(B$27:B384),\"\")","v":""}]
[{"$f":"IF(B385=\"y\",COUNTA(B$27:B385),\"\")","v":""}]
[{"$f":"IF(B386=\"y\",COUNTA(B$27:B386),\"\")","v":50},"y","Did your agency provide payment under the SCEIS financing agreement to the State Treasurer's Office during the year?",null,null,null,"No"]
[{"$f":"IF(B387=\"y\",COUNTA(B$27:B387),\"\")","v":""}]
[{"$f":"IF(B388=\"y\",COUNTA(B$27:B388),\"\")","v":""},null,"Action:  Provide the following information (if additional space is needed, click the Show Worksheet 44. (Cont) button below)"]
[]
[null,null,"Principle"]
[{"$f":"IF(B391=\"y\",COUNTA(B$27:B391),\"\")","v":""},null,"General Ledger Account"]
[{"$f":"IF(B392=\"y\",COUNTA(B$27:B392),\"\")","v":""},null,"Amount"]
[]
[null,null,"Interest"]
[{"$f":"IF(B395=\"y\",COUNTA(B$27:B395),\"\")","v":""},null,"General Ledger Account"]
[{"$f":"IF(B396=\"y\",COUNTA(B$27:B396),\"\")","v":""},null,"Amount"]
[{"$f":"IF(B397=\"y\",COUNTA(B$27:B397),\"\")","v":""}]
[{"$f":"IF(B398=\"y\",COUNTA(B$27:B398),\"\")","v":""},null,"SET MACRO'S TO ENABLE "]
[{"$f":"IF(B399=\"y\",COUNTA(B$27:B399),\"\")","v":""}]
[{"$f":"IF(B400=\"y\",COUNTA(B$27:B400),\"\")","v":51},"y","Has your agency used installment purchase financing (loans or notes) for acquisition?",null,null,null,"No"]
[{"$f":"IF(B401=\"y\",COUNTA(B$27:B401),\"\")","v":""}]
[{"$f":"IF(B402=\"y\",COUNTA(B$27:B402),\"\")","v":""},null,"a. State policy requires that all installment purchase agreements and terms of the contract be reported to the State Treasurer's Office, is your agency in violation of this policy? ",null,null,null,"No"]
[{"$f":"IF(B403=\"y\",COUNTA(B$27:B403),\"\")","v":""}]
[{"$f":"IF(B404=\"y\",COUNTA(B$27:B404),\"\")","v":""}]
[null,null,"Action:  Provide a listing including Name of Lender, identification of asset purchased, whether collateral secures the note, current year activity (including beginning balance, advances, repayments, and ending balance), and future payments (amount(s) and payment date(s)) as an attachment when you return this Master Reporting Package Checklist to the Comptroller General's Office."]
[{"$f":"IF(B406=\"y\",COUNTA(B$27:B406),\"\")","v":""}]
[{"$f":"IF(B407=\"y\",COUNTA(B$27:B407),\"\")","v":""}]
[{"$f":"IF(B408=\"y\",COUNTA(B$27:B408),\"\")","v":52},"y","The Comptroller General's Office obtains certain information relating to bonds and notes payable directly from the State Treasurer's Office. The types of bonds and notes are as follows:"]
[{"$f":"IF(B409=\"y\",COUNTA(B$27:B409),\"\")","v":""}]
[{"$f":"IF(B410=\"y\",COUNTA(B$27:B410),\"\")","v":""},null,"School Bonds"]
[{"$f":"IF(B411=\"y\",COUNTA(B$27:B411),\"\")","v":""},null,"State Institution Bonds and Notes"]
[{"$f":"IF(B412=\"y\",COUNTA(B$27:B412),\"\")","v":""},null,"Capital Improvement Bonds"]
[null,null,"Richard B. Russell Dam Debt"]
[{"$f":"IF(B414=\"y\",COUNTA(B$27:B414),\"\")","v":""},null,"Heritage Trust Revenue Bonds"]
[null,null,"Lease Revenue Bonds"]
[{"$f":"IF(B416=\"y\",COUNTA(B$27:B416),\"\")","v":""},null,"State Air Carrier Hub Bonds"]
[{"$f":"IF(B417=\"y\",COUNTA(B$27:B417),\"\")","v":""},null,"State Treasurer's Office Master Lease Program"]
[{"$f":"IF(B418=\"y\",COUNTA(B$27:B418),\"\")","v":""},null,"State Facilities Installment Purchase Revenue Bonds"]
[{"$f":"IF(B419=\"y\",COUNTA(B$27:B419),\"\")","v":""},null,"State Economic Development Bonds"]
[]
[{"$f":"IF(B421=\"y\",COUNTA(B$27:B421),\"\")","v":""},null,"Does your agency have any bonds or notes outstanding and payable to parties outside State government at June 30 or any other borrowings from parties outside the State NOT listed above?",null,null,null,"No"]
[{"$f":"IF(B422=\"y\",COUNTA(B$27:B422),\"\")","v":""}]
[{"$f":"IF(B423=\"y\",COUNTA(B$27:B423),\"\")","v":""},null,"Action:  Describe the situation in a letter or other attachment to this Master Reporting Package Checklist to the Comptroller General's Office.  Include authorization, Lender, Amount of Note, Date of Note, Collateral, Terms of repayment, and Balance as of year-end."]
[{"$f":"IF(B424=\"y\",COUNTA(B$27:B424),\"\")","v":""}]
[{"$f":"IF(B425=\"y\",COUNTA(B$27:B425),\"\")","v":""}]
[{"$f":"IF(B426=\"y\",COUNTA(B$27:B426),\"\")","v":53},"y","Does your agency participate in or administer any risk management activities other than those listed in Appendix C of the Year-End Reporting Procedures Manual?",null,null,null,"No"]
[{"$f":"IF(B427=\"y\",COUNTA(B$27:B427),\"\")","v":""}]
[{"$f":"IF(B428=\"y\",COUNTA(B$27:B428),\"\")","v":""},null,"Action:  Describe the situation in a letter or other attachment when you return this Master Reporting Package Checklist to the Comptroller General's Office. Be sure to fully describe the activity and whether you self-insure the activity, purchase insurance to cover the activity, or provide insurance coverage to other entities for this activity.  Also, please include the name and phone number of a person within your agency that we may contact to obtain additional information,  if necessary."]
[{"$f":"IF(B429=\"y\",COUNTA(B$27:B429),\"\")","v":""}]
[{"$f":"IF(B430=\"y\",COUNTA(B$27:B430),\"\")","v":""}]
[{"$f":"IF(B431=\"y\",COUNTA(B$27:B431),\"\")","v":54},"y","Does your agency use any non-State entities to process transactions (outsourced services - not including credit card payments)?",null,null,null,"No"]
[{"$f":"IF(B432=\"y\",COUNTA(B$27:B432),\"\")","v":""}]
[{"$f":"IF(B433=\"y\",COUNTA(B$27:B433),\"\")","v":""},null,"Action:  Describe the situation in a letter or other attachment (include specifics of the service agreement, the volume of transactions processed, the dollar amount of transactions processed, and procedures performed by the agency to ensure appropriate controls are in place for accuracy in recognition and reporting) when you return this Master Reporting Package Checklist to the Comptroller General's Office."]
[{"$f":"IF(B434=\"y\",COUNTA(B$27:B434),\"\")","v":""}]
[{"$f":"IF(B435=\"y\",COUNTA(B$27:B435),\"\")","v":""}]
[{"$f":"IF(B436=\"y\",COUNTA(B$27:B436),\"\")","v":55},"y","Each agency is responsible for designing and implementing processes, procedures, and controls to prevent and detect fraud.  Are you aware of any instances of fraud or suspected fraud affecting your agency during the fiscal year ended June 30 involving (a) management,  (b) employees who have significant roles in internal control, or (c) others where the fraud could have a financial impact on the agency.",null,null,null,"Yes"]
[{"$f":"IF(B437=\"y\",COUNTA(B$27:B437),\"\")","v":""}]
[{"$f":"IF(B438=\"y\",COUNTA(B$27:B438),\"\")","v":""},null,"Action:   Describe the situation on agency letterhead signed by the Agency Director or designee when this Master Reporting Package Checklist is returned to the Comptroller General's Office.  Be sure to fully describe the activity, the amount (or approximate amount) of the fraud or suspected fraud, and the resulting actions by management to prevent further fraudulent activities."]
[{"$f":"IF(B439=\"y\",COUNTA(B$27:B439),\"\")","v":""}]
[{"$f":"IF(B440=\"y\",COUNTA(B$27:B440),\"\")","v":""}]
[{"$f":"IF(B441=\"y\",COUNTA(B$27:B441),\"\")","v":56},"y","Are you aware of any allegations of fraud or suspected fraud affecting your agency during the fiscal year ended June 30 (e.g., that the agency has received in communications from employees, former employees, analysts, regulators, short sellers, or others)?",null,null,null,"No"]
[{"$f":"IF(B442=\"y\",COUNTA(B$27:B442),\"\")","v":""}]
[{"$f":"IF(B443=\"y\",COUNTA(B$27:B443),\"\")","v":""},null,"Action:   Describe the situation on agency letterhead signed by the Agency Director or designee when this Master Reporting Package Checklist is returned to the Comptroller General's Office.  Be sure to fully describe the allegation(s) and any actions taken by management to strengthen the internal controls that may have been breached if the allegations prove true."]
[{"$f":"IF(B444=\"y\",COUNTA(B$27:B444),\"\")","v":""}]
[{"$f":"IF(B445=\"y\",COUNTA(B$27:B445),\"\")","v":""}]
[{"$f":"IF(B446=\"y\",COUNTA(B$27:B446),\"\")","v":57},"y","Has your agency had any communications from regulatory agencies concerning noncompliance with, or deficiencies in, financial reporting practices?",null,null,null,"No"]
[{"$f":"IF(B447=\"y\",COUNTA(B$27:B447),\"\")","v":""}]
[{"$f":"IF(B448=\"y\",COUNTA(B$27:B448),\"\")","v":""},null,"Action:   Provide copies of the communications and a summary of the corrective actions when this Master Reporting Package Checklist is returned to the Comptroller General's Office.  "]
[{"$f":"IF(B449=\"y\",COUNTA(B$27:B449),\"\")","v":""}]
[{"$f":"IF(B450=\"y\",COUNTA(B$27:B450),\"\")","v":""}]
[{"$f":"IF(B451=\"y\",COUNTA(B$27:B451),\"\")","v":58},"y","Has your agency had either of the following situations:",null,null,null,"No"]
[{"$f":"IF(B452=\"y\",COUNTA(B$27:B452),\"\")","v":""},null,"--  Any violations or possible violations of laws or regulations that will not be reported"]
[{"$f":"IF(B453=\"y\",COUNTA(B$27:B453),\"\")","v":""},null,"in an existing reporting package?"]
[{"$f":"IF(B454=\"y\",COUNTA(B$27:B454),\"\")","v":""},null,"OR"]
[{"$f":"IF(B455=\"y\",COUNTA(B$27:B455),\"\")","v":""},null,"--  Any instances of noncompliance with applicable laws, regulations, contracts and"]
[{"$f":"IF(B456=\"y\",COUNTA(B$27:B456),\"\")","v":""},null,"grants that will not be reported in an existing reporting package or addressed in "]
[{"$f":"IF(B457=\"y\",COUNTA(B$27:B457),\"\")","v":""},null,"the previous question regarding financial reporting practices? "]
[{"$f":"IF(B458=\"y\",COUNTA(B$27:B458),\"\")","v":""}]
[{"$f":"IF(B459=\"y\",COUNTA(B$27:B459),\"\")","v":""},null,"Action:  Provide an explanation of the violation or instance of noncompliance as an attachment to this Master Reporting Package Checklist to the Comptroller General's Office."]
[{"$f":"IF(B460=\"y\",COUNTA(B$27:B460),\"\")","v":""}]
[{"$f":"IF(B461=\"y\",COUNTA(B$27:B461),\"\")","v":""}]
[{"$f":"IF(B462=\"y\",COUNTA(B$27:B462),\"\")","v":59},"y","Does your agency know or reasonably believe a site is polluted or contaminated?",null,null,null,"No"]
[{"$f":"IF(B463=\"y\",COUNTA(B$27:B463),\"\")","v":""}]
[{"$f":"IF(B464=\"y\",COUNTA(B$27:B464),\"\")","v":""},null,"a. Has your agency been compelled to take remediation action because pollution creates an imminent endangerment to public health or welfare or the environment?",null,null,null,"No"]
[{"$f":"IF(B465=\"y\",COUNTA(B$27:B465),\"\")","v":""}]
[null,null,"Action:  Please create and attach a list of the events identified, including a brief description of the potential obligation and the status of assessment of the event when this Master Reporting Package Checklist is returned to the Comptroller General's Office."]
[{"$f":"IF(B467=\"y\",COUNTA(B$27:B467),\"\")","v":""}]
[{"$f":"IF(B468=\"y\",COUNTA(B$27:B468),\"\")","v":""},null,"b. Has your agency violated a pollution prevention-related permit or license? ",null,null,null,"No"]
[]
[null,null,"Action:  Please create and attach a list of the events identified, including a brief description of the potential obligation and the status of assessment of the event when this Master Reporting Package Checklist is returned to the Comptroller General's Office."]
[{"$f":"IF(B471=\"y\",COUNTA(B$27:B471),\"\")","v":""}]
[{"$f":"IF(B472=\"y\",COUNTA(B$27:B472),\"\")","v":""},null,"c. Has your agency been named, or does evidence indicate that your agency will be named, by a regulator as a responsible party or potentially responsible party for remediation, or as a government responsible for sharing costs?",null,null,null,"No"]
[]
[null,null,"Action:  Please create and attach a list of the events identified, including a brief description of the potential obligation and the status of assessment of the event when this Master Reporting Package Checklist is returned to the Comptroller General's Office."]
[{"$f":"IF(B475=\"y\",COUNTA(B$27:B475),\"\")","v":""}]
[{"$f":"IF(B476=\"y\",COUNTA(B$27:B476),\"\")","v":""},null,"d. Has your agency been named, or does evidence indicate that your agency will be named, in a lawsuit to compel participation in remediation?",null,null,null,"No"]
[{"$f":"IF(B477=\"y\",COUNTA(B$27:B477),\"\")","v":""}]
[null,null,"Action:  Please create and attach a list of the events identified, including a brief description of the potential obligation and the status of assessment of the event when this Master Reporting Package Checklist is returned to the Comptroller General's Office."]
[{"$f":"IF(B479=\"y\",COUNTA(B$27:B479),\"\")","v":""}]
[{"$f":"IF(B480=\"y\",COUNTA(B$27:B480),\"\")","v":""},null,"e. Has your agency commenced, or legally obligated itself to commence, cleanup activities, monitoring, or maintenance and operation of the remediation effort?",null,null,null,"No"]
[{"$f":"IF(B481=\"y\",COUNTA(B$27:B481),\"\")","v":""}]
[{"$f":"IF(B482=\"y\",COUNTA(B$27:B482),\"\")","v":""},null,"Action:  Please create and attach a list of the events identified, including a brief description of the potential obligation and the status of assessment of the event when this Master Reporting Package Checklist is returned to the Comptroller General's Office."]
[{"$f":"IF(B483=\"y\",COUNTA(B$27:B483),\"\")","v":""}]
[{"$f":"IF(B484=\"y\",COUNTA(B$27:B484),\"\")","v":""}]
[{"$f":"IF(B485=\"y\",COUNTA(B$27:B485),\"\")","v":""}]
[{"$f":"IF(B486=\"y\",COUNTA(B$27:B486),\"\")","v":""}]
[]
[{"$f":"IF(B488=\"y\",COUNTA(B$27:B488),\"\")","v":""}]
[{"$f":"IF(B489=\"y\",COUNTA(B$27:B489),\"\")","v":""}]
[{"$f":"IF(B490=\"y\",COUNTA(B$27:B490),\"\")","v":""}]
[{"$f":"IF(B491=\"y\",COUNTA(B$27:B491),\"\")","v":""}]
[{"$f":"IF(B492=\"y\",COUNTA(B$27:B492),\"\")","v":""}]
[{"$f":"IF(B493=\"y\",COUNTA(B$27:B493),\"\")","v":""}]
[{"$f":"IF(B494=\"y\",COUNTA(B$27:B494),\"\")","v":""}]
[{"$f":"IF(B495=\"y\",COUNTA(B$27:B495),\"\")","v":""}]

{"sheet":"Required Packages","index":4,"n_rows":112,"n_cols":5,"rows_kept":112,"cut":false,"hidden":false,"merged":[[6,0,6,4],[0,0,0,4],[4,0,4,4],[3,0,3,4],[1,0,1,4],[2,0,2,4]]}
["STATE OF SOUTH CAROLINA"]
["YEAR-END REPORTING PACKAGE "]
["MASTER REPORTING PACKAGE CHECKLIST"]
["SUMMARY OF REQUIRED PACKAGES AND ADDITIONAL DOCUMENTATION"]
[{"$f":"\"For the Fiscal Year Ended June 30, \"&Year","v":"For the Fiscal Year Ended June 30, 2021"}]
[]
[{"$f":"\"For\"&\" \"&AgencyCode&\", \"&AgencyName","v":"For E120, COMPTROLLER GENERAL'S OFFICE\n"}]
[]
["Reporting Packages",null,null,"Submission Date"]
[]
["2.01 Subsequent Events Reporting Package",null,null,{"$f":"\"Due\"&\" \"&(Resources!D3)","v":"Due October 22"},{"$f":"\"Note: Package is not to be submitted before\"&\" \"&TEXT(Resources!E3,\"m/d/yyyy\")","v":"Note: Package is not to be submitted before 10/8/2021"}]
["3.01 Cash and Investments Reporting Package",null,null,{"$f":"IF(OR(E13=\"Yes\",E14=\"Yes\",E15=\"Yes\")=FALSE,\"Not Required\",\"Due\"&\" \"&Resources!D4)","v":"Due July 23"}]
[null,"3.01.1","Petty Cash",null,{"$f":"IF(COUNTIF('2.0.1'!G51:G55,\"Yes\")>0,\"Yes\",IF('2.0.1'!G55=\"No\",\"No\",IF('2.0.1'!G55=\"\",\"\",\"ERROR\")))","v":"Yes"}]
[null,"3.01.2","Agency Cash",null,{"$f":"IF('2.0.1'!G59=\"Yes\",\"Yes\",IF('2.0.1'!G59=\"No\",\"No\",IF('2.0.1'!G59=\"\",\"\",\"ERROR\")))","v":"Yes"}]
[null,"3.01.3","Investments",null,{"$f":"IF('2.0.1'!G63=\"Yes\",\"Yes\",IF('2.0.1'!G63=\"No\",\"No\",IF('2.0.1'!G63=\"\",\"\",\"ERROR\")))","v":"Yes"}]
["3.02 Tax Revenue Reporting Package",null,null,{"$f":"IF(OR(E17=\"Yes\",E18=\"Yes\",E19=\"Yes\")=FALSE,\"Not Required\",\"Due\"&\" \"&Resources!D5)","v":"Due August 13"}]
[null,"3.02.1","Tax Receivable",null,{"$f":"IF('2.0.1'!G69=\"Yes\",\"Yes\",IF('2.0.1'!G69=\"No\",\"No\",IF('2.0.1'!G69=\"\",\"\",\"ERROR\")))","v":"Yes"}]
[null,"3.02.2","Tax Refund Payable",null,{"$f":"IF('2.0.1'!G69=\"Yes\",\"Yes\",IF('2.0.1'!G69=\"No\",\"No\",IF('2.0.1'!G69=\"\",\"\",\"ERROR\")))","v":"Yes"}]
[null,"3.02.3","Deferred Tax Revenues",null,{"$f":"IF('2.0.1'!G69=\"Yes\",\"Yes\",IF('2.0.1'!G69=\"No\",\"No\",IF('2.0.1'!G69=\"\",\"\",\"ERROR\")))","v":"Yes"}]
["3.03 Grants and Contribution Revenue Reporting Package",null,null,{"$f":"IF(OR(E21=\"Yes\",E22=\"Yes\",E23=\"Yes\")=FALSE,\"Not Required\",\"Due\"&\" \"&Resources!D6)","v":"Due September 10"}]
[null,"3.03.1","Grants Activity Form",null,{"$f":"IF('2.0.1'!G79=\"Yes\",\"Yes\",IF('2.0.1'!G79=\"No\",\"No\",IF('2.0.1'!G79=\"\",\"\",\"ERROR\")))","v":"No"}]
[null,"3.03.2","Grants Receivable and Deferred Revenue Summary Form",null,{"$f":"IF('2.0.1'!G84=\"Yes\",\"Yes\",IF('2.0.1'!G84=\"No\",\"No\",IF('2.0.1'!G84=\"\",\"\",\"ERROR\")))","v":"Yes"}]
[null,"3.03.3","Contributions Receivable and Deferred Revenue Summary Form",null,{"$f":"IF('2.0.1'!G89=\"Yes\",\"Yes\",IF('2.0.1'!G89=\"No\",\"No\",IF('2.0.1'!G89=\"\",\"\",\"ERROR\")))","v":"Yes"}]
["3.04 Other Receivables Reporting Package",null,null,{"$f":"IF(E25=\"Yes\"=FALSE,\"Not Required\",\"Due\"&\" \"&Resources!D7)","v":"Due August 13"}]
[null,"3.04.1","Receivables Summary Form",null,{"$f":"IF(OR('2.0.1'!G95=\"Yes\",'2.0.1'!G100=\"Yes\",'2.0.1'!G105=\"Yes\")=TRUE,\"Yes\",IF(AND('2.0.1'!G95=\"No\",'2.0.1'!G100=\"No\",'2.0.1'!G105=\"No\")=TRUE,\"No\",IF(AND('2.0.1'!G95=\"\",'2.0.1'!G100=\"\",'2.0.1'!G105=\"\")=TRUE,\"\",\"ERROR\")))","v":"Yes"}]
["3.05 Unearned Revenue  Reporting Package",null,null,{"$f":"IF(E27=\"Yes\"=FALSE,\"Not Required\",\"Due\"&\" \"&Resources!D8)","v":"Due August 20"}]
[null,"3.05.1","Unearned Revenue Summary Form",null,{"$f":"IF('2.0.1'!G111=\"Yes\",\"Yes\",IF('2.0.1'!G111=\"No\",\"No\",IF('2.0.1'!G111=\"\",\"\",\"ERROR\")))","v":"Yes"}]
["3.06 Inventory Reporting Package",null,null,{"$f":"IF(OR(E29=\"Yes\")=FALSE,\"Not Required\",\"Due\"&\" \"&Resources!D9)","v":"Due August 13"}]
[null,"3.06.1","Inventory Summary Form",null,{"$f":"IF(OR('2.0.1'!G122=\"Yes\",'2.0.1'!G127=\"Yes\"),\"Yes\",IF(OR('2.0.1'!G122=\"No\",'2.0.1'!G127=\"No\"),\"No\",IF('2.0.1'!G122=\"\",\"\",\"ERROR\")))","v":"Yes"}]
["3.07 Prepaid Expenses Reporting Package",null,null,{"$f":"IF(OR(E31=\"Yes\")=FALSE,\"Not Required\",\"Due\"&\" \"&Resources!D10)","v":"Due August 20"}]
[null,"3.07.1","Prepaid Expenses Summary Form",null,{"$f":"IF('2.0.1'!G133=\"Yes\",\"Yes\",IF('2.0.1'!G133=\"No\",\"No\",IF('2.0.1'!G133=\"\",\"\",\"ERROR\")))","v":"Yes"}]
["3.08 Capital Assets Reporting Package",null,null,{"$f":"IF(OR(E33=\"Yes\")=FALSE,\"Not Required\",\"Due\"&\" \"&Resources!D11)","v":"Due September 10"}]
[null,"3.08.1","Capital Asset Questionnaire",null,{"$f":"IF(OR('2.0.1'!G139=\"Yes\",'2.0.1'!G144=\"Yes\")=TRUE,\"Yes\",IF(AND('2.0.1'!G139=\"No\",'2.0.1'!G144=\"No\")=TRUE,\"No\",IF(AND('2.0.1'!G139=\"\",'2.0.1'!G144=\"\")=TRUE,\"\",\"ERROR\")))","v":"Yes"}]
[null,"3.08.2","Reporting of Adjustments and Errors Identified in SCEIS Asset History",null,{"$f":"IF(E33=\"Yes\",\"Based on 3.08.1\",IF(E33=\"No\",\"No\",IF(E33=\"\",\"\",\"ERROR\")))","v":"Based on 3.08.1"}]
[null,"3.08.3","Non-SCEIS Agencies Only - Capital Asset Summary Form",null,{"$f":"IF(E33=\"Yes\",\"Based on 3.08.1\",IF(E33=\"No\",\"No\",IF(E33=\"\",\"\",\"ERROR\")))","v":"Based on 3.08.1"}]
[null,"3.08.4","Capital Asset Intra-State Transfers Summary Form",null,{"$f":"IF(E33=\"Yes\",\"Based on 3.08.1\",IF(E33=\"No\",\"No\",IF(E33=\"\",\"\",\"ERROR\")))","v":"Based on 3.08.1"}]
[null,"3.08.5","Asset History Reconciliation To GL Activity",null,{"$f":"IF(E33=\"Yes\",\"Based on 3.08.1\",IF(E33=\"No\",\"No\",IF(E33=\"\",\"\",\"ERROR\")))","v":"Based on 3.08.1"}]
["3.09 Operating Lease Reporting Package",null,null,{"$f":"IF(OR(E39=\"Yes\")=FALSE,\"Not Required\",\"Due\"&\" \"&Resources!D12)","v":"Due August 20"}]
[null,"3.09.1","Operating Lease Summary Form - Lease",null,{"$f":"IF(OR('2.0.1'!G160=\"Yes\",'2.0.1'!G165=\"Yes\",'2.0.1'!G170=\"Yes\"),\"Yes\",IF(AND('2.0.1'!G160=\"No\",'2.0.1'!G165=\"No\",'2.0.1'!G170=\"No\"),\"No\",IF(AND('2.0.1'!G160=\"\",'2.0.1'!G165=\"\",'2.0.1'!G170=\"\"),\"\",\"ERROR\")))","v":"Yes"}]
[null,"3.09.1.a","Operating Lease Future Minimum Payment Schedule",null,{"$f":"IF(E39=\"Yes\",\"Based on 3.09.1\",IF(E39=\"No\",\"No\",IF(E39=\"\",\"\",\"ERROR\")))","v":"Based on 3.09.1"}]
[null,"3.09.2","Operating Lease Summary Form - Leasor",null,{"$f":"IF(E39=\"Yes\",\"Based on 3.09.1\",IF(E39=\"No\",\"No\",IF(E39=\"\",\"\",\"ERROR\")))","v":"Based on 3.09.1"}]
["3.10 Loans Receivable Reporting Package",null,null,{"$f":"IF(OR(E43=\"Yes\")=FALSE,\"Not Required\",\"Due\"&\" \"&Resources!D13)","v":"Due July 23"}]
[null,"3.10.1","Loans Receivable Summary Form",null,{"$f":"IF('2.0.1'!G196=\"Yes\",\"Yes\",IF('2.0.1'!G196=\"No\",\"No\",IF('2.0.1'!G196=\"\",\"\",\"ERROR\")))","v":"Yes"}]
["3.11 Not Currently In Use"]
["3.12 Accounts Payable Reporting Package",null,null,{"$f":"IF(OR(E46=\"Yes\")=FALSE,\"Not Required\",\"Due\"&\" \"&Resources!D14)","v":"Due September 10"}]
[null,"3.12.1","Accounts Payable Summary Form",null,{"$f":"IF(OR('2.0.1'!G202=\"Yes\",'2.0.1'!G210=\"Yes\")=TRUE,\"Yes\",IF(AND('2.0.1'!G202=\"No\",'2.0.1'!G210=\"No\")=TRUE,\"No\",IF(AND('2.0.1'!G202=\"\",'2.0.1'!G210=\"\")=TRUE,\"\",\"ERROR\")))","v":"Yes"}]
["3.13 Litigation Reporting Package",null,null,{"$f":"IF(OR(E48=\"Yes\",E49=\"Yes\")=FALSE,\"Not Required\",\"Due\"&\" \"&Resources!D16)","v":"Due July 23"}]
[null,"3.13.1","Litigation Related Expense Explanation Form",null,{"$f":"IF('2.0.1'!G217=\"Yes\",\"Yes\",IF('2.0.1'!G217=\"No\",\"No\",IF('2.0.1'!G217=\"\",\"\",\"ERROR\")))","v":"Yes"}]
[null,"3.13.2","Litigation Overview Form",null,{"$f":"IF('2.0.1'!G217=\"Yes\",\"Yes\",IF('2.0.1'!G217=\"No\",\"No\",IF('2.0.1'!G217=\"\",\"\",\"ERROR\")))","v":"Yes"}]
[null,"3.13.3","Settled Litigation Report Form",null,{"$f":"IF(E49=\"Yes\",\"Based on 3.13.1\",IF(E49=\"No\",\"No\",IF(E49=\"\",\"\",\"ERROR\")))","v":"Based on 3.13.1"}]
[null,"3.13.4","Litigation Contingency Report Form",null,{"$f":"IF(E49=\"Yes\",\"Based on 3.13.1\",IF(E49=\"No\",\"No\",IF(E49=\"\",\"\",\"ERROR\")))","v":"Based on 3.13.1"}]
["3.14 Disallowances and Penalties Reporting Package",null,null,{"$f":"IF(OR(E53=\"Yes\")=FALSE,\"Not Required\",\"Due\"&\" \"&Resources!D17)","v":"Due July 23"}]
[null,"3.14.1","Disallowances and Penalties Reporting Form",null,{"$f":"IF(OR('2.0.1'!G223=\"Yes\",'2.0.1'!G228=\"Yes\"),\"Yes\",IF(OR('2.0.1'!G223=\"No\",'2.0.1'!G228=\"No\"),\"No\",IF('2.0.1'!G223=\"\",\"\",\"ERROR\")))","v":"Yes"}]
["3.15 Claims Reporting Package",null,null,{"$f":"IF(OR(E55=\"Yes\",E56=\"Yes\")=FALSE,\"Not Required\",\"Due\"&\" \"&Resources!D18)","v":"Due August 6"}]
[null,"3.15.1","Claims Summary Form",null,{"$f":"IF('2.0.1'!G264=\"Yes\",\"Yes\",IF('2.0.1'!G264=\"No\",\"No\",IF('2.0.1'!G264=\"\",\"\",\"ERROR\")))","v":"Yes"}]
[null,"3.15.2","Additional Claims Information Form",null,{"$f":"IF('2.0.1'!G264=\"Yes\",\"Yes\",IF('2.0.1'!G264=\"No\",\"No\",IF('2.0.1'!G264=\"\",\"\",\"ERROR\")))","v":"Yes"}]
["3.16 Miscellaneous Loss Liabilities, Loss Contingencies, and Commitments Reporting Package",null,null,{"$f":"IF(OR(E58=\"Yes\",E59=\"Yes\",E60=\"Yes\")=FALSE,\"Not Required\",\"Due\"&\" \"&Resources!D19)","v":"Due August 13"}]
[null,"3.16.1","Miscellaneous Loss Liabilities Report Form",null,{"$f":"IF(OR('2.0.1'!G273=\"Yes\",'2.0.1'!G285=\"Yes\"),\"Yes\",IF(OR('2.0.1'!G273=\"No\",'2.0.1'!G285=\"No\"),\"No\",IF('2.0.1'!G273=\"\",\"\",\"ERROR\")))","v":"Yes"}]
[null,"3.16.2","Miscellaneous Loss Contingency Report Form",null,{"$f":"IF(OR('2.0.1'!G273=\"Yes\",'2.0.1'!G285=\"Yes\"),\"Yes\",IF(OR('2.0.1'!G273=\"No\",'2.0.1'!G285=\"No\"),\"No\",IF('2.0.1'!G273=\"\",\"\",\"ERROR\")))","v":"Yes"}]
[null,"3.16.3","Significant Miscellaneous Commitments Form",null,{"$f":"IF(OR('2.0.1'!G273=\"Yes\",'2.0.1'!G285=\"Yes\"),\"Yes\",IF(OR('2.0.1'!G273=\"No\",'2.0.1'!G285=\"No\"),\"No\",IF('2.0.1'!G273=\"\",\"\",\"ERROR\")))","v":"Yes"}]
["3.17 Not Currently In Use"]
["3.18 Interfund Payables and Receivables Reporting Package",null,null,{"$f":"IF(OR(E63=\"Yes\",E64=\"Yes\")=FALSE,\"Not Required\",\"Due\"&\" \"&Resources!D20)","v":"Due August 20"}]
[null,"3.18.1","Interfund Payable Summary Form",null,{"$f":"IF('2.0.1'!G292=\"Yes\",\"Yes\",IF('2.0.1'!G292=\"No\",\"No\",IF('2.0.1'!G292=\"\",\"\",\"ERROR\")))","v":"Yes"}]
[null,"3.18.2","Interfund Receivables Summary Form",null,{"$f":"IF('2.0.1'!G298=\"Yes\",\"Yes\",IF('2.0.1'!G298=\"No\",\"No\",IF('2.0.1'!G298=\"\",\"\",\"ERROR\")))","v":"Yes"}]
["3.19 Not Currently In Use"]
["3.20 Fund Classification Reporting Package",null,null,{"$f":"\"Due\"&\" \"&Resources!D21","v":"Due August 20"},{"$f":"\"Note: Package is not to be submitted before\"&\" \"&Resources!E21","v":"Note: Package is not to be submitted before August 12"}]
[null,"3.20.1","Fund Balance And Net Asset Summary Form"]
[null,"3.20.2","Fund Use And Reporting Fund Types Form"]
[]
["Additional Required Submissions"]
["Question"]
[{"$f":"'2.0.1'!A73","v":9},null,"Provide a schedule of the amounts paid as related to each tax source, detailed by accounting fund, general ledger (or object code), gross of related processing costs, with amounts paid to outside collection agencies as processing costs.  Submit the detailed schedule with the Tax Revenue Reporting Package.",{"$f":"IF('2.0.1'!G73=\"Yes\",\"Required with the Tax Revenue Reporting Package\",\"Not Required\")","v":"Not Required"}]
[]
[{"$f":"'2.0.1'!A79","v":10},null,"A schedule of the total amount, by fund, passed through to non-State entities (as a cash conduit) is to be returned to the Comptroller General's Office with the Grants and Contributions Reporting Package.  ",{"$f":"IF('2.0.1'!G79=\"Yes\",\"Required with the Grants Reporting Package\",\"Not Required\")","v":"Not Required"}]
[]
[{"$f":"'2.0.1'!A116","v":17},null,"Provide a description of the transaction (include the counter party of the transaction and any responsibilities for servicing retained by the agency) in an attachment to this Reporting Package Checklist to the Comptroller General's Office.",{"$f":"IF('2.0.1'!G116=\"Yes\",\"Required with the Master Reporting Package Checklist\",\"Not Required\")","v":"Not Required"}]
[]
[{"$f":"'2.0.1'!A176&\".a.i\"","v":"27.a.i"},null,{"$f":"IF('2.0.1'!G182=\"\",\"\",IF('2.0.1'!G182=\"No\",\"Action:  Provide the following information for the assets acquired under capital leases (even if not acquired in the current year).  Please provide the following information vendor, in-service date, value of asset, asset classification and life of asset.\"))","v":false},{"$f":"IF('2.0.1'!G182=\"No\",\"Required with the Master Reporting Package Checklist\",\"Not Required\")","v":"Not Required"}]
[]
[{"$f":"'2.0.1'!A329","v":45},null,"Describe the situation in a letter or other attachment when you return this Reporting Package Control Checklist to the Comptroller General's Office.  Please provide copies of signed agreements for any new loans.",{"$f":"IF('2.0.1'!G329=\"Yes\",\"Required with the Master Reporting Package Checklist\",\"Not Required\")","v":"Required with the Master Reporting Package Checklist"}]
[]
[{"$f":"'2.0.1'!A334","v":46},null,"Describe the situation in a letter or other attachment when you return this Reporting Package Control Checklist to the Comptroller General's Office.  Please provide details of your understanding with the other agency.",{"$f":"IF('2.0.1'!G334=\"Yes\",\"Required with the Master Reporting Package Checklist\",\"Not Required\")","v":"Required with the Master Reporting Package Checklist"}]
[]
[{"$f":"'2.0.1'!A339","v":47},null,"Describe the situation in a letter or other attachment when you return this Reporting Package Control Checklist to the Comptroller General's Office. Please provide details of the plans for return of resources (repayment) between the funds within your agency.",{"$f":"IF('2.0.1'!G339=\"Yes\",\"Required with the Master Reporting Package Checklist\",\"Not Required\")","v":"Required with the Master Reporting Package Checklist"}]
[]
[{"$f":"'2.0.1'!A372","v":49},null,"Provide a listing including Lease ID #(s), amount(s), and payment date(s) as an attachment when you return this Reporting Package Checklist to the Comptroller General's Office.",{"$f":"IF('2.0.1'!G372=\"Yes\",\"Required with the Master Reporting Package Checklist\",\"Not Required\")","v":"Required with the Master Reporting Package Checklist"}]
[]
[{"$f":"'2.0.1'!A400","v":51},null,"Provide a listing including Name of Lendor, identification of asset purchased, whether collateral secures the note, current year activity (including beginning balance, advances, repayments, and ending balance), and future payments (amount(s) and payment date(s)) as an attachment when you return this Reporting Package Checklist to the Comptroller General's Office.",{"$f":"IF('2.0.1'!G400=\"Yes\",\"Required with the Master Reporting Package Checklist\",\"Not Required\")","v":"Not Required"}]
[]
[{"$f":"'2.0.1'!A408","v":52},null,"Describe the situation in a letter or other attachment to this Reporting Package Checklist to the Comptroller General's Office.  Include authorization, Lendor, Amount of Note, Date of Note, Collateral, Terms of repayment, and Balance as of year-end.",{"$f":"IF('2.0.1'!G421=\"Yes\",\"Required with the Master Reporting Package Checklist\",\"Not Required\")","v":"Not Required"}]
[]
[{"$f":"'2.0.1'!A426","v":53},null,"Describe the situation in a letter or other attachment when you return this Reporting Package Checklist to the Comptroller General's Office.  Be sure to fully describe the activity and whether you self-insure the activity, purchase insurance to cover the activity, or provide insurance coverage to other entities for this activity.  Also, please include the name and phone number of a person within your agency that we may contact to obtain additional information,  if necessary.",{"$f":"IF('2.0.1'!G426=\"Yes\",\"Required with the Master Reporting Package Checklist\",\"Not Required\")","v":"Not Required"}]
[]
[{"$f":"'2.0.1'!A431","v":54},null,"Describe the situation in a letter or other attachment (include specifics of the service agreement, the volume of transactions processed, the dollar amount of transactions processed, and procedures performed by the agency to ensure appropriate controls are in place for accuracy in recognition and reporting) when you return this Reporting Package Checklist to the Comptroller General's Office.",{"$f":"IF('2.0.1'!G431=\"Yes\",\"Required with the Master Reporting Package Checklist\",\"Not Required\")","v":"Not Required"}]
[]
[{"$f":"'2.0.1'!A436","v":55},null,"Describe the situation on agency letterhead signed by the Agency Director or designee when this Reporting Package Checklist is returned to the Comptroller General's Office.  Be sure to fully describe the activity, the amount (or approximate amount) of the fraud or suspected fraud, and the resulting actions by management to prevent further fraudulent activities.",{"$f":"IF('2.0.1'!G436=\"Yes\",\"Required with the Master Reporting Package Checklist\",\"Not Required\")","v":"Required with the Master Reporting Package Checklist"}]
[]
[{"$f":"'2.0.1'!A441","v":56},null,"Describe the situation on agency letterhead signed by the Agency Director or designee when this Reporting Package Checklist is returned to the Comptroller General's Office.  Be sure to fully describe the allegation(s) and any actions taken by management to strengthen the internal controls that may have been breached if the allegations prove true.",{"$f":"IF('2.0.1'!G441=\"Yes\",\"Required with the Master Reporting Package Checklist\",\"Not Required\")","v":"Not Required"}]
[]
[{"$f":"'2.0.1'!A446","v":57},null,"Provide copies of the communications and a summary of the corrective actions when this Reporting Package Checklist is returned to the Comptroller General's Office.  ",{"$f":"IF('2.0.1'!G446=\"Yes\",\"Required with the Master Reporting Package Checklist\",\"Not Required\")","v":"Not Required"}]
[]
[{"$f":"'2.0.1'!A451","v":58},null,"Provide an explanation of the violation or instance of noncompliance as an attachment to this Reporting Package Checklist to the Comptroller General's Office.",{"$f":"IF('2.0.1'!G451=\"Yes\",\"Required with the Master Reporting Package Checklist\",\"Not Required\")","v":"Not Required"}]
[]
[{"$f":"'2.0.1'!A462&\".a\"","v":"59.a"},null,"Please create and attach a list of the events identified, including a brief description of the potential obligation and the status of assessment of the event when this Reporting Package Checklist is returned to the Comptroller General's Office.",{"$f":"IF('2.0.1'!G464=\"Yes\",\"Required with the Master Reporting Package Checklist\",\"Not Required\")","v":"Not Required"}]
[]
[{"$f":"'2.0.1'!A462&\".b\"","v":"59.b"},null,"Please create and attach a list of the events identified, including a brief description of the potential obligation and the status of assessment of the event when this Reporting Package Checklist is returned to the Comptroller General's Office.",{"$f":"IF('2.0.1'!G468=\"Yes\",\"Required with the Master Reporting Package Checklist\",\"Not Required\")","v":"Not Required"}]
[]
[{"$f":"'2.0.1'!A462&\".c\"","v":"59.c"},null,"Please create and attach a list of the events identified, including a brief description of the potential obligation and the status of assessment of the event when this Reporting Package Checklist is returned to the Comptroller General's Office.",{"$f":"IF('2.0.1'!G472=\"Yes\",\"Required with the Master Reporting Package Checklist\",\"Not Required\")","v":"Not Required"}]
[]
[{"$f":"'2.0.1'!A462&\".d\"","v":"59.d"},null,"Please create and attach a list of the events identified, including a brief description of the potential obligation and the status of assessment of the event when this Reporting Package Checklist is returned to the Comptroller General's Office.",{"$f":"IF('2.0.1'!G476=\"Yes\",\"Required with the Master Reporting Package Checklist\",\"Not Required\")","v":"Not Required"}]
[]
[{"$f":"'2.0.1'!A462&\".e\"","v":"59.e"},null,"Please create and attach a list of the events identified, including a brief description of the potential obligation and the status of assessment of the event when this Reporting Package Checklist is returned to the Comptroller General's Office.",{"$f":"IF('2.0.1'!G480=\"Yes\",\"Required with the Master Reporting Package Checklist\",\"Not Required\")","v":"Not Required"}]

{"sheet":"Resources","index":5,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,2,0,3],[13,0,14,0],[13,1,14,1],[13,2,14,2],[13,7,14,7],[13,3,14,3]]}
["Package","Package Name","Package Due Day & Date",null,"Not Before","SCEIS Report Distribution Date","SCEIS Report Name ","CG's Office Contact","Phone Number"]
[2,"Master Reporting Package Checklist",{"$f":"TEXT(D2,\"dddd\")","v":"Friday"},"July 9",null,null,null,"Kelly Ghent","803-734-0272"]
[2.1,"Subsequent Event ","Friday","October 22","October 8",null,null,"Michael Moore","803-734-0584"]
[3.01,"Cash and Investments","Friday","July 23",null,"July 9","Yearend Rptg - Cash & Investments","Katherine Kip","803-734-5043"]
[3.02,"Tax Revenue","Friday","August 13",null,null,null,"Michael Moore","803-734-0584"]
[3.03,"Grant and Contributions Revenue","Friday","September 10",null,"September 1","Yearend Rptg - AR (Contributions)\nYearend Rptg - Schedule of Expenditures of Fed Awards (SEFA)","Michael Moore","803-734-0584"]
[3.04,"Other Receivables","Friday","August 13",null,"July 30","Yearend Rptg – Accounts Receivable Current with Customer","Kelly Ghent","803-734-0272"]
[3.05,"Unearned Revenue","Friday","August 20",null,null,null,"Michael Moore","803-734-0272"]
[3.06,"Inventory","Friday","August 13",null,"July 30","Yearend Rptg - AR (Contributions)","Kelly Ghent","803-734-0272"]
[3.07,"Prepaid Expenses","Friday","August 20",null,"August 6","Yearend Rptg - Prepaid Expenses","Kelly Ghent","803-734-0272"]
[3.08,"Capital Assets","Friday","September 10",null,"August 30","Yearend Rptg - Asset History Sheet","Kelly Ghent","803-734-0272"]
[3.09,"Operating Leases","Friday","August 20",null,"August 6","Yearend Rptg - Operating Lease Expense w/Vendor","Kelly Ghent","803-734-0272"]
[3.1,"Loans Receivable","Friday","July 23",null,null,null,"Katherine Kip","803-734-5043"]
[3.12,"Accounts Payable",{"$f":"TEXT(D14,\"dddd\")","v":"Friday"},"September 10",null,"September 1","Yearend Rptg - Prior Year Payables with Vendor","Kelly Ghent","803-734-0272"]
[null,null,null,null,null,"September 8","Yearend Rptg - Prior Year Payables with Vendor",null,"803-734-0272"]
[3.13,"Litigation","Friday","July 23",null,"July 9","Yearend Rpt - Litigation Expense","Michael Moore","803-734-0584"]
[3.14,"Disallowances and Penalties","Friday","July 23",null,null,null,"Kelly Ghent","803-734-0272"]
[3.15,"Claims","Friday","August 6",null,null,null,"David Starkey","803-734-2542"]
[3.16,"Misc Loss Liabilities","Friday","August 13",null,null,null,"Katherine Kip","803-734-5043"]
[3.18,"Interfund Payable","Friday","August 20",null,"July 30","Yearend Rptg - Inter-Agency Prior Year Payables with Vendor","David Starkey","803-734-2542"]
[3.2,"Fund Classification","Friday","August 20","August 12","August 12","Year-End Reporting - Fund Balance","Katherine Kip","803-734-5043"]

{"sheet":"Summary","index":6,"n_rows":460,"n_cols":7,"rows_kept":460,"cut":false,"hidden":true,"merged":[]}
["Worksheet","Agnecy Code","Agency Name","Year","QUESTION #","QUESTION","Answers"]
["2.0.1",{"$f":"AgencyCode","v":"E120"},{"$f":"AgencyName","v":"COMPTROLLER GENERAL'S OFFICE\n"},{"$f":"Year","v":2021},{"$f":"'2.0.1'!A32","v":2},{"$f":"'2.0.1'!C32","v":"Each agency is responsible for designing and implementing processes, procedures, and controls to record and provide accurate and timely accounting information and to prevent and detect fraud.  As part of Best Practices for Internal Control, a review of the agency's general ledger either in detail or at a trial balance level should be performed at the beginning of the yearly closing procedures."},{"$f":"IF('2.0.1'!G32=\"\",\"\",'2.0.1'!G32)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A34=\"\",E2,'2.0.1'!A34)","v":2},{"$f":"IF('2.0.1'!C34=\"\",\"\",'2.0.1'!C34)","v":"a.  Has a review of general ledger balances been performed at an agency wide level? "},{"$f":"IF('2.0.1'!G34=\"\",\"\",'2.0.1'!G34)","v":"Yes"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A36=\"\",E3,'2.0.1'!A36)","v":2},{"$f":"IF('2.0.1'!C36=\"\",\"\",'2.0.1'!C36)","v":"b.  Were any errors identified in the review performed for the beginning of year-end close for the current year ended June 30?"},{"$f":"IF('2.0.1'!G36=\"\",\"\",'2.0.1'!G36)","v":"No"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A38=\"\",E4,'2.0.1'!A38)","v":2},{"$f":"IF('2.0.1'!C38=\"\",\"\",'2.0.1'!C38)","v":"Action:  Perform sufficient analysis and evaluation to identify and correct the errors prior to submission of related reporting package forms and the close of access to the general ledger.  "},{"$f":"IF('2.0.1'!G38=\"\",\"\",'2.0.1'!G38)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A41=\"\",E5,'2.0.1'!A41)","v":3},{"$f":"IF('2.0.1'!C41=\"\",\"\",'2.0.1'!C41)","v":"As part of Best Practices for Internal Control, a review of the general ledger by detailed fund should be performed at the beginning and ending of the yearly closing procedures."},{"$f":"IF('2.0.1'!G41=\"\",\"\",'2.0.1'!G41)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A43=\"\",E6,'2.0.1'!A43)","v":3},{"$f":"IF('2.0.1'!C43=\"\",\"\",'2.0.1'!C43)","v":"a.  Has a review of general ledger balances been performed at the accounting (detailed) fund level? "},{"$f":"IF('2.0.1'!G43=\"\",\"\",'2.0.1'!G43)","v":"Yes"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A45=\"\",E7,'2.0.1'!A45)","v":3},{"$f":"IF('2.0.1'!C45=\"\",\"\",'2.0.1'!C45)","v":"b.  Were any errors identified in the review by fund for the beginning of year-end close for the current year ended June 30?"},{"$f":"IF('2.0.1'!G45=\"\",\"\",'2.0.1'!G45)","v":"No"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A47=\"\",E8,'2.0.1'!A47)","v":3},{"$f":"IF('2.0.1'!C47=\"\",\"\",'2.0.1'!C47)","v":"Action:  Perform sufficient analysis and evaluation to identify and correct the errors prior to submission of related reporting package forms and the close of access to the general ledger.  "},{"$f":"IF('2.0.1'!G47=\"\",\"\",'2.0.1'!G47)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A55=\"\",E9,'2.0.1'!A55)","v":5},{"$f":"IF('2.0.1'!C55=\"\",\"\",'2.0.1'!C55)","v":"Does your agency have G/L account 1000050000 Petty Cash present on your Trial Balance (regardless of balance)?"},{"$f":"IF('2.0.1'!G55=\"\",\"\",'2.0.1'!G55)","v":"Yes"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A57=\"\",E10,'2.0.1'!A57)","v":5},{"$f":"IF('2.0.1'!C57=\"\",\"\",'2.0.1'!C57)","v":"Action:  A Cash and Investments Reporting Package is required.  (See Section 3.01)"},{"$f":"IF('2.0.1'!G57=\"\",\"\",'2.0.1'!G57)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A59=\"\",E11,'2.0.1'!A59)","v":6},{"$f":"IF('2.0.1'!C59=\"\",\"\",'2.0.1'!C59)","v":"Does your agency have cash held in a bank account (including composite reservoir accounts) for which it receives periodic statements directly from the bank (cash on deposit with banks)?"},{"$f":"IF('2.0.1'!G59=\"\",\"\",'2.0.1'!G59)","v":"Yes"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A61=\"\",E12,'2.0.1'!A61)","v":6},{"$f":"IF('2.0.1'!C61=\"\",\"\",'2.0.1'!C61)","v":"Action:  A Cash and Investments Reporting Package is required.  (See Section 3.01)"},{"$f":"IF('2.0.1'!G61=\"\",\"\",'2.0.1'!G61)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A63=\"\",E13,'2.0.1'!A63)","v":7},{"$f":"IF('2.0.1'!C63=\"\",\"\",'2.0.1'!C63)","v":"Does your agency have ownership in investments that are not managed or accounted for by the State Treasurer's Office? "},{"$f":"IF('2.0.1'!G63=\"\",\"\",'2.0.1'!G63)","v":"Yes"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A65=\"\",E14,'2.0.1'!A65)","v":7},{"$f":"IF('2.0.1'!C65=\"\",\"\",'2.0.1'!C65)","v":"Action:  A Cash and Investments Reporting Package is required.  (See Section 3.01)"},{"$f":"IF('2.0.1'!G65=\"\",\"\",'2.0.1'!G65)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A69=\"\",E15,'2.0.1'!A69)","v":8},{"$f":"IF('2.0.1'!C69=\"\",\"\",'2.0.1'!C69)","v":"Did your agency collect and deposit any tax revenues during the fiscal year?  (If you collect sales taxes that are remitted to the South Carolina Department of Revenue for items sold in a gift shop, please answer no for this question.)"},{"$f":"IF('2.0.1'!G69=\"\",\"\",'2.0.1'!G69)","v":"Yes"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A71=\"\",E16,'2.0.1'!A71)","v":8},{"$f":"IF('2.0.1'!C71=\"\",\"\",'2.0.1'!C71)","v":"Action: A Tax Revenues Reporting Package is required.  (See Section 3.02)"},{"$f":"IF('2.0.1'!G71=\"\",\"\",'2.0.1'!G71)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A79=\"\",E17,'2.0.1'!A79)","v":10},{"$f":"IF('2.0.1'!C79=\"\",\"\",'2.0.1'!C79)","v":"Did your agency receive resources from the federal government or other private granting organizations under an agreement which constitutes the service as a cash conduit (see Reporting Manual for further guidance on what constitutes a cash conduit) during the year?"},{"$f":"IF('2.0.1'!G79=\"\",\"\",'2.0.1'!G79)","v":"No"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A81=\"\",E18,'2.0.1'!A81)","v":10},{"$f":"IF('2.0.1'!C81=\"\",\"\",'2.0.1'!C81)","v":"Action:  A schedule of the total amount, by fund, passed through to non-State entities (as a cash conduit) is to be returned to the Comptroller General's Office with the Grants and Contributions Reporting Package.  "},{"$f":"IF('2.0.1'!G81=\"\",\"\",'2.0.1'!G81)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A84=\"\",E19,'2.0.1'!A84)","v":11},{"$f":"IF('2.0.1'!C84=\"\",\"\",'2.0.1'!C84)","v":"Did your agency receive funding from federal or private granting organizations through grant awards or contracts during the year?"},{"$f":"IF('2.0.1'!G84=\"\",\"\",'2.0.1'!G84)","v":"Yes"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A86=\"\",E20,'2.0.1'!A86)","v":11},{"$f":"IF('2.0.1'!C86=\"\",\"\",'2.0.1'!C86)","v":"Action:  A Grants and Contribution Revenue Reporting Package is required.  (See Section 3.03)"},{"$f":"IF('2.0.1'!G86=\"\",\"\",'2.0.1'!G86)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A89=\"\",E21,'2.0.1'!A89)","v":12},{"$f":"IF('2.0.1'!C89=\"\",\"\",'2.0.1'!C89)","v":"Did your agency receive contributions or pledges (see Reporting Manual for definition and further guidance) during the fiscal year that were not received by June 30, but at June 30 were verifiable, measurable, and probable of collection?"},{"$f":"IF('2.0.1'!G89=\"\",\"\",'2.0.1'!G89)","v":"Yes"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A91=\"\",E22,'2.0.1'!A91)","v":12},{"$f":"IF('2.0.1'!C91=\"\",\"\",'2.0.1'!C91)","v":"Action:  A Grants and Contribution Revenue Reporting Package is required.  (See Section 3.03)"},{"$f":"IF('2.0.1'!G91=\"\",\"\",'2.0.1'!G91)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A196=\"\",E23,'2.0.1'!A196)","v":29},{"$f":"IF('2.0.1'!C196=\"\",\"\",'2.0.1'!C196)","v":"Did your agency have any outstanding loans or notes receivable from non-State parties at the beginning of the year (July 1, 2020) OR end of the year (June 30, 2021)?"},{"$f":"IF('2.0.1'!G196=\"\",\"\",'2.0.1'!G196)","v":"Yes"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A198=\"\",E24,'2.0.1'!A198)","v":29},{"$f":"IF('2.0.1'!C198=\"\",\"\",'2.0.1'!C198)","v":"Action:  A Loan Receivables Reporting Package is required.  (See Section 3.10)"},{"$f":"IF('2.0.1'!G198=\"\",\"\",'2.0.1'!G198)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A95=\"\",E25,'2.0.1'!A95)","v":13},{"$f":"IF('2.0.1'!C95=\"\",\"\",'2.0.1'!C95)","v":"Does your agency have any other amounts owed to it as of June 30 from non-State entities (not accounted for in the previous 5 questions)?"},{"$f":"IF('2.0.1'!G95=\"\",\"\",'2.0.1'!G95)","v":"Yes"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A97=\"\",E26,'2.0.1'!A97)","v":13},{"$f":"IF('2.0.1'!C97=\"\",\"\",'2.0.1'!C97)","v":"Action:  A Other Receivables Reporting Package is required.  (See Section 3.04)"},{"$f":"IF('2.0.1'!G97=\"\",\"\",'2.0.1'!G97)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A100=\"\",E27,'2.0.1'!A100)","v":14},{"$f":"IF('2.0.1'!C100=\"\",\"\",'2.0.1'!C100)","v":"Does your agency have any interfund receivables individually under $100,000 not already in SCEIS?  Do not report amounts in account 1300020000 (ACCTS RECEIV – IDT) on any package. Amounts in account 1300020000 will be reclassified by the CG’s office as part of the Interfund procedures."},{"$f":"IF('2.0.1'!G100=\"\",\"\",'2.0.1'!G100)","v":"Yes"}]
["2.0.1",{"$f":"AgencyCode","v":"E120"},{"$f":"AgencyName","v":"COMPTROLLER GENERAL'S OFFICE\n"},{"$f":"Year","v":2021},{"$f":"IF('2.0.1'!A102=\"\",E28,'2.0.1'!A102)","v":14},{"$f":"IF('2.0.1'!C102=\"\",\"\",'2.0.1'!C102)","v":"Action:  A Other Receivables Reporting Package is required.  (See Section 3.04)"},{"$f":"IF('2.0.1'!G102=\"\",\"\",'2.0.1'!G102)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A105=\"\",E29,'2.0.1'!A105)","v":15},{"$f":"IF('2.0.1'!C105=\"\",\"\",'2.0.1'!C105)","v":"Does your agency have a balance at year end in account 1300010000 (ACCOUNTS RECEIVABLE-CURRENT) and 1300030000 (ACCTS RECEIV CUR NR) in SCEIS?"},{"$f":"IF('2.0.1'!G105=\"\",\"\",'2.0.1'!G105)","v":"Yes"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A107=\"\",E30,'2.0.1'!A107)","v":15},{"$f":"IF('2.0.1'!C107=\"\",\"\",'2.0.1'!C107)","v":"Action:  A Other Receivables Reporting Package is required.  (See Section 3.04)"},{"$f":"IF('2.0.1'!G107=\"\",\"\",'2.0.1'!G107)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A111=\"\",E31,'2.0.1'!A111)","v":16},{"$f":"IF('2.0.1'!C111=\"\",\"\",'2.0.1'!C111)","v":"Has your agency collected any unearned revenue as of June 30 for charges for goods and/or services collected in advance of the earnings process? "},{"$f":"IF('2.0.1'!G111=\"\",\"\",'2.0.1'!G111)","v":"Yes"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A113=\"\",E32,'2.0.1'!A113)","v":16},{"$f":"IF('2.0.1'!C113=\"\",\"\",'2.0.1'!C113)","v":"Action:  A Unearned Revenue Reporting Package is required.  (See Section 3.05)"},{"$f":"IF('2.0.1'!G113=\"\",\"\",'2.0.1'!G113)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A116=\"\",E33,'2.0.1'!A116)","v":17},{"$f":"IF('2.0.1'!C116=\"\",\"\",'2.0.1'!C116)","v":"Has your agency entered into a sale of receivables or factoring transaction (i.e. received a payment in exchange for surrendering the right to cash flows from collections of specific receivables or specific future revenues)?"},{"$f":"IF('2.0.1'!G116=\"\",\"\",'2.0.1'!G116)","v":"No"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A118=\"\",E34,'2.0.1'!A118)","v":17},{"$f":"IF('2.0.1'!C118=\"\",\"\",'2.0.1'!C118)","v":"Action:  Provide a description of the transaction (include the counter party of the transaction and any responsibilities for servicing retained by the agency) in an attachment to this Master Reporting Package Checklist to the Comptroller General's Office."},{"$f":"IF('2.0.1'!G118=\"\",\"\",'2.0.1'!G118)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A223=\"\",E35,'2.0.1'!A223)","v":34},{"$f":"IF('2.0.1'!C223=\"\",\"\",'2.0.1'!C223)","v":"Has your agency agreed to make payments or accept reduced revenues after year-end resulting from non-compliance with regulations or the violation of rules or federal program requirements that occurred before year-end?  (i.e. Has an agreement been reached to make payments or accept reduced revenues in a future State fiscal year as a result of past events that caused a disallowance or penalty?)"},{"$f":"IF('2.0.1'!G223=\"\",\"\",'2.0.1'!G223)","v":"Yes"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A225=\"\",E36,'2.0.1'!A225)","v":34},{"$f":"IF('2.0.1'!C225=\"\",\"\",'2.0.1'!C225)","v":"Action:  A Disallowances and Penalties Reporting Package is required (See Section 3.14)."},{"$f":"IF('2.0.1'!G225=\"\",\"\",'2.0.1'!G225)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A228=\"\",E37,'2.0.1'!A228)","v":35},{"$f":"IF('2.0.1'!C228=\"\",\"\",'2.0.1'!C228)","v":"Did your agency have any other disallowance or penalty situations that may require future payments or reduced revenues after June 30? (See section 3.14 of the Reporting Policies and Procedures Manual for other disallowance and penalty situations that will be reported as part of the subsequent events reporting package such as disallowances or penalties that are probable, reasonably possible, or occur after June 30.)"},{"$f":"IF('2.0.1'!G228=\"\",\"\",'2.0.1'!G228)","v":"No"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A230=\"\",E38,'2.0.1'!A230)","v":35},{"$f":"IF('2.0.1'!C230=\"\",\"\",'2.0.1'!C230)","v":"Action: The subsequent events reporting package will request additional information, such as the fund(s) responsible for payment, State fiscal year amounts are due, a description of the situation, name of the entity assessing the disallowance or penalty, information about a receivable from outside the State reporting entity for a portion or all of this liability (if applicable), pass-through information (if applicable),timing of when the disallowance or penalty was identified, an estimate of the liability or estimate range or explanation why no estimate is available, and if an estimate range is used please also include if some amount within the range appears at the time to be a better estimate than any other amount within the range or if no amount within the range is a better estimate than any other amount. If possible, send a copy of related correspondences with the entity assessing the disallowance or penalty, the outside entity paying a portion or all of this liability (if applicable), and the pass-through entity (if applicable)."},{"$f":"IF('2.0.1'!G230=\"\",\"\",'2.0.1'!G230)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A122=\"\",E39,'2.0.1'!A122)","v":18},{"$f":"IF('2.0.1'!C122=\"\",\"\",'2.0.1'!C122)","v":"Did your agency have inventory on hand at year-end? "},{"$f":"IF('2.0.1'!G122=\"\",\"\",'2.0.1'!G122)","v":"Yes"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A124=\"\",E40,'2.0.1'!A124)","v":18},{"$f":"IF('2.0.1'!C124=\"\",\"\",'2.0.1'!C124)","v":"Action: An Inventory Reporting Package is required (See Section 3.06)."},{"$f":"IF('2.0.1'!G124=\"\",\"\",'2.0.1'!G124)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A127=\"\",E42,'2.0.1'!A127)","v":19},{"$f":"IF('2.0.1'!C127=\"\",\"\",'2.0.1'!C127)","v":"Did your agency have United States Department of Agriculture food supplies (commodities) at year-end?"},{"$f":"IF('2.0.1'!G127=\"\",\"\",'2.0.1'!G127)","v":"No"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A129=\"\",E42,'2.0.1'!A129)","v":19},{"$f":"IF('2.0.1'!C129=\"\",\"\",'2.0.1'!C129)","v":"Action: An Inventory Reporting Package is required (See Section 3.06)."},{"$f":"IF('2.0.1'!G129=\"\",\"\",'2.0.1'!G129)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A133=\"\",E43,'2.0.1'!A133)","v":20},{"$f":"IF('2.0.1'!C133=\"\",\"\",'2.0.1'!C133)","v":"At June 30, had your agency prepaid (paid prior to receipt of the good/service) any expenses that need to be reported? Agencies should not report a prepaid expense if 12 months of expenditures have already been recorded in the current year for recurring items that have been in existence. Agencies may exclude everything  individually under $10,000 up to $100,000 in aggregate from this reporting package (i.e., small items do not need to be reported as long as the total amount of items excluded does not exceed $100,000 for your agency)."},{"$f":"IF('2.0.1'!G133=\"\",\"\",'2.0.1'!G133)","v":"Yes"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A135=\"\",E44,'2.0.1'!A135)","v":20},{"$f":"IF('2.0.1'!C135=\"\",\"\",'2.0.1'!C135)","v":"Action: A Prepaid Expenses Reporting Package is required (See Section 3.07) ."},{"$f":"IF('2.0.1'!G135=\"\",\"\",'2.0.1'!G135)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A139=\"\",E45,'2.0.1'!A139)","v":21},{"$f":"IF('2.0.1'!C139=\"\",\"\",'2.0.1'!C139)","v":"a. Were any capital assets reported by your agency at the end of the previous fiscal year through SCEIS reporting?"},{"$f":"IF('2.0.1'!G139=\"\",\"\",'2.0.1'!G139)","v":"Yes"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A141=\"\",E46,'2.0.1'!A141)","v":21},{"$f":"IF('2.0.1'!C141=\"\",\"\",'2.0.1'!C141)","v":"Action:  A Capital Assets Reporting Package is required (See Section 3.08)."},{"$f":"IF('2.0.1'!G141=\"\",\"\",'2.0.1'!G141)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A144=\"\",E47,'2.0.1'!A144)","v":21},{"$f":"IF('2.0.1'!C144=\"\",\"\",'2.0.1'!C144)","v":"b. Were any capital assets reported by your agency at the end of the previous fiscal year through non-SCEIS reporting?"},{"$f":"IF('2.0.1'!G144=\"\",\"\",'2.0.1'!G144)","v":"No"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A146=\"\",E48,'2.0.1'!A146)","v":21},{"$f":"IF('2.0.1'!C146=\"\",\"\",'2.0.1'!C146)","v":"Action:  A Capital Assets Reporting Package is required (See Section 3.08)."},{"$f":"IF('2.0.1'!G146=\"\",\"\",'2.0.1'!G146)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A149=\"\",E49,'2.0.1'!A149)","v":22},{"$f":"IF('2.0.1'!C149=\"\",\"\",'2.0.1'!C149)","v":"Does your agency own any capital assets at June 30, recorded in SCEIS or other reporting?"},{"$f":"IF('2.0.1'!G149=\"\",\"\",'2.0.1'!G149)","v":"Yes"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A151=\"\",E50,'2.0.1'!A151)","v":22},{"$f":"IF('2.0.1'!C151=\"\",\"\",'2.0.1'!C151)","v":"Action:  A Capital Assets Reporting Package is required (See Section 3.08)."},{"$f":"IF('2.0.1'!G151=\"\",\"\",'2.0.1'!G151)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A154=\"\",E51,'2.0.1'!A154)","v":23},{"$f":"IF('2.0.1'!C154=\"\",\"\",'2.0.1'!C154)","v":"Did your agency recognize any non-cash contributions or transfers of assets during the fiscal year?"},{"$f":"IF('2.0.1'!G154=\"\",\"\",'2.0.1'!G154)","v":"No"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A156=\"\",E52,'2.0.1'!A156)","v":23},{"$f":"IF('2.0.1'!C156=\"\",\"\",'2.0.1'!C156)","v":"Action:  A Capital Assets Reporting Package is required (See Section 3.08)."},{"$f":"IF('2.0.1'!G156=\"\",\"\",'2.0.1'!G156)","v":""}]
["2.0.1",{"$f":"AgencyCode","v":"E120"},{"$f":"AgencyName","v":"COMPTROLLER GENERAL'S OFFICE\n"},{"$f":"Year","v":2021},{"$f":"IF('2.0.1'!A160=\"\",E53,'2.0.1'!A160)","v":24},{"$f":"IF('2.0.1'!C160=\"\",\"\",'2.0.1'!C160)","v":"Did your agency record any operating lease payments under lease agreements during the fiscal year?  This can include rental of PO Boxes, postage machines, etc.  Please use report provided by the CG's office as a guide for reporting rent and lease payment items."},{"$f":"IF('2.0.1'!G160=\"\",\"\",'2.0.1'!G160)","v":"Yes"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A162=\"\",E54,'2.0.1'!A162)","v":24},{"$f":"IF('2.0.1'!C162=\"\",\"\",'2.0.1'!C162)","v":"Action:  An Operating Leases Reporting Package is required (See Section 3.09)."},{"$f":"IF('2.0.1'!G162=\"\",\"\",'2.0.1'!G162)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A165=\"\",E55,'2.0.1'!A165)","v":25},{"$f":"IF('2.0.1'!C165=\"\",\"\",'2.0.1'!C165)","v":"Does your agency have noncancelable operating leases in effect at June 30 with future minimum required payments?"},{"$f":"IF('2.0.1'!G165=\"\",\"\",'2.0.1'!G165)","v":"No"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A167=\"\",E56,'2.0.1'!A167)","v":25},{"$f":"IF('2.0.1'!C167=\"\",\"\",'2.0.1'!C167)","v":"Action:  An Operating Leases Reporting Package is required (See Section 3.09)."},{"$f":"IF('2.0.1'!G167=\"\",\"\",'2.0.1'!G167)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A170=\"\",E57,'2.0.1'!A170)","v":26},{"$f":"IF('2.0.1'!C170=\"\",\"\",'2.0.1'!C170)","v":"Did your agency collect any revenues from non-State parties under operating leases involving State-owned assets during the fiscal year?"},{"$f":"IF('2.0.1'!G170=\"\",\"\",'2.0.1'!G170)","v":"No"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A172=\"\",E58,'2.0.1'!A172)","v":26},{"$f":"IF('2.0.1'!C172=\"\",\"\",'2.0.1'!C172)","v":"Action:  An Operating Leases Reporting Package is required (See Section 3.09)."},{"$f":"IF('2.0.1'!G172=\"\",\"\",'2.0.1'!G172)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A176=\"\",E59,'2.0.1'!A176)","v":27},{"$f":"IF('2.0.1'!C176=\"\",\"\",'2.0.1'!C176)","v":"Are payments being made on lease agreements which meet the criteria for capital leases (see form Lease Register on the CG's website under GAAP Reporting?"},{"$f":"IF('2.0.1'!G176=\"\",\"\",'2.0.1'!G176)","v":"Yes"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A178=\"\",E60,'2.0.1'!A178)","v":27},{"$f":"IF('2.0.1'!C178=\"\",\"\",'2.0.1'!C178)","v":"a.  Have the capital lease and terms of the contract been reported to the CG's office?"},{"$f":"IF('2.0.1'!G178=\"\",\"\",'2.0.1'!G178)","v":"Yes"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A180=\"\",E61,'2.0.1'!A180)","v":27},{"$f":"IF('2.0.1'!C180=\"\",\"\",'2.0.1'!C180)","v":"RESPOND AS NEEDED TO Sub-question I below."},{"$f":"IF('2.0.1'!G180=\"\",\"\",'2.0.1'!G180)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A182=\"\",E61,'2.0.1'!A182)","v":27},{"$f":"IF('2.0.1'!C182=\"\",\"\",'2.0.1'!C182)","v":"i)  Are the assets acquired under capital leases reflected in the SCEIS Asset History Listing or other Asset Listing if not in SCEIS?"},{"$f":"IF('2.0.1'!G182=\"\",\"\",'2.0.1'!G182)","v":"Yes"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A184=\"\",E63,'2.0.1'!A184)","v":27},{"$f":"IF('2.0.1'!C184=\"\",\"\",'2.0.1'!C184)","v":""},{"$f":"IF('2.0.1'!G184=\"\",\"\",'2.0.1'!G184)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A186=\"\",E64,'2.0.1'!A186)","v":27},null,{"$f":"IF('2.0.1'!C186=\"\",\"\",'2.0.1'!C186)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A187=\"\",E65,'2.0.1'!A187)","v":27},null,{"$f":"IF('2.0.1'!C187=\"\",\"\",'2.0.1'!C187)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A188=\"\",E66,'2.0.1'!A188)","v":27},null,{"$f":"IF('2.0.1'!C188=\"\",\"\",'2.0.1'!C188)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A189=\"\",E67,'2.0.1'!A189)","v":27},null,{"$f":"IF('2.0.1'!C189=\"\",\"\",'2.0.1'!C189)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A190=\"\",E68,'2.0.1'!A190)","v":27},null,{"$f":"IF('2.0.1'!C190=\"\",\"\",'2.0.1'!C190)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A192=\"\",E69,'2.0.1'!A192)","v":28},{"$f":"IF('2.0.1'!C192=\"\",\"\",'2.0.1'!C192)","v":"Has the agency reviewed all leases entered into during the current fiscal year to determine if they have been properly classified as operating or capital lease?"},{"$f":"IF('2.0.1'!G192=\"\",\"\",'2.0.1'!G192)","v":"Yes"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A193=\"\",E70,'2.0.1'!A193)","v":28},{"$f":"IF('2.0.1'!#REF!=\"\",\"\",'2.0.1'!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF('2.0.1'!#REF!=\"\",\"\",'2.0.1'!#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A202=\"\",E71,'2.0.1'!A202)","v":30},{"$f":"IF('2.0.1'!C202=\"\",\"\",'2.0.1'!C202)","v":"Did your agency receive goods or services prior to June 30 for which payment has not been made as of the close of A/P processing at year-end? In addition to payables due to outside entities, interfund payables individually under $100,000 are reported on 3.12."},{"$f":"IF('2.0.1'!G202=\"\",\"\",'2.0.1'!G202)","v":"Yes"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A204=\"\",E72,'2.0.1'!A204)","v":30},{"$f":"IF('2.0.1'!C204=\"\",\"\",'2.0.1'!C204)","v":"Action:  An Accounts Payable Reporting Package is required (See Section 3.12) A/P processing continues past June 30 so a payable does not exist if amounts due as of June 30 were paid with that year’s funds i.e. paid during extended period 12 or period 13."},{"$f":"IF('2.0.1'!G204=\"\",\"\",'2.0.1'!G204)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A207=\"\",E73,'2.0.1'!A207)","v":31},{"$f":"IF('2.0.1'!C207=\"\",\"\",'2.0.1'!C207)","v":"Did your agency recognize expenditures in period 12 (June 1 - June 30) of the fiscal year? "},{"$f":"IF('2.0.1'!G207=\"\",\"\",'2.0.1'!G207)","v":"Yes"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!#REF!=\"\",E74,'2.0.1'!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF('2.0.1'!#REF!=\"\",\"\",'2.0.1'!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF('2.0.1'!#REF!=\"\",\"\",'2.0.1'!#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A210=\"\",E75,'2.0.1'!A210)","v":32},{"$f":"IF('2.0.1'!C210=\"\",\"\",'2.0.1'!C210)","v":"Did your agency receive goods or services prior to June 30 for which an invoice (billing) has not been received prior to the completion and submission of this checklist? In addition to payables due to outside entities, interfund payables individually under $100,000 are reported on 3.12."},{"$f":"IF('2.0.1'!G210=\"\",\"\",'2.0.1'!G210)","v":"Yes"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A213=\"\",E76,'2.0.1'!A213)","v":32},{"$f":"IF('2.0.1'!C213=\"\",\"\",'2.0.1'!C213)","v":"Action:  An Accounts Payable Reporting Package is required (See Section 3.12)Information relating to the billings for these goods and services should be reported based on billings received through the preparation of Section 3.12 and estimates should be reported for billings not received as of that date."},{"$f":"IF('2.0.1'!G213=\"\",\"\",'2.0.1'!G213)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A234=\"\",E77,'2.0.1'!A234)","v":36},{"$f":"IF('2.0.1'!C234=\"\",\"\",'2.0.1'!C234)","v":"Will the August or later payrolls include payments due to employees, including retirees, who terminated State employment on or before June 30?"},{"$f":"IF('2.0.1'!G234=\"\",\"\",'2.0.1'!G234)","v":"No"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A236=\"\",E78,'2.0.1'!A236)","v":36},{"$f":"IF('2.0.1'!C236=\"\",\"\",'2.0.1'!C236)","v":"Action:  Provide the following information:"},{"$f":"IF('2.0.1'!G236=\"\",\"\",'2.0.1'!G236)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A238=\"\",E79,'2.0.1'!A238)","v":36},"Fund 1",{"$f":"IF('2.0.1'!C239=\"\",\"\",'2.0.1'!C239)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A239=\"\",E80,'2.0.1'!A239)","v":36},"Fund 2",{"$f":"IF('2.0.1'!C240=\"\",\"\",'2.0.1'!C240)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A240=\"\",E81,'2.0.1'!A240)","v":36},"Fund 3",{"$f":"IF('2.0.1'!C241=\"\",\"\",'2.0.1'!C241)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A238=\"\",E82,'2.0.1'!A238)","v":36},"Employee Grass Pay 1",{"$f":"IF('2.0.1'!E239=\"\",\"\",'2.0.1'!E239)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A239=\"\",E83,'2.0.1'!A239)","v":36},"Employee Grass Pay 2",{"$f":"IF('2.0.1'!E240=\"\",\"\",'2.0.1'!E240)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A240=\"\",E84,'2.0.1'!A240)","v":36},"Employee Grass Pay 3",{"$f":"IF('2.0.1'!E241=\"\",\"\",'2.0.1'!E241)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A238=\"\",E85,'2.0.1'!A238)","v":36},"Dates to be paid 1",{"$f":"IF('2.0.1'!G239=\"\",\"\",'2.0.1'!G239)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A239=\"\",E86,'2.0.1'!A239)","v":36},"Dates to be paid 2",{"$f":"IF('2.0.1'!G240=\"\",\"\",'2.0.1'!G240)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A240=\"\",E87,'2.0.1'!A240)","v":36},"Dates to be paid 3",{"$f":"IF('2.0.1'!G241=\"\",\"\",'2.0.1'!G241)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A243=\"\",E88,'2.0.1'!A243)","v":37},{"$f":"IF('2.0.1'!C243=\"\",\"\",'2.0.1'!C243)","v":"Did your agency offer special termination benefits to any employees during the fiscal year for which the payout was NOT made on or before June 30?"},{"$f":"IF('2.0.1'!G243=\"\",\"\",'2.0.1'!G243)","v":"No"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A245=\"\",E89,'2.0.1'!A245)","v":37},{"$f":"IF('2.0.1'!C245=\"\",\"\",'2.0.1'!C245)","v":"Action:  Provide the following information:"},{"$f":"IF('2.0.1'!G245=\"\",\"\",'2.0.1'!G245)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A247=\"\",E90,'2.0.1'!A247)","v":37},"Fund 1",{"$f":"IF('2.0.1'!C248=\"\",\"\",'2.0.1'!C248)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A248=\"\",E91,'2.0.1'!A248)","v":37},"Fund 2",{"$f":"IF('2.0.1'!C249=\"\",\"\",'2.0.1'!C249)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A249=\"\",E92,'2.0.1'!A249)","v":37},"Fund 3",{"$f":"IF('2.0.1'!C250=\"\",\"\",'2.0.1'!C250)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A247=\"\",E93,'2.0.1'!A247)","v":37},"Amount to be paid 1",{"$f":"IF('2.0.1'!E248=\"\",\"\",'2.0.1'!E248)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A248=\"\",E94,'2.0.1'!A248)","v":37},"Amount to be paid 2",{"$f":"IF('2.0.1'!E249=\"\",\"\",'2.0.1'!E249)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A249=\"\",E95,'2.0.1'!A249)","v":37},"Amount to be paid 3",{"$f":"IF('2.0.1'!E250=\"\",\"\",'2.0.1'!E250)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A247=\"\",E96,'2.0.1'!A247)","v":37},"Dates to be paid 1",{"$f":"IF('2.0.1'!G248=\"\",\"\",'2.0.1'!G248)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A248=\"\",E97,'2.0.1'!A248)","v":37},"Dates to be paid 2",{"$f":"IF('2.0.1'!G249=\"\",\"\",'2.0.1'!G249)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A249=\"\",E98,'2.0.1'!A249)","v":37},"Dates to be paid 3",{"$f":"IF('2.0.1'!G250=\"\",\"\",'2.0.1'!G250)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A253=\"\",E99,'2.0.1'!A253)","v":38},{"$f":"IF('2.0.1'!C253=\"\",\"\",'2.0.1'!C253)","v":"Does another entity that is legally separate from the State of South Carolina make payments for salaries and benefits for employees who work to carry out your agency's programs?"},{"$f":"IF('2.0.1'!G253=\"\",\"\",'2.0.1'!G253)","v":"No"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A255=\"\",E100,'2.0.1'!A255)","v":38},{"$f":"IF('2.0.1'!C255=\"\",\"\",'2.0.1'!C255)","v":"Action:  Provide the following information:"},{"$f":"IF('2.0.1'!G255=\"\",\"\",'2.0.1'!G255)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A257=\"\",E101,'2.0.1'!A257)","v":38},"Entity 1",{"$f":"IF('2.0.1'!C258=\"\",\"\",'2.0.1'!C258)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A258=\"\",E102,'2.0.1'!A258)","v":38},"Entity 2",{"$f":"IF('2.0.1'!C259=\"\",\"\",'2.0.1'!C259)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A259=\"\",E103,'2.0.1'!A259)","v":38},"Entity 3",{"$f":"IF('2.0.1'!C260=\"\",\"\",'2.0.1'!C260)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A257=\"\",E104,'2.0.1'!A257)","v":38},"Amount to be paid 1",{"$f":"IF('2.0.1'!E258=\"\",\"\",'2.0.1'!E258)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A258=\"\",E105,'2.0.1'!A258)","v":38},"Amount to be paid 2",{"$f":"IF('2.0.1'!E259=\"\",\"\",'2.0.1'!E259)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A259=\"\",E106,'2.0.1'!A259)","v":38},"Amount to be paid 3",{"$f":"IF('2.0.1'!E260=\"\",\"\",'2.0.1'!E260)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A257=\"\",E107,'2.0.1'!A257)","v":38},"Dates to be paid 1",{"$f":"IF('2.0.1'!G258=\"\",\"\",'2.0.1'!G258)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A258=\"\",E108,'2.0.1'!A258)","v":38},"Dates to be paid 2",{"$f":"IF('2.0.1'!G259=\"\",\"\",'2.0.1'!G259)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A259=\"\",E109,'2.0.1'!A259)","v":38},"Dates to be paid 3",{"$f":"IF('2.0.1'!G260=\"\",\"\",'2.0.1'!G260)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A292=\"\",E110,'2.0.1'!A292)","v":42},{"$f":"IF('2.0.1'!C292=\"\",\"\",'2.0.1'!C292)","v":"Did your agency have unprocessed payment IDT's (unpaid) and/or disbursement vouchers individually over $100,000 to another agency within the State's financial reporting entity as of June 30?"},{"$f":"IF('2.0.1'!G292=\"\",\"\",'2.0.1'!G292)","v":"Yes"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A294=\"\",E111,'2.0.1'!A294)","v":42},{"$f":"IF('2.0.1'!C294=\"\",\"\",'2.0.1'!C294)","v":"Action:  The Interfund Payables Reporting Package is required (See Section 3.18)."},{"$f":"IF('2.0.1'!G294=\"\",\"\",'2.0.1'!G294)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A298=\"\",E112,'2.0.1'!A298)","v":43},{"$f":"IF('2.0.1'!C298=\"\",\"\",'2.0.1'!C298)","v":"Has your agency entered into other transactions individually over $100,000 with other state agencies which would give rise to a receivable or payable owed to or from the other agency as of June 30?"},{"$f":"IF('2.0.1'!G298=\"\",\"\",'2.0.1'!G298)","v":"Yes"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A300=\"\",E113,'2.0.1'!A300)","v":43},{"$f":"IF('2.0.1'!C300=\"\",\"\",'2.0.1'!C300)","v":"Action:  The Interfund Payables Reporting Package is required (See Section 3.18)."},{"$f":"IF('2.0.1'!G300=\"\",\"\",'2.0.1'!G300)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A304=\"\",E114,'2.0.1'!A304)","v":44},{"$f":"IF('2.0.1'!C304=\"\",\"\",'2.0.1'!C304)","v":"The Comptroller General's Office obtains information relating to inter-agency/interfund loans from the State Treasurer's Office and the Department of Administration as follows:"},{"$f":"IF('2.0.1'!G304=\"\",\"\",'2.0.1'!G304)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A310=\"\",E115,'2.0.1'!A310)","v":44},{"$f":"IF('2.0.1'!C310=\"\",\"\",'2.0.1'!C310)","v":"Does your agency have any notes or loans payable or receivable outstanding at June 30 with other State agencies (including State universities and technical colleges) under any program NOT listed above?"},{"$f":"IF('2.0.1'!G310=\"\",\"\",'2.0.1'!G310)","v":"No"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A312=\"\",E116,'2.0.1'!A312)","v":44},{"$f":"IF('2.0.1'!C312=\"\",\"\",'2.0.1'!C312)","v":"Action:  Provide the following information (if additional space is needed, click the Show Worksheet 36. (Cont) button below)"},{"$f":"IF('2.0.1'!G312=\"\",\"\",'2.0.1'!G312)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A314=\"\",E117,'2.0.1'!A314)","v":44},{"$f":"IF('2.0.1'!C314=\"\",\"\",'2.0.1'!C314)","v":"Is your agency the lender or borrower?"},{"$f":"IF('2.0.1'!E314=\"\",\"\",'2.0.1'!E314)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A315=\"\",E118,'2.0.1'!A315)","v":44},{"$f":"IF('2.0.1'!C315=\"\",\"\",'2.0.1'!C315)","v":"Name of counter-party (other agency involved)?"},{"$f":"IF('2.0.1'!E315=\"\",\"\",'2.0.1'!E315)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A316=\"\",E119,'2.0.1'!A316)","v":44},{"$f":"IF('2.0.1'!C316=\"\",\"\",'2.0.1'!C316)","v":"Original amount of the loan"},{"$f":"IF('2.0.1'!E316=\"\",\"\",'2.0.1'!E316)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A317=\"\",E120,'2.0.1'!A317)","v":44},{"$f":"IF('2.0.1'!C317=\"\",\"\",'2.0.1'!C317)","v":"Date of the original loan"},{"$f":"IF('2.0.1'!E317=\"\",\"\",'2.0.1'!E317)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A318=\"\",E121,'2.0.1'!A318)","v":44},{"$f":"IF('2.0.1'!C318=\"\",\"\",'2.0.1'!C318)","v":"Additional advances made"},{"$f":"IF('2.0.1'!E318=\"\",\"\",'2.0.1'!E318)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A319=\"\",E122,'2.0.1'!A319)","v":44},{"$f":"IF('2.0.1'!C319=\"\",\"\",'2.0.1'!C319)","v":"Dates of additional advances"},{"$f":"IF('2.0.1'!E319=\"\",\"\",'2.0.1'!E319)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A320=\"\",E123,'2.0.1'!A320)","v":44},{"$f":"IF('2.0.1'!C320=\"\",\"\",'2.0.1'!C320)","v":"Balance as of June 30"},{"$f":"IF('2.0.1'!E320=\"\",\"\",'2.0.1'!E320)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A321=\"\",E124,'2.0.1'!A321)","v":44},{"$f":"IF('2.0.1'!C321=\"\",\"\",'2.0.1'!C321)","v":"Number of Payments required"},{"$f":"IF('2.0.1'!E321=\"\",\"\",'2.0.1'!E321)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A322=\"\",E125,'2.0.1'!A322)","v":44},{"$f":"IF('2.0.1'!C322=\"\",\"\",'2.0.1'!C322)","v":"Frequency of payments required (selections in drop-down)"},{"$f":"IF('2.0.1'!E322=\"\",\"\",'2.0.1'!E322)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A323=\"\",E126,'2.0.1'!A323)","v":44},{"$f":"IF('2.0.1'!C323=\"\",\"\",'2.0.1'!C323)","v":"Copies of signed agreements (for new loans only)."},{"$f":"IF('2.0.1'!E323=\"\",\"\",'2.0.1'!E323)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A329=\"\",E127,'2.0.1'!A329)","v":45},{"$f":"IF('2.0.1'!C329=\"\",\"\",'2.0.1'!C329)","v":"Does your agency have any loans or notes payable/receivable at June 30 between funds within your agency?"},{"$f":"IF('2.0.1'!G329=\"\",\"\",'2.0.1'!G329)","v":"Yes"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A331=\"\",E128,'2.0.1'!A331)","v":45},{"$f":"IF('2.0.1'!C331=\"\",\"\",'2.0.1'!C331)","v":"Action:  Describe the situation in a letter or other attachment when you return this Master Reporting Package Checklist to the Comptroller General's Office.  Please provide copies of signed agreements for any new loans."},{"$f":"IF('2.0.1'!G331=\"\",\"\",'2.0.1'!G331)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A334=\"\",E129,'2.0.1'!A334)","v":46},{"$f":"IF('2.0.1'!C334=\"\",\"\",'2.0.1'!C334)","v":"Has your agency provided resources to or received resources from another agency with an understanding that the resources were borrowed but no note or repayment contract was executed for the transaction?"},{"$f":"IF('2.0.1'!G334=\"\",\"\",'2.0.1'!G334)","v":"Yes"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A336=\"\",E130,'2.0.1'!A336)","v":46},{"$f":"IF('2.0.1'!C336=\"\",\"\",'2.0.1'!C336)","v":"Action:  Describe the situation in a letter or other attachment when you return this Master Reporting Package Checklist to the Comptroller General's Office.  Please provide details of your understanding with the other agency."},{"$f":"IF('2.0.1'!G336=\"\",\"\",'2.0.1'!G336)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A339=\"\",E131,'2.0.1'!A339)","v":47},{"$f":"IF('2.0.1'!C339=\"\",\"\",'2.0.1'!C339)","v":"Have resources been provided by one fund within your agency to another fund within your agency with an understanding that the resources were borrowed but no note or repayment contract was executed for the transaction?"},{"$f":"IF('2.0.1'!G339=\"\",\"\",'2.0.1'!G339)","v":"Yes"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A341=\"\",E132,'2.0.1'!A341)","v":47},{"$f":"IF('2.0.1'!C341=\"\",\"\",'2.0.1'!C341)","v":"Action:  Describe the situation in a letter or other attachment when you return this Master Reporting Package Checklist to the Comptroller General's Office.  Please provide details of the plans for return of resources (repayment) between the funds within your agency."},{"$f":"IF('2.0.1'!G341=\"\",\"\",'2.0.1'!G341)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!#REF!=\"\",E133,'2.0.1'!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF('2.0.1'!#REF!=\"\",\"\",'2.0.1'!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF('2.0.1'!#REF!=\"\",\"\",'2.0.1'!#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!#REF!=\"\",E134,'2.0.1'!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF('2.0.1'!#REF!=\"\",\"\",'2.0.1'!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF('2.0.1'!#REF!=\"\",\"\",'2.0.1'!#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A344=\"\",E135,'2.0.1'!A344)","v":48},{"$f":"IF('2.0.1'!C344=\"\",\"\",'2.0.1'!C344)","v":"The State Treasurer's Office Master Lease Program provides financing for equipment purchases of $100,000 or greater.  Borrowings under this program are notes rather than leases for accounting and reporting purposes.   Did your agency have any outstanding balance on financing agreements under the State Treasurer's Office Master Lease Program as of June 30?"},{"$f":"IF('2.0.1'!G344=\"\",\"\",'2.0.1'!G344)","v":"Yes"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A346=\"\",E136,'2.0.1'!A346)","v":48},{"$f":"IF('2.0.1'!C346=\"\",\"\",'2.0.1'!C346)","v":"a.   Did your agency have any loan proceeds held in an escrow account at June 30 for any loans under this program?"},{"$f":"IF('2.0.1'!G346=\"\",\"\",'2.0.1'!G346)","v":"No"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A348=\"\",E137,'2.0.1'!A348)","v":48},{"$f":"IF('2.0.1'!C348=\"\",\"\",'2.0.1'!C348)","v":"Action:  Provide the following information (if additional space is needed, click the Show Worksheet 42. (Cont) button below)"},{"$f":"IF('2.0.1'!G348=\"\",\"\",'2.0.1'!G348)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A350=\"\",E138,'2.0.1'!A350)","v":48},{"$f":"IF('2.0.1'!C350=\"\",\"\",'2.0.1'!C350)","v":"Lease ID #"},{"$f":"IF('2.0.1'!E350=\"\",\"\",'2.0.1'!E350)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A351=\"\",E139,'2.0.1'!A351)","v":48},{"$f":"IF('2.0.1'!C351=\"\",\"\",'2.0.1'!C351)","v":"Amount held in escrow"},{"$f":"IF('2.0.1'!E351=\"\",\"\",'2.0.1'!E351)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A353=\"\",E140,'2.0.1'!A353)","v":48},{"$f":"IF('2.0.1'!C353=\"\",\"\",'2.0.1'!C353)","v":"b.   Did your agency have an escrow account for this program closed out during the fiscal year?"},{"$f":"IF('2.0.1'!G353=\"\",\"\",'2.0.1'!G353)","v":"No"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A355=\"\",E141,'2.0.1'!A355)","v":48},{"$f":"IF('2.0.1'!C355=\"\",\"\",'2.0.1'!C355)","v":"Action:  Provide the following information (if additional space is needed, click the Show Worksheet 42. (Cont) button below)"},{"$f":"IF('2.0.1'!G355=\"\",\"\",'2.0.1'!G355)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A357=\"\",E142,'2.0.1'!A357)","v":48},{"$f":"IF('2.0.1'!C357=\"\",\"\",'2.0.1'!C357)","v":"Lease ID #(s)"},{"$f":"IF('2.0.1'!E357=\"\",\"\",'2.0.1'!E357)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A358=\"\",E143,'2.0.1'!A358)","v":48},{"$f":"IF('2.0.1'!C358=\"\",\"\",'2.0.1'!C358)","v":"Date the escrow account was closed checklist."},{"$f":"IF('2.0.1'!E358=\"\",\"\",'2.0.1'!E358)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A360=\"\",E144,'2.0.1'!A360)","v":48},{"$f":"IF('2.0.1'!C360=\"\",\"\",'2.0.1'!C360)","v":"c.  Was an asset(s) established in the SCEIS system?"},{"$f":"IF('2.0.1'!E360=\"\",\"\",'2.0.1'!E360)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A364=\"\",E145,'2.0.1'!A364)","v":48},null,{"$f":"IF('2.0.1'!C364=\"\",\"\",'2.0.1'!C364)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A365=\"\",E146,'2.0.1'!A365)","v":48},null,{"$f":"IF('2.0.1'!C365=\"\",\"\",'2.0.1'!C365)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A366=\"\",E147,'2.0.1'!A366)","v":48},null,{"$f":"IF('2.0.1'!C366=\"\",\"\",'2.0.1'!C366)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A367=\"\",E148,'2.0.1'!A367)","v":48},null,{"$f":"IF('2.0.1'!C367=\"\",\"\",'2.0.1'!C367)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A368=\"\",E149,'2.0.1'!A368)","v":48},null,{"$f":"IF('2.0.1'!C368=\"\",\"\",'2.0.1'!C368)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A372=\"\",E150,'2.0.1'!A372)","v":49},{"$f":"IF('2.0.1'!C372=\"\",\"\",'2.0.1'!C372)","v":"Did your agency have any outstanding loan balance on any loans under the State Treasurer's Office Master Lease Program at the beginning of the year?"},{"$f":"IF('2.0.1'!G372=\"\",\"\",'2.0.1'!G372)","v":"Yes"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A374=\"\",E151,'2.0.1'!A374)","v":49},{"$f":"IF('2.0.1'!C374=\"\",\"\",'2.0.1'!C374)","v":"a.  Did your agency pay off any loans under this program during the fiscal year ended June 30?"},{"$f":"IF('2.0.1'!G374=\"\",\"\",'2.0.1'!G374)","v":"No"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A376=\"\",E152,'2.0.1'!A376)","v":49},{"$f":"IF('2.0.1'!C376=\"\",\"\",'2.0.1'!C376)","v":"Action:  Provide a listing including Lease ID #(s), amount(s), and payment date(s) as an attachment when you return this Master Reporting Package Checklist to the Comptroller General's Office."},{"$f":"IF('2.0.1'!G376=\"\",\"\",'2.0.1'!G376)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A378=\"\",E153,'2.0.1'!A378)","v":49},{"$f":"IF('2.0.1'!C378=\"\",\"\",'2.0.1'!C378)","v":"b.   Did your agency have an escrow account for this program closed out during the fiscal year?"},{"$f":"IF('2.0.1'!G378=\"\",\"\",'2.0.1'!G378)","v":"No"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A380=\"\",E154,'2.0.1'!A380)","v":49},{"$f":"IF('2.0.1'!C380=\"\",\"\",'2.0.1'!C380)","v":"Action:  Provide the following information (if additional space is needed, attach a sheet)"},{"$f":"IF('2.0.1'!G380=\"\",\"\",'2.0.1'!G380)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A382=\"\",E155,'2.0.1'!A382)","v":49},{"$f":"IF('2.0.1'!C382=\"\",\"\",'2.0.1'!C382)","v":"Lease ID #(s)"},{"$f":"IF('2.0.1'!E382=\"\",\"\",'2.0.1'!E382)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A383=\"\",E156,'2.0.1'!A383)","v":49},{"$f":"IF('2.0.1'!C383=\"\",\"\",'2.0.1'!C383)","v":"Date the escrow account was closed checklist."},{"$f":"IF('2.0.1'!E383=\"\",\"\",'2.0.1'!E383)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A386=\"\",E157,'2.0.1'!A386)","v":50},{"$f":"IF('2.0.1'!C386=\"\",\"\",'2.0.1'!C386)","v":"Did your agency provide payment under the SCEIS financing agreement to the State Treasurer's Office during the year?"},{"$f":"IF('2.0.1'!G386=\"\",\"\",'2.0.1'!G386)","v":"No"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A388=\"\",E158,'2.0.1'!A388)","v":50},{"$f":"IF('2.0.1'!C388=\"\",\"\",'2.0.1'!C388)","v":"Action:  Provide the following information (if additional space is needed, click the Show Worksheet 44. (Cont) button below)"},{"$f":"IF('2.0.1'!G388=\"\",\"\",'2.0.1'!G388)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A390=\"\",E159,'2.0.1'!A390)","v":50},{"$f":"IF('2.0.1'!C390=\"\",\"\",'2.0.1'!C390)","v":"Principle"},{"$f":"IF('2.0.1'!G390=\"\",\"\",'2.0.1'!G390)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A391=\"\",E160,'2.0.1'!A391)","v":50},{"$f":"IF('2.0.1'!C391=\"\",\"\",'2.0.1'!C391)","v":"General Ledger Account"},{"$f":"IF('2.0.1'!E391=\"\",\"\",'2.0.1'!E391)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A392=\"\",E161,'2.0.1'!A392)","v":50},{"$f":"IF('2.0.1'!C392=\"\",\"\",'2.0.1'!C392)","v":"Amount"},{"$f":"IF('2.0.1'!E392=\"\",\"\",'2.0.1'!E392)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A394=\"\",E162,'2.0.1'!A394)","v":50},{"$f":"IF('2.0.1'!C394=\"\",\"\",'2.0.1'!C394)","v":"Interest"},{"$f":"IF('2.0.1'!G394=\"\",\"\",'2.0.1'!G394)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A395=\"\",E163,'2.0.1'!A395)","v":50},{"$f":"IF('2.0.1'!C395=\"\",\"\",'2.0.1'!C395)","v":"General Ledger Account"},{"$f":"IF('2.0.1'!E395=\"\",\"\",'2.0.1'!E395)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A396=\"\",E164,'2.0.1'!A396)","v":50},{"$f":"IF('2.0.1'!C396=\"\",\"\",'2.0.1'!C396)","v":"Amount"},{"$f":"IF('2.0.1'!E396=\"\",\"\",'2.0.1'!E396)","v":""}]
["2.0.1",{"$f":"AgencyCode","v":"E120"},{"$f":"AgencyName","v":"COMPTROLLER GENERAL'S OFFICE\n"},{"$f":"Year","v":2021},{"$f":"IF('2.0.1'!A400=\"\",E165,'2.0.1'!A400)","v":51},{"$f":"IF('2.0.1'!C400=\"\",\"\",'2.0.1'!C400)","v":"Has your agency used installment purchase financing (loans or notes) for acquisition?"},{"$f":"IF('2.0.1'!G400=\"\",\"\",'2.0.1'!G400)","v":"No"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A402=\"\",E166,'2.0.1'!A402)","v":51},{"$f":"IF('2.0.1'!C402=\"\",\"\",'2.0.1'!C402)","v":"a. State policy requires that all installment purchase agreements and terms of the contract be reported to the State Treasurer's Office, is your agency in violation of this policy? "},{"$f":"IF('2.0.1'!G402=\"\",\"\",'2.0.1'!G402)","v":"No"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A405=\"\",E167,'2.0.1'!A405)","v":51},{"$f":"IF('2.0.1'!C405=\"\",\"\",'2.0.1'!C405)","v":"Action:  Provide a listing including Name of Lender, identification of asset purchased, whether collateral secures the note, current year activity (including beginning balance, advances, repayments, and ending balance), and future payments (amount(s) and payment date(s)) as an attachment when you return this Master Reporting Package Checklist to the Comptroller General's Office."},{"$f":"IF('2.0.1'!G405=\"\",\"\",'2.0.1'!G405)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A408=\"\",E168,'2.0.1'!A408)","v":52},{"$f":"IF('2.0.1'!C408=\"\",\"\",'2.0.1'!C408)","v":"The Comptroller General's Office obtains certain information relating to bonds and notes payable directly from the State Treasurer's Office. The types of bonds and notes are as follows:"},{"$f":"IF('2.0.1'!G408=\"\",\"\",'2.0.1'!G408)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A421=\"\",E169,'2.0.1'!A421)","v":52},{"$f":"IF('2.0.1'!C421=\"\",\"\",'2.0.1'!C421)","v":"Does your agency have any bonds or notes outstanding and payable to parties outside State government at June 30 or any other borrowings from parties outside the State NOT listed above?"},{"$f":"IF('2.0.1'!G421=\"\",\"\",'2.0.1'!G421)","v":"No"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A423=\"\",E170,'2.0.1'!A423)","v":52},{"$f":"IF('2.0.1'!C423=\"\",\"\",'2.0.1'!C423)","v":"Action:  Describe the situation in a letter or other attachment to this Master Reporting Package Checklist to the Comptroller General's Office.  Include authorization, Lender, Amount of Note, Date of Note, Collateral, Terms of repayment, and Balance as of year-end."},{"$f":"IF('2.0.1'!G423=\"\",\"\",'2.0.1'!G423)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A73=\"\",E171,'2.0.1'!A73)","v":9},{"$f":"IF('2.0.1'!C73=\"\",\"\",'2.0.1'!C73)","v":"Is your agency required to pay interest on tax refunds?"},{"$f":"IF('2.0.1'!G73=\"\",\"\",'2.0.1'!G73)","v":"No"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A75=\"\",E172,'2.0.1'!A75)","v":9},{"$f":"IF('2.0.1'!C75=\"\",\"\",'2.0.1'!C75)","v":"Action:  Provide a schedule of the amounts paid as related to each tax source, detailed by accounting fund, general ledger (or object code), gross of related processing costs, with amounts paid to outside collection agencies as processing costs.  Submit the detailed schedule with the 3.02 Tax Revenue Reporting Package no later than August 9."},{"$f":"IF('2.0.1'!G75=\"\",\"\",'2.0.1'!G75)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A217=\"\",E173,'2.0.1'!A217)","v":33},{"$f":"IF('2.0.1'!C217=\"\",\"\",'2.0.1'!C217)","v":"Has your agency been involved in any litigation or made payments to private attorneys during the fiscal year?"},{"$f":"IF('2.0.1'!G217=\"\",\"\",'2.0.1'!G217)","v":"Yes"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A219=\"\",E174,'2.0.1'!A219)","v":33},{"$f":"IF('2.0.1'!C219=\"\",\"\",'2.0.1'!C219)","v":"Action:  The Litigation Reporting Package is required.  (See Section 3.13)"},{"$f":"IF('2.0.1'!G219=\"\",\"\",'2.0.1'!G219)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A264=\"\",E175,'2.0.1'!A264)","v":39},{"$f":"IF('2.0.1'!C264=\"\",\"\",'2.0.1'!C264)","v":"Does your agency have claims in excess of $100,000 for EITHER:"},{"$f":"IF('2.0.1'!G264=\"\",\"\",'2.0.1'!G264)","v":"Yes"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A269=\"\",E176,'2.0.1'!A269)","v":39},{"$f":"IF('2.0.1'!C269=\"\",\"\",'2.0.1'!C269)","v":"Action:  The Claims Reporting Package is required.  (See Section 3.15)"},{"$f":"IF('2.0.1'!G269=\"\",\"\",'2.0.1'!G269)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A273=\"\",E177,'2.0.1'!A273)","v":40},{"$f":"IF('2.0.1'!C273=\"\",\"\",'2.0.1'!C273)","v":"Did your agency either "},{"$f":"IF('2.0.1'!G273=\"\",\"\",'2.0.1'!G273)","v":"Yes"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A282=\"\",E178,'2.0.1'!A282)","v":40},{"$f":"IF('2.0.1'!C282=\"\",\"\",'2.0.1'!C282)","v":"Action:  The Miscellaneous Loss Liabilities, Loss Contingencies, and Commitments Reporting Package is required.   (See Section 3.16)"},{"$f":"IF('2.0.1'!G282=\"\",\"\",'2.0.1'!G282)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A285=\"\",E179,'2.0.1'!A285)","v":41},{"$f":"IF('2.0.1'!C285=\"\",\"\",'2.0.1'!C285)","v":"At June 30, have any events occurred for which your agency has yet to pay the related insurance deductible?"},{"$f":"IF('2.0.1'!G285=\"\",\"\",'2.0.1'!G285)","v":"No"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A287=\"\",E180,'2.0.1'!A287)","v":41},{"$f":"IF('2.0.1'!C287=\"\",\"\",'2.0.1'!C287)","v":"Action:  The Miscellaneous Loss Liabilities, Loss Contingencies, and Commitments Reporting Package is required.   (See Section 3.16.1)"},{"$f":"IF('2.0.1'!G287=\"\",\"\",'2.0.1'!G287)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A426=\"\",E181,'2.0.1'!A426)","v":53},{"$f":"IF('2.0.1'!C426=\"\",\"\",'2.0.1'!C426)","v":"Does your agency participate in or administer any risk management activities other than those listed in Appendix C of the Year-End Reporting Procedures Manual?"},{"$f":"IF('2.0.1'!G426=\"\",\"\",'2.0.1'!G426)","v":"No"}]
["2.0.1",{"$f":"AgencyCode","v":"E120"},{"$f":"AgencyName","v":"COMPTROLLER GENERAL'S OFFICE\n"},{"$f":"Year","v":2021},{"$f":"IF('2.0.1'!A428=\"\",E182,'2.0.1'!A428)","v":53},{"$f":"IF('2.0.1'!C428=\"\",\"\",'2.0.1'!C428)","v":"Action:  Describe the situation in a letter or other attachment when you return this Master Reporting Package Checklist to the Comptroller General's Office. Be sure to fully describe the activity and whether you self-insure the activity, purchase insurance to cover the activity, or provide insurance coverage to other entities for this activity.  Also, please include the name and phone number of a person within your agency that we may contact to obtain additional information,  if necessary."},{"$f":"IF('2.0.1'!G428=\"\",\"\",'2.0.1'!G428)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A431=\"\",E183,'2.0.1'!A431)","v":54},{"$f":"IF('2.0.1'!C431=\"\",\"\",'2.0.1'!C431)","v":"Does your agency use any non-State entities to process transactions (outsourced services - not including credit card payments)?"},{"$f":"IF('2.0.1'!G431=\"\",\"\",'2.0.1'!G431)","v":"No"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A433=\"\",E184,'2.0.1'!A433)","v":54},{"$f":"IF('2.0.1'!C433=\"\",\"\",'2.0.1'!C433)","v":"Action:  Describe the situation in a letter or other attachment (include specifics of the service agreement, the volume of transactions processed, the dollar amount of transactions processed, and procedures performed by the agency to ensure appropriate controls are in place for accuracy in recognition and reporting) when you return this Master Reporting Package Checklist to the Comptroller General's Office."},{"$f":"IF('2.0.1'!G433=\"\",\"\",'2.0.1'!G433)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A436=\"\",E185,'2.0.1'!A436)","v":55},{"$f":"IF('2.0.1'!C436=\"\",\"\",'2.0.1'!C436)","v":"Each agency is responsible for designing and implementing processes, procedures, and controls to prevent and detect fraud.  Are you aware of any instances of fraud or suspected fraud affecting your agency during the fiscal year ended June 30 involving (a) management,  (b) employees who have significant roles in internal control, or (c) others where the fraud could have a financial impact on the agency."},{"$f":"IF('2.0.1'!G436=\"\",\"\",'2.0.1'!G436)","v":"Yes"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A438=\"\",E186,'2.0.1'!A438)","v":55},{"$f":"IF('2.0.1'!C438=\"\",\"\",'2.0.1'!C438)","v":"Action:   Describe the situation on agency letterhead signed by the Agency Director or designee when this Master Reporting Package Checklist is returned to the Comptroller General's Office.  Be sure to fully describe the activity, the amount (or approximate amount) of the fraud or suspected fraud, and the resulting actions by management to prevent further fraudulent activities."},{"$f":"IF('2.0.1'!G438=\"\",\"\",'2.0.1'!G438)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A441=\"\",E187,'2.0.1'!A441)","v":56},{"$f":"IF('2.0.1'!C441=\"\",\"\",'2.0.1'!C441)","v":"Are you aware of any allegations of fraud or suspected fraud affecting your agency during the fiscal year ended June 30 (e.g., that the agency has received in communications from employees, former employees, analysts, regulators, short sellers, or others)?"},{"$f":"IF('2.0.1'!G441=\"\",\"\",'2.0.1'!G441)","v":"No"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A443=\"\",E188,'2.0.1'!A443)","v":56},{"$f":"IF('2.0.1'!C443=\"\",\"\",'2.0.1'!C443)","v":"Action:   Describe the situation on agency letterhead signed by the Agency Director or designee when this Master Reporting Package Checklist is returned to the Comptroller General's Office.  Be sure to fully describe the allegation(s) and any actions taken by management to strengthen the internal controls that may have been breached if the allegations prove true."},{"$f":"IF('2.0.1'!G443=\"\",\"\",'2.0.1'!G443)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A446=\"\",E189,'2.0.1'!A446)","v":57},{"$f":"IF('2.0.1'!C446=\"\",\"\",'2.0.1'!C446)","v":"Has your agency had any communications from regulatory agencies concerning noncompliance with, or deficiencies in, financial reporting practices?"},{"$f":"IF('2.0.1'!G446=\"\",\"\",'2.0.1'!G446)","v":"No"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A448=\"\",E190,'2.0.1'!A448)","v":57},{"$f":"IF('2.0.1'!C448=\"\",\"\",'2.0.1'!C448)","v":"Action:   Provide copies of the communications and a summary of the corrective actions when this Master Reporting Package Checklist is returned to the Comptroller General's Office.  "},{"$f":"IF('2.0.1'!G448=\"\",\"\",'2.0.1'!G448)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A451=\"\",E191,'2.0.1'!A451)","v":58},{"$f":"IF('2.0.1'!C451=\"\",\"\",'2.0.1'!C451)","v":"Has your agency had either of the following situations:"},{"$f":"IF('2.0.1'!G451=\"\",\"\",'2.0.1'!G451)","v":"No"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A459=\"\",E192,'2.0.1'!A459)","v":58},{"$f":"IF('2.0.1'!C459=\"\",\"\",'2.0.1'!C459)","v":"Action:  Provide an explanation of the violation or instance of noncompliance as an attachment to this Master Reporting Package Checklist to the Comptroller General's Office."},{"$f":"IF('2.0.1'!G459=\"\",\"\",'2.0.1'!G459)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A462=\"\",E193,'2.0.1'!A462)","v":59},{"$f":"IF('2.0.1'!C462=\"\",\"\",'2.0.1'!C462)","v":"Does your agency know or reasonably believe a site is polluted or contaminated?"},{"$f":"IF('2.0.1'!G462=\"\",\"\",'2.0.1'!G462)","v":"No"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A464=\"\",E194,'2.0.1'!A464)","v":59},{"$f":"IF('2.0.1'!C464=\"\",\"\",'2.0.1'!C464)","v":"a. Has your agency been compelled to take remediation action because pollution creates an imminent endangerment to public health or welfare or the environment?"},{"$f":"IF('2.0.1'!G464=\"\",\"\",'2.0.1'!G464)","v":"No"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A466=\"\",E195,'2.0.1'!A466)","v":59},{"$f":"IF('2.0.1'!C466=\"\",\"\",'2.0.1'!C466)","v":"Action:  Please create and attach a list of the events identified, including a brief description of the potential obligation and the status of assessment of the event when this Master Reporting Package Checklist is returned to the Comptroller General's Office."},{"$f":"IF('2.0.1'!G466=\"\",\"\",'2.0.1'!G466)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A468=\"\",E196,'2.0.1'!A468)","v":59},{"$f":"IF('2.0.1'!C468=\"\",\"\",'2.0.1'!C468)","v":"b. Has your agency violated a pollution prevention-related permit or license? "},{"$f":"IF('2.0.1'!G468=\"\",\"\",'2.0.1'!G468)","v":"No"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A470=\"\",E197,'2.0.1'!A470)","v":59},{"$f":"IF('2.0.1'!C470=\"\",\"\",'2.0.1'!C470)","v":"Action:  Please create and attach a list of the events identified, including a brief description of the potential obligation and the status of assessment of the event when this Master Reporting Package Checklist is returned to the Comptroller General's Office."},{"$f":"IF('2.0.1'!G470=\"\",\"\",'2.0.1'!G470)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A472=\"\",E198,'2.0.1'!A472)","v":59},{"$f":"IF('2.0.1'!C472=\"\",\"\",'2.0.1'!C472)","v":"c. Has your agency been named, or does evidence indicate that your agency will be named, by a regulator as a responsible party or potentially responsible party for remediation, or as a government responsible for sharing costs?"},{"$f":"IF('2.0.1'!G472=\"\",\"\",'2.0.1'!G472)","v":"No"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A474=\"\",E199,'2.0.1'!A474)","v":59},{"$f":"IF('2.0.1'!C474=\"\",\"\",'2.0.1'!C474)","v":"Action:  Please create and attach a list of the events identified, including a brief description of the potential obligation and the status of assessment of the event when this Master Reporting Package Checklist is returned to the Comptroller General's Office."},{"$f":"IF('2.0.1'!G474=\"\",\"\",'2.0.1'!G474)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A476=\"\",E200,'2.0.1'!A476)","v":59},{"$f":"IF('2.0.1'!C476=\"\",\"\",'2.0.1'!C476)","v":"d. Has your agency been named, or does evidence indicate that your agency will be named, in a lawsuit to compel participation in remediation?"},{"$f":"IF('2.0.1'!G476=\"\",\"\",'2.0.1'!G476)","v":"No"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A478=\"\",E201,'2.0.1'!A478)","v":59},{"$f":"IF('2.0.1'!C478=\"\",\"\",'2.0.1'!C478)","v":"Action:  Please create and attach a list of the events identified, including a brief description of the potential obligation and the status of assessment of the event when this Master Reporting Package Checklist is returned to the Comptroller General's Office."},{"$f":"IF('2.0.1'!G478=\"\",\"\",'2.0.1'!G478)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A480=\"\",E202,'2.0.1'!A480)","v":59},{"$f":"IF('2.0.1'!C480=\"\",\"\",'2.0.1'!C480)","v":"e. Has your agency commenced, or legally obligated itself to commence, cleanup activities, monitoring, or maintenance and operation of the remediation effort?"},{"$f":"IF('2.0.1'!G480=\"\",\"\",'2.0.1'!G480)","v":"No"}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"IF('2.0.1'!A482=\"\",E203,'2.0.1'!A482)","v":59},{"$f":"IF('2.0.1'!C482=\"\",\"\",'2.0.1'!C482)","v":"Action:  Please create and attach a list of the events identified, including a brief description of the potential obligation and the status of assessment of the event when this Master Reporting Package Checklist is returned to the Comptroller General's Office."},{"$f":"IF('2.0.1'!G482=\"\",\"\",'2.0.1'!G482)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.01.a","I5",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.01.b","I6",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.01.c","I7",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.01.d","I8",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.01.e","I9",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.01.f","I10",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.01.g","I11",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.01.h","I12",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.01.i","I13",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.02.a","K5",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.02.b","K6",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.02.c","K7",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.02.d","K8",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.02.e","K9",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.02.f","K10",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.02.g","K11",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.02.h","K12",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.02.i","K13",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.03.a","M5",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.03.b","M6",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.03.c","M7",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.03.d","M8",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.03.e","M9",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.03.f","M10",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.03.g","M11",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.03.h","M12",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.03.i","M13",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.04.a","O5",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.04.b","O6",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.04.c","O7",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.04.d","O8",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.04.e","O9",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.04.f","O10",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.04.g","O11",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.04.h","O12",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.04.i","O13",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.05.a","Q5",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.05.b","Q6",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.05.c","Q7",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.05.d","Q8",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.05.e","Q9",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.05.f","Q10",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.05.g","Q11",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.05.h","Q12",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.05.i","Q13",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.06.a","S5",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.06.b","S6",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.06.c","S7",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.06.d","S8",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.06.e","S9",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.06.f","S10",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.06.g","S11",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.06.h","S12",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.06.i","S13",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.07.a","U5",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.07.b","U6",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.07.c","U7",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.07.d","U8",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.07.e","U9",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.07.f","U10",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.07.g","U11",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.07.h","U12",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.07.i","U13",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1",{"$f":"AgencyCode","v":"E120"},{"$f":"AgencyName","v":"COMPTROLLER GENERAL'S OFFICE\n"},{"$f":"Year","v":2021},"37.08.a","W5",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.08.b","W6",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.08.c","W7",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.08.d","W8",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.08.e","W9",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.08.f","W10",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.08.g","W11",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.08.h","W12",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.08.i","W13",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.09.a","Y5",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.09.b","Y6",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.09.c","Y7",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.09.d","Y8",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.09.e","Y9",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.09.f","Y10",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.09.g","Y11",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.09.h","Y12",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.09.i","Y13",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.10.a","AA5",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.10.b","AA6",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.10.c","AA7",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.10.d","AA8",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.10.e","AA9",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.10.f","AA10",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.10.g","AA11",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.10.h","AA12",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"37.10.i","AA13",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"42.01.a","G6",{"$f":"IF('42. (Cont)'!G6=\"\",\"\",'42. (Cont)'!G6)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"42.01.a","G7",{"$f":"IF('42. (Cont)'!G7=\"\",\"\",'42. (Cont)'!G7)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"42.01.b","G12",{"$f":"IF('42. (Cont)'!G12=\"\",\"\",'42. (Cont)'!G12)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"42.01.b","G13",{"$f":"IF('42. (Cont)'!G13=\"\",\"\",'42. (Cont)'!G13)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"42.02.a","I6",{"$f":"IF('42. (Cont)'!I6=\"\",\"\",'42. (Cont)'!I6)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"42.02.a","I7",{"$f":"IF('42. (Cont)'!I7=\"\",\"\",'42. (Cont)'!I7)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"42.02.b","I12",{"$f":"IF('42. (Cont)'!I12=\"\",\"\",'42. (Cont)'!I12)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"42.02.b","I13",{"$f":"IF('42. (Cont)'!I13=\"\",\"\",'42. (Cont)'!I13)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"42.03.a","K6",{"$f":"IF('42. (Cont)'!K6=\"\",\"\",'42. (Cont)'!K6)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"42.03.a","K7",{"$f":"IF('42. (Cont)'!K7=\"\",\"\",'42. (Cont)'!K7)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"42.03.b","K12",{"$f":"IF('42. (Cont)'!K12=\"\",\"\",'42. (Cont)'!K12)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"42.03.b","K13",{"$f":"IF('42. (Cont)'!K13=\"\",\"\",'42. (Cont)'!K13)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"42.04.a","M6",{"$f":"IF('42. (Cont)'!M6=\"\",\"\",'42. (Cont)'!M6)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"42.04.a","M7",{"$f":"IF('42. (Cont)'!M7=\"\",\"\",'42. (Cont)'!M7)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"42.04.b","M12",{"$f":"IF('42. (Cont)'!M12=\"\",\"\",'42. (Cont)'!M12)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"42.04.b","M13",{"$f":"IF('42. (Cont)'!M13=\"\",\"\",'42. (Cont)'!M13)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"42.05.a","O6",{"$f":"IF('42. (Cont)'!O6=\"\",\"\",'42. (Cont)'!O6)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"42.05.a","O7",{"$f":"IF('42. (Cont)'!O7=\"\",\"\",'42. (Cont)'!O7)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"42.05.b","O12",{"$f":"IF('42. (Cont)'!O12=\"\",\"\",'42. (Cont)'!O12)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"42.05.b","O13",{"$f":"IF('42. (Cont)'!O13=\"\",\"\",'42. (Cont)'!O13)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"42.06.a","Q6",{"$f":"IF('42. (Cont)'!Q6=\"\",\"\",'42. (Cont)'!Q6)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"42.06.a","Q7",{"$f":"IF('42. (Cont)'!Q7=\"\",\"\",'42. (Cont)'!Q7)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"42.06.b","Q12",{"$f":"IF('42. (Cont)'!Q12=\"\",\"\",'42. (Cont)'!Q12)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"42.06.b","Q13",{"$f":"IF('42. (Cont)'!Q13=\"\",\"\",'42. (Cont)'!Q13)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"42.07.a","S6",{"$f":"IF('42. (Cont)'!S6=\"\",\"\",'42. (Cont)'!S6)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"42.07.a","S7",{"$f":"IF('42. (Cont)'!S7=\"\",\"\",'42. (Cont)'!S7)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"42.07.b","S12",{"$f":"IF('42. (Cont)'!S12=\"\",\"\",'42. (Cont)'!S12)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"42.07.b","S13",{"$f":"IF('42. (Cont)'!S13=\"\",\"\",'42. (Cont)'!S13)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"42.08.a","U6",{"$f":"IF('42. (Cont)'!U6=\"\",\"\",'42. (Cont)'!U6)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"42.08.a","U7",{"$f":"IF('42. (Cont)'!U7=\"\",\"\",'42. (Cont)'!U7)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"42.08.b","U12",{"$f":"IF('42. (Cont)'!U12=\"\",\"\",'42. (Cont)'!U12)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"42.08.b","U13",{"$f":"IF('42. (Cont)'!U13=\"\",\"\",'42. (Cont)'!U13)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"42.09.a","W6",{"$f":"IF('42. (Cont)'!W6=\"\",\"\",'42. (Cont)'!W6)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"42.09.a","W7",{"$f":"IF('42. (Cont)'!W7=\"\",\"\",'42. (Cont)'!W7)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"42.09.b","W12",{"$f":"IF('42. (Cont)'!W12=\"\",\"\",'42. (Cont)'!W12)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"42.09.b","W13",{"$f":"IF('42. (Cont)'!W13=\"\",\"\",'42. (Cont)'!W13)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"42.10.a","Y6",{"$f":"IF('42. (Cont)'!Y6=\"\",\"\",'42. (Cont)'!Y6)","v":""}]
["2.0.1",{"$f":"AgencyCode","v":"E120"},{"$f":"AgencyName","v":"COMPTROLLER GENERAL'S OFFICE\n"},{"$f":"Year","v":2021},"42.10.a","Y7",{"$f":"IF('42. (Cont)'!Y7=\"\",\"\",'42. (Cont)'!Y7)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"42.10.b","Y12",{"$f":"IF('42. (Cont)'!Y12=\"\",\"\",'42. (Cont)'!Y12)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"42.10.b","Y13",{"$f":"IF('42. (Cont)'!Y13=\"\",\"\",'42. (Cont)'!Y13)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"44.01.a","G5",{"$f":"IF('44. (Cont)'!G5=\"\",\"\",'44. (Cont)'!G5)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"44.01.b","I5",{"$f":"IF('44. (Cont)'!I5=\"\",\"\",'44. (Cont)'!I5)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"44.01.c","G7",{"$f":"IF('44. (Cont)'!G7=\"\",\"\",'44. (Cont)'!G7)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"44.01.d","I7",{"$f":"IF('44. (Cont)'!I7=\"\",\"\",'44. (Cont)'!I7)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"44.02.a","K5",{"$f":"IF('44. (Cont)'!K5=\"\",\"\",'44. (Cont)'!K5)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"44.02.b","M5",{"$f":"IF('44. (Cont)'!M5=\"\",\"\",'44. (Cont)'!M5)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"44.02.c","K7",{"$f":"IF('44. (Cont)'!K7=\"\",\"\",'44. (Cont)'!K7)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"44.02.d","M7",{"$f":"IF('44. (Cont)'!M7=\"\",\"\",'44. (Cont)'!M7)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"44.03.a","O5",{"$f":"IF('44. (Cont)'!O5=\"\",\"\",'44. (Cont)'!O5)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"44.03.b","Q5",{"$f":"IF('44. (Cont)'!Q5=\"\",\"\",'44. (Cont)'!Q5)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"44.03.c","O7",{"$f":"IF('44. (Cont)'!O7=\"\",\"\",'44. (Cont)'!O7)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"44.03.d","Q7",{"$f":"IF('44. (Cont)'!Q7=\"\",\"\",'44. (Cont)'!Q7)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"44.04.a","S5",{"$f":"IF('44. (Cont)'!S5=\"\",\"\",'44. (Cont)'!S5)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"44.04.b","U5",{"$f":"IF('44. (Cont)'!U5=\"\",\"\",'44. (Cont)'!U5)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"44.04.c","S7",{"$f":"IF('44. (Cont)'!S7=\"\",\"\",'44. (Cont)'!S7)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"44.04.d","U7",{"$f":"IF('44. (Cont)'!U7=\"\",\"\",'44. (Cont)'!U7)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"44.05.a","W5",{"$f":"IF('44. (Cont)'!W5=\"\",\"\",'44. (Cont)'!W5)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"44.05.b","Y5",{"$f":"IF('44. (Cont)'!Y5=\"\",\"\",'44. (Cont)'!Y5)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"44.05.c","W7",{"$f":"IF('44. (Cont)'!W7=\"\",\"\",'44. (Cont)'!W7)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"44.05.d","Y7",{"$f":"IF('44. (Cont)'!Y7=\"\",\"\",'44. (Cont)'!Y7)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"44.06.a","AA5",{"$f":"IF('44. (Cont)'!AA5=\"\",\"\",'44. (Cont)'!AA5)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"44.06.b","AC5",{"$f":"IF('44. (Cont)'!AC5=\"\",\"\",'44. (Cont)'!AC5)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"44.06.c","AA7",{"$f":"IF('44. (Cont)'!AA7=\"\",\"\",'44. (Cont)'!AA7)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"44.06.d","AC7",{"$f":"IF('44. (Cont)'!AC7=\"\",\"\",'44. (Cont)'!AC7)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"44.07.a","AE5",{"$f":"IF('44. (Cont)'!AE5=\"\",\"\",'44. (Cont)'!AE5)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"44.07.b","AG5",{"$f":"IF('44. (Cont)'!AG5=\"\",\"\",'44. (Cont)'!AG5)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"44.07.c","AE7",{"$f":"IF('44. (Cont)'!AE7=\"\",\"\",'44. (Cont)'!AE7)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"44.07.d","AG7",{"$f":"IF('44. (Cont)'!AG7=\"\",\"\",'44. (Cont)'!AG7)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"44.08.a","AI5",{"$f":"IF('44. (Cont)'!AI5=\"\",\"\",'44. (Cont)'!AI5)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"44.08.b","AK5",{"$f":"IF('44. (Cont)'!AK5=\"\",\"\",'44. (Cont)'!AK5)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"44.08.c","AI7",{"$f":"IF('44. (Cont)'!AI7=\"\",\"\",'44. (Cont)'!AI7)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"44.08.d","AK7",{"$f":"IF('44. (Cont)'!AK7=\"\",\"\",'44. (Cont)'!AK7)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"44.09.a","AM5",{"$f":"IF('44. (Cont)'!AM5=\"\",\"\",'44. (Cont)'!AM5)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"44.09.b","AO5",{"$f":"IF('44. (Cont)'!AO5=\"\",\"\",'44. (Cont)'!AO5)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"44.09.c","AM7",{"$f":"IF('44. (Cont)'!AM7=\"\",\"\",'44. (Cont)'!AM7)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"44.09.d","AO7",{"$f":"IF('44. (Cont)'!AO7=\"\",\"\",'44. (Cont)'!AO7)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"44.10.a","AQ5",{"$f":"IF('44. (Cont)'!AQ5=\"\",\"\",'44. (Cont)'!AQ5)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"44.10.b","AS5",{"$f":"IF('44. (Cont)'!AS5=\"\",\"\",'44. (Cont)'!AS5)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"44.10.c","AQ7",{"$f":"IF('44. (Cont)'!AQ7=\"\",\"\",'44. (Cont)'!AQ7)","v":""}]
["2.0.1","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"44.10.d","AS7",{"$f":"IF('44. (Cont)'!AS7=\"\",\"\",'44. (Cont)'!AS7)","v":""}]
["Signature Page","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"Prepared Date","E10",{"$f":"IF('Signature Page'!E10=\"\",\"\",'Signature Page'!E10)","v":44385}]
["Signature Page","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"Preparer's Name","E11",{"$f":"IF('Signature Page'!E11=\"\",\"\",'Signature Page'!E11)","v":"Agency Preparer"}]
["Signature Page","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"Preparer's Title","E12",{"$f":"IF('Signature Page'!E12=\"\",\"\",'Signature Page'!E12)","v":"Fiscal Manager"}]
["Signature Page","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"Preparer's e-Mail","E13",{"$f":"IF('Signature Page'!E13=\"\",\"\",'Signature Page'!E13)","v":"agencypreparer@agency.gov"}]
["Signature Page","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"Preparer's Phone","E14",{"$f":"IF('Signature Page'!E14=\"\",\"\",'Signature Page'!E14)","v":"803 123-4567"}]
["Signature Page","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"Reviewed Date","E17",{"$f":"IF('Signature Page'!E17=\"\",\"\",'Signature Page'!E17)","v":44386}]
["Signature Page","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"Reviewer's Name","E18",{"$f":"IF('Signature Page'!E19=\"\",\"\",'Signature Page'!E19)","v":"Agency Reviewer"}]
["Signature Page","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"Reviewer's Title","E19",{"$f":"IF('Signature Page'!E20=\"\",\"\",'Signature Page'!E20)","v":"Director of Finance"}]
["Signature Page","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"Reviewer's e-Mail","E20",{"$f":"IF('Signature Page'!E21=\"\",\"\",'Signature Page'!E21)","v":"agencyreviewer@agency.gov"}]
["Signature Page","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"Reviewer's Phone","E21",{"$f":"IF('Signature Page'!E22=\"\",\"\",'Signature Page'!E22)","v":"803 123-4567"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.01 Cash and Investments Reporting Package","E10",{"$f":"IF('Required Packages'!D12=\"Not Required\",\"\",\"Required\")","v":"Required"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.02 Tax Revenue Reporting Package","E14",{"$f":"IF('Required Packages'!D16=\"Not Required\",\"\",\"Required\")","v":"Required"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.03 Grants and Contribution Revenue Reporting Package","E18",{"$f":"IF('Required Packages'!D20=\"Not Required\",\"\",\"Required\")","v":"Required"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.04 Miscellaneous Revenues Reporting Package","E22",{"$f":"IF('Required Packages'!D24=\"Not Required\",\"\",\"Required\")","v":"Required"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.05 Unearned Revenue Reporting Package","E24",{"$f":"IF('Required Packages'!D26=\"Not Required\",\"\",\"Required\")","v":"Required"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.06 Inventory Reporting Package","E26",{"$f":"IF('Required Packages'!D28=\"Not Required\",\"\",\"Required\")","v":"Required"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.07 Prepaid Expenses Reporting Package","E28",{"$f":"IF('Required Packages'!D30=\"Not Required\",\"\",\"Required\")","v":"Required"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.08 Capital Assets Reporting Package","E30",{"$f":"IF('Required Packages'!D32=\"Not Required\",\"\",\"Required\")","v":"Required"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.09 Operating Lease Reporting Package","E36",{"$f":"IF('Required Packages'!D38=\"Not Required\",\"\",\"Required\")","v":"Required"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.10 Loans Receivable Reporting Package","E40",{"$f":"IF('Required Packages'!D42=\"Not Required\",\"\",\"Required\")","v":"Required"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.12 Accounts Payable Reporting Package","E43",{"$f":"IF('Required Packages'!D45=\"Not Required\",\"\",\"Required\")","v":"Required"}]
["Required Packages",{"$f":"AgencyCode","v":"E120"},{"$f":"AgencyName","v":"COMPTROLLER GENERAL'S OFFICE\n"},{"$f":"Year","v":2021},"3.13 Litigation Reporting Package","E46",{"$f":"IF('Required Packages'!D47=\"Not Required\",\"\",\"Required\")","v":"Required"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.14 Disallowances and Penalties Reporting Package","E50",{"$f":"IF('Required Packages'!D52=\"Not Required\",\"\",\"Required\")","v":"Required"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.15 Claims Reporting Package","E52",{"$f":"IF('Required Packages'!D54=\"Not Required\",\"\",\"Required\")","v":"Required"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.16 Miscellaneous Loss Liabilities, Loss Contingencies, and Commitments Reporting Package","E55",{"$f":"IF('Required Packages'!D57=\"Not Required\",\"\",\"Required\")","v":"Required"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.18 Interfund Payables Reporting Package","E62",{"$f":"IF('Required Packages'!D62=\"Not Required\",\"\",\"Required\")","v":"Required"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.20 Fund Balance and Net Position (Net Asset) Reporting Package","E66",{"$f":"IF('Required Packages'!D66=\"Not Required\",\"\",\"Required\")","v":"Required"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"7 A schedule of the total amount, by fund, passed through to non-State entities (as a cash conduit) is to be returned to the Comptroller General's Office before September 12.  ","E73",{"$f":"IF('Required Packages'!D74=\"Not Required\",\"\",\"Required\")","v":""}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"15 Provide a description of the transaction (include the counter party of the transaction and any responsibilities for servicing retained by the agency) in an attachment to this Reporting Package Checklist to the Comptroller General's Office.","E75",{"$f":"IF('Required Packages'!D76=\"Not Required\",\"\",\"Required\")","v":""}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"'Required Packages'!#REF!&\" \"&'Required Packages'!#REF!","v":{"$error":"#REF!"}},"E76",{"$f":"IF('Required Packages'!#REF!=\"Not Required\",\"\",\"Required\")","v":{"$error":"#REF!"}}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"'Required Packages'!A78&\" \"&'Required Packages'!C78","v":"27.a.i FALSE"},"E78",{"$f":"IF('Required Packages'!D78=\"Not Required\",\"\",\"Required\")","v":""}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"'Required Packages'!A80&\" \"&'Required Packages'!C80","v":"45 Describe the situation in a letter or other attachment when you return this Reporting Package Control Checklist to the Comptroller General's Office.  Please provide copies of signed agreements for any new loans."},"E80",{"$f":"IF('Required Packages'!D80=\"Not Required\",\"\",\"Required\")","v":"Required"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"'Required Packages'!A82&\" \"&'Required Packages'!C82","v":"46 Describe the situation in a letter or other attachment when you return this Reporting Package Control Checklist to the Comptroller General's Office.  Please provide details of your understanding with the other agency."},"E82",{"$f":"IF('Required Packages'!D82=\"Not Required\",\"\",\"Required\")","v":"Required"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"'Required Packages'!A84&\" \"&'Required Packages'!C84","v":"47 Describe the situation in a letter or other attachment when you return this Reporting Package Control Checklist to the Comptroller General's Office. Please provide details of the plans for return of resources (repayment) between the funds within your agency."},"E84",{"$f":"IF('Required Packages'!D84=\"Not Required\",\"\",\"Required\")","v":"Required"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"'Required Packages'!A86&\" \"&'Required Packages'!C86","v":"49 Provide a listing including Lease ID #(s), amount(s), and payment date(s) as an attachment when you return this Reporting Package Checklist to the Comptroller General's Office."},"E86",{"$f":"IF('Required Packages'!D86=\"Not Required\",\"\",\"Required\")","v":"Required"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"'Required Packages'!A88&\" \"&'Required Packages'!C88","v":"51 Provide a listing including Name of Lendor, identification of asset purchased, whether collateral secures the note, current year activity (including beginning balance, advances, repayments, and ending balance), and future payments (amount(s) and payment date(s)) as an attachment when you return this Reporting Package Checklist to the Comptroller General's Office."},"E88",{"$f":"IF('Required Packages'!D88=\"Not Required\",\"\",\"Required\")","v":""}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"'Required Packages'!A90&\" \"&'Required Packages'!C90","v":"52 Describe the situation in a letter or other attachment to this Reporting Package Checklist to the Comptroller General's Office.  Include authorization, Lendor, Amount of Note, Date of Note, Collateral, Terms of repayment, and Balance as of year-end."},"E90",{"$f":"IF('Required Packages'!D90=\"Not Required\",\"\",\"Required\")","v":""}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"'Required Packages'!A72&\" \"&'Required Packages'!C72","v":"9 Provide a schedule of the amounts paid as related to each tax source, detailed by accounting fund, general ledger (or object code), gross of related processing costs, with amounts paid to outside collection agencies as processing costs.  Submit the detailed schedule with the Tax Revenue Reporting Package."},"E92",{"$f":"IF('Required Packages'!D72=\"Not Required\",\"\",\"Required\")","v":""}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"'Required Packages'!A92&\" \"&'Required Packages'!C92","v":"53 Describe the situation in a letter or other attachment when you return this Reporting Package Checklist to the Comptroller General's Office.  Be sure to fully describe the activity and whether you self-insure the activity, purchase insurance to cover the activity, or provide insurance coverage to other entities for this activity.  Also, please include the name and phone number of a person within your agency that we may contact to obtain additional information,  if necessary."},"E94",{"$f":"IF('Required Packages'!D92=\"Not Required\",\"\",\"Required\")","v":""}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"'Required Packages'!A94&\" \"&'Required Packages'!C94","v":"54 Describe the situation in a letter or other attachment (include specifics of the service agreement, the volume of transactions processed, the dollar amount of transactions processed, and procedures performed by the agency to ensure appropriate controls are in place for accuracy in recognition and reporting) when you return this Reporting Package Checklist to the Comptroller General's Office."},"E96",{"$f":"IF('Required Packages'!D94=\"Not Required\",\"\",\"Required\")","v":""}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"'Required Packages'!A96&\" \"&'Required Packages'!C96","v":"55 Describe the situation on agency letterhead signed by the Agency Director or designee when this Reporting Package Checklist is returned to the Comptroller General's Office.  Be sure to fully describe the activity, the amount (or approximate amount) of the fraud or suspected fraud, and the resulting actions by management to prevent further fraudulent activities."},"E98",{"$f":"IF('Required Packages'!D96=\"Not Required\",\"\",\"Required\")","v":"Required"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"'Required Packages'!A98&\" \"&'Required Packages'!C98","v":"56 Describe the situation on agency letterhead signed by the Agency Director or designee when this Reporting Package Checklist is returned to the Comptroller General's Office.  Be sure to fully describe the allegation(s) and any actions taken by management to strengthen the internal controls that may have been breached if the allegations prove true."},"E100",{"$f":"IF('Required Packages'!D98=\"Not Required\",\"\",\"Required\")","v":""}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"'Required Packages'!A100&\" \"&'Required Packages'!C100","v":"57 Provide copies of the communications and a summary of the corrective actions when this Reporting Package Checklist is returned to the Comptroller General's Office.  "},"E102",{"$f":"IF('Required Packages'!D100=\"Not Required\",\"\",\"Required\")","v":""}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"'Required Packages'!A102&\" \"&'Required Packages'!C102","v":"58 Provide an explanation of the violation or instance of noncompliance as an attachment to this Reporting Package Checklist to the Comptroller General's Office."},"E104",{"$f":"IF('Required Packages'!D102=\"Not Required\",\"\",\"Required\")","v":""}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"'Required Packages'!A104&\" \"&'Required Packages'!C104","v":"59.a Please create and attach a list of the events identified, including a brief description of the potential obligation and the status of assessment of the event when this Reporting Package Checklist is returned to the Comptroller General's Office."},"E106",{"$f":"IF('Required Packages'!D104=\"Not Required\",\"\",\"Required\")","v":""}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"'Required Packages'!A106&\" \"&'Required Packages'!C106","v":"59.b Please create and attach a list of the events identified, including a brief description of the potential obligation and the status of assessment of the event when this Reporting Package Checklist is returned to the Comptroller General's Office."},"E108",{"$f":"IF('Required Packages'!D106=\"Not Required\",\"\",\"Required\")","v":""}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"'Required Packages'!A108&\" \"&'Required Packages'!C108","v":"59.c Please create and attach a list of the events identified, including a brief description of the potential obligation and the status of assessment of the event when this Reporting Package Checklist is returned to the Comptroller General's Office."},"E110",{"$f":"IF('Required Packages'!D108=\"Not Required\",\"\",\"Required\")","v":""}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"'Required Packages'!A110&\" \"&'Required Packages'!C110","v":"59.d Please create and attach a list of the events identified, including a brief description of the potential obligation and the status of assessment of the event when this Reporting Package Checklist is returned to the Comptroller General's Office."},"E112",{"$f":"IF('Required Packages'!D110=\"Not Required\",\"\",\"Required\")","v":""}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,{"$f":"'Required Packages'!A112&\" \"&'Required Packages'!C112","v":"59.e Please create and attach a list of the events identified, including a brief description of the potential obligation and the status of assessment of the event when this Reporting Package Checklist is returned to the Comptroller General's Office."},"E114",{"$f":"IF('Required Packages'!D112=\"Not Required\",\"\",\"Required\")","v":""}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.01.1 Petty Cash","F11",{"$f":"IF('Required Packages'!E13=\"\",\"\",'Required Packages'!E13)","v":"Yes"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.01.2 Agency Cash","F12",{"$f":"IF('Required Packages'!E14=\"\",\"\",'Required Packages'!E14)","v":"Yes"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.01.3 Investments","F13",{"$f":"IF('Required Packages'!E15=\"\",\"\",'Required Packages'!E15)","v":"Yes"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.02.1 Tax Receivable","F15",{"$f":"IF('Required Packages'!E17=\"\",\"\",'Required Packages'!E17)","v":"Yes"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.02.2 Tax Refund Payable","F16",{"$f":"IF('Required Packages'!E18=\"\",\"\",'Required Packages'!E18)","v":"Yes"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.02.3 Deferred Tax Revenues","F17",{"$f":"IF('Required Packages'!E19=\"\",\"\",'Required Packages'!E19)","v":"Yes"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.03.1 Grants Activity Form","F19",{"$f":"IF('Required Packages'!E21=\"\",\"\",'Required Packages'!E21)","v":"No"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.03.2 Grants Receivable and Deferred Revenue Summary Form","F20",{"$f":"IF('Required Packages'!E22=\"\",\"\",'Required Packages'!E22)","v":"Yes"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.03.3 Contributions Receivable and Deferred Revenue Summary Form","F21",{"$f":"IF('Required Packages'!E23=\"\",\"\",'Required Packages'!E23)","v":"Yes"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.04.1 Accounts Receivable Summary Form","F23",{"$f":"IF('Required Packages'!E25=\"\",\"\",'Required Packages'!E25)","v":"Yes"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.05.1 Unearned Revenue Summary Form","F25",{"$f":"IF('Required Packages'!E27=\"\",\"\",'Required Packages'!E27)","v":"Yes"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.06.1 Inventory Summary Form","F27",{"$f":"IF('Required Packages'!E29=\"\",\"\",'Required Packages'!E29)","v":"Yes"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.07.1 Prepaid Expenses Analysis","F29",{"$f":"IF('Required Packages'!E31=\"\",\"\",'Required Packages'!E31)","v":"Yes"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.08.1 Capital Asset Questionnaire","F31",{"$f":"IF('Required Packages'!E33=\"\",\"\",'Required Packages'!E33)","v":"Yes"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.08.2 Reporting of Adjustments and Errors Identified in SCEIS Asset History","F32",{"$f":"IF('Required Packages'!E34=\"\",\"\",'Required Packages'!E34)","v":"Based on 3.08.1"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.08.3 Non-SCEIS Agencies Only - Capital Asset Summary Form","F33",{"$f":"IF('Required Packages'!E35=\"\",\"\",'Required Packages'!E35)","v":"Based on 3.08.1"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.08.4 Capital Asset Intra-State Transfers Summary Form","F34",{"$f":"IF('Required Packages'!E36=\"\",\"\",'Required Packages'!E36)","v":"Based on 3.08.1"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.08.5 Asset History Reconciliation To GL Activity","F35",{"$f":"IF('Required Packages'!E37=\"\",\"\",'Required Packages'!E37)","v":"Based on 3.08.1"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.09.1 Operating Lease Summary Form - Leasee","F37",{"$f":"IF('Required Packages'!E39=\"\",\"\",'Required Packages'!E39)","v":"Yes"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.09.1.a Operating Lease Future Minimum Payment Schedule","F38",{"$f":"IF('Required Packages'!E40=\"\",\"\",'Required Packages'!E40)","v":"Based on 3.09.1"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.09.2 Operating Lease Summary Form - Leasor","F39",{"$f":"IF('Required Packages'!E41=\"\",\"\",'Required Packages'!E41)","v":"Based on 3.09.1"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.10.1 Loans Receivable Summary Form","F41",{"$f":"IF('Required Packages'!E43=\"\",\"\",'Required Packages'!E43)","v":"Yes"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.12.1 Accounts Payable Summary Form","F44",{"$f":"IF('Required Packages'!E46=\"\",\"\",'Required Packages'!E46)","v":"Yes"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.13.1 Litigation Related Expense Explanation Form","F46",{"$f":"IF('Required Packages'!E48=\"\",\"\",'Required Packages'!E48)","v":"Yes"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.13.2 Litigation Overview Form","F47",{"$f":"IF('Required Packages'!E49=\"\",\"\",'Required Packages'!E49)","v":"Yes"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.13.3 Settled Litigation Report Form","F48",{"$f":"IF('Required Packages'!E50=\"\",\"\",'Required Packages'!E50)","v":"Based on 3.13.1"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.13.4 Litigation Contingency Report Form","F49",{"$f":"IF('Required Packages'!E51=\"\",\"\",'Required Packages'!E51)","v":"Based on 3.13.1"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.14.1 Grant Disallowance Reporting Form","F51",{"$f":"IF('Required Packages'!E53=\"\",\"\",'Required Packages'!E53)","v":"Yes"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.15.1 Claims Summary Form","F53",{"$f":"IF('Required Packages'!E55=\"\",\"\",'Required Packages'!E55)","v":"Yes"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.15.2 Additional Claims Information Form","F54",{"$f":"IF('Required Packages'!E56=\"\",\"\",'Required Packages'!E56)","v":"Yes"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.16.1 Miscellaneous Loss Liabilities Report Form","F56",{"$f":"IF('Required Packages'!E58=\"\",\"\",'Required Packages'!E58)","v":"Yes"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.16.2 Miscellaneous Loss Contingency Report Form","F57",{"$f":"IF('Required Packages'!E59=\"\",\"\",'Required Packages'!E59)","v":"Yes"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.16.3 Significant Miscellaneous Commitments Form","F58",{"$f":"IF('Required Packages'!E60=\"\",\"\",'Required Packages'!E60)","v":"Yes"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.18.1 Interfund Payable Summary Form","F63",{"$f":"IF('Required Packages'!E63=\"\",\"\",'Required Packages'!E63)","v":"Yes"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.18.2 Interfund Receivables Summary Form","F64",{"$f":"IF('Required Packages'!E64=\"\",\"\",'Required Packages'!E64)","v":"Yes"}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.20.1 Fund Balance And Net Asset Summary Form","F67",{"$f":"IF('Required Packages'!E67=\"\",\"\",'Required Packages'!E67)","v":""}]
["Required Packages","E120","COMPTROLLER GENERAL'S OFFICE\n",2021,"3.20.2 Fund Use And Reporting Fund Types Form","F68",{"$f":"IF('Required Packages'!E68=\"\",\"\",'Required Packages'!E68)","v":""}]

{"sheet":"42. (Cont)","index":7,"n_rows":17,"n_cols":25,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[]
["42. (Cont)"]
[]
[null,"a.",null,null,null,null,"Escrow Account 1",null,"Escrow Account 2",null,"Escrow Account 3",null,"Escrow Account 4",null,"Escrow Account 5",null,"Escrow Account 6",null,"Escrow Account 7",null,"Escrow Account 8",null,"Escrow Account 9",null,"Escrow Account 10"]
[]
[null,null,"Lease ID #"]
[null,null,"Amount held in escrow"]
[]
[]
[null,null,null,null,null,null,"Escrow Account 1",null,"Escrow Account 2",null,"Escrow Account 3",null,"Escrow Account 4",null,"Escrow Account 5",null,"Escrow Account 6",null,"Escrow Account 7",null,"Escrow Account 8",null,"Escrow Account 9",null,"Escrow Account 10"]
[]
[null,"b.","Lease ID #(s)"]
[null,null,"Date the escrow account was closed"]
[]
[]
[]
[null,null,"Note:  Space for ten additional open and closed escrow accounts have been provided.  If you need additional space, please contact the CG's Office."]

{"sheet":"44. (Cont)","index":8,"n_rows":11,"n_cols":45,"rows_kept":11,"cut":false,"hidden":true,"merged":[[2,30,2,32],[2,34,2,36],[2,38,2,40],[2,42,2,44],[2,6,2,8],[2,10,2,12],[2,14,2,16],[2,18,2,20],[2,22,2,24],[2,26,2,28]]}
[]
["44. (Cont)"]
[null,null,null,null,null,null,"Additional Agreement 1",null,null,null,"Additional Agreement 2",null,null,null,"Additional Agreement 3",null,null,null,"Additional Agreement 4",null,null,null,"Additional Agreement 5",null,null,null,"Additional Agreement 6",null,null,null,"Additional Agreement 7",null,null,null,"Additional Agreement 8",null,null,null,"Additional Agreement 9",null,null,null,"Additional Agreement 10"]
[null,"Action:  Provide the following information "]
[null,null,"Principle amount"]
[null,null,null,null,null,null,"General Ledger Account",null,"Amount",null,"General Ledger Account",null,"Amount",null,"General Ledger Account",null,"Amount",null,"General Ledger Account",null,"Amount",null,"General Ledger Account",null,"Amount",null,"General Ledger Account",null,"Amount",null,"General Ledger Account",null,"Amount",null,"General Ledger Account",null,"Amount",null,"General Ledger Account",null,"Amount",null,"General Ledger Account",null,"Amount"]
[null,null,"Interest amount"]
[null,null,null,null,null,null,"General Ledger Account",null,"Amount",null,"General Ledger Account",null,"Amount",null,"General Ledger Account",null,"Amount",null,"General Ledger Account",null,"Amount",null,"General Ledger Account",null,"Amount",null,"General Ledger Account",null,"Amount",null,"General Ledger Account",null,"Amount",null,"General Ledger Account",null,"Amount",null,"General Ledger Account",null,"Amount",null,"General Ledger Account",null,"Amount"]
[]
[]
[null,"Note:  Space for ten additional agreements have been provided.  If you need additional space, please contact the CG's Office."]