{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Yearly Data","Instructions","Signature Page","2.0.1","Required Packages","Resources","Summary","37. (Cont)","42. (Cont)","44. (Cont)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":87,"n_cols":3,"rows_kept":87,"cut":false,"hidden":true,"merged":[]}
["Year",2019]
[]
[]
["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"]
["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","DIVISION ON AGING",2019]
["L080","CHILDREN'S ADVOCACY",2019]
["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"]
["X440","AID TO SUBDIVISIONS--DEPARTMENT OF REVENUE   (Note 2)"]
["ZZZZ","EXAMPLE AGENCY"]

{"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,"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,"● E-Mail the signed Signature Page to the Comptroller General's Office no later than July 5."]
[]
[]
[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,"Comptroller General's Office no later than July 5."]
[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":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":false,"merged":[[39,1,39,5],[25,3,25,4],[27,0,27,5],[31,1,31,5],[33,1,33,5],[35,1,35,5],[37,1,37,5]]}
[null,null,"Master Reporting Checklist Signature Page"]
[]
[]
[null,null,"CAFR Reporting Period:",null,{"$f":"Year","v":2019}]
[null,null,"Agency Number:",null,"ZZZZ",{"$f":"IF(AgencyCode=\"\",\"*\",\"\")","v":""}]
[null,null,"Agency Name",null,{"$f":"IF(ISERROR(VLOOKUP(E5,'Yearly Data'!A7:B87,2,FALSE))=TRUE,\"\",VLOOKUP(E5,'Yearly Data'!A7:B87,2,FALSE))","v":"EXAMPLE AGENCY"}]
[]
[]
[]
[null,null,"Preparer","Date:","Joe Preparer",{"$f":"IF(E10=\"\",\"*\",\"\")","v":""}]
[null,null,null,"Name:","Accountant",{"$f":"IF(E11=\"\",\"*\",\"\")","v":""}]
[null,null,null,"Title:","2019-07-03",""]
[null,null,null,"e-mail:","jpreparer@example.sc.gov",""]
[null,null,null,"Phone Number:","(803) 123-4567",""]
[null,null,null,"Signature:",null,"*"]
[]
[null,null,"Reviewer","Date:","2019-07-05",{"$f":"IF(E17=\"\",\"*\",\"\")","v":""}]
[null,null,null,"Name:","Tome Reviewer",""]
[null,null,null,"Title:","Manager",""]
[null,null,null,"e-mail:","treviewer@example.sc.gov",""]
[null,null,null,"Phone Number:","(803) 765-4321",""]
[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=\"*\",F18=\"*\",F19=\"*\",F20=\"*\",F21=\"*\")=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":480,"n_cols":7,"rows_kept":480,"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]]}
[null,null,"STATE OF SOUTH CAROLINA"]
[null,null,"YEAR-END REPORTING PACKAGE "]
[null,null,"MASTER REPORTING CHECKLIST"]
[null,null,{"$f":"\"For the Fiscal Year Ended June 30, \"&Year","v":"For the Fiscal Year Ended June 30, 2019"}]
[]
[null,null,"The information in this box is linked from the Signature Page. Complete the Signature Page to populate these fields."]
["Agency:",null,{"$f":"IF(AgencyCode=\"\",\"\",AgencyCode)","v":"ZZZZ"}]
[null,null,{"$f":"IF(AgencyName=\"\",\"\",AgencyName)","v":"EXAMPLE AGENCY"}]
[]
["Preparer",null,{"$f":"IF('Signature Page'!E11=\"\",\"\",'Signature Page'!E11)","v":"Accountant"}]
["Title",null,{"$f":"IF('Signature Page'!E12=\"\",\"\",'Signature Page'!E12)","v":43649}]
["Date",null,{"$f":"IF('Signature Page'!E10=\"\",\"\",'Signature Page'!E10)","v":"Joe Preparer"}]
["email:",null,{"$f":"IF('Signature Page'!E13=\"\",\"\",'Signature Page'!E13)","v":"jpreparer@example.sc.gov"}]
["Phone:",null,{"$f":"IF('Signature Page'!E14=\"\",\"\",'Signature Page'!E14)","v":"(803) 123-4567"}]
[]
["Reviewer",null,{"$f":"IF('Signature Page'!E18=\"\",\"\",'Signature Page'!E18)","v":"Tome Reviewer"}]
["Title",null,{"$f":"IF('Signature Page'!E19=\"\",\"\",'Signature Page'!E19)","v":"Manager"}]
["Date",null,{"$f":"IF('Signature Page'!E17=\"\",\"\",'Signature Page'!E17)","v":"2019-07-05"}]
["email:",null,{"$f":"IF('Signature Page'!E20=\"\",\"\",'Signature Page'!E20)","v":"treviewer@example.sc.gov"}]
["Phone:",null,{"$f":"IF('Signature Page'!E21=\"\",\"\",'Signature Page'!E21)","v":"(803) 765-4321"}]
[]
[]
[{"$f":"IF(B23=\"y\",COUNTA(B$22:B23),\"\")","v":""}]
[{"$f":"IF(B24=\"y\",COUNTA(B$22:B24),\"\")","v":""},null,"The following questions have been established in an outline hierarchy.  A NO response to a particular question advancesto 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."]
[{"$f":"IF(B25=\"y\",COUNTA(B$22:B25),\"\")","v":""}]
[{"$f":"IF(B26=\"y\",COUNTA(B$22:B26),\"\")","v":""}]
[{"$f":"IF(B27=\"y\",COUNTA(B$22:B27),\"\")","v":1},"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(B30=\"y\",COUNTA(B$22:B30),\"\")","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(B33=\"y\",COUNTA(B$22:B33),\"\")","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(B34=\"y\",COUNTA(B$22:B34),\"\")","v":""}]
[{"$f":"IF(B35=\"y\",COUNTA(B$22:B35),\"\")","v":""}]
[{"$f":"IF(B36=\"y\",COUNTA(B$22:B36),\"\")","v":2},"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,"Yes"]
[]
[{"$f":"IF(B42=\"y\",COUNTA(B$22:B42),\"\")","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(B43=\"y\",COUNTA(B$22:B43),\"\")","v":""}]
[{"$f":"IF(B44=\"y\",COUNTA(B$22:B44),\"\")","v":""}]
[{"$f":"IF(B45=\"y\",COUNTA(B$22:B45),\"\")","v":3},"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(B46=\"y\",COUNTA(B$22:B46),\"\")","v":""}]
[{"$f":"IF(B47=\"y\",COUNTA(B$22:B47),\"\")","v":""},null,"Action:  A Cash and Investments Reporting Package is required.  (See Section 3.01)"]
[{"$f":"IF(B48=\"y\",COUNTA(B$22:B48),\"\")","v":""}]
[{"$f":"IF(B49=\"y\",COUNTA(B$22:B49),\"\")","v":""}]
[{"$f":"IF(B50=\"y\",COUNTA(B$22:B50),\"\")","v":4},"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(B51=\"y\",COUNTA(B$22:B51),\"\")","v":""}]
[{"$f":"IF(B52=\"y\",COUNTA(B$22:B52),\"\")","v":""},null,"Action:  A Cash and Investments Reporting Package is required.  (See Section 3.01)"]
[{"$f":"IF(B53=\"y\",COUNTA(B$22:B53),\"\")","v":""}]
[{"$f":"IF(B54=\"y\",COUNTA(B$22:B54),\"\")","v":""}]
[{"$f":"IF(B55=\"y\",COUNTA(B$22:B55),\"\")","v":5},"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(B56=\"y\",COUNTA(B$22:B56),\"\")","v":""}]
[{"$f":"IF(B57=\"y\",COUNTA(B$22:B57),\"\")","v":""},null,"Action:  A Cash and Investments Reporting Package is required.  (See Section 3.01)"]
[{"$f":"IF(B58=\"y\",COUNTA(B$22:B58),\"\")","v":""}]
[{"$f":"IF(B59=\"y\",COUNTA(B$22:B59),\"\")","v":""}]
[{"$f":"IF(B60=\"y\",COUNTA(B$22:B60),\"\")","v":6},"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,"No"]
[{"$f":"IF(B61=\"y\",COUNTA(B$22:B61),\"\")","v":""}]
[{"$f":"IF(B62=\"y\",COUNTA(B$22:B62),\"\")","v":""},null,"Action: A Tax Revenues Reporting Package is required.  (See Section 3.02)"]
[{"$f":"IF(B63=\"y\",COUNTA(B$22:B63),\"\")","v":""}]
[{"$f":"IF(B64=\"y\",COUNTA(B$22:B64),\"\")","v":""}]
[{"$f":"IF(B65=\"y\",COUNTA(B$22:B65),\"\")","v":7},"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,"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 before September 6.  "]
[]
[{"$f":"IF(B69=\"y\",COUNTA(B$22:B69),\"\")","v":""}]
[{"$f":"IF(B70=\"y\",COUNTA(B$22:B70),\"\")","v":8},"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(B71=\"y\",COUNTA(B$22:B71),\"\")","v":""}]
[{"$f":"IF(B72=\"y\",COUNTA(B$22:B72),\"\")","v":""},null,"Action:  A Grants and Contribution Revenue Reporting Package is required.  (See Section 3.03)"]
[{"$f":"IF(B73=\"y\",COUNTA(B$22:B73),\"\")","v":""}]
[{"$f":"IF(B74=\"y\",COUNTA(B$22:B74),\"\")","v":""}]
[{"$f":"IF(B75=\"y\",COUNTA(B$22:B75),\"\")","v":9},"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,"No"]
[{"$f":"IF(B76=\"y\",COUNTA(B$22:B76),\"\")","v":""}]
[{"$f":"IF(B77=\"y\",COUNTA(B$22:B77),\"\")","v":""},null,"Action:  A Grants and Contribution Revenue Reporting Package is required.  (See Section 3.03)"]
[{"$f":"IF(B78=\"y\",COUNTA(B$22:B78),\"\")","v":""}]
[{"$f":"IF(B79=\"y\",COUNTA(B$22:B79),\"\")","v":""}]
[{"$f":"IF(B80=\"y\",COUNTA(B$22:B80),\"\")","v":10},"y","Did your agency have any outstanding loans or notes receivable from non-State parties at the beginning of the year (July 1, 2017) or end of the year (June 30, 2018)?",null,null,null,"No"]
[{"$f":"IF(B81=\"y\",COUNTA(B$22:B81),\"\")","v":""}]
[{"$f":"IF(B82=\"y\",COUNTA(B$22:B82),\"\")","v":""},null,"Action:  A Loan Receivables Reporting Package is required.  (See Section 3.10)"]
[{"$f":"IF(B83=\"y\",COUNTA(B$22:B83),\"\")","v":""}]
[{"$f":"IF(B84=\"y\",COUNTA(B$22:B84),\"\")","v":""}]
[{"$f":"IF(B85=\"y\",COUNTA(B$22:B85),\"\")","v":11},"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,"No"]
[{"$f":"IF(B86=\"y\",COUNTA(B$22:B86),\"\")","v":""}]
[{"$f":"IF(B87=\"y\",COUNTA(B$22:B87),\"\")","v":""},null,"Action:  A Other Receivables Reporting Package is required.  (See Section 3.04)"]
[]
[{"$f":"IF(B89=\"y\",COUNTA(B$22:B89),\"\")","v":""}]
[{"$f":"IF(B90=\"y\",COUNTA(B$22:B90),\"\")","v":12},"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(B91=\"y\",COUNTA(B$22:B91),\"\")","v":""}]
[null,null,"Action:  A Other Receivables Reporting Package is required.  (See Section 3.04)"]
[{"$f":"IF(B93=\"y\",COUNTA(B$22:B93),\"\")","v":""}]
[{"$f":"IF(B94=\"y\",COUNTA(B$22:B94),\"\")","v":""}]
[{"$f":"IF(B95=\"y\",COUNTA(B$22:B95),\"\")","v":13},"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(B96=\"y\",COUNTA(B$22:B96),\"\")","v":""}]
[{"$f":"IF(B97=\"y\",COUNTA(B$22:B97),\"\")","v":""},null,"Action:  A Other Receivables Reporting Package is required.  (See Section 3.04)"]
[{"$f":"IF(B98=\"y\",COUNTA(B$22:B98),\"\")","v":""}]
[{"$f":"IF(B99=\"y\",COUNTA(B$22:B99),\"\")","v":""}]
[{"$f":"IF(B100=\"y\",COUNTA(B$22:B100),\"\")","v":14},"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,"No"]
[{"$f":"IF(B101=\"y\",COUNTA(B$22:B101),\"\")","v":""}]
[{"$f":"IF(B102=\"y\",COUNTA(B$22:B102),\"\")","v":""},null,"Action:  A Unearned Revenue Reporting Package is required.  (See Section 3.05)"]
[{"$f":"IF(B103=\"y\",COUNTA(B$22:B103),\"\")","v":""}]
[{"$f":"IF(B104=\"y\",COUNTA(B$22:B104),\"\")","v":""}]
[{"$f":"IF(B105=\"y\",COUNTA(B$22:B105),\"\")","v":15},"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(B106=\"y\",COUNTA(B$22:B106),\"\")","v":""}]
[{"$f":"IF(B107=\"y\",COUNTA(B$22:B107),\"\")","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 Reporting Package Checklist to the Comptroller General's Office."]
[{"$f":"IF(B108=\"y\",COUNTA(B$22:B108),\"\")","v":""}]
[{"$f":"IF(B109=\"y\",COUNTA(B$22:B109),\"\")","v":""}]
[{"$f":"IF(B110=\"y\",COUNTA(B$22:B110),\"\")","v":16},"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,"No"]
[]
[{"$f":"IF(B112=\"y\",COUNTA(B$22:B112),\"\")","v":""},null,"Action:  A Disallowances and Penalties Reporting Package is required (See Section 3.14)."]
[{"$f":"IF(B113=\"y\",COUNTA(B$22:B113),\"\")","v":""}]
[{"$f":"IF(B114=\"y\",COUNTA(B$22:B114),\"\")","v":""}]
[{"$f":"IF(B115=\"y\",COUNTA(B$22:B115),\"\")","v":17},"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(B117=\"y\",COUNTA(B$22:B117),\"\")","v":""},null,"Action: The subsequent events reporting package will request additional information, such asthe 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(B119=\"y\",COUNTA(B$22:B119),\"\")","v":""}]
[{"$f":"IF(B120=\"y\",COUNTA(B$22:B120),\"\")","v":18},"y","Did your agency have inventory on hand at year-end? ",null,null,null,"Yes"]
[{"$f":"IF(B121=\"y\",COUNTA(B$22:B121),\"\")","v":""}]
[{"$f":"IF(B122=\"y\",COUNTA(B$22:B122),\"\")","v":""},null,"Action: An Inventory Reporting Package is required (See Section 3.06)."]
[{"$f":"IF(B123=\"y\",COUNTA(B$22:B123),\"\")","v":""}]
[{"$f":"IF(B124=\"y\",COUNTA(B$22:B124),\"\")","v":""}]
[{"$f":"IF(B125=\"y\",COUNTA(B$22:B125),\"\")","v":19},"y","Did your agency have United States Department of Agriculture food supplies (commodities) at year-end?",null,null,null,"No"]
[{"$f":"IF(B126=\"y\",COUNTA(B$22:B126),\"\")","v":""}]
[{"$f":"IF(B127=\"y\",COUNTA(B$22:B127),\"\")","v":""},null,"Action: An Inventory Reporting Package is required (See Section 3.06)."]
[{"$f":"IF(B128=\"y\",COUNTA(B$22:B128),\"\")","v":""}]
[{"$f":"IF(B129=\"y\",COUNTA(B$22:B129),\"\")","v":""}]
[{"$f":"IF(B130=\"y\",COUNTA(B$22:B130),\"\")","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,"No"]
[]
[null,null,"Action: A Prepaid Expenses Reporting Package is required (See Section 3.07) ."]
[{"$f":"IF(B133=\"y\",COUNTA(B$22:B133),\"\")","v":""}]
[{"$f":"IF(B134=\"y\",COUNTA(B$22:B134),\"\")","v":""}]
[{"$f":"IF(B135=\"y\",COUNTA(B$22:B135),\"\")","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(B137=\"y\",COUNTA(B$22:B137),\"\")","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(B142=\"y\",COUNTA(B$22:B142),\"\")","v":""},null,"Action:  A Capital Assets Reporting Package is required (See Section 3.08)."]
[{"$f":"IF(B143=\"y\",COUNTA(B$22:B143),\"\")","v":""}]
[{"$f":"IF(B144=\"y\",COUNTA(B$22:B144),\"\")","v":""}]
[{"$f":"IF(B145=\"y\",COUNTA(B$22:B145),\"\")","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(B146=\"y\",COUNTA(B$22:B146),\"\")","v":""}]
[{"$f":"IF(B147=\"y\",COUNTA(B$22:B147),\"\")","v":""},null,"Action:  A Capital Assets Reporting Package is required (See Section 3.08)."]
[{"$f":"IF(B148=\"y\",COUNTA(B$22:B148),\"\")","v":""}]
[{"$f":"IF(B149=\"y\",COUNTA(B$22:B149),\"\")","v":""}]
[{"$f":"IF(B150=\"y\",COUNTA(B$22:B150),\"\")","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(B151=\"y\",COUNTA(B$22:B151),\"\")","v":""}]
[{"$f":"IF(B152=\"y\",COUNTA(B$22:B152),\"\")","v":""},null,"Action:  A Capital Assets Reporting Package is required (See Section 3.08)."]
[{"$f":"IF(B153=\"y\",COUNTA(B$22:B153),\"\")","v":""}]
[{"$f":"IF(B154=\"y\",COUNTA(B$22:B154),\"\")","v":""}]
[{"$f":"IF(B155=\"y\",COUNTA(B$22:B155),\"\")","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(B157=\"y\",COUNTA(B$22:B157),\"\")","v":""},null,"Action:  An Operating Leases Reporting Package is required (See Section 3.09)."]
[{"$f":"IF(B158=\"y\",COUNTA(B$22:B158),\"\")","v":""}]
[{"$f":"IF(B159=\"y\",COUNTA(B$22:B159),\"\")","v":""}]
[{"$f":"IF(B160=\"y\",COUNTA(B$22:B160),\"\")","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(B161=\"y\",COUNTA(B$22:B161),\"\")","v":""}]
[{"$f":"IF(B162=\"y\",COUNTA(B$22:B162),\"\")","v":""},null,"Action:  An Operating Leases Reporting Package is required (See Section 3.09)."]
[{"$f":"IF(B163=\"y\",COUNTA(B$22:B163),\"\")","v":""}]
[{"$f":"IF(B164=\"y\",COUNTA(B$22:B164),\"\")","v":""}]
[{"$f":"IF(B165=\"y\",COUNTA(B$22:B165),\"\")","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(B166=\"y\",COUNTA(B$22:B166),\"\")","v":""}]
[{"$f":"IF(B167=\"y\",COUNTA(B$22:B167),\"\")","v":""},null,"Action:  An Operating Leases Reporting Package is required (See Section 3.09)."]
[{"$f":"IF(B168=\"y\",COUNTA(B$22:B168),\"\")","v":""}]
[{"$f":"IF(B169=\"y\",COUNTA(B$22:B169),\"\")","v":""}]
[{"$f":"IF(B170=\"y\",COUNTA(B$22:B170),\"\")","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,"No"]
[null,null,null,null,{"$f":"IF(G170=\"\",\"\",IF(G170=\"Yes\",\"CONTINUE THE CHECKLIST WITH QUESTION 27.a.\",\"CONTINUE THE CHECKLIST WITH QUESTION 28.\"))","v":"CONTINUE THE CHECKLIST WITH QUESTION 28."}]
[null,null,"a.  Have the capital lease and terms of the contract been reported to the CG's office?"]
[]
[null,null,{"$f":"IF(G172=\"\",\"\",IF(G172=\"Yes\",\"RESPOND AS NEEDED TO Sub-question I below.\",\"Action:    Provide the following:  Lease start date, amount of lease, vendor, equipment being leased,\"))","v":""}]
[]
[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,{"$f":"IF(G176=\"\",\"\",IF(G176=\"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(B188=\"y\",COUNTA(B$22:B188),\"\")","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,"No"]
[]
[null,null,{"$f":"IF(G188=\"\",\"\",IF(G188=\"No\",\"Action:  What assurances does the agency have that all leases have been accounted for and recorded.\",\"\"))","v":"Action:  What assurances does the agency have that all leases have been accounted for and recorded."}]
[]
[{"$f":"IF(B192=\"y\",COUNTA(B$22:B192),\"\")","v":""}]
[{"$f":"IF(B193=\"y\",COUNTA(B$22:B193),\"\")","v":29},"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(B194=\"y\",COUNTA(B$22:B194),\"\")","v":""}]
[{"$f":"IF(B195=\"y\",COUNTA(B$22:B195),\"\")","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(B197=\"y\",COUNTA(B$22:B197),\"\")","v":""}]
[{"$f":"IF(B198=\"y\",COUNTA(B$22:B198),\"\")","v":30},"y","Did your agency recognize expenditures in period 12 (June 1 - June 30) of the fiscal year? ",null,null,null,"Yes"]
[{"$f":"IF(B199=\"y\",COUNTA(B$22:B199),\"\")","v":""}]
[{"$f":"IF(B200=\"y\",COUNTA(B$22:B200),\"\")","v":""},null,"Action:  None, this related to the year-end cut-off procedures."]
[{"$f":"IF(B201=\"y\",COUNTA(B$22:B201),\"\")","v":""}]
[{"$f":"IF(B202=\"y\",COUNTA(B$22:B202),\"\")","v":""}]
[{"$f":"IF(B203=\"y\",COUNTA(B$22:B203),\"\")","v":31},"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(B204=\"y\",COUNTA(B$22:B204),\"\")","v":""}]
[]
[{"$f":"IF(B206=\"y\",COUNTA(B$22:B206),\"\")","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(B207=\"y\",COUNTA(B$22:B207),\"\")","v":""}]
[{"$f":"IF(B208=\"y\",COUNTA(B$22:B208),\"\")","v":""}]
[{"$f":"IF(B209=\"y\",COUNTA(B$22:B209),\"\")","v":32},"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,"Yes"]
[{"$f":"IF(B210=\"y\",COUNTA(B$22:B210),\"\")","v":""}]
[null,null,"Action:  Provide the following information:"]
[]
[null,null,"Fund",null,"Employee Gross Pay",null,"Date to be paid"]
[]
[]
[{"$f":"IF(B216=\"y\",COUNTA(B$22:B216),\"\")","v":""}]
[{"$f":"IF(B217=\"y\",COUNTA(B$22:B217),\"\")","v":""}]
[{"$f":"IF(B218=\"y\",COUNTA(B$22:B218),\"\")","v":33},"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,"Yes"]
[{"$f":"IF(B219=\"y\",COUNTA(B$22:B219),\"\")","v":""}]
[null,null,"Action:  Provide the following information:"]
[]
[null,null,"Fund",null,"Amount to be paid",null,"Date to be paid"]
[]
[]
[{"$f":"IF(B225=\"y\",COUNTA(B$22:B225),\"\")","v":""}]
[{"$f":"IF(B226=\"y\",COUNTA(B$22:B226),\"\")","v":""}]
[{"$f":"IF(B227=\"y\",COUNTA(B$22:B227),\"\")","v":""}]
[{"$f":"IF(B228=\"y\",COUNTA(B$22:B228),\"\")","v":34},"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,"Yes"]
[{"$f":"IF(B229=\"y\",COUNTA(B$22:B229),\"\")","v":""}]
[null,null,"Action:  Provide the following information:"]
[]
[null,null,"Entity",null,"Amount to be paid",null,"Date to be paid"]
[]
[]
[{"$f":"IF(B235=\"y\",COUNTA(B$22:B235),\"\")","v":""}]
[{"$f":"IF(B236=\"y\",COUNTA(B$22:B236),\"\")","v":""}]
[{"$f":"IF(B237=\"y\",COUNTA(B$22:B237),\"\")","v":""}]
[{"$f":"IF(B238=\"y\",COUNTA(B$22:B238),\"\")","v":35},"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(B239=\"y\",COUNTA(B$22:B239),\"\")","v":""}]
[{"$f":"IF(B240=\"y\",COUNTA(B$22:B240),\"\")","v":""},null,"Action:  The Interfund Payables Reporting Package is required (See Section 3.18)."]
[{"$f":"IF(B241=\"y\",COUNTA(B$22:B241),\"\")","v":""}]
[{"$f":"IF(B242=\"y\",COUNTA(B$22:B242),\"\")","v":""}]
[{"$f":"IF(B243=\"y\",COUNTA(B$22:B243),\"\")","v":""}]
[{"$f":"IF(B244=\"y\",COUNTA(B$22:B244),\"\")","v":36},"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(B245=\"y\",COUNTA(B$22:B245),\"\")","v":""}]
[{"$f":"IF(B246=\"y\",COUNTA(B$22:B246),\"\")","v":""},null,"Action:  The Interfund Payables Reporting Package is required (See Section 3.18)."]
[{"$f":"IF(B247=\"y\",COUNTA(B$22:B247),\"\")","v":""}]
[{"$f":"IF(B248=\"y\",COUNTA(B$22:B248),\"\")","v":""}]
[{"$f":"IF(B249=\"y\",COUNTA(B$22:B249),\"\")","v":""}]
[{"$f":"IF(B250=\"y\",COUNTA(B$22:B250),\"\")","v":37},"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(B251=\"y\",COUNTA(B$22:B251),\"\")","v":""}]
[{"$f":"IF(B252=\"y\",COUNTA(B$22:B252),\"\")","v":""},null,"Insurance Reserve Fund Loans"]
[null,null,"Capital Improvement Bond Proceeds Loans"]
[{"$f":"IF(B254=\"y\",COUNTA(B$22:B254),\"\")","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(B257=\"y\",COUNTA(B$22:B257),\"\")","v":""}]
[{"$f":"IF(B258=\"y\",COUNTA(B$22:B258),\"\")","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(B271=\"y\",COUNTA(B$22:B271),\"\")","v":""},null,"SET MACRO'S TO ENABLE "]
[{"$f":"IF(B272=\"y\",COUNTA(B$22:B272),\"\")","v":""}]
[{"$f":"IF(B273=\"y\",COUNTA(B$22:B273),\"\")","v":38},"y","Does your agency have any loans or notes payable/receivable at June 30 between funds within your agency?",null,null,null,"No"]
[{"$f":"IF(B274=\"y\",COUNTA(B$22:B274),\"\")","v":""}]
[{"$f":"IF(B275=\"y\",COUNTA(B$22:B275),\"\")","v":""},null,"Action:  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(B276=\"y\",COUNTA(B$22:B276),\"\")","v":""}]
[{"$f":"IF(B277=\"y\",COUNTA(B$22:B277),\"\")","v":""}]
[{"$f":"IF(B278=\"y\",COUNTA(B$22:B278),\"\")","v":39},"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,"No"]
[{"$f":"IF(B279=\"y\",COUNTA(B$22:B279),\"\")","v":""}]
[{"$f":"IF(B280=\"y\",COUNTA(B$22:B280),\"\")","v":""},null,"Action:  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(B281=\"y\",COUNTA(B$22:B281),\"\")","v":""}]
[{"$f":"IF(B282=\"y\",COUNTA(B$22:B282),\"\")","v":""}]
[{"$f":"IF(B283=\"y\",COUNTA(B$22:B283),\"\")","v":40},"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,"No"]
[{"$f":"IF(B284=\"y\",COUNTA(B$22:B284),\"\")","v":""}]
[{"$f":"IF(B285=\"y\",COUNTA(B$22:B285),\"\")","v":""},null,"Action:  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(B286=\"y\",COUNTA(B$22:B286),\"\")","v":""}]
[{"$f":"IF(B287=\"y\",COUNTA(B$22:B287),\"\")","v":""}]
[{"$f":"IF(B288=\"y\",COUNTA(B$22:B288),\"\")","v":41},"y","Did your agency owe refunds of revenue to other parties (excluding income tax refunds) at June 30 but not paid by the end of the fiscal year for which this form is being completed?"]
[{"$f":"IF(B289=\"y\",COUNTA(B$22:B289),\"\")","v":""}]
[{"$f":"IF(B290=\"y\",COUNTA(B$22:B290),\"\")","v":""},null,"Action:   An Accounts Payable Reporting Package is required (See Section 3.12)"]
[{"$f":"IF(B291=\"y\",COUNTA(B$22:B291),\"\")","v":""}]
[{"$f":"IF(B292=\"y\",COUNTA(B$22:B292),\"\")","v":""}]
[{"$f":"IF(B293=\"y\",COUNTA(B$22:B293),\"\")","v":""}]
[{"$f":"IF(B294=\"y\",COUNTA(B$22:B294),\"\")","v":42},"y","The State Treasurer's Office Master Lease Program provides financing for equipment purchasesof $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,"No"]
[{"$f":"IF(B295=\"y\",COUNTA(B$22:B295),\"\")","v":""}]
[{"$f":"IF(B296=\"y\",COUNTA(B$22:B296),\"\")","v":""},null,"a.   Did your agency have any loan proceeds held in an escrow account at June 30 for any loans under this program?"]
[{"$f":"IF(B297=\"y\",COUNTA(B$22:B297),\"\")","v":""}]
[{"$f":"IF(B298=\"y\",COUNTA(B$22:B298),\"\")","v":""},null,"Action:  Provide the following information (if additional space is needed, click the Show Worksheet 42. (Cont) button below)"]
[]
[{"$f":"IF(B300=\"y\",COUNTA(B$22:B300),\"\")","v":""},null,"Lease ID #"]
[{"$f":"IF(B301=\"y\",COUNTA(B$22:B301),\"\")","v":""},null,"Amount held in escrow"]
[{"$f":"IF(B302=\"y\",COUNTA(B$22:B302),\"\")","v":""}]
[{"$f":"IF(B303=\"y\",COUNTA(B$22:B303),\"\")","v":""},null,"b.   Did your agency have an escrow account for this program closed out during the fiscal year?"]
[{"$f":"IF(B304=\"y\",COUNTA(B$22:B304),\"\")","v":""}]
[{"$f":"IF(B305=\"y\",COUNTA(B$22:B305),\"\")","v":""},null,"Action:  Provide the following information (if additional space is needed, click the Show Worksheet 42. (Cont) button below)"]
[]
[{"$f":"IF(B307=\"y\",COUNTA(B$22:B307),\"\")","v":""},null,"Lease ID #(s)"]
[{"$f":"IF(B308=\"y\",COUNTA(B$22:B308),\"\")","v":""},null,"Date the escrow account was closed checklist."]
[]
[null,null,"c.  Was an asset(s) established in the SCEIS system?"]
[]
[null,null,{"$f":"IF(G310=\"\",\"\",IF(G310=\"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":""}]
[]
[]
[]
[]
[]
[]
[{"$f":"IF(B319=\"y\",COUNTA(B$22:B319),\"\")","v":""}]
[{"$f":"IF(B320=\"y\",COUNTA(B$22:B320),\"\")","v":""},null,"SET MACRO'S TO ENABLE "]
[{"$f":"IF(B321=\"y\",COUNTA(B$22:B321),\"\")","v":""}]
[{"$f":"IF(B322=\"y\",COUNTA(B$22:B322),\"\")","v":43},"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,"No"]
[{"$f":"IF(B323=\"y\",COUNTA(B$22:B323),\"\")","v":""}]
[{"$f":"IF(B324=\"y\",COUNTA(B$22:B324),\"\")","v":""},null,"a.  Did your agency pay off any loans under this program during the fiscal year ended June 30?"]
[{"$f":"IF(B325=\"y\",COUNTA(B$22:B325),\"\")","v":""}]
[{"$f":"IF(B326=\"y\",COUNTA(B$22:B326),\"\")","v":""},null,"Action:  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."]
[]
[null,null,"b.   Did your agency have an escrow account for this program closed out during the fiscal year?"]
[]
[{"$f":"IF(B330=\"y\",COUNTA(B$22:B330),\"\")","v":""},null,"Action:  Provide the following information (if additional space is needed, attach a sheet)"]
[]
[{"$f":"IF(B332=\"y\",COUNTA(B$22:B332),\"\")","v":""},null,"Lease ID #(s)"]
[{"$f":"IF(B333=\"y\",COUNTA(B$22:B333),\"\")","v":""},null,"Date the escrow account was closed checklist."]
[{"$f":"IF(B334=\"y\",COUNTA(B$22:B334),\"\")","v":""}]
[{"$f":"IF(B335=\"y\",COUNTA(B$22:B335),\"\")","v":""}]
[{"$f":"IF(B336=\"y\",COUNTA(B$22:B336),\"\")","v":44},"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(B337=\"y\",COUNTA(B$22:B337),\"\")","v":""}]
[{"$f":"IF(B338=\"y\",COUNTA(B$22:B338),\"\")","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(B341=\"y\",COUNTA(B$22:B341),\"\")","v":""},null,"General Ledger Account"]
[{"$f":"IF(B342=\"y\",COUNTA(B$22:B342),\"\")","v":""},null,"Amount"]
[]
[null,null,"Interest"]
[{"$f":"IF(B345=\"y\",COUNTA(B$22:B345),\"\")","v":""},null,"General Ledger Account"]
[{"$f":"IF(B346=\"y\",COUNTA(B$22:B346),\"\")","v":""},null,"Amount"]
[{"$f":"IF(B347=\"y\",COUNTA(B$22:B347),\"\")","v":""}]
[{"$f":"IF(B348=\"y\",COUNTA(B$22:B348),\"\")","v":""},null,"SET MACRO'S TO ENABLE "]
[{"$f":"IF(B349=\"y\",COUNTA(B$22:B349),\"\")","v":""}]
[{"$f":"IF(B350=\"y\",COUNTA(B$22:B350),\"\")","v":45},"y","Has your agency used installment purchase financing (loans or notes) for acquisition?",null,null,null,"No"]
[{"$f":"IF(B351=\"y\",COUNTA(B$22:B351),\"\")","v":""}]
[{"$f":"IF(B352=\"y\",COUNTA(B$22:B352),\"\")","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? "]
[{"$f":"IF(B353=\"y\",COUNTA(B$22:B353),\"\")","v":""}]
[{"$f":"IF(B354=\"y\",COUNTA(B$22:B354),\"\")","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 Reporting Package Checklist to the Comptroller General's Office."]
[{"$f":"IF(B356=\"y\",COUNTA(B$22:B356),\"\")","v":""}]
[{"$f":"IF(B357=\"y\",COUNTA(B$22:B357),\"\")","v":""}]
[{"$f":"IF(B358=\"y\",COUNTA(B$22:B358),\"\")","v":46},"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(B359=\"y\",COUNTA(B$22:B359),\"\")","v":""}]
[{"$f":"IF(B360=\"y\",COUNTA(B$22:B360),\"\")","v":""},null,"School Bonds"]
[{"$f":"IF(B361=\"y\",COUNTA(B$22:B361),\"\")","v":""},null,"State Institution Bonds and Notes"]
[{"$f":"IF(B362=\"y\",COUNTA(B$22:B362),\"\")","v":""},null,"Capital Improvement Bonds"]
[null,null,"Richard B. Russell Dam Debt"]
[{"$f":"IF(B364=\"y\",COUNTA(B$22:B364),\"\")","v":""},null,"Heritage Trust Revenue Bonds"]
[null,null,"Lease Revenue Bonds"]
[{"$f":"IF(B366=\"y\",COUNTA(B$22:B366),\"\")","v":""},null,"State Air Carrier Hub Bonds"]
[{"$f":"IF(B367=\"y\",COUNTA(B$22:B367),\"\")","v":""},null,"State Treasurer's Office Master Lease Program"]
[{"$f":"IF(B368=\"y\",COUNTA(B$22:B368),\"\")","v":""},null,"State Facilities Installment Purchase Revenue Bonds"]
[{"$f":"IF(B369=\"y\",COUNTA(B$22:B369),\"\")","v":""},null,"State Economic Development Bonds"]
[]
[{"$f":"IF(B371=\"y\",COUNTA(B$22:B371),\"\")","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(B372=\"y\",COUNTA(B$22:B372),\"\")","v":""}]
[{"$f":"IF(B373=\"y\",COUNTA(B$22:B373),\"\")","v":""},null,"Action:  Describe the situation in a letter or other attachment to this ReportingPackage 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(B374=\"y\",COUNTA(B$22:B374),\"\")","v":""}]
[{"$f":"IF(B375=\"y\",COUNTA(B$22:B375),\"\")","v":""}]
[{"$f":"IF(B376=\"y\",COUNTA(B$22:B376),\"\")","v":47},"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(B379=\"y\",COUNTA(B$22:B379),\"\")","v":""}]
[{"$f":"IF(B380=\"y\",COUNTA(B$22:B380),\"\")","v":""}]
[{"$f":"IF(B381=\"y\",COUNTA(B$22:B381),\"\")","v":48},"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(B382=\"y\",COUNTA(B$22:B382),\"\")","v":""}]
[{"$f":"IF(B383=\"y\",COUNTA(B$22:B383),\"\")","v":""},null,"Action:  The Litigation Reporting Package is required.  (See Section 3.13)"]
[{"$f":"IF(B384=\"y\",COUNTA(B$22:B384),\"\")","v":""}]
[{"$f":"IF(B385=\"y\",COUNTA(B$22:B385),\"\")","v":""}]
[{"$f":"IF(B386=\"y\",COUNTA(B$22:B386),\"\")","v":49},"y","Does your agency have claims in excess of $100,000 for EITHER:",null,null,null,"No"]
[{"$f":"IF(B387=\"y\",COUNTA(B$22:B387),\"\")","v":""},null,"--  Any self-insured risk to which it is exposed?"]
[{"$f":"IF(B388=\"y\",COUNTA(B$22:B388),\"\")","v":""},null,"OR"]
[{"$f":"IF(B389=\"y\",COUNTA(B$22:B389),\"\")","v":""},null,"--  Any claim-paying program it manages?"]
[{"$f":"IF(B390=\"y\",COUNTA(B$22:B390),\"\")","v":""}]
[{"$f":"IF(B391=\"y\",COUNTA(B$22:B391),\"\")","v":""},null,"Action:  The Claims Reporting Package is required.  (See Section 3.15)"]
[{"$f":"IF(B392=\"y\",COUNTA(B$22:B392),\"\")","v":""}]
[{"$f":"IF(B393=\"y\",COUNTA(B$22:B393),\"\")","v":""}]
[{"$f":"IF(B394=\"y\",COUNTA(B$22:B394),\"\")","v":50},"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(B397=\"y\",COUNTA(B$22:B397),\"\")","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(B402=\"y\",COUNTA(B$22:B402),\"\")","v":""}]
[{"$f":"IF(B403=\"y\",COUNTA(B$22:B403),\"\")","v":""},null,"Action:  The Miscellaneous Loss Liabilities, Loss Contingencies, and Commitments Reporting Package is required.   (See Section 3.16)"]
[{"$f":"IF(B404=\"y\",COUNTA(B$22:B404),\"\")","v":""}]
[{"$f":"IF(B405=\"y\",COUNTA(B$22:B405),\"\")","v":""}]
[{"$f":"IF(B406=\"y\",COUNTA(B$22:B406),\"\")","v":51},"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(B407=\"y\",COUNTA(B$22:B407),\"\")","v":""}]
[{"$f":"IF(B408=\"y\",COUNTA(B$22:B408),\"\")","v":""},null,"Action:  The Miscellaneous Loss Liabilities, Loss Contingencies, and Commitments Reporting Package is required.   (See Section 3.16.1)"]
[{"$f":"IF(B409=\"y\",COUNTA(B$22:B409),\"\")","v":""}]
[{"$f":"IF(B410=\"y\",COUNTA(B$22:B410),\"\")","v":""}]
[{"$f":"IF(B411=\"y\",COUNTA(B$22:B411),\"\")","v":52},"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(B412=\"y\",COUNTA(B$22:B412),\"\")","v":""}]
[{"$f":"IF(B413=\"y\",COUNTA(B$22:B413),\"\")","v":""},null,"Action:  Describe the situation in a letter or other attachment when you return thisReporting Package Checklist to the Comptroller General's Office.Be sure to fully describe the activity and whether you self-insure theactivity, purchase insurance to cover the activity, or provide insurancecoverage to other entities for this activity.  Also, please include the nameand phone number of a person within your agency that we may contactto obtain additional information,  if necessary."]
[{"$f":"IF(B414=\"y\",COUNTA(B$22:B414),\"\")","v":""}]
[{"$f":"IF(B415=\"y\",COUNTA(B$22:B415),\"\")","v":""}]
[{"$f":"IF(B416=\"y\",COUNTA(B$22:B416),\"\")","v":53},"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(B417=\"y\",COUNTA(B$22:B417),\"\")","v":""}]
[{"$f":"IF(B418=\"y\",COUNTA(B$22:B418),\"\")","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 Reporting Package Checklist to the Comptroller General'sOffice."]
[{"$f":"IF(B419=\"y\",COUNTA(B$22:B419),\"\")","v":""}]
[{"$f":"IF(B420=\"y\",COUNTA(B$22:B420),\"\")","v":""}]
[{"$f":"IF(B421=\"y\",COUNTA(B$22:B421),\"\")","v":54},"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 afinancial impact on the agency.",null,null,null,"No"]
[{"$f":"IF(B422=\"y\",COUNTA(B$22:B422),\"\")","v":""}]
[{"$f":"IF(B423=\"y\",COUNTA(B$22:B423),\"\")","v":""},null,"Action:   Describe the situation on agency letterhead signed by the Agency Directoror 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(B424=\"y\",COUNTA(B$22:B424),\"\")","v":""}]
[{"$f":"IF(B425=\"y\",COUNTA(B$22:B425),\"\")","v":""}]
[{"$f":"IF(B426=\"y\",COUNTA(B$22:B426),\"\")","v":55},"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(B427=\"y\",COUNTA(B$22:B427),\"\")","v":""}]
[{"$f":"IF(B428=\"y\",COUNTA(B$22:B428),\"\")","v":""},null,"Action:   Describe the situation on agency letterhead signed by the Agency Directoror 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(B429=\"y\",COUNTA(B$22:B429),\"\")","v":""}]
[{"$f":"IF(B430=\"y\",COUNTA(B$22:B430),\"\")","v":""}]
[{"$f":"IF(B431=\"y\",COUNTA(B$22:B431),\"\")","v":56},"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(B432=\"y\",COUNTA(B$22:B432),\"\")","v":""}]
[{"$f":"IF(B433=\"y\",COUNTA(B$22:B433),\"\")","v":""},null,"Action:   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(B434=\"y\",COUNTA(B$22:B434),\"\")","v":""}]
[{"$f":"IF(B435=\"y\",COUNTA(B$22:B435),\"\")","v":""}]
[{"$f":"IF(B436=\"y\",COUNTA(B$22:B436),\"\")","v":57},"y","Has your agency had either of the following situations:",null,null,null,"No"]
[{"$f":"IF(B437=\"y\",COUNTA(B$22:B437),\"\")","v":""},null,"--  Any violations or possible violations of laws or regulations that will not be reported"]
[{"$f":"IF(B438=\"y\",COUNTA(B$22:B438),\"\")","v":""},null,"in an existing reporting package?"]
[{"$f":"IF(B439=\"y\",COUNTA(B$22:B439),\"\")","v":""},null,"OR"]
[{"$f":"IF(B440=\"y\",COUNTA(B$22:B440),\"\")","v":""},null,"--  Any instances of noncompliance with applicable laws, regulations, contracts and"]
[{"$f":"IF(B441=\"y\",COUNTA(B$22:B441),\"\")","v":""},null,"grants that will not be reported in an existing reporting package or addressed in "]
[{"$f":"IF(B442=\"y\",COUNTA(B$22:B442),\"\")","v":""},null,"the previous question regarding financial reporting practices? "]
[{"$f":"IF(B443=\"y\",COUNTA(B$22:B443),\"\")","v":""}]
[{"$f":"IF(B444=\"y\",COUNTA(B$22:B444),\"\")","v":""},null,"Action:  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(B445=\"y\",COUNTA(B$22:B445),\"\")","v":""}]
[{"$f":"IF(B446=\"y\",COUNTA(B$22:B446),\"\")","v":""}]
[{"$f":"IF(B447=\"y\",COUNTA(B$22:B447),\"\")","v":58},"y","Does your agency know or reasonably believe a site is polluted or contaminated?",null,null,null,"No"]
[{"$f":"IF(B448=\"y\",COUNTA(B$22:B448),\"\")","v":""}]
[{"$f":"IF(B449=\"y\",COUNTA(B$22:B449),\"\")","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?"]
[{"$f":"IF(B450=\"y\",COUNTA(B$22:B450),\"\")","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 theevent when this Reporting Package Checklist is returned to the Comptroller General's Office."]
[{"$f":"IF(B452=\"y\",COUNTA(B$22:B452),\"\")","v":""}]
[{"$f":"IF(B453=\"y\",COUNTA(B$22:B453),\"\")","v":""},null,"b. Has your agency violated a pollution prevention-related permit or license? "]
[]
[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 theevent when this Reporting Package Checklist is returned to the Comptroller General's Office."]
[{"$f":"IF(B456=\"y\",COUNTA(B$22:B456),\"\")","v":""}]
[{"$f":"IF(B457=\"y\",COUNTA(B$22:B457),\"\")","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,"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 theevent when this Reporting Package Checklist is returned to the Comptroller General's Office."]
[{"$f":"IF(B460=\"y\",COUNTA(B$22:B460),\"\")","v":""}]
[{"$f":"IF(B461=\"y\",COUNTA(B$22:B461),\"\")","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?"]
[{"$f":"IF(B462=\"y\",COUNTA(B$22:B462),\"\")","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 theevent when this Reporting Package Checklist is returned to the Comptroller General's Office."]
[{"$f":"IF(B464=\"y\",COUNTA(B$22:B464),\"\")","v":""}]
[{"$f":"IF(B465=\"y\",COUNTA(B$22:B465),\"\")","v":""},null,"e. Has your agency commenced, or legally obligated itself to commence, cleanup activities, monitoring, or maintenance and operation of the remediation effort?"]
[{"$f":"IF(B466=\"y\",COUNTA(B$22:B466),\"\")","v":""}]
[{"$f":"IF(B467=\"y\",COUNTA(B$22:B467),\"\")","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 theevent when this Reporting Package Checklist is returned to the Comptroller General's Office."]
[{"$f":"IF(B468=\"y\",COUNTA(B$22:B468),\"\")","v":""}]
[{"$f":"IF(B469=\"y\",COUNTA(B$22:B469),\"\")","v":""}]
[{"$f":"IF(B470=\"y\",COUNTA(B$22:B470),\"\")","v":""}]
[{"$f":"IF(B471=\"y\",COUNTA(B$22:B471),\"\")","v":""}]
[]
[{"$f":"IF(B473=\"y\",COUNTA(B$22:B473),\"\")","v":""}]
[{"$f":"IF(B474=\"y\",COUNTA(B$22:B474),\"\")","v":""}]
[{"$f":"IF(B475=\"y\",COUNTA(B$22:B475),\"\")","v":""}]
[{"$f":"IF(B476=\"y\",COUNTA(B$22:B476),\"\")","v":""}]
[{"$f":"IF(B477=\"y\",COUNTA(B$22:B477),\"\")","v":""}]
[{"$f":"IF(B478=\"y\",COUNTA(B$22:B478),\"\")","v":""}]
[{"$f":"IF(B479=\"y\",COUNTA(B$22:B479),\"\")","v":""}]
[{"$f":"IF(B480=\"y\",COUNTA(B$22:B480),\"\")","v":""}]

{"sheet":"Required Packages","index":4,"n_rows":116,"n_cols":6,"rows_kept":116,"cut":false,"hidden":false,"merged":[[55,1,55,3],[5,0,5,5],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4]]}
["STATE OF SOUTH CAROLINA"]
["YEAR-END REPORTING PACKAGE "]
["SUMMARY OF REQUIRED PACKAGES AND ADDITIONAL DOCUMENTATION"]
[{"$f":"\"For the Fiscal Year Ended June 30, \"&Year","v":"For the Fiscal Year Ended June 30, 2019"}]
[]
[{"$f":"\"For\"&\" \"&AgencyCode&\", \"&AgencyName","v":"For ZZZZ, EXAMPLE AGENCY"}]
[]
["Package Number",null,null,null,"Required Package/Sheet"]
[]
[2.0099999999999998,"Subsequent Events Reporting Package",null,null,{"$f":"IF(OR(F66=\"Yes\",F67=\"Yes\")=FALSE,\"Not Required\",\"Due\"&\" \"&Resources!D4&\" but not before \"&Resources!E4)","v":"Due 10/21/2019 but not before 10/7/2019"}]
[3.01,"Cash and Investments Reporting Package",null,null,{"$f":"IF(OR(F12=\"Yes\",F13=\"Yes\",F14=\"Yes\")=FALSE,\"Not Required\",\"Due\"&\" \"&Resources!D5)","v":"Due 7/19/2019"}]
[null,null,"3.01.1","Petty Cash",null,{"$f":"IF('2.0.1'!G45=\"Yes\",\"Yes\",IF('2.0.1'!G45=\"No\",\"No\",IF('2.0.1'!G45=\"\",\"\",\"ERROR\")))","v":"Yes"}]
[null,null,"3.01.2","Agency Cash",null,{"$f":"IF('2.0.1'!G50=\"Yes\",\"Yes\",IF('2.0.1'!G50=\"No\",\"No\",IF('2.0.1'!G50=\"\",\"\",\"ERROR\")))","v":"Yes"}]
[null,null,"3.01.3","Investments",null,{"$f":"IF('2.0.1'!G55=\"Yes\",\"Yes\",IF('2.0.1'!G55=\"No\",\"No\",IF('2.0.1'!G55=\"\",\"\",\"ERROR\")))","v":"Yes"}]
[3.02,"Tax Revenue Reporting Package",null,null,{"$f":"IF(OR(F16=\"Yes\",F17=\"Yes\",F18=\"Yes\")=FALSE,\"Not Required\",\"Due\"&\" \"&Resources!D6)","v":"Not Required"}]
[null,null,"3.02.1","Tax Receivable",null,{"$f":"IF('2.0.1'!G60=\"Yes\",\"Yes\",IF('2.0.1'!G60=\"No\",\"No\",IF('2.0.1'!G60=\"\",\"\",\"ERROR\")))","v":"No"}]
[null,null,"3.02.2","Tax Refund Payable",null,{"$f":"IF('2.0.1'!G60=\"Yes\",\"Yes\",IF('2.0.1'!G60=\"No\",\"No\",IF('2.0.1'!G60=\"\",\"\",\"ERROR\")))","v":"No"}]
[null,null,"3.02.3","Deferred Tax Revenues",null,{"$f":"IF('2.0.1'!G60=\"Yes\",\"Yes\",IF('2.0.1'!G60=\"No\",\"No\",IF('2.0.1'!G60=\"\",\"\",\"ERROR\")))","v":"No"}]
[3.03,"Grants and Contribution Revenue Reporting Package",null,null,{"$f":"IF(OR(F20=\"Yes\",F21=\"Yes\",F22=\"Yes\")=FALSE,\"Not Required\",\"Due\"&\" \"&Resources!D7)","v":"Due 9/13/2019"}]
[null,null,"3.03.1","Grants Activity Form",null,{"$f":"IF('2.0.1'!G70=\"Yes\",\"Yes\",IF('2.0.1'!G70=\"No\",\"No\",IF('2.0.1'!G70=\"\",\"\",\"ERROR\")))","v":"Yes"}]
[null,null,"3.03.2","Grants Receivable and Deferred Revenue Summary Form",null,{"$f":"IF('2.0.1'!G70=\"Yes\",\"Yes\",IF('2.0.1'!G70=\"No\",\"No\",IF('2.0.1'!G70=\"\",\"\",\"ERROR\")))","v":"Yes"}]
[null,null,"3.03.3","Contributions Receivable and Deferred Revenue Summary Form",null,{"$f":"IF('2.0.1'!G75=\"Yes\",\"Yes\",IF('2.0.1'!G75=\"No\",\"No\",IF('2.0.1'!G75=\"\",\"\",\"ERROR\")))","v":"No"}]
[3.04,"Other Receivables Reporting Package",null,null,{"$f":"IF(F24=\"Yes\"=FALSE,\"Not Required\",\"Due\"&\" \"&Resources!D8)","v":"Due 8/9/2019"}]
[null,null,"3.04.1","Receivables Summary Form",null,{"$f":"IF(OR('2.0.1'!G85=\"Yes\",'2.0.1'!G90=\"Yes\",'2.0.1'!G95=\"Yes\")=TRUE,\"Yes\",IF(AND('2.0.1'!G85=\"No\",'2.0.1'!G90=\"No\",'2.0.1'!G95=\"No\")=TRUE,\"No\",IF(AND('2.0.1'!G85=\"\",'2.0.1'!G90=\"\",'2.0.1'!G95=\"\")=TRUE,\"\",\"ERROR\")))","v":"Yes"}]
[3.05,"Unearned Revenue  Reporting Package",null,null,{"$f":"IF(F26=\"Yes\"=FALSE,\"Not Required\",\"Due\"&\" \"&Resources!D9)","v":"Not Required"}]
[null,null,"3.05.1","Unearned Revenue Summary Form",null,{"$f":"IF('2.0.1'!G100=\"Yes\",\"Yes\",IF('2.0.1'!G100=\"No\",\"No\",IF('2.0.1'!G100=\"\",\"\",\"ERROR\")))","v":"No"}]
[3.06,"Inventory Reporting Package",null,null,{"$f":"IF(OR(F28=\"Yes\")=FALSE,\"Not Required\",\"Due\"&\" \"&Resources!D10)","v":"Due 8/9/2019"}]
[null,null,"3.06.1","Inventory Summary Form",null,{"$f":"IF(OR('2.0.1'!G120=\"Yes\",'2.0.1'!G125=\"Yes\"),\"Yes\",IF(OR('2.0.1'!G120=\"No\",'2.0.1'!G125=\"No\"),\"No\",IF('2.0.1'!G120=\"\",\"\",\"ERROR\")))","v":"Yes"}]
[3.07,"Prepaid Expenses Reporting Package",null,null,{"$f":"IF(OR(F30=\"Yes\")=FALSE,\"Not Required\",\"Due\"&\" \"&Resources!D11)","v":"Not Required"}]
[null,null,"3.07.1","Prepaid Expenses Summary Form",null,{"$f":"IF('2.0.1'!G130=\"Yes\",\"Yes\",IF('2.0.1'!G130=\"No\",\"No\",IF('2.0.1'!G130=\"\",\"\",\"ERROR\")))","v":"No"}]
[3.08,"Capital Assets Reporting Package",null,null,{"$f":"IF(OR(F32=\"Yes\")=FALSE,\"Not Required\",\"Due\"&\" \"&Resources!D12)","v":"Due 9/13/2019"}]
[null,null,"3.08.1","Capital Asset Questionnaire",null,{"$f":"IF(OR('2.0.1'!G135=\"Yes\",'2.0.1'!G140=\"Yes\")=TRUE,\"Yes\",IF(AND('2.0.1'!G135=\"No\",'2.0.1'!G140=\"No\")=TRUE,\"No\",IF(AND('2.0.1'!G135=\"\",'2.0.1'!G140=\"\")=TRUE,\"\",\"ERROR\")))","v":"Yes"}]
[null,null,"3.08.2","Reporting of Adjustments and Errors Identified in SCEIS Asset History",null,{"$f":"IF(F32=\"Yes\",\"Based on 3.08.1\",IF(F32=\"No\",\"No\",IF(F32=\"\",\"\",\"ERROR\")))","v":"Based on 3.08.1"}]
[null,null,"3.08.3","Non-SCEIS Agencies Only - Capital Asset Summary Form",null,{"$f":"IF(F32=\"Yes\",\"Based on 3.08.1\",IF(F32=\"No\",\"No\",IF(F32=\"\",\"\",\"ERROR\")))","v":"Based on 3.08.1"}]
[null,null,"3.08.4","Capital Asset Intra-State Transfers Summary Form",null,{"$f":"IF(F32=\"Yes\",\"Based on 3.08.1\",IF(F32=\"No\",\"No\",IF(F32=\"\",\"\",\"ERROR\")))","v":"Based on 3.08.1"}]
[null,null,"3.08.5","Asset History Reconciliation To GL Activity",null,{"$f":"IF(F32=\"Yes\",\"Based on 3.08.1\",IF(F32=\"No\",\"No\",IF(F32=\"\",\"\",\"ERROR\")))","v":"Based on 3.08.1"}]
[3.09,"Operating Lease Reporting Package",null,null,{"$f":"IF(OR(F38=\"Yes\")=FALSE,\"Not Required\",\"Due\"&\" \"&Resources!D13)","v":"Due 8/23/2019"}]
[null,null,"3.09.1","Operating Lease Summary Form - Leasee",null,{"$f":"IF(OR('2.0.1'!G155=\"Yes\",'2.0.1'!G160=\"Yes\",'2.0.1'!G165=\"Yes\"),\"Yes\",IF(AND('2.0.1'!G155=\"No\",'2.0.1'!G160=\"No\",'2.0.1'!G165=\"No\"),\"No\",IF(AND('2.0.1'!G155=\"\",'2.0.1'!G160=\"\",'2.0.1'!G165=\"\"),\"\",\"ERROR\")))","v":"Yes"}]
[null,null,"3.09.1.a","Operating Lease Future Minimum Payment Schedule",null,{"$f":"IF(F38=\"Yes\",\"Based on 3.09.1\",IF(F38=\"No\",\"No\",IF(F38=\"\",\"\",\"ERROR\")))","v":"Based on 3.09.1"}]
[null,null,"3.09.2","Operating Lease Summary Form - Leasor",null,{"$f":"IF(F38=\"Yes\",\"Based on 3.09.1\",IF(F38=\"No\",\"No\",IF(F38=\"\",\"\",\"ERROR\")))","v":"Based on 3.09.1"}]
[3.1,"Loans Receivable Reporting Package",null,null,{"$f":"IF(OR(F42=\"Yes\")=FALSE,\"Not Required\",\"Due\"&\" \"&Resources!D14)","v":"Not Required"}]
[null,null,"3.10.1","Loans Receivable Summary Form",null,{"$f":"IF('2.0.1'!G80=\"Yes\",\"Yes\",IF('2.0.1'!G80=\"No\",\"No\",IF('2.0.1'!G80=\"\",\"\",\"ERROR\")))","v":"No"}]
[3.11,"Not Currently In Use"]
[3.12,"Accounts Payable Reporting Package",null,null,{"$f":"IF(OR(F45=\"Yes\")=FALSE,\"Not Required\",\"Due\"&\" \"&Resources!D15)","v":"Due 9/13/2019"}]
[null,null,"3.12.1","Accounts Payable Summary Form",null,{"$f":"IF(OR('2.0.1'!G193=\"Yes\",'2.0.1'!G203=\"Yes\",'2.0.1'!G288=\"Yes\")=TRUE,\"Yes\",IF(AND('2.0.1'!G193=\"No\",'2.0.1'!G203=\"No\",'2.0.1'!G288=\"No\")=TRUE,\"No\",IF(AND('2.0.1'!G193=\"\",'2.0.1'!G203=\"\",'2.0.1'!G288=\"\")=TRUE,\"\",\"ERROR\")))","v":"Yes"}]
[3.13,"Litigation Reporting Package",null,null,{"$f":"IF(OR(F47=\"Yes\",F48=\"Yes\")=FALSE,\"Not Required\",\"Due\"&\" \"&Resources!D17)","v":"Due 7/19/2019"}]
[null,null,"3.13.1","Litigation Related Expense Explanation Form",null,{"$f":"IF('2.0.1'!G381=\"Yes\",\"Yes\",IF('2.0.1'!G381=\"No\",\"No\",IF('2.0.1'!G381=\"\",\"\",\"ERROR\")))","v":"Yes"}]
[null,null,"3.13.2","Litigation Overview Form",null,{"$f":"IF('2.0.1'!G381=\"Yes\",\"Yes\",IF('2.0.1'!G381=\"No\",\"No\",IF('2.0.1'!G381=\"\",\"\",\"ERROR\")))","v":"Yes"}]
[null,null,"3.13.3","Settled Litigation Report Form",null,{"$f":"IF(F48=\"Yes\",\"Based on 3.13.1\",IF(F48=\"No\",\"No\",IF(F48=\"\",\"\",\"ERROR\")))","v":"Based on 3.13.1"}]
[null,null,"3.13.4","Litigation Contingency Report Form",null,{"$f":"IF(F48=\"Yes\",\"Based on 3.13.1\",IF(F48=\"No\",\"No\",IF(F48=\"\",\"\",\"ERROR\")))","v":"Based on 3.13.1"}]
[3.14,"Disallowances and Penalties Reporting Package",null,null,{"$f":"IF(OR(F52=\"Yes\")=FALSE,\"Not Required\",\"Due\"&\" \"&Resources!D18)","v":"Not Required"}]
[null,null,"3.14.1","Disallowances and Penalties Reporting Form",null,{"$f":"IF('2.0.1'!G110=\"Yes\",\"Yes\",IF('2.0.1'!G110=\"No\",\"No\",IF('2.0.1'!G110=\"\",\"\",\"ERROR\")))","v":"No"}]
[3.15,"Claims Reporting Package",null,null,{"$f":"IF(OR(F54=\"Yes\",F55=\"Yes\")=FALSE,\"Not Required\",\"Due\"&\" \"&Resources!D19)","v":"Not Required"}]
[null,null,"3.15.1","Claims Summary Form",null,{"$f":"IF('2.0.1'!G386=\"Yes\",\"Yes\",IF('2.0.1'!G386=\"No\",\"No\",IF('2.0.1'!G386=\"\",\"\",\"ERROR\")))","v":"No"}]
[null,null,"3.15.2","Additional Claims Information Form",null,{"$f":"IF('2.0.1'!G386=\"Yes\",\"Yes\",IF('2.0.1'!G386=\"No\",\"No\",IF('2.0.1'!G386=\"\",\"\",\"ERROR\")))","v":"No"}]
[3.16,"Miscellaneous Loss Liabilities, Loss Contingencies, and Commitments Reporting Package",null,null,{"$f":"IF(OR(F57=\"Yes\",F58=\"Yes\",F59=\"Yes\")=FALSE,\"Not Required\",\"Due\"&\" \"&Resources!D20)","v":"Due 8/9/2019"}]
[null,null,"3.16.1","Miscellaneous Loss Liabilities Report Form",null,{"$f":"IF(OR('2.0.1'!G394=\"Yes\",'2.0.1'!G406=\"Yes\",'2.0.1'!P292=\"Yes\"),\"Yes\",IF(OR('2.0.1'!G394=\"No\",'2.0.1'!G406=\"No\",'2.0.1'!P292=\"Yes\"),\"No\",IF('2.0.1'!G394=\"\",\"\",\"ERROR\")))","v":"Yes"}]
[null,null,"3.16.2","Miscellaneous Loss Contingency Report Form",null,{"$f":"IF(OR('2.0.1'!G394=\"Yes\",'2.0.1'!G406=\"Yes\",'2.0.1'!P292=\"Yes\"),\"Yes\",IF(OR('2.0.1'!G394=\"No\",'2.0.1'!G406=\"No\",'2.0.1'!P292=\"Yes\"),\"No\",IF('2.0.1'!G394=\"\",\"\",\"ERROR\")))","v":"Yes"}]
[null,null,"3.16.3","Significant Miscellaneous Commitments Form",null,{"$f":"IF(OR('2.0.1'!G394=\"Yes\",'2.0.1'!G406=\"Yes\",'2.0.1'!P292=\"Yes\"),\"Yes\",IF(OR('2.0.1'!G394=\"No\",'2.0.1'!G406=\"No\",'2.0.1'!P292=\"Yes\"),\"No\",IF('2.0.1'!G394=\"\",\"\",\"ERROR\")))","v":"Yes"}]
[3.17,"Not Currently In Use"]
[3.18,"Interfund Payables Reporting Package",null,null,{"$f":"IF(OR(F62=\"Yes\",F63=\"Yes\")=FALSE,\"Not Required\",\"Due\"&\" \"&Resources!D21)","v":"Due 8/23/2019"}]
[null,null,"3.18.1","Interfund Payable Summary Form",null,{"$f":"IF('2.0.1'!G238=\"Yes\",\"Yes\",IF('2.0.1'!G238=\"No\",\"No\",IF('2.0.1'!G238=\"\",\"\",\"ERROR\")))","v":"Yes"}]
[null,null,"3.18.2","Interfund Receivables Summary Form",null,{"$f":"IF('2.0.1'!G244=\"Yes\",\"Yes\",IF('2.0.1'!G244=\"No\",\"No\",IF('2.0.1'!G244=\"\",\"\",\"ERROR\")))","v":"Yes"}]
[3.19,"Not Currently In Use"]
[3.2,"Fund Balance and Net Position (Net Asset) Reporting Package",null,null,{"$f":"IF(OR(F66=\"Yes\",F67=\"Yes\")=FALSE,\"Not Required\",\"Due\"&\" \"&Resources!D22)","v":"Due 8/23/2019"}]
[null,null,"3.20.1","Fund Balance And Net Asset Summary Form",null,{"$f":"IF(AgencyCode=\"\",\"\",\"Yes\")","v":"Yes"}]
[null,null,"3.20.2","Fund Use And Reporting Fund Types Form",null,{"$f":"IF(AgencyCode=\"\",\"\",\"Yes\")","v":"Yes"}]
[]
[]
["Additional Required Submissions"]
["Question"]
[{"$f":"'2.0.1'!A65","v":7},null,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 before September 12.  ",{"$f":"IF('2.0.1'!G65=\"Yes\",\"Required with the Master Closing Package\",\"Not Required\")","v":"Not Required"}]
[]
[{"$f":"'2.0.1'!A105","v":15},null,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'!G105=\"Yes\",\"Required with the Master Closing Package\",\"Not Required\")","v":"Not Required"}]
[]
[{"$f":"'2.0.1'!A170&\".a\"","v":"27.a"},null,null,{"$f":"IF('2.0.1'!G172=\"\",\"\",IF('2.0.1'!G172=\"Yes\",\"RESPOND AS NEEDED TO Sub-question I below.\",\"Action:    Provide the following:  Lease start date, amount of lease, vendor, equipment being leased,\"))","v":""},{"$f":"IF('2.0.1'!G172=\"Yes\",\"Required with the Master Closing Package\",\"Not Required\")","v":"Not Required"}]
[]
["27.a.i",null,null,{"$f":"IF('2.0.1'!G176=\"\",\"\",IF('2.0.1'!G176=\"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('2.0.1'!G176=\"No\",\"Required with the Master Closing Package\",\"Not Required\")","v":"Not Required"}]
[]
[28,null,null,"What assurances does the agency have that all leases have been accounted for and recorded.",{"$f":"IF('2.0.1'!G188=\"No\",\"Required with the Master Closing Package\",\"Not Required\")","v":"Required with the Master Closing Package"}]
[]
[{"$f":"'2.0.1'!A273","v":38},null,null,"Describe the situation in a letter or other attachment when you return thisReporting Package Control Checklist to the Comptroller General's Office.  Please provide copies of signed agreements for any new loans.",{"$f":"IF('2.0.1'!G273=\"Yes\",\"Required with the Master Closing Package\",\"Not Required\")","v":"Not Required"}]
[]
[{"$f":"'2.0.1'!A278","v":39},null,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'!G278=\"Yes\",\"Required with the Master Closing Package\",\"Not Required\")","v":"Not Required"}]
[]
[{"$f":"'2.0.1'!A283","v":40},null,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'!G283=\"Yes\",\"Required with the Master Closing Package\",\"Not Required\")","v":"Not Required"}]
[]
[{"$f":"'2.0.1'!A322","v":43},null,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'!G322=\"Yes\",\"Required with the Master Closing Package\",\"Not Required\")","v":"Not Required"}]
[]
[{"$f":"'2.0.1'!A350","v":45},null,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'!G350=\"Yes\",\"Required with the Master Closing Package\",\"Not Required\")","v":"Not Required"}]
[]
[{"$f":"'2.0.1'!A358","v":46},null,null,"Describe the situation in a letter or other attachment to this ReportingPackage 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'!G371=\"Yes\",\"Required with the Master Closing Package\",\"Not Required\")","v":"Not Required"}]
[]
[{"$f":"'2.0.1'!A376","v":47},null,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 no later than August 15.",{"$f":"IF('2.0.1'!G366=\"Yes\",\"Required with the Master Closing Package\",\"Not Required\")","v":"Not Required"}]
[]
[{"$f":"'2.0.1'!A411","v":52},null,null,"Describe the situation in a letter or other attachment when you return thisReporting Package Checklist to the Comptroller General's Office.  Be sure to fully describe the activity and whether you self-insure theactivity, purchase insurance to cover the activity, or provide insurancecoverage to other entities for this activity.  Also, please include the nameand phone number of a person within your agency that we may contact to obtain additional information,  if necessary.",{"$f":"IF('2.0.1'!G411=\"Yes\",\"Required with the Master Closing Package\",\"Not Required\")","v":"Not Required"}]
[]
[{"$f":"'2.0.1'!A416","v":53},null,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'sOffice.",{"$f":"IF('2.0.1'!G416=\"Yes\",\"Required with the Master Closing Package\",\"Not Required\")","v":"Not Required"}]
[]
[{"$f":"'2.0.1'!A421","v":54},null,null,"Describe the situation on agency letterhead signed by the Agency Directoror 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'!G421=\"Yes\",\"Required with the Master Closing Package\",\"Not Required\")","v":"Not Required"}]
[]
[{"$f":"'2.0.1'!A426","v":55},null,null,"Describe the situation on agency letterhead signed by the Agency Directoror 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 strenthen the internal controls that may have been breached if the allegations prove true.",{"$f":"IF('2.0.1'!G426=\"Yes\",\"Required with the Master Closing Package\",\"Not Required\")","v":"Not Required"}]
[]
[{"$f":"'2.0.1'!A431","v":56},null,null,"Provide copies of the communications and a summary of the correctiveactions when this Reporting Package Checklist is returned to theComptroller General's Office.  ",{"$f":"IF('2.0.1'!G431=\"Yes\",\"Required with the Master Closing Package\",\"Not Required\")","v":"Not Required"}]
[]
[{"$f":"'2.0.1'!A436","v":57},null,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'!G436=\"Yes\",\"Required with the Master Closing Package\",\"Not Required\")","v":"Not Required"}]
[]
[{"$f":"'2.0.1'!A447&\".a\"","v":"58.a"},null,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 theevent when this Reporting Package Checklist is returned to the Comptroller General's Office.",{"$f":"IF('2.0.1'!G449=\"Yes\",\"Required with the Master Closing Package\",\"Not Required\")","v":"Not Required"}]
[]
[{"$f":"'2.0.1'!A447&\".b\"","v":"58.b"},null,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 theevent when this Reporting Package Checklist is returned to the Comptroller General's Office.",{"$f":"IF('2.0.1'!G453=\"Yes\",\"Required with the Master Closing Package\",\"Not Required\")","v":"Not Required"}]
[]
[{"$f":"'2.0.1'!A447&\".c\"","v":"58.c"},null,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 theevent when this Reporting Package Checklist is returned to the Comptroller General's Office.",{"$f":"IF('2.0.1'!G457=\"Yes\",\"Required with the Master Closing Package\",\"Not Required\")","v":"Not Required"}]
[]
[{"$f":"'2.0.1'!A447&\".d\"","v":"58.d"},null,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 theevent when this Reporting Package Checklist is returned to the Comptroller General's Office.",{"$f":"IF('2.0.1'!G461=\"Yes\",\"Required with the Master Closing Package\",\"Not Required\")","v":"Not Required"}]
[]
[{"$f":"'2.0.1'!A447&\".e\"","v":"58.e"},null,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 theevent when this Reporting Package Checklist is returned to the Comptroller General's Office.",{"$f":"IF('2.0.1'!G465=\"Yes\",\"Required with the Master Closing Package\",\"Not Required\")","v":"Not Required"}]

{"sheet":"Resources","index":5,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,2,1,3],[1,7,1,8],[14,0,15,0],[14,1,15,1],[14,2,15,2],[14,3,15,3],[14,5,15,5]]}
[]
["Package","Package Name","Package Due Day & Date",null,"Not Before","CG's Office Contact","Phone Number","SCEIS Report Name & Date Report is Scheduled to be Sent"]
[2,"Master Reporting Checklist",{"$f":"TEXT(D3,\"dddd\")","v":"Friday"},"7/5/2019",null,"John Morrison","803-734-5043"]
[2.0099999999999998,"Subsequent Event ","Monday","10/21/2019","10/7/2019","Laura Showe","803-734-4178"]
[3.01,"Cash and Investments","Friday","7/19/2019",null,"John Morrison","803-734-5043","Yearend Rptg - Cash & Investments","2019-07-12"]
[3.02,"Tax Revenue","Friday","8/9/2019",null,"John Morrison","803-734-5043"]
[3.03,"Grant and Contributions Revenue","Friday","9/13/2019",null,"Laura Showe","803-734-4178","Yearend Rptg - AR (Contributions)\nYearend Rptg - Schedule of Expenditures of Fed Awards (SEFA)","2019-09-03"]
[3.04,"Other Receivables","Friday","8/9/2019",null,"Kelly Ghent","803-734-0272","Yearend Rptg – Accounts Receivable Current with Customer","2019-08-01"]
[3.05,"Unearned Revenue","Friday","8/23/2019",null,"Kelly Ghent","803-734-0272"]
[3.06,"Inventory","Friday","8/9/2019",null,"Kelly Ghent","803-734-0272","Yearend Rptg - AR (Contributions)","2019-08-01"]
[3.07,"Prepaid Expenses","Friday","8/23/2019",null,"Kelly Ghent","803-734-0272","Yearend Rptg - Prepaid Expenses","2019-08-09"]
[3.08,"Capital Assets","Friday","9/13/2019",null,"Laura Showe","803-734-4178","Yearend Rptg - Asset History Sheet","2019-09-03"]
[3.09,"Operating Leases","Friday","8/23/2019",null,"Laura Showe","803-734-4178","Yearend Rptg - Operating Lease Expense w/Vendor","2019-08-09"]
[3.1,"Loans Receivable","Friday","7/19/2019",null,"John Morrison","803-734-5043"]
[3.12,"Accounts Payable","Friday","9/13/2019",null,"Kelly Ghent","803-734-0272","Yearend Rptg - Prior Year Payables with Vendor","2019-09-03"]
[null,null,null,null,null,null,"803-734-0272","Yearend Rptg - Prior Year Payables with Vendor","2019-09-11"]
[3.13,"Litigation","Friday","7/19/2019",null,"Laura Showe","803-734-4178","Yearend Rpt - Litigation Expense","2019-07-12"]
[3.14,"Disallowances and Penalties","Friday","7/19/2019",null,"Kelly Ghent","803-734-0272"]
[3.15,"Claims","Friday","8/9/2019",null,"David Starkey","803-734-2542"]
[3.16,"Misc Loss Liabilities","Friday","8/9/2019",null,"Laura Showe","803-734-4178"]
[3.18,"Interfund Payable","Friday","8/23/2019",null,"David Starkey","803-734-2542","Yearend Rptg - Inter-Agency Prior Year Payables with Vendor","2019-08-01"]
[3.2,"Fund Balance","Friday","8/23/2019","8/15/2019","John Morrison","803-734-5043","Year-End Reporting - Fund Balance","2019-08-14"]

{"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":"ZZZZ"},{"$f":"AgencyName","v":"EXAMPLE AGENCY"},{"$f":"Year","v":2019},{"$f":"'2.0.1'!A27","v":1},{"$f":"'2.0.1'!C27","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'!G27=\"\",\"\",'2.0.1'!G27)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A29=\"\",E2,'2.0.1'!A29)","v":1},{"$f":"IF('2.0.1'!C29=\"\",\"\",'2.0.1'!C29)","v":"a.  Has a review of general ledger balances been performed at an agency wide level? "},{"$f":"IF('2.0.1'!G29=\"\",\"\",'2.0.1'!G29)","v":"Yes"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A31=\"\",E3,'2.0.1'!A31)","v":1},{"$f":"IF('2.0.1'!C31=\"\",\"\",'2.0.1'!C31)","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'!G31=\"\",\"\",'2.0.1'!G31)","v":"No"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A33=\"\",E4,'2.0.1'!A33)","v":1},{"$f":"IF('2.0.1'!C33=\"\",\"\",'2.0.1'!C33)","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'!G33=\"\",\"\",'2.0.1'!G33)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A36=\"\",E5,'2.0.1'!A36)","v":2},{"$f":"IF('2.0.1'!C36=\"\",\"\",'2.0.1'!C36)","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'!G36=\"\",\"\",'2.0.1'!G36)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A38=\"\",E6,'2.0.1'!A38)","v":2},{"$f":"IF('2.0.1'!C38=\"\",\"\",'2.0.1'!C38)","v":"a.  Has a review of general ledger balances been performed at the accounting (detailed) fund level? "},{"$f":"IF('2.0.1'!G38=\"\",\"\",'2.0.1'!G38)","v":"Yes"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A40=\"\",E7,'2.0.1'!A40)","v":2},{"$f":"IF('2.0.1'!C40=\"\",\"\",'2.0.1'!C40)","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'!G40=\"\",\"\",'2.0.1'!G40)","v":"Yes"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A42=\"\",E8,'2.0.1'!A42)","v":2},{"$f":"IF('2.0.1'!C42=\"\",\"\",'2.0.1'!C42)","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'!G42=\"\",\"\",'2.0.1'!G42)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A45=\"\",E9,'2.0.1'!A45)","v":3},{"$f":"IF('2.0.1'!C45=\"\",\"\",'2.0.1'!C45)","v":"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.)"},{"$f":"IF('2.0.1'!G45=\"\",\"\",'2.0.1'!G45)","v":"Yes"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A47=\"\",E10,'2.0.1'!A47)","v":3},{"$f":"IF('2.0.1'!C47=\"\",\"\",'2.0.1'!C47)","v":"Action:  A Cash and Investments Reporting Package is required.  (See Section 3.01)"},{"$f":"IF('2.0.1'!G47=\"\",\"\",'2.0.1'!G47)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A50=\"\",E11,'2.0.1'!A50)","v":4},{"$f":"IF('2.0.1'!C50=\"\",\"\",'2.0.1'!C50)","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'!G50=\"\",\"\",'2.0.1'!G50)","v":"Yes"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A52=\"\",E12,'2.0.1'!A52)","v":4},{"$f":"IF('2.0.1'!C52=\"\",\"\",'2.0.1'!C52)","v":"Action:  A Cash and Investments Reporting Package is required.  (See Section 3.01)"},{"$f":"IF('2.0.1'!G52=\"\",\"\",'2.0.1'!G52)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A55=\"\",E13,'2.0.1'!A55)","v":5},{"$f":"IF('2.0.1'!C55=\"\",\"\",'2.0.1'!C55)","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'!G55=\"\",\"\",'2.0.1'!G55)","v":"Yes"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A57=\"\",E14,'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","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A60=\"\",E15,'2.0.1'!A60)","v":6},{"$f":"IF('2.0.1'!C60=\"\",\"\",'2.0.1'!C60)","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'!G60=\"\",\"\",'2.0.1'!G60)","v":"No"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A62=\"\",E16,'2.0.1'!A62)","v":6},{"$f":"IF('2.0.1'!C62=\"\",\"\",'2.0.1'!C62)","v":"Action: A Tax Revenues Reporting Package is required.  (See Section 3.02)"},{"$f":"IF('2.0.1'!G62=\"\",\"\",'2.0.1'!G62)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A65=\"\",E17,'2.0.1'!A65)","v":7},{"$f":"IF('2.0.1'!C65=\"\",\"\",'2.0.1'!C65)","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'!G65=\"\",\"\",'2.0.1'!G65)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A67=\"\",E18,'2.0.1'!A67)","v":7},{"$f":"IF('2.0.1'!C67=\"\",\"\",'2.0.1'!C67)","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 before September 6.  "},{"$f":"IF('2.0.1'!G67=\"\",\"\",'2.0.1'!G67)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A70=\"\",E19,'2.0.1'!A70)","v":8},{"$f":"IF('2.0.1'!C70=\"\",\"\",'2.0.1'!C70)","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'!G70=\"\",\"\",'2.0.1'!G70)","v":"Yes"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A72=\"\",E20,'2.0.1'!A72)","v":8},{"$f":"IF('2.0.1'!C72=\"\",\"\",'2.0.1'!C72)","v":"Action:  A Grants and Contribution Revenue Reporting Package is required.  (See Section 3.03)"},{"$f":"IF('2.0.1'!G72=\"\",\"\",'2.0.1'!G72)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A75=\"\",E21,'2.0.1'!A75)","v":9},{"$f":"IF('2.0.1'!C75=\"\",\"\",'2.0.1'!C75)","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'!G75=\"\",\"\",'2.0.1'!G75)","v":"No"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A77=\"\",E22,'2.0.1'!A77)","v":9},{"$f":"IF('2.0.1'!C77=\"\",\"\",'2.0.1'!C77)","v":"Action:  A Grants and Contribution Revenue Reporting Package is required.  (See Section 3.03)"},{"$f":"IF('2.0.1'!G77=\"\",\"\",'2.0.1'!G77)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A80=\"\",E23,'2.0.1'!A80)","v":10},{"$f":"IF('2.0.1'!C80=\"\",\"\",'2.0.1'!C80)","v":"Did your agency have any outstanding loans or notes receivable from non-State parties at the beginning of the year (July 1, 2017) or end of the year (June 30, 2018)?"},{"$f":"IF('2.0.1'!G80=\"\",\"\",'2.0.1'!G80)","v":"No"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A82=\"\",E24,'2.0.1'!A82)","v":10},{"$f":"IF('2.0.1'!C82=\"\",\"\",'2.0.1'!C82)","v":"Action:  A Loan Receivables Reporting Package is required.  (See Section 3.10)"},{"$f":"IF('2.0.1'!G82=\"\",\"\",'2.0.1'!G82)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A85=\"\",E25,'2.0.1'!A85)","v":11},{"$f":"IF('2.0.1'!C85=\"\",\"\",'2.0.1'!C85)","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'!G85=\"\",\"\",'2.0.1'!G85)","v":"No"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A87=\"\",E26,'2.0.1'!A87)","v":11},{"$f":"IF('2.0.1'!C87=\"\",\"\",'2.0.1'!C87)","v":"Action:  A Other Receivables Reporting Package is required.  (See Section 3.04)"},{"$f":"IF('2.0.1'!G87=\"\",\"\",'2.0.1'!G87)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A90=\"\",E27,'2.0.1'!A90)","v":12},{"$f":"IF('2.0.1'!C90=\"\",\"\",'2.0.1'!C90)","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'!G90=\"\",\"\",'2.0.1'!G90)","v":"Yes"}]
["2.0.1",{"$f":"AgencyCode","v":"ZZZZ"},{"$f":"AgencyName","v":"EXAMPLE AGENCY"},{"$f":"Year","v":2019},{"$f":"IF('2.0.1'!A92=\"\",E28,'2.0.1'!A92)","v":12},{"$f":"IF('2.0.1'!C92=\"\",\"\",'2.0.1'!C92)","v":"Action:  A Other Receivables Reporting Package is required.  (See Section 3.04)"},{"$f":"IF('2.0.1'!G92=\"\",\"\",'2.0.1'!G92)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A95=\"\",E29,'2.0.1'!A95)","v":13},{"$f":"IF('2.0.1'!C95=\"\",\"\",'2.0.1'!C95)","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'!G95=\"\",\"\",'2.0.1'!G95)","v":"Yes"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A97=\"\",E30,'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","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A100=\"\",E31,'2.0.1'!A100)","v":14},{"$f":"IF('2.0.1'!C100=\"\",\"\",'2.0.1'!C100)","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'!G100=\"\",\"\",'2.0.1'!G100)","v":"No"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A102=\"\",E32,'2.0.1'!A102)","v":14},{"$f":"IF('2.0.1'!C102=\"\",\"\",'2.0.1'!C102)","v":"Action:  A Unearned Revenue Reporting Package is required.  (See Section 3.05)"},{"$f":"IF('2.0.1'!G102=\"\",\"\",'2.0.1'!G102)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A105=\"\",E33,'2.0.1'!A105)","v":15},{"$f":"IF('2.0.1'!C105=\"\",\"\",'2.0.1'!C105)","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'!G105=\"\",\"\",'2.0.1'!G105)","v":"No"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A107=\"\",E34,'2.0.1'!A107)","v":15},{"$f":"IF('2.0.1'!C107=\"\",\"\",'2.0.1'!C107)","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 Reporting Package Checklist to the Comptroller General's Office."},{"$f":"IF('2.0.1'!G107=\"\",\"\",'2.0.1'!G107)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A110=\"\",E35,'2.0.1'!A110)","v":16},{"$f":"IF('2.0.1'!C110=\"\",\"\",'2.0.1'!C110)","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'!G110=\"\",\"\",'2.0.1'!G110)","v":"No"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A112=\"\",E36,'2.0.1'!A112)","v":16},{"$f":"IF('2.0.1'!C112=\"\",\"\",'2.0.1'!C112)","v":"Action:  A Disallowances and Penalties Reporting Package is required (See Section 3.14)."},{"$f":"IF('2.0.1'!G112=\"\",\"\",'2.0.1'!G112)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A115=\"\",E37,'2.0.1'!A115)","v":17},{"$f":"IF('2.0.1'!C115=\"\",\"\",'2.0.1'!C115)","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'!G115=\"\",\"\",'2.0.1'!G115)","v":"No"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A117=\"\",E38,'2.0.1'!A117)","v":17},{"$f":"IF('2.0.1'!C117=\"\",\"\",'2.0.1'!C117)","v":"Action: The subsequent events reporting package will request additional information, such asthe 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'!G117=\"\",\"\",'2.0.1'!G117)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A120=\"\",E39,'2.0.1'!A120)","v":18},{"$f":"IF('2.0.1'!C120=\"\",\"\",'2.0.1'!C120)","v":"Did your agency have inventory on hand at year-end? "},{"$f":"IF('2.0.1'!G120=\"\",\"\",'2.0.1'!G120)","v":"Yes"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A122=\"\",E40,'2.0.1'!A122)","v":18},{"$f":"IF('2.0.1'!C122=\"\",\"\",'2.0.1'!C122)","v":"Action: An Inventory Reporting Package is required (See Section 3.06)."},{"$f":"IF('2.0.1'!G122=\"\",\"\",'2.0.1'!G122)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A125=\"\",E42,'2.0.1'!A125)","v":19},{"$f":"IF('2.0.1'!C125=\"\",\"\",'2.0.1'!C125)","v":"Did your agency have United States Department of Agriculture food supplies (commodities) at year-end?"},{"$f":"IF('2.0.1'!G125=\"\",\"\",'2.0.1'!G125)","v":"No"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A127=\"\",E42,'2.0.1'!A127)","v":19},{"$f":"IF('2.0.1'!C127=\"\",\"\",'2.0.1'!C127)","v":"Action: An Inventory Reporting Package is required (See Section 3.06)."},{"$f":"IF('2.0.1'!G127=\"\",\"\",'2.0.1'!G127)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A130=\"\",E43,'2.0.1'!A130)","v":20},{"$f":"IF('2.0.1'!C130=\"\",\"\",'2.0.1'!C130)","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'!G130=\"\",\"\",'2.0.1'!G130)","v":"No"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A132=\"\",E44,'2.0.1'!A132)","v":20},{"$f":"IF('2.0.1'!C132=\"\",\"\",'2.0.1'!C132)","v":"Action: A Prepaid Expenses Reporting Package is required (See Section 3.07) ."},{"$f":"IF('2.0.1'!G132=\"\",\"\",'2.0.1'!G132)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A135=\"\",E45,'2.0.1'!A135)","v":21},{"$f":"IF('2.0.1'!C135=\"\",\"\",'2.0.1'!C135)","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'!G135=\"\",\"\",'2.0.1'!G135)","v":"Yes"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A137=\"\",E46,'2.0.1'!A137)","v":21},{"$f":"IF('2.0.1'!C137=\"\",\"\",'2.0.1'!C137)","v":"Action:  A Capital Assets Reporting Package is required (See Section 3.08)."},{"$f":"IF('2.0.1'!G137=\"\",\"\",'2.0.1'!G137)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A140=\"\",E47,'2.0.1'!A140)","v":21},{"$f":"IF('2.0.1'!C140=\"\",\"\",'2.0.1'!C140)","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'!G140=\"\",\"\",'2.0.1'!G140)","v":"No"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A142=\"\",E48,'2.0.1'!A142)","v":21},{"$f":"IF('2.0.1'!C142=\"\",\"\",'2.0.1'!C142)","v":"Action:  A Capital Assets Reporting Package is required (See Section 3.08)."},{"$f":"IF('2.0.1'!G142=\"\",\"\",'2.0.1'!G142)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A145=\"\",E49,'2.0.1'!A145)","v":22},{"$f":"IF('2.0.1'!C145=\"\",\"\",'2.0.1'!C145)","v":"Does your agency own any capital assets at June 30, recorded in SCEIS or other reporting?"},{"$f":"IF('2.0.1'!G145=\"\",\"\",'2.0.1'!G145)","v":"Yes"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A147=\"\",E50,'2.0.1'!A147)","v":22},{"$f":"IF('2.0.1'!C147=\"\",\"\",'2.0.1'!C147)","v":"Action:  A Capital Assets Reporting Package is required (See Section 3.08)."},{"$f":"IF('2.0.1'!G147=\"\",\"\",'2.0.1'!G147)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A150=\"\",E51,'2.0.1'!A150)","v":23},{"$f":"IF('2.0.1'!C150=\"\",\"\",'2.0.1'!C150)","v":"Did your agency recognize any non-cash contributions or transfers of assets during the fiscal year?"},{"$f":"IF('2.0.1'!G150=\"\",\"\",'2.0.1'!G150)","v":"No"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A152=\"\",E52,'2.0.1'!A152)","v":23},{"$f":"IF('2.0.1'!C152=\"\",\"\",'2.0.1'!C152)","v":"Action:  A Capital Assets Reporting Package is required (See Section 3.08)."},{"$f":"IF('2.0.1'!G152=\"\",\"\",'2.0.1'!G152)","v":""}]
["2.0.1",{"$f":"AgencyCode","v":"ZZZZ"},{"$f":"AgencyName","v":"EXAMPLE AGENCY"},{"$f":"Year","v":2019},{"$f":"IF('2.0.1'!A155=\"\",E53,'2.0.1'!A155)","v":24},{"$f":"IF('2.0.1'!C155=\"\",\"\",'2.0.1'!C155)","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'!G155=\"\",\"\",'2.0.1'!G155)","v":"Yes"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A157=\"\",E54,'2.0.1'!A157)","v":24},{"$f":"IF('2.0.1'!C157=\"\",\"\",'2.0.1'!C157)","v":"Action:  An Operating Leases Reporting Package is required (See Section 3.09)."},{"$f":"IF('2.0.1'!G157=\"\",\"\",'2.0.1'!G157)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A160=\"\",E55,'2.0.1'!A160)","v":25},{"$f":"IF('2.0.1'!C160=\"\",\"\",'2.0.1'!C160)","v":"Does your agency have noncancelable operating leases in effect at June 30 with future minimum required payments?"},{"$f":"IF('2.0.1'!G160=\"\",\"\",'2.0.1'!G160)","v":"No"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A162=\"\",E56,'2.0.1'!A162)","v":25},{"$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","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A165=\"\",E57,'2.0.1'!A165)","v":26},{"$f":"IF('2.0.1'!C165=\"\",\"\",'2.0.1'!C165)","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'!G165=\"\",\"\",'2.0.1'!G165)","v":"No"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A167=\"\",E58,'2.0.1'!A167)","v":26},{"$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","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A170=\"\",E59,'2.0.1'!A170)","v":27},{"$f":"IF('2.0.1'!C170=\"\",\"\",'2.0.1'!C170)","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'!G170=\"\",\"\",'2.0.1'!G170)","v":"No"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A172=\"\",E60,'2.0.1'!A172)","v":27},{"$f":"IF('2.0.1'!C172=\"\",\"\",'2.0.1'!C172)","v":"a.  Have the capital lease and terms of the contract been reported to the CG's office?"},{"$f":"IF('2.0.1'!G172=\"\",\"\",'2.0.1'!G172)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A174=\"\",E61,'2.0.1'!A174)","v":27},{"$f":"IF('2.0.1'!C174=\"\",\"\",'2.0.1'!C174)","v":""},{"$f":"IF('2.0.1'!G174=\"\",\"\",'2.0.1'!G174)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A176=\"\",E61,'2.0.1'!A176)","v":27},{"$f":"IF('2.0.1'!C176=\"\",\"\",'2.0.1'!C176)","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'!G176=\"\",\"\",'2.0.1'!G176)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A178=\"\",E63,'2.0.1'!A178)","v":27},{"$f":"IF('2.0.1'!C178=\"\",\"\",'2.0.1'!C178)","v":""},{"$f":"IF('2.0.1'!G178=\"\",\"\",'2.0.1'!G178)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A180=\"\",E64,'2.0.1'!A180)","v":27},null,{"$f":"IF('2.0.1'!C180=\"\",\"\",'2.0.1'!C180)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A181=\"\",E65,'2.0.1'!A181)","v":27},null,{"$f":"IF('2.0.1'!C181=\"\",\"\",'2.0.1'!C181)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A182=\"\",E66,'2.0.1'!A182)","v":27},null,{"$f":"IF('2.0.1'!C182=\"\",\"\",'2.0.1'!C182)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A183=\"\",E67,'2.0.1'!A183)","v":27},null,{"$f":"IF('2.0.1'!C183=\"\",\"\",'2.0.1'!C183)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A184=\"\",E68,'2.0.1'!A184)","v":27},null,{"$f":"IF('2.0.1'!C184=\"\",\"\",'2.0.1'!C184)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A188=\"\",E69,'2.0.1'!A188)","v":28},{"$f":"IF('2.0.1'!C188=\"\",\"\",'2.0.1'!C188)","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'!G188=\"\",\"\",'2.0.1'!G188)","v":"No"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A189=\"\",E70,'2.0.1'!A189)","v":28},{"$f":"IF('2.0.1'!C190=\"\",\"\",'2.0.1'!C190)","v":"Action:  What assurances does the agency have that all leases have been accounted for and recorded."},{"$f":"IF('2.0.1'!G190=\"\",\"\",'2.0.1'!G190)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A193=\"\",E71,'2.0.1'!A193)","v":29},{"$f":"IF('2.0.1'!C193=\"\",\"\",'2.0.1'!C193)","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'!G193=\"\",\"\",'2.0.1'!G193)","v":"Yes"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A195=\"\",E72,'2.0.1'!A195)","v":29},{"$f":"IF('2.0.1'!C195=\"\",\"\",'2.0.1'!C195)","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'!G195=\"\",\"\",'2.0.1'!G195)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A198=\"\",E73,'2.0.1'!A198)","v":30},{"$f":"IF('2.0.1'!C198=\"\",\"\",'2.0.1'!C198)","v":"Did your agency recognize expenditures in period 12 (June 1 - June 30) of the fiscal year? "},{"$f":"IF('2.0.1'!G198=\"\",\"\",'2.0.1'!G198)","v":"Yes"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A200=\"\",E74,'2.0.1'!A200)","v":30},{"$f":"IF('2.0.1'!C200=\"\",\"\",'2.0.1'!C200)","v":"Action:  None, this related to the year-end cut-off procedures."},{"$f":"IF('2.0.1'!G200=\"\",\"\",'2.0.1'!G200)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A203=\"\",E75,'2.0.1'!A203)","v":31},{"$f":"IF('2.0.1'!C203=\"\",\"\",'2.0.1'!C203)","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'!G203=\"\",\"\",'2.0.1'!G203)","v":"Yes"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A206=\"\",E76,'2.0.1'!A206)","v":31},{"$f":"IF('2.0.1'!C206=\"\",\"\",'2.0.1'!C206)","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'!G206=\"\",\"\",'2.0.1'!G206)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A209=\"\",E77,'2.0.1'!A209)","v":32},{"$f":"IF('2.0.1'!C209=\"\",\"\",'2.0.1'!C209)","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'!G209=\"\",\"\",'2.0.1'!G209)","v":"Yes"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A211=\"\",E78,'2.0.1'!A211)","v":32},{"$f":"IF('2.0.1'!C211=\"\",\"\",'2.0.1'!C211)","v":"Action:  Provide the following information:"},{"$f":"IF('2.0.1'!G211=\"\",\"\",'2.0.1'!G211)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A213=\"\",E79,'2.0.1'!A213)","v":32},"Fund 1",{"$f":"IF('2.0.1'!C214=\"\",\"\",'2.0.1'!C214)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A214=\"\",E80,'2.0.1'!A214)","v":32},"Fund 2",{"$f":"IF('2.0.1'!C215=\"\",\"\",'2.0.1'!C215)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A215=\"\",E81,'2.0.1'!A215)","v":32},"Fund 3",{"$f":"IF('2.0.1'!C216=\"\",\"\",'2.0.1'!C216)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A213=\"\",E82,'2.0.1'!A213)","v":32},"Employee Grass Pay 1",{"$f":"IF('2.0.1'!E214=\"\",\"\",'2.0.1'!E214)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A214=\"\",E83,'2.0.1'!A214)","v":32},"Employee Grass Pay 2",{"$f":"IF('2.0.1'!E215=\"\",\"\",'2.0.1'!E215)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A215=\"\",E84,'2.0.1'!A215)","v":32},"Employee Grass Pay 3",{"$f":"IF('2.0.1'!E216=\"\",\"\",'2.0.1'!E216)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A213=\"\",E85,'2.0.1'!A213)","v":32},"Dates to be paid 1",{"$f":"IF('2.0.1'!G214=\"\",\"\",'2.0.1'!G214)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A214=\"\",E86,'2.0.1'!A214)","v":32},"Dates to be paid 2",{"$f":"IF('2.0.1'!G215=\"\",\"\",'2.0.1'!G215)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A215=\"\",E87,'2.0.1'!A215)","v":32},"Dates to be paid 3",{"$f":"IF('2.0.1'!G216=\"\",\"\",'2.0.1'!G216)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A218=\"\",E88,'2.0.1'!A218)","v":33},{"$f":"IF('2.0.1'!C218=\"\",\"\",'2.0.1'!C218)","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'!G218=\"\",\"\",'2.0.1'!G218)","v":"Yes"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A220=\"\",E89,'2.0.1'!A220)","v":33},{"$f":"IF('2.0.1'!C220=\"\",\"\",'2.0.1'!C220)","v":"Action:  Provide the following information:"},{"$f":"IF('2.0.1'!G220=\"\",\"\",'2.0.1'!G220)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A222=\"\",E90,'2.0.1'!A222)","v":33},"Fund 1",{"$f":"IF('2.0.1'!C223=\"\",\"\",'2.0.1'!C223)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A223=\"\",E91,'2.0.1'!A223)","v":33},"Fund 2",{"$f":"IF('2.0.1'!C224=\"\",\"\",'2.0.1'!C224)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A224=\"\",E92,'2.0.1'!A224)","v":33},"Fund 3",{"$f":"IF('2.0.1'!C225=\"\",\"\",'2.0.1'!C225)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A222=\"\",E93,'2.0.1'!A222)","v":33},"Amount to be paid 1",{"$f":"IF('2.0.1'!E223=\"\",\"\",'2.0.1'!E223)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A223=\"\",E94,'2.0.1'!A223)","v":33},"Amount to be paid 2",{"$f":"IF('2.0.1'!E224=\"\",\"\",'2.0.1'!E224)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A224=\"\",E95,'2.0.1'!A224)","v":33},"Amount to be paid 3",{"$f":"IF('2.0.1'!E225=\"\",\"\",'2.0.1'!E225)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A222=\"\",E96,'2.0.1'!A222)","v":33},"Dates to be paid 1",{"$f":"IF('2.0.1'!G223=\"\",\"\",'2.0.1'!G223)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A223=\"\",E97,'2.0.1'!A223)","v":33},"Dates to be paid 2",{"$f":"IF('2.0.1'!G224=\"\",\"\",'2.0.1'!G224)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A224=\"\",E98,'2.0.1'!A224)","v":33},"Dates to be paid 3",{"$f":"IF('2.0.1'!G225=\"\",\"\",'2.0.1'!G225)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A228=\"\",E99,'2.0.1'!A228)","v":34},{"$f":"IF('2.0.1'!C228=\"\",\"\",'2.0.1'!C228)","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'!G228=\"\",\"\",'2.0.1'!G228)","v":"Yes"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A230=\"\",E100,'2.0.1'!A230)","v":34},{"$f":"IF('2.0.1'!C230=\"\",\"\",'2.0.1'!C230)","v":"Action:  Provide the following information:"},{"$f":"IF('2.0.1'!G230=\"\",\"\",'2.0.1'!G230)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A232=\"\",E101,'2.0.1'!A232)","v":34},"Entity 1",{"$f":"IF('2.0.1'!C233=\"\",\"\",'2.0.1'!C233)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A233=\"\",E102,'2.0.1'!A233)","v":34},"Entity 2",{"$f":"IF('2.0.1'!C234=\"\",\"\",'2.0.1'!C234)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A234=\"\",E103,'2.0.1'!A234)","v":34},"Entity 3",{"$f":"IF('2.0.1'!C235=\"\",\"\",'2.0.1'!C235)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A232=\"\",E104,'2.0.1'!A232)","v":34},"Amount to be paid 1",{"$f":"IF('2.0.1'!E233=\"\",\"\",'2.0.1'!E233)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A233=\"\",E105,'2.0.1'!A233)","v":34},"Amount to be paid 2",{"$f":"IF('2.0.1'!E234=\"\",\"\",'2.0.1'!E234)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A234=\"\",E106,'2.0.1'!A234)","v":34},"Amount to be paid 3",{"$f":"IF('2.0.1'!E235=\"\",\"\",'2.0.1'!E235)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A232=\"\",E107,'2.0.1'!A232)","v":34},"Dates to be paid 1",{"$f":"IF('2.0.1'!G233=\"\",\"\",'2.0.1'!G233)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A233=\"\",E108,'2.0.1'!A233)","v":34},"Dates to be paid 2",{"$f":"IF('2.0.1'!G234=\"\",\"\",'2.0.1'!G234)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A234=\"\",E109,'2.0.1'!A234)","v":34},"Dates to be paid 3",{"$f":"IF('2.0.1'!G235=\"\",\"\",'2.0.1'!G235)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A238=\"\",E110,'2.0.1'!A238)","v":35},{"$f":"IF('2.0.1'!C238=\"\",\"\",'2.0.1'!C238)","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'!G238=\"\",\"\",'2.0.1'!G238)","v":"Yes"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A240=\"\",E111,'2.0.1'!A240)","v":35},{"$f":"IF('2.0.1'!C240=\"\",\"\",'2.0.1'!C240)","v":"Action:  The Interfund Payables Reporting Package is required (See Section 3.18)."},{"$f":"IF('2.0.1'!G240=\"\",\"\",'2.0.1'!G240)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A244=\"\",E112,'2.0.1'!A244)","v":36},{"$f":"IF('2.0.1'!C244=\"\",\"\",'2.0.1'!C244)","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'!G244=\"\",\"\",'2.0.1'!G244)","v":"Yes"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A246=\"\",E113,'2.0.1'!A246)","v":36},{"$f":"IF('2.0.1'!C246=\"\",\"\",'2.0.1'!C246)","v":"Action:  The Interfund Payables Reporting Package is required (See Section 3.18)."},{"$f":"IF('2.0.1'!G246=\"\",\"\",'2.0.1'!G246)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A250=\"\",E114,'2.0.1'!A250)","v":37},{"$f":"IF('2.0.1'!C250=\"\",\"\",'2.0.1'!C250)","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'!G250=\"\",\"\",'2.0.1'!G250)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A256=\"\",E115,'2.0.1'!A256)","v":37},{"$f":"IF('2.0.1'!C256=\"\",\"\",'2.0.1'!C256)","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'!G256=\"\",\"\",'2.0.1'!G256)","v":"No"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A258=\"\",E116,'2.0.1'!A258)","v":37},{"$f":"IF('2.0.1'!C258=\"\",\"\",'2.0.1'!C258)","v":"Action:  Provide the following information (if additional space is needed, click the Show Worksheet 36. (Cont) button below)"},{"$f":"IF('2.0.1'!G258=\"\",\"\",'2.0.1'!G258)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A260=\"\",E117,'2.0.1'!A260)","v":37},{"$f":"IF('2.0.1'!C260=\"\",\"\",'2.0.1'!C260)","v":"Is your agency the lender or borrower?"},{"$f":"IF('2.0.1'!E260=\"\",\"\",'2.0.1'!E260)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A261=\"\",E118,'2.0.1'!A261)","v":37},{"$f":"IF('2.0.1'!C261=\"\",\"\",'2.0.1'!C261)","v":"Name of counter-party (other agency involved)?"},{"$f":"IF('2.0.1'!E261=\"\",\"\",'2.0.1'!E261)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A262=\"\",E119,'2.0.1'!A262)","v":37},{"$f":"IF('2.0.1'!C262=\"\",\"\",'2.0.1'!C262)","v":"Original amount of the loan"},{"$f":"IF('2.0.1'!E262=\"\",\"\",'2.0.1'!E262)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A263=\"\",E120,'2.0.1'!A263)","v":37},{"$f":"IF('2.0.1'!C263=\"\",\"\",'2.0.1'!C263)","v":"Date of the original loan"},{"$f":"IF('2.0.1'!E263=\"\",\"\",'2.0.1'!E263)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A264=\"\",E121,'2.0.1'!A264)","v":37},{"$f":"IF('2.0.1'!C264=\"\",\"\",'2.0.1'!C264)","v":"Additional advances made"},{"$f":"IF('2.0.1'!E264=\"\",\"\",'2.0.1'!E264)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A265=\"\",E122,'2.0.1'!A265)","v":37},{"$f":"IF('2.0.1'!C265=\"\",\"\",'2.0.1'!C265)","v":"Dates of additional advances"},{"$f":"IF('2.0.1'!E265=\"\",\"\",'2.0.1'!E265)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A266=\"\",E123,'2.0.1'!A266)","v":37},{"$f":"IF('2.0.1'!C266=\"\",\"\",'2.0.1'!C266)","v":"Balance as of June 30"},{"$f":"IF('2.0.1'!E266=\"\",\"\",'2.0.1'!E266)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A267=\"\",E124,'2.0.1'!A267)","v":37},{"$f":"IF('2.0.1'!C267=\"\",\"\",'2.0.1'!C267)","v":"Number of Payments required"},{"$f":"IF('2.0.1'!E267=\"\",\"\",'2.0.1'!E267)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A268=\"\",E125,'2.0.1'!A268)","v":37},{"$f":"IF('2.0.1'!C268=\"\",\"\",'2.0.1'!C268)","v":"Frequency of payments required (selections in drop-down)"},{"$f":"IF('2.0.1'!E268=\"\",\"\",'2.0.1'!E268)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A269=\"\",E126,'2.0.1'!A269)","v":37},{"$f":"IF('2.0.1'!C269=\"\",\"\",'2.0.1'!C269)","v":"Copies of signed agreements (for new loans only)."},{"$f":"IF('2.0.1'!E269=\"\",\"\",'2.0.1'!E269)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A273=\"\",E127,'2.0.1'!A273)","v":38},{"$f":"IF('2.0.1'!C273=\"\",\"\",'2.0.1'!C273)","v":"Does your agency have any loans or notes payable/receivable at June 30 between funds within your agency?"},{"$f":"IF('2.0.1'!G273=\"\",\"\",'2.0.1'!G273)","v":"No"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A275=\"\",E128,'2.0.1'!A275)","v":38},{"$f":"IF('2.0.1'!C275=\"\",\"\",'2.0.1'!C275)","v":"Action:  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'!G275=\"\",\"\",'2.0.1'!G275)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A278=\"\",E129,'2.0.1'!A278)","v":39},{"$f":"IF('2.0.1'!C278=\"\",\"\",'2.0.1'!C278)","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'!G278=\"\",\"\",'2.0.1'!G278)","v":"No"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A280=\"\",E130,'2.0.1'!A280)","v":39},{"$f":"IF('2.0.1'!C280=\"\",\"\",'2.0.1'!C280)","v":"Action:  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'!G280=\"\",\"\",'2.0.1'!G280)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A283=\"\",E131,'2.0.1'!A283)","v":40},{"$f":"IF('2.0.1'!C283=\"\",\"\",'2.0.1'!C283)","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'!G283=\"\",\"\",'2.0.1'!G283)","v":"No"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A285=\"\",E132,'2.0.1'!A285)","v":40},{"$f":"IF('2.0.1'!C285=\"\",\"\",'2.0.1'!C285)","v":"Action:  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'!G285=\"\",\"\",'2.0.1'!G285)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A288=\"\",E133,'2.0.1'!A288)","v":41},{"$f":"IF('2.0.1'!C288=\"\",\"\",'2.0.1'!C288)","v":"Did your agency owe refunds of revenue to other parties (excluding income tax refunds) at June 30 but not paid by the end of the fiscal year for which this form is being completed?"},{"$f":"IF('2.0.1'!G288=\"\",\"\",'2.0.1'!G288)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A290=\"\",E134,'2.0.1'!A290)","v":41},{"$f":"IF('2.0.1'!C290=\"\",\"\",'2.0.1'!C290)","v":"Action:   An Accounts Payable Reporting Package is required (See Section 3.12)"},{"$f":"IF('2.0.1'!G290=\"\",\"\",'2.0.1'!G290)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A294=\"\",E135,'2.0.1'!A294)","v":42},{"$f":"IF('2.0.1'!C294=\"\",\"\",'2.0.1'!C294)","v":"The State Treasurer's Office Master Lease Program provides financing for equipment purchasesof $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'!G294=\"\",\"\",'2.0.1'!G294)","v":"No"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A296=\"\",E136,'2.0.1'!A296)","v":42},{"$f":"IF('2.0.1'!C296=\"\",\"\",'2.0.1'!C296)","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'!G296=\"\",\"\",'2.0.1'!G296)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A298=\"\",E137,'2.0.1'!A298)","v":42},{"$f":"IF('2.0.1'!C298=\"\",\"\",'2.0.1'!C298)","v":"Action:  Provide the following information (if additional space is needed, click the Show Worksheet 42. (Cont) button below)"},{"$f":"IF('2.0.1'!G298=\"\",\"\",'2.0.1'!G298)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A300=\"\",E138,'2.0.1'!A300)","v":42},{"$f":"IF('2.0.1'!C300=\"\",\"\",'2.0.1'!C300)","v":"Lease ID #"},{"$f":"IF('2.0.1'!E300=\"\",\"\",'2.0.1'!E300)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A301=\"\",E139,'2.0.1'!A301)","v":42},{"$f":"IF('2.0.1'!C301=\"\",\"\",'2.0.1'!C301)","v":"Amount held in escrow"},{"$f":"IF('2.0.1'!E301=\"\",\"\",'2.0.1'!E301)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A303=\"\",E140,'2.0.1'!A303)","v":42},{"$f":"IF('2.0.1'!C303=\"\",\"\",'2.0.1'!C303)","v":"b.   Did your agency have an escrow account for this program closed out during the fiscal year?"},{"$f":"IF('2.0.1'!G303=\"\",\"\",'2.0.1'!G303)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A305=\"\",E141,'2.0.1'!A305)","v":42},{"$f":"IF('2.0.1'!C305=\"\",\"\",'2.0.1'!C305)","v":"Action:  Provide the following information (if additional space is needed, click the Show Worksheet 42. (Cont) button below)"},{"$f":"IF('2.0.1'!G305=\"\",\"\",'2.0.1'!G305)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A307=\"\",E142,'2.0.1'!A307)","v":42},{"$f":"IF('2.0.1'!C307=\"\",\"\",'2.0.1'!C307)","v":"Lease ID #(s)"},{"$f":"IF('2.0.1'!E307=\"\",\"\",'2.0.1'!E307)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A308=\"\",E143,'2.0.1'!A308)","v":42},{"$f":"IF('2.0.1'!C308=\"\",\"\",'2.0.1'!C308)","v":"Date the escrow account was closed checklist."},{"$f":"IF('2.0.1'!E308=\"\",\"\",'2.0.1'!E308)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A310=\"\",E144,'2.0.1'!A310)","v":42},{"$f":"IF('2.0.1'!C310=\"\",\"\",'2.0.1'!C310)","v":"c.  Was an asset(s) established in the SCEIS system?"},{"$f":"IF('2.0.1'!E310=\"\",\"\",'2.0.1'!E310)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A314=\"\",E145,'2.0.1'!A314)","v":42},null,{"$f":"IF('2.0.1'!C314=\"\",\"\",'2.0.1'!C314)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A315=\"\",E146,'2.0.1'!A315)","v":42},null,{"$f":"IF('2.0.1'!C315=\"\",\"\",'2.0.1'!C315)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A316=\"\",E147,'2.0.1'!A316)","v":42},null,{"$f":"IF('2.0.1'!C316=\"\",\"\",'2.0.1'!C316)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A317=\"\",E148,'2.0.1'!A317)","v":42},null,{"$f":"IF('2.0.1'!C317=\"\",\"\",'2.0.1'!C317)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A318=\"\",E149,'2.0.1'!A318)","v":42},null,{"$f":"IF('2.0.1'!C318=\"\",\"\",'2.0.1'!C318)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A322=\"\",E150,'2.0.1'!A322)","v":43},{"$f":"IF('2.0.1'!C322=\"\",\"\",'2.0.1'!C322)","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'!G322=\"\",\"\",'2.0.1'!G322)","v":"No"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A324=\"\",E151,'2.0.1'!A324)","v":43},{"$f":"IF('2.0.1'!C324=\"\",\"\",'2.0.1'!C324)","v":"a.  Did your agency pay off any loans under this program during the fiscal year ended June 30?"},{"$f":"IF('2.0.1'!G324=\"\",\"\",'2.0.1'!G324)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A326=\"\",E152,'2.0.1'!A326)","v":43},{"$f":"IF('2.0.1'!C326=\"\",\"\",'2.0.1'!C326)","v":"Action:  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'!G326=\"\",\"\",'2.0.1'!G326)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A328=\"\",E153,'2.0.1'!A328)","v":43},{"$f":"IF('2.0.1'!C328=\"\",\"\",'2.0.1'!C328)","v":"b.   Did your agency have an escrow account for this program closed out during the fiscal year?"},{"$f":"IF('2.0.1'!G328=\"\",\"\",'2.0.1'!G328)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A330=\"\",E154,'2.0.1'!A330)","v":43},{"$f":"IF('2.0.1'!C330=\"\",\"\",'2.0.1'!C330)","v":"Action:  Provide the following information (if additional space is needed, attach a sheet)"},{"$f":"IF('2.0.1'!G330=\"\",\"\",'2.0.1'!G330)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A332=\"\",E155,'2.0.1'!A332)","v":43},{"$f":"IF('2.0.1'!C332=\"\",\"\",'2.0.1'!C332)","v":"Lease ID #(s)"},{"$f":"IF('2.0.1'!E332=\"\",\"\",'2.0.1'!E332)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A333=\"\",E156,'2.0.1'!A333)","v":43},{"$f":"IF('2.0.1'!C333=\"\",\"\",'2.0.1'!C333)","v":"Date the escrow account was closed checklist."},{"$f":"IF('2.0.1'!E333=\"\",\"\",'2.0.1'!E333)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A336=\"\",E157,'2.0.1'!A336)","v":44},{"$f":"IF('2.0.1'!C336=\"\",\"\",'2.0.1'!C336)","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'!G336=\"\",\"\",'2.0.1'!G336)","v":"No"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A338=\"\",E158,'2.0.1'!A338)","v":44},{"$f":"IF('2.0.1'!C338=\"\",\"\",'2.0.1'!C338)","v":"Action:  Provide the following information (if additional space is needed, click the Show Worksheet 44. (Cont) button below)"},{"$f":"IF('2.0.1'!G338=\"\",\"\",'2.0.1'!G338)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A340=\"\",E159,'2.0.1'!A340)","v":44},{"$f":"IF('2.0.1'!C340=\"\",\"\",'2.0.1'!C340)","v":"Principle"},{"$f":"IF('2.0.1'!G340=\"\",\"\",'2.0.1'!G340)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A341=\"\",E160,'2.0.1'!A341)","v":44},{"$f":"IF('2.0.1'!C341=\"\",\"\",'2.0.1'!C341)","v":"General Ledger Account"},{"$f":"IF('2.0.1'!E341=\"\",\"\",'2.0.1'!E341)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A342=\"\",E161,'2.0.1'!A342)","v":44},{"$f":"IF('2.0.1'!C342=\"\",\"\",'2.0.1'!C342)","v":"Amount"},{"$f":"IF('2.0.1'!E342=\"\",\"\",'2.0.1'!E342)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A344=\"\",E162,'2.0.1'!A344)","v":44},{"$f":"IF('2.0.1'!C344=\"\",\"\",'2.0.1'!C344)","v":"Interest"},{"$f":"IF('2.0.1'!G344=\"\",\"\",'2.0.1'!G344)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A345=\"\",E163,'2.0.1'!A345)","v":44},{"$f":"IF('2.0.1'!C345=\"\",\"\",'2.0.1'!C345)","v":"General Ledger Account"},{"$f":"IF('2.0.1'!E345=\"\",\"\",'2.0.1'!E345)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A346=\"\",E164,'2.0.1'!A346)","v":44},{"$f":"IF('2.0.1'!C346=\"\",\"\",'2.0.1'!C346)","v":"Amount"},{"$f":"IF('2.0.1'!E346=\"\",\"\",'2.0.1'!E346)","v":""}]
["2.0.1",{"$f":"AgencyCode","v":"ZZZZ"},{"$f":"AgencyName","v":"EXAMPLE AGENCY"},{"$f":"Year","v":2019},{"$f":"IF('2.0.1'!A350=\"\",E165,'2.0.1'!A350)","v":45},{"$f":"IF('2.0.1'!C350=\"\",\"\",'2.0.1'!C350)","v":"Has your agency used installment purchase financing (loans or notes) for acquisition?"},{"$f":"IF('2.0.1'!G350=\"\",\"\",'2.0.1'!G350)","v":"No"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A352=\"\",E166,'2.0.1'!A352)","v":45},{"$f":"IF('2.0.1'!C352=\"\",\"\",'2.0.1'!C352)","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'!G352=\"\",\"\",'2.0.1'!G352)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A355=\"\",E167,'2.0.1'!A355)","v":45},{"$f":"IF('2.0.1'!C355=\"\",\"\",'2.0.1'!C355)","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 Reporting Package Checklist to the Comptroller General's Office."},{"$f":"IF('2.0.1'!G355=\"\",\"\",'2.0.1'!G355)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A358=\"\",E168,'2.0.1'!A358)","v":46},{"$f":"IF('2.0.1'!C358=\"\",\"\",'2.0.1'!C358)","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'!G358=\"\",\"\",'2.0.1'!G358)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A371=\"\",E169,'2.0.1'!A371)","v":46},{"$f":"IF('2.0.1'!C371=\"\",\"\",'2.0.1'!C371)","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'!G371=\"\",\"\",'2.0.1'!G371)","v":"No"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A373=\"\",E170,'2.0.1'!A373)","v":46},{"$f":"IF('2.0.1'!C373=\"\",\"\",'2.0.1'!C373)","v":"Action:  Describe the situation in a letter or other attachment to this ReportingPackage 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'!G373=\"\",\"\",'2.0.1'!G373)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A376=\"\",E171,'2.0.1'!A376)","v":47},{"$f":"IF('2.0.1'!C376=\"\",\"\",'2.0.1'!C376)","v":"Is your agency required to pay interest on tax refunds?"},{"$f":"IF('2.0.1'!G376=\"\",\"\",'2.0.1'!G376)","v":"No"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A378=\"\",E172,'2.0.1'!A378)","v":47},{"$f":"IF('2.0.1'!C378=\"\",\"\",'2.0.1'!C378)","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'!G378=\"\",\"\",'2.0.1'!G378)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A381=\"\",E173,'2.0.1'!A381)","v":48},{"$f":"IF('2.0.1'!C381=\"\",\"\",'2.0.1'!C381)","v":"Has your agency been involved in any litigation or made payments to private attorneys during the fiscal year?"},{"$f":"IF('2.0.1'!G381=\"\",\"\",'2.0.1'!G381)","v":"Yes"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A383=\"\",E174,'2.0.1'!A383)","v":48},{"$f":"IF('2.0.1'!C383=\"\",\"\",'2.0.1'!C383)","v":"Action:  The Litigation Reporting Package is required.  (See Section 3.13)"},{"$f":"IF('2.0.1'!G383=\"\",\"\",'2.0.1'!G383)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A386=\"\",E175,'2.0.1'!A386)","v":49},{"$f":"IF('2.0.1'!C386=\"\",\"\",'2.0.1'!C386)","v":"Does your agency have claims in excess of $100,000 for EITHER:"},{"$f":"IF('2.0.1'!G386=\"\",\"\",'2.0.1'!G386)","v":"No"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A391=\"\",E176,'2.0.1'!A391)","v":49},{"$f":"IF('2.0.1'!C391=\"\",\"\",'2.0.1'!C391)","v":"Action:  The Claims Reporting Package is required.  (See Section 3.15)"},{"$f":"IF('2.0.1'!G391=\"\",\"\",'2.0.1'!G391)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A394=\"\",E177,'2.0.1'!A394)","v":50},{"$f":"IF('2.0.1'!C394=\"\",\"\",'2.0.1'!C394)","v":"Did your agency either "},{"$f":"IF('2.0.1'!G394=\"\",\"\",'2.0.1'!G394)","v":"Yes"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A403=\"\",E178,'2.0.1'!A403)","v":50},{"$f":"IF('2.0.1'!C403=\"\",\"\",'2.0.1'!C403)","v":"Action:  The Miscellaneous Loss Liabilities, Loss Contingencies, and Commitments Reporting Package is required.   (See Section 3.16)"},{"$f":"IF('2.0.1'!G403=\"\",\"\",'2.0.1'!G403)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A406=\"\",E179,'2.0.1'!A406)","v":51},{"$f":"IF('2.0.1'!C406=\"\",\"\",'2.0.1'!C406)","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'!G406=\"\",\"\",'2.0.1'!G406)","v":"No"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A408=\"\",E180,'2.0.1'!A408)","v":51},{"$f":"IF('2.0.1'!C408=\"\",\"\",'2.0.1'!C408)","v":"Action:  The Miscellaneous Loss Liabilities, Loss Contingencies, and Commitments Reporting Package is required.   (See Section 3.16.1)"},{"$f":"IF('2.0.1'!G408=\"\",\"\",'2.0.1'!G408)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A411=\"\",E181,'2.0.1'!A411)","v":52},{"$f":"IF('2.0.1'!C411=\"\",\"\",'2.0.1'!C411)","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'!G411=\"\",\"\",'2.0.1'!G411)","v":"No"}]
["2.0.1",{"$f":"AgencyCode","v":"ZZZZ"},{"$f":"AgencyName","v":"EXAMPLE AGENCY"},{"$f":"Year","v":2019},{"$f":"IF('2.0.1'!A413=\"\",E182,'2.0.1'!A413)","v":52},{"$f":"IF('2.0.1'!C413=\"\",\"\",'2.0.1'!C413)","v":"Action:  Describe the situation in a letter or other attachment when you return thisReporting Package Checklist to the Comptroller General's Office.Be sure to fully describe the activity and whether you self-insure theactivity, purchase insurance to cover the activity, or provide insurancecoverage to other entities for this activity.  Also, please include the nameand phone number of a person within your agency that we may contactto obtain additional information,  if necessary."},{"$f":"IF('2.0.1'!G413=\"\",\"\",'2.0.1'!G413)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A416=\"\",E183,'2.0.1'!A416)","v":53},{"$f":"IF('2.0.1'!C416=\"\",\"\",'2.0.1'!C416)","v":"Does your agency use any non-State entities to process transactions (outsourced services - not including credit card payments)?"},{"$f":"IF('2.0.1'!G416=\"\",\"\",'2.0.1'!G416)","v":"No"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A418=\"\",E184,'2.0.1'!A418)","v":53},{"$f":"IF('2.0.1'!C418=\"\",\"\",'2.0.1'!C418)","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 Reporting Package Checklist to the Comptroller General'sOffice."},{"$f":"IF('2.0.1'!G418=\"\",\"\",'2.0.1'!G418)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A421=\"\",E185,'2.0.1'!A421)","v":54},{"$f":"IF('2.0.1'!C421=\"\",\"\",'2.0.1'!C421)","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 afinancial impact on the agency."},{"$f":"IF('2.0.1'!G421=\"\",\"\",'2.0.1'!G421)","v":"No"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A423=\"\",E186,'2.0.1'!A423)","v":54},{"$f":"IF('2.0.1'!C423=\"\",\"\",'2.0.1'!C423)","v":"Action:   Describe the situation on agency letterhead signed by the Agency Directoror 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'!G423=\"\",\"\",'2.0.1'!G423)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A426=\"\",E187,'2.0.1'!A426)","v":55},{"$f":"IF('2.0.1'!C426=\"\",\"\",'2.0.1'!C426)","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'!G426=\"\",\"\",'2.0.1'!G426)","v":"No"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A428=\"\",E188,'2.0.1'!A428)","v":55},{"$f":"IF('2.0.1'!C428=\"\",\"\",'2.0.1'!C428)","v":"Action:   Describe the situation on agency letterhead signed by the Agency Directoror 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'!G428=\"\",\"\",'2.0.1'!G428)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A431=\"\",E189,'2.0.1'!A431)","v":56},{"$f":"IF('2.0.1'!C431=\"\",\"\",'2.0.1'!C431)","v":"Has your agency had any communications from regulatory agencies concerning noncompliance with, or deficiencies in, financial reporting practices?"},{"$f":"IF('2.0.1'!G431=\"\",\"\",'2.0.1'!G431)","v":"No"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A433=\"\",E190,'2.0.1'!A433)","v":56},{"$f":"IF('2.0.1'!C433=\"\",\"\",'2.0.1'!C433)","v":"Action:   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'!G433=\"\",\"\",'2.0.1'!G433)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A436=\"\",E191,'2.0.1'!A436)","v":57},{"$f":"IF('2.0.1'!C436=\"\",\"\",'2.0.1'!C436)","v":"Has your agency had either of the following situations:"},{"$f":"IF('2.0.1'!G436=\"\",\"\",'2.0.1'!G436)","v":"No"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A444=\"\",E192,'2.0.1'!A444)","v":57},{"$f":"IF('2.0.1'!C444=\"\",\"\",'2.0.1'!C444)","v":"Action:  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'!G444=\"\",\"\",'2.0.1'!G444)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A447=\"\",E193,'2.0.1'!A447)","v":58},{"$f":"IF('2.0.1'!C447=\"\",\"\",'2.0.1'!C447)","v":"Does your agency know or reasonably believe a site is polluted or contaminated?"},{"$f":"IF('2.0.1'!G447=\"\",\"\",'2.0.1'!G447)","v":"No"}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A449=\"\",E194,'2.0.1'!A449)","v":58},{"$f":"IF('2.0.1'!C449=\"\",\"\",'2.0.1'!C449)","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'!G449=\"\",\"\",'2.0.1'!G449)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A451=\"\",E195,'2.0.1'!A451)","v":58},{"$f":"IF('2.0.1'!C451=\"\",\"\",'2.0.1'!C451)","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 theevent when this Reporting Package Checklist is returned to the Comptroller General's Office."},{"$f":"IF('2.0.1'!G451=\"\",\"\",'2.0.1'!G451)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A453=\"\",E196,'2.0.1'!A453)","v":58},{"$f":"IF('2.0.1'!C453=\"\",\"\",'2.0.1'!C453)","v":"b. Has your agency violated a pollution prevention-related permit or license? "},{"$f":"IF('2.0.1'!G453=\"\",\"\",'2.0.1'!G453)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A455=\"\",E197,'2.0.1'!A455)","v":58},{"$f":"IF('2.0.1'!C455=\"\",\"\",'2.0.1'!C455)","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 theevent when this Reporting Package Checklist is returned to the Comptroller General's Office."},{"$f":"IF('2.0.1'!G455=\"\",\"\",'2.0.1'!G455)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A457=\"\",E198,'2.0.1'!A457)","v":58},{"$f":"IF('2.0.1'!C457=\"\",\"\",'2.0.1'!C457)","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'!G457=\"\",\"\",'2.0.1'!G457)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A459=\"\",E199,'2.0.1'!A459)","v":58},{"$f":"IF('2.0.1'!C459=\"\",\"\",'2.0.1'!C459)","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 theevent when this Reporting Package Checklist is returned to the Comptroller General's Office."},{"$f":"IF('2.0.1'!G459=\"\",\"\",'2.0.1'!G459)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A461=\"\",E200,'2.0.1'!A461)","v":58},{"$f":"IF('2.0.1'!C461=\"\",\"\",'2.0.1'!C461)","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'!G461=\"\",\"\",'2.0.1'!G461)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A463=\"\",E201,'2.0.1'!A463)","v":58},{"$f":"IF('2.0.1'!C463=\"\",\"\",'2.0.1'!C463)","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 theevent when this Reporting Package Checklist is returned to the Comptroller General's Office."},{"$f":"IF('2.0.1'!G463=\"\",\"\",'2.0.1'!G463)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A465=\"\",E202,'2.0.1'!A465)","v":58},{"$f":"IF('2.0.1'!C465=\"\",\"\",'2.0.1'!C465)","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'!G465=\"\",\"\",'2.0.1'!G465)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"IF('2.0.1'!A467=\"\",E203,'2.0.1'!A467)","v":58},{"$f":"IF('2.0.1'!C467=\"\",\"\",'2.0.1'!C467)","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 theevent when this Reporting Package Checklist is returned to the Comptroller General's Office."},{"$f":"IF('2.0.1'!G467=\"\",\"\",'2.0.1'!G467)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.01.a","I5",{"$f":"IF('37. (Cont)'!I5=\"\",\"\",'37. (Cont)'!I5)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.01.b","I6",{"$f":"IF('37. (Cont)'!I6=\"\",\"\",'37. (Cont)'!I6)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.01.c","I7",{"$f":"IF('37. (Cont)'!I7=\"\",\"\",'37. (Cont)'!I7)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.01.d","I8",{"$f":"IF('37. (Cont)'!I8=\"\",\"\",'37. (Cont)'!I8)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.01.e","I9",{"$f":"IF('37. (Cont)'!I9=\"\",\"\",'37. (Cont)'!I9)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.01.f","I10",{"$f":"IF('37. (Cont)'!I10=\"\",\"\",'37. (Cont)'!I10)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.01.g","I11",{"$f":"IF('37. (Cont)'!I11=\"\",\"\",'37. (Cont)'!I11)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.01.h","I12",{"$f":"IF('37. (Cont)'!I12=\"\",\"\",'37. (Cont)'!I12)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.01.i","I13",{"$f":"IF('37. (Cont)'!I13=\"\",\"\",'37. (Cont)'!I13)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.02.a","K5",{"$f":"IF('37. (Cont)'!K5=\"\",\"\",'37. (Cont)'!K5)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.02.b","K6",{"$f":"IF('37. (Cont)'!K6=\"\",\"\",'37. (Cont)'!K6)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.02.c","K7",{"$f":"IF('37. (Cont)'!K7=\"\",\"\",'37. (Cont)'!K7)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.02.d","K8",{"$f":"IF('37. (Cont)'!K8=\"\",\"\",'37. (Cont)'!K8)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.02.e","K9",{"$f":"IF('37. (Cont)'!K9=\"\",\"\",'37. (Cont)'!K9)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.02.f","K10",{"$f":"IF('37. (Cont)'!K10=\"\",\"\",'37. (Cont)'!K10)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.02.g","K11",{"$f":"IF('37. (Cont)'!K11=\"\",\"\",'37. (Cont)'!K11)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.02.h","K12",{"$f":"IF('37. (Cont)'!K12=\"\",\"\",'37. (Cont)'!K12)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.02.i","K13",{"$f":"IF('37. (Cont)'!K13=\"\",\"\",'37. (Cont)'!K13)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.03.a","M5",{"$f":"IF('37. (Cont)'!M5=\"\",\"\",'37. (Cont)'!M5)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.03.b","M6",{"$f":"IF('37. (Cont)'!M6=\"\",\"\",'37. (Cont)'!M6)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.03.c","M7",{"$f":"IF('37. (Cont)'!M7=\"\",\"\",'37. (Cont)'!M7)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.03.d","M8",{"$f":"IF('37. (Cont)'!M8=\"\",\"\",'37. (Cont)'!M8)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.03.e","M9",{"$f":"IF('37. (Cont)'!M9=\"\",\"\",'37. (Cont)'!M9)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.03.f","M10",{"$f":"IF('37. (Cont)'!M10=\"\",\"\",'37. (Cont)'!M10)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.03.g","M11",{"$f":"IF('37. (Cont)'!M11=\"\",\"\",'37. (Cont)'!M11)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.03.h","M12",{"$f":"IF('37. (Cont)'!M12=\"\",\"\",'37. (Cont)'!M12)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.03.i","M13",{"$f":"IF('37. (Cont)'!M13=\"\",\"\",'37. (Cont)'!M13)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.04.a","O5",{"$f":"IF('37. (Cont)'!O5=\"\",\"\",'37. (Cont)'!O5)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.04.b","O6",{"$f":"IF('37. (Cont)'!O6=\"\",\"\",'37. (Cont)'!O6)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.04.c","O7",{"$f":"IF('37. (Cont)'!O7=\"\",\"\",'37. (Cont)'!O7)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.04.d","O8",{"$f":"IF('37. (Cont)'!O8=\"\",\"\",'37. (Cont)'!O8)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.04.e","O9",{"$f":"IF('37. (Cont)'!O9=\"\",\"\",'37. (Cont)'!O9)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.04.f","O10",{"$f":"IF('37. (Cont)'!O10=\"\",\"\",'37. (Cont)'!O10)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.04.g","O11",{"$f":"IF('37. (Cont)'!O11=\"\",\"\",'37. (Cont)'!O11)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.04.h","O12",{"$f":"IF('37. (Cont)'!O12=\"\",\"\",'37. (Cont)'!O12)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.04.i","O13",{"$f":"IF('37. (Cont)'!O13=\"\",\"\",'37. (Cont)'!O13)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.05.a","Q5",{"$f":"IF('37. (Cont)'!Q5=\"\",\"\",'37. (Cont)'!Q5)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.05.b","Q6",{"$f":"IF('37. (Cont)'!Q6=\"\",\"\",'37. (Cont)'!Q6)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.05.c","Q7",{"$f":"IF('37. (Cont)'!Q7=\"\",\"\",'37. (Cont)'!Q7)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.05.d","Q8",{"$f":"IF('37. (Cont)'!Q8=\"\",\"\",'37. (Cont)'!Q8)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.05.e","Q9",{"$f":"IF('37. (Cont)'!Q9=\"\",\"\",'37. (Cont)'!Q9)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.05.f","Q10",{"$f":"IF('37. (Cont)'!Q10=\"\",\"\",'37. (Cont)'!Q10)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.05.g","Q11",{"$f":"IF('37. (Cont)'!Q11=\"\",\"\",'37. (Cont)'!Q11)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.05.h","Q12",{"$f":"IF('37. (Cont)'!Q12=\"\",\"\",'37. (Cont)'!Q12)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.05.i","Q13",{"$f":"IF('37. (Cont)'!Q13=\"\",\"\",'37. (Cont)'!Q13)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.06.a","S5",{"$f":"IF('37. (Cont)'!S5=\"\",\"\",'37. (Cont)'!S5)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.06.b","S6",{"$f":"IF('37. (Cont)'!S6=\"\",\"\",'37. (Cont)'!S6)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.06.c","S7",{"$f":"IF('37. (Cont)'!S7=\"\",\"\",'37. (Cont)'!S7)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.06.d","S8",{"$f":"IF('37. (Cont)'!S8=\"\",\"\",'37. (Cont)'!S8)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.06.e","S9",{"$f":"IF('37. (Cont)'!S9=\"\",\"\",'37. (Cont)'!S9)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.06.f","S10",{"$f":"IF('37. (Cont)'!S10=\"\",\"\",'37. (Cont)'!S10)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.06.g","S11",{"$f":"IF('37. (Cont)'!S11=\"\",\"\",'37. (Cont)'!S11)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.06.h","S12",{"$f":"IF('37. (Cont)'!S12=\"\",\"\",'37. (Cont)'!S12)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.06.i","S13",{"$f":"IF('37. (Cont)'!S13=\"\",\"\",'37. (Cont)'!S13)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.07.a","U5",{"$f":"IF('37. (Cont)'!U5=\"\",\"\",'37. (Cont)'!U5)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.07.b","U6",{"$f":"IF('37. (Cont)'!U6=\"\",\"\",'37. (Cont)'!U6)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.07.c","U7",{"$f":"IF('37. (Cont)'!U7=\"\",\"\",'37. (Cont)'!U7)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.07.d","U8",{"$f":"IF('37. (Cont)'!U8=\"\",\"\",'37. (Cont)'!U8)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.07.e","U9",{"$f":"IF('37. (Cont)'!U9=\"\",\"\",'37. (Cont)'!U9)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.07.f","U10",{"$f":"IF('37. (Cont)'!U10=\"\",\"\",'37. (Cont)'!U10)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.07.g","U11",{"$f":"IF('37. (Cont)'!U11=\"\",\"\",'37. (Cont)'!U11)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.07.h","U12",{"$f":"IF('37. (Cont)'!U12=\"\",\"\",'37. (Cont)'!U12)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.07.i","U13",{"$f":"IF('37. (Cont)'!U13=\"\",\"\",'37. (Cont)'!U13)","v":""}]
["2.0.1",{"$f":"AgencyCode","v":"ZZZZ"},{"$f":"AgencyName","v":"EXAMPLE AGENCY"},{"$f":"Year","v":2019},"37.08.a","W5",{"$f":"IF('37. (Cont)'!W5=\"\",\"\",'37. (Cont)'!W5)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.08.b","W6",{"$f":"IF('37. (Cont)'!W6=\"\",\"\",'37. (Cont)'!W6)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.08.c","W7",{"$f":"IF('37. (Cont)'!W7=\"\",\"\",'37. (Cont)'!W7)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.08.d","W8",{"$f":"IF('37. (Cont)'!W8=\"\",\"\",'37. (Cont)'!W8)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.08.e","W9",{"$f":"IF('37. (Cont)'!W9=\"\",\"\",'37. (Cont)'!W9)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.08.f","W10",{"$f":"IF('37. (Cont)'!W10=\"\",\"\",'37. (Cont)'!W10)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.08.g","W11",{"$f":"IF('37. (Cont)'!W11=\"\",\"\",'37. (Cont)'!W11)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.08.h","W12",{"$f":"IF('37. (Cont)'!W12=\"\",\"\",'37. (Cont)'!W12)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.08.i","W13",{"$f":"IF('37. (Cont)'!W13=\"\",\"\",'37. (Cont)'!W13)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.09.a","Y5",{"$f":"IF('37. (Cont)'!Y5=\"\",\"\",'37. (Cont)'!Y5)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.09.b","Y6",{"$f":"IF('37. (Cont)'!Y6=\"\",\"\",'37. (Cont)'!Y6)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.09.c","Y7",{"$f":"IF('37. (Cont)'!Y7=\"\",\"\",'37. (Cont)'!Y7)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.09.d","Y8",{"$f":"IF('37. (Cont)'!Y8=\"\",\"\",'37. (Cont)'!Y8)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.09.e","Y9",{"$f":"IF('37. (Cont)'!Y9=\"\",\"\",'37. (Cont)'!Y9)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.09.f","Y10",{"$f":"IF('37. (Cont)'!Y10=\"\",\"\",'37. (Cont)'!Y10)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.09.g","Y11",{"$f":"IF('37. (Cont)'!Y11=\"\",\"\",'37. (Cont)'!Y11)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.09.h","Y12",{"$f":"IF('37. (Cont)'!Y12=\"\",\"\",'37. (Cont)'!Y12)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.09.i","Y13",{"$f":"IF('37. (Cont)'!Y13=\"\",\"\",'37. (Cont)'!Y13)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.10.a","AA5",{"$f":"IF('37. (Cont)'!AA5=\"\",\"\",'37. (Cont)'!AA5)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.10.b","AA6",{"$f":"IF('37. (Cont)'!AA6=\"\",\"\",'37. (Cont)'!AA6)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.10.c","AA7",{"$f":"IF('37. (Cont)'!AA7=\"\",\"\",'37. (Cont)'!AA7)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.10.d","AA8",{"$f":"IF('37. (Cont)'!AA8=\"\",\"\",'37. (Cont)'!AA8)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.10.e","AA9",{"$f":"IF('37. (Cont)'!AA9=\"\",\"\",'37. (Cont)'!AA9)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.10.f","AA10",{"$f":"IF('37. (Cont)'!AA10=\"\",\"\",'37. (Cont)'!AA10)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.10.g","AA11",{"$f":"IF('37. (Cont)'!AA11=\"\",\"\",'37. (Cont)'!AA11)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.10.h","AA12",{"$f":"IF('37. (Cont)'!AA12=\"\",\"\",'37. (Cont)'!AA12)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"37.10.i","AA13",{"$f":"IF('37. (Cont)'!AA13=\"\",\"\",'37. (Cont)'!AA13)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"42.01.a","G6",{"$f":"IF('42. (Cont)'!G6=\"\",\"\",'42. (Cont)'!G6)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"42.01.a","G7",{"$f":"IF('42. (Cont)'!G7=\"\",\"\",'42. (Cont)'!G7)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"42.01.b","G12",{"$f":"IF('42. (Cont)'!G12=\"\",\"\",'42. (Cont)'!G12)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"42.01.b","G13",{"$f":"IF('42. (Cont)'!G13=\"\",\"\",'42. (Cont)'!G13)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"42.02.a","I6",{"$f":"IF('42. (Cont)'!I6=\"\",\"\",'42. (Cont)'!I6)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"42.02.a","I7",{"$f":"IF('42. (Cont)'!I7=\"\",\"\",'42. (Cont)'!I7)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"42.02.b","I12",{"$f":"IF('42. (Cont)'!I12=\"\",\"\",'42. (Cont)'!I12)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"42.02.b","I13",{"$f":"IF('42. (Cont)'!I13=\"\",\"\",'42. (Cont)'!I13)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"42.03.a","K6",{"$f":"IF('42. (Cont)'!K6=\"\",\"\",'42. (Cont)'!K6)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"42.03.a","K7",{"$f":"IF('42. (Cont)'!K7=\"\",\"\",'42. (Cont)'!K7)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"42.03.b","K12",{"$f":"IF('42. (Cont)'!K12=\"\",\"\",'42. (Cont)'!K12)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"42.03.b","K13",{"$f":"IF('42. (Cont)'!K13=\"\",\"\",'42. (Cont)'!K13)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"42.04.a","M6",{"$f":"IF('42. (Cont)'!M6=\"\",\"\",'42. (Cont)'!M6)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"42.04.a","M7",{"$f":"IF('42. (Cont)'!M7=\"\",\"\",'42. (Cont)'!M7)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"42.04.b","M12",{"$f":"IF('42. (Cont)'!M12=\"\",\"\",'42. (Cont)'!M12)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"42.04.b","M13",{"$f":"IF('42. (Cont)'!M13=\"\",\"\",'42. (Cont)'!M13)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"42.05.a","O6",{"$f":"IF('42. (Cont)'!O6=\"\",\"\",'42. (Cont)'!O6)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"42.05.a","O7",{"$f":"IF('42. (Cont)'!O7=\"\",\"\",'42. (Cont)'!O7)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"42.05.b","O12",{"$f":"IF('42. (Cont)'!O12=\"\",\"\",'42. (Cont)'!O12)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"42.05.b","O13",{"$f":"IF('42. (Cont)'!O13=\"\",\"\",'42. (Cont)'!O13)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"42.06.a","Q6",{"$f":"IF('42. (Cont)'!Q6=\"\",\"\",'42. (Cont)'!Q6)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"42.06.a","Q7",{"$f":"IF('42. (Cont)'!Q7=\"\",\"\",'42. (Cont)'!Q7)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"42.06.b","Q12",{"$f":"IF('42. (Cont)'!Q12=\"\",\"\",'42. (Cont)'!Q12)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"42.06.b","Q13",{"$f":"IF('42. (Cont)'!Q13=\"\",\"\",'42. (Cont)'!Q13)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"42.07.a","S6",{"$f":"IF('42. (Cont)'!S6=\"\",\"\",'42. (Cont)'!S6)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"42.07.a","S7",{"$f":"IF('42. (Cont)'!S7=\"\",\"\",'42. (Cont)'!S7)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"42.07.b","S12",{"$f":"IF('42. (Cont)'!S12=\"\",\"\",'42. (Cont)'!S12)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"42.07.b","S13",{"$f":"IF('42. (Cont)'!S13=\"\",\"\",'42. (Cont)'!S13)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"42.08.a","U6",{"$f":"IF('42. (Cont)'!U6=\"\",\"\",'42. (Cont)'!U6)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"42.08.a","U7",{"$f":"IF('42. (Cont)'!U7=\"\",\"\",'42. (Cont)'!U7)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"42.08.b","U12",{"$f":"IF('42. (Cont)'!U12=\"\",\"\",'42. (Cont)'!U12)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"42.08.b","U13",{"$f":"IF('42. (Cont)'!U13=\"\",\"\",'42. (Cont)'!U13)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"42.09.a","W6",{"$f":"IF('42. (Cont)'!W6=\"\",\"\",'42. (Cont)'!W6)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"42.09.a","W7",{"$f":"IF('42. (Cont)'!W7=\"\",\"\",'42. (Cont)'!W7)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"42.09.b","W12",{"$f":"IF('42. (Cont)'!W12=\"\",\"\",'42. (Cont)'!W12)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"42.09.b","W13",{"$f":"IF('42. (Cont)'!W13=\"\",\"\",'42. (Cont)'!W13)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"42.10.a","Y6",{"$f":"IF('42. (Cont)'!Y6=\"\",\"\",'42. (Cont)'!Y6)","v":""}]
["2.0.1",{"$f":"AgencyCode","v":"ZZZZ"},{"$f":"AgencyName","v":"EXAMPLE AGENCY"},{"$f":"Year","v":2019},"42.10.a","Y7",{"$f":"IF('42. (Cont)'!Y7=\"\",\"\",'42. (Cont)'!Y7)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"42.10.b","Y12",{"$f":"IF('42. (Cont)'!Y12=\"\",\"\",'42. (Cont)'!Y12)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"42.10.b","Y13",{"$f":"IF('42. (Cont)'!Y13=\"\",\"\",'42. (Cont)'!Y13)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"44.01.a","G5",{"$f":"IF('44. (Cont)'!G5=\"\",\"\",'44. (Cont)'!G5)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"44.01.b","I5",{"$f":"IF('44. (Cont)'!I5=\"\",\"\",'44. (Cont)'!I5)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"44.01.c","G7",{"$f":"IF('44. (Cont)'!G7=\"\",\"\",'44. (Cont)'!G7)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"44.01.d","I7",{"$f":"IF('44. (Cont)'!I7=\"\",\"\",'44. (Cont)'!I7)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"44.02.a","K5",{"$f":"IF('44. (Cont)'!K5=\"\",\"\",'44. (Cont)'!K5)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"44.02.b","M5",{"$f":"IF('44. (Cont)'!M5=\"\",\"\",'44. (Cont)'!M5)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"44.02.c","K7",{"$f":"IF('44. (Cont)'!K7=\"\",\"\",'44. (Cont)'!K7)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"44.02.d","M7",{"$f":"IF('44. (Cont)'!M7=\"\",\"\",'44. (Cont)'!M7)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"44.03.a","O5",{"$f":"IF('44. (Cont)'!O5=\"\",\"\",'44. (Cont)'!O5)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"44.03.b","Q5",{"$f":"IF('44. (Cont)'!Q5=\"\",\"\",'44. (Cont)'!Q5)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"44.03.c","O7",{"$f":"IF('44. (Cont)'!O7=\"\",\"\",'44. (Cont)'!O7)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"44.03.d","Q7",{"$f":"IF('44. (Cont)'!Q7=\"\",\"\",'44. (Cont)'!Q7)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"44.04.a","S5",{"$f":"IF('44. (Cont)'!S5=\"\",\"\",'44. (Cont)'!S5)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"44.04.b","U5",{"$f":"IF('44. (Cont)'!U5=\"\",\"\",'44. (Cont)'!U5)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"44.04.c","S7",{"$f":"IF('44. (Cont)'!S7=\"\",\"\",'44. (Cont)'!S7)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"44.04.d","U7",{"$f":"IF('44. (Cont)'!U7=\"\",\"\",'44. (Cont)'!U7)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"44.05.a","W5",{"$f":"IF('44. (Cont)'!W5=\"\",\"\",'44. (Cont)'!W5)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"44.05.b","Y5",{"$f":"IF('44. (Cont)'!Y5=\"\",\"\",'44. (Cont)'!Y5)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"44.05.c","W7",{"$f":"IF('44. (Cont)'!W7=\"\",\"\",'44. (Cont)'!W7)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"44.05.d","Y7",{"$f":"IF('44. (Cont)'!Y7=\"\",\"\",'44. (Cont)'!Y7)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"44.06.a","AA5",{"$f":"IF('44. (Cont)'!AA5=\"\",\"\",'44. (Cont)'!AA5)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"44.06.b","AC5",{"$f":"IF('44. (Cont)'!AC5=\"\",\"\",'44. (Cont)'!AC5)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"44.06.c","AA7",{"$f":"IF('44. (Cont)'!AA7=\"\",\"\",'44. (Cont)'!AA7)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"44.06.d","AC7",{"$f":"IF('44. (Cont)'!AC7=\"\",\"\",'44. (Cont)'!AC7)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"44.07.a","AE5",{"$f":"IF('44. (Cont)'!AE5=\"\",\"\",'44. (Cont)'!AE5)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"44.07.b","AG5",{"$f":"IF('44. (Cont)'!AG5=\"\",\"\",'44. (Cont)'!AG5)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"44.07.c","AE7",{"$f":"IF('44. (Cont)'!AE7=\"\",\"\",'44. (Cont)'!AE7)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"44.07.d","AG7",{"$f":"IF('44. (Cont)'!AG7=\"\",\"\",'44. (Cont)'!AG7)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"44.08.a","AI5",{"$f":"IF('44. (Cont)'!AI5=\"\",\"\",'44. (Cont)'!AI5)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"44.08.b","AK5",{"$f":"IF('44. (Cont)'!AK5=\"\",\"\",'44. (Cont)'!AK5)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"44.08.c","AI7",{"$f":"IF('44. (Cont)'!AI7=\"\",\"\",'44. (Cont)'!AI7)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"44.08.d","AK7",{"$f":"IF('44. (Cont)'!AK7=\"\",\"\",'44. (Cont)'!AK7)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"44.09.a","AM5",{"$f":"IF('44. (Cont)'!AM5=\"\",\"\",'44. (Cont)'!AM5)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"44.09.b","AO5",{"$f":"IF('44. (Cont)'!AO5=\"\",\"\",'44. (Cont)'!AO5)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"44.09.c","AM7",{"$f":"IF('44. (Cont)'!AM7=\"\",\"\",'44. (Cont)'!AM7)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"44.09.d","AO7",{"$f":"IF('44. (Cont)'!AO7=\"\",\"\",'44. (Cont)'!AO7)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"44.10.a","AQ5",{"$f":"IF('44. (Cont)'!AQ5=\"\",\"\",'44. (Cont)'!AQ5)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"44.10.b","AS5",{"$f":"IF('44. (Cont)'!AS5=\"\",\"\",'44. (Cont)'!AS5)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"44.10.c","AQ7",{"$f":"IF('44. (Cont)'!AQ7=\"\",\"\",'44. (Cont)'!AQ7)","v":""}]
["2.0.1","ZZZZ","EXAMPLE AGENCY",2019,"44.10.d","AS7",{"$f":"IF('44. (Cont)'!AS7=\"\",\"\",'44. (Cont)'!AS7)","v":""}]
["Signature Page","ZZZZ","EXAMPLE AGENCY",2019,"Prepared Date","E10",{"$f":"IF('Signature Page'!E10=\"\",\"\",'Signature Page'!E10)","v":"Joe Preparer"}]
["Signature Page","ZZZZ","EXAMPLE AGENCY",2019,"Preparer's Name","E11",{"$f":"IF('Signature Page'!E11=\"\",\"\",'Signature Page'!E11)","v":"Accountant"}]
["Signature Page","ZZZZ","EXAMPLE AGENCY",2019,"Preparer's Title","E12",{"$f":"IF('Signature Page'!E12=\"\",\"\",'Signature Page'!E12)","v":43649}]
["Signature Page","ZZZZ","EXAMPLE AGENCY",2019,"Preparer's e-Mail","E13",{"$f":"IF('Signature Page'!E13=\"\",\"\",'Signature Page'!E13)","v":"jpreparer@example.sc.gov"}]
["Signature Page","ZZZZ","EXAMPLE AGENCY",2019,"Preparer's Phone","E14",{"$f":"IF('Signature Page'!E14=\"\",\"\",'Signature Page'!E14)","v":"(803) 123-4567"}]
["Signature Page","ZZZZ","EXAMPLE AGENCY",2019,"Reviewed Date","E17",{"$f":"IF('Signature Page'!E17=\"\",\"\",'Signature Page'!E17)","v":43651}]
["Signature Page","ZZZZ","EXAMPLE AGENCY",2019,"Reviewer's Name","E18",{"$f":"IF('Signature Page'!E18=\"\",\"\",'Signature Page'!E18)","v":"Tome Reviewer"}]
["Signature Page","ZZZZ","EXAMPLE AGENCY",2019,"Reviewer's Title","E19",{"$f":"IF('Signature Page'!E19=\"\",\"\",'Signature Page'!E19)","v":"Manager"}]
["Signature Page","ZZZZ","EXAMPLE AGENCY",2019,"Reviewer's e-Mail","E20",{"$f":"IF('Signature Page'!E20=\"\",\"\",'Signature Page'!E20)","v":"treviewer@example.sc.gov"}]
["Signature Page","ZZZZ","EXAMPLE AGENCY",2019,"Reviewer's Phone","E21",{"$f":"IF('Signature Page'!E21=\"\",\"\",'Signature Page'!E21)","v":"(803) 765-4321"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.01 Cash and Investments Reporting Package","E10",{"$f":"IF('Required Packages'!E11=\"Not Required\",\"\",\"Required\")","v":"Required"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.02 Tax Revenue Reporting Package","E14",{"$f":"IF('Required Packages'!E15=\"Not Required\",\"\",\"Required\")","v":""}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.03 Grants and Contribution Revenue Reporting Package","E18",{"$f":"IF('Required Packages'!E19=\"Not Required\",\"\",\"Required\")","v":"Required"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.04 Miscellaneous Revenues Reporting Package","E22",{"$f":"IF('Required Packages'!E23=\"Not Required\",\"\",\"Required\")","v":"Required"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.05 Unearned Revenue Reporting Package","E24",{"$f":"IF('Required Packages'!E25=\"Not Required\",\"\",\"Required\")","v":""}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.06 Inventory Reporting Package","E26",{"$f":"IF('Required Packages'!E27=\"Not Required\",\"\",\"Required\")","v":"Required"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.07 Prepaid Expenses Reporting Package","E28",{"$f":"IF('Required Packages'!E29=\"Not Required\",\"\",\"Required\")","v":""}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.08 Capital Assets Reporting Package","E30",{"$f":"IF('Required Packages'!E31=\"Not Required\",\"\",\"Required\")","v":"Required"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.09 Operating Lease Reporting Package","E36",{"$f":"IF('Required Packages'!E37=\"Not Required\",\"\",\"Required\")","v":"Required"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.10 Loans Receivable Reporting Package","E40",{"$f":"IF('Required Packages'!E41=\"Not Required\",\"\",\"Required\")","v":""}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.12 Accounts Payable Reporting Package","E43",{"$f":"IF('Required Packages'!E44=\"Not Required\",\"\",\"Required\")","v":"Required"}]
["Required Packages",{"$f":"AgencyCode","v":"ZZZZ"},{"$f":"AgencyName","v":"EXAMPLE AGENCY"},{"$f":"Year","v":2019},"3.13 Litigation Reporting Package","E46",{"$f":"IF('Required Packages'!E46=\"Not Required\",\"\",\"Required\")","v":"Required"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.14 Disallowances and Penalties Reporting Package","E50",{"$f":"IF('Required Packages'!E51=\"Not Required\",\"\",\"Required\")","v":""}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.15 Claims Reporting Package","E52",{"$f":"IF('Required Packages'!E53=\"Not Required\",\"\",\"Required\")","v":""}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.16 Miscellaneous Loss Liabilities, Loss Contingencies, and Commitments Reporting Package","E55",{"$f":"IF('Required Packages'!E56=\"Not Required\",\"\",\"Required\")","v":"Required"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.18 Interfund Payables Reporting Package","E62",{"$f":"IF('Required Packages'!E61=\"Not Required\",\"\",\"Required\")","v":"Required"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.20 Fund Balance and Net Position (Net Asset) Reporting Package","E66",{"$f":"IF('Required Packages'!E65=\"Not Required\",\"\",\"Required\")","v":"Required"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"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'!E72=\"Not Required\",\"\",\"Required\")","v":""}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"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'!E74=\"Not Required\",\"\",\"Required\")","v":""}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"'Required Packages'!A76&\" \"&'Required Packages'!D76","v":"27.a "},"E76",{"$f":"IF('Required Packages'!E76=\"Not Required\",\"\",\"Required\")","v":""}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"'Required Packages'!A78&\" \"&'Required Packages'!D78","v":"27.a.i "},"E78",{"$f":"IF('Required Packages'!E78=\"Not Required\",\"\",\"Required\")","v":""}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"'Required Packages'!A82&\" \"&'Required Packages'!D82","v":"38 Describe the situation in a letter or other attachment when you return thisReporting Package Control Checklist to the Comptroller General's Office.  Please provide copies of signed agreements for any new loans."},"E80",{"$f":"IF('Required Packages'!E82=\"Not Required\",\"\",\"Required\")","v":""}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"'Required Packages'!A84&\" \"&'Required Packages'!D84","v":"39 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'!E84=\"Not Required\",\"\",\"Required\")","v":""}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"'Required Packages'!A86&\" \"&'Required Packages'!D86","v":"40 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'!E86=\"Not Required\",\"\",\"Required\")","v":""}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"'Required Packages'!A88&\" \"&'Required Packages'!D88","v":"43 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'!E88=\"Not Required\",\"\",\"Required\")","v":""}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"'Required Packages'!A90&\" \"&'Required Packages'!D90","v":"45 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'!E90=\"Not Required\",\"\",\"Required\")","v":""}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"'Required Packages'!A92&\" \"&'Required Packages'!D92","v":"46 Describe the situation in a letter or other attachment to this ReportingPackage 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'!E92=\"Not Required\",\"\",\"Required\")","v":""}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"'Required Packages'!A94&\" \"&'Required Packages'!D94","v":"47 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 no later than August 15."},"E92",{"$f":"IF('Required Packages'!E94=\"Not Required\",\"\",\"Required\")","v":""}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"'Required Packages'!A96&\" \"&'Required Packages'!D96","v":"52 Describe the situation in a letter or other attachment when you return thisReporting Package Checklist to the Comptroller General's Office.  Be sure to fully describe the activity and whether you self-insure theactivity, purchase insurance to cover the activity, or provide insurancecoverage to other entities for this activity.  Also, please include the nameand phone number of a person within your agency that we may contact to obtain additional information,  if necessary."},"E94",{"$f":"IF('Required Packages'!E96=\"Not Required\",\"\",\"Required\")","v":""}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"'Required Packages'!A98&\" \"&'Required Packages'!D98","v":"53 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'sOffice."},"E96",{"$f":"IF('Required Packages'!E98=\"Not Required\",\"\",\"Required\")","v":""}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"'Required Packages'!A100&\" \"&'Required Packages'!D100","v":"54 Describe the situation on agency letterhead signed by the Agency Directoror 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'!E100=\"Not Required\",\"\",\"Required\")","v":""}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"'Required Packages'!A102&\" \"&'Required Packages'!D102","v":"55 Describe the situation on agency letterhead signed by the Agency Directoror 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 strenthen the internal controls that may have been breached if the allegations prove true."},"E100",{"$f":"IF('Required Packages'!E102=\"Not Required\",\"\",\"Required\")","v":""}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"'Required Packages'!A104&\" \"&'Required Packages'!D104","v":"56 Provide copies of the communications and a summary of the correctiveactions when this Reporting Package Checklist is returned to theComptroller General's Office.  "},"E102",{"$f":"IF('Required Packages'!E104=\"Not Required\",\"\",\"Required\")","v":""}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"'Required Packages'!A106&\" \"&'Required Packages'!D106","v":"57 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'!E106=\"Not Required\",\"\",\"Required\")","v":""}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"'Required Packages'!A108&\" \"&'Required Packages'!D108","v":"58.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 theevent when this Reporting Package Checklist is returned to the Comptroller General's Office."},"E106",{"$f":"IF('Required Packages'!E108=\"Not Required\",\"\",\"Required\")","v":""}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"'Required Packages'!A110&\" \"&'Required Packages'!D110","v":"58.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 theevent when this Reporting Package Checklist is returned to the Comptroller General's Office."},"E108",{"$f":"IF('Required Packages'!E110=\"Not Required\",\"\",\"Required\")","v":""}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"'Required Packages'!A112&\" \"&'Required Packages'!D112","v":"58.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 theevent when this Reporting Package Checklist is returned to the Comptroller General's Office."},"E110",{"$f":"IF('Required Packages'!E112=\"Not Required\",\"\",\"Required\")","v":""}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"'Required Packages'!A114&\" \"&'Required Packages'!D114","v":"58.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 theevent when this Reporting Package Checklist is returned to the Comptroller General's Office."},"E112",{"$f":"IF('Required Packages'!E114=\"Not Required\",\"\",\"Required\")","v":""}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,{"$f":"'Required Packages'!A116&\" \"&'Required Packages'!D116","v":"58.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 theevent when this Reporting Package Checklist is returned to the Comptroller General's Office."},"E114",{"$f":"IF('Required Packages'!E116=\"Not Required\",\"\",\"Required\")","v":""}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.01.1 Petty Cash","F11",{"$f":"IF('Required Packages'!F12=\"\",\"\",'Required Packages'!F12)","v":"Yes"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.01.2 Agency Cash","F12",{"$f":"IF('Required Packages'!F13=\"\",\"\",'Required Packages'!F13)","v":"Yes"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.01.3 Investments","F13",{"$f":"IF('Required Packages'!F14=\"\",\"\",'Required Packages'!F14)","v":"Yes"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.02.1 Tax Receivable","F15",{"$f":"IF('Required Packages'!F16=\"\",\"\",'Required Packages'!F16)","v":"No"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.02.2 Tax Refund Payable","F16",{"$f":"IF('Required Packages'!F17=\"\",\"\",'Required Packages'!F17)","v":"No"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.02.3 Deferred Tax Revenues","F17",{"$f":"IF('Required Packages'!F18=\"\",\"\",'Required Packages'!F18)","v":"No"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.03.1 Grants Activity Form","F19",{"$f":"IF('Required Packages'!F20=\"\",\"\",'Required Packages'!F20)","v":"Yes"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.03.2 Grants Receivable and Deferred Revenue Summary Form","F20",{"$f":"IF('Required Packages'!F21=\"\",\"\",'Required Packages'!F21)","v":"Yes"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.03.3 Contributions Receivable and Deferred Revenue Summary Form","F21",{"$f":"IF('Required Packages'!F22=\"\",\"\",'Required Packages'!F22)","v":"No"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.04.1 Accounts Receivable Summary Form","F23",{"$f":"IF('Required Packages'!F24=\"\",\"\",'Required Packages'!F24)","v":"Yes"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.05.1 Unearned Revenue Summary Form","F25",{"$f":"IF('Required Packages'!F26=\"\",\"\",'Required Packages'!F26)","v":"No"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.06.1 Inventory Summary Form","F27",{"$f":"IF('Required Packages'!F28=\"\",\"\",'Required Packages'!F28)","v":"Yes"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.07.1 Prepaid Expenses Analysis","F29",{"$f":"IF('Required Packages'!F30=\"\",\"\",'Required Packages'!F30)","v":"No"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.08.1 Capital Asset Questionnaire","F31",{"$f":"IF('Required Packages'!F32=\"\",\"\",'Required Packages'!F32)","v":"Yes"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.08.2 Reporting of Adjustments and Errors Identified in SCEIS Asset History","F32",{"$f":"IF('Required Packages'!F33=\"\",\"\",'Required Packages'!F33)","v":"Based on 3.08.1"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.08.3 Non-SCEIS Agencies Only - Capital Asset Summary Form","F33",{"$f":"IF('Required Packages'!F34=\"\",\"\",'Required Packages'!F34)","v":"Based on 3.08.1"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.08.4 Capital Asset Intra-State Transfers Summary Form","F34",{"$f":"IF('Required Packages'!F35=\"\",\"\",'Required Packages'!F35)","v":"Based on 3.08.1"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.08.5 Asset History Reconciliation To GL Activity","F35",{"$f":"IF('Required Packages'!F36=\"\",\"\",'Required Packages'!F36)","v":"Based on 3.08.1"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.09.1 Operating Lease Summary Form - Leasee","F37",{"$f":"IF('Required Packages'!F38=\"\",\"\",'Required Packages'!F38)","v":"Yes"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.09.1.a Operating Lease Future Minimum Payment Schedule","F38",{"$f":"IF('Required Packages'!F39=\"\",\"\",'Required Packages'!F39)","v":"Based on 3.09.1"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.09.2 Operating Lease Summary Form - Leasor","F39",{"$f":"IF('Required Packages'!F40=\"\",\"\",'Required Packages'!F40)","v":"Based on 3.09.1"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.10.1 Loans Receivable Summary Form","F41",{"$f":"IF('Required Packages'!F42=\"\",\"\",'Required Packages'!F42)","v":"No"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.12.1 Accounts Payable Summary Form","F44",{"$f":"IF('Required Packages'!F45=\"\",\"\",'Required Packages'!F45)","v":"Yes"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.13.1 Litigation Related Expense Explanation Form","F46",{"$f":"IF('Required Packages'!F47=\"\",\"\",'Required Packages'!F47)","v":"Yes"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.13.2 Litigation Overview Form","F47",{"$f":"IF('Required Packages'!F48=\"\",\"\",'Required Packages'!F48)","v":"Yes"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.13.3 Settled Litigation Report Form","F48",{"$f":"IF('Required Packages'!F49=\"\",\"\",'Required Packages'!F49)","v":"Based on 3.13.1"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.13.4 Litigation Contingency Report Form","F49",{"$f":"IF('Required Packages'!F50=\"\",\"\",'Required Packages'!F50)","v":"Based on 3.13.1"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.14.1 Grant Disallowance Reporting Form","F51",{"$f":"IF('Required Packages'!F52=\"\",\"\",'Required Packages'!F52)","v":"No"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.15.1 Claims Summary Form","F53",{"$f":"IF('Required Packages'!F54=\"\",\"\",'Required Packages'!F54)","v":"No"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.15.2 Additional Claims Information Form","F54",{"$f":"IF('Required Packages'!F55=\"\",\"\",'Required Packages'!F55)","v":"No"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.16.1 Miscellaneous Loss Liabilities Report Form","F56",{"$f":"IF('Required Packages'!F57=\"\",\"\",'Required Packages'!F57)","v":"Yes"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.16.2 Miscellaneous Loss Contingency Report Form","F57",{"$f":"IF('Required Packages'!F58=\"\",\"\",'Required Packages'!F58)","v":"Yes"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.16.3 Significant Miscellaneous Commitments Form","F58",{"$f":"IF('Required Packages'!F59=\"\",\"\",'Required Packages'!F59)","v":"Yes"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.18.1 Interfund Payable Summary Form","F63",{"$f":"IF('Required Packages'!F62=\"\",\"\",'Required Packages'!F62)","v":"Yes"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.18.2 Interfund Receivables Summary Form","F64",{"$f":"IF('Required Packages'!F63=\"\",\"\",'Required Packages'!F63)","v":"Yes"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.20.1 Fund Balance And Net Asset Summary Form","F67",{"$f":"IF('Required Packages'!F66=\"\",\"\",'Required Packages'!F66)","v":"Yes"}]
["Required Packages","ZZZZ","EXAMPLE AGENCY",2019,"3.20.2 Fund Use And Reporting Fund Types Form","F68",{"$f":"IF('Required Packages'!F67=\"\",\"\",'Required Packages'!F67)","v":"Yes"}]

{"sheet":"37. (Cont)","index":7,"n_rows":16,"n_cols":27,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
["37. (Cont)"]
[null,null,null,null,null,null,null,null,"Additional Loan 1",null,"Additional Loan 2",null,"Additional Loan 3",null,"Additional Loan 4",null,"Additional Loan 5",null,"Additional Loan 6",null,"Additional Loan 7",null,"Additional Loan 8",null,"Additional Loan 9",null,"Additional Loan 10"]
[null,"Action:  Provide the following information"]
[null,null,"Is your agency the lendor 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)."]
[]
[null,"Note:  Space for ten additional loans have been provided.  If you need additional space, please contact the CG's Office."]

{"sheet":"42. (Cont)","index":8,"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":9,"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."]