HomeMy Public PortalAbout2024-01 NO Meeting - Sales Tax ReportMemo
To:Shiela Pearre
From:Shelby Convery
Date:January 5, 2024
Re:Sales Tax Revenues
The City received the January 1 % Sales Tax in the amount of $1,191,685 which is $70,473 less
than projected for January. January shortage is $70,473 (0.50%) 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,218,627 $1,216,173
Jan-24 & Oct-Dec 23 Qtrly Mar-24 $1,024,367 $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 $1,191,685 $14,042,670 ($70,473) $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 $ 621,636 $603,664
Jan-24 & Oct-Dec 23 Qtrly Mar-24 $ 507,431 $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 $580,334 $7,021,335 ($52,121) $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 $ 593,187 $603,664
Jan-24 & Oct-Dec 23 Qtrly Mar-24 $ 484,208 $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 $580,334 $6,700,000 ($23,176) $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 $ 311,728 $301,101
Jan-24 & Oct-Dec 23 Qtrly Mar-24 $ 253,947 $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 $290,472 $3,510,667 ($25,917) $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: JANUARY 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,218,627 est. 1,047,437
Jan & Oct-Dec Qtrly March 1,088,631 1,066,146 1,115,596 1,103,825 1,022,304 1,024,367 est. 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 $1,191,685
Estimated to Fiscal Year end (based on averages and on Budgeted amount)$12,780,512
Total Actual & Estimated $13,972,197
Less: Budget $14,042,670
Over (Under) Budget -$70,473
1,191,6851,191,685 1,191,685 1,191,685 1,191,685 1,191,685 1,191,685 1,191,685 1,191,685 1,191,685 1,191,685 1,191,6851,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 1/5/2024
City of Jefferson, Mo. - Account Analysis
Account Name Capital Imprs Sales Tax Rate: One-Half percent (½%) Receipt Month: JANUARY 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 621,636 est. 510,538
Jan & Oct-Dec Qtrly March 527,714 518,493 542,898 534,222 492,760 507,431 est. 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 $580,334
Estimated to Fiscal Year end (based on averages and on Budgeted amount)$6,388,880
Total Actual & Estimated $6,969,214
Less: Budget $7,021,335
Over (Under) Budget -$52,121
580,334 580,334 580,334 580,334 580,334 580,334 580,334 580,334 580,334 580,334 580,334 580,334 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 1/5/2024
City of Jefferson, Mo. - Account Analysis
Account Name Parks Sales Tax Rate: One-Half percent (½%) Receipt Month: JANUARY 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 593,187 est. 510,530
Jan & Oct-Dec Qtrly March 527,588 518,493 542,898 534,624 492,761 484,208 est. 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 $580,334
Estimated to Fiscal Year end (based on averages and on Budgeted amount)$6,096,490
Total Actual & Estimated $6,676,824
Less: Budget $6,700,000
Over (Under) Budget -$23,176
580,334580,334 580,334 580,334 580,334 580,334 580,334 580,334 580,334 580,334
580,334 580,334603,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 1/5/2024
City of Jefferson, Mo. - Account Analysis
Account Name Public Safety Rate: One-Quarter percent (1/4%) Receipt Month: JANUARY 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 311,728 est.
Jan & Oct-Dec Qtrly March 0.00 245,289.74 253,947 est.
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 $290,472
Estimated to Fiscal Year end (based on averages and on Budgeted amount)$3,194,279
Total Actual & Estimated $3,484,751
Less: Estimated Revenue $3,510,667
Over (Under) Budget -$25,917
290,472290,472 290,472 290,472 290,472 290,472 290,472 290,472 290,472 290,472
290,472 290,472316,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 1/5/2024