City of Placentia
CITY TREASURER'S
R E P O RT
December 31, 2021
(Unaudited)
FISCAL YEAR
2021-2022
PLACEHTIA
all 11FIl4:R n T,
ATTACHMENT 4
CITY OF PLACENTIA
CASH AND INVESTMENT DETAIL - CITY
For the Month of December 2021
PLACENTIA
FINANCE
DEPARTMENT
HELD BY CITY
Agency
CASH:
Bank of America - General Checking
Bank of America - Workers' Comp
Bank of America - Healthcare
Banc of California - Successor Agency
1Bancof California - General Checking
Total Cash
jINVESTMENTS:
Local Agency Investment Fund
Time Value Investments
Time Value Investments
Time Value Investments
ITotal Investments
TOTAL CASH & INVESTMENTS HELD BY CITY
Investment Current
Description Yield
Account No.
XXXXXX-0221
Account No.
XXXXXX-0525
Account No
XXXXXX-0513
Account No.
XXX -XXX -2728
Account No.
XXX -XXX -2660
City Account
No. XX -XX -XXX
Purchase
Date
Maturity
Date
Purchase
Price
Market
Value
N/A N/A On Demand $ 54,918.60 $ 54,918.60
N/A N/A On Demand $ $
N/A N/A On Demand $ $
N/A N/A On Demand $ 2,066,550.20 $ 2,066,550.20
N/A N/A On Demand $ 8,818,789.84 $ 8,818,789.84
1.79% N/A On Demand $
10,940,258.64 $ 10,940,258.64
Quantity Market Value
22,634,123.08 $ 22,634,123.08
Money Market 0.03% N/A On Demand $ 11,897.69 $ 11,897.69 Certificate of Deposit Various Various Various $ 992,000.00 $ 983,823.44 US Government Bonds Various Various Various $ 1,000,000.00 $ 981,455.00 $ 24,638,020.77 $ 24,611,299.21
$ 35,578,279.41 $ 35,551,557.85
HELD BY FISCAL AGENT
Agency
12013 Tax Allocation Refunding Bond
US Bank
12003 Certificate of Participation
IUS Bank
2020A Lease Revenue Bond - Pension
US Bank
TOTAL INVESTMENTS HELD BY FISCAL AGENT
Investment
Description
Current
Yield
First American
Treasury Fund 0.01%
US Bank Money
Market
First American
Treasury Fund
Cash & Investments Held by City and Fiscal Agent - Market Value Submitted By:
0.03%
Purchase Maturity
Date Date
N/A
N/A
N/A
N/A
0.01% N/A N/A
illpffer.js• rlandson. 'moi
Purchase
Price
$ 834,965.44
1 $
906,093.89
Market
Value
$ 834,965.44
$ 906,093.89
6,525,926.57
6,525,926.57 $
$ 8,266,985.90 $ 8,266,985.90
m Inance ❑erector Date
Approved By: Kevin A. Larson, City Treasurer Date
$ 43,818,543.75
ATTACHMENT 4
RPT Data
FUND FUND
NO. NO.
FUND
101 10 GENERAL FUND
105 11 POOLED CASH
201 16 UTILITY TAX FUND
205 17 GAS TAX FUND
210 18 MEASURE "M" FUND
215 19 AIR QUALITY FUND
225 21 ASSET SEIZURE FUND
230 22 COPS/SUPPL LAW ENFORCE. FUND
235 23 PARK DEVELOPMENT FUND
240 24 SEWER CONSTRUCTION FUND
244 68 CW AFORD HOUSING IMPACT FEE FUND
245 25 STORM DRAIN CONSTRUCTION FUND
250 26 THOROUGHFARE CONST. FUND
255 27 UNDERGROUND UTILITIES
260 28 PLACENTIA LIGHTING DISTRICT FUND
265 29 LANDSCAPE MAINT. DISTRICT
270 30 HOUSING & COMMUNITY DEVELOP.
401 33 CAPITAL PROJECTS FUND
405 34 IN -LIEU LOW/MOD HOUSING FUND
501 37 REFUSE FUND
601 39 HEALTH & WELFARE INS. FUND
605 40 RISK MANAGEMENT FUND
610 41 EQUIPMENT REPLACEMENT FUND
701 44 SPECIAL DEPOSITS
705 45 HCD REHABILITATION LOANS
715 47 COMMUNITY FAC. DISTRICT FUND
275 48 SEWER MAINTENANCE FUND
425 49 ORANGETHORPE CORRIDOR
280 50 MISC. GRANTS FUND
226 51 TRAFFIC OFFENDER FUND
206 52 GAS TAX BOND FUND
207 53 HOUSING AGENCY FUND
208 54 SUCCESSOR AGENCY FUND
261 55 PUBLIC SAFETY CFD 2014-01 FUND
241 57 PUBLIC SAFETY MITIGATION FUND
211 58 PEG FUND
116 59 REHAB REIMBURSEMENTS FUND
209 60 GAS TAX - RMRA FUND
228 61 NOC-PUBLIC SAFETY GRANT FUND
229 62 COMM BASED TRANS. GRANT FUND
236 63 PARKS & RECREATION IMPACT FEES
238 65 CITY TRAFFIC IMPACT FEES FUND
239 66 CW STORMDRAIN IMPACT FEE
242 67 CITY PUB. SAFETY IMPACT FEE FUND
243 69 CITY QUIMBY IN LIEU FEE
246 70 TOD TRAFFIC IMPACT FEES
247 71 TOD SEWER IMPACT FEES FUND
248 72 TOD STREETSCAPE IMPACT FEE
233 74 GENERAL PLAN UPDATES
234 75 TECHNOLOGY IMPACT FEES
227 76 EXPLORER GRANT NOC FUND
281 77 OCATT FUND
231 78 PLACENTIA REG NAV CENTER
117 79 MEASURE U
118 81 COVID-19 RELIEFT FUNDS
302 82 PLANCENITA PUBLIC FINANCING AUTH
Pending Journal Entries
Timing Differences
Difference between GL & Bank
CITY OF PLACENTIA
BANK RECONCILIATION
For the Month of December 2021
GIL
BALANCE
11,323,770.01
104.00
222,682.26
488,807.26
608,846.00
169,871.73
310,388.60
269,370.70
20,152.11
21,978.25
196,420.66
1,406,995.89
24,518.58
5,568.02
(93,299.74)
26,449.89
(491,795.85)
385,057 98
(209,634.75)
492,906.56
96,748.57
(1,182,732.29)
1,940,455.62
60,181.72
1,173,315.68
290.47
53,392.22
775,220.40
47,345.25
(150,498.15)
(202,369.53)
81,761.03
(605,232.71)
648,225.43
31,061.97
(2,753.62)
(38,344.21)
(350,367.57)
1,149,448.45
136,013.22
(23,960.82)
1,917,108 26
183,708.79
16,887.19
1,027,135.75
740,783.99
1,647,379.32
1,268,146.35
765,809.26
366,366.36
162,399.93
(60.24)
(1,624,297.26)
4,989,464.10
4,544,465.27
(1,047,441.69)
1,447,287.82
$ 135,221,502.49
2021-12 Bank Reconciliation Worksheets Reconciliation 3 of 15
END BALANCE PER BANK
Bank of America Checking/CITY 0221
Bank of America Checking/CITY 0525
Bank of America Checking/CITY 0513
Bank of California Checking/CITY 2660
Bank of California Checking/CITY 2677
Bank of California Checking/CITY 2694
Bank of California Checking/CITY 2711
Bank of California Checking/SA 2728
Bank of California Checking/CITY 2745
Local Agency Investment Fund
Certificates of Deposit
Less: Unrecorded Gain
Less: A/P O/S Checks
Less: Payroll O/S Checks
Less: EP 0/S Checks
Less: Worker's Comp O/S Checks
Less: Bank Deposits in Transit
Transfer from 2660 to
Transfer from 2660 to
Transfer from 2660 to
2694 (in transit)
2677 (in transit)
2711 (in transit)
PREPARED BY:
DATE:
APPROVED BY:
DATE:
TOTAL
54,918.60
8,818,789.84
2,066,550.20
22,634,123.08
1,977,176.13
24,512.69
(590,309.57)
(97,911.06)
(156,245 74)
1,130,528.08
(1,860.18)
(638,769.58)
/35,221,502.49
ATTACHMENT 4
CITY OF PLACENTIA
Changes In Cash Balances
For the Month of December 2021
POSTED ADJ CASH
RPT Data CASH BALANCE JOURNALS & BITECH CASH PENDING BALANCE FUND FUND FUND 11/30/2021 RECEIPTS DISBURSEMENTS VOIDS 12/31/2021 JOURNAL ENTRIES' 12/31/2021 101 10 GENERAL FUND 7,959,301.62 6,711524.19 (3,347,284 98) 229.18 11,323,770.01 (5,486.34) 11,318,283.67 105 11 POOLED CASH 104.00 - - 104.00 104.00
201 16 UTILITY TAX FUND 222,682.26 222.68226 222,682.26 205 17 GAS TAX FUND 295,219.12 202,731 06 (9,142.92) 488,807 26 488,807.26 210 18 MEASURE "M" FUND 697,062.94 (88,216.94) 608,846.00 608,846.00 215 19 AIR QUALITY FUND 153,057.55 16,814.18 169,871.73 169,871,73 225 21 ASSET SEIZURE FUND 311,477.83 (1,08923) 310,388.60 310,388.60 230 22 COPS/SUPPL LAW ENFORCE. FUND 250,051.03 19,31967 269,370,70 269,370.70 235 23 PARK DEVELOPMENT FUND 20,152,11 - - 20,152,11 - 20,152.11 240 24 SEWER CONSTRUCTION FUND 21,978.25 21,978.25 21,978.25 245 25 STORM DRAIN CONSTRUCTION FUND 1,406,995.89 1,406,995.69 1,406,995.89 250 26 THOROUGHFARE CONST. FUND 24,518 58 24,518,58 24,518.58 255 27 UNDERGROUND UTILITIES 5,568.02 - 5,568.02 5,568.02 260 28 PLACENTIA LIGHTING DISTRICT FUND (109,601.51) 57,611.20 (41,309.43) (93,29974) (93,299.74) 265 29 LANDSCAPE MAINT. DISTRICT (111,190.17) 189,18349 (51,54343) 26,449.89 26,449.89 270 30 HOUSING & COMMUNITY DEVELOP. (62,962.83) (433,833.02) 5,000 00 (491.795 85) (491,795.85) 401 33 CAPITAL PROJECTS FUND 391,783 89 (6,725.91) 385,057.98 385,057.98 405 34 IN -LIEU LOW/MOD HOUSING FUND (209,634.75) (209,634.75) (9.50) (209,644.25) 501 37 REFUSE FUND (576,155.30) 1,383,725.54 (314,663.68) 492,906.56 (3,10920) 489,797.36 601 39 HEALTH & WELFARE INS. FUND 169,416.20 (72,667.63) 96,748.57 96,748.57 605 40 RISK MANAGEMENT FUND (1,022,160.70) (160,571.59) (1,182,73229) (1,182,732.29) 610 41 EQUIPMENT REPLACEMENT FUND 1,940,455.62 1,940,455,62 1,940,455.62 701 44 SPECIAL DEPOSITS 108,724.14 10,698.33 (59,240.75) - 60,181,72 60,181.72 705 45 HCD REHABILITATION LOANS 1,173,315.68 - 1,173,315:68 - 1,173,315.68 715 47 COMMUNITY FAC. DISTRICT FUND 290.47 - 29047 (17.05) 273,42 275 48 SEWER MAINTENANCE FUND 91,307.31 19,903.25 (57,818.34) 53,39222 - 53,392.22 425 49 ORANGETHORPECORRIDOR 775,220.40 775,220.40 775,220.40 280 50 MISC. GRANTS FUND 41,938.64 19,787.27 (14,380.66) 47.345.25 47,345.25 226 51 TRAFFIC OFFENDER FUND (150,498.15) - (150,498.15) (150,498.15) 206 52 GAS TAX BOND FUND (202,369.53) (202,369.53) . (202,369.53) 207 53 HOUSING AGENCY FUND 81,261.03 50000 81,761.03 1,455,909.91 1,537,670.94 208 54 SUCCESSOR AGENCY FUND 245,320.07 - (850,552 78) (605,23271) (605,232.71) 261 55 PUBLIC SAFETY CFD 2014-01 FUND 632,674.35 15,551.08 - 648,225.43 648,225.43 241 57 PUBLIC SAFETY MITIGATION FUND 31,061.97 31,061.97 31,061.97 211 58 PEG FUND 4,394.03 (7,147.65) (2,753.62) (2,753.62) 116 59 REHAB REIMBURSEMENTS FUND (38,344.21) (38,344 21) (38,344.21) 209 60 GAS TAX - RMRA FUND 267,822.50 81,809.93 (700,000 00) (350,367,57) (350,367.57) 228 61 NOC-PUBLIC SAFETY GRANT FUND 1,149,448.45 1,149,448.45 1,149,448.45 229 62 COMM. BASED TRANS. GRANT FUND 136,013,22 136,013.22 136,013.22 236 63 PARKS & RECREATION IMPACT FEES (23,960.82) - - (23.960.82) (23,960.82) 238 65 CITY TRAFFIC IMPACT FEES FUND 2,041,942.64 (124,834 38) 1,917.108 26 1,917,108.26 239 66 CW STORMDRAIN IMPACT FEE 183,708.79 183,708.79 183,708.79 242 67 CITY PUB. SAFETY IMPACT FEE FUND 16,887.19 - 16,887 19 16,887.19 244 68 CW AFORD HOUSING IMPACT FEE FUND 196,420.66 196,420.66 196,420.66 243 69 CITY QUIMBY IN LIEU FEE 1,027,135.75 1,027.135.75 1,027,135.75 246 70 TOD TRAFFIC IMPACT FEES 740,783.99 740,783.99 740,783.99 247 71 TOD SEWER IMPACT FEES FUND 1,647,379.32 1,647,379.32 1,647,379,32 248 72 TOD STREETSCAPE IMPACT FEE 1,312,669.35 - (44,52300) 1,268,146.35 1,268,146.35 233 74 GENERAL PLAN UPDATES 761,511.04 4,353.72 (55 50) 765,809.26 765,809.26 234 75 TECHNOLOGY IMPACT FEES 363,817.73 2,581 00 (32 37) 366,366.36 366,366.36 227 76 EXPLORER GRANT NOC FUND 162,399.93 162,399.93 162,399.93 281 77 OCATTFUND (60.24) - - (60.24) (60.24)
231 78 PLACENTIA REG NAV CENTER (1,493,104.68) 3,478.38 (134,670.96) (1,624,297.26) (1,624,297.26) 117 79 MEASURE U 4,550,023.79 1,366,733,85 (927,293.34) 4,989,464.10 4,989,464.10 118 81 COVID-19 RELIEFT FUNDS 4,544,465.27 - 4,544,465.27 4,544,465.27 302 82 PLANCENITA PUBLIC FINANCING AUTH (1,046,841.69) (600 00) (1.047,441.69) - (1,047,441.69) TOTAL PER GENERAL LEDGER 31,110,87%04 10,106,305.94 (7,448,198.49) 5,229.18 33,774,214.67
'Journal entries may include interest income, budgeted transfers between funds, and expenses such as E -V Spark payments and bank fees 1,447,287.82 35,221,502.49 ✓
ATTACHMENT 4