The URL can be used to link to this page

Home My WebLink About02 - February 2025 Monthly Financial ReportVILLAGE OAK BROOKOF MONTHLY FINANCIAL REPORTS FEBRUARY 2025 Estimated YTD YTD Net Fund Ending YTD YTD Increase Fund Balance Governmental Funds Revenues Expenditures (Decrease)(Deficit) General Fund (Major Fund)5,349,817$ 5,196,935$ 152,882$ 43,530,359$ Main operating fund of the Village. Hotel Fund (Major Fund)187,383$ 94,176$ 93,206$ 5,439,821$ Collects and spends resources from the 3% hotel/motel tax. Motor Fuel Tax Fund 75,542$ 7,874$ 67,668$ 2,459,884$ Collects and spends resources from the State motor fuel tax. Infrastructure Fund (Major Fund)1,452,286$ 678,989$ 773,296$ 15,197,804$ Accounts for construction and maintenance of roadways, drainage, and safety path systems. Enterprise Funds Water Fund (Major Fund)1,435,057$ 1,039,884$ 395,173$ 22,313,816$ Collects user fees for the distribution of water and maintenance of infrastructure. Sports Core Fund (Major Fund)455,578$ 355,374$ 100,204$ 3,004,092$ Accounts for revenues and expenses relating to administration, programs, food and beverage operations, and golf course. Internal Service Funds Insurance Fund 271,336$ 539,009$ (267,673)$ 129,956$ Accounts for the Village's health insurance costs and the related contributions from the Village, employees, retirees, and other agencies. Garage Fund 147,654$ 181,640$ (33,986)$ 409,677$ Accounts for the maintenance of the Village's vehicle fleet and the related departmental reimbursements. Equipment Replacement Fund 242,109$ 87,615$ 154,494$ 3,772,180$ Accounts for the replacement of the Village's vehicle fleet and the related departmental contributions. Further information on the Village's major funds (as indicated above) can be found on the proceeding pages. Executive Summary on Village Funds Through February 28, 2025 2/28/25 2/28/25 2/28/24 2/28/25 YTD % of YTD 2025 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax 2,816,895$ 3,202,106 2,875,000$ 111.4%17,250,000$ 385,210$ State Income Tax 253,389 271,031 216,667 125.1%1,300,000 17,642 Replacement Tax 94,934 65,385 91,667 71.3%550,000 (29,549) Road & Bridge Tax 6,361 - 5,833 0.0%35,000 (6,361) Local Use Tax 57,071 41,433 53,167 77.9%319,000 (15,638) Cannabis Use Tax 2,175 2,227 2,083 106.9%12,500 52 Grants 151,500 4,180 28,520 14.7%171,120 (147,320) Utility/Telecom. Tax 603,955 537,580 625,000 86.0%3,750,000 (66,376) Licenses and Permits 588,925 239,280 457,927 52.3%2,747,560 (349,645) Charges for Services 485,242 379,176 456,342 83.1%2,738,050 (106,066) Investment Interest 287,390 159,372 166,667 95.6%1,000,000 (128,018) Miscellaneous Income 109,003 112,872 101,037 111.7%606,221 3,868 Total Operating Revenues 5,456,841$ 5,014,641$ 5,079,909$ 98.7%30,479,451$ (442,200)$ OPERATING EXPENDITURES Personnel 2,860,934$ 3,568,473$ 3,964,543$ 90.0%23,787,259$ 707,539$ Materials and Supplies 89,302 81,789 114,909 71.2%689,454 (7,513)$ Operation and Contract 1,311,450 1,523,577 1,218,754 125.0%7,312,523 212,127$ Other Expenditures 2,123 2,117 1,650 128.3%9,900 (7)$ Capital Outlay 14,755 20,979 102,096 20.5%612,575 6,225$ Total Operating Expenditures 4,278,563$ 5,196,935$ 5,401,952$ 96.2%32,411,711$ 918,371$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 1,178,278$ (182,294)$ (322,043)$ 56.6%(1,932,260)$ (1,360,572)$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A -$ -$ Transfers Out N/A - Reimbursements From Other Funds 145,990 335,176 335,177 100.0%2,011,062 189,186 Reimbursements To Other Funds - - - N/A - - Sports Core Loan N/A - - Total Interfund Transactions 145,990$ 335,176$ 335,177$ 100.0%2,011,062$ 189,186$ NET FUND INCREASE (DECREASE)1,324,268$ 152,882$ 13,134$ 78,802$ (1,171,386)$ *Includes the collection of Income Tax, Use Tax, Road & Bridge Tax, Personal Property Replacement Tax, and Cannabis Use Tax. Village of Oak Brook General Fund Financial Update For the Period Ending February 28, 2025 2/28/25 2/28/25 2/28/24 2/28/25 YTD % of YTD 2025 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Hotel Tax 237,890$ 163,172$ 233,333$ 69.9%1,400,000$ (74,718)$ Investment Interest 27,376 24,210 10,000 242.1%60,000 (3,165) Loan Interest - - - N/A - - Miscellaneous - - 84,083 504,500 - Total Operating Revenues 265,266$ 187,383$ 327,417$ 57.2%1,964,500$ (77,883)$ EXPENDITURES Personnel -$ 20,822$ 23,478$ 140,868$ -$ Operation and Contract 1,184 20,504 162,661 0.13 975,965 19,320.40 Capital Outlay 12 18,553 98,958 18.7%593,750 18,541 Total Expenditures 1,196$ 59,878$ 261,619$ 22.9%1,710,583$ 37,861$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 264,070$ 127,504$ 42,319$ 301.3%253,917$ (115,745)$ INTERFUND TRANSACTIONS Transfer Out -$ -$ -$ N/A -$ -$ Reimbursements to Other Funds - (34,298) (34,299) 100.0%(205,791) (34,298) Total Interfund Transactions -$ (34,298)$ (34,299)$ 100.0%(205,791)$ (34,298)$ NET FUND INCREASE (DECREASE)264,070$ 93,206$ 8,021$ 48,126$ (150,043)$ Note - Expenditures are recorded in program 171. Village of Oak Brook Hotel Tax Fund Financial Update For the Period Ending February 28, 2025 2/28/25 2/28/25 2/28/24 2/28/25 YTD % of YTD 2025 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Non-Home Rule Sales Tax 1,220,744$ 1,358,019$ 1,165,833$ 116.5%6,995,000$ 137,275$ Charges for Services - - - N/A - -$ Investment Interest 120,704 94,267 66,667 141.4%400,000 (26,437) Grants - - - N/A - - Miscellaneous 580 - - N/A - (580) Total Operating Revenues 1,342,028$ 1,452,286$ 1,232,500$ 117.8%7,395,000$ 110,258$ OPERATING EXPENDITURES Personnel 27,726$ 13,213$ -$ N/A -$ (14,512)$ Materials and Supplies 35 - 7,967 0.0%47,800 (35) Operation and Contract 147,917 179,125 381,369 47.0%2,288,213 31,208 Other Expenditures 5,334 - - N/A (5,334) Capital Outlay 133,415 369,667 751,862 49.2%4,511,174 236,252 Total Operating Expenditures 314,427$ 562,005$ 1,141,198$ 49.2%6,847,187$ 247,579$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 1,027,601$ 890,280$ 91,302$ 975.1%547,813$ (137,321)$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A -$ -$ Reimbursements From Other Funds - - 33,333 0.0%200,000 - Reimbursements To Other Funds - (116,984) (116,984) 100.0%(701,906) (116,984) Total Interfund Transactions -$ (116,984)$ (83,651)$ 139.8%(501,906)$ (116,984)$ NET FUND INCREASE (DECREASE)1,027,601$ 773,296$ 7,651$ 45,907$ (254,305)$ Village of Oak Brook Infrastructure Fund Financial Update For the Period Ending February 28, 2025 2/28/25 2/28/25 2/28/24 2/28/25 YTD % of YTD 2025 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Plan Review Fees 152$ 150$ 88$ 171.4%525$ (2)$ Building/Inspection Fees - - 250 0.0%1,500 - Water Sales 1,229,273 1,226,582 1,884,866 65.1%11,309,195 (2,691) Unmetered Sales 1,200 1,925 10,000 19.3%60,000 725 Water Connection Fees 13,110 12,420 12,333 100.7%74,000 (690) Fire Service Charge - - - N/A - - Meter Charges 3,080 5,058 2,500 202.3%15,000 1,978 Special Services - - 2,500 0.0%15,000 - Investment Interest 215,030 158,806 116,667 136.1%700,000 (56,225) Proceeds from Property Sale - - - N/A - - Miscellaneous 18,862 30,116 12,500 240.9%75,000 11,254 Total Operating Revenues 1,480,707$ 1,435,057$ 2,041,703$ 70.3%12,250,220$ (45,650)$ OPERATING EXPENDITURES Personnel 109,334$ 87,733$ 109,546$ 80.1%657,277$ (21,602)$ Materials and Supplies 23,576 21,849 19,945 109.5%119,671 (1,727) Operation and Contract 516,920 747,625 1,150,593 65.0%6,903,559 230,705 Capital Outlay 72,814 84,476 1,292,365 6.5%7,754,190 11,662 Total Expenditures 722,644$ 941,682$ 2,572,449$ 36.6%15,434,696$ 219,038$ Surplus (Deficit) of Revenues Over Expenditures 758,063$ 493,375$ (530,746)$ -93.0%(3,184,476)$ (264,688)$ INTERFUND TRANSACTIONS Reimbursements To Other Funds -$ (98,202)$ (98,200)$ 100.0%(589,202)$ (98,202)$ Total Interfund Transactions -$ (98,202)$ (98,200)$ 100.0%(589,202)$ (98,202)$ Fund Increase/(Decrease) - Budgetary Basis 758,063$ 395,173$ (628,946)$ (3,773,678)$ (362,890)$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay 72,814$ 84,476$ Depreciation Expense (47,917) (95,833) IMRF Pension Expense (3,750) (7,500) OPEB Expense (2,500) (5,000) Total GAAP Adjustments 18,647$ (23,858)$ Fund Increase/(Decrease) - GAAP Basis 776,710$ 371,315$ *Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year. Village of Oak Brook Water Fund Financial Update For the Period Ending February 28, 2025 Village of Oak Brook Monthly Operating Statement Sports Core Fund Consolidated Presentation For the Period Ending February 28, 2025 2/28/25 2/28/25 2/28/25 YTD % of YTD 2025 2/28/24 Difference B&T Recreation Field Clubhouse Golf YTD Amended Amended Adopted YTD Prior Operations Operations Operations Club Total Budget Budget Budget Total Year OPERATING REVENUES Memberships 253,758$ -$ -$ 116,325$ 370,083$ 159,934$ 231.4%959,607$ 21,200$ 348,883$ Greens Fees - - - - - 310,998 0.0%1,865,990 - - Pro Shop Sales - - - 1,401 1,401 30,000 4.7%180,000 3,986 (2,586) Golf Lessons - - - 2,250 2,250 7,500 30.0%45,000 - 2,250 Driving Range Fees - - - 28,883 28,883 110,230 26.2%661,382 3,920 24,963 Golf Surcharge - - - - - 37,500 0.0%225,000 Rentals - 5,000 24,032 5,650 34,682 183,667 18.9%1,102,000 12,053 22,629 Programs/User Fees 4,750 - - - 4,750 34,300 13.8%205,800 - 4,750 Food Sales - - - 480 480 9,630 5.0%57,780 - 480 Beverage Sales - - - 884 884 13,147 6.7%78,880 - 884 Grants - - - - - - N/A - - - Other Revenue 2,892 - - 2,605 5,497 16,333 33.7%98,000 426 5,071 Total Operating Revenues 261,400$ 5,000$ 24,032$ 158,477$ 448,910$ 913,240$ 49.2%5,479,439$ 41,585$ 407,324$ OPERATING EXPENDITURES Personnel 29,662$ -$ -$ 103,123$ 132,784$ 275,177$ 48.3%1,651,064$ 97,642$ 35,142$ Materials & Supplies 2,987 - 14 13,822 16,824 71,005 23.7%426,030 12,365 4,458 Operational & Contractual 75,636 1,092 5,663 21,016 103,407 201,951 51.2%1,211,708 167,799 (64,393) Other - - - - - - N/A - - - Capital 10,000 - - - 10,000 261,659 3.8%1,569,954 11,108 (1,108) Total Operating Expenditures 118,285$ 1,092$ 5,677$ 137,961$ 263,014$ 809,792$ 32.5%4,858,755$ 288,915$ (25,901)$ B&T Administration Overhead Allocation*109,339$ (9,292)$ (20,149)$ (79,898)$ 0$ -$ N/A -$ -$ 0$ Operating Revenues Over (Under) Expenditures 252,455$ (5,384)$ (1,794)$ (59,382)$ 185,896$ 103,447$ 179.7%620,684$ (247,329)$ 433,225$ INTERFUND TRANSACTIONS Reimbursement From Infrastructure Fund -$ -$ -$ -$ -$ -$ N/A -$ -$ -$ Reimbursement From Water Fund 6,668 - - - 6,668 6,667 100.0%40,000 - 6,668 Reimbursement To General Fund (92,360) - - - (92,360) (92,351) 100.0%(554,106) - (92,360) Total Interfund Transactions (85,692)$ -$ -$ -$ (85,692)$ (85,684)$ 100.0%(514,106)$ -$ (85,692)$ Total Revenues Over (Under) Expenditures - Budgetary Basis 166,763$ (5,384)$ (1,794)$ (59,382)$ 100,204$ 17,763$ 106,578$ (247,329)$ 347,533$ *Overhead allocation is comprised of salaries, business forms, liability insurance, building & grounds maintenance and bank service fees in Program 811 - Sports Core General Operations distributed to various Sports Core Programs on a % basis. **Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year. Village of Oak Brook Monthly Operating Statement Bath & Tennis Club Recreation Operations For the Period Ending February 28, 2025 2/28/25 2/28/25 822 2/28/25 YTD % of YTD 2025 2/28/24 Difference 811 812 813 Poolside YTD Adopted Amended Adopted YTD Prior B&T Admin Swimming Tennis Café Total Budget Budget Budget Total Year OPERATING REVENUES Memberships -$ 249,920$ 3,838$ -$ 253,758$ 83,797$ 302.8%502,782$ 21,200$ 232,558$ Programs/User Fees - 4,750 - - 4,750 34,300 13.8%205,800 - 4,750 Food Sales - - - - - 1,338 0.0%8,030 - - Beverage Sales - - - - - 605 0.0%3,630 - - Grants - - - - - - N/A - - - Other Revenue 2,392 - - 500 2,892 15,167 19.1%91,000 295 2,597 Total Operating Revenues 2,392$ 254,670$ 3,838$ 500$ 261,400$ 135,207$ 193.3%811,242$ 21,495$ 239,905$ OPERATING EXPENDITURES Personnel 29,541$ 121$ -$ -$ 29,662$ 48,436$ 61.2%290,617$ -$ 29,662$ Materials & Supplies - 2,975 12 - 2,987 4,693 63.7%28,155 193 2,795 Operational & Contractual 61,191 14,445 - - 75,636 107,225 70.5%643,347 98,863 (23,227) Other - - - - - - N/A - - - Capital - 10,000 - - 10,000 119,817 8.3%718,900 - 10,000 Total Operating Expenditures 90,732$ 27,540$ 12$ -$ 118,285$ 280,170$ 42.2%1,681,019$ 99,055$ 19,229$ B&T Administration Overhead Allocation*138,668$ (23,087)$ (4,574)$ (1,667)$ 109,339$ 109,339 100.0%656,036$ -$ 109,339$ Operating Revenues Over (Under) Expenditures 50,328$ 204,042$ (749)$ (1,167)$ 252,455$ (35,624)$ -708.7%(213,742)$ (77,560)$ 330,015$ INTERFUND TRANSACTIONS Reimbursement From Infrastructure Fund -$ -$ -$ -$ -$ -$ N/A -$ -$ -$ Reimbursement From Water Fund 6,668 - - - 6,668 6,667 100.0%40,000 - 6,668 Reimbursement To General Fund (92,360) - - - (92,360) (92,351) 100.0%(554,106) - (92,360) Total Interfund Transactions (85,692)$ -$ -$ -$ (85,692)$ (85,684)$ 100.0%(514,106)$ -$ (85,692)$ Total Revenues Over (Under) Expenditures - Budgetary Basis (35,364)$ 204,042$ (749)$ (1,167)$ 166,763$ (121,308)$ (727,848)$ (77,560)$ 244,323$ *Overhead allocation is comprised of salaries, business forms, liability insurance, building & grounds maintenance and bank service fees in Program 811 - Sports Core General Operations distributed to various Sports Core Programs on a percentage basis. **Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year. Village of Oak Brook Monthly Operating Statement Open Fields Operations For the Period Ending February 28, 2025 2/28/25 2/28/25 2/28/25 YTD % of YTD 2025 2/28/24 Difference 815 816 YTD Amended Amended Adopted YTD Prior Polo Open Fields Total Budget Budget Budget Total Year OPERATING REVENUES Field Rentals -$ 5,000$ 5,000$ 33,833$ 14.8%203,000$ -$ 5,000$ Range Rentals - - - - N/A - - - Taste of Oak Brook - - - - N/A - - - Other Revenue - - - N/A - - - Total Operating Revenues -$ 5,000$ 5,000$ 33,833$ 14.8%203,000$ -$ 5,000$ OPERATING EXPENDITURES Personnel -$ -$ -$ -$ N/A -$ -$ -$ Materials & Supplies - - - 1,582 0.0%9,490 - - Operational & Contractual - 1,092 1,092 12,670 8.6%76,022 536 556 Capital - - - - N/A - - - Total Operating Expenditures -$ 1,092$ 1,092$ 14,252$ 7.7%85,512$ 536$ 556$ B&T Administration Overhead Allocation*-$ (9,292)$ (9,292)$ (9,292) 100.0%(55,754)$ -$ (9,292)$ Total Revenues Over (Under) Expenditures - Budgetary Basis -$ (5,384)$ (5,384)$ 10,289$ -52.3%61,733$ (536)$ (4,848)$ *Overhead allocation is comprised of salaries, business forms, liability insurance, building & grounds maintenance and bank service fees in Program 811 - Sports Core General Operations distributed to various Sports Core Programs on a percentage basis. **Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year. Village of Oak Brook Monthly Operating Statement Bath & Tennis Clubhouse Operations For the Period Ending February 28, 2025 2/28/25 2/28/25 821 YTD % of YTD 2025 2/28/24 Difference B&T Amended Amended Adopted YTD Prior Clubhouse Budget Budget Budget Total Year OPERATING REVENUES Rentals 24,032$ 39,000$ 61.6%234,000$ 12,053$ 11,979$ Other Revenue - - 0.0%- - - Total Operating Revenues 24,032$ 39,000$ 61.6%234,000$ 12,053$ 11,979$ OPERATING EXPENDITURES Personnel -$ -$ N/A -$ -$ -$ Materials & Supplies 14 2,292 0.6%13,750 3,330 (3,316) Operational & Contractual 5,663 6,728 84.2%40,365 8,895 (3,232) Capital - - N/A - - - Total Operating Expenditures 5,677$ 9,019$ 62.9%54,115$ 12,225$ (6,548)$ B&T Administration Overhead Allocation*(20,149)$ (20,149) 100.0%(120,895)$ -$ (20,149)$ Operating Revenues Over (Under) Expenditures (1,794)$ 9,832$ -18.2%58,990$ (172)$ (1,622)$ Total Revenues Over (Under) Expenditures - Budgetary Basis (1,794)$ 9,832$ 58,990$ (172)$ (1,622)$ *Overhead allocation is comprised of salaries, business forms, liability insurance, building & grounds maintenance and bank service fees in Program 811 - Sports Core General Operations distributed to various Sports Core Programs on a percentage basis. **Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year. Village of Oak Brook Monthly Operating Statement Golf Club Programs For the Period Ending February 28, 2025 2/28/25 2/28/25 823 831 832 833 834 844 2/28/25 YTD % of YTD 2025 2/28/24 Difference Golf Golf General Golf Learning Golf Cart Golf Course Golf YTD Amended Amended Adopted YTD Prior Café Operation & Practice Operations Maintenance Surcharge Total Budget Budget Budget Total Year OPERATING REVENUES Memberships -$ 116,325$ -$ -$ -$ -$ 116,325$ 76,138$ 152.8%456,825$ -$ 116,325$ Greens Fees - - - - - - - 310,998 0.0%1,865,990 - - Pro Shop Sales - 1,401 - - - - 1,401 30,000 4.7%180,000 3,986 (2,586) Golf Lessons - - 2,250 - - - 2,250 7,500 30.0%45,000 - 2,250 Driving Range Fees - - 28,883 - - - 28,883 110,230 26.2%661,382 3,920 24,963 Rentals 5,650 - - - - - 5,650 110,833 5.1%665,000 - 5,650 Food Sales 480 - - - - - 480 8,292 5.8%49,750 - 480 Beverage Sales 884 - - - - - 884 12,542 7.0%75,250 - 884 Golf Surcharge - - - - - - - 37,500 0.0%225,000 - Other Revenue - 2,605 - - - - 2,605 1,167 223.3%7,000 131 2,474 Total Operating Revenues 7,014$ 120,331$ 31,133$ -$ -$ -$ 158,477$ 705,200$ 22.5%4,231,197$ 8,037$ 150,440$ OPERATING EXPENDITURES Personnel -$ 37,984$ -$ -$ 65,139$ -$ 103,123$ 226,741$ 45.5%1,360,447$ 97,642$ 5,481$ Materials & Supplies - 4,804 970 - 8,048 - 13,822 62,439 22.1%374,635 8,843 4,980 Operational & Contractual - 7,813 776 - 12,427 - 21,016 75,329 27.9%451,973 59,505 (38,489) Other - - - - - - - - N/A - - - Capital - - - - - - - 141,842 0.0%851,054 11,108 (11,108) Total Operating Expenditures -$ 50,601$ 1,746$ -$ 85,614$ -$ 137,961$ 506,351$ 27.2%3,038,108$ 177,098$ (39,137)$ Operating Revenues Over (Under) Expenditures 7,014$ 69,730$ 29,387$ -$ (85,614)$ -$ 20,516$ 198,848$ 10.3%1,193,089$ (169,061)$ 189,577$ B&T Administration Overhead Allocation*-$ (79,898)$ -$ -$ -$ -$ (79,898)$ (79,898) 100.0%(479,387)$ -$ (79,898)$ Total Revenues Over (Under) Expenditures - Budgetary Basis 7,014$ (10,168)$ 29,387$ -$ (85,614)$ -$ (59,382)$ 118,950$ 713,702$ (169,061)$ 109,679$ *Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.