City of Pacifica
Treasurer's Report
December 31, 2021
Portfolio Summary
Par Value
GASB 31 Fair
Market Value Book Value % of Portfolio
General Account-Checking Account with Tri Counties Bank $ 18,637,899 $ 18,637,899 18,637,899 36.53% Payroll Account-Checking Account with Tri Counties Bank 20,210 20,210 20,210 0.04% Workers Compensation Account-Checking Account with Tri Counties Bank 769 769 769 0.00% Senior Services Account with Tri Counties Bank 2,113,036 2,113,036 2,113,036 4.14% Roy Davies Trust- Principal Account-Ladder Acct (Business) with City National Bank 2,972,966 2,972,966 2,972,966 5.83% Roy Davies Trust- Interest Account-Public Funds - Checking Acct with City National Bank 27,936 27,936 27,936 0.05% Petty Cash - Held by various Departments 3,445 3,445 3,445 0.01% Cash $ 23,776,262 $ 23,776,262 $ 23,776,262 46.60%
Investments
California Local Agency Investment Fund (LAIF) $ 17,661,008 $ 17,661,008 17,661,008 34.61% Bank of New York Mellon-Fund 91 - Cash & Short Term 156,970 156,970 156,970 0.31% Deutsche Bank-Cash-Earmarked for debt service - Energy Retrofit Lease 13,415 13,415 13,415 0.03% US Bank - Money Market Fund* 9,016,430 9,016,430 9,016,430 17.67% PARS Post-Employment Benefit Trust** 401,674 401,674 401,674 0.79% Total Investments $ 27,249,497 $ 27,249,497 $ 27,249,497 53.40% Total Cash and Investments $ 51,025,759 $ 51,025,759 $ 51,025,759 100.00% Yulia Carter Date
Chief Financial Sustainability Officer
*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. 2/28/2022
City of Pacifica
Treasurer's Report
December 31, 2021
Reconciliation to General Ledger
Description Bank Account # Amount
Tri Counties General Checking Account xx0541 $ 18,637,899 Tri Counties Payroll Account xx6915 $ 20,210
Tri Counties Workmens Comp Account xx1341 $ 769
Tri Counties Senior Services Account xx5996 $ 2,113,036 City National Bank Roy Davies Trust-Principal xx5367 $ 2,972,966 City National Bank Roy Davies Trust-Interest xx7033 $ 27,936 Local Agency Investment Fund (LAIF) xx1614/xx1007 $ 17,661,008 Bank of New York Mellon xx0166/xx0167 $ 156,970
Deutsche Bank - Energy Retrofit Lease $ 13,415
US Bank - 2016 Refunding xx5000 $ 1,048,765
US Bank - 2017 Wastewater Revenue Bond-Project Fund xx2001 $ 4,029,096 US Bank - 2017 Wastewater Revenue Bond-Interest xx2003 $ 1 US Bank - 2019 Taxable Pension Obligation Bond Refunding-Debt Service xx4000 $ 0 US Bank - 2019 Taxable Pension Obligation Bond Refunding-Cost of Issuance xx4003 $ 3,066 US Bank - 2021 Civic Center Bonds xx9000 $ 3,935,502
Public Agency Retirement Services (PARS) - Post Employment Benefit Trust $ 401,674 Petty Cash $ 3,445
Total Cash per Bank Statements $ 51,025,759
Description GL Account # Amount
xx.xxxxxx.11000.xxxx.xxx $ 30,279,941
xx.xxxxxx.11002.xxxx.xxx $ (507,578)
xx.xxxxxx.11100.xxxx.xxx $ 3,445
01.000000.11290.0000.000 $ 17,660,364
22.900000.11292.0000.000 $ 644
01.000000.11297.0000.000 $ 201,671
01.000000.11298.0000.000 $ 200,003
18.940000.11032.0000.000 $ 0
18.940000.11033.0000.000 $ 4,029,096
18.940000.11034.0000.000 $ 1
22.900000.11022.0000.000 $ 13,415
27.900000.11293.0000.000 $ 2,972,966
27.900000.11296.0000.000 $ 27,936
40.880000.11025.0000.000 $ 4,836
40.880000.11026.0000.000 $ 1,043,929
40.880000.11036.0000.000 $ 0
40.880000.11037.0000.000 $ 3,066
xx.xx0000.110xx.0000.000 $ 3,935,502
91.960000.11019.0000.000 $ 129,859
91.960000.11020.0000.000 $ 27,112
$ 60,026,207
$ (10,000,000)
$ 999,552
$ -
$ -
Cash in Bank
Cash in Bank - Payroll
Petty Cash
Investments - LAIF
Investments - LAIF
PARS Trusts-Pension
PARS Trusts-Other Post Employment Benefits (OPEB)
Reserve Cash-2014 Wastewater Revenue Refunding
Reserve Cash-2017 Wastewater Revenue Refunding Project
Reserve Cash-2017 Wastewater Revenue Refunding Interest Cash with Fiscal Agent
R Davies Trust - Principal
R Davies Trust - Interest
Cash Reserve - 2016 Cost of Issuance
Cash Reserve - 2016 Lease Payment
Cash Reserve - 2019 POB Refunding
Cash Reserve - 2019 POB Cost of Issuance
City of Pacifica 2021 Project Fund
Debt Service Reserve Fund - 2004 TAB
Cash with Fiscal Agent
Total Cash per General Ledger
Wire Transfer on 12.31.2021 to LAIF and timing difference between TriCounty Bank reconciliation adjustments and timing difference Fiscal Agent reconciling adjustments
Other reconciling items
Total Reconciled GL Cash $ 51,025,759
City of Pacifica
Quarterly Treasurer's Report
December 31, 2021
Cash Balances By Fund
Fund No. - Fund Name Ending Balance
01 - GENERAL FUND 23,537,099.51
05 - TRUST AND AGENCY FUND 186,060.55
07 - S.L.E.S. FUND 252,253.67
09 - STREET CONSTRUCTION FUND 222,911.82
10 - GAS TAX MAINTENANCE FUND 368,873.19
12 - HIGHWAY 1 IMPROVEMENT FUND 598,552.94
14 - MANOR DRIVE IMPROVEMENT FUND 954,103.06
15 - AIRCRAFT NOISE PROJECT FUND 411.20
16 - NPDES STORMWATER FUND 324,938.41
18 - SEWER CHARGE FUND 7,404,252.90
19 - PLANNED LOCAL DRAINAGE FUND (232,065.81)
22 - GENERAL CAPITAL IMPROVEMENT 6,030,591.22
23 - FRONTIERLAND REMEDIATION 394,655.38
24 - HOUSING IN-LIEU FUND 243,222.97
25 - PARKING IN-LIEU FUND 116,142.37
26 - PARK IN-LIEU - CAP IMPROVMNT 631,303.95
27 - PB&R - R DAVIES TRUST 3,121,896.75
28 - PB&R SPECIAL REVENUE 2,139,391.76
31 - PACIFICA LIBRARY FUND 106,765.52
35 - BEACH PARKING FUND 234,879.20
38 - DISASTER ACCOUNTING FUND 4,710,762.82
40 - DEBT SERVICE FUND 1,486,829.20
xx - 2021 CIVIC CENTER BONDS DEBT SERVICE FUND 3,935,501.54 65 - SELF-FUNDED DENTAL PLAN FUND 202,830.59
66 - SELF-INSURANCE FUND (W/C) 433,755.12
67 - SELF-INSURANCE FUND (LIAB) 716,160.21
71 - MOTOR POOL OPERATIONS FUND 103,710.97
72 - MOTOR POOL REPLACEMENT FUND 783,049.47
90 - REDEVELOPMENT AGENCY FUND (1,311.50)
91 - REDEVELOPMENT-SUCCESSOR AGENCY 656,360.68
93 - REDVLPMNT HOUSNG SUCCESSOR AUT 362,317.16
Total 60,026,206.82