HomeMy WebLinkAbout2022-11_NOV_JeffCo.Treasurer_Gen.+LodgingTax_RevenueReports (as of 12-15-2022)JEFFERSON COUNTY TREASURER
PO Box 571, Port Townsend WA 98368
Email: TreasurerStaff@co.jefferson.wa.us Web: www.co.jefferson.wa.us
Stacie Prada – Treasurer (360) 385-9150
Sabrina Hathaway – Chief Deputy (360) 385-9352
Page | 1
JEFFERSON COUNTY BUDGET COMMITTEE
Treasurer’s November 2022 Revenue Report
• General Fund at $22,794,516 – 97.5% of the 2022 budget. The second sheet shows general fund revenue
charts showing 2015-2022 year to date detail and percentage of actual full year collections.
• Other Funds at $46,310,430 – 98.2% of 2022 budget. The graph on the second page shows the full year
and YTD percentage lines. The purple Grant Management segments in 2021 and 2022 show CARES and
ARPA funds received that contributed significantly to the increase.
• General Fund Cash Balance - $8,415,851 which includes $3,983,459 for the 15% of expenditure reserve.
The reserve amount will go up $81,318 with the proposed 4th quarter appropriation.
• General Sales Tax Receipts - $487,075 General and Optional Sales Tax and $140,213 for Special Purpose
this month. Cumulatively, this is 0.2% under YTD budget and 10.3% over YTD for last year.
• Sales Tax by Sector: Year to Date Retail trade is up 6% in unincorporated Jefferson County and 3%
within the City of Port Townsend. Year to Date Construction is up 13% in the county and up 62% in the
city.
• REET Receipts - Fund 302 - $120,228 for the month which is 8% under budget for the month and 16.6%
less than what it was this month last year. Year to date, it’s 11% over budget and 8% less than last year.
We had five sales over $1 million in unincorporated Jefferson County compared to this month last year
when there were four. Two of the top sales were residences in Woodland Hills, unincorporated Port
Townsend, one in Port Hadlock and two in Port Ludlow. A notable sale in the City is Lighthouse Center
where the UPS store, title company and Pacific Eyecare are located that sold for $4.35 million.
• Hotel/Motel Lodging Tax – Fund 125 - $89,963 including interest. This is 31% over budget for the month,
50% over budget year to date (YTD) and 2.3% more than 2021 YTD.
• DNR Timber Trust 1 – Amounts are distributed by the levy rates for the tax code areas where the timber
activity occurs. The first page shows distributions for full years 2017-2021 and November YTD for 2022.
This was provided last month, but it was missing the amounts for Mental Health and Development
Disabilities for 2017-2018. Research confirmed those funds did receive distribution those years.
• DNR NAP/NRCA Payment In Lieu of Taxes (PILT) and Noxious Weed Distribution Report – Payment
received in December. Amounts are billed annually by the Jefferson County Assessor, and distribution of
DNR PILT is based on the levy rates in the tax code areas of the parcels owned by Washington State and
paid by DNR. The Noxious Weed amount all goes to Fund 109, Noxious Weed overseen by WSU
Extension.
11 November 10/30/2022 2022 General Fund Treasurer 001.250 Sales 31311 Special Purpose 31315
9
MONTHLY SALES TAX RECEIPTS General Fund Treasurer 001.250 Sales 31311 Special Purpose 31315
Revenue Cumulative Cumulative Year End
3 yr. avg Expected Actual Over/Under % of projection
2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2019-21 2022 2022 Expected expected Projection Over/Under
January 154,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 7.5%382,053 354,280 -$27,772 92.73%$4,729,267 (370,733)$
February 224,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 8.9%452,018 398,029 -$81,761 90.20%$4,600,063 (499,937)$
March 142,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 6.6%337,825 350,367 $12,542 94.09%$4,798,763 (301,237)$
April 156,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 6.5%329,998 333,775 $3,777 95.64%$4,877,777 (222,223)$
May 198,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 8.0%410,428 429,025 $18,597 97.55%$4,975,067 (124,933)$
June 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 7.3%372,422 401,566 $29,144 100.53%$5,126,995 26,995$
July 187,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 8.7%441,914 416,750 -$25,164 102.06%$5,204,813 104,813$
August 220,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 9.7%492,613 467,081 -$25,532 100.04%$5,102,045 2,045$
September 211,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.2%467,700 432,971 -$34,728 98.28%$5,012,045 (87,955)$
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.3%474,308 451,872 -$22,436 96.50%$4,921,493 (178,507)$
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.8%499,625 487,075 -$12,549 97.42%$4,968,486 (131,514)$
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 8.6%439,098 - -$439,098
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,522,791 100.0%$5,100,000 $4,522,791
ytd 2,127,728 2,299,574 2,256,306 2,212,564 1,981,413 1,767,796 1,822,230 1,870,560 2,179,506 2,104,824 2,290,946 2,522,707 2,656,567 2,914,415 3,264,649 3,449,346 4,122,247 4,522,791 4,660,902 4,522,791 (138,111)
ytd change 8.08%-1.88%-1.94%-10.45%-10.78%3.08%2.65%16.52%-3.43%8.84%10.12%5.31%9.71%12.02%5.66%19.51%9.72%-2.96%over (under) ytd expected
annual % 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%0.90%from 2021
Special Purp./Public Safety Tax Cumulative Cumulative Year End
Actual 3 yr avg.Projection Actual Over/Under % of projection
2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2019-21 2022 2022 Expected expected Projection Over/Under
January 45,217 50,919 50,377 51,210 58,026 61,161 66,993 79,236 84,751 89,951 99,009 7.6%95,798 99,009 $3,211 103.35%$1,297,654 42,080$
February 61,899 70,678 67,508 73,364 83,521 93,242 90,853 94,690 101,181 104,630 113,672 9.0%113,363 113,672 $308 101.68%$1,276,699 21,125$
March 40,604 56,106 49,782 50,931 62,285 61,183 66,479 70,614 72,888 80,801 95,448 6.7%84,618 95,448 $10,830 104.88%$1,316,902 61,328$
April 43,155 51,054 47,573 52,541 59,481 59,911 63,784 65,310 69,887 83,697 95,308 6.6%82,577 95,308 $12,731 107.20%$1,345,918 90,344$
May 51,908 58,324 56,012 62,613 74,233 78,716 84,357 88,754 75,138 107,326 119,872 8.1%102,316 119,872 $17,555 109.32%$1,372,656 117,082$
June 45,930 46,797 50,067 48,647 58,717 65,832 65,229 75,141 77,429 68,693 99,946 110,725 7.4%92,829 110,725 $17,896 112.47%$1,412,146 156,572$
July 55,488 49,385 68,295 54,074 56,793 69,908 73,136 81,117 89,815 86,275 107,036 115,043 8.5%106,809 115,043 $8,234 114.33%$1,435,544 179,970$
August 59,578 56,220 56,063 68,712 76,734 87,275 89,679 97,261 107,514 94,459 123,789 129,406 9.8%122,893 129,406 $6,513 112.40%$1,411,285 155,711$
September 55,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%114,626 124,207 $9,581 111.08%$1,394,704 139,130$
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.3%116,849 139,292 $22,443 111.67%$1,402,130 146,556$
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.8%123,538 140,213 $16,676 111.58%$1,400,935 145,361$
December 46,767 49,281 52,177 59,043 62,263 66,133 69,582 83,431 93,783 67,940 101,650 7.9%99,357 - -$99,357
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,282,195 100.0%1,255,574 1,282,195
ytd 334,541 572,159 652,276 642,950 706,776 810,037 833,517 916,514 970,357 952,886 1,141,626 1,282,195 1,156,217 $1,282,195
ytd change 14.00%-1.43%9.93%14.61%2.90%9.96%5.87%-1.80%19.81%12.31%10.90%over (under) ytd expected
annual % chg.62.98%13.36%-0.35%9.55%13.93%3.07%10.72%6.42%-4.07%
Sales Tax receipts are for the approximate timeframe of two months prior depending on the business reporting schedules.
YTD Budget YTD Actual Over/Under % of Year End projection
Sales Tax 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2022 2022 Expected expected Projection Over/Under
General & Optional YTD2,127,728 2,299,574 2,256,306 2,212,564 1,981,413 1,767,796 1,822,230 1,870,560 2,179,506 2,104,824 2,290,946 2,522,707 2,656,567 2,914,415 3,264,649 3,449,346 4,122,247 4,522,791 4,660,902 4,522,791 (138,111) 97.0%4,968,486 (131,514)$
Special Purpose YTD - - - - - - 334,541 572,159 652,276 642,950 706,776 810,037 833,517 916,514 970,357 952,886 1,141,626 1,282,195 1,156,217 1,282,195 125,978 110.9%1,400,935 145,361$
G&O and SP Sales Tax YTD2,127,728 2,299,574 2,256,306 2,212,564 1,981,413 1,767,796 2,156,771 2,442,719 2,831,782 2,747,774 2,997,722 3,332,744 3,490,084 3,830,929 4,235,006 4,402,232 5,263,872 5,804,986 5,817,119 5,804,986 (12,134) 99.8%5,792,877 13,847
Full Year Total Actual w/ 2022 Budget2,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
ytd change 8.1%-1.9%-1.9%-10.4%-10.8%22.0%13.3%15.9%-3.0%9.1%11.2%4.7%9.8%10.5%3.9%19.6%10.3%-0.2%over (under) ytd expected
annual % 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%
-
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
2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022
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
2022
-
1,000,000
2,000,000
3,000,000
4,000,000
5,000,000
6,000,000
2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022
Sales Tax and Special Purpose Sales Tax YTD, Actual Total and 2021 Budget
Special Purpose
YTD
General &
Optional YTD
Full Year Total
Actual w/ 2022
Budget
November 2022
453,289
511,701
445,815 429,083
548,896 512,291
531,792
596,487 557,179 591,164
627,288
-
-
100,000
200,000
300,000
400,000
500,000
600,000
700,000
1 2 3 4 5 6 7 8 9 10 11 12
2022 Monthly Actual Revenue & Budgeted Share
Actual 2022
Expected 2022
-$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
1 2 3 4 5 6 7 8 9 10 11 12
2022 Cumulative YTD Actual & Budget Expected by Month
YTD Actual
Year End Projected
Over/Under Budget
YTD Budget
$0.00
November
November 2022 12/15/2022
4 yr avg *2022 2022 % Budget % Diff Projection
2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2018-21 Budget Actual Difference Prior Year Projection +/- EOY Bdgt
January 16,089 11,507 12,045 8,863 13,575 17,051 18,473 19,394 23,177 29,854 32,023 38,926 39,532 30,995 27,824 39,532 42.1%1.6%$763,079 225,989$
February 27,998 25,532 23,188 38,274 30,356 36,141 51,077 53,093 46,226 41,186 34,092 45,296 43,552 41,700 37,434 43,552 16.3%-3.9%$683,793 146,703$
March 22,623 12,406 7,271 11,203 12,715 14,345 14,554 16,889 19,419 25,281 29,621 46,465 40,951 30,196 27,107 40,951 51.1%-11.9%$721,235 184,145$
April 11,344 10,791 14,950 11,430 12,427 14,983 18,530 20,901 23,749 22,829 29,140 43,464 55,711 29,795 26,747 55,711 108.3%28.2%$810,486 273,396$
May 19,646 25,142 17,142 18,010 19,151 23,886 29,462 45,943 41,061 41,546 11,527 66,011 61,311 40,036 35,941 61,311 70.6%-7.1%$834,993 297,903$
June 19,205 17,302 17,916 16,477 18,786 25,070 29,476 31,485 36,556 43,299 742 69,468 64,789 37,517 33,679 64,789 92.4%-6.7%$870,367 333,277$
July 20,155 19,311 20,201 21,512 24,536 27,711 33,687 38,400 44,445 48,748 24,074 70,768 83,704 47,009 42,200 83,704 98.4%18.3%$905,992 368,902$
August 35,178 24,742 31,171 33,140 37,534 48,845 56,349 64,820 64,934 70,516 41,591 85,104 100,707 65,537 58,832 100,707 71.2%18.3%$908,707 371,617$
September 41,757 42,500 40,882 39,890 42,349 44,713 53,487 56,561 68,870 88,306 79,681 90,656 114,776 81,878 73,502 114,776 56.2%26.6%$894,538 357,448$
October 43,012 43,861 41,015 41,741 43,659 49,182 59,970 58,458 65,200 60,682 78,504 67,952 48,371 68,084 61,120 48,371 -20.9%-28.8%$826,925 289,835$
November 44,351 38,547 36,906 39,146 46,879 58,967 57,999 69,054 63,101 65,013 75,302 102,485 89,963 76,475 68,652 89,963 31.0%-12.2%$809,783 272,693$
December 19,873 21,703 11,109 15,514 33,858 25,213 26,084 32,870 46,067 42,545 54,544 53,129 49,071 44,051
Full Year 321,231 293,344 273,796 295,200 335,825 386,107 449,148 507,868 542,805 579,805 490,842 779,723 743,365 598,294 537,090 743,365
YTD 301,358 271,641 262,687 279,686 301,967 360,895 423,064 474,998 496,737 537,260 436,298 726,594.47 743,365 549,222 493,039 743,365 50.8%2.3%
Full Year Actual/20 321,231 293,344 273,796 295,200 335,825 386,107 449,148 507,868 542,805 579,805 490,842 779,723 537,090
YTD Change 1.08%-3.30%6.47%7.97%19.51%17.23%12.28%4.58%8.16%-18.79%35.24%2.31%
Annual % Change 0.24%-6.66%7.82%13.76%14.97%16.33%13.07%6.88%6.82%-15.34%34.48%38.36%$537,090 2022 Budget
2% Basic RCW 67.28.18RCW 67.28.180 2% Special RCW 67.28.181(1).11% Total sales tax paid on a lodging charges for periods of less than 30 consecutive days
Revenue reflects 2% "basic" as a credit against 6.5% state sales tax, 2% "special" tax levied locally, interest on amounts held at DOR until disbursement, and 1% Admin fee from DOR.
Revenue is reported one month after reporting to DOR. It typically reflects collections for activity from two months prior to distribution. Some businesses may report quarterly or annually.
0
100,000
200,000
300,000
400,000
500,000
600,000
700,000
800,000
900,000
2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022
December
November
October
September
August
July
June
May
April
March
February
January
2022 SPECIAL HOTEL/MOTEL & TRANSIENT RENTAL SALES TAX -Fund 125
Includes Investment Interest
0
100,000
200,000
300,000
400,000
500,000
600,000
700,000
800,000
2022 YTD Actual and Budget
YTD Actual YTD Budget Projected Over/Under Budget
0
20,000
40,000
60,000
80,000
100,000
120,000
140,000
2022 Monthly Actual and Budget
2022 Actual Budget
November