Loading...
HomeMy WebLinkAbout _ 4(d)--ACR133 Report and Cash Reconciliation - March 2023 CITY OF REDDING REPORT TO THE CITY COUNCIL Recommendation Accept City of Redding Proof of Cash reconciliation and ACR133 report for the month of March 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. Council Priority/City Manager Goals • This is a routine operational item. Attachments ^ACR133, Current Cash Balance March 2023 ^Proof of Cash March 2023 MEETING DATE: May 2, 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 March 2023. Greg Robinett, Director of Finance/City Treasurer ACR133 CITY OF REDDING KINGSSYS 10:41:08 4/06/2023 GENERAL ACCOUNTING DATED 4/06/2023 CURRENT CASH BALANCE - CITY COUNCIL REPORT PAGE 1 ENDING BALANCE 3/31/2023 111 GENERAL FUND 22,882,697.35 120 ASSET SEIZURE FUND 21,522.47 121 ENT ANDERSON GROUNDWATER 72,229.81- 122 PARKING FUND 393,872.16 123 GENERAL SPECIAL REVENUE 272,517.00 124 IPSS SPECIAL REVENUE 965,888.85 125 ROLLING STOCK REPLACEMNT 10,769,571.73 126 SPECL GAS TAX ST IMPROVE 10,105,016.67 127 LOCAL TRANSPORTATION 5,063,599.08 128 DEVELOPMENT FUND 4,095,183.21 129 LIBRARY 731,328.53 130 BRANCH LIBRARIES 853,825.41 134 MUNICIPAL AIRPORT FUND 5,094,154.78- 140 TOURISM/CONVENTION FUND 786,581.49- 142 ELECTRIC UTILITY FUND 57,242,627.36 143 WATER UTILITY FUND 59,508,895.89 145 WASTEWATER UTILITY FUND 47,322,815.28 147 STORM DRAIN UTILITY FUND 7,558,555.99 148 WEST CENTRAL LANDFILL 12,021,157.78 149 SOLID WASTE COLLECTION 15,507,489.94 150 MEDIA, COMMS & PR 89,176.19 151 INFORMATION TECHNOLOGY 2,879,475.19 153 FLEET MAINTENANCE 194,304.33- 154 BUILDING MAINT & CONSTR 1,027,397.36 158 RECORDS MANAGEMENT 43,828.00 160 EMPLOYER SERVICES 135,203.92 162 RMU ADMINISTRATION 1,416,534.18 165 GEOGRAPHIC INFO SERVICES 579,632.27 166 COMMUNICATIONS 234,974.41 168 REPROGRAPHICS 73,938.50 169 VOLUNTEER SERVICES 14,655.77- 171 SPECIAL DEPOSITS FUND 10,654,679.76 172 RISK MANAGEMENT 8,082,119.38 173 EMPLOYEE BENEFITS P/R 144,387.45 174 EMPLOYEE BENEFIT GRP INS 2,029,463.94 175 GASB 45 TRUST FUND 39,665.89 178 CAPITAL PROJECTS FUND 4,255,835.46 191 CD BLOCK GRANT FUND 2,973,868.18 193 HOUSING AUTHORITY 119,859.65- 194 REDDING REDEVELOPMENT 77,908.11 200 REDDING AREA BUS AUTHOR. 52,100.45- 230 LOW/MOD INC HOUS ASSET 681,914.16 300 SPECIAL ASSESSMENT DIST. 320,498.55 400 LANDSCAPE DISTRICTS 691,953.65 FINAL TOTAL 285,415,132.97 ACR133 10:41:08 4/06/2023 Sheet "D"March 2023 CITY OF REDDING PROOF OF CASH RECONCILIATION BETWEEN TREASURER'S REPORT AND ACR 133 As of March 2023 ACR133 TREASURER END OF MONTH BALANCE 285,415,132.97 284,855,776.37 LESS OUTSIDE MANAGED FUNDS (519.46) ACR133 Report CASH ACCOUNTS NOT ON ACR133 LIBRARY MERCHANT DEPOSIT 300.00 BAD CHECKS - PAYROLL TIMING DIFFERENCE 83.28 BANK CHARGES (65,423.42) WIRE TRANSFER TIMING DIFFERENCE OTHER ADJUSTMENTS (697,091.03) BANK DR/CR (202,855.11) TOTALS 284,652,701.80 284,652,701.80