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 AboutSeptember 2024 Financial Report Monthly Financial Reports September 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 10,389,187.47 8,051,468.24 31 - TAXES - SALES 21,416,000 28,878,720.90 26,561,800 30,207,510.88 30,003,000 0.00 0.00 32 - TAXES - OTHER 1,164,000 1,536,643.83 1,164,000 1,660,194.64 1,300,000 436,673.64 422,394.96 33 - RESTRICTED REVENUE 23,410,407 23,850,972.56 23,773,916 21,152,756.95 22,804,294 2,792,019.45 2,715,803.83 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 3,962,654.10 5,902,604.78 36 - ENTERPRISE CHARGES 0 4,392.51 0 6,325.96 0 897.62 416.58 37 - FACILITY FEES 0 2,783.82 0 3,487.26 0 0.00 1,523.76 38 - MISCELLANEOUS INCOME 2,109,210 2,487,949.62 820,092 302,645.92 948,847 718,964.65 1,219,011.13 39 - NON-REVENUE RECEIPTS 27,735,817 1,274,238.00 12,468,816 164,375.00 12,288,000 0.00 0.00 110 - GENERAL FUND REVENUE 171,205,638 $161,776,989.19 169,027,373 $161,390,368.65 178,174,263 $18,300,396.93 $15,875,201.02 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 135,696.25 128,658.38 4120 - COUNTY ADMINISTRATION 1,160,594 1,060,696.45 1,406,990 1,371,737.43 1,469,637 329,569.83 326,229.47 4130 - FINANCE 1,619,365 1,533,443.87 1,910,725 1,894,440.46 1,989,322 355,598.05 318,652.73 4131 - RETIREE INSURANCE 944,351 919,464.87 930,000 929,999.03 956,573 168,211.35 171,895.10 4140 - TAX 1,999,758 1,714,142.62 2,076,484 2,038,840.72 2,343,796 436,050.91 347,558.08 4150 - LEGAL SERVICES 387,832 369,867.69 589,456 571,875.48 634,280 124,156.35 82,020.31 4160 - HUMAN RESOURCES 966,968 882,574.81 967,288 956,690.67 672,502 137,504.31 503,498.93 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 133,729.13 95,537.89 4180 - CLERK OF COURT 28,233 17,713.99 51,810 45,359.68 53,815 7,329.93 7,465.00 4190 - REGISTER OF DEEDS 810,075 771,787.47 903,433 896,393.98 964,136 245,464.32 167,619.31 4210 - GENERAL SERVICES 255,027 252,022.15 272,931 272,763.64 296,962 61,938.10 54,527.84 4230 - FACILITIES MAINTENANCE 3,595,600 3,399,030.41 3,916,231 3,940,618.80 4,298,026 886,114.84 852,120.27 4250 - FLEET MAINTENANCE 907,315 841,138.04 1,120,753 1,108,538.90 1,111,197 194,144.95 170,001.60 4270 - INFORMATION TECHNOLOGY 2,736,780 2,617,423.22 2,850,044 2,838,039.08 2,125,815 375,513.21 665,365.28 4290 - GIS 846,687 810,806.18 1,005,874 999,473.46 1,087,118 315,001.74 285,339.37 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,842,839 0.00 0.00 00 - GENERAL GOVERNMENT Total 51,286,883 43,935,999.75 37,665,878 37,283,153.59 37,584,382 4,242,253.27 4,176,489.56 FY 2024 FY 2024 General Fund Unaudited as of September 30, 2024 FY 2025 Same Period Last Year Same Period Last Year FY 2023 FY 2023 FY 2025 General Fund 110 1 of 37 09.2024 Monthly Master Expense Function Department Budget Actual Budget Actual Budget Actual FY 2024 Same Period Last Year FY 2023 FY 2025 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 3,964,113.36 3,080,159.97 4330 - CAMPBELL DEPUTIES 586,694 575,389.37 727,436 624,155.97 691,536 134,912.33 121,642.64 4350 - SCHOOL RESOURCE OFFICER 2,147,192 1,580,281.44 2,480,674 2,057,966.99 2,697,805 360,136.24 378,721.84 4370 - CHILD SUPPORT ENFORCEMENT 98,087 96,248.57 110,767 104,587.47 107,988 21,941.03 20,017.64 4390 - JAIL 7,546,385 6,768,434.38 8,146,079 7,656,019.93 8,297,349 1,432,001.39 1,543,671.26 4410 - EMERGENCY MANAGEMENT 1,187,136 1,127,582.44 1,314,553 1,303,274.39 1,620,022 341,412.44 278,461.76 4411 - EMERGENCY SERVICES GRANTS 442,695 250,499.57 374,520 272,654.20 242,502 38,945.99 7,638.80 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,343,035.02 1,148,042.25 4510 - FIELD SERVICES 423,264 398,306.11 465,803 440,958.26 583,542 95,236.11 96,964.70 4512 - ANIMAL SHELTER 442,446 366,985.54 554,249 488,399.22 599,458 76,725.61 90,566.00 4530 - MEDICAL EXAMINER 100,000 82,400.00 100,000 67,545.90 100,000 21,840.30 12,400.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 286,975.93 249,071.11 10 - PUBLIC SAFETY Total 47,369,756 43,149,365.11 50,324,414 48,266,396.74 55,620,414 11,179,391.76 9,817,774.54 20 - TRANSPORTATION 4610 - TRANSPORTATION 1,493,881 1,040,368.09 1,576,325 1,320,124.60 1,875,856 339,580.50 254,743.65 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 681,509.65 310,615.07 30 - ENVIRONMENTAL PROTECTION 4710 - SOIL & WATER 309,461 295,848.31 339,110 328,969.13 365,978 75,743.24 67,328.59 4730 - FORESTRY PROGRAM 152,709 132,587.79 164,599 151,180.07 149,122 5,486.80 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 93,130.04 99,410.05 40 - ECONOMIC & PHYSICAL DEVELOPMNT 4910 - DEVELOPMENT SERVICES 1,119,722 1,033,858.20 1,252,686 1,184,125.19 1,464,512 309,195.67 282,642.73 4930 - ECONOMIC DEVELOPMENT 1,111,354 883,701.25 1,038,781 1,008,995.31 1,177,107 215,314.50 160,978.17 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,122.85 0.00 4971 - WIOA - ADULT 0 0.00 102,365 97,736.86 33,036 23,297.60 0.00 4973 - WIAO - NC WORKS CAREER CENTER 0 0.00 78,353 76,863.24 15,391 19,030.16 0.00 4975 - WIOA - DISLOCATED WORKER 0 0.00 57,292 57,086.71 19,161 10,211.46 0.00 4978 - WIOA - YOUTH - IN 0 0.00 34,283 34,201.47 11,412 13,090.66 0.00 4979 - WIOA - YOUTH - OUT 0 0.00 102,867 100,899.76 33,834 33,577.72 0.00 4990 - COOPERATIVE EXTENSION 443,332 402,432.61 459,580 396,348.23 508,465 68,116.97 60,658.93 4995 - COOPERATIVE EXT SPECIAL PROG 158,799 125,770.09 123,638 101,761.52 63,775 10,422.99 22,388.04 40 - ECONOMIC & PHYSICAL DEVELOPMNT Total 2,833,664 2,445,941.02 3,295,554 3,079,713.95 3,882,638 703,468.34 526,745.45 50 - HUMAN SERVICES 5110 - GENERAL ADMINISTRATION 9,637,937 7,349,865.69 269,764 236,698.78 523,711 63,369.86 1,212,012.80 5112 - VITAL RECORDS 0 0.00 28,215 27,310.61 29,625 6,012.20 6.30 5114 - AGING 0 0.00 105,919 95,122.53 86,858 20,981.77 0.00 5118 - LABORATORY SERVICES 0 0.00 312,717 274,791.38 321,694 60,925.63 14,700.32 General Fund 110 2 of 37 09.2024 Monthly Master Expense Function Department Budget Actual Budget Actual Budget Actual FY 2024 Same Period Last Year FY 2023 FY 2025 5120 - CHILD HEALTH 0 0.00 1,306,713 1,219,429.64 1,333,311 224,580.33 27,554.39 5121 - IMMUNIZATION ACTION PLAN 0 0.00 97,163 65,191.17 73,571 9,358.27 157.56 5122 - LEAD 0 0.00 8,170 2,675.12 8,462 0.00 0.00 5124 - SCHOOL HEALTH NURSE 0 0.00 150,000 150,000.00 150,000 16,666.67 0.00 5130 - ADULT HEALTH 0 0.00 256,177 226,480.21 227,881 76,966.93 60,054.66 5131 - SEXUALLY TRANSMITTED DISEASE 0 0.00 277,218 237,488.12 357,078 44,125.59 3,165.77 5134 - MATERNAL HEALTH 0 0.00 586,715 538,216.41 605,192 117,273.16 10,641.32 5135 - FAMILY PLANNING 0 0.00 576,156 548,420.49 523,190 118,256.49 15,475.68 5137 - TUBERCULOSIS PROGRAM 0 0.00 67,620 62,105.69 73,222 9,487.78 3,524.63 5138 - COMMUNICABLE DISEASES 0 0.00 77,717 72,534.17 124,027 19,758.59 163.62 5139 - TANF 0 0.00 16,728 16,278.87 16,203 0.00 0.00 5140 - HEALTH EDUCATION 0 0.00 92,013 73,556.22 90,097 19,460.96 1,288.01 5142 - CHILD FATALITY PREVENTION TEAM 0 0.00 7,625 3,293.66 8,064 480.00 0.00 5144 - HIV-STD COUNTY 0 0.00 22,904 19,528.32 23,873 1,982.09 123.00 5145 - HEALTH PROMOTION 0 0.00 82,393 79,431.17 85,991 14,749.85 220.01 5146 - HEALTHY COMMUNITIES 0 0.00 50,186 42,936.46 51,750 6,225.86 30.13 5148 - ITTS 0 0.00 55,484 55,051.06 57,915 10,270.24 552.66 5149 - MOBILE HEALTH PROGRAM 0 0.00 0 0.00 15,658 2,048.00 0.00 5150 - WIC - ADMINISTRATION 0 0.00 70,695 66,801.57 74,197 8,363.95 30.21 5151 - WIC - CLIENT SERVICES 0 0.00 614,554 570,918.38 549,947 111,740.07 7,839.83 5152 - WIC - NUTRITION EDUCATION 0 0.00 166,801 150,390.07 144,129 28,448.87 0.00 5153 - WIC - BREASTFEEDING 0 0.00 43,401 38,215.92 36,157 8,503.85 3.15 5154 - WIC - PEER BREASTFEEDING 0 0.00 73,647 59,881.45 72,604 10,024.89 8.79 5160 - CMARC 0 0.00 371,875 335,212.47 357,219 65,199.80 20,184.92 5161 - CMARC - STATE 0 0.00 45,033 45,024.50 49,414 9,854.77 0.00 5162 - CMHRP 0 0.00 781,013 313,625.40 391,933 66,113.57 4,477.71 5170 - BIOTERRORISM 0 0.00 60,784 53,216.80 62,353 10,242.53 3,652.75 5180 - ENVIRONMENTAL SERVICES 0 0.00 1,525,283 1,358,455.02 1,404,095 283,269.59 34,104.12 5190 - HEALTH DEPARTMENT GRANTS 0 0.00 1,919,424 654,166.12 710,448 6,532.20 33,821.43 5210 - MENTAL HEALTH 605,679 605,679.00 605,679 605,678.17 609,673 304,836.00 151,417.75 5260 - HEALTH - SENIOR SERVICES 1,726,073 1,498,416.92 1,880,207 1,532,420.78 1,741,283 293,794.70 297,622.78 5310 - DSS - ADMINISTRATION 2,398,802 2,245,120.78 2,941,166 2,794,604.11 3,559,841 834,199.35 791,119.64 5311 - DSS - FRAUD PREVENTION 386,647 381,047.15 421,935 419,664.62 450,236 86,694.90 86,295.13 5320 - DSS - ADULT SERVICES 1,156,996 1,108,910.38 1,271,699 1,217,479.51 1,338,691 264,870.74 246,495.70 5321 - DSS - WORKFIRST 378,702 320,704.29 396,816 373,131.55 415,868 84,515.89 74,960.35 5322 - DSS - ENERGY PROGRAMS 1,636,534 860,566.17 1,557,687 284,774.54 401,281 33,718.06 82,280.94 5330 - DSS - CHILD CARE SUBSIDY 459,647 456,670.30 486,115 474,729.32 511,098 100,611.11 98,881.02 5331 - DSS - CHILD PROTECTIVE SRVCS 2,330,626 2,089,094.95 2,480,613 2,321,403.62 2,586,132 521,912.66 477,609.29 5332 - DSS - FOSTER CARE 3,993,959 3,880,305.23 6,361,621 5,159,177.19 6,426,693 1,007,472.74 869,781.96 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 582,865.04 482,196.43 General Fund 110 3 of 37 09.2024 Monthly Master Expense Function Department Budget Actual Budget Actual Budget Actual FY 2024 Same Period Last Year FY 2023 FY 2025 5352 - DSS - FAMILY & CHLDRN MEDICAID 1,791,823 1,688,979.80 2,016,885 1,931,151.58 2,780,244 487,033.22 348,854.43 5353 - DSS - MEDICAID TRANSPORTATION 258,360 223,756.60 275,609 216,570.94 260,744 44,667.18 47,712.72 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 97,512.72 73,234.27 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,306,972 7,067,137.27 6,398,381.97 70 - EDUCATION 5910 - BOARD OF EDUCATION 26,121,589 26,121,589.00 28,301,509 28,301,509.00 30,804,606 7,701,151.50 7,030,452.28 5920 - CCCC 1,752,605 1,557,732.28 1,818,075 1,636,093.93 1,818,075 479,358.32 359,518.74 70 - EDUCATION Total 27,874,194 27,679,321.28 30,119,584 29,937,602.93 32,622,681 8,180,509.82 7,389,971.02 80 - CULTURAL & RECREATION 6110 - PARKS & RECREATION 1,752,797 1,504,187.17 1,945,628 1,836,627.94 2,167,462 617,879.94 498,524.53 6170 - MAIN LIBRARY 2,040,861 1,736,352.80 2,236,929 2,047,113.44 2,467,025 529,357.03 424,978.01 6172 - ANGIER BRANCH LIBRARY 253,527 211,733.68 278,867 264,042.58 303,057 59,462.39 51,415.47 6173 - BENHAVEN BRANCH LIBRARY 0 0.00 191,243 121,440.34 224,719 38,880.74 3,656.17 6175 - COATS BRANCH LIBRARY 151,658 122,622.63 172,056 159,036.07 187,073 36,897.88 34,381.73 6176 - DUNN BRANCH LIBRARY 278,839 242,816.32 341,711 321,304.52 352,080 70,436.47 53,692.65 6177 - ERWIN BRANCH LIBRARY 156,084 132,742.84 179,104 152,479.21 187,901 36,763.25 35,155.04 6199 - CULTURAL & REC APPROP 260,553 260,466.04 307,241 157,241.00 307,229 0.00 0.00 80 - CULTURAL & RECREATION Total 4,894,319 4,210,921.48 5,652,779 5,059,285.10 6,196,546 1,389,677.70 1,101,803.60 110 - GENERAL FUND EXPENSE 171,205,638 $152,210,101.12 169,027,373 $157,892,794.31 178,174,263 $33,537,077.85 $29,821,191.26 110 - GENERAL FUND REVENUE (OVER) / UNDER EXPENSES 0 $9,566,888.07 0 $3,497,574.34 0 $15,236,680.92 $13,945,990.24 General Fund 110 4 of 37 09.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,469,989.12 August $30,766,642.59 $27,193,882.75 $50,916,962.51 $60,497,443.11 $67,988,774.47 September $31,436,740.68 $28,797,031.28 $53,275,613.95 $62,210,399.86 $67,784,966.78 October $32,621,237.60 $29,562,531.87 $53,221,696.77 $61,191,258.32 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 September 30, 2024 General Fund Cash 5 of 37 09.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 196,245.24 169,335.86 38 - MISCELLANEOUS INCOME 74,329 88,846.99 45,000 48,185.06 48,500 7,450.00 8,950.00 39 - NON-REVENUE RECEIPTS 0 0.00 2,500,000 1,860,060.01 0 0.00 0.00 120 - HR JETPORT FUND REVENUE 1,242,706 $998,234.05 3,819,808 $2,734,027.38 1,355,209 $203,695.24 $178,285.86 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 $55,848.25 45,621.13 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 $149,572.62 54,556.13 53 - CURRENT SRVCS 84,113 $46,912.48 63,208 $51,167.06 55,738 $13,363.15 9,212.31 54 - FIXED CHARGES 58,347 $50,298.73 51,042 $51,077.51 70,276 $38,252.76 32,495.80 55 - CAPITAL OUTLAY 42,000 $41,301.00 2,500,000 $1,860,060.01 0 $0.00 0.00 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 $257,175.87 $141,885.37 120 - HR JETPORT FUND REVENUE (OVER) / UNDER EXPENSES 0 $51,151.86 0 $147,597.73 0 $53,480.63 $36,400.49 FY 2024 FY 2024 Harnett Regional Jetport Fund Unaudited as of September 30, 2024 Same Period Last Year FY 2025 FY 2025FY 2023 FY 2023 Same Period Last Year HRJetport Fund 120 6 of 37 09.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) 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 September 30, 2024 HRJetport Fund Cash 7 of 37 09.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 November $0.00 $47,552.93 $29,640.04 $60,956.54 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 September 30, 2024 HRJetport Fund Inventory 8 of 37 09.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 0 0.00 0.00 35 - SERVICE CHARGES 0 880,075.62 0 1,182,786.74 0 203,403.36 302,224.04 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 0 0.00 0.00 292 - ARPA FUND REVENUE 10,015,000 $7,881,572.71 5,276,608 $6,030,703.39 0 $203,403.36 $302,224.04 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 0 $0.00 $0.00 292 - ARPA FUND EXPENSE 10,015,000 $7,001,498.09 5,276,608 $4,847,916.65 0 $0.00 $0.00 292 - ARPA FUND REVENUE (OVER) / UNDER EXPENSES 0 $880,074.62 0 $1,182,786.74 0 $203,403.36 $302,224.04 Same Period Last Year FY 2025 Same Period Last Year American Rescue Plan Act Fund Unaudited as of September 30, 2024 FY 2023 FY 2023 FY 2024 FY 2024 FY 2025 ARPA Fund 292 9 of 37 09.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 126,285.23 267,663.40 36 - ENTERPRISE CHARGES 1,761,500 2,477,357.11 2,113,000 2,448,342.41 2,418,000 615,343.03 600,523.70 37 - FACILITY FEES 37,564,650 41,935,719.04 40,635,000 47,630,098.56 43,600,000 13,484,526.20 12,654,812.75 38 - MISCELLANEOUS INCOME 320,000 761,792.20 340,000 16,810,585.32 340,000 128,222.77 5,025,186.93 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 $14,354,377.23 $18,548,186.78 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,578,719 1,572,369.85 1,149,674.88 7113 - WATER TREATMENT PLANT 8,435,629 7,994,486.61 9,504,517 8,719,770.70 10,993,000 2,204,734.87 2,367,697.25 7115 - WASTEWATER TREATMENT PLANT 3,583,141 3,157,253.44 4,179,100 3,593,743.89 4,285,441 710,847.78 626,360.78 7117 - SOUTH HARNETT WASTEWATER PLANT 3,737,799 3,169,127.62 4,218,793 3,449,519.34 4,591,883 739,773.21 550,771.90 7119 - WATER DISTRIBUTION 6,396,571 5,348,263.00 7,439,204 6,000,175.87 7,051,813 1,484,629.43 1,596,503.19 7121 - SEWER COLLECTIONS 5,697,048 5,072,871.48 6,002,962 4,843,044.44 6,217,911 813,713.07 865,073.34 7131 - RETIREE INSURANCE HRW 63,829 64,280.10 75,824 57,113.44 55,426 15,043.00 13,846.40 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 $7,541,111.21 $7,169,927.74 610 - HRW FUND REVENUE (OVER) / UNDER EXPENSES 0 $32,172,278.17 0 $30,371,052.22 0 $6,813,266.02 $11,378,259.04 FY 2024 FY 2024FY 2023 Same Period Last Year Same Period Last Year Harnett Regional Water Fund Unaudited as of September 30, 2024 FY 2025 FY 2025 FY 2023 HRW Fund 610 10 of 37 09.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 $60,803,145.53 August $57,887,471.15 $53,478,105.50 $71,395,812.59 $49,668,609.87 $62,301,186.47 September $53,052,496.69 $54,740,839.35 $72,918,273.72 $51,309,490.06 $64,183,138.78 October $41,972,645.61 $57,802,598.49 $74,956,217.38 $53,345,216.44 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 September 30, 2024 HRW Fund Cash 11 of 37 09.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 49,587.81 1,260.99 36 - ENTERPRISE CHARGES 3,414,080 3,525,625.02 4,122,082 3,472,431.85 3,512,000 895,454.59 658,377.97 37 - FACILITY FEES 4,520,000 4,824,835.93 4,822,000 4,919,568.05 4,822,000 660,230.84 523,419.32 38 - MISCELLANEOUS INCOME 251,981 166,073.65 185,000 2,428,484.73 185,000 68,683.35 23,648.72 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 $1,673,956.59 $1,206,707.00 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 1,455,432.54 1,251,077.81 7431 - RETIREE INSURANCE SW 20,000 26,509.00 29,712 23,993.00 19,356 3,985.00 6,260.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 $1,459,417.54 $1,257,337.81 660 - SOLID WASTE FUND REVENUE (OVER) / UNDER EXPENSES 0 $1,626,466.06 0 $2,113,313.54 0 $214,539.05 $50,630.81 FY 2024 FY 2024FY 2023 Solid Waste Fund Unaudited as of September 30, 2024 Same Period Last Year FY 2025 FY 2025FY 2023 Same Period Last Year Solid Waste Fund 660 12 of 37 09.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,328,989.45 August $3,375,944.64 $4,647,598.39 $5,341,058.08 $6,031,473.51 $6,555,046.56 September $3,607,274.52 $4,882,131.66 $5,547,560.45 $6,165,598.96 $6,494,285.92 October $3,759,678.53 $5,029,336.00 $5,661,414.55 $6,206,732.64 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 September 30, 2024 Solid Waste Fund Cash 13 of 37 09.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 153,776.79 145,209.32 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 $153,776.79 $145,209.32 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 $729,333.90 369,011.31 810 - WORKER'S COMP FUND EXPENSE 850,000 $854,566.54 850,000 $516,873.53 850,000 $729,333.90 $369,011.31 810 - WORKERS'S COMP FUND REVENUE (OVER) / UNDER EXPENSES 0 $294,998.90 0 $26,678.20 0 $575,557.11 $223,801.99 Worker's Compensation Fund Unaudited as of September 30, 2024 FY 2024 FY 2024FY 2023 FY 2025 FY 2025 FY 2023 Same Period Last Year Same Period Last Year Worker's Comp Fund 810 14 of 37 09.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 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 September 30, 2024 Worker's Comp Fund Cash 15 of 37 09.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 20,378.26 34,108.14 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 $20,378.26 $34,108.14 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 $20,378.26 $34,108.14 FY 2024 FY 2024FY 2023 Unemployment Insurance Fund Unaudited as of September 30, 2024 FY 2025 FY 2025 FY 2023 Same Period Last Year Same Period Last Year Unemployment Ins Fund 820 16 of 37 09.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 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 September 30, 2024 Unemployment Ins Fund Cash 17 of 37 09.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 42,240.00 39,255.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 Grand Total 191,875 154,380.00 228,762 186,444.79 229,901 42,240.00 39,255.59 830 - EMPLOYEE CLINIC FUND REVENUE 191,875 $154,380.00 228,762 $186,444.79 229,901 $42,240.00 $39,255.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 37,923.10 34,228.43 830 - EMPLOYEE CLINIC FUND EXPENSE 191,875 $178,079.32 228,762 $195,365.09 229,901 $37,923.10 $34,228.43 830 - EMPLOYEE CLINIC FUND REVENUE (OVER) / UNDER EXPENSES 0 $23,699.32 0 $8,920.30 0 $4,316.90 $5,027.16 Employee Clinic Fund Unaudited as of September 30, 2024 FY 2025 FY 2025FY 2023 Same Period Last Year Same Period Last Year FY 2023 FY 2024 FY 2024 Employee Clinic Fund 830 18 of 37 09.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 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 September 30, 2024 Employee Clinic Fund Cash 19 of 37 09.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 3,017,204.79 2,764,981.45 38 - MISCELLANEOUS INCOME 650,000 1,261,002.15 0 1,449,859.89 0 64,614.51 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 $3,081,819.30 $2,877,589.26 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 3,406,273.23 2,685,061.71 841 - MEDICAL SELF INS FUND EXPENSE 12,226,500 $10,662,369.55 12,486,500 $12,466,348.43 13,503,500 $3,406,273.23 $2,685,061.71 841 - MEDICAL SELF INS FUND REVENUE (OVER) / UNDER EXPENSES 0 $1,696,248.51 0 $478,928.30 0 $324,453.93 $192,527.55 FY 2024 FY 2024FY 2023 Medical Self Insurance Fund Unaudited as of September 30, 2024 Same Period Last Year Same Period Last Year FY 2023 FY 2025 FY 2025 Medical Self Ins Fund 841 20 of 37 09.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 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 September 30, 2024 Medical Self Ins Fund Cash 21 of 37 09.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 131,041.06 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 $131,041.06 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 130,787.81 136,055.61 843 - DENTAL SELF INS FUND EXPENSE 650,000 $459,020.75 650,000 $461,934.46 650,000 $130,787.81 $136,055.61 843 - DENTAL SELF INS FUND REVENUE (OVER) / UNDER EXPENSES 0 $60,512.85 0 $108,975.45 0 $6,728.25 $5,014.55 FY 2024 FY 2024 Dental Self Insurance Fund Unaudited as of September 30, 2024 FY 2025FY 2023 Same Period Last Year Same Period Last Year FY 2025FY 2023 Dental Self Ins Fund 843 22 of 37 09.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 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 September 30, 2024 Dental Self Ins Fund Cash 23 of 37 09.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 110,833.06 112,683.58 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 $110,833.06 $112,683.58 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 284,782.90 282,108.21 845 - RETIREE SELF INS FUND EXPENSE 1,500,000 $1,357,594.41 1,500,000 $1,006,284.77 1,500,000 $284,782.90 $282,108.21 845 - RETIREE SELF INS FUND REVENUE (OVER) / UNDER EXPENSES 0 $51,932.21 0 $297,450.14 0 $173,949.84 $169,424.63 Retiree Self Insurance Fund Unaudited as of September 30, 2024 FY 2024 FY 2024 FY 2025 FY 2025 FY 2023 FY 2023 Same Period Last Year Same Period Last Year Retiree Self Ins Fund 845 24 of 37 09.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 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 September 30, 2024 Retiree Self Ins Fund Cash 25 of 37 09.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 43,476.00 38 - MISCELLANEOUS INCOME 12,000 16,269.51 22,360 22,360.00 12,000 19,091.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 $19,091.00 $54,376.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 304,561.15 264,762.75 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 $304,561.15 $264,762.75 880 - FLEET SERVICES FUND REVENUE (OVER) / UNDER EXPENSES 0 $78,891.11 0 $91,767.48 0 $285,470.15 $210,386.75 Fleet Services Fund Unaudited as of September 30, 2024 FY 2024 FY 2024 FY 2025 FY 2025 FY 2023 FY 2023 Same Period Last Year Same Period Last Year Fleet Services Fund 880 26 of 37 09.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 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 September 30, 2024 Fleet Services Fund Cash 27 of 37 09.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 275,075.45 419,604.43 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 $275,208.16 $419,767.05 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,112,376.33 586,566.69 890 - INFO TECHNOLOGY FUND EXPENSE 3,795,219 $2,647,317.05 2,123,660 $1,928,442.68 3,434,960 $1,112,376.33 $586,566.69 890 - INFO TECHNOLOGY FUND REVENUE (OVER) / UNDER EXPENSES 0 $1,028,501.08 0 $588,433.62 0 $837,168.17 $166,799.64 Information Technology Fund Unaudited as of September 30, 2024 FY 2024 FY 2024 FY 2025 FY 2025FY 2023 FY 2023 Same Period Last Year Same Period Last Year Info Technology Fund 890 28 of 37 09.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 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 September 30, 2024 Info Technology Fund Cash 29 of 37 09.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 0.00 0.00 38 - MISCELLANEOUS INCOME 73,000 28,254.50 68,250 15,570.81 50,000 0.00 0.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 $0.00 $0.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 71,596.33 66,910.52 250 - VET TREATMENT COURT EXPENSE 1,152,896 $435,225.61 1,851,304 $359,985.64 276,492 $71,596.33 $66,910.52 250 - VET TREATMENT COURT REVENUE (OVER) / UNDER EXPENSES 0 $48,465.05 0 $199,146.36 0 $71,596.33 $66,910.52 FY 2024 FY 2024 Veteran's Treatment Court Unaudited as of September 30, 2024 FY 2025FY 2023 Same Period Last Year Same Period Last Year FY 2025FY 2023 Veteran's Treatment Court 250 30 of 37 09.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 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 September 30, 2024 Veteran's Treatment Court Cash 31 of 37 09.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(9 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% 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 32 of 37 09.2024 Monthly Master HARNETT COUNTY FINANCIAL SUMMARY REPORT 10/22/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 09.2024 Monthly Master HARNETT COUNTY FINANCIAL SUMMARY REPORT 10/22/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 09.2024 Monthly Master HARNETT COUNTY FINANCIAL SUMMARY REPORT 10/22/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 09.2024 Monthly Master HARNETT COUNTY FINANCIAL SUMMARY REPORT 10/22/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 09.2024 Monthly Master HARNETT COUNTY FINANCIAL SUMMARY REPORT 10/22/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 09.2024 Monthly Master