Loading...
January 2017 Sales Tax1. Current year activity :City Hold Harmless School Hold Harmless Fiscal Year 2017 Article 39 Article 40 Article 42 Article 40 Article 42 Article 44 Article 44 *524 Article 46 Article 39 Article 39 Special Districts Total Distribution July, 2016 342,547.33$ 419,514.05$ 128,001.89$ 144,266.60$ 288,533.20$ 135.45$ 321,026.87$ 84,912.72$ (91,102.93)$ (189,556.62)$ 68,261.28$ 1,516,539.84$ August, 2016 499,004.02$ 449,495.13$ 161,297.39$ 157,725.20$ 315,450.39$ 222.44$ 321,026.87$ 138,244.67$ (94,619.99)$ (171,491.32)$ 94,507.77$ 1,870,862.57$ September, 2016 631,866.15$ 430,585.46$ 191,506.70$ 149,848.85$ 299,697.69$ -$ 321,026.87$ 180,968.20$ (84,719.28)$ (122,236.57)$ 117,252.06$ 2,115,796.13$ October, 2016 575,714.83$ 425,516.34$ 180,885.75$ 146,960.71$ 293,921.43$ 1.00$ 321,026.87$ 167,429.35$ (84,799.65)$ (131,785.11)$ 108,128.48$ 2,003,000.00$ November, 2016 629,952.15$ 453,962.93$ 191,407.10$ 159,532.55$ 319,065.11$ 60.38$ 320,930.23$ 179,625.92$ (91,306.16)$ (139,541.42)$ 116,975.74$ 2,140,664.53$ December, 2016 725,691.08$ 518,816.07$ 218,610.94$ 183,173.38$ 366,346.75$ 0.25$ 320,930.23$ 206,817.61$ (104,224.69)$ (158,745.37)$ 134,402.58$ 2,411,818.83$ January, 2017 511,567.30$ 374,618.22$ 163,977.91$ 127,099.22$ 254,198.45$ 5.17$ 320,930.23$ 162,127.90$ (73,528.68)$ (112,886.21)$ 96,730.35$ 1,824,839.86$ February, 2017 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ March, 2017 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ April, 2017 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ May, 2017 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ June, 2017 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 3,916,342.86$ 3,072,508.20$ 1,235,687.68$ 1,068,606.51$ 2,137,213.02$ 424.69$ 2,246,898.17$ 1,120,126.37$ (624,301.38)$ (1,026,242.62)$ 736,258.26$ 13,883,521.77$ Year over Year Change 2.26% 4.59% 1.18% 7.22% 7.22% 4.22% 0.00% 7.97% 10.29% 10.36% 1.06% 35.40% 2. Comparison to prior year :City Hold Harmless School Hold Harmless Fiscal Year 2016 Article 39 Article 40 Article 42 Article 40 Article 42 Article 44 Article 44 *524 Article 46 Article 39 Article 39 Special Districts Total Distribution July, 2015 578,603.16$ 436,808.62$ 177,618.90$ 151,567.19$ 303,134.38$ 8.20$ -$ 159,278.48$ (85,821.77)$ (139,379.84)$ 108,590.02$ 1,235,807.43$ August, 2015 360,595.60$ 410,372.75$ 135,077.55$ 136,564.05$ 273,128.10$ 50.07$ -$ 89,591.66$ (83,337.80)$ (172,939.96)$ 72,908.65$ 1,630,011.54$ September, 2015 577,428.49$ 417,424.58$ 178,624.89$ 143,166.51$ 286,333.02$ 124.89$ -$ 159,625.27$ (80,202.92)$ (124,823.23)$ 108,672.94$ 1,069,839.98$ October, 2015 575,996.92$ 392,635.32$ 180,693.73$ 131,686.36$ 263,372.72$ 48.57$ -$ 157,616.35$ (72,709.85)$ (105,785.92)$ 108,931.26$ 1,575,472.31$ November, 2015 557,422.21$ 413,889.89$ 175,088.22$ 140,958.83$ 281,917.66$ 46.49$ -$ 151,422.13$ (79,452.08)$ (127,076.34)$ 105,457.51$ 1,449,690.15$ December, 2015 653,599.14$ 501,682.04$ 202,904.05$ 173,428.43$ 346,856.86$ 97.62$ -$ 179,859.17$ (98,529.18)$ (161,982.73)$ 123,168.37$ 1,848,304.14$ January, 2016 526,105.03$ 364,863.82$ 171,223.66$ 119,292.81$ 238,585.62$ 31.66$ -$ 140,068.73$ (66,014.07)$ (97,954.60)$ 100,783.00$ 1,444,917.88$ February, 2016 574,221.44$ 381,648.27$ 181,476.89$ 126,603.88$ 253,207.76$ 222.35$ -$ 155,488.36$ (69,301.79)$ (97,906.62)$ 108,873.10$ 1,338,305.04$ March, 2016 678,048.85$ 455,920.69$ 201,080.82$ 159,534.87$ 319,069.74$ 513.88$ -$ 188,242.83$ (87,852.66)$ (126,323.56)$ 125,818.15$ 1,566,725.55$ April, 2016 633,796.65$ 454,178.93$ 194,757.27$ 156,205.71$ 312,411.42$ 122.38$ -$ 175,765.41$ (87,333.51)$ (134,913.55)$ 118,998.78$ 1,634,776.26$ May, 2016 615,963.14$ 443,672.77$ 189,659.90$ 152,346.44$ 304,692.88$ 169.43$ -$ 169,711.15$ (85,613.70)$ (132,698.21)$ 115,693.94$ 1,542,711.39$ June, 2016 661,520.97$ 479,606.63$ 199,540.37$ 167,413.04$ 334,826.08$ -$ 321,026.87$ 189,759.93$ (97,191.21)$ (146,878.68)$ 123,036.75$ 1,788,300.07$ 3,829,750.55$ 2,937,677.02$ 1,221,231.00$ 996,664.18$ 1,993,328.36$ 407.50$ -$ 1,037,461.79$ (566,067.67)$ (929,942.62)$ 728,511.75$ 10,254,043.44$ 110-0000-313.30-01 3,916,342.86$ 7,215,261$ (3,298,918.14)$ 4,208,902$ (292,559.39)$ Article 39 110-0000-313.30-02 3,072,508.20$ 5,534,591$ (2,462,082.80)$ 3,228,511$ (156,003.22)$ Article 40 General Fund Received Prior FY 321,026.87$ 2,172,201.00$ 110-0000-313.30-03 1,068,606.51$ 1,877,718$ (809,111.49)$ 1,095,336$ (26,728.99)$ Article 40 Education Received to Date this FY 2,246,898.17 1,120,126.37 110-0000-313.30-04 1,235,687.68$ 2,300,802$ (1,065,114.32)$ 1,342,135$ (106,446.82)$ Article 42 General Fund Interest Earned - 3,992.10 110-0000-313.30-05 2,137,213.02$ 3,755,435$ (1,618,221.98)$ 2,190,670$ (53,457.39)$ Article 42 Education110-0000-313.30-06 424.69$ -$ 424.69$ -$ 424.69$ Article 44 2,567,925.04$ 3,296,319.47$ 110-0000-313.30-07 (624,301.38)$ (925,285)$ 300,983.62$ (539,750)$ (84,551.80)$ Article 39 City Hold Harmless 110-0000-313.30-08 (1,026,242.62)$ (1,250,000)$ 223,757.38$ (729,167)$ (297,075.95)$ Article 39 School Hold Harmless 9,780,238.97$ 18,508,522$ (8,728,283.03)$ 10,796,638$ (1,016,398.87)$ 242-0000-313.30-00 736,258.26$ 1,223,650$ (487,391.74)$ 713,796$ 22,462.43$ Special Districts 226-0000-313.30-10 2,246,898.17$ 4,000,349$ (1,753,450.83)$ 2,333,537$ (86,638.75)$ Article 44 *524 Sales Tax 225-0000-313.30-10 1,120,126.37$ -$ 1,120,126.37$ -$ 1,120,126.37$ Article 46 Sales Tax General Fund Board of Education Activity Over/(Under) Annualized Budget Annualized Budget (7 months) Over/(Under) BudgetBudget HARNETT COUNTY SALES TAX ANALYSIS BY ARTICLE 3. Reconciliation to general ledger : ActivityBalance to HTE Article 46 Sales Tax (1,242,301.96)$ 1,756,319.47$ General Fund Board of Education 3,810,227.00$ 1,540,000.00$ Appropriated Available for Appropriation Article 44 *524 Sales Tax U:\My Documents\Monthly Reports\2016 - 2017\Sales Tax\Sales Tax 2017