07 - October Financial ReportItem No. 7
TO: City Council
John Godwin, City Manager
FROM: Gene Anderson, Finance Director
DATE: 11-15-2017
BACKGROUND: Section 6 (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 firkancial report.
City of Paris
October 2017 Financial Report Comments
Net to Date Comparison of Revenues:
1, The operatuons and maintenance property tax and related collections are 457,41% more than
this time last year, This distorted increase is due to unusually low property tax collections in
October 2016. Current tax collections were 3.78% of the tax levy vs. 0.53% last year,
2. Sales taxes are up 7.30% from last year.
3. Hotel occupancy taxes are up 33,03% from last year. All hotels are current on their taxes.
4. Franchise fees are down 39.67% compared to last year. The difference is caused by Suddenlink
not paying their quarterly payment until November 2017 vs. October 2016 last year.
5. Permit fees are down 28,40% from last year, This, amounts to less than $6,000.
6. Municipal Court fines and related fees are 11.35,% 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 is down 4,23%.
8. Sanitation fees, are clown 15.50% compared to October 2016. This is only $5,347 and was
expected with more of these fees going directly to the Sanitation Fund in this budget.
9. EMS fees are up 4.06% compared to last year.
110, Total General Fund revenues, net of any transfers, are 20,95% above last year. As mentioned
above, reported property tax collections are the main cause of this increase. General Fund
revenues equal 5,38% of the budget with the Cwty being 8.33% through the budget year,
11. Total General Fund expenditures are down 20.23% compared to last year. General Fund
expenditures to date equal 6.60% of budget with the City being 8.33% through the budget year.
12, Sewer revenue is down 3.06%.
13. Water revenue is up 1.65% compared to last year,
14, Total Water & Sewer revenues, ignoring transfers, are 1.11% below last year.
15. Total Water & Sewer expenses are 13.64% above last year at this point and represent 5.70% of
the total budget (5.70% 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. Wuthin the General, Water & Sewer, and Sanitation Funds there are
four departments whose expenditures are over 8.33%.
1. City Council -33,78%. The overage amounts to $20,753. This overage is due to the annual
insurance payment and election related expenses.
2. Cox Field Airport -18.16%. The overage amounts to $11,567 and is due to the annual insurance
payment.
3. Water Treatment -9.31%. The overage amounts to $30,969 and is due to the annual insurance
payment, work on the WTP storage tanks & wells/pumps, and purchase of an off road vehicle.
4. Water Uistrihution-9.00Y&. The overage amounts to 9,969 and is due to 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 purAose funds with limited
activity and usually with legal restr�ctionson what their money can be spent on. For that reason,
ynormally on|ycomrnentonthe activity mfthe General Fund, Water & Sewer Fund, and the
Sanitation Fund, However, if circumstances merited it, | xvVu|d make comment on activity in one
ofthe other funds.
3� | 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 meifyou can't reach the Manager) before the Council
meeting �f possible in case l have to research the answer to your question. That does not
prevent you from asking the question at the meeting ifyou wish tomake apoint, but itdoes
help prevent questions coming up that | can't answer on the spot and possibly delaying the
Council in making a decis�on.
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. PED[ has its
own managing board,
Mah-
City of Paris Fund Recap, for mo,-
&—LgWj2
General Fund: Current Prior Net
Report Sort Sequence —Report Group Description
Year
Year
To Date
70 Taxes Collected
293,731.94
52,69538
241,036.56
71 Sales Tax
598,446.30
55'7,707.27
40,739,03
72 Hotel/Motel Tax
192,043,64
144,352,68
47,690.96
73 Franchise Fees
90,889.51
150,669-82
-5,9,780.31
74 Permits
14,362.94
20,060.60
-5,697,66
75 Court Fines
19,085,47
21,530J3
-2,444-66
77 Other Revenue
40,22938
42,009.11
-1,77933
78 Sanitation
29,144.15
34,491.81
-5,347.66
79 Ems Fees
246,463.39
236,833.66
9,629.73
Total Revenue:
$ 1,524,396.72 $
1,260,350.46 $
264,046.26
Total Expenditures:
77:524,15722 $
1,910,833.93 $
676,71)
Net To Date,
$ 239.50 $
(650,483.47) $
650,722.97
Expenditures F.nd Number
Department
Number
Total
i General Fund'
Department
Name
0 Non -Departmental
11 City Council
12 City Manager
13 City Attorney
14 Municipal Court
15 City Clerk
21 Accounting & Auditing
31 Police
32 Fire
40 Community Developm,
41 Engineering
42 Public Works
43 Parks, Recreation,& R('
44 Sanitation
46 Streets & Highways
48 Traffic & Public Lightit
49 Garage
51 Paris -Lamar Co Health
54 Emergency Medical Se
61 Cox Field Airport
62 Paris Band
64 Library
89 'General Expenses
go Debt
91 Contingency
General Fund
Current
Prior
Current
Prior
Month Actual
Month Actual
Year To Date
Year To Date
0.00
OM
10.00
0.00
27,544.73
26,292.46
27,544,73
26,292.46
22,615.58
27,781.76
22,615.58
27,781.76
14,412.88
19,852,11
14,412.88
19,852.11
14,861.97
17,774.97
14,861.97
17,774.97
8,74T24
11,31821
8,74724
11,33.&21
24,985.98
29,975.41
24,985.98
29,975A1
456,844,16
543,581.83
456,844,16
543,582,83
401,670.13
448,05841
401,67013
448,058.41
19,473.65
36,917,99
19,473.65
36,917.99
22,539A7
19,695.55
22,539.47
19,695,55
14,07935
17,176,30
14,079 75
17,176.30
-72,992.60
72,692.02
-72,992,60
72,692,02
0.00
1,166,94
0.00
1,166.94
116,291.04
169,328-02
116,291,04
169,328.02
38,349-64
40,213,34
38,349.64
40,213,34
26,185.32
24,648.04
26,185,32
24,648.04
0,00
0.00
0.00
0.00
187,010.82
177,27164
187,010.82
177,271.64
21,368.13
20,709.01
21,368.13
20,709,01
50.36
5123
50.36
53.2 3,
59,226.23
58,718.12
59,226,23
58,718.12
120,892,74
147,608.57
120,892.74
147,608,S7
0100
0,00
0.00
0.00
0.00
0.00
0,00
0.00
$1,524,157.22
$1,910,833.93
$1,524,157.22
$1,910,833.93
Current Year
Budget
0,00
81,530.Oo
392,116m
347,968,00
244,5.55.00
149,045.00
442,839,00
6,,396,659,00
4,916,872.00
333,388,00
505,066.00
231,59&00
1,234,015.00
0,00
1, 579,5'83.00
564,620,00
361,500.,00
0.00
2,685,200.00
117,650.00
23,050.00
733,179.00
1,670,615.00
01,00
50,000,00
$23,061,047.00
Prior Year
Budget
0.00
76,430.00
375,383.00
378,928,00
23,2,063.00
143,688.00
425,436.00
6,113,190.00
4,680,012.77
541,76800
492,522.00
216,337,00
1,120,,324.00
0,00
1,569,116,00
583,250.00
342,686.00
0.00
2, 693, 797.00
106,950.00
23,050.00
694,850.00
1,605, 333, 00
0,00
50,000,00
$22,466,093.77
Other
Sewer
Water
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
Water Sewer Fund:
Revenue Group
Water
Sewer
Other
Total Revenue;
Total Expenditures:
Net To Date:
Current
Prior
Net
Year
Year
To Date
728,295.59
716,417.65
11,877.94
472,448.52
487,380.25
-14,931.73
49,829.59
60,84331
-11,013.72
1,250,573.70
1,264,641.21
067.51)
$ 835,170.08
734,878.31 $
100,291.77
$ 415,40162
529,762.90 $
(114,359.28,)
0 Prior Year
M Current Year
Expenditures Water / Sewer Fund
Fund Number 10 Water & Sewer Fund
Department Department Current Year
Prior Year
Current Year
Number Name Month
Month
Prior Year
Current Year
Prior Year
80 Warehouse 8,400,53
To Date
To Date
Budget
Budget
81. W & S Billing and Collecting 376,057.19
9,616.24
172,829.48
8,400.53
9,61624
107,284.01)
101,355.00
82 Water Production 292,431,74
221,764-53
176,057�19
172,829.48
2,187,749.00
2,096,039.00
83 Water Distribution 133,087.53
124,585.67
292,431.74
221,764.53
2,762,802.00
2,433,377,00
85 Sewer Maintenance 38,813-28
46,085,74
133,087-53
124,585,67
1,367,033.00
1,354,006.00
86 Waste Water Treatment 163,457-84
133,737.47
38,813.28
46,08534
600,118.00
811,268.00
87 Lift Stations 22,921.97
26,259.18
163,457,84
133,737.47
2,036,450�00
1,981,465m
Total 'Water & Sewer Fund $835,170.08
$734,878.31
22,921.97
$835,170.08
26,259.18
332,142.00
323,520,00
$734,878.31
$9,393,578.00
$9,101,030.00
Fund Number
2
Economic Development Ful
Current Year
Prior Year
Net To Date
Revenue
$ 119,957.13
$
81,712.69
$ 38,244,44
Expenditure
$ 15,858.41
$
24,745.51
$ (8,887.20)
Subtotal
Net To Date:
$ 104,098.72
$
56,967,18
47,131.54
Fund Number
11
Capital Projects Fund
Current Year
Prior Year
Net To Date
Revenue
$ 742,574.00
$
652.17
$ 741,'921.83
Expenditure
13,776.00
$
109,451.25
$ (95, - 67515)
Subtotal
Net To Date:
$ 728,798.0,0
$
(108,79'9.08)
$ 837,597.08
Fund Number
12
WW &SS Rev Bond 2000 Co
Current Year
Prior Year
Net To Date
Revenue
$
$
Expenditure
$
$
$
Subtotal
Net To Date:
$
$
$
Fund Number
13
Equipment Replacement Ft
Current Year
Prior Year,
Net To Date
Revenue
$ 2.61
$
25.72
$ (23.11)
Expenditure
$ -
-
Subtotal
Net To Date:
$ 2,61
25.72
$ (23,11
Fund Number
14
CO 2010 Construction Fun(
Current Year
Prior Year
Net'To Date
Revenue
44.47
$
89.11
$ (44.64)
Expenditure
-
$
461.50
$ (461.50)
Subtotal
Net To Date:
$ 44.47
$
(372.39)
$ -
416.86
Fund Number
16
TWDB Loan Fund
Current Year
Prior Year
Net To Date
Revenue
$ 45.05
23-69
$ 21.36
Expenditure
$
Subtotal
Net To Date:
$ 45.05
$ . ....
............... 23.69
2136
Fund Number
17
Library Construction Fund
Current Year
Prior Year
Net To Date
Revenue,
$
Subtotal
Fund Number
Subtotal
Fund Number
Subtotal
Fund Number
Subtotal
Fund Number
Subtotal
Fund Number
Subtotal
Fund Number
Expenditure $
$
Net To Date: $ $ $
18 Wp►&S Series'97 Const Fund Current Year Prior Year, Net To Date
Revenue $ $ $
Expenditure $
Net To Date: $ $ $
19 Water, Revenue Const Punt Current Year Prior Year Net To Date
Revenue $ $ $
Expenditure $
Net To Date: $ $ $
20 Special! Revenue Fund
Current Year
Prior Year
Net To Date
Revenue
$
$
Expenditure
Net To Date:
$
$
21 Child Safety Fund
Current Year
Prior Year
Net To Date
Revenue
2.23
1.x441
$ 0.79
Expenditure
-
$
Net To Date:
2.23
$
1.44
0.79
22 Health Department Fund Current Year Prior Year Net To Date
Revenue $ $ $
Expenditure $ $
Net To Date: $ $
23 PEG Channel Fund' Current Year Prior Year Net To Date
Revenue
$ 8,25.81
$
13,999.46
$ 013.,173-65)i
Expenditure
$ -
$
Subtotal
Net To Date:
$ 825.81
$
13,999.46
�$(13,173.65)
Fund Number
24
Lake Crook Restoration Ful
Current Year
Prior Year
Net To Date
Revenue
$ 4,86
$
2.69
$ 2.17
Expenditure
$ -
Subtotal
Net To Date:
$ 4.86,
$
2.69
$ 2.17
Fund Number
25
Grant Fund
Current Year
Prior Year
Net To Date
Revenue
$ 173,480.50,
$
16,82713
$ 156,65337
Expenditure
$ 6
$
65,071-10
$ lo 11 713.04)
Subtotal
Net To Date:
$ 1 - 19,122.44
$
(48,243..97)
$ 167,366.41
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 Tel Date
Revenue
$ 1,243.917
$
1,489.84
$ (245.87)
Subtotal
Net To Date-
$
$
$ 1,243.97
$
1,489.84
$ (245.87)
Fund Number
30
Community DvI Block Grain
Current Year
Prior Year
Net To Date
Revenue
$ 109,913.31
$
2091-18
$ 109,704-13
Expenditure
$
4,754.05
$(4,754.0'5)
Subtotal
Net To Date:
$ 104,913.31.$--
... ... ...... .. (4,544.87)
$ 114,,45�8.18
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
$ 850.79,
804.13
$ 46.66
Expenditure
$ 586.83
$
1,245.15
$ (658.32)
Subtotal
Net To Date:
$ 263.96
$
(441.02)
$ 704.,98
Fund Number
34
Municipal Court Security Fi
Current Year
Prior Year
Net To Date
Revenue
$ 672.78
$
623.27
49.51
Expenditure
$ 4,63.88
$
494.71
$ (30,83)
Subtotal
Net To Date:
$ 208.90
$
128.56
$ 80.34
Fund Number
35
Muniicilpail Court Child Safe
Current Year
Prior Year
Net To Date
Revenue
$ 109.47
85.71
$ 23,.76
Expenditure
$ -
$
-
$ -
Subtotal
Net To Date:
$ 109.47
85.71
$ 23.76
Fund Number
36
Municipal Court Time Pay F
Current Year
Prior Year
Net To Date
Revenue
$ 183,63
161.82
$ 21.81
Expenditure
$
$
I50.00
$ (150-00)
Subtotal
Net To Date:
$ 183.63
$
11.82
$ 171.81
Fund Number
37
Police Cont Fds-Gambling
Current Year
Prior Year
Net To Date
Revenue
$ 6.44
$
3.57
2.87
Expenditure
$
$
-
$
Subtotal
Net To Date:
$ 6.44
$
3.57
$ 2.87
Fund Number
38
Police Judicial Forfeitures
Current Year
Prior Year
Net To Date
Revenue
$ 2,541.75
$
11,893.18
$ (9,351.43)
Expenditure
$ -
$
4,158.00
$ (4,158.00)
Subtotal
Net To Date:
$ 2,541.75
7,735.18
$ (5,193.43)
Fund Number
39
Equitable Sharing Forfeitui
Current Year
Prior Year
Net To Date
Revenue
94.94
$
124.17
(291.23)
Expenditure
-
$
2,,93,7-18._$
(2,937.18)
Subtotal
Net To Date:
$ 94.94
$
(2,813,01)
$ 2,907.95
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 Constructi(
Current Year
Prior Year
Net To Date
Revenue
$
$
$
Expenditure
$
Subtotal
Net To Date:
$
$
Fund Number
43
GO Bonds 2013 Conistructio
Current Year
Prior Year
Net To Date
Revenue
$ 11,825.05
$
31,880,.40
$ (20,055.35)
Expenditure
808,974.29
$
634,824,11
$ 174,150.18
Subtotal
Net To Date:
$ (797,149.24)
$
(602,943.71)
(194,205.53)
Fund Number
Subtotal
Fund Number
Subtotal
Fund Number
Subtotal
Fund Number
Subtotal
Fund Number
Subtotal
Fund Number
Subtotal
45 Land Fill
Current Year
Prior Year
Net To Date
Revenue
$ 93,776.59
$
87,125-02
$ 6,651.57
Expenditure
$ 75,493.05
$
100,465,05
$ (24,972.00)
Net To Date:
$ 18,283-54
$
(13,340.03)
31,623.57
50, Revenue Bonds Sinking Ful
Current Year
Prior Year
Net To Date
Revenue
30,048.21
$
28,959,53
$ 1,088.68
Expenditure
$ -
$
$
Net To Date:
$ -- 30,048.21
$
28,959.53
$ 1,088.68
51 Tx&RevCOs 2013 (TWOB) i
Current Year
Prior Year
Net To Date
Revenue
15,102.82
22,070.38
$ (6,967.56)
Expenditure
$ - —
$
$
Net To Date:
15,102-82
$
22,070.38
(6,967,56)
52 2012 GO Refunding Bond I
Current Year
Prior Year
Net To Date
Revenue
$
$$
Expenditure
$
$
Net To Date:
$
$
53 Tax & Rev CO 2010 I&S Ful Current Year Prior Year Net To Date
Revenue $ 8,562.14 $ 2,162.29 $ 6,399,.85
Expenditure
Net To Date: :$ 8,562,14 $ 2,162.29 $ -6,3-99.85
54 City of Paris CQ '93 I&S Ful Current Year Prior Year Net To Date
Revenue $ $ $
Expenditure $ $ $
Net'To Date: $ $ $
Fund Number
Subtotal
Fund Number
Subtotal
Fund Number
Subtotal
Fund Number
Subtotal
Fund Number
Subtotal
Fund Number
SubtotaN
55 Tax & Rev CO 2000, I&S Fui Current Year Prior Year Net To Date
Revenue $ $ $
Expenditure $
Net To, Date. $ $ $
56 Tax & Rev CO 2002 I&S Fui Current Year Prior Year Net To Date
Revenue $ $ $
Expenditure $ $
Net To Date-, $
57 Contractual Oblig I&S Func
Current! Year
Prior Year
Net To Date
Expenditure
$
$
$
Net To Date:
$
$
58 2003 Go Refunding Bonds
Current Year
Prior Year
Net To Date
Revenue
$
$
$
Expenditure
Net! To Date:
59 2010 GO/W&S Refunding I Current Year Prior Year Net To Date,
Revenue $ 80,469.46 $ 83,359.75 $ (2,890.29)
Expenditure $ - $
Net To Date: 80,469.46 $ 83,359.75$ (2,890.29)
60 Refunding Bonds 2012 Current Year Prior Year Net To Date,
Revenue 16,545.13 $ 3,266.82 13,278.31
Expenditure $ -
Net To Date; $ 16,545.13 .. $ 3,266.82 $ 13,278.31
Fund Number
61
Interlocal Coop Agreement Current Year
Prior Year
Net To Date
Revenue
$ 3,858.72
$
696.16
3,162.56
Expenditure
$ -
$
Subtotal
Net To Date:
3,858.72
696.16
3,162.56
Fund Number
62
G O Bonds 2013 IHS Fund
Current Year
Prior Year
Net To Date
Revenue
$ 15I,009,34
220,802.44
$ (69,793.10)
Expenditure
$ --
$
-
$
Subtotal
Net To Date:
$ 151,009.34
$
220,802.44
$ (69,793AO)
Fund Number
63
CO Bonds - 2016
Current Year,
Prior Year
Net To Date
Revenue
$ 110,596,53
. ......... . . . .... .
$
$ 110,596.53
Expenditure
$ -
$
$
Subtotal
Net To Date:
110,596.53
$
$ 110,596.,53
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
7'2
Library Memorial Fund
Current Year
Prior Year
Net To Date
Revenue
$ 99.27
$
220.67
$ (121,40)
Expenditure
$ -
$
92.66
$ (92.66)
Subtotal
Net To Date:
$ 99.27'
$
128.01
$ (28.74)
Fund Number -
Subtotal
Fund Number
Subtotal
Fund Number
Subtotal
Fund Number
Subtotal
Fund Number
SubbW
Fund Number
Subtotal
73 3 A Love Trust Fundi Current Year Prior Year Net To Date
Revenue $ $ $
Expenditure $ $
Net To Date:
74, 3 P Poteet Trust Fund Current Year Prior Year Net To Date
Revenue $
Expenditure
Net To Date: $ $
75 Wilbor Deshong Trust Func
Current Year
Prior Year
Net'To Date
Revenue
$
$
$
Expenditure
$
Net To Date:
$
$
$
76 Gibbs Library Funds
Current Year
Prior Year
Net To Date
Revenue
$ -
$
$
Expenditure
$
$
Net To Date:
$
$
$
77 W B& Kathryn Vaughan Mi Current Year Prior Year Net To Date
Revenue $ $ $
Expenditure $ $ $
Net To Date: $ $1 I'll
78 Malone IH Love Mernorial Ft Current Year Prior Year Net To Date
Revenue
Expenditure $
Net To Date; $ $
Fund Number
79 Library Expendable Fund
Current Year
Prior Year
Net To Date
Revenue
103.88
$
57.20
$ 46.68
Expenditure
-
$
Subtatal Net To Date:
103.88
57.20
46.68
Fund Number
so Library Permanent Fundl
Current Year
Prior Year
Net To Date
Revenue
0.74
$
0.41
$ 01.33
Expenditure
-
$
Subtotal Net To Date:
0.7,4
0.41