HomeMy WebLinkAboutGrant Related - BOCC (003)GRANT COUNTY
BOARD OF COUNTY COMMISSIONERS
61
M 71LI7,6_09
To: Board of County Commissioners
41
From: Janice Flynn, Administrative Services Coordinator
Date: May 5, 2022
Re: Authorization for Release of Funds, Dept of Commerce, CDBG #21-62210-
005, Reimbursement #3, Subrecipient O/C Request #3
01C has requested reimbursement regarding the above -referenced grant in the amount
of $16,314.21 for March 2022 expenses. Their documentation is attached for review.
I am requesting the release of funds for payment to 01C in the amount of_llk,314-21
Thank you.
1.
AlT Of,"
_.. .... ........................
SIGNATURE OF ACCOUNTING PREPARER FOR PAYMENT DATE WARRANT TOTAL
ACCOUNTING APPROVAL FOR PAYMENT --
DATE
'MkTE OF WASMNGTON
DEPT OF COMMERCE
ATTN: CDBG PROGRAM
PO BOX 42525
:,OLYMPIA, WA 98504-2525
CON111MUN1111"ACTION AGENCY SUBRECtPIENT:
OIC OF WASHINGTON
815 FRUrFVALE BLVD
YAKM4A WA 98902
CONTRACT NO:
21-62210-005
REPORT PERIOD:
.Mar-22
REPORT NUMBER:
9
. ... .. .... .....
COMMUNITY DEVELOPMENT BLOCK GRANT - PUBLIC SERVICES GRANTS
CERT1F1CXTJ0,Nz tror,01Y that the information on this forin is a
true and accurate report of the cash status and that all reported
expenditures are property chargeable to the referenced grant.
Starn ature:
Printed Name: DEREJE MEKURIA
Title: CFO
Date: 5/4/2022
TOTAL AMOUNT REQUESTED THIS PERIOD: $16,314.21
......................... . ..
1. Name of Service Program: Asset Development & Other Asset Development 125 11CDBG amount requested for these program activities this..,period: $12,411.91
Description of service program how low- and moderate -income {LMI persons were served this period: Housing counseling, credit coaching,
foreclosure services business start-up, financial education workshops and high school classes. Free tax -prep.
2. Name of Service Program: Energ. 11CDBG amount requested for these program activities this period: $31902.29i
y Assistance 208
'Description of service program how low- and moderate -income (LMEI) persons were served this period: Energy assistance and conservation
Ieducation.
. . . ...................... . .
,3-Name of Service Activity: Asset Develop/Energy Assist Adman -indirect Admin JICDBG amount requested for these program activities this period: $0.001.
Description of service program how low- and moderate -income (LMI) persons were served this period: General administration expenses associated
With managing energy assistance and asset development activities oversight and assessments. Indirect admin.
. ............
Contract 21-62210-005
Submitted to GC by: OIC OF WASHINGTON
Request for Reimbursement No. 09
MARCH 2022
Grant County's Subrecipien# 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?
N/A 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-1 22?
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 (Leo, 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).
N/A Not included as both a direct billing and as a component of indirect costs?
N/A 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?
1ADATAN ON SHARE D\ACCOUNTI NC\ingrid's stufRCDl3G\CDl3G M L 267 2021-22\Subrecipient Checklist 2020-2 LdocPage
1
OIC OF WASHINGTON
For User: INGRID FRANK
RW Expenditure report for: 267 - 267 CDBG
Report year-, 7/1/2021 th ru 6/3012022
General Ledger System
Period ending.- March 2022
To Date—Pct
—
Account
Budget
Expenditures
Pct
tsucgel .
Expenditures
Adrnn
Adm in - Asset Dev/Energy Asst
$0.00
$0.00
0.00%
$0.00
$3,759.62
0.00%
Asst
Asset Development
$0.00
$12,321.70
0.00%
$0.00
$37,359.20
0.00%
Ener
Energy Assistance
$0.00
$3,902.29
0.00%
$0.00
$63964.34
0.00%
Othe
Other Asset Development
$0-00
$90-22
0-00%
$0.00
$90.22
0.00%
Report Totals
$0.00
$16,314.21
0.00%
$0.00
$48,173.38
0.00%
;111
Page: Page I of 1
Date: 5/4/2022
Tlme-- 10:26:17 AM
Annual budget Unexpended
$0.00
($3,759.62)
$0.00
($37,359.20)
$0.00
($6,964.34)
$0.00
($90-22)
$0.00
($48,173.38)
L/
Yncns'—�, L-W1 '73.3
General Ledger System
01C OF WASHINGTON
For User: 1NGR.1D FRANK
Fund Expenditure report for: 267 - CDBG PS 711/21-6/30122 (Fund status: Active)
Report year: 7l1/2021 thru 6/30/2022 Period ending: March 2022
Account
Department: 009 INDIRECT ADMIN
Program: 02 ADMIN. POOL -BASE
5312 SALARY ADM. ALLOCATION
5354 PIR TAX & BEN. ADM ALLOC_
5999 NON PERSONNEL ADM. ALLOC.
Total for sub program -----�
Total for program 02 ----->
Total for department 009 ---->
Department: 010 PROGRAM
Program: 25 PROGRAM SUPPORT
5311 SALARIES,WAGES EXPENSE
5351 FI CA,OIC EXP
5352 LAND 1,OIC SHARE
5353 STATE UCI(ES),OIC EXP
5355 PAID FAMILY MEDICAL LEAVE
5360 DISABILITY OIC EXPENSE
5361 MEDICAL INSURANCE,OIC EXP
5362 LIFE INSURANCE,OIC EXP
5363 PENSION,OIC EXP
5364 ACCRUED PTO EXP
5910 INSURANCE
5960 COMMUNICATION
Total for sub program ---->
Sub program: 54 ENERGY ASSISTANCE
5311 SALARIES,WAGES EXPENSE
5351 FICA,OIC EXP
5352 LAND I,OIC SHARE
Mon - To Date
Budget Expenditures Pct Budget Expenditures
Page: Page 1 of 8
Date: 4/29/2022
Time: 11:17:39 AM
Pct Annual budget Unexpended
$0.00
$0.00
0, 00%
$0.00
$2,073.83
0.00%
$0.00
($2,073.83)
$0.00
$0.00
0.00%
$0.00
$11116.44
0.00%
$0.00
($1,116.44)
$0.00
$0.00
0.00%
$0.00
$569.35
0.00%
$0.00
($569.35)
$0.00
$0.00
0.00%
$0.00
$3,759.62
0.00%
$0.00
($3,759.62)
$0-00
$0.00
0.00%
$0.00
$3,759.62
0.00%
$0.00
$0.00
$O.OQ
0.00%
$0.00
$3,759.62
0.00%
$0.00
($3,759.62)
$0.00
$8, 035.61
0.00%
$0.00
$24, 214.76
0.00%
$0.00
($24, 214.76)
$0.00
$589.03
0.00%
$0.00
$1, 764.82
0.00%
$0.00
($1, 764.82)
$0.00
$49.33
0.00%
$0.00
$141.72
0.00%
$0.00
($141.72)
$0.00
$129.38
0.00%
$0.00
$389.87
0.00%
$0.00
($389.87)
$0.00
$51.00
0.00%
$0.00
$153.02
0.00%
$0.00
($153.02)
$0.00
$102.16
0.00%
$0.00
$329.61
0.00%
$0.00
($329.61)
$0.00
$1,565.33
0.00%
$0.00
$51226.87
0.00%
$0.00
($5,226.87)
$0.00
$40.53
0.00%
$0.00
$130.77
0.00%
$0.00
($130.77)
$0.00
$594.95
0.00%
$0.00
$1,785.20
0.00%
$0.00
($1,785.20)
$0.00
$1,000.58
0.00%
$0.00
$3, 005.75
0.00%
$0.00
($3, 005.75)
$0.00
$21.90
0.00%
$0.00
$74.91
0.00%
$0.00
($74.91)
$0.00
$90.22
0.00%
$0.00
$90.22
0.00%
$0.00
($90.22)
$0.00
$12,270.02
0.00%
$0.00
$37,307.52
0.00%
$0.00
($37,307.52)
$0.00
$2,608.96
0.00%
$0.00
$4,576.31
0.00%
$0.00
($4,576.31)
$0.00
$189.72
0.00%
$0.00
$330.37
0_00%
$0.00
($330.37)
$0.00
$17.71
0.00%
$0.00
$30.09
0.00%
$0.00
($30.09)
General Ledger System
OIC OF WASHINGTON
For User: INGRID FRANK
Fund Expenditure report for: 267 - CDBG PS 7/1/21-6/30122 (Fund status: Active) Page: Page 2 of 8
Report year: 7/1/2021 thru 6/3012022 Period ending: March 2022 Date: 4129/2022
Time: 1117*41 AM
monally-_
To Date—
Account
Budget
Expenditures
Pct
Budget
Expenditures
Pct
Annual budget
5353
STATE UCI(ES),OIC EXP
$0.00
$42.02
... ........ .
0.00%
$0.00
$73.70
0-00%
$0-00
5355
PAID FAMILY MEDICAL LEAVE
$0-00
$17.04
0.00%
$0.00
$29�27
0.00%
$0.00
5360
DISABILITY OIC EXPENSE
$0.00
$36.43
0.00%
$0-00
$63.53
0,00%
$0.00
5361
MEDICAL INSURANCE,01C EXP
$0.00
$510.60
0.00%
$0.00
$1,015.44
0.00%
$0.00
5362
LIFE (NSURANCE,OIC EXP
$0.00
$14.50
0.00%
$0.00
$25.29
0.00%
$0.00
5363
PENSION,01C EXP
$0.00
$198.80
0.00%
$0.00
$341.39
0.00%
$0M
5364
ACCRUED PTO EXP
$0.00
$253.40
0.00%
$0.00
$456.11
0.00%
$0.00
5910
INSURANCE
$0.00
$13.11
0.00%
$0.00
$22,,.84
0.00%
$0.00
Total for sub program 54
$0.00
$31902�29
0-00%
$0.00
$6,964.34
.... . .......
0.00%
$0.00
Total for program 25
$0.00
$16,172.31
0.00%
$0.00
$44,271.86
0.00%
$0.00
Program: 50 BLDG MAINT/FACILITY
5611 SPACE
5630 UTILITIES
5640 BUILD. REPAIRMAINT.
5912 LIABILITY INSURANCE
Total for sub program
Total for program 50 -->
Total for department 010 -->
Fund Totals
Unexpended
($73,70)
($29.27)
($63.53)
($1,015.44)
($25.29)
($341-39)
($456.11)
($22.84)
($6,964�34)
($44,271.86)
$0.00
$25.44
0,00%
$0.00
$25.44
0.00%
$0.00
($25.44)
$0.00
$45.71
0.00%
$0.00
$45.71
0.00%
$0.00
($45-71)
$0.00
$56.91
0.00%
$0.00
$56.91
0.00%
$0.00
($56.91)
$0.00
$13.84
0.00%
$0.00
$13.84
0.00%
$0.00
($13.84)
$0.00
$141.90
0,00%
$0.00
$141.90
0.00%
$0.00
$0-00
$141.90
0.00%
$0.00
$141.90
0.00%
$0-00
($141.90)
$0.00
$16,314.21
0.00%
$0.00
$441413.76
0.00%
$0.00
($44,413.76)
$0.00
$16,314.21
0.00%
$0-00
$48,173-38
0-00%
$0.00
($48,173-38)