HomeMy WebLinkAbout _ 4(d)--ACR133 Report and Cash Reconciliation - June 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 June
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 June 2023
^Proof of Cash June 2023
MEETING DATE: September 5, 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 June 2023.
Greg Robinett, Director of
Finance/City Treasurer
ACR133 CITY OF REDDING KINGSSYS 10:14:43 8/02/2023
GENERAL ACCOUNTING DATED 8/02/2023
CURRENT CASH BALANCE - CITY COUNCIL REPORT PAGE 1
ENDING
BALANCE
6/30/2023
111 GENERAL FUND 24,879,005.68
120 ASSET SEIZURE FUND 14,346.44
121 ENT ANDERSON GROUNDWATER 39,225.74
122 PARKING FUND 250,850.34
123 GENERAL SPECIAL REVENUE 272,517.00
124 IPSS SPECIAL REVENUE 725,264.83
125 ROLLING STOCK REPLACEMNT 9,050,661.24
126 SPECL GAS TAX ST IMPROVE 11,226,555.02
127 LOCAL TRANSPORTATION 6,473,226.08
128 DEVELOPMENT FUND 3,828,821.74
129 LIBRARY 1,431,048.85
130 BRANCH LIBRARIES 851,312.41
134 MUNICIPAL AIRPORT FUND 5,511,935.38-
140 TOURISM/CONVENTION FUND 339,157.73
142 ELECTRIC UTILITY FUND 66,020,527.08
143 WATER UTILITY FUND 58,449,871.38
145 WASTEWATER UTILITY FUND 43,197,041.44
147 STORM DRAIN UTILITY FUND 7,356,089.05
148 WEST CENTRAL LANDFILL 11,341,035.73
149 SOLID WASTE COLLECTION 15,284,336.91
150 MEDIA, COMMS & PR 74,151.26
151 INFORMATION TECHNOLOGY 3,023,235.60
153 FLEET MAINTENANCE 503,900.41-
154 BUILDING MAINT & CONSTR 919,866.94
158 RECORDS MANAGEMENT 87,362.57
160 EMPLOYER SERVICES 136,055.63
162 RMU ADMINISTRATION 1,299,467.31
165 GEOGRAPHIC INFO SERVICES 570,865.59
166 COMMUNICATIONS 280,539.52
168 REPROGRAPHICS 74,332.39
169 VOLUNTEER SERVICES 24,664.15-
171 SPECIAL DEPOSITS FUND 10,895,447.26
172 RISK MANAGEMENT 8,596,756.93
173 EMPLOYEE BENEFITS P/R 331,376.30
174 EMPLOYEE BENEFIT GRP INS 2,885,226.92
175 GASB 45 TRUST FUND 39,907.33
178 CAPITAL PROJECTS FUND 1,479,570.50
191 CD BLOCK GRANT FUND 6,413,736.98
193 HOUSING AUTHORITY 86,226.48-
194 REDDING REDEVELOPMENT 29,573.85
200 REDDING AREA BUS AUTHOR. 182,456.09-
230 LOW/MOD INC HOUS ASSET 688,527.46
300 SPECIAL ASSESSMENT DIST. 324,479.49
400 LANDSCAPE DISTRICTS 904,073.07
FINAL TOTAL 293,776,265.08
ACR133 10:14:43 8/02/2023
CITY OF REDDING
PROOF OF CASH
RECONCILIATION BETWEEN TREASURER'S REPORT AND ACR 133
As of June 2023
ACR133 TREASURER
END OF MONTH BALANCE 293,776,265.08 293,244,802.33
LESS OUTSIDE MANAGED FUNDS (546.36)
ACR133 Report
CASH ACCOUNTS NOT ON ACR133
LIBRARY MERCHANT DEPOSIT 300.00
BAD CHECKS 44.63
PAYROLL TIMING DIFFERENCE 196.78
BANK CHARGES (84,200.73)
WIRE TRANSFER TIMING DIFFERENCE
OTHER ADJUSTMENTS (723,112.65)
BANK DR/CR (275,452.12)
TOTALS 292,969,148.48 292,969,148.48
Sheet "D" June 2023
Sheet "D" June 2023