City of Pacifica
Treasurer's Report
December 31, 2022
Portfolio Summary
Par Value
GASB 31 Fair
Market Value Book Value % of Portfolio
General Account-Checking Account with Tri Counties Bank $ 7,984,772 $ 7,984,772 7,984,772 13.66% Payroll Account-Checking Account with Tri Counties Bank 23,024 23,024 23,024 0.04% Workers Compensation Account-Checking Account with Tri Counties Bank 11,289 11,289 11,289 0.02% Senior Services Account with Tri Counties Bank 2,113,522 2,113,522 2,113,522 3.61% Turbo Data Account with Tri Counties Bank 36,639 36,639 36,639 0.06% Roy Davies Trust- Principal Account-Ladder Acct (Business) with City National Bank 2,974,391 2,974,391 2,974,391 5.09% Roy Davies Trust- Interest Account-Public Funds - Checking Acct with City National Bank 27,901 27,901 27,901 0.05% Petty Cash - Held by various Departments 3,445 3,445 3,445 0.01% Cash $ 13,174,984 $ 13,174,984 $ 13,174,984 22.53%
Investments
California Local Agency Investment Fund (LAIF) $ 35,772,771 35,107,013 35,772,771 61.18% Bank of New York Mellon-Fund 91 - Cash & Short Term 156,432 156,432 156,432 0.27% Deutsche Bank-Cash-Earmarked for debt service - Energy Retrofit Lease 13,415 13,415 13,415 0.02% US Bank - Money Market Fund 9,010,621 9,010,621 9,010,621 15.41% PARS Post-Employment Benefit Trust* 343,215 343,215 343,215 0.59% Total Investments $ 45,296,454 $ 44,630,696 $ 45,296,454 77.47% Total Cash and Investments $ 58,471,438 $ 57,805,680 $ 58,471,438 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. 12/27/2023
City of Pacifica
Treasurer's Report
December 31, 2022
Reconciliation to General Ledger
Description Bank Account # Amount
Tri Counties General Checking Account xx0541 $ 7,984,772 Tri Counties Payroll Account xx6915 $ 23,024
Tri Counties Workmens Comp Account xx1341 $ 11,289
Tri Counties Senior Services Account xx5996 $ 2,113,522 Tri Counties Turbo Data Account xx9758 $ 36,639
City National Bank Roy Davies Trust-Principal xx5367 $ 2,974,391 City National Bank Roy Davies Trust-Interest xx7033 $ 27,901 Local Agency Investment Fund (LAIF) xx1614/xx1007 $ 35,772,771 Bank of New York Mellon xx0166/xx0167 $ 156,432
Deutsche Bank - Energy Retrofit Lease S80844.1 $ 13,415 US Bank - 2016 Refunding xx5000 $ 1,005,813
US Bank - 2017 Wastewater Revenue Bond-Project Fund xx2001 $ 4,068,213 US Bank - 2017 Wastewater Revenue Bond-Interest xx2003 $ 897 US Bank - 2021 Civic Center Bonds xx9000 $ 3,935,698
Public Agency Retirement Services (PARS) - Post Employment Benefit Trust $ 343,215 Petty Cash $ 3,445
Total Cash per Bank Statements $ 58,471,438
Description GL Account # Amount
Cash in Bank xx.xxxxxx.11000.xxxx.xxx $ 10,022,188
Cash in Bank - Payroll xx.xxxxxx.11002.xxxx.xxx $ (542,095) Petty Cash xx.xxxxxx.11100.xxxx.xxx $ 3,445
Investments - LAIF 01.000000.11290.0000.000 $ 35,772,123 Investments - LAIF 22.900000.11292.0000.000 $ 648
PARS Trusts-Pension 01.000000.11297.0000.000 $ 170,279
PARS Trusts-Other Post Employment Benefits (OPEB) 01.000000.11298.0000.000 $ 172,936 Reserve Cash-2014 Wastewater Revenue Refunding 18.940000.11032.0000.000 $ 645 Reserve Cash-2017 Wastewater Revenue Refunding Project 18.940000.11033.0000.000 $ 4,068,213 Reserve Cash-2017 Wastewater Revenue Refunding Principal 18.940000.11034.0000.000 $ 254 Reserve Cash-2017 Wastewater Revenue Refunding Interest 18.940000.11034.0000.000 $ 252 Cash with Fiscal Agent 22.900000.11022.0000.000 $ 13,415 R Davies Trust - Principal 27.900000.11293.0000.000 $ 2,974,391 R Davies Trust - Interest 27.900000.11296.0000.000 $ 27,901 Cash Reserve - 2016 Lease Payment 40.880000.11026.0000.000 $ 1,005,813 City of Pacifica 2021 Project Fund 40.880000.11038.0000.000 $ 3,935,698 Debt Service Reserve Fund - 2004 TAB 91.960000.11019.0000.000 $ 131,458 Cash with Fiscal Agent 91.960000.11020.0000.000 $ 24,974 Total Cash per General Ledger $ 57,782,539
Tri Counties Bank reconciliation adjustments and timing differences $ 688,900 Total Reconciled GL Cash $ 58,471,438