07 - September monthly financial reportItem No. 7
TO: City Council
John Godwin, City Manager
FROM: Gene Anderson, Finance Director
SUBJECT: SEPTEMBER 2017 FINANCIAL REPORT
DATE: November 3, 2017
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 financi a] report,
City of Paris
September 2017 Financial Report Comments
Net to Date Comparison of Reveinues:
1. The operations and maintenance property tax and related collections are 4.70% more than this
time last year. Current tax collections were 98.11% vs. 97.10% last year.
2. Sales taxes are up 2.33% from last year. February collections inciluded a onetime net audit
collection of $126,245,49. $105,204.58 of this went to the general fund and $21,040.91 to PEDC.
3, Hotel occupancy taxes are up 5.53% from last year. All hotels are current on their taxes,
4. Franchise fees are up 2.65% compared to last year adjusting for the utility franchise payment.
5. Permit fees are up 2.20%.
6. Municipal Court fines are 6.57% 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 up 8.00%. The biggest area of increase
is interest earned.
8. Sanitation fees are flat being down only 0.28%,
9. EMS fees are up 3.58% compared to last year.
101. Total General Fund revenues, net of any transfers, are 1.13% below last year. General Fund
revenues equal 103.06% of the budget with the City being 100.00% through the budget year.
11, Total General Fund expenditures are down 4.29% compared to last year. General Fund
expenditures to date equal 100.125% of budget with the City being 1100,00% through the, budget
year.
12. Sewer revenue is down 1.93%.
13. Water revenue is down 4.92% compared to last year,
14. Total Water & Sewer revenues, ignoring transfers, are 3,29% below last year.
15. Total Water & Sewer expenses are 8,34% above last year at this point and represent 66.40% of
the total budget (89,44% adjusted for debt payments) while the City is 100.00% through the
budget year.
Departmental Expenditure Summary:
At this point the City is twelve months or 100% 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
nine, departments whose expenditures are over 100,100%.
1. City Council -104.86%. The overage amounts to $5,422. This overage is due to election related
expenses.
2. Police -102.84%. The overage arnounts to $175,286 and is due to the third pay period in
September plus accrual of September wages not paid until October.
3. Fire -102.04%. The overage amounts to $94,845 and is due to the third pay period in September
plus accrual ofSeptember wages not paid until October.
4. Community Deveilopment-101.28%, The overage amounts to $7,272 and is due to the third pay
period in September plus accrual of September wages not paid until October.
S EMS -101.44%. The overage amounts to $38,826 and is due to the third pay period in September
plus accrual of September wages not paid untH October,
6. Cox Field A|rport-93,66%.The overage amounts tm$2B36Gand isdue torunway maintenance.
7. General Expense -101.20. The overage amounts 1o$2[\136and isdue 10the Paris Metro
contribution,
8. Water Distributimn-1103.00%. The overage amounts to40,466 and is due to service line projects
and the third pay period in September plus accrual of September wages not paid until October.
9. Sanitation- 1101,86%, The overage amounts To $19,795 and isdue tw the third pay period �m
September plus accrual ofSeptember wages not paid until October.
General comments to the City Council:
1. Over 99% of all of the City operational' activity takes place in the Genera� Fund, the Water &
Sewer Fund, or the San�tation 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,
| normally only comment on the activity of the General Fund, Water 8' Sewer Fund, and the
Sanitation Fund. However, if circumstances merited it, A would make comment on activity in one
ofthe other funds.
l 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 le,t 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 atthe meeting ifyou wish 10make apoint, but itdoes
help prevent questions coming up that I can't answer on the spot and possibly delaying the
Council inmaking adecision.
l The activity ofthe Paris �Economic Development Corporation is reflected in the rnmrth|y report.
This is a result of the City performing the bookkeeping functions for this agency, PEDC has its
own managing board.
General Fund:
Current
Prior
Net
Report Sort Sequence Report Group Description
Year
Year
To Date
70 Taxes Collected
6,934,052.60
6,622,742,47
311,310.13
71 Sales Tax
7,216,181.96
7,051,858.32
164,323,64
72 Hotel/Motel Tax
665 ' 474.11
630,544.95
34,929.16
73 Franchise Fees
3,266,866.02
3,182,413.15
84,452-87
74 Permits
155,362-62
152,015.99
3,346.63
75 Court Fines
300,663.95
321,838,79
-21,174.84
77 Other Revenue
707,50434
655,041.11
52,46123
78 Sanitation
413,465,21
414,644.82
-1,179.61
79 Ems Fees
2,609,811.42
2,519,387.39
910,424.03
Total Revenue-.
$ 22,269,382.23
$ 22,525,671.99
$ 718,895.24
Total Expenditures,
$ 22, 94,242.71
$ 23,52L,620.57
$ (1,010,377.86)
Net To Date-
$ (224,860.48)
$ (978,948.58)
$ 1,729,273.10
Water Sewer Fund:
Revenue Group
Water
Sewer
Other
Total Revenue:
Total Expenditures:
Net To Date:
Current Prior Net
Year Year To Date
7,943,242.60 8,354,508.24 -411,265,64
5,697,906,54 5,810,257-66 -112,351.12
558,776.95 518,356,19 40,420.76
$ 14,199,926.09 $ 14,683,122.09 $ (483,196,00)
$ 10,134,266.90 $ 9,353,352,95 $ 780,913.95
4,065,659.19 $ 5,329,769.14 $ (1,264,109.95)
Fund Number
2
Economic Development Fund
Current Year
Prior Year
Net To Date
Revenue
$ 1,632,397.09
$
1,417,392.67
$ 215,004.42
Expenditure
$ 852,724,88
$
725,267.68
$ 127,457.20
Subtotal
Net To Date:
779,67121
$
692,124.99
$ 87,547,22
Fund Number
11
Capital Projects Fund
Current Year
Prior Year
Net To Date
Revenue
$ 5,723.74
$
1,806,727.39
$ (1,801,003,65)
Expenditure
--$-711,396.77
$
1,134,841.14
$ (423,,444-37)
Subtotal
Net To Date:
$ (70,5,673,03)
671-886-75
t 77,559,28)
Fund Number
12
WW&SS Rev Bond 2000 Const Fund
Current Year
Prior Year
Net To Date
Revenue
$
$
$
Expenditure
$
$
$
Subtotal
Net To Date:
$
$
$
Fund Number
13
Equipment Replacement Fund
Current Year
Prior Year
Net To Date
Revenue
260.97
(106.31)
367.28
Expenditure
Subtotal
Net To Date:
260.97
$
(106.31)
367.28
Fund Number
14
CO 2010 Construction Fund
Current Year
Prior Year
Net To Date
Revenue
1,049.69
6,623,67
$ (5,573.98)
�$(699,518.840
Expenditure
86,5=353
$
-786,.112.37
Subtotal
Net To Date:
543.84),
(779,488.70)
693,944,86
Fund Number
16
TWDB Loan Fund
Current Year
Prior Year
Net To Date
Revenue
$ 2,650.97
(245,242.01)
$ 247,892.98
Expenditure
$ 541-25
-$114,39,5.37
$ -(113,854.12)
SubtoW
Net To Date:
2,109.72
$
(359,637.38)
$ 361,747.10
Fund Number
17
Library Construction Fund
Current Year
Prior Year
Net To Date
Revenue
$
$
$
Expenditure
$
$
$
Subtotal
Net To Date:
$
$
$
Fund Number
18
W&S Series "97 Const Fund
Current Year
Prior Year
Net To Date!
Revenue
$
$
$
Expenditure
$
$
Subtotal
Net To Date.
$
Fund Number
19
Water Revenue Const Fund
Current Year
Prior Year
Net To Date
Revenue
Expenditure
$
Subtotal
Net To Date:
$
$
$
Fund Number
20
Special Revenue Fund
Current Year
Prior Year
Net To Date
Revenue
(99.92)
99.92
Expenditure
Subtotal
Net To Date:
$
$
(99M)
99.92
Fund Number
21
Child Safety Fund
Current Year
Prior Year
Net To Date
Revenue
$ 2,221.78
$
7,042.34
$ (4,820.56)
Expenditure
2,470.{30
$
28,558.29
$ (26,088.29,)
Subtotal
Net To Date.
(248.22)
$
(21,515.95)
$ 21,267.73
Fund Number
22
Health Department Fund
Current Year
Prior Year
Net To Date
Revenue
$
$
Expenditure
$
Subtotal
Net To Date:
$
$
$
Fund Number
23
PEG Channel Fund
Current Year
Prior Year
Net To Date
Revenue
$ 62,763.55
$
56,245.34
6,518,21
Expenditure
SubtoW
Net To Date:
$ 62,763.55
$
56 245,34
6,518.21
Fund Number
24
(Lake Crook Restoration Fund
Current Year
Prior Year
Net To Date,
Revenue
$ 44.84
105,616.40
$ (1Q5,571.56)
Expenditure
$ -
107,111.49 -(107,131.49)
Subtotal
Net To Date,
$ 44.84
$
(1,515.09)
$ 1,559.93
Fund Number
25
Grant Fund
Current Year
Prior Year
Net To Date
Revenue
$ 985,171.38
$
696,133.37
$ 289,038.01
Expenditure
$ 1,159,147.00
$
832,407.09
$ 326,739,91
Subtotal
Net To Date:
$ (173,975A2)
$
(136127172)
$ (37,701.90)
Fund Number
26
Criminal Justice Div Grant Fd
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
$ 18,556,26
29,3012.01
$ (10,745,75)
Subtotal
Net To Date:
$
18,556.26
$
29,302.01
$ (10,745,75)
Fund Number
30l
Community Dvl iBlock Grant Fund
Current Year
Prior Year
Net To Date
Revenue
$ 1,883.05
$
3,349.04
$ (1,46_5199)
Expenditure
$ 51,247.41
$
66,107,165
$ (14,8160.24)
Subtotal
Net To Date:
-'$-(49,36436)
(62,758.61)
$ ]13,3'94.25
Fund Number
31
Home, Buyers Asst 2009
Current Year
Prior Year,
Net To Date
Revenue
$
4,3001.00
$ (4,300-00)
Expenditure
$
$
Subtotal
Net To Date:
$
$
4,300.00
$ .. 4,300,00)
Fund Number
32
Owner Occ Rehab #1001053
Current Year
Prior Year
Net To Date
Revenue
$
$
346,760.81
$ (346,760.81)
Expenditure
$
$
347,640.81
$ (34�7,640.81)
Subtotal
Net To Date:
$
$
(880.0-0)
-$ 8-80.00
Fund Number
33
Municipal Court Tech Fee
Current Year
Prior Year
Net To Date
Revenue
$ 10,904.85
$
10,863.43
$ 41.42
Expenditure
$ 8,112.15
$
6,411,17
$ 1-700.98
Subtotal
Net To Date:
$ 2,792.70
$
4,452.,26
Fund Number
34
Municipal Court Security Fee,
Current Year
Prior Year
Net To Date
Revenue
$ 8,488.70
$
8,355.24
$ 233.46
Expenditure
$ 6,397.33
$
5.78633
$ 600.60
Subtotal
Net To Date:
$ 2,101,37
$
(467A4)
Fund Number
35
Municipal Court Child Safe Fee
Current Year
Prior Year
Net To Date
Revenue
$ 706.19
$
1,192.05
$ (485,86)
Expenditure
$ 4,626.00
$
905.20
$ 3,720.80
Subtotal
Net To Date:
$ (3,919,81)
$
286.85,
$ --44,206.66)
Fund Number
36
Municipal Court! Time Pay Fee
Current Year
Prior Year
Net To Date
Revenue
2,031.08
$
1,993.35
$ 37.73
Expenditure
1,652.20
$
1,194.20
$ 458,00
Subtotal
Net To Date:
$ 378.88
799.15
$ (420.27)
Fund Number
37
Police Conf Fds-Gambling
Current Year
Prior, Year
Net To Date
Revenue
$ 59.45
$
3838
20.67
Expenditure
$ -
$1
$
Subtotal
Net To Date,:
59A5
$
38.78
$ 20.67
Fund Number
38
Police 3udicial Forfeitures
Current Year
Prior Year
Net To Date
Revenue
$ 22,676.78
$
(4,134.06)
26,8,10.84
Expenditure
17,612.34
$
8,45015
Subtotal
Net To Date:
$ 5,064.44
$
(12,584.31)
17,648.75
Fund Number
39,
Equitable Sharing Forfeitures
Current Year
Prior Year
Net To Date
Revenue
$ 1,328.00
$
49,317.40
$ (47,989,40)
Expenditure
$ 103,264.48
$
79,710.35
$ 23,554.13
Subtotal
Net To Date-,
-(x01,936.48)
(30,392.9,5)
$ (71,543.53)
Fund Number
40
CitV of Paris CO'93 Const Fund
Current Year
Prior Year
Net To Date
Revenue
$
Expenditure
$
$
Subtotal
Net To Date,.
$
$
$
Fund Number
41
Tax & Rev CO 2000 Const Fund
Current Year
Prior Year
Net To Date
Revenue
$
(44-64)
$ 44,64
Expenditure
------------
$
$
Subtotal
Net To Date:
$
$
(44.64)
44.64
Fund Number
42
CO Series 2002 Construction Fd
Current! Year
Prior Year
Net To Date
Revenue
$
$
$
Expenditure
$
$
$
Subtotal
Net To Date:
$
$
$
Fund Number
43
GO Bonds 2013 Construction Fd
Current Year
Prior Year
Net To Date
Revenue
$ 148,,192.12
$ (6,796,285.70)
$ 6,,944,477.82
Expenditure
�9,75�1,04.77�$(1�11,283.60)
$ 9,861,324.37
Subtotal
Net To Date:11
(9,601,848.65)
$
(6,685,002.10)
. ......
$ (2,916 84&55)
Fund Number
45
Land Fill
Current Year
Prior Year
Net To Date
Revenue
$ 1,055,280.36
$
1,048,00222
$ 7,278.14
Expenditure
$ 1,082,795.52
$
984,531.60
$ 98,26,3.92
Subtotal
Net To Date:
$ (27,515.16)
$
63,470.61
$ (90,985.78)
Fund Number
so
Revenue Bonds Sinking Funds
Current Year
Prior Year
Net To Date
Revenue
354,189.62
$
1,552,670-00
$ (1,198,480.38)
Expenditure
$ -
$
86,05.53
$ -(86,505.53)
Subtotal
Net To Date:
$ 354,189.62
$
1,466,164.47
$ (1j11,974.85)
Fund Number
Subtotal
Fund Number
Subtotal
Fund Number
Subtotal
Fund Number
Subtotal
Fund Number
Subtotal
Fund Number
Subtotal
Fund Number
Subtotal
Fund Number
51
Tx&RevCOs 2013 (TWDS) I&S Fund
Current Year
Prior Year
Net To Date
Revenue
$ 160,208.52
$ 82,166.68
$ 78,041.84
Expenditure
$ 170,046.50
$ 19,546.50
$ 15-0-,500.00
Net To Date:
$ (9,837.98)
6Z620.18
(72,458.16)
52
2012 GO Refunding Bond I&S
Current Year
Prior Year
Net To Date
Revenue
$
Expenditure
$
Net To Date.
$
$
53
Tax & Rev CO 2010 I&S Fund
Current Year
Prior Year
Net To Date
Revenue
$ 311,062.77
$ 216,013.86
$, 95,048,91
Expenditure
$ 216,903,.76
$ 216,685.01
$ 218.75
Net To Date,
$ 94,159.01
(671.15)
$ 94,830.16
54
City of Paris CO '93 I&S Fund
Current Year
Prior Year
Net To Date
Revenue
$
Expenditure
$
$
Net To Date:
$
$
$
55
Tax & Rev CO 2000 I&S Fund
Current Year
Prior Year
Net To Date
Revenue
$
Expenditure
$
Net To Date:
$
$
$
56
Tax & Rev CO 2.002 I&S Fundi
Current Year
Prior Year
Net To Date
Revenue
$ -
$
Expenditure
= ---------
Net To Date:
$
$
$
57 Contractual Oblig I&S Fund
Expenditure
Net To Date:
Current Year Prior Year Net To Date
58
2003 GO Refunding Bonds
Current Year
Prior Year
Net To Date
Revenue
$
Expenditure
Subtotal
Net To Date:
$
$
Fund Number
59
2010 GO' /W&5 Refunding, Bonds
Current Year
Prior Year
Net To Date
Revenue
$ 1,6,31,963.34
$ 401,900.13
$ 1,230,063.21
Expenditure
$ 1,192,050-00
$ 450,587.50
$ 741,462.50
Subtotal
Net To Date:-
$ 439,913.34
$ (48,687,37)
$ 488,600.71
Fun,d Number
60
Refunding Bonds 2012
Current Year
Prior Year
Net To Date
Revenue
$ 407,954.64
$ 408,627.44
$ (672.80)
Expenditure
$ 403,700.00
$ 405,750
$ (2,050.00)
Subtotal
NetTo Date-
4,254.64
2,877.44
$ 1,377.20
Fund Number
61
Interlocal Coop Agreement I&S
Current Year
Prior Year
Net To Date
Revenue
$ 97,734.66
$ 100,570.88
$ (2,836.22)
Expenditure
$ 100,826.95
$ 100,826.95
$
Subtotal
Net To Date:
(3,092.29)
$ (256.07)
$ (2,836.22)
Fund Number
62
G 0 Bonds 2013 I&S Fund,
Current Year
Prior Year
Net To Date
Revenue
$ 1,945,784.35,
$ (343,291.77)
$ 2,289,076,12
Expenditure
$ 2,188,975.00
$ 988,166,34
$ 1.200-808.66
Subtotal
Net To Date:
(243,190.65)
$ (1,331,458.11 -
$ 1,088,267.46
Fund Number
63
CO Bonds - 2015
Current Year
Prior Year
Net To Date
Revenue
$ 478,31172
$
478,313.72
Expenditure,
$ 144,548.86,
$
144,548.86
Subtotal
Net To Date:
$ 333:,764.86
$
333,764.86
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
$ 1,767.86
2,548.58
$ (780.72)
Expenditure
$ 4,425.10
$
19,137.06
$ 14,711,916)
Subtotal
Net To Date:
$ (2,657.24)
$
(16,588,48)
$ 13,931-24
Fund Number
73
3 A Love Trust Fundl
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 De,shong Trust Fund
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 8 & Kathryn Vaughan Memuoriall
Current Year
Prior Year
Net To Date
Revenue
$ -
$
$
Expenditure
--$ --------------------- -
Subtotal
Net To Date:
$
Fund Number
U-71
Subtotal
Fund Number
79
Subtotal
Fund NUmber
80
Subtotal
Mahone IH Love Memorial Fund Current Year Prior Year Net To Date
Revenue $ $
Expenditure $
Net To Date: $ $ $
Library Expendable Fund
Current Year
Prior Year
Net To Date
Revenue
1,454.75
$ 688.75
$ 766,00
Expenditure
$ 10,0001.00
$ (10,000.00,)
Net To Date:
1,454.79
$ 10,766,.00
Library Permanent Fund Current Year Prior Year Net To Date
Revenue 6.83 $ 764.54 $ (757,71)
Expenditure - $ - $
Net To Date. $ 6.83 $ 764.54 $ (757.711