HomeMy Public PortalAbout20130528 finance packetNotice of Meeting and Tentative Agenda
CITY OF JEFFERSON
Finance Committee
Tuesday, May 28, 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 minutes of the April 24, 2013 meeting
4. Sales Tax Report – Bill Betts
5. Monthly Budget Report – Bill Betts
6. Fund Balance Report – Bill Betts
7. New Grant Procedures and Accompanying Bill – Bill Betts
8. Discussion of Budget Calendar – Bill Betts
9. Lodging Tax Report – Shiela Pearre
10. Economic Development Policy – Drew Hilpert
11. New Business
12. Old Business
13. 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.
CITY OF JEFFERSON
Finance Committee Meeting
Wednesday, April 24, 2013
MINUTES
The meeting was called to order by the Finance Committee Chairman, Councilman Shawn Schulte at 7:29 AM.
Roll call showed that Councilmen Schulte, Graham, Prather and Scrivner were in attendance. Councilman Bray
was not present at roll call but joined the meeting at 8:00 AM.
The minutes of the March 26, 2013 meeting were reviewed and a motion to approve was made by Councilman
Bray and seconded by Councilman Prather. The minutes were approved unanimously.
The next item was a discussion about the potential need for an Economic Development Policy led by City
Counselor, Drew Hilpert and taken out of order on the agenda. Mr. Hilpert gave some background on the types
of Economic Development that could arise within the City of Jefferson and asked the Committee how they
would like to proceed in an effort to create a General Econcomic Development Policy. The Committee decided
to pass initial questions through the Finance Committee and then proceed with a Council work session.
The next item on the agenda was a report by Interim Finance Director, Bill Betts, covering the sales tax revenue
for April.
The next item on the agenda was a report by Mr. Betts covering the monthly Budget Report. Mr. Betts
explained the format of the report and the information the report contains.
The next item on the agenda was a short report by the Chief Accountant, Shiela Pearre, covering the Lodging
Tax receipts to date. Lodging tax collected in March was $84,199. The total collected during the timeframe
where the rate has been 7% is $1,873,141.
The next item on the agenda was a resolution presented by Ms. Pearre to terminate the Water Enterpise Fund
and transfer all assets to the General Fund. A motion was made by Councilman Scrivner and seconded by
Councilman Bray to move the resolution to full Council. The motion passed unanimously.
The next item on the agenda was a resolution presented by Ms. Pearre to terminate the Capital Projects – Streets
& Public Facilities Fund and transfer all assets into Sales Tax F “Contingency” category. A motion was made
by Councilman Scrivner and seconded by Councilman Graham to move the resolution to full Council. The
motion passed unanimously.
The next item on the agenda was a resolution presented by Ms. Pearre to terminate the Sales Tax B and Sales
Tax C Funds and transfer all assets to Sales Tax F, with $283,495.10 going to the “Riverfront Projects”
category and the remainder going to the “Contingency” category. Councilman Scriver requested that the
resolution be amended to state that all other projects in Sales Tax B and Sales Tax C were completed as
promised and that the funds going to the “Contingency” category were a result of interest earned. A motion was
made by Councilman Scrivner and seconded by Councilman Prather to move the resolution to full Council as
amended. The motion passed unanimously.
The next item on the agenda was New Business. Councilman Schulte announced that the Finance Committee
typically meets the 4th Tuesday of each month, as this was the first Committee meeting for several members.
There was no old business discussed.
Adjournment took place at 9:10 AM.
As recorded by:
Shiela Pearre, Chief Accountant
Memo
To:Nathan Nickolaus
From:Shiela Pearre
Date:May 7, 2013
Re:Sales Tax Revenues
The City received the May 1% Sales Tax in the amount of $537,141 which is $30,074 less
than projected for May. November through May shortage is $89,510 (0.92%) in the
General Fund.
1% General Sales Tax
ReceiptBudget Actual
PeriodProjectionReceipts Variance
Sep-12Nov-12$615,421$615,421$0
Oct-12& Jul-Sept 12 QtrlyDec-12$982,684$982,684$0
Nov-12Jan-13$764,659$764,659$0
Dec-12Feb-13$703,181$703,181$0
Jan-13& Oct-Dec 12 QtrlyMar-13$992,559$1,008,111$15,552
Feb-13Apr-13$852,412$777,424($74,988)
Mar-13May-13$567,215$537,141($30,074)
Jun-13$1,028,514$0
Jul-13$797,780$0
Aug-13$557,032$0
Sep-13$1,069,414$0
Oct-13$769,129$0
Total Overage/Shortfall ($89,510)
1/2% Capital Improvement Tax
Receipt Budget Actual
PeriodProjectionReceipts Variance
Sep-12Nov-12$268,825$306,968$38,144
Oct-12& Jul-Sept 12 QtrlyDec-12$499,983$469,095($30,888)
Nov-12Jan-13$416,244$372,459($43,785)
Dec-12Feb-13$311,418$350,813$39,395
Jan-13& Oct-Dec 12 QtrlyMar-13$471,169$475,110$3,941
Feb-13Apr-13$413,147$372,340($40,806)
Mar-13May-13$266,340$266,422$82
Jun-13$499,328$0
Jul-13$393,021$0
Aug-13$280,801$0
Sep-13$508,966$0
Oct-13$370,760$0
Total Increase/Shortfall ($33,917)
1/2% Parks Sales Tax
ReceiptBudget Actual
PeriodProjectionReceipts Variance
Sep-12Nov-12$256,617 $306,831$50,214
Oct-12& Jul-Sept 12 QtrlyDec-12$457,184$468,924$11,740
Nov-12Jan-13$423,675$372,447($51,228)
Dec-12Feb-13$434,921$350,714($84,207)
Jan-13& Oct-Dec 12 QtrlyMar-13$299,737$475,026$175,289
Feb-13Apr-13$483,381$372,242($111,139)
Mar-13May-13$336,498$266,456($70,042)
Jun-13$468,999$0
Jul-13$500,092$0
Aug-13$301,981$0
Sep-13$514,787$0
Oct-13$189,747$0
Total Increase/Shortfall ($79,374)
Reporting
Period
Reporting
Period
Reporting
Period
Ci
t
y
o
f
J
e
f
f
e
r
s
o
n
,
M
o
.
-
A
c
c
o
u
n
t
A
n
a
l
y
s
i
s
Ac
c
o
u
n
t
N
a
m
e
Ge
n
e
r
a
l
F
u
n
d
S
a
l
e
s
T
a
x
Ra
t
e
:
O
n
e
p
e
r
c
e
n
t
(
1
%
)
R
e
c
e
i
p
t
M
o
n
t
h
:
A
P
R
I
L
2
0
1
3
Ac
c
o
u
n
t
N
u
m
b
e
r
10
-
1
0
0
-
4
0
0
0
1
0
Mo
n
t
h
l
y
Pr
o
j
e
c
t
e
d
f
u
t
u
r
e
F
i
s
c
a
l
Y
e
a
r
s
20
0
8
2
0
0
9
2
0
1
0
2
0
1
1
2
0
1
2
2
0
1
3
Av
e
r
a
g
e
20
1
4
2
0
1
5
2
0
1
6
2
0
1
7
2
0
1
8
No
v
e
m
b
e
r
4
5
3
,
5
7
1
4
8
6
,
2
5
8
5
5
4
,
8
2
4
4
8
2
,
8
0
7
5
3
6
,
1
8
5
6
1
5
,
4
2
1
a
c
t
.
5
0
2
,
7
2
9
5
1
3
,
8
3
5
5
1
4
,
6
5
8
5
1
5
,
4
8
2
5
1
6
,
3
0
7
5
1
7
,
1
3
4
De
c
e
m
b
e
r
1
,
0
2
2
,
4
3
0
9
2
6
,
7
6
0
8
0
1
,
7
8
0
8
8
1
,
7
8
0
1
,
0
3
2
,
0
4
6
9
8
2
,
6
8
4
a
c
t
.
9
3
2
,
9
5
9
9
5
3
,
5
6
9
9
5
5
,
0
9
6
9
5
6
,
6
2
5
9
5
8
,
1
5
7
9
5
9
,
6
9
1
Ja
n
u
a
r
y
8
6
0
,
9
2
1
7
8
7
,
6
7
6
9
2
8
,
4
6
0
8
0
9
,
3
8
5
8
4
3
,
0
6
1
7
6
4
,
6
5
9
a
c
t
.
8
4
5
,
9
0
1
8
6
4
,
5
8
8
8
6
5
,
9
7
2
8
6
7
,
3
5
9
8
6
8
,
7
4
7
8
7
0
,
1
3
8
Fe
b
r
u
a
r
y
6
4
1
,
7
8
6
5
7
7
,
7
5
8
6
3
1
,
1
3
7
8
3
3
,
9
1
9
6
1
9
,
2
8
7
7
0
3
,
1
8
1
a
c
t
.
6
6
0
,
7
7
7
6
7
5
,
3
7
5
6
7
6
,
4
5
6
6
7
7
,
5
3
9
6
7
8
,
6
2
4
6
7
9
,
7
1
1
Ma
r
c
h
1
,
0
7
6
,
3
9
5
1
,
0
7
9
,
2
4
6
8
9
4
,
1
5
8
5
8
9
,
9
5
8
9
9
2
,
5
5
9
1
,
0
0
8
,
1
1
1
a
c
t
.
9
2
6
,
4
6
3
9
4
6
,
9
3
0
9
4
8
,
4
4
6
9
4
9
,
9
6
5
9
5
1
,
4
8
6
9
5
3
,
0
0
9
Ap
r
i
l
8
3
6
,
5
1
3
7
6
3
,
9
0
6
7
7
4
,
9
6
4
9
7
8
,
3
9
1
8
5
2
,
4
1
2
7
7
7
,
4
2
4
a
c
t
.
8
4
1
,
2
3
7
8
5
9
,
8
2
1
8
6
1
,
1
9
8
8
6
2
,
5
7
7
8
6
3
,
9
5
8
8
6
5
,
3
4
1
Ma
y
4
4
5
,
9
0
3
5
1
6
,
0
1
6
5
9
2
,
6
5
7
6
3
3
,
6
7
4
5
3
0
,
0
4
1
5
3
7
,
1
4
1
a
c
t
.
5
4
3
,
6
5
8
5
5
5
,
6
6
8
5
5
6
,
5
5
8
5
5
7
,
4
4
9
5
5
8
,
3
4
2
5
5
9
,
2
3
6
Ju
n
e
1
,
1
0
3
,
1
7
0
9
3
4
,
6
6
0
8
4
3
,
7
1
2
9
2
5
,
5
5
5
1
,
0
2
8
,
5
1
4
1
,
0
2
8
,
5
1
4
e
s
t
.
9
6
7
,
1
2
2
9
8
8
,
4
8
7
9
9
0
,
0
7
0
9
9
1
,
6
5
5
9
9
3
,
2
4
3
9
9
4
,
8
3
3
Ju
l
y
8
2
1
,
9
0
6
6
8
6
,
1
5
3
9
3
9
,
4
9
5
9
5
5
,
4
9
5
7
9
7
,
7
8
0
7
9
7
,
7
8
0
e
s
t
.
8
4
0
,
1
6
6
8
5
8
,
7
2
6
8
6
0
,
1
0
1
8
6
1
,
4
7
8
8
6
2
,
8
5
8
8
6
4
,
2
3
9
Au
g
u
s
t
4
9
2
,
8
3
9
5
2
6
,
0
9
7
4
9
5
,
6
6
7
5
6
6
,
2
9
9
5
5
7
,
0
3
2
5
5
7
,
0
3
2
e
s
t
.
5
2
7
,
5
8
7
5
3
9
,
2
4
2
5
4
0
,
1
0
5
5
4
0
,
9
7
0
5
4
1
,
8
3
6
5
4
2
,
7
0
4
Se
p
t
e
m
b
e
r
1
,
1
0
2
,
8
2
6
1
,
0
0
6
,
1
2
0
1
,
0
4
0
,
1
5
6
1
,
0
3
2
,
2
5
8
1
,
0
6
9
,
4
1
4
1
,
0
6
9
,
4
1
4
e
s
t
.
1
,
0
5
0
,
1
5
5
1
,
0
7
3
,
3
5
4
1
,
0
7
5
,
0
7
3
1
,
0
7
6
,
7
9
4
1
,
0
7
8
,
5
1
8
1
,
0
8
0
,
2
4
5
Oc
t
o
b
e
r
7
8
8
,
0
8
5
7
1
8
,
4
8
0
8
2
2
,
1
6
4
7
9
7
,
5
1
0
7
6
9
,
1
2
9
7
6
9
,
1
2
9
e
s
t
.
7
7
9
,
0
7
4
7
9
6
,
2
8
4
7
9
7
,
5
5
9
7
9
8
,
8
3
6
8
0
0
,
1
1
5
8
0
1
,
3
9
7
Ac
t
u
a
l
t
o
D
a
t
e
$
9
,
6
4
6
,
3
4
6
$
9
,
0
0
9
,
1
3
0
$
9
,
3
1
9
,
1
7
5
$
9
,
4
8
7
,
0
3
1
$
9
,
6
2
7
,
4
6
0
5,
3
8
8
,
6
2
1
9
,
4
1
7
,
8
2
8
9
,
6
2
5
,
8
7
9
9
,
6
4
1
,
2
9
2
9
,
6
5
6
,
7
3
0
9
,
6
7
2
,
1
9
2
9
,
6
8
7
,
6
8
0
E
s
t
i
m
a
t
e
d
t
o
F
i
s
c
a
l
Y
e
a
r
e
n
d
(
b
a
s
e
d
o
n
a
v
e
r
a
g
e
s
a
n
d
o
n
B
u
d
g
e
t
e
d
a
m
o
u
n
t
)
4,
2
2
1
,
8
6
9
To
t
a
l
A
c
t
u
a
l
&
E
s
t
i
m
a
t
e
d
$
9
,
6
1
0
,
4
9
0
1
0
2
.
0
5
%
1
0
0
.
1
6
%
A
v
e
r
a
g
e
G
r
o
w
t
h
R
a
t
e
Le
s
s
:
B
u
d
g
e
t
9,
7
0
0
,
0
0
0
1
0
0
.
0
0
%
C
o
n
f
i
d
e
n
c
e
F
a
c
t
o
r
Ov
e
r
(
U
n
d
e
r
)
B
u
d
g
e
t
-$
8
9
,
5
1
0
10
0
.
1
6
%
P
r
o
j
e
c
t
e
d
G
r
o
w
t
h
Cu
m
u
l
a
t
i
v
e
P
e
r
c
e
n
t
a
g
e
s
b
y
M
o
n
t
h
No
v
e
m
b
e
r
5
%
5
%
6
%
5
%
6
%
6
%
De
c
e
m
b
e
r
1
5
%
1
6
%
1
5
%
1
4
%
1
6
%
1
6
%
Ja
n
u
a
r
y
2
4
%
2
4
%
2
5
%
2
3
%
2
5
%
2
4
%
Fe
b
r
u
a
r
y
3
1
%
3
1
%
3
1
%
3
2
%
3
1
%
3
2
%
Ma
r
c
h
4
2
%
4
3
%
4
1
%
3
8
%
4
2
%
4
2
%
Ap
r
i
l
5
1
%
5
1
%
4
9
%
4
8
%
5
1
%
5
0
%
Ma
y
5
5
%
5
7
%
5
6
%
5
5
%
5
6
%
5
6
%
Ju
n
e
6
7
%
6
7
%
6
5
%
6
5
%
6
7
%
6
6
%
Ju
l
y
7
5
%
7
5
%
7
5
%
7
5
%
7
5
%
7
4
%
Au
g
u
s
t
8
0
%
8
1
%
8
0
%
8
1
%
8
1
%
8
0
%
Se
p
t
e
m
b
e
r
9
2
%
9
2
%
9
1
%
9
2
%
9
2
%
9
1
%
Oc
t
o
b
e
r
1
0
0
%
1
0
0
%
1
0
0
%
1
0
0
%
1
0
0
%
9
9
%
To
t
a
l
A
m
o
u
n
t
L
a
s
t
1
2
M
o
n
t
h
s
9
,
6
0
3
,
3
9
0
Pr
e
v
i
o
u
s
1
2
M
o
n
t
h
s
A
c
t
u
a
l
9
,
7
8
6
,
3
4
1
%
G
r
o
w
t
h
-1
.
8
7
%
0
20
0
,
0
0
0
40
0
,
0
0
0
60
0
,
0
0
0
80
0
,
0
0
0
1,
0
0
0
,
0
0
0
1,
2
0
0
,
0
0
0
1,
4
0
0
,
0
0
0
Cu
r
r
e
n
t
A
c
t
u
a
l
5 Year Average Printed 5/9/2013
Ci
t
y
o
f
J
e
f
f
e
r
s
o
n
,
M
o
.
-
A
c
c
o
u
n
t
A
n
a
l
y
s
i
s
Ac
c
o
u
n
t
N
a
m
e
Ca
p
i
t
a
l
I
m
p
r
s
S
a
l
e
s
T
a
x
Ra
t
e
:
O
n
e
-
H
a
l
f
p
e
r
c
e
n
t
(
½
%
)
R
e
c
e
i
p
t
M
o
n
t
h
:
A
P
R
I
L
2
0
1
3
Ac
c
o
u
n
t
N
u
m
b
e
r
44
-
1
0
0
-
4
0
0
0
1
0
F
-
e
f
f
e
c
t
i
v
e
4
/
1
/
1
2
Mo
n
t
h
l
y
Pr
o
j
e
c
t
e
d
f
u
t
u
r
e
F
i
s
c
a
l
Y
e
a
r
s
20
0
8
2
0
0
9
2
0
1
0
2
0
1
1
2
0
1
2
2
0
1
3
Av
e
r
a
g
e
20
1
4
2
0
1
5
2
0
1
6
2
0
1
7
2
0
1
8
No
v
e
m
b
e
r
2
2
6
,
2
0
9
2
4
1
,
8
9
7
2
7
6
,
4
8
7
2
4
0
,
4
1
7
2
6
6
,
3
6
4
3
0
6
,
9
6
8
a
c
t
.
2
5
0
,
2
7
5
2
6
8
,
8
2
5
2
6
8
,
8
2
5
2
6
8
,
8
2
5
2
6
8
,
8
2
5
2
6
8
,
8
2
5
De
c
e
m
b
e
r
4
9
8
,
4
8
3
4
4
7
,
4
8
5
3
8
4
,
3
2
0
4
2
8
,
0
5
8
4
9
5
,
4
0
6
4
6
9
,
0
9
5
a
c
t
.
4
5
0
,
7
5
0
4
9
9
,
9
8
3
4
9
9
,
9
8
3
4
9
9
,
9
8
3
4
9
9
,
9
8
3
4
9
9
,
9
8
3
Ja
n
u
a
r
y
4
1
6
,
2
7
7
3
8
4
,
3
2
7
4
5
5
,
4
8
0
3
9
6
,
7
9
9
4
1
2
,
4
3
4
3
7
2
,
4
5
9
a
c
t
.
4
1
3
,
0
6
3
4
1
6
,
2
4
4
4
1
6
,
2
4
4
4
1
6
,
2
4
4
4
1
6
,
2
4
4
4
1
6
,
2
4
4
Fe
b
r
u
a
r
y
3
1
9
,
4
8
2
2
8
8
,
3
4
2
3
1
3
,
8
3
6
4
0
7
,
4
0
7
3
0
8
,
5
6
7
3
5
0
,
8
1
3
a
c
t
.
3
2
7
,
5
2
7
3
1
1
,
4
1
8
3
1
1
,
4
1
8
3
1
1
,
4
1
8
3
1
1
,
4
1
8
3
1
1
,
4
1
8
Ma
r
c
h
5
0
8
,
3
8
0
5
0
5
,
1
8
5
4
1
5
,
4
7
3
2
8
0
,
7
5
8
4
6
6
,
8
5
6
4
7
5
,
1
1
0
a
c
t
.
4
3
5
,
3
3
1
4
7
1
,
1
6
9
4
7
1
,
1
6
9
4
7
1
,
1
6
9
4
7
1
,
1
6
9
4
7
1
,
1
6
9
Ap
r
i
l
4
0
0
,
7
7
1
3
6
5
,
5
1
4
3
7
0
,
4
7
3
4
5
2
,
8
2
4
4
0
9
,
3
6
5
3
7
2
,
3
4
0
a
c
t
.
3
9
9
,
7
8
9
4
1
3
,
1
4
7
4
1
3
,
1
4
7
4
1
3
,
1
4
7
4
1
3
,
1
4
7
4
1
3
,
1
4
7
Ma
y
2
2
1
,
5
7
9
2
5
7
,
3
1
3
2
9
5
,
5
4
5
3
1
5
,
1
6
5
2
6
3
,
9
0
2
2
6
6
,
4
2
2
a
c
t
.
2
7
0
,
7
0
1
2
6
6
,
3
4
0
2
6
6
,
3
4
0
2
6
6
,
3
4
0
2
6
6
,
3
4
0
2
6
6
,
3
4
0
Ju
n
e
5
2
7
,
1
0
4
4
5
3
,
7
8
8
4
0
0
,
6
6
7
4
3
9
,
2
9
8
4
9
4
,
7
5
7
4
9
9
,
3
2
8
e
s
t
.
4
6
3
,
1
2
3
4
9
9
,
3
2
8
4
9
9
,
3
2
8
4
9
9
,
3
2
8
4
9
9
,
3
2
8
4
9
9
,
3
2
8
Ju
l
y
4
0
3
,
4
9
5
3
2
6
,
5
0
1
4
6
2
,
2
4
4
4
6
8
,
6
4
3
3
8
9
,
4
2
3
3
9
3
,
0
2
1
e
s
t
.
4
1
0
,
0
6
1
3
9
3
,
0
2
1
3
9
3
,
0
2
1
3
9
3
,
0
2
1
3
9
3
,
0
2
1
3
9
3
,
0
2
1
Au
g
u
s
t
2
4
5
,
3
0
8
2
6
1
,
7
0
7
2
4
7
,
2
6
0
2
8
2
,
8
5
9
2
7
8
,
2
3
1
2
8
0
,
8
0
1
e
s
t
.
2
6
3
,
0
7
3
2
8
0
,
8
0
1
2
8
0
,
8
0
1
2
8
0
,
8
0
1
2
8
0
,
8
0
1
2
8
0
,
8
0
1
Se
p
t
e
m
b
e
r
5
3
0
,
3
9
2
4
8
1
,
7
9
9
4
9
5
,
3
9
8
4
8
2
,
2
4
4
5
0
4
,
3
0
7
5
0
8
,
9
6
6
e
s
t
.
4
9
8
,
8
2
8
5
0
8
,
9
6
6
5
0
8
,
9
6
6
5
0
8
,
9
6
6
5
0
8
,
9
6
6
5
0
8
,
9
6
6
Oc
t
o
b
e
r
3
8
1
,
2
3
0
3
4
8
,
0
0
2
3
9
5
,
0
5
8
3
8
2
,
2
0
5
3
6
7
,
3
6
6
3
7
0
,
7
6
0
e
s
t
.
3
7
4
,
7
7
2
3
7
0
,
7
6
0
3
7
0
,
7
6
0
3
7
0
,
7
6
0
3
7
0
,
7
6
0
3
7
0
,
7
6
0
Ac
t
u
a
l
t
o
D
a
t
e
$
4
,
6
7
8
,
7
0
9
$
4
,
3
6
1
,
8
6
1
$
4
,
5
1
2
,
2
4
0
$
4
,
5
7
6
,
6
7
7
$
4
,
6
5
6
,
9
7
8
2
,
6
1
3
,
2
0
7
4
,
5
5
7
,
2
9
3
4
,
7
0
0
,
0
0
0
4
,
7
0
0
,
0
0
0
4
,
7
0
0
,
0
0
0
4
,
7
0
0
,
0
0
0
4
,
7
00,000
E
s
t
i
m
a
t
e
d
t
o
F
i
s
c
a
l
Y
e
a
r
e
n
d
2,
0
5
2
,
8
7
5
To
t
a
l
A
c
t
u
a
l
&
E
s
t
i
m
a
t
e
d
$
4
,
6
6
6
,
0
8
2
1
0
0
.
1
4
%
A
v
e
r
a
g
e
G
r
o
w
t
h
R
a
t
e
Le
s
s
:
B
u
d
g
e
t
4,
7
0
0
,
0
0
0
1
0
0
.
0
0
%
C
o
n
f
i
d
e
n
c
e
F
a
c
t
o
r
Ov
e
r
(
U
n
d
e
r
)
B
u
d
g
e
t
-$
3
3
,
9
1
8
10
0
.
1
4
%
P
r
o
j
e
c
t
e
d
G
r
o
w
t
h
Cu
m
u
l
a
t
i
v
e
P
e
r
c
e
n
t
a
g
e
s
b
y
M
o
n
t
h
No
v
e
m
b
e
r
5
%
6
%
6
%
5
%
6
%
7
%
De
c
e
m
b
e
r
1
5
%
1
6
%
1
5
%
1
5
%
1
6
%
1
7
%
Ja
n
u
a
r
y
2
4
%
2
5
%
2
5
%
2
3
%
2
5
%
2
4
%
Fe
b
r
u
a
r
y
3
1
%
3
1
%
3
2
%
3
2
%
3
2
%
3
2
%
Ma
r
c
h
4
2
%
4
3
%
4
1
%
3
8
%
4
2
%
4
2
%
Ap
r
i
l
5
1
%
5
1
%
4
9
%
4
8
%
5
1
%
5
0
%
Ma
y
5
5
%
5
7
%
5
6
%
5
5
%
5
6
%
5
6
%
Ju
n
e
6
7
%
6
7
%
6
5
%
6
5
%
6
7
%
6
6
%
Ju
l
y
7
5
%
7
5
%
7
5
%
7
5
%
7
5
%
7
5
%
Au
g
u
s
t
8
1
%
8
1
%
8
0
%
8
1
%
8
1
%
8
1
%
Se
p
t
e
m
b
e
r
9
2
%
9
2
%
9
1
%
9
2
%
9
2
%
9
1
%
Oc
t
o
b
e
r
1
0
0
%
1
0
0
%
1
0
0
%
1
0
0
%
1
0
0
%
9
9
%
To
t
a
l
A
m
o
u
n
t
L
a
s
t
1
2
M
o
n
t
h
s
4
,
6
4
4
,
7
7
1
Pr
e
v
i
o
u
s
1
2
M
o
n
t
h
s
A
c
t
u
a
l
4
,
7
2
9
,
4
0
6
%
G
r
o
w
t
h
-
1
.
7
9
%
0
10
0
,
0
0
0
20
0
,
0
0
0
30
0
,
0
0
0
40
0
,
0
0
0
50
0
,
0
0
0
60
0
,
0
0
0
Cu
r
r
e
n
t
A
c
t
u
a
l
5
Y
e
a
r
A
v
e
r
a
g
e
Printed 5/9/2013
Ci
t
y
o
f
J
e
f
f
e
r
s
o
n
,
M
o
.
-
A
c
c
o
u
n
t
A
n
a
l
y
s
i
s
Ac
c
o
u
n
t
N
a
m
e
Pa
r
k
s
S
a
l
e
s
T
a
x
Ra
t
e
:
O
n
e
-
H
a
l
f
p
e
r
c
e
n
t
(
½
%
)
R
e
c
e
i
p
t
M
o
n
t
h
:
A
P
R
I
L
2
0
1
3
Ac
c
o
u
n
t
N
u
m
b
e
r
21
-
2
1
0
-
4
0
0
0
1
0
Mo
n
t
h
l
y
Pr
o
j
e
c
t
e
d
f
u
t
u
r
e
F
i
s
c
a
l
Y
e
a
r
s
20
0
8
2
0
0
9
2
0
1
0
2
0
1
1
2
0
1
2
2
0
1
3
Av
e
r
a
g
e
20
1
4
2
0
1
5
2
0
1
6
2
0
1
7
2
0
1
8
No
v
e
m
b
e
r
2
2
5
,
9
8
2
2
4
3
,
7
9
6
2
7
5
,
4
6
9
2
4
0
,
3
4
8
2
6
4
,
7
3
5
3
0
6
,
8
3
1
a
c
t
.
2
5
0
,
0
6
6
2
5
2
,
4
0
0
2
5
2
,
8
9
1
2
5
3
,
3
8
2
2
5
3
,
8
7
5
2
5
4
,
3
6
9
De
c
e
m
b
e
r
4
9
7
,
7
8
6
4
4
6
,
7
9
7
3
8
4
,
3
0
0
4
2
8
,
2
0
0
4
9
5
,
3
0
5
4
6
8
,
9
2
4
a
c
t
.
4
5
0
,
4
7
8
4
5
4
,
6
8
2
4
5
5
,
5
6
6
4
5
6
,
4
5
2
4
5
7
,
3
3
9
4
5
8
,
2
2
9
Ja
n
u
a
r
y
4
1
6
,
5
6
9
3
8
4
,
3
0
5
4
5
5
,
4
4
2
3
9
6
,
8
1
5
4
0
5
,
7
3
0
3
7
2
,
4
4
7
a
c
t
.
4
1
1
,
7
7
2
4
1
5
,
6
1
6
4
1
6
,
4
2
4
4
1
7
,
2
3
3
4
1
8
,
0
4
4
4
1
8
,
8
5
7
Fe
b
r
u
a
r
y
3
1
8
,
8
5
8
2
8
8
,
3
2
2
3
1
3
,
7
9
2
4
0
7
,
3
4
8
3
0
8
,
4
5
6
3
5
0
,
7
1
4
a
c
t
.
3
2
7
,
3
5
5
3
3
0
,
4
1
1
3
3
1
,
0
5
3
3
3
1
,
6
9
7
3
3
2
,
3
4
2
3
3
2
,
9
8
8
Ma
r
c
h
5
0
8
,
2
4
9
5
0
7
,
7
6
8
4
1
5
,
2
7
5
2
8
0
,
7
3
4
4
6
6
,
7
1
3
4
7
5
,
0
2
6
a
c
t
.
4
3
5
,
7
4
8
4
3
9
,
8
1
5
4
4
0
,
6
7
0
4
4
1
,
5
2
7
4
4
2
,
3
8
5
4
4
3
,
2
4
5
Ap
r
i
l
4
0
0
,
6
0
6
3
6
5
,
7
2
7
3
7
0
,
3
0
8
4
5
2
,
7
3
5
4
0
9
,
3
5
3
3
7
2
,
2
4
2
a
c
t
.
3
9
9
,
7
4
6
4
0
3
,
4
7
7
4
0
4
,
2
6
1
4
0
5
,
0
4
7
4
0
5
,
8
3
5
4
0
6
,
6
2
4
Ma
y
2
2
0
,
8
2
1
2
5
6
,
6
7
5
2
9
5
,
5
2
9
3
1
5
,
1
6
5
2
6
3
,
8
2
2
2
6
6
,
4
5
6
a
c
t
.
2
7
0
,
4
0
2
2
7
2
,
9
2
6
2
7
3
,
4
5
7
2
7
3
,
9
8
9
2
7
4
,
5
2
1
2
7
5
,
0
5
5
Ju
n
e
5
2
7
,
0
2
5
4
5
3
,
0
1
6
4
0
0
,
5
0
0
4
3
9
,
2
6
5
4
9
4
,
7
3
3
4
6
8
,
9
9
9
e
s
t
.
4
6
2
,
9
0
8
4
6
7
,
2
2
9
4
6
8
,
1
3
7
4
6
9
,
0
4
7
4
6
9
,
9
5
9
4
7
0
,
8
7
3
Ju
l
y
4
0
2
,
4
8
2
3
2
6
,
5
1
8
4
6
1
,
2
5
5
4
6
8
,
3
8
7
3
8
9
,
0
0
6
5
0
0
,
0
9
2
e
s
t
.
4
0
9
,
5
2
9
4
1
3
,
3
5
2
4
1
4
,
1
5
6
4
1
4
,
9
6
1
4
1
5
,
7
6
8
4
1
6
,
5
7
6
Au
g
u
s
t
2
4
5
,
0
7
0
2
6
1
,
6
2
2
2
4
7
,
2
1
6
2
8
2
,
8
3
6
2
7
8
,
0
7
2
3
0
1
,
9
8
1
e
s
t
.
2
6
2
,
9
6
3
2
6
5
,
4
1
8
2
6
5
,
9
3
4
2
6
6
,
4
5
1
2
6
6
,
9
6
9
2
6
7
,
4
8
8
Se
p
t
e
m
b
e
r
5
3
0
,
3
5
2
4
8
1
,
7
7
2
4
9
5
,
2
2
2
4
8
2
,
1
5
0
5
0
5
,
9
1
3
5
1
4
,
7
8
7
e
s
t
.
4
9
9
,
0
8
2
5
0
3
,
7
4
0
5
0
4
,
7
2
0
5
0
5
,
7
0
1
5
0
6
,
6
8
4
5
0
7
,
6
6
9
Oc
t
o
b
e
r
3
8
1
,
3
0
9
3
4
7
,
7
2
1
3
9
5
,
0
1
4
3
8
2
,
1
1
5
3
6
6
,
8
4
6
1
8
9
,
7
4
7
e
s
t
.
3
7
4
,
6
0
1
3
7
8
,
0
9
8
3
7
8
,
8
3
3
3
7
9
,
5
6
9
3
8
0
,
3
0
7
3
8
1
,
0
4
7
Ac
t
u
a
l
t
o
D
a
t
e
$
4
,
6
7
5
,
1
1
0
$
4
,
3
6
4
,
0
4
0
$
4
,
5
0
9
,
3
2
1
$
4
,
5
7
6
,
0
9
8
$
4
,
6
4
8
,
6
8
4
2
,
6
1
2
,
6
3
9
4
,
5
5
4
,
6
5
1
4
,
5
9
7
,
1
6
4
4
,
6
0
6
,
1
0
2
4
,
6
1
5
,
0
5
6
4
,
6
2
4
,
0
2
9
4
,
6
33,018
E
s
t
i
m
a
t
e
d
t
o
F
i
s
c
a
l
Y
e
a
r
e
n
d
(
b
a
s
e
d
o
n
a
v
e
r
a
g
e
s
a
n
d
o
n
B
u
d
g
e
t
e
d
a
m
o
u
n
t
)
1,
9
7
5
,
6
0
5
To
t
a
l
A
c
t
u
a
l
&
E
s
t
i
m
a
t
e
d
$
4
,
5
8
8
,
2
4
4
1
0
0
.
7
4
%
1
0
0
.
1
9
%
A
v
e
r
a
g
e
G
r
o
w
t
h
R
a
t
e
Le
s
s
:
B
u
d
g
e
t
4,
6
6
7
,
6
2
0
1
0
0
.
0
0
%
C
o
n
f
i
d
e
n
c
e
F
a
c
t
o
r
Ov
e
r
(
U
n
d
e
r
)
B
u
d
g
e
t
-$
7
9
,
3
7
6
10
0
.
1
9
%
P
r
o
j
e
c
t
e
d
G
r
o
w
t
h
Cu
m
u
l
a
t
i
v
e
P
e
r
c
e
n
t
a
g
e
s
b
y
M
o
n
t
h
No
v
e
m
b
e
r
5
%
6
%
6
%
5
%
6
%
7
%
De
c
e
m
b
e
r
1
5
%
1
6
%
1
5
%
1
5
%
1
6
%
1
7
%
Ja
n
u
a
r
y
2
4
%
2
5
%
2
5
%
2
3
%
2
5
%
2
5
%
Fe
b
r
u
a
r
y
3
1
%
3
1
%
3
2
%
3
2
%
3
2
%
3
2
%
Ma
r
c
h
4
2
%
4
3
%
4
1
%
3
8
%
4
2
%
4
2
%
Ap
r
i
l
5
1
%
5
1
%
4
9
%
4
8
%
5
1
%
5
0
%
Ma
y
5
5
%
5
7
%
5
6
%
5
5
%
5
6
%
5
6
%
Ju
n
e
6
7
%
6
8
%
6
5
%
6
5
%
6
7
%
6
6
%
Ju
l
y
7
5
%
7
5
%
7
5
%
7
5
%
7
5
%
7
7
%
Au
g
u
s
t
8
0
%
8
1
%
8
0
%
8
1
%
8
1
%
8
3
%
Se
p
t
e
m
b
e
r
9
2
%
9
2
%
9
1
%
9
2
%
9
2
%
9
4
%
Oc
t
o
b
e
r
1
0
0
%
1
0
0
%
1
0
0
%
1
0
0
%
1
0
0
%
9
8
%
To
t
a
l
A
m
o
u
n
t
L
a
s
t
1
2
M
o
n
t
h
s
4
,
6
4
4
,
5
7
4
Pr
e
v
i
o
u
s
1
2
M
o
n
t
h
s
A
c
t
u
a
l
4
,
7
2
0
,
2
1
0
%
G
r
o
w
t
h
-
1
.
6
0
%
Printed 5/9/2013
General Ledger
Trial Balance by Acct Type
User: spearre
Printed: 05/20/13 10:09:14
Period 01 - 13
Fiscal Year 2013
Sort Level Description Budget YTD Actual Encumbered Remaining Budget %
UncollectedAvailable
10 General Fund
Revenue Revenue
100 Revenue
400010 Sales Tax 9,700,000.00 3,790,516.42 0.00 5,909,483.58 60.92
400020 Sales Tax Interest 0.00 0.00 0.00 0.00 0.00
R10 Sales & Use Taxes 9,700,000.00 3,790,516.42 0.00 5,909,483.58 60.92
401030 Motor Vehicle Sales Tax 403,750.00 146,332.55 0.00 257,417.45 63.76
R15 Motor Vehicle Sales Tax 403,750.00 146,332.55 0.00 257,417.45 63.76
403010 Gasoline Tax 1,100,950.00 343,887.37 0.00 757,062.63 68.76
403020 Cigarette Tax 147,000.00 56,340.60 0.00 90,659.40 61.67
R20 Other Taxes 1,247,950.00 400,227.97 0.00 847,722.03 67.93
410020 Electric Utility Lic Tax 3,225,000.00 1,166,260.05 0.00 2,058,739.95 63.84
410021 Electric Utility-AUDIT 0.00 0.00 0.00 0.00 0.00
410030 Gas Utility License Tax 900,000.00 617,733.02 0.00 282,266.98 31.36
410031 Gas Utility-AUDIT 0.00 0.00 0.00 0.00 0.00
410050 Telephone Utility Lic Tax 0.00 0.00 0.00 0.00 0.00
410051 Cell Phone Utility Tax 0.00 0.00 0.00 0.00 0.00
410052 TelephoneCell Utility Tax 2,825,000.00 1,023,740.72 0.00 1,801,259.28 63.76
410053 TelephoneCell Utility-AUDIT 110,000.00 67,033.15 0.00 42,966.85 39.06
410060 Cable Franchise Fee 325,000.00 169,891.24 0.00 155,108.76 47.73
410061 Cable Utility-AUDIT 0.00 0.00 0.00 0.00 0.00
R30 Franchise & Utility Tax 7,385,000.00 3,044,658.18 0.00 4,340,341.82 58.77
420010 Cur Property Tax 4,600,000.00 4,541,308.11 0.00 58,691.89 1.28
420020 Del Property Tax 50,000.00 32,352.31 0.00 17,647.69 35.30
420040 Fin Inst Tax 30,000.00 30,689.00 0.00 -689.00 -2.30
420050 Prop Tax Int & Penalties 16,000.00 17,010.48 0.00 -1,010.48 -6.32
420055 Surtax Receipts - County Reimb 54,000.00 54,399.28 0.00 -399.28 -0.74
420060 Surtax Receipts 450,000.00 470,588.39 0.00 -20,588.39 -4.58
420080 Special Tax Rev 21,000.00 10,947.52 0.00 10,052.48 47.87
R40 Property Taxes 5,221,000.00 5,157,295.09 0.00 63,704.91 1.22
GL - Trial Balance by Acct Type (05/20/2013 - 10:09 AM)Page 1
Sort Level Description Budget YTD Actual Encumbered Remaining Budget %
UncollectedAvailable
430010 Federal Grants 1,748,895.20 416,812.38 0.00 1,332,082.82 76.17
430020 State Grants 10,650.00 0.00 0.00 10,650.00 100.00
430040 Local Grants 15,594.00 20,049.51 0.00 -4,455.51 -28.57
430055 DARE Contributions 0.00 0.00 0.00 0.00 0.00
430060 Drug Forfeiture 0.00 6,727.93 0.00 -6,727.93 0.00
430074 Overtime Reimb 0.00 0.00 0.00 0.00 0.00
430080 Road & Bridge Tax 550,000.00 551,540.67 0.00 -1,540.67 -0.28
430100 State DNR Historic Pres.0.00 0.00 0.00 0.00 0.00
R50 Intergovernmental 2,325,139.20 995,130.49 0.00 1,330,008.71 57.20
440010 Admin Charge Backs 1,225,660.00 602,297.19 0.00 623,362.81 50.86
440050 Emt Reimbursement 35,000.00 0.00 0.00 35,000.00 100.00
440210 Street Cuts 25,000.00 15,743.00 0.00 9,257.00 37.03
440910 Fuel Charge-backs 364,590.00 166,484.83 0.00 198,105.17 54.34
440920 Parts Charge-back 170,610.00 73,414.22 0.00 97,195.78 56.97
440930 Labor Charge-backs 167,800.00 67,551.87 0.00 100,248.13 59.74
R60 Charges for Services 1,988,660.00 925,491.11 0.00 1,063,168.89 53.46
450010 Liquor Licenses 60,000.00 54,726.25 0.00 5,273.75 8.79
450020 Business Licenses 233,800.00 96,165.06 0.00 137,634.94 58.87
450021 Home Occupation Permit 1,500.00 1,200.00 0.00 300.00 20.00
450030 Soliciters Licenses 0.00 0.00 0.00 0.00 0.00
450040 Abandoned Bldg Registration 0.00 493.57 0.00 -493.57 0.00
450041 Abandoned Bldg Admin Fee 0.00 653.73 0.00 -653.73 0.00
450045 Bldg Constr Fees 150,000.00 81,711.73 0.00 68,288.27 45.53
450050 Electrical Certificates 20,000.00 14,380.00 0.00 5,620.00 28.10
450060 Electrical Permits 2,500.00 2,004.58 0.00 495.42 19.82
450070 Plumbing Licenses 12,000.00 9,620.00 0.00 2,380.00 19.83
450080 Plumbing Permits 7,500.00 3,420.00 0.00 4,080.00 54.40
450090 Other Lic & Permits 1,500.00 1,100.00 0.00 400.00 26.67
450091 Day Care Inspection Fees 8,000.00 3,160.00 0.00 4,840.00 60.50
450092 Food Inspection Fees 88,000.00 87,013.75 0.00 986.25 1.12
450100 Curb Cut Permits 700.00 450.00 0.00 250.00 35.71
450110 Board Of Adj Fees 800.00 2,600.00 0.00 -1,800.00 -225.00
450120 Sign Permits 4,000.00 2,020.00 0.00 1,980.00 49.50
450130 Demolition Permits 500.00 350.00 0.00 150.00 30.00
450150 Acc Rep Fees-police 12,000.00 6,337.95 0.00 5,662.05 47.18
450160 Accrptblastg P-fire 2,000.00 505.00 0.00 1,495.00 74.75
450170 Animal Redemption Fees 53,000.00 25,390.00 0.00 27,610.00 52.09
450180 Animal Vaccinations Fees 2,800.00 2,915.00 0.00 -115.00 -4.11
450185 Animal Cremation Fees 15,000.00 14,943.00 0.00 57.00 0.38
450186 Animal Boarding Fees 0.00 0.00 0.00 0.00 0.00
450190 Taxi Permits 300.00 0.00 0.00 300.00 100.00
450230 Vacating Right Of Way 800.00 100.00 0.00 700.00 87.50
450250 Rezoning Request 10,000.00 5,470.00 0.00 4,530.00 45.30
450260 Non-refundable Plansspec 3,000.00 897.50 0.00 2,102.50 70.08
R65 Fees Licenses & Permits 689,700.00 417,627.12 0.00 272,072.88 39.45
GL - Trial Balance by Acct Type (05/20/2013 - 10:09 AM)Page 2
Sort Level Description Budget YTD Actual Encumbered Remaining Budget %
UncollectedAvailable
460010 Court Cost 85,000.00 43,025.94 0.00 41,974.06 49.38
460015 Court Restitutions 1,300.00 1,016.84 0.00 283.16 21.78
460018 Inmate Security Fund 12,080.00 6,865.78 0.00 5,214.22 43.16
460020 Jail Cost Recovery 15,000.00 5,481.12 0.00 9,518.88 63.46
460025 Alcohol Offense Cost Rec 13,000.00 6,658.50 0.00 6,341.50 48.78
460030 Pol Fines-traffic 875,000.00 446,101.84 0.00 428,898.16 49.02
460040 Pol Tickets-parking 1,000.00 0.00 0.00 1,000.00 100.00
460050 Pol Fines-other 0.00 0.00 0.00 0.00 0.00
460060 Dog Fines 0.00 0.00 0.00 0.00 0.00
460070 P & Code Violations 0.00 0.00 0.00 0.00 0.00
460090 Parking Fines 58,600.00 31,746.99 0.00 26,853.01 45.82
460100 Bankcard Charges -10,000.00 -6,585.06 0.00 -3,414.94 34.15
R70 Fines & Forfeitures 1,050,980.00 534,311.95 0.00 516,668.05 49.16
450187 Special Sn Program 0.00 0.00 0.00 0.00 0.00
450188 Adoption Voucher Program 0.00 0.00 0.00 0.00 0.00
450189 Animal Shelter Bricks 0.00 0.00 0.00 0.00 0.00
480010 Citizen Participation 0.00 280.00 0.00 -280.00 0.00
480015 Sidewalk Waiver Revenue 0.00 0.00 0.00 0.00 0.00
480020 NSP Rehab Sales 101,406.88 0.00 0.00 101,406.88 100.00
480025 HUD Program Income 0.00 0.00 0.00 0.00 0.00
480030 Donations-Recycling 5,500.00 11,000.00 0.00 -5,500.00 -100.00
480050 Sober Driver Program 9,000.00 2,582.22 0.00 6,417.78 71.31
480055 JC Fire Museum 0.00 300.00 0.00 -300.00 0.00
480063 Private Donations-Cultural Art 0.00 0.00 0.00 0.00 0.00
480065 Cultural Arts 0.00 20.00 0.00 -20.00 0.00
480070 Community Projects Donations 1,500.00 2,270.00 0.00 -770.00 -51.33
480080 Dare Donations 8,000.00 8,006.24 0.00 -6.24 -0.08
480090 Police K-9 Donations 1,000.00 500.00 0.00 500.00 50.00
480165 Animal S Donations 80,780.00 3,588.00 0.00 77,192.00 95.56
481020 Cole Cty Animal Rescue 100,000.00 50,000.00 0.00 50,000.00 50.00
481030 Rent City Hallannex 6,500.00 3,250.00 0.00 3,250.00 50.00
481040 Rent Other 12,000.00 0.00 0.00 12,000.00 100.00
481045 Rent-tower Sites 80,000.00 25,144.43 0.00 54,855.57 68.57
481050 Transfer StnPlng-Sld Wst Cntr 0.00 0.00 0.00 0.00 0.00
481055 Street Repair-Solid Waste Cntr 110,000.00 50,110.92 0.00 59,889.08 54.44
481070 Miscellaneous 24,000.00 11,360.84 0.00 12,639.16 52.66
481075 Cole Cty 911 Reimb 355,715.00 207,841.56 0.00 147,873.44 41.57
481077 Insurance Claims 30,000.00 13,237.59 0.00 16,762.41 55.87
481078 Cafeteria Refunds 15,000.00 0.00 0.00 15,000.00 100.00
481080 Sale Of Mapsgis Data 100.00 50.00 0.00 50.00 50.00
481085 Cole Cty Gis Joint Coop 15,000.00 8,750.00 0.00 6,250.00 41.67
481100 Sale Of Grave Sites 3,500.00 2,800.00 0.00 700.00 20.00
481110 Long & Short 0.00 -33.98 0.00 33.98 0.00
R75 Other Operating Revenues 959,001.88 401,057.82 0.00 557,944.06 58.18
470010 Interest 40,000.00 38,134.21 0.00 1,865.79 4.66
470051 Unrealized Gainslosses 0.00 0.00 0.00 0.00 0.00
GL - Trial Balance by Acct Type (05/20/2013 - 10:09 AM)Page 3
Sort Level Description Budget YTD Actual Encumbered Remaining Budget %
UncollectedAvailable
R80 Interest Income 40,000.00 38,134.21 0.00 1,865.79 4.66
485049 Capvhcleqp-sale Of Assets 0.00 0.00 0.00 0.00 0.00
485050 Sale Of Assets 297,000.00 277,592.02 0.00 19,407.98 6.53
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
490193 Trsfr From Grant Fund 0.00 0.00 0.00 0.00 0.00
490240 Trsfr From Lodging Tax 20,990.00 8,499.02 0.00 12,490.98 59.51
490260 Trans from Firemen's Spec Rev 0.00 0.00 0.00 0.00 0.00
490280 Trnf From Stoneridge Tdd 0.00 0.00 0.00 0.00 0.00
490353 Transfer From Cit 'e'0.00 0.00 0.00 0.00 0.00
490620 Transfer from Parking Fund 0.00 0.00 0.00 0.00 0.00
R90 Transfers In 20,990.00 8,499.02 0.00 12,490.98 59.51
495995 Transfer From(to) Surplus 1,010,417.16 0.00 0.00 1,010,417.16 100.00
495996 Trnasfer From(To) Surplus 0.00 0.00 0.00 0.00 0.00
R99 Carry Over Surplus 1,010,417.16 0.00 0.00 1,010,417.16 100.00
100 Revenue 32,339,588.24 16,136,873.95 0.00 16,202,714.29 50.10
300 Police Department
430010 Federal Grants 525,201.79 86,237.58 0.00 438,964.21 83.58
430020 State Grants 0.00 0.00 0.00 0.00 0.00
430040 Local Grants 0.00 0.00 0.00 0.00 0.00
430074 Overtime Reimb 68,826.00 16,586.10 0.00 52,239.90 75.90
R50 Intergovernmental 594,027.79 102,823.68 0.00 491,204.11 82.69
300 Police Department 594,027.79 102,823.68 0.00 491,204.11 82.69
310 School Resource Officer
430010 Federal Grants 0.00 0.00 0.00 0.00 0.00
430020 State Grants 0.00 0.00 0.00 0.00 0.00
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.
430010 Federal Grants 0.00 14,012.97 0.00 -14,012.97 0.00
430020 State Grants 0.00 0.00 0.00 0.00 0.00
430040 Local Grants 0.00 0.00 0.00 0.00 0.00
430060 Drug Forfeiture 0.00 1,830.28 0.00 -1,830.28 0.00
430074 Overtime Reimb 0.00 0.00 0.00 0.00 0.00
R50 Intergovernmental 0.00 15,843.25 0.00 -15,843.25 0.00
320 M.U.S.T.A.N.G.0.00 15,843.25 0.00 -15,843.25 0.00
GL - Trial Balance by Acct Type (05/20/2013 - 10:09 AM)Page 4
Sort Level Description Budget YTD Actual Encumbered Remaining Budget %
UncollectedAvailable
Revenue Revenue 33,122,381.03 16,447,783.22 0.00 16,674,597.81 50.34
Expense Expense
110 Mayor & Council
501010 Salary-Elected Officials 64,800.00 33,075.00 0.00 31,725.00 48.96
501020 Salaries 0.00 0.00 0.00 0.00 0.00
501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00
502010 Social Security 4,960.00 2,359.13 0.00 2,600.87 52.44
502020 Group Health Insurance 0.00 650.00 0.00 -650.00 0.00
502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 69,760.00 36,084.13 0.00 33,675.87 48.27
511010 Advertising 230.00 0.00 0.00 230.00 100.00
511020 Postage 20.00 59.57 0.00 -39.57 -197.85
512010 Printing 150.00 0.00 0.00 150.00 100.00
512020 Copies 1,030.00 46.39 0.00 983.61 95.50
513010 Office Supplies 270.00 170.14 267.36 -167.50 -62.04
E10 Materials & Supplies 1,700.00 276.10 267.36 1,156.55 68.03
520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00
520030 Dues And Publications 5,014.46 4,367.51 0.00 646.95 12.90
520050 Meeting And Conferences 83.05 104.83 0.00 -21.78 -26.23
522020 Professional Services 0.00 0.00 0.00 0.00 0.00
529010 Special Events 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 5,097.51 4,472.34 0.00 625.17 12.26
534010 Telephone 0.00 0.00 0.00 0.00 0.00
E20 Utilities 0.00 0.00 0.00 0.00 0.00
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 40,832.57 267.36 35,457.59 46.31
120 City Clerk
501020 Salaries 62,566.80 33,661.17 0.00 28,905.63 46.20
501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00
501090 Overtime 0.00 0.00 0.00 0.00 0.00
501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00
502010 Social Security 4,783.86 2,429.86 0.00 2,354.00 49.21
502020 Group Health Insurance 11,791.50 6,544.07 0.00 5,247.43 44.50
502030 Retirement 10,968.60 6,318.33 0.00 4,650.27 42.40
502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
502050 Life Insurance 110.00 57.64 0.00 52.36 47.60
502060 Long Term Disability 151.47 89.47 0.00 62.00 40.93
502070 Employee Assistance Prgm 33.30 16.56 0.00 16.74 50.27
E05 Personnel Services 90,405.53 49,117.10 0.00 41,288.43 45.67
GL - Trial Balance by Acct Type (05/20/2013 - 10:09 AM)Page 5
Sort Level Description Budget YTD Actual Encumbered Remaining Budget %
UncollectedAvailable
511020 Postage 270.00 90.48 0.00 179.52 66.49
512010 Printing 300.00 0.00 0.00 300.00 100.00
512020 Copies 4,500.00 188.46 0.00 4,311.54 95.81
513010 Office Supplies 1,150.00 20.07 0.00 1,129.93 98.25
E10 Materials & Supplies 6,220.00 299.01 0.00 5,920.99 95.19
520030 Dues And Publications 200.00 15.00 0.00 185.00 92.50
520050 Meeting And Conferences 500.00 24.00 0.00 476.00 95.20
520070 Training And Education 500.00 0.00 0.00 500.00 100.00
522020 Professional Services 2,416.98 0.00 0.00 2,416.98 100.00
529030 Election Expense 72,083.02 72,083.02 0.00 0.00 0.00
E15 Contractual Services 75,700.00 72,122.02 0.00 3,577.98 4.73
534010 Telephone 0.00 0.00 0.00 0.00 0.00
E20 Utilities 0.00 0.00 0.00 0.00 0.00
547010 Equipment Maintenance 500.00 349.66 267.36 -117.02 -23.40
E25 Repairs & Maintenance 500.00 349.66 267.36 -117.02 -23.40
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 121,887.79 267.36 50,670.39 29.32
140 City Administrator
501020 Salaries 204,859.92 119,162.06 0.00 85,697.86 41.83
501050 Parttime(wo Benefits)100.98 0.00 0.00 100.98 100.00
501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00
501090 Overtime 0.00 0.00 0.00 0.00 0.00
501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00
502010 Social Security 15,494.23 7,885.51 0.00 7,608.72 49.11
502020 Group Health Insurance 9,853.41 10,662.14 0.00 -808.73 -8.21
502030 Retirement 36,676.68 22,137.74 0.00 14,538.94 39.64
502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
502050 Life Insurance 383.78 189.03 0.00 194.75 50.75
502060 Long Term Disability 475.08 233.58 0.00 241.50 50.83
502070 Employee Assistance Prgm 31.59 22.07 0.00 9.52 30.14
E05 Personnel Services 267,875.67 160,292.13 0.00 107,583.54 40.16
511010 Advertising 3,292.49 1,527.95 0.00 1,764.54 53.59
511020 Postage 370.00 213.82 0.00 156.18 42.21
512010 Printing 330.00 0.00 0.00 330.00 100.00
512020 Copies 950.00 67.74 0.00 882.26 92.87
513010 Office Supplies 1,200.00 1,026.33 267.36 -93.69 -7.81
E10 Materials & Supplies 6,142.49 2,835.84 267.36 3,039.30 49.48
520030 Dues And Publications 580.00 580.00 0.00 0.00 0.00
520050 Meeting And Conferences 1,211.80 925.41 0.00 286.39 23.63
GL - Trial Balance by Acct Type (05/20/2013 - 10:09 AM)Page 6
Sort Level Description Budget YTD Actual Encumbered Remaining Budget %
UncollectedAvailable
520070 Training And Education 0.00 99.00 0.00 -99.00 0.00
522020 Professional Services 3,472.22 175.00 0.00 3,297.22 94.96
E15 Contractual Services 5,264.02 1,779.41 0.00 3,484.61 66.20
534010 Telephone 0.00 0.00 0.00 0.00 0.00
E20 Utilities 0.00 0.00 0.00 0.00 0.00
541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00
547010 Equipment Maintenance 150.00 237.60 0.00 -87.60 -58.40
E25 Repairs & Maintenance 150.00 237.60 0.00 -87.60 -58.40
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 165,144.98 267.36 114,019.85 40.80
149 Entitlement Grant
501020 Salaries 0.00 1,541.25 0.00 -1,541.25 0.00
501050 Parttime(wo Benefits)20,000.00 0.00 0.00 20,000.00 100.00
502010 Social Security 1,000.00 117.91 0.00 882.09 88.21
502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00
502030 Retirement 0.00 0.00 0.00 0.00 0.00
502050 Life Insurance 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 21,000.00 1,659.16 0.00 19,340.84 92.10
511010 Advertising 500.00 117.33 0.00 382.67 76.53
511020 Postage 600.00 115.45 0.00 484.55 80.76
512020 Copies 800.00 72.67 0.00 727.33 90.92
513010 Office Supplies 600.00 135.89 0.00 464.11 77.35
E10 Materials & Supplies 2,500.00 441.34 0.00 2,058.66 82.35
520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00
520070 Training And Education 1,500.00 0.00 0.00 1,500.00 100.00
522020 Professional Services 10,000.00 156.00 0.00 9,844.00 98.44
528010 Housing Rehabilitation 50,000.00 20,117.25 0.00 29,882.75 59.77
528020 Housing Assistance 10,020.00 300.00 0.00 9,720.00 97.01
528030 Public Improvement 50,000.00 0.00 0.00 50,000.00 100.00
528040 Neighborhood Redevelopmnt 80,000.00 19,500.00 0.00 60,500.00 75.63
528050 Neighborhood Facility 80,000.00 0.00 0.00 80,000.00 100.00
528060 Economic Development 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 281,520.00 40,073.25 0.00 241,446.75 85.77
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
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
GL - Trial Balance by Acct Type (05/20/2013 - 10:09 AM)Page 7
Sort Level Description Budget YTD Actual Encumbered Remaining Budget %
UncollectedAvailable
149 Entitlement Grant 306,020.00 42,173.75 0.00 263,846.25 86.22
150 City Counselor
501020 Salaries 218,045.40 114,801.65 0.00 103,243.75 47.35
501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00
501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00
501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00
501090 Overtime 500.00 183.60 0.00 316.40 63.28
501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00
502010 Social Security 16,687.06 8,232.11 0.00 8,454.95 50.67
502020 Group Health Insurance 28,192.50 16,041.04 0.00 12,151.46 43.10
502030 Retirement 38,218.40 17,651.36 0.00 20,567.04 53.81
502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
502050 Life Insurance 390.00 192.74 0.00 197.26 50.58
502060 Long Term Disability 535.13 275.96 0.00 259.17 48.43
502070 Employee Assistance Prgm 77.70 38.64 0.00 39.06 50.27
503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 302,646.19 157,417.10 0.00 145,229.09 47.99
511010 Advertising 0.00 0.00 0.00 0.00 0.00
511020 Postage 100.00 120.63 0.00 -20.63 -20.63
512010 Printing 200.00 0.00 0.00 200.00 100.00
512020 Copies 670.00 107.54 0.00 562.46 83.95
513010 Office Supplies 2,000.00 1,072.88 0.00 927.12 46.36
517010 Operational Supplies 100.00 0.00 0.00 100.00 100.00
E10 Materials & Supplies 3,070.00 1,301.05 0.00 1,768.95 57.62
520020 Auditing Travel Expense 0.00 0.00 0.00 0.00 0.00
520030 Dues And Publications 13,250.00 5,518.50 0.00 7,731.50 58.35
520050 Meeting And Conferences 1,500.00 804.08 0.00 695.92 46.39
520070 Training And Education 2,400.00 408.55 0.00 1,991.45 82.98
520080 Tuition Reimbursement 2,880.00 1,596.00 0.00 1,284.00 44.58
521010 General Insurance 2,100.00 844.00 0.00 1,256.00 59.81
522020 Professional Services 12,000.00 11,020.36 0.00 979.64 8.16
525030 Court Cost & Witness Fees 290.00 28.36 0.00 261.64 90.22
E15 Contractual Services 34,420.00 20,219.85 0.00 14,200.15 41.26
534010 Telephone 0.00 0.00 0.00 0.00 0.00
E20 Utilities 0.00 0.00 0.00 0.00 0.00
547010 Equipment Maintenance 1,890.00 773.94 539.10 576.97 30.53
E25 Repairs & Maintenance 1,890.00 773.94 539.10 576.97 30.53
572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
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 179,711.94 539.10 161,775.16 47.30
GL - Trial Balance by Acct Type (05/20/2013 - 10:09 AM)Page 8
Sort Level Description Budget YTD Actual Encumbered Remaining Budget %
UncollectedAvailable
160 Municipal Court Dept
501010 Salary-Elected Officials 60,000.00 29,999.94 0.00 30,000.06 50.00
501020 Salaries 95,145.60 52,554.87 0.00 42,590.73 44.76
501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00
501050 Parttime(wo Benefits)9,500.00 3,482.75 0.00 6,017.25 63.34
501090 Overtime 8,600.00 2,013.91 0.00 6,586.09 76.58
501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00
502010 Social Security 13,252.72 6,645.38 0.00 6,607.34 49.86
502020 Group Health Insurance 14,248.50 6,371.39 0.00 7,877.11 55.28
502030 Retirement 18,210.30 10,242.15 0.00 7,968.15 43.76
502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
502050 Life Insurance 170.00 88.27 0.00 81.73 48.08
502060 Long Term Disability 232.24 137.77 0.00 94.47 40.68
502070 Employee Assistance Prgm 55.50 27.60 0.00 27.90 50.27
E05 Personnel Services 219,414.86 111,564.03 0.00 107,850.83 49.15
511010 Advertising 0.00 0.00 0.00 0.00 0.00
511020 Postage 4,000.00 1,597.28 0.00 2,402.72 60.07
512010 Printing 1,090.00 377.70 0.00 712.30 65.35
512020 Copies 1,000.00 81.01 0.00 918.99 91.90
513010 Office Supplies 1,600.00 1,082.44 0.00 517.56 32.35
E10 Materials & Supplies 7,690.00 3,138.43 0.00 4,551.57 59.19
520030 Dues And Publications 300.00 100.00 0.00 200.00 66.67
520050 Meeting And Conferences 500.00 359.48 0.00 140.52 28.10
520070 Training And Education 600.00 500.00 0.00 100.00 16.67
522020 Professional Services 21,000.00 8,771.38 0.00 12,228.62 58.23
525010 Care Of Prisoners 2,790.50 0.00 0.00 2,790.50 100.00
525030 Court Cost & Witness Fees 40.00 0.00 0.00 40.00 100.00
E15 Contractual Services 25,230.50 9,730.86 0.00 15,499.64 61.43
534010 Telephone 0.00 0.00 0.00 0.00 0.00
E20 Utilities 0.00 0.00 0.00 0.00 0.00
547010 Equipment Maintenance 200.00 708.67 267.36 -776.03 -388.01
E25 Repairs & Maintenance 200.00 708.67 267.36 -776.03 -388.01
572020 Purchase Of Equipment 0.00 0.00 23,851.06 -23,851.06 0.00
E70 Capital Purchases 0.00 0.00 23,851.06 -23,851.06 0.00
160 Municipal Court Dept 252,535.36 125,141.99 24,118.42 103,274.96 40.90
170 Human Resources
501020 Salaries 182,896.20 97,601.91 0.00 85,294.29 46.64
501050 Parttime(wo Benefits)9,600.00 4,653.13 0.00 4,946.87 51.53
501090 Overtime 300.00 0.00 0.00 300.00 100.00
502010 Social Security 15,514.34 7,523.07 0.00 7,991.27 51.51
GL - Trial Balance by Acct Type (05/20/2013 - 10:09 AM)Page 9
Sort Level Description Budget YTD Actual Encumbered Remaining Budget %
UncollectedAvailable
502020 Group Health Insurance 23,310.00 13,907.82 0.00 9,402.18 40.34
502030 Retirement 32,107.90 18,320.93 0.00 13,786.97 42.94
502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
502050 Life Insurance 320.00 165.80 0.00 154.20 48.19
502060 Long Term Disability 444.30 235.38 0.00 208.92 47.02
502070 Employee Assistance Prgm 66.60 33.11 0.00 33.49 50.29
503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 264,559.34 142,441.15 0.00 122,118.19 46.16
511010 Advertising 150.00 0.00 0.00 150.00 100.00
511020 Postage 1,000.00 59.68 0.00 940.32 94.03
512010 Printing 2,000.00 676.86 899.61 423.53 21.18
512020 Copies 1,500.00 365.27 0.00 1,134.73 75.65
513010 Office Supplies 1,500.00 221.05 0.00 1,278.95 85.26
517010 Operational Supplies 1,350.00 30.88 0.00 1,319.12 97.71
E10 Materials & Supplies 7,500.00 1,353.74 899.61 5,246.65 69.96
520030 Dues And Publications 1,255.00 379.00 0.00 876.00 69.80
520050 Meeting And Conferences 942.00 127.86 0.00 814.14 86.43
520060 Wellness Program 3,919.00 1,100.43 0.00 2,818.57 71.92
520070 Training And Education 2,002.00 605.38 0.00 1,396.62 69.76
520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00
521060 Drugalcohol Screening 5,816.00 3,686.25 0.00 2,129.75 36.62
522020 Professional Services 10,986.00 1,274.46 0.00 9,711.54 88.40
529010 Special Events 0.00 0.00 0.00 0.00 0.00
529015 Human Rights Commission 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 24,920.00 7,173.38 0.00 17,746.62 71.21
534010 Telephone 0.00 0.00 0.00 0.00 0.00
E20 Utilities 0.00 0.00 0.00 0.00 0.00
547010 Equipment Maintenance 100.00 170.14 267.36 -337.50 -337.50
E25 Repairs & Maintenance 100.00 170.14 267.36 -337.50 -337.50
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 297,079.34 151,138.41 1,166.97 144,773.97 48.73
180 Finance Department
501020 Salaries 615,366.81 339,296.60 0.00 276,070.21 44.86
501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00
501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00
501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00
501090 Overtime 0.00 0.00 0.00 0.00 0.00
501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00
502010 Social Security 48,011.64 25,656.15 0.00 22,355.49 46.56
502020 Group Health Insurance 84,704.73 37,375.14 0.00 47,329.59 55.88
GL - Trial Balance by Acct Type (05/20/2013 - 10:09 AM)Page 10
Sort Level Description Budget YTD Actual Encumbered Remaining Budget %
UncollectedAvailable
502030 Retirement 106,596.32 56,810.85 0.00 49,785.47 46.70
502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
502050 Life Insurance 1,078.90 518.46 0.00 560.44 51.95
502060 Long Term Disability 1,592.54 814.98 0.00 777.56 48.83
502070 Employee Assistance Prgm 286.89 154.57 0.00 132.32 46.12
E05 Personnel Services 857,637.83 460,626.75 0.00 397,011.08 46.29
511010 Advertising 2,000.00 129.30 0.00 1,870.70 93.54
511020 Postage 13,500.00 5,384.05 0.00 8,115.95 60.12
511021 Postage Cost 2,000.00 2,291.87 0.00 -291.87 -14.59
512010 Printing 6,500.00 1,790.17 899.61 3,810.22 58.62
512020 Copies 7,000.00 2,095.21 0.00 4,904.79 70.07
512021 Copy Machine Cost 0.00 -825.18 1,604.13 -778.95 0.00
513010 Office Supplies 5,913.00 1,030.85 0.00 4,882.15 82.57
517010 Operational Supplies 3,827.60 1,054.22 0.00 2,773.38 72.46
E10 Materials & Supplies 40,740.60 12,950.49 2,503.74 25,286.37 62.07
520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00
520020 Auditing Travel Expense 0.00 0.00 0.00 0.00 0.00
520030 Dues And Publications 2,400.00 135.52 0.00 2,264.48 94.35
520050 Meeting And Conferences 1,768.30 1,629.38 0.00 138.92 7.86
520070 Training And Education 0.00 0.00 0.00 0.00 0.00
520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00
522010 Audit 25,342.40 0.00 25,342.40 0.00 0.00
522020 Professional Services 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 29,510.70 1,764.90 25,342.40 2,403.40 8.14
534010 Telephone 0.00 0.00 0.00 0.00 0.00
E20 Utilities 0.00 0.00 0.00 0.00 0.00
547010 Equipment Maintenance 2,000.00 1,215.84 0.00 784.16 39.21
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
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 929,889.13 476,557.98 27,846.14 425,485.01 45.76
185 Non-Departmental
501020 Salaries 327,024.85 0.00 0.00 327,024.85 100.00
502020 Group Health Insurance 5,000.00 5,000.00 0.00 0.00 0.00
504010 Employee Salary Guarantee Fund 38,659.42 0.00 0.00 38,659.42 100.00
E05 Personnel Services 370,684.27 5,000.00 0.00 365,684.27 98.65
514011 Gas Oil & Antifreeze 935,000.00 465,405.80 41,020.20 428,574.00 45.84
E10 Materials & Supplies 935,000.00 465,405.80 41,020.20 428,574.00 45.84
GL - Trial Balance by Acct Type (05/20/2013 - 10:09 AM)Page 11
Sort Level Description Budget YTD Actual Encumbered Remaining Budget %
UncollectedAvailable
520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00
520080 Tuition Reimbursement 8,000.00 0.00 0.00 8,000.00 100.00
521010 General Insurance 261,000.00 260,529.32 0.00 470.68 0.18
521020 Insurance Deductible 10,000.00 13,332.79 0.00 -3,332.79 -33.33
521030 Self Ins Prop & Casualty 70,000.00 30,581.74 0.00 39,418.26 56.31
521070 Prov For Unsettled Claims 0.00 0.00 0.00 0.00 0.00
522020 Professional Services 235,000.00 224,583.31 14,583.33 -4,166.64 -1.77
524010 Trash Collections 500.00 0.00 0.00 500.00 100.00
526030 Assessment Charge 38,500.00 22,704.69 0.00 15,795.31 41.03
527020 Economic Development 185,000.00 0.00 0.00 185,000.00 100.00
529010 Special Events 18,000.00 9,394.57 0.00 8,605.43 47.81
E15 Contractual Services 826,000.00 561,126.42 14,583.33 250,290.25 30.30
531010 Electricity 37,400.00 12,976.58 0.00 24,423.42 65.30
533010 Natural Gas 11,000.00 3,620.91 0.00 7,379.09 67.08
535010 Water 2,750.00 2,643.11 0.00 106.89 3.89
535020 Downtown Irrigation 0.00 0.00 0.00 0.00 0.00
E20 Utilities 51,150.00 19,240.60 0.00 31,909.40 62.38
540010 Building & Grounds Maint.60,000.00 16,228.90 4,007.55 39,763.55 66.27
540020 Tree & Landscape Maint 25,000.00 23,625.00 0.00 1,375.00 5.50
547020 Maintenance Agreements 2,000.00 780.00 0.00 1,220.00 61.00
E25 Repairs & Maintenance 87,000.00 40,633.90 4,007.55 42,358.55 48.69
550010 Miscellaneous 17,246.44 2,422.44 0.00 14,824.00 85.95
550015 Bad Debt Expense 0.00 -270.00 0.00 270.00 0.00
550020 Neighborhood Reinvestment 0.00 0.00 0.00 0.00 0.00
550030 Old Town Projects 0.00 0.00 0.00 0.00 0.00
550036 Salute to America 5,000.00 5,000.00 0.00 0.00 0.00
550037 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00
550038 Civil War Reenactment Comm 0.00 0.00 0.00 0.00 0.00
550039 Katy Trail Welcome Area 0.00 0.00 0.00 0.00 0.00
550040 Public Art 6,250.00 32.48 0.00 6,217.52 99.48
550043 JC Fire Museum 0.00 0.00 0.00 0.00 0.00
550045 JC Fire Museum 0.00 0.00 0.00 0.00 0.00
550050 Neighb Stablization Prog 0.00 0.00 0.00 0.00 0.00
550060 MSP 0.00 0.00 0.00 0.00 0.00
550070 Energy Grant Expenditures 0.00 0.00 0.00 0.00 0.00
550080 Neighborhd Improvement Progr 0.00 0.00 0.00 0.00 0.00
550090 Hazard Mitigation 0.00 0.00 0.00 0.00 0.00
E30 Other Operating Expenses 28,496.44 7,184.92 0.00 21,311.52 74.79
572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
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
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
GL - Trial Balance by Acct Type (05/20/2013 - 10:09 AM)Page 12
Sort Level Description Budget YTD Actual Encumbered Remaining Budget %
UncollectedAvailable
185 Non-Departmental 2,298,330.71 1,098,591.64 59,611.08 1,140,127.99 49.61
190 I.T. Department
501020 Salaries 519,071.25 277,663.14 0.00 241,408.11 46.51
501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00
501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00
501090 Overtime 0.00 0.00 0.00 0.00 0.00
501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00
502010 Social Security 39,713.63 20,557.58 0.00 19,156.05 48.24
502020 Group Health Insurance 65,444.47 30,159.23 0.00 35,285.24 53.92
502030 Retirement 90,885.78 47,023.79 0.00 43,861.99 48.26
502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
502050 Life Insurance 890.25 470.02 0.00 420.23 47.20
502060 Long Term Disability 1,268.63 708.75 0.00 559.88 44.13
502070 Employee Assistance Prgm 206.63 104.87 0.00 101.76 49.25
E05 Personnel Services 717,480.64 376,687.38 0.00 340,793.26 47.50
511010 Advertising 500.00 0.00 0.00 500.00 100.00
511020 Postage 200.00 9.77 0.00 190.23 95.12
512010 Printing 100.00 0.00 0.00 100.00 100.00
512020 Copies 400.00 28.68 0.00 371.32 92.83
512030 Photographic Supplies 100.00 0.00 0.00 100.00 100.00
513010 Office Supplies 750.00 83.74 0.00 666.26 88.83
514030 Small Tools 50.00 0.00 0.00 50.00 100.00
514040 Food 50.00 0.00 0.00 50.00 100.00
515040 First Aid Supplies 50.00 0.00 0.00 50.00 100.00
517010 Operational Supplies 1,750.00 834.30 899.61 16.09 0.92
E10 Materials & Supplies 3,950.00 956.49 899.61 2,093.90 53.01
520010 Mileage Expense 500.00 150.01 0.00 349.99 70.00
520030 Dues And Publications 500.00 0.00 0.00 500.00 100.00
520050 Meeting And Conferences 1,000.00 75.00 0.00 925.00 92.50
520070 Training And Education 3,500.00 2,448.07 0.00 1,051.93 30.06
520080 Tuition Reimbursement 3,000.00 0.00 0.00 3,000.00 100.00
522020 Professional Services 3,000.00 824.41 0.00 2,175.59 72.52
522030 Services - Prof Training 0.00 0.00 0.00 0.00 0.00
522040 Service-internet T1 Web 19,800.00 9,714.48 0.00 10,085.52 50.94
522050 Service-remote Locations 0.00 0.00 0.00 0.00 0.00
522060 City Web Site 2,000.00 0.00 0.00 2,000.00 100.00
E15 Contractual Services 33,300.00 13,211.97 0.00 20,088.03 60.32
534010 Telephone 54,333.00 28,559.87 0.00 25,773.13 47.44
E20 Utilities 54,333.00 28,559.87 0.00 25,773.13 47.44
545010 Software Licensemaint 207,369.87 148,026.64 0.00 59,343.23 28.62
545020 Citywide Wiringnetwork 4,000.00 339.28 0.00 3,660.72 91.52
547010 Equipment Maintenance 4,000.00 2,415.58 0.00 1,584.42 39.61
GL - Trial Balance by Acct Type (05/20/2013 - 10:09 AM)Page 13
Sort Level Description Budget YTD Actual Encumbered Remaining Budget %
UncollectedAvailable
547020 Maintenance Agreements 31,630.13 31,324.36 271.74 34.03 0.11
E25 Repairs & Maintenance 247,000.00 182,105.86 271.74 64,622.40 26.16
572020 Purchase Of Equipment 25,000.00 22,711.15 1,378.72 910.13 3.64
E70 Capital Purchases 25,000.00 22,711.15 1,378.72 910.13 3.64
190 I.T. Department 1,081,063.64 624,232.72 2,550.07 454,280.85 42.02
300 Police Department
501020 Salaries 4,011,613.39 2,204,074.78 0.00 1,807,538.61 45.06
501030 Holiday Pay 119,064.00 78,747.62 0.00 40,316.38 33.86
501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00
501050 Parttime(wo Benefits)30,400.00 16,584.50 0.00 13,815.50 45.45
501060 Seasonal Salaries 9,000.00 9,273.50 0.00 -273.50 -3.04
501070 Stand-by Plan 6,800.00 2,524.00 0.00 4,276.00 62.88
501090 Overtime 239,228.50 117,315.57 0.00 121,912.93 50.96
501095 Overtime Straight Pay 6,000.00 7,919.00 0.00 -1,919.00 -31.98
502010 Social Security 343,918.63 176,504.74 0.00 167,413.89 48.68
502020 Group Health Insurance 720,145.46 353,372.43 0.00 366,773.03 50.93
502030 Retirement 864,464.58 481,504.82 0.00 382,959.76 44.30
502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
502050 Life Insurance 6,745.31 3,624.63 0.00 3,120.68 46.26
502060 Long Term Disability 9,688.90 5,588.02 0.00 4,100.88 42.33
502070 Employee Assistance Prgm 1,900.66 1,010.05 0.00 890.61 46.86
503010 Awards Program 1,600.00 0.00 0.00 1,600.00 100.00
503020 Unemployment Compensation 1,000.00 0.00 0.00 1,000.00 100.00
E05 Personnel Services 6,371,569.43 3,458,043.66 0.00 2,913,525.77 45.73
511010 Advertising 3,000.00 1,333.40 0.00 1,666.60 55.55
511020 Postage 2,500.00 775.71 0.00 1,724.29 68.97
512010 Printing 5,000.00 277.99 0.00 4,722.01 94.44
512020 Copies 0.00 2.59 0.00 -2.59 0.00
512030 Photographic Supplies 1,000.00 0.00 0.00 1,000.00 100.00
513010 Office Supplies 12,000.00 6,074.12 0.00 5,925.88 49.38
514010 Gas, Oil, Anti-Freeze 0.00 0.00 0.00 0.00 0.00
514040 Food 700.00 172.65 0.00 527.35 75.34
516010 Ammunition & Firearms Supplies 23,000.00 3,023.73 19,076.70 899.57 3.91
516020 Dare Program 16,000.00 3,138.45 0.00 12,861.55 80.38
516030 Special Investigation 2,500.00 2,500.00 0.00 0.00 0.00
516040 Investigations (Grant)0.00 0.00 0.00 0.00 0.00
516050 Community Projects 0.00 1,801.90 0.00 -1,801.90 0.00
517010 Operational Supplies 30,000.00 5,898.17 0.00 24,101.83 80.34
E10 Materials & Supplies 95,700.00 24,998.71 19,076.70 51,624.59 53.94
520030 Dues And Publications 4,000.00 3,203.78 0.00 796.22 19.91
520050 Meeting And Conferences 7,000.00 1,066.27 0.00 5,933.73 84.77
520070 Training And Education 10,000.00 6,941.26 0.00 3,058.74 30.59
520080 Tuition Reimbursement 7,000.00 3,304.50 0.00 3,695.50 52.79
GL - Trial Balance by Acct Type (05/20/2013 - 10:09 AM)Page 14
Sort Level Description Budget YTD Actual Encumbered Remaining Budget %
UncollectedAvailable
520090 Recruitment 2,500.00 12.00 0.00 2,488.00 99.52
521040 Medical Claimsservices 4,000.00 1,757.00 0.00 2,243.00 56.08
521050 Medical Services 1,000.00 573.41 0.00 426.59 42.66
522020 Professional Services 15,000.00 10,000.53 0.00 4,999.47 33.33
523010 Equipment Rentlease 12,840.00 5,600.00 0.00 7,240.00 56.39
523030 Rent-Parking Lot 1,160.00 660.00 500.00 0.00 0.00
524010 Trash Collections 600.00 0.00 0.00 600.00 100.00
525020 Sober Driver Program 12,000.00 2,241.21 0.00 9,758.79 81.32
525050 Police Reserve 0.00 0.00 0.00 0.00 0.00
529010 Special Events 2,200.00 1,099.03 0.00 1,100.97 50.04
E15 Contractual Services 79,300.00 36,458.99 500.00 42,341.01 53.39
531010 Electricity 49,500.00 25,830.80 0.00 23,669.20 47.82
533010 Natural Gas 19,800.00 9,533.61 0.00 10,266.39 51.85
534010 Telephone 9,900.00 2,493.19 0.00 7,406.81 74.82
535010 Water 2,200.00 1,857.45 0.00 342.55 15.57
E20 Utilities 81,400.00 39,715.05 0.00 41,684.95 51.21
540010 Building & Grounds Maint.51,000.00 24,000.91 5,223.40 21,775.69 42.70
541030 Vehicle Wash 7,000.00 5,405.00 0.00 1,595.00 22.79
544010 K-9 Operations 12,000.00 3,588.10 0.00 8,411.90 70.10
544015 Care of Animals 0.00 0.00 0.00 0.00 0.00
544020 Civil Defense 50,417.16 50,208.00 0.00 209.16 0.41
544030 Emerg Mgmt Operations 17,500.00 3,007.17 0.00 14,492.83 82.82
546010 Clothing Expense 40,732.00 11,754.42 -306.39 29,283.97 71.89
546020 Uniform Cleaning 26,000.00 10,609.70 0.00 15,390.30 59.19
547010 Equipment Maintenance 8,000.00 4,629.73 0.00 3,370.27 42.13
547020 Maintenance Agreements 55,000.00 16,239.68 2,619.95 36,140.37 65.71
547030 Radio Maintenance 10,000.00 5,365.92 0.00 4,634.08 46.34
E25 Repairs & Maintenance 277,649.16 134,808.63 7,536.96 135,303.57 48.73
572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00
572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
572070 Police Grant Equipment 153,772.97 41,680.17 94,089.16 18,003.64 11.71
572075 LLEBG Annual Grant Equipment 11,154.00 0.00 0.00 11,154.00 100.00
572076 LLEBG Stimulus Equipment 0.00 0.00 0.00 0.00 0.00
572100 MDT Year 3 Equipment 330,274.82 54,297.62 14,400.00 261,577.20 79.20
572110 Jcpd Mdt Equipment 0.00 0.00 0.00 0.00 0.00
572120 Cole Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00
572130 Osage B Mdt Equip 0.00 0.00 0.00 0.00 0.00
572140 Camden Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00
572150 Callaway Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00
572160 Fulton Mdt Equip 0.00 0.00 0.00 0.00 0.00
572170 Eldon Mdt Equip 0.00 0.00 0.00 0.00 0.00
572180 Miller Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00
572190 Camdenton Cty Mtd 0.00 0.00 0.00 0.00 0.00
572200 Lake Ozark Mdt Equip 0.00 0.00 0.00 0.00 0.00
572310 Software-camdnmilob 0.00 0.00 0.00 0.00 0.00
GL - Trial Balance by Acct Type (05/20/2013 - 10:09 AM)Page 15
Sort Level Description Budget YTD Actual Encumbered Remaining Budget %
UncollectedAvailable
572320 Software-morgan Cty 0.00 0.00 0.00 0.00 0.00
572330 Software-jcpdcole Cty 0.00 0.00 0.00 0.00 0.00
572340 Software-colboone Cty 0.00 0.00 0.00 0.00 0.00
572350 Software-fultncallaway 0.00 0.00 0.00 0.00 0.00
572360 Software-vpnfirewl 0.00 0.00 0.00 0.00 0.00
572370 Software-prof Serv 0.00 0.00 0.00 0.00 0.00
572410 Project Mgmt Fees 0.00 0.00 0.00 0.00 0.00
572420 Contingency 0.00 0.00 0.00 0.00 0.00
573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 495,201.79 95,977.79 108,489.16 290,734.84 58.71
300 Police Department 7,400,820.38 3,790,002.83 135,602.82 3,475,214.73 46.96
310 School Resource Officer
501020 Salaries 242,821.20 101,297.16 0.00 141,524.04 58.28
501030 Holiday Pay 9,343.20 1,841.76 0.00 7,501.44 80.29
501090 Overtime 7,126.00 5,425.03 0.00 1,700.97 23.87
501095 Overtime Straight Pay 0.00 590.16 0.00 -590.16 0.00
502010 Social Security 20,668.24 7,653.74 0.00 13,014.50 62.97
502020 Group Health Insurance 41,485.50 19,878.57 0.00 21,606.93 52.08
502030 Retirement 51,873.60 22,894.67 0.00 28,978.93 55.86
502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
502050 Life Insurance 450.00 173.67 0.00 276.33 61.41
502060 Long Term Disability 605.93 271.07 0.00 334.86 55.26
502070 Employee Assistance Prgm 111.00 55.20 0.00 55.80 50.27
E05 Personnel Services 374,484.67 160,081.03 0.00 214,403.64 57.25
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
520070 Training And Education 0.00 0.00 0.00 0.00 0.00
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
541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00
546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00
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
572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00
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 160,081.03 0.00 214,403.64 57.25
320 M.U.S.T.A.N.G.
501020 Salaries 86,802.00 34,675.15 0.00 52,126.85 60.05
501030 Holiday Pay 3,335.40 859.65 0.00 2,475.75 74.23
GL - Trial Balance by Acct Type (05/20/2013 - 10:09 AM)Page 16
Sort Level Description Budget YTD Actual Encumbered Remaining Budget %
UncollectedAvailable
501090 Overtime 6,897.00 5,838.04 0.00 1,058.96 15.35
501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00
502010 Social Security 8,315.20 3,019.66 0.00 5,295.54 63.69
502020 Group Health Insurance 14,532.00 5,800.08 0.00 8,731.92 60.09
502030 Retirement 20,614.10 8,668.12 0.00 11,945.98 57.95
502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
502050 Life Insurance 150.00 60.58 0.00 89.42 59.61
502060 Long Term Disability 212.12 95.94 0.00 116.18 54.77
502070 Employee Assistance Prgm 44.40 22.07 0.00 22.33 50.29
E05 Personnel Services 140,902.22 59,039.29 0.00 81,862.93 58.10
514010 Gas, Oil, Anti-Freeze 0.00 0.00 0.00 0.00 0.00
516040 Investigations (Grant)20,000.00 10,269.99 0.00 9,730.01 48.65
517010 Operational Supplies 1,000.00 438.61 0.00 561.39 56.14
E10 Materials & Supplies 21,000.00 10,708.60 0.00 10,291.40 49.01
520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00
520070 Training And Education 1,500.00 0.00 0.00 1,500.00 100.00
522020 Professional Services 5,000.00 15,000.00 0.00 -10,000.00 -200.00
523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00
523020 Building Lease 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 6,500.00 15,000.00 0.00 -8,500.00 -130.77
541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00
546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00
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
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.168,402.22 84,747.89 0.00 83,654.33 49.68
330 Animal Control
501020 Salaries 301,073.92 160,952.52 0.00 140,121.40 46.54
501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00
501050 Parttime(wo Benefits)600.00 0.00 0.00 600.00 100.00
501060 Seasonal Salaries 0.00 9,500.00 0.00 -9,500.00 0.00
501070 Stand-by Plan 3,000.00 2,244.00 0.00 756.00 25.20
501090 Overtime 1,709.00 1,210.07 0.00 498.93 29.19
501095 Overtime Straight Pay 500.00 27.82 0.00 472.18 94.44
502010 Social Security 23,963.21 12,098.97 0.00 11,864.24 49.51
502020 Group Health Insurance 65,287.85 31,227.67 0.00 34,060.18 52.17
502030 Retirement 54,182.34 28,464.79 0.00 25,717.55 47.46
502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
502050 Life Insurance 522.79 267.37 0.00 255.42 48.86
502060 Long Term Disability 746.84 416.43 0.00 330.41 44.24
502070 Employee Assistance Prgm 170.77 88.31 0.00 82.46 48.29
GL - Trial Balance by Acct Type (05/20/2013 - 10:09 AM)Page 17
Sort Level Description Budget YTD Actual Encumbered Remaining Budget %
UncollectedAvailable
503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 451,756.72 246,497.95 0.00 205,258.77 45.44
511010 Advertising 2,000.00 45.73 0.00 1,954.27 97.71
511020 Postage 900.00 89.99 0.00 810.01 90.00
512010 Printing 1,700.00 341.86 0.00 1,358.14 79.89
512020 Copies 20.00 0.04 0.00 19.96 99.80
513010 Office Supplies 800.00 623.02 0.00 176.98 22.12
514030 Small Tools 250.00 27.97 0.00 222.03 88.81
515040 First Aid Supplies 150.00 0.00 0.00 150.00 100.00
517010 Operational Supplies 5,500.00 3,735.55 0.00 1,764.45 32.08
E10 Materials & Supplies 11,320.00 4,864.16 0.00 6,455.84 57.03
520030 Dues And Publications 900.00 847.94 0.00 52.06 5.78
520050 Meeting And Conferences 1,000.00 0.00 0.00 1,000.00 100.00
520070 Training And Education 650.00 0.00 0.00 650.00 100.00
521040 Medical Claimsservices 829.00 829.00 0.00 0.00 0.00
522020 Professional Services 9,171.00 2,774.88 0.00 6,396.12 69.74
524010 Trash Collections 1,500.00 0.00 0.00 1,500.00 100.00
529050 Spay & Neuter Program 10,000.00 3,175.92 0.00 6,824.08 68.24
529060 Special Sn Program 0.00 0.00 0.00 0.00 0.00
529065 Adoption Voucher Program 0.00 3,400.00 0.00 -3,400.00 0.00
529067 Animal Shelter Bricks 0.00 1,414.00 0.00 -1,414.00 0.00
E15 Contractual Services 24,050.00 12,441.74 0.00 11,608.26 48.27
531010 Electricity 12,270.00 10,192.64 0.00 2,077.36 16.93
533010 Natural Gas 11,600.00 8,244.47 0.00 3,355.53 28.93
534010 Telephone 572.00 153.56 0.00 418.44 73.15
535010 Water 5,500.00 1,115.20 0.00 4,384.80 79.72
E20 Utilities 29,942.00 19,705.87 0.00 10,236.13 34.19
540010 Building & Grounds Maint.12,000.00 4,632.80 1,800.00 5,567.20 46.39
541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00
541030 Vehicle Wash 540.00 275.00 0.00 265.00 49.07
544040 Care Of Animals 47,000.00 9,898.47 0.00 37,101.53 78.94
546010 Clothing Expense 3,000.00 273.34 0.00 2,726.66 90.89
546020 Uniform Cleaning 200.00 0.00 0.00 200.00 100.00
547010 Equipment Maintenance 1,300.00 90.43 0.00 1,209.57 93.04
547020 Maintenance Agreements 800.00 0.00 0.00 800.00 100.00
547030 Radio Maintenance 700.00 0.00 0.00 700.00 100.00
E25 Repairs & Maintenance 65,540.00 15,170.04 1,800.00 48,569.96 74.11
572020 Purchase Of Equipment 2,094.00 2,094.00 0.00 0.00 0.00
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
578069 Animal Shelter 78,686.00 34,813.28 26,876.00 16,996.72 21.60
E75 Capital Projects 78,686.00 34,813.28 26,876.00 16,996.72 21.60
GL - Trial Balance by Acct Type (05/20/2013 - 10:09 AM)Page 18
Sort Level Description Budget YTD Actual Encumbered Remaining Budget %
UncollectedAvailable
330 Animal Control 663,388.72 335,587.04 28,676.00 299,125.68 45.09
390 9-1-1 Police
501020 Salaries 816,770.64 431,185.71 0.00 385,584.93 47.21
501030 Holiday Pay 29,988.00 18,637.49 0.00 11,350.51 37.85
501050 Parttime(wo Benefits)0.00 150.00 0.00 -150.00 0.00
501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00
501090 Overtime 15,814.00 8,312.21 0.00 7,501.79 47.44
501095 Overtime Straight Pay 500.00 36.04 0.00 463.96 92.79
502010 Social Security 67,111.40 32,989.70 0.00 34,121.70 50.84
502020 Group Health Insurance 163,307.38 79,687.99 0.00 83,619.39 51.20
502030 Retirement 155,143.26 80,554.15 0.00 74,589.11 48.08
502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
502050 Life Insurance 1,442.94 740.08 0.00 702.86 48.71
502060 Long Term Disability 2,021.54 1,143.87 0.00 877.67 43.42
502070 Employee Assistance Prgm 463.64 231.82 0.00 231.82 50.00
503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 1,252,562.80 653,669.06 0.00 598,893.74 47.81
511010 Advertising 2,200.00 0.00 0.00 2,200.00 100.00
512010 Printing 300.00 0.00 0.00 300.00 100.00
517010 Operational Supplies 5,000.00 2,596.03 0.00 2,403.97 48.08
E10 Materials & Supplies 7,500.00 2,596.03 0.00 4,903.97 65.39
520030 Dues And Publications 900.00 145.00 0.00 755.00 83.89
520050 Meeting And Conferences 1,764.69 1,764.69 0.00 0.00 0.00
520070 Training And Education 1,735.31 1,521.99 0.00 213.32 12.29
522020 Professional Services 2,000.00 923.00 0.00 1,077.00 53.85
523010 Equipment Rentlease 100,000.00 48,956.70 3,240.00 47,803.30 47.80
E15 Contractual Services 106,400.00 53,311.38 3,240.00 49,848.62 46.85
534010 Telephone 159.00 0.00 0.00 159.00 100.00
E20 Utilities 159.00 0.00 0.00 159.00 100.00
546010 Clothing Expense 3,400.00 738.86 0.00 2,661.14 78.27
546020 Uniform Cleaning 2,000.00 0.00 0.00 2,000.00 100.00
547010 Equipment Maintenance 2,000.00 486.79 0.00 1,513.21 75.66
547020 Maintenance Agreements 24,392.52 15,883.97 8,508.55 0.00 0.00
547030 Radio Maintenance 2,947.48 1,043.24 0.00 1,904.24 64.61
E25 Repairs & Maintenance 34,740.00 18,152.86 8,508.55 8,078.59 23.25
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 727,729.33 11,748.55 661,883.92 47.23
400 Fire Department
GL - Trial Balance by Acct Type (05/20/2013 - 10:09 AM)Page 19
Sort Level Description Budget YTD Actual Encumbered Remaining Budget %
UncollectedAvailable
501020 Salaries 3,644,108.20 1,963,797.99 0.00 1,680,310.21 46.11
501030 Holiday Pay 282,478.80 194,047.61 0.00 88,431.19 31.31
501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00
501080 Step-up Pay 28,000.00 14,232.32 0.00 13,767.68 49.17
501090 Overtime 30,000.00 9,071.12 0.00 20,928.88 69.76
501095 Overtime Straight Pay 32,000.00 7,787.11 0.00 24,212.89 75.67
502010 Social Security 59,092.54 27,700.31 0.00 31,392.23 53.12
502020 Group Health Insurance 581,939.20 304,166.65 0.00 277,772.55 47.73
502030 Retirement 1,663,127.92 896,758.50 0.00 766,369.42 46.08
502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
502050 Life Insurance 6,409.99 3,247.92 0.00 3,162.07 49.33
502060 Long Term Disability 8,975.29 5,032.68 0.00 3,942.61 43.93
502070 Employee Assistance Prgm 1,673.54 838.95 0.00 834.59 49.87
503010 Awards Program 2,000.00 1,652.84 0.00 347.16 17.36
E05 Personnel Services 6,339,805.48 3,428,334.00 0.00 2,911,471.48 45.92
511010 Advertising 350.00 75.00 0.00 275.00 78.57
511020 Postage 640.00 60.23 0.00 579.77 90.59
512010 Printing 1,250.00 750.83 0.00 499.17 39.93
512020 Copies 200.00 0.42 0.00 199.58 99.79
512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00
513010 Office Supplies 1,800.00 724.42 0.00 1,075.58 59.75
514020 Chemicals 2,000.00 701.84 0.00 1,298.16 64.91
514030 Small Tools 2,500.00 1,557.83 0.00 942.17 37.69
514040 Food 20.00 0.00 0.00 20.00 100.00
515040 First Aid Supplies 400.00 0.00 0.00 400.00 100.00
517010 Operational Supplies 7,500.00 5,137.05 0.00 2,362.95 31.51
E10 Materials & Supplies 16,660.00 9,007.62 0.00 7,652.38 45.93
520030 Dues And Publications 1,300.00 1,175.88 0.00 124.12 9.55
520050 Meeting And Conferences 60.00 32.18 0.00 27.82 46.37
520060 Wellness Program 0.00 0.00 0.00 0.00 0.00
520070 Training And Education 9,120.00 4,371.89 0.00 4,748.11 52.06
520080 Tuition Reimbursement 5,000.00 0.00 0.00 5,000.00 100.00
520085 Traing-Home Land Security 0.00 0.00 0.00 0.00 0.00
521040 Medical Claimsservices 480.00 479.00 0.00 1.00 0.21
522020 Professional Services 0.00 0.00 0.00 0.00 0.00
523010 Equipment Rentlease 5,000.00 0.00 0.00 5,000.00 100.00
524010 Trash Collections 500.00 0.00 0.00 500.00 100.00
529010 Special Events 8,300.00 1,154.48 0.00 7,145.52 86.09
529040 Fire Hydrants 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 29,760.00 7,213.43 0.00 22,546.57 75.76
531010 Electricity 39,500.00 22,875.17 0.00 16,624.83 42.09
533010 Natural Gas 1,500.00 0.00 0.00 1,500.00 100.00
534010 Telephone 15,000.00 9,551.04 0.00 5,448.96 36.33
535010 Water 8,720.00 4,739.42 0.00 3,980.58 45.65
E20 Utilities 64,720.00 37,165.63 0.00 27,554.37 42.57
GL - Trial Balance by Acct Type (05/20/2013 - 10:09 AM)Page 20
Sort Level Description Budget YTD Actual Encumbered Remaining Budget %
UncollectedAvailable
540010 Building & Grounds Maint.44,934.00 20,105.74 1,838.37 22,989.89 51.16
541030 Vehicle Wash 0.00 804.00 0.00 -804.00 0.00
546010 Clothing Expense 35,000.00 11,473.57 537.00 22,989.43 65.68
546020 Uniform Cleaning 1,066.00 1,065.01 0.00 0.99 0.09
547010 Equipment Maintenance 18,000.00 5,049.54 0.00 12,950.46 71.95
547020 Maintenance Agreements 15,900.00 3,531.27 8,419.48 3,949.25 24.84
547030 Radio Maintenance 7,000.00 1,425.61 0.00 5,574.39 79.63
E25 Repairs & Maintenance 121,900.00 43,454.74 10,794.85 67,650.41 55.50
572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00
572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
572021 Purchase of Equipment-ONE TIME 815,000.00 702,062.10 107,088.54 5,849.36 0.72
572060 Fire Grant Equipgear 0.00 0.00 0.00 0.00 0.00
573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 815,000.00 702,062.10 107,088.54 5,849.36 0.72
400 Fire Department 7,387,845.48 4,227,237.52 117,883.39 3,042,724.57 41.19
500 Public Works
501020 Salaries 0.00 0.00 0.00 0.00 0.00
501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00
501090 Overtime 0.00 0.00 0.00 0.00 0.00
501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00
502010 Social Security 0.00 0.00 0.00 0.00 0.00
502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00
502030 Retirement 0.00 0.00 0.00 0.00 0.00
502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
502050 Life Insurance 0.00 0.00 0.00 0.00 0.00
502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00
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
511010 Advertising 0.00 0.00 0.00 0.00 0.00
511020 Postage 0.00 0.00 0.00 0.00 0.00
512010 Printing 0.00 0.00 0.00 0.00 0.00
512020 Copies 0.00 0.11 0.00 -0.11 0.00
513010 Office Supplies 0.00 0.00 0.00 0.00 0.00
514040 Food 0.00 0.00 0.00 0.00 0.00
517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00
E10 Materials & Supplies 0.00 0.11 0.00 -0.11 0.00
520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00
520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00
520070 Training And Education 0.00 0.00 0.00 0.00 0.00
522020 Professional Services 0.00 0.00 0.00 0.00 0.00
523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00
527010 Comm Serv Projects 0.00 0.00 0.00 0.00 0.00
GL - Trial Balance by Acct Type (05/20/2013 - 10:09 AM)Page 21
Sort Level Description Budget YTD Actual Encumbered Remaining Budget %
UncollectedAvailable
E15 Contractual Services 0.00 0.00 0.00 0.00 0.00
534010 Telephone 0.00 0.00 0.00 0.00 0.00
E20 Utilities 0.00 0.00 0.00 0.00 0.00
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
572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
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 0.11 0.00 -0.11 0.00
520 Plan & Protect Svcs-Admin
501020 Salaries 202,276.20 108,326.52 0.00 93,949.68 46.45
501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00
501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00
501090 Overtime 0.00 0.00 0.00 0.00 0.00
501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00
502010 Social Security 15,473.42 7,996.27 0.00 7,477.15 48.32
502020 Group Health Insurance 28,707.00 15,196.16 0.00 13,510.84 47.06
502030 Retirement 35,451.00 20,334.41 0.00 15,116.59 42.64
502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
502050 Life Insurance 360.00 185.83 0.00 174.17 48.38
502060 Long Term Disability 494.76 267.80 0.00 226.96 45.87
502070 Employee Assistance Prgm 88.80 44.16 0.00 44.64 50.27
503010 Awards Program 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 282,851.18 152,351.15 0.00 130,500.03 46.14
511010 Advertising 500.00 470.55 0.00 29.45 5.89
511020 Postage 100.00 125.79 0.00 -25.79 -25.79
512010 Printing 100.00 0.00 0.00 100.00 100.00
512020 Copies 0.00 0.00 0.00 0.00 0.00
512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00
513010 Office Supplies 500.00 225.07 0.00 274.93 54.99
514030 Small Tools 0.00 0.00 0.00 0.00 0.00
515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00
517010 Operational Supplies 150.00 18.00 0.00 132.00 88.00
E10 Materials & Supplies 1,350.00 839.41 0.00 510.59 37.82
520030 Dues And Publications 400.00 191.85 0.00 208.15 52.04
520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00
520070 Training And Education 99.00 99.00 0.00 0.00 0.00
522020 Professional Services 600.00 95.65 0.00 504.35 84.06
E15 Contractual Services 1,099.00 386.50 0.00 712.50 64.83
534010 Telephone 181.31 0.00 0.00 181.31 100.00
GL - Trial Balance by Acct Type (05/20/2013 - 10:09 AM)Page 22
Sort Level Description Budget YTD Actual Encumbered Remaining Budget %
UncollectedAvailable
E20 Utilities 181.31 0.00 0.00 181.31 100.00
547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00
547020 Maintenance Agreements 713.69 647.25 114.24 -47.80 -6.70
E25 Repairs & Maintenance 713.69 647.25 114.24 -47.80 -6.70
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 154,224.31 114.24 131,856.63 46.07
521 Plan & Protect Svcs-Planning
501020 Salaries 51,387.60 27,342.46 0.00 24,045.14 46.79
501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00
501050 Parttime(wo Benefits)12,480.00 6,048.00 0.00 6,432.00 51.54
501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00
501090 Overtime 0.00 0.00 0.00 0.00 0.00
501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00
502010 Social Security 5,657.08 2,554.38 0.00 3,102.70 54.85
502020 Group Health Insurance 5,638.50 2,867.18 0.00 2,771.32 49.15
502030 Retirement 9,009.20 5,132.36 0.00 3,876.84 43.03
502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
502050 Life Insurance 90.00 46.74 0.00 43.26 48.07
502060 Long Term Disability 121.21 72.97 0.00 48.24 39.80
502070 Employee Assistance Prgm 22.20 11.04 0.00 11.16 50.27
503010 Awards Program 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 84,405.79 44,075.13 0.00 40,330.66 47.78
511010 Advertising 6,000.00 1,298.00 0.00 4,702.00 78.37
511020 Postage 2,000.00 726.89 0.00 1,273.11 63.66
512010 Printing 0.00 0.00 0.00 0.00 0.00
512020 Copies 200.00 1.86 0.00 198.14 99.07
512030 Photographic Supplies 30.00 0.00 0.00 30.00 100.00
513010 Office Supplies 1,435.00 355.67 0.00 1,079.33 75.21
514040 Food 0.00 0.00 0.00 0.00 0.00
515040 First Aid Supplies 10.00 0.00 0.00 10.00 100.00
517010 Operational Supplies 2,000.00 1,967.10 0.00 32.90 1.65
E10 Materials & Supplies 11,675.00 4,349.52 0.00 7,325.48 62.75
520030 Dues And Publications 14,400.00 2,274.00 0.00 12,126.00 84.21
520050 Meeting And Conferences 500.00 0.00 0.00 500.00 100.00
520070 Training And Education 0.00 0.00 0.00 0.00 0.00
520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00
522020 Professional Services 0.00 78.00 0.00 -78.00 0.00
523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 14,900.00 2,352.00 0.00 12,548.00 84.21
534010 Telephone 0.00 0.00 0.00 0.00 0.00
GL - Trial Balance by Acct Type (05/20/2013 - 10:09 AM)Page 23
Sort Level Description Budget YTD Actual Encumbered Remaining Budget %
UncollectedAvailable
E20 Utilities 0.00 0.00 0.00 0.00 0.00
541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00
547020 Maintenance Agreements 1,340.00 1,044.37 621.96 -326.33 -24.35
E25 Repairs & Maintenance 1,340.00 1,044.37 621.96 -326.33 -24.35
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 51,821.02 621.96 59,877.81 53.31
522 Plan & Protect Svcs-MPO
501020 Salaries 126,439.20 67,180.45 0.00 59,258.75 46.87
501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00
501090 Overtime 0.00 0.00 0.00 0.00 0.00
501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00
502010 Social Security 9,669.66 4,729.35 0.00 4,940.31 51.09
502020 Group Health Insurance 17,556.00 8,981.28 0.00 8,574.72 48.84
502030 Retirement 22,159.40 12,536.41 0.00 9,622.99 43.43
502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
502050 Life Insurance 220.00 114.47 0.00 105.53 47.97
502060 Long Term Disability 312.98 177.61 0.00 135.37 43.25
502070 Employee Assistance Prgm 44.40 22.07 0.00 22.33 50.29
E05 Personnel Services 176,401.64 93,741.64 0.00 82,660.00 46.86
511010 Advertising 1,000.00 426.40 0.00 573.60 57.36
511020 Postage 700.00 104.70 0.00 595.30 85.04
512010 Printing 1,200.00 0.00 0.00 1,200.00 100.00
512020 Copies 500.00 0.00 0.00 500.00 100.00
513010 Office Supplies 500.00 54.54 0.00 445.46 89.09
514040 Food 300.00 0.00 0.00 300.00 100.00
517010 Operational Supplies 800.00 0.00 0.00 800.00 100.00
E10 Materials & Supplies 5,000.00 585.64 0.00 4,414.36 88.29
520030 Dues And Publications 800.00 615.49 0.00 184.51 23.06
520050 Meeting And Conferences 2,188.00 0.00 0.00 2,188.00 100.00
520070 Training And Education 1,374.42 0.00 0.00 1,374.42 100.00
522020 Professional Services 0.00 0.00 0.00 0.00 0.00
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
534010 Telephone 100.00 0.00 0.00 100.00 100.00
E20 Utilities 100.00 0.00 0.00 100.00 100.00
541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00
547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00
547020 Maintenance Agreements 2,925.58 449.69 280.32 2,195.57 75.05
547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00
GL - Trial Balance by Acct Type (05/20/2013 - 10:09 AM)Page 24
Sort Level Description Budget YTD Actual Encumbered Remaining Budget %
UncollectedAvailable
E25 Repairs & Maintenance 2,925.58 449.69 280.32 2,195.57 75.05
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 95,392.46 280.32 93,116.86 49.32
530 Plan & Protect Svc-RedevGrant
501020 Salaries 112,433.52 40,764.61 0.00 71,668.91 63.74
501090 Overtime 0.00 0.00 0.00 0.00 0.00
502010 Social Security 8,596.77 2,965.23 0.00 5,631.54 65.51
502020 Group Health Insurance 9,658.85 3,675.26 0.00 5,983.59 61.95
502030 Retirement 19,432.96 4,687.39 0.00 14,745.57 75.88
502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
502050 Life Insurance 157.32 59.58 0.00 97.74 62.13
502060 Long Term Disability 281.51 90.85 0.00 190.66 67.73
502070 Employee Assistance Prgm 37.57 22.07 0.00 15.50 41.26
E05 Personnel Services 150,598.50 52,264.99 0.00 98,333.51 65.30
511010 Advertising 0.00 0.00 0.00 0.00 0.00
511020 Postage 10.00 14.29 0.00 -4.29 -42.90
513010 Office Supplies 90.00 15.70 0.00 74.30 82.56
E10 Materials & Supplies 100.00 29.99 0.00 70.01 70.01
520030 Dues And Publications 270.00 324.00 0.00 -54.00 -20.00
520050 Meeting And Conferences 350.00 269.00 0.00 81.00 23.14
520070 Training And Education 500.00 186.00 0.00 314.00 62.80
E15 Contractual Services 1,120.00 779.00 0.00 341.00 30.45
534010 Telephone 0.00 0.00 0.00 0.00 0.00
E20 Utilities 0.00 0.00 0.00 0.00 0.00
541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00
547020 Maintenance Agreements 723.00 292.76 155.76 274.48 37.96
E25 Repairs & Maintenance 723.00 292.76 155.76 274.48 37.96
550020 Neighborhood Reinvestment 28,532.00 23,834.20 0.00 4,697.80 16.47
550030 Old Town Projects 57,468.00 26,264.10 0.00 31,203.90 54.30
550035 Old Town Redev Committee 10,000.00 6,099.30 0.00 3,900.70 39.01
550037 Historic Preservation Comm 15,650.00 0.00 12,800.00 2,850.00 18.21
550050 Neighb Stablization Prog 101,406.88 32,746.73 0.00 68,660.15 67.71
550060 MSP 1,304,060.97 70,980.45 0.00 1,233,080.52 94.56
550090 Hazard Mitigation 146,834.23 3,111.42 1,940.00 141,782.81 96.56
E30 Other Operating Expenses 1,663,952.08 163,036.20 14,740.00 1,486,175.88 89.32
530 Plan & Protect Svc-RedevGrant 1,816,493.58 216,402.94 14,895.76 1,585,194.88 87.27
531 Plan & Protect Svcs-Build Reg
GL - Trial Balance by Acct Type (05/20/2013 - 10:09 AM)Page 25
Sort Level Description Budget YTD Actual Encumbered Remaining Budget %
UncollectedAvailable
501020 Salaries 429,746.40 213,917.44 0.00 215,828.96 50.22
501060 Seasonal Salaries 21,320.00 0.00 0.00 21,320.00 100.00
501090 Overtime 740.00 0.00 0.00 740.00 100.00
501095 Overtime Straight Pay 130.00 0.00 0.00 130.00 100.00
502010 Social Security 34,574.62 15,501.86 0.00 19,072.76 55.16
502020 Group Health Insurance 54,747.00 29,072.62 0.00 25,674.38 46.90
502030 Retirement 75,477.30 38,025.93 0.00 37,451.37 49.62
502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
502050 Life Insurance 740.00 331.73 0.00 408.27 55.17
502060 Long Term Disability 1,050.11 539.89 0.00 510.22 48.59
502070 Employee Assistance Prgm 177.60 88.31 0.00 89.29 50.28
E05 Personnel Services 618,703.03 297,477.78 0.00 321,225.25 51.92
511010 Advertising 200.00 45.50 0.00 154.50 77.25
511020 Postage 1,800.00 1,021.95 0.00 778.05 43.23
512010 Printing 700.00 0.00 0.00 700.00 100.00
512020 Copies 10.00 0.00 0.00 10.00 100.00
512030 Photographic Supplies 100.00 0.00 0.00 100.00 100.00
513010 Office Supplies 1,829.00 643.73 674.71 510.56 27.91
514030 Small Tools 300.00 0.00 0.00 300.00 100.00
515040 First Aid Supplies 30.00 0.00 0.00 30.00 100.00
517010 Operational Supplies 1,589.42 1,435.83 0.00 153.59 9.66
E10 Materials & Supplies 6,558.42 3,147.01 674.71 2,736.70 41.73
520030 Dues And Publications 2,000.00 519.00 0.00 1,481.00 74.05
520050 Meeting And Conferences 719.96 108.00 0.00 611.96 85.00
520070 Training And Education 2,500.00 1,416.99 0.00 1,083.01 43.32
522020 Professional Services 25,000.00 2,577.50 9,648.00 12,774.50 51.10
522070 Legal Services 0.00 0.00 0.00 0.00 0.00
523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00
529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 30,219.96 4,621.49 9,648.00 15,950.47 52.78
534010 Telephone 345.58 0.00 0.00 345.58 100.00
E20 Utilities 345.58 0.00 0.00 345.58 100.00
541030 Vehicle Wash 540.00 285.00 0.00 255.00 47.22
546010 Clothing Expense 1,130.00 773.09 0.00 356.91 31.58
547010 Equipment Maintenance 60.00 0.00 0.00 60.00 100.00
547020 Maintenance Agreements 1,775.04 855.45 997.07 -77.48 -4.36
547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00
E25 Repairs & Maintenance 3,505.04 1,913.54 997.07 594.43 16.96
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 659,332.03 307,159.82 11,319.78 340,852.43 51.70
GL - Trial Balance by Acct Type (05/20/2013 - 10:09 AM)Page 26
Sort Level Description Budget YTD Actual Encumbered Remaining Budget %
UncollectedAvailable
532 Plan & Protect Svcs-Env Health
501020 Salaries 114,362.40 68,800.24 0.00 45,562.16 39.84
501060 Seasonal Salaries 3,957.00 870.00 0.00 3,087.00 78.01
501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00
501090 Overtime 220.00 0.00 0.00 220.00 100.00
501095 Overtime Straight Pay 60.00 0.00 0.00 60.00 100.00
502010 Social Security 10,381.54 5,120.76 0.00 5,260.78 50.67
502020 Group Health Insurance 17,356.50 10,288.78 0.00 7,067.72 40.72
502030 Retirement 20,099.00 12,915.14 0.00 7,183.86 35.74
502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
502050 Life Insurance 200.00 117.68 0.00 82.32 41.16
502060 Long Term Disability 282.69 182.88 0.00 99.81 35.31
502070 Employee Assistance Prgm 44.40 22.07 0.00 22.33 50.29
503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 166,963.53 98,317.55 0.00 68,645.98 41.11
511010 Advertising 800.00 84.50 0.00 715.50 89.44
511020 Postage 500.00 84.38 0.00 415.62 83.12
512010 Printing 0.00 0.00 0.00 0.00 0.00
512020 Copies 20.00 0.35 0.00 19.65 98.25
512030 Photographic Supplies 20.00 0.00 0.00 20.00 100.00
513010 Office Supplies 1,800.00 157.11 224.90 1,417.99 78.78
514030 Small Tools 50.00 0.00 0.00 50.00 100.00
515030 Insect Control 0.00 0.00 0.00 0.00 0.00
515040 First Aid Supplies 30.00 0.00 0.00 30.00 100.00
517010 Operational Supplies 1,800.00 191.13 0.00 1,608.87 89.38
E10 Materials & Supplies 5,020.00 517.47 224.90 4,277.63 85.21
520030 Dues And Publications 880.00 565.90 0.00 314.10 35.69
520050 Meeting And Conferences 400.00 255.00 0.00 145.00 36.25
520070 Training And Education 400.00 99.00 0.00 301.00 75.25
521040 Medical Claimsservices 100.00 0.00 0.00 100.00 100.00
522020 Professional Services 4,224.90 0.00 0.00 4,224.90 100.00
523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00
524020 Recycle Collectprocess 1,000.00 0.00 0.00 1,000.00 100.00
524025 Glass Recycling 6,247.82 2,837.82 3,410.00 0.00 0.00
524026 Household Hazardous Waste 16,000.00 0.00 0.00 16,000.00 100.00
524027 Portable Recycling 0.00 0.00 0.00 0.00 0.00
524028 Misc Recycling 7,752.18 5,650.25 0.00 2,101.93 27.11
524030 Compost Services 212,000.00 106,000.02 0.00 105,999.98 50.00
529010 Special Events 0.00 0.00 0.00 0.00 0.00
529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 249,004.90 115,407.99 3,410.00 130,186.91 52.28
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
540060 Cemetery Maintenance 22,956.42 9,463.40 13,370.00 123.02 0.54
GL - Trial Balance by Acct Type (05/20/2013 - 10:09 AM)Page 27
Sort Level Description Budget YTD Actual Encumbered Remaining Budget %
UncollectedAvailable
541030 Vehicle Wash 1,290.00 642.00 0.00 648.00 50.23
546010 Clothing Expense 520.00 160.00 0.00 360.00 69.23
547010 Equipment Maintenance 80.00 0.00 0.00 80.00 100.00
547020 Maintenance Agreements 1,018.68 529.31 388.41 100.96 9.91
547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00
E25 Repairs & Maintenance 25,865.10 10,794.71 13,758.41 1,311.98 5.07
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 225,037.72 17,393.31 205,742.50 45.91
535 Public Works-Central Maintenan
501020 Salaries 343,750.20 178,874.62 0.00 164,875.58 47.96
501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00
501050 Parttime(wo Benefits)7,400.00 3,378.28 0.00 4,021.72 54.35
501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00
501090 Overtime 1,500.00 1,603.31 0.00 -103.31 -6.89
501095 Overtime Straight Pay 500.00 63.14 0.00 436.86 87.37
502010 Social Security 27,395.62 13,143.70 0.00 14,251.92 52.02
502020 Group Health Insurance 70,056.00 40,186.18 0.00 29,869.82 42.64
502030 Retirement 61,498.90 33,886.10 0.00 27,612.80 44.90
502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
502050 Life Insurance 600.00 300.28 0.00 299.72 49.95
502060 Long Term Disability 848.09 466.29 0.00 381.80 45.02
502070 Employee Assistance Prgm 177.60 88.31 0.00 89.29 50.28
503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 513,726.41 271,990.21 0.00 241,736.20 47.06
511010 Advertising 80.00 0.00 0.00 80.00 100.00
511020 Postage 300.00 11.66 0.00 288.34 96.11
512020 Copies 0.70 0.70 0.00 0.00 0.00
513010 Office Supplies 1,899.30 432.82 0.00 1,466.48 77.21
514011 Gas Oil & Antifreeze 0.00 0.00 0.00 0.00 0.00
514030 Small Tools 9,000.00 3,609.71 0.00 5,390.29 59.89
517010 Operational Supplies 9,100.00 7,405.35 0.00 1,694.65 18.62
E10 Materials & Supplies 20,380.00 11,460.24 0.00 8,919.76 43.77
520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00
520050 Meeting And Conferences 400.00 24.00 0.00 376.00 94.00
520070 Training And Education 1,000.00 0.00 0.00 1,000.00 100.00
521040 Medical Claimsservices 430.00 0.00 0.00 430.00 100.00
523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00
524010 Trash Collections 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 1,830.00 24.00 0.00 1,806.00 98.69
531010 Electricity 6,050.00 3,324.63 0.00 2,725.37 45.05
533010 Natural Gas 6,950.00 6,331.38 0.00 618.62 8.90
GL - Trial Balance by Acct Type (05/20/2013 - 10:09 AM)Page 28
Sort Level Description Budget YTD Actual Encumbered Remaining Budget %
UncollectedAvailable
534010 Telephone 320.00 0.00 0.00 320.00 100.00
535010 Water 715.00 668.15 0.00 46.85 6.55
E20 Utilities 14,035.00 10,324.16 0.00 3,710.84 26.44
540010 Building & Grounds Maint.9,000.00 3,834.10 100.00 5,065.90 56.29
541010 Veh & Equip Parts Etc 405,000.00 158,225.52 0.00 246,774.48 60.93
546010 Clothing Expense 7,000.00 4,424.43 0.00 2,575.57 36.79
547010 Equipment Maintenance 3,000.00 2,119.56 0.00 880.44 29.35
547020 Maintenance Agreements 4,000.00 1,009.60 52.80 2,937.60 73.44
547030 Radio Maintenance 500.00 0.00 0.00 500.00 100.00
E25 Repairs & Maintenance 428,500.00 169,613.21 152.80 258,733.99 60.38
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 463,411.82 152.80 514,906.79 52.62
540 Public Works-Admin
501020 Salaries 189,536.40 102,075.39 0.00 87,461.01 46.14
501090 Overtime 0.00 0.00 0.00 0.00 0.00
501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00
502010 Social Security 16,164.30 7,459.06 0.00 8,705.24 53.85
502020 Group Health Insurance 23,278.50 12,158.53 0.00 11,119.97 47.77
502030 Retirement 37,228.60 18,916.82 0.00 18,311.78 49.19
502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
502050 Life Insurance 410.00 167.73 0.00 242.27 59.09
502060 Long Term Disability 524.46 222.84 0.00 301.62 57.51
502070 Employee Assistance Prgm 66.60 33.11 0.00 33.49 50.29
E05 Personnel Services 267,208.86 141,033.48 0.00 126,175.38 47.22
511010 Advertising 400.00 0.00 0.00 400.00 100.00
511020 Postage 230.00 11.48 0.00 218.52 95.01
512010 Printing 1,630.00 0.00 0.00 1,630.00 100.00
512020 Copies 100.00 0.07 0.00 99.93 99.93
513010 Office Supplies 1,100.00 206.17 0.00 893.83 81.26
514040 Food 250.00 0.00 0.00 250.00 100.00
517010 Operational Supplies 1,400.00 4.99 0.00 1,395.01 99.64
E10 Materials & Supplies 5,110.00 222.71 0.00 4,887.29 95.64
520030 Dues And Publications 1,300.00 363.50 0.00 936.50 72.04
520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00
520070 Training And Education 2,400.00 323.00 0.00 2,077.00 86.54
522020 Professional Services 900.00 163.15 0.00 736.85 81.87
527010 Comm Serv Projects 1,000.00 85.35 0.00 914.65 91.47
E15 Contractual Services 5,600.00 935.00 0.00 4,665.00 83.30
534010 Telephone 924.00 0.00 0.00 924.00 100.00
E20 Utilities 924.00 0.00 0.00 924.00 100.00
GL - Trial Balance by Acct Type (05/20/2013 - 10:09 AM)Page 29
Sort Level Description Budget YTD Actual Encumbered Remaining Budget %
UncollectedAvailable
547020 Maintenance Agreements 930.00 471.24 388.41 70.35 7.56
E25 Repairs & Maintenance 930.00 471.24 388.41 70.35 7.56
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 142,662.43 388.41 136,722.02 48.87
541 Public Works-Engineering
501020 Salaries 742,215.90 415,033.10 0.00 327,182.80 44.08
501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00
501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00
501060 Seasonal Salaries 2,000.00 993.75 0.00 1,006.25 50.31
501080 Step-up Pay 0.00 0.00 0.00 0.00 0.00
501090 Overtime 500.00 0.00 0.00 500.00 100.00
501095 Overtime Straight Pay 500.00 0.00 0.00 500.00 100.00
502010 Social Security 57,855.03 30,312.22 0.00 27,542.81 47.61
502020 Group Health Insurance 102,005.55 54,501.88 0.00 47,503.67 46.57
502030 Retirement 129,184.51 77,913.42 0.00 51,271.09 39.69
502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
502050 Life Insurance 1,299.69 704.21 0.00 595.48 45.82
502060 Long Term Disability 1,819.00 1,060.92 0.00 758.08 41.68
502070 Employee Assistance Prgm 275.79 154.54 0.00 121.25 43.96
503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 1,037,655.47 580,674.04 0.00 456,981.43 44.04
511010 Advertising 1,400.00 278.25 0.00 1,121.75 80.13
511020 Postage 1,500.00 289.16 0.00 1,210.84 80.72
512010 Printing 100.00 31.00 0.00 69.00 69.00
512020 Copies 99.65 110.08 0.00 -10.43 -10.47
512030 Photographic Supplies 175.35 0.00 0.00 175.35 100.00
513010 Office Supplies 8,000.00 1,650.73 0.00 6,349.27 79.37
514030 Small Tools 500.00 469.15 0.00 30.85 6.17
514040 Food 150.00 33.60 0.00 116.40 77.60
515040 First Aid Supplies 50.00 0.00 0.00 50.00 100.00
515070 Const & Inspect Supplies 2,000.00 346.40 0.00 1,653.60 82.68
515080 Surveying Supplies 2,000.00 664.52 0.00 1,335.48 66.77
517010 Operational Supplies 1,150.00 339.75 0.00 810.25 70.46
E10 Materials & Supplies 17,125.00 4,212.64 0.00 12,912.36 75.40
520030 Dues And Publications 4,000.00 3,279.77 0.00 720.23 18.01
520050 Meeting And Conferences 1,000.00 0.00 0.00 1,000.00 100.00
520070 Training And Education 2,500.00 118.00 0.00 2,382.00 95.28
520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00
521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00
522020 Professional Services 4,000.00 96.00 0.00 3,904.00 97.60
E15 Contractual Services 11,500.00 3,493.77 0.00 8,006.23 69.62
GL - Trial Balance by Acct Type (05/20/2013 - 10:09 AM)Page 30
Sort Level Description Budget YTD Actual Encumbered Remaining Budget %
UncollectedAvailable
534010 Telephone 1,650.00 225.14 0.00 1,424.86 86.36
E20 Utilities 1,650.00 225.14 0.00 1,424.86 86.36
541020 Veh Maintenance 960.00 0.00 0.00 960.00 100.00
541030 Vehicle Wash 320.00 480.00 0.00 -160.00 -50.00
546010 Clothing Expense 1,000.00 258.39 0.00 741.61 74.16
547010 Equipment Maintenance 1,480.00 588.45 0.00 891.55 60.24
547020 Maintenance Agreements 17,000.00 7,761.40 785.49 8,453.11 49.72
547030 Radio Maintenance 200.00 0.00 0.00 200.00 100.00
E25 Repairs & Maintenance 20,960.00 9,088.24 785.49 11,086.27 52.89
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
576031 Misc Stormwater Projects 0.00 0.00 0.00 0.00 0.00
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 597,693.83 785.49 490,411.15 45.04
542 Public Works-Street
501020 Salaries 1,117,853.58 582,989.71 0.00 534,863.87 47.85
501060 Seasonal Salaries 1,964.69 2,239.82 0.00 -275.13 -14.00
501070 Stand-by Plan 4,081.31 2,272.00 0.00 1,809.31 44.33
501090 Overtime 20,000.00 16,593.08 0.00 3,406.92 17.03
501095 Overtime Straight Pay 2,000.00 220.71 0.00 1,779.29 88.96
502010 Social Security 91,487.54 45,009.36 0.00 46,478.18 50.80
502020 Group Health Insurance 177,578.38 84,309.34 0.00 93,269.04 52.52
502030 Retirement 201,158.04 107,623.48 0.00 93,534.56 46.50
502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
502050 Life Insurance 1,953.57 958.78 0.00 994.79 50.92
502060 Long Term Disability 2,741.84 1,478.39 0.00 1,263.45 46.08
502070 Employee Assistance Prgm 560.12 287.00 0.00 273.12 48.76
503010 Awards Program 450.00 335.00 0.00 115.00 25.56
503020 Unemployment Compensation 250.00 247.36 0.00 2.64 1.06
E05 Personnel Services 1,622,079.07 844,564.03 0.00 777,515.04 47.93
511010 Advertising 300.00 238.00 0.00 62.00 20.67
511020 Postage 150.00 112.79 0.00 37.21 24.81
512010 Printing 100.00 0.00 0.00 100.00 100.00
512020 Copies 0.35 27.23 0.00 -26.88 -7,680.00
513010 Office Supplies 2,000.00 982.01 0.00 1,017.99 50.90
514020 Chemicals 50,000.00 27,092.28 0.00 22,907.72 45.82
514030 Small Tools 9,000.00 3,905.29 0.00 5,094.71 56.61
514040 Food 1,385.38 1,294.61 0.00 90.77 6.55
515010 Stormwater Material 17,500.00 11,566.46 0.00 5,933.54 33.91
515020 Street Materials 253,324.00 84,171.98 0.00 169,152.02 66.77
GL - Trial Balance by Acct Type (05/20/2013 - 10:09 AM)Page 31
Sort Level Description Budget YTD Actual Encumbered Remaining Budget %
UncollectedAvailable
515040 First Aid Supplies 500.00 40.55 0.00 459.45 91.89
515060 Weed Control 2,000.00 167.88 0.00 1,832.12 91.61
515070 Const & Inspect Supplies 400.00 0.00 0.00 400.00 100.00
517010 Operational Supplies 4,500.00 2,649.76 0.00 1,850.24 41.12
E10 Materials & Supplies 341,159.73 132,248.84 0.00 208,910.89 61.24
520030 Dues And Publications 346.00 346.00 0.00 0.00 0.00
520050 Meeting And Conferences 489.27 0.00 0.00 489.27 100.00
520070 Training And Education 1,000.00 269.00 0.00 731.00 73.10
521040 Medical Claimsservices 400.00 0.00 0.00 400.00 100.00
522020 Professional Services 14,956.00 10,946.00 1,760.00 2,250.00 15.04
523010 Equipment Rentlease 1,000.00 75.00 0.00 925.00 92.50
524010 Trash Collections 4,983.00 589.60 0.00 4,393.40 88.17
529070 Street Light Installation 1,676.00 0.00 1,676.00 0.00 0.00
E15 Contractual Services 24,850.27 12,225.60 3,436.00 9,188.67 36.98
531010 Electricity 49,500.00 13,926.50 0.00 35,573.50 71.87
531020 Street Lights 527,900.00 288,069.32 0.00 239,830.68 45.43
533010 Natural Gas 11,385.00 12,343.35 0.00 -958.35 -8.42
534010 Telephone 4,950.00 283.55 0.00 4,666.45 94.27
535010 Water 3,300.00 3,258.43 0.00 41.57 1.26
E20 Utilities 597,035.00 317,881.15 0.00 279,153.85 46.76
540010 Building & Grounds Maint.7,000.00 3,975.50 100.00 2,924.50 41.78
541030 Vehicle Wash 6,620.00 3,312.00 0.00 3,308.00 49.97
542010 Repairs - Stop Lights 10,000.00 5,985.76 0.00 4,014.24 40.14
542030 Signs & Marking Paint 30,000.00 6,373.64 20,920.95 2,705.41 9.02
546010 Clothing Expense 12,000.00 4,480.38 0.00 7,519.62 62.66
547010 Equipment Maintenance 3,100.00 1,275.70 0.00 1,824.30 58.85
547020 Maintenance Agreements 1,400.00 279.60 30.00 1,090.40 77.89
547030 Radio Maintenance 100.00 55.00 0.00 45.00 45.00
E25 Repairs & Maintenance 70,220.00 25,737.58 21,050.95 23,431.47 33.37
572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00
572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00
573050 Neighborhood Impr Projs 0.00 0.00 0.00 0.00 0.00
573060 Sidewalk Rep Program 0.00 0.00 0.00 0.00 0.00
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,655,344.07 1,332,657.20 24,486.95 1,298,199.92 48.89
700 Transfers & Subsidies
590050 Transfer To Tif Fund 4,000.00 1,682.28 0.00 2,317.72 57.94
590070 Airport Matching 171,635.85 85,817.94 0.00 85,817.91 50.00
590075 Transit Matching 689,630.76 397,138.08 0.00 292,492.68 42.41
590080 Transfer To Amb Serv 0.00 0.00 0.00 0.00 0.00
GL - Trial Balance by Acct Type (05/20/2013 - 10:09 AM)Page 32
Sort Level Description Budget YTD Actual Encumbered Remaining Budget %
UncollectedAvailable
E80 Transfers Out 865,266.61 484,638.30 0.00 380,628.31 43.99
700 Transfers & Subsidies 865,266.61 484,638.30 0.00 380,628.31 43.99
900 CapitalVehicleEquipment
571010 Capvehclequip-city Admin 0.00 0.00 0.00 0.00 0.00
571020 Capvhcleqp-code Enf-adm 0.00 0.00 0.00 0.00 0.00
571030 Capvhcleqp-bldg Regs 0.00 0.00 0.00 0.00 0.00
571040 Capvhcleqp-envir Health 0.00 0.00 0.00 0.00 0.00
571050 Capvhcleqp-p & Transp-adm 0.00 0.00 0.00 0.00 0.00
571060 Capvhcleqp-pub Works-adm 0.00 0.00 0.00 0.00 0.00
571070 Capvhcleqp-engineering 0.00 0.00 0.00 0.00 0.00
571080 Capvhcleqp-street 96,371.20 0.00 96,371.20 0.00 0.00
571090 Capvhcleqp-police 161,268.00 99.00 161,268.00 -99.00 -0.06
571100 Capvhcleqp-fire 0.00 0.00 0.00 0.00 0.00
571110 Capvhcleqp-animal Rescue 0.00 0.00 0.00 0.00 0.00
571120 Capvhcleqp-central Maint 0.00 0.00 0.00 0.00 0.00
571130 Capvhcleqp-airport 55,318.00 0.00 54,398.00 920.00 1.66
571140 Capvhcleqp-contingency 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 312,957.20 99.00 312,037.20 821.00 0.26
900 CapitalVehicleEquipment 312,957.20 99.00 312,037.20 821.00 0.26
Expense Expense 33,124,070.23 16,422,000.37 793,020.81 15,909,049.05 48.03
GL - Trial Balance by Acct Type (05/20/2013 - 10:09 AM)Page 33
FU
N
D
BA
L
A
N
C
E
CA
L
C
U
L
A
T
I
O
N
FY
E
12
Un
a
s
s
i
g
n
e
d
Ge
n
e
r
a
l
Fu
n
d
Ba
l
a
n
c
e
4
,
6
8
1
,
3
1
6
.
0
0
$
Pe
r
Au
d
i
t
e
d
CA
F
R
Re
a
p
p
r
o
p
r
i
a
t
i
o
n
(
5
0
,
4
1
7
.
1
6
)
$
Co
l
e
Co
u
n
t
y
Em
e
r
g
e
n
c
y
Si
r
e
n
Re
a
p
p
r
o
p
r
i
a
t
i
o
n
(
1
0
0
,
0
0
0
.
0
0
)
$
Pr
o
f
Sv
c
s
to
Co
l
u
m
b
i
a
Ai
r
p
o
r
t
Re
a
p
p
r
o
p
r
i
a
t
i
o
n
(
8
1
5
,
0
0
0
.
0
0
)
$
Fi
r
e
De
p
t
ON
E
TI
M
E
PU
C
H
A
S
E
S
Su
p
p
l
e
m
e
n
t
a
l
Ap
p
r
o
p
r
i
a
t
i
o
n
(
5
,
0
0
0
.
0
0
)
$
Es
t
a
b
l
i
s
h
UH
C
De
d
u
c
t
i
b
l
e
Se
l
f
In
s
u
r
a
n
c
e
Im
p
r
e
s
t
Fu
n
d
Su
p
p
l
e
m
e
n
t
a
l
Ap
p
r
o
p
r
i
a
t
i
o
n
(
4
0
,
0
0
0
.
0
0
)
$
El
e
c
t
i
o
n
Ex
p
e
n
s
e
s
Es
t
i
m
a
t
e
d
Cu
r
r
e
n
t
Fu
n
d
Ba
l
a
n
c
e
3
,
6
7
0
,
8
9
8
.
8
4
$
Procedures for Applying For and Accepting Grants PLUS Responsibilities
after Acceptance
I. APPLICATION
A. Prior to applying for a grant, the Council MUST approve by resolution any grant application
filed on behalf of the City.
1. The Department applying for the grant must complete the “Resolution Grant
Application Form”, herein attached as Exhibit A.
2. The Department applying for the grant must take necessary steps with the City Clerk
to get the “Resolution Grant Application Form” added to the Council Agenda.
II. ACCEPTANCE
A. For Awards in excess of $2,000
1. Upon award of the grant to the City, the Council MUST approve on the Consent
Agenda any grant funds being accepted on behalf of the City.
a) The Department wishing to accept the grant funds must complete the
“Memo for Grant Acceptance Over $2,000”, herein attached as Exhibit B, which
should include at least the following information:
(1) The name of the grantor
(2) The amount of the grant
(3) The purpose of the grant
(4) Any matching requirements or future obligations tied to acceptance
of the grant
(5) The CFDA number
(6) The grant award number (if any)
(7) The revenue and expense accounts to be amended
b) The Department wishing to accept the grant funds must forward to the Chief
Accountant in the Finance Department the following documents:
(1) A copy of the document awarding the grant
(2) The completed “Memo for Grant Acceptance Over $2,000”
DR
A
F
T
c) The Finance Department will review the “Memo for Grant Acceptance Over
$2,000” to verify the account numbers to be amended are correct. They will then
forward the following documents to the City Clerk to add the item to the
Consent Agenda for the next regularly scheduled Council Meeting:
(1) A copy of the document awarding the grant
(2) The completed “Memo for Grant Acceptance Over $2,000”
B. For Awards under $2,000
1. Upon award of the grant to the City, the City Administrator MUST approve any grant
funds being accepted on behalf of the City.
a) The Department wishing to accept the grant funds must complete the
“Memo for Grant Acceptance Under $2,000”, herein attached as Exhibit C, which
should include at least the following information:
(1) The name of the grantor
(2) The amount of the grant
(3) The purpose of the grant
(4) Any matching requirements or future obligations tied to acceptance
of the grant
(5) The CFDA number
(6) The grant award number (if any)
(7) The revenue and expense accounts to be amended
b) The Department wishing to accept the grant funds must forward to the Chief
Accountant in the Finance Department the following documents:
(1) A copy of the document awarding the grant
(2) The completed “Memo for Grant Acceptance Under $2,000”
c) The Finance Department will review the “Memo for Grant Acceptance” to
verify the account numbers to be amended are correct. They will then forward
the following documents to the City Administrator for approval:
(1) A copy of the document awarding the grant
(2) The completed “Memo for Grant Acceptance Under $2,000”
DR
A
F
T
III. RESPONSIBILITIES AFTER ACCEPTANCE
A. Department Accepting Grant Funds
1. Once grant funds are accepted, the Director of the accepting department MUST
designate a Grant Administrator for each accepted grant who will be responsible for the
grant and accountable to the City Administrator.
2. The Grant Administrator MUST provide to the Accountant in the Finance
Department the complete grant agreement.
3. The Grant Administrator MUST complete reimbursement requests on a regular
basis—monthly requests are preferred, however requests should be no less than
quarterly.
a) ALL PAYMENTS of grant funds received MUST be forwarded to the
Accountant in the Finance Department for deposit.
4. At the time of each reimbursement request, the Grant Administrator MUST provide
to the Accountant in the Finance Department the following documents:
a) The reimbursement request form
b) Supporting documentation for each item being requested for
reimbursement. This should include but is not limited to the following:
(1) General Ledger Detail Reports for accounts that the expenses were
originally coded to
(2) Copies of Invoices
(3) Copies of Timesheets
B. Finance Department
1. Once the grant funds are accepted, the Finance Department will complete a Budget
Amendment to the accounts specified on the “Memo for Grant Acceptance”. As no
grant revenues are being recognized in the initial budget process, this step is necessary
to not only recognize the revenue but to allocate additional budgeted funds to the
appropriate expense accounts.
2. When the Finance Department receives the reimbursement requests with
supporting documentation from the Grant Administrator, the Accountant will compare
the supporting documents to the general ledger and update the Schedule of
Expenditures of Federal Awards.
DR
A
F
T
RESOLUTION
RS20___-___
A RESOLUTION AUTHORIZING THE CITY OF JEFFERSON TO APPLY FOR THE
[insert name of grant] GRANT.
WHEREAS, the City of Jefferson has the opportunity to apply for the [insert name of
grant] grant, and
WHEREAS, the purpose of the grant is [explain purpose of the grant], and
WHEREAS, the grant, if awarded, would provide up to $[amount of grant] for the City
for the purpose stated above, and
WHEREAS, the grant would require the City to [explain match or obligation]
WHEREAS, receiving said grant would benefit the City.
NOW THEREFORE BE IT RESOLVED, that the City Council of Jefferson City, Missouri
supports and authorizes the City Administrator, or his designee to execute and submit the
necessary application to obtain funding for the [insert name of grant] Grant.
Adopted this ____ day of ___________, 2013.
_____________________________
Mayor
ATTEST: APPROVED AS TO FORM:
_____________________________ _____________________________
City Clerk City Counselor
EXHIBIT A
DR
A
F
T
Memorandum
______________________________________________________________________________
To: City Council
From: Nathan Nickolaus
Re: Grant Acceptance Over $2,000
For: Consent Agenda
______________________________________________________________________________
Pursuant to Section 2-74 of the City Code, I request authority to accept the following Grant:
The name of the grantor:
The amount of the grant:
$
The purpose of the grant:
Any matching requirements or future
obligations tied to acceptance of the grant:
CFDA#:
Grant Award # (if any):
City Department Responsible:
Employee assigned as Grant
Administrator:
Revenue account # to be amended:
Expense account # to be amended:
Please NOTE: Upon Approval of the Consent Agenda, the City Administrator may, on behalf of the city
execute any documents necessary for accepting the grant and amend the budget to reflect the acceptance of
such revenue, and amend the budget to reflect equivalent expenses so as to accomplish the purpose of such
funds.
For Finance Department Use only:
Approved on the Consent Agenda this _______ day of _______, 20_____
EXHIBIT B
DR
A
F
T
Memorandum
______________________________________________________________________________
To: Nathan Nickolaus
From: [Insert Department Name]
Re: Grant Acceptance under $2,000
For: Your Approval
______________________________________________________________________________
Pursuant to Section 2-290(H) of the City Code, I request acceptance of the following Grant:
The name of the grantor:
The amount of the grant:
$
The purpose of the grant:
Any matching requirements or future
obligations tied to acceptance of the grant:
CFDA#:
Grant Award # (if any):
City Department Responsible:
Employee assigned as Grant
Administrator:
Revenue account # to be amended:
Expense account # to be amended:
Approved this _______ day of _______, 20_____
_____________________________________________
City Aministrator Signature
EXHIBIT C
DR
A
F
T
BILL NO. [Bill No.]
SPONSORED BY COUNCILMAN _______________________
ORDINANCE NO.
AN ORDINANCE OF THE CITY OF JEFFERSON, MISSOURI, ESTABLISHING
PROCEDURES FOR APPLYING FOR AND ACCEPTING GRANTS.
BE IT ENACTED BY THE COUNCIL OF THE CITY OF JEFFERSON, MISSOURI, AS
FOLLOWS:
Section 1. Chapter 2 (Administration) is amended by the addition of a new
Section 74 (Grants) as follows:
Sec. 2-74. Grants.
A. Application. Prior to application for any grant, the Council shall approve by Resolution any grant
application filed on behalf of the City.
B. Acceptance.
1. Upon award of the grant to the City, the City Administrator shall submit to the City Council for
approval on the Consent Agenda a copy of the document awarding the grant and a memo which
includes at least the following information:
a. The name of the grantor;
b. The amount of the grant;
c. The purpose of the grant;
d. Any matching requirements or future obligations tied to acceptance of the grant;
e. CFDA#:
f. Grant Award # (if any):
g. Revenue and Expense account to be amended.
2. Upon Approval of the Consent Agenda on which these documents appeared, the City
Administrator may, on behalf of the city execute any documents necessary for accepting the grant
and amend the budget to reflect the acceptance of such revenue, and amend the budget to reflect
equivalent expenses so as to accomplish the purpose of such funds.
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
Tax Period
Due Date to
City Total Lodging Tax JCCVB (3/7)
JCCVB/Convention
Center Fund (4/7)
May‐116/20/1191,258.41 38,328.53 51,104.71
Jun‐117/20/11101,479.82 42,621.54 56,828.68
Jul‐118/20/1188,392.47 37,124.82 49,499.80
Aug‐119/20/1173,144.02 30,720.48 40,960.66
Sep‐1110/20/11103,618.61 43,519.80 58,026.44
Oct‐1111/20/11105,531.99 44,323.44 59,097.91
Nov‐1112/20/1166,556.88 27,953.89 37,271.85
Dec‐111/20/1252,204.97 21,926.07 29,234.80
Jan‐122/20/1265,645.72 27,571.20 36,761.61
Feb‐123/20/1285,143.89 35,760.45 47,680.56
Mar‐124/20/1281,904.23 34,399.77 45,866.38
Apr‐125/20/12103,406.71 43,430.82 57,907.76
May‐126/20/1289,713.24 37,679.58 50,239.40
Jun‐127/20/1286,753.72 36,436.56 48,582.08
Jul‐128/20/1289,904.69 37,759.97 50,346.63
Aug‐129/20/1276,708.71 32,217.66 42,956.88
Sep‐1210/20/12109,335.16 45,920.77 61,227.69
Oct‐1211/20/12109,059.34 45,804.92 61,073.23
Nov‐1312/20/1269,756.75 29,297.84 39,063.77
Dec‐121/20/1355,126.67 23,153.20 30,870.94
Jan‐132/20/1384,295.92 35,404.29 47,205.71
Feb‐133/20/1384,199.16 35,363.65 47,151.53
Mar‐134/20/1397,213.16 40,829.53 54,439.37
Total1,970,354.24 827,548.78 1,103,398.39
average monthly amount for Convention Center Fund47,973.84
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% 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, de veloper’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 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. 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 incen tive 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 applicable 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 Missouri (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% of total project costs. However, project
assistance above 25% 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 finan cial 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 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 short
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 demonstrat e 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 been 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 that, 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 revie ws, 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 associat ed
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 th e 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 op erates 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 benefi t 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 a ppointed 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 petitioners 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 befo re
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 app lications for the formation of a TDD within the City’s
jurisdictional boundaries. In general, applications that meet each of the evaluation criteria 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 Circuit 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 th e 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 property 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 again st property owners in the district are apportioned 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