City of Pacifica
Treasurer's Report
March 31,2024
Portfolio Summary
Par Value
GASB 31 Fair
Market Value Book Value % of Portfolio
Cash
Tri Counties Bank-General Account $ 17,134,200 $ 17,134,200 $ 17,134,200 25.59% Tri Counties Bank-CDARS Account 12,500,000 12,500,000 12,500,000 18.67% Tri Counties Bank-Payroll Account (8,957) (8,957) (8,957) -0.01% Tri Counties Bank-Workers Compensation Account - - - 0.00% Tri Counties Bank-Senior Services Account - - - 0.00%
Tri Counties Bank-Turbo Data 6,136 6,136 6,136 0.01%
City National Bank-Roy Davies Trust 2,702,433 2,702,433 2,702,433 4.04% Petty Cash - Held by various Departments 3,445 3,445 3,445 0.01% Total Cash $ 32,337,257 $ 32,337,257 $ 32,337,257 48.30% Investments
California Local Agency Investment Fund (LAIF)* $ 3,492,045 $ 3,471,760 $ 3,492,045 5.22% Bank of New York Mellon-RDA 2004 Bonds 138,229 138,229 138,229 0.21% US Bank - Money Market Fund 30,777,436 30,777,436 30,777,436 45.97% PARS PENSION** 204,000 204,000 204,000 0.30%
Total Investments $ 34,611,709 $ 34,591,424 $ 34,611,709 51.70% Total Cash and Investments $ 66,948,966 $ 66,928,681 $ 66,948,966 100.00% Date
Yulia Carter, Assistant City Manager
* LAIF FAIR VAUE RATE 0.994191267 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 TRUST
AND MODERATE INDEX FUNDS
5/13/2024
City of Pacifica
Treasurer's Report
March 31,2024
Reconciliation to General Ledger
Description Bank Account # Bank Amount
TRI COUNTIES GENERAL CHECKING ACCOUNT xx0541 17,429,747 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 6,136
CITY NATIONAL BANK ROY DAVIES TRUST-PRINCIPAL xx5367 2,702,433 LOCAL AGENCY INVESTMENT FUND (LAIF) xx1614/xx1007 3,492,045 BNY- RDA xx0166/xx0167 138,229
US BANK - 2014 WASTEWATER BONDS 2126700 90,629
US BANK - 2016 REFUNDING 24952500 808
US BANK - 2017 WASTEWATER REVENUE BOND-PROJECT FUND 27843200 4,806,673 US BANK - 2019 TAXABLE PENSION OBLIGATION BOND 267004000-3 0 US BANK - 2021 CIVIC CENTER BONDS 249299000 4,132,923
US BANK - 2023 WW IBANK LOAN 207877539 21,746,402
PARS- PENSION&OPEB PACIFICA 204,000
PETTY CASH PETTY CASH 3,445
Total Cash per Bank Statements 67,253,470
DEPOSIT IN TRANSIT 586,698
OUTSTANDING AP CHECKS at 3/31/24 (683,424)
OUTSTANDING PAYROLL WIRE (198,821)
OUTSTANDING PR CHECKS at 3/31/24 (8,957)
Total Reconciled GL Cash 66,948,966
Description GL Account # BooK Amount
CASH IN BANK xx.xxxxxx.11000.xxxx.xxx 29,637,584
CASH IN BANK - TURBO 01.000000.11001.0000.000 6,136
CASH IN BANK - PAYROLL 01.000000.11002.0000.000 (8,957) BNY- RDA DEBT SERVICE RESERVE FUND - 2004 TAB 91.960000.11019.0000.000 131,560 BNY-RDA CASH WITH FISCAL AGENT 91.960000.11020.0000.000 6,669 CITY OF PACIFICA 2021 PROJECT FUND 22.900000.11022.0000.000 4,132,923 CASH RESERVE - 2016 LEASE PAYMENT 40.880000.11026.0000.000 808 RESERVE CASH-2014 WASTEWATER REVENUE REFUNDING 18.940000.11032.0000.000 90,629 RESERVE CASH-2017 WASTEWATER REVENUE REFUNDING PROJECT 18.940000.11033.0000.000 4,307,059 RESERVE CASH-2017 WASTEWATER REVENUE REFUNDING INTEREST 18.940000.11034.0000.000 499,614 RESERVE CASH-2019 POB BONDS 40.880000.11036.0000.000 0
US BANK-2023 WASTE WATER BANK LOAN 18.940000.11040.0000.000 21,746,402 PETTY CASH xx.xxxxxx.11100.xxxx.xxx 3,445
INVESTMENTS - LAIF 01.000000.11290.0000.000 3,492,045
R DAVIES TRUST 27.900000.11293.0000.000 2,702,433
PARS TRUSTS-PENSION 01.000000.11297.0000.000 204,000
MANUAL PAYROLL CHECK #1112 ON 4/26/24 (3,384)
Total Cash per General Ledger 66,948,966