HomeMy WebLinkAbout _ 4(d)--ACR133 Report and Cash Reconciliation - May 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 May
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 May 2023
^Proof of Cash May 2023
MEETING DATE: July 18, 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 May 2023.
Greg Robinett, Director of
Finance/City Treasurer
ACR133 CITY OF REDDING KINGSSYS 14:14:20 6/07/2023
GENERAL ACCOUNTING DATED 6/07/2023
CURRENT CASH BALANCE - CITY COUNCIL REPORT PAGE 1
ENDING
BALANCE
5/31/2023
111 GENERAL FUND 27,094,784.00
120 ASSET SEIZURE FUND 27,298.21
121 ENT ANDERSON GROUNDWATER 72,229.81-
122 PARKING FUND 252,256.01
123 GENERAL SPECIAL REVENUE 272,517.00
124 IPSS SPECIAL REVENUE 1,033,286.50
125 ROLLING STOCK REPLACEMNT 10,086,103.15
126 SPECL GAS TAX ST IMPROVE 10,788,358.56
127 LOCAL TRANSPORTATION 5,966,017.08
128 DEVELOPMENT FUND 5,005,776.18
129 LIBRARY 449,367.39
130 BRANCH LIBRARIES 842,054.01
134 MUNICIPAL AIRPORT FUND 5,923,364.52-
140 TOURISM/CONVENTION FUND 978,891.64-
142 ELECTRIC UTILITY FUND 47,451,760.07
143 WATER UTILITY FUND 58,416,857.03
145 WASTEWATER UTILITY FUND 43,174,050.59
147 STORM DRAIN UTILITY FUND 7,664,601.90
148 WEST CENTRAL LANDFILL 10,993,286.34
149 SOLID WASTE COLLECTION 15,402,786.79
150 MEDIA, COMMS & PR 69,524.25
151 INFORMATION TECHNOLOGY 2,967,777.40
153 FLEET MAINTENANCE 266,597.12-
154 BUILDING MAINT & CONSTR 944,116.91
158 RECORDS MANAGEMENT 28,769.14
160 EMPLOYER SERVICES 213,279.07
162 RMU ADMINISTRATION 1,299,806.48
165 GEOGRAPHIC INFO SERVICES 566,796.46
166 COMMUNICATIONS 263,844.08
168 REPROGRAPHICS 59,223.99
169 VOLUNTEER SERVICES 17,269.87-
171 SPECIAL DEPOSITS FUND 10,757,831.28
172 RISK MANAGEMENT 8,797,298.27
173 EMPLOYEE BENEFITS P/R 375,412.20
174 EMPLOYEE BENEFIT GRP INS 2,908,851.22
175 GASB 45 TRUST FUND 39,807.84
178 CAPITAL PROJECTS FUND 4,019,828.54
191 CD BLOCK GRANT FUND 4,061,278.88
193 HOUSING AUTHORITY 102,987.21-
194 REDDING REDEVELOPMENT 64,438.20
200 REDDING AREA BUS AUTHOR. 91,156.23-
230 LOW/MOD INC HOUS ASSET 708,287.52
300 SPECIAL ASSESSMENT DIST. 323,788.78
400 LANDSCAPE DISTRICTS 934,956.67
FINAL TOTAL 276,873,581.59
ACR133 14:14:20 6/07/2023
Sheet "D"May 2023
CITY OF REDDING
PROOF OF CASH
RECONCILIATION BETWEEN TREASURER'S REPORT AND ACR 133
As of May 2023
ACR133 TREASURER
END OF MONTH BALANCE 276,873,581.59 276,031,424.59
LESS OUTSIDE MANAGED FUNDS (300.00)
ACR133 Report
CASH ACCOUNTS NOT ON ACR133
LIBRARY MERCHANT DEPOSIT 300.00
BAD CHECKS -
PAYROLL TIMING DIFFERENCE (390,200.85)
BANK CHARGES (85,914.24)
WIRE TRANSFER TIMING DIFFERENCE
OTHER ADJUSTMENTS (832,636.87)
BANK DR/CR (466,594.96)
TOTALS 275,564,829.63 275,564,829.63