The URL can be used to link to this page

Browse Search

Home My WebLink About20193780.tiffRESOLUTION RE: APPROVE GRANT CLOSEOUT FOR VARIOUS WORKFORCE INNOVATION AND OPPORTUNITY ACT (WIOA) PROGRAMS AND AUTHORIZE CHAIR TO SIGN WHEREAS, the Board of County Commissioners of Weld County, Colorado, pursuant to Colorado statute and the Weld County Home Rule Charter, is vested with the authority of administering the affairs of Weld County, Colorado, and WHEREAS, the Board has been presented with a Grant Closeout document for Various Workforce Innovation and Opportunity Act (WIOA) Programs from the County of Weld, State of Colorado, by and through the Board of County Commissioners of Weld County, on behalf of the Department of Human Services, Employment Services of Weld County, to the Colorado Department of Labor and Employment, for all programs that have Expenditure Authorizations ending during the period of July 1, 2018, through June 30, 2019, with further terms and conditions being as stated in said grant closeout checklist, and WHEREAS, after review, the Board deems it advisable to approve said grant closeout document, 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 document for Various Workforce Innovation and Opportunity Act (WIOA) Programs from the County of Weld, State of Colorado, by and through the Board of County Commissioners of Weld County, on behalf of the Department of Human Services, Employment Services of Weld County, to the Colorado Department of Labor and Employment, be, and hereby is, approved. BE IT FURTHER RESOLVED by the Board that the Chair be, and hereby is, authorized to sign said grant closeout. ac : F-ISD, 4ACTC8C/C D) ,9- / 7- /9 2019-3780 H R0090 RE: GRANT CLOSEOUT 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 21st day of August, A.D., 2019. BOARD OF COUNTY COMMISSIONERS WD COUNTY, COLO A DO ATTEST: ddavo 'C j(10,4;4, Weld County Clerk to the Board BY: Deputy Clerk to the Board APP • v'ED AS I orney Date of signature: Og/2c(/1 Barbara Kirkmeyer, C air Mike Fi.aro- Sean P/ onway cott K. James 2019-3780 H R0090 Con+ract =J 4- 33 1 PRIVILF.GFD AND CONFIDFNTIAL MEMORANDUM DATE: August 14, 2019 TO: Board of County Commissioners — Pass -Around FR: Judy A. Griego, Director, Human Services RE: 2018-19 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' 2018-19 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 in accordance with their Policy Guidance Letter #06-12-F1, for all programs that have Expenditure Authorizations ending during the period of July 1, 2018 through June 30, 2019. 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 23, 2019. I do not recommend a Work Session. I recommend approval and submission of this Grant Closeout and authorize the Chair to sign. Sean P. Conway Mike Freeman, Pro -Tern Scott James Barbara Kirkmeyer, Chair Steve Moreno Approve Schedule Recommendation Work Session Vi('r ()mad) Other/Comments: Pass -Around Memorandum; August 14, 2019 — CMS 3087 cc. HSO O n fge, 2019-3780 !—HROOCO Karla Ford From: Sent: To: Subject: Barbara Kirkmeyer Thursday, August 15, 2019 10:59 AM Karla Ford Re: PA FOR ROUTING: WIOA Grant Closeout (CMS 3087) Approve Sent from my iPhone On Aug 15, 2019, at 7:49 AM, Karla Ford <kford@weldgov.com> wrote: Please advise if you approve recommendation. Karla Ford X Office Manager, Board of Weld County Commissioners 1150 0 Street P.O. Box 758, Greeley, Colorado 80632 :: 970.336-7204 :: kford@weldgov.com :: www.weldgov.com My working hours are Monday -Thursday 7:00a.m.-4:00 p.m. Friday 7:00a.m. - Noon <image001.jpg> Confidentiality Notice: This electronic transmission and any attached documents or other writings ore intended only for the person or entity to which it Is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. If you have received this communication in error, please immediately notify sender by return e-mail and destroy the communication. Any disclosure, copying, distribution or the taking of any action concerning the contents of this communication or any attachments by anyone other than the named recipient is strictly prohibited. From: Tobi Cullins <cullinta@weldgov.com> Sent: Wednesday, August 14, 2019 10:19 AM To: Cheryl Hoffman <choffman@weldgov.com>; Karla Ford <kford@weldgov.com> Cc: Barb Connolly <bconnolly@weldgov.com>; Bruce Barker <bbarker@weldgov.com>; Esther Gesick <egesick@weldgov.com>; HS Contract Management <HS-ContractManagement@co.weld.co.us>; Jamie Ulrich <ulrichii@weldgov.com>; Judy Griego <griegoia@weldgov.conv; Lennie Bottorff <bot tort l @we ldgov. co m> Subject: RE: PA FOR ROUTING: WIOA Grant Closeout (CMS 3087) My apologies; here you go. Regards, Tobi A. Cullins Contract Management and Compliance Coordinator Administration Support Unit (ASU) Contract Management Team: 970-400-6556 Direct: 970-400-6392 Fax: 970-353-5215 cullinta@weldgov.com 1 ktlaPi CDLE COLORADO Department of Labor and Employment Finance: 633 17th Street, Suite 1100, Denver, CO 80202-3660 Colorado Department of Labor and Employment Grant Closeout Check List Workforce Region / CLEAR Entity Code: Employment Services of Weld County - 5230 Address: PO Box 1805, Greeley, CO 80632 Director: Tami Grant Phone Number: 970-400-5754 Fiscal Manager: Leonard Bottorff Phone Number: 970-400-6537 Master Grant/Contract Agreement Number: CMS /#54599 Final Due Dates: The fourth Friday of August 2019 (Aug 23, 2019) CLOSEOUT SUMMARY CHECK LIST: Please list all the funds with the period of performance ends in June 30th, 2019 (please do the attachment if applicable): Program Year CLEAR Program Code CLEAR Program Code Title/Grant Budget Actual FFY17 1647 LABOR CERTIFICATION 7,563.90 7,563.90 PY16 2056 WAGNER PEYSER 514,519.00 514,519.00 PY17 2057 WAGNER PEYSER 90% TO COUNTY ALLOCATION 444,846.00 444,846.00 FFY18 20D8 DISABLED VETS OUTREACH PROG 17,384.00 17,384.00 PY17 2M57 MIGRANT SSNL WRKR 37,506.00 37,506.00 PY17 2S57 SUMMER JOB HUNT 40,000.00 40,000.00 SFY19 2W29 EMPLOYMENT SUPPORT FUND 359,116.00 359,116.00 PY18 46A7 WIOA ADULT LOCAL ADMIN 21, 397.00 21, 397.00 FFY18 46D7 DISLOCATED WORKER ADMIN 21,411.00 21,411.00 FFY18 47D7 WIOA 25% DW ENHANCED ADMIN 13,920.00 13,920.00 FFY18 48A7 WIOA ADULT LOCAL PROGRAM 401,256.00 401,256.00 FFY18 48D7 WIOA DISLOCATED WORKER PROG 192,694.00 192,694.00 FFY17 49D6 WIOA 25% DW ENHANCED PROG 103,907.00 103,907.00 FFY18 49D7 WIOA 25% DW ENHANCED PROG 125,285.00 125,285.00 PY17 4A67 WIOA ADULT 10% ADULT ADMIN 3,045.00 3,045.00 PY17 4A87 WIOA ADULT PROGRAM 57,861.00 57,861.00 FFY18 4BD7 WIOA DW ADMIN TRANSFER TO ADULT 20,874.00 20,874.00 If you have any questions or need assistance, please do not hesitate to contact: Sung Hong (phone: 303-318-8108 or e-mail: Sung.Honq@state.co.us), Paul Chavez (phone: 303-318-8102 or email: PaulD.Chavez@state.co.us), Bryce Green (phone: 303-318-8119 or email:Bryce.Green@state.co.us) �l�-37�S0 COLORADO Department of Labor and Employment Finance: 633 17th Street, Suite 1100, Denver, CO 80202-3660 CDLE PY17 4D67 WIOA DW 10% COUNTY ADMIN 3,918.00 3,918.00 PY17 4D87 WIOA DW PROGRAM 35,261.00 35,261.00 PY17 4DB7 WIOA DW ADMIN TRANSFER TO ADULT ADMIN 3,917.00 3,917.00 PY17 4DN7 WIOA DW PROGRAM TRANSFER TO ADULT 35,261.00 35,261.00 FFY17 4FH6 WFD APPRENTICESHIP 3,000.00 3,000.00 FFY18 4ND7 WIOA DW PROGRAM TRANSFER TO ADULT 187,872.00 187,872.00 FFY17 4PD6 WIOA 25% DW ENHANCED PROG TRANSFER TO 25% ADULT WORK - BASED LEARNING 44,000.00 44,000.00 PY17 4WD7 TA -LOCAL WORKFORCE DEVELOPMENT BOARDS 7,500.00 7,500.00 PY17 4Y67 WIOA YOUTH 10% COUNTY ADMIN 30,055.00 30,055.00 PY17 4Y77 WIOA YOUTH OUT OF SCHOOL 426,021.00 426,021.00 PY17 4Y87 WIOA YOUTH IN SCHOOL 142,006.00 142,006.00 PY16 4YW6 PERFORMANCE INCENTIVE FUND 48,265.00 48,265.00 Total $3,349,660.90 $3,349,660.90 I. ESF fund (CLEAR PROGRAM CODE 2W2900000) must be invoiced to CDLE by July 10th, 2019 in CLEAR by Journal Voucher UPLOAD. II. All the PROGRAM CODES from the CLOSEOUT SUMMARY CHECK LIST (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 screen shot of Fund 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 CLEAR program code & program year (program funding source), which was used to purchase physical inventory. If you have any questions or need assistance, please do not hesitate to contact: Sung Hong (phone: 303-318-8108 or e-mail: Sung.Honq@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) COLORADO Department of Labor and Employment Finance: 633 17th Street, Suite 1100, Denver, CO 80202-3660 IV. Each Program Year (PY) and funding stream listed above will have the following forms completed: CDLE • 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 2019; Report Type - PJTD) Please use the forms sent via email do not reference the attachments from PGL website. All attachment E, F, H and I are in the spreadsheet named: ACCT-PGL-FIN-2019-08 Subrecipient- Fanancial -Producefures-attach-02-Closeout Package.xls. Please attach appropriate supportive documents with Attachment E, F, H and I. It is optional to transpose information to Attachment E, F, H, and I upon subrecipeint's decision. Please submit the Grant Closeout Check List and Sub -recipient 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 month 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: Date Barbara Kirkmeyer, Chair Board of County Commissioners, Weld County, Colorado If you have any questions or need assistance, please do not hesitate to contact: Sung Hong (phone: 303-318-8108 or e-mail: Sung.Honu@state.co.us), Paul Chavez (phone: 303-318-8102 or email: PauID.Chavez@state.co.us), Bryce Green (phone: 303-318-8119 or email:Bryce.Green@state.co.us) aol°I-31SO - 1 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT EMPLOYMENT AND TRAINING PROGRAMS PROGRAM INCOME EXPENSE REPORT FORM (PIERF) SUBRECIPIENT: Employment Services of Weld County Part 1 Page 1 of 2 Calendar Qrtr End Date: June 30, 2019 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: CLEAR Program code Total Program Income Disbursed Prog Income (Expended) Net (Undisbursed) Program Income None 0.00 Total 0.00 CERTIFICATION: 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0, 00 0.00 I ce, ify to the best of my knowledge,and belief the above reported information is accurate and complete for the period reported. uthorizetl Signature See instructions for completing this form on the next tab (Attachment E 2 of 2) Date &O1G1 -3180 - `o COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT EMPLOYMENT AND TRAINING PROGRAMS PROGRAM INCOME EXPENSE REPORT FORM (PIERF) Part 1 Page 2 of 2 Instructions for Completing the Program Income Expense Report Form (PIERF): Subrecipient: Enter the subrecipient's name that generated the program income Calendar Quarter End Date: Enter the quarter end date in which the program income was generated CLEAR Program code: CDLE created CLEAR program code for Program Income Expense Report Form. Enter the number of the CLEAR Program code if known. 1. CLEAR Program code: Enter program code from CLEAR that the net generated prigram income was reported 2. Program Income Allocation- Cost Category (ies)/Budget Line Item (s): Enter the cost categories/budget line items that the amount reported on the Program Income Line Item will be allocated. Program Income Allocation - Income Amount: Enter the Income Budgeted amount for the expnditure of each cost category (ies)/budget line item (s) for the reporting quarter Program Income Allocation - Disbursed Income Expense: Enter the amount expended against the cost category (ies)/budget line item (s) through the reported calendar quarter end date. Total Net Program Income: Total progam Income amount and Income Disbursed/Expense columns. The Total Net Program Income is program income earned but not expended The Amounts should equal the amount recorded in the Cash Request Line Item Amount. Authorised Signature and Date: Optional signature for subrecipient's reference. COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT EMPLOYMENT AND TRAINING PROGRAMS STAND-IN COST REPORT FORM (SICRF) SUBRECIPIENT: Employment Services of Weld County Closeout Part 2 Page 1 of 3 Incurred During Program Year Ended: June 30, 2019 CLEAR Program code: CMS #54599 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 PY18 - - PY17 - PY16 GRANT NAME WIOA Dislocated Workers Current Prior Year Before Prior PY18 PY17 PY16 - GRANT NAME WIOA Youth Current Prior Year Before Prior PY18 - - PY17 PY16 - - GRANT NAME WIOA 10% Statewide Actv. Current Prior Year Before Prior PY18 - PY17 PY16 - - GRANT NAME WIOA Local Admin. Current Prior Year Before Prior PY18 PY17 PY16 GRANT NAME WIOA 25% Enh. DWAdmin Current Prior Year Before Prior PY18 - - PY17 - PY16 - - GRANT NAME WIOA 25% Enh. DW Program Current Poor Year Before Prior PY18 - - PY17 PY16 GRANT NAME WIOA 25% Innovaty. Prof. Current Prior Year Before Prior PY18 - PY17 - PY16 - - CERTIFICATION: I certify to the best of my knowledge and belief the above reported information is accurate and complete for the period reported. /Ca -AM A — Authorized Signature r Alin rn L• L Date aot I-31 O - 3 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT EMPLOYMENT AND TRAINING PROGRAMS STAND-IN COST REPORT FORM (SICRF) SUBRECIPIENT: Employment Services of Weld County Closeout Part 2 Page 2 of 3 Incurred During Program Year Ended: June 30, 2019 CLEAR Program code: CMS #54599 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 PY18 - - PY17 - PY16 GRANT NAME WP 10% SJH Current Prior Year Before Prior PY18 - - PY17 - PY16 GRANT NAME Vets DVOP Current Prior Year Before Prior PY18 - - PY17 - PY16 GRANT NAME Vets LVER Current Prior Year Before Prior PY18 - - PY17 - PY16 GRANT NAME Ul Reemp/oyement Svc Current Prior Year Before Prior PY18 - - PY17 PY16 GRANT NAME Unemployment Ins. Current Prior Year Before Prior PY18 - - PY17 - PY16 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) Date &C tct 31 O - `1 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part 2 Page 3 of 3 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. 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 SUBRECIPIENT CERTIFICATION OF PHYSICAL INVENTORY Subrecipient Name: Employment Services of Weld County Contact Person: Leonard Bottorff Address: PO Box 1805 Phone Number: 970-400-6537 Greeley CO 80632 I hereby certify that all property/equipment previously purchased with or transferred from the Workforce Investment Act (WIA), Comprehensive Employment and Training Act (CETA), or the Job Training Partnership Act (JTPA) program to the Workforce Innovation and Opportunity Act (WIOA) programs or purchased under any Colorado Department of Labor and Employment (CDLE) federally funded grant or transferred with the CDLE's approval is included in the attached listing for the above -noted subrecipient. The attached listing has been verified by a physical inventory. Changes/revisions are: 0 Noted 2 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. �C.C1d _ A - Subrecipien Director's Si, nature :ALT r 7 019 Date Closeout Part 4 Page 1 of 6 00 19 -5 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 : 20D8000000 , 2M57000000 46D7000000 47D7000000 49D7000000 4A67000000 4D87000000 4DB7000000 4PD6000000 4WD7000000 4YW6000000 CMS #54599 1647000000 2056000000 2S57000000 2W29000000 48A7000000 48D7000000 4A87000000 4BD7000000 4DN7000000 4FH6000000 4Y67000000 4Y77000000 , including the 2057000000 46A7000000 49D6000000 4D67000000 4ND7000000 4Y87000000 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. Employers 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 O ll(J t , 2019. Closeout Part 4 Page 2 of 6 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT GRANT CLOSEOUT TAX CERTIFICATION In the performance of WDP Master Agreement Number CMS #54599 , including the Expenditure Authorizations (EAs)/Workplan allocated under above Agreement number as CLEAR Program Code : 1647000000 2056000000 20D8000000 2M57000000 2S57000000 2W29000000 46D7000000 47D7000000 48A7000000 48D7000000 49D7000000 4A67 000000 4A87000000 4BD7000000 4D87000000 4DB7000000 4DN7000000 4PD6000000 4WD7000000 4Y67000000 4YW6000000 4FH6000000 4Y77000000 2057000000 46A7000000 49D6000000 4D67000000 4N D7000000 4Y87000000 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 By , 2019. Authorized Signature Barbara Kirkmeyer, Chair Title Weld County Board of Commissioners Closeout Part 4 Page 2 of 6 GRANT RECIPIENT'S ASSIGNMENT OF REFUNDS, REBATES, AND CREDITS Grant Recipient's Name: Employment Services of Weld County WDP Master Agreement No: CMS #54599 Street Address: PO Box 1805 City and State: Greeley CO 80632 Pursuant to the terms of WDP Master Agreement Number Expenditure Authorizations (EAs)/Workplan awarded under Agreement, identified as CLEAR Program code(s) : 1647000000 20D8000000 2M57000000 2S57000000 46D7000000 47D7000000 48A7000000 49D7000000 4A67000000 4A87000000 4D87000000 4DB7000000 4DN7000000 4PD6000000 4WD7000000 , 4Y67000000 4YW6000000 2056000000 2W290 00000 48D7000000 4B D7000000 4FH6000000 4Y77000000 , including the 2057000000 46A7000000 49D6000000 4D67000000 4ND7000000 4Y87000000 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: 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 01 5'+' day of O�,tJqrV , 2019. Auth.irized Signat e Title Barbara Kirkmeyer, Chair, County Commissioners 21119 Closeout Part 4 Page 3 of 6 0019 -314-o - c 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 Sfi O/ I day of , 2019. Authorized Signature — AUK;: 1 . arbara Kirkmeyer Title Chair, County Commissioners Closeout Part 4 Page 4 of 6 0019-31go COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT GRANT RECIPIENT'S RELEASE Grant Recipient's Name:Grant Recipient's Name: Employment Services of Weld County Address: PO Box 1805, Greeley CO 80632 Closeout Part 4 Page 5 of 6 Pursuant to the terms of WDP Master Agreement Number CMS #54599 , including the Expenditure Authorizations (EAs)/Workplan awarded under said WDP Master Agreement, as CLEAR Program code (s): 1647000000 2056000000 , 2057000000 20D8000000 2M57000000 2S57000000 2W29000000 46A7000000 4607000000 4707000000 48A7000000 48D7000000 4906000000 4907000000 4A67000000 4A87000000 4BD7000000 4O67000000 4O87000000 4087000000 4DN7000000 4FH6000000 4ND7000000 4PD6000000 4WD7000000 4Y67000000 4Y77000000 4Y87000000 4YW6000000 and in consideration of the sum of Total amount paid of $3,349,660.90 and payable of $0.00 ($ of Unclaimed Checks Total) under the said Contract to (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. Specified claims in stated amounts or in estimated amounts where the amounts are not susceptible of exact statement by the Grant Recipient, as follows( if none, so state): CLEAR Program Code Invoice Date (If Known) Vendor Invoice or P.O. # Line Item Cost Category Amount Expected Payment Amount None Claims, together with reasonable expenses incidental thereto, based upon the liabilities of the Grant Recipient to third parties arising out of the performance of the said contract, which are not known to the Grant Recipient on the date of the execution of this release and of which the Grant Recipient gives notice in writing to the CDLE within the period specified in the said Contract/Grant Agreement. Claims after closeout, for costs which results from the liability to pay Unemployment Insurance costs under a reimbursement system or to settle Worker's Compensation claims. This release has been executed this 1st day of S+ , 2019. Auth.rized Signature Title Barbara Kirkmeyer, Chair, County Commissioners 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 None 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 ( S+ day of Auth on ed Signature Title Barbara Kirkmeyer, Chair, County Commissioners 00(9-37'60 - 9 August 12, 2019 WFD Regional Budget Report Report Type: PJTD Entity: 5230 Program Program Description Activity Budget Amount Actual Amount Balance 1647000000 LABOR CERTIFICATION FFY17 Not Used(0000) 7,563.90 7,563.90 0 1648000000 LABOR CERTIFICATION FFY18 Not Used(0000) 7,564.00 4,846.45 2,717.55 17C6000000 NON-WIOA-TAA CASE MANAGEMENT FFY16 Not Used(0000) 5,400.00 5,400.00 0 17C7000000 NON-WIOA-TAA CASE MANAGEMENT FFY17 Not Used(0000) 13,631.00 12,599.96 1,031.04 17C8000000 NON-WIOA-TAA CASE MANAGEMENT FFY18 Not Used(0000) 11,869.00 0 11,869.00 2054000000 PY14 WAGNER PEYSER Not Used(0000) 216,631.68 216,631.68 0 2055000000 PY15 WAGNER PEYSER Not Used(0000) 531,185.00 531,185.00 0 2056000000 PY16 WAGNER PEYSER Not Used(0000) 514,519.00 514,519.00 0 2057000000 WFD-ES-WAGNER PEYSER 90% TO COUNTY ALLCOATION Not Used(0000) 444,846.00 444,846.00 0 2058000000 PY18-WAGNER PEYSER 90% LOCAL -WP Not Used(0000) 428,906.00 168,836.98 260,069.02 20D7000000 FFY17-DISABLED VETS OUTREACH PROG Not Used(0000) 7,000.00 7,000.00 0 20D8000000 FFY18-DISABLED VETS OUTREACH PROG Not Used(0000) 17,384.00 17,384.00 0 20D9000000 FFY19-DISABLED VETS OUTREACH PROG Not Used(0000) 17,384.00 6,600.58 10,783.42 2886000000 UI-RESEA Expenditures -Mary Ball grant Not Used(0000) 55,100.00 55,100.00 0 2887000000 UI-RESEA Expenditures -Mary Ball grant -92887 Not Used(0000) 4,650.00 4,650.00 0 28C8000000 RESEA Expenditures - County Not Used(0000) 9,852.00 9,852.00 0 28C9000000 RESEA Expenditures - County Not Used(0000) 11,897.00 0 11,897.00 2M5500000 10% MIGRANT SSNL WRKR-PY15WP Not Used(0000) 26,675.00 26,675.00 0 2M5600000 10% MIGRANT SSNL WRKR-PY16WP Not Used(0000) 18,166.00 18,166.00 0 2M5700000 10% MIGRANT SSNL WRKR-PY17WP Not Used(0000) 37,506.00 37,506.00 0 2555000000 PY15-WP10% SUMMER JOB HUNT PY14WP Not Used(0000) 40,000.00 40,000.00 0 2556000000 PY16-WP10% SUMMER JOB HUNT Not Used(0000) 40,000.00 40,000.00 0 2S57000000 PY17-P10% SUMMER JOB HUNT Not Used(0000) 40,000.00 40,000.00 0 2558000000 PY18-WP10% SUMMER JOB HUNT Not Used(0000) 40,000.00 18,910.48 21,089.52 2W2700000 ESF-SFY17- 7/1/2016 to 6/30/2017 -WED ESF ONLY -NO CRWC Not Used(0000) 404,346.00 404,346.00 0 2W2800000 ESF-SFY18 WFD ESF ONLY -NO CRWC Not Used(0000) 382,635.00 382,635.00 0 2W2900000 ESF-SFY19 WFD ESF ONLY -NO CRWC Not Used(0000) 359,116.00 359,116.00 0 46A5000000 FY16 - WIOA ADULT LOCAL ADMIN Not Used(0000) 38,721.11 38,721.11 0 46A6000000 FY17 - WIOA ADULT LOCAL ADMIN Not Used(0000) 33,453.00 33,453.00 0 46A7000000 FY18 - WIOA ADULT LOCAL ADMIN Not Used(0000) 21,397.00 21,397.00 0 46A8000000 FY19 - ADULT LOCAL ADMIN Not Used(0000) 13,296.00 13,296.00 0 Page 1 of 4 August 12, 2019 Entity: 5230 Program Program Description Activity Budget Amount Actual Amount Balance 46D5000000 FY16 - WIOA DW- LOCAL ADMIN Not Used(0000) 18,281.00 18,281.00 0 46D6000000 FY17 - WIOA DW- DW LOCAL/COUNTIES ADMIN Not Used(0000) 24,759.00 24,759.00 0 46D7000000 FY18 -DW- DW ADMIN LOCAL/COUNTIES Not Used(0000) 21,411.00 21,411.00 0 46D8000000 FY19 DW- DW ADMIN LOCAL/COUNTIES Not Used(0000) 19,000.00 12,841.88 6,158.12 47D6000000 FY17- WIOA 25% DW ENHANCED ADMIN LOCAL/COUNTIES Not Used(0000) 9,692.00 9,692.00 0 47D7000000 FY18 - WIOA 25% DW ENHANCED ADMIN LOCAL/COUNTIES Not Used(0000) 13,920.00 13,920.00 0 47D8000000 FY19- WIOA 25% DW ENHANCED ADMIN LOCAL/COUNTIES Not Used(0000) 1,981.00 1,981.00 0 48A6000000 FY17 - WIOA ADULT LOCAL PROGRAM Not Used(0000) 301,080.00 190,107.10 110,972.90 48A6000000 FY17 - WIOA ADULT LOCAL PROGRAM WIA-Direct Training Local Program(8000) 0 110,972.90 -110,972.90 48A7000000 FY18 - WIOA ADULT LOCAL PROGRAM Not Used(0000) 401,256.00 401,256.00 0 48A8000000 FY19 - ADULT LOCAL PROGRAM Not Used(0000) 419,667.00 319,770.72 99,896.28 48D5000000 FY16- WIOA DW LOCAL PROGRAM Not Used(0000) 164,533.00 124,092.22 40,440.78 48D5000000 FY16- WIOA DW LOCAL PROGRAM WIA-Direct Training Local Program(8000) 0 40,440.78 -40,440.78 48D6000000 FY17- WIOA DW LOCAL/COUNTIES PROGRAM Not Used(0000) 222,839.00 178,552.63 44,286.37 48D6000000 FY17- WIOA DW LOCAL/COUNTIES PROGRAM WIA-Direct Training Local Program(8000) 0 44,286.37 -44,286.37 48D7000000 FY18- WIOA DW PROGRAM LOCAL/COU Not Used(0000) 192,694.00 192,694.00 0 48D8000000 FY19- DW PROGRAM LOCAL/COUNTIES Not Used(0000) 171,005.00 92,258.58 78,746.42 49D6000000 FY17- WIOA 25% DW ENHANCED PROG LOCAL/COUNTIES Not Used(0000) 103,907.00 103,907.00 0 49D7000000 FY18- WIOA 25% DW ENHANCED PROG LOCAL/COUNTIES Not Used(0000) 125,285.00 125,285.00 0 49D8000000 FY19- WIOA 25% DW ENHANCED PROG LOCAL/COUNTIES Not Used(0000) 117,833.00 75,681.96 42,151.04 4A65000000 PY15 - WIOA ADULT LOCAL ADMIN Not Used(0000) 3,972.00 3,972.00 0 4A66000000 PY16 - WIOA ADULT LOCAL ADMIN Not Used(0000) 4,881.00 4,881.00 0 4A67000000 PY17 - WIOA ADULT 10% ADULT COUNTY ADMIN Not Used(0000) 3,045.00 3,045.00 0 4A68000000 PY18 - ADULT LOCAL ADMIN Not Used(0000) 8,146.00 7,790.90 355.1 4A85000000 PY15 - WIOA ADULT LOCAL PROGRAM Not Used(0000) 35,748.00 12,424.36 23,323.64 4A85000000 PY15 - WIOA ADULT LOCAL PROGRAM WIA-Direct Training Local Program(8000) 0 23,323.64 -23,323.64 4A86000000 PY16 - WIOA ADULT LOCAL PROGRAM Not Used(0000) 43,934.00 31,552.79 12,381.21 4A86000000 PY16 - WIOA ADULT LOCAL PROGRAM WIA-Direct Training Local Program(8000) 0 12,381.21 -12,381.21 4A87000000 PY17 - WIOA ADULT PROGRAM COUNTY Not Used(0000) 57,861.00 57,861.00 0 4A88000000 PY18 - ADULT LOCAL PROGRAM Not Used(0000) 73,313.00 73,313.00 0 4BD500000 FY16 - WIOA DW-LOCAL ADMIN TRANSFER ADULT Not Used(0000) 6,983.10 6,983.10 0 4BD600000 FY17 - WIOADW-LOCAL/COUNTIES ADMIN TRANSFER ADULT Not Used(0000) 15,000.00 15,000.00 0 4BD700000 FY18 - WIOA DW-ADMIN TRANSFER TO ADULT LOCALS/COUNTIES Not Used(0000) 20,874.00 20,874.00 0 4BD800000 FY19-ADMIN TRANSFER TO ADULT LOCALS/COUNTIES Not Used(0000) 15,000.00 0 15,000.00 Page 2 of 4 August 12, 2019 Entity: 5230 Program Program Description Activity Budget Amount Actual Amount Balance 4D65000000 PY15 - WIOA -DW LOCAL ADMIN Not Used(0000) 3,317.00 3,317.00 0 4D66000000 PY16 - WIOA DW LOCAL ADMIN Not Used(0000) 7,462.00 7,462.00 0 4D67000000 PY17 - WIOA DW 10% COUNTY ADMIN Not Used(0000) 3,918.00 3,918.00 0 4D68000000 PY18 -DW LOCAL/COUNTIES ADMIN Not Used(0000) 7,172.00 7,172.00 0 4D75000000 PY15- WIOA 25% DW ENHANCED ADMIN LOC Not Used(0000) 2,195.00 2,195.00 0 4D85000000 PY15- WIOA DW LOCAL PROGRAM Not Used(0000) 29,853.00 11,329.32 18,523.68 4D85000000 PY15- WIOA DW LOCAL PROGRAM WIA-Direct Training Local Program(8000) 0 18,523.68 -18,523.68 4D86000000 PY16- WIOA DW LOCAL PROGRAM Not Used(0000) 67,159.00 67,159.00 0 4D87000000 PY17 - WIOA DW PROGRAM COUNTY Not Used(0000) 35,261.00 35,261.00 0 4D88000000 PY18- DW LOCAL/COUNTIES PROGRAM Not Used(0000) 64,547.00 64,547.00 0 4D95000000 PY15 - 25% ENHANCED DISLOCATED WORKER Not Used(0000) 0 4,827.76 -4,827.76 4D95000000 PY15 - 25% ENHANCED DISLOCATED WORKER WIA-Direct Training Local Program(8000) 0 14,930.24 -14,930.24 4DB500000 PY15 - WIOA LOCAL ADMIN TRANSFER ADULT Not Used(0000) 3,317.00 3,317.00 0 4DB700000 PY17 - WIOA DW ADMIN TRANSFER TO ADULT ADMIN COUNTY Not Used(0000) 3,917.00 3,917.00 0 4DN500000 PY15 - WIOA LOCAL PROG TRANSFER ADULT Not Used(0000) 29,853.00 656.72 29,196.28 4DN500000 PY15 - WIOA LOCAL PROG TRANSFER ADULT WIA-Direct Training Local Program(8000) 0 29,196.28 -29,196.28 4DN700000 PY17 - WIOA DW PROGRAM TRANSFER TO ADULT PROGRAM Not Used(0000) 35,261.00 35,261.00 0 4DW500000 PY15 - WIA CWDC 5% DW COUNCIL INITIATIVES Not Used(0000) 20,490.00 20,490.00 0 40W600000 PY16 - WIA CWDC 10% DW COUNCIL Not Used(0000) 15,750.00 15,750.00 0 4ED5000000 FY16-WIOA 25% DW ENHANCED ADMIN TO LOCAL Not Used(0000) 5,122.00 5,122.00 0 4FD5000000 FY16 - WIOA -25% DW ENHANCED PROGRAM TO LOCAL Not Used(0000) 74,841.00 74,841.00 0 4FF6000000 FY17 WFD-APP-LOCAL-Apprenticeship Not Used(0000) 37,219.00 19,219.00 18,000.00 4FF7000000 PY17 WFD-APPR-LOCAL PROGRAM Not Used(0000) 27,000.00 0 27,000.00 4FH6000000 FY17 WFD-APP-LOCAL Admin Not Used(0000) 3,000.00 3,000.00 0 4FH7000000 PY17 WFD-APPR-LOCAL Admin Not Used(0000) 3,000.00 0 3,000.00 4G0400000 FY15 - WIA WFD-3.75%-Tech Assist Locals Not Used(0000) 12,500.00 12,500.00 0 4G0500000 FY16 - WIOA-5%-$165,000 WFD Tech Assist Locals Not Used(0000) 22,000.00 22,000.00 0 41D5000000 FY16 - WIOA 25% DW- WIOA TRANISITIONAL ACTIVITIES Not Used(0000) 5,109.00 5,109.00 0 4KD600000 FY17- DW LOCAL PROGRAM FORMULA INITIATIVES $300,000 Not Used(0000) 20,220.00 20,220.00 0 4MT500000 PY14-WIOA Technical Assist Traninig-TMT ADVANCE Not Used(0000) 8,000.00 8,000.00 0 4ND500000 FY16 - WIOA DW- LOCAL PROG TRANSFER ADULT Not Used(0000) 164,533.00 102,882.55 61,650.45 4ND500000 FY16 - WIOA DW- LOCAL PROG TRANSFER ADULT WIA-Direct Training Local Program(8000) 0 61,650.45 -61,650.45 4ND600000 FY17 - WIOA DW-LOCAL/COUNTIES PROG TRANSFER ADULT Not Used(0000) 135,000.00 86,427.90 48,572.10 4ND600000 FY17 - WIOA DW-LOCAL/COUNTIES PROG TRANSFER ADULT WIA-Direct Training Local Program(8000) 0 48,572.10 -48,572.10 Page 3 of 4 August 12, 2019 Entity: 5230 Program Program Description Activity Budget Amount Actual Amount Balance 4ND700000 FY18 - WIOA DW-PROGRAM TRANSFER TO ADULT LOCAL/COUNTIES Not Used(0000) 187,872.00 187,872.00 0 4ND800000 FY19 DW-PROGRAM TRANSFER TO ADULT LOCAL/COUNTIES Not Used(0000) 135,000.00 14,518.31 120,481.69 4PD6000000 FY17 - WIOA 25% DW LOCAL ENHANCED PROGRAM TRANSFER TO Not Used(0000) 44,000.00 44,000.00 0 4RA5000000 FY16 - WIOA WFD 5%- ADULT EVALU & CONTIN IMPR Not Used(0000) 20,000.00 20,000.00 0 4S35000000 PY15-WFD-SPNEG-GRANT PLANNING Not Used(0000) 80,257.00 80,257.00 0 4S45000000 PY15-WFD-SPNEG-LOCALADMIN Not Used(0000) 57,346.00 57,346.00 0 4555000000 PY15-WFD-SPNEG-LOCAL PROGRAM Not Used(0000) 723,160.00 723,160.00 0 4WA700000 FY18 - WIOA CWDC 10% COUNCIL -ADULT ETP Not Used(0000) 50,924.00 40,426.15 10,497.85 4WD700000 FY18 - WIOA CWDC 10% DW COUNCIL -LOCAL Not Used(0000) 7,500.00 7,500.00 0 4Y65000000 PY15 - WIOA 10% YOUTH LOCAL ADMIN Not Used(0000) 61,902.00 61,808.92 93.08 4Y66000000 PY16 - WIOA 10% YOUTH LOCAL ADMIN Not Used(0000) 30,956.00 30,956.00 0 4Y67000000 PY17- WIOA YOUTH 10% COUNTY ADMIN Not Used(0000) 30,055.00 30,055.00 0 4Y68000000 PY18 - 10%YOUTH LOCAL ADMIN Not Used(0000) 61,690.00 33,204.71 28,485.29 4Y74000000 PY14 - WIA YOUTH OUT -SCHOOL LOCAL PROGRAM Not Used(0000) 38,185.71 28,306.72 9,878.99 4Y74000000 PY14 - WIA YOUTH OUT -SCHOOL LOCAL PROGRAM WIA-Direct Training Local Program(8000) 0 9,878.99 -9,878.99 4Y75000000 PY15 - WIOA YOUTH MIN -75% -OUT -SCHOOL LOCAL PROGRAM Not Used(0000) 417,837.00 223,691.48 194,145.52 4Y75000000 PY15 - WIOA YOUTH MIN -75% -OUT -SCHOOL LOCAL PROGRAM WIA-Direct Training Local Program(8000) 0 161,492.01 -161,492.01 4Y75000000 PY15 - WIOA YOUTH MIN -75% -OUT -SCHOOL LOCAL PROGRAM YOUTH -20% -OUT -SCHOOL -WORK 0 32,599.51 -32,599.51 4Y76000000 PY16 - WIOA YOUTH MIN -75% -OUT -SCHOOL LOCAL PROGRAM Not Used(0000) 448,607.00 206,766.74 241,840.26 4Y76000000 PY16 - WIOA YOUTH MIN -75% -OUT -SCHOOL LOCAL PROGRAM WIA-Direct Training Local Program(8000) 0 158,549.13 -158,549.13 4Y76000000 PY16 - WIOA YOUTH MIN -75% -OUT -SCHOOL LOCAL PROGRAM YOUTH -20% -OUT -SCHOOL -WORK 0 83,291.13 -83,291.13 4Y77000000 PY17 - WIOA OSY-75% YOUTH OUT OF SCHOOL TO COUNTIES Not Used(0000) 426,021.00 341,227.95 84,793.05 4Y77000000 PY17 - WIOA OSY-75% YOUTH OUT OF SCHOOL TO COUNTIES YOUTH -2O% -OUT -SCHOOL -WORK 0 84,793.05 -84,793.05 4Y78000000 PY18 - YOUTH MIN -75% -OUT -SCHOOL LOCAL PROGRAM Not Used(0000) 416,406.00 311,600.11 104,805.89 4Y86000000 PY16 - WIOA YOUTH MAX -25% -IN -SCHOOL LOCAL PROGRAM Not Used(0000) 30,000.00 13,426.83 16,573.17 4Y86000000 PY16 - WIOA YOUTH MAX -25% -IN -SCHOOL LOCAL PROGRAM WIA-Direct Training Local Program(8000) 0 520 -520 4Y86000000 PY16 - WIOA YOUTH MAX -25% -IN -SCHOOL LOCAL PROGRAM YOUTH -20% -IN -SCHOOL -WORK 0 16,053.17 -16,053.17 4Y87000000 PY17 -WFD WIOA ISY-25% YOUTH IN SCHOOL TO COUNTIES Not Used(0000) 142,006.00 113,741.65 28,264.35 4Y87000000 PY17 -WFD WIOA ISY-25% YOUTH IN SCHOOL TO COUNTIES YOUTH -20% -IN -SCHOOL -WORK 0 28,264.35 -28,264.35 4Y88000000 PY18 - YOUTH MAX -25% -IN -SCHOOL LOCAL PROGRAM Not Used(0000) 138,802.00 51,765.63 87,036.37 4YW600000 PY16 - WIA CWDC 10%YOUTH COUNCIL $1,118,290.50 Not Used(0000) 48,265.00 48,265.00 0 Total 10,862,401.50 9,920,941.82 941,459.68 Page 4 of 4 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/2017 YEAR OF FUNDS TITLE/PROGRAM/PROJECT FY17 FOREIGN LABOR CERTIFICATION CLEAR Program code Page 1 of 2 FY17 1647000000 END DATE END DATE 9/30/2018 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 7,563.90 2. Current Program and Admin Cash Needs 0.00 3. FINAL Program and Admin Cash Needs Contract to Date 7,563.90 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 7,563.90 2. Current Expenses + Accruals (Through End Date of Award) 0.00 3. FINAL Program Expenses Contract to Date 7,563.90 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 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,563.90 2. FINAL Expenses Through End of Contract 7,563.90 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes E /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 2. Less Program Income Exoenses Through Contract End Date 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 7,563.90 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. Signature //:V +i� JJJA Date C 'I /3 /Preparer's 90/Authorized Signature JL IL' //` /,ICA—' Date AlU:: f r See instruction for completing this for on the next tab (Attachment H 2 of 2) 0019- 3 8.0 - 1O 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. ContractlEA/Workplan Start/End Date: Enter the start and end date of the grant on the applicable lines. Program Income Start/End Date: If program income was generated under the grant, enter the start and end date of the program income portion of the grant on the applicable lines. I. CASH REQUEST 1.Enter the amount of program and administrative cash needs reported prior to this draw. 2. Enter the amount of current cash needs reported. 3. Add the amount from 1 to 2 above. Enter total here. 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 Pl has been earned under this award, complete V thru VI 1. Enter the amount from 1.3 here 2. Enter the amount frojm 11.3 and 111.3 here 3. Does the amount from 1. EQUAL amount from 2? Check the appropriate box. V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Enter the amount of program income cash reported as received prior to this report. 2. Enter the amount of current PI cash reported. 3, Add the amounts from 1 to 2. Enter total here. VI. RECONCILIATION The goal of this reconciliation is to determine whether PI cash earned has been spent, and if not, whether if can be spent beyond the period of performance. 1. Enter the amount from V.3 here. 2. Enter the amount from 111.3 here. 3. Enter difference of 2 from 1 here. VII. MATCH RECONCILIATION The goal of this reconciliation is that match met should equal or exceed expenses+accruals reported at the end of the award. If the answer to 5 is NO, additional match will be required. 1. Enter the amount of match reported through the end of this award. 2. Enter the amount from 11.3 here. 3. Enter the match requirement as a percentage of expenditures. For example, a match of 1 dollar for every 1 dollar expended (1 for 1) is 100%. Match of 1 dollar for every 2 dollars (1of 2) expended is 50%. 4. Mutiply the amount from 2 by the amount in 3. 5. Is the amount in 1, greater than or equal to the amount in 4. Check the appropriate box. Preparer's and Director's Signature and Date: Optional signature for subrecipient's reference. CLEAR WIOA Reconciliation-FY17 FOREIGN LABOR CERTIFICATION Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance October -17 164700000 7,563.90 November -17 164700000 7,563.90 December -17 164700000 2,213.74 2,213.74 2,213.74 2/1/18 5,350.16 December -17 "B" 164700000 5,350.16 January -18 164700000 5,350.16 February -18 164700000 453.51 453.51 453.51 5/29/18 4,896.65 March -18 164700000 4,896.65 April -18 164700000 658.82 658.82 658.82 5/29/18 4,237.83 May -18 164700000 423.70 423.70 423.70 7/20/18 3,814.13 June -18 164700000 426.60 426.60 426.60 8/2/18 3,387.53 July -18 164700000 3,387.53 August -18 164700000 3,387.53 September -18 164700000 3,387.53 3,387.53 3,387.53 10/26/18 - Totals 7,563.90 7,563.90 7,563.90 164700000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Account 5230.0000.6500.1647000000.0000.00000000C Funds Available ( Detail Balances ) Period Sep -17 Oct -17 Nov -17 Dec -17 Jan -18 Feb -18 Mar -18 Apr -18 delay -18 'Jun -18 Budget Encumbrance 0 00', 0 00 7563.90 0.00 0 00'. 0 00 0.00! 0 00 0 00' 0.00 0.00 7563.90 0.00 0 00 0 00 0.00 0.00 000' 0 00', 0.00 0.00 0.00, Actual 0.00 0.00 0.00' 2213 74 0.00!. 453.51 0 00' 658.82 423.70, 426.60, 7563.90 Funds Available 0.00 7563.90 0.00 -2213.74 000 -453.51 0.00 - 658.82 - 423.70 - 426.60 Cancel .:......................... . 0.00 Account 15230.0000.6500.1647000000.0000.00000000C Funds Available ( Detail Balances ) Period Budget Encumbrance 000; 000' Jul -18 0.00 0.00', Aug -18 1 00 0 00'' Sep -18 0.00 0.00 Oct -18 0 00 0 00', Nov -18 0.00' 0 00' Dec -18 -1.00 0.00, Jan -19 0 00„ 0 00 Feb -19 0.00 0.00 Mar -19 0.00 0 00 7563.90 Actual Funds Available 000 000 0.00 0.00 0.00 1 00 3387.53 -3387.53 0.00 0.00 0 00 0.00 0 00 -1.00 000 000 0 00, 0.00 0.00 0.00 _ 0.00', 7563.90; Cancel 0.00 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part 3 GRANT CLOSEOUT RECONCILIATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 EA/WORKPLAN START DATE PROGRAM INCOME START DATE 7/1/2016 YEAR OF FUNDS TITLE/PROGRAM/PROJECT CLEAR Program code Page 1 of 2 PY16 PY16 WAGNER PEYSER 2056000000 END DATE END DATE 6/30/2019 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 514,519.00 2. Current Program and Admin Cash Needs 0.00 3. FINAL Program and Admin Cash Needs Contract to Date 514,519.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 514,519.00 2. Current Expenses + Accruals (Through End Date of Award) 0.00 3. FINAL Program Expenses Contract to Date 514,519.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 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 514,519.00 2. FINAL Expenses Through End of Contract 514,519.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes El /No ❑ V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Total PI Cash Previously Reported 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 2. Less Program Income Exoenses Through Contract End Date 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 514,519.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 3 it 3 JLq'i Authorized Signature / 1�� kke-7-",-- Date { : 2 `' ':C See instruction for completing this for on the next tab (Attachment H 2 of 2) O019 -3-1W - I I CLEAR WIOA Reconciliation-PY16 Wagner Peyser Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received Grant Balance July -16 205600000 514,519.00 August -16 205600000 514,519.00 September -16 205600000 514,519.00 October -16 205600000 514,519.00 November -16 205600000 15,092.57 15,092.57 15,092.57 12/31/16 499,426.43 December -16 205600000 22,772.28 22,772.28 22,772.28 12/31/16 476,654.15 12/1/2016 "B" 205600000 13,538.21 13,538.21 12/31/16 476,654.15 January -17 205600000 (6,628.33) (6,628.33) 4/4/17 476,654.15 February -17 205600000 34,278.34 41,188.22 34,278.34 4/4/17 435,465.93 March -17 205600000 26,687.86 26,687.86 26,687.86 5/11/17 408,778.07 April -17 205600000 39,420.71 39,420.71 39,420.71 5/23/17 369,357.36 May -17 205600000 29,193.28 29,193.28 29,193.28 6/26/17 340,164.08 June -17 205600000 15,181.01 15,181.01 15,181.01 7/21/17 324,983.07 July -17 205600000 26,825.27 26,825.27 26,825.27 8/21/17 298,157.80 August -17 205600000 44,842.80 44,842.80 44,842.80 9/25/17 253,315.00 September -17 205600000 48,822.37 48,822.37 48,822.37 10/20/17 204,492.63 October -17 205600000 52,891.83 52,891.83 52,891.83 11/27/17 151,600.80 November -17 205600000 40,541.82 40,541.82 40,541.82 12/21/17 111,058.98 December -17 205600000 37,053.64 37,053.64 37,053.64 12/31/17 74,005.34 December -17 "B" 205600000 6,759.46 6,759.46 12/31/17 74,005.34 January -18 205600000 5,422.62 12,182.08 5,422.62 2/27/18 61,823.26 February -18 205600000 18,710.96 18,710.96 18,710.96 5/26/18 43,112.30 March -18 205600000 30,191.91 30,191.91 30,191.91 5/29/18 12,920.39 April -18 205600000 12,920.39 12,920.39 12,920.39 5/29/18 0.00 May -18 205600000 0.00 June -18 205600000 0.00 July -18 205600000 0.00 August -18 205600000 0.00 September -18 205600000 0.00 October -18 205600000 0.00 November -18 205600000 0.00 December -18 205600000 0.00 January -19 205600000 0.00 Totals 514,519.00 514,519.00 514,519.00 205600000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 ._ n; x 1 Account 5230.0000.6500.2056000000.0000.00000000C Funds Available ( Detail Balances ) Period ' Adj-16 Jul -16 Aug 16 Sep -16 Oct 16 Nov -16 Dec -16 Jan -17 Feb -17 Mar -17 Budget 0 00 514519 00: 0.00 0.00 Q Qo' 0 00! 0 00' 0.00 000. 0.00 Encumbrance 000 000 0 00 0.00 0 00' 0 00 000' 0 00 0.00 0001 514519.00 O00 Actual Funds Available 0.00 0.00 0.00 514519.00 0.00 000 0.00 0.00 000 000 15092 57 15092.57 22772 28 -22772.28 0.00 0 00 41188 22 -41188.22 26687.86, -26687.86 514519.00: 0.00 Cancel t (PJ'D) - J Account '15230.0000.6500.2056000000.0000.00000000C Period Apr -17 May -17 ;Jun -17 Adj-17 ..._.......... Jul -17 Aug -17 Sep -17 Oct -17 Nov -17 Dec -17 Funds Available ( Detail Balances ) Budget Encumbrance 0.00 0.00 0,00 0.00 000' 0.00 0.40 0.00 0 00I 0.00 000; 0.00 0.00. 0.00 0.0O 000: 0.00 000 0 00 0.00 514519.00!. Actual Funds Available 39420 71 -39420.71 29193.28 -29193 28 15181 01 -15181.01 0.00 0.00 26825 27 -26825.27 44842 80' -44842.80 48822 37', -48822.37 52891 83 -52891.83 40541.82, -40541.82 37053.64 -37053.64. 0.00 514519.00 0.00 Cancel (P rTD) Account Period I Jan -18 Feb -18 (Mar -18 Apr -18 May -18 Jun -18 Ad} -18 Jul 18 Aug -18 Sep -18 5230.0000.6500.2056000000.0000.00000000C Funds Available ( Detail Balances ) Budget 000 0.00 000 0.00 0.00' 0.00 0.00' 0.00', 0.00 0.00' 514519.00', Encumbrance 0.00' 0 00 0.00 0.00 0.00 0.00 0.00' 0 00 0.00 000' 0.00 Actual 12182 08 18710 96, 30191 91! 12920.39 0.00 0.00 0.00 0.00:. 0 00! 0.00 514519 00 Funds Available -12182.08 -18710.96 -30191.91 -12920.39 0.00 0.00 0.00 0.00 0.00 0.00 Cancel 0.00 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part 3 GRANT CLOSEOUT RECONCILIATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley CO 90632 EAIWORKPLAN START DATE PROGRAM INCOME START DATE 7'1%20)7 YEAR OF FUNDS TITLEJPROGRAM/PROJECT CLEAR Program code Page ' of 2 oY17 WAGNER PEYSER 2057000000 END DATE END DATE 6/3012019 I. CASH REQUEST 1 Total program and Admin Cash needs Preciously Reported 2 Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date 444,846.00 0 00 444 846.00 It. PROGRAM EXPENSE REPORT (ER) 1 Total Expenses+Accruals Previously Reported (Through Last Month) 444,846 00 2 Current Expenses + Accruals (Through End Date of Award) 0.00 3 FINAL Program Expenses Contract to Date 444,846.00 ADMINISTRATIVE EXPENSE (ER) 4 Total Expenses+"Accruals Previously Reported (Through Last Month) 5 Current Expenses+Accruals (Through End Date of Awards) 6 FINAL Administrative Expenses Contract to Date 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 444.846.00 2. FINAL Expenses Through End of Contract 444,846.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 1 Total PI Cash Previously Reported on Cash Request 2 Current Program Income Cash (Through End Date of Contract) 3 FINAL Program Income Cash Contract to Date 0 00 VI. RECONCILIATION ' FINAL Program Income Cash 2. Less Program Income Exoenses Through Contract End Date 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 444,846.00 3 Match Percentage of Expenditure Contracttuai Requirement 0.00 4 Match Expenditure Requirement 0.00 5 Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes 2 INo 0 'The program Income Expense Report and Cash Request :an only be extended through the availabiliry of r^e 4-ea,mc and'or Fortenei funding pecod A Signature /Preoarer's / Date SW / O 19 Authorized Signature .q C. �� A-k ibt g-,-1 lc,— Date See 'nnrucoon for come:song :NS for on the next ten {vctacnmant ;'i 2 of 21 aot9- 31$0- l'07 CLEAR WIOA Reconciliation-PY17 Wagner Peyser Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance July -17 205700000 444,846.00 August -17 205700000 444,846.00 September -17 205700000 444,846.00 October -17 205700000 444,846.00 November -17 205700000 444,846.00 December -17 205700000 444,846.00 December -17 "B" 205700000 444,846.00 January -18 205700000 444,846.00 February -18 205700000 444,846.00 March -18 205700000 444,846.00 April -18 205700000 33,656.51 33,656.51 33,656.51 5/29/18 411,189.49 May -18 205700000 39,370.07 39,370.07 39,370.07 7/13/18 371,819.42 June -18 205700000 32,446.23 32,446.23 32,446.23 8/2/18 339,373.19 July -18 205700000 43,432.88 43,432.88 43,432.88 9/14/18 295,940.31 August -18 205700000 53,051.30 53,051.30 53,051.30 10/3/18 242,889.01 September -18 205700000 69,556.54 69,556.54 69,556.54 10/26/18 173,332.47 October -18 205700000 62,737.74 62,737.74 62,737.74 12/6/18 110,594.73 November -18 205700000 38,515.03 38,515.03 38,515.03 1/11/19 72,079.70 December -18 205700000 50,485.22 50,485.22 50,485.22 2/13/19 21,594.48 12/1/2018 "B" 205700000 12,621.73 12,621.73 4/1/19 21,594.48 12/1/2018 "C" 205700000 (653.67) (653.67) 4/1/19 21,594.48 January -19 205700000 9,626.42 21,594.48 9,626.42 4/1/19 0.00 Totals 444,846.00 444,846.00 444,846.00 205700000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Account 5230.0000.6500.2057000000.0000 00000000C Period Mar -17 Apr -17 May -17 Jun -17 AdJ-17 Jul -17 Aug -17 :Sep -17 C)ct 17 Nov -17 Funds Available ( Detail Balances ) Budget Encumbrance 0.00 0.00 0.00 j 0.00 0.00 0.00 0.00! 0 00 0.00 0.00 444846.00 0 00 000 000 0.00 000' 0 00" 0 00 0.00 0.00 444848.00 0.00 Actual Funds Available 0 00 0.00 .- 0.00 0.00 0 00 0.00 0.00 j 0.00 00a_ 0.00 0 00 444846 00 0.00 0.00 0.00 0 00 0.00 0.00 0 00 0.00 _ 444846.001 2.00 Cancel Account 5230.0000.6500.2057000000.0000.00000000C Period ' Dec -17 Jan -18 Feb 18 Mar -18 Apr -18 May -18 Jun 18 Adj-18 Jul -18 Aug -18 Funds Available ( Detail Balances ) Budget 0.00 0.00' 0.00 0.00 0 00 0.00 0 00'' 0.00 0.00' 200 444848.00 Encumbrance 000. 000 0.00 000 000 0.00. 000 000 000, 0.00 0.00 Actual Funds Available 0.00 0.00 0 00 0 00 0.00 0.00 000 0.00 33656.51 -33656.51 39370 07 -39370.07 32446.23 -32446.23 0.00 0.00 43432 88 -43432.88 5305130', -53049.30. 444846.00" 2.00 Cancel Period ' Sep -18 Oct -18 Nov 18 Dec -18 Jan -19 Feb -19 Mar -19 Apr -19 'May-19 Jun-19 5230.0000.6500.2057000000.0000.00000000C Funds Available ( Detail Balances ) Budget 0.00 0.00! 000 0.00 0.00 0.00'. 0.00'. 0.00 0.00.. 0.00 444848.00 Encumbrance 0.00 0 00 0.00! 0.00 0.00 0.00'. 0.00 0.00 000 0.00 0.00; Actual Funds Available 69556.54 -69556.54 62737 74 38515.03 50485 22' 21594 48' 000: 0.00 0.00 0.00 0.00!, ..._ ..........._.............. 444846.00'. -62737.74 -38515.03 -50485.22 -21594.48 0.00 0.00 0.00 0.00 0.00 Cancel 2.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/20/2018 YEAR OF FUNDS TITLE/PROGRAM/PROJECT CLEAR Program code Page 1 of 2 FY18 FY18 VETS DVOP 20D8000000 END DATE END DATE 12/31/2018 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 17,384.00 2. Current Program and Admin Cash Needs 0.00 3. FINAL Program and Admin Cash Needs Contract to Date 17,384.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 17,384.00 2. Current Expenses + Accruals (Through End Date of Award) 0.00 3. FINAL Program Expenses Contract to Date 17,384 00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 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 0 V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 VI. RECONCILIATION 1. FINAL Program Income Cash 2. Less Program Income Exoenses Through Contract End Date 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 17,384.00 3. Match Percentage of Expenditure Contracttual Requirement 0.00 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement'? (Check Box) Yes O /No 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 DateAuthorized :::::' Date r ..- 1ri See instruction for completing this for on the next tab (Attachment H 2 of 2) ao(9-3-18'0 -(3 CLEAR WIOA Reconciliation-FY18 VETS OUTREACH PROG Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received 1 Date Received I Grant Balance July -18 20D800000 17,384.00 August -18 20D800000 4,488.24 4,488.24 1/18/19 17,384.00 September -18 20D800000 17,384.00 October -18 20D800000 6,447.88 6,447.88 1/18/19 17,384.00 November -18 20D800000 3,223.94 14,160.06 3,223.94 1/18/19 3,223.94 December -18 20D800000 3,223.94 3,223.94 3,223.94 1/29/19 - January -19 20D800000 - February -19 20D800000 - March -19 20D800000 - April -19 20D800000 - May -19 20D800000 - June -19 20D800000 - Totals 17,384.00 17,384.00 17,384.00 20D800000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 es (PSTO)..'. Account 15230.0000.6500.2008000000.0000.00000000( Funds Available ( Detail Balances ) Period ' Dec -17 Jan -18 Feb -18 Mar -18 Apr -18 May -18 Jun -18 Adj-18 Jul -18 Aug -18 Budget Encumbrance 0.00 0.00 0.00 000 0.00 0.00 000 000, 0.00 0.00 0.00 0.00 0.00' 0 00 0 00 0.00 17384 00', 0.00 0.00 0.00' 17384.00' 0.00' Actual Funds Available 0.00 0.002- 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 17384 00 0.00 0.00 17384.00 0.00 Cancel Account 5230 0000.6500.2008000000 0000.00000000( Funds Available ( Detail Balances ) Period I:Sep 18 ................. Oct -18 Nov -18 Dec -18 Jan -19 Feb -19 Mar -19 Apr -19 ................... May -19 Jun -19 Budget Encumbrance 0.00, 0.00 000; 0.00 0.00 0.00 0.00 0.00 17384.00 0.0D 0 00',' 0.00 0.00 0 00 000 0.00 000 Actual Funds Available 0 00 0.00 .r.. 0 00 14160 06 3223 94 0.00' 000' 0.00 0 00 0 00 0.00 0.00 -14160.06 -3223_94 000 0.00 0.00 0.00 000 0.00 0.00' 17384.00' 0.00 Cancel COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part 3 GRANT CLOSEOUT RECONCILIATION WORKSHEET Page 1 of 2 SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 EA/WORKPLAN START DATE PROGRAM INCOME START DATE 7/1/2018 YEAR OF FUNDS TITLE/PROGRAM/PROJECT CLEAR Program code PY17 PY17 MIGRANT SSNL WRKR 2M57000000 END DATE END DATE 6/30/2019 I. CASH REQUEST 1 Total program and Admin Cash needs Preciously Reported 37,506.00 2. Current Program and Admin Cash Needs 0.00 3. FINAL Program and Admin Cash Needs Contract to Date 37,506.00 II. PROGRAM EXPENSE REPORT (ER) 1 Total Expenses+Accruals Previously Reported (Through Last Month) 37,506.00 2. Current Expenses + Accruals (Through End Date of Award) 0.00 3. FINAL Program Expenses Contract to Date 37,506.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 5 Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date III. PROGRAM INCOME(PI) EXPENSE REPORT 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION 1. FINAL Cash Request Contract to Date 37,506.00 2 FINAL Expenses Through End of Contract 37,506.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 2. Less Program Income Exoenses Through Contract End Date 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 37,506 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 SI'3 )iS Authorized Signature sss/// i. /% Date - kf e,' I L lP' See instruction for completing this for on the next tab (Attachment H 2 bf 2) 0019 - 31$0 - t `'t CLEAR WIOA Reconciliation-PY17 MIGRANT SSNL WRKR Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received 1 Date Received I Grant Balance July -18 2M5700000 37, 506.00 August -18 2M5700000 124.86 124.86 2/8/19 37,506.00 September -18 2M5700000 223.16 223.16 2/8/19 37,506.00 October -18 2M5700000 3,818.64 3,818.64 2/8/19 37,506.00 November -18 2M5700000 1,558.13 1,558.13 2/8/19 37,506.00 December -18 2M5700000 2,724.39 8,449.18 2,724.39 2/8/19 29,056.82 December -18 "B" 2M5700000 944.43 944.43 4/1/19 29,056.82 December -18 "C" 2M5700000 (18.40) (18.40) 4/1/19 29,056.82 January -19 2M5700000 79.23 1,005.26 79.23 4/1/19 28,051.56 February -19 2M5700000 1,148.41 1,148.41 1,148.41 4/12/19 26,903.15 March -19 2M5700000 5,866.85 5,866.85 5,866.85 5/14/19 21,036.30 April -19 2M5700000 5,170.86 5,170.86 5,170.86 5/28/19 15,865.44 May -19 2M5700000 12,057.96 12,057.96 12,057.96 7/9/19 3,807.48 June -19 2M5700000 3,807.48 3,807.48 3,807.48 7/24/19 - Totals 37,506.00 37,506.00 37,506.00 2M5700000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 (PSTD)- Account 15230.0000.6500.2M57000000.0000.00000000( Funds Available ( Detail Balances ) Period Apr -18 May -18 Jun -18 Adj-18 Jul -18 Aug -18 Sep -18 Oct -18 Budget 0.00 0.00: 0.00 0 00 0.00 000 37506.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 0 00 37506.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, 37506 ao 0.00 0 00 0.00 0.00 0 00 0 00 37506.00' 000 Cancel es (PJTh) - I Account s5230.0000.6500.2M57000000.0000.00000000( Period Nov -18 Dec -18 Jan -19 Feb -19 Mar -19. Apr -19 May -19 Jun -19 Adj-19 Jul 19 Funds Available ( Detail Balances ) Budget Encumbrance 0 00 + e.r, 0 00! 0 00' 000; 000` 0.00' 0.00', 0 00 0.00' 000, 000' 000 000. 000' 0.00 0.00! 0.00 0.00 0.00 37506.00!. 0.00 Actual 0 00 8449.18 1005.26 114841, 5866.85 5170.86. 12057 96 3807.48 0.00 0.00! 37506.001 Funds Available 0.00 - 8449.18 -1005.26 - 1148.41 -5866.85 - 5170.86 -12057.96 -3807.48 0.00 0.00, Cancel 0.00 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part 3 GRANT CLOSEOUT RECONCILIATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 EA/WORKPLAN START DATE PROGRAM INCOME START DATE 1/2/2018 YEAR OF FUNDS Page 1 of 2 PY17 TITLE/PROGRAM/PROJECT PY17 SUMMER JOB HUNT 10%WP CLEAR Program code 2S57000000 END DATE END DATE 12/31/2018 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 40,000.00 2. Current Program and Admin Cash Needs 0.00 3. FINAL Program and Admin Cash Needs Contract to Date 40,000.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 40,000.00 2. Current Expenses + Accruals (Through End Date of Award) 0.00 3. FINAL Program Expenses Contract to Date 40,000.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 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 40,000.00 2. FINAL Expenses Through End of Contract 40,000.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes 2 /No 0 V. CASH REQUEST PROGRAM INCOME CASH REPORTED 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 2. Less Program Income Exoenses Through Contract End Date 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 40,000.00 3. Match Percentage of Expenditure Contracttual Requirement 0.00 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes 2 /No 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 l'Yf, Date O / 13 /2p il Authorized Signatures - / 1 (6��(/�� Date Ash See Instruction for completing this for on the next tab (Attachment H 2 of 2) la - 3780 - (5 CLEAR WIOA Reconciliation-PI/17 Summer Job Hunt Reporting Month I Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance January -18 2S5700000 40,000.00 February -18 2S5700000 1,963.50 1,963.50 7/13/18 40,000.00 March -18 2S5700000 5,819.86 5,819.86 7/13/18 40,000.00 April -18 2S5700000 5,897.90 5,897.90 7/13/18 40,000.00 May -18 255700000 2,832.23 16,513.49 2,832.23 7/13/18 23,486.51 June -18 255700000 400.96 400.96 400.96 8/2/18 23,085.55 July -18 255700000 126.00 126.00 126.00 9/10/18 22,959.55 August -18 255700000 2,566.67 2,566.67 2,566.67 10/3/18 20,392.88 September -18 2S5700000 6,040.80 6,040.80 6,040.80 10/26/18 14,352.08 October -18 255700000 4,933.41 4,933.41 4,933.41 12/6/18 9,418.67 November -18 2S5700000 3,700.45 3,700.45 3,700.45 1/11/19 5,718.22 December -18 2S5700000 4,614.70 4,614.70 4,614.70 2/8/19 1,103.52 December -18 "B" 255700000 1,133.51 1,133.51 4/1/19 1,103.52 December -18 "C" 2S5700000 (29.99) (29.99) 4/1/19 1,103.52 January -19 255700000 1,103.52 - February -19 255700000 - March -19 255700000 - April -19 2S5700000 - May -19 255700000 - June -19 2S5700000 - Totals 40,000.00 40,000.00 40,000.00 255700000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Account 5230.0000.6500.2S57000000.0000.00000000( Funds Available ( Detail Balances ) Period Budget Encumbrance I Dec -17 0.00 0.00 Jan -18 40000.00! 0 00 Feb -18 0.00 0.00 Mar -18 0.00 0.00 Apr -18 0 00;' 0.00' May -18 0.00 0 00'. Jun -18 0 00 0 00 'Ad) -18 0.00 0.00 Jul -18 0.00 0 00 Aug -18 1.00' 0.00 40001.00 Actual Funds Available 0.00 0.00 0 00! 40000.00 0.00. 0 00 0.00 ! 0 00 0.00 0.00 16513.49; -16513.49 400 96 -400.96 0.00 0 00 126 00 -126.00 2566.67 -2565.67 0.00 40000.00 1.00 Cancel Account 5230.0000.6500.2S57000000.0000.00000000( Funds Available ( Detail Balances ) Period Budget Sep -18 0 00 Oct -18 0.00 Nov -18 Dec -18 Jan -19 0.00': Feb -19 0 00 Mar -19 0.00 Apr -19 0 00 May -19 0.00 ;Jun -19 0.00. 40001.00 Encumbrance 0.00' 000 0.00 0 00 0.00 000 0.00 0.00 0.00 0 00 0.00 Actual Funds Available 6040.80 -6040.80 4933.41', -4933.41 3700.45 -3700.45 4614.70 4614.70 1103.52 -1103.52 0.00 0.00 0 00 0.00 0.00, 0 00 0.00 0.00 0.00 0 00 P 40000.00 1.00 Cancel 1 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part 3 GRANT CLOSEOUT RECONCILIATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 EA/WORKPLAN START DATE PROGRAM INCOME START DATE 7/1/2018 YEAR OF FUNDS Page 1 of 2 SFY19 TITLE/PROGRAM/PROJECT EMPLOYMENT SUPPORT FUND CLEAR Program code 2W29000000 END DATE END DATE 6/30/2019 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 359,116.00 2. Current Program and Admin Cash Needs 0.00 3. FINAL Program and Admin Cash Needs Contract to Date 359,116.00 I1. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 359,116.00 2. Current Expenses + Accruals (Through End Date of Award) 0.00 3. FINAL Program Expenses Contract to Date 359,116.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 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 359,116.00 2. FINAL Expenses Through End of Contract 359,116.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes E /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 2. Less Program Income Exoenses Through Contract End Date 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 359,116.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 ❑ 'The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federa/ funding period. Preparer's Signatures/J f �%��rz/Lh Date f J )i S Authorized Signature add �� Date ,•.,�'� 1, .f 7 r See instruction for completing this for on the next tab (Attachment H 2 of 2) ao►q-318-0 - tt CLEAR WIOA Reconciliation-SFY19 Employment Support Fund Reporting Month I Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance July -18 2W29000000 359,116.00 August -18 2W29000000 21,980.33 21,980.33 2/8/19 359,116.00 September -18 2W29000000 2,863.85 2,863.85 2/8/19 359,116.00 October -18 2W29000000 18,103.12 18,103.12 2/8/19 359,116.00 November -18 2W29000000 21,290.04 21,290.04 2/8/19 359,116.00 December -18 2W29000000 31,509.25 95,746.59 31,509.25 2/8/19 263,369.41 December -18 "B" 2W29000000 10,941.68 10,941.68 3/19/19 263,369.41 December -18 "C" 2W29000000 58.51 58.51 3/19/19 263,369.41 January -19 2W29000000 4,813.47 15,813.66 4,813.47 3/19/19 247,555.75 February -19 2W29000000 29,585.38 29,585.38 29,585.38 4/12/19 217,970.37 March -19 2W29000000 15,634.88 15,634.88 15,634.88 6/24/19 202,335.49 April -19 2W29000000 44,824.68 44,824.68 44,824.68 5/28/19 157,510.81 May -19 2W29000000 38,328.98 38,328.98 38,328.98 7/9/19 119,181.83 June -19 2W29000000 119,181.83 119,181.83 119,181.83 7/17/19 - Totals 359,116.00 359,116.00 359,116.00 2W29000000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Account 5230.0000.6500.2W29000000.0000.00000000 Period ;Mar -18 Jan -18 Apr -18 May 18 Jun 18. Adj-18 Jul -18 Aug -18 Funds Available ( Detail Balances ) Budget Encumbrance 0.00 0.00 0.00 0.00 0.00'! 0.00' 0.00 0.00 0.00 000 359116.00 0.00' 359116.00', 0.00 0.00' 000 0.00'. 0.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 359116.00' 0.00 0.00 0.00 0.00 0.00 0.00 359116.00 0.00 Cancel 0.00 Account 5230.0000.6500 2W29000000.0000.00000000 Funds Available ( Detail Balances ) Period I Sep -18 Oct -18 Nov -18 Dec -18 Jan -19 .......... Feb -19 Mar 19 Apr -19 May -19 Jun -19 Budget Encumbrance 0 0Q', 0 00 0.00 0.00 0.00'. 0.00 0 00 0.00 0.00'' 0.00 0.00'. 0.00 359116.00' 0.00 0.00 0.00 0.00! 0.00 0.00 0.00 0 00 Actual 000 0.00 0.00. 95746.59 15813 66 29585 38 15634.88 44824.68 38328.98 119181 83', Funds Available 0 00 0.00 0.00 -95746.59 - 15813.66 - 29585.38 -15634.88 - 44824.68 -38328.98 -119181.83 0.00 359116.00', 0.00 Cancel COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part 3 GRANT CLOSEOUT RECONCILIATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 EA/WORKPLAN START DATE PROGRAM INCOME START DATE 10/1/2017 YEAR OF FUNDS TITLE/PROGRAM/PROJECT CLEAR Program code Page 1 of 2 PY18 WIOA ADULT LOCAL ADMIN 46A7000000 END DATE END DATE 6/30/2019 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 21,397.00 2. Current Program and Admin Cash Needs 0.00 3. FINAL Program and Admin Cash Needs Contract to Date 21,397.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 2. Current Expenses + Accruals (Through End Date of Award) 0.00 3. FINAL Program Expenses Contract to Date 0.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 21,397.00 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 21,397.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 21,397.00 2. FINAL Expenses Through End of Contract 21,397.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes 2 /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 2. Less Program Income Exoenses Through Contract End Date 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 21,397,00 3, Match Percentage of Expenditure Contracttual Requirement 0.00 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes 2 /No ❑ *The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signature —'/ / Date r'1,3 /?-0 ( j Authorized Signature Date i'^L,s ,E LiJ(.f See instruction for completing this for on the next tab (Attachment 1 2 of 2) X1O �q - 311i0 - t 7 CLEAR WIOA Reconciliation-PY18 WIOA Adult Local Admin Reporting Month I Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance October -17 46A7000000 21,397.00 November -17 46A7000000 21,397.00 December -17 46A7000000 21,397.00 January -18 46A7000000 21,397.00 February -18 46A7000000 21,397.00 March -18 46A7000000 21,397.00 April -18 46A7000000 21,397.00 May -18 46A7000000 21,397.00 June -18 46A7000000 21,397.00 July -18 46A7000000 21, 397.00 August -18 46A7000000 21,397.00 September -18 46A7000000 21,397.00 October -18 46A7000000 21,397.00 November -18 46A7000000 38.67 38.67 38.67 1/17/19 21,358.33 December -18 46A7000000 7,363.60 7,363.60 7,363.60 2/12/19 13,994.73 December -18 "B" 46A7000000 7,589.49 7,589.49 3/19/19 13,994.73 December -18 "C" 46A7000000 175.93 175.93 3/19/19 13,994.73 January -19 46A7000000 7,765.42 6,229.31 February -19 46A7000000 2,864.58 2,864.58 2,864.58 4/12/19 3,364.73 March -19 46A7000000 3,364.73 3,364.73 3,364.73 6/24/19 - April -19 46A7000000 - May -19 46A7000000 - June -19 46A7000000 - Totals 21,397.00 21,397.00 21,397.00 46A7000000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Account 5230.0000.6500.46A7000000.0000.00000000( Funds Available ( Detail Balances ) Period tvlar-17 Apr -17 Jun -17 Adj-T17 ul-17 Aug -17 Sep -17 Oct -17 Account 5230.0000.6500.46A7000000.0000.00000000( Period I1Dec-17 !Jan -18 Feb -18 ar-18 Apr -18 May -18 un-18 Adj-1 8 ;Jul-18� r ____ Aug -18 21397.00 Budget 0.00 0.00 0.00; 0.001 Q 00 0.00 0.00 0.00; 20870 00, Funds Available ( Detail Balances ) Budget 0 00 0.00 0.00, 000! 0.00 000 0.00', 527.00; 1.00` Encumbrance Actual Funds Available 0.00; 0.00 0.00 = 0.00! 000' 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 0 00 0.00 0.00 0.00 20870 00 000 000 0.00 v 0.00` 21397.00, Encumbrance 0 00, 0.00 0 00': 0.00 000' 0.00 00 0.00 000 0 00 0.00 Actual 000. 0.00: 000; 0.00' 000 000 000 000' 0.00 0.00 21397.00: 0.00 Funds Available 0.00 0.00 0 00 000 0.00 000 0.00 0.00 527 00 1.00v 0.00 J 0 Pencd Btiances (PA Account 5230.0000.6500.46A7000000.0000.00000000( Funds Available ( Detail Balances ) Period 10ct-18 Nov -18 .Dec -18 Jan -19 Feb -19 ;Mar -19 Apr -19 May -19 Jun -19 Budget Encumbrance 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 001. 0.00 0.00' -1.00 0 00i 21397.00!. 0 00 Actual 0.00' 0.001 38 67' 7363.60 7765 42 !, 2864 58 3364.73' 0.00 0.00 0.00 21397.00' Funds Available 0.00 ". 0.00 -38.67 -7363.60 - 7765 42 -2864.58 - 3364.73 0.00 Cancel 0.00 -1.00 _ 0.00 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part 3 GRANT CLOSEOUT RECONCILIATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 EA/WORKPLAN START DATE PROGRAM INCOME START DATE 10/1/2017 YEAR OF FUNDS Page 1 of 2 FY18 TITLE/PROGRAM/PROJECT DISLOCATED WORKER ADMIN CLEAR Program code 46D7000000 END DATE END DATE 6/30/2019 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 21,411.00 2. Current Program and Admin Cash Needs 0.00 3. FINAL Program and Admin Cash Needs Contract to Date 21,411.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 21,411.00 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 21,411.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 21,411.00 2. FINAL Expenses Through End of Contract 21,411.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes El /No ❑ V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Total PI Cash Previously Reported 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 2. Less Program Income Exoenses Through Contract End Date 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 21,411.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 /3Authorized Signature KAAJC_fh—e---,4--Q/L. Date A", a See instruction for completing this for on the next tab (Attachment H 2 of 2) X t9 -3780 - CLEAR WIOA Reconciliation-FY18 Dislocated Worker Admin Reporting Month Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance October -17 46D700000 21,411.00 November -17 46D700000 21,411.00 December -17 46D700000 21,411.00 December -17 "B" 46D700000 21,411.00 January -18 46D700000 21,411.00 February -18 46D700000 21,411.00 March -18 46D700000 4,610.47 4,610.47 4,610.47 5/29/18 16,800.53 April -18 46D700000 3,444.79 3,444.79 3,444.79 5/29/18 13,355.74 May -18 46D700000 4,156.05 4,156.05 4,156.05 7/13/18 9,199.69 June -18 46D700000 1,424.81 1,424.81 1,424.81 8/2/18 7,774.88 July -18 46D700000 7,774.88 August -18 46D700000 2,755.31 2,755.31 2,755.31 10/3/18 5,019.57 September -18 46D700000 5,018.57 4,483.57 4,483.57 10/26/18 536.00 October -18 46D700000 536.00 November -18 46D700000 536.00 December -18 46D700000 1.00 536.00 536.00 2/14/19 - January -19 46D700000 - Totals 21,411.00 21,411.00 21,411.00 46D700000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Account 5230.0000.6500.46D7000000.0000.00000000( Period 'Mar -17 Apr -17 May -17 Jun -17 Adj 17 Jul -17 Aug -17 Sep -17 Oct -17 Nov -17 Funds Available ( Detail Balances ) Budget Encumbrance 0.00 0.00 0.00 000; 0 00 0 00 0 00 0 00 0.00 0 00 0 00 0.00 000, 000: 000' 000'1 20875 00 0 00', 0.00 21411.00', 0.00 Actual Funds Available 0.00 0 00 - 0.00' 0 00' 0 00'. 0.00 0 00' 0 00', 000' 0 00'. 0.00 0.00 0.00 0.00 0.00 000 0.00 0.00 20875.00 000 _ 0 0, 21411 00 0.00 Cancel > ?er (RITD)N;t Account 5230 0000.6500,46D7000000.0000.00000000( Period 'Dec -17 Jan -18 :Feb -18 .................. Mar -18 Apr -18 May -18 Jun -18 Adi-18 Jut -18 Aug -18 Cancel Funds Available ( Detail Balances ) Budget 0 00 0.00 0.00 0.00 000 0.00', 0 00 0 00' 536 00' 1 001 Encumbrance 0.00 0 00 0.00 0 00 0 00' 0.00 000 000' 0 00 0 001. 21411.00' 0O0' Actual Funds Available 0 00 000 0.00 • 0.00 0.00 0.00 4610.47 4610.47 3444.79 -3444.79 4156.05 4156.05 1424.81 ! -1424.81 0.00; 0.00 0 00 536 00 2755 31 -2754.31 _ 21411.00' 0.00 - O Account 5230.0000.6500.46D7000000.0000.00000000( Funds Available ( Detail Balances ) Period I Sep -18 Oct -18 Nov -18 Dec -18 Jan -19 .Feb -19 Mar -19 Apr -19 May -19 Jun -19 Budget 0.00 0.00 0 00' -1.00 0.00' 0.00 0 00! 0.00: 0.00 0.00: 21411.00'i Encumbrance 000 0 00 0.00 000 0.00 0.00 0 00 000 0 00 0 00 0.00'; Actual Funds Available 4483.57 -4483.57 0.00 0.00 0.00 0 00 536.00 -537.00 0.00 000 0 00 0.00 0.001 0.00 0.00 0.00 0.00 0.00 000! 21411.00' Cancel 0.00 0.00 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part 3 GRANT CLOSEOUT RECONCILIATION WORKSHEET Page 1 of 2 SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 EA/WORKPLAN START DATE PROGRAM INCOME START DATE 10/1/2017 YEAR OF FUNDS FY18 TITLE/PROGRAM/PROJECT WIOA 25% DW Enhanced Admin CLEAR Program code 47D7000000 END DATE END DATE 6/30/2019 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 13,920.00 2. Current Program and Admin Cash Needs 0.00 3. FINAL Program and Admin Cash Needs Contract to Date 13,920.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 13,920.00 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 13,920.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 13,920.00 2. FINAL Expenses Through End of Contract 13,920.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes El /No ❑ V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Total PI Cash Previously Reported 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 2. Less Program Income Exoenses Through Contract End Date 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 13,920.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 17 /No ❑ 'The pmgram Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signature/ /I Date A // 3/200 a... -a... -Date rr� f I ��rlqq �'t:'L 1,9 Authorized Signature See instruction for completing this for on the next tab (Attachment H 2 of 2) ootq-3-11W 1q CLEAR WIOA Reconciliation-FY18 W/OA 25% DW Enhanced Admin Reporting Month 'Program Code ' Tracking Sheet ' CLEAR ' Received ' Date Received ' Grant Balance October -17 47D700000 13,920.00 November -17 47D700000 13,920.00 December -17 47D700000 13,920.00 December -17 "B" 47D700000 13,920.00 January -18 47D700000 13,920.00 February -18 47D700000 13,920.00 March -18 47D700000 13,920.00 April -18 47D700000 13,920.00 May -18 47D700000 13,920.00 June -18 47D700000 13,920.00 July -18 47D700000 13,920.00 August -18 47D700000 55.09 55.09 55.09 10/3/18 13,864.91 September -18 47D700000 895.32 895.32 895.32 10/26/18 12,969.59 October -18 47D700000 80.60 80.60 80.60 12/6/18 12,888.99 November -18 47D700000 627.90 627.90 627.90 1/17/19 12,261.09 December -18 47D700000 1,689.61 1,689.61 1,689.61 2/12/19 10,571.48 December -18 "B" 47D700000 1,966.40 1,966.40 3/19/19 10,571.48 December -18 "C" 47D700000 45.58 45.58 3/19/19 10,571.48 January -19 47D700000 2,011.98 8,559.50 February -19 47D700000 1,564.00 1,564.00 1,564.00 4/12/19 6,995.50 March -19 47D700000 1,892.03 1,892.03 1,892.03 6/24/19 5,103.47 April -19 47D700000 1,872.39 1,872.39 1,872.39 5/28/19 3,231.08 May -19 47D700000 2,179.24 2,179.24 2,179.24 7/9/19 1,051.84 June -19 47D700000 1,051.84 1,051.84 1,051.84 7/24/19 - Totals 13,920.00 13,920.00 13,920.00 47D700000 General ledger vs billied 0.0.0 Billed not received ' 0.00 General ledger vs. received 0.00 _ n x Account 5230.0000.6500.47D7000000.0000.00000000( Funds Available ( Detail Balances ) Period 'Mar -17 Apr -17 May -17 Jun -17 Adj-17 Jul -17 Aug -17 Sep -17 Oct -17 Nov -17 Budget 000 000', 0.00' 0.00 0.00 0.00 0.00'. 0.00 13920.00', 0.00 13920.00 Encumbrance 000 0.00' 0.00' 0.00! 0 00' 0.00''. Q 00' 0 00 0.00', 000 0 00 0.00 000 0.00 0 00' 0.00 0.00 000 0.00 13920.00 Actual Funds Available 0 00', 0.00 0.00 0.00 0 00 0.00 0.00 0.00 0.00 0.00 13920 00 0.00_ Cancel 0.00 es (PJTD) - Account 5230.0000.6500.47D7000000.0000.00000000( Funds Available ( Detail Balances ) Period Jan -18 Feb -18 Mar -18 Apr -18 May -18 Jun -18 Ad1-18 Jul -18 Aug -18 Budget Encumbrance 0.001 0.00' 0.00 0 00 0.00 0.00! 0.00 0 00 000 000', 0.00 0.00 000 0001 0.00 0.00. 0.00. 000; 0.00 1.00 13920.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 55.09 13920.00j, 0.00 -54.09 Cancel 0.00 0 Perod B ' O Account Period ........................ �-e Oct -18 •Nov -18 Dec -18 Jan -19 Feb -19 Mar -19 ................ Apr -19 May -19 Jun -19 5230.0000.6500.47D7000000.0000.00000000( Funds Available ( Detail Balances ) Budget Encumbrance 0.00 0.00 0.00 000 0.00 0 00 000 000' 0.00 0.00 0 00 ; 0.00 000' 000! 0 00' 0 00' 0 00 0 00' -1.00' 0 00 13920.00', 0.00 Actual Funds Available 895.32 -895.32 80.60 -80.60 627.90' -627 90 1689.61 -1689.61 2011.98 -2011.98 1564.00 1564.00 1892 03 -1892.03 1872.39, -1872.39 2179 24 -2179.24 1051 84: -1052.84 13920.00 0 00 Cancel COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT GRANT CLOSEOUT RECONCILIATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 EA/W0RKPLAN START DATE PROGRAM INCOME START DATE 10/1/2017 YEAR OF'FUNDS TITLE/PROGRAM/PROJECT CLEAR Program code Closeout Part 3 Page 1 of 2 FFY18 WIOA Adult Local Program 48A7000000 END DATE END DATE 6/30/2019 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 401,256.00 2. Current Program and Admin Cash Needs 0.00 3. FINAL Program and Admin Cash Needs Contract to Date 401,256.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 401,256.00 2. Current Expenses + Accruals (Through End Date of Award) 0.00 3. FINAL Program Expenses Contract to Date 401,256.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 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 401,256.00 2. FINAL Expenses Through End of Contract 401,256.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes 2 /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 2. Less Program Income Exoenses Through Contract End Date 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 401,256.00 3. Match Percentage of Expenditure Contracttual Requirement 0.00 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes 2 /No ❑ 'The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signature /Tk::::�, Date / Ot' �� Authorized Signature A�-G/��LC�CJ�� , 1 # f//i Date A� n!2, See instruction for completing this for on the next tab (Attachment H 2 of 2) X19-3780 --aD CLEAR WIOA Reconciliation-FFY18 WIOA Adult Local Program Reporting Month 1Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance October -17 48A700000 401,256.00 November -17 48A700000 401,256.00 December -17 48A700000 401,256.00 December -17 "B" 48A700000 401,256.00 January -18 48A700000 401,256.00 February -18 48A700000 35,035.89 35,035.89 35,035.89 5/29/18 366,220.11 March -18 48A700000 48,870.15 48,870.15 48,870.15 5/29/18 317,349.96 April -18 48A700000 65,320.01 65,320.01 65,320.01 5/29/18 252,029.95 May -18 48A700000 55,182.21 55,182.21 55,182.21 7/13/18 196,847.74 June -18 48A700000 149,747.90 149,747.90 149,747.90 8/2/18 47,099.84 July -18 48A700000 40,980.79 40,980.79 40,980.79 9/10/18 6,119.05 August -18 48A700000 1,378.05 1,378.05 1,378.05 10/3/18 4,741.00 September -18 48A700000 4,741.00 October -18 48A700000 4,741.00 November -18 48A700000 4,741.00 4,741.00 December -18 48A700000 4,741.00 4,741.00 2/12/19 (0.00) January -19 48A700000 (0.00) Totals 401,256.00 401,256.00 401,256.00 48A700000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Account 5230.0000.6500.48A7000000.0000. 00000000( Period Oct -17 Nov -17 Dec -17 Jan -18 Feb -18 Mar 18 Apr 18 May -18 Jun -18 Adj-18 Budget 396515 00. 0.00 0.00 0.00 000' 0.00 OOO€ 000 0.001 0.001 Funds Available ( Detail Balances ) Encumbrance 0.00 0.00; 0.00 000 0.00 0.00 0.00 000, . 0.00 0.001 401256.00; 0.00` Actual 000; 0.00 0.00, 0.00 35035.89≤ 48870.15,. 65320.01;, 55182 21 149747.90 0.00 Funds Available 396515.00 0.00 0.00 000` -35035.89 4887015: -65320.01 -55182.21 -149747.90 0.00 401256.00' 0.00 Account ",.5230.0000.6500.48A7000000.0000.00000000( Funds Available ( Detail Balances ) Period 'Adj 18 Jul -18 Aug -18 Sep -18 Oct -18 _Nov -18 Dec -18 Jan -19 Feb -19 Mar -1 Budget 0.001 4741.00! 0001 0.00: 000 000% 0.00i 0 00 0.001 0 00! 401256 00I Encumbrance 0.00 0 00 0 00 0 00'' 0.00 0 00 0.00 0.00 0.00 0 00' 0.00 0.00; o.0a 0.o0 Actual 40980.79 1378.05' 0.00 0.00: 0.00 4741.00` 401256.40 Funds Available 000 -36239.79 -1378 05 0 00 0.00 0.00 -4741.00 0.00 0.00 0.00 0.00 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part 3 GRANT CLOSEOUT RECONCILIATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 EA/W0RKPLAN START DATE PROGRAM INCOME START DATE 10/1/2017 YEAR OF FUNDS TITLE/PROGRAM/PROJECT WIOA DISLOCATED WORKER PROGRAM CLEAR Program code Page 1 of 2 FFY18 48D7000000 END DATE END DATE 6/30/2019 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 192,694,00 2. Current Program and Admin Cash Needs 0.00 3. FINAL Program and Admin Cash Needs Contract to Date 192,694.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 192,694.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 192,694.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 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 192,694.00 2. FINAL Expenses Through End of Contract 192,694.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 1. FINAL Program Income Cash 2. Less Program Income Exoenses Through Contract End Date 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 192,694.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 ,R it, I ZOk' Authorized Signature /C`� .A--,.A--,p Date : 4; See instruction for completing this for on the next tab (Attachment H 2 of 2) aolq-3"1 O -, ,l CLEAR WIOA Reconciliation-FY18 WIOA Dislocated Worker Prog Reporting Month Program Code 1 Tracking Sheet 1 CLEAR I Received I Date Received I Grant Balance October -17 48D700000 192,694.00 November -17 48D700000 192,694.00 December -17 48D700000 192,694.00 December -17 "B" 48D700000 192,694.00 January -18 48D700000 192,694.00 February -18 48D700000 15,143.52 15,143.52 15,143.52 5/29/18 177,550.48 March -18 48D700000 10,505.45 10,505.45 10,505.45 5/29/18 167,045.03 April -18 48D700000 15,718.21 15,718.21 15,718.21 5/29/18 151,326.82 May -18 48D700000 7,254.17 7,254.17 7,254.17 7/13/18 144,072.65 June -18 48D700000 27,957.01 27,957.01 27,957.01 8/2/18 116,115.64 July -18 48D700000 41,912.87 41,912.87 41,912.87 9/10/18 74,202.77 August -18 48D700000 45,978.83 45,978.83 45,978.83 10/3/18 28,223.94 September -18 48D700000 28,223.94 23,401.94 23,401.94 10/26/18 4,822.00 October -18 48D700000 4,822.00 November -18 48D700000 4,822.00 December -18 48D700000 4,822.00 4,822.00 2/12/19 (0.00) January -19 48D700000 (0.00) Totals 192,694.00 192,694.00 192,694.00 48D700000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Account 5230.0000.6500.48D7000000.0000.00000000( Funds Available ( Detail Balances ) Period I Sep -17 Oct -17 Nov -17 Dec 17 Jan -18 Feb -18 Mar -18 Apr -18 May -18 Jun -18 Budget 0001 187872.00' 0.00 0.00 0.00' 0.00 0.00 000 0.00 0 00 192694 00' Encumbrance 0.00 0.00 0.00 0.00 0 00 0.00, 000 0.00 0.00 0.00 000= Actual 0 00' 000. 0.00 0.00 0 00 15143 52', 10505 45' 15718 21 7254 17 27957 011 192694.00: Funds Available 0.00 '. 187872.00 0.00 0 00 000 -15143.52 -10505.45 -15718 21 -7254.17 -27957.01 Cancel 0.00 Account 5230.0000.6500.48D7000000.0000.00000000( Period Adj-18 Jul -18 Aug -18 ,Sep -18 `Oct -18 Nov -18 Dec -18 Jan -19 Feb -19 Mar -19 0.00' 0.00 000'; 000! 0.00, 0.00 192694.00; Funds Available ( Detail Balances ) Budget Encumbrance 0.00 0.00 4822.00 0.00 0.00' 0.00 0 00' 0 00 0.00 0 00 0.00 000 0 00 0.00 0.00 Actual Funds Available 0 00 0.00 - 41912.87 -37090.87 45978.83 -45978.83 23401.94! -23401.94 0.00 0 00 0 00, 0.00 4822 00. -4822.00 0 00 0.00 0.00; 0.00 000 192694.00 Cancel 0.00 _ 0.00 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part 3 GRANT CLOSEOUT RECONCILIATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 EA/W0RKPLAN START DATE PROGRAM INCOME START DATE 4/1/2017 YEAR OF FUNDS TITLE/PROGRAM/PROJECT 25% EDW WORK -BASED LEARNING CLEAR Program code Page 1 of 2 FFY17 49D6000000 END DATE END DATE 6/30/2019 I. CASH REQUEST �' s 1. Total program and Admin Cash needs Preciously Reported 103,907.00 2. Current Program and Admin Cash Needs 0.00 3. FINAL Program and Admin Cash Needs Contract to Date 103,907.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 103,907,0O 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 103,907.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 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 103,907.00 2. FINAL Expenses Through End of Contract 103,907.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes El /No 0 V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 VI. RECONCILIATION 1. FINAL Program Income Cash 2. Less Program Income Exoenses Through Contract End Date 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 103,907.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 ".,7 7 Date Xi2I ,0(i Authorized Signature Date' .v t 't' See instruction for completing this for on the next tab (Attachment H 2 of 2) ao t 9.3 -1 0- � a CLEAR WIOA Reconciliation-FY17 25% EDW Work Based Learning Prog Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance April -17 49D600000 103,907.00 May -17 49D600000 103,907.00 June -17 49D600000 103,907.00 July -17 49D600000 49.51 49.51 10/20/17 103,907.00 August -17 49D600000 103,907.00 September -17 49D600000 49.51 103,857.49 October -17 49D600000 634.59 634.59 634.59 11/27/17 103,222.90 November -17 49D600000 3,448.94 3,448.94 3,448.94 12/21/17 99,773.96 December -17 49D600000 7,279.02 7,279.02 7,279.02 2/1/18 92,494.94 December -17 "B" 49D600000 1,838.31 1,838.31 2/27/18 92,494.94 January -18 49D600000 266.47 2,104.78 266.47 2/27/18 90,390.16 February -18 49D600000 6,502.93 6,502.93 6,502.93 5/29/18 83,887.23 March -18 49D600000 12,760.64 12,760.64 12,760.64 5/29/19 71,126.59 April -18 49D600000 12,545.03 12,545.03 12,545.03 5/29/18 58,581.56 May -18 49D600000 20,366.83 20,366.83 20,366.83 7/13/18 38,214.73 June -18 49D600000 21,842.44 21,842.44 21,842.44 8/2/18 16,372.29 July -18 49D600000 1,743.14 1,743.14 1,743.14 9/10/18 14,629.15 August -18 49D600000 3,182.15 3,182.15 3,182.15 10/3/18 11,447.00 September -18 49D600000 2,057.79 2,057.79 2,057.79 10/26/18 9,389.21 October -18 49D600000 1,348.99 1,348.99 1,348.99 12/6/18 8,040.22 November -18 49D600000 1,141.17 1,141.17 1,141.17 1/11/19 6,899.05 December -18 49D600000 6,899.05 January -19 49D600000 6,899.05 February -19 49D600000 6,899.05 March -19 49D600000 1,223.57 1,223.57 1,223.57 5/14/19 5,675.48 April -19 49D600000 1,484.05 1,484.05 1,484.05 5/28/19 4,191.43 May -19 49D600000 4,191.43 4,191.43 4,191.43 7/9/19 0.00 June -19 49D600000 - 0.00 Totals 103,907.00 103,907.00 103,907.00 49D600000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Account 5230.0000.6500.49D6000000.0000.00000000( Funds Available ( Detail Balances ) Period Budget Encumbrance Mar -17 0.00', 0.00 Apr -17 141840.00 0.001 May -17 0.00 0.00 Jun -17 0.00 0.00 Adj-17 7 0.00 0.00 Jul -17 0.00 0.00 Aug -17 0.00 0.00 Sep -17 000 000 Oct -17 0.00 0.00 ' Nov -17 0.00, O00 103907.00'! Actual Funds Available 0.00 0.00 ±- 0.00 0.00' 0.00 0.00 0.00' 0.00'. 4951'. 634.59 3448.94 0.00', 103907.00 141840.00 0.00 0.00 0.00 0.00 0.00 -49.51 -634.59 -3448.94 Cancel 0.00 Account 5230.0000.6500.49D6000000.0000.00000000t Funds Available ( Detail Balances ) Period Jan -18 Feb -18 Mar -18 Apr -18 May -18 Jun -18 Adj-18 Jul -18 Aug -18 Budget 0.00. 0.00', 0.00 0.00 0.00 0.00 0 00 0 00 0.00'. 1 00! 103907.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 Funds Available 7279.02 -7279 02 2104 78 -2104.78 6502.93 -6502.93 12760 64 -12760.64 12545 03; -12545 03 20366.83 -20366.83 21842.44 -21842.44 0.00 0.00 1743.14 i -1743.14 3182.15; -3181.150 103907.00'; 0.00 Cancel es (P Account 5230.0000.6500.49D6000000.0000.00000000( Funds Available ( Detail Balances ) Period Oct -18 Nov -18 Dec -18 Jan -19 Feb 19 Mar -19 Apr -19 May -19 Jun -19 Budget 0.00 0.00 000 0.00' 0.00' 0 00 0.00', -44000 00 -1.00 • 103907.00 Encumbrance 0.00 0.00 0.00 0.00 000 0.00 0.00 000 0.00 0.00 Actual Funds Available 2057.79 -2057 79 1348.99 -1348.99 1141.1T -1141.17 0.00 0.00 0.00 0.00 0.00 0.00 1223.57', 1223.57 1484.05 -1484.05 4191 43'; 48191.43 0.00 -1.00 , 103907.00 0.00 Cancel COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT GRANT CLOSEOUT RECONCILIATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 EA/WORKPLAN START DATE PROGRAM INCOME START DATE 10/1/2017 YEAR OF FUNDS TITLE/PROGRAM/PROJECT WIOA 25% DW Enhanced Prog Local CLEAR Program code Closeout Part 3 Page 1 of 2 FFY18 49D7000000 END DATE END DATE 6/30/2019 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 125,285.00 2. Current Program and Admin Cash Needs 0.00 3. FINAL Program and Admin Cash Needs Contract to Date 125,285.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 125,285.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 125,285.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 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 125,285.00 2. FINAL Expenses Through End of Contract 125,285.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes D /No ❑ V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 VI. RECONCILIATION 1. FINAL Program Income Cash 2. Less Program Income Exoenses Through Contract End Date 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 125,285.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 Cl *The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signature /� 7 Date ell ; izo i `j Authorized Signature �L Date . 1 — See instruction for completing this for on the next tab (Attachment H 2 of 2) QC) I9 - G3 CLEAR WIOA Reconciliation-WIOA 25% DW Enhanced Program Reporting Month 'Program Code I Tracking Sheet I CLEAR 1 Received I Date Received I Grant Balance October -17 49D700000 125,285.00 November -17 49D700000 125,285.00 December -17 49D700000 125,285.00 December -17 "B" 49D700000 125,285.00 January -18 49D700000 125,285.00 February -18 49D700000 125,285.00 March -18 49D700000 125,285.00 April -18 49D700000 125,285.00 May -18 49D700000 125,285.00 June -18 49D700000 125,285.00 July -18 49D700000 882.29 882.29 882.29 9/10/18 124,402.71 August -18 49D700000 7,086.81 7,086.81 7,086.81 10/3/18 117,315.90 September -18 49D700000 5,303.78 5,303.78 5,303.78 10/26/18 112,012.12 October -18 49D700000 13,793.19 13,793.19 13,793.19 12/6/18 98,218.93 November -18 49D700000 14,432.13 14,432.13 14,432.13 1/17/19 83,786.80 December -18 49D700000 19,209.47 19,209.47 19,209.47 2/12/19 64,577.33 December -18 "B" 49D700000 5,830.51 5,830.51 3/19/19 64,577.33 December -18 "C" 49D700000 (147.22) (147.22) 3/19/19 64,577.33 January -19 49D700000 18,851.83 24,535.12 18,851.83 3/19/19 40,042.21 February -19 49D700000 23,356.55 23,356.55 23,356.55 4/12/19 16,685.66 March -19 49D700000 16,685.66 16,685.66 16,685.66 6/24/19 - April -19 49D700000 - May -19 49D700000 - June -19 49D700000 - - Totals 125,285.00 125,285.00 125,285.00 49D700000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 PST Account5230.0000.6500.49D7000000 0000.00000000( Funds Available ( Detail Balances ) Period Oct -17 Nov -17 Dec -17 Jan -18 Feb -18 Mar -18 Apr -18 May -18 Jun -1 Account Period Jul -18 Aug -18 'Sep18 Oct -18 INov 18 ,Dec -18 Jan -19 Feb -19 Mar -19 !Apr -19 Budget 125285 00 0 00 , 000; 0.00 000 0.00 0.00 0.00 0.00! 000' 125286.00' Encumbrance 0.00 0.00 0.00' 0.00 000; 0 00 0 00 0.00 000! 0.00 5230.0000.6500.49D7000000.0000.00000000( Funds Available ( Detail Balances ) Budget 0 00' 1.00 0.001 0.00, 0 00 0.001E 0 00 0.00' 0 00 125286.00'; Encumbrance 0 00 0.00! a00' 000 0 00 0 00' 0.00 0 00 0.00! 000 Actual Funds Available 0.00, 125285 00 000; 0.00 0.00; 0.00 000 000' 000' 000 0 00 0.00 0.00 0 00 000; 000 0.00 0.00 0.00: 0.00 125285.00 1.00 Cancel Actual Funds Available 882.29' -882.29- 7086 81! -7085.81 5303.78 -5303.78 13793.19 i -13793 19 14432.13; -14432.13 19209.47' -19209.47 24535 121 -24535 12 23356.55 -23356.55 16685.66 -16685.66 0.00 0.00 0.00' 125285.00': 1.00 Cancel n 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/2017 YEAR OF FUNDS Page 1 of 2 PY17 TITLE/PROGRAM/PROJECT WIOA ADULT 10% ADMIN CLEAR Program code 4A67000000 END DATE END DATE 6/30/2019 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 2. Current Program and Admin Cash Needs 3,045.00 3. FINAL Program and Admin Cash Needs Contract to Date 3,045.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 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) 3,045.00 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 3,045.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 3,045.00 2. FINAL Expenses Through End of Contract 3,045.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes 2 /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 3,045.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. 1 SignatureDate :::::Signature Date A! rG .( . r See instruction for completing this for on the next tab (Attachment H 2 of 2) Do iq -3-mo - �H CLEAR WIOA Reconciliation-PY17 WIOA Adult 10% Admin Reporting Month 'Program Code I Tracking Sheet 1 CLEAR I Received I Date Received I Grant Balance July -17 4A6700000 3045.00 August -17 4A6700000 3045.00 September -17 4A6700000 3045.00 October -17 4A6700000 3045.00 November -17 4A6700000 3045.00 December -17 4A6700000 3045.00 January -18 4A6700000 3045.00 February -18 4A6700000 3045.00 March -18 4A6700000 3045.00 April -18 4A6700000 796.75 796.75 796.75 5/29/18 2248.25 May -18 4A6700000 2248.25 2248.25 2248.25 7/13/18 0.00 June -18 4A6700000 0.00 July -18 4A6700000 0.00 August -18 4A6700000 0.00 September -18 4A6700000 0.00 October -18 4A6700000 0.00 Totals 3045.00 3045.00 3045.00 4A6700000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Account 5230.0000.6500.4A67000000.0000.00000000( Funds Available ( Detail Balances ) Period ' Jul -17 Aug -17 Sep -17 Oct -17 Nov -17 Dec -17 Jan -18 Feb -18 Mar -18 Apr -18 Account 5230.0000.6500,4A67000000.0000.00000000( Period 1 Jun -18 Ada_18.. Jul -18 Aug -18 Sep -18 :Oct 18 :Nov -18 Dec -18 an -19 Budget Encumbrance 3045.00 0.00. a 00 0.00 0.001 a 00 0.00 0 00 0.00; 0 00! 0.00' 000: 3045.00 Funds Available ( Detail Balances ) 0.00 0.00 0 00, ❑ 00' 0 00 0 00' 0 00' 0 00 0.00 Budget Encumbrance 0.00' 0 00!. 0.00 0 00' 0.00 0.00 0.00 0001 0.00i 0.00 0.00. 0 00' 0001 0.00' 0.001:, 0 00 0.00 0 00''. a 00 0_00 3045.00'1 0.00'i. Actual Funds Available 0.00 3045.00 0 00 0.00 0,00 __ 0.00 000 0.00 0.00 0.00 0.00 000 0.00 -796.75 . 0.00 0.00' 0.001, 0001 0.00 796 75 3045.00; 0.00 Actual Funds Available 2248.25 -2248.25 0.00 .-_ . . 0.00 0.00 0.00 000 000 0 00 0.00 0.00 000 0 00 0 00 0 00 0.00 0.00. 0 00 004:. 000 3045.00 ` 0.00 Cancel COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part 3 GRANT CLOSEOUT RECONCILIATION WORKSHEET Page 1 of 2 SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 EA/WORKPLAN START DATE PROGRAM INCOME START DATE 7/1/2017 YEAR OF FUNDS TITLE/PROGRAM/PROJECT CLEAR Program code PY17 WIOA Adult Program 4A87000000 END DATE END DATE 6/30/2019 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 57,861.00 2. Current Program and Admin Cash Needs 0.00 3. FINAL Program and Admin Cash Needs Contract to Date 57,861.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 57,861.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 57,861.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 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 57,861.00 2. FINAL Expenses Through End of Contract 57,861.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 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 57,861 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 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 1 / Date 9 I 13 1.7,14) 14) Authorized Signatur _Lt /�C/� Date (r ' _ u ,r,r; _ _ .. . See instruction for completing this for on the next tab (Attachment H 2 of 2) O0 - 378'6 - �5 CLEAR WIOA Reconciliation-PY17 WIOA Adult Program Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance July -17 4A8700000 57,861.00 August -17 4A8700000 57,861.00 September -17 4A8700000 57,861.00 October -17 4A8700000 57,861.00 November -17 4A8700000 57,861.00 December -17 4A8700000 19,311.86 19,311.86 19,311.86 2/1/18 38,549.14 December -17 "B" 4A8700000 13,841.50 13,841.50 2/27/18 57,861.00 January -18 4A8700000 16,074.15 29,915.65 16,074.15 2/27/18 8,633.49 February -18 4A8700000 8,633.49 8,633.49 8,633.49 5/29/18 March -18 4A8700000 - April -18 4A8700000 - May -18 4A8700000 - June -18 4A8700000 - July -18 4A8700000 - August -18 4A8700000 - September -18 4A8700000 - October -18 4A8700000 - Totals 57,861.00 57,861.00 57,861.00 4A8700000 General ledger vs bullied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Account 5230.0000.6500.4A87000000.0000.00000000( Period Aug -17 ,Sep -17 Oct -17 Nov -17 Dec -17 ............ Jan -18 Feb -18 Mar -18 Apr -18 Budget 57861 00 0.00 000! 0.00 0 00 0.00 0 00 0.00 0.00; 0.00: 57861 00 Funds Available ( Detail Balances ) Encumbrance 0.00 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' 57861.00 = 000 000 0.00 0.00 000 000 000 0.00 19311 86 19311.86 29915 65 -29915.65 8633.49 -8633.49 0.00 0.00 0.00 0.00 . 57861.0O: 0.00 Cancel COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part 3 GRANT CLOSEOUT RECONCILIATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 EA/W0RKPLAN START DATE PROGRAM INCOME START DATE 10/1/2017 YEAR OF FUNDS TITLE/PROGRAM/PROJECT WIOA DW-ADMIN TRANSFER TO ADULT CLEAR Program code Page 1 of 2 FY18 4BD7000000 END DATE END DATE 6/30/2019 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 20,874.00 2. Current Program and Admin Cash Needs 0.00 3. FINAL Program and Admin Cash Needs Contract to Date 20,874.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 20,874.00 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 20,874.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 20,874.00 2. FINAL Expenses Through End of Contract 20,874.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 20,874.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 I: /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 t3 406/ Authorized Signature t Date f -.l_ ni 2 See instruction for completing this for on the next tab (Attachment H 2 of 2) ao19-378'0 CLEAR WIOA Reconciliation-FY18 WIOA DWAdmin Transfer to Adult Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received Grant Balance October -17 48D700000 20,874.00 November -17 4BD700000 20,874.00 December -17 4BD700000 20,874.00 December -17 "B" 4BD700000 20,874.00 January -18 4BD700000 20,874.00 February -18 4BD700000 20,874.00 March -18 4BD700000 20,874.00 April -18 4BD700000 20,874.00 May -18 4BD700000 20,874.00 June -18 4BD700000 8,227.19 8,227.19 8,227.19 8/2/18 12,646.81 July -18 4BD700000 12,646.81 August -18 4BD700000 2,728.30 2,728.30 2,728.30 10/3/18 9,918.51 September -18 4BD700000 6,044.86 6,044.86 6,044.86 10/26/18 3,873.65 October -18 4BD700000 1,016.40 1,016.40 1,016.40 10/26/18 2,857.25 November -18 4BD700000 2,857.25 2,857.25 2,857.25 1/17/19 - December -18 4BD700000 - January -19 4BD700000 - Totals 20,874.00 20,874.00 20,874.00 4BD700000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Account 5230.0000.6500.4BD7000000.0000.000000001 Funds Available ( Detail Balances ) Period Oct -17 ;Nov -17 Dec -17 Jan -18 Feb -18... Mar -18 Apr -18 May -18 'Jun -18 Adj-18 Budget 20874.00 0.00 0.00', 0.00! 0.00 0.00 0.00 0.00 0.00 0.00' 20875.00 Encumbrance 0.00 000 0.00! 0.00i 000: 0 00. 0 00 0.00 0 00: 0 00 0.00 Actual Funds Available 0.00 20874.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 00 0.00 0 00 8227.19 0.00 20874.00 0.00 0.00 0.00 - 8227.19 o00W Cancel 1.00 0 Period Ettances (RITE * May - Account 5230.0000.6500.4BD7000000.0000.00000000I Period Aug -18 Sep -18 Oct -18 Nov -18 Dec -18 Jan -19 Feb -19 Mar -19 Apr -19 Funds Available ( Detail Balances ) Budget Encumbrance 0.00 000` 1.00 0.00' 0.00 000 0 00 0 00 0 00 0.00 0.00 0 00'. 0.00 0.00 000 000 0.00' 0.00 0.00 0.00 20875.00' 0.00' Actual 0.00 2728.30 6044.86 1016 40' 2857.25 0.00' 0.00 0.00 0.00 0.00 Funds Available 0.00 -2727 30 - 6044.86 - 1016.40 - 2857.25 0.00 0.00 0.00 0.00 000 20874.00' 1.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/2017 YEAR OF FUNDS Page 1 of 2 PY17 TITLE/PROGRAM/PROJECT WI0A DW 10% COUNTY ADMIN CLEAR Program code 4D67000000 END DATE END DATE 6/30/2019 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 3,918.00 2. Current Program and Admin Cash Needs 0.00 3. FINAL Program and Admin Cash Needs Contract to Date 3,918.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 3,918.00 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 3,918.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 3,918.00 2. FINAL Expenses Through End of Contract 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) 3,918.00 Yes 2 /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 3,918.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 1 / Date r(II I G o 1 Authorized Signature �� "' _114-0-A--./.---, Date r. } , r 1P See instruction for completing this for on the next tab (Attachment H 2 of 2) ao 1a -31g0 - a� CLEAR WIOA Reconciliation-PY17 WIOA DW 10% County Admin Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance July -17 4D6700000 3,918.00 August -17 4D6700000 3,918.00 September -17 4D6700000 3,918.00 October -17 4D6700000 3,918.00 November -17 4D6700000 3,918.00 December -17 4D6700000 3,918.00 December -17 "B" 4D6700000 3,918.00 January -18 4D6700000 3,918.00 February -18 4D6700000 3,918.00 March -18 4D6700000 3,918.00 3,918.00 3,918.00 5/29/18 - April -18 4D6700000 - May -18 4D6700000 - June -18 4D6700000 - Totals 3,918.00 3,918.00 3,918.00 4D6700000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Account 15230.0000.6500 4O67000000.0000.00000000( Funds Available ( Detail Balances ) Period ' Jul -17 Aug -17 Sep -17 Oct 17 Nov -17 Dec -17 Jan -18 Feb -18 Mar -18 Apr -18 Budget 3918.00 0 00 0.00 0.00 0.00 0.00 0.00 0 00 0.00! 0.00'' 3918.00 Encumbrance 0.00! 0 00' 0 00 0 00' 0 00 000 0.00 0 00! 0.00 000, 0.00'1 Actual Funds Available 0.00 3918.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 3918.00 -3918.00 000 0.00„ 3918.00' Cancel 0.00 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part 3 GRANT CLOSEOUT RECONCILIATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 EA/WORKPLAN START DATE PROGRAM INCOME START DATE 7/1/2017 YEAR OF FUNDS TITLE/PROGRAM/PROJECT WIOA DISLOCATED WORKER PROGRAM CLEAR Program code Page 1 of 2 PY17 4D87000000 END DATE END DATE 6/30/2019 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 35,261.00 2. Current Program and Admin Cash Needs 0.00 3. FINAL Program and Admin Cash Needs Contract to Date 35,261.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 35,261.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 35,261.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 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 35,261.00 2. FINAL Expenses Through End of Contract 35,261.00 3. Cash Request to Date = Expense reported Through End Date of Contract'? (Check Box) Yes O /No 0 V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 VI. RECONCILIATION 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 VII. MATCH RECONCILIATION 1. FINAL Match Reported Through End of Contract 0.00 2. FINAL Expenses Through End of Contract 35,261.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 3 /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 /G f Date I� 1l3I rN y ��/��(////4 ( n , Authorized Signature 9 C� lebt-i ' l�/L' Date /' n � �� (. .� 1 See instruction for completing this for on the next tab (Attachment H 2 of 2) 19 - 31S -me- CLEAR WIOA Reconciliation-PY17 WIOA Dislocated Worker Program Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance July -17 4D8700000 35,261.00 August -17 4D8700000 35,261.00 September -17 4D8700000 35,261.00 October -17 4D8700000 35,261.00 November -17 4D8700000 35,261.00 December -17 4D8700000 4,287.19 4,287.19 4,287.19 2/1/18 30,973.81 December -17 "B" 4D8700000 13,535.04 13,535.04 2/27/18 30,973.81 January -18 4D8700000 4,654.71 18,189.75 4,654.71 2/27/18 12,784.06 February -18 4D8700000 12,784.06 12,784.06 12,784.06 5/29/18 - March -18 4D8700000 - April -18 4D8700000 - May -18 4D8700000 - June -18 4D8700000 - Totals 35,261.00 35,261.00 35,261.00 4D8700000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Account 5230.0000.6500.4 D87000000.0000.00000000( Funds Available ( Detail Balances ) Period Jul -17 'Aug -17 'Sep -17 Oct -17 Nov -17 I Dec -17 Jan -18 Feb -18 •Mar -18 Apr -18 Budget Encumbrance 35261.00 0 00! 0.00 0.00:. 0 00 0.00 0 00!. 0 00', 0.00! 0 35261.00: 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 0001 0 00 0.00 428719', 18189 75', 12784 06', 0.00: 0.00' 35261 00 Funds Available 35261.00 0.00 0.00 0.00 0.00 -4287.19 -18189.75 -12784.06 0.00 0.00 _ Cancel 0.00 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part 3 GRANT CLOSEOUT RECONCILIATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 EA/WORKPLAN START DATE PROGRAM INCOME START DATE 7/1/2017 YEAR OF FUNDS TITLE/PROGRAM/PROJECT DW ADMIN TRANSFER TO ADULT ADMIN CLEAR Program code Page 1 of 2 PY17 4DB7000000 END DATE END DATE 6/30/2019 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 3,917.00 2. Current Program and Admin Cash Needs 0.00 3. FINAL Program and Admin Cash Needs Contract to Date 3,917.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 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) 3,917.00 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 3,917.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 3,917.00 2. FINAL Expenses Through End of Contract 3,917.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes 1 /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 3,917.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 Signature7/ . Date �/ t 3) �� Authorized Signature/4 e/� Date � ' 4. See instruction for completing this for on the next tab (Attachment H 2 of 2) CLEAR WIOA Reconciliation-PY17 WIOA DW ADMIN TRANSFER TO ADULT ADMIN Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received 1 Date Received I Grant Balance July -17 4DB700000 3,917.00 August -17 4DB700000 3,917.00 September -17 4DB700000 3,917.00 October -17 4DB700000 3,917,00 November -17 4DB700000 3,917.00 December -17 4DB700000 3,917.00 December -17 "B" 4DB700000 3,917.00 January -18 4DB700000 3,917.00 February -18 4DB700000 3,917.00 March -18 4DB700000 3,917.00 April -18 4DB700000 3,917.00 May -18 4DB700000 1,832.85 1,832.85 1,832.85 7/13/18 2,084.15 June -18 4DB700000 2,084.15 2,084.15 2,084.15 8/2/18 - Totals 3,917.00 3,917.00 3,917.00 4DB700000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 xI Account 5230.0000.6500.4DB7000000.0000.0000000O Funds Available ( Detail Balances ) Period Jul -17 Aug -17 Sep -17 Oct -17 I Nov -17 Dec -17 Jan -18 Feb -18 Mar -18 Apr -18 Budget 3917.00 0.00 0.00 0.00; 0 00 0 00 0 00' 0.00 • 0.00 000; 3917.00! Encumbrance 0 00 0.00 0 00... 0.00 0 00 0 00 0 00' 000' 0.00 0 00 0.00 Actual Funds Available 0.00 3917.00 0 00 0.00 0.00 0 00 0.00 0.00 0 0 000 0 00 000 000__ 000 0.00 0.00 0.00 0.00 0.00 0.00 _ 3917 00 Cancel 0.00 Account 5230.0000.6500.4DB7000000.0000.00000000' Period IMay18 Jun -18 Add 18 Jul 18 Aug -18 Sep -18 Oct 18 Nov -18 Dec -18 Jan -19 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 3917.00 Encumbrance 0.00 0 00 000 0.00 0 00', 0.001 0.00' 0.00 0 00! 0.00 0.00 Actual Funds Available 1832.85 ! 1832.85 208415. -2084.15 0.00: 0.00 0.00 ! 0.00 0 001 0.00 0 00 0.00 0.00 0.00 0.00 _ 0.001 0.00`: 0 00' 0.001 0.00' 3917 00 Cancel 0.00 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part 3 GRANT CLOSEOUT RECONCILIATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 EA/WORKPLAN START DATE PROGRAM INCOME START DATE 7/1/2017 YEAR OF FUNDS Page 1 of 2 PY17 TITLE/PROGRAM/PROJECT DW PROGRAM TRANSFER TO ADULT CLEAR Program code 4DN7000000 END DATE END DATE 6/30/2019 I. CASH REQUEST 1 Total program and Admin Cash needs Preciously Reported 35,261.00 2. Current Program and Admin Cash Needs 0.00 3. FINAL Program and Admin Cash Needs Contract to Date 35,261.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 35,261.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 35,261.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 0.00 III. PROGRAM INCOME(PI) EXPENSE REPORT 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION 1. FINAL Cash Request Contract to Date 35,261.00 2. FINAL Expenses Through End of Contract 35,261.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 35,261.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 Federa/ funding period. Preparer's Signature Date e, It 2, I:2o 1 Authorized Signature -/e !�%Q/�' Date A.;rir r• - „r= . .. . .: ti See instruction for completing this for on the next tab (Attachment H 2 of 2) aa19-3-3O CLEAR WIOA Reconciliation-PY17 WIOA DW PROGRAM TRANSFER TO ADULT Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance July -17 4DN700000 35,261.00 August -17 4DN700000 35,261.00 September -17 4DN700000 35,261.00 October -17 4DN700000 35,261.00 November -17 4DN700000 35,261.00 December -17 4DN700000 35,261.00 35,261.00 35,261.00 2/1/18 - December -17 "B" 4DN700000 - January -18 4DN700000 - February -18 4DN700000 - March -18 4DN700000 - April -18 4DN700000 - May -18 4DN700000 - June -18 4DN700000 - Totals 35,261.00 35,261.00 35,261.00 4DN700000 General ledger vs billied 0.00 Billed not received ' 0.00 General ledger vs. received 0.00 Account 5230.0000.6500.4DN7000000.0000. 00000000' Funds Available ( Detail Balances ) Period ' Jul -17 Aug -17 Sep 17 Oct -17 Nov -17 Dec -17 Jan -18 Feb -18 Mar -18 Apr 18 Budget 35261.00, 0.00 0.00 0.00'. 0 00 0.00 0.00 0.00! 0.00 0.00 35261.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 Funds Available 0 00 35261.00 0.00 0.00 0 00 0.00 0.00 0.00 0 00 0.00 35261.00! -35261.00 0.00 000' 0.00'. 0.00 0.00 0.00 0.00 0.00 _ 35261.00! 0.00 Cancel COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT GRANT CLOSEOUT RECONCILIATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 EA/WORKPLAN START DATE PROGRAM INCOME START DATE 4/10/2018 YEAR OF FUNDS TITLE/PROGRAM/PROJECT CLEAR Program code Closeout Part 3 Page 1 of 2 FY17 APPRENTICESHIP USA 4FH6000000 END DATE END DATE 4/30/2019 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 3,000.00 2. Current Program and Admin Cash Needs 0.00 3. FINAL Program and Admin Cash Needs Contract to Date 3,000.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 2. Current Expenses + Accruals (Through End Date of Award) 0.00 3. FINAL Program Expenses Contract to Date 0.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 3,000.00 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 3,000.00 III. PROGRAM INCOME(PI) EXPENSE REPORT 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION 1. FINAL Cash Request Contract to Date 3,000.00 2. FINAL Expenses Through End of Contract 3,000.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes E /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 2, Less Program Income Exoenses Through Contract End Date 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 3,000.00 3. Match Percentage of Expenditure Contracttual Requirement 0.00 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes 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 ,QI f 3 /Zoel Authorized Signature K_r1`"z Date See instruction for completing this for on the next tab (Attachment H 2 of 2) 0Oi9.-318'0-31 CLEAR WIOA Reconciliation-FY17 APPRENTICESHIP USA ADMIN Reporting Month 1 Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance October -16 4FH600000 3,000.00 February -18 4FH600000 3,000.00 March -18 4FH600000 3,000.00 April -18 4FH600000 3,000.00 May -18 4FH600000 3,000.00 June -18 4FH600000 3,000.00 July -18 4FH600000 3,000.00 August -18 4FH600000 3,000.00 September -18 4FH600000 3,000.00 October -18 4FH600000 3,000.00 November -18 4FH600000 3,000.00 December -18 4FH600000 1,158.77 1,158.77 1,158.77 2/8/19 1,841.23 December -18 "B" 4FH600000 1,841.23 December -18 "C" 4FH600000 1,841.23 January -19 4FH600000 387.03 387.03 387.03 4/1/19 1,454.20 February -19 4FH600000 1,434.00 1,434.00 1,434.00 4/12/19 20.20 March -19 4FH600000 20.20 20.20 20.20 5/14/19 0.00 April -19 4FH600000 0.00 May -19 4FH600000 0.00 June -19 4FH600000 0.00 Totals 3,000.00 3,000.00 3,000.00 4FH600000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 o p* Account 15230.0000.6500.4FH6000000.0000.00000000( Funds Available ( Detail Balances ) I Period Jun -16 Ad1-16 Jul -16 Aug -16 ,Sep -16 .......... Oct -16 Nov -16 Dec -16 Jan -17 Feb -17 Budget 0.00 0.00 0.00 0.00 0.00 3000.00 0.00 0.00 0.00 0.00 Encumbrance 0.00 000 0.00', 000 0 00 0 00! 000 000'. 0.00 0 00 3001.00! 0.00 j Actual Funds Available 0.00 0.00 0.00: 0.00 0.00 000 0 00 0.00 0 00 0.00 0.00 0.00 0.00 0.00 0.00 3000.00 0.00 0.00 0.00 0.00 _ 3000.00 ! 1.00 Account Period I Mar -17 Apr -17 May -17 Jun -17 Adj-17 Jul -17 Aug -17 'Sep -17 Oct -17 Nov -17 52 30.0000.6500.4 F H6000000.0000.00000000( Funds Available ( Detail Balances ) Budget 0.00 0.00 000', 0.00' 0.00' 0.00' 0.00. 0.00' 0.00' 0.00 3001.00' Encumbrance 0.00' 0.00 0.00, 000 0.00 0.00! 0.00: 0.00! 0.00' 0.00 0 00 Actual Funds Available 0.00 0.00 st 0.00 0.00 0.001 0.00 000_ 0.00 0.00; 000 0.00 0.00 0.00 I 0.00 000; 0.00 0.00 0.00 0.00 _ 0 00 3000 00 Cancel 1.00 ° PeriBalances (PJl't )� Account5230.0000.6500.4FH6000000.0000.00000000( Funds Available ( Detail Balances ) Period ' Dec -17 'Jan -18 Feb -18 Mar -18 Apr -18 ,May -18 Jun -18 Adj-18 Jul -18 Aug -18 Budget Encumbrance 000 000; 0.00 0.00 0 00 0 00I 0.00 0.00 0.00 0.00! 0.00 000; 0.00' 0.00 0.0a 0 00` 0.00 0.00 1 00 0.00 3001 00'. 0.00 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.001 0.00 0 001 0.00 0.00 0.00 0.00 0.00 1.00 0.00; 3000.00 1.00 Cancel Account15230.0000.6500.4FH6000000.0000. 00000000( Period Sep -18 Oct -18 Nov -18 Dec -18 Jan -19 Feb -19 Mar -19 Apr -19 May -19 ' Jun -19 Funds Available ( Detail Balances ) Budget Encumbrance 000 000 0.00 0.00 0001 000' 0.00 0 00 0.001 0 00 0.00 000 0.00 0 00 0 00', 0.00 1. 0.00 0 00! 0.00 0 00 3001.00 0 00 Actual Funds Available 0.00 ; 0.00 000 000 0.00 0.00 1158 77 1158.77 387 03 -387.03 1434 00 -1434.00 20.20 -20.20 0.00 0.00 0 00 0 00 0.00 0.00 3000.001 1 00 Cancel COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part 3 GRANT CLOSEOUT RECONCILIATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 EA/WORKPLAN START DATE PROGRAM INCOME START DATE 10/1/2017 YEAR OF FUNDS Page 1 of 2 FY18 TITLE/PROGRAMfPROJECT DW PROGRAM TRANSFER TO ADULT CLEAR Program code 4ND7000000 END DATE END DATE 6/30/2019 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 187,872.00 2. Current Program and Admin Cash Needs 0.00 3. FINAL Program and Admin Cash Needs Contract to Date 187,872.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 187,872.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 187,872.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 0.00 III. PROGRAM INCOME(PI) EXPENSE REPORT 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION 1. FINAL Cash Request Contract to Date 187,872.00 2. FINAL Expenses Through End of Contract 187,872.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes O /No 0 V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 VI. RECONCILIATION 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 VII. MATCH RECONCILIATION 1. FINAL Match Reported Through End of Contract 0.00 2. FINAL Expenses Through End of Contract 187,872.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 r /13 ZD ) / Date f' Authorized Signature See instruction for completing this for on the next tab (Attachment H 2 of 2) CLEAR WIOA Reconciliation-FY18 WiOA DW PROGRAM TRANSFER TO ADULT Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance October -17 4ND7000000 187,872.00 August -18 4ND7000000 50,636.33 50,636.33 50,636.33 10/3/18 137,235.67 September -18 4ND7000000 62,369.84 62,369.84 62,369.84 10/26/18 74,865.83 October -18 4ND7000000 64,249.13 64,249.13 64,249.13 12/6/18 10,616.70 November -18 4ND7000000 10,616.70 10,616.70 10,616.70 1/17/19 - December -18 4ND7000000 - January -19 4ND7000000 - February -19 4ND7000000 - March -19 4ND7000000 - April -19 4ND7000000 - May -19 4ND7000000 - June -19 4ND7000000 - July -19 4ND7000000 - Totals 187,872.00 187,872.00 187,872.00 4ND7000000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Account Period Oct -17 Nov -17 Dec -17 Jan -18 Feb -18 Mar 18 'Apr -18 y-18 Jun -18 '.Adt-18 5230.0000.6500.4 N D 7 000000.0000.00000000' Funds Available ( Detail Balances ) Budget Encumbrance 187872.00! 0 00 000 0.00': 0.00 0.00 0.00 0.00' 0.00 0.00 000 000 O00. 000 0.00 0 00'. 0 00 ! 0.00 0.00 0.00 187873.00 0.00 !. 0 Petiod ealances(PJ ) Y 0`a. Account ':5230.0000.6500.4 N D 7 000000.0000.00000000! Period Aug -18 Sep -18 Oct -18 Nov -18 Dec -18 Jan -19 Feb -19 Mar -19 Apr -19 Funds Available ( Detail Balances ) Budget Encumbrance 0.00 0.00' 1 00', 0.00 0.00; 0 00'' 0.0a, 0.00 0.00 0.00 000 000' 0.00 0.00 0 00'; 0.00 0 00! 0.00 0 00, 0 00! 187873.00 0.00 Actual Funds Available 0.00 187872 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 0.00 0.00 0.00 0.00 0 00 187872.00: 1.00 Cancel Actual Funds Available 000: 0.00' 50636.33 -50635.33 62369.84 -62369.84 64249.13 -64249.13 10616.70 -10616.70 0.00 0 00 0 00 0.00 0 00 0.00 0.00 0.00 0 00 0.00 v 187872.00: 1.00 Cancel COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part 3 GRANT CLOSEOUT RECONCILIATION WORKSHEET Page 1 of 2 SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 EA/WORKPLAN START DATE PROGRAM INCOME START DATE 4/1/2017 YEAR OF FUNDS FY17 TITLE/PROGRAM/PROJECT 25% DW ENHANCED PR0G TRANSFER TO 25% ADULT WBL CLEAR Program code 4PD6000000 END DATE END DATE 6/30/2019 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 44,000.00 2. Current Program and Admin Cash Needs 0.00 3. FINAL Program and Admin Cash Needs Contract to Date 44,000.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 44,000.00 2. Current Expenses + Accruals (Through End Date of Award) 0.00 3. FINAL Program Expenses Contract to Date 44,000.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 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 44,000.00 2. FINAL Expenses Through End of Contract 44,000.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 2. Less Program Income Exoenses Through Contract End Date 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 44,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 - Date g)/'.1i31 tom Authorized Signature p w Date ",1� _ > See instruction for completing this for on the next tab (Attachment H 2 of 2) 0019 -378'O - 33 CLEAR W1OA Reconciliation-FY17 W/OA 25% DW Enhanced Prog Transfer to Adult WBL Reporting Month I Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance July -18 4PD6000000 44,000.00 August -18 4PD6000000 44,000.00 September -18 4PD6000000 44,000.00 October -18 4PD6000000 44,000.00 November -18 4PD6000000 44,000.00 December -18 4PD6000000 44,000.00 December -18 "B" 4PD6000000 44,000.00 December -18 "C" 4PD6000000 44,000.00 January -19 4PD6000000 44,000.00 February -19 4PD6000000 44,000.00 March -19 4PD6000000 44,000.00 April -19 4PD6000000 44,000.00 May -19 4PD6000000 21,810.93 21,810.93 21,810.93 7/9/19 22,189.07 June -19 4PD6000000 22,189.07 22,189.07 22,189.07 7/24/19 - Totals 44,000.00 44,000.00 44,000.00 4PD6000000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Account 5230.0000.6500.4PD6000000.0000. 00000000! Funds Available ( Detail Balances ) Period I Nov -18 Dec -18 Jan -19 Feb -19 Mar -19 Apr -19 May -19 Jun -19 AAdj-19 Budget Encumbrance 000 000' 0.00 0 00'' 0 00 0.00 0.00 0.00 0.00' 0.00 a 0o- 44000.00; 0.00; 0.00; 000' Jul -19 0.00 44000.00' 000 0.00 0.00' 000 0.00', Actual Funds Available 0 00 o 00 -. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 000 0.00 0.00 21810 931 22189.07 22189.07 ' -22189.07 0.00 ! 0.00 0.00 0.00 44000 00 000 Cancel ..:....................................... . COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part 3 GRANT CLOSEOUT RECONCILIATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 EA/WORKPLAN START DATE PROGRAM INCOME START DATE 7/1/2018 Page 1 of 2 YEAR OF FUNDS PY17 TITLE/PROGRAM/PROJECT TA -LOCAL WORKFORCE DEVELOPMENT BOARDS CLEAR Program code 4WD7000000 END DATE END DATE 3/31/2019 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 7,500.00 2. Current Program and Admin Cash Needs 0.00 3. FINAL Program and Admin Cash Needs Contract to Date 7,500.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 7,500.00 2. Current Expenses + Accruals (Through End Date of Award) 0.00 3. FINAL Program Expenses Contract to Date 7,500,00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date M. 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,500.00 2. FINAL Expenses Through End of Contract 7,500.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes 2 /No 0 V. CASH REQUEST PROGRAM INCOME CASH REPORTED 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 2. Less Program Income Exoenses Through Contract End Date 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 7,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 period. Preparer's Signature 7 12t) 11312r31 I r Authorized Signature (,_ Date 'u. 4 See instruction for completing tvs for on the next tab (Attachment H 2 of 2) O0 (9 - 3 7$d - 3�1 CLEAR W1OA Reconciliation-PY17 TA -Local Workforce Development Boards Reporting Month I Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance July -18 4WD7000000 7,500.00 August -18 4WD7000000 7,500.00 September -18 4WD7000000 7,500.00 October -18 4WD7000000 485.64 485.64 485.64 12/6/18 7,014.36 November -18 4WD7000000 316.42 316.42 316.42 1/11/19 6,697.94 December -18 4WD7000000 576.63 576.63 576.63 2/8/19 6,121.31 December -18 "B" 4WD7000000 5.38 5.38 4/1/19 6,121.31 December -18 "C" 4WD7000000 6,121.31 January -19 4WD7000000 621.90 627.28 621.90 4/1/19 5,494.03 February -19 4WD7000000 (80.33) 5,494.03 March -19 4WD7000000 3,498.68 3,418.35 3,418.35 6/24/19 2,075.68 April -19 4WD7000000 2,075.68 2,075.68 2,075.68 5/28/19 - May -19 4WD7000000 - June -19 4WD7000000 - Totals 7,500.00 7,500.00 7,500.00 4WD7000000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Account ;5230.0000.6500.4WD7000000.0000.0000000( Period IDec-17 Jan -18 Feb -18 €Apr -18 ;May -18 :Jun -18 Adi-18 Jul -18 Aug -18 Funds Available ( Detail Balances ) Budget 0.00; 0.00 0.00' 0.00 0.00 0.00 0.00 0.00', 7500.00 0 00 7500.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.001 0.00i 000 0.00 0.00': 0.00 0.00 000 000 7500.00: Funds Available 0.00 000 0.00 0 00 0.00 0.00 0.00 0.00 7500.00 0.00 0.00 cei Account 15230.0000.6500.4WD7000000.0000.0000000( Period Oct -18 Nov -18 IDec-18 Jan -19 Feb -19 vtar-19 Apr -19 Jun -19 Funds Available ( Detail Balances ) Budget 000 0.00!: a00! co 0.00 0.00!, 0.00 7500.00! Encumbrance 0.00! 0.00 0.00 000 0.00 0.00; 0.00 Actual Funds Available 000 316.42 576.63 627.28 0.00 3418.35' 2075 68 0 00 O00; 0.00 0.00 7500.00; -316.42 -576.63 -627.28 0.40 -2075.68 0.00 0 00 0.00 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part 3 GRANT CLOSEOUT RECONCILIATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 EAIWORKPLAN START DATE PROGRAM INCOME START DATE 7/1/2017 YEAR OF FUNDS TITLE/PROGRAM/PROJECT CLEAR Program code Page 1 of 2 PY17 YOUTH 10% COUNTY ADMIN 4Y67000000 END DATE END DATE 6/30/2019 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 30,055.00 2. Current Program and Admin Cash Needs 0.00 3. FINAL Program and Admin Cash Needs Contract to Date 30,055.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 30,055.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 30,055.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 0.00 III. PROGRAM INCOME(PI) EXPENSE REPORT 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV RECONCILICATION 1. FINAL Cash Request Contract to Date 30,055.00 2. FINAL Expenses Through End of Contract 30,055.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 30,055.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. Preparers Signature Date gi)�)20,1 �,�Y" Authorized Si natur 9 ef' / 1IA. 1 i /�/L� Date _ 'v" 2 LI See instruction for completing this for on the next tab (Attachment H 2 of 2) go vci 31 O -35 CLEAR WIOA Reconciliation-PY17 YOUTH 10% COUNTY ADMIN Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance July -17 4Y67000000 30,055.00 August -17 4Y67000000 30,055.00 September -17 4Y67000000 30,055.00 October -17 4Y67000000 30,055.00 November -17 4Y67000000 30,055.00 December -17 4Y67000000 30,055.00 January -18 4Y67000000 30,055.00 February -18 4Y67000000 998.77 998.77 998.77 5/29/18 29,056.23 March -18 4Y67000000 6,303.89 6,303.89 6,303.89 5/29/18 22,752.34 April -18 4Y67000000 3,395.01 3,395.01 3,395.01 5/29/18 19,357.33 May -18 4Y67000000 3,655.37 3,655.37 3,655.37 7/13/18 15,701.96 June -18 4Y67000000 5,001.62 5,001.62 5,001.62 8/2/18 10,700.34 July -18 4Y67000000 10,700.34 August -18 4Y67000000 2,087.70 2,087.70 2,087.70 10/3/18 8,612.64 September -18 4Y67000000 6,055.68 6,055.68 6,055.68 10/26/18 2,556.96 October -18 4Y67000000 601.34 601.34 601.34 12/6/18 1,955.62 November -18 4Y67000000 1,651.62 1,651.62 1,651.62 1/11/19 304.00 December -18 4Y67000000 304.00 304.00 304.00 2/8/19 0.00 January -19 4Y67000000 0.00 February -19 4Y67000000 0.00 March -19 4Y67000000 0.00 April -19 4Y67000000 0.00 May -19 4Y67000000 0.00 June -19 4Y67000000 0.00 July -19 4Y67000000 0.00 Totals 30,055.00 30,055.00 30,055.00 I 4Y67000000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Account Period I:Jul-17 Aug -17 Sep -17 Oct -177 Nov -17 'Dec -17 Jan -18 Feb -18 Mar -18 Apr -18 5230.0000.6500.4Y67000000 0000.00000000C Funds Available ( Detail Balances ) Budget Encumbrance 29751 00. 0 00 0 00. 0 00 0.00 000 0.00" 000;.__. 0.00 0.00 000; 30056.00 000j 0.00 0 00'; 0 00 0.00 000;.... 0.00 0.00' 0 00 0.00' Actual Funds Available 0.00 29751 00 0.00 0.00 0.00 0 00 0.00 0 00 - 998.77 - 6303 89 - 3395 01 0.00 0.00 0 001 0.00 0.00' 0.00 998 77 6303.89 3395.01 30055.00 Cancel 1.00 Account 5230.0000.6500.4Y67000000 0000.00000000( Period ' May -18 Jun -18 Aug -18 Sep -18 iOct-18 ;Nov -18 ,Dec -18 Jan -19 Funds Available ( Detail Balances ) Budget Encumbrance 0 00 0.00 0.00 0.00 304.00 1.00 000 0 00 0.00, 0 00' 000. 0.00 0 00 0.00 0.00 0.00 0 00 0.00 0 00'. 0.00 Actual Funds Available 3655 37 -3655.37 -` 500162: -500162 0 00 0 00 0.00 2087.70! 6055.68 601.34! 1651 62 304.00! 0.001 304.00 - 2086.70 - 6055 68 - 601.34 -165162 - 304 00 0.00 A' Cancel COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part 3 GRANT CLOSEOUT RECONCILIATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 EA/WORKPLAN START DATE PROGRAM INCOME START DATE 7/1/2017 YEAR OF FUNDS TITLE/PROGRAM/PROJECT CLEAR Program code Page 1 of 2 PY17 YOUTH OUT OF SCHOOL 4Y77000000 END DATE END DATE 6/30/2019 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 426,021.00 2. Current Program and Admin Cash Needs 0.00 3. FINAL Program and Admin Cash Needs Contract to Date 426,021.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 426,021.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 426,021.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 0.00 III. PROGRAM INCOME(PI) EXPENSE REPORT rh'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 426,021.00 2. FINAL Expenses Through End of Contract 426,021.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes 2 /No 0 V CASH REQUEST PROGRAM INCOME CASH REPORTED 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 426,021.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 ❑ '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 bfe.."7 Date ''/3 /2-0I1 1 Authorized Signature tQ/` Date ;e ; J . _ i See instruction for completing this for on the next tab (Attachment H 2 of 2) aol9-37 O -3(0 CLEAR WIOA Reconciliation-PY17 YOUTH OUT OF SCHOOL Reporting Month 1Program Code I Tracking Sheet I CLEAR I CLEAR I Received I Date Received I Grant Balance July -17 4Y77000000 426,021.00 August -17 4Y77000000 426,021.00 September -17 4Y77000000 426,021.00 October -17 4Y77000000 426,021.00 November -17 4Y77000000 21,725.57 21,725.57 21,725.57 12/21/2017 404,295.43 December -17 4Y77000000 41,403.88 33,897.94 7,505.94 41,403.88 2/1/2018 362,891.55 December -17 "B" 4Y77000000 15,859.66 15,859.66 2/27/2018 362,891.55 January -18 4Y77000000 17,261.85 26,640.39 6,481.12 17,261.85 2/27/2018 329,770.04 February -18 4Y77000000 41,240.57 29,605.95 11,634.62 41,240.57 5/29/18 288,529.47 March -18 4Y77000000 47,773.71 36,168.45 11,605.26 47,773.71 5/29/18 240,755.76 April -18 4Y77000000 50,458.33 39,345.09 11,113.24 50,458.33 5/29/18 190,297.43 May -18 4Y77000000 56,062.67 47,461.29 8,601.38 56,062.67 7/13/18 134,234.76 June -18 4Y77000000 29,851.16 25,106.52 4,744.64 29,851.16 8/2/18 104,383.60 July -18 4Y77000000 10,494.21 6,650.79 3,843.42 10,494.21 9/10/18 93,889.39 August -18 4Y77000000 52,272.91 40,885.08 11,387.83 52,272.91 10/3/19 41,616.48 September -18 4Y77000000 35,855.10 27,979.50 7,875.60 35,855.10 10/26/18 5,761.38 October -18 4Y77000000 5,761.38 3,706.38 3,706.38 12/6/18 2,055.00 November -18 4Y77000000 2,055.00 December -18 4Y77000000 2,055.00 2,055.00 2/8/19 (0.00) December -18 "B" 4Y77000000 (0.00) December -18 "C" 4Y77000000 (0.00) January -19 4Y77000000 (0.00) February -19 4Y77000000 (0.00) March -19 4Y77000000 (0.00) April -19 4Y77000000 (0.00) May -19 4Y77000000 (0.00) June -19 4Y77000000 (0.00) July -19 4Y77000000 (0.00) Totals 426,021.00 341,227.95 84,793.05 426,021.00 4Y77000000 General ledger vs billied 0.00 Billed not received 1 0.00 0.00 General ledger vs. received 0.00 Account 15230.0000.6500.4Y77000000.0000.00000000( Funds Available ( Detail Balances ) Period Mar -17 Apr -17 May -17 Jun -17 Adj-17 Jul -17 Aug -17 Sep -17 Oct -17 'Nov -17 Budget 0.00 0.00( 0.00 0.001 0.00 423966 00'. 0.00' 0 00 0.00 0.00' 426021.00', Encumbrance 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 0.00 0.00 0.00,, 000 000 0.00 0.00 423966.00 000 000_ 0.00 000 0.00 000` 000 0.00 21725.57 -21725.57 _ 0.00 341227.95' 84793.05 Cancel 0 Pet's; ices (P tTD) ;;J 19 Account 15230.0000.6500.4Y77000000.0000.00000000( Period I Dec -17 Jan -18 Feb -18 ,Mar -18 Apr -18 ................ May -18 Jun -18 ........_. Adj-18 Jul -18 Aug -18 Funds Available ( Detail Balances ) Budget 0.00 0.00!.. 0.00 0.00 0.00 0.00 0.00; 0.00 2055.00 0.00'' 426021.00' Encumbrance Actual Funds Available 0.00 33897.94 -33897.94 0 00' 26640 39 -26640.39 0.00 29605.95 29605.95 0.00 36168.45 -36168.45 0.00, 39345.09 -39345.09 0 00' 47461.29 -47461.29 0.00 25106 52 -25106 52 0.00 0 00 0 00 0 00' 6650.79' -4595.79 0.00 40885.08 -40885.08 _ 0.00': 341227.95: 84793.05 Cancel 0 Penod Balances (PJTt1) J1 491 Account 5230.0000.6500.4Y77000000.0000.00000000( Funds Available ( Detail Balances ) Period ' Sep -18 Oct -18 Nov -18 Dec -18 Jan -19 Feb -19 Mar -19 Apr -19 May -19 Jun -19 Budget 0.00 0.00 0.00! 0.00; 0.00 000 0.00 000• 0 00 0.00 426021.00! Encumbrance 0.00 0 00 0.00 0 00 0.00 0.00 0 00 0.00 0.00'', 0.00, 000 Actual Funds Available 27979.50 -27979.50 3706.38' -3706.38 0.00 0.00 2055.00 -2055.00 0.00 0.00 000 000 0.00' 0.00 0 00 0.00 0.00 0.00 0 00 000 341227.95; 84793.05 Cancel °t?t B2nce (PJ Account 5230.0000.6500.4Y77000000.0000.00000000( Period Nov -17 ;Dec -17 Jan -18 Feb -18 Mar -18 Apr -18 ft/lay-18 Jun -18 ........_... Adj-18 Jut -1 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.00 0.00 0.00', 0.00 0.00 0.00 0.00 0 00 Actual Funds Available 0.00 000 7505.94 -7505.94 6481.12 -6481.12 11634.62' -11634.62 11605 26, -11605.26 11113 24 -11113.24 8601.38 -8601.38 4744 64 -4744.64 0.00 0.00 3843.42 ! -3843.42 84793 05 -84793.05 Cancel op Account Period ' Aug -18 Sep -18 Oct -18 Nov -18 Dec -18 Jan -19 Feb -19 Mar -19 Apr 19 ............... May -19 5230.0000.6500.4Y77000000.0000.00000000( Funds Available ( Detail Balances ) Budget Encumbrance 0 00 0.00 0.00'. 0 00 0.00 0.00 0.00 0.00 0.00, 000; 0.00 0.00; 000', 0.00 0.00. 0.00 0.00 0.00 0.00 0 00 000'i 0 00 Actual Funds Available 11387.83 -11387.83 7875 60', -7875.60 0.00 0.00 0 00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 000 0.00 0 00 0 00 84793.05';' 0.00 -84793 05 Cancel COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT GRANT CLOSEOUT RECONCILIATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 EA/WORKPLAN START DATE PROGRAM INCOME START DATE 7/1/2018 YEAR OF FUNDS TITLE/PROGRAM/PROJECT CLEAR Program code Closeout Part 3 Page 1 of 2 PY17 YOUTH IN SCHOOL 4Y87000000 END DATE END DATE 6/30/2019 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 142,006.00 2. Current Program and Admin Cash Needs 0.00 3. FINAL Program and Admin Cash Needs Contract to Date 142,006.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 142,006.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 142,006.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 0.00 III. PROGRAM INCOME(PI) EXPENSE REPORT 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION 1. FINAL Cash Request Contract to Date 142,006.00 2. FINAL Expenses Through End of Contract 142,006.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 1. FINAL Match Reported Through End of Contract 0.00 2. FINAL Expenses Through End of Contract 142,006.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 0 '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 Date 7 /1 2 /%Qr Authorized Signature �/�� (�� r r,,. Date ,?,.� t�, �, .r- 2.313 See Instruction for completing this for on the next tab (Attachment H 2 of 2) Qotq-3118'0-31 CLEAR WIOA Reconciliation-PY17 YOUTH IN SCHOOL Reporting Month 1Program Code I Tracking Sheet I CLEAR I CLEAR I Received I Date Received I Grant Balance July -17 4Y87000000 142,006.00 August -17 4Y87000000 142,006.00 September -17 4Y87000000 142,006.00 October -17 4Y87000000 4,445.40 4,445.40 4,445.40 11/27/2017 137,560.60 November -17 4Y87000000 3,993.08 3,993.08 3,993.08 12/21/2017 133,567.52 December -17 4Y87000000 11,181.11 9,788.29 1,392.82 11,181.11 2/1/2018 122,386.41 December -17 "B" 4Y87000000 2,707.91 122,386.41 January -18 4Y87000000 5,486.21 5,325.79 2,868.33 8,194.12 2/27/2018 114,192.29 February -18 4Y87000000 9,470.22 6,762.26 2,707.96 9,470.22 5/29/18 104,722.07 March -18 4Y87000000 8,583.78 7,409.02 1,174.76 8,583.78 5/29/18 96,138.29 April -18 4Y87000000 7,448.28 6,160.67 1,287.61 7,448.28 5/29/18 88,690.01 May -18 4Y87000000 7,918.83 6,425.51 1,493.32 7,918.83 7/13/18 80,771.18 June -18 4Y87000000 12,386.13 7,339.38 5,046.75 12,386.13 8/2/18 68,385.05 July -18 4Y87000000 5,559.64 1,774.63 3,785.01 5,559.64 9/10/18 62,825.41 August -18 4Y87000000 8,643.25 2,911.65 5,731.60 8,643.25 10/3/18 54,182.16 September -18 4Y87000000 5,685.35 3,505.44 2,179.91 5,685.35 10/26/18 48,496.81 October -18 4Y87000000 5,374.80 4,778.52 596.28 5,374.80 12/6/18 43,122.01 November -18 4Y87000000 4,537.48 4,537.48 4,537.48 1/11/19 38,584.53 December -18 4Y87000000 6,232.82 6,232.82 6,232.82 2/8/19 32,351.71 December -18 "B" 4Y87000000 2,828.08 2,828.08 4/1/19 32,351.71 December -18 "C" 4Y87000000 147.05 32,351.71 January -19 4Y87000000 6,174.77 8,946.26 6,118.18 4/1/19 23,405.45 February -19 4Y87000000 10,289.93 10,493.57 10,493.57 4/12/19 12,911.88 March -19 4Y87000000 8,598.47 8,598.47 8,598.47 5/14/19 4,313.41 April -19 4Y87000000 4,313.41 4,313.41 4,313.41 5/28/19 (0.00) May -19 4Y87000000 (0.00) June -19 4Y87000000 (0.00) July -19 4Y87000000 (0.00) Totals 142,006.00 113,741.65 28,264.35 142,006.00 4Y87000000 General ledger vs bullied 0.00 Billed not received I 0.00 0.00 General ledger vs. received 0.00 Account 5230.0000.6500.4Y87000000.0000.00000000( Funds Available ( Detail Balances ) Period Mar -17 Apr -17 May -17 Jun -17 Adj-17 Jul -17 Aug -17 Sep -17 Oct -17 ' Nov -17 Budget 0.00 0.00' 0.00 0.00 0.00 Encumbrance 0.00 000 0 00 0.00 0 00::.. 141321.00', 0.001 0.00' 0,001 0 00', 0 00, 0.00 ! 0 00 0.00 0 00' 142007.00 ! 0.00 Actual Funds Available 0.00 0.00 -. 0.00 0.00 0 00 0.00 0.00 0.00 00a 000 000 141321.00 000 0.00 0 00 0.00 4445 40 -4445.40 3993.08 -3993.08 . 113741.65, 28265.35 Cancel aped cesWAD) -J 19 Account 5230.0000.6500.4Y87000000.0000.00000000C Period I Dec -17 Jan -18 Feb -18 Mar -18 Apr -18 May -18 Jun -18 Adl-18 Jul -18 Aug -18 Funds Available ( Detail Balances ) Budget 0.00'. 0.00 0.00 0.00 0.00 0.00. 0.00 000 685.00 1.00 Encumbrance 0.00 0 00', 0 00 0 00 0.00!. 0.00S 0.00 • 0.00; 0.00 0 00 142007.00 0.00 Actual Funds Available 9788.29 -9788.29 -1'- 5325.79 5325.79 6762.26 -6762.26 7409 02', -7409.02 6160.67 -6160.67 6425 51 i -6425.51 7339.38 -7339.38 00a 000 1774.63 -1089.63 2911.65 ! -2910.65 . 113741.65' 28265.35 Cancel es (PAD) Account 5230.0000.6500.4Y87000000.0000.00000000( Period Sep -18 Oct -18 Nov -18 Dec -18 Jan -19 Feb -19 Mar -19 Apr -19 May -19 .............. Jun -19 Funds Available ( Detail Balances ) Budget Encumbrance 0.00; 0.00 000! 000'' 0.00 0.00 0.00 0 00' 0.00 0 00' 0 00 0.00 0.00 0.00 0.00 I 0.00 0.00' 0.00 0.00, 0.00, 142007.00. Actual Funds Available 3505.44 -3505.44 "- 4778.52 -4778.52 4537.48 -4537.48 6232.82 -6232 82 8946.26 -8946.26 10493.57 -10493.57 8598.47 -8598.47 4313.41 -4313.41 0.00 0.00 0.00; 0.00 0.00', 113741.65 28265.35 Cancel Account 5230.0000.6500.4Y87000000.0000.00000000( Period ' Dec -17 Jan -18 Feb -18 Mar -18 Apr -18 May -18 .._........ Jun -18 Adj-18 Jul 18 Aug -18 Funds Available ( Detail Balances ) Budget Encumbrance 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 0.00 0 00 ! 0.00 0.00 0.00 Actual Funds Available 1392 82' 1392 82 2868.33; -2868 33 2707.96 -2707 96 1174.76' -1174.76 1287.61 -1287.61 1493.32 -1493.32 5046 75 -5046 75 0.00: 3785 01 5731 60 28264.35! 0.00 -3785.01 -5731.60 -28264 35 Cancel Paned Balances (PJTO) tun -49. Account Period Sep -18 Oct -18 Nov -18 Dec -18 Jan -19 Feb -19 Mar 19 Apr 19 May -19 ' Jun -19 5230.0000.6500.4Y87000000.0000.00000000( Funds Available ( Detail Balances ) Budget Encumbrance 0.00 0.00 000', 000 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 0.00` Actual Funds Available 2179.91 -2179.91 596 28' -596.28 0.00 0.00 0.00 0 00 0.00 0.00 0.00 0.00! 0 00' 0 00! 000; 28264.35 0.00 0.00 0.00 0.00 0.00 -28264.35 Cancel COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Closeout Part 3 GRANT CLOSEOUT RECONCILIATION WORKSHEET Page 1 of 2 SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 EA/WORKPLAN START DATE PROGRAM INCOME START DATE 1/2/2018 YEAR OF FUNDS PY16 TITLE/PROGRAM/PROJECT PERFORMANCE INCENTIVE FUND CLEAR Program code 4YW6000000 END DATE END DATE 9/30/2018 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 48,265.00 2. Current Program and Admin Cash Needs 0.00 3. FINAL Program and Admin Cash Needs Contract to Date 48,265.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 48,265.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 48,265.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 0.00 III. PROGRAM INCOME(PI) EXPENSE REPORT 1, Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION 1. FINAL Cash Request Contract to Date 48,265.00 2. FINAL Expenses Through End of Contract 48,265.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 48,265.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 / Date /f7/),..3 12 121-.) 19 Authorized Signature . Date ? 7 See instruction for completing this for on the next tab (Attachment hl 2 of 2) aoiq-3-780 -3S" CLEAR WIOA Reconciliation-PY16 WIOA Performance Incentive Fund Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance January -18 4YW6000000 48,265.00 February -18 4YW6000000 48,265.00 March -18 4YW6000000 1,933.30 1,933.30 7/13/18 48,265.00 April -18 4YW6000000 48,265.00 May -18 4YW6000000 1,007.34 2,940.64 1,007.34 7/13/18 45,324.36 June -18 4YW6000000 45,324.36 July -18 4YW6000000 7,339.58 7,339.58 1,268.13 9/10/18 37,984.78 July -18 4YW6000000 6,071.45 9/14/18 37,984.78 August -18 4YW6000000 23,217.62 23,217.62 23,217.62 10/3/18 14,767.16 September -18 4YW6000000 14,767.16 14,767.16 14,767.16 10/26/18 - October -18 4YW6000000 - November -18 4YW6000000 - December -18 4YW6000000 - January -19 4YW6000000 - February -19 4YW6000000 - March -19 4YW6000000 - April -19 4YW6000000 - May -19 4YW6000000 - June -19 4YW6000000 July -19 4YW6000000 - Totals 48,265.00 48,265.00 48,265.00 4YW6000000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 �4 nT:Cii ( ) Account 5230.0000.6500.4YW6000000.0000.0000000C Period Dec -17 Jan -18 Feb -18 Mar -18 Apr -18 May -18 Jun -18 Adj-18 Jul -18 Funds Available ( Detail Balances ) Budget Encumbrance 0.00 0.00 48265.00 000 0 00 0.00 000 000 0 00 0 00 0.00 0.00 0 00 0 00' a 00 0.00 000; 000' 1 00I 0.00 48265.00 0.00 Actual Funds Available 0.00 0.00 0 00 48265.00 0 00 0.00 0.00 0 00 0 0,, 000 2940.64 294O64 0.00 0.00 0 00 0.00 7339.58', -7339.58 23217 62 -23216.62 48265.00 0.00 Cancel es (PJTD) J Account 5230.0000.6500.4YW6000000.0000.0000000C Period Oct -18 Nov -18 Dec -18 .Jan -19 Feb -19 Mar -19 Apr -19 May -19 Jun -19 Funds Available ( Detail Balances ) Budget 0.00 0.00 0.00' -1.00' 0.00 0.00 0.00. 0.00' 0.00 0.00 48265.00 Encumbrance O00 0.00 0 00 0 00 0.00 0.00 0.00 0.00' 0.001 0 00' 0.00 Actual Funds Available 14767.16 -14767 16 L"-:- 0 00 0.00 0.00 000 fl 00 000!. 0.00 0.00 0 00 0 00 48265 00 0.00 -1.00 0.00 0.00 0.00 0.00 0.00 0.00 Cancel 0.00 Cheryl Hoffman From: Sent: To: Cc: Subject: Fine with me Thanks Sent from my iPhone Barbara Kirkmeyer Wednesday, August 28, 2019 5:16 AM Esther Gesick HS Contract Management; Tobi Cullins; Cheryl Hoffman; Chloe Rempel Re: Update Revision Needed on Closeout Packets 6-30-2019 > On Aug 27, 2019, at 4:33 PM, Esther Gesick <egesick@weldgov.com> wrote: > Hello Barb, > Are you ok with us just stamping your signature on the attached 2019 Tax Certification page so we can swap it out and keep DHS moving with this closeout submittal? All of the content was presented to the Board on August 21st (see page 14/121 in the .pdf attachment), and this one was just missing the signature block. > Either way, just let me know. > Thanks! > Esther E. Gesick > Clerk to the Board > 1150 O StreetjP.O. Box 758IGreeley, CO 80632 > tel: (970) 400-4226 > [cid:image002.png@01 D41 F6A.E0951 C90] > Confidentiality Notice: This electronic transmission and any attached documents or other writings are intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. If you have received this communication in error, please immediately notify sender by return e-mail and destroy the communication. Any disclosure, copying, distribution or the taking of any action concerning the contents of this communication or any attachments by anyone other than the named recipient is strictly prohibited. > From: Tobi Cullins <cullinta@weldgov.com> > Sent: Tuesday, August 27, 2019 3:16 PM > To: Esther Gesick <egesick@weldgov.com> > Cc: HS Contract Management <HS-ContractManagement@co.weld.co.us> > Subject: FW: Update Revision Needed on Closeout Packets 6-30-2019 > Hello Esther, > Can you please advise me how best to handle this? Commissioner Kirkmeyer just signed the large WiOA Grant Closeout. Fiscal received notification that CDLE left a signature line off of one of the pages and that page now needs to be signed (attached). > Does this need to go through on a separate PA or is there a better way of addressing this and obtaining signature? > Thank you. 1 > > Regards, > Tobi A. Cullins > Contract Management and Compliance Coordinator Administration Support > Unit (ASU) Contract Management Team: 970-400-6556 > Direct: 970-400-6392 > Fax: 970-353-5215 > cullinta@weldgov.com<mailto:cullinta@weldgov.com> > > > Confidentiality Notice: This electronic transmission and any attached documents or other writings are intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. If you have received this communication in error, please immediately notify sender by return e-mail and destroy the communication. Any disclosure, copying, distribution or the taking of any action concerning the contents of this communication or any attachments by anyone other than the named recipient is strictly prohibited. > > [WC Logo Color.jpg]Vision: > The people of Weld County are connected to the resources needed to thrive in the community and feel safe and empowered. > > Mission: > Engaging and partnering with the community to improve the safety, health and well-being of individuals and families through the delivery of responsive and collaborative services. > > > > From: Jason Latta <lattaxjm@weldgov.com<mailto:lattaxjm@weldgov.com>> > Sent: Monday, August 26, 2019 4:04 PM > To: Tobi Cullins <cullinta@weldgov.com<mailto:cullinta@weldgov.com» > Subject: FW: Update Revision Needed on Closeout Packets 6-30-2019 > > Hiya Tobi, > > We just received a communication from CDLE regarding a revision on the closeout we just did. It looks like CDLE missed putting a signature line on one of their 100 pages. How hard will it be to get a commissioner's signature on the revised page? > > Jason Latta > Associate Fiscal Manager > Weld County Department of Human Services > 970-400-6662 > > From: Judy Zabka <zabkaxrj@weldgov.com<mailto:zabkaxrj@weldgov.com» > Sent: Monday, August 26, 2019 3:48 PM > To: Jason Latta <lattaxjm@weldgov.com<mailto:lattaxjm@weldgov.com» > Subject: FW: Update Revision Needed on Closeout Packets 6-30-2019 > > > > Judy Zabka > Accounting Clerk V > Fiscal Office > 970-400-6532 > > [cid:image001.jpg@01CCD1D5.555D9F60] 2 > Confidentiality Notice: This electronic transmission and any attached documents or other writings are intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. If you have received this communication in error, please immediately notify sender by return e-mail and destroy the communication. Any disclosure, copying, distribution or the taking of any action concerning the contents of this communication or any attachments by anyone other than the named recipient is strictly prohibited. > From: Chavez - CDLE, Paul > <pauld.chavez@state.co.us<mailto:pauld.chavez@state.co.us>> > Sent: Monday, August 26, 2019 12:24 PM > To: evelynford@elpasoco.com<mailto:evelynford@elpasoco.com>; > kclark@jeffco.us<mailto:kclark@jeffco.us>; > Kimberly.Manzanares@mesacounty.us<mailto: Kimberly. Manzanares@mesacount > y.us>; Judy Zabka <zabkaxrj@weldgov.com<mailto:zabkaxrj@weldgov.com>>; > Barron, Maryel > <mbarron@bouldercounty.org<mailto:mbarron@bouldercounty.org>>; > Christina Caya > <ccaya@co.jefferson.co.us<mailto:ccaya@co.jefferson.co.us>>; Gabriele > Zobel <GZobel@adcogov.org<mailto:GZobel@adcogov.org>>; Gena Sagen > <gsagen@co.jefferson.co.us<mailto:gsagen@co.jefferson.co.us>>; > Harkiso, Fanta F. - OED Sr Accountant > <Fanta.Harkiso@denvergov.org<mailto:Fanta.Harkiso@denvergov.org>>; > Kelly Mcbride > <kelly.mcbride@mesacounty.us<mailto:kelly.mcbride@mesacounty.us>>; > Kurtis Adams <KAdams@adcogov.org<mailto:KAdams@adcogov.org»; > laddie.somorin@denvergov.org<mailto: laddie.somorin@denvergov.org>; > Laurie Jervay > <LaurieJervay@elpasoco.com<mailto:LaurieJervay@elpasoco.com>>; Liz > Torres <LTorres@arapahoegov.com<mailto:LTorres@arapahoegov.com>>; > Mason, Donelda > <dmason@bouldercounty.org<mailto:dmason@bouldercounty.org>>; Michelle > Chavez <MChavez2@arapahoegov.com<mailto:MChavez2@arapahoegov.com>>; > Wendy Horst > <horstws@co.larimer.co.us<mailto:horstws@co.larimer.co.us>>; Wiggins, > Natalia > <nwiggins@bouldercounty.org<mailto:nwiggins@bouldercounty.org>>; Sung > Hong - CDLE <sung.hong@state.co.us<mailto:sung.hong@state.co.us>>; > Tammy Nelson - CDLE > <tmmy.nelson@state.co.us<mailto:tammy.nelson@state.co.us»; Paul > Chavez - CDLE > <pauld.chavez@state.co.us<mailto:pauld.chavez@state.co.us»; Wayne Hua > - CDLE <wayneq.hua@state.co.us<mailto:wayneq.hua@state.co.us>>; Bryce > Green - CDLE <bryce.green@state.co.us<mailto:bryce.green@state.co.us» > Subject: Update Revision Needed on Closeout Packets 6-30-2019 > Caution: This email originated from outside of Weld County Government. Do not click links or open attachments unless you recognize the sender and know the content is safe. > Hi County Folks, > We have a revision for one of the close out packet forms (excel tab "Tax Certification" form). The signature line is missing on the new form. If you haven't already had it signed and submitted, please have it signed and submitted to our office as soon as possible. > We will correct the form for next year. 3 > I apologize for any inconvenience we may have caused. > Thank you, > Paul Chavez > [image.png] > -- > [image.png] > Paul Chavez > Accountant II > County WFD Finance > [https://Ih5.googleusercontent.com/Fs3elxEzeu-GDdr45ZzWZYHvpYQbP5xYdf9 > t5UgkEuBeOaQc0mNOQjnEiSgirCuJaZTOZjWZUiWFMOCtImZ99l1 wb8o161 e0gQIFwVzPw > zBgH0lkmbmYOomAuMAaGgAZ45RfDcby]<https://urldefense.proofpoint. com/v2/ > url?u=http-3A_www.colorado.gov_cdle&d=DwMFaQ&c=A8J9jb3_ClsSlatombgkDA > &r=x80sIr2y0zIjOVZbYVWGc-w4IXGR6t3nDHild9JV9Gg&m=MZBBOvYT5Wg5A_gO03nZk > k-cYPugQewPegzMRs-5k_4&s=fgA5IH7FpperjFTFNpVYdBwfWEaMLBGKfhZJhBNyi-g&e => > We Keep Colorado Working. > P 303.318.8102 1 > 633 17th St., Suite 1100, Denver, CO > 80202<https://urldefense.proofpoint.com/v2/url?u=https-3A_maps.google > .com_-3Fq-3D633-2B17th-2BSt.-2C-2BSuite-2B1100-2C-2BDenver-2C-2BCO-2B8 > 0202-26entry-3Dgmail-26source-3Dg&d=DwMFaQ&c=A8J9jb3_ClsSl atombgkDA&r= > x80sIr2y0zIjOVZbYVWGc-w4IXGR6t3nDHild9JV9Gg&m=MZBBOvYT5Wg5A_gO03nZkk-c > YPugQewPegzMRs-5k_4&s=DLJB5eWU9YOs2thK6nPgaNZ9EAQgTJmAwqa-PkyI6O8&e=> > pauld.chavez@state.co.us<mailto:sung.hong@state.co.us> > www.colorado.gov/cdle<https://urldefense.proofpoint.com/v2/url?u=http- > 3A_www.colorado.gov_cdle&d=DwMFaQ&c=A8J9jb3_ClsSlatombgkDA&r=x80slr2y > 0zIjOVZbYVWGc-w4IXGR6t3nDHild9JV9Gg&m=MZBBOvYT5Wg5A_gO03nZkk-cYPugQewP > egzMRs-5k_4&s=fgA5IH7Fpperj FTFNpVYdBwfWEaMLBGKfhZJhBNyi-g&e=> > > > <image.png> > <image.png> > <image001.jpg> > <2019 Tax Certification.xlsx> > <image002.png> > <20193780 - WIOA Closeout Summary Report.pdf> <image003.png> > <image005.png> Entity Information. Entity Name* Entity ID* COLORADO DEPARTMENT OF LABOR @00010497 & EMPLOYMENT Contract Name* WORKFORCE INNOVATION AND OPPORUTNITY ACT {WIOAI GRANT CLOSEOUT Contract Status DONE ❑ New Entity? Contract ID 3087 Contract Lead* CULLINTA Contract Lead Email cullinta@co weld co us Parent Contract ID Requires Board Approval YES Department Project # Contract Description* THE WIOA GRANT CLOSEOUT PACKET IS REQUIRED BY THE YEAR-END CONTRACT CLOSEOUT PROCEDURES OF CDLE AND IN ACCORDANCE WITH PGL06-12-F1 FOR ALL PROGRAMS THAT HAVE EXPENDITURE AUTHORIZATIONS ENDING DURING THE PERIOD JULY 1, 2017 TO JUNE 30, 2018. Contract Description 2 Contract Type* AGREEMENT Amount k $O00 Renewable* NO Automatic Renewal Grant IGA Department Requested BOCC Agenda HUMAN SERVICES Department Email CM- HurnanServices@weidgov corn Department Head Email CM-HumanServices- Dep#Head c@weldgo•;.cor County Attorney GENERAL COUNTY ATTORNEY EMAIL County Attorney Email CM- COUNTYA I I ORNEY@:AELD GOV.COM Date* 08/21/2019 Due Date 08/17/2019 Will a work session with BOCC be required?* NO Does Contract require Purchasing Dept. to be included? If this is a renewal enter previous Contract ID If this is part of a MSA enter MSA Contract ID Note: the Previous Contract Number and Master Services Agreement Number should be left blank if those contracts are not in OnBase Contract Dates Effective Date Review Date* Renewal Date 06114/'2020 Termination Notice Period Committed Delivery Date Expiration Date 08/14/2020 Contact Information Contact Info Contact Name Contact Type Contact Email Contact Phone 1 Contact Phone 2 Purchasing Purchasing Approver Approval Process Department Head JUDY GRIEGO OH Approved Date 08/15/2019 Final Approva BOCC Approved YES BOCC Signed Date OB/21?2019 BOCC Agenda Date 08/21 / 2019 Originator CULLINTA Finance Approver BARB CONNOLLY Purchasing Approved Date Finance Approved Date 08/19/2019 Tyler Ref # 2019-3780 Legal Counsel KARIN MCDOUGAL Legal Counsel Approved Date 08/19/2019 Submit Hello