The URL can be used to link to this page

Browse Search

Home My WebLink About20202589.tiffRESOLUTION RE: APPROVE GRANT CLOSEOUT FOR VARIOUS WORKFORCE INNOVATION AND OPPORTUNITY ACT (WIOA) PROGRAMS AND AUTHORIZE CHAIR TO SIGN WHEREAS, the Board of County Commissioners of Weld County, Colorado, pursuant to Colorado statute and the Weld County Home Rule Charter, is vested with the authority of administering the affairs of Weld County, Colorado, and WHEREAS, the Board has been presented with a Grant Closeout Check List for Various Workforce Innovation and Opportunity Act (WIOA) Programs from the County of Weld, State of Colorado, by and through the Board of County Commissioners of Weld County, on behalf of the Department of Human Services, Employment Services of Weld County, to the Colorado Department of Labor and Employment, for all programs that have Expenditure Authorizations ending during the period of July 1, 2019, through June 30, 2020, with further terms and conditions being as stated in said grant closeout, and WHEREAS, after review, the Board deems it advisable to approve said grant closeout, a copy of which is attached hereto and incorporated herein by reference. NOW, THEREFORE, BE IT RESOLVED by the Board of County Commissioners of Weld County, Colorado, that the Grant Closeout Check List for Various Workforce Innovation and Opportunity Act (WIOA) Programs from the County of Weld, State of Colorado, by and through the Board of County Commissioners of Weld County, on behalf of the Department of Human Services, Employment Services of Weld County, to the Colorado Department of Labor and Employment, be, and hereby is, approved. BE IT FURTHER RESOLVED by the Board that the Chair be, and hereby is, authorized to sign said grant closeout. The above and foregoing Resolution was, on motion duly made and seconded, adopted by the following vote on the 24th day of August, A.D., 2020. BOARD OF COUNTY COMMISSIONERS WELD COUNTY, COLORADO ATTEST: dithlt) G( ..o•oe Weld County Clerk to the Board Deputy Clerk to the Boar Date of signature: 08/26/,2.0 cc: HSD, ACT(Bc/cD) G1127 /2.0 Mike Freeman, Chair 2910 -1 -e44 -0 — Kevin D. Ross 2020-2589 HR0092 PRIVILEGED AND CONFIDENTIAL MEMORANDUM DATE: August 17, 2020 TO: Board of County Commissioners — Pass -Around FR: Judy A. Griego, Director, Human Services RE: 2019-20 Workforce Innovation and Opportunity Act (WIOA) Grant Closeout Please review and indicate if you would like a work session prior to placing this item on the Board's agenda. Request Board Approval of the Departments' 2019-20 Workforce Innovation and Opportunity Act (WIOA) Grant Closeout for the Colorado Department of Labor and Employment (CDLE). The closeout packet is required by the Year -End Contract Closeout Procedures of the Colorado Department of Labor and Employment (CDLE), and in accordance with their Policy Guidance Letter #06-12-F1, for all programs that have Expenditure Authorizations ending during the period of July 1, 2019 through June 30, 2020. Revenues and expenditures are reconciled based on the CLEAR Fund Available Analysis Report, our internal spreadsheet, and the CLEAR billings. The grant obligations are released for those projects that are fully expended by the Division of Employment Services. This grant closeout is due to CDLE by Friday, August 28, 2020. I do not recommend a Work Session. I recommend approval and submission of this Grant Closeout and authorize the Chair to sign. Mike Freeman, Chair Scott James Barbara Kirkmeyer Steve Moreno, Pro -Tern Kevin Ross Approve Schedule Other/Comments: Recommendation Work Session Pass -Around Memorandum; August 17, 2020 - CMS 4042 Page 1 01.0024-02581 /-lea 0292 COLORADO Department of Labor and Employment Finance: 633 17th Street, Suite 1100, Denver, CO 80202-3660 Colorado Department of Labor and Employment Grant Closeout Check List Workforce Region / CLEAR Entity Code: Employment Services of Weld County - 5230 Address: PO Box 1805, Greeley, CO 80632 Director: Lora Lawrence Phone Number: 970-400-6303 Fiscal Manager: Leonard Bottorff Phone Number: 970-400-6537 Master Grant/Contract Agreement Number: CMS #54599 Final Due Dates: The fourth Friday of August 2020 (Aug 28, 2020). The closeout package without proper signature will not be accepted. CLOSEOUT SUMMARY CHECKLIST: Please list all the funds FROM NFA's with the period of performance ending June 30, 2020 (please create an attachment if applicable): Please list all the CLEAR program codes by the program year accordingly starting from Py17 to Fy20. Please see the example form: Program Year CLEAR Program Code CLEAR Program Code Title/Grant Budget Actual PY17 APPR 4FF7 APPRENTICESHIP PROGRAM 27,000.00 27,000.00 PY17 APPR 4FH7 APPRENTICESHIP ADMIN 3,000.00 3,000.00 PY18 WP 2058 WAGNER PEYSER 430,342.00 430,342.00 PY18 MSFW 2M58 MIGRANT SEASONAL FARM WORKER 35,034.00 35,034.00 PY18 SJH 2558 SUMMER JOB HUNT 40,000.00 40,000.00 PY18 ADULT 4A68 WIOA ADULT ADMIN 8,146.00 8,146.00 PY18 ADULT 4A88 WIOA ADULT PROGRAM 73,313.00 73,313.00 PY18 DW 4D68 DISLOCATED WORKER ADMIN 7,172.00 7,172.00 PY18 DW 4D88 DISLOCATED WORKER PROGRAM 64,547.00 64,547.00 PY18 YOUTH 4Y68 WIOA YOUTH 61,690.00 61,690.00 PY18 YOUTH 4Y78 WIOA YOUTH OUT OF SCHOOL PROG 418,071.00 418,071.00 PY18 YOUTH 4Y88 WIOA YOUTH IN SCHOOL PROGRAM 139,357.00 139,357.00 PY19 ESF 2W20 EMPLOYMENT SUPPORT FUND 340,697.00 340,697.00 FY17 TAA 17C7 TAA CASE MANAGEMENT 13,631.00 13,631.00 FY17 APPR 4FF6 APPRENTICESHIP USA STATE 37,219.00 37,219.00 If you have any questions or need assistance, please do not hesitate to contact: Sung Hong (phone: 303-318-8108 or e-mail: SunR.Hong®state.co.us), Paul Chavez (phone: 303-318-8102 or email: Pauld.Chavez®state.co.us), Bryce Green (phone: 303-318-8119 or email: Bryce.Green@state.co.us) a0 - O7539 COLORADO Department of Labor and Employment • 633 17th Street Suite 1100 Denver. CO 80202-3660 FY18 FLC 1648 FOREIGN LABOR CERTIFICATION 7,564.00 7,564.00 FY18 TM 17C8 TAA CASE MANAGEMENT 11,869.00 11,869.00 FY18 RESEA 28C8 RESEA EXPENDITURES - COUNTY 9,852.00 9,852.00 FY18 PIF 4WA7 PERFORMANCE INCENTIVE FUND 50,924.00 50,924.00 FY19 DOVP 20D9 DISABLED VETS OUTREACH PROG 17,384.00 17,384.00 FY19 ADULT 46A8 WIOA ADULT 13,296.00 13,296.00 FY19 DW 46D8 DISLOCATED WORKER ADMIN 19,000.00 19,000.00 FY19 EDW 47D8 25% ENHANCED DW ADMIN 1,981.00 1,981.00 FY19 ADULT 48A8 WIOA ADULT PROGRAM 421,200.00 421,200.00 FY19 DW 48D8 DISLOCATED WORKER PROGRAM 172,710.00 172,710.00 FY19 EDW 49D8 25% ENHANCED DW PROGRAM 117,833.00 117,833.00 FY19 ADULT 4BD8 DW ADMIN TRANSFER TO ADULT 15,000.00 15,000.00 FY19 ADULT 4ND8 DW PROGRAM TRANSFER TO ADULT 135,000.00 135,000.00 Total 2,692,832.00 2,692,832.00 I. ESF fund (CLEAR PROGRAM CODE 2W2000000) must be invoiced to CDLE by July 7th, 2020 in CLEAR by Journal Voucher UPLOAD. II. All the PROGRAM CODES from the CLOSEOUT SUMMARY CHECKLIST (BUDGET/ACTUAL) must be fully spent. There should not be any remaining balances. If there are any remaining balances, then, please provide an explanation with a screenshot of "Funds Available Inquiry " from CLEAR. Also, please work with your Regional Liaison with the remaining budget balances. III. CERTIFICATE PHYSICAL INVENTORY & PHYSICAL INVENTORY LIST: Please be sure to add Program year and CLEAR program code & the descriptions for the purchases of physical inventories. If no physical inventories were purchased, then, please use the verbiage below. See example Please identify the grant year accordingly. 0 No physical inventory purchased for the following grants: PY17 WIOA-ADULT, DW, Youth IV. Each Program Year (PY) and funding stream listed above will have the following forms completed: • Form Attachments are E, F, H, I, and CLEAR WFD Regional Report: o Attachment E - Program Income Expense Report Form o Attachment F - Stand -In Cost Repost Form o Attachment H - Grant Closeout Reconciliation Worksheet o Attachment I - Closeout Document Package - all I attachments o WFD Regional Report (Parameter: Period as of June or July 2020; Report Type - PJTD) If you have any questions or need assistance, please do not hesitate to contact: Sung Hong (phone: 303-318-8108 or e-mail: Sung.Hong@state.co.us), Paul Chavez (phone: 303-318-8102 or email: Pauld.Chavez@state.co.us), Bryce Green (phone: 303-318-8119 or email: Bryce.Green@state.co.us) 40 COLORADO Department of COLE Labor and Employment Finance: 633 17th Street, Suite 1100, Denver, CO 80202-3660 Please use the forms sent via email do not reference the attachments from the PGL website. All attachment E, F, H and I are in the spreadsheet named: SFY 2020 ACCT-PGL-FIN-2020- 08 Subrecipient-Financial -Procedures-attach-02-Closeout Package.xls. Please attach appropriate supportive documents with Attachment E, F, H, and I. It is optional to transfer information to Attachment E, F, H, and I upon sub -recipient's decision. Please submit the Grant Closeout Check List and Subrecipient Certification of Physical Inventory (the first page of Attachment I) with Authorized Signature to Colorado Department of Labor and Employment by the 4t' Friday of August. Please submit the electronic copy via email to pauld.chavez@state.co.us. I certify to the best of my knowledge and belief the following financial data reported in this closeout packet and the above statements are correctly reported along with all the attachments. „m-„_,_ AUG 2 4 2020 By: Title: Date Mike Freeman, Chair Board of Weld County Commissioners If you have any questions or need assistance, please do not hesitate to contact: Sung Hong (phone: 303-318-8108 or e-mail: Sung.Hong@state.co.us), Paul Chavez (phone: 303-318-8102 or email: Pauld.Chavez@state.co.us), Bryce Green (phone: 303-318-8119 or email: Bryce.Green@state.co.us) l clop o-02�� COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT EMPLOYMENT AND TRAINING PROGRAMS PROGRAM INCOME EXPENSE REPORT FORM (PIERF) SUBRECIPIENT: Employment Services of Weld County Calendar Qrtr End Date: June 30, 2020 1. CUMULATIVE PROGRAM INCOME CASH REPORTED ON CASH REQUEST THRU QUARTER END DATE: CLEAR Program code Amount NET (Undisbursed) LINE ITEM None 2. BUDGET ALLOCATION: Total CLEAR Program code Program Income Total CERTIFICATION: Disbursed Prog Income (Expended) Net (Undisbursed) Program Income 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 I certify to the best of my knowledge anc belief the above reported information is accurate and complete for the period reported. AUG 2 4 2020 Authorized Signature Date See instructions for completing this form on the next tab (Attachment E 2 of 2) Part 1 Page 1 of 2 020020 - 0251 ? 2 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT EMPLOYMENT AND TRAINING PROGRAMS PROGRAM INCOME EXPENSE REPORT FORM (PIERF) Part 1 Page 2 of 2 Instructions for Completing the Program Income Expense Report Form (PIERF): Subrecipient: Enter the subrecipient's name that generated the program income Calendar Quarter End Date: Enter the quarter end date in which the program income was generated CLEAR Program code: CDLE created CLEAR program code for Program Income Expense Report Form. Enter the number of the CLEAR Program code if known. 1. CLEAR Program code: Enter program code from CLEAR that the net generated prigram income was reported 2. Program Income Allocation- Cost Category (ies)/Budget Line Item (s): Enter the cost categories/budget line items that the amount reported on the Program Income Line Item will be allocated. Program Income Allocation - Income Amount: Enter the Income Budgeted amount for the expnditure of each cost category (ies)/budget line item (s) for the reporting quarter Program Income Allocation - Disbursed Income Expense: Enter the amount expended against the cost category (ies)/budget line item (s) through the reported calendar quarter end date. Total Net Program Income: Total progam Income amount and Income Disbursed/Expense columns. The Total Net Program Income is program income earned but not expended The Amounts should equal the amount recorded in the Cash Request Line Item Amount. Authorised Signature and Date: Optional signature for subrecipient's reference. COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT EMPLOYMENT AND TRAINING PROGRAMS STAND-IN COST REPORT FORM (SICRF) SUBRECIPIENT: Employment Services of Weld County Incurred During Program Year Ended: June 30, 2020 CLEAR Program code: CMS #54599 Closeout Part 2 Page 1 of 3 GRANTS Program Year of Funds COST CATEGORY(IES)/BUDGET LINE ITEM(S) Administration Program Other: Other: Total GRANT NAME WIOA Adult Current Prior Year Before Prior PY19 PY18 PY17 0.00 0.00 0.00 GRANT NAME WIOA Dislocated Workers Current Prior Year Before Prior PY19 PY18 PY17 0.00 0.00 0.00 GRANT NAME WIOA Youth Current Prior Year Before Prior PY19 PY18 PY17 0.00 0.00 0.00 GRANT NAME WIOA 10% Statewide Actv. Current Prior Year Before Prior PY19 PY18 PY17 0.00 0.00 0.00 GRANT NAME WIOA Local Admin. Current Prior Year Before Prior PY19 PY18 PY17 0.00 0.00 0.00 GRANT NAME WIOA 25% Enh. DWAdmin Current Prior Year Before Prior PY19 PY18 PY17 0.00 0.00 0.00 GRANT NAME WIOA 25% Enh. DW Program Current Prior Year Before Prior PY19 PY18 PY17 0.00 0.00 0.00 GRANT NAME WIOA 25% Innovaty. Proj. Current Prior Year Before Prior PY19 PY18 PY17 0.00 0.00 0.00 CERTIFICATION: I certify to the best of my knowledge and belief the above reported information is accurate and complete for the period reported Authorized Signature AUG 2 4 2020 Date 3 ,moo - �� COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT EMPLOYMENT AND TRAINING PROGRAMS STAND-IN COST REPORT FORM (SICRF) SUBRECIPIENT: Employment Services of Weld County Incurred During Program Year Ended: June 30, 2020 CLEAR Program code: CMS #54599 Closeout Part 2 Page 2 of 3 GRANTS Program Year of Funds COST CATEGORY(IES)/BUDGET LINE ITEM(S) Administration Program Other: Other: Total GRANT NAME Current Prior Year Before Prior GRANT NAME WIOA Wagner Peyser Current Prior Year Before Prior PY19 PY18 PY17 0.00 0.00 0.00 GRANT NAME WP 10% SJH Current Prior Year Before Prior PY19 PY18 PY17 0.00 0.00 0.00 GRANT NAME Vets DVOP Current Prior Year Before Prior PY19 PY18 PY17 0.00 0.00 0.00 GRANT NAME Vets LVER Current Prior Year Before Prior PY19 PY18 PY17 0.00 0.00 0.00 GRANT NAME Ul Reemployement Svc Current Prior Year Before Prior PY19 PY18 PY17 0.00 0.00 0.00 GRANT NAME Unemployment Ins. Current Prior Year Before Prior PY19 PY18 PY17 0.00 0.00 0.00 CERTIFICATION: I certify to the best of my knowledge and belief tie above reported information is accurate and complete for the period reported. Authorized Signature See instructions for completing this form on the next tab (Attachment F 3 of 3) AUG 2 4 2020 Date �c7ao -0768'7 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT EMPLOYMENT AND TRAINING PROGRAMS STAND-IN COST REPORT FORM (SIRF) Instructions for Completing the Stand -In Cost Report Form (SIRF): Subrecipient: Enter the subrecipient's name that incurred stand-in costs. Incurred During Program Year Ended: Enter the program year ended in which the program income cost were incurred. CLEAR Program code: CDLE created CLEAR program code for Stand -In Cost Report Form. Enter the number of the CLEAR Program code if known. Closeout Part 2 Page 3of3 Cost Category(ies)/Budget Line Item(s): Other: If Stand-in costs were incurrec against cost categories/budget line items other than Administration and Program, enter the cost category/budget line item. Program Year of Funds: For each applicable grant that incurred stand-in costs, enter the applicable program/fiscal year of funds. For example, during program year 2017, a subrecipinet could have incurred stand-in costs against its 2017 program year of funds (current), 2016 program year of funds (prior year), and 2015 program year of fund (year before prior year). As such, "17" would be entered on the Current line, "16" would be entered on the Prior Year line, and "15" would be entered on the Year Before Prior Year line. Grant Name: For each grant name, report the stand-in costs incurred, by cost category/budget line item, against the current, prior, and year before prior program/fiscal year's of funds, during the program year ended period. If stand-in costs benefitted a grant(s) other than those listed on page 1 and page 2, provide the grant name(s) on page 2 at the end of chart. Authorised Signature and Date: Optional signature for subrecipient's reference. COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part4 Page 1 of 6 SUBRECIPIENT CERTIFICATION OF PHYSICAL INVENTORY Subrecipient Name: Employment Services of Weld County Contact Person: Leonard Bottorff Address: PO Box 1805 Phone Number: 970-400-6537 Greeley CO 80632 I hereby certify that all property/equipment previously purchased with or transferred from the Workforce Investment Act (WIA), Comprehensive Employment and Training Act (CETA), or the Job Training Partnership Act (JTPA) program to the Workforce Innovation and Opportunity Act (WIOA) programs or purchased under any Colorado Department of Labor and Employment (CDLE) federally funded grant or transferred with the CDLE's approval is included in the attached listing for the above - noted subrecipient. The attached listing has been verified by a physical inventory. Changes/revisions are: ❑ Noted o Not Applicable I certify that this property is being used for purposes that it was originally purchased for and will be repaired or replaced by my insurance if damaged, lost, or stolen. I certify that all property/equipment previously purchased with or transferred from the WIA, CETA, or the JTPA programs to WIOA program or purchased under a CDLE federally funded grant or transferred with the CDLE's approval with a fair market value (FMV), established by our existing local procedures, of $5,000 or more, has been identified. I further certify that the proceeds of all property/equipment previously purchased with or transferred from the WIA, CETA, or JTPA program to the WIOA program, with a FMV of $5,000 or more, will be returned to CDLE, in order to return the proceeds to the U.S. Department of Labor. AUG 2 4 2U20 Subrecipient Director's Signature Date 02t)020, 2bIci COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT GRANT CLOSEOUT TAX CERTIFICATION In the performance of WDP Master Agreement Number Expenditure Authorizations (EAs)/Workplan allocated under above Agreement number as CLEAR Program Code : 4FF7 4FH7 2M58 , 2S58 CMS #54599 , including the 2058 4A68 4A88 4D68 4D88 4Y68 4Y78 17C7 4FF6 1648 4WA7 20D9 46A8 48A8 48D8 49D8 4Y88 2W20 17C8 28C8 46D8 47D8 4BD8 4ND8 I certify that I have complied with requirements of the law and the Colorado Department of Labor and Employment, regarding the obtaining of employer identification/account numbers; collection, payment, deposit, and reporting of federal, state, and local taxes; and the provision of W-2 forms to employees/enrollees who are not now my employees. For present employees/enrollees (formerly employed under the contract), W-2 forms will be furnished as specified in Circular E. Employer's Tax Guide. Grant Recipient Name: Employment Services of Weld County Grant Recipient Address: PO Box 1805 Greeley CO 80632 Grant Recipient Employer: Weld County Department of Human Services Employer's Identification Number: 84-6000813 This certification has been executed this oc41-14 day of , 2020. Closeout Part 4 Page 2 of 6 c:2002,0 -025E CLEAR Program code(s) 2M58 2S58 4D88 4Y68 GRANT RECIPIENT'S ASSIGNMENT OF REFUNDS, REBATES, AND CREDITS Grant Recipient's Name: Employment Services of Weld County WDP Master Agreement No: CMS #54599 Street Address: PO Box 1805 City and State: Greeley CO 80632 Pursuant to the terms of WDP Master Agreement Number Expenditure Authorizations (EAs)/Workplan awarded under Agreement, identified as 4FF7 4FH7 4A68 4Y78 17C7 4FF6 1648 4WA7 20D9 46A8 48A8 48D8 49D8 4A88 4Y88 , including the 2058 4D68 2W20 17C8 28C8 46D8 47D8 4BD8 4ND8 and in consideration of the reimbursement of costs and payment of fee, as provided in the said WDP Master Agreement and any assignment thereunder, the Grant Recipient's Name and Address (hereinafter called the Grant Recipient) does hereby: 1. Assign, transfer, set over and release to the Colorado Department of Labor and Employment (hereinafter called CDLE), all right, title and interest to all refunds, rebates credits or other amounts (including any interest thereon) arising out of the performance of the said WDP Master Agreement, together with all the rights of action accrued on which may hereafter accrue thereunder. 2. Agree to take whatever action may be necessary to effect prompt collection of as such refunds, rebates, credits or other amounts (including any interest thereon due or which may become due, and to forward promptly to CDLE. 3. Agree to cooperate fully with CDLE as to any claim or suit in connection with such refunds, rebates, credits or other amounts due (including an interest thereon): execute any protest, pleading, application, power of attorney or other papers in connection therewith; and to permit CDLE to represent it at an hearing, trial or other proceeding arising out of such claim or suit. This assignment has been executed this By Title p? day of Authorized Signature Mike Freeman,BOCC Chair , 2020. Closeout Part 4 Page 3 of 6 c2oo o - 015$ 7 G COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT SCHEDULE OF UNCLAIMED CHECKS Grant Recipient Name: Employment Services of Weld County WDP Master Agreement Number: CMS #54599 Release Date: CLEAR Program code Check Number Payee Check Amount Payee's Last Known Address None Total Amount Unclaimed This schedule has been executed this OWTayof By 2020. Authorized Signature Title Mike Freeman, BOCC Chair Closeout Part 4 Page 4 of 6 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT GRANT RECIPIENT'S RELEASE Grant Recipient's Name: Employment Services of Weld County Address: PO Box 1805, Greeley CO 80632 Pursuant to the terms of WDP Master Agreement Number Authorizations (EAs)/Workplan awarded under said WDP Master Agreement, as CLEAR Program code (s): 4FIIT 2000 2Mbh 2668 4088 4Y68 4Y78 4Y88 1648 17C8 28C8 47D8 48A8 CMS #54599 , including the Expenditure 4AftR 2W20 4WA7 2009 48O8 49O8 and in consideration of the sum of Total amount paid of 4FF7 4A88 4068 17C7 4FF6 46A8 46D8 4BD8 4ND8 $2,692,832.00 $0.00 ($ of Unclaimed Checks Total) under the said Contract to and payable of (Contractor's Name and Address) hereafter called the Grant Recipient or to its assignees, if any, the Grant Recipient, upon payment of the said sum by the COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT, hereinafter called CDLE, does remise, release, and discharge CDLE, its officers, agents, and employees, of and from all liabilities, obligations, claims, and demands whatsoever under or arising from said Contract/Grant Agreement except: 2. 3. This release has been executed this Specified claims in stated amounts or in estimated amounts where the amounts are not susceptible of exact statement by the Grant Recipient, as follows( if none, so state): CLEAR Program Code Invoice Date (If Known) Vendor Invoice or P.O. # Line Item Cost Category Amount Expected Payment Amount None Claims, together with reasonable expenses incidental thereto, based upon the liabilities of the Grant Recipient to third parties arising out of the performance of the said contract, which are not known to the Grant Recipient on the date of the execution of this release and of which the Grant Recipient gives notice in writing to the CDLE within the period specified in the said Contract/Grant Agreement. Claims after closeout, for costs which results from the liability to pay Unerployment Insurance costs under a re i ement system or to settle Worker's Compensation claims. day of By , 2020. Authorized Signature Title Mike Freeman, BOCC Chair Closeout Part 4 Page 5 of 6 0,242 _og5 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part4 Page 6 of 6 PHYSICAL INVENTORY LIST Grant Recipient Name: Employment Services of Weld County WDP Master Agreement Number: CMS #54599 Release Date: CLEAR Program code Purchase Date Description of Property Property Costs Program Funding Sources SERIAL # if applicable Property Location Property Condition No physical inventory purchased for PY17 Apprenticeship No physical inventory purchased for FY17 TAA Case Management and Apprenticeship USA State No physical inventory purchased for FY18 Foreign Labor Certification FY18 TAA Case Management, RESEA and Performance Incentive Fund No physical inventory purchased for PY18 WIOA Adult, DW, or Youth No physical inventory purchased for PY18 Migrant Seasonal Farm Worker and Summer Job Hunt No physical inventory purchased for FY19 WIOA Adult, DW and 25% Enhanced DW No physical inventory purchased for PY18-WAGNER PEYSER 90% No physical inventory purchased for FY19 Disabled VETS Outreach Total Amount I certify to the best of my knowledge and belief the above reported information is accurate and complete for the period reported. This Physical Inventory List has been executed this day dt .�/ _ 2020 By Authorized Signature Title Mike Freeman, BOCC Chair 020.20 - 02517 9 Page l of 4 WFD Regional Budget Report Period: Jul -20 Report Type: PJTD Entity: 5230 Unit Program Program Description Activity Budget Amount Actual Amount Balance Not Used(0000) 1647000000 LABOR CERTIFICATION FFY17 Not Used(0000) 7,563.90 7,563.90 0 Not Used(0000) 1648000000 LABOR CERTIFICATION FFY18 Not Used(0000) 7,564.00 7,564.00 0 Not Used(0000) 1649000000 FY19 Labor Certification Not Used(0000) 6,400.00 6,400.00 0 Not Used(0000) 17C6000000 NON-WIOA-TAA CASE MANAGEMENT FFY16 Not Used(0000) 5,400.00 5,400.00 0 Not Used(0000) 17C7000000 NON-WIOA-TAA CASE MANAGEMENT FFY17 Not Used(0000) 13,631.00 13,631.00 0 Not Used(0000) 17C8000000 NON-WIOA-TAA CASE MANAGEMENT FFY18 Not Used(0000) 11,869.00 11,869.00 0 Not Used(0000) 17C9000000 FY19-NON-WIOA-TAA CASE MANAGEMENT Not Used(0000) 60,462.00 16,042.79 44,419.21 Not Used(0000) 2035000000 FY15 DISABLED VETS OUTREACH PROG Not Used(0000) 2,000.01 2,000.01 0 Not Used(0000) 2036000000 FY16 DVOP Not Used(0000) 6,999.99 6,999.99 0 Not Used(0000) 2055000000 PY15 WAGNER PEYSER Not Used(0000) 531,185.00 531,185.00 0 Not Used(0000) 2056000000 PY16 WAGNER PEYSER Not Used(0000) 514,519.00 514,519.00 0 Not Used(0000) 2057000000 PY17-WFD-ES-WAGNER PEYSER 90% TO COUNTY ALLCOATION Not Used(0000) 444,846.00 444,846.00 0 Not Used(0000) 2058000000 PY18-WAGNER PEYSER 90% LOCAL -WP Not Used(0000) 430,342.00 430,342.00 0 Not Used(0000) 2059000000 PY19-WAGNER PEYSER 90% LOCAL -WP Not Used(0000) 427,462.00 196,783.23 230,678.77 Not Used(0000) 20D7000000 FFY17-DISABLED VETS OUTREACH PROG Not Used(0000) 7,000.00 7,000.00 0 Not Used(0000) 20D8000000 FFY18-DISABLED VETS OUTREACH PROG Not Used(0000) 17,384.00 17,384.00 0 Not Used(0000) 20D9000000 FFY19-DISABLED VETS OUTREACH PROG Not Used(0000) 17,384.00 17,384.00 0 Not Used(0000) 2886000000 UI-RESEA Expenditures -Mary Ball grant Not Used(0000) 55,100.00 55,100.00 0 Not Used(0000) 2887000000 UI-RESEA Expenditures -Mary Ball grant -92887 Not Used(0000) 4,650.00 4,650.00 0 Not Used(0000) 28C8000000 RESEA Expenditures - County Not Used(0000) 9,852.00 9,852.00 0 Not Used(0000) 28C9000000 RESEA Expenditures - County Not Used(0000) 11,897.00 11,897.00 0 Not Used(0000) 2M55000000 10% MIGRANT SSNL WRKR-PY15WP Not Used(0000) 26,675.00 26,675.00 0 Not Used(0000) 2M56000000 10% MIGRANT SSNL WRKR-PY16WP Not Used(0000) 18,166.00 18,166.00 0 Not Used(0000) 2M57000000 10% MIGRANT SSNL WRKR-PY17WP Not Used(0000) 37,506.00 37,506.00 0 Not Used(0000) 2M58000000 PY18-WP10% MIGRANT SSNL WRKR-COUNTY ONLY Not Used(0000) 35,034.00 35,034.00 0 Not Used(0000) 2554000000 PY14-WP10% SUMMER JOB HUNT PY14WP Not Used(0000) 17,621.92 17,621.92 0 Not Used(0000) 2555000000 PY15-WP10% SUMMER JOB HUNT PY14WP Not Used(0000) 40,000.00 40,000.00 0 Not Used(0000) 2S57000000 PY17-P10% SUMMER JOB HUNT Not Used(0000) 40,000.00 40,000.00 0 Not Used(0000) 2S58000000 PY18-WP10% SUMMER JOB HUNT Not Used(0000) 40,000.00 40,000.00 0 Not Used(0000) 2S59000000 PY19-WP10% SUMMER JOB HUNT Not Used(0000) 42,000.00 20,780.37 21,219.63 Not Used(0000) 2W20000000 ESF-SFY20 WFD ESF ONLY -NO CRWC Not Used(0000) 340,697.00 340,697.00 0 Not Used(0000) 2W26000000 ESF-SFY16-WFD ESF ONLY -NO CRWC Not Used(0000) 413,682.00 413,682.00 0 Page 1 of 4 Page 2 of 4 Period: Jul -20 Report Type: PJTD Entity: 5230 Unit Program Program Description Activity Budget Amount Actual Amount Balance Not Used(0000) 2W27000000 ESF-SFY17- 7/1/2016 to 6/30/2017-WFD ESF ONLY -NO CRWC Not Used(0000) 404,346.00 404,346.00 0 Not Used(0000) 2W29000000 ESF-SFY19 WFD ESF ONLY -NO CRWC Not Used(0000) 359,116.00 359,116.00 0 Not Used(0000) 46A5000000 FY16 - WIOA ADULT LOCAL ADMIN Not Used(0000) 38,721.11 38,721.11 0 Not Used(0000) 46A7000000 FY18 - WIOA ADULT LOCAL ADMIN Not Used(0000) 21,397.00 21,397.00 0 Not Used(0000) 46A8000000 FY19 -ADULT LOCAL ADMIN Not Used(0000) 13,296.00 13,296.00 0 Not Used(0000) 46A9000000 FY20 - WIOA ADULT LOCAL ADMIN Not Used(0000) 41,412.00 35,133.12 6,278.88 Not Used(0000) 4604000000 FY15 - WIA DW LOCAL ADMIN Not Used(0000) 10,010.36 10,010.36 0 Not Used(0000) 46D5000000 FY16 - WIOA DW- LOCAL ADMIN Not Used(0000) 18,281.00 18,281.00 0 Not Used(0000) 4606000000 FY17 - WIOA DW- DW LOCAL/COUNTIES ADMIN Not Used(0000) 24,759.00 24,759.00 0 Not Used(0000) 4607000000 FY18 -DW- DW ADMIN LOCAL/COUNTIES Not Used(0000) 21,411.00 21,411.00 0 Not Used(0000) 4608000000 FY19- WIOA DW- DW ADMIN LOCAL/COUNTIES Not Used(0000) 19,000.00 19,000.00 0 Not Used(0000) 4609000000 FY20 - WIOA DW ADMIN LOCAL/COUNTIES Not Used(0000) 32,368.00 30,210.77 2,157.23 Not Used(0000) 4707000000 FY18 - WIOA 25% DW ENHANCED ADMIN LOCAL/COUNTIES Not Used(0000) 13,920.00 13,920.00 0 Not Used(0000) 47D8000000 FY19- WIOA 25% DW ENHANCED ADMIN LOCAL/COUNTIES Not Used(0000) 1,981.00 1,981.00 0 Not Used(0000) 4709000000 FY20 - WIOA 25% DW ENHANCED ADMIN LOCAL/COUNTIES Not Used(0000) 11,409.00 11,409.00 0 Not Used(0000) 48A6000000 FY17 - WIOA ADULT LOCAL PROGRAM Not Used(0000) 301,080.00 190,107.10 110,972.90 Not Used(0000) 48A6000000 FY17 - WIOA ADULT LOCAL PROGRAM WIA-Direct Training Local Program(8000) 0 110,972.90 -110,972.90 Not Used(0000) 48A7000000 FY18 - WIOA ADULT LOCAL PROGRAM Not Used(0000) 401,256.00 401,256.00 0 Not Used(0000) 48A8000000 FY19 - ADULT LOCAL PROGRAM Not Used(0000) 421,200.00 421,200.00 0 Not Used(0000) 48A9000000 FY20 - WIOA ADULT LOCAL PROGRAM Not Used(0000) 372,714.00 215,762.39 156,951.61 Not Used(0000) 4807000000 FY18- WIOA DW PROGRAM LOCAL/COU Not Used(0000) 192,694.00 192,694.00 0 Not Used(0000) 4808000000 FY19- WIOA DW PROGRAM LOCAL/COUNTIES Not Used(0000) 172,710.00 172,710.00 0 Not Used(0000) 4809000000 FY20 - WIOA DW PROGRAM LOCAL/COUNTIES Not Used(0000) 291,313.00 159,098.52 132,214.48 Not Used(0000) 4906000000 FY17- WIOA 25% DW ENHANCED PROG LOCAL/COUNTIES Not Used(0000) 103,907.00 103,907.00 0 Not Used(0000) 4907000000 FY18- WIOA 25% DW ENHANCED PROG LOCAL/COUNTIES Not Used(0000) 125,285.00 125,285.00 0 Not Used(0000) 4908000000 FY19- WIOA 25% DW ENHANCED PROG LOCAL/COUNTIES Not Used(0000) 117,833.00 117,833.00 0 Not Used(0000) 4909000000 FY20- WIOA 25% DW ENHANCED PROG LOCAL/COUNTIES Not Used(0000) 102,687.00 60,293.47 42,393.53 Not Used(0000) 4A67000000 PY17 - WIOA ADULT 10% ADULT COUNTY ADMIN Not Used(0000) 3,045.00 3,045.00 0 Not Used(0000) 4A68000000 PY18 - ADULT LOCAL ADMIN Not Used(0000) 8,146.00 8,146.00 0 Not Used(0000) 4A69000000 PY19 - WIOA ADULT LOCAL ADMIN Not Used(0000) 7,768.00 7,768.00 0 Not Used(0000) 4A87000000 PY17 - WIOA ADULT PROGRAM COUNTY Not Used(0000) 57,861.00 57,861.00 0 Not Used(0000) 4A88000000 PY18 - ADULT LOCAL PROGRAM Not Used(0000) 73,313.00 73,313.00 0 Not Used(0000) 4A89000000 PY19 - WIOA ADULT LOCAL PROGRAM Not Used(0000) 69,913.00 69,913.00 0 Not Used(0000) 4605000000 FY16 - WIOA DW-LOCAL ADMIN TRANSFER ADULT Not Used(0000) 6,983.10 6,983.10 0 Page 2 of 4 Page 3 of 4 Period: Jul -20 Report Type: PJTD Entity: 5230 Unit Program Program Description Activity Budget Amount Actual Amount Balance Not Used(0000) 4607000000 FY18 - WIOA DW-ADMIN TRANSFER TO ADULT LOCALS/COUNTIES Not Used(0000) 20,874.00 20,874.00 0 Not Used(0000) 4608000000 FY19-WIOA DW ADMIN TRANSFER TO ADULT LOCALS/COUNTIES Not Used(0000) 15,000.00 15,000.00 0 Not Used(0000) 4067000000 PY17 - WIOA DW 10% COUNTY ADMIN Not Used(0000) 3,918.00 3,918.00 0 Not Used(0000) 4068000000 PY18 -DW LOCAL/COUNTIES ADMIN Not Used(0000) 7,172.00 7,172.00 0 Not Used(0000) 4069000000 PY19 -WIOA DW LOCAL ADMIN Not Used(0000) 6,822.00 6,822.00 0 Not Used(0000) 4087000000 PY17 - WIOA OW PROGRAM COUNTY Not Used(0000) 35,261.00 35,261.00 0 Not Used(0000) 4D88000000 PY18- WIOA DW LOCAL/COUNTIES PROGRAM Not Used(0000) 64,547.00 64,547.00 0 Not Used(0000) 4089000000 PY19- WIOA DW LOCAL PROGRAM Not Used(0000) 61,399.00 61,399.00 0 Not Used(0000) 4065000000 PY15 - WIOA LOCAL ADMIN TRANSFER ADULT Not Used(0000) 3,317.00 3,317.00 0 Not Used(0000) 4067000000 PY17 - WIOA OW ADMIN TRANSFER TO ADULT ADMIN COUNTY Not Used(0000) 3,917.00 3,917.00 0 Not Used(0000) 4DN7000000 PY17 - WIOA DW PROGRAM TRANSFER TO ADULT PROGRAM COUNTY Not Used(0000) 35,261.00 35,261.00 0 Not Used(0000) 4DW5000000 PY15 - WIA CWDC 5% DW COUNCIL INITIATIVES Not Used(0000) 20,490.00 20,490.00 0 Not Used(0000) 4DW6000000 PY16 - WIA CWDC 10% DW COUNCIL Not Used(0000) 15,750.00 15,750.00 0 Not Used(0000) 4ED5000000 FY16-WIOA 25% DW ENHANCED ADMIN TO LOCAL Not Used(0000) 5,122.00 5,122.00 0 Not Used(0000) 4FD5000000 FY16 - WIOA -25% DW ENHANCED PROGRAM TO LOCAL Not Used(0000) 74,841.00 74,841.00 0 Not Used(0000) 4FF6000000 FY17 WFD-APP-LOCAL-Apprenticeship Not Used(0000) 37,219.00 37,219.00 0 Not Used(0000) 4FF7000000 PY17 WFD-APPR-LOCAL PROGRAM Not Used(0000) 27,000.00 27,000.00 0 Not Used(0000) 4FH6000000 FY17 WFD-APP-LOCALAdmin Not Used(0000) 3,000.00 3,000.00 0 Not Used(0000) 4FH7000000 PY17 WFD-APPR-LOCALAdmin Not Used(0000) 3,000.00 3,000.00 0 Not Used(0000) 4605000000 FY16 - WIOA-5%-$165,000 WFD Tech Assist Locals Not Used(0000) 22,000.00 22,000.00 0 Not Used(0000) 4MT5000000 PY14-WIOA Technical Assist Traninig-TMT ADVANCE Not Used(0000) 8,000.00 8,000.00 0 Not Used(0000) 4ND6000000 FY17 - WIOA DW-LOCAL/COUNTIES PROG TRANSFER ADULT Not Used(0000) 135,000.00 86,427.90 48,572.10 Not Used(0000) 4ND6000000 FY17 - WIOA DW-LOCAL/COUNTIES PROG TRANSFER ADULT WIA-Direct Training Local Program(8000) 0 48,572.10 -48,572.10 Not Used(0000) 4ND7000000 FY18 - WIOA DW-PROGRAM TRANSFER TO ADULT LOCAL/COUNTIES Not Used(0000) 187,872.00 187,872.00 0 Not Used(0000) 4ND8000000 FY19-WIOA DW-PROGRAM TRANSFER TO ADULT LOCAL/COUNTIES Not Used(0000) 135,000.00 135,000.00 0 Not Used(0000) 4004000000 FY15 - WIA 25% DW - LTU / Hire for Colorado -ADM IN TO LOCAL Not Used(0000) 21,374.00 21,374.00 0 Not Used(0000) 4RA5000000 FY16 - WIOA WFD 5%- ADULT EVALU & CONTIN IM PR Not Used(0000) 20,000.00 20,000.00 0 Not Used(0000) 4545000000 PY15-WFD-SPNEG-LOCALADMIN Not Used(0000) 57,346.00 57,346.00 0 Not Used(0000) 4TD4000000 FY15 -WIA 25% taa case mgmt Not Used(0000) 20,000.00 20,000.00 0 Not Used(0000) 4WA7000000 FY18 - WIOA CWDC 10% COUNCIL -ADULT ETP Not Used(0000) 50,924.00 50,924.00 0 Not Used(0000) 4WD7000000 FY18 - WIOA CWDC 10% DW COUNCIL -LOCAL Not Used(0000) 7,500.00 7,500.00 0 Not Used(0000) 4WD8000000 FY19 - WIOA 10% DW CWDC COUNCIL Not Used(0000) 45,712.00 45,712.00 0 Not Used(0000) 4WD9000000 FY20 WIOA CWDC- 10% DW COUNCIL Not Used(0000) 10,000.00 10,000.00 0 Not Used(0000) 4Y65000000 PY15 - WIOA 10% YOUTH LOCAL ADMIN Not Used(0000) 61,808.92 61,808.92 0 Page 3 of 4 Page 4 of 4 Period: Jul -20 Report Type: PJTD Entity: 5230 Unit Program Program Description Activity Budget Amount Actual Amount Balance Not Used(0000) 4Y67000000 PY17- WIOA YOUTH 10% COUNTY ADMIN Not Used(0000) 30,055.00 30,055.00 0 Not Used(0000) 4Y68000000 PY18 - 10%YOUTH LOCAL ADMIN Not Used(0000) 61,690.00 61,690.00 0 Not Used(0000) 4Y69000000 PY19 - WIOA 10%YOUTH LOCAL ADMIN Not Used(0000) 57,544.00 48,242.44 9,301.56 Not Used(0000) 4Y75000000 PY15 - WIOA YOUTH MIN -75% -OUT -SCHOOL LOCAL PROGRAM Not Used(0000) 417,783.00 223,691.48 194,091.52 Not Used(0000) 4Y75000000 PY15 - WIOA YOUTH MIN-75%-OUT-SCHOOI LOCAL PROGRAM WIA-Direct Training Local Program(8000) 0 161,492.01 -161,492.01 Not Used(0000) 4Y75000000 PY15 - WIOA YOUTH MIN -75% -OUT -SCHOOL LOCAL PROGRAM YOUTH -20% -OUT -SCHOOL -WORK EXPERIENCE(8100) 0 32,599.51 -32,599.51 Not Used(0000) 4Y76000000 PY16 - WIOA YOUTH MIN -75% -OUT -SCHOOL LOCAL PROGRAM Not Used(0000) 448,607.00 206,766.74 241,840.26 Not Used(0000) 4Y76000000 PY16 - WIOA YOUTH MIN -75% -OUT -SCHOOL LOCAL PROGRAM WIA-Direct Training Local Program(8000) 0 158,549.13-158,549.13 Not Used(0000) 4Y76000000 PY16 - WIOA YOUTH MIN -75% -OUT -SCHOOL LOCAL PROGRAM YOUTH -20% -OUT -SCHOOL -WORK EXPERIENCE(8100) 0 83,291.13 -83,291.13 Not Used(0000) 4Y77000000 PY17 - WIOA OSY-75% YOUTH OUT OF SCHOOL TO COUNTIES Not Used(0000) 426,021.00 341,227.95 84,793.05 Not Used(0000) 4Y77000000 PY17 - WIOA OSY-75% YOUTH OUT OF SCHOOL TO COUNTIES YOUTH -20% -OUT -SCHOOL -WORK EXPERIENCE(8100) 0 84,793.05 -84,793.05 Not Used(0000) 4Y78000000 PY18 - YOUTH MIN -75% -OUT -SCHOOL LOCAL PROGRAM Not Used(0000) 418,071.00 334,520.00 83,551.00 Not Used(0000) 4Y78000000 PY18 - YOUTH MIN -75% -OUT -SCHOOL LOCAL PROGRAM YOUTH -20% -OUT -SCHOOL -WORK EXPERIENCE(8100) 0 83,551.00 -83,551.00 Not Used(0000) 4Y79000000 PY19 - WIOA YOUTH MIN -75% -OUT -SCHOOL LOCAL PROGRAM Not Used(0000) 390,126.00 272,294.12 117,831.88 Not Used(0000) 4Y79000000 PY19 - WIOA YOUTH MIN -75% -OUT -SCHOOL LOCAL PROGRAM YOUTH -20% -OUT -SCHOOL -WORK EXPERIENCE(8100) 0 55,581.70 -55,581.70 Not Used(0000) 4Y84000000 PY14 - WIA YOUTH IN -SCHOOL LOCAL PROGRAM Not Used(0000) 110,579.23 54,257.81 56,321.42 Not Used(0000) 4Y84000000 PY14 - WIA YOUTH IN -SCHOOL LOCAL PROGRAM WIA-Direct Training Local Program(8000) 0 56,321.42 -56,321.42 Not Used(0000) 4Y85000000 PY15 - WIOA YOUTH MAX -25% -IN -SCHOOL LOCAL PROGRAM Not Used(0000) 139,278.00 67,736.63 71,541.37 Not Used(0000) 4Y85000000 PY15 - WIOA YOUTH MAX -25% -IN -SCHOOL LOCAL PROGRAM WIA-Direct Training Local Program(8000) 0 29,012.06 -29,012.06 Not Used(0000) 4Y85000000 PY15 - WIOA YOUTH MAX -25% -IN -SCHOOL LOCAL PROGRAM YOUTH -20% -IN -SCHOOL -WORK EXPERIENCE(8200) 0 42,529.31 -42,529.31 Not Used(0000) 4Y86000000 PY16 - WIOA YOUTH MAX -25% -IN -SCHOOL LOCAL PROGRAM Not Used(0000) 30,000.00 13,426.83 16,573.17 Not Used(0000) 4Y86000000 PY16 - WIOA YOUTH MAX -25% -IN -SCHOOL LOCAL PROGRAM WIA-Direct Training Local Program(8000) 0 520 -520 Not Used(0000) 4Y86000000 PY16 - WIOA YOUTH MAX -25% -IN -SCHOOL LOCAL PROGRAM YOUTH -20% -IN -SCHOOL -WORK EXPERIENCE(8200) 0 16,053.17 -16,053.17 Not Used(0000) 4Y87000000 PY17 -WFD WIOA ISY-25% YOUTH IN SCHOOL TO COUNTIES Not Used(0000) 142,006.00 113,741.65 28,264.35 Not Used(0000) 4Y87000000 PY17 -WFD WIOA ISY-25% YOUTH IN SCHOOL TO COUNTIES YOUTH -20% -IN -SCHOOL -WORK EXPERIENCE(8200) 0 28,264.35 -28,264.35 Not Used(0000) 4Y88000000 PY18 - YOUTH MAX -25% -IN -SCHOOL LOCAL PROGRAM Not Used(0000) 139,357.00 108,477.54 30,879.46 Not Used(0000) 4Y88000000 PY18 - YOUTH MAX -25% -IN -SCHOOL LOCAL PROGRAM YOUTH -20% -IN -SCHOOL -WORK EXPERIENCE(8200) 0 30,879.46 -30,879.46 Not Used(0000) 4Y89000000 PY19 - WIOA YOUTH MAX -25% -IN -SCHOOL LOCAL PROGRAM Not Used(0000) 129,474.00 15,304.58 114,169.42 Not Used(0000) 4Y89000000 PY19 - WIOA YOUTH MAX -25% -IN -SCHOOL LOCAL PROGRAM YOUTH -20% -IN -SCHOOL -WORK EXPERIENCE(8200) 0 28,908.28 -28,908.28 Not Used(0000) 4YW6000000 PY16 - WIA CWDC 10%YOUTH COUNCIL $1,118,290.50 Not Used(0000) 48,265.00 48,265.00 0 Not Used(0000) 4YW8000000 PY18 - 10%YOUTH CWDC COUNCIL Not Used(0000) 42,500.00 42,500.00 0 Total 11,763,831.54 10,970,705.32 793,126.22 Page 4 of 4 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT SUBRECIPIENT: ADDRESS: GRANT CLOSEOUT RECONCILIATION WORKSHEET Employment Services of Weld County PO Box 1805, Greeley CO 80632 EA/WORKPLAN START DATE PROGRAM INCOME START DATE 2/14/2019 YEAR OF FUNDS Closeout Part 3 Page 1 of 2 PY17 TITLE/PROGRAM/PROJECT PY17 APPRENTICESHIP PROGRAM CLEAR Program code 4FF7000000 END DATE END DATE 6/30/2020 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 27,000.00 2. Current Program and Admin Cash Needs 27,000 00 3. FINAL Program and Admin Cash Needs Contract to Date II. PROGRAM EXPENSE REPORT (ER) ,: 1. Total Expenses+Accruals Previously Reported (Through Last Month) 25,786.62 2. Current Expenses + Accruals (Through End Date of Award) 1,213.38 3. FINAL Program Expenses Contract :o Date 27,000.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 0.00 III. PROGRAM INCOME(PI) EXPENSE REPORT 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION 1. FINAL Cash Request Contract to Da:e 27.000.00 2. FINAL Expenses Through End of Contract 27,000.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes El /No ❑ V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Total PI Cash Previously Reported of Cash Request 2. Current Program Income Cash (Thrcugh End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 VI. RECONCILIATION 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 VII. MATCH RECONCILIATION 1. FINAL Match Reported Through Enc of Contract .ti 0.00 2. FINAL Expenses Through End of Ccntract 27,000.00 3. Match Percentage of Expenditure Contracttual Requirement 0.00 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes o /No ❑ 'The program Income Expense Report and Casn Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signature / Date fill ( l i ,),..../(7v 'i( Authorized Signature AUG 2 4 Date 1020 See instruction for completing this for on the next tab (Attachment H 2 of 2) 020020--o15 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part 3 GRANT CLOSEOUT RECONCILIATION WORKSHEET Page 2 of 2 GRANT CLOSEOUT RECONCILIATION WORKSHEET INSTRUCTIONS Subrecipient: Enter the subrecipient's name Address: Enter the subrecipient's address Year of Funds: Enter the year of funds of the grants that are being closed (eg. PY17 or FY18) Title/Program/Project: Enter the title, program, and/or project name of the grant. CLEAR Program code: Enter CLEAR program code for the grant. Contract/EAlWorkplan Start/End Date: Enter the start and end date of the grant on the applicable lines. Program Income Start/End Date: If program income was generated under the grant, enter the start and end date of the program income portion of the grant on the applicable lines. I. CASH REQUEST 1.Enter the amount of program and administrative cash needs reported prior to this draw. 2. Enter the amount of current cash needs reported. 3. Add the amount from 1 to 2 above. Enter total here. II. PROGRAM EXPENSE REPORT 1. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program expenses+accruals through end of this award. 3. Add the amount from 1. to 2. above. Enter total here. ADMINISTRATIVE EXPENSE REPORT 4. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 5. Enter the amount of current admin expenses+accruals through end of this award. 6. Add the amounts from 4 to 5 above. Enter Final total here. III. PROGRAM INCOME EXPENSE REPORT 1. Enter the amount of program income expenses reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program income expenses through end of this award. 3.Add the amounts from 1 to 2. Enter total here. IV. RECONCILIATION The goal of this reconciliation is that cash drawn should equal expenses+accruals reported at the end of the award. If the answer to #3 below is NO and no PI has been reported, then adjust current cash draw or current expenses reported to achiese a YES while reflecting actual expenses per your accounting records. If PI has been earned under this award, complete V thru VI 1. Enter the amount from 1.3 here 2. Enter the amount frojm 11.3 and 111.3 here 3. Does the amount from 1. EQUAL amount from 2? Check the appropriate box. V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Enter the amount of program income cash reported as received prior to this report. 2. Enter the amount of current PI cash reported. 3. Add the amounts from 1 to 2. Enter total here. VI. RECONCILIATION The goal of this reconciliation is to determine whether PI cash earned has been spent, and if not, whether if can be spent beyond the period of performance. 1. Enter the amount from V.3 here. 2. Enter the amount from 111.3 here. 3. Enter difference of 2 from 1 here. VII. MATCH RECONCILIATION The goal of this reconciliation is that matzh met should equal or exceed expenses+accruals reported at the end of the award. If the answer to 5 is NO, additional match will be required. 1. Enter the amount of match reported through the end of this award. 2. Enter the amount from 11.3 here. 3. Enter the match requirement as a percentage of expenditures. For example, a match of 1 dollar for every 1 dollar expended (1 for 1) is 100%. Match of 1 dollar for every 2 dollars (1of 2) expended is 50%. 4. Mutiply the amount from 2 by the amount in 3. 5. Is the amount in 1. greater than or equal to the amount in 4. Check the appropriate box. Preparer's and Director's Signature and Date: Optional signature for subrecipient's reference. CLEAR WIOA Reconciliation-PY17 APPRENTICESHIP PROGRAM Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance February -19 4FF7000000 27,000.00 March -19 4FF7000000 27,000.00 April -19 4FF7000000 27,000.00 May -19 4FF7000000 1,043.54 25,956.46 June -19 4FF7000000 (1,043.54) 27,000.00 July -19 4FF7000000 27,000.00 August -19 4FF7000000 27,000.00 September -19 4FF7000000 27,000.00 October -19 4FF7000000 27,000.00 November -19 4FF7000000 27,000.00 December -19 4FF7000000 27,000.00 January -20 4FF7000000 27,000.00 February -20 4FF7000000 27,000.00 March -20 4FF7000000 4,161.48 4,161.48 4,161.48 5/6/20 22,838.52 April -20 4FF7000000 16,408.33 16,408.33 16,408.33 6/20/20 6,430.19 May -20 4FF7000000 5,216.81 5,216.81 5,216.81 7/15/20 1,213.38 June -20 4FF7000000 1,213.38 1,213.38 1,213.38 8/4/20 (0.00) Totals 27,000.00 27,000.00 27,000.00 4FF7000000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Account `.5230.0000. 6500.4FF7000000.0000.00000000', Funds Available ( Detail Balances ) Period I Feb -19 1iMar-19 Apr -19 1May-19_ lJun-19rn„ Adj-19 Jul -19____ .. Aug -19 ..:- Sep -19 iOct-19V^ Budget 27000.00 0.00 _.. _ 0.00,� 0.001 0.001___. 0.00 0.001 0.00 0.00 0.00: 27000.001 Encumbrance 0.001 0.001 0.001, 0.001 0.001 0.00 1..... _. 0.00; 0.001 0.00 0.00 0.00; Actual 0.00 . 0.00'1 0.00' 1043.54 -1043.54' 0.00 000', 0.00 0.00; 0.001, 27000.001 Funds Available 27000 00 0.00 0.00 -1043.54 1043.54 0.00 0.00" 0.00 Cancel 0.00 0.00_' 0.00 ° Period, Balances (PJTD) - Adj-20 Account 5230.0000-6500.4 FF7000000.0000.00000000' Funds Available ( Detail Balances ) Period '`Oct -19 tNov-19 ,Dec -19 !Jan -20 Feb -20 lMar-20 Apr -20 May -20 [Jun -20 Cancel Budget 0.001 0.00; 0.001 0.00 0.00.j 0.00; 0.00; Encumbrance 0.00 0.00„ 0.00' 0.001 0.00; 0.00 0.00 16408.33;s 0 00, 0.00 0.00: Actual 0.001 000 -, Funds Available 0.00 0 00 0.001 0.00 0.001 0.00�` 0.00 0.00 4161 48 -4161.48 -16408.33 5216.81_; -5216.81- 1213.38' -1213.38 0.00: o.00 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT GRANT CLOSEOUT RECONCILIATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805 Greeley CO 80632 EA/WORKPLAN START DATE PROGRAM INCOME START DATE 2/14/2019 YEAR OF FUNDS Closeout Part 3 Page 1 of 2 PY17 TITLE/PROGRAM/PROJECT PY17 APPRENTICESHIP ADMIN CLEAR Program code 4FH7000000 END DATE END DATE 6/30/2020 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 3,000.00 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date 3,000.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 0.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 0.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 1,795.29 5. Current Expenses+Accruals (Througi End Date of Awards) 1,204.71 6. FINAL Administrative Expenses Contract to Date 3,000.00 III. PROGRAM INCOME(PI) EXPENSE REPORT 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION,".,';.... „ M 1. FINAL Cash Request Contract to Date 3,000.00 2. FINAL Expenses Through End of Contract 3,000.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes D /No ❑ V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 VI. RECONCILIATION , °, ' � ,x.._ 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 VII. MATCH RECONCILIATION, ; , r 1. FINAL Match Reported Through End of Contract 0.00 2. FINAL Expenses Through End of Contract 3,000.00 3. Match Percentage of Expenditure Contracttual Requirement 0.00 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes D /No ❑ 'The program Income Expense Report and Caso Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signature Date 111)Z -O Authorized Si nature Date UG 2 4 ZOZO See instruction for completing this for on the next tab (Attachment H 2 of 2) o210e 2 -02,17 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part 3 GRANT CLOSEOUT RECONCILIATION WORKSHEET Page 2 of 2 GRANT CLOSEOUT RECONCILIATION ',WORKSHEET INSTRUCTIONS Subreciplent: Enter the subrecipient's name Address: Enter the subrecipient's address Year of Funds: Enter the year of funds of the grants that are being closed (eg. PY17 or FY18) Title/Program/Project: Enter the title, program, and/or project name of the grant. CLEAR Program code: Enter CLEAR program code for the grant. Contract/EA/Workplan Start/End Date: Enter the start and end date of the grant on the applicable lines. Program Income Start/End Date: If program income was generated under the grant, enter the start and end date of the program income portion of the grant on the applicable lines. I. CASH REQUEST 1.Enter the amount of program and administrative cash needs reported prior to this draw. 2. Enter the amount of current cash needs reported. 3. Add the amount from 1 to 2 above. Enter total here. II. PROGRAM EXPENSE REPORT 1. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program expenses+accruals through end of this award. 3. Add the amount from 1. to 2. above. Enter total here. ADMINISTRATIVE EXPENSE REPORT 4. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 5. Enter the amount of current admin expenses+accruals through end of this award. 6. Add the amounts from 4 to 5 above. Enter Final total here. Ill. PROGRAM INCOME EXPENSE REPORT 1. Enter the amount of program income expenses reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program ircome expenses through end of this award. 3.Add the amounts from 1 to 2. Enter total here. IV. RECONCILIATION The goal of this reconciliation is that cashrdrawn should equal expenses+accruals reported at the end of the award. If the answer to #3 below is NO and no PI has been reported, then adjust current can draw or current expenses reported to achiese a YES while reflecting actual expenses per your accounting records. If PI has been earned under this award, complete V thru VI 1. Enter the amount from 1.3 here 2. Enter the amount frojm 11.3 and 111.3 here 3. Does the amount from 1. EQUAL amount from 2? Check the appropriate box. V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Enter the amount of program income cash reported as received prior to this report. 2. Enter the amount of current PI cash reported. 3. Add the amounts from 1 to 2. Enter total here. VI. RECONCILIATION The goal of this reconciliation is to determine whether PI cash earned has been spent, and if not, whether if can be spent beyond the period of performance. 1. Enter the amount from V.3 here. 2. Enter the amount from 111.3 here. 3. Enter difference of 2 from 1 here. VII. MATCH RECONCILIATION The goal of this reconciliation is that match met should equal or exceed expenses+accruals reported at the end of the award. If the answer to 5 is NO, additional match will be required. 1. Enter the amount of match reported through the end of this award. 2. Enter the amount from 11.3 here. 3. Enter the match requirement as a percentage of expenditures. For example, a match of 1 dollar for every 1 dollar expended (1 for 1) is 100%. Match of 1 dollar for every 2 dollars (1 of 2) expended is 50%. 4. Mutiply the amount from 2 by the amount in 3. 5. Is the amount in 1. greater than or equal to the amount in 4. Check the appropriate box. Preparer's and Director's Signature and Date: Optional signature for subrecipient's reference. CLEAR WIOA Reconciliation-PY17 APPRENTICESHIP ADMIN Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance February -19 4FH7000000 3,000.00 March -19 4FH7000000 3,000.00 April -19 4FH7000000 3,000.00 May -19 4FH7000000 3,000.00 June -19 4FH7000000 3,000.00 July -19 4FH7000000 3,000.00 August -19 4FH7000000 1,795.29 1,795.29 1,795.29 10/2/19 1,204.71 September -19 4FH7000000 1,204.71 October -19 4FH7000000 1,204.71 November -19 4FH7000000 1,204.71 December -19 4FH7000000 1,204.71 January -20 4FH7000000 1,204.71 February -20 4FH7000000 1,204.71 March -20 4FH7000000 1,204.71 April -20 4FH7000000 1,204.71 May -20 4FH7000000 1,204.71 June -20 4FH7000000 1,204.71 1,204.71 1,204.71 8/4/20 - Totals 3,000.00 3,000.00 3,000.00 4FH7000000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Budget Encumbrance 3000.00 0.00 0.00 Account 5230.0000.6500 4FH7000000.0000.00000000 Funds Available ( Detail Balances ) Period 1 Feb -19 11Mar-19 1 0.00; Apr -19 0.001 0.00' .?May -19 0.001 0.00. ';Jun -19 0.00; 0.00:. (Adj-19 0.001 0.00 Jul -19 0.00; Aug -19 1Sep 19 'Oct -19 Period Oct -19 Nov -19 Dec -1,. 19 Jan -20 Feb -20 Mar -20 Apr -20W May 20 Jun -20 Adj-20 000 0.00; 0.00 0.00', 0.00 0.00;__.. 0.00 3000.001 0.00, Funds Available ( Detail Balances ) Budget Encumbrance 0.001 0.001 0.001 0.00 0.001 0.001 0.00: 0.001 0.001.�_0.00 0.001 0.00! 000€_u._._� _..e.. 000 0.00 0.001 0.001 0.001 o.00 3000.001 Actual 0.001 0.001 0.00:1 0.001 0.001 0.00, 0.001 1795.29 0.00 0 00'':. 3000.00 , Actual 0.00'; 0.00: 0.00 0.001 0.00 0.001 000;___ 0 00 1204.71 0.001 0.001 3000.00 Funds Available 3000.00 000 0.00 0.00 0.00,. 0.00 0.00 -1795.29 0.00 0.00 Funds Available 0.00 Account {5230,0000.6500.4FH7000000.0000.00000000 0.00 0.00 0.00 0.00 0.00 000 0.00 . -1204.71' 0.00 0.00 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part 3 GRANT CLOSEOUT RECONCILIATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805,Greeley CO 80632 EA/WORKPLAN START DATE PROGRAM INCOME START DATE 2/14/2019 YEAR OF FUNDS TITLE/PROGRAM/PROJECT CLEAR Program code Page 1 of 2 PY18 PY18 WAGNER PEYSER 2058000000 END DATE END DATE 6/30/2020 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date 430,342.00 430,342.00 II. PROGRAM EXPENSE REPORT (ER7 1 Total Expenses+Accruals Previously Reported (Through Last Month) 430,342.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 430,342.00 ADMINISTRATIVE EXPENSE (ER) "- 4. Total Expenses+Accruals Previously Reported (Through Last Month) 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 0.00 III. PROGRAM INCOME(PI) EXPENSEREPORT 1. Total Program Income Exoenses Remrted (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV RECONCILICATION 1. FINAL Cash Request Contract to Data 430,342.00 2. FINAL Expenses Through End of Contract 430,342.00 3. Cash Request to Date = Expense re3orted Through End Date of Contract? (Check Box) Yes El /No ❑ V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 VI. RECONCILIATION FINAL Program Income Cash "1. 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 VII. MATCH RECONCILIATION 1. FINAL Match Reported Through Endbf Contract 0.00 2. FINAL Expenses Through End of Contract 430,342.00 3. Match Percentage of Expenditure Ccntracttual Requirement 0.00 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes o /No ❑ 'The program Income Expense Report and cash Request can only be extended through the availability of the Award and/or Federal funding period. Preparers Signature Date 8 17120AUG2 Authorized Signature �. i�,� AUG Date 4 2020 See instruction for completing this for on the newt tab (Attachment H 2 of 2) do02o COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT GRANT CLOSEOUT RECONCILIATION WORKSHEET GRANT CLOSEOUT RECONCILIATION WORKSHEET INSTRUCTIONS Closeout Part 3 Page 2 of 2 Subreciplent: Enter the subrecipient's name Address: Enter the subrecipient's address Year of Funds: Enter the year of funds of the grants that are being closed (eg. PY17 or FY18) Title/Program/Project: Enter the title, program, and/or project name of the grant. CLEAR Program code: Enter CLEAR program code for the grant. Contract/EA/VVorkplan Start/End Date: Enter the start and end date of the grant on the applicable lines. Program Income Start/End Date: If program income was generated under the grant, enter the start and end date of the program income portion of the grant on the applicable lines. I. CASH REQUEST 1.Enter the amount of program and administrative cash needs reported prior to this draw. 2. Enter the amount of current cash needs reported. 3. Add the amount from 1 to 2 above. Enter total here. II. PROGRAM EXPENSE REPORT 1. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program expenses+accruals through end of this award. 3. Add the amount from 1. to 2. above. Enter total here. ADMINISTRATIVE EXPENSE REPORT 4. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 5. Enter the amount of current admin expenses+accruals through end of this award. 6. Add the amounts from 4 to 5 above. Enter Final total here. 111. PROGRAM INCOME EXPENSE REPORT 1. Enter the amount of program income expenses reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program income expenses through end of this award. 3.Add the amounts from 1 to 2. Enter total here. IV. RECONCILIATION The goal of this reconciliation is that cash drawn should equal expenses+accruals reported at the end of the award. If the answer to #3 below is NO and no PI has been reported, then adjust current cash draw or current expenses reported to achiese a YES while reflecting actual expenses per your accounting records. If PI has been earned under this award, complete V thru VI 1. Enter the amount from 1.3 here 2. Enter the amount frojm 11.3 and 111.3 here 3. Does the amount from 1. EQUAL amount from 2? Check the appropriate box. V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Enter the amount of program income cash reported as received prior to this report. 2. Enter the amount of current PI cash reported. 3. Add the amounts from 1 to 2. Enter total here. V/. RECONCILIATION The goal of this reconciliation is to determine whether PI cash earned has been spent, and if not, whether if can be spent beyond the period of performance. 1. Enter the amount from V.3 here. 2. Enter the amount from 111.3 here. 3. Enter difference of 2 from 1 here. VII. MATCH RECONCILIATION The goal of this reconciliation is that match met should equal or exceed expenses+accruals reported at the end of the award. If the answer to 5 is NO, additional match will be required. 1. Enter the amount of match reported through the end of this award. 2. Enter the amount from 11.3 here. 3. Enter the match requirement as a percentage of expenditures. For example, a match of 1 dollar for every 1 dollar expended (1 for 1) is 100%. Match of 1 dollar for every 2 dollars (1 of 2) expended is 50%. 4. Mutiply the amount from 2 by the amount in 3. 5. Is the amount in 1. greater than or equal to the amount in 4. Check the appropriate box. Preparer's and Director's Signature and Date: Optional signature for subrecipient's reference. CLEAR WIOA Reconciliation-PY18 WAGNER PEYSER Reporting Month IProgram Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance July -18 2058000000 430,342.00 August -18 2058000000 430,342.00 September -18 2058000000 430,342.00 October -18 2058000000 430,342.00 November -18 2058000000 430,342.00 December -18 2058000000 430,342.00 January -19 2058000000 19,447.10 19,447.10 19,447.10 3/19/19 410,894.90 February -19 2058000000 38,424.75 38,424.75 38,424.75 4/12/19 372,470.15 March -19 2058000000 40,061.51 40,061.51 40,061.51 6/24/19 332,408.64 April -19 2058000000 32,114.94 32,114.94 32,114.94 5/28/19 300,293.70 May -19 2058000000 17,740.63 17,740.63 17,740.63 7/9/19 282,553.07 June -19 2058000000 21,048.05 21,048.05 21,048.05 7/24/19 261,505.02 July -19 2058000000 51,196.94 51,196.94 51,196.94 9/5/19 210,308.08 August -19 2058000000 77,372.42 77,372.42 77,372.42 10/2/19 132,935.66 September -19 2058000000 44,530.31 44,530.31 44,530.31 11/8/19 88,405.35 October -19 2058000000 44,516.56 44,516.56 44,516.56 12/12/19 43,888.79 November -19 2058000000 43,888.79 43,888.79 43,888.79 1/13/20 - December -19 2058000000 - January -20 2058000000 - February -20 2058000000 - March -20 2058000000 - April -20 2058000000 - May -20 2058000000 - June -20 2058000000 - Totals 430,342.00 430,342.00 430,342.00 2058000000 General ledger vs billied 0.00 Billed not received j 0.00 General ledger vs. received 0.00 °Period Balances (PJTD) - Adj-20 Account 5230.0000.6500.2058000000.0000.000000001 Period Jul -18 4ug 18 Sep -18 " Oct -18 Nov -18 Dec -18 'Jan -19 1Feb-19 i[Mar-19 Apr -19 Funds Available ( Detail Balances ) Budget Encumbrance Actual Funds Available 428906.001( 0.00 : 0.00;! 428906.00- 0 001 0 00' 0 00' 0.0°- 0.00; ------- 4.00' 0.00' 0.00 0 001 0 00 0.0o; 0.00, 0.00; ---.--- 0.0M 0 00. 0.001 0.00.1 0.00, 430342 001 0.00 0.00' 0 00 0.001 0.001 ._ 0.00 0.001 19447 101 38424.751 40061 511 32114.94i 000 r 0.00' 000 -19447.10 -38424.75 -40061.51 -32114.94 .` 0.00 430342.001-_. 0.00' Cancel t]© °Period Balances (PJTD) - Adj-20 Account 15230.0000.6500.2058000000.0000.000000001 Jun -19 IAdj-19 r Jul '19 lAug-19 Sep -19 lOct-19 Nov 19 jDec 19 1Jan-20 Funds Available ( Detail Balances ) Budget 0.001 1436.001 0.001 0.00 -._ 0.001 0.00; 0001W 0.00 0.00; 430342 00' Encumbrance Actual Funds Available 0.00: 17740.63; -17740.63' ,M. 0.001° 21048 05. 19612 05 0.00i 0.001 000 0.001 51196.94i' 0 00 77372.42'; 0.001 44530.311 o.00' 0.001 0.001 0 ooi 0.001 44516.56 43888 79 0.001 0.00i 430342.001 -77372.42 -43888.79 0.00 -44516.56_ 0.00 . 0.00 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part 3 SUBRECIPIENT: ADDRESS: GRANT CLOSEOUT RECONCILIATION WORKSHEET Employment Services of Weld County PO Box 1805, Greeley CO 80632 EA/WORKPLAN START DATE PROGRAM INCOME START DATE 7/1/2019 YEAR OF FUNDS TITLE/PROGRAM/PROJECT PY18 MIGRANT SEASONAL FARM WORK CLEAR Program code Page 1 of 2 PY18 2M58000000 END DATE END DATE 6/30/2020 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date in 35,034.00 35,034.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 35,034.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 35,034.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 0.00 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 0.00 III. PROGRAM INCOME(PI) EXPENSE REPORT 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION iiiiii 1. FINAL Cash Request Contract to Date 35,034.00 2. FINAL Expenses Through End of Contract 35,034.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes 2 /No 0 V. CASH REQUEST PROGRAM INCOME CASH REPORTED in'. 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 W. RECONCILIATION 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 VII. MATCH RECONCILIATION Iii .i 1. FINAL Match Reported Through End of Contract 0.00 2. FINAL Expenses Through End of Contract 35,034.00 3. Match Percentage of Expenditure Contracttual Requirement 0.00 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes o /No ❑ *The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signature 7 Q1 /1 Date U / r 7 / 10 Authorized Signature R1,c...g, Date UG 2 4 2020 See instruction for completing this for on the next tab (Attachment H 2 of 2) 02a,2a - 026 i 3 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT GRANT CLOSEOUT RECONCILIATION WORKSHEET GRANT CLOSEOUT RECONCILIATION WORKSHEET INSTRUCTIONS Closeout Part 3 Page 2 of 2 Subreciplent: Enter the subrecipient's name Address: Enter the subrecipient's address Year of Funds: Enter the year of funds of the grants that are being closed (eg. PY17 or FY18) Title/Program/Project: Enter the title, program, and/or project name of the grant. CLEAR Program code: Enter CLEAR program code for the grant. Contract/EANVorkplan Start/End Date: Enter the start and end date of the grant on the applicable lines. Program Income Start/End Date: If program income was generated under the grant, enter the start and end date of the program income portion of the grant on the applicable lines. I. CASH REQUEST 1.Enter the amount of program and administrative cash needs reported prior to this draw. 2. Enter the amount of current cash needs reported. 3. Add the amount from 1 to 2 above. Enter total here. II. PROGRAM EXPENSE REPORT 1. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program expenses+accruals through end of this award. 3. Add the amount from 1. to 2. above. Enter total here. ADMINISTRATIVE EXPENSE REPORT 4. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 5. Enter the amount of current admin expanses+accruals through end of this award. 6. Add the amounts from 4 to 5 above. Enter Final total here. III. PROGRAM INCOME EXPENSE REPORT 1. Enter the amount of program income expenses reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program income expenses through end of this award. 3.Add the amounts from 1 to 2. Enter total here. IV. RECONCILIATION The goal of this reconciliation is that cash drawn should equal expenses+accruals reported at the end of the award. If the answer to #3 below is NO and no PI has been reported, then adjust current cash draw or current expenses reported to achiese a YES while reflecting actual expenses per your accounting records. If PI has been earned under this award, complete V thru VI 1. Enter the amount from 1.3 here 2. Enter the amount frojm 11.3 and 111.3 here 3. Does the amount from 1. EQUAL amcunt from 2? Check the appropriate box. V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Enter the amount of program income cash reported as received prior to this report. 2. Enter the amount of current PI cash reported. 3. Add the amounts from 1 to 2. Enter total here. VI. RECONCILIATION The goal of this reconciliation is to determine whether PI cash earned has been spent, and if not, whether if can be spent beyond the period of performance. 1. Enter the amount from V.3 here. 2. Enter the amount from 111.3 here. 3. Enter difference of 2 from 1 here. VII. MATCH RECONCILIATION The goal of this reconciliation is that match met should equal or exceed expenses+accruals reported at the end of the award. If the answer to 5 is NO, additional match will be required. 1. Enter the amount of match reported through the end of this award. 2. Enter the amount from 11.3 here. 3. Enter the match requirement as a percentage of expenditures. For example, a match of 1 dollar for every 1 dol ar expended (1 for 1) is 100%. Match of 1 dollar for every 2 dollars (1of 2) expended is 50%. 4. Mutiply the amount from 2 by the amcunt in 3. 5. Is the amount in 1. greater than or equal to the amount in 4. Check the appropriate box. Preparer's and Director's Signature and Date: Optional signature for subrecipient's reference. CLEAR WIOA Reconciliation-PY18 MIGRANT SEASONAL FARM WORKER Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance July -19 2M58000000 3,195.91 3,195.91 12/12/19 35,034.00 August -19 2M58000000 347.26 347.26 12/12/19 35,034.00 September -19 2M58000000 3,558.09 3,558.09 12/12/19 35,034.00 October -19 2M58000000 8,246.50 15,347.76 8,246.50 12/12/19 19,686.24 November -19 2M58000000 2,515.30 10,837.19 10,837.19 1/13/20 8,849.05 December -19 2M58000000 2,968.09 8,849.05 December -19 "B" 2M58000000 1,824.O2 8,849.05 January -20 2M58000000 308.72 8,849.05 February -20 2M58000000 1,353.89 8,849.05 March -20 2M58000000 741.36 8,849.05 April -20 2M58000000 5,983.60 4,857.79 4,857.79 6/20/20 3,991.26 May -20 2M58000000 3,991.26 3,991.26 3,991.26 7/10/20 - June -20 2M58000000 - Totals 35,034.00 35,034.00 35,034.00 2M58000000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Period_ 3 1;Aug-19 9 lsep 1 .._.—,: w jNov 19 `Dee -19 Ilan -20 Feb -20 !Mar -20 Apr 20 EMay-20 °Perlod Balances (PJ O) Ad!'- 0 Account 5230.0000.6500.2M58000000.0000.0000000C Funds Available ( Detail Balances ) Period Nov -18 Dee 18 ;Jan -19 IFeb 19� Mar -19 11Apr 19.. 1May-19 IJun-19 Adj-19 Budget 0.001 0.00 0.00! 0.00i 0.00 . 0.601 ... 0.00i • Encumbrance 0.00 0.00' 0.001 0.00, 0.001 0.003 0.00 0.00 0.001 000:, 0 00 0.001 0.00 Actual Funds Available 0.001 __. 0.001g � 0.001 0.001411 `F 0.00; 0.001111 034.001 35034.00 0003 000:' 00011 000 000; 000:.;; 0.00_. 0.00'; 0.00'' 0.001 35034.00` _.. 0.00111 0 00: 0.0010 • 35034 00°113 0.00 °Period Balances (PJT"t)j . Adj-20 Account 5230.00000.65Qt1.2M5-8010-0-010-0700007010-001-00-0C Funds Available ( Detail Balances ) Budget Encumbrance 0.001 0.001 0.001 0.001 •0001 0.001 0.00;'1 0.00 Q.00 0.0011 35034.00 Actual Funds Available 0.001 0.00i 0001' 0.001 0001 0.00 0.001 15347.76i 1534776; 0.00 10837 191 -10837.19 .- 0.001 0.00 0 004- © 000 000 _ 00k�.• 0.001 0.001 0.0011'4 000, 0.001 000':x' 0.001 485? 791 -4857.79' o.aoi 3991.261 -3991.26 0.00':; 35034.003 0.00 Cancel COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part 3 GRANT CLOSEOUT RECONCILIATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley CO 80632 EAIWORKPLAN START DATE PROGRAM INCOME START DATE 1/2/2019 YEAR OF FUNDS Page 1 of 2 PY18 TITLE/PROGRAM/PROJECT PY18 SUMMER JOB HUNT CLEAR Program code 2S58000000 END DATE END DATE 12/31/2019 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date 40,000.00 40,000.00 II. PROGRAM EXPENSE REPORT (ER) - 1. Total Expenses+Accruals Previously Reported (Through Last Month) 40,000.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 40,000.00 ADMINISTRATIVE EXPENSE (ER) is' 4. Total Expenses+Accruals Previously Reported (Through Last Month) 0.00 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 0.00 III. PROGRAM INCOME(PI) EXPENSE REPORT ,rFg 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Cate of Contract 0.00 IV. RECONCILICATION ,., n g.,Ant 1. FINAL Cash Request Contract to Date 40,000.00 2. FINAL Expenses Through End of Contract 40,000.00 3. Cash Request to Date = Expense reoorted Through End Date of Contract? (Check Box) Yes ❑ /No O V. CASH REQUEST PROGRAM INCOME CASH REPORTED q i!IV N G, .. � £x lNb�a 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 VI. RECONCILIATION cie9A k" ,. �d � 1 P �N.= 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 VII. MATCH RECONCILIATION �i ii ilh�, ,u ' � � ��ill ig 1. FINAL Match Reported Through End of Contract 0.00 2. FINAL Expenses Through End of Ccntract 40,000.00 3. Match Percentage of Expenditure Contracttual Requirement 0.00 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes 2 /No O 'The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding penod. Preparer's Signature _0011 TU j'4 / Date t 7vp 5k Authorized Signature UG 2 4 2010 Date See instruction for completing this for on the next tab (Attachment H 2 of 2) ,71)c2,0 -025n COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT GRANT CLOSEOUT RECONCILIATION WORKSHEET GRANT CLOSEOUT RECONCILIATION WORKSHEET INSTRUCTIONS Closeout Part 3 Page 2 of 2 Subrecipient: Enter the subrecipient's name Address: Enter the subrecipient's address Year of Funds: Enter the year of funds of the grants that are being closed (eg. PY17 or FY18). Title/Program/Project: Enter the title, program, and/or project name of the grant. CLEAR Program code: Enter CLEAR program code for the grant. Contract/EA/Workplan Start/End Date: Enter the start and end date of the grant on the applicable lines. Program Income Start/End Date: If program income was generated under the grant, enter the start and end date of the program income portion of the grant on the applicable lines. I. CASH REQUEST 1.Enter the amount of program and administrative cash needs reported prior to this draw. 2. Enter the amount of current cash needs reported. 3. Add the amount from 1 to 2 above. Enter total here. II. PROGRAM EXPENSE REPORT 1. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program expenses+accruals through end of this award. 3. Add the amount from 1. to 2. above. Enter total here. ADMINISTRATIVE EXPENSE REPORT 4. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 5. Enter the amount of current admin expenses+accruals through end of this award. 6. Add the amounts from 4 to 5 above. Enter Final total here. III. PROGRAM INCOME EXPENSE REPORT 1. Enter the amount of program income expenses reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program income expenses through end of this award. 3.Add the amounts from 1 to 2. Enter total here. IV. RECONCILIATION The goal of this reconciliation is that cash drawn should equal expenses+accruals reported at the end of the award. If the answer to #3 below is NO and no PI has been reported, then adjust current cash draw or current expenses reported to achiese a YES while reflecting actual expenses per your accounting records. If PI has been earned under this award, complete V thru VI 1. Enter the amount from 1.3 here 2. Enter the amount frojm 11.3 and 111.3 here 3. Does the amount from 1. EQUAL amount from 2? Check the appropriate box. V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Enter the amount of program income cash reported as received prior to this report. 2. Enter the amount of current PI cash reported. 3. Add the amounts from 1 to 2. Enter total here. VI. RECONCILIATION The goal of this reconciliation is to determine whether PI cash earned has been spent, and if not, whether if can be spent beyond the period of performance. 1. Enter the amount from V.3 here. 2. Enter the amount from 111.3 here. 3. Enter difference of 2 from 1 here. VII. MATCH RECONCILIATION The goal of this reconciliation is that match met should equal or exceed expenses+accruals reported at the end of the award. If the answer to 5 is NO, additional match will be required. 1. Enter the amount of match reported through the end of this award. 2. Enter the amount from 11.3 here. 3. Enter the match requirement as a percentage of expenditures. For example, a match of 1 dollar for every 1 dollar expended (1 for 1) is 100%. Match of 1 dollar for every 2 dollars (1 of 2) expended is 50%. 4. Mutiply the amount from 2 by the amount in 3. 5. Is the amount in 1. greater than or equal to the amount in 4. Check the appropriate box. Preparer's and Director's Signature and Date: Optional signature for subrecipient's reference. CLEAR WIOA Reconciliation-PY18 SUMMER JOB HUNT Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance January -19 2558000000 40,000.00 February -19 2S58000000 3,999.69 3,999.69 3,999.69 4/12/19 36,000.31 March -19 2S58000000 3,722.06 3,722.06 3,722.06 6/24/19 32,278.25 April -19 2558000000 4,283.87 4,283.87 4,283.87 5/28/19 27,994.38 May -19 2S58000000 3,146.27 3,146.27 3,146.27 7/9/19 24,848.11 June -19 2S58000000 3,758.59 3,758.59 3,758.59 7/24/19 21,089.52 July -19 2S58000000 3,663.50 3,663.50 3,663.50 9/5/19 17,426.02 August -19 2558000000 3,640.71 3,640.71 3,640.71 10/2/19 13,785.31 September -19 2558000000 3,699.84 3,699.84 3,699.84 10/28/19 10,085.47 October -19 2S58000000 6,316.23 6,316.23 6,316.23 12/12/19 3,769.24 November -19 2558000000 3,769.24 3,769.24 3,769.24 1/13/20 - December -19 2558000000 - Totals 40,000.00 40,000.00 40,000.00 2S58000000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 ` Period Balances (PJTD) -' Adj-20 Account ;5230.0000.6500.2658000000.0000.00000000. Funds Available ( Detail Balances ) Period Jan -19 • Feb -19 ,Mar -19 'Period Balances (PJTD) - Adj-20 „May -19 ;Jun -19 Adj-19 Account Period, Oct -19 (Nov -19 [Dec-1rv9 1Jan-20 Budget 40000.00; Encumbrance __._... D 00,x_.. •0.001 Actual Funds Available 0.00i 40000.00 3999.69' -3999.691...1 0.00( 0.001 3722 06 -3722.06q1' 0.001 0.001 0.00; 0.00€ 0.00 0.00 0.00: 0.00' .._,. 5230.0000.6500.2S58000000.0000.00000000 Funds Available ( Detail Balances ) (Feb -20 1Mar-20 [Apr -20 May -20 1Jun 2p_;. IAdj-20 Budget 0.001- 0.001 000' 0.00' ©.00 0.00! 0.00 0.00'. 0.00 • 0.001 40000.00 4283 87 -4283.871:: o.Qo[ 0.00 3758.59' -3758.59 3146 27 -3146.27' 0.001 0.00; 0.00 Encumbrance 0.00• '!. 0.001, 0.001 0.00; 0.001 0.00; 0.001 Actual Funds Available 6316.231 -6316.23.- 3769.241 -3769 24 0.001 0.00,1"• 000, 000 0.00i:.....,...._ . 0.00;'!' 000• 0.00 0.001 0.00 0.001 0.00 0.001 0.00 . 40000.001 0.00 Cancel COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part 3 SUBRECIPIENT: ADDRESS: GRANT CLOSEOUT RECONCILIATION WORKSHEET Employment Services of Weld County PO Box 1805, Greeley CO 80632 EA/WORKPLAN START DATE PROGRAM INCOME START DATE 7/1/2018 YEAR OF FUNDS Page 1 of 2 PY18 TITLE/PROGRAM/PROJECT PY18 WIOA ADULT ADMIN CLEAR Program code 4A68000000 END DATE END DATE 6/30/2020 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date 8,146.00 8,146.00 II. PROGRAM EXPENSE REPORT (ER) "� � NOR I„ a :- 1 Total Expenses+Accruals Previously Reported (Through Last Month) 0.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 0.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 8,146.00 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 8,146.00 III. PROGRAM INCOME(PI) EXPENSE REPORT 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION "-'- 1. FINAL Cash Request Contract to Date 8,146.00 2. FINAL Expenses Through End of Ccntract 8,146.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes R /No ❑ V. CASH REQUEST PROGRAM INCOME CASH REPORTED any 1. Total PI Cash Previously Reported on Cash Request 2, Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 VI. RECONCILIATION 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 VII. MATCH RECONCILIATION 1. FINAL Match Reported Through End of Contract 0.00 2. FINAL Expenses Through End of Contract 8,146.00 3. Match Percentage of Expenditure Contracttual Requirement 0.00 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes l /No El *The program Income Expense Report and Cash Request can only be extended through the availability of fire Award and/or Federal funding period. Preparer's Signature _002././..7 � 02. / 21, Date ith 7)21, Authorized Signature Date AUG 2 4 2020 See instruction for completing this for on the next tab (Attachment H 2 of 2) 0020 `025g/ I� COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part 3 GRANT CLOSEOUT RECONCILIATION WORKSHEET Page 2 of 2 GRANT CLOSEOUT RECONCILIATION WORKSHEET INSTRUCTIONS Subreciplent: Enter the subrecipient's name Address: Enter the subrecipient's address Year of Funds: Enter the year of funds cf the grants that are being closed (eg. PY17 or FY18) Title/Program/Project: Enter the title, program, and/or project name of the grant. CLEAR Program code: Enter CLEAR program code for the grant. Contract/EAlWorkplan Start/End Date: Enter the start and end date of the grant on the applicable lines. Program Income Start/End Date: If program income was generated under the grant, enter the start and end date of the program income portion of the grant on the applicable lines. I. CASH REQUEST 1.Enter the amount of program and administrative cash needs reported prior to this draw. 2. Enter the amount of current cash neecs reported. 3. Add the amount from 1 to 2 above. Enter total here. 11. PROGRAM EXPENSE REPORT 1. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program expenses+accruals through end of this award. 3. Add the amount from 1. to 2. above. Enter total here. ADMINISTRATIVE EXPENSE REPORT 4. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 5. Enter the amount of current admin expenses+accruals through end of this award. 6. Add the amounts from 4 to 5 above. Enter Final total here. III. PROGRAM INCOME EXPENSE REPORT 1. Enter the amount of program income expenses reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program income expenses through end of this award. 3.Add the amounts from 1 to 2. Enter total here. IV. RECONCILIATION The goal of this reconciliation is that cash drawn should equal expenses+accruals reported at the end of the award. If the answer to #3 below is NO and no PI has been reported, then adjust current cash draw or current expenses reported to achiese a YES while reflecting actual expenses per your accounting records. If PI has been earned under this award, complete V thru VI 1. Enter the amount from 1.3 here 2. Enter the amount frojm 11.3 and 111.3 here 3. Does the amount from 1. EQUAL amount from 2? Check the appropriate box. V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Enter the amount of program income cash reported as received prior to this report. 2. Enter the amount of current PI cash reported. 3. Add the amounts from 1 to 2. Enter total here. VI. RECONCILIATION The goal of this reconciliation is to determine whether PI cash earned has been spent, and if not, whether if can be spent beyond the period of performance. 1. Enter the amount from V.3 here. 2. Enter the amount from 111.3 here. 3. Enter difference of 2 from 1 here. VII. MATCH RECONCILIATION The goal of this reconciliation is that match met should equal or exceed expenses+accruals reported at the end of the award. If the answer to 5 is NO, additional match will be required. 1. Enter the amount of match reported through the end of this award. 2. Enter the amount from 11.3 here. 3. Enter the match requirement as a percentage of expenditures. For example, a match of 1 dollar for every 1 dollar expended (1 for 1) is 100%. Match of 1 dollar for every 2 dollars (1of 2) expended is 50%. 4. Mutiply the amount from 2 by the amount in 3. 5. Is the amount in 1. greater than or equal to the amount in 4. Check the appropriate box. Preparer's and Director's Signature and Date: Optional signature for subrecipient's reference. CLEAR WIDA Reconciliation -P1'18 WIDA ADULT ADMIN Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance July -18 4A68000000 8,146.00 August -18 4A68000000 8,146.00 September -18 4A68000000 8,146.00 October -18 4A68000000 8,146.00 November -18 4A68000000 8,146.00 December -18 4A68000000 8,146.00 January -19 4A68000000 8,146.00 February -19 4A68000000 8,146.00 March -19 4A68000000 8,146.00 April -19 4A68000000 8,146.00 May -19 4A68000000 8,146.00 June -19 4A68000000 7,790.90 7,790.90 7,790.90 7/24/19 355.10 July -19 4A68000000 355.10 August -19 4A68000000 355.10 355.10 355.10 10/2/19 - September -19 4A68000000 - October -19 4A68000000 - November -19 4A68000000 - December -19 4A68000000 January -20 4A68000000 February -20 4A68000000 March -20 4A68000000 April -20 4A68000000 May -20 4A68000000 June -20 4A68000000 July -20 4A68000000 - Totals 8,146.00 8,146.00 8,146.00 4A68000000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 °Period Balances (PJTD) Adj-20 Account 15230.0000.6500.4A68000000.0000.00000000 Funds Available ( Detail Balances ) Period Jul 18 Aug -18 Sep -18 iOct-18 Dec-18�___ Jan -19 _..., Feb -19 ..._. IMar-19 lApr-19 Budget 8146.001 0.00i 000; 0.001 0.00 0.00 0.00 0.001 0.00 .__.... 0.00 46.00 'Period Balances (PJTD) - Adj-20 Encumbrance 0001 0A01µ_ 0.00' 0.00 0001 0.00, 0.00; 0.00' 0 00' 0.00; Actual Funds Available 0.001 8146.00 0.001 0 00 0.001 0.00I 0.00 0.001 0.00;1 00or 0.001 0.00 0.00' 0.00 .. 0.001 8146.00; 0.00 ..................... Cancel Account 15230.0000.6500.4A68000000.0000.00000000 IJun-19 Adj-18 `(Jul 19 Aug -19,. ISep-19 jOct-19 Nov -19 Dec -19. Jan -20_._ 8146.00'1. Funds Available ( Detail Balances ) Budget 0.00 0.001 0.00i 0 00 0.00' 0.00 0.001 0.001 0.00' 0.00 Encumbrance 0.00 0.00 0.00. 000 0.00 0.00 , 0.00 0.00, 0.001 0.001 Actual 0.001 7790.90 0.00 355.101 0.00 0.001 0.00I 0.001 0.001 0.001 8146.00, Funds Available 0.00- -7790.90 e' 0.0011-, 000, , -355.10`i` 0.00 0.00 0.00 0.00 0.00 0.00 Cancel COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT GRANT CLOSEOUT RECONCILIATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley CO 80632 EA/WORKPLAN START DATE PROGRAM INCOME START DATE 7/1/2018 YEAR OF FUNDS Closeout Part 3 Page 1 of 2 PY18 TITLE/PROGRAM/PROJECT PY18 WIOA ADULT PROGRAM CLEAR Program code 4A88000000 END DATE END DATE 6/30/2020 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date 73,313.00 73,313.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 73,313.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 73,313.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 0.00 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 0.00 III. PROGRAM INCOME(PI) EXPENSE REPORT ,' -. 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION �,;r,. ' q 1. FINAL Cash Request Contract to Date 73,313.00N 2. FINAL Expenses Through End of Contract 73,313.00 3, Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes El /No O V. CASH REQUEST PROGRAM INCOME CASH REPORTED ;i „',,, 0,„ "1 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 VI. RECONCILIATION ,I 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 VII. MATCH RECONCILIATION . " �� )1f- 1. FINAL Match Reported Through End of Contract 0.00 2. FINAL Expenses Through End of Contract 73,313.00 3. Match Percentage of Expenditure Contracttual Requirement 0.00 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes o /No O 'The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signature /�% / % Date 1 ) 'v Authorized Signature R.�(,.f,•-.�... AU� Date 2 4 2020 See instruction for completing this for on the next tab (Attachment H 2 of 2) .2o020 .76Y 9 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT GRANT CLOSEOUT RECONCILIATION WORKSHEET GRANT CLOSEOUT RECONCILIATION WORKSHEET INSTRUCTIONS Closeout Part 3 Page 2 of 2 Subreciplent: Enter the subrecipient's name Address: Enter the subrecipient's address Year of Funds: Enter the year of funds of the grants that are being closed (eg. PY17 or FY18). Title/Program/Project: Enter the title, program, and/or project name of the grant. CLEAR Program code: Enter CLEAR program code for the grant. Contract/EA/Workplan Start/End Date: Enter the start and end date of the grant on the applicable lines. Program Income Start/End Date: If program income was generated under the grant, enter the start and end date of the program income portion of the grant on the applicable lines. I. CASH REQUEST 1.Enter the amount of program and administrative cash needs reported prior to this draw. 2. Enter the amount of current cash needs reported. 3. Add the amount from 1 to 2 above. Enter total here. II. PROGRAM EXPENSE REPORT 1. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program expenses+accruals through end of this award. 3. Add the amount from 1. to 2. above. Enter total here. ADMINISTRATIVE EXPENSE REPORT 4. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 5. Enter the amount of current admin expenses+accruals through end of this award. 6. Add the amounts from 4 to 5 above. Enter Final total here. III. PROGRAM INCOME EXPENSE REPORT 1. Enter the amount of program income expenses reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program income expenses through end of this award. 3.Add the amounts from 1 to 2. Enter total here. IV. RECONCILIATION The goal of this reconciliation is that cash drawn should equal expenses+accruals reported at the end of the award. If the answer to #3 below is NO and no PI has been reported, then adjust current cash draw or current expenses reported to achiese a YES while reflecting actual expenses per your accounting records. If PI has been earned under this award, complete V thru VI 1. Enter the amount from 1.3 here 2. Enter the amount frojm 11.3 and 111.3 here 3. Does the amount from 1. EQUAL amount from 2? Check the appropriate box. V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Enter the amount of program income cash reported as received prior to this report. 2. Enter the amount of current PI cash reported. 3. Add the amounts from 1 to 2. Enter total here. VI. RECONCILIATION The goal of this reconciliation is to determine whether PI cash earned has been spent, and if not, whether if can be spent beyond the period of performance. 1. Enter the amount from V.3 here. 2. Enter the amount from 111.3 here. 3. Enter difference of 2 from 1 here. VII. MATCH RECONCILIATION The goal of this reconciliation is that math met should equal or exceed expenses+accruals reported at the end of the award. If the answer to 5 is NO, additional match will be required. 1. Enter the amount of match reported through the end of this award. 2. Enter the amount from 11.3 here. 3. Enter the match requirement as a percentage of expenditures. For example, a match of 1 dollar for every 1 dollar expended (1 for 1) is 100%. Match of 1 dollar for every 2 dollars (1 of 2) expended is 50%. 4. Mutiply the amount from 2 by the amount in 3. 5. Is the amount in 1. greater than or equal to the amount in 4. Check the appropriate box. Preparer's and Director's Signature and Date: Optional signature for subrecipient's reference. CLEAR WIOA Reconciliation-PY18 WIOA ADULT PROGRAM Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance July -18 4A88000000 73,313.00 August -18 4A88000000 73,313.00 September -18 4A88000000 73,313.00 October -18 4A88000000 73,313.00 November -18 4A88000000 73,313.00 December -18 4A88000000 73,313.00 January -19 4A88000000 73,313.00 February -19 4A88000000 73,313.00 March -19 4A88000000 73,313.00 April -19 4A88000000 73,313.00 May -19 4A88000000 45,282.83 45,282.83 45,282.83 7/9/19 28,030.17 June -19 4A88000000 28,030.17 28,030.17 28,030.17 7/24/19 - July -19 4A88000000 - August -19 4A88000000 - September -19 4A88000000 - October -19 4A88000000 - November -19 4A88000000 - December -19 4A88000000 January -20 4A88000000 February -20 4A88000000 March -20 4A88000000 April -20 4A88000000 May -20 4A88000000 June -20 4A88000000 July -20 4A88000000 - Totals 73,313.00 73,313.00 73,313.00 4A88000000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Budget 73313.00; 0.00; 0.00!1 0.00' 0.00 Funds Available 73313.00 Encumbrance Actual o.00 1 0.00; 1 0.001 .._ 0.00; 0.00 Account {5230.0000.6500.4A88000000.0000.00000000' Period May -19 Account 15230.0000.6500.4A88000000.0000.00000000 Funds Available ( Detail Balances ) Period Jul -18 ;Aug -18 Sep -18 Oct -18 ;Nov -18" .............. Dec -18 "Period Balances (PJTD) - Adj-20 I • Jun -19 IAdj-19 [Jul -19 Aug -19 ;Sep -19 [Oct -19 1Nov-19 1Dec-19 [Jan -20 Funds Avalable ( Detail Balances ) Budget Encumbrance 000 000 0.00'x 0.00' 0.00' o.00 0.001 0.00 o.00 o.00 0.00 0.00; 0.00' o.00: t ... o.00' 0.00, 0.00]. o.00! o.00[ 0.00;___ o.00 0.00, 0 00, 0.00; 0.00.:1 0.00! 000 0 00 0.00:i 0 00= 0.001 73313.00 0 00 73313.001-1-1-- i 0.001_.. Actual 45282.831 28030.171 000 0.00 1 0.00 0.00 0.00 0.001 0.001 73313,00 0.00 0.00 0.00 0.00"°. 000. 0.00 0.00 0.00 0.00 Cancel Funds Available 45282.83,�< -28030.17 0.00 0.00/, w`' 0.00 : 0.00 0.00. 0.00 0.00 0.00 -' 0.00 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT SUBRECIPIENT: ADDRESS: GRANT CLOSEOUT RECONCILIATION WORKSHEET Employment Services of Weld County PO Box 1805, Greeley CO 80632 EAIWORKPLAN START DATE PROGRAM INCOME START DATE 7/1/2018 YEAR OF FUNDS TITLE/PROGRAM/PROJECT PY18 DISLOCATED WORKER ADMIN CLEAR Program code Closeout Part 3 Page 1 of 2 PY18 4D68000000 END DATE END DATE 6/30/2020 I. CASH REQUEST' 1. Total program and Admin Cash needs Preciously Reported 7,172.00 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date 7,172.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 0.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 0.00 ADMINISTRATIVE EXPENSE (ER) li°N Ill 16 .; u b, 4. Total Expenses+Accruals Previously Reported (Through Last Month) 7,172.00 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 7,172.00 III. PROGRAM INCOME(PI) EXPENSE REPORT 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION 1. FINAL Cash Request Contract to Da:e 7,172.00 2. FINAL Expenses Through End of Contract 7,172.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes o /No ❑ V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Thrcugh End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 VI. RECONCILIATION 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 VII. MATCH RECONCILIATION 1. FINAL Match Reported Through Enc of Contract 0.00 2. FINAL Expenses Through End of Ccntract 7,172.00 3. Match Percentage of Expenditure Contracttual Requirement 0.00 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes o /No ❑ *The program Income Expense Report and Casn Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signature Date)1OAuthorized dG' iOQ�YY Signature ieutz..........._„ Date 2 4 ZUZU See instruction for completing this 'for on the next tab (Attachment H 2 of 2) c A c20a20- 02517 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT GRANT CLOSEOUT RECONCILIATION WORKSHEET GRANT CLOSEOUT RECONCILIATION WORKSHEET INSTRUCTIONS Closeout Part 3 Page 2 of 2 Subrecipient: Enter the subrecipient's name Address: Enter the subrecipient's address Year of Funds: Enter the year of funds of the grants that are being closed (eg. PY17 or FY18). Title/Program/Protect: Enter the title, prcgram, and/or project name of the grant, CLEAR Program code: Enter CLEAR program code for the grant. ContractlEA/Workplan Start/End Date: Enter the start and end date of the grant on the applicable lines. Program Income Start/End Date: If program income was generated under the grant, enter the start and end date of the program income portion of the grant on the applicable lines. I. CASH REQUEST 1.Enter the amount of program and administrative cash needs reported prior to this draw. 2. Enter the amount of current cash needs reported. 3. Add the amount from 1 to 2 above. Enter total here. /1. PROGRAM EXPENSE REPORT 1. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program expenses+accruals through end of this award. 3. Add the amount from 1. to 2. above. Enter total here. ADMINISTRATIVE EXPENSE REPORT 4. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 5. Enter the amount of current admin expenses+accruals through end of this award. 6. Add the amounts from 4 to 5 above. Enter Final total here. M. PROGRAM INCOME EXPENSE REPORT 1. Enter the amount of program income expenses reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program income expenses through end of this award. 3.Add the amounts from 1 to 2. Enter total here. IV. RECONCILIATION The goal of this reconciliation is that cash drawn should equal expenses+accruals reported at the end of the award. If the answer to #3 below is NO and no PI has been reported, then adjust current cash draw or current expenses reported to achiese a YES while reflecting actual expenses per your accounting records. If PI has been earned under this award, complete V thru VI 1. Enter the amount from 1.3 here 2. Enter the amount frojm 11.3 and 111.3 here 3. Does the amount from 1. EQUAL amount from 2? Check the appropriate box. V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Enter the amount of program income cash reported as received prior to this report. 2. Enter the amount of current PI cash reported. 3. Add the amounts from 1 to 2. Enter total here. VI. RECONCILIATION The goal of this reconciliation is to determine whether PI cash earned has been spent, and if not, whether if can be spent beyond the period of performance. 1. Enter the amount from V.3 here. 2. Enter the amount from 111.3 here. 3. Enter difference of 2 from 1 here. VII. MATCH RECONCILIATION The goal of this reconciliation is that match met should equal or exceed expenses+accruals reported at the end of the award. If the answer to 5 is NO, additional match will be required. 1. Enter the amount of match reported through the end of this award. 2. Enter the amount from 11.3 here. 3. Enter the match requirement as a percentage of expenditures. For example, a match of 1 dollar for every 1 dollar expended (1 for 1) is 100%. Match of 1 dollar for every 2 dollars (1 of 2) expended is 50%. 4. Mutiply the amount from 2 by the amount in 3. 5. Is the amount in 1. greater than or equal to the amount in 4. Check the appropriate box. Preparer's and Director's Signature and Date: Optional signature for subrecipient's reference. CLEAR WIOA Reconciliation-PY18 DISLOCATED WORKER ADMIN Reporting Month IProgram Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance July -18 4D68000000 7,172.00 August -18 4D68000000 7,172.00 September -18 4D68000000 260.99 260.99 2/8/19 7,172.00 October -18 4D68000000 516.88 516.88 2/8/19 7,172.00 November -18 4D68000000 1,148.31 1,148.31 2/8/19 7,172.00 December -18 4D68000000 2,180.70 4,106.88 2,180.70 2/8/19 3,065.12 12/1/2018 "B" 4D68000000 1,612.04 1,612.04 3/19/19 3,065.12 12/1/2018 "C" 4D68000000 37.37 37.37 3/19/19 3,065.12 January -19 4D68000000 1,649.41 1,415.71 February -19 4D68000000 440.55 440.55 440.55 4/12/19 975.16 March -19 4D68000000 975.16 975.16 975.16 6/24/19 - April -19 4D68000000 - May -19 4D68000000 - June -19 4D68000000 - July -19 4D68000000 - August -19 4D68000000 - September -19 4D68000000 - October -19 4D68000000 - November -19 4D68000000 - December -19 4D68000000 - January -20 4D68000000 - February -20 4D68000000 - March -20 4D68000000 - April -20 4D68000000 - May -20 4D68000000 - June -20 4D68000000 - July -20 4D68000000 - Totals 7,172.00 7,172.00 7,172.00 4D68000000 General ledger vs bullied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Account 15230.0000.6500.4D68000000.0000.00000000 Period Jul -18' Aug -18 �ep_18 (Oct -18 Nov -18 W dDec-18 Jan -19 1Feb 19 ;Mar-19mm IApr-19 Funds Available ( Detail Balances ) Budget 7172.00;__.,. 0.00i 0.00'! 0 00 0.00! 0.00€ Encumbrance 0.00 0.00; 0.001 0.001 000; 0.00' 0.00,' 0.06f 0.00;! 0.001, Actual Funds Available 0.00 7172.00 -M 0.00 0.001 0.00 4106.88 1649.41 440.55 975.16 !^ 0.001 7172.001 0.00 000 ' 0.00 0.00 -4106.88 -1649.41 -440.55 -975.16 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part 3 GRANT CLOSEOUT RECONCILIATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley CO 80632 EA/WORKPLAN START DATE PROGRAM INCOME START DATE 7/1/2018 YEAR OF FUNDS TITLE/PROGRAM/PROJECT PY18 DISLOCATED WORKER PROG CLEAR Program code Page 1 of 2 PY18 4D88000000 END DATE END DATE 6/30/2020 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 64,547.00 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date 64,547.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 64,547.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 64,547.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 0.00 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Ccntract to Date 0.00 III. PROGRAM INCOME(PI) EXPENSE REPORT 1. Total Program Income Exoenses Reoorted (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Cate of Contract 0.00 IV, RECONCILICATION 1. FINAL Cash Request Contract to Date 64,547.00 2. FINAL Expenses Through End of Contract 64,547.00 3. Cash Request to Date = Expense reoorted Througi End Date of Contract? (Check Box) Yes ❑ /No O V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Total PI Cash Previously Reported on Cash Request � t .G, 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 W. RECONCILIATION 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 VII. MATCH RECONCILIATION 1. FINAL Match Reported Through End of Contract 0.00 2. FINAL Expenses Through End of Contract 64,547.00 3. Match Percentage of Expenditure Contracttual Requirement 0.00 4. Match Expenditure Requirement 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) 0.00 Yes o /No O 'The program Income Expense Report and Casn Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signature Date O I 1 ) s.O i::::AV.V. Authorized Signature AU6 2 4 2020 Date See instruction for completing this for on the next tab (Attachment H 2 of 2) ao.2o-02x'89 0 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part 3 GRANT CLOSEOUT RECONCILIATION WORKSHEET Page 2 of 2 GRANT CLOSEOUT RECONCILIATION WORKSHEET INSTRUCTIONS Subrecipient: Enter the subrecipient's name Address: Enter the subrecipient's address Year of Funds: Enter the year of funds of the grants that are being closed (eg. PY17 or FY18) Title/Program/Project: Enter the title, program, and/or project name of the grant. CLEAR Program code: Enter CLEAR program code for the grant. Contract/EA/Workplan Start/End Date: Enter the start and end date of the grant on the applicable lines. Program Income Start/End Date: If program income was generated under the grant, enter the start and end date of the program income portion of the grant on the applicable lines. I. CASH REQUEST 1.Enter the amount of program and administrative cash needs reported prior to this draw. 2. Enter the amount of current cash needs reported. 3. Add the amount from 1 to 2 above. Enter total here. II. PROGRAM EXPENSE REPORT 1. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program expenses+accruals through end of this award. 3. Add the amount from 1. to 2. above. Enter total here. ADMINISTRATIVE EXPENSE REPORT 4. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 5. Enter the amount of current admin expenses+accruats through end of this award. 6. Add the amounts from 4 to 5 above. Enter Final total here. III. PROGRAM INCOME EXPENSE REPORT 1. Enter the amount of program income expenses reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the ambunt of current program income expenses through end of this award. 3.Add the amounts from 1 to 2. Enter total here. IV. RECONCILIATION The goal of this reconciliation is that cash drawn should equal expenses+accruals reported at the end of the award. If the answer to #3 below is NO and no PI has been reported, then adjust current cash draw or current expenses reported to achiese a YES while reflecting actual expenses per your accounting records. If PI has been earned under this award, complete V thru VI 1. Enter the amount from 1.3 here 2. Enter the amount frojm 11.3 and 111.3 here 3. Does the amount from 1. EQUAL amount from 2? Check the appropriate box. V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Enter the amount of program income cash reported as received prior to this report. 2. Enter the amount of current PI cash reported. 3. Add the amounts from 1 to 2. Enter total here. VI. RECONCILIATION The goal of this reconciliation is to determine whether PI cash earned has been spent, and if not, whether if can be spent beyond the period of performance. 1. Enter the amount from V.3 here. 2. Enter the amount from 111.3 here. 3. Enter difference of 2 from 1 here. VII. MATCH RECONCILIATION The goal of this reconciliation is that math met should equal or exceed expenses+accruals reported at the end of the award. If the answer to 5 is NO, additional match will be required. 1. Enter the amount of match reported through the end of this award. 2. Enter the amount from 11.3 here. 3. Enter the match requirement as a percentage of expenditures. For example, a match of 1 dollar for every 1 dollar expended (1 for 1) is 100%. Match of 1 dollar for every 2 dollars (1 of 2) expended is 50%. 4. Mutiply the amount from 2 by the amount in 3. 5. Is the amount in 1. greater than or equal to the amount in 4. Check the appropriate box. Preparer's and Director's Signature and Date: Optional signature for subrecipient's reference. CLEAR WIOA Reconciliation -P1'18 DISLOCATED WORKER PROGRAM Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received ( Grant Balance July -18 4D88000000 64,547.00 August -18 4D88000000 64,547.00 September -18 4D88000000 6,465.27 64,547.00 October -18 4D88000000 28,271.10 64,547.00 November -18 4D88000000 18,803.19 64,547.00 December -18 4D88000000 11,007.44 64,547.00 64,547.00 2/8/19 - 12/1/2018"B" 4D88000000 - 12/1/2018"C" 4D88000000 - January -19 4D88000000 - February -19 4D88000000 - March -19 4D88000000 - April -19 4D88000000 - May -19 4D88000000 - June -19 4D88000000 - July -19 4D88000000 - August -19 4D88000000 - September -19 4D88000000 - October -19 4D88000000 - November -19 4D88000000 - December -19 4D88000000 - January -20 4D88000000 - February -20 4D88000000 - March -20 4D88000000 - April -20 4D88000000 - May -20 4D88000000 - June -20 4D88000000 - Totals 64,547.00 64,547.00 64,547.00 4D88000000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 ° Period Balances ,(NM) - Adj-20 Account 15230.0000.6500.4D88000000.0000.00000000 Period Jul -18 Aug -18 Sep -18 Oct -18 Nov -18 Dec -18 Jan -19.. Funds Available ( Detail Balances ) Budget 64547.00 0.00! 0.00 0.00 0.00 0.001 0.04, 0.001 0.00 0.001 Encumbrance Actual 0 00, 0 00 0.00.1 0.001 0.00' 0.001 64547.00! -64547.00n 0.00 0.001 0.001 0.001 • o 0.00! 0.001 64547.00 r 0.00[. Funds Available 64547.00,7„ 0.00. 0.00'!` 0.00 0.00 0.00 0 00 0.00 0.003 0.001 0.00,:' Cancel COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part 3 GRANT CLOSEOUT RECONCILIATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley CO 80632 EA/VVORKPLAN START DATE PROGRAM INCOME START DATE 7/1/2018 YEAR OF FUNDS TITLE/PROGRAM/PROJECT CLEAR Program code Page 1 of 2 PY18 PY18 WIOA YOUTH 4Y68000000 END DATE END DATE 6/30/2020 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date 61,690.00 61,690.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 61,690.00 2. Current Expenses + Accruals (Through End Date of Award) 61,690.00 3. FINAL Program Expenses Contract to Date ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 0.00 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 0.00 III. PROGRAM INCOME(PI) EXPENSE REPORT v A' 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION 1. FINAL Cash Request Contract to Date 61,690.00 2. FINAL Expenses Through End of Contract 61,690.00 3. Cash Request to Date = Expense reported Througi End Date of Contract? (Check Box) Yes o /No 0 1/. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 W. RECONCILIATION 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance - 0.00 VII. MATCH RECONCILIATION ,, ° 1. FINAL Match Reported Through End of Contract 0.00 2. FINAL Expenses Through End of Contract 61,690.00 3. Match Percentage of Expenditure Contracttual Requirement 0.00 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes 2 /No 0 'The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signature,51" Date p J �� Authorized Signature Date A 6 2 4 2020 See instruction for completing this for on the next tab (Attachment H 2 of 2) 0l10 -025g9 ,R COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT GRANT CLOSEOUT RECONCILIATION WORKSHEET GRANT CLOSEOUT RECONCILIATION WORKSHEET INSTRUCTIONS Closeout Part 3 Page 2 of 2 Subreciplent: Enter the subrecipient's name Address: Enter the subrecipient's address Year of Funds: Enter the year of funds of the grants that are being closed (eg. PY17 or FY18) Title/Program/Project: Enter the title, program, and/or project name of the grant. CLEAR Program code: Enter CLEAR program code for the grant. Contract/EANVorkplan Start/End Date: Enter the start and end date of the grant on the applicable lines. Program Income Start/End Date: If program income was generated under the grant, enter the start and end date of the program income portion of the grant on the applicable lines. I. CASH REQUEST 1.Enter the amount of program and administrative cash needs reported prior to this draw. 2. Enter the amount of current cash needs reported. 3. Add the amount from 1 to 2 above. Enter total here. II. PROGRAM EXPENSE REPORT 1. Enter the amount of expenses+accrua s reported pricy to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program expenses+accruals through end of this award. 3. Add the amount from 1. to 2. above. Enter total here. ADMINISTRATIVE EXPENSE REPORT 4. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 5. Enter the amount of current admin expenses+accruals through end of this award. 6. Add the amounts from 4 to 5 above. Enter Final total here. III. PROGRAM INCOME EXPENSE REPORT 1. Enter the amount of program income expenses reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program income expenses through end of this award. 3.Add the amounts from 1 to 2. Enter total here. IV. RECONCILIATION The goal of this reconciliation is that cash drawn should equal expenses+accruals reported at the end of the award. If the answer to #3 below is NO and no PI has been reported, then adjust current cash draw or current expenses reported to achiese a YES while reflecting actual expenses per your accounting records. If P1 has been earned under this award, complete V thru VI 1. Enter the amount from 1.3 here 2. Enter the amount frojm 11.3 and 111.3 here 3. Does the amount from 1. EQUAL amount from 2? Check the appropriate box. V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Enter the amount of program income cash reported as received prior to this report. 2. Enter the amount of current PI cash reported. 3. Add the amounts from 1 to 2. Enter total here. V/. RECONCILIATION The goal of this reconciliation is to determine whether PI cash earned has been spent, and if not, whether if can be spent beyond the period of performance. 1. Enter the amount from V.3 here. 2. Enter the amount from 111.3 here. 3. Enter difference of 2 from 1 here. VII. MATCH RECONCILIATION The goal of this reconciliation is that match met should equal or exceed expenses+accruals reported at the end of the award. If the answer to 5 is NO, additional match will be required. 1. Enter the amount of match reported through the end of this award. 2. Enter the amount from 11.3 here. 3. Enter the match requirement as a percentage of expenditures. For example, a match of 1 dollar for every 1 dollar expended (1 for 1) is 100%. Match of 1 dollar for every 2 dollars (1of 2) expended is 50%. 4. Mutiply the amount from 2 by the amount in 3. 5. Is the amount in 1. greater than or equal to the amount in 4. Check the appropriate box. Preparer's and Director's Signature and Date: Optional signature for subrecipient's reference. CLEAR WIOA Reconciliation-PY18 WIOA YOUTH Reporting Month [Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance July -18 4Y68000000 61,690.00 August -18 4Y68000000 61,690.00 September -18 4Y68000000 61,690.00 October -18 4Y68000000 61,690.00 November -18 4Y68000000 55.36 61,690.00 December -18 4Y68000000 3,009.65 3,065.01 3,065.01 2/13/19 58,624.99 12/1/2018 "B" 4Y68000000 5,183.64 58,624.99 12/1/2018 "C" 4Y68000000 120.16 58,624.99 January -19 4Y68000000 5,303.80 5,303.80 4/8/19 53,321.19 February -19 4Y68000000 2,470.72 2,470.72 2,470.72 4/16/19 50,850.47 March -19 4Y68000000 4,068.43 4,068.43 4,068.43 7/3/19 46,782.04 April -19 4Y68000000 4,129.85 4,129.85 4,129.85 6/5/19 42,652.19 May -19 4Y68000000 5,214.16 5,214.16 5,214.16 7/16/19 37,438.03 June -19 4Y68000000 8,952.74 8,952.74 8,952.74 7/30/19 28,485.29 July -19 4Y68000000 28,485.29 August -19 4Y68000000 2,436.93 2,436.93 2,436.93 10/10/19 26,048.36 September -19 4Y68000000 5,541.88 5,541.88 5,541.88 11/19/19 20,506.48 October -19 4Y68000000 4,346.93 4,346.93 4,346.93 12/17/19 16,159.55 November -19 4Y68000000 6,892.98 6,892.98 6,892.98 1/14/20 9,266.57 December -19 4Y68000000 2,709.49 2,709.49 2,709.49 2/11/20 6,557.08 12/1/2019 "C" 4Y68000000 4,864.04 6,557.08 January -20 4Y68000000 4,864.04 4,864.04 3/10/20 1,693.04 February -20 4Y68000000 1,693.04 1,693.04 1,693.04 4/28/20 - March -20 4Y68000000 - April -20 4Y68000000 - May -20 4Y68000000 - June -20 4Y68000000 - Totals 61,690.00 61,690.00 61,690.00 4Y68000000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 °Period Balances (PJTD) - Adj-20 Account 1,5230.0000.6500.4Y68000000.0000.00000000' Funds Available ( Detail Balances ) Period [Nov -17 !Dec -17 l Jan -18 1Feb-18 Mar -18 Apr -18 1May-18 [Jun -18 lgdj-18 6Ju1-18 °Period Balances (PJTD) r Adj-20 Budget 0.00,1 0.00 0.001 0.001 0.00 1 0.00 0.001 0.001 0.001 61690.001 61690.00! Encumbrance r- Account 15230.0000.6500.4Y68000000.0000.00000000, :Sep -18 1Oct-18 ;[Nov -18 I111 Dec -18 Jan -19 1Feb-19 l.- i3Mar-19 ,1Apr-19 0001 0.00' 0.00, 0.00!_._... 0.00F 0.001 .., 0 00, 0.00 I 0.001 Encumbrance 0.00' 0.00i 0.001 -3065.011,, 0.001 5303 803 -5303.8011- _._,, 0.001! 001 2470.721 -2470.72''' 4068.43i -4068.43, ' Funds Available ( Detail Balances ) Budget 0.001 0.00. 0.001 0.001 0.001 0,00 000: 0.00{ o.00[ Actual 0.001 0.001 0001�� 0.00 0.001 0.00, 0.00! 0.00' 000. 0.001 61690 00 Funds Available 0.00„±-, 0.000 0.00 0.00 0.00 0.00 0.00 0.00;, 0.00 61690.00 0.00 0.001 0.001 4129.851 -4129 85 3065.011 Actual Funds Available 0.00 .._ 0.00 - 000 0.00 000'1 0.00; 0.00,; 0.00':. 0.00': 61690.00 5214.16': -5214.16;.' �._ 0.00,1__61690.00 0.00 0.00 °Period Balances (PJTD) - Ad1-20 Account 5230.0000.6500.4Y68000000.0000.00000000 Funds Available ( Detail Balances ) Period ;Jun -19 Adj-19 aJul-19 Aug -19 ;Sep -19 C1Ct-19 INov-19 Dec -19 IJan-20 Budget 0.00; 0.00 0.00: 0.001 0.00; ao0 0.001 0.00 0.00 61690.00 Encumbrance 0.00_ 0.00 000; 0.003 0.00; 0.00 0.00 0.00 0.00 0.00: Actual Funds Available 8952.74; -8952.74 0.00; 0.00 0.00; 0.00 2436 93 -2436.93; 5541.88; -5541.88 ,, 4346.93; -4346.93 6892.98, -6892.98; 2709.49, -2709.49 4864.04 E -4864.04 1693.04 -1693.04 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT GRANT CLOSEOUT RECONCILIATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley CO 80632 EA/WORKPLAN START DATE PROGRAM INCOME START DATE 7/1/2018 YEAR OF FUNDS TITLE/PROGRAM/PROJECT PY18 WIOA YOUTH OUT OF SCHOOL CLEAR Program code Closeout Part 3 Page 1 of 2 PY18 4Y78000000 END DATE END DATE 6/30/2020 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 418,071.00 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash NeEIS Contract to Date 418,071.00 II. PROGRAM EXPENSE REPORT (Eli) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 418,071.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 418,071.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 0.00 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 0.00 III. PROGRAM INCOME(PI) EXPENSEiREPORT 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV RECONCILICATION 1. FINAL Cash Request Contract to Date 418,071.00 2. FINAL Expenses Through End of Contract 418,071.00 3. Cash Request to Date = Expense reported Througi End Date of Contract? (Check Box) Yes D /No O V. CASH REQUEST PROGRAM INCOME CASH REPORTED l , , 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contrst to Date 0.00 VI. RECONCILIATION 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contrac: End Date 0.00 3. Total PI Cash Balance 0.00 VII. MATCH RECONCILIATION �'It L �� yr � 1. FINAL Match Reported Through Enchof Contract 0.00 2. FINAL Expenses Through End of Contract 418,071.00 3. Match Percentage of Expenditure Cantracttual Requirement 0.00 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes D /No O 'The program Income Expense Report and Cash Request can on.'y be extended through the availability of the Award and/or Federal funding period. Preparer's Signature Date e/ v6v ,4V r1 Date AUG 2 4 Z0Z0 Authorized Signature -Gk- See instruction for completing this for on the neu; tab (Attachment H 2 of 2) pap - O26 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT GRANT CLOSEOUT RECONCILIATION WORKSHEET GRANT CLOSEOUT RECONCILIATION WORKSHEET INSTRUCTIONS Closeout Part 3 Page 2 of 2 Subrecipient: Enter the subrecipient's name Address: Enter the subrecipient's address Year of Funds: Enter the year of funds of the grants that are being closed (eg. PY17 or FY18) Title/Program/Project: Enter the title, program, and/or project name of the grant. CLEAR Program code: Enter CLEAR program code for the grant. Contract/EA/Workplan Start/End Date: Enter the start and end date of the grant on the applicable lines. Program Income Start/End Date: If program income was generated under the grant, enter the start and end date of the program income portion of the grant on the applicable lines. I. CASH REQUEST 1.Enter the amount of program and administrative cash needs reported prior to this draw. 2. Enter the amount of current cash needs reported. 3. Add the amount from 1 to 2 above. En:er total here. II. PROGRAM EXPENSE REPORT 1. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program expenses+accruals through end of this award. 3. Add the amount from 1. to 2. above. Enter total here. ADMINISTRATIVE EXPENSE REPORT 4. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 5. Enter the amount of current admin expenses+accruals through end of this award. 6. Add the amounts from 4 to 5 above. Eiter Final total here. III. PROGRAM INCOME EXPENSE REPORT 1. Enter the amount of program income expenses reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program income expenses through end of this award. 3.Add the amounts from 1 to 2. Enter total here. IV. RECONCILIATION The goal of this reconciliation is that cash drawn should equal expenses+accruals reported at the end of the award. If the answer to #3 below is NO and no PI has been reported, then adjust current cash draw or current expenses reported to achiese a YES while reflecting actual expenses per your accounting records. If PI has been earned under this award, complete V thru VI 1. Enter the amount from 1.3 here 2. Enter the amount frojm 11.3 and 111.3 here 3. Does the amount from 1. EQUAL amount from 2? Check the appropriate box. V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Enter the amount of program income cash reported as received prior to this report. 2. Enter the amount of current PI cash reported. 3. Add the amounts from 1 to 2. Enter total here. VI. RECONCILIATION The goal of this reconciliation is to determine whether PI cash earned has been spent, and if not, whether if can be spent beyond the period of performance. 1. Enter the amount from V.3 here. 2. Enter the amount from 111.3 here. 3. Enter difference of 2 from 1 here. VII. MATCH RECONCILIATION The goal of this reconciliation is that match met should equal or exceed expenses+accruals reported at the end of the award. If the answer to 5 is NO, additional match will be required. 1. Enter the amount of match reported through the end of this award. 2. Enter the amount from 11.3 here. 3. Enter the match requirement as a percentage of expenditures. For example, a match of 1 dollar for every 1 dollar expended (1 for 1) is 100% . Match of 1 dollar for every 2 dollars (1 of 2) expended is 50%. 4. Mutiply the amount from 2 by the amount in 3. 5. Is the amount in 1. greater than or equal to the amoult in 4. Check the appropriate box. Preparer's and Director's Signature and Date: Optional signature for subrecipient's reference. CLEAR WIOA Reconciliation-PY18 WIOA YOUTH OUT OF SCHOOL PROGRAM Reporting Month 'Program Code I Tracking Sheet I CLEAR I CLEAR I Received I Date Received I Grant Balance July -18 4Y78000000 418,071.00 August -18 4Y78000000 418,071.00 September -18 4Y78000000 666.70 418,071.00 October -18 4Y78000000 37,853.62 418,071.00 November -18 4Y78000000 33,076.49 418,071.00 December -18 4Y78000000 40,623.30 112,220.11 112,220.11 2/8/19 305,850.89 12/1/2018 "B" 4Y78000000 11,923.14 305,850.89 12/1/2018 "C" 4Y78000000 (235.83) 305,850.89 January -19 4Y78000000 20,371.75 32,059.06 32,059.06 3/19/19 273,791.83 February -19 4Y78000000 34,325.85 34,325.85 34,325.85 4/12/19 239,465.98 March -19 4Y78000000 33,366.93 33,366.93 33,366.93 6/24/19 206,099.05 April -19 4Y78000000 34,754.89 34,754.89 34,754.89 5/28/19 171,344.16 May -19 4Y78000000 42,951.42 42,951.42 42,951.42 7/9/19 128,392.74 June -19 4Y78000000 21,921.85 21,921.85 21,921.85 7/24/19 106,470.89 July -19 4Y78000000 29,631.85 (37,897.92) 67,529.77 29,631.85 9/519 76,839.04 August -19 4Y78000000 34,261.45 30,357.52 3,903.93 34,261.45 10/2/20 42,577.59 September -19 4Y78000000 39,652.65 28,540.60 11,112.05 39,652.65 11/8/19 2,924.94 October -19 4Y78000000 2,924.94 1,919.69 1,005.25 2,924.94 12/12/19 0.00 November -19 4Y78000000 0.00 December -19 4Y78000000 0.00 12/1/2019 "C" 4Y78000000 0.00 January -20 4Y78000000 0.00 February -20 4Y78000000 0.00 March -20 4Y78000000 0.00 April -20 4Y78000003 0.00 May -20 4Y78000003 0.00 June -20 4Y78000000 0.00 Totals 418,071.00 334,520.00 83,551.00 418,071.00 4Y78000000 General ledger vs billied 0.00 Billed not received I 0.00 0.00 General ledger vs. received 0.00 Account ,5230.0000.6500.4Y78000000.0000.00000000 Funds Available ( Detail Balances ) Period I Jul -18 ;Aug -18 1Sep-18 Oct -18 Dec -18 ;[Jan -19 ;Feb -19 Mar -19 Apr -19 Budget 416406.001 0.00' 0.00! 0.00! 0.001 0.001 0.00! 0.00! 0.00! 0.00! Encumbrance 000;_..._. 0.001 0 00 0.001 000! o.00lw:. 0oo1..ry 0.001 0.00j 0.00! 418071.001 0.00. Account 15230.0000.6500.4V78000000.0000.00000000 Period 1' ;Jun -19 ?Adj-19 ;Jul -19 ._ Aug -19 'Sep -19 loct-19 [Nov -19 May -19 Funds Avaiable ( Detail Balances ) Budget 0001 1665.00 0.001__ 0 oo 0.00? 0.001 0.001 o.00l -0.001 0.001 418071.00 Encumbrance 0.00! 0.001 0.00 0.001 0.0011-- 0.00i 0.001 y' 0.001 0.00( 0.00 0.00, 0.001 112220 111 32059 061 34325.851 33366.93' 34754.89! 334520.00: Actual 42951 42 21921.85; 0.00i -37897.92- 30357.52! 28540.60! 1919.69; Funds Available 416406.00 0.00,x.., 0.00` 000. 0.00 11222011 32059.06 -34325.85 -33366.93 -34754.89. 83551.00. Cancel'. Funds Available -42951.42 - -20256.85 w 0.00, 37897 92 -30357.52 -28540.60 -1919.69 0.00; 0.00 0.001 0.00 000j --r- 334520.00i 0.00 83551.00 Cancel °Period Balances (PJTD) - Adj-20 c" Period Balances (PJTD) - Adj-20 Account 5230.0000.6500.4Y78000000.0000.00000000' Funds Available ( Detail Balances ) Period lAd1 19 Jul 19 Aug -19 !Sep -19 Oct -19 :Nov -19 1Dec-19 ;Jan -20T ;Feb -20 Mar -20 Budget 0.00:�__ 0.00' 0.00 _... 0.00 0.00 0.00 a00i 0.00: 0.00 0.001 0.00'; i Encumbrance Actual 0.00 0.00; 0.001, 000 0.001 0.001 0.001 0.001 0.00E 0.00- 0.001 0.001 67529 771 3903.93 11112.05 1005.25': 0.001 0.001 0.001 0.001 0.001 83551.001 Funds Available 000 -67529.77: �-3903.93:1 -11112.05 -1005.25 0.00 0.00 0.00 0.00 -83551.00 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT GRANT CLOSEOUT RECONCILIATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley CO 80632 EA/WORKPLAN START DATE PROGRAM INCOME START DATE 7/1/2018 YEAR OF FUNDS TITLE/PROGRAM/PROJECT PY18 WIOA YOUTH IN SCHOOL PROG CLEAR Program code Closeout Part 3 Page 1 of 2 PY18 4Y88000000 END DATE END DATE 6/30/2020 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date 139,357.00 139,357.00 II. PROGRAM EXPENSE REPORT (ER) d ;. 1. Total Expenses+Accruals Previously Reported (Through Last Month) 139,357.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract :o Date 139,357.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 0.00 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 0.00 III. PROGRAM INCOME(PI) EXPENSE REPORT 1. Total Program Income Exoenses Reported (Last Quarter) 2, Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV RECONCILICATION h,., ..„ 1. FINAL Cash Request Contract to Date 139,357.00 2. FINAL Expenses Through End of Contract 139,357.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes R /No ❑ V. CASH REQUEST PROGRAM INCOME CASH REPORTED "' 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Thrcugh End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 VI. RECONCILIATION 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 WI. MATCH RECONCILIATION 1. FINAL Match Reported Through Enc of Contract 0.00 2. FINAL Expenses Through End of Contract 139,357.00 3. Match Percentage of Expenditure Contracttual Requirement 0.00 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes 2 /No ❑ *The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding period Preparer's Signature j Date _Ph 2/ 2o iDate �� Authorized Signature AUG 2 4 2020 ��.►� See instruction for completing this for on the next tab (Attachment H 2 of 2) 02o02.0 -0258 '� COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT GRANT CLOSEOUT RECONCILIATION WORKSHEET GRANT CLOSEOUT RECONCILIATION WORKSHEET INSTRUCTIONS Closeout Part 3 Page 2 of 2 Subrecipient: Enter the subrecipient's name Address: Enter the subrecipient's address Year of Funds: Enter the year of funds of the grants that are being closed (eg. PY17 or FY18) Title/Program/Project: Enter the title, program, and/or project name of the grant. CLEAR Program code: Enter CLEAR program code for the grant. Contract/EA/Workplan Start/End Date: Enter the start and end date of the grant on the applicable lines. Program Income Start/End Date: If program income was generated under the grant, enter the start and end date of the program income portion of the grant on the applicable lines. I. CASH REQUEST 1.Enter the amount of program and administrative cash needs reported prior to this draw. 2. Enter the amount of current cash needs reported. 3. Add the amount from 1 to 2 above. Enter total here. II. PROGRAM EXPENSE REPORT 1. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program expenses+accruals through end of this award. 3. Add the amount from 1. to 2. above. Enter total here. ADMINISTRATIVE EXPENSE REPORT 4. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 5. Enter the amount of current admin expenses+accruals through end of this award. 6. Add the amounts from 4 to 5 above. Enter Final total here. /1I. PROGRAM INCOME EXPENSE REPORT 1. Enter the amount of program income expenses reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program income expenses through end of this award. 3.Add the amounts from 1 to 2. Enter total here. IV. RECONCILIATION The goal of this reconciliation is that cash drawn should equal expenses+accruals reported at the end of the award. If the answer to #3 below is NO and no PI has been reported, then adjust current cash draw or current expenses reported to achiese a YES while reflecting actual expenses per your accounting records. If PI has been earned under this award, complete V thru VI 1. Enter the amount from 1.3 here 2. Enter the amount frojm 11.3 and 111.3 here 3. Does the amount from 1. EQUAL amount from 2? Check the appropriate box. V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Enter the amount of program income cash reported as received prior to this report. 2. Enter the amount of current PI cash reported. 3. Add the amounts from 1 to 2. Enter total here. VI. RECONCILIATION The goal of this reconciliation is to determine whether PI cash earned has been spent, and if not, whether if can be spent beyond the period of performance. 1. Enter the amount from V.3 here. 2. Enter the amount from 111.3 here. 3. Enter difference of 2 from 1 here. VII. MATCH RECONCILIATION The goal of this reconciliation is that match met should equal or exceed expenses+accruals reported at the end of the award. If the answer to 5 is NO, additional match will be required. 1. Enter the amount of match reported through the end of this award. 2. Enter the amount from 11.3 here. 3. Enter the match requirement as a percentage of expenditures. For example, a match of 1 dollar for every 1 dollar expended (1 for 1) is 100%. Match of 1 dollar for every 2 dollars (1 of 2) expended is 50%. 4. Mutiply the amount from 2 by the amount in 3. 5. Is the amount in 1. greater than or equal to the amount in 4. Check the appropriate box. Preparer's and Director's Signature and Date: Optional signature for subrecipient's reference. CLEAR WIOA Reconciliation-PY18 WIOA YOUTH IN SCHOOL PROGRAM Reporting Month 'Program Code I Tracking Sheet I CLEAR I CLEAR I Received I Date Received I Grant Balance July -18 4Y88000000 139,357.00 August -18 4Y88000000 139,357.00 September -18 4Y88000000 139,357.00 October -18 4Y88000000 308.69 139,357.00 November -18 4Y88000000 558.15 139,357.00 December -18 4Y88000000 2,533.12 3,399.96 3,399.96 2/8/19 135,957.04 12/1/2018 "B" 4Y88000000 1,078.88 1,078.88 3/19/19 135,957.04 12/1/2018"C" 4Y88000000 135,957.04 January -19 4Y88000000 3,234.73 4,313.61 3,234.73 3/19/19 131,643.43 February -19 4Y88000000 3,239.77 3,239.77 3,239.77 4/12/19 128,403.66 March -19 4Y88000000 5,911.28 5,911.28 5,911.28 6/24/19 122,492.38 April -19 4Y88000000 9,355.08 9,355.08 9,355.08 5/28/19 113,137.30 May -19 4Y88000000 14,600.61 14,600.61 14,600.61 7/9/19 98,536.69 June -19 4Y88000000 10,945.32 10,945.32 10,945.32 7/24/19 87,591.37 July -19 4Y88000000 3,793.49 (23,697.51) 27,491.00 3,793.49 9/5/19 83,797.88 August -19 4Y88000000 8,270.80 8,270.80 308.69 8,270.80 10/2/19 75,218.39 September -19 4Y88000000 3,923.55 3,923.55 (308.69) 3,923.55 11/8/19 71,603.53 October -19 4Y88000000 11,480.86 11,480.86 11,480.86 12/12/19 60,122.67 November -19 4Y88000000 7,582.70 7,582.70 7,582.70 1/13/20 52,539.97 December -19 4Y88000000 11,949.57 11,949.57 11,949.57 2/5/20 40,590.40 January -20 4Y88000000 6,704.03 6,704.03 6,704.03 3/20/20 33,886.37 February -20 4Y88000000 11,421.93 8,033.47 3,388.46 11,421.93 4/23/20 22,464.44 March -20 4Y88000000 9,461.04 9,461.04 9,461.04 5/6/20 13,003.40 April -20 4Y88000000 4,524.11 4,524.11 4,524.11 6/20/20 8,479.29 May -20 4Y88000000 3,105.72 3,105.72 3,105.72 7/10/20 5,373.57 June -20 4Y88000000 5,373.57 5,373.57 5,373.57 8/4/20 0.00 Totals 139,357.00 108,477.54 30,879.46 139,357.00 4Y88000000 General ledger vs billied 0.00 Billed not received I 0.00 0.00 General ledger vs. received 0.00 ° Period Balances (PJTD) - Adj-20 Account 15230.0000.6500.4Y88000000.0000.00000000' Period ,Mar -18 Funds Available ( Detail Balances ) Budget Apr -18 May -18 Jun -18 mm Adj-18 Jul -18 Aug -18 Sep -18 Oct -18 Nov -18 °Period Balances (PJTD) - Adj-20 Encumbrance 0.00 0.001 f 0.00 0.00i 0.001 .___. 0.00E 0.001 138802.001 0.001 0.00 0.001 0.00: 0.001 139357.00 Account ,5230.0000.6500 4Y88000000.0000.00000000 Period Dec -18 ;Jan -19 1Feb-19 ,Mar -19 '1Apr-19 u :May-19 Jul-19 ug-19 Funds Available ( Detail Balances ) Budget 0.00' 0.00 i 0.001 Actual 0.00, o.oa 0.001 0.00 0 00 0 00' 0.00; 0.00' 0.001 0.00 0.00 0.00'. 0.00 0.00 0.00! Encumbrance o.00 o.00 0.001 0.001 0.00 0001 0.00 0.001__ 0.00 555.00[ 0.00,1 0.001 0 0O 0.00' 0.00 139357.00 0.00 0.001 000 Actual 3399.96' 4313.61' 3239.77' 5911.28 9355.08' 14600.61 10945 32 0.00' -23697.51, 8270.80 Funds Available 0.00. 0.00i1,_ 0.00 `, 0.00 0.00.:: 138802.00 0.00 0.00 0.00 0.00 _ 79.46 Funds Available 3399.96 -4313.61 -3239.77 -5911.28 -9355.08 -14600.61. -10390.32 0.00 23697 51 -8270.80', 0.001 108477.541 30879.46 °Period Balances (PJTD) - A4j-20 Account ?5230.0000.6500.4Y88000000.0000.00000000'. Period ,1Sep-19 Nov -19 Dec -19 _ Jan -20 ,Feb 20 tMar-20 _..; Apr -20 i M ay -20 Jun -20 Funds Available ( Detail Balances ) Budget 0.00'I 0.00! 0.001 0.001v v 0.00 ,,.. .. 0.001 0.00! 0.00 0.00 139357.00, !' Encumbrance 0.00' 000'' 0.001 0.00 0.00 0.00! 0.00! 0.00l Actual 3923.55 11480.86 7582.70 6704.031 8033.47! 9461 041 4524.11 3105.72 5373.57! 108477.541 Funds Available -3923.55 -11480.86 -7582.70 -11949.57 , -6704.03 -8033.47 -9461.04 -4524.11 -3105.72 -5373.57 30879.46', °Period Balances (PJTD) - Adj-20 .., ROD Account 5230.0000.55004Y88000000.0000.00000000 Period Jul -19 Aug -19 Sep -19 !!Oct -19 Nov -19 Dec -19 !Jan -20 1Feb-20 Mar -20 Apr -20 Funds AvaiLble ( Detail Balances ) Budget 0.001 0.001 0.001 Encumbrance 0.00 0.00 0.00 0.001 0.00 0.001 0.00 0.00 0.00 0.00 0.00 0.00' -r- 3388.461 0.001 0.001 Actual Funds Available 27491.001 -27491.00 0.00! 0.00 0.00; 0.00,, 308.69 -308.69 -308.691 308.69 0001 000 0.00'. 0.00 -3388.46 .` 0.00 0.00 0.00 I 0.00! 30879.46! -30879.46 Cancel COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part 3 GRANT CLOSEOUT RECONCILIATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley CO 80632 EA/WORKPLAN START DATE PROGRAM INCOME START DATE 7/1/2019 YEAR OF FUNDS TITLE/PROGRAM/PROJECT PY19 EMPLOYMENT SUPPORT FUND CLEAR Program code Page 1 of 2 PY19 2W20000000 END DATE END DATE 6/30/2020 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 340,697.00 2. Current Program and Admin Cash Nesds 3. FINAL Program and Admin Cash Nevis Contract to Date 340,697.00 II. PROGRAM EXPENSE REPORT (ER1 1. Total Expenses+Accruals Previously Reported (Through Last Month) 340,697.00 2. Current Expenses + Accruals (Through End Date ox Award) 3. FINAL Program Expenses Contract b Date 340,697.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 0.00 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 0.00 III. PROGRAM INCOME(PI) EXPENSE REPORT 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV RECONCILICATION 1. FINAL Cash Request Contract to Date 340,697.00 2. FINAL Expenses Through End of Contract 340,697.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes ❑ /No 0 V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 VI. RECONCILIATION 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 VII. MATCH RECONCILIATION 1. FINAL Match Reported Through Endoof Contract 0.00 2. FINAL Expenses Through End of Contract 340,697.00 3. Match Percentage of Expenditure Contracttual Requirement 0.00 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes 2 /No 0 "The program Income Expense Report and Casha4equest can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signature ` Date ��l71 o I I7 7 ^/ �` 2U2U Authorized Signature — Date "" See instruction for completing this for on the nerc tab (Attachment H 2 of 2) 020020-o? COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT GRANT CLOSEOUT RECONCILIATION WORKSHEET GRANT CLOSEOUT RECONCILIATION WORKSHEET INSTRUCTIONS Closeout Part 3 Page 2 of 2 Subrecipient: Enter the subrecipient's name Address: Enter the subrecipient's address Year of Funds: Enter the year of funds of the grants that are being closed (eg. PY17 or FY18). Title/Program/ProJect: Enter the title, program, and/or project name of the grant. CLEAR Program code: Enter CLEAR program code for the grant. Contract/EA/Workplan Start/End Date: Enter the start and end date of the grant on the applicable lines. Program Income Start/End Date: If program income was generated under the grant, enter the start and end date of the program income portion of the grant on the applicable lines. I. CASH REQUEST 1.Enter the amount of program and administrative cash needs reported prior to this draw. 2. Enter the amount of current cash needs reported. 3. Add the amount from 1 to 2 above. Enter total here. II. PROGRAM EXPENSE REPORT 1. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program expenses+accruals through end of this award. 3, Add the amount from 1. to 2. above. Enter total here. ADMINISTRATIVE EXPENSE REPORT 4. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 5. Enter the amount of current admin expenses+accruals through end of this award. 6. Add the amounts from 4 to 5 above. Enter Final total here. III. PROGRAM INCOME EXPENSE REPORT 1. Enter the amount of program income expenses reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program income expenses through end of this award. 3.Add the amounts from 1 to 2. Enter tota. here. IV. RECONCILIATION The goal of this reconciliation is that cash drawn should equal expenses+accruals reported at the end of the award. If the answer to #3 below is NO and no PI has been reported, then adjust current cash draw or current expenses reported to achiese a YES while reflecting actual expenses per your accounting records. If PI has been earned under this award, complete V thru VI 1. Enter the amount from 1.3 here 2. Enter the amount frojm 11.3 and 111.3 here 3. Does the amount from 1. EQUAL amount from 2? Check the appropriate box. V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Enter the amount of program income cash reported as received prior to this report. 2. Enter the amount of current PI cash reported. 3. Add the amounts from 1 to 2. Enter total here. VI. RECONCILIATION The goal of this reconciliation is to determine whether PI cash earned has been spent, and if not, whether if can be spent beyond the period of performance. 1. Enter the amount from V.3 here. 2. Enter the amount from 111.3 here, 3. Enter difference of 2 from 1 here. VII. MATCH RECONCILIATION The goal of this reconciliation is that math met should equal or exceed expenses+accruals reported at the end of the award. If the answer to 5 is NO, additional match will be required. 1. Enter the amount of match reported through the end of this award. 2. Enter the amount from 11.3 here. 3. Enter the match requirement as a permntage of expenditures. For example, a match of 1 dollar for every 1 dollar expended (1 for 1) is 100%. Match of 1 dollar for every 2 dollars (1 of 2) expended is 50%. 4. Mutiply the amount from 2 by the amount in 3. 5. Is the amount in 1. greater than or equal to the amount in 4. Check the appropriate box. Preparer's and Director's Signature and Date: Optional signature for subrecipient's reference. CLEAR WIOA Reconciliation-PY19 EMPLOYMENT SUPPORT FUND Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance July -19 2W20000000 8,205.62 340,697.00 August -19 2W20000000 7,254.06 340,697.00 September -19 2W20000000 33,376.89 340,697.00 October -19 2W20000000 41,996.84 90,833.41 90,833.41 12/12/19 249,863.59 November -19 2W20000000 34,499.75 34,499.75 34,499.75 1/13/20 215,363.84 December -19 2W20000000 4,210.56 4,210.56 4,210.56 2/5/20 211,153.28 12/1/2019 "B" 2W20000000 5,827.79 211,153.28 January -20 2W20000000 28,023.70 33,851.49 33,851.49 3/6/20 177,301.79 February -20 2W20000000 64,002.22 64,002.22 64,002.22 4/23/20 113,299.57 March -20 2W20000000 58,941.41 58,941.41 58,941.41 5/6/20 54,358.16 April -20 2W20000000 25,729.71 25,729.71 25,729.71 6/20/20 28,628.45 May -20 2W20000000 15,255.15 15,255.15 15,255.15 7/10/20 13,373.30 June -20 2W20000000 13,373.30 13,373.30 13,373.30 7/14/20 - Totals 340,697.00 340,697.00 340,697.00 2W20000000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 °Period 8alances(PJTD)- Adj-20 Account 15230.0000.6500.2W20000000.0000.0000000( Funds Available ( Detail Balances ) Period Feb -19 Mar -19 r {Apr -19 May -19 1Jun-19m_:_: Adj-19 1Jul-19 ........_ !Aug -1'9 I Oct -19 Sep -19 °Period Balances (PJTD) - Adj-20 Account Period ioct-19 [Nov -19 Dec -19 Jan -20 Feb -20 ;Mar -20 Apr -20 ;May 20 ' Jun -20 Budget 0.00',1 0.001 ... 000 0.00 0.001 0.00!1 340697.00 d,w 0.001 0.001 340697.00 5230.0000.6500.2W20000000.0000.0000000( Funds Available ( Detail Balances ) Budget Encumbrance 0.001 0.001 0.001 Encumbrance 0.00! 0.0o �.. _. Qool o.00l 0.00, 0.00{! 0.003 Actual Funds Available 0.001 0.00 O 001 0.00 0.00 0.001 0.00'1 0.001 0 001 0.00{ 000 0.00[ 0.00'1 0oo 90833.413 0.001 340697.00j 000{ o.00[__:. 0.00! Qoo! o.Qo _w ;r 0.003 0.001 0.10, 0.001 0.001 0.00' 000 0.00 0.00=. 0.001 0.00; 0.00! a.oa! Actual 90833 41;1 34499.75 33851.49'3 64002.221 58941 411 25729.71: 15255.15 ri 0.00 -- -90833.41 0.00 Funds Available -90833.41 -34499.75t,' -4210.56 -33851.49°x=" -64002.22• 13373 301 0001v 340697.00{ -25729.71 -15255.15 -13373.30 0.00'. COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part 3 GRANT CLOSEOUT RECONCILIATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley CO 80632 EAIWORKPLAN START DATE PROGRAM INCOME START DATE 10/1/2017 YEAR OF FUNDS Page 1 of 2 FY17 TITLE/PROGRAM/PROJECT FY17 TAA CASE MANAGEMENT CLEAR Program code 17C7000000 END DATE END DATE 9/30/2019 I. CASH REQUEST ;i lir 1. Total program and Admin Cash needs: Preciously Reported 13,631.00 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date 13,631.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 13,631.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 13,631.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 0.00 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 0.00 III. PROGRAM INCOME(PI) EXPENSE REPORT 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION 1. FINAL Cash Request Contract to Date m 13,631.00 2. FINAL Expenses Through End of Contract 13,631.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes R /No ❑ V CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Total PI Cash Previously Reported on -Cash Request o`''' .. ,, t 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contrail to Date 0.00 VI. RECONCILIATION 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 WI. MATCH RECONCILIATION 1. FINAL Match Reported Through End of Contract 0.00 2. FINAL Expenses Through End of Contract 13,631.00 3. Match Percentage of Expenditure Cootracttual Requirement 0.00 4. Match Expenditure Requirement 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) 0.00 Yes O /No ❑ 'The program Income Expen9 Report and Cash Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signature Date/ 7 !�C] Authorized Signature �.L� - Date dusi 2 4 2020 See instruction for completing this for on the next tab (Attachment H 2 of 2) y3 070020- 026Y7 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part 3 GRANT CLOSEOUT RECONCILIATION WORKSHEET Page 2 of 2 GRANT CLOSEOUT RECONCILIATION WORKSHEET INSTRUCTIONS Subreciplent: Enter the subrecipient's name Address: Enter the subrecipient's address Year of Funds: Enter the year of funds of -the grants that are being closed (eg. PY17 or FY18) Title/Program/Protect: Enter the title, program, and/or project name of the grant. CLEAR Program code: Enter CLEAR program code for the grant. Contract/EA/Workplan Start/End Date: Enter the start and end date of the grant on the applicable lines. Program Income Start/End Date: If program income was generated under the grant, enter the start and end date of the program income portion of the grant on the applicable lines. I. CASH REQUEST 1.Enter the amount of program and administrative cash needs reported prior to this draw. 2. Enter the amount of current cash needs reported. 3. Add the amount from 1 to 2 above. Enter total here. II. PROGRAM EXPENSE REPORT 1. Enter the amount of expenses+accruab reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program expenses+accruals through end of this award. 3. Add the amount from 1. to 2. above. Erder total here. ADMINISTRATIVE EXPENSE REPORT 4. Enter the amount of expenses+accrual reported prior to this report on the CLEAR Funds Available Analysis report. 5. Enter the amount of current admin expenses+accruals through end of this award. 6. Add the amounts from 4 to 5 above. Erder Final total here. III. PROGRAM INCOME EXPENSE REPORT 1. Enter the amount of program income expenses reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program income expenses through end of this award. 3.Add the amounts from 1 to 2. Enter total here. IV. RECONCILIATION The goal of this reconciliation is that caslwdrawn should equal expenses+accruals reported at the end of the award. If the answer to #3 below is NO and no PI has been reported, then adjust current cash draw or current expenses reported to achiese a YES while reflecting actual expenses per your accounting records. If PI has been earned under this award, complete V thru VI 1. Enter the amount from 1.3 here 2. Enter the amount frojm 11.3 and 111.3 hme 3. Does the amount from 1. EQUAL amount from 2? Check the appropriate box. V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Enter the amount of program income cash reported as received prior to this report. 2. Enter the amount of current PI cash reported. 3. Add the amounts from 1 to 2. Enter total here. VI. RECONCILIATION The goal of this reconciliation is to determine whether PI cash earned has been spent, and if not, whether if can be spent beyond the period of performance. 1. Enter the amount from V.3 here. 2. Enter the amount from 111.3 here. 3. Enter difference of 2 from 1 here. VII. MATCH RECONCILIATION The goal of this reconciliation is that match met should equal or exceed expenses+accruals reported at the end of the award. If the answer to 5 is NO, additional match will be required. 1. Enter the amount of match reported through the end of this award. 2. Enter the amount from 11.3 here. 3. Enter the match requirement as a permntage of expenditures. For example, a match of 1 dollar for every 1 dollar expended (1 for 1) is 100%. Match of 1 dollar for every 2 dollars (1 of 2) expended is 50%. 4. Mutiply the amount from 2 by the amosit in 3. 5. Is the amount in 1. greater than or equal to the amount in 4. Check the appropriate box. Preparer's and Director's Signature anti Date: Optional signature for subrecipient's reference. CLEAR WIOA Reconciliation-FY17 TAA CASE MANAGEMENT Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance October -17 17C7000000 13,631.00 November -17 17C7000000 13,631.00 December -17 17C7000000 13,631.00 January -18 17C7000000 13,631.00 February -18 17C7000000 13,631.00 March -18. 17C7000000 13,631.00 April -18 17C7000000 17.17 17.17 17.17 5/29/2018 13,613.83 May -18 17C7000000 630.06 630.06 630.06 7/20/2018 12,983.77 June -18 17C7000000 812.56 812.56 812.56 8/2/2018 12,171.21 July -18 17C7000000 511.81 511.81 511.81 9/10/18 11,659.40 August -18 17C7000000 387.94 387.94 387.94 10/3/18 11,271.46 September -18 17C7000000 362.10 362.10 362.10 10/26/18 10,909.36 October -18 17C7000000 1,390.57 1,390.57 1,390.57 12/6/18 9,518.79 November -18 17C7000000 737.44 737.44 737.44 1/11/19 8,781.35 December -18 17C7000000 852.45 852.45 852.45 2/8/19 7,928.90 12/1/2018 "B" 17C7000000 231.26 7,928.90 12/1/2018 "C" 17C7000000 (5.62) 7,928.90 January -19 17C7000000 569.53 795.17 795.17 4/1/19 7,133.73 February -19 17C7000000 742.65 742.65 742.65 4/12/19 6,391.08 March -19 17C7000000 1,060.63 1,060.63 1,060.63 5/14/19 5,330.45 April -19 17C7000000 1,449.66 1,449.66 1,449.66 5/28/19 3,880.79 May -19 17C7000000 1,160.25 1,160.25 1,160.25 7/9/19 2,720.54 June -19 17C7000000 1,689.50 1,689.50 1,689.50 7/24/19 1,031.04 July -19 17C7000000 1,031.04 1,031.04 1,031.04 9/5/19 - August -19 17C7000000 - September -19 17C7000000 - Totals 13,631.00 13,631.00 13,631.00 17C7000000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Period '„Oct -17 Nov -17 rDec-17 iJan-18 1Feb-18 Mar -18 Apr -18 May -18 Jun -18 Adj-18 °Period Balances (PJTD) - .dj20 Account E523O.0000.6500.17C7000000.0000.00000000 Funds Available ( Detail Balances ) Budget Encumbrance 13631.001 0.001 0.001 _.�._.�..�.. 0.001 0.00 0001 0.00' 0.001 0.00(. 0.00.___ 0.00 0.001 13631.00 Account 15230.0000.8500.17C7000000.0000.00000000 Funds Available ( Detail Balances ) Period Aug _ -18 Sep -18 Oct -18 1Nov-18 !Dec -18 Jan -19 Feb -19 Mar -19 Apr -19 362.101 -362.10 1390.571 -1390.57,4 1 737.4: 4 _73744,;; 852.451 -852.45 795.17] 742.651 0.001 0.001 0.00≤ Actual Funds Available 0 00' 13631.00-1- 0.001 0.00„ 0.00.: __._.. _.. �.. _. 0.00111 0 00•" 0.001 0.00 0.00 000 000 tom:_ E 17 17 0.00 630.061 -630.06 0.00! 812.56 -812.56 0000.00.' 0.001 0,00 13631.00 Budget Encumbrance _ 0.00' mm _ 0.00. 1.00 0.001 0.00 0.00 0.00I 0.00, 0.001 13631.00! 0.001 0001 ;r 0.001µ 0.001 0.001 0.001 0.001 0.00• 1D6063i_.. 0.001 1449.66; 0.00; 13631 001 Actual Funds Available 511.811 -511.81 71 387.941 -386 94 -17 17 -795.17 -742.65 ,. -1060.6311 -1449.66 0.00 °Period Balances.(PJTD) - Adj-20 Account 5230.0000.6500.17C7000000.0000.00000000 Funds Available ( Detail Balances ) Period I;May 19 !Jun -19 Adj-19 Jul -19 'Aug -19 Sep -19 ... Oct -19 Budget 0.00 1.00 0.00 E 0 00,._ .. 0.001 0.001 _r 000; 0.001 0.00: 0.001 0.001 0.00 0.001 0.001 0.001 0.00 0.001 Actual 1160.25 1689.50i 0.00' 1031 043 0.00' 0 00_ 0.00,_ 0.00 Funds Available -1160.257 -1690.5011,:1 D 00 -1031.04 0.00 0.00 0.00 0.00 0.00 0.00 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT GRANT CLOSEOUT RECONCILIATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley CO 80632 EA/WORKPLAN START DATE PROGRAM INCOME START DATE 4/1/2017 YEAR OF FUNDS TITLE/PROGRAM/PROJECT FY17 APPRENTICESHIP USA STATE CLEAR Program code Closeout Part 3 Page 1 of 2 FY17 4FF6000000 END DATE END DATE 6/30/2020 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 37,219.00 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date 37,219.00 II. PROGRAM EXPENSE REPORT (ER) -" 1. Total Expenses+Accruals Previously Reported (Through Last Month) 37,219.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 37,219.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 0.00 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 0.00 III. PROGRAM INCOME(PI) EXPENSE REPORT 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION ,' 1. FINAL Cash Request Contract to Date 37,219.00 37,219.00 2. FINAL Expenses Through End of Contract Yes O1 /No O 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 VI. RECONCILIATION ., 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 VII. MATCH RECONCILIATION'. "; ."4 1. FINAL Match Reported Through End of Contract 0.00 2. FINAL Expenses Through End of Contract 37,219.00 3. Match Percentage of Expenditure Contracttual Requirement 0.00 4. Match Expenditure Requirement _ 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes o /No O 'The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal fu,xding penod. Preparer's Signature .92/1. 7 Date fill / )21, Authorized Signature I r"4 Date AUG 2 4 2020 See instruction for completing this for on the next tab (Attachment H 2 of 2) 020020 - O2,5$1 Go? COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT GRANT CLOSEOUT RECONCILIATION WORKSHEET GRANT CLOSEOUT RECONCILIATION WORKSHEET INSTRUCTIONS Closeout Part 3 Page 2 of 2 Subreciplent: Enter the subrecipient's name Address: Enter the subrecipient's address Year of Funds: Enter the year of funds of the grants that are being closed (eg. PY17 or FY18) Title/Program/Project: Enter the title, program, and/or project name of the grant. CLEAR Program code: Enter CLEAR program code for the grant. Contract/EA/Workplan Start/End Date: Enter the start and end date of the grant on the applicable lines. Program Income Start/End Date: If program income was generated under the grant, enter the start and end date of the program income portion of the grant on the applicable lines. I. CASH REQUEST 1.Enter the amount of program and administrative cash needs reported prior to this draw. 2. Enter the amount of current cash needs reported. 3. Add the amount from 1 to 2 above. Enter total here. II. PROGRAM EXPENSE REPORT 1. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program expenses+accruals through end of this award. 3. Add the amount from 1. to 2. above. Enter total here. ADMINISTRATIVE EXPENSE REPORT 4. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 5. Enter the amount of current admin expenses+accruals through end of this award. 6. Add the amounts from 4 to 5 above. Enter Final total here. III. PROGRAM INCOME EXPENSE REPORT 1. Enter the amount of program income expenses reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program income expenses through end of this award. 3.Add the amounts from 1 to 2. Enter total here. IV. RECONCILIATION The goal of this reconciliation is that cash drawn should equal expenses+accruals reported at the end of the award. If the answer to #3 below is NO and no PI has been reported, then adjust current cash draw or current expenses reported to achiese a YES while reflecting actual expenses per your accounting records. If PI has been earned under this award, complete V thru VI 1. Enter the amount from 1.3 here 2. Enter the amount frojm 11.3 and 111.3 here 3. Does the amount from 1. EQUAL amount from 2? Check the appropriate box. V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Enter the amount of program income cash reported as received prior to this report. 2. Enter the amount of current PI cash reported. 3. Add the amounts from 1 to 2. Enter total here. VI. RECONCILIATION The goal of this reconciliation is to determine whether PI cash earned has been spent, and if not, whether if can be spent beyond the period of performance. 1. Enter the amount from V.3 here. 2. Enter the amount from 111.3 here. 3. Enter difference of 2 from 1 here. VII. MATCH RECONCILIATION The goal of this reconciliation is that match met should equal or exceed expenses+accruals reported at the end of the award. If the answer to 5 is NO, additional match will be required. 1. Enter the amount of match reported through the end of this award. 2. Enter the amount from 11.3 here. 3. Enter the match requirement as a percentage of expenditures. For example, a match of 1 dollar for every 1 dollar expended (1 for 1) is 100%. Match of 1 dollar for every 2 dollars (1 of 2) expended is 50%. 4. Mutiply the amount from 2 by the amount in 3. 5. Is the amount in 1. greater than or equal to the amount in 4. Check the appropriate box. Preparer's and Director's Signature and Date: Optional signature for subrecipient's reference. CLEAR WIOA Reconciliation-FY17 APPRENTICESHIP USA STATE Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance April -17 4FF6000000 37,219.00 May -17 4FF6000000 37,219.00 June -17 4FF6000000 37,219.00 July -17 4FF6000000 37,219.00 August -17 4FF6000000 37,219.00 September -17 4FF6000000 37,219.00 October -17 4FF6000000 3,646.16 3,646.16 3,646.16 11/27/2017 33,572.84 November -17 4FF6000000 4,639.34 4,639.34 4,639.34 12/21/2017 28,933.50 December -17 4FF6000000 1,933.50 1,933.50 1,933.50 2/1/2018 27,000.00 January -18 4FF6000000 27,000.00 February -18 4FF6000000 27,000.00 March -18 4FF6000000 27,000.00 April -18 4FF6000000 27,000.00 May -18 4FF6000000 27,000.00 June -18 4FF6000000 27,000.00 July -18 4FF6000000 27,000.00 August -18 4FF6000000 27,000.00 September -18 4FF6000000 27,000.00 October -18 4FF6000000 27,000.00 November -18 4FF6000000 27,000.00 December -18 4FF6000000 27,000.00 12/1/2018 "B" 4FF6000000 27,000.00 12/1/2018"C" 4FF6000000 27,000.00 January -19 4FF6000000 27,000.00 February -19 4FF6000000 10,000.00 10,000.00 10,000.00 4/12/19 17,000.00 March -19 4FF6000000 10,000.00 10,000.00 10,000.00 5/14/19 7,000.00 April -19 4FF6000000 6,750.00 6,750.00 6,750.00 5/28/19 250.00 May -19 4FF6000000 (14,000.00) (14,000.00) (14,000.00) 7/9/19 14,250.00 June -19 4FF6000000 (3,750.00) (3,750.00) (3,750.00) 7/24/19 18,000.00 July -19 4FF6000000 1,795.29 1,795.29 1,795.29 9/5/19 16,204.71 August -19 4FF6000000 (1,795.29) (1,795.29) (1,795.29) 10/2/19 18,000.00 September -19 4FF6000000 18,000.00 October -19 4FF6000000 18,000.00 November -19 4FF6000000 342.47 342.47 342.47 1/13/20 17,657.53 December -19 4FF6000000 271.89 271.89 271.89 2/5/20 17,385.64 12/1/2019 "B" 4FF6000000 158.36 17,385.64 January -20 4FF6000000 1,864.90 2,023.26 2,023.26 3/6/20 15,362.38 February -20 4FF6000000 1,698.78 1,698.78 1,698.78 4/23/20 13,663.60 March -20 4FF6000000 13,663.60 13,663.60 13,663.60 5/6/20 - April -20 4FF6000000 - May -20 4FF6000000 - June -20 4FF6000000 - Totals 37,219.00 37,219.00 37,219.00 4FF6000000 General ledger vs bullied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 °Period Balances (PJt'D) - Adj-20.,, Account 15230.0000.6500.4FF6000000.0000 00000000; Funds Available ( Detail Balances ) Period Budget Encumbrance Actual 1Sep-16 0.001 .;Oct -16 lNov-16 {Dec -16 IJan-17 jFeb 17 Mar -17 l;Apr-17 May -17 Jun -17 0.001 0.001 0.00' 0.001 0.001 10219.00 0 00 0.001 0.00 3 0.001 0.001 0.00, x. 000, 0.00; 0.00 o.00l 0.001 0.001 0.001 0.00'1 0.001 0.001 0.001 0.001 0.001 'Period Balances (PJ D) - Adj-20 Funds Available 27000.00:,) 000- 0.00. 0.002. 0 • 00'1, 10219 00 0.00 0.00 Cancel Account ;5230.0000.6500.4FF6000000.0000.00000000' Period Ad1 17 6Jul-17 1Aug-17 • ;Sep 17 ;Oct -17 1Nov-17 1Dec-17 Jan -18 IFeb-18 Funds Available ( Detail Balances ) Budget Encumbrance Actual Funds Available 0.001 0.001 0.00 0.00 —� 0.001 0.001 0.001 0.00 •! 0.00 1 0.001 0.001 0.00 0.0070.00i 0.00', 0.00 3646.161 0.001 0.001 4639.34; 0.00 I 0.001 1933 50 0.00' 0 00 0.001 0.00 0.00) 37219.001 0.00-;. 0.001 0.00, o.00' 37219.00 000 0 00 -364616 -4639.34 0.00 0.00;. 0.00 0.00 Cancel Period Balances (PJTD) - Adj-20 Account 5230.0000.6500.4FF60o0000.0000.00000000' Funds Available ( Detail Balances ) Period Apr -18 May 18 iJun 18 Adj-18 Jul -18 ElOct-18 !Nov -18 Dec -18 °Period Balances (PJTD) Adj-20 Encumbrance Budget 0.001 0.00 0.00i 0.00' 0.00! 1.001 0.00 0.00' 0.00] 37219.00 Account :5230.0000.6500.4FF6000000.0000.00000000' Funds Available ( Detail Balances) Period Jan -19 '[Feb -19 lMar-19 Apr -19 May -19 Jun -19 • Adj-19 Jul -19 Aug -19 Sep -19 0.001`...... 0.00 0.00 0.001 0.001 0.001 0.001"-- 0.00! ..., 0.00!�- 0.00! 0,00, Actual 0.00; 0 00, 0.00'1 0.00; 0.00. 0.00; 0.00 0.00rr 0 00 0.00 _......... 37219.00 Funds Available 0.00 0.001!;!!!! . 0.00`:11-, 0.00 0.00' 1.00 0.00 0.00 0.00 0.00; :' 0.00'. Budget Encumbrance Actual Funds Available 0 00 0.001 o.00l 0.007. 0.00! 0.00, 10000.00; 0.0Di 00DE° 10000.00! 0.00 0.001 6750.001 0.001 0.00, 14000.00',! 1.003 o.00' 3750.001 0.00j 0.00 _ _ 0.00; -10000.00 -10000.00 -6750.001 14000.00 3749.00 T 0.00'; 37219.00 0.00i 0.00 1W 1795.29 -1795.291 0.001 0.00; 37219 00 0.00 0.00 -1795.29 i795.29' 0.00 �`' Account 0230;0000.6500.4FF6000000.0000.00000000', Funds Available ( Detail Balances ) Period 1 Oct -19 Nov -19 Dec -19 ,Jan -20 Feb 20 Mar -20 Apr -20 May -20 Jun -20 Adj-20 Budget 0.00 0.001 0.001 Encumbrance Actual Funds Available 0.00 0.00; 0.00 342 47; -342.47 ;' 0.00, 0.00 , 2023.26; 0.00; 0.00` 1698.78; 0.00 . ... __._._ 0.00...w 0.00 I 0.00 0.00; 0.00i 0.00 7219.00!; 0.00; 0.00 0.00 0.00 13663 60 0.001 0.00 0.00; -271 89 -- -2023.26 -1698.781' 13663 60, 0.00,;,;', 0.00 Cancel 0.00 0.00 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT SUBRECIPIENT: ADDRESS: GRANT CLOSEOUT RECONCILIATION WORKSHEET Employment Services of Weld County PO Box 1805, Greeley CO 80632 EA/WORKPLAN START DATE PROGRAM INCOME START DATE 10/4/2018 YEAR OF FUNDS Closeout Part 3 Page 1 of 2 FY18 TITLE/PROGRAM/PROJECT FY18 FOREIGN LABOR CERTIFICATION CLEAR Program code 1648000000 END DATE END DATE 9/30/2019 1. CASH REQUEST d., ..a , _ 1. Total program and Admin Cash needs Preciously Reported 7,564.00 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date 7,564.00 II. PROGRAM EXPENSE REPORT (ER) r ,ut 1. Total Expenses+Accruals Previously Reported (Through Last Month) 7,564.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 7,564.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 0.00 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 0.00 III. PROGRAM INCOME(PI) EXPENSE REPORT 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION? I 1. FINAL Cash Request Contract to Date 7,564.00 2. FINAL Expenses Through End of Contract 7,564.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes O /No O V. CASH REQUEST PROGRAM INCOME CASH REPORTED a, ,.=, ,.5i'i 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 VI. RECONCILIATION 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 WI. MATCH RECONCILIATION ��( _„ , ., rf,�,I 1. FINAL Match Reported Through End of Contract 0.00 2. FINAL Expenses Through End of Contract 7,564.00 3. Match Percentage of Expenditure Contracttual Requirement 0.00 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes o /No O 'The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signature Date.4‘.11)10^ Date 2020 Authorized Signature See instruction for completing this for on the next tab (Attachment H 2 of 2) 02©020-c,2 7 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT GRANT CLOSEOUT RECONCILIATION WORKSHEET GRANT CLOSEOUT RECONCILIATION WORKSHEET INSTRUCTIONS Closeout Part 3 Page 2 of 2 Subreciplent: Enter the subrecipient's name Address: Enter the subrecipient's address Year of Funds: Enter the year of funds of the grants that are being closed (eg. PY17 or FY18) Title/Program/Project: Enter the title, program, and/or project name of the grant. CLEAR Program code: Enter CLEAR program code for the grant. ContractlEAlWorkplan Start/End Date: Enter the start and end date of the grant on the applicable lines. Program Income Start/End Date: If program income was generated under the grant, enter the start and end date of the program income portion of the grant on the applicable lines. I. CASH REQUEST 1.Enter the amount of program and administrative cash needs reported prior to this draw. 2. Enter the amount of current cash needs reported. 3. Add the amount from 1 to 2 above. Enter total here. II. PROGRAM EXPENSE REPORT 1. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program expenses+accruals through end of this award. 3. Add the amount from 1. to 2. above. Enter total here. ADMINISTRATIVE EXPENSE REPORT 4. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 5. Enter the amount of current admin expenses+accruals through end of this award. 6. Add the amounts from 4 to 5 above. Enter Final total here. III. PROGRAM INCOME EXPENSE REPORT 1. Enter the amount of program income expenses reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program income expenses through end of this award. 3.Add the amounts from 1 to 2. Enter total here. IV. RECONCILIATION The goal of this reconciliation is that cash drawn should equal expenses+accruals reported at the end of the award. If the answer to #3 below is NO and no PI has been reported, then adjust current cash draw or current expenses reported to achiese a YES while reflecting actual expenses per your accounting records. If PI has been earned under this award, complete V thru VI 1. Enter the amount from 1.3 here 2. Enter the amount frojm 11.3 and 111.3 here 3. Does the amount from 1. EQUAL amount from 2? Check the appropriate box. V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Enter the amount of program income cash reported as received prior to this report. 2. Enter the amount of current PI cash reported. 3. Add the amounts from 1 to 2. Enter total here. VI. RECONCILIATION The goal of this reconciliation is to determine whether PI cash earned has been spent, and if not, whether if can be spent beyond the period of performance. 1. Enter the amount from V.3 here. 2. Enter the amount from 111.3 here. 3. Enter difference of 2 from 1 here. VII. MATCH RECONCILIATION The goal of this reconciliation is that match met should equal or exceed expenses+accruals reported at the end of the award. If the answer to 5 is NO, additional match will be required. 1. Enter the amount of match reported through the end of this award. 2. Enter the amount from 11.3 here. 3. Enter the match requirement as a percentage of expenditures. For example, a match of 1 dollar for every 1 dollar expended (1 for 1) is 100%. Match of 1 dollar for every 2 dollars (1 of 2) expended is 50%. 4. Mutiply the amount from 2 by the amount in 3. 5. Is the amount in 1. greater than or equal to the amount in 4. Check the appropriate box. Preparer's and Director's Signature and Date: Optional signature for subrecipient's reference. CLEAR WIOA Reconciliation-FV18 FOREIGN LABOR CERTIFICATION Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance October -18 1648000000 7,564.00 November -18 1648000000 7,564.00 December -18 1648000000 132.69 132.69 132.69 2/8/19 7,431.31 12/1/2018 "B" 1648000000 7,431.31 12/1/2018 "C" 1648000000 7,431.31 January -19 1648000000 7,431.31 February -19 1648000000 1,998.48 1,998.48 1,998.48 4/12/19 5,432.83 March -19 1648000000 623.80 623.80 623.80 6/24/19 4,809.03 April -19 1648000000 648.39 648.39 648.39 5/28/19 4,160.64 May -19 1648000000 1,034.31 1,034.31 1,034.31 7/9/19 3,126.33 June -19 1648000000 408.78 408.78 408.78 7/24/19 2,717.55 July -19 1648000000 2,717.55 August -19 1648000000 2,717.55 September -19 1648000000 2,642.16 2,642.16 2,642.16 11/8/19 75.39 October -19 1648000000 75.39 75.39 75.39 12/12/19 (0.00) Totals 7,564.00 7,564.00 7,564.00 1648000000 General ledger vs bullied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Period !Aug -119 Sep -19 ,lOct-19 !Nov -19 i ,Dec -19 °Period Balances (PJTD)-:AdJ-20 Account ;5230.0000.6500.1648000000.0000.00000000( Funds Available ( Detai Balances ) Period Sep -18 Oct -18 Nov -18 Dec -18 Jan -19 Feb -19 Mar -19 !Apr -19 ,May -19 ,[Jun -19 °Period Balances (PJTD) - Adj-20 Budget 7564.00; 0.001 0.00; 0.00! ..._ 0.001 0.001 0.00 0.00! T 0001 0.001 Encumbrance 0.001 0,00 0.00'! 0.00; 132.69 -132 69'4 Actual Funds Available 0.00; 7564.00;7 • 0.00!!!!! 0.00; 0.00,1 0.00'; 7564.00! 0.00 Account ;5230.0000.6500.1648000000.0000.000000001 Funds Available ( Detail Balances ) Budget 0.001 _. 0.001 0.001 0.00 .::. 0.001 0.003 0.00! 0.00! 0 00;1 7564.00' Encumbrance 000 0.00! 0.00! 0.00` 0.001— ; 0.00= 0.00 000: 0.00: 0.00'3 0.00: 0.00., 0.00 1998.48! 623.80! 648.391 103431:f.m_ 408.78' 7564.00! 0.00'1 -1998 48? -623 80, -648.39 -1034.31;` -408.78 0.00 Actual Funds Available 0.003-�� 0.00 s^ 0.00 0.00 2642.16; -2642.16; 75.391 -75.39;1 11' 0.00'_�- � ..._... �.._-� 0.00 0.00; 0.00 0.00 0.001 0.00, 0.00! 7564.00; 0.00 _ 0.00 0.00 0.00 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part 3 SUBRECIPIENT: ADDRESS: GRANT CLOSEOUT RECONCILIATION WORKSHEET Employment Services of Weld County PO Box 1805, Greeley CO 80632 EAIWORKPLAN START DATE PROGRAM INCOME START DATE 9/27/2018 YEAR OF FUNDS Page 1 of 2 FY18 TITLE/PROGRAM/PROJECT FY18 TM CASE MANAGEMENT CLEAR Program code 17C8000000 END DATE END DATE 6/30/2020 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date 11,869.00 11,869.00 II. PROGRAM EXPENSE REPORT (ER) n + 1. Total Expenses+Accruals Previously Reported (Through Last Month) 11,869.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 11,869.00 ADMINISTRATIVE EXPENSE (ER) ,, .. 4. Total Expenses+Accruals Previously Reported (Through Last Month) 0,00 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 0.00 III. PROGRAM INCOME(PI) EXPENSE REPORT 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION 1. FINAL Cash Request Contract to Date 11,869.00 2. FINAL Expenses Through End of Contract 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) 11,869.00 Yes 0 /No ❑ V CASH REQUEST PROGRAM INCOME CASH REPORTED ''' A~1W ,_)..t Wi ttrtn 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 W. RECONCILIATION 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 WI. MATCH RECONCILIATION ii[ t 1. FINAL Match Reported Through End of Contract 0.00 2. FINAL Expenses Through End of Contract 11,869.00 3. Match Percentage of Expenditure Contracttual Requirement 0.00 4. Match Expenditure Requirement 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) 0.00 Yes 0 /No ❑ 'The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signature Date a / i.`0t7 i Authorized Signature — Date A�� 2 4 ZUZU See instruction for completing this for on the next tab (Attachment hi 2 of 2) 02120.20 - 02sY9 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part 3 GRANT CLOSEOUT RECONCILIATION WORKSHEET Page 2 of 2 GRANT CLOSEOUT RECONCILIATION WORKSHEET INSTRUCTIONS Subrecipient: Enter the subrecipient's name Address: Enter the subrecipient's address Year of Funds: Enter the year of funds of the grants that are being closed (eg. PY17 or FY18) Title/Program/Project: Enter the title, program, and/or project name of the grant. CLEAR Program code: Enter CLEAR program code for the grant. Contract/EA/Workplan Start/End Date: Enter the start and end date of the grant on the applicable lines. Program Income Start/End Date: If program income was generated under the grant, enter the start and end date of the program income portion of the grant on the applicable lines. I. CASH REQUEST 1.Enter the amount of program and administrative cash needs reported prior to this draw. 2. Enter the amount of current cash needs reported. 3. Add the amount from 1 to 2 above. En:er total here. II. PROGRAM EXPENSE REPORT 1. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program expenses+accruals through end of this award. 3. Add the amount from 1. to 2. above. Eiter total here. ADMINISTRATIVE EXPENSE REPORT 4. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 5. Enter the amount of current admin expenses+accruals through end of this award. 6. Add the amounts from 4 to 5 above. Enter Final total here. III. PROGRAM INCOME EXPENSE REPORT 1. Enter the amount of program income expenses reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program income expenses through end of this award. 3.Add the amounts from 1 to 2. Enter total here. IV. RECONCILIATION The goal of this reconciliation is that cash drawn should equal expenses+accruals reported at the end of the award. If the answer to #3 below is NO and no PI has been reported, then adjust current cash draw or current expenses reported to achiese a YES while reflecting actual expenses per your accounting records. If PI has been earned under this award, complete V thru VI 1. Enter the amount from 1.3 here 2. Enter the amount frojm 11.3 and 111.3 here 3. Does the amount from 1. EQUAL amount from 2? Check the appropriate box. V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Enter the amount of program income cash reported as received prior to this report. 2. Enter the amount of current PI cash reported. 3. Add the amounts from 1 to 2. Enter total here. VI. RECONCILIATION The goal of this reconciliation is to determine whether PI cash earned has been spent, and if not, whether if can be spent beyond the period of performance. 1. Enter the amount from V.3 here. 2. Enter the amount from 111.3 here. 3. Enter difference of 2 from 1 here. VII. MATCH RECONCILIATION The goal of this reconciliation is that match met should equal or exceed expenses+accruals reported at the end of the award. If the answer to 5 is NO, additional match will be required. 1. Enter the amount of match reported through the end of this award. 2. Enter the amount from 11.3 here. 3. Enter the match requirement as a percentage of expenditures. For example, a match of 1 dollar for every 1 dollar expended (1 for 1) is 100%. Match of 1 dollar for every 2 dollars (1 of 2) expended is 50%. 4. Mutiply the amount from 2 by the amount in 3. 5. Is the amount in 1. greater than or equal to the amount in 4. Check the appropriate box. Preparer's and Director's Signature and Date: Optional signature for subrecipient's reference. CLEAR WIOA Reconciliation-FY18 TAA CASE MANAGEMENT Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance September -18 17C8000000 11,869.00 October -18 17C8000000 11,869.00 November -18 17C8000000 11,869.00 December -18 17C8000000 11,869.00 12/1/2018 "B" 17C8000000 11,869.00 12/1/2018 "C" 17C8000000 11,869.00 January -19 17C8000000 11,869.00 February -19 17C8000000 11,869.00 March -19 17C8000000 11,869.00 April -19 17C8000000 11,869.00 May -19 17C8000000 11,869.00 June -19 17C8000000 11,869.00 July -19 17C8000000 15.22 15.22 15.22 9/5/19 11,853.78 August -19 17C8000000 1,235.92 1,235.92 1,235.92 10/2/19 10,617.86 September -19 17C8000000 1,199.07 1,199.07 1,199.07 11/8/19 9,418.79 October -19 17C8000000 1,639.34 1,639.34 1,639.34 12/12/19 7,779.45 November -19 17C8000000 1,272.55 1,272.55 1,272.55 1/13/20 6,506.90 December -19 17C8000000 1,372.79 1,372.79 1,372.79 2/5/20 5,134.11 12/1/2019 "B" 17C8000000 1,027.19 5,134.11 January -20 17C8000000 2,119.57 3,146.76 3,146.76 3/6/20 1,987.35 February -20 17C8000000 1,987.35 1,987.35 1,987.35 4/23/20 - March -20 17C8000000 - April -20 17C8000000 - May -20 17C8000000 - June -20 17C8000000 - Totals 11,869.00 11,869.00 11,869.00 17C8000000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Period I Sep 18 lOct-18 Nov -18 'Dec -18 IJan-19 .............: , Feb -19 !Mar -19 ;Apr -19 [May -19 1Jun-19 Account (5230:0000.6500.17O8000000.0000.00000000 Funds Available ( Detail Balances ) Budget 11869 00 0.00!m. 0.00 0.00 0.00' 0.00 0.00! 0.00. 0.00 0.00 11869.00' 1 Encumbrance 0.00 0.00! 0.00; 0.001 0.00 0.00i o.00 0.00! 0.001` Actual 000 ww 0 00=.:� 0.00: 0.00 0.00 0.00 0.00; 0.00 0.00 Funds Available 11869.00'7 0.001 0.00 '.1p 0.00 0.00 0.00 0.00 r 0.00. • Cancel 0.00 0.00 0.00'. Period Balances (PJTD) - Adj-20 Account '5230.0000.6500.17C8000000.0000.00000000 Jul -19 Aug -19 Sep -19 Oct -19 Nov -19 Dec -19 Jan -20 Feb -20 Mar -20 Funds Available ( Detail Balances ) Budget 0.001 0 001 0.001 0.00 0.001 0.00 0.00.! 0.001 0.001 0.001 11869.00' Encumbrance 0.001 0.001 0.00! 0.00 0.00# 0.00 ,1 0 001 0 00,, 0.00E 0.00 I Actual Funds Available 0.00! 0.00 15.221 -15.22 1235.92! 1199.07! 1639.34 1272.55 1372 791 3146.76! 1987.35 1 0.00 1 0.00! 11869.00! -1235.92 -1199.07 -1639.34 -1272.55 -1372.79 -3146.76 -, -1987.35 0.00 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part 3 SUBRECIPIENT: ADDRESS: GRANT CLOSEOUT RECONCILIATION WORKSHEET Employment Services of Weld County PO Box 1805, Greeley CO 80632 EA/WORKPLAN START DATE PROGRAM INCOME START DATE 4/1/2018 YEAR OF FUNDS TITLE/PROGRAM/PROJECT FY18 RESEA EXPENDITURES -COUNTY CLEAR Program code Page 1 of 2 FY18 28C8000000 END DATE END DATE 9/30/2019 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 9,852.00 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date 9,852.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 9,852.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 9,852.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 0.00 5. Current Expenses+Accruals (Througi End Date of Awards) 6. FINAL Administrative Expenses Ccntract to Date 0.00 III. PROGRAM INCOME(PI) EXPENSE REPORT a ., 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION i '',,iiriti `F'l!1as1(lldrP i:16,-, 1. FINAL Cash Request Contract to Date 9,852.00 2. FINAL Expenses Through End of Contract 9,852,00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes O /No ❑ V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 VI. RECONCILIATION r 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 VII. MATCH RECONCILIATION $' ' i " 1. FINAL Match Reported Through Enc of Contract 0.00 2. FINAL Expenses Through End of Contract 9,852.00 3. Match Percentage of Expenditure Contracttual Requirement 0.00 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes o /No ❑ 'The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signature / Date &) / ) 2O Authorized Signature Date AUG 4 2020 See instruction for completing this for on the next tab (Attachment H 2 of 2) a2oo20 -,268 7 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT GRANT CLOSEOUT RECONCILIATION WORKSHEET GRANT CLOSEOUT RECONCILIATION WORKSHEET INSTRUCTIONS Closeout Part 3 Page 2 of 2 Subrecipient: Enter the subrecipient's name Address: Enter the subrecipient's address Year of Funds: Enter the year of funds of the grants that are being closed (eg. PY17 or FY18) Title/Program/Project: Enter the title, program, and/or project name of the grant. CLEAR Program code: Enter CLEAR program code for the grant. Contract/EA/Workplan Start/End Date: Enter the start and end date of the grant on the applicable lines. Program Income Start/End Date: If program income was generated under the grant, enter the start and end date of the program income portion of the grant on the applicable lines. I. CASH REQUEST 1.Enter the amount of program and administrative cash needs reported prior to this draw. 2. Enter the amount of current cash needs reported. 3. Add the amount from 1 to 2 above. Enter total here. II. PROGRAM EXPENSE REPORT 1. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program expenses+accruals through end of this award. 3. Add the amount from 1. to 2. above. Enter total here. ADMINISTRATIVE EXPENSE REPORT 4. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 5. Enter the amount of current admin expenses+accruals through end of this award. 6. Add the amounts from 4 to 5 above. Enter Final total here. III. PROGRAM INCOME EXPENSE REPORT 1. Enter the amount of program income expenses reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program income expenses through end of this award. 3.Add the amounts from 1 to 2. Enter total here. IV. RECONCILIATION The goal of this reconciliation is that cash drawn should equal expenses+accruals reported at the end of the award. If the answer to #3 below is NO and no PI has been reported, then adjust current cash draw or current expenses reported to achiese a YES while reflecting actual expenses per your accounting records. If PI has been earned under this award, complete V thru VI 1. Enter the amount from 1.3 here 2. Enter the amount frojm 11.3 and 111.3 here 3. Does the amount from 1. EQUAL amount from 2? Check the appropriate box. V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Enter the amount of program income cash reported as received prior to this report. 2. Enter the amount of current PI cash reported. 3. Add the amounts from 1 to 2. Enter total here. VI. RECONCILIATION The goal of this reconciliation is to determine whether PI cash earned has been spent, and if not, whether if can be spent beyond the period of performance. 1. Enter the amount from V.3 here. 2. Enter the amount from 111.3 here. 3. Enter difference of 2 from 1 here. VII. MATCH RECONCILIATION The goal of this reconciliation is that match met should equal or exceed expenses+accruals reported at the end of the award. If the answer to 5 is NO, additional match will be required. 1. Enter the amount of match reported through the end of this award. 2. Enter the amount from 11.3 here. 3. Enter the match requirement as a percentage of expenditures. For example, a match of 1 dollar for every 1 dollar expended (1 for 1) is 100%. Match of 1 dollar for every 2 dollars (1 of 2) expended is 50%. 4. Mutiply the amount from 2 by the amount in 3. 5. Is the amount in 1. greater than or equal to the amount in 4. Check the appropriate box. Preparer's and Director's Signature and Date: Optional signature for subrecipient's reference. CLEAR WIOA Reconciliation-FY18 RESEA EXPENDITURES Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance April -18 28C8000000 9,852.00 May -18 28C8000000 9,852.00 June -18 28C8000000 9,852.00 July -18 28C8000000 2,025.00 2,025.00 2,025.00 9/10/18 7,827.00 August -18 28C8000000 175.00 175.00 175.00 10/3/18 7,652.00 September -18 28C8000000 7,652.00 October -18 28C8000000 4,620.00 7,652.00 November -18 28C8000000 2,100.00 6,720.00 6,720.00 1/17/19 932.00 December -18 28C8000000 932.00 932.00 932.00 2/12/19 - January -19 28C8000000 - February -19 28C8000000 - March -19 28C8000000 - April -19 28C8000000 - May -19 28C8000000 - June -19 28C8000000 - July -19 28C8000000 - August -19 28C8000000 - September -19 28C8000000 - Totals 7,652.00 7,652.00 7,652.00 28C8000000 General ledger vs bullied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 ` Period Balances (PJTD) - Adj-20 Account Period lAug-18 ;Sep -18 lOct-18 Nov -18 IDec-18 !Jan-19� Feb -19 ,5230.0000.6500.28C8000000.0000.00000000 Funds Available ( Detail Balances ) Budget Encumbrance 2200.008 0.00 0.001 o.00: 0.00i 7652.00 0.00 0.001 0.00 0.001 9852.001 0.001 Actual Funds Available 0.00 2200.00 7 0.00; a o0 0.00i 2025.001 -2025.001:1 0.001 175 00 -175.00 0.00 I 0.00' 7652.00 0.00; 0.00; 0.00; 6720.00.1 0.001 932.001 000; 000;' 000:- -6720.00 -932.00 0.00 . 0.00 Cancel COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part 3 SUBRECIPIENT: ADDRESS: GRANT CLOSEOUT RECONCILIATION WORKSHEET Employment Services of Weld County PO Box 1805, Greeley CO 80632 EANVORKPLAN START DATE PROGRAM INCOME START DATE 11/1/2018 YEAR OF FUNDS TITLE/PROGRAM/PROJECT FY18 PERFORMANCE INCENTIVE FUND CLEAR Program code Page 1 of 2 FY18 4W47000000 END DATE END DATE 9/30/2019 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date 50,924.00 50,924.00 II. PROGRAM EXPENSE REPORT (ER) ;� 3°� . ti�w.r. ., i�!s�.. vm, 1. Total Expenses+Accruals Previously Reported (Through Last Month) 50,924.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 50,924.00 ADMINISTRATIVE EXPENSE (ER) 1,14'',.:.', 4. Total Expenses+Accruals Previously Reported (Through Last Month) 0.00 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 0.00 III. PROGRAM INCOME(PI) EXPENSE REPORT 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION 1. FINAL Cash Request Contract to Date 50,924.00 2. FINAL Expenses Through End of Contract 50,924.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes o /No O V. CASH REQUEST PROGRAM INCOME CASH REPORTED �l Cw , ,• ,°dixE (,„,x t„ .... 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 VI. RECONCILIATION, ,, 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 VII. MATCH RECONCILIATION 1. FINAL Match Reported Through End of Contract 0.00 2. FINAL Expenses Through End of Contract 50,924.00 3. Match Percentage of Expenditure Contracttual Requirement 0.00 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes o /No O 'The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signature/4" Date /n i Authorized Signature a— - Date Uti 4 2u20 See instruction for completing this for on the next tab (Attachment H 2 cf 2) 000020-02587 r4 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT GRANT CLOSEOUT RECONCILIATION WORKSHEET GRANT CLOSEOUT RECONCILIATION WORKSHEET INSTRUCTIONS Closeout Part 3 Page 2 of 2 Subrecipient: Enter the subrecipient's name Address: Enter the subrecipient's address Year of Funds: Enter the year of funds of the grants that are being closed (eg. PY17 or FY18) Title/Program/Project: Enter the title, program, and/or project name of the grant. CLEAR Program code: Enter CLEAR program code for the grant. Contract/EANVorkplan Start/End Date: Enter the start and end date of the grant on the applicable lines. Program Income Start/End Date: If program income was generated under the grant, enter the start and end date of the program income portion of the grant on the applicable lines. I. CASH REQUEST 1.Enter the amount of program and administrative cash needs reported prior to this draw. 2. Enter the amount of current cash needs reported. 3. Add the amount from 1 to 2 above. Enter total here. II. PROGRAM EXPENSE REPORT 1. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program expenses+accruals through end of this award. 3. Add the amount from 1. to 2. above. Enter total here. ADMINISTRATIVE EXPENSE REPORT 4. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 5. Enter the amount of current admin expenses+accruais through end of this award. 6. Add the amounts from 4 to 5 above. Enter Final total here. III. PROGRAM INCOME EXPENSE REPORT 1. Enter the amount of program income expenses reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program income expenses through end of this award. 3.Add the amounts from 1 to 2. Enter total here. IV. RECONCILIATION The goal of this reconciliation is that cash drawn should equal expenses+accruals reported at the end of the award. If the answer to #3 below is NO and no PI has been reported, then adjust current cash draw or current expenses reported to achiese a YES while reflecting actual expenses per your accounting records. If PI has been earned under this award, complete V thru VI 1. Enter the amount from 1.3 here 2. Enter the amount frojm 11.3 and 111.3 here 3. Does the amount from 1. EQUAL amount from 2? Check the appropriate box. V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Enter the amount of program income cash reported as received prior to this report. 2. Enter the amount of current PI cash reported. 3. Add the amounts from 1 to 2. Enter total here, VI. RECONCILIATION The goal of this reconciliation is to determine whether PI cash earned has been spent, and if not, whether if can be spent beyond the period of performance. 1. Enter the amount from V.3 here. 2. Enter the amount from 111.3 here. 3. Enter difference of 2 from 1 here. VII. MATCH RECONCILIATION The goal of this reconciliation is that match met should equal or exceed expenses+accruals reported at the end of the award. If the answer to 5 is NO, additional match will be required. 1. Enter the amount of match reported through the end of this award. 2. Enter the amount from 11.3 here. 3. Enter the match requirement as a percentage of expenditures. For example, a match of 1 dollar for every 1 dollar expended (1 for 1) is 100%. Match of 1 dollar for every 2 dollars (lof 2) expended is 50%. 4. Mutiply the amount from 2 by the amount in 3. 5. Is the amount in 1. greater than or equal to the amount in 4. Check the appropriate box. Preparer's and Director's Signature and Date: Optiolal signature for subrecipient's reference. CLEAR WIOA Reconciliation -F1'18 PERFORMANCE INCENTIVE FUND Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance November -18 4W47000000 50,924.00 December -18 4W47000000 226.05 50,924.00 December -18 "B" 4W47000000 236.82 50,924.00 January -19 4W47000000 3,122.88 50,924.00 February -19 4W47000000 2,655.35 50,924.00 March -19 4W47000000 4,503.62 10,744.72 10,744.72 6/24/19 40,179.28 April -19 4W47000000 9,819.72 9,819.72 9,819.72 5/28/19 30,359.56 May -19 4W47000000 15,290.04 15,290.04 15,290.04 7/9/19 15,069.52 June -19 4W47000000 4,571.67 4,571.67 4,571.67 7/24/19 10,497.85 July -19 4W47000000 4,395.58 4,395.58 4,395.58 9/5/19 6,102.27 August -19 4W47000000 5,488.91 5,488.91 5,488.91 10/2/19 613.36 September -19 4W47000000 613.36 613.36 613.36 11/8/19 (0.00) Totals 50,924.00 50,924.00 50,924.00 4W47000000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 °Period Balances (PJTD) - Adj-20 Account Period INov-18 11Dec-18 IJan-19 1Feb-19 FMar-19mm lApr-19 lMay-19 Jun -19 jAdj-19 'Jul -19 Actual 0.00; 5230.0000.6500.4 WA7000000.0000.0000000t. Funds Available ( Detail Balances ) °Period Balances (PJTD) Adj-20 1 "[Oct -19 [Nov 19 ,iDec-19 [Jan -20 IFeb-20 IMar-20 ,lApr-20 IMay-20 Account ;5230.0000.6500.4WA7000000.0000.0000000( Budget 50924.001 0.00', _.._.. Encumbrance 0.00 I Funds Available 50924.00 0.001 0.001 000rks 0.001 o.000.00 0.00 �� 0 00; 0 oo 0 00; 0.00 0.00 j 0.00 10744 72 -10744.72 0.00' 0.00 9819.721 -9819.72, 0.00, 0.00 0.00 0.00, 50924.00f Funds Available ( Detail Balances ) Budget 0.00'I 0.00 0.00,E 0.001 0.001 0.00 0.001 0.00I 15290.04i -15290.04 - 0.00,1 4571.671 -4571.67 0.00; 0.00; s 0.00 4395 58 0.00 50924.001 Encumbrance 0.00i 0.00! 0 00 Actual 5488.91' 613.36 0.00; 000i 0001 0.001 0.001 0.00; 0.001 0.00: 0.001 0 00, 0.00 0.00' ... 0.00 0.001 0.00 0.00 -4395.58 _ Funds Available 5488.91;1 -613.361-'1,11 0 00, 000:A 000 000 0.00 0.00 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT SUBRECIPIENT: ADDRESS: GRANT CLOSEOUT RECONCILIATION WORKSHEET Employment Services of Weld County PO Box 1805, Greeley CO 80632 EA/WORKPLAN START DATE PROGRAM INCOME START DATE 10/1/2018 YEAR OF FUNDS TITLE/PROGRAM/PROJECT FY19 DISABLED VETS OUTREACH PROG CLEAR Program code Closeout Part 3 Page 1 of 2 FY19 20D9000000 END DATE END DATE 12/31/2019 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date 17,384.00 17,384.00 IL PROGRAM EXPENSE REPORT (ER) � R ? 1 �e °r»n ) µ 1. Total Expenses+Accruals Previously Reported (Through Last Month) 17,384.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 17,384.00 ADMINISTRATIVE EXPENSE (ER) n' : 4. Total Expenses+Accruals Previously Reported (Through Last Month) 0.00 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 0.00 III. PROGRAM INCOME(PI) EXPENSE REPORT 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION 1. FINAL Cash Request Contract to Date 17,384.00 2. FINAL Expenses Through End of Contract 17,384.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes Q /No O V CASH REQUEST PROGRAM INCOME CASH REPORTED,,. 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 VI. RECONCILIATION �, . �.,. , � ,_" 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 VII. MATCH RECONCILIATION ' Mc, ,, '' ... "�17a4 T t 11 1. FINAL Match Reported Through End of Contract 0.00 2. FINAL Expenses Through End of Contract 17,384.00 3. Match Percentage of Expenditure Contracttual Requirement 0.00 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes O /No O 'The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signat Date t 7 ) Authorized Signature Date 6 2 4 2020 i See instruction for completing this for on the next tab (Attachment H 2 of 2) 020020 - 02 586, COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT GRANT CLOSEOUT RECONCILIATION WORKSHEET GRANT CLOSEOUT RECONCILIATION WORKSHEET INSTRUCTIONS Closeout Part 3 Page 2 of 2 Subrecipient: Enter the subrecipient's name Address: Enter the subrecipient's address Year of Funds: Enter the year of funds of the grants that are being closed (eg. PY17 or FY18) Title/Program/Project: Enter the title, program, and/or project name of the grant. CLEAR Program code: Enter CLEAR program code for the grant. Contract/EAANorkplan Start/End Date: Enter the start and end date of the grant on the applicable lines. Program Income Start/End Date: If program income was generated under the grant, enter the start and end date of the program income portion of the grant on the applicable lines. I. CASH REQUEST 1.Enter the amount of program and administrative cash needs reported prior to this draw. 2. Enter the amount of current cash needs reported. 3. Add the amount from 1 to 2 above. Enter total here. II. PROGRAM EXPENSE REPORT 1. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program expenses+accruals through end of this award. 3. Add the amount from 1. to 2. above. Enter total here. ADMINISTRATIVE EXPENSE REPORT 4. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 5. Enter the amount of current admin expenses+accrua s through end of this award. 6. Add the amounts from 4 to 5 above. Enter Final total here. III. PROGRAM INCOME EXPENSE REPORT 1. Enter the amount of program income expenses reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program income expenses through end of this award. 3.Add the amounts from 1 to 2. Enter total here. IV. RECONCILIATION The goal of this reconciliation is that cash drawn should equal expenses+accruals reported at the end of the award. If the answer to #3 below is NO and no PI has been reported, then adjust current cash draw or current expenses reported to achiese a YES while reflecting actual expenses per your accounting records. If Pi has been earned under this award, complete V thru VI 1. Enter the amount from 1.3 here 2. Enter the amount frojm 11.3 and 111.3 here 3. Does the amount from 1. EQUAL amount from 2? Check the appropriate box. V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Enter the amount of program income cash reported as received prior to this report. 2. Enter the amount of current PI cash reported. 3. Add the amounts from 1 to 2. Enter total here. VI. RECONCILIATION The goal of this reconciliation is to determine whether PI cash earned has been spent, and if not, whether if can be spent beyond the period of performance. 1. Enter the amount from V.3 here. 2. Enter the amount from 111.3 here. 3. Enter difference of 2 from 1 here. VII. MATCH RECONCILIATION The goal of this reconciliation is that match met should equal or exceed expenses+accruals reported at the end of the award. If the answer to 5 is NO, additional match will be required. 1. Enter the amount of match reported through the end of this award. 2. Enter the amount from 11.3 here. 3. Enter the match requirement as a percentage of expenditures. For example, a match of 1 dollar for every 1 dollar expended (1 for 1) is 100% Match of 1 dollar for every 2 dollars (1of 2) expended is 50%. 4. Mutiply the amount from 2 by the amount in 3. 5. Is the amount in 1. greater than or equal to the amount in 4. Check the appropriate box. Preparer's and Director's Signature and Date: Optional signature for subrecipient's reference. CLEAR WIOA Reconciliation-FY19 DISABLED VETS OUTREACH PROG Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance October -18 20D9000000 17,384.00 November -18 20D9000000 17,384.00 December -18 20D9000000 17,384.00 December -18 "B" 20D9000000 17,384.00 January -19 20D9000000 17,384.00 February -19 20D9000000 17,384.00 March -19 20D9000000 17,384.00 April -19 20D9000000 17,384.00 May -19 20D9000000 2,173.00 2,173.00 2,173.00 7/9/19 15,211.00 June -19 20D9000000 4,427.58 4,427.58 4,427.58 7/24/19 10,783.42 July -19 20D9000000 1,797.24 1,797.24 1,797.24 9/5/19 8,986.18 August -19 20D9000000 1,797.24 1,797.24 1,797.24 10/2/19 7,188.94 September -19 20D9000000 1,797.24 1,797.24 1,797.24 11/8/19 5,391.70 October -19 20D9000000 1,797.24 1,797.24 1,797.24 12/12/19 3,594.46 November -19 20D9000000 1,797.24 1,797.24 1,797.24 1/13/20 1,797.22 December -19 20D9000000 1,797.22 1,797.22 1,797.22 1/15/20 - Totals 17,384.00 17,384.00 17,384.00 20D9000000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Period °Period Balances (PJTD) - Adj-20 Account 5230.0000.6500.20D9000000.0000.00000000,- Funds Available ( Detail Balances ) Oct -18 ;Jan -19 .Feb -19 Apr 19 ,May -19 IJun-19 Adj-19 Budget 17384.00 0.001 0.001 0.001 0.00{ 0.00[ 0001_. 0.001 0.001 0 00 17384.001 Encumbrance 0.001 0.00 OA4 � 0.001 .. 0.001 _...___. 0µ00 0.00 0.00 0.001 0.00'. Actual Funds Available 0.001 17384.00 0.001 0.00 re! 0.00i 0.001 0.001 0.001 2173.001 4427 58 0.001 17384.00= °Period Balances (PJTD) - Adj-20 0.00 0.00 0.00,; 0.00 . 21730O1 -4427.58 0.00 _' Cancel 0.00 Account 5230.0000.6500.20D9000000.0000.00000000; Period I OW Aug -19 Sep 19 ibct-19 1Nov19. !Dec -19 Jan -20 1Feb-20 ;Mar -20 1Apr-20 Funds Available ( Detail Balances ) Budget 000, 0.00; 0001 0.00 a 001 0.00 Encumbrance 0.001 0.00. 0001 Actual 1797 241 1797 24' Funds Available -1797.247 -1797.24 1797.24 -1797.24 0.001 1797 241 -1797.24,g 0.00 1797 241 -1707.24 '' 0.00i � 1797.221 -1797.22 0.00; 0 00L(._. _..._ _ 0.001 0.00 ,. — : a� 0.00' 0.00 j 0.001 0 00. n. 0.001 0.001 0.00; 0.00 0.00; 0.001 0.001 0.00 17384.00 0.00; 17384.00; 0.00 Cancel COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT SUBRECIPIENT: ADDRESS: GRANT CLOSEOUT RECONCILIATION WORKSHEET Employment Services of Weld County PO Box 1805, Greeley CO 80632 EA/WORKPLAN START DATE PROGRAM INCOME START DATE 10/1/2018 YEAR OF FUNDS TITLE/PROGRAM/PROJECT CLEAR Program code Closeout Part 3 Page 1 of 2 FY19 FY19 WIOA ADULT 46A8000000 END DATE END DATE 6/30/2020 I. CASH REQUEST 9� 1. Total program and Admin Cash neecs Preciously Reported 13,296.00 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date 13,296.00 II. PROGRAM EXPENSE REPORT (ER) ? l .- " „" i 1. Total Expenses+Accruals Previously Reported (Through Last Month) 0.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 0.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 13,296.00 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 13,296.00 III. PROGRAM INCOME(PI) EXPENSE REPORT 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Cate of Contract 0.00 IV. RECONCILICATION' 1. FINAL Cash Request Contract to Date 13,296.0O 2. FINAL Expenses Through End of Contract 13,296.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes o /No ❑ V. CASH REQUEST PROGRAM INCOME CASH REPORTED ry irt 1. Total PI Cash Previously Reported on Cash Request 2, Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 VI. RECONCILIATION _' -€ 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 VII. MATCH RECONCILIATION tiM.. „ , . . ,u 1. FINAL Match Reported Through End of Contract 0.00 2. FINAL Expenses Through End of Contract 13,296.00 3. Match Percentage of Expenditure Contracttual Requirement 0.00 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes 2 /No ❑ *The program Income Expense Report and Casa Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signature`��s�/ �E / Date 7M)Authorized k.3 Signature t - Date AUG 2 4 2020 See instruction for completing this for on the nest tab (Attachment H 2 of 2) aoao - 025g'7 4, COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT GRANT CLOSEOUT RECONCILIATION WORKSHEET GRANT CLOSEOUT RECONCILIATION WORKSHEET INSTRUCTIONS Closeout Part 3 Page 2 of 2 Subrecipient: Enter the subrecipient's name Address: Enter the subrecipient's address Year of Funds: Enter the year of funds of the grants that are being closed (eg. PY17 or FY18) Title/Program/Project: Enter the title, program, and/or project name of the grant. CLEAR Program code: Enter CLEAR program code for the grant. Contract/EA/Workplan Start/End Date: Enter the start and end date of the grant on the applicable lines. Program Income Start/End Date: If program income was generated under the grant, enter the start and end date of the program income portion of the grant on the applicable lines. I. CASH REQUEST 1.Enter the amount of program and administrative cash needs reported prior to this draw. 2. Enter the amount of current cash needs reported. 3. Add the amount from 1 to 2 above. Enter total here. II. PROGRAM EXPENSE REPORT 1. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program expenses+accruals through end of this award. 3. Add the amount from 1. to 2. above. Enter total here. ADMINISTRATIVE EXPENSE REPORT 4. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 5. Enter the amount of current admin expenses+accruals through end of this award. 6. Add the amounts from 4 to 5 above. Enter Final total here. III. PROGRAM INCOME EXPENSE REPORT 1. Enter the amount of program income expenses reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program income expenses through end of this award. 3.Add the amounts from 1 to 2. Enter total here. IV. RECONCILIATION The goal of this reconciliation is that cash drawn should equal expenses+accruals reported at the end of the award. If the answer to #3 below is NO and no PI has been reported, then adjust current cash draw or current expenses reported to achiese a YES while reflecting actual expenses per your accounting records. If PI has been earned under this award, complete V thru VI 1. Enter the amount from 1.3 here 2. Enter the amount frojm 11.3 and 111.3 here 3. Does the amount from 1. EQUAL amount from 2? Check the appropriate box. V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Enter the amount of program income cash reported as received prior to this report. 2. Enter the amount of current PI cash reported. 3. Add the amounts from 1 to 2. Enter total here. VI. RECONCILIATION The goal of this reconciliation is to determine whether PI cash earned has been spent, and if not, whether if can be spent beyond the period of performance. 1. Enter the amount from V.3 here. 2. Enter the amount from 111.3 here. 3. Enter difference of 2 from 1 here. VII. MATCH RECONCILIATION The goal of this reconciliation is that match met should equal or exceed expenses+accruals reported at the end of the award. If the answer to 5 is NO, additional match will be required. 1. Enter the amount of match reported through the end of this award. 2. Enter the amount from 11.3 here. 3. Enter the match requirement as a percentage of expenditures. For example, a match of 1 dollar for every 1 dollar expended (1 for 1) is 100%. Match of 1 dollar for every 2 dollars (1 of 2) expended is 50%. 4. Mutiply the amount from 2 by the amount in 3. 5. Is the amount in 1. greater than or equal to the amount in 4. Check the appropriate box. Preparers and Director's Signature and Date: Optional signature for subrecipient's reference. CLEAR WIOA Reconciliation-FY19 WIOA ADULT Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance October -18 46A8000000 13,296.00 November -18 46A8000000 13,296.00 December -18 46A8000000 13,296.00 December -18 "B" 46A8000000 13,296.00 January -19 46A8000000 13,296.00 February -19 46A8000000 13,296.00 March -19 46A8000000 1,486.63 1,486.63 1,486.63 6/24/19 11,809.37 April -19 46A8000000 4,245.76 4,245.76 4,245.76 5/28/19 7,563.61 May -19 46A8000000 5,122.26 5,122.26 5,122.26 7/9/19 2,441.35 June -19 46A8000000 2,441.35 2,441.35 2,441.35 7/24/19 - July -19 46A8000000 - August -19 46A8000000 - September -19 46A8000000 - October -19 46A8000000 - November -19 46A8000000 - December -19 46A8000000 - January -20 46A8000000 - February -20 46A8000000- March -20 46A8000000 - April -20 46A8000000 - May -20 46A8000000 - June -20 46A8000000 - Totals 13,296.00 13,296.00 13,296.00 46A8000000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Period °Period Balance s.(PJTD) - Adj-20 Account 15230.0000.6500.46A8000000.0000 00000000' M[Oct-18 Nov -18 `Dec -18 .. Ilan -19 Feb -19 [Mar -19 Apr -19 IMay-19 ............. 1Jun-19 {Ad1 19 Funds Available ( Detail Balances ) Budget 43296.00' 0.00, 0.00 0.001 0.001 0.00i 0.001 ,f. -30000.001 0.00; 0.00, 13296 001 Encumbrance 0.00f..... 0.001 Actual 000 0.00 0001 000 0.00 0.00; 0.00; 0.00 Funds Available 43296 00_ 0.00,.'J, 0.00 e 0.00 0.00 0.001 1486 631 -1486.63 A. 0.00; 4245.761 4245 76"' 0.00 5122.26; -35122.26 0.00 2441 351 -2441.35 0.00 0.001 0.00 13296.00( 0.00 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT SUBRECIPIENT: ADDRESS: GRANT CLOSEOUT RECONCILIATION WORKSHEET Employment Services of Weld County PO Box 1805, Greeley CO 80632 EA/WORKPLAN START DATE PROGRAM INCOME START DATE 10/1/2018 YEAR OF FUNDS TITLE/PROGRAM/PROJECT FY19 DISLOCATED WORKER ADMIN CLEAR Program code Closeout Part 3 Page 1 of 2 FY19 46D8000000 END DATE END DATE 6/30/2020 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 19,000.00 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date 19,000.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 0.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 0.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 19,000.00 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Ccntract to Date 19,000.00 III. PROGRAM INCOME(PI) EXPENSE REPORT 1. Total Program Income Exoenses Re3orted (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV RECONCILICATION 1. FINAL Cash Request Contract to Date i, 19,000.00 2. FINAL Expenses Through End of Contract 19,000.00 3. Cash Request to Date = Expense reoorted Through End Date of Contract? (Check Box) Yes O /No ❑ V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 VI. RECONCILIATION 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 VII. MATCH RECONCILIATION 1. FINAL Match Reported Through End of Contract 0.00 2. FINAL Expenses Through End of Contract 19,000.00 3. Match Percentage of Expenditure Contracttual Requirement 0.00 4. Match Expenditure Requirement 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) 0.00 Yes o /No ❑ 'The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signature irt-e—g Date Date Sit /)70 Authorized Signature Date AUG 2 4 2020 See instruction for completing this for on the next tab (Attachment H 2 of 2) 020ao -02589 t\ COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT GRANT CLOSEOUT RECONCILIATION WORKSHEET GRANT CLOSEOUT RECONCILIATION WORKSHEET INSTRUCTIONS Closeout Part 3 Page 2 of 2 Subreciplent: Enter the subrecipient's name Address: Enter the subrecipient's address Year of Funds: Enter the year of funds of the grants that are being closed (eg. PY17 or FY18) Title/Program/Project: Enter the title, program, and/or project name of the grant. CLEAR Program code: Enter CLEAR program code for the grant. Contract/EA/Workplan Start/End Date: Enter the start and end date of the grant on the applicable lines. Program Income Start/End Date: If program income was generated under the grant, enter the start and end date of the program income portion of the grant on the applicable lines. I. CASH REQUEST 1.Enter the amount of program and administrative cash needs reported prior to this draw. 2. Enter the amount of current cash needs reported. 3. Add the amount from 1 to 2 above. Enr total here. II. PROGRAM EXPENSE REPORT 1. Enter the amount of expenses+accrua5 reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program expenses+accruals through end of this award. 3, Add the amount from 1. to 2. above. Enter total here. ADMINISTRATIVE EXPENSE REPORT 4. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 5. Enter the amount of current admin expenses+accruals through end of this award. 6. Add the amounts from 4 to 5 above. Enter Final total here. III. PROGRAM INCOME EXPENSE REPORT 1. Enter the amount of program income expenses reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program income expenses through end of this award. 3.Add the amounts from 1 to 2. Enter total here. IV. RECONCILIATION The goal of this reconciliation is that cash drawn should equal expenses+accruals reported at the end of the award. If the answer to #3 below is NO and no PI has been reported, then adjust current cash draw or current expenses reported to achlese a YES while reflecting actual expenses per your accounting records. If PI has been earned under this award, complete V thru VI 1. Enter the amount from 1.3 here 2. Enter the amount frojm 11.3 and 111.3 hoe 3. Does the amount from 1. EQUAL amornt from 2? Check the appropriate box. V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Enter the amount of program income cash reported as received prior to this report. 2. Enter the amount of current PI cash retorted. 3. Add the amounts from 1 to 2. Enter total here. VI. RECONCILIATION The goal of this reconciliation is to determine whether PI cash earned has been spent, and if not, whether if can be spent beyond the period of performance. 1. Enter the amount from V.3 here. 2. Enter the amount from 111.3 here. 3. Enter difference of 2 from 1 here. VII. MATCH RECONCILIATION The goal of this reconciliation is that match met should equal or exceed expenses+accruals reported at the end of the award. If the answer to 5 is NO, additional match will be required. 1. Enter the amount of match reported though the end of this award. 2. Enter the amount from 11.3 here. 3. Enter the match requirement as a percentage of expenditures. For example, a match of 1 dollar for every 1 dollar expended (1 for 1) is 100%. Match of 1 dollar for every 2 dollars (1 of 2) expenoed is 50%. 4. Mutiply the amount from 2 by the amount in 3. 5. Is the amount in 1. greater than or equal to the amount in 4. Check the appropriate box. Preparer's and Director's Signature and Date: Optional signature for subrecipient's reference. CLEAR WIOA Reconciliation-FY19 DISLOCATED WORKER ADMIN Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance October -18 46D8000000 19,000.00 November -18 46D8000000 19,000.00 December -18 46D8000000 19,000.00 January -19 46D8000000 19,000.00 February -19 46D8000000 19,000.00 March -19 46D8000000 697.81 697.81 697.81 6/24/19 18,302.19 April -19 46D8000000 2,036.30 2,036.30 2,036.30 5/28/19 16,265.89 May -19 46D8000000 2,616.78 2,616.78 2,616.78 7/9/19 13,649.11 June -19 46D8000000 7,490.99 7,490.99 7,490.99 7/24/19 6,158.12 July -19 46D8000000 6,158.12 August -19 46D8000000 2,089.72 2,089.72 2,089.72 10/2/19 4,068.40 September -19 46D8000000 3,509.52 3,509.52 3,509.52 11/8/19 558.88 October -19 46D8000000 558.88 558.88 558.88 12/12/19 - November -19 46D8000000 - December -19 46D8000000 - January -20 46D8000000 - February -20 46D8000000 - March -20 46D8000000 - April -20 46D8000000 - May -20 46D8000000 - June -20 46D8000000 - Totals 19,000.00 19,000.00 19,000.00 46D8000000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Account 152-30—.0000.6500.46D8000000.0000.00000000 ' Funds Available ( Detail Balances ) Period ' Oct -18 (Nov -18 !Dec -18 IJan-19^ Feb -19 rMar-19 Apr -19Y. May -19_. [Jun -19 !}Adj-19 Budget Encumbrance 19000.00 0.00 I 0.00 0.00 0.00, 0.001 0.00 0.00'I 0.00 0.001 19000.00' Actual 0001 000, 0.00 0.001 0.00! 0.00 I� 0.00 ___ D.00€_ 697.81 0.00,1 2036.30 0.00!' 0.001 0.00 I 2616 781 7490.991 0.001 Funds Available 19000 00� 0. 00!!!„.I.,' 0 00 0.00 0.00 -697.81 -2036.30 !I"'I -2616.78 -7490.99' 0 00 Cancel °Period Balances (PJTD) - Adj-20 Account X5230.0000.6500 46D8000000.0000.00000000 Period' '.Jut -19 lAug-19 ISep-19 1Oct-19 6Nov-19 Dec -19 iJan-20 Feb 20 LMar-20 Apr-20 Funds Available ( Detail Balances ) Budget 0.00 0.00, 0.001 0.00'. 000' 0.001 0.00,j 0.00! 0.00'; 19000.00 Encumbrance 0.00 0.001 0.001 0.00 0.00 0.001 000I 000i 0,001 0.00 0.001 Funds Available 0.00 0.00 7 2089.72 3509.52 558.881 0.00 I 0.00! 0.001 0.00 0.00i 0.001 19000.001 -2089.72 -3509.52. -558.88 0.00 0 00 0.00 !!`, . 0.00 0.00 0.00 Cancel. ;, COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part 3 SUBRECIPIENT: ADDRESS: GRANT CLOSEOUT RECONCILIATION WORKSHEET Employment Services of Weld County PO Box 1805, Greeley CO 80632 EA/WORKPLAN START DATE PROGRAM INCOME START DATE 10/1/2018 YEAR OF FUNDS Page 1 of 2 FY19 TITLE/PROGRAM/PROJECT FY19 25% ENHANCED DW ADMIN CLEAR Program code 47D8000000 END DATE END DATE 6/30/2020 I. CASH REQUEST hw, l,��i 1. Total program and Admin Cash needs Preciously Reported 1,981.00 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date 1,981.00 1I. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 0.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 0.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 1,981.00 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 1,981.00 III. PROGRAM INCOME(PI) EXPENSE REPORT 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV RECONCILICATION I`� `�°��''Mi,u;." 1. FINAL Cash Request Contract to Date 1,981.00 2. FINAL Expenses Through End of Contract 1,981.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes O /No ❑ V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 A RECONCILIATION t - 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 WI. MATCH RECONCILIATION 1. FINAL Match Reported Through End of Contract 0.00 2. FINAL Expenses Through End of Contract 1,981.00 3. Match Percentage of Expenditure Contracttual Requirement 0.00 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes ID /No O *The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signatur / Date g10 Authorized Signature 2 AUG...- Date ^�+�+ 2 4 2020 See instruction for completing this for on the next tab (Attachment H 2 of 2) 0202 -02,x? 3y COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT GRANT CLOSEOUT RECONCILIATION WORKSHEET GRANT CLOSEOUT RECONCILIATION WORKSHEET INSTRUCTIONS Closeout Part 3 Page 2 of 2 Subrecipient: Enter the subrecipient's name Address: Enter the subrecipient's address Year of Funds: Enter the year of funds of the grants that are being closed (eg. PY17 or FY18) Title/Program/Project: Enter the title, program, and/or project name of the grant. CLEAR Program code: Enter CLEAR program code for the grant. Contract/EA/Workplan Start/End Date: Enter the start and end date of the grant on the applicable lines. Program Income Start/End Date: If program income was generated under the grant, enter the start and end date of the program income portion of the grant on the applicable lines. I. CASH REQUEST 1.Enter the amount of program and administrative cash needs reported prior to this draw. 2. Enter the amount of current cash needs reported. 3. Add the amount from 1 to 2 above. Enter total here. II. PROGRAM EXPENSE REPORT 1. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program expenses+accruals through end of this award. 3, Add the amount from 1. to 2. above. Enter total here. ADMINISTRATIVE EXPENSE REPORT 4. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 5, Enter the amount of current admin expenses+accruals through end of this award. 6. Add the amounts from 4 to 5 above. Enter Final total here. 111. PROGRAM INCOME EXPENSE REPORT 1. Enter the amount of program income expenses reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program income expenses through end of this award. 3.Add the amounts from 1 to 2. Enter total here. IV. RECONCILIATION The goal of this reconciliation is that cash drawn should equal expenses+accruals reported at the end of the award. If the answer to #3 below is NO and no PI has been reported, then adjust current cash draw or current expenses reported to achiese a YES while reflecting actual expenses per your accounting records. If PI has been earned under this award, complete V thru VI 1. Enter the amount from 1.3 here 2. Enter the amount frojm 11.3 and 111.3 here 3. Does the amount from 1. EQUAL amount from 2? Check the appropriate box. V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Enter the amount of program income cash reported as received prior to this report. 2. Enter the amount of current PI cash reported. 3. Add the amounts from 1 to 2. Enter total here. VI. RECONCILIATION The goal of this reconciliation is to determine whether PI cash earned has been spent, and if not, whether if can be spent beyond the period of performance. 1. Enter the amount from V.3 here. 2. Enter the amount from 111.3 here. 3. Enter difference of 2 from 1 here. VII. MATCH RECONCILIATION The goal of this reconciliation is that match met should equal or exceed expenses+accruals reported at the end of the award. If the answer to 5 is NO, additional match will be required. 1. Enter the amount of match reported through the end of this award. 2. Enter the amount from 11.3 here. 3. Enter the match requirement as a percentage of expenditures. For example, a match of 1 dollar for every 1 doOar expended (1 for 1) is 100%. Match of 1 dollar for every 2 dollars (1 of 2) expended is 50%. 4. Mutiply the amount from 2 by the amount in 3. 5. Is the amount in 1. greater than or equal to the amount in 4. Check the appropriate box, Preparer's and Director's Signature and Date: Optional signature for subrecipient's reference. CLEAR WIOA Reconciliation-FY19 25% ENHANCED DW ADMIN Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance October -18 47D8000000 1,981.00 November -18 47D8000000 1,981.00 December -18 47D8000000 1,981.00 January -19 47D8000000 1,981.00 February -19 47D8000000 1,981.00 March -19 47D8000000 1,981.00 April -19 47D8000000 1,981.00 May -19 47D8000000 1,981.00 June -19 47D8000000 1,981.00 1,981.00 1,981.00 7/24/19 - July -19 47D8000000 - August -19 47D8000000 - September -19 47D8000000 - October -19 47D8000000 - November -19 47D8000000 - December -19 47D8000000 - January -20 47D8000000 - February -20 47D8000000 - March -20 47D8000000 - April -20 47D8000000 - May -20 47D8000000 June -20 47D8000000 - Totals 1,981.00 1,981.00 1,981.00 47D8000000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 ?Period Balat1ce5 (PJTD) - Adj-20 Account X5230.0000.6500.47D8000000.0000.00000000' Funds Available ( Detail Balances ) Period Oct -18 rNov-18 Dec -18 [Jan 19 'IFeb-19 IMar-19 ,Apr -19 _.. [May -19 LJun-19 I3Adj-19 Budget 11981 001 L...... 0.00 0 00' 0.00i 0.001 0.0(J; 0.001 0.00 -10000.001 Encumbrance 0.00 0.00 0.00, 0.00 t- 0.00 0.00 0.00 0.00 Actual 000[ 0.00; 0.00; 0.00 .,a 0 ' I D 00 0.00; 0.00m 1981.00' o.00 Funds Available 11981.00°m^ 0.00 0.00 0.00 0.00 t 0.00 -10000.00 -1981.00', , 0.00 Cancel COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT SUBRECIPIENT: ADDRESS: GRANT CLOSEOUT RECONCILIATION WORKSHEET Employment Services of Weld County PO Box 1805, Greeley CO 80632 EA/WORKPLAN START DATE PROGRAM INCOME START DATE 10/1/2018 YEAR OF FUNDS Closeout Part 3 Page 1 of 2 FY19 TITLE/PROGRAM/PROJECT FY19 WIOA ADULT PROGRAM CLEAR Program code 48A8000000 END DATE END DATE 6/30/2020 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 421,200.00 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date 421,200.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 421,200.00 2. Current Expenses + Accruals (Through 'End Date of Award) 3. FINAL Program Expenses Contract to Date 421,200.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 0.00 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 0.00 III. PROGRAM INCOME(PI) EXPENSE REPORT , 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION 1. FINAL Cash Request Contract to Date 421,200.00 2. FINAL Expenses Through End of Contract 421,200.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes O /No O V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Total PI Cash Previously Reported on Cash Request t �,.., 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 W. RECONCILIATION . 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 WI. MATCH RECONCILIATION 1. FINAL Match Reported Through End of Contract 0.00 2. FINAL Expenses Through End of Contract 421,200.00 3. Match Percentage of Expenditure Contracttual Requirement 0.00 4. Match Expenditure Requirement 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) 0.00 Yes El /No ❑ 'The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signatu/rte-/-7 Date Q I j'7)7,0 Authorized Signature ,—#4._ , — Date AUG 2 4 2020 See instruction for completing this for on the next tab (Attachment H 2 of 2) COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT GRANT CLOSEOUT RECONCILIATION WORKSHEET GRANT CLOSEOUT RECONCILIATION WORKSHEET INSTRUCTIONS Closeout Part 3 Page 2 of 2 Subreciplent: Enter the subrecipient's name Address: Enter the subrecipient's address Year of Funds: Enter the year of funds of the grants that are being closed (eg. PY17 or FY18) Title/Program/Project: Enter the title, program, and/or project name of the grant. CLEAR Program code: Enter CLEAR program code for the grant. Contract/EANVorkplan Start/End Date: Enter the start and end date of the grant on the applicable lines. Program Income Start/End Date: If program income was generated under the grant, enter the start and end date of the program income portion of the grant on the applicable lines. I. CASH REQUEST 1.Enter the amount of program and administrative cash needs reported prior to this draw. 2. Enter the amount of current cash needs reported. 3. Add the amount from 1 to 2 above. Enter total here. II. PROGRAM EXPENSE REPORT 1. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program expenses+accruals through end of this award. 3. Add the amount from 1. to 2. above. Enter total here. ADMINISTRATIVE EXPENSE REPORT 4. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 5. Enter the amount of current admin expenses+accruals through end of this award. 6. Add the amounts from 4 to 5 above. Enter Final total here. III. PROGRAM INCOME EXPENSE REPORT 1. Enter the amount of program income expenses reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program income expenses through end of this award. 3.Add the amounts from 1 to 2. Enter total here. IV. RECONCILIATION The goal of this reconciliation is that cash drawn should equal expenses+accruals reported at the end of the award. If the answer to #3 below is NO and no PI has been reported, then adjust current cash draw or current expenses reported to achiese a YES while reflecting actual expenses per your accounting records. If PI has been earned under this award, complete V thru VI 1. Enter the amount from 1.3 here 2. Enter the amount frojm 11.3 and 111.3 here 3. Does the amount from 1. EQUAL amount from 2? Check the appropriate box. V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Enter the amount of program income cash reported as received prior to this report. 2. Enter the amount of current PI cash reported. 3. Add the amounts from 1 to 2. Enter total here. VI. RECONCILIATION The goal of this reconciliation is to determine whether PI cash earned has been spent, and if not, whether if can be spent beyond the period of performance. 1. Enter the amount from V.3 here. 2. Enter the amount from 111.3 here. 3. Enter difference of 2 from 1 here. VII. MATCH RECONCILIATION The goal of this reconciliation is that match met should equal or exceed expenses+accruals reported at the end of the award. If the answer to 5 is NO, additional match will be required. 1. Enter the amount of match reported through the end of this award. 2. Enter the amount from 11.3 here. 3. Enter the match requirement as a percentage of expenditures. For example, a match of 1 dollar for every 1 dollar expended (1 for 1) is 100%. Match of 1 dollar for every 2 dollars (1of 2) expended is 50%. 4. Mutiply the amount from 2 by the amount in 3. 5. Is the amount in 1. greater than or equal to the amount in 4. Check the appropriate box. Preparers and Director's Signature and Date: Optional signature for subrecipient's reference. CLEAR WIOA Reconciliation-FY19 WIOA ADULT PROGRAM Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance October -18 48A8000000 421,200.00 November -18 48A8000000 49,558.41 421,200.00 December -18 48A8000000 72,066.67 421,200.00 December -18 "B" 48A8000000 15,285.38 421,200.00 December -18 "C" 48A8000000 (328.02) 421,200.00 January -19 48A8000000 34,528.62 171,111.06 171,111.06 3/19/19 250,088.94 February -19 48A8000000 51,516.79 51,516.79 51,516.79 4/12/19 198,572.15 March -19 48A8000000 48,189.10 48,189.10 48,189.10 6/24/19 150,383.05 April -19 48A8000000 48,953.77 48,953.77 48,953.77 5/28/19 101,429.28 May -19 48A8000000 101,429.28 June -19 48A8000000 101,429.28 July -19 48A8000000 57,251.03 57,251.03 57,251.03 9/5/19 44,178.25 August -19 48A8000000 44,178.25 42,645.25 42,645.25 10/2/19 1,533.00 September -19 48A8000000 1,533.00 October -19 48A8000000 1,533.00 1,533.00 12/12/19 - November -19 48A8000000 - December -19 48A8000000 - January -20 48A8000000 - February -20 48A8000000 - March -20 48A8000000 - April -20 48A8000000 - May -20 48A8000000 - June -20 48A8000000 - Totals 421,200.00 421,200.00 421,200.00 48A8000000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Account 15230.0000.6500.48A8000000.0000.00000000' Funds Available ( Detail Balances ) Budget Encumbrance 389667.001 0.001 0.00, 0.00, 0.00 0.00 Period Oct -18 Nov -18 'Dec -18 jJan-19 {Feb -19 Mar -19 Apr -19 May -19 Jun -19 Adj-19 .._.. 0.001 0.001 0.001 0.00 30000 001 1533 00 0.001 °Period Balances (PJTD) - Adj-20 Account ;5230.0000.6500 48A8000000.0000.00000000' Funds Available ( Detail Balances ) Period Aug -19 1Sep-19__._ Oct -19 ,Nov -19 1'1, -Dec -19 1Jan-20 Feb 20 • Mar -20 Apr -20 0.00i 0.001 0.001 0.001 0.001 000 Budget Encumbrance 000.t. Q00, 0.00; _ _ 0 00 _ 0.00; 0 00 0.00. 0.00 0.00f 0.001 1533.00; -1533.00 r 0.00' 0.00 ` 0 00 0.00 0.00; 0.00; 0.00 0.00 0.00' 0 00 0 00 0.00 0 00l 0 00' 0.001 0 00' 0001...._... 0001 000,1 000 0.00? 0 00! 0.00, 0.00`.x' Actual 0.001 0.001 0.001 171111.061 51516 79 48189 101 48953.77! 0.001 0.00; Funds Available 389667.00- 0.0014- _ -171111.06x' -51516.79,111- . -48189 10' i,, -48953.77' 30000.00 1533.00 0.00'. Cancel Actual Funds Available 57251 03 -57251 03, 42645.251 -42645.25,4',1 421200.00 '; 0.00' 421200.001 0.00 Cancel COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT GRANT CLOSEOUT RECONCILIATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley CO 80632 EA/WORKPLAN START DATE PROGRAM INCOME START DATE 10/1/2018 YEAR OF FUNDS TITLE/PROGRAM/PROJECT FY19 DISLOCATED WORKER PROG CLEAR Program code Closeout Part 3 Page 1 of 2 FY19 48D8000000 END DATE END DATE 6/30/2020 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 172,710.00 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date 172,710.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 172,710.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 172,710.00 ADMINISTRATIVE EXPENSE (ER) ? r ` : .; 4. Total Expenses+Accruals Previously Reported (Through Last Month) 0.00 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 0.00 III. PROGRAM INCOME(PI) EXPENSE REPORT 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV RECONCILICATION 1. FINAL Cash Request Contract to Date 172,710.00 2. FINAL Expenses Through End of Contract 172,710.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes Et /No 0 V. CASH REQUEST PROGRAM INCOME CASH REPORTED)�L,r, 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 VI. RECONCILIATION �Fl .,t ra,; , a�, v¢ 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 VII. MATCH RECONCILIATION a.,s 1. FINAL Match Reported Through End of Contract 0.00 2. FINAL Expenses Through End of Ccntract 172,710.00 3. Match Percentage of Expenditure Contracttual Requirement 0.00 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes 91 /No 0 *The program Income Expense Report and Casa Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signaturei�� "" Date AJ " AUG 4 LUZU Date Authorized Signature JL.EPi See instruction for completing this for on the nest tab (Attachment H 2 of 2) aoo20_02587 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part 3 GRANT CLOSEOUT RECONCILIATION WORKSHEET Page 2 of 2 GRANT CLOSEOUT RECONCILIATION WORKSHEET INSTRUCTIONS Subrecipient: Enter the subrecipient's name Address: Enter the subrecipient's address Year of Funds: Enter the year of funds of the grants that are being closed (eg. PY17 or FY18) TItle/Program/Protect: Enter the title, program, and/or project name of the grant. CLEAR Program code: Enter CLEAR program code for the grant. Contract/EA/Workplan Start/End Date: Enter the start and end date of the grant on the applicable lines. Program Income Start/End Date: If program income was generated under the grant, enter the start and end date of the program income portion of the grant on the applicable lines: I. CASH REQUEST 1.Enter the amount of program and administrative cash needs reported prior to this draw. 2. Enter the amount of current cash needs reported. 3. Add the amount from 1 to 2 above. Enter total here. II. PROGRAM EXPENSE REPORT 1. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program expenses+accruals through end of this award. 3. Add the amount from 1. to 2. above. Enter total here. ADMINISTRATIVE EXPENSE REPORT 4. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 5. Enter the amount of current admin expenses+accruals through end of this award. 6. Add the amounts from 4 to 5 above. Enter Final total here. III: PROGRAM INCOME EXPENSE REPORT 1. Enter the amount of program income expenses reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program income expenses through end of this award. 3.Add the amounts from 1 to 2. Enter total here. IV. RECONCILIATION The goal of this reconciliation is that cash drawn should equal expenses+accruals reported at the end of the award. If the answer to #3 below is NO and no PI has been reported, then adjust current cash draw or current expenses reported to achiese a YES while reflecting actual expenses per your accounting records. If PI has been earned under this award, complete V thru VI 1. Enter the amount from 1.3 here 2. Enter the amount frojm 11.3 and 111.3 here 3. Does the amount from 1. EQUAL amount from 2? Check the appropriate box. V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Enter the amount of program income cash reported as received prior to this report. 2. Enter the amount of current PI cash reported. 3. Add the amounts from 1 to 2. Enter total here. VI. RECONCILIATION The goal of this reconciliation is to determine whether PI cash earned has been spent, and if not, whether if can be spent beyond the period of performance. 1. Enter the amount from V.3 here. 2. Enter the amount from 111.3 here. 3. Enter difference of 2 from 1 here. VII. MATCH RECONCILIATION The goal of this reconciliation is that match met should equal or exceed expenses+accruals reported at the end of the award. If the answer to 5 is NO, additional match will be required. 1. Enter the amount of match reported through the end of this award. 2. Enter the amount from 11.3 here. 3. Enter the match requirement as a percentage of expenditures. For example, a match of 1 dollar for every 1 dollar expended (1 for 1) is 100%. Match of 1 dollar for every 2 dollars (1 of 2) expended is 50%. 4. Mutiply the amount from 2 by the amount in 3. 5. Is the amount in 1. greater than or equal to the amount in 4. Check the appropriate box. Preparer's and Director's Signature and Date: Optional signature for subrecipient's reference. CLEAR WIOA Reconciliation-FY19 DISLOCATED WORKER PROGRAM Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance October -18 48D8000000 172,710.00 November -18 48D8000000 172,710.00 December -18 48D8000000 3,573.91 172,710.00 December -18 "B" 48D8000000 3,518.81 172,710.00 December -18 "C" 48D8000000 (78.55) 172,710.00 January -19 48D8000000 5,310.18 12,324.35 12,324.35 3/19/19 160,385.65 February -19 48D8000000 16,289.75 16,289.75 16,289.75 4/12/19 144,095.90 March -19 48D8000000 21,395.71 21,395.71 21,395.71 6/24/19 122,700.19 April -19 48D8000000 4,255.03 4,255.03 4,255.03 5/28/19 118,445.16 May -19 48D8000000 13,116.80 13,116.80 13,116.80 7/9/19 105,328.36 June -19 48D8000000 24,876.94 24,876.94 24,876.94 7/24/19 80,451.42 July -19 48D8000000 28,809.28 28,809.28 28,809.28 9/5/19 51,642.14 August -19 48D8000000 27,718.49 27,718.49 27,718.49 10/2/19 23,923.65 September -19 48D8000000 14,972.30 14,972.30 14,972.30 11/8/19 8,951.35 October -19 48D8000000 8,951.35 8,951.35 8,951.35 12/12/19 - November -19 48D8000000 - December -19 48D8000000 - January -20 48D8000000 - February -20 48D8000000 - March -20 48D8000000 - April -20 48D8000000 - May -20 48D8000000 - June -20 48D8000000 - Totals 172,710.00 172,710.00 172,710.00 48D8000000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 c' Period Balances (PJTD) - Adj-20 Account Period Oct -18 Nov -18 'IDec-18 Jan -19 Feb -19 5230.0000.6500.48 D8000000.0000.00000000 Funds Available ( Detail Balances ) 'Mar -19 Apr -19 May-19� 1Jun-19 Adj-19 Budget 171005.001 0.00! 0.001 0.001 0.00. 1705.001 0.001 172710.001 Encumbrance 0.001 o.001 0.001 0.001 0.00 0.00 000 0001 0.00; o.00 Actual 0.001 -0.00; 0.001 12324 35 -12324.35'4,, 16289 75 -16289.7511 -21395 71 4255 031 -4255 03� 13116 801 24876.94 21395.711 0.001 172710.00 Funds Available 171005.00'77 0.00)!,, -13116.80 -23171.94 0.00_1 Cancel 0.00 CPeriod Balances (PJTD) - Adj-20 Account 15230.0000.6500.4808000000.0000 .00000000 Period 1Aug-19 '1Sep-19 loot -19 Nov -19 !Jan -20 1Feb 20 1Mar-20 Apr -20 Funds Available ( Detail Balances ) Budget 0.00! 0.001 000' 0.00! 0.00' 0.00: 0.00''. 172710.00 Encumbrance Actual Funds Available 0.00 28809.281 -28809.28t 0.001 27718.49= -27718.49 14972.301 -14972.30 0.00: 0.001 0.00 0001 0.00 000'; 8951.35'1. 0.001 0.001 0.00',.' 0.00; 0.00" 0001��_ 000` 0.001 0.00 0 00 0.00 .' 0.00; 172710.00; Cancel 0.00 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part 3 GRANT CLOSEOUT RECONCILIATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley CO 80632 EA/WORKPLAN START DATE PROGRAM INCOME START DATE 10/1/2018 YEAR OF FUNDS Page 1 of 2 FY19 TITLE/PROGRAM/PROJECT FY19 25% ENHANCED DW PROG CLEAR Program code 49D8000000 END DATE END DATE 6/30/2020 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 117,833.00 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date 117,833.00 II. PROGRAM EXPENSE REPORT (ER) ? b� u,i� t 1. Total Expenses+Accruals Previously Reported (Through Last Month) 117,833.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 117,833.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) t, 0.00 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 0.00 III. PROGRAM INCOME(PI) EXPENSE REPORT �, z, , / )J 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION 1. FINAL Cash Request Contract to Date 117,833.00 2. FINAL Expenses Through End of Contract 117,833.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes IS /No ❑ V. CASH REQUEST PROGRAM INCOME CASH REPORTED Il7 ," 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 VI. RECONCILIATION k''' . 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 WI. MATCH RECONCILIATION it .... 1. FINAL Match Reported Through End of Contract 0.00 2. FINAL Expenses Through End of Contract 117,833.00 3. Match Percentage of Expenditure Contracttual Requirement 0.00 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes O /No O 'The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signature� ! Dat % lR� Authorized Signature Date AUG• ` 2 4 MU See instruction for completing this for on the next tab (Attachment H 2 04 2) COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT GRANT CLOSEOUT RECONCILIATION WORKSHEET GRANT CLOSEOUT RECONCILIATION WORKSHEET INSTRUCTIONS Closeout Part 3 Page 2 of 2 Subreciplent: Enter the subrecipient's name Address: Enter the subrecipient's address Year of Funds: Enter the year of funds of the grants that are being closed (eg. PY17 or FY18) Title/Program/Project: Enter the title, program, and/or project name of the grant. CLEAR Program code: Enter CLEAR program code for the grant. Contract/EAIWorkplan Start/End Date: Enter the start and end date of the grant on the applicable lines. Program Income Start/End Date: If program income was generated under the grant, enter the start and end date of the program income portion of the grant on the applicable lines. 1. CASH REQUEST 1.Enter the amount of program and administrative cash needs reported prior to this draw. 2. Enter the amount of current cash needs reported. 3. Add the amount from 1 to 2 above. Enter total here. II. PROGRAM EXPENSE REPORT 1. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program expenses+accruals through end of this award. 3. Add -the amount from 1. to 2. above. Enter total here. ADMINISTRATIVE EXPENSE REPORT 4. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 5. Enter the amount of current admin expenses+accruals through end of this award. 6. Add the amounts from 4 to 5 above. Enter Final total here. III. PROGRAM INCOME EXPENSE REPORT 1. Enter the amount of program income expenses reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program income expenses through end of this award. 3.Add the amounts from 1 to 2. Enter total here. IV. RECONCILIATION The goal of this reconciliation is that cash drawn should equal expenses+accruals reported at the end of the award. If the answer to #3 below is NO and no PI has been reported, then adjust current cash draw or current expenses reported to achiese a YES while reflecting actual expenses per your accounting records. If PI has been earned under this award, complete V thru VI 1. Enter the amount from 1.3 here 2. Enter the amount frojm 11.3 and 111.3 here 3. Does the amount from 1. EQUAL amount from 2? Check the appropriate box. V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Enter the amount of program income cash reported as received prior to this report. 2. Enter the amount of current PI cash reported. 3. Add the amounts from 1 to 2. Enter total here. VI. RECONCILIATION The goal of this reconciliation is to determine whether PI cash earned has been spent, and if not, whether if can be spent beyond the period of performance. 1. Enter the amount from V.3 here. 2. Enter the amount from 111.3 here. 3. Enter difference of 2 from 1 here. VII. MATCH RECONCILIATION The goal of this reconciliation is that match met should equal or exceed expenses+accruals reported at the end of the award, If the answer to 5 is NO, additional match will be required. 1. Enter the amount of match reported through the end of this award. 2. Enter the amount from 11.3 here. 3. Enter the match requirement as a percentage of expenditures. For example, a match of 1 dollar for every 1 dollar expended (1 for 1) is 100%. Match of 1 dollar for every 2 dollars (101 2) expended is 50%. 4. Mutiply the amount from 2 by the amount in 3. 5. Is the amount in 1. greater than or equal to the amount in 4. Check the appropriate box. Preparer's and Director's Signature and Date: Optional signature for subrecipient's reference. CLEAR WIOA Reconciliation-FY19 25% ENHANCED DW PROGRAM Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance October -18 49D8000000 117,833.00 November -18 49D8000000 117,833.00 December -18 49D8000000 117,833.00 December -18 "B" 49D8000000 117,833.00 December -18 "C" 49D8000000 117,833.00 January -19 49D8000000 117,833.00 February -19 49D8000000 117,833.00 March -19 49D8000000 4,655.06 4,655.06 4,655.06 6/24/19 113,177.94 April -19 49D8000000 26,385.81 26,385.81 26,385.81 5/28/19 86,792.13 May -19 49D8000000 22,106.07 22,106.07 22,106.07 7/9/19 64,686.06 June -19 49D8000000 22,535.02 22,535.02 22,535.02 7/24/19 42,151.04 July -19 49D8000000 2,646.13 2,646.13 2,646.13 9/5/19 39,504.91 August -19 49D8000000 3,168.11 3,168.11 3,168.11 10/2/19 36,336.80 September -19 49D8000000 5,048.15 5,048.15 5,048.15 11/8/19 31,288.65 October -19 49D8000000 4,897.50 4,897.50 4,897.50 12/12/19 26,391.15 November -19 49D8000000 3,707.63 3,707.63 3,707.63 1/13/20 22,683.52 December -19 49D8000000 22,683.52 January -20 49D8000000 22,683.52 February -20 49D8000000 22,683.52 22,683.52 22,683.52 3/6/20 - March -20 49D8000000 - April -20 49D8000000 - May -20 49D8000000 - June -20 49D8000000 - Totals 117,833.00 117,833.00 117,833.00 49D8000000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Account i___� 15230.0000.6500.49 D80o0o00.0000. 00000000''. Funds Available ( Detail Balances ) Period Budget IllOct 18 107833 00' Nov -18 0.00 .Dec -18 0.00' lJan-19__ 0 00 1[Feb-19 j[Mar-19 Apr -19 May -19 lJun-19 Adj-19... a 00 0.001 10000.00E 0.00! 0.00! 117833.00 Encumbrance 0.00 0.00 0.001 0.001 0.001 0.00 0.00,{ 0.001 0.00; 0.001 0.00 r_ Actual Funds Available 107833 007 0.00 _. _._.000 0.00 0001 0.00 0 00' • 0.001 0. oo • 4655.06! 26385 81[ 22106.07, 22535.02i .__.. 0.00 117833.001 -4655.06 -26385.81 -12106.07 -22535.02 000: Cancel 0.00 ❑' Peried Balances (PJTD) - Adj-20 Account 15230.0000.6500.49D8000000.0000.00000000 Period Jul -19 Aug -19 [Sep -19 Oct -19 ,Nov -19 +Dec -19 !Jan -20 (Feb -20 [Mar -20 'r iApr-20...... Funds Available ( Detail Balances ) Budget 0.001 0.00' 0.001 0.00 0.00' 0.00 0.00 0.00' 0.00 0.00[ Encumbrance 0.00 r 0.00i 3168.11 -3168.11 0.001 5048.15, -5048.15 0.001 4897.50! -4897.50 0.00i 3707.63! -3707.63 i 0.00 0 00, 0.00', 0.00! 0.001 0.00- 0.00' 22683 52, -22683.52 0.00[ 0.001 0.00 0.00i 0 00 0.00':' 117833.00'! 0.00'; Actual Funds Available 2646.131 -2646.13'; 117833.001 Cancel 0.00 SUBRECIPIENT: ADDRESS: COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT GRANT CLOSEOUT RECONCILIATION WORKSHEET Employment Services of Weld County PO Box 1805, Greeley CO 80632 EA/WORKPLAN START DATE PROGRAM INCOME START DATE 10/1/2018 YEAR OF FUNDS TITLE/PROGRAM/PROJECT FY19 DW ADMIN TRANSFER TO ADULT CLEAR Program code Closeout Part 3 Page 1 of 2 FY19 4BD8000000 END DATE END DATE 6/30/2020 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date 15,000.00 15 000.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 2. Current Expenses + Accruals (Through End Date of Award) rlF. . ' i� 0.00 3. FINAL Program Expenses Contract to Date 0.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 15,000.00 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 15,000.00 III. PROGRAM INCOME(PI) EXPENSE REPORT nali'(. 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION:>rrx .,. 1. FINAL Cash Request Contract to Date 15,000.00 2. FINAL Expenses Through End of Contract 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) 15,000.00 Yes ID /No ❑ V. CASH REQUEST PROGRAM INCOME CASH REPORTED , t ,u 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 VI. RECONCILIATION 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 VII. MATCH RECONCILIATION 1,1� 1. FINAL Match Reported Through End of Contract 0.00 2. FINAL Expenses Through End of Contract 15,000.00 3. Match Percentage of Expenditure Contracttual Requirement 0.00 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes /No ❑ *The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's SignaturB// Date a )0 120 Date AUG 2 4 2020 Authorized Signature See instruction for completing this for on the next lab (Attachment H 2 of 2) 02v02 - �6i COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT GRANT CLOSEOUT RECONCILIATION WORKSHEET GRANT CLOSEOUT RECONCILIATION WORKSHEET INSTRUCTIONS Closeout Part 3 Page 2 of 2 Subreciplent: Enter the subrecipient's name Address: Enter the subrecipient's address Year of Funds: Enter the year of funds of the grants that are being closed (eg. PY17 or FY18) Title/Program/Protect: Enter the title, program, and/or project name of the grant. CLEAR Program code: Enter CLEAR program code for the grant. Contract/EAlWorkplan Start/End Date: Enter the start and end date of the grant on the applicable lines. Program Income Start/End Date: If program income was generated under the grant, enter the start and end date of the program income portion of the grant on the applicable lines. I. CASH REQUEST 1.Enter the amount of program and administrative cash needs reported prior to this draw. 2. Enter the amount of current cash needs reported. 3. Add the amount from 1 to 2 above. Enter total here. 11. PROGRAM EXPENSE REPORT 1. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program expenses+accruals through end of this award. 3. Add the amount from 1. to 2. above. Enter total here. ADMINISTRATIVE EXPENSE REPORT 4. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 5. Enter the amount of current admin expenses+accruals through end of this award. 6. Add the amounts from 4 to 5 above. Enter Final total here. 111. PROGRAM INCOME EXPENSE REPORT 1. Enter the amount of program income expenses reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program income expenses through end of this award. 3.Add the amounts from 1 to 2. Enter total here. IV. RECONCILIATION The goal of this reconciliation is that cash drawn should equal expenses+accruals reported at the end of the award, If the answer to #3 below is NO and no PI has been reported, then adjust current cash draw or current expenses reported to achiese a YES while reflecting actual expenses per your accounting records. If PI has been earned under this award, complete V thru VI 1. Enter the amount from 1.3 here 2. Enter the amount frojm 11.3 and 111.3 here 3. Does the amount from 1. EQUAL amount from 2? Check the appropriate box. V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Enter the amount of program income cash reported as received prior to this report. 2. Enter the amount of current PI cash reported. 3. Add the amounts from 1 to 2. Enter total here. VI. RECONCILIATION The goal of this reconciliation is to determine whether PI cash earned has been spent, and if not, whether if can be spent beyond the period of performance. 1. Enter the amount from V.3 here. 2. Enter the amount from 111.3 here. 3. Enter difference of 2 from 1 here. VII. MATCH RECONCILIATION The goal of this reconciliation is that match met should equal or exceed expenses+accruals reported at the end of the award. If the answer to 5 is NO, additional match will be required. 1. Enter the amount of match reported through the end of this award. 2. Enter the amount from 11.3 here. 3. Enter the match requirement as a percentage of expenditures. For example, a match of 1 dollar for every 1 dollar expended (1 for 1) is 100%. Match of 1 dollar for every 2 dollars (1 of 2) expended is 50%. 4. Mutiply the amount from 2 by the amount in 3. 5. Is the amount in 1. greater than or equal to the amount in 4. Check the appropriate box. Preparer's and Director's Signature and Date: Optional signature for subrecipient's reference. CLEAR WIOA Reconciliation-FV19 DW ADMIN TRANSFER TO ADULT Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance October -18 4BD8000000 15,000.00 November -18 4B D8000000 15,000.00 December -18 4BD8000000 15,000.00 December -18 "B" 4BD8000000 15,000.00 December -18 "C" 4BD8000000 15,000.00 January -19 4BD8000000 15,000.00 February -19 4BD8000000 15,000.00 March -19 4BD8000000 15,000.00 April -19 4B D8000000 15,000.00 May -19 4BD8000000 15,000.00 June -19 4BD8000000 15,000.00 July -19 4BD8000000 15,000.00 August -19 4BD8000000 3,396.89 3,396.89 3,396.89 10/2/19 11,603.11 September -19 4BD8000000 9,227.60 9,227.60 9,227.60 11/8/19 2,375.51 October -19 4BD8000000 2,375.51 2,375.51 2,375.51 12/12/19 - November -19 4BD8000000 - December -19 4BD8000000 - January -20 4BD8000000 - February -20 4BD8000000 - March -20 4BD8000000 - April -20 4BD8000000 - May -20 4BD8000000 - June -20 4BD8000000 - Totals 15,000.00 15,000.00 15,000.00 4BD8000000 General ledger vs bullied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 °Period Balances (PJTD) - Adj-20 Account 1523O.0000.6500 .4BD8000000.0000.00000000 Period Oct -18 Nov -18 Dec -18._..., Jan -19 Feb -19 Mar -19 1A r-19 May -19 Funds Available ( Detail Balances ) Budget 15000.0O 0.00 0001 0.001 0.00; 0.00 0.001 0.00.1 0.0O1 0.00 Encumbrance 0.001 0.001—y 0.003 000. 0.001 0.00! 0.001 0.00 0.00; 0.001 Account 15230.0000.6500.4BD8000000.0000.00000000 Period __ Jul-19�_... [Aug 19 .[Sep -19 _.. �. [[Oct -19 Nov -19 [Dec -19 [Jan -20 � 0 [Feb -20 1Mar-20 [Apr -20 Funds Available ( Detail Balances ) Budget 0.001 0.001 0.00 0.00 0.001E 0.00, 1 0.001 0.00 E _ 0.00 0.001 0.00E _. Encumbrance 0.00! 0.00;1 0.00, rn 0.001. o.00 0.00T_ 0.0O1 0.00'1 a 0.00; 0.001 15000.001 0.00? Actual Funds Available 0.001 15000 .00,7 000 0.00 0.00 0.00 0.00 0.001 0.00 0.001 0.001 0.001 0.0O3 0.001 0.00; 15000.00; Cancel 0.00, 0.00'`: 0.00 Actual Funds Available 0.001 0.00 3396 891 9227.601 2375.511 0.001 0.00 0.001 0.001 0.001 0.001 15000.00 -3396.89 -9227.60, Cancel 0.001 000' 0.00 000, 0.00 0.00 :` 0.00 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part 3 GRANT CLOSEOUT RECONCILIATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley CO 80632 EA/WORKPLAN START DATE PROGRAM INCOME START DATE 10/1/2018 YEAR OF FUNDS Page 1 of 2 FY19 TITLE/PROGRAM/PROJECT FY19 DW PROG TRANSFER TO ADULT CLEAR Program code 4ND8000000 END DATE END DATE 6/30/2020 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 135,000.00 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date 135,000.00 II. PROGRAM EXPENSE REPORT (ER) _ , 'R m 1. Total Expenses+Accruals Previously Reported (Through Last Month) 135,000.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 135,000.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 0.00 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 0.00 III. PROGRAM INCOME(PI) EXPENSE REPORT k t 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION r. 1. FINAL Cash Request Contract to Date 135,000.00 2. FINAL Expenses Through End of Contract 135,000.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes El /No O V. CASH REQUEST PROGRAM INCOME CASH REPORTED � gifiiy( n �„ 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 W. RECONCILIATION „1� X d=� 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 VII. MATCH RECONCILIATION 11;r, ° ¢ ¢i1 `t '¢ 1. FINAL Match Reported Through End of Contract 0.00 2. FINAL Expenses Through End of Contract 135,000.00 3. Match Percentage of Expenditure Contracttual Requirement 0.00 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes o /No ❑ 'The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signature ....4_,..,., Date i% ,1r/J-/iv 166r.1&17 Authorized Signature110:41VIdDate AUG 2 4 2020 See instruction for completing this for on the next tab (Attachment H 2 of 2) 2o2o-02 9 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT GRANT CLOSEOUT RECONCILIATION WORKSHEET GRANT CLOSEOUT RECONCILIATION WORKSHEET INSTRUCTIONS Closeout Part 3 Page 2 of 2 Subrecipient: Enter the subrecipient's name Address: Enter the subrecipient's address Year of Funds: Enter the year of funds of the grants that are being closed (eg. PY17 or FY18) Title/Program/Project: Enter the title, program, and/or project name of the grant. CLEAR Program code: Enter CLEAR program code for the grant. Contract/EA/Workplan Start/End Date: Enter the start and end date of the grant on the applicable lines. Program Income Start/End Date: If program income was generated under the grant, enter the start and end date of the program income portion of the grant on the applicable lines. I. CASH REQUEST 1.Enter the amount of program and administrative cash needs reported prior to this draw. 2. Enter the amount of current cash needs reported. 3. Add the amount from 1 to 2 above. Enter total here. II. PROGRAM EXPENSE REPORT 1. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program expenses+accruals through end of this award. 3. Add the amount from 1. to 2. above. Enter total here. ADMINISTRATIVE EXPENSE REPORT 4. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Analysis report. 5. Enter the amount of current admin expenses+accruals through end of this award. 6. Add the amounts from 4 to 5 above. Enter Final total here. III. PROGRAM INCOME EXPENSE REPORT 1. Enter the amount of program income expenses reported prior to this report on the CLEAR Funds Available Analysis report. 2. Enter the amount of current program income expenses through end of this award. 3.Add the amounts from 1 to 2. Enter total here. IV. RECONCILIATION The goal of this reconciliation is that cash drawn should equal expenses+accruals reported at the end of the award. If the answer to #3 below is NO and no PI has been reported, then adjust current cash draw or current expenses reported to achiese a YES while reflecting actual expenses per your accounting records. If PI has been earned under this award, complete V thru VI 1. Enter the amount from 1.3 here 2. Enter the amount frojm 11.3 and 111.3 here 3. Does the amount from 1. EQUAL amount from 2? Check the appropriate box. V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Enter the amount of program income cash reported as received prior to this report. 2. Enter the amount of current PI cash reported. 3. Add the amounts from 1 to 2. Enter total here. VI. RECONCILIATION The goal of this reconciliation is to determine whether PI cash earned has been spent, and if not, whether if can be spent beyond the period of performance. 1. Enter the amount from V.3 here. 2. Enter the amount from 111.3 here. 3. Enter difference of 2 from 1 here. VII. MATCH RECONCILIATION The goal of this reconciliation is that match met should equal or exceed expenses+accruals reported at the end of the award. If the answer to 5 is NO, additional match will be required. 1. Enter the amount of match reported through the end of this award. 2. Enter the amount from 11.3 here. 3. Enter the match requirement as a percentage of expenditures. For example, a match of 1 dollar for every 1 dollar expended (1 for 1) is 100%. Match of 1 dollar for every 2 dollars (1 of 2) expended is 50%. 4. Mutiply the amount from 2 by the amount in 3. 5. Is the amount in 1. greater than or equal to the amount in 4. Check the appropriate box. Preparer's and Director's Signature and Date: Optional signature for subrecipient's reference. CLEAR WIOA Reconciliation-FY19 DW PROGRAM TRANSFER TO ADULT Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance October -18 4N D8000000 135,000.00 November -18 4N D8000000 135,000.00 December -18 4N D8000000 135,000.00 January -19 4ND8000000 135,000.00 February -19 4N D8000000 135,000.00 March -19 4ND8000000 135,000.00 April -19 4ND8000000 135,000.00 May -19 4ND8000000 135,000.00 June -19 4ND8000000 14,518.31 14,518.31 14,518.31 7/24/19 120,481.69 July -19 4ND8000000 26,977.90 26,977.90 26,977.90 10/2/19 93,503.79 August -19 4ND8000000 59,047.22 59,047.22 59,047.22 11/8/19 34,456.57 September -19 4ND8000000 34,456.57 34,456.57 34,456.57 12/12/19 - October -19 4ND8000000 - November -19 4ND8000000 - December -19 4ND8000000 - January -20 4ND8000000 - February -20 4ND8000000 - March -20 4ND8000000 - April -20 4ND8000000 - May -20 4ND8000000 - June-20 4ND8000000 - Totals 135,000.00 135,000.00 135,000.00 4ND8000000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 °Period Balances (PJTD) - Adj-20 Account 5230.0000.6500.4W68666-6610.0666766660066 08000000.0000.00000000 Funds Available ( Detail Balances ) Period Budget Encumbrance � Actual Funds Available Oct 18 Nov -18 Dec18._ 8 Jan 19 IFeb-19 . f , I Mar -19 ;Apr 19 E [May 19 Jun -19 1Adj19 "Period Balances (PJTD)- Adj-20 135000.001 0.00, 0.00 135000.00i 0.00;; 0.00i 0.061.111 0.00] .0.001. cool_ 6.061 ..._ �. cool fl 00 0.001 0.D0 I....__�,w 0.00'1 135000.00?, Account-!5230.0000.65Q0.4ND8000000.0000.00000000 Funds Available ( Detail Balances ) • Period. • Budget - Encumbrance 0.00. 0.00,E lAug-19 0.061-• 0.0011 Sep 19 0.061 0 00 1 jt?ct-19 a o.o0; 1Nov-19 _ 0.00i 0.001 1 Dec 99 _.__.� ,,. � .__..___�. _�__ 0.00; 0.061 iJan-20 aA0 0.c0 0 001 0 00 0 00`1. 0,901: 0 00'wN . 0001 0.001 0.00 ;1Feb 20 ;Mar -20 IApr-20 0.001E 0.0011 0.061 0.001 0.00_ 0000, ( i 0.001 0.0011;111 0.00 Q a0.0. o. DO i 0.00 0001 000` 518.31 -14518 31 0flo.-w __�� 0.0011 135000.00' 0.00. Actual Funds Available 0001 000 26977.90 j -26977 90P 59047.22 -59047.221'1 34456 57 -34456.5711, 0.001 00fl 0001 000y 0.001 0.001 0.00 .- B.. o.04j 0 00:x, 135000.DD, 0.DO 135.. mW_ 000.00 0.00 1.. 1 0 0 Cancel Contract Form New Contract Request Entity Information Entity Name* Entity ID* COLORADO DEPARTMENT OF LABOR @00010497 & EMPLOYMENT Contract Name* WORKFORCE INNOVATION AND OPPORUTNITY ACT (WIOA) GRANT CLOSEOUT FOR 2019-20 Contract Status DONE ❑ New Entity? Contract ID 4042 Contract Lead* CULLINTA Contract Lead Email r_ullinta@co_weld.co us,cobbxxl k@co_weld.co.us Parent Contract ID Requires Board Approval YES Department Project # Contract Description * THE WIOA GRANT CLOSEOUT PACKET IS REQUIRED BY THE YEAR-END CONTRACT CLOSEOUT PROCEDURES OF CDLE AND IN ACCORDANCE WITH PGL06-12-F1 FOR ALL PROGRAMS THAT HAVE EXPENDITURE AUTHORIZATIONS ENDING DURING THE PERIOD JULY 1. 2019 TO JUNE 30, 2020 Contract Description 2 Contract Type* CONTRACT Amount* $0.00 Renewable* NO Automatic Renewal IGA Department HUMAN SERVICES Department Email CM- HumanServices@weldgov corn Department Head Email CM-HumanServices- DeptHead@weldgov.com County Attorney GENERAL COUNTY ATTORNEY EMAIL County Attorney Email CM- COUNTYATTORNEY@WELD GOV.COM Requested BOCC Agenda Date* 08/24/2020 Due Date 08/20/2020 Will a work session with BOCC be required?* NO Does Contract require Purchasing Dept. to be included? If this is a renewal enter previous Contract ID If this is part of a MSA enter MSA Contract ID Note: the Previous Contract Number and Master Services Agreement Number should be left blank if those contracts are not in OnBase Contract Dates Effective Date Review Date* 04/30/2020 Renewal Date Termination Notice Period Contact Name Contact Type Purchasing Approver Approval Prom Department Head JAMIE ULRICH DH Approved Date 08/19/2020 Final Approva BOCC Approved YES BOCC Signed Date 08/24/2020 BOCC Agenda Date 08/24/2020 Originator CULLINTA Conunitted Delivery Date Contact Email Finance Approver CHRIS D'OVIDIO Expiration Date 06/30/2020 Contact Phone 1 Purchasing Approved Date Finance Approved Date 08/19/2020 Tyler Ref # 2020-2589 Legal Counsel GABE KALOUSEK Contact Phone 2 Legal Counsel Approved Date 08/19/2020 Hello