Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
July 2021 Financial Report
Revenue Category Budget Actual Budget Actual Budget Actual 30 - TAXES - AD VALOREM 66,079,417 67,452,336.92 66,850,000 70,991,210.26 69,100,000 296,645.42 224,505.34 31 - TAXES - SALES 18,265,000 20,597,227.82 18,400,000 21,643,370.84 22,300,000 0.00 0.00 32 - TAXES - OTHER 572,000 736,457.89 530,000 1,012,526.63 730,000 114,017.64 1,006.23 33 - INTRGVRNMNTL - FEDRL 15,358,264 14,502,831.23 17,355,230 14,821,469.56 14,562,823 108,629.19 193,945.42 34 - INTRGVRNMNTL - STATE 6,686,121 8,284,382.38 6,483,859 8,389,141.85 5,914,982 256,948.66 29,892.80 35 - SERVICE CHARGES 16,781,629 14,237,895.08 15,319,535 13,983,228.15 13,629,786 819,183.06 982,031.17 36 - ENTERPRISE CHARGES 5,000 4,262.92 3,000 1,672.35 1,600 0.00 200.00 38 - MISCELLANEOUS INCOME 2,276,907 5,407,368.98 1,551,807 1,800,799.33 1,682,702 26,578.37 73,820.38 39 - NON-REVENUE RECEIPTS 4,054,805 644,682.10 11,942,137 2,024,968.00 3,411,812 0.00 0.00 110 - GENERAL FUND REVENUE $130,079,143 $131,867,445.32 138,435,568 $134,668,386.97 $131,333,705 $1,622,002.34 $1,505,401.34 Expense Function Department Budget Actual Budget Actual Budget Actual 110 - GENERAL 00 - GENERAL GOVERNMENT 4110 - GOVERNING BODY 405,127 373,092.30 788,447 735873.75 580,288 21,502.31 37,056.62 4120 - COUNTY ADMINISTRATION 908,274 888,035.06 1,036,614 958958.46 978,060 57,794.99 48,270.16 4130 - FINANCE 1,506,606 1,411,933.85 1,306,824 1274227.36 1,390,508 69,076.48 98,501.65 4131 - RETIREE INSURANCE 571,000 571,000.00 882,000 836451.90 882,000 35,638.41 66,431.88 4140 - TAX 1,746,836 1,554,218.86 1,551,703 1338572.76 1,798,582 42,253.52 72,974.37 4150 - LEGAL SERVICES 356,342 309,378.48 363,565 316696.52 317,941 12,669.72 14,723.95 4160 - HUMAN RESOURCES 480,451 432,931.39 505,151 473168.01 773,466 235,787.26 30,600.27 4170 - BOARD OF ELECTIONS 561,515 458,625.51 597,465 513806.67 419,439 11,717.56 38,969.60 4180 - CLERK OF COURT 93,433 42,782.84 26,083 12142.04 22,283 0.00 445.65 4190 - REGISTER OF DEEDS 884,396 821,751.63 889,071 727972.23 729,535 24,960.49 30,583.39 4210 - GENERAL SERVICES 222,831 221,242.15 227,775 226110.68 233,856 9,361.27 10,219.87 4230 - FACILITIES MAINTENANCE 3,447,272 2,978,382.48 3,610,387 3283052.36 3,087,866 145,287.85 125,234.77 4250 - FLEET MAINTENANCE 684,307 665,435.73 629,738 604484.85 692,444 58,420.30 32,784.90 4270 - INFORMATION TECHNOLOGY 2,589,405 2,484,827.31 2,554,198 2473071.76 2,445,345 58,032.57 123,361.55 4290 - GIS 765,223 737,924.98 700,709 656829.02 759,998 44,820.95 48,575.95 9800 - INTERFUND TRANSFERS 15,303,912 15,290,048.00 21,454,238 21445647.00 14,374,297 0.00 0.00 9910 - CONTINGENCY 196,450 0.00 454,020 0.00 915,000 0.00 0.00 00 - GENERAL GOVERNMENT Total $30,723,380 $29,241,610.57 37,577,988 $35,877,065.37 30,400,908 827,323.68 778,734.58 10 - PUBLIC SAFETY 4310 - SHERIFF 11,714,191 11,385,405.62 12,192,507 11698458.70 12,754,670 406,352.28 526,049.27 4330 - CAMPBELL DEPUTIES 551,807 476,310.20 477,204 461426.43 528,160 18,262.55 21,330.26 FY 2022 FY 2022 as of July 31, 2021 General Fund FY 2020 FY 2021 FY 2021 Same Period Last Year FY 2020 Same Period Last Year General Fund 110 1 of 32 07.2021 Monthly Master Expense Function Department Budget Actual Budget Actual Budget Actual FY 2022FY 2020 FY 2021 Same Period Last Year 4350 - SCHOOL RESOURCE OFFICER 2,301,216 1,341,492.52 2,254,482 1490552.81 2,083,102 58,030.53 57,859.22 4370 - CHILD SUPPORT ENFORCEMENT 86,495 59,949.60 71,676 65330.29 79,244 2,808.83 2,474.31 4390 - JAIL 5,950,242 5,592,459.65 5,836,177 5616242.30 6,146,234 143,931.34 234,412.59 4410 - EMERGENCY MANAGEMENT 1,058,089 1,006,385.67 1,004,854 884379.22 953,188 65,652.20 67,620.56 4411 - EMERGENCY SERVICES GRANTS 567,249 565,394.86 208,975 206851.32 54,279 0.00 0.00 4450 - EMERGENCY MEDICAL SERVICE 8,070,165 7,615,472.99 9,162,453 8034369.43 8,747,659 421,409.33 397,434.45 4451 - EMS TRANSPORTS 0 0.00 0 0.00 0 0.00 0.00 4470 - RESCUE DISTRICTS 3,673,427 3,673,427.00 3,673,427 3673427.00 4,152,210 630,605.04 3,673,427.00 4510 - FIELD SERVICES 324,321 282,242.96 321,672 293120.94 315,785 10,143.37 11,970.83 4512 - ANIMAL SHELTER 330,074 219,190.31 359,570 243535.11 331,611 7,813.99 10,592.33 4530 - MEDICAL EXAMINER 125,000 121,050.00 95,000 87000.00 100,000 0.00 3,700.00 4570 - COMMUNICATIONS 1,999,555 1,868,768.01 1,762,248 1579139.43 1,954,386 54,901.23 81,667.17 4915 - INSPECTIONS 0.00 $0.00 0 $24,583.76 870,247 25,105.56 0.00 10 - PUBLIC SAFETY Total $36,751,831 $34,207,549.39 37,420,245 $34,358,416.74 39,070,775 1,845,016.25 5,088,537.99 20 - TRANSPORTATION 4610 - TRANSPORTATION 1,523,304 1,082,398.03 1,513,691 947317.55 1,511,616 30,589.42 40,167.06 4630 - TRANSPORTATION - ADMIN 663,619 492,512.68 739,696 706044.94 604,040 33,258.78 10,148.32 4650 - HARNETT REGIONAL JETPORT 244,776 198,852.98 509,520 432235.73 634,362 518.70 3,017.00 20 - TRANSPORTATION Total $2,431,699 $1,773,763.69 2,762,907 $2,085,598.22 2,750,018 64,366.90 53,332.38 30 - ENVIRONMENTAL PROTECTION 4710 - SOIL & WATER 234,187 222,440.11 237,233 218127.00 245,552 8,997.17 10,478.98 4730 - FORESTRY PROGRAM 136,272 124,123.36 138,026 135320.77 125,852 0.00 0.00 4750 - ENVIROMENTAL PROT ALLOC 4,000 4,000.00 6,000 6000.00 12,000 0.00 0.00 30 - ENVIRONMENTAL PROTECTION Total $374,459 $350,563.47 381,259 $359,447.77 383,404 8,997.17 10,478.98 40 - ECONOMIC & PHYSICAL DEVELOPMNT 4910 - DEVELOPMENT SERVICES 1,860,624 1,551,440.18 1,665,394 1610433.95 992,417 81,225.47 67,788.93 4930 - ECONOMIC DEVELOPMENT 1,029,298 729,534.58 777,877 670120.00 1,036,973 55,800.54 56,730.29 4950 - COMMUNITY DEVELOPMENT 1,375 192.45 925 554.81 455 0.51 0.00 4951 - ABANDONED MFG HOME 30,854 26,962.71 0 0.00 0 0.00 1,141.97 4990 - COOPERATIVE EXTENSION 408,665 355,800.19 405,145 325576.32 393,878 4,523.21 5,636.58 4995 - COOPERATIVE EXT SPECIAL PROG 283,018 211,037.23 170,152 80618.74 112,366 2,364.13 3,069.56 40 - ECONOMIC & PHYSICAL DEVELOPMNT Total $3,613,834 $2,874,967.34 3,019,493 $2,687,303.82 2,536,089 143,913.86 134,367.33 50 - HUMAN SERVICES 5110 - HEALTH - ADMINISTRATION 6,635,444 5,609,257.46 7,370,852 5624895.57 6,158,055 196,637.90 270,155.28 5120 - HEALTH - LABORATORY SERVICE 0 0.00 0 0.00 0 0.00 0.00 5130 - HEALTH - ADULT SERVICES 0 0.00 0 0.00 0 0.00 0.00 5140 - HEALTH - MATERNAL & CHLD SRVCS 0 0.00 0 0.00 0 0.00 0.00 5150 - HEALTH - WIC 0 0.00 0 0.00 0 0.00 0.00 5160 - HEALTH - SENIOR SERVICES 1,401,534 1,307,710.38 1,679,594 1460031.51 1,513,551 29,087.91 54,185.49 5170 - HEALTH - COMMUNICABLE DISEASES 0 0.00 0 0.00 0 0.00 0.00 5180 - HEALTH - ENVIRONMENTAL SRVCS 0 0.00 0 0.00 0 0.00 0.00 5210 - MENTAL HEALTH 605,679 605,679.00 605,679 605679.00 605,679 0.00 205,679.00 General Fund 110 2 of 32 07.2021 Monthly Master Expense Function Department Budget Actual Budget Actual Budget Actual FY 2022FY 2020 FY 2021 Same Period Last Year 5310 - DSS - ADMINISTRATION 2,613,128 2,388,014.64 2,436,585 1938491.47 2,038,570 54,453.24 234,310.58 5311 - DSS - FRAUD PREVENTION 264,033 231,968.94 297,397 293041.26 340,031 13,770.04 13,442.73 5320 - DSS - ADULT SERVICES 1,133,036 1,099,638.00 888,982 834077.28 1,011,567 33,604.66 35,145.10 5321 - DSS - WORKFIRST 344,636 269,512.32 303,231 281561.51 352,353 12,298.70 13,052.95 5322 - DSS - ENERGY PROGRAMS 1,117,949 1,122,625.44 1,374,286 1220383.03 1,179,758 30,483.18 31,917.39 5330 - DSS - CHILD CARE SUBSIDY 2,900,405 2,650,694.52 376,627 366092.70 414,877 16,767.50 16,766.86 5331 - DSS - CHILD PROTECTIVE SRVCS 59,098 24,615.13 2,127,436 2003875.90 2,104,903 82,774.00 93,546.91 5332 - DSS - FOSTER CARE 1,752,348 1,547,642.72 2,711,023 2491923.63 2,801,953 48,258.51 54,646.15 5333 - DSS - ADOPTION 480,710 271,332.20 397,847 290006.27 389,469 18,671.81 20,412.32 5334 - DSS - DAY CARE 254,662 185,388.79 22,315 0.00 0 0.00 0.00 5340 - DSS - CHILD SUPPORT 1,328,691 1,190,151.75 1,331,417 1210490.69 1,397,305 54,117.13 60,578.39 5350 - DSS - MEDICAID 0 0.00 0 0.00 0 0.00 0.00 5351 - DSS - ADULT MEDICAID 2,491,982 2,212,563.34 2,215,437 2042205.93 2,334,126 97,957.56 129,122.19 5352 - DSS - FAMILY & CHLDRN MEDICAID 1,565,673 1,463,483.95 1,541,975 1500968.29 1,645,932 64,497.10 69,661.65 5353 - DSS - MEDICAID TRANSPORTATION 147,593 64,879.10 211,078 190776.42 216,148 5,919.75 6,743.54 5360 - DSS - TEMPORARY RESOURCES 0 0.00 124 0.00 0 0.00 0.00 5390 - DSS - TRUST ACCOUNTS 0 0.00 0 0.00 0 0.00 0.00 5810 - VETERANS SERVICES 299,545 270,170.03 304,997 242299.03 316,223 10,696.43 10,138.73 5870 - RESTITUTION 102,017 93,474.71 82,712 79168.66 93,831 4,332.40 3,450.04 5895 - HUMAN SERVICES APPROPRIATIONS 37,688 31,117.70 32,000 0.00 0 0.00 7,741.00 60 - DEBT SERVICES Total $0.00 $0.00 0 $0.00 0 0.00 0.00 70 - EDUCATION 5910 - BOARD OF EDUCATION 24,680,603 24,680,603.00 24,680,603 24680603.00 24,680,603 2,056,716.99 24,680,603.00 5920 - CCCC 1,626,978 1,551,147.64 1,621,978 1359842.33 1,812,631 0.00 578,488.98 70 - EDUCATION Total $26,307,581 $26,231,750.64 26,302,581 $26,040,445.33 26,493,234 2,056,716.99 25,259,091.98 80 - CULTURAL & RECREATION 6110 - PARKS & RECREATION 1,326,751 1,172,372.50 1,399,432 1224670.05 1,482,442 195,001.44 218,246.44 6170 - LIBRARY 1,335,059 1,058,294.68 1,542,378 1286836.53 1,564,894 47,160.21 51,783.52 6199 - CULTURAL & REC APPROP 219,196 172,360.00 219,187 184589.00 150,000 0.00 0.00 80 - CULTURAL & RECREATION Total $2,881,006 $2,403,027.18 3,160,997 $2,696,095.58 3,197,336 242,161.65 270,029.96 110 - GENERAL FUND EXPENSE $130,079,143 $121,013,796.40 $138,435,568 $128,253,219.70 $131,333,705 $6,025,183.23 $32,995,690.15 110 - GENERAL FUND REVENUE OVER / UNDER EXPENSES $0 $10,853,648.92 0 $6,415,167.27 $0 $4,403,180.89 $31,490,288.81 General Fund 110 3 of 32 07.2021 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Month 2020 2021 2022 2023 July $33,238,397.31 $47,538,800.11 August $30,766,642.59 September $31,436,740.68 October $32,621,237.60 November $55,769,435.23 December $52,235,231.63 January $49,307,366.28 $53,866,338.79 February $46,553,686.81 $52,436,827.11 March $48,087,241.40 $54,342,302.91 April $45,974,675.17 $53,069,840.69 May $41,927,274.60 $52,231,160.24 June $40,106,511.08 $48,728,591.98 General Fund as of July 31, 2021 CASH General Fund Cash 4 of 32 07.2021 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 33 - INTRGVRNMNTL - FEDRL 0 52,772.00 27,314 27,314.20 0 0.00 0.00 35 - SERVICE CHARGES 0 0.00 38,031 27,108.30 0 33,316.62 0.00 38 - MISCELLANEOUS INCOME 9,465 7,835.00 7,385 6,395.00 0 450.00 0.00 120 - HR JETPORT FUND REVENUE $9,465 $60,607.00 $72,730 $60,817.50 $0 $33,766.62 $0.00 Revenue Category Budget Actual Budget Actual Budget Actual 110 - GENERAL 4650 - HARNETT REGIONAL JETPORT 50 - SALARIES & BENEFITS 100 $0.00 7,145 $6,439.23 0 $6,439.03 0.00 51 - PROFESSIONAL SRVCS 9,000 $0.00 0 $0.00 0 $0.00 0.00 52 - SUPPLIES & MATERIALS 10,841 $3,160.73 62,111 $65,999.10 0 $0.00 0.00 53 - CURRENT SRVCS 75,893 $48,772.25 38,828 $32,623.76 0 $1,344.96 0.00 54 - FIXED CHARGES 148,942 $146,920.00 191,626 $151,089.63 0 $20,812.00 0.00 55 - CAPITAL OUTLAY 0 $0.00 160,000 $158,047.49 0 $0.00 0.00 58 - NON-CAPTALIZED ASSTS 0 $0.00 49,810 $18,036.52 0 $0.00 0.00 70 - PCARD ENCUMBRANCE 0 $0.00 0 $0.00 0 $0.00 0.00 120 - HR JETPORT FUND REVENUE $244,776 $198,852.98 $509,520 $432,235.73 $0 $28,595.99 $0.00 120 - HR JETPORT FUND REVENUE OVER / UNDER EXPENSES $235,311 $190,202.36 $172,046 $138,035.48 $0 $5,170.63 $0.00 FY 2022 Same Period Last Year FY 2020 FY 2021 Same Period Last Year Harnett Regional Jetport Fund as of July 31, 2021 FY 2020 FY 2021 FY 2022 HRJetport Fund 120 5 of 32 07.2021 Monthly Master Airport Avgas 4/19 JetA 4/19 Avgas 6/23 JetA 6/23 Avgas 6/29 JetA 6/29 Avgas 7/19 JetA 7/19 Avgas 7/30 JetA 7/30 Avgas 8/16 JetA 8/16 Harnett Regional Jetport 4.75$ 4.99$ 4.25$ 4.13$ 4.25$ 4.13$ 4.25$ 4.13$ 4.25$ 4.13$ 4.39$ 3.99$ Johnston County 4.31$ 4.08$ 4.44$ 4.15$ 4.44$ 4.15$ 4.44$ 4.22$ 4.44$ 4.30$ 4.44$ 4.49$ Rocky Mount- Wilson 3.99$ 3.25$ 4.29$ 3.49$ 4.49$ 3.69$ 4.49$ 3.69$ 4.49$ 3.74$ 4.49$ 3.74$ Whiteville $ - $ - $ - $ - $ - $ - $ - $ - 4.50$ 3.10$ 4.50$ 3.10$ Lumberton 4.16$ 3.18$ 4.16$ 3.18$ 4.16$ 3.18$ 4.55$ 3.57$ 4.55$ 3.57$ 4.55$ 3.57$ Elizabethtown 4.59$ 3.29$ 4.59$ 3.59$ 4.59$ 3.59$ 4.59$ 3.59$ 4.59$ 3.59$ 4.59$ 3.59$ Mount Olive 4.27$ 3.27$ 4.48$ 3.39$ 4.48$ 3.59$ 4.62$ 3.59$ 4.62$ 3.65$ 4.62$ 3.65$ Wayne Executive (Goldsboro)4.44$ 3.20$ 4.44$ 3.20$ 4.44$ 3.20$ 4.63$ 3.51$ 4.63$ 3.51$ 4.63$ 3.51$ Clinton 5.10$ 4.75$ 4.69$ 4.19$ 4.69$ 4.19$ 4.69$ 4.19$ 4.69$ 4.19$ 4.71$ 4.19$ Duplin County 4.21$ 3.80$ 4.73$ 4.00$ 4.73$ 4.00$ 4.72$ 4.17$ 4.73$ 4.18$ 4.73$ 4.18$ Siler City 4.49$ 3.99$ 4.49$ 3.99$ 4.59$ 4.49$ 4.79$ 4.49$ 4.79$ 4.49$ 4.79$ 4.49$ Gray's Creek 4.90$ NA 4.90$ NA 4.90$ NA 4.90$ NA 4.80$ NA 4.80$ NA Lauringburg-Maxton $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 5.05$ 4.69$ Moore County 5.10$ 4.75$ 5.10$ 4.75$ 5.10$ 4.75$ 5.10$ 4.75$ 5.10$ 4.75$ 5.20$ 4.85$ Triangle North $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 5.35$ 4.29$ Raleigh Exec 5.10$ 4.30$ 5.27$ 4.49$ 5.27$ 4.59$ 5.39$ 4.59$ 5.39$ 4.59$ 5.39$ 4.62$ Fayetteville 6.13$ 5.95$ 6.13$ 6.22$ 6.13$ 6.22$ 6.13$ 6.26$ 6.13$ 6.27$ 6.13$ 6.29$ Average of All Others 4.68$ 3.98$ 4.75$ 4.05$ 4.77$ 4.14$ 4.85$ 4.22$ 4.82$ 4.15$ 4.87$ 4.22$ KHRJ Fuel Price Comparison with Surrounding Airports By Date Types (AvGas - JetA) CY 21 Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Month 2020 2021 2022 2023 July $0.00 $22,906.24 August $0.00 September $0.00 October $0.00 November $0.00 December $0.00 January $0.00 $0.00 February $0.00 $0.00 March $0.00 $0.00 April $0.00 $0.00 May $0.00 $0.00 June $0.00 $0.00 Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Month 2020 2021 2022 2023 July $0.00 $59,505.03 August $0.00 September $0.00 October $0.00 November $0.00 December $0.00 January $0.00 $0.00 February $0.00 $0.00 March $0.00 $0.00 April $0.00 $0.00 May $0.00 $0.00 June $0.00 $47,065.45 CASH Harnett Regional Jetport as of July 31, 2021 INVENTORY HRJetport Fund Cash 7 of 32 07.2021 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 33 - INTRGVRNMNTL - FEDRL 3,703 0.00 3,703 325,618.70 3,703 0.00 0.00 35 - SERVICE CHARGES 15,000 143,502.18 10,581 2,561.90 10,000 217.94 0.00 36 - ENTERPRISE CHARGES 1,381,500 1,671,386.38 1,583,500 1,620,856.41 1,384,000 244,855.00 185,793.95 37 - FACILITY FEES 32,575,000 37,720,428.29 34,600,000 38,712,811.96 35,875,000 2,951,402.13 3,391,669.15 38 - MISCELLANEOUS INCOME 705,000 7,993,723.20 710,000 4,489,826.80 525,858 37,915.70 161,637.98 39 - NON-REVENUE RECEIPTS 7,672,747 0.00 14,305,000 0.00 0 0.00 0.00 610 - HRW FUND REVENUE $42,352,950 $47,529,040.05 $51,212,784 $45,151,675.77 $37,798,561 $3,234,390.77 $3,739,101.08 Expense Function Department Budget Actual Budget Actual Budget Actual 610 - HARNETT REGIONAL WATER 91 - WATER & SEWER 7111 - HRW ADMINISTRATION 19,689,398 28,937,487.52 28,373,613 37,638,395.88 13,345,618 195,465.26 185,697.43 7113 - WATER TREATMENT PLANT 6,569,748 5,422,700.11 5,966,684 4,993,113.82 6,561,391 200,487.11 119,918.77 7115 - WASTEWATER TREATMENT PLANT 3,062,790 2,054,660.74 3,385,564 3,021,922.21 3,675,108 116,703.44 55,111.06 7117 - SOUTH HARNETT WASTEWATER PLANT 3,173,670 2,210,178.83 2,975,213 2,448,459.74 3,590,345 148,963.52 102,492.39 7119 - WATER DISTRIBUTION 5,167,052 4,089,298.68 5,065,366 4,378,288.47 5,004,770 195,643.48 140,869.99 7121 - SEWER COLLECTIONS 4,690,292 4,075,030.16 5,446,344 4,314,851.16 5,560,522 70,523.77 64,223.45 7131 - RETIREE INSURANCE HRW 0 0.00 0 57,918.05 60,807 2,569.64 4,324.00 610 - HRW FUND EXPENSE $42,352,950 $46,789,356.04 $51,212,784 $56,852,949.33 $37,798,561 $930,356.22 $672,637.09 610 - HRW FUND REVENUE OVER / UNDER EXPENSES $0 $739,684.01 $0 $11,701,273.56 $0 $2,304,034.55 $3,066,463.99 Same Period Last Year Same Period Last Year Harnett Regional Water Fund as of July 31, 2021 FY 2020 FY 2021 FY 2021 FY 2022 FY 2020 FY 2022 HRW Fund 610 8 of 32 07.2021 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Month 2020 2021 2022 2023 July $56,308,485.60 $57,021,331.08 August $57,887,471.15 September $53,052,496.69 October $41,972,645.61 November $44,623,020.08 December $46,244,526.10 January $57,818,912.12 $47,842,388.74 February $58,911,946.79 $49,655,875.28 March $60,961,613.87 $51,249,479.82 April $60,643,544.18 $52,788,896.94 May $61,748,714.89 $55,026,201.87 June $62,092,603.76 $50,696,430.07 Harnett Regional Water Fund as of July 31, 2021 CASH HRW Fund Cash 9 of 32 07.2021 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 34 - INTRGVRNMNTL - STATE 260,000 283,640.35 282,000 299,010.13 260,000 0.00 0.00 35 - SERVICE CHARGES 0 6,122.07 553 2,072.25 0 0.00 62.58 36 - ENTERPRISE CHARGES 1,930,200 2,515,403.09 1,910,200 3,114,682.13 1,910,000 103,454.87 99,172.71 37 - FACILITY FEES 3,550,000 3,760,202.26 4,581,020 4,648,605.96 4,520,000 36,732.90 30,546.27 38 - MISCELLANEOUS INCOME 70,200 51,846.93 100,733 539,571.68 45,000 411,919.35 3,731.55 39 - NON-REVENUE RECEIPTS 0 0.00 0 0.00 0 0.00 0.00 660 - SOLID WASTE FUND REVENUE $5,810,400 $6,617,214.70 $6,874,506 $8,603,942.15 $6,735,000 $552,107.12 $133,513.11 Expense Function Department Budget Actual Budget Actual Budget Actual 660 - SOLID WASTE MANAGEMENT 96 - SOLID WASTE 7410 - SOLID WASTE MANAGEMENT 5,810,400 5,283,770.49 6,874,506 6,696,742.17 6,715,000 144,366.28 104,409.67 7431 - RETIREE INSURANCE SW 0 9,717.30 0 20,588.95 20,000 847.52 1,635.12 660 - SOLID WASTE FUND EXPENSE $5,810,400 $5,293,487.79 $6,874,506 $6,717,331.12 $6,735,000 $145,213.80 $106,044.79 660 - SOLID WASTE FUND REVENUE OVER / UNDER EXPENSES $0 $1,323,726.91 $0 $1,886,611.03 $0 $406,893.32 $27,468.32 FY 2022 Same Period Last Year FY 2020 FY 2021 Same Period Last Year FY 2021 Solid Waste Fund as of July 31, 2021 FY 2020 FY 2022 Solid Waste Fund 660 10 of 32 07.2021 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Month 2020 2021 2022 2023 July $3,387,995.72 $5,230,435.74 August $3,375,944.64 September $3,607,274.52 October $3,759,678.53 November $5,581,197.69 December $6,451,303.81 January $4,616,721.91 $5,784,640.53 February $4,751,271.26 $5,844,033.09 March $4,565,672.41 $5,773,139.20 April $4,268,648.15 $5,713,193.95 May $4,194,405.45 $5,677,132.65 June $3,584,698.74 $5,645,699.28 Solid Waste Fund as of July 31, 2021 CASH Solid Waste Fund Cash 11 of 32 07.2021 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 1,100,000 939,774.61 1,200,000 1,134,569.36 760,000 53,469.44 81,650.78 38 - MISCELLANEOUS INCOME 1,003,788 994,240.57 0 1,350.81 0 120.78 118.45 39 - NON-REVENUE RECEIPTS 0 0.00 11,700 0.00 0 0.00 0.00 810 - WORKER'S COMP FUND REVENUE $2,103,788 $1,934,015.18 $1,211,700 $1,135,920.17 $760,000 $53,590.22 $81,769.23 Expense Function Department Budget Actual Budget Actual Budget Actual 810 - WORKERS COMPENSATION FUND 00 - GENERAL GOVERNMENT 9301 - WORKER'S COMPENSATION 2,103,788 1,415,657.00 1,211,700 471,708.73 760,000 $31,487.80 163,430.00 810 - WORKER'S COMP FUND EXPENSE $2,103,788 $1,415,657.00 $1,211,700 $471,708.73 $760,000 $31,487.80 $163,430.00 810 - WORKERS'S COMP FUND REVENUE OVER / UNDER EXPENSES $0 $1,496,059.35 $0 $518,358.18 $0 $22,102.42 $81,660.77 Same Period Last Year Same Period Last Year FY 2020 FY 2021 FY 2021 Worker's Compensation Fund as of July 31, 2021 FY 2020 FY 2022 FY 2022 Worker's Comp Fund 810 12 of 32 07.2021 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Month 2020 2021 2022 2023 July $4,629,563.32 $5,397,537.95 August $4,708,459.01 September $4,785,314.35 October $4,844,771.48 November $4,925,635.39 December $4,982,050.03 January $3,318,944.43 $5,056,960.44 February $3,402,272.55 $5,098,194.24 March $4,462,485.39 $5,134,695.99 April $4,544,990.12 $5,193,817.86 May $4,545,144.92 $5,139,295.68 June $4,627,680.64 $5,334,540.35 Worker's Compensation Fund as of July 31, 2021 CASH Worker's Comp Fund Cash 13 of 32 07.2021 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 100,000 202,177.75 250,000 221,464.63 250,000 4,476.41 17,667.46 39 - NON-REVENUE RECEIPTS 0 0.00 0 0.00 0 0.00 0.00 820 - UNEMPLOYMENT FUND REVENUE $100,000 $202,177.75 $250,000 $221,464.63 $250,000 $4,476.41 $17,667.46 Expense Function Department Budget Actual Budget Actual Budget Actual 820 - UNEMPLOYMENT INSURANCE 00 - GENERAL GOVERNMENT 9305 - UNEMPLOYMENT INSURANCE 100,000 $16,752.83 250,000 $19,734.22 250,000 $0.00 0.00 820 - UNEMPLOYMENT FUND EXPENSE $100,000 $16,752.83 $250,000 $19,734.22 $250,000 $0.00 $0.00 820 - UNEMPLOYMENT FUND REVENUE OVER / UNDER EXPENSES $0 $193,123.89 $0 $185,424.92 $0 $4,476.41 $17,667.46 Same Period Last Year Same Period Last Year FY 2022 FY 2022 Unemployment Insurance Fund as of July 31, 2021 FY 2020 FY 2020 FY 2021 FY 2021 Unemployment Ins Fund 820 14 of 32 07.2021 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Month 2020 2021 2022 2023 July $1,564,861.07 $1,753,400.43 August $1,582,832.12 September $1,600,689.65 October $1,618,305.74 November $1,638,946.38 December $1,657,035.68 January $1,474,589.24 $1,675,333.87 February $1,475,924.07 $1,673,523.80 March $1,493,866.97 $1,691,308.04 April $1,511,420.05 $1,709,071.02 May $1,511,420.05 $1,709,071.02 June $1,529,156.27 $1,744,442.12 Unemployment Insurance Fund as of July 31, 2021 CASH Unemployment Ins Fund Cash 15 of 32 07.2021 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 173,720 195,434.80 174,690 158,707.77 180,900 6,247.23 12,705.00 38 - MISCELLANEOUS INCOME 6,000 6,000.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 $179,720 $201,434.80 $174,690 $158,707.77 $180,900 $6,247.23 $12,705.00 Expense Function Department Budget Actual Budget Actual Budget Actual 830 - EMPLOYEE CLINIC 00 - GENERAL GOVERNMENT 9302 - EMPLOYEE CLINIC 179,720 163,177.85 174,690 166,113.38 180,900 0.00 5,677.89 830 - EMPLOYEE CLINIC FUND EXPENSE $179,720 $163,177.85 $174,690 $166,113.38 $180,900 $0.00 $5,677.89 830 - EMPLOYEE CLINIC FUND REVENUE OVER / UNDER EXPENSES $0 $25,543.54 $0 $38,256.95 $0 $6,247.23 $7,027.11 Same Period Last Year Same Period Last Year FY 2020 FY 2021 FY 2021 FY 2022 Employee Clinic Fund as of July 31, 2021 FY 2020 FY 2022 Employee Clinic Fund 830 16 of 32 07.2021 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Month 2020 2021 2022 2023 July $700,090.56 $692,061.11 August $697,900.58 September $697,339.53 October $696,760.57 November $695,238.45 December $697,288.04 January $653,534.82 $696,374.16 February $653,489.63 $691,759.00 March $655,093.01 $690,369.37 April $655,094.11 $691,478.87 May $639,617.51 $679,723.63 June $668,125.25 $683,750.26 Employee Clinic Fund as of July 31, 2021 CASH Employee Clinic Fund Cash 17 of 32 07.2021 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 9,033,000 9,578,505.48 11,296,710 9,675,931.67 9,500,000 420,156.74 812,991.40 38 - MISCELLANEOUS INCOME 113,442 120,058.34 17,875 12,867.15 12,000 0.00 12,746.37 39 - NON-REVENUE RECEIPTS 0 0.00 1,000,000.00 0.00 0 0.00 0.00 841 - MEDICAL SELF INS FUND REVENUE $9,146,442 $9,698,563.82 $12,314,585 $9,688,798.82 $9,512,000 $420,156.74 $825,737.77 Expense Function Department Budget Actual Budget Actual Budget Actual 841 - MEDICAL INSURANCE - SELF 00 - GENERAL GOVERNMENT 9303 - MEDICAL INSURANCE - SELF 9,146,442 7,438,276.99 12,314,585 8,806,381.42 9,512,000 700,678.42 719,623.60 841 - MEDICAL SELF INS FUND EXPENSE $9,146,442 $7,438,276.99 $12,314,585 $8,806,381.42 $9,512,000 $700,678.42 $719,623.60 841 - MEDICAL SELF INS FUND REVENUE OVER / UNDER EXPENSES $0 $1,428,059.57 $0 $2,260,286.83 $0 $280,521.68 $106,114.17 FY 2022 Same Period Last Year Same Period Last Year FY 2021 FY 2021 FY 2022 Medical Self Insurance Fund as of July 31, 2021 FY 2020 FY 2020 Medical Self Ins Fund 841 18 of 32 07.2021 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Month 2020 2021 2022 2023 July $8,394,410.05 $9,102,909.87 August $8,309,827.07 September $8,147,930.01 October $8,437,620.01 November $8,763,538.51 December $9,045,130.83 January $7,007,592.83 $8,831,273.60 February $7,354,736.35 $9,169,687.18 March $7,342,921.96 $8,848,785.68 April $7,508,905.85 $9,411,546.73 May $7,195,825.04 $8,592,344.42 June $6,837,286.28 $8,642,780.68 Medical Self Insurance Fund as of July 31, 2021 CASH Medical Self Ins Fund Cash 19 of 32 07.2021 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 550,000 498,921.24 633,500 512,570.71 550,000 21,478.14 42,860.03 39 - NON-REVENUE RECEIPTS 0 0.00 0 0.00 0 0.00 0.00 843 - DENTAL SELF INS FUND REVENUE $550,000 $498,921.24 $633,500 $512,570.71 $550,000 $21,478.14 $42,860.03 Expense Function Department Budget Actual Budget Actual Budget Actual 843 - DENTAL INSURANCE - SELF 00 - GENERAL GOVERNMENT 9307 - DENTAL INSURANCE - SELF 550,000 455,407.48 633,500 435,870.63 550,000 37,532.92 36,784.91 843 - DENTAL SELF INS FUND EXPENSE $550,000 $455,407.48 $633,500 $435,870.63 $550,000 $37,532.92 $36,784.91 843 - DENTAL SELF INS FUND REVENUE OVER / UNDER EXPENSES $0 $140,950.29 $0 $43,513.76 $0 $16,054.78 $6,075.12 Same Period Last Year Same Period Last Year FY 2020 FY 2021 FY 2021 FY 2022 Dental Self Insurance Fund as of July 31, 2021 FY 2020 FY 2022 Dental Self Ins Fund 843 20 of 32 07.2021 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Month 2020 2021 2022 2023 July $612,444.32 $693,576.82 August $602,629.10 September $609,678.56 October $603,363.16 November $620,268.72 December $653,169.60 January $536,850.80 $657,824.44 February $547,206.22 $665,545.09 March $544,639.17 $673,523.14 April $551,952.84 $676,078.18 May $551,708.84 $605,182.75 June $544,280.85 $657,414.23 Dental Self Insurance Fund as of July 31, 2021 CASH Dental Self Ins Fund Cash 21 of 32 07.2021 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 1,320,000 1,760,442.82 1,965,000 896,249.40 1,500,000 23,430.38 33,702.49 36 - ENTERPRISE CHARGES 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 845 - RETIREE SELF INS FUND REVENUE $1,320,000 $1,760,442.82 $1,965,000 $896,249.40 $1,500,000 $23,430.38 $33,702.49 Expense Function Department Budget Actual Budget Actual Budget Actual 845 - MEDICAL INSURANCE RETIREE 00 - GENERAL GOVERNMENT 9304 - MEDICAL INSURANCE - RETIREE 1,320,000 1,172,243.73 1,965,000 1,122,842.12 1,500,000 27,297.11 79,781.72 845 - RETIREE SELF INS FUND EXPENSE $1,320,000 $1,172,243.73 $1,965,000 $1,122,842.12 $1,500,000 $27,297.11 $79,781.72 845 - RETIREE SELF INS FUND REVENUE OVER / UNDER EXPENSES $0 $588,199.09 $0 $226,592.72 $0 $3,866.73 $46,079.23 FY 2020 FY 2021 FY 2021 Retiree Self Insurance Fund as of July 31, 2021 FY 2020 FY 2022 FY 2022 Same Period Last Year Same Period Last Year Retiree Self Ins Fund 845 22 of 32 07.2021 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Month 2020 2021 2022 2023 July $646,924.11 $433,059.43 August $590,241.30 September $489,464.41 October $466,294.49 November $396,067.66 December $334,887.79 January ($315,453.19)$206,371.20 February ($386,583.22)$180,684.24 March ($530,399.34)$35,718.25 April ($611,564.54)$93,954.23 May ($622,617.07)$594,052.00 June ($625,264.03)$417,576.83 Retiree Self Insurance Fund as of July 31, 2021 CASH Retiree Self Ins Fund Cash 23 of 32 07.2021 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 0 0.00 1,000,000 373,149.74 450,000 14,580.65 36,231.34 38 - MISCELLANEOUS INCOME 860,000 34,379.16 0 0.00 0 0.00 0.00 39 - NON-REVENUE RECEIPTS 0 0.00 0 0.00 0 0.00 0.00 860 - FSA FUND REVENUE $860,000 $34,379.16 $1,000,000 $373,149.74 $450,000 $14,580.65 $36,231.34 Expense Function Department Budget Actual Budget Actual Budget Actual 860 - FLEXIBLE SPENDING ACCOUNT 00 - GENERAL GOVERNMENT 9306 - FLEXIBLE SPENDING ACCOUNT 860,000 16,054.01 1,000,000 348,138.39 450,000 40,804.89 45,074.29 860 - FSA FUND EXPENSE $860,000 $16,054.01 $1,000,000 $348,138.39 $450,000 $40,804.89 $45,074.29 860 - FSA FUND REVENUE OVER / UNDER EXPENSES $0 $18,325.15 $0 $25,011.35 $0 $26,224.24 $8,842.95 Same Period Last Year FY 2020 FY 2021 FY 2021 Flexible Spending Account Fund as of July 31, 2021 FY 2020 FY 2022 FY 2022 Same Period Last Year FSA Fund 860 24 of 32 07.2021 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Month 2020 2021 2022 2023 July $32,773.26 $57,917.15 August $4,555.97 September ($5,068.36) October ($4,643.01) November $8,077.84 December $26,646.09 January $0.00 $59,353.69 February $0.00 $29,548.75 March $0.00 ($199.25) April $0.00 $7,866.89 May $62.50 ($8,152.65) June ($38,774.94)$37,062.66 Flexible Spending Account Fund as of July 31, 2021 CASH FSA Fund Cash 25 of 32 07.2021 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 0 52,797.93 89,508 74,590.00 113,111 0.00 0.00 38 - MISCELLANEOUS INCOME 3,850 102,732.81 27,600 108,493.81 12,000 0.00 6,294.00 39 - NON-REVENUE RECEIPTS 200,000 200,000.00 150,000 150,000.00 100,000 0.00 0.00 880 - FLEET SERVICES FUND REVENUE $203,850 $355,530.74 $267,108 $333,083.81 $225,111 $0.00 $6,294.00 Expense Function Department Budget Actual Budget Actual Budget Actual 880 - FLEET SERVICES 00 - GENERAL GOVERNMENT 9410 - FLEET SERVICES 203,850 95,530.85 267,108 34,981.61 142,846 14,650.00 32,600.00 9910 - CONTINGENCY 0 0.00 0 0.00 82,265 0.00 0.00 880 - FLEET SERVICES FUND EXPENSE $203,850 $95,530.85 $267,108 $34,981.61 $225,111 $14,650.00 $32,600.00 880 - FLEET SERVICES FUND REVENUE OVER / UNDER EXPENSES $0 $49,294.56 $0 $259,999.89 $0 $14,650.00 $26,306.00 Same Period Last Year Same Period Last Year FY 2020 FY 2021 FY 2021 Fleet Services Fund as of July 31, 2021 FY 2020 FY 2022 FY 2022 Fleet Services Fund 880 26 of 32 07.2021 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Month 2020 2021 2022 2023 July $601,279.16 $875,875.85 August $609,506.58 September $615,658.56 October $624,166.20 November $632,714.95 December $791,230.55 January $565,853.83 $799,782.08 February $572,455.44 $808,107.96 March $573,647.74 $816,344.80 April $574,877.57 $823,803.80 May $616,138.99 $831,262.80 June $571,361.34 $875,875.85 Fleet Services Fund as of July 31, 2021 CASH Fleet Services Fund Cash 27 of 32 07.2021 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 940,000 1,214,177.01 1,413,384 1,368,537.84 1,568,420 7,269.83 63,095.41 38 - MISCELLANEOUS INCOME 0 0.00 0 2,205.00 0 0.00 0.00 39 - NON-REVENUE RECEIPTS 350,000 350,000.00 607,000 350,000.00 350,000 0.00 0.00 890 - INFO TECHNOLOGY FUND REVENUE $1,290,000 $1,564,177.01 $2,020,384 $1,720,742.84 $1,918,420 $7,269.83 $63,095.41 Expense Function Department Budget Actual Budget Actual Budget Actual 890 - INFORMATION TECHNOLOGY 00 - GENERAL GOVERNMENT 9420 - TECHNOLOGY 1,290,000 909,856.76 2,020,384 1,730,021.57 1,918,420 34,305.86 308,264.77 890 - INFO TECHNOLOGY FUND EXPENSE $1,290,000 $909,856.76 $2,020,384 $1,730,021.57 $1,918,420 $34,305.86 $308,264.77 890 - INFO TECHNOLOGY FUND REVENUE OVER / UNDER EXPENSES $0 $123,876.44 $0 $654,320.25 $0 $27,036.03 $245,169.36 FY 2020 FY 2021 FY 2021 Information Technology Fund as of July 31, 2021 FY 2020 FY 2022 FY 2022 Same Period Last Year Same Period Last Year Info Technology Fund 890 28 of 32 07.2021 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Month 2020 2021 2022 2023 July $852,093.02 $1,063,233.66 August $804,366.93 September $800,161.86 October $902,530.92 November $889,233.88 December $1,046,992.00 January $515,312.48 $1,189,759.12 February $534,562.33 $1,297,161.54 March $536,134.58 $1,426,825.09 April $570,566.56 $1,207,565.76 May $612,977.73 $973,972.46 June $798,424.51 $1,120,208.17 Information Technology Fund as of July 31, 2021 CASH Info Technology Fund Cash 29 of 32 07.2021 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 33 - INTRGVRNMNTL - FEDRL 361,795 237,905.37 313,368 168,677.61 130,040 0.00 0.00 34 - INTRGVRNMNTL - STATE 0 0.00 0 0.00 0 0.00 0.00 38 - MISCELLANEOUS INCOME 85,000 46,238.26 155,840 47,990.21 101,068 0.00 0.00 39 - NON-REVENUE RECEIPTS 50,000 50,000.00 57,484 48,893.00 0 0.00 0.00 250 - VET TREATMENT COURT REVENUE $496,795 $334,143.63 $526,692 $265,560.82 $231,108 $0.00 $0.00 Expense Function Department Budget Actual Budget Actual Budget Actual 250 - VETERANS SERVICE SRF 00 - GENERAL GOVERNMENT 4185 - VETERANS TREATMENT COURT 496,795 323,503.39 526,692 269,524.27 231,108 0.00 0.00 250 - VET TREATMENT COURT EXPENSE $496,795 $323,503.39 $526,692 $269,524.27 $231,108 $0.00 $0.00 250 - VET TREATMENT COURT REVENUE OVER / UNDER EXPENSES $0 $400.00 $0 $10,640.24 $0 $0.00 $0.00 Same Period Last Year Same Period Last Year FY 2022 FY 2022FY 2020 Veteran's Treatment Court as of July 31, 2021 FY 2020 FY 2021 FY 2021 Veteran's Treatment Court 250 30 of 32 07.2021 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Month 2020 2021 2022 2023 July $3,916.48 $17,423.22 August ($19.11) September ($5,847.89) October ($52,239.74) November ($55,209.63) December ($10,827.18) January $7,582.66 ($54,087.90) February $35,756.46 ($60,437.65) March $19,011.14 ($63,403.68) April $30,146.67 ($63,500.51) May $42,612.59 ($72,985.76) June $28,305.11 ($147,859.69) Veteran's Treatment Court as of July 31, 2021 CASH Veteran's Treatment Court Cash 31 of 32 07.2021 Monthly Master as of December 31, 2020 1. Current year activity :City Hold Harmless School Hold HarmlessFiscal Year 2021 Article 39 Article 40 Article 42 Article 40 Article 42 Article 44 Article 44 *524 Article 46 Article 39 Article 39 Special Total July, 2020 957,089.74$ 607,607.22$ 295,944.39$ 197,353.55$ 394,707.11$ -$ 402,528.73$ 279,162.77$ (111,209.05)$ (138,640.48)$ 190,001.70$ 3,074,545.68$ August, 2020 881,470.01$ 554,580.29$ 265,340.00$ 191,790.83$ 383,581.65$ 36.90$ 402,528.73$ 255,102.43$ (102,474.07)$ (136,132.07)$ 172,547.80$ 2,868,372.50$ September, 2020 718,623.67$ 587,874.58$ 232,920.94$ 202,785.24$ 405,570.48$ 93.39$ 402,528.73$ 198,331.54$ (115,349.37)$ (200,769.77)$ 144,305.98$ 2,576,915.41$ October, 2020 850,832.64$ 575,220.51$ 260,256.08$ 199,193.38$ 398,386.77$ 16.96$ 402,528.73$ 243,581.48$ (108,431.72)$ (158,228.91)$ 167,457.33$ 2,830,813.25$ November, 2020 949,788.51$ 601,505.60$ 286,496.88$ 207,873.95$ 415,747.90$ (24.83)$ 402,520.66$ 274,565.55$ (110,981.91)$ (149,298.36)$ 186,073.14$ 3,064,267.09$ December, 2020 1,090,014.44$ 683,767.23$ 324,492.97$ 238,678.97$ 477,357.95$ (74.49)$ 402,520.66$ 315,885.78$ (126,670.03)$ (168,628.42)$ 212,662.12$ 3,450,007.18$ January, 2021 988,362.50$ 579,245.34$ 295,170.17$ 199,046.00$ 398,091.99$ 144.56$ 402,520.66$ 287,183.48$ (103,900.15)$ (122,650.39)$ 193,019.04$ 3,116,233.20$ February, 2021 649,251.38$ 484,533.90$ 207,829.59$ 165,357.78$ 330,715.57$ 25.02$ 402,520.66$ 181,170.85$ (92,806.33)$ (148,981.30)$ 129,733.59$ 2,309,350.71$ March, 2021 1,159,338.74$ 688,326.19$ 333,071.23$ 244,660.11$ 489,320.23$ 6.32$ 402,520.66$ 341,895.51$ (127,876.41)$ (157,790.49)$ 223,534.61$ 3,597,006.70$ April, 2021 1,074,384.86$ 642,908.17$ 306,610.33$ 229,850.38$ 459,700.76$ 404.01$ 402,520.66$ 319,094.44$ (120,689.35)$ (151,185.51)$ 206,708.96$ 3,370,307.71$ May, 2021 1,052,763.20$ 645,003.43$ 310,312.63$ 225,895.89$ 451,791.77$ 11.84$ 402,381.65$ 306,040.73$ (119,600.06)$ (153,532.58)$ 204,647.88$ 3,325,716.38$ June, 2021 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 10,371,919.69$ 6,650,572.46$ 3,118,445.21$ 2,302,486.08$ 4,604,972.18$ 639.68$ 4,427,620.53$ 3,002,014.56$ (1,239,988.45)$ (1,685,838.28)$ 2,030,692.15$ 33,583,535.81$ Year over Year Change 21.69% 16.16% 18.41% 17.14% 17.14% 132.90% 3.86% 23.52% 14.34% 9.04% 22.01% 17.81% 2. Comparison to prior year :City Hold Harmless School Hold HarmlessFiscal Year 2020 Article 39 Article 40 Article 42 Article 40 Article 42 Article 44 Article 44 *524 Article 46 Article 39 Article 39 Special Total July, 2019 722,475.78$ 538,151.42$ 221,520.79$ 189,303.54$ 378,607.09$ 27.82$ 387,469.57$ 207,002.24$ (107,188.36)$ (170,842.84)$ 140,622.25$ 2,507,149.30$ August, 2019 689,392.36$ 542,114.38$ 216,498.38$ 189,512.68$ 379,025.36$ 23.07$ 387,469.57$ 194,396.72$ (108,588.35)$ (181,059.45)$ 135,277.83$ 2,444,062.55$ September, 2019 764,061.27$ 521,100.87$ 234,375.08$ 180,482.18$ 360,964.37$ 51.92$ 387,469.57$ 218,718.60$ (100,111.54)$ (145,288.95)$ 148,802.17$ 2,570,625.54$ October, 2019 781,928.60$ 538,319.98$ 233,493.51$ 190,440.97$ 380,881.94$ (20.83)$ 387,469.57$ 227,072.89$ (105,817.44)$ (155,952.83)$ 150,876.49$ 2,628,692.85$ November, 2019 774,744.39$ 535,701.16$ 236,445.63$ 186,689.60$ 373,379.19$ 43.30$ 387,496.79$ 222,699.83$ (103,836.42)$ (153,384.38)$ 150,615.20$ 2,610,594.29$ December, 2019 849,666.39$ 568,171.91$ 257,297.61$ 197,962.67$ 395,925.34$ (153.13)$ 387,496.79$ 244,296.38$ (108,947.71)$ (155,154.68)$ 164,765.27$ 2,801,326.84$ January, 2020 644,116.70$ 464,949.37$ 203,548.61$ 159,231.21$ 318,462.43$ 73.47$ 387,496.80$ 181,235.98$ (89,960.54)$ (137,977.53)$ 126,679.14$ 2,257,855.64$ February, 2020 655,032.59$ 472,097.14$ 207,635.33$ 161,173.65$ 322,347.31$ 108.23$ 387,496.79$ 184,164.13$ (90,969.46)$ (139,512.35)$ 128,972.90$ 2,288,546.26$ March, 2020 840,293.51$ 540,832.28$ 272,375.23$ 176,925.13$ 353,850.25$ 90.46$ 387,496.79$ 233,127.56$ (96,280.29)$ (127,773.40)$ 166,944.13$ 2,747,881.65$ April, 2020 852,889.65$ 467,793.07$ 261,842.19$ 154,250.20$ 308,500.40$ 25.27$ 387,496.79$ 244,598.34$ (80,103.55)$ (78,766.82)$ 166,259.99$ 2,684,785.53$ May, 2020 948,616.92$ 536,065.02$ 288,554.04$ 179,559.63$ 359,119.25$ 5.08$ 388,173.46$ 273,000.50$ (92,655.79)$ (100,332.21)$ 184,544.96$ 2,964,650.86$ June, 2020 1,017,972.62$ 634,227.37$ 301,043.78$ 221,921.43$ 443,842.87$ 51.77$ 402,528.73$ 295,180.44$ (117,938.36)$ (155,561.50)$ 196,169.67$ 3,239,438.82$ 8,523,218.16$ 5,725,296.60$ 2,633,586.40$ 1,965,531.46$ 3,931,062.93$ 274.66$ 4,263,032.49$ 2,430,313.17$ (1,084,459.45)$ (1,546,045.44)$ 1,664,360.33$ 28,506,171.31$ AnnualizedBudget % Collected(11 months)to Date1103100 310231 7,446,092.96$ 6,300,000$ 1,146,092.96$ 5,775,000$ 1,671,092.96$ 118.19%NC Sales Tax - Article 39 1103100 310233 6,650,572.46$ 5,600,000$ 1,050,572.46$ 5,133,333$ 1,517,239.13$ 118.76%NC Sales Tax - Article 40 (General Fund)1103100 310235 3,118,445.21$ 2,500,000$ 618,445.21$ 2,291,667$ 826,778.54$ 124.74%NC Sales Tax - Article 42 (General Fund)1103100 310237 4,428,260.21$ 4,000,000$ 428,260.21$ 3,666,667$ 761,593.54$ 110.71%NC Sales Tax - Article 44 & Article 44 *52421,643,370.84$ 18,400,000.00$ 3,243,370.84$ 16,866,666.67$ 4,776,704.17$ 117.63% 2118401 - 380892 2,030,692.15$ 1,598,664.00$ 432,028.15$ 1,465,442.00$ 565,250.15$ 127.02%NC Sales Tax Special Districts 3003100 310233 2,302,486.08$ 1,900,000$ 402,486.08$ 1,741,667$ 560,819.41$ 121.18%NC Sales Tax - Article 40 (Education)3003100 310235 4,604,972.18$ 3,900,000$ 704,972.18$ 3,575,000$ 1,029,972.18$ 118.08%NC Sales Tax - Article 42 (Education)3003100 310239 3,002,014.56$ 2,200,000$ 802,014.56$ 2,016,667$ 985,347.89$ 136.46%NC Sales Tax - Article 469,909,472.82$ 8,000,000.00$ 1,909,472.82$ 7,333,333.33$ 2,576,139.49$ 123.87% 3. Reconciliation to general ledger :Over/(Under) Annualized BudgetBalance to Tyler Activity Budget Over/(Under) Budget HARNETT COUNTY SALES TAX ANALYSIS BY ARTICLE General Fund Board of Education General Fund Board of Education Monthly Sales Tax 32 of 32 07.2021 Monthly Master