City of Pacifica
Treasurer's Report
September 30, 2023
Portfolio Summary
Par Value
GASB 31 Fair
Market Value Book Value % of Portfolio
Cash
Tri Counties Bank-General Account 8,042,371 $ 8,042,371 $ $ 8,042,371 12.95% Tri Counties Bank-CDARS Account 12,500,000 12,500,000 12,500,000 20.12% Tri Counties Bank-Payroll Account (18,566) (18,566) (18,566) -0.03% Tri Counties Bank-Workers Compensation Account - - - 0.00% Tri Counties Bank-Senior Services Account - - - 0.00%Tri Counties Bank-Turbo Data 4,624 4,624 4,624 0.01% City National Bank-Roy Davies Trust 2,702,594 2,702,594 2,702,594 4.35%Petty Cash - Held by various Departments 3,445 3,445 3,445 0.01%Total Cash $ 23,234,468 $ 23,234,468 $ 23,234,468 37.40% Investments
California Local Agency Investment Fund (LAIF)* $ 5,345,183 $ 5,271,996 $ 5,345,183 8.60% Bank of New York Mellon-RDA 2004 Bonds 134,631 134,631 134,631 0.22%US Bank - Money Market Fund** 32,680,379 32,680,379 32,680,379 52.61%PARS Post-Employment Benefit Trust*** 724,607 724,607 724,607 1.17%Total Investments $ 38,884,800 $ 38,811,613 $ 38,884,800 62.60% Total Cash and Investments $ 62,119,268 $ 62,046,081 $ 62,119,268 100.00% Date
Yulia Carter, Assistant City Manager
* LAIF FAIR VAUE RATE 0.986307739. https://www.treasurer.ca.gov/pmia-laif/reports/valuation.asp ** US BANK INCLUDES A $21 MILLION WASTE WATER IBANK LOAN, RECORDED AS ADJUSTMENT ENTRY IN Q4 FY2022-23. *** PARS TRUST - PUBLIC AGENCY RETIREMENT SERVICES - INVESTS IN CAPITAL APPRECIATION FUNDS FOR THE CITY'S OPEB TRUST AND MODERATE INDEX FOR PENSION TRUSTS.
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. 11/13/2023
City of Pacifica
Treasurer's Report
September 30, 2023
Reconciliation to General Ledger
Description Bank Account # Bank Amount
TRI COUNTIES GENERAL CHECKING ACCOUNT xx0541 8,678,178
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 4,624
CITY NATIONAL BANK ROY DAVIES TRUST-PRINCIPAL xx5367 2,702,594 LOCAL AGENCY INVESTMENT FUND (LAIF) xx1614/xx1007 5,345,183 BNY- RDA xx0166/xx0167 134,631
US BANK - 2014 WASTEWATER BONDS 2126700 1,725,500
US BANK - 2016 REFUNDING 24952500 283,284
US BANK - 2017 WASTEWATER REVENUE BOND-PROJECT FUND 27843200 5,372,442 US BANK - 2019 TAXABLE PENSION OBLIGATION BOND 267004000-3 1 US BANK - 2021 CIVIC CENTER BONDS 249299000 4,025,567
US BANK - 2023 WW IBANK LOAN 207877539 21,273,585
PARS- PENSION&OPEB PACIFICA 724,607
PETTY CASH PETTY CASH 3,445
Total Cash per Bank Statements 62,773,641
DEPOSIT IN TRANSIT 3,228
OUTSTANDING AP CHECKS (421,225)
OUTSTANDING WIRE (217,811)
OUTSTANDING PR CHECKS (18,566)
Total Reconciled GL Cash 62,119,268
Description GL Account # BooK Amount
CASH IN BANK xx.xxxxxx.11000.xxxx.xxx 20,542,371
CASH IN BANK - TURBO 01.000000.11001.0000.000 4,624
CASH IN BANK - PAYROLL 01.000000.11002.0000.000 (18,566) PETTY CASH xx.xxxxxx.11100.xxxx.xxx 3,445
INVESTMENTS - LAIF 01.000000.11290.0000.000 5,345,183
PARS TRUSTS-PENSION 01.000000.11297.0000.000 179,778
PARS TRUSTS-OPEB 01.000000.11298.0000.000 544,829
RESERVE CASH-2014 WASTEWATER REVENUE REFUNDING 18.940000.11032.0000.000 1,725,500 RESERVE CASH-2017 WASTEWATER REVENUE REFUNDING PROJECT 18.940000.11033.0000.000 4,202,264 RESERVE CASH-2017 WASTEWATER REVENUE REFUNDING INTEREST 18.940000.11034.0000.000 1,170,178 RESERVE CASH-2019 POB BONDS 40.880000.11036.0000.000 1
US BANK-2023 WASTE WATER BANK LOAN 18.940000.11040.0000.000 21,273,585 CITY OF PACIFICA 2021 PROJECT FUND 22.900000.11022.0000.000 4,025,567 R DAVIES TRUST 27.900000.11293.0000.000 2,702,594
CASH RESERVE - 2016 LEASE PAYMENT 40.880000.11026.0000.000 283,284 BNY- RDA DEBT SERVICE RESERVE FUND - 2004 TAB 91.960000.11019.0000.000 131,525 BNY-RDA CASH WITH FISCAL AGENT 91.960000.11020.0000.000 3,105 Total Cash per General Ledger 62,119,268