Revenue Detail by Fund
Second Quarter
Fiscal Year 2022-23
Attachment 2
Actual
Actual
Actual
Adopted
Budget
Q2
July-Dec
Description 2019-20 2020-21 2021-22 2022-23 2022-23
GENERAL FUND - 10
4010 Property Tax - CY Secured 30,178,732 32,927,960 33,417,323 34,424,535 18,260,920 4011 Property Tax - PY Secured 157,620 191,071 249,665 199,755 124,216 4012 Penalties/Delinquencies - PY 37,433 71,366 51,142 43,000 23,615 4015 Supplemental Roll 566,925 586,637 634,843 575,000 413,962 4020 Property Tax - CY Unsecured 828,336 862,152 905,744 901,337 428,324 4021 Prop Tax Collection Fees (176,435) (197,269) (186,649) (200,000) 0 4030 Homeowners Subvention 90,197 138,397 132,774 143,000 20,226 4033 Property Tax In-Lieu 14,502,620 15,494,541 15,611,953 16,080,312 - Total Property Taxes 46,185,429 50,074,855 50,816,796 52,166,939 19,271,262 4110 Sales & Use Ta x 22,111,203 24,569,589 29,292,047 29,429,594 10,367,172 4112 Prop 172 983,317 1,001,790 1,201,784 1,017,000 476,635 4130 Transient Occupancy Ta x 2,377,697 1,285,299 2,960,986 2,900,000 1,148,510 4131 Short Term Rentals TOT - 44,825 179,476 360,000 114,757 4150 Business Registration 1,159,258 1,089,393 1,213,710 1,165,544 585,909 4151 Oil Extraction Taxes 6,386 6,909 - 10,000 - 4170 Real Estate Transfer Ta x 741,174 930,576 1,197,567 875,000 436,109 Total Other Taxes 27,379,035 28,928,382 36,045,570 35,757,138 13,129,092 4220 Development Permits 1,260,989 1,454,251 2,075,328 1,395,350 1,036,929 4223 Building Permit Surcharge 24,803 26,434 51,066 - - 4225 Dep. Inspector Cert. Fee 2,451 2,280 3,846 5,000 1,294 4226 Parking Permit Fees 16,118 16,404 19,284 16,000 1,254 4228 Fireworks Permits 26,186 70,564 35,646 34,890 - 4260 Public Works Permits 109,649 112,653 68,614 120,000 27,741 4270 Police Alarm Permits 234,002 238,294 270,581 275,000 123,528 4280 Other Licenses & Permits 88,868 103,357 105,597 151,700 52,294 4282 Hazardous Mat Disclosures 272,955 271,508 2,125 - - 4283 Underground Tank Permits 87,761 86,257 12,061 - 3,342 4284 Overload Permits 22,784 23,500 21,982 20,400 13,736 4285 Encroachment Permits - - 70,373 - 68,416 Total Licenses & Permits 2,146,566 2,405,501 2,736,502 2,018,340 1,328,532 4330 Other Court Fines - Fund 10 994,818 847,839 1,484,927 1,500,000 711,668 4360 Administrative Citation 12,240 20,820 71,380 24,100 97,542 Total Fines & Penalties 1,007,058 868,659 1,556,307 1,524,100 809,210 4410 Interest Income 438,429 160,090 (44,622) 361,230 (37,490) 4412 Unrealized Gain/Loss on Invest (23,025) (507,435) (1,181,718) - 1,117,864 4413 Supplemental Interest 458,834 399,062 19,925 - - 4417 Property Lease 1,230,378 1,241,563 1,241,563 1,237,563 618,782 4418 Cell Tower Rent 11,478 6,473 413,094 255,000 228,417 4419 Property Lease - - - 150,000 - 4420 Rents 511,789 376,909 - 699,000 240,272 4421 Parks & Rec Facility Rent - - 727,784 - - 4424 Vista Park Lease - - - 550,000 175,390 4429 Fire Dept Lease 42,531 43,847 619,964 45,000 - 4440 General Concessions 75,787 75,787 98,565 75,787 18,947 4441 R-O-W Impact Fee 387,260 383,260 75,787 383,260 191,630 4445 Prisoners Welfare 405 - 383,260 1,000 - 4460 Franchise Fees 4,145,175 4,181,577 4,269,636 4,300,000 1,361,567 4466 Franchise - Cable PEG Support - - - - - Total Use of Money & Property 7,279,042 6,361,133 6,623,238 8,057,840 3,915,378
Revenue Detail by Fund
Second Quarter
Fiscal Year 2022-23
Attachment 2
Actual
Actual
Actual
Adopted
Budget
Q2
July-Dec
Description 2019-20 2020-21 2021-22 2022-23 2022-23
GENERAL FUND - 10
4512 MVL In-Lieu Ta x 113,039 104,047 161,078 125,000 - 4527 POST 73,531 15,798 24,281 30,000 9,651 4528 State Mandated Cost Reimb 79,418 133,158 65,055 100,000 - 4569 Federal Grants - - 1,000 - - 4570 Federal Dept. of Justice - - - - - 4580 Other Agency Contributions 501,599 1,329,070 1,261,939 416,725 198,575 4581 Parks Maint - School Dist 117,887 181,608 46,655 175,000 175,000 Total Other Agencies 885,474 1,763,681 1,560,008 846,725 383,226 4600 Planning Fees 438,586 422,115 592,095 506,600 362,599 4608 Seismic Fees 604 638 1,319 - 358 4611 Microfilming Fees 25,069 32,476 33,775 20,000 18,829 4612 Sale of Maps & Publications 4,051 5,565 16,254 8,000 4,638 4613 Misc Filing/Cert Fees - 4,514 - - 3,062 4614 Plan Check Fees 813,440 765,116 2,015,853 1,072,574 1,181,257 4617 Weed and Lot Cleaning - - - - - 4618 Refuse Services 615,177 972,402 790,477 737,892 310,319 4619 CRV 256,081 210,117 213,799 - - 4621 San. District Connection 7,660 5,769 5,768 10,000 4,897 4627 SB1473 Collection Fees 86 566 428 400 - 4628 Plan Check Premium In-House 2,592 90 5,823 - - 4632 Inspection Premium In-House 7,088 8,021 5,532 3,500 9,582 4633 Business License Review 26,509 15,136 23,384 14,000 13,044 4640 Misc Fire Fees 358,874 345,524 325,559 310,000 197,203 4641 Paramedic Fees for Service 14,860 5,750 - - - 4643 Paramedic Subscription - Res. 705,055 695,912 733,845 700,000 (150,535) 4644 Ambulance Billing 4,150,036 3,520,400 4,342,541 4,126,818 1,769,558 4645 Paramedic Subscription - Bus. 4,518 3,408 38,888 5,000 322 4647 Fire Dept - New business 9,713 10,210 19,376 15,000 19,289 4648 Fire Bldg Plan Ck/Inspection 25,619 21,247 23,574 25,000 11,828 4649 Advanced Life Support 4,116 - - - - 4676 Vehicle Charging Station Fees 5,833 3,909 7,365 6,600 3,669 4680 Parking Fees 167,901 73,522 145,820 175,000 71,516 4681 Documentation Assistance Fees - - 15 - - 4710 Misc Check Fees 7,338 3,046 5,339 - 1,928 4714 Witness Fees 6,340 4,460 1,710 8,200 15 4719 Inspection Prem - Outside Svc 1,865 270 8,315 2,000 2,544 4721 Construction Mgt Reimb - 10,181 - - - 4728 Medical Supplies Reimb - - - - 4729 Police - Pay to Sta y - - - 30,000 - 4730 Misc Police 989,995 1,123,378 664,784 1,399,446 831,158 4731 Public Works Fees 440,941 526,091 467,851 362,000 319,001 4737 Damage Repair 44,696 134,719 33,522 40,000 23,672 4799 Misc. Fees - 168 - - - Total Charges for Service 9,134,640 8,924,720 10,523,012 9,578,030 5,009,755 4810 Sale of Propert y 370,249 23,049 12,528 10,000 2,124 4815 Donations 6,734 287,298 297,123 303,977 249,433 4822 Misc Reimbursements/Rebates 28,072 22,191 - 15,000 6,221 4824 Admin Indirect Cost - - 100,247 1,524,564 732,452 4830 Miscellaneous 309,247 105,128 81,550 10,000 52,784 4834 Contributed Asset fr Developer - - - - - Total Other Revenue 714,302 437,666 491,448 1,863,541 1,043,013 Total General Fund 94,731,545 $ 99,764,596 $ 110,352,882 $ 111,812,652 $ 44,889,468 $
Revenue Detail by Fund
Second Quarter
Fiscal Year 2022-23
Attachment 2
Actual
Actual
Actual
Adopted
Budget
Q2
July-Dec
Description 2019-20 2020-21 2021-22 2022-23 2022-23
INFRASTRUCTURE FUND - 11
4410 Interest Income - - (5,280) - 6,190 Total Infrastructure Fund - $ - $ (5,280)$ - $ 6,190$ LIBRARY FUND - 13
4010 Property Tax - CY Secured 72,718 74,837 76,970 80,598 41,937 4350 Library Fines 38,246 2,316 4,207 4,100 233 4351 Interlibrary Loan Postage 43 - 89 100 48 4420 Rents 18,810 - 11,739 20,000 8,097 4425 Hunt Library Rent 18,000 1,500 - - - 4529 State Grants 7,940 - - 40,000 19,347 4569 Federal Grants - - - - - 4657 Passport Execution Fee 141,255 - - 168,000 8,585 4658 Passport Photo Fee 28,257 10 - 28,500 2,510 4735 Library Books Lost & Paid - - 116 - 2,559 4815 Donations 5,730 4,602 6,587 600 99,918 4830 Miscellaneous Revenue 492 89,646 32,337 - (15,078) 4870 Restricted Contributions (21,260) 76,164 92,892 99,000 17,834 Total Library Fund 310,230 $ 249,075 $ 224,936 $ 440,898 $ 185,989 $ PARKS & RECREATION FUND - 15
4410 Interest Income - - 908 - - 4418 Cell Tower Rent 231,687 274,240 2,551 - - 4419 Park Property Lease 105,852 105,852 106,032 105,852 52,926 4420 Rents 159,951 92,603 129,445 82,000 43,519 4421 Facility Rental 360,690 (50,978) 490,616 524,100 195,880 4424 Vista Park Restaurant Lease 477,340 335,205 45,375 - - 4438 Field Use Charges 49,800 149,405 120,285 125,000 51,793 4440 General Concessions 16,866 1 8,156 6,000 4,178 4685 Parks & Recreation Fees 425,535 239,579 458,567 458,425 175,089 4815 Donations 83,763 74,535 148,000 13,000 7,000 4830 Miscellaneous 31,219 6,345 19,032 57,000 40,689 4831 Museum Center 21,427 1,817 - - - Total Parks & Recreation Fund 1,964,129$ 1,228,603 $ 1,528,968 $ 1,371,377 $ 571,073 $ TOTAL GENERAL OPERATING FUNDS 97,005,904$ 101,242,275 $ 112,101,506 $ 113,624,927 $ 45,652,720 $ WEST COYOTE HILLS ENDOWMENT - 20
4410 Interest Income - - (2,350) - 84 4815 Donations - - 103,038 - 2,399 Total W. Coyote Endowment Fund - $ - $ 100,688$ - $ 2,483$ AIR QUALITY IMPROVEMENT FUND - 22
4410 Interest Income 17,429 13,231 4,134 15,600 956 4412 Unrealized Gain/Loss on Invest 4,655 (8,704) (26,818) - 25,230 4517 Motor Vehicle Air Quality Fees 181,139 185,242 134,334 181,000 45,859 4580 Other Agency Contributions - - - - - Total Air Quality Fund 203,223 $ 189,769 $ 111,650 $ 196,600 $ 72,044 $
Revenue Detail by Fund
Second Quarter
Fiscal Year 2022-23
Attachment 2
Actual
Actual
Actual
Adopted
Budget
Q2
July-Dec
Description 2019-20 2020-21 2021-22 2022-23 2022-23
SANITATION FUND - 23
4410 Interest Income 55,223 31,412 5,105 58,136 959 4412 Unrealized Gain/Loss on Invest 28,562 (24,668) (39,172) - 35,278 4620 Sanitation Fees * 5,647,47 0 5,781,554 6,366,001 7,200,00 0 3,098,743 4737 Damage Repair 4,605 5,384.23 1,846 - 7,167 Total Sanitation Fund 5,735,859 $ 5,793,682 $ 6,333,780 $ 7,258,136 $ 3,142,147 $ MEASURE M2 FUND - 25
4410 Interest Income 85,483 70,641 15,176 72,925 6,987 4412 Unrealized Gain/Loss on Invest 16,736 (29,266) (75,115) - 70,541 4546 Measure M2 2,447,087 2,357,163 3,183,746 2,968,104 1,173,728 Total Measure M2 Fund 2,549,307 $ 2,398,538 $ 3,123,807 $ 3,041,029 $ 1,251,257 $ HOUSING FUND - 26
4410 Interest Income 298,771 271,429 262,784 275,350 987 4412 Unrealized Gain/Loss on Invest 14,046 (23,100) (30,429) - 28,227 4680 Parking Fees 1,800 - 4,750 - - 4830 Miscellaneous 4,750 4,750 650 - - 4843 Loan Repayment 318,172 295,452 287,768 150,000 132,722 4998 Allocation to Notes Receivable (318,172) (295,452) (287,768) (150,000) (132,722) Total Housing Fund 319,367 $ 253,079 $ 237,755 $ 275,350 $ 29,214 $ FTV CABLE-PEG ACCESS FUND - 27
4410 Interest Income 4,586 13,178 4,007 16,015 888 4412 Unrealized Gain/Loss on Invest 11,578 (10,051) (24,675) - 23,148 4466 Franchise - Cable PEG Support 213,244 200,407 197,873 200,000 53,689 Total FTV Cable-PEG Access Fund 229,408$ 203,535 $ 177,205 $ 216,015 $ 77,725 $ SB2/PLHA FUND - 28
4410 Interest Income - 308 839 - 527 4412 Unrealized Gain/Loss on Invest - 360 (5,040) - 4,680 4529 State Grant - 688,452 2,362 1,070,068 1,070,068 Total SB2/PHLA Fund - $ 689,120$ (1,839) $ 1,070,068$ 1,075,275 $ SB1/RMRA FUND - 29
4410 Interest Income 67,380 94,480 19,288 81,816 7,128 4412 Unrealized Gain/Loss on Invest 20,367 (24,324) (81,016) - 75,297 4515 Gas Tax SB1/RMR A 2,473,694 2,407,050 2,815,910 3,178,282 1,304,687 Total SB1/RMRA Fund 2,561,441 $ 2,477,205 $ 2,754,181 $ 3,260,098 $ 1,387,112 $ GAS TAX FUND - 30
4410 Interest Income 80,427 53,636 9,403 61,020 2,325 4412 Unrealized Gain/Loss on Invest 12,135 (26,975) (20,388) - 17,061 4513 Gas Tax - 2106 454,950 455,270 485,234 548,659 210,648 4514 Gas Tax - 2103 984,824 977,424 1,099,561 1,373,255 527,304 4518 Gas Tax - 2107 929,942 1,013,126 936,847 1,238,981 471,710 4535 Gas Tax - 2105 728,557 739,322 775,090 899,588 333,250 4737 Damage Repair 15,945 14,644 7,527 15,000 75,124 4830 Miscellaneous 160,566 - - - - Total Gas Tax Fund 3,367,347 $ 3,226,447 $ 3,293,274 $ 4,136,503 $ 1,637,423 $
Revenue Detail by Fund
Second Quarter
Fiscal Year 2022-23
Attachment 2
Actual
Actual
Actual
Adopted
Budget
Q2
July-Dec
Description 2019-20 2020-21 2021-22 2022-23 2022-23
GRANTS FUND - 32
4410 Interest Income - - - - 553.77 4529 State Grants 153,341 105,798 212,035 35,000 5,119,342 4543 County Grants - - - - - 4563 Older Americans Act Grant 43,763 151,903 68,947 80,564 46,057 4567 Program Income 53,402 26,297 52,838 - - 4568 HOME Grant 44,780 86,985 56,648 539,238 - 4569 Federal Grants 1,604,702 4,049,773 487,604 302,498 796,499 4580 Other Agency Contributions 633,696 671,214 174,100 336,706 179,819 4814 HOME DAP Repayment - - - 40,000 122,627 4822 Misc. Reimbursements/Rebates - - - - 320 4843 Loan Repayment/Rehab - - - - 128,360 Total Grants Fund 2,533,683 $ 5,091,969 $ 1,052,173 $ 1,334,006 $ 6,393,578 $ SLES FUND - 33
4529 State Grants 339,208 338,298 345,673 300,000 202,144 Total SLES Fund 339,208 $ 338,298 $ 345,673 $ 300,000 $ 202,144 $ ASSET SEIZURE FUND - 34
4410 Interest Income 19,732 6,964 1,612 10,679 339 4412 Unrealized Gain/Loss on Invest 1,917 (7,456) (6,946) - 6,359 4569 Federal Grants 3,010 - - 15,000 9,360 4570 Federal Dept of Justice 237,097 376,717 365,140 350,000 529,527 4580 Other Agenc y - - 24,289 - 24,275 4730 Miscellaneous 7,284 98,244 5,425 - - Total Asset Seizure Fund 269,041 $ 474,468 $ 389,520 $ 375,679 $ 569,861 $ CDBG FUND - 35
4562 CDBG 1,783,689 1,372,023 2,763,633 1,828,782 682,316 4587 Grant - Program Income - - 11,331 - 4,927 4830 Miscellaneous 57,662 707 3,126 - 19,023 Total CDBG Fund 1,841,351 $ 1,372,730 $ 2,778,089 $ 1,828,782 $ 706,266 $ DRAINAGE CAPITAL OUTLAY FUND - 36
4410 Interest Income 123,856 87,300 25,394 93,795 8,212 4412 Unrealized Gain/Loss on Invest 57,309 (49,660) (116,306) - 108,657 4620 Sanitation Fees * 2,196,31 3 2,248,382 1,499,905 800,000 218,166 Total Drainage Capital Outlay Fund 2,377,478$ 2,286,022 $ 1,408,993 $ 893,795 $ 335,035 $ TRAFFIC SAFETY FUND - 37
4310 Motor Vehicle Fines 193,500 143,492 131,300 200,000 52,440 Total Traffic Safety Fund 193,500 $ 143,492 $ 131,300 $ 200,000 $ 52,440 $ ARPA FUND - 38
4410 Interest Income - 31,867 85,724 - 24,311 4412 Unrealized Gain/Loss on Invest - 29,411 (777,587) - 748,177 4569 Federal Grant - - 1,006,612 - 32,665,301 Total ARPA Fund - $ 61,277$ 314,748$ - $ 33,437,788$
Revenue Detail by Fund
Second Quarter
Fiscal Year 2022-23
Attachment 2
Actual
Actual
Actual
Adopted
Budget
Q2
July-Dec
Description 2019-20 2020-21 2021-22 2022-23 2022-23
PARK DWELLING FUND - 39
4410 Interest Income 127,041 73,527 9,979 94,928 3,321 4412 Unrealized Gain/Loss on Invest 49,878 (46,983) (23,049) - 20,154 4684 Park Dwelling Fees 472,420 688,780 232,020 8,786,620 404 Total Park Dwelling Fund 649,339 $ 715,323 $ 218,950 $ 8,881,548$ 23,880 $ AIRPORT FUND - 40
4060 Aircraft Taxes 106,514 87,697 113,521 110,000 185,521 4226 Parking Permits 960 500 600 1,374 80 4410 Interest Income 55,108 33,375 32,307 35,448 3,422 4412 Unrealized Gain/Loss on Invest 26,671 (22,762) (75,791) - 71,882 4420 Rents 69,107 56,831 43,956 75,600 22,998 4430 Fixed-Base Operators 549,212 529,970 553,939 551,250 278,568 4431 Hangar Admin Fee 1,800 5,600 7,788 4,000 2,300 4432 Hangar Rental 1,106,382 1,100,610 1,122,606 1,260,000 653,965 4433 Fuel Flowage Fee 49,856 39,767 48,117 42,000 20,362 4434 Tie-Downs 64,935 65,031 93,654 50,600 66,110 4436 Visitor Aircraft Parking 5,016 17,920 5,874 5,500 7,201 4438 Field Usage Charges 2,132 1,574 2,888 1,700 1,075 4440 General Concessions 20 - - 330 - 4569 Federal Grants - 257,779 2,539,983 - (49,312) 4720 Airport Fees - 4,400 5,685 4,400 4,400 4815 Donations - - 2,300,000 - - 4840 Bond Proceeds - - 269,666 - - 4830 Miscellaneous 5,584 1,785 2,485 6,600 - Total Airport Fund 2,043,298 $ 2,180,077 $ 7,067,340 $ 2,148,802 $ 1,268,571 $ COMPRESSED NATURAL GAS (CNG) - 41
4410 Interest Income 6,386 3,487 709 - (18) 4412 Unrealized Gain/Loss on Invest 3,654 (3,236) (2,672) - 2,254 4420 Rents - 126 - - - 4674 CNG Sales 189,971 169,979 150,102 160,000 371 Total CNG Fund 200,010 $ 170,356 $ 148,140 $ 160,000 $ 2,607 $ BREA DAM RECREATIONAL FUND - 42
4410 Interest Income (10,051) (18) 32,103 - 5,463 4412 Unrealized Gain/Loss on Invest (4,251) 7,640 (53,364) - 52,313 4418 Cell Tower Rent 30,193 30,910 32,984 32,000 16,329 4419 Park Property Lease 23,975 18,624 24,872 24,000 12,681 4420 Rents 2,000 2,000 2,000 2,000 40,000 4421 Facility Rentals 34,203 72,971 49,536 39,200 25,906 4438 Field Use Charges 126,131 175,182 203,886 202,000 106,369 4440 General Concessions 3,549 1,366 316 1,000 398 4680 Parking Fees 151,762 - - 80,000 - 4686 Golf Fees 1,853,014 3,302,334 3,582,306 3,243,500 1,827,498 4694 Brea Dam Fees 223,294 354,536 360,357 350,000 178,254 4815 Donations - - 13,950 30,000 30,000 4830 Miscellaneous - - (451,715) - - Total Brea Dam Fund 2,433,819 $ 3,965,543 $ 3,797,231 $ 4,003,700 $ 2,295,211 $ WATER FUND - 44
4260 Public Works Permits 56,021 25,253 38,216 40,000 14,287 4280 Other Licenses & Permits - - - - - 4281 Temp Water Permits 4,862 6,178 5,958 5,000 2,445
Revenue Detail by Fund
Second Quarter
Fiscal Year 2022-23
Attachment 2
Actual
Actual
Actual
Adopted
Budget
Q2
July-Dec
Description 2019-20 2020-21 2021-22 2022-23 2022-23
4410 Interest Income 692,760 497,789 162,645 600,000 44,040 4412 Unrealized Gain/Loss on Invest 417,861 (354,349) (1,130,289) - 1,066,776 4418 Cell Tower Rent 302,455 291,726 319,362 320,000 200,345 4442 Undergound Locating Svc Impact - - 270,000 270,000 135,000 4529 State Grants - 689,077 345,758 - (343,179) 4569 Federal Grants - 290,000 143,116 - - 4580 Other Agenc y - - 19,340 - 39,975 4612 Sale of Maps & Publications 1,886 2,665 1,974 3,300 1,086 4614 Plan Check Fees 31,357 35,122 45,487 38,500 21,365 4660 Water Sales * 35,930,94 3 42,483,95 9 46,590,37 0 50,000,00 0 20,590,263 4661 Temp Water Sales 36,176 41,604 184,864 40,000 40,166 4662 Municipal Water Sales 794,105 1,003,854 1,086,503 1,100,000 637,874 4664 Front Footage Charges 4,275 17,089 - - - 4665 Net Zero Water Impact Fee - - - - - 4666 Customer Service Charges 177,181 111,049 103,951 240,000 80,705 4668 Water Delinquent Charges 404,375 591,484 1,212,315 600,000 652,066 4670 Water System Reimb - Devel. 5,462 18,394 10,056 7,748 3,248 4671 Construction Mgmt Reimb 2,618 - - - - 4672 Water System Mod. Fees 19,574 9,139 13,948 16,500 4,788 4673 Water Cross-Connection Inspec 7,325 1,167 7,403 27,700 228 4710 Miscellaneous Fees & Charges 5,265 4,112 5,365 - 2,225 4734 Water Maintenance Charges 925 1,351 1,158 1,200 193 4737 Damage Repair 1,685 47,183 40,228 - 2,987 4810 Sale of Propert y 19,512 95,415 29,878 20,000 7,344 4830 Miscellaneous 45,593 75,334 213,078 50,000 329 4834 Contributed Assets 567,355 65,125 198,170 - - 4842 Premium on Bond Sales 38,615 38,615 38,615 38,615 38,615 Total Water Fund 39,568,185 $ 46,088,334 $ 49,957,470 $ 53,418,563 $ 23,243,172 $ WHITING-LEMON PARKING FUND - 45
4410 Interest Income (1,358) (1,527) 4,123 - (4,962) 4680 Parking Fees 7,677 - - 10,000 - Total Whiting-Lemon Parking Fund 6,319$ (1,527)$ 4,123 $ 10,000$ (4,962) $ REFUSE COLLECTION FUND - 46
4410 Interest Income 32,453 17,788 4,181 30,000 990 4412 Unrealized Gain/Loss on Invest 11,801 (10,047) (26,931) - 25,176 4529 State Grants - - - - 197,528 4618 Refuse Collection * 11,624,00 5 12,665,04 3 13,091,81 8 12,981,66 9 5,355,550 4618 Refuse Contract Fees - - - 134,171 - 4619 CRV - - - 265,393 - 4626 AB939 Fees-Recycling Surcharge 435,104 441,753 438,682 446,400 209,558 4830 Miscellaneous - 27,500 - - - Total Refuse Fund 12,103,363 $ 13,142,038 $ 13,507,750 $ 13,857,633 $ 5,788,801 $ SEWER ENTERPRISE FUND - 47
4251 Wastewater Discharge Permit 35,500 36,200 36,200 40,000 500 4410 Interest Income 250,345 148,721 36,828 187,650 8,195 4412 Unrealized Gain/Loss on Invest 136,322 (120,452) (212,210) - 196,341 4677 Sewer Service Fee * 5,908,35 6 6,168,81 9 6,025,151 6,100,00 0 2,517,804 4830 Miscellaneous - 7,023.84 30,319 - - Total Sewer Fund 6,330,523 $ 6,240,311 $ 5,916,287 $ 6,327,650 $ 2,722,841 $
Revenue Detail by Fund
Second Quarter
Fiscal Year 2022-23
Attachment 2
Actual
Actual
Actual
Adopted
Budget
Q2
July-Dec
Description 2019-20 2020-21 2021-22 2022-23 2022-23
LIABILITY INSURANCE FUND - 62
4410 Interest Income 649,230 369,674 78,508 350,000 14,090 4412 Unrealized Gain/Loss on Invest 179,039 (321,178) (545,164) - 507,485 4754 Interfund Insurance Premiums 5,959,115 6,355,060 7,348,463 12,030,365 6,012,261 4811 Prior Year Recoverable Cost 1,200 900 1,100 - 500 4821 Insurance Reimbursement - 2,449 - - 4841 Bond Proceeds - 5,010,000 - - - 4999 Revenue Allocation (5,959,115) (11,365,060) (7,348,463) (12,030,365) (6,012,261) Total Liability Insurance Fund 829,469 $ 49,396 $ (463,107)$ 350,000 $ 522,075 $ VEHICLE REPLACEMENT FUND - 64
4410 Interest Income 141,475 85,794 19,890 80,000 6,444 4412 Unrealized Gain/Loss on Invest 29,118 (65,939) (122,080) - 113,940 4420 Rents 25,172 - - - - 4756 Equipment Replacement 1,408,560 1,636,296 2,822,721 2,908,810 1,411,522 4810 Sale of Propert y 25,350 147,244 100,394 - 59,459 4830 Miscellaneous - 35,000 12,708 - - 4834 Contributed Asset fr Developer - - 750,000 - - 4999 Revenue Allocation (1,408,560) (1,636,296) (2,822,721) (2,908,810) (1,411,522) Total Vehicle Replacement Fund 221,115$ 202,099 $ 760,912 $ 80,000 $ 179,842$ WORKERS COMP FUND - 65
4410 Interest Income 656,588 418,100 117,728 450,000 25,054 4412 Unrealized Gain/Loss on Invest 192,603 (318,349) (736,786) - 688,128 4760 Workers Comp 4,276,274 4,520,937 4,429,433 4,044,891 2,043,058 4811 PY Recoverable Costs - 1,795 859 - 146 4820 Worker Comp Benefit Reimb 172,106 234,727 263,676 - 244,320 4999 Revenue Allocation (4,276,274) (4,520,937) (4,429,433) (4,044,891) (2,043,058) Total Workers Comp Fund 1,021,298 $ 336,274 $ (354,523)$ 450,000 $ 957,648 $ GROUP INSURANCE FUND - 66
4410 Interest Income 41,639 24,386 7,327 25,000 1,884 4412 Unrealized Gain/Loss on Invest 27,384 (23,720) (51,563) - 47,899 4754 Insurance Premiums 7,696,373 7,495,483 7,325,916 7,923,036 3,407,399 4815 Donations - - - - 4823 Cigna Wellness Contributions 748 76,489 29,352 - 45,369 4999 Revenue Allocation (7,696,373) (7,495,483) (7,325,916) (7,923,036) (3,407,399) Total Group Insurance Fund 69,771 $ 77,156 $ (14,884)$ 25,000 $ 95,152 $ EQUIPMENT MAINTENANCE FUND - 67
4410 Interest Income 143,119 83,182 21,344 80,000 3,080 4412 Unrealized Gain/Loss on Invest 70,600 (61,185) (123,794) - 114,379 4737 Damage Repair 21,764 29,189 41,072 - - 4755 Equipment Maint 2,980,783 3,143,732 2,957,261 3,387,291 1,676,903 4810 Sale of Propert y 198 305 - - - 4830 Miscellaneous - - 520 - - 4999 Revenue Allocation (2,980,783) (3,143,732) (2,957,261) (3,387,291) (1,676,903) Total Equipment Maint Fund 235,680 $ 51,491 $ (60,857)$ 80,000 $ 117,459$ INFORMATION TECHNOLOGY FUND - 68
4410 Interest Income 25,924 40,688 9,036 45,000 1,661 4412 Unrealized Gain/Loss on Invest 5,954 (2,538) (79,461) - 76,045 4420 Rents - - - - 27,840 4757 Information Technolog y 3,131,522 2,958,310 5,783,610 6,608,328 3,333,236
Revenue Detail by Fund
Second Quarter
Fiscal Year 2022-23
Attachment 2
Actual
Actual
Actual
Adopted
Budget
Q2
July-Dec
Description 2019-20 2020-21 2021-22 2022-23 2022-23
4999 Revenue Allocation (3,131,522) (2,958,310) (5,783,610) (6,608,328) (3,333,236) Total Information Tech. Fund 31,878 $ 38,150 $ (70,426)$ 45,000 $ 105,546$ BUILDING MAINTENANCE FUND - 69
4410 Interest Income 23,311 18,824 7,296 20,000 3,214 4412 Unrealized Gain/Loss on Invest 14,069 (11,451) (62,154) - 59,535 4758 Building Maintenance 2,652,787 2,750,643 2,769,009 2,783,410 1,394,065 4999 Revenue Allocation (2,652,787) (2,750,643) (2,769,009) (2,783,410) (1,394,065) Total Building Maint. Fund 37,380 $ 7,373 $ (54,858)$ 20,000 $ 62,749 $ FACILITY CAPITAL REPAIR FUND - 70
4410 Interest Income 54,572 43,138 10,533 50,000 3,397 4412 Unrealized Gain/Loss on Invest 13,834 (21,411) (46,194) - 42,921 4759 Facility Capital Repair 545,453 516,533 561,954 564,224 283,686 4815 Donations 88,880 - - - - 4999 Revenue Allocation (545,453) (516,533) (561,954) (564,224) (283,686) Total Facility Capital Repair Fund 157,286$ 21,728 $ (35,661)$ 50,000 $ 46,319 $ CAPITAL PROJECTS FUND - 74
4410 Interest Income 516 - - - - 4529 State Grants 6,749,857 322,181 16,823,578 2,750,000 3,390,157 4543 County Grants - - - - 1,000,000 4545 Measure M Regional 1,409,535 5,035,292 411,548 1,638,672 318,925 4569 Federal Grants 13,546,069 - 2,000,000 659,000 - 4580 Other Agency Contributions 2,144,068 229,644 54,423 100,000 284,096 4582 Emergency Management Reimb 20,374 41,004 - - - 4609 Traffic Mitigation Fees 62,155 - - 120,000 - 4631 Development Agreement Fees - 21,528 77,244 300,000 286,613 4737 Damage Repair - - 1,753 - 163,308 4830 Miscellaneous 37,585 78,318 14,676 - 104,962 4840 Bond/Loan Proceeds - - 8,894,000 - - 4999 Revenue Allocation - - (8,894,000) - - Total Capital Projects Fund 23,970,159 $ 5,727,967 $ 19,383,221$ 5,567,672 $ 5,548,060 $ SUCCESSOR AGENCY FUNDS - 80-89
4065 Taxes/ROPS 11,834,201 9,365,723 8,964,690 9,734,354 4,682,401 4410 Interest Income 831,424 801,791 734,373 25,000 (10,630) 4412 Unrealized Gain/Loss on Invest 136,223 (165,695) (156,553) - 140,546 4420 Rents - - 9,912 - 32,069 4830 Miscellaneous - - 50 - - 4840 Bond Proceeds - - - - - 4842 Premium on Bond Sales 318,370 1,889,667 992,015 318,370 992,015 4843 Loan Repayment/Rehab&Seismic - (1) 283,697 - 69,623 4999 Revenue Allocation - - (283,697) - (69,623) Total Successor Agency Fund 13,120,219$ 11,891,485 $ 10,544,487 $ 10,077,724 $ 5,836,400 $ GRAND TOTAL REVENUES 222,555,228 $ 217,145,480 $ 244,904,097 $ 243,564,281 $ 144,835,883 $ * Due to timing of proper recording receipts and monthly entries of these revenues, December revenues for these funds are estimated based on FY 22-23 prior month receipts to date. A "true-up" for these funds will be provided at Q3 Report.