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 AboutJuly 2024 Financial Report Monthly Financial Reports July 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 243,769.33 68,152.03 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 141,509.16 101,227.88 33 - RESTRICTED REVENUE 23,410,407 23,850,972.56 23,773,916 21,152,756.95 22,148,448 278,627.45 273,084.03 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 1,113,053.24 1,624,648.92 36 - ENTERPRISE CHARGES 0 4,392.51 0 6,325.96 0 485.07 0.00 37 - FACILITY FEES 0 2,783.82 0 3,487.26 0 0.00 0.00 38 - MISCELLANEOUS INCOME 2,109,210 2,487,949.62 820,092 302,645.92 930,558 55,995.51 101,994.85 39 - NON-REVENUE RECEIPTS 27,735,817 1,274,238.00 12,468,816 164,375.00 12,266,557 0.00 0.00 110 - GENERAL FUND REVENUE 171,205,638 $161,776,989.19 169,027,373 $161,390,368.65 177,478,685 $1,833,439.76 $1,965,118.01 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 24,211.00 25,222.21 4120 - COUNTY ADMINISTRATION 1,160,594 1,060,696.45 1,406,990 1,371,737.43 1,469,637 67,289.74 58,123.45 4130 - FINANCE 1,619,365 1,533,443.87 1,910,725 1,894,440.46 1,989,322 64,291.82 59,696.64 4131 - RETIREE INSURANCE 944,351 919,464.87 930,000 929,999.03 956,573 33,284.67 35,135.22 4140 - TAX 1,999,758 1,714,142.62 2,076,484 2,038,840.72 2,343,796 84,142.86 54,856.60 4150 - LEGAL SERVICES 387,832 369,867.69 589,456 571,875.48 634,280 26,310.67 16,775.72 4160 - HUMAN RESOURCES 966,968 882,574.81 967,288 956,690.67 672,502 32,334.88 397,727.11 4161 - INSURANCE 0 0.00 0 0.00 336,230 10,240.00 0.00 4170 - BOARD OF ELECTIONS 577,506 562,798.02 875,726 802,482.70 801,696 16,900.25 12,816.97 4180 - CLERK OF COURT 28,233 17,713.99 51,810 45,359.68 53,815 0.00 0.00 4190 - REGISTER OF DEEDS 810,075 771,787.47 903,433 896,393.98 964,136 98,337.82 31,743.15 4210 - GENERAL SERVICES 255,027 252,022.15 272,931 272,763.64 296,962 11,205.63 10,258.79 4230 - FACILITIES MAINTENANCE 3,595,600 3,399,030.41 3,916,231 3,940,618.80 4,298,026 217,267.93 102,705.92 4250 - FLEET MAINTENANCE 907,315 841,138.04 1,120,753 1,108,538.90 1,083,360 31,391.66 38,576.57 4270 - INFORMATION TECHNOLOGY 2,736,780 2,617,423.22 2,850,044 2,838,039.08 2,125,815 89,657.53 75,601.75 4290 - GIS 846,687 810,806.18 1,005,874 999,473.46 1,087,118 35,102.98 30,365.11 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,849,172 0.00 0.00 00 - GENERAL GOVERNMENT Total 51,286,883 43,935,999.75 37,665,878 37,283,153.59 37,562,878 841,969.44 949,605.21 FY 2024 FY 2024 General Fund Unaudited as of July 31, 2024 FY 2025 Same Period Last Year Same Period Last Year FY 2023 FY 2023 FY 2025 General Fund 110 1 of 37 07.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 601,545.56 554,456.46 4330 - CAMPBELL DEPUTIES 586,694 575,389.37 727,436 624,155.97 691,536 23,641.09 22,395.36 4350 - SCHOOL RESOURCE OFFICER 2,147,192 1,580,281.44 2,480,674 2,057,966.99 2,835,855 65,757.12 55,452.99 4370 - CHILD SUPPORT ENFORCEMENT 98,087 96,248.57 110,767 104,587.47 107,988 3,817.85 3,510.78 4390 - JAIL 7,546,385 6,768,434.38 8,146,079 7,656,019.93 8,047,349 244,443.76 191,805.01 4410 - EMERGENCY MANAGEMENT 1,187,136 1,127,582.44 1,314,553 1,303,274.39 1,620,022 44,835.40 78,497.15 4411 - EMERGENCY SERVICES GRANTS 442,695 250,499.57 374,520 272,654.20 242,502 0.00 0.00 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 0.00 382,680.75 4510 - FIELD SERVICES 423,264 398,306.11 465,803 440,958.26 583,542 15,921.48 16,555.77 4512 - ANIMAL SHELTER 442,446 366,985.54 554,249 488,399.22 599,458 15,730.67 13,752.51 4530 - MEDICAL EXAMINER 100,000 82,400.00 100,000 67,545.90 100,000 0.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 47,844.66 44,552.98 10 - PUBLIC SAFETY Total 47,369,756 43,149,365.11 50,324,414 48,266,396.74 55,370,414 1,574,113.27 2,032,173.86 20 - TRANSPORTATION 4610 - TRANSPORTATION 1,493,881 1,040,368.09 1,576,325 1,320,124.60 1,875,856 43,057.95 39,846.12 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 58,202.50 47,742.59 30 - ENVIRONMENTAL PROTECTION 4710 - SOIL & WATER 309,461 295,848.31 339,110 328,969.13 365,978 12,871.76 12,524.68 4730 - FORESTRY PROGRAM 152,709 132,587.79 164,599 151,180.07 149,122 0.00 0.00 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 12,871.76 12,524.68 40 - ECONOMIC & PHYSICAL DEVELOPMNT 4910 - DEVELOPMENT SERVICES 1,119,722 1,033,858.20 1,252,686 1,184,125.19 1,458,179 44,671.50 44,579.01 4930 - ECONOMIC DEVELOPMENT 1,111,354 883,701.25 1,038,781 1,008,995.31 1,177,107 23,486.35 55,336.59 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 37.57 0.00 4971 - WIOA - ADULT 0 0.00 102,365 97,736.86 33,036 5,728.47 0.00 4973 - WIAO - NC WORKS CAREER CENTER 0 0.00 78,353 76,863.24 15,391 5,970.83 0.00 4975 - WIOA - DISLOCATED WORKER 0 0.00 57,292 57,086.71 19,161 3,403.82 0.00 4978 - WIOA - YOUTH - IN 0 0.00 34,283 34,201.47 11,412 1,983.32 0.00 4979 - WIOA - YOUTH - OUT 0 0.00 102,867 100,899.76 33,834 6,308.08 0.00 4990 - COOPERATIVE EXTENSION 443,332 402,432.61 459,580 396,348.23 508,465 7,054.10 25,487.92 4995 - COOPERATIVE EXT SPECIAL PROG 158,799 125,770.09 123,638 101,761.52 62,952 2,118.71 4,505.35 40 - ECONOMIC & PHYSICAL DEVELOPMNT Total 2,833,664 2,445,941.02 3,295,554 3,079,713.95 3,875,482 100,765.74 129,908.87 50 - HUMAN SERVICES 5110 - GENERAL ADMINISTRATION 9,637,937 7,349,865.69 269,764 236,698.78 6,440,756 229,891.03 228,596.25 5112 - VITAL RECORDS 0 0.00 28,215 27,310.61 313 0.00 0.00 5114 - AGING 0 0.00 105,919 95,122.53 0 0.00 0.00 5118 - LABORATORY SERVICES 0 0.00 312,717 274,791.38 99,245 600.00 3,528.24 General Fund 110 2 of 37 07.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 250,721 1,660.61 2,422.07 5121 - IMMUNIZATION ACTION PLAN 0 0.00 97,163 65,191.17 3,506 0.00 0.00 5122 - LEAD 0 0.00 8,170 2,675.12 0 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 166,893 5,092.95 136.70 5131 - SEXUALLY TRANSMITTED DISEASE 0 0.00 277,218 237,488.12 29,220 0.00 411.70 5134 - MATERNAL HEALTH 0 0.00 586,715 538,216.41 89,559 0.00 136.71 5135 - FAMILY PLANNING 0 0.00 576,156 548,420.49 115,351 4,187.82 4,828.04 5137 - TUBERCULOSIS PROGRAM 0 0.00 67,620 62,105.69 20,344 0.00 0.00 5138 - COMMUNICABLE DISEASES 0 0.00 77,717 72,534.17 2,020 0.00 0.00 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 14,228 0.00 0.00 5142 - CHILD FATALITY PREVENTION TEAM 0 0.00 7,625 3,293.66 3,960 0.00 0.00 5144 - HIV-STD COUNTY 0 0.00 22,904 19,528.32 3,786 0.00 0.00 5145 - HEALTH PROMOTION 0 0.00 82,393 79,431.17 3,992 0.00 0.00 5146 - HEALTHY COMMUNITIES 0 0.00 50,186 42,936.46 20,084 0.00 0.00 5148 - ITTS 0 0.00 55,484 55,051.06 9,091 0.00 0.00 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 358 0.00 0.00 5151 - WIC - CLIENT SERVICES 0 0.00 614,554 570,918.38 60,876 0.00 25.00 5152 - WIC - NUTRITION EDUCATION 0 0.00 166,801 150,390.07 4,955 0.00 0.00 5153 - WIC - BREASTFEEDING 0 0.00 43,401 38,215.92 1,757 0.00 0.00 5154 - WIC - PEER BREASTFEEDING 0 0.00 73,647 59,881.45 2,657 0.00 0.00 5160 - CMARC 0 0.00 371,875 335,212.47 94,073 166.14 0.00 5161 - CMARC - STATE 0 0.00 45,033 45,024.50 0 0.00 0.00 5162 - CMHRP 0 0.00 781,013 313,625.40 129,414 25.00 0.00 5170 - BIOTERRORISM 0 0.00 60,784 53,216.80 28,214 0.00 0.00 5180 - ENVIRONMENTAL SERVICES 0 0.00 1,525,283 1,358,455.02 124,216 0.00 3,844.00 5190 - HEALTH DEPARTMENT GRANTS 0 0.00 1,919,424 654,166.12 333,235 0.00 0.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,432 35,623.15 31,719.49 5310 - DSS - ADMINISTRATION 2,398,802 2,245,120.78 2,941,166 2,794,604.11 3,556,841 124,599.99 405,636.21 5311 - DSS - FRAUD PREVENTION 386,647 381,047.15 421,935 419,664.62 450,236 17,230.42 15,767.31 5320 - DSS - ADULT SERVICES 1,156,996 1,108,910.38 1,271,699 1,217,479.51 1,338,691 50,792.67 46,267.56 5321 - DSS - WORKFIRST 378,702 320,704.29 396,816 373,131.55 415,868 20,424.06 14,209.10 5322 - DSS - ENERGY PROGRAMS 1,636,534 860,566.17 1,557,687 284,774.54 401,281 3,211.39 975.60 5330 - DSS - CHILD CARE SUBSIDY 459,647 456,670.30 486,115 474,729.32 511,098 19,667.97 19,605.91 5331 - DSS - CHILD PROTECTIVE SRVCS 2,330,626 2,089,094.95 2,480,613 2,321,403.62 2,589,132 99,725.42 89,738.80 5332 - DSS - FOSTER CARE 3,993,959 3,880,305.23 6,361,621 5,159,177.19 6,426,693 109,454.24 70,240.13 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 126,204.49 109,272.91 General Fund 110 3 of 37 07.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 94,536.73 64,647.13 5353 - DSS - MEDICAID TRANSPORTATION 258,360 223,756.60 275,609 216,570.94 260,744 7,224.90 7,779.28 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 18,926.34 12,465.49 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 37,890,042 1,304,936.00 1,430,075.06 70 - EDUCATION 5910 - BOARD OF EDUCATION 26,121,589 26,121,589.00 28,301,509 28,301,509.00 30,804,606 2,567,050.50 2,343,484.12 5920 - CCCC 1,752,605 1,557,732.28 1,818,075 1,636,093.93 1,818,075 239,679.16 239,679.16 70 - EDUCATION Total 27,874,194 27,679,321.28 30,119,584 29,937,602.93 32,622,681 2,806,729.66 2,583,163.28 80 - CULTURAL & RECREATION 6110 - PARKS & RECREATION 1,752,797 1,504,187.17 1,945,628 1,836,627.94 2,167,462 297,392.95 240,018.75 6170 - MAIN LIBRARY 2,040,861 1,736,352.80 2,236,929 2,047,113.44 2,467,025 93,107.58 75,859.18 6172 - ANGIER BRANCH LIBRARY 253,527 211,733.68 278,867 264,042.58 303,057 9,784.11 8,402.05 6173 - BENHAVEN BRANCH LIBRARY 0 0.00 191,243 121,440.34 224,719 7,332.24 50.00 6175 - COATS BRANCH LIBRARY 151,658 122,622.63 172,056 159,036.07 187,073 9,541.81 6,294.46 6176 - DUNN BRANCH LIBRARY 278,839 242,816.32 341,711 321,304.52 352,080 14,458.64 10,045.86 6177 - ERWIN BRANCH LIBRARY 156,084 132,742.84 179,104 152,479.21 187,901 6,415.18 5,609.41 6199 - CULTURAL & REC APPROP 260,553 260,466.04 307,241 157,241.00 307,241 0.00 0.00 80 - CULTURAL & RECREATION Total 4,894,319 4,210,921.48 5,652,779 5,059,285.10 6,196,558 438,032.51 346,279.71 110 - GENERAL FUND EXPENSE 171,205,638 $152,210,101.12 169,027,373 $157,892,794.31 177,478,685 $7,137,620.88 $7,531,473.26 110 - GENERAL FUND REVENUE (OVER) / UNDER EXPENSES 0 $9,566,888.07 0 $3,497,574.34 0 $5,304,181.12 $5,566,355.25 General Fund 110 4 of 37 07.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 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 July 31, 2024 General Fund Cash 5 of 37 07.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 59,354.15 48,035.66 38 - MISCELLANEOUS INCOME 74,329 88,846.99 45,000 48,185.06 48,500 2,175.00 2,275.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 $61,529.15 $50,310.66 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 $11,256.64 8,434.51 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 $59,673.88 35,817.34 53 - CURRENT SRVCS 84,113 $46,912.48 63,208 $51,167.06 55,738 $3,682.13 1,446.11 54 - FIXED CHARGES 58,347 $50,298.73 51,042 $51,077.51 70,276 $28,125.47 25,199.95 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 $0.00 0.00 120 - HR JETPORT FUND EXPENSE 1,242,706 $1,049,385.91 3,819,808 $2,881,625.11 1,355,209 $102,738.12 $70,897.91 120 - HR JETPORT FUND REVENUE (OVER) / UNDER EXPENSES 0 $51,151.86 0 $147,597.73 0 $41,208.97 $20,587.25 FY 2024 FY 2024 FY 2025 Harnett Regional Jetport Fund Unaudited as of July 31, 2024 Same Period Last Year FY 2025 Same Period Last Year FY 2023 FY 2023 HRJetport Fund 120 6 of 37 07.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) 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 July 31, 2024 HRJetport Fund Cash 7 of 37 07.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 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 July 31, 2024 HRJetport Fund Inventory 8 of 37 07.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 101,513.75 110,862.50 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 $101,513.75 $110,862.50 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 $101,513.75 $110,862.50 FY 2025 Same Period Last Year Same Period Last Year American Rescue Plan Act Fund Unaudited as of July 31, 2024 FY 2023 FY 2023 FY 2024 FY 2024 FY 2025 ARPA Fund 292 9 of 37 07.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 115,615.06 81,646.25 36 - ENTERPRISE CHARGES 1,761,500 2,477,357.11 2,113,000 2,448,342.41 2,418,000 187,724.50 197,965.00 37 - FACILITY FEES 37,564,650 41,935,719.04 40,635,000 47,630,098.56 43,600,000 4,820,197.33 3,540,566.60 38 - MISCELLANEOUS INCOME 320,000 761,792.20 340,000 16,810,585.32 340,000 32,688.81 1,233,658.74 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 $5,156,225.70 $5,053,836.59 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 163,019.44 267,368.00 7113 - WATER TREATMENT PLANT 8,435,629 7,994,486.61 9,504,517 8,719,770.70 10,993,000 269,218.33 358,767.97 7115 - WASTEWATER TREATMENT PLANT 3,583,141 3,157,253.44 4,179,100 3,593,743.89 4,285,441 111,770.68 186,824.67 7117 - SOUTH HARNETT WASTEWATER PLANT 3,737,799 3,169,127.62 4,218,793 3,449,519.34 4,591,883 108,130.83 175,346.56 7119 - WATER DISTRIBUTION 6,396,571 5,348,263.00 7,439,204 6,000,175.87 7,051,813 197,011.14 378,327.46 7121 - SEWER COLLECTIONS 5,697,048 5,072,871.48 6,002,962 4,843,044.44 6,217,911 98,429.48 173,157.78 7131 - RETIREE INSURANCE HRW 63,829 64,280.10 75,824 57,113.44 55,426 2,611.00 2,769.28 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 $950,190.90 $1,542,561.72 610 - HRW FUND REVENUE (OVER) / UNDER EXPENSES 0 $32,172,278.17 0 $30,371,052.22 0 $4,206,034.80 $3,511,274.87 FY 2024 FY 2024FY 2023 Same Period Last Year Same Period Last Year Harnett Regional Water Fund Unaudited as of July 31, 2024 FY 2025 FY 2025 FY 2023 HRW Fund 610 10 of 37 07.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 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 July 31, 2024 HRW Fund Cash 11 of 37 07.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 32,112.61 34.52 36 - ENTERPRISE CHARGES 3,414,080 3,525,625.02 4,122,082 3,472,431.85 3,512,000 296,741.48 273,833.29 37 - FACILITY FEES 4,520,000 4,824,835.93 4,822,000 4,919,568.05 4,822,000 32,024.78 6,381.05 38 - MISCELLANEOUS INCOME 251,981 166,073.65 185,000 2,428,484.73 185,000 0.00 9,524.00 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 $360,878.87 $289,772.86 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 154,750.95 217,276.75 7431 - RETIREE INSURANCE SW 20,000 26,509.00 29,712 23,993.00 19,356 797.00 1,252.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 $155,547.95 $218,528.75 660 - SOLID WASTE FUND REVENUE (OVER) / UNDER EXPENSES 0 $1,626,466.06 0 $2,113,313.54 0 $205,330.92 $71,244.11 FY 2024 FY 2024FY 2023 Solid Waste Fund Unaudited as of July 31, 2024 FY 2025 FY 2025FY 2023 Same Period Last Year Same Period Last Year Solid Waste Fund 660 12 of 37 07.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 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 July 31, 2024 Solid Waste Fund Cash 13 of 37 07.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 49,724.75 44,778.15 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 49,724.75 $44,778.15 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 $363,268.83 335,996.52 810 - WORKER'S COMP FUND EXPENSE 850,000 $854,566.54 850,000 $516,873.53 850,000 $363,268.83 $335,996.52 810 - WORKERS'S COMP FUND REVENUE (OVER) / UNDER EXPENSES 0 $294,998.90 0 $26,678.20 0 $313,544.08 $291,218.37 Worker's Compensation Fund Unaudited as of July 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 07.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 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 July 31, 2024 Worker's Comp Fund Cash 15 of 37 07.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 6,605.33 10,520.22 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 6,605.33 $10,520.22 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 $6,605.33 $10,520.22 FY 2024 FY 2024FY 2023 Unemployment Insurance Fund Unaudited as of July 31, 2024 FY 2025 FY 2025FY 2023 Same Period Last Year Same Period Last Year Unemployment Ins Fund 820 16 of 37 07.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 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 July 31, 2024 Unemployment Ins Fund Cash 17 of 37 07.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 14,040.00 12,780.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 $14,040.00 $12,780.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 6,225.67 5,264.87 830 - EMPLOYEE CLINIC FUND EXPENSE 191,875 $178,079.32 228,762 $195,365.09 229,901 $6,225.67 $5,264.87 830 - EMPLOYEE CLINIC FUND REVENUE (OVER) / UNDER EXPENSES 0 $23,699.32 0 $8,920.30 0 $7,814.33 $7,515.72 Employee Clinic Fund Unaudited as of July 31, 2024 FY 2025 FY 2025FY 2023 Same Period Last Year Same Period Last Year FY 2023 FY 2024 FY 2024 Employee Clinic Fund 830 18 of 37 07.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 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 July 31, 2024 Employee Clinic Fund Cash 19 of 37 07.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 997,327.47 897,905.65 38 - MISCELLANEOUS INCOME 650,000 1,261,002.15 0 1,449,859.89 0 0.00 0.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 $997,327.47 $897,905.65 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 0.00 108,744.93 841 - MEDICAL SELF INS FUND EXPENSE 12,226,500 $10,662,369.55 12,486,500 $12,466,348.43 13,503,500 $0.00 $108,744.93 841 - MEDICAL SELF INS FUND REVENUE (OVER) / UNDER EXPENSES 0 $1,696,248.51 0 $478,928.30 0 $997,327.47 $789,160.72 FY 2024 FY 2024FY 2023 Medical Self Insurance Fund Unaudited as of July 31, 2024 FY 2025 FY 2025 Same Period Last Year Same Period Last Year FY 2023 Medical Self Ins Fund 841 20 of 37 07.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 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 July 31, 2024 Medical Self Ins Fund Cash 21 of 37 07.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 45,585.52 43,131.16 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 $45,585.52 $43,131.16 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 46,987.19 35,992.32 843 - DENTAL SELF INS FUND EXPENSE 650,000 $459,020.75 650,000 $461,934.46 650,000 $46,987.19 $35,992.32 843 - DENTAL SELF INS FUND REVENUE (OVER) / UNDER EXPENSES 0 $60,512.85 0 $108,975.45 0 $1,401.67 $7,138.84 FY 2024 FY 2024 Dental Self Insurance Fund Unaudited as of July 31, 2024 FY 2023 Same Period Last Year Same Period Last Year FY 2025 FY 2023 FY 2025 Dental Self Ins Fund 843 22 of 37 07.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 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 July 31, 2024 Dental Self Ins Fund Cash 23 of 37 07.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 37,052.66 38,153.14 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 $37,052.66 $38,153.14 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 26,482.46 24,624.21 845 - RETIREE SELF INS FUND EXPENSE 1,500,000 $1,357,594.41 1,500,000 $1,006,284.77 1,500,000 $26,482.46 $24,624.21 845 - RETIREE SELF INS FUND REVENUE (OVER) / UNDER EXPENSES 0 $51,932.21 0 $297,450.14 0 $10,570.20 $13,528.93 Retiree Self Insurance Fund Unaudited as of July 31, 2024 FY 2024 FY 2024 FY 2025 FY 2025FY 2023 FY 2023 Same Period Last Year Same Period Last Year Retiree Self Ins Fund 845 24 of 37 07.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 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 July 31, 2024 Retiree Self Ins Fund Cash 25 of 37 07.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 14,492.00 38 - MISCELLANEOUS INCOME 12,000 16,269.51 22,360 22,360.00 12,000 0.00 0.00 39 - NON-REVENUE RECEIPTS 100,000 100,000.00 484,521 0.00 0 0.00 0.00 880 - FLEET SERVICES FUND REVENUE 352,909 $238,018.51 654,889 $440,176.00 204,640 $0.00 $14,492.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 204,640 0.00 107,132.00 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 204,640 $0.00 $107,132.00 880 - FLEET SERVICES FUND REVENUE (OVER) / UNDER EXPENSES 0 $78,891.11 0 $91,767.48 0 $0.00 $92,640.00 Fleet Services Fund Unaudited as of July 31, 2024 FY 2024 FY 2024 Same Period Last Year Same Period Last Year FY 2025 FY 2025FY 2023 FY 2023 Fleet Services Fund 880 26 of 37 07.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 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 July 31, 2024 Fleet Services Fund Cash 27 of 37 07.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 0.00 38 - MISCELLANEOUS INCOME 0 1,601,809.13 1,773,310 1,695,382.86 3,434,960 2,256.55 9,587.83 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 $2,256.55 $9,587.83 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 63,712.33 331,400.70 890 - INFO TECHNOLOGY FUND EXPENSE 3,795,219 $2,647,317.05 2,123,660 $1,928,442.68 3,434,960 $63,712.33 $331,400.70 890 - INFO TECHNOLOGY FUND REVENUE (OVER) / UNDER EXPENSES 0 $1,028,501.08 0 $588,433.62 0 $61,455.78 $321,812.87 Information Technology Fund Unaudited as of July 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 07.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 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 July 31, 2024 Info Technology Fund Cash 29 of 37 07.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 0 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 226,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 226,492 8,626.83 0.00 250 - VET TREATMENT COURT EXPENSE 1,152,896 $435,225.61 1,851,304 $359,985.64 226,492 $8,626.83 $0.00 250 - VET TREATMENT COURT REVENUE (OVER) / UNDER EXPENSES 0 $48,465.05 0 $199,146.36 0 $8,626.83 $0.00 FY 2024 FY 2024 Veteran's Treatment Court Unaudited as of July 31, 2024 FY 2023 Same Period Last Year Same Period Last Year FY 2025 FY 2025FY 2023 Veteran's Treatment Court 250 30 of 37 07.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 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 July 31, 2024 Veteran's Treatment Court Cash 31 of 37 07.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(8 month)to Date1103100 310231 748,388.99$ 10,403,000$ (9,654,611.01)$ 6,935,333$ (6,186,944.34)$ 7.19%NC Sales Tax - Article 39 1103100 310233 777,528.29$ 9,000,000$ (8,222,471.71)$ 6,000,000$ (5,222,471.71)$ 8.64%NC Sales Tax - Article 40 (General Fund)1103100 310235 348,226.03$ 4,100,000$ (3,751,773.97)$ 2,733,333$ (2,385,107.30)$ 8.49%NC Sales Tax - Article 42 (General Fund)1103100 310237 590,867.64$ 6,500,000$ (5,909,132.36)$ 4,333,333$ (3,742,465.69)$ 9.09%NC Sales Tax - Article 44 & Article 44 *5242,465,010.95$ 30,003,000$ (27,537,989.05)$ 20,002,000.00$ (17,536,989.05)$ 8.22% 2118401 - 380892 302,941.29$ 3,710,014$ (3,407,072.71)$ 2,473,342.67$ (2,170,401.38)$ 8.17%NC Sales Tax Special Districts 3003100 310233 269,945.50$ 2,415,182$ (2,145,236.50)$ 1,610,121$ (1,340,175.83)$ 11.18%NC Sales Tax - Article 40 (Education)3003100 310235 539,891.00$ 5,244,640$ (4,704,749.00)$ 3,496,427$ (2,956,535.67)$ 10.29%NC Sales Tax - Article 42 (Education)3003100 310239 340,930.54$ 3,122,285$ (2,781,354.46)$ 2,081,523$ (1,740,592.79)$ 10.92%NC Sales Tax - Article 461,150,767.04$ 10,782,107$ (9,631,339.96)$ 7,188,071.33$ (6,037,304.29)$ 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 07.2024 Monthly Master HARNETT COUNTY FINANCIAL SUMMARY REPORT 10/24/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 07.2024 Monthly Master HARNETT COUNTY FINANCIAL SUMMARY REPORT 10/24/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 07.2024 Monthly Master HARNETT COUNTY FINANCIAL SUMMARY REPORT 10/24/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 07.2024 Monthly Master HARNETT COUNTY FINANCIAL SUMMARY REPORT 10/24/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 07.2024 Monthly Master HARNETT COUNTY FINANCIAL SUMMARY REPORT 10/24/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 07.2024 Monthly Master