HomeMy WebLinkAboutGrant Related - BOCC (002)I
Yfopdource
700 E, Mountain View Ave
Suite 501
Ellensburg, WA 98926
Phone: 509-925-1448
Fax: 509-925-1204
0
rah�tl-
ERAR2.'
lGrant #
Program Period: 10/1/2021 - 6/30/2023
Award : $757,015 -1Remainin Bal: $165,668.83 9 .. ........ -- - - ------------ . . ......
For the Period
Nov 2022
HopeSource
............. ................... ................. -------------
ame: Ariam Mehtsentu
Signature:
Date; 14 -Dec -22
DEC 12 7 2022
..............
Grant County Courthouse
AttnJanice Flynn, Admin. Services Coordinate
P.O. Box 37
E2hrata, WA 98823-0037
700E. Mount nView Ave, Suite 501 Ellensburg, WA 98926 0 Phone (509) 925-1448 0 Fax (509)
Ll
Fc: -,i �? � ;, - "!f %
110 ennsylvanla Ave, Cle Elum, WA 98922 Phone (509) 674-2375 Fax (509) 674-5187 j
1 2022
TV f7 f
INVOICE
Envoice #
2022-11 ERAP-G
Date
12/1412022
Reference #
21-4619C-108
Contact Person
jAriam Mehtsentu
............. ................... ................. -------------
ame: Ariam Mehtsentu
Signature:
Date; 14 -Dec -22
DEC 12 7 2022
..............
Grant County Courthouse
AttnJanice Flynn, Admin. Services Coordinate
P.O. Box 37
E2hrata, WA 98823-0037
700E. Mount nView Ave, Suite 501 Ellensburg, WA 98926 0 Phone (509) 925-1448 0 Fax (509)
Ll
Fc: -,i �? � ;, - "!f %
110 ennsylvanla Ave, Cle Elum, WA 98922 Phone (509) 674-2375 Fax (509) 674-5187 j
1 2022
TV f7 f
Lead Grantee Name: I I List Sub Grantee Names Below ITotal
Report Week or Month/Year: I Noy -221 I I I I I I
Hope Source
Expanded General Ledger - BL- ERAP - Unposted Transactions Included In Report
625202110 - Eviction Rent Assistance- Grant- ERAP 2.0
From 11/1/2022 Through 11/30/2022
GL Divisi...
Code
GL Title
Session 1
7000
Salaries & Wages
2,168.45
7000
Salaries & Wages
JVA1530
7100
FICA & Medicare Expense
JVA1530
7101
Employee Tax
JVA1530
7105
Health Benefits
JVA1530
7106
Unemployment Insurance Exp
JVA1530
7107
L & I tax expense
JVA1530
7108
Other Benefits
JVA1530
8010
Professional Fees
JVA1530
8100
Office Supplies
JVA1530
8200
Communication Expense
JVA1530
8300
Postage & Shipping
JVA1530
8350
Dues & Subscriptions
JVA1530
8400
Rent - Space Lower County
JVA1530
8405
Utilities - Ellensburg
JVA1530
8406
Utilities - Upper
JVA1530
County/Offsite offices
8420
Repairs & Maintenance -
JVA1530
General
8450
Insurance Expense
JVA1530
8501
Computer hardware and
JVA1530
Software
8510
Program supplies and tools
JVA1530
8650
Photocopy Expense
JVA1530
8700
Travel Expense
JVA1530
8705
Conference Fees
JVA1530
8710
Meeting Exp
JVA1530
8990
Interest Expenses
JVA1530
8992
Bank Fee
JVA1530
8940 Rent Assistance
8940 Rent Assistance
8940 Rent Assistance
Date: 12/14/22 09:44:49 AM
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
Administration
Administration
Administration
Administration
Administration
Administration
Administration
Administration
Administration
Administration
Administration
Administration
Administration
Administration
Administration
Administration
Administration
Administration
Administration
Administration
Administration
Administration
Administration
Administration
Administration
Administration
Debit Credit
0.00
679.50
58.49
139.05
127.13
5.17
7.25
4.27
793.74
18.51
18.89
4.26
41.06
42.93
15.12
0.49
103.41
20.33
58.28
2.68
0.08
10.99
12.20
2.93
1 711
Sub
division
99999
99999
99999
99999
99999
99999
99999
99999
99999
99999
99999
99999
99999
99999
99999
99999
99999
99999
99999
99999
99999
99999
99999
99999
99999
99999
Opening Balar
2,168.45 0.00 Transaction Tc
Balan...
Administration
2,168.45
100
611
Direct Client Services
0.00 62067 Opening Balar
AP1042679 611
Direct Client Services
10,092.00 62067
AP1042564 611
Direct Client Services
1,982.50 62068
Page: 1
GL
Code GL Title
Hope Source
Expanded General Ledger - BL- ERAP - Unposted Transactions Included In Report
625202110 - Eviction Rent Assistance- Grant- ERAP 2.0
From 1111/2022 Through 11/30/2022
Divisi...
Session ID Code Division Title
Sub
division
rlohit ('rarlit ('_nrla
Direct Client Services
3,768.00
Direct Client Services
7,100.00
Direct Client Services
3,222.00
Direct Client Services
2,625.00
Direct Client Services
3,170.00
Direct Client Services
2,355.00
Direct Client Services
300.00
Direct Client Services
6,986.00
Direct Client Services
5,781.96
Direct Client Services
2)243.60
Direct Client Services
476.40
Direct Client Services
4,871.00
7101
54, 973.46 0.00
Direct Client Services
54,973.46
8940
Rent Assistance
AP1042571
611
7000
8940
Rent Assistance
AP1042786
611
Salaries & Wages
8940
Rent Assistance
AP1042856
611
7100
8940
Rent Assistance
AP1042573
611
FICA & Medicare Expense
8940
Rent Assistance
AP1042892
611
7101
8940
Rent Assistance
AP1042594
611
Employee Tax
8950
Utility Assistance
AP1042594
611
7105
8940
Rent Assistance
AP1042835
611
613
8940
Rent Assistance
AP1042789
611
Program Operations
8940
Rent Assistance
AP1042589
611
67.35
8950
Utility Assistance
AP1042589
611
71.71
8940
Rent Assistance
AP1042767
611
99999
7000 Salaries & Wages
7000
Salaries & Wages
7000
Salaries & Wages
7000
Salaries & Wages
7000
Salaries & Wages
7000
Salaries & Wages
7000
Salaries & Wages
7000
Salaries & Wages
7100
FICA & Medicare Expense
7100
FICA & Medicare Expense
7100
FICA & Medicare Expense
7100
FICA & Medicare Expense
7100
FICA & Medicare Expense
7101
Employee Tax
7101
Employee Tax
7101
Employee Tax
7101
Employee Tax
7101
Employee Tax
7105
Health Benefits
7105
Health Benefits
62350
62371
62427
62434
62514
62531
62531
62632
62785
62820
62820
62962
Program Operations
Balan...
611
Program Operations
613
AP 1043005
613
CDSPRO1328
613
CDSPRO1329
613
CDSPRO1330
613
CDSPRO1331
613
CDSPRO1333
613
CDSPRO1334
613
AP 1043005
613
CDSPRO1328
613
CDSPRO1329
613
CDSPRO1330
613
CDSPRO1331
613
AP 1043005
613
CDSPRO1328
613
CDSPRO1329
613
CDSPRO1330
613
CDSPRO1331
613
AP1043005
613
CDSPRO1328
613
62350
62371
62427
62434
62514
62531
62531
62632
62785
62820
62820
62962
Program Operations
0.00
99999
Program Operations
557.49
99999
Program Operations
1,600.93
224.74
99999
Program Operations
716.58
99999
Program Operations
1,340.84
168.11
99999
Program Operations
722.24
99999
Program Operations
104.17
99999
Program Operations
77.37
99999
Program Operations
49.15
99999
Program Operations
128.07
99999
Program Operations
67.31
99999
Program Operations
106.06
99999
Program Operations
67.35
99999
Program Operations
71.71
99999
Program Operations
224.74
99999
Program Operations
136.48
99999
Program Operations
168.11
99999
Program Operations
135.06
99999
Program Operations
130.34
99999
Program Operations
308.06
99999
Transaction Tc
Opening Balar
Date: 12/14/22 09:44:49 AM Page: 2
Hope Source
Expanded General Ledger - BL- ERAP - Unposted Transactions Included In Report
625202110 - Eviction Rent Assistance- Grant- ERAP 2.0
From 11/1/2022 Through 11/3012022
Date: 12/14/22 09:44:49 AM Page: 3
Sub
GL
Divisi...
division
Code
GL Title
Session ID
Code
Division Title
Debit Credit
Code
7105
Health Benefits
CDSPR01329
613
Program Operations
120.87
99999
7105
Health Benefits
CDSPRO1330
613
Program Operations
274.22
99999
7105
Health Benefits
CDSPRO1331
613
Program Operations
120.87
99999
7106
Unemployment Insurance Exp
AP1043005
613
Program Operations
5.54
99999
7106
Unemployment Insurance Exp
CDSPR01328
613
Program Operations
12.10
99999
7106
Unemployment Insurance Exp
CDSPR01329
613
Program Operations
7.85
99999
7106
Unemployment Insurance Exp
CDSPRO1330
613
Program Operations
11.39
99999
7106
Unemployment Insurance Exp
CDSPR01331
613
Program Operations
7.96
99999
7107
L & I tax expense
AP1043005
613
Program Operations
4.01
99999
7107
L & I tax expense
CDSPR01328
613
Program Operations
15.08
99999
7107
L & I tax expense
CDSPR01329
613
Program Operations
9.42
99999
7107
L & I tax expense
CDSPR01330
613
Program Operations
14.13
99999
7107
L & I tax expense
CDSPR01331
613
Program Operations
9.86
99999
7108
Other Benefits
CDSPR01328
613
Program Operations
0.88
99999
7108
Other Benefits
CDSPR01329
613
Program Operations
0.08
99999
7108
Other Benefits
CDSPR01330
613
Program Operations
0.24
99999
7108
Other Benefits
CDSPR01331
613
Program Operations
0.08
99999
6,508.40
1,211.09
Transaction Tc
Balan...
Program Operations
L5,297.31 --D
613
8010
Professional Fees
613001
Program Support - Pool
0.00
99999
Opening Balar
8010
Professional Fees
AP1042034
613001
Program Support - Pool
469.27
99999
8010
Professional Fees
AP1042425
613001
Program Support - Pool
7.30
99999
8010
Professional Fees
AP1042558
613001
Program Support - Pool
89.61
99999
8010
Professional Fees
AP1042562
613001
Program Support - Pool
72.97
169.11
99999
99999
+3.
8010
Professional Fees
AP1042563
613001
Program Support - Pool
g
�
8010
Professional Fees
AP1042599
613001
Program Support - Pool
908.95
1,082.33
99999
4� �1
8010
Professional Fees
AP1042631
613001
Program Support - Pool
32.50
99999
8010
8100
Professional Fees
Office Supplies
AP1042650
AP1042626
613001
613001
Program Support - Pool
Program Support - Pool
79.00
61.36
44.86
99999
99999
«
8100
Office Supplies
AP1042627
613001
Program Support - Pool
82.49
99999
8100
Office Supplies
AP1042650
613001
Program Support - Pool
49.23
27.96
99999
8200
Communication Expense
AP1042376
613001
Program Support - Pool
25.10
99999
8200
Communication Expense
AP1042403
613001
Program Support - Pool
1.88
99999
8200
Communication Expense
AP1042535
613001
Program Support - Pool
88.80
99999
Date: 12/14/22 09:44:49 AM Page: 3
Hope Source
Expanded General Ledger - BL- ERAP - Unposted Transactions Included In Report
625202110 - Eviction Rent Assistance- Grant- ERAP 2.0
From 11/1/2022 Through 11/30/2022
Page: 4
Sub
GL
Divisi...
division
Code
GL Title
Session ID
Code
Division Title
Debit
Credit
Code
8200
Communication Expense
AP1042599
613001
Program Support - Pool
43.74
52.08
99999
8200
Communication Expense
AP1042650
613001
Program Support - Pool
333.87
177.56
99999
8400
Rent - Space Lower County
AP1042314
613001
Program Support - Pool
379.51
99999
8400
Rent - Space Lower County
AP1042599
613001
Program Support - Pool
637.44
759.02
99999
8401
Rent - Space Upper County
AP1042599
613001
Program Support - Pool
30.29
99999
8405
Utilities - Ellensburg
AP1042534
613001
Program Support - Pool
24.59
99999
8405
Utilities - Ellensburg
AP1042599
613001
Program Support - Pool
58.40
69.53
99999
8405
Utilities - Ellensburg
AP1042601
613001
Program Support - Pool
24.26
99999
8406
Utilities - Upper
AP1042533
613001
Program Support - Pool
36.43
99999
County/Offsite offices
8406
Utilities - Upper
AP1042650
613001
Program Support - Pool
170.43
96.78
99999
County/Offsite offices
8406
Utilities - Upper
AP1042840
613001
Program Support - Pool
47.44
99999
County/Offsite offices
8420
Repairs & Maintenance -
AP1042424
613001
Program Support - Pool
20.34
99999
General
8420
Repairs & Maintenance -
AP1042437
613001
Program Support - Pool
5.56
99999
General
8420
Repairs & Maintenance -
AP1042510
613001
Program Support - Pool
12.96
99999
General
8420
Repairs & Maintenance -
AP1042590
613001
Program Support - Pool
212.17
99999
General
8420
Repairs & Maintenance -
AP1042599
613001
Program Support - Pool
15.86
18.87
99999
General
8420
Repairs & Maintenance -
AP1042600
613001
Program Support - Pool
0.51
99999
General
8420
Repairs & Maintenance -
AP1042629
613001
Program Support - Pool
65.84
99999
General
8420
Repairs & Maintenance -
AP1042650
613001
Program Support - Pool
432.27
245.47
99999
General
8420
Repairs & Maintenance -
AP1042808
613001
Program Support - Pool
14.86
99999
General
8420
Repairs & Maintenance -
AP1042832
613001
Program Support - Pool
29.05
99999
General
8420
Repairs & Maintenance -
AP1042883
613001
Program Support - Pool
49.18
99999
General
8420
Repairs & Maintenance -
AP1042911
613001
Program Support - Pool
23.87
99999
General
Date: 12/14/22 09:44:49 AM
Page: 4
GL
Code GL Title
8450
Insurance Expense
8450
Insurance Expense
8650
Photocopy Expense
8650
Photocopy Expense
8990
Interest Expenses
8990
Interest Expenses
Report
Opening/Current
Balance
Report Transaction
Totals
Report Current
Balances
Report Difference
Hope Source
Expanded General Ledger - BL- ERAP - Unposted Transactions Included In Report
625202110 - Eviction Rent Assistance- Grant- ERAP 2.0
From 11/1/2022 Through 11/30/2022
Balan... Program Support - Pool
613001
Balance 625202110 -
Eviction Rent
Assistance- Grant-
ERAP 2.0
Divisi...
Session ID
Code
Division Title
AP1042599
613001
Program Support - Pool
AP1042914
613001
Program Support - Pool
AP1042650
613001
Program Support - Pool
AP1042848
613001
Program Support - Pool
AP1042650
613001
Program Support - Pool
AP1042760
613001
Program Support - Pool
Balan... Program Support - Pool
613001
Balance 625202110 -
Eviction Rent
Assistance- Grant-
ERAP 2.0
5,578.30 21773.60
�D
C2,'8
65,243.92
0.00 0.00
69,228.61 3,984.69
RQ 77R R1 R QRA RQ
� 65.243.92
Transaction Tc
Date: 12/14/22 09:44:49 AM Page: 5
Sub
division
Debit
Credit Code
5.87
7.00 99999
217.53
99999
17.85
10.14 99999
19.27
99999
267.15
151.71 99999
274.48
99999
5,578.30 21773.60
�D
C2,'8
65,243.92
0.00 0.00
69,228.61 3,984.69
RQ 77R R1 R QRA RQ
� 65.243.92
Transaction Tc
Date: 12/14/22 09:44:49 AM Page: 5
i.
Contract # "21-46490-108 --
Submitted to GC by: 2 4/2022
Request for Reimbursement No.
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 nder state or local laws or regulations?
NA Approved by the federal awarding agency, if required?
NA Allowable per Circular A-87 (June 2004 version), Attachment B, items 1-43?
For payroll transactions:
Does the employee's time and effort documentation meet the requirements of
Circular A-1 22?
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 used on actual costs, not budgeted or projected amounts?
X Applied uniformly to federal and non-federal activities (Le., is the federal
government being charged the same'amount as if non-federal funds were being
used to pay the cost)?
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 br indirect costs only
with respect to final cost objectives).
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.
Correctly charged to the Proper account code and grant period?
NAStaff\ASC Files\Mrickler Pre Feb 2018\00 Grants\00 Subrecipient Checklist.doex Page 1
---------- I - ------ ...... -------------------------
Eviction Rent Assistance Program 2.0 (ERAP 2.0) - Report Farm -VERSION
---------------- - — --------- ------- -------------------------------------- -------------- - - ------------- - -----
4
LA1161111-1111S M.
.. .
•.Rental
Type
EXAMPLE: 080120200 945
1 American Indian/Alaska
'Native/Indigenous
Non-Hispanic/Non- leased lot space/mooring fee
Latin(a)(o)(A
leased rental unit
���M[Cisgender
Woman
'leased rental unit
Cisgender Woman
leased rental unit
..CisgenderWoma
TV IN
w.. -
leased rental unit
:. ,
Cisgender Man
leased rental unit
30% or less
..
..
30% or less
Cisgender Man..leased
rental unit
Cisgender Man..leased
rental unit.
,
Cisgender Man
leased rental unit
30% or less
leased rental unit
130% or less
..leased rental unit..or
less
Summary
No. of Applications [Total Households Months of Utility Assistance ITotal Amount of Utility Assistance Months of Rental Assistance ITotal Amount of Rental Assistance
01 121 81 776.41 671 54197,06
d
Head of Household Gen ee
A gender otherthan singularly man or
woman (e.g. non -
Transgender Man or bina ry/genderfluid/agender/cultu ra fly
b
C[sgenderWoman
Cisgender Man
Transgender Woman speciftigender)
Questioning
Client Doesn't Know Client Refused
Data Not Collected
61
51
11 0
01
0, 0,
0
50%1
42%1
8%1 A
0%1
0%1 0%1
0%1
rWC%U Ut rIUU:,W1IUIU na�.
American Indian/Alaska
ck/African American/African Native/Indigenous White.Client Doesn't Know Client Refused Data 'Not Collected Asian or Asian American Native Hawaiian or Pacific Islander Multiple Races
0 0 12 0 0 0 0 0 0
0% 0% 100% 0% 0% 0% 0% 0% 0%
z
Head 6fHousehold Ethnic'
4on-Hispanic/Non-Latln(a)(0)(X) Hispanic/Latin(ai)(o)(x) Client Doesn't Know Client Refused, Data Not. Collected'
6 6 0 0
50% 50% 0% 0% 05
enta[TVP
Leased Rental Unit Family/Friends Hotel/Motel Leased Lot Space/M ooring Fee Refused/Don't Know
11 0 0 1 0
92% 0% 0% 8% 0%
",.AMI
Less than 30% 31-50% 51-80%.
9 1 2
75% 8% 17%