Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My Public Portal
About
2017-11 Meeting - Sales Tax Report
Memo To:Steve Crowell From:Shiela Pearre Date:November 8, 2017 Re:Sales Tax Revenues The City received the November 1% Sales Tax in the amount of $615,667 which is $69,026 less than projected for November. January thru November shortfall is $229,749 (2.03%) in the General Fund. 1% General Sales Tax Receipt Actual Budget Period Receipts Projection1 Variance Nov-16 Jan-17 $1,083,570 $924,504 $159,066 Dec-16 Feb-17 $806,789 $823,770 ($16,981) Jan-17 & Oct-Dec 16 Qtrly Mar-17 $1,073,842 $1,129,724 ($55,882) Feb-17 Apr-17 $843,561 $951,232 ($107,670) Mar-17 May-17 $687,741 $731,839 ($44,098) Apr-17 & Jan-Mar 17 Qtrly Jun-17 $1,000,942 $1,071,788 ($70,847) May-17 Jul-17 $1,154,051 $1,069,247 $84,804 Jun-17 Aug-17 $678,636 $650,040 $28,597 Jul-17 & Apr-June 17 Qtrly Sep-17 $1,143,504 $1,195,077 ($51,574) Aug-17 Oct-17 $883,215 $969,353 ($86,138) Sep-17 Nov-17 $615,667 $684,693 ($69,026) Oct-17 & Jul-Sept 17 Qtrly Dec-17 $1,098,734 Total Overage/Shortfall $11,300,000 ($229,749) 1Budgeted based on 3-year average percentage 1/2% Capital Improvement Tax - Sales Tax F & G combined Receipt Actual Budget Period Receipts Projection2 Variance Nov-16 Jan-17 $525,521 $396,801 $128,721 Dec-16 Feb-17 $402,964 $353,565 $49,399 Jan-17 & Oct-Dec 16 Qtrly Mar-17 $506,597 $484,882 $21,715 Feb-17 Apr-17 $411,020 $408,272 $2,748 Mar-17 May-17 $340,162 $314,108 $26,054 Apr-17 & Jan-Mar 17 Qtrly Jun-17 $489,008 $460,015 $28,993 May-17 Jul-17 $559,119 $458,924 $100,195 Jun-17 Aug-17 $338,618 $278,999 $59,618 Jul-17 & Apr-June 17 Qtrly Sep-17 $542,457 $512,931 $29,525 Aug-17 Oct-17 $425,493 $416,050 $9,443 Sep-17 Nov-17 $307,281 $411,938 ($104,657) Oct-17 & Jul-Sept 17 Qtrly Dec-17 $353,515 Total Overage/Shortfall $4,850,000 $351,756 2Budgeted based on 3-year average percentage 1/2% Parks Sales Tax Receipt Actual Budget Period Receipts Projection3 Variance Nov-16 Jan-17 $525,521 $415,075 $110,446 Dec-16 Feb-17 $395,217 $369,848 $25,369 Jan-17 & Oct-Dec 16 Qtrly Mar-17 $506,524 $507,213 ($689) Feb-17 Apr-17 $411,020 $427,075 ($16,055) Mar-17 May-17 $340,162 $328,574 $11,587 Apr-17 & Jan-Mar 17 Qtrly Jun-17 $489,008 $481,201 $7,807 May-17 Jul-17 $559,115 $480,060 $79,055 Jun-17 Aug-17 $338,470 $291,848 $46,622 Jul-17 & Apr-June 17 Qtrly Sep-17 $542,457 $536,554 $5,903 Aug-17 Oct-17 $425,497 $435,211 ($9,714) Sep-17 Nov-17 $307,305 $430,909 ($123,604) Oct-17 & Jul-Sept 17 Qtrly Dec-17 $369,796 Total Overage/Shortfall $5,073,365 $136,727 3Budgeted based on 3-year average percentage Period Reporting Period Reporting Period Reporting City of Jefferson, Mo. - Account Analysis Printed 11/8/2017 Account Name General Fund Sales Tax Receipt Month: NOVEMBER 2017 Account Number 10-100-400010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2012 2013 2014 2015 2016 2017 Average Nov January 843,061 764,659 741,056 944,619 929,179 1,083,570 act.844,515 Dec February 619,287 703,181 789,830 727,437 812,670 806,789 act.730,481 Jan & Oct-Dec Qtrly March 992,559 1,008,111 920,599 1,091,021 1,183,675 1,073,842 act.1,039,193 Feb April 852,653 777,424 737,482 1,059,943 893,024 843,561 act.864,105 Mar May 530,069 537,141 802,765 618,854 648,305 687,741 act.627,427 Apr & Jan-Mar Qtrly June 1,028,514 1,023,015 865,930 1,045,933 1,119,566 1,000,942 act.1,016,592 May July 797,785 872,436 1,048,754 963,280 1,012,207 1,154,051 act.938,892 Jun August 557,032 546,351 614,048 562,996 661,518 678,636 act.588,389 Jul & Apr-Jun Qtrly September 1,069,414 1,096,581 996,272 1,185,891 1,197,976 1,143,504 act.1,109,227 Aug October 769,129 717,262 919,035 918,839 903,829 883,215 act.845,619 Sept November 615,421 677,366 651,080 661,849 623,645 615,667 act.645,872 Oct & Jul-Sept Qtrly December 982,684 932,387 1,015,322 1,075,638 1,016,682 1,098,734 est.1,004,542 Actual to Date $ 9,657,608 $ 9,655,913 $ 10,102,175 $ 10,856,302 $ 11,002,277 9,971,518 Estimated to Fiscal Year end (based on averages and on Budgeted amount)1,098,734 Total Actual & Estimated $ 11,070,251 Less: Budget 11,300,000 Over (Under) Budget -$ 229,749 $ 1,083,570 $ 1,890,359 $ 2,964,201 $ 3,807,762 $ 4,495,504 $ 5,496,445 $ 6,650,496 $ 7,329,132 $ 8,472,636 $ 9,355,851 $ 9,971,518 $ 924,504 $ 1,748,274 $ 2,877,998 $ 3,829,230 $ 4,561,069 $ 5,632,857 $ 6,702,104 $ 7,352,144 $ 8,547,221 $ 9,516,574 $ 10,201,266 $ 11,300,000 $ 0 $ 500,000 $ 1,000,000 $ 1,500,000 $ 2,000,000 $ 2,500,000 $ 3,000,000 $ 3,500,000 $ 4,000,000 $ 4,500,000 $ 5,000,000 $ 5,500,000 $ 6,000,000 $ 6,500,000 $ 7,000,000 $ 7,500,000 $ 8,000,000 $ 8,500,000 $ 9,000,000 $ 9,500,000 $ 10,000,000 $ 10,500,000 $ 11,000,000 $ 11,500,000 $ 12,000,000 Nov Dec Jan & Oct-Dec Qtrly Feb Mar Apr & Jan-Mar Qtrly May Jun Jul & Apr-Jun Qtrly Aug Sept Oct & Jul-Sept Qtrly REPORTING PERIOD YTD Actuals vs. YTD Budget Actual Budget City of Jefferson, Mo. - Account Analysis Printed 11/8/2017 Account Name Capital Imprs Sales Tax Receipt Month: NOVEMBER 2017 Account Number 44-100-400010/45-100-440010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2012 2013 2014 2015 2016 2017 Average Nov January 412,434 372,459 359,800 461,560 455,278 525,521 act.412,306 Dec February 308,567 350,813 394,475 362,597 405,543 402,964 act.364,399 Jan & Oct-Dec Qtrly March 466,856 475,110 423,641 511,685 563,056 506,597 act.488,070 Feb April 409,365 372,340 348,172 512,808 431,353 411,020 act.414,808 Mar May 263,902 266,422 399,863 308,247 322,957 340,162 act.312,278 Apr & Jan-Mar Qtrly June 494,757 483,070 416,943 496,466 539,529 489,008 act.486,153 May July 389,423 425,325 503,869 473,120 498,229 559,119 act.457,993 Jun August 278,231 272,603 306,157 280,733 330,112 338,618 act.293,567 Jul & Apr-Jun Qtrly September 504,307 521,260 484,992 565,296 570,134 542,457 act.529,198 Aug October 367,366 357,619 430,185 442,371 435,416 425,493 act.406,591 Sept November 306,968 323,871 324,697 330,393 310,506 307,281 act.319,287 Oct & Jul-Sept Qtrly December 469,095 443,688 485,136 515,478 494,218 353,515 est.481,523 Actual to Date $ 4,671,272 $ 4,664,580 $ 4,877,931 $ 5,260,753 $ 5,356,330 4,848,240 Estimated to Fiscal Year end (based on averages and on Budgeted amount)353,515 Total Actual & Estimated $ 5,201,756 Less: Budget 4,850,000 Over (Under) Budget $ 351,756 $ 525,521 $ 928,485 $ 1,435,082 $ 1,846,103 $ 2,186,264 $ 2,675,273 $ 3,234,392 $ 3,573,009 $ 4,115,466 $ 4,540,959 $ 4,848,240 $ 396,801 $ 750,365 $ 1,235,247 $ 1,643,519 $ 1,957,627 $ 2,417,642 $ 2,876,567 $ 3,155,566 $ 3,668,497 $ 4,084,547 $ 4,496,485 $ 4,850,000 $ 100,000 $ 350,000 $ 600,000 $ 850,000 $ 1,100,000 $ 1,350,000 $ 1,600,000 $ 1,850,000 $ 2,100,000 $ 2,350,000 $ 2,600,000 $ 2,850,000 $ 3,100,000 $ 3,350,000 $ 3,600,000 $ 3,850,000 $ 4,100,000 $ 4,350,000 $ 4,600,000 $ 4,850,000 $ 5,100,000 Nov Dec Jan & Oct- Dec Qtrly Feb Mar Apr & Jan- Mar Qtrly May Jun Jul & Apr-Jun Qtrly Aug Sept Oct & Jul- Sept Qtrly REPORTING PERIOD YTD Actuals vs. YTD Budget Actual Budget City of Jefferson, Mo. - Account Analysis Printed 11/8/2017 Account Name Parks Sales Tax Receipt Month: NOVEMBER 2017 Account Number 21-210-400010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2012 2013 2014 2015 2016 2017 Average Nov January 405,730 372,447 359,708 461,472 455,239 525,521 act.410,919 Dec February 308,456 350,714 393,562 362,371 405,543 395,217 act.364,129 Jan & Oct-Dec Qtrly March 466,713 475,026 423,546 511,582 563,039 506,524 act.487,981 Feb April 409,353 372,242 348,076 512,738 431,353 411,020 act.414,752 Mar May 263,822 266,456 398,085 308,030 322,957 340,162 act.311,870 Apr & Jan-Mar Qtrly June 494,733 482,382 416,845 496,386 539,529 489,008 act.485,975 May July 389,006 425,194 503,790 473,038 498,229 559,115 act.457,851 Jun August 278,072 272,321 305,930 280,513 330,112 338,470 act.293,390 Jul & Apr-Jun Qtrly September 505,913 521,155 484,904 565,217 572,847 542,457 act.530,007 Aug October 366,846 357,482 430,093 442,370 435,416 425,497 act.406,441 Sept November 306,831 323,768 324,481 330,393 310,506 307,305 act.319,196 Oct & Jul-Sept Qtrly December 468,924 443,569 484,999 515,368 494,218 369,796 est.481,415 Actual to Date $ 4,664,400 $ 4,662,755 $ 4,874,018 $ 5,259,477 $ 5,358,988 4,840,296 Estimated to Fiscal Year end (based on averages and on Budgeted amount)369,796 Total Actual & Estimated $ 5,210,092 Less: Budget 5,073,365 Over (Under) Budget $ 136,727 $ 525,521 $ 920,739 $ 1,427,263 $ 1,838,283 $ 2,178,445 $ 2,667,453 $ 3,226,568 $ 3,565,038 $ 4,107,495 $ 4,532,991 $ 4,840,296 $ 415,075 $ 784,923 $ 1,292,136 $ 1,719,211 $ 2,047,785 $ 2,528,986 $ 3,009,046 $ 3,300,895 $ 3,837,449 $ 4,272,660 $ 4,703,569 $ 5,073,365 $ 100,000 $ 350,000 $ 600,000 $ 850,000 $ 1,100,000 $ 1,350,000 $ 1,600,000 $ 1,850,000 $ 2,100,000 $ 2,350,000 $ 2,600,000 $ 2,850,000 $ 3,100,000 $ 3,350,000 $ 3,600,000 $ 3,850,000 $ 4,100,000 $ 4,350,000 $ 4,600,000 $ 4,850,000 $ 5,100,000 $ 5,350,000 Nov Dec Jan & Oct- Dec Qtrly Feb Mar Apr & Jan- Mar Qtrly May Jun Jul & Apr-Jun Qtrly Aug Sept Oct & Jul- Sept Qtrly REPORTING PERIOD YTD Actuals vs. YTD Budget Actual Budget