Loading...
HomeMy Public PortalAbout2023-11 NO Meeting - Sales Tax ReportMemo To:Shiela Pearre From:Shelby Convery Date:November 8, 2023 Re:Sales Tax Revenues The City received the November 1 % Sales Tax in the amount of $1,043,919 which is $7,772 less than projected for November. January through November overage is $533,139 (3.95%) in the General Fund. 1% General Sales Tax Receipt Actual Budget Period Receipts Projection Variance Nov-22 Jan-23 $1,259,616 $1,026,648 $232,968 Dec-22 Feb-23 $1,216,173 $1,120,272 $95,901 Jan-23 & Oct-Dec 22 Qtrly Mar-23 $1,022,304 $1,125,672 ($103,368) Feb-23 Apr-23 $1,159,734 $959,706 $200,029 Mar-23 May-23 $1,016,572 $941,216 $75,356 Apr-23 & Jan-Mar 23 Qtrly Jun-23 $1,278,048 $1,289,592 ($11,545) May-23 Jul-23 $1,210,579 $1,135,175 $75,404 Jun-23 Aug-23 $1,164,947 $1,147,955 $16,992 Jul-23 & Apr-June 23 Qtrly Sep-23 $1,314,300 $1,270,875 $43,424 Aug-23 Oct-23 $1,085,882 $1,170,133 ($84,251) Sep-23 Nov-23 $1,043,919 $1,051,691 ($7,772) Oct-23 & Jul-Sept 23 Qtrly Dec-23 $1,261,065 Total Overage/Shortfall $12,772,074 $13,500,000 $533,139 1/2% Capital Improvement Tax - Sales Tax H Receipt Actual Budget Period Receipts Projection Variance Nov-22 Jan-23 $614,170 $ 519,792 $94,378 Dec-22 Feb-23 $603,664 $ 556,425 $47,239 Jan-23 & Oct-Dec 22 Qtrly Mar-23 $492,760 $ 563,512 ($70,752) Feb-23 Apr-23 $560,057 $ 477,122 $82,935 Mar-23 May-23 $490,388 $ 474,411 $15,977 Apr-23 & Jan-Mar 23 Qtrly Jun-23 $621,539 $ 641,494 ($19,955) May-23 Jul-23 $584,311 $ 572,975 $11,337 Jun-23 Aug-23 $577,849 $ 577,523 $326 Jul-23 & Apr-June 23 Qtrly Sep-23 $644,848 $ 636,773 $8,075 Aug-23 Oct-23 $522,774 $ 578,954 ($56,180) Sep-23 Nov-23 $503,633 $ 520,413 ($16,780) Oct-23 & Jul-Sept 23 Qtrly Dec-23 $ 630,606 Total Overage/Shortfall $6,215,994 $6,750,000 $96,600 1/2% Parks Sales Tax Receipt Actual Budget Period Receipts Projection Variance Nov-22 Jan-23 $614,170 $ 469,739 $144,431 Dec-22 Feb-23 $603,664 $ 502,835 $100,829 Jan-23 & Oct-Dec 22 Qtrly Mar-23 $492,761 $ 509,438 ($16,677) Feb-23 Apr-23 $560,057 $ 431,180 $128,878 Mar-23 May-23 $490,388 $ 428,728 $61,660 Apr-23 & Jan-Mar 23 Qtrly Jun-23 $621,540 $ 579,722 $41,818 May-23 Jul-23 $584,311 $ 517,610 $66,702 Jun-23 Aug-23 $577,849 $ 521,910 $55,939 Jul-23 & Apr-June 23 Qtrly Sep-23 $644,848 $ 575,455 $69,393 Aug-23 Oct-23 $522,771 $ 523,202 ($430) Sep-23 Nov-23 $503,633 $ 470,300 $33,333 Oct-23 & Jul-Sept 23 Qtrly Dec-23 $ 569,882 Total Overage/Shortfall $6,215,992 $6,100,000 $685,875 1/4% Public Safety Tax Receipt Actual Budget Period Receipts Projection Variance Nov-22 Jan-23 $305,603 $ 259,896 $45,707 Dec-22 Feb-23 $301,101 $ 278,212 $22,889 Jan-23 & Oct-Dec 22 Qtrly Mar-23 $245,290 $ 281,756 ($36,466) Feb-23 Apr-23 $278,185 $ 238,561 $39,624 Mar-23 May-23 $243,340 $ 237,206 $6,134 Apr-23 & Jan-Mar 23 Qtrly Jun-23 $310,277 $ 320,747 ($10,470) May-23 Jul-23 $290,835 $ 286,487 $4,347 Jun-23 Aug-23 $282,943 $ 288,761 ($5,818) Jul-23 & Apr-June 23 Qtrly Sep-23 $322,586 $ 318,386 $4,200 Aug-23 Oct-23 $260,846 $ 289,477 ($28,631) Sep-23 Nov-23 $249,383 $ 260,207 ($10,824) Oct-23 & Jul-Sept 23 Qtrly Dec-23 $ 315,303 Total Overage/Shortfall $3,090,390 $3,375,000 $30,693 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 2023 Account Number 10-100-400010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2015 2016 2017 2018 2019 2020 2021 2022 2023 Average Nov January 944,619 929,179 1,083,570 884,259 1,071,917 1,049,305 986,180 1,023,976 1,259,616 act. 1,003,128 Dec February 727,437 812,670 806,789 927,290 885,496 942,049 971,262 1,222,207 1,216,173 act. 989,661 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 1,022,304 act. 1,105,988 Feb April 1,059,943 893,024 843,561 986,714 892,285 949,276 895,779 1,000,444 1,159,734 act. 944,900 Mar May 618,854 648,305 687,741 709,248 731,421 828,799 861,134 981,749 1,016,572 act. 822,470 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 1,278,048 act. 1,157,354 May July 963,280 1,012,207 1,154,051 1,117,038 979,846 1,139,419 1,112,675 1,109,974 1,210,579 act. 1,091,790 Jun August 562,996 661,518 678,636 821,132 770,155 912,996 996,635 1,251,810 1,164,947 act. 950,546 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 1,314,300 act. 1,221,900 Aug October 918,839 903,829 883,215 879,331 875,539 1,020,452 1,113,777 1,177,321 1,085,882 act. 1,013,284 Sept November 661,849 623,645 615,667 774,337 818,656 856,748 971,814 1,087,375 1,043,919 act. 901,786 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,237,576 1,261,065 est. 1,130,553 Actual to Date $ 10,856,302 $ 11,002,277 $ 11,304,678 $ 11,470,052 $ 11,511,614 $ 12,219,110 $ 12,778,432 $ 13,687,585 $12,772,074 Estimated to Fiscal Year end (based on averages and on Budgeted amount)$1,261,065 Total Actual & Estimated $14,033,139 Less: Budget $13,500,000 Over (Under) Budget $533,139 1,259,616 2,475,790 3,498,094 4,657,828 5,674,400 6,952,448 8,163,027 9,327,973 10,642,273 11,728,155 12,772,074 1,026,648 2,146,920 3,272,591 4,232,297 5,173,513 6,463,106 7,598,280 8,746,235 10,017,111 11,187,244 12,238,935 13,500,000 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 14,000,000 14,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/9/2023 City of Jefferson, Mo. - Account Analysis Account Name Capital Imprs Sales Tax Rate: One-Half percent (½%) Receipt Month: NOVEMBER 2023 Account Number 46-100-400010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2015 2016 2017 2018 2019 2020 2021 2022 2023 Average Nov January 461,560 455,278 525,521 424,160 525,696 513,808 483,288 509,721 614,170 act. 491,335 Dec February 362,597 405,543 402,964 444,476 427,711 458,324 473,674 589,318 603,664 act. 478,700 Jan & Oct-Dec Qtrly March 511,685 563,056 506,597 575,894 527,714 518,493 542,898 534,222 492,760 act. 539,844 Feb April 512,808 431,353 411,020 455,943 430,468 458,553 430,804 480,689 560,057 act. 451,291 Mar May 308,247 322,957 340,162 340,740 351,775 402,202 430,383 475,930 490,388 act. 400,206 Apr & Jan-Mar Qtrly June 496,466 539,529 489,008 508,225 554,062 537,105 626,235 599,274 621,539 act. 564,980 May July 473,120 498,229 559,119 548,625 481,405 560,720 547,153 547,456 584,311 act. 537,072 Jun August 280,733 330,112 338,618 393,512 372,416 443,962 487,128 616,545 577,849 act. 462,713 Jul & Apr-Jun Qtrly September 565,296 570,134 542,457 545,731 615,998 597,489 596,853 619,635 644,848 act. 595,141 Aug October 442,371 435,416 425,493 423,478 421,199 494,618 538,917 567,114 522,774 act. 489,065 Sept November 330,393 310,506 307,281 374,512 395,311 415,079 469,176 525,019 503,633 act. 435,819 Oct & Jul-Sept Qtrly December 515,478 494,218 652,070 510,228 495,454 558,134 604,664 600,044 630,606 est. 553,705 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,664,966 $6,215,995 Estimated to Fiscal Year end (based on averages and on Budgeted amount)$630,606 Total Actual & Estimated $6,846,601 Less: Budget $6,750,000 Over (Under) Budget $96,601 614,170  1,217,835  1,710,595  2,270,652  2,761,040  3,382,579  3,966,891  4,544,740  5,189,588  5,712,362  6,215,995  519,792  1,076,217  1,639,728  2,116,851  2,591,262  3,232,756  3,805,731  4,383,254  5,020,027  5,598,981  6,119,394  6,750,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 6,850,000 7,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 Printed 11/9/2023 City of Jefferson, Mo. - Account Analysis Account Name Parks Sales Tax Rate: One-Half percent (½%) Receipt Month: NOVEMBER 2023 Account Number 21-210-400010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2015 2016 2017 2018 2019 2020 2021 2022 2023 Average Nov January 461,472 455,239 525,521 424,192 525,690 513,808 483,288 509,721 614,170 act. 491,340 Dec February 362,371 405,543 395,217 450,479 427,689 458,324 473,676 589,297 603,664 act. 479,893 Jan & Oct-Dec Qtrly March 511,582 563,039 506,524 577,148 527,588 518,493 542,898 534,624 492,761 act. 540,150 Feb April 512,738 431,353 411,020 457,060 430,459 458,632 430,808 480,688 560,057 act. 451,529 Mar May 308,030 322,957 340,162 340,708 350,479 402,202 430,383 475,930 490,388 act. 399,941 Apr & Jan-Mar Qtrly June 496,386 539,529 489,008 508,266 554,065 537,107 626,235 599,274 621,540 act. 564,989 May July 473,038 498,229 559,115 548,639 481,406 560,720 547,152 547,054 584,311 act. 536,994 Jun August 280,513 330,112 338,470 393,578 372,405 443,965 487,128 616,545 577,849 act. 462,724 Jul & Apr-Jun Qtrly September 565,217 572,847 542,457 545,842 616,012 597,492 596,854 619,635 644,848 act. 595,167 Aug October 442,370 435,416 425,497 423,387 421,199 494,618 538,913 567,114 522,771 act. 489,046 Sept November 330,393 310,506 307,305 374,484 395,311 415,079 469,176 525,019 503,633 act. 435,814 Oct & Jul-Sept Qtrly December 515,368 494,218 652,101 510,220 495,452 558,134 604,664 600,044 569,882 est. 553,703 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,664,945 $6,215,992 Estimated to Fiscal Year end (based on averages and on Budgeted amount)$569,882 Total Actual & Estimated $6,785,874 Less: Budget $6,100,000 Over (Under) Budget $685,874 614,170 1,217,834 1,710,595 2,270,652 2,761,040 3,382,579 3,966,891 4,544,740 5,189,588 5,712,359 6,215,992 469,739 972,574 1,482,012 1,913,192 2,341,920 2,921,642 3,439,251 3,961,161 4,536,616 5,059,818 5,530,118 6,100,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/9/2023 City of Jefferson, Mo. - Account Analysis Account Name Public Safety Rate: One-Quarter percent (1/4%) Receipt Month: NOVEMBER 2023 Account Number 55-100-400010 REPORTING PERIOD RECEIPT PERIOD 2022 2023 Nov January 0.00 305,603 act. Dec February 0.00 301,101 act. Jan & Oct-Dec Qtrly March 0.00 245,290 act. Feb April 0.00 278,185 act. Mar May 0.00 243,340 act. Apr & Jan-Mar Qtrly June 194,548.64 310,277 act. May July 239,893.32 290,835 act. Jun August 303,285.52 282,943 act. Jul & Apr-Jun Qtrly September 308,722.21 322,586 act. Aug October 281,012.20 260,846 act. Sept November 259,718.13 249,383 act. Oct & Jul-Sept Qtrly December 297,156.18 315,303 est. Actual to Date $1,884,336 $3,090,389 Estimated to Fiscal Year end (based on averages and on Budgeted amount)$315,303 Total Actual & Estimated $3,405,692 Less: Estimated Revenue $3,375,000 Over (Under) Budget $30,692 305,603 606,704 851,993 1,130,179 1,373,518 1,683,795 1,974,630 2,257,574 2,580,160 2,841,006 3,090,389 259,896 538,108 819,864 1,058,425 1,295,631 1,616,378 1,902,866 2,191,627 2,510,013 2,799,490 3,059,697 3,375,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 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/9/2023