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 AboutJanuary 2022 Financial Report Monthly Financial Reports January 2022 Table of Contents General Fund ................................................................................................ 1 Harnett Regional Jetport Fund ..................................................................... 5 Harnett Regional Water Fund ...................................................................... 9 Solid Waste Fund ....................................................................................... 11 Worker’s Compensation Fund .................................................................... 13 Unemployment Insurance Fund ................................................................. 15 Employee Clinic Fund ................................................................................. 17 Medical Self Insurance Fund ...................................................................... 19 Dental Self Insurance Fund ........................................................................ 21 Retiree Self Insurance Fund ....................................................................... 23 Flexible Spending Account Fund ................................................................ 25 Fleet Services Fund ..................................................................................... 27 Information Technology Fund .................................................................... 29 Veteran’s Treatment Court ..................................................................... 31 Monthly Sales Tax Analysis by Article ........................................................ 33 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,725,351 65,075,514.32 62,847,564.19 31 - TAXES - SALES 18,265,000 20,597,227.82 18,400,000 23,875,039.72 22,300,000 8,181,364.37 7,326,786.80 32 - TAXES - OTHER 572,000 736,457.89 530,000 1,012,526.63 730,000 880,017.75 510,209.61 33 - INTRGVRNMNTL - FEDRL 15,358,264 14,502,831.23 17,355,230 15,711,610.96 18,270,725 7,201,851.52 6,267,282.94 34 - INTRGVRNMNTL - STATE 6,686,121 8,284,382.38 6,483,859 8,392,633.14 5,939,492 1,322,762.05 2,067,020.61 35 - SERVICE CHARGES 16,781,629 14,237,895.08 15,319,535 13,778,720.42 13,272,946 6,964,067.33 6,430,724.55 36 - ENTERPRISE CHARGES 5,000 4,262.92 3,000 1,672.35 1,600 1,158.33 739.67 38 - MISCELLANEOUS INCOME 2,276,907 5,407,368.98 1,551,807 1,803,513.67 1,691,126 776,533.56 1,002,857.12 39 - NON-REVENUE RECEIPTS 4,054,805 644,682.10 11,942,137 2,185,791.26 5,407,329 59,932.00 24,968.00 110 - GENERAL FUND REVENUE $130,079,143 $131,867,445.32 138,435,568 137,752,718.41 $137,338,569 $90,463,201.23 $86,478,153.49 Expense Function Department Budget Actual Budget Actual Budget Actual 110 - GENERAL 00 - GENERAL GOVERNMENT 4110 - GOVERNING BODY 405,127 373,092.30 788,447 777246.30 622,064 295,470.39 573,500.18 4120 - COUNTY ADMINISTRATION 908,274 888,035.06 1,036,614 967,139.30 1,142,158 609,889.13 488,562.34 4130 - FINANCE 1,506,606 1,411,933.85 1,306,824 1302523.38 1,405,508 794,466.71 715,531.10 4131 - RETIREE INSURANCE 571,000 571,000.00 882,000 836451.90 882,000 454,923.16 404,292.45 4140 - TAX 1,746,836 1,554,218.86 1,551,703 1375145.61 1,798,582 809,857.29 733,883.80 4150 - LEGAL SERVICES 356,342 309,378.48 363,565 317124.91 327,941 173,730.75 175,478.54 4160 - HUMAN RESOURCES 480,451 432,931.39 505,151 485996.12 773,466 495,570.73 253,221.44 4170 - BOARD OF ELECTIONS 561,515 458,625.51 597,465 524487.82 602,341 198,486.45 385,691.38 4180 - CLERK OF COURT 93,433 42,782.84 26,083 13338.15 22,283 8,275.90 8,565.28 4190 - REGISTER OF DEEDS 884,396 821,751.63 889,071 731345.62 736,135 345,448.14 380,402.99 4210 - GENERAL SERVICES 222,831 221,242.15 227,775 226379.33 233,856 130,908.69 125,298.70 4230 - FACILITIES MAINTENANCE 3,447,272 2,978,382.48 3,610,387 3370988.28 3,171,866 1,510,198.40 2,095,688.38 4250 - FLEET MAINTENANCE 684,307 665,435.73 629,738 605175.27 734,214 435,112.84 346,254.70 4270 - INFORMATION TECHNOLOGY 2,589,405 2,484,827.31 2,554,198 2498933.29 2,474,930 1,118,791.21 1,368,042.16 4290 - GIS 765,223 737,924.98 700,709 667520.21 759,998 373,476.43 375,545.97 9800 - INTERFUND TRANSFERS 15,303,912 15,290,048.00 21,454,238 21454238.00 14,374,297 14,374,297.00 17,392,315.00 9910 - CONTINGENCY 196,450 0.00 454,020 0.00 842,861 0.00 0.00 00 - GENERAL GOVERNMENT Total $30,723,380 $29,241,610.57 37,577,988 $36,154,033.49 30,904,500 22,128,903.22 25,822,274.41 General Fund as of January 31, 2022 FY 2020 FY 2022 FY 2020 FY 2021 FY 2021 Same Period Last Year Same Period Last Year FY 2022 General Fund 110 1 of 33 01.2022 Monthly Master Expense Function Department Budget Actual Budget Actual Budget Actual FY 2020 FY 2021 Same Period Last Year FY 2022 10 - PUBLIC SAFETY 4310 - SHERIFF 11,714,191 11,385,405.62 12,192,507 11767113.14 12,973,397 6,567,117.27 6,268,474.69 4330 - CAMPBELL DEPUTIES 551,807 476,310.20 477,204 462180.48 528,160 293,154.03 253,571.86 4350 - SCHOOL RESOURCE OFFICER 2,301,216 1,341,492.52 2,254,482 1636706.45 2,083,102 982,964.17 726,634.77 4370 - CHILD SUPPORT ENFORCEMENT 86,495 59,949.60 71,676 69418.10 79,244 41,297.69 34,960.92 4390 - JAIL 5,950,242 5,592,459.65 5,836,177 5714088.79 6,160,734 2,953,578.70 3,108,659.58 4410 - EMERGENCY MANAGEMENT 1,058,089 1,006,385.67 1,004,854 917365.40 984,086 532,878.46 461,399.22 4411 - EMERGENCY SERVICES GRANTS 567,249 565,394.86 208,975 206851.32 94,921 15,303.67 18,676.36 4450 - EMERGENCY MEDICAL SERVICE 8,070,165 7,615,472.99 9,162,453 8307576.45 9,277,434 4,749,148.00 4,310,715.93 4470 - RESCUE DISTRICTS 3,673,427 3,673,427.00 3,673,427 3673427.00 4,152,210 2,522,420.16 3,673,427.00 4510 - FIELD SERVICES 324,321 282,242.96 321,672 304222.75 366,521 165,769.77 152,276.16 4512 - ANIMAL SHELTER 330,074 219,190.31 359,570 253890.05 307,449 112,694.26 116,022.05 4530 - MEDICAL EXAMINER 125,000 121,050.00 95,000 87000.00 100,000 60,750.00 54,450.00 4570 - COMMUNICATIONS 1,999,555 1,868,768.01 1,762,248 1678534.79 1,954,386 879,136.97 938,675.40 4915 - INSPECTIONS 0.00 $0.00 0 $0.00 986,597 417,956.23 0.00 10 - PUBLIC SAFETY Total $36,751,831 $34,207,549.39 37,420,245 $35,078,374.72 40,048,241 20,294,169.38 20,117,943.94 20 - TRANSPORTATION 4610 - TRANSPORTATION 1,523,304 1,082,398.03 1,513,691 1029779.25 1,704,971 548,330.26 502,107.27 4630 - TRANSPORTATION - ADMIN 663,619 492,512.68 739,696 706044.94 604,040 139,645.69 251,649.05 4650 - HARNETT REGIONAL JETPORT 244,776 198,852.98 509,520 417451.00 0 0.00 118,745.28 20 - TRANSPORTATION Total $2,431,699 $1,773,763.69 2,762,907 $2,153,275.19 2,309,011 687,975.95 872,501.60 30 - ENVIRONMENTAL PROTECTION 4710 - SOIL & WATER 234,187 222,440.11 237,233 218946.11 245,552 131,460.54 119,718.79 4730 - FORESTRY PROGRAM 136,272 124,123.36 138,026 135320.77 130,722 50,231.19 56,163.85 4750 - ENVIROMENTAL PROT ALLOC 4,000 4,000.00 6,000 6000.00 12,000 11,000.00 6,000.00 30 - ENVIRONMENTAL PROTECTION Total $374,459 $350,563.47 381,259 $360,266.88 388,274 192,691.73 181,882.64 40 - ECONOMIC & PHYSICAL DEVELOPMNT 4910 - DEVELOPMENT SERVICES 1,860,624 1,551,440.18 1,665,394 1644998.81 956,067 583,316.86 875,986.31 4930 - ECONOMIC DEVELOPMENT 1,029,298 729,534.58 777,877 675911.43 1,036,973 268,814.89 199,645.06 4950 - COMMUNITY DEVELOPMENT 1,375 192.45 925 554.81 455 24.79 272.61 4951 - ABANDONED MFG HOME 30,854 26,962.71 0 0.00 0 0.00 13,573.58 4990 - COOPERATIVE EXTENSION 408,665 355,800.19 405,145 334915.00 405,014 210,348.33 160,132.19 4995 - COOPERATIVE EXT SPECIAL PROG 283,018 211,037.23 170,152 80618.74 112,625 45,764.00 46,704.93 40 - ECONOMIC & PHYSICAL DEVELOPMNT Total $3,613,834 $2,874,967.34 3,019,493 $2,736,998.79 2,511,134 1,108,268.87 1,296,314.68 50 - HUMAN SERVICES 5110 - HEALTH - ADMINISTRATION 6,635,444 5,609,257.46 7,370,852 5797516.31 8,705,903 3,254,212.23 3,062,028.24 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 General Fund 110 2 of 33 01.2022 Monthly Master Expense Function Department Budget Actual Budget Actual Budget Actual FY 2020 FY 2021 Same Period Last Year FY 2022 5160 - HEALTH - SENIOR SERVICES 1,401,534 1,307,710.38 1,679,594 1460031.51 1,605,397 753,569.98 760,132.96 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 454,349.25 505,679.00 5310 - DSS - ADMINISTRATION 2,613,128 2,388,014.64 2,436,585 2255368.91 2,038,570 1,213,018.82 1,115,036.47 5311 - DSS - FRAUD PREVENTION 264,033 231,968.94 297,397 293135.82 340,031 186,304.35 146,096.37 5320 - DSS - ADULT SERVICES 1,133,036 1,099,638.00 888,982 851855.81 1,011,567 484,278.04 452,032.45 5321 - DSS - WORKFIRST 344,636 269,512.32 303,231 281561.51 352,353 159,407.98 147,755.44 5322 - DSS - ENERGY PROGRAMS 1,117,949 1,122,625.44 1,374,286 1220383.03 2,325,542 491,960.43 840,600.91 5330 - DSS - CHILD CARE SUBSIDY 2,900,405 2,650,694.52 376,627 366092.70 414,877 226,729.68 192,312.59 5331 - DSS - CHILD PROTECTIVE SRVCS 59,098 24,615.13 2,127,436 2016036.47 2,105,403 1,136,572.02 1,083,143.60 5332 - DSS - FOSTER CARE 1,752,348 1,547,642.72 2,711,023 2504118.07 2,974,453 1,466,336.50 1,320,017.72 5333 - DSS - ADOPTION 480,710 271,332.20 397,847 290006.27 389,469 170,522.21 168,884.47 5334 - DSS - DAY CARE 254,662 185,388.79 22,315 10488.00 0 0.00 0.00 5340 - DSS - CHILD SUPPORT 1,328,691 1,190,151.75 1,331,417 1229087.03 1,482,305 706,885.31 657,026.58 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 2065004.64 2,334,126 1,062,055.93 1,140,900.61 5352 - DSS - FAMILY & CHLDRN MEDICAID 1,565,673 1,463,483.95 1,541,975 1503778.69 1,645,932 859,531.41 809,155.88 5353 - DSS - MEDICAID TRANSPORTATION 147,593 64,879.10 211,078 190776.42 216,148 104,612.16 99,434.60 5360 - DSS - TEMPORARY RESOURCES 0 0.00 124 0.00 0 0.00 0.00 5370 - DSS - FOOD STAMPS 1,459,502 1,290,644.00 1,498,504 1473856.97 1,587,610 866,304.70 797,196.58 5810 - VETERANS SERVICES 299,545 270,170.03 304,997 273925.29 316,223 152,127.97 123,979.07 5870 - RESTITUTION 102,017 93,474.71 82,712 79168.66 95,090 45,943.79 43,645.93 5895 - HUMAN SERVICES APPROPRIATIONS 37,688 31,117.70 32,000 0.00 0 0.00 23,223.00 50 - HUMAN SERVICES Total $26,995,353 $23,930,564.12 27,810,098 $24,767,871.11 30,546,678 13,794,722.76 13,488,282.47 70 - EDUCATION 5910 - BOARD OF EDUCATION 24,680,603 24,680,603.00 24,680,603 24680603.00 25,532,776 17,305,907.91 24,680,603.00 5920 - CCCC 1,626,978 1,551,147.64 1,621,978 1359842.33 1,812,631 863,885.57 1,236,504.44 70 - EDUCATION Total $26,307,581 $26,231,750.64 26,302,581 $26,040,445.33 27,345,407 18,169,793.48 25,917,107.44 80 - CULTURAL & RECREATION 6110 - PARKS & RECREATION 1,326,751 1,172,372.50 1,399,432 1255861.31 1,482,442 804,090.28 785,795.68 6170 - LIBRARY 1,335,059 1,058,294.68 1,542,378 1325297.41 1,618,226 759,656.44 606,783.70 6199 - CULTURAL & REC APPROP 219,196 172,360.00 219,187 184589.00 184,656 160,156.00 150,000.00 80 - CULTURAL & RECREATION Total $2,881,006 $2,403,027.18 3,160,997 $2,765,747.72 3,285,324 1,723,902.72 1,542,579.38 110 - GENERAL FUND EXPENSE $130,079,143 $121,013,796.40 $138,435,568 130,057,013.23 $137,338,569 $78,100,428.11 $89,238,886.56 110 - GENERAL FUND REVENUE OVER / UNDER EXPENSES $0 $10,853,648.92 $0 7,695,705.18 $0 $12,362,773.12 $2,760,733.07 General Fund 110 3 of 33 01.2022 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Month 2020 2021 2022 2023 July $33,238,397.31 $42,138,468.69 August $30,766,642.59 $27,193,378.74 September $31,436,740.68 $28,790,983.30 October $32,621,237.60 $29,548,489.91 November $55,768,728.62 $53,028,835.59 December $52,233,891.79 $62,336,715.42 January $49,307,366.28 $53,864,998.95 $66,551,605.32 February $46,553,686.81 $52,435,487.27 March $48,087,241.40 $54,340,963.07 April $45,974,675.17 $53,068,500.85 May $41,927,274.60 $52,229,820.40 June $40,106,511.08 $45,039,854.80 General Fund as of January 31, 2022 CASH General Fund Cash 4 of 33 01.2022 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 27,314.20 35 - SERVICE CHARGES 0 0.00 38,031 20,630.37 712,958 496,141.07 0.00 38 - MISCELLANEOUS INCOME 9,465 7,835.00 7,385 6,395.00 35,285 24,827.97 4,595.00 120 - HR JETPORT FUND REVENUE $9,465 $60,607.00 $72,730 $54,339.57 $748,243 $520,969.04 $31,909.20 Expense Function Department Budget Actual Budget Actual Budget Actual 110 - GENERAL 4650 - HARNETT REGIONAL JETPORT 50 - SALARIES & BENEFITS 100 0.00 7,145 6,439.23 181,268 103,934.32 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 49,820.28 473,629 291,028.24 1,410.00 53 - CURRENT SRVCS 75,893 48,772.25 38,828 33,704.11 43,764 18,663.40 19,195.82 54 - FIXED CHARGES 148,942 146,920.00 191,626 151,403.37 49,582 34,412.46 90,602.94 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 7,536.52 70 - PCARD ENCUMBRANCE 0 0.00 0 0.00 0 0.00 0.00 110 - GENERAL Total $244,776 $198,852.98 $509,520.00 $417,451.00 $748,243.00 $448,038.42 118,745.28 120 - HR JETPORT FUND REVENUE $244,776 $198,852.98 $509,520 $417,451.00 $748,243 $448,038.42 $118,745.28 120 - HR JETPORT FUND REVENUE OVER / UNDER EXPENSES $235,311 $190,202.36 $172,046 $144,513.41 $0 $72,930.62 $86,836.08 Harnett Regional Jetport Fund as of January 31, 2022 Same Period Last Year FY 2020 FY 2021 FY 2020 FY 2021 FY 2022 FY 2022 Same Period Last Year HRJetport Fund 120 5 of 33 01.2022 Monthly Master Airport Avgas 10/25 JetA 10/25 Avgas 11/29 JetA 11/29 Avgas 12/27 JetA 12/27 Avgas 1/31 JetA 1/31 Harnett Regional Jetport 4.45$ 4.13$ 4.45$ 4.64$ 4.45$ 4.39$ 4.60$ 4.15$ Clinton 4.99$ 4.24$ 4.99$ 4.24$ 4.99$ 4.24$ 4.99$ 4.24$ Duplin County 4.92$ 4.41$ 4.87$ 4.68$ 4.86$ 4.27$ 4.86$ 4.39$ Elizabethtown 4.79$ 3.59$ 4.99$ 3.99$ 4.99$ 3.99$ 4.55$ 3.85$ Fayetteville 6.13$ 6.71$ 6.13$ 6.66$ 6.13$ 6.48$ 6.13$ 6.93$ Gray's Creek 5.00$ NA 5.10$ NA 5.20$ NA 5.10$ NA Johnston County 4.74$ 4.49$ 4.89$ 4.59$ 4.98$ 4.69$ 5.09$ 4.69$ Lauringburg-Maxton 5.05$ 5.15$ 5.05$ 5.31$ 4.41$ 4.41$ 5.05$ 4.94$ Lumberton 4.55$ 3.57$ 4.55$ 3.57$ 4.55$ 3.85$ 4.55$ 3.85$ Moore County 5.20$ 4.85$ 5.29$ 5.10$ 5.29$ 5.10$ 5.29$ 5.10$ Mount Olive 4.75$ 3.78$ 4.88$ 3.78$ 4.88$ 3.99$ 4.35$ 3.88$ Raleigh Exec 5.66$ 5.04$ 5.43$ 5.10$ 5.25$ 4.96$ 5.55$ 5.31$ Rocky Mount- Wilson 4.19$ 3.69$ 4.19$ 4.22$ 4.42$ 4.22$ 4.21$ 4.22$ Siler City 5.29$ 4.49$ 5.29$ 4.49$ 5.29$ 4.59$ 5.29$ 4.59$ Triangle North 5.59$ 4.84$ 5.54$ 4.84$ 5.54$ 4.84$ 5.39$ 4.99$ Wayne Executive (Goldsboro)4.63$ 3.51$ 4.33$ 3.78$ 4.33$ 3.78$ 4.63$ 3.51$ Whiteville 4.55$ 3.45$ 4.75$ 3.50$ 4.75$ 3.50$ 4.75$ 3.50$ Average of All Others 5.00$ 4.39$ 5.02$ 4.52$ 4.99$ 4.46$ 4.99$ 4.53$ KHRJ Fuel Price Comparison with Surrounding Airports By Date Types (AvGas - JetA) FY 22 Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Month 2020 2021 2022 2023 July $0.00 ($11,088.75) August $0.00 $37,411.89 September $0.00 $35,672.40 October $0.00 $20,779.21 November $0.00 $15,413.17 December $0.00 ($7,456.99) January $0.00 $0.00 ($13,970.07) 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 CASH Harnett Regional Jetport as of January 31, 2022 HRJetport Fund Cash 7 of 33 01.2022 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Month 2020 2021 2022 2023 July $0.00 $59,505.03 August $0.00 $29,721.24 September $0.00 $33,441.27 October $0.00 $50,458.29 November $0.00 $47,552.93 December $0.00 $48,472.67 January $0.00 $0.00 $65,652.06 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 INVENTORY Harnett Regional Jetport as of January 31, 2022 HRJetport Fund Inventory 8 of 33 01.2022 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 325,618.70 35 - SERVICE CHARGES 15,000 143,502.18 10,581 2,561.90 10,000 937.91 1,289.57 36 - ENTERPRISE CHARGES 1,381,500 1,671,386.38 1,583,500 1,663,356.41 1,384,000 1,352,129.68 882,191.40 37 - FACILITY FEES 32,575,000 37,720,428.29 34,600,000 39,100,367.08 35,875,000 20,302,193.09 23,211,726.78 38 - MISCELLANEOUS INCOME 705,000 7,993,723.20 710,000 4,045,071.83 552,094 814,808.84 2,342,619.69 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,136,975.92 $37,824,797 $22,470,069.52 $26,763,446.14 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 35,432,165.67 12,995,754 2,155,629.23 23,044,220.95 7113 - WATER TREATMENT PLANT 6,569,748 5,422,700.11 5,966,684 4,988,907.10 6,607,451 2,877,777.85 2,684,354.63 7115 - WASTEWATER TREATMENT PLANT 3,062,790 2,054,660.74 3,385,564 2,245,476.78 3,675,118 1,158,587.30 1,707,941.85 7117 - SOUTH HARNETT WASTEWATER PLANT 3,173,670 2,210,178.83 2,975,213 2,442,340.96 3,590,355 1,509,255.04 1,141,770.36 7119 - WATER DISTRIBUTION 5,167,052 4,089,298.68 5,065,366 4,372,934.46 5,119,780 2,515,085.78 2,139,253.42 7121 - SEWER COLLECTIONS 4,690,292 4,075,030.16 5,446,344 4,305,290.43 5,775,532 2,208,014.24 1,809,404.51 7131 - RETIREE INSURANCE HRW 0 0.00 0 0.00 60,807 33,405.50 26,833.42 610 - HRW FUND EXPENSE $42,352,950 $46,789,356.04 $51,212,784 $53,787,115.40 $37,824,797 $12,457,754.94 $32,553,779.14 610 - HRW FUND REVENUE OVER / UNDER EXPENSES $0 $739,684.01 $0 $8,650,139.48 $0 $10,012,314.58 $5,790,333.00 Harnett Regional Water Fund as of January 31, 2022 FY 2020 Same Period Last Year FY 2020 FY 2021 FY 2021 FY 2022 FY 2022 Same Period Last Year HRW Fund 610 9 of 33 01.2022 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Month 2020 2021 2022 2023 July $56,308,485.60 $51,396,573.71 August $57,887,471.15 $53,478,105.50 September $53,052,496.69 $54,740,839.35 October $41,972,645.61 $57,802,598.49 November $44,623,020.08 $59,929,869.87 December $46,244,526.10 $61,433,187.37 January $57,818,912.12 $47,842,388.74 $62,779,925.69 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 $55,307,862.26 $48,531,475.46 Harnett Regional Water Fund as of January 31, 2022 CASH HRW Fund Cash 10 of 33 01.2022 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 84,031.27 74,445.46 35 - SERVICE CHARGES 0 6,122.07 553 2,072.25 0 0.00 962.64 36 - ENTERPRISE CHARGES 1,930,200 2,515,403.09 1,910,200 3,114,682.13 1,910,000 1,754,750.29 1,653,267.00 37 - FACILITY FEES 3,550,000 3,760,202.26 4,581,020 4,648,605.96 4,520,000 4,408,001.11 4,323,886.85 38 - MISCELLANEOUS INCOME 70,200 51,846.93 100,733 138,848.24 45,000 70,228.31 494,357.91 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,203,218.71 $6,735,000 $6,317,010.98 $6,546,919.86 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 7,074,884.93 6,715,000 2,719,956.14 3,921,295.12 7431 - RETIREE INSURANCE SW 0 9,717.30 0 0.00 20,000 11,017.82 9,810.72 660 - SOLID WASTE FUND EXPENSE $5,810,400 $5,293,487.79 $6,874,506 $7,074,884.93 $6,735,000 $2,730,973.96 $3,931,105.84 660 - SOLID WASTE FUND REVENUE OVER / UNDER EXPENSES $0 $1,323,726.91 $0 $1,128,333.78 $0 $3,586,037.02 $2,615,814.02 Solid Waste Fund as of January 31, 2022 Same Period Last Year FY 2020 FY 2022 FY 2022 FY 2020 FY 2021 Same Period Last Year FY 2021 Solid Waste Fund 660 11 of 33 01.2022 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Month 2020 2021 2022 2023 July $3,387,995.72 $4,457,425.74 August $3,375,944.64 $4,647,598.39 September $3,607,274.52 $4,882,131.66 October $3,759,678.53 $5,029,336.00 November $5,581,197.69 $6,828,615.40 December $6,451,303.81 $7,686,623.97 January $4,616,721.91 $5,784,640.53 $8,072,325.65 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,590,915.49 $4,646,306.54 Solid Waste Fund as of January 31, 2022 CASH Solid Waste Fund Cash 12 of 33 01.2022 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 706,967.19 600,956.40 38 - MISCELLANEOUS INCOME 1,003,788 994,240.57 0 1,350.81 0 1,655.65 722.35 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 $708,622.84 $601,678.75 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 180,454.06 760,000 $275,514.69 273,916.31 810 - WORKER'S COMP FUND EXPENSE $2,103,788 $1,415,657.00 $1,211,700 $180,454.06 $760,000 $275,514.69 $273,916.31 810 - WORKERS'S COMP FUND REVENUE OVER / UNDER EXPENSES $0 $518,358.18 $0 $955,466.11 $0 $433,108.15 $327,762.44 Worker's Compensation Fund as of January 31, 2022 FY 2020 FY 2022 Same Period Last Year FY 2020 FY 2021 FY 2021 FY 2022 Same Period Last Year Worker's Comp Fund 810 13 of 33 01.2022 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 $5,246,986.87 September $4,785,314.35 $5,461,742.83 October $4,844,771.48 $5,445,463.58 November $4,925,635.39 $5,542,243.37 December $4,982,050.03 $5,731,380.38 January $3,318,944.43 $5,056,960.44 $5,816,058.20 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,380,269.92 Worker's Compensation Fund as of January 31, 2022 CASH Worker's Comp Fund Cash 14 of 33 01.2022 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 59,386.97 128,140.26 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 $59,386.97 $128,140.26 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 $16,813.26 19,734.22 820 - UNEMPLOYMENT FUND EXPENSE $100,000 $16,752.83 $250,000 $19,734.22 $250,000 $16,813.26 $19,734.22 820 - UNEMPLOYMENT FUND REVENUE OVER / UNDER EXPENSES $0 $185,424.92 $0 $201,730.41 $0 $42,573.71 $108,406.04 Unemployment Insurance Fund as of January 31, 2022 FY 2020 FY 2020 FY 2021 FY 2021 FY 2022 FY 2022 Same Period Last Year Same Period Last Year Unemployment Ins Fund 820 15 of 33 01.2022 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 $1,762,410.64 September $1,600,689.65 $1,780,727.76 October $1,618,305.74 $1,780,727.76 November $1,638,946.38 $1,789,872.72 December $1,657,035.68 $1,782,256.94 January $1,474,589.24 $1,675,333.87 $1,791,497.73 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,748,924.02 Unemployment Insurance Fund as of January 31, 2022 CASH Unemployment Ins Fund Cash 16 of 33 01.2022 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 80,032.23 89,265.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 $80,032.23 $89,265.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 56,298.47 86,122.75 830 - EMPLOYEE CLINIC FUND EXPENSE $179,720 $163,177.85 $174,690 $166,113.38 $180,900 $56,298.47 $86,122.75 830 - EMPLOYEE CLINIC FUND REVENUE OVER / UNDER EXPENSES $0 $38,256.95 $0 $7,405.61 $0 $23,733.76 $3,142.25 Employee Clinic Fund as of January 31, 2022 FY 2022 FY 2022 FY 2020 FY 2021 FY 2021FY 2020 Same Period Last Year Same Period Last Year Employee Clinic Fund 830 17 of 33 01.2022 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 $703,376.13 September $697,339.53 $723,948.07 October $696,760.57 $714,556.04 November $695,238.45 $715,794.77 December $697,288.04 $714,986.69 January $653,534.82 $696,374.16 $709,565.30 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 $688,250.11 Employee Clinic Fund as of January 31, 2022 CASH Employee Clinic Fund Cash 18 of 33 01.2022 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 9,033,000 9,578,505.48 11,296,710 10,509,741.05 9,500,000 5,342,051.11 5,633,432.59 38 - MISCELLANEOUS INCOME 113,442 120,058.34 17,875 12,867.15 12,000 0.00 12,867.15 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 $10,522,608.20 $9,512,000 $5,342,051.11 $5,646,299.74 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,815,520.42 9,512,000 5,815,788.88 5,003,453.57 841 - MEDICAL SELF INS FUND EXPENSE $9,146,442 $7,438,276.99 $12,314,585 $8,815,520.42 $9,512,000 $5,815,788.88 $5,003,453.57 841 - MEDICAL SELF INS FUND REVENUE OVER / UNDER EXPENSES $0 $2,260,286.83 $0 $1,707,087.78 $0 $473,737.77 $642,846.17 Medical Self Insurance Fund as of January 31, 2022 FY 2020 FY 2020 FY 2021 FY 2021 FY 2022 FY 2022 Same Period Last Year Same Period Last Year Medical Self Ins Fund 841 19 of 33 01.2022 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Month 2020 2021 2022 2023 July $8,394,410.05 $9,936,719.25 August $8,309,827.07 $9,558,799.23 September $8,147,930.01 $10,182,610.45 October $8,437,620.01 $9,335,253.68 November $8,763,538.51 $9,233,189.07 December $9,045,130.83 $9,259,586.30 January $7,007,592.83 $8,831,273.60 $9,612,099.50 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 $9,752,219.84 Medical Self Insurance Fund as of January 31, 2022 CASH Medical Self Ins Fund Cash 20 of 33 01.2022 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 550,000 498,921.24 633,500 543,514.52 550,000 272,464.00 318,536.84 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 $543,514.52 $550,000 $272,464.00 $318,536.84 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 433,314.63 550,000 258,658.98 265,161.30 843 - DENTAL SELF INS FUND EXPENSE $550,000 $455,407.48 $633,500 $433,314.63 $550,000 $258,658.98 $265,161.30 843 - DENTAL SELF INS FUND REVENUE OVER / UNDER EXPENSES $0 $43,513.76 $0 $110,199.89 $0 $13,805.02 $53,375.54 Dental Self Insurance Fund as of January 31, 2022 FY 2020 FY 2022 FY 2022FY 2020 FY 2021 FY 2021 Same Period Last Year Same Period Last Year Dental Self Ins Fund 843 21 of 33 01.2022 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Month 2020 2021 2022 2023 July $612,444.32 $724,520.63 August $602,629.10 $696,545.18 September $609,678.56 $734,630.02 October $603,363.16 $695,046.20 November $620,268.72 $701,911.17 December $653,169.60 $711,856.70 January $536,850.80 $657,824.44 $731,212.41 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 $703,042.49 Dental Self Insurance Fund as of January 31, 2022 CASH Dental Self Ins Fund Cash 22 of 33 01.2022 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 1,320,000 1,760,442.82 1,965,000 913,653.88 1,500,000 234,865.08 179,863.22 36 - ENTERPRISE CHARGES 0 0.00 0 0.00 0 25.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 $913,653.88 $1,500,000 $234,890.08 $179,863.22 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 177,591.22 666,569.63 845 - RETIREE SELF INS FUND EXPENSE $1,320,000 $1,172,243.73 $1,965,000 $1,122,842.12 $1,500,000 $177,591.22 $666,569.63 845 - RETIREE SELF INS FUND REVENUE OVER / UNDER EXPENSES $0 $588,199.09 $0 $209,188.24 $0 $57,298.86 $486,706.41 Retiree Self Insurance Fund as of January 31, 2022 FY 2020 FY 2022FY 2020 FY 2021 FY 2021 FY 2022 Same Period Last Year Same Period Last Year Retiree Self Ins Fund 845 23 of 33 01.2022 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 $433,709.18 September $489,464.41 $465,741.89 October $466,294.49 $453,817.31 November $396,067.66 $466,968.91 December $334,887.79 $476,600.30 January ($315,453.19)$206,371.20 $490,257.62 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)$428,365.66 Retiree Self Insurance Fund as of January 31, 2022 CASH Retiree Self Ins Fund Cash 24 of 33 01.2022 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 0 0.00 1,000,000 373,149.74 450,000 185,422.44 239,716.06 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 $185,422.44 $239,716.06 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 236,077.77 251,701.34 860 - FSA FUND EXPENSE $860,000 $16,054.01 $1,000,000 $348,138.39 $450,000 $236,077.77 $251,701.34 860 - FSA FUND REVENUE OVER / UNDER EXPENSES $0 $18,325.15 $0 $25,011.35 $0 $50,655.33 $11,985.28 Flexible Spending Account Fund as of January 31, 2022 FY 2020 FY 2022 FY 2022 FY 2020 FY 2021 FY 2021 Same Period Last Year Same Period Last Year FSA Fund 860 25 of 33 01.2022 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 $18,082.11 September ($5,068.36)$30,223.42 October ($4,643.01)$938.53 November $8,077.84 $2,584.11 December $26,646.09 ($109.30) January $0.00 $59,353.69 $5,603.91 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)$46,567.40 Flexible Spending Account Fund as of January 31, 2022 CASH FSA Fund Cash 26 of 33 01.2022 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 0 52,797.93 89,508 203,985.55 113,111 52,234.00 37,295.00 38 - MISCELLANEOUS INCOME 3,850 102,732.81 27,600 108,493.81 12,000 44,546.00 19,883.53 39 - NON-REVENUE RECEIPTS 200,000 200,000.00 150,000 150,000.00 100,000 100,000.00 150,000.00 880 - FLEET SERVICES FUND REVENUE $203,850 $355,530.74 $267,108 $462,479.36 $225,111 $196,780.00 $207,178.53 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 42,466.00 34,981.61 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 $42,466.00 $34,981.61 880 - FLEET SERVICES FUND REVENUE OVER / UNDER EXPENSES $0 $259,999.89 $0 $427,497.75 $0 $154,314.00 $172,196.92 Fleet Services Fund as of January 31, 2022 FY 2020 FY 2022FY 2020 FY 2021 FY 2021 FY 2022 Same Period Last Year Same Period Last Year Fleet Services Fund 880 27 of 33 01.2022 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Month 2020 2021 2022 2023 July $601,279.16 $1,090,458.91 August $609,506.58 $1,184,866.91 September $615,658.56 $1,229,825.91 October $624,166.20 $1,229,825.91 November $632,714.95 $1,214,819.91 December $791,230.55 $1,236,861.91 January $565,853.83 $799,782.08 $1,244,772.91 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 $1,090,458.91 Fleet Services Fund as of January 31, 2022 CASH Fleet Services Fund Cash 28 of 33 01.2022 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 940,000 1,214,177.01 1,413,384 1,794,850.94 1,568,420 689,797.97 666,375.67 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 350,000.00 350,000.00 890 - INFO TECHNOLOGY FUND REVENUE $1,290,000 $1,564,177.01 $2,020,384 $2,147,055.94 $1,918,420 $1,039,797.97 $666,375.67 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 809,473.26 961,692.65 890 - INFO TECHNOLOGY FUND EXPENSE $1,290,000 $909,856.76 $2,020,384 $1,730,021.57 $1,918,420 $809,473.26 $961,692.65 890 - INFO TECHNOLOGY FUND REVENUE OVER / UNDER EXPENSES $0 $654,320.25 $0 $417,034.37 $0 $230,324.71 $54,683.02 Information Technology Fund as of January 31, 2022 FY 2020 FY 2022FY 2020 FY 2021 FY 2021 FY 2022 Same Period Last Year Same Period Last Year Info Technology Fund 890 29 of 33 01.2022 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Month 2020 2021 2022 2023 July $852,093.02 $1,491,852.27 August $804,366.93 $1,558,798.40 September $800,161.86 $1,577,002.07 October $902,530.92 $1,729,919.23 November $889,233.88 $1,765,161.46 December $1,046,992.00 $1,751,059.99 January $515,312.48 $1,189,759.12 $1,794,385.65 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,492,175.30 Information Technology Fund as of January 31, 2022 CASH Info Technology Fund Cash 30 of 33 01.2022 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 33 - INTRGVRNMNTL - FEDRL 361,795 237,905.37 313,368 168,677.61 400,918 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 17,090.17 8,994.84 39 - NON-REVENUE RECEIPTS 50,000 50,000.00 57,484 57,484.00 0 0.00 48,893.00 250 - VET TREATMENT COURT REVENUE $496,795 $334,143.63 $526,692 $274,151.82 $501,986 $17,090.17 $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,609.26 501,986 121,527.23 122,941.49 250 - VET TREATMENT COURT EXPENSE $496,795 $323,503.39 $526,692 $269,609.26 $501,986 $121,527.23 $122,941.49 250 - VET TREATMENT COURT REVENUE OVER / UNDER EXPENSES $0 $10,640.24 $0 $4,542.56 $0 $104,437.06 $65,053.65 Veteran's Treatment Court as of January 31, 2022 FY 2020 FY 2020 FY 2021 FY 2021 FY 2022 FY 2022 Same Period Last Year Same Period Last Year Veteran's Treatment Court 250 31 of 33 01.2022 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Month 2020 2021 2022 2023 July $3,916.48 $26,014.22 August ($19.11)$6,936.02 September ($5,847.89)$1,617.01 October ($52,239.74)($48,042.22) November ($55,209.63)($67,669.08) December ($10,827.18)($74,565.51) January $7,582.66 ($54,087.90)($93,893.26) 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 $36,571.92 Veteran's Treatment Court as of January 31, 2022 CASH Veteran's Treatment Court Cash 32 of 33 01.2022 Monthly Master as of December 31, 2020 1. Current year activity : City Hold Harmless School Hold HarmlessFiscal Year 2022 Article 39 Article 40 Article 42 Article 40 Article 42 Article 44 Article 44 *524 Article 46 Article 39 Article 39 Special Total July, 2021 873,616.34$ 696,818.04$ 270,497.04$ 246,763.14$ 493,526.29$ -$ 459,092.34$ 250,664.40$ (139,686.11)$ (236,809.36)$ 180,905.28$ 3,095,387.40$ August, 2021 774,746.17$ 653,135.22$ 241,332.11$ 232,372.88$ 464,745.77$ 3.78$ 459,092.34$ 221,450.95$ (133,268.57)$ (234,850.37)$ 160,727.74$ 2,839,488.02$ September, 2021 1,051,674.97$ 652,833.31$ 307,490.95$ 230,720.67$ 461,441.34$ 13.64$ 459,092.34$ 310,685.98$ (123,042.19)$ (160,389.43)$ 213,535.76$ 3,404,057.34$ October, 2021 1,126,998.11$ 651,080.78$ 328,641.02$ 228,015.77$ 456,031.55$ -$ 459,092.34$ 333,701.55$ (118,932.77)$ (136,907.67)$ 228,643.57$ 3,556,364.25$ November, 2021 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ December, 2021 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ January, 2022 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ February, 2022 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ March, 2022 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ April, 2022 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ May, 2022 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ June, 2022 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 3,827,035.59$ 2,653,867.35$ 1,147,961.12$ 937,872.46$ 1,875,744.95$ 17.42$ 1,836,369.36$ 1,116,502.88$ (514,929.64)$ (768,956.83)$ 783,812.35$ 12,895,297.01$ Year over Year Change 12.30%14.13%8.87%18.55%18.55%-88.17%14.05%14.37%17.71%21.33%16.24%13.61% 2. Comparison to prior year : 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 1,079,358.91$ 715,009.70$ 315,068.41$ 255,553.82$ 511,107.64$ -$ 459,092.35$ 317,141.27$ (138,503.27)$ (198,357.22)$ 209,085.12$ 3,524,556.73$ 3,408,016.06$ 2,325,282.60$ 1,054,461.41$ 791,123.00$ 1,582,246.01$ 147.25$ 1,610,114.92$ 976,178.22$ (437,464.21)$ (633,771.23)$ 674,312.81$ 11,350,646.84$ AnnualizedBudget % Collected(4 months)to Date1103100 310231 2,543,149.12$ 9,400,000$ (6,856,850.88)$ 3,133,333$ (590,184.21)$ 27.05%NC Sales Tax - Article 391103100 310233 2,653,867.35$ 6,700,000$ (4,046,132.65)$ 2,233,333$ 420,534.02$ 39.61%NC Sales Tax - Article 40 (General Fund)1103100 310235 1,147,961.12$ 1,500,000$ (352,038.88)$ 500,000$ 647,961.12$ 76.53%NC Sales Tax - Article 42 (General Fund)1103100 310237 1,836,386.78$ 4,700,000$ (2,863,613.22)$ 1,566,667$ 269,720.11$ 39.07%NC Sales Tax - Article 44 & Article 44 *5248,181,364.37$ 22,300,000.00$ (14,118,635.63)$ 7,433,333.33$ 748,031.04$ 36.69% 2118401 - 380892 783,812.35$ 1,994,716.00$ (1,210,903.65)$ 664,905.33$ 118,907.02$ 39.29%NC Sales Tax Special Districts 3003100 310233 937,872.46$ 1,969,000$ (1,031,127.54)$ 656,333$ 281,539.13$ 47.63%NC Sales Tax - Article 40 (Education)3003100 310235 1,875,744.95$ 3,900,000$ (2,024,255.05)$ 1,300,000$ 575,744.95$ 48.10%NC Sales Tax - Article 42 (Education)3003100 310239 1,116,502.88$ 2,534,748$ (1,418,245.12)$ 844,916$ 271,586.88$ 44.05%NC Sales Tax - Article 463,930,120.29$ 8,403,748.00$ (4,473,627.71)$ 2,801,249.33$ 1,128,870.96$ 46.77% 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 33 12.2021 Monthly Master