Cities Index.
Exp Summary 06.30.25 - Water Funds.pdf

Corona City Council
August 6, 2025

Document
Exp Summary 06.30.25 - Water Funds.pdf
Meeting
August 6, 2025
Body
Corona City Council
Original file
50 KB
Text extracted from the city's file for reading and search. Open the original on pub-corona.escribemeetings.com. That file is the official record.

GL
06/30/2025
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2025
OB 12
Ledger:

Level:

Month to
453 2012 WATER REV REF PROJECT
00 NOT APPLICABLE

SERVICES-SUPPLIES
TOTAL FOR SERVICES-SUPPLIES 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL FOR NOT APPLICABLE 0.00 0.00 0.00 0.00 0.00 0.00
FUN 453 0.00 0.00 0.00 0.00 0.00 0.00
JULIEK Page: 1 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/21/2025
Current Time: 11:16:01
User:

Report:

GL
06/30/2025
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2025
OB 12
Ledger:

Level:

Month to
507 WATER CAPACITY
00 NOT APPLICABLE

SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 2,332,003.45 0.00 0.00 0.00 2,332,003.45 0.00 TOTAL FOR SERVICES-SUPPLIES 2,332,003.45 0.00 0.00 0.00 2,332,003.45 0.00 TOTAL FOR NOT APPLICABLE 2,332,003.45 0.00 0.00 0.00 2,332,003.45 0.00 13 DEBT SERVICE

SERVICES-SUPPLIES
42900 PROF. & CONT. SVCS 1,004.00 0.00 1,002.45 0.00 1.55 99.84 TOTAL FOR SERVICES-SUPPLIES 1,004.00 0.00 1,002.45 0.00 1.55 99.84 TOTAL FOR DEBT SERVICE 1,004.00 0.00 1,002.45 0.00 1.55 99.84 50 WATER UTILITY SERVICES

SERVICES-SUPPLIES
44100 INTEREST EXPENSE 696,737.74 0.00 231,258.59 0.00 465,479.15 33.19 44610 ADMINISTRATIVE SERVICES CHARGE 27,156.00 0.00 20,367.00 0.00 6,789.00 75.00 TOTAL FOR SERVICES-SUPPLIES 723,893.74 0.00 251,625.59 0.00 472,268.15 34.76 TOTAL FOR WATER UTILITY SERVICES 723,893.74 0.00 251,625.59 0.00 472,268.15 34.76 FUN 507 3,056,901.19 0.00 252,628.04 0.00 2,804,273.15 8.26 JULIEK Page: 2 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/21/2025
Current Time: 11:16:01
User:

Report:

GL
06/30/2025
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2025
OB 12
Ledger:

Level:

Month to
567 RECLAIMED WATER SYSTEM
00 NOT APPLICABLE

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 0.00 1,001.52 11,825.23 0.00 (11,825.23) 0.00 41141 SP COMP-BILINGUAL 0.00 0.00 4.10 0.00 (4.10) 0.00 41910 PERS-NORMAL 0.00 120.68 1,425.42 0.00 (1,425.42) 0.00 41920 MEDICARE 0.00 29.63 349.91 0.00 (349.91) 0.00
41931 WORKERS COMP 0.00 20.03 236.61 0.00 (236.61) 0.00 41932 STATE UNEMPLOYMENT INSURANCE 0.00 0.91 10.79 0.00 (10.79) 0.00 41951 HEALTH ALLOWANCE CREDIT 0.00 2.83 13.59 0.00 (13.59) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 1,175.60 13,865.65 0.00 (13,865.65) 0.00

SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 3,788,776.58 0.00 0.00 0.00 3,788,776.58 0.00 42033 CONSTRUCTION MATERIALS 0.00 0.00 51,242.86 212,156.56 (263,399.42) 0.00 42220 PROMOTIONAL/PUBLIC OUTREACH 0.00 0.00 7.66 0.00 (7.66) 0.00 42700 OTHER EQUIPMENT RENTAL 0.00 4.20 29.90 0.00 (29.90) 0.00 42813 MTCE & REPAIR - EQUIP & FAC 0.00 0.00 58,550.00 0.00 (58,550.00) 0.00 42900 PROF. & CONT. SVCS 397,464.35 49,108.86 1,017,934.98 248,066.72 (868,537.35) 318.51 43300 CONSTRUCTION CONTRACTS 0.00 0.00 48,200.00 114,153.00 (162,353.00) 0.00 TOTAL FOR SERVICES-SUPPLIES 4,186,240.93 49,113.06 1,175,965.40 574,376.28 2,435,899.25 41.81

SERVICES-SUPPLIES
TOTAL FOR SERVICES-SUPPLIES 0.00 0.00 0.00 0.00 0.00 0.00

CAPITAL OUTLAY
45100 LICENSED VEHICLES 33,914.59 0.00 326.25 33,914.59 (326.25) 100.96 TOTAL FOR CAPITAL OUTLAY 33,914.59 0.00 326.25 33,914.59 (326.25) 100.96 TOTAL FOR NOT APPLICABLE 4,220,155.52 50,288.66 1,190,157.30 608,290.87 2,421,707.35 42.61 13 DEBT SERVICE

SERVICES-SUPPLIES
42900 PROF. & CONT. SVCS 357.00 0.00 356.86 0.00 0.14 99.96 44001 DS PRINCIPAL 2021 POBS 80,058.00 0.00 80,057.80 0.00 0.20 100.00 44101 DS INTEREST 2021 POBS 20,407.00 0.00 17,052.31 0.00 3,354.69 83.56 TOTAL FOR SERVICES-SUPPLIES 100,822.00 0.00 97,466.97 0.00 3,355.03 96.67 TOTAL FOR DEBT SERVICE 100,822.00 0.00 97,466.97 0.00 3,355.03 96.67 39 PUBLIC WORKS

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 34,450.57 3,166.02 24,835.32 0.00 9,615.25 72.08 41140 FINAL LEAVE 0.00 0.00 2,729.09 0.00 (2,729.09) 0.00 41141 SP COMP-BILINGUAL 270.90 0.00 114.96 0.00 155.94 42.43 JULIEK Page: 3 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/21/2025
Current Time: 11:16:01
User:

Report:

GL
06/30/2025
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2025
OB 12
Ledger:

Level:

Month to
41500 DEFERRED COMPENSATION MATCH 180.67 0.00 0.00 0.00 180.67 0.00 41520 TIERED EMP DEF COMPENSATION 101.97 85.50 180.00 0.00 (78.03) 176.52 41530 TIERED RHS BENEFIT 55.67 42.50 94.00 0.00 (38.33) 168.85 41660 TUITION REIMBURSEMENT 0.00 0.00 197.40 0.00 (197.40) 0.00 41910 PERS-NORMAL 2,882.95 381.51 3,006.59 0.00 (123.64) 104.28 41912 PERS-UNFUNDED 569.00 0.00 569.00 0.00 0.00 100.00 41920 MEDICARE 1,029.22 94.52 805.39 0.00 223.83 78.25
41929 SHORT TERM DISABILITY 110.25 25.50 239.98 0.00 (129.73) 217.66 41930 LONG TERM DISABILITY 234.26 42.32 407.64 0.00 (173.38) 174.01 41931 WORKERS COMP 679.74 264.70 688.36 0.00 (8.62) 101.26 41932 STATE UNEMPLOYMENT INSURANCE 31.14 2.85 24.80 0.00 6.34 79.64 41940 HEALTH INSURANCE 9,169.91 1,720.11 15,858.66 0.00 (6,688.75) 172.94 41945 OPT OUT HEALTH INSURANCE 0.00 0.00 46.29 0.00 (46.29) 0.00 41946 LIFE INSURANCE 285.95 51.63 497.45 0.00 (211.50) 173.96 41951 HEALTH ALLOWANCE CREDIT 0.00 34.70 297.64 0.00 (297.64) 0.00 41996 VACANCY FACTOR (3,038.00) 0.00 0.00 0.00 (3,038.00) 0.00 TOTAL FOR SALARIES-BENEFITS 47,014.20 5,911.86 50,592.57 0.00 (3,578.37) 107.61

SERVICES-SUPPLIES
42101 SAFETY SHOES - MOU ITEM 57.46 0.00 0.00 0.00 57.46 0.00 TOTAL FOR SERVICES-SUPPLIES 57.46 0.00 0.00 0.00 57.46 0.00 TOTAL FOR PUBLIC WORKS 47,071.66 5,911.86 50,592.57 0.00 (3,520.91) 107.47 53 RECLAIMED WATER

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 81,243.55 0.00 34,690.57 0.00 46,552.98 42.69 41102 SHIFT DIFFERENTIAL 0.00 0.00 175.91 0.00 (175.91) 0.00 41103 OUT OF CLASS PAY 0.00 0.00 33.58 0.00 (33.58) 0.00 41140 FINAL LEAVE 0.00 0.00 516.79 0.00 (516.79) 0.00
41141 SP COMP-BILINGUAL 450.35 0.00 264.98 0.00 185.37 58.83 41147 SP COMP-GRADE 4 CERT PAY 420.00 0.00 171.96 0.00 248.04 40.94 41148 SP COMP-GRADE 5 CERT PAY 1,266.15 0.00 645.30 0.00 620.85 50.96 41200 TEMPORARY EMPLOYEES 1,300.98 0.00 435.63 0.00 865.35 33.48 41300 OVERTIME 8,892.00 0.00 4,023.92 0.00 4,868.08 45.25 41320 COMP TIME 0.00 0.00 192.93 0.00 (192.93) 0.00
41400 SPECIAL DUTY PAY 958.00 0.00 584.07 0.00 373.93 60.96 41410 AUTO ALLOWANCE 57.60 0.00 28.80 0.00 28.80 50.00
41500 DEFERRED COMPENSATION MATCH 460.74 0.00 17.78 0.00 442.96 3.85 41510 PST DEFERRED COMPENSATION 9.69 0.00 5.67 0.00 4.02 58.51 41520 TIERED EMP DEF COMPENSATION 324.15 0.00 87.61 0.00 236.54 27.02 41530 TIERED RHS BENEFIT 197.04 0.00 49.22 0.00 147.82 24.97 JULIEK Page: 4 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/21/2025
Current Time: 11:16:01
User:

Report:

GL
06/30/2025
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2025
OB 12
Ledger:

Level:

Month to
41600 LONGEVITY 451.59 0.00 227.48 0.00 224.11 50.37
41660 TUITION REIMBURSEMENT 0.00 0.00 91.26 0.00 (91.26) 0.00 41700 ANNUAL LEAVE BUYBACK 1,025.22 0.00 1,106.32 0.00 (81.10) 107.91 41910 PERS-NORMAL 9,825.67 0.00 4,442.29 0.00 5,383.38 45.21 41912 PERS-UNFUNDED 1,365.00 0.00 1,365.00 0.00 0.00 100.00 41920 MEDICARE 2,892.64 0.00 1,283.17 0.00 1,609.47 44.35 41929 SHORT TERM DISABILITY 259.93 0.00 138.91 0.00 121.02 53.44 41930 LONG TERM DISABILITY 552.26 0.00 228.77 0.00 323.49 41.42 41931 WORKERS COMP 2,107.90 380.37 1,111.96 0.00 995.94 52.75 41932 STATE UNEMPLOYMENT INSURANCE 87.96 0.00 39.51 0.00 48.45 44.91 41940 HEALTH INSURANCE 16,916.45 0.00 5,643.93 0.00 11,272.52 33.36 41941 RETIREES HEALTH INSURANCE/OPEB 14,017.00 3,557.89 14,231.99 0.00 (214.99) 101.53 41945 OPT OUT HEALTH INSURANCE 1,359.60 0.00 679.71 0.00 679.89 49.99 41946 LIFE INSURANCE 672.89 0.00 279.18 0.00 393.71 41.48 41951 HEALTH ALLOWANCE CREDIT 0.00 0.00 53.04 0.00 (53.04) 0.00 41996 VACANCY FACTOR (19,281.00) 0.00 0.00 0.00 (19,281.00) 0.00 41997 BUDGETARY/PAYROLL (179.41) 0.00 0.00 0.00 (179.41) 0.00 TOTAL FOR SALARIES-BENEFITS 127,653.95 3,938.26 72,847.24 0.00 54,806.71 57.06

SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 3,630.00 0.39 148.44 1,500.00 1,981.56 45.41 42033 CONSTRUCTION MATERIALS 108,447.40 1,605.71 95,001.77 0.00 13,445.63 87.60 42034 SAFETY MATERIALS/CONSTRUCTION 15.00 0.00 0.00 0.00 15.00 0.00 42055 COMPUTER EQUIPMENT & 2,546.32 2,737.39 5,243.86 0.00 (2,697.54) 205.93 42100 UNIFORM EXPENSE 6.32 26.64 95.89 0.00 (89.57) 1,517.24 42101 SAFETY SHOES - MOU ITEM 366.67 0.00 0.00 0.00 366.67 0.00 42200 ADVERTISING EXPENSE 486.00 0.00 0.00 0.00 486.00 0.00 42220 PROMOTIONAL/PUBLIC OUTREACH 0.00 0.00 529.60 0.00 (529.60) 0.00 42300 WIRELESS COMMUNICATION 770.40 46.36 418.91 0.00 351.49 54.37 42320 POSTAGE & SHIPPING 670.00 0.00 234.19 0.00 435.81 34.95 42340 OFFICE SUPPLIES 256.20 30.56 190.59 0.00 65.61 74.39 42350 PROGRAM EXPENDITURES 446.38 45.86 2,444.82 0.00 (1,998.44) 547.69 42360 CLEANING/JANITORIAL SUPPLIES 0.00 0.00 0.93 0.00 (0.93) 0.00 42365 RECYCLED CONTENT PRODUCTS 26.00 1.72 10.98 0.00 15.02 42.23 42410 ELECTRIC UTILITY 748,178.25 214.75 703,523.14 0.00 44,655.11 94.03 42500 RENTS & LEASES 17,679.00 0.00 13,259.25 0.00 4,419.75 75.00 42600 MOTOR POOL RENTAL - OPS & MTCE 4,594.00 0.00 2,297.00 0.00 2,297.00 50.00 42605 RETAINED VEHICLE EXPENSE 110.00 0.00 55.00 0.00 55.00 50.00 42660 MOTOR POOL RENTAL- 4,245.08 0.00 1,849.00 0.00 2,396.08 43.55 42710 MILEAGE/VEHICLE EXP REIMB 50.00 0.00 0.48 0.00 49.52 0.96 42813 MTCE & REPAIR - EQUIP & FAC 102,000.00 0.00 24,922.14 17,307.72 59,770.14 41.40 JULIEK Page: 5 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/21/2025
Current Time: 11:16:01
User:

Report:

GL
06/30/2025
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2025
OB 12
Ledger:

Level:

Month to
42815 SCADA MAINTENANCE 105,002.00 8,526.92 44,817.24 14,252.68 45,932.08 56.25 42816 MOWING/LANDSCAPE CONTRACTS 10,094.00 0.00 0.00 3,000.00 7,094.00 29.72 42900 PROF. & CONT. SVCS 475,983.40 39,574.48 443,691.80 61,592.36 (29,300.76) 106.15 43000 INSURANCE & SURETY BONDS 8,633.90 12,249.12 18,326.83 0.00 (9,692.93) 212.26 43100 MEMBERSHIP & DUES 8,687.70 0.00 8,937.50 0.00 (249.80) 102.87 43200 CONFERENCE, TRAINING & TRAVEL 316.30 41.02 211.91 0.00 104.39 66.99 43715 REGULATORY PERMIT & USE FEES 100.00 0.00 100.00 0.00 0.00 100.00 43716 JOB REQ CERTIFICATES & LICENSE 5.20 0.00 0.00 0.00 5.20 0.00 43722 PREVENTION & MAINTENANCE 155,696.69 975.00 29,289.34 24,280.99 102,126.36 34.40 44100 INTEREST EXPENSE 288,059.53 0.00 102,332.35 0.00 185,727.18 35.52 44200 BAD DEBTS EXPENSE 908.00 0.00 0.00 0.00 908.00 0.00 44610 ADMINISTRATIVE SERVICES CHARGE 129,651.00 0.00 97,238.25 0.00 32,412.75 75.00 44613 INTERNAL SVC CHRG-WAREHOUSE 3,911.00 0.00 1,955.50 0.00 1,955.50 50.00 44614 INTERNAL SVC CHRG-INFO TECH 45,785.00 0.00 34,338.75 0.00 11,446.25 75.00 TOTAL FOR SERVICES-SUPPLIES 2,227,356.74 66,075.92 1,631,465.46 121,933.75 473,957.53 78.72

CAPITAL OUTLAY
45200 MACHINERY, EQUIPMENT, & FIXTUR 100,000.00 0.00 0.00 0.00 100,000.00 0.00 TOTAL FOR CAPITAL OUTLAY 100,000.00 0.00 0.00 0.00 100,000.00 0.00 TOTAL FOR RECLAIMED WATER 2,455,010.69 70,014.18 1,704,312.70 121,933.75 628,764.24 74.38 FUN 567 6,823,059.87 126,214.70 3,042,529.54 730,224.62 3,050,305.71 55.29 JULIEK Page: 6 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/21/2025
Current Time: 11:16:01
User:

Report:

GL
06/30/2025
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2025
OB 12
Ledger:

Level:

Month to
570 WATER UTILITY
00 NOT APPLICABLE

SALARIES-BENEFITS
40001 CIP - PAYROLL EXPENSES 0.00 0.00 1,896.00 0.00 (1,896.00) 0.00 41100 PERMANENT EMPLOYEES 0.00 7,067.26 83,575.64 0.00 (83,575.64) 0.00 41141 SP COMP-BILINGUAL 0.00 0.00 417.13 0.00 (417.13) 0.00 41147 SP COMP-GRADE 4 CERT PAY 0.00 0.00 37.34 0.00 (37.34) 0.00 41148 SP COMP-GRADE 5 CERT PAY 0.00 0.00 301.60 0.00 (301.60) 0.00 41300 OVERTIME 0.00 0.00 12,731.93 0.00 (12,731.93) 0.00 41320 COMP TIME 0.00 0.00 1,063.61 0.00 (1,063.61) 0.00 41500 DEFERRED COMPENSATION MATCH 0.00 0.00 42.26 0.00 (42.26) 0.00 41520 TIERED EMP DEF COMPENSATION 0.00 0.00 24.38 0.00 (24.38) 0.00 41530 TIERED RHS BENEFIT 0.00 0.00 8.12 0.00 (8.12) 0.00 41600 LONGEVITY 0.00 0.00 56.63 0.00 (56.63) 0.00
41910 PERS-NORMAL 0.00 851.61 10,174.20 0.00 (10,174.20) 0.00 41920 MEDICARE 0.00 208.96 2,883.40 0.00 (2,883.40) 0.00 41929 SHORT TERM DISABILITY 0.00 0.00 41.23 0.00 (41.23) 0.00 41930 LONG TERM DISABILITY 0.00 0.00 68.38 0.00 (68.38) 0.00 41931 WORKERS COMP 0.00 141.33 1,689.09 0.00 (1,689.09) 0.00 41932 STATE UNEMPLOYMENT INSURANCE 0.00 6.45 89.11 0.00 (89.11) 0.00 41940 HEALTH INSURANCE 0.00 0.00 1,160.63 0.00 (1,160.63) 0.00 41945 OPT OUT HEALTH INSURANCE 0.00 0.00 551.03 0.00 (551.03) 0.00 41946 LIFE INSURANCE 0.00 0.00 83.47 0.00 (83.47) 0.00
41951 HEALTH ALLOWANCE CREDIT 0.00 2.86 9.66 0.00 (9.66) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 8,278.47 116,904.84 0.00 (116,904.84) 0.00

SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 45,039,880.59 0.00 0.00 0.00 45,039,880.59 0.00 40003 CIP-MATERIALS & SUPPLIES 0.00 0.00 1,964.31 0.00 (1,964.31) 0.00 42020 MINOR EQUIPMENT & FURNITURE 0.00 131.55 2,936.80 0.00 (2,936.80) 0.00 42033 CONSTRUCTION MATERIALS 39,771.62 514,174.87 2,652,168.27 14,023,587.70 (16,635,984.35) 41,928.78 42034 SAFETY MATERIALS/CONSTRUCTION 0.00 0.00 43.72 0.00 (43.72) 0.00 42055 COMPUTER EQUIPMENT & 0.00 0.00 5,558.97 0.00 (5,558.97) 0.00 42200 ADVERTISING EXPENSE 0.00 0.00 1,583.17 0.00 (1,583.17) 0.00 42300 WIRELESS COMMUNICATION 0.00 0.00 60.06 0.00 (60.06) 0.00 42320 POSTAGE & SHIPPING 0.00 0.00 21.45 0.00 (21.45) 0.00 42350 PROGRAM EXPENDITURES 0.00 0.00 17.97 0.00 (17.97) 0.00 42700 OTHER EQUIPMENT RENTAL 0.00 650.15 17,750.28 0.00 (17,750.28) 0.00 42813 MTCE & REPAIR - EQUIP & FAC 0.00 1,472.50 91,111.84 0.00 (91,111.84) 0.00 42815 SCADA MAINTENANCE 6,683.00 71,689.01 97,957.81 65,135.04 (156,409.85) 2,440.41 42900 PROF. & CONT. SVCS 1,605,691.99 288,731.16 2,154,928.46 3,421,645.55 (3,970,882.02) 347.30 43300 CONSTRUCTION CONTRACTS 2,145,071.68 244,713.23 4,246,749.15 4,568,530.78 (6,670,208.25) 410.95 JULIEK Page: 7 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/21/2025
Current Time: 11:16:01
User:

Report:

GL
06/30/2025
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2025
OB 12
Ledger:

Level:

Month to
43301 CAPITAL IMPROVEMENTS 20,000.00 8,075.64 96,257.48 0.00 (76,257.48) 481.28 43715 REGULATORY PERMIT & USE FEES 0.00 0.00 11,122.79 0.00 (11,122.79) 0.00 43727 INSPECTION 29,816.86 0.00 10,867.50 18,949.36 0.00 100.00 TOTAL FOR SERVICES-SUPPLIES 48,886,915.74 1,129,638.11 9,391,100.03 22,097,848.43 17,397,967.28 64.41

SERVICES-SUPPLIES
40002 CIP-CONTRACTUAL (240,337.50) 0.00 731,961.63 0.00 (972,299.13) (304.55) TOTAL FOR SERVICES-SUPPLIES (240,337.50) 0.00 731,961.63 0.00 (972,299.13) (304.55)

CAPITAL OUTLAY
45100 LICENSED VEHICLES 231,743.52 0.00 30,015.00 231,743.52 (30,015.00) 112.95 45200 MACHINERY, EQUIPMENT, & FIXTUR 0.00 28,265.00 180,820.79 0.00 (180,820.79) 0.00 TOTAL FOR CAPITAL OUTLAY 231,743.52 28,265.00 210,835.79 231,743.52 (210,835.79) 190.97 TOTAL FOR NOT APPLICABLE 48,878,321.76 1,166,181.58 10,450,802.29 22,329,591.95 16,097,927.52 67.06 13 DEBT SERVICE

SERVICES-SUPPLIES
42900 PROF. & CONT. SVCS 1,353.00 0.00 1,352.13 0.00 0.87 99.93 44001 DS PRINCIPAL 2021 POBS 1,386,419.00 0.00 1,386,419.00 0.00 0.00 100.00 44101 DS INTEREST 2021 POBS 353,401.00 0.00 295,307.13 0.00 58,093.87 83.56 TOTAL FOR SERVICES-SUPPLIES 1,741,173.00 0.00 1,683,078.26 0.00 58,094.74 96.66 TOTAL FOR DEBT SERVICE 1,741,173.00 0.00 1,683,078.26 0.00 58,094.74 96.66 21 PLANNING & DEVELOPMENT

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 39,399.64 2,913.14 35,700.00 0.00 3,699.64 90.60 41141 SP COMP-BILINGUAL 704.00 54.16 700.21 0.00 3.79 99.46 41200 TEMPORARY EMPLOYEES 1,711.70 0.00 0.00 0.00 1,711.70 0.00 41500 DEFERRED COMPENSATION MATCH 259.40 10.00 215.00 0.00 44.40 82.88 41510 PST DEFERRED COMPENSATION 22.25 0.00 0.00 0.00 22.25 0.00 41520 TIERED EMP DEF COMPENSATION 126.48 60.00 120.00 0.00 6.48 94.87 41530 TIERED RHS BENEFIT 86.16 40.00 80.00 0.00 6.16 92.85 41600 LONGEVITY 140.00 10.76 118.36 0.00 21.64 84.54
41710 ANNUAL LEAVE OVER MAX 0.00 0.00 493.45 0.00 (493.45) 0.00 41910 PERS-NORMAL 4,738.83 358.86 4,400.47 0.00 338.36 92.85 41912 PERS-UNFUNDED 1,024.00 0.00 1,024.00 0.00 0.00 100.00 41920 MEDICARE 1,245.38 90.21 1,095.51 0.00 149.87 87.96 41929 SHORT TERM DISABILITY 126.08 11.96 146.43 0.00 (20.35) 116.14 41930 LONG TERM DISABILITY 267.91 19.80 242.83 0.00 25.08 90.63 41931 WORKERS COMP 1,127.84 310.98 973.01 0.00 154.83 86.27 41932 STATE UNEMPLOYMENT INSURANCE 38.35 2.70 32.93 0.00 5.42 85.86 41940 HEALTH INSURANCE 5,459.33 464.40 5,122.92 0.00 336.41 93.83 JULIEK Page: 8 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/21/2025
Current Time: 11:16:01
User:

Report:

GL
06/30/2025
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2025
OB 12
Ledger:

Level:

Month to
41946 LIFE INSURANCE 327.01 24.20 296.34 0.00 30.67 90.62 41951 HEALTH ALLOWANCE CREDIT 0.00 23.36 151.84 0.00 (151.84) 0.00 41996 VACANCY FACTOR (2,548.00) 0.00 0.00 0.00 (2,548.00) 0.00 TOTAL FOR SALARIES-BENEFITS 54,256.36 4,394.53 50,913.30 0.00 3,343.06 93.83

SERVICES-SUPPLIES
42101 SAFETY SHOES - MOU ITEM 50.50 0.00 0.00 0.00 50.50 0.00 TOTAL FOR SERVICES-SUPPLIES 50.50 0.00 0.00 0.00 50.50 0.00 TOTAL FOR PLANNING & DEVELOPMENT DEPT54,306.86 4,394.53 50,913.30 0.00 3,393.56 93.75 39 PUBLIC WORKS

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 406,855.37 15,091.64 223,057.28 0.00 183,798.09 54.82 41101 SPECIAL ASSIGNMENT PAY 0.00 0.00 12.15 0.00 (12.15) 0.00 41103 OUT OF CLASS PAY 0.00 0.00 3,774.24 0.00 (3,774.24) 0.00 41140 FINAL LEAVE 0.00 0.00 33,853.62 0.00 (33,853.62) 0.00 41141 SP COMP-BILINGUAL 3,181.77 37.09 1,880.50 0.00 1,301.27 59.10 41200 TEMPORARY EMPLOYEES 6,084.52 924.43 10,551.94 0.00 (4,467.42) 173.42 41300 OVERTIME 0.00 0.00 553.96 0.00 (553.96) 0.00
41400 SPECIAL DUTY PAY 0.00 0.00 1,012.82 0.00 (1,012.82) 0.00 41410 AUTO ALLOWANCE 864.00 66.46 1,001.69 0.00 (137.69) 115.93 41500 DEFERRED COMPENSATION MATCH 927.03 120.00 1,459.92 0.00 (532.89) 157.48 41510 PST DEFERRED COMPENSATION 79.09 12.02 137.11 0.00 (58.02) 173.35 41520 TIERED EMP DEF COMPENSATION 731.24 345.00 1,166.98 0.00 (435.74) 159.58 41530 TIERED RHS BENEFIT 309.27 300.25 989.98 0.00 (680.71) 320.10 41600 LONGEVITY 1,042.00 81.52 1,301.75 0.00 (259.75) 124.92 41660 TUITION REIMBURSEMENT 0.00 0.00 197.32 0.00 (197.32) 0.00 41700 ANNUAL LEAVE BUYBACK 2,247.11 0.00 4,508.63 0.00 (2,261.52) 200.64 41710 ANNUAL LEAVE OVER MAX 44.00 0.00 0.00 0.00 44.00 0.00 41910 PERS-NORMAL 48,574.21 1,832.88 27,291.42 0.00 21,282.79 56.18 41912 PERS-UNFUNDED 12,311.00 0.00 12,311.00 0.00 0.00 100.00 41920 MEDICARE 12,401.06 485.67 8,299.56 0.00 4,101.50 66.92 41929 SHORT TERM DISABILITY 1,301.93 88.20 1,532.96 0.00 (231.03) 117.74 41930 LONG TERM DISABILITY 2,766.61 146.40 2,542.97 0.00 223.64 91.91 41931 WORKERS COMP 11,671.52 2,422.39 6,821.03 0.00 4,850.49 58.44 41932 STATE UNEMPLOYMENT INSURANCE 378.21 14.94 256.85 0.00 121.36 67.91 41940 HEALTH INSURANCE 43,758.49 2,534.75 39,274.70 0.00 4,483.79 89.75 41945 OPT OUT HEALTH INSURANCE 5,862.00 210.00 4,176.71 0.00 1,685.29 71.25 41946 LIFE INSURANCE 3,376.89 178.66 3,104.10 0.00 272.79 91.92 41951 HEALTH ALLOWANCE CREDIT 0.00 126.36 932.35 0.00 (932.35) 0.00 41996 VACANCY FACTOR (155,179.00) 0.00 0.00 0.00 (155,179.00) 0.00 JULIEK Page: 9 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/21/2025
Current Time: 11:16:01
User:

Report:

GL
06/30/2025
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2025
OB 12
Ledger:

Level:

Month to
TOTAL FOR SALARIES-BENEFITS 409,588.32 25,018.66 392,003.54 0.00 17,584.78 95.70

SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 90.00 0.00 0.00 0.00 90.00 0.00 42033 CONSTRUCTION MATERIALS 200.00 0.00 0.00 0.00 200.00 0.00 42034 SAFETY MATERIALS/CONSTRUCTION 365.00 0.00 0.00 0.00 365.00 0.00 42055 COMPUTER EQUIPMENT & 1,392.00 55.12 1,698.45 0.00 (306.45) 122.01 42101 SAFETY SHOES - MOU ITEM 801.20 0.00 67.78 0.00 733.42 8.45 42300 WIRELESS COMMUNICATION 0.00 195.46 1,741.28 0.00 (1,741.28) 0.00 42320 POSTAGE & SHIPPING 100.00 0.00 0.00 0.00 100.00 0.00 42340 OFFICE SUPPLIES 200.00 0.00 0.00 0.00 200.00 0.00 42600 MOTOR POOL RENTAL - OPS & MTCE 209.00 0.00 104.50 0.00 104.50 50.00 42660 MOTOR POOL RENTAL- 1,039.00 0.00 519.50 0.00 519.50 50.00 43200 CONFERENCE, TRAINING & TRAVEL 9,805.00 0.00 2,116.61 0.00 7,688.39 21.58 TOTAL FOR SERVICES-SUPPLIES 14,201.20 250.58 6,248.12 0.00 7,953.08 43.99 TOTAL FOR PUBLIC WORKS 423,789.52 25,269.24 398,251.66 0.00 25,537.86 93.97 50 WATER UTILITY SERVICES

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 5,420,629.93 420,977.45 4,896,374.81 0.00 524,255.12 90.32 41101 SPECIAL ASSIGNMENT PAY 0.00 0.00 2,090.08 0.00 (2,090.08) 0.00 41102 SHIFT DIFFERENTIAL 0.00 2,743.69 34,615.08 0.00 (34,615.08) 0.00 41103 OUT OF CLASS PAY 0.00 0.00 1,745.96 0.00 (1,745.96) 0.00 41140 FINAL LEAVE 0.00 455.90 39,285.15 0.00 (39,285.15) 0.00 41141 SP COMP-BILINGUAL 26,766.59 2,704.96 31,463.99 0.00 (4,697.40) 117.54 41147 SP COMP-GRADE 4 CERT PAY 33,120.00 2,226.94 28,987.37 0.00 4,132.63 87.52 41148 SP COMP-GRADE 5 CERT PAY 99,993.36 9,198.95 101,153.29 0.00 (1,159.93) 101.16 41200 TEMPORARY EMPLOYEES 65,049.78 3,729.14 43,707.62 0.00 21,342.16 67.19 41300 OVERTIME 623,687.00 41,851.93 616,599.69 0.00 7,087.31 98.86 41320 COMP TIME 0.00 1,086.14 35,785.67 0.00 (35,785.67) 0.00 41400 SPECIAL DUTY PAY 61,506.00 3,853.65 58,596.23 0.00 2,909.77 95.26 41410 AUTO ALLOWANCE 2,736.00 243.70 2,977.92 0.00 (241.92) 108.84 41500 DEFERRED COMPENSATION MATCH 28,666.37 4,889.14 29,901.19 0.00 (1,234.82) 104.30 41510 PST DEFERRED COMPENSATION 484.86 48.48 568.13 0.00 (83.27) 117.17 41520 TIERED EMP DEF COMPENSATION 19,555.67 9,592.35 24,992.64 0.00 (5,436.97) 127.80 41530 TIERED RHS BENEFIT 11,834.36 4,709.70 12,608.58 0.00 (774.22) 106.54 41600 LONGEVITY 27,227.03 2,331.44 27,732.80 0.00 (505.77) 101.85 41660 TUITION REIMBURSEMENT 0.00 0.00 3,498.30 0.00 (3,498.30) 0.00 41700 ANNUAL LEAVE BUYBACK 66,185.08 0.00 66,722.55 0.00 (537.47) 100.81 41710 ANNUAL LEAVE OVER MAX 13,462.00 0.00 9,240.74 0.00 4,221.26 68.64 41910 PERS-NORMAL 663,628.36 53,948.03 628,043.29 0.00 35,585.07 94.63 JULIEK Page: 10 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/21/2025
Current Time: 11:16:01
User:

Report:

GL
06/30/2025
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2025
OB 12
Ledger:

Level:

Month to
41912 PERS-UNFUNDED 89,642.00 0.00 89,642.00 0.00 0.00 100.00 41920 MEDICARE 193,391.64 14,948.28 178,613.28 0.00 14,778.36 92.35 41929 SHORT TERM DISABILITY 17,357.08 1,728.00 20,008.60 0.00 (2,651.52) 115.27 41930 LONG TERM DISABILITY 36,883.98 2,865.96 33,192.31 0.00 3,691.67 89.99 41931 WORKERS COMP 149,947.86 43,439.67 137,472.34 0.00 12,475.52 91.68 41932 STATE UNEMPLOYMENT INSURANCE 5,843.58 448.91 5,458.52 0.00 385.06 93.41 41940 HEALTH INSURANCE 1,150,724.84 82,736.69 875,124.12 0.00 275,600.72 76.04 41941 RETIREES HEALTH INSURANCE/OPEB 646,272.00 164,383.06 657,533.53 0.00 (11,261.53) 101.74 41945 OPT OUT HEALTH INSURANCE 78,763.20 8,107.62 96,745.27 0.00 (17,982.07) 122.83 41946 LIFE INSURANCE 44,983.05 3,498.28 40,515.53 0.00 4,467.52 90.06 41951 HEALTH ALLOWANCE CREDIT 0.00 2,153.95 17,401.66 0.00 (17,401.66) 0.00 41996 VACANCY FACTOR (657,410.00) 0.00 0.00 0.00 (657,410.00) 0.00 41997 BUDGETARY/PAYROLL (12,185.23) 0.00 0.00 0.00 (12,185.23) 0.00 TOTAL FOR SALARIES-BENEFITS 8,908,746.39 888,902.01 8,848,398.24 0.00 60,348.15 99.32

SERVICES-SUPPLIES
42010 SUBSCRIPTIONS 0.00 0.00 468.00 0.00 (468.00) 0.00 42020 MINOR EQUIPMENT & FURNITURE 133,982.00 11,168.40 139,849.32 9,000.00 (14,867.32) 111.09 42033 CONSTRUCTION MATERIALS 1,582,024.27 110,530.65 1,442,125.49 240,305.29 (100,406.51) 106.34 42034 SAFETY MATERIALS/CONSTRUCTION 77,920.00 11,992.41 101,055.90 8,935.83 (32,071.73) 141.15 42055 COMPUTER EQUIPMENT & 49,665.50 15,067.58 79,263.94 36.72 (29,635.16) 159.66 42100 UNIFORM EXPENSE 24,932.53 (1,065.59) 25,752.68 0.00 (820.15) 103.28 42101 SAFETY SHOES - MOU ITEM 27,043.26 2,836.90 33,181.90 0.00 (6,138.64) 122.69 42200 ADVERTISING EXPENSE 8,460.00 0.00 874.00 0.00 7,586.00 10.33 42220 PROMOTIONAL/PUBLIC OUTREACH 21,371.81 7,063.32 45,092.15 0.00 (23,720.34) 210.98 42300 WIRELESS COMMUNICATION 71,277.29 4,822.07 40,631.02 0.00 30,646.27 57.00 42310 PHONES, FAX, ISDN LINES 12,923.92 3,730.40 29,766.85 0.00 (16,842.93) 230.32 42320 POSTAGE & SHIPPING 172,252.98 18,677.48 148,148.23 0.00 24,104.75 86.00 42340 OFFICE SUPPLIES 13,964.13 1,809.23 12,742.71 0.00 1,221.42 91.25 42345 FIRST AID KIT SUPPLIES 214.20 47.29 198.13 0.00 16.07 92.49 42350 PROGRAM EXPENDITURES 60,261.90 4,927.34 63,937.63 0.00 (3,675.73) 106.09 42360 CLEANING/JANITORIAL SUPPLIES 0.00 1,105.93 8,008.50 0.00 (8,008.50) 0.00 42365 RECYCLED CONTENT PRODUCTS 1,226.55 86.43 549.95 0.00 676.60 44.83 42370 OTHER CONTRACTED SERVICES 0.00 0.00 96.46 0.00 (96.46) 0.00 42410 ELECTRIC UTILITY 6,210,453.00 106,492.22 5,707,437.48 0.00 503,015.52 91.90 42420 NATURAL GAS UTILITY 1,976.00 97.27 1,399.59 0.00 576.41 70.82 42430 WATER UTILITY 61,576.66 253.58 95,783.65 0.00 (34,206.99) 155.55 42435 RECYCLED WATER UTILITY 7,639.22 0.00 7,949.44 0.00 (310.22) 104.06 42441 UNLEADED FUEL 2,286.00 0.00 1,102.64 0.00 1,183.36 48.23 42442 DIESEL FUEL 5,048.00 0.00 5,238.66 0.00 (190.66) 103.77 42500 RENTS & LEASES 873,427.00 0.00 655,070.25 0.00 218,356.75 75.00 JULIEK Page: 11 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/21/2025
Current Time: 11:16:01
User:

Report:

GL
06/30/2025
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2025
OB 12
Ledger:

Level:

Month to
42501 CUA LEASES 2,168,773.60 0.00 1,626,579.75 0.00 542,193.85 75.00 42600 MOTOR POOL RENTAL - OPS & MTCE 282,143.00 0.00 141,071.50 0.00 141,071.50 50.00 42605 RETAINED VEHICLE EXPENSE 5,732.00 0.00 2,866.00 0.00 2,866.00 50.00 42610 DIRECT VEHICLE EXPENSE 8,750.00 0.00 4,902.32 0.00 3,847.68 56.02 42660 MOTOR POOL RENTAL- 264,752.16 0.00 113,823.50 0.00 150,928.66 42.99 42700 OTHER EQUIPMENT RENTAL 64,322.74 0.00 6,845.84 5,000.00 52,476.90 18.41 42710 MILEAGE/VEHICLE EXP REIMB 2,760.00 108.64 888.00 0.00 1,872.00 32.17 42813 MTCE & REPAIR - EQUIP & FAC 607,163.03 23,157.01 464,967.34 257,513.49 (115,317.80) 118.99 42815 SCADA MAINTENANCE 371,027.00 48,803.54 294,065.62 14,831.70 62,129.68 83.25 42816 MOWING/LANDSCAPE CONTRACTS 138,739.81 0.00 15,117.62 92,560.00 31,062.19 77.61 42830 REBATE PROGRAMS 35,000.00 250.00 9,573.89 0.00 25,426.11 27.35 42900 PROF. & CONT. SVCS 2,814,015.85 284,703.73 2,137,685.95 77,972.72 598,357.18 78.73 42902 CUST CREDIT CRD PROCESSING FEE 390,346.86 22,104.09 245,121.39 95,682.05 49,543.42 87.30 42910 REFUSE DISPOSAL 1,575.00 1,922.39 1,922.39 0.00 (347.39) 122.05 43000 INSURANCE & SURETY BONDS 69,071.20 48,996.47 97,618.19 0.00 (28,546.99) 141.32 43100 MEMBERSHIP & DUES 203,080.25 11,424.00 187,913.30 0.00 15,166.95 92.53 43200 CONFERENCE, TRAINING & TRAVEL 77,095.00 4,031.69 46,761.85 0.00 30,333.15 60.65 43400 LEGAL SERVICES-SPECIAL COUNSEL 22,500.00 318.40 796.00 0.00 21,704.00 3.53 43502 SCHOOL PROGRAMS 29,480.00 11,330.13 23,947.57 852.43 4,680.00 84.12 43699 CHEMICALS-CORRSN & SCALE INHIB 171,281.05 0.00 0.00 150,000.00 21,281.05 87.57 43701 CHEMICALS-POLYMER 196,350.09 21,156.95 206,457.98 8,242.02 (18,349.91) 109.34 43702 CHEMICALS-ALUM 115,433.31 23,293.86 147,209.12 31,481.02 (63,256.83) 154.79 43703 CHEMICALS-AMMONIA 76,446.91 9,566.37 74,912.29 7,712.55 (6,177.93) 108.08 43704 CHEMICALS-ANTISCALANT 223,929.68 16,597.97 165,979.70 12,220.30 45,729.68 79.57 43705 CHEMICALS-SULFURIC ACID 281,400.34 28,453.77 264,512.48 3,487.52 13,400.34 95.23 43706 CHEMICALS-CAUSTIC SODA 60,000.00 8,774.01 104,729.69 5,270.31 (50,000.00) 183.33 43707 CHEMICALS-SODIUM 467,250.12 78,774.94 584,038.81 135,706.57 (252,495.26) 154.03 43711 CHEMICALS-MISC 110,000.00 0.00 60,000.00 0.00 50,000.00 54.54 43714 OUTSIDE LAB ANALYSIS 580,341.45 67,491.00 419,293.00 55,469.98 105,578.47 81.80 43715 REGULATORY PERMIT & USE FEES 197,434.21 5,957.85 192,337.48 0.00 5,096.73 97.41 43716 JOB REQ CERTIFICATES & LICENSE 4,248.90 2,069.97 16,327.80 0.00 (12,078.90) 384.28 43717 RAW WATER PURCHASES 17,218,307.49 1,604,809.26 17,357,391.24 0.00 (139,083.75) 100.80 43718 TREATED WATER PURCHASES 3,747,572.49 8,661.50 956,727.96 0.00 2,790,844.53 25.52 43720 LAB CHEMICALS AND SUPPLIES 56,410.20 3,010.66 50,226.04 15,675.94 (9,491.78) 116.82 43722 PREVENTION & MAINTENANCE 1,625,774.91 208,497.91 1,325,202.28 108,307.48 192,265.15 88.17 43723 INLAND EMPIRE BRINE LINE-SARI 1,669,176.79 174,006.72 1,383,918.50 0.00 285,258.29 82.91 43731 CARBON DIOXIDE 60,000.00 2,065.29 35,438.47 0.00 24,561.53 59.06 44100 INTEREST EXPENSE 556,414.35 0.00 329,918.15 0.00 226,496.20 59.29 44200 BAD DEBTS EXPENSE 147,537.84 0.00 0.00 0.00 147,537.84 0.00 44610 ADMINISTRATIVE SERVICES CHARGE 3,176,790.00 0.00 2,382,592.50 0.00 794,197.50 75.00 JULIEK Page: 12 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/21/2025
Current Time: 11:16:01
User:

Report:

GL
06/30/2025
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2025
OB 12
Ledger:

Level:

Month to
44613 INTERNAL SVC CHRG-WAREHOUSE 278,799.00 0.00 139,399.50 0.00 139,399.50 50.00 44614 INTERNAL SVC CHRG-INFO TECH 1,938,262.00 0.00 1,453,696.50 0.00 484,565.50 75.00 TOTAL FOR SERVICES-SUPPLIES 49,935,414.85 3,019,981.03 41,718,502.08 1,336,263.92 6,880,648.85 86.22

CAPITAL OUTLAY
45100 LICENSED VEHICLES 0.00 0.00 19,601.24 0.00 (19,601.24) 0.00 45200 MACHINERY, EQUIPMENT, & FIXTUR 50,000.00 0.00 7,042.57 0.00 42,957.43 14.08 45600 BUILDINGS, STRUCTURES, & IMPRO 0.00 0.00 73,900.00 0.00 (73,900.00) 0.00 TOTAL FOR CAPITAL OUTLAY 50,000.00 0.00 100,543.81 0.00 (50,543.81) 201.08 TOTAL FOR WATER UTILITY SERVICES 58,894,161.24 3,908,883.04 50,667,444.13 1,336,263.92 6,890,453.19 88.30 FUN 570 109,991,752.38 5,104,728.39 63,250,489.64 23,665,855.87 23,075,406.87 79.02 JULIEK Page: 13 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/21/2025
Current Time: 11:16:01
User:

Report:

GL
06/30/2025
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2025
OB 12
Ledger:

Level:

Month to
571 WATER UTILITY GRANT/AGREEMENT
00 NOT APPLICABLE

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 0.00 333.84 3,980.87 0.00 (3,980.87) 0.00 41141 SP COMP-BILINGUAL 0.00 0.00 3.24 0.00 (3.24) 0.00 41910 PERS-NORMAL 0.00 40.23 480.05 0.00 (480.05) 0.00
41920 MEDICARE 0.00 9.88 117.82 0.00 (117.82) 0.00
41931 WORKERS COMP 0.00 6.67 79.69 0.00 (79.69) 0.00
41932 STATE UNEMPLOYMENT INSURANCE 0.00 0.30 3.58 0.00 (3.58) 0.00 41951 HEALTH ALLOWANCE CREDIT 0.00 2.83 13.59 0.00 (13.59) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 393.75 4,678.84 0.00 (4,678.84) 0.00

SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 7,001,304.21 0.00 0.00 0.00 7,001,304.21 0.00 42830 REBATE PROGRAMS 0.00 0.00 (121,339.15) 0.00 121,339.15 0.00 42900 PROF. & CONT. SVCS 199,434.79 12,793.75 68,740.38 76,939.51 53,754.90 73.04 43300 CONSTRUCTION CONTRACTS 345,199.11 0.00 0.00 2,000,000.00 (1,654,800.89) 579.37 TOTAL FOR SERVICES-SUPPLIES 7,545,938.11 12,793.75 (52,598.77) 2,076,939.51 5,521,597.37 26.82 TOTAL FOR NOT APPLICABLE 7,545,938.11 13,187.50 (47,919.93) 2,076,939.51 5,516,918.53 26.88 FUN 571 7,545,938.11 13,187.50 (47,919.93) 2,076,939.51 5,516,918.53 26.88 JULIEK Page: 14 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/21/2025
Current Time: 11:16:01
User:

Report:

GL
06/30/2025
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2025
OB 12
Ledger:

Level:

Month to
GRAND TOTAL 127,417,651.55 5,244,130.59 66,497,727.29 26,473,020.00 34,446,904.26 72.96 JULIEK Page: 15 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/21/2025
Current Time: 11:16:01
User:

Report:

← All documents from this meeting