M E M O R A N D U M
September 20, 2023
TO: City Clerk
FROM: Kim Sitton
Finance Director
SUBJECT: Monthly Fiscal Report, June 2023
Pursuant to CMC Section 2.28.010 (D) the attached report provides an accounting of all receipts, disbursements, and fund balances for the month of June 2023, subject to final audit.
Prepared By: Reviewed By:
_______________________________ _______________________________ Financial Analyst Accounting Manager
Respectfully submitted:
_______________________________ _______________________________ Finance Director Assistant City Manager
_______________________________
City Treasurer
Attachment
DocuSign Envelope ID: 5CA147CD-8CAF-47E7-97B7-1F8C189EB192
BEGINNING ENDING
DESCRIPTION BALANCE RECEIPTS DISBURSEMENTS BALANCE
Balance Per Bank - Bank of America 4,887,186.19 $ 60,971,383.64 $ 60,787,465.99 $ 5,071,103.84 $ Deposits in Transit 924,733.12 536,708.65 924,733.12 536,708.65 Outstanding Checks (1,869,886.36) 1,869,886.36 3,139,900.41 (3,139,900.41) Fiscal Agents 32,052,656.26 90,924,974.04 109,882,961.30 13,094,669.00 Investments
Chandler Investment- City Account 456,507,744.16 136,822,491.88 126,365,583.62 466,964,652.42 Chandler Investment -Pension Trust Fund 32,602,615.08 118,446.27 32,721,061.35 LAIF 45,709,460.43 25,800,000.00 24,550,000.00 46,959,460.43 Investments Subtotal 534,819,819.67 162,740,938.15 150,915,583.62 546,645,174.20 Change Fund 10,248.00 0.00 0.00 10,248.00
Returned Checks 7,101.83 22,875.97 17,112.63 12,865.17
Credit Card Reconciling Items- Fees (1,916.84) 1,916.84 2,033.39 (2,033.39) TOTAL $ 317,068,683.65 570,829,941.87 $ 325,669,790.46 $ 562,228,835.06 $ * For informational purpose only
Subject to final audit
June 30, 2023
CITY OF CORONA
Receipts and Disbursements*
DocuSign Envelope ID: 5CA147CD-8CAF-47E7-97B7-1F8C189EB192
ENDING DEPOSITS OUTSTANDING MISCELLANEOUS RECONCILED
ACCOUNTS BANK BAL IN TRANSIT CHECKS RECONCILING ITEMS BALANCES LAIF 46,959,460.43 $ 46,959,460.43 $
Chandler Investment- City Account 466,964,652.42 $ 466,964,652.42 $ Chandler Investment -Pension Trust Fund 32,721,061.35 $ 32,721,061.35 $ Investment Total 546,645,174.20 546,645,174.20
General Account - Bank of America 4,630,724.43 344,325.27 (3,007,137.62) 10,831.78 1,978,743.86 Worker's Comp Account - Bank of America 440,379.41 192,383.38 (132,762.79) 500,000.00 Fiscal Agent Accounts 13,094,669.00 13,094,669.00
Cashiers Change 10,248.00 10,248.00
BALANCE PER BOOKS OF CITY TREASURER
& FINANCE DIRECTOR 564,821,195.04 $ 536,708.65 $ (3,139,900.41) $ 10,831.78 $ 562,228,835.06 $ Subject to final audit
CITY OF CORONA
Cash and Investment Status Report
June 30, 2023
DocuSign Envelope ID: 5CA147CD-8CAF-47E7-97B7-1F8C189EB192 General Fund $ 175,011,115.97
Special Revenue Funds
Gas Tax 8,713,888.36
Measure A 17,109,712.87
Trip Reduction 1,725,126.28
Asset Forfeiture 344,004.86
Development 28,786,556.46
Residential Refuse/Recycling (359,901.47)
Landscape and Streetlight Maintenance 25,473,909.70
Other Grants and Endowments 28,197,709.14 109,991,006.20 Debt Service Funds
Public Financing Authority 19.69 19.69
Capital Project Funds
Housing/Community Development 161,570.48
Planned Local Drainage 573,677.44
Other Grants 20,707,149.70
Public Facility Project (3,875,769.60)
Corona Housing Authority 27,234,651.53 44,801,279.55
Enterprise Funds
Water Utility 51,507,992.89
Water Reclamation Utility 73,393,858.33
Transit 949,624.98
Electric Utility 18,336,399.91
Airport 1,520,225.04 145,708,101.15
Internal Service Funds
Fleet Operations 6,937,325.39
Workers' Compensation 24,518,471.19
Liability Risk 2,819,963.38
Warehouse Services 853,511.60
Information Technology 11,469,719.05 46,598,990.61
Fiduciary Funds
AD & CFD Bond Funds 30,170,243.23
AB109 PACT -
Successor Agency 9,948,078.66 40,118,321.89
Total All Funds 562,228,835.06 $
Subject to final audit
CITY OF CORONA
Cash Balance By Fund
June 30, 2023
DocuSign Envelope ID: 5CA147CD-8CAF-47E7-97B7-1F8C189EB192
MARKET BOOK PERCENT OF
INVESTMENTS PAR VALUE VALUE VALUE PORTFOLIO
ABS 29,112,205.19 28,333,223.43 29,108,738.12 5.32%
Agency 68,245,000.00 63,740,670.72 68,760,266.40 12.58% CMO 24,365,508.39 23,304,019.06 23,930,664.52 4.38%
Pension Trust 688,140.51 35,322,635.16 32,721,061.35 5.99% Corporate 94,796,000.00 89,103,360.30 94,342,480.39 17.26% LAIF 46,959,460.36 46,959,460.36 46,959,460.48 8.59%
Money Market Fund FI 900,416.86 900,416.86 900,416.86 0.16% Municipal Bonds 3,385,000.00 3,255,520.37 3,462,753.45 0.63% Supranational 12,690,000.00 11,482,621.39 12,633,094.65 2.31% US Treasury 235,870,000.00 228,916,768.20 233,826,237.98 42.77% TOTAL PORTFOLIO $ 531,318,695.85 517,011,731.31 $ 546,645,174.20 $ 100.00% Average Daily Balance
Subject to final audit
CITY OF CORONA
Investment Portfolio Report
June 30, 2023
DocuSign Envelope ID: 5CA147CD-8CAF-47E7-97B7-1F8C189EB192