The URL can be used to link to this page

Home My WebLink AboutGrant Related - BOCC (005)GRANT COUNTY BOARD OF COUNTY COMMISSIONERS T 1Ll=il_L.•J To: Board of County Commissioners Frcwn: Janice Flynn, Administrative Services Coordinator Data June 22, 2023 Re: Authorization for Release of Funds, Dept of Commerce, CDBG #22-62210- 005, Reimbursement #1, Subrecipient 01C Request #1-4 01C has requested reimbursement regarding the above -referenced grant in the amount of $27,314.18 for May 2023 expenses. Their documentation is attached for review. I am requesting the release of funds for payment to 01C in the amount Of $27,314.18. Thank you. APPROVED JUN 2 '1 2023 CONSENT IVED POUN Tly COMMISSIONER I'S $0.00 8623 2 1 A - General Program Administration $ 39500.00 $0.00 $3,500.00 $0.00 $0.00 - WASHINGTON STATE $ - Cr DEPARTMENT OF COMMERCE $0.00 71 ,oy $ AGENCY NUMBER IDIS PROJECT NUMBER Commerce Contract Number - ___ $0.00 - - $ - A19 VOUCHER DISTRIBUTION $0.00 1030 2021-0019 2J/62210-005 AGENCY NAME INSTRUCTION TO VENDOR OR CLAIMANT.- LAIMANT;DEPARTMENT - DEPARTMENTOF COMMERCE $ - Submit this farm to claim payment for matenais,-.merchandise or services ATTN: CDBG $0.00 Show com Iete detail for each Item: TOTAL PAYMENT REQUEST PO BOX 42525 $45,461.72 27,314.18 $55,224.10 OLYMPIA, WA 98504-2525 Everything below this line is for Dept of Commerce Vendor's Certifcate: `I hereby certify under perjury that the items and totals fisted herein are proper charges for materials, merchandise or services furnished to the State of Washington, and' FED TAX ID # VENDOR OR CLAIMANT (Warrant is to be payable to:) warrants the have the authori to si n this voucher. _ _. _ tY .:.... g a Y that all goods furnished and/or services rendered have been`provided without discrimination because of age, sex; marital status,race, creed, color, national origin, handicap, religion or :- :. SIGNATURE:., Vietnamdraor disabled veterans status Grant County ... CURRENT DOC. NO. . _ .._ REFERENCE DOG NO . <. ,.. PO Box 37 By: Ephrata, WA 98823 .(SIGN IMBLUE INKY. , REPORTING PERIOD: May 2023 Sw # (TITLE) DATE} C . A COUNT Nb.: Description QUANTITY AMOUNT IDIS VENDOR MESSAGE:,",-:.. PREVIOUSLY AMOUNT REMAINING Activity ID BUDGET REQUESTED THIS INVOICE BALANCE 8622 05Z - Other Public Services not in 03T,05A-05Y $ 1249500.00 45,461.72 23,814.18 $55,224.10 $0.00 8623 2 1 A - General Program Administration $ 39500.00 $0.00 $3,500.00 $0.00 $0.00 - - $ - -_ $0.00 $ - ___ $0.00 - - $ - $0.00 - - $ - $0.00 TOTAL PAYMENT REQUEST $1289000.00 $45,461.72 27,314.18 $55,224.10 Everything below this line is for Dept of Commerce FED TAX ID # PROGRAM APPROVAL The individual _( „n, vi ual signing this: voucher - i warrants the have the authori to si n this voucher. _ _. _ tY .:.... g a Y PRINTED AME.. Jeff Hinckie :. SIGNATURE:., DOC -DATE, ... CURRENT DOC. NO. . _ .._ REFERENCE DOG NO . <. ,.. VENDOR NUMBER <- Sw # .0002426 '01 . :'. C . A COUNT Nb.: �: = . ' . �� . ` _ _ _ -' - .. , _ : ASD NUMBER ,: -. _ �= VENDOR MESSAGE:,",-:.. 43260 CD.BGI # SUB =0 MASTER -1; =SUB. '.. GLACGTS � SUBSIRANS CODE D - INDEX OBJ OBJ <. AMOUNT NUMBER 622FO320 NZ $ 1289000.00 22-62210-005 0 $ - 0 $ - 0 $ - TURE OF ACCOUNTING PREPARER FOR PAYMENT I DATE I WARRANT TOTAL KING 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: y , y CONTRACT NO: Signature: ,1 OIC OF WASHINGTON 22-62210-005 815 FRUITVALE BLVD REPORT PERIOD: Printed Name: ELIZA BAYSINGER YAKIMA WA 98902 May -23 .- REPORT NUMBER: Title: SENIOR ACCOUNTANT _ . 17 Date: 6/20/2023 TOTAL AMOUNT REQUESTED THIS PERIOD: $27,314.18 1. Name of Service Program: Asset Development & Other Asset Development 218 CDBG amount requested for these program activities thisperiod: $16,055.16 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: Ener Assistance 177 CDBG amount re uested for these ro ram activities this eriod: $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: $7,759.02 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. 4. Name of Service Activity: Contract Recipient General Program Administration CDBG amount requested for these program activities thisperiod: $3,500.00 50 50 50 50 50 50 50 OIC of Washington CDBG Expense Summary - 267 Grant Period: 07/01/2022 - 06/30/2023 22-62210-005 BILLING PERIOD: MAY 2023 Salary 5311 $52,968.00 $18,131.27 $29,136.90 $11,005.63 $23,831.10 FICA, OIC Exp 5351 $3,868.00 $11321.90 $2,124.40 $802.50 $1,743.60 L AND I, OIC Share 5352 $305.00 $85.34 $138.30 $52.96 $166.70 State UCI,OIC Ex 5353 $824.00 $192.17 $308.83 $116.66 $515.17 PFML 5355 $341.00 $153.73 $236.47 $82.74 $104.53 Disability, OIC Exp 5360 $731.00 $248.09 $353.78 $105.69 $377.22 Medical Insurance, OIC Exp 5361 $11,187.00 $31777.02 $5,666.23 $1,889.21 $5,520.77 Life Insurance, OIC Exp 5362 $291.00 $98.89 $140.96 $42.07 $150.04 Pension, OIC Exp 5363 $3,977.00 $1,345.07 $27069.20 $724.13 $1,907.80 Accrued PTO Exp 5364 $6,030.00 $17904.89 $27658.22 $753.33 w $3,371.78 Credit Reports 5411 $0.00 $28.90 $140.70 $111.80 ($140.70) Depreciation Exp Equip 5602 $10.00 $4.87 $4.87 $0.00 $5.13 Insurance 5910 $121.00 $69.04 $86.59 $17.55 $34.41 Liability Insurance 5912 $0.00 $0.00 $0.96 $0.96 ($0.96) Communication (Telephone/Cell & ISP 5960 $723.00 $186.99 $236.82 $49.83.- $486.18 De reciation Exp Bldg 5601 $75.00 $83.38 $83.38 $0.00 ($8.38) Depreciation Exp Equip 5602 $0.00 $0.00 $0.03 $0.03 ($0.03) Space 5611 $40.00 $127.43 $127.43 ($87.43) Utilities 5630 $71.00 $74.50 $74.50 ($3.50) Build Re air/Maint. 5640 $88.00 $76.54 $76.54 $11.46 Insurance 5910 $0.00 $0.25 $0.25 AV ($0.25) Liability Insurance 5912 $22.00 $21.35 $21.35 $0.65 SU BTOT . , , 3AL . 05516 $37,98586.7$81672.00 . , T .0 ENERGY'ASSISAN Salary 5311 $11,953.00 $101095.75 $107095.75 $0.00 $1,857.25 FICA, OIC Exp 5351 $873.00 $745.25 $745.25 $0.00 $127.75 LAND I, OIC Share 5352 $76.00 $61.56 $61.56 $0.00 $14.44 State UCI,OIC Exp 5353 $180.00 $107.02 $107.02 $0.00 $72.98 PFML 5355 $76.00 $88.52 $88.52 $0.00 ($12.52) Disability, OIC Exp 5360 $170.00 $187.61 $187.61 $0.00 ($17.61) Medical Insurance, OIC Exp 5361 $2,240.00 $1,682.87 $1,682.87 $0.00 $557.13 Life Insurance, OIC Exp 5362 $68.00 $61.65 $61.65 $0.00 $6.35 Pension, OIC Exp 5363 $884.00 $774.60 $774.60 $0.00 $109.40 Accrued PTO Exp 5364 $1$66.00 $1,065.44 $1,065.44 $0.00 $300.56 Insurance 5910 $42.00 1 $35.89 1 $35.89 1 $0.00 $6.11 SUBTOTAL � � $17,928.00 � $14,906.16` $14,906.16 I $0.00 � $3,021.84 ASSET DEVELOPMENT/ENERGY ASSISTANCE ADMIN -INDIRECT 009-02 Salary Admin. Allocation 5312 $14,458.00 $1,998.23 $61429.95 $4,431.72 $8,028.05 P/R Tax & Ben. Adm Allocation 5354 $7,116.00 $925.78 $2,805.54 $17879.76 $4,310.46 Non Personnel Adm. Allocation 5999 $3,326.00 $0.00 $1,447.54 $1,447.54 $1,878.46 SUBTOTAL $24,900.00 $21924.01 $10,683.03 $7,759.02 $14,216.97 I:\DATANONSHARED\ACCOUNTING\Accounting_Eliza\Grants_Contracts\Grants_Contracts_Current\267_CDBG (EB)\2- Billings\YR 2\CDBG_Expense Tracking Summary- 267 6/20/2023 I I YTD BILLED I YTD EXPENSED I I BUDGET BALANCE Description ACCOUNT BUDGET (as of 04/30/23) (as of 05/31/23) DIFFERENCE (as of 05/31/23) CONTRACT RECIPIENT 70 ; Contract Recipient Fee 5415 $3,500.00 $3,500.00 $3,500.00 $0.00 SUBTOTAL . $0.00 $3,500.40 $3,500.00 $0:00 $45, .2 .$55,224.10TOTAL GRANT $128,000.00 7, I:\DATANONSHARED\ACCOUNTING\Accounting_Eliza\Grants_Contracts\Grants_Contracts_Current\267_CDBG (EB)\2- Billings\YR 2\CDBG_Expense Tracking Summary- 267 6/20/2023 OIC OF WASHINGTON For User: Eliza Baysinger Transaction listing by account Fund: CDBG PS 7/1/21-6/30/23 General Ledger System From 5/2023 through 5/2023 Page: Page 1 of 3 Date: 6/12/2023 Tlme: 11:47:09 AM Account Trans. date Trans. type Doc. num. Vendor/Customer Journal description Debit amount Credit amount 267-009-02- -5312 INDIRECT ADMIN - ADMIN. POOL - BASE - - SALARY ADM. ALLOCATION May, 2023 6/12/2023 AJE 145269 5/23 Admin Pool Salary & Benegits $3,258.52 Alloc Period Total ---> $3,258.52 «R Cummulative Total ---> $3,258.52 267-009-02- -5354 INDIRECT ADMIN - ADMIN. POOL - BASE - - P/R TAX & BEN. ADM ALLOC. May, 2023 6/12/2023 AJE 145269 5/23 Admin Pool Salary & Benegits $`h,344.62 f _ Allot 45\ vW s Period Total ---> $1,344.62 ,. Cummulative Total ---> $1,344.62 $0.00 267-009-02- -5999 INDIRECT ADMIN --ADMIN. POOL - BASE - - NON PERSONNEL ADM.-ALLOC. May, 2023 6/9/2023 AJE. 145245 5/20/23 Admin Pool Allocation $543.69 Period Total ---> $543.69 Cummulative Total ---> $543.69 ,/ $0.00 267-010-25--5311 PROGRAM - PROGRAM SUPPORT - - SALARIES,WAGES EXPENSE May, 2023 5/31/2023 Payroll 33828 Payroll wage expense for period $11,005.63 ending 5/31/2023 Period Total ---> $11,005.63 Cummulative Total ---> $11,005.63 WwP $0.00 267-010-25--5351 PROGRAM - PROGRAM SUPPORT - - FICA,OIC EXP May, 2023 5/31/2023 Payroll 33828 Payroll FICA expense for period $802.50 ending 5/31/2023 Period Total ---> $802.5000 Cummulative Total ---> $802.50 $0.00 267-010-25--5352 PROGRAM - PROGRAM SUPPORT - - L AND I,OIC SHARE May, 2023 5/31/2023 Payroll 33828 Payroll WC expense for period $52.96 ending 5/31/2023 Period Total ---> $52.96 «. Cummulative Total ---> $52.96 $0.00 267-010-25--5353 PROGRAM - PROGRAM SUPPORT - - STATE UCI(ES),OIC EXP May, 2023 5/31/2023 Payroll 33828 Payroll UI expense for period ending $116.66 5/31/2023 General Ledger System OIC OF WASHINGTON For User: Eliza Baysinger Transaction listing by account Fund: CDBG PS 7/1/21-6/30/23 From 5/2023 through 5/2023 Page: Page 2 of 3 Date: 6/12/2023 Tlme: 11:47:10 AM Account Trans. date Trans. type Doc. num. Vendor/Customer Journal description Debit amount Credit amount Period Total ---> $116.66 •M» Cummulative Total ---> $116.66 $0.00 267-010-25--5355 PROGRAM - PROGRAM SUPPORT - - PAID FAMILY MEDICAL LEAVE May, 2023 5/31/2023 Payroll 33828 Payroll cost allocation (PFML) for $82.74 period ending 5/31/2023 Period Total ---> $82.74 Cummulative Total ---> $82.74 $0.00 267-010-25--5360 PROGRAM - PROGRAM SUPPORT - - DISABILITY OIC EXPENSE May, 2023 5/31/2023 Payroll 33828 Payroll cost allocation (LNG DISAB.) $85.29 for period ending 5/31/2023 5/31/2023 Payroll 33828 Payroll cost allocation (SHT DISAB.) $20.40 for period ending 5/31/2023 Period Total ---> $105.690 Cummulative Total ---> $105.69 $0.00 267-010-25--5361 PROGRAM - PROGRAM SUPPORT - - MEDICAL INSURANCE,OIC EXP May, 2023 5/31/2023 Payroll 33828 Payroll cost allocation (EAP SERVIC) $4.89 for period ending 5/31/2023 5/31/2023 Payroll 33828 Payroll cost allocation (MED INS) for $1,884.32 period ending 5/31/2023 Period Total ---> $1,889.21 Cummulative Total ---> $1,889.21 $0.00 267-010-25--5362 PROGRAM - PROGRAM SUPPORT - - LIFE INSURANCE,OIC EXP May, 2023 5/31/2023 Payroll 33828 Payroll cost allocation (LIFE) for $42.07 period ending 5/31/2023 Period Total ---> $42.07 Cummulative Total ---> $42.07 $0.00 267-010-25--5363 PROGRAM - PROGRAM SUPPORT - - PENSION,OIC EXP May, 2023 5/31/2023 Payroll 33828 Payroll cost allocation (PENS.) for $724.13 period ending 5/31/2023 Period Total ---> $724.13 Cummulative Total ---> $724.13 $0.00 267-010-25--5364 PROGRAM - PROGRAM SUPPORT - - ACCRUED PTO EXP May, 2023 5/31/2023 Payroll 33828 Program expense for vacation $753.33 accrued 5/31/2023 OIC OF WASHINGTON For User: Eliza Baysinger Transaction listing by account Fund: CDBG PS 7/1/21-6/30/23 General Ledger System From 5/2023 through 5/2023 Page: Page 3 of 3 Date: 6/12/2023 Time: 11:47:10 AM Account Trans. date Trans. type Doc. num. Vendor/Customer Journal description Debit amount Credit amount 267-010-25- -5910 PROGRAM - PROGRAM SUPPORT - - INSURANCE May, 2023 6/12/2023 AJE 145259 267-010-25- -5912 PROGRAM - PROGRAM SUPPORT - - LIABILITY INSURANCE May, 2023 6/9/2023 AJE 145244 (Funds included: 267-CDBG PS) Period Total ---> $753.33 410 Cummulative Total ---> $753.33 $0.00 5/23 Mgmt Liab Ins - Mid Valley Ins $17.55 Period Total ---> $17.55 -- Cummulative Total ---> $17.55 $0.00 Exp 5/23 Liab Insurance Liberty $0.96 Mutual Period Total ---> $0.96 -� Cummulative Total ---> $0.96 $0.00 Grand Total ---> $20,740.26 General Ledger System OIC OF WASHINGTON Page: Page 1 of 1 For User: Eliza Baysinger Date: 6/14/2023 Transaction listing by account Time: 11:49:17 AM Fund: CDBG PS 7/1/21-6/30/23 From 1/2023 through 4/2023 Account Trans. date Trans. type Doc. num. Vendor/Customer Journal description Debit amount Credit amount 267-010-25- -5411 PROGRAM - PROGRAM SUPPORT - - CREDIT REPORTS April, 2023 4/30/2023 Voucher 206684 ACRANET-CBS BRANCH (V) (Funds included: 267-CDBG PS) 5/23 2304111 ACRAN ET $111.80 Period Total ---> $111.80 — Cummulative Total ---> $111.80 Grand Total ---> $111.80 OIC OF WASHINGTON For User: Eliza Baysinger Transaction listing by account Fund: CDBG PS 7/1/21-6/30/23 General Ledger System From 1/2023 through 4/2023 Page: Page 1 of 3 Date: 6/14/2023 Time: 11:46:36 AM Account Trans. date Trans. type Doc. num. Vendor/Customer Journal description Debit amount Credit amount 267-009-02- -5312 INDIRECT ADMIN - ADMIN. POOL - BASE - - SALARY ADM. ALLOCATION April, 2023 6/9/2023 AJE 145213 4/23 Admin Pool Salary & Benefits $1,173.20 Alloc Period Total ---> $1,173.20 — Cummulative Total ---> $1,173.20 267-009-02- -5354 INDIRECT ADMIN - ADMIN. POOL - BASE - - P/R TAX & BEN. ADM ALLOC. April, 2023 6/9/2023 AJE 145213 4/23 Admin Pool Salary & Benefits $535.14 Alloc Period Total ---> $535.14 -� Cummulative Total ---> $535.14 $0.00 267-009-02- -5999 INDIRECT ADMIN - ADMIN. POOL - BASE - - NON PERSONNEL ADM. ALLOC. January, 2023 6/2/2023 AJE 145106 01/2023 Admin Pool Allocation $226.02 Period Total ---> $226.02 Cummulative Total ---> $226.02 $0.00 February, 2023 6/7/2023 AJE 145121 2/2023 Admin Pool Allocation $109.60 Period Total ---> $109.60 Cummulative Total ---> $335.62 $0.00 March, 2023 6/7/2023 AJE 145169 3/2023 Admin Pool Allocation $17.31 Period Total ---> $17.31 Cummulative Total ---> $352.93 $0.00 April, 2023 6/9/2023 AJE 145202 04/2023 Admin Pool Allocation $550.92 Period Total ---> $550.92 Cummulative Total ---> $903.85 $0.00 267-010-25- -5960 PROGRAM - PROGRAM SUPPORT - - COMMUNICATION February, 2023 6/1/2023 AJE 145079 02/23 Server Costs $17.98 6/2/2023 AJE 145097 02/23 Moses Lake Phone Costs $31.85 Period Total ---> $49.83 Cummulative Total ---> $49.83 ~' $0.00 267-010-50- -5602 PROGRAM - BLDG MAINT/FACILITY - - DEPRECIATION EXP EQUIP January, 2023 5/26/2023 AJE 145012 01/23 Moses Lake Space Costs $0.01 Arrtt/SAX)'r-�.,�, 3 asg .5� �-Rr1 � s.�.-��1�w- t � 3yw� (040) 111,C)o g-79 110 mom �8Ce�_— ��. - M.a�, S�,d hd.�:.. P•e1 SN3. b 9 r 4u3. 85 OIC OF WASHINGTON For User: Eliza Baysinger Transaction listing by account Fund: CDBG PS 7/1/21-6/30/23 General Ledger System From 1/2023 through 4/2023 I Page: Page 2 of 3 Date: 6/14/2023 Tlme: 11:46:36 AM Account Trans. date Trans. type Doc. num. Vendor/Customer Journal description Debit amount Credit amount February, 2023 6/7/2023 AJE 145158 267-010-50- -5611 PROGRAM - BLDG MAINT/FACILITY - - SPACE January, 2023 5/26/2023 AJE 145012 February, 2023 6/7/2023 AJE 145159 267-010-50- -5630 PROGRAM - BLDG MAINT/FACILITY - - UTILITIES January, 2023 5/26/2023 AJE 145012 February, 2023 6/7/2023 AJE 145159 267-010-50- -5640 PROGRAM - BLDG MAINT/FACILITY - - BUILD. REPAIR/MAINT. January, 2023 5/26/2023 AJE 145012 February, 2023 6/7/2023 AJE 145159 267-010-50- -5910 PROGRAM - BLDG MAINT/FACILITY - - INSURANCE January, 2023 5/26/2023 AJE 145013 Period Total ---> $0.01 Cummulative Total ---> $0.01 $0.00 02/23 Moses Lake Space Cost $0.02 Period Total ---> $0.02 Cummulative Total ---> $0.03 $0.00 01/23 Moses Lake Space Costs $33.68 Period Total ---> $33.68 Cummulative Total ---> $33.68 $0.00 02/23 Moses Lake Space Cost $93.75 Period Total ---> $93.75 Cummulative Total ---> $127.43 $0.00 01/23 Moses Lake Space Costs $29.16 Period Total ---> $29.16 Cummulative Total ---> $29.16 $0.00 02/23 Moses Lake Space Cost $45.34 Period Total ---> $45.34 Cummulative Total ---> $74.50 $0.00 01/23 Moses Lake Space Costs $3.50 Period Total ---> $3.50 Cummulative Total ---> $3.50 $0.00 02/23 Moses Lake Space Cost $73.04 Period Total ---> $73.04 Cummulative Total ---> $76.54 -r~ $0.00 01/23 Moses Lake Space Costs $0.04 Period Total ---> $0.04 Cummulative Total ---> $0.04 $0.00 OIC OF WASHINGTON For User: Eliza Baysinger Transaction listing by account Fund: CDBG PS 7/1/21-6/30/23 General Ledger System From 1/2023 through 4/2023 Page: Page 3 of 3 Date: 6/14/2023 Time: 11:46:36 AM Account Trans. date Trans. type Doc. num. Vendor/Customer Journal description Debit amount Credit amount February, 2023 6/7/2023 AJE 145159 267-010-50- -5912 PROGRAM - BLDG MAINT/FACILITY - - LIABILITY INSURANCE January, 2023 5/26/2023 AJE 145013 February, 2023 6/7/2023 AJE 145159 (Funds included: 267-CDBG PS) 144. 02/23 Moses Lake Space Cost $0.21 Period Total ---> $0.21 Cummulative Total ---> $0.25 .,. $0.00 01/23 Moses Lake Space Costs $8.25 Period Total ---> $8.25 Cummulative Total ---> $8.25 $0.00 02/23 Moses Lake Space Cost $13.10 Period Total ---> $13.10 Cummulative Total ---> $21.35 $0.00 Grand Total ---> $2,962.12 Ab -W (0 0 t Q al 3,'