Loading...
HomeMy WebLinkAbout.4_Sales Tax 20238 August 8/30/2023 2023 General Fund Treasurer 001.250 Sales 31311 Special Purpose 31315 9 MONTHLY SALES TAX RECEIPTS Revenue Cumulative Cumulative 3 yr. avg Expected Actual Over/Under % of 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2020-2022 2023 2023 Expected expected ProjectionJanuary154,373 180,283 156,597 207,318 152,937 133,849 137,774 137,615 177,776 176,956 163,811 185,292 185,505 207,899 258,313 303,235 326,695 354,280 393,215 7.4%389,774 393,215 $3,441 100.88%$5,279,490February224,687 244,043 249,049 206,809 219,448 215,617 201,110 206,281 227,634 218,000 239,784 263,305 310,729 279,301 314,528 355,834 380,545 398,029 412,586 8.6%449,256 412,586 -$33,229 96.04%$5,026,031March142,119 161,270 157,709 170,679 177,252 122,153 136,282 115,959 194,619 156,957 164,393 194,466 189,576 206,999 241,958 251,543 291,915 350,367 382,123 6.8%353,978 382,123 -$5,085 99.57%$5,210,986April156,731 170,147 181,390 162,253 148,592 131,100 127,885 124,117 174,718 154,216 167,550 181,384 193,862 202,532 209,415 249,173 308,631 333,775 377,962 6.7%353,089 377,962 $19,789 101.28%$5,300,273May198,754 211,995 207,595 212,586 181,514 175,118 178,468 151,451 195,175 178,074 207,951 226,291 249,596 271,431 295,191 267,758 391,264 429,025 439,294 8.2%430,895 439,294 $28,187 101.43%$5,307,905June 164,380 165,275 175,802 167,706 172,947 133,593 154,669 133,909 166,750 156,362 196,231 196,762 208,349 248,506 263,069 243,568 359,215 401,566 393,711 7.6%397,749 393,711 $24,149 101.02%$5,286,508July187,091 235,150 199,236 174,881 159,276 136,373 166,276 155,881 188,957 174,130 185,889 204,143 236,448 262,489 308,592 323,542 395,282 416,750 463,547 8.6%449,717 463,547 $37,979 101.34%$5,303,659August220,873 241,022 250,665 244,562 199,901 184,345 187,132 192,602 219,583 238,784 257,369 276,309 293,953 309,575 355,294 348,337 441,657 467,081 527,973 9.5%497,835 527,973 $68,116 102.05%$5,340,587September211,602 211,286 200,636 213,505 187,214 173,733 169,379 242,312 198,879 212,018 227,766 247,376 241,325 307,750 319,609 372,118 395,639 432,971 9.1%475,520 - October 213,751 244,393 214,468 212,410 168,681 161,452 182,962 203,958 214,572 208,256 239,390 254,002 267,264 306,832 334,704 365,211 402,815 451,872 9.2%483,112 - November 253,367 234,710 263,159 239,855 213,651 200,463 180,293 206,475 220,843 231,070 240,812 293,377 279,959 311,101 363,975 369,025 428,588 487,075 9.7%508,771 - December 183,910 170,134 197,603 197,943 155,866 150,355 146,560 176,593 169,167 196,112 195,665 215,537 219,772 280,843 337,112 323,421 360,336 436,352 8.5%443,593 - TTL 2,311,638 2,469,708 2,453,909 2,410,507 2,137,279 1,918,151 1,968,790 2,047,153 2,348,673 2,300,936 2,486,611 2,738,244 2,876,339 3,195,259 3,601,761 3,772,767 4,482,583 4,959,143 3,390,410 100.0%$5,233,290 $3,390,410ytd 1,449,008 1,609,185 1,578,043 1,546,794 1,411,867 1,232,148 1,289,596 1,217,815 1,545,212 1,453,479 1,582,977 1,727,952 1,868,018 1,988,733 2,246,361 2,342,991 2,895,205 3,150,872 3,390,410 3,322,294 3,390,410 68,116 ytd change 11.05%-1.94%-1.98%-8.72%-12.73%4.66%-5.57%26.88%-5.94%8.91%9.16%8.11%6.46%12.95%4.30%23.57%8.83%7.60%2.05%over (under) ytd expectedannual % chg.6.84%-0.64%-1.77%-11.33%-10.25%2.64%3.98%14.73%-2.03%8.07%10.12%5.04%11.09%12.72%4.75%18.81%10.63%Cumulative Cumulative Special Purp./Public Safety Tax 3 yr avg.Projection Actual Over/Under % of20052006200720082009201020112012201320142015201620172018201920202021202220232019-21 2023 2023 Expected expected Projection January 45,217 50,919 50,377 51,210 58,026 61,161 66,993 79,236 84,751 89,951 99,009 121,134 7.5%97,326 121,134 $23,808 124.46%$1,622,092February61,899 70,678 67,508 73,364 83,521 93,242 90,853 94,690 101,181 104,630 113,672 120,428 8.7%113,602 120,428 $30,634 114.52%$1,492,566March40,604 56,106 49,782 50,931 62,285 61,183 66,479 70,614 72,888 80,801 95,448 106,525 6.8%88,588 106,525 $48,570 116.22%$1,514,630April43,155 51,054 47,573 52,541 59,481 59,911 63,784 65,310 69,887 83,697 95,308 104,345 6.8%88,501 104,345 $64,414 116.60%$1,519,642May51,908 58,324 56,012 62,613 74,233 78,716 84,357 88,754 75,138 107,326 119,872 118,284 8.2%107,505 118,284 $75,194 115.17%$1,501,055June 45,930 46,797 50,067 48,647 58,717 65,832 65,229 75,141 77,429 68,693 99,946 110,725 112,649 7.6%99,336 112,649 $88,506 113.00%$1,472,764July55,488 49,385 68,295 54,074 56,793 69,908 73,136 81,117 89,815 86,275 107,036 115,043 127,524 8.4%109,644 127,524 $106,386 115.35%$1,503,311August59,578 56,220 56,063 68,712 76,734 87,275 89,679 97,261 107,514 94,459 123,789 129,406 145,792 9.5%123,619 145,792 $128,559 115.13%$1,500,500September55,746 54,902 61,455 64,622 72,022 77,854 77,534 97,036 94,733 96,212 112,903 124,207 9.1%118,523 - October 59,692 61,120 64,400 64,152 73,903 82,028 82,991 95,473 97,187 101,038 111,516 139,292 9.6%125,109 - November 58,107 60,952 64,915 71,491 77,947 89,596 90,736 98,020 105,075 102,364 120,031 140,213 9.9%128,936 - December 46,767 49,281 52,177 59,043 62,263 66,133 69,582 83,431 93,783 67,940 101,650 118,938 7.9%102,595 - TOTAL 381,308 621,440 704,453 701,993 769,039 876,170 903,099 999,945 1,064,140 1,020,826 1,243,276 1,401,133 956,681 100.0%1,303,286 956,681 ytd 160,996 395,185 461,506 442,685 482,904 560,560 582,256 625,985 673,362 653,272 797,176 878,482 956,681 828,122 $956,681ytd change 16.78%-4.08%9.09%16.08%3.87%7.51%7.57%-2.98%22.03%10.20%8.90%15.52%over (under) ytd expectedannual % chg.62.98%13.36%-0.35%9.55%13.93%3.07%10.72%6.42%-4.07%21.79%12.70% Sales Tax receipts are for the approximate timeframe of two months prior depending on the business reporting schedules.3 yr. avg YTD Budget YTD Actual Over/Under % of Year End Sales Tax 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2020-2022 2023 2023 Expected expected Projection General & Option 1,449,008 1,609,185 1,578,043 1,546,794 1,411,867 1,232,148 1,289,596 1,217,815 1,545,212 1,453,479 1,582,977 1,727,952 1,868,018 1,988,733 2,246,361 2,342,991 2,895,205 3,150,872 3,390,410 3,322,294 3,390,410 68,116 102.1%$5,340,587Special Purpose - - - - - - 160,996 395,185 461,506 442,685 482,904 560,560 582,256 625,985 673,362 653,272 797,176 878,482 956,681 828,122 956,681 128,559 115.5%$1,505,610G&O and SP Sal 1,449,008 1,609,185 1,578,043 1,546,794 1,411,867 1,232,148 1,450,592 1,613,000 2,006,718 1,896,164 2,065,881 2,288,511 2,450,274 2,614,718 2,919,723 2,996,263 3,692,381 4,029,355 4,347,092 4,150,416 4,347,092 196,675 104.7%6,846,198 Full Year Total A 2,311,638 2,469,708 2,453,909 2,410,507 2,137,279 1,918,151 2,350,098 2,668,593 3,053,126 3,002,929 3,255,650 3,614,414 3,779,438 4,195,203 4,665,900 4,793,593 5,725,858 6,355,574 6,355,574 6,536,576 ytd change 11.1%-1.9%-2.0%-8.7%-12.7%17.7%11.2%24.4%-5.5%9.0%10.8%7.1%6.7%11.7%2.6%23.2%9.1%7.9%4.74%over (under) ytd expectedannual % chg.6.8%-0.6%-1.8%-11.3%-10.3%22.5%13.6%14.4%-1.6%8.4%11.0%4.6%11.0%11.2%2.7%19.4%11.1%309,748.29$ - 1,000,000 2,000,000 3,000,000 4,000,000 5,000,000 6,000,000 20 0 5 20 0 6 20 0 7 20 0 8 20 0 9 20 1 0 20 1 1 20 1 2 20 1 3 20 1 4 20 1 5 20 1 6 20 1 7 20 1 8 20 1 9 20 2 0 20 2 1 20 2 2 20 2 3 GENERAL & OPTIONAL SALES TAX RECEIPTS BY MONTH AND YEAR(Does not include Special Purpose/Public Safety Tax) December November October September August July June May April March February January 2023 0 1000000 2000000 3000000 4000000 5000000 6000000 20 0 5 20 0 6 20 0 7 20 0 8 20 0 9 20 1 0 20 1 1 20 1 2 20 1 3 20 1 4 20 1 5 20 1 6 20 1 7 20 1 8 20 1 9 20 2 0 20 2 1 20 2 2 20 2 3 Sales Tax and Special Purpose Sales Tax YTD, Actual Total and 2023 Budget Special PurposeYTD General &Optional YTD Sales Tax Full Year TotalActual w/ 2022Budget August 2023 514,349 533,013 488,648 482,307 557,578 506,360 591,072 673,765 -- -- - 100,000 200,000 300,000 400,000 500,000 600,000 700,000 800,000 1 2 3 4 5 6 7 8 9 10 11 12 2023 Monthly Actual Revenue & Budgeted Share $365,007 $(17,979)$189,040 $283,339 $272,383 $222,696 $270,394 $304,511 -$500,000 $500,000 $1,500,000 $2,500,000 $3,500,000 $4,500,000 $5,500,000 $6,500,000 $7,500,000 2023 Cumulative YTD Actual & Budget Expected by Month August $0.00