Loading...
HomeMy Public PortalAbout2024-03 NO Meeting - Sales Tax ReportMemo To:Shiela Pearre From:Shelby Convery Date:March 7, 2024 Re:Sales Tax Revenues The City received the March 1 % Sales Tax in the amount of $1,207,245 which is $182,879 more than projected for March. January through March overage is $187,646 (1.33%) in the General Fund. 1% General Sales Tax Receipt Actual Budget Prior Year Period Receipts Projection Variance Actual Receipts Nov-23 Jan-24 $1,191,685 $1,262,157 ($70,473)$1,259,616 Dec-23 Feb-24 $1,293,867 $1,218,627 $75,240 $1,216,173 Jan-24 & Oct-Dec 23 Qtrly Mar-24 $1,207,245 $1,024,367 $182,879 $1,022,304 Feb-24 Apr-24 $1,162,074 $1,159,734 Mar-24 May-24 $1,018,623 $1,016,572 Apr-24 & Jan-Mar 24 Qtrly Jun-24 $1,280,626 $1,278,048 May-24 Jul-24 $1,213,021 $1,210,579 Jun-24 Aug-24 $1,167,297 $1,164,947 Jul-24 & Apr-June 24 Qtrly Sep-24 $1,316,951 $1,314,300 Aug-24 Oct-24 $1,088,073 $1,085,882 Sep-24 Nov-24 $1,046,025 $1,043,919 Oct-24 & Jul-Sept 24 Qtrly Dec-24 $1,244,830 $1,242,324 Total Overage/Shortfall $3,692,797 $14,042,670 $187,646 $14,014,398 1/2% Capital Improvement Tax - Sales Tax H Receipt Actual Budget Prior Year Period Receipts Projection Variance Actual Receipts Nov-23 Jan-24 $580,334 $ 632,455 ($52,121)$614,170 Dec-23 Feb-24 $631,360 $ 621,636 $9,723 $603,664 Jan-24 & Oct-Dec 23 Qtrly Mar-24 $591,447 $ 507,431 $84,016 $492,760 Feb-24 Apr-24 $ 576,731 $560,057 Mar-24 May-24 $ 504,988 $490,388 Apr-24 & Jan-Mar 24 Qtrly Jun-24 $ 640,044 $621,539 May-24 Jul-24 $ 601,707 $584,311 Jun-24 Aug-24 $ 595,053 $577,849 Jul-24 & Apr-June 24 Qtrly Sep-24 $ 664,046 $644,848 Aug-24 Oct-24 $ 538,338 $522,774 Sep-24 Nov-24 $ 518,627 $503,633 Oct-24 & Jul-Sept 24 Qtrly Dec-24 $ 620,281 $602,348 Total Overage/Shortfall $1,803,141 $7,021,335 $41,619 $6,818,342 1/2% Parks Sales Tax Receipt Actual Budget Prior Year Period Receipts Projection Variance Actual Receipts Nov-23 Jan-24 $580,334 $ 603,510 ($23,176)$614,170 Dec-23 Feb-24 $631,360 $ 593,187 $38,173 $603,664 Jan-24 & Oct-Dec 23 Qtrly Mar-24 $591,447 $ 484,208 $107,239 $492,761 Feb-24 Apr-24 $ 550,337 $560,057 Mar-24 May-24 $ 481,877 $490,388 Apr-24 & Jan-Mar 24 Qtrly Jun-24 $ 610,752 $621,540 May-24 Jul-24 $ 574,170 $584,311 Jun-24 Aug-24 $ 567,820 $577,849 Jul-24 & Apr-June 24 Qtrly Sep-24 $ 633,656 $644,848 Aug-24 Oct-24 $ 513,698 $522,771 Sep-24 Nov-24 $ 494,892 $503,633 Oct-24 & Jul-Sept 24 Qtrly Dec-24 $ 591,894 $602,348 Total Overage/Shortfall $1,803,141 $6,700,000 $122,236 $6,818,341 1/4% Public Safety Tax Receipt Actual Budget Prior Year Period Receipts Projection Variance Actual Receipts Nov-23 Jan-24 $290,472 $ 316,388 ($25,917)$305,603 Dec-23 Feb-24 $315,336 $ 311,728 $3,608 $301,101 Jan-24 & Oct-Dec 23 Qtrly Mar-24 $295,017 $ 253,947 $41,070 $245,290 Feb-24 Apr-24 $ 288,003 $278,185 Mar-24 May-24 $ 251,928 $243,340 Apr-24 & Jan-Mar 24 Qtrly Jun-24 $ 321,228 $310,277 May-24 Jul-24 $ 301,099 $290,835 Jun-24 Aug-24 $ 292,929 $282,943 Jul-24 & Apr-June 24 Qtrly Sep-24 $ 333,971 $322,586 Aug-24 Oct-24 $ 270,052 $260,846 Sep-24 Nov-24 $ 258,184 $249,383 Oct-24 & Jul-Sept 24 Qtrly Dec-24 $ 311,209 $300,600 Total Overage/Shortfall $900,825 $3,510,667 $18,762 $3,390,990 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: MARCH 2024 Account Number 10-100-400010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2019 2020 2021 2022 2023 2024 Average Nov January 1,071,917 1,049,305 986,180 1,023,976 1,259,616 1,191,685 act.1,078,199 Dec February 885,496 942,049 971,262 1,222,207 1,216,173 1,293,867 act.1,047,437 Jan & Oct-Dec Qtrly March 1,088,631 1,066,146 1,115,596 1,103,825 1,022,304 1,207,245 act.1,079,300 Feb April 892,285 949,276 895,779 1,000,444 1,159,734 1,162,074 est.979,504 Mar May 731,421 828,799 861,134 981,749 1,016,572 1,018,623 est.883,935 Apr & Jan-Mar Qtrly June 1,126,211 1,093,256 1,297,057 1,227,939 1,278,048 1,280,626 est.1,204,502 May July 979,846 1,139,419 1,112,675 1,109,974 1,210,579 1,213,021 est.1,110,498 Jun August 770,155 912,996 996,635 1,251,810 1,164,947 1,167,297 est.1,019,309 Jul & Apr-Jun Qtrly September 1,262,838 1,228,769 1,224,960 1,263,389 1,314,300 1,316,951 est.1,258,851 Aug October 875,539 1,020,452 1,113,777 1,177,321 1,085,882 1,088,073 est.1,054,594 Sept November 818,656 856,748 971,814 1,087,375 1,043,919 1,046,025 est.955,702 Oct & Jul-Sept Qtrly December 1,008,620 1,131,896 1,231,564 1,237,576 1,242,324 1,244,830 est.1,170,396 Actual to Date $ 11,511,614 $ 12,219,110 $ 12,778,432 $ 13,687,585 $ 14,014,398 $3,692,797 Estimated to Fiscal Year end (based on averages and on Budgeted amount)$10,537,519 Total Actual & Estimated $14,230,316 Less: Budget $14,042,670 Over (Under) Budget $187,646 1,191,685 2,485,552 3,692,797 3,692,797 3,692,797 3,692,797 3,692,797 3,692,797 3,692,797 3,692,797 3,692,797 3,692,797 1,262,157 2,480,784 3,505,151 4,667,225 5,685,847 6,966,473 8,179,494 9,346,791 10,663,742 11,751,815 12,797,840 14,042,670 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 15,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 Printed 3/7/2024 City of Jefferson, Mo. - Account Analysis Account Name Capital Imprs Sales Tax Rate:One-Half percent (½%)Receipt Month: MARCH 2024 Account Number 46-100-400010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2019 2020 2021 2022 2023 2024 Average Nov January 525,696 513,808 483,288 509,721 614,170 580,334 act.529,337 Dec February 427,711 458,324 473,674 589,318 603,664 631,358 act.510,538 Jan & Oct-Dec Qtrly March 527,714 518,493 542,898 534,222 492,760 591,447 act.523,218 Feb April 430,468 458,553 430,804 480,689 560,057 576,731 est.472,114 Mar May 351,775 402,202 430,383 475,930 490,388 504,988 est.430,136 Apr & Jan-Mar Qtrly June 554,062 537,105 626,235 599,274 621,539 640,044 est.587,643 May July 481,405 560,720 547,153 547,456 584,311 601,707 est.544,209 Jun August 372,416 443,962 487,128 616,545 577,849 595,053 est.499,580 Jul & Apr-Jun Qtrly September 615,998 597,489 596,853 619,635 644,848 664,046 est.614,965 Aug October 421,199 494,618 538,917 567,114 522,774 538,338 est.508,924 Sept November 395,311 415,079 469,176 525,019 503,633 518,627 est.461,644 Oct & Jul-Sept Qtrly December 495,454 558,134 604,664 600,044 602,348 620,281 est.572,129 Actual to Date $ 5,599,211 $ 5,958,488 $ 6,231,172 $ 6,664,966 $ 6,818,343 $1,803,139 Estimated to Fiscal Year end (based on averages and on Budgeted amount)$5,259,813 Total Actual & Estimated $7,062,952 Less: Budget $7,021,335 Over (Under) Budget $41,617 580,334 1,211,692 1,803,139 1,803,139 1,803,139 1,803,139 1,803,139 1,803,139 1,803,139 1,803,139 1,803,139 1,803,139 632,455 1,254,091 1,761,522 2,338,252 2,843,240 3,483,283 4,084,991 4,680,043 5,344,089 5,882,427 6,401,054 7,021,335 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 7,350,000 7,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 3/7/2024 City of Jefferson, Mo. - Account Analysis Account Name Parks Sales Tax Rate:One-Half percent (½%)Receipt Month: MARCH 2024 Account Number 21-210-400010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2019 2020 2021 2022 2023 2024 Average Nov January 525,690 513,808 483,288 509,721 614,170 580,334 act.529,335 Dec February 427,689 458,324 473,676 589,297 603,664 631,360 act.510,530 Jan & Oct-Dec Qtrly March 527,588 518,493 542,898 534,624 492,761 591,447 act.523,273 Feb April 430,459 458,632 430,808 480,688 560,057 550,337 est.472,129 Mar May 350,479 402,202 430,383 475,930 490,388 481,877 est.429,877 Apr & Jan-Mar Qtrly June 554,065 537,107 626,235 599,274 621,540 610,752 est.587,644 May July 481,406 560,720 547,152 547,054 584,311 574,170 est.544,129 Jun August 372,405 443,965 487,128 616,545 577,849 567,820 est.499,578 Jul & Apr-Jun Qtrly September 616,012 597,492 596,854 619,635 644,848 633,656 est.614,968 Aug October 421,199 494,618 538,913 567,114 522,771 513,698 est.508,923 Sept November 395,311 415,079 469,176 525,019 503,633 494,892 est.461,644 Oct & Jul-Sept Qtrly December 495,452 558,134 604,664 600,044 602,348 591,894 est.572,128 Actual to Date $ 5,597,755 $ 5,958,575 $ 6,231,173 $ 6,664,945 $ 6,818,341 $1,803,141 Estimated to Fiscal Year end (based on averages and on Budgeted amount)$5,019,095 Total Actual & Estimated $6,822,236 Less: Budget $6,700,000 Over (Under) Budget $122,236 580,334 1,211,694 1,803,141 1,803,141 1,803,141 1,803,141 1,803,141 1,803,141 1,803,141 1,803,141 1,803,141 1,803,141 603,510 1,196,697 1,680,905 2,231,242 2,713,119 3,323,871 3,898,041 4,465,860 5,099,516 5,613,214 6,108,106 6,700,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 3/7/2024 City of Jefferson, Mo. - Account Analysis Account Name Public Safety Rate:One-Quarter percent (1/4%)Receipt Month: MARCH 2024 Account Number 55-100-400010 REPORTING PERIOD RECEIPT PERIOD 2022 2023 2024 Nov January 0.00 305,602.76 290,472 act. Dec February 0.00 301,100.91 315,336 act. Jan & Oct-Dec Qtrly March 0.00 245,289.74 295,017 act. Feb April 0.00 278,185.28 288,003 est. Mar May 0.00 243,339.78 251,928 est. Apr & Jan-Mar Qtrly June 194,548.64 310,277.01 321,228 est. May July 239,893.32 290,834.71 301,099 est. Jun August 303,285.52 282,943.40 292,929 est. Jul & Apr-Jun Qtrly September 308,722.21 322,586.38 333,971 est. Aug October 281,012.20 260,846.05 270,052 est. Sept November 259,718.13 249,382.89 258,184 est. Oct & Jul-Sept Qtrly December 297,156.18 300,600.40 311,209 est. Actual to Date $1,884,336 $3,390,989 $900,825 Estimated to Fiscal Year end (based on averages and on Budgeted amount)$2,628,605 Total Actual & Estimated $3,529,429 Less: Estimated Revenue $3,510,667 Over (Under) Budget $18,762 290,472 605,808 900,825 900,825 900,825 900,825 900,825 900,825 900,825 900,825 900,825 900,825 316,388 628,116 882,063 1,170,066 1,421,994 1,743,222 2,044,321 2,337,250 2,671,222 2,941,274 3,199,458 3,510,667 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 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 3/7/2024