The URL can be used to link to this page

Home My WebLink About5.1 Monthly Financial Report - March 2018 BoardDocs® ProPage 1 of 2 Agenda Item Details MeetingApr 17, 2018 - REGULAR MEETING OF THE MOUNT PROSPECT VILLAGE BOARD - 7:00 p.m. Category5. CONSENT AGENDA Subject5.1 Monthly Financial Report - March 2018 AccessPublic TypeAction (Consent) Preferred DateApr 17, 2018 Absolute DateApr 17, 2018 Fiscal ImpactNo BudgetedNo Recommended ActionAccept the monthly financial report for March 2018. Public Content Information The monthly financial report contains a Cash Position Report and Fund Financials for the month ended March 31, 2018. Alternatives 1. Accept the monthly financial report for March 2018 2. Action at discretion of Village Board. Staff Recommendation Staff recommends the Village Board accept the monthly financial report for March 31, 2018. 03 March Board Reports for Upload .pdf (337 KB) Combined Financials for BD 3-18.pdf (798 KB) Administrative Content Executive Content https://www.boarddocs.com/il/vomp/Board.nsf/Private?open&login6/12/2018 BoardDocs® ProPage 2 of 2 All items under Consent Agenda are considered routine by the Village Board and will be enacted by one motion. There will be no separate discussion of those items unless a Board member or member from the audience so requests, in which the item will be removed from the Consent Agenda and considered in its sequence on the agenda. Motion & Voting (not specified) Motion by Michael Zadel, second by Richard Rogers. Final Resolution: Motion Carries Yea: William Grossi, Eleni Hatzis, Paul Hoefert, Richard Rogers, Colleen Saccotelli, Michael Zadel https://www.boarddocs.com/il/vomp/Board.nsf/Private?open&login6/12/2018 8 1 20 , 31 & March – 1 BUDGET REVENUE March EXPENDITURE SUMMARIES VILLAGE OF MOUNT PROSPECT .00 77,056.6246,662.9638,233.84 587,033.01343,097.25163,019.88144,785.53 8,546,701.231,253,176.98 Prior Year YTD $11,199,767.30$11,199,767.30 5317232011234122 104 30% +++ Rec'd Summary Listing % Used/ Through 03/31/18 .00 338,282.94120,798.48169,801.01 (11,069.75) Transactions Budget - YTD7,758,991.756,839,931.791,085,316.881,158,586.97 19,986,421.88 $37,447,061.95$37,447,061.95 .00 YTD Prior Fiscal Year Activity Included 98,717.0684,201.5249,098.99 331,683.12262,569.75 146,413.03 Transactions 8,781,008.251,370,068.214,897,438.12 $16,021,198.05$16,021,198.05 .00.00.00.00.00.00 .00.00.00.00 YTD $0.00$0.00 Encumbrances .00 42,465.3350,466.0327,142.0145,197.36 (1,524.04) 612,240.93110,990.99 Transactions 5,908,832.123,710,434.22 Current Month $10,506,244.95$10,506,244.95 .00 Budget 1 Amended 437,000.00205,000.00218,900.00251,500.00 8,210,000.001,417,000.001,305,000.00 16,540,000.0024,883,860.00 $53,468,260.00$53,468,260.00 .00.00.00.00.00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00 Budget Revenue Budget by Account Classification Report Adopted 437,000.00205,000.00218,900.00251,500.00 8,210,000.001,417,000.001,305,000.00 16,540,000.0024,883,860.00 $53,468,260.00$53,468,260.00 Totals REVENUE TOTALS 001 - General Fund Fund 001 - General Fund REVENUE Account ClassificationFundProperty TaxesOther TaxesLicenses, Permits & FeesIntergovernmental RevenueCharges For ServicesFines & ForfeitsInvestment IncomeReimbursementsOther RevenueOther Financing Sources .00.00.00.00.00 1,224,768.49 $1,224,768.49$1,224,768.49 Prior Year YTD 0 482051 27% ++++++ Rec'd Summary Listing % Used/ Through 03/31/18 .00.00 491.87 812,039.43 Transactions Budget - YTD1,239,506.141,618,150.00 $3,670,187.44$3,670,187.44 .00.00.00 YTD Prior Fiscal Year Activity Included 508.13 200,478.57 Transactions 1,140,493.86 $1,341,480.56$1,341,480.56 .00.00.00.00.00.00 YTD $0.00$0.00 Encumbrances .00.00.00 371.27 866,175.41200,478.57 Transactions Current Month $1,067,025.25$1,067,025.25 .00.00 Budget 2 1,000.00 Amended 2,380,000.001,012,518.001,618,150.00 $5,011,668.00$5,011,668.00 .00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00 Budget Revenue Budget by Account Classification Report Adopted 1,000.00 2,380,000.001,012,518.001,618,150.00 $5,011,668.00$5,011,668.00 Totals REVENUE TOTALS 002 - Debt Service Fund Fund 002 - Debt Service Fund REVENUE Account ClassificationFundProperty TaxesOther TaxesIntergovernmental RevenueInvestment IncomeOther RevenueOther Financing Sources .00.00.00.00.00 688.07 $688.07$688.07 Prior Year YTD 00 20 275 13% ++++++ Rec'd Summary Listing % Used/ Through 03/31/18 .00.00 10,000.00 (1,754.85) 750,000.00 Transactions Budget - YTD1,042,600.00 $1,800,845.15$1,800,845.15 .00.00.00.00 YTD Prior Fiscal Year Activity Included 2,754.85 257,400.00 Transactions $260,154.85$260,154.85 .00.00.00.00.00.00 YTD $0.00$0.00 Encumbrances .00.00.00.00 1,020.96 257,400.00 Transactions $258,420.96$258,420.96 Current Month .00.00 Budget 3 1,000.00 Amended 10,000.00 750,000.00 1,300,000.00 $2,061,000.00$2,061,000.00 .00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00 Budget Revenue Budget by Account Classification Report Adopted 1,000.00 10,000.00 750,000.00 1,300,000.00 $2,061,000.00$2,061,000.00 Totals REVENUE TOTALS 020 - Capital Improvement Fund Fund 020 - Capital Improvement Fund REVENUE Account ClassificationFundOther TaxesIntergovernmental RevenueInvestment IncomeReimbursementsOther RevenueOther Financing Sources .00.00.00.00.00.00 106,334.28704,506.00 $810,840.28$810,840.28 Prior Year YTD 7 194120 28% ++++++++++++ Rec'd Summary Listing % Used/ Through 03/31/18 .00.00.00.00 1,608.92 27,931.68 980,102.00 Transactions Budget - YTD1,609,261.80 $2,618,904.40$2,618,904.40 .00.00.00.00 YTD Prior Fiscal Year Activity Included 391.08 2,068.32 370,738.20669,898.00 Transactions $1,043,095.60$1,043,095.60 .00.00.00.00.00.00.00 .00 YTD $0.00$0.00 Encumbrances .00.00.00.00.00 229.59 311,031.32372,279.00 Transactions $683,539.91$683,539.91 Current Month .00.00.00.00 Budget 4 2,000.00 Amended 30,000.00 1,980,000.001,650,000.00 $3,662,000.00$3,662,000.00 .00.00.00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00.00 .00 Budget Revenue Budget by Account Classification Report Adopted 2,000.00 30,000.00 1,980,000.001,650,000.00 $3,662,000.00$3,662,000.00 Totals REVENUE TOTALS 023 - Street Improvement Construc Fund 023 - Street Improvement Construc Fund Fund REVENUE Account ClassificationFundOther TaxesLicenses, Permits & FeesIntergovernmental RevenueFines & ForfeitsInvestment IncomeReimbursementsOther RevenueOther Financing Sources .00.00.00.00 (176.50) 2,212.00 $2,035.50$2,035.50 Prior Year YTD 30 2035 18% ++++++ Rec'd Summary Listing % Used/ Through 03/31/18 .00.00 3,913.08 24,316.0020,000.00 230,976.00 Transactions $279,205.08$279,205.08 Budget - YTD .00.00.00 YTD Prior Fiscal Year Activity Included 684.00 2,086.92 57,024.00 $59,794.92$59,794.92 Transactions .00.00.00.00.00.00 YTD $0.00$0.00 Encumbrances .00.00.00 85.00 1,037.64 57,024.00 $58,146.64$58,146.64 Transactions Current Month .00.00 Budget 5 6,000.00 Amended 25,000.0020,000.00 288,000.00 $339,000.00$339,000.00 .00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00 Budget Revenue Budget by Account Classification Report Adopted 6,000.00 25,000.0020,000.00 288,000.00 $339,000.00$339,000.00 Totals REVENUE TOTALS 024 - Flood Control Construction Fund Fund 024 - Flood Control Construction Fund REVENUE Account ClassificationFundOther TaxesIntergovernmental RevenueCharges For ServicesInvestment IncomeReimbursementsOther Financing Sources .00.00 290.49 9,298.00 33,920.18 1,037,854.80 $1,081,363.47$1,081,363.47 Prior Year YTD 0 25203624 25% +++ Rec'd Summary Listing % Used/ Through 03/31/18 .00 2,543.011,000.00 36,765.2884,177.40 Transactions Budget - YTD3,130,855.32 $3,255,341.01$3,255,341.01 .00.00 YTD Prior Fiscal Year Activity Included 9,234.721,456.99 26,822.60 Transactions 1,044,144.68 $1,081,658.99$1,081,658.99 .00.00.00.00.00 .00 YTD $0.00$0.00 Encumbrances .00.00 532.06 1,656.15 10,570.95 488,189.27 Transactions $500,948.43$500,948.43 Current Month .00 Budget 6 4,000.001,000.00 Amended 46,000.00 111,000.00 4,175,000.00 $4,337,000.00$4,337,000.00 .00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00 Budget Revenue Budget by Account Classification Report Adopted 4,000.001,000.00 46,000.00 111,000.00 4,175,000.00 $4,337,000.00$4,337,000.00 Totals REVENUE TOTALS 040 - Refuse Disposal Fund Fund 040 - Refuse Disposal Fund REVENUE Account ClassificationFundProperty TaxesCharges For ServicesFines & ForfeitsInvestment IncomeReimbursementsOther Revenue .00.00 512.74 238,616.86 $239,129.60$239,129.60 Prior Year YTD 6 1681 17% +++ Rec'd Summary Listing % Used/ Through 03/31/18 .00 960.95 14,045.67 Transactions Budget - YTD1,166,296.16 $1,181,302.78$1,181,302.78 .00 YTD Prior Fiscal Year Activity Included 954.33 4,039.05 228,703.84 Transactions $233,697.22 $233,697.22 .00.00.00.00 YTD $0.00 $0.00 Encumbrances .00 1,712.493,665.99 106,163.63 Transactions $111,542.11$111,542.11 Current Month .00 Budget 7 5,000.00 Amended 15,000.00 1,395,000.00 $1,415,000.00$1,415,000.00 .00.00.00.00 $0.00$0.00 Budget Amendments .00 Budget Revenue Budget by Account Classification Report Adopted 5,000.00 15,000.00 1,395,000.00 $1,415,000.00$1,415,000.00 Totals REVENUE TOTALS 041 - Motor Fuel Tax Fund Fund 041 - Motor Fuel Tax Fund REVENUE Account ClassificationFundIntergovernmental RevenueInvestment IncomeReimbursementsOther Revenue .00.00 28,418.73 $28,418.73$28,418.73 Prior Year YTD 0 42 6% +++ Rec'd Summary Listing % Used/ Through 03/31/18 .00 35,000.00 378,666.00 Transactions $413,666.00$413,666.00 Budget - YTD .00.00 YTD Prior Fiscal Year Activity Included 25,000.00 $25,000.00$25,000.00 Transactions .00.00.00 YTD $0.00$0.00 Encumbrances .00.00.00 $0.00$0.00 Transactions Current Month .00 Budget 8 Amended 60,000.00 378,666.00 $438,666.00$438,666.00 .00.00.00 $0.00$0.00 Budget Amendments .00 Budget Revenue Budget by Account Classification Report Adopted 60,000.00 378,666.00 $438,666.00$438,666.00 Totals REVENUE TOTALS 042 - CDBG Fund 042 - CDBG REVENUE Account ClassificationFundIntergovernmental RevenueInvestment IncomeOther Revenue 26.47 4,962.13 $4,988.60$4,988.60 Prior Year YTD 7546 73% Rec'd Summary Listing % Used/ Through 03/31/18 268.64 1,629.88 $1,898.52$1,898.52 Transactions Budget - YTD YTD Prior Fiscal Year Activity Included 231.36 4,870.12 $5,101.48$5,101.48 Transactions .00.00 YTD $0.00 $0.00 Encumbrances 96.06 4,862.81 $4,958.87$4,958.87 Transactions Current Month 500.00 Budget 9 6,500.00 Amended $7,000.00$7,000.00 .00.00 $0.00$0.00 Budget Amendments 500.00 Budget Revenue Budget by Account Classification Report Adopted 6,500.00 $7,000.00$7,000.00 Totals REVENUE TOTALS 043 - Asset Seizure Fund Fund 043 - Asset Seizure Fund REVENUE Account ClassificationFundFines & ForfeitsInvestment Income .00 29.33 $29.33$29.33 Prior Year YTD 0 24 2% Rec'd Summary Listing % Used/ Through 03/31/18 152.74 1,800.00 $1,952.74$1,952.74 Transactions Budget - YTD .00 YTD Prior Fiscal Year Activity Included 47.26 $47.26$47.26 Transactions .00.00 YTD $0.00$0.00 Encumbrances .00 4.81 $4.81$4.81 Transactions Current Month 200.00 Budget 10 1,800.00 Amended $2,000.00$2,000.00 .00.00 $0.00$0.00 Budget Amendments 200.00 Budget Revenue Budget by Account Classification Report Adopted 1,800.00 $2,000.00$2,000.00 Totals REVENUE TOTALS 044 - Federal Equitable Share Funds Fund 044 - Federal Equitable Share Funds REVENUE Account ClassificationFundFines & ForfeitsInvestment Income .00 81.80 $81.80$81.80 Prior Year YTD 6 26 7% Rec'd Summary Listing % Used/ Through 03/31/18 372.01 23,446.54 $23,818.55$23,818.55 Transactions Budget - YTD YTD Prior Fiscal Year Activity Included 127.99 1,553.46 $1,681.45$1,681.45 Transactions .00.00 YTD $0.00 $0.00 Encumbrances 13.20 1,553.46 $1,566.66$1,566.66 Transactions Current Month 500.00 Budget 11 Amended 25,000.00 $25,500.00$25,500.00 .00.00 $0.00$0.00 Budget Amendments 500.00 Budget Revenue Budget by Account Classification Report Adopted 25,000.00 $25,500.00$25,500.00 Totals REVENUE TOTALS 045 - DUI Fine Fund Fund 045 - DUI Fine Fund REVENUE Account ClassificationFundFines & ForfeitsInvestment Income .00.00 143.15 10,322.57 $10,465.72$10,465.72 Prior Year YTD 0 30 1% ++++++ Rec'd Summary Listing % Used/ Through 03/31/18 .00.00 1,403.32 90,000.00 $91,403.32$91,403.32 Transactions Budget - YTD .00.00.00 YTD Prior Fiscal Year Activity Included 596.68 $596.68$596.68 Transactions .00.00.00.00 YTD $0.00$0.00 Encumbrances .00.00.00 203.44 $203.44$203.44 Transactions Current Month .00.00 Budget 12 2,000.00 Amended 90,000.00 $92,000.00$92,000.00 .00.00.00.00 $0.00$0.00 Budget Amendments .00.00 Budget Revenue Budget by Account Classification Report Adopted 2,000.00 90,000.00 $92,000.00$92,000.00 Totals REVENUE TOTALS 046 - Foreign Fire Tax Board Fund Fund 046 - Foreign Fire Tax Board Fund REVENUE Account ClassificationFundOther TaxesInvestment IncomeOther RevenueOther Financing Sources .00.00 89,158.95 142,500.00 $231,658.95$231,658.95 Prior Year YTD 9 1857 12% +++ Rec'd Summary Listing % Used/ Through 03/31/18 .00 1,302.76 997,501.92344,400.00 Transactions Budget - YTD $1,343,204.68$1,343,204.68 .00 YTD Prior Fiscal Year Activity Included 1,697.24 75,600.00 102,498.08 Transactions $179,795.32 $179,795.32 .00.00.00.00 YTD $0.00 $0.00 Encumbrances .00 836.47 49,765.9975,600.00 Transactions $126,202.46$126,202.46 Current Month .00 Budget 13 3,000.00 Amended 420,000.00 1,100,000.00 $1,523,000.00$1,523,000.00 .00.00.00.00 $0.00$0.00 Budget Amendments .00 Budget Revenue Budget by Account Classification Report Adopted 3,000.00 420,000.00 1,100,000.00 $1,523,000.00$1,523,000.00 Totals REVENUE TOTALS 048 - Business District Fund Fund 048 - Business District Fund REVENUE Account ClassificationFundOther TaxesIntergovernmental RevenueInvestment IncomeOther Financing Sources .00.00.00 $0.00$0.00 Prior Year YTD 00 1% +++ Rec'd Summary Listing % Used/ Through 03/31/18 253,953.00 (25,281.64) Transactions Budget - YTD1,600,000.00 $1,828,671.36$1,828,671.36 .00.00 YTD Prior Fiscal Year Activity Included 25,281.64 $25,281.64$25,281.64 Transactions .00.00.00 YTD $0.00$0.00 Encumbrances .00.00 21,423.09 $21,423.09$21,423.09 Transactions Current Month .00 Budget 14 Amended 253,953.00 1,600,000.00 $1,853,953.00$1,853,953.00 .00.00.00 $0.00$0.00 Budget Amendments .00 Budget Revenue Budget by Account Classification Report Adopted 253,953.00 1,600,000.00 $1,853,953.00$1,853,953.00 Totals REVENUE TOTALS 049 - Prospect and Main TIF District Fund 049 - Prospect and Main TIF District REVENUE Account ClassificationFundProperty TaxesInvestment IncomeOther Financing Sources .00.00 (180.65) 5,640.004,751.52 22,890.5319,306.50 3,034,002.27 $3,086,410.17$3,086,410.17 Prior Year YTD 0 30222116 121 17% ++++++ Rec'd Summary Listing % Used/ Through 03/31/18 .00 1,355.86 14,080.0067,220.00 (3,347.61) 103,003.14 Transactions Budget - YTD5,000,000.00 11,242,483.50 $16,424,794.89$16,424,794.89 .00 .00 YTD Prior Fiscal Year Activity Included 5,920.00 26,996.8619,447.6112,780.00 (1,355.86) Transactions 3,201,716.50 $3,265,505.11$3,265,505.11 .00.00.00.00.00 .00.00.00 YTD $0.00$0.00 Encumbrances .00.00 2,370.008,377.544,200.00 11,793.10 (1,355.86) 988,400.32 Transactions Current Month $1,013,785.10$1,013,785.10 .00.00 Budget 15 Amended 20,000.0016,100.0080,000.00 130,000.00 5,000,000.00 14,444,200.00 $19,690,300.00$19,690,300.00 .00.00.00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00 Budget Revenue Budget by Account Classification Report Adopted 20,000.0016,100.0080,000.00 130,000.00 5,000,000.00 14,444,200.00 $19,690,300.00$19,690,300.00 Totals REVENUE TOTALS 050 - Water and Sewer Fund Fund 050 - Water and Sewer Fund REVENUE Account ClassificationFundProperty TaxesLicenses, Permits & FeesCharges For ServicesFines & ForfeitsInvestment IncomeReimbursementsOther RevenueOther Financing Sources .00.00 112.46821.45 48,575.80 $49,509.71$49,509.71 Prior Year YTD 275522 27% ++++++ Rec'd Summary Listing % Used/ Through 03/31/18 .00.00 454.48 2,339.90 140,912.70 Transactions $143,707.08$143,707.08 Budget - YTD .00.00 YTD Prior Fiscal Year Activity Included 545.52660.10 52,687.30 $53,892.92$53,892.92 Transactions .00.00.00.00.00 YTD $0.00$0.00 Encumbrances .00.00 196.94237.65 14,425.30 $14,859.89$14,859.89 Transactions Current Month .00.00 Budget 16 1,000.003,000.00 Amended 193,600.00 $197,600.00$197,600.00 .00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00 Budget Revenue Budget by Account Classification Report Adopted 1,000.003,000.00 193,600.00 $197,600.00$197,600.00 Totals REVENUE TOTALS 051 - Village Parking System Fund Fund 051 - Village Parking System Fund REVENUE Account ClassificationFundOther TaxesCharges For ServicesInvestment IncomeOther RevenueOther Financing Sources .00.00.00.00 392.00 38,804.95 $39,196.95$39,196.95 Prior Year YTD 253935 25% +++++++++ Rec'd Summary Listing % Used/ Through 03/31/18 .00.00.00 304.30648.60 117,317.65 Transactions $118,270.55$118,270.55 Budget - YTD .00.00.00 YTD Prior Fiscal Year Activity Included 195.70351.40 38,682.35 $39,229.45$39,229.45 Transactions .00.00.00.00.00 .00 YTD $0.00$0.00 Encumbrances .00.00.00 94.64 114.45 13,113.05 $13,322.14$13,322.14 Transactions Current Month .00.00.00 500.00 Budget 17 1,000.00 Amended 156,000.00 $157,500.00$157,500.00 .00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00.00 500.00 Budget Revenue Budget by Account Classification Report Adopted 1,000.00 156,000.00 $157,500.00$157,500.00 Totals REVENUE TOTALS 052 - Parking System Revenue Fund Fund 052 - Parking System Revenue Fund REVENUE Account ClassificationFundOther TaxesIntergovernmental RevenueCharges For ServicesInvestment IncomeOther RevenueOther Financing Sources .00 163.29 507,491.01 $507,654.30$507,654.30 Prior Year YTD 2531 25% +++ Rec'd Summary Listing % Used/ Through 03/31/18 .00 2,062.02 Transactions Budget - YTD1,530,620.30 $1,532,682.32$1,532,682.32 .00 YTD Prior Fiscal Year Activity Included 937.98 510,206.70 Transactions $511,144.68$511,144.68 .00.00.00 YTD $0.00$0.00 Encumbrances .00 356.51 170,068.90 Transactions $170,425.41$170,425.41 Current Month .00 Budget 18 3,000.00 Amended 2,040,827.00 $2,043,827.00$2,043,827.00 .00.00.00 $0.00$0.00 Budget Amendments .00 Budget Revenue Budget by Account Classification Report Adopted 3,000.00 2,040,827.00 $2,043,827.00$2,043,827.00 Totals REVENUE TOTALS 060 - Vehicle Maintenance Fund Fund 060 - Vehicle Maintenance Fund REVENUE Account ClassificationFundCharges For ServicesInvestment IncomeOther Revenue .00.00.00 11,665.9118,518.55 411,249.96 $441,434.42$441,434.42 Prior Year YTD 25105682 28% ++++++ Rec'd Summary Listing % Used/ Through 03/31/18 .00.00 7,180.00 22,033.4011,688.76 Transactions Budget - YTD1,208,475.03 $1,249,377.19$1,249,377.19 .00.00 YTD Prior Fiscal Year Activity Included 820.00 27,966.6053,311.24 402,824.97 Transactions $484,922.81$484,922.81 .00.00.00.00.00 .00 YTD $0.00$0.00 Encumbrances .00.00 820.00 6,049.02 21,322.49 134,274.99 Transactions $162,466.50$162,466.50 Current Month .00.00 Budget 19 8,000.00 Amended 50,000.0065,000.00 1,611,300.00 $1,734,300.00$1,734,300.00 .00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00 Budget Revenue Budget by Account Classification Report Adopted 8,000.00 50,000.0065,000.00 1,611,300.00 $1,734,300.00$1,734,300.00 Totals REVENUE TOTALS 061 - Vehicle Replacement Fund Fund 061 - Vehicle Replacement Fund REVENUE Account ClassificationFundCharges For ServicesFines & ForfeitsInvestment IncomeReimbursementsOther RevenueOther Financing Sources .00 100.45 60,207.27 $60,307.72$60,307.72 Prior Year YTD 2551 25% +++ Rec'd Summary Listing % Used/ Through 03/31/18 .00 735.74 153,822.77 Transactions $154,558.51$154,558.51 Budget - YTD .00 YTD Prior Fiscal Year Activity Included 764.26 51,274.23 $52,038.49$52,038.49 Transactions .00.00.00 YTD $0.00$0.00 Encumbrances .00 309.93 17,091.41 $17,401.34$17,401.34 Transactions Current Month .00 Budget 20 1,500.00 Amended 205,097.00 $206,597.00$206,597.00 .00.00.00 $0.00$0.00 Budget Amendments .00 Budget Revenue Budget by Account Classification Report Adopted 1,500.00 205,097.00 $206,597.00$206,597.00 Totals REVENUE TOTALS 062 - Computer Replacement Fund Fund 062 - Computer Replacement Fund REVENUE Account ClassificationFundCharges For ServicesInvestment IncomeOther Financing Sources .00 1,719.13 337,189.75 1,640,903.04 $1,979,811.92$1,979,811.92 Prior Year YTD 253928 696 25% Rec'd Summary Listing % Used/ Through 03/31/18 7,885.57 (5,957.41) Transactions Budget - YTD5,397,233.101,138,492.79 $6,537,654.05$6,537,654.05 YTD Prior Fiscal Year Activity Included 5,114.436,957.41 444,035.21 Transactions 1,767,116.90 $2,223,223.95 $2,223,223.95 .00.00.00.00 YTD $0.00 $0.00 Encumbrances .00 2,048.24 585,652.24160,931.54 Transactions $748,632.02$748,632.02 Current Month Budget 21 1,000.00 Amended 13,000.00 7,164,350.001,582,528.00 $8,760,878.00$8,760,878.00 .00.00.00.00 $0.00$0.00 Budget Amendments Budget Revenue Budget by Account Classification Report Adopted 1,000.00 13,000.00 7,164,350.001,582,528.00 $8,760,878.00$8,760,878.00 Totals REVENUE TOTALS 063 - Risk Management Fund Fund 063 - Risk Management Fund REVENUE Account ClassificationFundCharges For ServicesInvestment IncomeReimbursementsOther Revenue .00 2,432,008.731,886,636.60 $4,318,645.33$4,318,645.33 Prior Year YTD -5 44 18% +++ Rec'd Summary Listing % Used/ Through 03/31/18 .00 Transactions Budget - YTD5,535,012.632,494,227.90 $8,029,240.53$8,029,240.53 .00 YTD Prior Fiscal Year Activity Included Transactions (274,012.63) 1,990,272.10 $1,716,259.47$1,716,259.47 .00.00.00 YTD $0.00$0.00 Encumbrances .00 Transactions $645,648.44$645,648.44 (646,297.31) 1,291,945.75 Current Month .00 Budget 22 Amended 5,261,000.004,484,500.00 $9,745,500.00$9,745,500.00 .00.00.00 $0.00$0.00 Budget Amendments .00 Budget Revenue Budget by Account Classification Report Adopted 5,261,000.004,484,500.00 $9,745,500.00$9,745,500.00 Totals REVENUE TOTALS 070 - Police Pension Fund Fund 070 - Police Pension Fund REVENUE Account ClassificationFundCharges For ServicesInvestment IncomeOther Revenue 2,923,188.111,523,385.67 $4,446,573.78$4,446,573.78 Prior Year YTD $29,763,780.14 9 40 23% Rec'd Summary Listing % Used/ Through 03/31/18 Transactions Budget - YTD4,630,330.572,425,016.84 $7,055,347.41$7,055,347.41 $95,203,095.51 YTD Prior Fiscal Year Activity Included 447,669.43 Transactions 1,614,283.16 $2,061,952.59$2,061,952.59 $30,686,753.49 .00.00 YTD $0.00$0.00 $0.00 Encumbrances Transactions $815,590.16$815,590.16 (227,815.53) 1,043,405.69 Current Month $16,942,358.58 Budget 23 Amended 5,078,000.004,039,300.00 $9,117,300.00$9,117,300.00 $125,889,849.00 .00.00 $0.00$0.00$0.00 Budget Amendments Budget Revenue Budget by Account Classification Report Adopted 5,078,000.004,039,300.00 $9,117,300.00$9,117,300.00 $125,889,849.00 Totals Grand Totals REVENUE TOTALS 071 - Fire Pension Fund Fund 071 - Fire Pension Fund REVENUE Account ClassificationFundInvestment IncomeOther Revenue .00.00.00.00 11,694.9028,940.7669,841.6849,501.28 128,009.26100,322.97131,821.86503,473.00 5,294,407.514,878,172.951,781,722.29 Prior Year YTD $12,977,908.46$12,977,908.46 30140 213623301525294243 26% +++ Rec'd Summary Listing % Used/ Through 03/31/18 .00 45,495.3315,614.6561,300.56 435,372.23536,791.00146,553.62750,000.00 283,990.79313,322.20683,456.00601,078.91 Transactions 9,300,966.256,059,037.77 Budget - YTD 21,366,189.23 $40,599,168.54$40,599,168.54 .00 .00.00 YTD Prior Fiscal Year Activity Included 213.35 1,454.672,475.44 50,053.6617,463.53 50,065.21 114,094.62104,288.80116,757.67 Transactions 5,538,847.775,193,267.751,794,012.13 $12,982,994.60$12,982,994.60 .00.00.00.00.00.00.00.00.00.00 YTD 19,072.1556,922.72 798,026.10104,356.33441,895.56 Encumbrances $1,420,272.86$1,420,272.86 .00.00.00 484.89213.35 1,101.453,480.82 49,214.9531,449.6034,754.7048,118.7317,726.81 507,591.53 Transactions 2,088,788.092,868,071.34 Current Month $5,650,996.26$5,650,996.26 .00 Budget Amended 46,950.0015,828.0063,776.00 568,539.00334,056.00417,611.00757,905.00683,456.00253,530.00750,000.00 8,651,076.001,060,438.00 Page 1 26,905,037.0014,494,234.00 $55,002,436.00$55,002,436.00 .00.00.00.00.00.00.00.00.00.00.00 Budget 3,780.009,000.00 11,800.00 162,438.00 $187,018.00$187,018.00 Amendments .00 Budget Adopted Expense Budget by Account Classification Report 46,950.0015,828.0054,776.00 568,539.00334,056.00417,611.00754,125.00683,456.00253,530.00898,000.00750,000.00 8,639,276.00 26,905,037.0014,494,234.00 $54,815,418.00$54,815,418.00 Totals EXPENSE TOTALS 001 - General Fund Fund 001 - General Fund EXPENSE Account ClassificationFundPersonal Services, Scheduled Salaries & WagesEmployee BenefitsOther Employee CostsPension BenefitsContractual ServicesUtilitiesInsuranceCommodities & SuppliesOther ExpendituresBuilding ImprovementsOffice EquipmentOther EquipmentDistribution SystemsInfrastructureInterfund Transfers .00.00.00.00.00.00 1,230.50 $1,230.50$1,230.50 Prior Year YTD 00 47 0% ++++++++++++ Rec'd Summary Listing % Used/ Through 03/31/18 .00.00 .00.00 3,164.50 Transactions 3,712,771.001,296,201.00 Budget - YTD $5,012,136.50 $5,012,136.50 .00.00.00.00 .00.00 YTD Prior Fiscal Year Activity Included 2,835.50 $2,835.50 $2,835.50 Transactions .00.00.00.00.00.00.00 YTD $0.00 $0.00 Encumbrances .00.00.00.00.00.00 802.50 $802.50$802.50 Transactions Current Month .00.00.00.00 Budget 6,000.00 Amended 3,712,771.001,296,201.00 Page 2 $5,014,972.00$5,014,972.00 .00.00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00.00.00 Budget Adopted 6,000.00 Expense Budget by Account Classification Report 3,712,771.001,296,201.00 $5,014,972.00$5,014,972.00 Totals EXPENSE TOTALS 002 - Debt Service Fund Fund 002 - Debt Service Fund EXPENSE Account ClassificationFundContractual ServicesOther ExpendituresBond PrincipalInterest ExpenseBank & Fiscal FeesInterfund TransfersOther Financing Uses .00.00.00.00.00 1,778.60 10,917.2434,937.1857,949.73 $105,582.75$105,582.75 Prior Year YTD 051 4014 5% ++++++++++++ Rec'd Summary Listing % Used/ Through 03/31/18 .00.00 .00.00 113,030.00315,000.00513,359.94 354,073.88 Transactions Budget - YTD1,648,020.50 $2,943,484.32$2,943,484.32 .00.00.00.00 .00.00 YTD Prior Fiscal Year Activity Included 8,003.897,950.50 58,173.12 $74,127.51$74,127.51 Transactions .00.00.00.00.00.00 YTD 1,150.00 75,000.0016,861.17 $93,011.17$93,011.17 Encumbrances .00.00.00.00.00.00 3,463.751,732.50 36,965.30 $42,161.55$42,161.55 Transactions Current Month .00.00.00.00 Budget Amended 188,030.00315,000.00538,225.00412,247.00 1,657,121.00 Page 3 $3,110,623.00$3,110,623.00 .00.00.00.00.00 Budget 58,225.00 110,000.00115,000.00478,121.00 $761,346.00$761,346.00 Amendments .00.00.00.00 Budget Adopted Expense Budget by Account Classification Report 78,030.00 200,000.00480,000.00412,247.00 1,179,000.00 $2,349,277.00$2,349,277.00 Totals EXPENSE TOTALS 020 - Capital Improvement Fund Fund 020 - Capital Improvement Fund EXPENSE Account ClassificationFundContractual ServicesOther ExpendituresLand ImprovementsBuilding ImprovementsOffice EquipmentMotor EquipmentOther EquipmentInfrastructureInterfund Transfers .00.00.00.00 12,517.25 $12,517.25$12,517.25 Prior Year YTD 02 2% +++++++++ Rec'd Summary Listing % Used/ Through 03/31/18 .00.00 .00 40,000.00 Transactions 3,707,685.69 Budget - YTD $3,747,685.69$3,747,685.69 .00.00.00 .00 YTD Prior Fiscal Year Activity Included 26,577.90 $26,577.90$26,577.90 Transactions .00.00.00.00 YTD 42,736.41 $42,736.41$42,736.41 Encumbrances .00.00.00.00 10,331.44 $10,331.44$10,331.44 Transactions Current Month .00.00.00 Budget Amended 40,000.00 3,777,000.00 Page 4 $3,817,000.00$3,817,000.00 .00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00.00 Budget Adopted Expense Budget by Account Classification Report 40,000.00 3,777,000.00 $3,817,000.00$3,817,000.00 Totals EXPENSE TOTALS 023 - Street Improvement Construc Fund Fund 023 - Street Improvement Construc Fund EXPENSE Account ClassificationFundContractual ServicesOther ExpendituresLand ImprovementsInfrastructureInterfund Transfers .00.00.00 27.90 388.86 7,828.00 $5,246.81$5,246.81 (2,997.95) Prior Year YTD 2000 1950 37% +++ Rec'd Summary Listing % Used/ Through 03/31/18 .00 2,550.005,306.004,306.00 121,396.00 155,775.00415,588.49 Transactions $704,921.49$704,921.49 Budget - YTD .00.00 .00.00 YTD Prior Fiscal Year Activity Included 2,900.001,000.00 29,222.50 $33,122.50$33,122.50 Transactions .00.00.00.00.00.00 YTD 383,134.01 $383,134.01$383,134.01 Encumbrances .00.00.00.00 2,900.001,000.00 14,048.50 $17,948.50$17,948.50 Transactions Current Month .00 Budget 2,550.005,306.005,306.00 Amended 124,296.00155,775.00827,945.00 Page 5 $1,121,178.00$1,121,178.00 .00.00.00.00.00 Budget 53,775.00 247,445.00 $301,220.00$301,220.00 Amendments .00 Budget Adopted 2,550.005,306.005,306.00 Expense Budget by Account Classification Report 124,296.00102,000.00580,500.00 $819,958.00$819,958.00 Totals EXPENSE TOTALS 024 - Flood Control Construction Fund Fund 024 - Flood Control Construction Fund EXPENSE Account ClassificationFundContractual ServicesUtilitiesCommodities & SuppliesOther ExpendituresOther EquipmentDistribution SystemsInfrastructure 61.52 624.44 7,382.018,702.21 49,505.0325,746.22 708,618.57 $800,640.00$800,640.00 Prior Year YTD 776 21242125 21% Rec'd Summary Listing % Used/ Through 03/31/18 440.89 1,225.33 90,640.3420,004.7538,367.92 213,961.43 Transactions 3,084,443.00 Budget - YTD $3,449,083.66$3,449,083.66 YTD Prior Fiscal Year Activity Included 98.67 33.11 6,668.251,593.59 57,037.5729,220.66 808,698.00 Transactions $903,349.85$903,349.85 .00.00.00.00.00.00 YTD 801.49 $801.49$801.49 Encumbrances .00 11.14 9,651.412,222.751,116.09 18,757.71 324,410.64 Transactions $356,169.74$356,169.74 Current Month 474.00 Budget 1,324.00 Amended 26,673.0040,763.00 270,999.00119,861.00 3,893,141.00 Page 6 $4,353,235.00$4,353,235.00 .00.00.00.00.00.00 Budget 5,065.00 $5,065.00$5,065.00 Amendments 474.00 Budget Adopted 1,324.00 Expense Budget by Account Classification Report 26,673.0040,763.00 270,999.00119,861.00 3,888,076.00 $4,348,170.00$4,348,170.00 Totals EXPENSE TOTALS 040 - Refuse Disposal Fund Fund 040 - Refuse Disposal Fund EXPENSE Account ClassificationFundPersonal Services, Scheduled Salaries & WagesEmployee BenefitsOther Employee CostsContractual ServicesUtilitiesInsuranceCommodities & Supplies .00.00 1,949.62 31,325.0738,274.69 $71,549.38$71,549.38 Prior Year YTD 4 641164 28% +++ Rec'd Summary Listing % Used/ Through 03/31/18 .00 127,876.25147,061.04125,104.55 892,786.50 Transactions Budget - YTD $1,292,828.34$1,292,828.34 .00 YTD Prior Fiscal Year Activity Included 2,821.50 58,966.3918,550.96 207,591.96 Transactions $287,930.81$287,930.81 .00.00 YTD 17,303.4935,051.00 166,268.36 $218,622.85$218,622.85 Encumbrances .00 2,821.50 19,338.8818,171.46 173,886.28 Transactions $214,218.12$214,218.12 Current Month .00 Budget Amended 353,111.00165,612.00350,000.00930,659.00 Page 7 $1,799,382.00$1,799,382.00 .00.00.00.00 Budget 330,659.00 $330,659.00$330,659.00 Amendments .00 Budget Adopted Expense Budget by Account Classification Report 353,111.00165,612.00350,000.00600,000.00 $1,468,723.00$1,468,723.00 Totals EXPENSE TOTALS 041 - Motor Fuel Tax Fund Fund 041 - Motor Fuel Tax Fund EXPENSE Account ClassificationFundContractual ServicesUtilitiesCommodities & SuppliesBuilding ImprovementsInfrastructure .00.00.00.00.00 50.00 5,844.56 10,534.0220,293.86 $36,722.44$36,722.44 Prior Year YTD 000 0% ++++++++++++++++++ Rec'd Summary Listing % Used/ Through 03/31/18 .00.00.00 .00.00.00 550.00 1,104.00 436,007.49 Transactions $437,661.49$437,661.49 Budget - YTD .00.00.00.00 .00.00.00.00 YTD Prior Fiscal Year Activity Included 1,004.51 $1,004.51$1,004.51 Transactions .00.00.00.00.00.00.00.00.00 YTD $0.00$0.00 Encumbrances .00.00.00.00.00.00.00.00 78.45 $78.45$78.45 Transactions Current Month .00.00.00.00.00.00 550.00 Budget 1,104.00 Amended 437,012.00 $438,666.00$438,666.00 Page 8 .00.00.00.00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00.00.00.00.00 550.00 Budget Adopted 1,104.00 Expense Budget by Account Classification Report 437,012.00 $438,666.00$438,666.00 Totals EXPENSE TOTALS 042 - CDBG Fund 042 - CDBG EXPENSE Account ClassificationFundPersonal Services, Scheduled Salaries & WagesEmployee BenefitsOther Employee CostsContractual ServicesCommodities & SuppliesOther ExpendituresLand ImprovementsBuilding ImprovementsInfrastructure .00.00.00.00 $0.00$0.00 Prior Year YTD 0 454866 47% Rec'd Summary Listing % Used/ Through 03/31/18 1,000.008,585.121,032.35 12,787.14 $23,404.61$23,404.61 Transactions Budget - YTD .00 YTD Prior Fiscal Year Activity Included 6,914.881,967.65 11,612.86 $20,495.39$20,495.39 Transactions .00.00.00.00 YTD $0.00$0.00 Encumbrances .00 414.88 5,056.561,662.77 $7,134.21$7,134.21 Transactions Current Month Budget 1,000.003,000.00 Amended 15,500.0024,400.00 $43,900.00$43,900.00 Page 9 .00.00.00.00 $0.00$0.00 Budget Amendments Budget Adopted 1,000.003,000.00 Expense Budget by Account Classification Report 15,500.0024,400.00 $43,900.00$43,900.00 Totals EXPENSE TOTALS 043 - Asset Seizure Fund Fund 043 - Asset Seizure Fund EXPENSE Account ClassificationFundOther Employee CostsContractual ServicesCommodities & SuppliesOther Equipment .00.00.00 $0.00$0.00 Prior Year YTD 00 0% +++ Rec'd Summary Listing % Used/ Through 03/31/18 .00 1,000.001,000.00 $2,000.00$2,000.00 Transactions Budget - YTD .00.00.00 YTD Prior Fiscal Year Activity Included $0.00$0.00 Transactions .00.00.00 YTD $0.00$0.00 Encumbrances .00.00.00 $0.00$0.00 Transactions Current Month .00 Budget 1,000.001,000.00 Amended $2,000.00$2,000.00 Page 10 .00.00.00 $0.00$0.00 Budget Amendments .00 Budget Adopted 1,000.001,000.00 Expense Budget by Account Classification Report $2,000.00$2,000.00 Totals EXPENSE TOTALS 044 - Federal Equitable Share Funds Fund 044 - Federal Equitable Share Funds EXPENSE Account ClassificationFundContractual ServicesBuilding ImprovementsOther Equipment .00.00 924.94917.23 $1,842.17$1,842.17 Prior Year YTD 00 67 48% +++ Rec'd Summary Listing % Used/ Through 03/31/18 .00 1,000.001,000.001,669.70 $3,669.70$3,669.70 Transactions Budget - YTD .00.00.00 YTD Prior Fiscal Year Activity Included 3,330.30 $3,330.30$3,330.30 Transactions .00.00.00.00 YTD $0.00$0.00 Encumbrances .00.00.00.00 $0.00$0.00 Transactions Current Month .00 Budget 1,000.001,000.005,000.00 Amended $7,000.00$7,000.00 Page 11 .00.00.00 Budget 4,000.00 $4,000.00$4,000.00 Amendments .00 Budget Adopted 1,000.001,000.001,000.00 Expense Budget by Account Classification Report $3,000.00$3,000.00 Totals EXPENSE TOTALS 045 - DUI Fine Fund Fund 045 - DUI Fine Fund EXPENSE Account ClassificationFundOther Employee CostsContractual ServicesOther EquipmentInterfund Transfers .00 712.06 3,703.034,350.005,480.00 $14,245.09$14,245.09 Prior Year YTD 0005 21 7% Rec'd Summary Listing % Used/ Through 03/31/18 500.00 5,000.00 15,000.0011,791.3228,511.40 $60,802.72$60,802.72 Transactions Budget - YTD .00.00.00 YTD Prior Fiscal Year Activity Included 3,208.681,488.60 $4,697.28$4,697.28 Transactions .00.00.00.00.00 YTD $0.00$0.00 Encumbrances .00.00.00.00.00 $0.00$0.00 Transactions Current Month 500.00 Budget 5,000.00 Amended 15,000.0015,000.0030,000.00 $65,500.00$65,500.00 Page 12 .00.00.00.00.00 $0.00$0.00 Budget Amendments 500.00 Budget Adopted 5,000.00 Expense Budget by Account Classification Report 15,000.0015,000.0030,000.00 $65,500.00$65,500.00 Totals EXPENSE TOTALS 046 - Foreign Fire Tax Board Fund Fund 046 - Foreign Fire Tax Board Fund EXPENSE Account ClassificationFundOther Employee CostsContractual ServicesInsuranceCommodities & SuppliesOther Equipment .00 58,149.36 $58,149.36$58,149.36 Prior Year YTD 4 4% +++ Rec'd Summary Listing % Used/ Through 03/31/18 .00 Transactions 1,466,183.13 Budget - YTD $1,466,183.13$1,466,183.13 .00 YTD Prior Fiscal Year Activity Included 56,816.87 $56,816.87$56,816.87 Transactions .00.00 YTD $0.00$0.00 Encumbrances .00 29,083.24 $29,083.24$29,083.24 Transactions Current Month .00 Budget Amended 1,523,000.00 $1,523,000.00$1,523,000.00 Page 13 .00.00 $0.00$0.00 Budget Amendments .00 Budget Adopted Expense Budget by Account Classification Report 1,523,000.00 $1,523,000.00$1,523,000.00 Totals EXPENSE TOTALS 048 - Business District Fund Fund 048 - Business District Fund EXPENSE Account ClassificationFundBond PrincipalInterest Expense .00.00.00.00.00.00.00.00.00 4,325.33 $4,325.33$4,325.33 Prior Year YTD 060000 4059 5% ++++++ Rec'd Summary Listing % Used/ Through 03/31/18 .00 .00 900.00 1,500.00 73,510.74 750,000.00260,000.00710,000.00183,419.00 Transactions 3,230,758.00 Budget - YTD $5,210,087.74$5,210,087.74 .00.00 .00.00.00.00.00 YTD Prior Fiscal Year Activity Included 600.00 18,000.86 101,609.00 Transactions $120,209.86$120,209.86 .00.00.00.00.00.00.00.00 YTD 89,988.4090,633.00 $180,621.40$180,621.40 Encumbrances .00.00.00.00.00.00.00.00 18,000.86 101,609.00 Transactions $119,609.86$119,609.86 Current Month .00.00 Budget 1,500.001,500.00 Amended 181,500.00750,000.00260,000.00710,000.00183,419.00 3,423,000.00 $5,510,919.00$5,510,919.00 Page 14 .00.00.00.00.00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00 Budget Adopted 1,500.001,500.00 Expense Budget by Account Classification Report 181,500.00750,000.00260,000.00710,000.00183,419.00 3,423,000.00 $5,510,919.00$5,510,919.00 Totals EXPENSE TOTALS 049 - Prospect and Main TIF District Fund 049 - Prospect and Main TIF District EXPENSE Account ClassificationFundOther Employee CostsContractual ServicesCommodities & SuppliesOther ExpendituresLand ImprovementsBuilding ImprovementsInfrastructureBond PrincipalInterest ExpenseInterfund Transfers .00.00.00.00.00.00.00 326.19 3,085.44 16,631.3025,236.5325,010.5250,330.1093,412.80 413,693.90193,547.38 1,348,627.27 $2,169,901.43$2,169,901.43 Prior Year YTD 005000 2224311912251312 15% +++++++++ Rec'd Summary Listing % Used/ Through 03/31/18 .00 .00.00 1,060.00 30,002.8571,206.4870,000.0010,000.00 701,749.14240,950.09115,000.00182,546.00 151,417.44287,354.29 Transactions 1,802,421.537,208,569.15 Budget - YTD5,415,273.75 $16,287,550.72$16,287,550.72 .00.00.00 .00.00.00.00.00 YTD Prior Fiscal Year Activity Included 13,596.1523,280.91 19,874.5623,735.5220,447.3622,265.07 515,726.47227,473.86 Transactions 1,435,638.56 $2,302,038.46$2,302,038.46 .00.00.00.00.00.00.00.00.00.00.00.00.00 YTD 9,150.00 22,167.35 241,674.29267,375.18 $540,366.82$540,366.82 Encumbrances .00.00.00.00.00.00.00.00 3,275.397,911.845,843.42 78,004.3012,693.7323,280.9117,750.92 170,812.64638,907.73 Transactions $958,480.88$958,480.88 Current Month .00.00.00 Budget 1,060.00 Amended 43,599.0094,942.0070,000.0010,000.00 929,223.00171,292.00329,969.00273,381.00115,000.00182,546.00 2,318,148.008,885,882.005,704,914.00 Page 15 $19,129,956.00$19,129,956.00 .00.00.00.00.00.00.00.00.00.00.00.00.00.00.00 Budget 101,000.00242,500.00 $343,500.00$343,500.00 Amendments .00.00.00 Budget Adopted 1,060.00 Expense Budget by Account Classification Report 43,599.0094,942.0070,000.0010,000.00 929,223.00171,292.00329,969.00172,381.00115,000.00182,546.00 2,318,148.008,885,882.005,462,414.00 $18,786,456.00$18,786,456.00 Totals EXPENSE TOTALS 050 - Water and Sewer Fund Fund 050 - Water and Sewer Fund EXPENSE Account ClassificationFundPersonal Services, Scheduled Salaries & WagesEmployee BenefitsOther Employee CostsContractual ServicesUtilitiesInsuranceCommodities & SuppliesOther ExpendituresBuildingsBuil ding ImprovementsOffice EquipmentOther EquipmentDistribution SystemsInfrastructureBond PrincipalInterest ExpenseInterfund Transfers .00.00.00.00.00 12.00 399.00 7,424.983,868.442,475.72 $14,180.14$14,180.14 Prior Year YTD 00 2225152568 32% +++++++++ Rec'd Summary Listing % Used/ Through 03/31/18 .00 .00.00 490.50552.00 7,506.00 30,045.4913,299.6352,068.2216,135.00 Transactions $120,096.84$120,096.84 Budget - YTD .00.00 .00.00.00.00 YTD Prior Fiscal Year Activity Included 163.50 8,631.514,405.373,483.69 $16,684.07$16,684.07 Transactions .00.00.00.00.00.00.00.00 YTD 5,521.09 33,865.00 $39,386.09$39,386.09 Encumbrances .00.00.00.00.00.00 54.50 2,886.741,663.462,668.65 $7,273.35$7,273.35 Transactions Current Month .00.00.00 654.00552.00 Budget 7,506.00 Amended 38,677.0017,705.0061,073.0050,000.00 $176,167.00$176,167.00 Page 16 .00.00.00.00.00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00.00 654.00552.00 Budget Adopted 7,506.00 Expense Budget by Account Classification Report 38,677.0017,705.0061,073.0050,000.00 $176,167.00$176,167.00 Totals EXPENSE TOTALS 051 - Village Parking System Fund Fund 051 - Village Parking System Fund EXPENSE Account ClassificationFundPersonal Services, Scheduled Salaries & WagesEmployee BenefitsContractual ServicesInsuranceCommodities & SuppliesOther ExpendituresBuildingsBuilding ImprovementsInfrastructu reInterfund Transfers .00.00.00.00 345.51 5,456.952,848.672,631.981,076.881,692.25 $14,052.24$14,052.24 Prior Year YTD 0 2225181025 23% ++++++++++++ Rec'd Summary Listing % Used/ Through 03/31/18 .00 .00.00 725.26 9,841.59 21,994.2389,522.1010,285.7510,585.00 (9,304.60) Transactions $133,649.33$133,649.33 Budget - YTD .00 .00.00.00 YTD Prior Fiscal Year Activity Included 241.74 6,280.773,255.414,362.971,101.254,009.60 $19,251.74$19,251.74 Transactions .00.00.00.00.00.00.00.00 YTD 5,295.00 15,012.93 $20,307.93$20,307.93 Encumbrances .00.00.00.00 80.58 544.18 2,124.831,249.132,164.584,009.60 $10,172.90$10,172.90 Transactions Current Month .00.00.00.00 967.00 Budget Amended 28,275.0013,097.0011,387.0010,585.00 108,898.00 $173,209.00$173,209.00 Page 17 .00.00.00.00.00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00.00.00 967.00 Budget Adopted Expense Budget by Account Classification Report 28,275.0013,097.0011,387.0010,585.00 108,898.00 $173,209.00$173,209.00 Totals EXPENSE TOTALS 052 - Parking System Revenue Fund Fund 052 - Parking System Revenue Fund EXPENSE Account ClassificationFundPersonal Services, Scheduled Salaries & WagesEmployee BenefitsContractual ServicesUtilitiesInsuranceCommodities & SuppliesOther ExpendituresBuildingsBuilding ImprovementsInterfund Transfers .00.00.00 918.51 2,712.138,295.85 99,645.3487,513.54 205,352.82 $404,438.19$404,438.19 Prior Year YTD 0 27341043307550 41% +++ Rec'd Summary Listing % Used/ Through 03/31/18 .00 303.80 3,676.07 2,314.433,864.00 62,266.35 740,245.29266,580.18 131,401.84 Transactions Budget - YTD $1,210,651.96$1,210,651.96 .00.00 YTD Prior Fiscal Year Activity Included 408.93298.20 1,010.57 21,321.05 268,186.71138,742.82155,658.68 Transactions $585,626.96$585,626.96 .00.00.00.00.00.00.00 YTD 25,212.60 234,718.48 $259,931.08$259,931.08 Encumbrances .00.00 179.00379.55298.20 9,937.94 73,225.3438,264.3556,291.16 Transactions $178,575.54$178,575.54 Current Month .00 602.00 Budget 4,085.003,325.003,864.00 Amended 405,323.00108,800.00521,779.00 1,008,432.00 $2,056,210.00$2,056,210.00 Page 18 .00.00.00.00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00 602.00 Budget Adopted 4,085.003,325.003,864.00 Expense Budget by Account Classification Report 405,323.00108,800.00521,779.00 1,008,432.00 $2,056,210.00$2,056,210.00 Totals EXPENSE TOTALS 060 - Vehicle Maintenance Fund Fund 060 - Vehicle Maintenance Fund EXPENSE Account ClassificationFundPersonal Services, Scheduled Salaries & WagesEmployee BenefitsOther Employee CostsContractual ServicesUtilitiesCommodities & SuppliesOther ExpendituresOffice EquipmentOther Equipment .00.00 996,223.99 $996,223.99$996,223.99 Prior Year YTD 10 10% ++++++ Rec'd Summary Listing % Used/ Through 03/31/18 .00.00 Transactions 2,664,407.70 Budget - YTD $2,664,407.70$2,664,407.70 .00.00 YTD Prior Fiscal Year Activity Included 13,212.95 $13,212.95$13,212.95 Transactions .00.00 YTD 280,825.35 $280,825.35$280,825.35 Encumbrances .00.00 10,869.30 $10,869.30$10,869.30 Transactions Current Month .00.00 Budget Amended 2,958,446.00 $2,958,446.00$2,958,446.00 Page 19 .00.00 Budget 572,446.00 $572,446.00$572,446.00 Amendments .00.00 Budget Adopted Expense Budget by Account Classification Report 2,386,000.00 $2,386,000.00$2,386,000.00 Totals EXPENSE TOTALS 061 - Vehicle Replacement Fund Fund 061 - Vehicle Replacement Fund EXPENSE Account ClassificationFundOther ExpendituresMotor EquipmentInterfund Transfers .00 3,566.84 $3,566.84$3,566.84 Prior Year YTD 12 12% +++ Rec'd Summary Listing % Used/ Through 03/31/18 .00 261,392.09 Transactions $261,392.09$261,392.09 Budget - YTD .00 YTD Prior Fiscal Year Activity Included 33,485.30 $33,485.30$33,485.30 Transactions .00 YTD 637.61 $637.61$637.61 Encumbrances .00 16,440.38 $16,440.38$16,440.38 Transactions Current Month .00 Budget Amended 295,515.00 $295,515.00$295,515.00 Page 20 .00.00 $0.00$0.00 Budget Amendments .00 Budget Adopted Expense Budget by Account Classification Report 295,515.00 $295,515.00$295,515.00 Totals EXPENSE TOTALS 062 - Computer Replacement Fund Fund 062 - Computer Replacement Fund EXPENSE Account ClassificationFundOther ExpendituresOffice Equipment .00.00 9,800.002,027.08 2,626,784.43 $2,638,611.51$2,638,611.51 Prior Year YTD 03 40 39% ++++++ Rec'd Summary Listing % Used/ Through 03/31/18 .00 .00 27,000.0019,404.50 Transactions 5,177,297.90 Budget - YTD $5,223,702.40$5,223,702.40 .00.00 .00 YTD Prior Fiscal Year Activity Included 595.50 Transactions 3,389,040.10 $3,389,635.60$3,389,635.60 .00.00.00.00.00 YTD $0.00$0.00 Encumbrances .00.00.00 595.50 714,249.61 Transactions $714,845.11$714,845.11 Current Month .00.00 Budget Amended 27,000.0020,000.00 8,566,338.00 $8,613,338.00$8,613,338.00 Page 21 .00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00 Budget Adopted Expense Budget by Account Classification Report 27,000.0020,000.00 8,566,338.00 $8,613,338.00$8,613,338.00 Totals EXPENSE TOTALS 063 - Risk Management Fund Fund 063 - Risk Management Fund EXPENSE Account ClassificationFundContractual ServicesInsuranceCommodities & SuppliesOther EquipmentInterfund Transfers .00.00.00 795.00 4,905.85 1,189,124.73 $1,194,825.58$1,194,825.58 Prior Year YTD 3000 25 24% +++ Rec'd Summary Listing % Used/ Through 03/31/18 .00 100.00 15,000.0010,000.00 160,513.18 Transactions 3,769,295.26 Budget - YTD $3,954,908.44$3,954,908.44 .00.00 .00.00 YTD Prior Fiscal Year Activity Included 4,986.82 Transactions 1,264,259.74 $1,269,246.56$1,269,246.56 .00.00.00.00.00.00 YTD $0.00$0.00 Encumbrances .00.00.00.00 2,449.80 422,313.17 Transactions $424,762.97$424,762.97 Current Month .00 100.00 Budget Amended 15,000.0010,000.00 165,500.00 5,033,555.00 $5,224,155.00$5,224,155.00 Page 22 .00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00 100.00 Budget Adopted Expense Budget by Account Classification Report 15,000.0010,000.00 165,500.00 5,033,555.00 $5,224,155.00$5,224,155.00 Totals EXPENSE TOTALS 070 - Police Pension Fund Fund 070 - Police Pension Fund EXPENSE Account ClassificationFundPension BenefitsContractual ServicesInsuranceCommodities & SuppliesOther ExpendituresOffice Equipment .00.00 795.00 18,005.00 1,321,928.91 $1,340,728.91$1,340,728.91 Prior Year YTD $22,866,488.37 000 2613 26% Rec'd Summary Listing % Used/ Through 03/31/18 100.00 15,000.0010,000.00 115,571.39 Transactions 4,146,284.73 Budget - YTD $4,286,956.12$4,286,956.12 $99,096,433.53 .00.00 .00 YTD Prior Fiscal Year Activity Included 17,928.61 Transactions 1,455,325.27 $1,473,253.88$1,473,253.88 $23,619,928.40 .00.00.00.00.00 YTD $0.00$0.00 Encumbrances $3,480,655.07 .00.00.00 3,405.00 487,148.31 Transactions $490,553.31$490,553.31 Current Month $9,260,507.61 100.00 Budget Amended 15,000.0010,000.00 133,500.00 5,601,610.00 $5,760,210.00$5,760,210.00 Page 23 $126,197,017.00 .00.00.00.00.00 $0.00$0.00 Budget Amendments $2,505,254.00 100.00 Budget Adopted Expense Budget by Account Classification Report 15,000.0010,000.00 133,500.00 5,601,610.00 $5,760,210.00$5,760,210.00 $123,691,763.00 Totals Grand Totals EXPENSE TOTALS 071 - Fire Pension Fund Fund 071 - Fire Pension Fund EXPENSE Account ClassificationFundPension BenefitsContractual ServicesInsuranceCommodities & SuppliesOther Expenditures Village of Mount Prospect Mount Prospect, Illinois INTEROFFICE MEMORANDUM TO:VILLAGE PRESIDENT AND BOARD OF TRUSTEES FINANCE COMMISSION FROM:FINANCE DIRECTOR DATE:APRIL 12, 2018 SUBJECT:MONTHLY FINANCIALREPORT MARCH2018 Attached hereto are the cash position and investment statements of the Village for the month ended March 31, 2018of the month end date noted and are intended to supplement the budget revenue and expenditure summary and listing of bills you enterprise funds and trust and by fund type. The third statement presents the list of investments again broken down by governmental and enterprise funds and trust and agency funds. It is important to note that although we have included the trust and agency funds in the cash position report, these are not funds accessible for Village operations. They are restricted for pension and escrow funding only. Please read the summary that follows for further detail on the cash position of the Village. Cash and Investment Position Report All Funds (page4) This reportprovides adetailedsummary of cashandinvestments forthe Village broken outby governmental and enterprisefunds and trustand agency funds.Governmental funds include the General Fund,Special Revenue Funds,DebtServiceFunds,Capital ProjectFunds andInternal Service Funds. The Enterprise Funds consist of theWater/Sewer Fund andtwo (2) Parking Funds. includetheEscrowDepositandFlexcompEscrowFunds.TheEscrowDepositFundaccountsfor refundabledepositsheldbytheVillageto ensurecompletionofpublicimprovements.TheFlexcomp Escrow Fund accounts for employee payroll deductions pursuant to a Section 125 flexible compensation plan. GovernmentalandEnterpriseFunds-CashandcashequivalentsatFebruary28was$36.5million. During March, cash receipts totaled $11,184,132 and investment income was $79,226.Reductions in cash andcashequivalentsduringMarchtotaled$5,236,875.Ofthisamount,paymentsto vendorswere $3,619,713 and employee payroll expenses were $1,595,803.There was also a net increase in cash due to investment activities of $2,507,535. Inflows resulting from interfund activity totaled $142,648 while other reductions to cash totaled $21,359.Cash and cash equivalents at March 31 were $45.2 million. InvestmentsintheGovernmentalandEnterpriseFundsat February28were$12,493,750.Duringthe monthofMarch, investmentincomewas($72,652).Therewasalsoa netdecreaseincashdueto investment activities of $2,507,535. The Notes and accounted for in the Governmental and Enterprise Funds reside in multiple Funds investing surplus funds above what is needed for cash flow purposes. Total investments at March 31 are $ million. Total cashand investments forGovernmental andEnterprise Funds at February 28 were$49,034,854. Cash and investments atMarch 31 totaled $55,131,334. This isanincrease of$6,096,480 for the month. Monthly Financial Report March 2018 April 12, 2018 Page 2 Trust and Agency Funds - Cash and cash equivalents at February 28 was $3.2 million. During March, cash receipts totaled $2,419,343. Investment income for the month was $115,175. There was also a net increase in cash due to investment activities of $540,418 while outflows due to Interfund activity totaled $142,648. Reductions in cash and cash equivalents during March totaled $972,295. Of this amount, payments to vendors were $135,084 and employee payroll and related expenses were $837,211. Other disbursements totaled $1,901. Cash and cash equivalents at March 31 were $5.1 million. Total investments at March 31 were $134,180,860, a decrease of $1,508,606 from February 28. There were investment losses of $968,189 and a net transfer from cash of $540,418 that accounted for the change. Total cash and investments for Trust and Agency Funds at February 28 were $138,877,021. Cash and investments at March 31 totaled $139,326,507. This is an increase of $449,486. Summary of Cash Activity by Fund Type (page 5) This report provides a breakdown of the cash activity for the month broken down by fund type. This breakdown is useful in identifying where the activity (receipts and disbursements) is occurring. There are times during the year when activity in certain funds such as the capital improvement and special revenue funds is higher than normal. This will distort the financial picture of some of the other components of the governmental funds such as the General Fund which tends to be more level and predictable in terms of spending and receipt of revenue. Each month the report will provide detail explanation on activity of the General Fund, the VilDetail on the activity of the General Fund is highlighted below. General Fund Cash and cash equivalents at February 28 totaled $11,240,848. During March, cash receipts totaled $7,054,542, and investment income was $56,599. Significant cash receipts include property taxes, sales and income taxes. Receipts of Property taxes related to the 2017 levy continued to be received in March. A total of $2,253,249 was received in the General Fund during the month. The first installment expected to be received . Sales tax revenues for the month totaled $1,994,062. This is the amount generated from the 1% state portion and quarter-cent home rules sales tax. Sales taxes received in March are for December sales as there is a three-month lag in getting this distribution from the state. State income tax receipts for March totaled $299,533 and were for the month of February. Disbursements from the General Fund for March included payments to vendors of $1,359,480, payments for employee wages and benefits of $1,416,748 and other disbursements of $10,080. There was also a net decrease in cash from Interfund transfers totaling $337,513. Cash and cash equivalents at March 31 were $15,228,168, an increase of $3,987,320 from February 28. In addition, investments consisting of certificates of deposit totaling $3,683,628 bring total cash and investments for the General Fund to $18,911,796. Statement of Investments (page 6) This report provides a breakdown of investments by trust and agency funds and governmental and enterprise funds. The report also provides a fund-by-fund breakdown of the investments. Government and Enterprise Funds - Investments for the governmental and agency funds are made up of Certificates of Deposit. At March 31, there was a total of $9,913,563 and various governmental notes. These notes and monies available from the governmental and enterprise funds. A detail list of holdings is included with this report. H:\\ACCT\\Treasurer's Report\\2018\\Monthly Cash Position Report - March 2018.docx Monthly Financial Report March 2018 April 12, 2018 Page 3 Trust and Agency Funds The investments for the trust and agency funds are made up of certificates of will generally have maturities of between 30 and 120 days. Most of the reserves for this fund are invested in the more liquid money market account due to the nature of the deposit. At March 31, there was a total of $134.2 million invested in a combination of fixed income and equity instruments. A detail list of holdings is included with this report. Escrow pension funds is governed by an Investment Policy adopted by each Pension Board. Investments for the Police and Firefighter Pension Funds consist of various fixed income securities as well as equity mutual fund accounts. Wells Fargo is the third-party holder of the fixed income securities. The funds are managed by three investment management firms, Galliard, Segall Bryant and Mesirow Financial. Segall Bryant holds approximately half of the fixed income investments for the two pension funds while Galliard and Mesirow manage the balance of fixed income investments for these two funds. Each manager maintains a small portion of their portfolio in cash to help facilitate liquidity and trading. Investments in equities consist of mutual funds spread across various sectors (small, mid and large-cap stocks) as well as investment philosophies (value, core and growth). The funds also invest a small amount in international stocks. Each year the investment mix is evaluated for optimal diversification to meet pension fund investment policy goals and objectives. Equity investments held by the Police Pension Fund are managed by Sawyer Falduto Asset Management. A breakdown of where pension funds are invested is included with this report. Conclusion month end date. Using this report, we are able to provide trend information to support cash management This report is provided to the Village Board and Finance Commission on a monthly basis. Please do not hesitate to contact me with any questions. David O. Erb Finance Director H:\\ACCT\\Treasurer's Report\\2018\\Monthly Cash Position Report - March 2018.docx VILLAGE OF MOUNT PROSPECT Preliminary Cash and Investment Position Report - All Funds For the Month Ended March 31, 2018 GOVERNMENTAL AND ENTERPRISE FUNDS Cash and CashTotal Cash and EquivalentsInvestmentsInvestments Balance at February 28, 2018$36,541,104.70$12,493,749.66$49,034,854.36 Cash receipts11,184,132.2711,184,132.27 Investment income79,226.49(72,651.92)6,574.57 Transfers from investments to cash2,507,535.00(2,507,535.00)- Transfers to investments from cash--- Interfund activity142,647.78142,647.78 Disbursements: Accounts payable(3,619,712.89)(3,619,712.89) Payroll(1,595,803.39)(1,595,803.39) Other(21,359.00)(21,359.00) Balance at March 31, 2018$45,217,770.96$ 9,913,562.74$55,131,333.70 TRUST AND AGENCY FUNDS * Cash and CashTotal Cash and EquivalentsInvestmentsInvestments Balance at February 28, 2018$3,187,554.54$135,689,466.36$138,877,020.90 Cash receipts2,419,343.282,419,343.28 Investment income (loss)115,175.13(968,188.66)(853,013.53) Transfers from investments to cash2,107,237.21(2,107,237.21)- Transfers to investments from cash(1,566,819.37)1,566,819.37- Interfund activity(142,647.78)(142,647.78) Disbursements: Accounts payable(135,083.65)(135,083.65) Payroll(771,657.01)(771,657.01) Flex spending(65,553.86)(65,553.86) Other(1,900.94)(1,900.94) Balance at March 31, 2018$5,145,647.55$134,180,859.86$139,326,507.41 * Assets are restricted in purpose and do not represent discretionary assets of the government. 4 5 VILLAGE OF MOUNT PROSPECT STATEMENT OF INVESTMENTS As of March 31, 2018 GOVERNMENTAL AND ENTERPRISE FUNDS MaturityPurchaseFinancial InvestmentCUSIP/Market DateDateInstitutionDescriptionFDIC #Net YieldValue GENERAL FUND (001) 06/29/1812/28/17Freddie MacAgency Notes3134G9TH05.000%1,208,991.60 12/31/1812/28/17U.S. Treasury NoteTreasury Note912828A751.500%1,238,606.02 12/13/1912/28/17Federal Home Loan BankAgency Notes3130A0JR22.375%1,236,029.99 3,683,627.61 WATER AND SEWER FUND (050) 05/31/1812/28/17U.S. Treasury NoteTreasury Note912828VE71.000%2,498,106.34 2,498,106.34 VEHICLE REPLACEMENT FUND (061) 05/30/1912/28/17Freddie MacAgency Notes3137EADG11.750%1,244,178.75 06/12/2012/28/17Federal Home Loan BankAgency Notes313383MB41.875%1,235,793.75 12/11/2012/28/17Federal Home Loan BankAgency Notes3130A3UQ51.875%1,231,806.25 3,711,778.75 RISK MANAGEMENT FUND (063) 03/06/1903/06/17Mount Prospect State BankCertificate of Deposit3540580.250%20,050.04 20,050.04 TOTAL GOVERNMENTAL AND ENTERPRISE FUNDS$ 9,913,562.74 TRUST AND AGENCY FUNDS * MaturityPurchaseFinancial InvestmentCUSIP/InterestMarket DateDateInstitutionDescriptionAcct #Rate %Value POLICE PENSION FUND (070) VariousVariousWells FargoWells Fargo InvestmentsVariousVarious$ 22,965,763.88 VariousVariousVariousMutual Fund InvestmentsVariousVarious46,473,240.92 69,439,004.80 FIRE PENSION FUND (071) Various5/26/2015Principal Life Insurance CompanyGroup Annuity Contract8-10810Variable3,224,701.36 VariousVariousWells FargoWells Fargo InvestmentsVariousVarious22,273,519.21 VariousVariousVariousMutual Fund InvestmentsVariousVarious39,243,634.49 64,741,855.06 TOTAL TRUST AND AGENCY FUND INVESTMENTS$ 134,180,859.86 * Assets are restricted in purpose and do not represent discretionary assets of the government. 6