Loading...
HomeMy WebLinkAboutMarch 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 631,392.75$ 400,093.30$ 189,344.20$ 138,591.38$ 277,182.76$ 52.73$ 320,930.23$ 175,711.78$ (77,011.03)$ (100,904.06)$ 116,800.24$ 2,072,184.28$ March, 2017 743,738.67$ 487,885.01$ 223,019.71$ 170,320.46$ 340,640.91$ -$ 320,930.23$ 213,362.73$ (94,955.46)$ (130,879.99)$ 137,612.20$ 2,411,674.47$ April, 2017 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ May, 2017 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ June, 2017 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 5,291,474.28$ 3,960,486.51$ 1,648,051.59$ 1,377,518.35$ 2,755,036.70$ 477.42$ 2,888,758.63$ 1,509,200.88$ (796,267.87)$ (1,258,026.67)$ 990,670.70$ 18,367,380.52$ Year over Year Change 4.12% 4.91% 2.76% 7.38% 7.38% -58.26% 0.00% 9.27% 10.10% 9.00% 2.85% 39.58% 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$ 5,082,020.84$ 3,775,245.98$ 1,603,788.71$ 1,282,802.93$ 2,565,605.86$ 1,143.73$ -$ 1,381,192.98$ (723,222.12)$ (1,154,172.80)$ 963,203.00$ 13,159,074.02$ 110-0000-313.30-01 5,291,474.28$ 7,215,261$ (1,923,786.72)$ 5,411,446$ (119,971.47)$ Article 39 110-0000-313.30-02 3,960,486.51$ 5,534,591$ (1,574,104.49)$ 4,150,943$ (190,456.74)$ Article 40 General Fund Received Prior FY 321,026.87$ 2,172,201.00$ 110-0000-313.30-03 1,377,518.35$ 1,877,718$ (500,199.65)$ 1,408,289$ (30,770.15)$ Article 40 Education Received to Date this FY 2,888,758.63 1,509,200.88 110-0000-313.30-04 1,648,051.59$ 2,300,802$ (652,750.41)$ 1,725,602$ (77,549.91)$ Article 42 General Fund Interest Earned - 3,992.10 110-0000-313.30-05 2,755,036.70$ 3,755,435$ (1,000,398.30)$ 2,816,576$ (61,539.55)$ Article 42 Education110-0000-313.30-06 477.42$ -$ 477.42$ -$ 477.42$ Article 44 3,209,785.50$ 3,685,393.98$ 110-0000-313.30-07 (796,267.87)$ (925,285)$ 129,017.13$ (693,964)$ (102,304.12)$ Article 39 City Hold Harmless 110-0000-313.30-08 (1,258,026.67)$ (1,250,000)$ (8,026.67)$ (937,500)$ (320,526.67)$ Article 39 School Hold Harmless 12,978,750.31$ 18,508,522$ (5,529,771.69)$ 13,881,392$ (902,641.19)$ 242-0000-313.30-00 990,670.70$ 1,223,650$ (232,979.30)$ 917,738$ 72,933.20$ Special Districts 226-0000-313.30-10 2,888,758.63$ 4,000,349$ (1,111,590.37)$ 3,000,262$ (111,503.12)$ Article 44 *524 Sales Tax 225-0000-313.30-10 1,509,200.88$ -$ 1,509,200.88$ -$ 1,509,200.88$ Article 46 Sales Tax General Fund Board of Education Activity Over/(Under) Annualized Budget Annualized Budget (9 months) Over/(Under) BudgetBudget HARNETT COUNTY SALES TAX ANALYSIS BY ARTICLE 3. Reconciliation to general ledger : ActivityBalance to HTE Article 46 Sales Tax (600,441.50)$ 2,145,393.98$ 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