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 AboutApril 2024 Financial Report Monthly Financial Reports April 2024 Table of Contents General Fund ................................................................................................ 1 Harnett Regional Jetport Fund ..................................................................... 6 American Rescue Plan Act Fund ................................................................. 10 Harnett Regional Water Fund .................................................................... 11 Solid Waste Fund ....................................................................................... 13 Worker’s Compensation Fund .................................................................... 15 Unemployment Insurance Fund ................................................................. 17 Employee Clinic Fund ................................................................................. 19 Medical Self Insurance Fund ...................................................................... 21 Dental Self Insurance Fund ........................................................................ 23 Retiree Self Insurance Fund ....................................................................... 25 Fleet Services Fund ..................................................................................... 27 Information Technology Fund .................................................................... 29 Veteran’s Treatment Court Fund .............................................................. 31 Monthly Sales Tax Analysis by Article ........................................................ 33 Harnett County Towns Summary ............................................................... 34 Revenue Category Budget Actual Budget Actual Budget Actual 30 - TAXES - AD VALOREM 72,701,330 73,671,143.88 77,645,000 79,931,250.14 81,560,000 80,502,576.92 77,017,819.22 31 - TAXES - SALES 22,300,000 26,539,012.42 21,416,000 28,878,720.90 26,561,800 17,103,549.53 16,788,803.97 32 - TAXES - OTHER 730,000 1,565,634.08 1,164,000 1,540,099.75 1,164,000 1,294,737.91 1,252,954.71 33 - RESTRICTED REVENUE 21,618,923 19,448,221.74 23,410,407 23,731,929.43 23,773,916 14,109,023.31 16,958,618.44 34 - RESTRICTED REVENUE 3,700,000 5,550,492.66 3,110,000 6,619,121.15 6,100,000 4,522,396.31 6,367,851.94 35 - SERVICE CHARGES 13,334,288 15,145,099.60 14,615,204 17,192,177.91 16,576,749 16,058,130.24 15,610,689.82 36 - ENTERPRISE CHARGES 1,600 2,927.17 0 4,392.51 0 6,145.24 4,167.71 37 - FACILITY FEES 0 0.00 0 2,783.82 0 2,896.26 0.00 38 - MISCELLANEOUS INCOME 1,737,467 1,716,483.93 2,109,210 2,487,949.62 793,992 438,010.25 1,780,970.90 39 - NON-REVENUE RECEIPTS 9,131,314 781,184.62 27,735,817 1,274,238.00 7,796,765 0.00 1,123,259.00 110 - GENERAL FUND REVENUE $145,254,922 $144,420,200.10 $171,205,638 $161,662,663.23 $164,327,222 $133,161,445.47 $136,905,135.71 Expense Function Department Budget Actual Budget Actual Budget Actual 110 - GENERAL 00 - GENERAL GOVERNMENT 4110 - GOVERNING BODY 1,097,890 700,681.26 918,415 846,695.96 667,930 426,878.38 657,254.47 4120 - COUNTY ADMINISTRATION 1,168,511 1,084,649.28 1,160,594 1,060,696.45 1,400,290 1,080,964.51 822,746.94 4130 - FINANCE 1,575,325 1,446,970.66 1,619,365 1,533,443.87 1,905,957 1,491,307.86 1,176,782.70 4131 - RETIREE INSURANCE 882,000 881,998.48 944,351 919,464.87 930,000 624,474.34 643,249.77 4140 - TAX 1,858,149 1,638,278.00 1,999,758 1,714,142.62 2,076,484 1,407,506.77 1,383,856.80 4150 - LEGAL SERVICES 348,564 335,989.02 387,832 369,867.69 589,456 410,547.63 289,706.32 4160 - HUMAN RESOURCES 812,570 765,241.54 966,968 882,574.81 967,288 830,063.93 756,576.27 4170 - BOARD OF ELECTIONS 611,967 486,986.66 577,506 562,798.02 875,726 575,933.53 494,871.58 4180 - CLERK OF COURT 22,283 15,003.96 28,233 17,713.99 51,810 38,449.86 16,588.20 4190 - REGISTER OF DEEDS 764,991 733,004.63 810,075 771,787.47 898,990 715,259.75 619,007.32 4210 - GENERAL SERVICES 243,609 238,037.30 255,027 252,022.15 272,931 217,151.16 201,243.73 4230 - FACILITIES MAINTENANCE 3,218,002 3,169,355.98 3,595,600 3,399,030.41 3,916,231 2,881,355.35 2,545,882.71 4250 - FLEET MAINTENANCE 780,677 777,916.82 907,315 841,138.04 1,082,252 821,965.16 654,305.25 4270 - INFORMATION TECHNOLOGY 2,545,738 2,522,795.76 2,736,780 2,617,423.22 2,849,914 2,191,711.43 2,139,373.32 4290 - GIS 793,447 725,435.75 846,687 810,806.18 998,871 792,712.23 653,796.60 9800 - INTERFUND TRANSFERS 18,418,352 18,418,352.00 33,106,322 27,336,394.00 13,345,286 749,058.00 18,067,822.00 9910 - CONTINGENCY 126,644 0.00 426,055 0.00 370,786 0.00 0.00 00 - GENERAL GOVERNMENT Total 35,268,719 33,940,697.10 51,286,883 43,935,999.75 33,200,202 15,255,339.89 31,123,063.98 10 - PUBLIC SAFETY 4310 - SHERIFF 13,182,650 12,698,552.66 14,093,457 13,505,215.48 15,794,222 11,838,695.56 10,390,517.56 FY 2022 FY 2022 General Fund Unaudited as of April 30, 2024 FY 2024 Same Period Last Year Same Period Last Year FY 2023 FY 2023 FY 2024 General Fund 110 1 of 38 04.2024 Monthly Master Expense Function Department Budget Actual Budget Actual Budget Actual FY 2022 Same Period Last Year FY 2023 FY 2024 4330 - CAMPBELL DEPUTIES 540,424 505,786.76 586,694 575,389.37 725,436 495,593.56 462,846.83 4350 - SCHOOL RESOURCE OFFICER 2,104,893 1,780,756.12 2,147,192 1,580,281.44 2,480,674 1,510,210.77 1,203,874.25 4370 - CHILD SUPPORT ENFORCEMENT 92,371 85,148.89 98,087 96,248.57 101,507 84,611.87 77,491.55 4390 - JAIL 6,871,307 6,274,841.72 7,546,385 6,768,434.38 8,084,024 5,383,267.56 5,150,111.90 4410 - EMERGENCY MANAGEMENT 1,072,232 1,024,568.72 1,187,136 1,127,582.44 1,294,553 1,010,952.51 901,387.26 4411 - EMERGENCY SERVICES GRANTS 109,718 81,595.82 442,695 250,499.57 374,520 118,002.06 249,924.79 4450 - EMERGENCY MEDICAL SERVICE 9,424,313 8,874,222.88 11,188,551 9,599,513.22 11,575,958 8,550,352.22 7,356,539.97 4470 - RESCUE DISTRICTS 3,783,630 3,749,400.37 5,792,107 5,792,106.70 4,592,173 3,789,193.67 4,707,367.64 4510 - FIELD SERVICES 370,958 320,814.44 423,264 398,306.11 465,803 335,629.43 302,546.16 4512 - ANIMAL SHELTER 357,920 238,345.89 442,446 366,985.54 553,863 328,735.41 276,401.55 4530 - MEDICAL EXAMINER 488,580 99,550.00 100,000 82,400.00 100,000 54,415.30 57,950.00 4570 - COMMUNICATIONS 2,038,639 1,754,234.23 2,169,081 1,960,240.72 2,548,281 2,055,451.73 1,419,022.40 4915 - INSPECTIONS 1,061,034 894,169.11 1,152,661 1,046,161.57 1,451,754 962,780.89 817,621.67 10 - PUBLIC SAFETY Total 41,498,669 38,381,987.61 47,369,756 43,149,365.11 50,142,768 36,517,892.54 33,373,603.53 20 - TRANSPORTATION 4610 - TRANSPORTATION 1,733,673 1,012,934.33 1,493,881 1,040,368.09 1,578,838 1,042,112.92 793,676.72 4630 - TRANSPORTATION - ADMIN 606,006 261,355.74 1,131,599 454,201.10 1,441,390 285,451.83 346,126.30 20 - TRANSPORTATION Total 2,339,679 1,274,290.07 2,625,480 1,494,569.19 3,020,228 1,327,564.75 1,139,803.02 30 - ENVIRONMENTAL PROTECTION 4710 - SOIL & WATER 261,378 254,800.08 309,461 295,848.31 339,110 260,675.79 232,805.70 4730 - FORESTRY PROGRAM 130,722 126,844.67 152,709 132,587.79 164,599 80,665.98 86,537.55 4750 - ENVIROMENTAL PROT ALLOC 12,000 11,000.00 12,000 11,900.00 12,000 11,900.00 11,900.00 30 - ENVIRONMENTAL PROTECTION Total 404,100 392,644.75 474,170 440,336.10 515,709 353,241.77 331,243.25 40 - ECONOMIC & PHYSICAL DEVELOPMNT 4910 - DEVELOPMENT SERVICES 995,192 983,246.49 1,119,722 1,033,858.20 1,245,575 947,692.71 818,769.50 4930 - ECONOMIC DEVELOPMENT 1,046,120 860,876.07 1,111,354 883,701.25 1,038,781 871,711.44 778,745.19 4950 - COMMUNITY DEVELOPMENT 455 82.59 457 178.87 10,709 370.99 76.29 4970 - HARNETT 0 0.00 0 0.00 35,000.00 5,340.64 0.00 4971 - WIOA - ADULT 0 0.00 0 0.00 102,365.00 85,256.56 0.00 4973 - WIAO - NC WORKS CAREER CENTER 0 0.00 0 0.00 78,353.00 68,146.34 0.00 4975 - WIOA - DISLOCATED WORKER 0 0.00 0 0.00 57,292.00 48,848.66 0.00 4978 - WIOA - YOUTH - IN 0 0.00 0 0.00 34,283.00 29,737.33 0.00 4979 - WIOA - YOUTH - OUT 0 0.00 0 0.00 102,867.00 80,369.05 0.00 4990 - COOPERATIVE EXTENSION 426,907 418,943.43 443,332 402,432.61 419,572 268,701.33 291,266.74 4995 - COOPERATIVE EXT SPECIAL PROG 135,332 105,558.83 158,799 125,770.09 123,638 83,756.12 90,775.51 40 - ECONOMIC & PHYSICAL DEVELOPMNT Total 2,604,006 2,368,707.41 2,833,664 2,445,941.02 3,248,435 2,489,931.17 1,979,633.23 50 - HUMAN SERVICES 5110 - GENERAL ADMINISTRATION 9,432,669 6,312,375.88 9,637,937 7,349,865.69 269,764 189,486.06 5,846,609.67 5112 - VITAL RECORDS 0 0.00 0 0.00 28,215 22,167.79 0.00 5114 - AGING 0 0.00 0 0.00 105,919 74,597.29 0.00 5118 - LABORATORY SERVICES 0 0.00 0 0.00 312,717 217,661.24 0.00 5120 - CHILD HEALTH 0 0.00 0 0.00 1,306,713 947,849.74 0.00 5121 - IMMUNIZATION ACTION PLAN 0 0.00 0 0.00 97,163 45,251.50 0.00 General Fund 110 2 of 38 04.2024 Monthly Master Expense Function Department Budget Actual Budget Actual Budget Actual FY 2022 Same Period Last Year FY 2023 FY 2024 5122 - LEAD 0 0.00 0 0.00 8,170 1,016.08 0.00 5124 - SCHOOL HEALTH NURSE 0 0.00 0 0.00 150,000 133,333.36 0.00 5130 - ADULT HEALTH 0 0.00 0 0.00 256,177 188,312.45 0.00 5131 - SEXUALLY TRANSMITTED DISEASE 0 0.00 0 0.00 277,218 179,313.22 0.00 5134 - MATERNAL HEALTH 0 0.00 0 0.00 586,715 405,010.91 0.00 5135 - FAMILY PLANNING 0 0.00 0 0.00 576,156 428,725.96 0.00 5137 - TUBERCULOSIS PROGRAM 0 0.00 0 0.00 67,620 45,021.80 0.00 5138 - COMMUNICABLE DISEASES 0 0.00 0 0.00 77,717 59,778.50 0.00 5139 - TANF 0 0.00 0 0.00 16,728 9,092.28 0.00 5140 - HEALTH EDUCATION 0 0.00 0 0.00 92,013 51,772.46 0.00 5142 - CHILD FATALITY PREVENTION TEAM 0 0.00 0 0.00 7,625 3,006.16 0.00 5144 - HIV-STD COUNTY 0 0.00 0 0.00 22,904 15,425.22 0.00 5145 - HEALTH PROMOTION 0 0.00 0 0.00 82,393 62,492.77 0.00 5146 - HEALTHY COMMUNITIES 0 0.00 0 0.00 50,186 35,158.75 0.00 5148 - ITTS 0 0.00 0 0.00 55,484 41,536.69 0.00 5149 - MOBILE HEALTH PROGRAM 0 0.00 0 0.00 0.00 0.00 0.00 5150 - WIC - ADMINISTRATION 0 0.00 0 0.00 70,695 53,933.99 0.00 5151 - WIC - CLIENT SERVICES 0 0.00 0 0.00 614,554 448,343.84 0.00 5152 - WIC - NUTRITION EDUCATION 0 0.00 0 0.00 166,801 117,366.59 0.00 5153 - WIC - BREASTFEEDING 0 0.00 0 0.00 43,401 29,976.57 0.00 5154 - WIC - PEER BREASTFEEDING 0 0.00 0 0.00 73,647 49,200.26 0.00 5160 - CMARC 0 0.00 0 0.00 371,875 267,648.99 0.00 5161 - CMARC - STATE 0 0.00 0 0.00 45,033 34,418.29 0.00 5162 - CMHRP 0 0.00 0 0.00 781,013 245,056.68 0.00 5170 - BIOTERRORISM 0 0.00 0 0.00 60,784 39,330.62 0.00 5180 - ENVIRONMENTAL SERVICES 0 0.00 0 0.00 1,525,283 1,088,873.97 0.00 5190 - HEALTH DEPARTMENT GRANTS 0 0.00 0 0.00 1,919,424 365,287.05 0.00 5210 - MENTAL HEALTH 605,679 605,679.00 605,679 605,679.00 605,679 605,678.17 605,679.00 5260 - HEALTH - SENIOR SERVICES 1,724,938 1,432,025.35 1,726,073 1,498,416.92 1,880,207 1,120,017.30 1,129,856.48 5310 - DSS - ADMINISTRATION 2,177,621 2,068,015.24 2,398,802 2,245,120.78 2,861,222 2,239,816.29 1,822,053.53 5311 - DSS - FRAUD PREVENTION 359,970 355,120.19 386,647 381,047.15 421,935 332,777.68 300,922.90 5320 - DSS - ADULT SERVICES 1,079,763 933,879.69 1,156,996 1,108,910.38 1,271,699 957,341.10 873,817.46 5321 - DSS - WORKFIRST 370,509 300,623.74 378,702 320,704.29 394,670 295,584.20 248,738.02 5322 - DSS - ENERGY PROGRAMS 2,472,707 2,054,900.57 1,636,534 860,566.17 1,557,687 238,348.43 806,620.80 5330 - DSS - CHILD CARE SUBSIDY 439,779 422,234.66 459,647 456,670.30 486,115 383,965.61 358,450.47 5331 - DSS - CHILD PROTECTIVE SRVCS 2,231,213 2,128,536.64 2,330,626 2,089,094.95 2,569,196 1,840,064.43 1,626,020.87 5332 - DSS - FOSTER CARE 3,053,187 2,898,902.18 3,993,959 3,880,305.23 6,361,621 3,945,347.09 2,650,468.10 5333 - DSS - ADOPTION 395,295 321,147.43 582,600 342,804.00 577,791 349,487.86 276,568.77 5340 - DSS - CHILD SUPPORT 1,559,968 1,427,942.69 1,600,976 1,486,178.39 1,687,575 1,210,143.82 1,124,919.01 5351 - DSS - ADULT MEDICAID 2,349,386 1,941,026.61 2,463,225 2,083,213.56 2,615,865 1,874,977.43 1,663,193.76 5352 - DSS - FAMILY & CHLDRN MEDICAID 1,754,283 1,557,853.10 1,791,823 1,688,979.80 2,016,885 1,465,363.47 1,324,066.44 5353 - DSS - MEDICAID TRANSPORTATION 224,629 204,783.19 258,360 223,756.60 275,609 183,972.58 175,574.99 General Fund 110 3 of 38 04.2024 Monthly Master Expense Function Department Budget Actual Budget Actual Budget Actual FY 2022 Same Period Last Year FY 2023 FY 2024 5354 - DSS - MEDICAID EXPANSION 0 0.00 0 0.00 111,416 111,412.54 0.00 5810 - VETERANS SERVICES 331,193 307,382.90 356,053 347,566.64 431,651 298,543.30 260,464.82 5870 - RESTITUTION 88,706 85,044.76 107,250 94,165.87 134,853 79,033.21 74,018.66 50 - HUMAN SERVICES Total 32,353,804 26,972,393.15 33,847,172 28,853,647.19 38,433,227 24,939,165.24 22,586,930.97 70 - EDUCATION 5910 - BOARD OF EDUCATION 25,532,777 25,532,776.55 26,121,589 26,121,589.00 28,301,509 25,778,324.92 21,884,657.50 5920 - CCCC 1,835,077 1,502,947.48 1,752,605 1,557,732.28 1,818,075 1,441,204.43 1,255,035.82 70 - EDUCATION Total 27,367,854 27,035,724.03 27,874,194 27,679,321.28 30,119,584 27,219,529.35 23,139,693.32 80 - CULTURAL & RECREATION 6110 - PARKS & RECREATION 1,530,087 1,402,144.12 1,752,797 1,504,187.17 1,942,128 1,430,080.82 1,186,931.91 6170 - MAIN LIBRARY 1,703,348 1,530,381.73 2,040,861 1,736,352.80 2,236,652 1,548,981.78 1,366,045.59 6172 - ANGIER BRANCH LIBRARY 0 0.00 253,527 211,733.68 277,187 205,153.57 159,530.30 6173 - BENHAVEN BRANCH LIBRARY 0 0.00 0 0.00 191,243 69,990.11 0.00 6175 - COATS BRANCH LIBRARY 0 0.00 151,658 122,622.63 172,052 115,215.46 78,109.61 6176 - DUNN BRANCH LIBRARY 0 0.00 278,839 242,816.32 340,739 245,720.11 178,163.29 6177 - ERWIN BRANCH LIBRARY 0 0.00 156,084 132,742.84 179,827 115,976.73 99,671.19 6199 - CULTURAL & REC APPROP 184,656 184,656.00 260,553 260,466.04 307,241 156,641.00 229,931.00 80 - CULTURAL & RECREATION Total 3,418,091 3,117,181.85 4,894,319 4,210,921.48 5,647,069 3,887,759.58 3,298,382.89 110 - GENERAL FUND EXPENSE $145,254,922 $133,483,625.97 $171,205,638 $152,210,101.12 $164,327,222 $111,990,424.29 $116,972,354.19 110 - GENERAL FUND REVENUE (OVER) / UNDER EXPENSES $0 $10,936,574.13 $0 $9,452,562.11 $0 $21,171,021.18 $19,932,781.52 General Fund 110 4 of 38 04.2024 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 2024 July $33,238,397.31 $42,138,468.69 $54,281,722.96 $61,938,453.02 August $30,766,642.59 $27,193,882.75 $50,916,962.51 $60,497,442.98 September $31,436,740.68 $28,797,031.28 $53,275,613.95 $62,210,399.73 October $32,621,237.60 $29,562,531.87 $53,221,696.77 $61,197,881.79 November $55,768,728.62 $53,048,249.28 $84,574,717.48 $88,650,677.63 December $52,233,891.79 $62,382,452.13 $98,791,252.21 $98,634,386.93 January $49,307,366.28 $53,864,998.95 $66,631,763.25 $103,901,132.64 $105,806,667.72 February $46,553,686.81 $52,435,487.27 $64,815,294.91 $95,758,773.44 $107,556,613.77 March $48,087,241.40 $54,340,963.07 $68,066,131.09 $86,276,904.65 $109,517,362.95 April $45,974,675.17 $53,068,500.85 $67,511,156.89 $85,610,715.71 $99,666,537.92 May $41,927,274.60 $52,229,820.40 $63,702,091.44 $72,169,732.05 June $40,106,511.08 $45,039,854.80 $57,567,146.97 $67,132,348.80 CASH General Fund Unaudited as of April 30, 2024 General Fund Cash 5 of 38 04.2024 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 33 - RESTRICTED REVENUE 0 0.00 82,000 82,000.00 0 0.00 82,000.00 35 - SERVICE CHARGES 916,253 818,441.42 1,086,377 827,387.06 1,274,808 684,551.79 718,396.06 38 - MISCELLANEOUS INCOME 60,412 64,174.05 74,329 88,846.99 45,000 41,032.40 72,507.99 39 - NON-REVENUE RECEIPTS 0 0.00 0 0.00 2,500,000.00 1,860,060.01 0.00 120 - HR JETPORT FUND REVENUE $976,665 $882,615.47 $1,242,706 $998,234.05 $3,819,808 $2,585,644.20 $872,904.05 Expense Function Department Budget Actual Budget Actual Budget Actual 120 - HARNETT REGIONAL JETPORT 4650 - HARNETT REGIONAL JETPORT 50 - SALARIES & BENEFITS 192,671 189,277.02 310,165 $202,559.90 315,718 $206,285.86 150,780.70 51 - PROFESSIONAL SRVCS 0 0.00 8,234 $8,234.00 470 $0.00 8,234.00 52 - SUPPLIES & MATERIALS 655,687 599,651.47 739,487 $699,730.80 892,572 $559,399.51 567,425.97 53 - CURRENT SRVCS 47,361 42,861.13 84,113 $46,912.48 60,598 $42,117.08 32,809.34 54 - FIXED CHARGES 46,049 42,341.22 58,347 $50,298.73 50,392 $46,913.43 47,854.98 55 - CAPITAL OUTLAY 15,971 15,971.00 42,000 $41,301.00 2,500,000 $1,860,060.01 0.00 58 - NON-CAPTALIZED ASSTS 18,926 17,927.33 360 $349.00 58 $0.00 0.00 70 - PCARD ENCUMBRANCE 0 0.00 0 $0.00 0 $0.00 0.00 120 - HR JETPORT FUND EXPENSE $976,665 $908,029.17 $1,242,706 $1,049,385.91 $3,819,808 $2,714,775.89 $807,104.99 120 - HR JETPORT FUND REVENUE (OVER) / UNDER EXPENSES $0 $25,413.70 $0 $51,151.86 $0 $129,131.69 $65,799.06 FY 2022 FY 2022 Harnett Regional Jetport Fund Unaudited as of April 30, 2024 FY 2024 Same Period Last Year FY 2023 FY 2023 FY 2024 Same Period Last Year HRJetport Fund 120 6 of 38 04.2024 Monthly Master Airport Avgas 1/29 JetA 1/29 Avgas 2/26 JetA 2/26 Avgas 3/25 JetA 3/25 Avgas 4/29 JetA 4/29 Harnett Regional Jetport 4.54$ 5.10$ 4.69$ 5.10$ 4.86$ 5.38$ 5.21$ 5.18$ Clinton 5.85$ 5.75$ 5.85$ 5.75$ 5.85$ 5.75$ 5.85$ 5.75$ Duplin County 5.15$ 4.78$ 5.15$ 5.19$ 5.45$ 5.00$ 5.74$ 5.15$ Elizabethtown 5.10$ 4.50$ 5.10$ 4.50$ 5.10$ 4.50$ 5.15$ 4.50$ Fayetteville 7.02$ 7.02$ 7.02$ 7.22$ 7.02$ 7.07$ 7.02$ 7.10$ Gray's Creek 5.80$ NA 5.50$ NA 5.50$ NA 5.50$ NA Johnston County 6.12$ 6.12$ 6.12$ 6.12$ 6.12$ 6.12$ 6.12$ 6.55$ Lauringburg-Maxton 5.10$ 5.89$ 5.10$ 5.89$ 5.20$ 5.89$ 5.25$ 5.89$ Lumberton 5.55$ 4.79$ 5.55$ 4.79$ 5.55$ 4.79$ 5.55$ 4.79$ Moore County 6.60$ 6.80$ 6.60$ 6.80$ 6.60$ 6.80$ 6.70$ 6.80$ Mount Olive 4.86$ 4.38$ 5.02$ 4.38$ 5.29$ 4.56$ 5.51$ 4.64$ Raleigh Exec 5.66$ 5.49$ 5.85$ 5.61$ 6.16$ 5.56$ 6.18$ 5.62$ Rocky Mount- Wilson 4.85$ 4.35$ 4.85$ 4.35$ 4.85$ 4.30$ 4.85$ 4.79$ Siler City 5.39$ 5.99$ 5.99$ 5.99$ 5.69$ 5.99$ 5.99$ 5.99$ Triangle North 5.24$ 5.44$ 5.24$ 5.44$ 5.54$ 5.79$ 5.54$ 5.79$ Wayne Executive (Goldsboro)5.45$ 4.65$ 5.83$ 4.98$ 5.13$ 4.53$ 5.38$ 4.53$ Whiteville 5.10$ 4.50$ 5.10$ 4.50$ 5.10$ 4.50$ 5.20$ 4.50$ Average of All Others 5.55$ 5.36$ 5.62$ 5.43$ 5.63$ 5.41$ 5.72$ 5.49$ HRJ Fuel Price Comparison with Surrounding Airports By Date & Types (AvGas - JetA) Jetport Fuel Price Comp 7 of 38 04.2024 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 2024 July $0.00 ($10,408.95) $87,758.33 $1,113,436.56 August $0.00 $38,091.69 $45,064.56 ($27,058.80) 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 ($103,940.73) May $0.00 $0.00 $21,848.15 $52,398.54 June $0.00 $0.00 $29,385.38 $28,888.28 CASH Harnett Regional Jetport Unaudited as of April 30, 2024 HRJetport Fund Cash 8 of 38 04.2024 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 2024 July $0.00 $16,178.82 $38,753.86 $37,999.75 August $0.00 $29,721.24 $38,363.43 $57,579.29 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 June $0.00 $0.00 $22,313.20 $73,394.41 INVENTORY Harnett Regional Jetport Unaudited as of April 30, 2024 HRJetport Fund Inventory 9 of 38 04.2024 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 33 - RESTRICTED REVENUE 6,003,877 0.00 10,015,000 15,737,050.09 2,000,000 0.00 0.00 35 - SERVICE CHARGES 0 20,997.06 0 880,075.62 0 984,439.62 654,289.48 38 - MISCELLANEOUS INCOME 0 0.00 0 0.00 0 0.00 0.00 39 - NON-REVENUE RECEIPTS 0 0.00 0 0.00 71,608 0.00 0.00 292 - ARPA FUND REVENUE $6,003,877 $20,997.06 $10,015,000 $16,617,125.71 $2,071,608 $984,439.62 $654,289.48 Revenue Category Budget Actual Budget Actual Budget Actual 292 - AMERICAN RESCUE PLAN ACT SRF 9990 - NON-DEPARTMENTAL 0 $0.00 4,262,949 $1,249,448.00 0 $0.00 $11,250.00 4120 - COUNTY ADMINISTRATION 0 $0.00 15,000 $15,000.00 0 $0.00 $117,822.60 4450 - EMERGENCY MEDICAL SERVICE 0 $0.00 117,823 $117,822.60 2,000,000 $1,571,308.65 $0.00 4591 - RADIO SYSTEM 6,003,877 $0.00 5,619,228 $5,619,227.49 71,608 $0.00 $1,043,259.00 292 - ARPA FUND EXPENSE $6,003,877 $0.00 $10,015,000 $7,001,498.09 $2,071,608 $1,571,308.65 $1,172,331.60 292 - ARPA FUND REVENUE (OVER) / UNDER EXPENSES $0 $20,997.06 $0 $9,615,627.62 $0 $586,869.03 $518,042.12 Same Period Last Year FY 2024FY 2022 Same Period Last Year American Rescue Plan Act Fund Unaudited as of April 30, 2024 FY 2022 FY 2023 FY 2023 FY 2024 ARPA Fund 292 10 of 38 04.2024 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 33 - RESTRICTED REVENUE 3,703 0.00 0 0.00 0 0.00 0.00 35 - SERVICE CHARGES 10,000 1,148.84 10,000 555,432.17 250,000 1,036,902.81 357,168.39 36 - ENTERPRISE CHARGES 1,384,000 2,379,865.25 1,761,500 2,477,357.11 2,113,000 1,764,170.76 1,960,669.14 37 - FACILITY FEES 35,875,000 39,966,546.68 37,564,650 41,935,719.04 40,635,000 32,437,715.85 31,649,441.20 38 - MISCELLANEOUS INCOME 552,094 8,794,097.38 320,000 761,792.20 340,000 752,099.93 10,544,769.36 39 - NON-REVENUE RECEIPTS 2,217,039 2,208,738.19 25,359,677 0.00 1,913,600 0.00 0.00 610 - HRW FUND REVENUE $40,041,836 $53,350,396.34 $65,015,827 $45,730,300.52 $45,251,600 $35,990,889.35 $44,512,048.09 Expense Function Department Budget Actual Budget Actual Budget Actual 610 - HARNETT REGIONAL WATER 91 - WATER & SEWER 7111 - HRW ADMINISTRATION 5,192,369 4,579,044.21 6,253,837 4,540,164.29 8,742,839 4,600,745.82 3,550,809.15 7113 - WATER TREATMENT PLANT 6,785,996 5,848,978.24 8,435,629 7,994,486.61 9,502,017 7,232,222.35 5,582,779.55 7115 - WASTEWATER TREATMENT PLANT 3,715,242 2,911,906.21 3,583,141 3,157,253.44 4,171,600 2,826,545.97 2,218,696.23 7117 - SOUTH HARNETT WASTEWATER PLANT 3,622,758 3,156,372.31 3,737,799 3,169,127.62 4,218,793 2,412,313.87 2,107,758.53 7119 - WATER DISTRIBUTION 5,449,739 4,790,103.03 6,396,571 5,348,263.00 7,437,904 4,914,603.47 3,603,698.71 7121 - SEWER COLLECTIONS 5,773,595 4,075,464.91 5,697,048 5,072,871.48 6,002,962 3,789,405.06 3,264,871.43 7131 - RETIREE INSURANCE HRW 60,807 65,678.76 63,829 64,280.10 75,824 46,005.60 50,523.30 9990 - NON-DEPARTMENTAL 9,441,330 19,153,656.58 30,847,973 48,202,047.68 5,099,661 $658,166.00 28,806,408.00 610 - HRW FUND EXPENSE $40,041,836 $44,581,204.25 $65,015,827 $77,548,494.22 $45,251,600 $26,480,008.14 $49,185,544.90 610 - HRW FUND REVENUE (OVER) / UNDER EXPENSES $0 $8,769,192.09 $0 $31,818,193.70 $0 $9,510,881.21 $4,673,496.81 FY 2023 Harnett Regional Water Fund Unaudited as of April 30, 2024 Same Period Last Year FY 2022 FY 2024 FY 2024FY 2022 FY 2023 Same Period Last Year HRW Fund 610 11 of 38 04.2024 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 2024 July $56,308,485.60 $51,396,573.71 $69,906,540.92 $47,872,143.43 August $57,887,471.15 $53,478,105.50 $71,395,812.59 $49,668,609.87 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,821,861.66 January $57,818,912.12 $47,842,388.74 $63,336,473.21 $79,769,987.45 $58,453,968.03 February $58,911,946.79 $49,655,875.28 $65,045,521.23 $56,832,826.21 $59,557,076.87 March $60,961,613.87 $51,249,479.82 $62,345,519.84 $53,955,027.95 $61,955,193.68 April $60,643,544.18 $52,788,896.94 $62,323,826.87 $55,336,607.53 $57,989,641.03 May $61,748,714.89 $55,026,201.87 $57,960,361.56 $56,053,548.68 June $55,307,862.26 $48,531,475.46 $58,710,523.48 $45,653,091.25 CASH Harnett Regional Water Fund Unaudited as of April 30, 2024 HRW Fund Cash 12 of 38 04.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 335,000 333,365.11 260,000 378,939.22 300,000 193,310.25 195,155.20 35 - SERVICE CHARGES 0 410.26 0 18,173.48 0 5,550.83 13,959.72 36 - ENTERPRISE CHARGES 3,116,088 3,455,130.23 3,414,080 3,525,625.02 4,122,082 2,837,949.23 3,006,947.74 37 - FACILITY FEES 4,745,000 4,722,829.38 4,520,000 4,824,835.93 4,822,000 4,863,939.69 4,773,742.02 38 - MISCELLANEOUS INCOME 45,000 124,396.71 251,981 166,073.65 185,000 92,262.15 317,922.72 39 - NON-REVENUE RECEIPTS 397,860 0.00 103,000 0.00 0 0.00 0.00 660 - SOLID WASTE FUND REVENUE $8,638,948 $8,636,131.69 $8,549,061 $8,913,647.30 $9,429,082 $7,993,012.15 $8,307,727.40 Expense Function Department Budget Actual Budget Actual Budget Actual 660 - SOLID WASTE MANAGEMENT 96 - SOLID WASTE 7410 - SOLID WASTE MANAGEMENT 6,472,964 5,698,296.50 7,628,133 6,002,800.28 7,763,141 5,365,646.00 4,432,806.71 7431 - RETIREE INSURANCE SW 20,000 20,448.00 20,000 26,509.00 29,712 20,036.00 20,277.00 9990 - NON-DEPARTMENTAL 2,145,984 2,459,955.28 900,928 $1,146,781.72 1,636,229 $0.00 797,928.00 610 - SOLID WASTE FUND EXPENSE $8,638,948 $8,178,699.78 $8,549,061 $7,176,091.00 $9,429,082 $5,385,682.00 $5,251,011.71 660 - SOLID WASTE FUND REVENUE (OVER) / UNDER EXPENSES $0 $457,431.91 $0 $1,737,556.30 $0 $2,607,330.15 $3,056,715.69 FY 2023 FY 2022 FY 2022 Solid Waste Fund Unaudited as of April 30, 2024 Same Period Last Year FY 2024 FY 2024FY 2023 Same Period Last Year Solid Waste Fund 660 13 of 38 04.2024 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 2024 July $3,387,995.72 $4,457,425.74 $5,242,053.75 $5,391,826.49 August $3,375,944.64 $4,647,598.39 $5,341,058.08 $5,360,309.25 September $3,607,274.52 $4,882,131.66 $5,547,560.45 $5,494,434.70 October $3,759,678.53 $5,029,336.00 $5,661,414.55 $5,535,653.38 November $5,581,197.69 $6,828,615.40 $7,650,032.21 $7,318,764.25 December $6,451,303.81 $7,686,623.97 $8,441,890.85 $7,758,644.49 January $4,616,721.91 $5,784,640.53 $8,071,097.98 $8,957,335.18 $8,474,641.72 February $4,751,271.26 $5,844,033.09 $8,201,845.59 $9,072,792.36 $8,465,294.30 March $4,565,672.41 $5,773,139.20 $8,188,060.38 $8,162,225.83 $8,367,565.46 April $4,268,648.15 $5,713,193.95 $7,697,878.34 $7,939,798.65 $7,922,515.99 May $4,194,405.45 $5,677,132.65 $7,291,803.85 $7,812,630.66 June $3,590,915.49 $4,646,306.54 $5,409,762.66 $6,655,083.50 CASH Solid Waste Fund Unaudited as of April 30, 2024 Solid Waste Fund Cash 14 of 38 04.2024 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 760,000 1,322,417.89 850,000 553,775.07 850,000 497,061.66 457,387.14 38 - MISCELLANEOUS INCOME 0 0.00 0 5,792.57 0 0.00 1,792.57 39 - NON-REVENUE RECEIPTS 0 0.00 0 0.00 0 0.00 0.00 810 - WORKER'S COMP FUND REVENUE $760,000 $1,322,417.89 $850,000 $559,567.64 $850,000 $497,061.66 $459,179.71 Expense Function Department Budget Actual Budget Actual Budget Actual 810 - WORKERS COMPENSATION FUND 00 - GENERAL GOVERNMENT 9301 - WORKER'S COMPENSATION 760,000 349,599.73 850,000 854,566.54 850,000 $604,891.21 581,437.48 810 - WORKER'S COMP FUND EXPENSE $760,000 $349,599.73 $850,000 $854,566.54 $850,000 $604,891.21 $581,437.48 810 - WORKERS'S COMP FUND REVENUE (OVER) / UNDER EXPENSES $0 $972,818.16 $0 $294,998.90 $0 $107,829.55 $122,257.77 FY 2023 FY 2024FY 2022 Worker's Compensation Fund Unaudited as of April 30, 2024 FY 2022 FY 2024FY 2023 Same Period Last Year Same Period Last Year Worker's Comp Fund 810 15 of 38 04.2024 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 2024 July $4,629,563.32 $5,397,537.95 $6,198,476.66 $5,745,898.77 August $4,708,459.01 $5,246,986.87 $5,963,212.81 $5,771,021.35 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 June $4,627,680.64 $5,380,269.92 $6,163,362.66 $6,036,996.00 CASH Worker's Compensation Fund Unaudited as of April 30, 2024 Worker's Comp Fund Cash 16 of 38 04.2024 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 250,000 108,674.91 250,000 128,054.68 250,000 79,704.24 106,171.04 39 - NON-REVENUE RECEIPTS 0 0.00 1,000,000 0.00 0 0.00 0.00 820 - UNEMPLOYMENT FUND REVENUE $250,000 $108,674.91 $1,250,000 $128,054.68 $250,000 $79,704.24 $106,171.04 Expense Function Department Budget Actual Budget Actual Budget Actual 820 - UNEMPLOYMENT INSURANCE 00 - GENERAL GOVERNMENT 9305 - UNEMPLOYMENT INSURANCE 250,000 16,813.26 250,000 $31,606.81 250,000 $49,731.76 31,606.81 9910 - CONTINGENCY 0 0.00 1,000,000 $1,000,000.00 0 $0.00 0.00 820 - UNEMPLOYMENT FUND EXPENSE $250,000 $16,813.26 $1,250,000 $1,031,606.81 $250,000 $49,731.76 $31,606.81 820 - UNEMPLOYMENT FUND REVENUE (OVER) / UNDER EXPENSES $0 $91,861.65 $0 $903,552.13 $0 $29,972.48 $74,564.23 FY 2023 FY 2022 FY 2022 Unemployment Insurance Fund Unaudited as of April 30, 2024 FY 2024 FY 2024 Same Period Last Year FY 2023 Same Period Last Year Unemployment Ins Fund 820 17 of 38 04.2024 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 2024 July $1,564,861.07 $1,753,400.43 $1,850,881.89 $947,753.76 August $1,582,832.12 $1,762,410.64 $1,861,008.73 $959,484.99 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 June $1,529,156.27 $1,748,924.02 $1,840,785.67 $937,233.54 CASH Unemployment Insurance Fund Unaudited as of April 30, 2024 Unemployment Ins Fund Cash 18 of 38 04.2024 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 180,900 157,395.13 191,875 154,380.00 228,762 147,975.59 128,475.00 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 $180,900 $157,395.13 $191,875 $154,380.00 $228,762 $147,975.59 $128,475.00 Expense Function Department Budget Actual Budget Actual Budget Actual 830 - EMPLOYEE CLINIC 00 - GENERAL GOVERNMENT 9302 - EMPLOYEE CLINIC 180,900 127,581.04 191,875 178,079.32 228,762 153,593.55 139,000.23 830 - EMPLOYEE CLINIC FUND EXPENSE $180,900 $127,581.04 $191,875 $178,079.32 $228,762 $153,593.55 $139,000.23 830 - EMPLOYEE CLINIC FUND REVENUE (OVER) / UNDER EXPENSES $0 $29,814.09 $0 $23,699.32 $0 $5,617.96 $10,525.23 Employee Clinic Fund Unaudited as of April 30, 2024 FY 2022 FY 2022 FY 2024FY 2023 FY 2024 Same Period Last Year Same Period Last Year FY 2023 Employee Clinic Fund 830 19 of 38 04.2024 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 2024 July $700,090.56 $692,061.11 $723,019.23 $699,682.16 August $697,900.58 $703,376.13 $723,881.09 $699,923.80 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 June $668,125.25 $688,250.11 $720,716.69 $699,088.15 CASH Employee Clinic Fund Unaudited as of April 30, 2024 Employee Clinic Fund Cash 20 of 38 04.2024 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 10,000,000 10,001,728.55 11,253,500 11,097,615.91 12,000,000 9,539,243.33 8,833,481.87 38 - MISCELLANEOUS INCOME 512,000 352,486.51 650,000 1,261,002.15 0 925,211.99 870,152.18 39 - NON-REVENUE RECEIPTS 300,000 0.00 323,000 0.00 486,500 0.00 0.00 841 - MEDICAL SELF INS FUND REVENUE $10,812,000 $10,354,215.06 $12,226,500 $12,358,618.06 $12,486,500 $10,464,455.32 $9,703,634.05 Expense Function Department Budget Actual Budget Actual Budget Actual 841 - MEDICAL INSURANCE - SELF 00 - GENERAL GOVERNMENT 9303 - MEDICAL INSURANCE - SELF 10,812,000 9,499,014.57 12,226,500 10,662,369.55 12,486,500 9,695,009.75 8,368,031.63 841 - MEDICAL SELF INS FUND EXPENSE $10,812,000 $9,499,014.57 $12,226,500 $10,662,369.55 $12,486,500 $9,695,009.75 $8,368,031.63 841 - MEDICAL SELF INS FUND REVENUE (OVER) / UNDER EXPENSES $0 $855,200.49 $0 $1,696,248.51 $0 $769,445.57 $1,335,602.42 FY 2023 FY 2022 FY 2022 Medical Self Insurance Fund Unaudited as of April 30, 2024 FY 2024 FY 2024 FY 2023 Same Period Last Year Same Period Last Year Medical Self Ins Fund 841 21 of 38 04.2024 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 2024 July $8,394,410.05 $9,936,719.25 $11,349,904.41 $13,123,302.23 August $8,309,827.07 $9,558,799.23 $10,768,815.17 $12,519,779.60 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 June $6,837,286.28 $9,752,219.84 $10,485,775.01 $12,332,058.18 CASH Medical Self Insurance Fund Unaudited as of April 30, 2024 Medical Self Ins Fund Cash 22 of 38 04.2024 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 550,000 520,837.10 650,000 519,533.60 650,000 446,793.11 432,171.54 39 - NON-REVENUE RECEIPTS 0 0.00 0 0.00 0 0.00 0.00 843 - DENTAL SELF INS FUND REVENUE $550,000 $520,837.10 $650,000 $519,533.60 $650,000 $446,793.11 $432,171.54 Expense Function Department Budget Actual Budget Actual Budget Actual 843 - DENTAL INSURANCE - SELF 00 - GENERAL GOVERNMENT 9307 - DENTAL INSURANCE - SELF 550,000 445,343.87 650,000 459,020.75 650,000 387,328.02 375,568.48 843 - DENTAL SELF INS FUND EXPENSE $550,000 $445,343.87 $650,000 $459,020.75 $650,000 $387,328.02 $375,568.48 843 - DENTAL SELF INS FUND REVENUE (OVER) / UNDER EXPENSES $0 $75,493.23 $0 $60,512.85 $0 $59,465.09 $56,603.06 FY 2022 FY 2022 Dental Self Insurance Fund Unaudited as of April 30, 2024 FY 2024FY 2023 FY 2024FY 2023 Same Period Last Year Same Period Last Year Dental Self Ins Fund 843 23 of 38 04.2024 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 2024 July $612,444.32 $724,520.63 $822,532.24 $853,196.58 August $602,629.10 $696,545.18 $790,185.12 $843,955.60 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 June $544,280.85 $703,042.49 $780,381.70 $846,057.74 CASH Dental Self Insurance Fund Unaudited as of April 30, 2024 Dental Self Ins Fund Cash 24 of 38 04.2024 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 1,500,000 1,496,197.47 1,500,000 1,409,301.62 1,500,000 373,522.02 397,419.96 36 - ENTERPRISE CHARGES 0 25.00 0 225.00 0 75.00 200.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,496,222.47 $1,500,000 $1,409,526.62 $1,500,000 $373,597.02 $397,619.96 Expense Function Department Budget Actual Budget Actual Budget Actual 845 - MEDICAL INSURANCE RETIREE 00 - GENERAL GOVERNMENT 9304 - MEDICAL INSURANCE - RETIREE 1,500,000 1,117,497.44 1,500,000 1,357,594.41 1,500,000 839,909.41 1,096,903.76 845 - RETIREE SELF INS FUND EXPENSE $1,500,000 $1,117,497.44 $1,500,000 $1,357,594.41 $1,500,000 $839,909.41 $1,096,903.76 845 - RETIREE SELF INS FUND REVENUE (OVER) / UNDER EXPENSES $0 $378,725.03 $0 $51,932.21 $0 $466,312.39 $699,283.80 FY 2022 FY 2022 Retiree Self Insurance Fund Unaudited as of April 30, 2024 FY 2024 FY 2024FY 2023 FY 2023 Same Period Last Year Same Period Last Year Retiree Self Ins Fund 845 25 of 38 04.2024 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 2024 July $646,924.11 $433,059.43 $829,677.64 $872,551.83 August $590,241.30 $433,709.18 $770,327.59 $728,469.75 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,019.44 April ($611,564.54) $93,954.23 $519,585.17 $123,809.37 $410,638.87 May ($622,617.07) $594,052.00 $532,894.99 $60,110.80 June ($625,264.03)$428,365.66 $807,090.69 $859,022.90 CASH Retiree Self Insurance Fund Unaudited as of April 30, 2024 Retiree Self Ins Fund Cash 26 of 38 04.2024 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 113,111 217,546.85 240,909 121,749.00 148,008 145,320.00 121,749.00 38 - MISCELLANEOUS INCOME 45,546 62,469.00 12,000 16,269.51 22,360 22,360.00 9,211.51 39 - NON-REVENUE RECEIPTS 203,823 100,000.00 100,000 100,000.00 484,521 0.00 100,000.00 880 - FLEET SERVICES FUND REVENUE $362,480 $380,015.85 $352,909 $238,018.51 $654,889 $167,680.00 $230,960.51 Expense Function Department Budget Actual Budget Actual Budget Actual 880 - FLEET SERVICES 00 - GENERAL GOVERNMENT 9410 - FLEET SERVICES 280,215 277,136.77 290,679 159,127.40 654,889 525,871.31 157,832.00 9910 - CONTINGENCY 82,265 0.00 62,230 0.00 0 0.00 0.00 880 - FLEET SERVICES FUND EXPENSE $362,480 $277,136.77 $352,909 $159,127.40 $654,889 $525,871.31 $157,832.00 880 - FLEET SERVICES FUND REVENUE (OVER) / UNDER EXPENSES $0 $102,879.08 $0 $78,891.11 $0 $358,191.31 $73,128.51 FY 2022 FY 2022 Fleet Services Fund Unaudited as of April 30, 2024 FY 2024 FY 2024FY 2023 FY 2023 Same Period Last Year Same Period Last Year Fleet Services Fund 880 27 of 38 04.2024 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 2024 July $601,279.16 $1,090,458.91 $1,203,969.99 $1,179,589.10 August $609,506.58 $1,184,866.91 $1,199,951.99 $1,072,380.65 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 $914,037.79 May $616,138.99 $831,262.80 $1,110,625.14 $1,265,171.10 June $571,361.34 $1,090,458.91 $1,193,337.99 $1,272,229.10 CASH Fleet Services Fund Unaudited as of April 30, 2024 Fleet Services Fund Cash 28 of 38 04.2024 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 1,568,420 1,788,955.15 1,748,415 0.00 0 250,279.44 0.00 38 - MISCELLANEOUS INCOME 0 0.00 0 1,601,809.13 1,773,310 1,395,002.82 1,341,141.29 39 - NON-REVENUE RECEIPTS 350,000 350,000.00 2,046,804 2,074,009.00 350,350 0.00 1,624,009.00 890 - INFO TECHNOLOGY FUND REVENUE $1,918,420 $2,138,955.15 $3,795,219 $3,675,818.13 $2,123,660 $1,645,282.26 $2,965,150.29 Expense Function Department Budget Actual Budget Actual Budget Actual 890 - INFORMATION TECHNOLOGY 00 - GENERAL GOVERNMENT 9420 - TECHNOLOGY 1,918,420 1,711,368.67 3,795,219 2,647,317.05 2,123,660 1,282,215.50 2,112,611.74 890 - INFO TECHNOLOGY FUND EXPENSE $1,918,420 $1,711,368.67 $3,795,219 $2,647,317.05 $2,123,660 $1,282,215.50 $2,112,611.74 890 - INFO TECHNOLOGY FUND REVENUE (OVER) / UNDER EXPENSES $0 $427,586.48 $0 $1,028,501.08 $0 $363,066.76 $852,538.55 FY 2022 FY 2022 Information Technology Fund Unaudited as of April 30, 2024 FY 2024 FY 2024FY 2023 FY 2023 Same Period Last Year Same Period Last Year Info Technology Fund 890 29 of 38 04.2024 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 2024 July $852,093.02 $1,491,852.27 $2,011,076.10 $2,884,692.29 August $804,366.93 $1,558,798.40 $2,089,994.83 $2,653,325.67 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,458.41 May $612,977.73 $973,972.46 $1,845,823.82 $2,796,637.32 June $798,424.51 $1,492,175.30 $1,924,106.94 $3,140,915.15 CASH Information Technology Fund Unaudited as of April 30, 2024 Info Technology Fund Cash 30 of 38 04.2024 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 33 - RESTRICTED REVENUE 681,954 443,960.42 884,546 411,161.90 1,489,942 37,703.37 213,682.09 38 - MISCELLANEOUS INCOME 101,068 31,562.93 73,000 28,254.50 68,250 15,570.81 21,129.50 39 - NON-REVENUE RECEIPTS 0 0.00 195,350 0.00 201,102 0.00 0.00 250 - VET TREATMENT COURT REVENUE $783,022 $475,523.35 $1,152,896 $439,416.40 $1,759,294 $53,274.18 $234,811.59 Expense Function Department Budget Actual Budget Actual Budget Actual 250 - VETERANS SERVICE SRF 00 - GENERAL GOVERNMENT 4185 - VETERANS TREATMENT COURT 783,022 286,462.47 1,152,896 435,225.61 1,759,294 289,114.47 303,579.85 250 - VET TREATMENT COURT EXPENSE $783,022 $286,462.47 $1,152,896 $435,225.61 $1,759,294 $289,114.47 $303,579.85 250 - VET TREATMENT COURT REVENUE (OVER) / UNDER EXPENSES $0 $189,060.88 $0 $4,190.79 $0 $235,840.29 $68,768.26 FY 2022 FY 2022 Veteran's Treatment Court Unaudited as of April 30, 2024 FY 2024 Same Period Last Year Same Period Last Year FY 2023 FY 2024FY 2023 Veteran's Treatment Court 250 31 of 38 04.2024 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 2024 July $3,916.48 $26,014.22 $106,617.08 $128,518.38 August ($19.11) $6,936.02 $197,695.62 $241,771.52 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 June $28,305.11 $36,571.92 $127,852.90 $69,181.84 CASH Veteran's Treatment Court Unaudited as of April 30, 2024 Veteran's Treatment Court Cash 32 of 38 04.2024 Monthly Master as of December 31, 2020 1. Current year activity :City Hold Harmless School Hold HarmlessFiscal Year 2024as 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, 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 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ March, 2024 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ April, 2024 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ May, 2024 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ June, 2024 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 7,884,318.75$ 5,259,781.49$ 2,431,038.23$ 1,830,482.85$ 3,660,965.70$ 22.67$ 3,994,075.69$ 2,405,867.43$ (1,111,596.83)$ (1,354,090.47)$ 2,098,203.35$ 27,099,068.86$ Year over Year Change 1.64% 0.16% 1.62% 0.37% 0.37% -78.84% 7.09% 2.68% 14.28% -1.10% -2.83% 1.26% 2. Comparison to prior year :City Hold Harmless School Hold HarmlessFiscal Year 2023 Article 39 Article 40 Article 42 Article 40 Article 42 Article 44 Article 44 *524 Article 46 Article 39 Article 39 Special Total July, 2022 1,157,314.97$ 749,270.84$ 353,464.82$ 260,035.43$ 520,070.87$ 13.76$ 532,789.40$ 351,044.51$ (137,020.83)$ (182,627.83)$ 320,851.18$ 3,925,207.12$ August, 2022 1,056,359.97$ 766,939.47$ 325,450.70$ 269,441.55$ 538,883.10$ 20.65$ 532,789.40$ 316,994.86$ (146,156.14)$ (222,408.85)$ 294,360.22$ 3,732,674.93$ September, 2022 1,164,761.44$ 753,374.63$ 355,098.87$ 261,963.22$ 523,926.43$ -$ 532,789.40$ 354,728.83$ (137,991.78)$ (183,490.36)$ 322,725.75$ 3,947,886.43$ October, 2022 917,997.69$ 724,950.21$ 289,874.24$ 253,815.32$ 507,630.64$ 2.97$ 532,789.40$ 274,165.86$ (140,568.23)$ (229,808.62)$ 258,353.54$ 3,389,203.02$ November, 2022 1,016,485.39$ 714,540.62$ 321,630.62$ 245,037.79$ 490,075.58$ 73.90$ 532,880.23$ 303,440.76$ (132,132.55)$ (193,176.81)$ 285,632.12$ 3,584,487.65$ December, 2022 1,371,351.32$ 838,394.41$ 416,287.26$ 290,002.96$ 580,005.92$ (4.12)$ 532,880.23$ 417,354.23$ (149,779.40)$ (183,247.31)$ 379,151.96$ 4,492,397.46$ January, 2023 1,072,630.12$ 704,166.18$ 330,379.47$ 243,446.33$ 486,892.67$ -$ 532,880.23$ 325,443.92$ (129,021.26)$ (174,394.75)$ 298,254.82$ 3,690,677.73$ February, 2023 892,254.25$ 578,968.82$ 280,991.88$ 195,908.69$ 391,817.37$ 162.27$ 532,880.23$ 267,089.24$ (104,183.18)$ (137,357.44)$ 249,819.51$ 3,148,351.64$ March, 2023 1,242,267.26$ 788,002.09$ 375,163.59$ 274,912.22$ 549,824.44$ 2.08$ 532,880.23$ 379,503.44$ (143,846.71)$ (187,140.55)$ 343,013.59$ 4,154,581.68$ April, 2023 1,142,886.85$ 696,497.83$ 352,088.43$ 237,542.39$ 475,084.79$ 161.78$ 532,880.23$ 346,058.19$ (123,181.67)$ (148,681.22)$ 317,437.67$ 3,828,775.27$ May, 2023 1,146,706.13$ 762,708.40$ 345,893.18$ 271,966.63$ 543,933.25$ 28.24$ 524,133.97$ 353,083.54$ (163,044.51)$ (200,801.82)$ 312,761.12$ 3,728,709.61$ June, 2023 1,210,286.03$ 810,663.78$ 367,483.96$ 288,177.15$ 576,354.30$ (664.52)$ 570,454.80$ 372,388.16$ (173,192.86)$ (214,434.90)$ 330,726.93$ 4,138,242.83$ 7,756,900.90$ 5,251,636.36$ 2,392,185.98$ 1,823,742.60$ 3,647,485.21$ 107.16$ 3,729,798.29$ 2,343,172.97$ (972,670.19)$ (1,369,154.53)$ 2,159,329.59$ 26,762,534.34$ AnnualizedBudget % Collected(7 month)to Date1103100 310231 5,418,631.45$ 10,100,000$ (4,681,368.55)$ 5,891,667$ (473,035.22)$ 53.65%NC Sales Tax - Article 39 1103100 310233 5,259,781.49$ 7,950,000$ (2,690,218.51)$ 4,637,500$ 622,281.49$ 66.16%NC Sales Tax - Article 40 (General Fund)1103100 310235 2,431,038.23$ 2,061,800$ 369,238.23$ 1,202,717$ 1,228,321.56$ 117.91%NC Sales Tax - Article 42 (General Fund)1103100 310237 3,994,098.36$ 6,450,000$ (2,455,901.64)$ 3,762,500$ 231,598.36$ 61.92%NC Sales Tax - Article 44 & Article 44 *52417,103,549.53$ 26,561,800.00$ (9,458,250.47)$ 15,494,383.33$ 1,609,166.20$ 64.39% 2118401 - 380892 2,098,203.35$ 2,986,778.00$ (888,574.65)$ 1,742,287.17$ 355,916.18$ 70.25%NC Sales Tax Special Districts 3003100 310233 1,830,482.85$ 2,415,182$ (584,699.15)$ 1,408,856$ 421,626.68$ 75.79%NC Sales Tax - Article 40 (Education)3003100 310235 3,660,965.70$ 5,244,640$ (1,583,674.30)$ 3,059,373$ 601,592.37$ 69.80%NC Sales Tax - Article 42 (Education)3003100 310239 2,405,867.43$ 3,122,285$ (716,417.57)$ 1,821,333$ 584,534.51$ 77.05%NC Sales Tax - Article 467,897,315.98$ 10,782,107.00$ (2,884,791.02)$ 6,289,562.42$ 1,607,753.56$ 73.24% HARNETT COUNTY SALES TAX ANALYSIS BY ARTICLE General Fund Board of Education General Fund Board of Education 3. Reconciliation to general ledger :Over/(Under) Annualized BudgetBalance to Tyler Activity Budget Over/(Under) Budget Monthly Sales Tax 33 of 38 04.2024 Monthly Master HARNETT COUNTY FINANCIAL SUMMARY REPORT 5/16/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) U:\My Documents\Monthly Reports\2023 - 2024\Financial Reports\County\4th Qtr 2024\04.2024 Monthly Master 34 HARNETT COUNTY FINANCIAL SUMMARY REPORT 5/16/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 U:\My Documents\Monthly Reports\2023 - 2024\Financial Reports\County\4th Qtr 2024\04.2024 Monthly Master 35 HARNETT COUNTY FINANCIAL SUMMARY REPORT 5/16/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 U:\My Documents\Monthly Reports\2023 - 2024\Financial Reports\County\4th Qtr 2024\04.2024 Monthly Master 36 HARNETT COUNTY FINANCIAL SUMMARY REPORT 5/16/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 U:\My Documents\Monthly Reports\2023 - 2024\Financial Reports\County\4th Qtr 2024\04.2024 Monthly Master 37 HARNETT COUNTY FINANCIAL SUMMARY REPORT 5/16/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 % U:\My Documents\Monthly Reports\2023 - 2024\Financial Reports\County\4th Qtr 2024\04.2024 Monthly Master 38