The URL can be used to link to this page

Home My WebLink AboutGrant Related - BOCC (004)y� �1 l� www.hagc.net July 1, 2021 ousi'ng At 1 • Grant County Board of Commissioners ATTN: Janice Flynn PO Box 37/35 C Street Ephrata, WA 98523 Dear Ms. Flynn: 1139 Larson Blvd. •Moses Lake, WA 98837-3308 Phone: (509) 762-5541 •Fax: (509) 762-2202 Toll Free: (800) 747-9202 •TTY: (800) 833-6388 Dated this 9 day of 20 Board of C o Linty C of n' ssiolaLr ' brant CoUnty. Washington A rove I�isatnroti�e Abstain Dist #I Dist f 1 mist Dist #.22 Dist # Dist #2 Dist 43 �' twist #3 ..... r .� � Dist Please consider this letter and attached documentation the Housing Authority's claim for draw #3 for June, 2021, for the ESG-CV Program. I certify that: The information on the A-19 and supporting documentation for the ESG-CV Program (ESG), contract # 20-46130-100, in the amount of $5,931,97 is a true and accurate report and that all reported expenditures are properly chargeable to the ESG grant. Sincerely, Christopher A. Sutherland Financial Director The Housing Authority of Grant County, Washington is an equal opportunity provider and employer and does not discriminate on the basis of race, color, national origin, religion, sex, physical or mental f N� disability, or familial status. The Housing Authority of Grant County' policies andpractices are designed to provide assurances thatpersons with disabilities will be given reasonable accommodations, EQUAL HOUSING upon request, so that they may fully access and utilize the housing programs and related services. OPPORTUNITY If you or anyone in your family is a person with disabilities, and you require a specific accommodation in order to fitly utilize our programs and services, please contact the Housing Authority. Grant County/GCHA Contract # 20-4613C-'100 (ESG) Submitted to GC by: HAGC Date: Request for Reimbursement No. #3 Grant County's Subrecipient 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? _X Allowable per Circular A-87 (June 2004 version), Attachment 13, items 1-43? For payroll transactions: _X Does the employee's time and effort documentation meet the requirements of Circular A-122? _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 (i.e., 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 samepurpose, 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 priorperiod? _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). I _X Not included as both a direct billing and as a component of indirect costs? _X 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? HAACC0UNT1NG\L0TUS\L0TUS\ESG GRANT\ESG Subrecipient Checktist,docx Page 1 Grantee Name: Lead Grantee List Sub Grantee Names Below T, ONTH M Report Month/Year: GRANT COUNTY HA OF GRANT COUNTY -- BUDGET t--tl �7. :�'l 4Y q g -ug P 3! Y mini ,, , ; A^ _? .1 - .4 7 st 7 20i000zoo ...... .... . . Tr !-w Street Outreach Outreach Essenfial Services $20,000.00 Hazard Pay (unique actitVity) Handwashing stabons/portable bathrboms (unique adivity) Volunteer incentives (unique attlivity) Training (unique activity) Subtotal Street Outreadi 7.- OWNf, 6- �4 Alit. r gi A vi� M erxn ............. ...... . .. ....... XIMM ��RLAMZ t :Alt: . . ... ..... N* t F9 t.; t CS"i gg, UNIX).: t-- 4 T 1'. 'If �W. 'M K -ON T� 1 r:!' 'i M� q —J,ts 'I ht f, tw." V. vs eA x f d-, TV� Vzia . 1..� A Nit. IN"MiN -,-�-11,14 k0KA, :fw; e A-.!�(pn MH gi . ... . ..... ......... A VIM# H 's- ajorA id gd:� Vit r: H V W n .......... ...... to t .. ... ....... T M P (a tom ...... ..... ...... y. e� . .... . ... .... Acqpitit ESQ C .... ...... V. d; q V t.e e .. . ....... -S cy", . . . .. ...... . .. ..... rvg;, ... . .. ... .... ....... .. . . .. .:RRH-;-Ri�ht� .. . . ... ........ d:! .. ...... . .. .. .. ......... ...... ...... . .. .. ..... .... ..... . Wa ss.p.� np- - RRH,!Dt btfl, fig h $ .. . . .. . .. .... ..... . .. ..... ..... ...... .... .. ... . ...... .... ... ... . ..... n asei anag6 a .. .. .. . ..... Hazar . .... ... . ....... Vity . ....... ....... d.p (06 Otie:�a.cfi- ... . .. .. ...... . . .... ... ... .. . ...... a --.:Incentives-. L ndlb*rd y V ......... .... . . per, nc6n ive t ....... .... . ........ ... . . . . ... . ........... . . .. Tf . .. .... .. .. .... . .. ... ...... .. . .. .. . .......... . .. ... .. .. . e . .. .. ..... . ... ... ..... . .. ........ . . . . ...... . .. ...... .. ... . ...... . .. .. ... .. . $20,'() taL: -bb! .: .. ..... . . R61 -.-As nt ........ . ... ...... .... ...... .. .. . -V&ftt16n- -eriRhA h Mi C L ion:. a. n:pg!pm.ejl'E:, fl. -Lah 'Cit. iqv y t. . .. ...... niqu�---aj .. ..... . . .... .. S, ei'l6sness. Tevent.lotv u a Tot al $0.00 $0.00 $0.00 $278,4G6.00 $0.00 $5,931.97 $0-00 Invoice Total: $0.00 $278,466.00 �iU.uu �,U.uu TOTAL OF BALANCE Apr -21 May -21 Jun -21 Jul -21 Aug -21 Sep -21 Oct -21 Nov -21 Dec -21 Jan -22 DRAWS REMAINING DRAW #1 DRAW #2 DRAW# 3 DRAW #3 DRAW #4 DRAW# 4 DRAW #5 DRAW #6 DRAW# 5 DRAW #7 1783.97 $1,783.97 $16,216.03 $0.00 $20,000.00 1109.8 1914 1637.221".. 4,b42 --i'56 $0.00 $1,637.12 $4,052.30 $5,931.97 $0.00 $20,000.00 $0.00 $45,000.00 $0.00 $80,000.00 $3,023.80 $37,442.20 $0.00 $5,000.00 $0.00 $20,000.00 $6,813.62 $13,186.38 $0.00 $5,000.00 $0.00 $5,000.00 $ 278,466.00 ##� $545,310.61 General Ledger Detail Report Summary Report for Period 06 Ending 6/30/2021 r,71) e u( A Run Date: 711/2021 1:38:11 PM Page: I G/L Date: 7/1/2021 User Logon: CAS HOUSING AUTHORITY OF GRANT COUNTY (GCH) PROJECT 01 - Account Number/Description Beg Balance Debit Credit Net Change End Balance 401000-9-01 MGMT SALARIES - ESG 0.00 75.12 0.00 75.12 75.12 408200-9-01 MGMT FICA:ESG Grant -01 0.00 5.67 0.00 5.67 5.67 408201-9-01 MGMT S .UTA:ESG Grant -01 . 000 0.85 0.00 0.85 0.85 408202-9-01 MGMT LUESG Grant -01 0.00 0.13 0.00 0.13 0.13 411000-9-01 ADMIN SALARIES-ESG Grant 0.00 118.34 0.00 118.34 118.34 417001-9-01 ADMIN FEES -GRANT CO-ESG Grc, 0.00 11500.00 0.00 11500.00 11500.00 4182009-01 ADMIN FICA-ESG Grant 0.00 8.78 0.00 8.78 8.78 418201-9-01 ADMIN SUTA-ESG Grant 0.00 1.33 0,00 1.33 1.33 418202-9-01 ADMIN L&I-ESG Grant 0.00 0.67 0.00 0.67 0.67 418204-9-01 ADMIN RETIREMENT-ESG Grant 0.00 23.03 0.00 23.03 23.03 418205-9-01 ADMIN MED/DENTNIS/L-ESG Gra 0.00 50-05 0.00 50.05 50.05 PROJECT 01 -Total: 0.00 11783.97 0.00 11783.97 11783.97 r,71) e u( A Run Date: 711/2021 1:38:11 PM Page: I G/L Date: 7/1/2021 User Logon: CAS General Ledger Detail Report Summary Report for Period 06 Ending 6/3012021 HOUSING AUTHORITY OF GRANT COUNTY (GCH) PROJECT 07 - Account Number/Description Beg Balance Debit Credit Net Change End Balance 471501-9-07 HAP PAYMENTS RENT RR:ESG C 459.80 11019.00 0.00 1,019.00 1,478.80 471506-9-07 RENT RR DEPOSITS-ESG Grant -0 650.00 895.00 0.00 895.00 11546.00 PROJECT 07 - Total: 1,109.80 11914.00 0.00 11914.00 31023.80 .0� Run Date: 7/112021 1:38:11113M Page: 2 GIL Date: 711/2021 User Logon: CAS General Ledger Detail Report Summary Report for Period 06 Ending 6/3012021 HOUSING AUTHORITY OF GRANT COUNTY (GCH) PROJECT 10 - Account Number/Description Beg Balance Debit Credit Net Change End Balance 471501-9-10 PREVENTION HAP PAYMENTS R1 21609.62 21234.00 0.00 21234.00 41843.62 471506-9-10 PREVENTION RENT DEPOSITS:E 11970.00 0.00 0.00 0.00 11970.00 PROJECT 10 - Total: 41579.62 21234.00 0.00 21234.09 L,�) 61813.62 Report Total: 51689.42 51931,97 0.00 519 31.97 11,621.39 .0-00 0,0.,0- 003 0 * 0.00:+ 0 e 00i,G 7F 19.783o97 1 9 14 0.0 + 2 2 3 4 OO. + Pzr� w Run Date: 7/112021 1:38:11 PM Page: 3 GIL Date: 7/1/2021 User Logon: CAS General Ledger Detail Report Detail Postings for Period 06 Ending 6/30/2021 HOUSING AUTHORITY OF GRANT COUNTY (GCH) Account Number/Description Perio Date Journal Comments Beg Balance Debit Credit Net Change End Balance 471501-9-07 HAP PAYMENTS RENT RR:ESG Gr 459.80 06 6/11/2021 AP -003894 750.00 0.00 1,209.80 06 6129/2021 AP -003904 269.00 0.00 11478.80 459.80 11019.00 0.00 11019.00 11478.80 471501-9-10 PREVENTION HAP PAYMENTS RE 21609.62 06 6/1/2021 AP -003887 614.00 0.00 31223.62 06 6/1/2021 AP -003887 725.00 0.00 31948.62 06 6/11/2021 AP -003894 895.00 0.00 41843.62 21609.62 21234.00 0.00 2,234.00 41843.62 471506-9-07 RENT RR DEPOSITS:ESG Grant -07 650.00 06 6/29/2021 AP -003904 895.00 0.00 1,545.00 650.00 895.00 0.00 895.00 11545.00 471506-9-10 PREVENTION RENT DEPOSITS:E,"-" 13970.00 0.00 0.00 1,970.00 11970.00 0.00 0.00 0.00 11970.00 Report Total: 51689.42 41148.00 0.00 41148.00 91837.42 Run Date: 711/2021 9:34:07AM Page:1 GIL Date: 7/11/2021 User Logon: SAB HMIS Data Quality HA Grant County Repoft [FY 2020] CoC Category Filter: Agency CoC Date Range: 06/01/2021 thru 06/30/2021 Q1. Report Validation Table Program Applicability: All Projects Total number of persons served 8 Number of adults (age 18 or over) Number of children (under age 18) Number of persons with unknown age 4 4 0 Number of leavers, 0 Number of adult leavers 0 Number of adult and head of household leavers 0 Number of stayers 8 Number of adult stayers 4 Number of veterans Number of chronically homeless persons 0 0 Number of youth under age 25 2 Number of parenting youth under age 25 with children Number of adult heads of household 2 2 Number of child and unknown -age heads of household 0 Heads of households and adult stayers, in the project 365 days or more 0 IThu Jul 1 09:29:13 AM 2021 92� M11,80 1/81 UMAN SERVICES HMIS Data Quality HA Grant County Report [FY 2020] CoC Category Filter: Agency CoC Date Range: 06/01/2021 thru 06/30/2021 Q2. Personally Identifiable Information (P11) Program Applicability: All Projects rnent Cent.:Doesn t. formation £ : Data Total /o :ofi_ E_r:ror Rate Iss u.eS p .... . • 5 Know/Refs ed - MIs n. ... ..,......,....n........_.a,......_...,..,,.,,,�..n»:.,ke�.,....,.,.:•..a«...,a�»,..�;........:o»...e�«...�.�rw.�i�.�-:..s........r>.>.a«w.na:<«.,..z.�...,.w.»....,..,�..m.,..x,- �.: Wxx - ° - �- - - • = � a..�...x,.F...»..,.,........,...c........w.,........,.,+w.w.:...�...,...,..�-.w...,F....�xu.....µ.,w.,na..,....,.a.a.... �R..-,F..�.+.w.«..w,....w.,«.,ww.........,,wo�,... Name (3.1) 3 0 0 3 30.00% Social Security Number (3.2) 4 0 1 .......�...0 4o 40.00 /o Date of Birth (3.3) 0 0 ( 3 3 1 30.00% Thu Jul 1 09:23:47 AM 2021 ! f I Powered By 0.00% 0.00% 0.00% 40.00% 2/81