The URL can be used to link to this page

Browse Search

Home My WebLink About20182890.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 for Various Workforce Innovation and Opportunity Act (WIOA) Programs between the County of Weld, State of Colorado, by and through the Board of County Commissioners of Weld County, on behalf of the Department of Human Services, Employment Services of Weld County, and the Colorado Department of Labor and Employment, for all programs that have Expenditure Authorizations ending during the period of July 1, 2017, through June 30, 2018, with further terms and conditions being as stated in said grant closeout, and WHEREAS, after review, the Board deems it advisable to approve said grant closeout, a copy of which is attached hereto and incorporated herein by reference. NOW, THEREFORE, BE IT RESOLVED by the Board of County Commissioners of Weld County, Colorado, that the Grant Closeout for Various Workforce Innovation and Opportunity Act (WIOA) Programs between the County of Weld, State of Colorado, by and through the Board of County Commissioners of Weld County, on behalf of the Department of Human Services, Employment Services of Weld County, and the Colorado Department of Labor and Employment, be, and hereby is, approved. BE IT FURTHER RESOLVED by the Board that the Chair be, and hereby is, authorized to sign said grant closeout. cc•. HSO. GkCTC(3C) 2018-2890 10- ll-1,$ HR0089 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 12th day of September. A.D.. 2018. BOARD OF COUNTY COMMISSIONERS WELD COUNTY, COLORADO ATTEST: WS ji144 e4 Weld County Clerk to the Board BY puty Clerk to the Board APPROVED AS TQFORM: � G ttorney Date of signature: td /41( Stev Moreno, Chair Barbara Kirkme ike Freeman Sean P. Cpnway dee 11e A. Cozad 2018-2890 HR0089 • PRIVILEGED AND CONFIDENTIAL MEMORANDUM DATE: September 4, 2018 TO: Board of County Commissioners Pass -Around FR: Judy A. Griego, Director, Human Services RE: 2017-18 Workforce Innovation and Opportunity Act (WIOA) Grant Closeout for the Colorado Department of Labor and Employment (CDLE) 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' 2017-18 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, 2017 through June 30, 2018. 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. I do not recommend a Work Session. I recommend approval of this Grant Closeout. Sean P. Conway Julie A. Cozad Mike Freeman Barbara Kirkmeyer, Pro -Tern Steve Moreno, Chair Approve Schedule Recommendation Work Session Other/Comments: 2018-2890 +� Q89 Pass -Around Memorandum; September 4, 2018 — CMS 2072 Page I COLO Department of Labor and Employment Finance 633 171h 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 2018 (Aug 24/ 2018) CLOSEOUT SUMMARY CHECK LIST: Please list all the funds with the period of performance ends in June 30th, 2018 (please do the attachment if applicable): Program Year CLEAR Program Code / Vax # CLEAR Program Code Title/Grant Amount FFY16 17C6 NON-WIOA-TAA CASE MANAGEMENT 5,400.00 PY15 2055 WAGNER PEYSER 531,185.00 FFY17 20D7 DISABLED VETS OUTREACH PROG 7,000.00 FY15 2886 UI-RESEA Expenditures -Mary Ball grant 55,100.00 FY17 2887 UI-RESEA-Mary Ball grant -92887 4,650.00 PY16 2M56 10% MIGRANT SSNL WRKR 18,166.00 PY16 2S56 WP10% SUMMER JOB HUNT 40,000.00 SFY18 2W28 WFD ESF ONLY -NO CRWC 382,635.00 FY17 46A6 WIOA ADULT LOCAL ADMIN 33,453.00 FY17 46D6 WIOA DW-DW LOCAL/COUNTIES ADMIN 24,759.00 FY17 47D6 WIOA 25% DW ENHANCED ADMIN LOCAL/COUNTIES 9,692.00 FY17 48A6 WIOA ADULT LOCAL PROGRAM 301,080.00 FY17 48D6 WIOA DW LOCAL/COUNTIES PROGRAM 222,839.00 PY16 4A66 WIOA ADULT LOCAL ADMIN 4,881.00 PY16 4A86 WIOA ADULT LOCAL PROGRAM 43,934.00 FY17 4BD6 WIOA DW-LOCAL/COUNTIES ADMIN TRANSFER ADULT 15,000.00 PY16 4D66 WIOA DW LOCAL ADMIN 7,462.00 PY16 4D86 WIOA DW LOCAL PROGRAM 67,159.00 PY16 4DW6 WIA CWDC 10% DW COUNCIL 15,750.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.Hong@state.co.us), Paul Chavez (phone: 303-318-8102 or email: PaulD.Chavez@state.co.us), Bryce Green (phone: 303-318-8119 or email:Bryce.Green@state.co.us) COLORADO Department of Labor and Employment Finance 633 17th Street, Suite 1100 Denver, CO 80202-3660 FY16 4ED5 WIOA 25% DW ENHANCED ADMIN TO LOCAL 5,122.00 FY16 4FD5 WIOA -25% DW ENHANCED PROGRAM TO LOCAL 74,841.00 FY15 4GD5 WIOA-5%-$165,000 WFD Tech Assist Locals 22,000.00 FY16 4ID5 WIOA 25% DW-WIOA TRANISITIONAL ACTIVITIES 5,109.00 PY14 4MT5 WIOA Technical Assist Training-TMT ADVANCE 8,000.00 FY17 4ND6 WIOA DW-LOCAL/COUNTIES PROG TRANSFER ADULT 135,000.00 FY16 4RA5 WIOA WFD 5% -ADULT EVALU a CONTIN IMPR 20,000.00 PY15 4535 WFD-SPNEG-GRANT PLANNING 80,257.00 PY15 4S45 WFD-SPNEG-LOCAL ADMIN 57,346.00 PY15 4S55 WFD-SPNEG-LOCAL PROGRAM 723,160.00 PY16 4Y66 WIOA 10% YOUTH LOCAL ADMIN 30,956.00 PY16 4Y76 WIOA YOUTH -75% -OUT -SCHOOL LOCAL PROGRAM 448,607.00 PY16 4Y86 WIOA YOUTH MAX -25% -IN -SCHOOL LOCAL PROGRAM 30,000.00 Total 3,430,543.00 Each Program Year (PY) and funding stream listed above will have the following forms completed: Form Attachment are E, F, H, I, and CLEAR Fund Available Analysis Report: • Attachment E - Program Income Expense Report Form • Attachment F - Stand -In Cost Repost Form • Attachment H - Grant Closeout Reconciliation Worksheet • Attachment I - Closeout Document Package • Funds Available Analysis Report (Parameter: Project to Date as of June 2018) 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: 3 2017-PGL-Attachment-E-F-H-I.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 subrecipient's decision. Please submit the Grant Closeout Check List and Subrecipient Certification of Physical Inventory (the first page of Attachment I) with Authorized Signature to Colorado Department of Labor and Employment by the 4th Friday of month of August. Please submit the electronic copy via email to pauld.chavez@state.co.us. If you have any questions or need assistance, please do not hesitate to contact: Sung Hong (phone: 303-318-8108 or e-mail: SunQ.Hong@state.co.us), Paul Chavez (phone: 303-318-8102 or email: Pau1D.Chavez®state.co.us), Bryce Green (phone: 303-318-8119 or email:Bryce.Green@state.co.us) 1COLORADO II Department of I Labor and Employment Finance 633 17th Street, Suite 1100 Denver, CO 80202-3660 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: Title: SEP 12 2018 Steve Moreno, Chair Date Chair, Board of Weld County Commissioners If you have any questions or need assistance, please do not hesitate to contact: Sung Hong (phone: 303-318-8108 or e-mail: Sung.Hong@state.co.us), Paul Chavez (phone: 303-318-8102 or email: PaulD.Chavez@state.co.us), Bryce Green (phone: 303-318-8119 or email:Bryce.Green@state.co.us) COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT EMPLOYMENT AND TRAINING PROGRAMS PROGRAM INCOME EXPENSE REPORT FORM (PIERF) SUBRECIPIENT: Employment Services of Weld County Calendar Qrtr End Date: June 30, 2018 1. CUMULATIVE PROGRAM INCOME CASH REPORTED ON CASH REQUEST THRU QUARTER END DATE: CLEAR Program code Amount NET (Undisbursed) LINE ITEM None 2. BUDGET ALLOCATION: Total CLEAR Program code Program Income 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 certify to the best of my knowledge and belief the above reported information is accurate and complete for the period reported. SEP 12 2018 Authorized Signature Date See instructions for completing this form on the next tab (Attachment E 2 of 2) Attachment E Page 1 of 2 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT EMPLOYMENT AND TRAINING PROGRAMS PROGRAM INCOME EXPENSE REPORT FORM (PIERF) Attachment E 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 program income was reported 2. Program Income Allocation- Cost Category (ies)/Budget Line Item (s): Enter the cost categories/budget line items that the amount reported on the Program Income Line Item will be allocated. Program Income Allocation - Income Amount: Enter the Income Budgeted amount for the expnditure of each cost category (ies)/budget line item (s) for the reporting quarter Program Income Allocation - Disbursed Income Expense: Enter the amount expended against the cost category (ies)/budget line item (s) through the reported calendar quarter end date. Total Net Program Income: Total progam Income amount and Income Disbursed/Expense columns. The Total Net Program Income is program income earned but not expended The Amounts should equal the amount recorded in the Cash Request Line Item Amount. Authorised Signature and Date: Optional signature for subrecipient's reference. COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT EMPLOYMENT AND TRAINING PROGRAMS STAND-IN COST REPORT FORM (SICRF) SUBRECIPIENT: Employment Services of Weld County Incurred During Program Year Ended: June 30, 2018 CLEAR Program code: CMS #54599 Attachment F Page 1 of 3 GRANTS Program Year of Funds COST CATEGORY(IES)/BUDGET LINE ITEM(S) Administration Program Other: Other: Total GRANT NAME WIA Adult Current Prior Year Before Prior PY17 $0.00 $0.00 $0.00 PY16 $0.00 $0.00 $0.00 PY15 $1,145.00 $18,027.00 $19,172.00 GRANT NAME WIA Dislocated Workers Current Prior Year Before Prior PY17 $0.00 $0.00 $0.00 PY16 $0.00 $0.00 $0.00 PY15 $2,837.00 $16,022.00 $18,859.00 GRANT NAME WIA Youth Current Prior Year Before Prior PY17 $0.00 $0.00 $0.00 PY16 $0.00 $0.00 $0.00 PY15 $1,298.00 $22,707.00 $24,005.00 GRANT NAME WIA 10% Statewide Actv. Current Prior Year Before Prior PY17 $0.00 PY16 r $0.00 PY15 $0.00 GRANT NAME WIA Local Admin. Current Prior Year Before Prior PY17 $0.00 PY16 l� �" $0.00 PY15 f�� `i�1 �<'a! $0.00 GRANT NAME WIA 25% Enh. DWAdmin Current Prior Year Before Prior PY17 W ri' 4 $0.00 PY16 .. P it $0.00 PY15k $0.00 GRANT NAME WIA 25% Enh. DW Program Current Prior Year Before Prior PY17 $0.00 PY16 $0.00 PY15 , " $0.00 GRANT NAME WIA 25% Innovaty. PrJ. Current Prior Year Before Prior PY17 $0.00 PY16 0.00 PY16 t�' $0.00 CERTIFICATION: I certify to the best of my knowledge and belief the above reported information is accurate and complete for the period reported SEP 122018 Date 3 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT EMPLOYMENT AND TRAINING PROGRAMS STAND-IN COST REPORT FORM (SICRF) SUBRECIPIENT: Attachment F Page 2 of 3 Incurred During Program Year Ended: CLEAR Program code: GRANTS Program Year of Funds COST CATEGORY(IES)/BUDGET LINE ITEM(S) Administration Program Other: Other: Total GRANT NAME WIA NEG Grant Current Prior Year Before Prior PY17 $0.00 PY16 $0.00 PY15 $0.00 GRANT NAME WIA Wagner Peyser Current Prior Year Before Prior PY17 ,, „ ;: $0.00 PY16 i-,`a , .,'' $0.00 PY15 kr , , `' $0.00 GRANT NAME WP 10% SJH Current Prior Year Before Prior PY17 $0.00 PY16 � a � � , „b, $0.00 PY15 ; �„ _ $0.00 GRANT NAME Vets DVOP Current Prior Year Before Prior PY17 n -o %l $0.00 PY16 � `° $0.00 PY15 ° . $0.00 GRANT NAME Vets LVER Current Prior Year Before Prior PY17 $0.00 PY16 o' $0.00 PY15 Li ;z _, r x .r r , ,f,,,,,f _ $0.00 GRANT NAME UI Reemployement Svc Current Prior Year Before Prior PY17t�r� rs� $0.00 PY16 �� " $0.00 PY15 �ti ��,_ „�, $0.00 GRANT NAME Unemployment Ins. Current Prior Year Before Prior PY17 $0.00 PY16 $0.00 PY15 $0.00 CERTIFICATION: I certify to the best of my knowledge and belief the above reported information is accurate and complete for the period reported. Authorized Signature See instructions for completing this form on the next tab (Attachment F 3 of 3) SEP 12 2018 Date it,o/e? -07S9° COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT EMPLOYMENT AND TRAINING PROGRAMS STAND-IN COST REPORT FORM (SICRF) 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. Attachment F Page 3 of 3 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 Attachment I Page 1 of 6 SUBRECIPIENT CERTIFICATION OF PHYSICAL INVENTORY Subrecipient Name: ES 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 Comprehensive Employment and Training Act (CETA) or the Job Training Partnership Act (JTPA) program to the Workforce Investment Act (WIA) programs or purchased under any Colorado Department of Labor and Employment (CDLE) federally funded grant or transferred with the CDLE's approval is included in the attached listing for the above -noted subrecipient. The attached listing has been verified by a physical inventory. Changes/revisions are: ❑ Noted O Not Applicable I certify that this property is being used for purposes that it was originally purchased for and will be repaired or replaced by my insurance if damaged, lost, or stolen. I certify that all property/equipment previously purchased with or transferred from the CETA or the JTPA programs to WIA 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 CETA or JTPA program to the WIA 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. SEP 12 2018 Subrecipient Director's Signature Date a'te,a-o2gPo 5 COLORADO DEPARTMENT OF LABOR AND EMPLOYMEN1 CONTRACT CLOSEOUT TAX CERTIFICATION In the performance of Contract/Grant Agreement Number CMS #54599 Expenditure Authorizations (EAs)/Work Plan awarded under said Contract/Grant Agreement, identified as CLEAR Program Code : 17C6000000 2055000000 20D7000000 2886000000 , 2887000000 2M56000000 2S56000000 2W28000000 46A6000000 , 46D6000000 47D6000000 48A6000000 48D6000000 4A66000000 , 4A86000000 4BD6000000 , 4D66000000 4D86000000 4DW6000000 4ED5000000 4FD5000000 4GD5000000 41D5000000 , including the 4MT5000000 4ND6000000 4RA5000000 4S35000000 4S45000000 4S55000000 4Y66000000 4Y76000000 4Y86000000 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 • c"o Q 0a' day of , 2018. Attachment I Page 2 of 6 GRANT RECIPIENT'S ASSIGNMENT OF REFUNDS, REBATES, AND CREDITS Grant Recipient's Name: Employment Services of Weld County Contract/Grant Agreement No: CMS #54599 Street Address: PO Box 1805 City and State: Greeley CO 80632 Pursuant to the terms of Contract/Grant Agreement Number Expenditure Authorizations (EAs)/Work Plan awarded under said Contract/Grant Agreement, identified as CLEAR Program code(s) : 2886000000 46A6000000 46D6000000 47D6000000 4A66000000 4A86000000 4BD6000000 4DW6000000 4ED5000000 4FD5000000 4MT5000000 4ND6000000 4RA5000000 4S55000000 4Y66000000 4Y76000000 2887000000 17C6000000 , 2M56000000 2055000000 2S56000000 48A6000000 4D66000000 4GD5000000 4S35000000 4Y86000000 , including the 20D7000000 2W28000000 48D6000000 4D86000000 41D5000000 4545000000 and in consideration of the reimbursement of costs and payment of fee, as provided in the said Contract/Grant Agreement and any assignment thereunder, the Grant Recipient's Name and Address (hereinafter called the Grant Recipient) does hereby: 1. Assign, transfer, set over and release to the Colorado Department of Labor and Employment (hereinafter called CDLE), all right, title and interest to all refunds, rebates credits or other amounts (including any interest thereon) arising out of the performance of the said contract/grant 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 ob-8°- 81020 iday of By Authorized Signature Title BOCC Chair , 2018. Attachment I Page 3 of 6 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT SCHEDULE OF UNCLAIMED CHECKS Grant Recipient Name: Employment Services of Weld County Contract/Grant 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 �o _- day of , 2018. By Authorized Signature Title BOCC Chair Attachment I Page 4 of 6 aoi8-zft0 8 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 Pursuant to the terms of Contract/Grant Agreement Number CMS #54599 , including the Expenditure Authorizations (EAs)/Work Plan awarded under said Contract/Grant Agreement, as CLEAR Program code (s): 17C6000000 2055000000 , 20O7000000 , 2886000000 2887000000 , 2M56000000 , 2S56000000 2W28000000 46A6000000 , 4606000000 , 47O6000000 48A6000000 , 48O6000000 4A66000000 4A86000000 4BD6000000 4066000000 4O86000000 4DW6000000 4ED5000000 4FD5000000 4GD5000000 4105000000 , 4MT5000000 4ND6000000 4RA5000000 , 4S35000000 4S45000000 4S55000000 4Y66000000 4Y76000000 4Y86000000 and in consideration of the sum of Total amount paid of $3,430,543.00 $0.00 ($ of Unclaimed Checks Total) under the said Contract to and payable of (Contractor's Name and Address) hereafter called the Grant Recipient or to its assignees, if any, the Grant Recipient, upon payment of the said sum by the COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT, hereinafter called CDLE, does remise, release, and discharge CDLE, its officers, agents, and employees, of and from all liabilities, obligations, claims, and demands whatsoever under or arising from said Contract/Grant Agreement except: 1. 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): 2. 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. 3. Claims after closeout, for costs which results from the liability to pay nemployment Insurance costs under a reimbursement system or to settle Worker's Compensation claims. This release has been executed this �- ) day of By Title BOCC Chair ,2018. Attachment I Page 5 of 6 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT PHYSICAL INVENTORY LIST Grant Recipient Name: Employment Services of Weld Count Contract/Grant Agreement Number: CMS #54599 Release Date: Attachment I 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. ON This Physical Inventory List has been executed this 1 By Authorized Signature Title BOCC Chair Revised: 6/05 Copy of 3-2018-PGL-Attachment-E-F-H-I (2) WFD Regional Budget Report Period: Jul -18 Report Type: PJTD Entity: 5230 Unit Program Program Description Activity Budget Actual Balance Not Used(0000) 1647000000 LABOR CERTIFICATION FFY17 Not Used(0000) 7,563.90 4,176.37 3,387.53 Not Used(0000) 17C6000000 NON-WIOA-TAA CASE MANAGEMENT FFY16 Not Used(0000) 5,400.00 5,400.00 0 Not Used(0000) 17C7000000 NON-WIOA-TAA CASE MANAGEMENT FFY17 Not Used(0000) 13,631.00 1,971.60 11,659.40 Not Used(0000) 2055000000 PY15 WAGNER PEYSER Not Used(0000) 531,185.00 531,185.00 0 Not Used(0000) 2056000000 PY16 WAGNER PEYSER Not Used(0000) 514,519.00 514,519.00 0 Not Used(0000) 2057000000 WFD-ES-WAGNER PEYSER 90% TO COUNTY ALLCOATION Not Used(0000) 444,846.00 148,905.69 295,940.31 Not Used(0000) 20D7000000 FFY17-DISABLED VETS OUTREACH PROG Not Used(0000) 7,000.00 7,000.00 0 Not Used(0000) 2886000000 UI-RESEA Expenditures -Mary Ball grant Not Used(0000) 55,100.00 55,100.00 0 Not Used(0000) 2887000000 UI-RESEA Expenditures -Mary Ball grant -92887 Not Used(0000) 4,650.00 4,650.00 0 Not Used(0000) 28C8000000 RESEA Expenditures - County Not Used(0000) 2,200.00 2,025.00 175 Not Used(0000) 2M55000000 10% MIGRANT SSNL WRKR-PY15WP Not Used(0000) 26,675.00 26,675.00 0 Not Used(0000) 2M56000000 10% MIGRANT SSNL WRKR-PY16WP Not Used(0000) 18,166.00 18,166.00 0 Not Used(0000) 2555000000 PY15-WP10% SUMMER JOB HUNT PY14WP Not Used(0000) 40,000.00 40,000.00 0 Not Used(0000) 2556000000 PY16-WP10% SUMMER JOB HUNT Not Used(0000) 40,000.00 40,000.00 0 Not Used(0000) 2557000000 PY17-P10% SUMMER JOB HUNT Not Used(0000) 40,000.00 17,040.45 22,959.55 Not Used(0000) 2W27000000 ESF-SFY17- 7/1/2016 to 6/30/2017 -WED ESF ONLY -NO CRWC Not Used(0000) 404,346.00 404,346.00 0 Not Used(0000) 2W28000000 ESF-SFY18 WFD ESF ONLY -NO CRWC Not Used(0000) 382,635.00 382,635.00 0 Not Used(0000) 46A5000000 FY16 - WIOA ADULT LOCAL ADMIN Not Used(0000) 38,721.11 38,721.11 0 Not Used(0000) 46A6000000 FY17 - WIOA ADULT LOCAL ADMIN Not Used(0000) 33,453.00 33,453.00 0 Not Used(0000) 46A7000000 FY18 - WIOA ADULT LOCAL ADMIN Not Used(0000) 20,870.00 0 20,870.00 Not Used(0000) 46D5000000 FY16 - WIOA DW- LOCAL ADMIN Not Used(0000) 18,281.00 18,281.00 0 Not Used(0000) 46D6000000 FY17 - WIOA DW- DW LOCAL/COUNTIES ADMIN Not Used(0000) 24,759.00 24,759.00 0 Not Used(0000) 46D7000000 FY18 -DW- DW ADMIN LOCAL/COUNTIES Not Used(0000) 20,875.00 13,636.12 7,238.88 Not Used(0000) 47D6000000 FY17- WIOA 25% DW ENHANCED ADMIN LOCAL/COUNTIES Not Used(0000) 9,692.00 9,692.00 0 Not Used(0000) 47D7000000 FY18 - WIOA 25% DW ENHANCED ADMIN LOCAL/COUNTIES Not Used(0000) 13,920.00 0 13,920.00 Not Used(0000) 48A6000000 FY17 - WIOA ADULT LOCAL PROGRAM Not Used(0000) 301,080.00 190,107.10 110,972.90 Not Used(0000) 48A6000000 FY17 - WIOA ADULT LOCAL PROGRAM WIA-Direct Training Local Program(8000) 0 110,972.90 -110,972.90 Not Used(0000) 48A7000000 FY18 - WIOA ADULT LOCAL PROGRAM Not Used(0000) 396,515.00 395,136.95 1,378.05 Not Used(0000) 48D5000000 FY16- WIOA DW LOCAL PROGRAM Not Used(0000) 164,533.00 124,092.22 40,440.78 Not Used(0000) 48D5000000 FY16- WIOA DW LOCAL PROGRAM WIA-Direct Training Local Program(8000) 0 40,440.78 -40,440.78 Not Used(0000) 48D6000000 FY17- WIOA DW LOCAL/COUNTIES PROGRAM Not Used(0000) 222,839.00 178,552.63 44,286.37 Not Used(0000) 48D6000000 FY17- WIOA DW LOCAL/COUNTIES PROGRAM WIA-Direct Training Local Program(8000) 0 44,286.37 -44,286.37 Not Used(0000) 48D7000000 FY18- WIOA DW PROGRAM LOCAL/COU Not Used(0000) 187,872.00 118,491.23 69,380.77 Page 1 of 3 WFD Regional Budget Report Period: Jul -18 Report Type: PJTD Entity: 5230 Unit Program Program Description Activity Budget Actual Balance Not Used(0000) 49D6000000 FY17- WIOA 25% DW ENHANCED PROG LOCAL/COUNTIES Not Used(0000) 147,907.00 89,277.85 58,629.15 Not Used(0000) 49D7000000 FY18- WIOA 25% DW ENHANCED PROG LOCAL/COUNTIES Not Used(0000) 125,285.00 882.29 124,402.71 Not Used(0000) 4A65000000 PY15 - WIOA ADULT LOCAL ADMIN Not Used(0000) 3,972.00 3,972.00 0 Not Used(0000) 4A66000000 PY16 - WIOA ADULT LOCAL ADMIN Not Used(0000) 4,881.00 4,881.00 0 Not Used(0000) 4A67000000 PY17 - WIOA ADULT 10% ADULT COUNTY ADMIN Not Used(0000) 3,045.00 3,045.00 0 Not Used(0000) 4A85000000 PY15 - WIOA ADULT LOCAL PROGRAM Not Used(0000) 35,748.00 12,424.36 23,323.64 Not Used(0000) 4A85000000 PY15 - WIOA ADULT LOCAL PROGRAM WIA-Direct Training Local Program(8000) 0 23,323.64 -23,323.64 Not Used(0000) 4A86000000 PY16 - WIOA ADULT LOCAL PROGRAM Not Used(0000) 43,934.00 31,552.79 12,381.21 Not Used(0000) 4A86000000 PY16 - WIOA ADULT LOCAL PROGRAM WIA-Direct Training Local Program(8000) 0 12,381.21 -12,381.21 Not Used(0000) 4A87000000 PY17 - WIOA ADULT PROGRAM COUNTY Not Used(0000) 57,861.00 57,861.00 0 Not Used(0000) 4BD5000000 FY16 - WIOA DW-LOCAL ADMIN TRANSFER ADULT Not Used(0000) 6,983.10 6,983.10 0 Not Used(0000) 4BD6000000 FY17 - WIOADW-LOCAL/COUNTIES ADMIN TRANSFER ADULT Not Used(0000) 15,000.00 15,000.00 0 Not Used(0000) 4BD7000000 FY18 - WIOA DW-ADMIN TRANSFER TO ADULT LOCALS/COUNTIES Not Used(0000) 20,874.00 8,227.19 12,646.81 Not Used(0000) 4D65000000 PY15 - WIOA -DW LOCAL ADMIN Not Used(0000) 3,317.00 3,317.00 0 Not Used(0000) 4D66000000 PY16 - WIOA DW LOCAL ADMIN Not Used(0000) 7,462.00 7,462.00 0 Not Used(0000) 4D67000000 PY17 - WIOA DW 10% COUNTY ADMIN Not Used(0000) 3,918.00 3,918.00 0 Not Used(0000) 4D75000000 PY15- WIOA 25% DW ENHANCED ADMIN LOC Not Used(0000) 2,195.00 2,195.00 0 Not Used(0000) 4D85000000 PY15- WIOA DW LOCAL PROGRAM Not Used(0000) 29,853.00 11,329.32 18,523.68 Not Used(0000) 4D85000000 PY15- WIOA DW LOCAL PROGRAM WIA-Direct Training Local Program(8000) 0 18,523.68 -18,523.68 Not Used(0000) 4D86000000 PY16- WIOA DW LOCAL PROGRAM Not Used(0000) 67,159.00 67,159.00 0 Not Used(0000) 4D87000000 PY17 - WIOA DW PROGRAM COUNTY Not Used(0000) 35,261.00 35,261.00 0 Not Used(0000) 4D95000000 PY15 - 25% ENHANCED DISLOCATED WORKER Not Used(0000) 0 4,827.76 -4,827.76 Not Used(0000) 4D95000000 PY15 - 25% ENHANCED DISLOCATED WORKER WIA-Direct Training Local Program(8000) 0 14,930.24 -14,930.24 Not Used(0000) 4DB5000000 PY15 - WIOA LOCAL ADMIN TRANSFER ADULT Not Used(0000) 3,317.00 3,317.00 0 Not Used(0000) 4D87000000 PY17 - WIOA DW ADMIN TRANSFER TO ADULT ADMIN COUNTY Not Used(0000) 3,917.00 3,917.00 0 Not Used(0000) 4DN5000000 PY15 - WIOA LOCAL PROG TRANSFER ADULT Not Used(0000) 29,853.00 656.72 29,196.28 Not Used(0000) 4DN5000000 PY15 - WIOA LOCAL PROG TRANSFER ADULT WIA-Direct Training Local Program(8000) 0 29,196.28 -29,196.28 Not Used(0000) 4DN7000000 PY17 - WIOA DW PROGRAM TRANSFER TO ADULT PROGRAM Not Used(0000) 35,261.00 35,261.00 0 Not Used(0000) 4DW5000000 PY15 - WIA CWDC 5% DW COUNCIL INITIATIVES Not Used(0000) 20,490.00 20,490.00 0 Not Used(0000) 4DW6000000 PY16 - WIA CWDC 10% DW COUNCIL Not Used(0000) 15,750.00 15,750.00 0 Not Used(0000) 4ED5000000 FY16-WIOA 25% DW ENHANCED ADMIN TO LOCAL Not Used(0000) 5,122.00 5,122.00 0 Not Used(0000) 4FD5000000 FY16 - WIOA -25% DW ENHANCED PROGRAM TO LOCAL Not Used(0000) 74,841.00 74,841.00 0 Not Used(0000) 4FF6000000 FY17 WFD-APP-LOCAL-Apprenticeship Not Used(0000) 37,219.00 10,219.00 27,000.00 Page 2 of 3 WFD Regional Budget Report Period: Jul -18 Report Type: PJTD Entity: 5230 Unit Program Program Description Activity Budget Actual Balance Not Used(0000) 4FH6000000 FY17 WFD-APP-LOCAL Admin Not Used(0000) 3,000.00 0 3,000.00 Not Used(0000) 4GD5000000 FY16 - WIOA-5%-$165,000 WFD Tech Assist Locals Not Used(0000) 22,000.00 22,000.00 0 Not Used(0000) 41D5000000 FY16 - WIOA 25% DW- WIOA TRANISITIONAL ACTIVITIES Not Used(0000) 5,109.00 5,109.00 0 Not Used(0000) 4MT5000000 PY14-WIOA Technical Assist Traninig-TMT ADVANCE Not Used(0000) 8,000.00 8,000.00 0 Not Used(0000) 4ND5000000 FY16 - WIOA DW- LOCAL PROG TRANSFER ADULT Not Used(0000) 164,533.00 102,882.55 61,650.45 Not Used(0000) 4ND5000000 FY16 - WIOA DW- LOCAL PROG TRANSFER ADULT WIA-Direct Training Local Program(8000) 0 61,650.45 -61,650.45 Not Used(0000) 4ND6000000 FY17 - WIOA DW-LOCAL/COUNTIES PROG TRANSFER ADULT Not Used(0000) 135,000.00 86,427.90 48,572.10 Not Used(0000) 4ND6000000 FY17 - WIOA DW-LOCAL/COUNTIES PROG TRANSFER ADULT WIA-Direct Training Local Program(8000) 0 48,572.10 -48,572.10 Not Used(0000) 4ND7000000 FY18 - WIOA DW-PROGRAM TRANSFER TO ADULT Not Used(0000) 187,872.00 0 187,872.00 Not Used(0000) 4RA5000000 FY16 - WIOA WFD 5%- ADULT EVALU & CONTIN IMPR Not Used(0000) 20,000.00 20,000.00 0 Not Used(0000) 4535000000 PY15-WFD-SPNEG-GRANT PLANNING Not Used(0000) 80,257.00 80,257.00 0 Not Used(0000) 4S45000000 PY15-WFD-SPNEG-LOCALADMIN Not Used(0000) 57,346.00 57,346.00 0 Not Used(0000) 4555000000 PY15-WFD-SPNEG-LOCAL PROGRAM Not Used(0000) 723,160.00 723,160.00 0 Not Used(0000) 4Y65000000 PY15 - WIOA 10% YOUTH LOCAL ADMIN Not Used(0000) 61,902.00 61,808.92 93.08 Not Used(0000) 4Y66000000 PY16 - WIOA 10% YOUTH LOCAL ADMIN Not Used(0000) 30,956.00 30,956.00 0 Not Used(0000) 4Y67000000 PY17- WIOA YOUTH 10% COUNTY ADMIN Not Used(0000) 29,751.00 19,354.66 10,396.34 Not Used(0000) 4Y76000000 PY16 - WIOA YOUTH MIN -75% -OUT -SCHOOL LOCAL PROGRAM Not Used(0000) 448,607.00 206,766.74 241,840.26 Not Used(0000) 4Y76000000 PY16 - WIOA YOUTH MIN -75% -OUT -SCHOOL LOCAL PROGRAM WIA-Direct Training Local Program(8000) 0 158,549.13 -158,549.13 Not Used(0000) 4Y76000000 PY16 - WIOA YOUTH MIN -75% -OUT -SCHOOL LOCAL PROGRAM YOUTH -20% -OUT -SCHOOL -WORK 0 83,291.13 -83,291.13 Not Used(0000) 4Y77000000 PY17 - WIOA OSY-75% YOUTH OUT OF SCHOOL TO COUNTIES Not Used(0000) 423,966.00 266,601.99 157,364.01 Not Used(0000) 4Y77000000 PY17 - WIOA OSY-75% YOUTH OUT OF SCHOOL TO COUNTIES YOUTH -20% -OUT -SCHOOL -WORK 0 65,529.62 -65,529.62 Not Used(0000) 4Y86000000 PY16 - WIOA YOUTH MAX -25% -IN -SCHOOL LOCAL PROGRAM Not Used(0000) 30,000.00 13,426.83 16,573.17 Not Used(0000) 4Y86000000 PY16 - WIOA YOUTH MAX -25% -IN -SCHOOL LOCAL PROGRAM WIA-Direct Training Local Program(8000) 0 520 -520 Not Used(0000) 4Y86000000 PY16 - WIOA YOUTH MAX -25% -IN -SCHOOL LOCAL PROGRAM YOUTH -20% -IN -SCHOOL -WORK 0 16,053.17 -16,053.17 Not Used(0000) 4Y87000000 PY17 -WFD WIOA ISY-25% YOUTH IN SCHOOL TO COUNTIES Not Used(0000) 141,321.00 59,424.03 81,896.97 Not Used(0000) 4Y87000000 PY17-WFD WIOA ISY-25% YOUTH IN SCHOOL TO COUNTIES YOUTH -20% -IN -SCHOOL -WORK 0 19,756.56 -19,756.56 Not Used(0000) 4YW6000000 PY16 - WIA CWDC 10%YOUTH COUNCIL $1,118,290.50 Not Used(0000) 48,265.00 10,280.22 37,984.78 Total 7,452,797.11 6,409, 645.95 1,043,151.16 Page 3 of 3 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Attachment H GRANT CLOSEOUT RECONCILICATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 CONTRACT/EA/WORKPLAN START DATE PROGRAM INCOME START DATE Page 1 of 2 YEAR OF FUNDS FFY16 TITLE/PROGRAM/PROJECT NON-WIOA-TAA CASE MANAGEME CLEAR Program code 17C6000000 10/1/2016 END DATE END DATE 6/30/2018 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 2. Current Program and Admin Cash Needs 5,400.00 3. FINAL Program and Admin Cash Needs Contract to Date 5,400.00 II. PROGRAM EXPENSE REPORT (ER) �, Fu , .EA„,,Ti` 1. Total Expenses+Accruals Previously Reported (Through Last Month) 5,400.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 5,400.00 ADMINISTRATIVE EXPENSE (ER) `lii�„ 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(P1) EXPENSE REPORT �� t t? dgµ , 1. Total Program Income Expenses 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 flr :;. 1. FINAL Cash Request Contract to Date 5,400.00 2. FINAL Expenses Through End of Contract 5,400.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 fr ate. '- x : _ .. 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 VII. MATCH RECONCILIATIONS �... '` 1. FINAL Match Reported Through End of Contract 2. FINAL Expenses Through End of Contract 5,400.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 Signature7:(er- Date j )-I rt 8 Authorized Signature ✓-- Date SEP 12 2018 See instruction for completing this for on the next tab (Attachment H 2 of 2) d-9 /s''01 ? %'O 11 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Attachment H GRANT CLOSEOUT RECONCILICATION WORKSHEET Page 2 of 2 GRANT CLOSEOUT RECONCILIATION WORKSHEET INSTRUCTIONS Subrecipinet: Enter the subrecipient's name Address: Enter the subrecipient's address Year of Funds: Enter the year of funds of the grants that is being closed (eg. PY14 or PY15). Title/Program/Project: Enter the title, program, and/or project name of the grant. CLEAR Program code: Enter CLEAR program code for the grant. Contract/EANVorkplan Start/End Date: Enter the start and end date of the grant on the applicable lines. Program Income Start/End Date: If program income was generated under the grant, enter the start and end date of the program income portion of the grant on the applicable lines. I. CASH REQUEST 1.Enter the amount of program and administrative cash needs reported prior to this draw. 2. Enter the amount of current cash needs reported, 3. Add the amount from 1 to 2 above. Enter total here. II. PROGRAM EXPENSE REPORT 1. Enter the amount of expenses+accruals reported prior to this report on the CLEAR Funds Available Anakysis reportNAX Expense 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 Anakysis reportNAX Expense 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 Anakysis reportNAX Program Income Expense report. 2. Enter the amount of current program income expenses through end of this award. 3.Add the amounts from 1 to 2. Enter total here. IV. RECONCILIATION The goal of this reconciliation is that cash drawn should equal expenses+accruals reported at the end of the award. If the answer to #3 below is NO and no PI has been reported, then adjust current cash draw or current expenses reported to achiese a YES while reflecting actual expenses per your accounting records. If PI has been earned under this award, complete V thru VI 1. Enter the amount from 1.3 here 2. Enter the amount frojm 11.3 and 111.3 here 3. Does the amount from 1. EQUAL amount from 2? Check the appropriate box. V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Enter the amount of program income cash reported as received prior ro rhis report. 2. Enter the amount of current PI cash reported. 3. Add the amounts from 1 to 2. Enter total here. W. 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 contract period. 1. Enter the amount from V.3 here. 2. Enter the amount from 111.3 here. 3. Enter difference of 2 from 1 here. WI. 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 macth 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-TAA Case Management Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance October -15 17C600000 5,400.00 May -17 17C600000 870.26 870.26 870.26 6/26/17 4,529.74 June -17 17C600000 (548.74) 4,529.74 July -17 17C600000 469.11 4,529.74 August -17 17C600000 435.42 355.79 355.79 9/25/17 4,173.95 September -17 17C600000 362.69 362.69 362.69 10/20/17 3,811.26 October -17 17C600000 400.91 400.91 400.91 11/27/17 3,410.35 November -17 17C600000 514.30 514.30 514.30 12/21/17 2,896.05 December -17 17C600000 881.64 881.64 881.64 12/31/17 2,014.41 December B-17 17C600000 7.25 - 7.25 12/31/17 2,014.41 January -18 17C600000 333.63 340.88 333.63 2/27/18 1,673.53 February -18 17C600000 500.95 500.95 500.95 5/29/18 1,172.58 March -18 17C600000 556.65 556.65 556.65 8/7/18 615.93 April -18 17C600000 615.93 615.93 615.93 8/7/18 - May -18 17C600000 - June -18 17C600000 - July -18 17C600000 - Totals 5,400.00 5,400.00 5,400.00 17C600000 General ledger vs billed 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Ad -18 Account 5230.000(16500.17C6000000.0000.00000000( Funds Available ( Detail Balances ) Period riw Sep -15 Oct -15 [Nov -15 Dec -15 1Jan-16 .jFeb-16 Mar -16 Budget 0.00 5400.00 0.00 0.001 (1.003 0.00 j._.. 0.00° 0.001 0.00 5400.0(1,1 Encumbrance 0.00' 0.00 0.001 0.001 0.00 0_00 0.00 0.001 0.001 Account [5230 0000 8500 17C6000000 0000 00000000( Funds Available ( Detail Balances ) Period Sep -16 1Nov-16 1Dec-16 Jan -17__ Feb -17 Mar -17 Apr -17. May -17 Jun -17 Period Balances (PJTD) - Adj-18 Budget Encumbrance 0.001 0.001 0.001 0.00 0.001 0.001 0.00i 0.00 0.00. 0.001 0.00 j 0.001 0.001 0.00E 0.00'1 _. 0.001 n. 0.001 000; 11 5400.00 Account [5-230.0000.6500.17C6000000.0000.00000000( Funds Available ( Detail Balances ) Period Jul -17 Aug -17 [Sep -17 Nov -17 'Dec -17 Jan -18 Budget 001 0.00 0.001 0.00;[ 0.00 0.00! 0.001 0001 5400.00'1 000'1 Encumbrance 0.00'[ 0.001 0.00[ 0.00 0.00 0.00 0.00 it 355.791 0.00 0.001 0.001 Actual 0 001 0.00 0.001 _ 0.001 0.001 Funds Available 000 5400.00 0.00 000 0.00 0.00i 000 0.00i 0.00 1\1-1 i 0.00 0.00 0.00 0.00'1 Actual 000 ._._ 0.001 0001 000 0 00 0001. 0.00, 0001 870.261 0.001 5400.001 Actual_ 0.00 Funds Available 0.00 0.00 0.00 0.00 0.00 0.00 0,00 0.00 0.00 Funds Available 0.00 -355.79 362.69 362.69. 400.91 i 400 91 514.301 881 64 340.88;! 500.951 -500.95 556.65r _556.65 615.931 -514.30 -340.88 5400.00: -615.931;' 0.00 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Attachment H GRANT CLOSEOUT RECONCILICATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 CONTRACT/EA/WORKPLAN START DATE PROGRAM INCOME START DATE YEAR OF FUNDS PY15 TITLE/PROGRAM/PROJECT Wagner Peyser Page 1 of 2 CLEAR Program code 2055000000 7/1/2015 END DATE END DATE 6/30/2018 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 I�((�a.;°�� ) ��"�a A _. 505,362.00 25,823.00 531,185.00 II. PROGRAM EXPENSE REPORT (ER) 6':�.r:-=. 1. Total Expenses+Accruals Previously Reported (Through Last Month) 531,185.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 531,185.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 �,.� ' r a . • �.�hl a. 1. Total Program Income Expenses 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 531,185.00 2. FINAL Expenses Through End of Contract 531,185.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 k, a )0 i0 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 W. RECONCILIATION ar 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 2. FINAL Expenses Through End of Contract 531,185.00 3. Match Percentage of Expenditure Contracttual Requirement 0.00 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes ID /No ❑ 'The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signature'g" Date 91111$ Authorized Signature - / ' ' rv-1/4_Q^^'Lr' Date SEP 1 2 2018 See instruction for completing this for on the next tab (Attachment H 2 of 2) 020/er-o2f�% / CLEAR WIOA Reconciliation -Wagner Peyser Work Based Learning Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received Date Received ] Grant Balance June -15 205500000 531,185.00 September -15 205500000 26,518.79 26,518.79 26,518.79 3/8/16 504,666.21 October -15 205500000 73,306.22 73,306.22 73,306.22 12/1/15 431,359.99 November -15 205500000 77,955.73 77,955.73 77,955.73 3/3/16 353,404.26 December -15 205500000 14,953.11 14,953.11 14,953.11 1/27/16 338,451.15 January -16 205500000 1,773.72 1,773.72 1,773.72 5/11/16 336,677.43 February -16 205500000 3,486.68 3,486.68 3,486.68 7/27/16 333,190.75 March -16 205500000 10,609.48 10,609.48 10,609.48 6/21/16 322,581.27 April -16 205500000 5,621.78 322,581.27 May -16 205500000 7,672.93 7,310.30 7,310.30 7/1/16 315,270.97 June -16 205500000 36,894.31 42,878.72 42,878.72 7/27/16 272,392.25 July -16 205500000 62,093.30 272,392.25 August -16 205500000 60,066.89 122,160.19 122,160.19 12/31/16 150,232.06 September -16 205500000 57,397.40 57,397.40 57,397.40 12/31/16 92,834.66 October -16 205500000 56,732.15 56,732.15 56,732.15 12/31/16 36,102.51 November -16 205500000 10,279.51 10,279.51 10,279.51 12/31/16 25,823.00 July -17 205500000 25,823.00 August -17 205500000 25,823.00 September -17 205500000 25,823.00 October -17 205500000 2,541.02 2,541.02 2,541.02 11/27/17 23,281.98 November -17 205500000 2,532.34 2,532.34 2,532.34 12/21/17 20,749.64 December -17 205500000 3,567.57 3,567.57 3,567.57 2/1/18 17,182.07 December B-17 205500000 17,182.07 January -18 205500000 2,765.47 2,765.47 2,765.47 2/27/18 14,416.60 February -18 205500000 3,993.35 3,993.35 3,993.35 5/29/18 10,423.25 March -18 205500000 1,459.18 1,459.18 1,459.18 5/29/18 8,964.07 April -18 205500000 4,427.40 4,427.40 4,427.40 5/29/18 4,536.67 May -18 205500000 4,536.67 4,536.67 4,536.67 7/13/18 0.00 June -18 205500000 0.00 July -18 205500000 0.00 Totals 531,185.00 531,185.00 531,185.00 205500000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 ° Period Balances (PJTD) - Ad} -18 Account 5230.0000.6500.2055000000.0000.00000000C' Funds Available ( Detail Balances ) Period Aug -15._....... 1Sep 15 'Oct -15 INov-15 @Dec -15 �EJan 16 ;Feb -16 Mar-16 Apr-16 Budget 531185.00 0.00'. 531 Q 00, 0.001 0.00 0 00! 0.00 0.001 0.00 0.00 85.00 Encumbrance 0.001 0.00 0.00 ..._... .. _.... 0.001 0.001 0.001 14953.11! 0.00 3486.68 0.001 10609.48: 0.00 000_ 531185.001 0.00i Actual Funds Available 0.00 531185.00 0001 26518 79 26518 79,i, 73306 22 £ -73306.22 77955.73; 77955 73 - 14953.11, -1773.72 -3486 68 - 10609.48 0.00 . 0.00 Period Balances (PJTD) - Adj-18 ROM Account ;5230.0000.6500.2055000000.0000.00000000C Period 1Jun-16 1Ad}-16 lJul-16 Aug -16 !Sep -16 [Oct -16 Nov -16 iDec-16 Jan -17 Funds Available ( Detail Balances ) Budget Encumbrance Actual Funds Available 0.00; 0 00 7310.30i -7310.30 0.00 42878_72! -42878.72 0.00 0:.1 0.00; 0.001 0.00 0.00 0.00{ 531185.001 Q 001 0.001 0.001 mm 0.001 0.001 0.00 0.00 0.00 122160 191 -122160.19 57397.40i -57397.40 0:661 0.001 531185.00; -56732.15 0.00' Account 5230.0000.6500.2055000000.0000. 0C Funds Available ( Detail Balances ) Period Budget, _.... 1Feb 17 a 0.00d 1 Mar -17 0 00j ,Apr -17 :May -17 ;Jun -17 Adj-� 7 Jul -17 ... Aug -17 =Sep -17 'Oct -17 Account 15230.0000.6500.2055000000.0000.00000000C Period Dec -17 '1Jan-18 Feb -18 ^ri [Mar -18 fApr-18 1May-18 Jun -18 Adj-98 1Jul-18 Encumbrance Actual Funds Available 000! 0001 0.00 0.00': 0.00,j 0.00; 0.00' 0.00, 0.00 ..,. .... _ . 000£-... 0.00 0.003 0.00'f actor, 0.001 0 cto 0.00' 5.00 Funds Available ( Detail Balances ) Budget 0.00 0.001 0.00E 0.001 0.00 0.001 0.001 0.001 000; Y"- 0.001 0.00: 0.001 Encumbrance ----5-6-118511661- 0.001 0.061 0.001 0.001 0.001 0.001 0.001 2541.02A 531185.00 0.00 .' 000`' 0.00 0.00°! 0.00 0..00 . 0.00 .. 0.00 -2541.02 0.00 Actual Funds Available 2532.341 0.001 3567 571 -2532 34 -3567 57 0.001 2765 47 2765 47 dT.', 0.00 3993 351 -3993.35 0.00! 1459.18? -1459.18 = -- 0.0011 4427.40 -4427 40 0.001 0001 0.009 4536.67; 0.001 0.001 0.001 0.00i 5-31-18-5700-1- -4536 67 0 00 0.00 0.00' COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Attachment H GRANT CLOSEOUT RECONCILICATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 CONTRACT/EA/WORKPLAN START DATE PROGRAM INCOME START DATE Page 1 of 2 YEAR OF FUNDS FFY17 TITLE/PROGRAM/PROJECT DISABLED VETS OUTREACH PROG CLEAR Program code 20D7000000 10/1/2016 END DATE END DATE 12/31/2017 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 2. Current Program and Admin Cash Needs 7,000.00 3. FINAL Program and Admin Cash Needs Contract to Date 7,000.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 7,000.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 7,000.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 0.00 III. PROGRAM INCOME(PI) EXPENSE REPORT 1. Total Program Income Expenses 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,000.00 2. FINAL Expenses Through End of Contract 7,000.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes CI /No ❑ V. CASH REQUEST PROGRAM INCOME CASH REPORTED a�INA 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 W. RECONCILIATION I, 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 VII. MATCH RECONCILIATION a fiNr!))." 1. FINAL Match Reported Through End of Contract 2. FINAL Expenses Through End of Contract 7,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 S Date I /1Il, s Authorized Signature F?�€, M -,--1-Q---1--•-€7--- Dat$E1 12 ZO tB See instruction for completing this for on the next tab (Attachment H 2 of 2) c7 oig _x890 /3 CLEAR WIOA Reconciliation-DVOP Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance October -16 20D700000 7,000.00 November -16 20D700000 7,000.00 December -16 20D700000 1,399.98 7,000.00 January -17 20D700000 622.22 7,000.00 February -17 20D700000 622.22 7,000.00 March -17 20D700000 622.22 7,000.00 April -17 20D700000 622.22 7,000.00 May -17 20D700000 622.22 7,000.00 June -17 20D700000 622.23 5,133.31 5,133.31 7/21/17 1,866.69 July -17 20D700000 622.23 622.23 622.23 7/31/17 1,244.46 August -17 20D700000 622.23 622.23 622.23 8/31/17 622.23 September -17 20D700000 622.23 622.23 622.23 9/30/17 0.00 October -17 20D700000 0.00 November -17 20D700000 0.00 December -17 20D700000 0.00 December B-17 20D700000 0.00 January -18 20D700000 0.00 February -18 20D700000 0.00 March -18 20D700000 0.00 April -18 20D700000 0.00 May -18 20D700000 0.00 June -18 20D700000 0.00 July -18 20D700000 0.00 Totals 7,000.00 7,000.00 7,000.00 20D700000 General ledger vs bullied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 a Period Balances(PJTD) - Adj-18 Account 15230.0000.6500.2007000000.0000.00000000£ Period May -16 1Jun-16... 1Adj-16 _ ;Jul-16 ;Aug-16 1Sep-16 jOct-16 ;Nov -16 1Dec-16 Period 1Feb-17 Funds Available ( Detail Balances ) Budget 0.00; 0001 0.001 0.001 0.00; 0 001 7000.00 1 0.001 0.001 0 Period Balances (PJTD) - Adj-18 7000 001 Encumbrance 0.00, 0.00 000;. 0.00' 0.00 0.001 Account 5230.0000.6500.20D7000000.0000.00000000t Funds Available ( Detail Balances ) Actual Funds Available 0 00. 000 0.00. 000 000 0.001 0.001 0.001 0.00'1 0.001 Budget Encumbrance 0.00 0 00 0.0o, 0.00; 0.001 _ 0.001 0.001 0.00; 0.001 0.00'' 0.001,,,, 0.00 0.001 0.001 7000.001 0.00j1 0 00; 7000 00' Actual 0.001 0.001 0.00{ Q_001 0.001 5133.31; 0.001 0,00; 622.231 000 0.00 0.00 7000.00 0.00 0.00`.:; 0.00'. Funds Available 0.00.' 0 00 00 0.00 • Q 00, '1-622.23 0.001 622.231 -622_23 0.001 0.001 0.00 622.23„ -622 23 0.001 r 7000.00, 000 0.00. COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Attachment H GRANT CLOSEOUT RECONCILICATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 CONTRACT/EA/WORKPLAN START DATE PROGRAM INCOME START DATE Page 1 of 2 YEAR OF FUNDS FY15 TITLE/PROGRAM/PROJECT UI-RESEA EXPENDITURES -MARY BALL c CLEAR Program code 2886000000 6/6/2016 END DATE END DATE 6/30/2017 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported w s ' I., ._.. 'N' '* 2. Current Program and Admin Cash Needs 55,100.00 3. FINAL Program and Admin Cash Needs Contract to Date 55,100.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 55,100.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 55,100.00 ADMINISTRATIVE EXPENSE (ER) ) tote 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 Vairb' .i ,;�,g, 1. Total Program Income Expenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION �� r aNr�rtk ra sy. atii g)hr a tr ro 1. FINAL Cash Request Contract to Date 55,100.00 2. FINAL Expenses Through End of Contract 55,100.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 W. RECONCILIATION .��` a 'y '6:8 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 WI. MATCH RECONCILIATION VONS 1. FINAL Match Reported Through End of Contract 2. FINAL Expenses Through End of Contract 55,100.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 y Date 67/ H As Authorized Signature Z'` �.- -232,1..,,,fY Dat$ E P12 2018 See instruction for completing this for on the next tab (Attachment H 2 of 2) 0,2D/a— 9219 CLEAR WIOA Reconciliation-RESEA Reporting Month (Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance June -16 288600000 2,400.00 55,100.00 July -16 288600000 3,825.00 55,100.00 August -16 288600000 4,125.00 10,350.00 10,350.00 12/31/2016 44,750.00 September -16 288600000 2,925.00 2,925.00 2,925.00 12/31/2016 41,825.00 October -16 288600000 3,150.00 3,150.00 3,150.00 12/31/2016 38,675.00 November -16 288600000 3,300.00 3,300.00 3,300.00 12/31/2016 35,375.00 December -16 288600000 2,175.00 2,175.00 2,175.00 12/31/2016 33,200.00 January -17 288600000 4,950.00 4,950.00 4,950.00 2/23/2017 28,250.00 February -17 288600000 2,925.00 2,925.00 2,925.00 4/4/2017 25,325.00 March -17 288600000 3,525.00 3,525.00 3,525.00 5/11/2017 21,800.00 April -17 288600000 3,375.00 3,375.00 3,375.00 5/23/2017 18,425.00 May -17 288600000 5,550.00 5,550.00 5,550.00 6/26/2017 12,875.00 June -17 288600000 2,850.00 2,850.00 2,850.00 7/21/2017 10,025.00 July -17 288600000 5,025.00 5,025.00 5,025.00 8/21/17 5,000.00 August -17 288600000 2,250.00 2,250.00 2,250.00 9/25/17 2,750.00 September -17 288600000 2,750.00 2,750.00 2,750.00 10/20/17 - October -17 288600000 - November -17 288600000 - December -17 288600000 - December B-17 288600000 - January -18 288600000 - February -18 288600000 - March -18 288600000 - April -18 288600000 - May -18 288600000 - June -18 288600000 - July -18 288600000 - Totals 55,100.00 55,100.00 55,100.00 288600000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Account X230.0 Period Apr -16 ';May -16 Jun -16 .1A -d. 16 Jul-16 Aug -16 ;Nov -16 Mar -17 I Dec -16 Period ;Jan -17 1Feb-17N Funds Available -4950.00 0.6500.2886000000.0000.0000000 Funds Available ( Detail Balances ) Budget Encumbrance Actual Funds Available 0.00; 0.00; 000 0.00 0.001 0.00; 55100.00 0.00; 0.00; 000; 0.001 0.00; 0.00 0.001 0.001 Q.caQ 0.00'' 0.00; 0.001 000,__. 0.001 0.00' 00.00 5230.0000.6500.2886000000.0000.00000000C Funds Available ( Detail Balances ) ;;;Apr -17 ,May -17 ;Jun -17 ;Adl-17 Jul .l.. _.... ;Aug -17 lisep-17 Budget ._.. 0.00 0.00; 0.00; o.00I 0.00 0.€0 0601 0.001 0 00' 000 0.00 0.00 0.001 000 55100.00 0 00 10350.00 -10350.00 2925.00 -2925.00 31'50.00 i -3150.00 3300.00; 2175.00 55100.001 Encumbrance Actual 0.001 4950.001 0.00 2925 00 0.06 O00 0.00; 0.00^ 000 000 0.001 2250 00 0.00mm 2750.001 -3300 00 -2175.00'. 0 00 -5025.00 -2256.00 -2750 00 0.00 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Attachment H GRANT CLOSEOUT RECONCILICATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 CONTRACT/EA/WORKPLAN START DATE PROGRAM INCOME START DATE Page 1 of 2 YEAR OF FUNDS FFY17 TITLE/PROGRAM/PROJECT Ul-RESEA-Mary Ball grant -92887 CLEAR Program code 2887000000 1/1/2017 END DATE END DATE 3/31/2018 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 2. Current Program and Admin Cash Needs 4,650.00 3. FINAL Program and Admin Cash Needs Contract to Date 4,650.00 II. PROGRAM EXPENSE REPORT (ER) . '`, 1. Total Expenses+Accruals Previously Reported (Through Last Month) 4,650.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 4,650.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 I,irs i a, 8R , J d��,' 1. Total Program Income Expenses 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 4,650.00 2. FINAL Expenses Through End of Contract 4,650.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 Pil I 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 VI. RECONCILIATION 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 VII. MATCH RECONCILIATION .01KA m ' 5 I 1. FINAL Match Reported Through End of Contract 2. FINAL Expenses Through End of Contract 4,650.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. I Preparer's Signature Z" Date Pt fig Authorized Signature 2 `' i•-Z-E'-4,.,,L,..--- Date SEP 12 2018 See instruction for completing this for on the next tab (Attachment H 2 of 2) oto/g -a 8-9'4 CLEAR WIOA Reconciliation-RESEA Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance June -17 288700000 4,650.00 July -17 288700000 4,650.00 August -17 288700000 4,650.00 September -17 288700000 400.00 400.00 400.00 10/20/17 4,250.00 October -17 288700000 3,075.00 1,085.00 1,085.00 11/27/17 3,165.00 November -17 288700000 1,175.00 3,165.00 December -17 288700000 3,165.00 - December B-17 288700000 - January -18 288700000 - February -18 288700000 1,990.00 2/1/18 - March -18 288700000 1,175.00 2/1/18 - April -18 288700000 - May -18 288700000 - June -18 288700000 - July -18 288700000 - Totals 4,650.00 4,650.00 4,650.00 288700000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Account 15230.0000.6500.2887000000.0000.00000000C Period Sep -16 Funds Available ( Detail Balances ) Budget Encumbrance 0.00= 0.00 I Oct -16 1485.00i . ,Nov -16 E- t 6 0.00 1Dec 16 Jan -17 1Feb-17 Apr -17 0001 0.001 0.00; 0.00 0.00 0.00;x.. o.00 4650.00 a Period Balances (0.3TD) - A0j-18 Account 15230.0000.6500 2887000000.0000.00000000E Period lAug-17 „[Sep -17 1Nov-17 • ;Dec -17 1Jan 18 Feb -18 1Mar-18- 1Apr-18 IFMay-18 -41 Funds Available ( Detail Balances ) Budget 0.00 0.00 3165.001 0.001 0.00, 465 0.00 0.001 0.00 0.00 001 Encumbra nce 0.00 0.001. 0.001 0.001 0.001 0.001 0.001 0.001 Actual 0.001 .. .._. 0.00' 0.001 o.00 0.00: 0.00i 0.001 0.001 0.00, 4650 00 Funds Available 0.00 1485 00 000.' 0.00 000 0 00 0.00 0.00 0.00 0.00 0.00` 0.001 Actual Funds Available 0.00; 0.00 ,= 400001 4€30 00'11 0_00 1085.001 2080 00. 6.460 0.001 3165001 0.001 0.001 0001 0.00, 0.001 0.001 0001 000,_.. 0.001 0.00 i 4650.001 0.00 -3165.00 0.00 000 0.00 0.00 0.00 0.00! COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Attachment H GRANT CLOSEOUT RECONCILICATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 CONTRACT/EANVORKPLAN START DATE PROGRAM INCOME START DATE Page 1 of 2 YEAR OF FUNDS PY16 TITLE/PROGRAM/PROJECT 10% MIGRANT SSNL WRKR CLEAR Program code 2M56000000 7/1/2017 END DATE END DATE 6/30/2018 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 li,'i„tea, ...x .; . uii hR Nib 18,166.00 18,166.00 I1. PROGRAM EXPENSE REPORT (ER) ..,4," 1. Total Expenses+Accruals Previously Reported (Through Last Month) 18,166.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 18,166.00 ADMINISTRATIVE EXPENSE (ER) l 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 S 1. Total Program Income Expenses 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 18,166.00 2. FINAL Expenses Through End of Contract 18,166.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�W��, 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 at � � , 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 2. FINAL Expenses Through End of Contract 18,166.00 3. Match Percentage of Expenditure Contracttual Requirement 0.00 4. Match Expenditure Requirement 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) 0.00 Yes 0 /No ❑ "The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signature .� Date / J 1 A Authorized Signature 0.,.r-- O 1--C�^ G1.--- '-e%-1.-C....."---e 1.--- Date SEP 12 2078 See instruction for completing this for on the next tab (Attachment H 2 of 2) aois-ae 9-d /4, CLEAR WIOA Reconciliation -Wagner Peyser MSFW Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance July -16 2M 5600000 18,166.00 June -17 2M5600000 18,166.00 July -17 2M 5600000 18,166.00 August -17 2M5600000 18,166.00 September -17 2M5600000 698.44 18,166.00 October -17 2M5600000 346.83 1,045.27 1,045.27 11/27/17 17,120.73 November -17 2M5600000 1,861.94 1,861.94 1,861.94 12/21/17 15,258.79 December -17 2M5600000 1,896.81 1,896.81 1,896.81 2/1/18 13,361.98 December B-17 2M5600000 577.24 577.24 2/27/18 13,361.98 January -18 2M5600000 51.23 628.47 51.23 2/27/18 12,733.51 February -18 2M5600000 1,749.08 1,749.08 1,749.08 5/29/18 10,984.43 March -18 2M5600000 2,564.38 2,564.38 2,564.38 5/29/18 8,420.05 April -18 2M5600000 5,762.45 5,762.45 5,762.45 5/29/18 2,657.60 May -18 2M5600000 2,657.60 2,657.60 2,657.60 7/13/18 0.00 June -18 2M5600000 0.00 July -18 2M 5600000 0.00 Totals 18,166.00 18,166.00 18,166.00 2M5600000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 0 Period Balances (PJTD)- Adj-18 Account Period Aug -16 Sep -16 Oct -16 15230.0000.8 500 2M56000000 0000 000000001 Funds Available ( Detail Balances ) Nov -16 Dec -16 Jan -17 Feb -17 Mar -17 Apr -17 Budget 18166.001 0.001 0.00. 0.001 0004 0.00 0.001 o.00 0.001 0.001 CJ Period Balances (PJTD)-Adj-18 001. -. Encumbrance 0.001 0.001 0.00'! 0.001 0.00` 0.00, 0.00 Actual 000; 000 0.001 .. 0001 000; 0.0O' 0.00 0001 0.00 0.001 18166.00 Funds Available 18166 00 0.00 , 0.00 0.00 0.00 0.00 0.00 00 0.00 0.00 Account 45230.0000.6500.2M56000000.0000.000000001 Funds Available ( Detail Balances ) Period ;Sep -17 ,Nov -17 1113;--1-1"i Jan -18 1IFeb-18 :fMar-18 11Apr-18 jMay-18 Jun -18 Budget _.._ 0.001 0.001 0.001 0.00 0.001 Encumbrance 0.0a1_Ne_�i 0 00 0.001 0.001 0.00 0.00 0.00- 0.00 0.001 0.00 0.00 0.0O1 0.00 0.001 0.001 ........ _ . 18166.00! 0.00;_ Actual Funds Available 0.00 � _.�.._ 0.t?0� -1t- 1045.271- -1045.27 186194,.. -1861.94 1896,81: 628.471 1749 08! 2564.381;.. 5762 4571 0.001 8166.00' - 1896.8 -628.47 1749 08 - 2564.38 - 5762 45 - 2657.60 0.00 0.00 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Attachment H GRANT CLOSEOUT RECONCILICATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 CONTRACT/EA/WORKPLAN START DATE PROGRAM INCOME START DATE Page 1 of 2 YEAR OF FUNDS PY16 TITLE/PROGRAM/PROJECT WP10°/0 SUMMER JOB HUNT CLEAR Program code 2S56000000 1/1/2017 END DATE END DATE 12/31/2017 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 2. Current Program and Admin Cash Needs 40,000.00 3. FINAL Program and Admin Cash Needs Contract to Date 40,000.00 Il. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 40,000.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 40,000.00 ADMINISTRATIVE EXPENSE (ER) : , i 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 Expenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION t; i 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 E /No ❑ V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Total PI Cash Previously Reported on Cash Request d � sir ` 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0,00 VI. RECONCILIATION 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 WI. MATCH RECONCILIATION 1. FINAL Match Reported Through End of Contract 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 E /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 /J7�j� / Date ! / f Cg Authorized Signature ' t'- tea' mot-- DateSEP 12 2018 See instruction for completing this for on the next tab (Attachment H 2 of 2) aiy` of? /7 CLEAR WIOA Reconciliation -Summer Job Hunt Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received 1 Grant Balance January -17 255600000 40,000.00 February -17 255600000 3,996.77 3,996.77 3,996.77 4/4/17 36,003.23 March -17 2S5600000 8,368.66 8,368.66 8,368.66 5/11/17 27,634.57 April -17 255600000 7,132.73 7,132.73 7,132.73 5/23/17 20,501.84 May -17 2S5600000 4,473.34 4,473.34 4,473.34 6/26/17 16,028.50 June -17 255600000 1,502.97 1,502.97 1,502.97 7/21/17 14,525.53 July -17 255600000 2,035.91 2,035.91 2,035.91 8/21/17 12,489.62 August -17 255600000 518.75 518.75 518.75 9/25/17 11,970.87 September -17 255600000 344.67 344.67 344.67 10/20/17 11,626.20 October -17 255600000 4,100.43 4,100.43 4,100.43 11/27/17 7,525.77 November -17 255600000 7,525.77 7,525.77 7,525.77 12/21/17 0.00 December -17 2S5600000 0.00 December B-17 255600000 0.00 January -18 255600000 0.00 February -18 255600000 0.00 March -18 2S5600000 0.00 April -18 255600000 0.00 May -18 255600000 0.00 June -18 255600000 0.00 July -18 255600000 0.00 Totals 40,000.00 40,000.00 40,000.00 255600000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 cy Period Balances(PJTD) - Adj-18 Account 15230 0000 6500 2S56000000 0000 000000000 Funds Available ( Detail Balances ) Period �jAdris �. Jul -16 Aug -16 1Sep-16 lOct-16� ;Nov -16 1Dec-16 '1Jan-17 .._ Feb -17 Budget Encumbrance 0.001 0.00 o.00r— o oo 0.001 0.00! 0.001 000, o.00l o.00l 40000.001 0.001 000, 40000.00; Account 15230:00006500.2S58000000,0000.00000000E'. Period 'May -17 Jun -17 ;Adj-17 Jul -17 1Oct-17 [Nov -17 Dec -17 Funds Available ( Detail Balances ) 0A0' 0.00' 0,00 0.00 Budget Encumbrance 0.001 0.001 0.001 0.00 0.00 0.001 0.003 0.00; 0.00 0.00 i 0.00 0.00] 0.00 0.001 0.001 0.00 0.00, Actual Funds Available 0.001 0.001 0.000.'. 00. 0.00„ 0.007 40000.00' 0.0011i' 0 00 -3996.77 Actual Funds Available 7132.73I-7132.711-'7, 4473.341 -4473-.34' "w -":" 1502.9711µ -1502.97 0.001 0.00. "' 2035.91 -2035.9 51875;.._. -518.75 344.671 -344.67 4100.43[ -4100.43 7525 77'. -7525.77 0.00' 0.00. 6:661 40000.00, COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Attachment H GRANT CLOSEOUT RECONCILICATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 CONTRACT/EA/WORKPLAN START DATE PROGRAM INCOME START DATE Page 1 of 2 YEAR OF FUNDS SFY18 TITLE/PROGRAM/PROJECT WFD ESF ONLY-NOCRWC CLEAR Program code 2W28000000 7/1/2017 END DATE END DATE 6/30/2018 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 2. Current Program and Admin Cash Needs 382,635.00 3. FINAL Program and Admin Cash Needs Contract to Date 382,635.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) ay, ' ;, Tllk��w 382,635.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 382,635.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 Expenses 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 382,635.00 2. FINAL Expenses Through End of Contract 382,635.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes ID /No ❑ V CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Total PI Cash Previously Reported on Cash Request wag 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 W. RECONCILIATION, 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 VII. MATCH RECONCILIATION 1. FINAL Match Reported Through End of Contract 2. FINAL Expenses Through End of Contract 382,635.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 „ "}-7ej en Date j // �t 6 Authorized Signature e.,-k_ �y /j 2 �‹0'�q�'"°� Date SEP 12 2018 See instruction for completing this for on the next tab (Attachment H 2 of 2) 020/e- air 9v /g CLEAR WIOA Reconciliation -Employment Support Fund Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance June -17 2W2800000 382,635.00 July -17 2W2800000 84,089.84 382,635.00 August -17 2W2800000 27,297.58 382,635.00 September -17 2W2800000 22,349.28 133,736.70 133,736.70 10/20/2017 248,898.30 October -17 2W2800000 25,036.20 25,036.20 25,036.20 11/27/2017 223,862.10 November -17 2W2800000 24,953.23 24,953.23 24,953.23 12/21/2017 198,908.87 December -17 2W2800000 22,515.65 22,515.65 22,515.65 12/31/2017 176,393.22 December B-17 2W2800000 4,687.80 176,393.22 January -18 2W2800000 4,944.91 9,632.71 9,632.71 2/27/2018 166,760.51 February -18 2W2800000 13,130.10 13,130.10 13,130.10 5/29/2018 153,630.41 March -18 2W2800000 15,922.98 15,922.98 15,922.98 5/29/2018 137,707.43 April -18 2W2800000 19,185.57 19,185.57 19,185.57 5/29/2018 118,521.86 May -18 2W2800000 24,287.34 24,287.34 24,287.34 7/13/2018 94,234.52 June -18 2W2800000 71,447.38 71,447.38 71,447.38 8/2/2018 22,787.14 July -18 2W2800000 22,787.14 22,787.14 0.00 Totals 382,635.00 382,635.00 359,847.86 2W2800000 General ledger vs billied 0.00 Billed not received I 22,787.14 General ledger vs. received 22,787.14 Jun-17 dl-a7- Jul -17 m w fAug-17 'Oct -17 3 (PJTD) - Aug -18 Account Period eb-17 Mar -1' 7 ..� 5230.0000.6500.2W28000000 0000.00000000' Funds Available ( Detail Balances ) Budget 0.00! 0.001 zAp r-17 0.00E i i mr. May -17 ~µ 0.00 0.001 0.001 382635.0O 0.00! 0.001 0001. 62636.00 .., Encumbrance 0 00' 0.00 0.001 0.00, 0.00! 0.001 0.00 0.00'. 0.00 0.001 Actual Funds Available 0.001 0.00 0.00'1'1 Q00'' 0.00 0.00',' 0_00 382635.00 0.00 -- -133736_70 -25036.20 0.00 0001 0.001 0. 0001 0.001 0.001 133736.70' 25036.20! 382635 00, 1.00 fl Period Balances (PJTD) - Aug -18 ® fl Account 5230.0000.6500.2W28000000.0000.00000000 iApr-18 3May 18 pun -18 1Adj-18 t 1Jul-18 Funds Available ( Detail Balances ) Budget 0.00' 0.001 0.00 0.00" 000 0.00, 0.00; 382636.001 0.00! 0.0o t"...W 0 QO ,,. 0.001 _m 0.001 air Actual Funds Available 24953.231 -24953.23- 22515.651 -22515.65 9632.711 -9632.71 13130.101 -13130.10 15922.981 19185 57 24287.1 71447.381 0.00 22787.14 - 15922.98, -19185.57. -24287.34 - 71447.38 -22787.14 7_ COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Attachment H GRANT CLOSEOUT RECONCILICATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 CONTRACT/EANVORKPLAN START DATE PROGRAM INCOME START DATE Page 1 of 2 YEAR OF FUNDS FY17 TITLE/PROGRAM/PROJECT WIOA ADULT LOCAL ADMIN CLEAR Program code 46A6000000 7/1/2016 END DATE END DATE 6/30/2018 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 33,453.00 33,453.00 II. PROGRAM EXPENSE REPORT (ER) 0"t ' i 1. Total Expenses+Accruals Previously Reported (Through Last Month) 33,453.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 33,453.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 Expenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION �� a �� ,:k.. 1. FINAL Cash Request Contract to Date 33,453.00 2. FINAL Expenses Through End of Contract 33,453.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes ID /No ❑ V. CASH REQUEST PROGRAM INCOME CASH REPORTED , t4 �Lh N' g(° 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 VI. RECONCILIATION 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 WI. MATCH RECONCILIATION MOW I 1. FINAL Match Reported Through End of Contract 2. FINAL Expenses Through End of Contract 33,453.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 rl1//fi �' _...4.+-_...4.+--e-/tr✓ Authorized Signature '— - �' `ZeiL--.t Date PSE 12 2018 See instruction for completing this for on the next tab (Attachment H 2 of 2) a7/g-02g�D /q CLEAR WIOA Reconciliation -Adult Administration Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance May -17 46A600000 33,453.00 June -17 46A600000 7,617.24 7,617.24 7,617.24 7/21/2017 25,835.76 July -17 46A600000 2,836.57 2,836.57 2,836.57 8/21/2017 22,999.19 August -17 46A600000 5,547.22 5,547.22 5,547.22 8/25/2017 17,451.97 September -17 46A600000 5,679.40 5,679.40 5,679.40 10/20/2017 11,772.57 October -17 46A600000 11,772.57 November -17 46A600000 11,772.57 December -17 46A600000 11,772.57 December B-17 46A600000 1,518.49 11,772.57 January -18 46A600000 1,518.49 1,518.49 2/27/2018 10,254.08 February -18 46A600000 3,044.30 3,044.30 3,044.30 5/29/2018 7,209.78 March -18 46A600000 4,261.84 4,261.84 4,261.84 5/29/2018 2,947.94 April -18 46A600000 2,947.94 2,947.94 2,947.94 5/29/2018 - May -18 46A600000 - June-18 46A600000 - July -18 46A600000 - Totals 33,453.00 33,453.00 33,453.00 46A600000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Account 15230,0000.6500.46A6000000.0000.00000000( Funds Available ( Detail Balances ) Period Oct -16 _^ Nov -16 1May-17 Jun -17 Adj-17 Account Period Jul -17 Aug -17 Sep -17 ;opt -17._ Nov -17 1Dec-17 3Jan-18 Persad Balance - Aug -t8 Actual Funds Available Budget Encumbrance 3453.001 0-061: 0.00 1 0.001. 0.00 0.001 0.00,1 0.00'1 53.00 F 5230.0000.6500.46A6000000.0000.00000000( Funds Available ( Detail Balances ) Feb -18 Mar -18 Apr -18 Budget 0.00 0.00 ........... 0.00 0.00 0.001. 33453.00 1 0.00 fl 001 0.001 Encumbrance �..�0.00 1 _. 0.00; 000', 0.00' 0001 0.001 0.001 0.003 0.0011 33453.00 0.00 000 0.00 0.001 0.00E 0.001.:_ 0.00 0.00. 0.00 • 0.00 000 Q00 7617.24 -7617.24 0.00E 0.00 33453 001 Actual 5547.221 5679.40 0.00 0.00 0.00 1518.4911 0.00 Funds Available -2836 57 -5547 22 -5679.40 0.00 0.00 -1518.49', 0.001 0.001 3044 30; 4261.841 2947.941 33453 00 -3044.30 -4261.84 - -2947 94 0.00 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Attachment H GRANT CLOSEOUT RECONCILICATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 CONTRACT/EA/WORKPLAN START DATE PROGRAM INCOME START DATE Page 1 of 2 YEAR OF FUNDS FY17 TITLE/PROGRAM/PROJECT WIOA DW-DW LOCAL/COUNTIES AM/ CLEAR Program code 46D6000000 7/1/2016 END DATE END DATE 6/30/2018 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported :i�°iA, ��rr ,''r+' 2. Current Program and Admin Cash Needs 24,759.00 3. FINAL Program and Admin Cash Needs Contract to Date 24,759.00 II. PROGRAM EXPENSE REPORT (ER) al . ; 1. Total Expenses+Accruals Previously Reported (Through Last Month) 24,759.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 24,759.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 i��T ..'` 1. Total Program Income Expenses 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 �i a �' N 24,759.00 2. FINAL Expenses Through End of Contract 24,759.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 I//. 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 gym,�h"ti„,L IZ 1. FINAL Match Reported Through End of Contract 2. FINAL Expenses Through End of Contract 24,759.00 3. Match Percentage of Expenditure Contracttual Requirement 0.00 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes ID /No O 'The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signature Date / /�! I� Authorized Signature 0.1.,--Q._ 7)1-1>'-'1 2 �C Dat eSEP 12 2018 See instruction for completing this for on the next tab (Attachment H 2 of 2) ao CLEAR WIOA Reconciliation -Dislocated Worker Administration Reporting Month (Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance June -17 46D600000 24,759.00 July -17 46D600000 24,759.00 August -17 46D600000 24,759.00 September -17 46D600000 2,569.03 2,569.03 2,569.03 10/20/17 22,189.97 October -17 46D600000 3,431.48 3,431.48 3,431.48 11/27/17 18,758.49 November -17 46D600000 3,180.83 3,180.83 3,180.83 12/21/17 15,577.66 December -17 46D600000 3,297.85 3,297.85 3,297.85 2/1/18 12,279.81 December B-17 46D600000 7,671.66 12,279.81 January -18 46D600000 7,671.66 7,671.66 2/27/18 4,608.15 February -18 46D600000 1,524.67 1,524.67 1,524.67 5/29/18 3,083.48 March -18 46D600000 3,083.48 3,083.48 3,083.48 5/29/18 - April -18 46D600000 - May -18 46D600000 - June -18 46D600000 - July -18 46D600000 - Totals 24,759.00 24,759.00 24,759.00 46D600000 General ledger vs bullied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 0 Period Balances (PJTD) - Adj-18 Account 15230.0000.6500.46Dt000000.0000.00000000( Period IE =;Nov -16 Dec -16 1Jan-17 1Feb-17 Mar -17 Apr -17 May -17 ;Jun -17 1Adj-17 ca Period Balances (PJTD) - Adi-1 8 Funds Available ( Detail Balances ) Budget Encumbrance 24759.00! 0.001 0.00€ ... 0.001 0.00€ 0.001 0.001 0.00; 0.001 0.001 24759.001 Account 15230.0000.6500.46D600000ci0000.000O0000( Period N1Aug_17 1Sep-17 =10ct-17 1Pan-18 [Feb -18 {Mar -18 0.00. Apr -18 Funds Available ( Detail Balances ) Budget 0.001 0.001 000; 0.003 0.00; 0.00 0.001 0.001 ,".... 0.00 24759.00'5 0.001 o.00l 0.001 0.001 0 001 0.401 Encumbrance 0.001 .................... 0.00E 0.Qo 0.00 0.001 0.00 0.001 0.001 0.001 _. Actual 0.00' 0.00. .._ . 1 0.001 0.00�F __._. 0.001 Funds Available 24759 00 0.00 0 00 0.00 0.00 0.001 0.00 V.VV3 e v7m. 0001 000 71- 0.001 0.00 0.00,1 0.00 0.00 Actual Funds Available 0 001 000 0.0011 0.00 2569.031 3431.481 3180.83, 3297.851 7671.66; 1524 67 3083 48 -3083.48 0_00 1 000 . - 2569.03=11' - 3431 48, -3180.83 - 3297.85, - 7671 66 - 1524.67 24759001 0.00 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Attachment H GRANT CLOSEOUT RECONCILICATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 CONTRACT/EA/WORKPLAN START DATE PROGRAM INCOME START DATE Page 1 of 2 YEAR OF FUNDS FY17 TITLE/PROGRAM/PROJECT WIOA 25% DW ENHANCED ADMIN LOi CLEAR Program code 47D6000000 10/1/2016 END DATE END DATE 6/30/2018 I. CASH REQUESTt. 1. Total program and Admin Cash needs Preciously Reported _ iL ... n`� 2. Current Program and Admin Cash Needs 9,692.00 3. FINAL Program and Admin Cash Needs Contract to Date 9,692.00 II. PROGRAM EXPENSE REPORT (ER) ., Wi_ 1. Total Expenses+Accruals Previously Reported (Through Last Month) 9,692.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 9,692.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 Expenses 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 .. pI at 1. FINAL Cash Request Contract to Date 9,692,00 2. FINAL Expenses Through End of Contract 9,692.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 L 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 VII. MATCH RECONCILIATION I% - 1. FINAL Match Reported Through End of Contract 2. FINAL Expenses Through End of Contract 9,692.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/ . / Date �' /Arils Authorized Signature P� re 214 -0 -t -1-"f? �1 DateSEP 2018 See instruction for completing this for on the next tab (Attachment H 2 of 2) 0.?()/g- 028-10 02-I CLEAR WIOA Reconciliation -25% Enhanced DW Work Based Learning Administration Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance June -17 47D600000 9,692.00 July -17 47D600000 13.51 9,692.00 August -17 47D600000 9,692.00 September -17 47D600000 13.51 13.51 5/29/18 9,678.49 October -17 47D600000 9,678.49 November -17 47D600000 87.38 87.38 87.38 12/21/17 9,591.11 December -17 47D600000 9,591.11 December B-17 47D600000 9,591.11 January -18 47D600000 9,591.11 February -18 47D600000 9,591.11 March -18 47D600000 658.19 658.19 658.19 5/29/18 8,932.92 April -18 47D600000 1,079.43 1,079.43 1,079.43 5/29/18 7,853.49 May -18 47D600000 637.93 637.93 637.93 7/13/18 7,215.56 June -18 47D600000 7,215.56 7,215.56 7,215.56 8/2/18 - July -18 47D600000 - Totals 9,692.00 9,692.00 9,692.00 47D600000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 0 Penod Balances (PJTD) - Adj-18 ROM 1iFeb-17 IMar-17 !Apr -17 FMay-17 `[Jun -17 di -17 !Jul -17 IAug-17 ;Sep -17... 0 Period Balances (PJTD) - Adj-18 Account 15230.0000.6500.4706000000.0000.00000000( Jun -16 Funds Available ( Detail Balances ) Budget 0.00 0.00! 0.001 lAdj-16 0.00€ ;Jul -16 Nmj 0.00 ;Aug -16 1 0.001 [Sep -16 0.00'. [Oct -16 flNov-16 Dec -16 9692.00; Encumbrance 0.00 0.001 Account [5230.0000.6500.47D8000000.0000.00000000( Funds Available ( Detail Balances ) Budget Encumbrance 0.001 0.00! 0.001 ..... 0.001 0.001 0.001 0.00! 15759.001 000; 0.001 0.001 0001 0.001 1 0.00;1 0.001 0.00 0.00 0.001 0.00; 0.001 000!. 0 00;1 0.001 000 0.001 0.00' 0.001 0.00;[ 0.00'1, 0.00, 9692.001 Account 15230-0000.6500 47D6000000.0000.00000000( Funds Available ( Detail Balances ) Period INov 17 1Dec-17 Jan -18 .... Feb -18 1Ma�r-18 !Apr-18� May -18 e[Jun-18 '1Adj-18 Budget Encumbrance 0.001 0.00 0.001 - 0.001 9692.00' 000; 0.00 0.001 9692.001 Actual 0.003 Funds Available 000 0.00 0.00 0.00 0.00 000 `. 0.00; a00 -6067.001111 0.00 Funds Available 0.00 0.00 0.00 0.00 15759.00 000•; _ 0.00i _..__ 0 00 000;_._____. 0.. 00 0.061 0.00 -' 0.001 0.00 .;1 3.51 9692.00! Actual Funds Available 0.00! 0 00 87.381 -87.38 0.001 0.001 0 00 0.001 0.001 0.00 0.001 0.001 0.001 0001 0.00' 0.00! 658.19i 1079.431. 63793; 0 00 -658.19 -1079.43 -637.93 7215.561 0001 -7215.56 0.00 9692.00'! 0.00! COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT GRANT CLOSEOUT RECONCILICATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 CONTRACT/EANVORKPLAN START DATE PROGRAM INCOME START DATE YEAR OF FUNDS FY17 Attachment H Page 1 of 2 TITLE/PROGRAM/PROJECT WIOA ADULT LOCAL PROGRAM CLEAR Program code 48A6000000 7/1/2016 END DATE END DATE 6/30/2018 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 2. Current Program and Admin Cash Needs 301,080.00 3. FINAL Program and Admin Cash Needs Contract to Date 301,080.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) r, 301,080.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 301,080.00 ADMINISTRATIVE EXPENSE (ER)l� 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 Expenses 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 301,080.00 2. FINAL Expenses Through End of Contract 301,080.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 W RECONCILIATION s , i . 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 WI. MATCH RECONCILIATION)'( 1. FINAL Match Reported Through End of Contract 2. FINAL Expenses Through End of Contract 301,080.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 El /No ❑ 'The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signature / / Date - / ) 61 /13 Authorized Signature DateSEP 12 2018 See instruction for completing this for on the next tab (Attachment H 2 of 2) �/8 a, 8' qv aat CLEAR WIOA Reconciliation -Adult Program Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance April -17 48A600000 301,080.00 May -17 48A600000 28,899.01 28,899.01 28,899.01 6/26/17 272,180.99 June -17 48A600000 43,588.06 43,588.06 43,588.06 7/21/17 228,592.93 July -17 48A600000 70,744.89 70,744.89 70,744.89 8/21/17 157,848.04 August -17 48A600000 46,875.14 46,875.14 46,875.14 9/25/17 110,972.90 September -17 48A600000 110,972.90 October -17 48A600000 110,972.90 November -17 48A600000 110,972.90 December -17 48A600000 110,972.90 December -17 B 48A600000 110,972.90 January -18 48A600000 110,972.90 February -18 48A600000 110,972.90 March -18 48A600000 110,972.90 April -18 48A600000 110,972.90 May -18 48A600000 110,972.90 June -18 48A600000 110,972.90 July -18 48A600000 110,972.90 Totals 190,107.10 190,107.10 190,107.10 48A600000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 CLEAR WIOA Reconciliation -Adult Program Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance May -17 48A600000 27,294.74 27,294.74 27,294.74 6/26/2017 (27,294.74) June -17 48A600000 45,092.82 45,092.82 45,092.82 7/21/2017 (72,387.56) July -17 48A600000 5,465.97 5,465.97 5,465.97 8/21/2017 (77,853.53) August -17 48A600000 20,955.77 20,955.77 20,955.77 9/25/2017 (98,809.30) September -17 48A600000 12,163.60 12,163.60 12,163.60 10/20/2017 (110,972.90) October -17 48A600000 (110,972.90) November -17 48A600000 (110,972.90) December -17 48A600000 (110,972.90) December B-17 48A600000 (110,972.90) January -18 48A600000 (110,972.90) February -18 48A600000 (110,972.90) March -18 48A600000 (110,972.90) April -18 48A600000 (110,972.90) May -18 48A600000 (110,972.90) June -18 48A600000 (110,972.90) July -18 48A600000 (110,972.90) Totals 110,972.90 110,972.90 110,972.90 48A600000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Funds Available Inc{ Period Balances (PJTD) - Adj-18 Selection Criteria Ledger 1CDLE Ledger Budget 15230 WELD -15 Period 1Adj-18 Summary test Account 5230 0000 6500 48A6000000 0000 5230.0000.6500.48A60 i 0000.1 Amount Type Project To Date Encumbrance Type ALL Budget 0.00 0.00 Account Level All Encumbrance Actual 0.001 190107.10'. 0.001 110972.90' Funds Available 110972.90 -110972 90 ISOM Account 1523Q 0000.6500.48A6000000.0od0.Q0oo0a00( Funds Available ( Detail Balances ) Period Nov -16 Dec -16 1Jan-17 1Feb-17 1Mar-17 ',Apr -17 , May -17 `Jun -17 jAdj-17 Budget Encumbrance 301080.00{ 0.00 0 __ ._______.._.__. 0.00,; 00 0.00' 0.00. 0.00; 0.00; 0 ool o.0o' 0.001 3010 0 Period Balances (PJTD) - Adj-18 0.00 0,001 Account ;5230.0000.6500.48A6000000.0000.00000000( Funds Available ( Detail Balances ) Period I WI 1Aug-17 {Sep -17 1 Feb -18 11 Mar -18 Budget 0.001 0.00 0.001 0.001 0.00 o.00 0.00'; 0.0011 oao:... 0.001 0.001 0.00.., Encumbrance 0.001.._- 0.001 0.00i 0.00 0.001 0.001 Actual 0.401 0.00 0.001 0.001 0.001 0.00 Funds Available 301080.00 0.00 0,00 .'rt,. 400 0.00 0.00 0.00 0.00 28899.011 -28899.01 43588 06 190107.101 -43588.06 0972.90' Actual Funds_ Available -70744.891 -70744.89 46875.141 0.000 0.001 0.001 0.00 0.001 0901— ..,............ 0.001 m 0.001 0.00 301080.00,1 0.001 -46875.14' 0.00 0.00 0.00 1.� 0.00 4.00 0.00 190107.10 110972.90 Account '5230.0000.6500.48A6000000.0000.00000000( Funds Available ( Detail Balances ) Budget 0.00 0.00 Adj-17 ;Jul -17 EAug-17 1Sep 17 ![Oct-17�� ,;Nov -17 1 0.00E 0.00! 0.00;1 0.00 0.00 i 0.001 0.00,3 Encumbrance 0 001 0.003 0.00 27294.74, -27294.74 45092.82 ., -45092.82 0.00 0.00 5465.97 -5465.97 0.00` 0.00[ 0.00E 0.00 0.00 0.00E 20955.77 -20955.77 12163.60i 0.00{ 110972.90 -110972.90 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Attachment H GRANT CLOSEOUT RECONCILICATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 CONTRACT/EA/WORKPLAN START DATE PROGRAM INCOME START DATE Page 1 of 2 YEAR OF FUNDS FY17 TITLE/PROGRAM/PROJECT WIOA DW LOCAUCOUNTIES PROGRF CLEAR Program code 48D6000000 7/1/2016 END DATE END DATE 6/30/2018 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported qua '' ,, A 2. Current Program and Admin Cash Needs 222,839.00 3. FINAL Program and Admin Cash Needs Contract to Date 222,839.00 Il. PROGRAM EXPENSE REPORT (ER) 5T it 1. Total Expenses+Accruals Previously Reported (Through Last Month) 222,839.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 222,839.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 ViS�;e, ,, R 1. Total Program Income Expenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION `II._gym 1. FINAL Cash Request Contract to Date 222,839.00 2. FINAL Expenses Through End of Contract 222,839.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 W. RECONCILIATION 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 WI. MATCH RECONCILIATION , 1.„4aM 1. FINAL Match Reported Through End of Contract 2. FINAL Expenses Through End of Contract 222,839.00 3. Match Percentage of Expenditure Contracttual Requirement 0.00 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes 0 /No O 'The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signature _.t.c Date /=/11145 Authorized Signature tif� J / � "Lr+.� Date SEA 1 2 2016 See instruction for completing this for on the next tab (Attachment H 2 of 2) /8-90 .23 CLEAR WIOA Reconciliation -Dislocated Worker Program Reporting Month (Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance February -17 48D600000 222,839.00 March -17 48D600000 11,654.59 11,654.59 11,654.59 5/1/2017 211,184.41 April -17 48D600000 211,184.41 May -17 48D600000 8,761.79 8,761.79 8,761.79 6/26/2017 202,422.62 June -17 48D600000 202,422.62 July -17 48D600000 7,620.94 7,620.94 7,620.94 7/21/17 194,801.68 August -17 48D600000 35,098.63 35,098.63 35,098.63 9/25/17 159,703.05 September -17 48D600000 42,645.62 42,645.62 42,645.62 10/20/17 117,057.43 October -17 48D600000 25,653.57 25,653.57 25,653.57 11/27/17 91,403.86 November -17 48D600000 20,173.33 20,173.33 20,173.33 12/21/17 71,230.53 December -17 48D600000 26,944.16 26,944.16 26,944.16 2/1/18 44,286.37 December B-17 48D600000 44,286.37 January -18 48D600000 44,286.37 February -18 48D600000 44,286.37 March -18 48D600000 44,286.37 April -18 48D600000 44,286.37 May -18 48D600000 44,286.37 June -18 48D600000 44,286.37 July -18 48D600000 44, 286.37 Totals 178,552.63 178,552.63 178,552.63 48D600000 General ledger vs bullied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 CLEAR W1OA Reconciliation -Dislocated Worker Program Reporting Month (Program Code I Tracking Sheet ] CLEAR I Received I Date Received I Grant Balance June -17 48D600000 - July -17 48D600000 5,031.32 5,031.32 5,031.32 7/21/17 (5,031.32) August -17 48D600000 8,599.54 8,599.54 8,599.54 9/25/17 (13,630.86) September -17 48D600000 3,126.32 3,126.32 3,126.32 10/20/17 (16,757.18) October -17 48D600000 7,959.68 7,959.68 7,959.68 11/27/17 (24,716.86) November -17 48D600000 8,886.60 8,886.60 8,886.60 12/21/17 (33,603.46) December -17 48D600000 10,682.91 10,682.91 10,682.91 2/1/18 (44,286.37) December B-17 48D600000 (44,286.37) January -18 48D600000 (44,286.37) February -18 48D600000 (44,286.37) March -18 48D600000 (44,286.37) April -18 48D600000 (44,286.37) May -18 48D600000 (44,286.37) June -18 48D600000 (44,286.37) July -18 48D600000 (44,286.37) Totals 44,286.37 44,286.37 44,286.37 48D600000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Aug -17 ,[Sep -17 ` [Oct 17 e €Nov -17 i[Dec-17 Jan -18 Account [5230.0000.6500.48D6000000 0000.00000000( Funds Available ( Detail Balances ) [Feb -18 [Mar -18 Selection Criteria Ledger COLE Ledger Budget 5230 WELD -15 Period [Jun -18 Summary test Account € [5230.0000.6500 48D6000000 0000 222839.00 Account 15230.0000.6500.48D6000000.0000,0000Q000( Period [Oct -16 1Nov-16 iDec-16 [Jan -17 [1Feb-17' liJun-17 IAdj-17 Amount Type Protect To Date Encumbrance Type [ALL Account Level Al[, Budget Encumbrance Actual 0003 178552 63 0.00: 44286.37 Funds Available 44286 37 -44286.37'. Budget Encumbrance Actual Funds Available 222839.06f 000 0.00 222839.00 Funds Available ( Detail Balances ) � 0 0.00l 0.00_, 0 00,[' 000 oo t o.00, o.00; a 00 a 0.00; 0001 0.001 000N, 0.:00' 0.00 0D_{ 59'1 0.001 0.00# 0.00i 8761 79 0.001000r- 0.001 0,001 0.00; 222839 00', 0 001 0 001 178552.63, 0.00 0.00''. -8761 79-7. 0.0GO 0.00 :: 44286 37 Period Budget Encumbrance Actual Funds Available 0.00 0.00 - 35098.63i -35098.63' 42645.626 -42645.62 25653.57,1 -25653.5T- . 20173.33 0.00.; 0.001 1 222839.001 0.00,_ 178552.6i 0.001 -26944 16 0.00 _. 0.00' 0 00 44286.37 Account ,5230.0000.6500A8136000000.0000.00000000( Funds Available ( Detail Balances ) Period un-17 1Adl-17 1Jul-17 lAug-17 I Sep -17 Budget Encumbrance 0 001 0.00 0.001 0.001 0001 0.00 0.00' 0.00,E-� 0.00 _. 0.00 _. 0.001 0.001 0.001 0.00 0.001 Actual 0.00'[ 000[ 5031.321 8599.54 3126.321 7959.681 Funds Available -5031.32 -8599.54 , -3126 32 -7959.68 86.60 -10682.91 0.00 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Attachment H GRANT CLOSEOUT RECONCILICATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 CONTRACT/EAIWORKPLAN START DATE PROGRAM INCOME START DATE Page 1 of 2 YEAR OF FUNDS PY16 TITLE/PROGRAM/PROJECT WIOA ADULT LOCAL ADMIN CLEAR Program code 4A66000000 7/1/2016 END DATE END DATE 6/30/2018 I. CASH REQUEST. 1. Total program and Admin Cash needs Preciously Reported a ... 2. Current Program and Admin Cash Needs 4,881.00 3. FINAL Program and Admin Cash Needs Contract to Date 4,881.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 4,811.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 4,811.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 A I' )�r .0 ; 1. Total Program Income Expenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION '�: � ° � ;:II 1. FINAL Cash Request Contract to Date 4,881.00 2. FINAL Expenses Through End of Contract 4,811.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 W. RECONCILIATION ,AVINAAAAA AAA, AAQ�w 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 WI. MATCH RECONCILIATION dj.E� Le 1. FINAL Match Reported Through End of Contract 2. FINAL Expenses Through End of Contract 4,811.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 Signatu/e,;Ve, / Date 9/ 1// fO �// gam -C-� Authorized Signature �.,—e-- d' `2",'1�^Z DateSEP 12 2018 See instruction for completing this for on the next tab (Attachment H 2 of 2) CLEAR WIOA Reconciliation -Adult Administration Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance June -17 4A6600000 4,881.00 July -17 4A6600000 4,881.00 4,881.00 4,881.00 8/21/17 0.00 August -17 4A6600000 0.00 September -17 4A6600000 0.00 October -17 4A6600000 0.00 November -17 4A6600000 0.00 December -17 4A6600000 0.00 December B-17 4A6600000 0.00 January -18 4A6600000 0.00 February -18 4A6600000 0.00 March -18 4A6600000 0.00 April -18 4A6600000 0.00 May -18 4A6600000 0.00 June -18 4A6600000 0.00 July -18 4A6600000 0.00 Totals 4,881.00 4,881.00 4,881.00 4A6600000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Account 5230.0000.6500.4A66000000. 0000.00000000( Funds Available ( Detail Balances ) Period Mar -16 Apr -16 May -16 Jun -16 Adj-16 lJul-16 ',Aug -16 Sep -16 10ct-16 Nov-16 Period Balances (PJTD) -Aug-18 Budget Encumbrance 0.00 0.001 0.001 0.00E 0.00 0.00 0.00 I 000' 0.00 o.00l 0.00,1 0 00l 0.001 o.00 j Actual Funds Available 0.001,1, _ 0.00 0.00 0 00,hi'i''. 0.001 0.00 0.00 0.001 0.001 0 o0 o. oo r 0.001 4881.00 000 0.00 4881 00 7� 0.00 000 0.00 :` 0.00' MOM Account 15230.0000.6500.4A66000000.0000.00000000C Period Dec -16 ,[Jan -17 Feb -17 (lMa r-17 Funds Available ( Detail Balances ) Budget 0.00 Apr -17 May -17 Jun -17 Adj-17 Jul -17µ 917x: 0 001 o.aa'[ 0 00'. 0.00 l 0.001 0.00 0.00 0.00 0.00 001 Encumbrance 0.00 0.001 0.00 0.00'y 0.00,E 0.00' 0oo 0.00'1 .00, Actual 0.001 Funds Available 0.00 o.00l 0.00 0-00 0 00 000 0.00 000; 0.00 0.00; 0.00 0.001 0.00 0.00i 0.00? 4881.00! -4881.00 0.00 000W'' 0.001 488100,1 0.00 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT GRANT CLOSEOUT RECONCILICATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 CONTRACT/EA/WORKPLAN START DATE PROGRAM INCOME START DATE YEAR OF FUNDS PY16 Attachment H Page 1 of 2 TITLE/PROGRAM/PROJECT WIOA ADULT LOCAL PROGRAM CLEAR Program code 4A86000000 7/1/2016 END DATE END DATE 6/30/2018 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 2. Current Program and Admin Cash Needs 43,934.00 3. FINAL Program and Admin Cash Needs Contract to Date 43,934.00 I1. PROGRAM EXPENSE REPORT (ER) IrR(. 1. Total Expenses+Accruals Previously Reported (Through Last Month) 43,934.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 43,934.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 Expenses 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 43,934.00 2. FINAL Expenses Through End of Contract 43,934.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. RECONCILIATIONF_.. 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 VII. MATCH RECONCILIATION r....... r'.t .... 1. FINAL Match Reported Through End of Contract 2. FINAL Expenses Through End of Contract 43,934.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 Signatureyv / Date 7/L/ kg Authorized Signature ? +-lam Date £P 12 2018 See instruction for completing this for on the next tab (Attachment H 2 of 2) a20/8'a‘ CLEAR WIOA Reconciliation -Adult Program Reporting Month Program Code Tracking Sheet - Program CLEAR Received Date Received Grant Balance July -16 4A8600000 43,934.00 March -17 4A8600000 4,073.50 4,073.50 4,073.50 5/11/2017 39,860.50 April -17 4A8600000 27,479.29 27,479.29 27,479.29 5/23/2017 12,381.21 May -17 4A8600000 12, 381.21 June -17 4A8600000 12,381.21 July -17 4A8600000 12,381.21 August -17 4A8600000 12,381.21 September -17 4A8600000 12,381.21 October -17 4A8600000 12,381.21 November -17 4A8600000 12,381.21 December -17 4A8600000 12,381.21 December B-17 4A8600000 12,381.21 January -18 4A8600000 12,381.21 February -18 4A8600000 12,381.21 March -18 4A8600000 12,381.21 April -18 4A8600000 12,381.21 May -18 4A8600000 12,381.21 June -18 4A8600000 12,381.21 July -18 4A8600000 12,381.21 Totals 31,552.79 31,552.79 31,552.79 4A8600000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 CLEAR WIOA Reconciliation -Adult Training Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance April -17 4A8600000 9,867.35 9,867.35 9,867.35 5/23/2017 (9,867.35) May -17 4A8600000 2,513.86 2,513.86 2,513.86 6/26/2017 (12,381.21) June -17 4A8600000 (12,381.21) July -17 4A8 600000 (12, 381.21) August -17 4A8600000 (12, 381.21) September -17 4A8600000 (12,381.21) October -17 4A8600000 (12,381.21) November -17 4A8600000 (12,381.21) December -17 4A8600000 (12,381.21) December B-17 4A8600000 (12,381.21) January -18 4A8600000 (12,381.21) February -18 4A8600000 (12,381.21) March -18 4A8600000 (12,381.21) April -18 4A8600000 (12,381.21) May -18 4A8600000 (12,381.21) June -18 4A8600000 (12,381.21) July -18 4A8 600000 (12,381.21) Totals 12,381.21 12,381.21 12,381.21 4A8 600000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Period Summary test Account Selection Criteria Ledger 1CDLE Ledger Budget 15230 WELD 15 Period Aug -18 15230.0000.6500.4A86000000.0000. I5230.0000.65o0.4A86000000 0000: s 15230.0000.6500.4A86000000.0000. PJTD) - Aug 18 Amount Type Project To Date Encumbrance Type ALL Account Level All Budget Encumbrance 43934 00 r;' 0:001 0.00i 0.00i 0 001 001 Account 15230.0000.6500.4A86000000.0000.00000000( Funds Available ( Detail Balances ) Period Budget Jul -16 43934.00 Aug -16 0.001 {Sep -16 d 0.001 iOct-16� (Nov -16 Period Balances (PJTD) - Aug -18 0.001 0.00 0.001 0.001 0.001 0.001 0.00? 43934.00 Encumbrance 0.00 0.001 0.00 0.00„ 0.00 0.00 0.001 0.00 eEl13 Actual 31552.79, 1 0.00'1 12381.211 0.001 4073.501 27479.29i 31552.79 ...._ Funds Available 12381.21'. 0 00'. -12381.21 Funds Available 43934.00 0.00� 000 0.00 0.00 0.00 .'. -4073.50 -27479.29 1.2381 21 Account 5230.0000.6500.4A88000000.0000.00000000f Funds Available ( Detail Balances ) ;1Apr-17 May -17 11Jun-17 '1Ad}-17 UyN Jul -17 Aug -17 v Sep -17 .Oct -17 Budget 0.00 0.00! 0001 0.001 Encumbrance 0.00 o oOT:. a_v 0.001 0 00 0001 000 0.001 0.00I b-:00 0 o0I 0.001 o.ao o.00l 0.00: 0.001 0.001.' Actual Funds Available 0.00 0.00 0.001 0.00, 0001 aoo l 0.00 0.00 000, 0.001 0.00 0.00; 0.00 .' -251386 000 0.00 2381.21 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Attachment H GRANT CLOSEOUT RECONCILICATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 CONTRACT/EA/WORKPLAN START DATE PROGRAM INCOME START DATE Page 1 of 2 YEAR OF FUNDS FY17 TITLE/PROGRAM/PROJECT WIOA DW-LOCAL/COUNTIES ADMIN T CLEAR Program code 4BD6000000 7/1/2016 END DATE END DATE 6/30/2018 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 Wys , 15,000.00 15,000.00 II. PROGRAM EXPENSE REPORT (ER) �(,�T�� " ��r�n trim N M a � ua 1. Total Expenses+Accruals Previously Reported (Through Last Month) 15,000.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 15,000.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 0.00 III. PROGRAM INCOME(PI) EXPENSE REPORT I 1. Total Program Income Expenses 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 15,000.00 2. FINAL Expenses Through End of Contract 15,000.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes ID /No ❑ V CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 VI. RECONCILIATION", 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 VII. MATCH RECONCILIATION 1. FINAL Match Reported Through End of Contract 2. FINAL Expenses Through End of Contract 15,000.00 3. Match Percentage of Expenditure Contracttual Requirement 0.00 4. Match Expenditure Requirement 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) 0.00 Yes O /No ❑ *The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signature Date q1/470 Authorized Signature °—C rkl--0^.."'z'' Date SEP 1 2 2018 See instruction for completing this for on the next tab (Attachment H 2 of 2) 9.0 "1/v CLEAR WIOA Reconciliation -Adult Administration Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance June -17 4BD600000 15,000.00 July -17 4BD600000 15,000.00 August -17 4BD600000 15,000.00 September -17 4BD600000 15,000.00 October -17 4BD600000 4,017.99 4,017.99 4,017.99 11/27/17 10,982.01 November -17 4BD600000 4,462.73 4,462.73 4,462.73 12/21/17 6,519.28 December -17 4BD600000 3,590.22 3,590.22 3,590.22 2/1/18 2,929.06 December B-17 4BD600000 2,929.06 2,929.06 January -18 4BD600000 2,929.06 2,929.06 2/27/18 0.00 February -18 4BD600000 0.00 March -18 4BD600000 0.00 April -18 4BD600000 0.00 May -18 4BD600000 0.00 June -18 4BD600000 0.00 July -18 4BD600000 0.00 Totals 15,000.00 15,000.00 15,000.00 4BD600000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 ()Period Balances (PJTD) - Ad) -18 Account 152-3-0.0000.6500.4806000000.0000.00000000 Period ct-16 Funds Available ( Detail Balances ) Budget Encumbrance 15000.00 0.00 Nov -16 Dec -16 Jan -17 Feb -17 µ 4 .Mar -17 Apr -17 [May -17 '1Jun-17 Adj-17 0.000.00 0.001 0.00 .1 0.001 0.001 0.00 0.001 0.001 0.001 0.001 0.00 l 0.00,_ 0.001 0.00 0.001 5000.00! 0.00'1 0.00 Actual 0001 0.00 0.001 0.00: 0.00 0.00,1 0001 0001 0.001 5000.00:1 0.00` Funds Available 15000.00 0.00 000 0.00 • 0.00 0µ00 • 0 00 0.00 0.00 0.00', cp Period Balances (PJTD) - Adj-18 Account $5230.0000.6500.4BD6000000.0000.000000001 Period [Oct -17 ,Nov -17 Dec -17 Jan -18 Feb -18 Mar -18 1Apr-18 Funds Available ( Detail Balances ) Budget Encumbrance Actual 0.00',I 0.001 0001 0.001 0.00` N 0.00; 0.00. 4017.99' 0.00; 0.00_ 4462.73• 1: 0.001 0.001 3590.22 ' 0.001 2929.06'0.00f Q 00 i' 10.00 0.00 0.00 0.001 0.00 0.001 15000.00: 0.001` -4017.99 -4462.73 -3590.22 -2929.06:0 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Attachment H GRANT CLOSEOUT RECONCILICATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 CONTRACT/EA/WORKPLAN START DATE PROGRAM INCOME START DATE Page 1 of 2 YEAR OF FUNDS PY16 TITLE/PROGRAM/PROJECT WIOA DW LOCAL ADMIN CLEAR Program code 4D66000000 7/1/2016 END DATE END DATE 6/30/2018 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 7,462.00 7,462.00 II. PROGRAM EXPENSE REPORT (ER) ,„ i m ° X t i' rAtav L.,. 1. Total Expenses+Accruals Previously Reported (Through Last Month) 7,462.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 7,462,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 Expenses 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 q4�^'? 1. FINAL Cash Request Contract to Date 7,462.00 2. FINAL Expenses Through End of Contract 7,462.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 7 IIL"i ih� 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 W. RECONCILIATION ` 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 VII. MATCH RECONCILIATION 1. FINAL Match Reported Through End of Contract 2. FINAL Expenses Through End of Contract 7,462.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 "XV �f Date /) `(J1$ Authorized Signature Qom,,, —E! . ' SEP 12 2018 Date See instruction for completing this for on the next tab (Attachment H 2 of 2) a2D/t z89° a7 CLEAR WIOA Reconciliation -Dislocated Worker Administration Reporting Month (Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance June -17 4D6600000 7,462.00 July -17 4D6600000 2,074.14 2,074.14 2,074.14 8/21/17 5,387.86 August -17 4D6600000 4,046.27 4,046.27 4,046.27 9/25/17 1,341.59 September -17 4D6600000 1,341.59 1,341.59 1,341.59 10/20/17 0.00 October -17 4D6600000 0.00 November -17 4D6600000 0.00 December -17 4D6600000 0.00 December B-17 4D6600000 0.00 January -18 4D6600000 0.00 February -18 4D6600000 0.00 March -18 4D6600000 0.00 April -18 4D6600000 0.00 May -18 4D6600000 0.00 June -18 4D6600000 0.00 July -18 4D6600000 0.00 Totals 7,462.00 7,462.00 7,462.00 4D6600000 General ledger vs Willed 0.00 Billed not received I 0.00 General ledger vs. received 0.00 0 Period Bahr es (PJTD) - Adj 1 Account l5230.0000.6500.4066000000.0000.00000000( 0.0000.00000000( Funds Available ( Detail Balances ) Period' Sep -16 1©ct-16 1Nov-16 µ =Dec -16 €Jan-17Mrom ,Feb 17 Budget Encumbrance Actual 7462.061' 0 001 0.00 0 0Q( 0 00�... 0.00 e . l 0.00.; 0.0(il 0.001 0.00„ 0.00,E ooa 0.00 0.00,E 7462.00 Account =5230.0000.6500.4D66000000.0000.00000000( Period Jun -17 Adt-17 Jul -17 lAug-17 ,Sep -17 Oct17 Nov=17 'Jan -18 Funds Available ( Detail Balances ) 0.00; 000 0.00 0.001 0.00 # 0. 0.00177-000,1 00 - 0.003 Budget Enc umbrance 0.001 0.00i0.00 0.00 0.00 0.00. 0.QQ 7462. Funds Available 7462.00 O. 0.001111 0.00. 000* 0.00 000 0.00° Actual Funds Available 0.00 l 000 000 0.0014141 2074.14_ -207414..,; 4046 27 l -4046 27 r.e. 1341.591 134 me 0.00 0.0a11„�-3 0.00 I .,.. Toot 0.00'1 0.00i 0.00,€ 0.001 7462.001 0.00 0.00 g° COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Attachment H GRANT CLOSEOUT RECONCILICATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 CONTRACT/EA/WORKPLAN START DATE PROGRAM INCOME START DATE Page 1 of 2 YEAR OF FUNDS PY16 TITLE/PROGRAM/PROJECT WIOA DW LOCAL PROGRAM CLEAR Program code 4D86000000 7/1/2016 END DATE END DATE 6/30/2018 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported idi' 2. Current Program and Admin Cash Needs 67,159.00 3. FINAL Program and Admin Cash Needs Contract to Date 67,159.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 67,159.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 67,159.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 Expenses 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 ilik�- . I µ ,.,, 1. FINAL Cash Request Contract to Date 67,159.00 2. FINAL Expenses Through End of Contract 67,159.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 %V IE) n :9 . .._ 1. FINAL Match Reported Through End of Contract 2. FINAL Expenses Through End of Contract 67,159.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 ."—. r Date 7�y�1 g Authorized Signature t -k 7'4_0,SEP "L2�� Date 1 2 2018 See instruction for completing this for on the next tab (Attachment H 2 of 2) otoa-02890 Oz8 CLEAR WIOA Reconciliation -Dislocated Worker Program Reporting Month (Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance June -17 4D8600000 67,159.00 July -17 4D8600000 67,159.00 67,159.00 67,159.00 8/21/17 0.00 August -17 4D8600000 0.00 September -17 4D8600000 0.00 October -17 4D8600000 0.00 November -17 4D8600000 0.00 December -17 4D8600000 0.00 December B-17 4D8600000 0.00 January -18 4D8600000 0.00 February -18 4D8600000 0.00 March -18 4D8600000 0.00 April -18 4D8600000 0.00 May -18 4D8600000 0.00 June -18 4D8600000 0.00 July -18 4D8600000 0.00 Totals 67,159.00 67,159.00 67,159.00 4D8600000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 o Period Balances (PJTD) - Ad} -18 Account 15230.0400.6500.4D86000000.0000.00000000(, Period 1 Er Aug -16 Sep 16 poet -16 Nov -16 Dec -16 ,Jan 17 ._. Feb -17 j Oar -17 jApr-17 D Period Balances (PJTD) - Adj-18 Funds Available ( Detail Balances ) Budget 67159.001 000E 0.001m.. 0.00 0000 0.00 0.00 0.00 ( 0.001 0.00 0.00i Encumbrance 0.00 0.00 0.001 0 00' 0.001 0.005 000 67159.001 ......... 0.001, Account 15230 0000.6500 4086000000 0000.000000000 Period tvlay-1 jNov-17 Dec -17 Jan -18 Funds Available ( Detail Balances ) Budget Encumbrance 0:00+ 01 0, 0.00 0.00,1 0001 0.001 0.00 0.00 0.001 0.001�y0 0.0-0 e.�m 0.66! 0.001 0.00 67159.00',] 0.00 Actual 0001 0.001 0.001 000, o.00'Wr 0.00] ..: 0 oo[' 0.001 0.00 4 67159 00! Actual 0.001 0.001 0.0o 1 0.00 0 EY 000, 0.00 rn67159 00° Funds Available 67159.00 -11- 0 00 000 0.00 0.00 0.00 ,! 0.00 000; 0.00 0.00 0.00 -67159.00 0.00 000,, ,.,.,. 0.00�w.. 0.00. 0.00 0.00 0.00' COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Attachment H GRANT CLOSEOUT RECONCILICATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 CONTRACT/EA/WORKPLAN START DATE PROGRAM INCOME START DATE Page 1 of 2 YEAR OF FUNDS PY16 TITLE/PROGRAM/PROJECT WIA CWDC 10% DW COUNCIL CLEAR Program code 4DW6000000 3/1/2017 END DATE END DATE 6/30/2018 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported ^r;; . �� tt l ,._. 2. Current Program and Admin Cash Needs 15,750.00 3. FINAL Program and Admin Cash Needs Contract to Date 15,750.00 11. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 15,750.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 15,750.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 �o o b` 1. Total Program Income Expenses 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 bb 'Abo!bb 1. FINAL Cash Request Contract to Date 15,750.00 2. FINAL Expenses Through End of Contract 15,750.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes LI /No ❑ V CASH REQUEST PROGRAM INCOME CASH REPORTED d ii, X,04, o 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 VI. RECONCILIATION.,, a w 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 WI. MATCH RECONCILIATION 1. FINAL Match Reported Through End of Contract 2. FINAL Expenses Through End of Contract 15,750.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.G7 7 Date i/ h /16 ,,,,,,47 Authorized Signature -6.- / / -C71-- tf Date SEP 12 2018 See instruction for completing this for on the next tab (Attachment H 2 of 2) ot0l8 - 01890 i9 CLEAR WIOA Reconciliation -10% Funds -Local Planning Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance April -17 4DW600000 15,750.00 July -17 4DW600000 15,750.00 August -17 4DW600000 750.00 750.00 750.00 9/25/17 15,000.00 September -17 4DW600000 15,000.00 October -17 4DW600000 1,382.10 1,382.10 1,382.10 11/27/17 13,617.90 November -17 4DW600000 1,026.14 1,026.14 1,026.14 12/21/17 12,591.76 December -17 4DW600000 6,124.54 6,124.54 6,124.54 2/1/18 6,467.22 December B-17 4DW600000 6,467.22 6,467.22 6,467.22 2/27/18 0.00 January -18 4DW600000 0.00 February -18 4DW600000 0.00 March -18 4DW600000 0.00 April -18 4DW600000 0.00 May -18 4DW600000 0.00 June -18 4DW600000 0.00 July -18 4DW600000 0.00 Totals 15,750.00 15,750.00 15,750.00 4DW600000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 PITO) Account 1523Q_0000.6500.4D—W6000000.0000.0000000(' Funds Available ( Detail Balances ) Budget 15750 001 Period lMay-17 IlJun-17 l'Ad}-17 ,Jul -17 ug-17 1Sep-17 tiOct-17 lNov-17 €;Dec -17 Glances 1PJTO) - Adj-t8 • 0.001 0.0Q M 0.00, 0.001 0.00= 0.001 _r 0.00' 0.00 Encumbrance 0.00 0.00!I 000 000 oa; 0.Q0i 0OO1,_...u.::750.00 0.001 0.00:1 15750.001 O 00� Account 5230:0000.6500.4DW6000000.0000.0000000( 11 Period ;Feb -18 Mar 18 { 1Apr-18 ;May -18 Funds Available ( Detail Balances ) Budget 0 00l. Q.• 00'l 0.001 0.00• 0.1001i • 0.00 15750.00r 1382.101 1026.14; 6124 54!1 15750.001 Actual Funds Available 0.001 1575Q00 T;, 00011 0.00111, 000 0.0011111 -111 -750.001111 0.00111' 0.00. Encumbrance Actual Funds Available .0.001.1 00 ' 1382.11q1 -.-•1382.10i1 026:141 -102614 "_ 6124.54'. 0.00 6467.22 0.001._ .. 0.00'; 000, 000;1 000; 0 QOM.... 0001 000j''6aorYf 0.00 0.001 0.00 -0.401 05750.00f 0.00- 124.54 467.22 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Attachment H GRANT CLOSEOUT RECONCILICATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 CONTRACT/EA/WORKPLAN START DATE PROGRAM INCOME START DATE Page 1 of 2 YEAR OF FUNDS FY16 TITLE/PROGRAM/PROJECT WIOA 25% DW ENHANCED ADMIN TO CLEAR Program code 4ED5000000 4/1/2017 END DATE END DATE 6/30/2018 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 2. Current Program and Admin Cash Needs 5,122.00 3. FINAL Program and Admin Cash Needs Contract to Date 5,122.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 5,122.00 2. Current Expenses + Accruals (Through End Date of Award) 3, FINAL Program Expenses Contract to Date 5,122.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 Expenses 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 5,122.00 2. FINAL Expenses Through End of Contract 5,122.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes O /No ❑ V. CASH REQUEST PROGRAM INCOME CASH REPORTED I u ` 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 W. RECONCILIATION 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 VII. MATCH RECONCILIATION d iI 1. FINAL Match Reported Through End of Contract 2. FINAL Expenses Through End of Contract 5,122.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 Al" �r Date tclg Authorized Signature Pr ----- 0'1"---C-6'. ,e,,,--e---,e,,,--e---��' "�0"" � DateSEP 12 2018 See instruction for completing this for on the next tab (Attachment H 2 of 2) CLEAR W/OA Reconciliation -25°o EDW Work Based Learning Administration Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance October -15 4ED500000 5,122.00 March -16 4ED500000 5,122.00 5,122.00 5,122.00 6/21/2016 0.00 July -17 4ED500000 0.00 August -17 4ED500000 0.00 September -17 4ED500000 0.00 October -17 4ED500000 0.00 November -17 4ED500000 0.00 December -17 4ED500000 0.00 December B-17 4ED500000 0.00 January -18 4ED500000 0.00 February -18 4ED500000 0.00 March -18 4ED500000 0.00 April -18 4ED500000 0.00 May -18 4ED500000 0.00 June -18 4ED500000 0.00 July -18 4ED500000 0.00 Totals 5,122.00 5,122.00 5,122.00 4ED500000 General ledger vs bullied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 ** Original budget of $7,995.00 decreased by $2,873.00 on 4/2017 for an ending budget of $5,122.00. CLEAR WIOA Reconciliation -25% Enhanced DW Admininistration Reporting Month Program Code Tracking Sheet CLEAR Adjustment to the Budget Received Date Received Grant Balance October -15 4ED500000 7,995.00 March -16 4ED500000 5,122.00 5,122.00 5,122.00 6/21/16 2,873.00 April -17 4ED500000 2,873.00 0.00 July -17 4ED500000 0.00 August -17 4ED500000 0.00 September -17 4ED500000 0.00 October -17 4ED500000 0.00 November -17 4ED500000 0.00 December -17 4ED500000 0.00 December B-17 4ED500000 0.00 January -18 4ED500000 0.00 February -18 4ED500000 0.00 March -18 4ED500000 0.00 April -18 4ED500000 0.00 May -18 4ED500000 0.00 June -18 4ED500000 0.00 July -18 4ED500000 0.00 Totals 5,122.00 5,122.00 2,873.00 5,122.00 4ED500000 General ledger vs billied 0.00 Billed not received 1 0.00 General ledger vs. received 0.00 odBalances (PJTD) - Adj-19 Account Period Oct -15 £.Dec -15 iJan-16 Adj-i8 5230.0000.6500.4 E D 5000000.0000.0000000€ i Funds Available ( Detail Balances ) Budget 7995.001i 0.001 0.001 0.00 0.0011 0.001 0001 0.001 • 0,001 0.00'1 .0.00? 0.00( 0.00!I 0.001 0 Period Oalances (PJTC3)- Aclj-°l£3 Account Period • 1Ju1-16 • 1Aug-16 Sep -16 i0ct-16 Nov -16 'lDec 16 an -17 lApr-17 5230.0000.6500.4ED5000000.0000.00000001 Funds Available ( Detail Balances ) Encumbrance Actual ve 0.(30°�.. ._ _.,.4. �._ m.. 0.00 Funds Available 7995.00 0.00'! Q 00' 0.00 000 0 00 5122..00£ -5122 00 _J 000'I 000 0001 000~4 0.00, 2.00: 0.00; 0.00 Budget Encumbrance Actual Funds Available 0.001 Q.00, 0 00' ....0 001 0001 0.00;1 0.00 0. 0.001 0.001 0.0QI 0.00,1 0 001 0:00 0.00 0 0.001 0.00 0.0011 0.001 -2873.00x 0. ) 1 5922 004 0.00',.1 0.00.1 0.00 �a 0.00 0.0 0.00 0.00 0. —2873.001.;; 5122.001 0.001 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Attachment H GRANT CLOSEOUT RECONCILICATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 CONTRACT/EA/WORKPLAN START DATE PROGRAM INCOME START DATE Page 1 of 2 YEAR OF FUNDS FFY16 TITLE/PROGRAM/PROJECT WIOA - 25% DW ENHANCED PROGRA CLEAR Program code 4FD5000000 7/1/2015 END DATE END DATE 6/30/2018 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported „, e )i 2. Current Program and Admin Cash Needs 74,841.00 3. FINAL Program and Admin Cash Needs Contract to Date 74,841.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 74,841.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 74,841.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 Expenses 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 74,841.00 2. FINAL Expenses Through End of Contract 74,841.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 MOW 4 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 VI. RECONCILIATION 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 WI. MATCH RECONCILIATION 1. FINAL Match Reported Through End of Contract 2. FINAL Expenses Through End of Contract 74,841.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 l2 /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 q%,/) /J3 �' Authorized Signature A -re- / —1---e--1.--` f Date SEP 12 2018 See instruction for completing this for on the next tab (Attachment H 2 of 2) 00/8-alf9 3/ CLEAR WIOA Reconciliation -25% EDW Work Based Learning Program Reporting Month Program Code Tracking Sheet CLEAR Received Date Received Grant Balance October -15 4FD500000 74,841.00 November -16 4FD500000 16,658.80 16,658.80 16,658.80 12/31/2016 58,182.20 December -16 4FD500000 8,492.04 8,492.04 8,492.04 12/31/2016 49,690.16 December -16 B 4FD500000 3,228.33 3,228.33 4/4/2017 49,690.16 January -17 4FD500000 (1,436.52) (1,436.52) 4/4/2017 49,690.16 February -17 4FD500000 (70.75) 1,721.06 (70.75) 4/4/2017 47,969.10 March -17 4FD500000 47,969.10 April -17 4FD500000 19,230.10 19,230.10 19,230.10 5/23/2017 28,739.00 May -17 4FD500000 28,739.00 June -17 4FD500000 28,739.00 July -17 4FD500000 28,739.00 August -17 4FD500000 28,739.00 September -17 4FD500000 28,739.00 October -17 4FD500000 28,739.00 November -17 4FD500000 28,739.00 December -17 4FD500000 1,963.84 1,963.84 1,963.84 2/1/2018 26,775.16 December B-17 4FD500000 26,775.16 January -18 4FD500000 1,194.08 1,194.08 1,194.08 2/27/2018 25,581.08 February -18 4FD500000 5,223.50 5,223.50 5,223.50 5/29/2018 20,357.58 March -18 4FD500000 3,655.61 3,655.61 3,655.61 5/29/2018 16,701.97 April -18 4FD500000 1,294.20 1,294.20 1,294.20 5/29/2018 15,407.77 May -18 4FD500000 10,099.46 10,099.46 10,099.46 7/13/2018 5,308.31 June -18 4FD500000 5,308.31 5,308.31 5,308.31 8/2/2018 0.00 July -18 4FD500000 0.00 Totals 74,841.00 74,841.00 74,841.00 4FD500000 General ledger vs billied 0.00 Billed not received 1 0.00 General ledger vs. received 0.00 ** Original budget of $71,968.00 increased by $2,873.00 on 4/2017 for an ending budget of $74,841.00. es (t 33D) Add -18 Account 15230.0000.6500.4F05000000.0000.0000000 4 Funds Available ( Detail Balances ) Period ;Nov -15 1Dec- Jan•16 Feb 16 Mar -1 r.._., lApr 16 May 16 Jun 16 Budget Encumbrance Actual 71968.001 74 (PJTD) - Adj-$8 0 003 iF 0.00,1 0. 0 . 0 00{ 0.t 0. 0.001 0. 41.00; Account 15230.0000.8r500.4F05000000.0000.000000004 Period Jul 16 Aug16 Sep -16 • i0ct-16_ Nov -16. Dec -16 [Jan17 Feb -17 Mar417 • 1Apr-:17 Funds Available ( Detail Balances ) Budget 0001 0.001 O 001 0.001 0.00-j 0.00i 0.001_m 0001 flag 0.001 �_., 0 QQ 0.001 0.001 0.001 0.001 000' 0.00i 74841.00 0.001 • 0.00„ a00� aO1• O. 000,1 • 0.001 6.00A aooi 0.001 0.001 0.00'1 0oa 0.001 0.001 ao0;. 2873 001 m. 0.aa_E `a 74841.00_ - Funds Available 71968 00 -", 0.00'1'1 0.00 0.00 0.00 0 00 000'. 0.00 Actual Funds Available 0.00 0 0.001:1 0.0011Q 0.001 0.00:0A 8492 04; 0.00 1721 06# 0.001 . 19230.10 0.001 • 74841.00'1 0 -16658.80 -8492.04 0 00,...: -1721.06 000 57.10 0.00 o Period Balances (PJTD) - Adj-1 Account 5230:0000:6500.4 FD5000000.0000.000000001 Funds Available ( Detail Balances ) Budget Period I May -17 IJun-17... Adj-17 Jul -17 Aug -17 Sep -17 (act -17W m, jNov-17 Dec -17 P;JTD)-Adj-18 0.00! 0.00 0.001 .. 0.001 0.001 0.00;: o.00rµ 0.00 0.00'1 Encumbrance Account 5230.0000.6500.4FD5000000.0000.00000000( Funds Available ( Detail Balances ) Period ' loct-17 Nov -17 !Dec -17 jJan-18 Feb -18 [Mar -18 Apr -18 (May -18 1Jun-18 iAdj-18 Budget 0.00 0.00; 0.00' 0.00} 0.00( 0.001 o oo' 0.00 0O0' 74841.00! Q 00. 0.00'' 0.00 ' 0.00 0_001 0 00. 000: 0.00' 0.00; Actual Funds Available 0.00 0.00 0.00 0.00 000' 0.001 0.00 0.001 0001 0.00 0.00 . �0 . .e.. 0.00 = 0.00 ° 0.00 0.00 0.00 ' 196384 1194.08! 0.00 Encumbrance 0.00. 0.001 0.001 0.001 0.00j 0.001 0.001 0.00 0.00, -1963 84 -1194.08 Actual Funds Available 0 00 ... 0.00 000: 1963.84 -1963.84 1194.08} -1194.08 5223 501 3655 61', 1294/0 10099.461 5308 31 000 74841.00, 000 -3655.61 -1294.20 -10099.46 0.00 0.00 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Attachment H GRANT CLOSEOUT RECONCILICATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 CONTRACT/EAIWORKPLAN START DATE PROGRAM INCOME START DATE Page 1 of 2 YEAR OF FUNDS FY15 TITLE/PROGRAM/PROJECT WIOA-5%-$165,000 WFD TECH ASSTS" CLEAR Program code 4GD5000000 10/1/2017 END DATE END DATE 6/30/2018 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 2. Current Program and Admin Cash Needs 22,000.00 3. FINAL Program and Admin Cash Needs Contract to Date 22,000.00 II. PROGRAM EXPENSE REPORT (ER) ., „ 1. Total Expenses+Accruals Previously Reported (Through Last Month) 22,000,00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 22,000.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 0.00 III. PROGRAM INCOME(PI) EXPENSE REPORT 1. Total Program Income Expenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV RECONCILICATION A 1. FINAL Cash Request Contract to Date 22,000.00 2. FINAL Expenses Through End of Contract 22,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 L�. i�? 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 W RECONCILIATION 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 VIL MATCH RECONCILIATION 1. FINAL Match Reported Through End of Contract 2. FINAL Expenses Through End of Contract 22,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 E /No LI *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 r -1,,,V Date /Ma Authorized Signature Date SEP 1 2 2018 See instruction for completing this for on the next tab (Attachment H 2 of 2) doe- Ag9.0 32- CLEAR WIOA Reconciliation -Youth Work Based Learning Direct Services Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance June -17 4GD500000 0.00 July -17 4G D500000 0.00 August -17 4G D500000 0.00 September -17 4GD500000 22,000.00 October -17 4GD500000 22,000.00 November -17 4GD500000 22,000.00 December -17 4GD500000 22,000.00 December B-17 4GD500000 196.35 22,000.00 January -18 4GD500000 196.35 196.35 2/27/18 21,803.65 February -18 4GD500000 21,803.65 March -18 4GD500000 2,074.10 2,074.10 2,074.10 5/29/18 19,729.55 April -18 4GD500000 3,859.56 3,859.56 3,859.56 5/29/18 15,869.99 May -18 4GD500000 3,041.54 3,041.54 3,041.54 7/13/18 12,828.45 June -18 4GD500000 12,828.45 12,828.45 12,828.45 8/2/18 0.00 July -18 4GD500000 0.00 Totals 22,000.00 22,000.00 22,000.00 4GD500000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 0 Pe€red Balances (RIM) - Ad; -18 Account (5230.0000.6500.4605000000.0000.00000000 Funds Available ( Detail Balances ) Period sSep-17 ?Oct -17 sNov-17.._. 1Dec-17 Jan -18 Feb -18 ;Mar-1_�. 8 Budget 22000.00! 0.00 I _.. 0.00 0.001 Encumbrance 0.00' 0.001 000: Q 40.. 0.00; 0.001 0.001 Actual Funds Available 0 00 22000 00 0001 000 0.001 0.00 0.00: 196.35. 0.001 2074.101 3859.56? 3041 54, 12828 45`°, 22000.00' 0.00 -196.35 0.00 • -2074.10' -3859.56 -3041.54 -12828.4 :" 0.00 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Attachment H GRANT CLOSEOUT RECONCILICATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 CONTRACT/EAIWORKPLAN START DATE PROGRAM INCOME START DATE Page 1 of 2 YEAR OF FUNDS FY16 TITLE/PROGRAM/PROJECT WIOA 25% DW-WIOA TRANSITIONAL CLEAR Program code 41D5000000 4/1/2017 END DATE END DATE 6/30/2018 1. 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 (G. .. ...,' 5,109.00 5,109.00 11. PROGRAM EXPENSE REPORT (ER) „"\r PiDNERSOI 1. Total Expenses+Accruals Previously Reported (Through Last Month) 5,109.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 5,109.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 ( i. „ G t 1. Total Program Income Expenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION a (Tr aVky ,M , 1. FINAL Cash Request Contract to Date 5,109.00 2. FINAL Expenses Through End of Contract 5,109.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 W. RECONCILIATION 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 VII. MATCH RECONCILIATION s � � ( firIl 1. FINAL Match Reported Through End of Contract 2. FINAL Expenses Through End of Contract 5,109.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 El /No ❑ 'The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signature ? Date `/ J1 t Authorized Signature l 2� / —c7``P-- -,..-c-1 DatSEP 1 2 2015 See instruction for completing this for on the next tab (Attachment H 2 of 2) Ojoiy- ;S9° 05 CLEAR WIOA Reconciliation -25% DW Business Services Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance October -15 41D500000 5,109.00 July -17 41D500000 5,109.00 August -17 41D500000 5,109.00 September -17 41D500000 5,109.00 October -17 41D500000 5,109.00 November -17 41D500000 5,109.00 December -17 41D500000 5,109.00 December B-17 41D500000 5,109.00 January -18 41D500000 54.89 54.89 54.89 2/27/18 5,054.11 February -18 41D500000 5,054.11 March -18 41D500000 2,994.71 2,994.71 2,994.71 5/29/18 2,059.40 April -18 41D500000 2,059.40 2,059.40 2,059.40 5/29/18 0.00 May -18 41D500000 0.00 June -18 41D500000 0.00 July -18 41D500000 0.00 Totals 5,109.00 5,109.00 5,109.00 41D500000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 0 Period Balances (PJTD) - Adjr18 Account ;5230.0000.8500.41D5000000.0000.000000000 Funds Available ( Detail Balances ) Period 'Oct -15 Nov -15 Dec -15 tan -16m 1Feb-16 ]Mar -16 pr -16 May -16 'Jun -16 Adj-16 Budget 5109.00₹ 0.001 000'1 000' 0.00x_ 0.00] 0.00 0.00; a0'' Encumbrance Actual Funds Available 0.001 000 5109.00- 0M0 0.004 0.00f 0.00; 0001 0.00 0.001 0.00 Q0f1] 0.00 o.00'I 0 Period Balances (PJTD)-Ad;-18 e®M 0.00' 5109.00 0.00 Account Period O ;Nov -17 `Dec -17 Jan -18 1Feb-18 5230.0000.6500.41D5000000.0000.000000000 Funds Available ( Detail Balances ) Mar -18 Apr -18 1May-18 �. 1Jun-18 ;1Adj-18 Budget Encumbrance 0.00r 0.001 0.00( 000,.....::. 0.00I0.001 0-001 0.00; 0.001 ._. 0.001 0.00' 0.001 0,001 0.00'I, 0. 0001 O 00,� 0. 0.00 i 0.001 5109 00E 0.001 0.00 0.00 54891 0.001 2994 71 2059 401 0.00 �. 000 0.00 5109.001 Funds Available 0.00 000 0.00 -54.89 0.00 - 2994.71 - 2059.40: 0.00 0.00 ; 000•x, 0.00 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Attachment H GRANT CLOSEOUT RECONCILICATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 CONTRACT/EANVORKPLAN START DATE PROGRAM INCOME START DATE 9/18/2017 Page 1 of 2 YEAR OF FUNDS PY14 TITLE/PROGRAM/PROJECT WIOA TECHNICAL ASSIST TRAINING= CLEAR Program code • 4MT5000000 END DATE END DATE 10/17/2017 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 �� r ' l r �,,,, 8,000.00 8,000.00 II. PROGRAM EXPENSE REPORT (ER) „rM& a 1. Total Expenses+Accruals Previously Reported (Through Last Month) 8,000.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 8,000.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 0.00 III. PROGRAM INCOME(PI) EXPENSE REPORT 1. Total Program Income Expenses 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 ;! k t k 1 u°, Fs,h;ry 1. FINAL Cash Request Contract to Date 8,000.00 2. FINAL Expenses Through End of Contract 8,000.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 O(( AN0Y 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0,00 WI. MATCH RECONCILIATION 1. FINAL Match Reported Through End of Contract 2. FINAL Expenses Through End of Contract 8,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 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/0-)„,, Date /�jir$ Authorized Signature p " Le —Le. -1"L' DateSEp 1 2 ?um See instruction for completing this for on the next tab (Attachment H 2 of 2) XO4 -a,890 3s- CLEAR WIOA Reconciliation -Technical Assistance Reporting Month (Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance June -17 4MT500000 0.00 July -17 4MT500000 0.00 August -17 4MT500000 0.00 September -17 4MT500000 8,000.00 October -17 4MT500000 8,000.00 8,000.00 November -17 4MT500000 8,000.00 December -17 4MT500000 8,000.00 8,000.00 2/1/18 0.00 December B-17 4MT500000 0.00 January -18 4MT500000 0.00 February -18 4MT500000 0.00 March -18 4MT500000 0.00 April -18 4MT500000 0.00 May -18 4MT500000 0.00 June -18 4MT500000 0.00 July -18 4MT500000 0.00 Totals 8,000.00 8,000.00 8,000.00 4MT500000 General ledger vs bullied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Period Balances (PJTD) - Adj-18 Account W30.0000.6500.4MT5000000.0000 000000006', Funds Available ( Detail Balances ) Period Aug -17 iSep-17 Nov -17 IDec-17 Jan -18 1[Feb-18 [Mar -18 _. Apr -18 [May -18 Budget 0.00 8000.001 0.00'.1 000; 0.001 Encumbrance 0.00; 0.001 0.00 0.00 0.00] 0.00 0.001 0.00 0.001 .. __.. 0 t)0€ 8000.00', 0.001 0.00. Actual Funds Available 000 000 `r 0 00 0.001 _ 0.00 _ __ 0.00 8000.00; -8000.00. 0.00, 0.00 ''. 0.00 0.00 0.00 0.00: 0.00. 8000.00,1 0.00 0.00 0.00, 0.00 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Attachment H GRANT CLOSEOUT RECONCILICATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 CONTRACT/EAIWORKPLAN START DATE PROGRAM INCOME START DATE Page 1 of 2 YEAR OF FUNDS FY17 TITLE/PROGRAM/PROJECT WIOA DW-LOCAUCOUNTIES PROG TI CLEAR Program code 4ND6000000 7/1/2016 END DATE END DATE 6/30/2018 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 2. Current Program and Admin Cash Needs 135,000.00 3. FINAL Program and Admin Cash Needs Contract to Date 135,000.00 II. PROGRAM EXPENSE REPORT (ER) ,.`_ 1. Total Expenses+Accruals Previously Reported (Through Last Month) 135,000.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 135,000.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 0.00 III. PROGRAM INCOME(PI) EXPENSE REPORT i �i�i� 1(� s� 1. Total Program Income Expenses 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 �d t, 135,000.00 2. FINAL Expenses Through End of Contract 135,000,00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes 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 Tar ..�lti4�,u, 1. FINAL Match Reported Through End of Contract 2. FINAL Expenses Through End of Contract 135,000.00 3. Match Percentage of Expenditure Contracttual Requirement 0.00 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes O /No 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 Signature71ed: Date / / a Authorized Signature / �j ��z�� 2 1 SEP Date J 1 2 2018 See instruction for completing this for on the next tab (Attachment H 2 of 2) ao,8- .219O 36- CLEAR WIOA Reconciliation -Adult Program Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance May -17 4ND600000 135,000.00 June -17 4ND600000 22,211.98 22,211.98 112,788.02 July -17 4ND600000 (22,211.98) (22,211.98) 135,000.00 August -17 4ND600000 135,000.00 September -17 4ND600000 35,716.14 135,000.00 October -17 4ND600000 26,957.03 62,673.17 62,673.17 11/27/17 72,326.83 November -17 4ND600000 23,725.01 23,725.01 23,725.01 12/21/17 48,601.82 December -17 4ND600000 29.72 29.72 29.72 2/1/18 48,572.10 December -17 B 4ND600000 48,572.10 January -18 4ND600000 48,572.10 February -18 4ND600000 48,572.10 March -18 4ND600000 48,572.10 April -18 4ND600000 48,572.10 May -18 4ND600000 48,572.10 June -18 4ND600000 48,572.10 July -18 4ND600000 48,572.10 Totals 86,427.90 86,427.90 86,427.90 4ND600000 General ledger vs billed 0.00 Billed not received I 0.00 General ledger vs. received 0.00 CLEAR WIOA Reconciliation -Adult Program Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance June -17 4ND600000 4,981.32 4,981.32 (4,981.32) July -17 4ND600000 50.00 (4,981.32) - August -17 4ND600000 (5,031.32) - September -17 4ND600000 12,520.67 12,520.67 12,520.67 10/20/17 (12,520.67) October -17 4ND600000 15,921.25 15,921.25 15,921.25 11/27/17 (28,441.92) November -17 4ND600000 20,130.18 20,130.18 20,130.18 12/21/17 (48,572.10) December -17 4ND600000 (48,572.10) December -17 B 4ND600000 (48,572.10) January -18 4ND600000 (48,572.10) February -18 4ND600000 (48,572.10) March -18 4ND600000 (48,572.10) April -18 4ND600000 (48,572.10) May -18 4ND600000 (48,572.10) June -18 4ND600000 (48,572.10) July -18 4ND600000 (48,572.10) Totals 48,572.10 48,572.10 48,572.10 4N D600000 General ledger vs bullied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 0 Funds Available Inqu ry (COLE Ledger) Selection Criteria Ledger :CDLE Ledger Budget 5230 WELD -15 Period !Adj-18� Summary test Account period Balances (PJTD) - Adj-18 45230.0000.6500.4 N D6000000.0000 Amount Type 1Project To Date Encumbrance Type ALL Account Level All Funds Budget Encumbrance Actual Available 135000.00 1 0.00: 86427 90� 1 48572.10 0.00, Account 5230,0000.650©.4ND6000000.0000.000000001 Period Ii 'INov-16 Account 35230.0000.6500 4ND6000000.0000.00000000i :Mar -17 r�mmmM lApr-17 May -17 ;Jun -17 ;Adj-17 Period 1i {Aug -17 :Sep -17 Oct -17 ov-17� Dee -17 :Jan -18 IFeb-1 8� IMar-18 1Apr-18a Funds Available ( Detail Balances ) Budget Encumbrance 135000.001 0.00 0.00! 0.001 0.001 0.00 0.001 0.00: 0.00; 0.00: 0.00; 135000.001 Funds Available ( Detail Balances ) Budget 0.001 0.001 0.00 , 0.00j 0.001 0.001 0.001 0.00: 135000.00 0.00 Q 00 0.00: 0.00 0.00 000; 000:. 0.00: 000__ 0.00 Encumbrance 0.00 0.001 0.00: 0.00 0.00 0.00 0 OQ: 0.00: O Oas 0 00' Actual 0.00 0.00 0.001 Q00,. 0.00 0.00: 0.00 0.00 0.00 0 0Q 22211 98; 0.00' 86427.90 Actual -22211.98: 000_ Funds Available 135000 00 0.00 0.00 0.00 -22211 98 0.00, 48572.10. Funds Available 22211 98 ±- 0.00 0.00: 0O0 62673 171 -62673.17 23725.01: -23725.01. -29.72 0.00- 0.00 29 72 0 00 0.00 86427 90,1 0.00 48572.10 Account €5230 0000.6500.4ND6000000 0000.000000001 Funds Available ( Detail Balances ) Period May -17 lJun-17 Adj-17 Aug -17 Sep -17 w ...... iOct-17 INov17 Dec -17 {Jan -18 Encumbrance 0.00' 0.00 0.00 Actual 0.00' 4981.32 0.00 Funds Available 0.00 21. 4981.32 0.00 0.00: -4981.321 4981.32 0.00 ; 0.00 0.00 , 0.00 0.00E 0.00! 12520.671 -12520.67 0.00 `I w_m 0. 15921.25 -15921.25 0 00 000 ` 20130.18' -20130 18 0.00 0.001 000 , 0.00 0.00 ,_.._ 0.00:0.00 0.00, 0.00! 48572.101 -48572.10 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Attachment H GRANT CLOSEOUT RECONCILICATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 CONTRACT/EAIWORKPLAN START DATE PROGRAM INCOME START DATE Page 1 of 2 YEAR OF FUNDS FY16 TITLE/PROGRAM/PROJECT WIOA WFD 5% -ADULT EVALU & CON1 CLEAR Program code 4RA5000000 4/1/2017 END DATE END DATE 6/30/2018 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported . r;" � * r u; ) T, 2. Current Program and Admin Cash Needs 20,000.00 3. FINAL Program and Admin Cash Needs Contract to Date 20,000.00 II. PROGRAM EXPENSE REPORT (ER) 1{ uiNA 1. Total Expenses+Accruals Previously Reported (Through Last Month) 20,000.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 20,000.00 ADMINISTRATIVE EXPENSE (ER) w` t 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 r.r ,i ) +� 1. Total Program Income Expenses 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,000.00 2. FINAL Expenses Through End of Contract 20,000.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 c', 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 Wl. MATCH RECONCILIATION 1. FINAL Match Reported Through End of Contract 2. FINAL Expenses Through End of Contract 20,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 E /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 7 �C /,g Authorized Signature €,,,,.. � ix� / °'7 o•NL` Date SEP 12 2018 See instruction for completing this for on the next tab (Attachment H 2 of 2) 020/8- A19`0 34- CLEAR WIOA Reconciliation -5% Evaluation Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance October -15 4RA500000 20,000.00 June -17 4RA500000 20,000.00 July -17 4RA500000 20,000.00 August -17 4RA500000 20,000.00 September -17 4RA500000 20,000.00 October -17 4RA500000 20,000.00 November -17 4RA500000 20,000.00 December -17 4RA500000 681.36 20,000.00 December B-17 4RA500000 1.13 20,000.00 January -18 4RA500000 466.32 20,000.00 February -18 4RA500000 1,866.69 20,000.00 March -18 4RA500000 3,072.16 6,087.66 6,087.66 5/29/18 13,912.34 April -18 4RA500000 2,884.81 2,884.81 2,884.81 5/29/18 11,027.53 May -18 4RA500000 4,481.84 4,481.84 4,481.84 7/13/18 6,545.69 June -18 4RA500000 6,545.69 6,545.69 6,545.69 8/2/18 0.00 July -18 4RA500000 0.00 Totals 20,000.00 20,000.00 20,000.00 4RA500000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 0 Period Balances (PJTD) - Adj-18 Account 5230.0000.6500.4RA5000000..0000 000000001 Funds Available ( Detail Balances ) Period Aug -15 1Dec-15 Jan -16 ,1Feb-16 EMar-16 W;u '1Apr-16 inna Budget 0.00E 0.00E 20000.001- 0.00' 0.001 0.001 0001 0.00[ 0.001. Encumbrance 0.00' 0.00[ 0.00 1 0.001 0001 0.00' 0.001::,_.. 0./0/01 Account [523000006500.4RA5000000.0000 000000001 Funds Available ( Detail Balances ) Period ;Nov -17 1Dec-17 Jan -18 '1Feb-18 .1Mar-18 Apr -18 ;May -18n,.. Jun -18 Adj-18 1 0.001 Actual Funds Available 0001 000 0.001 O.flO 0.001 0 00' 0.00 Q.00' 4001 0.001 0.001 0.00r 20000.00S Budget Encumbrance 0.00 ��j 0.00. 0.00 0.00 ] �� 0.00E 0.00 0.001 0.00 0.001 0001 00D 0.001 0.001 0.00 0.00' 0.00! 0.001 0.00' 000] 20000.00' 00.00'r 0.00' 0.00 ... 0.00 0 00 0.00 0.00 Q00 0.00 Actual Funds Available_ 0.00 0.00 0.00 000E 0.001 0.00. 6087.661 -6087.66_. 2884 81 -2884.81 4481.84 6545_69 0.001 0.001 20000.001 - 4481.84 - 6545.69 ., 0.00 ; 0.00 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Attachment H GRANT CLOSEOUT RECONCILICATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 CONTRACT/EA/WORKPLAN START DATE PROGRAM INCOME START DATE Page 1 of 2 YEAR OF FUNDS PY15 TITLE/PROGRAM/PROJECT WFD-SPNEG-GRANT PLANNING CLEAR Program code 4S35000000 10/1/2015 END DATE END DATE 6/30/2018 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 80,257.00 80,257.00 II. PROGRAM EXPENSE REPORT (ER) , a � m , ° . °. 1. Total Expenses+Accruals Previously Reported (Through Last Month) 80,257.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 80,257.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 Expenses 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 80,257.00 2. FINAL Expenses Through End of Contract 80,257.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 t: x. ` , °a 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 VII. MATCH RECONCILIATION , � [ "I , ,i 1. FINAL Match Reported Through End of Contract 2. FINAL Expenses Through End of Contract 80,257.00 3. Match Percentage of Expenditure Contracttual Requirement 0.00 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes ID /No 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 1/7 //9 Authorized Signature -1`irtr2—Z....C--1-47— SEP 12 2018 Date See instruction for completing this for on the next tab (Attachment H 2 of 2) 020!8 - 0289° 37 CLEAR WIOA Reconciliation -Technical Assistance Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance October -15 4535000000 162.32 80,257.00 November -15 4S35000000 2,549.00 80,257.00 December -15 4535000000 6,005.51 80,257.00 December B-16 4S35000000 1,326.92 80,257.00 December C-16 4S35000000 3,769.31 80,257.00 January -16 4535000000 1,478.02 80,257.00 February -16 4S35000000 4,626.70 80,257.00 March -16 4535000000 487.59 20,405.37 20,405.37 6/21/16 59,851.63 April -16 4535000000 4,184.86 59,851.63 May -16 4S35000000 4,184.36 4,184.36 7/1/16 55,667.27 June -16 4S35000000 648.94 649.44 649.44 7/27/16 55,017.83 July -16 4S35000000 55,017.83 August -16 4535000000 5,485.83 5,485.83 5,485.83 12/31/16 49,532.00 September -16 4535000000 49,532.00 October -16 4535000000 49,532.00 November -16 4S35000000 49,532.00 December -16 4535000000 49,532.00 January -17 4535000000 374.29 49,532.00 February -17 4S35000000 2,648.70 49,532.00 March -17 4535000000 2,609.56 5,632.55 5,632.55 5/11/17 43,899.45 April -17 4535000000 255.52 255.52 255.52 5/23/17 43,643.93 May -17 4535000000 43, 643.93 June -17 4S35000000 1,248.05 1,248.05 1,248.05 7/21/17 42,395.88 July -17 4S35000000 81.53 81.53 81.53 8/21/17 42,314.35 August -17 4535000000 780.39 780.39 780.39 9/25/17 41,533.96 September -17 4S35000000 4,629.20 4,629.20 4,629.20 10/20/17 36,904.76 October -17 4535000000 36,904.76 November -17 4535000000 8,155.20 8,155.20 8,155.20 12/21/17 28,749.56 December -17 4535000000 14,104.43 14,104.43 14,104.43 14,645.13 December B-17 4S35000000 124.63 14,645.13 January -18 4535000000 2,828.19 2,952.82 2,952.82 2/27/18 11,692.31 February -18 4S35000000 1,563.96 1,563.96 1,563.96 5/29/18 10,128.35 March -18 4S35000000 2,389.45 2,389.45 2,389.45 5/29/18 7,738.90 April -18 4535000000 853.18 853.18 853.18 5/29/18 6,885.72 May -18 4535000000 6,696.11 6,696.11 6,696.11 7/13/18 189.61 June -18 4535000000 189.61 189.61 189.61 8/2/18 0.00 July -18 4535000000 0.00 Totals 80,257.00 80,257.00 80,257.00 4535000000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Account 15230.0000.6500.4835000000.0000.00000000( Funds Available ( Detail Balances ) Period IOct-15 11 -No -v-15 `€Dec -15 'Jan -16 1Feb-16 ,Mar -16 Apr -,96__ EMay-16 1Jun-16 lAdl-16 Budget 80257 001 0.00' 0.00; 0.001 0.00 0.00 Actual Funds Available 0.00° 80257 00 Encumbrance 0.00 0.001 0.00;. 0.00i 0.001 0.00! 0.00 0.00; 0.00 ,, 0.00! 0.00 0.00 __..__... 0.001 0.001 0 001 0.00 4184.36! o.00 649.44 000 0.00 -20405.37 0.00 -4184.36 -649.44 0.00 °Period Balances (PJTD) - Aug -18 Account 5230.0000.6500.4S35000000.0000.00000000( Period 1 DIE_._... Aug -16 ISep-16 Oct -16 INov-16W i Dec -16 1Jan-17 Feb -17 Mar -17 Apr -17 Funds Available ( Detail Balances ) Budget 0.00 0.001 Encumbrance 0.00 0.00' Actual Funds Available 0.00! 0.00 - 5485.83 I -5485_83 0.00 { 0 001 0.00 i 0.00;1 0.00 0.00 0.00; 0.001 Q 00 ' l Q.Oo;,__ 0.00 o.00 0.00, 0.00:I 0.001 0.001 0.00 0.00: 80257.001 0.001 0.001 0.00! 5632.55 0.00; 255.521 0.001 000.. O00xi 0.00 0.00' 000, 0.00 -5632 55 -255.52 80257.00, 0.00 (NM) Aug • Account r5230.0000.6500 .0000.6500.4S 35000000.0000.00000000( Period 1Jun-17 Aug 17 11Sep-17 10ct-17 • Dec 17 3Jan-18 Funds Available ( Detail Balances ) Budget Encumbrance 0.00E .._� 0.00 1 0.00 0.00'. 0.00. 0.00 0.00 0.00: Account 15230.0000.6500.4S35000000.0000..00000000t Funds Available ( Detail Balances ) Period Dec -17 jFeb-18 µ'Mar-18��„ Apr 18 4(May-18_ [Jun -18 • , Act -18 Jul-i s Aug -18 0.00! Budget Encumbrance. 0.00E 000], 0.001 000 j 0.001 0.001 80257.00' 0.001 0.001 1563.96 0.00; w m 2389 451 853.181 6696.11 189..61 0.001 0.O1 0.00! Funds Available 0.0 - 780.39i 4829.201, 0.001 8155 20 14104 431 2952.82,: 80257.001 Actual 0.001 0.00 0.001 0.001. 0.00j -1248 0.00', -81.53 -780.39Z; -4629.20''. 155.20 Funds Available 1i044377- 9 -1563.96'1; !1'„ -2389.45 8 6696 1 -189611 000 !' 0,00 0.00 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Attachment H GRANT CLOSEOUT RECONCILICATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 CONTRACT/EA/WORKPLAN START DATE PROGRAM INCOME START DATE Page 1 of 2 YEAR OF FUNDS PY15 TITLE/PROGRAM/PROJECT WFD-SPNEG-LOCAL ADMIN CLEAR Program code 4S45000000 10/1/2015 END DATE END DATE 6/30/2018 1. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 2. Current Program and Admin Cash Needs 57,346.00 3. FINAL Program and Admin Cash Needs Contract to Date 57,346.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 57,346.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 57,346.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 Expenses 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 o 1. FINAL Cash Request Contract to Date 57,346.00 2. FINAL Expenses Through End of Contract 57,346.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 2. FINAL Expenses Through End of Contract 57,346.00 3. Match Percentage of Expenditure Contracttual Requirement 0.00 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes O /No ❑ 'The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signature ,( 7 . Date 't/ ii� Authorized Signature 17Z � M2''L- .4, ' DatEEP 1 2 2018 See instruction for completing this for on the next tab (Attachment H 2 of 2) 0�0l8 a i9c7 �� CLEAR WIOA Reconciliation -Technical Assistance Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance October -15 4S45000000 5,110.04 57,346.00 November -15 4S45000000 3,516.55 57,346.00 December -15 4545000000 4,030.37 57,346.00 December B-16 4545000000 1,656.71 57,346.00 December C-16 4S45000000 6,020.75 57,346.00 January -16 4S45000000 (6,905.49) 57,346.00 February -16 4545000000 2,447.58 57,346.00 March -16 4S45000000 589.78 57,346.00 April -16 4S45000000 1,778.51 57,346.00 May -16 4S45000000 4,272.15 22,516.95 22,516.95 7/1/2016 34,829.05 June -16 4S45000000 265.05 265.05 265.05 7/27/2016 34,564.00 July -16 4545000000 34,564.00 August -16 4S45000000 34,564.00 September -16 4S45000000 34,564.00 October -16 4S45000000 34,564.00 November -16 4545000000 34,564.00 December -16 4S45000000 34,564.00 January -17 4S45000000 563.44 34,564.00 February -17 4S45000000 1,577.54 34,564.00 March -17 4545000000 3,956.25 6,097.23 6,097.23 5/11/2017 28,466.77 April -17 4545000000 1,632.65 1,632.65 1,632.65 5/23/2017 26,834.12 May -17 4S45000000 22,893.70 22,893.70 22,893.70 6/26/2017 3,940.42 June -17 4S45000000 206.20 206.20 206.20 7/21/2017 3,734.22 July -17 4S45000000 1,113.38 1,113.38 1,113.38 8/21/17 2,620.84 August -17 4S45000000 164.14 164.14 164.14 9/25/17 2,456.70 September -17 4S45000000 156.36 156.36 156.36 10/20/17 2,300.34 October -17 4S45000000 2,300.34 November -17 4545000000 1,579.75 1,579.75 1,579.75 12/21/17 720.59 December -17 4S45000000 720.59 720.59 720.59 2/1/18 (0.00) December B-17 4S45000000 (0.00) January -18 4545000000 (0.00) February -18 4S45000000 (0.00) March -18 4545000000 (0.00) April -18 4545000000 (0.00) May -18 4S45000000 (0.00) June -18 4S45000000 (0.00) July -18 4S45000000 (0.00) Totals 57,346.00 57,346.00 57,346.00 4545000000 General ledger vs bullied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Account 5230.0000.6500.4S45000000.0000.00000000( Funds Available ( Detail Balances ) Period I Oct -15 I ` Nov -15 Dec -15 • IJan-16 Feb -16 !Mar -16 . Apr -16 ,May -16 Jun -16 Adj-16 Budget Encumbrance 57346.00 0.001 0.001 0.001 0.00; v . 0 001 0.00: 57346.00: 0.001 0.00'. 0.0011 o.00'l 0.00! 0.00i 0001._. 0.001 Actual Funds Available 0.00! 57346.00 0.00 0.00 0.00 . 0.00 0.00,.... r.... 0.00 0.00: 000 000; 0.00 0.00 r 0.00 -22516.95 265.051 0.00 ..:.... 57346 001 0.00, a Period Balances (PJTD) - Aug -18 ROM Account 15-230.0000.6500.4S45000000.0000. 00000000( Period I.Jul-16 Aug -16 #Sep -16 30ct-16 Nov 16 Dec -16 Jan -17 ;Feb -17 :Mar -17 -Apr-17 Funds Available ( Detail Balances ) Budget Encumbrance 0.001 0.00? 0.00t 0 001 000; 0.00! ..._ 0.001 0.001,... aoo'1 0.00i o.00l 0.00! 0.001 0.00; 0.001 0001 o.00' 0.00.I 0.001 0.00 0 00 0.00 57346.001 0.00 0.00; 0001 0.00' 0.0G' 0001. 0.00' 0.00 11 6097.23; 1632.65 57346.00 Funds Available 0.00 0.00 0.00`x, -6097.23 -1632.65 0.00 Pert.Bat TD) A t1 Account 5230 0000 6500 4845000000 0000 00000000( Funds Available ( Detail Balances ) Period lMay-17 jJun 17 €.Adt-17� [Jut 17� lAug-17 :Sep -17 Oct -1'7 Nov -17 .._. iDec-17 A3 Jan -18 Budget 0 001 0001 0.00 a 0 00, 0001 .._ 0.00 0.a£1{ 0.001 0 00 0.00 57346.001 Encumbrance 0001 :.. a00j..: 0 00 ..... 0 00.__ O00 0.00; 0.001 000,: 0001 0 0.001 Actual • Funds Available -22893:70A • 1-206:2041 0001 • 0.00,14 111338 111338 164 14 1 -164..14A1 156 36 .-156.36111111 0 a0 0.00,1177. 1579.75 72a59 0.00 57346.00; -1579 75 -720.59 0 0.00 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT GRANT CLOSEOUT RECONCILICATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 CONTRACT/EA/WORKPLAN START DATE PROGRAM INCOME START DATE YEAR OF FUNDS PY15 Attachment H Page 1 of 2 TITLE/PROGRAM/PROJECT WFD-SPNEG-LOCAL PROGRAM CLEAR Program code 4S55000000 9/1/2015 END DATE END DATE 6/30/2018 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 2. Current Program and Admin Cash Needs 723,160.00 3. FINAL Program and Admin Cash Needs Contract to Date 723,160.00 II. PROGRAM EXPENSE REPORT (ER) : ix w 1. Total Expenses+Accruals Previously Reported (Through Last Month) 723,160.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 723,160.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 Expenses 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 723,160.00 2. FINAL Expenses Through End of Contract 723,160.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 r �',; ,1 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 VI. RECONCILIATION 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 MOREL 1. FINAL Match Reported Through End of Contract 2. FINAL Expenses Through End of Contract 723,160.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 Signaturej Date/ ‘71/q/147 Authorized Signature -L G.O--`-(„."i) 921.0--,.._(„„i) / Dat FP 12 2018 See instruction for completing this for on the next tab (Attachment H 2 of 2) 020/x -0l89° 31 CLEAR WIOA Reconciliation -Technical Assistance Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance September -15 4555000000 15,783.86 723,160.00 October -15 4S55000000 23,402.51 723,160.00 November -15 4S55000000 21,576.06 723,160.00 December -15 4555000000 22,275.21 723,160.00 December B-15 4555000000 5,543.72 723,160.00 December C-15 4555000000 3,171.28 723,160.00 January -16 4S55000000 22,265.40 723,160.00 February -16 4S55000000 15,569.49 723,160.00 March -16 4S55000000 24,312.11 153,899.64 153,899.64 6/21/16 569,260.36 April -16 4S55000000 15,759.18 569,260.36 May -16 4S55000000 7,022.89 22,782.07 22,782.07 7/1/16 546,478.29 June -16 4S55000000 3,919.39 3,919.39 3,919.39 7/27/16 542,558.90 July -16 4555000000 513.68 542,558.90 August -16 4555000000 8,313.71 8,827.39 8,827.39 12/31/16 533,731.51 September -16 4555000000 15,847.95 15,847.95 15,847.95 12/31/16 517,883.56 October -16 4S55000000 3,310.56 3,310.56 3,310.56 12/31/16 514,573.00 November -16 4555000000 514,573.00 December -16 4S55000000 69,404.41 514,573.00 January -17 4S55000000 27,090.43 514,573.00 February -17 4555000000 36,094.24 514,573.00 March -17 4555000000 18,972.60 82,157.27 82,157.27 5/11/17 432,415.73 April -17 4555000000 16,433.52 16,433.52 16,433.52 5/23/17 415,982.21 May -17 4555000000 2,134.86 71,539.27 71,539.27 6/26/17 344,442.94 June -17 4555000000 2,578.72 2,578.72 2,578.72 7/21/17 341,864.22 July -17 4S55000000 2,779.67 2,779.67 2,779.67 8/21/17 339,084.55 August -17 4S55000000 4.00 4.00 4.00 9/25/17 339,080.55 September -17 4555000000 8,951.20 8,951.20 8,951.20 10/20/17 330,129.35 October -17 4555000000 17,059.42 17,059.42 17,059.42 11/27/17 313,069.93 November -17 4S55000000 8,074.61 8,074.61 8,074.61 12/21/17 304,995.32 December -17 4S55000000 34,377.38 34,377.38 34,377.38 2/1/18 270,617.94 December B-17 4555000000 12,268.53 270,617.94 January -18 4555000000 28,475.42 40,743.95 40,743.95 2/27/18 229,873.99 February -18 4555000000 48,879.00 48,879.00 48,879.00 5/29/18 180,994.99 March -18 4S55000000 27,170.23 27,170.23 27,170.23 5/29/18 153,824.76 April -18 4S55000000 51,319.91 51,319.91 51,319.91 5/29/18 102,504.85 May -18 4S55000000 34,542.40 34,542.40 34,542.40 7/13/18 67,962.45 June -18 4S55000000 56,069.75 56,069.75 56,069.75 8/2/18 11,892.70 July -18 4555000000 11,892.70 11,892.70 (0.00) Totals 723,160.00 723,160.00 711,267.30 4555000000 General ledger vs billied 0.00 Billed not received I 11,892.70 General ledger vs. received 11,892.70 ry Account 15230 0000.6500.4555000000.0000.00000000(. Funds Available ( Detail Balances ) Period 11Oct-15 !Nov -15 Jan -16 IFeb-16 Mar -16 Apr -16 ;May -16 IJun-16 Adj-16 Period Balances (PJTD) - Aug -18 Budget 674688.00 0.00 0.00 000,{ 0.001 0001 0.00 0.00 0.00' 723161.001 Encumbrance 0.001 0.00 O000. 0.00' 0.001 0.001 0.001 0003;_ 0.00. Actual 0.003 0.001 fm 0.001 153899..64 0.001 22782.071 3919 39 0.001 Funds Available 674688.00 0.00 0.00 0.00 000 -153899.64 0 00 -22782.07 -3919.39 0.00 BEM Account 15230.0000.6500.4555000000.0000.00000000( Funds Available ( Detail Balances ) Period ';Jul -16 [Aug -16 Sep -16 Oct -16 LNov-16 mmmm Dec -16 Jan -17 'Mar -17 Apr -17 Budget Encumbrance 0.001 0.001 0.001 000' 0.00 .__ 0.00 0.001 0.00 ` 0.OO 0.001 0.001 0.001 0.001 0.001 0.001 0.00 0.00, 0 00 723161.001 r-- 0.001 723160.00 ! 1.00 Actual Funds Available i�, 000= 8827.39'1 -8827.39 15847 95 -15847.95 3310 56j -3310.56 _�. 000,_ 0.00. 0 00 0.00 . 0001 0.00 0.00 I 0 00 82157.27' -82157.217 16433 52 -16433 52 . f-_ Period Balances (PJTD) - Aug -18 Account 15230.0000.6500.4555000000.0000.00000000€ Funds Available ( Detail Balances ) Period Adj-17 Jul -17m Aug -17 1 Sep -17 Period Balances (PJTD) - Aug -18 Budget 0.00 Encumbrance _�. 0.00 0.00; 0 00' 0.00 0.001 0.00 0.001 0.001 0.00'( 0.001 0.00' 0.00 0.00 723161 00i 0.001 0.001 0.001 0.001 Actual Funds Available 71539 27 -71539.27 4 00; 8951.20 17059.42 8074.61) 34377.38 40743.951 723160.001 -2578.72 000 -2779.67 -4.00 -8951.20 -17059.42 8074.61 -34377.38 -40743.95 1.00 MOM Account 15230.0000.6500.4S55000000.0000.00000000( Period 1Jan-18 1Aug-18 Funds Available ( Detail Balances) Budget 0.001 0.00 48472.00 0.00 0.00 1.00. 723161.)0 Encumbrance 0.001 0.00 0.001 0.00 i".. 0.001 0.001 0.00'1 0.00 0 00„ 0.00 Actual Funds Available 3- 34 77.38 ', 51319.911 34542.40 56069 75 0.00 11892.701 000, 723160.00= -4(174-3 9�5� - 48879.00 - 27170.23 -51319.91 - 34542.40 -7597.75 000 892.70 1.00 1.00 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Attachment H GRANT CLOSEOUT RECONCILICATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 CONTRACT/EA/WORKPLAN START DATE PROGRAM INCOME START DATE Page 1 of 2 YEAR OF FUNDS PY16 TITLE/PROGRAM/PROJECT WIOA 10% Youth Local Admin CLEAR Program code 4Y66000000 7/1/2016 END DATE END DATE 6/30/2018 I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 2. Current Program and Admin Cash Needs 30,956.00 3. FINAL Program and Admin Cash Needs Contract to Date 30,956.00 II. PROGRAM EXPENSE REPORT (ER) )ua:... .. 1. Total Expenses+Accruals Previously Reported (Through Last Month) 30,956.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 30,956.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 Expenses 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 o I},,,!!;!k',,,, 1. FINAL Cash Request Contract to Date 30,956.00 2. FINAL Expenses Through End of Contract 30,956.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 WI. MATCH RECONCILIATION ... litkat 1. FINAL Match Reported Through End of Contract 2. FINAL Expenses Through End of Contract 30,956.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 / . i. Date 6/I /IS Authorized Signature -ti- A.' - �( , ��' —" "it.--tC7" DateSEP 12 2018 See instruction for completing this for on the next tab (Attachment H 2 of 2) 020/1- 890 CLEAR WIOA Reconciliation -Youth Administration Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received 1 Date Received I Grant Balance June -16 4Y6600000 30,956.00 March -17 4Y6600000 2,341.72 2,341.72 2,341.72 5/11/2017 28,614.28 April -17 4Y6600000 3,325.39 3,325.39 3,325.39 5/23/2017 25,288.89 May -17 4Y6600000 3,817.28 3,817.28 3,817.28 6/23/2017 21,471.61 June -17 4Y6600000 897.34 897.34 897.34 7/21/2017 20,574.27 July -17 4Y6600000 421.07 421.07 421.07 8/21/2017 20,153.20 August -17 4Y6600000 1,776.58 1,776.58 1,776.58 9/25/2017 18,376.62 September -17 4Y6600000 3,157.67 3,157.67 3,157.67 10/20/2017 15,218.95 October -17 4Y6600000 2,991.43 2,991.43 2,991.43 11/27/2017 12,227.52 November -17 4Y6600000 3,034.14 3,034.14 3,034.14 12/21/2017 9,193.38 December -17 4Y6600000 2,023.26 2,023.26 2,023.26 2/1/2017 7,170.12 December B-17 4Y6600000 4,073.45 4,073.45 4,073.45 2/27/2018 3,096.67 January -18 4Y6600000 3,096.67 February -18 4Y6600000 3,096.67 3,096.67 3,096.67 5/29/2018 - March -18 4Y6600000 - April -18 4Y6600000 - May -18 4Y6600000 - June -18 4Y6600000 - July -18 4Y6600000 - Totals 30,956.00 30,956.00 30,956.00 4Y6600000 General ledger vs bullied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Period Jun -17 EAdf-17 ;Aug -17 Oct -17 Nov -17 IDec-17 mm IJan-18 Account [5230.0000.6500.4Y66000000.0000.00000000( Period Jul -16 aAug-16 Sep -16 Oct -16 Nov -16 Dec -16 Jan -17µ.. Feb -17 Mar -17 Apr -17 Funds Available ( Detail Balances ) Budget Encumbrance 3095600' 0.001 0.00„ 0.00 0.00 o.00 0.00; 0.W, 0.001 0.00: 000; 000 0.00. 30956.00 0.00 0.00' 0.001m 0.001 0.00 0.001 0.00, 0.00' Actual Funds Available 0.001 30956.00 '111- 0. 000` 0.001 0.00; 000j 0.001 0.00 2341.72 3325.391 30956. 0.00 0.00 0.00 0 00 0.00 000 • 0.00 -2341 72 -3325.39 _` 0.00'; 0 Period Balances (PJTD) - Aug -18 ®®M Account 5230.0000.6500 4Y66000000 0000.00000000( Funds Available ( Detail Balances ) Budget 0.00, 0.001 0.00, 0.001 0.00 0.001 0.001 0.001 0.001 0.00; 30956.00'. Encumbrance 0.00,E 0001I 0_00i _. 0.00, 0001 0.001 3817.281 ..,.897.34 0.001 421.07 1776.58 3157.67'!1 2991.43', 3034.14 I Actual Funds Available -3817.28 -897.314'1,1 897.34 0.00 -421 07 -1776.58 -2991.43 PJ Aug Account 15230.0000.6500.4Y66000000.0000. 00000000( Funds Available ( Detail Balances ) Budget Encumbrance Actual Funds Available Qi1Q 0 001 2£'a'.L -2023 26 --_ yr ... ...o...t -a 000 du7S t5 -4073 45 ' ,IFeb-18 1 fl Chi E 000' 3096.67 -3096.67 EMar-18 0 00 0.00 0.00 I 0 00 1� (Apr -18 $ i _ 0001 000` 000 0� May -18 0 00 _ 0 0.00 ( 0 00 Jun 18 000e 0 i8 0.00 000 0a" pAdt 18 fl00I 0.001 000! 000 Jul -18 0 001 0.001 000! 0.00 Aug 8 .00 0.001 0.001 0.00 Period Dec -1 09€ 001 0.0o 1 30956.00 0.00 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Attachment H GRANT CLOSEOUT RECONCILICATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 CONTRACT/EANVORKPLAN START DATE PROGRAM INCOME START DATE Page 1 of 2 YEAR OF FUNDS PY16 TITLE/PROGRAM/PROJECT WIOA YOUTH -75% -OUT -SCHOOL LOC CLEAR Program code 4Y76000000 7/1/2016 END DATE END DATE 6/30/2018 I. CASH REQUEST 1, Total program and Admin Cash needs Preciously Reported 2. Current Program and Admin Cash Needs 448,607.00 3. FINAL Program and Admin Cash Needs Contract to Date 448,607.00 I1. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 448,607.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 448,607.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 Expenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION ? r 1. FINAL Cash Request Contract to Date 448,607.00 2. FINAL Expenses Through End of Contract 448,607.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 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 Aak lac rL it 2. FINAL Expenses Through End of Contract 448,607.00 3. Match Percentage of Expenditure Contracttual Requirement 0.00 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes E /No O 'The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signature r Date IA i /if Authorized Signature _ E !' 1 / 1--- -` �L 'C 1 Date SEP 12 2018 See instruction for completing this for on the next tab (Attachment hl 2 of 2) 010/8 A 8 90 it/ CLEAR WIOA Reconciliation -Youth out of School Training Reporting Month !Program Code [ Tracking Sheet I CLEAR I Received I Date Received I Grant Balance July -16 4Y7600000 448, 607.00 August -16 4Y7600000 448, 607, 00 September -16 4Y7600000 19,655.15 19,655.15 19,655.15 12/31/16 428,951.85 October -16 4Y7600000 17,198.62 17,198.62 17,198.62 12/31/16 411,753.23 November -16 4Y7600000 21,502.88 21,502.88 21,502.88 12/31/16 390,250.35 December -16 4Y7600000 21,587.04 21,587.04 21,587.04 12/31/16 368,663.31 December -16 B 4Y7600000 15,728.07 368,663.31 January -17 4Y7600000 10,590.11 10,590.11 10,590.11 2/23/17 358,073.20 February -17 4Y7600000 20,223.49 35,951.56 35,951.56 4/4/17 322,121.64 March -17 4Y7600000 15,342.30 322,121.64 April -17 4Y7600000 23,300.57 322,121.64 May -17 4Y7600000 3,662.57 23,757.93 23,757.93 6/26/17 298,363.71 June -17 4Y7600000 410.54 2,955.41 2,955.41 7/21/17 295,408.30 July -17 4Y7600000 (6,594.79) 9,407.85 9,407.85 8/21/17 286,000.45 August -17 4Y7600000 13,644.45 13,644.45 13,644.45 9/25/17 272,356.00 September -17 4Y7600000 15,727.26 15,727.26 15,727.26 10/20/17 256,628.74 October -17 4Y7600000 14,172.35 14,172.35 14,172.35 11/27/17 242,456.39 November -17 4Y7600000 616.13 616.13 616.13 12/31/17 241,840.26 December -17 4Y7600000 241,840.26 December B-17 4Y7600000 241,840.26 January -18 4Y7600000 241,840.26 February -18 4Y7600000 241,840.26 March -18 4Y7600000 241,840.26 April -18 4Y7600000 241, 840.26 May -18 4Y7600000 241,840.26 June -18 4Y7600000 241, 840.26 July -18 4Y7600000 241, 840.26 Totals 206,766.74 206,766.74 206,766.74 4Y7600000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 CLEAR WIOA Reconciliation -Youth Administration Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance August -16 4Y7600000 1,921.36 1,921.36 1,921.36 12/31/2016 (1,921.36) September -16 4Y7600000 2,495.38 2,495.38 2,495.38 12/31/2016 (4,416.74) October -16 4Y7600000 2,242.22 2,242.22 2,242.22 12/31/2016 (6,658.96) November -16 4Y7600000 3,542.96 3,542.96 3,542.96 12/31/2016 (10,201.92) December -16 4Y7600000 3,846.02 3,846.02 3,846.02 2/6/2017 (10,504.98) December -16 B 4Y7600000 945.94 945.94 4/4/2017 (10,201.92) January -17 4Y7600000 2,308.71 2,308.71 2,308.71 2/23/2017 (12,510.63) February -17 4Y7600000 4,399.59 5,345.53 4,399.59 4/4/2017 (17,856.16) March -17 4Y7600000 4,936.00 4,936.00 7/21/2017 (17,856.16) April -17 4Y7600000 7,890.36 7,890.36 7/21/2017 (17,856.16) May -17 4Y7600000 8,655.06 8,655.06 7/21/2017 (17,856.16) June -17 4Y7600000 3,930.07 25,411.49 3,930.07 7/21/2017 (43,267.65) July -17 4Y7600000 5,763.24 5,763.24 5,763.24 8/21/17 (49,030.89) August -17 4Y7600000 7,499.78 7,499.78 7,499.78 9/25/17 (56,530.67) September -17 4Y7600000 7,110.95 7,110.95 7,110.95 10/20/17 (63,641.62) October -17 4Y7600000 7,853.84 7,853.84 7,853.84 11/27/17 (71,495.46) November -17 4Y7600000 7,949.65 7,949.65 7,949.65 12/21/17 (79,445.11) December -17 4Y7 600000 (79,445.11) December B-17 4Y7600000 (79,445.11) January -18 4Y7600000 (79,445.11) February -18 4Y7600000 (79,445.11) March -18 4Y7600000 (79,445.11) April -18 4Y7600000 (79,445.11) May -18 4Y7600000 (79,445.11) June -18 4Y7600000 (79,445.11) July -18 4Y7600000 (79,445.11) Totals 83,291.13 83,291.13 83,291.13 4Y7600000 General ledger vs bullied Billed not received I General ledger vs. received CLEAR WIOA Reconciliation -Youth out of School Program Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance August -16 4Y7600000 18,069.50 18,069.50 18,069.50 12/31/2016 (18,069.50) September -16 4Y7600000 7,772.31 7,772.31 7,772.31 12/31/2016 (25,841.81) October -16 4Y7600000 880.92 880.92 880.92 12/31/2016 (26,722.73) November -16 4Y7600000 7,004.09 7,004.09 7,004.09 12/31/2016 (33,726.82) December -16 4Y7600000 15,779.59 15,779.59 15,779.59 2/6/2017 (49,506.41) December -16 B 4Y7600000 8,905.78 (49,506.41) January -17 4Y7600000 6,030.00 6,030.00 6,030.00 2/23/2017 (55,536.41) February -17 4Y7600000 15,420.96 24,326.74 24,326.74 4/4/2017 (79,863.15) March -17 4Y7600000 12,059.42 12,059.42 7/21/2017 (79,863.15) April -17 4Y7600000 16,640.71 16,640.71 7/21/2017 (79,863.15) May -17 4Y7600000 14,429.79 14,429.79 7/21/2017 (79,863.15) June -17 4Y7600000 3,789.39 46,919.31 3,789.39 7/21/2017 (126,782.46) July -17 4Y7600000 338.11 338.11 338.11 8/21/17 (127,120.57) August -17 4Y7600000 11,196.25 11,196.25 11,196.25 9/25/17 (138,316.82) September -17 4Y7600000 12,104.00 12,104.00 12,104.00 10/20/14 (150,420.82) October -17 4Y7600000 7,835.96 7,835.96 7,835.96 11/27/17 (158,256.78) November -17 4Y7600000 292.35 292.35 292.35 12/21/17 (158,549.13) December -17 4Y7600000 (158,549,13) December B-17 4Y7600000 (158,549.13) January -18 4Y7600000 (158,549.13) February -18 4Y7600000 (158,549.13) March -18 4Y7600000 (158,549.13) April -18 4Y7600000 (158,549.13) May -18 4Y7600000 (158,549.13) June -18 4Y7600000 (158,549.13) July -18 4Y7600000 (158,549.13) Totals 158,549.13 158,549.13 158,549.13 4Y7600000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 ands Available Inquiry (CDLE Led 5230.0000.6500.4Y76000000.0000.00000000( Funds Available ( Detail Balances ) Selection Criteria Ledger COLE Ledger Budget 15230 WELD -15 Period 1Adj-18..._. Summary test Account 5230 0000 6500 W76000000 0000 5230.0000.6500.4Y76000000.0000. 5230.0000.6500.4Y76000000.0 OQo 15230.0000.6500.4Y76000000.0000.1 Amount Type 'Project To Date Encumbrance Type ALL Account Level ;All Budget 44860700 r 0.00 1 Encumbrance 0.00 0.001 0.00' 0.00_ Actual 206766 74', 0.00 158549.13! 83291.13 Funds Available 241840 26 ` ,.... _, _.,..0:00.. -158549.13 Period Balances (PJTD) - Adj-18 Account Period (Jul -16 Aug -16 ,Sep -16 JOct-16 (Nov -16 ;Dec -16 Jan -17 'Mar -17 :.... ......... Apr -17 0 Pentad Balances (PJTD) - Ad) -18 Budget 44860700 I ,.. 0.00 000;1. 0.001 0_00i 0.00 €. 000, 000, 0 0011 448607.00 Encumbrance 0.00 o.00 0 Qo 0.00I 0 00l 0.00 Account 5230.0000 6500.4Y76000000.0000.00000000( Funds Available ( Detail Balances ) Period ',Aug -17 1Sep-17 0ct-17.., 'Nov -17 ;Dec 17 1Jan-18 Budget 0 00i Q o01 Actual Funds Available 0.041 448607.00 _ 0.00, 0.00 19655.151 17198.621 21502.881 21587.041 10590.11 35951.56€ 0.00 0.001 206766.741 -19655.15 - 17198.62 -21502 88 -21587.04: - 10590.11 0 0 241840.26' Encumbrance Actual Funds Available 0 00, 23757.931 -23757.93 0.001 0.001 0.001 0.001 061 j 0 001 0.001 0.00_____ 0.00 0.00 0.001 0.60 0.001 0.0011 0.00( 448607.00,( o.00l 0.001 0.001 -2955.41 000' 9407.851 -9407.85 .` 13644.451 -13644.45 15727.26 � -15727.26 14172.35` -14172.35. 616.13; 616.13 0.001 0.001 206766.74: 241840.26 0.00 Account '5230.0000.6500.4Y76000000.0000.0000000 Funds Available ( Detail Balances) Period Sep -16 Oct -16 Nov -16 Dec -16 11Jan 17 •11Feb-17 ;[Mar -17.v.. lApr-17 May -17 • Budget Encumbrance 0.00-T- 00 0 001 0.00 0.001 Q 00l 0.00, 0.00{1 0.00' Account 15230.0000.6500.4Y76000000.0000.00000000( 1 Dec -17 Peri s1Ad) 17 1Jul 17 iAug-17 [Sep -1 7 1Oct-17 Iov 17. an -18 Funds Available ( Detail Balances ) 0.001 0.00 0.00 0.00 001 0.001 0.00; 0.001 0.00'' 0.001 0.001 0.00'r 0.00,1 0001 cool 0.00 1 0.00 0.001 0.0011 0.0011 Actual Funds Available 8069.501 -118€69 50 7772.31 880.921 7004.091 15779 59 6030.001 0.00 158549.131 -880.92 -7004.09 -15779.59 . 000 -158549.13 Actual Funds Available 46919.31 -46919.31 33811 96.251 12104 00 7835 96;1 292. 0.00 0.00, 15854913' -158549.13 -12104 00 -783596 0 25 Account 5230.0000.6500.4Y76000000.0000.00000000( Funds Available ( Detail Balances ) I Period 1Jul-16 Aug -16.... ,. !Sep -16 [Oct 16 INov-16 1Dec-1 Jan -17 Feb -17 Mar -17 Budget 0.00 0.00! 0.00 0.00! 000! 0.001 000 0.00 0.00 000, 0.00'; Encumbrance 0.00 0.00` 0.00 0.00 0.001 0.00: Actual Funds Available 0.00; 000 0.00 �__�.._......00© 1921.36 2495.38 2242.22 3542.96 0.00' 3846.02 0.001 0.001 0.00 0.00. 2308.71 5345.53 0.00' 83291.13 -1921.36 -2495.38 - 2242.22 - 3542.96 - 3846.02 - 2308 7 - 5345.53 0.00 -83291.13 C3 Period Balances (PJTD) - Aug -18 MOM Account 15230.0000.6500.4Y76000000.0000.00000000( May -17 ,'Jun -17 :Adj-17 !Jul -17 Aug -17 ISep-17 1NovR- ,IDec-17 Funds Available ( Detail Balances ) Budget Encumbrance 0.001 0.001 0.00i 0,00 0.00 0.00 0.00 0.00 0.001 _ . ..._ 0.00 0.001�-._.0.00. 0.001 _.._..._. __...-_ 0.00r 0.001 0.00'.1 0.0014 0.00.1 0.00' 0.00. Actual Funds Available 0.00! 0.00 0.00' 0.00 25411.49. 3 0.001 5763.24! 7499.78'I 7110.95 -25411.49 0.00 5763.24 - 7499.78 - 7110.95 -7853.84 -7949.65 0.00 € 0.00 83291.13'1 -83291.13' COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT Attachment H GRANT CLOSEOUT RECONCILICATION WORKSHEET SUBRECIPIENT: Employment Services of Weld County ADDRESS: PO Box 1805, Greeley, CO 80632 CONTRACT/EAIWORKPLAN START DATE PROGRAM INCOME START DATE Page 1 of 2 YEAR OF FUNDS PY16 TITLE/PROGRAM/PROJECT WIOA YOUTH MAX -25% -IN -SCHOOL L CLEAR Program code 4Y86000000 7/1/2016 END DATE END DATE 6/30/2018 I. CASH REQUEST... 1. Total program and Admin Cash needs Preciously Reported a , , 2. Current Program and Admin Cash Needs 30,000.00 3. FINAL Program and Admin Cash Needs Contract to Date 30,000.00 II. PROGRAM EXPENSE REPORT (ER) '. � .1: - 1. Total Expenses+Accruals Previously Reported (Through Last Month) 30,000.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 30,000.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 0.00 III. PROGRAM INCOME(PI) EXPENSE REPORT q 1. Total Program Income Expenses 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 laMERAARBRiMge a� (i g,„ 1. FINAL Cash Request Contract to Date 30,000.00 2. FINAL Expenses Through End of Contract 30,000.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 r 1 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 VII. MATCH RECONCILIATION A,a , , p, . N! i 1. FINAL Match Reported Through End of Contract 2. FINAL Expenses Through End of Contract 30,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 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 I /y' Ix Authorized Signature t.A--e- /7k Date SEP 12 2018 See instruction for completing this for on the next tab (Attachment H 2 of 2) lJZo/t- c2e ° CLEAR WIOA Reconciliation-YIS 20% Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance June -16 4Y8 600000 30, 000.00 April -17 4Y8600000 2,115.29 2,115.29 2,115.29 5/23/17 27,884.71 May -17 4Y8600000 1,215.55 1,215.55 1,215.55 6/26/17 26,669.16 June -17 4Y8600000 79.77 79.77 79.77 7/21/17 26,589.39 July -17 4Y8600000 1,594.89 1,594.89 1,594.89 8/21/17 24,994.50 August -17 4Y8600000 3,853.84 3,853.84 3,853.84 9/25/17 21,140.66 September -17 4Y8600000 4,567.49 4,567.49 4,567.49 10/20/17 16,573.17 October -17 4Y8600000 16,573.17 November -17 4Y8600000 16,573.17 December -17 4Y8600000 16,573.17 December B-17 4Y8600000 16,573.17 January -18 4Y8600000 16,573.17 February -18 4Y8600000 16,573.17 March -18 4Y8600000 16,573.17 April -18 4Y8600000 16,573.17 May -18 4Y8600000 16,573.17 June -18 4Y8600000 16,573.17 July -18 4Y8600000 16,573.17 Totals 13,426.83 13,426.83 13,426.83 4Y8600000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 CLEAR WIOA Reconciliation -Youth in School Program Reporting Month 'Program Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance May -17 4Y8600000 751.80 751.80 751.80 6/26/17 -751.80 June -17 4Y8600000 4,178.98 4,178.98 4,178.98 7/21/17 -4,930.78 July -17 4Y8600000 2,098.15 2,098.15 2,098.15 8/21/17 -7,028.93 August -17 4Y8600000 1,806.83 1,806.83 1,806.83 9/25/17 -8,835.76 September -17 4Y8600000 1,716.72 1,716.72 1,716.72 10/20/17 -10,552.48 October -17 4Y8600000 2,276.44 2,276.44 2,276.44 11/27/17 -12,828.92 November -17 4Y8600000 1,473.48 1,473.48 1,473.48 12/21/17 -14,302.40 December -17 4Y8600000 1,750.77 1,750.77 1,750.77 2/1/17 -16,053.17 December B-17 4Y8600000 -16,053.17 January -18 4Y8600000 -16,053.17 February -18 4Y8600000 -16,053.17 March -18 4Y8600000 -16,053.17 April -18 4Y8600000 -16,053.17 May -18 4Y8600000 -16,053.17 June -18 4Y8600000 -16,053.17 July -18 4Y8600000 -16,053.17 Totals 16,053.17 16,053.17 16,053.17 4Y8600000 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 CLEAR WIOA Reconciliation -Youth in School Training Reporting Month IProgram Code I Tracking Sheet I CLEAR I Received I Date Received I Grant Balance May -17 4Y8600000 200.00 200.00 200.00 6/26/17 (200.00) June -17 4Y8600000 195.00 195.00 195.00 7/21/17 (395.00) July -17 4Y8600000 (395.00) August -17 4Y8600000 25.00 25.00 25.00 9/25/17 (420.00) September -17 4Y8600000 25.00 25.00 25.00 10/20/17 (445.00) October -17 4Y8600000 (445.00) November -17 4Y8600000 50.00 50.00 50.00 12/21/17 (495.00) December -17 4Y8600000 25.00 25.00 25.00 2/1/18 (520.00) December B-17 4Y8600000 (520.00) January -18 4Y8600000 (520.00) February -18 4Y8600000 (520.00) March -18 4Y8600000 (520.00) April -18 4Y8600000 (520.00) May -18 4Y8600000 (520.00) June -18 4Y8600000 (520.00) July -18 4Y8600000 (520.00) Totals 520.00 520.00 520.00 4Y8600000 General ledger vs bullied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Selection Criteria Ledger CDLE Ledger 5230 WELD -15 Aug 18 Account €5231) 0000.6500.4Y86000000:. j 523x.0000.6500.4Y88000000.0000; t X5230.0000 6500 ItY86000000 O000 j 15230.0000.6500.4Y86000000.0000. Amount Type Project To Date Encumbrance Type ALL Account Level All Funds Budget Encumbrance Actual Available 30000_00 1 0.001 3426.8a! 16573.17, 0.00 0.001 0. ....__. 0.00 0.00 0.00 520 00 -520.00 0.00 0.001 1605317 1605317! Penod Balances'(PJTD) - Aug -1B Account J5230.0000.650o.4Y86000000.0000.0000000o( Funds Available ( Detail Balances ) ii Period ;Aug -16 Sep -16 1Oct-16 Nov -16 Dec -16 Jan -17 [Feb -17 EMar-17 Budget Encumbrance 30000.001 0.00I 000E 0.001': 000, 0.00„ 0.001 0.001 0.00; 0.00` 0.00 0.00 30000 00' 0.00 Account 15230.0000.6500.4Y86000000.0000.00000000( Period r I- :Jun -17 IAdj-17 lAug-17 Sep -17 'Oct -17 [Nov -17 ;Jan -18 Funds Available ( Detail Balances ) Budget 0.00; 0.001 0.00' 0.001 0.001 0.00, 0 00 0.00 0.00.3 0 0(o: Q Q03 0.001 Encumbrance 0 00' 000: 0.001 0.001 000' 0.001 0.001 0 OQ Actual �_ 0 Q00( 000 000 __. 0.001 0.00 000 0.00 0 Period Balances (PJTD) - Aug -18 2115.29i 13426.83. Actual 1215 55' 79 77 0001 1594_891 3853.84{ 4567.49 00& 0.00' 0.001 0.001 0.00,° 0.00 0.001 0.00= 000; 30000.00' i 0.001 13426.831 Funds Available 30000.00 111:- 0.00 0.00 .- 0.00 0.00 - 2115.29 16573.17' Funds Available -1215.55 -79.77 000 - 1594.89 - 3853.84 -4567.49 0 00" 0.00 000 0.00 16573.17 Account 5230.0000.6500.4Y86000000.0000. 00000000( Funds Available ( Detail Balances ) Period 1May-17 Jun -17 ;]Ad} -17 ;Jul -17 ;Aug -17 Sep-17��._ Oct -17 Nov -17 Dec -17 Budget 0.001 0.001 0.00[.. 0.00[ 0.00s 0.001 0.001 0.00 0.00 0.00. Encumbrance 0.00 0001 o.ao 0 00 0.00 0.00 I 000E - .: 0.001 0.001 0.00( Actual 751.80! 4178.981 0.00!1 2098151 1806.83' 1716.72; 2276.44 1473.48 1750.77,, 0.00 16053.17! Funds Available - 751.80 =-. 4- 178 98 0.00 -2098.15 -1806.83 -1716.72 -2276 44 - 1473.48 -1750.77 6053.17'. Cancel a Period Balances (PJTD) - Aug -18 ROM Account Period [Jun -17 Ad} -17 [Jul _ -17 :Aug -17 Sep -17 ']Oct -17 I[Nov 17 [Dec -17 ;Jan -18 5230.0000.6500.4Y86000000.0000.00000000(( Funds Available ( Detail Balances ) Budget 000: 0.00 00' 0.00 000!. 0.001 0.00`; o.o01 0.001 0.001 0.001 000[ 000; 0.00 !: 0.00 Actual 200.001 195.001 0.001 000' 2500! 2500 Funds Available - 200 00 -195.00 0.00 O00 -25.00 -25 00 0.00 50.00i -50.00 25 00 -25.00 0.00! 0A0 520.00' -520.00 Hello