Loading...
HomeMy WebLinkAboutGrant Related - BOCC (003)GRANT COUNTY BOARD OF COUNTY COMMISSIONERS 61 M 71LI7,6_09 To: Board of County Commissioners 41 From: Janice Flynn, Administrative Services Coordinator Date: May 5, 2022 Re: Authorization for Release of Funds, Dept of Commerce, CDBG #21-62210- 005, Reimbursement #3, Subrecipient O/C Request #3 01C has requested reimbursement regarding the above -referenced grant in the amount of $16,314.21 for March 2022 expenses. Their documentation is attached for review. I am requesting the release of funds for payment to 01C in the amount of_llk,314-21 Thank you. 1. AlT Of," _.. .... ........................ SIGNATURE OF ACCOUNTING PREPARER FOR PAYMENT DATE WARRANT TOTAL ACCOUNTING APPROVAL FOR PAYMENT -- DATE 'MkTE OF WASMNGTON DEPT OF COMMERCE ATTN: CDBG PROGRAM PO BOX 42525 :,OLYMPIA, WA 98504-2525 CON111MUN1111"ACTION AGENCY SUBRECtPIENT: OIC OF WASHINGTON 815 FRUrFVALE BLVD YAKM4A WA 98902 CONTRACT NO: 21-62210-005 REPORT PERIOD: .Mar-22 REPORT NUMBER: 9 . ... .. .... ..... COMMUNITY DEVELOPMENT BLOCK GRANT - PUBLIC SERVICES GRANTS C­ERT1F1CXTJ0,Nz tror,01Y that the information on this forin is a true and accurate report of the cash status and that all reported expenditures are property chargeable to the referenced grant. Starn ature: Printed Name: DEREJE MEKURIA Title: CFO Date: 5/4/2022 TOTAL AMOUNT REQUESTED THIS PERIOD: $16,314.21 ......................... . .. 1. Name of Service Program: Asset Development & Other Asset Development 125 11CDBG amount requested for these program activities this..,period: $12,411.91 Description of service program how low- and moderate -income {LMI persons were served this period: Housing counseling, credit coaching, foreclosure services business start-up, financial education workshops and high school classes. Free tax -prep. 2. Name of Service Program: Energ. 11CDBG amount requested for these program activities this period: $31902.29i y Assistance 208 'Description of service program how low- and moderate -income (LMEI) persons were served this period: Energy assistance and conservation Ieducation. . . . ...................... . . ,3-Name of Service Activity: Asset Develop/Energy Assist Adman -indirect Admin JICDBG amount requested for these program activities this period: $0.001. Description of service program how low- and moderate -income (LMI) persons were served this period: General administration expenses associated With managing energy assistance and asset development activities oversight and assessments. Indirect admin. . ............ Contract 21-62210-005 Submitted to GC by: OIC OF WASHINGTON Request for Reimbursement No. 09 MARCH 2022 Grant County's Subrecipien# Checklist: State Auditor's Office Audit Procedures for Testing Activities Allowed And Not Allowed, As Published In 2007 Questions to ask before submitting a payment request Was the expenditure or cost: X Made for an allowable activity under the grant guidelines? X Authorized (or not prohibited) under state or local laws or regulations? X Approved by the federal awarding agency, if required? N/A Allowable per Circular A-87 (June 2004 version), Attachment B, items 1-43? For payroll transactions: X Does the employee's time and effort documentation meet the requirements of Circular A-1 22? X Allocable to the program? (i.e.., was the dollar amount charged to the program relative to the benefits received by the program? Is the federal grantor being charged its fair share of the cost?) X Based on actual costs, not budgeted or projected amounts? X Applied uniformly to federal and non-federal activities (Leo, is the federal government being charged the same amount as if non-federal funds were being used to pay the cost)? X Given consistent accounting treatment within and between accounting periods? (Consistency in accounting requires that costs incurred for the same purpose, in like circumstances, be treated as either direct costs only or indirect costs only with respect to final cost objectives). X Calculated in conformity with generally accepted accounting principles, or another comprehensive basis of accounting, when required under the applicable cost principles? X Not included as a cost (or used to meet cost sharing requirements) of other federally -supported activities of the current or a prior period? X Net of all applicable credits? (e.g., volume or cash discounts, insurance recoveries, refunds, rebates, trade-ins, adjustments for checks not cashed, and scrap sales). N/A Not included as both a direct billing and as a component of indirect costs? N/A Properly classified (e.g., some costs may be incorrectly claimed as a direct cost instead of being incorporated as part of the indirect cost rate). X Supported by appropriate documentation? (e.g., approved purchase orders, receiving reports, vendor invoices, canceled checks, and time and attendance records.) Documentation may be in an electronic form. X Correctly charged to the proper account code and grant period? 1ADATAN ON SHARE D\ACCOUNTI NC\ingrid's stufRCDl3G\CDl3G M L 267 2021-22\Subrecipient Checklist 2020-2 LdocPage 1 OIC OF WASHINGTON For User: INGRID FRANK RW Expenditure report for: 267 - 267 CDBG Report year-, 7/1/2021 th ru 6/3012022 General Ledger System Period ending.- March 2022 To Date—Pct — Account Budget Expenditures Pct tsucgel . Expenditures Adrnn Adm in - Asset Dev/Energy Asst $0.00 $0.00 0.00% $0.00 $3,759.62 0.00% Asst Asset Development $0.00 $12,321.70 0.00% $0.00 $37,359.20 0.00% Ener Energy Assistance $0.00 $3,902.29 0.00% $0.00 $63964.34 0.00% Othe Other Asset Development $0-00 $90-22 0-00% $0.00 $90.22 0.00% Report Totals $0.00 $16,314.21 0.00% $0.00 $48,173.38 0.00% ;111 Page: Page I of 1 Date: 5/4/2022 Tlme-- 10:26:17 AM Annual budget Unexpended $0.00 ($3,759.62) $0.00 ($37,359.20) $0.00 ($6,964.34) $0.00 ($90-22) $0.00 ($48,173.38) L/ Yncns'—�, L-W1 '73.3 General Ledger System 01C OF WASHINGTON For User: 1NGR.1D FRANK Fund Expenditure report for: 267 - CDBG PS 711/21-6/30122 (Fund status: Active) Report year: 7l1/2021 thru 6/30/2022 Period ending: March 2022 Account Department: 009 INDIRECT ADMIN Program: 02 ADMIN. POOL -BASE 5312 SALARY ADM. ALLOCATION 5354 PIR TAX & BEN. ADM ALLOC_ 5999 NON PERSONNEL ADM. ALLOC. Total for sub program -----� Total for program 02 -----> Total for department 009 ----> Department: 010 PROGRAM Program: 25 PROGRAM SUPPORT 5311 SALARIES,WAGES EXPENSE 5351 FI CA,OIC EXP 5352 LAND 1,OIC SHARE 5353 STATE UCI(ES),OIC EXP 5355 PAID FAMILY MEDICAL LEAVE 5360 DISABILITY OIC EXPENSE 5361 MEDICAL INSURANCE,OIC EXP 5362 LIFE INSURANCE,OIC EXP 5363 PENSION,OIC EXP 5364 ACCRUED PTO EXP 5910 INSURANCE 5960 COMMUNICATION Total for sub program ----> Sub program: 54 ENERGY ASSISTANCE 5311 SALARIES,WAGES EXPENSE 5351 FICA,OIC EXP 5352 LAND I,OIC SHARE Mon - To Date Budget Expenditures Pct Budget Expenditures Page: Page 1 of 8 Date: 4/29/2022 Time: 11:17:39 AM Pct Annual budget Unexpended $0.00 $0.00 0, 00% $0.00 $2,073.83 0.00% $0.00 ($2,073.83) $0.00 $0.00 0.00% $0.00 $11116.44 0.00% $0.00 ($1,116.44) $0.00 $0.00 0.00% $0.00 $569.35 0.00% $0.00 ($569.35) $0.00 $0.00 0.00% $0.00 $3,759.62 0.00% $0.00 ($3,759.62) $0-00 $0.00 0.00% $0.00 $3,759.62 0.00% $0.00 $0.00 $O.OQ 0.00% $0.00 $3,759.62 0.00% $0.00 ($3,759.62) $0.00 $8, 035.61 0.00% $0.00 $24, 214.76 0.00% $0.00 ($24, 214.76) $0.00 $589.03 0.00% $0.00 $1, 764.82 0.00% $0.00 ($1, 764.82) $0.00 $49.33 0.00% $0.00 $141.72 0.00% $0.00 ($141.72) $0.00 $129.38 0.00% $0.00 $389.87 0.00% $0.00 ($389.87) $0.00 $51.00 0.00% $0.00 $153.02 0.00% $0.00 ($153.02) $0.00 $102.16 0.00% $0.00 $329.61 0.00% $0.00 ($329.61) $0.00 $1,565.33 0.00% $0.00 $51226.87 0.00% $0.00 ($5,226.87) $0.00 $40.53 0.00% $0.00 $130.77 0.00% $0.00 ($130.77) $0.00 $594.95 0.00% $0.00 $1,785.20 0.00% $0.00 ($1,785.20) $0.00 $1,000.58 0.00% $0.00 $3, 005.75 0.00% $0.00 ($3, 005.75) $0.00 $21.90 0.00% $0.00 $74.91 0.00% $0.00 ($74.91) $0.00 $90.22 0.00% $0.00 $90.22 0.00% $0.00 ($90.22) $0.00 $12,270.02 0.00% $0.00 $37,307.52 0.00% $0.00 ($37,307.52) $0.00 $2,608.96 0.00% $0.00 $4,576.31 0.00% $0.00 ($4,576.31) $0.00 $189.72 0.00% $0.00 $330.37 0_00% $0.00 ($330.37) $0.00 $17.71 0.00% $0.00 $30.09 0.00% $0.00 ($30.09) General Ledger System OIC OF WASHINGTON For User: INGRID FRANK Fund Expenditure report for: 267 - CDBG PS 7/1/21-6/30122 (Fund status: Active) Page: Page 2 of 8 Report year: 7/1/2021 thru 6/3012022 Period ending: March 2022 Date: 4129/2022 Time: 1117*41 AM monally-_ To Date— Account Budget Expenditures Pct Budget Expenditures Pct Annual budget 5353 STATE UCI(ES),OIC EXP $0.00 $42.02 ... ........ . 0.00% $0.00 $73.70 0-00% $0-00 5355 PAID FAMILY MEDICAL LEAVE $0-00 $17.04 0.00% $0.00 $29�27 0.00% $0.00 5360 DISABILITY OIC EXPENSE $0.00 $36.43 0.00% $0-00 $63.53 0,00% $0.00 5361 MEDICAL INSURANCE,01C EXP $0.00 $510.60 0.00% $0.00 $1,015.44 0.00% $0.00 5362 LIFE (NSURANCE,OIC EXP $0.00 $14.50 0.00% $0.00 $25.29 0.00% $0.00 5363 PENSION,01C EXP $0.00 $198.80 0.00% $0.00 $341.39 0.00% $0M 5364 ACCRUED PTO EXP $0.00 $253.40 0.00% $0.00 $456.11 0.00% $0.00 5910 INSURANCE $0.00 $13.11 0.00% $0.00 $22,,.84 0.00% $0.00 Total for sub program 54 $0.00 $31902�29 0-00% $0.00 $6,964.34 .... . ....... 0.00% $0.00 Total for program 25 $0.00 $16,172.31 0.00% $0.00 $44,271.86 0.00% $0.00 Program: 50 BLDG MAINT/FACILITY 5611 SPACE 5630 UTILITIES 5640 BUILD. REPAIRMAINT. 5912 LIABILITY INSURANCE Total for sub program Total for program 50 --> Total for department 010 --> Fund Totals Unexpended ($73,70) ($29.27) ($63.53) ($1,015.44) ($25.29) ($341-39) ($456.11) ($22.84) ($6,964�34) ($44,271.86) $0.00 $25.44 0,00% $0.00 $25.44 0.00% $0.00 ($25.44) $0.00 $45.71 0.00% $0.00 $45.71 0.00% $0.00 ($45-71) $0.00 $56.91 0.00% $0.00 $56.91 0.00% $0.00 ($56.91) $0.00 $13.84 0.00% $0.00 $13.84 0.00% $0.00 ($13.84) $0.00 $141.90 0,00% $0.00 $141.90 0.00% $0.00 $0-00 $141.90 0.00% $0.00 $141.90 0.00% $0-00 ($141.90) $0.00 $16,314.21 0.00% $0.00 $441413.76 0.00% $0.00 ($44,413.76) $0.00 $16,314.21 0.00% $0-00 $48,173-38 0-00% $0.00 ($48,173-38)