Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
June 2021 Pre-Close Financial Report
Revenue Category Budget Actual Budget Actual Budget Actual 30 - TAXES - AD VALOREM 63,555,052 65,856,429.57 66,079,417 67,452,336.92 66,850,000 70,991,210.26 67,452,336.92 31 - TAXES - SALES 13,904,175 13,613,356.20 18,265,000 20,597,227.82 18,400,000 19,506,030.73 20,597,227.82 32 - TAXES - OTHER 1,325,000 1,136,871.38 572,000 736,457.89 530,000 1,012,526.63 736,457.89 33 - INTRGVRNMNTL - FEDRL 15,035,872 14,010,628.13 15,358,264 14,502,831.23 17,355,230 14,484,984.25 14,502,831.23 34 - INTRGVRNMNTL - STATE 5,694,716 6,499,701.76 6,686,121 8,284,382.38 6,483,859 7,446,101.06 8,284,382.38 35 - SERVICE CHARGES 15,379,152 12,725,228.02 16,781,629 14,237,895.08 15,319,535 13,945,085.77 14,237,895.08 36 - ENTERPRISE CHARGES 5,000 14,000.56 5,000 4,262.92 3,000 1,672.35 4,262.92 38 - MISCELLANEOUS INCOME 5,284,839 2,173,980.32 2,276,907 5,407,368.98 1,551,807 1,885,986.84 5,407,368.98 39 - NON-REVENUE RECEIPTS 6,962,858 3,306,256.00 4,054,805 644,682.10 11,942,137 2,024,968.00 644,682.10 110 - GENERAL FUND REVENUE $127,146,664 $119,336,451.94 $130,079,143 $131,867,445.32 $138,435,568 $131,298,565.89 $131,867,445.32 Expense Function Department Budget Actual Budget Actual Budget Actual 110 - GENERAL 00 - GENERAL GOVERNMENT 4110 - GOVERNING BODY 481,172 419,795.24 405,127 373,092.30 788,447 713,409.00 373,092.30 4120 - COUNTY ADMINISTRATION 785,523 723,709.40 908,274 888,035.06 1,036,614 912,214.22 888,035.06 4130 - FINANCE 1,476,524 1,269,178.47 1,506,606 1,411,933.85 1,306,824 1,220,138.95 1,411,933.85 4131 - RETIREE INSURANCE 520,000 478,141.26 571,000 571,000.00 882,000 800,812.98 571,000.00 4140 - TAX 1,696,599 1,591,162.11 1,746,836 1,554,218.86 1,551,703 1,296,585.51 1,554,218.86 4150 - LEGAL SERVICES 342,015 304,983.91 356,342 309,378.48 363,565 304,376.34 309,378.48 4160 - HUMAN RESOURCES 433,375 401,159.91 480,451 432,931.39 505,151 457,254.59 432,931.39 4170 - BOARD OF ELECTIONS 450,505 414,927.56 561,515 458,625.51 597,465 498,113.68 458,625.51 4180 - CLERK OF COURT 85,352 12,445.89 93,433 42,782.84 26,083 12,142.04 42,782.84 4190 - REGISTER OF DEEDS 825,889 785,435.98 884,396 821,751.63 889,071 705,358.99 821,751.63 4210 - GENERAL SERVICES 221,188 214,783.85 222,831 221,242.15 227,775 216,812.25 221,242.15 4230 - FACILITIES MAINTENANCE 3,365,763 2,893,327.74 3,447,272 2,978,382.48 3,610,387 3,250,980.12 2,978,382.48 4250 - FLEET MAINTENANCE 668,998 617,341.28 684,307 665,435.73 629,738 591,770.24 665,435.73 4270 - INFORMATION TECHNOLOGY 2,499,371 2,199,543.24 2,589,405 2,484,827.31 2,554,198 2,423,236.98 2,484,827.31 4290 - GIS 739,546 714,674.75 765,223 737,924.98 700,709 633,247.83 737,924.98 9800 - INTERFUND TRANSFERS 15,188,568 16,210,096.00 15,303,912 15,290,048.00 21,454,238 19,445,647.00 15,290,048.00 9910 - CONTINGENCY 413,989 0.00 196,450 0.00 454,020 0.00 0.00 00 - GENERAL GOVERNMENT Total $30,194,377 $29,250,706.59 $30,723,380 $29,241,610.57 $37,577,988 33,482,100.72 29,241,610.57 10 - PUBLIC SAFETY 4310 - SHERIFF 11,153,352 10,564,709.76 11,714,191 11,385,405.62 12,192,507 11,199,671.58 11,385,405.62 4330 - CAMPBELL DEPUTIES 532,138 486,531.83 551,807 476,310.20 477,204 443,163.56 476,310.20 Same Period Last Year FY 2019 FY 2020 FY 2021 Same Period Last Year as of June 30, 2021 General Fund FY 2019 FY 2020 FY 2021 General Fund 110 1 of 29 06.2021 Monthly Master Expense Function Department Budget Actual Budget Actual Budget Actual Same Period Last Year FY 2019 FY 2020 FY 2021 4350 - SCHOOL RESOURCE OFFICER 1,346,158 1,168,811.24 2,301,216 1,341,492.52 2,254,482 1,418,534.95 1,341,492.52 4370 - CHILD SUPPORT ENFORCEMENT 85,979 71,437.31 86,495 59,949.60 71,676 62,521.42 59,949.60 4390 - JAIL 5,538,213 5,022,721.57 5,950,242 5,592,459.65 5,836,177 5,371,629.22 5,592,459.65 4410 - EMERGENCY MANAGEMENT 1,132,980 1,013,159.27 1,058,089 1,006,385.67 1,004,854 848,360.33 1,006,385.67 4411 - EMERGENCY SERVICES GRANTS 540,660 52,682.78 567,249 565,394.86 208,975 205,379.52 565,394.86 4450 - EMERGENCY MEDICAL SERVICE 7,448,728 6,891,711.06 8,070,165 7,615,472.99 9,162,453 7,757,670.61 7,615,472.99 4451 - EMS TRANSPORTS 0 0.00 0 0.00 0 0.00 0.00 4470 - RESCUE DISTRICTS 3,636,434 3,636,434.00 3,673,427 3,673,427.00 3,673,427 3,673,427.00 3,673,427.00 4510 - FIELD SERVICES 352,711 292,928.06 324,321 282,242.96 321,672 282,327.46 282,242.96 4512 - ANIMAL SHELTER 300,045 240,018.04 330,074 219,190.31 359,570 229,783.69 219,190.31 4530 - MEDICAL EXAMINER 68,423 59,800.00 125,000 121,050.00 95,000 87,000.00 121,050.00 4570 - COMMUNICATIONS 1,943,159 1,777,279.78 1,999,555 1,868,768.01 1,762,248 1,524,342.61 1,868,768.01 10 - PUBLIC SAFETY Total $34,078,980 $31,278,224.70 $36,751,831 $34,207,549.39 $37,420,245 33,103,811.95 34,207,549.39 20 - TRANSPORTATION 4610 - TRANSPORTATION 1,441,363 1,314,072.25 1,523,304 1,082,398.03 1,513,691 906,524.13 1,082,398.03 4630 - TRANSPORTATION - ADMIN 553,174 287,174.87 663,619 492,512.68 739,696 697,416.59 492,512.68 4650 - HARNETT REGIONAL JETPORT 275,115 250,809.36 244,776 198,852.98 509,520 352,598.55 198,852.98 20 - TRANSPORTATION Total $2,269,652 $1,852,056.48 $2,431,699 $1,773,763.69 $2,762,907 1,956,539.27 1,773,763.69 30 - ENVIRONMENTAL PROTECTION 4710 - SOIL & WATER 206,830 174,916.47 234,187 222,440.11 237,233 209,182.41 222,440.11 4730 - FORESTRY PROGRAM 121,519 107,132.79 136,272 124,123.36 138,026 123,612.67 124,123.36 4750 - ENVIROMENTAL PROT ALLOC 4,000 4,000.00 4,000 4,000.00 6,000 6,000.00 4,000.00 30 - ENVIRONMENTAL PROTECTION Total $332,349 $286,049.26 $374,459 $350,563.47 $381,259 338,795.08 350,563.47 40 - ECONOMIC & PHYSICAL DEVELOPMNT 4910 - DEVELOPMENT SERVICES 1,681,315 1,455,006.72 1,860,624 1,551,440.18 1,665,394 1,570,446.66 1,551,440.18 4930 - ECONOMIC DEVELOPMENT 1,630,279 1,359,757.88 1,029,298 729,534.58 777,877 661,814.64 729,534.58 4950 - COMMUNITY DEVELOPMENT 1,300 65.09 1,375 192.45 925 491.89 192.45 4951 - ABANDONED MFG HOME 37,740 36,023.31 30,854 26,962.71 0 0.00 26,962.71 4990 - COOPERATIVE EXTENSION 406,863 302,177.19 408,665 355,800.19 405,145 321,104.56 355,800.19 4995 - COOPERATIVE EXT SPECIAL PROG 244,662 154,747.68 283,018 211,037.23 170,152 77,640.44 211,037.23 40 - ECONOMIC & PHYSICAL DEVELOPMNT Total $4,002,159 $3,307,777.87 $3,613,834 $2,874,967.34 $3,019,493 2,631,498.19 2,874,967.34 50 - HUMAN SERVICES 5110 - HEALTH - ADMINISTRATION 7,154,208 5,784,231.16 6,635,444 5,609,257.46 7,370,852 5,424,621.35 5,609,257.46 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,373,955 1,302,702.79 1,401,534 1,307,710.38 1,679,594 1,430,482.70 1,307,710.38 5170 - HEALTH - COMMUNICABLE DISEASES 0 49.99 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 605,679.00 605,679 605,679.00 605,679.00 5310 - DSS - ADMINISTRATION 13,265,900 12,070,433.33 2,613,128 2,388,014.64 2,436,585 1,891,230.92 2,388,014.64 General Fund 110 2 of 29 06.2021 Monthly Master Expense Function Department Budget Actual Budget Actual Budget Actual Same Period Last Year FY 2019 FY 2020 FY 2021 5311 - DSS - FRAUD PREVENTION 0 0.00 264,033 231,968.94 297,397 279,270.81 231,968.94 5320 - DSS - ADULT SERVICES 67,316 53,220.68 1,133,036 1,099,638.00 888,982 797,976.75 1,099,638.00 5321 - DSS - WORKFIRST 69,000 57,442.54 344,636 269,512.32 303,231 269,262.43 269,512.32 5322 - DSS - ENERGY PROGRAMS 1,094,681 1,031,701.50 1,117,949 1,122,625.44 1,374,286 1,220,383.03 1,122,625.44 5330 - DSS - CHILD CARE SUBSIDY 0 0.00 2,900,405 2,650,694.52 376,627 349,324.66 2,650,694.52 5331 - DSS - CHILD PROTECTIVE SRVCS 2,224 1,646.62 59,098 24,615.13 2,127,436 1,921,100.40 24,615.13 5332 - DSS - FOSTER CARE 1,758,934 1,299,775.18 1,752,348 1,547,642.72 2,711,023 2,344,719.87 1,547,642.72 5333 - DSS - ADOPTION 458,000 275,756.88 480,710 271,332.20 397,847 286,400.14 271,332.20 5334 - DSS - DAY CARE 0 0.00 254,662 185,388.79 22,315 0.00 185,388.79 5340 - DSS - CHILD SUPPORT 55,565 33,584.25 1,328,691 1,190,151.75 1,331,417 1,155,482.23 1,190,151.75 5350 - DSS - MEDICAID 0 0.00 0 0.00 0 0.00 0.00 5351 - DSS - ADULT MEDICAID 955,000 783,917.04 2,491,982 2,212,563.34 2,215,437 1,976,670.74 2,212,563.34 5352 - DSS - FAMILY & CHLDRN MEDICAID 0 0.00 1,565,673 1,463,483.95 1,541,975 1,436,469.40 1,463,483.95 5353 - DSS - MEDICAID TRANSPORTATION 120,000 70,597.82 147,593 64,879.10 211,078 184,856.55 64,879.10 5360 - DSS - TEMPORARY RESOURCES 314 124.00 0 0.00 124 0.00 0.00 5370 - DSS - FOOD STAMPS 54,587 32,413.79 1,459,502 1,290,644.00 1,498,504 1,408,534.29 1,290,644.00 5810 - VETERANS SERVICES 288,684 263,442.42 299,545 270,170.03 304,997 231,936.66 270,170.03 5870 - RESTITUTION 106,359 87,706.06 102,017 93,474.71 82,712 75,431.15 93,474.71 5895 - HUMAN SERVICES APPROPRIATIONS 42,000 31,325.75 37,688 31,117.70 32,000 0.00 31,117.70 50 - HUMAN SERVICES Total $27,472,406 $23,785,750.80 $26,995,353 $23,930,564.12 $27,810,098 23,289,833.08 23,930,564.12 70 - EDUCATION 5910 - BOARD OF EDUCATION 24,710,061 23,688,533.30 24,680,603 24,680,603.00 24,680,603 24,680,603.00 24,680,603.00 5920 - CCCC 1,340,207 1,162,438.00 1,626,978 1,551,147.64 1,621,978 1,359,842.33 1,551,147.64 70 - EDUCATION Total $26,050,268 $24,850,971.30 $26,307,581 $26,231,750.64 $26,302,581 26,040,445.33 26,231,750.64 80 - CULTURAL & RECREATION 6110 - PARKS & RECREATION 1,281,827 1,074,684.64 1,326,751 1,172,372.50 1,399,432 1,186,575.34 1,172,372.50 6170 - LIBRARY 1,276,636 1,078,918.13 1,335,059 1,058,294.68 1,542,378 1,225,771.86 1,058,294.68 6199 - CULTURAL & REC APPROP 188,010 188,010.00 219,196 172,360.00 219,187 184,589.00 172,360.00 80 - CULTURAL & RECREATION Total $2,746,473 $2,341,612.77 $2,881,006 $2,403,027.18 $3,160,997 2,596,936.20 2,403,027.18 110 - GENERAL FUND EXPENSE $127,146,664 $116,953,149.77 $130,079,143 $121,013,796.40 $138,435,568 $123,439,959.82 $121,013,796.40 110 - GENERAL FUND REVENUE OVER / UNDER EXPENSES $0 $2,383,302.17 $0 $10,853,648.92 $0 $7,858,606.07 $10,853,648.92 General Fund 110 3 of 29 06.2021 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Month 2020 2021 2022 2023 July $33,238,397.31 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 $50,815,370.49 General Fund as of June 30, 2021 CASH General Fund Cash 4 of 29 06.2021 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 33 - INTRGVRNMNTL - FEDRL 3,703 3,703.09 3,703 0.00 3,703 325,618.70 0.00 35 - SERVICE CHARGES 12,000 42,325.30 15,000 143,502.18 10,581 2,561.90 143,502.18 36 - ENTERPRISE CHARGES 1,442,250 1,740,247.46 1,381,500 1,671,386.38 1,583,500 1,620,856.41 1,671,386.38 37 - FACILITY FEES 30,967,800 36,720,640.48 32,575,000 37,720,428.29 34,600,000 36,354,467.96 37,720,428.29 38 - MISCELLANEOUS INCOME 1,589,197 4,529,164.45 705,000 7,993,723.20 710,000 532,344.86 7,993,723.20 39 - NON-REVENUE RECEIPTS 5,397,151 0.00 7,672,747 0.00 14,305,000 0.00 0.00 610 - HRW FUND REVENUE $39,412,101 $43,036,080.78 $42,352,950 $47,529,040.05 $51,212,784 $38,835,849.83 $47,529,040.05 Expense Function Department Budget Actual Budget Actual Budget Actual 610 - HARNETT REGIONAL WATER 91 - WATER & SEWER 7111 - HRW ADMINISTRATION 16,697,893 26,247,382.03 19,689,398 28,937,487.52 28,373,613 25,067,579.95 28,937,487.52 7113 - WATER TREATMENT PLANT 5,990,442 5,661,244.35 6,569,748 5,422,700.11 5,966,684 4,945,324.02 5,422,700.11 7115 - WASTEWATER TREATMENT PLANT 3,053,431 2,221,601.59 3,062,790 2,054,660.74 3,385,564 2,981,236.38 2,054,660.74 7117 - SOUTH HARNETT WASTEWATER PLANT 3,348,425 2,577,468.93 3,173,670 2,210,178.83 2,975,213 2,407,655.61 2,210,178.83 7119 - WATER DISTRIBUTION 4,919,415 4,232,070.87 5,167,052 4,089,298.68 5,065,366 4,320,441.59 4,089,298.68 7121 - SEWER COLLECTIONS 5,402,495 4,196,138.50 4,690,292 4,075,030.16 5,446,344 4,274,023.25 4,075,030.16 7131 - RETIREE INSURANCE HRW 0 0.00 0 0.00 0 55,348.38 0.00 610 - HRW FUND EXPENSE $39,412,101 $45,135,906.27 $42,352,950 $46,789,356.04 $51,212,784 $44,051,609.18 $46,789,356.04 610 - HRW FUND REVENUE OVER / UNDER EXPENSES $0 $2,099,825.49 $0 $739,684.01 $0 $5,215,759.35 $739,684.01 Same Period Last Year FY 2019 FY 2020 FY 2021 Same Period Last Year Harnett Regional Water Fund as of June 30, 2021 FY 2019 FY 2020 FY 2021 HRW Fund 610 5 of 29 06.2021 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Month 2020 2021 2022 2023 July $56,308,485.60 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 $51,048,491.30 Harnett Regional Water Fund as of June 30, 2021 CASH HRW Fund Cash 6 of 29 06.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 320,000 282,190.82 260,000 283,640.35 282,000 219,437.29 283,640.35 35 - SERVICE CHARGES 340 2,211.83 0 6,122.07 553 2,038.50 6,122.07 36 - ENTERPRISE CHARGES 1,807,020 2,254,274.12 1,930,200 2,515,403.09 1,910,200 3,114,682.13 2,515,403.09 37 - FACILITY FEES 3,644,332 3,738,378.18 3,550,000 3,760,202.26 4,581,020 4,648,605.96 3,760,202.26 38 - MISCELLANEOUS INCOME 63,894 49,557.00 70,200 51,846.93 100,733 139,571.68 51,846.93 39 - NON-REVENUE RECEIPTS 0 0.00 0 0.00 0 0.00 0.00 660 - SOLID WASTE FUND REVENUE $5,835,586 $6,326,611.95 $5,810,400 $6,617,214.70 $6,874,506 $8,124,335.56 $6,617,214.70 Expense Function Department Budget Actual Budget Actual Budget Actual 660 - SOLID WASTE MANAGEMENT 96 - SOLID WASTE 7410 - SOLID WASTE MANAGEMENT 5,835,586 5,476,100.79 5,810,400 5,283,770.49 6,874,506 6,207,040.79 5,283,770.49 7431 - RETIREE INSURANCE SW 0 0.00 0 9,717.30 0 19,741.42 9,717.30 660 - SOLID WASTE FUND EXPENSE $5,835,586 $5,476,100.79 $5,810,400 $5,293,487.79 $6,874,506 $6,226,782.21 $5,293,487.79 660 - SOLID WASTE FUND REVENUE OVER / UNDER EXPENSES $0 $850,511.16 $0 $1,323,726.91 $0 $1,897,553.35 $1,323,726.91 Solid Waste Fund as of June 30, 2021 FY 2019 FY 2020 FY 2021 Same Period Last Year FY 2019 FY 2020 FY 2021 Same Period Last Year Solid Waste Fund 660 7 of 29 06.2021 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Month 2020 2021 2022 2023 July $3,387,995.72 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,728.49 Solid Waste Fund as of June 30, 2021 CASH Solid Waste Fund Cash 8 of 29 06.2021 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 1,100,000 685,240.71 1,100,000 939,774.61 1,200,000 1,081,094.39 939,774.61 38 - MISCELLANEOUS INCOME 150,000 98,189.90 1,003,788 994,240.57 0 1,350.81 994,240.57 39 - NON-REVENUE RECEIPTS 0 0.00 0 0.00 11,700 0.00 0.00 810 - WORKER'S COMP FUND REVENUE $1,250,000 $783,430.61 $2,103,788 $1,934,015.18 $1,211,700 $1,082,445.20 $1,934,015.18 Expense Function Department Budget Actual Budget Actual Budget Actual 810 - WORKERS COMPENSATION FUND 00 - GENERAL GOVERNMENT 9301 - WORKER'S COMPENSATION 1,250,000 712,628.74 2,103,788 1,415,657.00 1,211,700 471,708.73 1,415,657.00 810 - WORKER'S COMP FUND EXPENSE $1,250,000 $712,628.74 $2,103,788 $1,415,657.00 $1,211,700 $471,708.73 $1,415,657.00 810 - WORKERS'S COMP FUND REVENUE OVER / UNDER EXPENSES $0 $1,496,059.35 $0 $518,358.18 $0 $610,736.47 $518,358.18 Worker's Compensation Fund as of June 30, 2021 FY 2019 FY 2020 FY 2021 Same Period Last Year FY 2019 FY 2020 FY 2021 Same Period Last Year Worker's Comp Fund 810 9 of 29 06.2021 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Month 2020 2021 2022 2023 July $4,629,563.32 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 June 30, 2021 CASH Worker's Comp Fund Cash 10 of 29 06.2021 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 200,000 207,126.33 100,000 202,177.75 250,000 216,982.73 202,177.75 39 - NON-REVENUE RECEIPTS 0 0.00 0 0.00 0.00 0.00 0.00 820 - UNEMPLOYMENT FUND REVENUE $200,000 $207,126.33 $100,000 $202,177.75 $250,000 $216,982.73 $202,177.75 Expense Function Department Budget Actual Budget Actual Budget Actual 820 - UNEMPLOYMENT INSURANCE 00 - GENERAL GOVERNMENT 9305 - UNEMPLOYMENT INSURANCE 200,000 $14,002.44 100,000 $16,752.83 250,000 $19,734.22 16,752.83 820 - UNEMPLOYMENT FUND EXPENSE $200,000 $14,002.44 $100,000 $16,752.83 $250,000 $19,734.22 $16,752.83 820 - UNEMPLOYMENT FUND REVENUE OVER / UNDER EXPENSES $0 $193,123.89 $0 $185,424.92 $0 $197,248.51 $185,424.92 Unemployment Insurance Fund as of June 30, 2021 FY 2021 Same Period Last Year FY 2019 FY 2020 FY 2021 Same Period Last Year FY 2020FY 2019 Unemployment Ins Fund 820 11 of 29 06.2021 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Month 2020 2021 2022 2023 July $1,564,861.07 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 June 30, 2021 CASH Unemployment Ins Fund Cash 12 of 29 06.2021 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 175,056 136,633.87 173,720 195,434.80 174,690 152,460.00 195,434.80 38 - MISCELLANEOUS INCOME 1,233 4,000.00 6,000 6,000.00 0 0.00 6,000.00 39 - NON-REVENUE RECEIPTS 0 0.00 0 0.00 0 0.00 0.00 830 - EMPLOYEE CLINIC FUND REVENUE $176,289 $140,633.87 $179,720 $201,434.80 $174,690 $152,460.00 $201,434.80 Expense Function Department Budget Actual Budget Actual Budget Actual 830 - EMPLOYEE CLINIC 00 - GENERAL GOVERNMENT 9302 - EMPLOYEE CLINIC 176,289 166,177.41 179,720 163,177.85 174,690 165,851.97 163,177.85 830 - EMPLOYEE CLINIC FUND EXPENSE $176,289 $166,177.41 $179,720 $163,177.85 $174,690 $165,851.97 $163,177.85 830 - EMPLOYEE CLINIC FUND REVENUE OVER / UNDER EXPENSES $0 $25,543.54 $0 $38,256.95 $0 $13,391.97 $38,256.95 Employee Clinic Fund as of June 30, 2021 FY 2019 FY 2020 FY 2021 Same Period Last Year FY 2019 FY 2020 FY 2021 Same Period Last Year Employee Clinic Fund 830 13 of 29 06.2021 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Month 2020 2021 2022 2023 July $700,090.56 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 June 30, 2021 CASH Employee Clinic Fund Cash 14 of 29 06.2021 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 8,050,000 8,831,680.41 9,033,000 9,578,505.48 11,296,710 9,255,764.98 9,578,505.48 38 - MISCELLANEOUS INCOME 42,000 11,187.81 113,442 120,058.34 17,875 12,867.15 120,058.34 841 - MEDICAL SELF INS FUND REVENUE $8,092,000 $8,842,868.22 $9,146,442 $9,698,563.82 $1,000,000 $0.00 $0.00 Expense Function Department Budget Actual Budget Actual Budget Actual 841 - MEDICAL INSURANCE - SELF 00 - GENERAL GOVERNMENT 9303 - MEDICAL INSURANCE - SELF 8,092,000 7,414,808.65 9,146,442 7,438,276.99 12,314,585 8,806,381.42 7,438,276.99 841 - MEDICAL SELF INS FUND EXPENSE $8,092,000 $7,414,808.65 $9,146,442 $7,438,276.99 $12,314,585 $8,806,381.42 $7,438,276.99 841 - MEDICAL SELF INS FUND REVENUE OVER / UNDER EXPENSES $0 $1,428,059.57 $0 $2,260,286.83 $0 $462,250.71 $2,260,286.83 Medical Self Insurance Fund as of June 30, 2021 FY 2019 FY 2020 FY 2021 Same Period Last Year FY 2019 FY 2020 FY 2021 Same Period Last Year Medical Self Ins Fund 841 15 of 29 06.2021 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Month 2020 2021 2022 2023 July $8,394,410.05 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 June 30, 2021 CASH Medical Self Ins Fund Cash 16 of 29 06.2021 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 475,000 572,780.84 550,000 498,921.24 633,500 491,092.16 498,921.24 843 - DENTAL SELF INS FUND REVENUE $475,000 $572,780.84 $550,000 $498,921.24 $0 $0.00 $0.00 Expense Function Department Budget Actual Budget Actual Budget Actual 843 - DENTAL INSURANCE - SELF 00 - GENERAL GOVERNMENT 9307 - DENTAL INSURANCE - SELF 475,000 431,830.55 550,000 455,407.48 633,500 435,870.63 455,407.48 843 - DENTAL SELF INS FUND EXPENSE $475,000 $431,830.55 $550,000 $455,407.48 $0 $0.00 $455,407.48 843 - DENTAL SELF INS FUND REVENUE OVER / UNDER EXPENSES $0 $140,950.29 $0 $43,513.76 $0 $55,221.53 $43,513.76 Dental Self Insurance Fund as of June 30, 2021 FY 2019 FY 2020 FY 2021 Same Period Last Year FY 2019 FY 2020 FY 2021 Same Period Last Year Dental Self Ins Fund 843 17 of 29 06.2021 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Month 2020 2021 2022 2023 July $612,444.32 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 June 30, 2021 CASH Dental Self Ins Fund Cash 18 of 29 06.2021 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 1,085,000 543,106.48 1,320,000 1,760,442.82 1,965,000 885,224.77 1,760,442.82 845 - RETIREE SELF INS FUND REVENUE $1,085,000 $543,106.48 $1,320,000 $1,760,442.82 $0 $0.00 $0.00 Expense Function Department Budget Actual Budget Actual Budget Actual 845 - MEDICAL INSURANCE RETIREE 00 - GENERAL GOVERNMENT 9304 - MEDICAL INSURANCE - RETIREE 1,085,000 1,411,811.01 1,320,000 1,172,243.73 1,965,000 1,122,842.12 1,172,243.73 845 - RETIREE SELF INS FUND EXPENSE $1,085,000 $1,411,811.01 $1,320,000 $1,172,243.73 $1,965,000 $1,122,842.12 $1,172,243.73 845 - RETIREE SELF INS FUND REVENUE OVER / UNDER EXPENSES $0 $868,704.53 $0 $588,199.09 $0 $237,617.35 $588,199.09 Retiree Self Insurance Fund as of June 30, 2021 FY 2019 FY 2020 FY 2021 Same Period Last Year FY 2019 FY 2020 FY 2021 Same Period Last Year Retiree Self Ins Fund 845 19 of 29 06.2021 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Month 2020 2021 2022 2023 July $646,924.11 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 June 30, 2021 CASH Retiree Self Ins Fund Cash 20 of 29 06.2021 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 0 0.00 0 0.00 1,000,000 358,566.91 0.00 38 - MISCELLANEOUS INCOME 0 0.00 860,000 34,379.16 0 0.00 34,379.16 39 - NON-REVENUE RECEIPTS 0 0.00 0 0.00 0 0.00 0.00 860 - FSA FUND REVENUE $0 $0.00 $860,000 $34,379.16 $1,000,000 $358,566.91 $34,379.16 Expense Function Department Budget Actual Budget Actual Budget Actual 860 - FLEXIBLE SPENDING ACCOUNT 00 - GENERAL GOVERNMENT 9306 - FLEXIBLE SPENDING ACCOUNT 0 0.00 860,000 16,054.01 1,000,000 346,785.31 16,054.01 860 - FSA FUND EXPENSE $0 $0.00 $860,000 $16,054.01 $1,000,000 $346,785.31 $16,054.01 860 - FSA FUND REVENUE OVER / UNDER EXPENSES $0 $0.00 $0 $18,325.15 $0 $11,781.60 $18,325.15 Flexible Spending Account Fund as of June 30, 2021 FY 2019 FY 2020 FY 2021 Same Period Last Year FY 2019 FY 2020 FY 2021 Same Period Last Year FSA Fund 860 21 of 29 06.2021 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Month 2020 2021 2022 2023 July $32,773.26 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 June 30, 2021 CASH FSA Fund Cash 22 of 29 06.2021 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 0 0.00 0 52,797.93 89,508 74,590.00 52,797.93 38 - MISCELLANEOUS INCOME 3,990 54,668.32 3,850 102,732.81 27,600 58,682.30 102,732.81 39 - NON-REVENUE RECEIPTS 200,000 200,000.00 200,000 200,000.00 150,000 150,000.00 200,000.00 880 - FLEET SERVICES FUND REVENUE $203,990 $254,668.32 $203,850 $355,530.74 $267,108 $283,272.30 $355,530.74 Expense Function Department Budget Actual Budget Actual Budget Actual 880 - FLEET SERVICES 00 - GENERAL GOVERNMENT 9410 - FLEET SERVICES 203,990 205,373.76 203,850 95,530.85 267,108 34,981.61 95,530.85 9910 - CONTINGENCY 0 0.00 0 0.00 0 0.00 0.00 880 - FLEET SERVICES FUND EXPENSE $203,990 $205,373.76 $203,850 $95,530.85 $267,108 $34,981.61 $95,530.85 880 - FLEET SERVICES FUND REVENUE OVER / UNDER EXPENSES $0 $49,294.56 $0 $259,999.89 $0 $248,290.69 $259,999.89 Fleet Services Fund as of June 30, 2021 FY 2019 FY 2020 FY 2021 Same Period Last Year FY 2019 FY 2020 FY 2021 Same Period Last Year Fleet Services Fund 880 23 of 29 06.2021 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Month 2020 2021 2022 2023 July $601,279.16 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 June 30, 2021 CASH Fleet Services Fund Cash 24 of 29 06.2021 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 940,000 808,960.41 940,000 1,214,177.01 1,413,384 1,368,537.84 1,214,177.01 38 - MISCELLANEOUS INCOME 0 0.00 0 0.00 0 2,205.00 0.00 39 - NON-REVENUE RECEIPTS 595,584 350,000.00 350,000 350,000.00 607,000 350,000.00 350,000.00 890 - INFO TECHNOLOGY FUND REVENUE $1,535,584 $1,158,960.41 $1,290,000 $1,564,177.01 $1,413,384 $1,370,742.84 $1,214,177.01 Expense Function Department Budget Actual Budget Actual Budget Actual 890 - INFORMATION TECHNOLOGY 00 - GENERAL GOVERNMENT 9420 - TECHNOLOGY 1,535,584 1,035,083.97 1,290,000 909,856.76 2,020,384 1,730,021.57 909,856.76 890 - INFO TECHNOLOGY FUND EXPENSE $1,535,584 $1,035,083.97 $1,290,000 $909,856.76 $2,020,384 $1,730,021.57 $909,856.76 890 - INFO TECHNOLOGY FUND REVENUE OVER / UNDER EXPENSES $0 $123,876.44 $0 $654,320.25 $0 $9,278.73 $654,320.25 Information Technology Fund as of June 30, 2021 FY 2019 FY 2020 FY 2021 Same Period Last Year FY 2019 FY 2020 FY 2021 Same Period Last Year Info Technology Fund 890 25 of 29 06.2021 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Month 2020 2021 2022 2023 July $852,093.02 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 June 30, 2021 CASH Info Technology Fund Cash 26 of 29 06.2021 Monthly Master Revenue Category Budget Actual Budget Actual Budget Actual 33 - INTRGVRNMNTL - FEDRL 604,583 467,587.88 361,795 237,905.37 313,368 0.00 237,905.37 34 - INTRGVRNMNTL - STATE 0 0.00 0 0.00 0 0.00 0.00 38 - MISCELLANEOUS INCOME 0 0.00 85,000 46,238.26 155,840 47,990.21 46,238.26 39 - NON-REVENUE RECEIPTS 0 0.00 50,000 50,000.00 57,484 48,893.00 50,000.00 250 - VET TREATMENT COURT REVENUE $604,583 $467,587.88 $496,795 $334,143.63 $313,368 $0.00 $237,905.37 Expense Function Department Budget Actual Budget Actual Budget Actual 250 - VETERANS SERVICE SRF 00 - GENERAL GOVERNMENT 4185 - VETERANS TREATMENT COURT 604,583 467,187.88 496,795 323,503.39 526,692 269,524.27 323,503.39 250 - VET TREATMENT COURT EXPENSE $604,583 $467,187.88 $496,795 $323,503.39 $526,692 $269,524.27 $323,503.39 250 - VET TREATMENT COURT REVENUE OVER / UNDER EXPENSES $0 $400.00 $0 $10,640.24 $0 $172,641.06 $10,640.24 FY 2019 FY 2020 FY 2021 Same Period Last Year Veteran's Treatment Court as of June 30, 2021 FY 2019 FY 2020 FY 2021 Same Period Last Year Veteran's Treatment Court 250 27 of 29 06.2021 Monthly Master Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Month 2020 2021 2022 2023 July $3,916.48 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 June 30, 2021 CASH Veteran's Treatment Court Cash 28 of 29 06.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 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ June, 2021 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 9,319,156.49$ 6,005,569.03$ 2,808,132.58$ 2,076,590.19$ 4,153,180.41$ 627.84$ 4,025,238.88$ 2,695,973.83$ (1,120,388.39)$ (1,532,305.70)$ 1,826,044.27$ 30,257,819.43$ Year over Year Change 23.03% 15.73% 19.75% 16.27% 16.27% 132.90% 3.88% 24.97% 12.96% 5.99% 23.40% 18.47% 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$ 7,574,601.24$ 5,189,231.58$ 2,345,032.36$ 1,785,971.83$ 3,571,943.68$ 269.58$ 3,874,859.03$ 2,157,312.67$ (991,803.66)$ (1,445,713.23)$ 1,479,815.37$ 25,541,520.45$ AnnualizedBudget % Collected(10 months)to Date1103100 310231 6,666,462.40$ 6,300,000$ 366,462.40$ 5,250,000$ 1,416,462.40$ 105.82%NC Sales Tax - Article 39 1103100 310233 6,005,569.03$ 5,600,000$ 405,569.03$ 4,666,667$ 1,338,902.36$ 107.24%NC Sales Tax - Article 40 (General Fund)1103100 310235 2,808,132.58$ 2,500,000$ 308,132.58$ 2,083,333$ 724,799.25$ 112.33%NC Sales Tax - Article 42 (General Fund)1103100 310237 4,025,866.72$ 4,000,000$ 25,866.72$ 3,333,333$ 692,533.39$ 100.65%NC Sales Tax - Article 44 & Article 44 *52419,506,030.73$ 18,400,000.00$ 1,106,030.73$ 15,333,333.33$ 4,172,697.40$ 106.01% 2118401 - 380892 1,826,044.27$ 1,598,664.00$ 227,380.27$ 1,332,220.00$ 493,824.27$ 114.22%NC Sales Tax Special Districts 3003100 310233 2,076,590.19$ 1,900,000$ 176,590.19$ 1,583,333$ 493,256.86$ 109.29%NC Sales Tax - Article 40 (Education)3003100 310235 4,153,180.41$ 3,900,000$ 253,180.41$ 3,250,000$ 903,180.41$ 106.49%NC Sales Tax - Article 42 (Education)3003100 310239 2,695,973.83$ 2,200,000$ 495,973.83$ 1,833,333$ 862,640.50$ 122.54%NC Sales Tax - Article 468,925,744.43$ 8,000,000.00$ 925,744.43$ 6,666,666.67$ 2,259,077.76$ 111.57% 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 29 of 29 06.2021 Monthly Master