City of Pacifica
Treasurer's Report
September 30,2024
Portfolio Summary
Par Value
GASB 31 Fair
Market Value Book Value
% of
Portfolio
Cash
Tri Counties Bank-General Account $ 6,926,887 $ 6,926,887 $ 6,926,887 11.98% Tri Counties Bank-Payroll Account (5,273) (5,273) (5,273) -0.01% Tri Counties Bank-Workers Compensation Account - - - 0.00% Tri Counties Bank-Senior Services Account - - - 0.00%
Tri Counties Bank-Turbo Data 15,995 15,995 15,995 0.03% Petty Cash - Held by various Departments 3,445 3,445 3,445 0.01% Total Cash $ 6,941,054 $ 6,941,054 $ 6,941,054 12.01%
Investments
California Local Agency Investment Fund (LAIF)* $ 14,622,224 $ 14,652,362 $ 14,622,224 25.30% City National Bank-Roy Davies Trust 2,702,462 2,702,462 2,702,462 4.68% PARS PENSION** 395,727 395,727 395,727 0.68%
Bank of New York Mellon-RDA 2004 Bonds 142,259 142,259 142,259 0.25% US Bank - Money Market Fund 32,996,039 32,996,039 32,996,039 57.09% Total Investments $ 50,858,710 $ 50,888,848 $ 50,858,710 87.99% Total Cash and Investments $ 57,799,764 $ 57,829,902 $ 57,799,764 100.00% * LAIF FAIR VAUE RATE 1.002061084 https://www.treasurer.ca.gov/pmia-laif/reports/valuation.asp ** PARS TRUST - PUBLIC AGENCY RETIREMENT SERVICES - INVESTS IN CAPITAL APPRECIATION FUNDS FOR THE
CITY'S OPEB TRUST AND MODERATE INDEX FUNDS
City of Pacifica
Treasurer's Report
September 30,2024
Reconciliation to General Ledger
Description Bank Account # Bank Amount
TRI COUNTIES GENERAL CHECKING ACCOUNT xx0541 9,299,847
TRI COUNTIES PAYROLL ACCOUNT xx6915 -
TRI COUNTIES WORKERS COMP ACCOUNT xx1341 -
TRI COUNTIES SENIOR SERVICES ACCOUNT xx5996 -
TRI COUNTIES TURBO DATA ACCOUNT xx9758 15,995
PETTY CASH PETTY CASH 3,445
CITY NATIONAL BANK ROY DAVIES TRUST-PRINCIPAL xx5367 2,702,462 LOCAL AGENCY INVESTMENT FUND (LAIF) xx1614/xx1007 14,622,224 BNY- RDA xx0166/xx0167 142,259
US BANK - 2014 WASTEWATER BONDS 2126700 1,765,625
US BANK - 2016 REFUNDING 24952500 933
US BANK - 2017 WASTEWATER REVENUE BOND-PROJECT FUND 27843200 5,604,918 US BANK - 2019 TAXABLE PENSION OBLIGATION BOND 267004000-3 1 US BANK - 2021 CIVIC CENTER BONDS 249299000 4,233,151
US BANK - 2023 WW IBANK LOAN 207877539 21,391,411
PARS- PENSION&OPEB PACIFICA 395,727
DEPOSIT IN TRANSIT 347,288
OUTSTANDING AP CHECKS at 9/30/24 (2,586,672)
OUTSTANDING PAYROLL WIRE (133,577)
OUTSTANDING PR CHECKS at 9/30/24 (5,273)
TOTAL ADJUSTED BANK BALANCE 57,799,764
Description ORG OBJECT Book Amount
CASH IN GENERAL ACCOUNT 101 10001 6,879,490
CASH IN BANK - PAYROLL 101 10002 (5,273)
CASH IN BANK - TURBO 101 10003 15,995
PETTY CASH 101&518 10020 3,445
INVESTMENTS - LAIF 101 10101 14,622,224
PARS TRUSTS-PENSION 101 11001 395,727
R DAVIES TRUST 227 11003 2,702,462
BNY- RDA 2004 BONDS FISCAL AGENT 791 11204 142,259
RESERVE CASH-2014 WASTEWATER REVENUE REFUNDING 518 11214 1,765,625 CASH RESERVE - 2016 LEASE PAYMENT 440 11216 933
RESERVE CASH-2017 WASTEWATER REVENUE REFUNDING PROJECT 518 11217 5,604,918 RESERVE CASH-2019 POB BONDS 440 11219 1
CITY OF PACIFICA 2021 PROJECT FUND 322 11221 4,233,151
US BANK-2023 WASTE WATER BANK LOAN 518 11223 21,391,411 Unrecorded Old Legacy System GEMS void checks 46,774
Unreconciling items JUL-SEP 2024 623
TOTAL ADJUSTED BOOK BALANCE 57,799,764