Loading...
HomeMy WebLinkAboutGrant Related - BOCC (006)r, A J` v`rww.hagc.net July 1, 2021 Hous i*ng Auth * A&-- oriT-'.y of Grant County Grant County Board of Commissioners ATTN: Janice Flynn PQ Box 37/35 C Street Ephrata, WA 98823 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- `�� day of Board ofCounty Coi(Anissio6ers Grant County. Washington Dist # i Dist #I Dist #1 [dist #2 - Dist #? 11 ------- Dist #2 Dist #3 - Dist #� Dist #.3 ......_.....y _:.... 20 Please consider this letter and attached documentation the Housing Authority's claim for draw #10 for June, 2021, for the Eviction Rent Assistance Program. I certify that: The information on the A-19 and supporting documentation for the Eviction Rent Assistance Program (ERAP), contract # 21-4614C-108, in the amount of $12,480,71 is a true and accurate report and that all reported expenditures are properly chargeable to the ERAP 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 o race, color, national ori 'n, religion, sex, ® f gY 'gi physical ormental disability, orfamilial status. The Housing Authority of Grant County's policies and practices are designed to provide assurances that persons with disabilities will be given reasonable accommodations, EQUAL HOUSING upon request, so that they may filly 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 fully utilize our programs and services, please contact the Housing Authority. Grant County/GCHA Contract# 21-46140-108 (EfZAP) Submitted to GC by: HAGC CS2;;!;,L Ct Date: It l2 a I Request for Reimbursement No. #10 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 B, 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 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). _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? H:\ACCOUNTING\LOTUS\LOTUS\EVICTION PROTECTION GRANTTRAP Subrecipient Checklist.docx Page I Grantee Name: Lead Grantee List Sub Grantee Names Below Report Month/Year: JUNE 2021 1 1HOUSING AUTHORITY Or GRANT COUNTY Total - _ - Y Adm......_. x t. O r- „ a. b. J. .S r v r ,v ,. � •,t.l ., r.. .:. .'. .. .. n. _ ...vim - .. - .. .. .. .. .. _. .. .. ..a _ F C. , ♦ . - >'.t.•£.. v. Sc: /> , .. :, ♦ . ,. a ., , v i .. : . ,> . t „ _ ,..l. a ..)1.- 3F: s,.::-: h': n- �. ,:.Y .... ...... m.. .._._..._ ._ SS ...._.,- ... i }:..... .. v -. .. _..... ... -716 - 0e . Jr $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Total Invoice Total: $32,480.71 E'AP Voucher Detail Worksheet Grantee Name: Lead Grantee List Sub Grantee Names Below Total Report Month/Year: JUNE 2021 BUDGET GRANTCO-T COUNTY TOTAL OF BALANCE Sep -20 Oct -20 Nov -20 Dec -20 Jan 21 Feb -21 Mar -21 Apr -21 May21 Jun -21 DRAWS REMAINING 2- 00- -Admin' ,• MO.' $0.00 $0.00 $0.00 $0.00 $0.00 $7,500.00 $0.1)0 $0.00 $0.00 $5,000.00 $12,500.00 $0 00 .......... -,656 00 $3,640.49 $10,027A8 $5,117.67 $.12,000-35 $0.00 $0.00 $0.00 $3,066.77 $792.28 $312.73. $34,957.76 $72,099.24 R' - t.A ssistancp ep `00 Z. $21, -951.83 $92,394.03 $202,669.49 $576,647.65 $59,607.35 $48,611.45 $35,593.00 $103,225.66 $31,296.00 $7,168.00 $1,178,154.47 $242,367 -53 $1540,078.00 %00 ## # $0.00 ## $0.00 Total InvolceTo $1,540,078.00 $25,592.32 $102,411.51 $207,787.16 $588,648.02 $58,607.35 $56,111.45 $35,593.00 $106,292.43 $32,088.28 $12,480.71 $1,225,612.23 $314,465.77 General Ledger Detail Report Summary Report for Period 06 Ending 613012021 0 0. 0 011 0:° 0 0 G + 75a 12 + HOUSING AUTHORITY OF GRANT COUNTY (GCH) -- PROJECT 01- Oe 85 Account Number/Description 0,v 13 Beg Balance Debit Credit Net Change End Balance 401000-8-01 MGMT SALARIES - ERAP 153.91 75.12 0.00 75.12 229-03 408200-8-01 MGMT FICA - ERAP 11.43 5.67 0.00 5.67 17.10 408201-8-01 MGMT SUTA - ERAP 1.74 0.85 0.00 0.85 2.59 408202-8-01 MGMT L&I - ERAP 0.68 0.13 0.00 0.13 0.81 408204-8-01 MGMT RETIREMENT - ERAP 62.04 0.00 0.00 0.00 62.04 411000-8-01 ADMIN SALARIES - ERAP 21480.43 139.27 0.00 139.27 21619.70 417100-8-01 AUDIT Grant County- ERAP 7,500.00 51000.00 0.00 51000.0 12,500.00 418200-8-01 ADMIN FICA - ERAP 184.65 10.30 0,00 10.30 194.95 418201-8-01 ADMIN 'SUTA-ERAP 28.00 1.68 0.00 1.68 29-68 418202-8-01 ADMIN L&I - ERAP 15.29 0.67 0.00 0.67 15.96 418204-8-01 ADMIN RETIREMENT - ERAP 306.53 20.18 0.00 20.18 326.71 4182058-01 ADMIN MED/DENT/VIS/L - ERAP 603.64 43.54 0.00 43.54 647.18 471501-8-01 HAP PAYMENTS -RENT - ERAP 2777333.46 71168.00 0.00 7,168-00 2, 284,501.46 PROJECT 01 - Total: 288,681.80 12,465.41 0.00 12,465-41 30111-47.21 0 0. 0 011 0:° 0 0 G + 75a 12 + 5 a 6 7 + Oe 85 + 0,v 13 + 39 * 2 7 + 10 a 30 + is 1 068 + 0 'a 6 f? 2018 + 43054 + 151030 + 3 12 * 7 1 G + v\T t , o? 14 #a, 60 C3jl in - Run Date: 7/1/2021 1:08:13PM G/L Date: 711/2021 page: I User Logon: CAS General Ledger Detail Report Summary Report for Period 06 Ending 6130/2021 HOUSING AUTHORITY OF GRANT COUNTY (GCH) PROJECT 02 - Account Number/Description Beg Balance Debit Credit Net Change End Balance 419018-8-02 POSTAGE - ERAP 10.71 15.30 0.00 15.30 26.01 PROJECT 02 - Total: 10.71 15.30 0.00 15.30 26,01 Report Total: 2881692.51 12,480.71 0.00 12,480.71 301,173,22 0:03 0- vj-0 0 G + 312*71 + 79168oOO +; 5,; 00-0 o 0.0 +; 7 1 G Run Date: 711/2021 1:08:13PM Page: 2 GIL Date: 711/2021 User Logon: CAS General Ledger Detail Report Detail Postings for Period 06 Ending 6130/2021 Account Number/Description Perio -9 Date Journal 471501-8-01 278,633.46 06 6/11/2021 AP -003894 06 6/1112021 AP -003894 06 6/11/2021 AP -003894 06 6/22/2021 AP -003901 06 6/22/2021 AP -003901 06 6/22/2021 AP -003901 06 6/22/2021 AP -003901 06 6/22/2021 AP -003901 06 6/22/2021 AP -003901 06 6/22/2021 AP -003901 06 6/22/2021 AP -003901 06 6122/2021 AP -003901 06 6/29/2021 AP -003904 06 6/29/2021 AP -003904 06 6/29/2021 AP -003904 Run Date: 6/30/2021 9:07:40AM GIL Date: 6/30/2021 HOUSING AUTHORITY OF GRANT COUNTY (GCH) Comments Beg Balance Debit Credit Net Change End Balance HAP PAYMENTS -RENT - ERAP 2771333.46 650.00 0.00 277,983.46 650.00 0.00 278,633.46 650.00 0.00 279,283.46 15.00 0.00 279,298.46 165.00 0.00 279,463.46 165.00 0.00 279,628.46 625.00 0.00 280,253.46 625.00 0.00 280,878.46 625.00 0.00 281,503.46 402.00 0.00 281,905,46 367.00 0.00 282,272.46 567.00 0.00 282,839.46 554.00 0.00 283,393.46 554.00 0.00 283,947.46 554.00 0.00 284,501.46 277,333.46 71168.00 0.00 71168.00 284,501.46 Report Total 277,333.46 71168.00 0.00 7 - 168.00 284,501.46 Page: 1 User Logon: SAB 000* gtor. &C t- ..8­ Departrnenit of P �$ V ww Commerce, Instructions: Report Period: Enter corresponding week or month that matches the invoice reimbursement request. Match all of the information below to the information collected on the ERAP Household Information and Eligibility Form. Grantee: Grant County Report period: June 1- June 30, 2021 Household Paymept Information -o�t- 4' IN 4§'Oj�"b4ghbld, ro, Household ID N o. of months of rental Total Rent Payment Gender Race Ethnicity Staying with Friend Family? assistance Percent Area Median Income (AMI) 750121820 3 1950 Male White Hispanic/Lafinx No —80% EH09242020 3 1875 Female White Non-Hispanic/Non-Latinx' No Less than,301 771052521 3 1336 Female White Hispanic/LatInx No —50% 77205262021 3 .345 Female Multiple Raees Hispanic/Latinx No Less than 30% CDO62421 .3 1662. Male White Non-Hispanic/Non-Latinx -No Less than 30*/o „. rfti:t uy Head Gender Non Confarming� Fernafe z :. Trafis eiidei ... 1-.. I:e.note f6,*Q riii,e:;!6 ” Refuied pontkiwNr 3 2 0 0 0 609 40%1 09 0% cy. n._._ V� ,,C Ai lencan Indlan Of y, ` ) li to 1TiVAtlirn 0� OiKBf y w a L1 M s < fL aska'Natl`ve Asten . r:.,, 9lackor.'Afnan:Arrlerlcan-:� PaHRclslander. Whttr" Multl �ehaees. =:r Refused 0on'tkncw lr <' r. 0 1 O 0% 0% 0% B07L 2074 09 Noft Hispanic/Nott. X.�` ,;� _ Flfs anle latiia Refused lbnR know_ r , , 2 3 0 40% 6074 0% 1!es s.E,„'h n..> it 4F.. rt 'r i .a' tieRisti�'(56.' T7b1�}!i'`ix >•..i 0 5 0 ON I 10�e0% 09 MOP::.'ern Tx�7b4'.'if :�•c. ?1,d•.:' l s .:+3 .C: fs.P.?.r.. Cess.=tha��9 ._..:4011:'.. .:�'� Y �'.'. 'SO�i.., ...,: �, :: �.. • �( i.•cf-. ��. i s+:i.' :� . itliG^.'”. < , x •'° , - 3 0 1 0 0 1 607L 0 4 20% 0% 0% 20% 01-shngton ate W iSt Dep I artmentof Coi=erce Instructions: --- - -------- Report Period: Enter corresponding week or month that matches the invoice reimbursement request. Match all of the information below to the information collected on the ERAP Household Information and Eligibility Form. Grantee: Grant County Report period: June 1- June 30, 2021 Household Payment Information Head of Household information.' (select from dropdown), Household ID No. of months of rental Total Rent Payment Gender Race Ethnicity Staying with Friend Family.? assistance Percent Area Median Income (AMI) 750121820 3 1950 Male White Hispanic/Latinx No —80% EH09242020 3 1875 Female White Non-Hispanic/Non-Latinx No Less than 30% 771052521 3 1336 Female White Hispanic/Latinx No —50% 77205262021 3 345 Female Multiple Races Hispanic/Latinx No Less than 30% CD062421 3 1662 Male White Non-Hispanic/Non-Latinx No Less than 30% 'A' Voucher Detail Worksheet Grantee Name: Lead Grantee List Sub Grantee Names Below Total Report Month/Year: JUNE 2021 BUDGET GRANT CO. COUNTY TOTAL OF BALANCE Sep -20 Oct -20 Nov -20 Dec -20 Jan -21 Feb -21 Mar -21 Apr -21 May -21 Jun -21 DRAWS REMAINING Ad"min- $12,500.00 $0.00 $0.00 $0.00 $0.00 $0.00 $7,500.00 $0.00 $0.00 $0.00 $5,000.00 $12,500.00 $0.00 Operations $107,056.00 $107,056.00 $3,640.49 $10,027.48 $5,117.67 $12,000.36 $0.00 $0.00 $0.00 $3,066.77 $792.28 $312.71 $34,957.76 $72,098.24 Rent Assistance.$1,420,522.00 $1,420,522.00 $21,951.83 $92,384.03 $202,669.49 $576,647.66 $58,607.35 $48,611.45 $35,593.00 $103,225.66 $31,296.00 $7,168.00 $1,178,154.47 $242,367.53 M _.. $1,540,078.00 $0.00 ## # $0.00 ## $0.00 Total Invoice Ta $1,540,078.00 $25,592.32 $102,411.51 $207,787.16 $588,648.02 $58,607.35 $56,111.45 $35,593.00 $106,292.43 $32,088.28 $12,480.71 $1,225,612.23 $314,465.77