Loading...
HomeMy WebLinkAboutMay 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 688,501.18$ 459,575.02$ 208,857.75$ 159,536.52$ 319,073.05$ 3,266.05$ 320,930.23$ 186,060.41$ (89,510.33)$ (125,665.59)$ 128,229.31$ 2,258,853.60$ May, 2017 627,008.12$ 427,075.22$ 185,527.75$ 151,333.57$ 302,667.13$ 30.26$ 320,322.29$ 181,863.08$ (86,984.59)$ (123,507.66)$ 115,252.77$ 2,100,587.94$ June, 2017 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 6,606,983.58$ 4,847,136.75$ 2,042,437.09$ 1,688,388.44$ 3,376,776.88$ 3,773.73$ 3,530,011.15$ 1,877,124.37$ (972,762.79)$ (1,507,199.92)$ 1,234,152.78$ 22,726,822.06$ Year over Year Change 4.35% 3.72% 2.73% 6.10% 6.10% 162.88% 0.00% 8.71% 8.55% 6.01% 3.03% 39.12% 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$ 6,331,780.63$ 4,673,097.68$ 1,988,205.88$ 1,591,355.08$ 3,182,710.16$ 1,435.54$ -$ 1,726,669.54$ (896,169.33)$ (1,421,784.56)$ 1,197,895.72$ 16,336,561.68$ 110-0000-313.30-01 6,606,983.58$ 7,215,261$ (608,277.42)$ 6,613,989$ (7,005.67)$ Article 39 110-0000-313.30-02 4,847,136.75$ 5,534,591$ (687,454.25)$ 5,073,375$ (226,238.33)$ Article 40 General Fund Received Prior FY 321,026.87$ 2,172,201.00$ 110-0000-313.30-03 1,688,388.44$ 1,877,718$ (189,329.56)$ 1,721,242$ (32,853.06)$ Article 40 Education Received to Date this FY 3,530,011.15 1,877,124.37 110-0000-313.30-04 2,042,437.09$ 2,300,802$ (258,364.91)$ 2,109,069$ (66,631.41)$ Article 42 General Fund Interest Earned - 3,992.10 110-0000-313.30-05 3,376,776.88$ 3,755,435$ (378,658.12)$ 3,442,482$ (65,705.20)$ Article 42 Education110-0000-313.30-06 3,773.73$ -$ 3,773.73$ -$ 3,773.73$ Article 44 3,851,038.02$ 4,053,317.47$ 110-0000-313.30-07 (972,762.79)$ (925,285)$ (47,477.79)$ (848,178)$ (124,584.87)$ Article 39 City Hold Harmless 110-0000-313.30-08 (1,507,199.92)$ (1,250,000)$ (257,199.92)$ (1,145,833)$ (361,366.59)$ Article 39 School Hold Harmless 16,085,533.76$ 18,508,522$ (2,422,988.24)$ 16,966,145$ (880,611.41)$ 242-0000-313.30-00 1,234,152.78$ 1,223,650$ 10,502.78$ 1,121,679$ 112,473.61$ Special Districts 226-0000-313.30-10 3,530,011.15$ 4,000,349$ (470,337.85)$ 3,666,987$ (136,975.43)$ Article 44 *524 Sales Tax 225-0000-313.30-10 1,877,124.37$ -$ 1,877,124.37$ -$ 1,877,124.37$ Article 46 Sales Tax General Fund Board of Education Activity Over/(Under) Annualized Budget Annualized Budget (11 months) Over/(Under) BudgetBudget HARNETT COUNTY SALES TAX ANALYSIS BY ARTICLE 3. Reconciliation to general ledger : ActivityBalance to HTE Article 46 Sales Tax 40,811.02$ 2,513,317.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