The URL can be used to link to this page

Home My WebLink About _ 4(d)--ACR133 Report and Cash Reconciliation - November & December 2022 and January 2023 CITY OF REDDING REPORT TO THE CITY COUNCIL Recommendation Accept City of Redding Proof of Cash reconciliation and ACR133 report for the months of November 2022, December 2022, and January 2023. Fiscal Impact There is no fiscal impact to accepting the report. Alternative Action The City Council could choose to not accept the Proof of Cash reconciliation and ACR133 report and provide alternate direction to staff. Background/Analysis The City Council has requested a monthly report on pooled cash. The ACR133 report summarizes, by fund, the month-to-date pooled cash balances and transactions. The Proof of Cash reconciles the ACR133 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. MEETING DATE: March 7, 2023 ITEM NO. 4(d) FROM: ***APPROVED BY*** grobinett@cityofredding.org btippin@cityofredding.org SUBJECT: 4(d)--ACR133 Report and Cash Reconciliation for the Month of November, December 2022 and January 2023. Greg Robinett, Director of Finance/City Treasurer Report to Redding City Council February 27, 2023 Re: 4(d)--ACR133 Report and Cash Reconciliation - November & December 2022 and January 2023 Page 2 Council Priority/City Manager Goals • This is a routine operational item. Attachments ^ACR133, Current Cash Balance November 2022 ^Proof of Cash November 2022 ^ACR133, Current Cash Balance December 2022 ^Proof of Cash December 2022 ^ACR133, Current Cash Balance January 2023 ^Proof of Cash January 2023 ACR133 CITY OF REDDING KINGSSYS 11:54:34 12/07/2022 GENERAL ACCOUNTING DATED 12/07/2022 CURRENT CASH BALANCE - CITY COUNCIL REPORT PAGE 1 ENDING BALANCE 11/30/2022 111 GENERAL FUND 19,189,753.92 120 ASSET SEIZURE FUND 36,956.00 121 ENT ANDERSON GROUNDWATER 358,116.64- 122 PARKING FUND 574,114.25 123 GENERAL SPECIAL REVENUE 127,065.50 124 IPSS SPECIAL REVENUE 1,193,213.90 125 ROLLING STOCK REPLACEMNT 11,705,039.61 126 SPECL GAS TAX ST IMPROVE 7,548,722.13 127 LOCAL TRANSPORTATION 3,482,763.08 128 DEVELOPMENT FUND 5,570,844.62 129 LIBRARY 165,422.15 130 BRANCH LIBRARIES 49,423.62 134 MUNICIPAL AIRPORT FUND 4,194,362.71- 140 TOURISM/CONVENTION FUND 444,030.16- 142 ELECTRIC UTILITY FUND 53,923,204.61 143 WATER UTILITY FUND 58,854,106.60 145 WASTEWATER UTILITY FUND 45,136,509.97 147 STORM DRAIN UTILITY FUND 7,514,906.14 148 WEST CENTRAL LANDFILL 11,594,847.94 149 SOLID WASTE COLLECTION 15,164,968.48 150 MEDIA, COMMS & PR 62,546.00 151 INFORMATION TECHNOLOGY 2,034,014.68 153 FLEET MAINTENANCE 150,142.99 154 BUILDING MAINT & CONSTR 1,314,259.81 158 RECORDS MANAGEMENT 96,590.57 160 EMPLOYER SERVICES 54,289.37- 162 RMU ADMINISTRATION 1,351,892.92 165 GEOGRAPHIC INFO SERVICES 594,185.91 166 COMMUNICATIONS 204,291.26 168 REPROGRAPHICS 73,871.51 169 VOLUNTEER SERVICES 20,290.92- 171 SPECIAL DEPOSITS FUND 10,054,556.02 172 RISK MANAGEMENT 7,550,912.67 173 EMPLOYEE BENEFITS P/R 1,892,507.77 174 EMPLOYEE BENEFIT GRP INS 894,494.45 175 GASB 45 TRUST FUND 39,434.96 178 CAPITAL PROJECTS FUND 4,617,564.58 191 CD BLOCK GRANT FUND 629,373.72 193 HOUSING AUTHORITY 109,265.30- 194 REDDING REDEVELOPMENT 9,383.07- 200 REDDING AREA BUS AUTHOR. 14,166.95- 230 LOW/MOD INC HOUS ASSET 628,010.48 300 SPECIAL ASSESSMENT DIST. 315,146.58 400 LANDSCAPE DISTRICTS 381,221.56 FINAL TOTAL 269,512,975.84 ACR133 11:54:34 12/07/2022 Sheet "D"November 2022 CITY OF REDDING PROOF OF CASH RECONCILIATION BETWEEN TREASURER'S REPORT AND ACR 133 As of November 2022 ACR133 TREASURER END OF MONTH BALANCE 269,512,975.84 268,430,714.10 LESS OUTSIDE MANAGED FUNDS (181.00) ACR133 Report CASH ACCOUNTS NOT ON ACR133 LIBRARY MERCHANT DEPOSIT 100.00 BAD CHECKS - PAYROLL TIMING DIFFERENCE (393,112.62) BANK CHARGES (111,757.46) WIRE TRANSFER TIMING DIFFERENCE OTHER ADJUSTMENTS (1,040,318.29) BANK DR/CR (462,845.63) TOTALS 267,967,787.47 267,967,787.47 ACR133 CITY OF REDDING KINGSSYS 13:12:14 1/09/2023 GENERAL ACCOUNTING DATED 1/09/2023 CURRENT CASH BALANCE - CITY COUNCIL REPORT PAGE 1 ENDING BALANCE 12/31/2022 111 GENERAL FUND 18,852,820.38 120 ASSET SEIZURE FUND 32,199.17 121 ENT ANDERSON GROUNDWATER 378,824.15- 122 PARKING FUND 492,244.85 123 GENERAL SPECIAL REVENUE 205,029.64 124 IPSS SPECIAL REVENUE 1,121,138.46 125 ROLLING STOCK REPLACEMNT 10,883,103.61 126 SPECL GAS TAX ST IMPROVE 6,922,835.80 127 LOCAL TRANSPORTATION 3,877,972.08 128 DEVELOPMENT FUND 2,828,789.09 129 LIBRARY 184,073.99 130 BRANCH LIBRARIES 49,052.60 134 MUNICIPAL AIRPORT FUND 4,418,140.43- 140 TOURISM/CONVENTION FUND 539,812.75- 142 ELECTRIC UTILITY FUND 55,328,591.51 143 WATER UTILITY FUND 59,763,746.01 145 WASTEWATER UTILITY FUND 45,983,351.05 147 STORM DRAIN UTILITY FUND 7,223,077.70 148 WEST CENTRAL LANDFILL 11,929,027.97 149 SOLID WASTE COLLECTION 15,130,133.21 150 MEDIA, COMMS & PR 69,948.75 151 INFORMATION TECHNOLOGY 2,080,985.02 153 FLEET MAINTENANCE 102,100.04 154 BUILDING MAINT & CONSTR 1,161,050.28 158 RECORDS MANAGEMENT 90,497.15 160 EMPLOYER SERVICES 76,515.14- 162 RMU ADMINISTRATION 1,400,591.45 165 GEOGRAPHIC INFO SERVICES 608,341.34 166 COMMUNICATIONS 221,115.04 168 REPROGRAPHICS 68,189.85 169 VOLUNTEER SERVICES 19,014.12- 171 SPECIAL DEPOSITS FUND 10,205,509.79 172 RISK MANAGEMENT 7,657,696.42 173 EMPLOYEE BENEFITS P/R 896,185.67 174 EMPLOYEE BENEFIT GRP INS 706,616.02 175 GASB 45 TRUST FUND 39,434.96 178 CAPITAL PROJECTS FUND 4,410,097.10 191 CD BLOCK GRANT FUND 2,779,465.91 193 HOUSING AUTHORITY 87,390.47- 194 REDDING REDEVELOPMENT 13,504.88- 200 REDDING AREA BUS AUTHOR. 82,928.66- 230 LOW/MOD INC HOUS ASSET 622,543.61 300 SPECIAL ASSESSMENT DIST. 314,660.72 400 LANDSCAPE DISTRICTS 298,686.97 FINAL TOTAL 268,924,772.61 ACR133 13:12:14 1/09/2023 Sheet "D"December 2022 CITY OF REDDING PROOF OF CASH RECONCILIATION BETWEEN TREASURER'S REPORT AND ACR 133 As of December 2022 ACR133 TREASURER END OF MONTH BALANCE 268,924,772.61 268,139,960.13 LESS OUTSIDE MANAGED FUNDS (588.20) ACR133 Report CASH ACCOUNTS NOT ON ACR133 LIBRARY MERCHANT DEPOSIT 300.00 BAD CHECKS - PAYROLL TIMING DIFFERENCE 5,134.14 BANK CHARGES (109,183.77) WIRE TRANSFER TIMING DIFFERENCE OTHER ADJUSTMENTS (1,134,569.00) BANK DR/CR (453,517.95) TOTALS 267,686,153.98 267,686,153.98 ACR133 CITY OF REDDING KINGSSYS 14:45:57 2/07/2023 GENERAL ACCOUNTING DATED 2/07/2023 CURRENT CASH BALANCE - CITY COUNCIL REPORT PAGE 1 ENDING BALANCE 1/31/2023 111 GENERAL FUND 30,358,096.76 120 ASSET SEIZURE FUND 21,425.50 121 ENT ANDERSON GROUNDWATER 72,229.81- 122 PARKING FUND 456,619.81 123 GENERAL SPECIAL REVENUE 270,976.92 124 IPSS SPECIAL REVENUE 1,114,668.52 125 ROLLING STOCK REPLACEMNT 10,745,597.79 126 SPECL GAS TAX ST IMPROVE 9,530,744.34 127 LOCAL TRANSPORTATION 4,273,181.08 128 DEVELOPMENT FUND 4,040,475.46 129 LIBRARY 936,916.77 130 BRANCH LIBRARIES 852,331.88 134 MUNICIPAL AIRPORT FUND 4,483,807.98- 140 TOURISM/CONVENTION FUND 623,765.69- 142 ELECTRIC UTILITY FUND 57,331,895.81 143 WATER UTILITY FUND 60,045,537.38 145 WASTEWATER UTILITY FUND 46,335,311.07 147 STORM DRAIN UTILITY FUND 7,922,597.87 148 WEST CENTRAL LANDFILL 11,440,943.20 149 SOLID WASTE COLLECTION 15,333,825.15 150 MEDIA, COMMS & PR 77,468.48 151 INFORMATION TECHNOLOGY 1,979,606.52 153 FLEET MAINTENANCE 67,622.30 154 BUILDING MAINT & CONSTR 1,120,664.36 158 RECORDS MANAGEMENT 87,545.78 160 EMPLOYER SERVICES 49,344.82- 162 RMU ADMINISTRATION 1,439,574.44 165 GEOGRAPHIC INFO SERVICES 621,245.54 166 COMMUNICATIONS 238,341.09 168 REPROGRAPHICS 69,050.48 169 VOLUNTEER SERVICES 17,843.37- 171 SPECIAL DEPOSITS FUND 10,380,342.11 172 RISK MANAGEMENT 7,792,366.79 173 EMPLOYEE BENEFITS P/R 226,715.62 174 EMPLOYEE BENEFIT GRP INS 478,709.60 175 GASB 45 TRUST FUND 39,508.73 178 CAPITAL PROJECTS FUND 4,407,088.48 191 CD BLOCK GRANT FUND 3,965,646.57 193 HOUSING AUTHORITY 102,311.93- 194 REDDING REDEVELOPMENT 18,877.53- 200 REDDING AREA BUS AUTHOR. 82,621.05- 230 LOW/MOD INC HOUS ASSET 736,415.60 300 SPECIAL ASSESSMENT DIST. 320,148.85 400 LANDSCAPE DISTRICTS 833,234.39 FINAL TOTAL 290,441,638.86 ACR133 14:45:57 2/07/2023 Sheet "D"January 2023 CITY OF REDDING PROOF OF CASH RECONCILIATION BETWEEN TREASURER'S REPORT AND ACR 133 As of January 2023 ACR133 TREASURER END OF MONTH BALANCE 290,441,638.86 289,814,774.86 LESS OUTSIDE MANAGED FUNDS (300.00) ACR133 Report CASH ACCOUNTS NOT ON ACR133 LIBRARY MERCHANT DEPOSIT 300.00 BAD CHECKS 158.00 PAYROLL TIMING DIFFERENCE 5,134.14 BANK CHARGES (76,862.53) WIRE TRANSFER TIMING DIFFERENCE OTHER ADJUSTMENTS (1,055,868.30) BANK DR/CR (500,890.69) TOTALS 289,314,042.17 289,314,042.17