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