The URL can be used to link to this page

07 - December Financial ReportItem No. 7 memorandum TO: City Council John Godwin, City Manager FROM: Gene Anderson, Finance Director SUBJECT: DECEMBER 2018 FINANCIAL REPORT DATE: January 17, 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 December 2018 Financial Report Comments Net to Date Comparison of Revenues: 1. The operations and maintenance property tax and related collections are 6.88% more than this time last year. Current tax collections were 26.84% of the tax levy vs. 26.36% last year. Delinquent tax collections are also above last year's delinquent collections at this point. 2. Sales taxes are up only 2.74% from last year. 3. Hotel occupancy taxes are up 3.36% from last year. All hotels are current on their taxes. 4. Franchise fees are up 8.24% compared to last year. 5. Permit fees are down 42.11% from last year. This amounts to $29,407. There were several large new construction permits issued last year that were above our usual activity level. 6. Municipal Court fines and related fees are 23.39% above last year's collections. This amounts to $12,310. 7. Other revenue includes leases, interest, copy fees, birth & death certificates, library fees, mixed beverage tax, and other minor revenues. This revenue is up 18.92% or $28,396. This comes mostly from collecting some delinquent lease payments. 8. Sanitation fees are down 5.12% compared to 2017 collections. This is only $4,475 and was expected with more of these fees going directly to the Sanitation Fund in this budget. 9. EMS fees are up 15.37% compared to last year. 10. Total General Fund revenues, net of any transfers, are 6.17% above last year. General Fund revenues equal 26.99% of the budget with the City being 25.00% through the budget year. 11. Total General Fund expenditures are up 3.20% compared to last year. General Fund expenditures to date equal 22.70% of budget with the City being 25.00% through the budget year. 12. Sewer revenue is up 8.96%. 13. Water revenue is down 3.93%, but is adversely affected by the billing adjustment to Lamar County Water Supply. Without that adjustment, water revenue would have been up 2.93%. November 2018 was the final month to be affected by the LCWS adjustment. 14. Total Water & Sewer revenues, ignoring transfers, are 1.43% above last year. 15. Total Water & Sewer expenses are 3.59% above last year at this point and represent 17.41% of the total budget (31.17% adjusted for debt payments)while the City is 25.00% through the budget year. Departmental Expenditure Summary: At this point the City is three months or 25.00% 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 five departments whose expenditures are over 25.00%. 1. City Council -47.80%. The overage amounts to $20,488. This overage is due to the annual insurance payment, building maintenance, updating ordinance book, and membership fees. 2. EMS -29.14%. The overage amounts to $111,729 and is due to expenditures made on the new EMS station. 3. Cox Field Airport -27.77%. The overage amounts to $3,849 and is due to the annual insurance payment. 4. General Expenses -34.42%. The overage amounts to $166,137 and is mainly due to payments made to the non-profit organizations and maintenance agreements. 5. Waste Water Plant -29.87%. The overage amounts to $125,274 and is due to work on the flow equalization bar screen. General comments to the City Council: 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. I 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. 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. Mab City of Paris Fund Recap, for month ending -December 2018 General Fund: Current Prior Net Report Sort Sequence Report Group Description Year Year To Date 70 Taxes Collected 2,094,460.98 1,959,502.34 134,958.64 71 Sales Tax 1,847,864.94 1,798,455.59 49,409.35 72 Hotel/Motel Tax 188,476.26 182,347.34 6,128.92 73 Franchise Fees 904,718.17 835,798.73 68,919.44 74 Permits 40,411.69 69,819.07 -29,407.38 75 Court Fines 64,918.39 52,608.14 12,310.25 77 Other Revenue 178,442.23 150,045.43 28,396.80 78 Sanitation 82,902.06 87,377.57 -4,475.51 79 Ems Fees 755,848.51 655,103.55 100,744.96 84 W & S Admin Fees 240,987.51 235,987.50 5,000.01 Total Revenue: $ 6,399,030.74 $ 6,027,045.26 $ 371,985.48 Total Expenditures: $ 5,377,941.98 $ 5,211,164.86 $ 166,777.12 Net To Date: $ 1,021,088.76 $ 815,880.40 $ 205,208.36 Ems Fees Sanitation Other Revenue Court Fines Permits '.. Franchise Fees lllll�llllllllllllllllllll�lll��l�l�l Hotel/Motel Tax Sales Tax Taxes Collected 0.00 500,000.00 1,000,000.00 1,500,000.00 2,000,000.00 2,500,000.00 e Prior Year * Current Year Expenditures r„Nd N.� Department Department Number Name 0 Non -Departmental 11 City Coundl 12 City Manager 13 City Attorney 14 Municipal Court 15 City Clerk 21 Accounting & Auditin 31 Police 32 Fire 40 Community Develop 41 Engineering 42 Public Works 43 Parks,Recreation,& R 44 Sanitation 46 Streets & Highways 48 Traffic & Public Lighth 49 Garage 51 Paris -Lamar Co Hea" 54 Emergency Medical Se 61 Cox Field Airport 62 Paris Band 64 Library 89 General Expenses 90 Debt 91 Contingency Total General Fund i General Fund Current Month Actual _ 0.00__ 11,246.02 29,387.55 22,967.33 16,811.49 10,157.22 9 36,685.55 470,955.97 341,381.65 m 19,322.20 28,654.82 19,495.63 C 64,124.36 0.00 179,603.29 33,353.38 24,430.15 0.00 247,191.17 3,701.32 0.00 51,482.29 58,117.51 0.00 0.00 $1,669,068.90 Prior Month Actual 0.00 8,342.17 27,446.70 21,289.66 16,801.91 11,668.89 35,839.80 450,617.95 316,947.96 40,102.01 30,052.41 17,371.04 58,681.62 229.36 87,687.48 56,889.58 24,408.23 0.00 215,878.20 8,507.17 0.00 42,866.76 64,888.37 0.00 0.00 $1,536,517.27 Current Year To Date _0.00 42,945.92 81,111.50 71,027.03 51,241.74 30,094.80 99,899.09 1,447,691.49 1,105,862.42 59,431.79 89,797.42 53,868.03 172,507.44 42.46 294,866.37 103,583.69 77,593.37 0.00 785,143.29 38,561.86 54.03 165,848.89 606,769.35 0.00- 0.00 $5,377,941.98 Prior Year To Date 0.00 49,203.35 84,293.74 59,196.31 55,789.47 33,997.60 101,240.05 1,478,253.31 1,084,557.05 87,715.37 80,524.79 51,937.72 60,827.46 229.36 370,875.73 141,013.94 82,450.46 OAO 642,827.20 34,823.66 50.36 176,802.82 534,555.11 0.00 0.00 $5,211,164.86 Current Year Budget _0.00 89,830.00 395,806.DO 349,688.00 247,772.00 144,357.00 445,942.00 6,538,662.00 5,085,669.00 451,843.00 420,501.00 233,023.00 1,252,319.00 0.00 1,703,269.00 570,516.00 368,238.00 0.00 2,693,657.00 138,850.00 23,050.00 721,328.00 1,762,529.00 0.00 50,000.00 $23,686,849.00 Prior Year Budget 0.00 81,530.00 392,116.00 347,968.00 244,555.00 149,045.00 442,839.00 6,396,659.00 4,916,871.00 333,388.00 505,066.00 231,598.00 1,234,015.00 0.00 1,579,583.00 564,620.00 361,500.00 0.00 2,685,200.00 117,650AO 23,050.00 733,179.00 1,670,615.00 0.00 50,000.00 $23,061,047.00 Other Sewer Water Water Sewer Fund: Current Prior Net Revenue Group Year Year To Date Water 1,955,031.08 2,035,140.95 -80,109.87 Sewer 1,549,059.65 1,421,664.42 127,395.23 Other 148,332.53 143,986.12 4,346.41 Total Revenue: 3,652,423.26 3 3,600,791.49 51,631.77 Total Expenditures: $ 2,620,706.16 $ 2,529,732.69 $ 90,973.47 Net To Date: $ 1,031,717.10 $ 1,071,058.80 $ (39,341.70) 0.00 500,000.00 1,000,000.00 1,500,000.00 2,000,000.00 2,500,000.00 e Prior Year x Current Year Expenditures Water/ Sewer Fund Pffi r Year Fund Number 10 Water & Sewer Fund Prior Year _. -..—-------Department ._..--Department Current Year Prior -Year Number Name Month Month 80 Warehouse 7,716.63 11,727.44 81 W & 5 Billing and Collecting 194,409.71 184,544.68 82 Water Production 321,016.45 360,728.25 83 Water Distribution 101,960.36 133,786.64 85 Sewer Maintenance 57,466.45 52,467.24 86 Waste Water Treatment 342,809.36 143,661.40 87 Uft Stations 23,373.56 22,469.22 Total Water & Sewer Fund $1,048,752.52 $909,384.87 CurrentYear Pffi r Year Current Year Prior Year To Date To Date Budget Budget 34,001.20 30,390.32 98,334.00 107,284.00 574,979.20 550,422.04 2,230,827.00 2,187,749.00 704,634.48 843,443.38 2,543,497.00 2,762,802.00 310,413.59 384,386.25 1,463,827.00 1,367,033.00 149,085.84 146,257.74 721,939.00 600,118.00 767,542.00 498,512.09 2,127,000.00 2,036,450.00 80,049.85 76,320.87 365,250.00 332,142.00 $2,620,706.16 $2,529,732.69 $9,550,674.00 $9,393,578.00 Fund Number 2 Economic Development Fu Current Year Prior Year Net To Date Revenue $ 371,501.98 $ 360,514.24 $ 10,987.74 Expenditure $ 159,786.80 $ 90,522.41 $ 69,264.39 Subtotal Net To Date: $ 211,715.18 $ 269,991.83 $ (58,276.65) Fund Number 11 Capital Projects Fund Current Year Prior Year Net To Date Revenue $ 4,101.65 $ 745,415.47 $ (741,313.82) Expenditure $ 22,176.51 $ 18,016.21 $ 4,160.30 Subtotal Net To Date: $ (18,074.86) $ 727,399.26 $ (745,474.12) Fund Number 12 W W&SS Rev Bond 2000 Ca 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 $ 566.00 $ 6.20 $ 559.80 Expenditure $ $ - $ - Subtotal Net To Date: $ 566.00 $ 6.20 $ 559.80 Fund Number 14 CO 2010 Construction Funt Current Year Prior Year Net To Date Revenue $ $ 139.20 $ (139.20) Expenditure $ $ - $ Subtotal Net To Date: $ - $ 139.20 $ (139.20) Fund Number 16 TWDB Loan Fund Current Year Prior Year Net To Date Revenue $ 191.11 $ 141.02 $ 50.09 Expenditure $ $ - $ - Subtotal Net To Date: $ 191.11 $ 141.02 $ 50.09 Fund Number 17 Library Construction Fund Current Year Prior Year Net To Date Revenue $ - $ $ Subtotal Fund Number 18 Subtotal Fund Number 19 Subtotal Fund Number 20 Subtotal Fund Number 21 Subtotal Fund Number 22 Subtotal Fund Number 23 Expenditure $ $ $ Net To Date: $ - $ $ WBS 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 $ 10.73 $ 6.98 $ 3.75 Expenditure $ - $ Net To Date: $ 10.73 $ 6.98 $ 3.75 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 $ 16,209.35 $ 16,034.69 $ 174.66 Expenditure $ $ $ _ Subtotal Net TO Date: $ 16,209.35 $ 16,034.69 $ 174.66 Fund Number 24 Lake Crook Restoration Full Current Year Prior Year Net To Date Revenue $ 20.61 $ 15.21 $ 5.40 Expenditure $ - $ - $ _ Subtotal Net To Date: $ 20.61 $.... 15.21 $ SAO Fund Number 25 Grant Fund Current Year Prior Year Net To Date Revenue $ 31,438.39 $ 173,480.50 $ (142,042.11) Expenditure $ 130,837.88 $ 219,491.32 $ (88,653.44) Subtotal Net TO Date: $ (99,399.49) $ (46,010.82) $ (53,388.67) 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 $ 5,406.02 $ 4,730.17 $ 675.85 Subtotal Net To Date: $ - $ - $ 5,406.02 $ 4,730.17 $ 675.85 Fund Number 30 Community Dvl Block Gran Current Year Prior Year Net To Date Revenue $ 1,228.27 $ 110,463.95 $ (109,235.68) Expenditure $ - $ - $ Subtotal Net To Date: $ 1,220.27 $ 110,463.95 $ (109,235.68) Fund Number 31 Home Buyers Asst 2009 Current Year Prior Year Net To Date Revenue $ $ $ Expenditure $ $ $ _ Subtotal Net To Date: $ $ $ Fund Number 32 Owner Doc 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 $ 2,341.78 $ 2,248.37 $ 93.41 Expenditure $ 827.73 $ 624.20 $ 203.53 Subtotal Net To Date: ; 1,514.05 ; 1,624.17 ; (110.12) Fund Number 34 Municipal Court Security R Current Year Prior Year Net To Date Revenue $ 1,999.76 $ 1,793.82 $ 205.94 Expenditure $ 1,208.96 $ 1,391.62 $ (182.66) Subtotal Net To Date: $ 790.80 $ 402.20 $ 388.60 Fund Number 35 Municipal Court Child Safe Current Year Prior Year Net To Date Revenue $ 250.70 $ 222.35 $ 28.35 Expenditure $ $ - $ - Subtotal Net To Date: ; 250.70 $ 222.35 $ 28.35 Fund Number 36 Municipal Court Tlme Pay F Current Year Prior Year Net To Date Revenue $ 535.93 $ 482.17 $ 53.76 Expenditure $ $ $ Subtotal Net To Date: ; 535.93 $ 482.17 $ 53.76 Fund Number 37 Police Conf Fds-Gambling Current Year Prior Year Net To Date Revenue $ 27.34 $ 20.16 $ 7.18 Expenditure $ - $ - $ _ Subtotal Net To Date: $ 27.34 ; 20.16 $ 7.18 Fund Number 38 Police Judicial Forfeitures Current Year Prior Year Net To Date Revenue $ 5,456.02 $ 3,592.57 $ 1,863.45 Expenditure $ -...$ 112.35 $ (112.35) Subtotal Net To Date: $ 5,456.02 $ 3,480.22 $ 1,975.80 Fund Number 39 Equitable Sharing Forfeitur Current Year Prior Year Net To Date Revenue $ 3,893.21 $ 281.02 $ 3,612.19 Expenditure $ 18,278.00 $ 4,385.02 $ 13,892.98 Subtotal Net To Date: $ (14,384.79) $ (4,104.00) $ (10,280.79) 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 ConstructJt Current Year Prior Year Net To Date Revenue $ 7,129.94 $ 49,576.78 $ (42,446.84) Expenditure $ 1,161,086.97 $ 2,162,080.24 $ (1,000,993.27) Subtotal Net To Date: $ (1,153,957.03) $ (2,112,503.46) $ 958,546.43 Furl Number 45 Land Fill Current Year Prior Year Net To Date Revenue $ 280,565.99 $ 280,180.20 $ 385.79 Expenditure $ 194,328.42 $ 218,537.59 $ (24,209.17) Subtotal Net To Date: $ 86,237.57 $ 61,642.61 $ 24,594.96 Fund Number 50 Revenue Bonds Sinking Fui Current Year Prior Year Net To Date Revenue $ 95,717.58 $ 90,559.75 $ 5,157.83 Expenditure $ $ $ Subtotal Net To Date: $ 95,717.58 $ 90,559.75 ; 5,157.83 Fund Number 51 Tx&RevCOs 2013 (TWDB) l Current Year Prior Year Net To Date Revenue $ 45,797.56 $ 45,372.63 $ 424.93 Expenditure $ 9,773.25 $ 9,773.25 $ - Subtotal Net To Date: ; 36,024.31 $ 35,599.38 $ 424.93 Fund Number 52 2012 60 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 Fui Current Year Prior Year Net To Date Revenue $ 60,415.25 $ 57,230.96 $ 3,184.29 Expenditure _$ 179,326.88 $ 176,858.13 $ 2,468.75 Subtotal Net To Date: $ (118,911.63) $ (119,627.17) $ 715.54 Fund Number 54 City of Paris CO '93 I&S Fm 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 $ M $ $ Subtotal Net To Date: $ - $ - $ _ Fund Number 56 Tax & Rev CO 2002 I&S Fui 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 $ $ $ Subtotal Net To Date: $ $ $ Fund Number 59 2010 GO/W&S Refunding E Current Year Prior Year Net To Date Revenue $ 313,409.40 $ 307,456.97 $ 5,952.43 Expenditure $ 459,900.00 $ 467,862.50 $ (7,962.50) Subtotal Net To Date: $ (146,490.60) $ (160,405.53) $ 13,914.93 Fund Number 60 Refunding Bonds 2012 Current Year Prior Year Net To Date Revenue $ 114,916.14 $ 108,814.83 $ 6,101.31 Expenditure $ 398,675.00 $ 387,825.00 $ 10,850.00 Subtotal Net To Date: $ (283,758.86) $ (279,010.17) $ (4,748.69) Fund Number 61 Interlocal Coop Agreement Current Year Prior Year Net To Date Revenue $ 27,337.53 $ 26,266.94 $ 1,070.59 Expenditure $ $ $ _ Subtotal Net To Date:$ 27,337.53 $ 26,266.94 1,070.59 Fund Number 62 G O Bonds 2013 I&S Fund Current Year Prior Year Net To Date Revenue $ 726,815.49 $ 452,217.88 $ 274,597.61 Expenditure $ 1,433,487.50 $ 1,473,987.50 $ (40,500.00) Subtotal Net To Date: $ (706,672.01) $ (1,021,769.62) $ 315,097.61 Fund Number 63 CO Bonds - 2016 Current Year Prior Year Net To Date Revenue $ 227,518.00 $ 281,492.25 $ (53,974.25) Expenditure $ 585,317.50 $ 514,317.50 $ 71,000.00 Subtotal Net To Date: _ $ (357,799.50) $ (232,825.75) $ (124,974.25) Fund Number 64 CO Bonds - 2017 Current Year Prior Year Net To Date Revenue $ 171,973.27 $ 78.92 $ 171,894.35 Expenditure $ 133,051.69 $ 115,681.77 $ 17,369.92 Subtotal Net To Date: $ 38,921.58 $ (115,60LBS) $ 154,524.43 Fund Number 70 Employees Insurance Fund Current Year Prior Year Net To Date Revenue $ $ $ Expenditure S $ $ 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 $ 779.91 $ 457.19 $ 322.72 Expenditure $ 2,072.53 $ 21.40 $ 2,051.13 Subtotal Net To Date: ; (1,292.62) $ 435.79 ¢ (1,728.41) Fund Number 73 3 A Love Trust Fund Current Year Prior Year Net To Date Revenue $ $ $ Expenditure $ $ $ - Subtotal Net To Date: $ $ $ Fund Number 74 7 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 $ $S $ Expenditure $ - $ - Subtotal Net To Date: $ $ $ Fund Number 78 Malone H Love Memorial R Current Year Prior Year Net To Date Revenue $ $ $ Expenditure $ $ $ Subtotal Net To Date: $ $ $ Fund Number 79 Library Expendable Fund Current Year Prior Year Net To Date Revenue $ 439.05 $ 325.19 S 113.86 Expenditure $ 295.00 $ - $ 295.00 Subtotal Net To Date: $ 144.05 $ 325.19 $ (181.14) Fund Number 80 Library Permanent Fund Current Year Prior Year Net To Date Revenue $ 3.14 $ 2.32 $ 0.82 Expenditure $ $ $ Subtotal Net To Date: ; 3.14 $ 2.32 ; 0.82