12 - December 2022 Monthly Financial ReportVILLAGE
OAK BROOKOF
MONTHLY FINANCIAL REPORTS
DECEMBER 2022
YTD YTD
Net Fund Ending
YTD YTD Increase Fund Balance
Governmental Funds Revenues Expenditures (Decrease)(Deficit)
General Fund (Major Fund)32,264,664$ 24,103,334$ 8,161,331$ 39,509,268$
Main operating fund of the Village.
Hotel Fund (Major Fund)1,361,686$ 519,490$ 842,197$ 2,342,098$
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund 509,000$ 115$ 508,885$ 1,691,461$
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)8,408,420$ 9,515,134$ (1,106,714)$ 7,699,580$
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)413,818$ 490,835$ (77,017)$ 221,370$
Accounts for the revenues and expenditures
restricted to the Tax Increment Financing (TIF)
district located at 22nd St. and Meyers Rd.
Enterprise Funds
Water Fund (Major Fund)24,622,937$ 6,240,976$ 18,381,961$ 22,388,873$
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)4,742,200$ 3,683,268$ 1,058,933$ 1,164,492$
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund 146,744$ 651$ 146,093$ 424,866$
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund 3,649,117$ 3,099,154$ 549,962$ 428,966$
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund 624,919$ 635,744$ (10,825)$ 292,798$
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund 821,685$ 733,830$ 87,856$ 3,532,179$
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 December 31, 2022
12/31/22 12/31/22
12/31/21 12/31/22 YTD % of YTD 2022 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 14,286,866$ 17,984,683 13,200,000$ 136.2%13,200,000$ 3,697,817$
Other Intergovernmental Tax*1,937,522 2,742,043 1,618,400 169.4%1,618,400 804,521
Telecommunications/Utility Tax 5,685,893 5,426,390 5,595,000 97.0%5,595,000 (259,503)
Grants 42,987 279,320 15,000 1862.1%15,000 236,333
Licenses and Permits 2,427,816 2,453,016 2,007,510 122.2%2,007,510 25,200
Charges for Services 1,539,619 1,882,917 1,154,900 163.0%1,154,900 343,298
Fines and Penalties 139,421 109,571 142,000 77.2%142,000 (29,850)
Administrative Towing Fees 26,891 47,250 25,000 189.0%25,000 20,359
Investment Interest 171,232 307,232 144,000 213.4%144,000 136,000
Franchise Fees 159,960 223,852 198,000 113.1%198,000 63,892
Installment Contract Proceeds - N/A -
Miscellaneous Income 381,110 290,268 478,270 60.7%478,270 (90,842)
Total Operating Revenues 26,799,317$ 31,746,542$ 24,578,080$ 129.2%24,578,080$ 4,947,225$
OPERATING EXPENDITURES
Personnel 18,529,897$ 19,062,169$ 19,468,249$ 97.9%19,468,249$ 532,272$
Materials and Supplies 436,833 509,208 572,545 88.9%572,545 72,375$
Operation and Contract 3,112,319 3,863,493 3,584,720 107.8%3,584,720 751,174$
Other Expenditures 8,599 6,437 118,880 5.4%118,880 (2,162)$
Capital Outlay 267,280 561,300 1,292,350 43.4%1,292,350 294,020$
Total Operating Expenditures 22,354,928$ 24,002,607$ 25,036,744$ 95.9%25,036,744$ 1,647,679$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 4,444,389$ 7,743,936$ (458,664)$ -1688.4%(458,664)$ 3,299,547$
INTERFUND TRANSACTIONS
Transfers In -$ -$ -$ N/A -$ -$
Transfers Out (3,000,000) N/A 3,000,000
Reimbursements From Other Funds 593,685 518,122 565,220 91.7%565,220 (75,563)
Reimbursements To Other Funds (105,885) (100,727) (109,880) 91.7%(109,880) 5,158
Sports Core Loan - N/A - -
Total Interfund Transactions (2,512,200)$ 417,395$ 455,340$ 91.7%455,340$ 2,929,595$
NET FUND INCREASE (DECREASE)1,932,189$ 8,161,331$ (3,324)$ (3,324)$ 6,229,142$
*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 December 31, 2022
Total Total
Revenues Expenditures
12/31/22 Actual 31,746,542$ 24,002,607$
12/31/21 Actual 26,799,317$ 22,354,928$
% Change From Last Year 18.5%7.4%
Major Revenues
Other Telecom/Utility Licenses &Charges for
Sales Tax Intergov. Tax Tax Permits Services
12/31/22 Actual 17,984,683$ 2,742,043$ 5,426,390$ 2,453,016$ 1,882,917$
12/31/21 Actual $ 14,286,866 $ 1,937,522 $ 5,685,893 $ 2,427,816 $ 1,539,619
% Change From Last Year 25.9%41.5%-4.6%1.0%22.3%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
12/31/22 Actual 19,062,169$ 509,208$ 3,863,493$ 6,437$ 561,300$
12/31/21 Actual 18,529,897$ 436,833$ 3,112,319$ 8,599$ 267,280$
% Change From Last Year 2.9%16.6%24.1%-25.1%110.0%
Five Year Trend
Expenditures by Department
12/31/21 12/31/22 12/31/22 12/31/22 2022 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 2,123,970$ 2,705,977$ 3,002,480$ 90.1%3,002,480$ 582,007$
Financial Services 691,170 724,522 827,030 87.6%827,030 33,352
Public Works 718,961 766,797 928,765 82.6%928,765 47,836
Engineering & Capital Projects 22,671 13,418 384,000 3.5%384,000 (9,253)
Library 810,260 879,249 996,145 88.3%996,145 68,989
Police 7,595,733 8,044,295 9,869,105 81.5%9,869,105 448,562
Fire 6,234,412 6,363,215 7,922,040 80.3%7,922,040 128,803
Development Services 855,199 811,554 1,094,285 74.2%1,094,285 (43,645)
Total Expenditures 22,354,928$ 24,002,607$ 25,036,744$ 95.9%25,036,744$ 1,256,651$
Five Year Trend
For the Period Ending December 31, 2022
General Fund - Five Year Trend
Village of Oak Brook
10,000,000
30,000,000
50,000,000
Revenues Expenditures
12/31/22 12/31/22
12/31/21 12/31/22 YTD % of YTD 2022 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 754,014$ 1,334,630$ 773,500$ 172.5%773,500$ 580,616$
Investment Interest 30,781 21,056 21,000 100.3%21,000 (9,725)
Loan Interest 8,000 6,000 6,000 100.0%6,000 (2,000)
Miscellaneous 1,272 (1,272)
Total Operating Revenues 794,067$ 1,361,686$ 800,500$ 170.1%800,500$ 567,619$
EXPENDITURES
Operation and Contract 188,152$ 390,894$ 289,985$ 134.8%289,985$ 202,742$
Capital Outlay 5,215 52,696 - N/A - 47,481
Total Expenditures 193,367$ 443,590$ 289,985$ 153.0%289,985$ 250,223$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 600,700$ 918,097$ 510,515$ 179.8%510,515$ 317,397$
INTERFUND TRANSACTIONS
Transfer Out (3,450,462)$ -$ (193,375)$ 0.0%(193,375)$ 3,450,462$
Reimbursements to Other Funds (84,085) (75,900) (82,800) 91.7%(82,800) 8,185
Total Interfund Transactions (3,534,547)$ (75,900)$ (276,175)$ 27.5%(276,175)$ 3,458,647$
NET FUND INCREASE (DECREASE)(2,933,847)$ 842,197$ 234,340$ 234,340$ 3,776,044$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending December 31, 2022
Total Total
Revenues Expenditures
12/31/22 Actual $ 1,361,686 443,590$
12/31/21 Actual $ 794,067 193,367$
% Change From Last Year 71.5%129.4%
Major Revenues Investment
Hotel Tax Interest Loan Interest Miscellaneous
12/31/22 Actual $ 1,334,630 $ 21,056 6,000$ -$
12/31/21 Actual $ 754,014 $ 30,781 8,000$ 1,272$
% Change From Last Year 77.0%-31.6%0.0%0.0%
Five Year Trend
Major Expenditures Operation &
Contractual Capital Outlay
12/31/22 Actual 390,894$ 52,696$
12/31/21 Actual 188,152$ 5,215$
% Change From Last Year 107.8%N/A
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending December 31, 2022
Five Year Trend
Revenues Expenditures
12/31/22 12/31/22
12/31/21 12/31/22 YTD % of YTD 2022 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Non-Home Rule Sales Tax 6,044,599$ 7,471,148$ 5,815,000$ 128.5%5,815,000$ 1,426,549$
Charges for Services - - N/A -$
Investment Interest 34,064 90,844 27,500 330.3%27,500 56,780
Grants - 550,000 1,089,730 50.5%1,089,730 550,000
Miscellaneous 4,279 - 1,000 0.0%1,000 (4,279)
Total Operating Revenues 6,082,942$ 8,111,992$ 6,933,230$ 117.0%6,933,230$ 2,029,050$
OPERATING EXPENDITURES
Personnel 1,328,087$ 1,251,819$ 1,292,835$ 96.8%1,292,835$ (76,268)$
Materials and Supplies 161,568 164,685 226,600 72.7%226,600 3,117
Operation and Contract 1,587,672 1,185,776 1,730,180 68.5%1,730,180 (401,896)
Other Expenditures - N/A -
Capital Outlay 6,064,349 6,804,569 9,226,320 73.8%9,226,320 740,220
Total Operating Expenditures 9,141,676$ 9,406,850$ 12,475,935$ 75.4%12,475,935$ 265,174$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES (3,058,734)$ (1,294,858)$ (5,542,705)$ 23.4%(5,542,705)$ 1,763,876$
INTERFUND TRANSACTIONS
Transfers In 6,450,462$ -$ 423,375$ 0.0%423,375$ (6,450,462)$
Reimbursements From Other Funds 331,840 296,428 323,365 91.7%323,365 (35,412)
Reimbursements To Other Funds (176,300) (108,284) (118,130) 91.7%(118,130) 68,016
Total Interfund Transactions 6,606,002$ 188,144$ 628,610$ 29.9%628,610$ (6,417,858)$
NET FUND INCREASE (DECREASE)3,547,268$ (1,106,714)$ (4,914,095)$ (4,914,095)$ (4,653,982)$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending December 31, 2022
Total Total
Revenues Expenditures
12/31/22 Actual $ 8,111,992 9,406,850$
12/31/21 Actual $ 6,082,942 9,141,676$
% Change From Last Year 33.4%2.9%
Major Revenues
Sales Tax
Charges for
Services
Investment
Interest Miscellaneous
12/31/22 Actual $ 7,471,148 $ - $ 90,844 $ -
12/31/21 Actual $ 6,044,599 $ - $ 34,064 $ -
% Change From Last Year 23.6%0.0%166.7%0.0%
Five Year Trend
Major Expenditures Materials &Operation &
Personnel Supplies Contractual Capital Outlay
12/31/22 Actual 1,251,819$ 164,685$ 1,185,776$ 6,804,569$
12/31/21 Actual 1,328,087$ 161,568$ 1,587,672$ 6,064,349$
% Change From Last Year -5.7%1.9%-25.3%12.2%
Five Year Trend
Expenditures by Department
12/31/21 12/31/22 12/31/22 12/31/22 2022 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 147,483$ 180,545$ 209,510$ 86.2%209,510$ 33,062$
Public Works 2,199,524 1,960,037 2,380,195 82.3%2,380,195 (239,487)
Engineering & Capital Projects 5,814,055 7,040,280 9,886,230 71.2%9,886,230 1,226,225
Total Expenditures 8,161,062$ 9,180,862$ 12,475,935$ 73.6%12,475,935$ 1,019,800$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending December 31, 2022
Revenues Expenditures
12/31/22 12/31/22
12/31/21 12/31/22 YTD % of YTD 2022 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 97,268$ -$ 90,000$ 0.0%90,000$ (97,268)$
Real Estate Tax 408,456 411,881 405,000 101.7%405,000 3,425
Investment Interest 60 1,937 50 3873.6%50 1,877
Total Operating Revenues 505,784$ 413,818$ 495,050$ 83.6%495,050$ (91,966)$
EXPENDITURES
Operation and Contract 4,075$ 4,575$ 3,900$ 117.3%3,900$ 500$
Other Expenditures 481,500 486,260 486,255 100.0%486,255 4,760
Total Expenditures 485,575$ 490,835$ 490,155$ 100.1%490,155$ 5,260$
NET FUND INCREASE (DECREASE)20,209$ (77,017)$ 4,895$ 4,895$ (97,226)$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending December 31, 2022
Total Total
Revenues Expenditures
12/31/22 Actual $ 413,818 490,835$
12/31/21 Actual $ 505,784 485,575$
% Change From Last Year -18.2%1.1%
Major Revenues Real Estate Investment
Sales Tax Tax Interest
12/31/22 Actual -$ $ 411,881 $ 1,937
12/31/21 Actual 97,268$ $ 408,456 $ 60
% Change From Last Year -100.0%0.0%3128.0%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
12/31/22 Actual 4,575$ 486,260$
12/31/21 Actual 4,075$ 481,500$
% Change From Last Year 0.0%1.0%
Five Year Trend
Village of Oak Brook
Promenade TIF Fund - Major Sources Five Year Trend
For the Period Ending December 31, 2022
Five Year Trend
Revenues Expenditures
12/31/22 12/31/22
12/31/21 12/31/22 YTD % of YTD 2022 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Plan Review Fees 525$ 600$ 1,000$ 60.0%1,000$ 75$
Building/Inspection Fees 3,000 2,175 5,000 43.5%5,000 (825)
Water Sales 10,654,667 11,460,580 10,484,500 109.3%10,484,500 805,913
Unmetered Sales 46,702 98,815 50,000 197.6%50,000 52,113
Water Connection Fees 188,830 586,270 75,000 781.7%75,000 397,440
Fire Service Charge - - N/A -
Meter Charges 7,826 24,729 15,000 164.9%15,000 16,903
Special Services 25,326 13,389 25,000 53.6%25,000 (11,937)
Investment Interest 45,502 79,340 30,000 264.5%30,000 33,838
Proceeds from Property Sale - 12,243,661 - N/A - 12,243,661
Miscellaneous 711,951 113,378 30,000 377.9%30,000 (598,573)
Total Operating Revenues 11,684,329$ 24,622,937$ 10,715,500$ 229.8%10,715,500$ 12,938,608$
OPERATING EXPENDITURES
Personnel 737,710$ 478,087$ 647,620$ 73.8%647,620$ (259,623)$
Materials and Supplies 130,866 75,505 69,650 108.4%69,650 (55,361)
Operation and Contract 4,826,637 5,268,039 5,400,625 97.5%5,400,625 441,402
Capital Outlay 8,187,696 33,894 3,925,000 0.9%3,925,000 (8,153,802)
Total Expenditures 13,882,909$ 5,855,525$ 10,042,895$ 58.3%10,042,895$ (8,027,384)$
Surplus (Deficit) of Revenues Over
Expenditures (2,198,580)$ 18,767,412$ 672,605$ 2790.3%672,605$ 20,965,992$
INTERFUND TRANSACTIONS
Reimbursements To Other Funds (450,500)$ (385,451)$ (420,490)$ 91.7%(420,490)$ 65,049$
Total Interfund Transactions (450,500)$ (385,451)$ (420,490)$ 91.7%(420,490)$ 65,049$
Fund Increase/(Decrease) - Budgetary Basis (2,649,080)$ 18,381,961$ 252,115$ 252,115$ 21,031,041$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay 8,187,696$ 33,894$
Depreciation Expense (575,000) (575,000)
IMRF Pension Expense (45,000) (45,000)
OPEB Expense (30,000) (30,000)
Total GAAP Adjustments 7,537,696$ (616,106)$
Fund Increase/(Decrease) - GAAP Basis 4,888,616$ 17,765,855$
*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 December 31, 2022
Total Total
Revenues Expenditures
12/31/22 Actual $ 24,622,937 5,855,525$
12/31/21 Actual $ 11,684,329 13,882,909$
% Change From Last Year 110.7%-57.8%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
12/31/22 Actual $ 11,460,580 $ 98,815 $ 586,270 $ 24,729 $ 113,378
12/31/21 Actual $ 10,654,667 $ 46,702 $ 188,830 $ 7,826 $ 711,951
% Change From Last Year 7.6%111.6%210.5%216.0%-84.1%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
12/31/22 Actual 478,087$ 75,505$ 5,268,039$ -$ 33,894$
12/31/21 Actual 737,710$ 130,866$ 4,826,637$ -$ 8,187,696$
% Change From Last Year -35.2%-42.3%9.1%0.0%-99.6%
Five Year Trend
Expenditures by Department
12/31/21 12/31/22 12/31/22 12/31/22 2022 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 5,216,717$ 5,821,631$ 6,117,895$ 85.3%6,117,895$ (604,914)$
Engineering & Capital Projects 6,044,753 33,894 3,925,000 0.0%3,925,000 6,010,859
Total Expenditures 11,261,470$ 5,855,525$ 10,042,895$ 58.3%10,042,895$ 5,405,945$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending December 31, 2022
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending December 31, 2022
12/31/22 12/31/22
12/31/22 YTD % of YTD 2022 12/31/21 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 402,838$ -$ -$ 404,975$ 807,813$ 801,750$ 100.8%801,750$ 355,865$ 451,948$
Greens Fees - - - 1,259,625 1,259,625 1,145,000 110.0%1,145,000 1,304,076 (44,451)
Pro Shop Sales - - - 226,529 226,529 210,000 107.9%210,000 244,194 (17,665)
Golf Lessons - - - 35,815 35,815 50,000 71.6%50,000 50,140 (14,325)
Driving Range Fees - - - 356,233 356,233 300,000 118.7%300,000 341,440 14,793
Rentals - 254,393 354,269 457,202 1,065,864 993,775 107.3%993,775 825,705 240,159
Programs/User Fees 84,221 - - - 84,221 15,500 543.4%15,500 - 84,221
Food Sales 44,287 - - 273,057 317,343 286,000 111.0%286,000 280,382 36,961
Beverage Sales 17,712 - - 484,388 502,100 490,000 102.5%490,000 496,244 5,856
Taste of Oak Brook - 66,812 - - 66,812 120,000 55.7%120,000 - 66,812
Grants - - - - - - N/A - 138,217 (138,217)
Other Revenue 3,127 - - 16,719 19,846 8,000 248.1%8,000 82,656 (62,810)
Total Operating Revenues 552,184$ 321,205$ 354,269$ 3,514,542$ 4,742,200$ 4,420,025$ 107.3%4,420,025$ 4,118,919$ 623,281$
OPERATING EXPENDITURES
Personnel 67,599$ -$ 135,657$ 1,267,759$ 1,471,016$ 1,671,380$ 88.0%1,671,380$ 1,462,983$ 8,033$
Materials & Supplies 69,928 - 19,460 709,995 799,382 718,900 111.2%718,900 716,179 83,203
Operational & Contractual 311,454 223,829 79,775 352,967 968,025 942,765 102.7%942,765 599,405 368,620
Other - - - - - - N/A - (39,000) 39,000
Capital 244,355 - - 131,321 375,676 466,750 80.5%466,750 658,097 (282,421)
Total Operating Expenditures 693,335$ 223,829$ 234,892$ 2,462,043$ 3,614,100$ 3,799,795$ 95.1%3,799,795$ 3,397,664$ 216,436$
B&T Administration Overhead Allocation*32,738$ -$ (32,738)$ -$ -$ -$ N/A -$ -$ -$
Operating Revenues Over (Under) Expenditures (108,413)$ 97,376$ 86,639$ 1,052,499$ 1,128,101$ 620,230$ 181.9%620,230$ 721,255$ 406,846$
INTERFUND TRANSACTIONS
Interfund Loan**-$ -$ -$ -$ -$ -$ N/A -$ -$ -$
Transfer From General Fund - - - - - - N/A - - -
Transfer From Golf Surcharge Fund - - - - - 150,000 0.0%150,000 - -
Reimbursement From Infrastructure Fund - - - - - - N/A - 32,000 (32,000)
Reimbursement From Water Fund - - - - - - N/A - 8,000 (8,000)
Reimbursement To General Fund (17,292) - - (51,876) (69,168) (75,455) 91.7%(75,455) (62,900) (6,268)
Total Interfund Transactions (17,292)$ -$ -$ (51,876)$ (69,168)$ 74,545$ -92.8%74,545$ (22,900)$ (46,268)$
Total Revenues Over (Under) Expenditures - Budgetary Basis (125,705)$ 97,376$ 86,639$ 1,000,623$ 1,058,933$ 694,775$ 694,775$ 698,355$ 360,578$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 244,355$ -$ -$ 131,321$ 375,676$ 658,097$
Depreciation Expense (168,227) (1,685) (25,000) (246,300) (441,212) (439,815)
IMRF Pension Expense (2,050) - (1,250) (24,500) (27,800) (26,000)
OPEB Expense - - (1,250) (28,000) (29,250) (25,850)
Total GAAP Adjustments 74,078$ (1,685)$ (27,500)$ (167,479)$ (122,586)$ 166,432$
Fund Increase/(Decrease) - GAAP Basis (51,627)$ 95,691$ 59,139$ 833,144$ 936,347$ 864,787$
*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.
Total Direct Total Direct
Revenues Expenditures
12/31/22 Actual $ 4,742,200 3,614,100$
12/31/21 Actual $ 4,118,919 3,397,664$
% Change From Last Year 15.1%6.4%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
12/31/22 Actual $ 807,813 $ 1,259,625 $ 356,233 $ 1,065,864 84,221$
12/31/21 Actual $ 355,865 $ 1,304,076 $ 341,440 $ 825,705 -$
% Change From Last Year 127.0%-3.4%N/A 29.1%0.0%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
12/31/22 Actual 1,471,016$ 799,382$ 968,025$ -$ 375,676$
12/31/21 Actual 1,462,983$ 716,179$ 599,405$ (39,000)$ 658,097$
% Change From Last Year 0.5%11.6%61.5%0.0%-42.9%
Five Year Trend
Revenues by Department 12/31/21 12/31/22 12/31/22 12/31/22 2022 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations 146,978$ 552,184$ 521,450$ 105.9%521,450$ 481,425$
Open Field Operations 170,494 321,205 375,000 85.7%375,000 83,899
B&T Clubhouse Operations 196,384 354,269 351,275 100.9%351,275 157,885
Golf Club 3,585,258 3,514,542 3,172,300 110.8%3,172,300 (70,716)
Total Revenues 4,099,114$ 4,742,200$ 4,420,025$ 107.3%4,420,025$ 652,493$
Expenditures by Department 12/31/21 12/31/22 12/31/22 % of YTD 2022 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations 548,031$ 693,335$ 567,180$ 122.2%567,180$ 145,304$
Open Field Operations 154,702$ 223,829$ 250,660$ 89.3%250,660$ 69,127$
B&T Clubhouse Operations 210,350 234,892 298,200 78.8%298,200 24,542
Golf Club 2,484,581 2,462,043 2,683,755 91.7%2,683,755 (22,538)
Total Expenditures 3,397,664$ 3,614,100$ 3,799,795$ 95.1%3,799,795$ 216,436$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending December 31, 2022
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Operations
For the Period Ending December 31, 2022 12/31/22 12/31/22
822 12/31/22 YTD % of YTD 2022 12/31/21 Difference
811 812 813 Poolside YTD Amended Amended Adopted YTD Prior
B&T Admin Swimming Tennis Café Total Budget Budget Budget Total Year
OPERATING REVENUES
Memberships -$ 377,263$ 25,575 - 402,838$ 448,950$ 89.7%448,950$ -$ 402,838$
Programs/User Fees (550) 42,109 42,661 - 84,221 15,500.00 543.4%15,500 - 84,221
Food Sales - - - 44,287 44,287 36,000.00 123.0%36,000 - -
Beverage Sales - - - 17,712 17,712 20,000.00 88.6%20,000 - -
Grants - - - - - - N/A - 138,217 -
Other Revenue 3,127 - - - 3,127 1,000 312.7%1,000 8,761 (5,634)
Total Operating Revenues 2,577$ 419,372$ 68,236$ 61,998$ 552,184$ 521,450$ 105.9%521,450$ 146,978$ 481,425$
OPERATING EXPENDITURES
Personnel 16,606$ 14,714$ -$ 36,280$ 67,599$ 127,350$ 53.1%127,350$ 16,251$ 51,348$
Materials & Supplies 1,078 29,588 6,574 32,687 69,928 74,550 93.8%74,550 32,675 37,253
Operational & Contractual 37,515 206,104 59,511 8,324 311,454 307,530 101.3%307,530 112,296 199,158
Other - - - - N/A - -
Capital - 243,605 750 - 244,355 57,750 423.1%57,750 386,809 (142,454)
Total Operating Expenditures 55,199$ 494,011$ 66,835$ 77,291$ 693,335$ 567,180$ 122.2%567,180$ 548,031$ 145,304$
B&T Administration Overhead Allocation*65,477$ (23,572)$ (6,548)$ (2,619)$ 32,738$ -$ N/A 68,810$ 24,921$ 7,817$
Operating Revenues Over (Under) Expenditures 12,855$ (98,210)$ (5,147)$ (17,911)$ (108,413)$ (45,730)$ 237.1%23,080$ (376,132)$ 343,937$
Transfer From General Fund - - - - - - N/A - -
Reimbursement From Infrastructure Fund - - - - - -$ N/A - 32,000 (32,000)
Reimbursement From Water Fund - - - - - - N/A - 8,000 (8,000)
Reimbursement To General Fund (17,292) - - - (17,292) (18,865) 91.7%(18,865) (15,725) (1,567)
Total Interfund Transactions (17,292)$ -$ -$ -$ (17,292)$ (18,865)$ 91.7%(18,865)$ 24,275$ (41,567)$
Total Revenues Over (Under) Expenditures - Budgetary Basis (4,437)$ (98,210)$ (5,147)$ (17,911)$ (125,705)$ (64,595)$ 4,215$ (351,857)$ 302,370$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay -$ 243,605$ 750$ -$ 244,355$ 386,809$
Depreciation Expense (64,359) (100,000) (2,700) (1,168) (168,227) (127,460)
IMRF Pension Expense (2,000) - - (50) (2,050) (1,000)
Total GAAP Adjustments (66,359)$ 143,605$ (1,950)$ (1,218)$ 74,078$ 258,349$
Fund Increase/(Decrease) - GAAP Basis (70,796)$ 45,395$ (7,097)$ (19,129)$ (51,627)$ (93,508)$
*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 o
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 December 31, 2022 12/31/22 12/31/22
12/31/22 YTD % of YTD 2022 12/31/21 Difference
815 816 YTD Amended Amended Adopted YTD Prior
Polo Open Fields Total Budget Budget Budget Total Year
OPERATING REVENUES
Field Rentals -$ 174,393$ 174,393$ 170,000$ 102.6%170,000$ 30,500$ 143,893$
Range Rentals - 80,000 80,000 85,000 94.1%85,000 80,000 -
Taste of Oak Brook - 66,812 66,812 120,000 55.7%120,000 - -
Other Revenue - - - N/A - 59,994 (59,994)
Total Operating Revenues -$ 321,205$ 321,205$ 375,000$ 85.7%375,000$ 170,494$ 83,899$
OPERATING EXPENDITURES
Personnel -$ -$ -$ -$ N/A -$ -$
Materials & Supplies - - - 1,500 0.0%1,500$ - -
Operational & Contractual 199 223,630 223,829 249,160 89.8%249,160 34,714 189,115
Capital - - - N/A 119,988 (119,988)
Total Operating Expenditures 199$ 223,630$ 223,829$ 250,660$ 89.3%250,660$ 154,702$ 69,127$
Operating Revenues Over (Under) Expenditures (199)$ 97,575$ 97,376$ 124,340$ 78.3%124,340$ 15,792$ 14,772$
INTERFUND TRANSACTIONS
Transfer From Hotel Tax Fund -$ -$ -$ -$ N/A -$ -$ -$
Total Interfund Transactions -$ -$ -$ -$ N/A -$ -$ -$
Total Revenues Over (Under) Expenditures - Budgetary Basis (199)$ 97,575$ 97,376$ 124,340$ 124,340$ 15,792$ 14,772$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay -$ -$ -$ 119,988$
Depreciation Expense - (1,685) (1,685) (13,820)
Total GAAP Adjustments -$ (1,685)$ (1,685)$ 106,168$
Fund Increase/(Decrease) - GAAP Basis (199)$ 95,890$ 95,691$ 121,960$
*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 December 31, 2022
12/31/22 12/31/22
821 YTD % of YTD 2022 12/31/21 Difference
B&T Amended Amended Adopted YTD Prior
Clubhouse Budget Budget Budget Total Year
OPERATING REVENUES
Rentals 354,269$ 351,275$ 100.9%351,275$ 216,189$ 138,080$
Other Revenue - - 0.0%- (19,805) 19,805
Total Operating Revenues 354,269$ 351,275$ 100.9%351,275$ 196,384$ 157,885$
OPERATING EXPENDITURES
Personnel 135,657$ 140,250$ 96.7%140,250$ 126,165$ 9,492$
Materials & Supplies 19,460 15,350 126.8%15,350 6,867 12,593
Operational & Contractual 79,775 92,600 86.1%92,600 72,936 6,839
Capital - 50,000 0.0%50,000 4,382 (4,382)
Total Operating Expenditures 234,892$ 298,200$ 78.8%298,200$ 210,350$ 24,542$
B&T Administration Overhead Allocation*(32,738)$ -$ N/A (68,810)$ (24,921)$ (7,817)$
Operating Revenues Over (Under) Expenditures 86,639$ 53,075$ 163.2%(15,735)$ (38,887)$ 125,526$
INTERFUND TRANSACTIONS
Transfer From General Fund -$ -$ 0.0%-$ -$ -$
Total Interfund Transactions -$ -$ 0.0%-$ -$ -$
Total Revenues Over (Under) Expenditures - Budgetary Basis 86,639$ 53,075$ (15,735)$ (38,887)$ 125,526$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay -$ 4,382$
Depreciation Expense (25,000) (62,600)
IMRF Pension Expense (1,250) (2,000)
OPEB Expense (1,250) (2,750)
Total GAAP Adjustments (27,500)$ (62,968)$
Fund Increase/(Decrease) - GAAP Basis 59,139$ (101,855)$
*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 December 31, 2022
12/31/22 12/31/22
823 831 832 833 834 12/31/22 YTD % of YTD 2022 12/31/21 Difference
Golf Golf General Golf Learning Golf Cart Golf Course YTD Amended Amended Adopted YTD Prior
Café Operation & Practice Operations Maintenance Total Budget Budget Budget Total Year
OPERATING REVENUES
Memberships -$ 404,975$ -$ -$ -$ 404,975$ 352,800$ 114.8%352,800$ 355,865$ 49,110$
Greens Fees - 1,259,625 - - - 1,259,625 1,145,000 110.0%1,145,000 1,304,076 (44,451)
Pro Shop Sales - 226,529 - - - 226,529 210,000 107.9%210,000 244,194 (17,665)
Golf Lessons - - 35,815 - - 35,815 50,000 71.6%50,000 50,140 (14,325)
Driving Range Fees - - 356,233 - - 356,233 300,000 118.7%300,000 341,440 14,793
Rentals - 3,105 - 454,097 - 457,202 387,500 118.0%387,500 499,016 (41,814)
Food Sales 273,057 - - - - 273,057 250,000 109.2%250,000 280,382 (7,325)
Beverage Sales 484,388 - - - - 484,388 470,000 103.1%470,000 496,244 (11,856)
Other Revenue 17,028 (309) - - - 16,719 7,000 238.8%7,000 13,901 2,818
Total Operating Revenues 774,473$ 1,893,925$ 392,048$ 454,097$ -$ 3,514,542$ 3,172,300$ 110.8%3,172,300$ 3,585,258$ (70,716)$
OPERATING EXPENDITURES
Personnel 246,327$ 569,424$ 59,482$ 42,611$ 349,915$ 1,267,759$ 1,403,780$ 90.3%1,403,780$ 1,320,567$ (52,808)$
Materials & Supplies 284,914 198,141 19,958 1,006 205,976 709,995 627,500 113.1%627,500 676,637 33,358
Operational & Contractual 7,487 227,688 6,301 58,817 52,674 352,967 293,475 120.3%293,475 379,459 (26,492)
Other - - - - - - - N/A - (39,000) 39,000
Capital - 131,321 - - - 131,321 359,000 36.6%359,000 146,918 (15,597)
Total Operating Expenditures 538,728$ 1,126,574$ 85,741$ 102,434$ 608,566$ 2,462,043$ 2,683,755$ 91.7%2,683,755$ 2,484,581$ (22,538)$
Operating Revenues Over (Under) Expenditures 235,744$ 767,351$ 306,307$ 351,663$ (608,566)$ 1,052,499$ 488,545$ 215.4%488,545$ 1,100,677$ (48,178)$
INTERFUND TRANSACTIONS
Transfer from Golf Surcharge -$ -$ -$ -$ -$ -$ 150,000$ 0.0%150,000$ -$ -$
Reimbursement to General Fund - (51,876) - - - (51,876) (56,590) 91.7%(56,590) (47,175) (4,701)
Total Interfund Transactions -$ (51,876)$ -$ -$ -$ (51,876)$ 93,410$ -55.5%93,410$ (47,175)$ (4,701)$
Total Revenues Over (Under) Expenditures - Budgetary Basis 235,744$ 715,475$ 306,307$ 351,663$ (608,566)$ 1,000,623$ 581,955$ 581,955$ 1,053,502$ (52,879)$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay -$ 131,321$ -$ -$ -$ 131,321$ 146,918$
Depreciation Expense (1,000) (105,000) (2,300) (13,000) (125,000) (246,300) (235,935)
IMRF Pension Expense (2,500) (10,000) (1,000) - (11,000) (24,500) (23,000)
OPEB Expense (3,000) (15,000) - - (10,000) (28,000) (23,100)
Total GAAP Adjustments (6,500)$ 1,321$ (3,300)$ (13,000)$ (146,000)$ (167,479)$ (135,117)$
Fund Increase/(Decrease) - GAAP Basis 229,244$ 716,796$ 303,007$ 338,663$ (754,566)$ 833,144$ 918,385$
*Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.