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 AboutAugust 2024 Financial Report Monthly Financial Reports August 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 5,622,658.54 2,426,216.25 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 293,899.32 289,246.88 33 - RESTRICTED REVENUE 23,410,407 23,850,972.56 23,773,916 21,152,756.95 22,492,294 904,529.52 972,815.43 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 2,582,999.97 3,889,119.60 36 - ENTERPRISE CHARGES 0 4,392.51 0 6,325.96 0 746.70 0.00 37 - FACILITY FEES 0 2,783.82 0 3,487.26 0 0.00 689.09 38 - MISCELLANEOUS INCOME 2,109,210 2,487,949.62 820,092 302,645.92 948,847 87,490.23 1,283,664.32 39 - NON-REVENUE RECEIPTS 27,735,817 1,274,238.00 12,468,816 164,375.00 12,276,105 0.00 0.00 110 - GENERAL FUND REVENUE 171,205,638 $161,776,989.19 169,027,373 $161,390,368.65 177,850,368 $9,492,324.28 $6,294,422.93 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 100,802.46 88,866.30 4120 - COUNTY ADMINISTRATION 1,160,594 1,060,696.45 1,406,990 1,371,737.43 1,469,637 215,860.56 177,156.52 4130 - FINANCE 1,619,365 1,533,443.87 1,910,725 1,894,440.46 1,989,322 193,982.74 190,128.80 4131 - RETIREE INSURANCE 944,351 919,464.87 930,000 929,999.03 956,573 99,854.01 104,481.16 4140 - TAX 1,999,758 1,714,142.62 2,076,484 2,038,840.72 2,343,796 222,399.20 174,079.03 4150 - LEGAL SERVICES 387,832 369,867.69 589,456 571,875.48 634,280 75,168.58 49,356.61 4160 - HUMAN RESOURCES 966,968 882,574.81 967,288 956,690.67 672,502 88,070.29 440,189.83 4161 - INSURANCE 0 0.00 0 0.00 336,230 20,240.00 0.00 4170 - BOARD OF ELECTIONS 577,506 562,798.02 875,726 802,482.70 801,696 78,907.88 66,806.62 4180 - CLERK OF COURT 28,233 17,713.99 51,810 45,359.68 53,815 7,233.93 6,409.00 4190 - REGISTER OF DEEDS 810,075 771,787.47 903,433 896,393.98 964,136 173,893.10 99,613.52 4210 - GENERAL SERVICES 255,027 252,022.15 272,931 272,763.64 296,962 34,176.46 32,404.53 4230 - FACILITIES MAINTENANCE 3,595,600 3,399,030.41 3,916,231 3,940,618.80 4,298,026 402,233.80 448,257.49 4250 - FLEET MAINTENANCE 907,315 841,138.04 1,120,753 1,108,538.90 1,111,197 138,098.18 109,802.85 4270 - INFORMATION TECHNOLOGY 2,736,780 2,617,423.22 2,850,044 2,838,039.08 2,125,815 223,201.94 460,638.47 4290 - GIS 846,687 810,806.18 1,005,874 999,473.46 1,087,118 207,007.50 215,062.20 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 2,281,130.63 2,663,252.93 FY 2024 FY 2024 General Fund Unaudited as of August 31, 2024 FY 2025 Same Period Last Year Same Period Last Year FY 2023 FY 2023 FY 2025 General Fund 110 1 of 37 08.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,061,335 2,041,852.21 1,763,003.95 4330 - CAMPBELL DEPUTIES 586,694 575,389.37 727,436 624,155.97 691,536 75,225.00 67,682.79 4350 - SCHOOL RESOURCE OFFICER 2,147,192 1,580,281.44 2,480,674 2,057,966.99 2,835,855 187,024.88 182,170.52 4370 - CHILD SUPPORT ENFORCEMENT 98,087 96,248.57 110,767 104,587.47 107,988 12,454.00 12,276.83 4390 - JAIL 7,546,385 6,768,434.38 8,146,079 7,656,019.93 8,047,349 797,166.41 890,933.68 4410 - EMERGENCY MANAGEMENT 1,187,136 1,127,582.44 1,314,553 1,303,274.39 1,620,022 151,122.19 180,105.91 4411 - EMERGENCY SERVICES GRANTS 442,695 250,499.57 374,520 272,654.20 242,502 38,945.99 5,809.05 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 895,356.68 765,361.50 4510 - FIELD SERVICES 423,264 398,306.11 465,803 440,958.26 583,542 50,678.17 57,818.31 4512 - ANIMAL SHELTER 442,446 366,985.54 554,249 488,399.22 599,458 43,036.40 51,068.30 4530 - MEDICAL EXAMINER 100,000 82,400.00 100,000 67,545.90 100,000 10,550.00 0.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 159,374.19 146,939.64 10 - PUBLIC SAFETY Total 47,369,756 43,149,365.11 50,324,414 48,266,396.74 55,370,414 6,264,746.01 5,812,617.31 20 - TRANSPORTATION 4610 - TRANSPORTATION 1,493,881 1,040,368.09 1,576,325 1,320,124.60 1,875,856 151,694.57 142,150.38 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 195,708.21 173,453.83 30 - ENVIRONMENTAL PROTECTION 4710 - SOIL & WATER 309,461 295,848.31 339,110 328,969.13 365,978 41,989.16 40,199.25 4730 - FORESTRY PROGRAM 152,709 132,587.79 164,599 151,180.07 149,122 0.00 12,122.45 4750 - ENVIROMENTAL PROT ALLOC 12,000 11,900.00 12,000 11,900.00 12,000 0.00 0.00 30 - ENVIRONMENTAL PROTECTION Total 474,170 440,336.10 515,709 492,049.20 527,100 41,989.16 52,321.70 40 - ECONOMIC & PHYSICAL DEVELOPMNT 4910 - DEVELOPMENT SERVICES 1,119,722 1,033,858.20 1,252,686 1,184,125.19 1,464,512 203,747.03 190,210.43 4930 - ECONOMIC DEVELOPMENT 1,111,354 883,701.25 1,038,781 1,008,995.31 1,177,107 165,623.51 127,089.44 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 580.21 0.00 4971 - WIOA - ADULT 0 0.00 102,365 97,736.86 33,036 11,973.26 0.00 4973 - WIAO - NC WORKS CAREER CENTER 0 0.00 78,353 76,863.24 15,391 12,121.10 0.00 4975 - WIOA - DISLOCATED WORKER 0 0.00 57,292 57,086.71 19,161 6,807.64 0.00 4978 - WIOA - YOUTH - IN 0 0.00 34,283 34,201.47 11,412 6,606.32 0.00 4979 - WIOA - YOUTH - OUT 0 0.00 102,867 100,899.76 33,834 23,280.26 0.00 4990 - COOPERATIVE EXTENSION 443,332 402,432.61 459,580 396,348.23 508,465 36,472.38 57,512.89 4995 - COOPERATIVE EXT SPECIAL PROG 158,799 125,770.09 123,638 101,761.52 63,775 5,579.30 15,130.61 40 - ECONOMIC & PHYSICAL DEVELOPMNT Total 2,833,664 2,445,941.02 3,295,554 3,079,713.95 3,882,638 472,794.97 389,945.98 50 - HUMAN SERVICES 5110 - GENERAL ADMINISTRATION 9,637,937 7,349,865.69 269,764 236,698.78 523,711 84,448.34 758,781.44 5112 - VITAL RECORDS 0 0.00 28,215 27,310.61 29,625 3,525.61 2.52 5114 - AGING 0 0.00 105,919 95,122.53 86,858 12,416.62 0.00 5118 - LABORATORY SERVICES 0 0.00 312,717 274,791.38 321,694 32,397.96 10,966.51 General Fund 110 2 of 37 08.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 135,793.36 23,847.54 5121 - IMMUNIZATION ACTION PLAN 0 0.00 97,163 65,191.17 73,571 3,970.40 88.48 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 0.00 0.00 5130 - ADULT HEALTH 0 0.00 256,177 226,480.21 227,881 52,512.28 19,614.02 5131 - SEXUALLY TRANSMITTED DISEASE 0 0.00 277,218 237,488.12 357,078 26,123.05 2,174.83 5134 - MATERNAL HEALTH 0 0.00 586,715 538,216.41 605,192 68,290.12 8,150.28 5135 - FAMILY PLANNING 0 0.00 576,156 548,420.49 523,190 70,244.56 10,260.89 5137 - TUBERCULOSIS PROGRAM 0 0.00 67,620 62,105.69 73,222 5,822.86 2,680.05 5138 - COMMUNICABLE DISEASES 0 0.00 77,717 72,534.17 124,027 11,241.67 97.50 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 11,826.27 865.68 5142 - CHILD FATALITY PREVENTION TEAM 0 0.00 7,625 3,293.66 8,064 192.50 0.00 5144 - HIV-STD COUNTY 0 0.00 22,904 19,528.32 23,873 1,162.96 82.00 5145 - HEALTH PROMOTION 0 0.00 82,393 79,431.17 85,991 8,537.92 168.73 5146 - HEALTHY COMMUNITIES 0 0.00 50,186 42,936.46 51,750 3,675.79 0.00 5148 - ITTS 0 0.00 55,484 55,051.06 57,915 6,076.82 43.23 5149 - MOBILE HEALTH PROGRAM 0 0.00 0 0.00 15,658 0.00 0.00 5150 - WIC - ADMINISTRATION 0 0.00 70,695 66,801.57 74,197 5,322.99 17.06 5151 - WIC - CLIENT SERVICES 0 0.00 614,554 570,918.38 549,947 60,931.73 3,780.05 5152 - WIC - NUTRITION EDUCATION 0 0.00 166,801 150,390.07 144,129 17,094.69 0.00 5153 - WIC - BREASTFEEDING 0 0.00 43,401 38,215.92 36,157 5,394.84 3.15 5154 - WIC - PEER BREASTFEEDING 0 0.00 73,647 59,881.45 72,604 5,381.46 7.53 5160 - CMARC 0 0.00 371,875 335,212.47 357,219 39,751.46 9,969.52 5161 - CMARC - STATE 0 0.00 45,033 45,024.50 49,414 5,938.64 0.00 5162 - CMHRP 0 0.00 781,013 313,625.40 391,933 40,755.90 2,341.03 5170 - BIOTERRORISM 0 0.00 60,784 53,216.80 62,353 5,257.78 1,499.25 5180 - ENVIRONMENTAL SERVICES 0 0.00 1,525,283 1,358,455.02 1,404,095 157,133.34 23,986.81 5190 - HEALTH DEPARTMENT GRANTS 0 0.00 1,919,424 654,166.12 648,448 24.59 4,056.00 5210 - MENTAL HEALTH 605,679 605,679.00 605,679 605,678.17 609,673 152,418.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 182,473.50 154,742.13 5310 - DSS - ADMINISTRATION 2,398,802 2,245,120.78 2,941,166 2,794,604.11 3,559,841 599,674.27 621,055.53 5311 - DSS - FRAUD PREVENTION 386,647 381,047.15 421,935 419,664.62 450,236 52,455.34 50,919.61 5320 - DSS - ADULT SERVICES 1,156,996 1,108,910.38 1,271,699 1,217,479.51 1,338,691 157,912.00 146,036.55 5321 - DSS - WORKFIRST 378,702 320,704.29 396,816 373,131.55 415,868 52,404.86 44,522.66 5322 - DSS - ENERGY PROGRAMS 1,636,534 860,566.17 1,557,687 284,774.54 401,281 14,785.64 9,694.13 5330 - DSS - CHILD CARE SUBSIDY 459,647 456,670.30 486,115 474,729.32 511,098 60,191.94 59,202.96 5331 - DSS - CHILD PROTECTIVE SRVCS 2,330,626 2,089,094.95 2,480,613 2,321,403.62 2,586,132 310,487.25 282,810.26 5332 - DSS - FOSTER CARE 3,993,959 3,880,305.23 6,361,621 5,159,177.19 6,426,693 578,243.78 472,930.65 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 356,628.44 296,137.68 General Fund 110 3 of 37 08.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 290,473.43 202,762.43 5353 - DSS - MEDICAID TRANSPORTATION 258,360 223,756.60 275,609 216,570.94 260,744 31,717.44 27,926.65 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 55,153.16 43,157.74 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,233,077 4,298,427.32 3,923,663.19 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 359,518.74 239,679.16 70 - EDUCATION Total 27,874,194 27,679,321.28 30,119,584 29,937,602.93 32,622,681 8,060,670.24 7,270,131.44 80 - CULTURAL & RECREATION 6110 - PARKS & RECREATION 1,752,797 1,504,187.17 1,945,628 1,836,627.94 2,167,462 452,104.26 379,527.80 6170 - MAIN LIBRARY 2,040,861 1,736,352.80 2,236,929 2,047,113.44 2,467,025 310,015.98 271,892.11 6172 - ANGIER BRANCH LIBRARY 253,527 211,733.68 278,867 264,042.58 303,057 33,793.37 29,070.19 6173 - BENHAVEN BRANCH LIBRARY 0 0.00 191,243 121,440.34 224,719 22,133.20 1,832.00 6175 - COATS BRANCH LIBRARY 151,658 122,622.63 172,056 159,036.07 187,073 22,780.81 20,904.43 6176 - DUNN BRANCH LIBRARY 278,839 242,816.32 341,711 321,304.52 352,080 42,924.46 30,800.39 6177 - ERWIN BRANCH LIBRARY 156,084 132,742.84 179,104 152,479.21 187,901 22,052.87 21,500.15 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 905,804.95 755,527.07 110 - GENERAL FUND EXPENSE 171,205,638 $152,210,101.12 169,027,373 $157,892,794.31 177,850,368 $22,521,271.49 $21,040,913.45 110 - GENERAL FUND REVENUE (OVER) / UNDER EXPENSES 0 $9,566,888.07 0 $3,497,574.34 0 $13,028,947.21 $14,746,490.52 General Fund 110 4 of 37 08.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 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 August 31, 2024 General Fund Cash 5 of 37 08.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 120,736.31 117,126.44 38 - MISCELLANEOUS INCOME 74,329 88,846.99 45,000 48,185.06 48,500 3,150.00 6,625.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 $123,886.31 $123,751.44 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 $30,939.68 26,730.44 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 $115,799.48 77,897.10 53 - CURRENT SRVCS 84,113 $46,912.48 63,208 $51,167.06 55,738 $6,850.80 5,155.89 54 - FIXED CHARGES 58,347 $50,298.73 51,042 $51,077.51 70,276 $30,810.69 27,168.52 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 $184,539.74 $136,951.95 120 - HR JETPORT FUND REVENUE (OVER) / UNDER EXPENSES 0 $51,151.86 0 $147,597.73 0 $60,653.43 $13,200.51 FY 2024 FY 2024 Harnett Regional Jetport Fund Unaudited as of August 31, 2024 Same Period Last Year FY 2025 Same Period Last Year FY 2025FY 2023 FY 2023 HRJetport Fund 120 6 of 37 08.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) 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 August 31, 2024 HRJetport Fund Cash 7 of 37 08.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 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 August 31, 2024 HRJetport Fund Inventory 8 of 37 08.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 207,788.88 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 $207,788.88 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 $207,788.88 Same Period Last Year FY 2025 Same Period Last Year American Rescue Plan Act Fund Unaudited as of August 31, 2024 FY 2023 FY 2023 FY 2024 FY 2024 FY 2025 ARPA Fund 292 9 of 37 08.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 232,400.33 178,810.35 36 - ENTERPRISE CHARGES 1,761,500 2,477,357.11 2,113,000 2,448,342.41 2,418,000 413,348.11 401,825.45 37 - FACILITY FEES 37,564,650 41,935,719.04 40,635,000 47,630,098.56 43,600,000 9,189,343.04 8,556,443.27 38 - MISCELLANEOUS INCOME 320,000 761,792.20 340,000 16,810,585.32 340,000 96,784.12 3,583,364.67 39 - NON-REVENUE RECEIPTS 25,359,677 0.00 1,993,600 0.00 0 0.00 0.00 610 - HRW FUND REVENUE 65,015,827 $45,730,300.52 45,331,600 $68,186,141.76 47,108,000 $9,931,875.60 $12,720,443.74 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 701,955.22 745,709.80 7113 - WATER TREATMENT PLANT 8,435,629 7,994,486.61 9,504,517 8,719,770.70 10,993,000 1,218,442.63 1,317,317.35 7115 - WASTEWATER TREATMENT PLANT 3,583,141 3,157,253.44 4,179,100 3,593,743.89 4,285,441 307,444.59 412,933.65 7117 - SOUTH HARNETT WASTEWATER PLANT 3,737,799 3,169,127.62 4,218,793 3,449,519.34 4,591,883 382,423.31 348,226.68 7119 - WATER DISTRIBUTION 6,396,571 5,348,263.00 7,439,204 6,000,175.87 7,051,813 817,450.85 919,866.33 7121 - SEWER COLLECTIONS 5,697,048 5,072,871.48 6,002,962 4,843,044.44 6,217,911 513,032.15 522,294.69 7131 - RETIREE INSURANCE HRW 63,829 64,280.10 75,824 57,113.44 55,426 8,827.00 8,307.84 9990 - NON-DEPARTMENTAL 30,847,973 48,202,047.68 5,099,661 $5,099,661.00 4,333,807 $0.00 0.00 610 - HRW FUND EXPENSE 65,015,827 $77,902,578.69 45,331,600 $37,815,089.54 47,108,000 $3,949,575.75 $4,274,656.34 610 - HRW FUND REVENUE (OVER) / UNDER EXPENSES 0 $32,172,278.17 0 $30,371,052.22 0 $5,982,299.85 $8,445,787.40 FY 2024 FY 2024FY 2023 Same Period Last Year Same Period Last Year Harnett Regional Water Fund Unaudited as of August 31, 2024 FY 2025 FY 2025 FY 2023 HRW Fund 610 10 of 37 08.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 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 August 31, 2024 HRW Fund Cash 11 of 37 08.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 48,981.37 944.79 36 - ENTERPRISE CHARGES 3,414,080 3,525,625.02 4,122,082 3,472,431.85 3,512,000 613,812.06 475,105.19 37 - FACILITY FEES 4,520,000 4,824,835.93 4,822,000 4,919,568.05 4,822,000 372,298.16 147,371.51 38 - MISCELLANEOUS INCOME 251,981 166,073.65 185,000 2,428,484.73 185,000 60,251.98 17,016.22 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,095,343.57 $640,437.71 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 777,058.06 703,530.40 7431 - RETIREE INSURANCE SW 20,000 26,509.00 29,712 23,993.00 19,356 2,391.00 3,756.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 $779,449.06 $707,286.40 660 - SOLID WASTE FUND REVENUE (OVER) / UNDER EXPENSES 0 $1,626,466.06 0 $2,113,313.54 0 $315,894.51 $66,848.69 FY 2024 FY 2024FY 2023 Solid Waste Fund Unaudited as of August 31, 2024 Same Period Last Year FY 2025 FY 2025FY 2023 Same Period Last Year Solid Waste Fund 660 12 of 37 08.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 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 August 31, 2024 Solid Waste Fund Cash 13 of 37 08.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 101,487.30 94,530.50 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 $101,487.30 $94,530.50 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 $720,996.82 347,976.12 810 - WORKER'S COMP FUND EXPENSE 850,000 $854,566.54 850,000 $516,873.53 850,000 $720,996.82 $347,976.12 810 - WORKERS'S COMP FUND REVENUE (OVER) / UNDER EXPENSES 0 $294,998.90 0 $26,678.20 0 $619,509.52 $253,445.62 Worker's Compensation Fund Unaudited as of August 31, 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 08.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 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 August 31, 2024 Worker's Comp Fund Cash 15 of 37 08.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 13,469.85 22,251.45 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 $13,469.85 $22,251.45 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 $13,469.85 $22,251.45 FY 2024 FY 2024FY 2023 Unemployment Insurance Fund Unaudited as of August 31, 2024 FY 2025 FY 2025 FY 2023 Same Period Last Year Same Period Last Year Unemployment Ins Fund 820 16 of 37 08.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 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 August 31, 2024 Unemployment Ins Fund Cash 17 of 37 08.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 28,050.00 25,890.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 $28,050.00 $25,890.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 21,282.13 20,221.78 830 - EMPLOYEE CLINIC FUND EXPENSE 191,875 $178,079.32 228,762 $195,365.09 229,901 $21,282.13 $20,221.78 830 - EMPLOYEE CLINIC FUND REVENUE (OVER) / UNDER EXPENSES 0 $23,699.32 0 $8,920.30 0 $6,767.87 $5,668.81 Employee Clinic Fund Unaudited as of August 31, 2024 FY 2025FY 2023 Same Period Last Year Same Period Last Year FY 2025FY 2023 FY 2024 FY 2024 Employee Clinic Fund 830 18 of 37 08.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 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 August 31, 2024 Employee Clinic Fund Cash 19 of 37 08.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 2,005,943.82 1,828,829.30 38 - MISCELLANEOUS INCOME 650,000 1,261,002.15 0 1,449,859.89 0 61,758.44 14,810.00 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 $2,067,702.26 $1,843,639.30 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 2,151,327.55 1,660,798.88 841 - MEDICAL SELF INS FUND EXPENSE 12,226,500 $10,662,369.55 12,486,500 $12,466,348.43 13,503,500 $2,151,327.55 $1,660,798.88 841 - MEDICAL SELF INS FUND REVENUE (OVER) / UNDER EXPENSES 0 $1,696,248.51 0 $478,928.30 0 $83,625.29 $182,840.42 FY 2024 FY 2024FY 2023 Medical Self Insurance Fund Unaudited as of August 31, 2024 FY 2025 FY 2025 Same Period Last Year Same Period Last Year FY 2023 Medical Self Ins Fund 841 20 of 37 08.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 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 August 31, 2024 Medical Self Ins Fund Cash 21 of 37 08.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 91,487.50 87,120.33 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 $91,487.50 $87,120.33 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 92,962.29 89,222.47 843 - DENTAL SELF INS FUND EXPENSE 650,000 $459,020.75 650,000 $461,934.46 650,000 $92,962.29 $89,222.47 843 - DENTAL SELF INS FUND REVENUE (OVER) / UNDER EXPENSES 0 $60,512.85 0 $108,975.45 0 $1,474.79 $2,102.14 FY 2024 FY 2024 Dental Self Insurance Fund Unaudited as of August 31, 2024 FY 2023 Same Period Last Year Same Period Last Year FY 2025 FY 2025FY 2023 Dental Self Ins Fund 843 22 of 37 08.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 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 August 31, 2024 Dental Self Ins Fund Cash 23 of 37 08.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 74,042.86 75,512.68 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 $74,042.86 $75,512.68 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 222,495.17 206,065.83 845 - RETIREE SELF INS FUND EXPENSE 1,500,000 $1,357,594.41 1,500,000 $1,006,284.77 1,500,000 $222,495.17 $206,065.83 845 - RETIREE SELF INS FUND REVENUE (OVER) / UNDER EXPENSES 0 $51,932.21 0 $297,450.14 0 $148,452.31 $130,553.15 Retiree Self Insurance Fund Unaudited as of August 31, 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 08.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 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 August 31, 2024 Retiree Self Ins Fund Cash 25 of 37 08.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 28,984.00 38 - MISCELLANEOUS INCOME 12,000 16,269.51 22,360 22,360.00 12,000 11,239.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 $11,239.00 $39,884.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 98,000.00 239,732.45 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 $98,000.00 $239,732.45 880 - FLEET SERVICES FUND REVENUE (OVER) / UNDER EXPENSES 0 $78,891.11 0 $91,767.48 0 $86,761.00 $199,848.45 Fleet Services Fund Unaudited as of August 31, 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 08.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 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 August 31, 2024 Fleet Services Fund Cash 27 of 37 08.2024 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 1,748,415 0.00 0 471,493.44 0 0.00 162.62 38 - MISCELLANEOUS INCOME 0 1,601,809.13 1,773,310 1,695,382.86 3,434,960 4,435.06 282,551.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 $4,435.06 $282,714.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 976,319.84 521,165.35 890 - INFO TECHNOLOGY FUND EXPENSE 3,795,219 $2,647,317.05 2,123,660 $1,928,442.68 3,434,960 $976,319.84 $521,165.35 890 - INFO TECHNOLOGY FUND REVENUE (OVER) / UNDER EXPENSES 0 $1,028,501.08 0 $588,433.62 0 $971,884.78 $238,451.30 Information Technology Fund Unaudited as of August 31, 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 08.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 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 August 31, 2024 Info Technology Fund Cash 29 of 37 08.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 25,587.72 34,358.04 250 - VET TREATMENT COURT EXPENSE 1,152,896 $435,225.61 1,851,304 $359,985.64 276,492 $25,587.72 $34,358.04 250 - VET TREATMENT COURT REVENUE (OVER) / UNDER EXPENSES 0 $48,465.05 0 $199,146.36 0 $25,587.72 $34,358.04 FY 2024 FY 2024 Veteran's Treatment Court Unaudited as of August 31, 2024 FY 2025FY 2023 Same Period Last Year Same Period Last Year FY 2025FY 2023 Veteran's Treatment Court 250 30 of 37 08.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 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 August 31, 2024 Veteran's Treatment Court Cash 31 of 37 08.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 08.2024 Monthly Master HARNETT COUNTY FINANCIAL SUMMARY REPORT 10/23/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 08.2024 Monthly Master HARNETT COUNTY FINANCIAL SUMMARY REPORT 10/23/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 08.2024 Monthly Master HARNETT COUNTY FINANCIAL SUMMARY REPORT 10/23/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 08.2024 Monthly Master HARNETT COUNTY FINANCIAL SUMMARY REPORT 10/23/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 08.2024 Monthly Master HARNETT COUNTY FINANCIAL SUMMARY REPORT 10/23/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 08.2024 Monthly Master