Pacifica City Council
February 26, 2024

City of Pacifica
Treasurer's Report
December 31, 2023
Portfolio Summary
Par Value
GASB 31 Fair
Market Value Book Value % of Portfolio
Cash
Tri Counties Bank-General Account 17,964,239 $ 17,964,239 $ 17,964,239 $ 26.51% Tri Counties Bank-CDARS Account 12,500,000 12,500,000 12,500,000 18.45% Tri Counties Bank-Payroll Account (6,902) (6,902) (6,902) -0.01% Tri Counties Bank-Workers Compensation Account - - - 0.00%Tri Counties Bank-Senior Services Account - - - 0.00%Tri Counties Bank-Turbo Data 2,315 2,315 2,315 0.00%City National Bank-Roy Davies Trust 2,702,514 2,702,514 2,702,514 3.99%Petty Cash - Held by various Departments 3,445 3,445 3,445 0.01%Total Cash $ 33,165,611 $ 33,165,611 $ 33,165,611 48.95% Investments
California Local Agency Investment Fund (LAIF)* $ 3,448,097 $ 3,425,833 $ 3,448,097 5.09% Bank of New York Mellon-RDA 2004 Bonds 159,237 159,237 159,237 0.24% US Bank - Money Market Fund 30,789,267 30,789,267 30,789,267 45.44% PARS PENSION** 196,216 196,216 196,216 0.29%
Total Investments $ 34,592,817 $ 34,570,553 $ 34,592,817 51.05% Total Cash and Investments $ 67,758,428 $ 67,736,164 $ 67,758,428 100.00% Date
Yulia Carter, Assistant City Manager
* LAIF FAIR VAUE RATE 0.993543131 https://www.treasurer.ca.gov/pmia-laif/reports/valuation.asp 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. * PARS TRUST - PUBLIC AGENCY RETIREMENT SERVICES - INVESTS IN CAPITAL APPRECIATION FUNDS FOR THE CITY'S OPEB TRUSTAND MODERATE INDEX FUNDS 2/26/2024
City of Pacifica
Treasurer's Report
December 31, 2023
Reconciliation to General Ledger
Description Bank Account # Bank Amount
TRI COUNTIES GENERAL CHECKING ACCOUNT xx0541 18,608,433 TRI COUNTIES CDARS ACCOUNT xx0424 12,500,000
TRI COUNTIES PAYROLL ACCOUNT xx6915 -
TRI COUNTIES WORKERS COMP ACCOUNT xx1341 -
TRI COUNTIES SENIOR SERVICES ACCOUNT xx5996 -
TRI COUNTIES TURBO DATA ACCOUNT xx9758 2,315
CITY NATIONAL BANK ROY DAVIES TRUST-PRINCIPAL xx5367 2,702,514 LOCAL AGENCY INVESTMENT FUND (LAIF) xx1614/xx1007 3,448,097 BNY- RDA xx0166/xx0167 159,237
US BANK - 2014 WASTEWATER BONDS 2126700 915
US BANK - 2016 REFUNDING 24952500 1,043,285
US BANK - 2017 WASTEWATER REVENUE BOND-PROJECT FUND 27843200 4,255,194 US BANK - 2019 TAXABLE PENSION OBLIGATION BOND 267004000-3 0 US BANK - 2021 CIVIC CENTER BONDS 249299000 4,025,667
US BANK - 2023 WW IBANK LOAN 207877539 21,464,206
PARS- PENSION&OPEB PACIFICA 196,216
PETTY CASH PETTY CASH 3,445
Total Cash per Bank Statements 68,409,524
DEPOSIT IN TRANSIT 155
OUTSTANDING AP CHECKS (575,715)
OUTSTANDING WIRE (48,518)
OUTSTANDING PR CHECKS (6,902)
ACH Deposits recorded in January (20,117)
Total Reconciled GL Cash 67,758,428
Description GL Account # BooK Amount
CASH IN BANK xx.xxxxxx.11000.xxxx.xxx 30,464,239
CASH IN BANK - TURBO 01.000000.11001.0000.000 2,315
CASH IN BANK - PAYROLL 01.000000.11002.0000.000 (6,902) BNY- RDA DEBT SERVICE RESERVE FUND - 2004 TAB 91.960000.11019.0000.000 133,255 BNY-RDA CASH WITH FISCAL AGENT 91.960000.11020.0000.000 25,982 CITY OF PACIFICA 2021 PROJECT FUND 22.900000.11022.0000.000 4,025,667 CASH RESERVE - 2016 LEASE PAYMENT 40.880000.11026.0000.000 1,043,285 RESERVE CASH-2014 WASTEWATER REVENUE REFUNDING 18.940000.11032.0000.000 915 RESERVE CASH-2017 WASTEWATER REVENUE REFUNDING PROJECT 18.940000.11033.0000.000 4,254,388 RESERVE CASH-2017 WASTEWATER REVENUE REFUNDING INTEREST 18.940000.11034.0000.000 806 RESERVE CASH-2019 POB BONDS 40.880000.11036.0000.000 0
US BANK-2023 WASTE WATER BANK LOAN 18.940000.11040.0000.000 21,464,206 PETTY CASH xx.xxxxxx.11100.xxxx.xxx 3,445
INVESTMENTS - LAIF 01.000000.11290.0000.000 3,448,097
R DAVIES TRUST 27.900000.11293.0000.000 2,702,514
PARS TRUSTS-PENSION 01.000000.11297.0000.000 196,216
Total Cash per General Ledger 67,758,428