City of Pacifica
Treasurer's Report
March 31, 2023
Portfolio Summary
Par Value
GASB 31 Fair
Market Value Book Value % of Portfolio
Cash
General Account-Checking Account with Tri Counties Bank $ 5,216,105 $ 5,216,105 5,216,105 9.42% Payroll Account-Checking Account with Tri Counties Bank 2 2 2 0.00% Senior Services Account with Tri Counties Bank 2,113,626 2,113,626 2,113,626 3.82% Turbo Data Account with Tri Counties Bank 5,087 5,087 5,087 0.01% Roy Davies Trust- Principal Account-Ladder Acct (Business) with City National Bank 2,974,711 2,974,711 2,974,711 5.37% Roy Davies Trust- Interest Account-Public Funds - Checking Acct with City National Bank 27,891 27,891 27,891 0.05% Petty Cash - Held by various Departments 3,445 3,445 3,445 0.01% Total Cash $ 10,340,868 $ 10,340,868 $ 10,340,868 18.67% Investments
California Local Agency Investment Fund (LAIF) $ 35,876,353 35,392,392 35,876,353 64.76% Bank of New York Mellon-Fund 91 - Cash & Short Term 132,865 132,865 132,865 0.24% US Bank - Money Market Fund 8,689,113 8,689,113 8,689,113 15.68% PARS Post-Employment Benefit Trust* 359,300 359,300 359,300 0.65% Total Investments $ 45,057,630 $ 44,573,669 $ 45,057,630 81.33% Total Cash and Investments $ 55,398,498 $ 54,914,537 $ 55,398,498 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
March 31, 2023
Reconciliation to General Ledger
Description Bank Account # Amount
Tri Counties General Checking Account xx0541 $ 5,216,105 Tri Counties Payroll Account xx6915 $ 2
Tri Counties Senior Services Account xx5996 $ 2,113,626 Tri Counties Turbo Data Account xx9758 $ 5,087
City National Bank Roy Davies Trust-Principal xx5367 $ 2,974,711 City National Bank Roy Davies Trust-Interest xx7033 $ 27,891 Local Agency Investment Fund (LAIF) xx1614/xx1007 $ 35,876,353 Bank of New York Mellon xx0166/xx0167 $ 132,865
US Bank - 2016 Refunding xx5000 $ 730
US Bank - 2017 Wastewater Revenue Bond-Project Fund xx2001 $ 4,106,462 US Bank - 2017 Wastewater Revenue Bond-Interest xx2003 $ 646,188 US Bank - 2021 Civic Center Bonds xx9000 $ 3,935,732
Public Agency Retirement Services (PARS) - Post Employment Benefit Trust $ 359,300 Petty Cash $ 3,445
Total Cash per Bank Statements $ 55,398,498
Description GL Account # Amount
Cash in Bank xx.xxxxxx.11000.xxxx.xxx $ 6,649,094
Cash in Bank - Turbo xx.xxxxxx.11001.xxxx.xxx $ 5,087
Cash in Bank - Payroll xx.xxxxxx.11002.xxxx.xxx $ (10,108) Petty Cash xx.xxxxxx.11100.xxxx.xxx $ 3,445
Investments - LAIF 01.000000.11290.0000.000 $ 35,875,701 Investments - LAIF 22.900000.11292.0000.000 $ 651
PARS Trusts-Pension 01.000000.11297.0000.000 $ 180,300
PARS Trusts-Other Post Employment Benefits (OPEB) 01.000000.11298.0000.000 $ 179,000 Reserve Cash-2014 Wastewater Revenue Refunding 18.940000.11032.0000.000 $ 130,502 Reserve Cash-2017 Wastewater Revenue Refunding Project 18.940000.11033.0000.000 $ 4,106,462 Reserve Cash-2017 Wastewater Revenue Refunding Principal 18.940000.11034.0000.000 $ 257 Reserve Cash-2017 Wastewater Revenue Refunding Interest 18.940000.11034.0000.000 $ 515,429 R Davies Trust - Principal 27.900000.11293.0000.000 $ 2,974,711 R Davies Trust - Interest 27.900000.11296.0000.000 $ 27,891 Cash Reserve - 2016 Lease Payment 40.880000.11026.0000.000 $ 730 City of Pacifica 2021 Project Fund 40.880000.11038.0000.000 $ 3,935,732 Debt Service Reserve Fund - 2004 TAB 91.960000.11019.0000.000 $ 131,196 Cash with Fiscal Agent 91.960000.11020.0000.000 $ 1,669 Total Cash per General Ledger $ 54,707,751
Tri Counties Bank reconciling items: outstanding checks, wire and deposit in transit $ 690,747 Total Reconciled GL Cash $ 55,398,498