HomeMy WebLinkAboutGrant Related - BOCC (004)`\I \S
r
V-
f
. . . . . . . . . . . .
www.hage.net
January 3, 2022
(,,AJ CA - dVX-
Housin AuthoriTyGrantg County
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
Grant County Board of Commissioners
ATTN: Janice Flynn
Po Box 37/35 C Street
Ephrata, WA 98523
Dear Ms. Flynn:
Dated this �� --. day of �� � , 20_--X�Ll
Board 'of County Com -t-ri issioners
Grant Col ntv 5) ,-S2H1(yton
Anp _ 1N.,e FAS'a Or'.o e Abstain
Dist #I Dist #I
d _Dist .fid
1 Dist 113 Dist 43 Dist #3
Please consider this letter and attached documentation the Housing Authority's claim for draw #6 for
December, 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 $44,920.47
is a true and accurate report and that all reported expenditures are properly chargeable to the CHG
grant.
Sincerely,
C��.4 CA ...
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 reques4 so that they may fully access and utilize the housingprograms and related services.
OPPORTUNITY If you or anyone in your family is a person with disabilities, and you require a speck accommodation in order to fully utilize our programs and services, please contact the HousingAuthority.
Grant County/GCHA
Contract #22-fw�vlJOICHG) Submitted to GC by:
HAGC 6�4. � U �
Date: 1 IS (A 4 g. I
Request for Reimbursement No. #6
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?
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
Grantee Name : Grant County ILead Grantee list Sub Grantee Names Below Total
Report Month/Year: DECEMBER 2021 HAGC
CHG Voucher Detail Worksheet
Grantee Name: Grant County Lead Grantee List Sub Grantee Names Below
Report Month/Year: DECEMBER 2021 HAGC Jul -21 Aug -21 Sep -21 Oct -21 Nov -21 Dec -21 Jan -22
BUDGET DRAW #1 DRAW #2 DRAW #3 DRAW #4 DRAW #5 DRAW #6 DRAW #7
$798.07 $512.37 $837.77 $2,274.80 $1,911.81 $630.55
$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
$8,250.57
$3,951.70
$5,480.61
$5,433.38
$5,949.24
$9,591.74
$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
$14,613.19
$13,891.00
$16,848.25
$15,738.68
$15,966.00
$18,611.00
$5,643.50
$2,972.96
$4,390.12
$4,137.56
$4,040.96
$4,700.58
$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
Feb -22 Mar -22 Apr -22 May -22 Jun -22 TOTAL OF BALANCE
DRAW #8 DRAW #9 DRAW #10 DRAW #11 DRAW #12 DRAWS REMAINING
$6,965.37 $62,984.63
$0.00 $5,000.00
$76,668.59 $139,870.41
$38,657.24 $136,342.76
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$902.03 $24,097.97
$95,668.12 $166,284.88
$25,885.68 $48,114.32
$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 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $244,747.03 $943,647.97
$1,188,395.00
General Ledger Detail Report
Summary Report for Period
12 Ending 1213112021
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
21052.20
427.78
0.00
427.78
2,479.98
417001-7-01
ADMIN FEES -GRANT GO-CHG
11500.00
0.00
0.00
0,00
11500.00
418200-7-01
ADMIN FICA-CHG
149.98
31.45
0.00
31.45
181.43*
418201-7-01
ADMIN SUTA-CHG
23.20
0.69
0.00
0.69
23.89
418202-7-01
ADMIN L&I-CHG
9.83
2.16
0.00
2.16
11.99
418204-7-01
ADMIN RETIREMENT:CHG
265.36
51.70
0.00
51.70
317.06
418205-7-01
ADMIN MED/DENTNIS/L:CHG
591.04
105.77
0.00
105.77
696.81
4190127-01
MEMBERSHIP DUES & FE-CHG
500.00
0.00
0.00
0.00
500.00
419018-7-01
POSTAGE:CHG
111.91
11.00
0.00
11.00
122.91
441000-7-01
MAINTENANCE SALARIES:CHG
51270.98
0.00
0.00
0.00
51270.98
443300-7-01
MAINT FICA:CHG
394.49
0.00
0.00
0.00
394.49
443301-7-01
MAINT SUTA:CHG
77.08
0.00
0.00
0.00
77.08
443302-7-01
MAINT L&I:CHG
250.52
0.00
0.00
0.00
250-52
4433047-01
MAINT RETIREMENT:CHG
630.20
0.00
0.00
0.00
630.20
443305-7-01
MAINT MED/DENTNIS/L:CHG
982.99
0.00
0.00
0.00
982.99
PROJECT 01 -Total:
12,809.78
630.55
0.00
630.55V
13,440.33
Run Date: 1/3/2022 10:53:26AM Page: I
GIL Date: 12131/2021 User Logon-. CAS-
General Ledger Detail Report
Summary Report for Period 12 Ending 12/3112021
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
44,736.96
61521.65
0.00
6,521.65
51,258.61
418200-7-02
ADMIN FICA FACILITY SUPP & W
3,293.92
481.89
0.00
481.89
31775.81
418201-7-02
ADMIN SUTA FACILITY SUPP & R
579.35
72.49
0.00
72.49
651.84
418202-7-02
ADMIN L&I FACILITY SUPP & RA (
248.98
38.68
0.00
38.68
287.66
418204-7-02
ADMIN RETIREMENT FACILITY S1
61288.61
570.14
0.00
570.14
61858.75
418205-7-02
ADMIN MEDIDENTNIS/L FACILIT"
15,586.77
11767.98
0.00
11767.98
17,354.75
443000-7-02
CONTRCT SVC MAI NT FACILITY,'
906.64
138.91
0.00
1,045.55
PROJECT 02 - Total:
71,641.23
91591.74
0.00r
9,591.74
81,232.97'"
Run Date: 1/3/2022 10:63:26AM Page: 2
G/L Date: 1213112021 User Logon: CAS
General Ledger Detail Report
Summary Report for Period 12 Ending 12/3112021
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
111,907.69
7,398.80
0.00
71398.80
119,306.49
471502-7-04
HAP PAYMNT PROJECT LEASE C
39,072.00
31552,00
0.00
31552.00
42,624.00
471506-7-04
RENT DEPOSITS-CHG
26,374.00
350.00
0.00
350.00
26,724.00
471508-7-04
MOTEL VOUCHERS -CHG
10,701.40
0.00
0.00
— —&10
10,701-40
PROJECT 04 - Total:
188,055.09
11,300.80
0.00
11,300.80
199,355.89'
Run Date: 113/2022 10:634.25AM Page: 3
G/L Date: 1213112021 User Logon: CAS
General Ledger Detail Report
Summary Report for Period 12 Ending 12/3112021
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.1 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: 1/3/2022 10:63:25AM Page: 4
G/L Date: 12/31/2021 User Logon: CAS
General Ledger Detail Report
Summary Report for Period 12 Ending 1213112021
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
311054-03
41089.31
0.00
4,089.31
35,143-34
418200-7-08
ADMIN FICA-HEN-OPS-CHG
11735.38
232.67
0.00
232.67
1,968.05
418201-7-08
ADMIN SUTA HEN-OPS-CHG
288.31
34.61
0.00
34.61
322.92
418202-7-08
ADMIN L&I HEN-OPS-CHG
134.68
18.65
0.00
18.65
153.33
418204-7-08
ADMIN RETIREMENT HEN -OPS -C
21897.77
325.02
0.00
325-02
31222.79
418205-7-08
ADMIN MED/DENTNIS/L HEN -OP,'
1.78
0.32
0.00
0-.���
2.10
PROJECT 08 - Total:
36,111.95
41700.58
0.0
41700.58
40,812.53
Lf
Run Date: 1/312022 10:63:26AM Page: 6
G/L Date: 12/3112021 User Logon: CAS
General Ledger Detail Report
Summary Report for Period 12 Ending 12131/2021
HOUSING AUTHORITY OF GRANT COUNTY (GCH)
PROJECT 09 -
0 v 0
4-
Account Number/Description
Beg Balance
Debit
Credit
Net Change
End Balance
411000-7-09
ADMIN SALRIES HEN-CHG
11428.07
53.47
0.00
53.47 1,481.54
11481-54
4182007-09
ADMIN FICA HEN- CHG
107.06
4.03
0,00
4.03
111.09
418201-7-09
ADMIN SUTA HEN-CHG
18.80
0.00
0.00
0.00
18.80
418202-7-09
ADMIN L&I HEN-CHG
6.44
0.27
0.00
0.27
6.71
418204-7-09
ADMIN RETIREMENT HEN-CHG
212.27
9.37
0.00
9.37
'* 37
221.64
418205-7-09
ADMIN MED/DENTIVISIL HEN-CHi
400.89
18.66
0.00
18.66
18.66
419-55
471501-7-09
HAP PAYMENTS RENT HEN-CHG
144,951.14
17,661.00
0.00
17,661.00
C!4
1 621612.14
471506-7-09
RENT DEPOSITS HEN-CHG
61115.00
950.00
0.00
950.0
71065.00
PROJECT 09 - Total:
153,239.67
18,696.80
0.00
18,696.80
171,936-47
Report Total:
462,157.72
44,920.47
0.00
44,920.47
507,078--.19
milt
7 6 6 1 0
950 0 +
002
8 6 1 1 0
Run Date: 1/312022 10:63:25AM Page: 6
GIL Date: 12/31/2021 User Logon: CAS
0 v 0
4-
5 3 7 +
0 3
9 o 37 +
18o66,+
630055
0 .05
9 5 9 1
NIV
8m� .
I'D 10 +
7 0 0
5 80 +
18 6 1 1 00 +
00.6
9 2 0
41 r
� b�LT� i��y�A�
{
000
0 0 0
7 6 6 1 0
950 0 +
002
8 6 1 1 0
Run Date: 1/312022 10:63:25AM Page: 6
GIL Date: 12/31/2021 User Logon: CAS