HomeMy Public PortalAbout20130827 finance packet
Notice of Meeting and Tentative Agenda
CITY OF JEFFERSON
Finance Committee
Tuesday, August 27, 2013 at 7:30 AM
City Hall, 320 E. McCarty Street, Jefferson City, MO ~ Boone-Bancroft Room
TENTATIVE AGENDA
1. Call to Order
2. Roll Call
3. Approval of the minut es of the April 15, 2013 meeting and July 23, 2013 meeting
4. Financial Reports – Bill Betts
5. Lodging Tax Report – Shiela Pearre
6. Callaway County Tax Collection Agreement – Drew Hilpert
7. Economic Incentives Ordinance – Drew Hilpert
8. New Business
9. Old Business
10. Adjournment
NOTES
Individuals should contact the ADA Coordinator at (573) 634 -6570 to request accommodations or alternative
formats as required under the Americans with Disabilities Act. Please allow three business days process the request.
Minutes of Meeting
Jefferson City Finance Committee
Monday, April 15, 2013
Immediately following 6:00 PM City Council Meeting
City Hall - 320 E. McCarty Street
City Council Chambers
Mayor Eric Struemph asked Councilman Shawn Schulte to convene the meeting
for the purpose of electing officers.
Members of the Committee present:
Present: Bray, Graham, Prather, Schulte, and Scrivner
Absent: None
Councilman Schulte convened the meeting at 8:55 P.M., and opened the floor for
nominations of Chairman and Vice-Chairman.
Chairman - Councilman Ralph Bray nominated Councilman Shawn Schulte as
Chairman. There being no further nominations made, Councilman Schulte was
elected unanimously.
Vice-Chairman – Councilman Bob Scrivner nominated Councilman Ralph Bray
as Vice-Chairman. There being no further nominations made, Councilman Bray
was elected unanimously.
There being no further business brought before the Committee at this time, a
motion was made by Councilman Rick Prather for a djournment, seconded by
Councilman Shawn Schulte, and approved unanimously at 9:00 P.M.
CITY OF JEFFERSON
Finance Committee Meeting
Tuesday, July 23, 2013
MINUTES
The meeting was called to order by the Finance Committee Chairman, Councilman Shawn Schulte at 7:30 AM.
Roll call showed that Councilmen Schulte, Graham, Prather, Scrivner and Bray were in attendance.
The minutes of the June 25, 2013 meeting were reviewed and a motion to approve was made by Councilman
Graham and seconded by Councilman Prather. The minutes were approved unanimously.
The next item on the agenda was a report by Interim Finance Director, Bill Betts, covering the Financial Reports
for July. This report provided information on sales tax figures, year-to-date general ledger account information,
and the current fund balance calculation.
The next item on the agenda was a report by the Interim Finance Director, Bill Betts, covering the newly
provided Income Statement Report. Councilman Scrivner requested that any anomalies be highlighted in future
presentations.
The next item on the agenda was a report by the Chief Accountant, Shiela Pearre, covering the Lodging Tax
receipts to date. 4/7 of the Lodging tax collected during the timeframe where the rate has been 7% is
$1,214,513.49. The average monthly amount collected for the Conference Center Fund is $48,580.54. The
committee requested a document that shows how the $9,000,000 funding figure was arrived at.
The next item on the agenda was a presentation by Bob Volmert, ALPLA plant manager, regarding the GRUT
exemption. Specifically Mr. Volmert wants the GRUT exemption to be approved for ALPLA, and stated that if
the exemption was approved for ALPLA they would make no retroactive claim. ALPLA believes that since
they started the process of seeking the GRUT exemption prior to the approval of Bill No. 2012-83, which
essentially removed any exemption unless exempt status was obtained prior to November 15, 2012, they should
still be eligible to receive exempt status. The Committee requested that this issue be added to next month’s
agenda for further discussion.
There was no New Business.
The next item on the agenda was Old Business. City Counselor, Drew Hilpert, again spoke about the need for a
general Economic Development Incentives Policy. The Committee requested that this issue be added to next
month’s agenda for further discussion.
A motion to adjourn was made by Councilman Scrivner and seconded by Councilman Graham. Adjournment
took place at 8:22 AM.
As recorded by:
Shiela Pearre, Chief Accountant
Memo
To:Nathan Nickolaus
From:Shiela Pearre
Date:August 7, 2013
Re:Sales Tax Revenues
The City received the August 1% Sales Tax in the amount of $546,351 which is $10,681 less
than projected for August. January through August shortage is $31,034 (0.32%) in the
General Fund.
1% General Sales Tax
Receipt Budget Actual
Period Projection Receipts Variance
Nov-12 Jan-13 $764,659 $764,659 $0
Dec-12 Feb-13 $703,181 $703,181 $0
Jan-13 & Oct-Dec 12 Qtrly Mar-13 $992,559 $1,008,111 $15,552
Feb-13 Apr-13 $852,412 $777,424 ($74,988)
Mar-13 May-13 $567,215 $537,141 ($30,074)
Apr-13 & Jan-Mar 13 Qtrly Jun-13 $1,028,514 $1,023,015 ($5,499)
May-13 Jul-13 $797,780 $872,436 $74,656
Jun-13 Aug-13 $557,032 $546,351 ($10,681)
Jul-13 & Apr-June 13 Qtrly Sep-13 $1,069,414 $0
Aug-13 Oct-13 $769,129 $0
Sep-13 Nov-13 $615,421 $0
Oct-13 & Jul-Sept 13 Qtrly Dec-13 $982,684 $0
Total Overage/Shortfall ($31,034)
1/2% Capital Improvement Tax
Receipt Budget Actual
Period Projection Receipts Variance
Nov-12 Jan-13 $416,244 $372,459 ($43,785)
Dec-12 Feb-13 $311,418 $350,813 $39,395
Jan-13 & Oct-Dec 12 Qtrly Mar-13 $471,169 $475,110 $3,941
Feb-13 Apr-13 $413,147 $372,340 ($40,806)
Mar-13 May-13 $266,340 $266,422 $82
Apr-13 & Jan-Mar 13 Qtrly Jun-13 $499,328 $483,070 ($16,258)
May-13 Jul-13 $393,021 $425,325 $32,305
Jun-13 Aug-13 $280,801 $272,603 ($8,199)
Jul-13 & Apr-June 13 Qtrly Sep-13 $508,966 $0
Aug-13 Oct-13 $370,760 $0
Sep-13 Nov-13 $268,825 $0
Oct-13 & Jul-Sept 13 Qtrly Dec-13 $499,983 $0
Total Overage/Shortfall ($33,325)
1/2% Parks Sales Tax
Receipt Budget Actual
Period Projection Receipts Variance
Nov-12 Jan-13 $396,815 $372,447 ($24,368)
Dec-12 Feb-13 $407,348 $350,714 ($56,634)
Jan-13 & Oct-Dec 12 Qtrly Mar-13 $280,734 $475,026 $194,292
Feb-13 Apr-13 $452,735 $372,242 ($80,493)
Mar-13 May-13 $315,030 $266,456 ($48,574)
Apr-13 & Jan-Mar 13 Qtrly Jun-13 $439,265 $482,382 $43,117
May-13 Jul-13 $468,387 $425,194 ($43,193)
Jun-13 Aug-13 $282,836 $272,321 ($10,515)
Jul-13 & Apr-June 13 Qtrly Sep-13 $482,150 $0
Aug-13 Oct-13 $382,115 $0
Sep-13 Nov-13 $264,735 $0
Oct-13 & Jul-Sept 13 Qtrly Dec-13 $495,470 $0
Total Overage/Shortfall ($26,369)
Period
Reporting
Period
Reporting
Period
Reporting
City of Jefferson, Mo. - Account Analysis
Printed 8/7/2013
Account Name General Fund Sales Tax Rate:One percent (1%)Receipt Month: AUGUST 2013
Account Number 10-100-400010
Monthly
REPORTING PERIOD RECEIPT PERIOD 2008 2009 2010 2011 2012 2013 Average
Nov January 860,921 787,676 928,460 809,385 843,061 764,659 act.845,901
Dec February 630,186 572,813 631,137 833,919 619,287 703,181 act.657,468
Jan & Oct-Dec Qtrly March 1,076,395 1,079,246 894,158 589,958 992,559 1,008,111 act.926,463
Feb April 836,513 763,906 774,964 978,391 852,653 777,424 act.841,286
Mar May 445,903 516,016 592,657 633,676 530,069 537,141 act.543,664
Apr & Jan-Mar Qtrly June 1,103,170 934,660 843,712 925,555 1,028,514 1,023,015 act.967,122
May July 821,905 686,153 939,495 955,495 797,785 872,436 act.840,167
Jun August 485,766 526,097 495,667 566,299 557,032 546,351 act.526,172
Jul & Apr-Jun Qtrly September 1,102,826 1,006,120 1,040,156 1,032,258 1,069,414 1,069,414 est.1,050,155
Aug October 788,085 718,480 822,163 797,510 769,129 769,129 est.779,073
Sept November 486,258 554,824 482,807 536,185 615,421 615,421 est.535,099
Oct & Jul-Sept Qtrly December 926,760 801,780 881,780 1,032,046 982,684 982,684 est.925,010
Actual to Date $ 9,564,688 $ 8,947,771 $ 9,327,157 $ 9,690,677 $ 9,657,608 6,232,319
Estimated to Fiscal Year end (based on averages and on Budgeted amount)3,436,648
Total Actual & Estimated $ 9,668,967
Less: Budget 9,700,000
Over (Under) Budget -$ 31,033
$ 764,659.19
$ 1,467,840.39
$ 2,475,951.79
$ 3,253,375.33
$ 3,790,516.42
$ 4,813,531.75
$ 5,685,967.41
$ 6,232,318.77
$ 764,659.00
$1,467,840.00
$2,460,399.00
$3,312,811.00
$3,880,026.00
$4,908,540.00
$5,706,320.00
$6,263,352.00
$7,332,766.00
$8,101,895.00
$8,717,316.00
$9,700,000.00
$ 500,000.00
$ 750,000.00
$ 1,000,000.00
$ 1,250,000.00
$ 1,500,000.00
$ 1,750,000.00
$ 2,000,000.00
$ 2,250,000.00
$ 2,500,000.00
$ 2,750,000.00
$ 3,000,000.00
$ 3,250,000.00
$ 3,500,000.00
$ 3,750,000.00
$ 4,000,000.00
$ 4,250,000.00
$ 4,500,000.00
$ 4,750,000.00
$ 5,000,000.00
$ 5,250,000.00
$ 5,500,000.00
$ 5,750,000.00
$ 6,000,000.00
$ 6,250,000.00
$ 6,500,000.00
$ 6,750,000.00
$ 7,000,000.00
$ 7,250,000.00
$ 7,500,000.00
$ 7,750,000.00
$ 8,000,000.00
$ 8,250,000.00
$ 8,500,000.00
$ 8,750,000.00
$ 9,000,000.00
$ 9,250,000.00
$ 9,500,000.00
$ 9,750,000.00
$ 10,000,000.00
$ 10,250,000.00
Nov Dec Jan & Oct-
Dec Qtrly
Feb Mar Apr & Jan-
Mar Qtrly
May Jun Jul & Apr-
Jun Qtrly
Aug Sept Oct & Jul-
Sept Qtrly
REPORTING PERIOD
YTD Actuals vs. YTD Budget
Actual
Budget
City of Jefferson, Mo. - Account Analysis
Printed 8/7/2013
Account Name Capital Imprs Sales Tax Rate:One-Half percent (½%)Receipt Month: AUGUST 2013
Account Number 44-100-400010 F - effective 4/1/12
Monthly
REPORTING PERIOD RECEIPT PERIOD 2008 2009 2010 2011 2012 2013 Average
Nov January 416,277 384,327 455,480 396,799 412,434 372,459 act.413,063
Dec February 313,830 286,909 313,836 407,407 308,567 350,813 act.326,110
Jan & Oct-Dec Qtrly March 508,380 505,185 415,473 280,758 466,856 475,110 act.435,331
Feb April 400,771 365,514 370,473 452,824 409,365 372,340 act.399,790
Mar May 221,579 257,313 295,545 315,165 263,902 266,422 act.270,701
Apr & Jan-Mar Qtrly June 527,104 453,788 400,667 439,298 494,757 483,070 act.463,123
May July 403,495 326,501 462,244 468,643 389,423 425,325 act.410,061
Jun August 241,889 261,707 247,260 282,859 278,231 272,603 act.262,389
Jul & Apr-Jun Qtrly September 530,392 481,799 495,398 482,244 504,307 508,966 est.498,828
Aug October 381,230 348,002 395,058 382,206 367,366 370,760 est.374,772
Sept November 241,897 276,487 240,417 266,364 306,968 268,825 est.266,427
Oct & Jul-Sept Qtrly December 447,485 384,320 428,058 495,406 469,095 499,983 est.444,873
Actual to Date $ 4,634,329 $ 4,331,852 $ 4,519,908 $ 4,669,974 $ 4,671,272 3,018,142
Estimated to Fiscal Year end (based on averages and on Budgeted amount)1,648,534
Total Actual & Estimated $ 4,666,676
Less: Budget 4,700,002
Over (Under) Budget -$ 33,326
$ 372,458.69
$ 723,271.57
$ 1,198,381.28
$ 1,570,721.73
$ 1,837,144.01
$ 2,320,213.81
$ 2,745,539.17
$ 3,018,141.84
$ 416,244.00
$727,662.00
$1,198,831.00
$1,611,978.00
$1,878,318.00
$2,377,646.00
$2,770,667.00
$3,051,468.00
$3,560,434.00
$3,931,194.00
$4,200,019.00
$4,700,002.00
$ 100,000.00
$ 350,000.00
$ 600,000.00
$ 850,000.00
$ 1,100,000.00
$ 1,350,000.00
$ 1,600,000.00
$ 1,850,000.00
$ 2,100,000.00
$ 2,350,000.00
$ 2,600,000.00
$ 2,850,000.00
$ 3,100,000.00
$ 3,350,000.00
$ 3,600,000.00
$ 3,850,000.00
$ 4,100,000.00
$ 4,350,000.00
$ 4,600,000.00
$ 4,850,000.00
$ 5,100,000.00
Nov Dec Jan & Oct-
Dec Qtrly
Feb Mar Apr & Jan-
Mar Qtrly
May Jun Jul & Apr-
Jun Qtrly
Aug Sept Oct & Jul-
Sept Qtrly
REPORTING PERIOD
YTD Actuals vs. YTD Budget
Actual
Budget
City of Jefferson, Mo. - Account Analysis
Printed 8/7/2013
Account Name Parks Sales Tax Rate:One-Half percent (½%)Receipt Month: AUGUST 2013
Account Number 21-210-400010
Monthly
REPORTING PERIOD RECEIPT PERIOD 2008 2009 2010 2011 2012 2013 Average
Nov January 416,569 384,305 455,442 396,815 405,730 372,447 act.411,772
Dec February 313,259 286,889 313,792 407,348 308,456 350,714 act.325,949
Jan & Oct-Dec Qtrly March 508,249 507,768 415,275 280,734 466,713 475,026 act.435,748
Feb April 400,606 365,727 370,308 452,735 409,353 372,242 act.399,746
Mar May 220,821 256,675 295,529 315,030 263,822 266,456 act.270,375
Apr & Jan-Mar Qtrly June 527,025 453,016 400,500 439,265 494,733 482,382 act.462,908
May July 402,482 326,518 461,255 468,387 389,006 425,194 act.409,530
Jun August 241,656 261,622 247,216 282,836 278,072 272,321 act.262,280
Jul & Apr-Jun Qtrly September 530,352 481,772 495,222 482,150 505,913 482,150 est.499,082
Aug October 381,309 347,721 395,014 382,115 366,846 382,115 est.374,601
Sept November 243,796 275,469 240,348 264,735 306,831 264,735 est.266,236
Oct & Jul-Sept Qtrly December 446,797 384,300 428,200 495,305 468,924 495,470 est.444,705
Actual to Date $ 4,632,921 $ 4,331,782 $ 4,518,100 $ 4,667,453 $ 4,664,400 3,016,781
Estimated to Fiscal Year end (based on averages and on Budgeted amount)1,624,470
Total Actual & Estimated $ 4,641,251
Less: Budget 4,667,620
Over (Under) Budget -$ 26,369
$ 372,446.56
$ 723,160.39
$ 1,198,185.94
$ 1,570,427.84
$ 1,836,884.14
$ 2,319,266.06
$ 2,744,459.67
$ 3,016,780.80
$ 396,815.00
$804,163.00
$1,084,897.00
$1,537,632.00
$1,852,662.00
$2,291,927.00
$2,760,314.00
$3,043,150.00
$3,525,300.00
$3,907,415.00
$4,172,150.00
$4,667,620.00
$ 100,000.00
$ 350,000.00
$ 600,000.00
$ 850,000.00
$ 1,100,000.00
$ 1,350,000.00
$ 1,600,000.00
$ 1,850,000.00
$ 2,100,000.00
$ 2,350,000.00
$ 2,600,000.00
$ 2,850,000.00
$ 3,100,000.00
$ 3,350,000.00
$ 3,600,000.00
$ 3,850,000.00
$ 4,100,000.00
$ 4,350,000.00
$ 4,600,000.00
$ 4,850,000.00
$ 5,100,000.00
Nov Dec Jan & Oct-
Dec Qtrly
Feb Mar Apr & Jan-
Mar Qtrly
May Jun Jul & Apr-
Jun Qtrly
Aug Sept Oct & Jul-
Sept Qtrly
REPORTING PERIOD
YTD Actuals vs. YTD Budget
Actual
Budget
General Ledger
Trial Balance by Full Acct Number
User: spearre
Printed: 08/19/13 08:34:36
Period 01 - 13
Fiscal Year 2013
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10 General Fund
Revenue Revenue
100 Revenue
10-100-400010 Sales Tax 9,700,000.00 6,232,318.77 0.00 3,467,681.23 35.75
10-100-400020 Sales Tax Interest 0.00 0.00 0.00 0.00 0.00
R10 Sales & Use Taxes 9,700,000.00 6,232,318.77 0.00 3,467,681.23 35.75
10-100-401030 Motor Vehicle Sales Tax 403,750.00 263,636.35 0.00 140,113.65 34.70
R15 Motor Vehicle Sales Tax 403,750.00 263,636.35 0.00 140,113.65 34.70
10-100-403010 Gasoline Tax 1,100,950.00 621,607.82 0.00 479,342.18 43.54
10-100-403020 Cigarette Tax 147,000.00 85,413.44 0.00 61,586.56 41.90
R20 Other Taxes 1,247,950.00 707,021.26 0.00 540,928.74 43.35
10-100-410020 Electric Utility Lic Tax 3,225,000.00 2,030,669.33 0.00 1,194,330.67 37.03
10-100-410021 Electric Utility-AUDIT 0.00 0.00 0.00 0.00 0.00
10-100-410030 Gas Utility License Tax 900,000.00 815,079.15 0.00 84,920.85 9.44
10-100-410031 Gas Utility-AUDIT 0.00 0.00 0.00 0.00 0.00
10-100-410050 Telephone Utility Lic Tax 0.00 0.00 0.00 0.00 0.00
10-100-410051 Cell Phone Utility Tax 0.00 0.00 0.00 0.00 0.00
10-100-410052 TelephoneCell Utility Tax 2,825,000.00 1,598,879.47 0.00 1,226,120.53 43.40
10-100-410053 TelephoneCell Utility-AUDIT 110,000.00 91,130.20 0.00 18,869.80 17.15
10-100-410060 Cable Franchise Fee 325,000.00 255,179.84 0.00 69,820.16 21.48
10-100-410061 Cable Utility-AUDIT 0.00 0.00 0.00 0.00 0.00
R30 Franchise & Utility Tax 7,385,000.00 4,790,937.99 0.00 2,594,062.01 35.13
10-100-420010 Cur Property Tax 4,600,000.00 4,559,886.24 0.00 40,113.76 0.87
10-100-420020 Del Property Tax 50,000.00 41,925.20 0.00 8,074.80 16.15
10-100-420040 Fin Inst Tax 30,000.00 30,689.00 0.00 -689.00 -2.30
10-100-420050 Prop Tax Int & Penalties 16,000.00 23,002.21 0.00 -7,002.21 -43.76
10-100-420055 Surtax Receipts - County Reimb 54,000.00 54,399.28 0.00 -399.28 -0.74
10-100-420060 Surtax Receipts 450,000.00 473,502.77 0.00 -23,502.77 -5.22
10-100-420080 Special Tax Rev 21,000.00 14,038.54 0.00 6,961.46 33.15
R40 Property Taxes 5,221,000.00 5,197,443.24 0.00 23,556.76 0.45
10-100-430010 Federal Grants 1,748,895.20 344,563.21 0.00 1,404,331.99 80.30
GL - Trial Balance by Full Acct Number (08/19/2013 - 8:34 AM)Page 1
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-100-430020 State Grants 11,010.00 0.00 0.00 11,010.00 100.00
10-100-430040 Local Grants 15,594.00 22,146.60 0.00 -6,552.60 -42.02
10-100-430055 DARE Contributions 0.00 0.00 0.00 0.00 0.00
10-100-430060 Drug Forfeiture 0.00 25,943.21 0.00 -25,943.21 0.00
10-100-430074 Overtime Reimb 0.00 0.00 0.00 0.00 0.00
10-100-430080 Road & Bridge Tax 550,000.00 551,540.67 0.00 -1,540.67 -0.28
10-100-430100 State DNR Historic Pres.0.00 0.00 0.00 0.00 0.00
R50 Intergovernmental 2,325,499.20 944,193.69 0.00 1,381,305.51 59.40
10-100-440010 Admin Charge Backs 1,225,660.00 914,030.61 0.00 311,629.39 25.43
10-100-440050 Emt Reimbursement 35,000.00 0.00 0.00 35,000.00 100.00
10-100-440210 Street Cuts 25,000.00 21,343.00 0.00 3,657.00 14.63
10-100-440910 Fuel Charge-backs 364,590.00 259,322.76 0.00 105,267.24 28.87
10-100-440920 Parts Charge-back 170,610.00 113,038.18 0.00 57,571.82 33.74
10-100-440930 Labor Charge-backs 167,800.00 94,196.75 0.00 73,603.25 43.86
R60 Charges for Services 1,988,660.00 1,401,931.30 0.00 586,728.70 29.50
10-100-450010 Liquor Licenses 60,000.00 63,843.33 0.00 -3,843.33 -6.41
10-100-450020 Business Licenses 233,800.00 193,276.01 0.00 40,523.99 17.33
10-100-450021 Home Occupation Permit 1,500.00 1,458.00 0.00 42.00 2.80
10-100-450030 Soliciters Licenses 0.00 0.00 0.00 0.00 0.00
10-100-450040 Abandoned Bldg Registration 0.00 715.31 0.00 -715.31 0.00
10-100-450041 Abandoned Bldg Admin Fee 0.00 1,838.60 0.00 -1,838.60 0.00
10-100-450045 Bldg Constr Fees 150,000.00 115,761.67 0.00 34,238.33 22.83
10-100-450050 Electrical Certificates 20,000.00 16,171.00 0.00 3,829.00 19.15
10-100-450060 Electrical Permits 2,500.00 2,623.22 0.00 -123.22 -4.93
10-100-450070 Plumbing Licenses 12,000.00 10,058.00 0.00 1,942.00 16.18
10-100-450080 Plumbing Permits 7,500.00 4,800.00 0.00 2,700.00 36.00
10-100-450090 Other Lic & Permits 1,500.00 1,600.00 0.00 -100.00 -6.67
10-100-450091 Day Care Inspection Fees 8,000.00 5,580.00 0.00 2,420.00 30.25
10-100-450092 Food Inspection Fees 88,000.00 88,186.99 0.00 -186.99 -0.21
10-100-450100 Curb Cut Permits 700.00 850.00 0.00 -150.00 -21.43
10-100-450110 Board Of Adj Fees 800.00 2,600.00 0.00 -1,800.00 -225.00
10-100-450120 Sign Permits 4,000.00 3,328.00 0.00 672.00 16.80
10-100-450130 Demolition Permits 500.00 658.00 0.00 -158.00 -31.60
10-100-450150 Acc Rep Fees-police 12,000.00 10,028.45 0.00 1,971.55 16.43
10-100-450160 Accrptblastg P-fire 2,000.00 516.00 0.00 1,484.00 74.20
10-100-450170 Animal Redemption Fees 53,000.00 40,960.00 0.00 12,040.00 22.72
10-100-450180 Animal Vaccinations Fees 2,800.00 4,565.00 0.00 -1,765.00 -63.04
10-100-450185 Animal Cremation Fees 15,000.00 19,450.00 0.00 -4,450.00 -29.67
10-100-450186 Animal Boarding Fees 0.00 0.00 0.00 0.00 0.00
10-100-450190 Taxi Permits 300.00 425.00 0.00 -125.00 -41.67
10-100-450230 Vacating Right Of Way 800.00 100.00 0.00 700.00 87.50
10-100-450250 Rezoning Request 10,000.00 9,786.00 0.00 214.00 2.14
10-100-450260 Non-refundable Plansspec 3,000.00 1,462.50 0.00 1,537.50 51.25
R65 Fees Licenses & Permits 689,700.00 600,641.08 0.00 89,058.92 12.91
10-100-460010 Court Cost 85,000.00 61,952.99 0.00 23,047.01 27.11
10-100-460015 Court Restitutions 1,300.00 1,256.75 0.00 43.25 3.33
GL - Trial Balance by Full Acct Number (08/19/2013 - 8:34 AM)Page 2
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-100-460018 Inmate Security Fund 12,080.00 10,002.32 0.00 2,077.68 17.20
10-100-460020 Jail Cost Recovery 15,000.00 7,881.87 0.00 7,118.13 47.45
10-100-460025 Alcohol Offense Cost Rec 13,000.00 8,746.25 0.00 4,253.75 32.72
10-100-460030 Pol Fines-traffic 875,000.00 640,492.03 0.00 234,507.97 26.80
10-100-460040 Pol Tickets-parking 1,000.00 0.00 0.00 1,000.00 100.00
10-100-460050 Pol Fines-other 0.00 0.00 0.00 0.00 0.00
10-100-460060 Dog Fines 0.00 0.00 0.00 0.00 0.00
10-100-460070 P & Code Violations 0.00 0.00 0.00 0.00 0.00
10-100-460090 Parking Fines 58,600.00 37,206.97 0.00 21,393.03 36.51
10-100-460100 Bankcard Charges -10,000.00 -10,291.53 0.00 291.53 -2.92
R70 Fines & Forfeitures 1,050,980.00 757,247.65 0.00 293,732.35 27.95
10-100-450187 Special Sn Program 0.00 0.00 0.00 0.00 0.00
10-100-450188 Adoption Voucher Program 0.00 0.00 0.00 0.00 0.00
10-100-450189 Animal Shelter Bricks 0.00 100.00 0.00 -100.00 0.00
10-100-480010 Citizen Participation 0.00 8,509.40 0.00 -8,509.40 0.00
10-100-480015 Sidewalk Waiver Revenue 0.00 0.00 0.00 0.00 0.00
10-100-480020 NSP Rehab Sales 101,406.88 0.00 0.00 101,406.88 100.00
10-100-480025 HUD Program Income 0.00 8,340.00 0.00 -8,340.00 0.00
10-100-480030 Donations-Recycling 5,500.00 11,000.00 0.00 -5,500.00 -100.00
10-100-480050 Sober Driver Program 9,000.00 3,742.22 0.00 5,257.78 58.42
10-100-480055 JC Fire Museum 0.00 3,834.00 0.00 -3,834.00 0.00
10-100-480063 Private Donations-Cultural Art 0.00 200.00 0.00 -200.00 0.00
10-100-480065 Cultural Arts 0.00 20.00 0.00 -20.00 0.00
10-100-480070 Community Projects Donations 3,770.00 2,270.00 0.00 1,500.00 39.79
10-100-480080 Dare Donations 8,000.00 8,006.24 0.00 -6.24 -0.08
10-100-480090 Police K-9 Donations 1,000.00 500.00 0.00 500.00 50.00
10-100-480165 Animal S Donations 80,780.00 4,469.00 0.00 76,311.00 94.47
10-100-481020 Cole Cty Animal Rescue 100,000.00 75,000.00 0.00 25,000.00 25.00
10-100-481030 Rent City Hallannex 6,500.00 6,500.00 0.00 0.00 0.00
10-100-481040 Rent Other 12,000.00 0.00 0.00 12,000.00 100.00
10-100-481045 Rent-tower Sites 80,000.00 65,814.45 0.00 14,185.55 17.73
10-100-481050 Transfer StnPlng-Sld Wst Cntr 0.00 0.00 0.00 0.00 0.00
10-100-481055 Street Repair-Solid Waste Cntr 110,000.00 82,920.53 0.00 27,079.47 24.62
10-100-481070 Miscellaneous 24,000.00 14,451.17 0.00 9,548.83 39.79
10-100-481075 Cole Cty 911 Reimb 355,715.00 297,003.00 0.00 58,712.00 16.51
10-100-481077 Insurance Claims 30,000.00 11,368.50 0.00 18,631.50 62.11
10-100-481078 Cafeteria Refunds 15,000.00 0.00 0.00 15,000.00 100.00
10-100-481080 Sale Of Mapsgis Data 100.00 50.00 0.00 50.00 50.00
10-100-481085 Cole Cty Gis Joint Coop 15,000.00 12,500.00 0.00 2,500.00 16.67
10-100-481090 Cole Cty Sheriff-New World 0.00 28,678.00 0.00 -28,678.00 0.00
10-100-481095 Cemetery Donations 0.00 0.00 0.00 0.00 0.00
10-100-481100 Sale Of Grave Sites 3,500.00 4,800.00 0.00 -1,300.00 -37.14
10-100-481110 Long & Short 0.00 -33.87 0.00 33.87 0.00
R75 Other Operating Revenues 961,271.88 650,042.64 0.00 311,229.24 32.38
10-100-470010 Interest 40,000.00 65,242.50 0.00 -25,242.50 -63.11
10-100-470051 Unrealized Gainslosses 0.00 0.00 0.00 0.00 0.00
R80 Interest Income 40,000.00 65,242.50 0.00 -25,242.50 -63.11
GL - Trial Balance by Full Acct Number (08/19/2013 - 8:34 AM)Page 3
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-100-485049 Capvhcleqp-sale Of Assets 0.00 0.00 0.00 0.00 0.00
10-100-485050 Sale Of Assets 297,000.00 277,592.02 0.00 19,407.98 6.53
10-100-486070 Cap Contr-Neighborhood Imp Pro 0.00 0.00 0.00 0.00 0.00
R85 Other Non-Operating Revenue 297,000.00 277,592.02 0.00 19,407.98 6.53
10-100-490193 Trsfr From Grant Fund 0.00 0.00 0.00 0.00 0.00
10-100-490240 Trsfr From Lodging Tax 20,990.00 14,411.68 0.00 6,578.32 31.34
10-100-490260 Trans from Firemen's Spec Rev 0.00 0.00 0.00 0.00 0.00
10-100-490280 Trnf From Stoneridge Tdd 0.00 0.00 0.00 0.00 0.00
10-100-490353 Transfer From Cit 'e'0.00 0.00 0.00 0.00 0.00
10-100-490600 Transfer from Water Fund 0.00 17,809.14 0.00 -17,809.14 0.00
10-100-490620 Transfer from Parking Fund 0.00 0.00 0.00 0.00 0.00
R90 Transfers In 20,990.00 32,220.82 0.00 -11,230.82 -53.51
10-100-495995 Transfer From(to) Surplus 986,566.10 0.00 0.00 986,566.10 100.00
10-100-495996 Trnasfer From(To) Surplus 0.00 0.00 0.00 0.00 0.00
R99 Carry Over Surplus 986,566.10 0.00 0.00 986,566.10 100.00
100 Revenue 32,318,367.18 21,920,469.31 0.00 10,397,897.87 32.17
300 Police Department
10-300-430010 Federal Grants 525,201.79 238,676.55 0.00 286,525.24 54.56
10-300-430020 State Grants 0.00 0.00 0.00 0.00 0.00
10-300-430040 Local Grants 0.00 0.00 0.00 0.00 0.00
10-300-430074 Overtime Reimb 68,826.00 28,615.27 0.00 40,210.73 58.42
R50 Intergovernmental 594,027.79 267,291.82 0.00 326,735.97 55.00
300 Police Department 594,027.79 267,291.82 0.00 326,735.97 55.00
310 School Resource Officer
10-310-430010 Federal Grants 0.00 0.00 0.00 0.00 0.00
10-310-430020 State Grants 0.00 0.00 0.00 0.00 0.00
10-310-430040 Local Grants 188,765.00 192,242.34 0.00 -3,477.34 -1.84
R50 Intergovernmental 188,765.00 192,242.34 0.00 -3,477.34 -1.84
310 School Resource Officer 188,765.00 192,242.34 0.00 -3,477.34 -1.84
320 M.U.S.T.A.N.G.
10-320-430010 Federal Grants 0.00 27,308.33 0.00 -27,308.33 0.00
10-320-430020 State Grants 0.00 0.00 0.00 0.00 0.00
10-320-430040 Local Grants 0.00 0.00 0.00 0.00 0.00
10-320-430060 Drug Forfeiture 0.00 0.00 0.00 0.00 0.00
10-320-430074 Overtime Reimb 0.00 0.00 0.00 0.00 0.00
R50 Intergovernmental 0.00 27,308.33 0.00 -27,308.33 0.00
320 M.U.S.T.A.N.G.0.00 27,308.33 0.00 -27,308.33 0.00
Revenue Revenue 33,101,159.97 22,407,311.80 0.00 10,693,848.17 32.31
GL - Trial Balance by Full Acct Number (08/19/2013 - 8:34 AM)Page 4
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
Expense Expense
110 Mayor & Council
10-110-501010 Salary-Elected Officials 64,800.00 43,875.00 0.00 20,925.00 32.29
10-110-501020 Salaries 0.00 0.00 0.00 0.00 0.00
10-110-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00
10-110-502010 Social Security 4,960.00 3,185.43 0.00 1,774.57 35.78
10-110-502020 Group Health Insurance 0.00 1,048.00 0.00 -1,048.00 0.00
10-110-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 69,760.00 48,108.43 0.00 21,651.57 31.04
10-110-511010 Advertising 1.15 0.00 0.00 1.15 100.00
10-110-511020 Postage 59.57 59.57 0.00 0.00 0.00
10-110-512010 Printing 150.00 0.00 0.00 150.00 100.00
10-110-512020 Copies 1,030.00 48.32 0.00 981.68 95.31
10-110-513010 Office Supplies 437.50 243.04 194.44 0.02 0.00
E10 Materials & Supplies 1,678.22 350.93 194.44 1,132.85 67.50
10-110-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00
10-110-520030 Dues And Publications 5,014.46 4,367.51 0.00 646.95 12.90
10-110-520050 Meeting And Conferences 104.83 64.83 0.00 40.00 38.16
10-110-522020 Professional Services 0.00 0.00 0.00 0.00 0.00
10-110-529010 Special Events 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 5,119.29 4,432.34 0.00 686.95 13.42
10-110-534010 Telephone 0.00 0.00 0.00 0.00 0.00
E20 Utilities 0.00 0.00 0.00 0.00 0.00
10-110-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00
110 Mayor & Council 76,557.51 52,891.70 194.44 23,471.37 30.66
120 City Clerk
10-120-501020 Salaries 62,566.80 48,423.15 0.00 14,143.65 22.61
10-120-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00
10-120-501090 Overtime 0.00 0.00 0.00 0.00 0.00
10-120-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00
10-120-502010 Social Security 4,783.86 3,500.89 0.00 1,282.97 26.82
10-120-502020 Group Health Insurance 11,791.50 9,120.12 0.00 2,671.38 22.66
10-120-502030 Retirement 10,968.60 9,078.81 0.00 1,889.79 17.23
10-120-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
10-120-502050 Life Insurance 110.00 80.19 0.00 29.81 27.10
10-120-502060 Long Term Disability 151.47 126.77 0.00 24.70 16.31
10-120-502070 Employee Assistance Prgm 33.30 24.56 0.00 8.74 26.25
E05 Personnel Services 90,405.53 70,354.49 0.00 20,051.04 22.18
10-120-511020 Postage 270.00 117.92 0.00 152.08 56.33
10-120-512010 Printing 300.00 0.00 0.00 300.00 100.00
GL - Trial Balance by Full Acct Number (08/19/2013 - 8:34 AM)Page 5
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-120-512020 Copies 4,500.00 242.86 0.00 4,257.14 94.60
10-120-513010 Office Supplies 1,150.00 20.07 0.00 1,129.93 98.25
E10 Materials & Supplies 6,220.00 380.85 0.00 5,839.15 93.88
10-120-520030 Dues And Publications 250.00 200.00 0.00 50.00 20.00
10-120-520050 Meeting And Conferences 500.00 36.00 0.00 464.00 92.80
10-120-520070 Training And Education 500.00 0.00 0.00 500.00 100.00
10-120-522020 Professional Services 2,249.96 0.00 0.00 2,249.96 100.00
10-120-529030 Election Expense 72,083.02 72,083.02 0.00 0.00 0.00
E15 Contractual Services 75,582.98 72,319.02 0.00 3,263.96 4.32
10-120-534010 Telephone 0.00 0.00 0.00 0.00 0.00
E20 Utilities 0.00 0.00 0.00 0.00 0.00
10-120-547010 Equipment Maintenance 617.02 422.56 194.44 0.02 0.00
E25 Repairs & Maintenance 617.02 422.56 194.44 0.02 0.00
10-120-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00
120 City Clerk 172,825.53 143,476.92 194.44 29,154.17 16.87
140 City Administrator
10-140-501020 Salaries 204,859.92 160,852.47 0.00 44,007.45 21.48
10-140-501050 Parttime(wo Benefits)100.98 0.00 0.00 100.98 100.00
10-140-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00
10-140-501090 Overtime 0.00 0.00 0.00 0.00 0.00
10-140-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00
10-140-502010 Social Security 15,494.23 10,914.36 0.00 4,579.87 29.56
10-140-502020 Group Health Insurance 9,853.41 15,532.01 0.00 -5,678.60 -57.63
10-140-502030 Retirement 36,676.68 29,933.82 0.00 6,742.86 18.38
10-140-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
10-140-502050 Life Insurance 383.78 248.88 0.00 134.90 35.15
10-140-502060 Long Term Disability 475.08 307.73 0.00 167.35 35.23
10-140-502070 Employee Assistance Prgm 31.59 32.74 0.00 -1.15 -3.64
E05 Personnel Services 267,875.67 217,822.01 0.00 50,053.66 18.69
10-140-511010 Advertising 3,292.49 2,442.95 0.00 849.54 25.80
10-140-511020 Postage 370.00 231.18 0.00 138.82 37.52
10-140-512010 Printing 330.00 0.00 0.00 330.00 100.00
10-140-512020 Copies 950.00 94.67 0.00 855.33 90.03
10-140-513010 Office Supplies 1,300.64 1,106.21 194.44 -0.01 0.00
E10 Materials & Supplies 6,243.13 3,875.01 194.44 2,173.68 34.82
10-140-520030 Dues And Publications 580.00 580.00 0.00 0.00 0.00
10-140-520050 Meeting And Conferences 1,211.80 925.41 0.00 286.39 23.63
10-140-520070 Training And Education 99.00 99.00 0.00 0.00 0.00
10-140-522020 Professional Services 3,184.98 363.82 0.00 2,821.16 88.58
E15 Contractual Services 5,075.78 1,968.23 0.00 3,107.55 61.22
GL - Trial Balance by Full Acct Number (08/19/2013 - 8:34 AM)Page 6
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-140-534010 Telephone 0.00 0.00 0.00 0.00 0.00
E20 Utilities 0.00 0.00 0.00 0.00 0.00
10-140-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00
10-140-547010 Equipment Maintenance 237.60 237.60 0.00 0.00 0.00
E25 Repairs & Maintenance 237.60 237.60 0.00 0.00 0.00
10-140-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00
140 City Administrator 279,432.18 223,902.85 194.44 55,334.89 19.80
149 Entitlement Grant
10-149-501020 Salaries 0.00 0.00 0.00 0.00 0.00
10-149-501050 Parttime(wo Benefits)20,000.00 4,278.75 0.00 15,721.25 78.61
10-149-502010 Social Security 1,000.00 327.34 0.00 672.66 67.27
10-149-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00
10-149-502030 Retirement 0.00 0.00 0.00 0.00 0.00
10-149-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 21,000.00 4,606.09 0.00 16,393.91 78.07
10-149-511010 Advertising 500.00 383.33 0.00 116.67 23.33
10-149-511020 Postage 600.00 164.97 0.00 435.03 72.51
10-149-512020 Copies 800.00 1.55 0.00 798.45 99.81
10-149-513010 Office Supplies 600.00 502.06 0.00 97.94 16.32
E10 Materials & Supplies 2,500.00 1,051.91 0.00 1,448.09 57.92
10-149-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00
10-149-520070 Training And Education 1,500.00 350.40 0.00 1,149.60 76.64
10-149-522020 Professional Services 10,000.00 189.00 3,700.00 6,111.00 61.11
10-149-528010 Housing Rehabilitation 50,000.00 20,117.25 0.00 29,882.75 59.77
10-149-528020 Housing Assistance 10,020.00 300.00 0.00 9,720.00 97.01
10-149-528030 Public Improvement 120,000.00 0.00 0.00 120,000.00 100.00
10-149-528040 Neighborhood Redevelopmnt 80,000.00 19,500.00 0.00 60,500.00 75.63
10-149-528050 Neighborhood Facility 10,000.00 0.00 0.00 10,000.00 100.00
10-149-528060 Economic Development 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 281,520.00 40,456.65 3,700.00 237,363.35 84.31
10-149-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00
E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00
10-149-572020 Purchase Of Equipment 1,000.00 0.00 0.00 1,000.00 100.00
E70 Capital Purchases 1,000.00 0.00 0.00 1,000.00 100.00
149 Entitlement Grant 306,020.00 46,114.65 3,700.00 256,205.35 83.72
150 City Counselor
10-150-501020 Salaries 218,045.40 164,934.60 0.00 53,110.80 24.36
GL - Trial Balance by Full Acct Number (08/19/2013 - 8:34 AM)Page 7
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-150-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00
10-150-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00
10-150-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00
10-150-501090 Overtime 500.00 183.60 0.00 316.40 63.28
10-150-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00
10-150-502010 Social Security 16,687.06 11,846.32 0.00 4,840.74 29.01
10-150-502020 Group Health Insurance 28,192.50 22,357.44 0.00 5,835.06 20.70
10-150-502030 Retirement 38,218.40 27,026.25 0.00 11,192.15 29.28
10-150-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
10-150-502050 Life Insurance 390.00 268.74 0.00 121.26 31.09
10-150-502060 Long Term Disability 535.13 391.60 0.00 143.53 26.82
10-150-502070 Employee Assistance Prgm 77.70 57.31 0.00 20.39 26.24
10-150-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 302,646.19 227,065.86 0.00 75,580.33 24.97
10-150-511010 Advertising 0.00 0.00 0.00 0.00 0.00
10-150-511020 Postage 100.00 180.89 0.00 -80.89 -80.89
10-150-512010 Printing 200.00 0.00 0.00 200.00 100.00
10-150-512020 Copies 670.00 177.69 0.00 492.31 73.48
10-150-513010 Office Supplies 2,000.00 1,269.44 0.00 730.56 36.53
10-150-517010 Operational Supplies 100.00 0.00 0.00 100.00 100.00
E10 Materials & Supplies 3,070.00 1,628.02 0.00 1,441.98 46.97
10-150-520020 Auditing Travel Expense 0.00 0.00 0.00 0.00 0.00
10-150-520030 Dues And Publications 13,250.00 9,590.17 0.00 3,659.83 27.62
10-150-520050 Meeting And Conferences 1,500.00 1,054.08 0.00 445.92 29.73
10-150-520070 Training And Education 2,400.00 2,049.51 0.00 350.49 14.60
10-150-520080 Tuition Reimbursement 2,880.00 2,394.00 0.00 486.00 16.88
10-150-521010 General Insurance 2,100.00 844.00 0.00 1,256.00 59.81
10-150-522020 Professional Services 12,000.00 11,020.36 0.00 979.64 8.16
10-150-525030 Court Cost & Witness Fees 290.00 28.36 0.00 261.64 90.22
E15 Contractual Services 34,420.00 26,980.48 0.00 7,439.52 21.61
10-150-534010 Telephone 0.00 0.00 0.00 0.00 0.00
E20 Utilities 0.00 0.00 0.00 0.00 0.00
10-150-547010 Equipment Maintenance 1,890.00 983.52 330.31 576.17 30.49
E25 Repairs & Maintenance 1,890.00 983.52 330.31 576.17 30.49
10-150-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
10-150-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00
150 City Counselor 342,026.19 256,657.88 330.31 85,038.00 24.86
160 Municipal Court Dept
10-160-501010 Salary-elected Officals 60,000.00 39,999.92 0.00 20,000.08 33.33
10-160-501020 Salaries 95,145.60 74,942.18 0.00 20,203.42 21.23
10-160-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00
GL - Trial Balance by Full Acct Number (08/19/2013 - 8:34 AM)Page 8
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-160-501050 Parttime(wo Benefits)9,250.00 4,446.75 0.00 4,803.25 51.93
10-160-501090 Overtime 8,600.00 2,013.91 0.00 6,586.09 76.58
10-160-501095 Overtime Straight Pay 0.00 67.16 0.00 -67.16 0.00
10-160-502010 Social Security 13,252.72 9,169.86 0.00 4,082.86 30.81
10-160-502020 Group Health Insurance 14,248.50 8,740.04 0.00 5,508.46 38.66
10-160-502030 Retirement 18,210.30 14,441.15 0.00 3,769.15 20.70
10-160-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
10-160-502050 Life Insurance 170.00 122.37 0.00 47.63 28.02
10-160-502060 Long Term Disability 232.24 194.58 0.00 37.66 16.22
10-160-502070 Employee Assistance Prgm 55.50 40.93 0.00 14.57 26.25
E05 Personnel Services 219,164.86 154,178.85 0.00 64,986.01 29.65
10-160-511010 Advertising 0.00 0.00 0.00 0.00 0.00
10-160-511020 Postage 4,000.00 2,312.83 0.00 1,687.17 42.18
10-160-512010 Printing 1,090.00 377.70 0.00 712.30 65.35
10-160-512020 Copies 1,000.00 150.14 0.00 849.86 84.99
10-160-513010 Office Supplies 2,600.00 1,986.06 0.00 613.94 23.61
E10 Materials & Supplies 8,690.00 4,826.73 0.00 3,863.27 44.46
10-160-520030 Dues And Publications 300.00 100.00 0.00 200.00 66.67
10-160-520050 Meeting And Conferences 750.00 558.48 0.00 191.52 25.54
10-160-520070 Training And Education 600.00 500.00 0.00 100.00 16.67
10-160-522020 Professional Services 21,869.52 14,849.03 0.00 7,020.49 32.10
10-160-525010 Care Of Prisoners 1,790.50 75.00 0.00 1,715.50 95.81
10-160-525030 Court Cost & Witness Fees 40.00 0.00 0.00 40.00 100.00
E15 Contractual Services 25,350.02 16,082.51 0.00 9,267.51 36.56
10-160-534010 Telephone 0.00 0.00 0.00 0.00 0.00
E20 Utilities 0.00 0.00 0.00 0.00 0.00
10-160-547010 Equipment Maintenance 1,032.98 781.60 194.44 56.94 5.51
E25 Repairs & Maintenance 1,032.98 781.60 194.44 56.94 5.51
10-160-572020 Purchase Of Equipment 23,851.06 0.00 23,851.06 0.00 0.00
E70 Capital Purchases 23,851.06 0.00 23,851.06 0.00 0.00
160 Municipal Court Dept 278,088.92 175,869.69 24,045.50 78,173.73 28.11
170 Human Resources
10-170-501020 Salaries 182,896.20 140,051.76 0.00 42,844.44 23.43
10-170-501050 Parttime(wo Benefits)9,600.00 6,844.51 0.00 2,755.49 28.70
10-170-501090 Overtime 300.00 0.00 0.00 300.00 100.00
10-170-502010 Social Security 15,514.34 10,805.38 0.00 4,708.96 30.35
10-170-502020 Group Health Insurance 23,310.00 19,103.67 0.00 4,206.33 18.05
10-170-502030 Retirement 32,107.90 26,259.05 0.00 5,848.85 18.22
10-170-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
10-170-502050 Life Insurance 320.00 230.55 0.00 89.45 27.95
10-170-502060 Long Term Disability 444.30 332.68 0.00 111.62 25.12
10-170-502070 Employee Assistance Prgm 66.60 49.11 0.00 17.49 26.26
GL - Trial Balance by Full Acct Number (08/19/2013 - 8:34 AM)Page 9
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-170-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 264,559.34 203,676.71 0.00 60,882.63 23.01
10-170-511010 Advertising 150.00 0.00 0.00 150.00 100.00
10-170-511020 Postage 1,000.00 79.94 0.00 920.06 92.01
10-170-512010 Printing 2,000.00 1,576.47 0.00 423.53 21.18
10-170-512020 Copies 1,500.00 519.13 0.00 980.87 65.39
10-170-513010 Office Supplies 1,500.00 287.51 0.00 1,212.49 80.83
10-170-517010 Operational Supplies 1,350.00 46.32 0.00 1,303.68 96.57
E10 Materials & Supplies 7,500.00 2,509.37 0.00 4,990.63 66.54
10-170-520030 Dues And Publications 1,255.00 483.00 0.00 772.00 61.51
10-170-520050 Meeting And Conferences 942.00 389.08 0.00 552.92 58.70
10-170-520060 Wellness Program 3,919.00 1,702.66 0.00 2,216.34 56.55
10-170-520070 Training And Education 2,002.00 1,810.36 0.00 191.64 9.57
10-170-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00
10-170-521060 Drugalcohol Screening 6,816.00 5,445.00 0.00 1,371.00 20.11
10-170-522020 Professional Services 10,648.50 2,090.96 0.00 8,557.54 80.36
10-170-529010 Special Events 0.00 0.00 0.00 0.00 0.00
10-170-529015 Human Rights Commission 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 25,582.50 11,921.06 0.00 13,661.44 53.40
10-170-534010 Telephone 0.00 0.00 0.00 0.00 0.00
E20 Utilities 0.00 0.00 0.00 0.00 0.00
10-170-547010 Equipment Maintenance 437.50 243.07 194.44 -0.01 0.00
E25 Repairs & Maintenance 437.50 243.07 194.44 -0.01 0.00
10-170-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00
170 Human Resources 298,079.34 218,350.21 194.44 79,534.69 26.68
180 Finance Department
10-180-501020 Salaries 604,556.47 470,327.11 0.00 134,229.36 22.20
10-180-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00
10-180-501050 Parttime(wo Benefits)8,600.00 4,217.18 0.00 4,382.82 50.96
10-180-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00
10-180-501090 Overtime 0.00 0.00 0.00 0.00 0.00
10-180-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00
10-180-502010 Social Security 53,692.95 35,884.91 0.00 17,808.04 33.17
10-180-502020 Group Health Insurance 81,663.89 51,470.04 0.00 30,193.85 36.97
10-180-502030 Retirement 103,469.01 79,075.65 0.00 24,393.36 23.58
10-180-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
10-180-502050 Life Insurance 1,053.35 712.71 0.00 340.64 32.34
10-180-502060 Long Term Disability 1,527.41 1,135.18 0.00 392.23 25.68
10-180-502070 Employee Assistance Prgm 273.23 229.26 0.00 43.97 16.09
E05 Personnel Services 854,836.31 643,052.04 0.00 211,784.27 24.77
GL - Trial Balance by Full Acct Number (08/19/2013 - 8:34 AM)Page 10
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-180-511010 Advertising 2,000.00 327.93 0.00 1,672.07 83.60
10-180-511020 Postage 13,500.00 7,623.76 0.00 5,876.24 43.53
10-180-511021 Postage Cost 2,000.00 4,560.82 0.00 -2,560.82 -128.04
10-180-512010 Printing 6,500.00 3,470.28 0.00 3,029.72 46.61
10-180-512020 Copies 7,000.00 2,567.55 0.00 4,432.45 63.32
10-180-512021 Copy Machine Cost 0.00 -1,244.05 1,166.64 77.41 0.00
10-180-513010 Office Supplies 5,913.00 3,698.90 0.00 2,214.10 37.44
10-180-517010 Operational Supplies 3,827.60 1,273.61 0.00 2,553.99 66.73
E10 Materials & Supplies 40,740.60 22,278.80 1,166.64 17,295.16 42.45
10-180-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00
10-180-520020 Auditing Travel Expenses 0.00 0.00 0.00 0.00 0.00
10-180-520030 Dues And Publications 2,400.00 890.52 0.00 1,509.48 62.90
10-180-520050 Meeting And Conferences 1,768.30 1,629.38 0.00 138.92 7.86
10-180-520070 Training And Education 1,426.00 959.96 0.00 466.04 32.68
10-180-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00
10-180-522010 Audit 25,342.40 25,342.40 0.00 0.00 0.00
10-180-522020 Professional Services 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 30,936.70 28,822.26 0.00 2,114.44 6.83
10-180-534010 Telephone 0.00 0.00 0.00 0.00 0.00
E20 Utilities 0.00 0.00 0.00 0.00 0.00
10-180-547010 Equipment Maintenance 2,000.00 1,215.84 0.00 784.16 39.21
10-180-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00
E25 Repairs & Maintenance 2,000.00 1,215.84 0.00 784.16 39.21
10-180-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00
180 Finance Department 928,513.61 695,368.94 1,166.64 231,978.03 24.98
185 Non-Departmental
10-185-501020 Salaries 586,048.24 0.00 0.00 586,048.24 100.00
10-185-502020 Group Health Insurance 5,000.00 5,000.00 0.00 0.00 0.00
10-185-504010 Employee Salary Guarantee Fund 29,749.56 0.00 0.00 29,749.56 100.00
E05 Personnel Services 620,797.80 5,000.00 0.00 615,797.80 99.19
10-185-514011 Gas Oil & Antifreeze 935,000.00 679,607.40 41,403.50 213,989.10 22.89
E10 Materials & Supplies 935,000.00 679,607.40 41,403.50 213,989.10 22.89
10-185-520030 Dues and Publications 0.00 0.00 0.00 0.00 0.00
10-185-520080 Tuition Reimbursement 8,000.00 0.00 0.00 8,000.00 100.00
10-185-521010 General Insurance 261,000.00 308,287.72 0.00 -47,287.72 -18.12
10-185-521020 Insurance Deductible 10,000.00 13,794.59 0.00 -3,794.59 -37.95
10-185-521030 Self Ins Prop & Casualty 70,000.00 44,690.12 0.00 25,309.88 36.16
10-185-521070 Prov For Unsettled Claims 0.00 0.00 0.00 0.00 0.00
10-185-522020 Professional Services 235,000.00 228,749.97 8,333.33 -2,083.30 -0.89
10-185-524010 Trash Collections 500.00 0.00 0.00 500.00 100.00
GL - Trial Balance by Full Acct Number (08/19/2013 - 8:34 AM)Page 11
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-185-526030 Assessment Charge 38,500.00 34,068.38 0.00 4,431.62 11.51
10-185-527020 Economic Development 185,000.00 185,000.00 0.00 0.00 0.00
10-185-529010 Special Events 18,000.00 10,510.71 0.00 7,489.29 41.61
E15 Contractual Services 826,000.00 825,101.49 8,333.33 -7,434.82 -0.90
10-185-531010 Electricity 37,400.00 25,577.98 0.00 11,822.02 31.61
10-185-533010 Natural Gas 11,000.00 4,160.98 0.00 6,839.02 62.17
10-185-535010 Water 6,791.05 4,702.14 0.00 2,088.91 30.76
10-185-535020 Downtown Irrigation 0.00 0.00 0.00 0.00 0.00
E20 Utilities 55,191.05 34,441.10 0.00 20,749.95 37.60
10-185-540010 Building & Grounds Maint.55,958.95 20,723.69 494.33 34,740.93 62.08
10-185-540020 Tree & Landscape Maint 25,000.00 23,625.00 0.00 1,375.00 5.50
10-185-547020 Maintenance Agreements 2,000.00 1,404.00 0.00 596.00 29.80
E25 Repairs & Maintenance 82,958.95 45,752.69 494.33 36,711.93 44.25
10-185-550010 Miscellaneous 17,246.44 2,422.44 0.00 14,824.00 85.95
10-185-550015 Bad Debt Expense 0.00 -270.00 0.00 270.00 0.00
10-185-550020 Neighborhood Reinvestment 0.00 0.00 0.00 0.00 0.00
10-185-550030 Old Town Projects 0.00 0.00 0.00 0.00 0.00
10-185-550036 Salute to America 5,000.00 5,000.00 0.00 0.00 0.00
10-185-550037 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00
10-185-550038 Civil War Reenactment Comm 0.00 0.00 0.00 0.00 0.00
10-185-550039 Katy Trail Welcome Area 0.00 0.00 0.00 0.00 0.00
10-185-550040 Public Art 12,391.36 6,884.34 0.00 5,507.02 44.44
10-185-550043 JC Fire Museum 0.00 0.00 0.00 0.00 0.00
10-185-550045 Conference Center 0.00 0.00 0.00 0.00 0.00
10-185-550050 Neighb Stablization Prog 0.00 0.00 0.00 0.00 0.00
10-185-550060 MSP 0.00 0.00 0.00 0.00 0.00
10-185-550070 Energy Grant Expenditures 0.00 0.00 0.00 0.00 0.00
10-185-550080 Neighborhd Improvement Progr 0.00 0.00 0.00 0.00 0.00
10-185-550090 Hazard Mitigation 0.00 0.00 0.00 0.00 0.00
E30 Other Operating Expenses 34,637.80 14,036.78 0.00 20,601.02 59.48
10-185-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
10-185-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00
10-185-578073 Council Infrastructure Proj 0.00 0.00 0.00 0.00 0.00
E75 Capital Projects 0.00 0.00 0.00 0.00 0.00
185 Non-Departmental 2,554,585.60 1,603,939.46 50,231.16 900,414.98 35.25
190 I.T. Department
10-190-501020 Salaries 519,071.25 404,979.56 0.00 114,091.69 21.98
10-190-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00
10-190-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00
10-190-501090 Overtime 0.00 0.00 0.00 0.00 0.00
10-190-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00
GL - Trial Balance by Full Acct Number (08/19/2013 - 8:34 AM)Page 12
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-190-502010 Social Security 39,713.63 29,996.06 0.00 9,717.57 24.47
10-190-502020 Group Health Insurance 65,444.47 44,047.21 0.00 21,397.26 32.70
10-190-502030 Retirement 90,885.78 69,105.79 0.00 21,779.99 23.96
10-190-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
10-190-502050 Life Insurance 890.25 659.37 0.00 230.88 25.93
10-190-502060 Long Term Disability 1,268.63 1,012.85 0.00 255.78 20.16
10-190-502070 Employee Assistance Prgm 206.63 155.54 0.00 51.09 24.73
E05 Personnel Services 717,480.64 549,956.38 0.00 167,524.26 23.35
10-190-511010 Advertising 500.00 0.00 0.00 500.00 100.00
10-190-511020 Postage 200.00 10.43 0.00 189.57 94.79
10-190-512010 Printing 100.00 0.00 0.00 100.00 100.00
10-190-512020 Copies 400.00 33.17 0.00 366.83 91.71
10-190-512030 Photographic Supplies 100.00 0.00 0.00 100.00 100.00
10-190-513010 Office Supplies 741.09 256.60 0.00 484.49 65.38
10-190-514030 Small Tools 50.00 0.00 0.00 50.00 100.00
10-190-514040 Food 50.00 0.00 0.00 50.00 100.00
10-190-515040 First Aid Supplies 50.00 0.00 0.00 50.00 100.00
10-190-517010 Operational Supplies 1,758.91 1,758.91 0.00 0.00 0.00
E10 Materials & Supplies 3,950.00 2,059.11 0.00 1,890.89 47.87
10-190-520010 Mileage Expense 500.00 150.01 0.00 349.99 70.00
10-190-520030 Dues And Publications 500.00 200.00 0.00 300.00 60.00
10-190-520050 Meeting And Conferences 2,000.00 1,933.09 0.00 66.91 3.35
10-190-520070 Training And Education 3,500.00 3,494.08 0.00 5.92 0.17
10-190-520080 Tuition Reimbursement 3,000.00 615.00 0.00 2,385.00 79.50
10-190-522020 Professional Services 2,000.00 824.41 0.00 1,175.59 58.78
10-190-522030 Services - Prof Training 0.00 0.00 0.00 0.00 0.00
10-190-522040 Service-internet T1 Web 19,800.00 12,952.03 0.00 6,847.97 34.59
10-190-522050 Service-remote Locations 0.00 0.00 0.00 0.00 0.00
10-190-522060 City Web Site 2,000.00 0.00 0.00 2,000.00 100.00
E15 Contractual Services 33,300.00 20,168.62 0.00 13,131.38 39.43
10-190-534010 Telephone 54,333.00 38,922.74 0.00 15,410.26 28.36
E20 Utilities 54,333.00 38,922.74 0.00 15,410.26 28.36
10-190-545010 Software Licensemaint 207,369.87 148,864.94 0.00 58,504.93 28.21
10-190-545020 Citywide Wiringnetwork 4,000.00 504.03 208.61 3,287.36 82.18
10-190-547010 Equipment Maintenance 4,000.00 2,524.33 0.00 1,475.67 36.89
10-190-547020 Maintenance Agreements 31,630.13 31,461.01 135.87 33.25 0.11
E25 Repairs & Maintenance 247,000.00 183,354.31 344.48 63,301.21 25.63
10-190-572020 Purchase Of Equipment 25,000.00 24,409.23 0.00 590.77 2.36
E70 Capital Purchases 25,000.00 24,409.23 0.00 590.77 2.36
190 I.T. Department 1,081,063.64 818,870.39 344.48 261,848.77 24.22
300 Police Department
10-300-501020 Salaries 3,926,515.32 3,097,926.92 0.00 828,588.40 21.10
GL - Trial Balance by Full Acct Number (08/19/2013 - 8:34 AM)Page 13
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-300-501030 Holiday Pay 119,064.00 99,623.49 0.00 19,440.51 16.33
10-300-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00
10-300-501050 Parttime(wo Benefits)30,400.00 23,540.50 0.00 6,859.50 22.56
10-300-501060 Seasonal Salaries 9,847.50 9,847.50 0.00 0.00 0.00
10-300-501070 Stand-by Plan 6,800.00 4,328.00 0.00 2,472.00 36.35
10-300-501090 Overtime 232,919.01 171,521.97 0.00 61,397.04 26.36
10-300-501095 Overtime Straight Pay 12,309.49 9,069.75 0.00 3,239.74 26.32
10-300-502010 Social Security 368,558.03 247,832.34 0.00 120,725.69 32.76
10-300-502020 Group Health Insurance 705,469.95 490,440.27 0.00 215,029.68 30.48
10-300-502030 Retirement 843,642.69 678,058.94 0.00 165,583.75 19.63
10-300-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
10-300-502050 Life Insurance 6,511.27 4,974.37 0.00 1,536.90 23.60
10-300-502060 Long Term Disability 9,302.24 7,807.21 0.00 1,495.03 16.07
10-300-502070 Employee Assistance Prgm 1,846.87 1,498.10 0.00 348.77 18.88
10-300-503010 Awards Program 1,600.00 0.00 0.00 1,600.00 100.00
10-300-503020 Unemployment Compensation 1,000.00 0.00 0.00 1,000.00 100.00
E05 Personnel Services 6,275,786.37 4,846,469.36 0.00 1,429,317.01 22.78
10-300-511010 Advertising 3,000.00 2,564.86 0.00 435.14 14.50
10-300-511020 Postage 2,500.00 1,010.37 0.00 1,489.63 59.59
10-300-512010 Printing 4,996.00 4,431.84 0.00 564.16 11.29
10-300-512020 Copies 4.00 2.59 0.00 1.41 35.25
10-300-512030 Photographic Supplies 1,000.00 92.34 0.00 907.66 90.77
10-300-513010 Office Supplies 12,000.00 8,538.17 0.00 3,461.83 28.85
10-300-514010 Gas, Oil, Anti-Freeze 0.00 0.00 0.00 0.00 0.00
10-300-514040 Food 700.00 278.52 0.00 421.48 60.21
10-300-516010 Ammunition & Firearms Supplies 28,000.00 6,340.88 16,497.56 5,161.56 18.43
10-300-516020 Dare Program 16,000.00 3,374.67 4,237.28 8,388.05 52.43
10-300-516030 Special Investigation 2,500.00 2,500.00 0.00 0.00 0.00
10-300-516040 Investigations (Grant)0.00 0.00 0.00 0.00 0.00
10-300-516050 Community Projects 2,270.00 2,270.00 0.00 0.00 0.00
10-300-517010 Operational Supplies 45,000.00 18,636.89 11,401.12 14,961.99 33.25
E10 Materials & Supplies 117,970.00 50,041.13 32,135.96 35,792.91 30.34
10-300-520030 Dues And Publications 4,300.00 4,089.30 0.00 210.70 4.90
10-300-520050 Meeting And Conferences 2,000.00 1,290.58 0.00 709.42 35.47
10-300-520070 Training And Education 15,000.00 14,798.34 0.00 201.66 1.34
10-300-520080 Tuition Reimbursement 7,000.00 6,459.00 0.00 541.00 7.73
10-300-520090 Recruitment 2,200.00 34.43 0.00 2,165.57 98.44
10-300-521040 Medical Claimsservices 3,800.00 2,762.00 0.00 1,038.00 27.32
10-300-521050 Medical Services 1,200.00 1,067.45 0.00 132.55 11.05
10-300-522020 Professional Services 15,000.00 11,162.68 0.00 3,837.32 25.58
10-300-522026 Drug Forfeiture - Justice 0.00 0.00 0.00 0.00 0.00
10-300-522027 Drug Forfeiture - Treasury 0.00 0.00 0.00 0.00 0.00
10-300-523010 Equipment Rentlease 12,840.00 5,600.00 0.00 7,240.00 56.39
10-300-523030 Building Lease 1,160.00 960.00 200.00 0.00 0.00
10-300-524010 Trash Collections 600.00 0.00 0.00 600.00 100.00
10-300-525020 Sober Driver Program 12,000.00 3,153.54 0.00 8,846.46 73.72
10-300-525050 Police Reserve 0.00 0.00 0.00 0.00 0.00
GL - Trial Balance by Full Acct Number (08/19/2013 - 8:34 AM)Page 14
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-300-529010 Special Events 2,200.00 1,800.99 0.00 399.01 18.14
E15 Contractual Services 79,300.00 53,178.31 200.00 25,921.69 32.69
10-300-531010 Electricity 61,000.00 48,656.11 0.00 12,343.89 20.24
10-300-533010 Natural Gas 11,800.00 10,459.02 0.00 1,340.98 11.36
10-300-534010 Telephone 4,400.00 3,488.93 0.00 911.07 20.71
10-300-535010 Water 4,200.00 3,140.51 0.00 1,059.49 25.23
E20 Utilities 81,400.00 65,744.57 0.00 15,655.43 19.23
10-300-540010 Building & Grounds Maint.61,000.00 33,283.42 11,293.05 16,423.53 26.92
10-300-541030 Vehicle Wash 11,000.00 8,151.50 0.00 2,848.50 25.90
10-300-544010 K-9 Operations 12,000.00 5,924.69 2,781.90 3,293.41 27.45
10-300-544015 Care of Animals 0.00 0.00 0.00 0.00 0.00
10-300-544020 Civil Defense 50,417.16 50,208.00 0.00 209.16 0.41
10-300-544030 Emerg Mgmt Operations 17,500.00 3,007.17 0.00 14,492.83 82.82
10-300-546010 Clothing Expense 25,732.00 14,038.96 -990.90 12,683.94 49.29
10-300-546020 Uniform Cleaning 26,000.00 18,150.24 0.00 7,849.76 30.19
10-300-547010 Equipment Maintenance 10,000.00 6,737.51 969.00 2,293.49 22.93
10-300-547020 Maintenance Agreements 34,000.00 21,856.67 1,306.58 10,836.75 31.87
10-300-547030 Radio Maintenance 10,000.00 7,645.04 0.00 2,354.96 23.55
E25 Repairs & Maintenance 257,649.16 169,003.20 15,359.63 73,286.33 28.44
10-300-572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00
10-300-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
10-300-572070 MDT Year 2 Equipment 153,772.97 153,772.97 287.50 -287.50 -0.19
10-300-572075 LLEBG Annual Grant Equipment 11,154.00 11,154.00 0.00 0.00 0.00
10-300-572076 LLEBG Stimulus Equipment 0.00 0.00 0.00 0.00 0.00
10-300-572100 MDT Year 3 Equipment 330,274.82 65,380.17 6,140.00 258,754.65 78.35
10-300-572110 Jcpd Mdt Equipment 0.00 0.00 0.00 0.00 0.00
10-300-572120 Cole Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00
10-300-572130 Osage B Mdt Equip 0.00 0.00 0.00 0.00 0.00
10-300-572140 Camden Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00
10-300-572150 Callaway Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00
10-300-572160 Fulton Mdt Equip 0.00 0.00 0.00 0.00 0.00
10-300-572170 Eldon Mdt Equip 0.00 0.00 0.00 0.00 0.00
10-300-572180 Miller Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00
10-300-572190 Camdenton Cty Mtd 0.00 0.00 0.00 0.00 0.00
10-300-572200 Lake Ozark Mdt Equip 0.00 0.00 0.00 0.00 0.00
10-300-572310 Software-camdnmilob 0.00 0.00 0.00 0.00 0.00
10-300-572320 Software-morgan Cty 0.00 0.00 0.00 0.00 0.00
10-300-572330 Software-jcpdcole Cty 0.00 0.00 0.00 0.00 0.00
10-300-572340 Software-colboone Cty 0.00 0.00 0.00 0.00 0.00
10-300-572350 Software-fultncallaway 0.00 0.00 0.00 0.00 0.00
10-300-572360 Software-vpnfirewl 0.00 0.00 0.00 0.00 0.00
10-300-572370 Software-prof Serv 0.00 0.00 0.00 0.00 0.00
10-300-572410 Project Mgmt Fees 0.00 0.00 0.00 0.00 0.00
10-300-572420 Contingency 0.00 0.00 0.00 0.00 0.00
10-300-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 495,201.79 230,307.14 6,427.50 258,467.15 52.19
GL - Trial Balance by Full Acct Number (08/19/2013 - 8:34 AM)Page 15
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
300 Police Department 7,307,307.32 5,414,743.71 54,123.09 1,838,440.52 25.16
310 School Resource Officer
10-310-501020 Salaries 242,821.20 165,155.68 0.00 77,665.52 31.98
10-310-501030 Holiday Pay 9,343.20 2,879.84 0.00 6,463.36 69.18
10-310-501090 Overtime 6,300.84 6,702.93 0.00 -402.09 -6.38
10-310-501095 Overtime Straight Pay 825.16 957.36 0.00 -132.20 -16.02
10-310-502010 Social Security 20,668.24 12,439.65 0.00 8,228.59 39.81
10-310-502020 Group Health Insurance 41,485.50 26,293.32 0.00 15,192.18 36.62
10-310-502030 Retirement 51,873.60 30,766.42 0.00 21,107.18 40.69
10-310-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
10-310-502050 Life Insurance 450.00 221.27 0.00 228.73 50.83
10-310-502060 Long Term Disability 605.93 349.77 0.00 256.16 42.28
10-310-502070 Employee Assistance Prgm 111.00 81.87 0.00 29.13 26.24
E05 Personnel Services 374,484.67 245,848.11 0.00 128,636.56 34.35
10-310-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00
E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00
10-310-520070 Training And Education 0.00 0.00 0.00 0.00 0.00
10-310-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 0.00 0.00 0.00 0.00 0.00
10-310-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00
10-310-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00
10-310-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00
E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00
10-310-572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00
10-310-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00
310 School Resource Officer 374,484.67 245,848.11 0.00 128,636.56 34.35
320 M.U.S.T.A.N.G.
10-320-501020 Salaries 76,802.00 56,298.52 0.00 20,503.48 26.70
10-320-501030 Holiday Pay 3,335.40 1,383.96 0.00 1,951.44 58.51
10-320-501090 Overtime 6,897.00 7,103.54 0.00 -206.54 -2.99
10-320-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00
10-320-502010 Social Security 8,315.20 4,687.22 0.00 3,627.98 43.63
10-320-502020 Group Health Insurance 14,532.00 9,174.14 0.00 5,357.86 36.87
10-320-502030 Retirement 20,614.10 13,561.49 0.00 7,052.61 34.21
10-320-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
10-320-502050 Life Insurance 150.00 93.48 0.00 56.52 37.68
10-320-502060 Long Term Disability 212.12 150.04 0.00 62.08 29.27
10-320-502070 Employee Assistance Prgm 44.40 32.74 0.00 11.66 26.26
E05 Personnel Services 130,902.22 92,485.13 0.00 38,417.09 29.35
GL - Trial Balance by Full Acct Number (08/19/2013 - 8:34 AM)Page 16
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-320-514010 Gas Oil Anti-freeze 0.00 0.00 0.00 0.00 0.00
10-320-516040 Investigations (grant)20,561.39 14,764.94 0.00 5,796.45 28.19
10-320-517010 Operational Supplies 438.61 438.61 0.00 0.00 0.00
E10 Materials & Supplies 21,000.00 15,203.55 0.00 5,796.45 27.60
10-320-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00
10-320-520070 Training And Education 0.00 0.00 0.00 0.00 0.00
10-320-522020 Professional Services 15,000.00 15,000.00 0.00 0.00 0.00
10-320-522025 Drug Forfeiture - MUSTANG 16,456.41 16,456.41 0.00 0.00 0.00
10-320-523010 Equipment Rentlease 1,500.00 1,500.00 0.00 0.00 0.00
10-320-523020 Building Lease 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 32,956.41 32,956.41 0.00 0.00 0.00
10-320-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00
10-320-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00
10-320-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00
E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00
10-320-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00
320 M.U.S.T.A.N.G.184,858.63 140,645.09 0.00 44,213.54 23.92
330 Animal Control
10-330-501020 Salaries 289,908.92 228,507.01 0.00 61,401.91 21.18
10-330-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00
10-330-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00
10-330-501060 Seasonal Salaries 2,765.00 2,765.00 0.00 0.00 0.00
10-330-501070 Stand-by Plan 3,000.00 3,228.00 0.00 -228.00 -7.60
10-330-501090 Overtime 1,709.00 1,210.07 0.00 498.93 29.19
10-330-501095 Overtime Straight Pay 500.00 27.82 0.00 472.18 94.44
10-330-502010 Social Security 23,963.21 16,379.40 0.00 7,583.81 31.65
10-330-502020 Group Health Insurance 65,287.85 45,250.67 0.00 20,037.18 30.69
10-330-502030 Retirement 54,182.34 39,639.05 0.00 14,543.29 26.84
10-330-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
10-330-502050 Life Insurance 522.79 367.75 0.00 155.04 29.66
10-330-502060 Long Term Disability 746.84 582.16 0.00 164.68 22.05
10-330-502070 Employee Assistance Prgm 170.77 130.98 0.00 39.79 23.30
10-330-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 442,756.72 338,087.91 0.00 104,668.81 23.64
10-330-511010 Advertising 2,000.00 45.73 0.00 1,954.27 97.71
10-330-511020 Postage 900.00 99.33 0.00 800.67 88.96
10-330-512010 Printing 1,700.00 1,430.50 0.00 269.50 15.85
10-330-512020 Copies 20.00 0.04 0.00 19.96 99.80
10-330-513010 Office Supplies 800.00 796.04 0.00 3.96 0.50
10-330-514030 Small Tools 250.00 27.97 0.00 222.03 88.81
10-330-515040 First Aid Supplies 150.00 0.00 0.00 150.00 100.00
10-330-517010 Operational Supplies 10,500.00 6,350.53 0.00 4,149.47 39.52
GL - Trial Balance by Full Acct Number (08/19/2013 - 8:34 AM)Page 17
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
E10 Materials & Supplies 16,320.00 8,750.14 0.00 7,569.86 46.38
10-330-520030 Dues And Publications 1,609.94 1,609.94 0.00 0.00 0.00
10-330-520050 Meeting And Conferences 290.06 0.00 0.00 290.06 100.00
10-330-520070 Training And Education 650.00 459.58 0.00 190.42 29.30
10-330-521040 Medical Claimsservices 829.00 829.00 0.00 0.00 0.00
10-330-522020 Professional Services 18,171.00 10,409.44 0.00 7,761.56 42.71
10-330-524010 Trash Collections 1,500.00 0.00 0.00 1,500.00 100.00
10-330-529050 Spay & Neuter Program 10,000.00 9,705.12 0.00 294.88 2.95
10-330-529060 Special Sn Program 0.00 0.00 0.00 0.00 0.00
10-330-529065 Adoption Voucher Program 3,669.05 3,669.05 0.00 0.00 0.00
10-330-529067 Animal Shelter Bricks 1,433.00 1,433.00 0.00 0.00 0.00
E15 Contractual Services 38,152.05 28,115.13 0.00 10,036.92 26.31
10-330-531010 Electricity 20,768.36 14,654.21 0.00 6,114.15 29.44
10-330-533010 Natural Gas 20,098.36 12,426.50 0.00 7,671.86 38.17
10-330-534010 Telephone 572.00 227.70 0.00 344.30 60.19
10-330-535010 Water 5,500.00 1,989.48 0.00 3,510.52 63.83
E20 Utilities 46,938.72 29,297.89 0.00 17,640.83 37.58
10-330-540010 Building & Grounds Maint.12,000.00 5,575.54 200.00 6,224.46 51.87
10-330-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00
10-330-541030 Vehicle Wash 540.00 410.00 0.00 130.00 24.07
10-330-544040 Care Of Animals 41,790.95 26,591.33 0.00 15,199.62 36.37
10-330-546010 Clothing Expense 3,000.00 599.00 0.00 2,401.00 80.03
10-330-546020 Uniform Cleaning 200.00 0.00 0.00 200.00 100.00
10-330-547010 Equipment Maintenance 1,300.00 475.36 0.00 824.64 63.43
10-330-547020 Maintenance Agreements 800.00 156.00 0.00 644.00 80.50
10-330-547030 Radio Maintenance 700.00 0.00 0.00 700.00 100.00
E25 Repairs & Maintenance 60,330.95 33,807.23 200.00 26,323.72 43.63
10-330-572020 Purchase Of Equipment 2,094.00 2,094.00 0.00 0.00 0.00
10-330-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 2,094.00 2,094.00 0.00 0.00 0.00
10-330-578069 Animal Shelter 61,689.28 61,689.28 0.00 0.00 0.00
E75 Capital Projects 61,689.28 61,689.28 0.00 0.00 0.00
330 Animal Control 668,281.72 501,841.58 200.00 166,240.14 24.88
390 9-1-1 Police
10-390-501020 Salaries 816,560.64 630,160.01 0.00 186,400.63 22.83
10-390-501030 Holiday Pay 29,988.00 24,166.39 0.00 5,821.61 19.41
10-390-501050 Parttime(wo Benefits)210.00 150.00 0.00 60.00 28.57
10-390-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00
10-390-501090 Overtime 15,814.00 11,804.26 0.00 4,009.74 25.36
10-390-501095 Overtime Straight Pay 500.00 36.04 0.00 463.96 92.79
10-390-502010 Social Security 67,111.40 48,168.06 0.00 18,943.34 28.23
10-390-502020 Group Health Insurance 163,307.38 109,578.71 0.00 53,728.67 32.90
GL - Trial Balance by Full Acct Number (08/19/2013 - 8:34 AM)Page 18
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-390-502030 Retirement 155,143.26 114,090.57 0.00 41,052.69 26.46
10-390-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
10-390-502050 Life Insurance 1,442.94 1,012.03 0.00 430.91 29.86
10-390-502060 Long Term Disability 2,021.54 1,590.27 0.00 431.27 21.33
10-390-502070 Employee Assistance Prgm 463.64 343.83 0.00 119.81 25.84
10-390-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 1,252,562.80 941,100.17 0.00 311,462.63 24.87
10-390-511010 Advertising 1,200.00 0.00 0.00 1,200.00 100.00
10-390-512010 Printing 300.00 0.00 0.00 300.00 100.00
10-390-517010 Operational Supplies 5,000.00 2,665.00 0.00 2,335.00 46.70
E10 Materials & Supplies 6,500.00 2,665.00 0.00 3,835.00 59.00
10-390-520030 Dues And Publications 900.00 510.00 0.00 390.00 43.33
10-390-520050 Meeting And Conferences 1,764.69 1,764.69 0.00 0.00 0.00
10-390-520070 Training And Education 2,735.31 1,871.99 0.00 863.32 31.56
10-390-522020 Professional Services 2,000.00 923.00 0.00 1,077.00 53.85
10-390-523010 Equipment Rentlease 100,000.00 80,607.08 1,620.00 17,772.92 17.77
E15 Contractual Services 107,400.00 85,676.76 1,620.00 20,103.24 18.72
10-390-534010 Telephone 159.00 0.00 0.00 159.00 100.00
E20 Utilities 159.00 0.00 0.00 159.00 100.00
10-390-546010 Clothing Expense 3,400.00 788.86 0.00 2,611.14 76.80
10-390-546020 Uniform Cleaning 2,000.00 0.00 0.00 2,000.00 100.00
10-390-547010 Equipment Maintenance 2,272.45 2,272.45 0.00 0.00 0.00
10-390-547020 Maintenance Agreements 24,392.52 21,097.10 3,295.42 0.00 0.00
10-390-547030 Radio Maintenance 2,675.03 1,483.24 0.00 1,191.79 44.55
E25 Repairs & Maintenance 34,740.00 25,641.65 3,295.42 5,802.93 16.70
10-390-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00
390 9-1-1 Police 1,401,361.80 1,055,083.58 4,915.42 341,362.80 24.36
400 Fire Department
10-400-501020 Salaries 3,562,022.04 2,770,265.80 0.00 791,756.24 22.23
10-400-501030 Holiday Pay 282,478.80 248,350.24 0.00 34,128.56 12.08
10-400-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00
10-400-501080 Step-up Pay 28,000.00 21,414.52 0.00 6,585.48 23.52
10-400-501090 Overtime 30,000.00 32,609.99 0.00 -2,609.99 -8.70
10-400-501095 Overtime Straight Pay 32,000.00 19,408.62 0.00 12,591.38 39.35
10-400-502010 Social Security 86,218.37 39,794.71 0.00 46,423.66 53.84
10-400-502020 Group Health Insurance 572,264.23 423,604.58 0.00 148,659.65 25.98
10-400-502030 Retirement 1,619,822.08 1,270,620.81 0.00 349,201.27 21.56
10-400-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
10-400-502050 Life Insurance 6,242.77 4,440.37 0.00 1,802.40 28.87
10-400-502060 Long Term Disability 8,662.18 6,993.33 0.00 1,668.85 19.27
10-400-502070 Employee Assistance Prgm 1,632.56 1,244.33 0.00 388.23 23.78
GL - Trial Balance by Full Acct Number (08/19/2013 - 8:34 AM)Page 19
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-400-503010 Awards Program 2,245.00 2,242.59 0.00 2.41 0.11
E05 Personnel Services 6,231,588.03 4,840,989.89 0.00 1,390,598.14 22.32
10-400-511010 Advertising 350.00 75.00 0.00 275.00 78.57
10-400-511020 Postage 640.00 79.52 0.00 560.48 87.58
10-400-512010 Printing 1,250.00 750.83 0.00 499.17 39.93
10-400-512020 Copies 200.00 0.42 0.00 199.58 99.79
10-400-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00
10-400-513010 Office Supplies 1,800.00 1,470.68 0.00 329.32 18.30
10-400-514020 Chemicals 2,000.00 1,033.84 0.00 966.16 48.31
10-400-514030 Small Tools 2,500.00 1,557.83 0.00 942.17 37.69
10-400-514040 Food 20.00 0.00 0.00 20.00 100.00
10-400-515040 First Aid Supplies 400.00 53.66 0.00 346.34 86.59
10-400-517010 Operational Supplies 7,500.00 6,087.97 1,317.52 94.51 1.26
E10 Materials & Supplies 16,660.00 11,109.75 1,317.52 4,232.73 25.41
10-400-520030 Dues And Publications 1,300.00 1,292.73 0.00 7.27 0.56
10-400-520050 Meeting And Conferences 60.00 53.54 0.00 6.46 10.77
10-400-520060 Wellness Program 0.00 0.00 0.00 0.00 0.00
10-400-520070 Training And Education 9,120.00 8,426.51 0.00 693.49 7.60
10-400-520080 Tuition Reimbursement 600.00 0.00 0.00 600.00 100.00
10-400-520085 Traing-Home Land Security 0.00 0.00 0.00 0.00 0.00
10-400-521040 Medical Claimsservices 3,980.00 2,184.00 0.00 1,796.00 45.13
10-400-522020 Professional Services 900.00 300.00 0.00 600.00 66.67
10-400-523010 Equipment Rentlease 2,500.00 0.00 0.00 2,500.00 100.00
10-400-524010 Trash Collections 500.00 0.00 0.00 500.00 100.00
10-400-529010 Special Events 8,055.00 1,247.09 0.00 6,807.91 84.52
10-400-529040 Fire Hydrants 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 27,015.00 13,503.87 0.00 13,511.13 50.01
10-400-531010 Electricity 39,500.00 32,957.33 0.00 6,542.67 16.56
10-400-533010 Natural Gas 1,500.00 0.00 0.00 1,500.00 100.00
10-400-534010 Telephone 15,000.00 13,284.50 0.00 1,715.50 11.44
10-400-535010 Water 8,720.00 7,388.37 0.00 1,331.63 15.27
E20 Utilities 64,720.00 53,630.20 0.00 11,089.80 17.14
10-400-540010 Building & Grounds Maint.43,326.00 28,499.11 989.75 13,837.14 31.94
10-400-541030 Vehicle Wash 1,608.00 1,206.00 0.00 402.00 25.00
10-400-546010 Clothing Expense 35,000.00 16,174.70 -1,298.22 20,123.52 57.50
10-400-546020 Uniform Cleaning 1,066.00 1,065.01 0.00 0.99 0.09
10-400-547010 Equipment Maintenance 18,000.00 7,847.50 0.00 10,152.50 56.40
10-400-547020 Maintenance Agreements 18,400.00 8,278.65 4,920.10 5,201.25 28.27
10-400-547030 Radio Maintenance 7,000.00 1,915.61 0.00 5,084.39 72.63
E25 Repairs & Maintenance 124,400.00 64,986.58 4,611.63 54,801.79 44.05
10-400-572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00
10-400-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
10-400-572021 Purchase of Equipment-ONE TIME 815,000.00 702,062.10 83,294.22 29,643.68 3.64
10-400-572060 Fire Grant Equipgear 0.00 0.00 0.00 0.00 0.00
GL - Trial Balance by Full Acct Number (08/19/2013 - 8:34 AM)Page 20
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-400-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 815,000.00 702,062.10 83,294.22 29,643.68 3.64
400 Fire Department 7,279,383.03 5,686,282.39 89,223.37 1,503,877.27 20.66
500 Public Works
10-500-501020 Salaries 0.00 0.00 0.00 0.00 0.00
10-500-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00
10-500-501090 Overtime 0.00 0.00 0.00 0.00 0.00
10-500-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00
10-500-502010 Social Security 0.00 0.00 0.00 0.00 0.00
10-500-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00
10-500-502030 Retirement 0.00 0.00 0.00 0.00 0.00
10-500-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
10-500-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00
10-500-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00
10-500-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 0.00 0.00 0.00 0.00 0.00
10-500-511010 Advertising 0.00 0.00 0.00 0.00 0.00
10-500-511020 Postage 0.00 0.00 0.00 0.00 0.00
10-500-512010 Printing 0.00 0.00 0.00 0.00 0.00
10-500-512020 Copies 0.00 0.00 0.00 0.00 0.00
10-500-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00
10-500-514040 Food 0.00 0.00 0.00 0.00 0.00
10-500-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00
E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00
10-500-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00
10-500-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00
10-500-520070 Training And Education 0.00 -229.50 0.00 229.50 0.00
10-500-522020 Professional Services 0.00 0.00 0.00 0.00 0.00
10-500-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00
10-500-527010 Comm Serv Projects 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 0.00 -229.50 0.00 229.50 0.00
10-500-534010 Telephone 0.00 0.00 0.00 0.00 0.00
E20 Utilities 0.00 0.00 0.00 0.00 0.00
10-500-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00
E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00
10-500-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
10-500-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00
500 Public Works 0.00 -229.50 0.00 229.50 0.00
520 Plan & Protect Svcs-Admin
GL - Trial Balance by Full Acct Number (08/19/2013 - 8:34 AM)Page 21
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-520-501020 Salaries 202,276.20 155,796.68 0.00 46,479.52 22.98
10-520-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00
10-520-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00
10-520-501090 Overtime 0.00 0.00 0.00 0.00 0.00
10-520-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00
10-520-502010 Social Security 15,473.42 11,501.41 0.00 3,972.01 25.67
10-520-502020 Group Health Insurance 28,707.00 21,681.47 0.00 7,025.53 24.47
10-520-502030 Retirement 35,451.00 29,211.32 0.00 6,239.68 17.60
10-520-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
10-520-502050 Life Insurance 360.00 258.28 0.00 101.72 28.26
10-520-502060 Long Term Disability 494.76 378.60 0.00 116.16 23.48
10-520-502070 Employee Assistance Prgm 88.80 65.50 0.00 23.30 26.24
10-520-503010 Awards Program 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 282,851.18 218,893.26 0.00 63,957.92 22.61
10-520-511010 Advertising 500.00 470.55 0.00 29.45 5.89
10-520-511020 Postage 150.00 142.17 0.00 7.83 5.22
10-520-512010 Printing 100.00 0.00 0.00 100.00 100.00
10-520-512020 Copies 0.00 0.00 0.00 0.00 0.00
10-520-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00
10-520-513010 Office Supplies 500.00 420.19 0.00 79.81 15.96
10-520-514030 Small Tools 0.00 0.00 0.00 0.00 0.00
10-520-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00
10-520-517010 Operational Supplies 150.00 18.00 0.00 132.00 88.00
E10 Materials & Supplies 1,400.00 1,050.91 0.00 349.09 24.94
10-520-520030 Dues And Publications 400.00 381.75 0.00 18.25 4.56
10-520-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00
10-520-520070 Training And Education 99.00 99.00 0.00 0.00 0.00
10-520-522020 Professional Services 600.00 95.65 0.00 504.35 84.06
E15 Contractual Services 1,099.00 576.40 0.00 522.60 47.55
10-520-534010 Telephone 74.19 0.00 0.00 74.19 100.00
E20 Utilities 74.19 0.00 0.00 74.19 100.00
10-520-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00
10-520-547020 Maintenance Agreements 770.81 704.33 57.12 9.36 1.21
E25 Repairs & Maintenance 770.81 704.33 57.12 9.36 1.21
10-520-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00
520 Plan & Protect Svcs-Admin 286,195.18 221,224.90 57.12 64,913.16 22.68
521 Plan & Protect Svcs-Planning
10-521-501020 Salaries 51,387.60 39,317.26 0.00 12,070.34 23.49
10-521-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00
10-521-501050 Parttime(wo Benefits)12,480.00 8,448.00 0.00 4,032.00 32.31
10-521-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00
GL - Trial Balance by Full Acct Number (08/19/2013 - 8:34 AM)Page 22
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-521-501090 Overtime 0.00 0.00 0.00 0.00 0.00
10-521-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00
10-521-502010 Social Security 5,657.08 3,654.06 0.00 2,003.02 35.41
10-521-502020 Group Health Insurance 5,638.50 3,984.13 0.00 1,654.37 29.34
10-521-502030 Retirement 9,009.20 7,371.62 0.00 1,637.58 18.18
10-521-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
10-521-502050 Life Insurance 90.00 64.94 0.00 25.06 27.84
10-521-502060 Long Term Disability 121.21 103.22 0.00 17.99 14.84
10-521-502070 Employee Assistance Prgm 22.20 16.37 0.00 5.83 26.26
10-521-503010 Awards Program 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 84,405.79 62,959.60 0.00 21,446.19 25.41
10-521-511010 Advertising 5,300.00 2,484.50 0.00 2,815.50 53.12
10-521-511020 Postage 2,000.00 979.68 0.00 1,020.32 51.02
10-521-512010 Printing 0.00 0.00 0.00 0.00 0.00
10-521-512020 Copies 100.00 2.32 0.00 97.68 97.68
10-521-512030 Photographic Supplies 30.00 0.00 0.00 30.00 100.00
10-521-513010 Office Supplies 1,265.00 733.59 0.00 531.41 42.01
10-521-514040 Food 0.00 0.00 0.00 0.00 0.00
10-521-515040 First Aid Supplies 10.00 0.00 0.00 10.00 100.00
10-521-517010 Operational Supplies 2,000.00 1,967.10 0.00 32.90 1.65
E10 Materials & Supplies 10,705.00 6,167.19 0.00 4,537.81 42.39
10-521-520030 Dues And Publications 15,100.00 15,083.70 0.00 16.30 0.11
10-521-520050 Meeting And Conferences 322.00 0.00 0.00 322.00 100.00
10-521-520070 Training And Education 0.00 0.00 0.00 0.00 0.00
10-521-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00
10-521-522020 Professional Services 78.00 78.00 0.00 0.00 0.00
10-521-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 15,500.00 15,161.70 0.00 338.30 2.18
10-521-534010 Telephone 0.00 0.00 0.00 0.00 0.00
E20 Utilities 0.00 0.00 0.00 0.00 0.00
10-521-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00
10-521-547020 Maintenance Agreements 1,710.00 1,356.10 310.98 42.92 2.51
E25 Repairs & Maintenance 1,710.00 1,356.10 310.98 42.92 2.51
10-521-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00
521 Plan & Protect Svcs-Planning 112,320.79 85,644.59 310.98 26,365.22 23.47
522 Plan & Protect Svcs-MPO
10-522-501020 Salaries 126,439.20 96,711.60 0.00 29,727.60 23.51
10-522-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00
10-522-501090 Overtime 0.00 0.00 0.00 0.00 0.00
10-522-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00
10-522-502010 Social Security 9,669.66 6,851.98 0.00 2,817.68 29.14
GL - Trial Balance by Full Acct Number (08/19/2013 - 8:34 AM)Page 23
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-522-502020 Group Health Insurance 17,556.00 11,402.77 0.00 6,153.23 35.05
10-522-502030 Retirement 22,159.40 16,151.71 0.00 6,007.69 27.11
10-522-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
10-522-502050 Life Insurance 220.00 139.32 0.00 80.68 36.67
10-522-502060 Long Term Disability 312.98 218.45 0.00 94.53 30.20
10-522-502070 Employee Assistance Prgm 44.40 32.74 0.00 11.66 26.26
E05 Personnel Services 176,401.64 131,508.57 0.00 44,893.07 25.45
10-522-511010 Advertising 1,000.00 739.35 0.00 260.65 26.07
10-522-511020 Postage 700.00 142.08 0.00 557.92 79.70
10-522-512010 Printing 1,200.00 0.00 0.00 1,200.00 100.00
10-522-512020 Copies 500.00 0.00 0.00 500.00 100.00
10-522-513010 Office Supplies 500.00 262.30 0.00 237.70 47.54
10-522-514040 Food 300.00 183.53 0.00 116.47 38.82
10-522-517010 Operational Supplies 800.00 21.00 0.00 779.00 97.38
E10 Materials & Supplies 5,000.00 1,348.26 0.00 3,651.74 73.03
10-522-520030 Dues And Publications 800.00 615.49 0.00 184.51 23.06
10-522-520050 Meeting And Conferences 2,188.00 0.00 0.00 2,188.00 100.00
10-522-520070 Training And Education 1,374.42 0.00 0.00 1,374.42 100.00
10-522-522020 Professional Services 0.00 0.00 0.00 0.00 0.00
10-522-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 4,362.42 615.49 0.00 3,746.93 85.89
10-522-534010 Telephone 100.00 0.00 0.00 100.00 100.00
E20 Utilities 100.00 0.00 0.00 100.00 100.00
10-522-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00
10-522-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00
10-522-547020 Maintenance Agreements 2,925.58 589.84 140.16 2,195.58 75.05
10-522-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00
E25 Repairs & Maintenance 2,925.58 589.84 140.16 2,195.58 75.05
10-522-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00
522 Plan & Protect Svcs-MPO 188,789.64 134,062.16 140.16 54,587.32 28.91
530 Plan & Protect Svc-RedevGrant
10-530-501020 Salaries 112,433.52 55,135.08 0.00 57,298.44 50.96
10-530-501090 Overtime 0.00 0.00 0.00 0.00 0.00
10-530-502010 Social Security 8,596.77 3,938.21 0.00 4,658.56 54.19
10-530-502020 Group Health Insurance 9,658.85 5,275.31 0.00 4,383.54 45.38
10-530-502030 Retirement 19,432.96 5,367.97 0.00 14,064.99 72.38
10-530-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
10-530-502050 Life Insurance 157.32 81.52 0.00 75.80 48.18
10-530-502060 Long Term Disability 281.51 127.70 0.00 153.81 54.64
10-530-502070 Employee Assistance Prgm 37.57 32.74 0.00 4.83 12.86
E05 Personnel Services 150,598.50 69,958.53 0.00 80,639.97 53.55
GL - Trial Balance by Full Acct Number (08/19/2013 - 8:34 AM)Page 24
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-530-511010 Advertising 0.00 0.00 0.00 0.00 0.00
10-530-511020 Postage 20.00 18.51 0.00 1.49 7.45
10-530-513010 Office Supplies 80.00 47.70 0.00 32.30 40.38
E10 Materials & Supplies 100.00 66.21 0.00 33.79 33.79
10-530-520030 Dues And Publications 324.00 324.00 0.00 0.00 0.00
10-530-520050 Meeting And Conferences 720.98 681.98 0.00 39.00 5.41
10-530-520070 Training And Education 211.00 211.00 0.00 0.00 0.00
E15 Contractual Services 1,255.98 1,216.98 0.00 39.00 3.11
10-530-534010 Telephone 0.00 0.00 0.00 0.00 0.00
E20 Utilities 0.00 0.00 0.00 0.00 0.00
10-530-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00
10-530-547020 Maintenance Agreements 587.02 370.64 77.88 138.50 23.59
E25 Repairs & Maintenance 587.02 370.64 77.88 138.50 23.59
10-530-550020 Neighborhood Reinvestment 28,532.00 23,834.20 0.00 4,697.80 16.47
10-530-550030 Old Town Projects 57,468.00 26,264.10 0.00 31,203.90 54.30
10-530-550035 Old Town Redev Committee 10,000.00 6,344.30 0.00 3,655.70 36.56
10-530-550037 Historic Preservation Comm 15,650.00 6,585.00 6,400.00 2,665.00 17.03
10-530-550050 Neighb Stablization Prog 101,406.88 373.25 0.00 101,033.63 99.63
10-530-550060 MSP 1,304,060.97 119,638.83 0.00 1,184,422.14 90.83
10-530-550090 Hazard Mitigation 146,834.23 54,118.42 0.00 92,715.81 63.14
E30 Other Operating Expenses 1,663,952.08 237,158.10 6,400.00 1,420,393.98 85.36
530 Plan & Protect Svc-RedevGrant 1,816,493.58 308,770.46 6,477.88 1,501,245.24 82.65
531 Plan & Protect Svcs-Build Reg
10-531-501020 Salaries 403,257.40 318,893.71 0.00 84,363.69 20.92
10-531-501060 Seasonal Salaries 21,320.00 0.00 0.00 21,320.00 100.00
10-531-501090 Overtime 740.00 0.00 0.00 740.00 100.00
10-531-501095 Overtime Straight Pay 130.00 0.00 0.00 130.00 100.00
10-531-502010 Social Security 42,061.01 23,174.00 0.00 18,887.01 44.90
10-531-502020 Group Health Insurance 51,516.11 41,441.42 0.00 10,074.69 19.56
10-531-502030 Retirement 68,838.57 53,258.35 0.00 15,580.22 22.63
10-531-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
10-531-502050 Life Insurance 656.52 446.98 0.00 209.54 31.92
10-531-502060 Long Term Disability 912.49 741.69 0.00 170.80 18.72
10-531-502070 Employee Assistance Prgm 163.08 130.98 0.00 32.10 19.68
E05 Personnel Services 589,595.18 438,087.13 0.00 151,508.05 25.70
10-531-511010 Advertising 200.00 45.50 0.00 154.50 77.25
10-531-511020 Postage 1,800.00 1,614.60 0.00 185.40 10.30
10-531-512010 Printing 700.00 0.00 0.00 700.00 100.00
10-531-512020 Copies 10.00 0.00 0.00 10.00 100.00
10-531-512030 Photographic Supplies 100.00 0.00 0.00 100.00 100.00
10-531-513010 Office Supplies 1,829.00 1,501.40 0.00 327.60 17.91
GL - Trial Balance by Full Acct Number (08/19/2013 - 8:34 AM)Page 25
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-531-514030 Small Tools 300.00 0.00 0.00 300.00 100.00
10-531-515040 First Aid Supplies 30.00 0.00 0.00 30.00 100.00
10-531-517010 Operational Supplies 1,589.42 1,522.65 0.00 66.77 4.20
E10 Materials & Supplies 6,558.42 4,684.15 0.00 1,874.27 28.58
10-531-520030 Dues And Publications 2,000.00 633.00 0.00 1,367.00 68.35
10-531-520050 Meeting And Conferences 719.96 108.00 0.00 611.96 85.00
10-531-520070 Training And Education 2,500.00 1,616.99 0.00 883.01 35.32
10-531-522020 Professional Services 25,000.00 19,780.50 0.00 5,219.50 20.88
10-531-522070 Legal Services 0.00 0.00 0.00 0.00 0.00
10-531-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00
10-531-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 30,219.96 22,138.49 0.00 8,081.47 26.74
10-531-534010 Telephone 137.98 0.00 0.00 137.98 100.00
E20 Utilities 137.98 0.00 0.00 137.98 100.00
10-531-541030 Vehicle Wash 540.00 420.00 0.00 120.00 22.22
10-531-546010 Clothing Expense 1,130.00 778.81 0.00 351.19 31.08
10-531-547010 Equipment Maintenance 60.00 0.00 0.00 60.00 100.00
10-531-547020 Maintenance Agreements 1,982.64 1,262.71 591.37 128.56 6.48
10-531-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00
E25 Repairs & Maintenance 3,712.64 2,461.52 591.37 659.75 17.77
10-531-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00
531 Plan & Protect Svcs-Build Reg 630,224.18 467,371.29 591.37 162,261.52 25.75
532 Plan & Protect Svcs-Env Health
10-532-501020 Salaries 114,362.40 98,954.93 0.00 15,407.47 13.47
10-532-501060 Seasonal Salaries 3,957.00 1,972.00 0.00 1,985.00 50.16
10-532-501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00
10-532-501090 Overtime 220.00 0.00 0.00 220.00 100.00
10-532-501095 Overtime Straight Pay 60.00 0.00 0.00 60.00 100.00
10-532-502010 Social Security 10,381.54 7,429.01 0.00 2,952.53 28.44
10-532-502020 Group Health Insurance 17,356.50 14,297.03 0.00 3,059.47 17.63
10-532-502030 Retirement 20,099.00 18,554.11 0.00 1,544.89 7.69
10-532-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
10-532-502050 Life Insurance 200.00 163.64 0.00 36.36 18.18
10-532-502060 Long Term Disability 282.69 258.58 0.00 24.11 8.53
10-532-502070 Employee Assistance Prgm 44.40 32.74 0.00 11.66 26.26
10-532-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 166,963.53 141,662.04 0.00 25,301.49 15.15
10-532-511010 Advertising 800.00 84.50 0.00 715.50 89.44
10-532-511020 Postage 500.00 139.37 0.00 360.63 72.13
10-532-512010 Printing 0.00 0.00 0.00 0.00 0.00
10-532-512020 Copies 20.00 0.35 0.00 19.65 98.25
GL - Trial Balance by Full Acct Number (08/19/2013 - 8:34 AM)Page 26
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-532-512030 Photographic Supplies 20.00 0.00 0.00 20.00 100.00
10-532-513010 Office Supplies 1,800.00 766.18 0.00 1,033.82 57.43
10-532-514030 Small Tools 50.00 0.00 0.00 50.00 100.00
10-532-515030 Insect Control 0.00 0.00 0.00 0.00 0.00
10-532-515040 First Aid Supplies 30.00 0.00 0.00 30.00 100.00
10-532-517010 Operational Supplies 1,800.00 468.26 0.00 1,331.74 73.99
E10 Materials & Supplies 5,020.00 1,458.66 0.00 3,561.34 70.94
10-532-520030 Dues And Publications 880.00 794.90 0.00 85.10 9.67
10-532-520050 Meeting And Conferences 400.00 255.00 0.00 145.00 36.25
10-532-520070 Training And Education 400.00 99.00 0.00 301.00 75.25
10-532-521040 Medical Claimsservices 100.00 0.00 0.00 100.00 100.00
10-532-522020 Professional Services 4,224.90 605.00 2,595.00 1,024.90 24.26
10-532-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00
10-532-524020 Recycle Collectprocess 1,000.00 0.00 0.00 1,000.00 100.00
10-532-524025 Glass Recycling 6,247.82 4,382.78 1,870.00 -4.96 -0.08
10-532-524026 Household Hazardous Waste 16,000.00 8,563.81 -1,660.85 9,097.04 56.86
10-532-524027 Portable Recycling 0.00 0.00 0.00 0.00 0.00
10-532-524028 Misc Recycling 7,752.18 5,650.25 0.00 2,101.93 27.11
10-532-524030 Compost Services 212,000.00 159,000.03 53,000.01 -0.04 0.00
10-532-529010 Special Events 0.00 0.00 0.00 0.00 0.00
10-532-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 249,004.90 179,350.77 55,804.16 13,849.97 5.56
10-532-534010 Telephone 1,320.00 0.00 0.00 1,320.00 100.00
E20 Utilities 1,320.00 0.00 0.00 1,320.00 100.00
10-532-540060 Cemetery Maintenance 22,956.42 17,173.32 5,730.00 53.10 0.23
10-532-540065 Cemetery Exp from Donations 0.00 0.00 0.00 0.00 0.00
10-532-541030 Vehicle Wash 1,290.00 963.00 0.00 327.00 25.35
10-532-546010 Clothing Expense 520.00 160.00 0.00 360.00 69.23
10-532-547010 Equipment Maintenance 80.00 0.00 0.00 80.00 100.00
10-532-547020 Maintenance Agreements 1,018.68 715.64 202.85 100.19 9.84
10-532-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00
E25 Repairs & Maintenance 25,865.10 19,011.96 5,932.85 920.29 3.56
10-532-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00
532 Plan & Protect Svcs-Env Health 448,173.53 341,483.43 61,737.01 44,953.09 10.03
535 Public Works-Central Maintenan
10-535-501020 Salaries 343,750.20 255,341.73 0.00 88,408.47 25.72
10-535-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00
10-535-501050 Parttime(wo Benefits)7,400.00 5,385.23 0.00 2,014.77 27.23
10-535-501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00
10-535-501090 Overtime 1,800.00 1,603.31 0.00 196.69 10.93
10-535-501095 Overtime Straight Pay 200.00 63.14 0.00 136.86 68.43
10-535-502010 Social Security 27,395.62 18,778.53 0.00 8,617.09 31.45
GL - Trial Balance by Full Acct Number (08/19/2013 - 8:34 AM)Page 27
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-535-502020 Group Health Insurance 70,056.00 57,130.58 0.00 12,925.42 18.45
10-535-502030 Retirement 61,498.90 48,185.45 0.00 13,313.45 21.65
10-535-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
10-535-502050 Life Insurance 600.00 417.18 0.00 182.82 30.47
10-535-502060 Long Term Disability 848.09 659.34 0.00 188.75 22.26
10-535-502070 Employee Assistance Prgm 177.60 130.98 0.00 46.62 26.25
10-535-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 513,726.41 387,695.47 0.00 126,030.94 24.53
10-535-511010 Advertising 80.00 0.00 0.00 80.00 100.00
10-535-511020 Postage 300.00 12.12 0.00 287.88 95.96
10-535-512020 Copies 0.70 0.70 0.00 0.00 0.00
10-535-513010 Office Supplies 1,899.30 1,241.35 0.00 657.95 34.64
10-535-514011 Gas, Oil, & Antifreeze 0.00 584.10 0.00 -584.10 0.00
10-535-514030 Small Tools 9,000.00 5,344.65 0.00 3,655.35 40.62
10-535-517010 Operational Supplies 9,100.00 8,648.53 0.00 451.47 4.96
E10 Materials & Supplies 20,380.00 15,831.45 0.00 4,548.55 22.32
10-535-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00
10-535-520050 Meeting And Conferences 400.00 24.00 0.00 376.00 94.00
10-535-520070 Training And Education 1,000.00 412.51 0.00 587.49 58.75
10-535-521040 Medical Claimsservices 430.00 0.00 0.00 430.00 100.00
10-535-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00
10-535-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 1,830.00 436.51 0.00 1,393.49 76.15
10-535-531010 Electricity 6,050.00 5,412.62 0.00 637.38 10.54
10-535-533010 Natural Gas 6,950.00 6,566.35 0.00 383.65 5.52
10-535-534010 Telephone 320.00 0.00 0.00 320.00 100.00
10-535-535010 Water 1,215.00 1,019.82 0.00 195.18 16.06
E20 Utilities 14,535.00 12,998.79 0.00 1,536.21 10.57
10-535-540010 Building & Grounds Maint.9,000.00 5,915.63 25.00 3,059.37 33.99
10-535-541010 Veh & Equip Parts Etc 405,000.00 240,024.85 0.00 164,975.15 40.73
10-535-546010 Clothing Expense 7,000.00 5,800.70 0.00 1,199.30 17.13
10-535-547010 Equipment Maintenance 3,000.00 2,665.09 0.00 334.91 11.16
10-535-547020 Maintenance Agreements 3,500.00 1,274.10 0.00 2,225.90 63.60
10-535-547030 Radio Maintenance 500.00 0.00 0.00 500.00 100.00
E25 Repairs & Maintenance 428,000.00 255,680.37 25.00 172,294.63 40.26
10-535-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00
535 Public Works-Central Maintenan 978,471.41 672,642.59 25.00 305,803.82 31.25
540 Public Works-Admin
10-540-501020 Salaries 189,536.40 145,577.83 0.00 43,958.57 23.19
10-540-501090 Overtime 0.00 0.00 0.00 0.00 0.00
10-540-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00
GL - Trial Balance by Full Acct Number (08/19/2013 - 8:34 AM)Page 28
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-540-502010 Social Security 16,164.30 10,505.63 0.00 5,658.67 35.01
10-540-502020 Group Health Insurance 23,278.50 17,997.73 0.00 5,280.77 22.69
10-540-502030 Retirement 37,228.60 27,051.77 0.00 10,176.83 27.34
10-540-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
10-540-502050 Life Insurance 410.00 232.13 0.00 177.87 43.38
10-540-502060 Long Term Disability 524.46 319.14 0.00 205.32 39.15
10-540-502070 Employee Assistance Prgm 66.60 49.11 0.00 17.49 26.26
E05 Personnel Services 267,208.86 201,733.34 0.00 65,475.52 24.50
10-540-511010 Advertising 400.00 0.00 0.00 400.00 100.00
10-540-511020 Postage 230.00 11.48 0.00 218.52 95.01
10-540-512010 Printing 1,230.00 201.00 0.00 1,029.00 83.66
10-540-512020 Copies 100.00 0.18 0.00 99.82 99.82
10-540-513010 Office Supplies 1,100.00 206.17 0.00 893.83 81.26
10-540-514040 Food 650.00 632.49 0.00 17.51 2.69
10-540-517010 Operational Supplies 1,400.00 4.99 0.00 1,395.01 99.64
E10 Materials & Supplies 5,110.00 1,056.31 0.00 4,053.69 79.33
10-540-520030 Dues And Publications 1,300.00 500.50 0.00 799.50 61.50
10-540-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00
10-540-520070 Training And Education 2,400.00 503.00 0.00 1,897.00 79.04
10-540-522020 Professional Services 900.00 163.15 0.00 736.85 81.87
10-540-527010 Comm Serv Projects 1,000.00 85.35 0.00 914.65 91.47
E15 Contractual Services 5,600.00 1,252.00 0.00 4,348.00 77.64
10-540-534010 Telephone 924.00 0.00 0.00 924.00 100.00
E20 Utilities 924.00 0.00 0.00 924.00 100.00
10-540-547020 Maintenance Agreements 930.00 657.57 202.85 69.58 7.48
E25 Repairs & Maintenance 930.00 657.57 202.85 69.58 7.48
10-540-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00
540 Public Works-Admin 279,772.86 204,699.22 202.85 74,870.79 26.76
541 Public Works-Engineering
10-541-501020 Salaries 742,215.90 579,933.26 0.00 162,282.64 21.86
10-541-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00
10-541-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00
10-541-501060 Seasonal Salaries 2,000.00 993.75 0.00 1,006.25 50.31
10-541-501080 Step-up Pay 0.00 0.00 0.00 0.00 0.00
10-541-501090 Overtime 500.00 0.00 0.00 500.00 100.00
10-541-501095 Overtime Straight Pay 500.00 0.00 0.00 500.00 100.00
10-541-502010 Social Security 57,855.03 42,449.47 0.00 15,405.56 26.63
10-541-502020 Group Health Insurance 102,005.55 74,868.03 0.00 27,137.52 26.60
10-541-502030 Retirement 129,184.51 108,749.70 0.00 20,434.81 15.82
10-541-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
10-541-502050 Life Insurance 1,299.69 951.66 0.00 348.03 26.78
GL - Trial Balance by Full Acct Number (08/19/2013 - 8:34 AM)Page 29
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-541-502060 Long Term Disability 1,819.00 1,469.47 0.00 349.53 19.22
10-541-502070 Employee Assistance Prgm 275.79 229.22 0.00 46.57 16.89
10-541-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 1,037,655.47 809,644.56 0.00 228,010.91 21.97
10-541-511010 Advertising 1,400.00 969.50 0.00 430.50 30.75
10-541-511020 Postage 1,500.00 377.24 0.00 1,122.76 74.85
10-541-512010 Printing 100.00 31.00 0.00 69.00 69.00
10-541-512020 Copies 199.65 110.08 0.00 89.57 44.86
10-541-512030 Photographic Supplies 175.35 0.00 0.00 175.35 100.00
10-541-513010 Office Supplies 7,900.00 3,361.58 0.00 4,538.42 57.45
10-541-514030 Small Tools 500.00 469.15 0.00 30.85 6.17
10-541-514040 Food 150.00 100.47 0.00 49.53 33.02
10-541-515040 First Aid Supplies 50.00 0.00 0.00 50.00 100.00
10-541-515070 Const & Inspect Supplies 2,000.00 346.40 0.00 1,653.60 82.68
10-541-515080 Surveying Supplies 2,000.00 911.01 0.00 1,088.99 54.45
10-541-517010 Operational Supplies 1,150.00 339.75 0.00 810.25 70.46
E10 Materials & Supplies 17,125.00 7,016.18 0.00 10,108.82 59.03
10-541-520030 Dues And Publications 4,000.00 3,279.77 0.00 720.23 18.01
10-541-520050 Meeting And Conferences 1,000.00 240.00 0.00 760.00 76.00
10-541-520070 Training And Education 2,500.00 314.00 0.00 2,186.00 87.44
10-541-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00
10-541-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00
10-541-522020 Professional Services 4,000.00 196.00 0.00 3,804.00 95.10
E15 Contractual Services 11,500.00 4,029.77 0.00 7,470.23 64.96
10-541-534010 Telephone 1,650.00 337.61 0.00 1,312.39 79.54
E20 Utilities 1,650.00 337.61 0.00 1,312.39 79.54
10-541-541020 Veh Maintenance 560.00 0.00 0.00 560.00 100.00
10-541-541030 Vehicle Wash 720.00 720.00 0.00 0.00 0.00
10-541-546010 Clothing Expense 1,000.00 431.07 0.00 568.93 56.89
10-541-547010 Equipment Maintenance 1,480.00 588.45 0.00 891.55 60.24
10-541-547020 Maintenance Agreements 17,000.00 8,100.79 446.83 8,452.38 49.72
10-541-547030 Radio Maintenance 200.00 0.00 0.00 200.00 100.00
E25 Repairs & Maintenance 20,960.00 9,840.31 446.83 10,672.86 50.92
10-541-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00
10-541-576031 Misc Stormwater Projects 0.00 0.00 0.00 0.00 0.00
10-541-576035 SidewalkGreenway-JCMG 0.00 0.00 0.00 0.00 0.00
E75 Capital Projects 0.00 0.00 0.00 0.00 0.00
541 Public Works-Engineering 1,088,890.47 830,868.43 446.83 257,575.21 23.65
542 Public Works-Street
10-542-501020 Salaries 1,096,536.31 813,616.39 0.00 282,919.92 25.80
GL - Trial Balance by Full Acct Number (08/19/2013 - 8:34 AM)Page 30
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-542-501060 Seasonal Salaries 9,964.69 12,535.72 0.00 -2,571.03 -25.80
10-542-501070 Stand-by Plan 4,081.31 3,328.00 0.00 753.31 18.46
10-542-501090 Overtime 20,500.00 21,552.48 0.00 -1,052.48 -5.13
10-542-501095 Overtime Straight Pay 1,500.00 334.51 0.00 1,165.49 77.70
10-542-502010 Social Security 96,881.84 63,442.84 0.00 33,439.00 34.52
10-542-502020 Group Health Insurance 174,072.88 116,546.56 0.00 57,526.32 33.05
10-542-502030 Retirement 196,864.18 151,781.62 0.00 45,082.56 22.90
10-542-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
10-542-502050 Life Insurance 1,904.14 1,306.93 0.00 597.21 31.36
10-542-502060 Long Term Disability 2,659.61 2,048.54 0.00 611.07 22.98
10-542-502070 Employee Assistance Prgm 545.60 425.68 0.00 119.92 21.98
10-542-503010 Awards Program 350.00 335.00 0.00 15.00 4.29
10-542-503020 Unemployment Compensation 250.00 247.36 0.00 2.64 1.06
E05 Personnel Services 1,606,110.56 1,187,501.63 0.00 418,608.93 26.06
10-542-511010 Advertising 400.00 323.75 0.00 76.25 19.06
10-542-511020 Postage 150.00 142.47 0.00 7.53 5.02
10-542-512010 Printing 50.00 0.00 0.00 50.00 100.00
10-542-512020 Copies 50.35 33.22 0.00 17.13 34.02
10-542-513010 Office Supplies 2,000.00 994.00 0.00 1,006.00 50.30
10-542-514020 Chemicals 50,000.00 49,292.66 0.00 707.34 1.41
10-542-514030 Small Tools 9,000.00 5,408.06 0.00 3,591.94 39.91
10-542-514040 Food 1,385.38 1,307.79 0.00 77.59 5.60
10-542-515010 Stormwater Material 17,500.00 12,946.76 0.00 4,553.24 26.02
10-542-515020 Street Materials 245,324.00 153,062.22 -46,047.00 138,308.78 56.38
10-542-515040 First Aid Supplies 500.00 40.55 0.00 459.45 91.89
10-542-515060 Weed Control 2,000.00 253.88 0.00 1,746.12 87.31
10-542-515070 Const & Inspect Supplies 400.00 0.00 0.00 400.00 100.00
10-542-517010 Operational Supplies 4,500.00 4,252.74 0.00 247.26 5.49
E10 Materials & Supplies 333,259.73 228,058.10 -46,047.00 151,248.63 45.38
10-542-520030 Dues And Publications 346.00 346.00 0.00 0.00 0.00
10-542-520050 Meeting And Conferences 489.27 0.00 0.00 489.27 100.00
10-542-520070 Training And Education 1,000.00 269.00 0.00 731.00 73.10
10-542-521040 Medical Claimsservices 400.00 0.00 0.00 400.00 100.00
10-542-522020 Professional Services 14,956.00 13,582.00 1,100.00 274.00 1.83
10-542-523010 Equipment Rentlease 1,000.00 75.00 0.00 925.00 92.50
10-542-524010 Trash Collections 4,983.00 589.60 0.00 4,393.40 88.17
10-542-529070 Street Light Installation 1,676.00 1,582.89 0.00 93.11 5.56
E15 Contractual Services 24,850.27 16,444.49 1,100.00 7,305.78 29.40
10-542-531010 Electricity 42,500.00 19,950.44 0.00 22,549.56 53.06
10-542-531020 Street Lights 527,900.00 440,613.18 0.00 87,286.82 16.53
10-542-533010 Natural Gas 16,385.00 12,984.58 0.00 3,400.42 20.75
10-542-534010 Telephone 2,450.00 392.86 0.00 2,057.14 83.96
10-542-535010 Water 7,800.00 4,729.55 0.00 3,070.45 39.36
E20 Utilities 597,035.00 478,670.61 0.00 118,364.39 19.83
10-542-540010 Building & Grounds Maint.7,000.00 5,094.15 75.00 1,830.85 26.16
GL - Trial Balance by Full Acct Number (08/19/2013 - 8:34 AM)Page 31
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-542-541030 Vehicle Wash 6,620.00 5,238.00 0.00 1,382.00 20.88
10-542-542010 Repairs - Stop Lights 10,000.00 6,976.34 0.00 3,023.66 30.24
10-542-542030 Signs & Marking Paint 30,124.88 30,124.88 0.00 0.00 0.00
10-542-546010 Clothing Expense 12,000.00 4,803.63 0.00 7,196.37 59.97
10-542-547010 Equipment Maintenance 3,100.00 1,513.79 0.00 1,586.21 51.17
10-542-547020 Maintenance Agreements 1,275.12 297.60 12.00 965.52 75.72
10-542-547030 Radio Maintenance 100.00 55.00 0.00 45.00 45.00
E25 Repairs & Maintenance 70,220.00 54,103.39 87.00 16,029.61 22.83
10-542-572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00
10-542-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
10-542-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00
10-542-573050 Neighborhood Impr Projs 0.00 0.00 0.00 0.00 0.00
10-542-573060 Sidewalk Rep Program 0.00 0.00 0.00 0.00 0.00
10-542-573061 Street Crack Sealing 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00
542 Public Works-Street 2,631,475.56 1,964,778.22 -44,860.00 711,557.34 27.04
700 Transfers & Subsidies
10-700-590050 Transfer To Tif Fund 4,000.00 1,682.28 0.00 2,317.72 57.94
10-700-590070 Airport Subsidy 171,635.85 128,726.91 0.00 42,908.94 25.00
10-700-590075 Transit Subsidy 689,630.76 543,384.42 0.00 146,246.34 21.21
10-700-590080 Transfer To Amb Serv 0.00 0.00 0.00 0.00 0.00
E80 Transfers Out 865,266.61 673,793.61 0.00 191,473.00 22.13
700 Transfers & Subsidies 865,266.61 673,793.61 0.00 191,473.00 22.13
900 CapitalVehicleEquipment
10-900-571010 Capvehclequip-city Admin 0.00 0.00 0.00 0.00 0.00
10-900-571020 Capvhcleqp-code Enf-adm 0.00 0.00 0.00 0.00 0.00
10-900-571030 Capvhcleqp-bldg Regs 0.00 0.00 0.00 0.00 0.00
10-900-571040 Capvhcleqp-envir Health 0.00 0.00 0.00 0.00 0.00
10-900-571050 Capvhcleqp-p & Transp-adm 0.00 0.00 0.00 0.00 0.00
10-900-571060 Capvhcleqp-pub Works-adm 0.00 0.00 0.00 0.00 0.00
10-900-571070 Capvhcleqp-engineering 0.00 0.00 0.00 0.00 0.00
10-900-571080 Capvhcleqp-street 96,371.20 96,371.20 0.00 0.00 0.00
10-900-571090 Capvhcleqp-police 161,268.00 0.00 161,268.00 0.00 0.00
10-900-571100 Capvhcleqp-fire 0.00 0.00 0.00 0.00 0.00
10-900-571110 Capvhcleqp-animal Rescue 0.00 0.00 0.00 0.00 0.00
10-900-571120 Capvhcleqp-central Maint 0.00 0.00 0.00 0.00 0.00
10-900-571130 Capvhcleqp-airport 55,318.00 54,398.00 0.00 920.00 1.66
10-900-571140 Capvhcleqp-contingency 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 312,957.20 150,769.20 161,268.00 920.00 0.29
900 CapitalVehicleEquipment 312,957.20 150,769.20 161,268.00 920.00 0.29
Expense Expense 33,171,900.70 23,335,765.75 415,454.93 9,420,680.02 28.40
GL - Trial Balance by Full Acct Number (08/19/2013 - 8:34 AM)Page 32
FUND BALANCE CALCULATION
FYE 12 Unassigned General Fund Balance 4,681,316.00$ Per Audited CAFR
Reappropriation (50,417.16)$ Cole County Emergency Siren
Reappropriation (100,000.00)$ Prof Svcs to Columbia Airport
Reappropriation (815,000.00)$ Fire Dept ONE TIME PUCHASES
Reappropriation (23,851.06)$ Court Software - not completed in prior fiscal year
Supplemental Appropriation (5,000.00)$ Establish UHC Deductible Self Insurance Imprest Fund
Supplemental Appropriation (40,000.00)$ Election Expenses
Estimated Current Fund Balance 3,647,047.78$
CURRENT CURRENT YEAR-YTD
2012-2013 MONTH TO-DATE %BUDGET
FUND BUDGET ACTIVITY ACTUAL RECEIVED/SPENT VARIANCE
REVENUES:
Property Taxes $5,221,000 $18,886.47 $5,197,443.24 100%($23,557)
Sales Tax & Sale Tax Interest $9,700,000 $872,435.66 $5,685,967.41 59%($4,014,033)
Motor Vehicle Sales Tax $403,750 $28,312.72 $263,636.35 65%($140,114)
Gasoline Tax $1,100,950 $95,417.81 $621,607.82 56%($479,342)
Cigarette Tax $147,000 $10,653.28 $84,555.04 58%($62,445)
Franchise Fees $7,385,000 $670,722.04 $4,764,409.53 65%($2,620,590)
Intergovernmental $2,325,499 $54,330.31 $944,193.69 41%($1,381,305)
Charges for Services $1,988,660 $160,330.64 $1,398,937.88 70%($589,722)
Fees, Licenses & Permits $689,700 $62,904.77 $575,118.36 83%($114,582)
Fines & Forfeitures $1,050,980 $73,371.02 $715,141.19 68%($335,839)
Interest Income $40,000 $0.00 $65,242.50 163%$25,243
Other Operating Revenues $1,258,272 $127,709.13 $892,203.72 71%($366,068)
Operating Transfers In $20,990 $1,952.05 $32,220.82 154%$11,231
Police Grants $594,028 $20,787.69 $262,653.51 44%($331,374)
School Resource Officer $188,765 $0.00 $192,242.34 102%$3,477
M.U.S.T.A.N.G.$0 $7,357.77 $24,321.66 N/A $24,322
Transfer from (to) Surplus $986,566 $0.00 $0.00 N/A ($986,566)
Total General Fund $33,101,160 $2,205,171.36 $21,719,895.06 66%($11,381,265)
EXPENDITURES:
Council & Mayor $76,558 $5,838.03 $52,867.39 69%($23,690)
City Clerk $172,826 $7,499.86 $139,827.99 81%($32,998)
City Administrator $279,432 $19,259.15 $213,424.30 76%($66,008)
Entitlement Grant $306,020 $911.09 $45,318.76 15%($260,701)
City Counselor $342,026 $26,336.04 $242,654.36 71%($99,372)
Municipal Court $278,089 $20,265.66 $169,190.76 61%($108,898)
Human Resources $298,079 $22,592.24 $207,566.54 70%($90,512)
Finance $928,514 $61,332.71 $659,650.99 71%($268,863)
Non Departmental $2,554,586 $191,707.57 $1,590,513.90 62%($964,072)
IT Department $1,081,064 $67,912.00 $788,153.07 73%($292,911)
Police $7,307,307 $503,037.97 $5,142,006.13 70%($2,165,301)
School Resource Officer $374,485 $16,934.52 $237,689.94 63%($136,795)
M.U.S.T.A.N.G.$184,859 $11,250.58 $133,083.24 72%($51,775)
Animal Control $668,282 $50,138.77 $476,371.27 71%($191,910)
9-1-1 Police $1,401,362 $101,639.54 $1,001,241.94 71%($400,120)
Fire $7,279,383 $492,684.13 $5,458,416.72 75%($1,820,966)
Public Works $0 $0.00 ($229.50)N/A ($230)
Planning & Protective Services
Admin $286,195 $22,492.55 $209,690.58 73%($76,505)
Planning $112,321 $19,216.31 $81,906.63 73%($30,414)
Metropolitan Planning Org $188,790 $6,220.96 $129,505.06 69%($59,285)
Redevelopment/Grant $1,816,494 $61,760.85 $305,172.02 17%($1,511,322)
Building Regulations $630,224 $52,608.43 $422,543.65 67%($207,681)
Environmental Health $448,174 $43,858.60 $313,273.95 70%($134,900)
Public Works - Central Main $978,471 $67,976.11 $633,297.26 65%($345,174)
Public Works - Admin $279,773 $20,770.94 $194,311.63 69%($85,461)
Public Works - Engineering $1,088,890 $78,008.27 $790,726.70 73%($298,164)
Public Works - Street $2,631,476 $200,233.49 $1,836,560.75 70%($794,915)
Transfers & Subsidies $865,267 $63,051.77 $673,793.61 78%($191,473)
Capital/Vehicle/Equipment $312,957 $0.00 $54,398.00 17%($258,559)
$33,171,900 $2,235,538.14 $22,202,927.64 67%($10,968,973)
Fund Income (Loss)($70,741)*($30,366.78)($483,032.58)($412,292)
CITY OF JEFFERSON
GENERAL FUND
INCOME STATEMENT
FOR THE MONTH ENDING JULY 30, 2013
Tax Period
Due Date to
City Total Lodging Tax JCCVB (3/7)
JCCVB/Convention
Center Fund (4/7)
May-11 6/20/11 91,258.41 38,328.53 51,104.71
Jun-11 7/20/11 101,479.82 42,621.54 56,828.68
Jul-11 8/20/11 88,392.47 37,124.82 49,499.80
Aug-11 9/20/11 73,144.02 30,720.48 40,960.66
Sep-11 10/20/11 103,618.61 43,519.80 58,026.44
Oct-11 11/20/11 105,531.99 44,323.44 59,097.91
Nov-11 12/20/11 66,556.88 27,953.89 37,271.85
Dec-11 1/20/12 52,204.97 21,926.07 29,234.80
Jan-12 2/20/12 65,645.72 27,571.20 36,761.61
Feb-12 3/20/12 85,143.89 35,760.45 47,680.56
Mar-12 4/20/12 81,904.23 34,399.77 45,866.38
Apr-12 5/20/12 103,406.71 43,430.82 57,907.76
May-12 6/20/12 89,713.24 37,679.58 50,239.40
Jun-12 7/20/12 86,753.72 36,436.56 48,582.08
Jul-12 8/20/12 89,904.69 37,759.97 50,346.63
Aug-12 9/20/12 76,708.71 32,217.66 42,956.88
Sep-12 10/20/12 109,335.16 45,920.77 61,227.69
Oct-12 11/20/12 109,059.34 45,804.92 61,073.23
Nov-12 12/20/12 69,756.75 29,297.84 39,063.77
Dec-12 1/20/13 55,126.67 23,153.20 30,870.94
Jan-13 2/20/13 84,295.92 35,404.29 47,205.71
Feb-13 3/20/13 84,199.16 35,363.65 47,151.53
Mar-13 4/20/13 98,008.06 41,163.39 54,884.51
Apr-13 5/20/13 100,022.48 42,009.44 56,012.59
May-13 6/20/13 97,602.44 40,993.02 54,657.37
Jun-13 7/20/13 92,796.57 38,974.56 51,966.08
Total 2,261,570.63 949,859.66 1,266,479.57
average monthly amount for Convention Center Fund 48,710.75
Page 1 of 2
U:\Finance Committee Meetings\2013 Tax Collection Agreement.Docx
CITY OF JEFFERSON, MISSOURI
CALLAWAY COUNTY TAX COLLECTION AGREEMENT
This agreement , made and entered into this _______day of________________, 2013, by
and between the City of Jefferson, Missouri, a municipal corporation, and the County Collector
for Callaway County, Missouri, by and through the Callaway County Commission.
WITNESSETH:
WHEREAS, the City of Jefferson is a taxing authority under the constitution and laws of the
State of Missouri; and
WHEREAS, the Callaway County Collector and Callaway County Commission are each
concerned with the billing and collection of taxes for the State of Missouri and Callaway County,
Missouri, and other political subdivisions of the state; and
WHEREAS, all parties desire to consolidate the billing and collection of taxes, lawfully levied
by the City, with the billing and collection of other state and county taxes; and
WHEREAS, t he County Commission of Callaway County, Missouri, has made an order
authorizing the Presiding Commissioner to execute this contract ; and
WHEREAS, t he City Council of the City of Jefferson, has by ordinance authorized the Mayor to
execute this contract on behalf of the City.
NOW THEREFORE, in consideration of the sums hereinafter set out to be paid by the City of
Jefferson to the County Collector of Callaway County, Missouri, it is agreed as follows:
1. That the County Collector of Callaway County, Missouri, will provide the billing and
collection of the real estate taxes, personal property taxes and motor vehicle taxes for the City of
Jefferson and collection and disbursement of any payments, and that Callaway County will
provide the facilities needed by the Collector to do the same.
2. That all taxes collected by said County Collector shall be paid to the City of Jefferson on
a monthly basis via electronic transfer.
3. That the penalties for non-payment of city taxes shall be made to conform by the City of
Jefferson pursuant to Sections 139.100 and 140.100, RSMo, which is eighteen percent (18%) per
annum.
4. That a percentage (dependent upon the assessed value and tax dollars billed for collection
year) will be deducted from the tax collections each year and deposited into the Assessment
Fund (.016019 for 2013, plus 1/8% up to $125,000.00) as required by Section 137.750, 137.721,
& 137.720.2. Also, per RSMo 52.260, in addition the following percentage (.01000) will be
Page 2 of 2
U:\Finance Committee Meetings\2013 Tax Collection Agreement.Docx
deducted from the tax collections each year and deposited into General Revenue. These
percentages will remain as noted unless the Missouri State Legislature directs them to change.
5. That the County Collector shall follow the same procedure for the collection of
delinquent City real estate taxes as is prescribed by the statutes of the State of Missouri for the
collection of delinquent county real estate t axes, including all necessary sales of real estate. The
City of Jefferson’s personal property taxes shall, before the expiration of the statutes of
limitation, be certified by the County Collector to the Attorney of the City of Jefferson, who shall
institute and prosecute such suits.
5. That the City of Jefferson, Missouri, who shall submit a written request for a copy of the
tax roll from the Assessor no later than October 20 of each year. The City of Jefferson shall
validate a clean tax roll annually.
6. That the term of this contract shall begin upon signing and continue through July 31,
2017, unless sooner changed by operation of law, or by either party giving written notice sixty
days before the anniversary date of the contract that they intend to t erminate the relationship.
7. That upon termination of this contract, the County Collector shall make available to the
City of Jefferson of such tax records as may be necessary to enable the City of Jefferson to
collect the current year’s real, personal property and vehicle license taxes, as well as delinquent
real and personal property taxes as may be carried on the books of County Collector at the time
of termination.
IN WITNESS WHEREOF, the parties hereto have set their respective hands and seals the day
and year first above written.
CITY OF JEFFERSON CALLAWAY COUNTY
____________________________ ______________________________
Mayor Presiding Commissioner
ATTEST:
_____________________________ ______________________________
City Clerk Callaway County Collector
APPROVED AS TO FORM: ATTEST:
______________________________ _____________________________
City Counselor Callaway County Clerk
BILL SUMMARY
BILL NO: _______
SPONSOR:
SUBJECT: Contract with Callaway County Collector for Collection of Taxes
DATE INTRODUCED: ___
Summary: The Callaway County Tax Agreement requires the Collector of Callaway
County to provide billing and collection of real estate taxes, personal property taxes,
and motor vehicle taxes for the City of Jefferson and collection and disbursements of
any payment. Payment to the City will be made on a monthly basis. This contract will
be in effect through July 31, 2017.
Background Information: The Callaway County Collector’s office has been providing
the billing and collection of taxes for property within the corporate city limits of the City
of Jefferson and Callaway County since November 2009. The Collector’s office has
agreed to continue to provide this service to the City.
Fiscal Information: A percentage will be deducted from the tax collections each
year and deposited into the Assessment Fund (.016019 for 2013, plus 1/8% up to
$125,000.00) as required by Section 137.750, 137.721, & 137.720.2. Also, per RSMo
52.260, in addition the following percentage (.01000) will be deducted from the tax
collections each year and deposited into General Revenue. These percentages will
remain as noted unless the Missouri State Legislature direct s them to change.
Origin of Request: Finance Department
Department Responsible: Finance Department
Person Responsible: Bill Betts
Staff Recommendation: Approve
BILL NO. _______
SPONSORED BY COUNCILMAN ______
ORDINANCE NO.
AN ORDINANCE OF THE CITY OF JEFFERSON, MISSOURI, AUTHORIZING THE
MAYOR AND CITY CLERK TO EXECUTE AN AGREEMENT WITH THE CALLAWAY
COUNTY COLLECTOR FOR BILLING AND COLLECTION OF TAXES.
BE IT ENACTED BY THE COUNCIL OF THE CITY OF JEFFERSON, MISSOURI, AS
FOLLOWS:
Section 1. The Mayor and City Clerk are hereby authorized and directed to execute
an agreement with the Callaway County Collector for billing and collection of taxes.
Section 2. The agreement shall be substantially the same in form and content as that
agreement attached hereto as Exhibit A.
Section 3. This Ordinance shall be in full force and effect from and after the date of
its passage and approval.
Passed: Approved:
Presiding Officer Mayor
ATTEST: APPROVED AS TO FORM:
City Clerk City Counselor
BILL NO. [Bill No.]
SPONSORED BY COUNCILMAN _______________________
ORDINANCE NO.
AN ORDINANCE OF THE CITY OF JEFFERSON, MISSOURI, ADOPTING AN ECONOMIC
INCENTIVE POLICY.
BE IT ENACTED BY THE COUNCIL OF THE CITY OF JEFFERSON, MISSOURI, AS
FOLLOWS:
Section 1. Chapter 25 (Planning and Development) is amended by the addition of
an Article XI as follows:
Article XI. Economic Incentive Policy
Sec. 25-200. Purpose Statement
The City of Jefferson is dedicated to achieving the highest quality of development, services, infrastructure, and
quality of life for its citizens. One of the primary keys for achieving these goals is to enhance and expand the local
economy. Competition for attracting new businesses and employers, as well as retaining the ones already in existence in
the community, can be aggressive from time to time at national, regional, interstate, and intrastate levels. For this reason,
the City recognizes that the appropriate use of economic development incentives may be necessary in the correct
circumstances to aid the City in reaching its full economic potential.
The purpose of th ese policies are two-fold: First, to establish the goals, standards, guidelines, and preferences of
the City to direct the use of economic incentives to ensure that these incentives are used in a way that advances the City’s
economic goals. These policies allow the City to be proactive (not reactive) with respect to requests from developers and
businesses to create the public-private partnerships, which are the real result of granting incentives in any instance. These
policies serve as a guide to developers and businesses far and wide to attract those having concepts, ideas, and plans that
closely match the development needs of the City. Conversely, these policies also inform the development and business
community that incentives for businesses already supported in the City, or for which there is no longer a community need,
may be more difficult to obtain.
Second, the procedures component establishes a uniform, transparent, and well -informed path for businesses and
developers to follow when seeking economic development incentives of the City. We believe that through a standard
approach the expectations of applicants can be managed at reasonable levels, which leads to a more positive experience for
those seeking incentives. The uniform application of these procedures ensures that the goals and needs of the City are
being specifically considered for each economic development incentives request, which leads to greater long -term success
of the program as a whole. Finally, these procedures address the ongoing execution of each approved incentive application
thereby confirming that the applicant will be held accountable for delivering the promised investment in the community,
which in turn builds confidence in the City’s incentives program by its citizens and the other affected taxing jurisdiction s
that are the City’s neighbors.
Nevertheless, the applicability of the differing incentives programs often varies from project to project, and the
City Council’s decision to grant incentives is discretionary, based upon one or more of the criteria set forth in this
document and other outside factors. The City Council is under no obligation to approve any requested incentives that are
not required by state or local laws, and it reserves the right to deviate from these policies and procedures at its sole
discretion when doing so is deemed to be in the best interests of the City.
Sec. 25-201. General Policy And Procedure Guidelines
To implement the City’s economic development incentive program, certain overarching concepts apply. These
concepts, which are listed in detail below, fall into the categories of both the policy and procedural components of the
City’s overall program. Applicants with the highest likelihood of success will address each of these general policy issues
and procedural steps in addition to the policy issues and procedural steps that apply to the specific economic incentive tool
or tools applied for and described in more detail in this document.
A. General Policy Matters
1. When funds exist, either from the City’s budget or supplementary grants or other funding sources, or a
combination thereof, the City should obtain, maintain, and update a market study designed to identify the
economic development needs of the City for utilization in the review of economic development requests.
2. Applicants must demonstrate that the private investment (through equity, private financing, or a combination
thereof) is greater than the incentives requested. The preferred ratio of investment to incentive is that the
incentives request should be 25% 50% or less of the total proposed project costs).
3. The purpose of any requested incentive is to provide additional funding for a specific City-designated
economic development goal; or, if not, the applicant has provided justification and supporting documents
(e.g., third-party market studies, etc.) explaining why the purpose of the request should be a City-designated
economic development goal.
4. To ensure that the City’s interests are adequately protected and that the citizens and current business partners
of the City of Jefferson are not bearing the burden of the costs to review requests for public aid through
economic development incentives, applicants will be required to enter into a funding agreement whereby the
applicant provides funds to the City to obtain professional consultants necessary to aid in determining the
appropriate levels of assistance for the proposal, project feasibility, developer’s financial capacity, and a
legal review of the application, the approval process, and the negotiation and implementation of applicable
agreements. The City’s expenses may include, but is not limited to, fees for special legal and financial
consultation, market study reviews, appraisal reviews, and if applicable, bond underwriters and bond
counsel. These costs may be reimbursed through the incentive program as allowed by law.
5. When the level and type of economic development incentives reaches or exceeds an appropriate amount, the
City will conduct, and the applicant should expect to provide, a review of its relevant business experience,
financial condition , ability to carry out the proposed project, and criminal background. Applicants are
notified that the level of scrutiny into the applicant’s background will vary ratably with the amount of public
incentives and public risk associated with the level of incentives requested in the application.
6. Projects utilizing funds created from the development to reimburse development costs (“pay-as-you-go”) are
highly encouraged. The use of public debt should be limited to only that amount absolutely necessary, which
fact will be the applicant’s responsibility to justify in the approval process.
7. Incentive requests for projects that involve property acquisition by eminent domain are highly discouraged.
B. General Procedural Requirements.
1. Applicants for any economic development incentive program granted by the City must schedule and attend a
pre-application meeting with City staff prior to submitting an application.
2. The City will provide basic forms, a summary of the application, review, and consideration process,
applicable statutory requirements, and an estimated timeline for the approval process, in addition to other
relevant information, at the pre-application meeting.
3. Applicants will be expected to work with City staff and, when applicable, City consultants, while preparing
the applicable “official” document to be placed on file with the City, thus triggering the applicable statutory
review process.
4. Applicants will be required to enter into a funding agreement whereby the applicant provides funds to the
City to obtain professional consultants necessary to aid in determining the appropriate levels of ass istance for
the proposal, project feasibility, developer’s financial capacity, and a legal review of the application, the
approval process, and the negotiation and implementation of applicable agreements. An initial deposit will
be required before the City’s staff and consultants will begin work processing the applicant’s proposal. The
amount of the funding agreement deposit will vary depending upon the application or applications filed, and
applicants are hereby notified that the funding agreement will contain an “evergreen” clause whereby the
applicant must replenish the fund as it is used to ensure the full amount of the deposit is available to the City
for use in reviewing the application. Applicants are placed on notice that the costs associated with a funding
agreement are not refundable in the event that the application is not approved. Payment of the associated
costs does not guarantee approval of the application by the TIF Commission or City Council, whose
decisions shall remain at their sole discretion.
5. Applicants shall consider reimbursement of the City’s costs to review and consider the approval of the
application, and in the event the application is approved, to administer the incentive program while it remains
active, as a component of the overall project costs. Applicants also shall provide a mechanism for the
prompt payment of the City’s costs in its application. The City’s costs associated with the consideration of
the approval of an application shall be paid in full at the time of any a pplicable hearing or meeting to
consider a recommendation of approval or the approval of the application. The City reserves the right to
postpone such hearing or meeting until the necessary payments have been made.
Secs 25-203 through 25-109 Reserved.
Sec 25-210. Tax Increment Financing (TIF) Incentives.
Sections 25-210 through 25–219 shall be known as “The Policy And Procedure Guidelines For Tax Increment
Financing (TIF) Incentives.
Sec 25-211. TIF Overview.
Tax Increment Financing (TIF) is a public funding mechanism to assist private development of an area within the
City. TIF may only be used: 1) when there is evidence the development would not occur without public assistance; and 2)
when the project area qualifies as a blighted or conservation area in accordance with state statutes. TIF is a financial tool
used to capture the increase in property taxes and sales taxes created as a result of the redevelopment of an approved area
within the City. TIF by itself does not cause an increase in property or sales tax rates. 100% of the incremental increase in
property tax revenues (known as payments in lieu of taxes or “PILOTs”) and 50% of the incremental increase in local sales
and use tax revenues (known as economic activity taxes or “EATs”) generated in an approved TIF redevelopment area as a
result of the completion of a development project will be captured and directed to a TIF special allocation fund. The
PILOTs and EATs may then be used to reimburse a private developer for eligible expenses or to repay principal and
interest on bonds used to finance the eligible expenses for a maximum of 23 years from the date a TIF redevelopment
project was activated.
Sec 25-212. TIF Statutory Requirements.
By law, the City must determine that certain requirements have been met before approving a Tax Increment
Financing Plan filed by the applicant. These requirements are set forth under Sections 99.805 to 99.865 of the Revised
Statutes of the State of Missour i (RSMo) (the “TIF Act”).
Sec 25-213. TIF Policy Guidelines.
A. In addition to meeting the statutory requirements referenced above, the City has established several criteria that
will be applied in the review and evaluation of applications for TIF financing. In general, applications that meet
each of the evaluation criteria will be viewed most favorably. However, TIF applications that do not meet all of
the criteria listed herein may be approved if the application demonstrates that the TIF Plan and project or projects
on the whole is of vital economic interest to the City.
B. The City’s evaluation criteria for TIF applications are as follows:
1. The proposal must demonstrate a substantial and significant public benefit by eliminating blight, financing
desirable public improvements, strengthening the City’s economic and employment base through the
creation of new jobs or retention of existing employment, positively impacts surrounding areas, creates
economic stability, facilitates economic self-sufficiency, aids in the implementation of the City’s
comprehensive development plan and economic development strategies, and serves as a catalyst for further
high quality development or redevelopment in the City.
2. Proposals for the redevelopment and/or infill of deteriorating areas within the City will be given more
favorable consideration than projects for the redevelopment of “green field” areas.
3. The applicant must provide evidence that the applicant has thoroughly explored alternative financing
methods and has a track record which demonstrates the financial and technical ability to complete the
project.
4. TIF assistance to the project should generally not exceed 25% 50% of total project costs. However, project
assistance above 25% 50% may be considered in circumstances where the developer:
a. has a proven track record in completing successful projects comparable in scope and scale; and
b. documents the developer’s financial capacity to complete the proposed project; and
c. demonstrates that tenant commitments are already in place for a significant portion of the proposed
project; and
d. demonstrates the need for additional assistance in order to achieve a reasonable rate of return of the
proposed project.
5. Proposals requesting TIF assistance should have a ratio of three to one (3:1) in comparing potential increased
revenue to the City from all sources to the value of the incentives provided, measured over the term of the
TIF project.
6. Generally, TIF applications which encompass a project area of less than 10 3 acres will be discouraged.
7. In evaluating the employment potential of a proposed redevelopment, the following shall be taken into
consideration:
a. number of additional employees that will be hired as a result of the project and whether they are likely
to be hired from the local population; and
b. skill and education levels required for the jobs expected to be created by the project; and
c. range of salary and compensation for jobs expected to be created by the project; and
d. potential for executive relocation. TIF projects that create jobs with wages that exceed the community
average will be viewed favorably.
8. TIF applications for new or expanded office, commercial, or industrial and manufacturing projects will be
viewed more favorably than new or expanded retail projects. TIF applications for retail and service
commercial projects should be limited to those projects that encourage an inflow of new customers from
outside the City or that will provide services or fill retail markets that are currently unavailable or in shor t
supply in the City as documented in a professionally prepared market study. New or expanded industrial and
manufacturing projects will be given more favorable consideration than new or expanded warehouse type
uses based upon the projected employment per square foot.
9. TIF applications for the development of commercial, office and industrial projects that would stabilize
existing commercial, office and industrial areas that have or will likely experience deterioration will be
favored.
10. TIF applications that include the development of business areas, or the redevelopment of existing business
areas, shall include information as to the business type of the major tenants of the TIF area. In addition, a
thorough market analysis should be completed that identifies: (1) the population areas from which the project
will draw; and (2) the businesses of similar types that would be competing with the TIF area businesses.
11. TIF applications for new residential development projects (other than a limited number of residential units
which are creatively integrated into commercial or retail projects) will be strongly disfavored. TIF
applications for the redevelopment of existing residential areas will generally be disfavored. [NOTE: Need
to consider this based on the City’s needs. Residential TIFs are usually disfavored because
they cause a drain on resources without an offsetting increase in revenues. They are
particularly burdensome on school districts, who have two representatives on the TIF
Commission]
12. Government-issued financing related to TIF applications.
a. If an applicant’s financing plan includes a request for the City or another governmental entity at the
City’s request (e.g., an industrial development authority or the Missouri Economic Development
Financing Board (“MDFB”)) to issue notes and/or bonds to finance the project, the applicant shall enter
into an agreement with the City regarding the terms of such financing prior to the consideration of the
approval of the application, which financing terms shall be incorporated into a redevelopment
agreement for the implantation of the redevelopment plan upon the approval of the application, as
applicable.
b. TIF applications requesting the issuance of bonds or notes shall be required to demonstrate using a
third-party revenue consultant selected by the City that the payments-in-lieu of taxes and/or economic
activity taxes expected to be generated will be sufficient to provide debt service coverage of at least
1.30 times the projected debt service on any tax increment financing bonds or notes, that is to say that
the development must show that there will be $1.30 of revenue produced for every $1.00 of debt
service to repay debt issued. This limitation may be modified for projects that involve the
redevelopment of existing structures or the assembly and clearance of land upon which existing
structures are located. The debt service coverage ratio provided in this subsection is for guidance only,
the actual ratio will be determined through negotiations of the parties in the context of an actual request
for incentives through an application.
c. Applications requesting the City to issue annual-appropriation backed bonds are highly discouraged. In
the event that the applicant justifies why annual-appropriation backed bonds are necessary for the
project, the applicant shall be required to demonstrate using a third-party revenue consultant selected
by the City that the payments-in-lieu of taxes and/or economic activity taxes expected to be generated
will be sufficient to provide debt service coverage of at least 1.70 times the projected debt service on
any tax increment financing bonds or notes., that is to say that the development must show that there
will be $1.70 of revenue produced for every $1.00 of debt service to repay debt issued The debt service
coverage ratio provided in this subsection is for guidance only, the actual ratio will be determined
through negotiations of the parties in the context of an actual request for incentives through an
application.
13. If the TIF application is being recommended based upon specifically delineated benefits that are projected to
flow to the City as a result of the development, such as increased employment opportunities, increased ad
valorem or economic activity taxes, or construction of public infrastructure, language will be included in the
development agreement that stipulates that the City's assistance to the developer may be reduced if
satisfactory evidence is not shown that the degree, nature and/or quality of the benefits have b een generated
to the City by the project in accordance with the timeline provided in the application.
14. Applications that include the utilization of a Community Improvement District (CID), Transportation
Development District (TDD), Neighborhood Improvement District (NID), or other private or public
financing mechanisms that result in reducing the term of the TIF project and/or reduce the burden on affected
taxing jurisdictions will be viewed more favorably.
15. Notwithstanding the foregoing, TIF applications th at, based upon the above guidelines, would not otherwise
be favorably considered or do not meet any of the above referenced criteria, shall be viewed favorably by the
City if the application clearly demonstrates that the project as a whole or a portion of it is of vital interest to
the City and will significantly assist the City by eliminating blight, financing desirable public improvements,
strengthening the City’s economic and employment base through the creation of new jobs or retention of
existing employment, positively impacting surrounding areas, creating economic stability, facilitates
economic self-sufficiency, aiding in the implementation of the City’s comprehensive development plan and
economic development strategies, and serving as a catalyst for further high quality development or
redevelopment in the City.
Sec 25-213. TIF Expenses Eligible for Reimbursement.
A. A TIF proposal shall include what expenses are to be eligible for reimbursement.
B. Subject to the requirements of the TIF Act, expenses eligible for reimbursement under a TIF proposal may include,
but are not limited to, the following:
1. Studies, surveys, plans and specifications, Fees incurred by either the City or the applicant, or both, for
professional services such as architectural, engineering, legal, marketing, financial, and planning;
2. Site preparation, including demolition of structures, clearing and grading of land.
3. Constructing public infrastructure such as streets, sewers, utilities, parking, and lighting.
4. Financing costs including bond issuance.
5. Relocation costs if persons or businesses within the redevelopment area are displaced.
Sec 25-213. TIF City Application/Approval Process.
A. The applicant is required to first meet with staff in a pre-qualification conference to determine project eligibility.
An application may then be submitted to the Department of Public Works for review and processing. A copy of
the formal application may be obtained through the Department of Public Works.
B. Provided that the application exhibits initial feasibility in the opinion of City staff as determined by the
information exchanged in the pre-qualification conference, the applicant will be required to enter into a funding
agreement with the City to cover the City’s expenses associated with the TIF consideration and approval process ,
as provided in the City’s General Policy and Procedural Guidelines. The City’s expenses may include, but is not
limited to, fees for special legal and financial consultation, market study reviews, appraisal reviews, and if
applicable, bond underwriters and bond counsel. Applicants are placed on notice that the costs associated with a
funding agreement are not refundable in the event that the application is not approved. Payment of the associated
costs does not guarantee approval of the application by the TIF Commission or City Council, whose decisions
shall remain at their sole discretion.
C. Care will be exercised in the use of TIF incentives to thoroughly evaluate each project to ensure that the benefits
that will accrue from the approval of the project are appropriate, in relation to the TIF incentive provided to and
the costs that will result from the project, and that the project, when viewed from this prospective, benefits the City
as a whole.
D. Each project, and the location at which it is proposed, is unique and, therefore, every proposal shall be evaluated
on its individual merit, including its potential economic benefit, potential impact on the City's service levels, its
overall contribution to the City's economy and its consistency with the City's goals and objective as expressed in
the Comprehensive Plan and other adopted or City endorsed planning or strategic documents. The applicant is
expected to work with the City’s staff and consultants to prepare the TIF Plan prior to the applicant’s formal
submittal of the final TIF Plan for TIF Commission and City Council review and approval.
E. Following a public hearing before the City’s TIF Commission and approval of the TIF Plan by the City Council,
the City and the applicant shall enter into a redevelopment agreement for the purpose of governing the
implementation of the TIF Plan.
Secs 25-214 through 25-299 Reserved.
Sec 25-220. Community Improvement District (Cid) Incentives
Sections 25-220 through 25 – 221 shall be known as “The General Policy And Procedure Guidelines For The Use
Of Community Improvement District (Cid) Incentives.”
Sec 25-221. CID Overview
A Community Improvement District (CID) is a special purpose district in which property owners voluntarily
impose a funding mechanism upon themselves to fund a broad range of public improvements and/or services to support
business activity and economic development within specified boundaries. Created by an ordinance of the City Council,
establishment of the CID is considered after the receipt of a petition, signed by owners of real property, representing more
than 50 percent of the assessed valuation within the proposed CID boundary and over 50 percent per capita of all owners of
real property.
A CID may be established either as a separate political subdivision that is distinct from the municipality or as a
not-for -profit corporation. If the CID is organi zed as a political subdivision, the District can impose a sales tax in 1/8%
increments up to 1% on most retail sales and/or a real property tax. If the CID is organized as a non -profit corporation, it
may only impose special assessments to finance the cost of improvements and services. The District, if desired, may issue
tax-exempt revenue bonds to finance capital improvement projects for up to 20 years.
Responsibility for repayment of CID bonds lies solely with the District. As such, the City does not pledge its full
faith and credit behind the repayment of the bonds. In terms of governance, a board of directors made up of the
representatives of business owner, property owners, and voters either elected or appointed by the City of Jefferson City
Council oversees District activities.
If the District is funded solely through special assessments, a not -for -profit agency can serve as the administrator.
Although the CID is established with the approval of the City Council, once formed the District operates independently in
accordance with the provisions set forth in the petition and Missouri State Law.
Sec 25-222. CID Statutory Requirements
By law, the City must determine that certain requirements have been met before approving the establishment of a
Community Improvement District. These requirements are set forth under Sections 67.1401 - 67.1571 of the Revised
Statutes of the State of Missouri (RSMo) (the “CID Act”).
Sec 25-223. CID Policy Guidelines
A. In addition to meeting the statutory requirements referenced above, the City has established several criteria that
will be applied in the review and evaluation of applications for the establishment of a CID. In general,
applications that meet each of the evaluation criteria will be viewed most favorably. However, CID applications
that do not meet all of the criteria listed herein may be approved if the application demonstrates that the CID
proposal on the whole provides a substantial and significant public benefit to meet identified economic
development needs in the City.
B. The City’s evaluation criteria for CID applications are as follows:
1. CIDs which are established for the purpose of: (1) reducing the time a TIF project is active and/or offsetting
the burden of TIF incentives on the affected taxing jurisdictions; or (2) providing all or a portion of the
funding needed to construct public improvements that have been identified as a long -term goal of the City’s
capital improvements plan are highly favored.
2. The applicant should work with City staff and consultants to ensure that a proposed sales tax would not cause
the cumulative sales tax rate within the proposed CID boundaries to exceed ten percent (10%).
3. Perpetual CIDs having a sales tax as a funding mechanism are disfavored.
C. CIDs formed primarily for the purpose of funding common area maintenance costs are discouraged.
D. The CID petition shall require that at least two (2) members of the Board of Directors shall be an elected or
appointed official or employee of the City.
E. The CID petition shall provide that the City Council must review and approve the CID’s annual budget before it is
presented for approval by the CID’s Board of Directors.
F. CID petitions which provide that the CID Board of Directors will be appointed by the Mayor with the consent of
the City Council are favored.
G. A CID formed to provide sustainable funding for an organization having the purpose of promoting the City’s
historic downtown shopping district would be strongly encouraged.
H. Petitions which propose the issuance of CID bonds are discouraged.
I. The use of a CID as a substitute for traditional homeowners associations i s encouraged; provided that the proposed
CID is established as a not-for -profit corporation.
Sec 25-224. CID City Application/Approval Process
A. CID applicants are required to first meet with staff pre-qualification conferences to determine project eligibility.
An application may then be submitted to the Department of Public Works for review and processing. A copy of
the formal application may be obtained through the Department of Public Works. Applicants may be required to
enter into a funding agreement with the City pursuant to the General Policy and Procedure Guidelines provided as
a component of the City of Jefferson’s Economic Development Policies and Procedures.
B. Prior to the applicant’s formal submittal of the final CID Petition with the City Clerk for City Council review and
approval, the applicant is expected to work with the City’s staff and consultants to prepare the CID petition to
ensure that it substantially complies with statutory requirements. Once the review process has been completed, the
petitioner(s) may file the petition pursuant to the CID Act in the office of the City Clerk. Upon receipt of the
petition, the City Clerk, upon the advice of the City Counselor, or his or her designee, shall make a final
determination of whether the petition substantially complies with statutory requirements. Following confirmation
that the petition complies with these requirements, a public hearing will be held by the City Council. The City
Council would then consider whether to approve an ordinance to establish the CID.
C. Following the establishment of the CID, the City and the CID board shall enter into a cooperative agreement for
the purpose of establishing the terms of the relationship between the City and the CID board. Once established,
the CID applicant will either seek to impose a sales tax and/or a property tax within the district, or to levy a special
assessment within the district in accordance with the procedures and provisions set forth in the CID Act.
Secs 25-225 through 25-229 Reserved.
Sec 25-230. Transportation Development District (TDD) Incentives
Sections 25-230 through 25 – 239 shall be known as “The General Policy And Procedure Guidelines For The Use
Of Transportation Development District (TDD) Incentives”.
Sec 25-231. TDD Overview
Transportation Development Districts (TDD) are independent political subdivisions organized to levy sales taxes,
property taxes, or special assessments to pay for the construction of roads, bridges, interchanges, intersections, parking
facilities or other transportation related improvements. Unlike CIDs, TDDs are approved and organized by order of the
circuit court. A TDD petition is a law suit filed by the petitioner s against the Missouri Highways and Transportation
Commission and the affected local transportation authority, which may include the City (provided that the City is not the
petitioner). Property owners may petition for the creation of a district as large as several counties or as small as a single
parcel of property. The TDD Act also allows for the governing body of local transportation (in the City’s case, the City
Council) to file a petition to form a TDD. As long as the TDD is proposed to construct transportation related
improvements, any property is eligible to be included in a TDD.
TDDs may generate revenues through sales taxes (up to 1%), ad valorem taxes on real and personal property (up
to ten cents per $100 assessed valuation), special assessments, or tolls. The TDD is authorized to issue bonds on its own
behalf, utilizing these captured taxes and assessments to pay debt service on bonds issued to construct transportation
projects. Either the Missouri Department of Transportation (MoDOT) or the City are required to sponsor projects and must
agree to accept maintenance responsibilities for completed projects. When the project costs are paid off (or if applicable,
the bonds financing the project costs are paid off), the TDD is terminated.
Sec 25-232. TDD Statutory Requirements
While City approval of a TDD is not specifically required by law, it is in an applicant’s best interest to coordinate
the filing of a petition for the formation of a TDD for which the City is a local transportation authority with the City before
doing so. The City will aid the applicant in determining whether the requirements for a valid TDD have been met before
asking the City Council to adopt a resolution in support of the formation of the proposed TDD. These requirements are set
forth under Sections 238.200 – 238.275 of the Revised Statutes of the State of Missouri (RSMo) (the “TDD Act”).
Sec 25-233. TDD Policy Guidelines
A. The City may pass a resolution endorsing (or opposing) projects prior to the time of the circuit court review of
petitions filed to establish a proposed TDD. Additionally, for proposed TDDs which include the City as a local
transportation authority, the City has a statutory right to file a petition in support of or opposing the formation of
the TDD. The City will support the formation of a TDD only in circumstances where projects create substantial
public benefits by advancing the City’s goals.
B. In addition to meeting the statutory requirements referenced above, the City has established several criteria that
will be applied in the review and evaluation of applications for the formation of a TDD within the City’s
jurisdictional boundaries. In general, applications that meet each of the evaluation cri teria will be viewed most
favorably. However, TDD proposals that do not meet all of the criteria listed herein may be approved if the
application demonstrates that the TDD proposal on the whole provides a substantial and significant public benefit
to meet identified economic development needs in the City. The City’s evaluation criteria for TDD applications
are as follows:
1. TDDs which are established for the purpose of: (1) reducing the time a TIF project is active and/or offsetting
the burden of TIF incentives on the affected taxing jurisdictions; or (2) providing all or a portion of the
funding needed to construct public improvements that have been identified as a long -term goal of the City’s
capital improvements plan are highly favored.
2. The applicant should work with City staff and consultants to ensure that a proposed sales tax would not cause
the cumulative sales tax rate within the proposed TDD boundaries to exceed ten percent (10%).
3. TDD petitions requiring that at least two (2) members of the TDD Board of Directors shall be an elected or
appointed official or employee of the City are highly favored.
4. TDD petitions that require the City Council to review and approve the TDD’s annual budget before it is
presented for approval by the TDD’s Board of Directors are highly favored.
5. Petitions which propose the issuance of TDD bonds are discouraged.
Sec 25-234. TDD City Application/Approval Process
A. TDD applicants are required to first meet with staff pre-qualification conferences to determine project eligibility.
An application may then be submitted to the Department of Public Works for review and processing. A copy of
the formal application may be obtained through the Department of Public Works. Applicants may be required to
enter into a funding agreement with the City pursuant to the General Policy and Procedure Guidelines provided as
a component of the City of Jefferson’s Economic Development Policies and Procedures.
B. Prior to the applicant’s formal submittal of the final TDD Petition with the Cir cuit Court Clerk, the applicant is
expected to work with the City’s staff and consultants to prepare the TDD petition to ensure that it complies with
statutory requirements and City policy. Among the issues to be resolved in this process is whether the City will be
the petitioner as the local transportation authority, or whether the property owners will file the petition. Once the
review process has been completed, City staff will forward the matter to the City Council, which will consider a
resolution of support in favor of the formation of the TDD.
C. After the City Council’s determination, the petitioner(s) may file the petition with the Circuit Court Clerk pursuant
to the TDD Act. If the City Council has approved a resolution of support in favor of the formation of the TDD, the
City will cooperate with the petitioners in the prosecution of the case, as is required by whether the City is the
petitioner or a respondent. If the City Council has not approved a resolution of support in favor of the formation
of the TDD, the City reserves its right to file an answer in opposition to the petition.
D. Once the TDD is formed by the circuit court, the City and the TDD board should enter into a cooperative
agreement for the purpose of establishing the terms of the relationship between the City and the TDD Board of
Directors.
Secs 25-235 through 25-139 Reserved.
Sec 25-240. Neighborhood Improvement District (NID) Incentives
Sections 25-240 through 25– 249 shall be known as the “The General Policy And Procedure Guidelines
For The Use Of Neighborhood Improvement District (Nid) Incentives”
Sec 25-241. NID Overview
Neighborhood Improvement District (NID) is not an entity separate from the City, but rather the designation of a
special district in which special assessments are imposed to finance public improvements, including acquisition,
construction, engineering, legal and related costs. Temporary notes are issued by the municipality to pay the costs of the
improvements and related costs. Once the construction of the improvements is completed, the temporary notes are paid by
the NID bonds, which are in turn retired through special assessments against proper ty owners in the area in which the
improvements are made. NID bonds cannot exceed 125% of the estimated cost of the improvements established in the NID
petition. The cost of the public improvements assessed against property owners in the district are app ortioned in a manner
commensurate to the amount of benefit received from such improvements. NID bonds are counted against the City’s
constitutional debt limits.
The creation of a NID may be established by one of two methods. The first is by a favorable vote of qualified
voters living within the boundaries of the proposed district. The second is through a proper petition signed by at least two-
thirds of the owners of record of all real property within the proposed district. In both instances, approval by the City’s
City Council is required in order to establish the NID.
Sec 25-242. NID Statutory Requirements
By law, the City must determine that certain requirements have been met before approving the establishment of a
Neighborhood Improvement District (NID). These requirements are set forth under Sections 67.453 to 67.475 of the
Revised Statutes for the State of Missouri (RSMo) (the “NID Act”).
Sec 25-243. NID Policy Guidelines
The City of Jefferson is prepared to approve petitions for Neighborhood Improvement Districts (NID) to facilitate
business activity, economic development, and expedited neighborhood improvement through the participation of property
owners to fund public infrastructure within Jefferson City. Because the City issues special obligation bonds that count
against its constitutional debt limits, decisions to approve the establishment of a NID will be determined on a case-by-case
basis and approved only where there is a clear demonstration of substantial and significant public benefit. Improvements
funded by a NID must be purely public in nature, meaning that the improvement will be owned, operated, and maintained
by the City after completion and must remain open for public use. At a minimum, all statutory requirements must be met.
Sec 25-244. NID City Application/Approval Process
A. NID applicants are required to first meet with staff pre-qualification conferences to determine project eligibility.
An application may then be submitted to the Department of Public Works for review and processing. A copy of
the formal application may be obtained through the Department of Public Works. Applicants may be required to
enter into a fun ding agreement with the City pursuant to the General Policy and Procedure Guidelines provided as
a component of the City of Jefferson’s Economic Development Policies and Procedures.
B. Prior to the applicant’s formal submittal of the final NID Petition with the City Clerk for City Council review and
approval, the applicant is expected to work with the City’s staff and consultants to prepare the NID petition to
ensure that it substantially complies with statutory requirements. Once the review process has been completed, the
petitioner(s) may file the petition pursuant to the NID Act in the office of the City Clerk. Upon receipt of the
petition, the City Clerk, upon the advice of the City Counselor, or his or her designee, shall make a final
determination of whether the petition substantially complies with statutory requirements. Petitions that comply
with the statutory requirements will be forwarded to the City Council for consideration, subject to the procedural
requirements established in the NID Act. Under certain conditions a cooperative agreement may be required to
establish the terms of the relationship between the City and the applicants filing the NID petition.
Secs 25-245 through 25-250 Reserved.
Section 2. This Ordinance shall be in full force and effect from and after the date of
its passage and approval.
Passed: Approved:
Presiding Officer Mayor
ATTEST: APPROVED AS TO FORM:
City Clerk City Counselor