Loading...
HomeMy WebLinkAboutGrant Related - BOCC (002)November 2., 2021 AuthorityHousing 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. e 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 #4 for October.. 2021, 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 $43,067.52 is a true and accurate report and that all reported expenditures are properly chargeable to the CHG grant. Sincerely, 4 Christopher A. Sutherland Financial Director Dated this day of )Vbl( _, 202�'i Board of County Commissioners Grant County, Washington Approve DisqpMove Mstain Dist #IDist# I Dist # I Dist #2 Dist # 2 Dist # 2 Dist #3 Dist # 3 Dist # 3 mom; GRANT COUNTY 004AMISSI ONERS, The HousingAuthority of Grant County, Washington is an equal opportunity provider and employer and does not discriminate an the basis of race, color, national origin, religion, sex, physical or mental 16 ) disability, or familial status. ?he Housing Authority of Grant County's policies and practices are designed to provide assurances that persons with disabilities will be given reasonable accommodations, VQUAL HOUSING upon request, so that they may fully access and utilize the housing programs and related services, OPPORTUNITY ffyou or anyone inyour family is aperson 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-10 (CHG) Submitted to GC by: HAGC Date: Request for Reimbursement No. #4 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 13, 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\Consolidated HG\CHG 2021-20231CHG Subrecipient Checklist.doex Page 1 General Ledger Detail Report Summary Report for Period 10 Ending 10/31/2021 Run Date: 11/212021 1:06:64PM Page: 1 G/L Date: 10/3112021 User Logon: CAS Ar 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 11169.91 397.70 0.00 397-70 11567.61 417001-7-01 ADMIN FEES -GRANT CO-CHG 11500.00 0.00 0.00 0.00 11500.00 418200-7-01 ADMIN FICA-CHG 85.56 29.00 0.00 29.00 114-56 418201-7-01 ADMIN SUTA-CHG 13.23 4.49 0.00 4.49 17.72 418202-7-01 ADMIN L&I-CHG 5.66 1.88 0.00 1,88 7.54 418204-7-01 ADMIN RETIREMENT:CHG 154.52 53.22 0.00 53.22 207.74 418 . 205-7-01 ADMIN MED/DENTNIS/LCHG 329.74 130.65 0.00 130.65 460-39 419012-7-01 MEMBERSHIP DUES & FE-CHG 500.00 0.00 0.00 0.00 500.00 419018-7-01 POSTAGE:CHG 94.95 16.96 0.00 16.96 111.91 441000-7-01 MAINTENANCE SALARIES:CHG 31195.36 11438.38 0.00 11438.38 4,633.74 443300-7-01 MAINT FICA:CHG 237.73 108.21 0.00 108.21 345-94 443301-7-01 MAINT SUTA:CHG, 63.63 16.25 0.00 16.25 69.88 443302-7-01 MAINT L&I:CHG 154.62 62.98 0.00 62.98 217.60 443304-7-01 MAINT RETIREMENT:CHG 412.79 1.5.08 0.00 15.08 427.87 443305-7-01 MAINT MEDIDENTNIS/L:CHG 715.47 0.00 0.00 0.00 715.47 Run Date: 11/212021 1:06:64PM Page: 1 G/L Date: 10/3112021 User Logon: CAS Ar ROJECT 01 -Total: 81-623.17 27274.80 0.00 21274.80 10,897.97 Run Date: 11/212021 1:06:64PM Page: 1 G/L Date: 10/3112021 User Logon: CAS General Ledger Detail Report Summary Report for Period 10 Ending 1013112021 WOW C.,} .,t** 17 Run Date: 11/212021 1:06:54PM Page: 3 GIL Date: 1013112021 User Logon: CAS 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 97,247.90 71827.46 0.00 7,827.46 105,075.36 471502-7-04 HAP PAYMNT PROJECT LEASE C 31 j968.00 31552.00 0.00 3,552.00 35,520.00 471506-7-04 RENT DEPOSITS -CHC 21,497.00 3,852.00 0.00 3,852.00 25,349.00 471508-7-04 MOTEL VOUCHERS -CHG 10,701.40 0.00 0.00 0.00 10,701.40 PROJECT 04 - Total: 161,414.30 15,231.46 0.00 15,231.46 176,645.76 WOW C.,} .,t** 17 Run Date: 11/212021 1:06:54PM Page: 3 GIL Date: 1013112021 User Logon: CAS General Ledger Detail Report Summary Report for Period 10 Ending 10/31/2021 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 SUPE 36,993.81 31707.77 0.00 31707.77 40,701.58 418200-7-02 ADMIN FICA FACILITY SUPP & [:;U 21729.27 269.32 0.00 269.32 2,998.59 418201-7-02 ADMIN SUTA FACILITY SUPP & R 494.77 41.71 0.00 41.71 536.48 418202-7-02 ADMIN L&I FACILITY SUPP & RA 206.55 20.34 0.00 20.34 226,89 418204-7-02 ADMIN RETIREMENT FACILITY S1 51417.67 408.56 0.00 408.56 51826.23 418205-7-02 ADMIN MED/DENTNIS/L FACILIT' 13,598.28 985.68 0.00 985.68 14,583-96 443000-7-02 CONTRCT SVC MAINT FACILITY1 818.26 0.00 -0.00 0.00 818.26 PROJECT 02 - Total: 60,258.61 51433.38 0.00 5,433.38 65,691.99 .,A -A y --w%% Run Date: 1112/2021 1:06:64PM Page: 2 G/L. Date: 10/31/2021 User Logon: CAS General Ledger Detail Report Summary Report for Period 10 Ending 1013112021 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 23,974.37 31583.18 0.00 31583.18 27,557.55 418200-7-08 ADMIN FICA-HEN-OPS-CHG 11347.58 196.20 0.00 196.20 11543.78 418201-7-08 ADMIN SUTA HEN-OPS-CHG 230.05 29.80 0.00 29.80 259.85 418202-7-08 ADMIN L&I HEN-OPS-CHG 105,19 14.88 0.00 14.88 120.07 418204-7-08 ADMIN RETIREMENT HEN -OPS -C 21274.46 313.50 0.00 313.50 2,587.96 418205-7-08 ADMIN MED/DENT/VIS/L HEWOR, 1.78 0.00 0.00 0.00 1.78 PROJECT 08 - Total: 2 , 33.43 41137.56 0.00 41137.56 32,070.99 0 7, 3 7( Run Date: 11/212021 1:06:54PM Page: 6 G/L Date: 10/3112021 User Logon: CAS General Ledger Detail Report Summary Report for Period 10 Ending 10/31/2021 000 0 a 0.0 * 0 0 0 0 72 a 83 + 12o99 + I z 42 + O,o 67 +� 19 o 26 +1 44 47 + 006 1 2 5 1 .6 4, 41 000 /00 -� L -*L-rfi�r 002 Run Date: 1112/2021 1:0( G/L Date: 10/31/2021 00-o., 0 -e 00 006 Page: 6 User Logon: CAS HOUSING AUTHORITY OF GRANT COUNTY (GCH) PROJECT09- Account Number/Description Beg Balance Debit Credit Net Change End Balance 411000-7-09 ADMIN SALRIES HEN-CHG 11201.77 172.83 0.00 172-83 11374,60 418200-7-09 ADMIN FICA HEN- CHG 90.06 12.99 0.00 12.99 103.05 418201-7-09 ADMIN SUTA HEN-CHG 16.78 1.42 0.00 1.42 18.20 418202-7-09 ADMIN L&I HEN-CHG 5.50 0.67 0.00 0.67 6.17 418204-7-09 ADMIN RETIREMENT HEN-CHG 178.76 19.26 0.00 19.26 198-02 418205-7-09 ADMIN MED/DENTNIS/L HEN -CH, 324.40 44.47 0.00 44.47 368.87 471501-7-09 HAP PAYMENTS RENT HEN-CHG 114,046.46 14,938.68 0.00 14,938.6 6 128,985.14 471506-7-09 RENT DEPOSITS HEN-CHG 51315.00 800.00 0.00 800.00 6,115.00 PROJECT 09 - Total: 121,178.73 15,990.32 0.00 15,990.32 --137,169.05 Report Total: 379,708.24 43,067.52 0.00 43,067.52 4221775-76 000 0 a 0.0 * 0 0 0 0 72 a 83 + 12o99 + I z 42 + O,o 67 +� 19 o 26 +1 44 47 + 006 1 2 5 1 .6 4, 41 000 /00 -� L -*L-rfi�r 002 Run Date: 1112/2021 1:0( G/L Date: 10/31/2021 00-o., 0 -e 00 006 Page: 6 User Logon: CAS General Ledger Detail Report Summary Report for Period 10 Ending 10131/2021 HOUSING AUTHORITY OF GRANT COUNTY (GCH) PROJECT 05 - Account Number/Description Beg Balance Debit Credit Net Change End Balance 471504-7-05 HAP PAYMNTS UTILITIES CHG-0,' 300.00 0.00 0.00 0.00 300.00 PROJECT 05 - Total: 300.00 0.00 0.00 0.00' 300.00 Run Date: 111212021 1:06:54PM Page: 4 GIL Date: 1013112021 User Logon: CAS CHG - OCTOBER 2021 471501-7-04 HAP PAYMENTS RENT - CHG B65DA91DO Rental Assistance: Rental Assistance 10/01/2021$ 750.00 6AA7C88C5 Rental Assistance: Rental Assistance 10/01/2021 $685.00 578A2F185 Rental Assistance: Rental Assistance 10/01/2021 $550.00 A915EO63B Rental Assistance: Rental Assistance 10/01/2021 $700.00 Al D548FCE Rental Assistance: Rental Assistance 10/01/2021$300.00 EOFIOBFOB Rental Assistance: Rental Assistance 10/01/2021 $482.00 26E133127 Rental Assistance: Rental Assistance 10/01/2021 $641.00 DE1A84897 Rental Assistance: Rental Assistance 10/01/2021$411.29 E9183AOAB Rental Assistance: Rental Assistance 10/06/2021 $136.70 E19320634 Rental Assistance: Rental Assistance 10/01/2021 $700.00 2933734D5 Rental Assistance: Rental Assistance 10/01/2021 $1,002.00 FF23EBOEA Rental Assistance: Rental Assistance 10/21/2021 $425.80 5EI013295 Rental Assistance: Rental Assistance 10/21/2021 $171.03 CE5456CO8 Rental Assistance: Rental Assistance 10/05/2021 $872.64 $7,827.46 471501-7-09 HAP PAYMENTS RENT - HEN CA8472172 HEN Rent Assistance: HEN Rent Assistance 10/01/2021 $300.00 CAD7866A2 HEN Rent Assistance: HEN Rent Assistance 10/01/2021 $525.00 D3731DO14 HEN Rent Assistance: HEN Rent Assistance Issistance 10/01112021 $650.00 F350F8A2A HEN Rent Assistance: HEN Rent Assistance 10/01/2021 $550.00 C413CA126F HEN Rent Assistance: HEN Rent Assistance 10/01/2021 $425.00 410E07E70 HEN Rent Assistance: HEN Rent Assistance 10/01/2021 $1,086.00 E59AAEAF9 HEN Rent Assistance: HEN Rent Assistance 10/01/2021 $440.00 8D071A4A1 HEN Rent Assistance: HEN Rent Assistance 10/01/2021 $600.00 1BOB90DAF HEN Rent Assistance: HEN Rent Assistance 10/01/2021 $525.00 B3580BCEA HEN Rent Assistance: HEN Rent Assistance 10/01/2021 $595.00 4CBD53486 HEN Rent Assistance: HEN Rent Assistance 10/01/2021 $575.00 A585CABF1 HEN Rent Assistance: HEN Rent Assistance 10/01/2021 $400.00 7401303F51D HEN Rent Assistance: HEN Rent Assistance 10/01/2021 $675.00 551 CAEI 22 HEN Rent Assistance: HEN Rent Assistance 10/01/2021 $350.00 542299D613 HEN Rent Assistance: HEN Rent Assistance 10/01/2021$675.00 $500.00 3B753E8EO HEN Rent Assistance: HEN Rent Assistance 10/01/2021 $595.00 008962DOF HEN Rent Assistance: HEN Rent Assistance 10/01/2021 $625.00 6CD6E5AFA HEN Rent Assistance: HEN Rent Assistance 10/01/2021 $515.00 532B35FCB HEN Rent Assistance: HEN Rent Assistance 10/01/2021 $400.00 427C2B5BF HEN Rent Assistance: HEN Rent Assistance 10/01/2021 $700.00 3C1347377 HEN Rent Assistance: HEN Rent Assistance 10/01/2021 $425.00 99CFE2OF4 HEN Rent Assistance: HEN Rent Assistance 10/01/2021 $300.00 5F3227409 HEN Rent Assistance: HEN Rent Assistance 10/01/2021 $400.00 24D9AD65C HEN Rent Assistance: HEN Rent Assistance 10/01/2021 $555.00 28B9DDED7 HEN Rent Assistance: HEN Rent Assistance 10/01/2021 $400.00 1DOCDDFOD HEN Rent Assistance: HEN Rent Assistance 10/01/2021 $300.00 BF11A77AB HEN Rent Assistance: HEN Rent Assistance 10/01/2021 $500.00 BF11A77AB HEN Rent Assistance: HEN Rent Assistance 10/01/2021 $233.33 BBAF1DB7C HEN Rent Assistance: HEN Rent Assistance 10/15/2021$219.35 362843CEC HEN Rent Assistance: HEN Rent Assistance 10/01/2021$400.00 $14,938.68 471506-7-04 RENT DEPOSITS - CHG 'DE1A84897 Security Deposit: Security Deposit 10/01/2021 $500.00 E9183AOAB Security Deposit: Security Deposit 10/06/2021 $300.00 2933734D5 Security Deposit: Security Deposit 10/01/2021 $350.00 FF23EBOEA Security Deposit: Security Deposit 10/21/2021 $1.,200.00 CE5456CO8 Security Deposit: Security Deposit 10/05/2021 $1,002.00 5EI013295 Security Deposit: Security Deposit 10/21/2021 $500.00 $3,852.00 471506-7-09 RENT DEPOSITS - HEN BFllA77AB HEN Security Deposit Payment: HEN Security Deposit Payment 10/01/2021 $400.00 BBAF1DB7C HEN Security Deposit Payment: HEN Security Deposit Payment 10/15/2021 $400.00 $800.00 General Ledger Detail Report Detail Postings for Period 10 Ending 10/31/2021 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 97,247.90 10 10/5/2021 AP -003969 750.00 0.00 97,997.90 10 1015/2021 AP -003969 685.00 0.00 98,682.90 10 10/5/2021 AP -003969 550.00 0.00 99,232.90 10 10/5/2021 AP -003969 700.00 0.00 99,932.90 10 10/5/2021 AP -003969 300.00 0.00 100,232.90 10 10/6/2021 AP -003970 482.00 0.00 100,714.90 10 1016/2021 AP -003970 641.00 0.00 101,355.90 10 10/11/2021 AP -003973 411.29 0.00 101,767.19 10 10/19/2021 AP -003979 136.70 0.00 101,903.89 10 10/19/2021 AP -003979 700.00 0.00 102,603.89 10 10/21/2021 AP -003982 11002.00 0.00 103,605.89 1 0 10/26/2021 AP -003984 425.80 0.00 104,031.69 10 10/28/2021 AP -003989 171.03 0.00 104,202.72 10 10/28/2021 AP -003989 872.64 0.00 105j075.36 97,247.90 71827.46 0.00 7,827.46 105,075.36 471501-7-09 HAP PAYMENTS RENT HEN-CHG 114,046.46 10 10/5/2021 AP -003969 300.00 0.00 114,346.46 10 10/5/2021 AP -003969 525.00 0.00 114,871.46 10 10/5/2021 AP -003969 650.00 0.00 116,621.46 10 10/5/2021 AP -003969 550.00 0.00 116,071.46 10 10/5/2021 AP -003969 426.00 0.00 116,496.46 10 10/5/2021 AP -003969 1,086.00 0.00 117,582.46 10 10/5/2021 AP -003969 440.00 0.00 118,022.46 10 10/5/2021 AP -003969 600.00 0.00 1181622.46 10 10/5/2021 AP -003969 525.00 0.00 119,147,46 10 10/5/2021 AP -003969 595.00 0.00 119,742.46 10 10/5/2021 AP -003969 575.00 0.00 120,317.46 10 10/5/2021 AP -003969 400.00 0.00 120,717.46 10 1015/2021 AP -003969 675.00 0.00 121,392.46 10 10/5/2021 AP -003969 350.00 0.00 121,742.46 10 10/5/2021 AP -003969 675.00 0.00 1223417.46 10 10/5/2021 AP -003969 595.00 0.00 1231012.46 10 10/5/2021 AP -003969 625.00 0.00 123,637.46 10 10/5/2021 AP ' -003969 516.00 0.00 124,152.46 10 10/5/2021 AP -003969 400.00 0.00 124,552.46 10 10/5/2021 AP -003969 700.00 0.00 125,252.46 10 10/5/2021 AP -003969 425.00 0.00 125,677.46 10 10/5/2021 AP -003969 300.00 0.00 125,977.46 10 10/5/2021 AP -003969 400.00 0.00 126,377.46 10 10/5/2021 AP -003969 555.00 0.00 126,932.46 10 10/5/2021 AP -003969 400.00 0.00 127,332.46 10 10/11/2021 AP -003973 300.00 0.00 127,632.46 10 10/19/2021 AP -003979 500.00 0.00 128,132.46 10 10/19/2021 AP -003979 233.33 0.00 128,365.79 10 10/21/2021 AP -003982 219.35 0.00 128,585.14 10 10121/2021 AP -003982 400.00 0.00 128,985.14 114,046.46 14,938.68 0.00 14,938.68 128,985.14 Account Number/Description Period Date Journal Comments Beg Balance Debit Credit Net Change End Balance 471502-7-04 HAP PAYMNT PROJECT LEASE CC 31,968.00 10 10/5/2021 AP -003969 000100235 /IN: 1004100521 581.00 0.00 32,549.00 10 10/5/2021 AP -003969 000 100235 AN: 1006100521 581.00 0.00 33,130.00 10 10/5/2021 AP -003969 000100235 AN: 1008100521 614.00 0.00 33,744.00 10 10/5/2021 AP -003969 000100235 /IN: 1010100521 614.00 0.00 34,358.00 10 10/5/2021 AP -003969 000100235 /IN: 1102100521 581.00 0.00 34,939.00 10 10/5/2021 AP -003969 000100235 /IN: 1104100521 581.00 0.00 35,520.00 31,968.00 3,552.00 0.00 3,552.00 35,520.00 471504-7-05 HAP PAYMNTS UTILITIES CHG-05 300.00 0.00 0.00 300.00 300.00 0.00 0.00 0.00 300.00 471506-7-04 RENT DEPOSITS-CHG 21,497.00 10 10/11/2021 AP -003973 500.00 0.00 21, 997.00 10 10/19/2021 AP -003979 300.00 0.00 22,297.00 10 10/21/2021 AP -003982 350.00 0.00 22,647.00 10 10/26/2021 AP -003984 1,200.00 0.00 23,847.00 10 10/28/2021 AP -003989 500.00 0.00 24,347.00 10 10/28/2021 AP -003989 1,002.00 0.00 25,349.00 21,497.00 31852.00 0.00 3,852.00 25,349.05- 471506-7-09 RENT DEPOSITS HEN-CHG 5,315.00 10 10/19/2021 AP -003979 400.00 0.00 5,715.00 10 10/21/2021 AP -003982 400.00 0.00 6,115.00 5,315.00 800.00 0.00 800.00 6,115.00 471508-7-04 MOTEL VOUCHERS -CHG 10,701.40 0.00 0.00 10, 701.40 10,701.40 0.00 0.00 0,00 10,701.40 Report Total: 281,075.76 30,970.14 0.00 30,970.14 312,045.90 Run Date: 11/2/2021 9:19:04AM Page. 2 G/L Date: 111212021 User Logon: SAB Grantee Name: Grant County Lead Grantee List Sub Grantee Names Below Total Report Month/Year: OCTOBER 2021 HAGC ia ��:. 4.8.0nAdmi ..,$2,27480 CHG- . Other Rent Fac Supp Lease & -Ho usin $0.00 Costs !, $0.00 CHG\,Base F�uneding; CHG-Rent & Fac support/Lease Costs 15.,231$.46 5, 2,3�1 46 — W-0- \ \ v \ \3\ •':-.: ` . f 3 38 _. SH CHF �, S u .;. ,, rt' Leas . . , � r _ _ ... �,�;. ,0.'00, _ r . $000 C en S 0 0.0 s: t SHC PS H RE� FA . 0.00 CHF ton 00 �, . S,tysr•C•Sa.. ��...s:a2?-a.-�cx.c s• .x• X � Z;h',7 � :,... rc' .. Y � a � -x x ..r.. T\k� > . >r. r ..F.. i\. ,y..� . ,. � SSM �,. -•:w .J� . . .,.s.--..�. .� � led SUPP/ 8065164,V -1 $0.00 &HOUSINGCOSTS 2 $15,738 6 $ 4 1.6 OHEN� � 7 iJ3 q, $0.00 � � I $0.00 a a - $0.00 Invoice Total: $43,067.52