The URL can be used to link to this page

Home My WebLink AboutGrant Related - BOCC (002)C d V ' REPORTING PERIOD: MAY 2022 WASHINGTON STATE (TITLE) j (DATE} DEPARTMENT OF COMMERCE Description QUANTITY AMOUNT AGENCY NUMBER IDIS PROJECT NUMBER Commerce Contract Number PREVIOUSLY VOUCHER DISTRIBUTION REMAINING 1030 2021-0019 21-62210-005 REQUESTED THIS INVOICE BALANCE 8397 1 1 719087.76 AGENCY NAME $409355.08 INSTRUCTION TO VENDOR OR CLAIMANT DEPARTMENT OF COMMERCE ATTN: CDBG Submit this form to claim payment for materials, merchandise or services Show com tete detail for "each item $0.00 PO BOX 42525 2 1 A - General Program Administration $ 39500.00 OLYMPIA, WA 98504-2525 $39500.00 Vendor's Certificate I hereby certify, under perJury that the Items and totals listed herein are proper charges for, materials, `merchandise or"services furnished toahe State of Washington, and : :. $0.00 VENDOR OR CLAIMANT (Warrant is to be payable to:) - that all goods furnished: and/or services rendered have been provided withoutdiscrimination because of age, sex, ma"rital status, race, creed, color, national origin, handicap, religion'or $0.00 Vetnam.era.�or disabledveterans status:, '_ - Grant County a $0.00 PO Box 37 - $ - Ephrata, WA 98823 $0.00 = I G N I N B L U - $ - REPORTING PERIOD: MAY 2022 (TITLE) j (DATE} Description QUANTITY AMOUNT IDIS PREVIOUSLY AMOUNT REMAINING Activity ID BUDGET REQUESTED THIS INVOICE BALANCE 8397 05Z - Other Public Services not in 03T,05A-05Y $ 1239080.00 719087.76 11,637.16 $409355.08 $0.00 8398 2 1 A - General Program Administration $ 39500.00 $39500.00 $0.00 - - $ - $0.00 - - $ - $0.00 - - $ - $0.00 - - $ - $0.00 - - $ - J 1 $0.00 TOTAL PAYMENT REQUEST $1269580.00 $71,087.76 11,637.16 $43,855.08 Everything below this line is for Dept of Commerce EDT I F AX D # _ PROGRAM APP OVAL Th n i i .. . R, _ e d vidual sign! this voucher warrants the have the authont to si n;this voucher. _ RI NTED-NAME. .___....- , ,..,,., ,.,:.. =, s , . " .. -. ,; SIGNATURE.:=65, Jeff Hir ckl- }, DOG DATE CURRENT DOC. N0. - REFERENCE DOC N0...- -== ,. VENDOR ,NUMBER .." - uvv, # : 000426.03 ACCOUNT -.NO.: - ` ASS NUMBER . -' VENDOR ME SA E -="= O S G 40932 CDB G #..... - -TRANS`= 0 MASTS R UB - SUB GL -ACCT ' SUBSID, INV CODE D IDE ;::" N X _. - _ _ ----------------- ,""OBJ " _ . OBJ _ B OU . A(N NT, NUMBER 621F0320 NZ $ 126,580.00 21-62210-005 0 $ - 0 $ - 0 $ - SIGNATURE OF ACCOUNTING PREPARER FOR PAYMENT DATE WARRANT TOTAL ACCOUNTING APPROVAL FOR PAYMENT DATE STATE OF WASHINGTON COMMUNITY DEVELOPMENT BLOCK GRANT - PUBLIC SERVICES GRANTS DEPT OF COMMERCE ATTN: CDBG PROGRAM PO BOX 42525 CERTIFICATION: I certify that the information on this form is a OLYMPIA, WA 98504-2525 true and accurate report of the cash status and that all reported expenditures are properly chargeable to the referenced grant. COMMUNITY ACTION AGENCY SUBRECIPIENT: CONTRACT NO: Signature: OIC OF WASHINGTON 21-62210-005 815 FRUITVALE BLVD REPORT PERIOD: Printed Name: DEREJE MEKURIA YAKIMA WA 98902 May -22 REPORT NUMBER: Title CFO 11 Date: 6/28/2022 TOTAL AMOUNT REQUESTED THIS PERIOD: $119637.16 1. Name of Service Pro am: Asset Development & Other Asset Development 136 IICDBG amount requested for these program activities thisperiod: $119622.12 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 120 IFCDBG amount requested for these program activities thisperiod: $15.04 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: $0.00 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 MAY 2022 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 maybe in an electronic form. X Correctly charged to the proper account code and grant period? C:\Users\Eliza Baysinger\Accountingjliza\Grants—Contracts\Grants—Contracts 20222023\267CDBG (EB)\2- Billings\05- 2022\Subrecipient Checklist 2020-21.doc Page 1 General Ledger System OIC OF WASHINGTON For User: Eliza Baysinger RW Expenditure report for: 267 - 267 CDBG Page: Page I of 1 Date: 6/24/2022 Report year: 7/1/2021 thru 6/30/2022 Period ending: May 2022 Time: 10:06:30 AM --_...---------Monthly--_---------- -----------------To Date--------. Account Budget Expenditures Pct Budget Expenditures Pct Annual budget Unexpended Admn Admin - Asset Dev/Energy Asst $2,051.00 $0.00 0.00% $22,561.00 $14,899.11 66.04% $24,616.00 $9,716.89 Asst Asst Dev & Othr Asst Developem $6,416.00 $11,622.12 181.14% $70,462.00 $53,175.63 75.47% $77,017,00 $23,841.37 Ener Energy Assistance $1,783.00 $15.04 0.84% $19,613.00 $14,650.18 74,70% $21,447.00 $6,796.82 Report Totals $10,250.00 ( $11,637.16 113.53% $112,636.00 $82,724.92 73.44% $123,080.00 $40,355.08 General Ledger System OIC OF WASHINGTON For User: Eliza Baysinger Page: Page 1 of 2 Fund Expenditure report for: 267 - CDBG PS 7/1/21-6/30/22 (Fund status: Active) Date: 6/24/2022 Report year: 7/1/2021 thru 6/30/2022 Period ending: May 2022 Time: 10:07:02 AM ---------------To Date ---------- Account Budget Expenditures Pet Budget Expenditures Pet Annual budget Unexpended Department: 009 INDIRECT ADMIN Program: 02 ADMIN. POOL -BASE 5312 SALARY ADM. ALLOCATION $1,191.00 $0.00 0.00% $13,101.00 $8,333.27 63.61% $14,293.00 $5,959.73 5354 P/R TAX & BEN. ADM ALLOC. $586.00 $0.00 0.00% $6,446.00 $3,861.34 59.90% $7,035.00 $3,173.66 5999 NON PERSONNEL ADM. ALLOC. $274.00 $0.00 0.00% $3,014.00 $2,704.50 89.73% $3,288.00 $583.50 Total for sub program -----> $2,051.00 $0.00 0.00% $22,561.00 $14,899.11 66.04% $24,616.00 $9,716.89 Total for program 02 $2,051.00 $0.00 0.00% $22,561.00 $14,899.11 66.04% $24,616.00 $9,716.89 Total for department 009 -----> $2,051.00 $0.00 0.00% $22,561.00 $14,899.11 66.04% $24,616.00 $9,716.89 Department: 010 PROGRAM Program: 25 PROGRAM SUPPORT 5311 SALARIES,WAGES EXPENSE $4,162.00 $7,464.55 179.35% $45,782.00 $34,084.31 74.45% $49,954.00 $15,869.69 5351 FICA,OIC EXP $303.00 $547.32 180.63% $3,333.00 $2,488.91 74.67% $3,647.00 $1,158.09 5352 L AND I,OIC SHARE $23.00 $39.38 171.22% $253.00 $195.99 77.47% $287.00 $91.01 5353 STATE UCI(ES),OIC EXP $64.00 $105.99 165.61% $704.00 $530.01 75.29% $777.00 $246.99 5355 PAID FAMILY MEDICAL LEAVE $26.00 $51.91 199.65% $286.00 $219.36 76.70% $321.00 $101.64 5360 DISABILITY OIC EXPENSE $57.00 $109.74 192.53% $627.00 $470.49 75.04% $689.00 $218.51 5361 MEDICAL INSURANCE,01C EXP $879.00 $1,567.91 178.37% $9,669.00 $7,198.67 74.45% $10,550.00 $3,351.33 5362 LIFE INSURANCE,01C EXP $22.00 $44.04 200.18% $242.00 $187.16 77.34% $274.00 $86.84 5363 PENSION,OIC EXP $312.00 $605.55 194.09% $3,432.00 $2,559.10 74.57% $3,750.00 $1,190.90 5364 ACCRUED PTO EXP $473.00 $693.31 146.58% $5,203.00 $3,880.17 74.58% $5,686.00 $1,805.83 5602 DEPRECIATION EXP EQUIP $0.00 $0.00 0.00% $0.00 $8.56 0.00% $9.00 $0.44 5910 INSURANCE $19.00 $28.19 148.37% $95.00 $106.12 111.71% $114.00 $7.88 5945 ADVERTISING $0.00 $338.26 0.00% $0.00 $338.26 0.00% $0.00 ($338.26) 5960 COMMUNICATION $56.00 $25.97 46.38% $616.00 $465.30 75.54% $682.00 $216.70 Total for sub program -----> $6,396.00 $11,622.12 181.71% $70,242.00 $52,732.41 75.07% $76,740.00 $24,007.59 Sub program: 54 ENERGY ASSISTANCE 5311 SALARIES,WAGES EXPENSE $1,191.00 $0.00 0.00% $13,101.00 $9,758.27 74.48% $14,300.00 $4,541.73 General Ledger System OIC OF WASHINGTON For User: Eliza Baysinger Fund Expenditure report for: 267 - CDBG PS 7/1/21-6/30/22 (Fund status: Active) Report year: 7/1/2021 thru 6/30/2022 Period ending: May 2022 Account V $87.00 5351 FICA,OIC EXP 5352 L AND 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 5910 INSURANCE Total for sub program 54 -----> Total for program 25 -----> Program: .50 BLDG MAINT/FACILITY 5601 DEPRECIATION EXP BLDG. 5602 DEPRECIATION EXP EQUIP 5611 SPACE 5630 UTILITIES 5640 BUILD. REPAIR/MAINT. 5910 INSURANCE 5912 LIABILITY INSURANCE Total for sub program -----> Total for program 50 -----> Total for department 010 -----> Fund Totals ---------------Monthly-------------- Budget Expenditures Pct $87.00 $0.00 0.00% $7.00 $0.00 0.00% $18.00 $0.00 0.00% $7.00 $0.00 0.00% $16.00 $0.00 0.00% $223.00 $0.00 0.00% $6.00 $0.00 0.00% $88.00 $0.00 0.00% $136.00 $0.00 0.00% $4.00 $15.04 376.00% $1,783.00 $15.04 0.84% $8,179.00 $11,637.16 142.28% $5.00 $0.00 0.00% $0.00 $0.00 0.00% $3.00 $0.00 0.00% $5.00 $0.00 0.00% $6.00 $0.00 0.00% $0.00 $0.00 0.00% $1.00 $0.00 0.00% smoo $0.00 0.00% $20.00 $0.00 0.00% $8,199.00 $11,637.16 141.93% $10,250.00 $11,637.1 113.53% -----------------To Date --------------- Budget Expenditures Pct $957.00 $712.77 74.48% $77.00 $62.01 80.53% $198.00 $147.26 74.37% $77.00 $61.83 80.30% $176.00 $138.59 78.74% $2,453.00 $1,828.31 74.53% $66.00 $55.12 83.52% $968.00 $721.36 74.52% $1,496.00 $1,115.29 74.55% $44.00 $49.37 112.20% $19,613.00 $14,650.18 74.70% $89,855.00 $67,382.59 74.99% $55.00 $0.00 $33.00 $55.00 $66.00 $0.00 $11.00 $220.00 $220.00 $90,075.00 $112,636.00 $87.32 158.76% $0.03 0.00% $101.75 308.33% $97.34 176.98% $127.66 193.42% $0.03 0.00% $29.09 264.45% $443.22 201.46% $443.22 201.46% $67,825.81 75.30% Page: Page 2 of 2 Date: 6/24/2022 Time: 10:07:03 AM Annual budget $1,045.00 $91.00 $216.00 $91.00 $203.00 $2,679.00 $81.00 $1,057.00 $1,634.00 $50.00 $21,447.00 $98,187.00 $70.00 $0.00 $37.00 $67.00 $83.00 $0.00 $20.00 Unexpended $332.23 $28.99 $68.74 $29.17 $64.41 $850.69 $25.88 $335.64 $518.71 $0.63 $6,796.82 $30,804.41 ($17.32) ($0.03) ($64.75) ($30.34) ($44.66) ($0.03) ($9.09) $277.00 ($166.22) $277.00 ($166.22) $98,464.00 $30,638.19 $82,724.92 73.44% $123,080.00 $40,355.08