Press Alt + R to read the document text or Alt + P to download or print.

No preview available

The URL can be used to link to this page

Home My WebLink AboutOctober 2024 Financial Report Monthly Financial Reports October 2024 Table of Contents General Fund ................................................................................................ 1 Harnett Regional Jetport Fund ..................................................................... 6 American Rescue Plan Act Fund ................................................................... 9 Harnett Regional Water Fund .................................................................... 10 Solid Waste Fund ....................................................................................... 12 Worker’s Compensation Fund .................................................................... 14 Unemployment Insurance Fund ................................................................. 16 Employee Clinic Fund ................................................................................. 18 Medical Self Insurance Fund ...................................................................... 20 Dental Self Insurance Fund ........................................................................ 22 Retiree Self Insurance Fund ....................................................................... 24 Fleet Services Fund ..................................................................................... 26 Information Technology Fund .................................................................... 28 Veteran’s Treatment Court Fund .............................................................. 30 Monthly Sales Tax Analysis by Article ........................................................ 32 Harnett County Towns Summary ............................................................... 33 Revenue Category Budget Actual Budget Actual Budget Actual 30 - TAXES - AD VALOREM 77,645,000 79,931,250.14 81,560,000 83,804,630.86 86,760,145 14,605,995.04 12,195,746.62 31 - TAXES - SALES 21,416,000 28,878,720.90 26,561,800 30,207,510.88 30,003,000 2,465,010.95 2,308,594.75 32 - TAXES - OTHER 1,164,000 1,536,643.83 1,164,000 1,660,194.64 1,300,000 591,851.52 546,839.80 33 - RESTRICTED REVENUE 23,410,407 23,850,972.56 23,773,916 21,152,756.95 22,899,505 4,401,511.48 4,240,210.25 34 - RESTRICTED REVENUE 3,110,000 6,619,121.15 6,100,000 5,338,962.28 4,000,000 0.00 0.00 35 - SERVICE CHARGES 14,615,204 17,190,916.66 16,578,749 18,749,478.90 20,069,977 5,853,266.62 8,131,053.44 36 - ENTERPRISE CHARGES 0 4,392.51 0 6,325.96 0 1,135.84 877.51 37 - FACILITY FEES 0 2,783.82 0 3,487.26 0 0.00 2,084.99 38 - MISCELLANEOUS INCOME 2,109,210 2,487,949.62 820,092 302,645.92 948,847 772,719.99 1,177,695.02 39 - NON-REVENUE RECEIPTS 27,735,817 1,274,238.00 12,468,816 164,375.00 12,438,891 0.00 0.00 110 - GENERAL FUND REVENUE 171,205,638 $161,776,989.19 169,027,373 $161,390,368.65 178,420,365 $28,691,491.44 $26,247,712.34 Expense Function Department Budget Actual Budget Actual Budget Actual 110 - GENERAL 00 - GENERAL GOVERNMENT 4110 - GOVERNING BODY 918,415 846,695.96 675,930 598,562.56 600,438 183,121.47 170,302.13 4120 - COUNTY ADMINISTRATION 1,160,594 1,060,696.45 1,406,990 1,371,737.43 1,488,742 446,615.07 433,076.48 4130 - FINANCE 1,619,365 1,533,443.87 1,910,725 1,894,440.46 1,989,322 533,094.97 476,904.82 4131 - RETIREE INSURANCE 944,351 919,464.87 930,000 929,999.03 956,573 231,195.15 238,080.14 4140 - TAX 1,999,758 1,714,142.62 2,076,484 2,038,840.72 2,343,796 602,287.22 465,689.18 4150 - LEGAL SERVICES 387,832 369,867.69 589,456 571,875.48 634,280 175,946.25 118,226.42 4160 - HUMAN RESOURCES 966,968 882,574.81 967,288 956,690.67 672,502 203,649.33 545,654.22 4161 - INSURANCE 0 0.00 0 0.00 336,230 336,230.00 0.00 4170 - BOARD OF ELECTIONS 577,506 562,798.02 875,726 802,482.70 801,696 234,867.12 141,325.81 4180 - CLERK OF COURT 28,233 17,713.99 51,810 45,359.68 53,815 8,194.93 8,165.47 4190 - REGISTER OF DEEDS 810,075 771,787.47 903,433 896,393.98 964,136 322,311.19 295,835.21 4210 - GENERAL SERVICES 255,027 252,022.15 272,931 272,763.64 296,962 86,277.94 76,555.43 4230 - FACILITIES MAINTENANCE 3,595,600 3,399,030.41 3,916,231 3,940,618.80 4,298,026 1,091,069.04 1,165,918.73 4250 - FLEET MAINTENANCE 907,315 841,138.04 1,120,753 1,108,538.90 1,111,197 314,056.52 257,115.46 4270 - INFORMATION TECHNOLOGY 2,736,780 2,617,423.22 2,850,044 2,838,039.08 2,125,815 546,938.93 853,500.54 4290 - GIS 846,687 810,806.18 1,005,874 999,473.46 1,087,118 384,887.60 352,304.52 9800 - INTERFUND TRANSFERS 33,106,322 27,336,394.00 18,017,337 18,017,337.00 11,000,000 0.00 0.00 9910 - CONTINGENCY 426,055 0.00 94,866 0.00 6,793,205 0.00 0.00 00 - GENERAL GOVERNMENT Total 51,286,883 43,935,999.75 37,665,878 37,283,153.59 37,553,853 5,700,742.73 5,598,654.56 FY 2025 Same Period Last Year FY 2023 FY 2023 Same Period Last Year FY 2025FY 2024 FY 2024 General Fund Unaudited as of October 31, 2024 General Fund 110 1 of 37 10.2024 Monthly Master Expense Function Department Budget Actual Budget Actual Budget Actual FY 2025FY 2023 Same Period Last Year FY 2024 4300 - PUBLIC SAFETY 0 0.00 0 0.00 0 0.00 0.00 4310 - SHERIFF 14,093,457 13,505,215.48 15,809,147 15,649,054.18 18,199,385 5,433,696.82 4,296,782.53 4330 - CAMPBELL DEPUTIES 586,694 575,389.37 727,436 624,155.97 691,536 194,996.09 173,806.32 4350 - SCHOOL RESOURCE OFFICER 2,147,192 1,580,281.44 2,480,674 2,057,966.99 2,697,805 550,873.31 575,242.67 4370 - CHILD SUPPORT ENFORCEMENT 98,087 96,248.57 110,767 104,587.47 107,988 30,037.64 36,925.28 4390 - JAIL 7,546,385 6,768,434.38 8,146,079 7,656,019.93 8,297,349 2,277,220.81 2,066,188.26 4410 - EMERGENCY MANAGEMENT 1,187,136 1,127,582.44 1,314,553 1,303,274.39 1,620,022 484,372.51 369,084.68 4411 - EMERGENCY SERVICES GRANTS 442,695 250,499.57 374,520 272,654.20 242,502 38,945.99 75,077.76 4451 - EMS TRANSPORTS 0 0.00 0 0.00 0 0.00 0.00 4470 - RESCUE DISTRICTS 5,792,107 5,792,106.70 4,592,173 4,592,168.96 5,372,140 1,790,713.36 1,530,723.00 4510 - FIELD SERVICES 423,264 398,306.11 465,803 440,958.26 583,542 138,181.66 132,809.01 4512 - ANIMAL SHELTER 442,446 366,985.54 554,249 488,399.22 619,987 122,692.67 128,063.61 4530 - MEDICAL EXAMINER 100,000 82,400.00 100,000 67,545.90 100,000 29,540.30 17,000.00 4591 - RADIO SYSTEM 0 0.00 0 0.00 0 0.00 0.00 4915 - INSPECTIONS 1,152,661 1,046,161.57 1,451,754 1,275,922.68 1,553,416 407,063.51 347,158.30 10 - PUBLIC SAFETY Total 47,369,756 43,149,365.11 50,324,414 48,266,396.74 55,640,943 15,916,564.54 13,598,824.36 20 - TRANSPORTATION 4610 - TRANSPORTATION 1,493,881 1,040,368.09 1,576,325 1,320,124.60 1,882,468 461,437.68 356,340.36 4650 - HARNETT REGIONAL JETPORT 0 0.00 0 0.00 0 0.00 0.00 20 - TRANSPORTATION Total 2,625,480 1,494,569.19 3,020,228 1,765,441.27 3,433,530 924,721.37 435,209.35 30 - ENVIRONMENTAL PROTECTION 4710 - SOIL & WATER 309,461 295,848.31 339,110 328,969.13 365,978 106,253.82 96,551.86 4730 - FORESTRY PROGRAM 152,709 132,587.79 164,599 151,180.07 149,122 15,463.78 20,181.46 4750 - ENVIROMENTAL PROT ALLOC 12,000 11,900.00 12,000 11,900.00 12,000 11,900.00 11,900.00 30 - ENVIRONMENTAL PROTECTION Total 474,170 440,336.10 515,709 492,049.20 527,100 133,617.60 128,633.32 40 - ECONOMIC & PHYSICAL DEVELOPMNT 4910 - DEVELOPMENT SERVICES 1,119,722 1,033,858.20 1,252,686 1,184,125.19 1,464,512 474,384.91 378,261.99 4930 - ECONOMIC DEVELOPMENT 1,111,354 883,701.25 1,038,781 1,008,995.31 1,177,107 273,320.83 206,876.09 4951 - ABANDONED MFG HOME 0 0.00 0 0.00 0 0.00 0.00 4970 - HARNETT 0 0.00 35,000 21,380.51 545,005 1,890.17 0.00 4971 - WIOA - ADULT 0 0.00 102,365 97,736.86 33,036 39,594.29 0.00 4973 - WIAO - NC WORKS CAREER CENTER 0 0.00 78,353 76,863.24 15,391 24,954.40 0.00 4975 - WIOA - DISLOCATED WORKER 0 0.00 57,292 57,086.71 19,161 14,625.28 0.00 4978 - WIOA - YOUTH - IN 0 0.00 34,283 34,201.47 11,412 17,302.99 0.00 4979 - WIOA - YOUTH - OUT 0 0.00 102,867 100,899.76 33,834 42,749.95 0.00 4990 - COOPERATIVE EXTENSION 443,332 402,432.61 459,580 396,348.23 508,465 78,149.54 85,435.56 4995 - COOPERATIVE EXT SPECIAL PROG 158,799 125,770.09 123,638 101,761.52 69,725 12,957.37 30,527.09 40 - ECONOMIC & PHYSICAL DEVELOPMNT Total 2,833,664 2,445,941.02 3,295,554 3,079,713.95 3,888,588 980,072.34 701,179.57 50 - HUMAN SERVICES 5110 - GENERAL ADMINISTRATION 9,637,937 7,349,865.69 269,764 236,698.78 523,711 114,265.24 221,966.49 5112 - VITAL RECORDS 0 0.00 28,215 27,310.61 29,625 8,639.95 7,739.30 5114 - AGING 0 0.00 105,919 95,122.53 86,858 29,371.44 27,057.67 5118 - LABORATORY SERVICES 0 0.00 312,717 274,791.38 321,694 85,201.75 77,137.16 General Fund 110 2 of 37 10.2024 Monthly Master Expense Function Department Budget Actual Budget Actual Budget Actual FY 2025FY 2023 Same Period Last Year FY 2024 5120 - CHILD HEALTH 0 0.00 1,306,713 1,219,429.64 1,333,311 318,790.34 363,385.80 5121 - IMMUNIZATION ACTION PLAN 0 0.00 97,163 65,191.17 73,571 14,117.47 10,603.67 5122 - LEAD 0 0.00 8,170 2,675.12 8,462 0.00 450.88 5124 - SCHOOL HEALTH NURSE 0 0.00 150,000 150,000.00 150,000 33,333.34 33,333.34 5130 - ADULT HEALTH 0 0.00 256,177 226,480.21 227,881 101,516.56 108,584.29 5131 - SEXUALLY TRANSMITTED DISEASE 0 0.00 277,218 237,488.12 357,078 62,061.66 55,439.00 5134 - MATERNAL HEALTH 0 0.00 586,715 538,216.41 605,192 163,285.33 144,126.77 5135 - FAMILY PLANNING 0 0.00 576,156 548,420.49 523,190 163,683.03 146,568.17 5137 - TUBERCULOSIS PROGRAM 0 0.00 67,620 62,105.69 73,222 17,213.81 19,259.30 5138 - COMMUNICABLE DISEASES 0 0.00 77,717 72,534.17 124,027 28,632.49 24,684.46 5139 - TANF 0 0.00 16,728 16,278.87 16,203 231.92 4,266.28 5140 - HEALTH EDUCATION 0 0.00 92,013 73,556.22 90,097 28,747.14 26,401.77 5142 - CHILD FATALITY PREVENTION TEAM 0 0.00 7,625 3,293.66 8,064 480.00 348.24 5144 - HIV-STD COUNTY 0 0.00 22,904 19,528.32 23,873 3,019.01 6,011.88 5145 - HEALTH PROMOTION 0 0.00 82,393 79,431.17 85,991 21,849.50 20,124.68 5146 - HEALTHY COMMUNITIES 0 0.00 50,186 42,936.46 51,750 9,552.68 10,162.90 5148 - ITTS 0 0.00 55,484 55,051.06 57,915 15,522.46 13,989.15 5149 - MOBILE HEALTH PROGRAM 0 0.00 0 0.00 15,658 2,625.31 0.00 5150 - WIC - ADMINISTRATION 0 0.00 70,695 66,801.57 74,197 13,393.04 19,949.83 5151 - WIC - CLIENT SERVICES 0 0.00 614,554 570,918.38 549,947 156,723.95 12,282.56 5152 - WIC - NUTRITION EDUCATION 0 0.00 166,801 150,390.07 144,129 41,216.52 44,665.03 5153 - WIC - BREASTFEEDING 0 0.00 43,401 38,215.92 36,157 10,970.95 12,219.23 5154 - WIC - PEER BREASTFEEDING 0 0.00 73,647 59,881.45 72,604 16,158.74 21,535.40 5160 - CMARC 0 0.00 371,875 335,212.47 357,219 93,820.92 98,509.10 5161 - CMARC - STATE 0 0.00 45,033 45,024.50 49,414 13,353.31 12,820.82 5162 - CMHRP 0 0.00 781,013 313,625.40 391,933 94,400.28 78,693.69 5170 - BIOTERRORISM 0 0.00 60,784 53,216.80 62,353 14,592.61 13,579.25 5180 - ENVIRONMENTAL SERVICES 0 0.00 1,525,283 1,358,455.02 1,404,095 394,185.92 396,495.78 5190 - HEALTH DEPARTMENT GRANTS 0 0.00 1,919,424 654,166.12 794,448 39,113.66 80,053.31 5210 - MENTAL HEALTH 605,679 605,679.00 605,679 605,678.17 609,673 304,836.00 302,839.50 5260 - HEALTH - SENIOR SERVICES 1,726,073 1,498,416.92 1,880,207 1,532,420.78 1,741,283 453,239.61 415,422.76 5310 - DSS - ADMINISTRATION 2,398,802 2,245,120.78 2,941,166 2,794,604.11 3,569,841 1,177,188.87 975,392.28 5311 - DSS - FRAUD PREVENTION 386,647 381,047.15 421,935 419,664.62 450,236 123,312.22 121,046.94 5320 - DSS - ADULT SERVICES 1,156,996 1,108,910.38 1,271,699 1,217,479.51 1,338,691 370,617.70 346,396.47 5321 - DSS - WORKFIRST 378,702 320,704.29 396,816 373,131.55 415,868 116,626.91 107,200.15 5322 - DSS - ENERGY PROGRAMS 1,636,534 860,566.17 1,557,687 284,774.54 401,281 49,010.46 92,614.47 5330 - DSS - CHILD CARE SUBSIDY 459,647 456,670.30 486,115 474,729.32 511,098 141,185.72 138,608.94 5331 - DSS - CHILD PROTECTIVE SRVCS 2,330,626 2,089,094.95 2,480,613 2,321,403.62 2,586,132 731,247.07 655,322.21 5332 - DSS - FOSTER CARE 3,993,959 3,880,305.23 6,361,621 5,159,177.19 6,426,693 1,442,983.77 1,286,786.79 5334 - DSS - DAY CARE 0 0.00 0 0.00 0 0.00 0.00 5350 - DSS - MEDICAID 0 0.00 0 0.00 0 0.00 0.00 5351 - DSS - ADULT MEDICAID 2,463,225 2,083,213.56 2,615,865 2,390,812.12 3,261,260 808,303.89 671,405.49 General Fund 110 3 of 37 10.2024 Monthly Master Expense Function Department Budget Actual Budget Actual Budget Actual FY 2025FY 2023 Same Period Last Year FY 2024 5352 - DSS - FAMILY & CHLDRN MEDICAID 1,791,823 1,688,979.80 2,016,885 1,931,151.58 2,780,244 700,979.07 498,228.00 5353 - DSS - MEDICAID TRANSPORTATION 258,360 223,756.60 275,609 216,570.94 260,744 56,802.14 66,336.54 5390 - DSS - TRUST ACCOUNTS 0 0.00 0 8.85 0 0.00 0.00 5810 - VETERANS SERVICES 356,053 347,566.64 431,651 417,728.17 500,440 136,598.14 101,568.88 5895 - HUMAN SERVICES APPROPRIATIONS 0 0.00 0 0.00 0 0.00 0.00 50 - HUMAN SERVICES Total 33,847,172 28,853,647.19 38,433,227 32,009,151.53 38,407,124 9,945,259.59 9,053,700.35 70 - EDUCATION 5910 - BOARD OF EDUCATION 26,121,589 26,121,589.00 28,301,509 28,301,509.00 30,804,606 10,268,202.00 9,373,936.36 5920 - CCCC 1,752,605 1,557,732.28 1,818,075 1,636,093.93 1,818,075 526,207.21 479,358.32 70 - EDUCATION Total 27,874,194 27,679,321.28 30,119,584 29,937,602.93 32,622,681 10,794,409.21 9,853,294.68 80 - CULTURAL & RECREATION 6110 - PARKS & RECREATION 1,752,797 1,504,187.17 1,945,628 1,836,627.94 2,167,462 784,012.35 639,817.74 6170 - MAIN LIBRARY 2,040,861 1,736,352.80 2,236,929 2,047,113.44 2,467,025 737,284.33 582,426.08 6172 - ANGIER BRANCH LIBRARY 253,527 211,733.68 278,867 264,042.58 303,057 85,946.67 71,877.66 6173 - BENHAVEN BRANCH LIBRARY 0 0.00 191,243 121,440.34 224,719 55,070.02 5,253.27 6175 - COATS BRANCH LIBRARY 151,658 122,622.63 172,056 159,036.07 187,073 53,819.05 45,294.59 6176 - DUNN BRANCH LIBRARY 278,839 242,816.32 341,711 321,304.52 352,080 104,077.28 79,981.58 6177 - ERWIN BRANCH LIBRARY 156,084 132,742.84 179,104 152,479.21 187,901 55,359.61 51,403.46 6199 - CULTURAL & REC APPROP 260,553 260,466.04 307,241 157,241.00 457,229 0.00 0.00 80 - CULTURAL & RECREATION Total 4,894,319 4,210,921.48 5,652,779 5,059,285.10 6,346,546 1,875,569.31 1,476,054.38 110 - GENERAL FUND EXPENSE 171,205,638 $152,210,101.12 169,027,373 $157,892,794.31 178,420,365 $46,270,956.69 $40,845,550.57 110 - GENERAL FUND REVENUE (OVER) / UNDER EXPENSES 0 $9,566,888.07 0 $3,497,574.34 0 $17,579,465.25 $14,597,838.23 General Fund 110 4 of 37 10.2024 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 2024 2025 July $33,238,397.31 $42,138,468.69 $54,281,722.96 $61,938,453.15 $69,472,830.58 August $30,766,642.59 $27,193,882.75 $50,916,962.51 $60,497,443.11 $68,019,517.82 September $31,436,740.68 $28,797,031.28 $53,275,613.95 $62,210,399.86 $68,167,756.54 October $32,621,237.60 $29,562,531.87 $53,221,696.77 $61,191,258.32 $64,666,747.52 November $55,768,728.62 $53,048,249.28 $84,574,717.48 $88,644,054.16 December $52,233,891.79 $62,382,452.13 $98,791,252.21 $98,640,706.84 January $49,307,366.28 $53,864,998.95 $66,631,763.25 $103,901,132.64 $105,847,987.63 February $46,553,686.81 $52,435,487.27 $64,815,294.91 $95,758,773.44 $107,597,437.01 March $48,087,241.40 $54,340,963.07 $68,066,131.09 $86,276,904.65 $109,589,425.92 April $45,974,675.17 $53,068,500.85 $67,511,156.89 $85,610,715.71 $99,944,582.15 May $41,927,274.60 $52,229,820.40 $63,702,091.44 $72,169,732.05 $79,620,028.38 June $40,106,511.08 $45,039,854.80 $57,567,146.97 $67,132,348.80 $72,798,979.77 CASH General Fund Unaudited as of October 31, 2024 General Fund Cash 5 of 37 10.2024 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 33 - RESTRICTED REVENUE 82,000 82,000.00 0 0.00 0 0.00 0.00 35 - SERVICE CHARGES 1,086,377 827,387.06 1,274,808 825,782.31 1,306,709 285,689.91 230,759.25 38 - MISCELLANEOUS INCOME 74,329 88,846.99 45,000 48,185.06 48,500 10,325.00 11,175.00 39 - NON-REVENUE RECEIPTS 0 0.00 2,500,000 1,860,060.01 0 0.00 1,860,060.01 120 - HR JETPORT FUND REVENUE 1,242,706 $998,234.05 3,819,808 $2,734,027.38 1,355,209 $296,014.91 $2,101,994.26 Expense Function Department Budget Actual Budget Actual Budget Actual 120 - HARNETT REGIONAL JETPORT 4650 - HARNETT REGIONAL JETPORT 50 - SALARIES & BENEFITS 310,165 $202,559.90 312,508 $268,444.59 334,795 $84,087.68 65,690.65 51 - PROFESSIONAL SRVCS 8,234 $8,234.00 70 $0.00 0 $0.00 0.00 52 - SUPPLIES & MATERIALS 739,487 $699,730.80 892,922 $650,791.14 894,000 $210,460.52 140,050.34 53 - CURRENT SRVCS 84,113 $46,912.48 63,208 $51,167.06 55,738 $18,982.70 11,514.84 54 - FIXED CHARGES 58,347 $50,298.73 51,042 $51,077.51 70,276 $45,418.04 34,145.66 55 - CAPITAL OUTLAY 42,000 $41,301.00 2,500,000 $1,860,060.01 0 $0.00 1,860,060.01 58 - NON-CAPTALIZED ASSTS 360 $349.00 58 $58.00 400 $0.00 0.00 70 - PCARD ENCUMBRANCE 0 $0.00 0 $26.80 0 $139.09 0.00 120 - HR JETPORT FUND EXPENSE 1,242,706 $1,049,385.91 3,819,808 $2,881,625.11 1,355,209 $359,088.03 $2,111,461.50 120 - HR JETPORT FUND REVENUE (OVER) / UNDER EXPENSES 0 $51,151.86 0 $147,597.73 0 $63,073.12 $9,467.24 FY 2025FY 2023 FY 2023 Same Period Last Year Same Period Last Year FY 2025 Harnett Regional Jetport Fund Unaudited as of October 31, 2024 FY 2024 FY 2024 HRJetport Fund 120 6 of 37 10.2024 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 2024 2025 July $0.00 ($10,408.95) $87,758.33 $1,113,436.56 ($164,413.27) August $0.00 $38,091.69 $45,064.56 ($27,058.80) ($161,354.09) September $0.00 $36,352.20 $11,220.79 ($4,428.86) ($169,096.56) October $0.00 $21,459.01 $48,823.98 ($31,682.99) ($193,160.59) November $0.00 $16,092.97 $49,802.68 $1,940.37 December $0.00 ($6,777.19) $58,287.77 $22,770.51 January $0.00 $0.00 ($13,727.75) $81,982.97 ($4,432.89) February $0.00 $0.00 $13,226.32 $165,139.85 ($60,194.85) March $0.00 $0.00 ($31,248.47) $142,889.96 ($42,900.23) April $0.00 $0.00 $26,128.75 $115,037.01 ($104,515.90) May $0.00 $0.00 $21,848.15 $52,398.54 ($106,573.94) June $0.00 $0.00 $29,385.38 $28,888.28 ($115,594.27) CASH Harnett Regional Jetport Unaudited as of October 31, 2024 HRJetport Fund Cash 7 of 37 10.2024 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 2024 2025 July $0.00 $16,178.82 $38,753.86 $37,999.75 $72,759.56 August $0.00 $29,721.24 $38,363.43 $57,579.29 $55,584.84 September $0.00 $33,441.27 $31,163.35 $84,158.29 $61,134.73 October $0.00 $50,458.29 $19,255.25 $65,460.75 $61,134.73 November $0.00 $47,552.93 $29,640.04 $60,956.54 $57,936.53 December $0.00 $48,472.67 $19,400.81 $43,883.34 January $0.00 $0.00 $65,652.06 $19,764.97 $54,137.84 February $0.00 $0.00 $58,787.79 $23,447.84 $41,123.31 March $0.00 $0.00 $42,570.99 $5,971.34 $35,832.58 April $0.00 $0.00 $65,608.49 $17,990.72 $60,587.75 May $0.00 $0.00 $35,441.10 $31,028.82 $45,057.49 June $0.00 $0.00 $22,313.20 $73,394.41 $46,613.99 INVENTORY Harnett Regional Jetport Unaudited as of October 31, 2024 HRJetport Fund Inventory 8 of 37 10.2024 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 33 - RESTRICTED REVENUE 10,015,000 7,001,497.09 2,000,000 4,847,916.65 5,458,946 5,458,945.26 0.00 35 - SERVICE CHARGES 0 880,075.62 0 1,182,786.74 0 96,155.98 400,319.27 38 - MISCELLANEOUS INCOME 0 0.00 0 0.00 0 0.00 0.00 39 - NON-REVENUE RECEIPTS 0 0.00 3,276,608 0.00 2,083,858 0.00 0.00 292 - ARPA FUND REVENUE 10,015,000 $7,881,572.71 5,276,608 $6,030,703.39 7,542,804 $5,555,101.24 $400,319.27 Revenue Category Budget Actual Budget Actual Budget Actual 292 - AMERICAN RESCUE PLAN ACT SRF 9990 - NON-DEPARTMENTAL 4,262,949 $1,249,448.00 3,276,608 $3,276,608.00 0 $0.00 $0.00 4120 - COUNTY ADMINISTRATION 15,000 $15,000.00 0 $0.00 0 $0.00 $0.00 4450 - EMERGENCY MEDICAL SERVICE 117,823 $117,822.60 0 $0.00 0 $0.00 $0.00 4591 - RADIO SYSTEM 5,619,228 $5,619,227.49 2,000,000 $1,571,308.65 7,542,804 $1,500,000.00 $0.00 292 - ARPA FUND EXPENSE 10,015,000 $7,001,498.09 5,276,608 $4,847,916.65 7,542,804 $1,500,000.00 $0.00 292 - ARPA FUND REVENUE (OVER) / UNDER EXPENSES 0 $880,074.62 0 $1,182,786.74 0 $4,055,101.24 $400,319.27 FY 2025 FY 2025 FY 2023 FY 2023 FY 2024 FY 2024 American Rescue Plan Act Fund Unaudited as of October 31, 2024 Same Period Last Year Same Period Last Year ARPA Fund 292 9 of 37 10.2024 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 33 - RESTRICTED REVENUE 0 0.00 0 0.00 0 0.00 0.00 35 - SERVICE CHARGES 10,000 555,432.17 250,000 1,297,115.47 750,000 444,731.51 363,819.73 36 - ENTERPRISE CHARGES 1,761,500 2,477,357.11 2,113,000 2,448,342.41 2,418,000 940,782.88 792,622.41 37 - FACILITY FEES 37,564,650 41,935,719.04 40,635,000 47,630,098.56 43,600,000 17,723,705.98 16,541,036.32 38 - MISCELLANEOUS INCOME 320,000 761,792.20 340,000 16,810,585.32 340,000 159,980.57 7,538,558.33 39 - NON-REVENUE RECEIPTS 25,359,677 0.00 1,993,600 0.00 97,700 0.00 0.00 610 - HRW FUND REVENUE 65,015,827 $45,730,300.52 45,331,600 $68,186,141.76 47,205,700 $19,269,200.94 $25,236,036.79 Expense Function Department Budget Actual Budget Actual Budget Actual 610 - HARNETT REGIONAL WATER 91 - WATER & SEWER 7111 - HRW ADMINISTRATION 6,253,837 4,894,248.76 8,811,539 6,052,060.86 9,178,719 2,079,390.88 1,519,938.72 7113 - WATER TREATMENT PLANT 8,435,629 7,994,486.61 9,504,517 8,719,770.70 11,393,000 3,106,208.71 3,302,282.95 7115 - WASTEWATER TREATMENT PLANT 3,583,141 3,157,253.44 4,179,100 3,593,743.89 4,285,216 945,257.63 871,464.98 7117 - SOUTH HARNETT WASTEWATER PLANT 3,737,799 3,169,127.62 4,218,793 3,449,519.34 4,587,358 1,106,797.09 870,271.68 7119 - WATER DISTRIBUTION 6,396,571 5,348,263.00 7,439,204 6,000,175.87 7,056,458 2,026,494.02 2,065,702.39 7121 - SEWER COLLECTIONS 5,697,048 5,072,871.48 6,002,962 4,843,044.44 6,218,016 1,236,934.44 1,190,382.65 7131 - RETIREE INSURANCE HRW 63,829 64,280.10 75,824 57,113.44 55,426 21,259.00 18,515.20 9990 - NON-DEPARTMENTAL 30,847,973 48,202,047.68 5,099,661 $5,099,661.00 4,431,507 $0.00 0.00 610 - HRW FUND EXPENSE 65,015,827 $77,902,578.69 45,331,600 $37,815,089.54 47,205,700 $10,522,341.77 $9,838,558.57 610 - HRW FUND REVENUE (OVER) / UNDER EXPENSES 0 $32,172,278.17 0 $30,371,052.22 0 $8,746,859.17 $15,397,478.22 FY 2023 FY 2025 FY 2025 Same Period Last Year Harnett Regional Water Fund Unaudited as of October 31, 2024 FY 2024 FY 2024FY 2023 Same Period Last Year HRW Fund 610 10 of 37 10.2024 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 2024 2025 July $56,308,485.60 $51,396,573.71 $69,906,540.92 $47,872,143.43 $61,041,794.93 August $57,887,471.15 $53,478,105.50 $71,395,812.59 $49,668,609.87 $62,646,189.50 September $53,052,496.69 $54,740,839.35 $72,918,273.72 $51,309,490.06 $63,393,445.79 October $41,972,645.61 $57,802,598.49 $74,956,217.38 $53,345,216.44 $65,943,625.57 November $44,623,020.08 $59,929,869.87 $77,010,360.42 $55,515,423.72 December $46,244,526.10 $61,433,187.37 $78,805,658.04 $56,834,058.40 January $57,818,912.12 $47,842,388.74 $63,336,473.21 $79,769,987.45 $58,466,164.77 February $58,911,946.79 $49,655,875.28 $65,045,521.23 $56,832,826.21 $59,569,273.61 March $60,961,613.87 $51,249,479.82 $62,345,519.84 $53,955,027.95 $61,972,230.67 April $60,643,544.18 $52,788,896.94 $62,323,826.87 $55,336,607.53 $62,083,104.02 May $61,748,714.89 $55,026,201.87 $57,960,361.56 $56,053,548.68 $59,428,422.60 June $55,307,862.26 $48,531,475.46 $58,710,523.48 $45,653,091.25 $59,303,866.71 CASH Harnett Regional Water Fund Unaudited as of October 31, 2024 HRW Fund Cash 11 of 37 10.2024 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 260,000 378,939.22 300,000 418,365.90 300,000 0.00 0.00 35 - SERVICE CHARGES 0 18,173.48 0 8,172.54 6,858 73,121.86 1,903.85 36 - ENTERPRISE CHARGES 3,414,080 3,525,625.02 4,122,082 3,472,431.85 3,512,000 1,255,928.59 1,156,871.67 37 - FACILITY FEES 4,520,000 4,824,835.93 4,822,000 4,919,568.05 4,822,000 883,365.21 792,027.25 38 - MISCELLANEOUS INCOME 251,981 166,073.65 185,000 2,428,484.73 185,000 75,896.76 36,306.27 39 - NON-REVENUE RECEIPTS 103,000 0.00 0 0.00 0 0.00 0.00 660 - SOLID WASTE FUND REVENUE 8,549,061 $8,913,647.30 9,429,082 $11,247,023.07 8,825,858 $2,288,312.42 $1,987,109.04 Expense Function Department Budget Actual Budget Actual Budget Actual 660 - SOLID WASTE MANAGEMENT 96 - SOLID WASTE 7410 - SOLID WASTE MANAGEMENT 7,628,133 6,113,890.52 7,763,141 7,002,160.47 7,964,989 2,030,283.55 1,780,431.95 7431 - RETIREE INSURANCE SW 20,000 26,509.00 29,712 23,993.00 19,356 5,579.00 8,764.00 9990 - NON-DEPARTMENTAL 900,928 $1,146,781.72 1,636,229 $2,107,556.06 841,513 $0.00 0.00 610 - SOLID WASTE FUND EXPENSE 8,549,061 $7,287,181.24 9,429,082 $9,133,709.53 8,825,858 $2,035,862.55 $1,789,195.95 660 - SOLID WASTE FUND REVENUE (OVER) / UNDER EXPENSES 0 $1,626,466.06 0 $2,113,313.54 0 $252,449.87 $197,913.09 FY 2023 Same Period Last Year FY 2025 FY 2025FY 2024 FY 2024FY 2023 Solid Waste Fund Unaudited as of October 31, 2024 Same Period Last Year Solid Waste Fund 660 12 of 37 10.2024 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 2024 2025 July $3,387,995.72 $4,457,425.74 $5,242,053.75 $6,062,990.75 $6,329,191.67 August $3,375,944.64 $4,647,598.39 $5,341,058.08 $6,031,473.51 $6,555,248.78 September $3,607,274.52 $4,882,131.66 $5,547,560.45 $6,165,598.96 $6,517,382.00 October $3,759,678.53 $5,029,336.00 $5,661,414.55 $6,206,732.64 $6,431,467.18 November $5,581,197.69 $6,828,615.40 $7,650,032.21 $7,989,843.51 December $6,451,303.81 $7,686,623.97 $8,441,890.85 $8,430,714.10 January $4,616,721.91 $5,784,640.53 $8,071,097.98 $8,957,335.18 $9,146,711.33 February $4,751,271.26 $5,844,033.09 $8,201,845.59 $9,072,792.36 $9,137,363.91 March $4,565,672.41 $5,773,139.20 $8,188,060.38 $8,162,225.83 $9,040,116.04 April $4,268,648.15 $5,713,193.95 $7,697,878.34 $7,939,798.65 $8,593,194.34 May $4,194,405.45 $5,677,132.65 $7,291,803.85 $7,812,630.66 $6,819,352.41 June $3,590,915.49 $4,646,306.54 $5,409,762.66 $6,655,083.50 $6,621,106.76 CASH Solid Waste Fund Unaudited as of October 31, 2024 Solid Waste Fund Cash 13 of 37 10.2024 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 850,000 553,775.07 850,000 543,551.73 850,000 205,783.86 196,301.95 38 - MISCELLANEOUS INCOME 0 5,792.57 0 0.00 0 0.00 0.00 39 - NON-REVENUE RECEIPTS 0 0.00 0 0.00 0 0.00 0.00 810 - WORKER'S COMP FUND REVENUE 850,000 $559,567.64 850,000 $543,551.73 850,000 $205,783.86 $196,301.95 Expense Function Department Budget Actual Budget Actual Budget Actual 810 - WORKERS COMPENSATION FUND 00 - GENERAL GOVERNMENT 9301 - WORKER'S COMPENSATION 850,000 854,566.54 850,000 516,873.53 850,000 $754,240.66 407,313.34 810 - WORKER'S COMP FUND EXPENSE 850,000 $854,566.54 850,000 $516,873.53 850,000 $754,240.66 $407,313.34 810 - WORKERS'S COMP FUND REVENUE (OVER) / UNDER EXPENSES 0 $294,998.90 0 $26,678.20 0 $548,456.80 $211,011.39 Same Period Last Year Same Period Last Year FY 2023 FY 2025 FY 2025 Worker's Compensation Fund Unaudited as of October 31, 2024 FY 2024 FY 2024FY 2023 Worker's Comp Fund 810 14 of 37 10.2024 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 2024 2025 July $4,629,563.32 $5,397,537.95 $6,198,476.66 $5,745,898.77 $5,625,560.56 August $4,708,459.01 $5,246,986.87 $5,963,212.81 $5,771,021.35 $5,315,957.68 September $4,785,314.35 $5,461,742.83 $5,986,205.95 $5,802,536.61 $5,360,212.35 October $4,844,771.48 $5,445,463.58 $6,015,973.71 $5,813,455.58 $5,384,442.80 November $4,925,635.39 $5,542,243.37 $6,011,959.38 $5,836,855.64 December $4,982,050.03 $5,731,380.38 $6,036,954.24 $5,860,191.16 January $3,318,944.43 $5,056,960.44 $5,816,058.20 $6,008,286.38 $5,855,288.99 February $3,402,272.55 $5,098,194.24 $5,865,374.15 $6,023,150.11 $5,885,825.14 March $4,462,485.39 $5,134,695.99 $5,944,781.80 $6,034,359.79 $5,919,860.47 April $4,544,990.12 $5,193,817.86 $6,032,017.52 $6,041,866.35 $5,916,637.42 May $4,545,144.92 $5,139,295.68 $6,116,497.62 $6,028,294.55 $5,955,062.65 June $4,627,680.64 $5,380,269.92 $6,163,362.66 $6,036,996.00 $5,936,887.32 CASH Worker's Compensation Fund Unaudited as of October 31, 2024 Worker's Comp Fund Cash 15 of 37 10.2024 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 250,000 128,054.68 250,000 93,115.66 250,000 27,315.15 40,439.31 39 - NON-REVENUE RECEIPTS 1,000,000 0.00 0 0.00 0 0.00 0.00 820 - UNEMPLOYMENT FUND REVENUE 1,250,000 $128,054.68 250,000 $93,115.66 250,000 $27,315.15 $40,439.31 Expense Function Department Budget Actual Budget Actual Budget Actual 820 - UNEMPLOYMENT INSURANCE 00 - GENERAL GOVERNMENT 9305 - UNEMPLOYMENT INSURANCE 250,000 $31,606.81 250,000 $49,731.76 250,000 $0.00 0.00 9910 - CONTINGENCY 1,000,000 $1,000,000.00 0 $0.00 0 $0.00 0.00 820 - UNEMPLOYMENT FUND EXPENSE 1,250,000 $1,031,606.81 250,000 $49,731.76 250,000 $0.00 $0.00 820 - UNEMPLOYMENT FUND REVENUE (OVER) / UNDER EXPENSES 0 $903,552.13 0 $43,383.90 0 $27,315.15 $40,439.31 FY 2023 Same Period Last Year Same Period Last Year FY 2025 FY 2025 FY 2024 FY 2024FY 2023 Unemployment Insurance Fund Unaudited as of October 31, 2024 Unemployment Ins Fund 820 16 of 37 10.2024 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 2024 2025 July $1,564,861.07 $1,753,400.43 $1,850,881.89 $947,753.76 $987,222.77 August $1,582,832.12 $1,762,410.64 $1,861,008.73 $959,484.99 $994,087.29 September $1,600,689.65 $1,780,727.76 $1,871,494.58 $971,341.68 $1,000,995.70 October $1,618,305.74 $1,780,727.76 $1,881,948.64 $977,672.85 $1,007,932.59 November $1,638,946.38 $1,789,872.72 $1,892,577.25 $984,071.05 December $1,657,035.68 $1,782,256.94 $1,871,937.68 $941,412.99 January $1,474,589.24 $1,675,333.87 $1,791,497.73 $1,882,907.21 $947,943.54 February $1,475,924.07 $1,673,523.80 $1,801,313.49 $1,893,735.82 $954,312.49 March $1,493,866.97 $1,691,308.04 $1,811,113.56 $1,904,454.36 $960,712.51 April $1,511,420.05 $1,709,071.02 $1,820,978.24 $1,915,349.90 $967,206.02 May $1,511,420.05 $1,709,071.02 $1,830,806.28 $926,042.90 $973,806.50 June $1,529,156.27 $1,748,924.02 $1,840,785.67 $937,233.54 $980,617.44 CASH Unemployment Insurance Fund Unaudited as of October 31, 2024 Unemployment Ins Fund Cash 17 of 37 10.2024 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 191,875 154,380.00 228,762 186,444.79 229,901 56,355.00 52,815.59 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 191,875 $154,380.00 228,762 $186,444.79 229,901 $56,355.00 $52,815.59 Expense Function Department Budget Actual Budget Actual Budget Actual 830 - EMPLOYEE CLINIC 00 - GENERAL GOVERNMENT 9302 - EMPLOYEE CLINIC 191,875 178,079.32 228,762 195,365.09 229,901 54,575.56 47,671.68 830 - EMPLOYEE CLINIC FUND EXPENSE 191,875 $178,079.32 228,762 $195,365.09 229,901 $54,575.56 $47,671.68 830 - EMPLOYEE CLINIC FUND REVENUE (OVER) / UNDER EXPENSES 0 $23,699.32 0 $8,920.30 0 $1,779.44 $5,143.91 FY 2025 FY 2025FY 2023 FY 2024 FY 2024 Same Period Last Year Same Period Last Year FY 2023 Employee Clinic Fund Unaudited as of October 31, 2024 Employee Clinic Fund 830 18 of 37 10.2024 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 2024 2025 July $700,090.56 $692,061.11 $723,019.23 $699,682.16 $690,186.90 August $697,900.58 $703,376.13 $723,881.09 $699,923.80 $689,090.44 September $697,339.53 $723,948.07 $723,117.23 $697,036.81 $689,606.00 October $696,760.57 $714,556.04 $721,661.50 $697,128.72 $683,863.04 November $695,238.45 $715,794.77 $722,166.94 $696,707.23 December $697,288.04 $714,986.69 $722,572.03 $700,493.76 January $653,534.82 $696,374.16 $709,565.30 $712,125.82 $693,199.86 February $653,489.63 $691,759.00 $709,021.02 $715,311.33 $690,188.80 March $655,093.01 $690,369.37 $708,705.76 $706,441.27 $688,889.09 April $655,094.11 $691,478.87 $709,557.47 $704,910.81 $685,804.45 May $639,617.51 $679,723.63 $703,692.41 $700,768.29 $681,320.31 June $668,125.25 $688,250.11 $720,716.69 $699,088.15 $689,555.70 CASH Employee Clinic Fund Unaudited as of October 31, 2024 Employee Clinic Fund Cash 19 of 37 10.2024 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 11,253,500 11,097,615.91 12,000,000 11,495,416.84 12,000,000 4,030,137.30 3,719,441.29 38 - MISCELLANEOUS INCOME 650,000 1,261,002.15 0 1,449,859.89 0 140,979.15 112,607.81 39 - NON-REVENUE RECEIPTS 323,000 0.00 486,500 0.00 1,503,500 0.00 0.00 841 - MEDICAL SELF INS FUND REVENUE 12,226,500 $12,358,618.06 12,486,500 $12,945,276.73 13,503,500 $4,171,116.45 $3,832,049.10 Expense Function Department Budget Actual Budget Actual Budget Actual 841 - MEDICAL INSURANCE - SELF 00 - GENERAL GOVERNMENT 9303 - MEDICAL INSURANCE - SELF 12,226,500 10,662,369.55 12,486,500 12,466,348.43 13,503,500 4,454,774.66 2,842,166.20 841 - MEDICAL SELF INS FUND EXPENSE 12,226,500 $10,662,369.55 12,486,500 $12,466,348.43 13,503,500 $4,454,774.66 $2,842,166.20 841 - MEDICAL SELF INS FUND REVENUE (OVER) / UNDER EXPENSES 0 $1,696,248.51 0 $478,928.30 0 $283,658.21 $989,882.90 FY 2023 FY 2025 FY 2025 Same Period Last Year Same Period Last Year FY 2024 FY 2024FY 2023 Medical Self Insurance Fund Unaudited as of October 31, 2024 Medical Self Ins Fund 841 20 of 37 10.2024 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 2024 2025 July $8,394,410.05 $9,936,719.25 $11,349,904.41 $13,123,302.23 $14,221,280.41 August $8,309,827.07 $9,558,799.23 $10,768,815.17 $12,519,779.60 $13,144,389.65 September $8,147,930.01 $10,182,610.45 $10,928,333.21 $12,632,767.66 $12,901,570.06 October $8,437,620.01 $9,335,253.68 $11,370,700.94 $13,321,922.90 $13,149,587.55 November $8,763,538.51 $9,233,189.07 $11,135,597.77 $12,957,084.14 December $9,045,130.83 $9,259,586.30 $11,221,624.97 $13,278,900.80 January $7,007,592.83 $8,831,273.60 $9,612,099.50 $11,189,119.32 $13,180,590.67 February $7,354,736.35 $9,169,687.18 $9,498,226.66 $11,364,307.86 $12,991,069.68 March $7,342,921.96 $8,848,785.68 $9,065,970.50 $11,660,274.02 $13,767,320.08 April $7,508,905.85 $9,411,546.73 $9,200,399.34 $11,986,582.01 $13,252,347.95 May $7,195,825.04 $8,592,344.42 $9,240,938.82 $11,881,979.85 $13,130,670.41 June $6,837,286.28 $9,752,219.84 $10,485,775.01 $12,332,058.18 $13,223,952.94 CASH Medical Self Insurance Fund Unaudited as of October 31, 2024 Medical Self Ins Fund Cash 21 of 37 10.2024 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 650,000 519,533.60 650,000 570,909.91 650,000 137,516.06 175,760.12 39 - NON-REVENUE RECEIPTS 0 0.00 0 0.00 0 0.00 0.00 843 - DENTAL SELF INS FUND REVENUE 650,000 $519,533.60 650,000 $570,909.91 650,000 $137,516.06 $175,760.12 Expense Function Department Budget Actual Budget Actual Budget Actual 843 - DENTAL INSURANCE - SELF 00 - GENERAL GOVERNMENT 9307 - DENTAL INSURANCE - SELF 650,000 459,020.75 650,000 461,934.46 650,000 195,134.51 149,621.04 843 - DENTAL SELF INS FUND EXPENSE 650,000 $459,020.75 650,000 $461,934.46 650,000 $195,134.51 $149,621.04 843 - DENTAL SELF INS FUND REVENUE (OVER) / UNDER EXPENSES 0 $60,512.85 0 $108,975.45 0 $57,618.45 $26,139.08 FY 2023 FY 2025 Same Period Last Year Same Period Last Year FY 2025FY 2023 FY 2024 FY 2024 Dental Self Insurance Fund Unaudited as of October 31, 2024 Dental Self Ins Fund 843 22 of 37 10.2024 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 2024 2025 July $612,444.32 $724,520.63 $822,532.24 $853,196.58 $966,594.06 August $602,629.10 $696,545.18 $790,185.12 $843,955.60 $955,082.74 September $609,678.56 $734,630.02 $797,437.93 $851,846.69 $963,285.78 October $603,363.16 $695,046.20 $795,743.33 $872,196.82 $917,813.28 November $620,268.72 $701,911.17 $804,974.47 $854,937.88 December $653,169.60 $711,856.70 $812,872.25 $879,346.67 January $536,850.80 $657,824.44 $731,212.41 $832,304.92 $881,010.37 February $547,206.22 $665,545.09 $737,896.84 $837,835.80 $883,889.09 March $544,639.17 $673,523.14 $739,863.15 $832,355.91 $928,991.11 April $551,952.84 $676,078.18 $739,741.66 $836,984.76 $913,926.03 May $551,708.84 $605,182.75 $738,936.50 $834,680.46 $911,791.97 June $544,280.85 $703,042.49 $780,381.70 $846,057.74 $956,557.53 CASH Dental Self Insurance Fund Unaudited as of October 31, 2024 Dental Self Ins Fund Cash 23 of 37 10.2024 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 1,500,000 1,409,301.62 1,500,000 1,303,659.91 1,500,000 193,457.26 150,226.44 36 - ENTERPRISE CHARGES 0 225.00 0 75.00 0 0.00 0.00 39 - NON-REVENUE RECEIPTS 0 0.00 0 0.00 0 0.00 0.00 845 - RETIREE SELF INS FUND REVENUE 1,500,000 $1,409,526.62 1,500,000 $1,303,734.91 1,500,000 $193,457.26 $150,226.44 Expense Function Department Budget Actual Budget Actual Budget Actual 845 - MEDICAL INSURANCE RETIREE 00 - GENERAL GOVERNMENT 9304 - MEDICAL INSURANCE - RETIREE 1,500,000 1,357,594.41 1,500,000 1,006,284.77 1,500,000 395,397.53 320,352.51 845 - RETIREE SELF INS FUND EXPENSE 1,500,000 $1,357,594.41 1,500,000 $1,006,284.77 1,500,000 $395,397.53 $320,352.51 845 - RETIREE SELF INS FUND REVENUE (OVER) / UNDER EXPENSES 0 $51,932.21 0 $297,450.14 0 $201,940.27 $170,126.07 Same Period Last Year Same Period Last Year FY 2025 FY 2023 FY 2023 FY 2025 Retiree Self Insurance Fund Unaudited as of October 31, 2024 FY 2024 FY 2024 Retiree Self Ins Fund 845 24 of 37 10.2024 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 2024 2025 July $646,924.11 $433,059.43 $829,677.64 $872,551.83 $1,188,298.72 August $590,241.30 $433,709.18 $770,327.59 $728,469.75 $1,027,180.31 September $489,464.41 $465,741.89 $736,325.28 $692,915.07 $1,001,682.78 October $466,294.49 $453,817.31 $706,499.95 $688,896.83 $997,312.08 November $396,067.66 $466,968.91 $641,611.83 $590,078.99 December $334,887.79 $476,600.30 $599,142.27 $556,000.08 January ($315,453.19) $206,371.20 $490,226.98 $445,630.08 $478,336.05 February ($386,583.22) $180,684.24 $500,421.34 $318,834.16 $443,975.85 March ($530,399.34) $35,718.25 $509,125.50 $246,480.74 $444,219.44 April ($611,564.54) $93,954.23 $519,585.17 $123,809.37 $410,838.87 May ($622,617.07) $594,052.00 $532,894.99 $60,110.80 $376,172.06 June ($625,264.03)$428,365.66 $807,090.69 $859,022.90 $1,175,632.62 CASH Retiree Self Insurance Fund Unaudited as of October 31, 2024 Retiree Self Ins Fund Cash 25 of 37 10.2024 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 240,909 121,749.00 148,008 417,816.00 192,640 0.00 57,968.00 38 - MISCELLANEOUS INCOME 12,000 16,269.51 22,360 22,360.00 12,000 21,491.00 10,900.00 39 - NON-REVENUE RECEIPTS 100,000 100,000.00 484,521 0.00 306,000 0.00 0.00 880 - FLEET SERVICES FUND REVENUE 352,909 $238,018.51 654,889 $440,176.00 510,640 $21,491.00 $68,868.00 Expense Function Department Budget Actual Budget Actual Budget Actual 880 - FLEET SERVICES 00 - GENERAL GOVERNMENT 9410 - FLEET SERVICES 290,679 159,127.40 654,889 531,943.48 510,640 329,155.16 265,519.66 9910 - CONTINGENCY 62,230 0.00 0 0.00 0 0.00 0.00 880 - FLEET SERVICES FUND EXPENSE 352,909 $159,127.40 654,889 $531,943.48 510,640 $329,155.16 $265,519.66 880 - FLEET SERVICES FUND REVENUE (OVER) / UNDER EXPENSES 0 $78,891.11 0 $91,767.48 0 $307,664.16 $196,651.66 Same Period Last Year Same Period Last Year FY 2025 FY 2023 FY 2023 FY 2025 Fleet Services Fund Unaudited as of October 31, 2024 FY 2024 FY 2024 Fleet Services Fund 880 26 of 37 10.2024 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 2024 2025 July $601,279.16 $1,090,458.91 $1,203,969.99 $1,179,589.10 $1,180,461.62 August $609,506.58 $1,184,866.91 $1,199,951.99 $1,072,380.65 $1,093,700.62 September $615,658.56 $1,229,825.91 $1,167,317.99 $1,061,842.35 $943,991.47 October $624,166.20 $1,229,825.91 $1,199,618.20 $1,075,577.44 $871,180.46 November $632,714.95 $1,214,819.91 $1,212,931.71 $1,090,069.44 December $791,230.55 $1,236,861.91 $1,223,968.71 $1,116,021.44 January $565,853.83 $799,782.08 $1,244,772.91 $1,232,852.73 $1,130,513.44 February $572,455.44 $808,107.96 $1,170,235.91 $1,245,938.71 $1,145,005.44 March $573,647.74 $816,344.80 $1,179,361.91 $1,354,781.71 $1,100,152.11 April $574,877.57 $823,803.80 $1,188,487.91 $1,266,466.50 $908,851.49 May $616,138.99 $831,262.80 $1,110,625.14 $1,265,171.10 $922,857.62 June $571,361.34 $1,090,458.91 $1,193,337.99 $1,272,229.10 $1,180,461.62 CASH Fleet Services Fund Unaudited as of October 31, 2024 Fleet Services Fund Cash 27 of 37 10.2024 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 1,748,415 0.00 0 471,493.44 0 132.71 162.62 38 - MISCELLANEOUS INCOME 0 1,601,809.13 1,773,310 1,695,382.86 3,434,960 1,152,677.70 557,116.33 39 - NON-REVENUE RECEIPTS 2,046,804 2,074,009.00 350,350 350,000.00 0 0.00 0.00 890 - INFO TECHNOLOGY FUND REVENUE 3,795,219 $3,675,818.13 2,123,660 $2,516,876.30 3,434,960 $1,152,810.41 $557,278.95 Expense Function Department Budget Actual Budget Actual Budget Actual 890 - INFORMATION TECHNOLOGY 00 - GENERAL GOVERNMENT 9420 - TECHNOLOGY 3,795,219 2,647,317.05 2,123,660 1,928,442.68 3,434,960 1,191,836.41 711,688.73 890 - INFO TECHNOLOGY FUND EXPENSE 3,795,219 $2,647,317.05 2,123,660 $1,928,442.68 3,434,960 $1,191,836.41 $711,688.73 890 - INFO TECHNOLOGY FUND REVENUE (OVER) / UNDER EXPENSES 0 $1,028,501.08 0 $588,433.62 0 $39,026.00 $154,409.78 Same Period Last Year Same Period Last Year FY 2025FY 2023 FY 2023 FY 2025 Information Technology Fund Unaudited as of October 31, 2024 FY 2024 FY 2024 Info Technology Fund 890 28 of 37 10.2024 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 2024 2025 July $852,093.02 $1,491,852.27 $2,011,076.10 $2,884,692.29 $3,513,264.13 August $804,366.93 $1,558,798.40 $2,089,994.83 $2,653,325.67 $2,552,211.87 September $800,161.86 $1,577,002.07 $1,729,069.00 $2,696,925.55 $2,682,173.61 October $902,530.92 $1,729,919.23 $1,725,039.53 $2,703,241.31 $3,493,601.40 November $889,233.88 $1,765,161.46 $894,683.88 $2,772,283.57 December $1,046,992.00 $1,751,059.99 $906,874.68 $2,820,549.17 January $515,312.48 $1,189,759.12 $1,792,688.16 $1,055,166.45 $2,860,009.70 February $534,562.33 $1,297,161.54 $1,843,447.45 $1,128,314.64 $2,970,161.23 March $536,134.58 $1,426,825.09 $1,790,864.84 $2,844,280.84 $3,057,280.14 April $570,566.56 $1,207,565.76 $1,763,694.03 $2,751,244.56 $3,368,404.90 May $612,977.73 $973,972.46 $1,845,823.82 $2,796,637.32 $3,654,990.78 June $798,424.51 $1,492,175.30 $1,924,106.94 $3,140,915.15 $3,563,465.34 CASH Information Technology Fund Unaudited as of October 31, 2024 Info Technology Fund Cash 29 of 37 10.2024 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 33 - RESTRICTED REVENUE 884,546 455,436.16 1,489,942 145,268.47 174,492 62,394.93 0.00 38 - MISCELLANEOUS INCOME 73,000 28,254.50 68,250 15,570.81 50,000 0.00 1,400.00 39 - NON-REVENUE RECEIPTS 195,350 0.00 293,112 0.00 52,000 0.00 0.00 250 - VET TREATMENT COURT REVENUE 1,152,896 $483,690.66 1,851,304 $160,839.28 276,492 $62,394.93 $1,400.00 Expense Function Department Budget Actual Budget Actual Budget Actual 250 - VETERANS TREATMENT COURT 00 - GENERAL GOVERNMENT 4185 - VETERANS TREATMENT COURT 1,152,896 435,225.61 1,851,304 359,985.64 276,492 83,626.30 103,511.99 250 - VET TREATMENT COURT EXPENSE 1,152,896 $435,225.61 1,851,304 $359,985.64 276,492 $83,626.30 $103,511.99 250 - VET TREATMENT COURT REVENUE (OVER) / UNDER EXPENSES 0 $48,465.05 0 $199,146.36 0 $21,231.37 $102,111.99 FY 2023 FY 2025 FY 2025FY 2023 Same Period Last Year Same Period Last Year FY 2024 FY 2024 Veteran's Treatment Court Unaudited as of October 31, 2024 Veteran's Treatment Court 250 30 of 37 10.2024 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 2024 2025 July $3,916.48 $26,014.22 $106,617.08 $128,518.38 $16,907.36 August ($19.11) $6,936.02 $197,695.62 $241,771.52 $30,883.74 September ($5,847.89) $1,617.01 $170,316.49 $182,473.08 ($18,308.88) October ($52,239.74) ($48,042.22) $236,136.83 $146,746.36 $27,668.34 November ($55,209.63) ($67,669.08) $228,538.41 $145,108.22 December ($10,827.18) ($74,565.51) $144,375.79 $93,188.19 January $7,582.66 ($54,087.90) ($93,893.26) $120,098.68 $117,979.77 February $35,756.46 ($60,437.65) ($36,255.36) $154,587.98 $98,451.54 March $19,011.14 ($63,403.68) ($66,528.04) $113,762.06 $32,231.97 April $30,146.67 ($63,500.51) ($80,604.24) $132,819.22 $41,767.57 May $42,612.59 ($72,985.76) $162,839.31 $120,571.26 $86,167.58 June $28,305.11 $36,571.92 $127,852.90 $69,181.84 $23,146.04 CASH Veteran's Treatment Court Unaudited as of October 31, 2024 Veteran's Treatment Court Cash 31 of 37 10.2024 Monthly Master as of December 31, 2020 1. Current year activity :City Hold Harmless School Hold HarmlessFiscal Year 2025as 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, 2024 1,121,135.77$ 777,528.29$ 348,226.03$ 269,945.50$ 539,891.00$ -$ 590,867.64$ 340,930.54$ (162,164.56)$ (210,582.22)$ 302,941.29$ 3,918,719.28$ August, 2024 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ September, 2024 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ October, 2024 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ November, 2024 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ December, 2024 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ January, 2025 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ February, 2025 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ March, 2025 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ April, 2025 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ May, 2025 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ June, 2025 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 1,121,135.77$ 777,528.29$ 348,226.03$ 269,945.50$ 539,891.00$ -$ 590,867.64$ 340,930.54$ (162,164.56)$ (210,582.22)$ 302,941.29$ 3,918,719.28$ Year over Year Change 8.26% 0.55% 6.36% 0.59% 0.59% -100.00% 3.58% 8.97% -3.67% -8.37% 8.90% 5.77% 2. Comparison to prior year :City Hold Harmless School Hold HarmlessFiscal Year 2024 Article 39 Article 40 Article 42 Article 40 Article 42 Article 44 Article 44 *524 Article 46 Article 39 Article 39 Special Total July, 2023 1,035,583.41$ 773,305.30$ 327,403.11$ 268,373.83$ 536,747.66$ 5.59$ 570,454.78$ 312,864.36$ (168,342.48)$ (229,814.96)$ 278,193.55$ 3,704,774.15$ August, 2023 1,201,849.83$ 772,804.38$ 358,990.46$ 276,925.50$ 553,851.00$ 10.98$ 570,454.78$ 370,719.99$ (164,305.00)$ (195,227.74)$ 315,963.24$ 4,062,037.42$ September, 2023 1,031,910.81$ 721,961.21$ 329,415.98$ 245,520.27$ 491,040.55$ 6.37$ 570,454.78$ 309,637.87$ (151,909.00)$ (193,764.77)$ 278,110.38$ 3,632,384.45$ October, 2023 1,165,607.28$ 721,527.97$ 349,281.49$ 256,135.52$ 512,271.05$ -$ 570,454.78$ 360,990.99$ (150,622.69)$ (168,863.21)$ 306,809.49$ 3,923,592.67$ November, 2023 1,202,560.07$ 756,539.66$ 366,845.52$ 261,640.34$ 523,280.67$ -$ 570,752.19$ 368,841.50$ (157,081.80)$ (175,826.78)$ 318,990.36$ 4,036,541.73$ December, 2023 1,387,799.81$ 846,760.69$ 423,079.69$ 291,740.05$ 583,480.09$ (0.27)$ 570,752.19$ 425,882.76$ (172,913.63)$ (184,438.54)$ 368,166.70$ 4,540,309.54$ January, 2024 859,007.54$ 666,882.28$ 276,021.98$ 230,147.34$ 460,294.68$ -$ 570,752.19$ 256,929.96$ (146,422.23)$ (206,154.47)$ 231,969.63$ 3,199,428.90$ February, 2024 1,124,516.50$ 647,707.95$ 341,505.27$ 221,020.11$ 442,040.22$ -$ 570,752.19$ 348,519.97$ (129,765.29)$ (123,903.60)$ 297,707.24$ 3,740,100.56$ March, 2024 1,270,326.22$ 790,798.55$ 390,665.44$ 271,202.28$ 542,404.57$ -$ 570,752.19$ 388,355.30$ (162,016.25)$ (178,179.20)$ 337,965.90$ 4,222,275.00$ April, 2024 1,201,866.80$ 716,192.55$ 363,012.44$ 247,387.85$ 494,775.69$ -$ 570,752.19$ 371,473.65$ (146,398.25)$ (149,875.72)$ 317,671.73$ 3,986,858.93$ May, 2024 1,281,135.07$ 788,223.04$ 387,558.63$ 272,764.27$ 545,528.54$ -$ 572,592.25$ 394,389.00$ (158,903.21)$ (176,130.01)$ 339,612.62$ 3,728,709.61$ June, 2024 1,288,556.41$ 842,887.43$ 397,748.48$ 290,159.72$ 580,319.45$ -$ 590,867.64$ 392,144.04$ (171,788.08)$ (207,496.28)$ 344,098.00$ 4,347,496.81$ 1,035,583.41$ 773,305.30$ 327,403.11$ 268,373.83$ 536,747.66$ 5.59$ 570,454.78$ 312,864.36$ (168,342.48)$ (229,814.96)$ 278,193.55$ 3,704,774.15$ AnnualizedBudget % Collected(01 month)to Date1103100 310231 748,388.99$ 10,403,000$ (9,654,611.01)$ 7,802,250$ (7,053,861.01)$ 7.19%NC Sales Tax - Article 39 1103100 310233 777,528.29$ 9,000,000$ (8,222,471.71)$ 6,750,000$ (5,972,471.71)$ 8.64%NC Sales Tax - Article 40 (General Fund)1103100 310235 348,226.03$ 4,100,000$ (3,751,773.97)$ 3,075,000$ (2,726,773.97)$ 8.49%NC Sales Tax - Article 42 (General Fund)1103100 310237 590,867.64$ 6,500,000$ (5,909,132.36)$ 4,875,000$ (4,284,132.36)$ 9.09%NC Sales Tax - Article 44 & Article 44 *5242,465,010.95$ 30,003,000$ (27,537,989.05)$ 22,502,250.00$ (20,037,239.05)$ 8.22% 2118401 - 380892 302,941.29$ 3,710,014$ (3,407,072.71)$ 2,782,510.50$ (2,479,569.21)$ 8.17%NC Sales Tax Special Districts 3003100 310233 269,945.50$ 2,415,182$ (2,145,236.50)$ 1,811,387$ (1,541,441.00)$ 11.18%NC Sales Tax - Article 40 (Education)3003100 310235 539,891.00$ 5,244,640$ (4,704,749.00)$ 3,933,480$ (3,393,589.00)$ 10.29%NC Sales Tax - Article 42 (Education)3003100 310239 340,930.54$ 3,122,285$ (2,781,354.46)$ 2,341,714$ (2,000,783.21)$ 10.92%NC Sales Tax - Article 461,150,767.04$ 10,782,107$ (9,631,339.96)$ 8,086,580.25$ (6,935,813.21)$ 10.67% 3. Reconciliation to general ledger :Over/(Under) Annualized BudgetBalance to Tyler Activity Budget Over/(Under) Budget HARNETT COUNTY SALES TAX ANALYSIS BY ARTICLE General Fund Board of Education General Fund Board of Education Monthly Sales Tax 32 of 37 10.2024 Monthly Master HARNETT COUNTY FINANCIAL SUMMARY REPORT 11/19/2024 June 30, 2023 HARNETT COUNTY TOWNS 1 0.00% 20.00% 40.00% 60.00% 80.00% 100.00% ANGIER (5,832) COATS (2,222) DUNN (8,535) ERWIN (4,631) LILLINGTON (4,583) 62.11% 113.95% 36.50% 133.52% 87.64% Fund Balance % Towns Pier Group (population based) Towns 33 of 37 10.2024 Monthly Master HARNETT COUNTY FINANCIAL SUMMARY REPORT 11/19/2024 June 30, 2023 HARNETT COUNTY TOWNS 1 Angier Coats Dunn Erwin Lillington $ 5.9 M $ 1.7 M $ 13.0 M $ 3.4 M $ 6.0 M $ 7.2 M $ 1.9 M $ 14.0 M $ 4.4 M $ 7.3 M Revenues / Expenditures Revenues Expenditures Towns 34 of 37 10.2024 Monthly Master HARNETT COUNTY FINANCIAL SUMMARY REPORT 11/19/2024 June 30, 2023 HARNETT COUNTY TOWNS 1 1 https://www.nctreasurer.com/slg/lfm/financial-analysis/Pages/Analysis-by-Population.aspx $7,544,825 $2,234,595 $8,730,621 $8,745,888 $7,314,204 Cash Angier Coats Dunn Erwin Lillington Towns 35 of 37 10.2024 Monthly Master HARNETT COUNTY FINANCIAL SUMMARY REPORT 11/19/2024 June 30, 2023 HARNETT COUNTY TOWNS 1 2023 2022 2021 2020 2019 Angier 7,219,289$ 5,923,124$ 5,288,373$ 4,375,452$ 4,053,035$ Coats 1,866,471$ 1,707,416$ 1,711,011$ 1,500,712$ 1,573,107$ Dunn 13,973,183$ 12,199,936$ 11,915,650$ 11,229,699$ 10,563,357$ Erwin 4,382,568$ 3,663,444$ 3,748,461$ 4,033,682$ 3,633,664$ Lillington 7,256,602$ 5,317,115$ 4,726,743$ 4,859,861$ 4,587,021$ 2023 2022 2021 2020 2019 Angier 5,937,125$ 6,194,572$ 3,962,912$ 4,304,101$ 3,720,425$ Coats 1,733,305$ 1,593,374$ 1,531,197$ 1,266,203$ 1,320,523$ Dunn 12,967,028$ 13,238,300$ 11,244,080$ 11,407,762$ 10,266,268$ Erwin 3,384,063$ 3,215,958$ 2,951,464$ 3,722,740$ 3,353,894$ Lillington 5,976,399$ 5,194,662$ 4,574,759$ 4,881,660$ 7,645,088$ Revenues Expenditures Towns 36 of 37 10.2024 Monthly Master HARNETT COUNTY FINANCIAL SUMMARY REPORT 11/19/2024 June 30, 2023 HARNETT COUNTY TOWNS 1 2023 2022 2021 2020 2019 Angier 62.11%68.84%128.50%100.44%111.09% Coats 113.95%113.11%108.74%117.72%89.67% Dunn 36.50%38.09%52.13%37.71%41.02% Erwin 133.52%109.53%104.68%63.75%55.49% Lillington 87.64%38.78%34.70%48.21%37.66% 2023 2022 2021 2020 2019 Angier 7,544,825$ 5,800,297$ 5,860,512$ 4,584,238$ 4,360,056$ Coats 2,234,595$ 2,271,149$ 1,746,630$ 1,583,822$ 1,354,638$ Dunn 8,730,621$ 8,000,720$ 5,418,437$ 4,642,176$ 1,611,418$ Erwin 8,745,888$ 7,571,325$ 6,166,810$ 5,605,754$ 5,337,622$ Lillington 7,314,204$ 2,523,527$ 2,399,357$ 2,536,487$ 2,475,675$ 1 https://logos.nctreasurer.com/Reporting/Report/External?applicationCode=AFIR Cash Fund Balance % Towns 37 of 37 10.2024 Monthly Master