City of Pacifica
Treasurer's Report
September 30, 2022
Portfolio Summary
Par Value
GASB 31 Fair
Market Value Book Value % of Portfolio
General Account-Checking Account with Tri Counties Bank $ 16,339,186 $ 16,339,186 16,339,186 32.75% Payroll Account-Checking Account with Tri Counties Bank 26,774 26,774 26,774 0.05% Workers Compensation Account-Checking Account with Tri Counties Bank 11,497 11,497 11,497 0.02% Senior Services Account with Tri Counties Bank 2,113,247 2,113,247 2,113,247 4.24% Turbo Data Account with Tri Counties Bank 9,415 9,415 9,415 0.02% Roy Davies Trust- Principal Account-Ladder Acct (Business) with City National Bank 2,973,504 2,973,504 2,973,504 5.96% Roy Davies Trust- Interest Account-Public Funds - Checking Acct with City National Bank 27,880 27,880 27,880 0.06% Petty Cash - Held by various Departments 3,445 3,445 3,445 0.01% Cash $ 21,504,949 $ 21,504,949 $ 21,504,949 43.10%
Investments
California Local Agency Investment Fund (LAIF) $ 17,712,502 17,371,731 17,712,502 35.50% Bank of New York Mellon-Fund 91 - Cash & Short Term 130,543 130,543 130,543 0.26% Deutsche Bank-Cash-Earmarked for debt service - Energy Retrofit Lease 13,415 13,415 13,415 0.03% US Bank - Money Market Fund* 10,204,928 10,204,928 10,204,928 20.45% PARS Post-Employment Benefit Trust** 325,999 325,999 325,999 0.65% Total Investments $ 28,387,387 $ 28,046,616 $ 28,387,387 56.90% Total Cash and Investments $ 49,892,336 $ 49,551,565 $ 49,892,336 100.00% Date
Yulia Carter, Assistant City Manager
*Includes available cash from the City's issuance of the 2017 Wastewater Revenue Bonds totaling $25.929 million. The initial proceeds were shown in the Cash and Investment report as of September 30, 2017. ** 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/12/2022
City of Pacifica
Treasurer's Report
September 30, 2022
Reconciliation to General Ledger
Description Bank Account # Amount
Tri Counties General Checking Account xx0541 $ 16,339,186 Tri Counties Payroll Account xx6915 $ 26,774
Tri Counties Workmens Comp Account xx1341 $ 11,497
Tri Counties Senior Services Account xx5996 $ 2,113,247 Tri Counties Turbo Data Account xx9758 $ 9,415
City National Bank Roy Davies Trust-Principal xx5367 $ 2,973,504 City National Bank Roy Davies Trust-Interest xx7033 $ 27,880 Local Agency Investment Fund (LAIF) xx1614/xx1007 $ 17,712,502 Bank of New York Mellon xx0166/xx0167 $ 130,543
Deutsche Bank - Energy Retrofit Lease S80844.1 $ 13,415 US Bank - 2016 Refunding xx5000 $ 4,949
US Bank - 2017 Wastewater Revenue Bond-Project Fund xx2001 $ 4,041,963 US Bank - 2017 Wastewater Revenue Bond-Interest xx2003 $ 2,219,300 US Bank - 2019 Taxable Pension Obligation Bond Refunding-Debt Service xx4000 $ 1 US Bank - 2019 Taxable Pension Obligation Bond Refunding-Debt Service xx4001 $ 3,066 US Bank - 2021 Civic Center Bonds xx9000 $ 3,935,649
Public Agency Retirement Services (PARS) - Post Employment Benefit Trust $ 325,999 Petty Cash $ 3,445
Total Cash per Bank Statements $ 49,892,336
Description GL Account # Amount
Cash in Bank xx.xxxxxx.11000.xxxx.xxx $ 21,728,773
Cash in Bank - Payroll xx.xxxxxx.11002.xxxx.xxx $ (4,106,654) Petty Cash xx.xxxxxx.11100.xxxx.xxx $ 3,445
Investments - LAIF 01.000000.11290.0000.000 $ 17,711,856 Investments - LAIF 22.900000.11292.0000.000 $ 646
PARS Trusts-Pension 01.000000.11297.0000.000 $ 165,521
PARS Trusts-Other Post Employment Benefits (OPEB) 01.000000.11298.0000.000 $ 160,477 Reserve Cash-2014 Wastewater Revenue Refunding 18.940000.11032.0000.000 $ 1,688,500 Reserve Cash-2017 Wastewater Revenue Refunding Project 18.940000.11033.0000.000 $ 4,041,963 Reserve Cash-2017 Wastewater Revenue Refunding Principal 18.940000.11034.0000.000 $ 625,000 Reserve Cash-2017 Wastewater Revenue Refunding Interest 18.940000.11034.0000.000 $ 530,800 Cash with Fiscal Agent 22.900000.11022.0000.000 $ 13,415 R Davies Trust - Principal 27.900000.11293.0000.000 $ 2,973,504 R Davies Trust - Interest 27.900000.11296.0000.000 $ 27,880 Cash Reserve - 2016 Lease Payment 40.880000.11026.0000.000 $ 4,949 Cash Reserve - 2019 POB Refunding 40.880000.11036.0000.000 $ 1 Interest Account - 2019 POB Refunding 40.880000.11036.0000.000 $ 3,066 City of Pacifica 2021 Project Fund xx.xx0000.110xx.0000.000 $ 3,935,649 Debt Service Reserve Fund - 2004 TAB 91.960000.11019.0000.000 $ 130,486 Cash with Fiscal Agent 91.960000.11020.0000.000 $ 57
Total Cash per General Ledger $ 49,639,335
Tri Counties Bank reconciliation adjustments and timing differences $ 253,001 Total Reconciled GL Cash $ 49,892,336