The URL can be used to link to this page

Browse Search

Home My WebLink About20212495.tiffPRIVILEGED AND CONFIDENTIAL MEMORANDUM DATE: October 27, 2021 TO: Board of County Commissioners FR: Jamie Ulrich, Director, Human Services RE: Consent Agenda Item Request — Correction to Page #9 for Tyler ID #2021-2495 2020-21 CDLE Grant Closeout Check List Request Board of County Commissioner (BOCC) Chair to Sign Corrected Page for CDLE Grant Closeout Check List. On August 18, 2021 the Board of County Commissioners (BOCC) approved and signed the 2020-21 Workforce Innovation and Opportunity Act (WIOA) Grant Closeout Check List for the Colorado Department of Labor and Employment (CDLE), referenced as Tyler ID 2021-2495. The Department was informed after submission that an incorrect box was checked on page #9 on the original closeout document. Due to this, I am requesting the attached corrected page #9 of the 2020-21 CDLE Grant Close Out Check List be signed by the BOCC Chair for re -submittal to CDLE. Legal (Karin McDougal) has indicated that this item may be a Consent Agenda item for the BOCC Chair signature. Memorandum; October 27, 2021 JD nSO-Y)4 Il/OI/DI ii/oi/ -i Page 1 00.9 i - ati9 H 8009 3 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT SUBRECIPIENT CERTIFICATION OF PHYSICAL INVENTORY Subrecipient Name: Address: Employment Services of Weld County Contact Person: Phone Number: Leonard Bottorff PO Box 1805 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: Li Noted Ll 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. Subrecipient Director's Signature t:31 0 12021 Date Closeout Part 4 Page 1 of 6 ,2402/-031/94' RESOLUTION RE: APPROVE GRANT CLOSEOUT CHECK LIST 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 between 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, and the Colorado Department of Labor and Employment, for all programs that have Expenditure Authorizations ending during the period of July 1, 2020, through June 30, 2021, with further terms and conditions being as stated in said grant closeout check list, and WHEREAS, after review, the Board deems it advisable to approve said grant closeout check list, 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 between 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, and 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 check list. cc: Hs D cg/3o la -I 2021-2495 HR0093 GRANT CLOSEOUT CHECK LIST FOR VARIOUS WORKFORCE INNOVATION AND OPPORTUNITY ACT (WIOA) PROGRAMS PAGE 2 The above and foregoing Resolution was, on motion duly made and seconded, adopted by the following vote on the 18th day of August, A.D., 2021. BOARD OF COUNTY COMMISSIONERS WELD COUNTY, COLORADO ATTEST: dettAvo W j,d 0 4k. Weld County Clerk to the Board BY: County Attorney Date of signature: o' /27/2 Steve Moreno, Chair 2021-2495 HR0093 PRIVILEGED AND CONFIDENTIAL CiOn+t C+ ZO - 51 7 Co MEMORANDUM DATE: August 10, 2021 TO: Board of County Commissioners — Pass -Around FR: Jamie Ulrich, Director, Human Services RE: 2020-21 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' 2020-21 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, 2020 through June 30, 2021. 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 27, 2021. I do not recommend a Work Session. I recommend approval and submission of this Grant Closeout and authorize the Chair to sign. Perry L. Buck Mike Freeman Scott K. James, Pro-Tem Steve Moreno, Chair Lori Saine Approve Schedule Rec. i u n•.= ion Work Session Other/Comments: Pass -Around Memorandum; August 10, 2021 — CMS 5176 Page I 2021-2405 -rzo6G3 eA. C Department of CDLE Labor and Employment Finance: 633 17th Street, Suite 1100, Denver, CO 80202-3660 COLORADO 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: Karina Amaya Phone Number: 970-400-6763 Fiscal Manager: Leonard Bottorff Phone Number: 970-400-6537 Master Grant/Contract Agreement Number: CMS #54599 Final Due Dates: The fourth Friday of August 2021 (Aug 27, 2021). The closeout package without proper signature will not be accepted. Please coordinate with your program liaison if you are unable to spend your NFA allocation. CLOSEOUT SUMMARY CHECKLIST: Please list all the funds from NFA's with the period of performance ending June 30, 2021 (please create an attachment if applicable): Please list all the CLEAR program code by the program year accordingly starting from Py19 to Fy20. Please see the example below: Program Year- CLEAR Program Code CLEAR Program Code Title/Grant Budget Actual FY19 FLC 1649 FOREIGN LABOR CERTIFICATION 6,400.00 6,400.00 PY19 WP 2059 WAGNER PEYSER 90% LOCAL -WP 427,462.00 427,462.00 FY19 RESEA 28C9 RESEA Expenditures - County 11,897.00 11,897.00 FY20 DVOP 2D20 DISABLED VETS OUTREACH PROG 17,384.00 17,384.00 PY19 MSFW 2M59 WP10% MIGRANT SSNL WRKR 47,068.00 47,068.00 PY19 SJH 2S59 WP10% SUMMER JOB HUNT 42,000.00 42,000.00 PY20 ESF 2W21 WFD ESF ONLY -NO CRWC 370,437.00 370,437.00 PY20(SFY21) ESF 2W31 WFD EXTRA ESF FUNDING ONLY -NO CRWC 95,215.00 95,215.00 FY20 ADULT 46A9 WIOA ADULT LOCAL ADMIN 41,412.00 41,412.00 FY20 DW 46D9 WIOA DW ADMIN LOCAL/COUNTIES 32,368.00 32,368.00 If you have any questions or need assistance, please do not hesitate to contact: Laura Urbain (phone 303-318-8106) or email: laura.urbain@state.co.us John Torres (phone 303-318-8107) or email: John.M.Torres@state.co.us Sung Hong (phone: 303-318-8108) or email: 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 o2a02/. 029 COLORADO Department of Labor and Employment •633 17th Street, Suite 1100, Denver, CO 80202-3660 FY20 EDW 47D9 WIOA 25% DW ENHANCED ADMIN 16,819.00 16,819.00 FY20 ADULT 48A9 WIOA ADULT LOCAL PROGRAM 358,301.00 358,301.00 FY20 DW 48D9 WIOA DW PROGRAM LOCAL/COUNTIES 281,945.00 281,945.00 FY20 EDW 49D9 WIOA 25% DW ENHANCED PROG 97,277.00 97,277.00 PY19 ADULT 4A69 WIOA ADULT LOCAL ADMIN 7,768.00 7,768.00 PY19 ADULT 4A89 WIOA ADULT LOCAL PROGRAM 69,913.00 69,913.00 PY19 DW 4D69 WIOA DW LOCAL ADMIN 6,822.00 6,822.00 PY19 DW 4D89 WIOA DW LOCAL PROGRAM 61,399.00 61,399.00 FY20 ADULT 4VA9 WIOA COVID19-ADULT LOCAL ADM IN 14,413.00 14,413.00 FY20 DW 4VD9 WIOA COVID19-DW ADMIN LOCAL 9,368.00 9,368.00 FY19 PIF 4WD8 WIOA 10% DW CWDC COUNCIL 45,712.00 45,712.00 FY20 PIF 4WD9 WIOA CWDC- 10% DW COUNCIL 10,000.00 10,000.00 PY19 YOUTH 4Y69 WIOA 10% YOUTH LOCAL ADMIN 57,544.00 57,544.00 PY19 YOS 4Y79 WIOA YOUTH MIN -75% -OUT -SCHOOL LOCAL 390,126.00 390,126.00 PY19 YIS 4Y89 WIOA YOUTH MAX -25% -IN -SCHOOL LOCAL 129,474.00 129,474.00 PY18 BD DEV 4YW8 10%YOUTH CWDC COUNCIL 42,500.00 42,500.00 PY19 PIF 4YW9 WIOA CWDC-10%YOUTH COUNCIL 29,268.00 29,268.00 Total 2,720,292.00 2,720,292.00 I. ESF funds and WFD EXTRA ESF FUNDING (CLEAR PROGRAM CODE 2W21 + 2W31) must be invoiced to CDLE by July 7th, 2021 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. No physical inentory purchased for the following grants: PY19-FY20 WIOA-ADULT, DW, YOUTH. If you have any questions or need assistance, please do not hesitate to contact: Laura Urbain (phone 303-318-8106) or email: laura.urbain@state.co.us John Torres (phone 303-318-8107) or email: John.M.Torres@state.co.us Sung Hong (phone: 303-318-8108) or email: SunR.HonR@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 C at Department of cope Labor and Employment Finance: 633 17th Street, Suite 1100, Denver, CO 80202-3660 COLORADO 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 2021; Report Type - PJTD) 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: ACCT-PGL-FIN-2019-08 Subrecipient- Financial -Procedures-attach-02-Closeout PackaQe.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 -recipients 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 4th 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. By: Steve Moreno Date Title: Chair, Board of Weld County Commissioners Steve Moreno, Chair BOCC AUG 1 8 2021 If you have any questions or need assistance, please do not hesitate to contact: Laura Urbain (phone 303-318-8106) or email: laura.urbain@state.co.us John Torres (phone 303-318-8107) or email: John.M.Torres@state.co.us Sung Hong (phone: 303-318-8108) or email: 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 oZoar-avii‘ Part 1 Page 1 of 2 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,2021 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 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 CERTIFICATION: I certify to the best of my knowledge and belief the above reported information is accurate and complete for the period reported. AUG 1 8 2021 Authorized Signature Date See instructions for completing this form on the next tab (Attachment E 2 of 2) otb.2/-.2O5- V 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 Canty Incurred During Program Year Ended: June 30, 2021 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 PY20 PY19 FY18 0.00 0.00 0.00 GRANT NAME WIOA Dislocated Workers Current Prior Year Before Prior FY20 FY19 FY18 0.00 0.00 0.00 GRANT NAME WIOA Youth Current Prior Year Before Prior FY20 PY19 PY18 GRANT NAME WIOA 10% Statewide Actv. 0.00 0.00 0.00 Current Prior Year Before Prior PY20 PY19 PY18 0.00 0.00 0.00 GRANT NAME WIOA Local Admin. Current Prior Year Before Prior PY20 PY19 PY18 0.00 0.00 0.00 GRANT NAME WIOA 25% Enh. DWAdmir Current Prior Year Before Prior PY20 PY19 PY18 0.00 0.00 0.00 GRANT NAME WIOA 25% Enh. DW Program Current Prior Year Before Prior PY20 PY19 PY18 0.00 0.00 0.00 GRANT NAME WIOA 25% lnnovaty. Proj. Current Prior Year Before Prior PY20 PY19 PY18 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 1 8 2021 Date 3 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, 2021 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 PY20 PY19 PY18 0.00 0.00 0.00 GRANT NAME WP 10% SJH Current Prior Year Before Prior PY20 PY19 PY18 0.00 0.00 0.00 GRANT NAME Vets DVOP Current Prior Year Before Prior PY20 PY19 PY18 0.00 0.00 0.00 GRANT NAME Vets LVER Current Prior Year Before Prior PY20 PY19 PY18 0.00 0.00 0.00 GRANT NAME UI Reemp/oyement Svc Current Prior Year Before Prior PY20 PY19 PY18 0.00 0.00 0.00 GRANT NAME Unemployment Ins. Current Prior Year Before Prior PY20 PY19 PY18 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 See instructions for completing this form on the next tab (Attachment F 3 of 3) AUG 18 2021 Date ,2,Ot1- 4- COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT EMPLOYMENT AND TRAINING PROGRAMS Closeout Part 1 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. 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. Closeout Part 2 Page 3 of 3 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 Part 4 Page 1 of 6 SUBRECIPIENT CERTIFICATION OF PHYSICAL INVENTORY Subrecipient Name: Address: Employment Services of Weld County Contact Person: Phone Number: Leonard Bottorff PO Box 1805 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: o Noted ❑ 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. Subrecipient Director's Signature /.*: 02002./ Date 07.o6.21—asiq� 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 : 1649 2059 2D20 2M59 CMS #54599 , including the 28C9 2S59 2W21 2W31 46A9 46D9 47D9 49D9 4A69 4A89 4VA9 4VD9 4WD8 4Y79 4Y89 48A9 48D9 4D69 4D89 4WD9 4Y69 4YW8 4YW9 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 day of , 2021. Closeout Part 4 Page 2 of 6 o2.oav 024-96 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)ANorkplan awarded under Agreement, identified as CLEAR Program code(s) : 2D20 2M59 46A9 46D9 1649 2S59 47D9 49D9 4A69 4A89 4VA9 4VD9 4WD8 4Y79 4Y89 4YW8 2059 CMS #54599 , including the 2W21 48A9 4D69 4WD9 4YW9 28C9 2W31 48D9 4D89 4Y69 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 Autho i ed Signature Steve Moreno, Chair, Board of Title Weld County Commissioners , 2021. Closeout Part 4 Page 3 of 6 ado/-o2(k9a 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 / day of By , 2021. Authorized Signature Steve Moreno, Chair, Board of Title Weld County Commissioners Closeout Part 4 Page 4 of 6 ..2oa,_a419' 7 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT GRANT RECIPIENTS 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): 2059 28C9 2D20 2M59 46A9 46D9 47D9 4A89 4O69 4Y69 4Y79 4Y89 and in consideration of the sum of Total amount paid of CMS #54599 , including the Expenditure 1649 2S59 2W21 2W31 48A9 48D9 4D89 4VA9 4VD9 4YW8 4YW9 $2,720,292.00 49D9 4A69 4WD8 4WD9 $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 daims 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 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 Unemployment Insurance costs under a reimbursej�ent system or to settle Workers Compensation claims. /fr , 2021. Authorized Signature Title Steve Moreno, BOCC Chair Closeout Part 4 Page 5 of 6 old,1/'a//1 8 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT PHYSICAL INVENTORY LIST Grant Recipient Name: Employment Services of Weld County WDP Master Agreement Number: CMS #54599 Release Date: Closeout Part 4 Page 6 of 6 CLEAR Program code Purchase Date Description of Property Property Costs Program Funding Sources SERIAL # if applicable Property Location Property Condition No physical inventory purchased tor FY19 FLC, RESEA, PIF No physical inventory purchased -for PY19 WAGNER PEYSER No physical inventory purchased -tor FY20 DVOP No physical inventory purchased -for PY19 MSFW, SJH, PIF No physical inventory purchased -tor FY21 EMPLOYMENT SUPPORT FUND No physical inventory purchased -for FY20 WIOA ADULT, DW, EDW No physical inventory purchased -for PY19 WIOA ADULT, DW, YOUTH No physical inventory purchased for PY18 BD DEV 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 By Title Authorized Signature day of Steve Moreno, BOCC Chair 2021 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) 17C0000000 FY20-NON-WIOA-TAA CASE MANAGEMENT Not Used(0000) 35,187.00 0 35,187.00 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) 65,977.00 20,007.09 45,969.91 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) 2050000000 PY20-WP COUNTY ALLOCATION Not Used(0000) 470,496.00 0 470,496.00 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 207,215.46 220,246.54 Not Used(0000) 2007000000 FFY17-DISABLED VETS OUTREACH PROG Not Used(0000) 7,000.00 7,000.00 0 Not Used(0000) 2008000000 FFY18-DISABLED VETS OUTREACH PROG Not Used(0000) 17,384.00 17,384.00 0 Not Used(0000) 2009000000 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) 28C0000000 RESEA Expenditures - County Not Used(0000) 35,000.00 0 35,000.00 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) 2020000000 FFY2020-DISABLED VETS OUTREACH PROG Not Used(0000) 17,384.00 0 17,384.00 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) 2M59000000 PY19-WP10% MIGRANT SSNL WRKR-COUNTY ONLY Not Used(0000) 47,068.00 0 47,068.00 Not Used(0000) 2554000000 PYl4-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) 2557000000 PY17-P10%SUMMER JOB HUNT Not Used(0000) 40,000.00 40,000.00 0 Not Used(0000) 2558000000 PY18-WP10% SUMMER JOB HUNT Not Used(0000) 40,000.00 40,000.00 0 Not Used(0000) 2559000000 PY19-WP10% SUMMER JOB HUNT Not Used(0000) 42,000.00 22,140.85 19,859.15 Not Used(0000) 2W20000000 ESF-SFY20 WFD ESF ONLY -NO CRWC Not Used(0000) 340,697.00 340,697.00 0 Not Used(0000) 2W21000000 ESF-SFY21 WFD ESF ONLY -NO CRWC Not Used(0000) 370,437.00 0 370,437.00 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) 2W26000000 ESF-SFY16-WFD ESF ONLY -NO CRWC Not Used(0000) 413,682.00 413,682.00 0 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) 2W31000000 ESF-SFY21 WFD EXTRA ESF FUNDING ONLY -NO CRWC Not Used(0000) 95,215.00 0 95,215.00 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) 46O4000000 FY15 - WIA DW LOCAL ADMIN Not Used(0000) 10,010.36 10,010.36 0 Not Used(0000) 4605000000 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) 46O7000000 FY18 -DW- DW ADMIN LOCAL/COUNTIES Not Used(0000) 21,411.00 21,411.00 0 Not Used(0000) 4608000000 FY19- WIOA OW- OW ADMIN LOCAL/COUNTIES Not Used(0000) 19,000.00 19,000.00 0 Not Used(0000) 46O9000000 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) 4708000000 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 222,802.05 149,911.95 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 165,806.49 125,506.51 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 61,832.64 40,854.36 Not Used(0000) 4A60000000 PY20 - WIOA ADULT LOCAL ADMIN Not Used(0000) 7,601.00 0 7,601.00 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) 4A80000000 PY20 - WIOA ADULT LOCAL PROGRAM Not Used(0000) 68,410.00 0 68,410.00 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 WFD Regional Budget Report Period: Jul -20 Report Type: PJTO Entity: 5230 Unit Program Program Description Activity Budget Amount Actual Amount Balance Not Used(0000) 4805000000 FY16 - WIOA DW-LOCAL ADMIN TRANSFER ADULT Not Used(0000) 6,983.10 6,983.10 0 Not Used(0000) 4807000000 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) 4060000000 PY20 - WIOA DW LOCAL/COUNTIES ADMIN Not Used(0000) 7,490.00 0 7,490.00 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) 4080000000 PY20- WIOA DW LOCAL/COUNTIES PROGRAM Not Used(0000) 67,415.00 0 67,415.00 Not Used(0000) 4087000000 PY17 - WIOA DW PROGRAM COUNTY Not Used(0000) 35,261.00 35,261.00 0 Not Used(0000) 4088000000 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) 4085000000 PY15 - WIOA LOCAL ADMIN TRANSFER ADULT Not Used(0000) 3,317.00 3,317.00 0 Not Used(0000) 40B7000000 PY17 - WIOA DW 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) 4F05000000 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-LOCAL Admin 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 OW-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-ADMIN TO LOCAL Not Used(0000) 21,374.00 21,374.00 0 Not Used(0000) 4RA5000000 FY16 - WIOA WFD 5%- ADULT EVALU & CONTIN IMPR 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) 4Y60000000 PY20 - WIOA 10%YOUTH LOCAL ADMIN Not Used(0000) 51,500.00 0 51,500.00 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) 4Y65000000 PY15 - WIOA 10% YOUTH LOCAL ADMIN Not Used(0000) 61,808.92 61,808.92 0 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) 4Y70000000 PY20 - WIOA YOUTH MIN -75% -OUT -SCHOOL LOCAL PROGRAM Not Used(0000) 347,642.00 0 347,642.00 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 -SCHOOL 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 295,751.89 94,374.11 Not Used(0000) 4Y79000000 PY19 - WIOA YOUTH MIN -75% -OUT -SCHOOL LOCAL PROGRAM YOUTH -20% -OUT -SCHOOL -WORK EXPERIENCE(8100) 0 58,377.41 -58,377.41 Not Used(0000) 4Y80000000 PY20 - WIOA YOUTH MAX -25% -IN -SCHOOL LOCAL PROGRAM Not Used(0000) 115,880.00 0 115,880.00 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 20,380.65 109,093.35 Not Used(0000) 4Y89000000 PY19 - WIOA YOUTH MAX -25% -IN -SCHOOL LOCAL PROGRAM YOUTH -20% -IN -SCHOOL -WORK EXPERIENCE(8200) 0 33,500.17 -33,500.17 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 13,506,071.54 11,037,670.57 2,468,400.97 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/2019 YEAR OF FUNDS Page 1 of 2 FY19 TITLE/PROGRAM/PROJECT FOREIGN LABOR CERTIFICATION CLEAR Program code 1649000000 END DATE END DATE 9/30/2020 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 6,400.00 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date 6,400.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 6,400.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 6,400.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 6,400.00 2. FINAL Expenses Through End of Contract 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) 6,400.00 Yes ID /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 6,400.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 Date j>/SS�� 2/ Authorized Signature 4., �. � � / � '-'U'�� Date A 1 20�� See instruction for completing this for on the next tab (Attachment H 2 of 2) c202 -1-a 4'9 /a 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+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. °Period Balances ('JTO) Jun -21 Account '5230.0000.6500.1649000000.0000.000000001 Period Oct -19 Nov -19 Dec -19 Jan -20 Feb -20 Mar -20 Apr -20 May -20 Adj-20 Funds Available ( Detail Balances ) Budget 6400.00 0.00 0.00 0.00'', 0.00', 0.00 0.00 0.00`. Encumbrance 0.00; 0.00 0.00 0.00' 0.00 0.00 0.00! 0.00 0.00 Actual Funds Available 0.00 6400.00 0.00 0.00 0.00 0.00 0.00 0.00 3760.68 -3760.68 1557.75' -1557.75 536.14 -536.14 239.98 -239.98 305.45 -305.45 0.00 0.00 6400.00 0.00 6400.00 0.00 CLEAR WIOA Reconciliation-FV19 FOREIGN LABOR CERTIFICATION Reporting Month Program Code Tracking Sheet CLEAR Received Date Received Grant Balance July -19 1649000000 6,400.00 August -19 1649000000 6,400.00 September -19 1649000000 6,400.00 October -19 1649000000 6,400.00 November -19 1649000000 898.74 6,400.00 December -19 1649000000 436.77 6,400.00 December -19 "B" 1649000000 165.14 6,400.00 January -20 1649000000 1,327.25 6,400.00 February -20 1649000000 932.78 3,760.68 3,760.68 4/23/2020 2,639.32 March -20 1649000000 1,557.75 1,557.75 1,557.75 5/6/2020 1,081.57 April -20 1649000000 536.14 536.14 536.14 6/20/2020 545.43 May -20 1649000000 239.98 239.98 239.98 7/10/2020 305.45 June -20 1649000000 305.45 305.45 305.45 8/4/2020 - Totals 6,400.00 6,400.00 6,400.00 1649000000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 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/W0RKPLAN START DATE PROGRAM INCOME START DATE 7/1/2019 YEAR OF FUNDS TITLE/PROGRAM/PROJECT CLEAR Program code Page 1 of 2 PY19 WAGNER PEYSER 2059000000 END DATE END DATE 6/30/2021 1. CASH REQUEST , 1. Total program and Admin Cash needs Previously Reported 427,462.00 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date 427,462.00 I1. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 427,462.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 427,462.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 427,462.00 2. FINAL Expenses Through End of Contract 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) 427,462.00 Yes G /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 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 % i'.a�. 1. FINAL Match Reported Through End of Contract 0.00 2. FINAL Expenses Through End of Contract 427,462.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 D '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 g/s'H Authorized Signature 8 Date AUGS 1 2021 See instruction for completing this for on the next tab (Attachment H 2 of 2) 020.21- f,Z 495- °Period:Balancep Account PJT) Jun 21 5230.0000.6500.2059000000.0000.00000000( Funds Available ( Detail Balances ) Period Dec -18 ,Jan -19 Feb -19 Mar -19 Apr -19 ............ ,May -19 Jun -19 Adj-19 Jul -19 Budget 0.00_ 0.00 0.00 0.00 0.00 0.00! .. 0.00 0.00 427462.00', 0.00 427462.00 e©a Encumbrance 0.00 0.00 0.00 0.00 r 0.00 o.00 ... .__ 0.00 0.00, 0.00 0.00 Actual Funds Available 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.00 0.00 0.00 0.00 0,00'! 427462.00 0.00 0.00 .; 0.00 427462.00! 0.00 'Period Balances (PJTD) - Jun -21 Account ;5230.0000.6500.2059000000.0000.000000001 Period ;Sep -19 Oct -19 Nov -19 'Dec -19 ........... Jan -20 Feb -20 ........... Mar -20 Apr -20 ,May -20 'Jun -20 Funds Available ( Detail Balances ) Budget 0.00 0.00 0.00 0.001 0.00 0.00 0.00'. 0.00; 0.00 0.00 427462.00 Encumbrance 0.00 0.00 0.00: 0.00' 0.00 0.00' 0.00', 0.00 0.00. 0.00 Actual Funds Available 0.00 0.00'= 0.00 0.00 3284.95 -3284.95 82572.74 -82572.74 68145.39 -68145.39 13354.85 -13354.85 5474.48 -5474.48 -18857.94, 18857.94 3927.15 -3927.15 38881.61' -38881.61 0.00 427462.00 0.00 Cancel °Period 81 Account Period Adj-20 Jul -20 ;Aug -20 Sep -20 Oct -20 Nov -20 Dec -20 Jan -21 :Feb -21 Mar -21 kED),., ,Jun -21, ,v.. 5230.0000.6500.2059000000.0000.000000001 Funds Available ( Detail Balances ) Budget Encumbrance 0.00 0.00', 0.001 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.00'. 0.00 0.00 0.00 0.00, 427462.00 ` 0.00 Cancel Actual Funds Available 0.00 0.00 10432.23 -10432.23 14929.62 -14929.62 35058.07 -35058.07 43301.25 -43301.25 22861.69 -22861.6 53962.87 -53962.87 44655.59 -44655.59 5477.45 -5477.45 0.00 0.00, 427462.00 0.00, CLEAR WIOA Reconciliation-PY19 WAGNER PEYSER 90% LOCAL -WP Reporting Month Program Code Tracking Sheet CLEAR Received Date Received Grant Balance July -19 2059000000 427,462.00 August -19 2059000000 427,462.00 September -19 2059000000 427,462.00 October -19 2059000000 427,462.00 November -19 2059000000 3,284.95 3,284.95 3,284.95 1/13/2020 424,177.05 December -19 2059000000 82,572.74 82,572.74 82,572.74 2/5/2020 341,604.31 December -19 "B" 2059000000 56,384.05 341,604.31 January -20 2059000000 11,761.34 68,145.39 68,145.39 3/6/2020 273,458.92 February -20 2059000000 13,354.85 13,354.85 13,354.85 4/23/2020 260,104.07 March -20 2059000000 5,474.48 5,474.48 5,474.48 5/6/2020 254,629.59 April -20 2059000000 (18,857.94) (18,857.94) (18,857.94) 6/20/2020 273,487.53 May -20 2059000000 3,927.15 3,927.15 3,927.15 7/10/2020 269,560.38 June -20 2059000000 38,881.61 38,881.61 38,881.61 8/4/2020 230,678.77 July -20 2059000000 10,432.23 10,432.23 10,432.23 9/8/2020 220,246.54 August -20 2059000000 14,929.62 14,929.62 14,929.62 10/8/2020 205,316.92 September -20 2059000000 35,058.07 T 35,058.07 35,058.07 11/10/2020 170,258.85 October -20 2059000000 43,301.25 I 43,301.25 43,301.25 I 12/10/2020 126,957.60 November -20 2059000000 22,861.69 22,861.69 22,861.69 1/8/2021 I 104,095.91 December -20 2059000000 53,962.87 53,962.87 53,962.87 2/1/2021 50,133.04 December -20 "B" 2059000000 1,399.61 50,133.04 January -21 2059000000 43,255.98 44,655.59 44,655.59 3/12/2021 5,477.45 February -21 2059000000 5,477.45 5,477.45 5,477.45 4/13/2021 (0.00) March -21 2059000000 (0.00) Totals 427,462.00 427,462.00 427,462.00 , 2059000000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 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 4/1/2019 YEAR OF FUNDS TITLE/PROGRAM/PROJECT CLEAR Program code Page 1 of 2 FY19 RESEA 28C9000000 END DATE END DATE 9/30/2020 I. CASH REQUEST 1. Total program and Admin Cash needs Previously Reported 11,897.00 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date 11,897.00 I1. PROGRAM EXPENSE REPORT (ER) il,r. _ 1. Total Expenses+Accruals Previously Reported (Through Last Month) 11,897.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 11,897.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,897.00 2. FINAL Expenses Through End of Contract 11,897.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 (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 11,897.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 Date 313 /2—) Authorized Signature Date AUG 181021 See instruction for completing this for on the next tab (Attachment H 2 of 2) 0245621-a e19 /7' °PeriodBellent Account 5230.0000.6500.28C9000000.0000.00000000 Funds Available ( Detail Balances ) Mar -19 ,11Apr-19 ,May -19 Jun -19 Adj-19__ 1Jul-19 Aug -19 Sep -19 Oct -19 Nov -19 11897.00 0.00 0.00 0.00 0.00 0.001 0.00; 0.00; 0.00' Encumbrance 0.00` 0.001 0.00, 0.00 0.00 0.00 0.00i 000; 0.001 0.001 11897.00'', 0.00''. Actual Funds Available 0.00 0.00 0.00; 11897.00 0.00 : 0.00 0.00 0.00 0.00 0.00 6600.00 -6600.00 3733.20 -3733.20 1563.80! -1563.80 0.00 0.00 0.00 0.00 11897.00'' 0.00 CLEAR WIOA Reconciliation-FY19 RESEA Expenditures - County Reporting Month Program Code Tracking Sheet CLEAR Received I Date Received Grant Balance March -19 28C9000000 I 11,897.00 April -19 28C9000000 3,962.00 11,897.00 May -19 28C9000000 1,540.00 11,897.00 June -19 28C9000000 11,897.00 July -19 28C9000000 1,098.00 6,600.00 6,600.00 9/5/2019 5,297.00 August -19 28C9000000 3,733.20 3,733.20 3,733.20 10/2/2019 1,563.80 September -19 28C9000000 1,563.80 1,563.80 1,563.801 11/8/2019 - October -19 28C9000000 - November -19 28C9000000 - December -19 28C9000000 - Totals 11,897.00 11,897.00 11,897.00 28C9000000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 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 10/1/2019 YEAR OF FUNDS Closeout Part 3 Page 1 of 2 FY20 TITLE/PROGRAM/PROJECT DISABLED VETS OUTREACH PROG CLEAR Program code 2D20000000 END DATE END DATE 12/31/2020 I. CASH REQUEST< 1. Total program and Admin Cash needs Previously Reported 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date 17,384.00 17,384.00 II. PROGRAM EXPENSE REPORT (ER)u 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) ,, __ 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 0 /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 ;,c,tMp'anP " 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 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/ j/ / 1 Date 5 (rit 1 Authorized Signature Date AUG 1 8 2021 See instruction for completing this for on the next tab (Attachment H 2 of 2) ,zf-a 5 /3 °Pent Bat at et (ND)-Jt 1 Period 'Sep -19 'Oct -19 Nov -19 Dec -19 Jan -20 .Feb -20 €Mar -20 iApr-20 ;May -20 I 5230.0000.6500.2 D20000000, 0000.00000000 Funds Available ( Detail Balances ) Budget 0.001 17384.00; 0.00 0.00; 0.00'; 0.001 0.001 0.00 0.001 0.00. 17384.00 Encumbrance 0.00 0.00! 0.00? 0.00 0.00 0.00. 0.00: 0 00 0.00 0.00 0.00', Actual 0.00' 0.00 0.00 0.00 0.00, 0.00 0.00 0.00 ..-.. 0.00 0.00 17384.00', Funds Available ........ ................ 0.00: 17384.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00. 0.00 ° eriod Account ,5230.0000.6500.2D20000000.0000.00000000 Period Jul -20 ;Aug -20 'Sep -20 ;Oct -20 INov-20 1Dec-20 IJan-21 ,Feb -21 '.Mar -21 Funds Available ( Detail Balances ) Budget 0.00', 0.00: 0.00 000' 0.001 0.00; 0.00' 0.00; 0.00; 0.00! 17384.00 Encumbrance 0.00 0.00 0.00. 0.00 0.00; 0.001 0.00: 0.001 0.00'. 0.00 Actual Funds Available 0.00 0.00' 0.00 11589.36 -11589.36 1448.66 -1448.66 1448.66 -1448.66 2897.32 -2897.32 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 . 0.001 17384.00 0.00 CLEAR WIOA Reconciliation-FY20 DISABLED VETS OUTREACH PROG Reporting Month Program Code Tracking Sheet CLEAR Received Date Received Grant Balance October -19 2D20000000 17,384.00 November -19 2D20000000 17,384.00 December -19 2D20000000 17,384.00 January -20 2D20000000 17,384.00 February -20 2D20000000 17,384.00 March -20 2D20000000 17,384.00 April -20 2D20000000 17,384.00 May -20 2D20000000 8,692.00 17,384.00 June -20 2D20000000 17,384.00 July -20 2D20000000 1,448.70 17,384.00 August -20 2D20000000 1,448.66 11,589.36 11,589.36 10/8/2020 5,794.64 September -20 2D20000000 1,448.66 1,448.66 1,448.66 11/10/2020 4,345.98 October -20 2D20000000 1,448.66 1,448.66 1,448.66 12/10/2020 2,897.32 November -20 2D20000000 2,897.32 2,897.32 2,897.32 1/8/2021 - December -20 2D20000000 - Totals 17,384.00 17,384.00 17,384.00 2D20000000 General ledger vs bullied 0.00 Billed not received 0.00 General ledger vs. received 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 6/17/2020 YEAR OF FUNDS Closeout Part 3 Page 1 of 2 PY19 TITLE/PROGRAM/PROJECT WP10°/0 MIGRANT SSNL WRKR CLEAR Program code 2M59000000 END DATE END DATE 6/30/2021 I. CASH REQUEST �Lirn^ r 1. Total program and Admin Cash needs Previously Reported 47,068.00 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date 47,068.00 11. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 47,068.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 47,068.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 z� �� ;fi( 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 "If 0141 1. FINAL Cash Request Contract to Date 47,068.00 2, FINAL Expenses Through End of Contract 47,068.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 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 47,068.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 a4d Date �(A �-//t► ../.. Authorized Signature "--L-P--)"'e7" Date AUG 8 1 2021 See instruction for completing this for on the next tab (Attachment H 2 of 2) o2ao2i- O2 V49- 1+ °eri -221,x. Account 5230.0000.6500.2M59000000.0000.0000000C Funds Available ( Detail Balances ) Period Budget 0.00: -Jan-20 Feb -20 Mar -20 Apr -20 May -20 Jun -20 Adj-20 Jul -20 Aug -20 {period ea,as be ° i TD) �! 0.00; 0.00 0.00. 0.00' 0.00E 47068.00; 0.00_ 0.00 0.00i 47068.00 Encumbrance 0.00 0.00 0.00- 0.00: 0.00: 0.00- 0.00 0.00; 0.001 0.00 0.00 Account ;5230.0000.6500.2M59000000.0000.0000000C Period C0ct-20 Nov -20 Dec -20 Jan -21 Feb -21 • 'Mar -21 'Apr -21 May -21 ,Jun -21 Funds Available ( Detail Balances ) Budget Encumbrance Actual Funds Available 0.00 0.00! 4702.30; -4702.301'. Actual Funds Available 0.00 0.00 0.00 0.00 0.00 i 0.00 0.00 0.00 0.00 ! 0.00 0.00 0.00 0.00 47068.00 0.00 0.00 0.00 4376.81 47068.00 0.00 -4376.81 Cancel 0.00 0.00 0.00 0.00; 0.00: 0.00[ 0.00 0.00 0.00- 0.00 47068.00 0.00 000; 0.00' 0.00 0.00[ 0.00; 000; D.00 0.00. 0.00 47068.00 4181.89 -4181.89 :r 2017.60 -2017.60 2538 05; -2538.05 1464.01 -1464.01 5858.28 -5858.28 4109.86 -4109.86 7894.32 -7894.32.x, 6597.49 -6597.49 3327.39 3327.39. 0.00 Cancel CLEAR WIOA Reconciliation-PY19 WP10% MIGRANT SSNL WRKR Reporting Month Program Code Tracking Sheet CLEAR Received Date Received Grant Balance June -20 2M59000000 47,068.00 July -20 2M59000000 751.90 47,068.00 August -20 2M59000000 3,624.91 4,376.81 4,376.81 10/8/2020 42,691.19 September -20 2M59000000 4,702.30 4,702.30 4,702.30 11/10/2020 37,988.89 October -20 2M59000000 4,181.89 4,181.89 4,181.89 12/10/2020 33,807.00 November -20 2M59000000 2,017.60 2,017.60 2,017.60 1/8/2021 31,789.40 December -20 2M59000000 2,538.05 2,538.05 2,538.05 2/1/2021 29,251.35 12/1/2020 "B" 2M59000000 48.85 29,251.35 January -21 2M59000000 1,415.16 1,464.01 1,464.01 3/12/2021 27,787.34 February -21 2M59000000 5,858.28 5,858.28 5,858.28 4/13/2021 21,929.06 March -21 2M59000000 4,109.86 4,109.86 4,109.86 5/10/2021 17,819.20 April -21 2M59000000 7,894.32 7,894.32 7,894.32 6/14/2021 9,924.88 May -21 2M59000000 6,597.49 6,597.49 6,597.49 7/8/2021 3,327.39 June -21 2M59000000 3,327.39 3,327.39 0.00 Totals 47,068.00 47,068.00 43,740.61 2M59000000 General ledger vs billied 0.00 Billed not received I 3,327.39 General ledger vs. received 3,327.39 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 1/2/2020 YEAR OF FUNDS TITLE/PROGRAM/PROJECT CLEAR Program code Page 1 of 2 PY19 WP10% SUMMER JOB HUNT 2S59000000 END DATE END DATE 12/31/2020 I. CASH REQUEST 1. Total program and Admin Cash needs Previously Reported 42,000.00 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date 42,000.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 42,000.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 42,000.00 ADMINISTRATIVE EXPENSE (ER) I r �l t 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 y P;l" 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 42,000.00 2. FINAL Expenses Through End of Contract 42,000.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes R /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 iii' q,}��_. 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 v' q ` N11+t 1. FINAL Match Reported Through End of Contract 0.00 2. FINAL Expenses Through End of Contract 42,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 0 /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/Z' Date S(A hi Authorized Signature Date ' AUG 1 8 2021 See instruction for completing this for on the next tab (Attachment H 2 of 2) 02/ -.2(11 Period !Nov -19 Dec -19 Jan -20• �� jFeb-20 Mar -20 Apr -20 May -20 Jun -20 Adj-20 Jul -20 ' erIod, ata °Penod.Belem Account '5230.0000.6500.2S59000000.0000.00000000 Funds Available ( Detail Balances ) Budget 0.00 0.00_ 42000.00 0.00! 0.00 !� 0.00 0.00: 0.00! 0.00 0.00i 42000.00., Encumbrance 0.00' 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Actual Funds Available 0.00 0.00. 0.00 0.00 882.57 6023.16 7835.89 1394.35 356.09 0.00 1360.48 41117.43 -6023.16 -7835.89 -4288.31 -1394.35 -356.09 0.00 -1360.48 0.00 42000.00 0.00 Cancel Account 5230.0000.6500.2559000000.0000.00000000 Period Aug -20 :Sep -20 Oct -20 `Nov -20 -Dec-20 Jan -21. Feb -21 Mar -21 Apr -21 May -21 Funds Available ( Detail Balances Budget 0.00 0.00 0.00- 0.00;. 0.00! 000! ............. 0.00` ............. 0.00 0.00 0.00 42000.00 Encumbrance 0.00 0.00; 000 0.001 0.00 0.00 0.00; 0.00 0.00 0.00 0.00[ Actual 8038.46 7254.76 2273.48! 0.00! 0.00 0.00` 0.00 _ . 0.00,_ ... 0.00! 42000.00; Funds Available -2292.45 ........... -8038.46 -7254.76 -2273.48 0.00 0.00 0.00 0.00 0.00 0.00 Cancel 0.00 CLEAR WIOA Reconciliation-PY19 WP10% SUMMER JOB HUNT Reporting Month Program Code Tracking Sheet CLEAR Received Date Received Grant Balance January -20 2S59000000 42,000.00 January -20 2559000000 882.57 882.57 882.57 3/6/2020 41,117.43 February -20 2S59000000 6,023.16 6,023.16 6,023.16 4/23/2020 35,094.27 March -20 2S59000000 7,835.89 7,835.89 7,835.89 5/6/2020 27,258.38 April -20 2S59000000 4,288.31 4,288.31 4,288.31 6/20/2020 22,970.07 May -20 2S59000000 1,394.35 1,394.35 1,394.35 7/10/2020 21,575.72 June -20 2S59000000 356.09 356.09 356.09 8/4/2020 21,219.63 July -20 2S59000000 1,360.48 1,360.48 1,360.48 9/8/2020 19,859.15 August -20 2S59000000 2,292.45 2,292.45 2,292.45 10/8/2020 17,566.70 September -20 2S59000000 8,038.46 8,038.46 8,038.46 11/10/2020 9,528.24 October -20 2S59000000 7,254.76 7,254.76 7,254.76 12/10/2020 2,273.48 November -20 2S59000000 2,273.48 2,273.48 2,273.48 1/8/2021 0.00 December -20 2559000000 0.00 Totals 42,000.00 42,000.00 42,000.00 2559000000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 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 7/1/2020 YEAR OF FUNDS TITLE/PROGRAM/PROJECT CLEAR Program code Page 1 of 2 PY20 WFD ESF ONLY -NO CRWC 2W21000000 END DATE END DATE 6/30/2021 I. CASH REQUEST 1. Total program and Admin Cash needs Previously Reported 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date '!1ia'�:"��°. 370,437.00 370,437.00 II. PROGRAM EXPENSE REPORT (ER) a . . 1. Total Expenses+Accruals Previously Reported (Through Last Month) 370,437.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 370,437.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 y,,; 1. FINAL Cash Request Contract to Date 370,437.00 2. FINAL Expenses Through End of Contract 370,437.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes 0 /No 0 V. CASH REQUEST PROGRAM INCOME CASH REPORTED _tir 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 Contract to Date 0.00 VI. RECONCILIATION d..A )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 VII. MATCH RECONCILIATION .4 mod) 1. FINAL Match Reported Through End of Contract 0.00 2. FINAL Expenses Through End of Contract 370,437.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 J /:" Authorized Signature G Date + AUGUG 1 2021 See instruction for completing this for on the next tab (Attachment H 2 of 2) oD2I-.910 j4' Account ;5230.0000.6500.2W21000000.0000.0000000( Period Dec -19 Jan -20 Feb -20 Mar -20 Apr -20 May -20 'Jun -20 Adj-20 Jul -20 Funds Available ( Detail Balances ) Budget Encumbrance 1- 0.001 0.001 0.001 0.001 0.001 0.00 000E 0.001 0.001 0.00 0.001 370437.001 0.00 370437.00 0.00 0.001 0.00; 0.00` 0.00; 0.00 0.001 0.00 Actual 0.001 0.00 0.001 0.00 0.00 0.00: 0.001. 0.00 0.00 0.00 Funds Available 0.00 A.. 0.00 0.00 0.00 0.00 0.00 0.00 370437.00 0.00 W" C' ertod'.Bal Account 5230.0000.6500.2W21000000.0000.0000000( Funds Available ( Detail Balances ) Period `Oct -20 Nov -20 1Dec-20 Jan -21 Feb -21 Mar -21..._.. Apr -21 !May -21 ,Jun -21 Budget 0.001 0.00 0.00 0.00' 0.00 0.00 0.00` 0.00,. 0.001 0.00 370437.00 Encumbrance 0.001 0.001 0.001 0.001 0.001 0.00; 0.001 0.00 0.00. 0.00a 0.00; Actual 0.00 95547.54 29737.07 48951.65 20552.08 35183.96, 38155.32 48475.69 25017.46; 28816.23 370437.001 Funds Available 95547.54 -29737.07 -48951.65" -20552.08 -35183.96 -38155.32 -48475.69 -25017,46 28816.23 Cancel 0.00 CLEAR W1OA Reconciliation-PY20 WFD ESF ONLY -NO CRWC Reporting Month Program Code Tracking Sheet CLEAR Received Date Received Grant Balance July -20 2W21000000 370,437.00 July -20 2W21000000 4,297.02 370,437.00 August -20 2W2 1000000 26,770.55 370,437.00 September -20 2W21000000 27,212.50 370,437.00 October -20 2W21000000 37,267.47 95,547.54 95,547.54 12/10/2020 274,889.46 November -20 2W21000000 29,737.07 29,737.07 29,737.07 1/8/2021 245,152.39 December -20 2W21000000 48,951.65 48,951.65 48,951.65 2/1/2021 196,200.74 December -20 "B" 2W2 1000000 758.53 196,200.74 January -21 2W21000000 19,793.55 20,552.08 20,552.08 3/12/2021 175,648.66 February -21 2W21000000 35,183.96 35,183.96 35,183.96 4/13/2021 140,464.70 March -21 2W21000000 38,155.32 38,155.32 38,155.32 5/10/2021 102,309.38 April -21 2W21000000 48,475.69 48,475.69 48,475.69 6/14/2021 53,833.69 May -21 2W21000000 25,017.46 25,017.46 25,017.46 7/8/2021 28,816.23 June -21 2W21000000 28,816.23 28,816.23 28,816.23 7/15/2021 0.00 Totals 370,437.00 370,437.00 370,437.00 2W21000000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 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 7/1/2020 Closeout Part 3 Page 1 of 2 YEAR OF FUNDS PY20(SFY21) TITLE/PROGRAM/PROJECT EXTRA ESF FUNDING ONLY -NO CRWC CLEAR Program code 2W31000000 END DATE END DATE 6/30/2021 I. CASH REQUEST 1. Total program and Admin Cash needs Previously Reported 95,215.00 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date 95,215.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 95,215.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 95,215.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 ' 'q I 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.�°?.,Lug ._ 1. FINAL Cash Request Contract to Date 95,215.00 2. FINAL Expenses Through End of Contract 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) 95,215.00 Yes R /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 95,215.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 Date 24 g /A'�1/r Authorized Signature " � C.1" Date AUG 1 8 2021 See instruction for completing this for on the next tab (Attachment H 2 of 2) 020.24 -01V9 11 F' Period tia)an es (PJ:TD un-21 , :a Account 5230.0000.6500.2W31000000.0000.0000000( Period :Dec -19 Jan -20 Feb -20 �1Mar-20 Apr -20 'May -20 IJun-20 ;Adj-20 Jul -20 Aug -20 Funds Available ( Detail Balances ) Budget 0.00; 0.00' 0.00 0.00; 0.00 0.00; 0.00...... 0.00: 95215.00 0.00; 95215.00.' Encumbrance 0.00 0,00... 0.00 0.00 0.00, 0.00 0.00 0.00 0.00 0.00 0.00E Account 5230.0000.6500.2W31000000.0000.0000000t Period Sep -20 `Oct -20 Nov -20 Dec -2D 'Jan -21 ;Feb -21 ;Mar -21 iApr-21 :May -21 ;Jun -21 Funds Available ( Detail Balances ) Budget 0.00: 0.00 0.00. 0.00` 0.00. 0.00 0.00 0.00 0.00' 0.00 95215.00 Encumbrance 0.00! 0.00 0 00 0.00' 0.00' 0.00 0.00 0.00i 0.00. 0.001 Actual Funds Available 0.00 0.00 k 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00... 0.00 0.00 o.aD. 0.00 0.00 0.00 95215.00 0.00 0.00 95215.00 Actual 0.00: _O.OD 0.00 0.00 0.00 0.00 14748.25: 15568.28 39544.87 F 25353.60 95215.00 0.00 Cancel Funds Available 0.00-- 0.00 0.00 0.00 0.00, 0.00 -14748.25 -15568.28 -39544.87 -25353.60 Cancel 0.00 CLEAR WIOA Reconciliation-PY20(SFY21) WFD EXTRA ESF FUNDING ONLY -NO CRWC Reporting Month Program Code Tracking Sheet CLEAR Received Date Received Grant Balance July -20 2W31000000 , 95,215.00 August -20 2W31000000 95,215.00 September -20 2W3 1000000 95,215.00 October -20 2W3 1000000 95,215.00 November -20 2W31000000 95,215.00 December -20 2W31000000 95,215.00 December -20 "B" 2W3 1000000 95,215.00 January -21 2W31000000 95,215.00 February -21 2W31000000 95,215.00 March -21 2W31000000 14,748.25 14,748.25 14,748.25 5/10/2021 80,466.75 April -21 2W31000000 15,568.28 15,568.28 15,568.28 6/14/2021 64,898.47 May -21 2W31000000 39,544.87 39,544.87 39,544.87 7/8/2021 25,353.60 June -21 2W31000000 25,353.60 25,353.60 25,353.60 7/15/2021 - Totals 95,215.00 95,215.00 95,215.00 2W31000000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 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 10/1/2019 YEAR OF FUNDS TITLE/PROGRAM/PROJECT CLEAR Program code Page 1 of 2 FY20 WIOA ADULT LOCAL ADMIN 46A9000000 END DATE END DATE 6/30/2021 I. CASH REQUEST 1. Total program and Admin Cash needs Previously Reported 41,412.00 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date 41,412.00 T. 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 I ADMINISTRATIVE EXPENSE (ER) !ni 4. Total Expenses+Accruals Previously Reported (Through Last Month) 41,412.00 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 41,412.00 III. PROGRAM INCOME(PI) EXPENSE REPORT ) 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 ? a,.., 1. FINAL Cash Request Contract to Date 41,412.00 2. FINAL Expenses Through End of Contract 41,412.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 , �� tjil A ttla 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 . w III .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 VII. MATCH RECONCILIATION 5� 1. FINAL Match Reported Through End of Contract 0.00 2. FINAL Expenses Through End of Contract 41,412.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 I 1.021 Authorized Signature Date AUG 1 8 2021 See instruction for completing this for on the next tab (Attachment H 2 of 2) Account 5230.0000.6500.46A9000000.0000.00000000 Funds Available ( Detail Balances ) Period Sep -19 lOct-19 ':Nov-19� 'Dec -19 Jan -20 ?Feb -20 ;Mar -20 'Apr -20 IMay-20 3Jut+ ti. ................. 'Period Budget _... 0.00; 41412.00 0.00: 0.00' 0.00 0.00 0.00'. 0.001 0.00 0.00' 41412.00 Encumbrance 0.00, 0.00` 0.00 0.00 0.00 0.00 0.00 0.00 0.00'. 0.00. o.00' Account ,5230.0000.6500.46A9000000.0000.00000000 Period IJul-20 Aug -20 !Sep -20 Oct -20 ;Nov -20 ;Dec -20 ,Jan -21 Feb -21 ;Mar -21 Funds Available ( Detail Balances ) Budget 0.00; 0.00 i o.00 0.00,.._ 0.00; 0.0/0 0.0O; 0.001 0.00 0.00 41412.00 Encumbrance 0.00; 0.00: 0.00` 0.00' 0.00 0.00: 0.00 0.00 0.00, 0.001 0.00! Actual 0.00,,,, 0.00', 0.00'. 0.00 11517.04', 3671.09 2477.34 2825.76: 2749.21, 11892.68 41412.00 Funds Available 0.00 41412.00 0.00-'- 0.00 -11517.04 -3671.09 -2477.34 , -2825.76 -2749.21 -11892.68 Cancel 0.00 Actual Funds Available 0.00, K-_ 000±. 0.00 0.00 1649.08 -1649.08. 3024.04 -3024.04. 1605.76'. 0.00 0.00 0.00 0.00 0.00'. 41412.00: -1605.76 0.00' 0.00 0.00 0.00 0.00 Cancel 0.00' CLEAR WIOA Reconciliation-FY20 WIOA ADULT LOCAL ADMIN Reporting Month Program Code Tracking Sheet CLEAR Received Date Received Grant Balance October -19 4649000000 41,412.00 November -19 4649000000 1,092.22 41,412.00 December -19 4649000000 4,617.41 41,412.00 December -19 "C" 4649000000 5,807.41 41,412.00 January -20 4649000000 11,517.04 11,517.04 3/6/20 29,894.96 February -20 4649000000 3,671.09 3,671.09 3,671.09 4/23/20 26,223.87 March -20 4649000000 2,477.34 2,477.34 2,477.34 5/6/20 23,746.53 April -20 4649000000 2,825.76 2,825.76 2,825.76 6/20/20 20,920.77 May -20 4649000000 2,749.21 2,749.21 2,749.21 7/10/20 18,171.56 June -20 4649000000 11,892.68 11,892.68 11,892.68 8/4/20 6,278.88 July -20 4649000000 6,278.88 August -20 4649000000 1,649.08 1,649.08 1,649.08 10/8/20 4,629.80 September -20 4649000000 3,024.04 3,024.04 3,024.04 11/10/20 1,605.76 October -20 4649000000 1,605.76 1,605.76 1,605.76 12/10/20 (0.00) November -20 4649000000 (0.00) December -20 4649000000 (0.00) Totals 41,412.00 41,412.00 41,412.00 46A9000000 General ledger vs bullied 0.00 Billed not received 0.00 General ledger vs. received 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/2019 YEAR OF FUNDS Page 1 of 2 FY20 TITLE/PROGRAM/PROJECT WI0A DW ADMIN LOCAL/COUNTIES CLEAR Program code 46D9000000 END DATE END DATE 6/30/2021 I. CASH REQUEST 1. Total program and Admin Cash needs Previously Reported 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date 32,368.00 32,368.00 II. PROGRAM EXPENSE REPORT (ER) , Irt 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) -' I „ '. 4. Total Expenses+Accruals Previously Reported (Through Last Month) 32,368.00 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 32,368.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 F iii 1. FINAL Cash Request Contract to Date 32,368.00 2. FINAL Expenses Through End of Contract 32,368.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes 2 /No O V. CASH REQUEST PROGRAM INCOME CASH REPORTED 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 lr'. 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 32,368,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 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 4 Date g /5J Authorized Signature 'z-42--jz,---- Date AUG 1 8 2021 See instruction for completing this for on the next tab (Attachment bl 2 of 2) Account ,5230.0000.6500.46D9000000.0000.00000000 Funds Available ( Detail Balances ) Period ,Sep -19 Oct -19 1 Nov -19 jDec-19 Jan -20 ,Feb -20 Mar -20 ;Apr -20 "May -20 Jun -20 'Period SalonCoo TD) JUit Budget 0.00 32368.00 0.00 0.00` 0.00' 0.00; 0.00' 0.00 32368.00 Encumbrance 0.00'. 0.00! 0.00! 0.00; 0.00, 0.00 0.00 0.00, 0.00! 0.00 0.00 Funds Available ( Detail Balances ) Period Budget Encumbrance Adj-20 0.0(11 0.001 ';Jul -20 0.00' 0.00:! 'Aug -20 0.001 0.001 ,Sep -20 Oct 20 Nov -20 Dec -20 Jan -21 'Feb -21 „Mar -21 0.00; o.00l 0.001 0.00! 0.001 0.001 .... 0.06 2368.00 0.00 0.00 o.00:`� ! 0.00 0.00. 0.00! 0.00" 0.00; 4 Actual Funds Available 0.00 0.00 0.00 0.00 o.00' 2325.23 1954.68 2268.64, 2147.17 3244.68 18270.37; 32368.00 Actual 0.00 0.00 1571.381 585.851: 0.00 0.00' 0.00 0.00 0.00 0.00 32368.00 32368.00 0.00 0.00 -2325.23 -1954.6 2268.64 -2147.17 -3244.68 -18270.37 w 0.00 Cancel Account 5230.0000.6500.46D9000000.0000.00000000 Funds Available 0.00 ±-! 0.00 -1571.38 ' -585.8 0.00 0.00 0.00'" 0.00 0.00, 0.001 Cancel 0.00 CLEAR WIOA Reconciliation-FY20 DW ADMIN LOCAL/COUNTIES Reporting Month Program Code Tracking Sheet CLEAR Received Date Received Grant Balance November -19 46D9000000 32,368.00 December -19 46D9000000 32,368.00 12/1/2019 "B" 46D9000000 150.46 32,368.00 December -19 "C" 46D9000000 2,174.77 32,368.00 January -20 46D9000000 2,325.23 2,325.23 3/6/20 30,042.77 February -20 46D9000000 1,954.68 1,954.68 1,954.68 4/23/20 28,088.09 March -20 46D9000000 2,268.64 2,268.64 2,268.64 5/6/20 25,819.45 April -20 46D9000000 2,147.17 2,147.17 2,147.17 6/20/20 23,672.28 May -20 46D9000000 3,244.68 3,244.68 3,244.68 7/10/20 20,427.60 June -20 46D9000000 18,270.37 18,270.37 18,270.37 8/4/20 2,157.23 July -20 46D9000000 2,157.23 August -20 46D9000000 1,571.38 1,571.38 1,571.38 10/8/20 585.85 September -20 46D9000000 585.85 585.85 585.85 11/10/20 - October -20 46D9000000 - November -20 46D9000000 - December -20 46D9000000 - Totals 32,368.00 32,368.00 32,368.00 46D9000000 General ledger vs billied 0.00 Billed not received ] 0.00 General ledger vs. received 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 10/1/2019 YEAR OF FUNDS Page 1 of 2 FY20 TITLE/PROGRAM/PROJECT WIOA 25% DW ENHANCED ADMIN CLEAR Program code 47D9000000 END DATE END DATE 6/30/2021 I. CASH REQUEST iir , 1 . 1. Total program and Admin Cash needs Previously Reported 16,819.0O 2. Current Program and Admin Cash Needs 16,819.00 3. FINAL Program and Admin Cash Needs Contract to Date II. PROGRAM EXPENSE REPORT (ER) �t a J �, e �., 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) . , �i ^�, 4. Total Expenses+Accruals Previously Reported (Through Last Month) 16,819.00 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 16,819.00 III. PROGRAM INCOME(PI) EXPENSE REPORT � qr.M-„ �, _ 4 " f 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 Q°.? 1. FINAL Cash Request Contract to Date 16,819.00 2. FINAL Expenses Through End of Contract 16,819.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes D /No O V. CASH REQUEST PROGRAM INCOME CASH REPORTED 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 ll,° 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, 1. FINAL Match Reported Through End of Contract 0.00 2. FINAL Expenses Through End of Contract 16,819.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 A. II -V2 Authorized Signature Date AlJ6 1 8 21. See instruction for completing this for on the next tab (Attachment H 2 of 2) 'Period Account (5230.0000.6500.47D9000000.0000.00000000 Period • Mar -19 Apr -19 ,May -19 lJun-19 Adj-19 !Jul 19 Aug -19 ,Sep -19 !Oct -19 • Funds Available ( Detail Balances ) Budget Encumbrance 0.00E 0.001 0.001 0.00 0.00i 0.001 o.00 0 00` 0.001 0.00` 0.00: 0.001 11409.00; 0.00 16819.00 0.00! 0.00 0.00 0.001 0.00: 0.00' Actual Funds Available 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.00. 0.00 0.00 _. 0.00 0.00 11409.00` 0.00; 0.00 w' 0.00, 16819.00; 0.00 Cancel °Period) - Jun 21 Account 5230 0000 6500 47D9000000.0000.00000000 Period ',Dec 19 Jan -20 Feb -20 Mar -20 ;Apr -20 ;May -20 Jun -20 !Adj-20 'Jul -20 LL :Aug -20 Funds Available ( Detail Balances ) Budget 0.001 0.00; _. 0.001 0.00 0.00 0.00f 0.00! 0.00; 0.001 0.00 16819.00 Encumbrance Actual Funds Available 0.00 0.00 0.00 0.00 2770.57 ' -2770.57: ". 323.87! -323.87 604.23= -604.23 494.24: 494.24 1698.65 -1698.65 5517.44 -5517.44 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00• 0.001 0.00 0.00; 0.00! 0.00; 0.00'; 0.00'. r1 Account 5230.0000.6500 47D9000000.0000.00000000. Period :Oct -20 Nov -20 Dec -20 Jan -21 !Mar -21' Apr -21 !May-21� :Jun -21 Funds Available ( Detail Balances ) Budget 11410.00 Encumbrance 0.00' 0.00: 0.00; 0.00` 0.00, -6000.00: 0.00 0.00 0.00I 0.00; 0.00E 0.001 0.00; 16819.00 ° 0.00 Actual Funds Available 1097.84 10312.16 1296.1 -1296.11 447.05 -447.05, 2071.92: 0.00! 22.51 106.44 45.23; 322.901 0.00. -2071.92 .!. 0.00 -22.51 -106.44 -6045.23 -322.90 0.00 r! 16819.00 0.00 CLEAR WIOA Reconciliation-FY20 WIOA 25% DW ENHANCED ADMIN Reporting Month Program Code Tracking Sheet CLEAR Received Date Received Grant Balance October -19 47D9000000 16,819.00 November -19 47D9000000 357.81 , 16,819.00 December -19 47D9000000 287.31 16,819.00 December -19 "C" 47D9000000 2,125.45 16,819.00 January -20 47D9000000 2,770.57 2,770.57 3/6/2020 14,048.43 February -20 47D9000000 323.87 323.87 323.87 4/23/2020 13,724.56 March -20 47D9000000 604.23 604.23 604.23 5/6/2020 13,120.33 April -20 47D9000000 494.24 494.24 494.24 6/20/2020 12,626.09 May -20 47D9000000 1,698.65 1,698.65 1,698.65 7/10/2020 10,927.44 May -20 47D9000000 5,517.44 5,517.44 5,517.44 8/4/2020 5,410.00 June -20 47D9000000 5,410.00 July -20 47D9000000 5,410.00 August -20 47D9000000 360.56 5,410.00 September -20 47D9000000 1,097.84 1,097.84 1,097.84 11/10/2020 4,312.16 October -20 47D9000000 935.55 1,296.11 1,296.11 12/10/2020 3,016.05 November -20 47D9000000 447.05 447.05 447.05 1/8/2021 2,569.00 December -20 47D9000000 2,071.92 2,071.92 2,071.92 2/1/2021 497.08 January -21 47D9000000 497.08 February -21 47D9000000 22.51 22.51 22.51 4/13/2021 474.57 March -21 47D9000000 106.44 106.44 106.44 5/10/2021 368.13 April -21 47D9000000 45.23 45.23 45.23 6/14/2021 322.90 May -21 47D9000000 322.90 322.90 322.90 7/8/2021 0.00 June -21 47D9000000 0.00 Totals 16, 819.00 16, 819.00 16, 819.00 47D9000000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 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 EAIWORKPLAN START DATE PROGRAM INCOME START DATE 10/1/2019 YEAR OF FUNDS Closeout Part 3 Page 1 of 2 FY20 TITLE/PROGRAM/PROJECT WIOA ADULT LOCAL PROGRAM CLEAR Program code 48A9000000 END DATE END DATE 6/30/2021 I. CASH REQUEST 1. Total program and Admin Cash needs Previously Reported 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date rtt . 358,301.00 358 301.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 358,301.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 358,301.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 r ), 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 .hrti'IT,,. `.:I? 1. FINAL Cash Request Contract to Date 358,301.00 2. FINAL Expenses Through End of Contract 358,301.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes 7 /No 0 V. CASH REQUEST PROGRAM INCOME CASH REPORTED II l'v 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 =°jY��« 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 Artrt 1. FINAL Match Reported Through End of Contract 0.00 2. FINAL Expenses Through End of Contract 358,301.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 ' Date Us' 12, Authorized Signature / t Date AUG 18 2021 See instruction for completing this for on the next tab (Attachment H 2 of 2) Account :5230.0000.6500.48A9000000.0000.00000000 Period Oct -19 • INov-19 Dec -19 Jan -20 .............. 1Feb-20 Mar -20 Apr -20 ,May-20�� Jun -20 ' +Adj-20 Funds Available ( Detail Balances ) Budget 372714.00 0.00! 0.001 0.00' .. 0A0 1 0.00; 0.001 ................. 0.001 0.001 0.00 358301.00; Encumbrance - - 0.001 0.00€_�- 0.00 0.00: 0.00 0.00 0.00 0.00 0.00 0.00 0.00'. Actual Funds Available 0.00 372714 00 0.00 0.00 0.00 0.00 100268.81 -100268.81 34321.94 -34321.94 26430.47 -26430.47 20435.99 -20435.9 15211.45 -15211.45 19093.73 -19093.7 0.00 0.00 358301.00 0.00 Cancel °Pereod8 1. Account Period l IJ ul-20 'Aug -20 Sep -20 Oct -20 Nov -20 IDec-20 Jan -21 {Feb -21 Mar -21 ................ Apr -21 5230.0000.6500.48A9000000.0000.00000000 Funds Available ( Detail Balances ) Budget 0.00 0.00 -41413.00 0.00 0.00 0.00 0.00 0.00 0.00 27000.001 358301.00 Encumbrance 0.00; 0.00 0.001 Q 00 0.00; 0.001 . t. 0.001 0.00 a.00' 0.00 0.003 Actual Funds Available 7039.66 -7039.66,-- 12308.15 -12308.15 14791.36' -56204.36 19894.45 -19894.4511 19548.37 -19548.37 33322.75- -33322.75 8633.87 -8633.87 0.00 0.00 27000.00 -27000.00 0.00; 27000.00.. 358301.00 0.00 Cancel CLEAR WIOA Reconciliation-FY20 WIOA ADULT LOCAL PROGRAM Reporting Month Program Code Tracking Sheet CLEAR Received Date Received Grant Balance October -19 48A9000000 358,301.00 November -19 48A9000000 8,062.05 358,301.00 December -19 48A9000000 46,064.55 358,301.00 December -19 "B" 48A9000000 5,618.76 358,301.00 January -20 48A9000000 40,523.45 100,268.81 100,268.81 3/6/2020 258,032.19 February -20 48A9000000 34,321.94 34,321.94 34,321.94 4/23/2020 223,710.25 March -20 48A9000000 26,430.47 26,430.47 26,430.47 5/6/2020 197,279.78 April -20 48A9000000 20,435.99 20,435.99 20,435.99 6/20/2020 176,843.79 May -20 48A9000000 15,211.45 15,211.45 15,211.45 7/10/2020 161,632.34 June -20 48A9000000 19,093.73 19,093.73 19,093.73 8/4/2020 142,538.61 July -20 48A9000000 7,039.66 7,039.66 7,039.66 9/8/2020 135,498.95 August -20 48A9000000 12,308.15 I 12,308.15 12,308.15 10/8/2020 123,190.80 September -20 48A9000000 14,791.36 14,791.36 14,791.36 11/10/2020 108,399.44 October -20 48A9000000 19,894.45 19,894.45 19,894.45 12/10/2020 88,504.99 November -20 48A9000000 19,548.37 19,548.37 19,548.37 1/8/2021 68,956.62 December -20 48A9000000 33,322.75 33,322.75 33,322.75 2/1/2021 35,633.87 December -20 "B" 48A9000000 711.39 35,633.87 January -21 48A9000000 7,922.48 8,633.87 8,633.87 3/12/21 27,000.00 February -21 48A9000000 27,000.00 March -21 48A9000000 27,000.00 27,000.00 27,000.00 5/10/21 - Totals 358,301.00 358,301.00 358,301.00 48A9000000 General ledger vs billied 0.00 Billed not received 0.00 General ledger vs. received 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 10/1/2019 YEAR OF FUNDS TITLE/PROGRAM/PROJECT WIOA UW PROGRAM LOCAL/COUNTIES CLEAR Program code Page 1 of 2 FY20 48D9000000 END DATE END DATE 6/30;2021 I. CASH REQUEST b _. 3 " , 1. Total program and Admin Cash needs Previously Reported 281,945.00 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date 281,945.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 281,945.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 281,945.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 q,, 1. FINAL Cash Request Contract to Date 281,945.00 2. FINAL Expenses Through End of Contract 281,945.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 i .... a ',I: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 Contract to Date 0.00 VI. RECONCILIATION a•: 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,b'I aim 1. FINAL Match Reported Through End of Contract 0.00 2. FINAL Expenses Through End of Contract 281,945.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 en -024 Authorized Signature Date AUG 1 8 2021 See instruction for completing this for on the next tab (Attachment H 2 of 2) 'Period 6al c (P1TO) Jun -21 Account 15230.0000.6500.48D9000000.0000.00000000 Period Oct -19 Nov -19 Dec -19 Jan -20 Feb -20 Mar -20 1 Apr -20 m . ,May -20 Jun -20 .. Adj-20 Funds Available ( Detail Balances ) Budget 291313.00 0.00: 0.00 0.00 0.00' 0.00 0.00' 0.00 0.00 0.00 281945.00; Encumbrance 0.0O1 0.00, 0.00' 0.0O. 0.00; 0.00; 0.001 0.00; 0.00 0.00; ....................... . 0.00'. Account 35230.0000.6500.48D9000000.0000.00000000 Period Jul -20 Aug -20 1Sep-20 Oct -20 Nov -20 Dec -20 Jan -21 Feb -21 Mar -21 Apr -21 Cancel Funds Available ( Detail Balances ) Budget 0.00 0.00 32368.00,[ 0.00, .. 0.00 0.00 0.00 0.0O, 0.00, 23000.00 Encumbrance 0.00! 0.001 0.001 0.00 0.00 0.00 0.00 .. 0.00 .. 0.00 0.00 281945.00 0.00, Actual Funds Available 0.00! 291313.00,- 0.00 0.00 0.00; 0.00 37283.15: -37283.15 26090.04; -26090.04 20764.81 -20764.81 56x16 -29456.16 19232.64 -19232.64 26271.72 -26271.72 0.00 0.00„. 281945.00 0.00 Cancel aF!J1D). W J l Actual Funds Available 6707.97' -6707.97 _7556.13 13260.21 -45628.21 17516 50 -175115. 6.500 14552.84 -14552.84 14435.55 -14435.55 8216.78 -8216.78 10419.59 -10419.59 15426 30 -15426.30 14754.61 8245.39 .. 281945.00 0.0O CLEAR WIOA Reconciliation-FY20 WIOA DW PROGRAM LOCAL/COUNTIES Reporting Month Program Code Tracking Sheet CLEAR Received Date Received Grant Balance October -19 48D9000000 281,945.00 November -19 48D9000000 281,945.00 December -19 48D9000000 281,945.00 December -19 "B" 48D9000000 15,706.36 281,945.00 January -20 48D9000000 21,576.79 37,283.15 37,283.15 3/6/2020 244,661.85 February -20 48D9000000 26,090.04 26,090.04 26,090.04 4/23/2020 218,571.81 March -20 48D9000000 20,764.81 20,764.81 20,764.81 5/6/2020 197,807.00 April -20 48D9000000 29,456.16 29,456.16 29,456.16 6/20/2020 168,350.84 May -20 48D9000000 19,232.64 19,232.64 19,232.64 7/10/2020 149,118.20 June -20 48D9000000 26,271.72 26,271.72 26,271.72 8/4/2020 122,846.48 July -20 48D9000000 6,707.97 6,707.97 6,707.97 9/8/2020 116,138.51 August -20 48D9000000 7,556.13 7,556.13 7,556.13 10/8/2020 108,582.38 September -20 48D9000000 13,260.21 13,260.21 13,260.21 11/10/2020 95,322.17 October -20 48D9000000 17,516.50 17,516.50 17,516.50 12/10/2020 77,805.67 November -20 48D9000000 14,552.84 14,552.84 14,552.84 1/8/2021 63,252.83 December -20 48D9000000 14,435.55 14,435.55 14,435.55 2/1/2021 48,817.28 December -20 "B" 48D9000000 465.63 48,817.28 January -21 48D9000000 7,751.15 8,216.78 8,216.78 3/12/2021 40,600.50 February -21 48D9000000 10,419.59 10,419.59 10,419.59 4/13/2021 30,180.91 March -21 48D9000000 15,426.30 15,426.30 15,426.301 5/10/2021 14,754.61 April -21 48D9000000 14,754.61 14,754.61 14,754.61 6/14/2021 0.00 Totals 281,945.00 281,945.00 281,945.00 48D9000000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 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 10/1/2019 YEAR OF FUNDS Page 1 of 2 FY20 TITLE/PROGRAM/PROJECT WIOA 25% DW ENHANCED PROD CLEAR Program code 49D9000000 END DATE END DATE 6/30/2021 I. CASH REQUEST 1. Total program and Admin Cash needs Previously Reported 97,277.00 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date 97,277.00 II. PROGRAM EXPENSE REPORT (ER) ..,, 1. Total Expenses+Accruals Previously Reported (Through Last Month) 97,277.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 97,277.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 it yd ;,- 'ii,ww_ =w 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 � ,tW��, 1. FINAL Cash Request Contract to Date 97,277.00 2. FINAL Expenses Through End of Contract 97,277.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes D /No O 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 VI. RECONCILIATION mt 't�S�a�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 (I IIM UP fT v ,, „,,_ 1. FINAL Match Reported Through End of Contract 0.00 2. FINAL Expenses Through End of Contract 97,277.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 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 79 Date ASW/2-) Authorized Signature Date AUG 1 8 2021 See instruction for completing this for on the next tab (Attachment H 2 of 2) 0200/- 02 �9a 13 °Petted 3ata nces;l(i ITO) Jun .1 Account 5230.0000.6500.49D9000000.0000.00000000 Funds Available ( Detail Balances ) Period Oct -19 Nov -19 Dec -19 Jan -20 Feb -20 ;Mar -20 Apr -20 •May 20 ,Jun -20 .............. Adj-20 Budget 102687.00 • 0.001 0.00 0.00; 0.00; 0.00 ............ 0.00; 0.00l 0.001 0.00 97277.00 Encumbrance 0.00 -----0.00 0.00'. 0.00, 0.00'. 0.00 0.00 0.00 0.00 0.00 0.00. Actual 0.00 0.00 0.00, 33250.78'. -15063.85 5023.47 18019.50 115.66 37 7497.20 0.00 97277.00 Funds Available 102687 00 0.00 0.00 -33250.78 15063.85 -5023.47 -18019.50 -11566.37 -7497.201 000 W. Cancel 0.00 °Period Balances: Account 5230.0000.6500.49D9000000.0000.00000000 Period Aug -20 Sep -20 Oct -20 Nov -20 ;Dec -20 1'1Jan-21 • Feb -21 Mar -21 •,Apr -21 Funds Available ( Detail Balances ) Budget 0.00 0.00- -11410.00; _. 0.001 0.00._ 0.00 0.00 0.00 0.00 6000.00 97277.00 Encumbrance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Actual 1539.17' 4364.16 4888.82; 4157.40 2233.92 13004.50 795.56' 0.00 4146.17 1853.83' 97277.00; Funds Available 1539.17 -; -4364.16 16298.82 -4157.40 -2233.92 -13004.50 -795.56 0.00 -4146.17 4146.17 0.00 CLEAR WIOA Reconciliation-FY20 WIOA 25% DW ENHANCED PROG LOCAL/COUNTIES Reporting Month Program Code Tracking Sheet CLEAR Received Date Received Grant Balance October -19 49D9000000 97,277.00 November -19 49D9000000 97,277.00 December -19 49D9000000 16,461.80 97,277.00 December -19 "B" 49D9000000 13,213.94 97,277.00 January -20 49D9000000 3,575.04 33,250.78 33,250.78 3/6/2020 64,026.22 February -20 49D9000000 (15,063.85) (15,063.85) (15,063.85) 4/23/2020 79,090.07 March -20 49D9000000 5,023.47 5,023.47 5,023.47 5/6/2020 74,066.60 April -20 49D9000000 18,019.50 18,019.50 18,019.50 6/20/2020 56,047.10 May -20 49D9000000 11,566.37 11,566.37 11,566.37 7/10/2020 44,480.73 June -20 49D9000000 7,497.20 7,497.20 7,497.20 8/4/2020 36,983.53 July -20 49D9000000 1,539.17 1,539.17 1,539.17 9/8/2020 35,444.36 August -20 49D9000000 4,364.16 4,364.16 4,364.16 10/8/2020 31,080.20 September -20 49D9000000 4,888.82 4,888.82 4,888.82 11/10/2020 26,191.38 October -20 49D9000000 4,157.40 4,157.40 4,157.40 12/10/2020 22,033.98 November -20 49D9000000 2,233.92 2,233.92 2,233.92 1/8/2021 19,800.06 December -20 49D9000000 13,004.50 13,004.50 13,004.50 2/1/2021 6,795.56 December -20 "B" 49D9000000 322.11 6,795.56 January -21 49D9000000 473.45 795.56 795.56 3/12/2021 6,000.00 February -21 49D9000000 6,000.00 March -21 49D9000000 4,146.17 4,146.17 4,146.17 5/10/2021 1,853.83 April -21 49D9000000 1,853.83 1,853.83 1,853.83 6/14/2021 0.00 Totals 97,277.00 97,277.00 97,277.00 49D9000000 General ledger vs bullied 0.00 Billed not received 0.00 General ledger vs. received 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 CLEAR Program code Page 1 of 2 PY19 WIOA ADULT LOCAL ADMIN 4A69000000 END DATE END DATE 6/30/2021 I. CASH REQUEST 1. Total program and Admin Cash needs Previously Reported 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date :, _ rt ,, 7,768.00 7,768.00 II. PROGRAM EXPENSE REPORT (ER) s'; '; L ii ,,' 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) i, inm= 4. Total Expenses+Accruals Previously Reported (Through Last Month) 7,768.00 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 7,768.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 7,768.00 2. FINAL Expenses Through End of Contract 7,768.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes 0 /No 0 V CASH REQUEST PROGRAM INCOME CASH REPORTED 01 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 1ti+,." 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 1ue-,r.'-.-. 1. FINAL Match Reported Through End of Contract 0.00 2. FINAL Expenses Through End of Contract 7,768.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 2r Authorized Signature AUGLJ// Date AU1 8 2021 See instruction for completing this for on the next tab (Attachment H 2 of 2) oZoo_a4'9a Account 5230.0000.6500.4A69000000.0000.00000000 Period Adj-19 'Jul -19 ;Dec -19 1 Jan -20 Feb -20 Mar -20 Funds Available ( Detail Balances Budget 0.00 7768.00 0.00 0.001. 0.00_ 0.00! 0.00 0.00 0.00 0.00` Encumbrance 0.00;. 0.00 000 0.00;. 0.00:_ 0.00; 0.00` 0.00; 0.00. 0.00! 2708.24;. 5059.76 0.00 0.00 0.00 0.00 Actual Funds Available 0.00. 0.00-- 0.00 7768.00 0.00. 0.00 -2708.24 -5059.76 0.00_: CLEAR WIOA Reconciliation-PY19 WIOA ADULT LOCAL ADMIN Reporting Month Program Code Tracking Sheet CLEAR Received Date Received Grant Balance June -19 4A69000000 7,768.00 July -19 4A69000000 7,768.00 August -19 4A69000000 7,768.00 September -19 4A69000000 7,768.00 October -19 4A69000000 2,708.24 2,708.24 2,708.24 12/12/2019 5,059.76 November -19 4A69000000 5,059.76 5,059.76 5,059.76 1/13/2020 - December -19 4A69000000 - Totals 7,768.00 7,768.00 7,768.00 4A69000000 General ledger vs billied 0.00 Billed not received 0.00 General ledger vs. received 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 7/1/2019 YEAR OF FUNDS Closeout Part 3 Page 1 of 2 PY19 TITLE/PROGRAM/PROJECT WIOA ADULT LOCAL PROGRAM CLEAR Program code 4A89000000 END DATE END DATE 6/30;2021 I. CASH REQUEST 1. Total program and Admin Cash needs Previously Reported 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date 69,913.00 69,913.00 II. PROGRAM EXPENSE REPORT (ER) r 'r` � �� d1VW" 1. Total Expenses+Accruals Previously Reported (Through Last Month) 69,913.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 69,913.00 ADMINISTRATIVE EXPENSE (ER) (' I _:. 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 e`t!i ,_- 1. FINAL Cash Request Contract to Date 69,913.00 2. FINAL Expenses Through End of Contract 69,913.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes G /No O V. CASH REQUEST PROGRAM INCOME CASH REPORTED ,q14';':'' ' ha. 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, 11 1. FINAL Match Reported Through End of Contract 0.00 2. FINAL Expenses Through End of Contract 69,913.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 ��41 Date gysG% � Authorized Signature v/Jr�� / Date Q AUG 1 8 2021 See instruction for completing this for on the next tab (Attachment H 2 of 2) O2oar Account 5230.0000.6500.4A89000000.0000.00000006 Period Adj-19 Jul -19 lAug-19� ____......:.:. ISep-19 lOct-19 Nov -19 Dec -19 (Jan -20 Feb -20 I Funds Available ( Detail Balances ) Budget __._. 0.0o 69913.00 0.00 ........... 0.00 0.00 0.00 0.00 0.00 0.00 0.00 69913.00'' Encumbrance 0.00 0.00 0.00 0.00, .. 0.00 0.00 0.00 .__. 0.00 0.00 0.00 0.00; Actual 0.00 0.00 0.00 0.00: 20872.46 49040.54 0,00 0.00 0.00 0.00 69913.00 Funds Available 0.0 0 69913.00 0.00 0.00 -20872.46 -49040.54 0.00 0.00 0.00 0.00 ,' 0.00 CLEAR WIOA Reconciliation-PY19 WIOA ADULT LOCAL PROGRAM Reporting Month Program Code Tracking Sheet CLEAR Received Date Received Grant Balance June -19 4A89000000 69,913.00 July -19 4A89000000 69,913.00 August -19 4A89000000 69,913.00 September -19 4A89000000 69,913.00 October -19 4A89000000 20,872.46 20,872.46 20,872.46 12/12/2019 49,040.54 November -19 4A89000000 49,040.54 49,040.54 49,040.54 1/13/2020 - December -19 4A89000000 - Totals 69,913.00 69,913.00 69,913.00 4A89000000 General ledger vs bullied 0.00 Billed not received 0.00 General ledger vs. received 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 7/1/2019 YEAR OF FUNDS TITLE/PROGRAM/PROJECT CLEAR Program code Closeout Part 3 Page 1 of 2 PY19 WIOA DW LOCAL ADMIN 4D69000000 END DATE END DATE 6/30;2021 I. CASH REQUEST 1. Total program and Admin Cash needs Previously Reported 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date 6,822.00 6,822.00 II. PROGRAM EXPENSE REPORT (ER) °','N..,.' illft Y�= 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) r , a 4. Total Expenses+Accruals Previously Reported (Through Last Month) 6,822.00 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 6,822.00 III. PROGRAM INCOME(PI) EXPENSE REPORT TirK 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 6,822.00 2. FINAL Expenses Through End of Contract 6,822.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 ( `' iT .;:" 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 ` 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 6,822.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 }t' (112-/ Authorized Signature _ '—'1.12.-,1.1....O"--Date AUG 1 8 2021 See instruction for completing this for on the next tab (Attachment H 2 of 2) Oto021-0Z4 7�� ric Account 5230.0000.6500.4D69000000.0000.00000000 Funds Available ( Detail Balances ) Period Adj-19 _ ._.. !Jul -19 Aug 19 ISep-19 :Nov -19 ;Dec -19 Jan -20 Feb -20 Budget Encumbrance 0.00!! 0.00', 6822.00 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.00 0.00 6822.00 0.00 Actual Funds Available 0.00 0.00 0.00 6822.00. 0.00 0.00 0.00 774.71 1967.33 2115.21 1964.75 0.00. 0.00 22.00 0.00 -774.71 -1967.3 -2115.21 -1964.75 0.00 0.00 m 0.00 CLEAR WIOA Reconciliation-PY19 WIOA DW LOCAL ADMIN Reporting Month Program Code Tracking Sheet CLEAR Received Date Received Grant Balance June -19 4D69000000 6,822.00 July -19 4D69000000 6,822.00 August -19 4D69000000 6,822.00 September -19 4D69000000 6,822.00 October -19 4D69000000 774.71 774.71 774.71 12/12/2019 6,047.29 November -19 4D69000000 1,967.33 1,967.33 1,967.33 1/13/2020 4,079.96 December -19 4D69000000 2,115.21 2,115.21 2,115.21 2/5/2020 1,964.75 December -19 "B" 4D69000000 1,964.75 4,079.96 January -20 4D69000000 1,964.75 1,964.75 3/6/2020 - Totals 6,822.00 6,822.00 6,822.00 4D69000000 General ledger vs billied 0.00 Billed not received 0.00 General ledger vs. received 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 7/1/2019 YEAR OF FUNDS TITLE/PROGRAM/PROJECT CLEAR Program code Closeout Part 3 Page 1 of 2 PY19 WIOA DW LOCAL PROGRAM 4O89000000 END DATE END DATE 6/30/2021 I. CASH REQUEST 1. Total program and Admin Cash needs Previously Reported 2. Current Program and Admin Cash Needs lul1� 61,399.00 3. FINAL Program and Admin Cash Needs Contract to Date 61,399.00 II. PROGRAM EXPENSE REPORT (ER) i" m1Ii1a?I 1. Total Expenses+Accruals Previously Reported (Through Last Month) 61,399.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 6",399.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 61,399.00 2. FINAL Expenses Through End of Contract 61,399,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 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 � ( ( T!'" 1. FINAL Match Reported Through End of Contract 0.00 2. FINAL Expenses Through End of Contract 61,399.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 13 /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/�/ Date �j ��/2' Authorized Signature t Date AUG 1 8 102 ^ See instruction for completing this for on the next tab (Attachment H 2 of 2) l 2 Period Adj-19 Jul -19 Aug -19 Sep -19 1 Account.5230.0000.6500.4D89000000.0000.00000000' Nov -19 !Dec -19 Jan -20 Feb -20 ;Mar -20 Funds Available ( Detail Balances ) Budget 0.00 61399.00 0.00',' 0.00,E 0.001 0.001 0.001 0.00!` 0.000 61399.00 Encumbrance 0.00 0.00, 0.00 0.00 0.00 0.00°._... 0.00 0.00, 0.00,.. 0.00 0.00 Actual 0.00 0.00 0.00 0.00 10122.34 26056.72 17963.07 7256.87 0.00 0.00 ................... 61399.00 Funds Available 0.00 1- 61399.00 0.00,.' 0.00 -10122,34 -26056.72 -17963.07 -7256.87 0.00 0.00 0.00 CLEAR WIOA Reconciliation-PY19 WIOA DW LOCAL PROGRAM Reporting Month Program Code Tracking Sheet CLEAR Received Date Received Grant Balance June -19 4D89000000 61,399.00 July -19 4D89000000 61,399.00 August -19 4D89000000 61,399.00 September -19 4D89000000 61,399.00 October -19 4D89000000 10,122.34 10,122.34 10,122.34 12/12/2019 51, 276.66 November -19 4D89000000 26,056.72 26,056.72 26,056.72 1/13/2020 25,219.94 December -19 4D89000000 17,963.07 17,963.07 17,963.07 2/5/2020 7,256.87 December -19 "B" 4D89000000 7,256.87 7,256.87 January -20 4D89000000 7,256.87 7,256.87 3/6/2020 - February -20 4D89000000 - March -20 4D89000000 - Totals 61,399.00 61,399.00 61,399.00 4D89000000 General ledger vs bullied 0.00 Billed not received 0.00 General ledger vs. received 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/2019 YEAR OF FUNDS Closeout Part 3 Page 1 of 2 FY20 TITLE/PROGRAM/PROJECT WIOA COVID19-ADULT LOCAL ADMIN CLEAR Program code 4VA9000000 END DATE END DATE 6/30/2021 I. CASH REQUEST 1. Total program and Admin Cash needs Previously Reported 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date '" °''- "'� 14,413.00 14,413.00 II. PROGRAM EXPENSE REPORT (ER) M iiq a - I 'r 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) A' 'M:``i 4. Total Expenses+Accruals Previously Reported (Through Last Month) 14,413.00 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 14,413.00 III. PROGRAM INCOME(PI) EXPENSE REPORT 4uyr 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 14,413.00 2. FINAL Expenses Through End of Contract 14,413.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 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 VI. RECONCILIATION 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 l a �Y " 1. FINAL Match Reported Through End of Contract 0.00 2. FINAL Expenses Through End of Contract 14,413.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 t7/312.I i Authorized Signature Date AUG 1 8 2021 See instruction for completing this for on the next tab (Attachment H 2 of 2) Period Sep -20 Oct -20. ,Nov -20 ...__ IDec-20 IJan-21 Feb -21 Mar -21 Apr -21 May -21 Jun -21 Yi Account 5230.0000.6500.4VA9000000.0000.00000000 Funds Available ( Detail Balances ) Budget 41413.00 0.00! 0,00! 0.00' ._�.. 0.00 0.00i 0.00` -27000.00 0.00 0.00" _.. 14413.00 Encumbrance 0.00 0.00 0.00 0.00 0.00 0.00, 0.00 0.00. 0.00 0.00= Actual Funds Available 0.00 41413.00 . 0.00 .m_..__0.00 3139.63 -3139.63 7200.03 -7200.03 0.00 0.00 0.00 .. _ 0.00 727.81 -727.81. 606.33 -27606.33 2739.20 -2739.20 0.00 0.00 :' 0.00i 14413.00; 0.00 Cancel CLEAR WIOA Reconciliation-FY20 WIOA COVID19-ADULT LOCAL ADMIN Reporting Month Program Code Tracking Sheet CLEAR Received Date Received Grant Balance September -20 4VA9000000 14,413.00 October -20 4VA9000000 14,413.00 November -20 4VA9000000 3,139.63 3,139.63 3,139.63 1/8/2021 11,273.37 December -20 4VA9000000 7,200.03 7,200.03 7,200.03 2/1/2021 4,073.34 January -21 4VA9000000 4,073.34 February -21 4VA9000000 4,073.34 March -21 4VA9000000 727.81 727.81 727.81 5/10/2021 3,345.53 April -21 4VA9000000 606.33 606.33 606.33 6/14/2021 2,739.20 May -21 4VA9000000 2,739.20 2,739.20 2,739.20 7/8/2021 - June -21 4VA9000000 - Totals 14,413.00 14,413.00 14,413.00 4VA9000000 General ledger vs billied 0.00 Billed not received 0.00 General ledger vs. received 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/2019 YEAR OF FUNDS TITLE/PROGRAM/PROJECT CLEAR Program code Closeout Part 3 Page 1 of 2 FY20 WIOA COVID19-DW ADMIN 4VD9000000 END DATE END DATE 6/30/2021 I. CASH REQUEST 1. Total program and Admin Cash needs Previously Reported 2. Current Program and Admin Cash Needs !s `t< a ,,b ,', 9,368.00 3. FINAL Program and Admin Cash Needs Contract to Date 9,368.00 II. PROGRAM EXPENSE REPORT (ER) " m,,ljf 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) emu,, 4. Total Expenses+Accruals Previously Reported (Through Last Month) 9,368.00 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 9,368.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 .V,a 1. FINAL Cash Request Contract to Date 9,368.00 2. FINAL Expenses Through End of Contract 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) 9,368.00 Yes R /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 .,hr�,^il i'In„ sia'a 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 9,368.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 E /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 Authorized Signature See instruction for completing this for on the next tab (Attachment H 2 of 2) Date O ItTi2( Date AUG 18 2021 a/002l-02# 9,4 Account ;5230,0000.6500.4VD9000000.0000.00000000 Period i Sep -20 Oct -20 Nov -20 Dec -20 Funds Available ( Detail Balances ) Budget 32368 00. 0.00' 0.00 0.00 0.00, 0.001 0.001 -23000.00 0.00;. 0.00 9368.00 r 0.00' 0.00; 0.00m.. 0.00 0.00 0.00 0.00; 0.00i 0.00i 0.00: 0.00 Actual Funds Available 1196.27; 31171.73' -1196.27 2857.14 4431.77 0.00 0.00 313.72 170.22 561.90 1033.25' 9368.00 1196.27 -2857.14 -4431.77 0.00 0.00 -313.72" -23170.22 -561.90 -1033.25 0.00 CLEAR WIOA Reconciliation-FY20 WIOA COVID19-DW ADMIN LOCAL/COUNTIES Reporting Month Program Code Tracking Sheet CLEAR Received Date Received Grant Balance September -20 4VD9000000 9,368.00 October -20 4VD9000000 9,368.00 November -20 4VD9000000 2,857.14 2,857.14 2,857.14 1/8/2021 6,510.86 December -20 4VD9000000 4,431.77 4,431.77 4,431.77 2/1/2021 2,079.09 January -21 4VD9000000 2,079.09 February -21 4VD9000000 2,079.09 March -21 4VD9000000 313.72 313.72 313.72 5/10/2021 1,765.37 April -21 4VD9000000 170.22 170.22 170.22 6/14/2021 1,595.15 May -21 4VD9000000 561.90 561.90 561.90 7/8/2021 1,033.25 June -21 4VD9000000 1,033.25 1,033.25 - Totals 9,368.00 9,368.00 8,334.75 4VD9000000 General ledger vs billied 0.00 Billed not received I 1,033.25 General ledger vs. received 1,033.25 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 9/1/2019 YEAR OF FUNDS Closeout Part 3 Page 1 of 2 FY19 TITLE/PROGRAM/PROJECT WIOA 10% DW CWDC COUNCIL (PIF) CLEAR Program code 4WD8000000 END DATE END DATE 12/31/2020 I. CASH REQUEST Ith a 1. Total program and Admin Cash needs Previously Reported 45,712.00 2. Current Program and Admin Cash Needs 45,712.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) 45,712.00 2. Current Expenses + Accruals (Through End Date of Award) 45,712.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 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 11/. RECONCILICATION ,tljilll fteSul 1. FINAL Cash Request Contract to Date 45,712.00 2. FINAL Expenses Through End of Contract 45,712.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes R /No O V CASH REQUEST PROGRAM INCOME CASH REPORTED tt 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 , u, r .. �t" ' �t e' 1. FINAL Match Reported Through End of Contract 0.00 2. FINAL Expenses Through End of Contract 45,712.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 n I,72% Authorized Signaturekl-t>""1-e-iet-er"—Date AUG 18 2021 See instruction for completing this for on the next tab (Attachment H 2 of 2) 020 o2/ -a'2 496' 3� Account 5230.0000.6500.4WD8000000.0000.00000001 Funds Available ( Detail Balances ) Period Sep -19 }act -19 Nov -19 ,aDec-19 Jan -20 .......... ..... Feb -20 Mar -20 Apr -20 May -20 rJun-20 Budget Encumbrance 45712.00 0.00 0.00 I 0.00 0.00; 0.00' 0.00 ` 0.00 0.001 0.00 0.0a! 0.00 0.00 0.00! 0.00 0.00 0.00. 0.00 0.00, 0.00 45712.00 I 0.00 Actual 0.00 0.00 0.00 0.00 6931.98 3730 48 4150.17 24482.61 6416.76: 0.00 45712.00! Funds Available 45712.00 -" 0.00 0.00 0.00!!! -6931.98. -3730.48 -4150.17 -24482.61 -6416.76 0.00 Cancel 0.00 CLEAR WIOA Reconciliation-FY19 WIOA 10% DW CWDC COUNCIL Reporting Month Program Code Tracking Sheet CLEAR Received Date Received Grant Balance September -19 4WD8000000 45,712.00 October -19 4WD8000000 3.66 45,712.00 November -19 4WD8000000 2,480.55 45,712.00 December -19 4WD8000000 1,630.17 45,712.00 December -19 "B" 4WD8000000 1,142.29 45,712.00 January -20 4WD8000000 1,675.31 6,931.98 6,931.98 3/6/2020 38,780.02 February -20 4WD8000000 3,730.48 3,730.48 3,730.48 4/23/2020 35,049.54 March -20 4WD8000000 4,150.17 4,150.17 4,150.17 5/6/2020 30,899.37 April -20 4WD8000000 24,482.61 24,482.61 24,482.61 6/20/2020 6,416.76 May -20 4WD8000000 6,416.76 6,416.76 6,416.76 7/10/2020 - June -20 4WD8000000 - July -20 4WD8000000 - August -20 4WD8000000 - Totals 45,712.00 45,712.00 45,712.00 4WD8000000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 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/6/2020 YEAR OF FUNDS Page 1 of 2 FY20 TITLE/PROGRAM/PROJECT WIOA CWDC- 10% DW COUNCIL CLEAR Program code 4WD9000000 END DATE END DATE 12/31/2020 I. CASH REQUEST 1. Total program and Admin Cash needs Previously Reported 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date ,i " 10,000.00 10,000.00 II. PROGRAM EXPENSE REPORT (ER) tr " 'b4 1. Total Expenses+Accruals Previously Reported (Through Last Month) 10,000.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 10,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 1 r 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 10,000.00 2. FINAL Expenses Through End of Contract 10,000.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes CD /No O V CASH REQUEST PROGRAM INCOME CASH REPORTED o°' 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! :'�., )i'1N)fir'� 1. FINAL Match Reported Through End of Contract 0.00 2. FINAL Expenses Through End of Contract 10,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 g/ Date / sr/2 ( Authorized Signature 8 Date AUG 1 2021 See instruction for completing this for on the next tab (Attachment H 2 of 2) frt Period '=Mar -20 Apr -20 'May -20 Jun -20_.. lAdj-20 Jul -20 Aug -20 Sep -20 Oct -20 'Nov -20 Account 15230.0000.6500.41ND9000000.0000.00000001 Funds Available ( Detail Balances ) Budget Encumbrance 0.00. 0.00;. 100C&1.00,! 0.00 0.00i 0.00! 0.00'. 0.00 0.00 0.00 0.00 10000.001 0.00 0.00 0.00 0.00 0.00 0.00 0.00; Actual 0.00 0.00; 0.001 0.001 0.00 0.00 Funds Available 0.00 10000.00 -10000.00 0.00 0.00' 0.00 0.00 10000.00' 0.00 CLEAR WIOA Reconciliation-FY20 WIOA CWDC- 10% DW COUNCIL (PIF) Reporting Month Program Code Tracking Sheet CLEAR Received Date Received Grant Balance March -20 4WD9000000 10,000.00 April -20 4WD9000000 10,000.00 May -20 4WD9000000 10,000.00 10,000.00 10,000.00 7/10/2020 - June -20 4WD9000000 - July -20 4WD9000000 - August -20 4WD9000000 - Totals 10,000.00 10,000.00 10,000.00 4WD9000000 General ledger vs billied 0.00 Billed not received 0.00 General ledger vs. received 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 Page 1 of 2 PY19 TITLE/PROGRAM/PROJECT WIOA 10% YOUTH LOCAL ADMIN CLEAR Program code 4Y69000000 END DATE END DATE 6/30/2021 I. CASH REQUEST tl"tN i 1. Total program and Admin Cash needs Previously Reported 57,544.00 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date 57,544.00 II. PROGRAM EXPENSE REPORT (ER) �u f 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) 57,544.00 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 57,544.00 III. PROGRAM INCOME(PI) EXPENSE REPORT urS 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 1. FINAL Cash Request Contract to Date 57,544.00 2. FINAL Expenses Through End of Contract 57,544.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 �; lGl 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 ItitL '' ,!-' 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 v� 'i , ,c 1,1� 1. FINAL Match Reported Through End of Contract 0.00 2. FINAL Expenses Through End of Contract 57,544.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 g /.\ 74i Authorized Signature 8 Date AUG 1 2021 See instruction for completing this for on the next tab (Attachment H 2 of 2) 02-0021-c21/9 3y PJ ) -; run Account '5230.0000.6500.4Y69000000.0000.00000000 Funds Available ( Detail Balances ) Period (Jul -19 Aug -19 __.... ;Sep -19 Oct -19 :Nov -19 Dec -19 Jan -20 (Feb -20 'Mar -20 Period May -20 Jun -20 • Adj-20 .!Jul -20 Aug -20 ,Sep -20 Oct -20 ............ Nov -20 1Dec-20 `Jan -21 Budget 57544.00 0.00 0.00; 0.00 0.00: 0.00 0.00 0.00' 0.00 57544.00 Funds Available ( Detail Balances ) Budget 0.00.; 0.00 0.00 0.00 0.001 0.00-a 0.00, 0.00' 0.00 0.00' 57544.00 Encumbrance 0.00 0.00, 0.00, 0.00, 0.00; 0.00 0.00' 0.00' 0.00; 0.00 0.001 Encumbrance 0.00, 0.00; 0.00 0.00 0.00; 0.00 0.00; 0.00' 0.00, 0.00 0.00` Actual 0.00E 0.00 0.001 0.00' 0.00 0.00 0.00 1278.60 3630.18 5035.77E 57544.00; Funds Available 57544.00 ' 000 0.00 .ti 0.00 0,00 !,r 0.00 0.00 -1278.60 -3630.18 5035.77 0.00 Cancel Account 5230.0000.6500.4Y69000000.0000.00000000 Actual Funds Available 5120.63 -5120.63 33177.26 -33177.26 0.00 0.00 8439.18 -8439.18 862.38 0.00 0.00 0.00 0.00 57544.00', 0.00 0.00 0.00 000':. 0.00 0.00 .' 0.00 CLEAR WIOA Reconciliation-PY19 WIOA 10% YOUTH LOCAL ADMIN Reporting Month Program Code Tracking Sheet CLEAR Received Date Received Grant Balance July -19 4Y69000000 57,544.00 August -19 4Y69000000 57,544.00 September -19 4Y69000000 57,544.00 October -19 4Y69000000 I 57,544.00 November -19 4Y69000000 57,544.00 December -19 4Y69000000 57,544.00 December -19 "B" 4Y69000000 57,544.00 January -20 4Y69000000 57,544.00 February -20 4Y69000000 1,278.60 1,278.60 1,278.60 4/23/2020 56,265.40 March -20 4Y69000000 3,630.18 3,630.18 3,630.18 5/6/2020 52,635.22 April -20 4Y69000000 5,035.77 5,035.77 5,035.77 6/20/2020 47,599.45 May -20 4Y69000000 5,120.63 5,120.63 5,120.63 7/10/2020 42,478.82 June -20 4Y69000000 33,177.26 33,177.26 33,177.26 8/4/2020 9,301.56 July -20 4Y69000000 9,301.56 August -20 4Y69000000 8,439.18 8,439.18 8,439.18 10/8/2020 862.38 September -20 4Y69000000 862.38 862.38 862.38 11/10/2020 (0.00) October -20 4Y69000000 (0.00) November -20 4Y69000000 (0.00) December -20 4Y69000000 (0.00) January -21 4Y69000000 (0.00) Totals 57,544.00 57,544.00 57,544.00 4Y69000000 General ledger vs billied 0.00 Billed not received 0.00 General ledger vs. received 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 7/1/2019 YEAR OF FUNDS TITLE/PROGRAM/PROJECT YOUTH MIN -75% -OUT -SCHOOL PROGRAM CLEAR Program code Page 1 of 2 PY19 4Y79000000 END DATE END DATE 6/30/2021 I. CASH REQUEST 1. Total program and Admin Cash needs Previously Reported 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date -x a -L 390,126.00 390,126,00 II. PROGRAM EXPENSE REPORT (ER) ,r(ikr, .a/E 1. Total Expenses+Accruals Previously Reported (Through Last Month) 390,126.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 390,126.00 ADMINISTRATIVE EXPENSE (ER) fi4. 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 ,ii o.,� � 1. FINAL Cash Request Contract to Date 390,126.00 2. FINAL Expenses Through End of Contract 390,126.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 �� '^(i =`earn � Ipnn�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 ... (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 ,,,g, err ,,!I;�nrt 1. FINAL Match Reported Through End of Contract 0.00 2. FINAL Expenses Through End of Contract 390,126.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 period Preparer's Signature c Date te/O!/J Authorized SignatureIll Date 8 AUG 1 2021 See instruction for completing this for on the next tab (Attachment H 2 012) c.2Do2(-oZ./9‘ 3'6 °Petrol Banes (NIB) Jun -21 Account 5230.0000.6500.4Y79000000.0000.00000000 Funds Available ( Detail Balances ) Period ;Adj-19 Jul -19 Aug -19 jSep 19 Oct 1"9 Nov -19 Dec -19 LJan-20 1Feb-20 Mar-20 Budget 0.001 388424.00;_ 0.00 0.00° 1702.001 0.00 0.00'. 0.00 0.00 0.00 390126.00 Encumbrance 0.001 0.00! 0.00 0.001 0.001 0.001 0.001 0.00 0.00 0.00! Actual Funds Available 0.00 0.00 0.00 388424.00 0.00 0.00 0.00 0.00 38646.78 -36944.78 21297.11 -21297.11. 17275.52 -17275.52 44377.52 -44377.52'. 34548.04 -34548.04 22250.42 -22250.42,: 0.00= 306213.00; 83913.00 Cancel eno (PJ t ),, n-21 Account 5230.0000.6500.4Y79000000.0000.00000000 Period 1May-20 (Jun -20 Adj-20 ;Jul -20 Aug -20 Sep -20 ;Oct -20 'Nov -20 ;Dec -20 Funds Available ( Detail Balances ) Budget 0.00 0.00 _.. 0.00 0.00- 0.00 0.00 0.00 0,00; 0.00 0.00 390126.00 Encumbrance 0.00. 0.00 0.00 0.00 0.00 0.00 0.00 0.00`. 0.00 0.00 Actual 34719.62' ............. 25876.22 33302.89 0.00 .............. . 23457.77; 10461.11 0.00: 0.00, 0.00 0.00'. Funds Available -34719.62' -25876.22.. -33302.89 0.00 -23457.77 -10461.11, 0.00 0.00 0.00 0.00 306213,00! 83913.00 Cancel Account 35230.0000.6500.4Y79000000.0000.00000000 Funds Available ( Detail Balances ) Period !Sep -19 Oct -19 Nov -19 iDec-19 Jan -20 Feb -20 0.00 Account ;5230.0000.6500.4Y79000000.0000.00000000 Period ;Jul -20 Aug -20 Sep -20 Oct -20 Nov -20 !!Dec -20 !Jan -21 Feb -21 ,Mar -21 Apr -21 Budget 0.001 0.00` • 0.00;_. 0.00:.. 0.00 0.00 Funds Available ( Detail Balances ) Budget 0.00, 0.00: 0.00 0.00' 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Encumbrance 0.00 0.00 0.00 0.001 0.00 0.00! 0.00. 0.00! 0.00' 0.00 0.00 Encumbrance 0.00: 0.001 0.00, 0.001 000; 0.001 0.00':: 0.00' 0.00-, 0.00` 0.00 Actual Funds Available 0.00: 0.00x: 5735.83; -5735.83 6143.77 -6143.77. 5881.74 -5881.74., 6091.28 -6091.2 6711.33 -6711.33 6550.21 -6550.21 2182.34' -2182.34 7568.72' -7568.72'- 8716.48 -8716.48 83913.00 -83913.00 Actual 2795.71 16277.52 9258.07, 0.001 0.00E 0.00! 0.00_; 0.00- 0.00: 0.00 83913.00 Cancel Funds Available -2795.71 W -16277.52 -9258.07 0.00 0.00 0.00] 000 0.00 0.00 0.00 -83913.00 Cancel CLEAR WIOA Reconciliation-PY19 WIOA YOUTH MIN -75% -OUT -SCHOOL LOCAL PROGRAM Reporting Month Program Code Tracking Sheet CLEAR Received Date Received Grant Balance July -19 4Y79000000 390,126.00 August -19 4Y79000000 390,126.00 September -19 4Y79000000 390,126.00 October -19 4Y79000000 38,646.78 38,646.78 38,646.78 12/12/19 351,479.22 November -19 4Y79000000 21,297.11 21,297.11 21,297.11 1/13/20 330,182.11 December -19 4Y79000000 17,275.52 17,275.52 17,275.52 2/5/20 312,906.59 December -19 "B" 4Y79000000 21,766.43 312,906.59 January -20 4Y79000000 22,611.09 44,377.52 44,377.52 3/6/20 268,529.07 February -20 4Y79000000 34,548.04 34,548.04 34,548.04 4/23/20 233,981.03 March -20 4Y79000000 22,250.42 22,250.42 22,250.42 5/6/20 211,730.61 April -20 4Y79000000 34,719.62 34,719.62 34,719.62 6/20/20 177,010.99 May -20 4Y79000000 25,876.22 25,876.22 25,876.22 7/10/20 151,134.77 June -20 4Y79000000 33,302.89 33,302.89 33,302.89 8/4/20 117,831.88 July -20 4Y79000000 23,457.77 23,457.77 23,457.77 9/8/20 94,374.11 August -20 4Y79000000 10,461.11 10,461.11 10,461.11 10/8/20 83,913.00 September -20 4Y79000000 83,913.00 October -20 4Y79000000 83,913.00 November -20 4Y79000000 83,913.00 December -20 4Y79000000 83,913.00 January -21 4Y79000000 83,913.00 Totals 306,213.00 306,213.00 306,213.00 4Y79000000 General ledger vs bullied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 CLEAR WIOA Reconciliation-PY19 WIOA YOUTH MIN -75% -OUT -SCHOOL LOCAL PROGRAM Reporting Month Program Code Tracking Sheet CLEAR Received Date Received Grant Balance July -19 4Y79000000 83,913.00 August -19 4Y79000000 83,913.00 September -19 4Y79000000 83,913.00 October -19 4Y79000000 5,735.83 5,735.83 5,735.83 12/12/19 78,177.17 November -19 4Y79000000 6,143.77 6,143.77 6,143.77 1/13/20 72,033.40 December -19 4Y79000000 5,881.74 5,881.74 5,881.74 2/5/20 66,151.66 December -19 "B" 4Y79000000 659.98 66,151.66 January -20 4Y79000000 5,431.30 6,091.28 6,091.28 3/6/20 60,060.38 February -20 4Y79000000 6,711.33 6,711.33 6,711.33 4/23/20 53,349.05 March -20 4Y79000000 6,550.21 6,550.21 6,550.21 5/6/20 46,798.84 April -20 4Y79000000 2,182.34 2,182.34 2,182.34 6/20/20 44,616.50 May -20 4Y79000000 7,568.72 7,568.72 7,568.72 7/10/20 37,047.78 June -20 4Y79000000 8,716.48 8,716.48 8,716.48 8/4/20 28,331.30 July -20 4Y79000000 2,795.71 2,795.71 2,795.71 9/8/20 25,535.59 August -20 4Y79000000 16,277.52 16,277.52 16,277.52 10/8/20 9,258.07 September -20 4Y79000000 9,258.07 9,258.07 9,258.07 11/10/20 (0.00) October -20 4Y79000000 (0.00) November -20 4Y79000000 (0.00) December -20 4Y79000000 (0.00) January -21 4Y79000000 (0.00) Totals 83,913.00 83,913.00 83,913.00 4Y79000000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 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/2019 YEAR OF FUNDS TITLE/PROGRAM/PROJECT YOUTH MAX -25% -IN -SCHOOL PROGRAM CLEAR Program code Closeout Part 3 Page 1 of 2 PY19 4Y89000000 END DATE END DATE 6/30/2021 I. CASH REQUEST 1. Total program and Admin Cash needs Previously Reported 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date o 129,474.00 129,474.00 II. PROGRAM EXPENSE REPORT (ER) AA , :: ) ; I . 1. Total Expenses+Accruals Previously Reported (Through Last Month) 129,474.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 129,474.00 ADMINISTRATIVE EXPENSE (ER)o„U " „tM'' 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 A ,n 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 '"'.� E�-r�� , Lal¢ 1, FINAL Cash Request Contract to Date 129,474.00 2. FINAL Expenses Through End of Contract 129,474.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes m /No O V CASH REQUEST PROGRAM INCOME CASH REPORTED GA -- '. 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 )it,,,'..-I-A0 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 AO, ABIA d drrG _ . 1. FINAL Match Reported Through End of Contract 0.00 2. FINAL Expenses Through End of Contract 129,474.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 f f,r1 2% I0pa!'V101 Authorized Signature Date AUG 18 2021 See instruction for completing this for on the next tab (Attachment H 2 of 2) .446.2/- c2i/9‘ 3`1" Account 5230.0000.6500.4Y89000000.0000.00000000 Period 'Dec -18 1Jan-19� 'Feb -19 ;Mar -19 Apr -19 ........... ;May -19 Jun -19 Adj-19 „Jul -19 en* d.Baiance (PJTD) - Jun -21 Funds Available ( Detail Balances ) Budget 0.001. 0.001 0.00.; ... 0.001 0.00 0.00'. 0,00! 0.001 129474.00 Encumbrance 0.00! 0.00 _.. 0.©0;_. 0.001 0.00 0.00 0.00 0.00 0.00. 0.00 0.00 Actual Funds Available 0.00': 0.00 - 0.0Q', 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.00 0 001: 129474 00 0.00 0.00 60398.21 69075.79 ontt Account 15230.0000.6500.4Y89000000.0000.00000000 00.4Y890fl0000.0000.fl00000 0 Period 'Sep -19 ;Oct -19 ;Nov -19 .Dec -19 lJan-20 'Feb -20 Mar -20 :Apr -20 ,May -20 f Funds Available ( Detail Balances ) Budget 0.00 0.001 0.00 0.001 0.001 0.001 0.0013...__ 0.001 0.00T Q o0,• 0.00, 0.00,; 129474.00 Encumbrance 0.001 0.001 0.001,- 0.00`.;. 0.00? 0.00' 0.00: 0.00' Actual 0.00, ._ 0.001 0.00 0.00 0.00 0.00 �._. 0.00 0.00 .. 0.00 15304.58 0.00;, 60398.21: Funds Available 000 000 0.00 • 000a, 0.00 0.001 0.00 0.00; -15304.58: 69075.79 Cancel Sep -20 °'P nod a ►tGe k (PJT) w Jui Account Period Adj-20 ?Jul 20 „Aug -20 Oct 20 iNov-20 Dec -20 Jan -21 .............. ;Feb -21 Mar -21 5230.0000.6500.4Y89000000.0000.00000000 Funds Available ( Detail Balances ) Budget 0.00 0.00 0.00. 0.00 0.00 0.00 0.00 0,00 !. 0.00 0.00. 129474.00 Encumbrance 0.00. 0.00,; 0.00i 0.00I 0.00i 0.001 0.00 0.00 0.001 0.001 0.00 Actual Funds Available 0.40' 0.00 -- 5076.07 -5076.07 5383.50 -5383.50 4051.43 -4051.4 6180.31 -6180.31 6991.64 -6991.64 7800.65 -7800.65 4420.07 -4420.07', 5189.96 5189.96, 0.00' 0.00;:' 60398.21 69075.79 Cancel :PJTQ) . Jurr Account 15230.0000.6500.4Y89000000.0000.00000000 Period ;Sep -1'5 lOct-19 INov-19 ;Dec -19 'Jan -20 Feb -20 Mar -20 Apr -20 'May -20 ;Jun -20 Funds Available ( Detail Balances ) Budget 0.00 0.00; 0.00' 0.00, 0.00' 0.00' 0.00 0.00 0.00 0.00 Encumbrance 0.00; 0.00' 0.00i 0.00 0.00 Actual 0.00: 11052.00 2220.98 3596.12 2261.56 -51.98 2548.03 393.12 1729.46 5158.99 Funds Available 0.00__ -11052.00 -2220.98 -3596.12 -2261.56 51.98 -2548.03 -393.12 -1729.46 -5158.99 69075.79 -69075.79 Cancel iod Account 5230.0000.6500.4Y89000000.0000.00000000' Period Jul -20 Aug -20 ,Sep -20 Oct -20 Nov -20 Dec -20 IJan-21 [Feb -21 [Mar -21 Funds Available ( Detail Balances ) Budget 0.00' 0.00 ' 0.00 0.00 0.00 0.00 0.00 0.00' Encumbrance • 0.00: o.aol 0.00 0.00' 0.00; 0.00; Actual 000: 4591,89 12876.141 4946.78 4335 10 1296.04; 3966.81; 6661.40; 1493.35 0.00;, 69075.79 Funds Available 0.00 -4591.89°.' -12876.14 -4946.78. -4335 10 -1296.04 -3966.81 -6661.40 -1493.35 CLEAR WIOA Reconciliation-PY19 WIOA YOUTH MAX -25% -IN -SCHOOL LOCAL PROGRAM Reporting Month Program Code Tracking Sheet CLEAR Received Date Received Grant Balance July -19 4Y89000000 129,474.00 August -19 4Y89000000 129,474.00 September -19 4Y89000000 129,474.00 October -19 4Y89000000 129,474.00 November -19 4Y89000000 129,474.00 December -19 4Y89000000 129,474.00 December -19 "B" 4Y89000000 129,474.00 January -20 4Y89000000 129,474.00 February -20 4Y89000000 129,474.00 March -20 4Y89000000 129,474.00 April -20 4Y89000000 129,474.00 May -20 4Y89000000 129,474.00 June -20 4Y89000000 15,304.58 15,304.58 15,304.58 8/4/20 114,169.42 July -20 4Y89000000 5,076.07 5,076.07 5,076.07 9/8/20 109,093.35 August -20 4Y89000000 5,383.50 5,383.50 5,383.50 10/8/20 103,709.85 September -20 4Y89000000 4,051.43 4,051.43 4,051.43 11/10/20 99,658.42 October -20 4Y89000000 6,180.31 6,180.31 6,180.311 12/10/20 93,478.11 November -20 4Y89000000 6,991.64 6,991.64 6,991.64 1/8/21 86,486.47 December -20 4Y89000000 7,800.65 7,800.65 7,800.65 2/1/21 78,685.82 January -21 4Y89000000 4,420.07 4,420.07 4,420.07 3/12/21 74,265.75 February -21 4Y89000000 5,189.96 5,189.96 5,189.96 4/13/21 69,075.79 March -21 4Y89000000 - 69,075.79 April -21 4Y89000000 69,075.79 May -21 4Y89000000 69,075.79 June -21 4Y89000000 69,075.79 Totals 60,398.21 60,398.21 60,398.21 4Y89000000 General ledger vs billied 0.00 Billed not received 1 0.00 General ledger vs. received 0.00 CLEAR WIOA Reconciliation-PY19 WIOA YOUTH MAX -25% -IN -SCHOOL LOCAL PROGRAM Reporting Month Program Code Tracking Sheet CLEAR Received Date Received Grant Balance July -19 4Y89000000 69,075.79 August -19 4Y89000000 1,389.21 69,075.79 September -19 4Y89000000 3,838.87 69,075.79 October -19 4Y89000000 2,435.46 11,052.00 11,360.69 12/12/19 58,023.79 November -19 4Y89000000 2,220.98 2,220.98 1,912.29 1/13/20 55,802.81 December -19 4Y89000000 3,596.12 3,596.12 3,596.12 2/5/20 52,206.69 December -19 "B" 4Y89000000 709.82 52,206.69 January -20 4Y89000000 1,551.74 2,261.56 2,261.56 3/6/20 49,945.13 - February -20 4Y89000000 3,336.48 (51.98) (51.98) 4/23/20 49,997.11 March -20 4Y89000000 2,548.03 2,548.03 2,548.03 5/6/20 47,449.08 April -20 4Y89000000 393.12 393.12 393.12 6/20/20 47,055.96 May -20 4Y89000000 1,729.46 1,729.46 1,729.46 7/10/20 45,326.50 June -20 4Y89000000 5,158.99 5,158.99 5,158.99 8/4/20 40,167.51 July -20 4Y89000000 4,591.89 4,591.89 4,591.89 9/8/20 35,575.62 August -20 4Y89000000 12,876.14 12,876.14 12,876.14 10/8/20 22,699.48 September -20 4Y89000000 4,946.78 4,946.78 4,946.78 11/10/20 17,752.70 October -20 4Y89000000 4,335.10 4,335.10 4,335.10 12/10/20 13,417.60 November -20 4Y89000000 1,296.04 1,296.04 1,296.04 1/8/21 12,121.56 December -20 4Y89000000 3,966.81 3,966.81 3,966.81 2/1/21 8,154.75 January -21 4Y89000000 6,661.40 6,661.40 6,661.40 3/12/21 1,493.35 February -21 4Y89000000 1,493.35 1,493.35 1,493.35 4/13/21 - Totals 69,075.79 69,075.79 69,075.79 4Y89000000 General ledger vs billied 0.00 Billed not received 0.00 General ledger vs. received 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 9/4/2019 YEAR OF FUNDS Closeout Part 3 Page 1 of 2 PY18 TITLE/PROGRAM/PROJECT 10%YOUTH CWDC COUNCIL (BD DEV) CLEAR Program code 4YW8000000 END DATE END DATE 12/31/2020 I. CASH REQUEST 1. Total program and Admin Cash needs Previously Reported 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date 42,500.00 42,500.00 II. PROGRAM EXPENSE REPORT (ER) r °.') * )i '.;',.10.,N- 1. Total Expenses+Accruals Previously Reported (Through Last Month) 42,500.00 2. Current Expenses + Accruals (Through End Date of Award) 42,500.00 3. FINAL Program Expenses Contract to Date ADMINISTRATIVE EXPENSE (ER) i 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(P1) EXPENSE REPORT ii1't' ` Ta 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 'Qit.r>. 1. FINAL Cash Request Contract to Date 42,500.00 2. FINAL Expenses Through End of Contract 42,500.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes G /No O V. CASH REQUEST PROGRAM INCOME CASH REPORTED wts 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 ,� w ,.: It '' , . 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, . , ....' t'40;4m.., )� 1. FINAL Match Reported Through End of Contract 0.00 2. FINAL Expenses Through End of Contract 42,500.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 penod Preparer's Signature ,/C' Date S /1171 f Authorized Signature Date AUG 8 2021 See instruction for completing this for on the next tab (Attachment H 2 of 2) cZeez/-02V9 3 Account 5230.0000.6500.4YW8000000.0000.0000000i Period ;Sep -19 loci -19 Nov -19 IDec-1 9 Jan -20 IFeb-20... Mar -20 Apr -20 . . May -20 Funds Available ( Detail Balances ) Budget Encumbrance 42500.00 ; 0.001 0.00'. 0.00; 0.00 0.00 0.00, 0.00 ._. 0.00 .._. 0.00 0.00 0.001 0.00 0.00; 0.00; 0.001 0.001 0.00' 0.001 Q.001 Actual 0.00 0.00 0.00 0.00 0.00 2422.62 4135.44 4238.92 21392.45. 10310.57 Funds Available 42500.00 0.00 0.00 0.00 0.00 -2422.62 -4135.44 -4238.92 -21392.45 -10310.57 r' CLEAR WIOA Reconciliation-PY18 10%YOUTH CWDC COUNCIL (8D DEV) Reporting Month Program Code Tracking Sheet CLEAR Received Date Received Grant Balance September -19 4YW8000000 42,500.00 October -19 4YW8000000 42,500.00 November -19 4YW8000000 42,500.00 December -19 4YW8000000 42,500.00 December -19 "B" 4YW8000000 42,500.00 January -20 4YW8000000 42,500.00 February -20 4YW8000000 2,422.62 2,422.62 2,422.62 4/23/20 40,077.38 March -20 4YW8000000 4,135.44 4,135.44 4,135.44 5/6/20 35,941.94 April -20 4YW8000000 4,238.92 4,238.92 4,238.92 6/20/20 31,703.02 May -20 4YW8000000 21,392.45 21,392.45 21,392.45 7/10/20 10,310.57 June -20 4YW8000000 10,310.57 10,310.57 10,310.57 8/4/20 - Totals 42,500.00 42,500.00 42,500.00 4YW8000000 General ledger vs billied 0.00 Billed not received 0.00 General ledger vs. received 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 11/23/2020 YEAR OF FUNDS TITLE/PROGRAM/PROJECT WIOA CWDC-10/YOUTH COUNCIL (PIF) CLEAR Program code Closeout Part 3 Page 1 of 2 PY19 4YW9000000 END DATE END DATE 6/15/2021 I. CASH REQUEST, p1' 1. Total program and Admin Cash needs Previously Reported 29,268.00 2. Current Program and Admin Cash Needs 3, FINAL Program and Admin Cash Needs Contract to Date 29 268.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 29,268.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 29,268.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) _ u �, _ ��VW 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 l G 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 t, „t„ 1. FINAL Cash Request Contract to Date 29,268.00 2. FINAL Expenses Through End of Contract 29,268.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 ii "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 ",aars. �' 111tilgf) 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/ 1. FINAL Match Reported Through End of Contract 0.00 2. FINAL Expenses Through End of Contract 29,268.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 I') c1 Authorized Signature 9 Date AU 2021 See instruction for completing this for on the next tab (Attachment H 2 of 2) 02o 2f-cW91 3(0 Account ;5230.0000.6500.4YW9000000.0000.00000001 Period Sep -20 Oct -20 Nov 20 Dec -20 !Jan -21 Feb -21 Mar -21 GApr-21 May -21 Jun -21 Funds Available ( Detail Balances Budget Encumbrance Actual Funds Available 000 0.00- 000 000-- 000: 0.00 000! 0.00 29268 00 0.00 0.00' 29268 00 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.00 0.00' 11862 72 11862 72 0.00 0.00 7437.37 -7437.37 0.00 0.001 3652.00; _3652.00, „ 0.00` 0.00;: 6315.91 -6315.91 _' 29268.00 0.00; 29268.00 0.00 Cancel CLEAR WIOA Reconciliation-PY19 WIOA CWDC-10%YOUTH COUNCIL Reporting Month Program Code Tracking Sheet CLEAR Received Date Received Grant Balance November -20 4YW9000000 29,268.00 December -20 4YW9000000 29,268.00 January -21 4YW9000000 29,268.00 February -21 4YW9000000 5,060.10 29,268.00 March -21 4YW9000000 6,802.62 11,862.72 11,862.72 5/10/2021 17,405.28 April -21 4YW9000000 7,437.37 7,437.37 7,437.37 6/14/2021 9,967.91 May -21 4YW9000000 3,652.00 3,652.00 3,652.00 7/8/2021 6,315.91 June -21 4YW9000000 6,315.91 6,315.91 - Totals 29,268.00 29,268.00 22,952.09 4YW9000000 General ledger vs bullied 0.00 Billed not received I 6,315.91 General ledger vs. received 6,315.91 Contract Form New Contract Request nfor ation Entity Name* Entity ID* COLORADO DEPARTMENT OF LABOR & g>00010497 EMPLOYMENT Contract Name* WORKFORCE INNOVATION AND OPPORUTNITY ACT (WIOA) GRANT CLOSEOUT FOR 2020-21 Contract Status CTB REVIEW Contract ID 5176 Contract Lead* HLOONEY ❑ New Entity? Parent Contract ID Requires Roard YES Contract Lead Email Department Project I hlooneyPhveldgov.cormcobb xxlkcAveidgov.com Contract Description* THE WIOA GRANT CLOSEOUT PACKET IS REQUIRED BY THE YEAR-END CONTRACT CLOSEOUT PROCEDURES OF COLE AND IN ACCORDANCE WITH PGL06-12-F1 FOR ALL PROGRAMS THAT HAVE EXPENDITURE AUTHORIZATIONS ENDING DURING THE PERIOD JULY 1, 2020 TO JUNE 30, 2021. Contract Description 2 PA ROUTING THROUGH NORMAL APPROVAL PROCESS. ETA TO CTB 08-12-2021. NOTE: ATTACHED SOW IS UNSIGNED DUE TO THE FACT THAT THE GRANT CLOSEOUT DOCUMENT REQUIRES WET SIGNATURE AND HAS BEEN ROUTED ACCORDINGLY AS OF 8-9-2021. Contract Type* CONTRACT Amount* $0.O0 Renewable NO Automatic Renewal ICA Department HUMAN SERVICES Department Email CM- HumanServIces@weldgov.co rn De; nt Head Email CM -Hu man Services- DeptHead` weIdgov.com County Attorney GENERAL COUNTY A I 1 ORNEY EMAIL County Attorney Email CM- COUNTYA I I ORNEY BLDG OV.COM If this is a renewal enter previous Contract ID If this is part of a MSA enter MSA Contract ID Requested BOCC Agenda Date* 08 18,3'2021 Due Date ©8114:2021 Will a work session with BOCC be required?* NO Does Contract require Purchasing Dept. to be included? Note: the Previous Contract Number and Master Services Agreement Number should be left blank if those contracts are not in On Base Contract Dates Effective Date Termination Notice Period Contact Information Contact Info Contact Name Purchasing Approval Process Department Head JAMIE ULRICH DH Approved Date 08;10//2021 Final Approval EOCC Signed Date BOCC Agenda Date 08;` 18 t 2021 Originator HLOONEY Review Date* 04:`29;'2022 Committed Delivery Date Contact Type Contact Email Finance over BARE CONNOLLY Finance Appr 08/11 .'2021 Renewal Date Expiration Date* 06;30/2022 Contact Phone ll Contact Phone 2 Purchasing Approved Date Tyler Ref AG 081 821 Legal Counsel GABE KALOUSEK Legal Counsel =;aroved Date 08;`12,a 2021 Hello