Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My Public Portal
About
2021-05 Meeting - Sales Tax Report
Memo To:Steve Crowell From:Shiela Pearre Date:May 10, 2021 Re:Sales Tax Revenues The City received the May 1% Sales Tax in the amount of $861,134 which is $42,782 more than projected for May. January through May overage is $61,951 (0.51%) in the General Fund. 1% General Sales Tax Receipt Actual Budget Period Receipts Projection1 Variance Nov-20 Jan-21 $986,180 $1,036,079 ($49,899) Dec-20 Feb-21 $971,262 $923,552 $47,710 Jan-21 & Oct-Dec 20 Qtrly Mar-21 $1,100,217 $1,052,707 $47,510 interest adjustment Mar-21 $15,379 $0 $15,379 Feb-21 Apr-21 $878,640 $937,310 ($58,670) interest adjustment Apr-21 $17,139 $0 $17,139 Mar-21 May-21 $861,134 $818,352 $42,782 Apr-21 & Jan-Mar 21 Qtrly Jun-21 $1,079,475 May-21 Jul-21 $1,125,057 Jun-21 Aug-21 $901,488 Jul-21 & Apr-June 21 Qtrly Sep-21 $1,207,010 Aug-21 Oct-21 $1,007,589 Sep-21 Nov-21 $845,949 Oct-21 & Jul-Sept 21 Qtrly Dec-21 $1,117,628 Total Overage/Shortfall $4,829,951 $12,052,196 $61,951 1Budgeted based on 3-year average percentage 1/2% Capital Improvement Tax - Sales Tax G Receipt Actual Budget Period Receipts Projection2 Variance Nov-20 Jan-21 $483,288 $ 429,830 $53,458 Dec-20 Feb-21 $473,674 $ 383,147 $90,527 Jan-21 & Oct-Dec 20 Qtrly Mar-21 $542,308 $ 436,728 $105,580 interest adjustment Mar-21 $590 $0 $590 Feb-21 Apr-21 $430,804 $ 388,854 $41,950 Mar-21 May-21 $430,383 $ 339,503 $90,880 Apr-21 & Jan-Mar 21 Qtrly Jun-21 $ 447,833 May-21 Jul-21 $ 466,743 Jun-21 Aug-21 $ 373,993 Jul-21 & Apr-June 21 Qtrly Sep-21 $ 500,743 Aug-21 Oct-21 $ 418,010 Sep-21 Nov-21 $ 350,952 Oct-21 & Jul-Sept 21 Qtrly Dec-21 $ 463,662 Total Overage/Shortfall $2,361,047 $5,000,000 $382,984 2Budgeted based on 3-year average percentage 1/2% Parks Sales Tax Receipt Actual Budget Period Receipts Projection3 Variance Nov-20 Jan-21 $483,288 $ 496,737 ($13,449) Dec-20 Feb-21 $473,676 $ 442,787 $30,889 Jan-21 & Oct-Dec 20 Qtrly Mar-21 $542,308 $ 504,709 $37,599 interest adjustment Mar-21 $590 $0 $590 Feb-21 Apr-21 $430,808 $ 449,384 ($18,576) Mar-21 May-21 $430,383 $ 392,351 $38,033 Apr-21 & Jan-Mar 21 Qtrly Jun-21 $ 517,543 May-21 Jul-21 $ 539,397 Jun-21 Aug-21 $ 432,209 Jul-21 & Apr-June 21 Qtrly Sep-21 $ 578,688 Aug-21 Oct-21 $ 483,078 Sep-21 Nov-21 $ 405,581 Oct-21 & Jul-Sept 21 Qtrly Dec-21 $ 535,835 Total Overage/Shortfall $2,361,053 $5,778,300 $75,085 3Budgeted based on 3-year average percentage Period Reporting Period Reporting Period Reporting City of Jefferson, Mo. - Account Analysis Account Name General Fund Sales Tax Rate:One percent (1%)Receipt Month: MAY 2021 Account Number 10-100-400010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2015 2016 2017 2018 2019 2020 2021 Average Nov January 944,619 929,179 1,083,570 884,259 1,071,917 1,049,305 986,180 act.1,003,646 Dec February 727,437 812,670 806,789 927,290 885,496 942,049 971,262 act.874,859 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 act.1,113,607 Feb April 1,059,943 893,024 843,561 986,714 892,285 949,276 895,779 act.912,972 Mar May 618,854 648,305 687,741 709,248 731,421 828,799 861,134 act.721,103 Apr & Jan-Mar Qtrly June 1,045,933 1,119,566 1,000,942 1,042,310 1,126,211 1,093,256 1,079,475 est.1,076,457 May July 963,280 1,012,207 1,154,051 1,117,038 979,846 1,139,419 1,125,057 est.1,080,512 Jun August 562,996 661,518 678,636 821,132 770,155 912,996 901,488 est.768,887 Jul & Apr-Jun Qtrly September 1,185,891 1,197,976 1,143,504 1,129,543 1,262,838 1,228,769 1,207,010 est.1,192,526 Aug October 918,839 903,829 883,215 879,331 875,539 1,020,452 1,007,589 est.912,473 Sept November 661,849 623,645 615,667 774,337 818,656 856,748 845,949 est.737,811 Oct & Jul-Sept Qtrly December 1,075,638 1,016,682 1,333,160 1,043,108 1,008,620 1,131,896 1,117,628 est.1,106,693 Actual to Date $ 10,856,302 $ 11,002,277 $ 11,304,678 $ 11,470,052 $ 11,511,614 $ 12,219,110 $4,829,951 Estimated to Fiscal Year end (based on averages and on Budgeted amount)$7,284,196 Total Actual & Estimated $12,114,148 Less: Budget $12,052,196 Over (Under) Budget $61,951 986,180 1,957,442 3,073,038 3,968,817 4,829,951 1,036,079 1,959,631 3,012,338 3,949,648 4,768,000 5,847,476 6,972,532 7,874,020 9,081,031 10,088,619 10,934,568 12,052,196 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 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 5/10/2021 City of Jefferson, Mo. - Account Analysis Account Name Capital Imprs Sales Tax Rate:One-Half percent (½%)Receipt Month: MAY 2021 Account Number 45-100-400010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2015 2016 2017 2018 2019 2020 2021 Average Nov January 461,560 455,278 525,521 424,160 525,696 513,808 483,288 act.488,893 Dec February 362,597 405,543 402,964 444,476 427,711 458,324 473,674 act.427,804 Jan & Oct-Dec Qtrly March 511,685 563,056 506,597 575,894 527,714 518,493 542,898 act.538,351 Feb April 512,808 431,353 411,020 455,943 430,468 458,553 430,804 act.437,467 Mar May 308,247 322,957 340,162 340,740 351,775 402,202 430,383 act.351,567 Apr & Jan-Mar Qtrly June 496,466 539,529 489,008 508,225 554,062 537,105 447,833 est.525,586 May July 473,120 498,229 559,119 548,625 481,405 560,720 466,743 est.529,620 Jun August 280,733 330,112 338,618 393,512 372,416 443,962 373,993 est.375,724 Jul & Apr-Jun Qtrly September 565,296 570,134 542,457 545,731 615,998 597,489 500,743 est.574,362 Aug October 442,371 435,416 425,493 423,478 421,199 494,618 418,010 est.440,041 Sept November 330,393 310,506 307,281 374,512 395,311 415,079 350,952 est.360,538 Oct & Jul-Sept Qtrly December 515,478 494,218 652,070 510,228 495,454 558,134 463,662 est.542,021 Actual to Date $ 5,260,753 $ 5,356,330 $ 5,500,311 $ 5,545,522 $ 5,599,211 $ 5,958,488 $2,361,047 Estimated to Fiscal Year end (based on averages and on Budgeted amount)$3,021,937 Total Actual & Estimated $5,382,984 Less: Budget $5,000,000 Over (Under) Budget $382,984 483,288 956,962 1,499,860 1,930,664 2,361,047 429,830 812,977 1,249,705 1,638,559 1,978,063 2,425,896 2,892,640 3,266,633 3,767,376 4,185,386 4,536,338 5,000,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 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 5/10/2021 City of Jefferson, Mo. - Account Analysis Account Name Parks Sales Tax Rate:One-Half percent (½%)Receipt Month: MAY 2021 Account Number 21-210-400010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2015 2016 2017 2018 2019 2020 2021 Average Nov January 461,472 455,239 525,521 424,192 $525,690 513,808 483,288 act.488,890 Dec February 362,371 405,543 395,217 450,479 $427,689 458,324 473,676 act.427,450 Jan & Oct-Dec Qtrly March 511,582 563,039 506,524 577,148 $527,588 518,493 542,898 act.538,559 Feb April 512,738 431,353 411,020 457,060 $430,459 458,632 430,808 act.437,705 Mar May 308,030 322,957 340,162 340,708 $350,479 402,202 430,383 act.351,302 Apr & Jan-Mar Qtrly June 496,386 539,529 489,008 508,266 $554,065 537,107 517,543 est.525,595 May July 473,038 498,229 559,115 548,639 $481,406 560,720 539,397 est.529,622 Jun August 280,513 330,112 338,470 393,578 $372,405 443,965 432,209 est.375,706 Jul & Apr-Jun Qtrly September 565,217 572,847 542,457 545,842 $616,012 597,492 578,688 est.574,930 Aug October 442,370 435,416 425,497 423,387 $421,199 494,618 483,078 est.440,023 Sept November 330,393 310,506 307,305 374,484 $395,311 415,079 405,581 est.360,537 Oct & Jul-Sept Qtrly December 515,368 494,218 652,101 510,220 $495,452 558,134 535,835 est.542,025 Actual to Date $ 5,259,477 $ 5,358,988 $ 5,492,397 $ 5,554,002 $ 5,597,755 $ 5,958,575 $2,361,053 Estimated to Fiscal Year end (based on averages and on Budgeted amount)$3,492,332 Total Actual & Estimated $5,853,385 Less: Budget $5,778,300 Over (Under) Budget $75,085 483,288 956,964 1,499,862 1,930,670 2,361,053 496,737 939,525 1,444,234 1,893,618 2,285,968 2,803,511 3,342,908 3,775,117 4,353,805 4,836,883 5,242,465 5,778,300 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 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 5/10/2021