No preview available
HomeMy WebLinkAboutSales Tax 2015 HARNETT COUNTY SALES TAX ANALYSIS BY ARTICLE City Hold School Hold 1. Current year activity : HarmlessHarmless General FundBoard of Education Special DistrictsTotal Distribution Fiscal Year 2014Article 39Article 40Article 42Article 40Article 42Article 44Article 46Article 39 Article 39 July, 2014$ 363,495.28 $ 389,722.99 $ 126,807.61 $ 132,884.02 $ 265,768.04 $ 101.44 $ 124,901.76 $ (81,143.53)$ (161,431.37)$ 74,701.19 $ 1,235,807.43 August, 2014$ 567,559.04 $ 401,150.19 $ 178,890.63 $ 135,077.76 $ 270,155.52 $ 294.29 $ 154,235.98 $ (75,988.12)$ (113,642.20)$ 112,278.46 $ 1,630,011.54 September, 2014$ 266,812.79 $ 380,160.40 $ 107,629.88 $ 127,350.15 $ 254,700.29 $ (10,483.34)$ 145,300.82 $ (80,760.07)$ (177,767.13)$ 56,896.19 $ 1,069,839.98 October, 2014$ 542,748.42 $ 398,154.70 $ 169,324.58 $ 135,958.58 $ 271,917.15 $ (152.30)$ 147,919.45 $ (77,216.40)$ (120,125.64)$ 106,943.77 $ 1,575,472.31 November, 2014$ 482,726.09 $ 388,071.74 $ 158,055.77 $ 130,416.21 $ 260,832.41 $ 215.12 $ 135,147.51 $ (75,591.57)$ (127,018.20)$ 96,835.07 $ 1,449,690.15 December, 2014$ 634,600.76 $ 469,942.78 $ 198,680.19 $ 160,350.45 $ 320,700.91 $ 139.73 $ 173,139.71 $ (91,265.90)$ (143,223.08)$ 125,238.59 $ 1,848,304.14 January, 2015$ 499,898.56 $ 363,436.85 $ 162,976.46 $ 119,773.42 $ 239,546.84 $ 205.76 $ 131,361.57 $ (67,802.16)$ (104,559.72)$ 100,080.30 $ 1,444,917.88 February, 2015$ 452,970.43 $ 352,409.41 $ 148,821.73 $ 117,036.40 $ 234,072.81 $ 280.41 $ 119,904.45 $ (67,338.63)$ (110,813.47)$ 90,961.50 $ 1,338,305.04 March, 2015$ 553,203.77 $ 370,283.27 $ 172,788.12 $ 124,106.49 $ 248,212.97 $ 19.66 $ 154,773.03 $ (68,812.73)$ (96,885.75)$ 109,036.72 $ 1,566,725.55 April, 2015$ 574,622.69 $ 393,928.92 $ 176,071.03 $ 134,579.95 $ 269,159.90 $ 217.98 $ 158,027.81 $ (75,162.89)$ (109,206.25)$ 112,537.12 $ 1,634,776.26 May, 2015$ 509,447.58 $ 426,137.57 $ 168,664.89 $ 143,271.71 $ 286,543.43 $ 19.00 $ 133,828.33 $ (82,936.92)$ (144,948.84)$ 102,684.64 $ 1,542,711.39 June, 2015$ 613,411.27 $ 454,782.79 $ 189,299.51 $ 156,591.74 $ 313,183.48 $ 94.53 $ 168,980.06 $ (88,425.60)$ (140,181.94)$ 120,564.23 $ 1,788,300.07 $ 6,061,496.68 $ 4,788,181.61 $ 1,958,010.40 $ 1,617,396.88 $ 3,234,793.75 $ (9,047.72)$ 1,747,520.48 $ (932,444.52)$ (1,549,803.59)$ 1,208,757.78 $ 18,124,861.75 City Hold School Hold 2. Comparison to prior year : 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 3. Reconciliation to general ledger : Activity Article 46 Over/(Under) Annualized Over/(Under) Annualized Budget Sales Tax Budget Balance to HTEActivityBudgetBudget(12 months) $ 334,169.68 110-0000-313.30-01$ 6,061,496.68 $ 5,727,327 $ 334,169.68 $ 5,727,327 Article 39 $ 530,119.61 110-0000-313.30-02$ 4,788,181.61 $ 4,258,062 $ 530,119.61 $ 4,258,062 Article 40 General FundReceived to Date$ 1,747,520.48 $ 155,338.88 110-0000-313.30-03$ 1,617,396.88 $ 1,462,058 $ 155,338.88 $ 1,462,058 Article 40 Education $ 148,831.40 110-0000-313.30-04$ 1,958,010.40 $ 1,809,179 $ 148,831.40 $ 1,809,179 Article 42 General FundInterest Earned $ 64.68 $ 310,675.75 110-0000-313.30-05$ 3,234,793.75 $ 2,924,118 $ 310,675.75 $ 2,924,118 Article 42 Education $ (9,047.72) 110-0000-313.30-06$ (9,047.72)$ -$ (9,047.72)$ -Article 44$ 1,747,585.16 $ (107,444.52) 110-0000-313.30-07$ (932,444.52)$ (825,000)$ (107,444.52)$ (825,000)Article 39 City Hold Harmless $ (299,803.59) 110-0000-313.30-08$ (1,549,803.59)$ (1,250,000)$ (299,803.59)$ (1,250,000)Article 39 School Hold Harmless $ 1,062,839.49 $ 15,168,583.49 $ 14,105,744 $ 1,062,839.49 $ 14,105,744 Encumbered for $ 1,540,000.00 Various Projects $ 179,105.66 242-0000-313.30-00$ 1,180,188.66 $ 1,001,083 $ 179,105.66 $ 1,001,083 Special Districts Available for $ 207,585.16 $ (752,479.52) 225-0000-313.30-10$ 1,747,520.48 $ 2,500,000 $ (752,479.52)$ 2,500,000 Article 46 Sales Tax Appropriation U:\\My Documents\\Monthly Reports\\2014 - 2015\\Sales Tax\\Sales Tax 2015.xlsx