Loading...
07 - Financial ReportItem No. 7 memorandum TO: City Council John Godwin, City Manager FROM: Gene Anderson, Finance Director SUBJECT: JANUARY 2019 FINANCIAL REPORT DATE: February 12, 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 January 2019 Financial Report Comments Net to Date Comparison of Revenues: 1. The operations and maintenance property tax and related collections are 0.19% less than this time last year. Current tax collections are 79.42% of the tax levy vs. 81.95% last year. 2. Sales taxes are up only 0.10% from last year. 3. Hotel occupancy taxes are up 6.69% from last year. All hotels are current on their taxes except America's Best Value Inn. The previous owner owes us for part of the 4th quarter tax. 4. Franchise fees are up 7.20% compared to last year. 5. Permit fees are down 35.09% from last year. This amounts to $27,040. 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 28.73% above last year's collections. This amounts to $21,466. 7. Other revenue includes leases, interest, copy fees, birth & death certificates, library fees, mixed beverage tax, and other minor revenues. This revenue is up 45.59% or $70,721. This comes mostly from collecting some delinquent lease payments and increase interest earnings. 8. Sanitation fees are down 5.21% compared to 2017 collections. This is only $6,071 and was expected with more of these fees going directly to the Sanitation Fund in this budget. 9. EMS fees are up 11.40% compared to last year. 10. Total General Fund revenues, net of any transfers, are 2.21% above last year. General Fund revenues equal 49.04% of the budget with the City being 33.33% through the budget year. 11. Total General Fund expenditures are up 2.52% compared to last year. General Fund expenditures to date equal 30.58% of budget with the City being 33.33% through the budget year. 12. Sewer revenue is up 6.29%. 13. Water revenue is down 3.31%, but is adversely affected by the billing adjustment to Lamar County Water Supply. Without that adjustment, water revenue would have been up 1.99%. November 2018 was the final month to be affected by the LCWS adjustment. 14. Total Water & Sewer revenues, ignoring transfers, are 0.63% above last year. 15. Total Water & Sewer expenses are 0.25% above last year at this point and represent 22.50% of the total budget (36.27% adjusted for debt payments)while the City is 33.33% through the budget year. Departmental Expenditure Summary: At this point the City is three months or 33.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 five departments whose expenditures are over 33.33%. 1. City Council -51.65%. The overage amounts to $16,462. This overage is due to the annual insurance payment, building maintenance, updating ordinance book, and membership fees. 2. EMS -44.37%. The overage amounts to $297,603 and is due to expenditures made on the new EMS station and a new ambulance. 3. General Expenses -36.41%. The overage amounts to $54,410 and is mainly due to payments made to the non-profit organizations and maintenance agreements. 4. Warehouse -35.64%. The overage amounts to $2,691 and is due to the annual insurance payment and the paving of the loading/unloading area. 5. Waste Water Plant -38.62%. The overage amounts to $136,021 and is due to work on the flow equalization bar screen. 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. 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 -January 2019 General Fund: Current Prior Net Report sort sequence Report Group Description Year Year To Date 70 Taxes Collected 6,033,966.18 6,045,969.16 -12,002.98 71 Sales Tax 2,381,378.79 2,378,955.93 2,422.86 72 Hotel/Motel Tax 335,738.22 314,671.11 21,067.11 73 Franchise Fees 1,060,591.07 989,324.20 71,266.87 74 Permits 50,015.21 77,055.99 -27,040.78 75 Court Fines 96,169.37 74,702.68 21,466.69 77 Other Revenue 225,843.82 155,122.79 70,721.03 78 Sanitation 110,370.65 116,441.81 -6,071.16 79 Ems Fees 1,005,353.50 902,440.06 102,913.44 84 W & 5 Admin Fees 321,316.68 314,650.00 6,666.68 Total Revenue: $ 11,620,743.49 $ 11,369,333.73 $ 251,409.76 Total Expenditures: $ 7,244,521.47 $ 7,066,319.29 $ 178,202.18 Net To Date: $ 4,376,222.02 $ 4,303,014.44 $ 73,207.58 Ems Fees Sanitation Other Revenue Court Fines Permits Franchise Fees Hotel/Motel Tax Sales Tax Taxes Collected 0.00 1,000,000.00 2,000,000.00 3,000,000.00 4,000,000.00 5,000,000.00 6,000,000.00 7,000,000.00 e Prior Year is Current Year Expenditures Fmd Wm6ar r General Fund Department Department Current Prior Current Prior Current Year Prior Year Number Name Montle 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 3,457.10 5,314.50 46,403.02 54,517.85 89,830.00 81,530.00 12 City Manager 28,775.92 29,561.40 109,887.42 113,855.14 395,806.00 392,116.00 13 City Attorney 19,628.64 16,215.49 90,655.67 75,411.80 349,688.00 347,968.00 14 Municipal Court 15,494.70 16,638.29 66,736.44 72,427.76 247,772.00 244,555.00 15 City Clerk 10,244.12 8,530.93 40,338.92 42,528.53 144,357.00 149,045.00 21 Accounting & Auditing 47,121.05 35,379.46 147,020.14 136,619.51 445,942.00 442,839.00 31 Police 473,510,77 558,067.24 1,921,202.26 2,036,320.55 6,538,662.00 6,396,659.00 32 Fire 440,127.75 466,393.52 1,545,990.17 1,550,950.57 5,085,669.00 4,916,871.00 40 Community Developm 24,518.17 22,513.67 83,949.96 110,229.04 451,84300 333,388.00 41 Engineering 32,711.50 26,971.00 122,508.92 107,495.79 420,501.00 505,066.00 42 Public Works 17,680.84 17,034.32 71,548.87 68,972.04 233,023.00 231,598.00 43 Parks,Recreation,& R( 78,408.27 80,798.95 250,915.71 141,626.41 1,252,319.00 11234,015.00 44 Sanitation 0.00 0.00 42.46 229.36 0.00 0.00 46 Streets & Highways 109,017.90 135,437.08 403,884.27 506,312.81 1,703,269.00 1,579,583.00 48 TratTit & Public Lighter 32,081.75 40,903.39 135,665.44 181,917.33 570,516.00 564,620.00 49 Garage 23,837.15 23,308.86 101,430.52 105,759.32 368,238.00 361,500.00 51 Paris -Lamar Co Health 0.00 1,878.00 0.00 1,878.00 0.00 0.00 54 Emergency Medical Se 410,255.76 217,012.67 1,195,399.05 859,839.87 2,693,657.00 2,685,200.00 61 Cox Feld Airport 7,583.51 8,150.76 46,145.37 42,974.42 138,850.00 117,650.00 62 Paris Bard 0.00 0.00 54.03 50.36 23,050.00 23,050.00 64 Library 57,032.58 65,634.73 222,881.47 242,437.55 721,328.00 733,179.00 89 General Expenses 35,092.01 79,410.17 641,861.36 613,965.28 1,762,529.00 1,670,615.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,00000 'total General Fund $1,866,579.49 $1,855,154.43 $7,244,521.47 $7,066,319.29 $23,686,849.00 $23,061,047.00 Other Sewer Water Water Sewer Fund: Revenue Group Water Sewer Other Total Revenue: Total Expenditures: Net To Date: Current Prior Net Year Year To Date 2,544,790.69 2,631,969.76 -87,179.07 2,028,502.35 1,908,439.98 120,062.37 187,072.60 190,032.99 -2,960.39 4,760,365.64 4,730,442.73 29,922.91 $ 3,387,157.00 $ 3,378,419.65 $ 8,737.35 $ 1,373,208.64 $ 1,352,023.08 $ 21,185.56 0.00 500,000.00 1,000,000.00 1,500,000.00 2,000,000.00 2,500,000.00 3,000,000.00 mu Prior Year uuui Current Year Expenditures Water/ Sewer Fund Fund Number 10 Water & Sewer Fund Department 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 7,417.50 4,729.71 41,418.70 35,120.03 98,334.00 107,294.00 81 W & S Billing and Collecting 210,433.40 186,673.66 785,412.60 737,095.70 2,230,827.00 2,187,749.00 82 Water Production 165,112.88 259,936.63 969,747.36 1,103,380.01 2,543,497.00 2,762,802.00 83 Water Distribution 78,762.13 119,594.97 389,175.72 503,981.22 1,463,827.00 1,367,033.00 85 Sewer Maintenance 54,269.99 56,842.99 203,355.83 203,100.73 721,939.00 600,118.00 86 Waste Water Treatment 224,749.95 197,262.78 992,291.95 695,774.87 2,127,000.00 2,036,450.00 87 Lift Stations 25,704.99 23,646.22 105,754.84 99,967.09 365,250.00 332,142.00 Total Water & Sewer Fund $766,450.84 $848,686.96 $3,387,157.00 $3,378,419.65 $9,550,674.00 $9,393,578.00 Fund Number 2 Economic Development Ful Current Year Prior Year Net To Date Revenue $ 478,651.16 $ 476,905.16 $ 1,746.00 Expenditure $ 227,706.69 $ 132,083.90 $ 95,622.79 Subtotal Net To Date: $ 750,944.47 $ 344,821.26 $ (93,876.79) Fund Number 11 Capital Projects Fund Current Year Prior Year Net To Date Revenue $ 5,974.64 $ 747,087.21 $ (741,112.57) Expenditure $ 51,559.56 $ 37,460.93 $ 14,098.63 Subtotal Net To Date: $ (45,384.92) $ 709,626.28 $ (755,211.20) Fund Number 12 WW&SS Rev Bond 2000 Cc Current Year Prior Year Net To Date Revenue $ - $ $ Expenditure $ $ $ Subtotal Net To Date: $ $ $ Fund Number 13 Equipment Replacement F4 Current Year Prior Year Net To Date Revenue $ 882.92 $ 57.14 $ 825.78 Expenditure $ $ $ Subtotal Net To Date: $ 882.92 $ 57.14 $ 825.78 Fund Number 14 CO 2010 Construction Funt Current Year Prior Year Net To Date Revenue $ $ 196.08 $ (196.08) Expenditure $ $ - $ Subtotal Net To Date: $ - $ 196.08 $ (196.08) Fund Number 16 TWDB Loan Fund Current Year Prior Year Net To Date Revenue $ 282.26 $ 198.65 $ 83.61 Expenditure $ $ - $ Subtotal Net To Date: $ 282.26 $ 196.65 $ 83.61 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 $ S $ Subtotal Net To Date: ; $ $ Fund Number 20 Special Revenue Fund Current Year Prior Year Net To Date Revenue $ $ $ Expenditure $ $ $ Subtotal Net To Date: # $ $ Fund Number 21 Child Safety Fund Current Year Prior Year Net To Date Revenue $ 15.85 $ 9.83 $ 6.02 Expenditure $ $ $ Subtotal Net To Date: ; 15.85 # 9.83 # 6.02 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 $ 29,934.44 $ 30,401.09 $ (466.65) Expenditure $ $ $ Subtotal Net To Date: $ 29,934A4 $ 30,401.09 $ (466.65) Fund Number 24 Lake Crook Restoration Ful Current Year Prior Year Net To Date Revenue $ 30.44 $ 21.43 $ 9.01 Expenditure $ $ $ Subtotal Net To Date: $ 30A4 $ 21.43 $ 9.01 Fund Number 25 Grant Fund Current Year Prior Year Net To Date Revenue $ 31,438.39 $ 173,480.50 $ (142,042.11) Expenditure $ 141,859.59 $ 345,202.71 $ (203,343.12) Subtotal Net To Date: $ (110,421.20) $ (171,722.21) $ 61,301.01 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 $ 7,316.52 $ 6,321.11 $ 995.41 Subtotal Net To Date: $ $ - $ - $ 7,315.52 $ 6,321.11 $ 995.41 Fund Number 30 Community Dvi Block Gran Current Year Prior Year Net To Date Revenue $ 1,799.30 $ 110,777.34 $ (108,978.04) Expenditure $ $ - $ Subtotal Net To Date: $ 1,799.30 $ 110,777.34 $ (108,978.04) 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 $ 3,300.55 $ 3,009.54 $ 291.01 Expenditure $ 861.75 $ 11,550.85 $ (10,689.10) Subtotal Net To Date: # 2,438.80 # (8,541.31) # 10,980.11 Fund Number 34 Municipal Court Security Ff Current Year Prior Year Net To Date Revenue $ 2,837.02 $ 2,421.42 $ 415.60 Expenditure $ 1,595.14 $ 1,830.18 $ (235.04) Subtotal Net To Date: ; 1,241.88 # 591.24 # 650.54 Fund Number 3S Municipal Court Child Safe Current Year Prior Year Net To Date Revenue $ 290.11 $ 290.28 $ (0.17) Expenditure $ - $ - $ - Subtotal Net To Date: ; 290.11 # 290.28 # (0.17) Fund Number 36 Municipal Court Time Pay F Current Year Prior Year Net To Date Revenue $ 774.55 $ 650.51 $ 124.04 Expenditure $ $ - $ - Subtotal Net To Date: # 774.55 # 650s1 # 124.04 Fund Number 37 Police Conf Fds-Gambling Current Year Prior Year Net To Date Revenue $ 40.38 $ 28.40 $ 11.98 Expenditure $ $ - $ Subtotal Net To Date: ; 40.38 ; 28A0 # 11.98 Fund Number 38 Police judicial Forfeitures Current Year Prior Year Net To Date Revenue $ 5,552.20 $ 3,621.88 $ 1,930.32 Expenditure $ $ 1,287.35 $ (1,287.35) Subtotal Net To Date: $ 5,552.20 $ 2,334.53 $ 3,217.67 Fund Number 39 Equitable Sharing Forfeitut Current Year Prior Year Net To Date Revenue $ 3,962.46 $ 392.75 $ 3,569.71 Expenditure $ 18,278.00 $ 4,385.02 $ 13,892.98 Subtotal Net To Date: $ (14,315.54) $ (3,992.27) $ (10,323.27) Fund Number 40 City of Paris CO'93 Const IF, Current Year Prior Year Net To Date Revenue $ $ $ Expenditure $ $ $ Subtotal Net To Date: $ - $ Fund Number 41 Tax 8t 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 Constructit Current Year Prior Year Net To Date Revenue $ 9,808.75 $ 62,320.23 $ (52,511.48) Expenditure $ 1,169,012.33 $ 3,583,647.63 $ (2,414,635.30) Subtotal Net To Date: $ (1,159,203.58) $ (3,521,327.40) $ 2,362,123.82 Fund Number 45 Land Fill Current Year Prior Year Net To Date Revenue $ 373,095.45 $ 372,586.41 $ 509.04 Expenditure $ 268,938.91 $ 312,076.99 $ (43,138.08) Subtotal Net To Date: # 104,156.54 $ 60,509A2 $ 43,647.12 Fund Number SO Revenue Bonds Sinking Fut Current Year Prior Year Net To Date Revenue $ 125,087.93 $ 121,040.17 $ 4,047.76 Expenditure $ $ - $ Subtotal Net To Data: $ 125,087.93 $ 121,040.17 $ 4,047.76 Fund Number 51 Tx&RevCOs 2013 (TWDB) I Current Year Prior Year Net To Date Revenue $ 61,127.07 $ 60,564.52 $ 562.55 Expenditure $ 9,773.25 $ 9,773.25 $ - Subtotal Net To Date: $ 51,353.82 $ 50,791.27 $ 562.55 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 Fui Current Year Prior Year Net To Date Revenue $ 173,766.54 $ 176,238.84 $ (2,472.30) Expenditure $ 179,326.88 $ 176,858.13 $ 2,468.75 Subtotal Net To Date: $ (5,560.34) $ (619.29) $ (4,941.05) Fund Number 54 City of Paris CO 193 I&S Ful 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&RevCO20021&SFui Current Year Prior Year Net To Date Revenue $ $ - $ " Expenditure $ $ $ Subtotal Net To Date: $ $ $ Fund Number 57 Contractual Oblig I&S Funr Current Year Prior Year Net To Date Expenditure $ $ " $ - Subtotal Met To Datw $ $ - $ - Fund Number 50 2003 GO Refunding Bonds Current Year Prior Year Net To Date Revenue $ $ $ Expenditure $ $ $ - Subtotal Net To : $ - $ Fund Number 59 2010 GOIW&S Refunding I Current Year Prior Year Net To Date Revenue $ 600,224.54 $ 618,798,93 $ (18,574.39) Expenditure $ 460.650.00 $ 467,862,50 $ (7,212.50) Subtotal Net To : $$_..._._ 139x574.54 $ 156,936.43 $ (11,361,89) Fund Number 60 Refunding Gonda 2012 Current Year Prior Year Net To Date Revenue $ 330,828.71 $ 332,682.01 $ (1,853.30) Expenditure $ 399,175.00 $ 387,825.00 $ 11,350. Subtotal Net To D $ (68,346.7.9) $ (55,142.99) $ (13,293.30) Fund Number 61 Interlocal Coop Agreement Current Year Prior Year Net To Date Revenue $ 79,730.64 $ 81,285.36 $ (1,554.72) Expenditure $ - S _ $ Subtotal Net To Date: $ 79,730.64 $ 81,285.36 $ (1.554.72) Fund Number 62 G O Bonds 2013I&S Fund Current Year Prior Year Net To Date Revenue $ 902,338.27 $ 602,217.88 $ 300,120.39 Expenditure $ 1,433,487.50 $ 1,473,987.50 $ (40,500.00) Subtotal Net To Date: $ (531,149.73) $ (871,769.62) $ 340,62039 Fund Number 63 CO Bonds - 2016 Current Year Prior Year Net To Date Revenue $ 292,706.60 $ 341,767.75 $ (49,061.15) Expenditure $ 585,317.50 $ 514,317.50 $ 71,000.00 Subtotal Net To Date: $ (292,610.90) $ (172,549.75) $ (120,061.15) Fund Number 64 CO Bonds - 2017 Current Year Prior Year Net To Date Revenue $ 501,990.13 $ 78.92 $ 501,911.21 Expenditure $ 133,051.69 $ 115,681.77 $ 17,369.92 Subtotal Net To Date: $ 368,938A4 $ (115,602.85) $ 484,541.29 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 $ $ S Subtotal Net To Date: $ $ $ Fund Number 72 Library Memorial Fund Current Year Prior Year Net To Date Revenue $ 919.67 $ 697.24 $ 222.43 Expenditure $ 2,103.33 $ 142.43 $ 1,960.90 Subtotal Net To Date: $ (1,183.66) $ W 554.81 $ (1,735.47) Fund Number 73 7 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 $ $ - $ 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 $ 648.46 $ 458.07 $ 190.39 Expenditure $ 295.00 $ - $ 295.00 Subtotal Net To Date: $ 353.46 $ 455.07 $ (104.61) Fund Number 8o Library Permanent Fund Current Year Prior Year Net To Date Revenue $ 4.64 $ 3.27 $ 1.37 Expenditure $ - $ - $ Subtotal Net To Date: $ 4.64 $ 3.27 $ 1.37