Loading...
HomeMy WebLinkAboutGrant Related - BOCC (002)a, Lj- www.hagc.net November 5, 2020 Housing Authority of Grant County Grant County Board of Commissioners ATTN: June Strickler 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 Dated this _JV:jr day of M _ 2020 Board of County Commissioners Grant County, Washington Anprov Disa rove Abstain Dist 91 Dist # I Dist # I Dist #2 Dist # 2 Dist # 2 Dist #3 Dist # 3 Dist # 3 Please consider this letter and attached documentation the Housing Authority's claim for draw #16 for October, 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,910.18 is a true and accurate report and that all reported expenditures are properly chargeable to the CHG grant. Sincerely, Christopher A. Sutherland Financial Director NOV -- 5 2020 ?3}y rpU COM The HousingAuthorityof 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 disability, orfaminal status. 7haHousingAuthorityofGrantCDotysPOUciesandpractices am desi81ed to provideasuvmneesthatpersons with disabilities will begivenreasonableaccommodatlow.- EQUAL MOUSING upon request so that they may fuUy access and utilize the housing programs and related smices. OPPORTUNITY If you or anyone in your family is a person with disabilities, andyou require a specific accommodation in order tofu Uy utilize our programs and services, please contact the Housing Authority. Grant County/GCHA Contrac 6108-10 (CH Submitted to GC by: HAGC Q Date:I... s Request foeReimbursement No. #16 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?) Based on actual costs, not budgeted or projected amounts? 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 confonnity 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:W000UNTING\LOTUS\LOTUS\Consolidated HG\CHG 2019-2021\CHG Subrecipient Checklist.docx Page 1 CHG Base Funding PSH/CHF RENT/FAC SUPP/ LEASE &HOUSING COSTS HEN SFY 2020 7/1/2020- 6/30/2021 Grantee Name: Grant County Lead Grantee List Sub Grantee Names Below Total Report Month/Year: OCTOBER 2020 1 1 HAGC Admin $530.65 $530.65 CHG-Other Rent/Fac Supp Lease & Housing Costs $0.00 $0.00 CHG-Rent & Fac support/Lease Costs $7,163.70 $7,163.70 CHG-Operations $7,917.96 $7,917.96 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 Housing Costs 2020 $0.00 $0.00 HEN- Operations 2020 $0.00 $0.00 HEN- Admin 2021 $503.55 $503.55 HEN- Rent/Fac Supp & Other Housing Costs 021 $9,325.00 $9,325.00 perations 2021 1 $2,469.321 1 1 $2,469.32 Invoice Total: $27,910.18 TOTAL OF BALANCE DRAWS REMAINING $18,345.14 $41,654.86 $0.00 $25,000.00 $132,293.21 $110,837.79 $100,690.31 $99,309.69 $0.00 $5,000.00 $0.00 $20,222.00 $826.27 $9,173.73 $3,167.10 $5,332.90 $147,078.04 $2,953.96 $39,607.13 $4,892.87 $1,556.12 $6,943.88 $41,196.45 $108,835.55 $10,741.25 $33,758.75 $495,501.02 $473,915.98 Grantee Name: Grant County_ Lod Grante.� lis[6ub Grantee Names Below Report Month/Year: OCTOBER 2020 JHAGC J-20 Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 Od-20 Nov-20 Dec-20 Jan-21 Feb-21 BUDGET DRAW R7 DRAW 88 DRAW e9 DRAW N10 DRAW ell DRAW g12 DRAW g13 DRAW 414 DRAW 415 DRAW p16 DRAW N17 DRAW N18 DRAW e19 DRAW e20 Admin $60,000.00 365.17 532.25 169.79 30.92 518.95 861.44 1186.13 173.16 416.81 530.65 CHG-Other Rent/Fac Supp Lease & Housing Costs $25,000.00 0 0 0 0 0 0 0 0 0 0 CHG-Rent& Fac su port Lease Costs$243,131.00 10700.22 8420.54 9437.62 9607.57 6720.58 5874 7011.52 5210.12 8908.76 7163.7 ratlom $200000.00 6659.37 6991.45 4826.51 7107.01 7296.38 4636.81 6057.26 4663.18 6275.84 7917.96 SH CHF Fcili Su IT Isase Costs 2"' $5,000.00 0 0 0 0 0 0 0 0 0 0 PSH CHF O[her Hent Fac Su Lease &Mous $20 222.00 0 O 0 0 0 0 0 0 0 0 PSH/CHF Orations 10000.00 0 0 0 0 $0.00 0 0 0 0 0 HEN•. Admin 2020 $8500.00 364.99 312.2 225.53 383.3 231.38 151.91 0 0 0 0 NEN- Rent end Housln Costs 2020 $150,032.00j 11635 9975 9675 7825 8095.96 8125 0 0 0 0 HEN- O ratl" 2020 544 500.00 2873.83 2624.12 1471.18 3918.32 2334.55 2291.87 0 0 0 0 HEN-Admiu2021 $8500.00. 0 0 0 0 0 0 257.6 426.31 368.66 503.55 HEN- R..VFec Supp & Other Hopsing Casts 1021 .$150,032.60 0 0 0 0 0 0 11306.45 10680 9885 9325 .EN." tetlorN2021 500.00 0 0 0 0 0 0 4634.04 1526.64 2111.25 2469.32 Invoice Tota $32,598.58 $28,855.56 $25,805.63 $28,872.12 $25,197.80 $21,941.03 $30,453.00 $22,679.41 $27,966.32 $27,910.18 TOTAL OF BALANCE DRAWS REMAINING $18,345.14 $41,654.86 $0.00 $25,000.00 $132,293.21 $110,837.79 $100,690.31 $99,309.69 $0.00 $5,000.00 $0.00 $20,222.00 $826.27 $9,173.73 $3,167.10 $5,332.90 $147,078.04 $2,953.96 $39,607.13 $4,892.87 $1,556.12 $6,943.88 $41,196.45 $108,835.55 $10,741.25 $33,758.75 $495,501.02 $473,915.98 General Ledger Detail Report Summary Report for Period 10 Ending 10/31/2020 HOUSING AUTHORITY OF GRANT COUNTY (GCH) PROJECT 01 - Account Number/Description Beg Balance Debit Credit Net Change End Balance 408204-7-01 MGMT RETIREMENT:CHG 54.10 11.71 0.00 11.71 65.81 408205-7-01 MGMT MED/DENTNIS/LI:CHG 87.82 18.82 0.00 18.82 106.64 411000-7-01 ADMIN SALARIES:CHG 534.17 0.00 0.00 0.00 534.17 415000-7-01 TRAVEL:CHG 17.83 0.00 0.00 0.00 17.83 418200-7-01 ADMIN FICA-CHG 39.72 0.00 0.00 0.00 39.72 418201-7-01 ADMIN SUTA-CHG 6.57 0.00 0.00 0.00 6.57 418202-7-01 ADMIN L&I-CHG 5.16 0.00 0.00 0.00 5.16 418205-7-01 ADMIN MED/DENTNIS/L:CHG 668.33 0.00 0.00 0.00 668.33 419012-7-01 MEMBERSHIP DUES & FE-CHG 450.00 0.00 0.00 0.00 450.00 419013-7-01 TELEPHONE:CHG 0.00 7.51 0.00 7.51 7.51 419018-7-01 POSTAGE:CHG 4.50 0.00 0.00 0.00 4.50 441000-7-01 MAINTENANCE SALARIES:CHG 1,772.41 326.37 0.00 326.37 2,098.78 443300-7-01 MAINT FICA:CHG 133.92 24.63 0.00 24.63 158.55 443301-7-01 MAINT SUTA:CHG 21.80 4.02 0.00 4.02 25.82 443302-7-01 MAINT L&I:CHG 179.40 40.21 0.00 40.21 219.61 443304-7-01 MAINT RETIREMENT:CHG 322.01 47.84 0.00 47.84 369.85 443305-7-01 MAINT MED/DENTNIS/L:CHG 1.30 49.54 0.00 49.54 50.84 PROJECT 01 -Total: 4,299.04 530.65 0.00 530.65 4,829.69 N Run Date: 11/4/2020 1:36:52PM Page: 1 G/L Date: 10/31/2020 User Logon: CAS General Ledger Detail Report Summary Report for Period 10 Ending 10/31/2020 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 33,098.96 5,451.72 0.00 5,451.72 38,550.68 418200-7-02 ADMIN FICA FACILITY SUPP & RJ 2,434.50 399.59 0.00 399.59 2,834.09 418201-7-02 ADMIN SUTA FACILITY SUPP & R 404.93 66.78 0.00 66.78 471.71 418202-7-02 ADMIN L&I FACILITY SUPP & RA ( 297.86 50.86 0.00 50.86 348.72 418204-7-02 ADMIN RETIREMENT FACILITY Si 5,306.80 556.50 0.00 556.50 5,863.30 418205-7-02 ADMIN MEd/DENTNIS/L FACILIT` 12,970.43 1,258.72 0.00 1,258.72 14,229.15 419013-7-02 TELEPHONE -FACILITY SUPP FOI 3.32 0.00 0.00 0.00 3.32 443000-7-02 CONTRCT SVC MAINT FACILITY ; 532.45 133.79 0.00 133.79 666.24 PROJECT 02 - Total: 55,049.25 7,917.96 0.00 7,917.96 62,967.21 r , f Run Date: 11/4/2020 1:36:52PM Page: 2 G/L Date: 10/3112020 User Logon: CAS General Ledger Detail Report Summary Report for Period 10 Ending 1013112020 HOUSING AUTHORITY OF GRANT COUNTY (GCH) PROJECT 04 - Account Number/Description Beg Balance Debit Credit Net Change End Balance 471501-7-04 HAP PAYMENTS RENTS-CHG 28,105.28 2,736.70 0.00 2,736.70 30,841.98 471502-7-04 HAP PAYMNT PROJECT LEASE C 31,968.00 3,552.00 0.00 3,552.00 35,520.00 471506-7-04 RENT DEPOSITS-CHG 10,673.00 1,450.00 575.00 875.00 11,548.00 471508-7-04 MOTEL VOUCHERS-CHG 1,144.65 0.00 0.00 0.00 1,144.65 PROJECT 04 - Total: 71,890.93 7,738.70 575.00 7,163.70 79,054.63 Run Date: 11/4/2020 1:36:52PM Page: 3 G/L Date: 10/31/2020 User Logon: CAS General Ledger Detail Report Summary Report for Period 10 Ending 1013112020 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-OPS-CHG 19,512.09 2,122.09 0.00 2,122.09 21,634.18 418200-7-08 ADMIN FICA-HEN-OPS-CHG 1,008.83 125.57 0.00 125.57 1,134.40 418201-7-08 ADMIN SUTA HEN-OPS-CHG 168.00 21.05 0.00 21.05 189.05 418202-7-08 ADMIN L&I HEN-OPS-CHG 125.41 16.14 0.00 16.14 141.55 418204-7-08 ADMIN RETIREMENT HEN -OPS -C 2,192.18 184.15 0.00 184.15 2,376.33 418205-7-08 ADMIN MED/DENTNIS/L HEN -OP: 2.43 0.32 0.00 0.32 2.75 PROJECT 08 - Total: 23,008.94 2,469.32 0.00 2,469.32 25,478.26 Run Date: 11/4/2020 1:36:52PM Page: 4 G/L Date: 10131/2020 User Logon: CAS General Ledger Detail Report Summary Report for Period 10 Ending 10/31/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,775.64 334.36 0.00 334.36 2,110.00 418200-7-09 ADMIN FICA HEN- CHG 132.86 25.02 0.00 25.02 157.88 418201-7-09 ADMIN SUTA HEN-CHG 21.18 1.87 0.00 1.87 23.05 418202-7-09 ADMIN L&I HEN-CHG 11.85 2.26 0.00 2.26 14.11 418204-7-09 ADMIN RETIREMENT HEN-CHG 262.53 52.27 0.00 52.27 314.80 418205-7-09 ADMIN MED/DENTNIS/L HEN -CH, 536.92 87.77 0.00 87.77 624.69 471501-7-09 HAP PAYMENTS RENT HEN-CHG 86,177.41 9,325.00 0.00 9,325.0 95,502.41 471506-7-09 RENT DEPOSITS HEN-CHG 1,025.00 0.00 0.00 0.00 1,025.00 PROJECT 09 - Total: 89,943.39 9,828.55 0.00 9,828.55 99,771.94 Report Total: 244,191.55 28,485.18 575.00 27,910.18 272,101.73 000 0-00G+ 334-36 + 25.02 + 1®87 + 2.26 + 52.27 + 87-77 + 006 503 55G+ HEIV SL Lr- ie,�ac C 9 3 Run Date: 11/4/2020 1:36:52PM G/L Date: 1013112020 Mug] 11 Ii. 0.00G+ 530.65 + 7917°96 + 7 16370 + 2'469°32 + 503 55 + 9 • 32500 + 27,910c18G+ 0) Page: 5 User Logon: CAS CHG OCTOBER 2020 471501-7-04 HAP PAYMENTS RENT CHG 4098C79139 Rental Assistance: Rental Assistance 10/01/2020 $300.00 083D18130D Rental Assistance: Rental Assistance 10/01/2020 $550.00 DB340E38D Rental Assistance: Rental Assistance 10/01/2020 $900.00 B263ECE6D Rental Assistance: Rental Assistance 10/01/2020 $220.00 4CBD53486 Rental Assistance: Rental Assistance 10/01/2020 $191.70 4CBD53486 Rental Assistance: Rental Assistance 10/01/2020 $575.00 $2,736.70 471501-7-09 HAP PAYMENTS RENT - HEN CA8472172 HEN Rent Assistance: HEN Rent Assistance 10/01/2020 $300.00 6500C2195 HEN Rent Assistance: HEN Rent Assistance 10/01/2020 $300.00 A54C625DB HEN Rent Assistance: HEN Rent Assistance 10/01/2020 $300.00 93EBA4669 HEN Rent Assistance: HEN Rent Assistance 10/01/2020 $550.00 C4BCA126F HEN Rent Assistance: HEN Rent Assistance 10/01/2020 $425.00 7A4164681 HEN Rent Assistance: HEN Rent Assistance 10/01/2020 $560.00 551CAE122 HEN Rent Assistance: HEN Rent Assistance 10/01/2020 $300.00 E59AAEAF9 HEN Rent Assistance: HEN Rent Assistance 10/01/2020 $440.00 8D071A4A1 HEN Rent Assistance: HEN Rent Assistance 10/01/2020 $600.00 900909582 HEN Rent Assistance: HEN Rent Assistance 10/01/2020 $600.00 1BOB90DAF HEN Rent Assistance: HEN Rent Assistance 10/01/2020 $525.00 A585CABF1 HEN Rent Assistance: HEN Rent Assistance 10/01/2020 $400.00 3F07EA9AA HEN Rent Assistance: HEN Rent Assistance 10/01/2020 $515.00 8A5A1 BC92 HEN Rent Assistance: HEN Rent Assistance 10/01/2020 $535.00 7CE9CC39A HEN Rent Assistance: HEN Rent Assistance 10/01/2020 $300.00 5854FCFC6 HEN Rent Assistance: HEN Rent Assistance 10/01/2020 $450.00 7401303F51D HEN Rent Assistance: HEN Rent Assistance 10/01/2020 $625.00 2AD2609EO HEN Rent Assistance: HEN Rent Assistance 10/01/2020 $575.00 542299D6B HEN Rent Assistance: HEN Rent Assistance 10/01/2020 $625.00 37FFE58ED HEN Rent Assistance: HEN Rent Assistance 10/01/2020 $400.00 $9,325.00 471506-7-04 RENT DEPOSITS - CHG B263ECE6D Security Deposit: Security Deposit 10/01/2020 $300.00 4CBD53486 Security Deposit: Security Deposit 10/01/2020 $575.00 $875.00 General Ledger Detail Report Detail Postings for Period 10 Ending 10/31/2020 HOUSING AUTHORITY OF GRANT COUNTY (GCH) Account Number/Description Period Date Journal Comments Beg Balance Debit Credit Net Change End Balance 471501-7-04 HAP PAYMENTS RENTS-CHG 28,105.28 10 10/112020 AP -003727 000100235 /IN: 300.00 0.00 28,405.28 10 10/1/2020 AP -003727 000107426 /IN 550.00 0.00 28,955.28 10 10/112020 AP -003727 000108883 AN 900.00 0.00 29,855.28 10 1018/2020 AP -003730 000100235 AN: 220.00 0.00 30,075.28 10 10/8/2020 AP -003730 000108550 /IN:. 191.70 0.00 30,266.98 10 10/31/2020 7J-000266 CORR ACCOUNT POSTING ERROR -POS 575.00 0.00 30,841.98 28,105.28 2,736.70 0.00 2,736.70 30,841.98 471501-7-09 HAP PAYMENTS RENT HEN-CHG 86,177.41 10 10/1/2020 AP -003727 000100235 /IN. 300.00 0.00 86,477.41 10 10/1/2020 AP -003727 000100235 /IN: 300.00 0.00 86,777.41 10 10/1/2020 AP -003727 000100235 AN. 300.00 0.00 87,077.41 10 10/1/2020 AP -003727 000106624 /IN: 550.00 0.00 87,627.41 10 10/1/2020 AP -003727 000107079 AN: 425.00 0.00 88,052.41 10 10/1/2020 AP -003727 000107200 /I N. 560.00 0.00 88,612.41 10 10/1/2020 AP -003727 000107415 AN: 300.00 0.00 88,912.41 10 10/1/2020 AP -003727 000108425 AN 440.00 0.00 89,352.41 10 10/1/2020 AP -003727 000108493 AN' 600.00 0.00 89,952.41 10 10/1/2020 AP -003727 000108493 At 600.00 0.00 90,552.41 10 10/1/2020 AP -003727 000108550 AN. 525.00 0.00 91,077.41 10 10/1/2020 AP -003727 000108599 AN, 400.00 0.00 91,477.41 10 10/1/2020 AP -003727 000108606 /IN 515.00 0.00 91,992.41 10 10/112020 AP -003727 000108606 /IN 535.00 0.00 92,527.41 10 10/1/2020 AP -003727 000108625 /IN: 300.00 0.00 92,827.41 10 10/1/2020 AP -003727 000108680 AN: 450.00 0.00 93,277.41 10 10/1/2020 AP -003727 000108844 /IN 625.00 0.00 93,902.41 10 10/1/2020 AP -003727 000108844 AN 575.00 0.00 94,477.41 10 10/1/2020 AP -003727 000108844 AN 625.00 0.00 95,102.41 10 10/1/2020 AP -003727 000108855 AN 400.00 0.00 95,502.41 86,177.41 9,325.00 0.00 9,325.00 95,502.41 471502-7-04 HAP PAYMNT PROJECT LEASE COSI 31,968.00 10 10/1/2020 AP -003727 000100235 AN: 1004100120 581.00 0.00 32,549.00 10 10/1/2020 AP -003727 000100235 AN: 1006100120 581.00 0.00 33,130.00 10 10/1/2020 AP -003727 000100235 /IN: 1008100120 614.00 0.00 33,744.00 10 10/1/2020 AP -003727 000100235 AN: 1010100120 614.00 0.00 34,358.00 10 10/1/2020 AP -003727 000100235 /IN: 1102100120 581.00 0.00 34,939.00 10 10!1/2020 AP -003727 000100235 /IN: 1104100120 581.00 0.00 35,520.00 31,968.00 3,552.00 0.00 3,552.00 35,520.00 471506-7-04 RENT DEPOSITS-CHG 10,673.00 10 10/8/2020 AP -003730 000100235 AN 300.00 0.00 10,973.00 10 10/8/2020 AP -003730 000108550 AN 575.00 0.00 11,548.00 10 10/8/2020 AP -003730 000108550 AN:.. _ 575.00 0.00 12,123.00 10 10/31/2020 7J-000266 CORR ACCOUNT POSTING ERROR -POS 0.00 575.00 11,548.00 10,673.00 1,450.00 575.00 875.00 11,548.00 471506-7-09 RENT DEPOSITS HEN-CHG 1,025.00 0.00 0.00 1,025.00 1,025.00 0.00 0.00 0.00 1,025.00 471508-7-04 MOTEL VOUCHERS -CHG 1,144.65 0.00 0.00 1,144.65 1,144.65 0.00 0.00 0.00 1,144.65 Run Date: 11/2/2020 2:00:48PM Page: 1 GAL Date: 11/2/2020 User Logon: SAB General Ledger Detail Report Detail Postings for Period 10 Ending 10/31/2020 HOUSING AUTHORITY OF GRANT COUNTY (GCH) Report Total: 159,093.34 17,063.70 575.00 16,488.70 175,582.04 Run Date: 11/2/2020 2:00:48PM Page: 2 GI Date: 11/2/2020 User Logon: SAB