Loading...
HomeMy WebLinkAboutSales 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