City of Pacifica
Treasurer's Report
June 30, 2023
Portfolio Summary
Par Value
GASB 31 Fair
Market Value Book Value % of Portfolio
Cash
General Account-Checking Account with Tri Counties Bank $ 17,892,131 $ 17,892,131 $ 17,892,131 31.08% Tri Counties CDARS Investment Account 12,500,000 12,500,000 12,500,000 21.71% Turbo Data Account with Tri Counties Bank 1,757 1,757 1,757 0.00% Roy Davies Trust- Principal Account-Ladder Acct (Business) with City National Bank 2,702,561 2,702,561 2,702,561 4.69% Petty Cash - Held by various Departments 3,445 3,445 3,445 0.01% Total Cash $ 33,099,894 $ 33,099,894 $ 33,099,894 57.49% Investments
California Local Agency Investment Fund (LAIF) $ 15,117,572 $ 14,888,216 $ 15,117,572 26.26% Bank of New York Mellon-Fund 91 - Cash & Short Term 232,746 232,746 232,746 0.40% US Bank - Money Market Fund 8,371,766 8,371,766 8,371,766 14.54% PARS Post-Employment Benefit Trust* 748,900 748,900 748,900 1.30% Total Investments $ 24,470,985 $ 24,241,629 $ 24,470,985 42.51% Total Cash and Investments $ 57,570,879 $ 57,341,523 $ 57,570,879 100.00% Date
Yulia Carter, Assistant City Manager
* PARS Trust - Public Agency Retirement Services - invests in Capital Appreciation funds for the City's OPEB trust and Moderate Index funds for Pension trust.
The above investments are consistent with the City's Investment Policy and are allowable under current legislation of the State of California. Investments are selected using safety, liquidity, and yield as the criteria. The City has sufficient cash flow to cover anticipated expenditures through the next six months.
City of Pacifica
Treasurer's Report
June 30, 2023
Reconciliation to General Ledger
Description Bank Account # Amount
Tri Counties General Checking Account xx0541 $ 17,892,131 Tri Counties CDARS Investment Account xx0424 $ 12,500,000 Tri Counties Turbo Data Account xx9758 $ 1,757
City National Bank Roy Davies Trust-Principal xx5367 $ 2,702,561 Local Agency Investment Fund (LAIF) xx1614/xx1007 $ 15,117,572 Bank of New York Mellon xx0166/xx0167 $ 232,746
US Bank - 2016 Refunding xx5000 $ 283,175
US Bank - 2017 Wastewater Revenue Bond-Project Fund xx2001 $ 4,152,001 US Bank - 2017 Wastewater Revenue Bond-Interest xx2003 $ 858 US Bank - 2019 Taxable Pension Obligation Bond Refunding-Debt Service xx4000 $ 1 US Bank - 2021 Civic Center Bonds xx9000 $ 3,935,732
Public Agency Retirement Services (PARS) - Post Employment Benefit Trust $ 748,900 Petty Cash $ 3,445
Total Cash per Bank Statements $ 57,570,879
Description GL Account # Amount
Cash in Bank xx.xxxxxx.11000.xxxx.xxx $ 29,141,009
Cash in Bank - Turbo xx.xxxxxx.11001.xxxx.xxx $ 1,757
Cash in Bank - Payroll xx.xxxxxx.11002.xxxx.xxx $ (2,810) Petty Cash xx.xxxxxx.11100.xxxx.xxx $ 3,445
Investments - LAIF 01.000000.11290.0000.000 $ 15,117,572 PARS Trusts-Pension 01.000000.11297.0000.000 $ 185,519
PARS Trusts-Other Post Employment Benefits (OPEB) 01.000000.11298.0000.000 $ 563,382 Reserve Cash-2014 Wastewater Revenue Refunding 18.940000.11032.0000.000 $ 94 Reserve Cash-2017 Wastewater Revenue Refunding Project 18.940000.11033.0000.000 $ 4,152,001 Reserve Cash-2017 Wastewater Revenue Refunding Bond 18.940000.11034.0000.000 $ 62 Reserve Cash-2017 Wastewater Revenue Refunding Principal 18.940000.11034.0000.000 $ 260 Reserve Cash-2017 Wastewater Revenue Refunding Interest 18.940000.11034.0000.000 $ 442 City of Pacifica 2021 Project Fund 22.900000.11022.0000.000 $ 3,935,732 R Davies Trust - Principal 27.900000.11293.0000.000 $ 2,702,561 Cash Reserve - 2016 Lease Payment 40.880000.11026.0000.000 $ 283,175 Cash Reserve - 2019 POB Refunding 40.880000.11036.0000.000 $ 1 Debt Service Reserve Fund - 2004 TAB 91.960000.11019.0000.000 $ 129,838 Cash with Fiscal Agent 91.960000.11020.0000.000 $ 102,908 Total Cash per General Ledger $ 56,316,947
Tri Counties Bank reconciling items: outstanding checks, wire and deposit in transit $ 1,253,932 Total Reconciled GL Cash $ 57,570,879