Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Grant Related - BOCC
GRANT COUNTY BOARD OF COUNTY COMMISSIONERS LlJ1=�_I_L!J To: Board of County Commissioners Janice Flynn, Administrative Services Coordinator Dahn Oct 12, 2022 Re: Authorization for Release of Funds, Dept of Commerce, CDBG CV1 #20- 6221C-111, Reimbursement #17, Subrecipient 01C Request #17 OIC has requested reimbursement regarding the above -referenced grant in the amount of $6,320.49 for August 2022 expenses. Their documentation is attached for review. I am requesting the release of funds for payment to OIC in the amount of $6,320.49. Thank you. OCT 1'B ,2022 V E D M N 0 0 M Avr!'S,05 0 N E R S Al VOUCHER FORM Voucher #8 4 art M SUB - TRANS O SUB GL CODE D MASTER INDEX SUB OBJ OBJ ACCT SUBSID AMOUNT INVOICE NUMBER CI 622CO320 NZ SIGNATURE OF ACCOUNTING PREPARER FOR PAYMENTDATE WARRANT TOTAL CMS Invoice ID. Jennifer Lewis, Program Manager ACCOUNTING APPROVAL FOR PAYMENT DATE WASHINGTON STATE AGENCY NUMBER IDIS PROJECT NUMBER COMMERCE CONTRACT NUMBER DEPARTMENT OF COMMERCE A19 VOUCHER DISTRIBUTION 1030 107 20-6221 C-111 AGENCY NAME INSTRUCTION .TO VENDOR OR CLAIMANT: DEPARTMENT OF COMMERCE Submit this form to claim payment for materials, merchandise or services. ATTN: CDBG-CV PO BOX 42525 OLYMPIA, WA 98504-2525 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 and/or services rendered have been provided without VENDOR OR CLAIMANT (Warrant is to be payable to.) discrimination because of age, sex, marital status, race, creed, color, national origin, handicap, religion or Vietnam era or disabled veterans status. GRANT COUNTY PO BOX 37 By: EPHRATA, WA 98823-0037 (SIGN IN BLUE INK) _. (TITLE) (DATE) REPORTING PERIOD: Aug -22 IDIS DESCRIPTION ORIGINAL PRIOR AMOUNT AMOUNT THIS REMAINING Activity ID BUDGET REQUESTEDINVOICE BALANCE Add or, delete budget line items as needed. Includes CV1 and CV2 as applicable. 8310 2 1 A General Admin (Grant County Expenses Only) $ 23,090:00 8311 05Q Public Services Admin.Budget (OIC) $ 96,367:84 $ 342101:69 $ 535.21: $ 61,730:94 . 8311 05Q PS -Subsistence Payments (rent, morta e utility).(OIC ) $ " 150,000.00 $ 80,837.91 $ 1,022.00 $ 68;140;09 8312 05X PS- Housing Counseling (01C) $ 1.1.0,715.59 $ 141,790.34 $ 42228.07 $ 91,697.18 8313 18C - Microenterprise Assistance Admin. (01C) $ . 151,034:57 $ 5;621:15 $ 535.21 $ 144,878:21 8313 18C - Microenterprise Financial Assistance (OIC) $ 5017000:00 $ 25,697.02 $. $ 24,302.98 8313 18C - Microenterprise Training (OIC) $ 1200:00 $ $ $ 12;000.00 050 -Urgent Need- Mental Health -General Public (Grant Co.) 198,000.00 $ 1987000.00 OSQ -Urgent Need= Mental Health -Tele-Health (Grant Co.) 32,157.00 $ 32;157.00 O50 - Ur" ent Need- Mental Health -Coon Jail Grant;Co. g ' _ ( ) $ 1062000.00 $ . 106;000.00 Balances $ 929,365.00 � 161,048.11 69320.49 $ 761,996:40 M SUB - TRANS O SUB GL CODE D MASTER INDEX SUB OBJ OBJ ACCT SUBSID AMOUNT INVOICE NUMBER CI 622CO320 NZ SIGNATURE OF ACCOUNTING PREPARER FOR PAYMENTDATE WARRANT TOTAL CMS Invoice ID. Jennifer Lewis, Program Manager ACCOUNTING APPROVAL FOR PAYMENT DATE Contract # 20-6221 C-11 Submitted to GC by: OIC OF WASHINGTON Request For Reimbursement 18 August 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? 1:\DATANONSHARED\ACCOUNTING\Accountingjliza\Grants — Contracts\Grants—Contracts 20222023\500CDBG COVID 19 fund (EB)\2- Billings\2022\Subrecipient Checklist. docPage 1 00 030-6 030-6 030-6 030-6 030-6 030-6 030-6 030-6 030-6 030-6 030-6 030-6 030-62-5 030-62/030-62-5 030-62-5 030-62-5 030-62-5 030-6 030-6 030-6 030-62 / 030-62-5 030-62-5 030-6 030-6. 030-6. 030-6. 030-6. 030-6, 030-6. 030-6, 030-6, 030-6, 030-6, 030-6, OIC of Washington CDBG CV1 Expense Tracking Summary - 500 Grant Period: 10/01/2020 -12/31/2023 20-6221 C-111 RII 1 Mir- D=01ni'n• n I Ir --I icy- *9n77 DESCRIPTION ACCOUNT 05Q PUBLIC SERVICES -SUBSISTENCE PAYMENTS05X PUBLIC SERVICES ADMIN 030-62, -030-62-50)- BUDGET HOUSING YTD EXPENSED (as of 08/31/22) YTD BILLED (as of 07/31/22) DIFFERENCE BUDGET BALANCE (as of 08/31/22) TOTAL PUBLIC SERVICE ADMIN BUDGET $96,367.84 $963367.84 ADMINISTRATION - INDIRECT 009 $121740.52 $121740.52 $0.00 $12,740.52) i ADMINISTRATION - DIRECT 008 $317.83 $317.83 $0.00 ($317.83) Salary 5311 $12,888.35 $127888.35 $0.00 $12,888.35 FICA, OIC Exp 5351 $970.49 $970.49 $0.00 ($970.49) L AND I, OIC Share 5352 $74.86 $74.86 $0.00 ($74.86) State U C I, OI C Exp 5353 $266.58 $266.58 $0.00 ($266.58) PFML 5355 $57.20 $57.20 $0.00 $57.20 Disability, OIC Exp 5360 $130.69 $130.69 $0.00 $130.69 Medical Insurance, OIC Exp 5361 $965.83 $965.83 $0.00 $965.83) Life Insurance, OIC Exp 5362 $52.12 $52.12 $0.00 ($52.12) Pension, OIC Exp 5363 $964.77 $964.77 $0.00 ($964.77) Accrued PTO Exp 5364 $815.04 $815.04 $0.00 $815.04 Audit Costs 5402 $85.21 $0.00 $85.21 ($8/�'(� 5.21) Mileage/Perdiem:-In state 5500 $727.78 $727.78 $0.00 ($727.78) Depreciation Exp Bldg 5601 $17.49 $17.49 $0.00 ($17.49) Depreciation Exp Equip 5602 $13.29 $13.29 $0.00 ($13.29) Space 5611 $96.66 $96.66 $0.00 ($96.66) Utilities 5630 $13.81 $13.81 $0.00 ($13.81) Build Re air/Maint. 5640 $21.02 $21.02 $0.00 ($21.02) Consumables 5700 $783.30 $783.30 $0.00 ($783.30) Reproduction Supplies 5712 $86.26 $86.26 $0.00 ($86.26) Equipment -added 5800 $738.98 $738.98 $0.00 ($738.98) Insurance 5910 $70.52 $70.52 $0.00 ($70.52) L -i -ability Insurance 5912 $7.67 $7.67 $0.00 ($7.67) Advertising 5945 $900.00 $450.00 • $450.00 $900.00 Communication (Telephone/Cell & ISP 5960 $830.63 $830.63 $0.00 ($830.63) Postage 5970 $0.00 $0.00 $0.00 $0.00 SUBTOTAL $96y367.84 $34,636.90 $34,101.69. 535.21 ° $61, 730.94 SUBSISTENCE PUBLIC SERVICES PAYMENTS 030-62, 030-62-50 TOTAL SUBSISTENCE PS PAYMENTS BUDGET $150,000.00 $150,000.00 Client Mortgage Payment 5618 $137753.77 $13,753.77 $0.00 ($13,753.77) Housing Asst/Rent 5619 $11,066.10 $10,044.10 $1,022.00 ($11,066.10) Services 5959 $7,392.13 $7,392.13 $0.00 ($7,392.13) Client Mortgage Payment 5618 $7,573.46 $7,573.46 $0.00 ($7,573.46) Housing.Asst/Rent 5619 $42,074.45 $42,074.45 0 ($42,074.45) SUBTOTAL $150,000.00 $81, 859.91 $80,837.91 $1,022.00 $68,140.09 05X - HOUSING INFORMATION AND REFERRAL SERVICES (030-64,030-64-50). TOTAL PS HOUSING COUNSELING BUDGET $110,715.59 $110,715.59 Salary 5311 $4,946.22 $2,799.75 v $2,146.47 ($4,946.22) FICA, OIC Exp 5351 $378.27 $214.11 $164.16 $378.27 L AND I, OIC Share 5352 $25.45 $14.73 ' $10.72 ($25.45 State UCI,OIC Exp 5353 $73.35 $42.87 ' $30.48 ($73.35) I:\DATANONSHARED\ACCOUNTING\Accounting_Eliza\Grants_Contracts\Grants_Contracts 2022_2023\500_CDBG COVID 19 fund (EB)\2- Billings\2022\CDBG (500)_Expense Tracking - Revised 6-24-22 9/30/2022 030-6' 030-6' 030-6' 030-6' 030-6' 030-6' 030-6r 030-6r 030-6' 030-6' 030-6, 030-6, 030-6' 030-64 / 030-64-51 030-6' 030-6, 030-6, 030-6, 030-6; 030-6; 030-6; 030-6; 030-6; 030-6: 030-6: 030-6: 030-6: 030-6: 030-6: DESCRIPTION ACCOUNT BUDGET YTD EXPENSED (as of 08/31/22) YTD BILLED (as of 07/31/22) BUDGET BALANCE DIFFERENCE (as of 08/31/22) PFML 5355 $31.58 $16.92 $14.66 ($31.58) Disability, OIC Exp 5360 $51.70 $22.16 $29.54 ($51.70) Medical Insurance, OIC Exp 5361 $256.67 $2.88 $253.79 $256.67 Life Insurance, OIC Exp 5362 $20.58 $8.83 ' $11.75 ($20.58) Pension, OIC Exp 5363 $368.43 $197.36 $171.07 $368.43) Accrued PTO Exp 5364 $323.49 $129.31 $194.18 $323.49) Audit Costs 5402 $25.46 $0.00 " $25.46 $25.46 Credit Reports 5411 $366.60 $366.60 $0.00 ($366.60) Mileage/Perdiem:-In state 5500 $926.47 $806.54 $119.93 ($926.47) Depreciation Exp Equip 5602 $2.87 $2.87 $0.00 ($2.87) Consumables 5700 $1,139.54 $93.42 $1,046.12 $19139.54 Reproduction Supplies 5712 $54.05 $51.67 $2.38 ($54.05) Equipment -added 5800 $2,568.42 $27568.42 $0.00 $22568.42) Insurance 5910 $21.31 $13.95 $7.36 ($21.31) Advertising 5945 $5,680.00 $5,680.00 $0.00 $5,680.00) Staff Training 5949 $200.00 $200.00 $0.00 ($200.00 Communication (Telephone/Cell & ISP 5960 $11403.29 $17403.29 $0.00 $1,403.29) Postage 5970 $154.66 $154.66 0 ($154.66) SUBTOTAL $110,715.59 $19,018.41 $14,790,34 $4,228.07 $91,697.18- >.��.Y � ..... ,✓y,. ,, .i. .,.,v,. . P., �... rC d. ..d �.n.,. ✓.. Hl ,.,. ,2„., 17 ., .. .. ly a,,. ,_.. ,.t ..,. .. .. A, L., .!> ✓.+.r' .. 1.N >r. ..K,.....ry / %NA...�.... _,. /. �` .., s r, > c. r ., 3 .�. .- /�.-.,�' x•. t. < NIA .....JJ .rGnx,7> 5/f. .. ',: ., :: r. ,, -•. .. _. ... �.,i� ?J'. ,. ._... .,/ . > , J a... r.. .r...1I a..,., r ... „.. ,. .':.. .. :L ,.t .. ,..,:- :,. ,,. ,. .., :.. ,. ,u /Y, '✓ r : .; .. , .i y.. f ,.. ,.r., ..r .r ,.�' �r "Syr ,•.. m. ,. r. :. v 6.z. ,r' .,: �• ,., ,. . ., l� .N.: ,.a Y .., N /. L_.�n.<x^G'., { ti r^' . , F ,.., .. .. .,. 1. ..V 1.. �,. �r� .4✓�i . rY' � /„ ,.. .✓ : Y � r. : r.. :. Y. 4 / / ,. . v. .4 , r •gg ra�yi, � , NVIA. .' SAW, 'TOTAL MICRO ASSIST ADMIN BUDGET ��" }�, >�,r y $151,034.57 $151,034.57 ADMINISTRATION - INDIRECT 009 $2,517.26 $2,517.26 $0.00 ($2,517.26) ADMINISTRATION - DIRECT 008 $49.50 $49.50 $0.00 ($49.50) Audit Costs 5402 $85.21 $0.00 0 $85.21 ($85.21) Mileage/Perdiem:-In state 5500 $286.30 $286.30 $0.00 ($286.30) Consumables 5700 $229.47 $229.47 $0.00 ($229.47) Equipment -added 5800 $2,088.62 $2,088.62 $0.00 ($20088.62) Advertising 5 00 $450.00 "' r , q,90000 Y �B'` �"[`�IN- ".PHwcwry %N��....'� N.,� If 6 a,r. ,.. r, w Y , . :....,. ' , ' b / rr ,r.. 4F , r;l H :r.., ., '. �b I I e ' S t. 1 IS �� TOTAL MICRO FINANCIAL ASSIST BUDGET $50,000.00 ' $50,000.00 Client Mortgage Payment 5618 $0.00 Housing Asst/Rent 5619 $0.00 Services .� 5959 �NO,MAA"xm 69 7/ .0o�2 2."�5�.. r$0.00 ($25,697.02)iro b,. . N, , ; � ill .r... _„ ... . 1 . r 'Fc�.. rW"wa...'N,,.Wa�J� >.fiA�./. y. .na:b v�° WN. Y '.�, ._.a',,��.. e.r� ,b .'" y � .✓, ..� .,� ,, J/,r � ,y ,� ,., �L!M { , i 41m: W +.00 l. / ,%1Y�4 •, r �*,. r � (// :4 a.,. >i,ii�¢.✓�,:� „,.^>;e',r+E,,,,w;:„, r:an�y' .,. .,,"r�, 'ij..,w ,>,w .,.. .. .. /S 'r.Fw::`ru. .R. �,r✓H. ✓ . N °ti,yMW 8 :u. v< e I. j,t"sy°,. a.• l� .Z r' F"'l Nd,. TOTAL MICRO TRAINING BUDGET $12,000.00 $122000.00 Consultant / Contract Services 5400 $0.00 $0.00 $0.00 $0.00 Training Materials 5730 $0.00 $0.00 $0.00 $0.00 Client Training 5965 $0.00 $0.00 $0.00 $0.00 L ' 9i.. v y, fr 4 r� ' .. � : � a s�N"�': KIM-,�H. <� .. ... f$ „%� a }. pw. ... ''. ;, r, 4/ ,, i"• .ve s.a all Y n fBT TAL,. �,g ,w y 0 : S, 55mm r .. k r ,�.. �. _ 7�,`� ���,�rrma�o��r"�Q�Q T' ML M; C O I R EN% P O R RISE 213 034.57 $. _ > 31 8 3. $ _5 38,$31,318.17::$181',181.18; r :TOTAL i, i ,H $,,4,,02, 74,0.40: I:\DATANONSHARED\ACCOUNTING\Accounting_Eliza\Grants_Contracts\Grants_Contracts 2022_2023\500_CDBG COVID 19 fund (EB)\2- Billings\2022\CDBG (500)_Expense Tracking - Revised 6-24-22 9/30/2022 CDBG Public Services Expenditure Report STATE OF 'WASHINGTON COMMUNITY DEVELOPMENT BLOCK GRANT - CV GRAN'T'S DEPT OF COMMERCE HOUSING & SUBSISTENCE 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. SUBRECIPIENT: CDBG CONTRACT NO: Signature: OIC OF WASHINGTON E: 20-6221 C-111 815 FRUITVALE BLVD REPORT MONTH: Printed Name: DEREJE MEKURIA YAKIMA WA 98902 Aug-22 REPORT NUMBER: Title: CFO 23 Date: 9/30/2022 TOTAL AMOUNT REQUESTED THIS PERIOD: $59785.28 1. Name of Service Program: HOUSING CDBG CV CDBG amount requested for these program activities this period: $43228.07 Description of service program and how low- and moderate-income (LMI) persons were served this period: Assistance was advertised by radio, print and social media to targeted areas and qualifying households throughout the service area. 2. Name of Service Pro ram: SUBSISTENCE CDBG CV CDBG amount requested for these program activities this period: $15022.00 Description of service program how law- and moderate-income (LMI) persons were served this period: Assistance was advertised by radio, print and social media to targeted areas and qualifying households throughout the service area. 3. Name of Service Program: ADMINISTRATION HOUSING/SUBSISTENCE Ir $535.21 Description of service program how low- and moderate-income (LMI) persons were served this period: General administration expenses associated with managing Housing and Subsistence activities oversight and assessments. Indirect admin. CDBG Public Services Expenditure Report STATE OF WASHINGTON COMMUNITY DEVELOPMENT BLOCK GRANT - CV GRANTS DEPT OF COMMERCE MICRO -ENTERPRISE 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 ares properly chargeable to the referenced grant. SUBRECIPIENT: CDBG CONTRACT NO: Signature: OIC OF WASHINGTON 20-6221 C-111 815 FRUITVALE BLVD REPORT MONTH: Printed Name: DEREJE MEKURIA YAKIMA WA 98902 Aug -22 REPORT NUMBER: Title: CFO 23 Date: 9/30/2022 TOTAL AMOUNT REQUESTED THIS PERIOD: $535.21 1. Name of Service Program: MICRO -ENTERPRISE CDBG amount requested for these program activities this period: $0.00 Description of service program and how low- and moderate -income (LMI) persons were served this period: Assistace was advertised to Micro -Businesses by radio, print, social media and face-to- face and assisted to financially qualifying businesses within the service areas. 2. Name of Service Program: ADMINISTRATION MICRO -ENTERPRISE 1CDBG amount requested for these program activities this period: $535.21 Description of service program how low- and moderate -income (LMI) persons were served this period: General administration expenses associated with managing Micro -Enterprise activities oversight and assesments. Indirect Admin. OIC OF WASHINGTON For User: Eliza Baysinger RW Expenditure report for: 500 - 500 CDBG CV 1 Report year: 10/1/2020 thru 12/3112023 General Ledger System Period ending: August 2022 Page: Page 1 of 1 Date: 9/29/2022 Tlme: 1:27:43 PM --------------Monthly-------------------------------To Dote --------------- Account Budget Expenditures Pct Budget Expenditures Pct Annual budget Unexpended 62SB PS Subsistence Program Admin 63MC Microenterprise Program Admin 64HS PS Housing Counseling Admn Administration MCFA Micro Financial Assistance PSPA PS Subsistence Payments Report Totals $1,779.00 $535.21 30.08% $40,917.84 $3,244.00 $535.21 16.50% $74,612.02 $3,322.00 $3,180.66 95.75% $76,406.74 $2,130.00 $0.00 0.00% $48,990.40 $1,537.00 $0.00 0.00% $35,351.00 $2,562.00 $1,022.00 39.89% $58,926.00 $14,574.00 $5,273.08 36.18% $335,204.00 Billing Adiustment for Previous Month $1,047.41 - PS Housing Counseling $6,320.49 - Revised Billing Total $21,578.55 52.74% $69,884.84 $48,306.29 $3,589.60 4.81% $127,011.02 $1231421.42 $19,018.41 24.89% $130,117.74 $111,099.33 $15,625.11 31.89% $83,103.40 $67,478.29 $25,697.02 72.69% $60,000.00 $34,302.98 $81,859.91 138.92% $100,000.00 $18,140.09 $167,368.60 49.93% $570,117.00 $402,748.40 <$153,477.26> - Warrants Received <$4,027.44> - June Billing <$3,543.41> - July Billing $6,320.49 - August Billing OIC OF WASHINGTON For User: (Eliza Baysinger Transaction listing by period General Led revious Month Expen From 7/2022 through 7/2022 Page: Page 1 of 1 Date: 9/30/2022 Time: 10:07:55 AM Account Trans. date Trans. type Doc. num. Vendor/Customer Journal description Debit amount Credit amount July 2022 500 -030 -64 _ _ 5700 CONSUMABLES 7/31/2022 Voucher 203196 500 -030 -64 _ _ 5700 CONSUMABLES 7/31/2022 Voucher 203196 500 -030 -64 _ _ 5700 CONSUMABLES 7/31/2022 Voucher 203196 500 -030 -64 _ _ 5700 CONSUMABLES 7/31/2022 Voucher 203196 500 -030 -64 _ _ 5712 REPRODUCTION SUP 9/15/2022 AJE 142645 (Funds included: 500-CDBG-CV1) b%ova wy ODP BUSINESS SOL 250788724001/109103 ODP BUSINESS S ODP BUSINESS SOL 250796629001/109103 ODP BUSINESS S ODP BUSINESS SOL 250796630001/109103 ODP BUSINESS S ODP BUSINESS SOL 250796634001/109103 ODP BUSINESS S 7/22 copy cost PERIOD TOTAL ---> AGENCY TOTAL --- $547.90 $28.60 $439.74 $29.88 $1.29 $1,047.41 $1,047.41 General Ledger System OIC OF WASHINGTON For User: Eliza Baysinger Fund Expenditure report for: 500 - CDBG-CV1 10/1/20-12/31/23 (Fund status: Active) Report year: 10/1/2020 thru 12/31/2023 Period ending: August 2022 Page: Page 1 of 6 Date: 9/29/2022 Time: 1:25:24 PM -------------- Monthly -------------- -----------------To Date --------------- Account Budget Expenditures Pct Budget Expenditures Pct Annual budget Unexpended Department: 008 DIRECT ADMIN Program: 80 CEO OFFICE 5602 DEPRECIATION EXP EQUIP $0.00 $0.00 0.00% $0.00 $0.16 0.00% $0.00 ($0.16) 5960 COMMUNICATION $0.00 $0.00 0.00% $0.00 $10.17 0.00% $0.00 ($10.17) Total for sub program -----> $0.00 $0.00 0.00% $0.00 $10.33 0.00% $0.00 ($10.33) Sub program: 50 FACILITY MAINT 5601 DEPRECIATION EXP BLDG. $0.00 $0.00 0.00% $0.00 $2.41 0.00% $0.00 ($2.41) 5602 DEPRECIATION EXP EQUIP $0.00 $0.00 0.00% $0.00 $0.02 0.00% $0.00 ($0.02) 5611 SPACE $0.00 $0.00 0.00% $0.00 $44.34 0.00% $0.00 ($44.34) 5630 UTILITIES $0.00 $0.00 0.00% $0.00 $8.84 0.00% $0.00 ($8.84) 5640 BUILD. REPAIR/MAINT. $0.00 $0.00 0.00% $0.00 $35.96 0.00% $0.00 ($35.96) 5910 INSURANCE $0.00 $0.00 0.00% $0.00 $0.16 0.00% $0.00 ($0.16) 5912 LIABILITY INSURANCE $0.00 $0.00 0.00% $0.00 $5.42 0.00% $0.00 ($5.42) Total for sub program 50 -----> $0.00 $0.00 0.00% $0.00 $97.15 0.00% $0.00 ($97.15) Total for program 80 -----> $0.00 $0.00 0.00% $0.00 $107.48 0.00% $0.00 ($107.48) Program: 82 CFO / FISCAL 5602 DEPRECIATION EXP EQUIP $0.00 $0.00 0.00% $0.00 $0.77 0.00% $0.00 ($0.77) 5960 COMMUNICATION $0.00 $0.00 0.00% $0.00 $26.53 0.00% $0.00 ($26.53) Total for sub program -----> $0.00 $0.00 0.00% $0.00 $27.30 0.00% $0.00 ($27.30) Sub program: 50 FACILITY MAINT 5601 DEPRECIATION EXP BLDG. $0.00 $0.00 0.00% $0.00 $5.78 0.00% $0.00 ($5.78) 5602 DEPRECIATION EXP EQUIP $0.00 $0.00 0.00% $0.00 $0.04 0.00% $0.00 ($0.04) 5611 SPACE $0.00 $0.00 0.00% $0.00 $106.14 0.00% $0.00 ($106.14) 5630 UTILITIES $0.00 $0.00 0.00% $0.00 $21.16 0.00% $0.00 ($21.16) 5640 BUILD. REPAIR/MAINT. $0.00 $0.00 0.00% $0.00 $86.08 0.00% $0.00 ($86.08) 5910 INSURANCE $0.00 $0.00 0.00% $0.00 $0.38 0.00% $0.00 ($0.38) 5912 LIABILITY INSURANCE $0.00 $0.00 0.00% $0.00 $12.97 0.00% $0.00 ($12.97) General Ledger System OIC OF WASHINGTON For User: Eliza Baysinger Fund Expenditure report for: 500 - CDBG-CV1 10/1/20-12/31/23 (Fund status: Active) Report year: 10/1/2020 thru 12/31/2023 Period ending: August 2022 Page: Page 2 of 6 Date: 9/29/2022 Time: 1:25:25 PM ---------------Monthly----------- -----------------To Date --------------- Account Budget Expenditures Pct Budget Expenditures Pct Annual budget Unexpended Total for sub program 50 -----> $0.00 $0.00 0.00% $0.00 $232.55 0.00% $0.00 ($232.55) Total for program 82 -----> $0.00 $0.00 0.00% $0.00 $259.85 0.00% $0.00 ($259.85) Total for department 008 -----> $0.00 $0.00 0.00% $0.00 $367.33 0.00% $0.00 ($367.33) Department: 009 INDIRECT ADMIN Program: 02 ADMIN. POOL -BASE 5312 SALARY ADM. ALLOCATION $1,321.00 $0.00 0.00% $30,383.40 $8,814.42 29.01% $51,523.40 $42,708.98 5354 P/R TAX & BEN. ADM ALLOC. $554.00 $0.00 0.00% $12,742.00 $4,217.44 33.10% $21,607.00 $17,389.56 5999 NON PERSONNEL ADM. ALLOC. $255.00 $0.00 0.00% $5,865.00 $2,225.92 37.95% $9,973.00 $7,747.08 Total for sub program -----> $2,130.00 $0.00 0.00% $48,990.40 $15,257.78 31.14% $83,103.40 $67,845.62 Total for program 02 -----> $2,130.00 $0.00 0.00% $48,990.40 $15,257.78 31.14% $83,103.40 $67,845.62 Total for department 009 -----> $2,130.00 $0.00 0.00% $48,990.40 $15,257.78 31.14% $83,103.40 $67,845.62 Department: 030 COVI D 19 Program: 62 SUBSISTENCE 5311 SALARIES,WAGES EXPENSE $814.00 $0.00 0.00% $18,722.06 $12,888.35 68.84% $31,759.06 $18,870.71 5351 FICA,OIC EXP $58.00 $0.00 0.00% $1,334.00 $970.49 72.75% $2,276.00 $1,305.51 5352 L AND I,OIC SHARE $7.00 $0.00 0.00% $161.00 $74.86 46.50% $302.00 $227.14 5353 STATE UCI(ES),OIC EXP $19.00 $0.00 0.00% $437.00 $266.58 61.00% $778.00 $511.42 5355 PAID FAMILY MEDICAL LEAVE $3.00 $0.00 0.00% $69.00 $57.20 82.90% $153.00 $95.80 5360 DISABILITY OIC EXPENSE $13.00 $0.00 0.00% $299.00 $130.69 43.71% $512.00 $381.31 5361 MEDICAL INSURANCE,OIC EXP $258.00 $0.00 0.00% $5,934.00 $965.83 16.28% $10,069.00 $9,103.17 5362 LIFE INSURANCE,OIC EXP $5.00 $0.00 0.00% $115.00 $52.12 45.32% $204.00 $151.88 5363 PENSION,OIC EXP $71.00 $0.00 0.00% $1,633.00 $964.77 59.08% $2,769.00 $1,804.23 5364 ACCRUED PTO EXP $89.00 $0.00 0.00% $2,047.00 $815.04 39.82% $3,498.00 $2,682.96 5402 AUDIT COSTS $25.00 $85.21 j 340.84% $575.00 $85.21 14.82% $1,000.00 $914.79 5500 TRAVEL $38.00 $0.00 0.00% $874.00 $727.78 83.27% $1,500.00 $772.22 5602 DEPRECIATION EXP EQUIP $0.00 $0.00 0.00% $0.00 $13.27 0.00% $0.00 ($13.27) 5618 CLIENT MORTGAGE PYMENT $641.00 $0.00 0.00% $14,743.00 $13,753.77 93.29% $25,000.00 $11,246.23 General Ledger System OIC OF WASHINGTON For User: Eliza Baysinger Fund Expenditure report for: 500 - CDBG-CV1 10/1/20-12/31/23 (Fund status: Active) Report year: 10/1/2020 thru 12/31/2023 Period ending: August 2022 Page: Page 3 of 6 Date: 9/29/2022 Time: 1:25:26 PM -------------- Monthl-----------------To Date --------------- Account Budget Expenditures Pct Budget Expenditures Pct Annual budget Unexpended 5619 HOUSING ASST/RENT $128.00 5700 CONSUMABLES $76.00 5712 REPRODUCTION SUPPLIES $51.00 5800 EQUIPMENT $0.00 5910 INSURANCE $10.00 5912 LIABILITY INSURANCE $15.00 5945 ADVERTISING $64.00 5949 STAFF TRAINING $47.00 5959 SERVICES $512.00 5960 COMMUNICATION $48.00 5970 POSTAGE $7.00 Total for sub program -----> $2,999.00 Sub program: 50 SUBSISTENCE MAINTENANCE 5601 DEPRECIATION EXP BLDG. $11.00 5602 DEPRECIATION EXP EQUIP $0.00 5611 SPACE $17.00 5630 UTILITIES $15.00 5640 BUILD. REPAIR/MAINT. $15.00 5910 INSURANCE $0.00 5912 LIABILITY INSURANCE $3.00 Total for sub program 50 -----> $61.00 Total for program 62 -----> $3,060.00 Program: 63 MICROENTRPRS $830.63 5311 SALARIES,WAGES EXPENSE $1,569.00 5351 FICA,OIC EXP $112.00 5352 L AND I,OIC SHARE $14.00 5353 STATE UCI(ES),OIC EXP $38.00 5355 PAID FAMILY MEDICAL LEAVE $7.00 $1,022.00798.44% $2,944.00 $11,066.10 375.89% $5,000.00 ($6,066.10) $0.00 0.00% $1,748.00 $783.30 44.81% $3,000.00 $2,216.70 $0.00 0.00% $1,173.00 $86.26 7.35% $2,000.00 $1,913.74 $0.00 0.00% $0.00 $738.98 0.00% $0.00 ($738.98) $0.00 0.00% $230.00 $70.40 30.61% $400.00 $329.60 $0.00 0.00% $345.00 $0.00 0.00% $600.00 $600.00 $450.006'0 703.13% $1,472.00 $900.00 61.14% $2,500.00 $1,600.00 $0.00 0.00% $1,081.78 $0.00 0.00% $1,864.78 $1,864.78 $0.00 0.00% $11,776.00 $7,392.13 62.77% $20,000.00 $12,607.87 $0.00 0.00% $1,104.00 $830.63 75.24% $1,900.00 $1,069.37 $0.00 0.00% $161.00 $0.00 0.00% $300.00 $300.00 $1,557.21 51.92% $68,977.84 $53,633.76 77.76% $1177384.84 $63,751.08 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1,557.21 0.00% $253.00 $17.49 6.91% $461.00 $443.51 0.00% $0.00 $0.02 0.00% $0.00 ($0.02) 0.00% $391.00 $96.66 24.72% $667.00 $570.34 0.00% $345.00 $13.81 4.00% $586.00 $572.19 0.00% $345.00 $21.02 6.09% $613.00 $591.98 0.00% $0.00 $0.12 0.00% $24.00 $23.88 0.00% $69.00 $7.67 11.12% $149.00 $141.33 0.00% $1,403.00 $156.79 11.18% $2,500.00 $2,343.21 50.89% $70,380.84 $53,790.55 76.43% $119,884.84 $66,094.29 $0.00 0.00% $36,087.02 $0.00 0.00% $61,196.02 $61,196.02 $0.00 0.00% $2,576.00 $0.00 0.00% $4,386.00 $4,386.00 $0.00 0.00% $322.00 $0.00 0.00% $581.00 $581.00 $0.00 0.00% $874.00 $0.00 0.00% $1,499.00 $1,499.00 $0.00 0.00% $161.00 $0.00 0.00% $295.00 $295.00 General Ledger System OIC OF WASHINGTON DEPRECIATION EXP BLDG. $14.00 $0.00 0.00% $322.00 $0.00 0.00% $553.00 For User: Eliza Baysinger 5611 SPACE $20.00 $0.00 0.00% $460.00 $0.00 0.00% $800.00 $800.00 5630 UTILITIES $18.00 $0.00 0.00% $414.00 Page: g Page 4 of 6 g Fund Expenditure report for: 500 - CDBG-CV1 10/1/20-12/31/23 (Fund status: Active) 5640 BUILD. REPAIR/MAINT. $18.00 $0.00 0.00% $414.00 $0.00 0.00% $736.00 $736.00 5910 INSURANCE Date: 9/29/2022 Report year: 10/1/2020 thru 12/31/2023 $0.00 Period ending: August 2022 0.00% $28.00 Time: 1:25:26 PM LIABILITY INSURANCE $4.00 ---------------Monthly-------------- -----------------To Date --------------- $92.00 $0.00 Account $180.00 Budget Expenditures Pct Budget Expenditures Pct Annual budget Unexpended 5360 DISABILITY OIC EXPENSE $25.00 $0.00 0.00% $575.00 $0.00 0.00% $986.00 $986.00 5361 MEDICAL INSURANCE,OIC EXP $497.00 $0.00 0.00% $11,431.00 $0.00 0.00% $19,401.00 $19,401.00 5362 LIFE INSURANCE,OIC EXP $10.00 $0.00 0.00% $230.00 $0.00 0.00% $392.00 $392.00 5363 PENSION,OIC EXP $136.00 $0.00 0.00% $3,128.00 $0.00 0.00% $5,335.00 $5,335.00 5364 ACCRUED PTO EXP $172.00 $0.00 0.00% $3,956.00 $0.00 0.00% $6,740.00 $6,740.00 5402 AUDIT COSTS $25.00 $85.210" 340.84% $575.00 $85.21 14.82% $1,000.00 $914.79 5500 TRAVEL $51.00 $0.00 0.00% $1,173.00 $286.30 24.41% $2,000.00 $1,713.70 5618 CLIENT MORTGAGE PYMENT $51.00 $0,.00 0.00% $1,173.00 $0.00 0.00% $2,000.00 $2,000.00 5619 HOUSING ASST/RENT $1,435.00 $0.00 0.00% $33,005.00 $0.00 0.00% $56,000.00 $56,000.00 5700 CONSUMABLES $102.00 $0.00 0.00% $2,346.00 $229.47 9.78% $4,000.00 $3,770.53 5712 REPRODUCTION SUPPLIES $64.00 $0.00 0.00% $1,472.00 $0.00 0.00% $2,500.00 $2,500.00 5800 EQUIPMENT $102.00 $0.00 0.00% $2,346.00 $2,088.62 89.03% $4,000.00 $1,911.38 5910 INSURANCE $10.00 $0.00 0.00% $230.00 $0.00 0.00% $400.00 $400.00 5912 LIABILITY INSURANCE $15.00 $0.00 0.00% $345.00 $0.00 0.00% $600.00 $600.00 5945 ADVERTISING $64.00 $450.00-e 703.13% $1,472.00 $900.00 ° 61.14 /o $2,500.00 $1 600.00 , 5949 STAFF TRAINING $51.00 $0.00 0.00% $1,173.00 $0.00 0.00% $2,000.00 $2,000.00 5959 SERVICES $51.00 $0.00 0.00% $1,173.00 $25,697.02 2190.71% $2,000.00 ($23,697.02) 5960 COMMUNICATION $48.00 $0.00 0.00% $1,104.00 $0.00 0.00% $1,900.00 $1,900.00 5965 CLIENT TRAINING $51.00 $0.00 0.00% $1,173.00 $0.00 0.00% $2,000.00 $2,000.00 5970 POSTAGE $7.00 $0.00 0.00% $161.00 $0.00 0.00% $300.00 $300.00 Total for sub program -----> $4,707.00 $535.21 11.37% $108,261.02 $29,286.62 27.05% $184,011.02 $154,724.40 Sub program: 50 MICRO MAINTENANCE 5601 DEPRECIATION EXP BLDG. $14.00 $0.00 0.00% $322.00 $0.00 0.00% $553.00 $553.00 5611 SPACE $20.00 $0.00 0.00% $460.00 $0.00 0.00% $800.00 $800.00 5630 UTILITIES $18.00 $0.00 0.00% $414.00 $0.00 0.00% $703.00 $703.00 5640 BUILD. REPAIR/MAINT. $18.00 $0.00 0.00% $414.00 $0.00 0.00% $736.00 $736.00 5910 INSURANCE $0.00 $0.00 0.00% $0.00 $0.00 0.00% $28.00 $28.00 5912 LIABILITY INSURANCE $4.00 $0.00 0.00% $92.00 $0.00 0.00% $180.00 $180.00 General Ledger System OIC OF WASHINGTON For User: Eliza Baysinger Fund Expenditure report for: 500 - CDBG-CV1 10/1/20-12/31/23 (Fund status: Active) Report year: 10/1/2020 thru 12/31/2023 Period ending: August 2022 Page: Page 5 of 6 Date: 9/29/2022 } Time: 1:25:27 PM ---------------Monthly-------------- -----------------To Date --------------- Account Budget Expenditures Pct Budget Expenditures Pct Annual budget Unexpended Total for sub program 50 -----> $74.00 $0.00 0.00% $1,702.00 $0.00 0.00% $3,000.00 $3,000.00 Total for program 63 -----> $4,781.00 $535.21 11.19% $109,963.02 $29,286.62 26.63% $187,011.02 $157,724.40 Program: 64 HOUSING 5311 SALARIESOAGES EXPENSE $1,648.00 $2,146.47 -"" 130.25% $37,904.74 $4,946.22 13.05% $64,294.74 $59,348.52 5351 FICA,OIC EXP $118.00 $164.16 r 139.12% $2,714.00 $378.27 13.94% $4,608.00 $4,229.73 5352 L AND I,OIC SHARE $15.00 $10.72.- 71.47% $345.00 $25.45 7.38% $611.00 $585.55 5353 STATE UCI(ES),OIC EXP $40.00 $30.48' 76.20% $920.00 $73.35 7.97% $1,575.00 $1,501.65 5355 PAID FAMILY MEDICAL LEAVE $7.00 $14.66' 209.43% $161.00 $31.58 19.61% $310.00 $278.42 5360 DISABILITY OIC EXPENSE $26.00 $29.54 113.62% $598.00 $51.70 8.65% $1,036.00 $984.30 5361 MEDICAL INSURANCE,OIC EXP $522.00 $253.79 48.62% $12,006.00 $256.67 2.14% $20,384.00 $20,127.33 5362 LIFE INSURANCE,OIC EXP $10.00 $11.75' 117.50% $230.00 $20.58 8.95% $412.00 $391.42 5363 PENSION,OIC EXP $143.00 $171.07' 119.63% $3,289.00 $368.43 11.20% $5,605.00 $5,236.57 5364 ACCRUED PTO EXP $181.00 $194.18' 107.28% $4,163.00 $323.49 7.77% $7,082.00 $6,758.51 5402 AUDIT COSTS $7.00 $25.46,* 363.71% $161.00 $25.46 15.81% $300.00 $274.54 5411 CREDIT REPORTS $0.00 $0.00 0.00% $0.00 $366.60 0.00% $0.00 ($366.60) 5500 TRAVEL $51.00 $119.93 235.16% $1,173.00 $926.47 78.98% $21000.00 $1,073.53 5602 DEPRECIATION EXP EQUIP $0.00 $0.00 0.00% $0.00 $2.87 0.00% $0.00 ($2.87) 5618 CLIENT MORTGAGE PYMENT $153.00 $0.00 0.00% $3,519.00 $7,573.46 215.22% $6,000.00 ($1,573.46) 5619 HOUSING ASST/RENT $1,128.00 $0.00 0.00% $25,944.00 $42,074.45 162.17% $44,000.00 $1,925.55 5700 CONSUMABLES $89.00 $0.00 0.00% $2,047.00 $1,139.54 55.67% $3,500.00 $2,360.46 5712 REPRODUCTION SUPPLIES $64.00 sw--� $1.09 1.70% $1,472.00 $54.05 3.67% $2,500.00 $2,445.95 5800 EQUIPMENT $102.00 $0.00 0.00% $2,346.00 $2,568.42 109.48% $4,000.00 $1,431.58 5910 INSURANCE $10.00 $7.36 73.60% $230.00 $21.31 9.27% $400.00 $378.69 5912 LIABILITY INSURANCE $15.00 $0.00 0.00% $345.00 $0.00 0.00% $600.00 $600.00 5945 ADVERTISING $89.00 $0.00 0.00% $2,047.00 $5,680.00 277.48% $3,500.00 ($2,180.00) 5949 STAFF TRAINING $51.00 $0.00 0.00% $1,173.00 $200.00 17.05% $2,000.00 $1,800.00 5960 COMMUNICATION $48.00 $0.00 0.00% $1,104.00 $1,403.29 127.11% $1,900.00 $496.71 5970 POSTAGE $12.00 $0.00 0.00% $276.00 $154.66 56.04% $500.00 $345.34 General Ledger System OIC OF WASHINGTON For User: Eliza Baysinger Fund Expenditure report for: 500 - CDBG-CV1 10/l/20-12/31/23 (Fund status: Active) Report year: 10/1/2020 thru 12/31/2023 Period ending: August 2022 Page: Page 6 of 6 Date: 9/29/2022 Time: 1:25:28 PM ---------------Monthly-------------- -----------------To Date --------------- Account Budget Expenditures Pct Budget Expenditures Pct Annual budget Unexpended Total for sub program -----> $4,529.00 $3,180.66 70.23% $104,167.74 $68,666.32 65.92% $177,117.74 $108,451.42 Sub program: 50 HOUSING MAINT 5601 DEPRECIATION EXP BLDG. $14.00 $0.00 0.00% $322.00 $0.00 0.00% $553.00 $553.00 5611 SPACE $20.00 $0.00 0.00% $460.00 $0.00 0.00% $800.00 $800.00 5630 UTILITIES $18.00 $0.00 0.00% $414.00 $0.00 0.00% $703.00 $703.00 5640 BUILD. REPAIR/MAINT. $18.00 $0.00 0.00% $414.00 $0.00 0.00% $736.00 $736.00 5910 INSURANCE $0.00 $0.00 0.00% $0.00 $0.00 0.00% $28.00 $28.00 5912 LIABILITY INSURANCE $4.00 $0.00 0.00% $92.00 $0.00 0.00% $180.00 $180.00 Total for sub program 50 -----> $74.00 $0.00 0.00% $1,702.00 $0.00 0.00% $3,000.00 $3,000.00 Total for program 64 -----> $4,603.00 $3,180.66 69.10% $105,869.74 $68,666.32 64.86% $180,117.74 $111,451.42 Total for department 030 -----> $12,444.00 $5,273.08 42.37% $286,213.60 $151,743.49 53.02% $487,013.60 $335,270.11 Fund Totals $14,574.00 $5,273.08 36.18% $335,204.00 $167,368.60 49.93% $570,117.00 $402,748.40 s,a� 3, lu'ov Au -t l nul X11 PSN0N." ,..+ b:�t.J (0s ya o 9 1101, Avg'