Loading...
HomeMy WebLinkAbout _ 4(e)--Proof of Cash and Cash by Fund Report - July, August & September 2025 GI �" Y C� F � � �- ' � ° � � i � CITY OF REDDING �� REPORT TO THE CITY COUNCIL MEETING DATE: November 18, 2025 FROM: Greg Robinett, Director of ITEM NO. 4(e) Finance/City Treasurer ***APPROVED BY*** �� �� �` � i��* c3 a t,I3 � tt�e �^ins�nci,'Catyr`�'ri�sure,r l l,'13r2�)25 t�S�B c1 �, I1t � ' �C/��r/�Q�v,`+ grobinett@cityofredding.org sbade@cityofredding.org SUBJECT: 4(e)--Proof of Cash and Cash by Fund Report-J�uly, August, & September 2025 Recommendation Accept City of Redding Proof of Cash and Cash by Fund reports for the months of July, August, and September 2025. Fiscal Impact There is no �scal impact to accepting the report. AZteNnative Action The City Council could choose to not accept the Proof of Cash reconciliation and Cash by Fund report and provide alternate direction to staff. Background/Analysis The City Council has reguested a monthly report on pooled cash. The Cash by Fund report summarizes, by fund, the month-to-date pooled cash balances and transactions. The Proof of Cash reconciles the Cash by Fund report to the Treasurer's monthly report. Environmental Review This is not a project defined under the California Environmental Quality Act, and no further action is required. Council Priority/City Manager Goals � This is a routine operational item. Attachments ^07 2025 Cash by Fund ^0'7 2025 Proof of Cash Report to Redding City Council November 13,2025 Re: 4(e)--Proof of Cash and Cash by Fund Report-July,August&September 2025 Page 2 ^08 2025 Cash by Fund ^08 2025 Proof of Cash ^09 2025 Cash by Fund ^09 2025 Proof of Cash Cash by Fund City of Redding luly 2025 Fund Fund Description Ending Balance 101 101-General Fund 1,463,317.59 102 102-Grants General Fund 4,674,241.96 103 103-Capital Projects General Fund 2,994,038.81 151 151-Development/Construction Fund 15,122,966.61 152 152-Development/Construction Grants Fund (2,485,790.48) 161 161-General Special Revenue 0.00 165 165-Asset Seizure Fund 168,813.80 171 171-Special Gas Tax Street Improvements 5,182,326.04 172 172-�ocal Transportation/TDA 7,588,810.20 175 175-Parking Fund (36,289.86) 181 181-�ibrary 1,464,257.05 182 182-Branch Libraries 778,331.64 191 191-Housing&Community Development Fund 11,630,052.32 192 192-Norcal Continuum of Care(CoC) 4,429,843.75 195 195-Successor Housing Agency Fund 684,367.58 196 196-Redding Housing Authority (149,382.44) 201 201-Airports (5,583.59) 206 206-Convention Center 198,943.93 211 211-Electric Utility Fund 55,920,048.37 221 221-Water Utility Fund 52,175,729.53 231 231-Wastewater Utility Fund 41,611,832.97 241 241-Storm Drain Utility Fund 6,465,404.83 251 251-Solid Waste Utility Fund 7,896,560.29 255 255-West Central Landfill 9,119,561.78 291 291-Redding Area Bus Authority (546,575.30) 311 311-information Technologies 1,223,686.16 315 315-Geographic Information Services 91,828.78 317 317-Communications-Radios 316,811.46 321 321-Electrical Technicians&USA Locates 1,665,658J7 325 325-Redding Municipal Utilities Administration 49,540.10 331 331-Public Relations,Media,&Communications 217,292.43 335 335-Building Maintenance 1,050,571.05 341 341-Records Management (174,573.58) 345 345-Reprographics 333,730.26 351 351-Fleet Maintenance (343,831.85) 361 361-Customer Service 1,191,304.03 365 365-Field Service (31,927.30) 381 381-Risk-Liability/Insurance 3,611,795.85 383 383-Risk-Workers Compensation 3,176,402.41 391 391-Employer Services 558,350.52 393 393-Volunteer Services (85,316.40) 398 398-Employee Benefits Payroli 4,573,381.66 399 399-Employee Benefits Insurance 2,719,770.57 401 401-Special Deposits Fund 6,716,244.14 411 411-Integrated Public Safety(IPS)Fund 1,557,642.16 421 421-EAGSA(Enterprise Anderson Groundwater Sustainability Agency) 164,656.70 431 431-GASB 45 Trust Fund 42,340.40 441 441-RORF-CHC Capital Project (0.00) 443 443-RORF-Market Street Capital (0.00) 444 444-RORF-SHASTEC Capital Project 261,020.28 451 451-Tierra Oaks 1993-1 13,292.83 452 452-Refinanced A/D 1997-1 - 453 453-Teton Drive 1998-1 1,830.91 Cash by Fund City of Redding luly 2025 Fund Fund Description Ending Balance 501 501-�MD A#80089 8,741.93 502 502-LMD B#80090 (20,579.16) 503 503-�MD C#80091 (207.08) 504 504-LMD D#80120 17,291.39 505 505-�MD E#80118 9,478.24 506 506-LMD F#80120 5,338.58 507 507-�MD G#80121 11,576J7 508 508-LMD H#80135 30,631.81 509 509-�MD 1-06 15,053.28 510 510-LMD J#80122 3,123.54 511 511-�MD K#80136 3,046.12 512 512-LMD L#80123 4,194.75 513 513-�MD M#80124 11,750.38 514 514-LMD N#80125 6,369.84 515 515-�MD 0#80126 (4,723.64) 516 516-�MD P#80127 4,117.67 517 517-�MD Q#80128 10,797.07 518 518-LMD R#80129 2,817.71 519 519-�MD 5#80130 17,471.49 520 520-�MD T#80131 4,506.59 521 521-�MD U#80137 5,905.15 522 522-LMD V#80132 13,542.32 523 523-�MD 2-06#80134 1,252.59 524 524-LMD 3-06#80139 11,039.93 525 525-�MD 4-06#80140 13,068.97 526 526-�MD W#80133 4,339.79 527 527-�MD 5-06#80141 (256J4) 528 528-LMD#1 1992#80087 (6.84) 529 529-�MD 6-06#80142 10,348.02 530 530-�MD 7-06#80145 1,626.28 531 531-�MD 8-06#80146 431,839.43 532 532-LMD 9-06#80143 3,919.08 533 533-�MD 10-06 - 534 534-LMD 11-06#80148 5,321.71 535 535-�MD 01-07#80149 2,866.09 536 536-SANITARY SEWER MAINT DIST 01-07#80150 46,143.02 537 537-�MD 02-07#80151 11,180.61 539 539-LMD ADMIN FRMLYL 02-09#Holding Acct (61,833.44) 540 540-�MD 03-09#80156 174,534.64 541 541-LMD PLACER WEST 02-09#80155 8,090.02 543 543-�MD RIVER RIDGE#80157 39,776.24 544 544-LMD RIVER PARK#80158 20,894.00 545 545-�MD RIVER HEIGHTS#80159 36,677.51 547 547-LMD LANCER HILLS 02-12 (120A2) 548 548-�MD WESTERN HIGH�AND 03-12 (550.26) 549 549-�MD COLLEGE HIGHLAND 01-13#80160 31,840.65 550 550-�MD WESTSIDE 02-14#80163 47,871.24 551 551-LMD HIDDEN HILLS 01-15#80162 16,797.05 552 552-�MD BROWNING POINTE 03-14#80165 (2,130.90) 553 553-�MD SHASTAVIEW SW 02-16#80164 35,328.50 554 554-�MD RIVER POINTE 03-16#80166 11,392.46 555 555-LMD SALT CREEK HEIGHTS 01-07#80167 133,421.99 556 556-�MD SEVEN BRIDGES 01-19#80168 23,408.12 Cash by Fund City of Redding luly 2025 Fund Fund Description Ending Balance 557 557-�MD SEVEN BRIDGES SSMD 01-19#80169 5,566.85 558 558-LMD CENTER COURT 02-19#80170 24,410.68 559 559-�MD WYNDHAM POINT#80171 64,904.21 560 560-�MD RANCHO RD 07-19 - 561 561-�MD Luke Estates 01-22 76.64 951 951-Rolling Stock Fund 12,168,826.79 952 952-Equipment Replacement Fund 3,053,395.02 953 953-Technology Replacement Fund 85,802.37 954 954-Major Maintenance Fund 6,212,217.82 999 999-Cash Transfer Fund - 278,080,854.59 CITY OF REDDING PROOF OF CASH RECONCILIATION BETWEEN TREASURER'S REPORT AND GENERAL LEDGER AS OF JULY 2025 ORACLE TREASURER REPORT END OF MONTH BA�ANCE 278,080,854.59 305,857,539.02 Timing Differences 27,775,728.79 Library(Outstide Managed Funds) (955.64) TOTA�S 305,856,583.38 305,856,583.38 Cash by Fund City of Redding August 2025 Fund Fund Description Ending Balance 101 101-General Fund (1,887,336.18) 102 102-Grants General Fund 4,845,283.52 103 103-Capital Projects General Fund 2,992,576.39 151 151-Development/Construction Fund 14,154,544.73 152 152-Development/Construction Grants Fund (2,562,241.99) 161 161-General Special Revenue 0.00 165 165-Asset Seizure Fund 168,813.80 171 171-Special Gas Tax Street Improvements 5,629,900.85 172 172-Loca)Transportation/TDA 7,983,329.20 175 175-Parking Fund (68,319.22) 181 181-Li bra ry 995,174.78 182 182-Branch�ibraries 740,640.49 191 191-Housing&Community Development Fund 10,439,582.36 192 192-Norcal Continuum of Care(CoC) 4,414,540.60 195 195-Successor Housing Agency Fund 677,895.61 196 196-Redding Housing Authority (750,448.27) 201 201-Airports (765,597.03) 206 206-Convention Center 51,444.83 211 211-Electric Utility Fund 56,070,867.50 221 221-Water Utility Fund 54,819,218.09 231 231-Wastewater Utility Fund 40,283,064.09 241 241-Storm Drain Utility Fund 5,813,921.56 251 251-Solid Waste Utility Fund 7,947,265.53 255 255-West Centra) Landfill 9,551,903.87 291 291-Redding Area Bus Authority (709,046.66) 311 311-Information Technologies 762,285.08 315 315-Geographic Information Services 65,554.44 317 317-Communications-Radios 359,820.79 321 321-Electrical Technicians&USA Locates 1,695,250.20 325 325-Redding Municipa)Utilities Administration 94,538.73 331 331-Public Relations,Media,&Communications 217,250.13 335 335-Building Maintenance 992,620.50 341 341-Records Management (299,975.13) 345 345-Reprographics 335,897.83 351 351-Fleet Maintenance (424,801.97) 361 361-Customer Service 1,905,293.35 365 365-Field Service (35,685.11) 381 381-Risk-Liability/Insurance (726,353.33) 383 383-Risk-Workers Compensation 3,488,294.52 391 391-Employer Services 547,877.01 393 393-Volunteer Services (83,927.32) 398 398-Employee Benefits Payroll 9,177,386.95 399 399-Employee Benefits Insurance 5,843,371.04 401 401-Special Deposits Fund 7,611,601.31 411 411-Integrated Public Safety(IPS)Fund 1,519,122.45 421 421-EAGSA(Enterprise Anderson Groundwater Sustainability Agency) (97,894.42) 431 431-GASB 45 Trust Fund 42,340.40 441 441-RORF-CHC Capital Project (0.00) 443 443-RORF-Market Street Capital (0.00) Cash by Fund City of Redding August 2025 Fund Fund Description Ending Balance 444 444-RORF-SHASTEC Capital Project (356,351.47) 451 451-Tierra Oaks 1993-1 13,292.83 452 452-Refinanced A/D 1997-1 - 453 453-Teton Drive 1998-1 1,830.91 501 501-LMD A#80089 8,708.26 502 502-LMD B#80090 (26,124.02) 503 503-LMD C#80091 (240.74) 504 504-LMD D#80120 17,155.29 505 505-LMD E#80118 9,358.63 506 506-LMD F#80120 5,165.60 507 507-LMD G#80121 11,185.41 508 508-LMD H#80135 29,761.91 509 509-LMD 1-06 14,659.51 510 510-LMD J#80122 2,152.63 511 511-LMD K#80136 2,983.04 512 512-LMD L#80123 3,902.97 513 513-LMD M#80124 10,769.47 514 514-LMD N#80125 5,891.43 515 515-LMD 0#80126 (5,085.66) 516 516-LMD P#80127 4,084.31 517 517-LMD Q#80128 10,402.02 518 518-LMD R#80129 2,814.07 519 519-LMD S#80130 17,180.61 520 520-LMD T#80131 4,343.23 521 521-LMD U#80137 5,901.51 522 522-LMD V#80132 13,046.71 523 523-LMD 2-06#80134 1,248.95 524 524-LMD 3-06#80139 10,888.79 525 525-LMD 4-06#80140 12,480.53 526 526-LMD W#80133 4,189.35 527 527-LMD 5-06#80141 (260.38) 528 528-LMD#1 1992#80087 (6.84) 529 529-LMD 6-06#80142 9,744.70 530 530-LMD 7-06#80145 1,460.01 531 531-LMD 8-06#80146 429,595.31 532 532-LMD 9-06#80143 3,441.72 533 533-LMD 10-06 - 534 534-LMD 11-06#80148 5,318.07 535 535-LMD 01-07#80149 2,664.73 536 536-SANITARY SEWER MAINT DIST 01-07#80150 46,019.46 537 537-LMD 02-07#80151 11,176.97 539 539-LMD ADMIN FRM�YL 02-09#Holding Acct (64,332.90) 540 540-LMD 03-09#80156 163,252.59 541 541-LMD P�ACER WEST 02-09#80155 7,968.66 543 543-LMD RIVER RIDGE#80157 38,786.47 544 544-LMD RIVER PARK#80158 20,486.39 545 545-LMD RIVER HEIGHTS#80159 35,918.29 547 547-LMD LANCER HIL�S 02-12 (120A2) 548 548-LMD WESTERN HIGHLAND 03-12 (550.26) Cash by Fund City of Redding August 2025 Fund Fund Description Ending Balance 549 549-LMD COLLEGE HIGHLAND 01-13#80160 31,498.48 550 550-LMD WESTSIDE 02-14#80163 47,353.97 551 551-LMD HIDDEN HILLS 01-15#80162 16,609.18 552 552-LMD BROWNING POINTE 03-14#80165 (2,212.26) 553 553-LMD SHASTAVIEW SW 02-16#80164 34,964.92 554 554-LMD RIVER POINTE 03-16#80166 11,232.58 555 555-LMD SALT CREEK HEIGHTS 01-07#80167 125,741.73 556 556-LMD SEVEN BRIDGES 01-19#80168 23,046.77 557 557-LMD SEVEN BRIDGES SSMD 01-19#80169 (5,867.08) 558 558-LMD CENTER COURT 02-19#80170 24,125.88 559 559-LMD WYNDHAM POINT#80171 64,686.85 560 560-LMD RANCHO RD 07-19 - 561 561-LMD Luke Estates 01-22 5.90 951 951-Rolling Stock Fund 12,168,326.79 952 952-Equipment Replacement Fund 3,035,195.02 953 953-Technology Replacement Fund 85,802.37 954 954-Major Maintenance Fund 6,212,217.82 999 999-Cash Transfer Fund - 276,245,733.87 CITY OF REDDING PROOF OF CASH RECONCILIATION BETWEEN TREASURER'S REPORT AND GENERAL LEDGER AS OF AUGUST 2025 ORACLE TREASURER REPORT END OF MONTH BA�ANCE 276,245,733.87 278,667,869.83 Timing Differences 2,420,648.18 Library(Outstide Managed Funds) (1,487.78) TOTA�S 278,666,382.05 278,666,382.05 Cash by Fund City of Redding September 2025 Fund Fund Description Ending Balance 101 101-General Fund (3,351,029.90) 102 102-Grants GeneralFund 4,829,173.67 103 103-Capital Projects General Fund 2,991,178.19 151 151-Development/Construction Fund 14,652,151.45 152 152-Development/Construction Grants Fund (2,582,003.98) 161 161-General Special Revenue 0.00 165 165-AssetSeizureFund 168,813.80 171 171-Specia)Gas Tax Street Improvements 5,127,220.60 172 172-Local Transportation/TDA 7,409,898.20 175 175-ParkingFund (119,601.44) 181 181-Library 762,494.75 182 182-Branch�ibraries 756,329.14 191 191-Housing&Community Development Fund 10,195,360.21 192 192-Norcal Continuum of Care(CoC) 4,149,446.36 195 195-SuccessorHousing AgencyFund 675,725.10 196 196-Redding Housing Authority (900,091.40) 201 201-Ai rports (1,434,802.11) 206 206-Convention Center 667,950.20 211 211-Electric Utility Fund 60,338,107.06 221 221-Water Utility Fund 55,714,098.46 231 231-Wastewater Utility Fund 41,501,662.48 241 241-Storm Drain Utility Fund 3,792,857.93 251 251-Solid Waste Utility Fund 8,905,636.57 255 255-West Central Landfill 9,678,630.90 291 291-Redding Area Bus Authority (496,226.90) 311 311-Information Technologies 296,058.97 315 315-Geographic Information Services 70,195.38 317 317-Communications-Radios 304,852.31 321 321-Electrical Technicians&USA Locates 1,767,815.31 325 325-Redding Municipal Utilities Administration 153,620.48 331 331-Public Relations,Media,&Communications 227,638.52 335 335-Building Maintenance 963,461.60 341 341-Records Management (275,221.37) 345 345-Reprographics 327,521.32 351 351-Fleet Maintenance (402,004.06) 361 361-Customer Service 2,574,470.34 365 365-Field Service (22,723.04) 381 381-Risk-�iability/Insurance (581,376.56) 383 383-Risk-Workers Compensation 3,529,797.60 391 391-Employer Services 516,807.57 393 393-VolunteerServices (83,108.54) 398 398-Employee Benefits Payroil 11,714,722.99 399 399-Employee Benefits Insurance 2,554,942.45 401 401-Specia)Deposits Fund 7,740,997.40 411 411-integrated Public Safety(IPS)Fund 1,488,245.22 421 421-EAGSA(Enterprise Anderson Groundwater Sustainability Agency) (99,040.47) 431 431-GASB 45 Trust Fund 42,340.40 441 441-RORF-CHC Capital Project (0.00) 443 443-RORF-Market Street Capitai (0.00} 444 444-RORF-SHASTEC Capital Project (356,351.47) 451 451-Tierra Oaks 1993-1 13,292.83 452 452-Refinanced A/D 1997-1 - Cash by Fund City of Redding September 2025 Fund Fund Description Ending Balance 453 453-Teton Drive 1998-1 1,830.91 501 501-�MD A#80089 8,564.26 502 502-LMD B#80090 (36,056.84) 503 503-�MD C#80091 (240.74) 504 504-LMD D#80120 15,961.83 505 505-�MD E#80118 8,841.66 506 506-LMD F#80120 4,835.65 507 507-�MD G#80121 10,408.34 508 508-LMD H#80135 27,226.47 509 509-�MD 1-06 13,738.19 510 510-LMD 1#80122 (2,298.49) 511 511-�MD K#80136 2,639.60 512 512-LMD L#80123 3,160.17 513 513-�MD M#80124 9,244.52 514 514-LMD N#80125 5,133.33 515 515-�MD O#80126 (5,993.21) 516 516-LMD P#80127 3,864.59 517 517-�MDQ#80128 9,611.61 518 518-LMD R#80129 2,446.35 519 519-�MD S#80130 16,370.17 520 520-LMD T#80131 3,866.51 521 521-�MD U#80137 5,901.51 522 522-LMD V#80132 12,007.74 523 523-�MD 2-06#80134 1,161.95 524 524-LMD 3-06#80139 10,539.79 525 525-�MD 4-06#80140 10,485.40 526 526-LMD W#80133 3,778.02 527 527-�MD 5-06#80141 (260.38) 528 528-LMD#1 1992#80087 (6.84} 529 529-�MD 6-06#80142 8,664.02 530 530-LMD 7-06#80145 969.55 531 531-�MD 8-06#80146 421,629.29 532 532-LMD 9-06#80143 2,706.00 533 533-�MD 10-06 - 534 534-LMD 11-06#80148 5,318.07 535 535-�MD 01-07#80149 2,495.01 536 536-SANITARY SEWER MAINT DIST 01-07#80150 45,539.65 537 537-�MD 02-07#80151 11,176.97 539 539-LMD ADMIN FRMLYL 02-09#Holding Acct (64,440.85) 540 540-�MD 03-09#80156 154,461.64 541 541-LMD PLACER WEST 02-09#80155 7,608.94 543 543-�MD RIVER RIDGE#80157 36,729.34 544 544-LMD RIVER PARK#80158 19,361.48 545 545-�MD RIVER HEIGHTS#80159 34,349.35 547 547-LMD LANCER HILLS 02-12 (120.02) 548 548-�MD WESTERN HIGHLAND 03-12 (550.26) 549 549-LMD COLLEGE HIGHLAND 01-13#80160 30,236.99 550 550-�MD WESTSIDE 02-14#80163 45,166.62 551 551-LMD HIDDEN HILLS 01-15#80162 16,321.52 552 552-�MD BROWNING POINTE 03-14#80165 (2,651.48) 553 553-LMD SHASTAVIEW SW 02-16#80164 34,380.98 554 554-�MD RIVER POINTE 03-16#80166 10,779.44 Cash by Fund City of Redding September 2025 Fund Fund Description Ending Balance 555 555-LMD SALT CREEK HEIGHTS 01-07#80167 117,773.53 556 556-�MD SEVEN BRIDGES 01-19#80168 19,640.27 557 557-LMD SEVEN BRIDGES SSMD 01-19#80169 (6,060.95) 558 558-�MD CENTER COURT 02-19#80170 23,501.72 559 559-LMD WYNDHAM POINT#80171 62,682.13 560 560-�MD RANCHO RD 07-19 - 561 561-LMD Luke Estates 01-22 (310.76) 951 951-Rolling Stock Fund 12,171,626.79 952 952-Equipment Replacement Fund 2,359,745.02 953 953-Technology Replacement Fund 85,802.37 954 954-Major Maintenance Fund 6,212,217.82 999 999-Cash Transfer Fund - 277,913,446J8 CITY OF REDDING PROOF OF CASH RECONCILIATION BETWEEN TREASURER'S REPORT AND GENERAL LEDGER AS OF SEPTEMBER 2025 ORACLE TREASURER REPORT END OF MONTH BA�ANCE 277,913,446.78 278,937,441.02 Timing Differences 1,023,853.88 Library(Outstide Managed Funds) (140.36) TOTA�S 278,937,300.66 278,937,300.66