HomeMy WebLinkAbout _ 4(d)--ACR133 Report and Cash Reconciliation - April 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 April
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 April 2023
^Proof of Cash April 2023
MEETING DATE: June 6, 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 April 2023.
Greg Robinett, Director of
Finance/City Treasurer
ACR133 CITY OF REDDING KINGSSYS 13:23:31 5/11/2023
GENERAL ACCOUNTING DATED 5/11/2023
CURRENT CASH BALANCE - CITY COUNCIL REPORT PAGE 1
ENDING
BALANCE
4/30/2023
111 GENERAL FUND 18,780,889.33
120 ASSET SEIZURE FUND 21,556.85
121 ENT ANDERSON GROUNDWATER 72,229.81-
122 PARKING FUND 365,022.43
123 GENERAL SPECIAL REVENUE 272,517.00
124 IPSS SPECIAL REVENUE 879,399.41
125 ROLLING STOCK REPLACEMNT 10,008,147.15
126 SPECL GAS TAX ST IMPROVE 10,467,637.30
127 LOCAL TRANSPORTATION 5,458,808.08
128 DEVELOPMENT FUND 3,428,428.70
129 LIBRARY 644,100.23
130 BRANCH LIBRARIES 854,048.59
134 MUNICIPAL AIRPORT FUND 5,307,431.35-
140 TOURISM/CONVENTION FUND 888,162.58-
142 ELECTRIC UTILITY FUND 55,620,080.57
143 WATER UTILITY FUND 58,999,486.18
145 WASTEWATER UTILITY FUND 48,040,724.96
147 STORM DRAIN UTILITY FUND 7,559,567.79
148 WEST CENTRAL LANDFILL 10,601,591.17
149 SOLID WASTE COLLECTION 15,264,320.89
150 MEDIA, COMMS & PR 71,091.92
151 INFORMATION TECHNOLOGY 2,812,578.50
153 FLEET MAINTENANCE 191,593.32-
154 BUILDING MAINT & CONSTR 972,456.50
158 RECORDS MANAGEMENT 29,055.51
160 EMPLOYER SERVICES 144,486.25
162 RMU ADMINISTRATION 1,267,448.96
165 GEOGRAPHIC INFO SERVICES 564,477.54
166 COMMUNICATIONS 246,342.08
168 REPROGRAPHICS 54,284.82
169 VOLUNTEER SERVICES 18,339.80-
171 SPECIAL DEPOSITS FUND 10,693,598.69
172 RISK MANAGEMENT 8,504,099.18
173 EMPLOYEE BENEFITS P/R 1,349,753.26
174 EMPLOYEE BENEFIT GRP INS 3,085,897.05
175 GASB 45 TRUST FUND 39,729.22
178 CAPITAL PROJECTS FUND 4,147,059.25
191 CD BLOCK GRANT FUND 4,672,527.79
193 HOUSING AUTHORITY 174,951.30-
194 REDDING REDEVELOPMENT 69,554.55
200 REDDING AREA BUS AUTHOR. 72,885.88-
230 LOW/MOD INC HOUS ASSET 624,473.35
300 SPECIAL ASSESSMENT DIST. 320,270.64
400 LANDSCAPE DISTRICTS 571,862.56
FINAL TOTAL 280,781,780.21
ACR133 13:23:31 5/11/2023
Sheet "D"April 2023
CITY OF REDDING
PROOF OF CASH
RECONCILIATION BETWEEN TREASURER'S REPORT AND ACR 133
As of April 2023
ACR133 TREASURER
END OF MONTH BALANCE 280,781,780.21 283,912,693.84
LESS OUTSIDE MANAGED FUNDS (566.51)
ACR133 Report
CASH ACCOUNTS NOT ON ACR133
LIBRARY MERCHANT DEPOSIT 300.00
BAD CHECKS -
PAYROLL TIMING DIFFERENCE 3,617,996.99
BANK CHARGES (82,063.12)
WIRE TRANSFER TIMING DIFFERENCE
OTHER ADJUSTMENTS (730,925.35)
BANK DR/CR (325,638.60)
TOTALS 283,586,788.73 283,586,788.73