JUNE_2021 Investment ReportCASH AND INVESTMENT REPORT
As of June 30, 2021
Page 1
Fund Apr-21 May-21 Jun-21
01- General Fund 4,670,289.43$ 4,612,639.73$ 4,027,246.60$
02- Debt Service Fund 576,708.99$ 586,132.89$ 627,694.52$
04- Capital Project Fund 162,598.67$ 176,437.23$ 188,358.67$
05- Capital Replacement Fund 13,886.12$ 257.22$ (11,842.21)$
07- Storm Drainage Utility Fund 347,007.86$ 362,767.74$ 364,076.67$
10- Water/Sewer Fund 2,457,405.37$ 2,588,260.80$ 2,760,599.12$
12- Court Security Fund 23,981.50$ 24,323.83$ 24,533.83$
13-CIP Tax Note 2,312,338.76$ 2,304,349.02$ 2,304,371.80$
14- Park Dedication Fund 272,881.15$ 300,483.45$ 313,686.48$
15- Economic Development Fund 801,728.13$ 867,373.65$ 920,378.01$
16- Court Technology Fund 13,218.91$ 13,534.70$ 13,718.33$
17- Streets Improvement Fund 192,093.51$ 168,928.90$ 220,696.17$
18- Juvenile Case Manager Fund 7,850.64$ 7,985.57$ 8,034.86$
21- TIF #1 New Hope Fund 309,410.58$ 309,413.06$ 487,671.06$
30- Hotel/Motel Tax Fund 18,676.93$ 18,677.08$ 18,677.26$
31- Police Seizure 662.90$ 662.91$ 662.92$
32- Library Building Fund (2,165.29)$ (2,131.04)$ (2,099.29)$
34- LEOSE Fund 3,585.92$ 3,585.95$ 1,885.98$
35-Disaster Recovery Fund 787.30$ 787.30$ 787.30$
41- Park Rec/Other Donation Fund 33,187.23$ 33,075.44$ 33,003.15$
45- Roadway Impact Fee Fund 332,152.69$ 369,356.89$ 383,498.98$
61- Water Impact Fee Fund (20,015.13)$ 14,185.87$ 33,386.87$
62- Sewer Impact Fee Fund 116,703.15$ 141,544.19$ 157,422.67$
83- Tree Reforestation Fund 71,049.69$ 71,050.26$ 71,050.96$
85- Unclaimed Property Fund 1,990.24$ 1,990.24$ 1,990.24$
95- EDC Reserve Fund 125,715.86$ 125,716.87$ 125,718.12$
TOTAL ALL FUNDS 12,843,731.11$ 13,101,389.75$ 13,075,209.07$
CASH BREAKDOWN BY FUND
CITY OF KENNEDALE, TEXAS
INVESTMENT REPORT
FOR QUARTER ENDING JUNE 30, 2021
The Quarterly Investment Report provides the City's investment portfolio position as of the report period indicated
above.Funds are invested in accordance with the City of Kennedale Investment Policy,as originally adopted on
September 13, 2001 and most recently reviewed and adopted in June of 2018.
SUMMARY OF INVESTMENTS FOR THE QUARTER
100%of the City of Kennedale's investments are owned by the Pooled Cash Fund.As of the reporting quarter,
93.88%of the City's investments are in investment pools,and 6.12%are invested in money market savings
accounts.
INVESTMENT STRATEGIES
The City's main objectives in managing the portfolio are as follows: suitability, preservation & safety of principal,
liquidity, marketability, diversification, and yield.
INVESTMENT PORTFOLIO ALLOWABLE BREAKDOWN
Certificates of Deposit (50%), Investment Pools (100%)* , Money Market Mutual Funds (100%)*, Repurchase
Agreements (50%)*, Government Obligations (25%), US Treasury & US Agency Callables (25%), US Government
Agencies & Instrumentalities (100%), and US Treasury Notes/Bills (100%)
*(no more than 50% in any individual pool, fund, or repurchase agreement)
Bank Account
March 31, 2021
GL Balance
March 31, 2021
Ending Bank
Balance
Add: April
Deposits
Less: April
Withdrawals
Add: April
Interest
Add: May
Deposits
Less: May
Withdrawals Add: May Interest
Add: June
Deposits
Less: June
Withdrawals
Add: June
Interest
June 30, 2021
Ending Bank
Balance
Ending GL
Balance
Unreconciled
Difference
Consolidated Cash 1,049,815.30$ 1,049,815.30$ 1,057,468.44$ (1,109,645.62)$ 1,151,685.95$ (917,477.73)$ 966,129.00$ (1,277,469.64)$ 920,505.70$ 920,505.70$ -$
Payroll Clearing 0.00$ 0.00$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 0.00$ 0.00$ -$
Section 125 Flex -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$
Health Reimbursement -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$
Employee Health Benefit Trust 40.53$ 40.53$ 17,224.95$ (17,224.44)$ 0.51$ 42,215.10$ (42,213.81)$ 1.29$ 43,716.57$ (43,715.06)$ 1.51$ 43.84$ 43.84$ -$
TOTAL WELLS FARGO ACCOUNTS 1,049,855.83$ 1,049,855.83$ 920,549.54 920,549.54 -
Bank Account
March 31, 2021
GL Balance
March 31, 2021
Ending Bank
Balance
Add: April
Deposits
Less: April
Withdrawals
Add: April
Interest
Add: May
Deposits
Less: May
Withdrawals Add: May Interest
Add: June
Deposits
Less: June
Withdrawals
Add: June
Interest
June 30, 2021
Ending Bank
Balance
Ending GL
Balance
Unreconciled
Difference
Consolidated Cash 346,419.25$ 346,419.25 3.16$ -$ -$ 2.85$ -$ -$ 2.74$ 346,428.00$ 346,428.00$ -$
TOTAL TEX STAR ACCOUNTS 346,419.25$ 346,419.25$ 346,428.00 346,428.00 -
Bank Account
March 31, 2021
GL Balance
March 31, 2021
Ending Bank
Balance
Add: April
Deposits
Less: April
Withdrawals
Add: April
Interest
Add: May
Deposits
Less: May
Withdrawals Add: May Interest
Add: June
Deposits
Less: June
Withdrawals
Add: June
Interest
June 30, 2021
Ending Bank
Balance
Ending GL
Balance
Unreconciled
Difference
Consolidated Cash 11,620,237.68$ 11,620,237.68$ 80,069.38$ -$ 129.09$ 45,078.46$ -$ 101.39$ 120,732.76$ -$ 126.74$ 11,866,475.50$ 11,866,475.50$ -$
TOTAL TEX POOL ACCOUNTS 11,620,237.68$ 11,620,237.68$ 11,866,475.50 11,866,475.50 -
31-Mar-21 30-Jun-21
TOTAL INVESTMENT POOLS 11,966,656.93$ 12,212,903.50
Wells Fargo Payroll Clearning 0.04%–0.05%
Wells Fargo Section 125 Flex 0.04%–0.05%
TEX STAR INVESTMENTS
APR %
TEX POOL INVESTMENTS
WELLS FARGO ACCOUNTS RECONCILIATION