year to date trial - city.urbana.il.us2017-2018_detail_trial… · capital repl & improv - assets...

GL40A RUN DATE 9/07/18 GENERAL LEDGER DETAIL TRIAL BALANCE FOR PERIOD 7/01/2017 TO 2/01/2018 PAGE 1 PERIOD 7/01/2017 TO 2/01/2018 CITY OF URBANA A09 CAPITAL REPL. & IMPROVEMENT FUND

GL ACCT NO TRANSCO DP MAJ MIN DATE SEQNO VENDOR DESCRIPTION CURRENT MTD DEBIT AMT CREDIT AMT CURRENT YTD

CAPITAL REPL & IMPROV - ASSETSA09 0 0000-0001 BUSEY REGULAR CHECKING .00 .00 .00 * .00 *

A09 0 0000-0002 BUSEY MONEY MARKET .00 .00 .00 * .00 *

A09 0 0000-0006 ILLINOIS FUNDS MONEY MARKET .00 .00 .00 * .00 *

A09 0 0000-0011 INVESTMENTS - TIME DEPOSITS .00 .00 .00 * .00 *

A09 0 0000-0013 INVESTMENTS, MARKET CHANGE .00 .00 .00 * .00 *

A09 0 0000-0025 ACCOUNTS RECEIVABLE .00 .00 .00 * .00 *

A09 0 0000-0027 GRANT RECEIVABLE 14,443.94 .00 .00 * 14,443.94 *

A09 0 0000-0028 DUE IDOT-SIGNAL MAINT .00 .00 .00 * .00 *

A09 0 0000-0033 DUE FROM CHAMPAIGN BONEYARD .00 .00 .00 * .00 *

A09 0 0000-0099 DUE FROM TREASURY FUND 2,656,634.57 7/12/17 00322 FOR CHECKS WRITTEN 07/12/2017 36,145.02 7/14/17 01071 FOR CHECKS WRITTEN 07/14/2017 9,175.00 7/21/17 01483 FOR CHECKS WRITTEN 07/21/2017 29,171.38 7/28/17 02939 FOR CHECKS WRITTEN 07/28/2017 450.00 7/31/17 14202 INTEREST 7/31/2017 2,285.12 JUL 72,656.28-* 2,583,978.29

8/08/17 03925 AUGUST REVENUE 8/8/17 2.00 8/11/17 04411 FOR CHECKS WRITTEN 08/11/2017 29.00 8/11/17 04553 FOR CHECKS WRITTEN 08/11/2017 32,330.21 8/18/17 05008 FOR CHECKS WRITTEN 08/18/2017 43,831.60 8/18/17 05204 FOR CHECKS WRITTEN 08/18/2017 21,885.24 8/25/17 06206 FOR CHECKS WRITTEN 08/25/2017 53,197.72



A09 0 0000-0099 DUE FROM TREASURY FUND (CONTINUED) 8/31/17 14266 INTEREST 8/31/2017 1,341.79 AUG 149,929.98-* 2,434,048.31

9/01/17 06740 FOR CHECKS WRITTEN 09/01/2017 250.00 9/08/17 07666 FOR CHECKS WRITTEN 09/08/2017 14,326.38 9/15/17 08166 FOR CHECKS WRITTEN 09/15/2017 5,480.79 9/22/17 09235 FOR CHECKS WRITTEN 09/22/2017 72,171.03 9/25/17 09527 SEPTEMBER REVENUE 9/25/2017 5,721.66 9/29/17 09854 FOR CHECKS WRITTEN 09/29/2017 72,257.38 9/30/17 13858 Q1 TFR GF TO A09 182,033.75 9/30/17 14330 INTEREST 9/30/2017 2,733.97 SEP 26,003.80 * 2,460,052.11

10/06/17 10353 FOR CHECKS WRITTEN 10/06/2017 240,280.48 10/09/17 10774 CITY PAY LRC BILL AUG 2017 54.00 10/13/17 11822 FOR CHECKS WRITTEN 10/13/2017 584,795.89 10/27/17 13510 FOR CHECKS WRITTEN 10/27/2017 2,320.54 10/31/17 24024 INTEREST 10/31/2017 561.76 OCT 826,889.15-* 1,633,162.96

11/03/17 15027 FOR CHECKS WRITTEN 11/03/2017 9,799.93 11/09/17 15510 FOR CHECKS WRITTEN 11/09/2017 25,547.60 11/14/17 16388 NOVEMBER REVENUE 11/14/17 9,735.31 11/17/17 16543 FOR CHECKS WRITTEN 11/17/2017 166,327.36 11/22/17 16990 FOR CHECKS WRITTEN 11/22/2017 10,655.45 11/30/17 24090 INTEREST 11/30/2017 1,863.26 NOV 200,731.77-* 1,432,431.19

12/08/17 18774 FOR CHECKS WRITTEN 12/08/2017 61,691.76 12/15/17 19219 FOR CHECKS WRITTEN 12/15/2017 15,910.68 12/22/17 20652 FOR CHECKS WRITTEN 12/22/2017 2,938.12 12/29/17 21597 FOR CHECKS WRITTEN 12/29/2017 13,906.07 12/31/17 23488 Q2 TFR FROM GF TO A09 182,033.75 12/31/17 24588 INTEREST 12/31/2017 883.36 DEC 88,470.48 * 1,520,901.67

1/05/18 21979 FOR CHECKS WRITTEN 01/05/2018 24,988.43 1/12/18 22730 FOR CHECKS WRITTEN 01/12/2018 498.25 1/19/18 23270 FOR CHECKS WRITTEN 01/19/2018 343.95 1/19/18 23575 CITY PAY LRC BILL NOVEMBER 25.00 1/26/18 24404 FOR CHECKS WRITTEN 01/26/2018 42,178.08 JAN 68,033.71-* 389,195.73 1,592,962.34 * 1,452,867.96 *

MAJOR TOTALS 2,671,078.51 * 389,195.73 1,592,962.34 * 1,467,311.90 *



CAPITAL REPL & IMPROV - LIABSA09 0 0001-0100 DUE TO/FROM OTHER FUNDS .00 .00 .00 * .00 *

A09 0 0001-0116 ACCOUNTS PAYABLE 126,969.50- 7/14/17 01070 FOR CHECKS WRITTEN 07/14/2017 9,175.00 7/21/17 01482 FOR CHECKS WRITTEN 07/21/2017 29,171.38 JUL 38,346.38 * 88,623.12-

8/11/17 04410 FOR CHECKS WRITTEN 08/11/2017 29.00 8/18/17 05007 FOR CHECKS WRITTEN 08/18/2017 43,831.60 AUG 43,860.60 * 44,762.52-

9/08/17 07665 FOR CHECKS WRITTEN 09/08/2017 14,326.38 SEP 14,326.38 * 96,533.36 .00 * 30,436.14-*

A09 0 0001-0118 MERVIS DEPOSIT 52,640.13- .00 .00 * 52,640.13-*

A09 0 0001-0199 FUND BALANCE-UNRESERVED 2,491,468.88- .00 .00 * 2,491,468.88-*

MAJOR TOTALS 2,671,078.51-* 96,533.36 .00 * 2,574,545.15-*

CAPITAL REPL & IMPROV REVENUEA09 0 0030-0000 TRANSFER - GENERAL FUND .00 9/30/17 13859 Q1 TFR GF TO A09 182,033.75 SEP 182,033.75-* 182,033.75-

12/31/17 23489 Q2 TFR FROM GF TO A09 182,033.75 DEC 182,033.75-* .00 364,067.50 * 364,067.50-*

MAJOR TOTALS .00 * .00 364,067.50 * 364,067.50-*

CAPITAL REPL & IMPROV REVENUEA09 0 0032-0000 TRANSFERS - OTHER FUNDS .00 .00 .00 * .00 *

MAJOR TOTALS .00 * .00 .00 * .00 *



CAPITAL REPL & IMPROV REVENUEA09 0 0035-0000 TRANS. PWOPN SIGN SYSTEM .00 .00 .00 * .00 *

MAJOR TOTALS .00 * .00 .00 * .00 *

CAPITAL REPL & IMPROV REVENUEA09 0 0050-0000 COUNTY REIMB., WINDSOR ENG. .00 .00 .00 * .00 *

MAJOR TOTALS .00 * .00 .00 * .00 *

CAPITAL REPL & IMPROV REVENUEA09 0 0055-0000 UNIV. REIMB. GOODWIN/IL. .00 .00 .00 * .00 *

MAJOR TOTALS .00 * .00 .00 * .00 *

CAPITAL REPL & IMPROV REVENUEA09 0 0058-0000 IDOT REIMB. WILLOW RD. .00 .00 .00 * .00 *

MAJOR TOTALS .00 * .00 .00 * .00 *

CAPITAL REPL & IMPROV REVENUEA09 0 0059-0000 IDOT REIMB WINDSOR RD .00 .00 .00 * .00 *

MAJOR TOTALS .00 * .00 .00 * .00 *

CAPITAL REPL & IMPROV REVENUEA09 0 0060-0000 REIMBURSEMENT - OTHER GOVTS .00 .00 .00 * .00 *

MAJOR TOTALS .00 * .00 .00 * .00 *



CAPITAL REPL & IMPROV REVENUEA09 0 0062-0000 IDOT GRANT, IL130 .00 .00 .00 * .00 *

MAJOR TOTALS .00 * .00 .00 * .00 *

CAPITAL REPL & IMPROV REVENUEA09 0 0070-0000 CARLE REIMB., CHURCH .00 .00 .00 * .00 *

MAJOR TOTALS .00 * .00 .00 * .00 *

CAPITAL REPL & IMPROV REVENUEA09 0 0072-0000 REIMB., ATKINS SIGN .00 .00 .00 * .00 *

MAJOR TOTALS .00 * .00 .00 * .00 *

CAPITAL REPL & IMPROV REVENUEA09 0 0074-0000 MISC. REIMBURSEMENTS .00 .00 .00 * .00 *

MAJOR TOTALS .00 * .00 .00 * .00 *

CAPITAL REPL & IMPROV REVENUEA09 0 0078-0000 STATE SUPPL. GRANT, SIGNAL IMPR .00 .00 .00 * .00 *

MAJOR TOTALS .00 * .00 .00 * .00 *

CAPITAL REPL & IMPROV REVENUEA09 0 0082-0000 IDOT REIMB-SIGNAL MAINT. .00 9/25/17 09528 2ND QTR APR-JUN 2017 5,721.66 SEP 5,721.66-* 5,721.66-

11/14/17 16396 3RD QUARTER 9,735.31 NOV 9,735.31-* .00 15,456.97 * 15,456.97-*

MAJOR TOTALS .00 * .00 15,456.97 * 15,456.97-*



CAPITAL REPL & IMPROV REVENUEA09 0 0090-0000 SALE OF PROPERTY .00 8/08/17 03926 ANNUAL RENTAL 909&911 LINCOLN 2.00 AUG 2.00-* .00 2.00 * 2.00-*

MAJOR TOTALS .00 * .00 2.00 * 2.00-*

CAPITAL REPL & IMPROV REVENUEA09 0 0110-0000 TRANS, TIFS INT. ENGINEERING .00 .00 .00 * .00 *

MAJOR TOTALS .00 * .00 .00 * .00 *

CAPITAL REPL & IMPROV REVENUEA09 0 0112-0000 SAFESCHOOL ROUTE GRANTS .00 .00 .00 * .00 *

MAJOR TOTALS .00 * .00 .00 * .00 *

CAPITAL REPL & IMPROV REVENUEA09 0 0114-0000 STATE GRANT OLYMPIAN DRIVE .00 .00 .00 * .00 *

MAJOR TOTALS .00 * .00 .00 * .00 *

CAPITAL REPL & IMPROV REVENUEA09 0 0116-0000 STATE GRANT/MERVIS PAYMENTS .00 .00 .00 * .00 *

MAJOR TOTALS .00 * .00 .00 * .00 *

CAPITAL REPL & IMPROV REVENUEA09 0 0117-0000 TFR FROM SW UTILITY (A10) .00 .00 .00 * .00 *

MAJOR TOTALS .00 * .00 .00 * .00 *



CAPITAL REPL & IMPROV REVENUEA09 0 0118-0000 MERVIS CONTRIBUTION .00 .00 .00 * .00 *

MAJOR TOTALS .00 * .00 .00 * .00 *

CAPITAL REPL & IMPROV REVENUEA09 0 0120-0000 LOCAL MOTOR FUEL TAX REVENUE .00 .00 .00 * .00 *

MAJOR TOTALS .00 * .00 .00 * .00 *

CAPITAL REPL & IMPROV REVENUEA09 0 0121-0000 OLYMPIAN DR GCFP .00 .00 .00 * .00 *

MAJOR TOTALS .00 * .00 .00 * .00 *

CAPITAL REPL & IMPROV REVENUEA09 0 0122-0000 OLYMPIAN DR STP-U FUNDS .00 .00 .00 * .00 *

MAJOR TOTALS .00 * .00 .00 * .00 *

CAPITAL REPL & IMPROV REVENUEA09 0 0123-0000 BOND ISSUE WINDSOR RD PHILO TO RACE .00 .00 .00 * .00 *

MAJOR TOTALS .00 * .00 .00 * .00 *

A09 0 0125-0000 LANORE/ADAMS/FAIRLAWN PATH .00 .00 .00 * .00 *

MAJOR TOTALS .00 * .00 .00 * .00 *



CAPITAL REPL & IMPROV REVENUEA09 0 0130-0000 INTEREST .00 7/31/17 14203 INTEREST 7/31/2017 2,285.12 JUL 2,285.12-* 2,285.12-

8/31/17 14267 INTEREST 8/31/2017 1,341.79 AUG 1,341.79-* 3,626.91-

9/30/17 14331 INTEREST 9/30/2017 2,733.97 SEP 2,733.97-* 6,360.88-

10/31/17 24025 INTEREST 10/31/2017 561.76 OCT 561.76-* 6,922.64-

11/30/17 24091 INTEREST 11/30/2017 1,863.26 NOV 1,863.26-* 8,785.90-

12/31/17 24589 INTEREST 12/31/2017 883.36 DEC 883.36-* .00 9,669.26 * 9,669.26-*

MAJOR TOTALS .00 * .00 9,669.26 * 9,669.26-*

CAPITAL REPL & IMPROV REVENUEA09 0 0136-0000 SUMP PUMP ROW REIMB. PROGRAM .00 .00 .00 * .00 *

MAJOR TOTALS .00 * .00 .00 * .00 *

CAPITAL REPL & IMPROV REVENUEA09 0 0140-0000 AIRPORT RD WEST EDP FUNDS .00 .00 .00 * .00 *

MAJOR TOTALS .00 * .00 .00 * .00 *

A09 0 0141-0000 AIRPORT RD WEST TARP FUNDS .00 .00 .00 * .00 *

MAJOR TOTALS .00 * .00 .00 * .00 *



ADMINISTRATIONA09 1 0300-0010 TFR TO GEN OP FUND (WINDSOR) .00 .00 .00 * .00 *

A09 1 0300-0012 CITY FACILITY IMPROVEMENTS .00 10/13/17 11809 15889 TRANE U.S. INC A/C UNITS 2,612.94 10/13/17 11810 15889 TRANE U.S. INC FURNACE 621.61 10/13/17 11811 15889 TRANE U.S. INC WATER HEATER 1,515.00 OCT 4,749.55 * 4,749.55

11/22/17 16948 03164 A & R MECHANICAL ASBESTOS ABATEMENT 1,197.53 11/22/17 16949 03164 A & R MECHANICAL FURNACE/H20 HEATER 9,457.92 NOV 10,655.45 * 15,405.00 .00 * 15,405.00 *

A09 1 0300-0014 CONTRACT AUDIT, WINDSOR RD. .00 .00 .00 * .00 *

A09 1 0300-0015 CONTRACT AUDIT WINDSOR ENC. .00 .00 .00 * .00 *

A09 1 0300-0050 TFR TO SUPPL CAP IMPR FUND .00 .00 .00 * .00 *

A09 1 0300-0051 PW COVERED MATERIAL BINS .00 1/05/18 21960 26350 DUCE CONSTRUCTION INCSALT STORAGE 24,850.00 JAN 24,850.00 * 24,850.00 .00 * 24,850.00 *

A09 1 0300-0150 BONEYARD/BRIDGES MAINT. .00 .00 .00 * .00 *

A09 1 0300-0151 BONEYARD MAINT. (ENC.) .00 .00 .00 * .00 *

A09 1 0300-0156 SIGNAL MAINT. IDOT .00 8/25/17 06201 07317 TRAFFIC CONTROL CORPOTRAF SGNL BAT B/UP 4,450.00 AUG 4,450.00 * 4,450.00

11/03/17 14991 05037 CHAMPAIGN SIGNAL & LIKILLARNEY AND LINC 9,799.93 NOV 9,799.93 * 14,249.93 .00 * 14,249.93 *

A09 1 0300-0157 SIGNAL MT. IDOT ENC. .00 .00 .00 * .00 *



A09 1 0300-0160 SUMP PUMP ROW REIMB. PROGRAM .00 .00 .00 * .00 *

A09 1 0300-0161 SUMP PUMP ROW REIMB. ENC. .00 .00 .00 * .00 *

A09 1 0300-0164 TRAFFIC SIGN MGT. SYSTEM ENC. .00 .00 .00 * .00 *

A09 1 0300-0168 STORMWATER UTILITY FEAS. STUDY .00 .00 .00 * .00 *

A09 1 0300-0169 STORMWATER FEE STUDY ENC. .00 .00 .00 * .00 *

MAJOR TOTALS .00 * 54,504.93 .00 * 54,504.93 *

ADMINISTRATIONA09 1 0400-0074 FIRE STATION #2 .00 7/12/17 00318 06614 CHICAGO TITLE COMPANY2201 PHILO ROAD 266.10 7/12/17 00319 09808 ABBAS KAZEMI 2201 PHILO ROAD 33,778.92 7/12/17 00320 15854 EDWIN K. PIRAINO 2201 PHILO ROAD 450.00 7/12/17 00321 08326 RE/MAX REALTY ASSOCIA2201 PHILO ROAD 1,650.00 JUL 36,145.02 * 36,145.02

8/11/17 04486 16714 CHAMPAIGN COUNTY COLL2201 PHILO RD 948.10 AUG 948.10 * 37,093.12 .00 * 37,093.12 *

A09 1 0400-0250 PEDESTRIAN MASTER PLAN .00 12/29/17 21524 03828 CHAMPAIGN COUNTY REGI3/1/17 - 11/30/17 12,874.23 DEC 12,874.23 * 12,874.23 .00 * 12,874.23 *

A09 1 0400-0374 FIRE STATION DIESEL EXHAUST SYSTEM .00 .00 .00 * .00 *

A09 1 0400-0375 MISC TRAFFIC STUDIES .00 12/22/17 20567 11402 SYNCHRONY BANK DRILL BITS 23.94 12/29/17 21553 13427 MIOVISION TECHNOLOGIETRAFFIC COUNT 1,031.84 DEC 1,055.78 * 1,055.78

1/05/18 21942 08885 FIRST NATIONAL BANK OROAD CLEATS/BATT 138.43



A09 1 0400-0375 MISC TRAFFIC STUDIES (CONTINUED) 1/19/18 23214 13427 MIOVISION TECHNOLOGIEINTERSECTION COUNT 343.95 JAN 482.38 * 1,538.16 .00 * 1,538.16 *

A09 1 0400-0410 CD "HOME" CAP. IMPR. TFR .00 .00 .00 * .00 *

A09 1 0400-0411 CD HOME TRANSFER ENC. .00 .00 .00 * .00 *

A09 1 0400-0412 PAVEMENT MGMT SYSTEM .00 .00 .00 * .00 *

A09 1 0400-0420 ROUNDABOUT STUDY ENC. .00 .00 .00 * .00 *

A09 1 0400-0422 PAVEMENT MAINTENANCE .00 9/22/17 09209 11361 OTTO BAUM COMPANY, IN8/14/17 - 8/30/17 72,171.03 9/29/17 09847 09685 VARSITY STRIPING & 8/1/17 - 9/15/17 25,000.00 SEP 97,171.03 * 97,171.03

10/09/17 10771 CITY PAY LRC BILL AUG 2017 54.00 OCT 54.00 * 97,225.03

12/08/17 18702 06885 ERES INTERNATIONAL INTESTING - GOODWIN 1,930.25 12/15/17 19174 11361 OTTO BAUM COMPANY, IN8/31-9/30/17 PATCH 2,639.59 12/15/17 19213 13417 VEYA, INC 2017 PHILO ROAD 9,846.40 DEC 14,416.24 * 111,641.27

1/19/18 23573 CITY PAY LRC BILL NOVEMBER 25.00 JAN 25.00 * 111,666.27 .00 * 111,666.27 *

A09 1 0400-0423 PAVEMENT PATCHING ENC. .00 .00 .00 * .00 *

A09 1 0400-0424 PROPERTY ACQ - CITY FACILITIES .00 .00 .00 * .00 *

A09 1 0400-0515 BRICK SIDEWALK MAINT. .00 8/18/17 05146 10738 OWENS EXCAVATING AND 7/1 - 7/17 21,885.24 AUG 21,885.24 * 21,885.24 .00 * 21,885.24 *



A09 1 0400-0516 BRICK SIDEWALK REPL. ENC. .00 .00 .00 * .00 *

A09 1 0400-0531 MCORE PHASE I (PE II) .00 .00 .00 * .00 *

A09 1 0400-0532 2020 STREET RECON - DIVISION .00 .00 .00 * .00 *

A09 1 0400-0533 LINCOLN AVE PROPERTY TAXES .00 .00 .00 * .00 *

A09 1 0400-0534 WINDSOR RD. DESIGN ENC. .00 .00 .00 * .00 *

A09 1 0400-0536 WINDSOR MEDIAN PAYMENT .00 .00 .00 * .00 *

A09 1 0400-0540 AIRPORT RD WEST .00 9/29/17 09822 11189 FARNSWORTH GROUP, INCTHROUGH 7/28/17 9,520.10 SEP 9,520.10 * 9,520.10

10/06/17 10350 06628 FEUTZ CONTRACTORS INC7/1/17 - 7/31/17 229,501.71 10/13/17 11759 11189 FARNSWORTH GROUP, INCAIRPORT RD 8/25/17 15,536.40 10/13/17 11819 06628 FEUTZ CONTRACTORS INC8/1/17 - 8/31/17 564,509.94 OCT 809,548.05 * 819,068.15

11/17/17 16541 06628 FEUTZ CONTRACTORS INC9/1/17 - 9/30/17 166,327.36 NOV 166,327.36 * 985,395.51

12/08/17 18704 11189 FARNSWORTH GROUP, INCTHROUGH 10/20/17 21,073.64 12/08/17 18772 06628 FEUTZ CONTRACTORS INC10/1/17 - 10/31/17 25,665.35 12/22/17 20607 11189 FARNSWORTH GROUP, INCTHROUGH 10/27/17 2,680.42 DEC 49,419.41 * 1,034,814.92

1/26/18 24398 06628 FEUTZ CONTRACTORS INC11/1/17 - 11/30/17 42,178.08 JAN 42,178.08 * 1,076,993.00 .00 * 1,076,993.00 *

A09 1 0400-0550 PED X-SIGNALS (GRANT) ENC. .00 .00 .00 * .00 *



A09 1 0400-0557 BIKE LANES & SIDEPATHS .00 9/01/17 06654 08885 FIRST NATIONAL BANK OLIFE IS A CYCLE 250.00 9/15/17 08113 36296 HALL SIGNS TRAFFIC SIGNAGE 521.48 9/29/17 09848 09685 VARSITY STRIPING & 8/1/17 - 9/15/17 37,737.28 SEP 38,508.76 * 38,508.76

12/08/17 18764 09685 VARSITY STRIPING & COMPLETION 10/4/17 13,022.52 12/22/17 20613 36296 HALL SIGNS BIKE SIGNAGE 233.76 DEC 13,256.28 * 51,765.04 .00 * 51,765.04 *

A09 1 0400-0558 BIKE LANES & SIGNAGE ENC. .00 .00 .00 * .00 *

A09 1 0400-0559 HIGHCROSS RD. SIDEPATH ENC. .00 .00 .00 * .00 *

A09 1 0400-0560 HIGHCROSS RD. SIDEPATH ENC. .00 .00 .00 * .00 *

A09 1 0400-0564 PHILO RD. IMPR./LANDSCAP ENC. .00 .00 .00 * .00 *

A09 1 0400-0572 CITY BUILDING CHILLER .00 .00 .00 * .00 *

A09 1 0400-0576 OLYMPIAN DRIVE ENG./STUDY ENC. .00 .00 .00 * .00 *

A09 1 0400-0577 OLYMPIAN DR. ENG/STUDY ENC. .00 .00 .00 * .00 *

A09 1 0400-0578 DIVISION ST. IMPROVEMENT ENC. .00 .00 .00 * .00 *

A09 1 0400-0580 MERVIS ST.IMPR. ENC. .00 .00 .00 * .00 *

A09 1 0400-0582 BIKE SIGNS/LANES GRANT ENC. .00 .00 .00 * .00 *

A09 1 0400-0583 WILLOW RD. IMPR. ENC. .00 .00 .00 * .00 *



A09 1 0400-0584 KING PARK LITING IMPR. ENC. .00 .00 .00 * .00 *

A09 1 0400-0586 MATHEWS ST. IMPR. .00 .00 .00 * .00 *

A09 1 0400-0588 IL. 130 ENGINEERING ENC .00 .00 .00 * .00 *

A09 1 0400-0590 DESIGN COSTS, CAMPUS LITING ENC. .00 .00 .00 * .00 *

A09 1 0400-0592 DEMOLITION URBANA TOWNHOMES ENC .00 .00 .00 * .00 *

A09 1 0400-0594 BIKE MASTER PLAN UPDATE .00 .00 .00 * .00 *

A09 1 0400-0596 URBANA STORM WATER UT. FEE .00 .00 .00 * .00 *

A09 1 0400-0598 CONCRETE SIDEWALK MAINT .00 7/28/17 02912 15867 JERRY HESS 206 S POPLAR 450.00 JUL 450.00 * 450.00

8/11/17 04474 08575 A & R SERVICES INC 6/20/17 - 7/14/17 31,382.11 8/25/17 06129 08575 A & R SERVICES INC 7/17/17 - 8/7/17 48,747.72 AUG 80,129.83 * 80,579.83

9/15/17 08088 08575 A & R SERVICES INC 8/7/17 - 8/31/17 3,939.41 9/15/17 08118 11372 IBC - CENTRAL IL BROADWAY & WATER 1,019.90 SEP 4,959.31 * 85,539.14

10/06/17 10308 10403 HUNSINGER ENTERPRISES611 ELM SDWLK RAMP 10,778.77 OCT 10,778.77 * 96,317.91

11/09/17 15481 10738 OWENS EXCAVATING AND BRICK REPAIR 25,547.60 NOV 25,547.60 * 121,865.51

12/15/17 19134 08575 A & R SERVICES INC 8/31/17 - 11/30/17 3,424.69 DEC 3,424.69 * 125,290.20

1/12/18 22700 06885 ERES INTERNATIONAL INTEST 6/29-11/10/17 498.25 JAN 498.25 * 125,788.45 .00 * 125,788.45 *



A09 1 0400-0600 OLYMPIAN DRIVE CONSTRUCTION .00 .00 .00 * .00 *

A09 1 0400-0601 OLYMPIAN DR CONSTR ENGINEERING .00 10/27/17 13437 12702 HANSON PROFESSIONAL S3/26/17-9/9/17 2,320.54 OCT 2,320.54 * 2,320.54 .00 * 2,320.54 *

A09 1 0400-0602 WINDSOR RD REC PHILO TO RACE .00 .00 .00 * .00 *

A09 1 0400-0604 IL RT 130 IMPROVEMENTS .00 .00 .00 * .00 *

A09 1 0400-0606 NORTHWEST URBANA .00 .00 .00 * .00 *

A09 1 0400-0612 BROADWAY AVE .00 .00 .00 * .00 *

MAJOR TOTALS .00 * 1,441,924.05 .00 * 1,441,924.05 *

108 TRANSACTIONS FUND TOTALS .00 1,982,158.07 1,982,158.07 .00

GL40A RUN DATE 9/07/18 GENERAL LEDGER DETAIL TRIAL BALANCE FOR PERIOD 7/01/2017 TO 2/01/2018 PAGE 1 PERIOD 7/01/2017 TO 2/01/2018 CITY OF URBANA A10 STORM WATER UTILITY


STORMWATER UTILITY ASSETSA10 0 0000-0001 BUSEY CHECKING .00 .00 .00 * .00 *

A10 0 0000-0002 BUSEY MONEY MARKET .00 .00 .00 * .00 *

A10 0 0000-0011 INVESTMENTS .00 .00 .00 * .00 *

A10 0 0000-0050 ACCOUNTS RECEIVABLE .00 .00 .00 * .00 *

A10 0 0000-0099 DUE FROM TREASURY FUND 691,710.49 7/03/17 00011 REGISTER REVENUE 07/03/17 25.00 7/07/17 00091 FOR CHECKS WRITTEN 07/07/2017 2,751.00 7/10/17 00344 WIRE UCSD STORMWATER DEP 6/17 112,633.53 7/14/17 01138 FOR CHECKS WRITTEN 07/14/2017 1,000.00 7/21/17 01485 FOR CHECKS WRITTEN 07/21/2017 47,719.00 7/24/17 01881 JULY REVENUE 7/24/17 16,190.00 7/28/17 02940 FOR CHECKS WRITTEN 07/28/2017 1,772.00 7/31/17 14204 INTEREST 7/31/2017 659.88 JUL 76,266.41 * 767,976.90

8/07/17 03755 WIRE-UCSD STORMWATER DEP 7/17 92,265.43 8/11/17 04554 FOR CHECKS WRITTEN 08/11/2017 29,254.00 8/14/17 04870 REGISTER REVENUE 08/14/17 25.00 8/25/17 06207 FOR CHECKS WRITTEN 08/25/2017 34,276.95 8/31/17 14268 INTEREST 8/31/2017 433.85 AUG 29,193.33 * 797,170.23

9/01/17 06741 FOR CHECKS WRITTEN 09/01/2017 899.00 9/08/17 07654 FOR CHECKS WRITTEN 09/08/2017 260.00 9/08/17 12957 WIRE-UCSD STORMWATER DEP 8/17 113,418.87 9/15/17 08167 FOR CHECKS WRITTEN 09/15/2017 2,598.26 9/22/17 09236 FOR CHECKS WRITTEN 09/22/2017 28,627.71 9/25/17 09529 SEPTEMBER REVENUE 9/25/17 500.00 9/29/17 09855 FOR CHECKS WRITTEN 09/29/2017 5,357.75 9/29/17 10372 REGISTER REVENUE 09/29/17 25.00 9/30/17 13866 Q1 TFR A10 TO GF 140,193.00 9/30/17 13908 Q1 TFR A10 TO VERF 9,186.00 9/30/17 14332 INTEREST 9/30/2017 988.57



A10 0 0000-0099 DUE FROM TREASURY FUND (CONTINUED) SEP 72,189.28-* 724,980.95

10/06/17 10354 FOR CHECKS WRITTEN 10/06/2017 13,545.00 10/06/17 11664 WIRE UCSD STORMWATER DEP 9/17 101,079.76 10/13/17 11823 FOR CHECKS WRITTEN 10/13/2017 109,460.57 10/27/17 13511 FOR CHECKS WRITTEN 10/27/2017 13,541.20 10/27/17 13610 OCTOBER REVENUE 10/27/17 500.00 10/31/17 24026 INTEREST 10/31/2017 215.63 OCT 34,751.38-* 690,229.57

11/03/17 15028 FOR CHECKS WRITTEN 11/03/2017 2,385.00 11/07/17 20407 WIRE UCSD STORMWATER DEP OCT17 124,345.72 11/09/17 15511 FOR CHECKS WRITTEN 11/09/2017 1,784.00 11/17/17 16544 FOR CHECKS WRITTEN 11/17/2017 2,525.00 11/30/17 24092 INTEREST 11/30/2017 956.08 NOV 118,607.80 * 808,837.37

12/01/17 17909 FOR CHECKS WRITTEN 12/01/2017 4,101.75 12/07/17 20397 WIRE UCSD STORMWATER DEP NOV17 81,780.06 12/08/17 18775 FOR CHECKS WRITTEN 12/08/2017 17,138.44 12/18/17 20416 REGISTER REVENUE 12/18/17 104,628.74 12/22/17 20653 FOR CHECKS WRITTEN 12/22/2017 18,426.98 12/29/17 21598 FOR CHECKS WRITTEN 12/29/2017 590.00 12/31/17 23496 Q2 TFR A10 TO GF 140,193.00 12/31/17 23588 Q2 TFR FROM A10 TO H09 9,186.00 12/31/17 24590 INTEREST 12/31/2017 572.36 DEC 2,655.01-* 806,182.36

1/05/18 21980 FOR CHECKS WRITTEN 01/05/2018 756.75 1/08/18 22943 WIRE UCSD STORMWATER DEP DEC17 117,675.62 1/12/18 23003 REGISTER REVENUE 01/12/18 25.00 1/19/18 23271 FOR CHECKS WRITTEN 01/19/2018 5,845.73 1/26/18 24405 FOR CHECKS WRITTEN 01/26/2018 42,359.56 JAN 68,738.58 * 868,944.10 685,733.65 * 874,920.94 *

MAJOR TOTALS 691,710.49 * 868,944.10 685,733.65 * 874,920.94 *

STORMWATER UTILITY LIABILITIESA10 0 0001-0100 DUE TO/FROM OTHER FUNDS .00 .00 .00 * .00 *



A10 0 0001-0116 ACCOUNTS PAYABLE 50,470.00- 7/07/17 00090 FOR CHECKS WRITTEN 07/07/2017 2,751.00 7/21/17 01484 FOR CHECKS WRITTEN 07/21/2017 47,719.00 JUL 50,470.00 * 50,470.00 .00 * .00 *

A10 0 0001-0140 DEFERRED REVENUE .00 .00 .00 * .00 *

A10 0 0001-0199 FUND BALANCE 641,240.49- .00 .00 * 641,240.49-*

MAJOR TOTALS 691,710.49-* 50,470.00 .00 * 641,240.49-*

STORMWATER UTILITY REVENUEA10 0 0010-0000 STORM SEWER UTILITY BILLINGS .00 7/03/17 00012 REG REV 07/03/17 BROWN PA 25.00 7/10/17 00340 WIRE UCSD STORMWATER REV 6/17 116,348.86 JUL 116,373.86-* 116,373.86-

8/07/17 03751 WIRE-UCSD STORMWTR REV 7/17 95,143.20 8/14/17 04871 REG REV 08/14/17 BROWN PA 25.00 AUG 95,168.20-* 211,542.06-

9/08/17 12953 WIRE-UCSD STORMWATER REV 8/17 117,134.20 9/25/17 09530 310 S POPLAR-SUMP PUMP COST SH 500.00 9/29/17 10373 REGISTER REVENUE 09/29/17 25.00 SEP 117,659.20-* 329,201.26-

10/06/17 11660 WIRE UCSD STORMWATER REV 9/17 103,962.78 10/27/17 13613 THOMPSON-408 E PENNSYLVANIA 500.00 OCT 104,462.78-* 433,664.04-

11/07/17 20403 WIRE UCSD STORMWATER REV OCT17 128,051.74 NOV 128,051.74-* 561,715.78-

12/07/17 20393 WIRE UCSD STORMWATER REV NOV17 84,657.49 12/18/17 20417 REGISTER REVENUE 12/18/17 104,628.74 DEC 189,286.23-* 751,002.01-

1/08/18 22939 WIRE UCSD STORMWATER REV DEC17 121,414.14 1/12/18 23004 J BROWN PMT REGISTER 01/12/18 25.00 JAN 121,439.14-* .00 872,441.15 * 872,441.15-*

MAJOR TOTALS .00 * .00 872,441.15 * 872,441.15-*



STORMWATER UTILITY REVENUEA10 0 0020-0000 BONEYARD CREEK MAINTENANCE REIMB .00 7/24/17 01886 CHAMPAIGN PMT FY 16-17 16,190.00 JUL 16,190.00-* .00 16,190.00 * 16,190.00-*

MAJOR TOTALS .00 * .00 16,190.00 * 16,190.00-*

STORMWATER UTILITY REVENUEA10 0 0030-0000 HAZARDOUS SUMP PUMP ABATEMENT PROG .00 .00 .00 * .00 *

MAJOR TOTALS .00 * .00 .00 * .00 *

STORMWATER UTILITY REVENUEA10 0 0040-0000 MISC. REIMBURSEMENT .00 .00 .00 * .00 *

MAJOR TOTALS .00 * .00 .00 * .00 *

STORMWATER UTILITY REVENUEA10 0 0130-0000 INTEREST .00 7/31/17 14205 INTEREST 7/31/2017 659.88 JUL 659.88-* 659.88-

8/31/17 14269 INTEREST 8/31/2017 433.85 AUG 433.85-* 1,093.73-

9/30/17 14333 INTEREST 9/30/2017 988.57 SEP 988.57-* 2,082.30-

10/31/17 24027 INTEREST 10/31/2017 215.63 OCT 215.63-* 2,297.93-

11/30/17 24093 INTEREST 11/30/2017 956.08 NOV 956.08-* 3,254.01-

12/31/17 24591 INTEREST 12/31/2017 572.36 DEC 572.36-* .00 3,826.37 * 3,826.37-*

MAJOR TOTALS .00 * .00 3,826.37 * 3,826.37-*



STORMWATER UTILITY REVENUEA10 0 0250-0000 MISCELLANEOUS REVENUE .00 .00 .00 * .00 *

MAJOR TOTALS .00 * .00 .00 * .00 *



STORMWATER UTILITY EXPENSESA10 1 0300-0010 TFR TO GEN OP FUND (PERSONNEL) .00 9/30/17 13861 Q1 TFR A10 TO GF 51,338.00 SEP 51,338.00 * 51,338.00

12/31/17 23491 Q2 TFR A10 TO GF 51,338.00 DEC 51,338.00 * 102,676.00 .00 * 102,676.00 *

A10 1 0300-0012 TFR TO GEN OP FUND (STREET SWEEP) .00 9/30/17 13862 Q1 TFR A10 TO GF 39,315.25 SEP 39,315.25 * 39,315.25

12/31/17 23492 Q2 TFR A10 TO GF 39,315.25 DEC 39,315.25 * 78,630.50 .00 * 78,630.50 *

A10 1 0300-0014 TFR TO GEN OP FUND (STORM MTC) .00 9/30/17 13863 Q1 TFR A10 TO GF 49,539.75 SEP 49,539.75 * 49,539.75

12/31/17 23493 Q2 TFR A10 TO GF 49,539.75 DEC 49,539.75 * 99,079.50 .00 * 99,079.50 *

A10 1 0300-0016 STREAM/RAIN GAUGE MONITORING .00 8/11/17 04542 14292 U.S. GEOLOGICAL SURVEJOINT FUNDING AGR 14,400.00 AUG 14,400.00 * 14,400.00 .00 * 14,400.00 *

A10 1 0300-0018 TFR TO A09 (STORMWATER STUDY) .00 .00 .00 * .00 *

A10 1 0300-0020 BONEYARD CREEK MAINTENANCE .00 7/28/17 02904 15007 DEANGELO BROTHERS LLCHERBICIDE APPL 1,772.00 JUL 1,772.00 * 1,772.00

9/15/17 08131 14837 PROFESSIONAL PRODUCTSCLEANER 292.26 9/22/17 09170 05390 BROWN/WOODS & ASSOCIAJULY 2017 4,275.00 9/29/17 09807 05390 BROWN/WOODS & ASSOCIAAUGUST 2017 LANDSC 4,107.75 SEP 8,675.01 * 10,447.01

11/09/17 15458 15007 DEANGELO BROTHERS LLCVEGETATION SPRAY 1,772.00 11/17/17 16478 05390 BROWN/WOODS & ASSOCIASEPTEMBER LANDSCPE 2,495.00 NOV 4,267.00 * 14,714.01

12/01/17 17869 05390 BROWN/WOODS & ASSOCIAOCTOBER 2017 LANDS 4,101.75



A10 1 0300-0020 BONEYARD CREEK MAINTENANCE (CONTINUED) 12/22/17 20587 05390 BROWN/WOODS & ASSOCIANOVEMBER 2017 3,471.75 DEC 7,573.50 * 22,287.51 .00 * 22,287.51 *

A10 1 0300-0022 DRAINAGE DISTRICT FEES .00 10/06/17 10277 15915 SALINE BRANCH DRAINAGSALINE MAIN BRANCH 13,125.00 10/06/17 10278 15914 SALINE BRANCH DRAINAGSALINE SUB DIST C 420.00 OCT 13,545.00 * 13,545.00 .00 * 13,545.00 *

A10 1 0300-0024 SUMP PUMP DISCHARGE ABATEMENT .00 9/22/17 09181 26350 DUCE CONSTRUCTION INC8/1/-31 MSRC 4,841.08 SEP 4,841.08 * 4,841.08 .00 * 4,841.08 *

A10 1 0300-0026 GIS PROFESSIONAL SERVICES .00 .00 .00 * .00 *

A10 1 0300-0028 NPDES PERMIT FEE .00 7/14/17 01134 08181 ILLINOIS EPA FISCAL S2017-18 MS4 NPDES 1,000.00 JUL 1,000.00 * 1,000.00 .00 * 1,000.00 *

A10 1 0300-0030 MOSQUITO ABATEMENT .00 8/11/17 04488 06806 CHAMPAIGN URBANA PUBLPAY 1&2 - CULEX 14,854.00 AUG 14,854.00 * 14,854.00 .00 * 14,854.00 *

A10 1 0300-0032 BILLING COSTS .00 7/10/17 00341 WIRE UCSD STORMWATER FEE 6/17 3,715.33 JUL 3,715.33 * 3,715.33

8/07/17 03752 WIRE-UCSD STORMWTR FEE 7/17 2,877.77 AUG 2,877.77 * 6,593.10

9/08/17 12954 WIRE-UCSD STORMWATER FEE 8/17 3,715.33 SEP 3,715.33 * 10,308.43

10/06/17 11661 WIRE UCSD STORMWATER FEE 9/17 2,883.02 OCT 2,883.02 * 13,191.45

11/07/17 20404 WIRE UCSD STORMWATER FEE OCT17 3,706.02 NOV 3,706.02 * 16,897.47

12/07/17 20394 WIRE UCSD STORMWATER FEE NOV17 2,877.43 DEC 2,877.43 * 19,774.90

1/08/18 22940 WIRE UCSD STORMWATER FEE DEC17 3,738.52 JAN 3,738.52 * 23,513.42 .00 * 23,513.42 *



A10 1 0300-0034 STORM SEWER FEE INCENTIVES .00 .00 .00 * .00 *

A10 1 0300-0036 STORM SEWER FEE CREDIT PROGRAM .00 .00 .00 * .00 *

A10 1 0300-0038 CLEANING AND TELEVISING .00 10/13/17 11821 10569 HOERR CONSTRUCTION IN2016 STORM SEWER 109,460.57 OCT 109,460.57 * 109,460.57

1/19/18 23201 10569 HOERR CONSTRUCTION IN2016 FINAL PAYMENT 5,845.73 JAN 5,845.73 * 115,306.30 .00 * 115,306.30 *

A10 1 0300-0040 TRAINING GIS EROSION STORMWATER .00 9/01/17 06653 08885 FIRST NATIONAL BANK OBENNETT 8/27-30 899.00 9/08/17 07603 15893 SCRANTON GILLETTE COMREINKE 11/7 SWS 260.00 9/22/17 09077 09021 BRAD BENNETT APWA 8/27-30 1,272.93 SEP 2,431.93 * 2,431.93

11/03/17 14964 02528 ILLINOIS GIS ASSOCIAILGISA 10/2 REINKE 385.00 11/09/17 15431 14908 BETH REINKE ILGIS 10/3-4/2017 12.00 11/17/17 16421 09021 BRAD BENNETT APWA 10/20/2017 10.00 11/17/17 16449 14908 BETH REINKE APWA 10/20/17 10.00 11/17/17 16456 10016 PEGGY STASKE APWA 10/20/17 10.00 NOV 427.00 * 2,858.93

12/08/17 18588 08885 FIRST NATIONAL BANK O11/7-9 SWS CONF 291.54 12/08/17 18628 14908 BETH REINKE SWS CONF 11/7-11/9 197.33 12/29/17 21520 09581 BENTLEY SYSTEMS INC HYDRAULIC SOFTWARE 590.00 DEC 1,078.87 * 3,937.80

1/05/18 21915 05344 CDW GOVERNMENT INC ASUS TABLET 176.00 1/05/18 21944 08885 FIRST NATIONAL BANK OPACP RECERT REINKE 360.00 1/26/18 24248 08885 FIRST NATIONAL BANK OTABLET CASE 29.86 JAN 565.86 * 4,503.66 .00 * 4,503.66 *

A10 1 0300-0042 BRIDGE MAINTENANCE PROJECTS .00 .00 .00 * .00 *

A10 1 0300-0044 EDUCATION AND OUTREACH .00 .00 .00 * .00 *

MAJOR TOTALS .00 * 494,636.97 .00 * 494,636.97 *



STORMWATER UTILITY EXPENSESA10 1 0400-0100 STORMWATER IMPROVEMENTS .00 8/25/17 06154 26350 DUCE CONSTRUCTION INC7/1/17 - 7/31/17 34,276.95 AUG 34,276.95 * 34,276.95

9/15/17 08132 05298 RAHN EQUIPMENT CO MOWER RENTAL/KNIFE 2,306.00 9/22/17 09182 26350 DUCE CONSTRUCTION INC8/1/-31 MSRC 18,238.70 9/29/17 09849 03908 VISU-SEWER CLEAN & SE2017 SEWER LINING 1,250.00 SEP 21,794

year to date trial - city.urbana.il.us2017-2018_detail_trial… · capital repl & improv - assets...

Documents