Loading...
HomeMy WebLinkAboutGrant Related - BOCC (003)w"-,A,.hagc.net October 7, 2020 Housing Authority of Grant County Grant County Board of Commissioners ATTN: Brittany Rang PO Box 37/35 C Street Ephrata, WA 98823 Dear Ms. Rang: 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 Please consider this letter and attached documentation the Housing Authority's claim for draw #15 for September, 2020, for the Consolidated Homeless Grant. I certify that: The information on the A-19 and supporting documentation for the Consolidated Homeless Grant (CHG), contract # 20-46108-10, in the amount of $27,966.32 is a true and accurate report and that all reported expenditures are properly chargeable to the CHG grant. Sincerely, Christopher A. Sutherland Financial Director 12tVie Housing Authority of Grant County, Washington is an equal opportunity provider and empluye, and does not discriminate on the basis of race, color, national origin, religion, sex physiral or mental EQUAL HOUSING disability, or familial status. The Housing Authority of Granr County's popcia and practices are designed to provide assuranca that persons with di abilities will be given reasonable accommodations, OPPORTUNITY upon requesi, so that they may dify access and utilize the houdng programs and related services, Grantee Name: Grant County ILead Grantee List Sub Grantee Names Below Report Month/Year: SEPTEMBER 2020 HAGC otal Admin $416.81 $416.81 CHG-Other Rent/Fac Supp Lease & Housing Costs $0.00 $0.00 CHG-Rent & Fac support/Lease Costs $8,908.76 $8,908.76 CHG-Operations $6,275.84 _ $6,275.84 PSH/CHF Fcility Support/Lease Costs $0.00 $0.00 PSH/CHF Other Rent/Fac Supp/Lease & Hous $0.00 $0.00 PSH/CHF Operations $0.00 $0.00 HEN - Admin 2020 $0.00 $0.00 HEN- Rent and Hou5ing'Costs 2020 :$0.00 $0.00 HEN Operations 2020 $0.00 $0.00 �9Q CNS Adrtrn022`$3t;$ �� $368.66 'eiVtCnY�� �a irk P ~_� $9,885.00 $2,111.25 County review conducted by: BOCC APPROVAL BY: ne Stricklef, Grant Administration Specialist Cindy Carter�JChair Invoice Total: $27,966.32 Date: l0 - 0 �- Zd Date: [V -13, Zl CHG'Base Funding PSH/CHF RENT/FAC SUPP/ LEASE &HOUSING COSTS HEN SFY 2020 - 0 Grantee Name: Grant County I Lead Grantee List Sub Grantee Names Below Total Report Month/Year: SEPTEMBER 2020 HAGC Admin $416.81 $416.81 CHG-Other Rent/Fac Supp Lease & Housing Costs $0.00 $0.00 CHG-Rent & Fac support/Lease Costs $8,908.76 $8,908.76 CHG-Operations $6;275.84 $6,275.84 PSH/CHF Fcility Support/Lease Costs $0.00 $0.00 PSH/CHF Other Rent/Fac Supp/lease & Hous $0.00 $0.00 PSH/CHF Operations $0.00 $0.00 HEN- Admin 2020 $0.Q0 $0.00 HEN- Rent and Housing Costs2020 $0.00 $0.00 HEN- Operations 2020 $0.00 $0.00 +iEIV ,Admin 2021 ;�., .: _ 'r . `.r .,. '' a M ::;$368:66 w _ %ie u&�Ot#ie 001" Ca5t5 , . c r a 0,3: , �" }'�Flr M .Y;� :4�.t. �.,4 ti �-> ,+� s .�. W ONO C✓s..: .. ... _.. $368.66 $9,885.00 $2,111.25 Invoice Total: $27,966.32 8a ass�9181 8 a 's 's a 91 3 � a t.,g�gp R Y c w r 3 < r. N O 8a ass�9181 8 a 's 's a 91 Grant CountylGCHA HAMraet #20�'1081'CentNo Submitted to GC by: GC RequDateRequestfor#15 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? 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). 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:\A000UriTNG\LOTUS\LOTUS\Consolidated HG\CHG 2019-2021\CHG Subrecipient Chmiclist.docx Page 1 General Ledger Detail Report Summary Report for Period 09 Ending 9/30/2020 PROJECT 01 - Account Number/Description 408204-7-01 408205-7-01 411000-7-01 415000-7-01 418200-7-01 418201-7-01 418202-7-01 418205-7-01 419012-7.01 419018-7-01 441000-7-01 443300-7-01 443301-7-01 443302-7-01 443304-7-01 443305-7-01 MGMT RETIREMENT:CHG MGMT MED/DENTNISILI:CHG ADMIN SALARIES:CHG TRAVEL:CHG ADMIN FICA-CHG ADMIN SUTA-CHG ADMIN L&I-CHG ADMIN MEDIDENTNIS/L:CHG MEMBERSHIP DUES & FE-CHG POSTAGE:CHG MAINTENANCE SALARIES:CHG MAINT FICA:CHG MAINT SUTA:CHG MAINT L&I:CHG MAINT RETIREMENT:CHG MAINT MED/DENTNISIL:CHG PROJECT 01 -Total: Run Date: 1017/2020 11:56:32AM G/L Date: 9/30/2020 HOUSING AUTHORITY OF GRANT COUNTY (GCH) Beg Balance Debit Credit Net Change End Balance 54.10 0.00 0.00 0.00 54.10 87.82 0.00 0.00 0.00 87.82 534.17 0.00 0.00 0.00 534.17 0.00 17.83 0.00 17.83 17.83 39.72 0.00 0.00 0.00 39,72 6.57 0.00 0.00 0.00 6.57 5.16 0.00 0.00 0.00 5.16 668.33 0.00 0.00 0.00 668.33 450.00 0.00 0.00 0.00 450.00 4.50 0.00 0.00 0.00 4.50 1,459.69 312.72 0.00 312.72 1,772.41 110.12 23.80 0.00 23.80 133.92 17.94 3.86 0.00 3.86 21.80 148.47 30.93 0.00 30.93 179.40 294.34 27.67 0.00 27.67 322.01 1.30 0.00 0.00 0.00 1.30 3,882.23 416.81 0.00 416.81 4,299.04 0 Page: 1 User Logon: CAS General Ledger Detail Report Summary Report for Period 09 Ending 9130/2020 V HOUSING AUTHORITY OF GRANT COUNTY (GCH) PROJECT 02 - Account Number/Description Beg Balance Debit Credit Net Change End Balance 411000-7-02 ADMIN SALARIES FACILITY SUPF 29.342.10 3;756.86 0.00 3,756.86 33,098.96 418200-7-02 ADMIN FICA FACILITY SUPP & W 2,158.74 275.76 0.00 275.76 2,434.50 418201-7-02 ADMIN SUTA FACILITY SUPP & R 358.71 46.22 0.00 46.22 404.93 418202-7-02 ADMIN L&I FACILITY SUPP & RA 1 261.94 35.92 0.00 35.92 297.86 418204-7-02 ADMIN RETIREMENT FACILITY S1 4.721.64 585.16 0.00 585.16 5,306.80 418205-7-02 ADMIN MED/DENTNIS/LFACILIT` 11,563.94 1,406.49 0.00 1,406.49 12,970.43 419013-7-02 TELEPHONE -FACILITY SUPP FOI 3.32 0.00 0.00 0.00 3.32 443000-7-02 CONTRCT SVC MAINT FACILITY ! 363.02 169.43 0.00 169.43 532.45 PROJECT 02 - Total: 48,773.41 6;275.84 0.00 6,275.84 55,049.25 Run Date: 10/7/2020 11:56:32AM Page: 2 G/L Date: 9/3012020 User Logon: CAS General Ledger Detail Report Summary Report for Period 09 Ending 9/3012020 PROJECT 04 - Account Number/Description 471501-7-04 HAP PAYMENTS RENTS-CHG 471502-7-04 HAP PAYMNT PROJECT LEASE C 471506-7-04 RENT DEPOSITS-CHG 471508-7-04 MOTEL VOUCHERS -CHG 3,031.76 PROJECT 04 - Total: 62,982.17 8,908.76 Run Date: 10/712020 11:56:32AM GIL Date: 9/3012020 0.00 8,908.76 71,890.93 0-3 Page: 3 User Logon: CAS HOUSING AUTHORITY OF GRANT COUNTY (GCH) Beg Balance Debit Credit Net Change End Balance 25,073.52 3,031.76 0.00 3,031.76 28,105.28 28,416.00 3,552.00 0.00 3,552.00 31,968.00 8,348.00 2,325.00 0.00 2,325.00 10,673.00 1,144,65 0.00 0.00 0.00 1,144.65 62,982.17 8,908.76 Run Date: 10/712020 11:56:32AM GIL Date: 9/3012020 0.00 8,908.76 71,890.93 0-3 Page: 3 User Logon: CAS General Ledger Detail Report Summary Report for Period 09 Ending 9/30/2020 HOUSING AUTHORITY OF GRANT COUNTY (GCH) PROJECT08- Account Number/Description Beg Balance Debit Credit Net Change End Balance 411000-7-08 ADMIN SALARIES-HEN-OPS-CHG 17,720.73 1,791.36 418200-7-08 ADMIN FICA-HEN-OPS-CHG 911.08 97.75 418201-7-08 ADMIN SUTA HEN-OPS-CHG 151.63 16.37 418202-7-08 ADMIN L&I HEN-OPS-CHG 112.83 12.58 418204-7-08 ADMIN RETIREMENT HEN -OPS -C 1,998.99 193.19 418205-7-08 ADMIN MED/DENTNIS/L HEN -OP: 2.43 0.00 PROJECT 08 - Total: 20,897.69 2,111.25 o Ktv 00 a Run Date: 10/7/2020 11:56:32AM GIL Date: 9/30/2020 0.00 1,791.36 19,512.09 0.00 97.75 1,008.83 0.00 16.37 168.00 0.00 12.58 125.41 0.00 193.19 2,192.18 0.00 0.00 2.43 0.00 2,11111.J25 23,008.94 �.:/ Page: 4 User Logon: CAS General Ledger Detail Report I Summary Report for Period 09 Ending 9/30/2020 HOUSING AUTHORITY OF GRANT COUNTY (GCH) PROJECT 09 - Account Number/Description Beg Balance Debit Credit Net Change End Balance 411000-7-09 ADMIN SALRIES HEN-CHG 1,565.39 210.25 0.00 210.25 1,775.64 418200-7-09 ADMIN FICA HEN- CHG 117.04 15.82 0.00 15.82 132.86 418201-7-09 ADMIN SUTA HEN-CHG 18,60 2.58 0.00 2.58 21.18 418202-7-09 ADMIN L&I HEN-CHG 10.45 1.40 0.00 1.40 11.85 418204-7-09 ADMIN RETIREMENT HEN-CHG 224.56 37.97 0.00 37.97 262.53 418205-7-09 ADMIN MED/DENTNIS/L HEN -CH, 436.28 100.64 0.00 100.64 536.92 471501-7-09 HAP PAYMENTS RENT HEN-CHG 76,292.41 10,380.00 0.00 IA,380.00 86,672.41 471506-7-09 RENT DEPOSITS HEN-CHG 1,025.00 0.00 0.00 0.00 1,025.00 PROJECT 09 - Total: 79,689.73 10,748.66 0.00 10,748.66 90,438.39 000 Report Total: 216,225.23 28,461.32 0.00 28,461.32 244,686.55 0 ° 0 0 G + 2100.25 + i 15-82 + 2-58 + �' 000+ 1.40 + 37.97 + 100-64 + CL -^,w, rp7-4 L 416.81 + 006 6,275.84 + 368°66G+ se -8,908.76 + 000 2,111.25 + 368°66 + 9,885.00 + �f �v itG•c� 006 ?7•966°32G+ 000 C*g0.00G+ 10,380.00 + 495.00 - OOU 002 0.00G+ 9,885°00G+ 27:,9L-3+ KJvIrha 002 2_8,4 t0 3s 4 '"a ;�,t{,�, � MF4 �"a�-' g y'bF E.- v fM1:�4-:��F...V✓* . �.• �•Y9"•f+ n.'R Run Date: 1017/2020 11:56:32AM k Page: 5 G/L Date: 9/30/2020 '' User Logon: CAS (tv �i-i General Ledger Detail Report Detail Postings for Period 09 Ending 9/30/2020 HOUSING AUTHORITY OF GRANT COUNTY (GCH) Account Number/Description Period Date Journal Comments Beg Balance Debit Credit Net Change End Balance 471501-7-09 0.00 09 9/2/2020 AP -003709 09 9/2/2020 AP -003709 09 9/2/2020 AP -003709 09 9/2/2020 AP -003709 09 9/2/2020 AP -003709 09 9/2/2020 AP -003709 09 9/2/2020 AP -003709 09 9/2/2020 AP -003709 09 9/2/2020 AP -003709 09 9/2/2020 AP -003709 09 9/2/2020 AP -003709 09 9/2/2020 AP -003709 09 9/2/2020 AP -003709 09 9/2/2020 AP -003709 09 9/2/2020 AP -003709 09 9/2/2020 AP -003709 09 9/2/2020 AP -003709 09 9/2/2020 AP -003709 09 9/2/2020 AP -003709 09 9/2/2020 AP -003709 09 9/2/2020 AP -003709 09 9/2/2020 AP -003709 HAP PAYMENTS R 000100235 /IN: 000100235 /IN: 000100235 /IN: 00010662411 N 000107079lIN:: 000107200 /IN: 000107415 /IN: 000108425 /IN: 000108493 /IN: 000108493/IN: 000108550 /IN: 000108550 /IN: 000108599/IN: 000108599/IN: 000108606 /IN: 000108606 /IN 000101625N :- 000108680 /IN, 000108844/IN: 000108844/1 000108844 /1 000108855 /IN: A Report Total: 76,292.41 300.00 0.00 76,592.41 300.00 0.00 76.892.41 300.00 0.00 77,192.41 550.00 0.00 77,742.41 425.00 0.00 78,167.41 560.00 0.00 78, 727.41 300.00 0.00 79, 027.41 440.00 0.00 79,467.41 600.00 0.00 80,067.41 600.00 0.00 80,667.41 525.00 0.00 81,192.41 495.00 (1) 0.00 81,687.41 400.00 0.00 82,087.41 560.00 0.00 82.647.41 515.00 0.00 83,162.41 535.00 0.00 83,697.41 300.00 0.00 83,99741 450.00 0.00 84,447.41 625.00 0.00 85.072.41 575.00 0.00 85,647.41 T 625.00 0.00 86,272.41 400.00 0.00 86,672.41 76,292.41 10,380.00 0.00 10,380.00 86,672.41 76,292.41 10,380.00 0.00 10,380.00 86,672.41 of �y / i re a•, .+ J 14.1C-�...+�"�+'m�"� . .'��i €'.�.,•:..a�� ;�"�� .<,r�.� 1�t% �N�.�gea+ � a�,-. Run Date: 10/7/2020 12:11:10PM Page: 1 G/L Date: 9130/2020 User Logon: CAS