HomeMy WebLinkAboutGrant Related - BOCC (003)Vj av 14V,
-V� `-� Housing Authority of Grant Coun
Nh 1139 Larson Blvd. •Moses Lake, WA 98837-3308
ty
Phone: (509) 762-5541 •Fax: (509) 762-2202
Toll Free: (800) 747-9202 • 'T'TY: (800) 833-6388
www.hagc.net
Dated this -__ day of ��20
December 6, 2021 Board ofC County C'ommissionc;rs'
Grant County Board of Commissioners
ATTN:Janice Flynn
PO Box 37/35 C Street
Ephrata, WA 98823
Dear Ms. Flynn:
Grant County. Washington
r Usa.rove_ Abstain
Dist # I Dist #I Dist #I
Dist #2` Dist #? gist #2
u
List #3 Dist #3 --------
..... . . Dist#3
Please consider this letter and attached documentation the Housing Authority's claim for draw #8 for
November, 2021, for the ESG-CV Program, I certify that:
The information on the A-19 and supporting documentation for the ESG-CV Program (ESG), contract #
20-46130-100, in the amount of $974.81 is a true and accurate report and that
all reported expenditures are properly chargeable to the ESG grant.
Sincerely,
ct,-t� a_ Azul�-,
Christopher A. Sutherland
Financial Director
� >3
B
u
DEC— 6 2021 F
:] 1.
j.:
I� The HousingAuthority 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
1rr
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.
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 Housing Authority.
Grant County/GCHA
Contract # 20-461,AC-1 00 (ESG) Submitted to GC by:
HAGC 1; 0,44 _
Date: 17-1 �1 Z 0-7-W
Request for Reimbursement No, #8
Grant County's Subreciplent 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? (Le., was the dollar amount charged to the program
relative to the benefits received by the program? Is the federalgrantor 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?
HAACCOUNTINGTOTUSTOTUSTSG GRANMSG Subrecipient Checklist.docx Page 1
Total
Grantee Name: Lead Grantee Ust Sub Grantee Names Below T(
Report Month/Year: GRANTCOUNTY
HA OF GRANT COUNTY
R 11 f1r. F7 -CM . Ai�7
.. .. . .........
NO
Ri zwr�;i;w
llif� q n6
H
Zrit'. v�:`
Street Outreach
'000'
.00
Outreach Essential Services
Hazard Pay (unique acf[vi
ty
Handwashing staftons/portable bathroo mis activity
Volunteer Incontives (uniquetictivito
Training (unique activity)
Subfdtal We& Outreach'
I47
iii p Uq
TIP Ti-
M.Mergqpty,*� e
.............
hd t pera
. ....... . .
H
14 T "In un
qq
t.'a ing-, e::�
h.. ........... . .
in' 1 . .............. .
... ......... ......
. ... ...... ...
.... .. .... .. . .... . ...... . ... ................ . . . ....... . .......
........ . ..... .
............ ................
.. .... ........ .. ..... ......
.... . ... .. ... ... ..... ...... -- ------ ............ ..
. . ..........
$
-d' bt!�
.... ... . .....
K. s.e:i a ijag
tj
aza ...... ......
re 1:Pay ....nlq pg ........ . ..
.. .... .... .. ... ... ........
......... .
geht1V t,7
Y.)
h . ....... . ...... . ............ . ...... ........ . ......... .. .. .......
. .... .. . .... ......... . ...
V ................ .....
q p n ..... ....... V . ... ...
s
..... .. . .... ......
. .... .... .... .. .. .......... ... . ............ ..... .
. .. ..... ..
. ... . ...... Tf iningitunique-pd, _7:
....... . ........ ...
.... . ...... ...
...........
.. ... .. ...... A
..... ......
ssis anq
�R rita ;?A
Pe6v.driti6h, e
er:, an
c
....... . ..
'C
-aseW... ge�M' i ri c-,
ana
.PLP1:4l in .. ......... .
H! azar unL[q
or "Ificent y stipp q
u La i e
mip y
r
q ... ........
n
g, vniqu:,ac
e e snessI.0i6ighi,16111,
�)U.uu :�Uxu -)U.UU ;�z/0"+00.vu ?U.uu T?_7 1 -t.0-L ?Lf-uu
Invoice Total:
Grantee Name:
Report Month/Year:
Lead Grantee Total
GRANT COUNT HA OF GRANT COUNTY MONTH
BUDGET November -21
..- ...:: •:,. :;. .... . --•. .... » ..+' u- ..3, ,.. .. ...,
? 0.00
Admin $
HMIS $20,000.00. : $0.00
Training (unique activity) $0.00
Street Outreach
Outreach Essential Services $20,000.00 $0.00
Hazard Pay (unique activity) : $0.00
Handwashing stations/portable bathrooms (unique activity) $0.00
Volunteer Incentives (unique activity) $0.00
Trainin (unique activity) $0.00
Subtotal Street Outreach $0:00
Permanent Emer en" Shelter:
TOTAL OF BALANCE
Apr -21 May -21 Jun -21 Jul -21 Aug -21 Sep -21 Oct -21 Nov -21 Dec -21 Jan -22 DRAWS REMAINING
DRAW #1 DRAW #2 DRAW# 3 DRAW #3 DRAW #4 DRAW# 4 DRAW #5 DRAW #6 DRAW# 5 DRAW #7
02
56.18 130.37 79.81
15
1783.97 104.57 60.08 $2214.98 $ ,785.
$0.00 $20,000.00
1109.8 1914 1645 895 895 895 895
1637.12 $2,942.50 .,$2,234.00 $3,046.70 , $2,770.00 .`$2,045.00 $1,431.00:
I_._ I 1
$0.00 $278,466.00 $0.00 50.00
$0.00 $1,637.12 $4,052.30 $5,931.97 $4,796.27 $3,725.08 $2,996.18 $2,456.37 $974.81
$0.00 $20,000.00
$0.00 $45,000.00
$0.00 $80,000.00
$8,248.80 $32,217.20
$0.00 $5,000.00
$0.00 $20,000.00
$16,106.32 $3,893.68
$0.00 $5,000.00
$0.00 $5,000.00
$278,466.00
$26,570.10 $530,361.90
C
Shelter, Case Mana ement: includin CE ? ;,> p :: $45'000'00
$0.00
Shelter0 erations xz� t �•, $80;000.00`
$000
Renovation
$0:00
Nla or_RehabiUtation :r. ;,,•
:$0:00
Conversion.
$0.00
Nazatd Pa uni `ue.activit �'
0.00
Volunteeranientives uni ue activit ;: ` ",� ? ?` a : ° _ 5;
$0.00
`framin
$0.00
Subtotal:Permanent Einer en Shelter
$0.00
Temporary Emergen
Shelter
Shelter Case Management including CE)
$0.00
Shelter Operations
$0.00
Leasing existing real property or temporary structures
$0.00
Acquisition
$0:00
Renovation
;$0.00
Hazard Pa (unique activity)
$0.00
Volunteer Incentives (unique activity),$0.00
Training(unique activity)$0.00
Other Shelter Costs .
$0.00
Subtotal Temporary Emergency Shelter
$0.00
Rapid Rehousing
RRH Rental Assistance $40,466.00. : ;
$0:00
RRH Other Financial Assistance* $5,000.00
$0.00
RRH Case Management (including CE) $20,000.00.
G $0.00
Hazard Pa unique activity)
"--$0.00
Landlord incentives (unique activity)
$0.00
Volunteer Incentives unique activity)
$0.00
Training (unique activity)
$0.00
Homeless Prevention :
$0.00
Subtotal Rapid Rehousing :
$0.00
Homelessness Prevention
Prevention Rental Assistance:. $20,000.00 w
$0.00
Prevention' Other financial Assistance* $51000.00
$0.00
Prevention Case Management including CE)::; . $5,000.00.
$0.00
Hazard Pa unique activity)
$0.00
Landlord Incentives (unique activity)
$0.00
Volunteer Incentives (unique activity).
Trainingunique activity)$000
Subtotal Homelessness Prevention _
$0.0 0
TOTAL OF BALANCE
Apr -21 May -21 Jun -21 Jul -21 Aug -21 Sep -21 Oct -21 Nov -21 Dec -21 Jan -22 DRAWS REMAINING
DRAW #1 DRAW #2 DRAW# 3 DRAW #3 DRAW #4 DRAW# 4 DRAW #5 DRAW #6 DRAW# 5 DRAW #7
02
56.18 130.37 79.81
15
1783.97 104.57 60.08 $2214.98 $ ,785.
$0.00 $20,000.00
1109.8 1914 1645 895 895 895 895
1637.12 $2,942.50 .,$2,234.00 $3,046.70 , $2,770.00 .`$2,045.00 $1,431.00:
I_._ I 1
$0.00 $278,466.00 $0.00 50.00
$0.00 $1,637.12 $4,052.30 $5,931.97 $4,796.27 $3,725.08 $2,996.18 $2,456.37 $974.81
$0.00 $20,000.00
$0.00 $45,000.00
$0.00 $80,000.00
$8,248.80 $32,217.20
$0.00 $5,000.00
$0.00 $20,000.00
$16,106.32 $3,893.68
$0.00 $5,000.00
$0.00 $5,000.00
$278,466.00
$26,570.10 $530,361.90
General Ledger Detail Report
Summary Report for Period 11 Ending 11/30/2021
HOUSING AUTHORITY OF GRANT COUNTY (GCH)
PROJECT 01 -
Account Number/Description
Beg Balance
Debit
Credit
Net Change
End Balance
401000-9-01
MGMT SALARIES - ESG
156.57
0.00
0.00
0.00
156.57
408200-9-01
MGMT FiCA:ESG Grant -01
11.76
0.00
0.00
0.00
11.76
408201-9-01
MGMT SUTA:ESG Grant -01
1.78
0.00
0.00
0.00
1.78
4082029-01
MGMT L&I:ESG Grant -01
0.39
0.00
0.00
0.00
0.39
408204-9-01
MGMT RETIREMENT:ESG Grant -C
14.03
0.00
0.00
0.00
14.03
408205-9-01
MGMT MED/DENTNIS/LI:ESG GrE
25.93
0.00
0.00
0.00
25.93
4110009-01
ADMIN SALARIES-ESG Grant
278.75
56.27
0.00
56.27
335.02
417001-9-01
ADMIN FEES -GRANT CO-ESG Grp
1,500.00
0.00
0.00
0.00
1,500.00
418200-9-01
ADMIN FICA-ESG Grant
20.80
4.22
0.00
4.22
25.02
418201-9-01
ADMIN SUTA-ESG Grant
3.05
0.00
0.00
0.00
3.05
418202-9-01
ADMIN L&I-ESG Grant
1.27
0.20
0.00
0.20
1.47
418204-9-01
ADMIN RETIREMENT-ESG Grant
38.66
6.24
0.00
6.24
44.90
418205-9-01
ADMIN MED/DENTNIS/L-ESG Gra
82.18
12.88
0.00
12.88
95.06
PROJECT 01 - Total:
21135.17
79.81
0.00
79.81
21214.98
Run Date: 12/6/2021 12:27:OOPM Page: I
GIL Date: 1113012021 User Logon: CAS
General Ledger Detail Report
Summary Report for Period 11 Ending 11/30/2021
HOUSING AUTHORITY OF GRANT COUNTY (GCH)
PROJECT 07 -
Account Number/Description Beg Balance Debit Credit Net Change End Balance
471501-9-07
471506-9-07
HAP PAYMENTS RENT RR'ESG C
6,808.80
RENT RR DEPOSITS:ESG Grant -0
1,545.00
PROJECT 07 - Total:
71353.80
895.00 0.00 895.00 6,703.80
0.00 0.00 0.00 1,545.00
895.00 0.00 895.00 81248,80
Run Date: 1216/2021 12:27:OOPM Page: 2
GIL Date: 11/30/2021 User Logon: CAS
General Ledger Detail Report
Summary Report for Period I I Ending 11/3012021
000
0 0 0 0
79 81 +
8 9 5 0
0-02
97-4*81
Run Date: 121612021 12:27:0013M
GIL Date: 11130/2021
Page: 3
User Logon: CAS
HOUSING AUTHORITY OF GRANT COUNTY (GCH)
PROJECT 10 -
Account Number/Description
Beg Balance
Debit Credit
Net Change
End Balance
471501-9-10
PREVENTION HAP PAYMENTS R1
13,842.32
0.00 0.00
0.00
13,842.32
471506-9-10
PREVENTION RENT DEPOSITS:E
21264.00
0.00 0.00
0.00
2,264.00
PROJECT 10 - Total:
16,106.32
0.00 0.00
0.00
16,106.32
Report Total:
25,595,29
974.81 0.00
974.81
26,570.10
000
0 0 0 0
79 81 +
8 9 5 0
0-02
97-4*81
Run Date: 121612021 12:27:0013M
GIL Date: 11130/2021
Page: 3
User Logon: CAS
General Ledger Detail Report
Detail Postings for Period 71 Ending 11/3012021
HOUSING AUTHORITY OF GRANT COUNTY (GCH)
Account Number/Description
Perio Date Journal
Comments
Beg Balance
Debit
Credit
Net Change
End Balance
471501-9-07
HAP PAYMENTS RENT RR:ESG Gr
5,808.80
11 11/1/2021 AP -003991
895.00
0.00
6,703.80
51808.80
895.00
0.00
895.00
6,703.80
471501-9-10
PREVENTION HAP PAYMENTS RE
13,842.32
0.00
0.00
13,842.32
13,842.32
0.00
0.00
0.00
13$842.32
471506-9-07
RENT RR DEPOSITS:ESG Grant -07
11545.00
0.00
0.00
1,545.00
11545.00
0.00
0.00
0.00
1,545.00
471506-9-10
PREVENTION RENT DEPOSITS:E%"-" .
21264.00
0.00
0.00
21264.00
2,264.00
0.00
0.00
0.00
21264.00
Report Total:
23,460.12
895.00
0.00
895.00
24,355.12
Run Date: 1211/2021 11:44:14AM
Page: I
G/L Date: 12/112021
User Logon: SAB
HMIS Data Quality HA Grant County
Report [FY -2022] CoC Category Filter: Agency CoC
Date Range: 11/01/2021 thru 11/30/2021
Q1. Report Validation Table
Program Applicability: All Projects
Total number of persons served
5
Number of adults (age 18 or over)
1
Number of children (under age 18)
4
Number of persons with unknown age
0
Number of leavers
p
Number of adult leavers
0
Number of adult and head of household leavers
0
Number of stayers 5
Number of adult stayers 1
Number of veterans 0
Number of chronically homeless persons 0
Number of youth under age 25 0
Number of parenting youth under age 25 with children 0
Number of adult heads of household 1
Number of child and unknown -age heads of household 0
Heads of households and adult stayers in the project 365 days or more 0
1/8
Wed Dec 1 12:10:30 FSM 2021 Powered ByL A R IT
AV
O MAN SERVICES
HMIS Data Quality HA Grant County
Report [FY 2022] CoC Category Filter: Agency CoC
Date Range: 11/01/2021 thru 11/30/2021
Q1. Report Validation Table
Program Applicability: All Projects
Total number of persons served
3
Number of adults (age 18 or over)
2
Number of children (under age 18)
1
Number of persons with unknown age
0
Number of leavers
0
Number of adult leavers
0
Number of adult and head of household leavers
0
Number of stayers
3
Number of adult stayers
2
Number of veterans
0
Number of chronically homeless persons
0
Number of youth under age 25
2
Number of parenting youth under age 25 with children
2
Number of adult heads of household
1
Number of child and unknown -age heads of household
0
Heads of households and adult stayers in the project 365 days or more
0
1/8
Wed Dec 1 12:13:33 PM 2021
Powered ByLARITT
__3IL,MAN SERVICES