Loading...
HomeMy WebLinkAbout03 - March 2026 Monthly Financial ReportVILLAGE OAK BROOKOF MONTHLY FINANCIAL REPORTS MARCH 2026 Estimated YTD YTD Net Fund Ending YTD YTD Increase Fund Balance Governmental Funds Revenues Expenditures (Decrease)(Deficit) General Fund (Major Fund)10,240,087$ 7,014,858$ 3,225,229$ 46,371,551$ Main operating fund of the Village. Hotel Fund (Major Fund)388,903$ 196,197$ 192,707$ 6,368,767$ Collects and spends resources from the 3% hotel/motel tax. Motor Fuel Tax Fund 118,200$ 58,856$ 59,344$ 2,841,604$ Collects and spends resources from the State motor fuel tax. Infrastructure Fund (Major Fund)3,166,394$ 952,073$ 2,214,321$ 30,095,718$ Accounts for construction and maintenance of roadways, drainage, and safety path systems. Enterprise Funds Water Fund (Major Fund)2,824,711$ 1,808,811$ 1,015,899$ 25,330,705$ Collects user fees for the distribution of water and maintenance of infrastructure. Sports Core Fund (Major Fund)1,318,168$ 945,569$ 372,599$ 4,205,680$ Accounts for revenues and expenses relating to administration, programs, food and beverage operations, and golf course. Internal Service Funds Insurance Fund 816,030$ 828,837$ (12,807)$ 338,818$ Accounts for the Village's health insurance costs and the related contributions from the Village, employees, retirees, and other agencies. Garage Fund 169,789$ 144,672$ 25,116$ 603,018$ Accounts for the maintenance of the Village's vehicle fleet and the related departmental reimbursements. Equipment Replacement Fund 385,153$ 192,419$ 192,734$ 4,044,034$ 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 March 31, 2026 3/31/26 3/31/26 3/31/25 3/31/26 YTD % of YTD 2026 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax 5,423,089$ 6,660,086 4,625,000$ 144.0%18,500,000$ 1,236,997$ State Income Tax 349,221 362,750 387,452 93.6%1,549,806 13,529 Replacement Tax 89,109 92,198 125,000 73.8%500,000 3,090 Road & Bridge Tax 1 8 8,425 0.1%33,700 7 Local Use Tax 74,510 18,908 72,500 26.1%290,000 (55,602) Cannabis Use Tax 3,328 3,214 3,462 92.9%13,846 (114) Grants 7,704 - 5,280 0.0%21,120 (7,704) Utility/Telecom. Tax 840,238 789,893 725,000 109.0%2,900,000 (50,345) Licenses and Permits 376,394 506,086 607,103 83.4%2,428,410 129,692 Charges for Services 648,356 632,689 511,013 123.8%2,044,050 (15,668) Investment Interest 228,412 315,714 350,000 90.2%1,400,000 87,302 Miscellaneous Income 237,189 162,684 178,565 91.1%714,260 (74,505) Total Operating Revenues 8,277,551$ 9,544,231$ 7,598,798$ 125.6%30,395,192$ 1,266,680$ OPERATING EXPENDITURES Personnel 5,370,459$ 5,494,489$ 6,224,464$ 88.3%24,897,854$ 124,031$ Materials and Supplies 137,162 111,482 179,607 62.1%718,429 (25,680)$ Operation and Contract 1,813,288 1,377,880 1,735,365 79.4%6,941,461 (435,408)$ Other Expenditures 2,117 1,844 2,475 74.5%9,900 (272)$ Capital Outlay 26,531 29,163 138,672 21.0%554,690 2,632$ Total Operating Expenditures 7,349,556$ 7,014,858$ 8,280,583$ 84.7%33,122,333$ (334,698)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 927,995$ 2,529,373$ (681,785)$ -371.0%(2,727,141)$ 1,601,378$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A -$ -$ Transfers Out N/A - Reimbursements From Other Funds 502,764 695,856 695,858 100.0%2,783,433 193,092 Reimbursements To Other Funds - - - N/A - - Sports Core Loan N/A - - Total Interfund Transactions 502,764$ 695,856$ 695,858$ 100.0%2,783,433$ 193,092$ NET FUND INCREASE (DECREASE)1,430,759$ 3,225,229$ 14,073$ 56,292$ 1,794,470$ *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 March 31, 2026 3/31/26 3/31/26 3/31/25 3/31/26 YTD % of YTD 2026 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Hotel Tax 296,490$ 343,476$ 400,000$ 85.9%1,600,000$ 46,986$ Investment Interest 34,296 45,428 15,000 302.9%60,000 11,132 Loan Interest - - - N/A - - Miscellaneous - - 124,625 498,500 - Total Operating Revenues 330,786$ 388,903$ 539,625$ 72.1%2,158,500$ 58,118$ EXPENDITURES Personnel 31,277$ 32,506$ 38,689$ 84.0%154,755$ 1,229$ Operation and Contract 65,053 91,137 277,685 32.8%1,110,740 26,083 Other Expenditures - - 71,940 0.0%287,758 - Capital Outlay 33,626 617 212,513 0.3%850,050 (33,009.69) Total Expenditures 129,957$ 124,260$ 562,137$ 22.1%2,403,303$ (6,926)$ SURPLUS (DEFICIT) OF REVENUES OVER - EXPENDITURES 200,829$ 264,644$ (61,201)$ -432.4%(244,803)$ 65,044$ INTERFUND TRANSACTIONS Transfer Out -$ -$ -$ N/A -$ -$ Reimbursements to Other Funds (51,447) (71,937) 71,940 -100.0%287,758 (20,490) Total Interfund Transactions (51,447)$ (71,937)$ 71,940$ -100.0%287,758$ (20,490)$ NET FUND INCREASE (DECREASE)149,382$ 192,707$ 10,739$ 42,955$ 44,554$ Note - Expenditures are recorded in program 171. Village of Oak Brook Hotel Tax Fund Financial Update For the Period Ending March 31, 2026 3/31/26 3/31/26 3/31/25 3/31/26 YTD % of YTD 2026 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Non-Home Rule Sales Tax 2,355,984$ 2,951,104$ 2,148,750$ 137.3%8,595,000$ 595,120$ Charges for Services - - N/A -$ Investment Interest 135,607 215,290 125,000 172.2%500,000 79,684 Grants - - N/A - Miscellaneous - - N/A - Total Operating Revenues 2,491,591$ 3,166,394$ 2,273,750$ 139.3%9,095,000$ 674,803$ OPERATING EXPENDITURES Personnel 13,996$ 14,863$ -$ N/A -$ 867$ Materials and Supplies 2,740 294 14,701 2.0%58,804 (2,446) Operation and Contract 307,852 670,881 950,424 70.6%3,801,698 363,028 Other Expenditures - - 276,208 0.0%1,104,830 - Capital Outlay 296,533 39,830 2,302,126 1.7%9,208,503 (256,703) Total Operating Expenditures 621,121$ 725,867$ 3,543,459$ 20.5%14,173,835$ 104,746$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 1,870,469$ 2,440,527$ (1,269,709)$ -192.2%(5,078,835)$ 570,058$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A -$ -$ Reimbursements From Other Funds - - 500,000 0.0%2,000,000 - Reimbursements To Other Funds (175,476) (226,206) (276,208) 81.9%(1,104,830) (50,730) Total Interfund Transactions (175,476)$ (226,206)$ 223,793$ -101.1%895,170$ (50,730)$ NET FUND INCREASE (DECREASE)1,694,993$ 2,214,321$ (1,045,916)$ (4,183,665)$ 519,328$ Village of Oak Brook Infrastructure Fund Financial Update For the Period Ending March 31, 2026 3/31/26 3/31/26 3/31/25 3/31/26 YTD % of YTD 2026 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Plan Review Fees 450$ 75$ 188$ 40.0%750$ (375)$ Building/Inspection Fees - - - N/A - - Water Sales 2,111,403 2,363,391 3,102,250 76.2%12,409,000 251,989 Unmetered Sales 3,131 2,133 10,000 21.3%40,000 (997) Water Connection Fees 22,310 8,280 15,000 55.2%60,000 (14,030) Fire Service Charge - - - N/A - Meter Charges 8,537 3,830 4,125 92.8%16,500 (4,707) Special Services - - 3,750 0.0%15,000 - Investment Interest 228,737 250,322 212,500 117.8%850,000 21,585 Proceeds from Property Sale - - - N/A - Miscellaneous 38,556 196,678 18,750 1049.0%75,000 158,123 Total Operating Revenues 2,413,123$ 2,824,711$ 3,366,563$ 83.9%13,466,250$ 411,587$ OPERATING EXPENDITURES Personnel 140,817$ 145,748$ 175,788$ 82.9%703,153$ 4,931$ Materials and Supplies 39,673 21,594 38,133 56.6%152,532 (18,079) Operation and Contract 1,157,438 1,108,132 2,003,395 55.3%8,013,581 (49,306) Other Expenditures - - 171,190 0.0%684,758 - Capital Outlay 140,434 362,146 1,504,308 24.1%6,017,230 221,712 Total Expenditures 1,478,362$ 1,637,619$ 3,892,813$ 42.1%15,571,254$ 159,257$ Surplus (Deficit) of Revenues Over Expenditures 934,761$ 1,187,091$ (526,251)$ -225.6%(2,105,004)$ 252,330$ INTERFUND TRANSACTIONS Reimbursements To Other Funds (147,303)$ (171,192)$ (171,190)$ 100.0%(684,758)$ (23,889)$ Total Interfund Transactions (147,303)$ (171,192)$ (171,190)$ 100.0%(684,758)$ (23,889)$ Fund Increase/(Decrease) - Budgetary Basis 787,458$ 1,015,899$ (697,440)$ (2,789,762)$ 228,441$ *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 March 31, 2026 Village of Oak Brook Monthly Operating Statement Sports Core Fund Consolidated Presentation For the Period Ending March 31, 2026 3/31/26 3/31/26 3/31/26 YTD % of YTD 2026 3/31/25 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 574,570$ -$ -$ 294,525$ 869,095$ 260,723$ 333.3%1,042,890 620,121$ 248,974$ Greens Fees - - - 45,740 45,740 435,500 10.5%1,742,000 21,438 24,302 Pro Shop Sales - - - - - 45,000 0.0%181,000 4,455 (4,455) Golf Lessons - - - 19,355 19,355 25,000 77.4%100,000 23,725 (4,370) Driving Range Fees - - - 142,514 142,514 194,750 73.2%779,000 66,182 76,332 Golf Surcharge - - - 4,730 4,730 62,500 7.6%250,000 - 4,730 Rentals 95,636 5,000 51,645 27,672 179,953 282,118 63.8%1,226,070 63,099 116,854 Programs/User Fees 24,897 - - - 24,897 38,955 63.9%155,820 6,694 18,203 Food Sales - - - 1,709 1,709 28,938 5.9%115,750 870 839 Beverage Sales - - - - - 1,000 0.0%4,000 884 (884) Grants - - - - - - N/A - - - Other Revenue 13,473 - - 6,700 20,173 19,140 105.4%76,560 16,485 3,688 Total Operating Revenues 708,576$ 5,000$ 51,645$ 542,945$ 1,308,166$ 1,393,623$ 93.9%5,673,090$ 823,953$ 484,213$ OPERATING EXPENDITURES Personnel 50,693$ -$ -$ 172,702$ 223,395$ 454,380$ 49.2%1,817,521$ 201,050$ 22,345$ Materials & Supplies 25 - - 27,383 27,408 114,472 23.9%457,887 32,113 (4,705) Operational & Contractual 189,869 3,578 23,441 89,930 306,818 283,378 108.3%1,133,511 186,358 120,460 Other - - - - - - N/A - - - Capital 87,831 - - 63,593 151,424 222,236 68.1%888,942 86,618 64,806 Total Operating Expenditures 328,418$ 3,578$ 23,441$ 353,609$ 709,046$ 1,074,465$ 66.0%4,297,861$ 506,140$ 202,906$ B&T Administration Overhead Allocation*238,539$ (20,273)$ (42,708)$ (175,558)$ -$ -$ N/A -$ 4,646$ 4,646$ Operating Revenues Over (Under) Expenditures 618,696$ (18,850)$ (14,504)$ 13,778$ 599,120$ 319,157$ 187.7%1,375,229$ 322,459$ 285,952$ INTERFUND TRANSACTIONS Reimbursement From Other Funds 10,002$ -$ -$ -$ 10,002$ 10,000$ 100.0%40,000$ 10,002$ -$ Reimbursement To General Fund (236,523) - - - (236,523) (236,522) 100.0%(946,087) (138,540) (97,983) Total Interfund Transactions (226,521)$ -$ -$ -$ (226,521)$ (226,522)$ 100.0%(906,087)$ (128,538)$ (97,983)$ Total Revenues Over (Under) Expenditures - Budgetary Basis 392,175$ (18,850)$ (14,504)$ 13,778$ 372,599$ 92,636$ 469,142$ 193,921$ 187,969$ *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 March 31, 2026 3/31/26 3/31/26 822 3/31/26 YTD % of YTD 2026 3/31/25 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 -$ 561,235$ 13,335$ -$ 574,570$ 159,929$ 359.3%639,715$ 376,671$ 197,899$ Programs/User Fees - 24,897 - - 24,897 38,955 63.9%155,820 6,694 18,203 Pro Shop Sales - - - - - 250 0.0%1,000 - - Rentals 94,886 - - 750 95,636 24,400 392.0%97,600 - 95,636 Food Sales - - - - - 1,500 0.0%6,000 - - Beverage Sales - - - - - 1,000 0.0%4,000 - - Grants - - - - - - N/A - - - Other Revenue 13,473 - - - 13,473 11,640 115.7%46,560 3,422 10,051 Total Operating Revenues 108,359$ 586,132$ 13,335$ 750$ 708,576$ 237,674$ 298.1%950,695$ 386,787$ 321,789$ OPERATING EXPENDITURES Personnel 50,693$ -$ -$ -$ 50,693$ 83,115$ 61.0%332,458$ 44,560$ 6,133$ Materials & Supplies 25 - - - 25 7,150 0.3%28,600 3,369 (3,344) Operational & Contractual 185,279 1,873 2,717 - 189,869 146,912 129.2%587,649 134,583 55,286 Other - - - - - N/A - - - Capital 87,831 - - - 87,831 1,350 6506.0%5,400 10,088 77,743 Total Operating Expenditures 323,828$ 1,873$ 2,717$ -$ 328,418$ 238,527$ 137.7%954,107$ 192,600$ 135,819$ B&T Administration Overhead Allocation*302,522$ (50,368)$ (9,980)$ (3,636)$ 238,539$ 238,539 100.0%954,154$ 164,009$ 74,530$ Operating Revenues Over (Under) Expenditures 87,053$ 533,891$ 639$ (2,886)$ 618,696$ 237,686$ 260.3%950,742$ 358,197$ 260,500$ INTERFUND TRANSACTIONS Reimbursement From Other Fund 10,002$ -$ -$ -$ 10,002$ 10,000$ 100.0%40,000$ 10,002$ -$ Reimbursement To General Fund (236,523) - - - (236,523) (236,522) 100.0%(946,087) (138,540) (97,983) Total Interfund Transactions (226,521)$ -$ -$ -$ (226,521)$ (226,522)$ 100.0%(906,087)$ (128,538)$ (97,983)$ Total Revenues Over (Under) Expenditures - Budgetary Basis (139,468)$ 533,891$ 639$ (2,886)$ 392,175$ 11,164$ 44,655$ 229,659$ 162,517$ *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 March 31, 2026 3/31/26 3/31/26 3/31/26 YTD % of YTD 2026 3/31/25 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$ 51,000$ 9.8%204,000$ 7,500$ (2,500)$ Range Rentals - - - - N/A - - - Other Revenue - - - N/A - - - Total Operating Revenues -$ 5,000$ 5,000$ 51,000$ 9.8%204,000$ 7,500$ (2,500)$ OPERATING EXPENDITURES Personnel -$ -$ -$ -$ N/A -$ -$ -$ Materials & Supplies - - -$ 2,373 0.0%9,490 - - Operational & Contractual - 3,578 3,578$ 19,331 18.5%77,322 1,092 2,486 Capital - - -$ 50,000 0.0%200,000 - - Total Operating Expenditures -$ 3,578$ 3,578$ 71,703$ 5.0%286,812$ 1,092$ 2,486$ B&T Administration Overhead Allocation*-$ (20,273)$ (20,273)$ (20,273) 100.0%(81,090)$ (9,292)$ (10,980)$ Total Revenues Over (Under) Expenditures - Budgetary Basis -$ (18,850)$ (18,850)$ (40,976)$ 46.0%(163,902)$ (2,884)$ (15,966)$ *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 March 31, 2026 3/31/26 3/31/26 821 YTD % of YTD 2026 3/31/25 Difference B&T Amended Amended Adopted YTD Prior Clubhouse Budget Budget Budget Total Year OPERATING REVENUES Rentals 51,645$ 60,000$ 86.1%240,000$ 40,745$ 10,900$ Other Revenue - - 0.0%- - - Total Operating Revenues 51,645$ 60,000$ 86.1%240,000$ 40,745$ 10,900$ OPERATING EXPENDITURES Personnel -$ -$ N/A -$ -$ -$ Materials & Supplies - 1,250 0.0%5,000 14 (14) Operational & Contractual 23,441 15,863 147.8%63,450 9,273 14,168 Capital - - N/A - - - Total Operating Expenditures 23,441$ 17,113$ 137.0%68,450$ 9,287$ 14,154$ B&T Administration Overhead Allocation*(42,708)$ (42,708) 100.0%(170,832)$ (30,224)$ (12,484)$ Operating Revenues Over (Under) Expenditures (14,504)$ 180$ -8080.4%718$ 1,234$ (15,738)$ Total Revenues Over (Under) Expenditures - Budgetary Basis (14,504)$ 180$ 718$ 1,234$ (15,738)$ *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 March 31, 2026 3/31/26 3/31/26 823 831 832 833 834 844 3/31/26 YTD % of YTD 2026 3/31/25 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 -$ 294,525$ -$ -$ -$ -$ 294,525$ 100,794$ 292.2%403,175$ 243,450$ 51,075$ Greens Fees - 45,740 - - - - 45,740 435,500 10.5%1,742,000 21,438 24,302 Pro Shop Sales - - - - - - - 45,000 0.0%180,000 4,455 (4,455) Golf Lessons - - 19,355 - - - 19,355 25,000 77.4%100,000 23,725 (4,370) Driving Range Fees - - 142,514 - - - 142,514 194,750 73.2%779,000 66,182 76,332 Rentals 9,180 - 7,250 11,242 - - 27,672 171,118 16.2%684,470 14,854 12,818 Food Sales 1,709 - - - - - 1,709 27,438 6.2%109,750 870 839 Beverage Sales - - - - - - - - N/A 884 (884) Golf Surcharge - - - - - 4,730 4,730 62,500 7.6%250,000 2,795 1,935 Other Revenue - 6,700 - - - - 6,700 7,500 89.3%30,000 13,063 (6,363) Total Operating Revenues 10,889$ 346,965$ 169,119$ 11,242$ -$ 4,730$ 542,945$ 1,069,599$ 50.8%4,278,395$ 391,716$ 151,229$ OPERATING EXPENDITURES Personnel -$ 62,184$ 362$ 272$ 109,884$ 172,702$ 371,266$ 46.5%1,485,063$ 156,491$ 16,212$ Materials & Supplies - 7,881 503 - 18,999 27,383 103,699 26.4%414,797 28,731 (1,347) Operational & Contractual - 61,994 4,820 2,338 20,778 89,930 101,273 88.8%405,090 41,410 48,519 Other - - - - - - - N/A - - Capital - 5,842 8,500 - 49,252 63,593 170,886 37.2%683,542 76,530 (12,937) Total Operating Expenditures -$ 137,901$ 14,185$ 2,610$ 198,913$ -$ 353,609$ 747,123$ 47.3%2,988,492$ 303,162$ 50,447$ Operating Revenues Over (Under) Expenditures 10,889$ 209,064$ 154,934$ 8,632$ (198,913)$ 4,730$ 189,336$ 322,476$ 58.7%1,289,903$ 88,554$ 100,782$ B&T Administration Overhead Allocation*-$ (175,558)$ -$ -$ -$ -$ (175,558)$ (175,558) 100.0%(702,232)$ (119,847)$ (55,711)$ INTERFUND TRANSACTIONS Reimbursement To General Fund -$ -$ -$ -$ -$ -$ N/A -$ 0.0%-$ -$ Total Interfund Transactions -$ -$ -$ -$ -$ -$ N/A -$ -$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis 10,889$ 33,506$ 154,934$ 8,632$ (198,913)$ 4,730$ 13,778$ 146,918$ 587,671$ (31,293)$ 45,071$ *Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.