Loading...
HomeMy WebLinkAboutMarch 2018 Sales Tax1. Current year activity :City Hold Harmless School Hold Harmless Fiscal Year 2018 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, 2017 527,233.64$ 464,751.25$ 172,971.15$ 161,069.44$ 322,138.89$ 4,014.56$ 343,826.29$ 143,817.13$ (97,992.88)$ (172,089.32)$ 100,187.30$ 1,969,927.45$ August, 2017 668,435.36$ 455,300.15$ 200,189.49$ 160,239.15$ 320,478.31$ 78.72$ 343,826.29$ 193,110.34$ (91,957.00)$ (130,593.88)$ 122,764.51$ 2,241,871.44$ September, 2017 706,943.32$ 470,386.89$ 216,833.87$ 161,756.20$ 323,512.39$ (7.49)$ 343,826.29$ 202,059.77$ (92,295.63)$ (126,571.95)$ 130,994.08$ 2,337,437.74$ October, 2017 550,198.87$ 429,190.63$ 171,897.50$ 149,949.88$ 299,899.76$ 62.38$ 343,826.29$ 155,210.75$ (89,216.97)$ (143,401.50)$ 102,398.89$ 1,970,016.48$ November, 2017 682,166.26$ 484,141.44$ 204,688.51$ 171,109.50$ 342,219.01$ 39.06$ 343,895.31$ 194,372.15$ (99,207.99)$ (147,059.80)$ 125,363.13$ 2,301,726.58$ December, 2017 785,025.54$ 535,130.74$ 240,180.05$ 185,374.17$ 370,748.35$ 85.37$ 343,895.31$ 223,750.26$ (106,037.55)$ (150,180.86)$ 145,362.47$ 2,573,333.85$ January, 2018 562,055.74$ 405,005.06$ 177,487.70$ 138,360.50$ 276,721.01$ 115.31$ 343,895.31$ 157,847.31$ (81,018.64)$ (120,729.34)$ 105,094.51$ 1,964,834.47$ February, 2018 613,547.14$ 392,245.87$ 183,948.34$ 135,939.95$ 271,879.90$ 36.25$ 343,895.31$ 177,656.96$ (77,246.57)$ (100,760.08)$ 112,768.88$ 2,053,911.95$ March, 2018 755,185.41$ 502,398.96$ 227,363.05$ 175,273.58$ 350,547.15$ 79.05$ 343,895.31$ 216,791.63$ (99,829.08)$ (137,494.05)$ 139,065.07$ 2,473,276.08$ April, 2018 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ May, 2018 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ June, 2018 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 5,850,791.28$ 4,138,550.99$ 1,795,559.66$ 1,439,072.38$ 2,878,144.77$ 4,503.21$ 3,094,781.71$ 1,664,616.30$ (834,802.31)$ (1,228,880.78)$ 1,083,998.84$ 19,886,336.05$ Year over Year Change 10.57% 4.50% 8.95% 4.47% 4.47% 843.24% 7.13% 10.30% 4.84% -2.32% 9.42% 8.27% 2. Comparison to prior year :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 625,443.09$ 489,768.32$ 192,911.17$ 172,825.49$ 345,650.98$ 27.96$ 343,826.29$ 177,089.83$ (102,407.54)$ (165,649.67)$ 116,478.30$ 2,195,964.23$ 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$ 110-0000-313.30-01 5,850,791.28$ 7,576,024$ (1,725,232.72)$ 5,682,018$ 168,773.28$ Article 39 110-0000-313.30-02 4,138,550.99$ 5,811,321$ (1,672,770.01)$ 4,358,491$ (219,939.76)$ Article 40 General Fund 110-0000-313.30-03 1,439,072.38$ 1,971,604$ (532,531.62)$ 1,478,703$ (39,630.62)$ Article 40 Education 110-0000-313.30-04 1,795,559.66$ 2,415,842$ (620,282.34)$ 1,811,882$ (16,321.84)$ Article 42 General Fund 110-0000-313.30-05 2,878,144.77$ 3,943,207$ (1,065,062.23)$ 2,957,405$ (79,260.48)$ Article 42 Education 110-0000-313.30-06 4,503.21$ -$ 4,503.21$ -$ 4,503.21$ Article 44 110-0000-313.30-07 (834,802.31)$ (812,748)$ (22,054.31)$ (609,561)$ (225,241.31)$ Article 39 City Hold Harmless 110-0000-313.30-08 (1,228,880.78)$ (1,250,000)$ 21,119.22$ (937,500)$ (291,380.78)$ Article 39 School Hold Harmless14,042,939.20$ 19,655,250$ (5,612,310.80)$ 14,741,438$ (698,498.30)$ 242-0000-313.30-00 1,083,998.84$ 1,377,362$ (293,363.16)$ 1,033,022$ 50,977.34$ Special Districts 226-0000-313.30-10 3,094,781.71$ 3,800,000$ (705,218.29)$ 2,850,000$ 244,781.71$ Article 44 *524 Sales Tax 225-0000-313.30-10 1,664,616.30$ 2,529,968$ (865,351.70)$ 1,897,476$ (232,859.70)$ 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 General Fund Board of Education U:\My Documents\Monthly Reports\2017 - 2018\Sales Tax\Sales Tax 2018