Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Sales Tax 2014
HARNETT COUNTY SALES TAX ANALYSIS BY ARTICLE 1. Current year activity : City Hold School Hold HarmlessHarmless General FundBoard of Education Special DistrictsTotal Distribution Fiscal Year 2014Article 39Article 40Article 42Article 40Article 42Article 44Article 46Article 39 Article 39 July, 2013$ 486,897.40$ 347,861.76$ 143,052.61$ 134,407.06$ 268,814.11 $ 27.13$ -$ (69,616.26) $ (121,961.48)$ 87,992.81$ 1,277,475.14 August, 2013$ 382,993.11$ 352,405.55$ 131,806.24$ 119,434.34$ 238,868.68 $ 51.73$ -$ (70,557.49) $ (132,240.64)$ 74,361.48$ 1,097,123.00 September, 2013$ 223,114.15$ 355,432.70$ 94,382.89$ 121,102.95$ 242,205.97 $ 1,991.94$ -$ (77,060.51) $ (177,747.61)$ 47,016.15$ 830,438.63 October, 2013$ 473,430.52$ 302,275.04$ 146,647.37$ 101,828.29$ 203,656.58 $ 127.86$ -$ (55,256.87) $ (74,830.79)$ 88,679.00$ 1,186,557.00 November, 2013$ 502,615.34$ 365,659.46$ 158,191.81$ 125,165.70$ 203,656.58 $ 1,331.43$ -$ (70,366.37) $ (68,898.98)$ 99,438.27$ 1,316,793.24 December, 2013$ 452,714.56$ 407,090.92$ 148,521.60$ 141,275.61$ 282,551.22 $ 44.50$ -$ (83,071.53) $ (153,653.37)$ 86,358.17$ 1,281,831.68 January, 2014$ 438,216.40$ 306,126.94$ 143,081.13$ 99,699.78$ 199,399.57 $ (50.43)$ -$ (56,130.01) $ (83,225.00)$ 83,713.91$ 1,130,832.29 February, 2014$ 470,535.60$ 338,202.84$ 149,338.09$ 113,335.47$ 226,670.94 $ 336.39$ -$ (64,338.22) $ (98,599.17)$ 89,024.96$ 1,224,506.90 March, 2014$ 554,961.68$ 370,950.17$ 174,023.54$ 123,733.56$ 247,467.12 $ 44.18$ 210.02$ (68,914.74) $ (97,136.56)$ 104,519.79$ 1,409,858.76 April, 2014$ 516,193.27$ 346,268.44$ 161,077.30$ 116,059.72$ 232,119.44 $ 127.98$ 135,374.95$ (64,718.92) $ (91,654.00)$ 97,062.51$ 1,447,910.69 May, 2014$ 430,901.19$ 397,448.51$ 144,284.67$ 134,915.35$ 269,830.70 $ 1.13$ 144,305.53$ (80,392.52) $ (149,322.38)$ 83,143.37$ 1,375,115.55 June, 2014$ 536,523.23$ 437,619.92$ 171,212.92$ 149,797.49$ 299,594.98 $ 3,502.33$ 144,790.81$ (87,152.50) $ (149,162.50)$ 102,126.52$ 1,608,853.20 $ 5,469,096.45$ 4,327,342.25$ 1,765,620.17$ 1,480,755.32$ 2,914,835.89 $ 7,536.17$ 424,681.31$ (847,575.94) $ (1,398,432.48)$ 1,043,436.94$ 15,187,296.08 2. Comparison to prior year : City Hold School Hold HarmlessHarmless General FundBoard of Education Special DistrictsTotal Distribution Fiscal Year 2013Article 39Article 40Article 42Article 40Article 42Article 44Article 46Article 39 Article 39 July, 2012$ 443,303.54$ 336,358.14$ 140,623.23$ 115,657.66$ 231,315.32 $ 63.04$ -$ (70,547.08) $ (107,836.69)$ 85,502.04$ 1,174,439.20 August, 2012$ 360,670.60$ 335,215.84$ 119,887.54$ 116,462.04$ 232,924.07 $ 148.37$ -$ (73,967.15) $ (129,950.66)$ 70,525.85$ 1,031,916.50 September, 2012$ 447,151.51$ 317,495.15$ 143,198.49$ 106,884.05$ 213,768.09 $ (161.81)$ -$ (64,086.07) $ (91,934.19)$ 86,619.78$ 1,158,935.00 October, 2012$ 374,507.06$ 304,980.66$ 121,813.42$ 104,607.06$ 209,214.12 $ 54,236.62$ -$ (64,766.95) $ (104,721.02)$ 79,058.72$ 1,078,929.69 November, 2012$ 474,634.06$ 338,148.02$ 146,493.87$ 117,202.43$ 234,404.86 $ 153.91$ -$ (70,395.67) $ (101,431.79)$ 90,761.35$ 1,229,971.04 December, 2012$ 436,015.24$ 357,265.49$ 143,996.55$ 121,552.72$ 243,105.41 $ 95.97$ -$ (75,355.43) $ (122,188.78)$ 85,256.07$ 1,189,743.24 January, 2013$ 450,748.60$ 289,762.17$ 140,259.29$ 97,565.71$ 195,131.45 $ (15.61)$ -$ (56,940.85) $ (72,672.13)$ 86,559.69$ 1,130,398.32 February, 2013$ 505,783.90$ 337,336.14$ 152,775.94$ 117,439.88$ 234,879.78 $ 4,197.43$ -$ (69,369.31) $ (92,869.85)$ 96,552.27$ 1,286,726.18 March, 2013$ 528,859.18$ 352,548.53$ 163,785.86$ 120,329.76$ 240,659.53 $ (13.54)$ -$ (70,997.95) $ (94,757.77)$ 101,342.66$ 1,341,756.26 April, 2013$ 392,426.19$ 335,332.20$ 126,767.34$ 116,717.56$ 233,435.17 $ 245.14$ -$ (72,969.96) $ (121,756.89)$ 76,061.85$ 1,086,258.60 May, 2013$ 518,670.58$ 360,594.61$ 157,770.58$ 124,668.09$ 249,336.18 $ 159.82$ -$ (69,662.93) $ (104,566.83)$ 99,446.02$ 1,336,416.12 June, 2013$ 521,827.02$ 390,260.33$ 165,656.35$ 133,350.01$ 266,700.03 $ 73.34$ -$ (75,819.87) $ (120,641.74)$ 101,565.25$ 1,382,970.72 July - June$ 5,454,597.48$ 4,055,297.28$ 1,723,028.46$ 1,392,436.97$ 2,784,874.01 $ 59,182.68$ -$ (834,879.22) $ (1,265,328.34)$ 1,059,251.55$ 14,428,460.87 3. Reconciliation to general ledger : Activity Over/(Under) Annualized Budget Annualized Budget Over/(Under) Budget(12 months) Balance to HTEActivityBudget $ 125,357.45 110-0000-313.30-01$ 5,469,096.45 $ 5,343,739$ 125,357.45 $ 5,343,739Article 39 $ 324,203.25 110-0000-313.30-02$ 4,327,342.25 $ 4,003,139$ 324,203.25 $ 4,003,139Article 40 General Fund $ 107,845.32 110-0000-313.30-03$ 1,480,755.32 $ 1,372,910$ 107,845.32 $ 1,372,910Article 40 Education $ 68,861.17 110-0000-313.30-04$ 1,765,620.17 $ 1,696,759$ 68,861.17 $ 1,696,759Article 42 General Fund $ 169,015.89 110-0000-313.30-05$ 2,914,835.89 $ 2,745,820$ 169,015.89 $ 2,745,820Article 42 Education $ 7,536.17 110-0000-313.30-06$ 7,536.17 $ -$ 7,536.17 $ - Article 44 $ (9,020.94) 110-0000-313.30-07$ (847,575.94) $ (838,555)$ (9,020.94) $ (838,555) Article 39 City Hold Harmless $ (132,202.48) 110-0000-313.30-08$ (1,398,432.48) $ (1,266,230)$ (132,202.48) $ (1,266,230) Article 39 School Hold Harmless $ 661,595.83 $ 13,719,177.83 $ 13,057,582$ 661,595.83 $ 13,057,582 S:\\Kimberly\\Sales Tax\\Sales Tax 2014.xls