Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My Public Portal
About
2022-11 NO Meeting - Sales Tax Report
Memo To:Steve Crowell From:Shelby Convery Date:November 7, 2022 Re:Sales Tax Revenues The City received the September 1% Sales Tax in the amount of $1,087,375 which is $169,760 more than projected for November. January through November overage is $1,114,572 (8.90%) in the General Fund. 1% General Sales Tax Receipt Actual Budget Period Receipts Projection 1 Variance Nov-21 Jan-22 $1,023,976 $1,021,454 $2,523 Dec-21 Feb-22 $1,222,207 $956,778 $265,429 Jan-22 & Oct-Dec 21 Qtrly Mar-22 $1,103,825 $1,087,131 $16,694 Feb-22 Apr-22 $1,000,444 $917,291 $83,153 Mar-22 May-22 $981,749 $848,048 $133,701 Apr-22 & Jan-Mar 22 Qtrly Jun-22 $1,227,939 $1,199,514 $28,424 May-22 Jul-22 $1,109,974 $1,130,153 ($20,178) Jun-22 Aug-22 $1,251,038 $958,297 $292,741 interest adjustment Aug-22 $773 $0 $773 Jul-22 & Apr-June 22 Qtrly Sep-22 $1,263,389 $1,228,151 $35,237 Aug-22 Oct-22 $1,177,321 $1,071,005 $106,316 Sep-22 Nov-22 $917,615 Oct-22 & Jul-Sept 22 Qtrly Dec-22 $1,186,039 Total Overage/Shortfall $11,362,634 $12,521,475 $944,812 1Budgeted based on 3-year average percentage 1/2% Capital Improvement Tax - Sales Tax G & H Receipt Actual Budget Period Receipts Projection 2 Variance Nov-21 Jan-22 $509,721 $ 432,354 $77,367 Dec-21 Feb-22 $589,318 $ 404,978 $184,339 Jan-22 & Oct-Dec 21 Qtrly Mar-22 $534,222 $ 460,153 $74,069 Feb-22 Apr-22 $480,689 $ 388,264 $92,424 Mar-22 May-22 $475,930 $ 358,956 $116,975 Apr-22 & Jan-Mar 22 Qtrly Jun-22 $599,274 $ 507,722 $91,552 May-22 Jul-22 $547,456 $ 478,363 $69,093 Jun-22 Aug-22 $616,170 $ 405,621 $210,549 interest adjustment Aug-22 $375 $ 0 $375 Jul-22 & Apr-June 22 Qtrly Sep-22 $619,635 $ 519,843 $99,792 Aug-22 Oct-22 $567,114 $ 453,327 $113,787 Sep-22 Nov-22 $525,019 $ 388,401 $136,618 Oct-22 & Jul-Sept 22 Qtrly Dec-22 $ 502,018 Total Overage/Shortfall $6,064,922 $5,300,000 $1,266,940 2Budgeted based on 3-year average percentage 1/2% Parks Sales Tax Receipt Actual Budget Period Receipts Projection 3 Variance Nov-21 Jan-22 $509,721 $ 490,007 $19,714 Dec-21 Feb-22 $589,297 $ 458,981 $130,316 Jan-22 & Oct-Dec 21 Qtrly Mar-22 $534,624 $ 521,514 $13,110 Feb-22 Apr-22 $480,688 $ 440,038 $40,650 Mar-22 May-22 $475,930 $ 406,822 $69,109 Apr-22 & Jan-Mar 22 Qtrly Jun-22 $599,274 $ 575,425 $23,848 May-22 Jul-22 $547,054 $ 542,152 $4,903 Jun-22 Aug-22 $616,170 $ 459,710 $156,460 interest adjustment Aug-22 $375 $ 0 $375 Jul-22 & Apr-June 22 Qtrly Sep-22 $619,635 $ 589,163 $30,472 Aug-22 Oct-22 $567,114 $ 513,778 $53,336 Sep-22 Nov-22 $525,019 $ 440,194 $84,825 Oct-22 & Jul-Sept 22 Qtrly Dec-22 $ 568,961 Total Overage/Shortfall $6,064,902 $6,006,745 $627,118 3Budgeted based on 3-year average percentage 1/4% Public Safety Tax Receipt Actual Budget Period Receipts Projection 4 Variance Nov-21 Jan-22 $0 $ 0 $0 Dec-21 Feb-22 $0 $ 0 $0 Jan-22 & Oct-Dec 21 Qtrly Mar-22 $0 $ 0 $0 Feb-22 Apr-22 $0 $ 0 $0 Mar-22 May-22 $0 $ 0 $0 Apr-22 & Jan-Mar 22 Qtrly Jun-22 $194,549 $ 266,532 ($71,984) May-22 Jul-22 $239,893 $ 228,643 $11,250 Jun-22 Aug-22 $303,233 $ 204,799 $98,435 interest adjustment Aug-22 $52 $ 0 $52 Jul-22 & Apr-June 22 Qtrly Sep-22 $308,722 $ 251,717 $57,005 Aug-22 Oct-22 $281,012 $ 228,870 $52,142 Sep-22 Nov-22 $259,718 $ 199,698 $60,020 Oct-22 & Jul-Sept 22 Qtrly Dec-22 $ 253,074 Total Overage/Shortfall $1,587,180 $1,633,333 $206,920 4Budgeted based on 7 of 12 months - $2,800,000 annual collections - using General Fund FY2021 monthly collection percentages Period Reporting Period Reporting Period Reporting Period Reporting City of Jefferson, Mo. - Account Analysis Account Name General Fund Sales Tax Rate: One percent (1%) Receipt Month: NOVEMBER 2022 Account Number 10-100-400010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2015 2016 2017 2018 2019 2020 2021 2022 Average Nov January 944,619 929,179 1,083,570 884,259 1,071,917 1,049,305 986,180 1,023,976 act. 1,015,046 Dec February 727,437 812,670 806,789 927,290 885,496 942,049 971,262 1,222,207 act. 906,577 Jan & Oct-Dec Qtrly March 1,091,021 1,183,675 1,073,842 1,155,742 1,088,631 1,066,146 1,115,596 1,103,825 act. 1,099,991 Feb April 1,059,943 893,024 843,561 986,714 892,285 949,276 895,779 1,000,444 act. 913,523 Mar May 618,854 648,305 687,741 709,248 731,421 828,799 861,134 981,749 act. 763,669 Apr & Jan-Mar Qtrly June 1,045,933 1,119,566 1,000,942 1,042,310 1,126,211 1,093,256 1,297,057 1,227,939 act. 1,111,955 May July 963,280 1,012,207 1,154,051 1,117,038 979,846 1,139,419 1,112,675 1,109,974 act. 1,100,606 Jun August 562,996 661,518 678,636 821,132 770,155 912,996 996,635 1,251,810 act. 835,911 Jul & Apr-Jun Qtrly September 1,185,891 1,197,976 1,143,504 1,129,543 1,262,838 1,228,769 1,224,960 1,263,389 act. 1,197,923 Aug October 918,839 903,829 883,215 879,331 875,539 1,020,452 1,113,777 1,177,321 act. 954,463 Sept November 661,849 623,645 615,667 774,337 818,656 856,748 971,814 1,087,375 act. 807,444 Oct & Jul-Sept Qtrly December 1,075,638 1,016,682 1,333,160 1,043,108 1,008,620 1,131,896 1,231,564 1,186,039 est. 1,149,670 Actual to Date $ 10,856,302 $ 11,002,277 $ 11,304,678 $ 11,470,052 $ 11,511,614 $ 12,219,110 $ 12,778,432 $12,450,009 Estimated to Fiscal Year end (based on averages and on Budgeted amount)$1,186,039 Total Actual & Estimated $13,636,048 Less: Budget $12,521,475 Over (Under) Budget $1,114,572 1,023,976 2,246,183 3,350,008 4,350,452 5,332,201 6,560,139 7,670,114 8,921,924 10,185,313 11,362,634 12,450,009 1,021,454 1,978,232 3,065,363 3,982,653 4,830,701 6,030,216 7,160,368 8,118,666 9,346,817 10,417,822 11,335,437 12,521,475 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 12,500,000 13,000,000 13,500,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 Printed 11/7/2022 City of Jefferson, Mo. - Account Analysis Account Name Capital Imprs Sales Tax Rate: One-Half percent (½%) Receipt Month: NOVEMBER 2022 Account Number 45/46-100-400010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2015 2016 2017 2018 2019 2020 2021 2022 Average Nov January 461,560 455,278 525,521 424,160 525,696 513,808 483,288 509,721 act. 494,495 Dec February 362,597 405,543 402,964 444,476 427,711 458,324 473,674 589,318 act. 441,430 Jan & Oct-Dec Qtrly March 511,685 563,056 506,597 575,894 527,714 518,493 542,898 534,222 act. 534,319 Feb April 512,808 431,353 411,020 455,943 430,468 458,553 430,804 480,689 act. 437,358 Mar May 308,247 322,957 340,162 340,740 351,775 402,202 430,383 475,930 act. 373,052 Apr & Jan-Mar Qtrly June 496,466 539,529 489,008 508,225 554,062 537,105 626,235 599,274 act. 542,927 May July 473,120 498,229 559,119 548,625 481,405 560,720 547,153 547,456 act. 539,404 Jun August 280,733 330,112 338,618 393,512 372,416 443,962 487,128 616,545 act. 407,127 Jul & Apr-Jun Qtrly September 565,296 570,134 542,457 545,731 615,998 597,489 596,853 619,635 act. 579,706 Aug October 442,371 435,416 425,493 423,478 421,199 494,618 538,917 567,114 act. 460,741 Sept November 330,393 310,506 307,281 374,512 395,311 415,079 469,176 525,019 act. 392,272 Oct & Jul-Sept Qtrly December 515,478 494,218 652,070 510,228 495,454 558,134 604,664 502,018 est. 564,110 Actual to Date $ 5,260,753 $ 5,356,330 $ 5,500,311 $ 5,545,522 $ 5,599,211 $ 5,958,488 $ 6,231,172 $6,064,922 Estimated to Fiscal Year end (based on averages and on Budgeted amount)$502,018 Total Actual & Estimated $6,566,940 Less: Budget $5,300,000 Over (Under) Budget $1,266,940 509,721 1,099,039 1,633,261 2,113,949 2,589,880 3,189,154 3,736,609 4,353,154 4,972,789 5,539,903 6,064,922 432,354 837,332 1,297,485 1,685,749 2,044,704 2,552,426 3,030,789 3,436,410 3,956,253 4,409,581 4,797,982 5,300,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 5,350,000 5,600,000 5,850,000 6,100,000 6,350,000 6,600,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 Printed 11/7/2022 City of Jefferson, Mo. - Account Analysis Account Name Parks Sales Tax Rate: One-Half percent (½%) Receipt Month: NOVEMBER 2022 Account Number 21-210-400010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2015 2016 2017 2018 2019 2020 2021 2022 Average Nov January 461,472 455,239 525,521 424,192 $525,690 513,808 483,288 509,721 act. 494,500 Dec February 362,371 405,543 395,217 450,479 $427,689 458,324 473,676 589,297 act. 441,077 Jan & Oct-Dec Qtrly March 511,582 563,039 506,524 577,148 $527,588 518,493 542,898 534,624 act. 534,530 Feb April 512,738 431,353 411,020 457,060 $430,459 458,632 430,808 480,688 act. 437,596 Mar May 308,030 322,957 340,162 340,708 $350,479 402,202 430,383 475,930 act. 372,787 Apr & Jan-Mar Qtrly June 496,386 539,529 489,008 508,266 $554,065 537,107 626,235 599,274 act. 542,936 May July 473,038 498,229 559,115 548,639 $481,406 560,720 547,152 547,054 act. 539,406 Jun August 280,513 330,112 338,470 393,578 $372,405 443,965 487,128 616,545 act. 407,109 Jul & Apr-Jun Qtrly September 565,217 572,847 542,457 545,842 $616,012 597,492 596,854 619,635 act. 579,731 Aug October 442,370 435,416 425,497 423,387 $421,199 494,618 538,913 567,114 act. 460,723 Sept November 330,393 310,506 307,305 374,484 $395,311 415,079 469,176 525,019 act. 392,271 Oct & Jul-Sept Qtrly December 515,368 494,218 652,101 510,220 $495,452 558,134 604,664 568,961 est. 564,114 Actual to Date $ 5,259,477 $ 5,358,988 $ 5,492,397 $ 5,554,002 $ 5,597,755 $ 5,958,575 $ 6,231,173 $6,064,901 Estimated to Fiscal Year end (based on averages and on Budgeted amount)$568,961 Total Actual & Estimated $6,633,862 Less: Budget $6,006,745 Over (Under) Budget $627,118 509,721 1,099,018 1,633,642 2,114,330 2,590,261 3,189,534 3,736,589 4,353,133 4,972,768 5,539,882 6,064,901 490,007 948,988 1,470,502 1,910,540 2,317,362 2,892,787 3,434,939 3,894,649 4,483,812 4,997,590 5,437,783 6,006,745 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 5,600,000 5,850,000 6,100,000 6,350,000 6,600,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 Printed 11/7/2022 City of Jefferson, Mo. - Account Analysis Account Name Public Safety Rate: One-Quarter percent (1/4%) Receipt Month: NOVEMBER 2022 Account Number 55-100-400010 REPORTING PERIOD RECEIPT PERIOD 2022 Nov January 0 act. Dec February 0 act. Jan & Oct-Dec Qtrly March 0 act. Feb April 0 act. Mar May 0 act. Apr & Jan-Mar Qtrly June 194,549 act. May July 239,893 act. Jun August 303,286 act. Jul & Apr-Jun Qtrly September 308,722 act. Aug October 281,012 act. Sept November 259,718 act. Oct & Jul-Sept Qtrly December 253,074 est. Actual to Date $1,587,180 Estimated to Fiscal Year end (based on averages and on Budgeted $253,074 Total Actual & Estimated $1,840,254 Less: Estimated Revenue $1,633,333 7 of 12 months - $2,800,000 annually Over (Under) Budget $206,921 194,549 434,442 737,727 1,046,450 1,327,462 1,587,180 266,532 495,176 699,974 951,691 1,180,561 1,380,259 1,633,333 100,000 350,000 600,000 850,000 1,100,000 1,350,000 1,600,000 1,850,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 Printed 11/7/2022