The URL can be used to link to this page

Home My WebLink AboutGrant Related - BOCC (002)STATE OF WASHINGTON DEPT OF COMMERCE ATTN: CDBG PROGRAM PO BOX 42525 OLYMPIA, WA 985042525 COMMUNITY ACTION AGENCY SUBRECIPIENT: OIC OF WASHINGTON 815 FRUITVALE BLVD YAKIMA WA 98902 TOTAL AMOUNT REQUESTED THIS PERIOD: CONTRACT NO: 19-62210-005 REPORT PERIOD: Mar -20 REPORT NUMBER: $17,866.04 2019 COMMUNITY DEVELOPMENT BLOCK GRANT - PUBLIC SERVICES GRANTS CERTIFICATION: I certify that the information on this form is a true and accurate report of the cash status and that all reported ezpeodihn r, are propertychar ab{e to the referenced grant. Signature: Printed Name: Dere'e Mekuria Title: Chief Financial Officer Date: 4/14/2020 1. Name of Service Program: Asset Development 55 CDBG amount requested for these program activities thisperiod: $14,120.35 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: Energy Assistance 198 CDBG amount requested for these program activities thisperiod: $0.00 Description of service program how low- and moderate -income (LMI) persons were served this period: Energy assistance and conservation education. 3.Name of Service Activity: Asset Develop/Energy Develop/EnergyAssist Admin -Indirect Admin CDBG amount requested for these program activities thisperiod: $3,745.69 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. STATE OF WASHINGTON DEPT OF COMMERCE ATTN:CDBGPROGRAM PO BOY 42525 OLVNIPIA, WA 98504-2525 COMMUNITY ACTION AGENCY SUBRECIPIENT: OIC OF WASHINGTON 815 FRUITVALE BLVD YAKIMA WA 98902 TOTAL AMOUNT REQUESTED THIS PERIOD: CONTRACT NO: 19-62210-005 REPORT PERIOD: Mar -20 REPORT NUMBER: 9 5(7,866.04 2019 COMMUNITY DEVELOPMENT BLOCK GRANT - PUBLIC SERVICES GRANTS CERTIFICATION: I certify Ihal the informntion on this form is a Irue and accnrale report or the ash slat as and IItoI all reported expenditures are properly chnrgenble to the referenced grant. Signature: Printed Name: Dereje Mekuria Title: Chief Fol:ulcial Officer Date: 4/14/2020 1. Natne of Service Program. Asset Develo men( 55 CDIIG amount re ucsted for these ro =ram activities this erintl; $14,13U,35 Description of service program how low- and moderate -income (LMI) persons were served this period: Housing counseling, credit coaching, foreclosure services, business start -tip, financial education workshops and high school classes. Free tax -prep. 2 Name of Service Program: Enc Y Assistance 198 C'D13(i amount ret tiestcd for these prograin activities this cri(x1: $0.00 Description of service program how low- and moderate -income (LMI) persons were served this period: Energy assistance and conservation education. 3.Name of Service Activity. Asset Qeveln It ne v Assist Admin -Indirect Admin CDI3G amount ret ucsted for these progrim aelivitit.•s this ri(xl S3.745.69 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. WASHINGTON STATE DEPARTMENT OF COMMERCE A19 VOUCHER DISTRIBUTION AGENCY NAME DEPARTMENT OF COMMERCE ATTN: CDBG PO BOX 42525 OLYMPIA, WA 98504-2525 VENDOR OR CLAIMANT (Warrant is to be payable to:) GRANT COUNTY PO BOX 37 EPHRATA, WA 98823-0037 RIA"ORTING PERIOD: MARCH 2020 Description IDIS Activity ID 7945 05 Public Services 7946 121A General Admin TOTAL PAYMENT REQUEST Everything below this line is for Dept of Commerce PROGRAM APPROVAL (The individual signing this vouc PRINTED NAME: Jeff Hlnckle CURRENT DOC. N0, IREFERENCE DOC NO 1030 30 19-62210-005 INSTRUCTION TO VENDOR OR CLAIMANT: Submit this form to claim payment for materials, merchandise or services Shaw complete detail for each item Vendor's Certificate: I hereby certify under perjury that the Items and totals listed hereln are proper charges for materials, merchandise or sarvices furnished to the State of Washington, and that all goods fur nd/or se//��'ices rends d have been rovId.d without discrimination becaur age, sex, frltal status r9ce, creed, or, national origin, handicap. relloion or Iitnam era or �sabled vet ai6 tura , �) v l_ "C --Ot — dt a (TITLE) (DATE) QUANTITY AMOUNT BUDGET PREVIOUSLY AMOUNT REQUESTED THIS INVOICE REMAINING BALANCE $117,558.00 36,845.78 17,866.04 $62,846.18 $0.00 $0.00 3,500.00 3,500.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $121,058.00 $40,345.781 17,866,041 $62,846.18 -T Brants they have the authority to sign this vouaher.f SIGNATURE: DATE VENDOR NUMBER SWV0002426-03 VENDOR MESSAGE CDBG # M SUB TRANS 0 MASTER SUB SUB GL ACCT SUBSID INVOICE CODE 0 INDEX OBJ OBJ AMOUNT NUMBER 629FO320 I NZ 1 1 151521 OF ACCOUNTING PREPARER 3 APPROVAL FOR PAYMENT WARRANT TOTAL Contract 19.62210-005 Submitted to GC by: OIC OF WASHINGTON Request for Reimbursement No. 9 MARCH 2020 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? 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-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). 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? 1:\DA'T'ANONSIIARED\ACCOUNTING\ingrid's s(uftNCDBG\CD13G ML 265 2019-20\Subrecipient Checklist 2019-20.docPage OIC OF WASHINGTON For User: INGRID FRANK RW Expenditure report for: 265 - 265 CDBG Report year: 7/1/2019 thru 6/30/2020 Account Admn Admin - Asset Dev/Energy Asst Asst Asset Development Ener Energy Assistance Report Totals a8(ro n - 394s (C General Ledger System —To Date --------- Expenditures Pct $11,811.37 67.02% $42,900.45 75.22% $0.00 0.00% $54,711.82 62.67% Page: Page 1 of 1 Date: 4/14/2020 Time: 2:58:20 PM Annualbudget Unexpended $23,511.60 Period ending: March 2020 ----Monthly-- -- -- Budget Expenditures Pct Budget $1,958.00 $3,804.27 194.29% $17,622.60 $6,670.00 $14,156.90 212.25% $57,036.05 $1,405.00 $0.00 0.00% $12,645.35 $10,033.00 $17,961.17 179.02% $87,304.00 e4,6,0L} —To Date --------- Expenditures Pct $11,811.37 67.02% $42,900.45 75.22% $0.00 0.00% $54,711.82 62.67% Page: Page 1 of 1 Date: 4/14/2020 Time: 2:58:20 PM Annualbudget Unexpended $23,511.60 $11,700.23 $77,118.05 $34,217.60 $16,928.35 $16,928.35 $117,558.00 $62,846.18 OIC OF WASHINGTON For User: INGRID FRANK Fund Expenditure report for: Report year: 7/1/2019 Account General Ledger System 265 - CDBG PS 711/19-6/30/20 (Fund status: Active) Page: Page 1 of 3 Date: 4/14/2020 thru 6/30/2020 Period ending: March 2020 Time: 2:57:57 PM --Monthly-------------_To Date-- -- Budget Expenditures Pct Budget Expenditures Pct Annual budget Unexpended Department: 008 DIRECT ADMIN Program: 83 COO/ I.T. 5311 SALARIES,WAGES EXPENSE 5351 FICA,OIC EXP 5352 LAND I,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 5500 TRAVEL 5601 DEPRECIATION EXP BLDG. 5602 DEPRECIATION EXP EQUIP 5611 SPACE 5630 UTILITIES 5640 BUILD. REPAIR/MAINT. 5910 INSURANCE 5912 LIABILITY INSURANCE 5960 COMMUNICATION Total for subprogram -> $0.00 $284.09 0.000/0 $0.00 $284.09 0.00% $0.00 $21.39 0.00% $0.00 $21.39 0.00% $0.00 $1.57 0.00% $0.00 $1.57 0.00% $0.00 $6.34 0.00% $0.00 $6.34 0.00% $0.00 $1.14 0.00% $0.00 $1.14 0.00% $0.00 $3.38 0.00% $0.00 $3.38 0.00% $0.00 $26.91 0.00% $0.00 $26.91 0.00% $0.00 $1.45 0.00% $0.00 $1.45 0.00% $0.00 $19.89 0.00% $0.00 $19.89 0.00% $0.00 $21.59 0.00% $0.00 $21.59 0.00% $16.00 $0.00 0.00% $144.00 $0.00 0.00% $0.00 $0.67 0.00% $0.00 $0.67 0.00% $0.00 $0.12 0.00% $0.00 $0.12 0.00% $0.00 $14.57 0.00% $0.00 $14.57 0.00% $0.00 $6.06 0.00% $0.00 $6.06 0.00% $0.00 $1.54 0.00% $0.00 $1.54 0.00% $0.00 $0.50 0.00% $0.00 $0.50 0.00% $0.00 $1.53 0.00% $0.00 $1.53 0.00% $0.00 $2.03 0.00% $0.00 $2.03 0.00% $16.00 $414.77 2592.31% $144.00 $414.77 288.03% Total for program 83 ---> $16.00 $414.77 2592.31% $144.00 $414.77 $414.77 Total for department 008 --> $16.00 $414 77 % $144.00 Department: 009 INDIRECTADMIN �i''� j�'t �f� Program: 02 ADMIN. POOL -BASE C�%� Cif W / �j1� c� /✓ bbG 5312 SALARY ADM. ALLOCATION $1,204.00 $2,027.78 168.42% $10,836.60 $6,608.64 5354 P/R TAX & BEN. ADM ALLOC $505.00 $972.66 192.61% $4,545.00 $3,362.51 288.03% 288.03% cLo(191,n 60.98% 73.98% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $200.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $200.00 ($284.09) ($21.39) ($1.57) ($6.34) ($1.14) ($3.38) ($26.91) ($1.45) ($19.89) ($21.59) $200.00 ($0.67) ($0.12) ($14.57) ($6.06) ($1.54) ($0.50) ($1.53) ($2.03) ($214.77) $200.00 ($214.77) $200.00 ($214.77) $14,453.60 $7,844.96 $6,061.00 $2,698.49 General Ledger System OIC OF WASHINGTON For User: INGRID FRANK Fund Expenditure report for: 265 - CDBG PS 7/1/19-6/30/20 (Fund status: Active) Page: Page 2 of 3 Report year: 7/1/2019 thru 6/30/2020 Period ending: March 2020 Date: 020 Time: 2 2:57:58 PM :57.5 Monthly - -----To Date - Account Budget Expenditures Pd Budget Expenditures Pct Annualbudget Unexpended 5999 NON PERSONNEL ADM. ALLOC. $233.00 $389.06 166.98% $2,097.00 $1,425.45 67.96% $2,797.00 $1,371.55 Total for subprogram -a $1,942.00 $3,389.50 174.54% $17,478.60 $11,396.60 65.20% $23,311.60 $11,915.00 Total for program 02-� $1,942.00 $3,389. 174.54% $17,478.60 $11,396.60 65.20% $23,311.60 $11,915.00 Total for department 009--> $1,942.00 $3,389.50 174.54% `ti Lvn yjo $17,478.60 $11,396.60 65.20% $23,311.60 $11,915.00 Department: 010,P Program: 2 PROGRAM SUPPORT, Gt d, �S 8. S y, n %/� / S- 1p 7 5311 SALARI0.PENSE $3,803.00 $9,064.44 238.35% $34,227.00 $26,944.44 78.72% $45,644.00 $18,699.56 5351 FICA,OIC EXP $295.00 $662.12 224.45% $2,655.00 $1,966.98 74.09% $3,540.00 $1,573.02 5352 LAND I,OIC SHARE $34.00 $91.37 268.74% $306.00 $251.13 82.07% $412.00 $160.87 5353 STATE UCI(ES),OIC EXP $84.00 $202.14 240.64% $756.OD $600.86 79.48% $1,012.00 $411.14 5355 PAID FAMILY MEDICAL LEAVE $16.00 $37.48 234.25% $144.00 $110.55 76.77% $195.00 $84.45 5360 DISABILITY OIC EXPENSE $71.00 $119.45 168.24% $639.00 $358.35 56.08% $659.00 $500.65 5361 MEDICAL INSURANCE,OIC EXP $1,068.00 $2,375.44 222.42% $9,612.00 $7,126.32 74.14% $12,825.00 $5,698.68 5362 LIFE INSURANCE,OIC EXP $20.00 $47.43 237.15% $180.00 $142.29 79.05% $251.00 $106.71 5363 PENSION,OIC EXP $283.00 $655.90 231.77% $2,547.00 $1,934.59 75.96% $3,405.00 $1,470.41 5364 ACCRUED PTO EXP $0.00 $873.50 0.00% $0.00 $2,478.03 0.DD% $0.00 ($2,478.03) 5399 FRINGE $497.00 $0.00 0-00% $4,473.05 $0.00 0.00% $5,975.05 $5,975.05 5500 TRAVEL $166.00 $O.DO 0.00% $498.00 $20.00 4.02% $1,000.00 $980.00 5507 OUT OF STATE TRAVEL $283.00 $0.00 0.00% $849.00 $910.70 107.27% $1,700.00 $789.30 5910 INSURANCE $0.00 $27.63 0.00% $0.00 $56.21 0.00% $0.00 ($56.21) 5950 TESTING CHARGES $50.00 $0.00 0.00% $150.00 $0.00 0.00% $300.00 $300.00 Total for subprogram -a 1c)-0 $6,670.00 $14,156.90 212.25%$57,�0I36.05 $42,900.45 75.22% $77,118.05 $34,217.60 Sub program: 54 ENERGY ASSISTANCE C Cc �'S� = V(4 (A Q.3 5 5311 SALARIES,WAGES EXPENSE $97_5.010 $0.00 0.00% $8,775.00 $0.00 0.00% $11,704.00 $11,704.00 5351 FICA,OIC EXP $72.00 $0.00 0.00% $648.00 $0.00 0.00% $875.00 $875.00 5352 L AND I,OIC SHARE $9.00 $0.00 0.00% $81.00 $0.00 0.00% $115.00 $115.00 5353 STATE UCI(ES),OIC EXP $20.00 $0.00 0.00% $180.00 $0.00 0.00% $243.00 $243.00 5355 PAID FAMILY MEDICAL LEAVE $3.00 $0.00 0.00% $27.00 $0.00 0.00% $46.00 $46.00 General Ledger System OIC OF WASHINGTON For User INGRID FRANK Fund Expenditure report for 265 - CDBG PS 7/1/19-6/30/20 (Fund status: Active) Report year: 711/2019 thru 6/30/2020 Period ending: March 2020 Account Monthly - 5360 DISABILITY OIC EXPENSE 5361 MEDICAL INSURANCE,OIC EXP 5362 LIFE INSURANCE,OIC EXP 5363 PENSION,OIC EXP 5399 FRINGE Total for sub program 54 —> Total for program 25 —> Total for department 010 --> Fund Totals $10,033.00 $17,961.17 179.02% $87,304.00 �! eesO a&K r) &C0 -0y Page: Page 3 of 3 Date: 4/14/2020 Time: 2:57:59 PM Annual budget $193.00 $1,592.00 $57.00 $815.00 $1,288.35 $16,928.35 $94,046.40 $94,046.40 Unexpended $193.00 $1,592.00 $57.00 $815.00 $1,288.35 $16,928.35 $51,145.95 $51,145.95 $54,711.82 62.67% $117,558.00 $62,846.18 Monthly - Budget Expenditures Pct $16.00 $0.00 0.00% $132.00 $0.00 0.00% $4.00 $0.00 0.00% $67.00 $0.00 0.00% $107.00 $0.00 0.00 $1,405.00 $0.00 0.00% $8,075.00 $14,156.90 175.32% $8,075.00 $14,156.90 175.32% $10,033.00 $17,961.17 179.02% $87,304.00 �! eesO a&K r) &C0 -0y Page: Page 3 of 3 Date: 4/14/2020 Time: 2:57:59 PM Annual budget $193.00 $1,592.00 $57.00 $815.00 $1,288.35 $16,928.35 $94,046.40 $94,046.40 Unexpended $193.00 $1,592.00 $57.00 $815.00 $1,288.35 $16,928.35 $51,145.95 $51,145.95 $54,711.82 62.67% $117,558.00 $62,846.18 To Date— Budget Expenditures Pct $144.00 $0.00 0.00% $1,188.00 $0.00 0.00% $36.00 $0.00 0.00% $603.00 $0.00 0.00% $963.35 $0.00 0.00 $12,645.35 $0.00 0.00% $69,681.40 $42,900.45 61.57% $69,681.40 $42,900.45 61.57% $10,033.00 $17,961.17 179.02% $87,304.00 �! eesO a&K r) &C0 -0y Page: Page 3 of 3 Date: 4/14/2020 Time: 2:57:59 PM Annual budget $193.00 $1,592.00 $57.00 $815.00 $1,288.35 $16,928.35 $94,046.40 $94,046.40 Unexpended $193.00 $1,592.00 $57.00 $815.00 $1,288.35 $16,928.35 $51,145.95 $51,145.95 $54,711.82 62.67% $117,558.00 $62,846.18 General Ledger System OIC OF WASHINGTON Page: Page 1 of 1 For User: INGRID FRANK Date: 4/1412020 Transaction work file listing Time: 2:57:04 PM Number Period Date Description Journal Account Debit Amt Credit Amt 135328 1 14 -Feb -20 1/20 admin pool salary & General 2020- 265 009 - 02- - 5354 PIR TA 1298.97 benefits 135569 2 13 -Mar -20 2/20 admin pool salary & General 2020- 265 - 009 - 02 - - 5354 PIR TA 1149.46 benefits 135736 1 25 -Mar -20 adl 1120 admin pool pto General 2020- 265 - 009 - 02 - - 5354 P/R TA 58.58 alloc 135921 3 14 -Apr -20 320 admin pool salary & General 2020- 265 - 009 - 02. - 5354 PIR TA 972.66 benefits Total number of transactions: 4 Agency Totals: 3421.09 58.58 General Ledger System OIC OF WASHINGTON Page: Page 1 of 1 For User: INGRID FRANK Date: 4/14/2020 Transaction work file listing Tlme: 2:57:37 PM Number Period Date Description Journal Account Debit Amt Credit Amt 135719 1 25 -Mar -20 system pto I & i Payroll 2020- 265 010 - 25 - - 5364 ACCR 36.55 calculation adj 21921 1 31 -Jan -20 Program expense for Payroll 2020- 265 - 010 - 25 - - 5364 ACCR 837.23 vacation accrued 1/31/2020 22039 2 29 -Feb -20 Program expense for Payroll 2020- 265 - 010 - 25 - - 5364 ACCR 803.85 vacation accrued 2/29/2020 22160 3 31 -Mar -20 Program expense for Payroll 2020- 265 - 010 - 25- - 5364 ACCR 673.50 vacation accrued 3131/2020 Total number of transactions: 4 Agency Totals: 2514.58 36.55