The URL can be used to link to this page

Home My WebLink AboutGrant Related - BOCC (002)U ` 1 1 •wvw.hagc.net February 8, 2022 Housing Authority of Grant County Grant County Board of Commissioners ATTN: Janice Flynn Po 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,o TTY (800) 833-6388 Please consider this letter and attached documentation the Housing Authority's claim for draw #7 for January, 2022, for the Consolidated Homeless Grant. I certify that: The information on the A-19 and supporting documentation for the Consolidated Homeless Grant (CHG), contract # 22-46108-10, in the amount of $33,583.02 is a true and accurate report and that all reported expenditures are properly chargeable to the CHG . 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 disability, or familial 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 fully access and utilize the housing programs and related services, ti OPPORTUNITY I 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 #22-46108-1 CHG) Submitted to GC by: HAGC__,,C�. Date: 4, 7. Request for Reimbursement No. #7 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.9 For payroll transactions: _X Does the employee's time and effort documentation meet the requirements of Circular A-'122? _X Allocable to the program? (Le., 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 grantperiod? H:\ACCOUNTING\LOTUS\LOTUS\Consolidated HG\CHG 2021-20231CHG Subrecipient Checkfist.docx Page 1 General Ledger Detail Report Summary Report for Period 01 Ending 113112022 HOUSING AUTHORITY OF GRANT COUNTY (GCH) PROJECT 01 - Account Number/Description Beg Balance Debit Credit Net Change End Balance 411000-7-01 ADMIN SALARIES:CHG 0.00 153.40 0.00 153.40 153.40 418200-7-01 ADMIN FICA-CHG 0.00 11.50 0.00 11.50 11.50 418201-7-01 ADMIN SUTA-CHG 0.00 2.47 0.00 2.47 2.47 418202-7-01 ADMIN L&I-CHG 0.00 0.64 0.00 0.64 0.64 418204-7-01 ADMIN RETIREMENT:CHG 0.00 59.04 0.00 59.04 59.04 418205-7-01 ADMIN MED/DENTNIS/L:CHG 0.00 100.62 0.00 100.62 100.62 419018-7-01 POSTAGE:CHG 0.00 17.96 0.00 17.96 PROJECT 01 - Total: 0.00 345.63 0.00 7 345.63 34-5.63 Run Date: 2/7/2022 3:14:23PM Page: 1 GIL Date: 1213112021 User Logon: CAS General Ledger Detail Report Summary Report for Period 01 Ending 1/31/2022 HOUSING AUTHORITY OF GRANT COUNTY (GCH) P ROJ ECT 02 - Account Number/Description Beg Balance Debit Credit Net Change End Balance 411000-7-02 ADMIN SALARIES FACILITY SUPF 0.00 21817.09 0.00 21817.09 2,817.09 418200-7-02 ADMIN FICA FACILITY SUPP & Rj 0.00 209.81 0.00 209.81 209.81 418201-7-02 ADMIN SUTA FACILITY SUPP & R 0.00 45.36 0.00 45-36 45.36 418202-7-02 ADMIN L&I FACILITY SUPP & RA ( .0.00 13.74 0.00 13-74 13.74 418204-7-02 ADMIN RETIREMENT FACILITY S1 0.00 679.00 0.00 679.00 679.00 418205-7-02 ADMIN MED/DENT/VIS/L FACILIT' 0.00 11981.96 0.00 11981-96 11981.96 443000-7-02 CONTRCT SVC MAINT FACILITY,' 0.00 93.24 0.00 93.24 93.24 PROJECT 02 - Total: 0.00 51840.20 0.00 51840.20 51840.201 C2--) 6" Run Date: 217/2022 3:14:23PM Page: 2 G/L Date: 12131/2021 User Logon: CAS General Ledger Detail Report Summary Report for Period 01 Ending 1/31/2022 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 0.00 31334.23 0.00 31334.23 31334.23 471502-7-04 HAP PAYMNT PROJECT LEASE C 0.00 31552.00 0.00 31552.00 3,552.00 471506-7-04 RENT DEPOSITS-CHG 0.00 871.00 0.00 8 871.00 PROJECT 04 - Total: 0.00 71757.23 0.00 W.—o— 7,757.23 71757.23 Run Date: 2/7/2022 3:14:23PM Page: 3 G/L Date: 12131/2021 User Logon: CAS General Ledger Detail Report Summary Report for Period 01 Ending 1/31/2022 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 0.00 2,207.28 0.00 21207.28 2,207.28 418200-7-08 ADMIN FICA-HEN-OPS-CHG 0.00 97.94 0.00 97.94 97.94 418201-7-08 ADMIN SUTA HEN-OPS-CHG 0.00 21.15 0.00 21.15 21.15 418202-7-08 ADMIN L&I HEN-OPS-CHG .0.00 6.23 0.00 6.23 6.23 418204-7-08 ADMIN RETIREMENT HEN -OPS -C 0.00 311.13 0.00 311.13 311-13 418205-7-08 ADMIN MED/DENTNIS/L HEN -OR 0.00 0.16 0.00 0.16 0.16 PROJECT 08 - Total: 0.00 21643.89 0.00 21643 �4 3, 8-1 89 . 2,643.89' Run Date: 2/7/2022 3:14:23PM Page: 4 G/L Date: 1213112021 User Logon: CAS General Ledger Detail Report Summary Report for Period 01 Ending 1131/2022 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 0.00 61.36 0.00 61.3 61.36 418200-7-09 ADMIN FICA HEN- CHG 0.00 4.60 0.00 it 4.60 4.60 418201-7-09 ADMIN SUTA HEN-CHG 0.00 0,99 0.00 0.99 0.99 418202-7-09 ADMIN L&I HEN-CHG 0.00 0.25 0.00 0.25 0.25 418204-7-09 ADMIN RETIREMENT HEN-CHG 0.00 8.04 0.00 8.04 8--04 418205-7-09 ADMIN MED/DENTNIS/L HEN -CH, 0.00 12.58 0.00 12.58 471501-7-09 HAP PAYMENTS RENT HEN-CHG 0.00 17,008.25 0.00 17,008.2 17,008.25 PROJECT 09 - Total: 0.00 17,096.07 0.00 171096.07 17,096.07 Report Total: 0.00 331683.02 0.00 33,683.02 33,683.02 0:0 t4v 6 1 6 + h. 60 + 0 99 + 000 0 0 0 + 1 2 5 8 + 6 5 + 0 20 + 006 5 87 82 7 7 2 6 4 8 s-.7 8.2 I 0 3 0 �'- 3 006 3 , 6 8 3 o-02 Run Date: 2/712022 3:14:23PM Page: 6 GIL Date: 12/3112021 User Logon: CAS CHG JANUARY 2022 471501.-7-04 HAP PAYMENTS RENT - CHG E5DE00128 Rental Assistance: Rental Assistance 01101/2022 $680.00 E0F10BF0B Rental Assistance: Rental Assistance 01/01/2022 $482,00 B501 C12E0 Rental Assistance: Rental Assistance 01/01/2022 $450.00 B263ECE6D Rental Assistance: Rental Assistance 01/01/2022 $271.00 CE5456CO8 Rental Assistance: Rental Assistance 01101/2022 $1,002.00 9D79E26FA Rental Assistance: Rental Assistance 01/13/2022 $183.87 5981AAE3F Rental Assistance: Rental Assistance 01/05/2022 $261..36 $3,330.23 471501-7-09 HAP PAYMENTS RENT - HEN 53C04A31 D HEN Rent Assistance: HEN Rent Assistance 01/01/2022 $650.00 427C2B5BF HEN Rent Assistance: HEN Rent Assistance 01/01/2022 $700.00 A27DD0130 HEN Rent Assistance: HEN Rent Assistance 01/01/2022 $300.00 1 DOCDDFOD HEN Rent Assistance: HEN Rent Assistance 01/01/2022 $300.00 CAD7866A2 HEN Rent Assistance: HEN Rent Assistance 01/01/2022 $525.00 B358OBCEA HEN Rent Assistance: HEN Rent Assistance 01/0112022 $595.00 9F74B4ACF HEN Rent Assistance: HEN Rent Assistance 01/0112022 $775.00 BBAF1 DB7C HEN Rent Assistance: HEN Rent Assistance 01/01/2022 $400,00 F35OF8A2A HEN Rent Assistance: HEN Rent Assistance 01/01/2022 $550.00 E59AAEAF9 HEN Rent Assistance: HEN Rent Assistance 01/01/2022 $440.00 410E07E70 HEN Rent Assistance: HEN Rent Assistance 01101/2022 $10086,00 C4BCA126F HEN Rent Assistance: HEN Rent Assistance 01/01/2022 $425.00 8D071A4A1 HEN Rent Assistance: HEN Rent Assistance 01101/2022 $600.00 1 BOB90DAF HEN Rent Assistance: HEN Rent Assistance 01/01/2022 $525.00 CE6BC384A HEN Rent Assistance: HEN Rent Assistance 01/01/2022 $550.00 4CBD53486 HEN Rent Assistance: HEN Rent Assistance 01/01/2022 $575.00 A585CABF1 HEN Rent Assistance: HEN Rent Assistance 01/01/2022 $450.00 7401303F50 HEN Rent Assistance: HEN Rent Assistance 01/01/2022 $675.00 551 CAE122 HEN Rent Assistance: HEN Rent Assistance 01/0112022 $350.00 542299D6B HEN Rent Assistance: HEN Rent Assistance 01/01/2022 $675.00 3B753E8E4 HEN Rent Assistance: HEN Rent Assistance 01101/2022 �at� 9a.GG 008962DOF HEN Rent Assistance: HEN Rent Assistance 01/01/2022 $625.00 BF11A77AB HEN Rent Assistance: HEN Rent Assistance 01/01/2022 $250.00 3C1347377 HEN Rent Assistance: HEN Rent Assistance 01/01/2022 $425.00 99CFE201`4 HEN Rent Assistance: HEN Rent Assistance 01/01/2022 $300.00 5F3227409 HEN Rent Assistance: HEN Rent Assistance 01/01/2022 $400.00 24D9AD65C HEN Rent Assistance: HEN Rent Assistance 01/01/2022 $555.00 362843CEC HEN Rent Assistance: HEN Rent Assistance 01/01/2022 $400.00 28139DDED7 HEN Rent Assistance: HEN Rent Assistance 01101/2022 $400.00 453EB0019 HEN Rent Assistance: HEN Rent Assistance 01/01/2022 $530.00 D3731DO14 HEN Rent Assistance: HEN Rent Assistance 01/01/2022 $650.00 EE7414580 HEN Rent Assistance: HEN Rent Assistance 01/01/2022 $500.00 OF7457991 HEN Rent Assistance: HEN Rent Assistance 01114/2022 $232.25 $17,008.25 471506-7-04 RENT DEPOSITS - CHG B263ECE6D Security Deposit: Security Deposit 01/01/2022 $271.00 9D79E26FA Security Deposit: Security Deposit 01/13/2022 $300.00 5981AAE3F Security Deposit: Security Deposit 01/05/2022 $300.00 $871.00 General Ledger Detail Report Detail Postings for Period 01 Ending 1/31/2022 Account Number/Description Period Date Journal 471501-7-04 01 1/4/2022 AP -004029 01 1/4/2022 AP -004029 01 1/4/2022 AP -004029 01 1/10/2022 AP -004033 01 1113/2022 AP -004035 01 1/25/2022 AP -004044 01 1/31/2022 AP -004047 471501-7-09 Beg Balance 01 1/3/2022 AP -004028 01 1/3/2022 AP -004028 01 1/4/2022 AP -004029 01 1/4/2022 AP -004029 01 1/4/2022 AP -004029 01 1/4/2022 AP -004029 01 1/4/2022 AP -004029 01 1/4/2022 AP -004029 01 1/4/2022 AP -004029 01 1/4/2022 AP -004029 01 1/4/2022 AP -004029 01 1/4/2022 AP -004029 01 1/4/2022 AP -004029 01 1/4/2022 AP -004029 01 1/4/2022 AP -004029 01 1/4/2022 AP -004029 01 1/4/2022 AP -004029 01 1/4/2022 AP -004029 01 1/4/2022 AP -004029 01 1/4/2022 AP -004029 01 11412022 AP -004029 01 1/4/2022 AP -004029 01 1/4/2022 AP -004029 01 1/4/2022 AP -004029 01 1/4/2022 AP -004029 01 1/4/2022 AP -004029 01 1/4/2022 AP -004029 01 1/4/2022 AP -004029 01 1/4/2022 AP -004029 01 1/4/2022 AP -004029 01 1/4/2022 AP -004029 01 1/4/2022 AP -004029 01 1/20/2022 AP -004042 Account Number/Description Period Date Journal 471502-7-04 01 1/4/2022 AP -004029 01 1/4/2022 AP -004029 01 1/4/2022 AP -004029 01 1/4/2022 AP -004029 01 1/4/2022 AP -004029 01 114/2022 AP -004029 HOUSING AUTHORITY OF GRANT COUNTY (GCH) Comments Beg Balance Debit Credit Net Change End Balance HAP PAYMENTS RENTS-CHG 0.00 1,776.00 614.00 0.00 2,390.00 581.00 0.00 680.00 0.00 0.00 6$Q.00 482.00 0.00 11162.00 450.00 0.00 11612.00 271.00 0.00 1,883.00 11002.00 0.00 21885.00 Overpayment of $4, will be adjusted in Feb 2022 187.87 0.00 3,072.87 261.36 0.00 31334.23 0.00 31334.23 0.00 3,334.23 3,334.23 HAP PAYMENTS RENT HEN-CHG 0.00 650.00 0.00 650.00 700.00 0.00 1,350.00 300.00 0.00 1,650.00 300.00 0.00 11950.00 525.00 0.00 21475.00 550.00 0.00 31025.00 775.00 0.00 31800.00 400.00 0.00 43200.00 550.00 0.00 41750.00 425.00 0.00 5,175.00 1,086.00 0.00 61261.00 440.00 0.00 6,701.00 600.00 0.00 7,301.00 525.00 0.00 7,826.00 595.00 0.00 8,421.00 575.00 0.00 81996.00 450.00 0.00 9,446.00 675.00 0.00 10,121.00 350.00. 0.00 10,471.00 675.00 0.00 11,146.00 595.00 0.00 11,741.00 625.00 0.00 12,366.00 250.00 0.00 12,616.00 425.00 0.00 13,041.00 300.00 0.00 13,341.00 400.00 0.00 13,741.00 555.00 0.00 14,296.00 400.00 0.00 14,696.00 400.00 0.00 15,096.00 530.00 0.00 15,626.00 650.00 0.00 16,276.00 500.00 0.00 16,776.00 232.25 0.00 17,008.25 0.00 17,008.25 0.00 L17,008.25 17,008.25 Comments Beg Balance Debit Credit Net Change End Balance HAP PAYMNT PROJECT LEASE CC 00010023511 N: 1004010422 000100235/IN:1006010422 000100235 /IN: 1008010422 000100235 /IN: 1010010422 000100235/IN:1102010422 0001002351IN:1104010422 0.00 581.00 0.00 581.00 581.00 0.00 1,162.00 614.00 0.00 1,776.00 614.00 0.00 2,390.00 581.00 0.00 2,971.00 581.00 0.00 31552.00 0.00 3,552.00 0.00 3,552.00 3,552.00 471506-7-04 01 1/10/2022 AP -004033 01 1/25/2022 AP -004044 01 1/31/2022 AP -004047 Run Date: 2/1/2022 10:39:27AM GIL Date: 2/1/2022 RENT DEPOSITS-CHG 0.00 271.00 0.00 271.00 300.00 0.00 571.00 300.00 0.00 871.00 0.00 871.00 0.00 871.00 871.00 Report Total: 0.00 24,765.48 0.00 24,765.48 24,765.48 Page: 2 User Logon: SAB Grantee Name: Grant County ILead Grantee List Sub Grantee Names Below Total Report Month/Year: JANUARY 2021 HAGC PSH/CI S,ki &HOI Voucher Detail Worksheet Grantee Name: Grant County Lead Grantee List Sub Grantee Names Below Report Month/Year: JANUARY 2021 HAGC Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 Jan-22 Feb-22 BUDGET DRAW #1 DRAW #2 DRAW #3 DRAW #4 DRAW #5 DRAW #6 DRAW #7 DRAW #8 $798.07 $512.37 $837.77 $2,274.80 $1,911.81 $630.55 $345.63 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $11,099.29 $10,949.77 $16,677.94 $15,231.46 $11,409.33 $11,300.80 $7,757.23 $8,250.57 $3,951.70 $5,480.61 $5,433.38 $5,949.24 $9,591.74 $5,840.20 $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 $152.83 $116.83 $190.31 $251.64 $104.62 $85.80 $87.82 $14,613.19 $13,891.00 $16,848.25 $15,738.68 $15,966.00 $18,611.00 $17,008.25 $5,643.50 $2,972.96 $4,390.12 $4,137.56 $4,040.96 $4,700.58 $2,643.89 $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 Mar -22 Apr -22 May -22 Jun -22 TOTAL OF BALANCE DRAW #9 DRAW #10 DRAW #11 DRAW #12 DRAWS REMAINING $7,311.00 $62,639.00 $0.00 $5,000.00 $84,425.82 $132,113.18 $44,497.44 $130,502.56 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $989.85 $24,010.15 $112,676.37 $149,276.63 $28,529.57 $45,470.43 $0.00 $25,000.00 $0.00 $261,953.00 $0.00 $74,000.00 Invoice Tota $40,557.45 $32,394.63 $44,425.00 $43,067.52 $39,381.96 $44,920.47 $33,683.02 $0.00 $0.00 $0.00 $0.00 $0.00 $278,430.05 $909,964.95 $1,188,395.00