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 (002)
GRANT COUNTY BOARD OF COUNTY COMMISSIONERS 1 v T To: Board of County Commissioners Janice Flynn, Administrative Services Coordinator Data June 20, 2023 Re: Authorization for Release of Funds, Dept of Commerce,, CDBG CV1 #20- 6221 C-111, Subrecipient O/C Request #30 01C has requested reimbursement regarding the above -referenced grant in the amount of $72,827.19 for March -April 2023 expenses. Their documentation is attached for review. I am requesting the release of funds for payment to 01C in the amount of $72,827.19. The attached A19 reflects both CV1 (01C) & CV2 (Renew) expenses for March -April 2023 as a combined A19 is required by Commerce. Thank you. 'APPROVED -- JUN 2 12023 CONSENT @�e CE rVn G" !�2-12E LZ OMIP14LLCMM�Pjll N E R S, OM 001 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: 030-6: 030-6: 030-6: 030-6: 030-6: 030-6: 030-62-51 030-62-51 030-62-51 030-62-51 030-62-51 030-62-51 030-62-51 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 - 06/30/23 20-6221 C-111 R11 I Mr. PFRlnn• M®Rr.H gn�� DESCRIPTION ACCOUNT BUDGET YTD EXPENSED (as of 03/31123) YTD BILLED (as of 02/28/23) DIFFERENCE BUDGET BALANCE (as of 03/31/23) 05Q PUBLIC SERVICES -SUBSISTENCE PAYMENTS PUBLIC , ? SERVICES ADMIN' 030, 62,'-0301162150)--,, I 05X HOUSING = , TOTAL PUBLIC SERVICE ADMIN BUDGET $96,367.84 $96,367.84 ADMINISTRATION - INDIRECT (009) $23,767.27 $23,767.27 $0.00 ($23,767.27) ADMINISTRATION - DIRECT 008 $317.83 $317.83 $0.00 $317.83 Salary 5311 $24,512.66 $24,512.66 $0.00 $24,512.66 FICA, OIC Exp 5351 $1,809.78 $1,809.78 $0.00 ($1,809.78) LAND I, OIC Share 5352 $149.88 $149.88 $0.00 ($149.88) State UCI,OIC Exp 5353 $411.90 $411.90 $0.00 $411.90 PFML 5355 $135.67 $135.67 $0.00 $135.67 Disability, OIC Exp 5360 $280.37 $280.37 $0.00 $280.37 Medical Insurance, OIC Exp 5361 $37726.18 $37726.18 $0.00 ($3,726.18) Life Insurance, OIC Exp 5362 $111.46 $111.46 $0.00 $111.46 Pension, OIC Exp 5363 $1,750.51 $1,750.51 $0.00 $1,750.51 Accrued PTO Exp 5364 $11583.94 $17583.94 $0.00 $1,583.94 Audit Costs 5402 $105.21 $105.21 $0.00 ($105.21) Website design & Hosting 5403 $1,375.48 $1,201.50 $173.98 $1,375.48 Mileage/Perdiem:-In state 5500 $1,284.02 $1,284.02 $0.00 $1,284.02 Depreciation Exp Equip 5602 $18.77 $18.77 $0.00 $18.77 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 $108.40 $108.40 $0.00 $108.40 Advertising 5945 $21250.00 $2,250.00 $0.00 ($21250.00) Communication (Telephone/Cell & ISP) 5960 $986.61 $986.61 $0.00 ($986.61) Postage 5970 $22.75 $22.75 $0.00 $22.75 Depreciation Exp Bldg 5601 $38.99 $38.99 $0.00 $38.99) Depreciation Exp Equip 5602 $0.04 $0.04 $0.00 $0.04 Space 5611 $158.66 $158.66 $0.00 ($158.66) Utilities 5630 $39.13 $39.13 $0.00 $39.13 Build Re air/Maint. 5640 $61.20 $61.20 $0.00 $61.20 Insurance 5910 $0.22 $0.22 $0.00 $0.22 Liability Insurance 5912 $18.29 $18.29 $0.00 ($18.29) SUBTOTAL $96,367.84 $66,633.76 $661459.78` $$1.73.98 $29,734.08.; SUBSISTENCE PUBLIC SERVICES PAYMENTS.(030-62, 030-62-50 TOTAL SUBSISTENCE PS PAYMENTS BUDGET $150,000.00 $150,000.00 Client Mortgage Payment 5618 $23,019.85 $23,019.85 $0.00 ($231019.85) Housing Asst/Rent 5619 $21,631.10 $20,231.10 $11400.00 $21,631.10 Services 5959 $7,392.13 $77392.13 $0.00 $7,392.13 Client Mortgage Payment 5618 $7,573.46 $71573.46 $0.00 ($7,573.46) Housing Asst/Rent 5619 $427074.45 $42,074.45 $0.00 ($42,074.45) SUBTOTAL $150,000.00 $101,690.99 $100,290.99 $1,400.00 $48,309°01 05X -`MOUSING INFORMATION AND RE.FERRALr SERVICES 030-64, 030-64-50 TOTAL PS HOUSING COUNSELING BUDGET $1109715.59 $110,715.59 Salary 5311 $8,211.07 $62769.00 $1,442.07 $8,211.07 I:\DATANONSHARED\ACCOUNTING\Accounting Eliza\Grants_Contracts\Grants Contracts 2022 2023\500 CDBG COVID 19 fund (EB)\2- Billings\CDBG (500) Expense Tracking 4/27/2023 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, 030-6, 030-6, 030-6, 030-6, 030-6, 030-6, 030-64-51 030-64-51 030-64-51 030-64-51 030-64-51 030-64-51 030-64-51 00! 001 030-6: 030-6: 030-6; 030-6: 030-6: 030-6: 030-6: 030-61 030-6: 030-6: 030-6; 030-6: 030-6; 030-6; 030-6: DESCRIPTION ACCOUNT YTD EXPENSED BUDGET (as of 03131/23) YTD BILLED (as of 02/28/23) DIFFERENCE BUDGET BALANCE (as of 03/31/23) FICA, OIC Exp 5351 $616.59 $510.46 $106.13 $616.59 L AND I, OIC Share 5352 $46.54 $36.66 $9.88 $46.54 State UCI,OIC Exp 5353 $114.51 $99.23 $15.28 ($114,51) PFML 5355 $58.71 $46.47 $12.24 ($58.71) Disability, OIC Exp 5360 $88.15 $68.34 $19.81 $88.15 Medical Insurance, OIC Exp 5361 $727.87 $471.36 $256.51 $727.87 Life Insurance, OIC Exp 5362 $35.01 $27.17 $7.84 $35.01 Pension, OIC Exp 5363 $649.27 $542.15 $107.12 ($649.27) Accrued PTO Exp 5364 $512.99 $398.12 $114.87 $512.99 Audit Costs 5402 $45.46 1 $45.46 $0.00 $45.46 Credit Reports 5411 $403.80 $403.80 $0.00 $403.80 Mileage/Perdiem:-In state 5500 $1,293.75 $11293.75 $0.00 ($1,293.75) Depreciation Exp Equip 5602 $5.75 $5.75 $0.00 ($5.75) Consumables 5700 $1,209.81 $1,209.81 $0.00 $1,209.81 Reproduction Supplies 5712 $161.96 $161.96 $0.00 $161.96 Equipment -added 5800 $2,568.42 $2,568.42 $0.00 ($2,568.42) Insurance 5910 $30.33 $26.81 $3.5210 ($30.33) Advertising 5945 $6,220.00 $6,220.00 $0.00 $6,220.00 Staff Training 5949 $200.00 $200.00 $0.00 $200.00 Communication (Telephone/Cell & ISP) 5960 $11455.86 $1,433.24 $22.62 ($1,455.86) Postage 5970 $169.01 $169.01 $0.00 ($169.01) Depreciation Ex Bldg5601 $5.59 $5.59 $0.00 $5.59 Depreciation Exp Equip 5602 $0.01 $0.01 $0.00 $0.01 Space 5611 $17.08 $17.08 $0.00 $17.08 Utilities 5630 $7.79 $7.79 $0.00 ($7.79) Build Re air/Maint. 5640 $14.64 $14.64 $0.00 $14.64 Insurance 5910$0.02 $0.02 $0.00 $0.02) Liability Insurance 5912 $4.09 $4.09 $0.00 $4.09 SUBTOTAL 110 7.'1,5.59 24 87 r08 _ $ $ 4 22 7 6 $ 5 .'1.9 _ . $2,11;7.89: $85,84;'1..51, , r , ✓' ? : ✓- .. 1"' �. /. ,. �. .. r . ,. . v' .. 7 sm,,<� r r Y 4ff5'w,,'.. ... 4> , aYk.. ,'{' , N - .+/,. ' / '.'"Qb'. , ! ;a r - MICROENTERPRISEASSISTANCE TOTAL MICRO ASSIST ADMIN BUDGET $151,034.57 $151,034.57 ADMINISTRATION - INDIRECT 009 $6,179.94 $6,179.94 $0.00 $6,179.94 ADMINISTRATION - DIRECT 008 $49.50 $49.50 $0.00 $49.50 Salary 5311 $24,369.75 $6,680.22 $17,689.53 $24,369.75 FICA, OIC Exp 5351 $11796.62 $496.22 $17300.40 ($1,796.62) LAND I, OIC Share 5352 $167.79 $40.39 $127.40 $167.79 State UCI,OIC Exp 5353 $265.98 $78.45 $187.53 $265.98 PFML 5355 $188.52 $36.00 $152.52 $188.52 Disability, OIC Exp 5360 $278.21 $40.38 $237.83 ($278.21) Medical Insurance, OIC Exp 5361 $3,860.51 $644.92 $3,215.59 $3,860.51 Life Insurance, OIC Exp 5362 $110.46 $16.05 $94.41 $110.46 Pension, OIC Exp 5363 $11754.63 $420.05 $1,334.58 $19754.63 Accrued PTO Exp 5364 $17656.91 $277.88 $17379.03 ($1,656.91) Audit Costs 5402 $105.21 $105.21 $0.00 ($105.21) Website Design & Hosting 5403 $1,375.49 $1,201.51 $173.98 $1,375.49 Mileage/Perdiem:-In state 5500 $769.69 $769.69 $0.00 $769.69 Depreciation Exp Equip 5602 $3.49 $3.49 $0.00 ($3.49 Consumables 5700 $338.07 $292.60 $45.47 $338.07) I:\DATANONSHARED\ACCOUNTING\Accounting_Eliza\Grants_Contracts\Grants Contracts 2022_2023\500 CDBG COVID 19 fund (EB)\2- Billings\CDBG (500) Expense Tracking 4/27/2023 030-6; 030-6' 030-6c 030-6: 030-6' 030-6' 030-6' 030-63-5( 030-63-5( 030-63-5( 030-63-5( 030-63-5( 030-63-5( 030-63-5( 030-6< 030-6' 030-6; 030-6' 030-6' 030-6; DESCRIPTION ACCOUNT YTD EXPENSED BUDGET (as of 03/31/23) YTD BILLED (as of 02/28/23) DIFFERENCE BUDGET BALANCE (as of 03/31/23) Equipment -added 5800 $3,968.68 $3,968.68 $0.00 $3,968.68) Insurance 5910 $67.98 $13.81 $54.17 $67.98) Liability Insurance 5912 $1.76 $0.00 $1.76 ($1.76) Advertising 5945 $1,566.67 $1,566.67 $0.00 ($1,566.67) Dues/Memberships 5941 $41.67 $0.00 $41.67 $41.67 Communication (Telephone/Cell & ISP 5960 $319.57 $60.46 $259.11 $319.57) Meeting Expense 5994 $133.33 $0.00 $133.33 $133.33) Depreciation Exp Bldg 5601 $4.20 $4.20 $0.00 ($4.20) Depreciation Exp Equip 5602 $0.01 $0.01 $0.00 $0.01) Space 5611 $21.65 $21.65 $0.00 $21.65 Utilities 5630 $4.61 $4.61 $0.00 $4.61) Build Repair/Maint. 5640 $11.88 $11.88 $0.00 ($11.88) Insurance 5910 $0.04 $0.04 $0.00 ($0.04) Liability Insurance 5912 $4.35 $4.35 $0.00 $4.35 , r / .� ',.a wr,Y /k,nk,.LNpa/ �/, b'. d., rlawi, ,b ,�M'. „W/ •7/ .�; TOTAL MICRO FINANCIAL ASSIST BUDGET $50,000.00 $50,000.00 Client Mortgage Payment 5618 $0.00 $0.00 $0.00 $0.00 Housing Asst/Rent 5619 $0.00 $0.00 $0.00 $0.00 Services 5959 $251697.02 $257697.02 $0.00 ($25,697.02) M n. ... k, a-,/ .. ,.... ..... ....... .. .e ... ;: ✓hn. Ld/ /.'"'',�,/4i',e>z,L, far'- a //n N/ '/ y/ n,w i ri/nn'm� gg TOTAL MICRO TRAINING BUDGET $12,000.00 $12,000.00 Consultant / Contract Services 5400 $0.00 $0.00 $0.00 $0.00 TrainingMaterials 5730 $0.00 $0.00 $0.00 $0.00 Client Training 5965 $0.00 $0.00 $0.00 $0.00 R011 I AM: M�� Mou. v .r . ,.... .4. , .¢ .w r i'T .T., 56 k .,d: -i, n � ^,. ;--:•N-. :..• [.m-: w..rr:,,H w:sJ . P r S . r . • ,.. .., . ,.m .t. ,.. ... 7.o-. .,r ,, r<: .. .. > ..��' .. .. ... ... .. .. Xf. N.fj3 6 .,ems, ,., .. .... ,?Y% .. i., 4C ...f .r ro � r.. ,r � �' h i- .NxL.3 -r�.h ♦a .�.,. -',Y . .�. r> J mm, 4 . ., i{✓ fg: ./ a .. ,,. � �` ., „ �.�`yr,.k, ,. ...,. >✓ .r � ;H^ � y���. .r ...�.,,. °',tT„ ..:!.n� ,.. � , s*' -: ,iY' .�-.�,1i� i" ,riyr./,. k.J ...,ar'. ,/1 :/rb'r. r... * A- �9'.@a v% i. ",.','$. ) v .4 Y nf. ,.n ,. ,.. ".1' .,' � "-fh...r' •. i' .%�. 1n, 'rd.".. ..'SF. ,�,. �..ir5. ,-•?., �. .t ,,.'.He r'. r},. sr<" .. .'Zr?.. ..„,:. ,,. ,. _ .. ,, .,r- - 'r G.,. .'+'r..5 /.. -'c , 3 � a ., ,. + ..r3'L r ., ., .. �. � ..:. 3, .;. _r - =xr' -C1. F r ✓f � s ,c .. 3 , v. / n,� !',}Y. , .. .re ::. :., ::`.,;- .., t < .S, .£ . h � � �4 �� 268 3,1 .: .9 ,'I "1,8 0 3 02 2 8 P , Q 3 .-9 .84 �: ..,.. � ,, 2 3;0 � ,.,Y. �' r "h . , , r � $.. _.. .. .. ... ... -K t., ... � ,v„ .. .: .., ,.. r�. . +� �t.'�6J>a 4r9R e ,,.., „�Y,,..n ....,,$ rZ .,n, ,e r ��ii„ r,..�i . Yr � ,a �... 4�� r .. h. x,,,,/nn. ,. rya r,r,., ..%x/, ....a .� ....r ,�,.:;,.,, r i....�r=.rr. a tx: ,._,,,,., rF : '+1.,.E_..¢ . ..,... <'>n. , 1.,,,.....rN, �.,...:.,n:�,.,.� :�Yy, tfr=. .J:. ..f � ,a .', ..�,.-.R ADATANONGHAREMACCOUNTING\Accounting_Eliza\Grants Contracts\Grants Contracts 2022 2023\500 CDBG COVID 19 fund (EB)\2- Billings\CDBG (500) Expense Tracking 4/27/2023 0142Contract # 20-6221 C-11 Submitted to GC by: OIC OF WASHINGTON Request For Reimbursement 18 March 2023 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-1 22? X Allocable to the program? (i.e., was the dollar amount charged to the program relative to the benefits received by the program? Is the federal grantor being charged its fair share of the cost?) X Based on actual costs, not budgeted or projected amounts? X Applied uniformly to federal and non-federal activities (i.e., is the federal government being charged the same amount as if non-federal funds were being used to pay the cost)? X Given consistent accounting treatment within and between accounting periods? (Consistency in accounting requires that costs incurred for the same purpose, in like circumstances, be treated as either direct costs only or indirect costs only with respect to final cost objectives). X Calculated in conformity with generally accepted accounting principles, or another comprehensive basis of accounting, when required under the applicable cost principles? X Not included as a cost (or used to meet cost sharing requirements) of other federally -supported activities of the current or a prior period? X Net of all applicable credits? (e.g., volume or cash discounts, insurance recoveries, refunds, rebates, trade-ins, adjustments for checks not cashed, and scrap sales). N/A Not included as both a direct billing and as a component of indirect costs? N/A Properly classified (e.g., some costs may be incorrectly claimed as a direct cost instead of being incorporated as part of the indirect cost rate). X Supported by appropriate documentation? (e.g., approved purchase orders, receiving reports, vendor invoices, canceled checks, and time and attendance records.) Documentation may be in an electronic form. X Correctly charged to the proper account code and grant period? I:\DATANONSHARED\ACCOUNTING\Accounting_Eliza\Grants_Contracts\Grants_Contracts 2022_2023\500_CDBG COVID 19 fund (EB)\2- Billings\Subrecipient Checklist.doc Page 1 CDBG Public Services Expenditure Report STATE OF WASHINGTON COMMUNITY DEVELOPMENT BLOCK GRANT - CV GRANTS 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 20-6221 C-111 815 FRUITVALE BLVD REPORT MONTH: Printed Name: Eliza Baysinger YAKIMA WA 98902 Mar -23 REPORT NUMBER: Title: Senior Accountant 30 Date: 4/27/2023 TOTAL AMOUNT REQUESTED THIS PERIOD: $35,691.87 1. Name of Service Program: HOUSING CDBG CV CDBG amount requested for these program activities thisperiod: $15400.00 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 Program: SUBSISTENCE CDBG CV IFCDBG amount requested for these program activities thisperiod: Description of service program 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. 3. Name of Service Program: ADMIN HOUSING/SUBSISTENCE & OPERATIONS $21291.87 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 are properly chargeable to the referenced grant. SUBRECIPIENT: • y CDBG CONTRACT NO: Signature: ` g � OIC OF WASHINGTON 20-6221 C-111 4 815 FRUITVALE BLVD REPORT MONTH: Printed Name: Eliza Baysinger YAKIMA WA 98902 Mar -23 REPORT NUMBER: Title: Senior Accountant 30 Date: 4/27/2023 TOTAL AMOUNT REQUESTED THIS PERIOD: $269428.31 1. Name of Service Program: MICRO -ENTERPRISE CDBG amount requested for these program activities thisperiod: 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 CDBG amount requested for these program activities thisperiod: $26,428.31 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. General Ledger System OIC OF WASHINGTON For User: Eliza Baysinger Fund Expenditure report for: 500 - CDBG-CV1 10/1/20-06/30/23 (Fund status: Active) Report year: 10/1/2020 thru 6/30/2023 Period ending: March 2023 Page: Page 1 of 6 Date: 4/26/2023 Time: 8:08:57 AM -------------- 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-06/30/23 (Fund status: Active) Report year: 10/1/2020 thru 6/30/2023 Period ending: March 2023 Account Total for sub program 50 -----> Total for program 82 -----> Total for department 008 -----> Department: 009 INDIRECT ADMIN Program: 02 ADMIN. POOL -BASE 5312 SALARY ADM. ALLOCATION 5354 P/R TAX & BEN. ADM ALLOC. 5999 NON PERSONNEL ADM. ALLOC. Total for sub program -----> Total for program 02 -----> Total for department 009 -----> Department: 030 COVID 19 Program: 62 SUBSISTENCE 5311 SALARIES,WAGES EXPENSE 5351 FICA,OIC EXP 5352 LAND I,OIC SHARE 5353 STATE UCI(ES),OIC EXP 5355 PAID FAMILY MEDICAL LEAVE 5360 DISABILITY OIC EXPENSE 5361 MEDICAL INSURANCE,OIC EXP 5362 LIFE INSURANCE,OIC EXP 5363 PENSION,OIC EXP 5364 ACCRUED PTO EXP 5402 AUDIT COSTS 5403 WEBSITE DESIGN & HOSTING 5500 TRAVEL 5602 DEPRECIATION EXP EQUIP -------------- Monthly-------------- Budget Expenditures Pct $0.00 $0.00 0.00% $0.00 $0.00 0.00% $0.00 $0.00 0.00% -----------------To Date --------------- Budget Expenditures Pct $0.00 $232.55 0.00% $0.00 $259.85 0.00% $0.00 $367.33 0.00% Page: Page 2 of 6 Date: 4/26/2023 Time: 8:08:58 AM Annual budget Unexpended $0.00 ($232.55) $0.00 ($259.85) $0.00 ($367.33) $1,321.00 $0.00 0.00% $39,629.40 $17,964.12 45.33% $43,592.40 $25,628.28 $554.00 $0.00 0.00% $16,620.00 $8,445.86 50.82% $18,282.00 $9,836.14 $255.00 $0.00 0.00% $7,650.00 $3,537.23 46.24% $8,415.00 $4,877.77 $2,130.00 $0.00 0.00% $63,899.40 $29,947.21 46.87% $70,289.40 $40,342.19 $2,130.00 $0.00 0.00% $63,899.40 $29,947.21 46.87% $70,289.40 $40,342.19 $2,130.00 $0.00 0.00% $63,899.40 $29,947.21 46.87% $70,289.40 $40,342.19 $814.00 $0.00 0.00% $24,420.06 $24,512.66 100.38% $26,862.06 $2,349.40 $58.00 $0.00 0.00% $1,740.00 $1,809.78 104.01% $1,914.00 $104.22 $7.00 $0.00 0.00% $210.00 $149.88 71.37% $231.00 $81.12 $19.00 $0.00 0.00% $570.00 $411.90 72.26% $627.00 $215.10 $3.00 $0.00 0.00% $90.00 $135.67 150.74% $99.00 ($36.67) $13.00 $0.00 0.00% $390.00 $280.37 71.89% $429.00 $148.63 $258.00 $0.00 0.00% $7,740.00 $3,726.18 48.14% $8,514.00 $4,787.82 $5.00 $0.00 0.00% $150.00 $111.46 74.31% $165.00 $53.54 $71.00 $0.00 0.00% $2,130.00 $1,750.51 82.18% $2,343.00 $592.49 $89.00 $0.00 0.00% $2,670.00 $1,583.94 59.32% $2,937.00 $1,353.06 $25.00 $0_00 0.00% $750.00 $105.21 14.03% $825.00 $719.79 $0.00 Q$:17=398: ' 0.00% $0.00 $1,375.48 0.00% $0.00 ($1,375.48) $38.00 $0.00 0.00% $1,140.00 $1,284.02 112.63% $1,254.00 ($30.02) $0.00 $0.00 0.00% $0.00 $18.77 0.00% $0.00 ($18.77) General Ledger System OIC OF WASHINGTON For User: Eliza Baysinger Page: Page 3 of 6 Fund Expenditure report for: 500 - CDBG-CV1 10/1/20-06/30/23 (Fund status: Active) Date: 4/26/2023 Report year: 10/1/2020 thru 6/30/2023 Period ending: March 2023 Time: 8:08:59 AM Monthly-----. y______________ --- To Date --------------- Account Budget Expenditures Pct Budget Expenditures Pct Annual budget Unexpended 5618 CLIENT MORTGAGE PYMENT $641.00 $0.00 0.00% $19,230.00 $23,019.85 119.71% $21,153.00 ($1,866.85) 5619 HOUSING ASST/RENT C'E.t-�iti' $128.00 1,400.00 093.75% $3,840.00 $21,631.10 563.31% $4,224.00 ($17,407.10) 5700 CONSUMABLES $76.00 $0.00 0.00% $2,280.00 $783.30 34.36% $2,508.00 $1,724.70 5712 REPRODUCTION SUPPLIES $51.00 $0.00 0.00% $1,530.00 $86.26 5.64% $1,683.00 $1,596.74 5800 EQUIPMENT $0.00 $0.00 0.00% $0.00 $738.98 0.00% $0.00 ($738.98) 5910 INSURANCE $10.00 $0.00 0.00% $300.00 $108.40 36.13% $330.00 $221.60 5912 LIABILITY INSURANCE $15.00 $0.00 0.00% $450.00 $0.00 0.00% $495.00 $495.00 5945 ADVERTISING $64.00 $0.00 0.00% $1,920.00 $2,250.00 117.19% $2,112.00 ($138.00) 5949 STAFF TRAINING $47.00 $0.00 0.00% $1,410.78 $0.00 0.00% $1,551.78 $1,551.78 5959 SERVICES $512.00 $0.00 0.00% $15,360.00 $7,392.13 48.13% $16,896.00 $9,503.87 5960 COMMUNICATION $48.00 $0.00 0.00% $1,440.00 $986.61 68.51% $1,584.00 $597.39 5970 POSTAGE $7.00 $0.00 0.00% $210.00 $22.75 10.83% $231.00 $208.25 Total for sub program -----> $2,999.00 $1,573.98 52.48% $89,970.84 $94,275.21 104.78% $98,967.84 $4,692.63 Sub program: 50 SUBSISTENCE MAINTENANCE 5601 DEPRECIATION EXP BLDG. $11.00 $0.00 0.00% $330.00 $38.99 11.82% $363.00 $324.01 5602 DEPRECIATION EXP EQUIP $0.00 $0.00 0.00% $0.00 $0.04 0.00% $0.00 ($0.04) 5611 SPACE $17.00 $0.00 0.00% $510.00 $158.66 31.11% $561.00 $402.34 5630 UTILITIES $15.00 $0.00 0.00% $450.00 $39.13 8.70% $495.00 $455.87 5640 BUILD. REPAIR/MAINT. $15.00 $0.00 0.00% $450.00 $61.20 13.60% $495.00 $433.80 5910 INSURANCE $0.00 $0.00 0.00% $0.00 $0.22 0.00% $0.00 ($0.22) 5912 LIABILITY INSURANCE $3.00 $0.00 0.00% $90.00 $18.29 20.32% $99.00 $80.71 Total for sub program 50 -----> $61.00 $0.00 0.00% $1,830.00 $316.53 17.30% $2,013.00 $1,696.47 Total for program 62 -----> $3,060.00 $1,573.98 51.44% $91,800.84 $94,591.74 103.04% $100,980.84 $6,389.10 Program: 63 MICROENTRPRS 5311 SALARIES,WAGES EXPENSE $1,569.00 $17,689.53 1127.44% $47,070.02 $24,369.75 51.77% $51,777.02 $27,407.27 5351 FICA,OIC EXP $112.00 $1,300.40 1161.07% $3,360.00 $1,796.62 53.47% $3,696.00 $1,899.38 5352 LAND I,OIC SHARE $14.00 $127.40 910.00% $420.00 $167.79 39.95% $462.00 $294.21 5353 STATE UCI(ES),OIC EXP $38.00 $187.53 493.50% $1,140.00 $265.98 23.33% $1,254.00 $988.02 General Ledger System OIC OF WASHINGTON For User: Eliza Baysinger Page: Page 4 of 6 Fund Expenditure report for: 500 - CDBG-CV1 10/1/20-06/30/23 (Fund status: Active) Date: 4/26/2023 Report year: 10/1/2020 thru 6/30/2023 Period ending: March 2023 Time: 8:09:00 AM -------------- Monthly_ ------------- -----------------To Date --------------- Account Budget Expenditures Pct Budget Expenditures Pct Annual budget Unexpended 5355 PAID FAMILY MEDICAL LEAVE $7.00 $152.52 2178.86% $210.00 $188.52 89.77% $231.00 $42.48 5360 DISABILITY OIC EXPENSE $25.00 $237.83 951.32% $750.00 $278.21 37.09% $825.00 $546.79 5361 MEDICAL INSURANCE,OIC EXP $497.00 $3,215.59 647.00% $14,910.00 $3,860.51 25.89% $16,401.00 $12,540.49 5362 LIFE INSURANCEDIC EXP $10.00 $94.41 944.10% $300.00 $110.46 36.82% $330.00 $219.54 5363 PENSION,OIC EXP $136.00 $1,334.58 981.31% $4,080.00 $1,754.63 43.01% $4,488.00 $2,733.37 5364 ACCRUED PTO EXP $172.00 $1,379.03 801.76% $5,160.00 $1,656.91 32.11% $5,676.00 $4,019.09 5402 AUDIT COSTS $25.00 $0.00 0.00% $750.00 $105.21 14.03% $825.00 $719.79 5403 WEBSITE DESIGN & HOSTING $0.00 $173.98 0.00% $0.00 $1,375.49 0.00% $0.00 ($1,375.49) 5500 TRAVEL $51.00 $0.00 0.00% $1,530.00 $769.69 50.31% $1,683.00 $913.31 5602 DEPRECIATION EXP EQUIP $0.00 $0.00 0.00% $0.00 $3.49 0.00% $0.00 ($3.49) 5618 CLIENT MORTGAGE PYMENT $51.00 $0.00 0.00% $1,530.00 $0.00 0.00% $1,683.00 $1,683.00 5619 HOUSING ASST/RENT $1,435.00 $0.00 0.00% $43,050.00 $0.00 0.00% $47,355.00 $47,355.00 5700 CONSUMABLES $102.00 $45.47 44.58% $3,060.00 $338.07 11.05% $3,366.00 $3,027.93 5712 REPRODUCTION SUPPLIES $64.00 $0.00 0.00% $1,920.00 $0.00 0.00% $2,112.00 $2,112.00 5800 EQUIPMENT $102.00 $0.00 0.00% $3,060.00 $3,968.68 129.70% $3,366.00 ($602.68) 5910 INSURANCE $10.00 $54.17 541.70% $300.00 $67.98 22.66% $330.00 $262.02 5912 LIABILITY INSURANCE $15.00 $1.76 11.73% $450.00 $1.76 0.39% $495.00 $493.24 5941 DUES/MEMBERSHIPS $0.00 $41.67 0.00% $0.00 $41.67 0.00% $0.00 ($41.67) 5945 ADVERTISING $64.00 $0.00 0.00% $1,920.00 $1,566.67 81.60% $2,112.00 $545.33 5949 STAFF TRAINING $51.00 $0.00 0.00% $1,530.00 $0.00 0.00% $1,683.00 $1,683.00 5959 SERVICES $51.00 $0.00 0.00% $1,530.00 $25,697.02 1679.54% $1,683.00 ($24,014.02) 5960 COMMUNICATION $48.00 $259.11 539.81% $1,440.00 $319.57 22.19% $1,584.00 $1,264.43 5965 CLIENT TRAINING $51.00 $0.00 0.00% $1,530.00 $0.00 0.00% $1,683.00 $1,683.00 5970 POSTAGE $7.00 $0.00 0.00% $210.00 $0.00 0.00% $231.00 $231.00 5994 MEETING EXPENSE $0.00 $133.33 0.00% $0.00 $133.33 0.00% $0.00 ($133.33) Total for sub program -----> $4,707.00 $26,428.31 561.47% $141,210.02 $68,838.01 48.75% $155,331.02 $86,493.01 Sub program: 50 MICRO MAINTENANCE 5601 DEPRECIATION EXP BLDG. $14.00 $0.00 0.00% $420.00 $4.20 1.00% $462.00 $457.80 5602 DEPRECIATION EXP EQUIP $0.00 $0.00 0.00% $0.00 $0.01 0.00% $0.00 ($0.01) General Ledger System OIC OF WASHINGTON For User: Eliza Baysinger Page: Page 5 of 6 Fund Expenditure report for: 500 - CDBG-CV1 10/1/20-06/30/23 (Fund status: Active) Date: 4/26/2023 Report year: 10/1/2020 thru 6/30/2023 Period ending: March 2023 Time: 8:09:01 AM -------------- Monthly --__--------_- -----------------To Date --- _-_--------- Account Budget Expenditures Pct Budget Expenditures Pct Annual budget Unexpended 5611 SPACE 5630 UTILITIES 5640 BUILD. REPAIR/MAINT. 5910 INSURANCE 5912 LIABILITY INSURANCE Total for sub program 50 -----> Total for program 63 -----> Program: 64 HOUSING 5311 SALARIES,WAGES EXPENSE 5351 FICA,OIC EXP 5352 LAND I,OIC SHARE 5353 STATE UCI(ES),OIC EXP 5355 PAID FAMILY MEDICAL LEAVE 5360 DISABILITY OIC EXPENSE 5361 MEDICAL INSURANCE,OIC EXP 5362 LIFE INSURANCE,OIC EXP 5363 PENSION,OIC EXP 5364 ACCRUED PTO EXP 5402 AUDIT COSTS 5411 CREDIT REPORTS 5500 TRAVEL 5602 DEPRECIATION EXP EQUIP 5618 CLIENT MORTGAGE PYMENT 5619 HOUSING ASST/RENT 5700 CONSUMABLES 5712 REPRODUCTION SUPPLIES 5800 EQUIPMENT 5910 INSURANCE 5912 LIABILITY INSURANCE $20.00 $0.00 0.00% $600.00 $21.65 3.61% $660.00 $638.35 $18.00 $0.00 0.00% $540.00 $4.61 0.85% $594.00 $589.39 $18.00 $0.00 0.00% $540.00 $11.88 2.20% $594.00 $582.12 $0.00 $0.00 0.00% $0.00 $0.04 0.00% $0.00 ($0.04) $4.00 $0.00 0.00% $120.00 $4.35 3.63% $132.00 $127.65 $74.00 $0.00 0.00% $2,220.00 $46.74 2.11% $2,442.00 $2,395.26 $4,781.00 $26,428.31 552.78% $143,430.02 $68,884.75 48.03% $157,773.02 $88,888.27 $1,648.00 $1,442.07 87.50% $49,440.74 $8,211.07 16.61% $54,384.74 $46,173.67 $118.00 $106.13- 89.94% $3,540.00 $616.59 17.42% $3,894.00 $3,277.41 $15.00 $9.88'` 65.87% $450.00 $46.54 10.34% $495.00 $448.46 $40.00 $15.28- 38.20% $1,200.00 $114.51 9.54% $1,320.00 $1,205.49 $7.00 $12.24 •174.86% $210.00 $58.71 27.96% $231.00 $172.29 $26.00 $19.81' 76.19% $780.00 $88.15 11.30% $858.00 $769.85 $522.00 $256.51 -- 49.14% $15,660.00 $727.87 4.65% $17,226.00 $16,498.13 $10.00 $7.84- 78.40% $300.00 $35.01 11.67% $330.00 $294.99 $143.00 $107.12- 74.91% $4,290.00 $649.27 15.13% $4,719.00 $4,069.73 $181.00 $114.87- 63.46% $5,430.00 $512.99 9.45% $5,973.00 $5,460.01 $7.00 $0.00 0.00% $210.00 $45.46 21.65% $231.00 $185.54 $0.00 $0.00 0.00% $0.00 $403.80 0.00% $0.00 ($403.80) $51.00 $0.00 0.00% $1,530.00 $1,293.75 84.56% $1,683.00 $389.25 $0.00 $0.00 0.00% $0.00 $5.75 0.00% $0.00 ($5.75) $153.00 $0.00 0.00% $4,590.00 $7,573.46 165.00% $5,049.00 ($2,524.46) $1,128.00 $0.00 0.00% $33,840.00 $42,074.45 124.33% $37,224.00 ($4,850.45) $89.00 $0.00 0.00% $2,670.00 $1,209.81 45.31% $2,937.00 $1,727.19 $64.00 $0.00 0.00% $1,920.00 $161.96 8.44% $2,112.00 $1,950.04 $102.00 $0.00 0.00% $3,060.00 $2,568.42 83.94% $3,366.00 $797.58 $10.00 $3.52 ' 35.20% $300.00 $30.33 10-11% $330.00 $299.67 $15.00 $0.00 0.00% $450.00 $0.00 0.00% $495.00 $495.00 General Ledger System OIC OF WASHINGTON For User: Eliza Baysinger Page: Page 6 of 6 Fund Expenditure report for: 500 - CDBG-CV1 10/1/20-06/30/23 (Fund status: Active) Date: 4/26/2023 Report year: 10/1/2020 thru 6/30/2023 Period ending: March 2023 Time: 8:09:03 AM Monthly -----------------To Date --------------- Account Budget Expenditures Pct Budget Expenditures Pct Annual budget Unexpended 5945 ADVERTISING 5949 STAFF TRAINING 5960 COMMUNICATION 5970 POSTAGE Total for sub program -----> Sub program: 50 HOUSING MAINT 5601 DEPRECIATION EXP BLDG. 5602 DEPRECIATION EXP EQUIP 5611 SPACE 5630 UTILITIES 5640 BUILD. REPAIR/MAINT. 5910 INSURANCE 5912 LIABILITY INSURANCE Total for sub program 50 -----> Total for program 64 -----> Total for department 030 -----> Fund Totals $89.00 $0.00 0.00% $2,670.00 $6,220.00 232.96% $2,937.00 ($3,283.00) $51.00 $0.00 0.00% $1,530.00 $200.00 13.07% $1,683.00 $1,483.00 $48.00 $22.62' 47.13% $1,440.00 $1,455.86 101.10% $1,584.00 $128.14 $12.00 $0.00 0.00% $360.00 $169.01 46.95% $396.00 $226.99 $4,529.00 $2,117.89 46.76% $135,870.74 $74,472.77 54.81% $149,457.74 $74,984.97 $14.00 $0.00 0.00% $420.00 $5.59 1.33% $462.00 $456.41 $0.00 $0.00 0.00% $0.00 $0.01 0.00% $0.00 ($0.01) $20.00 $0.00 0.00% $600.00 $17.08 2.85% $660.00 $642.92 $18.00 $0.00 0.00% $540.00 $7.79 1.44% $594.00 $586.21 $18.00 $0.00 0.00% $540.00 $14.64 2.71% $594.00 $579.36 $0.00 $0.00 0.00% $0.00 $0.02 0.00% $0.00 ($0.02) $4.00 $0.00 0.00% $120.00 $4.09 3.41% $132.00 $127.91 $74.00 $0.00 0.00% $2,220.00 $49.22 2.22% $2,442.00 $2,392.78 $4,603.00 (::$2:,:117:.89 46.01% $138,090.74 $74,521.99 53.97% $151,899.74 $77,377.75 $12,444.00 $30,120.18 242.05% $373,321.60 $237,998.48 63.75% $410,653.60 $172,655.12 $14,574.00 $30,120.18 206.67% $437,221.00 $268,313.02 61.37% $480,943.00 $212,629.98 $ 1,400.00 COVID-19 Utility/Rent/Mortgage Subsistence Payments Project Detail Report Grant County CDBG Contract #XX-XXXXX-XXX As of 3/31/2023 On=going CQVI� Assistance: Details Note: No direct payments to clients Client Details Assistance' Details COVID Eli ` ibili Certification Intake Information otal.$ Address to Date of Clien Withi Total, CDB Purchase Order/ Type of Assistance: Amount of Mail . Assistanc t Dupli. n, Househ G _ Approving Payment to 3rd " s Client Name or Initials Client Util" /Rent/ rtY Monthl Assistance $. y. Assistance Assistance a Date Addr 'catio Tare g old LMl Narrative - Economic impact Intake Intake Staff Supervisor Pe Party # or Identification # ' Client Address Zip. Code Mortgage Payment Given � Paid to:: :Payment Applicatio Assistance Paid ess � n of t Eligi due to COVI D Date/time Name. if applicable) ( pp Works in a restaurant and his Ann Smith or A.S. or 123 Rock Lane, ABC 1111 Main St. hours were reduced due to 5/29/20 Anne Mary Smith 20 )000OC Client #1 Olympia 98502 Rent $ 1,000.00 $ 3,000.00 Apartments Olympia, 6/2/2020 44012 Y N Y o <50% Y COVID, they still did to -go orders, 10:30am Shirley 5/30/20 98502 so it didn't stop entirely, but was reduced by half. 102 Selkirk Ave He fell behind due to high risk with 716 2nd St Fabela's Rentals Mattawa, WA health and Covid, needed surgery Angela 3/9/2023 Mattawa, WA 99349 Rent $ 700.00 $ 1,400.00 and Construction 99349 3/22/23 4/16/2023 Y N Y <50% Y and got behind in his rent. 3/15/2023 Vasquez Candi Jaeger 3/31/2023 $ 1,400.00 COVID-19 Micro- subsistence Payments Project Detail Report Grant County CDBG Contract #XX-XXXXX-XXX As of 313112023 'On-goingCOVID Assistance_Details Note: No direct a ments to clients Client Details - Assistance Details . ` COVID Eli ibili Certification - Intake Information Total $ . Address o Dateof Clien WithiTotal CDB Purchase Order/ Amount -of Mail Assistant t Dupli n Househ G . Approving Payment to 3rd Client Name or Initials Client Type of Assistance: $Monthly Assistance .: , Assistance Assistance a Date Addr catio Targe old ; I -Mi Narrative - Economic impact Intake Intake Staff Supervisor Party Pa # or Identification # Client Address Zi Code P Mico -Subsistence Payment Given Paid to: ° Payment Ap licatio Assistance Paid ess n of t Y_ _ Y_ B Eligi due to COVID Date/time Name (if applicable) Works in a restaurant and his 20-)XOO( Ann Smith or A.S.19 S. or 123 Rock Lane, 98502 Micro -Subsistence Main St. ABC s 1,000.00 $ . 3,000.00 Olympia, 6/212020 44012 Y N Y o <50% Y hours were reduced due to orders, COVID, they still did to -go ord 5/29/20 Anne Mary Smith Client #1 Olympia Apartments 98502 so it didn't stop entirely, but was 10:30am Shirley 5130/20 reduced by half. None $ - 3/31/2023 00 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-6 030-6 030-6 030-6 030-6 030-6 030-6 030-6 030-6 030-62-5 030-62-5 030-62-5 030-62-5 030-62-5 030-62-5 030-62-5 030-E 030-E 030-E 030-E 030-E 030-E 030-E 030-E OIC of Washington CDBG CV1 Expense Tracking Summary - 500 Grant Period: 10/01/2020 - 06/30/23 20-6221 C-111 BILLING PERIOD- APRIL 2023 DESCRIPTION ACCOUNT BUDGET YTD EXPENSED (as of 04/30/23) YTD BILLED (as of 03/31/23) BUDGET BALANCE DIFFERENCE (as of 04/30/23) 05Q PUBLIC SERVICES -SUBSISTENCE PAYMENTS PUBLIC SERVICES ADMIN (030-62,030-62-50) / 05X HOUSING ASSISTANCE ADMINISTRATION - INDIRECT (009) $65,040.17 $277028.35 $237767.27 $37261.08 $38,011.82 ADMINISTRATION - DIRECT (008) $317.83 $317.83 $317.83 $0.00 $0.00 Salary 5311 $17,863.84 $247512.66 $24,512.66 $0.00 ($6,648.82) FICA, OIC Exp 5351 $1,319.00 $1,809.78 $17809.78 $0.00 ($490.78) L AND I, OIC Share 5352 $109.00 $149.88 $149.88 $0.00 ($40.88) State UCI,OIC Exp 5353 $300.00 $411.90 $411.90 $0.00 ($111.90) PFML 5355 $99.00 $135.67 $135.67 $0.00 ($36.67) Disabilit , OIC Exp 5360 $204.00 $280.37 $280.37 $0.00 ($76.37) Medical Insurance, OIC Exp 5361 $2,716.00 $37726.18 $37726.18 $0.00 ($1,010.18) Life Insurance, OIC Exp 5362 $81.00 $111.46 $111.46 $0.00 ($30.46) Pension, OIC Exp 5363 $1,276.00 $17750.51 $17750.51 $0.00 ($474.51) Accrued PTO Exp 5364 $1,154.00 $1,583.94 $1,583.94 $0.00 ($429.94) Audit Costs 5402 $77.00 $105.21 $105.21 $0.00 ($28.21) Website design & Hosting 5403 $1,002.00 $17547.68 $17375.48 $172.20 ($545.68) Mileage/Perdiem:-In state 5500 $936.00 $17284.02 $11284.02 $0.00 ($348.02) Depreciation Exp Equip 5602 $14.00 $20.19 $18.77 $1.42 ($6.19) Consumables 5700 $571.00 $17138.72 $783.30 $355.42.. ($567.72) Reproduction Supplies 5712 $63.00 $86.26 $86.26 $0.00 ($23.26) Equipment -added 5800 $539.00 $738.98 $738.98 $0.00 ($199.98) Insurance 5910 $79.00 $108.40 $108.40 $0.00 ($29.40) !.Advertising 5945 $1,640.00 $27250.00 $27250.00 $0.00 ($610.00) Communication (Telephone/Cell & ISP) 5960 $719.00 $17015.79 $986.61 $29.1810* ($296.79) Postage 5970 $17.00 $24.14 $22.75 $1.39 ($7.14) Depreciation Exp Bldg 5601 $28.00 $48.66 $38.99 $9.67 Depreciation Exp Equip 5602 $0.00 $0.05 $0.04 $0.01 ($0.05), Space 5611 $116.00 $208.30 $158.66 $49.64 ($92.30) Utilities 5630 $29.00 $47.99 $39.13 $8.86 ($18.99) Build Repair/Maint. 5640 $45.00 $70.52 $61.20 $9.32 ($25.52) Insurance 5910 $0.00 $0.30 $0.22 $0.08 ($0.30) Liability Insurance 5912 $13.00 $21.54 $18.29 $3.25 ($8.54) SUBTOTAL $965367.84 $70,535.28 $66,633.76 $3,901.52 $25,832.56 SUBSISTENCE PUBLIC SERVICES PAYMENTS (030-62,030-62-50) !.Client Mortgage Payment 5618 $333956.00 $231019.85 $23,019.85 $0.00 $10,936.15 Housing Asst/Rent 5619 $31,907.00 $211631.10 $217631.10 $0.00 $10,275.90 > Services 5959 $10,904.00 $7,392.13 $77392.13 $0.00 $3,511.87 Client Mortgage Payment 5618 $11,171.00 $77573.46 $7,573.46 $0.00 $3$97.54 Housing Asst/Rent 5619 $62,062.00 $427074.45 $421074.45 $0.00 $19,987.55 SUBTOTAL $1501000.00 $101,690.99 $101,690.99 $0.00 $48,309.01 05X - HOUSING INFORMATION AND REFERRAL SERVICES (030-64,030-64-50) t Salary 5311 $36,549.59 $10,200.22 $8,211.07 $17989.15 $26,349.37 1 FICA, OIC Exp 5351 $2,744.00 $765.06 $616.59 $148.47 $1,978.94 I. L AND I, OIC Share 1 5352 $207.00 $57.96 $46.54 $11.42 r $149.04 I:\DATANONSHARED\HCCOUNTING\Accounting_Eliza\Grants_Contracts\Grants_Contracts 2022_2023\500_CDBG COVID 19 fund (EB)\2- Billings\CDBG (500)_Expense Tracking 5/26/2023 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 030-6 030-6 030-6 030-6 030-64-5 030-64-5 030-64-5 030-64-5 030-64-5 030-64-5 030-64-5 oa oa 030-6 030-6 030-6 030-6 030-E 030-E 030-E 030-E 030-E 030-E 030-E 030-E 030-E 030-E 030-E 030-E 030-E 030-E 030-E DESCRIPTION ACCOUNT BUDGET YTD EXPENSED (as of 04/30/23) YTD BILLED BUDGET BALANCE (as of 03/31/23) DIFFERENCE (as of 04/30/23) State UCI,OIC Exp 5353 $510.00 $135.60 $114.51 $21.09 $374.40 PFML 5355 $261.00 $76.74 $58.71 $18.0340,$184.26 Disability, OIC Exp 5360 $392.00 $117.32 $88.15 $29.17 $274.68 Medical Insurance, OIC Exp 5361 $3,240.00 $984.76 $727.87 $256.89 $2,255.24 Life Insurance, OIC Exp 5362 $156.00 $46.58 $35.01 $11.57 $109.42 Pension, OIC Exp 5363 $2,890.00 $807.05 $649.27 $157.7840 $2,082.95 Accrued PTO Exp 5364 $2,283.00 $760.97 $512.99 $247.98 $1,522.03 Audit Costs 5402 $202.00 $45.46 $45.46 $0.00 $156.54 Credit Reports 5411 $1,797.00 $490.50 $403.80 $86.70 $1,306.50 Mileage/Perdiem:-In state 5500 $5,759.00 $17339.77 $17293.75 $46.02 $43419.23 Depreciation Exp Equip 5602 $26.00 $5.75 1 $5.75 $0.00 $20.25 Consumables 5700 $5,385.00 $1,209.81 $17209.81 $0.00 $4,175.19 Reproduction Supplies 5712 $721.00 $173.35 $161.96 $11.39 lop $547.65 Equipment -added 5800 $11,432.00 $27568.42 $27568.42 $0.00 $8,863.58 Insurance 5910 $135.00 $34.91 $30.33 $4.5810 $100.09 .Advertising 5945 $27,685.00 $6,220.00 $6,220.00 $0.00 $21,465.00 Staff Training 5949 $890.00 $200.00 $200.00 $0.00 $690.00 Communication (Telephone/Cell & ISP) 5960 $6,480.00 $17455.86 $17455.86 $0.00 $51024.14 Postage 5970 $752.00 $169.01 $169.01 $0.00 $582.99 Depreciation Exp Bldg 5601 $25.00 $5.59 $5.59 $0.00 $19.41 Depreciation Exp Equip 5602 $0.00 $0.01 $0.01 $0.00 ($0.01) Space 5611 $76.00 $17.08 $17.08 $0.00 $58.92 Utilities 5630 $35.00 $7.79 $7.79 $0.00 $27.21 Build Repair/Maint. 5640 $65.00 $14.64 $14.64 $0.00 $50.36 Insurance 5910 $0.00 $0.02 $0.02 $0.00 ($0.02) Liability- Insurance 5912 $18.00 $4.09 $4.09 $0.00 $13.91 SUBTOTAL $110,715.59 $27,914.32 $24,874.08 $3,040.24 $82,801.27. :; TOTAL:SUBSISTENGE /:Ht3USLNC - _ . ...., :: 357 083.43 ;;;:.2.00 1.40.59 18C MICROENTERPRISE ASSISTANCE /..! r � ././ .,jt .y � ate' � a, / ri /' ;i ..�.;y, ..�. .y. tORQE - �`ER�?RIS��►;S 15TA1�[C �/ . / M , .: . _ .. _ S ��/ .o-.s4� � ADMINISTRATION - INDIRECT (009) $29,611.50 $117089.37 $6,179.94 $41909.43 $18,522.13 ADMINISTRATION - DIRECT (008) $49.50 $49.50 $49.50 $0.00 $0.00 Salary 5311 $68,487.57 $44,902.16 $241369.75 $207532.41 $23,585.41 FICA, OIC Exp 5351 $5,049.00 $37302.25 $17796.62 $17505.63 $1,746.75 L AND I, OIC Share 5352 $472.00 $298.91 $167.79 $131.12.0, $173.09 State UCI,OIC Exp 5353 $748.00 $483.62 $265.98 $217.64 $264.38 PFML 5355 $530.00 $361.13 $188.52 $172.61 $168.87 Disability, OIC Exp 5360 $782.00 $575.18 $278.21 $296.97 $206.82 Medical Insurance, OIC Exp 5361 $10,849.00 $77710.21 $37860.51 $31849.70 to $3,138.79 &ife Insurance, OIC Exp 5362 $310.00 $228.55 $110.46 $118.09 $81.45 � Pension, OIC Exp 5363 $4,931.00 $31264.76 $11754.63 $1,510.13 $1,666.24 s Accrued PTO Exp 5364 $4,657.00 $37538.27 $17656.91 $1,881.36 $1,118.73 i Audit Costs 5402 $296.00 $105.21 $105.21 $0.00 $190.79 s Website Design & Hosting 5403 $3,866.00 $1,547.70 $1,375.49 $172.21 $2,318.30 s Mileage/Perdiem:-In state 5500 $2,163.00 $905.93 $769.69 $136.24 $1,257.07 s Depreciation Exp Equip 5602 $10.00 $3.49 $3.49 $0.00 $6.51 s Consumables 5700 $950.00 $610.94 $338.07 $272.87 $339.06 s Equipment -added 5800 $11,153.00 $3,968.68 $3,968.68 $0.00 $7,184.32 s Insurance 5910 $191.00 $125.30 $67.98 $57.32 $65.70 s Liability Insurance 5912 1 $5.00 1 $3.28 $1.76 $1.52 $1.72 s Advertising 5945 $4,403.00 $1,566.67 $1,566.67 $0.00 $2,836.33 I:\DATANONSHARED\ACCOUNTING\Accounting_Eliza\Grants_Contracts\Grants_Contracts 2022_2023\500_CDBG COVID 19 fund (EB)\2- Billings\CDBG (500)_Expense Tracking 5/26/2023 I 030-6: 030-6: 030-6: 030-63-5( 030-63-5( 030-63-5( 030-63-5( 030-63-5( 030-63-5( 030-63-5( 030-6; 030-6; 030-6; 030-6; 030-6; 0304 YTD EXPENSED DESCRIPTION ACCOUNT BUDGET (as of 04/30/23) YTD BILLED BUDGET BALANCE (as of 03/31/23) DIFFERENCE (as of 04/30/23) Dues/Memberships 5941 $117.00 $41.67 $41.67 $0.00 $75.33 Communication (Telephone/Cell & ISP) 5960 $898.00 $319.57 $319.57 $0.00 $578.43 Meeting Expense 5994 $375.00 $133.33 $133.33 $0.00 $241.67 Depreciation Exp Bldg 5601 $12.00 $4.20 $4.20 $0.00 $7.80 Depreciation Exp Equip 5602 $0.00 $0.01 $0.01 $0.00 ($0.01) Space 5611 $61.00 $21.65 $21.65 $0.00 $39.35 Utilities 5630 $13.00 $4.61 $4.61 $0.00 $8.39 Build Repair/Maint. 5640 $33.00 $11.88 $11.88 $0.00 $21.12 Insurance 5910 $0.00 $0.04 $0.04 $0.00 ($0.04) Liability Insurance 5912 $12.00 $4.35 $4.35 $0.00 $7.65 y , ✓" :/��% /�/ y-.��� i- /. � .�,/- .;ri. ... v_•- y ! '/_-./_/`� .. .. -ice / v/ -i .l: iJ wS U BTOTAL�. 5 a�4 5 . _.. _ ._. .-_ ._ ✓/,- .-_ ,�._. �.. -_... ./ ... _.,�/. -_.; ./._/ . /_./ .lJ". ice. /. �/: ;moi // ii ./., // /v � .S/-./_✓ �n � � . Client Mortgage Payment 5618 $0.00 $0.00 $0.00 $0.00 $0.00 Housing Asst/Rent 5619 $0.00 $0.00 $0.00 $0.00 $0.00 Services 5959 $50,000.00 $25,697.02 $25,697.02 $0.00 $24,302.98 ..,- . _ __ y� �// _ �,, _/ _/ ✓ t / ./�'., .i _ / �/�-:...r/ //. � �../ � -- /, , ,..-.....G� . ,... �_'/��.. / 2 -y � �//.�-.�/•":�i//�/,_, ./. is „✓ ;//.' - � __ s ' - , � / / / / :.E MLOC�4�NT Consultant / Contract Services 5400 $0.00 $0.00 $0.00 $0.00 $0.00 Training Materials 5730 $0.00 $0.00 $0.00 $0.00 $0.00 Client Training 5965 $12,000.00 $0.00 $0.00 $0.00 $12,000.00 - / i F ^?yr ./ ✓ .s . ,. /,i,. . ✓,.-/�� /'ice. ,/J � _/ _�, ..,ice .v' _ r. .' .. __ ... /.. ,..'_ _ � /iii _-`fir/ - _/ /. ��; � / /fes :-/--, i/ � _i /' y„ /�., _ / _ ,ice //. i /� . / ,iii i, s .._ _ ,-s%ii _/. / T. ,.." .. i ii i. _ i .�/"_� � _� "�- � -iii. ��'� i:� iM� o OQ TOTALMIGROENTERPRISE =: $213,034' $110,879.44 $75,1-14.19 $35,765.25 $102,'155.13 TOTALGRA NT ,. == .- 268 31;3.02 - 42 707:01 259.097.97 _ I:\DATANONSHARED\ACCOUNTING\Accounting_Eliza\Grants_Contracts\Grants Contracts 2022_2023\500_CDBG COVID 19 fund (EB)\2- Billings\CDBG (500)_Expense Tracking 5/26/2023 OIC of Washington CDBG M Budget Tracking Summary - 500 Grant Period: 10/0112020 - 06/30/23 20-6221 C-111 BILLING PERIOn- Anril 2123 DESCRIPTION BUDGET YTD EXPENSED (as of 04/30/23) YTD BILLED (as of 03131/23) DIFFERENCE BUDGET BALANCE (as of 04/30/23) 05Q PS SUBSISTENCE PAYMENTS / 05X HOUSING ASSISTANCE . 62 SUBSISTENCE $181,009.84 $144,880.09 $1447239.65 $640.44 $36,129.75 19.96% 64 HOUSING $110,715.59 $277914.32 $24,874.08 $3,040.24 $82,801.27 74.79% ADMINISTRATION $65,358.00 $27,346.18 $24,085.10 $31261.08 $38,011.82 58.16% s ,/::. r /: � �'s� �� v , . � .. /,._ ,_ - ,,,. ,�, _ .. ,...,_�_ � � __, , ,_,.__/„/ f� / � �� _ �y� s-���. � _ice i / ._. i i/, _/�, /% _ i-�%i �'i.� . �,/ '/_� ` ��"- / �,i'�'�...// //, i�s�;- x _�s�.�, � , 1::83 'L9 .83:/-'� �%. ./,.� /; �- 'L,5 Iw r�._ �6 94 84 //� � �F _/ .,_�-,__ � _. _ /�_�_,� , ._ � ,_ � /. � / / � �i �� _. _ .� � . oil /.<� � ,�. � � ,.✓r �: � / / � / _ rOWN _ 43.95 /os.�%/ 18C MICROENTERPRISE ASSISTANCE 63 MICROENTERPRISE $183,373.57 $99,740.57 $68,884.75 $30,855.82 $83,633.00 45.61% ADMINISTRATION $29,661.00 $11,138.87 $6,229.44 $4,909.43 $18,522.13 62.45% / .: ,- - �= sem- ,... ,moi _ / / �' .. �.. � _ / - ,i_ /, _.: - _..�/,�. /.. -' �, �.,-,.�" .l✓ ,�N - ��%i_-//�� �✓. __ �!� ii- �i�-%� .� ,. -� 3 =,: 3 n _ ":55E1: s 3. ,3 ..,::, .., � 47.95 TOTAL GRANT $570,118.00 $311,020.03 $268,313.02F $42,707,01F $259,097.971 45.45% Admin Calculation % of Admin Billed YTD Admin (a) YTD Admin Difference (as of 04/30/23) (as of 04/30/23) (as of 03/31/23) 12% $38,485.05 $30,314.54 $8,170.51 BUDGET CATEGORY AMT % (b) SUB PYMTS / HOUSING ASSIST TOTAL $169,113.73 0.710566429 MICRO TOTAL $68,884.75 0.289433571 TOTAL $237,998.48 TOTAL (aXb=c) SUB PYMTS/HOUSING ASSIST -PROPORTIONATE SHARE OF ADM EXPENSE $27,346.18 MICRO -PROPORTIONATE SHARE OF ADMIN EXPENSE $11,138.87 BILLABLE ADMIN TOTAL $38,485.05 I:\DATANONSHARED\ACCOUNTING\Accounting_Eliza\Grants_Contracts\Grants_Contracts 2022_2023\500_CDBG COVID 19 fund (EB)\2- Billings\CDBG (500)_Expense Tracking 5/26/2023 CDBG Public Services Expenditure Report STATE OF WASHINGTON COMMUNITY DEVELOPMENT BLOCK GRANT - CV GRANTS 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: 4 OIC OF WASHINGTON 20-6221 C-111', 815 FRUITVALE BLVD REPORT MONTH: Printed Name: Eliza Baysinger YAK[MA WA 98902 Apr -23 7 REPORT NUMBER: Title: Senior Accountant 31 Date: 5/26/2023 , TOTAL AMOUNT REQUESTED THIS PERIOD: $69941.76 ;WIT 1. Name of Service Program: HOUSING CDBG CV IFCDBG amount requested for these program activities this period: $3,040.24 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 are and qualifying households throughout the service area.�4 2. Name of Service Program: SUBSISTENCE CDBG CV CDBG amount requested for these program activities thisperiod: Description of service program 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. 3. Name of Service Program: ADMIN HOUSING/SUBSISTENCE & OPERATIONS $3,901.52 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 are 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: Eliza Baysinger YAK IA WA 98902 Apr -23 REPORT NUMBER: Title: Senior Accountant 31 Date: 5/26/2023 TOTAL AMOUNT REQUESTED THIS PERIOD: $359765.25 1. Name of Service Program: MICRO -ENTERPRISE CDBG amount requested for these program activities this period: 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 JFCDBG amount requested for these program activities this period: $359765.25 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 Transaction listing by account Fund: CDBG-CV110/1/20-06/30/23 General Ledger System From 4/2023 through 4/2023 Page: Page 1 of 5 Date: 5/26/2023 Time: 9:30:41 AM Account Trans. date Trans. type Doc. num. Vendor/Customer Journal description Debit amount Credit amount 500-030-62- -5403 COVID 19 - SUBSISTENCE - - WEBSITE DESIGN & HOSTING April, 2023 5/15/2023 AJE 144948 500-030-63--5311 COVID 19 - MICROENTRPRS - - SALARIES,WAGES EXPENSE April, 2023 4/30/2023 Payroll 33634 4/30/2023 Payroll 33634 500-030-63--5351 COVID 19 - MICROENTRPRS - - FICA,OIC EXP April, 2023 4/30/2023 Payroll 33634 4/30/2023 Payroll 33634 500-030-63--5352 COVID 19 - MICROENTRPRS - - L AND I,OIC SHARE April, 2023 4/30/2023 Payroll 33634 4/30/2023 Payroll 33634 500-030-63--5353 COVID 19 - MICROENTRPRS - - STATE UCI(ES),OIC EXP April, 2023 4/30/2023 Payroll 33634 4/30/2023 Payroll 33634 500-030-63--5355 COVID 19 - MICROENTRPRS - - PAID FAMILY MEDICAL LEAVE Exp Case Worthy user/maint Supp $172.20 Fees April 2023 Period Total ---> $172.20 Cummulative Total ---> $172.20 • Payroll wage expense for period $14,366.01 ending 4/30/2023 Payroll wage expense for period $6,166.40 ending 4/30/2023 Period Total ---> $20,532.41 Cummulative Total ---> $20,532.41 r $0.00 Payroll FICA expense for period $1,044.68 ending 4/30/2023 Payroll FICA expense for period $460.95 ending 4/30/2023 Period Total ---> $1,505.63 Cummulative Total ---> $1,505.63— $0.00 Payroll WC expense for period $102.62 ending 4/30/2023 Payroll WC expense for period $28.50 ending 4/30/2023 Period Total ---> $131.12 Cummulative Total ---> $131.12'"` $0.00 Payroll UI expense for period ending $152.27 4/30/2023 Payroll UI expense for period ending $65.37 4/30/2023 Period Total ---> $217.64 Cummulative Total ---> $217.64 $0.00 OIC OF WASHINGTON For User: Eliza Baysinger Transaction listing by account Fund: CDBG-CV1 10/1/20-06/30/23 General Ledger System From 4/2023 through 4/2023 Page: Page 2 of 5 Date: 5/26/2023 Time: 9:30:42 AM Account Trans. date Trans. type Doc. num. Vendor/Customer Journal description Debit amount Credit amount April, 2023 4/30/2023 Payroll 33634 500-030-63--5360 COVID 19 - MICROENTRPRS - - DISABILITY OIC EXPENSE April, 2023 4/30/2023 Payroll 33634 4/30/2023 Payroll 33634 500-030-63--5361 COVID 19 - MICROENTRPRS - - MEDICAL INSURANCE,OIC EXP April, 2023 4/30/2023 Payroll 33634 4/30/2023 Payroll 33634 500-030-63--5362 COVID 19 - MICROENTRPRS - - LIFE INSURANCE,OIC EXP April, 2023 4/30/2023 Payroll 33634 500-030-63--5363 COVID 19 - MICROENTRPRS - - PENSION,OIC EXP April, 2023 4/30/2023 Payroll 33634 500-030-63--5364 COVID 19 - MICROENTRPRS - - ACCRUED PTO EXP April, 2023 4/30/2023 Payroll 33634 4/30/2023 Payroll 33634 4/30/2023 Payroll 33634 Payroll cost allocation (PFML) for $172.61 period ending 4/30/2023 Period Total ---> $172.61 — Cummulative Total ---> $172.61 $0.00 Payroll cost allocation (LNG DISAB.) $239.70 for period ending 4/30/2023 Payroll cost allocation (SHT DISAB.) $57.27 for period ending 4/30/2023 Period Total ---> $296.97 .w� Cummulative Total ---> $296.97 $0.00 Payroll cost allocation (EAP SERVIC) $15.96 for period ending 4/30/2023 Payroll cost allocation (MED INS) for $3,833.74 period ending 4/30/2023 Period Total ---> $3,849.70— Cummulative Total ---> $3,849.70 $0.00 Payroll cost allocation (LIFE) for $118.09 period ending 4/30/2023 Period Total ---> $118.09 Cummulative Total ---> $118.09 $0.00 Payroll cost allocation (PENS.) for $1,510.13 period ending 4/30/2023 Period Total ---> $1,510.13 Cummulative Total ---> $1,510.13 $0.00 Payroll cost allocation (PTO ALLOC) $78.63 for period ending 4/30/2023 Program expense for vacation $1,288.47 accrued 4/30/2023 Program expense for vacation $514.26 accrued 4/30/2023 OIC OF WASHINGTON For User: Eliza Baysinger Transaction listing by account Fund: CDBG-CV110/1/20-06/30/23 General Ledger System From 4/2023 through 4/2023 Page: Page 3 of 5 Date: 5/26/2023 TI me: 9:30:42 AM Account Trans. date Trans. type Doc. num. Vendor/Customer Journal description Debit amount Credit amount 500-030-63- -5403 COVID 19 - MICROENTRPRS - - WEBSITE DESIGN & HOSTING April, 2023 5/15/2023 AJE 144948 500-030-63- -5500 COVID 19 - MICROENTRPRS - - TRAVEL April, 2023 4/30/2023 Voucher 206639 FRANK J MARTINEZ M 500-030-63- -5910 COVID 19 - MICROENTRPRS - - INSURANCE April, 2023 5/12/2023 AJE 144935 500-030-63- -5912 COVID 19 - MICROENTRPRS - - LIABILITY INSURANCE April, 2023 5/12/2023 AJE 144932 500-030-64--5311 COVID 19 - HOUSING - - SALARIES,WAGES EXPENSE April, 2023 4/30/2023 Payroll 33634 500-030-64--5351 COVID 19 - HOUSING - - FICA,OIC EXP April, 2023 4/30/2023 Payroll 33634 500-030-64--5352 COVID 19 - HOUSING - - L AND I,OIC SHARE Period Total ---> $1,881.36-- 1,881.36-rCummulative CummulativeTotal ---> $1,881.36 $0.00 Exp Case Worthy user/maint Supp .$172.21 Fees April 2023 Period Total ---> $172.21 Cummulative Total ---> $172.21 $0.00 4/23 MILEAGE F MARITNEZ $136.24 Period Total ---> $136.24 -� Cummulative Total ---> $136.24 $0.00 4/23 Mgmt Liab Ins - Mid Valley Ins $57.32 Period Total ---> $57.32 .. Cummulative Total ---> $57.32 $0.00 Exp 4/23 Liab Insuarnace Liberty $1.52 Mutual Period Total ---> $1.52 Cummulative Total ---> $1.52 $0.00 Payroll wage expense for period $1,989.15 ending 4/30/2023 Period Total ---> $1,989.15 .. Cummulative Total ---> $1,989.15 $0.00 Payroll FICA expense for period $148.47 ending 4/30/2023 Period Total ---> $148.47- Cummulative Total ---> $148.47 $0.00 OIC OF WASHINGTON For User: Eliza Baysinger Transaction listing by account Fund: CDBG-CV1 10/1/20-06/30/23 General Ledger System From 4/2023 through 4/2023 Page: Page 4 of 5 Date: 5/26/2023 TI me: 9:30:42 AM Account Trans. date Trans. type Doc. num. Vendor/Customer Journal description Debit amount Credit amount April, 2023 4/30/2023 Payroll 33634 500-030-64--5353 COVID 19 - HOUSING - - STATE UCI(ES),OIC EXP April, 2023 4/30/2023 Payroll 33634 500-030-64--5355 COVID 19 - HOUSING - - PAID FAMILY MEDICAL LEAVE April, 2023 4/30/2023 Payroll 33634 500-030-64--5360 COVID 19 - HOUSING - - DISABILITY OIC EXPENSE April, 2023 4/30/2023 Payroll 33634 4/30/2023 Payroll 33634 500-030-64--5361 COVID 19 - HOUSING - - MEDICAL INSURANCE,OIC EXP April, 2023 4/30/2023 Payroll 33634 4/30/2023 Payroll 33634 500-030-64--5362 COVID 19 - HOUSING - - LIFE INSURANCE,OIC EXP April, 2023 4/30/2023 Payroll 33634 500-030-64--5363 COVID 19 - HOUSING - - PENSION,OIC EXP Payroll WC expense for period $11.42 ending 4/30/2023 Period Total ---> $11.42- Cummulative Total ---> $11.42 $0.00 Payroll UI expense for period ending $21.09 4/30/2023 Period Total ---> $21.09 Cummulative Total ---> $21.09 $0.00 Payroll cost allocation (PFML) for $18.03 period ending 4/30/2023 Period Total ---> $18.03 -► Cummulative Total ---> $18.03 $0.00 Payroll cost allocation (LNG DISAB.) $23.55 for period ending 4/30/2023 Payroll cost allocation (SHT DISAB.) $5.62 for period ending 4/30/2023 Period Total ---> $29.17 * Cummulative Total ---> $29.17 $0.00 Payroll cost allocation (EAP SERVIC) $1.28 for period ending 4/30/2023 Payroll cost allocation (MED INS) for $255.61 period ending 4/30/2023 Period Total ---> $256.89 Cummulative Total ---> $256.89 $0.00 Payroll cost allocation (LIFE) for $11.57 period ending 4/30/2023 Period Total ---> $11.57 Cummulative Total ---> $11.57 $0.00 OIC OF WASHINGTON For User: Eliza Baysinger Transaction listing by account Fund: CDBG-CV1 10/1/20-06/30123 General Ledger System From 4/2023 through 4/2023 Page: Page 5 of 5 Date: 5/26/2023 Time: 9:30:42 AM Account Trans. date Trans. type Doc. num. Vendor/Customer Journal description Debit amount Credit amount April, 2023 4/30/2023 Payroll 33634 500-030-64--5364 COVID 19 - HOUSING - -ACCRUED PTO EXP April, 2023 4/30/2023 Payroll 33634 4/30/2023 Payroll 33634 500-030-64- -5500 COVID 19 - HOUSING - - TRAVEL April, 2023 4/20/2023 Voucher 206315 CANDIDA JAEGER M 500-030-64- -5910 COVID 19 - HOUSING - - INSURANCE April, 2023 5/12/2023 AJE 144935 (Funds included: 500-CDBG-CV1) Payroll cost allocation (PENS.) for $157.78 period ending 4/30/2023 Period Total ---> $157.78 Cummulative Total ---> $157.78 $0.00 Payroll cost allocation (PTO ALLOC) $78.63 for period ending 4/30/2023 Program expense for vacation $169.35 accrued 4/30/2023 Period Total ---> $247.98 Cummulative Total ---> $247.98 $0.00 4/3-4/4/23 C JAEGER $46.02 Period Total ---> $46.02 Cummulative Total ---> $46.02 $0.00 4/23 Mgmt Liab Ins - Mid Valley Ins $4.58 Period Total ---> $4.58 Cummulative Total ---> $4.58 ~'°' $0.00 Grand Total ---> $33,697.30 OIC OF WASHINGTON For User: Eliza Baysinger Transaction listing by account Fund: CDBG-CV110/1/20-06/30/23 General Ledger System From 1/2023 through 3/2023 Page: Page 1 of 1 Date: 5/26/2023 Tlme: 2:27:33 PM Account Trans. date Trans. type Doc. num. Vendor/Customer Journal description Debit amount Credit amount 500-009-02- -5312 INDIRECT ADMIN - ADMIN. POOL - BASE - - SALARY ADM. ALLOCATION March, 2023 5/11/2023 AJE 144885 3/23 Admin Pool Salary & Benefits $5,901.96 Alloc Period Total ---> $5,901.96 Cummulative Total ---> $5,901.96 500-009-02- -5354 INDIRECT ADMIN -ADMIN. POOL -BASE - - P/R TAX & BEN. ADM ALLOC. March, 2023 5/11/2023 AJE 144885 3/23 Admin Pool Salary & Benefits $2,268.55 Alloc Period Total ---> $2,268.55 Cummulative Total ---> $2,268.55 (Funds included: 500-CDBG-CV1) Grand Total ---> $8,170.51 $0.00 Previous Month Expense txtperiod year Fundl Deptl Prog SubF Objectl objectname Transactior Transactiol Documents txtVenCustName Description Amount February 2023 500 030 62 5602 DEPRECIATION EXP EQ 5/11/2023 AJE 144872 2/23 Server Depr Expense $1.42 5602 Total $1.42 March 2023 500 030 62 5700 CONSUMABLES 3/31/2023 Voucher 205427 AMAZON CAPITAL SER 1 L7X-6KVR-9H41 AMAZON $320.48 March 2023 500 030 62 5700 CONSUMABLES 3/31/2023 Voucher 206232 ODP BUSINESS SOLUT 302568614001/PO 866000 ODP ($6.49) March 2023 500 030 62 5700 CONSUMABLES 3/31/2023 Voucher 206232 ODP BUSINESS SOLUT 304937941001/PO 866000 ODP ($10.82) March 2023 500 030 62 5700 CONSUMABLES 3/31/2023 Voucher 206232 ODP BUSINESS SOLUT 303204259001/PO 866000 ODP $17.31 March 2023 500 030 62 5700 CONSUMABLES 3/31/2023 Voucher 206232 ODP BUSINESS SOLUT 303204261001/PO 866000 ODP $10.79 March 2023 500 030 62 5700 CONSUMABLES 3/31/2023 Voucher 206232 ODP BUSINESS SOLUT 303204260001/PO 866000 ODP $24.15 5700 Total $355.42 January 2023 500 030 62 5960 COMMUNICATION 5/9/2023 AJE 144833 01/23 Server Costs '$7.25 January 2023 500 030 62 5960 COMMUNICATION 5/9/2023 AJE 144842 1/23 815 Fruitvale Phone Costs $5.50 January 2023 500 030 62 5960 COMMUNICATION 5/10/2023 AJE 144850 01/23 MOSES LAKE PHONE COSTS $16.43 5960 Total $29.18— 29.18—January January 2023 500 030 62 5970 POSTAGE 5/2/2023 AJE 144803 1/23 Postage Costs $0.70 February 2023 500 030 62 5970 POSTAGE 5/22/2023 AJE 144986 02/23 Postage Costs $0.69 5970 Total $1.39 -. February 2023 500 030 62 50 5601 DEPRECIATION EXP BLI 5/2/2023 AJE 144792 2/23 ML - Depreciation expe $3.90 March 2023 500 030 62 50 5601 DEPRECIATION EXP BLI 5/2/2023 AJE 144796 3/23 ML - Depreciation Expe $4.32 February 2023 500 030 62 50 5601 DEPRECIATION EXP BLI 5/11/2023 AJE 144859 2/23 815 Fruitvale Depr Expense $1.45 5601 Total $9.67 January 2023 500 030 62 50 5602 DEPRECIATION EXP EQ 5/24/2023 AJE 144999 01/23 815 Fruitvale Space Costs $0.01 5602 Total $0.01 January 2023 500 030 62 50 5611 SPACE 5/24/2023 AJE 144999 01/23 815 Fruitvale Space Costs $49.64 5611 Total $49.64 - January 2023 500 030 62 50 5630 UTILITIES 5/24/2023 AJE 144999 01/23 815 Fruitvale Space Costs $8.86 5630 Total $8.86 January 2023 500 030 62 50 5640 BUILD. REPAIR/MAINT. 5/24/2023 AJE 144999 01/23 815 Fruitvale Space Costs $9.32 5640 Total $9.32 Previous Month Expense txtperiod year Fundl Deptl Prog Subf Objectl objectname Transactior Transactioi Documentf txtVenCustName Description Amount January 2023 500 030 62 50 5910 INSURANCE 5/24/2023 AJE 144999 01/23 815 Fruitvale Space Costs $0.08 5910 Total $0.08 .. January 2023 500 030 62 50 5912 LIABILITY INSURANCE 5/24/2023 AJE 144999 01/23 815 Fruitvale Space Costs $3.25 5912 Total $3.25 March 2023 500 030 63 5700 CONSUMABLES 3/31/2023 Voucher 206232 ODP BUSINESS SOLUT 303710635001/PO 865991 ODP $8.26 March 2023 500 030 63 5700 CONSUMABLES 3/31/2023 Voucher 206232 ODP BUSINESS SOLUT 303711558001/PO 865991 ODP $94.90 March 2023 500 030 63 5700 CONSUMABLES 3/31/2023 Voucher 206232 ODP BUSINESS SOLUT 303711556001/PO 865991 ODP $169.71 5700 Total $272.87 — March 2023 500 030 64 5411 CREDIT REPORTS 3/31/2023 Voucher 206114 ACRANET-CBS BRANC 3/23 2303112 ACRANER $86.70 5411 Total $86.70 .~ January 2023 500 030 64 5712 REPRODUCTION SUPPL 4/28/2023 AJE 144777 1/23 Copy Costs $11.39 5712 Total $11.39 ..� Grand Total $839.20 COV113=19 Utility/ Rent/ Mortgage Payments Project Detail Report CDBG Contract #XX-XXXXX-XXX Grant CountyAs of 4/30/2023 On-going COVID Assistance Details ((Note: -No direct payments to clients) Client Details Assistance Details COVID JElgibility Certification Intake Information Purchas Name or I' Assistan Amount= Address Date of Address Duplicati Within Househo LM1 e " ng e Order/ Initials ce: of - to Mail Assistan Within on of , Target Id Eligible . Econo Supervis Payment or Utility/Re $ Assistan Assistan Assistan ce Date Target Benefits: Service Income: <80%. me Intake Intake or to 3rd Identific Client Client ntl Monthly ce Given ce Paid ce Applicati Assistan Service Were Area? Y <50% MHI impact: Date/tim Staff (if Party # ation # Address Zip Code Mortgag Payment (6 to: Payment on _ ce Paid Area? Y other or N or Y or N due to. a Name applicab VV Ul K6 III a restaur Ann 123 ABC ��91 ant and his hours Mary 20- Smith or Rock 98502 Rent Apartme Main St. 6/2/2020 Y N Y o <50% Y were 5/29/20 Anne Smith. X0000( A.S. or Lane, nts Olympia, reduced 10:30am Shine y 5/30/20 Client #1 Olympia 98502 due to COVID, NONE COVID-19 Micro Assistance Payments Project Detail Report CDBG Contract #XX-XXOCX-XXX Grant County As of 4/30/2023 -0n-going CaVID Assistance Details (Note: No direct payments o, clients) Client Details Assistance Details ,. _ COVID Eli rb�l�t .Certification J Y Intake:lnformation urc as (nient iFype ot -rotai s. Address bate-ot mentWithin o a pproVi r e Order/ Name r a e o A " ` i n ss sta $ Amoun ` t. Assistan to Mail _ Assistan Date ., Address Du Licata _ p Tar et 9 Househo LMI _ `e - Intake Intake n 9 Payment Y Initials Client Client ce. Monthly v -_ of ce Paid Assistan . ce Assistan Within on of Service Id Eligible? Econo Dateltim Staff Supervis to 3rd or Address Zip Code Utility/Re Payment Assistan to: _ ce _ Applicati 'ce Paid : Tar9et Benefits: Area? ` Y Income. <8.0% mic e- Name or vvorKS Ann 123 1111' 161212020 a restaur 20- Smith or Rock ABC Main St ant and 5129/20 Anne Mary )0000( A.S. or Lane, 98502 Rent ####�f## ##� Apartme . Olympia, ##�# Y N Y: o <50% Y his hours 10;30am Shirleymith y Client #1 Olympia nts 98502 were 5/30/20 reduced NONE