Loading...
HomeMy WebLinkAboutApril 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 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ June, 2017 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 5,979,975.46$ 4,420,061.53$ 1,856,909.34$ 1,537,054.87$ 3,074,109.74$ 3,743.47$ 3,209,688.86$ 1,695,261.29$ (885,778.20)$ (1,383,692.26)$ 1,118,900.01$ 20,626,234.12$ Year over Year Change 4.62% 4.51% 3.25% 6.81% 6.81% 195.67% 0.00% 8.88% 9.28% 7.34% 3.39% 39.42% 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,715,817.49$ 4,229,424.91$ 1,798,545.98$ 1,439,008.64$ 2,878,017.28$ 1,266.11$ -$ 1,556,958.39$ (810,555.63)$ (1,289,086.35)$ 1,082,201.78$ 14,793,850.28$ 110-0000-313.30-01 5,979,975.46$ 7,215,261$ (1,235,285.54)$ 6,012,718$ (32,742.04)$ Article 39 110-0000-313.30-02 4,420,061.53$ 5,534,591$ (1,114,529.47)$ 4,612,159$ (192,097.64)$ Article 40 General Fund Received Prior FY 321,026.87$ 2,172,201.00$ 110-0000-313.30-03 1,537,054.87$ 1,877,718$ (340,663.13)$ 1,564,765$ (27,710.13)$ Article 40 Education Received to Date this FY 3,209,688.86 1,695,261.29 110-0000-313.30-04 1,856,909.34$ 2,300,802$ (443,892.66)$ 1,917,335$ (60,425.66)$ Article 42 General Fund Interest Earned - 3,992.10 110-0000-313.30-05 3,074,109.74$ 3,755,435$ (681,325.26)$ 3,129,529$ (55,419.42)$ Article 42 Education110-0000-313.30-06 3,743.47$ -$ 3,743.47$ -$ 3,743.47$ Article 44 3,530,715.73$ 3,871,454.39$ 110-0000-313.30-07 (885,778.20)$ (925,285)$ 39,506.80$ (771,071)$ (114,707.37)$ Article 39 City Hold Harmless 110-0000-313.30-08 (1,383,692.26)$ (1,250,000)$ (133,692.26)$ (1,041,667)$ (342,025.59)$ Article 39 School Hold Harmless 14,602,383.96$ 18,508,522$ (3,906,138.04)$ 15,423,768$ (821,384.38)$ 242-0000-313.30-00 1,118,900.01$ 1,223,650$ (104,749.99)$ 1,019,708$ 99,191.68$ Special Districts 226-0000-313.30-10 3,209,688.86$ 4,000,349$ (790,660.14)$ 3,333,624$ (123,935.31)$ Article 44 *524 Sales Tax 225-0000-313.30-10 1,695,261.29$ -$ 1,695,261.29$ -$ 1,695,261.29$ Article 46 Sales Tax General Fund Board of Education Activity Over/(Under) Annualized Budget Annualized Budget (10 months) Over/(Under) BudgetBudget HARNETT COUNTY SALES TAX ANALYSIS BY ARTICLE 3. Reconciliation to general ledger : ActivityBalance to HTE Article 46 Sales Tax (279,511.27)$ 2,331,454.39$ 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