The URL can be used to link to this page

Browse Search

Home My WebLink About20173941.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, 2016, through June 30, 2017, 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. GO: f -ISO, GZCT C 5C) oilt`@/tg 2017-3941 HR0088 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 22nd day of November, A.D., 2017. BOARD OF COUNTY COMMISSIONERS WELD CONTY, COLORADO ATTEST: ddatiov• j t'®' Weld County Clerk to the Board BY: G puty Clerk to the Board ` ... ounty Attorney Date of signature: lam/ Ju . Cozad, Chair Steve Moreno, Pro-Tem Barbara Kirkme er 2017-3941 HR0088 0_O n +ro► c+- -ro n i S O Co PRIVILEGED AND CONFIDENTIAL MEMORANDUM DATE: October 19, 2017 TO: Board of County Commissioners — Pass -Around FR: Judy A. Griego, Director, Human Services RE: Weld County Department of Human Services' 2016-17 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' 2016-17 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-F I, for all programs that have Expenditure Authorizations ending during the period of July 1, 2016 through June 30, 2017. 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, Chair Mike Freeman Barbara Kirkmeyer Steve Moreno, Pro-Tem t'iaa Approve Schedule Recommendation Work Session. Other/Comments: . 2017-3941 l Hto Sg Pass -Around MeinOiandurn; October 19; 2017 = CMS 1506 Page 1' COLORADO Department of Labor and Employment Finance 633 17th Street, Suite 1100 Denver, CO 80202-3660 Colorado Department of Labor and Employment Grant Closeout Check List Workforce Region / CLEAR Entity Code: Employment Services of Weld County- 5230 Address: P.O. 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 2017 (Aug 25, 2017) CLOSEOUT SUMMARY CHECK LIST: Please list all the funds with the period of performance ends in June 30th, 2017 (please do the attachment if applicable): Program Year CLEAR Program Code / Vax # CLEAR Program Code. Title/Grant Amount FY15 17C5 TAA CASE MANAGEMENT $8,172 FY16 2036 DVOP $7,000 PY15 2055 WAGNER PEYSER $505,362 PY15 2M55 10% WP-MSFW $26,675 PY15 2555 WP 10% SUMMER JOB HUNT $40,000 SFY17 2W26 ESF $413,682 SFY17 2W27 ESF $404,346 FY16 46A5 ADULT LOCAL ADMIN $38,721.11 FY16 46D5 DW ADMIN $18,281 FY16 48A5 ADULT LOCAL PROGRAM/TRAINING $408,127.79 FY16 48D5 DW PROGRAM/TRAINING $164,533 FY16 4BD5 DW LOCAL ADMIN $6983.10 PY15 4D95 25% ENHANCED DW $19,758 PY15 4DB5 DW LOCAL ADMIN $3,317 PY15 4DW5 WIA CWDC 5% DW COUNCIL INITIATIVE $20,490 FY15 4ED4 25% DW ENH ADMIN $6,422 FY15 4FD4 ENHANCED DW $57,800 FY16 4FD5 EDW PROGRAM $46,102 FY15 4GD4 WFD 3.75% TECH ASSIST LOCALS $12,500 If you have any questions or need assistance, please do not hesitate to contact: Sung Hong (phone: 303-318-8108 or e-mail: Sune.Hong@state.co.us), John Torres (phone: 303-318-8199 or email: john.m.torres®state.co.us), Natrada Rodrakam (phone: 303-318-8102 or email: natrada.rodrakam@state.co.us). COLORADO Department of Labor and Employment Finance 633 17th Street, Suite 1100 Denver, CO 80202-3660 FY16 4ND5 DW LOCAL PGR TRANSFER ADULT $164,533 FY15 4OD4 25% DW HIRE CO ADMIN $21,374 FY15 4PD4 25 %DW HIRE CO PROGRAM $187,535.79 PY15 4Y65 10% YOUTH LOCAL ADMIN $61,902 PY15 4Y75 YOUTH 75% OUT OF SCHOOL LOCAL $417,837 PY15 4Y85 YOUTH 25% IN SCHOOL LOCAL $139,278 Total $3,200,732 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 2017) 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 subrecipeint'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 natrada.rodrakam@state.co.us. 1 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: Julie A. Cozad Title: Chair Board of Weld County Commissioners NOV 2 2 2017 Date 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), John Torres (phone: 303-318-8199 or email: john.m.torres®state.co.us), Natrada Rodrakam (phone: 303-318-8102 or email: natrada.rodrakam®state.co.us). 0W7-.51 W 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:_ 06/30/2016 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 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 CERTIFICATION: I certify to the best of my knowl-dge and belief the above reported information is accurate and complete for the period reported. NOV 2 2 2017 Authorized Signature See instructions for completing this form on the next tab (Attachment E 2 of 2) Date Attachment E Page 1 of 2 020/ 7- 39// 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 prigram income was reported 2. Program Income Allocation- Cost Category (ies)/Budget Line Item (s): Enter the cost categories/budget line items that the amount reported on the Program Income Line Item will be allocated. Program Income Allocation - Income Amount: Enter the Income Budgeted amount for the expnditure of each cost category (ies)/budget line item (s) for the reporting quarter Program Income Allocation - Disbursed Income Expense: Enter the amount expended against the cost category (ies)/budget line item (s) through the reported calendar quarter end date. Total Net Program Income: Total progam Income amount and Income Disbursed/Expense columns. The Total Net Program. Income is program income earned but not expended The Amounts should equal the amount recorded in the Cash Request Line Item Amount. Authorised Signature and Date: Optional signature for subrecipient's reference. COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT EMPLOYMENT AND TRAINING PROGRAMS STAND-IN COST REPORT FORM (SICRF) SUBRECIPIENT:_ Employment Services of Weld County Incurred During Program Year Ended:_ 06/30/2017 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 PY16 $0.00 $0.00 $0.00 PY15 $1,145.00 $18,027.00 $19,172.00 PY14 $1,064.00 $16,754.00 $17,818.00 GRANT NAME WIA Dislocated Workers Current Prior Year Before Prior PY16 $0.00 $0.00 $0.00 PY15 $2,837.00 $16,022.00 $18,859.00 PY14 $862.00 $13,578.00. $14,440.00 GRANT NAME • WIA Youth Current Prior Year Before Prior PY16 $0.00 $0.00 $0.00 PY15 $1,298.00 $22,707.00 $24,005.00 PY14 $1,156.00 $20,457.00 $21,613.00 GRANT NAME WIA 10% Statewide Actv. Current Prior Year Before Prior PY16 - ., _ $0.00 PY15 $0.00 PY14 $0.00 GRANT NAME WIA 25% ENH. DW Current Prior Year Before Prior PY16 $0.00 $0.00 $0.00 PY15 $0.00 $0.00 $0.00 PY14 $98.00 $1,543.00 $1,641.00 GRANT NAME FED EUC Current Prior Year Before Prior PY16 $0.00 PY15 $0.00 PY14 $0.00 GRANT T NAME WIA NEG Current Prior Year Before Prior PY16 $0.00 $0.00 $0.00 PY15 $0.00 $0.00 $0.00 PY14 $64.00 $1,012.00 $1,076.00 GRANT NAME. WP 10% MSFW Current Prior Year Before Prior PY16 $0.00 .. 0.00 PY15 $0.00 0.00 PY14 $1,965.00 1,965.00 CERTIFICATION: I certify to the best of my knowl-.ge and belief the above reported information is accurate and complete for the period reported. orized Signature NOV 2 2 2017 Date ,2i917 -O9`741 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:_ 06/30/2017 CLEAR Program code: CMS#54599 Attachment F Page 2 of 3 GRANTS Program Year of Funds COST CATEG0RY(IES)/BUDGET LINE ITEM(S) Administration Program Other: Other: Total GRANT NAME H-18 TECH SKILLS TRAINING Current Prior Year Before Prior PY16 $0.00 $0.00 $0.00 PY15 $0.00 $0.00 $0.00 PY14 $24.00 $373.00 $397.00 GRANT NAME WIA Wagner Peyser Current Prior Year Before Prior PY16 $0.00 $0.00 PY15 $0.00 $0.00 PY14 , , $38,123.00 . $38,123.00 GRANT NAME WP 10% SJH Current Prior Year Before Prior PY16 $0.00 $0.00 PY15 $0.00 $0.00 PY14 $2,003.00 $2,003.00 GRANT NAME Vets DVOP Current Prior Year Before Prior PY16 $0.00 PY15 $0.00 PY14 _ 1, $0.00 GRANT NAME Vets LVER Current Prior Year Before Prior PY16 $0.00 PY15 ' $0.00 PY14 .'a • , ` • - ._ , , $0.00 GRANT NAME Ul Reemployement Svc Current Prior Year Before Prior PY16 ". r' ` $0.00 PY15 • $0.00 PY14 $0.00 GRANT NAME WP-ESF Current Prior Year Before Prior PY16 •_ _ • $0.00 $0.00 PY15 $0.00 $0.00 PY14 $11,549.00 $11,549.00 CERTIFICATION: I certify to the best of my knowledge and belief the above reported information is accurate and complete for the period reported. horized Signature See instructions for completing this form on the next tab (Attachment F 3 of 3) NOV 2 2 2017 Date 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: P.O. Box 1805 Greeley, CO 80632 Phone Number: 970-400-6537 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: o Noted ID 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. CUZI; Subrecipient ire or'- Signature N0V 2 2 2017 Date 02O/ 7-cg9Vl COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT CONTRACT CLOSEOUT TAX CERTIFICATION In the performance of Contract/Grant Agreement Number CMS #54599 , including the Expenditure Authorizations (EAs)/Work Plan awarded under said Contract/Grant Agreement, identified as CLEAR Program Code : 17C5000000 2036000000 2055000000 2M55000000 , 2S55000000 2W26000000 2W27000000 46A5000000 46D5000000 , 48A5000000 48D5000000 4BD5000000 4D95000000 4DB5000000 , 4DW5000000 4ED4000000 4FD4000000 4FD5000000 4GD4000000 , 4ND5000000 4OD4000000 4PD4000000 4Y65000000 4Y75000000 , 4Y85000000 I certify that I have complied with requirements of the law and the Colorado Department of Labor and Employment, regarding the obtaining of Grant Recipient Name: Employment Services of Weld County Grant Recipient Address: P.O. 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 oCo2 AID day of , 2017. Attachment I Page 2 of 6 GRANT RECIPIENT'S ASSIGNMENT OF REFUNDS, REBATES, AND CREDITS Grant Recipient's Name: Employment Services of Weld County Street Address: P.O. Box 1805 City and State: Greeley, Colorado Contract/Grant Agreement No: CMS # 54599 Pursuant to the terms of Contract/Grant Agreement Number CMS #54599 Expenditure Authorizations (EAs)/Work Plan awarded under said Contract/Grant Agreement, identified as CLEAR Program code(s) : 2M55000000 , 2S55000000 46D5000000 , 48A5000000 4DB5000000 , 4DW5000000 4GD4000000 , 4ND5000000 4Y75000000 , 4Y85000000 17C5000000 2W26000000 48D5000000 4ED4000000 4OD4000000 2035000000 2W27000000 4BD5000000 4FD4000000 4FD5000000 4PD4000000 4Y65000000 , including the 2055000000 46A5000000 4D95000000 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 day of 971, 2017. By ( ----- )11.-C, uthorized S.•T,iture Julie A. Cozad, Chair Title Board of Weld County Commissioners NOV 2 2 201? 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 thisday of , 2017. Title Julie A. Cozad, Chair, BOCC Attachment I Page 4 of 6 0Za/7.- e941 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT GRANT RECIPIENTS RELEASE Grant Recipient's Name:Grant Recipient's Name: Employment Services of Weld County Address: P.O. Box 1805 Greeley, CO 80632 Pursuant to the terms of Contract/Grant Agreement Number Authorizations (EAs)NVork Plan awarded under said Contract/Grant Agreement, as CLEAR Program code (s) 2M55000000 46D5000000 4DB5000000 4GD4000000 4Y75000000 4Y85000000 and in consideration of the sum of Total amount paid of 2S55000000 48A5000000 4DW5000000 4ND5000000 40D4000000 2W26000000 48D5000000 4ED4000000 CMS #54599 , Including the Expenditure 2W27000000 46A5000000 4BD5000000 4D95000000 4FD4000000 4FD5000000 4PD4000000 4Y65000000 $3,200,732.00 17C5000000 , 2036000000 , 2055000000 , $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 COLE, 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 3. CLEAR Program Code Invoice Date (If Known) Vendor Invoice or P.O. # Line Item Cost Category Amount Expected Payment Amount None Claims, together with reasonable expenses incidental thereto, based upon the liabilities of the Grant Recipient to third parties arising out of the performance of the said contract, which are not known to the Grant Recipient on the date of the execution of this release and of which the Grant Recipient gives notice in writing to the CDLE within the period specified in the said Contract/Grant Agreement. Claims after closeout, for costs which results from the liability to pay Unemployent Insurance costs under a r-imbursement system or to settle Worker's Compensation claims. This release has been executed this day of By Title ,2017. Authorized Sign Julie A. Cozad, Chair, ROCC Attachment I Page 5 of 6 COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT PHYSICAL INVENTORY LIST Grant Recipient Name: Employment Services of Weld County 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. This Physical Inventory List has been executed this By ouitl° Authorized Signat day of / • 2017 Title Julie A. Cozad, Chair, BOCC Revised: 6/05 3 2017-PGL-Attachment-E-F-H-I WFD Regional Budget Report Period: Jun -17 Entity: 5230 Unit Program Program Description Activity Budget Amount Actual Amount Balance Not Used(0000) 17C4000000 TAA CASE MANAGEMENT FFY13 Not Used(0000) 1,637.36 1,637.36 0 Not Used(0000) 17C5000000 TAA CASE MANAGEMENT FFY1S Not Used(0000) 8,172.00 8,172.00 0 Not Used(0000) 17C6000000 NON-WIOA-TAA CASE MANAGEMENT FFY16 Not Used(0000) 5,400.00 870.26 4,529.74 Not Used(0000) 2035000000 FY15 DISABLED VETS OUTREACH PROG Not Used(0000) 2,000.01 2,000.01 0 Not Used(0000) 2036000000 FY16 DVOP Not Used(0000) 7,000.00 6,999.99 0.01 Not Used(0000) 2054000000 PY14 WAGNER PEYSER Not Used(0000) 216,631.68 216,631.68 0 Not Used(0000) 2055000000 PY15 WAGNER PEYSER Not Used(0000) 531,185.00 505,362.00 25,823.00 Not Used(0000) 2056000000 PY16 WAGNER PEYSER Not Used(0000) 501,535.00 189,535.93 311,999.07 Not Used(0000) 20D7000000 FFY17-DISABLED VETS OUTREACH PROG Not Used(0000) 7,000.00 5,133.31 1,866.69 Not Used(0000) 2886000000 UI-RESEA Expenditures -Mary Ball grant Not Used(0000) 55,100.00 45,075.00 10,025.00 Not Used(0000) 2887000000 Ul-RESEA Expenditures -Mary Ball grant -92887 Not Used(0000) 1,485.00 0 1,485.00 Not Used(0000) 2M54000000 10% MIGRANT SSNLWRKR-PY14WP Not Used(0000) 27,933.00 27,933.00 0 Not Used(0000) 2M55000000 10% MIGRANT SSNL WRKR-PY15WP Not Used(0000) 26,675.00 26,675.00 0 Not Used(0000) 2554000000 PY14-WP10% SUMMER JOB HUNT PY14WP Not Used(0000) 17,621.92 17,621.92 0 Not Used(0000) 2S55000000 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 25,474.47 14,525.53 Not Used(0000) 2W26000000 ESF-SFY16-WFD ESF ONLY -NO CRWC Not Used(0000) 413,682.00 367,862.39 45,819.61 Not Used(0000) 2W27000000 ESF-SFY17- 7/1/2016 to 6/30/2017-WFD ESF ONLY -NO CRWC Not Used(0000) 404,346.00 365,836.38 . 38,509.62 Not Used(0000) 4361000000 WDP H -1B TECH SKILLS TRAINING Not Used(0000) 5,985.57 1,210.57 4,775.00 Not Used(0000) 4361000000 WDP H-18 TECH SKILLS TRAINING WIA-Direct Training Local Program(8000) 0 4,775.00 -4,775.00 Not Used(0000) 4423000000 WIA-COUNTY PROG NEG FLOOD-PY13 Not Used(0000) 1,937.53 1,937.53 0 Not Used(0000) 46A4000000 WIA FY15 - ADULT LOCAL ADMIN Not Used(0000) 32,351.83 32,351.83 ' 0 Not Used(0000) 46A5000000 WIOA FY16 - ADULT LOCAL ADMIN Not Used(0000) 38,721.11 38,721.11 0 Not Used(0000) 46A6000000 WIOA FY17 - ADULT LOCAL ADMIN Not Used(0000) 33,453.00 7,617.24 25,835.76 Not Used(0000) 46D4000000 WIA FY15 - DW LOCAL ADMIN Not Used(0000) 10,010.36 10,010.36 0 Not Used(0000) 46D5000000 WIOA FY16 DW- LOCAL ADMIN Not Used(0000) 18,281.00 18,281.00 0 Not Used(0000) 46D6000000 WIOA FY17 DW- DW LOCAL/COUNTIES ADMIN Not Used(0000) 24,759.00 0 24,759.00 Not Used(0000) 47D6000000 WIOA FY17- 25% DW ENHANCED ADMIN LOCAL/COUNTIES Not Used(0000) 15,759.00 0 15,759.00 Not Used(0000) 48A5000000 WIOA FY16 - ADULT LOCAL PROGRAM Not Used(0000) 408,127.79 209,338.00 198,789.79 Not Used(0000) 48A5000000 WIOA FY16 - ADULT LOCAL PROGRAM WIA-Direct Training Local Program(8000) 0 182,658.00 -182,658.00 Not Used(0000) 48,46000000 WIOA FY17 - ADULT LOCAL PROGRAM Not Used(0000) 301,080.00 72,487.07 228,592.93 Not Used(0000) 48A6000000 WIOA FY17 - ADULT LOCAL PROGRAM WIA-Direct Training Local Program(8000) 0 72,387.56 -72,387.56 Not Used(0000) 48D4000000 WIA FY15 - DW LOCAL PROGRAM Not Used(0000) 29,290.97 11,950.13 17,340.84 Not Used(0000) 48O4000000 WIA FY15 - DW LOCAL PROGRAM WIA-Direct Training Local Program(8000) 0 17,340.84 -17,340.84 Not Used(0000) 48D5000000 WIOA FY16- DW LOCAL PROGRAM Not Used(0000) 164,533.00 124,092.22 40,440.78 Not Used(0000) 4805000000 WIOA FY16- DW LOCAL PROGRAM WIA-Direct Training Local Program(8000) 0 40,440.78 -40,440.78 Not Used(0000) 4806000000 WIOA FY17- DW LOCAL/COUNTIES PROGRAM Not Used(0000) 222,839.00 20,416.38 202,422.62 Report Type: PJTD Not Used(0000) 49D6000000 WIOA FY17-25% DW ENHANCED PROG LOCAL/COUNTIES Not Used(0000) 141,840.00 0 141,840.00 Not Used(0000) 4A65000000 WIOA PY15 - ADULT LOCAL ADMIN Not Used(0000) 3,972.00 3,972.00 0 NotUsed(0000) 4A66000000 WIOA PY16- ADULT LOCAL ADMIN NotUsed(0000) 4,881.00 0 4,881.00 Not Used(0000) 4A85000000 WIOA PY15 - ADULT LOCAL PROGRAM Not Used(0000) 35,748.00 12,424.36 23,323.64 Not Used(0000) 4A85000000 WIOA PY15 - ADULT LOCAL PROGRAM WIA-Direct Training Local Program(8000) 0 23,323.64 -23,323.64 Not Used(0000) 4A86000000 WIOA PY16 - ADULT LOCAL PROGRAM Not Used(0000) 43,934.00 31,552.79 12,381.21 Not Used(0000) 4A86000000 WIOA PY16 - ADULT LOCAL PROGRAM WIA-Direct Training Local Program(8000) 0 12,381.21 -12,381.21 Not Used(0000) 4804000000 WIA FY15 - LOCAL ADMIN TRANSFER ADULT Not Used(0000) 23,607.00 23,607.00 0 Not Used(0000) 4805000000 WIOA FY16 DW-LOCAL ADMIN TRANSFER ADULT Not Used(0000) 6,983.10 6,983.10 0 Not Used(0000) 4806000000 WIOA FY17 DW-LOCAL/COUNTIES ADMIN TRANSFER ADULT Not Used(0000) 15,000.00 0 15,000.00 Not Used(0000) 4065000000 WIOA PY15-DW LOCAL ADMIN Not Used(0000) 3,317.00 3,317.00 0 Not Used(0000) 4066000000 WIOA PY16-DW LOCAL ADMIN Not Used(0000) 7,462.00 0 7,462.00 Not Used(0000) 4075000000 WIOA PY15- 25% DW ENHANCED ADMIN LOC Not Used(0000) 2,195.00 2,195.00 0 Not Used(0000) 4085000000 WIOA PY15- DW LOCAL PROGRAM Not Used(0000) 29,853.00 11,329.32 18,523.68 Not Used(0000) 4085000000 WIOA PY15- DW LOCAL PROGRAM WIA-Direct Training Local Program(8000) 0 18,523.68 -18,523.68 Not Used(0000) 4086000000 WIOA PY16- DW LOCAL PROGRAM Not Used(0000) -67,159.00 0 67,159.00 Not Used(0000) 4D95000000 PY15 25% ENHANCED DISLOCATED WORKER Not Used(0000) 19,758.00 4,827.76 14,930.24 Not Used(0000) 4D95000000 PY15 25% ENHANCED DISLOCATED WORKER WIA-Direct Training Local Program(8000) 0 14,930.24 -14,930.24 NotUsed(0000) 4DB5000000 WIOA PY15-LOCAL ADMIN TRANSFER ADULT NotUsed(0000) 3,317.00 3,317.00 0 Not Used(0000) 4DN5000000 WIOA PY15 - LOCAL PROG TRANSFER ADULT Not Used(0000) 29,853.00 656.72 29,196.28 Not Used(0000) 4DN5000000 WIOA PY15 - LOCAL PROG TRANSFER ADULT WIA-Direct Training Local Program(8000) 0 29,196.28 -29,196.28 Not Used(0000) 4DW5000000 WIA CWDC PY15 - 5% DW COUNCIL INITIATIVES Not Used(0000) 20,490.00 20,490.00 0 Not Used(0000) 4DW6000000 WIA CWDC PY16 - 10% DW COUNCIL Not Used(0000) 15,750.00 0 15,750.00 Not Used(0000) 4ED4000000 WIA FY15 -25% DW ENHANCED ADMIN TO LOCAL Not Used(0000) 6,422.00 6,422.00 0 Not Used(0000) 4ED5000000 WIOA FY16-25% DW ENHANCED ADMIN TO LOCAL Not Used(0000) 7,995.00 5,122.00 2,873.00 Not Used(0000) 4FD4000000 WIA FY15 -25% DW ENHANCED PROGRAM TO LOCAL Not Used(0000) 57,800.00 57,800.00 0 Not Used(0000) 4FD5000000 WIOA FY16-25% DW ENHANCED PROGRAM TO LOCAL Not Used(0000) 71,968.00 46,102.00 25,866.00 Not Used(0000) 4FF6000000 FY17 WFD-APP-LOCAL-Apprenticeship Not Used(0000) 10,219.00 0 10,219.00 Not Used(0000) 4GD4000000 WIA FY15-WFD-3.75Y Tech Assist Locals Not Used(0000) 12,500.00 12,500.00 0 NotUsed(0000) 4ID5000000 WIOAFY16-25%DW-WIOATRANISITIONALACTIVITIES NotUsed(0000) 5,109.00 0 5,109.00 Not Used(0000) 4KD3000000 WIA FY14 - 25% DW ENHANCED PROGRAM Not Used(0000) 48,785.00 34,165.05 14,619.95 Not Used(0000) 4KD3000000 WIA FY14 - 25% DW ENHANCED PROGRAM WIA-Direct Training Local Program(8000) 0 14,619.95 -14,619.95 Not Used(0000) 4LD4000000 CWDC-fy15 3.75% perform incentive Not Used(0000) 16,971.00 16,971.00 0 Not Used(0000) 4ND4000000 WIA FY15 - LOCAL PROG TRANSFER ADULT Not Used(0000) 132,219.86 62,020.79 70,199.07 Not Used(0000) 4ND4000000 WIA FY15 - LOCAL PROG TRANSFER ADULT WIA-Direct Training Local Program(8000) 0 70,199.07 -70,199.07 Not Used(0000) 4ND5000000 WIOA FY16 DW- LOCAL PROG TRANSFER ADULT Not Used(0000) 164,533.00 102,882.55 61,650.45 Not Used(0000) 4ND5000000 WIOA FY16 DW- LOCAL PROG TRANSFER ADULT WIA-Direct Training Local Program(8000) 0 61,650.45 -61,650.45 Not Used(0000) 4ND6000000 WIOA FY17 DW-LOCAL/COUNTIES PROG TRANSFER ADULT Not Used(0000) 135,000.00 22,211.98 112,788.02 Not Used(0000) 4ND6000000 WIOA FY17 DW-LOCAL/COUNTIES PROG TRANSFER ADULT WIA-Direct Training Local Program(8000) 0 4,981.32 -4,981.32 Not Used(0000) 4004000000 WIA FY15 -25% DW - LTU / Hire for Colorado-ADMIN TO Not Used(0000) 21,374.00 21,374.00 0 Not Used(0000) 4PD4000000 WIA FY15 -25% DW LTU / Hire for Colorado -PROGRAM TO Not Used(0000) 187,535.79 187,535.79 0 Not Used(0000) 4535000000 WFD-PY15-SPNEG-GRANT PLANNING Not Used(0000) 80,257.00 37,861.12 42,395.88 Not Used(0000) 4545000000 WFD-PY15-SPNEG-LOCALADMIN Not Used(0000) 57,346.00 53,611.78 3,734.22 Not Used(0000) 4555000000 WFD-PY15-SPNEG-LOCAL PROGRAM Not Used(0000) 674,688.00 381,295.78 293,392.22 Not Used(0000) 4TD4000000 WIA FY15 - 25% taa case mgmt Not Used(0000) 28,172.00 20,000.00 8,172.00 Not Used(0000) 4Y64000000 WIAPY14-YOUTH LOCAL ADMIN Not Used(0000) 36,935.91 36,935.91 0 Not Used(0000) 4Y65000000 WIOA PY15 - 10% YOUTH LOCAL ADMIN Not Used(0000) 61,902.00 61,808.92 93.08 Not Used(0000) 4Y66000000 WIOA PY16-10%YOUTH LOCAL ADMIN Not Used(0000) 30,956.00 10,381.73 20,574.27 Not Used(0000) 4Y74000000 WIA PY14 - YOUTH OUT -SCHOOL LOCAL PROGRAM Not Used(0000) 38,185.71 28,306.72 9,878.99 Not Used(0000) 4Y74000000 WIA PY14 - YOUTH OUT -SCHOOL LOCAL PROGRAM WIA-Direct Training Local Program(8000) 0 9,878.99 -9,878.99 Not Used(0000) 4Y75000000 WIOA PY1S - YOUTH MIN -75% -OUT -SCHOOL LOCAL Not Used(0000) 417,837.00 223,691.48 194,145.52 Not Used(0000), 4Y75000000 WIOA PY15 - YOUTH MIN -75% -OUT -SCHOOL LOCAL WIA-Direct Training Local Program(8000) 0 161,492.01 -161,492.01 Not Used(0000) 4Y75000000 WIOA PY15 - YOUTH MIN -75% -OUT -SCHOOL LOCAL YOUTH -20% -OUT -SCHOOL -WORK EXPERIENCE(8100) 0 32,599.51 -32,599.51 Not Used(0000) 4Y76000000 WIOA PY16 - YOUTH MIN -75% -OUT -SCHOOL LOCAL Not Used(0000) 448,607.00 153,198.70 295,408.30 Not Used(0000) 4Y76000000 WIOA PY16 - YOUTH MIN -75% -OUT -SCHOOL LOCAL WIA-Direct Training Local Program(8000) 0 126,782.46 -126,782.46 Not Used(0000) 4Y76000000 WIOA PY16 - YOUTH MIN -75% -OUT -SCHOOL LOCAL YOUTH -20% -OUT -SCHOOL -WORK EXPERIENCE(8100) 0 47,113.67 -47,113.67 Not Used(0000) 4Y84000000 WIA PY14 - YOUTH IN -SCHOOL LOCAL PROGRAM Not Used(0000) 110,579.23 54,257.81 56,321.42 Not Used(0000) 4Y84000000 WIA PY14 - YOUTH IN -SCHOOL LOCAL PROGRAM WIA-Direct Training Local Program(8000) 0 56,321.42 -56,321.42 Not Used(0000) 4Y85000000 WIOA PY15 - YOUTH MAX -25% -IN -SCHOOL LOCAL PROGRAM Not Used(0000) 139,278.00 67,736.63 71,541.37 Not Used(0000) 4Y85000000 WIOA PY15 - YOUTH MAX -25% -IN -SCHOOL LOCAL PROGRAM WIA-Direct Training Local Program(8000) 0 29,012.06 -29,012.06 Not Used(0000) 4Y85000000 WIOA PY15 - YOUTH MAX -25% -IN -SCHOOL LOCAL PROGRAM YOUTH -20% -IN -SCHOOL -WORK EXPERIENCE(8200) 0 42,529.31 -42,529.31 Not Used(0000) 4Y86000000 WIOA PY15 - YOUTH MAX -25% -IN -SCHOOL LOCAL PROGRAM Not Used(0000) 30,000.00 3,410.61 26,589.39 Not Used(0000) 4Y86000000 WIOA PY15 - YOUTH MAX -25% -IN -SCHOOL LOCAL PROGRAM WIA-Direct Training Local Program(8000) 0 395 -395 Not Used(0000) 4Y86000000 WIOA PY15 -YOUTH MAX -25% -IN -SCHOOL LOCAL PROGRAM YOUTH -20% -IN -SCHOOL -WORK EXPERIENCE(8200) 0 4,930.78 -4,930.78 Not Used(0000) 4YW4000000 WIA CWDC PY14 - 3.75%YOUTH COUNCIL INITIATIVES Not Used(0000) 1,000.00 1,000.00 0 Total 7,123,827.73 5,312,973.77 1,810,853.96 WIA/WP Tracking Period: May 2017 Month 6 Funding Expended -0000 . Pending EA Program Acct/Activity Project Contract Period Desc Budget Disbursed as of 06/30/16 Jul -16 Aug -16 Sep -16 Oct -16 Nov -16 Disbursements Dec -16 Jan -17 Feb -17 Dec 6-16 Mar -17 Apr -17 May -17 Jun -17 Total Disbursements Adjustments Balance Average Monthly Spending Average spending needed for 30% carry-over Closed Last Reimbursemen t Start End 408500000".6500..`•:-PY15WIOA Adult- i d 07/01/15 06/30/17 PY15 OW.TransferAdult Admin : -.1-=3,317.001 '`.';+•_'0.00' ;.3;317.00.'..."'-L0.00 ''.1;.0.00. 0;.._0.00 `.-.•:0.00 r 0.00= '-'0.OOr •--`.0.00 -. .•.0.00"•.. ^.y 0.00^ .. " 0.00 r,. ,.^.".:0.00 ..0.00...:-":3,317:00' _ -. .'"0.00'-.-•3,317.00: ,3'0.00•.__7/31/2016 46A500000 6500 FY16 WIOA Aduh 07/01/15 06/30/17 F/16 Admin 43,555.00 17,121.27 772.19 2,157.15 2,688.17 0.00 2,860.15 2,678.24 0.00 598.75 3,135.35 1,824.36 2,330.07 2,555.41 484500000 6500 FY16 WIOA Adult 07/01/15 06/30/17 FY16 Program 183,003.60 23,765.67 12,544.13 16,131.79 38,721.11 .4,833.89 0.00 6,453.52 -2,177.75 235,445.19 16131.79 484500000'28000•'-r.' :.-FY36.WIOA'Adult.: 1 •�, — ...-;,07/01/15' 06/30/17'FY16 Training' ,__ t• .,..• =-.' ; 166,980.54'-'._. 2993.82-" .4;708.24'7 -,s -r'^• ".- ,_ -.. ,. . ,. -' •- - - .. �. ., .. .. .• •172,682.60., ..,-- - - '. :a = �:-r �-:'.408,127.79 `.'8/31/2016 - FY16 WIOA Adult -Total �- ... .. - :-.' - 07/01/15 _.-- -'07/01/15 06/30/17' 'FY16 Program &Training Total ,-•,.-' 391,996.00 ' , 349,984.14,. 24,759.49.._ '17,25237' - ,:. 0.00 .' , 0.00- ., '-0.00+, - 0.00...-. -0.00 ;.'; goo.' .-0.00:" 10.00.. . "0,00----,`.'" 0.00.. .16,131.79 -, - -', -16,131.79. . 68,02130. ••-11,144.221 •.. - . - • -000 ,. ., • ; ,. :... .:. . � . ... c..., .: -. .°�.M1 .., r. , . � - ^.0.00 ...` z. •. .. •car ,0.00 46D500000 6500 FY16 WIOA Dislocated Worker 07/01/15 06/30/17 FY16 Admin-Adult Tranfer 18,281.00 3,317.00 0.00 0.00 0,00 -=1.83: -L833:0 1,833.05 5,150.05 13,130.95 858.34 -914.05 4ND50D000 •6500 -•' ;.FY16 WIOA DI loated Worket• ' '' 07/01/15,..• 06/30/17 ','' - ' - -" 14,75.01:-;:`'..15;65a39 - -13,681.24' 0- 9 ,, ,.. ',-•�;FY16 Program-AdultTransfe .. 0:00' .- ,, 0.00;;•-.• 513;923.74-.74,520,21 6585 y087 11 50.43`•. 10438.36._'11378.11,". .: .006.. , ,. . :•..., •.:-, :0700;, _ _, ra 0000 .-_... r..,t _ . ,, ,..; r, .. .. ,� .,- 0000, _,._,r,. ,., , Worker 1 0000. , : • .. _ „ _ :+ - P �.. _000 , .. 4: ,.. ' .• :.1:-,.., 2.890.00 -;' 15'300.05., .� ... , 4ND500000 8000 c; ,. FY36WIOA Dislocated WoYke ,..,07/01/15 .06/30[17. FY16 Training Adult Transfer :.-b. . ,. 000, 0.00 0.00 0.00.,,..11;860.78_ 6,205.10 _ .,-. .' 000,, ,.,,:5,434.26 .,9,329.50 3,I 7.65• 7,583 1. •t4 . .- ' 1102,882:55--- _ n., .. '- .:`61,650.45_., •'. + _ : - � � � Vic.' : h- -: ; _. �. :.:i.v ,_ _ 00.00., -.,.:, -., ', - . • °0 000 _ _, —. ;: ",,,,,,,.27,511.17 .S. ., .. 4440500000 _--.FYI6 WIOA Dislocated Worker., .,-07/01/35 06/30/37-.FY38�Tralnlnp-: r; ;-. ,. ,._Y=; ,;,164,533.00. ,,�, ..0.00.....0:00 c. 4,755.01 �-, 19,886.34:-�',19,358.00 `. 23,849.71 -d_9,83L73:�°19,533:54...13,328.34`-.16,178.16- MOO:- `"0.00.,:: ��',:0.00 _,"'_`,,L'0.00;: :: 27,42Z17,‘".(-,,,4;113.33., .. .. .. .'164,533.00. M1 - „ ,. .. .. _. _ _ .• ... 4A6600000 6500 PY16 WIOA Adult 07/01/16 06/30/18 PY16 Admin 4,881.00 0.00 0.00 0.00 0.00 4,881.00 0.00 569.45 4486OOOOO-'265OO ' ".PY16, WIOA Adult. `• :.:- � '�-'07/01/16 '..,`06/30/18,` Py16 Program . . t. ' 0.01 `_' ,-4.00 . : .. •i. ,�._- • _ ., - 4,073,50.. •^.'27,479.29 - , ' " 0 ". .. - .. .;: '.. • .:. .- _ -.� ' _i ,..^:..1 4A8600000 - 8000 _ .-PY16 WIOA Adult _., ... 07/01/16 /30 18 � �- � • _ '- �. -". O6 / M6TninmB !--:0.00.^'-. ? 0.00 -� 0.00. 4 '9;867.35 ' � `2,513.86 •. -' 31,552.79, - i i' .. 2, 381.21 . k s. - � '+ - .-448600000,, 448600000,;: ",_ -1 ,- _'PY16 WIOA Adult -Total,_-' +.:, 07/01/16 06/30/18 . PY16 Program & TmLring.Total._.: .43,934.00 :-. :. 10.00... �.: .0.00 :. - ..0.00_ :0.00 '_ ,;;0.00.4 ••0.00 -0'=0.00-_ ±0,00:'- ' 0.00---- O.00a 4,073.50.''.'237,346.64-7.2,513.86 . .0.00 -_-._43,934.00 ,. .. ..,, .'0.00 - :7,322.33.. '=2,196.70-3..-, .. .. �, .-. .�. ,. „ •00,,00 . , : - -,. r -.:, 0000 .. , ., .. >. ,, . _. . - _ 464600000 6500 FY17 WIOA Adult 07/01/16 06/30/18 FY17 Admin 33,453.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 7,617.24 484600000 6500 FY17 WIOA Adult 07/01/16 06/30/18 FY17 Program 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 28,899.01 43,588.06 484600000 8000 FY17 WIOA Adult 07/01/16 06/30/18 FY17 Training 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 27,294.74 45,092.82 7,617.24 25,835.76 72,487.07 72,387.56 Total FY17 WIOA Adult 301,080.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 144,874.63 156,205.37 0000 .., .. .. .., .., ...• • a 1" ' .. ., _ - -1 c . vH"• 4 - . ... . _ .. - - _ ... ! -0.00 v .. .. C 480600000 6500 FY17 WIOA Dislocated Worker 07/01/16 06/30/18 FY17 Admin-Adult Tranfer 15,000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 460600000 6500 FY17 WIOA Dislocated Worker 07/01/16 ' 06/30/18 FY17 Program -Adult Transfer 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 22,211.98 4%0600000 8000 FY17 WIOA Dislocated Worker 07/01/16 06/30/18 P/17 Training -Adult Transfer 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4,981.32 0.00 15.000.00 0.00 0.00 FY 17 Adult DW Transfer 135,000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 135,000.00 _000 ,_ , . :.,.. - - ,.61902.00:. ,,: .. ..,, ,- .. ' 4y650000 , : 6500 . ' P515 WIOA.Youth ' +' - _' 07/01/15 06/30/17:PY15*Admin , -. , . _ . '3941153 . 5,710,01 ..:'3387.00..: •' 3,803,03 0.00- 3,751.05 4,722.02' -. 1,88737 . 6,214,81 .11,613,18,• , - • 45750000. 8100 1 -.. ' P515 WIOAYOS 20% :r_1� .;•07/01/15 1.06/30/17,-. R75,WIOA Youth 20%-. , .i- 83,568.00'', -, „60,987.52„� 341747 ., 4,118:83 , - 45750000. '-6500 '' ,PY15 WIOA Youth " is -. ,:07/01/15_. 06/30/17, '4,,Y15 505 -Nog -. -. `, :•, _ _ ,• 204;362-30".. 7,094,88. - 12 288.30 - * -. 7 3 1 . 6 _ . , .. _.."' , .. 3• -. .., 1 Youth.. 45750000:-,-'8000 :-'PY15 WIOA Voutfi � � s .. •n+--. 07/01/15 .'"06/30/17 .:. PY15�Y05-Trng - i' .., .,- :. • :' ". -,. ..120.635:51 : "4:732.49 i., 0.00 ;.:•. . -1 _ _ .. .. � .. _ ', ,' : - _ -- <r' - ",61;902,00. _ 0.00 - 79317,00 „-,--3,095.10^ -.68,523.52. _ :223;745:48 J - 125,568.00 _ - ^•: , ':: .'- ... 'P Youth ,4...-;t;% 07/01/15 ." 06/30/17.•1' SYOS-Tm & Totals,: '.:- ',., - 4 7. 3 _-: >_ 0:0,:- 0` .00 ---, .' 0.00 ,. ,10.00. :0.00 0.00,,'- 0.00 0.00,-7,, - v.- 0.00 . _ .0.00. 45750000 , . Y15WIOA Yo OS Totals ,.,PY3 p Pmp ., ,._ :417,83700 . 386,185:33 15,244.51 16,10 I 0.00. 0.00 , .,• 0 ` �. .. ""' .. 417 37.00 . .: „ ..._..0.00.: 6963950 x' _ :10,445.93 '' ; 8/31/2016 � ,B `' ' ' , 45660000 6500 PY16 WIOA Youth 07/01/16 06/30/18 PY16Admin 30,956.00 0.00 0.00 0.00 0.00 0.00 45760000 6500/8100 PY16 WIOA YOS 20% 07/01/16 06/30/18 PYI6 WIOA Youth 20% 0.00 0.00 1,921.36 2,495.38 2,242.22 3,542.96 3,846.02 2,308.71 4,399.59 945.94 45760000 6500 PY16 WIOA Youth 07/01/16 06/30/18 PY16 Y05 -Frog 0.00 0.00 0.00 19,655.1.5 17,198.62 21,502.88 21,587.04 10,590.11 20,223.49 15,728.07 45760000 8000 PY16 WIOA Youth 07/01/16 06/30/18 PY16 YOS-Tmg 0.00 - 0.00 18,069.50 7,772.31 880.92 7,004.09 15,779.59 6,030.00 15,420.96 8,905.78 2,341.72 3,325.39 3,817.28 897.34 3,930.07 10,381,73 47,113.67 169,201.34 126,782.46 20,574.27 1,730.29 1,881.25 - 4,936.00 7,89036' - 8,655.06 15,342 30; 23,300.57 -• 3,662.57 12,059.42' ` 16,640.71 , - 14,429.79 .. . i -- - ^ '• .410.54 3,789.39 4Y760000 PY16 WIOA Youth OS Totals 07/01/16 06/30/18 P516 YOS-Trap& Pro9 Totals 363,955.00 0.00 0.00 19,990.86 29,922.84 20,321.76 32,049.93 41,212.65 18,928.82 40,044.04 25,579.79 32,337.72 47,831.64 26,747.42 8,130.00 343,097.47 20,857.53 57,182.91 -7,360.75 - "_ ,_ •.. •.:,; 0000 ,- :. t'....- 45850000 6500/8200 - PV15:WIOA yl520% :.'.:' : :07/01/15- '06/30/17., P515 WIOA Youth. 20% ;--:-27,8554,31 ,- 59,844.06 -,4,077.59- , 5,91654."21;796.34` _1,139.85 1,631-02' 449956- •1,143.23 .1,736.58 630,98-, 761.39':' 2,007.02_ _ - .. s PY15 YIS'-Pr _ ' ' - "' F 718.67' 4,150.01 9920.13 4Y850000 6500'.'+ PY35 WIOA Youth' i. 07/Ol/15, 06/30/17 = og -; _.i -- •--29,340.20'•1,896.09 6;056:OS,�x- 6,601.95'6,565:73-� 6,177.13 6,555:11.4;170:57 .4;698.70'', 4, - .. a _ ., ., 45850000:•-- 8000:.' ,'-'PY15WIOA youth_.', "..-4-' •,07/01/15'_ 06/30/17-': PY15 YIS-Tmg _,. .•-,•.'•: -A- -510.00,„ _ : ,� 0.00 _._ .^. `426.36 .• 25.00 ,r. + .. 95.00 .:.. .0.00:' A'. 349.60' :.••1274.00 _ 82,184.16 , _ •. ,, , J _ _ - , ,. `-27,756.50 c --1,� .. 45850000-•-. ;.:. ;..'::P515:Youth In School .Totals. :-, ''"'-107/01/15.. 06/30/17.. Muhl Tod&' Prop totals , ,,;'-.139,278.00 ,_. 59,077.82., -?6,663.66,,, 11,462.59........8,398.29--:.. 6,565.73-. -; `6,603.49 `:•r 6,580.11 -4,170.57.5:4,793.70'-.4,718.67•x.'4,499.61.—..5,194.13.. . 0.00 i.. .:0.00. 139,278.00...-. _ ,.. .. ., 0.00.,, 23,213.00 '-'+-..4,356.68.,: • ,,, 45860000 6500/8200 PY16 WIOA YLS 20% 07/01/16 06/30/18 PY16 WIOA Youth 20% 0.00 0.00 0.00 751.80 4,178.98 45860000 6500 PY16 WIOA Youth 07/01/16 06/30/18 PY16 YIS-frog 0.00 0.00 0.00 2,115.29 1,215.55 79.77 45860000 8000 PY16 WIOA Youth 07/01/16 06/30/18:' P516 YIS-Trng 0.00 0.00 0.00 200.00 195.00 4,930.78 3,410.61 395.00 45860000 PYI6 Youth In School Totals 07/01/16 06/30/18 Inschl Top& Prop totals 114,652.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2,115.29 2167.35 274.77 8,736.39 105,915.61 1,456.07 14,304.00 - _ _ _ _ - � �" _ , •- . _ 406600000 6500 PY16 WIOA Dislocated Worker 07/01/16 06/30/18 PY16 Admin 7,462.00 0.00 0.00 0.00 40860000 6500 PY16 WIOA Dislocated Worker 07/01/16 06/30/18 PY16 Program 0.00 0.00 0.00 4D8600000 8000 PY16 WIOA Dislocated Worker 07/01/16 06/30/18 PY16 Training 0.00 0.00 0.00 0.00 7,462.00 0.00 870.57 0.00 0.00 408600000 PY16 WIOA Dislocated Worker 07/01/16 06/30/18 -P516 Training 67,159.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 67,159.00 0.00 9,402.26 .,0 1 .: .. .. ... _. .. '-1, 00,:,00 ._ - .: t ._.,.:, 1 .. .. ., . ,,. .. ': ... 0000-:-. -rs .;", 1,.,t �. i'.. s . �..,, .. . . I F , - - - - - , ,, :;;'12/31/16, ITU Adm .:.. .. ..-u_. -.. .,: .;1_ _, ,.. , ' � ' �:� 4004.0000 . �, , , . r.FY15;25%Enhanced DW Hire CO , 02[23/16 , Admin , �; g. _ 9,956:00.., 3,237,09, 1,209.02 .. 2,210.93,_ .2,891.17 . 0.00-� 1,754.94 652.85 ..' u- .. . ._ _ - :Hire ., +..'...' , '1-2' 2 ''., 4P040000.:..,: „ .:- FY1525%Enhanced DWW-Nue CO '02/23/16 - 12/31/16 LTU Program .: .., 000 0 ,.: 89,611.00' , 15,804.36.--+4,1%.71' 19,039:9928,055.69.42,479 -.77::. -J.8,531.85, -x'1,50163 -T " :•: - -''tR 0 0 0 0. .. . _ • -. �, 9,9 600 5 : �' �_ 0.00... '..1659.33: 1' �, 89,611.00 -- -- ., .:0.00 • .-14,935.17 -.. Wit, - - . _ - _.. _ .. . _ - .• 0000. 4 .. :•,.., 453500000' 6500/7000; ' FY15Sectors NEG .$.. ; :>> 08/24/15 ' 06/30/17.. : PY15 Admin , .. - " :,,'22,782.00- 28,478.27 '''''.• 1 :':. 668.51 :: - - • 454500000 6500) ,: Fy155eRors NEG. ;` ^---! :;' 08/24/15 _06/30/17- PY 15 Planning• ..',30725.00 .22782.00 • = 0.00 ;-0.00 .. . '. .6500- - -. • •' FY ars N G'- : • - ,m'. 4 -' 06/10/17.' PY 15 Program' - .' -i'; . ' : -.. _. _ •.. ,y r - - ,208,587.0 455500000 _ 6500 15 SeR E ... _ 08/2 /15og _ 208,587.00 180,60110 .: • 513.68' '-,8,313.71 • •15,847.95 3,310.56 .� . • • �: ' - . -.. _ .. -7;943.00 5;120.83-2,462.93.,, Wit. -;22;782:00- =7,94300 •3,797.00• 212:42'x. c. 8/31/16 .. . •- _ •.w:.ti , r .. - .. .. - - 0000 _ .:. r-.�-�.. �-. 454500000 6500/7000-'.FY15.Secocs NEW. ..,,:,`;, ..• 06/06/16- 06/30/17 .- PY15 Admin 'i -., • `- .� 22, 769.00 •- ;;,- -, -16,826.00 - • .. : v 0000. - ., . 1. .'..,. :-'::: -:-� 7', PY.15 flinning - r -, •. -'-, . _•.:- ." . 453500000 FY15 Sectors NEG „06/06/16 .,06/30/1 annmg ,t -„ , - 31,406.00 .• 3,863.85 374'29 .2,648.70, 2 60936 255 52 , '_, F S... -or N n .. .: ».-0,000 ". 06/30/17 ' ..PY 15 Pro ra - '., ,`,,• ,. :_; .•"-. . _ :r' ,.. � •- .. - 455500000 6500 515 eR s EG' 06/06/16 g m• - 207,919.00 .. _ 69,404.41 -, 27;090.43' 36,094.24 - ,+ " 16,972.60 '= 16;433.52.. -14,826.00 - :y 7,94300'2,471000 185.38:.-. .= 9;751.92 - -21,654.08' "' 1,62 5.32 2038.71; 7 - 399 .80,:�.:- 27999.20 :-3741.98: ,,- -16 ,995.20 .. 23 . ...-. ,. . 00::0 _ ...:-. -. ...-. , .,.�,.... ... ,. ., - ,., _ -,: ;..' , .. ,' -, - u: -06/30/17 PY 15 Admin _. ,., ,.. - . ... �„ ,. __r: :,. ,..:> ..4 454500000 6500/7000 • Fy15 Sectors'NEG . - 06/06/16 . 11,795.01. r , .: - 7.88 563.44 1 577.54 3,956.25: 1;632.65 38:41•_. `206:20 _ . _,. ... ..; . 0000 �/, /1 -06/30/17 "FY PIanni • 1 ..' 3-5. •..- _ 453500000, ' ,." " FV15 Sectors NEG . .- , 06/06/16; rag ., - :, F.18,126.00, ,- -,.-121.10' 1,248.05 455500000 6500 ^ -' FY15 Senors NEG "'• 06/06/16 '-06/30/17 . PY 15 Program ' " • 258,182:00 - �'•-+.', ' • . "' -' : � � - . . - .. = 1,OG7.42,... _ 2,578.72 7.06'';,. .39.02' 8,022.37 ,3,772.63 ' '•1,33 _ - 7 8.19 :-1886.51, "' "1,369.15'' -"16, 56.85, '-' :. 22 _ ;. ' ,3,646.14 . • 254,535.86' 607.69 ''''i9,51154 .. 205500000 •`6500,,-,,,,,',..,,L,._„......515' ._ Wagn_gasyser Emp Svcs --- :- -' 07/01/15. 06/30/17 --WP Program . - '_ - ' - ' 505,362.00 ,- , 258,792.75 62. 093.30 60,066.89 -. 57,397,60 56,73L15 - 70.27951 - _: 34,278.34 13,538.211 - •. - 0000 505,362.00 • • - 0.00 ' 84 227.00 . •--25,268.10 "' .. 205600000 6500 PY16 Wagner Peyser Emp Svcs 07/01/16 06/30/18 WP Program 501,535.00 0.00 0,00 0.00 0.00 15,092.57 22,772.28 -6,628.33 26,687.86 39,420.71 29,193.28 15,181.01 189,535.93 311,999.07 31,589.32 26,923.10 , _ 2W260J00, ';65001+,•` PY75"EmP5 yPort Fund ESF •.—��'�:07/01/15 ;'06/30/16-:ESF Program' - {:,+,,413,682.00 ,:.-413;682.00= ::: ...;- S-: .y � -. .. , -. -'413682.00 r ..' 0.00- 68947.00 : -20,684.10'.,5/33/2016 2W270000 6500 PY16 Emp Support Fund (ESF) 07/01/16 06/30/18 ESF Program 404,346.00 8,955.26 3,515.34 -1,052.12 33,311.54 40,954.23 11,427.25 14,347.94 28,237.42 24,924.56 31,770.31 27,259.99 142,184.66 365,836.38 38,509.62 60,972.73 -13,799.03 _ '.t - '7 , f .,,; .. ' - _ ( •U . s;' _. '''.6500 0 0 5 6'7/01/15 4D9500000.6500..+. PV3525%Enhanced'DW :•• : r- a;_,; ..07/01/15 !:06/30[17, ;PY35 EDW Frog .,•- _ .. ,. -,. 0000 3,522:27 0.00 .-.. 0.00. ',. �.,-., -. 1,30549 - .. - . .. .., ... }. . , .._ .•.. ,.__ .. - '. .. ca` 1'' .; 0000 - .. ;'.. .. ''f1 3017 :PY15EOW Trite --:.-:: - -'•: "... r., '.: 4 1 _.,. - _ _ .. -- .. - ., 409501000 • 6500/7000_-� PY15 25%Enhanced DW - • � -.. . 07[O1f15 06/ / 8 .. 14,930.24 0.00 ' .0:00. '`'., .. 1'''. -'... `. `• '- , � , : " . � , . . ,' 000 0.00.. 000', ,_ - - •ut c ,. .:-.10.00 - 0.00 ''`.t- 0.00...'.. 409500000 PY15 25% Enhanced OW Totals 07/01/15 06/30/17 PYI5 USWTmp& Rog Totals 19,758.00 18,452.51 0.00 0.00 0.00 0.00 1,305.49 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 19,758.00 0.00 3,293.00 -493.95 4FD500000 6500 FY16 25% Enhanced DW 07/01/15 06/30/17 FY16 EDW Frog 0.00 0.00 0.00 16,658.80 8,492.041 --.436.52' '` ' =70.75 3, 19,230.10 46,102.00 '46,102.00 7,683.67 -7,683.67 Program Acct/Activity Project Contract Period Desc Budget Disbursed as of 06/30/16 Jul -16 Aug_16 Sep -16 Oct -16 Nov -16 _ Disbursements Dec -16 Jan -17 Feb -17 Dec B-16 Mar -17 - Apr -17 May -17 Jun -17 Total Disbursements Adjustments Balance Average Monthly Spending Average spending needed for 30% carry-over Closed Last Reimbursemen t Start End 4FD500000 6500/7000 FY16 25% Enhanced DW 07/01/15 06/30/17 FY16 EDW Trng 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4F05017000 FY16 25% Enhanced OW Totals 07/01/15 06/30/17 FY16 EDW Tmg& Frog Totals 46,102.00 0.00 0.00 0.00 0.00 0.00 16,658.80 8,492.04 -1,436.52 -70.75 3,228.33 0.00 19,230.10 0.00 0.00 46,102.00 0.00 7,683.67 -1,152.55 ._- c 4E0400000. .. FY 1525% ENHANCED Dislocated Worker,. 10/1221716 •'.6/30/2017 FY 15 Admin .• ,. 6,422.00' �4FD400000 - FY 1525% ENHANCED Dislocated Worker. 10/1/2016 6/30/2017 FY 15 Program .- . 57,800.00 • 1,110.59 - 1,400.19 ,. :. - -' 3,911.226.422.0 : •:- 14,096.77 - , 10,044 55 33 65868 5 7,80000 OAO • 000 - — — - - - 4E0600300 FY 17 25% ENHANCED Dislocated Worker 10/1/2016 6/30/2018 FY 17 Admin ' 9,692.00 4F0600000 FY 17 25% ENHANCED Dislocated Worker 10/1/2016 6/30/2018 Pr 17 Program 87,235.00 0.00 0.00 9,692.00 87,235.00 96,927.00 96,927.00 4.. - '_ .- ,.: - .. , .' -• -• _ _ .: :.-. �, 46D500000 , 6500'....- 'FY36 WIOA Dislocated Worker .- :-:-07/01/15 06/30/17..;F1'16 Admin---. /' - -: :18;261.00 "' ' '- • " �-�'� 48D500000. , 6500 FY16 WIOA pslo ated Worker. - 07/01/15 �,. O6/30/1J, ;,FY36 Ptognm •� 48D500000..8000. •- .FYI6 WIOA dslocated Worker- •-.,•, .07/O7/15.., 06/30/17 �.'`, rfV16 Tralning-- `� --=r:�--- ., -�- � .. .. L. ._.' i. `. ., ..._' .,•• s - - '6 18 12,157.83.- ' 1,625.18 : .395.56 •.646:21. --- ,.794.53 666:27•7';_-• 379.82', 138585.•' 1,537.37_ 525.63 76245.05 '.7'61867''��,3168.07-. � 3100.40' ':'206:70 �.�624:56r.� ..6890.74. 6.466.07_: 11587.93 ��' 5,427.26 '� 2,856.77 ' �- .18,147.51,-- 2,363.56-^--•'510.00.-'3;712.50• �-3,491.68 •-':2564:73- .1;%8.00 - - •"4,727.60 "1,849.'03- --;'-1,106:00 20114, 05 - ..'•124,092.22 '�40,440.78 . 335234 •1 -914.05 -1;833051 „� 0.00 •, ^,., _ .. '•... -., � ..- ., _ ..:_ - ,, .. _- :-., _ . 18D500000 -..-., .•:.. F,Y16 W70A Dislocated Worker.:,. _:-.07/O3/I5.. ,06/30/17,:FY36Tminln0 ,.... •-. _. -.._164,533.00.-.. ..,. ..';, .:-.; --.,3,69&38 .. ..T. ,-, n .. •'0,00. 94,392.56 ,.. 9,982:13 .3,678.07 . 6,83L90•.,. 3,089.29., ...8,858:74., 6,466.07 -:16,315:73 '7,276.26... ,.3,%2.77., -. ., X0.00: -_x '_0:00 •.= .'_ < .:.164533.00 - _. ..3"E.,,;:---4110.00,?_:. '27422:17, ,1% l'-9871.98. ,:-, .. '-� .,. 46D600000 6500 FY17 WIOA Dislocated Worker 07/01/16 06/30/18 FY17 Admit 24,759.00 480600000 6500 FY17 WIOA Dislocated Worker 07/01/16 06/30/18 FY17 Program 48D600000 8000 FY17 WIOA Dislocated Worker 07/01/16 06/30/18 FY17 Training 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0,00 0.00 0.00 0.00 0,00 0.00 0,00 0.00 0.00 0.00 0.00 0.00 11,654.59 8,761.79 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0,00 0.00 0.00 20,416,38 0.00 24,759.00 FY 17 Dislocated Worker 222,839.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 11,654,59 20,416.38 202,422.62 170500000` : 6500. •-- .; FY15 TAA Use MHmt '• 10/01/15 •.- 06/30/17 ,♦ Case Mgmt ,; : - — := ' 7,439.00 „ 170500000 . ,: FY15 TAA Use M mt ... •...al/03/16, 06/30/17..; Use M t ,.-- - 733:00 -.... 948.74' 3,014.73: 0.00 •,' : ' - 976.11 ,' . 0.00 s . 0.00 24.47 153.67 7 50.E 669175 ^• 1,644.03, ,0.00 - ., ... 0.00 _ 0.00 ..-. 0.00 , _ .. , _ : _..- • ,= -' 203.31 z 529:69 7;43 .733.00 _ ,- 0.00 x 1122 17 -371.95, 65 .., •4, - s ,::- ... 06/30/18 Case Mgmt 4 570600000 FY16 TAA Case Mgmt 5,400.00 0.00 0.00 0.00 0.00 870.26 -548.74 5,078.48 53.59 57641 •- `.10/01/16 .. • • • . ,,n _ 9 _ p r ,. ,, .:h, .. 203600000-` . 6500' •' - FY16 DVOP - s : `... � .. r...- :10/01/14 09/30/15 OPenting- '.": r:. : i-:..•., . 7,000.00 ... -'-32152 .. ._ • . .• ,, -. _ 5,249.98 -•: 583.34 � ' - 583.34 • , '..583:34 � -:,.. ., _ ...... ... , - - .• .C 7,000.00 -� Y •, A, - .--.- '.:0.00 1.166.67 .. 350.00.:. �. 203700000 6500- - FY17 DVOP - - 10/01/16 12/31/17 Operating . •: 7,00000 - 0.00 0.00 0.00. 0.00 1,399.98 622.22 622.22 .. 622.22 622.22 622.22 622.23 5,133,31 1,866.69 855,55. - -38,89 255500000 6500r ., Pii5 Summer.Job Hunt -' _� -'- 1/3/2016 12/31/2016�W SS.GSIM ' -;40,000.00 ' .- - - . .- ' � - �-. ' -. i; � - 19,550:36 '7,012,21 Y 5,569,36 • -•: 7,868,07','• `0.00- ..�F. - - - - - � •`• � � �- -� �- � 40;00000 . �' � 000 � 6666 67' ��- _2,00000 -, - � - - 255600000 6500 PY 16 Summer Job Hunt 1/1/2017 12/31/2017 PY 16 G529 40,000.00 3,996.77 8,368.66 7,132,73 4,473.34 1,502,97 25,474.47 14,525.53 4,245,75 420.92 4DW500000 PY 15 5% Performance Incentive 10/1/2016 6/30/2017 PY15 Program 20,490.00 0.00 0.00 0.00 0.00 0.00 2,992.13 2,368.75 0.00 6,352.70 6,611.94 2,164.48 20,490.00 0.00 3,415,00 -1,024.50 4GD4000000 6500 FY 15 WIOA Technical Assistance 5/10/2017 6/30/2017 FY 15 12,500.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 12,500.00 12,500.00 0.00 2,083.33 625.00 .. _ .. , . . : .., r ..: - .: -:. ._ � 2M5500000:'.i '„ PT 15,10%WP-MSFW ,; <,: 7/1/2016 ,, 6/30/2017;PY 15Prog m � .,__ _',,._,26,675.00 - -- '. . _ r• n .' � :_.' � .... �',. �� ,: • 4 - . 4,798.05- - 630.80 . -- 4440.30 -� '8,07510 - 1683.13 _, , 0.00 _—.-0.00 0.00 0.00, 3,022.45 306.19 ,, 584.46 3,3 0.52 - v, 26675.00 k. y. �. 0.00 . �- 4,445 83 "'5335.75 .y 1` _ .. ,: '� : FY16 Reemployment Services & 288600000 6500/7000 Assessment (RESEA) 06/06/16 06/30/17 FY 15 Program 63,600.00 2,400.00 3,825.00 4,125.00 2,925.00 3,150.00 3,300.00 2,175.00 4,950.00 2,925.00 0.00 3,525.00 3,375.00 5,550.00 2,850.00 45,075.00 18,525.00 7,512.50 -92.50 FY16 Reemployment Services & 288700000 6500/7000 Assessment (RESEA) 01/01/17 12/31/17 FF17 1,485.00 0.00 0.00 1,485.00 0.00 173.25 Cash Requested Non -Active EA's Check Number CLEAR UPLOAD FILES DiH UPLOAD FILE & CASH REQUEST 4,912,768.00 . 1,920,628,64 161,055.77 183,778.81 195,275.22 130,306,99 162,312,40 168,624.24 55,808.69 148,709,52 107,912,31 160,522.52 247,449.22 216,360,14 353,434.92 3,837,301.73 588,181.48 642,314.46 (83,282.66) 1,485,00 1,920,628.64 161,055,77 183,778.81 195,275,22 127,284.54 209,580.52 166,639.80 60,259,19 145,718.55 102,562.66 159,900.30 187,840.22 153,931.63 0.00 3,817,543.73 0.00 0.00 0.00 0.00 3,022,45 106.19 1,984.44 -4,450.50 2,990.97 5,349,65 622.22 59,609.00 62,428,51 0.00 0.00 0.00 0.00 0.00 0.00 (47,374.31) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 353,434.92 19,758.00 - MAY 153931.63 0.01 23757.93 177689.57 -121.1 177568,47 70471.84 22855.29 270895.6 247449.2 187840.2 59609 0 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 10/1/2015 PROGRAM INCOME START DATE Attachment H Page 1 of 2 YEAR OF FUNDS_ FY15 TITLE/PROGRAM/PROJECT TAA CASE MANAGEMENT CLEAR Program code 17C5000000 END DATE_ 6/30/2017 END DATE I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 2. Current Program and Admin Cash Needs 3. FINAL Program and Admin Cash Needs Contract to Date # 8,172.00 8,172.00 II. PROGRAM EXPENSE REPORT (ER) , ,, - Hrb , ' � ii > 1. Total Expenses+Accruals Previously Reported (Through Last Month) 8,172.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 8,172.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 „ , 3 s ,��; 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION wrz 1. FINAL Cash Request Contract to Date 8,172.00 2. FINAL Expenses Through End of Contract 8,172.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes ❑( /No 0 V. CASH REQUEST PROGRAM INCOME CASH REPORTED „ (tNU rn 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 1/I. RECONCILIATION = , „, r 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 VII. MATCH RECONCILIATION 1. FINAL Match Reported Through End of Contract 2. FINAL Expenses Through End of Contract 8,172.00 3. Match Percentage of Expenditure Contracttual Requirement 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 / �aDi1"' l%" Authorized Signatu \ ,- ., .„... Date NOV 2 2 2017 See instruction for completing this for on the next tab (Attachment H 020 / 7- of v/ CLEAR WIOA Reconciliation-TAA Case Management Reporting Month 'Program Code 'General Ledger 'Billed 'Received 'Date Received 'Grant Balance June FY 15 7,223.26 July 17C500000 3014.73 7223.26 August 17C500000 0.00 3014.73 3014.73 12/31/16 4208.53 September 17C500000 976.11 976.11 976.11 12/31/16 3232.42 October 17C500000 0.00 0.00 3232.42 November 17C500000 3232.42 December 17C500000 24.47 24.47 24.47 2/6/17 3207.95 December B 17C500000 7.50 7.50 7.50 4/4/17 3200.45 January 17C500000 0.00 3200.45 February 17C500000 153.67 153.67 153.67 4/4/17 3046.78 March 17C500000 669.75 669.75 669.75 5/11/17 2377.03 April 17C500000 1644.03 1644.03 733.00 April 17C500000 203.31 203.31 1847.34 5/23/17 529.69 May 17C500000 529.69 529.69 529.69 6/26/17 0.00 June 17C600000 Totals 7223.26 7223.26 7223.26 FY15 17C500000 733.00 General ledger vs billied 0.00 Billed not received' 0.00 General ledger vs. received 0.00 CLEAR WIOA Reconciliation-TAA Case Management Reporting Month (Program Code (General Ledger (Billed (Received (Date Received (Grant Balance June FY 14 1,637.36 July 17C400000 1637.36 1637.36 1637.36 10/13/15 0.00 March 17C500000 17C500000 605.04 8,172.00 8,172.00 April 17C500000 17C500000 343.70 0.00 8,172.00 8,172.00 May 17C500000 17C500000 0.00 948.74 948.74 7/1/16 7,223.26 0.00 7,223.26 June 17C500000 17C500000 0.00 0.00 7/27/16 7,223.26 0.00 7,223.26 Totals 2586.10 2586.10 2586.10 General ledger vs bullied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Account 5230.0000.6500.17C5000000.0000.00000000( • —= Funds Available ( Detail Balances.) Period Budget Encumbrance Actual Funds Available 1-1IDec-15 1 0.001 0.001 0.00 • 0.00E Jan16 1 IFeb-16 • __1I ' - 0.001 [Mar -16 ' . I 0.001 0.00 0001 000 0.00;,. -0.00 0.0o! 0.00 0.00 I 0.00, 0.00 0.00.1 - 0.00 - 0.00'1 0.00 Jl.pr-16 j LIMay 16 ! 0 00'[ 000 948.74' ___-_948.7,4_'. ,-'l U(TJun 16 •-, 8172.00! 000 0.00; 8172.00 ( Adi 16 II 0.04 0.00 0 00 0 00 L�Jul l •— -O.OoI 0 ;I _ 0.00 3014 731 -3014.73 UTug-16& I 0.00 _ • —� ---8172.0011 -"7" 0.00 8172.00 ; , • 0.01 I • Cancel Account 5230.0000.6500.17C5000000.0000.00000000( — Funds Available ( Detail Balances ) Period Sep -16 Jloct-16 ._ L Nov -16 Dec -16: Budget Encumbrance Actual Funds Available 0_00;L — - 0.0 - 976.1111 - — - 976_11; 0.00E . 0.00[ 0.0Q, 0.00'1 - 0.00L Jan -17 I 0.00 0 00 0.00! 0.00!! �1Feb 17 0.00 0 00. 161.17 -161.17II LIMar-17 i 0.00• 0 00 669.75I -669 75;• ^I Apr -17 i - 0.00 0.00' 1847.34! -1847.34 • r May 17 0.00 0 00 529.69! • L, I 0.00 0.00 0.00 0.00 _ 'IJun 17 it .-- 0.00, - 0.00' 0.00 0.00, 24.471 0.00'I • -24.47 j • 8172.001 - 0.00 8172.00' 0.00! Cancel_ J 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 10/1/2015 PROGRAM INCOME START DATE YEAR OF FUNDS_ FY16 TITLE/PROGRAM/PROJECT_ DVOP CLEAR Program cod 2036000000 Page 1 of 2 END DATE_ 9/30/2016 END DATE 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,000.00 7,000.00 II. PROGRAM EXPENSE REPORT (ER) i *° tl, - h 1. Total Expenses+Accruals Previously Reported (Through Last Month) 2. Current Expenses + Accruals (Through End Date of Award) 7,000.00 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 Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION A� 1. FINAL Cash Request Contract to Date 6,999.99 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 ❑ /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 VL 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 Wl. MATCH RECONCILIATION 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 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes 0 /No 0 `The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signature !/_/� Date C1 42 -D 2-£/ 14 Authorized Signatur /;( Date NOV 2 2 2017 /cam See instruction for completing this for on the next tab (Attachment H 2 of 020 / 7 -.V9-/ CLEAR W/OA Reconciliation-DVOP Reporting Month (Program Code (General Ledger 'Billed 'Received (Date Received (Grant Balance June FY 15 2,000.01 July 203500000 666.67 666.67 666.67 10/13/15 1,333.34 August 203500000 666.67 666.67 666.67 10/13/15 666.67 September 203500000 666.67 666.67 666.67 3/8/16 0.00 October 203600000 7,000.00 November 203500000 1,166.66 0.00 7,000.00 December 203500000 583.33 0.00 7,000.00 December B 203500000 0.00 0.00 7,000.00 January 203500000 0.00 0.00 0.00 5/11/16 7,000.00 February 203500000 583.33 0.00 7,000.00 March 203600000 1,166.66 3,499.98 3,499.98 6/21/16 3,500.02 April 203600000 583.33 3,500.02 May 203600000 583.33 1,166.66 1,166.66 7/1/16 2,333.36 June 203600000 583.33 583.33 583.33 7/27/16 1,750.03 Totals 7,249.98 7,249.98 7,249.98 General ledger vs billied 0.00 Billed not received J 0.00 General ledger vs. received 0.00 CLEAR WIOA Reconciliation-DVOP Reporting Month 'Program Code (General Ledger (Billed (Received (Date Received (Grant Balance June 203600000 1,750.03 July 203600000 583.34 1,166.69 August 203600000 583.34 1,166.68 1,166.68 12/31/16 583.35 September 203600000 583.34 583.34 583.34 12/31/16 0.01 October 203600000 0.00 0.00 November 203600000 0.00 December 203600000 0.00 December B 203600000 0.00 January 203600000 0.00 February 203600000 0.00 March 203600000 0.00 April 203600000 0.00 May 203600000 0.00 June 203600000 0.00 Totals 1,750.02 1,750.02 1,750.02 General ledger vs bullied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Account 15230.0000.6500.2036000000.0000.000000000, - Funds Available ( Detail Balances ) Period Budget Encumbrance Actual Funds Available j ' Mar -16 jl, 0.00 O.OO;I 3499.98 3499:98= f r•I16 0.00 11 0.001 _ ._. __-_-- 0 00, 0.00 [_ May -16 JI 0.001 0.00; 1166 66! -1166.661 Jun 16 1. 000. OOOI 58333 58333! • h Adl-16 • 0.00; 0.001 0.00 _9i' Jut -16 000 0.001 — 0.00; -- ---000- Aug 16 j 0.001 4 0.00;1 1166 68. -1166.68 4° (t Sep 16 0.00 0.001 583.34:- .-583.341, i [ Oct -16 IL 0.00 • 0.001 0.00 0.00,, Nov -16 II 0.00; 0.001 0.00; 0.00 _ 7000.00 0.00; 6999.99; '0.01i Cancel . J . COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT GRANT CLOSEOUT RECONCILICATION WORKSHEET SUBRECIPIENT:_ Employment Services of Weld County ADDRESS: PO BOX 1805 Greeley, CO 80632 CONTRACT/EAIWORKPLAN START DATE_ 7/1/2015 PROGRAM INCOME START DATE YEAR OF FUNDS_ PY 15 TITLE/PROGRAM/PROJECT_ WAGNER PEYSER CLEAR Program code 2055000000 Attachment H Page 1 of 2 END DATE_ 6/30/2017 END DATE L 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 M 505,362.00 505 362.00 IL PROGRAM EXPENSE REPORT (ER) _ c 1. Total Expenses+Accruals Previously Reported (Through Last Month) 2. Current Expenses + Accruals (Through End Date of Award) 505,362.00 3. FINAL Program Expenses Contract to Date 505,362.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 0.00 III. PROGRAM INCOME(PI) EXPENSE REPORT , _ 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION .- L a " ',' 1. FINAL Cash Request Contract to Date 505,362.00 2. FINAL Expenses Through End of Contract 505,362.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes D /No ❑ V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 W. RECONCILIATION1. 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 e--.Fa .w�. i 1. FINAL Match Reported Through End of Contract 2. FINAL Expenses Through End of Contract 505,362.00 3. Match Percentage of Expenditure Contracttual Requirement 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes ❑ /No ❑ *The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signature Date 9/7 0// :. Authorized Signat re s/ / /(� Date NOV 2 2 2017 See instruction for completing this for on the next tab (Attachment H 2 of oZoi 7- e94/1 CLEAR WIOA Reconciliation -Wagner Peyser Reporting Month (Program Code 'General Ledger (Billed 'Received (Date Received 'Grant Balance June 2016 2055000000 246,569.25 July 2055000000 62,093.30 246,569.25 August 2055000000 60,066.89 122,160.19 122,160.19 12/31/2016 124,409.06 September 2055000000 57,397.40 57,397.40 57,397.40 12/31/2016 67,011.66 October 2055000000 56,732.15 56,732.15 56,732.15 12/31/2016 10,279.51 November 2055000000 10,279.51 10,279.51 November 2056000000 15,092.57 25,372.08 25,372.08 12/31/2016 486,442.43 December 2056000000 22,772.28 22,772.28 22,772.28 2/6/2017 463,670.15 January 2017 2056000000 -6,628.33 -6,628.33 -6,628.33 4/4/2017 470,298.48 February 2056000000 34,278.34 34,278.34 34,278.34 4/4/2017 436,020.14 March 2056000000 26,687.86 26,687.86 26,687.86 5/11/2017 409,332.28 December B 2056000000 13,538.21 13,538.21 13,538.21 4/4/2017 395,794.07 April 2056000000 39,420.71 39,420.71 39,420.71 5/23/2017 356,373.36 May 2056000000 29,193.28 29,193.28 29,193.28 6/26/2017 327,180.08 June 2056000000 15,181.01 15,181.01 15,181.01 7/21/2017 311,999.07 Totals 436,105.18 436,105.18 436,105.18 PY15 2055 505,362.00 END 11/2016 PY 16 2056 501,535.00 START 11/2016 General ledger vs billied 0.00 Billed not received' 0.00 General ledger vs. received 0.00 °1RAttlilTI 15 g'tV 6F1nra'i(' [fir , -_ `r - • Account 15230.0000.6500.2055000000.0000.000000000 — — Funds Available ( Detail Balances ) Period - Budget Encumbrance Actual Funds Available _ Adj-15 • : 0.00' 0.00' • 0.00 • f f 0.00' — Jul -15 . j 531185.00 0.00 0.00; 531185:0011 Aug -15 j 0.00; 0.00; 0.00 0.00"1 1 0 00; 26518.79 ' -26518.79 Oct15. 0 00'j. 0.00' 73306 221 f -73306.22 1; Nov 15 I 0:00 0.00; 77955.73' -77955.73j Dec -15. • , 0.00' 0.00; 14953.111 -14953.1'11 1 Jan -16, 0.00 0.00. 1773.7a -1773.721 1 Feb -16 0.00 0.00' 3486.68' . -3486.68;' Mar -16 . , 0.00, 0.00' 10609.48; -10609.481 • 531185.00 0.00; 505362.00! 25823.00 I J h _____ —__-J Cancel Account 5230.0000.6500.2055000000.0000.000000000 ------ .__-...._. Funds Available ( Detail Balances ) -- - _ _ _ __-.___,._.__•.:_:_.._;-.--------_----, Period Budget Encumbrance Actual Funds Available ' Apr -16 J 0.00; - 0.00' __= _0 00 — 0.00 = Ma 16 1 f 0.00 0.00 7310.301 -7310.30;; Jun 16 J L 0.00' 0.00 42878.72, -42878.72' Fl Adj 16 J1I 0.00;1 • 0.00; 0.00; 0.00'1 Jul 16 — 0.00 0.00' _ 0 00 __- 0 001 ,_ Aug 16 t �� ;. 0.00 0.00'. J�.__. 122160.19 -122160.19'_ -_ L Sep -16 f iII — 0.00; 0.00 57397.40' .-57397.40.• 1 I L Oct -16 _ IL. ..f.,= 0.00 _..._ 0.00 56732 15 -56732:15 • Nov -16 iI 0.00' 0.00 10279.51! -10279.51 ( Dec -16 ;1 0.00 0 00, ' 0 00 0.00' I I 531185,001 0.04 505362.00 25823.00; l -_ -- --- -- — — — --- -- — — — '-- °---... _ _. _) • ( •Cancel . Period -' 'I Sep -16 f � Oct`16 l U Nov 16 Dec 16 • Jan -17.,, j Mar 17 JApr �7__.___ _ r May -:17• - I1 [un17 ' I • Account 5230.0000:6500.2055000000:0000.000000000 ---- Funds Available (Detail Balances ) . Budget Encumbrance o.00 0.00; — _- 0001._. _.._.:,�.. _ — 0_Ooi 0.00 0.00; 0.00 0.00; „ 0.001 ' 0.00: E 1 0:00• 0 00!. 0.00' 0 00;., { 0.00 0.00; Feb -17 Actual. . Funds. Available 1:7•771:7•77C91;.x 57397.40! . , -57397.40 • 5673215] -56732.151 [ 10279.51 -10279.51 i . 000: O00 O.0d 0.00,, 0.001 .- '0.00E 009 •0001 000 -.000 i 0.00j 0.00• n nn 0 00 I 0.00; 0.00 0.00, OOJ 531185.00! 0.00;1 • 505362.00 - 25823.00 Cancel. 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 7/1/2016 PROGRAM INCOME START DATE Page 1 of 2 YEAR OF FUNDS_ PY15 TITLE/PROGRAM/PROJECT_ 10% WP-MSFW CLEAR Program code 2M55000000 END DATE_ 6/30/2017 END DATE I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported : 3,. 2. Current.Program and Admin Cash Needs 26,675.00 3. FINAL Program and Admin Cash Needs Contract to Date 26,675.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 26,675.00 2. Current Expenses + Accruals (Through End Date of Award) . 3. FINAL Program Expenses Contract to Date 26,675.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 0.00 III. PROGRAM INCOME(PI) EXPENSE REPORT "' 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract - 0.00 IV. RECONCILICATION 1. FINAL Cash Request Contract to Date 26,675.00 2. FINAL Expenses Through End of Contract 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) 2,675.00 Yes O /No O V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 VI. RECONCILIATION 1. FINAL Program Income Cash 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 26,675.00 3. Match Percentage of Expenditure Contracttual Requirement 4. Match Expenditure Requirement 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) 0.00 Yes O /No O 'The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding period. Preparers Signature - Date V32 -O// Authorized Signature( ( l ae Date NOV 2 2 2017 See instruction for completing this for on the next tab (Attachment H 2 of c201 7-0 94/( CLEAR WIOA Reconciliation-MSFW Reporting Month [Program Code 'General Ledger 'Billed 'Received 'Date Received 'Grant Balance June PY 15 $26,675.00 July 2M5500000 $0.00 $26,675.00 August 2M5500000 $0.00 $26,675.00 September 2M5500000 $0.00 $26,675.00 October 2M5500000 $3,022.45 $26,675.00 November 2M5500000 $106.19 $26,675.00 December 2M5500000 $584.46 $26,675.00 January 2M5500000 $3,340.52 $7,053.62 $7,053.62 2/23/17 $19,621.38 Febraury 2M5500000 $4,798.05 $5,428.85 $4,798.05 4/4/17 $14,192.53 March 2M5500000 $4,440.30 $4,440.30 $4,440.30 5/11/17 $9,752.23 December b 2M5500000 $630.80 $0.00 $630.80 1/1/17 $9,752.23 April 2M5500000 $8,071.10 $8,071.10 $8,071.10 5/23/17 $1,681.13 May 2M5500000 $1,681.13 $1,681.13 $1,681.13 6/26/17 $0.00 June 2M5500000 $0.00 $0.00 Totals $26,675.00 $26,675.00 $26,675.00 General ledger vs billled 0.00 Billed not received' 0.00 General ledger vs. received 0.00 Account 15230.0000.6500.2M55000000.0000.00000000i - -------- Funds Available ( Detail Balances ) . Period • Budget Encumbrance Actual Funds Available r, Sep -16 • I - 0.00; 0.00:; _ 0.00; 0.00,- lOCt-16 1 O.OOi 0.00 .0.00. 0 00;i. i Nov 16 - __±_.......0.001 0.00 ______1_0.06 0.001: IDec 16- 0.00:• 0.001 0.001 0.00Ji' )Lan 17 0.001 0.00' 7053.621 -7053.62) i, Feb 17 — _ 0 00 0.00 5428.85:. 5428.85 17 0.00 -- . _ - �L__.__. __ ___ _JL.._ 0 001 4440 30 __ ___ __._ __ .___ -.--...__ --__$o_ 4440 30� ... - - . i.1Mar 1.pr 17 i O.OO1L 0.00; 71.10; -8071.10, r I 1May-1-7 �I - 0.00IL. - 0.00 1681 13 -1681.13 UlJun-17. ' i1. 0.00;1 - 0.00; 0.00; 0.00 . f I__ 26675.0011_ 0.00 26675.001. 0.001 ,. _-- .. _._-.._. - _ ___ -_ _ _._. __. I I I I Cancel , j 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 1/3/2016 PROGRAM INCOME START DATE Attachment H Page 1 of 2 YEAR OF FUNDS_ PY 15 TITLE/PROGRAM/PROJECT_ WP 10% -SUMMER JOB HUNT CLEAR Program code 2S55000000 END DATE. 12/31/2016 END DATE I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported ..aH "' 2. Current Program and Admin Cash Needs 40,000.00 3. FINAL Program and Admin Cash Needs Contract to Date 40,000.00 II. PROGRAM EXPENSE REPORT (ER) , e� �,. •.� p �Y ;N�. 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)x_g� 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 :. ;frJ ii,glihwgM" '° 1 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION MAE 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 RI /No O V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 W. RECONCILIATION 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 VII. MATCH RECONCILIATION 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 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes O /No O 'The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signature Date (//2-v/1 .:1 - Authorized Signatur (I Date N0V 2 2 2017 See instruction for completing this for on the next tab (Attachment H 2 d J0/7_ 099/ CLEAR WIOA Reconciliation -Summer Job Hunt Reporting Month 'Program Code 'General Ledger 'Billed (Received 'Date Received 'Grant Balance June PY 14 17,621.92 July August September • 255400000 5404.33 5404.33 5404.33 3/8/16 358.67 2S5400000 255400000 6046.70 6046.70 6046.70 10/13/15 11575.22 5812.22 5812.22 5812.22 10/13/15 5763.00 October 255400000 358.67 358.67 November 255400000 0.00 358.67 December 255400000 0.00 358.67 January 255400000 0.00 358.67 358.67 5/11/16 0.00 Febraury 255500000 March 255500000 7476.47 7476.47 7476.47 6/21/16 32523.53 0.00 0.00 40000.00 December C 255400000 0.00 0.00 32523.53 April May 255500000 1308.96 4071.43 4071.43 7/1/16 28452.10 June 255500000 8002.46 8002.46 8002.46 7/27/16 20449.64 255500000 2762.47 32523.53 Totals 37172.28 37172.28 37172.28 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 CLEAR WIOA Reconciliation -Summer Job Hunt Reporting Month (Program Code (General Ledger (Billed 'Received 'Date Received (Grant Balance June PY 15 20,449.64 July 255500000 7012.21 20449.64 August 255500000 5569.36 12581.57 12581.57 12/31/16 7868.07 September 2S5500000 7868.07 7868.07 7868.07 12/31/16 0.00 October 2S5500000 0.00 0.00 0.00 November 255500000 0.00 December 255500000 0.00 January 255500000 0.00 Febraury 255500000 0.00 March 255500000 0.00 December C 255400000 0.00 April 2S5500000 0.00 May 2S5500000 0.00 June 255500000 0.00 Totals 20449.64 20449.64 20449.64 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Account 15230.0000: 6500.2S55000000.0000.00000000( ' —:_---: ti__._r...._:----_ Funds: Available ( Detail Balances ) •' Period Budget Encumbrance Actual Funds Available Mar -16 L.0.00 0.00 - _7476,44___._-7476.47 :, Apr 16 0 00; 0 oot 0.00; 0 poi • 11 f I May 16 -0 00i - — ._ 0 00 , 4071.431L --497i.431, r [Jun -16 J TT 0.001 0.00, . . 8002 46 8002.461• UIAdj 16 O.0 O.OOi 0.00; -0.00l', I7,IJuI-16 0.00' 0.00 0.00' 0.001 1 Aug -16 0.00. 0.001 12581 5711 12581 57 LSep 16 0.001 0.00 7868.07J1 .-7868.07 , Li Oct -16 0.00' 0 00� - 0 00 0.00 Nov -16-__T_ L_ - 0• __J -- - _ f _0 00 _ _� —_ . — _ 0.00 (_ —= -- 0.00 — — { 40000.001 0.00• 40000 00' o o j Cancel: 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 7/1/2015 PROGRAM INCOME START DATE YEAR OF FUNDS_ SFY17 TITLE/PROGRAM/PROJECT_ ESF CLEAR Program code 2W26000000 Attachment H Page 1 of 2 END DATE. 6/30/2016 END DATE I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 2. Current Program and Admin Cash Needs 413,682.00 3. FINAL Program and Admin Cash Needs Contract to Date 413,682.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 2. Current Expenses + Accruals (Through End Date of Award) 413,682.00 3. FINAL Program Expenses Contract to Date 413,682.00 ADMINISTRATIVE EXPENSE (ER) „ ,' ' F ` 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 ��M r� � fa 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV RECONCILICATION l' : try 1. FINAL Cash Request Contract to Date 413,682.00 2. FINAL Expenses Through End of Contract 413,682.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes O /No 0 V. CASH REQUEST PROGRAM INCOME CASH REPORTED '(a"�'.� 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 VI. RECONCILIATION r= 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 VII. MATCH RECONCILIATION 1. FINAL Match Reported Through End of Contract 2. FINAL Expenses Through End of Contract 413,682.00 3. Match Percentage of Expenditure Contracttual Requirement 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes 0 /No 0 'The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signature s Authorized Signature r ' W t - -, / Date NOV 2 2 2017 See instruction for completing this for on the next tab (Attachment H 2 of 2) 020/ 7-.595z/ CLEAR WIOA Reconciliation-ESF Reporting Month 'Program Code 'General Ledger (Billed 'Received (Date Received 'Grant Balance June PY 15 413,682.00 July August 2W2600000 4,394.86 4,394.86 4,394.86 10/13/2015 409,287.14 2W2600000 5,929.66 5,929.66 5,929.66 10/13/2015 403,357.48 September October 2W2600000 8,641.37 8,641.37 8,641.37 12/1/2015 383,240.71 2W2600000 11,475.40 11,475.40 11,475.40 3/8/2016 391,882.08 November 2W2600000 13,471.33 13,471.33 13,471.33 3/3/2016 369,769.38 December 2W2600000 74,415.47 74,415.47 74,415.47 1/27/2016 295,353.91 December B 2W2600000 I. 21,759.611 273,594.30 January 2W2600000 41,046.96 40,074.14 40,074.14 5/11/2016 232,547.34 February 2W2600000 45,809.61 45,809.61 45,809.61 7/27/2016 186,737.73 March 2W2600000 70,843.52 94,834.39 94,834.39 6/21/2016 115,894.21 December C 2W2600000 0.00 115,894.21 April 2W2600000 61,627.82 54,266.39 May 2W2600000 54,266.39 114,635.77 114,635.77 7/22/2016 0.00 June 2W2600000 0.00 0.00 0.00 7/27/2016 0.00 Totals 413,682.00 413,682.00 413,682.00 General ledger vs billied 0.00 Billed not received' 0.00 General ledger vs. received 0.00 SaiK;``'r�, a -s �,jil, �:'��Vi(,�i7`,`#_^:..0'1F,1C>t7riWi'‘.. ... .._ ._ �..; ; ".-. '• • .__ .,.. 7, ..{:.._:Ox — i�pi Journal 'Expenditure Reporting USD • I . Conversion �y' Reverse — Description Journal Import 4699590: 4 Currency 'USD , j - ` Date I Ledger CDLE Ledger I Category'Expenditure Reporting'; Date '29-FEB-2016 , Period 'Feb -16 1 Period - Feb 16 Effective Date 29-FEB-2016 I f Type User I Method Switch Dr/Cr Balance Type Actual r Bud et I I Rate 1 Status Reversed Clearing Company, Tax Not Required — .. Control Total I . i . IF ;;,Lines . r r,1t Other information Line Account Debit (USD) Credit (USD) Description' ' [I (1 5230-0000_1010.0000000000.0000 0000 : 85032 37 Journal Import Created F.-15230.0000.6500.2055000000.0000.0000' 3486.68 !Journal Import Created I�3 -I5230 0000.6500 2M54000000 0000000( 754.75. :Journal Import Created • j I ! ' I" II 5230 0000 6500 20026000000.0000 000 ' 45809 61 r Journal Import Created _ 5 15230 0000.6500 48D4000000 0000 000( 172106, Journal Import Created I 1 6 J5230 0000:6500 4PD4000000 0000 000( 1168 33Joumal Import Created I-71 j 5230.0000.6500.41'64000000.0000.0006 I I JI 3071 35" Journal Import Created 1 f [8-15230.0000.6500.4Y75000000.0000.0000— 18472 98 Journal Import. Created l ' '.� 90993 11 L 90993 111 Acct Desc (Weld County One Stop Cent Not Used Cash on Hand.NOT USED.Not Used.Not Used.Not Used.Not Usod Not Used ( , Lao Drilldown ;_ . T Accounts._ a I':J . Account [5230 0000.6500 2W26000000 0000.0000( . _3 J Header • Currency _Seurce Category., Debit . Credit iFtop A 1 Expenditure Reporting USD I Weld One Stop Expenditure Repd 45809.61j n:xpen. dit Reverses "Expenditure IUSD j Weld One. Stop I Expenditure`Repc - 45809.61 J: �II >top Al"Expenditure Reporting USD ' I 'USD Weld One Stop J Expenditure Repc 45809 611 - J . _ J I, r -xpendii Reverses Expenditure USD I I Weld One Stop1 Expenditure Repc • I 4145809 61 �,: repost Expenditure Reporting' USD AutoCopy Expenditure Repc `,. 45809.61 U3top A.J Ex•penditure Reporting USD J Weld One Stop] Expenditure Repd 45809.61i I .1 ERSAL Ex enditure Reporting! USD i AutoCopy - Expenditure Repo j45819.61 r'ERSE Expenditure Reporting1 USD j AutoCopy .. -- I Expenditure Repd;_ _ 10 00I __ _ — -xpendii Reverses Expenditure (USD AutoCopy Ex enditure Red j[45809.611______ -f=xpendii, Reverses "Expenditure USD 'I AutoCopy j Expenditure Repd 110.00 I I 1.I Journal: J I : BudgetaryControl 1 1 Drilldown 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 7/1/2016 PROGRAM INCOME START DATE Page 1 of 2 YEAR OF FUNDS_ SFY17 TITLE/PROGRAM/PROJECT_ ESF CLEAR Program code 2W27000000 END DATE_ 6/30/2017 END DATE 1. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported #s .. 2. Current Program and Admin Cash Needs 404,346.00 3. FINAL Program and Admin Cash Needs Contract to Date 404,346.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 2. Current Expenses + Accruals (Through End Date of Award) 404,346.00 3. FINAL Program Expenses Contract to Date 404,346.00 ADMINISTRATIVE EXPENSE (ER),,u 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 � .� : � 5,� �� K a �, ra, 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION 1. FINAL Cash Request Contract to Date 404,346.00 2. FINAL Expenses Through End of Contract 404,346.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 sb rr 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 y � 1. FINAL Match Reported Through End of Contract 2. FINAL Expenses Through End of Contract 404,346.00 3. Match Percentage of Expenditure Contracttual Requirement 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes ❑ /No ❑ 'The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signature � Date Y/c L3/ - Authorized Signature Date NOV 2 2 2017 See instruction for completing this for on the next tab (Attachment H 2 of 2) 020 /7- 94/ CLEAR WIOA Reconciliation-ESF Reporting Month 'Program Code Ledger 'Billed 'Received 'Date Received 'Grant Balance ,General June 2W2600000 0.00 July 2W2700000 404, 346.00 2W2700000 8,955.26 404,346.00 August 2W2700000 3,515.34 12,470.60 12,470.60 12/31/2016 391,875.40 September 2W2700000 -1,052.12 391,875.40 October 2W2700000 0.00 0.00 391,875.40 November 2W2700000 33,311.54 32,259.42 32,259.42 12/31/2016 359,615.98 December 2W2700000 40,954.23 40,954.23 40,954.23 2/6/2017 318,661.75 December B 2W2700000 28,237.42 28,237.42 28,237.42 4/4/2017 290,424.33 January 2W2700000 11,427.25 11,427.25 11,427.25 2/23/2017 278,997.08 February 2W2700000 14,347.94 14,347.94 14,347.94 4/4/2017 264,649.14 March 2W2700000 24,924.56 24,924.56 24,924.56 5/11/2017 239,724.58 April 2W2700000 31,770.31 31,770.31 31,770.31 5/23/2017 207,954.27 May 2W2700000 27,259.99 27,259.99 27,259.99 6/26/2017 180,694.28 June 2W2700000 142,184.66 142,184.66 142,184.66 7/21/2017 38,509.62 6/30/2017 Accrual 38,509.62 0.00 Totals 365,836.38 404,346.00 365,836.38 General ledger vs Willed -38,509.62 Billed not received I 38,509.62 General ledger vs. received 0.00 Database Data Access Set Chart Of Accounts Ledger t -Text Category t - Text Source t - Text Currency .t - Text Accounting t - Date SPCLEAR.CDLE.INT.PROD CDLE Ledger CDLE Accounting Flexfield CDLE Ledger Expenditure Reporting Weld One Stop USD 6/30/2017 (VI Entity Ibnit Account Program TasklAppropriation Unit 'Activity !Task Order !Location * List - Text Debit * Number Credit * Number 5230 5230 5230 5230 5230 5230 5230 5230 5230 5230 5230 5230 5230 5230 5230 5230 523.0 Totals: 0000 1010 0000 7000 0000 7000 0000 7000 0000 7000 0000 7000 0000 7000 0000 7000 0000 7000 0000 7000 0000 7000 0000 7000 0000 7000 0000 7000 0000 7000 0000 7000 0000 7000 00000000 0000 000000000 20560000 0000 000000000 2S560000 0000 000000000 46A60000 0000 000000000 48A60000 0000 000000000 4A660000 0000 000000000 48A60000 0000 000000000 4BD5000C 0000 000000000 48A50000 0000 000000000 4ND6000( 0000 000000000 4Y660000 0000 000000000 4S450000 0000 000000000 4S550000 0000 000000000 4Y760000 0000 000000000 4Y760000 0000 000000000 4Y860000 0000 000000000 2W27000( 0000 000000000 0000 0000 0000 0000 0000 0000 8000 0000 0000 0000 0000 0000 0000 8100 8000 0000 0000 000000 000000 000000 000000 000000 000000 000000 000000 000000 000000 000000 000000 000000 000000 000000 000000 000000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 5138.64 296.58 4910.71 20580.27 4881.00 136.5 1833.05 16131.79 7830.88 421.07 948.08 2745.22 1599.33 16.25 1098.83 38509.62 107077.82 107077.82 107077.82; Account +5230.0000.6500.2W27000000.0000.00000000 • _: _ _-- Funds Available ( Detail Balances.) • —___--_ Period . Budget Encumbrance Actual Funds Available • _ _ 1 0.00' lf'`dl 16 � J - (loci _I 0 00;1._._ 0.00�`k= Jul 16 404346.00 �" �1_. J 404346.00 0 00' 0 OO I - -12470.60; _. Aug 16u �I -- - O.OOi __. 0.0O 12470.60; , I Sep -16. ... — - 0.001 • 0.00 • 0.00;1— - -- _O.O0 Il0ct-16 L 000'. - --.. , _ -- ----1 000!f 000 000'. —_ -- i l Nov -16 • I 0.00! . 0:00 32259.42! .._ -32259A2106 il Dec 16 0 00 0.00 40954.23' -40954'.231— j Jan 17 0:00' _____0.001 11427.25! • -1'1427.25 ;- !lFeb-17 0. 6 0.001 42585.36: -42585.361_ Mar -17 • j 0.001 • 0:00. 23872 4411_ . -23872 44 404346.00 0.00 365836.38'1 38509.621 I 1 Cancel- - 1'I E,.io4X1 0Erra,s gee r4 EO4111 r _ . Account 5230.0000.6500.2W27000000.0000.00000000, —` — •-- - Funds Available ( Detail Balances ) • Period .Budget - Encumbrance Actual - Funds Available ' Sep -16 •. 0.00! 0.00 . ' 0.0O 0.00 =' Oct 16 I 0.00' _.0-0a, 0.0O1 0.00; L Nov -16 { 0 00' 0.00' 32259.42 -32259.42] • Dec -16 [ 0._001. 0 00' 40954.2_3) -40954.23; ` U Jan -17 I . 0.00'I 0.00 11427 25 -11427:25, . Feb -17 i , 0.00jL 0.044 - 42585 36! -42585.36 Mar -17 1 • 0.001 0 00 - 23872.441 =23872.44:p { �� Apr -17 J 0.00 0.0O - 32822.43; -32822.43 i Li May 17 i 0.00 0.001 27259 99 27259 99 • L Jun 17 0.00 0 00. ` 142184.66',-142184.66;--- ' 404346.0O 0.00} 365836.38{ 38509:621 • I Cancel .: J COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT GRANT CLOSEOUT RECONCILICATION WORKSHEET SUBRECIPIENT:_ Employment Services of Weld County ADDRESS: PO BOX 1805 Greeley, CO 80632 CONTRACT/EAIWORKPLAN START DATE 7/1/2015 PROGRAM INCOME START DATE YEAR OF FUNDS_ FY 16 TITLE/PROGRAM/PROJECT_ADULT LOCAL ADMIN CLEAR Program code 46A5000000 Attachment H Page 1 of 2 END DATE_ 6/30/2017 END DATE I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 2. Current Program and Admin Cash Needs 38,721.11 3. FINAL Program and Admin Cash Needs Contract to Date 38,721.11 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 2. Current Expenses + Accruals (Through End Date of Award) 0.00 3. FINAL Program Expenses Contract to Date 0.00 ADMINISTRATIVE EXPENSE (ER) t 4. Total Expenses+Accruals Previously Reported (Through Last Month) 5. Current Expenses+Accruals (Through End Date of Awards) 38,721.11 6. FINAL Administrative Expenses Contract to Date 38,721.11 III. PROGRAM INCOME(PI) EXPENSE REPORT 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION 1. FINAL Cash Request Contract to Date 38,721.11 2. FINAL Expenses Through End of Contract 38,721.11 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes ❑ /No 0 V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 VI. RECONCILIATION 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 Vll. MATCH RECONCILIATION 1. FINAL Match Reported Through End of Contract ,-------t- 2. FINAL Expenses Through End of Contract 38,721.11 3. Match Percentage of Expenditure Contracttual Requirement 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes ❑ /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 ?/`'2-6// Authorized Signature --�/� `� —^' (,e /r Date tf NOV 2 2 20t7 1 See instruction for completing this for on the next tab (Attachment H 2 of 2) 02,0i 7-O911 CLEAR WIOA Reconciliation -Adult Administration Reporting Month 'Program Code 'General Ledger (Billed 'Received (Date Received (Grant Balance June 46A500000 26,433.73 July 46A500000 772.19 26,433.73 July 4DB500000 3,317.00 3,317.00 August 0.00 August 46A500000 2,157.15, 2,929.34 23,504.39 September 46A500000 2,688.17 2,688.17 20,816.22 October 46A500000 0.00 20,816.22 November 46A500000 2,860.15 2,860.15 17,956.07 November Adjustment 4BD50000 17,956.07 December 46A500000 2,678.24 2,678.24 15,277.83 December B 46A500000 3,135.35 15,277.83 January 15,277.83 February 46A500000 598.75 3,734.10 11,543.73 March 46A500000 1,824.36 1,824.36 9,719.37 December C 9,719.37 April 46A500000 2,330.07 2,330.07 7,389.30 May 46A500000 2,555.41 2,555.41 4,833.89 June 4,833.89 Moved to 48A5 4,833.89 Totals 24,916.84 21,599.84 0.00 0.00 4DB5 General ledger vs billied 3,317.00 Billed not received 21,599.84 General ledger vs. received 24,916.84 CLEAR WIOA Reconciliation -Adult Administration Reporting Month 'Program Code 'General Ledger 'Billed 'Received 'Date Received 'Grant Balance June FY 15 32,351.83 PY 15 4A65 3,972.00 July 46A400000 6,118.91 6,118.91 6,118.91 10/13/15 26,232.92 PY15 DW 4DB5 3,317.00 August 46A400000 5,172.82 5,172.82 5,172.82 10/13/15 21,060.10 FY16 DW 4BD5 18281.00 September 46A400000 21,060.10 21,060.10 0.00 September FY 15 DW 23,607.00 September 48D400000 4,344.73 4,344.73 25,404.83 3/8/16 19,262.27 October 4BD400000 6,214.30 0.00 19,262.27 November 4BD400000 4,119.18 10,333.48 10,333.48 3/3/16 8,928.79 December 4BD400000 4,363.69 4,612.32 4,612.32 1/27/16 4,316.47 December B 4BD400000 1,800.77 0.00 1,833.05 5/11/16 January 48D400000 1,076.43 2,477.68 2,477.68 5/11/16 1,838.79 }January 4A6500000 : 3,972.001 February 4BD400000 0.00 0.00 0.00 7/26/16 1,838.79 1,833.05 2,138.951 March 4BD400000 452.70 603.59 603.59 6/21/16 1,235.20 [February 4A6500000 -1833.05 3,972.001 December C 4BD400000 0.00 0.00 April 4BD400000 739.68 0.00 1,235.20 May 4BD400000 495.52 1,235.20 1,235.20 7/1/16 0.00 May 4A6500000 3,972.00 3,972.00 3,972.00 3,972.00 7/1/16 0.00 4BD500000 18,281.00 3,317.00 3,317.00 3,317.00 7/1/16 14,964.00 46A500000 43,555.00 11,324.09 11,324.09 11,324.09 7/1/16 32,230.91 June 46A500000 5,797.18 5,797.18 5,797.18 7/27/16 26,433.73 -1,833.05 26,433.73 Totals 80,369.10 80,369.10 80,369.10 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Account F520.0000.6500.46A5000000. 0000: 000000000 Funds Available ( Detail Balances ) i. i Period Budget Encumbrance Actual Funds Available ! 1May 16 J 0.00 0.00 11324 .0911 -11324.09 ' Lun 16 J 0 00; . 0.001 5797.181 -5797.18 • iJ Adj-16 . ; ' - 0.00, 0.00;1 0.001 - — 0.00' fJul ,6.• _- J ___. ... _= 0_00', _ _. 0.0�I — - 0.00 -- —°-00 Li Aug -16 0.00' 0.00, - 2929341 •- -2929 341 ULSep-16 •_ 0 00; 0.00 - - 2688.17I -2688.17) -•. � [Oct -16 jl _ 0.00' V 0.00', 0.00; - V 0.00: a1! Nov -16 0 00 — — 0.00' 2860.15 — — — ( -2860.15,(' I _ — — — - LIJan-17 Dec 16 -..... 0 00 -_ . _ �.._ __- --____ -0 . - _ ._ _ -2670.00 - 267'8.2A0.00 00' 0.00 ( I rti. I - 38721.111 . ' - 0.001,- 38721.111 • -0.00 i• • Cancel. A Account 5230.0000:6500.46A5000000.0000.00000000( Funds Available ( Detail Balances ) Period Sep -16 LI Oct -16 Nov -16. •.. I. ' -, 0.00)1 Dec -16- ! V 0.00 i� Jan -17 U Feb -17 L Mar -17 Apr -17 1 May -17 I Jun17• __— Budget Encumbrance Actual Funds Available • 1 2688.17: -2688.17k= 0.001 -- -__--------��00__-_----------------- �-------------------� 01011 0.00 0.00,'0.00 0.00' .. 2860.15! -2860.151 ' 0.00; • . 2678.24) 2678.241 0.00 0.00 0.00;1 - 0:00! 0.00 0.00!1- 3734.101 . -3734.10. 0 1 0 00, 1824 361 -1824.36; 001 l _ 0 001 0.00 2330:07j 2330.07 1. _ ___ i ._—.____. 0 00 -•- 0.001, — 2555 41 =2555.41}': . - 0.001_ 0.09 • •0.00` 38721.111 0.00;1 38721.1) 0.001 r • - - _ __ -11 I Cancel.. ;J J 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 7/1/2015 PROGRAM INCOME START DATE YEAR OF FUNDS FY16 TITLE/PROGRAM/PROJECT_ DW Admin CLEAR Program code 46D5000000 Attachment H Page 1 of 2 END DATE_ 6/30/2017 END DATE I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported a . a i 41, ,, 2. Current Program and Admin Cash Needs 18,281.00 3. FINAL Program and Admin Cash Needs Contract to Date 18,281.00 II. PROGRAM EXPENSE REPORT (ER) a rtw I Era Prx F n:iiia'tlu 1. Total Expenses+Accruals Previously Reported (Through Last Month) 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 0.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 5. Current Expenses+Accruals (Through End Date of Awards) 18,281.00 6. FINAL Administrative Expenses Contract to Date 18,281.00 III. PROGRAM INCOME(PI) EXPENSE REPORT a; 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION 1. FINAL Cash Request Contract to Date 18,281.00 2. FINAL Expenses Through End of Contract 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) 18,281.00 Yes O /No O V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 VI. RECONCILIATION 1. FINAL Program Income Cash 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,281.00 3. Match Percentage of Expenditure Contracttual Requirement 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes O /No O *The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signature t / Date ?/// Authorized Signature (----�2 i/ 67 trfrida, DatENOV 2 2 2017 See instruction for completing this for on the next tab (Attachment H 2 of 2) O2,0 / 7-.6`j`11/ CLEAR W/OA Reconciliation -Dislocated Worker Administration Reporting Month (Program Code 'General Ledger (Billed 'Received 'Date Received 'Grant Balance June 46D500000 6,123.17 July 46D500000 1625.18 6,123.17 August 46D500000 395.56 2020.74 2020.74 12/31/2016 4,102.43 September 46D500000 646.21 646.21 646.21 12/31/2016 3,456.22 October 46D500000 0.00 3,456.22 November 46D500000 794.53 3,456.22 November Adjustment -1833.05 5,289.27 December 46D500000 666.27 1460.80 1460.8 2/6/2017 3,828.47 December B 46D500000 1385.85 1385.85 .1385.85 4/4/2017 2,442.62 January 46D500000 2,442.62 February 46D500000 379.82 379.82 379.82 4/4/2107 2,062.80 March 46D500000 1537.17 1537.17 1537.17 5/11/2016 525.63 April 46D500000 525.63 May 46D500000 525.63 525.63 525.63 6/26/2017 0.00 June 46D500000 0.00 Totals 7956.22 6123.17 7956.22 General ledger vs billied 1,833.05 Billed not received I -1,833.05 General ledger vs. received 0.00 Account [5230.0000 6500 46D5000000 000000000000 — Funds Available'( Detail Balances ) _ -- ,- - -- Period Budget Encumbrance : Actual • Funds Available Feb -16. _.._ _. `, _ .: ;__ _0 00' _ 0.00',0.00; -1833.05 -1833.051 i Mar 16 0 001 0 00 6883.882 -6883 82 App 16 . O.OO• i •0 00 - 0 00 0.00 , I May 16 __ _._ 00011 •i 0o0, " 2132331 213233! j 1 Jun -16 1 ; 0:00jr•• 0.00! 1308.631 • ,1308 63',s;`J 0 Adj=16. j� . . o.4 . 0.00} 0.00 .. • :0'00:, I j Jul 16 ' 0.00; . 0.00, 0.00' • , 0.00,',',„ I IAug-•16 - ---• 0.00! . , 0.001 • 2020 741 . .-2020.74 . (�{Sep 16 i 0 00' _- 0.00; 646.211-646.21V-" ( -16 � ! 0 00• •Oct 0 0 :, _ — -- 0 000 000' 18281.00 • 0.00; ',18281.0011 0.001 Cancet`- ox Account 5230.0000.6500.46D000000:0000.00000000( • Funds Available ( Detail Balances') • Period Sep 16 • 0.001 0.0011 . 646.211 • -646 21p, Oct 16 j 0.00' 0 00'1 • 0 00 0.0d ' Nov 16 0.001 0 00'1 1833 05; 1833 05, Dec 16 • 0 00! 0 001 1460.80! -1460.80',',, Jan 17 0.001 0.001 0.00: 0.00'' ;• Feb -17 Mar 17 j j 0.0-0: ' 0 00 1765 671 -1765.67'I ry 0.0u. 0.00' 1537 171 . -153.7.171,, Apr 17. 1 :' 000` 000; 000; 000; May -17 I +_ 0.001, 0.00 ,• 525 63 " 525 63 Jun 17 .j 000 000 000' 000'. Budget Encumbrance Actual Funds Available _18281 001 0.00'1 18281.0011 �� o:ool Gancel1 { I 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 7/1/2015 PROGRAM INCOME START DATE Attachment H Page 1 of 2 YEAR OF FUNDS_ FY16 TITLE/PROGRAM/PROJECT_ ADULT LOCAL PROGRAM/TRAINING CLEAR Program code 48A5000000 END DATE_ 6/30/2017 END DATE I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 2. Current Program and Admin Cash Needs 408,127.79 3. FINAL Program and Admin Cash Needs Contract to Date 408,127.79 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 2. Current Expenses + Accruals (Through End Date of Award) 408,127.79 3. FINAL Program Expenses Contract to Date 408,127.79 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 0.00 III. PROGRAM INCOME(PI) EXPENSE REPORT 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION _ "',' 1. FINAL Cash Request Contract to Date 408,127.79 2. FINAL Expenses Through End of Contract 408,127.79 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 ri 4 Hr 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 408,127.79 3. Match Percentage of Expenditure Contracttual Requirement 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 [�� 6 / :71-,. Authorized Signature (')-1/ 11 Date NOV 2 2 2017 C---- See instruction for completing this for on the next tab (Attachment H 2 of 2) CLEAR WIOA Reconciliation -Adult Reporting Month (Program Code (General Ledger (Billed (Received (Date Received (Grant Balance June 48A500000 42,011.86 July Program 48A500000 23,765.67 42,011.86 Training 48A500000 993.82 42,011.86 August Program 48A500000 12,544.13 36,309.80 5,702.06 Training 48A500000 4,708.24 5,702.06 0.00 August 164,533.00 Program 4ND500000 4,755.01 4,755.01 159,777.99 Training 4ND500000 0.00 0.00 159,777.99 September Program 4ND500000 15,650.39 15,650.39 144,127.60 Training 4ND500000 11,860.78 11,860.78 132,266.82 October Program 4ND500000 13,681.24 13,681.24 118,585.58 Training 4ND500000 6,205.10 6,205.10 112,380.48 November Program 4ND500000 13,923.74 13,923.74 98,456.74 Training 4ND500000 5,434.26 5,434.26 _ 93,022.48 December Program 4ND500000 14,520.21 14,520.21 78,502.27 Training 4ND500000 9,329.50 9,329.50 69,172.77 December B Program 4ND500000 10,438.34 69,172.77 Training 4ND500000 2,890.00 69,172.77 January Program 4ND500000 6,585.08 6,585.08 62,587.69 Training 4ND500000 3,247.65 -3,247.65 59,340.04 February Program 4ND500000 11,950.43 22,388.77 36,951.27 Training 4ND500000 7,583.11 10,473.11 26,478.16 March Program 4ND500000 11,378.11 11,378.11 15,100.05 Training 4ND500000 15,100.05 15,100.05 0.00 December C Program Training April Program Training May Program Training June Transfer funds from 4BD5 11,297.90 and 4,833.89 46A5 Program Accrual 4ND5 16,131.79 Training Totals 222,676.65 206,544.86 0.00 General ledger vs billied 16,131.79 Billed not received I 206,544.86 General ledger vs. received 222,676.65 r PFICTI . Account 5230.0000.6500.48A5000000. 0000.00000000( --..__--- Funds Available ( Detail Balances ) —_----.^--...— _---. ----_----___._-- . Period Budget Encumbrance Actual Funds Available Jan 16 D.00, 0.00' 46551 45 -46551 45,- [I Feb -16 it o.0p, 0.00' 0.00; 0.00; Mar -16 ' II 0.00, 0.00i 34570.10; -34570.10; ---0 UAPr,6 l( 0.00 0.00; O.0 0.0O'; - [ May -16 II 0.0Q 0 00 48734.38' 48734.38) Jun 16 0 00 _--_ __ 0 oo, .- 4317227; __ ____ .__ -43172.27 L Adj-16 11 0.00 0.00; 0.00, 0.00 •• Jul -16 If i -0.00. 0.00 0.00', 0.00 ,Aug 16 II 0.00' 0.001 36309.8Q -36309.80; Sep -16 (( ----- --- ---1I. 0.00', -, 0.00; __ ._ — -- • 0.00; _ _ — 0.00' -- 1' 408127.79. 0.00 L 209338.00;1 , 198789.791 ICancel Account (5230.0000.6500,48A5000000.0000.00000000C --'----- Funds Available ( Detail Balances ) =_..____------_--_-`. —`.--- ---• --- Period ' Budget • Encumbrance .. Actual •• Funds Available 11Jan-16 J — 0.06 0 00, - 46551.451 ,46551.4511 _..----------- -- - ----- ----0.00,1 j1Feb-16 I 0.00 0.00 , 0.00; :. IMar-16 I1. 0:00 0.00 34570.101 -34570.101: 11Ap r-16 0.99 0.00 0 OO L 0 00� ` LIMay16 -, 0.00 0.00', 48734.38' 8 L ; 48734 3 Jun -16 f 0.00; 0 00, 43172 27i • • -43172.271 ilAdj-16 J 0.00 • 0 00; 0.0Q 0.00J. Jul -16 0.00; 0 00 . 0 00; 0.00'1 I jfAug-16 1 0.00J'. 0 00 L 36309.8a -36309.80 ViiSep -16 _^ 0.06 l_ _. , 0 00' ____.. _ _ .---- _- __-_ 0.00 0.00 408127:791 0.0011 209338.00;1 - 198789.791 1 _.. - _. __J .._ _ ._: l: Cancel . Account 5230.0000 6500 48A5000000.0000.000000000 ` Funds.Available-(.Detail Balances:) Period. Budget l! Dec -15 I - 0:00 LIJan 16i .._.�_ — 000;I Feb -16 It; 0.00[ —=— i _ Mar -16 I 0.00 , Encumbrance 0.00! . 0.00: 0.00F4 0.00 9645Y 30{ -96451.30' - 0.00! 0.00j ' ' 0'00' 0.00 44545.50; •-44545.50' Actual Funds Available .r _ Apr -16 0.00'. 0 00' :. :: 0-00I. " 0 oO May 16 0 00. —.—_— 1.:_. __ ___. _�I ___ 0 00� 19112 181-19112.181, 'IJun 16 0.00 0.001 16846.96 -16846 96 U Ad1-16 :. 0:00, 0° I 0 00 0 0o] f �� Jul -16 I 0.00; 0.00; J Aug 15 _� - 0.00' 0.06 • T - 570206; _5702 06 =i 0 00, • 0.0 182658.0 -18658.001 .cancel I-- 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 7/1/2015 PROGRAM INCOME START DATE Page 1 of 2 YEAR OF FUNDS_ FY16 TITLE/PROGRAM/PROJECT_ DW PROGRAM/TRAINING CLEAR Program code 48D5000000 END DATE. 6/30/2017 END DATE I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported ,"361 m 2. Current Program and Admin Cash Needs 164,533.00 3. FINAL Program and Admin Cash Needs Contract to Date 164,533.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 2. Current Expenses + Accruals (Through End Date of Award) 164,533.00 3. FINAL Program Expenses Contract to Date 164,533.00 ADMINISTRATIVE EXPENSE (ER) " . 4. Total Expenses+Accruals Previously Reported (Through Last Month) 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 0.00 III. PROGRAM INCOME(PI) EXPENSE REPORT 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION Vliate 1. FINAL Cash Request Contract to Date 164,533.00 2. FINAL Expenses Through End of Contract 164,533.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 f 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 164,533.00 3. Match Percentage of Expenditure Contracttual Requirement 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes ❑ /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 ! 6/9 - Authorized Signature `--r—.tr Date NOV 2 2 2017 See instruction for completing this for on the next tab (Attachment H 2 of 2) O2 -0/7-A'941/ CLEAR WIOA Reconciliation -Dislocated Worker Reporting Month Program Code 'General Ledger 'Billed 'Received 'Date Received 'Grant Balance June 2016 48D500000 70,140.44 July Program 48D500000 7,618.67 70,140.44 Training 48D500000 2,363.56 70,140.44 August Program 48D500000 3,168.07 10,786.74 59,353.70 Training 48D500000 510.00 2,873.56 13,660.30 12/31/2016 56,480.14 September Program 48D500000 3,100.40 3,100.40 53,379.74 Training 48D500000 3,712.50 3,712.50 6,812.90 12/31/2016 49,667.24 October Program 48D500000 206.70 206.70 49,460.54 Training 48D500000 3,491.68 3,491.68 3,698.38 12/31/2016 45,968.86 November Program 48D500000 524.56 524.56 45,444.30 Training 48D500000 2,564.73 2,564.73 3,089.29 12/31/2016 42,879.57 December Program 48D500000 6,890.74 6,890.74 35,988.83 Training 48D500000 1,968.00 1,968.00 8,858.74 2/6/2017 34,020.83 December B Program 48D500000 5,427.26 5,427.26 28,593.57 Training 48D500000 1,849.00 1,849.00 7,276.26 4/4/2017 26,744.57 January 2017 Program 48D500000 6,466.07 6,466.07 6,466.07 2/23/2017 20,278.50 Training 48D500000 20,278.50 February Program 48D500000 11,587.93 11,587.93 8,690.57 Training 48D500000 4,727.80 4,727.80 16,315.73 4/4/2017 3,962.77 March Program 48D500000 2,856.77 2,856.77 2,856.77 1,106.00 Training 48D500000 1,106.00 1,106.00 1,106.00 5/11/2017 0.00 December C Program Training April Program Training May Program Training June Program Training Totals 70140.44 70140.44 70140.44 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Account 15230.0000.6500.48D5000000.0000.00000000(j Funds Available ( Detail Balances ) Period Di May -16 II _ Jun -16 0.00: • 0.00'. 30443.82 -30443.82, L1Adj 16 '1 0.00', 0.00 O.OOj 0.001 ' Jul -16 j 0.00' 0.00' 0.00] 0.00 [Aug -16 �L 0.00; 0.00' 10786.741 -10786.741 — 0.00• 0.00 . a 3100.40 3100.40' ' - Oct 16 I _ 0 00! 0.00 20670 206.70. . Nov -16 0.00 0.00 524.56' -524 56;' Li Jan 17 0.00 • --- — — 0.00' 6466.071 6466.071. IIDec 16 I 0.00; —— -- — — 0.00' 6890.74; -6890.74', IL L .0 Sep -16 Budget 0.00; Encumbrance Actual Funds Available 0.00i 18056.25] 18056.25 1 164533.001 0.00 124092.22; 40440.781 = - 1- JCancel Account 5230.0000.6500.48D5000000.0000.00000000( Period Funds Available ( Detail Balances ) Budget Encumbrance U1 -Sep -16 1 • 0.00 0.00 U10ct-16 I 0.001 0.00 , 206.70; -206.70' U[Nov-16 _1 0.00 0.00: • 524.56 -524.56 J(Dec 16 0 0.. i __ _o o0 - - --6-689 I Jan -17 0.00 0.00; 6466.07] 6466.OT 1 LFeb-17 - j 0.00I 0.00; 17015.1 , -17015.19] - J1Mar 17 0.001 0.00 2856.7j -2856.77, [Apr17 0.000.00 0.00 • 0:29.11 Actual Funds Available 3100.401 -3100.40- Pun -17 f 0.00'0.00,L 0.00; 164533.00: 0.o0`' 0.00} 0.00; • 0.001 124092.22E 40440.78 Cancel _❑x p41 KdSi t?.�r Account 5230.0000:6500 48D5000000:0000 00000000 . Funds Available (Detail Balances ) ) Period 'Budget Encumbrance Actual 'Funds Available ' , '{Mar 16 i - 0.0OiI •0.00 16536.07j ,. -16536 07 .. Apr -16 _ 0 00�._ 0 00' _ 0 00� _.:. 0 00 �,.l May 16 - 0.00 0.00 - 1360.2• -1360.28' . • i I : • . Jun -16 0.001 .0 .00. 251.16] '-251.16;k i L Adt 16 0 00 0.00 L f_ 0 00 0 00 • • LIJul 16 0 00 ____. j -__-_ 0 00 L_.._ __ _--_-_ __ ..I :-- - _- 0 00; 0 00'-'' ° u Aug -16, �� 0 00 ( 0.00 2873.56; 2873 561 .. ' Sep 16 1I 0.00 0.00 , , •. `3712.50 3712 50' Oct -16 ii 0 00i 0.00 3491..68i • • -3491.68,1;r, - ' Nov 1.6 1I 0 00;�, 0 00, 2564.73J[ •-2564 73 0.00 0 00 40440 78' . -40440.78: j I i Cancel Account 5230.0000 6500.48D5000000:0000.00000000(• .. ___. _. Funds Available ( Detail Balances ) Period • Budget Encumbrance Actual ' Funds Available ' Sep 16 0 00'I ' 0.00i 3712 501 -3712.50r ( L Oct 16 0 00! 0 001 3491 68. ,3491.68; -. 1 L Nov 16 0 00 0 001 2564 73-L ( " -2564 73: � L1 Dec 16 l i • 0 00 .. - ! :. ' 0 00 1968001968.0 • 0 u Jan -17 I 0.00 0.00; - 0.00; • . • 0.00 .. la. Feb -17 • . .' 0.00 . ` . 0.00 - 6576,.80; . -6576_80H Mar 17 0 00 0 001 1106 00 1106.00 l -)Apr ! 17: 000 000 OOOI 000 , (j May -17 ' • 0.0a . 0.00 0.00' 0.00 Jun 17 I 0.00 0 00, 0 001 000 . 17 0 00 0 00, . 40440 78 -40440.781 ,Cancel,, 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 7/1/2015 PROGRAM INCOME START DATE Page 1 of 2 YEAR OF FUNDS FY16 TITLE/PROGRAM/PROJECT_ DW LOCAL ADMIN TRANSFER ADULT CLEAR Program code 4BD5000000 END DATE_ 6/30/2017 END DATE I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported �" ' �F _ 2. Current Program and Admin Cash Needs 6,983.10 3. FINAL Program and Admin Cash Needs Contract to Date 6,983.10 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 2. Current Expenses + Accruals (Through End Date of Award) 0.00 3. FINAL Program Expenses Contract to Date 0.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 5. Current Expenses+Accruals (Through End Date of Awards) 6,983.10 6. FINAL Administrative Expenses Contract to Date 6,983.10 III. PROGRAM INCOME(PI) EXPENSE REPORT , ,.., a 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION 1. FINAL Cash Request Contract to Date 6,983.10 2. FINAL Expenses Through End of Contract 6,983.10 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes D /No ❑ V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 VI. RECONCILIATION 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 VII. MATCH RECONCILIATION M 3ua i !k w lM i' 1. FINAL Match Reported Through End of Contract 2. FINAL Expenses Through End of Contract 6,983.10 3. Match Percentage of Expenditure Contracttual Requirement 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. Preparers Signature Date 9/%//7 DateNOV 9 2 2n17 ' Authorized Signatuc .tf r, See instruction for completing this for on the next tab (Attachment H 2 of c2' 7- &9`.71/ ,Orud! Appli(ationi'- PROD Ed. Edit 0'au Folder Dols ;y duo, 00k, (W b,(9'I('3:altiA9 EDtl)tic'+l ;:;?. ;...i j I: i _-: • iI5rcs-dT!�°Jma7. .. 3 ..•-io0 t IlApr-I0 I�May-ifi. (IJun-16 IMO.,. IIJ 'SOP �I Actual ' Funds Available 0.W!�= . Account 5230.0000.0500.4BD5000000.0000.00000000 ' Funds Period - . - Available ( Detail Balnces ) ' -. Budget ' Encumbrance r . 0.001 4 0.001• ' .. D.00 0.00 : ,- 000 ...__331700 '. 3317.004 0.00 0.00 000 O.IXP.. FIR 000 1- �- 0.00 Oo0 Ooo --` 000 -000 O.ODr` OOOt -16 6, ISOP-116 000.: 000 .- 000 - _ 000 OoO':: 0.00�� 000f ' J Nov -I6 tr- 0.00.1 ,.-. .._; 0001.- 7�{; _.7%610- 70&'�,{- .._ ..__ Doc-1O - .. .� 0.00. - o.00r_ . . . 0.00, 0004 6983.10 - 0.00 6963.10 0.ET _U0; :. I r ... :-. _ ORACLE' Rem0C0000 ' I I - I - .., I -osc. 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 7/1/2015 PROGRAM INCOME START DATE YEAR OF FUNDS_ PY15 TITLE/PROGRAM/PROJECT_ 25% Enhanced DW CLEAR Program code 4D95000000 Attachment H Page 1 of 2 END DATE_ 6/30/2017 END DATE I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported ' r 2. Current Program and Admin Cash Needs 19,758.00 3. FINAL Program and Admin Cash Needs Contract to Date 19,758.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 19,758.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 19,758.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 v a -- ,' 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION �er 1. FINAL Cash Request Contract to Date 19,758.00 2. FINAL Expenses Through End of Contract 19,758.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes 0 /No 0 V CASH REQUEST PROGRAM INCOME CASH REPORTED , 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 VI. RECONCILIATION 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 VII. MATCH RECONCILIATION 1. FINAL Match Reported Through End of Contract 2. FINAL Expenses Through End of Contract 19,758.00 3. Match Percentage of Expenditure Contracttual Requirement 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes 0 /No 0 *The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signature Date /� O//9. Authorized Signature �� / 'mob / ,- ` —" � Date N0V 2 2 2017 See instruction for completing this for on the next tab (Attachment H 2 of &9/7- ,39W/ CLEAR WIOA Reconciliation -Enhanced Dislocated Worke► Reporting Month 'Program Code 'General Ledger 'Billed 'Received 'Date Received 'Grant Balance August Program Training FY 14 4D9500000 4KD300000 4KD300000 8,416.00 48,785.00 19,758.00 48,785.00 48,785.00 September Program Training 4KD300000 4KD300000 3,522.27 6,514.24 48,785.00 48,785.00 October Program Training 4KD300000 4KD300000 40.91 763.91 48,785.00 48,785.00 November Program Training 4KD300000 4KD300000 248.26 1,696.73 48,785.00 48,785.00 December Program Training 4KD300000 4KD300000 2,519.67 993.33 48,785.00 48,785.00 December B Program Training 4KD300000 4KD300000 1,686.26 2,353.74 48,785.00 48,785.00 January Program Training 4KD300000 4KD300000 0.00 48,785.00 0.00 0.00 5/11/2016 48,785.00 February Program Training 4KD300000 4KD300000 0.00 0.00 48,785.00 48,785.00 March Program Training 4KD300000 4KD300000 16,731.29 20,699.59 7,357.45 28,085.41 48,785.00 6/21/2016 28,085.41 0.00 March Program 4D9500000 19,758.00 4,061.06 4,061.06 6/21/2016 15,696.94 December C Program Training 4KD300000 4KD300000 0.00 0.00 0.00 0.00 April Adjustment Program Training 4KD300000 4KD300000 -3,522.27 -14,930.24 3,522.27 18,452.51 April Adjustment Program Training 4D9500000 4D9500000 3,522.27 14,930.24 12,174.67 -2,755.57 April Adjustment 4D9500000 Program -4,061.06 -1,305.491 April Adjustment 4KD300000 Program 4,061.06 18,452.51 14,391.45 April Program Training 4KD300000 4KD300000 0.00 0.00 14,391.45 14,391.45 May Program Training 4KD300000 4KD300000 rte.._.,._ _�..,, 1,055.34 1,053.34 1,053.34 7/1/2016[ : 13,338.11 0.00 0.00 June Program Training 4KD300000 4KD300000 11,873.33 11,873.33 13,338.11 7/27/2016?_ 1,464•,781 1,464.78 1,464.78 0.00 Totals 67237.51 67237.51 67237.51 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 CLEAR WIOA Reconciliation -Enhanced Dislocated Worker Reporting Month 'Program Code (General Ledger (Billed 'Received (Date Received (Grant Balance June 4D9500000 1,305.49 July PY 15 Program 4D9500000 0.00 0.00 1,305.49 Training 4D9500000 0.00 0.00 1,305.49 August Program 4D9500000 0.00 0.00 1,305.49 Training 4D9500000 0.00 0.00 1,305.49 September Program 4D9500000 0.00 0.00 1,305.49 Training 4D9500000 0.00 0.00 1,305.49 October Program 4D9500000 0.00 0.00 1,305.49 Training 4D9500000 0.00 0.00 1,305.49 November Program 4D9500000 1,305.49 1,305.49 1,305.49 12/31/2016 0.00 Training 0.00 December Program 0.00 Training 0.00 June Program 0.00 Training 0.00 Totals 1305.49 1305.49 1305.49 FY 16 4F0500000 46,102.00 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 Account 15230,0000.6500.4095000000.0000.000000000 -- --- ---- Funds Available ( Detail Balances ) -- — — — -- — — — — —_, , Period Budget Encumbrance Actual _ Funds Available Mar 16 0.00; 0.00( 4061.061 - -4061.06' I 1.[Apr 16 a0 0.00 0.001 538.79; 538.79', May -16 _)I 0.00 0.00 0.00: ------------- - --O-Ol1l--------------- 0.00' Jun -16 �l 0� 0.00 0.00 L Ad1-16 ^.. __ji f — 0.001 - - 0-001 _.__ __.__ a.. __: 0 00` -.. - - 0.000j L� Jul -16 IL 0.00;1 . - _ 0.001 0.00. -- - 0.00 ' 1 Aug 16 JI 0.001 . 0.001 0 0Q 0 00`x: r Se 16 ' 0.00 0 00 0.00' 0.00 Li Oct 16 0.00;1 0.00'1 0.00:. 0 00; • "INov-16 U 0.* s 0.0o 1305.49'-1305.49 ; .,..7 19758.00;1 0.0O1 4827.76i 14930.24! . - - ^ ` L_ _:._ .. J 1. - — ._ Cancel Account 5230.0000.6500.4D95000000.0000.00000000(� • --- Funds Available ( Detail Balances ) T___._..__-___.______ _._..`__..-_--=--_-_..___-- _ _-• Period Budget Encumbrance Actual • Funds Available ' Apr -16 -0.00 0.00 14930.24;; • -14930.24i �iMay i6 • 0.00; 0..00J _• 000:__. 'OA0 Jun 16 —~ �_ 0.00 0=00� 0.001- ___ _______I Adj-16 0.00 0.00; • 0.00; . 0.00 I I Jul -16 0.00' 0.00, 0.00 0: 00. rl Aug 16 0.00 0 00; 0 00 0.00 IL] Sep 16 000 000 000 .000 ;. Oct -16 .-i 0.00' 0.00 0.00: 0.00 L Nov -16 J 0.00 0.001 0.00 0.00)�j L Dec -16 . ` 0.00'' 0.00; 0.00, O.OOy: 0.001 0.00. 14930.24! -14930.24} . : Cancel ) . 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 7/1/2015 PROGRAM INCOME START DATE YEAR OF FUNDS_ PY 15 TITLE/PROGRAM/PROJECT_ DW LOCAL ADMIN CLEAR Program code 4DB5000000 Attachment H Page 1 of 2 END DATE_ 6/30/2017 END DATE I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported - ¢_ 2. Current Program and Admin Cash Needs 3,317.00 3. FINAL Program and Admin Cash Needs Contract to Date 3,317.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 2. Current Expenses + Accruals (Through End Date of Award) 0.00 3. FINAL Program Expenses Contract to Date 0.00 ADMINISTRATIVE EXPENSE (ER) k 4. Total Expenses+Accruals Previously Reported (Through Last Month) 5. Current Expenses+Accruals (Through End Date of Awards) 3,317.00 6. FINAL Administrative Expenses Contract to Date 3,317.00 III. PROGRAM INCOME(PI) EXPENSE REPORT 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION r; 1. FINAL Cash Request Contract to Date 3,317.00 2. FINAL Expenses Through End of Contract 3,317.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 ) a & 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0 00 VI. RECONCILIATION 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 VIL MATCH RECONCILIATION .. ww `" 1. FINAL Match Reported Through End of Contract 2. FINAL Expenses Through End of Contract 3,317.00 3. Match Percentage of Expenditure Contracttual Requirement 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes ❑ /No ❑ 'The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding penod. Preparer's Signature --�-"'' / 71 Date / .2-617 Authorized Signature �"� (!� -5§.Q 1? e2 -.I� Date NOV 2 2 2017 See instruction for completing this for on the next tab (Attachment H 2 of 2 024/7-49 L/ CLEAR WIOA Reconciliation -Adult Administration Reporting Month 'Program Code 'General Ledger 'Billed 'Received 'Date Received 'Grant Balance June 46A500000 26,433.73 July 46A500000 772.19 26,433.73 July 4DB500000 3,317.00 3,317.00 August 0.00 August 46A500000 2,157.15 2,929.34 23,504.39 September 46A500000 2,688.17 2,688.17 20,816.22 October 46A500000 0.00 20,816.22 November 46A500000 2,860.15 2,860.1.5 17,956.07 November Adjustment 4BD50000 17,956.07 December 46A500000 2,678.24 2,678.24 15,277.83 December B 46A500000 3,135.35 15,277.83 January 15,277.83 February 46A500000 598.75 3,734.10 11,543.73 March 46A500000 1,824.36 1,824.36 9,719.37 December C 9,719.37 April 46A500000 2,330.07 2,330.07 7,389.30 May 46A500000 2,555.41 2,555.41 4,833.89 June 4,833.89 Moved to 48A5 4,833.89 Totals 24,916.84 21,599.84 0.00 0.00 4DB5 General ledger vs billied 3,317.00 Billed not received 21,599.84 General ledger vs. received 24,916.84 •C.' ‘', .r grt,. � :f u lull - o x Account [5230.0000 6500 4DB5000000.0000 00000000 - ------ Funds Available (Detail Balances ) _ ,.._��__ r_-._._ _----__.-- Period Budget Encumbrance , Actual • Funds Available I Jun 16 . '. i 0.00';. 0.00;[ 0.00 L ' 0 OOk= Adj 16 1 0.00j • . 0.00; 0.00; 0 00 i : • I• I L Jul -16 ll 0.001 • 0.00; 0.00, • 00 0['' I Li L Aug -16 1 0.00 0.0d 3317.00 L3317.00,, Sep 16 I 0.00 0 00 - __--- - 0 _ • . -- _ _.. ____ 00 I Oct -16 0.00 0.00 . 0 00' 0 00: - ; Nov -16 0 00. 0 00:.. ' -0.00 _1 0.00 . _.. _ _ ..___—_. __ I ( Dec -16 0.00 , 0 00 • 0 00: • 0 00 , ; I b Jan -17 I 0.00 • 0.00! 0 00' 0 00; ., ' Feb 17 1 - —000;.. — 000 _ _ _ 000 — — 000 . 3317.0d 0.0Q . 3317.00 O.OOi [• [ I Cancel - ) . COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT GRANT CLOSEOUT RECONCILICATION WORKSHEET SUBRECIPIENT:_ Employment Services of Weld County ADDRESS: PO BOX 1805 Greeley, CO 80632 CONTRACT/EAIWORKPLAN START DATE 10/1/2016 PROGRAM INCOME START DATE Attachment H Page 1 of 2 YEAR OF FUNDS_ PY15 TITLE/PROGRAM/PROJECT_ WIA CWDC-5% DW COUNCIL INITIATIV CLEAR Program code 4DW5000000 END DATE_ 6/30/2017 END DATE I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 2. Current Program and Admin Cash Needs 20,490.00 3. FINAL Program and Admin Cash Needs Contract to Date 20,490.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 20,490.00 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 0.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 0.00 III. PROGRAM INCOME(PI) EXPENSE REPORT C. 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION 1. FINAL Cash Request Contract to Date 20,490.00 2. FINAL Expenses Through End of Contract 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) 20,490.00 Yes I] /No ❑ V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Total PI Cash Previously Reported on Cash Request Ca . h )gr - 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 W. RECONCILIATION n �. „ 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 VII. MATCH RECONCILIATION 1. FINAL Match Reported Through End of Contract 2. FINAL Expenses Through End of Contract 20,490.00 3. Match Percentage of Expenditure Contracttual Requirement 4. Match Expenditure Requirement 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) 0.00 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 : y Date //.7--‘)// 7 -- Authorized Signature �1 L4 /' Q C DateNOV 2 2 2017 See instruction for completing this for on the next tab (Attachment H 2 of 2 2o/7-.&91/ CLEAR WIOA Reconciliation -Performance Incentive Reporting Month 'Program Code 'General Ledger 'Billed 'Received 'Date Received 'Grant Balance 20,490.00 July 2016 4DW5000000 0.00 20,490.00 August 4DW5000000 0.00 0.00 20,490.00 September 4DW5000000 0.00 0.00 20,490.00 October 4DW5000000 0.00 0.00 20,490.00 November 4DW5000000 0.00 20,490.00 December 4DW5000000 0.00 20,490.00 December B 4DW5000000 0.00 20,490.00 January 2017 4DW5000000 2,992.13 2,992.13 2,992.13 5/23/17 17,497.87 February 4DW5000000 2,368.75 2,368.75 2,368.75 5/23/17 15,129.12 March 4DW5000000 0.00 0.00 0.00 15,129.12 April 4DW5000000 6,352.70 6,352.70 6,352.70 5/23/17 8,776.42 May 4DW5000000 6,611.94 6,611.94 6,611.94 6/26/17 2,164.48 June 4DW5000000 2,164.48 2,164.48 2,164.48 7/21/17 0.00 Totals 20,490.00 20,490.00 20,490.00 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 0, ..X'dd!tt" .- s t`r' '°j 4i1„ .-44i , Y - • • -- ". r' -- O X Account 15230.0000: 6500:4DW5000000.0000.0000000U ;-- -- ----- Funds Available ( Detail Balances ) Budget - Encumbrance - Actual funds Available ' ('Period IIep-16; • jf .• 0.00: 0:00; 0.00if ;0 O0 - . `- IJoct 16 I 0.00; 0.0 . • clod! _ 0 00li1, ' ENov 16 000 000 ' 0.001 000 LI Dec 16 t 0 00: - 0 00; 0.0Q1 0.0Q;- f L Jan -17 0.00; 0.00; ; 0.0011 0.00;;, . Feb 17 ( 0 DO! • o —.-.__0 00, • 0- --0 00 L _ - ,0 003 ' T Mar -17 -I. 0.00I 0.001 .;O.OO�I 0 00' . • LI Apr 17 JL 0 00 0 00 11713.58! -11713 58 May 17 0 00f ___- 0 001 6611.94I __._ _ _. .'-6611:94 • .. Jun 17 0 00 —�0 00 2164.48j '-2164.48 .20490.0Q1_ 0.00 20490.00 0.001 Cancel 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 10/1/2016 PROGRAM INCOME START DATE YEAR OF FUNDS_ FY15 TITLE/PROGRAM/PROJECT_ 25% DW ENH ADMIN CLEAR Program code 4ED4000000 Page 1 of 2 END DATE. 6/30/2017 END DATE I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported __ 2. Current Program and Admin Cash Needs 6,422.00 3. FINAL Program and Admin Cash Needs Contract to Date 6,422.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 0.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 6,422.00 5. Current Expenses+Accruals (Through End. Date of Awards) 6. FINAL Administrative Expenses Contract to Date 6,422.00 III. PROGRAM INCOME(PI) EXPENSE REPORT 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION w>, .ft'°r.ok , 1. FINAL Cash Request Contract to Date 6,422.00 2, FINAL Expenses Through End of Contract 6,422.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes 0 /No O V. CASH REQUEST PROGRAM INCOME CASH REPORTED a ° 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 VI. RECONCILIATION _e . 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 6,422.00 3. Match Percentage of Expenditure Contracttual Requirement 4. Match Expenditure Requirement 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) 0.00 Yes 0 /No 0 *The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signature / 7 Authorized Signature 17--A' Date NOV 2 2 2017 /�Date LL�C ' / 11 See instruction for completing this for on the next tab (Attachment H 2 of 2) O,2 -p/ 7-ca94L/ CLEAR WIOA Reconciliation -Enhanced Dislocated Worker Administration Reporting Month 'Program Code 'General Ledger 'Billed 'Received 'Date Received 'Grant Balance June 2016 FY15 6,422.00 July 4ED400000 0.00 0.00 6,422.00 August 4ED400000 0.00 0.00 6,422.00 September 4ED400000 0.00 0.00• 6,422.00 October 4ED400000 0.00 0.00 6,422.00 November 4ED400000 6,422.00 December 4ED400000 6,422.00 December B 4ED400000 6,422.00 January 2017 4ED400000 0.00 6,422.00 February 4ED400000 6,422.00 March 4ED400000 0.00 6,422.00 April 4ED400000 1,110.59 6,422.00 May 4ED400000 1,400.19 2,510.78 2,510.78 7/21/2017 3,911.22 June 4ED400000 3,911.22 3,911.22 3,911.22 7/21/2017 0.00 Totals 6,422.00 6,422.00 6,422.00 General ledger vs billied 0.00 Billed not received' 0.00 General ledger vs. received 0.00 0 + Fr - I I 07) N; - ' ! D1 i Q 7 Jan -17 I ,IDec-16 I) Z O O ' u) i j CD 1. 8422 00 o O L.P i 0 0 , P. O O OAP O O+ i O 0 Lo_ O, O `o . O O `o_ I O, .0 Lo 0 ! 0 moo_ 1000.6500.4E04000000.1 Available ( Detail Balanc Budget ! '0 ;o i !010;0 io'.O O 0 O 0!0`0 '0 f 10 0 0 O 0!0 o io 000.000000001. es ) Encumbrance 6422.00 6422.001 J. � IO + O ',O,LO IO lb O O O O O; O_ . I P 0 LO t0 10 I O O O _O'. O O `0.,. ! � ji i0 O L O_ Actual Funds Available 0.00 Cancer ,_. i pipo o.Jo ��oo_ o b ,_Q o 0 Lo_� 1 (o o o i I l0 !O �0 0 O 0 0 0-,0 0 io �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 10/1/2016 PROGRAM INCOME START DATE YEAR OF FUNDS_ FY15 TITLE/PROGRAM/PROJECT_ 25 % ENHANCED DW CLEAR Program code 4FD4000000 Page 1 of 2 END DATE_ 6/30/2017 END DATE I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 2. Current Program and Admin Cash Needs 57,600.00 3. FINAL Program and Admin Cash Needs Contract to Date 57,800.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 2. Current Expenses + Accruals (Through End Date of Award) 57,800.00 3. FINAL Program Expenses Contract to Date 57,800.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 0.00 III. PROGRAM INCOME(PI) EXPENSE REPORT 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION 57,800.00 1. FINAL Cash Request Contract to Date 2. FINAL Expenses Through End of Contract 57,800.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes O /No 0 V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 W. RECONCILIATION F 0.00 1. FINAL Program Income Cash 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 57,800.00 3. Match Percentage of Expenditure Contracttual Requirement 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes 0 /No 0 'The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signature Date -w / .7-- Authorized Signature ( iii C)C'ep DatjVOV 2 2 2017 See instruction for completing this for on the next tab (Attachment H 2 of 20 / 7- �9� / CLEAR WIOA Reconciliation -Enhanced Dislocated Worker Reporting Month 'Program Code 'General Ledger 'Billed 'Received 'Date Received 'Grant Balance June 4D9500000 1,305.49 July PY 15 Program 4D95000000 0.00 0.00 1,305.49 Training 4D95000000 0.00 0.00 1,305.49 August Program 4D95000000 0.00 0.00 1,305.49 Training 4D95000000 0.00 0.00 1,305.49 September Program 4D95000000 0.00 0.00 1,305.49 Training 4D95000000 0.00 0.00 1,305.49 October Program 4D95000000 0.00 0.00 1,305.49 Training 4D95000000 0.00 0.00 1,305.49 November Program 4D95000000 1,305.49 1,305.49 1,305.49 12/31/2016 46,102.00 Program 4FD5000000 16,658.80 16,658.80 16,658.80 12/31/2016 29,443.20 December Program 4FD5000000 8,492.04 8,492.04 8,492.04 12/31/2016 20,951.16 Training 20,951.16 December B Program 4FD5000000 3,228.33 3,228.33 3,228.33 12/31/2016 17,722.83 Training 17,722.83 January Program 4FD5000000 -1,436.52 -1,436.52 -1,436.52 4/4/2017 19,159.35 Training 19,159.35 February Program 4FD5000000 -70.75 -70.75 -70.75 4/4/2017 19,230.10 Training 19,230.10 March Program 19,230.10 Training 19,230.10 April Program 4FD5000000 19,230.10 19,230.10 19,230.10 5/30/2017 57,800.00 Program 4FD4000000 10,044.55 10,044.55 10,044.55 47,755.45 May Program 4FD4000000 33,658.68 33,658.68 33,658.68 7/21/2017 14,096.77 Training 14,096.77 June Program 4FD4000000 14,096.77 14,096.77 14,096.77 7/21/2017 0.00 Training 0.00 Totals 105207.49 105207.49 105207.49 FY 16 4FD500000 46,102.00 General ledger vs billied 0.00 Billed not received' 0.00 General ledger vs. received 0.00 Account 15230.0000.6500.4FD4000000.0000.00000000c i— ---------- Funds Available ( Detail Balances ) I Period • Budget Encumbrance Actual Funds Available _ 1 L Sep 16 1 )— 0.00I, 0.00'.., 0.00, 0 00—) Oct -16' 0.06 0 00; 0 00; 0.00; i { l Nov -16 II 0 00' 0-001 -- __ 0.00: - - 0.001 , L Dec -16 i • 0.00; . 0.00t - - o.00 • 0.00; . L Jan -17 J 0.00 0.00 o.00 o_oo I Feb 17 0 00 j 0.00 0.00 1. 0.00 v �• Mar 17 0.00 0 00, 0 ool 0 ool 1 j Apr -17 . 0.00' 0 00 0.001 - 0.00 May -17 , 0.00 0.00 0.00 . 0.00 !'• { ' Jun -17 ' 0.00' 0.001 - • 57800.00' -57800.001: 57800.001 0.00 57800.00, ' 0.001 I _� — I____ _--- -- -_ ___.___._—._ _� L_ a:_._ — — ---I Cancel 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 7/1/2015 PROGRAM INCOME START DATE YEAR OF FUNDS FY16 TITLE/PROGRAM/PROJECT_ EDW PROGRAM CLEAR Program code 4FD5000000 Page 1 of 2 END DATE_ 6/30/2017 END DATE I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 2. Current Program and Admin Cash Needs 46,102.00 3. FINAL Program and Admin Cash Needs Contract to Date 46,102.00 II. PROGRAM EXPENSE REPORT (ER) • 1. Total Expenses+Accruals Previously Reported (Through Last Month) 2. Current Expenses + Accruals (Through End Date of Award) 46,102.00 3. FINAL Program Expenses Contract to Date 46,102.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 0.00 III. PROGRAM INCOME(PI) EXPENSE REPORT 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION 46,102.00 1. FINAL Cash Request Contract to Date 2. FINAL Expenses Through End of Contract 46,102.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes 0 /No 0 V. CASH REQUEST PROGRAM INCOME CASH REPORTED - - 3 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 . 0.00 1. FINAL Program Income Cash 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 46,102.00 3. Match Percentage of Expenditure Contracttual Requirement 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes 0 /No 0 'The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal lung/mg period. Preparer's Signature Dat��// • Authorized Si nature Clati$113V 2. 2 2017 See instruction for completing this for on the next tab (Attachment H 2 of 2) CLEAR WIOA Reconciliation -Enhanced Dislocated Worker Reporting Month 'Program Code 'General Ledger 'Billed 'Received 'Date Received 'Grant Balance June 4D9500000 1,305.49 July PY 15 Program 4D95000000 0.00 0.00 1,305.49 Training 4D95000000 0.00 0.00 1,305.49 August Program 4D95000000 0.00 0.00 1,305.49 Training 4D95000000 0.00 0.00 1,305.49 September Program 4D95000000 0.00 0.00 1,305.49 Training 4D95000000 0.00 0.00 1,305.49 October Program 4D95000000 0.00 0.00 1,305.49 Training 4D95000000 0.00 0.00 1,305.49 November Program 4D95000000 1,305.49 1,305.49 1,305.49 12/31/2016 .46,102.00 Program 4FD5000000 16,658.80 16,658.80 16,658.80 12/31/2016 29,443.20 December Program 4FD5000000 8,492.04 8,492.04 8,492.04 12/31/2016 20,951.16 Training 20,951.16 December B Program 4FD5000000 3,228.33 3,228.33 3,228.33 12/31/2016 17,722.83 Training 17,722.83 January Program 4FD5000000 -1,436.52 -1,436.52 -1,436.52 4/4/2017 19,159.35 Training 19,159.35 February Program 4FD5000000 -70.75 -70.75 . -70.75 4/4/2017 19,230.10 Training 19,230.10 March Program 19,230.10 Training 19,230.10 April Program 4FDS000000 19,230.10 19,230.10 19,230.10 5/30/2017 57,800.00 Program 4FD4000000 10,044.55 10,044.55 10,044.55 47,755.45 May Program 4FD4000000 33,658.68 33,658.68 33,658.68 7/21/2017 14,096.77 Training 14,096.77 June Program 4FD4000000 14,096.77 14,096.77 14,096.77 7/21/2017 0.00 Training 0.00 Totals 105207.49 105207.49 105207.49 FY 16 4FD500000 46,102.00 General ledger vs Willed 0.00 Billed not received' 0.00 General ledger vs. received 0.00 Account 15230.0000.6500.4FD5000000.0000.00000000t '----------- Funds Available(.Detail Balances) —_ _ _�___._____._ ___ -_._._� Period , • Budget Encumbrance Actual Funds Available 1ISep16 0:00 • 0 001 - 0.00] 0 00� , L Oct:16 0 00 0.0010.00 _ - 0 00, { L Nov 16 0.00 .. •"' 0.00;1. " 16658.801 • -16658.80!':: Dec 16 000, _._.._ 0001 • 8492 04' -8492.041 — -- Jan 17 - '.._ 0.00, . ^. O.OOL� 0 00 0.00� . IFeb 17, i 0.00. 0.00! 1721:061. =1721 06 JIMar-17 •. 0 00 : 0.00' � 0 00 ' -0.00; L IApr 17 ) 0.00' 0.00 19230 101 "• 19230 10�� . 1 IMay 17 j 0 00I 0 00 . ` 0.00' 0 00' `- IlJuri-17 I • 000{I 0 00 , 0 001 0 00- '' . 71968 00ii 0 00 46102.00 '.25866.00I L ( -Cancels ). 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 5/10/2017 PROGRAM INCOME START DATE Attachment H Page 1 of 2 YEAR OF FUNDS_ FY15 TITLE/PROGRAM/PROJECT WIA WFD 3.75% TECH ASSIST LOCALS CLEAR Program code 4GD4000000 END DATE_ 6/30/2017 END DATE I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 2. Current Program and Admin Cash Needs 12,500.00 3. FINAL Program and Admin Cash Needs Contract to Date 12,500.00 II. PROGRAM EXPENSE REPORT (ER) 12,500.00 1. Total Expenses+Accruals Previously Reported (Through Last Month) 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 12,500.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 0.00 III. PROGRAM INCOME(PI) EXPENSE REPORT 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION 1. FINAL Cash Request Contract to Date 12,500.00 2. FINAL Expenses Through End of Contract 12,500.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes OX /No 0 V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date 0.00 VI. RECONCILIATION 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date - 0.00 3. Total PI Cash Balance 0.00 VII. MATCH RECONCILIATION 1. FINAL Match Reported Through End of Contract 2. FINAL Expenses Through End of Contract 12,500.00 3. Match Percentage of Expenditure Contracttual Requirement 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 /.2--"g"--7 Authorized Signature (�-CP ,� � � � DateNOV 2 2 2017 See instruction for completing this for on the next tab (Attachment H 2 of 2) 07_4/7- 0901 CLEAR W/OA Reconciliation-DVOP Reporting Month 'Program Code 'General Ledger 'Billed 'Received 'Date Received 'Grant Balance June 2016 4GD4000000 12,500.00 July 4G D4000000 0.00 12,500.00 August 4GD4000000 0.00 0.00 12,500.00 September 4GD4000000 0.00 0.00 12,500.00 October 4GD4000000 0.00 0.00 12,500.00 November 4GD4000000 0.00 12,500.00 December 4GD4000000 0.00 12,500.00 December B 4GD4000000 0.00 12,500.00 January 2017 4GD4000000 0.00 12,500.00 February 4G D4000000 0.00 12, 500.00 March 4G D4000000 0.00 12,500.00 April 4G D4000000 0.00 12, 500.00 May 4G D4000000 0.00 12,500.00 June 4GD4000000 12,500.00 12,500.00 12,500.00 7/21/17 0.00 Totals 12,500.00 12,500.00 12,500.00 General ledger vs billied 0.00 Billed not received' 0.00 General ledger vs. received 0.00 Account 5230.0000.6500.4GD4000000.0000.00000000j Funds Available ( Detail Balances ) , Period '!Sep -16 . . FllOct 16 Nov -16 Budget Encumbrance 0.001 0.00� 0.00 LI Dec -16 , J 0.00 • Jan -17 - 0.00— --= 0.00 0-00 0.00' -- — 0-00 Actual Funds Available O.OOI 0.00- • o.00 l 0.00; r Feb -17 • . I 0.001 _ .0.00; Mar -17 0.00' 000, I Apr -17- 0.00, - . 0.00, 0.00' 0.00; 0.00: 0.00 0.00;[ • 0.00;' ---- 0.00 --- -- - — . 0:00 • 0.00; 0.00. 0.00; 0.001 0.00! -- — _ 0.00Li '! May 17 0.00 0.00 0.00: 0.00 r U Jun -17 • 0.00' 0.00' 12500.00; 12560.00g 12500.00] 0.00! 12500.00. Cancel ,.. 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 7/1/2015 PROGRAM INCOME START DATE Page 1 of 2 YEAR OF FUNDS_ FY16 TITLEIPROGRAM/PROJECT_ DW LOCAL PRG TRANSFER ADULT CLEAR Program code 4ND5000000 END DATE_ 6/30/2017 END DATE I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 2. Current Program and Admin Cash Needs 164,533.00 3. FINAL Program and Admin Cash Needs Contract to Date 164,533.00 II. PROGRAM EXPENSE REPORT (ER) , r 1. Total Expenses+Accruals Previously Reported (Through Last Month) 2. Current Expenses + Accruals (Through End Date of Award) 164,533.00 3. FINAL Program Expenses Contract to Date 164,533.00 ADMINISTRATIVE EXPENSE (ER) , . • 4. Total Expenses+Accruals Previously Reported (Through Last Month) 5. Current Expenses+Accruals (Through End Date of Awards) - 6. FINAL Administrative Expenses Contract to Date 0.00 III. PROGRAM INCOME(PI) EXPENSE REPORT - 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current.Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract _ 0.00 IV. RECONCILICATION - 164,533.00 1. FINAL Cash Request Contract to Date 2. FINAL Expenses Through End of Contract 164,533.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes 2 /No O V. CASH REQUEST PROGRAM INCOME CASH REPORTED 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 164,533.00 3. Match Percentage of Expenditure Contracttual Requirement 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes 0 /No 0 'The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding period. Date 7� Preparers Signature �7 6 Authorized Signature l NOV222017 Date See instruction for completing this for on the next tab (Attachment H 2 of O2h , 7, X954/ CLEAR WIOA Reconciliation -Adult Reporting Month 'Program Code 'General Ledger 'Billed 'Received 'Date Received 'Grant Balance Jun -16 48A500000 42,011.86 July Program 48A500000 23,765.67 42,011.86 Training 48A500000 993.82 42,011.86 August Program 48A500000 12,544.13 36,309.80 5,702.06 Training 48A500000 4,708.24 5,702.06 0.00 August 164,533.00 Program 4ND500000 4,755.01 4,755.01 159,777.99 Training 4ND500000 0.00 0.00 159,777.99 September Program 4ND500000 15,650.39 15,650.39 144,127.60 Training 4ND500000 11,860.78 11,860.78 132,266.82 October Program 4ND500000 13,681.24 13,681.24 118,585.58 Training 4ND500000 6,205.10 6,205.10 112,380.48 November Program 4ND500000 13,923.74 13,923.74 98,456.74 Training 4ND500000 5,434.26 5,434.26 93,022.48 December Program 4ND500000 14,520.21 14,520.21 78,502.27 Training 4ND500000 9,329.50 9,329.50 69,172.77 December B Program 4ND500000 10,438.34 69,172.77 Training 4ND500000 2,890.00 69,172.77 Jan -17 Program 4ND500000 6,585.08 6,585.08 62,587.69 Training 4ND500000 3,247.65 3,247.65 59,340.04 February Program 4ND500000 11,950.43 22,388.77 36,951.27 Training 4ND500000 7,583.11 10,473.11 26,478.16 March Program 4ND500000 11,378.11 11,378.11 15,100.05 Training 4ND500000 15,100.05 15,100.05 0.00 December C Program Training April Program Training May Program Training June Transfer funds from 4BD5 11,297.90 and 4,833.89 46A5 Program Accrual 4ND5 16,131.79 Training Totals 222,676.65 206,544.86 0.00 General ledger vs billied 16,131.79 Billed not received I 206,544.86 General ledger vs. received 222,676.65 Account .152 30.0000.6500.4 N D 5000000.0000.00000000; • — - - - Funds Available ( Detail Balances ) • • --------- _.--__.- Period Budget Encumbrance Actual Funds Available 1Jul-16 ._._.__.. 1.._._ - _... _ 0:0 1 _.__-_.._-.-_- ---0-o0 . ...----._ -- 000' - --- ----- -- _o.o ,. Aug -16 j1 , 0.00; . - 0.00,1 4755.01 -4755.01F ' Sep -16 I 0.00; 0.00L 15650.39! -15650.39] Oct 16 J 0.00; 0.00 13681.24; -1368,.24;1 UINov-16 • J . 0.00 0.00; 13923.741 , -13923.74j Dec 16 I 0.00', 0.00; 14520.21 jL -14520.21{ u Jan -17 ' . 1 . 0.00; 0.00, - . 6585.08, -6585.08', ("Feb -17 I 0.00' 0.00L 22388.77; -22388.77._ il Mar -17 ! 0.00' 0.001 1137811! -11378.11j J Apr -17 ( 0.00, 0.001 0.00 - 0.000 164533.001 0.001 102882.55' 61650.45 1 L 1 I J Cancer_ • Account 5230.0000.6500.4ND5000000.0000.00000006 - Funds Funds Available ( Detail Balances )-__._...._____:___.__..-----.____._ _...�.__._-------__..._____y Period Budget Encumbrance Actual Funds Available Adj-16 ! 0.00' . 0.00' 0.00 - 0.00,= UJul-16 - IL 000; - 000 000, 0.00; Aug -16 - I 0.00 0.00, 0.00, - . 0.00 11 Sep -16 I • 0.00 0.0( . 11860.78', -11860-78', I Oct -16 ! 0.001 0.00; 6205.1O -6205.10', I I Nov -16 0.001— - 0.00 5434.26, . -5434.26] L Dec -16 I 0.00;1 0.00; 9329.50 -9329-50' i Jan 17 1 0.001 0.00 3247.651 -3247.65 Li Feb 17 JI — — • 0.001 0_00 .. _-- - 10473.111 - - - ._. 10473.11 • Li Mar 17 0.001 0.00 li 15100.05,1 1510O.05jJ 0_00; 61650.451 -61650.451 -- --- --0.001 - - - - .- • - Cancel' , J 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 2/23/2016 PROGRAM INCOME START DATE Page 1 of 2 YEAR OF FUNDS_ FY15 TITLE/PROGRAM/PROJECT_ 25% DW HIRE CO'ADMIN CLEAR Program code 4OD4000000 END DATE. 12/31/2016 END DATE I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 2. Current Program and Admin Cash Needs 21,374.00 3. FINAL Program and Admin Cash Needs Contract to Date 21,374.00 II. PROGRAM EXPENSE REPORT (ER) ., • - 1. Total Expenses+Accruals Previously Reported (Through Last Month) 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 0.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 21,374.00 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 21,374.00 III. PROGRAM INCOME(PI) EXPENSE REPORT •- 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION 1. FINAL Cash Request Contract to Date 21,374.00 2. FINAL Expenses Through End of Contract 21,374.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes 2 /No 0 V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date _ 0.00 W. RECONCILIATION 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 WI. MATCH RECONCILIATION 1. FINAL Match Reported Through End of Contract 2. FINAL Expenses Through End of Contract 21,374.00 3. Match Percentage of Expenditure Contracttual Requirement 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes 0 /No 0 'The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signature Date ? / 7. _ Authorized Signature r-��{,�"� \grade./' 1 Cl Y Date NOV 2 2 2017 See instruction for completing this for on the next tab (Attachment H 2 of CLEAR WIOA Reconciliation -Hire CO Administration Reporting Month (Program Code 'General Ledger (Billed 'Received 'Date Received (Grant Balance June 11,418.00 July 4O0400000 0.00 0.00 0.00 11418.00 August 4O0400000 181.20 181.20 181.20 10/13/15 11236.80 September 4O0400000 402.31 284.12 284.12 3/8/16 10952.68 October 4O0400000 i._ 0.00( 0.00 November 4O0400000 6618.63 6655.47 6655.47 3/3/16 4297.21 December 4O0400000 1078.35 1078.35 1078.35 1/27/16 3218.86 10952.68 December B 4O0400000 445.00 3218.86 January 4O0400000 530.89 975.89 975.89 5/11/16 2242.97 Febraury 4O0400000 March 4OD400000 2242.97 2242.97 2242.97 6/21/16 0.00 0.00 0.00 2242.97 March 4O0400000 8565.21 9956.00 December C 4O0400000 0.00 9956.00 April 4O0400000 4717.73 9956.00 May 4O0400000 -12127.20 0.00 0.00 7/1/16 9956.00 June 4O0400000 0.00 1237.09 1237.09 7/27/16 8718.91 Totals 12655.09 12655.09 12655.09 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 CLEAR WIOA Reconciliation -Hire CO Administration Reporting Month 'Program Code 'General Ledger 'Billed 'Received (Date Received 'Grant Balance June FY 15 8,718.91 July 4OD400000 1209.02 8718.91 August 4OD400000 2210.93 3419.95 3419.95 12/14/16 5298.96 September 4OD400000 2891.17 2891.17 2891.17 12/14/16 2407.79 October 4OD400000 0.00 0.00 0.00 2407.79 November 4OD400000 1754.94 1754.94 1754.94 12/27/16 652.85 December 4OD400000 652.85 652.85 652.85 2/6/17 0.00 December B 4OD400000 0.00 January 4OD400000 0.00 Febraury 4OD400000 0.00 March 4OD400000 0.00 March 4OD400000 0.00 December C 4OD400000 0.00 April 4OD400000 0.00 May 4OD400000 0.00 June 4OD400000 0.00 Totals 8718.91 8718.91 8718.91 General ledger vs billied 0.00 Billed not received' 0.00 General ledger vs. received 0.00 Account 5230.0000.6500.40D4000000.0000.00000000' • - - -------- Funds Available ( Detail Balances ) ---- __, - • j----------- . Period Budget Encumbrance Actual Funds Available Jul 15 11418.00 • 0 00; •0.00 11418.00��1 I_ Aug -15 j 0.00II 0.00i -_ - - 181_20, - 181 20iI Sep 15 0.0011 0.00• 284.121 -284.121i . i Oct -15 - 9956.00' 0.00 0.00; 9956.00'.. ti Nov 15 }L 0.O 0 00] 6655.47;-6655.47 L„ LI Dec 15 0 00' 0.00! 1078.35; -1078.35,' i Jan -16 ' 1 - 0.001 0.00 975.89;1 -975.89] Feb -16 I • 0.00, 0.00' 0.00;1 0.00'i : J Mar -16 i — —0.00 - - 0.00i 2242 97) 2242-971. ir Apr -16 j - I 0.00 0.001, • 0.00, ___:__;,__0.00.1F • I `21374.01 0.001 21374.00:•1 0.00, i Cancel'. _ . Account (5230:0000.6500.40D4000000.0000.00000000' — Funds Available ( Detail Balances ) Period Budget Encumbrance Actual - Funds Available 1 DIApr-16 { 0.001 0.00 0.001 •0.00 —' May -16 — - - — 0 00 0.00 0.00 0:00 l Jun 16 J 0.00 0.00{ 1237.09;L 1237.09; '1Ad 16 ' j- - l 006 I 000 000 000.. t Jul -16 I 0.00 0 00 0.00; _ _ 0.008 Aug -16 I 0.00 0.00 - 3419.95' . -3419.951i_ • L Sep 16 i 0.00 ;0...00 2891.1.7 -2891.17 :. •. J Oct 16 j 0.00 0.00' 0.00; - 0 00 . Nov -16 - • • 0.00•' 0.00' 1754.941 -1 .. -1754.94i ' Dec 16 A 0R00, 0.00 652.85; -652.8.51t- — - - _, i- 21374.00`1 0.00, 21374.00; 0.00 - I'll II I. • Cancel•. . ) 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 2/23/2016 PROGRAM INCOME START DATE Page 1 of 2 YEAR OF FUNDS_ FY15 TITLEIPROGRAM/PROJECT_ 25% DW Hire for CO Program CLEAR Program code 4PD4000000 END DATE_ 12/31/2016 END DATE I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 2. Current Program and Admin Cash Needs 187,535.79 3. FINAL Program and Admin Cash Needs Contract to Date 187,535.79 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) 187,535.79 2. Current Expenses + Accruals (Through End Date of Award) 3. FINAL Program Expenses Contract to Date 187,535.79 ADMINISTRATIVE EXPENSE (ER) • 4. Total Expenses+Accruals Previously Reported (Through Last Month) 5. Current Expenses+Accruals (Through End Date of Awards) 6. FINAL Administrative Expenses Contract to Date 0.00 III. PROGRAM INCOME(PI) EXPENSE REPORT 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION 1. FINAL Cash Request Contract to Date 187,535.79 2. FINAL Expenses Through End of Contract 187,535.79 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 W. RECONCILIATION : 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance 0.00 WI. MATCH RECONCILIATION 1. FINAL Match Reported Through End of Contract 2. FINAL Expenses Through End of Contract 187,535.79 3. Match Percentage of Expenditure Contracttual Requirement 4. Match Expenditure Requirement 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) 0.00 Yes O /No O 'The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding period. Preparer's Signature Date/ . Authorized Signature Date N422201? `��' (-- <_-Yie .€? ( ./ f � See instruction for completing this for on the next tab (Attachment H 2 of 2) o2.0i7-o 94'f CLEAR W/OA Reconciliation -Hire CO Reporting Month 'Program Code (General Ledger 'Billed (Received (Date Received (Grant Balance June FY 15 97,924.79 July 4PD400000 17048.39 6256.39 6256.39 10/13/15 91,668.40 August September 4PD400000 8170.15 8288.34 8288.34 3/8/16 62,851.98 October 4PD400000 22466.80 22466.80 22466.80 12/1/15 40,385.18 4PD400000 9736.08 20528.08 20528.08 10/15/15 71,140.32 November 4PD400000 24729.95 24693.11 24693.11 3/3/16 15,692.07 December 4PD400000 13086.77 13086.77 13086.77 1/27/16 2,605.30 December B 4PD400000 1657.12 2,605.30 January 4PD400000 -1269.77 387.35 387.35 5/11/16 2,217.95 Febraury 4PD400000 -1168.33 0.00 2,217.95 March 4PD400000 4824.47 2217.95 2217.95 6/21/16 0.00 March 4PD400000 89,611.00 December C 4PD400000 137.61 89,611.00 April 4PD400000 5922.26 89,611.00 May 4PD400000 3745.25 0.00 0.00 7/1/16 89,611.00 June 4PD400000 4642.40 16972.69 16972.69 7/27/16 72,638.31 72,638.31 Totals 113729.15 114897.48 114897.48 General ledger vs bullied -1,168.33 Billed not received I 0.00 General ledger vs. received -1,168.33 CLEAR WIOA Reconciliation -Hire CO Reporting Month 'Program Code 'General Ledger 'Billed 'Received 'Date Received 'Grant Balance June FY 15 -1168.33 72,638.31 July 4PD400000 4196.71 72,638.31 August 4PD400000 19039.99 22068.37 22068.37 12/14/16 50,569.94 September 4PD400000 28055.69 28055.69 28055.69 12/14/16 22,514.25 October 4PD400000 12479.77 12479.77 12479.77 12/14/16 10,034.48 November 4PD400000 8532.85 8532.85 8532.85 12/27/16 1,501.63 December 4PD400000 1501.63 1501.63 1501.63 2/6/17 0.00 December B 4PD400000 0.00 January 4PD400000 0.00 Febraury 4PD400000 0.00 March 4PD400000 0.00 March 4PD400000 0.00 December C 4PD400000 0.00 April 4PD400000 0.00 May 4PD400000 0.00 June 4PD400000 0.00 Totals 72638.31 72638.31 72638.31 General ledger vs billied 0.00 Billed not received' 0.00 General ledger vs. received 0.00 -Z. ti i . 41' 2N'.•°tai`z; ail 17 . _ t- I. s ry .e . .. t , . LAPP, ,°:l Account 15230:0000.6500.4PD4000000.0000.00000000i Funds Available ( Detail Balances) I , _ I Period Budget Encumbrance Actual Funds Available jj Jul -15 i 97924.79i 0.00 6256 39 91668.401- I Aug -15 - • 0.06 0.00' • 20528 081 -20528.081 L Sep -15 _--! — —000 — 0.00' 8288.341 -8288.34i J Oct -15 1 - 89611.00, 0.00 22466.80' 67144:20 _- L1 -15 0.00;- 0.00j 24693.111° -24693.11 •.; i -Nov Dec -15 0.001 0 00 13086.77 13086 77t 1 LI Jan 16 0.00 0.00 387.35' 387.35 Feb 16 1 — — — 0.00t 0.0G - - - 0.00 0.00J : U1Mar-16 0.00 0.00. 2217.95!. -2217.951 —_-1 C IA 16 I _ 0 00;L - - - 0.00;_^- 0.00i-__.. ,._ __ 0.00:c.-' '187535.79 0.00 187535.79 0.00 j I.. J 1 _ - = - - Cancels.: J Account 15230.0000.6500.4PD4000000.0000.00000000 Funds Available ( Detail Balances ) `—__------_•_._.__---____.._.____._-----.._.----_.-___ .- . Period Budget Encumbrance Actual Funds Available 1 LApr-16 ! 0.0011 . 0.00; o.000.00 ` May 16 0.00 0 00; 0.00; 0.00'. •it I Jun -16 1 0.00 __ 0.00 _ 16972 69, __ _.-_ _-.-16972.69Jj Adj 16 1_ 0.00. 0.0011 o. of): 0.00 ; i 1Jul-16 I 0.09j 0.00 . 0.001 0.00! I Aug16 - -I 0.00 0.06 - 22068.3r ' - Sep_ 16 -' — 0-001.- 0.00 28055.69 1 28055.69 — — _--- : I 1_i Oct 16 1 0 0.00 12479.77:-12479.77 I Nov -16 0.001 0.00; 8532 85 -8532.851 I Dec -16 - 1 0.00 . 0.00 1501.63 • -1501.63c I- 187535.79 0.00 187535.79;1 0.001 f 1 _ • I._ _— — I ,_. ____ ,___, Cancel '' 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 7/1/2015 PROGRAM INCOME START DATE Attachment H Page 1 of 2 YEAR OF FUNDS_ PY15 TITLE/PROGRAM/PROJECT_ 10% YOUTH LOCAL ADMIN CLEAR Program code 4Y65000000 END DATE_ 6/30/2017 END DATE I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 2. Current Program and Admin Cash Needs 61,902.00 3. FINAL Program and Admin Cash Needs Contract to Date 61,902.00 II. PROGRAM EXPENSE REPORT (ER) - .. • 1. Total Expenses+Accruals Previously Reported (Through Last Month) 2. Current Expenses + Accruals (Through End Date of Award) 0.00 3. FINAL Program Expenses Contract to Date 0.00 ADMINISTRATIVE EXPENSE (ER) 4. Total Expenses+Accruals Previously Reported (Through Last Month) 5. Current Expenses+Accruals (Through End Date of Awards) 61,902.00 6. FINAL Administrative Expenses Contract to Date 61,902.00 III. PROGRAM INCOME(PI) EXPENSE REPORT 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION � .,, 1. FINAL Cash Request Contract to Date 61,808.92 2. FINAL Expenses Through End of Contract 61,902.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes ❑ /No 2 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' ; 0.00 1. FINAL Program Income Cash 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 61,902.00 3. Match Percentage of Expenditure Contracttual Requirement 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes ❑ /No ❑ 'The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding perod. Preparer's Signature Date / 2 // .. Authorized Signature t Date QV 2 2 2017 �� See instruction for completing this for on the next tab (Attachment H 2 of CLEAR WIOA Reconciliation -Youth Administration Reporting Month Program Code 'Program General Ledger 'Billed Received Date Received Grant Balance June 2016 4Y65000000 31,581.55 July 4Y65000000 YIS 2,228.61 31,581.55 YOS 3,481.40 31,581.55 August 4Y65000000 YIS 1,274.17 3,502.78 12/31/16 31,581.55 YOS 2,312.83 9,297.01 5,794.23 22,284.54 September 4Y65000000 YIS 1,679.28 1,679.28 12/31/16 22,284.54 YOS 2,123.75 3,8.03.03 2,123.75 18,481.51 October 4Y65000000 YIS 0.00 0.00 18,481.51 YOS 0.00 0.00 18,481.51 November 4Y65000000 YIS -98.90 -98.90 -98.90 12/31/16 18,580.41 YOS 3,849.95 3,849.95 3,849.95 14,730.46 December A 4Y65000000 YIS 1,047.30 1,047.30 1,047.30 2/6/17 13,683.16 YOS 3,674.72 3,674.72 3,674.72 10,008.44 December B 4Y65000000 YIS 1,116.62 1,116.62 1,116.62 4/4/17 8,891.82 YOS 5,098.19 5,098.19 5,098.19 3,793.63 January 2017 4Y65000000 YIS 0.00 3,793.63 YOS 0.00 3,793.63 February 4Y65000000 YIS 321.70 321.70 321.70 4/4/17 3,471.93 YOS 1,565.67 1,565.67 1,56.5.67 1,906.26 March 4Y65000000 1,906.26 4Y65000000 YIS 498.43 498.43 498.43 5/11/17 1,407.83 YOS 1,813.18 1,314.75 93.08 4Y66000000 YOS 1,843.29 2,341.72 3,656.47 5/11/17 30,956.00 December C 4Y66000000 YIS 28,614.28 YOS 28,614.28 April 4Y66000000 YIS 452.32 452.32 452.32 5/23/17 28,161.96 YOS 2,873.07 2,873.07 2,873.07 25,288.89 May 4Y66000000 YIS 579.53 579.53 579.53 6/26/17 24,709.36 YOS 3,237.75 3,237.75 3,237.75 21,471.61 June 4Y66000000 YIS 106.22 106.22 106.22 7/21/17 21,365.39 YOS 791.12 791.12 791.12 20,574.27 Totals 41,870.20 41,870.20 41,870.20 General ledger vs billied Billed not received I General ledger vs. received 0.00 0.00 0.00 Account [5_230.0000.6500.4Y65000000.0000.000000006, Funds Available ( Detail Balances ) Period Budget Encumbrance ' Mar -16 II 0.001 0.00.1 14643.42; -14643.42'1#. j Apr 16 11 0.00 0.00 0.00 0.00 L May 16 II. 0.00. 0.00L 10814.21, -10814.21; . ' Jun -16 1 0.00 0.00; 4862.82 -4862.82: 11 Adj-16 1 0.001 0 00 0.0 0:00' r Jul -16 1 0:001 0.00' _0. (10 0.00"; J Aug -16 I i 0.00 • 0.00 9297.01 jl 9297.01 IJ Sep -16 11 0.001 • 0.00 3803.03' -3803.03] Oct -16 if 0.00f 0.00 0.00 0 00' - . - L - Nov -16 11 0 00'1 0.00 3751.05' -3751 05x9 Actual Funds Available 61902.00 0.00' " 61808.92] 93.08 . Cancel Account 15230.0000.6500.4Y65000000.0000.00000000( . r- Funds Available ( Detail Balances ) I . i • Period ' Budget Encumbrance - Actual Funds Available IISep-16 0.001 0.00, 3803.03L 3803.03=' • UlOct-16 I - 0.00;1 0.00. 0.00 - 0.00;. 1 f Nov 16 i . ' 0.00', 0.00, 3751.05 -3751.05 • i Dec 16 ( 0 00 0 00' 4722.02 -4722.021 j Jan -17 0.001 0.00: Feb -17 II 0.00 0.00 _— --- --_-- 8102.18, --____ -- -8102.18' Mar -17 0 00'1 0.00' 1813.1d — _1813.181 Li Apr -17 i 0.00 1 0.00; 0 00 0.o0 j May -17 . 1 • • 0.00[ 0.00; 0.00! 0.00 LlJun 17 0.0O1 O.OOI O.OO�L 0,00 61902.001 0.00;1 61808.921_ • 93.081 _ _-- -__ ! I __ _ _ _ _. �_.— — -- -- — _ --! Cancel, 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 7/1/2015 PROGRAM INCOME START DATE Page 1 of 2 YEAR OF FUNDS_ PY15 TITLE/PROGRAM/PROJECT_ YOUTH 75% OUT OF SCHOOL LOCAL CLEAR Program code 4Y75000000 END DATE_ 6/30/2017 END DATE 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 „_ • .. .. . - 417,837.00 417,837.00 II. PROGRAM EXPENSE REPORT (ER) 1. Total Expenses+Accruals Previously Reported (Through Last Month) ' . ' ." 2. Current Expenses + Accruals (Through End Date of Award) 417,837.00 3. FINAL Program Expenses Contract to Date 417,837.00 ADMINISTRATIVE EXPENSE (ER) °" s' • 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 - l 1. Total Program Income Exoenses Reported (Last•Quarter) 2. Current Program Income Expenses (Through End Date of Contract) - 3. TOTAL PI Expenses Through End Date of Contract - 0.00 IV. RECONCILICATION ` ' '' " 1. FINAL Cash Request Contract to Date 417,783.00 2. FINAL Expenses Through End of Contract 417,837.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 W. RECONCILIATION 1. FINAL Program Income Cash 0.00 2. Less Program Income Exoenses Through Contract End Date 0.00 3. Total PI Cash Balance - .0.00 WI. MATCH RECONCILIATION 1. FINAL Match Reported Through End of Contract 2. FINAL Expenses Through End of Contract 417,837.00 3. Match Percentage of Expenditure Contracttual Requirement 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes O /No O -The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding penod. Preparer's Signature Date // -6i ! • Authorized Signature -r5-1,1 DatNOV 2 2 Z017 See instruction for completing this for on the next tab (Attachment H 2 of oboe 7- mil/ CLEAR WIOA Reconciliation Youth Out Of School Reporting Month 'Program Code 'General Ledger 'Billed 'Received 'Date Received 'Grant Balance Jun -16 4Y7500000 31,705.67 July YOS 4Y75-8200 3,417.17 Program 4Y7500000 7,094.88 Training 4Y7500000 4,732.49 31,705.67 31,705.67 31,705.67 August YOS 4Y75-8200 4,118.83 Program 4Y7500000 12,288.30 Training 4Y7500000 0.00 7,536.00 19,383.18 4,732.49 31,651.67 24,169.67 4,786.49 54.00 4Y7600000 YOS 4Y76-8200 Program 4Y7600000 Training 4Y7600000 September 4Y7600000 YOS 4Y76-8200 Program 4Y7600000 Training 4Y7600000 October YOS 4Y76-8200 Program 4Y7600000 Training 4Y7600000 November YOS Program Training December A YOS Program Training December B YOS Program Training January YOS Program Training February YOS Program Training June YOS Program Training Totals 31,651.67 31,651.67 31,651.67 General ledger vs billied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 CLEAR WIOA Reconciliation_Youth Out Of School Reporting Month 'Program Code 'General Ledger 'Billed 'Received bate Received 'Grant Balance June 4Y7400000 19,501.81 July Program Training PY 14 4Y7400000 4Y7400000 9,622.82 9,622.82 9,878.99 9,878.99 19,501.81 10/13/2015 9,878.99 0.00 October 4Y7400000 18, 683.90 18, 683.90 10/27/2016 July Progra m Training 4Y7500000 4Y7500000 4Y7500000 417,837.00 10,672.72 10,672.72 21,629.56 10/13/2015 407,164.28 31,651.67 10,956.84 10,956.84 396,207.44 August Program Training PY15 4Y7500000 4Y7500000 18,379.66 18,379.66 32,062.44 32,062.44 50,442.10 10/13/2015 345,765.34 377,827.78 September Progra m Training PY 15 4Y7500000 4Y7500000, 25,120.89 25,120.89 10,427.29 10,427.29 35,548.18 3/8/2016 310,217.16 320,644.45 October Progra m Training PY 15 4Y7500000 4Y7500000 16,921.81 16,921.81 15,163.37 15,163.37 32,085.18 12/1/2015 278,131.98 293,295.35 November Program Training PY 15 4Y7500000 4Y7500000 18,263.10 18,263.10 259,868.88 9,257.451-- 9;257.451 18,263.10 3/3/2016 259,868.88 December A Program Training PY 15 4Y7500000 4Y7500000 24,816.64 24,816.64 18,086.96 18,086.96 42,903.60 1/27/2016 216,965.28 235,052.24 December B PY 15 Program 4Y7500000 Training 4Y7500000 7,239.72 460.00 216,965.28 216,965.28 January Program Training PY 15 4Y7500000 4Y7500000 9,882.50 17,122.22 7,902.33 8,362.33 25,484.55 5/11/2016 191,480.73 199,843.06 February YOS Program Training PY 15 4Y75-8200 4Y7500000 4Y7500000 156.34 191,480.73 18,472.98 18,472.98 27,709.24 7/27/2015 173,007.75 9,236.26 9,236.26 163,771.49 March YOS Informal Mod. Program Training PY 15 4Y75-8200 from 4Y64 4Y7500000 4Y7500000 580.48 736.82 736.82 6/21/16 163,034.67 18683.90 163,034.67 23,806.23 23,806.23 139,228.44 r • ~ 23,469.63 32,727.08 56,533.31 6/821/2016 106,501.36 April YOS Program Training PY 15 4Y75-8200 4Y7500000 4Y7500000 228.74 25,938.95 13,797.48 106,501.36 106,501.36 106,501.36 May YOS Program Training PY 15 4Y75-8200 4Y7500000 4Y7500000 56,571.51 20,876.24 85,625.12 16,392.07 23,647.12 61,978.00 -35,924.01 13,797.48 58,320.84 7/1/2016 48,180.52 June YO5 Program Training PY 15 4Y75-8200 4Y7500000 4Y7500000 3,450.45 3,450.45 3,450.45 7/27/16 44,730.07 7,084.93 7,084.93 13,024.40 7/27/2016 37,645.14 5,939.47 5,939.47 31,705.67 Totals 424,317.04 424,317.04 424,317.04 General ledger vs billied 0.00 Billed not received 1 0.00 General ledger vs. received 0.00 or_aftial ' as ,4 ifEl.)y'" i C— t=7 Account 5230.0000.6500.4Y75000000.0000.00000000( — Funds Available ( Detail Balances ) . Period Budget Encumbrance . Actual - Funds Available _-'' ''.Adj-15 '1 " 0.00E 0.00, 0.001 . - 0.o f ii Jul -15 417837.001 0.00' 10672.72x) 407164 28 Li Aug -15 . 0.001 0.00; 18379.66 -18379.661 L1 Sep -15 j - 0.00.1 0.00 25120.89' -25120.89'; ti Oct -15. ; 0.00 0.00 1692181' • -1692181 Nov -15 -.... _.._.. _.! 0.00; _.._..-._.___-._._..__ ..._.. 0.00 11.. 18263.10t' ...-,. _...._. __._--- --;.- 18263.10 -...__.__- Dec -15 IL 0.00 0.00 _I 24816 641 J, -24816.64i1 !~ Jan -16 i - 0.00' 0.00 17122 221 • -17122.22; L Feb -16 i( • 0 00; 0.00 18472.98 -18472.98,1! p Mar -16 - i1 0.001 0.00; 23806: 23] -23806.23 _ L 417837.001 0.00'223691.481 194145.52 L ? I i • ( Cancel • j-A.i Account 15230.0000.6500.4Y75000000.0000.00000000(! ---.- Funds Available( Detail Balances ) , .__—__._.._... _-----_;:_—.____....__------.—_------_-----�- Period - Budget Encumbrance Actual Funds Available ' Apr -16 '1' 0.00 0. 0.001 0.00,- May 16 0.00 0.00• 23647.12? -23647.121 Li Jun 16 0.0 0.00; 7084.93; -7084.931 , Adl16 0.00j 0.00; 0 001 0.00, r} Jul 16 - i - 0.00; 0.00' - 0.00; - -0 001 Aug 16 _ • 19383.18' - 0 00'' 0 00, - 1 -19383.18" -_: ----- Sep 16 _- 0 00 0 00I . 0 00 0.00, ,• Oct 16 0.0q 0:00' 0 00 0.00 Nov -16 j 0.00, 0.00, 0.001_ ''.0.00)'. -16 - I , 0.00; 0.00; 0.0011 0.00h - _[Dec . 417837.00 0.00 223691.48.1. 194145.52; I . I i I — I Cancel o X Account 5230.0000.6500.4Y75000000:0000.00000000( -- Funds Available ( Detail Balances ) Period Budget Encumbrance Actual Funds Available 1 956. j - Aug' 15 0.00' + - 0.00j 320062 441 32062. _ _ • ;,1 Sep -15 ! 0.00! 0.00' 10427 29 _10427.29; r I Oct -15 0.00; 0 00 15163.37! -15163.37 I Nov -15 ! 0.00' 0.00, 0.00' 0.00 ,-18086.96 Dec -15 : I 0.00j 0.00; 18086.96; [l Jan 16 _,____j 0.00 0.00; 8362.33a 8362.33;` lFeb 16 0.00; 0.00' 9236:26; -9236.261 Mar 16 ! 0.001 0.00 32727.08; 32727.08;, Apr -16 10.001 - 0.00; 0.00; . • 0.00 0.00! 0.00 _. 161492.011 -161492.011• 1 _ Cancel x Account I5230.0000.6500.4Y75000000.0000.0000000 — — --- Funds Available ( Detail Balances ) Period Budget Encumbrance LIIFeb-16 Mar -16 -' 0.00; ILApr-16---- J�- _.__..---0.00 1 May -16 J Jun -16 I 0.00 !� Adj-16 1 Jul -16 V Aug -16 Sep -16 I ' Oct -16 IF - - Actual Funds Available o.001 0.0] 0.00 L o.00:` 0.00 736.82, 736.82' - _--- --_--- ----� 0.001---- --- - - .. 0.00!,I 0.00`1 0.00' .. 0.00 20876 244 20876.24! 0.00}1 3450.45L -3450.451 0.00, 0.00'1 0.00: 0.00} 0.00, 0.00;1_ 0.00" 0.00 -: . 0.00; - _._.. o.00j 7536.00; :._ -7536.00i- 0.001 0.00'1 o.oat :0.00; ' 0:00 0.00. 0.00 0.0O , 0.00; 0.001 • 32599.51'1 -32599.511 • Cancel 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 7/1/2015 PROGRAM INCOME START DATE Page 1 of 2 YEAR OF FUNDS_ PY 15 TITLE/PROGRAM/PROJECT_ YOUTH IN SCHOOL LOCAL PROGRAM CLEAR Program code 4Y85000000 END DATE_ 6/30/2017 END DATE I. CASH REQUEST 1. Total program and Admin Cash needs Preciously Reported 2. Current Program and Admin Cash Needs 139,278.00 3. FINAL Program and Admin Cash Needs Contract to Date 139,278.00 II. PROGRAM EXPENSE REPORT (ER) , 1. Total Expenses+Accruals Previously Reported (Through Last Month) 2. Current Expenses + Accruals (Through End Date of Award) 139,278.00 3. FINAL Program Expenses Contract to Date - 139,278.00 ADMINISTRATIVE EXPENSE (ER) ti s" `• 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 Ill. PROGRAM INCOME(PI) EXPENSE REPORT 1. Total Program Income Exoenses Reported (Last Quarter) 2. Current Program Income Expenses (Through End Date of Contract) 3. TOTAL PI Expenses Through End Date of Contract 0.00 IV. RECONCILICATION 139,278.00 1. FINAL Cash Request Contract to Date 2. FINAL Expenses Through End of Contract 139,278.00 3. Cash Request to Date = Expense reported Through End Date of Contract? (Check Box) Yes O /No O V. CASH REQUEST PROGRAM INCOME CASH REPORTED 1. Total PI Cash Previously Reported on Cash Request 2. Current Program Income Cash (Through End Date of Contract) 3. FINAL Program Income Cash Contract to Date . 0.00 VI. RECONCILIATION 1. FINAL Program Income Cash 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 139,278.00 3. Match Percentage of Expenditure Contracttual Requirement 4. Match Expenditure Requirement 0.00 5. Total Match Reported > or = to Match Expenditure Requirement? (Check Box) Yes 0 /No 0 'The program Income Expense Report and Cash Request can only be extended through the availability of the Award and/or Federal funding penod. Preparer's Signature " • Date .1 / ' � Authorized Signature l 1l T 2 Date NOV 2 2 201t7 See instruction for completing this for on the next tab (Attachment H 2 of 2) 02.0 1-,69 CLEAR WIOA Reconciliation -Youth In School Reporting Month (Program Code (General Ledger (Billed 'Received 'Date Received (Grant Balance June FY16-17 61,142.17 Training 4Y8500000 -17113.71 Returned to the State -19,058.01 ` 80,200.18 July YIS 20% Work 4Y85-8200 4,077.59 80,200.18 Program 4Y8500000 1,896.09 80,200.18 Training 4Y8500000 689.98 80,200.18 Au ust YIS 20% Work 4Y85-8200 5,916.54 9,994.13 9,994.13 12/31/16 70,206.05 Program 4Y8500000 6,056.05 7,952.14 62,253.91 Training 4Y8500000 -510.00 179.98 8,132.12 12/31/16 62,073.93 September YIS 20% Work 4Y85-8200 1,796.34 1,796.34 1,796.34 12/31/16 60,277.59 Program 4Y8500000 6,601.95 6,601.95 6,601.95 12/31/16 53,675.64 Training . 4Y8500000 October YIS 20% Work 4Y85-8200 1,139.85 1,139.85 1,139.85 12/31/16 52,535.79 Program 4Y8500000 6,565.73 6,565.73 6,565.73 12/31/16 45,970.06 Training 4Y8500000 0.00 0.00 45,970.06 November YIS 20% Work 4Y85-8200 1,631.02 1,631.02 1,631.02 12/31/16 44,339.04 Program 4Y8500000 6,177.13 6,177.13 6,177.13 12/31/16 38,161.91 Training 4Y8500000 426.36 426.36 426.36 12/31/16 37,735.55 December A YIS 20% Work 4Y85-8200 1,499.56 1,499.56 1,499.56 2/6/17 36,235.99 Program 4Y8500000 6,555.11 6,555.11 6,555.11 2/6/17 29,680.88 Training 4Y8500000 25.00 25.00 25.00 2/6/17 29,655.88 December B YIS 20% Work 4Y85-8200 630.98 630.98 630.98 5/11/17 29,024.90 Program 4Y8500000 4,718.67 4,718.67 4,718.67 5/11/17 24,306.23 Training 4Y8500000 0.00 January YIS 20% Work 4Y85-8200 1,143.23 1,143.23 1,143.23 2/23/17 23,163.00 Program 4Y8500000 4,170.57 4,170.57 4,170.57 2/23/17 18,992.43 Training 4Y8500000 February YIS 20% Work 4Y85-8200 1,736.58 1,736.58 1,736.58 5/11/17 17,255.85 Program 4Y8500000 4,698.70 4,698.70 4,698.70 5/11/17 12,557.15 Training 4Y8500000 95.00 95.00 95.00 5/11/17 12,462.15 March YIS 20% Work 4Y85-8200 761.39 761.39 761.39 5/11/17 11,700.76 Program 4Y8500000 4,150.01 4,150.01 4,150.01 5/11/17 7,550.75 Training 4Y8500000 349.60 349.60 349.60 5/11/17 7,201.15 April YIS 20% Work 4Y85-8200 2,007.02 2,007.02 2,007.02 5/23/17 5,194.13 Program 4Y85000000 3,920.13 3,920.13 3,920.13 5/23/17 1,274.00 Training 4Y85000000 1,274.00 1,274.00 1,274.00 5/23/17 0.00 PRogram 4Y86000000 2,115.29 2,115.29 2,115.29 5/23/17 112,536.71 May YIS 20% Work 4Y86-8200 751.80 751.80 751.80 6/26/17 111,784.91 Program 4Y86000000 1,215.55 1,215.55 1,215.55 6/26/17 110,569.36 Training 4Y86000000 200.00 200.00 200.00 6/26/17 110,369.36 June YIS 20% Work 4Y86-8200 4,178.98 4,178.98 4,178.98 7/21/17 106,190.38 Program 4Y86000000 79.77 79.77 79.77 7/21/17 106,110.61 Training 4Y86000000 195.00 195.00 195.00 7/21/17 105,915.61 Totals 88,936.57 88,936.57 88,936.57 General ledger vs bullied 0.00 Billed not received I 0.00 General ledger vs. received 0.00 CLEAR WIOA Reconciliation -Youth In School Reporting Month (Program Code 'General Ledger 'Billed 'Received 'Date Received (Grant Balance June 4Y8400000 110, 579.23 July Program Training PY14 4Y8400000 4Y8400000 16` 540.24 16, 540.24 6,662.51 6,662.51 23, 202.75 10/13/15 103, 916.72 87,376.48 August Program 4Y8400000 8,461.93 8,461.93 21,353.81 10/13/15 78,914.55 Training 4Y8400000 12,891.88 12,891.88 66,022.67 September Program Training 4Y8400000 8,404.17 8,404.17 4Y8400000 6,706.82 6,706.82 15,110.99 3/8/16 50,911.68 57,618.50 October Program 4Y8400000 7,063.73 7,063.73 43,847.95 Training 4Y8400000 10,987.41 10,987.41 18,051.14 12/1/15 32,860.54 November Program 4Y8400000 7,395.30 7,395.30 7,395.30 3/3/16 25,465.24 Training 4Y8400000 4,079.87 J. 4,079.87 25,465.24 December A Program 4Y8400000 9,278.38 9,278.38 16,186.86 Training 4Y8400000 5,032.20 5,032.20 14,310.58. 1/27/16 11,154.66 December B Program 4Y8400000 2,688.99 11,154.66 Training 4Y8400000 83.00 11,154.66 Janua Program 4Y8400000 4,302.80 6,991.79 4,162.87 4Y8500000 139,278.00 Program 4Y8500000 174.84 174.84 139,103.16 Training 4Y8500000 0.00 83.00 7,249.63 5/11/16 139,020.16 February Program 4Y8400000 83.00 83.00 7/27/16 4,079.87 YIS 4Y85-8100 142.87 139,020.16 Program 4Y8500000 6,496.60 6,496.60 13,149.83 7/26/16 132,523.56 Training 4Y8500000 6,736.23 6,653.23 125,870.33 March Program 4Y8400000 4,079.871 0.00 YIS 4Y85-8100 110.52 253.39 253.39 6/21/16 125,616.94 Program 4Y8500000 7,833.11 7,833.11 117,783.83 Training 4Y8500000 15,809.67 15,809.67 27,722.65 6/21/16 101,974.16 April YIS 4Y85-8100 112.95 101,974.16 Program 4Y8500000 6,486.78 101,974.16 Training 4Y8500000 4,116.22 101,974.16 May YIS Program Training 4Y85-8100 57,776.79 18,234.89 83,739.27 4Y8500000 5,864.45 12,351.23 71,388.04 4Y8500000 -39654.85 4,116.22 34,702.34 7/1/16 67,271.82 June YIS 4Y85-8100 1,700.93 1,700.93 1,700.93 7/27/16 65,570.89 Program 4Y8500000 2,484.42 4,428.72 4,428.72 7/27/16 61,142.17 Training 4Y8500000 -17113.71 61,142.17 Returned to the State -19,058.01 -19,058.01 80,200.18 Totals 169,657.05 169,657.05 169,657.05 General ledger vs Willed 0.00 Billed not received I 0.00 General ledger vs. received 0.00 • Account ]5230:0000.6500.4Y85000000.0000.00000000( _ --- - _ -: Funds Available ( Detail Balances ) — - — ----_�_._-------__ _:-- ---- -- --. Period Budget Encumbrance Actual Funds Available ' Jan_ 16 JI. o.001_ 0.00 174.841 174 84]' I Feb -16 I• 6.6.66_.__--.•,l ___---_.—_-- 0.00' - __ -__-. _ 0 00 6496 60(( -6496 60 Mar-16 • 0.00 o oo! 7833 111 -7833.111 I 1 Apr -16 I 0.001 0.001 0.00; . 0.00, May 16 0.00 0.0O 12351 231 -1235123 Jun -16 0.00 0.001 4428.72 4428.72 J Adl 16 I - 0.00,i 0.00; 0 00, ' ' 0 00 11 Jul -16 J 0.0Q 0.0Q 0.00; 0.00 ]IAug 16 0.00 0.00] 7952.14! 7952.14; Sep -16 0.00j 0.p0L 6601.95 . 6601.95 • 139278.0(k 0.00;1 67736.631 • 71541.37. f J IH _ - - _ _ __ _ - -] __ __ _ ff Cancel Account 5230.0000.6500.4Y85000000.0000.00000000( • r - Funds Available'( Detail Balances ) Period Budget • Encumbrance Actual Funds Available I I 'I Se -16 0.00 0.00, • 6601 951 -6601 951._ — — 1 jIOct-16 I 0.001 0.00 6565.731 -6565.73' INov-16 ... 0.00 0 00, 6177.13! -6177.13 1 IDec-16 0.00I 0 00 6555.11i -6555.11 6555 . I, Jan 17 _ 0:00! 0 00 4170 571 A170.57 _ 66.66 __.. __ _ ---__._a ' ' 1 IFeb-17 f 0:001 0.001 0.00} 0.0Q, . I ]Mar -17 0.00I . 0.001 13567 38 -13567.38! (Apr -17 0.00; 0.001 -15137.88' • 15137:88 May -17 I 0 00 0.001 _._-. _.L _ __ _ 0.00. 0.00 _r_--.- --. ,, (Jun 17 i — .__.. T_ 0. - - �-00i _ - 0.00 1 -.0.00] • J - 139278.00 . 0.00, 67736.631 71541.37] __ _- --_T .._...l — — — — -- . Cancel ._.� _[, ?L4Ytra4. (4 it rC!?ak-' , tagii,,21 Account 5230.0000.6500.4Y85000000.0000.00000000d -- - - - Funds Available ( Detail Balances ) Period • Budget Encumbrance Actual Funds Available , Sep -16 . 0.00 0.00; 0.00, 0.00'= IL Oct 16 ,[ . 0.00' 0.00, 0.0 " , 0.00' • IL Nov -16 {l 0.00 0.00' 426.36 426.36 1] Dec 16 I0.001 0 00' - 25.00I - =25.00 U Jan -17 I 0.001 - - 0.00 0 00 - - - - 0.00 __ -0.00 • iL Mar 17 0:001 , 444.60' 444.60 ( 0.00 0.001E 1274.00,E -1274.00 -LApr-17 LI May -17 1 0.00 0.00'1 0.00, 0.00 '- ' Jun -17 0.00 0.00', . 0.00 0.0011z.) 0 00' 0.00L` 29012.061 • -29012.06 1__---_-m__ _____-� I____�---:__ i_�.__ . _._ _ ___--� ____y__� - ( Cancel 1:7F *'≥`i 11t-t-1A1.'L , 'g1-7,''.-;5' MO, Account 5230.0000.6500.4Y85000000.0000.00000000 -- Funds Available ( Detail Balances ) ____.._._.. ___..____.__._:_____ _...__._.______.._ ___:_____. —.- Period . Budget • Encumbrance Actual . Funds Available ' Mar 16 it • 0.001 i 0.00 253.39; -253.39;- 1[ pr -16 II 0.0011 0.00'0.00! 0.00 L May-16 it ....9:P0....; 0 00 18234.89; -18234.89' I Lun_ 16 1l 0.00;1 0 00; 1700.93. -1700.931 I Adj-16 I 0.00 0 00 0 00, . 0.00 L.1 Jul -16 11 0.00' 0.00 o.00} O.00 Aug 16 IIJI 0.00; 0.00 9994.13; 9994.13: ;: U Sep -16 , 11 0.001 . 0.00: - 1796.4; .. . -1796.34: 1 Oct 16 --iL--- -- ------- 0.04_____ --._.._0.00,------ --- _ - ---1139-85 ',I______ 1 - 1139,85; Nov -16 11 0.00;1 0.00, 1631.02; -1631.02. 0.00;1 . 0.001 42529.311 • -42529.311 . 1-- �_ I__�__ I • I l __ -- — -- ( . Cancel J Account 5230.0000.6500.4Y85000000.0000.00000000( - -=- Funds Available Detail Balances ) - - - - Period • Budget' Encumbrance Actual . Funds Available I ISep 16 -• 0.001 0.00 1796.34 11 :1796.34r - I -1LOct 16 0.00;1 • 0.0011 — --- 1139.85 - -- 1139_851' i 1 Nov -16 i 0.00'[ 0.001 • 1631 02 -1631.02i Dec -16 • 0.00 0 00: 1499.56 -1499.56'' U Jan -17 0.00' .. 0.00'1. 1143.23' -1143.23, — _—_ it Feb 17 i 0.00, 0 00' .__ 0 00 0.00' " Mar -17 j 0.00; 0.00,1 3128.95! • -3128.951' LApr-17 0.00 0 00,1— 2007 02i-2007.02 i V May -17 j 0.00' 0.00 0 00, 0.00 ', Jun 17 ? 000 0001 000 O.OOJ i 0.00j 0.00;1 42529.31' -42529.311 • { L 1 I 1 I I Cancel' Hello