Loading...
HomeMy WebLinkAboutSales Tax 2013HARNETT COUNTY SALES TAX ANALYSIS BY ARTICLE Current year activity Fiscal Year 2013 Article 39 General Fund Article 40 Article 42 Board of Education Article 40 Article 42 Article 44 City Hold Harmless Article 39 School Hold Harmless Article 39 Special Districts Total Distribution y, 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 gust, 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 ptember, 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 tober, 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 vember, 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 cember, 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 wary, 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 :)ruary,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 rch, 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 ril, 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 y,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 ie, 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 $ (71,812.96) $ 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 1 $ 14,428,460.87 2. Comparison to prior year City Hold School Hold General Fund Board of Education Harmless Harmless Fiscal Year 2011 Article 39 Article 40 Article 42 Article 40 Article 42 Article 44 Article 39 Article 39 Special Districts Total Distributior July, 2011 $ 431,704.60 $ 318,671.46 $ 132,855.25 $ 111,181.32 $ 222,362.64 $ 973.92 $ (67,313.45) $ (101,976.60) $ 79,417.35 $ 1,127,876.49 August, 2011 $ 360,954.46 $ 319,778.82 $ 120,469.75 $ 109,724.67 $ 219,449.36 $ (403.35) $ (69,051.97) $ (119,581.67) $ 68,003.31 $ 1,009,343.38 September, 2011 $ 326,062.51 $ 312,314.74 $ 111,125.03 $ 107,198.54 $ 214,397.07 $ 519.51 $ (68,565.32) $ (123,923.04) $ 61,934.42 $ 941,063.46 October, 2011 $ 390,232.01 $ 283,156.20 $ 128,125.89 $ 93,56146 $ 187,126.98 $ (3,034.03) $ (56,465.45) $ (83,817.01) $ 73,116.82 $ 1,012,004.87 November, 2011 $ 506,500.05 $ 313,682.72 $ 147,946.07 $ 109,849.57 $ 219,699.15 $ 504.18 $ (63,670.06) $ (79,140.48) $ 91,737.63 $ 1,247,108.83 December, 2011 $ 532,225.64 $ 386,769.44 $ 162,079.78 $ 135,469.23 $ 270,938.45 $ 677.16 $ (81,893.56) $ (121,622.05) $ 97,560.11 $ 1,382,204.20 January, 2012 $ 449,612.25 $ 280,937.06 $ 137,739.51 $ 94,700.62 $ 189,401.26 $ (19,151.28) $ (54,895.90) $ (68,601.75) $ 80,608.77 $ 1,090,350.54 February, 2012 $ 454,634.33 $ 320,641.28 $ 138,408.55 $ 111,52922 $ 223,058.47 $ 140.13 $ (66,921.12) $ (96,874.44) $ 83,318.05 $ 1,167,934.47 March, 2012 $ 519,342.75 $ 340,976.57 $ 156,774.70 $ 117,850.77 $ 235,701.53 $ 52.06 $ (69,389.66) $ (92,471.36) $ 95,010.52 $ 1,303,847.88 April, 2012 $ 387,956.95 $ 292,350.55 $ 123,511.49 $ 99,883.82 $ 199,767.66 $ 313.54 $ (60,872.42) $ (93,427.41) $ 72,187.59 $ 1,021,671.77 May, 2012 $ 485,165.06 $ 342,218.37 $ 147,266.12 $ 119,796.44 $ 239,592.87 $ 63.36 $ (71,812.96) $ (103,083.50) $ 88,84832 $ 1,248,054.48 June, 2012 $ 456;57038 $ 371,912.79 $ 144,372.74 $ 130,981.47 $ 261,962.94 $ 15.01 $ (80,504.05) $ (132,368.72) $ 82,852.16 $ 1,235,794.72 July - June $ 5,300,960.99 $ 3,883,410.00 $ 1,650,674.88 $ 1,341,729.13 $ 2,683,458.38 $ (19,329.79) $ (811,355.92) $ (1,216,888.03) $ 974,595.45 $ 13,787,255.09 3. Reconciliation to general ledger Annualized Budget Activity Over /(Under) Balance to HTE Activity Budget Over/(Under) Budget (12 months) Annualized Budget 110- 0000 - 313.30 -01 $ 5,454,597.48 $ 5,287,512 $ 167,085.48 $ 5,287,512 $ 167,085.48 Article 39 110- 0000 - 313.30 -02 $ 4,055,297.28 $ 4,070,203 $ (14,905.72) $ 4,070,203 $ (14,905.72) Article 40 General Fund 110 - 0000 - 313.30 -03 $ 1,392,436.97 $ 1,401,513 $ (9,076.03) $ 1,401,513 $ (9,076.03) Article 40 Education 110- 0000 - 313.30 -04 $ 1,723,028.46 $ 1,731,393 $ (8,364.54) $ 1,731,393 $ (8,364.54) Article 42 General Fund 110 - 0000 - 31330 -05 $ 2,784,874.01 $ 2,803,026 $ (18,151.99) $ 2,803,026 $ (18,151:99) Article 42 Education 110 - 0000 - 313.30 -06 $ 59,182.68 $ (10,000) $ 69,182.68 $ (10,000) $ 69,182.68 Article 44 110- 0000 - 313.30 -07 $ (834,879.22) $ (848,687) $ 13,807.78 $ (848,687) $ 13,807.78 Article 39 City Hold Harmless 110 - 0000 - 313.30 -08 $ (1,265,32834) $ (1,276,837) $ 11,508.66 $ (1,276,837) $ 11,508.66 Article 39 School Hold Harmless $ 13,369,209.32 $ 13,158,123 $ 211,086.32 $ 13,158,123 $ 211,086.32 S: \Kimberly \Sales Tax \Sales Tax 2013