The URL can be used to link to this page

Home My WebLink AboutGrant Related - BOCCGRANT COUNTY BOARD OF COUNTY COMMISSIONERS To: Board of County Commissioners Frcwn: Janice Flynn, Administrative Services Coordinator Da&m May 25, 2023 Re: Authorization for Release of Funds, Dept of Commerce, CDBG #22-62210- 005, Reimbursement #1, Subrecipient O/C Request #1-4 01C has requested reimbursement regarding the above -referenced grant in the amount of $45,461.72 for January — April 2023 expenses. Their documentation is attached for review. 4s,�t � 1.1a I am requesting the release of funds for payment to 01C in the amount of $.51. Thank you. MAY 3 0 2023 21 5C 5C 5( 5C 5C Salary 5311 01C of Washington CDBG Expense Summary - 267 Grant Period: 07/0112022 - 06/3012023 22-62210-005 BILLING PERIOD: JANUARY 2023 $0.00 $11,953.00 YTD BILLED YTD EXPENSED BUDGET BALANCE Description ACCOUNT BUDGET (as of 12131122) (as of 01/31/23) DIFFERENCE (as. of 01/31123) I va OTHER, UBLIC SCRY1 ES IN oP' IN 03US �06.Y;� S --&_QT, ER,_ �"E�V LO E� R.,MENT.J.. _E FWENT 25.50 - Salary 5311 $52,968.00 $51551.25 $5,551.25,ol $47,416.75 FICA, 01C Exp 5351 $3,868.00 $404.19 $404.191 $3,463.81 LAND 1, 01C Share 5352 $305.00 $27.30 $27.30 $277.70 State UC1,01C Exp 5353 $824.00 $58.83 $58.831 $765.17 PFML 5355 $341.00 $44.41 $44.41 $296.59 Disability, 01C Exp 5360 $731.00 $71.45 $71.45 $659.55 Medical Insurance, 01C EXp 5361 $11,187.00 $1,109.04 $1,109.04- $10,077.96 Life Insurance, 01C Exp 5362 $291.00 $28.47 $28.47 - $262.53 Pension, 01C Exp 5363 $3,977.00 $388.59 $388.59.. $3588.41 Accrued PTO Exp 5364 $6,030.00 $527.60 $527.60,-# $5,502.40 Depreciation Exp Equip 5602 $10.00 $2.07 $2.07 0 $7.93 Insurance 5910 $121.00 $10.46 $10.46 ;, $110.54 Communication (Telephone/Cell & ISP) 5960 $723.00 $75.80 $75.80 No, $647.20 I Depreciation Exp Bldg 5601 $75.00 $20.38 $20.38410 $54.62 I.Space 5611- $40.00 $0.00 $40.00 Utilities 5630 $71.00 $0.00 $71.00 )-Build Repair/Maint. 5640 $88.00 $0.00 $88.00 Liability Insurance 5912 $22.00 $0.00 $22.00 -S, BTPT 8 2 3 -84'- 7Z I S8T 4V Salary 5311 $11,953.00 $0.00 $11,953.00 FICA, 01-C Exp 5351 $873.00 $0.00 $873.00 LAND 1, 01C Share 5352 $76.00 $0.00 $76.00 State UC1,01C Exp 5353 $180.00 $0.00 $180.00 PFML 5355 $76.00 $0.00 $76.00 Disability, 01C Exp 5360 $170.00 $0.00 $170.00 Medical -Insurance, 01C Exp 5361 $2,240.00 $0.00 $2,240.00 Life Insurance, 01C Exp 5362 $68.00 $0.00 $68.00 Pension, 01C Exp 5363 $884.00 $0.00 $884.00 Accrued PTO Exp 5364 $1,366.00 $0.00 $15366.00 Insurance 1 5910 $42.00 $0.00 $42.00 -0 0 -8 �,�_$UBTOTAL�!V- 7 *� -A -N F' MAV�`-- Mh. v Ftb §A P-VEIZOPMENTIENERGY.-, Salary Admin. Allocation 5312 $14,458.00 $915.40 $915.40 $13,542.60 P/R Tax & Ben. Adm Allocation 5354 $7,116.00 $449.74 $449.74- $6,666.26 .Non Personnel Adm. Allocation 5999 $3,326.00 $0.00 $3,326.0 QBTOTAL" $24 __90'0 -00.' 365.14�7' _'�6 4- 23 -634 I:TATAN ON SHARE MAC COU NTI NG\Acco u nting_Eliza\G rants -C ontracts\Grants-C o ntracts 20222023\267CDBG (EB)\2- Billings\YR 2\CDBG_Expense Tracking Summary -267 5/24/2023 General Ledger System OIC OF WASHINGTON For User: Eliza Baysinger Transaction listing by account Fund: CDBG PS 7/l/21-6/30/23 From 1/2023 through 1/2023 Page: Page 1 of 3 Date: 5/24/2023 TIme: 3:13:53 PM Account Trans. date Trans. type Doc. num. Vendor/Customer Journal description Debit amount Credit amount 267-009-02- -5312 2�®IRECT ADMIN -ADMIN. POOL -EASE - - SALARY ADM. M. ALLOCATION January, 2023 2/28/2023 AJE 144031 1/23 Admin Pool Salary & Benefits $915.40 Alloc Period Total ---> $915.40 Cummulative Total ---> $915.40 267-009-02- -5354 INDIRECT ADMIN -ADMIN. POOL -BASE - -P/RTAX & BEN. ADM ALLOC. January, 2023 .2/28/2023 AJE 144031 1123 Admin. Pool Salary & Benefits $449.74 Alloc Period Total ---> .$449.74 Cummulative Total ---> $449.74 $0.00 267-010-25--5311 PROGRAM - PROGRAM SUPPORT - SALARIESWAGES EXPENSE January, 2023 1131/2023 Payroll 33122 Payroll wage expense for period $5,551.25 ending 1/31/2023 Period Total ---> $5,551.25 Cummulative Total ---> $5,551.25-,, $0.00 267-010-25--5351 PROGRAM - PROGRAM SUPPORT.- FICAOIC EXP January, 2023 1131/2023 Payroll 33122 Payroll FICA expense for period $404.19 ending 1/31/2023 Period Total ---> $404.19 Cummulative Total ---> $404.19 $0.00 267-010-25--5352 PROGRAM - PROGRAM SUPPORT - L AND I,OIC SHARE January, 2023 1/31/2023 Payroll 33122 Payroll WC expense for period $27.30 ending 1/31/2023 Period Total ---> $27.30 Cummu lative. Total ---> $27.30 $0.00 267-010-25--5353. PROGRAM - PROGRAM SUPPORT - STATE UCI(ES),OIC EXP January, 2023 1/31/2023 Payroll 33122 Payroll UI expense for period ending $58.83 1/31/2023 Period Total ---> Cummulative Total ---> $58.83 $0.00 267-010-25--5355 PROGRAM - PROGRAM SUPPORT - - PAID FAMILY MEDICAL LEAVE January, 2023 1/31/2023 Payroll 33122 Payroll cost allocation (PFML) for $44.41 period ending 1/3112023 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 1/2023 Account Trans. date Trans. type Doc. num. Vendor/Customer 267-010-25--5360 PROGRAM - PROGRAM SUPPORT - - DISABILITY OIC EXPENSE January, 2023 1/31/2023 Payroll 33122 1/31/2023 Payroll 33122 267-010-25--5361 PROGRAM - PROGRAM SUPPORT - - MEDICAL INSURANCE,OIC EXP January, 2023 1/31/2023 Payroll 33122 1/3112023 Payroll 33122 267-010-25--5362 PROGRAM - PROGRAM SUPPORT - - LIFE INSURANCE,OIC EXP January, 2023 1/31/2023 Payroll 33122 267-010-25--5363 PROGRAM - PROGRAM SUPPORT - - PENSION,OIC EXP January, 2023 1/31/2023 Payroll 33122 267-010-25--5364 PROGRAM - PROGRAM SUPPORT - - ACCRUED PTO EXP January, 2023 1/31/2023 Payroll 33122 267-010-25- -5602 PROGRAM - PROGRAM SUPPORT - - DEPRECIATION EXP EQUIP January, 2023 4/10/2023 AJE 144508 Page: Page 2 of 3 Date: 5/24/2023 Time: 3:13:54 PM Journal description Debit amount Credit amount Period Total ---> $44.41 Cummulative Total ---> $44.41,-,, $0.00 Payroll cost allocation (LNG DISAB.) $57.60 for period ending 1/31/2023 Payroll cost allocation (SHT DISAB.) $13.85 for period ending 1/31/2023 Period Total ---> $71.45 Cummulative Total ---> $71.45,e $0.00 Payroll cost allocation (EAP SERVIC) $2.58 for period ending 1/31/2023 Payroll cost allocation (MED INS) for $1,106.46 period ending 1/31/2023 Period Total ---> $1,109.04 Cummulative Total ---> $1,109.04- $0.00 Payroll cost allocation (LIFE) for $28.47 period ending 1/31/2023 Period Total ---> $28.47 Cummulative Total ---> $28.47 - $0.00 Payroll cost allocation (PENS.) for $388.59 period ending 1/31/2023 Period Total ---> $388.59 _ Cummulative Total ---> $388.59 - $0.00 Program expense for vacation $527.60 accrued 1/31/2023 Period Total ---> $527.60 Cummulative Total ---> $527.60- $0.00 1/23 SERVER DEPRECIATION $2.07 EXPE General- Ledger System Page: Page 3 of 3Date: OIC OF WASHINGTON For User: Eliza Baysinger 5/24/2023 Transaction listing by account TIme: 3:13:54 PM Fund: CDBG PS 7/1/21-6/30/23 From 1/2023 through 1/2023 1 Account Trans. date Trans. type Doc. num. Vendor/Customer Journal description Debit amount Credit amount Period Total $2.07 Cummulative Total ---> $2.07. $0.00 267-010-25- -5910 PROGRAM - PROGRAM SUPPORT - INSURANCE January, 2023 2/15/2023 AJE 143940 1/23 Mgmt Liab Ins - Mid Valley Ins $10.46 Period Total ---> $10.46 Cummulative Total ---> $10.46 $0.00 267-010-25- -5960 PROGRAM - PROGRAM SUPPORT - COMMUNICATION January, 2023 4/19/2023 AJE 144632 1/23 Verizon $54.18 5/9/2023 AJE 144829 01/23 Server Costs $7.88 5/10/2023 AJE 144848 01/23 MOSES LAKE PHONE $13.74 COSTS Period Total ---> $75.80 Cummulative Total ---> $75.80..." $0.00 267-010-50- -5601 PROGRAM - BLDG MAINT/FACILITY - DEPRECIATION EXP.BLDG. January, 2023 4/10/2023 AJE 144529 1/23 DEPRECIATION EXPENSE $20.38 Period Total ---> $20.38 Cummulative Total ---> $20.38, $0.00 Grand Total ---> $9,684.98 (Funds included: 267-CDBG PS) 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: � j J OIC. OF WASHINGTQN 22-62210-005 815 FRUITVAL'E,BLVD REPORT PERIOD: Printed Name: ELIZA BAYSINGER " YAKIMA - WA -98902': ' ` Jan -23 REPORT NUMBER: Title: SENIOR ACCOUNTANT 13 Date: 5/24/2023 TOTAL AMOUNT REQUESTED THIS PERIOD: $9,684.98 1. Name of Service Program: Asset Development & Other Asset Development 24 FCDIRG amount requested for these program activities this period: $8,319.84 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 146 CDBG amount requested for these program activities this period:- $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 Assist Admin -Indirect Admin TDBG amount requested for these program activities this period: $19365.14 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 IICDBG amount requested for these program activities this period: $0.00 WASHINGTON STATE DEPARTMENT OF COMMERCE ia�s y°�n AGENCY NUMBER 1030 IDIS PROJECT NUMBER 2021-0019 Commerce C Number A 2V-62210-005 A19 VOUCHER DISTRIBUTION AGENCY NAME DEPARTMENT OF COMMERCE ATTN: CDBG PO BOX 42525 OLYMPIA, WA 98504-2525 INSTRUCTIONT' VENDOR OR CLAIMANT. S: .yP;M!tq this form to claimpayment for materials, merchandise or services. Show.:complete detail for each item. Vendor's Certificate: I hereby certify under perjury that the items and totals listed herein are proper charges for materials, merchandise or services furnished to the State of Washington, and that all goods furnished. andlor services rendered have been provided without discrimination because of age, sex, marital status, race, creed, color, national origin, handicap, religion. or Vletriam'era or disabled veterans status VENDOR OR CLAIMANT (Warrant is to be payable to:) Grant County PO Box 37y: Ephrata, WA 98823 REPORTING PERIOD: February 2023 BL. ) (TITLE) (D/TE) Description QUANTITY AMOUNT IDIS PREVIOUSLY AMOUNT REMAINING Activity ID BUDGET REQUESTED THIS INVOICE BALANCE 8622 05Z - Other Public Services not in 03T,05A-05Y $ 1249500.00 95684.98 119342.42 $103472.60 $0.00 8623 21A - General Program Administration $ 31500.00 1 $0.00 $0.00 $35500.00 $0.00 - - $ - $0.00 - - $ - $0.00 - - $ - $0.00 - - $ - $0.00 - - $ - $0.00 TOTAL PAYMENTREQUEST $1289000.00 $904.98 115342.42 $106,972.60 Everything below this tine is for Dept of Commerce FED TAX ID # ;- ;: RROGRAM APPROVAL (The, nd��ilual signin .this voucher warrants the have the authority to sign this voucher. Y 5 I TED NAM RSIGNATURE, E e' ,J fF Hirickle , ,DATE. DOC, DATE : :..,: _. _. CURRENT DOC,: NO ;'. : REFERENCE DOCVENDOR NUMBER .. O�102426 03 ACCOUNT( = :. = . TN :._., _;......... - , .... ASD - . NUMBER 43260 VENDOR MESSAGE CDBG S. s - .: TRANS.. : 0 .. MA TER :' =. SUB -:..SUB _ _., ... . INDE ' DEX ;. OBJ D_ .... . :....:...... .. OBJ, GL ACCT : SUBS D I INVOICE AMOUt1T NUMBER 622FO320 NZ $ 12800.00 22-62210-005 0 - $ _ 0 $ _ 0 $ _ - $ - SIGNATURE OF ACCOUNTING PREPARER FOR PAYMENT DATE WARRANT TOTAL ACCOUNTING APPROVAL FOR PAYMENT DATE STATE Or wASIIINGTON COMMUNITY DEVELOPMENT BLOCK GRANT - PUBLIC SERVICES GRANTS DEPT OF COMMERCE G ATTN: CDBPROGRAM AT BOX 4CERTIFICATION: I certify that the information on this form is a OLYMPIA, WA 98_>"04-2525 true and accurate report of the cash status and that all reported expenditures are properly chargeable to the referenced grant. COMMUNITY ACTION AGENCY SUBRECIP_ IENT: CONTRACT NO: Signature: OIC .OF WASHINGTQN 22-62210-005 .815 FRO. REPORT PERIOD: Printed Name: EL ZA BAYSINGER YAKIMA WA 98902 Feb -23 REPORT NUMBER: Title: SENIOR ACCOUNTANT 14 Date: 5/24/2023 TOTAL AMOUNT REQUESTED THIS PERIOD: $11,342.42 1. Name of Service Program: Asset Development & Other Asset Development 23 IFCDBG amount requested for these program activities this period: $10,247.78 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. J 2. Name of Service Program: Energy Assistance 158 1jCDBG amount requested for these program activities this period: $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 Assist Admin -Indirect Admin CDBG amount requested for these program activities this period: $1,094.64 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 this period: $0.00 Salary 5311 $52,968.00 $51551.25 $12,141.39 $6,590.14 if $40,826.61 FICA, OIC Exp 5351 $3,868.00 $404.19 .$885.41 $481.22- $2,982.59 LAND 1, OIC Share 5352 $305.00 $27.30 $58.04 $30.74 $246.96 State UCI,OIC Exp 5353 $824.00 $58.83 $128.68 $69.85- $695.32. PFML 5355 $341.00 $44.41 $105.80 $61.39- $235.20 Disability, OIC Exp 5360 $731.00 $71.45 $171.19 $99.74- $559.81 Medical Insurance, OIC Exp 5361 $115187.00 $1,109.04 $2,629.84 $1,520.80 - $85557.16 Life Insurance, OIC Exp 5362 $291.00 $28.47 $68.15 $39.68 $222.85 Pension, OIC Exp 5363 $3,977.00 $388.59 $925.77 $537.18- $3;051.23 Accrued PTO Exp 5364 $6,030.00 $527.60 $1,212.44 $684.84 - $4,817.56 Depreciation Exp Equip 5602 $10.00. $2.07 $4.87 $2.80- $5.13 Insurance 5910 $121.00 $10.46 $24.84 $14.38-- $96.16 Communication (Telephone/Cell & ISP) 5960 $723.00 $75.80 $160.92 $85.12- $562.08 -Depreciation Exp Bldg 5601 $75.00 $20.38 $50.28 $29.90- $24.721 .Space 5611 $40.00 $0.00 $40.00 1 -Utilities 5630 $71.00 $0.00 $71.00 i Build Repair/Maint. 5640 $88.00 $0.00 $88.00 i.Liability Insurance 5912 $22.00 $0.00 $22.00 :.'SUBTOTAL`,..�_�-.- - ...: - - . " I � .$81;672 '00.� _: t :: . .7 - 9 -84 8l_,55T '6 Oil- I 04.1 IFNFR6 SSISTA F41941::i' Salary 5311 $11;953.00 $0.00 $11,953.00 FICA, OIC Exp 5351 $873.00 $0.00 $873.00 .LAND 1, OIC Share 5352 $76.00 $0.00 $76.00 State UCI,OIC Exp 5353 $180.00 $0.00 $180.00 .PFML 5355 $76.00 $0.00 $76.00 Disability, OIC Exp 5360 $170.00 $0.00 $170.00 Medical Insurance, OIC Exp 5361 $2,240.00 $0.00 $23240.00 Life Insurance, OIC Exp 5362 $68.00 $0.00 $68.00 .Pension, OIC Exp 5363 $884.00 $0.00 $884.00 Accrued PTO Exp 5364 $1,366.00 $0.00 $1,366.00 .Insurance 5910 1 $42.00 1 1 1 $0.00 1 $42.00 '0 I t $0 0 `$17-9 SVBTOTAL 2 'P-ZT"*-., DF F1 -()P-M'F.NTIFNF'PrYA.R.Rll.qTA'Nr-.F-:-.AnMIN IPI=rT-:-Inno_-nqi Salary Admin. Allocation 5312 $143458.00 $915.40 $1,662.89 $747.49.. $12,795.11 P/R Tax & Ben. Adm Allocation 5354 $7,116.00 $449.74 $796.89 $347.15-- $6,319.11 Non Personnel Adm. Allocation 5999 $3,326.00 $0.00 $3,326.00 SUBTOTAL. $24 90 000 9 4 -365i.114 78 `,-,�-`�,`$11094.6 A40' -22 Q00§4tREC101 Contract Recipient Fee 5415 $33500.00 1 $0.00 $3,500.00 SU 500 00 -'$o 0 TOTAL:.. i'O o.DO— _$3 _000 684.9 .60 -972. 06 027.41 TOTAL: RANT IADATANON SHARE MAC CO U NTI NG\Acco unting_E Iiza\G rants -C o ntra cts\G rants -C ontracts 20222023\267CDBG (EB)\2- BillingskYR 2\C DBG_Expen se Tracking Summary- 267 5/24/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 2/2023 through 2/2023 Account Trans. date Trans. type Doc. num. vendor/Customer Journal description Page: Page 1 of 3, Date: 5/24/2023 Time: 3:15:05 PIVI Debit amount Credit amount 267-009-02- -5312 INDIRECT ADMIN - ADMIN. POOL - BASE - - SALARY ADM. ALLOCATION February, 2023 3/15/2023 AJE 144266 2/23 Admin Pool Salary & Benefits $747.49 Alloc I Period Total $747.49 Cummulative Total ---> $747.49 267-009-02- -5354 INDIRECT ADMIN -ADMIN. POOL -BASE - - PIR TAX & BEN. ADM ALLOC. February, 2023 3/1512023 AJE 144266 2/23 Admin Pool Salary & Benefits $347.15 Alloc Period Total ---> $347.15 oop, Cummulative Total ---> $347.15 $0.00 267-010-25--5311 PROGRAM - PROGRAM SUPPORT - SALARIESWAGES EXPENSE February, 2023 2/28/2023 Payroll 33242 Payroll wage expense for period $5,300.37 ending 2/28/2023 2/28/2023 Payroll 33242 Payroll wage expense for period - $1,289.77 ending 2/2812023 Period Total ---> $6,590.14 Cummulative Total ---> $6,590.14- $0.00 267-010-25--5351 PROGRAM - PROGRAM SUPPORT - FICAOIC EXP February, 2023 2/28/2023 Payroll 33242 Payroll FICA expense for period $387.17 ending 2/28/2023 2/28/2023 Payroll .33242 Payroll FICA expense for period $94.05 ending 2/28/2023 Period Total ---> $481.22 Cummulative Total ---> $481.22- $0.00 267-010-25--5352 PROGRAM - PROGRAM SUPPORT - L AND I,OIC SHARE February, 2023 2/28/2023 Payroll 33242 Payroll WC expense for period $25.55 ending -2/28/2023 2/28/2023 Payroll 33242 Payroll WC expense for period $5.19 ending 2/28/2023 Period Total ---> $30.74 Cummulative Total ---> $30.74- $0.00 267-010-25--5353 PROGRAM - PROGRAM SUPPORT STATE UCI(ES),OIC EXP February, 2023 2/28/2023 Payroll 33242 Payroll UI expense for period ending $56.18 2/28/2023 General Ledger System OIC OF WASHINGTON For User: Eliza Baysinger Transaction listing by account Fund: CDBG PS 7/1/21-6130/23 From 2/2023 through 2/2023 Account Trans. date Trans. type Doc. num. Vendor/Customer Journal description Page: Page 2 of 3 Date: 5/24/2023 Time: 3:15:06 PM Debit amount Credit amount February, 2023 2/28/2023 Payroll 33242 Payroll UI expense for period ending $13.67 2/28/2023 Period Total ---> $69.85 Cummulative Total ---> $69.85 $0.00 267-010-25--5355 PROGRAM - PROGRAM SUPPORT - - PAID FAMILY MEDICAL LEAVE February, 2023 2/28/2023 Payroll 33242 Payroll cost allocation (PFML) for $61.39 period ending 2/28/2023 Period Total ---> $61.39 Cummulative Total ---> $61.39 $0.00 267-010-25--5360 PROGRAM - PROGRAM SUPPORT - DISABILITY OIC EXPENSE February, 2023 2/28/2023 Payroll 33242 Payroll cost allocation (LNG DISAB.) $80.45 for period ending 2/28/2023 2/28/2023 Payroll 33242 Payroll cost allocation (SHT DISAB.) $19.29 for period ending 2/28/2023 Period Total ---> $99.74 Cummulative Total ---> $99.74 $0.00 267-010-25--5361 PROGRAM - PROGRAM SUPPORT - MEDICAL INSURANCEOIC EXP February, 2023 2/28/2023 Payroll 33242 Payroll cost allocation (EAP SERVIC) $4.10 for period ending 2/28/2023 2/28/2023 Payroll 33242 Payroll cost allocation (MED INS) for $1,516.70 period ending 2/28/2023 Period Total $1,520.80 -- Cummulative Total ---> $1,520.80 $0.00 267-010-25--5362 PROGRAM - PROGRAM SUPPORT - LIFE INSURANCE,OIC EXP February, 2023 2/28/2023 Payroll 33242 Payroll cost allocation (LIFE) for $39.68 period ending 2/2812023 Period Total ---> $39.68- Cummulative Total ---> $39.68 $0.00 267-010-25--5363 PROGRAM - PROGRAM SUPPORT - - PENSION,OIC EXP February, 2023 2/28/2023 Payroll 33242 Payroll cost allocation (PENS.) for $537.18 period ending 2/28/2023 Period Total ---> $537.18 Cummulative Total ---> $537.18 $0.00 267-010-25--5364 PROGRAM - PROGRAM SUPPORT - - ACCRUED PTO EXP OIC OF WASHINGTON For User: Eliza Baysinger Transaction listing by account Fund: CDBG PS 7/1/21-6/30/23 General Ledger System From 2/2023 through 2/2023 Page: Page 3 of 3 Date: 5/24/2023 Time: 3:15:06 PM Account Trans. date Trans. type Doc. num. Vendor/Customer Journal description Debit amount Credit amount February, 2023 2/28/2023 Payroll 33242 2/28/2023 Payroll 33242 267-010-25- -5602 PROGRAM - PROGRAM SUPPORT - - DEPRECIATION EXP EQUIP February, 2023 5/11/2023 AJE 144873 267-010-25- -5910 PROGRAM - PROGRAM SUPPORT - - INSURANCE February, 2023 3/14/2023 AJE 144228 267-010-25- -5960 PROGRAM - PROGRAM SUPPORT - - COMMUNICATION February, 2023 4/19/2023 AJE 144649 267-010-50- -5601 PROGRAM - BLDG MAINT/FACILITY - - DEPRECIATION EXP BLDG. February, 2023 5/2/2023 AJE 144793 (Funds included: 267-CDBG PS) Program expense for vacation $574.52 accrued 2/28/2023 Program expense for vacation $110.32 accrued 2/28/2023 Period Total ---> $684.84 Cummulative Total ---> $684.84 $0.00 2/23 Server Depr Expense $2.80 Period Total ---> $2.80 Cummulative Total ---> $2.80 $0.00 2/23 Mgmt Liab Ins- Mid Valley Ins $14.38 Period Total ---> $14.38 " Cummulative Total ---> $14.38 $0.00 2/23 Verizon $85.12 Period Total ---> $85.12 Cummulative Total ---> $85.12 $0.00 2/23 ML - Depreciation expe $29.90 Period Total ---> $29.90 Cummulative Total ---> $29.90 $0.00 Grand Total ---> $11,342.42 ;c .t��n� WA.S INGT N STATE O� . tr = DEPARTMENT OF COMERLE . Ayr , r� � k.I.a0'" AGENCY NUMBER IDIS PROJECT NUMBER Commerce Can at Number A19 VOUCHER DISTRIBUTION 1030 2021-0019 -622' ®®®d5 AGENCY NAME WSTRUCfIQN,TOVENDORORCLAIM- .: DEPARTMENT OF COMMERCE Submit this form to "claim payment for materials, merchandise or services __ ..1_1 r ATTN: CDEG Show conipiete detail foreach item " . ;:`1.1. - PO BOX 42525 - _ OLYMPIA, WA 98504-2525 Vender's Certificate I hereby certifyunder perjury that the items and totals listed herein are praper,charges for materials; merchandise or services furnished to the State of Washington, and VENDOR OR CLAIMANT (Warrant is to be payable to:) that ail.goods furnished and/or services rendered have been' proVided without discrimination because of age, sex, marital status, race, creed, col_'7_i ational origin, handicap, religion.-. Vietnam era or. disabled: veterans"status Grant COtality PO Box 37 �y. -. " Ephrata, WA 98823 I N I N B LU F I N K . . __ _ - :-'�i-�-! .: ''..."'"....' _. � - . - �. - . -1- ,- !'-,. 7��_-.' -�"�!. - - ' - - -, I . I I-- I . � ..' * �. I - . . � . .- - :� " �. - ' _. � � -.4 I � .. �*_� �_A I . . ,::, .-- ,-. '. .~,. . .. � ,- -_ I __' _... _� - I '. ' " - '' _; " - . I� - . - .� * . I -, _ - , - _ - � '.1 _ " .- .. t".� (TITLE) _ (DATE} REPORTING PERIOD: March 2023 Description QUANTITY AMOUNT IDIS - PREVIOUSLY AMOUNT REMAINING Activity ID BUDGET REQUESTED THIS INVOICE BALANCE 8622 05Z - Other Public Services not in 03T,05A-05Y $ 1249500.00 21,027.40 6,210.57 $975262.03 $0.00 8623 21A - General Program Administration $ 31500.00 $0.00 $0.00 $3,500.00 1 $0.00 - - $ - $0.00 - - $ - $0.00 - - $ - $0.00 - - $ - $0.00 - - $ - $0.00 TOTAL PAYMENT REQUEST $128,000.00 $219027.40 6,210.57 $100,762.03 Everything below this line is for Dept of Commerce _;, ?. FEDTAXID#.. . ..__._.. _. . . _... _ . _. PROGRAM M PP O _R RA A R VAL The.individuat i nin this -. - . _ . ... .a.. _ -- .., voucherwarrantsthe have ha he authors to sign rrthis Voucher: ' ::;. _ .. . _ _:..... _ . ,..-: .. __ ; .9. __. _... . '. .. S P TE : - :PRINTED D NAME: IGNAT ._ - .. . _.: .....:: .- ,.1. e -:.:• ::..J ff:.Hlnc e,.1.f. 9. - -: DOG DA E.' T _ :. t:.. -: :._ . _ .._.. _. .. . C C.° c URRENT DO . NO _. REFERENCE. ,--.0 0. r :.,, ... r. _:: .. - •_.....�.._,- _moi _. . -.: ....:.. _. : . _:. t. .. ... .. .: - ... _ - a. . �' .. - - - - . 000242 A COUNT NO =-: .._ ,...... . _ ::. `; _ __ . _._. _,. _ _. ._ _ _ _:. _ ... :,. __: _ , _._ _. _ _ ........_ ..._... _:.. . _ ...: j.. ... ASI) NUMBER'<-. _.. >. ; .VENDOR:MESSAGE,,` = 4, 326 0 CDB G M :_ , . _ u .. _ .S B . -. : - T NS . ' 0 . MASTER . .: :SUB - - ` :.:; _ _...: _ . ..: _,,.._ -__ S B. .:... ,. .. _.: - _ ....... "::.. .. ::. _ _ _ _ _ .,:.. :. GL, ACCT _.- .. _. - _ : ... , SU S - BID . . INVOICE E „, ;: C D ::. D , ;:' IND X :>:'OBJ 0 E -OBJ' = AMOUNT . NUMBER 622F0320 NZ $ 128,000.00 22-62210-005 0 $ _ 0 - o $ - 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 BOA 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: f _� CONTRACT NO: Signature: OIC OF WASHINGTON 22-62210-005 81 S TRUTTVALE BLVD ,. REPORT PERIOD: Printed Name: ELIZA BAYSINGER �. YAKIIVIA WA 98902':':'... Mar -23 REPORT NUMBER: Title: SENIOR ACCOUNTANT 15 Date: 5/24/2023 TOTAL AMOUNT REQUESTED THIS PERIOD: $6,210.57 1. Name of Service Program: Asset Development & Other Asset Development 25 11CDBG amount requested for these program activities this period: $5,746.34 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 294 IICDBG amount requested for these program activities this period: $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 Assist Admin -Indirect Admin [CDBG amount requested for these program activities this period: $464.23 " 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 IICDBG amount requested for these program activities this period: $0.00 51 51 51 51 51 BUDGET BALANCE DIFFERENCE I (as of 03/31/23) Salary 5311 $52,968.00 $12,141.39 $15,890.93 $31749.54,, $37,077.07 FICA, OIC Exp 5351 $3,868.00 $885.41 $1,156.78 $271.371. $2,711.22 LAND 11 Olt Share 5352 $305.00 $58.04 $75.27 $17.231. $229.73 State UC1,01C Exp 5353 $824.00 $128.68 $168.42 $39.74 - $655.58 PFML 5355 $341.00 $105.80 $135.81 $30.01 $205.19 Disability, OIC Exp 5360 $731.00 $171.19 $219.28 $48.09,-- $511.72 Medical Insurance, OIC Exp 5361 $11,187.00 $2,629.84 $3,446.36 $816.52 $75740.64 Life Insurance, OIC Exp 5362 $291.00 $68.15 $87.38 $19.23 $203.62 Pension, OIC Exp 5363 $3,977.00 $925.77 $1,188.24 $262.47 $2,788.76 Accrued PTO Exp 5364 $6,030.00 $1,212.44 $17610.70 $398.26 - $4,419.30 Credit Reports 5411 $0.00 $0.00 $28.90 $28.90 ($28.90) Depreciation Exp Equip 5602 $10.00 $4.87 $4.87 $0.00 $5.13 Insurance 5910 $121.00 $24.84 $30.65 $5.81 $90.35 Communication (Telephone/Cell & ISP) 5960 $723.00 $160.92 $186.99 $26.07,11 $536.01 Depreciation Exp Bldg 5601 $75.00 $50.28 $83.38 $33.10-1 ($8.38) Space 5611 $40.00 $0.00 $40.00 Utilities 5630 $71.00 $0.00 $71.00 i.Build Repair/Maint. 5640 $88.00 $0.00 $88.00 Liability Insurance 5912 $22.00 $0.00 $22.00 T OTAL _, = : _ :_ : 81 672.00 = 18 567:62 13'58'04. '. ai AY'I�M Salary 5311 $11,953.00 $0.00 $11,953.00 FICA, OIC -Exp 5351 $873.00 $0.00 $873.00 .LAND 1, OIC Share 5352 $76.00 $0.00 $76.001 State UC1,01C Exp 5353 $180.00 $0.00 $180.00 PFML 5355 $76.00 $0.00 $76.00 Disability, OIC Exp 5360 $170.00 $0.00 $170.00 Medical Insurance, OIC Exp 5361 $21240.00 $0.00 $2,240.00 Life Insurance, OIC Exp 5362 $68.00 $0.00 $68.00 Pension, OIC Exp 5363 $884.00 $0.00 $884.00 .Accrued PTO Exp 5364 $1,366.00 $0.00 $1,366.00 .Insurance 5910 $42.00 $0.00 $42.00 -SUBTOTAL' 7-928.0,07�.l�l---"*"--:'---'�' • 0 hm-nit, Salary Admin. Allocation 5312 $143458.00 $1,662.89 $1,998.23 $335.34 $12,459.77 P/R Tax & Ben. Adm Allocation 5354 $7,116.00 $796.89 $925.78 $128.8910, $6,190.22 'Non Personnel Adm. Allocation 5999 $3,326.00 $0.0,0 $3,326.00 :SUBTOTAL_ T -$24 .9 .-0 00 - 59.78 24. 64.23 2 0 77 4.5- AGT :REG t 7 (7. -�NT 0 TP Contract Recipient Fee 5415 $3,500.00 $0.00 $3,500.00 V`$3 500 00' L ...... .00 U B TOTAL $ 0 . 00 0. $ :i�l 97 210 te - 1 0 i 60 TOTAL RANT 2800 .001 2 027 40' IADATANON SHAREMAC CO U NTI NG\Acco u nting_Eliza\G ran ts-C o ntracts\G rants -C ontracts 20222023\267CDBG (EB)\2- Billings\YR 2\C DBG_Expense Tracking Summary- 267 5/24/2023 t General Ledger System OIC OF WASHINGTON For User: Eliza Baysinger Transaction listing by account Fund: CDBG PS 7/1/21-6/30/23 From 3/2023 through 3/2023 Page: Page 1 of 3 Date: 5/24/2023 TIme: 3:15:52 PM 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 March, 2023 5/11/2023 AJE 144879 3/23 Admin Pool Salary & Benefits $335.34 Alloc Period Total ---> $335.34 Cummulative Total ---> $335.34 267-009-02- -5354 INDIRECT ADMIN - ADMIN. POOL - BASE - PIR TAX & BEN. ADM ALLOC. March, 2023 5/11/2023 AJE 144879 3/23 Admin Pool Salary & Benefits $128.89 Alloc Period Total ---> $128.89 Cummulative Total ---> $128.89 $0.00 267-010-25--5311 PROGRAM - PROGRAM SUPPORT - SALARIESWAGES EXPENSE March, 2023 3/31/2023 Payroll 33431 Payroll wage expense for period $3,749.54 ending 3/3112023 Period Total ---> $3,749.54— Cummulative Total ---> $3,749.54 $0.00 267-010-25--5351 PROGRAM - PROGRAM SUPPORT - FICA,OIC EXP March, 2023 3/31/2023 Payroll 33431 Payroll FICA expense for period $271.37 ending 3/31/2023 Period Total $271.37--* Cummulative Total ---> $271.37 $0.00 267-010-25--5352 PROGRAM - PROGRAM SUPPORT - - L AND IOIC SHARE March, 2023 3/31/2023 Payroll 33431 Payroll WC expense for period $17.23 ending 3/31/2023 Period Total ---> $17.23 Cummulative Total ---> $17.23 $0.00 267-010-25--5353 PROGRAM - PROGRAM SUPPORT - STATE UCI(ES),OIC EXP March, 2023 3/31/2023 Payroll 33431 Payroll UI expense for period ending $39.74 3/31/2023 Period Total $39.74 Cummulative Total ---> $39.74 $0.00 267-010-25--5355 PROGRAM - PROGRAM SUPPORT - PAID FAMILY MEDICAL LEAVE March, 2023 3/31/2023 Payroll 33431 Payroll cost allocation (PFML) for $30.01 period ending 3/3112023 OIC OF WASHINGTON For User: Eliza Baysinger Transaction listing by account Fund: CDBG PS 7/1/21-6/30/23 General Ledger System From 3/2023 through 3/2023 Account Trans. date Trans. type Doc. num. Vendor/Customer 267-010-25--5360 PROGRAM - PROGRAM SUPPORT - - DISABILITY OIC EXPENSE March, 2023 3/31/2023 Payroll 33431 3/31/2023 Payroll 33431 267-010-25--5361 PROGRAM - PROGRAM SUPPORT - - MEDICAL INSURANCE,OIC EXP March, 2023 3/31/2023 Payroll 33431 3131/2023 Payroll 33431 267-010-25--5362 PROGRAM - PROGRAM SUPPORT - - LIFE INSURANCE,OIC EXP March, 2023 3/31/2023 Payroll 33431 267-010-25--5363 PROGRAM - PROGRAM SUPPORT - - PENSION,OIC EXP March, 2023 3/31/2023 Payroll 33431 267-010-25--5364 PROGRAM - PROGRAM SUPPORT - - ACCRUED PTO EXP March, 2023 3/31/2023 Payroll 33431 267-010-25- -5411 PROGRAM - PROGRAM SUPPORT - - CREDIT REPORTS March, 2023 3/31/2023 Voucher 206114 ACRANET-CBS BRANCH (V) Page: Page 2 of 3 Date: 5/24/2023 Time: 3:15:53 PM Journal description Debit amount Credit amount Period Total ---> $30.01-. Cummulative Total ---> $30.01 $0.00 Payroll cost allocation (LNG DISAB.) $38.75 for period ending 3/31/2023 Payroll cost allocation (SHT DISAB.) $9.34 for period ending 3/31/2023 Period Total ---> $48.09 - Cummulative Total ---> $48.09 $0.00 Payroll cost allocation (EAP SERVIC) $1.48 for period ending 3/31/2023 Payroll cost allocation (MED INS) for $815.04 period ending 3/31/2023 Period Total ---> $816.52 Cummulative Total ---> $816.52 $0.00 Payroll cost allocation (LIFE) for $19.23 period ending 3/31/2023 Period Total ---> $19.23 — Cummulative Total ---> $19.23 $0.00 Payroll cost allocation (PENS.) for $262.47 period ending 3/31/2023 Period Total ---> $262.47 — Cummulative Total ---> $262.47 $0.00 Program expense for vacation $398.26 accrued 3/31/2023 Period Total ---> $398.26 -- Cummulative Total ---> $398.26 $0.00 3123 2303112 ACRANER $28.90 OIC OF WASHINGTON For User: Eliza Baysinger Transaction listing by account Fund: CDBG PS 7/l/21-6/30/23 Account Trans. date Trans. type General Ledger System From 3/2023 through 3/2023 Doc. num. Vendor/Customer 267-010-25- -5910 PROGRAM - PROGRAM SUPPORT - - INSURANCE March, 2023 4/20/2023 AJE 144705 267-010-25- -5960 PROGRAM - PROGRAM SUPPORT - -, COMMUNICATION March, 2023 4/20/2023 AJE 144686 267-010-50- -5601 PROGRAM - BLDG MAINT/FACILITY - - DEPRECIATION EXP BLDG. March, 2023 5/2/2023 AJE 144797 (Funds included: 267-CDBG PS) Page: Page 3 of 3 Date: 5/24/2023 Time: 3:15:53 PM Journal description Debit amount Credit amount Period Total ---> $28.90 Cummulative Total ---> $28.90 $0.00 3/23 Mgmt Liab Ins - Mid Valley Ins $5.81 Period Total ---> $5.81 Cummulative Total ---> $5.81 $0.00 3/23 Verizon $26.07 Period Total ---> $26.07 Cummulative Total ---> $26.07 $0.00 3/23 ML - Depreciation Expe $33.10 Period Total ---> $33.10 Cummulative Total ---> $33.10 $0.00 Grand Total ---> $6,210.57 r� WASHINGTON STATE a�' r DEPARTMENT OF COMMERCE AGENCY NUMBER 1030 IDIS PROJECT NUMBER 2021-0019 Commerc C rumber "62210-005 A19 VOUCHER DISTRIBUTION AGENCY NAME DEPARTiYIENT OF COMMERCE ATTN: CDBG PO BOX 42525 OLYMPIA, WA 98504-2525 INSTRUCTION TO.VENDOR OR CLAIMANT Submit this formto claim payment. for materials, merchandise or services. .. Show complet'd etaifor each item. Vendor's Certificate: I hereby certify under perjury that the items and totals listed herein are proper charges: for materials, merchandise or services furnished to the State of Washington, and that all goods'furnshed and/or services rendered have been provided without discrimination because of age, sex,: marital status, race, creed, color, national origin, handicap,raligion or Vietnam era or disabled veterans status. VENDOR OR CLAIMANT (Warrant is to be payable to:) Grant County PO Box 37 Ephrata, WA 98823IN REPORTING PERIOD: April 2023 1 ill\Y ' By: �- BLUE INK, =: (TITLE) (DATE) . - Description QUANTITY AMOUNT IDIS Activity ID PREVIOUSLY AMOUNT REMAINING BUDGET REQUESTED THIS INVOICE BALANCE 8622 05Z - Other Public Services not in 03T,05A-05Y $ 1249500.00 279237.97 182223.75 $79,038.28 $0.00 8623 21A - General Program Administration $ 39500.00 1 $0.00 $0.00 $39500.00 $0.00 - - $ - $0.00 - - $ - $0.00 - - $ - $0.00 - - $ - $0.00 - - $ - $0.00 TOTAL PAYMENT REQUEST $1289000.00 $279237.97 18,223.75 r $82,538.28 Everything below this line is for Dept of Commerce „..: . , •....^ z , PRQG.RAM<APPROVAC` The' individual si ^ Hirt this voucher.warrants theyhave the author' o sign thivoucher. PRI TED:NAME 1 SIGNATURE: e , DATE.._.... DOC:DATE C' 0 ti CURRENT DQ- , N : ::.: - REFERENCE DOC NO;.,;.. { i' VENDOR NUMBER 002426 3 ACCOUNT ASD NUMBER..,--VENDOR 43260 MESSAGE CD8G'# ;0 ;' ASTERUB SU ..TRANS... .. M .. .._ _, ... ,... _. ^....^ . . _ ......._ . B . .. -._ ..._. , .. _... ..... ,: ,. ., <: ,•.:::,.:.OBJ - CODE_., . D..INDEX.. OBJ. GL'::ACCT �-. : SUBSID ..:'. :;. INV ICE - AMOUNT NUMBER 622FO320 NZ $ 128,000.00 22-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: QF. WA.SBINGTON 22-6221a-oos 8;15TRUITVAIB BL . ` REPORT PERIOD: Printed Name: ELIZA 1BAYSINGER YAKIMA WA 98902 „ Apr-23 REPORT NUMBER: Title: SENIOR ACCOUNTANT 16 Date: 5/24/2023 TOTAL AMOUNT REQUESTED THIS PERIOD: $18,223.75 1. Name of Service Program: Asset Development & Other Asset Development 26 IICDBG amount requested for these program activities this period: $39317.59 Description of service program how low- and moderate-income (LMI) persons were served this period: Housing counseling, credit coaching, p p g foreclosure services, business start-up, financial education workshops and high school classes. Free tax-prep. - 2. Name of Service Program: Energy Assistance 110 JJCDBG amount requested for these program activities this period: $14,906.16 Description of service program how low- and moderate-income (LMI) persons were served this period: Energy assistance and conservation p p g education. 13.Name of Service Activity: Asset Develop/Energy Assist Admin-Indirect Admin iFCDBG amount requested for these program activities this period: $0.00 Description of service program how low- and moderate-income (LMI) persons were served this period: General administration expenses associated p p g with managing energy assistance and asset development activities oversight and assessments. Indirect admin. 4. Name of Service Activity Contract Recipient General Program Administration jFCDBG amount requested for these program activities this period: $0.00 5( 51 51 51 51 OIC of Washington CDBG Expense Summary - 267 Grant Period: 07/0112022 - 06/3012023 22-62210-005 BILLING PERIOD: APRIL 2023 -Salary 5311 $52,968.00 $15,890.93 $18,131.27 $21240-341, $34,836.73 FICA, OIC Exp 5351 $3,868.00 $1,156.78 $1,321.90 $165.12-A, $2,546.10 LAND 1, OIC Share 5352 $305.00 $75.27 $85.34 $10.07 $219.66 State UCI,OIC Exp 5353 $824.00 $168.42 $192.17 $23.75 $631-83 PFML 5355 $341.00 $135.81 $153.73 $17.92," $187.27 Disability, OIC EXP 5360 $731.00 $219.28 $248.09 - $28.81.40 $482.91 Medical Insurance, OIC Exp 5361 $11,187.00 $3,446.36 $3,777.02 $330.66.. $7,409.98 Life Insurance, 01C Exp 5362 $291.00 $87.38 $98.89 $11.51- $192.11 Pension, 01C Exp 5363 $3,977.00 $11188.24 $11345.07 $156.83-- $2,631-93 Accrued PTO Exp 5364 $6,030.00 $1,610.70 $1,904.89 $294.1994, $4,125.11 Credit Reports 5411 $0.00 $28.90 $28.90 $0.00 ($28.90) Depreciation Exp Equip 5602 $10.00 $4.87 $4.87 $0.00 $5.13 Insurance 5910 $121.00 $30.65 $69.04 $38.39 $51.96 Communication (Telephone/Cell & ISP) 5960 $723.00 $186.99 $186.99 $0.00 $536.01 Depreciation Exp Bldg 5601 $75.00 $83.38 $83.38 $0.00 ($8.38) .Space 5611 $40.00 $0.00 $40.00 .Utilities 5630 $71.00 $0.00 $71.00 Build Repair/Maint. k 5640 $88.00 $0.00 $88.00 ,.Liability Insurance 5912 $22.00 $0.00 $22.00 PTO AL, 'S T $81 -:672,00 !'$24 31 6]�_.- $27 631.55 13 _7 IR T lr%Al Salary 5311 $11,953.00 $10,095.75 .......... $10,095.75 - $1,857.25 FICA, OIC Exp 5351 $873.00 $745.25 $745.25,00 $127.75 L AND 1, OIC Share 5352 $76.00 $61.56 $61.56 $14.44, State UCI,OIC Exp 5353 $180.00 $107.02 $107.02 $72.98 PFML 5355 _$76.00 $88.52 $88.52 ($12.52) Disability, OIC Exp 5360 $170.00 $187.61 $187.61 ($17.61) Medical Insurance, OIC Exp 5361 $2,240.00 $11682.87 $1,682.87 $557.13 Life Insurance, 01C Exp 5362 $68.00 $61.65 $61.65 $6.35 Pension, OIC Exp 5363 $884.00 $774.60 $774.60 r $109.40 Accrued PTO Exp 5364 $1;366.00 $1,065.44 $1,065.44,o, $300.56 .Insurance 5910 $42.00 $35.89 $35.89 $6.11 00� ; Wi 4 90.6,,1_6 17-:928 _ZS U BTOTA L� ASSET` DEVELd P ENTIFNERGY`ASSISTANCE:A*DMIN. NniRFr;T-lnhQ_nqi Salary Admin. Allocation 5312 $14,458.00 $11998.23 .$1,998.23 $0.00 $123459.77 P/R Tax & Ben. Adm Allocation 5354 $73116.00 $925.78 $925.78 $0.00 $65190.22 Non Personnel Adm. Allocation 5999 $33 26. $0.00, $3,326.0 I - J --,SUBTOTAL .0 i _92.401- 24� $ OJO 0 $21;975. -99 C: F C 0 N TTRAf k 6 i0* I E N T. Contract Recipient Fee, 5415 $3,500.00 $0.00 $3,500.00 Z. r�� Is -00 lJ UBTOTAL-; voo.la 0 � 3 00. 3 4r 7 2_ $272 4, .7 3761 TOTAL GRANT 128,000.6 j5Z8 28 1:\DATANONSHARED\AC000NTING\Accounting_Eliza\Grants-Contracts\Grants-Contracts 20222023\267_CDBG (EB)\2- Billings\YR 2\CDBG_Expense Tracking Summary -'267 5/24/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 4/2023 through 4/2023 - Page: Page 1 of 5 Date: 5/24/2023 Tlme: 3:17:58 PM Account Trans. date Trans. type Doc. num. Vendor/Customer Journal description Debit amount Credit amount 267-010-25--5311 PROGRAM - PROGRAM SUPPORT - - SALARIES,WAGES EXPENSE April, 2023 4/30/2023 Payroll 33634 267-010-25--5351 PROGRAM - PROGRAM SUPPORT - - FICA,OIC EXP April, 2023 4/30/2023 Payroll 33634 267-010-25--5352 PROGRAM - PROGRAM SUPPORT - - L AND I,OIC SHARE April, 2023 4/30/2023 Payroll 33634 267-010-25--5353 PROGRAM - PROGRAM SUPPORT - - STATE UCI(ES),OIC EXP April, 2023 4/30/2023 Payroll 33634 267-010-25--5355 PROGRAM - PROGRAM SUPPORT - - PAID FAMILY MEDICAL LEAVE April, 2023 4/30/2023 Payroll 33634 267-010-25--5360 PROGRAM - PROGRAM SUPPORT - - DISABILITY OIC EXPENSE April, 2023 4/30/2023 Payroll 33634 4/30/2023 Payroll 33634 267-010-25--5361 PROGRAM - PROGRAM SUPPORT - - MEDICAL INSURANCE,OIC EXP Payroll wage expense for period $2,240.34 ending 4/30/2023 Period Total ---> $2,240.34 Cummulative Total ---> $2,240.34 Payroll FICA expense for period $165.12 ending 4/30/2023 Period Total ---> $165.12 - Cummulative Total ---> $165.12 $0.00 Payroll WC expense for period $10.07 ending 4/30/2023 Period Total ---> $10.07 Cummulative Total ---> $10.07 $0.00 Payroll UI expense for period ending $23.75 4/30/2023 Period Total ---> $23.75 - Cummulative Total ---> $23.75 $0.00 Payroll cost allocation (PFML) for $17.92 period ending 4/30/2023 Period Total ---> $17.92 -» Cummulative Total ---> $17.92 $0.00 Payroll cost allocation (LNG DISAB.) $23.23 for period ending 4/30/2023 Payroll cost allocation (SHT DISAB.) $5.58 for period ending 4/30/2023 Period Total ---> $28.81 - Cummulative Total ---> $28.81 $0.00 Genera{ Ledger System OIC OF WASHINGTON For User: Eliza Baysinger Transaction listing by account Fund: CDBG PS 7/1/21-6/30/23 From 4/2023 through 4/2023 Page: Page 2 of 5 Date: 5/24/2023 Time: 3:17:59 PM Account Trans. date Trans. type Doc. num. Vendor/Customer Journal description Debit amount Credit amount April, 2023 4/30/2023 Payroll 33634 Payroll cost allocation (EAP SERVIC) $0.98 for period ending 4/30/2023 4/30/2023+ Payroll 33634 Payroll cost allocation (MED INS) for $329.68 period ending 4/30/2023 Period Total ---> $330.66 �- Cummulative Total ---> $330.66 $0.00 267-010-25--5362 PROGRAM - PROGRAM SUPPORT - - LIFE INSURANCE,OIC EXP April, 2023 4/30/2023 Payroll 33-634 Payroll cost allocation (LIFE) for $11.51 period ending 4/30/2023 Period Total ---> $11.51 Cummulative Total ---> $11.51 $0.00 267-010-25--5363 PROGRAM - PROGRAM SUPPORT - - PENSION,OIC EXP April, 2023 4/30/2023 Payroll 33634 Payroll cost allocation (PENS.) for $156.83 period ending 4/30/2023 Period Total ---> $156.83— Cummulative Total ---> $156.83 $0.00 267-010-25--5364 PROGRAM - PROGRAM SUPPORT - - ACCRUED PTO EXP April, 2023 4/30/2023 Payroll 33634 Payroll cost allocation (PTO ALLOC) $78.63 for period ending 4/30/2023 4/30/2023 Payroll 33634 Program expense for vacation $215.56 accrued 4/30/2023 Period Total ---> $294.19 Cummulative Total ---> $294.19 $0.00 267-010-25- -5910 PROGRAM - PROGRAM SUPPORT - - INSURANCE April, 2023 5/12/2023 AJE 144940 4/23 Mgmt Liab Ins - Mid Valley Ins $38.39 Period Total ---> $38.39 Cummulative Total ---> $38.39 $0.00 267-010-25-54-5311 PROGRAM - PROGRAM SUPPORT - ENERGY ASSISTANCE - SALARIES,WAGES EXPEN April, 2023 4/30/2023 Payroll 33634 Payroll wage expense for period $6,490.15 - ending 4/30/2023 4/30/2023 Payroll 33634 Payroll wage expense for period $3,882.71 ending 4/30/2023 4/30/2023 Payroll 33634 Payroll wage expense for period $277.11 ending 4/30/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 4/2023 through 4/2023 Page: Page 3 of 5 Date: 5/24/2023 TI me: 3:17:59 PM Account Trans. date Trans. type Doc. num. Vendor/Customer Journal description Debit amount Credit amount r -t:1 1UU I ULCII %P I U'o I f—Qu %,Uf- I I . I I Cummulative Total ---> $10,372.86 $277.11 267-010-25-54-5351 PROGRAM - PROGRAM SUPPORT - ENERGY ASSISTANCE - FICA,OIC EXP April, 2023 4/30/2023 Payroll 33634 Payroll F - ICA expense for period $481.96 ending 4/30/2023 4/30/2023 Payroll 33634 Payroll FICA expense for period $283.69 ending 4/30/2023 4130/2023 Payroll 33634 Payroll FICA expense for period $20.40 - ending 4/30/2023 Period Total $765.65 $20.40 Cummulative Total ---> $765.65 $20.40 267-010-25-54-5352 PROGRAM - PROGRAM SUPPORT - ENERGY ASSISTANCE - L AND IOIC SHARE April, 2023 '4/3012023 Payroll 33634 Payroll WC expense for period $42.22 ending 4130/2023 4/30/2023 Payroll 33634 Payroll WC expense for period $21.07 ending 4/30/2023 4/30/2023 Payroll 33634 Payroll WC expense for period - $1.73 ending 4/30/2023 Period Total ---> $63.29 $1.73 Cummulative Total ---> $63.29 $1.73 267-010-25-54-5353 PROGRAM - PROGRAM SUPPORT - ENERGY ASSISTANCE - STATE UCI(ES),OIC EXP April, 2023 4/30/2023 Payroll 33634 Payroll UI expense for period ending $68.80 4/30/2023 4/30/2023 Payroll 33634 Payroll UI expense for period ending $41.16 4/30/2023 4/30/2023 Payroll 33634 Payroll UI expense for period ending $2.94 4/30/2023 Period Total ---> $109.96 $2.94 Cummulative Total $109.96 $2.94 267-010-25-54-5355 PROGRAM - PROGRAM SUPPORT - ENERGY ASSISTANCE - PAID FAMILY MEDICAL LE April, 2023 4/30/2023 Payroll 33634 Payroll cost allocation (PFML) for $90.74 period ending 4/30/2023 4/30/2023 Payroll 33634 Payroll cost allocation (PFML) for $2.22 period ending 4/30/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 4/2023 through 4/2023 Account Trans. date Trans. type Doc. num. Vendor/Customer Page: Page 4 of 5 Date: 5/24/2023 Time: 3:17:59 PM Journal description Period Total ---> Cummulative Total ---> v � $90.74 $2.22 $90.74 $2.22 $2.22 267-010-25-54-5360 PROGRAM - PROGRAM SUPPORT - ENERGY ASSISTANCE - DISABILITY OIC EXPENSE April, 2023 4/30/2023 Payroll 33634 Payroll cost allocation (LNG DISAB.) $120.17 for period ending 4/30/2023 4/30/2023 Payroll 33634 Payroll cost allocation (SHT DISAB.) $28.75 for period ending 4/30/2023 4/30/2023 Payroll 33634 Payroll cost allocation (LNG DISAB.) $2.90 for period ending 4/30/2023 4/30/2023 Payroll 33634 Payroll cost allocation (SHT DISAB.) $0.70 for period ending 4/30/2023 4/30/2023 33672 Payroll cost allocation (LNG DISAB.) $34.14 for period ending 4/30/2023 4/30/2023 33672 Payroll cost allocation (SHT DISAB.) $8.15 for period ending 4/30/2023 Period Total ---> $191.21 $3.60 Cummulative Total ---> $191.21- $3.60 267-010-25-54-5361 PROGRAM - PROGRAM SUPPORT - ENERGY ASSISTANCE - MEDICAL INSURANCE,OIC April, 2023 4/30/2023 Payroll 33634 Payroll cost allocation (EAP SERVIC) $9.22 for period ending 4/30/2023 4/30/2023 Payroll 33634 Payroll cost allocation (MED INS) for $1,718.47 period ending 4/30/2023 4/30/2023 Payroll 33634 Payroll cost allocation (EAP SERVIC) $0.16 for period ending 4/30/2023 4/30/2023 Payroll 33634 Payroll cost allocation (MED INS) for $47.66 period ending 4/30/2023 4/30/2023 33672 Payroll cost allocation (EAP SERVIC) $3.00 for period ending 4/30/2023 --> Period Total --- > $1,730.69 $47.82 Cummulative Total ---> $1,730.69 $47.82 267-010-25-54-5362 PROGRAM - PROGRAM SUPPORT - ENERGY ASSISTANCE - LIFE INSURANCE,OIC EXP April, 2023 4/30/2023 Payroll 33634 Payroll cost allocation (LIFE) for $59.33 period ending 4/30/2023 4/30/2023 Payroll 33634 Payroll cost allocation (LIFE) for $1.43 period ending 4/30/2023 4/30/2023 33672 Payroll cost allocation (LIFE) for $3.75 period ending 4/30/2023 OIC OF WASHINGTON For User: Eliza Baysinger Transaction listing by account Fund: CDBG PS 7/1121-6/30/23 General Ledger System From 4/2023 through 4/2023 Page: Page 5 of 5 Date: 5/24/2023 Time: 3:17:59 PM Account Trans. date Trans. type Doc. num. Vendor/Customer Journal description Debit amount Credit amount (0:) Period Total ---> $63.08 $1.43 Cummulative Total ---> $63.08 $1.43 267-010-25-54-5363 PROGRAM - PROGRAM SUPPORT - ENERGY ASSISTANCE - PENSION,OIC EXP .April, 2023 4/30/2023 Payroll 33634 Payroll cost allocation (PENS.) for $793.99 period ending 4/3012023 413012023 Payroll 33634 Payroll cost allocation (PENS.) for $19.39 period ending 4/30/2023 Period Total ---> $793.99 $19.39 Cummulative Total ---> $793.99 $19.39 267-010-25-54-5364 PROGRAM - PROGRAM SUPPORT - ENERGY ASSISTANCE - ACCRUED PTO EXP April, 2023 4130/2023 Payroll 33634 Payroll cost allocation (PTO ALLOC) $78.63 for period ending 4/30/2023 4/30/2023 Payroll 33634 Program expense for vacation $673.27 accrued 4/3012023 4/3012023 Payroll 33634 Program expense for vacation $334.33 accrued 4130/2023 4/30/2023 Payroll 33634 Program expense for vacation $20.79 accrued 4/30/2023 Period Total --->$1,086.23 $1,086.23 $20.79 14 L4 Cummulative Total $1,086.23 $20.79 267-010-25-54-5910 PROGRAM,- PROGRAM SUPPORT - ENERGY ASSISTANCE - INSURANCE - April, 2023 5/12/2023 AJE 144940 4/23 Mgmt Liab Ins - Mid Valley Ins $35.89 Period Total ---> $35.89 Cummulative Total ---> $35.89 $0.00 Grand Total ---> $18,621.18 $397.43 included: 267-CDBG PS) (Funds