Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
May 2023 Financial Report
Monthly Financial Reports May 2023 Table of Contents General Fund ................................................................................................ 1 Harnett Regional Jetport Fund ..................................................................... 6 American Rescue Plan Act Fund ................................................................. 10 Harnett Regional Water Fund .................................................................... 11 Solid Waste Fund ....................................................................................... 13 Worker’s Compensation Fund .................................................................... 15 Unemployment Insurance Fund ................................................................. 17 Employee Clinic Fund ................................................................................. 19 Medical Self Insurance Fund ...................................................................... 21 Dental Self Insurance Fund ........................................................................ 23 Retiree Self Insurance Fund ....................................................................... 25 Fleet Services Fund ..................................................................................... 27 Information Technology Fund .................................................................... 29 Veteran’s Treatment Court Fund .............................................................. 31 Monthly Sales Tax Analysis by Article ........................................................ 33 Revenue Category Budget Actual Budget Actual Budget Actual 30 - TAXES - AD VALOREM 66,850,000 70,991,210.26 72,701,330 73,709,701.88 77,645,000 78,071,755.59 71,719,661.27 31 - TAXES - SALES 18,400,000 23,875,039.72 22,300,000 26,539,012.42 21,416,000 18,832,520.80 16,706,461.51 32 - TAXES - OTHER 530,000 1,012,526.63 730,000 1,565,634.08 1,164,000 1,372,014.43 1,398,005.32 33 - RESTRICTED REVENUE 21,619,089 19,260,581.08 21,618,923 19,448,221.74 23,021,451 18,696,276.79 16,466,575.57 34 - RESTRICTED REVENUE 2,220,000 4,843,663.02 3,700,000 5,550,492.66 3,110,000 6,367,851.94 5,225,953.18 35 - SERVICE CHARGES 15,319,535 13,778,720.42 13,334,288 15,145,099.60 14,615,204 17,835,292.66 13,345,244.09 36 - ENTERPRISE CHARGES 3,000 1,672.35 1,600 2,927.17 0 4,242.71 2,859.82 38 - MISCELLANEOUS INCOME 1,551,807 1,803,513.67 1,737,467 1,704,613.93 2,011,123 2,105,941.82 1,536,570.51 39 - NON-REVENUE RECEIPTS 11,942,137 2,185,791.26 9,131,314 781,184.62 27,620,715 1,123,259.00 59,932.00 110 - GENERAL FUND REVENUE $138,435,568 $137,752,718.41 $145,254,922 $144,446,888.10 $170,603,493 $144,409,155.74 $126,461,263.27 Expense Function Department Budget Actual Budget Actual Budget Actual 110 - GENERAL 00 - GENERAL GOVERNMENT 4110 - GOVERNING BODY 788,447 777,246.30 1,097,890 700,681.26 918,415 681,987.55 457,660.06 4120 - COUNTY ADMINISTRATION 1,036,614 967,139.30 1,168,511 1,084,649.28 1,160,594 916,499.65 959,302.60 4130 - FINANCE 1,306,824 1,302,523.38 1,575,325 1,446,970.66 1,619,365 1,318,244.66 1,279,722.79 4131 - RETIREE INSURANCE 882,000 836,451.90 882,000 881,998.48 944,351 711,059.21 741,013.43 4140 - TAX 1,551,703 1,375,145.61 1,858,149 1,638,278.00 1,999,758 1,490,437.49 1,381,610.40 4150 - LEGAL SERVICES 363,565 317,124.91 348,564 335,989.02 387,832 321,486.25 288,124.60 4160 - HUMAN RESOURCES 505,151 485,996.12 812,570 765,241.54 966,968 801,673.63 657,915.80 4170 - BOARD OF ELECTIONS 597,465 524,487.82 611,967 486,986.66 577,506 522,566.99 398,421.15 4180 - CLERK OF COURT 26,083 13,338.15 22,283 15,003.96 28,233 16,863.40 13,792.01 4190 - REGISTER OF DEEDS 889,071 731,345.62 764,991 733,004.63 810,075 682,749.28 630,925.02 4210 - GENERAL SERVICES 227,775 226,379.33 243,609 238,037.30 255,027 221,509.06 208,702.93 4230 - FACILITIES MAINTENANCE 3,610,387 3,370,988.28 3,218,002 3,169,355.98 3,595,600 2,817,519.67 2,447,583.71 4250 - FLEET MAINTENANCE 629,738 605,175.27 780,677 777,916.82 907,315 726,816.17 671,048.13 4270 - INFORMATION TECHNOLOGY 2,554,198 2,498,933.29 2,545,738 2,522,795.76 2,736,780 2,353,421.58 2,045,774.32 4290 - GIS 700,709 667,520.21 793,447 725,435.75 846,687 716,860.81 606,894.03 9800 - INTERFUND TRANSFERS 21,454,238 21,454,238.00 18,418,352 18,418,352.00 33,106,322 25,796,294.00 14,776,748.00 9910 - CONTINGENCY 454,020 0.00 126,644 0.00 475,665 0.00 0.00 00 - GENERAL GOVERNMENT Total $37,577,988 $36,154,033.49 $35,268,719 $33,940,697.10 $51,336,493 $40,095,989.40 $27,565,238.98 FY 2022 FY 2022 General Fund as of May 31, 2023 Same Period Last Year FY 2021 FY 2021 Same Period Last Year FY 2023 FY 2023 General Fund 110 1 of 33 05.2023 Monthly Master Expense Function Department Budget Actual Budget Actual Budget Actual FY 2022 Same Period Last Year FY 2021 FY 2023 10 - PUBLIC SAFETY 4300 - PUBLIC SAFETY 0 0.00 0 0.00 0 0.00 0.00 4310 - SHERIFF 12,192,507 11,767,113.14 13,182,650 12,698,552.66 14,092,957 11,519,060.34 10,791,154.91 4330 - CAMPBELL DEPUTIES 477,204 462,180.48 540,424 505,786.76 586,694 510,019.34 447,324.98 4350 - SCHOOL RESOURCE OFFICER 2,254,482 1,636,706.45 2,104,893 1,780,756.12 2,147,192 1,327,372.51 1,508,763.60 4370 - CHILD SUPPORT ENFORCEMENT 71,676 69,418.10 92,371 85,148.89 91,087 85,179.64 74,177.64 4390 - JAIL 5,836,177 5,714,088.79 6,871,307 6,274,841.72 7,546,885 5,731,113.01 4,812,170.62 4410 - EMERGENCY MANAGEMENT 1,004,854 917,365.40 1,072,232 1,024,568.72 1,187,136 979,485.61 893,560.78 4411 - EMERGENCY SERVICES GRANTS 208,975 206,851.32 109,718 81,595.82 442,695 250,499.57 71,350.41 4450 - EMERGENCY MEDICAL SERVICE 9,162,453 8,307,576.45 9,424,313 8,874,222.88 10,982,362 8,056,537.19 7,565,583.04 4451 - EMS TRANSPORTS 0 0.00 0 0.00 0 0.00 0.00 4470 - RESCUE DISTRICTS 3,673,427 3,673,427.00 3,783,630 3,749,400.37 5,403,151 5,055,259.24 3,749,400.37 4510 - FIELD SERVICES 321,672 304,222.75 370,958 320,814.44 423,264 339,408.32 263,623.40 4512 - ANIMAL SHELTER 359,570 253,890.05 357,920 238,345.89 442,446 311,597.10 182,403.44 4530 - MEDICAL EXAMINER 95,000 87,000.00 488,580 99,550.00 100,000 64,450.00 91,900.00 4570 - COMMUNICATIONS 1,762,248 1,678,534.79 2,038,639 1,754,234.23 2,169,081 1,570,887.31 1,455,837.01 4915 - INSPECTIONS 0 0.00 1,061,034 894,169.11 1,152,661 908,623.03 744,958.09 10 - PUBLIC SAFETY Total $37,420,245 $35,078,374.72 $41,498,669 $38,381,987.61 $46,767,611 $36,709,492.21 $32,652,208.29 20 - TRANSPORTATION 4610 - TRANSPORTATION 1,513,691 1,029,779.25 1,733,673 1,012,934.33 1,493,881 888,712.23 886,636.68 4630 - TRANSPORTATION - ADMIN 739,696 706,044.94 606,006 261,355.74 1,131,599 375,089.65 238,962.52 4650 - HARNETT REGIONAL JETPORT 509,520 417,451.00 0 0.00 0 0.00 0.00 20 - TRANSPORTATION Total $2,762,907 $2,153,275.19 $2,339,679 $1,274,290.07 $2,625,480 $1,263,801.88 $1,125,599.20 30 - ENVIRONMENTAL PROTECTION 4710 - SOIL & WATER 237,233 218,946.11 261,378 254,800.08 309,461 256,589.26 220,382.81 4730 - FORESTRY PROGRAM 138,026 135,320.77 130,722 126,844.67 152,709 110,839.27 104,963.61 4750 - ENVIROMENTAL PROT ALLOC 6,000 6,000.00 12,000 11,000.00 12,000 11,900.00 11,000.00 30 - ENVIRONMENTAL PROTECTION Total $381,259 $360,266.88 $404,100 392,644.75 $474,170 $379,328.53 $336,346.42 40 - ECONOMIC & PHYSICAL DEVELOPMNT 4910 - DEVELOPMENT SERVICES 1,665,394 1,644,998.81 995,192 983,246.49 1,119,722 910,636.79 868,657.41 4930 - ECONOMIC DEVELOPMENT 777,877 675,911.43 1,046,120 860,876.07 1,111,354 818,720.85 798,152.07 4950 - COMMUNITY DEVELOPMENT 925 554.81 455 82.59 457 78.03 24.79 4951 - ABANDONED MFG HOME 0 0.00 0 0.00 0 0.00 0.00 4990 - COOPERATIVE EXTENSION 405,145 334,915.00 426,907 418,943.43 427,722 324,845.77 338,681.55 4995 - COOPERATIVE EXT SPECIAL PROG 170,152 80,618.74 135,332 105,558.83 158,799 99,617.40 90,901.35 40 - ECONOMIC & PHYSICAL DEVELOPMNT Total $3,019,493 $2,736,998.79 $2,604,006 $2,368,707.41 $2,818,054 $2,153,898.84 $2,096,417.17 General Fund 110 2 of 33 05.2023 Monthly Master Expense Function Department Budget Actual Budget Actual Budget Actual FY 2022 Same Period Last Year FY 2021 FY 2023 50 - HUMAN SERVICES 5110 - GENERAL ADMINISTRATION 7,370,852 5,797,516.31 9,432,669 6,312,375.88 9,637,937 6,433,270.00 5,480,894.70 5120 - CHILD HEALTH 0 0.00 0 0.00 0 0.00 0.00 5130 - ADULT HEALTH 0 0.00 0 0.00 0 0.00 0.00 5140 - HEALTH EDUCATION 0 0.00 0 0.00 0 0.00 0.00 5150 - WIC - ADMINISTRATION 0 0.00 0 0.00 0 0.00 0.00 5170 - BIOTERRORISM 0 0.00 0 0.00 0 0.00 0.00 5180 - ENVIRONMENTAL SERVICES 0 0.00 0 0.00 0 0.00 0.00 5210 - MENTAL HEALTH 605,679 605,679.00 605,679 605,679.00 605,679 605,679.00 605,679.00 5260 - HEALTH - SENIOR SERVICES 1,679,594 1,460,031.51 1,724,938 $1,432,025.35 1,726,073 1,252,075.13 1,226,757.76 5310 - DSS - ADMINISTRATION 2,436,585 2,255,368.91 2,177,621 2,068,015.24 2,398,802 2,017,760.67 1,821,442.30 5311 - DSS - FRAUD PREVENTION 297,397 293,135.82 359,970 355,120.19 386,647 332,793.23 308,979.49 5320 - DSS - ADULT SERVICES 888,982 851,855.81 1,079,763 933,879.69 1,156,996 964,441.46 779,770.12 5321 - DSS - WORKFIRST 303,231 281,561.51 370,509 300,623.74 378,702 272,217.78 259,063.30 5322 - DSS - ENERGY PROGRAMS 1,374,286 1,220,383.03 2,472,707 2,054,900.57 1,602,534 852,070.01 2,019,399.99 5330 - DSS - CHILD CARE SUBSIDY 376,627 366,092.70 439,779 422,234.66 459,647 395,041.22 372,082.73 5331 - DSS - CHILD PROTECTIVE SRVCS 2,127,436 2,016,036.47 2,231,213 2,128,536.64 2,330,626 1,799,531.86 1,850,580.96 5332 - DSS - FOSTER CARE 2,711,023 2,504,118.07 3,053,187 2,898,902.18 3,993,959 3,224,533.10 2,426,978.30 5333 - DSS - ADOPTION 397,847 290,006.27 395,295 321,147.43 582,600 311,990.31 286,735.68 5334 - DSS - DAY CARE 22,315 10,488.00 0 0.00 0 0.00 0.00 5340 - DSS - CHILD SUPPORT 1,331,417 1,229,087.03 1,559,968 1,427,942.69 1,600,976 1,236,463.50 1,233,891.01 5350 - DSS - MEDICAID 0 0.00 0 0.00 0 0.00 0.00 5351 - DSS - ADULT MEDICAID 2,215,437 2,065,004.64 2,349,386 1,941,026.61 2,463,225 1,845,111.04 1,712,296.33 5352 - DSS - FAMILY & CHLDRN MEDICAID 1,541,975 1,503,778.69 1,754,283 1,557,853.10 1,791,823 1,457,480.05 1,359,631.80 5353 - DSS - MEDICAID TRANSPORTATION 211,078 190,776.42 224,629 204,783.19 258,360 194,515.89 175,579.53 5360 - DSS - TEMPORARY RESOURCES 124 0.00 0 0.00 0 0.00 0.00 5370 - DSS - FOOD STAMPS 1,498,504 1,473,856.97 1,702,309 1,614,919.33 1,975,283 1,550,168.16 1,406,536.75 5810 - VETERANS SERVICES 304,997 273,925.29 331,193 307,382.90 356,053 286,924.30 248,345.15 5870 - RESTITUTION 82,712 79,168.66 88,706 85,044.76 107,250 81,278.84 73,707.77 5895 - HUMAN SERVICES APPROPRIATIONS 32,000 0.00 0 0.00 0 0.00 0.00 50 - HUMAN SERVICES Total $27,810,098 $24,767,871.11 $32,353,804 $26,972,393.15 $33,813,172 $25,113,345.55 $23,648,352.67 70 - EDUCATION 5910 - BOARD OF EDUCATION 24,680,603 24,680,603.00 25,532,777 25,532,776.55 26,121,589 24,003,123.25 25,532,775.55 5920 - CCCC 1,621,978 1,359,842.33 1,835,077 1,502,947.48 1,752,605 1,370,252.90 1,249,649.89 70 - EDUCATION Total $26,302,581 $26,040,445.33 $27,367,854 $27,035,724.03 $27,874,194 $25,373,376.15 $26,782,425.44 80 - CULTURAL & RECREATION 6110 - PARKS & RECREATION 1,399,432 1,255,861.31 1,530,087 1,402,144.12 1,752,797 1,295,732.98 1,215,028.12 6170 - MAIN LIBRARY 1,542,378 1,325,297.41 1,703,348 1,530,381.73 2,040,861 1,509,269.38 1,276,836.21 6172 - ANGIER BRANCH LIBRARY 0 0.00 0 0.00 253,527 179,931.66 0.00 6175 - COATS BRANCH LIBRARY 0 0.00 0 0.00 151,658 89,942.62 0.00 General Fund 110 3 of 33 05.2023 Monthly Master Expense Function Department Budget Actual Budget Actual Budget Actual FY 2022 Same Period Last Year FY 2021 FY 2023 6176 - DUNN BRANCH LIBRARY 0 0.00 0 0.00 278,839 206,133.85 0.00 6177 - ERWIN BRANCH LIBRARY 0 0.00 0 0.00 156,084 114,081.59 0.00 6199 - CULTURAL & REC APPROP 219,187 184,589.00 184,656 184,656.00 260,553 229,931.00 177,876.00 80 - CULTURAL & RECREATION Total $3,160,997 $2,765,747.72 $3,418,091 $3,117,181.85 $4,894,319 $3,625,023.08 $2,669,740.33 110 - GENERAL FUND EXPENSE $138,435,568 $130,057,013.23 $145,254,922 $133,483,625.97 $170,603,493 $134,714,255.64 $116,876,328.50 110 - GENERAL FUND REVENUE (OVER) / UNDER EXPENSES $0 $7,695,705.18 $0 $10,963,262.13 $0 $9,694,900.10 $9,584,934.77 General Fund 110 4 of 33 05.2023 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 July $33,238,397.31 $42,138,468.69 $54,311,107.96 August $30,766,642.59 $27,193,882.75 $50,946,347.51 September $31,436,740.68 $28,797,031.28 $53,304,998.95 October $32,621,237.60 $29,562,531.87 $53,251,081.77 November $55,768,728.62 $53,048,249.28 $84,604,102.48 December $52,233,891.79 $62,382,452.13 $98,820,637.21 January $49,307,366.28 $53,864,998.95 $66,631,763.25 $103,930,517.64 February $46,553,686.81 $52,435,487.27 $64,815,294.91 $95,788,158.44 March $48,087,241.40 $54,340,963.07 $68,066,131.09 $87,327,817.65 April $45,974,675.17 $53,068,500.85 $67,511,156.89 $86,661,673.46 May $41,927,274.60 $52,229,820.40 $63,702,091.44 $73,179,334.51 June $40,106,511.08 $45,039,854.80 $57,596,531.97 General Fund as of May 31, 2023 CASH General Fund Cash 5 of 33 05.2023 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 33 - RESTRICTED REVENUE 0 0.00 0 0.00 82,000 82,000.00 0.00 35 - SERVICE CHARGES 0 0.00 916,253 818,441.42 1,086,377 780,278.82 718,164.78 38 - MISCELLANEOUS INCOME 0 0.00 60,412 64,174.05 74,329 87,721.99 56,023.19 120 - HR JETPORT FUND REVENUE $0 $0.00 $976,665 $882,615.47 $1,242,706 $950,000.81 $774,187.97 Expense Function Department Budget Actual Budget Actual Budget Actual 120 - HARNETT REGIONAL JETPORT 4650 - HARNETT REGIONAL JETPORT 50 - SALARIES & BENEFITS 0 0.00 192,671 189,277.02 310,165 172,914.02 167,671.18 51 - PROFESSIONAL SRVCS 0 0.00 0 0.00 8,234 8,234.00 0.00 52 - SUPPLIES & MATERIALS 0 0.00 655,687 599,651.47 739,487 623,357.96 435,644.05 53 - CURRENT SRVCS 0 0.00 47,361 42,861.13 84,113 43,829.29 32,793.35 54 - FIXED CHARGES 0 0.00 46,049 42,341.22 58,347 49,267.97 39,728.32 55 - CAPITAL OUTLAY 0 0.00 15,971 15,971.00 42,000 41,301.00 15,971.00 58 - NON-CAPTALIZED ASSTS 0 0.00 18,926 17,927.33 360 0.00 0.00 70 - PCARD ENCUMBRANCE 0 0.00 0 0.00 0 0.00 0.00 120 - HR JETPORT FUND EXPENSE $0 $0.00 $976,665 $908,029.17 $1,242,706 $938,904.24 $691,807.90 120 - HR JETPORT FUND REVENUE (OVER) / UNDER EXPENSES $0 $0.00 $0 $25,413.70 $0 $11,096.57 $82,380.07 FY 2022 FY 2022 Harnett Regional Jetport Fund as of May 31, 2023 FY 2021 FY 2021 FY 2023 Same Period Last Year FY 2023 Same Period Last Year HRJetport Fund 120 6 of 33 05.2023 Monthly Master Airport Avgas 02/27 JetA 02/27 Avgas 03/27 JetA 03/27 Avgas 04/24 JetA 04/24 Avgas 05/29 JetA 05/29 Harnett Regional Jetport 5.15$ 5.40$ 5.15$ 5.40$ 5.15$ 5.40$ 5.15$ 5.40$ Clinton 5.65$ 5.75$ 5.65$ 5.75$ 5.65$ 5.75$ 5.65$ 5.75$ Duplin County 5.47$ 5.41$ 5.47$ 5.34$ 5.54$ 4.94$ 5.54$ 4.54$ Elizabethtown 4.30$ 4.20$ 4.70$ 4.20$ 4.70$ 4.20$ 5.00$ 4.20$ Fayetteville 6.22$ 7.33$ 6.22$ 7.28$ 6.02$ 6.91$ 7.02$ 6.63$ Gray's Creek 5.80$ NA 5.80$ NA 5.80$ NA 5.80$ NA Johnston County 6.12$ 6.22$ 6.12$ 6.22$ 6.12$ 6.22$ 6.12$ 6.12$ Lauringburg-Maxton 5.99$ 6.38$ 5.74$ 5.90$ 5.45$ 5.90$ 5.15$ 5.90$ Lumberton 4.82$ 4.71$ 5.20$ 4.71$ 5.20$ 4.71$ 5.20$ 4.06$ Moore County 5.60$ 6.70$ 5.90$ 6.80$ 5.90$ 6.80$ 6.60$ 6.25$ Mount Olive 5.26$ 5.19$ 5.30$ 4.76$ 5.51$ 4.47$ 5.09$ 4.09$ Raleigh Exec 5.70$ 5.76$ 5.88$ 5.77$ 6.15$ 5.53$ 5.89$ 5.03$ Rocky Mount- Wilson 4.95$ 5.91$ 4.95$ 5.91$ 4.95$ 4.49$ 5.28$ 4.79$ Siler City 5.99$ 5.99$ 5.99$ 5.99$ 5.99$ 5.99$ 6.19$ 5.99$ Triangle North 6.49$ 6.49$ 6.19$ 6.39$ 5.59$ 5.79$ 5.29$ 5.49$ Wayne Executive (Goldsboro)5.37$ 4.88$ 5.37$ 4.88$ 5.37$ 4.88$ 4.76$ 4.88$ Whiteville 4.40$ 4.30$ 5.25$ 4.30$ 5.25$ 4.30$ 5.25$ 4.00$ Average of All Others 5.51$ 5.68$ 5.61$ 5.61$ 5.57$ 5.39$ 5.61$ 5.18$ HRJ Fuel Price Comparison with Surrounding Airports By Date & Types (AvGas - JetA) Jetport Fuel Price Comp 7 of 33 05.2023 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 July $0.00 ($10,408.95) $58,373.33 August $0.00 $38,091.69 $15,679.56 September $0.00 $36,352.20 ($18,164.21) October $0.00 $21,459.01 $19,438.98 November $0.00 $16,092.97 $20,417.68 December $0.00 ($6,777.19)$28,902.77 January $0.00 $0.00 ($13,727.75)$52,597.97 February $0.00 $0.00 $13,226.32 $135,754.85 March $0.00 $0.00 ($31,248.47)$113,504.96 April $0.00 $0.00 $26,128.75 $85,652.01 May $0.00 $0.00 $21,848.15 $23,819.38 June $0.00 $0.00 $0.38 CASH Harnett Regional Jetport as of May 31, 2023 HRJetport Fund Cash 8 of 33 05.2023 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 July $0.00 $59,505.03 $51,698.20 August $0.00 $29,721.24 $67,748.43 September $0.00 $33,441.27 $60,548.35 October $0.00 $50,458.29 $48,640.25 November $0.00 $47,552.93 $59,025.04 December $0.00 $48,472.67 $38,546.58 January $0.00 $0.00 $65,652.06 $49,149.97 February $0.00 $0.00 $58,787.79 $52,832.84 March $0.00 $0.00 $42,570.99 $35,356.34 April $0.00 $0.00 $65,608.49 $47,375.72 May $0.00 $0.00 $35,441.10 $60,413.82 June $0.00 $0.00 $51,698.20 INVENTORY Harnett Regional Jetport as of May 31, 2023 HRJetport Fund Inventory 9 of 33 05.2023 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 33 - RESTRICTED REVENUE 0 0.00 6,003,877 6,003,877.00 10,015,000 0.00 0.00 35 - SERVICE CHARGES 0 0.00 0 20,997.06 0 768,377.05 10,362.30 38 - MISCELLANEOUS INCOME 0 0.00 0 0.00 0 0.00 0.00 39 - NON-REVENUE RECEIPTS 0 0.00 0 0.00 0.00 0.00 0.00 292 - ARPA FUND REVENUE $0 $0.00 $6,003,877 $6,024,874.06 $10,015,000 $768,377.05 $10,362.30 Revenue Category Budget Actual Budget Actual Budget Actual 292 - AMERICAN RESCUE PLAN ACT SRF 9990 - NON-DEPARTMENTAL 0 $0.00 0 $0.00 15,000 $15,000.00 $0.00 4120 - COUNTY ADMINISTRATION 0 $0.00 0 $0.00 0 $117,822.60 $0.00 4450 - EMERGENCY MEDICAL SERVICE 0 $0.00 0 $0.00 0 $0.00 $0.00 4591 - RADIO SYSTEM 0 $0.00 6,003,877 $6,003,877.00 10,000,000 $1,043,259.00 $0.00 292 - ARPA FUND EXPENSE $0 $0.00 $6,003,877 $6,003,877.00 $10,015,000 $1,176,081.60 $0.00 292 - ARPA FUND REVENUE (OVER) / UNDER EXPENSES $0 $0.00 $0 $20,997.06 $0 $407,704.55 $10,362.30 Same Period Last Year FY 2023FY 2021 FY 2022 Same Period Last Year FY 2023 American Rescue Plan Act Fund as of May 31, 2023 FY 2021 FY 2022 ARPA Fund 292 10 of 33 05.2023 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 33 - RESTRICTED REVENUE 3,703 325,618.70 3,703 0.00 0 0.00 0.00 35 - SERVICE CHARGES 10,581 2,561.90 10,000 1,148.84 10,000 454,006.32 1,106.65 36 - ENTERPRISE CHARGES 1,583,500 1,663,356.41 1,384,000 2,379,865.25 1,761,500 2,176,296.36 2,142,242.19 37 - FACILITY FEES 34,600,000 39,100,367.08 35,875,000 39,966,546.68 37,564,650 35,343,498.92 33,165,973.81 38 - MISCELLANEOUS INCOME 710,000 4,045,071.83 552,094 9,532,429.38 320,000 677,666.92 1,247,012.89 39 - NON-REVENUE RECEIPTS 14,305,000 0.00 2,217,039 2,208,738.19 25,359,677 0.00 0.00 610 - HRW FUND REVENUE $51,212,784 $45,136,975.92 $40,041,836 $54,088,728.34 $65,015,827 $38,651,468.52 $36,556,335.54 Expense Function Department Budget Actual Budget Actual Budget Actual 610 - HARNETT REGIONAL WATER 91 - WATER & SEWER 7111 - HRW ADMINISTRATION 5,695,304 4,190,297.32 5,192,369 4,579,044.21 6,253,837 3,985,428.54 3,882,663.66 7113 - WATER TREATMENT PLANT 5,966,684 4,988,907.10 6,785,996 5,848,978.24 8,435,629 6,420,222.53 5,003,831.70 7115 - WASTEWATER TREATMENT PLANT 3,385,564 2,245,476.78 3,715,242 2,911,906.21 3,583,141 2,547,021.51 2,355,740.79 7117 - SOUTH HARNETT WASTEWATER PLANT 2,975,213 2,442,340.96 3,622,758 3,156,372.31 3,737,799 2,327,438.94 2,538,049.78 7119 - WATER DISTRIBUTION 5,065,366 4,372,934.46 5,449,739 4,790,103.03 6,396,571 4,395,939.33 4,174,901.32 7121 - SEWER COLLECTIONS 5,446,344 4,305,290.43 5,773,595 4,806,693.91 5,697,048 3,865,322.22 3,561,211.11 7131 - RETIREE INSURANCE HRW 0 0.00 60,807 65,678.76 63,829 55,972.26 54,162.74 9990 - NON-DEPARTMENTAL 22,678,309 $31,241,868.35 9,441,330 19,160,759.58 30,847,973 28,847,973.00 6,448,433.05 610 - HRW FUND EXPENSE $51,212,784 $53,787,115.40 $40,041,836 $45,319,536.25 $65,015,827 $52,445,318.33 $28,018,994.15 610 - HRW FUND REVENUE (OVER) / UNDER EXPENSES $0 $8,650,139.48 $0 $8,769,192.09 $0 $13,793,849.81 $8,537,341.39 Harnett Regional Water Fund as of May 31, 2023 FY 2023 FY 2021 FY 2021 FY 2023FY 2022 FY 2022 Same Period Last Year Same Period Last Year HRW Fund 610 11 of 33 05.2023 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 July $56,308,485.60 $51,396,573.71 $69,906,540.92 August $57,887,471.15 $53,478,105.50 $71,395,812.59 September $53,052,496.69 $54,740,839.35 $72,918,273.72 October $41,972,645.61 $57,802,598.49 $74,956,217.38 November $44,623,020.08 $59,929,869.87 $77,010,360.42 December $46,244,526.10 $61,433,187.37 $78,805,658.04 January $57,818,912.12 $47,842,388.74 $63,336,473.21 $79,769,987.45 February $58,911,946.79 $49,655,875.28 $65,045,521.23 $56,832,826.21 March $60,961,613.87 $51,249,479.82 $62,345,519.84 $53,955,027.95 April $60,643,544.18 $52,788,896.94 $62,323,826.87 $55,336,607.53 May $61,748,714.89 $55,026,201.87 $57,960,361.56 $56,056,136.19 June $55,307,862.26 $48,531,475.46 $58,710,523.48 Harnett Regional Water Fund as of May 31, 2023 CASH HRW Fund Cash 12 of 33 05.2023 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 30 - TAXES - AD VALOREM 0 0.00 0 0.00 0 0.00 0.00 33 - RESTRICTED REVENUE 282,000 299,010.13 335,000 333,365.11 260,000 283,192.49 247,596.93 35 - SERVICE CHARGES 553 2,072.25 0 410.26 0 15,828.51 376.87 36 - ENTERPRISE CHARGES 1,910,200 3,114,682.13 3,116,088 3,455,130.23 3,414,080 3,310,581.54 2,915,649.45 37 - FACILITY FEES 4,581,020 4,648,605.96 4,745,000 4,722,829.38 4,520,000 4,806,138.34 4,707,519.15 38 - MISCELLANEOUS INCOME 100,733 138,848.24 45,000 124,396.71 251,981 262,198.82 111,616.51 39 - NON-REVENUE RECEIPTS 0 0.00 397,860 0.00 103,000 0.00 0.00 660 - SOLID WASTE FUND REVENUE $6,874,506 $8,203,218.71 $8,638,948 $8,636,131.69 $8,549,061 $8,677,939.70 $7,982,758.91 Expense Function Department Budget Actual Budget Actual Budget Actual 660 - SOLID WASTE MANAGEMENT 96 - SOLID WASTE 7410 - SOLID WASTE MANAGEMENT 5,382,988 5,135,026.60 6,472,964 5,698,296.50 7,628,133 4,875,730.87 4,709,432.43 7431 - RETIREE INSURANCE SW 0 0.00 20,000 20,448.00 20,000 22,753.00 18,293.07 9990 - NON-DEPARTMENTAL 1,491,518 1,939,858.33 2,145,984 2,459,955.28 900,928 900,928.00 353,550.00 610 - SOLID WASTE FUND EXPENSE $6,874,506 $7,074,884.93 $8,638,948 $8,178,699.78 $8,549,061 $5,799,411.87 $5,081,275.50 660 - SOLID WASTE FUND REVENUE (OVER) / UNDER EXPENSES $0 $1,128,333.78 $0 $457,431.91 $0 $2,878,527.83 $2,901,483.41 FY 2022 FY 2022 Solid Waste Fund as of May 31, 2023 Same Period Last Year FY 2023 FY 2023FY 2021 Same Period Last Year FY 2021 Solid Waste Fund 660 13 of 33 05.2023 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 July $3,387,995.72 $4,457,425.74 $5,242,053.75 August $3,375,944.64 $4,647,598.39 $5,341,058.08 September $3,607,274.52 $4,882,131.66 $5,547,560.45 October $3,759,678.53 $5,029,336.00 $5,661,414.55 November $5,581,197.69 $6,828,615.40 $7,650,032.21 December $6,451,303.81 $7,686,623.97 $8,441,890.85 January $4,616,721.91 $5,784,640.53 $8,071,097.98 $8,957,335.18 February $4,751,271.26 $5,844,033.09 $8,201,845.59 $9,072,792.36 March $4,565,672.41 $5,773,139.20 $8,188,060.38 $8,162,225.83 April $4,268,648.15 $5,713,193.95 $7,697,878.34 $7,939,798.65 May $4,194,405.45 $5,677,132.65 $7,291,803.85 $7,813,101.19 June $3,590,915.49 $4,646,306.54 $5,409,762.66 Solid Waste Fund as of May 31, 2023 CASH Solid Waste Fund Cash 14 of 33 05.2023 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 1,200,000 1,134,569.36 760,000 1,322,417.89 850,000 503,090.62 1,146,164.10 38 - MISCELLANEOUS INCOME 0 1,350.81 0 0.00 0 5,792.57 1,784.13 39 - NON-REVENUE RECEIPTS 11,700 0.00 0 0.00 0 0.00 0.00 810 - WORKER'S COMP FUND REVENUE $1,211,700 $1,135,920.17 $760,000 $1,322,417.89 $850,000 $508,883.19 $1,147,948.23 Expense Function Department Budget Actual Budget Actual Budget Actual 810 - WORKERS COMPENSATION FUND 00 - GENERAL GOVERNMENT 9301 - WORKER'S COMPENSATION 1,211,700 180,454.06 760,000 349,599.73 850,000 $635,161.01 426,878.42 810 - WORKER'S COMP FUND EXPENSE $1,211,700 $180,454.06 $760,000 $349,599.73 $850,000 $635,161.01 $426,878.42 810 - WORKERS'S COMP FUND REVENUE (OVER) / UNDER EXPENSES $0 $955,466.11 $0 $972,818.16 $0 $126,277.82 $721,069.81 Worker's Compensation Fund as of May 31, 2023 FY 2023 FY 2022 FY 2022 FY 2021 FY 2021 FY 2023 Same Period Last Year Same Period Last Year Worker's Comp Fund 810 15 of 33 05.2023 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 July $4,629,563.32 $5,397,537.95 $6,198,476.66 August $4,708,459.01 $5,246,986.87 $5,963,212.81 September $4,785,314.35 $5,461,742.83 $5,986,205.95 October $4,844,771.48 $5,445,463.58 $6,015,973.71 November $4,925,635.39 $5,542,243.37 $6,011,959.38 December $4,982,050.03 $5,731,380.38 $6,036,954.24 January $3,318,944.43 $5,056,960.44 $5,816,058.20 $6,008,286.38 February $3,402,272.55 $5,098,194.24 $5,865,374.15 $6,023,150.11 March $4,462,485.39 $5,134,695.99 $5,944,781.80 $6,034,359.79 April $4,544,990.12 $5,193,817.86 $6,032,017.52 $6,041,866.35 May $4,545,144.92 $5,139,295.68 $6,116,497.62 $6,028,294.55 June $4,627,680.64 $5,380,269.92 $6,163,362.66 Worker's Compensation Fund as of May 31, 2023 CASH Worker's Comp Fund Cash 16 of 33 05.2023 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 250,000 221,464.63 250,000 108,674.91 250,000 116,864.04 98,695.52 39 - NON-REVENUE RECEIPTS 0 0.00 0 0.00 1,000,000 0.00 0.00 820 - UNEMPLOYMENT FUND REVENUE $250,000 $221,464.63 $250,000 $108,674.91 $1,250,000 $116,864.04 $98,695.52 Expense Function Department Budget Actual Budget Actual Budget Actual 820 - UNEMPLOYMENT INSURANCE 00 - GENERAL GOVERNMENT 9305 - UNEMPLOYMENT INSURANCE 250,000 19,734.22 250,000 16,813.26 250,000 31,606.81 16,813.26 9910 - CONTINGENCY 0 0.00 0 0.00 1,000,000 1,000,000.00 0.00 00 - GENERAL GOVERNMENT Total 250,000 19,734.22 250,000 16,813.26 1,250,000 1,031,606.81 16,813.26 820 - UNEMPLOYMENT FUND EXPENSE $250,000 $19,734.22 $250,000 $16,813.26 $1,250,000 $1,031,606.81 $16,813.26 820 - UNEMPLOYMENT FUND REVENUE (OVER) / UNDER EXPENSES $0 $201,730.41 $0 $91,861.65 $0 $914,742.77 $81,882.26 Same Period Last Year Same Period Last Year FY 2021 FY 2021 FY 2023 FY 2023 FY 2022 FY 2022 Unemployment Insurance Fund as of May 31, 2023 Unemployment Ins Fund 820 17 of 33 05.2023 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 July $1,564,861.07 $1,753,400.43 $1,850,881.89 August $1,582,832.12 $1,762,410.64 $1,861,008.73 September $1,600,689.65 $1,780,727.76 $1,871,494.58 October $1,618,305.74 $1,780,727.76 $1,881,948.64 November $1,638,946.38 $1,789,872.72 $1,892,577.25 December $1,657,035.68 $1,782,256.94 $1,871,937.68 January $1,474,589.24 $1,675,333.87 $1,791,497.73 $1,882,907.21 February $1,475,924.07 $1,673,523.80 $1,801,313.49 $1,893,735.82 March $1,493,866.97 $1,691,308.04 $1,811,113.56 $1,904,454.36 April $1,511,420.05 $1,709,071.02 $1,820,978.24 $1,915,349.90 May $1,511,420.05 $1,709,071.02 $1,830,806.28 $926,042.90 June $1,529,156.27 $1,748,924.02 $1,840,785.67 Unemployment Insurance Fund as of May 31, 2023 CASH Unemployment Ins Fund Cash 18 of 33 05.2023 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 174,690 158,707.77 180,900 157,395.13 191,875 141,420.00 129,262.23 38 - MISCELLANEOUS INCOME 0 0.00 0 0.00 0 0.00 0.00 39 - NON-REVENUE RECEIPTS 0 0.00 0 0.00 0 0.00 0.00 830 - EMPLOYEE CLINIC FUND REVENUE $174,690 $158,707.77 $180,900 $157,395.13 $191,875 $141,420.00 $129,262.23 Expense Function Department Budget Actual Budget Actual Budget Actual 830 - EMPLOYEE CLINIC 00 - GENERAL GOVERNMENT 9302 - EMPLOYEE CLINIC 174,690 166,113.38 180,900 127,581.04 191,875 156,087.75 111,003.37 830 - EMPLOYEE CLINIC FUND EXPENSE $174,690 $166,113.38 $180,900 $127,581.04 $191,875 $156,087.75 $111,003.37 830 - EMPLOYEE CLINIC FUND REVENUE (OVER) / UNDER EXPENSES $0 $7,405.61 $0 $29,814.09 $0 $14,667.75 $18,258.86 FY 2022 FY 2022 Employee Clinic Fund as of May 31, 2023 FY 2021 FY 2021 FY 2023 FY 2023 Same Period Last Year Same Period Last Year Employee Clinic Fund 830 19 of 33 05.2023 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 July $700,090.56 $692,061.11 $723,019.23 August $697,900.58 $703,376.13 $723,881.09 September $697,339.53 $723,948.07 $723,117.23 October $696,760.57 $714,556.04 $721,661.50 November $695,238.45 $715,794.77 $722,166.94 December $697,288.04 $714,986.69 $722,572.03 January $653,534.82 $696,374.16 $709,565.30 $712,125.82 February $653,489.63 $691,759.00 $709,021.02 $715,311.33 March $655,093.01 $690,369.37 $708,705.76 $706,441.27 April $655,094.11 $691,478.87 $709,557.47 $704,910.81 May $639,617.51 $679,723.63 $703,692.41 $700,768.29 June $668,125.25 $688,250.11 $720,716.69 Employee Clinic Fund as of May 31, 2023 CASH Employee Clinic Fund Cash 20 of 33 05.2023 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 11,296,710 10,509,741.05 10,000,000 10,001,728.55 11,253,500 9,724,324.11 8,607,648.87 38 - MISCELLANEOUS INCOME 17,875 12,867.15 512,000 352,486.51 650,000 1,079,569.69 392,075.28 39 - NON-REVENUE RECEIPTS 1,000,000 0.00 300,000 0.00 323,000 0.00 0.00 841 - MEDICAL SELF INS FUND REVENUE $12,314,585 $10,522,608.20 $10,812,000 $10,354,215.06 $12,226,500 $10,803,893.80 $8,999,724.15 Expense Function Department Budget Actual Budget Actual Budget Actual 841 - MEDICAL INSURANCE - SELF 00 - GENERAL GOVERNMENT 9303 - MEDICAL INSURANCE - SELF 12,314,585 8,815,520.42 10,812,000 9,499,014.57 12,226,500 10,142,043.32 9,433,991.72 841 - MEDICAL SELF INS FUND EXPENSE $12,314,585 $8,815,520.42 $10,812,000 $9,499,014.57 $12,226,500 $10,142,043.32 $9,433,991.72 841 - MEDICAL SELF INS FUND REVENUE (OVER) / UNDER EXPENSES $0 $1,707,087.78 $0 $855,200.49 $0 $661,850.48 $434,267.57 FY 2022 FY 2022 Medical Self Insurance Fund as of May 31, 2023 FY 2021 FY 2021 FY 2023 FY 2023 Same Period Last Year Same Period Last Year Medical Self Ins Fund 841 21 of 33 05.2023 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 July $8,394,410.05 $9,936,719.25 $11,349,904.41 August $8,309,827.07 $9,558,799.23 $10,768,815.17 September $8,147,930.01 $10,182,610.45 $10,928,333.21 October $8,437,620.01 $9,335,253.68 $11,370,700.94 November $8,763,538.51 $9,233,189.07 $11,135,597.77 December $9,045,130.83 $9,259,586.30 $11,221,624.97 January $7,007,592.83 $8,831,273.60 $9,612,099.50 $11,189,119.32 February $7,354,736.35 $9,169,687.18 $9,498,226.66 $11,364,307.86 March $7,342,921.96 $8,848,785.68 $9,065,970.50 $11,660,274.02 April $7,508,905.85 $9,411,546.73 $9,200,399.34 $11,986,582.01 May $7,195,825.04 $8,592,344.42 $9,240,938.82 $11,881,979.85 June $6,837,286.28 $9,752,219.84 $10,485,775.01 Medical Self Insurance Fund as of May 31, 2023 CASH Medical Self Ins Fund Cash 22 of 33 05.2023 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 633,500 543,514.52 550,000 520,837.10 650,000 475,698.38 438,345.02 39 - NON-REVENUE RECEIPTS 0 0.00 0 0.00 0 0.00 0.00 843 - DENTAL SELF INS FUND REVENUE $633,500 $543,514.52 $550,000 $520,837.10 $650,000 $475,698.38 $438,345.02 Expense Function Department Budget Actual Budget Actual Budget Actual 843 - DENTAL INSURANCE - SELF 00 - GENERAL GOVERNMENT 9307 - DENTAL INSURANCE - SELF 633,500 433,314.63 550,000 445,343.87 650,000 440,374.14 409,085.61 843 - DENTAL SELF INS FUND EXPENSE $633,500 $433,314.63 $550,000 $445,343.87 $650,000 $440,374.14 $409,085.61 843 - DENTAL SELF INS FUND REVENUE (OVER) / UNDER EXPENSES $0 $110,199.89 $0 $75,493.23 $0 $35,324.24 $29,259.41 FY 2022 FY 2022 Dental Self Insurance Fund as of May 31, 2023 Same Period Last Year FY 2021 FY 2021 FY 2023 FY 2023 Same Period Last Year Dental Self Ins Fund 843 23 of 33 05.2023 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 July $612,444.32 $724,520.63 $822,532.24 August $602,629.10 $696,545.18 $790,185.12 September $609,678.56 $734,630.02 $797,437.93 October $603,363.16 $695,046.20 $795,743.33 November $620,268.72 $701,911.17 $804,974.47 December $653,169.60 $711,856.70 $812,872.25 January $536,850.80 $657,824.44 $731,212.41 $832,304.92 February $547,206.22 $665,545.09 $737,896.84 $837,835.80 March $544,639.17 $673,523.14 $739,863.15 $832,355.91 April $551,952.84 $676,078.18 $739,741.66 $836,984.76 May $551,708.84 $605,182.75 $738,936.50 $834,680.46 June $544,280.85 $703,042.49 $780,381.70 Dental Self Insurance Fund as of May 31, 2023 CASH Dental Self Ins Fund Cash 24 of 33 05.2023 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 1,965,000 913,653.88 1,500,000 1,496,197.47 1,500,000 437,691.69 376,086.64 36 - ENTERPRISE CHARGES 0 0.00 0 25.00 0 200.00 25.00 39 - NON-REVENUE RECEIPTS 0 0.00 0 0.00 0 0.00 0.00 845 - RETIREE SELF INS FUND REVENUE $1,965,000 $913,653.88 $1,500,000 $1,496,222.47 $1,500,000 $437,891.69 $376,111.64 Expense Function Department Budget Actual Budget Actual Budget Actual 845 - MEDICAL INSURANCE RETIREE 00 - GENERAL GOVERNMENT 9304 - MEDICAL INSURANCE - RETIREE 1,965,000 1,122,842.12 1,500,000 1,117,497.44 1,500,000 1,277,731.50 274,060.51 845 - RETIREE SELF INS FUND EXPENSE $1,965,000 $1,122,842.12 $1,500,000 $1,117,497.44 $1,500,000 $1,277,731.50 $274,060.51 845 - RETIREE SELF INS FUND REVENUE (OVER) / UNDER EXPENSES $0 $209,188.24 $0 $378,725.03 $0 $839,839.81 $102,051.13 Retiree Self Insurance Fund as of May 31, 2023 FY 2022 FY 2022 FY 2021 FY 2021 FY 2023 FY 2023 Same Period Last Year Same Period Last Year Retiree Self Ins Fund 845 25 of 33 05.2023 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 July $646,924.11 $433,059.43 $829,677.64 August $590,241.30 $433,709.18 $770,327.59 September $489,464.41 $465,741.89 $736,325.28 October $466,294.49 $453,817.31 $706,499.95 November $396,067.66 $466,968.91 $641,611.83 December $334,887.79 $476,600.30 $599,142.27 January ($315,453.19)$206,371.20 $490,226.98 $445,630.08 February ($386,583.22)$180,684.24 $500,421.34 $318,834.16 March ($530,399.34)$35,718.25 $509,125.50 $246,480.74 April ($611,564.54)$93,954.23 $519,585.17 $123,809.37 May ($622,617.07)$594,052.00 $532,894.99 $60,110.80 June ($625,264.03)$428,365.66 $807,090.69 Retiree Self Insurance Fund as of May 31, 2023 CASH Retiree Self Ins Fund Cash 26 of 33 05.2023 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 89,508 203,985.55 113,111 217,546.85 240,909 121,749.00 87,407.00 38 - MISCELLANEOUS INCOME 27,600 108,493.81 45,546 62,469.00 12,000 9,211.51 55,815.00 39 - NON-REVENUE RECEIPTS 150,000 150,000.00 203,823 100,000.00 100,000 100,000.00 100,000.00 880 - FLEET SERVICES FUND REVENUE $267,108 $462,479.36 $362,480 $380,015.85 $352,909 $230,960.51 $243,222.00 Expense Function Department Budget Actual Budget Actual Budget Actual 880 - FLEET SERVICES 00 - GENERAL GOVERNMENT 9410 - FLEET SERVICES 267,108 34,981.61 280,215 277,136.77 290,679 157,832.00 223,055.77 9910 - CONTINGENCY 0 0.00 82,265 0.00 62,230 0.00 0.00 880 - FLEET SERVICES FUND EXPENSE $267,108 $34,981.61 $362,480 $277,136.77 $352,909 $157,832.00 $223,055.77 880 - FLEET SERVICES FUND REVENUE (OVER) / UNDER EXPENSES $0 $427,497.75 $0 $102,879.08 $0 $73,128.51 $20,166.23 Fleet Services Fund as of May 31, 2023 FY 2022 FY 2022 FY 2021 FY 2021 FY 2023 FY 2023 Same Period Last Year Same Period Last Year Fleet Services Fund 880 27 of 33 05.2023 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 July $601,279.16 $1,090,458.91 $1,203,969.99 August $609,506.58 $1,184,866.91 $1,199,951.99 September $615,658.56 $1,229,825.91 $1,167,317.99 October $624,166.20 $1,229,825.91 $1,199,618.20 November $632,714.95 $1,214,819.91 $1,212,931.71 December $791,230.55 $1,236,861.91 $1,223,968.71 January $565,853.83 $799,782.08 $1,244,772.91 $1,232,852.73 February $572,455.44 $808,107.96 $1,170,235.91 $1,245,938.71 March $573,647.74 $816,344.80 $1,179,361.91 $1,354,781.71 April $574,877.57 $823,803.80 $1,188,487.91 $1,266,466.50 May $616,138.99 $831,262.80 $1,110,625.14 $1,266,466.50 June $571,361.34 $1,090,458.91 $1,193,337.99 Fleet Services Fund as of May 31, 2023 CASH Fleet Services Fund Cash 28 of 33 05.2023 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 1,413,384 1,794,850.94 1,568,420 1,788,955.15 1,748,415 0.00 1,304,717.07 38 - MISCELLANEOUS INCOME 0 2,205.00 0 0.00 0 1,470,344.61 0.00 39 - NON-REVENUE RECEIPTS 607,000 350,000.00 350,000 350,000.00 2,046,804 1,624,009.00 350,000.00 890 - INFO TECHNOLOGY FUND REVENUE $2,020,384 $2,147,055.94 $1,918,420 $2,138,955.15 $3,795,219 $3,094,353.61 $1,654,717.07 Expense Function Department Budget Actual Budget Actual Budget Actual 890 - INFORMATION TECHNOLOGY 00 - GENERAL GOVERNMENT 9420 - TECHNOLOGY 2,020,384 1,730,021.57 1,918,420 1,711,368.67 3,795,219 2,235,230.70 1,667,458.51 890 - INFO TECHNOLOGY FUND EXPENSE $2,020,384 $1,730,021.57 $1,918,420 $1,711,368.67 $3,795,219 $2,235,230.70 $1,667,458.51 890 - INFO TECHNOLOGY FUND REVENUE (OVER) / UNDER EXPENSES $0 $417,034.37 $0 $427,586.48 $0 $859,122.91 $12,741.44 Information Technology Fund as of May 31, 2023 FY 2022 FY 2022 FY 2021 FY 2021 FY 2023 FY 2023 Same Period Last Year Same Period Last Year Info Technology Fund 890 29 of 33 05.2023 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 July $852,093.02 $1,491,852.27 $2,011,076.10 August $804,366.93 $1,558,798.40 $2,089,994.83 September $800,161.86 $1,577,002.07 $1,729,069.00 October $902,530.92 $1,729,919.23 $1,725,039.53 November $889,233.88 $1,765,161.46 $894,683.88 December $1,046,992.00 $1,751,059.99 $906,874.68 January $515,312.48 $1,189,759.12 $1,792,688.16 $1,055,166.45 February $534,562.33 $1,297,161.54 $1,843,447.45 $1,128,314.64 March $536,134.58 $1,426,825.09 $1,790,864.84 $2,844,280.84 April $570,566.56 $1,207,565.76 $1,763,694.03 $2,751,244.56 May $612,977.73 $973,972.46 $1,845,823.82 $2,815,993.06 June $798,424.51 $1,492,175.30 $1,924,106.94 Information Technology Fund as of May 31, 2023 CASH Info Technology Fund Cash 30 of 33 05.2023 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 33 - RESTRICTED REVENUE 313,368 168,677.61 681,954 443,960.42 884,546 213,682.09 346,861.54 38 - MISCELLANEOUS INCOME 155,840 47,990.21 101,068 31,562.93 73,000 23,729.50 29,007.93 39 - NON-REVENUE RECEIPTS 57,484 57,484.00 0 0.00 195,350 0.00 0.00 250 - VET TREATMENT COURT REVENUE $526,692 $274,151.82 $783,022 $475,523.35 $1,152,896 $237,411.59 $375,869.47 Expense Function Department Budget Actual Budget Actual Budget Actual 250 - VETERANS SERVICE SRF 00 - GENERAL GOVERNMENT 4185 - VETERANS TREATMENT COURT 526,692 269,609.26 783,022 286,462.47 1,152,896 342,366.37 232,945.68 250 - VET TREATMENT COURT EXPENSE $526,692 $269,609.26 $783,022 $286,462.47 $1,152,896 $342,366.37 $232,945.68 250 - VET TREATMENT COURT REVENUE (OVER) / UNDER EXPENSES $0 $4,542.56 $0 $189,060.88 $0 $104,954.78 $142,923.79 FY 2022 FY 2022 Veteran's Treatment Court as of May 31, 2023 FY 2021 FY 2021 FY 2023 FY 2023 Same Period Last Year Same Period Last Year Veteran's Treatment Court 250 31 of 33 05.2023 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 July $3,916.48 $26,014.22 $106,617.08 August ($19.11)$6,936.02 $197,695.62 September ($5,847.89)$1,617.01 $170,316.49 October ($52,239.74)($48,042.22)$236,136.83 November ($55,209.63)($67,669.08)$228,538.41 December ($10,827.18)($74,565.51)$144,375.79 January $7,582.66 ($54,087.90)($93,893.26)$120,098.68 February $35,756.46 ($60,437.65)($36,255.36)$154,587.98 March $19,011.14 ($63,403.68)($66,528.04)$113,762.06 April $30,146.67 ($63,500.51)($80,604.24)$132,819.22 May $42,612.59 ($72,985.76)$162,839.31 $120,571.26 June $28,305.11 $36,571.92 $127,852.90 Veteran's Treatment Court as of May 31, 2023 CASH Veteran's Treatment Court Cash 32 of 33 05.2023 Monthly Master as of December 31, 2020 1. Current year activity :City Hold Harmless School Hold HarmlessFiscal Year 2023as of October 31, 2022Article 39 Article 40 Article 42 Article 40 Article 42 Article 44 Article 44 *524 Article 46 Article 39 Article 39 Special Total July, 2022 1,157,314.97$ 749,270.84$ 353,464.82$ 260,035.43$ 520,070.87$ 13.76$ 532,789.40$ 351,044.51$ (137,020.83)$ (182,627.83)$ 320,851.18$ 3,925,207.12$ August, 2022 1,056,359.97$ 766,939.47$ 325,450.70$ 269,441.55$ 538,883.10$ 20.65$ 532,789.40$ 316,994.86$ (146,156.14)$ (222,408.85)$ 294,360.22$ 3,732,674.93$ September, 2022 1,164,761.44$ 753,374.63$ 355,098.87$ 261,963.22$ 523,926.43$ -$ 532,789.40$ 354,728.83$ (137,991.78)$ (183,490.36)$ 322,725.75$ 3,947,886.43$ October, 2022 917,997.69$ 724,950.21$ 289,874.24$ 253,815.32$ 507,630.64$ 2.97$ 532,789.40$ 274,165.86$ (140,568.23)$ (229,808.62)$ 258,353.54$ 3,389,203.02$ November, 2022 1,016,485.39$ 714,540.62$ 321,630.62$ 245,037.79$ 490,075.58$ 73.90$ 532,880.23$ 303,440.76$ (132,132.55)$ (193,176.81)$ 285,632.12$ 3,584,487.65$ December, 2022 1,371,351.32$ 838,394.41$ 416,287.26$ 290,002.96$ 580,005.92$ (4.12)$ 532,880.23$ 417,354.23$ (149,779.40)$ (183,247.31)$ 379,151.96$ 4,492,397.46$ January, 2023 1,072,630.12$ 704,166.18$ 330,379.47$ 243,446.33$ 486,892.67$ -$ 532,880.23$ 325,443.92$ (129,021.26)$ (174,394.75)$ 298,254.82$ 3,690,677.73$ February, 2023 892,254.25$ 578,968.82$ 280,991.88$ 195,908.69$ 391,817.37$ 162.27$ 532,880.23$ 267,089.24$ (104,183.18)$ (137,357.44)$ 249,819.51$ 3,148,351.64$ March, 2023 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ April, 2023 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ May, 2023 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ June, 2023 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 8,649,155.15$ 5,830,605.18$ 2,673,177.86$ 2,019,651.29$ 4,039,302.58$ 269.43$ 4,262,678.52$ 2,610,262.21$ (1,076,853.37)$ (1,506,511.97)$ 2,409,149.10$ 29,910,885.98$ Year over Year Change 10.00% 9.63% 13.43% 7.86% 7.86% 157.80% 16.03% 13.82% 5.43% 1.53% 49.64% 14.05% 2. Comparison to prior year :City Hold Harmless School Hold HarmlessFiscal Year 2022 Article 39 Article 40 Article 42 Article 40 Article 42 Article 44 Article 44 *524 Article 46 Article 39 Article 39 Special Total July, 2021 873,616.34$ 696,818.04$ 270,497.04$ 246,763.14$ 493,526.29$ -$ 459,092.34$ 250,664.40$ (139,686.11)$ (236,809.36)$ 180,905.28$ 3,095,387.40$ August, 2021 774,746.17$ 653,135.22$ 241,332.11$ 232,372.88$ 464,745.77$ 3.78$ 459,092.34$ 221,450.95$ (133,268.57)$ (234,850.37)$ 160,727.74$ 2,839,488.02$ September, 2021 1,051,674.97$ 652,833.31$ 307,490.95$ 230,720.67$ 461,441.34$ 13.64$ 459,092.34$ 310,685.98$ (123,042.19)$ (160,389.43)$ 213,535.76$ 3,404,057.34$ October, 2021 1,126,998.11$ 651,080.78$ 328,641.02$ 228,015.77$ 456,031.55$ -$ 459,092.34$ 333,701.55$ (118,932.77)$ (136,907.67)$ 228,643.57$ 3,556,364.25$ November, 2021 1,088,994.29$ 698,504.12$ 321,030.17$ 246,651.41$ 493,302.82$ 41.85$ 459,387.16$ 319,912.01$ (132,476.80)$ (180,957.98)$ 221,757.41$ 3,536,146.46$ December, 2021 1,074,826.03$ 783,676.83$ 320,376.48$ 280,256.10$ 560,512.19$ 14.13$ 459,387.16$ 311,921.86$ (155,027.09)$ (245,023.06)$ 219,744.73$ 3,610,665.36$ January, 2022 968,615.63$ 600,615.11$ 296,437.34$ 204,757.61$ 409,515.22$ -$ 459,387.16$ 281,008.13$ (109,278.67)$ (139,702.03)$ 199,713.26$ 3,171,068.76$ February, 2022 903,340.13$ 581,568.36$ 270,796.29$ 202,883.40$ 405,766.80$ 31.11$ 459,387.16$ 263,985.99$ (109,685.16)$ (149,168.58)$ 184,913.43$ 3,013,818.93$ March, 2022 1,222,316.18$ 750,716.35$ 355,015.11$ 266,376.44$ 532,752.89$ -$ 459,387.16$ 360,461.30$ (141,070.39)$ (181,726.84)$ 247,713.35$ 3,871,941.55$ April, 2022 1,206,125.87$ 741,653.28$ 351,887.62$ 262,111.29$ 524,222.58$ (239.47)$ 459,387.16$ 354,731.88$ (138,875.50)$ (179,275.68)$ 244,751.74$ 3,826,480.77$ May, 2022 1,159,362.11$ 735,933.72$ 343,084.43$ 258,389.36$ 516,778.73$ 57.16$ 460,511.00$ 338,917.88$ (135,539.79)$ (185,629.67)$ 236,844.68$ 3,728,709.61$ June, 2022 1,223,057.57$ 793,226.38$ 358,882.36$ 281,292.80$ 562,585.61$ -$ 532,789.41$ 359,193.01$ (148,795.52)$ (209,689.10)$ 249,125.50$ 4,001,668.02$ 7,862,811.67$ 5,318,231.77$ 2,356,601.40$ 1,872,420.98$ 3,744,841.98$ 104.51$ 3,673,918.00$ 2,293,330.87$ (1,021,397.36)$ (1,483,808.48)$ 1,609,941.18$ 26,226,996.52$ AnnualizedBudget % Collected(8 months)to Date1103100 310231 6,065,789.81$ 8,455,000$ (2,389,210.19)$ 5,636,667$ 429,123.14$ 71.74%NC Sales Tax - Article 39 1103100 310233 5,830,605.18$ 6,673,000$ (842,394.82)$ 4,448,667$ 1,381,938.51$ 87.38%NC Sales Tax - Article 40 (General Fund)1103100 310235 2,673,177.86$ 979,000$ 1,694,177.86$ 652,667$ 2,020,511.19$ 273.05%NC Sales Tax - Article 42 (General Fund)1103100 310237 4,262,947.95$ 5,309,000$ (1,046,052.05)$ 3,539,333$ 723,614.62$ 80.30%NC Sales Tax - Article 44 & Article 44 *52418,832,520.80$ 21,416,000.00$ (2,583,479.20)$ 14,277,333.33$ 4,555,187.47$ 87.94% 2118401 - 380892 2,409,149.10$ 2,348,424.00$ 60,725.10$ 1,565,616.00$ 843,533.10$ 102.59%NC Sales Tax Special Districts 3003100 310233 2,019,651.29$ 2,550,000$ (530,348.71)$ 1,700,000$ 319,651.29$ 79.20%NC Sales Tax - Article 40 (Education)3003100 310235 4,039,302.58$ 5,544,917$ (1,505,614.42)$ 3,696,611$ 342,691.25$ 72.85%NC Sales Tax - Article 42 (Education)3003100 310239 2,610,262.21$ 3,300,000$ (689,737.79)$ 2,200,000$ 410,262.21$ 79.10%NC Sales Tax - Article 468,669,216.08$ 11,394,917.00$ (2,725,700.92)$ 7,596,611.33$ 1,072,604.75$ 76.08% HARNETT COUNTY SALES TAX ANALYSIS BY ARTICLE General Fund Board of Education General Fund Board of Education 3. Reconciliation to general ledger :Over/(Under) Annualized BudgetBalance to Tyler Activity Budget Over/(Under) Budget Monthly Sales Tax 33 of 33 05.2023 Monthly Master