Loading...
HomeMy WebLinkAboutGrant Related - BOCC (002)vm%hage.net May 10, 2023 Housing Authority of Grant County Grant County Board of Commissioners ATTIC: Janice Flynn Ptd Sox 37/35 C Street Ephrata, SVA 98323 Dear Ms. Flynn: 1139 Larson Pled. o' ores Lake, WA 98837-3308 Phone: (509) 762-5541 o Fax: (509) 762-2202 Toll Free: (800) 747-9202,e TTY (800) 833-6358 Please consider this letter and attached documentation the Housing Authority's claim for draw #22 for April, 2023, for the Consolidated Homeless Grant. I certify that: The information on the A-19 and supporting documentation for the Consolidated Homeless Grant (CHC), contract # 22-46108-10, In the amount of $36,O90-71 is a true and accurate report and that all reported expenditures are prraperly chargeable to the CHG . grant, Sincerely, ctjtpz C� Christopher A. Sutherland Financial Director MAY 1 6 2023 CONSENT i-- •-. _ • " »,� � ,r^ � s.� � e^c"^'� W VE ?.,4 . f � y{ H 1' t:-. s,:�s..•.w...:..u�r.<-rc- >.•.n -_,:t cae*:.m..vaawaec - ...i r..ann_....n , eia�,vx•ur:.tie.er.,.�s The HouslgAuthotlty of Grant County, Washington is an equal opporNsilty p*v1dar and ernploper and does not discriminate an the basis of race, color, national arighs, iviigion, sex, physical or mental disabditA or famtilalstatus, ?Ire Ho using Authority of Grant County'spollefes and practlees are designed toprovide assurances thatpersons waft disabtlides will begiven raasonabk acccmrtwdations, QUAL HOUSINGupon request, so that they may felly access and utttize the housingprograms and related services, OPPORTUNITY If you of anyone !a your family is a person with disabilities, and you require a spacylc accommodation In order to fully unlike ourprograms and servicces, plaase contact the Housing AuUturity. Grant CountylGCHA Contract #22-461M,,CHG, Submitted to GC by: HAGC CU 5 Date:- I ,a a /& Z,3r 4L Request for Reimbursement No. #22 Grant County's Subrecipieni 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? Authorized (or not prohibited) under state or local laws or regulations? M �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 (Le., is the federal government being charged the same ambunt 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). aw"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), ft.WX Supported by appropriate documentation? (e.g., approved purchase orders, receiving reports, vendor invoices, canceled checks, and time and attendahce records,) Doo umentation may be in an eleoftnic form. W�x Correctly charged to the proper account code and grant period? H:\ACCOUNTING%LOTUS\LOTUS\donsolidated HG\CIIG 2021-2023\CHG Subredpient Checklist.doex Page 1 Grantee Name: Grant County Lead Grantee List Sub Grantee Names Below Total Report Month/Year: APRIL 2023 HAGC CHG Voucher Detail Worksheet Grantee Name: Grant County Lead Grantee List Sub Grantee Names Below Report Month/Year: APRIL 2023 HAGC Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 Jan-23 Feb-23 Mar-23 Apr-23 TOTAL OF BUDGET DRAW #13 DRAW #14 DRAW #15 DRAW #16 DRAW #17 DRAW #18 DRAW #19 DRAW #20 DRAW #21 DRAW #22 DRAWS $1,058.85 $3,010.82 $1,404.83 $1,204.87 $1,486.09 $1,088.94 $669.85 $1,476.09 $1,440.88 $593.43 $32,525.44 $1,308,455.00 BALANCE REMAINING $37,424.56 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $150.00 $0.00 $150.00 $0.00 $450.00 $9,550.00 $10,412.10 $13,688.81 $12,576.04 $6,255.00 $9,616.88 $17,460.56 $19,179.56 $13,764.40 $15,159.06 $11,949.00 $273,811.03 $37,727.97 $6,430.84 $5,376.57 $8,516.45 $5,072.59 $7,731.01 $8,111.46 $4,322.09 $6,650.54 $11,501.41 $5,372.26 $156,841.52 $38,218.48 $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 $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 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1,727.49 $23,272.51 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $200,431.76 $61,521.24 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $48,764.03 $25,235.97 $143.11 $75.93 $129.09 $127.77 $88.49 $118.32 $39.27 $0.00 $724.27 $361.79 $1,808.04 $23,191.96 $16,813.24 $18,816.31 $16,431.00 $17,480.25 $18,238.19 $12,396.77 $15,731.13 $13,492.72 $12,413.56 $14,945.47 $156,758.64 $105,194.36 $2,319.25 $2,184.97 $3,201.52 $1,498.52 $2,528.84 $2,943.98 $2,038.42 $2,079.57 $4,654.03 $2,868.76 $26,317.86 $47,682.14 Invoice Tota $37,177.39 $43,153.41 $42,258.93 $31,639.00 $39,689.50 $42,120.03 $42,130.32 $37,463.32 $46,043.21 $36,090.71 $899,435.81 $409,019.19 General Ledger Dotall Report Summary Report for Period 04 Ending 413012023 HOUSING AUTHOMTY OF GRANT COUNTY (OCH} PROJECT 01- Acco.unt, Number/Description Bog Balance Debit Credit NOt Change End Balance 408204-7-01 IVIGNIT RETIREMENT.,CHG 26.49 0.00 0.00 0.00 26.49 408206-7-01 MGMT IVIED/13ENTNIS/LWHIG 46.36 0.00 0.00 0.00 46.36 411000.7-01 ADMIN SALARIES:CHO 11940.23 219.06 0.00 219.05 21209.28 418200-7-01 ADMIN FICA-CHG 147.50 16.36 0.00 16.35 163.85 418201-7-01 ADMIN SLITA-CHG 29.84 3.29 0.00 3.29 33,13 418202-7-01 ADMIN L&I-CHG 10.12 0.99 0.00 0.99 11.11 418204-7-01 ADMIN RETIREMENT:CHG 313.91 126.31 0.00 128.31 440.22 418206-7-01 ADMIN MED/DENTNl8/L:CHG 605.26 220.24 0.00 220,24 726.60 419018-7-01 POSTAGE:CHG 63.01 7.20 0.00 7.20 60.21 441000-7-01 MAI NTE NANCE SALARI ES.- CH G 412.33 0.00 0.00 0.00 412.33 443300-7-01 MAI NT FICA:CHG 30.98 0100 0.00 0.00 30.98 443301-7-01 MAINT SUTA:CHG 6.19 0.00 0.00 0.00 6.19 443302-7-01 MAI NT L&I.-,,CHG 13.47 0100 0.00 0.00 13.47 443305-7-01 MAI NT MED/DENTNI8/L:CHG 1.13 0.00 0.00 0,.OQ 1.13 PROJECT 01 - Total. 31588.82 W- I - 593.43 0.00 693.43 41180.26 •SoA Run Date: 6/8/2023 10:16:33AM Page: 1 G/L Date: 4130/2023 User Logon: CA$ General Ledger Detail Report Summary Report for Period 04 Ending 4/3012023 HOUSING AUTHORITY OF GRANT COUNTY (OCH) PROJECT 02 - Account Numbor/Doscriptlon Beg Balance Dabit Credit Not Change End Belanoo 411000-7-02 ADMIN SALARIES FACILITY SUIPF 14,512,70 21343.30 0.00 21343.30 16,866.00 418200.7-02 ADMIN FICA FACILITY SUPP & FV 11066.06 173.14 0.00 173.14 11238.20 418201-7-02 ADMIN SUTA FACILITY SUPP & R 217.71 36.15 0.00 35.15 262.66 418202-7-02 ADMIN L&I FACILITY SUPP & RA 1 83.70 12.46 0.00 12.46 96.16 418204-7-02 ADMIN RETIREMENT FACILITY 81 11668,82 723.86 0.00 723.86 21382.68 418205.7-02 ADMIN MED/DENT/VIS/L FACILITI 41869.27 21084.35 0.00 21084.35 61963,62 4430007-02 CONTROT SVC MAINT FACILITY f 66.78 0.00 0.00 0 66.78 PROJECT 02 - Total: 22,474.04 61372.26 0.00 Q,5372_a1 2 . 71846.30 Run Date: 618/2023 10o,16*933AM Pago: 2 G/L gate; 4/30/2023 User Logon: CAS General Lodger Detail Report Summary Roport, for Period 04 Ending 4130/2023 HOUSING AUTHORITY OF GRANT COUNTY (GCHj PROJECT 04 - Account Number/Description Reg Balance Debit Credit Not Chmige End Balance 471501-7-04 HAP PAYMENTS RENTS-CHG 28,403.02 61629.00 0.00 51529,00 33,932.02 471602-7-04 HAP P"MNT PROJECT LEASE C 11,160.00 31720.00 0.00 31720.00 14,880.00 471606-7-04 RENT 10EPOSITS-CHG 71880,00 21700.00 0.00 2,700.00 101580.00 471508-7-04 MOTEL VOUCHERS -CHG 660.00 0.00 0.00 0.00 660.00 PROJECT 04 - Tota): 48,103.02 11,949.00 0.00 11,949.00 60,052.02 O;?U. >4-.eN Mk., 4- Run Date: 61812023 10A6:33AM Page-, 3 G/L Date: 4130/2023 User Logon: CAS General Ledger Detail Report Summary Report for Purled 04 Ending 4/30/2023 HOUSING AUTHORITY OF GRANT COUNTY {GCI -I) PROJECT 06 - Account Number/Doseriotion Beg Balance DOW Credit Net Change End Balance 471504-7-05 HAP PAYMNTS UTILITIES CHG-0.1 300.00 0.00 0.00 0.00 300.00 PROJECT 06 - Total: 300.00 0.00 0.00 0.00 300-00 Run Date., 618/2023 10:16:33AM Pageo, 4 G/L Date: 413012023 User Logon: CM General Ledger Detail Report Summary Report for Period 04 Ending 413012023 HOUSING AUTHORITY OF GRANT COUNTY {GCH} PROJECT 08 - Account Number/Description Beg Balance Debit Credit Net Change End Balance 411000-7-08 ADMIN SALARIES -HEN -{SPS -CHC 61800,86 11438.78 0.00 11438.78 71239.63 418200-7-08 ADMIN FICA-HEN-OPS-CHG 428.67 106.20 0.00 106.20 634.87 418201-7-08 ADMIN SUTA Hr-N-OPS-CHG 87.01 21.68 0.00 21.58 108.69 418202-7-08 ADMIN L&I HEN-OPS-CHG 32.98 7.85 0.00 7.85 40,83 418204-7-08 ADMIN RETIREMENT HEN -OPS -C 625.61 325.83 0.00 325.83 951.44 418205-7-08 ADMIN MED/DENTNIS/L HEN -OR, 11796.90 968.62 0.00 988:5 21785.42 PROJECT 08 - Total: 81772.02 2,868.76 0.00- 21868.76 11,640.78 nppot '117 Run Date: 51812023 1016:33AM page: 6 OIL Date: 413012023 User Logon: CAS General Ledger Detail Report 0°00 rj Summary Report for Period 04 Ending 4/3012023 4a68 + 000 0 a 94 + 00 P, 8 + 593*43 HOUSING AUTHORITY OF GRANT COUNTY (GCH) PROJECT 09 - 213o76 I- I 1 9 lie 9 0 + 00629868t,76 + 3 6 1 7 9 Account Number/Description I#, g9ti 5 4"7 4- -006 Beg Balance Debit Credit Not Change End Balance 411000-7-09 ADMIN SALRIES HEN-CHG 661.44 62.59 0.00 62.59 724.03 418200-7-09 ADMIN FICA HEN- CIG 48.74 4.68 0.00 4.68 53-42 418201-7-09 ADMIN SUTA HEN-CHG9,92 0,94 0.00 0.94 '10,80 418202-7-09 ADMIN L&I HEN-CHG 4.17 0.26 0.00 0,28 4.45 418204-7-09 ADMIN RETIREMENT HEN-CHG 13.36 79.64 0.00 79.64 92.90 418205-7-09 ADMIN MED/DENTNIS/L HEN-CHi 26,91 213.76 0.00 218,10 239.67 471501-7-09 HAP PAYMENTS RENT HEN-CHG 40,027.27 14,847.60 0.00 14*1847,60 54,874,77 471604-7-09 HAP PAYMNTS UTILITIE -CHG 510,14 97,97 0.00 97.97 608.11 471606-7-09 RENT DEPOSITS HEN-CHG 1,100.00 0100 0.00 0.00 11100100 PROJECT 09 - Total: 42,400-95 18,307.26 0600 15,307.26 67,708.21 Report Total: 125,636.86 36,090.71 0.00 36,090.71 161,727.56 L 000 0°00 rj + 4a68 + 000 0 a 94 + 00 P, 8 + 593*43 79,o'54 + Fj 372,a26 + 213o76 I- I 1 9 lie 9 0 + 00629868t,76 + 3 6 1 7 9 I#, g9ti 5 4"7 4- -006 00 36p 09 0 7 1 0°00 000 0 0o 0 8 h 7 0 + 97o97 + 002 Run Date: 51812023 10:16m.-33AM OIL Date: 413012023 Page: 6 User Logon: CAS CHG - APRIL 2023 471501-7-04 HAP PAYMENTS RENT - CHC CA341136171 Rental Assistance: Rental Assistance 04/0112023 $480.00 5OB3FC596 Rental Assistance: Rental Assistance 04101/2023 $400,00 915295AA4 Rental Assistance: Rental Assistance 04/01/2023 $984,00 OD6E95B[)C Rental Assistance: Rental Assistance 04101/2023 $825.00 B44628878 Rental Assistance: Rental Assistance 04/01/2023. $1,600.00 840OF76EA Rental Assistance: Rental Assistance 04/01/2023 $850.00 943624OF4 Rental Assistance: Rental Assistance 0410112023 $390.00 $50529.00 471501-7-09 HAP PAYMENTS RENT - HEN 1BO1390DAF HEN Rent Assistance: HEN Rent Assistance 04103/2023 $641.00 410E07E70 HEN Rent Assistance: HEN Rent Assistance . 04/03/2023 $1,262.00 7BAl32A4B3 HEN Rent Assistance: HEN Rent Assistance 041011202� $641.00 A685GABF1 HEN Rent Assistance: HEN Rent Assistance 04/0312023 $472.50 A270DO130 HEN Rent Assistance: HEN Rent Assistance 0410312023 $300.00 3C1347377 HEN Rent Assistance: HEN Rent Assistance 04/0312023 $450.00 30349CF38 HEN Rent Assistance: HEN Rent Assistance 04103/2023 $800.00 8529765CA HEN Rent Assistance: HEN Rent Assistance 04/03/2023 $745.00 990FE201"4 HEN Rent Assistance: HEN Rent Assistance 04/03/2023 $350.00 40BD63486 HEN Rent Assistance: HEN Rent Assistance 04/03/2023 $641.00 542299D6B HEN Rent Assistance: HEN Rent Assistance 04/03/2023 $675.00 7CE9CC39A HEN Rent Assistance: HEN Rent Assistance 04101/2023 $650.00 7CE9CC39A HEN Rent Assistance: HEN Rent Assistance 04101/2023 $650.00 7CE9CC39A HEN Rent Assistance,, HEN Rent Assistance 04101/2023 $650.00 7CE9CC39A HEN Rent Assistance: HEN Rent Assistance 04/01/2023 $650.00 7CE9=39A HEN Rent Assistanoe: HEN Rent Assistance 04/0312023 $650.00 37A14A37F HEN Rent Assistance: HEN Rent Assistance 04/03/2023 $700.00 6EA898E46 HEN Rent Assistance: HEN Rent Assistance 04/03/2023 $300.00 D3731DO14 HEN Rent Assistance: HEN Rent Assistance 04/0312023 $650.00 FOA41313175 HEN Rent Assistance: HEN Rent Assistance 04/03/2023 $515,00 0089620OF HEN Rent Assistance,. HEN Rent Assistance 04/0312023 $62.5.00 453ES0019 HEN Rent Assistance: HEN Rent Assistance 04/0312023 $530.00 4666E3733 HEN Rent Assistance: HEN Rent Assistance 04/0312023 $600.00 427C285BF HEN Rent Assistance: HEN Rent Assistance 04/03/2023 $700.00 $14,847.50 471601-7-09 HAP P"MENTS UTILITIES - HEN 41 CE07E70 HEN Utility Payment: HEN Utility Payment 0412412023 $97,97 $97.97 471506-7-04 RENT DEPOSITS - CHG OD6E96BDC Security Deposit: Security Deposit 6083FC596 Security Deposit: Security beposit 1344628878 Security Deposit,,, Security Deposit 0411012023 $800.00 04/0112023 $400.00 04/01/2023 $1,500.00 $2,700.00 General Ledger Detail Report Detail Postings for Period 04 Ending 4130/2023 HOUSING AUTHORITY OF GRANT COUNTY (GCH) Account Numbor/Descriptlon Period Date Journal Comments Beg Balance Debit Credit Net Change End Balance 471601-7-04 HAP PAYMENTS RENTS-CHG 28,403.02 04 413/2023 AP -404312 480.00 0000 281883.02 04 4/312023 AP -004312 984.00 0.00 29,867.02 04 413/2023 AP -004312 390.00 0.00 30,257.02 04 0/2023 AIP-0043112 850.00 0.00 31,107.02 04 4/12/2023 AP -004320 826.00 0100 31,932.02 04 4/12/2023 AP -004820 400.00 0.00 32,332.02 04 4/2512023 AP -004326 19600.00 0.00 33,932,02 28,40-02 5,529.00 0.00 5,629.00 33,932.02 471501-7-09 HAP PAYMENTS RENT HIEN-OFIG 40,027.27 04 4/3/2023 AP -004312 300.0*0 0.00 40,327.27 04 4/3/2023 AP -004312 300,00 0.00 40,627..27 04 4/3/2023 AP -004312 625.00 0.00 41,252.27 04 4/3/2023 AP -00012 516.00 0.00 41,767.27 04 402023 AP -004312 11262.00 0.00 43,029.27 04 4/3/2028 AP -004312 641.00 0.00 43,670.27 04 4/3/2023 AP -004312 641.00 0.00 44o311.27 04 4/3/2023 AP -004312 472,60 0.00 44,783.77 04 4/3/2023 AP -004312 746.00 0.00 45l528.77 04 413/2023 AP�004312 676.00 0.00 46,203.77 04 41312023 AP -004312 800.00 0.00 47,003.77 04 4/312023 AP -004312 700.00 0.00 47,703.77 04 41312023 AP -004312 450.00 0,00 48,153.77 04 41312023 AP -004312 530.00 0.00 48,683.77 04 4/312023 AP -004312 650-,00 0.00 49,333.77 04 4/3/2023 AP -004312 360.00 0.00 49,683.77 04 4/3/2023 AP -004312 600.00 0.00 60,283.77 04 413/2023 AP -00431.2 MOM 0.00 60*983.77 04 413/2023 AP -004312 650.00 0.00 619633.77 04 413/2023 AP -004312 650.00 0.00 62,283.77 04 413/2023 AP -004312 650,00 0.00 52,933.77 04 413/2023 AP -004312 650.00 0.00 63,683.77 04 413/2023 AP -004312 650.00 0.00 64,233.77 04 4112/2023 AP -004320 641.00 0.00 64,874.77 40,027.27 14,847.60 0.00 14,847.50 64)874.77 471502-7-04 HAP PAYMNT PROJECT LEASE CC 11,160.00 04 41312023 AP -004312 000100235 AN: 1004040323 610.00 0.00 11,770.00 04 4/3/2023 AP -004312 000100235 AN: 1006040323 610.00 0.00 12,380.00 04 41312023 AP -004312 000100235 AN: 1008040323 640,00 0.00 13,020.00 04 41312023 AP -004312 000100235 AN: 1010040323 640.00 0.00 13,660.00 04 413/2023 AP -004312 000100235 AN: 1102040323 610.00 0100 14,270,©0 04 4/312023 AP -004312 000100235 AN: 1104040323 610.00 0.00 14,880.00 11,1160.00 V20,00 0,00 3,720.00 14,880,00 471504-7-06 HAP PAYMNTS UTILITIES CHG-06 300.00 0.00 0.00 300.00 300.00 0.00 10.00 0.00 300.307 471504-7-09 HAP PAYMNTS UTILITIE. -CHG 610.14 04 4/26/2023 AP -004326 97.97 0.00 608.11 610.14 97,97 0.00 97.97 608.11 Account Number/Desarlpt1w Period tate Journal Comments Beg ftlanco Debit Cfedlt Not Change End Balance 47'1506-7-0N4] RENT DEPOSITS-CHG 71880.00 04 4/12023 AP -004320 800.00 0.00 81680.00 04 4/12t2O23 AP -004320 04 4/26/2023 AP -004326 471506-7-09 471508-7-04 Run Date: 511/2023 12:49:04PM G/L Date: 61112023 400.00 0.00 91080.00 11500100 0,00 10,680.00 7,880.00 20700.00 0.00 2p700.00- 10;680.00 RENT DEPOSITS HEN-CHG 1,100.00 0.00 0.00 1$100.00 11100.00 0,00 0.00 0.00 1,100.00, MOTEL VOUCHERS -CHG 660,00 0.00 0.00 660.00 660.00 0100 6.00 0.00 660.00 Report Total: 90,040.43 26,894,47 0.00 20,894,47 116,934.90 • Page: 2 User Logon: SAB