07 - Financial ReportItem No. 7
memorandum
TO: Mayor & City Council
FROM: Gene Anderson, Interim City Manager & Finance Director
SUBJECT: OCTOBER 2019 FINANCIAL REPORT
DATE: November 23, 2019
BACKGROUND: Section 69 (3) of the Paris City Charter requires the Finance Director to
submit to the City Council through the City Manager a monthly statement of all receipts and
disbursements. The attached report satisfies that requirement.
STATUS OF ISSUE: This report updates the City Council on the City's financial activities
through the month stated in the subject line.
BUDGET: Not affected by this report.
RECOMMENDATION: Motion to receive the monthly financial report.
City of Paris
October 2019 Financial Report Comments
Net to Date Comparison of Revenues:
1. The operations and maintenance property tax and related collections are 0.37% less than this
time last year. Current tax collections are 4.93% of the tax levy vs. 4.20% last year.
2. Sales taxes are up 1.49% from last year.
3. Hotel occupancy taxes are up 30.61% from last year. Last year not all hotels paid on time for the
3`d quarter explaining the increase. All hotels are current on their taxes.
4. Franchise fees are up 82.64% compared to last year. A prompter payment from Atmos was the
major cause for this increase. Also, Suddenlink's payment was posted incorrectly but corrected
in a later month.
5. Permit fees are up 29.22% from last year. This amounts to $2,390. This increase was caused by
new residential permits.
6. Municipal Court fines and related fees are 8.69% below last year's collections.
7. Other revenue includes leases, interest, copy fees, birth & death certificates, library fees, mixed
beverage tax, and other minor revenues. This revenue up 86.03% caused by larger interest
earnings and lease payments.
8. Sanitation fees are down 13.02% compared to 2019 collections. This is only $3,607 and was
expected with more of these fees going directly to the Sanitation Fund in this budget.
9. EMS fees are down 0.84% compared to last year.
10. Total General Fund revenues, net of any transfers, are 12.15% ($219,996) above last year.
General Fund revenues equal 8.57% of the budget with the City being 8.33% through the budget
year.
11. Total General Fund expenditures are up 2.01% ($31,269) compared to last year. General Fund
expenditures to date equal 6.70% of budget with the City being 8.33% through the budget year..
12. Sewer revenue is up 5.35% ($28,207).
13. Water revenue is down 1.26%
14. Total Water & Sewer revenues, ignoring transfers and adjustments, are 0.94% above last year.
15. Total Water & Sewer expenses are 3.77% below last year at this point and represent 4.17% of
the total budget (4.17% adjusted for debt payments)while the City is 8.33% through the budget
year..
Departmental Expenditure Summary:
At this point the City is one month or 8.33% through the budget year. It is important to remember that
expenditures do not occur equally throughout the year. For example, capital expenditures and
association memberships are one time expenditures that if made early in the fiscal year can produce a
distorted expenditure percentage. Within the General, Water & Sewer, and Sanitation Funds there are
two departments whose expenditures are over 8.33%.
City Council -25.70%. The overage amounts to $14,008. This overage is due entirely to making
the annual general liability insurance payment to TML at the start of the year saving 2% of the
total premium. You will see this repeated in other departments.
2. Airport -26.65%. The overage amounts to $27,281 and is due to maintenance work at the airport
and the annual insurance payment.
General comments to the City Council:
1. Over 99% of all of the City operational activity takes place in the General Fund, the Water &
Sewer Fund, or the Sanitation Fund. The other funds are special purpose funds with limited
activity and usually with legal restrictions on what their money can be spent on. For that reason,
I normally only comment on the activity of the General Fund, Water & Sewer Fund, and the
Sanitation Fund. However, if circumstances merited it, I would make comment on activity in one
of the other funds.
2. 1 try to anticipate questions you might have about the report and comment on those points.
After you receive your packet and review the monthly report, if you have questions about the
report, please let the Manager know (or me if you can't reach the Manager) before the Council
meeting if possible in case I have to research the answer to your question. That does not
prevent you from asking the question at the meeting if you wish to make a point, but it does
help prevent questions coming up that I can't answer on the spot and possibly delaying the
Council in making a decision.
3. The activity of the Paris Economic Development Corporation is reflected in the monthly report.
This is a result of the City performing the bookkeeping functions for this agency. PEDC has its
own managing board.
MAI
City of Paris Fund Recap, for month ending -October 2019
General Fund:
Current
Prior
Net
Report Sort Sequence Report Group Description
Year
Year
To Date
70 Taxes Collected
380,940.09
382,369.19
-1,429.10
71 Sales Tax
589,387.65
580,701.62
8,686.03
72 Hotel/Motel Tax
232,468.35
177,983.98
54,484.37
73 Franchise Fees
223,591.78
122,419.04
101,172.74
74 Permits
10,572.60
8,181.75
2,390.85
75 Court Fines
25,252.30
27,655.62
-2,403.32
77 Other Revenue
137,243.81
73,772.27
63,471.54
78 Sanitation
24,079.49
27,686.91
-3,607.42
79 Ems Fees
325,657.69
328,427.19
-2,769.50
84 W & S Admin Fees
80,329.17
80,329.17
0.00
Total Revenue:
S 2,029,522.93 $
1,809,526.74 $
219,996.19
Total Expenditures:
$ 1,583,757.15 $
1,552,488.09 $
31,269.06
Net To Date:
$ 445,765.78 $
257,038.65 $
188,727.13
Ems Fees
0
Sanitation
Other Revenue
Court Fines
Permits
Franchise Fees
Hotel/Motel Tax
Sales Tax
Taxes Collected
0.00 100,000.00 200,000.00 300,000.00 400,000.00 500,000.00 600,000.00
is Prior Year
H Current Year
Expenditures ww wmov 1 General Fund
Department Department
Current
Prior
Current
Prior
Current Year
Prior Year
Number Name
Month Actual
Month Actual
Year To Date
Year To Date
Budget
Budget
0 Non -Departmental
0.00
0.00
0.00
0.00
0.00
0.00
11 City Council
20,727.12
25,881.09
20,727.12
25,881.09
80,650.00
89,830.00
12 City Manager
18,106.41
17,406.86
18,106.41
17,406.86
395,522.00
395,806.00
13 City Attorney
17,346.24
14,496.16
17,346.24
14,496.16
359,035.00
349,688.00
14 Municipal Court
12,262.03
11,303.95
12,262.03
11,303.95
234,389.00
247,772.00
15 City Clerk
6,349.11
6,887.77
6,349.11
6,887.77
144,847.00
144,357.00
21 Accounting & Auditing
29,230.33
22,446.29
29,230.33
22,446.29
451,611.00
445,942.00
31 Police
466,198.01
438,104.80
466,198.01
438,104.80
6,517,341.00
6,538,662.00
32 Fire
405,008.37
376,806.76
405,008.37
376,806.76
5,135,886.00
5,085,669.00
40 Community Developm
24,165.64
15,686.02
24,165.64
15,686.02
573,737.00
451,843.00
41 Engineering
29,458.58
25,624.36
29,458.58
25,624.36
443,757.00
420,501.00
42 Public Works
13,191.89
12,141.60
13,191.89
12,141.60
244,912.00
233,023.00
43 Parks,Recreation,&RC
41,718.28
29,947.36
41,718.28
29,947.36
1,146,646.00
1,252,319.00
44 Sanitation
0.00
34.18
0.00
34.18
0.00
0.00
46 Streets & Highways
75,641.24
52,319.46
75,641.24
52,319.46
1,678,200.00
1,703,269.00
48 Traffic & Public Lighth
8,803.92
34,197.43
8,803.92
34,197.43
516,682.00
570,516.00
49 Garage
15,843.09
19,548.53
15,843.09
19,548.53
357,199.00
368,238.00
51 Paris -Lamar CO Health
0.00
0.00
0.00
0.00
0.00
0.00
54 Emergency Medical Se
176,881.23
238,964.79
176,881.23
238,964.79
2,610,947.00
2,693,657.00
61 Cox Field Airport
39,680.25
29,670.42
39,680.25
29,670.42
148,850.00
138,850.00
62 Paris Band
50.29
54.03
50.29
54.03
23,050.00
23,050.00
64 Library
51,788.51
47,768.02
51,788.51
47,768.02
713,539.00
721,328.00
89 General Expenses
131,306.61
133,198.21
131,306.61
133,198.21
1,788,642.00
1,762,529.00
90 Debt
0.00
0.00
0.00
0.00
0.00
0.00
91 Contingency
0.00
0.00
0.00
0.00
50,000.00
50,000.00
Total General Fund
$1,583,757.15
$1,552,488.09
$1,583,757.15
$1,552,488.09
$23,615,442.00
$23,686,849.00
Other
Sewer
Water
Water Sewer Fund:
Current
Prior
Net
Revenue Group
Year
Year
To Date
Water
720,158.37
729,376.22
-9,217.85
Sewer
555,062.82
526,854.84
28,207.98
Other
39,691.79
46,350.98
-6,659.19
Total Revenue:
. 1,314,912.98
1,302,582.04
12,330.94
Total Expenditures:
$ 630,479.80 $
655,188.75 $
{24,708.95)
Net To Date:
$ 684,433.18 $
647,393.29 $
37,039.89
0.00 100,000.00 200,000.00 300,000.00 400,000.00 500,000.00 600,000.00 700,000.00
800,000.00
* Prior Year
a Current Year
Expenditures Water f Sewer Fund
Fund Number 10 Water & Sewer Fund
Deparhnent Department Current Year
Prior Year
Current Year
Prior Year
Current Year
Prior Year
Number Name Month
Month
To Date
To Date
Budget
Budget
80 Warehouse 8,744.05
7,417.13
8,744.05
7,417.13
101,797.00
98,334.00
81 W & S Billing and Collecting 153,502.46
175,057.87
153,502.46
175,057.87
2,253,734.00
2,230,827.00
82 Water Production 142,155.24
201,080.68
142,155.24
201,080.68
1,786,295.00
2,543,497.00
83 Water Distribution 72,947.50
87,640.08
72,947.50
87,640.08
1,140,343.00
1,463,827.00
85 Sewer Maintenance 38,636.87
35,773.96
38,636.87
35,773.96
680,739.00
721,939.00
86 Waste Water Treatment 195,152.22
122,120.61
195,152.22
122,120.61
2,160,062.00
2,127,000.00
87 Lift Stations 19,341.46
26,098.42
19,341.46
26,098.42
225,727.00
365,250.00
Total Water & Sewer Fund $630,479.80
$655,188.75
$630,479.80
$655,188.75
$8,348,697.00
$9,550,674.00
Fund Number
2
Economic Development Ful Current Year
Prior Year
Net To Date
Revenue
$ 118,147.43
$ 116,553.68
$ 1,593.75
Expenditure
$ 85,703.45
$ 22,659.01
$ 63,044.44
Subtotal
Net To Date:
$ 32,443.98
$ 93,894.67
$ (61,450.69)
Fund Number
11
Capital Projects Fund
Current Year
Prior Year
Net To Date
Revenue
$ 466.40
$ -
$ 466.40
Expenditure
$ 5,898.53
$ 4,158.71
$ 1,739.82
Subtotal
Net To Date:
$ (5,432.13) $
(4,158.71) $ (1,273.42)
Fund Number
12
WW&SS Rev Bond 2000 Cc Current Year
Prior Year
Net To Date
Revenue
S
$
$
Expenditure
Subtotal
Net To Date:
$
Fund Number
13
Equipment Replacement Ft Current Year
Prior Year
Net To Date
Revenue
$ 1.35
$ (11.67)
$ 13.02
Expenditure
$ -
$
$ -
Subtotal
Net To Date:
$ 1.35
$ (11.67) $ 13.02
Fund Number
14
CO 2010 Construction Funt Current Year
Prior Year
Net To Date
Revenue
$
$
$
Expenditure$
$
$ -
Subtotal
Net To Date:
$
...........
$
........ —._.m. - ...... __..
$
Fund Number
16
TWDB Loan Fund
Current Year
Prior Year
Net To Date
Revenue
$ 55.28
$
$ 55.28
Expenditure
S
$
$...._
Subtotal
Net To Date:
; 55.28
$ -
$ 55.28
Fund Number
17
Library Construction Fund
Current Year
Prior Year
Net To Date
Revenue
$
$ -
$
Subtotal
Fund Number
is
Subtotal
Fund Number
19
Subtotal
Fund Number
20
Subtotal
Fund Number
21
Subtotal
Fund Number
22
Subtotal
Fund Number
23
Expenditure $ $ $
Net To Date: $ $ $
W&S Series'97 Const Fund Current Year Prior Year Net To Date
Revenue $ $
Expenditure $ $ $
. . . . . .............. ............... .
Net To Date: $ $
Water Revenue Const Fund Current Year Prior Year Net To Date
Revenue
Expenditure
Net To Date:
Special Revenue Fund Current Year Prior Year Net To Date
Revenue $ $
Expenditure $ $
------------------
Net To Date: $ $ - $ -
................. . . . .......
Child Safety Fund Current Year Prior Year Net To Date
Revenue $ 3.50 3.50
Expenditure
Net To Date: $ 3.50 $ $ 3.50
. . ........ ---
Health Department Fund Current Year Prior Year Net To Date
Revenue $ $ $
Expenditure $ $
Net To Date: $ $
PEG Channel Fund Current Year Prior Year Net To Date
Revenue
$ 13,351.82
$ 1,026.28
$ 12,325.54
Expenditure
$
$
$
Subtotal
Net To Date:
$ 13,351.82
$ 1,026.28
$ 12,325.54
Fund Number
24
Lake Crook Restoration
Ful Current Year
Prior Year
Net To Date
Revenue
$ 5.96
$
$ 5.96
Expenditure
$ -
$
$
Subtotal
Net To Date:
$ 5.96
$ -
$_..____._._... 5.96
Fund Number
25
Grant Fund
Current Year
Prior Year
Net To Date
Revenue
$ (2,365.20)
$ -
$ (2,365.20)
Expenditure
$ 10,196.24
$ 9,444.38
$ 751.86
Subtotal
Net To Date:
§ (12,561.44)
$ (9,444.38)
$ (3,117.06)
Fund Number
26
Criminal Justice Div Grant
I Current Year
Prior Year
Net To Date
Revenue
$
$
$
Expenditure
$
$
$
Subtotal
Net To Date:
$
$
$
Fund Number
27
Water Contract Fund
Current Year
Prior Year
Net To Date
Revenue
$ 1,652.73
$ 1,512.79
$ 139.94
Subtotal
Net To Date:
$
$ -
$ -
$ 1,652.73
$ 1,512.79
$ 139.94
Fund Number
30
Community Dvi Block Gran Current Year
Prior Year
Net To Date
Revenue
$ 345.29
$ 29.49
$ 315.80
Expenditure
Subtotal
Net To Date:
$ 345.29
$ _ 29.49
$ 315.80
Fund Number
31
Home Buyers Asst 2009
Current Year
Prior Year
Net To Date
Revenue
$ -
$
$
Expenditure
$
$
$
Subtotal
Net To Date:
§
§
$
Fund Number
32 Owner Occ Rehab #10010: Current Year Prior Year Net To Date
Revenue $ $ $
Expenditure $ $ $
Subtotal Net To Date: $ $ $
Fund Number
33
Municipal Court Tech Fee
Current Year
Prior Year
Net To Date
Revenue
$ 718.05
$ 868.84
$ (150.79)
Expenditure
$ 25.00
$ 738.13
$ (713.13)
Subtotal
Net To Date:
$ 693.05
$ 130.71
$ 562.34
Fund Number
34
Municipal Court Security R
Current Year
Prior Year
Net To Date
Revenue
$ 608.34
$ 650.33
$ (41.99)
Expenditure
$ 260.40
$ 402 98
m$ . (142.58)
Subtotal
Net To Date:
$ 347.94
$ 247.35
$ 100.59
Fund Number
35
Municipal Court Child Safe
Current Year
Prior Year
Net To Date
Revenue
$ 39.11
$ 64.80
$ (25.69)
Expenditure
. $ .....
$ . _....
$
Subtotal
Net To Date:
$ 39.11
$ ".S0
$ (25.69)
Fund Number
36
Municipal Court Time Pay F
Current Year
Prior Year
Net To Date
Revenue
$ 151.24
$ 187.96
$ (36.72)
Expenditure
$
$
$
Subtotal
Net To Date:
$ 151.24
$ 187.96
$ (36.72)
Fund Number
37
Police Conf Fds-Gambling
Current Year
Prior Year
Net To Date
Revenue
$ 7.91
$
$ 7.91
Expenditure
Subtotal
Net To Date:
$ 7.91
$ -
$ 7.91
Fund Number
38
Police Judicial Forfeitures Current Year
Prior Year
Net To Date
Revenue $ 67.90
$ 3,572.17
$ (3,504.27)
Expenditure $ 880.00
$
$ ....._ 880.00
Subtotal
Net To Date: # (812.10) ;
3,572.17
(4,384.27)
Fund Number
39
Equitable Sharing Forfeitur Current Year
Prior Year
Net To Date
Revenue $ 39.35
$
$ 39.35
Expenditure $ ._..
$
$
Subtotal
Net To Date: # 39.35
#
# ....._.._ 39.35
Fund Number
40
City of Paris CO'93 Const F, Current Year
Prior Year
Net To Date
Revenue $
$
$
Expenditure $
$
$
Subtotal
Net To Date: # -
# -
#
Fund Number
41
Tax & Rev CO 2000 Const F Current Year
Prior Year
Net To Date
Revenue $
$ -
$
Expenditure $
$
$
Subtotal
Net To Date: #
$
#
Fund Number
42
CO Series 2002 Constructic Current Year
Prior Year
Net To Date
Revenue $
$
$
Expenditure $
$
$ ........_. ......
Subtotal
Net To Date:
Fund Number
43
GO Bonds 2013 Constructk Current Year
Prior Year
Net To Date
Revenue $ -
$ -
$
......_.-
Expenditure$..........n.........._
$ 251,647.59
$ (251,647.59)
Subtotal
Net TO Date: # -
# (251,647.59) ; 251,647.59
Fund Number
45
Land Fill Current Year
Prior Year
Net To Date
Revenue $ 97,469.15
$ 93,905.48
$ 3,563.67
Expenditure $ 58,717.91
$ 48,520.52
$� 10,197.39
Subtotal
Net To Date: # 38,751.24
# 45,384.96
$ (6,633.72)
Fund Number
50
Revenue Bonds Sinking Ful Current Year
Prior Year
Net To Date
Revenue $ 32,232.98
$ 31,248.55
$ 984.43
............................
Expenditure $
$ -
$
Subtotal
Net To Date: # 32,232.98
# 31,248.55
$ 984.43
Fund Number
51
Tx&RevCOs 2013 (TWDB) 7 Current Year
Prior Year
Net To Date
Revenue $ 15,168.50
$ 15,205.08
$ (36.58)
Expenditure $
$
$
Subtotal
Net To Date: $ 15,168.50
# 15,205.08
# (36.58)
Fund Number
52
2012 GO Refunding Bond I Current Year
Prior Year
Net To Date
Revenue $
$
$
Expenditure $
$
$
Subtotal
Net To Date: #
#
#
Fund Number
53
Tax & Rev CO 2010 I&S Ful Current Year
Prior Year
Net To Date
Revenue $ 11,456.54
$ 10,568.55
$ 887.99
Expenditure $ -
__....._..........._............._.....
$ -
$
Subtotal
Net To Date: # 11,41S6.54
#W------ 10,568.55
# 887.99
Fund Number
54
City of Paris CO'93 I&S Fuw Current Year
Prior Year
Net To Date
Revenue $ -
$
$
Expenditure $
$
$
Subtotal
Net To Date: #
#
#_..
Fund Number
55
Tax & Rev CO 2000 I&S Ful Current Year
Prior Year
Net To Date
Revenue $
$
$
Expenditure $
$
$
Subtotal
Net To Date: $ -
$ -
; -
Fund Number
56
Tax & Rev CO 2002 I&S Fm Current Year
Prior Year
Net To Date
Revenue $
$ -
$
Expenditure $ -
$
$
Subtotal
Net To Date: $ -
$ -
$
Fund Number
57
Contractual Oblig i&S Func Current Year
Prior Year
Net To Date
Expenditure $
$
$
Subtotal
Net To Date:
Fund Number
58
2003 GO Refunding Bonds Current Year
Prior Year
Net To Date
Revenue _$
$
$
Expenditure $
S
$
Subtotal
Net To Date: $ -
$ -
$ -
Fund Number
59
2010 GO/W&S Refunding I Current Year
Prior Year
Net To Date
Revenue $ 73,789.22
$ 84,909.64
$ (11,120.42)
Expenditure $ -�
$
$
Subtotal
Net To Date: $ 73,789.22
$ 844,909.64
$ (11,120A2)
Fund Number
60
Refunding Bonds 2012 Current Year
Prior Year
Net To Date
Revenue $ 21,810.92
$ 19,835.12
$ 1,975.80
Expenditure $
$ -
$ -
Subtotal
Net To Date: $ 21,810.92
$ 19,835.12
$ 1,975.80
Fund Number
61
Interlocal Coop Agreement
Current Year
Prior Year
Net To Date
Revenue
$ 5,049.31
4,884.71
164.60
Expenditure
$
. . . ........ ... .
Subtotal
Net To Date:
....
.................
164.60
Fund Number
62
6 0 Bonds 2013 I&S Fund
Current Year
Prior Year
Net To Date
Revenue
$ 176,760.23
$ 243,281.29
$ (66,521.06)
Expenditure
Subtotal
Net To Date:
$ 176,760.23
243,281.29
$ (66,521.06)
Fund Number
63
CO Bonds - 2016
Current Year
Prior Year
Net To Date
Revenue
$ 65,769.13
$ 76,025.40
$ 110,256.27)
Expenditure
$ -
$ -
$ -
Subtotal
Net To Date:
$
56.27)
Fund Number
64
CO Bonds - 2017
Current Year
Prior Year
Net To Date
Revenue
31,814.67
$ 32,441.97
$ (627.30)
Expenditure
$
Subtotal
Net To Date:
(627.30)
Fund Number
70
Employees Insurance Fund
Current Year
Prior Year
Net To Date
Revenue
$
$
Expenditure
Subtotal
Net To Date:
$
$
$
Fund Number
71
Insurance Claims Fund
Current Year
Prior Year
Net To Date
Revenue
$
$
$
Expenditure
$
$
$
Subtotal
Net To Date:
$
$
Fund Number
72
Library Memorial Fund
Current Year
Prior Year
Net To Date
Revenue
$ 85.20
$ 95.00
$ (9.80)
Expenditure
$ 171.12
$ 1,762.18
$ 11,591.04
Subtotal
Net To Date:
; (85.92) ;
(1,667.15) ; 1,581.26
Fund Number
73
3 A Love Trust Fund
Current Year
Prior Year
Net To Date
Revenue
$
$
$
Expenditure
$
$
$
Subtotal
Net To Date:
;
;
; -
Fund Number
74
3 P Poteet Trust Fund
Current Year
Prior Year
Net To Date
Revenue
$
$
$ -
Expenditure
$
$
$
Subtotal
Net To Date:
Fund Number
75
Wilbor Deshong Trust Func Current Year
Prior Year
Net To Date
Revenue
$
$ -
$
Expenditure
$
$ -
$
Subtotal
Net To Date:
Fund Number
76
Gibbs Library Fund
Current Year
Prior Year
Net To Date
Revenue
$ .
.
$ .
$ -
Expenditure
..... ..........................................
$
$
$
Subtotal
Net To Date:
$
$
;
Fund Number
77
W B & Kathryn Vaughan Mt Current Year
Prior Year
Net To Date
Revenue
$
$
$
Expenditure
$
$
$
Subtotal
Net To Date:
;
;
;
Fund Number
78
Malone H Love Memorial FI Current Year
Prior Year
Net To Date
Revenue
$
$
$
Expenditure
$.._.........._..__.
S
$
Subtotal
Net To Date:
¢
$
$
Fund Number
79
Library Expendable Fund
Current Year
Prior Year
Net To Date
Revenue
$ 107.50
$
$ 107.50_
Expenditure
$ "-29.92
$ 295.00
$ 065.08)
Subtotal
Net To Date:
$ 77.58
$ (295.00) $ 372.58
Fund Number
80
Library Permanent Fund
Current Year
Prior Year
Net To Date
Revenue
$ 0.91
$ -
$ 0.91
Expenditure
$
$ .,...
$ .. ..
Subtotal
Net To Date:
; 0.91
¢ -
$ 0.91