Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2021-07_July_RevenueReports
JEFFERSON COUNTY TREASURER PO Box 571, Port Townsend WA 98368 Email: sprada@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 July 2021 Revenue Report • General Fund at $13,889,640 – 63.4% of the 2021 budget year to date which is higher than previous years. The second sheet shows general fund revenue charts showing 2015-2021 year to date detail and percentage of actual full year collections. Second Quarter appropriations are reflected in the budget. • Other Funds at $25,182,844– 62.4% of 2021 budget year to date which is a lot higher than previous years. Budget appropriations are reflected, and fund 123 for Grant Management was adjusted for ARPA funds received of $3.157 million. • General Fund Cash Balance - $9.35 million at the end of June which includes the 3.7 million reserve. Second quarter general fund appropriations amounted to $803,226 raising the budgeted reserve $120,488. • General Sales Tax Receipts - $502,317 which includes $107,036 for Special Purpose in July 2021. Cumulatively, this is 24.7% over budget year to date and if it holds we’re forecasted for about $1.3 million over budget for the year. • Sales Tax by Sector: Sales tax composition by category reflects funds receipted in May for July distribution for all of Jefferson County including the City of Port Townsend. • REET Receipts - Fund 302 - $192,025 in June which is 56% over budget and 7% less than what it was this month last year. We had a total of 28 sales over $500,000 with five properties selling in unincorporated Jefferson County for over $1 million. Four were in tax code 211 (Nordland and Chimacum) and one in 323 (Quilcene). If it holds, the projection is to come in $1.3 million over the original 2021 budget. • Hotel/Motel Lodging Tax – Fund 125 - $70,768 in July. This puts it 80% over budget for the month. Year to date, revenue is 71.8% over budget. 2021 7 July Jefferson County Treasurer 23-Aug-2021 Jefferson County Treasurer REVENUE NAME BARS BUDGET AMENDED JUN JUL Y-T-D Y-T-D Y-T-D BUDGET QTRLY AMENDED ACTUAL JUN Y-T-D Y-T-D ACTUAL JUN Y-T-D Y-T-D *2021 ANNUAL & QTRLY Approp Budget 2021 2021 2021 2021 % of Amended Budget Over/Under Amended Budget 2020 Approp Budget 2020 2020 2020 2020 % of Actual 2019 2019 2019 % of Actual Property Tax 1 311.10 8,538,738 (133,567)8,405,171 60,983 29,613 4,882,137 58.1%(3,523,034)8,290,037 268,714 8,558,751 8,148,279 101,692 4,741,584 58.2%7,992,860 45,010 4,605,400 57.6%Diverted Road Prop Tax 1 311.20 720,000 0 720,000 5,837 2,882 425,573 59.1%(294,427)720,000 720,000 720,000 8,959 421,367 58.5%720,000 4,196 416,773 57.9%Sales Tax 1 313.11 3,453,021 270,910 3,723,931 359,215 395,282 2,453,548 65.9%(1,270,383)3,326,609 3,326,609 3,772,767 243,568 1,994,654 52.9%3,601,761 263,069 1,891,067 52.5% special purpose 313.15 1,084,963 (64,180)1,020,783 99,946 107,036 673,387 66.0%(347,396)1,045,244 1,045,244 1,020,826 68,693 558,813 54.7%1,064,119 77,429 565,828 53.2% Local Criminal Justice 1 313.71 438,710 (3,314)435,396 41,916 44,765 281,552 64.7%(153,844)422,650 422,650 427,244 28,242 232,638 54.5%442,239 32,251 235,113 53.2%Leasehold Excise Tax 3 317.20 66,801 12,297 79,098 21,172 - 43,283 54.7%(35,815)66,801 66,801 79,122 16,910 38,725 48.9%75,500 18,490 37,130 49.2%Private Harvest Tax - TAV 2 317.40.10/.20 339,599 0 339,599 0 - 184,561 54.3%(155,038)339,599 339,599 281,066 0 137,325 48.9%363,246 - 259,278 71.4%P.I.L.T. (incl DNR)4332.15.23/336.02.31 1,035,150 623,245 1,658,395 1,643,245 - 1,669,735 100.7%11,340 1,015,150 1,015,150 1,588,729 1,572,825 1,572,825 99.0%1,553,455 1,537,328 1,537,328 99.0%P.U.D. Privilege Tax 4 335.00.91 398,151 11,789 409,940 0 398,969 398,969 97.3%(10,971)386,555 386,555 398,063 0 398,063 100.0%385,397 - 385,397 100.0%Crim Just Hi Crime/DUI/Asst 5 336.06.10/51 465,324 (5,324)460,000 0 146,409 420,091 91.3%(39,909)451,770 451,770 522,693 0 385,846 73.8%336,086 - 333,709 99.3% Marijuana Excise 6 336.06.41/42 54,124 (3,604)50,520 11,027 - 22,054 43.7%(28,466)52,548 52,548 46,636 12,230 24,461 52.4%170,903 12,111 24,224 14.2% Liquor Excise Tax 8 336.06.94 49,233 9,464 58,697 0 16,031 50,907 86.7%(7,791)48,267 48,267 61,396 0 43,836 71.4%51,439 - 37,729 73.3%Liquor Profit 6 336.06.95 92,463 (7,294)85,169 20,826 - 41,652 48.9%(43,517)90,650 90,650 83,340 20,844 41,687 50.0%83,623 20,968 41,936 50.1%Treasurer Invest & Other Fees 1 341.42.15-20/50 35,830 (11,213)24,617 232 342 10,509 42.7%(14,108)35,830 35,830 32,773 1,171 18,666 57.0%43,596 2,525 23,191 53.2%Treas. Collection Fees (REET)3 341.42.31/32/33 87,175 (11,870)75,305 11,871 15,167 65,310 86.7%(9,995)87,175 87,175 92,802 7,706 39,982 43.1%85,234 7,383 45,734 53.7%Penalties on delinquent taxes 1 359.40.10/.20 122,152 6,119 128,271 10,781 7,953 81,190 63.3%(47,081)119,757 119,757 128,759 13,285 85,041 66.0%113,976 9,437 75,048 65.8%Investment Income 1 361.11 727,260 (305,372)421,888 630 78,614 111,504 26.4%(310,384)713,000 713,000 380,191 14,359 239,945 63.1%1,028,831 64,067 758,898 73.8%Interest on delinquent taxes 1 361.40.10 196,162 30,454 226,616 15,892 12,614 177,901 78.5%(48,715)192,316 192,316 244,045 35,518 163,771 67.1%224,004 14,883 135,254 60.4% Interfund Chg Svc-Cost Alloc 3 362.50.00.180/0671 349,707 (98,445)251,262 0 11,899 31,822 12.7%(219,440)339,521 339,521 243,461 29,207 12.0%232,066 260 28,985 12.5%DNR Timber & DNRTimbTrust 2 1 395.1.1/335.02.33 250,000 0 250,000 0 21,790 21,790 8.7%(228,210)250,000 250,000 525,780 54,065 202,705 38.6%352,075 - 328,974 93.4%Transfer in 1 397.00 3,000 7,000 10,000 27,141 - 30,022 300.2%20,022 3,000 24,074 27,074 36,847 0 25,572 69.4%21,798 16,393 20,298 93.1%Miscellaneous *1 50.1/369.81/369.9 27,784 (10,919)16,865 403 126,436 130,668 774.8%113,803 27,784 27,784 62,869 737 7,849 12.5%111,997 1,308 9,639 8.6% Assessor 1 001-010-000 8,300 0 8,300 5 100 3,752 45.2%(4,548)8,300 8,300 7,943 5 3,845 48.4%9,642 23 3,904 40.5%Auditor-Recording Fees 1 341.21.10 69,495 0 69,495 9,134 9,596 66,322 95.4%(3,173)69,495 69,495 95,307 8,310 50,136 52.6%69,039 5,607 35,860 51.9%Auditor-M.V. License Fees 1341.48+/336.00.93 246,440 16,370 262,810 17,690 61,767 228,144 86.8%(34,666)246,440 16,370 262,810 322,944 17,561 165,948 51.4%302,603 16,970 147,136 48.6%Auditor-Other Revenue 1 35,330 0 35,330 2,927 1,247 56,841 160.9%21,511 35,330 5,696 41,026 29,104 1,431 13,784 47.4%35,127 2,937 20,529 58.4%Elections 1 001-021-000 161,195 73,000 234,195 445 - 55,560 23.7%(178,635)116,110 116,110 326,422 274 309,648 94.9%161,606 - 103,962 64.3%Clerk 1 001-050-000 141,663 (17,798)123,865 9,651 14,961 73,958 59.7%(49,907)149,591 149,591 144,678 10,715 77,970 53.9%149,436 10,725 84,916 56.8%County Administrator 1 001-059-000 3,700 300 4,000 0 - 4,000 100.0%0 438,600 438,600 4,000 0 4,000 100.0%4,260 - 4,260 100.0% Commissioners 1 001-060-000 8,000 0 8,000 933 1,021 6,881 86.0%(1,119)8,000 8,000 10,230 892 5,298 51.8%7,843 649 4,189 53.4%Safety & Security/Emergency Mg 1 001-067-000 75,538 22,811 98,349 0 10,850 49,492 50.3%(48,857)75,538 75,538 67,399 15,857 67,399 100.0%36,232 - 28,578 78.9%Community Services 1 001-068-000 4,172 0 4,172 29 1,081 2,983 71.5%(1,189)4,155 4,155 3,867 23 2,911 75.3%3,987 40 18,990 476.3%District Court 1 001-080-000 655,380 (17,300)638,080 30,633 58,029 274,551 43.0%(363,529)644,505 644,505 579,650 27,071 285,511 49.3%682,644 142,128 360,947 52.9%Juvenile Service 1 001-110-000 278,783 3,147 281,930 13,338 13,547 158,473 56.2%(123,457)279,284 279,284 314,628 3,613 151,063 48.0%243,744 18,906 134,260 55.1%Prosecuting Attorney 1 001-150-000 236,251 0 236,251 17,483 45,002 166,279 70.4%(69,972)320,633 88,000 408,633 237,412 7,958 88,513 37.3%257,902 20,423 139,783 54.2%Coroner 1 001-151-000 25,348 0 25,348 0 - 8,400 33.1%(16,948)25,348 25,348 13,958 0 7,958 57.0%18,324 - 11,924 65.1% Sheriff 1 001-180-000 577,054 344,609 921,663 115,834 39,084 456,112 49.5%(465,551)794,303 263,000 1,057,303 942,051 100,054 484,662 51.4%1,141,545 35,940 646,338 56.6% Superior Court 1 001-240-000 59,547 0 59,547 220 11,123 17,223 28.9%(42,324)59,421 59,421 41,617 220 7,500 18.0%50,414 220 7,720 15.3% Non Departmental 1 001-261/270-000 36,990 0 36,990 30 765 52,506 141.9%15,516 35,568 ########2,484,068 2,627,644 2,589 38,973 1.5%39,722 - 34,572 87.0% TOTAL CURRENT EXPENSE REVENUE 21,158,533 741,315 21,899,848 2,549,471 1,683,973 13,889,640 63.4%(8,010,208)21,334,884 3,114,354 24,449,238 24,666,543 2,397,377 13,169,679 53.4%22,268,272 2,381,676 13,584,799 61.0% * Revenue Schedule 1 monthly, 2 Feb/May/Aug/Nov, 3 Feb/Apr/Jun/Aug/Oct/Dec , 4 Jun 5 Jan/Apr/Jul/Oct 6 Mar/Jun/Sep/Dec 7 Nov 8 Var REFUND EXPEND CY/PRIOR excl 388/89 0 6,000 733.42 17,897 0 52,695 3,771 27,115 1,319 14,301 *July 2021 LE & CJ One Time Cost 125,339 125,339 July2021 GENERAL FUND REVENUE 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021Property Tax 3,929,615 4,033,323 3,963,540 4,047,965 4,137,371 4,228,173 4,301,556 4,373,103 4,459,181 4,605,400 4,741,584 4,882,137Diverted Road Prop Tax 405,542 408,627 409,576 411,326 413,207 424,673 415,508 415,545 412,719 416,773 421,367 425,573Sales Tax 1,047,802 1,102,464 1,025,213 1,325,627 1,214,695 1,325,608 1,451,643 1,574,065 1,679,158 1,891,067 1,994,654 2,453,548 special purpose 0 101,418 338,964 392,913 373,974 406,170 473,285 492,577 528,724 565,828 558,813 673,387Local Criminal Justice 141,533 149,396 142,505 163,965 155,857 168,253 196,702 203,944 220,996 235,113 232,638 281,552Leasehold Excise Tax 26,698 29,779 28,565 28,739 35,978 31,722 29,729 34,549 31,549 37,130 38,725 43,283Private Harvest Tax 64,114 124,315 203,716 272,552 325,648 366,366 183,394 171,790 309,599 259,278 137,325 184,561P.I.L.T. (incl DNR)397,957 486,246 641,300 1,283,164 1,330,422 1,253,823 1,422,312 1,390,772 1,833,818 1,537,328 1,572,825 1,669,735P.U.D. Privilege Tax 50,666 16,788 31,380 32,775 225,457 370,446 318,107 314,148 393,491 385,397 398,063 398,969Crim Just Hi Crime/DUI/Asst 250,761 241,639 248,813 278,952 347,828 359,931 367,324 327,664 320,837 333,709 385,846 420,091Marijuana Enforcement/Excise 0 0 0 0 0 - 25,568 11,354 39,588 24,224 24,461 22,054Liquor Excise Tax 27,662 28,998 31,873 0 9,683 11,894 30,739 32,161 34,380 37,729 43,836 50,907Liquor Profit 36,094 35,925 53,297 42,426 42,354 42,582 42,439 42,310 42,130 41,936 41,687 41,652Treasurer Invest & Other Fees 3,156 2,802 1,992 2,081 1,467 2,263 5,544 22,573 29,397 23,191 18,666 10,509Treas. Collection Fees (REET)15,669 17,023 17,710 20,891 24,471 40,475 49,611 50,530 46,978 45,734 39,982 65,310Penalties on delinquent taxes 49,251 80,864 65,059 71,373 84,115 71,913 72,121 62,008 68,363 75,048 85,041 81,190Investment Income 39,963 26,578 21,434 -4,318 -400 15,184 66,394 249,994 293,098 758,898 239,945 111,504Interest on delinquent taxes 84,088 129,357 118,078 125,765 135,059 139,526 140,839 126,259 130,250 135,254 163,771 177,901Interfund Chg Svc-Cost Alloc 0 0 0 39,051 0 26,255 26,537 30,577 206,731 28,985 29,207 31,822DNR Timber 37,173 403,304 212,836 65,299 204,722 356,803 224,129 4,884 8,200 328,974 202,705 21,790Transfer in 0 0 0 0 0 5,000 21,687 19,546 19,194 20,298 25,572 30,022Miscellaneous227,634 148,185 20,896 35,451 24,684 22,496 15,701 4,000 5,440 9,639 7,849 130,668Assessor992781793153,893 10,495 504 4,345 6,288 4,031 3,904 3,845 3,752Auditor-Recording Fees 36,473 36,827 40,311 46,431 32,499 41,774 41,593 42,760 41,423 35,860 50,136 66,322Auditor-M.V. License Fees 95,375 93,067 92,871 99,551 99,506 98,039 133,358 141,636 136,476 147,136 165,948 228,144Auditor-Other Revenue 20,203 18,374 17,383 21,875 20,728 42,126 17,997 17,690 20,326 20,529 13,784 56,841Elections99,023 59,231 54,954 31,757 72,842 55,146 151,935 55,987 93,388 103,962 309,648 55,560Clerk118,391 112,281 116,248 121,067 123,442 121,812 111,616 98,059 103,992 84,916 77,970 73,958County Administrator 0 0 0 0 0 - - - 4,260 4,260 4,000 4,000Commissioners5,781 4,226 9,189 5,835 4,311 5,016 4,841 5,086 5,097 4,189 5,298 6,881Safety & Security 54,795 28,415 32,088 38,633 28,735 15,003 27,802 39,790 30,414 28,578 67,399 49,492Community Services 0 4,428 839 4,215 3,124 3,241 2,822 2,077 1,407 18,990 2,911 2,983District Court 303,132 350,554 361,508 364,001 360,816 376,797 363,352 349,401 397,137 360,947 285,511 274,551Juvenile Service 166,083 165,242 114,904 195,235 168,424 147,521 150,644 162,184 155,969 134,260 151,063 158,473Prosecuting Attorney 176,195 183,462 120,745 81,283 90,852 152,122 82,347 100,249 77,288 139,783 88,513 166,279Coroner2,320 7,480 3,480 6,380 3,480 3,480 8,340 24,610 18,140 11,924 7,958 8,400Sheriff582,678 540,125 396,159 405,436 265,132 351,887 343,782 351,348 303,112 646,338 484,662 456,112Superior Court 16,976 4,840 3,000 4,844 3,000 4,500 15,321 46,660 26,043 7,720 7,500 17,223Non Departmental 0 0 0 0 0 - 10 10 32,802 34,572 38,973 52,506TOTAL CURRENT EXPENSE 8,513,795 9,176,364 8,941,219 10,216,433 10,373,977 11,088,523 11,340,973 11,398,187 12,565,125 13,584,799 13,169,679 13,889,640TOTAL CURRENT EXPENSE ACTUAL/2020 BUDGET 15198876 16349133 15531592 16964139 17374434.53 18,950,211 19,247,467 19,181,590 20,890,820 22,268,272 24,666,543 21,899,848 YTD % of Full Year Actual/2021 Budget 56.0%56.1%57.6%60.2%59.7%58.5%58.9%59.4%60.1%61.0%53.4%63.4% 0 2,000,000 4,000,000 6,000,000 8,000,000 10,000,000 12,000,000 14,000,000 16,000,000 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 GENERAL FUND REVENUE YTD Non Departmental Superior Court Sheriff Coroner Prosecuting Attorney Juvenile Service District Court Community Services Safety & Security Commissioners County Administrator Clerk Elections Auditor-Other Revenue Auditor-M.V. License Fees Auditor-Recording Fees Assessor Miscellaneous Transfer in DNR Timber Interfund Chg Svc-Cost Alloc Interest on delinquent taxes Investment Income Penalties on delinquent taxes Treas. Collection Fees (REET) Treasurer Invest & Other Fees Liquor Profit Liquor Excise Tax Marijuana Enforcement/Excise Crim Just Hi Crime/DUI/Asst P.U.D. Privilege Tax P.I.L.T. (incl DNR) Private Harvest Tax Leasehold Excise Tax Local Criminal Justice special purpose Sales Tax Diverted Road Prop Tax Property Tax 2021 56.0%56.1%57.6%60.2%59.7%58.5%58.9%59.4%60.1%61.0% 53.4% 63.4% 0.0% 10.0% 20.0% 30.0% 40.0% 50.0% 60.0% 70.0% 80.0% 90.0% 100.0% 0 5,000,000 10,000,000 15,000,000 20,000,000 25,000,000 30,000,000 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 GENERAL FUND YTD AND FULL YEAR ACTUAL/2021 BUDGET TOTAL CURRENT EXPENSE TOTAL CURRENT EXPENSE ACTUAL/2020 BUDGET YTD % of Full Year Actual/2021 Budget July 2021 July OTHER FUNDS REVENUE REPORT 2021 3 year view July 7 8/23/2021 FUND Fund #Orig Budget Budget Amended BDGT Jul YTD YTD Orig Budget Budget Amended BDGT Jun YTD YTD ACTUAL Amended BDGT Jun YTD ACTUAL YTD AMEND BUDGET YTD 2021 Amendment 2021 2021 2021 %2020 Amendment 2020 2020 2020 %2019 2019 2019 2019 %% SPECIAL REVENUE Elections CARES Act 103 - - - 6 n/a - 153,422 153,422 153,422 153,451 n/a HAVA 3 Grant 104 - - 7 65 n/a - 123,419 123,419 - 123,419 n/a Auditor's O & M 105 77,900 77,900 78,522 98,883 126.9%77,900 566 78,466 3,074 70,324 89.6%72,512 80,480 2,304 59,529 82.1%74.0% Court Facilitator 106 4,000 (1,280) 2,720 260 1,860 68.4%4,500 4,500 220 1,540 34.2%4,300 4,100 500 2,940 68.4%71.7% Boating Safety 107 50,000 (5,500) 44,500 3,619 33,553 75.4%50,000 50,000 - 30,384 60.8%50,138 50,138 - 50,138 100.0%100.0% WSU Cooperative 108 401,431 25,487 426,918 38,113 201,611 47.2%532,762 (53,107) 479,655 4,011 237,989 49.6%352,814 468,922 1,947 175,058 49.6%37.3% Noxious Weed 109 203,717 (5,000) 198,717 854 140,343 70.6%217,717 (23,700) 194,017 2,462 108,072 55.7%198,125 260,816 1,763 104,720 52.9%40.2% 4-H After School 113 Moved to Fund 108 - Moved to Fund 108 - 49,508 47,600 12,000 61,200 123.6%128.6% JeffComCap 119 119 276,600 276,600 23,050 161,350 58.3%206,640 206,640 17,220 120,540 58.3%204,000 204,000 17,000 119,000 58.3%58.3% Crime Victim's Svc 120 81,543 81,543 20,541 73,709 90.4%81,543 81,543 1,737 83,557 102.5%127,920 140,813 418 90,405 70.7%64.2% Grant Mgmt 123 150,000 3,261,793 3,411,793 11,881 3,366,908 98.7%150,000 251,680 401,680 - 64,749 16.1%119,570 150,000 - 48,346 40.4%32.2% Hotel-Motel 125 537,087 537,087 70,768 403,265 75.1%521,444 521,444 742 161,219 30.9%579,805 500,500 43,299 252,743 43.6%50.5% Jeff Co Public Health 127 4,820,115 79,415 4,899,530 283,273 3,518,148 71.8%4,994,011 697,569 5,691,580 342,105 3,079,070 54.1%4,758,462 4,651,629 338,140 2,850,079 59.9%61.3% Water Quality 128 1,365,704 (2,227) 1,363,477 15,707 841,331 61.7%1,307,279 1,307,279 117,433 677,986 51.9%1,025,077 1,163,949 75,384 571,341 55.7%49.1% Water Quality Land Acq 129 100,000 85,000 185,000 - - 0.0%115,000 165,386 280,386 - - 0.0%160,179 275,000 - - 0.0%0.0% Mental Health 130 51,732 51,732 283 29,518 57.1%50,289 50,289 960 29,367 58.4%50,299 47,637 366 29,847 59.3%62.7% Chem Dep Mnt Hlth tx 131 561,734 (26,465) 535,269 61,264 385,728 72.1%553,433 553,433 38,748 319,042 57.6%612,026 527,003 44,296 328,354 53.7%62.3% JC Inmate Commissary 134 41,500 (2,500) 39,000 933 9,024 Drug Fund 135 14,240 14,240 129 862 6.1%13,850 13,850 2,600 5,032 36.3%5,982 12,249 197 4,513 75.4%36.8% Law Library 140 11,591 4,827 16,418 810 9,428 57.4%16,081 16,081 575 9,236 57.4%9,149 10,927 591 5,260 57.5%48.1% Trial Court Imprvmnt 141 23,690 23,690 - 14,158 59.8%23,000 23,000 - 14,168 61.6%22,806 23,000 - 17,103 75.0%74.4% Community Develpmnt 143 1,505,632 479,114 1,984,746 90,828 1,428,508 72.0%1,657,637 155,230 1,812,867 139,690 883,277 48.7%1,635,441 1,812,850 104,529 873,669 53.4%48.2% Federal Forest Title III 147 21,000 21,000 10 15,959 21,000 21,000 54 18,223 21,440 - 236 20,420 95.2% Jeff Co Affrdbl Hsg 148 45,582 520,048 565,630 75,807 199,266 35.2%45,131 103,780 148,911 9,501 52,092 35.0%50,363 48,000 4,174 26,998 53.6%56.2% Homeless Housing Fund 149 275,603 145,000 420,603 74,506 290,761 69.1%272,874 187,319 460,193 32,506 199,169 43.3%304,747 587,282 25,303 163,083 53.5%27.8% Treasurer's O & M 150 55,750 (1,000) 54,750 5,265 13,786 25.2%54,650 54,650 4,033 14,223 26.0%49,566 47,624 6,049 15,320 30.9%32.2% REET technology 151 13,401 13,401 177,688 186,312 1390.3%13,816 13,816 1,073 7,740 56.0%15,250 15,690 1,378 8,376 54.9%53.4% Veteran's Relief 155 66,050 66,050 295 49,794 75.4%65,510 65,510 984 48,424 73.9%95,103 89,990 558 48,717 51.2%54.1% Water Pollution Cntrl 160 - - - - 36,279 - - - - - Park & Rec 174 698,883 (37,881) 661,002 6,821 335,828 50.8%684,549 (9,023) 675,526 (610) 287,720 42.6%665,738 669,649 7,552 325,715 48.9%48.6% County Park Imprvmnt 175 208,500 (47,000) 161,500 21,718 50,849 31.5%171,625 31,360 202,985 2,661 56,292 27.7%185,875 160,125 100,074 134,479 72.3%84.0% Post Harvest Timber Mgm 178 8,375 8,375 1 5 - - 4 86 209 50 19 128 61.1%255.1% County Roads 180 8,985,491 (146,585) 8,838,906 303,286 4,754,479 53.8%8,801,630 409,379 9,211,009 357,621 4,619,417 50.2%8,166,809 8,931,921 203,613 5,064,574 62.0%56.7% Facilities Mgmt 183 1,209,958 47,285 1,257,243 - 553,570 44.0%1,169,335 1,169,335 96,936 719,636 61.5%1,111,711 1,065,393 88,783 643,044 57.8%60.4% Total Special Revenue 21,876,781 4,372,531 26,249,312 1,366,232 17,205,075 65.5%21,873,206 1,916,439 23,789,645 1,176,338 11,918,574 50.1%21,003,015 22,327,852 1,080,474 12,095,099 57.8%54.2% CAPITAL IMPROVEMENT Const/Renovation 301 415,233 415,233 - 285,853 68.8%363,826 363,826 - 50,625 13.9%773,299 518,500 26,442 225,568 29.2%43.5% Capital Improvement 302 1,155,500 1,155,500 194,625 1,012,661 87.6%1,156,313 1,000,000 2,156,313 205,638 1,768,836 82.0%1,246,025 1,072,125 104,991 640,824 51.4%59.8% HJC Park Jump 304 - 57,630 57,630 - 0.0% Public Infrastructure 306 567,500 567,500 55,771 350,550 61.8%565,000 565,000 35,328 294,458 52.1%572,302 510,100 42,095 306,187 53.5%60.0% Conservation Futures 308 274,280 (5,980) 268,300 1,540 156,147 58.2%271,860 271,860 5,365 161,259 59.3%280,835 258,841 3,334 166,321 59.2%64.3% Total CAP IMP 2,412,513 51,650 2,464,163 251,936 1,805,211 73.3%2,356,999 1,000,000 3,356,999 246,331 2,275,179 67.8%2,872,460 2,359,566 176,863 1,338,901 53.5%56.7% OTHER FUNDS REVENUE REPORT 2021 3 year view 2021 2021 2021 2021 %2020 2020 2020 2020 %2019 2019 2019 2019 % FUND Orig Budget Amended BDGT Jul YTD YTD Orig Budget Amended BDGT Jun YTD YTD YTD Amended BDGT Jun YTD YTD ENTERPRISE Solid Waste 401 3,670,759 3,670,759 394,955 2,403,485 65.5%3,718,073 3,718,073 339,885 2,204,799 59.3%3,866,094 3,636,313 346,478 2,194,497 56.8%60.3% Solid Waste Post Clos 402 38,686 38,686 2 20 - - 13 238 1,094 - 99 696 63.6% Solid Waste Eqpt Res 403 936,055 936,055 55 451 0.0%15,000 15,000 258 4,718 31.5%19,648 8,000 1,757 12,377 63.0%154.7% Yard Waste Educ Fnd 404 10,915 10,915 0 3 0.0%7,000 7,000 1 31 0.4%209 6,800 19 131 62.5%1.9% Tri Area Sewer 405 1,064,500 381,192 1,445,692 295,014 605,205 41.9%982,500 23,087 1,005,587 246 155,094 15.4%303,778 303,632 1,476 45,082 14.8%14.8% Total ENTERPRISE 5,720,915 381,192 6,102,107 690,027 3,009,165 49.3%4,722,573 23,087 4,745,660 340,403 2,364,881 49.8%4,190,823 3,954,745 349,830 2,252,783 62.5%57.0% INTERNAL SERVICE Equipment Rental 501 2,681,971 167,202 2,849,173 233,926 1,287,404 45.2%2,617,745 18,883 2,636,628 185,741 1,216,854 46.2%2,915,525 3,139,487 181,402 1,293,912 44.4%41.2% Risk Management 502 150,000 150,000 - - 0.0%150,000 150,000 - 529 0.4%38,522 215,000 - 0 0.0%0.0% Benefit Reserve 505 275,000 275,000 23,292 174,226 63.4%275,000 275,000 22,627 229,627 83.5%257,890 208,000 25,293 173,877 67.4%83.6% Information Services 506 1,954,417 333,056 2,287,473 666,010 1,701,763 74.4%1,968,639 1,335,533 3,304,172 2,983 1,401,707 42.4%2,116,237 2,197,065 5,230 1,023,270 48.4%46.6% Total INT SERV 5,061,388 500,258 5,561,646 923,228 3,163,393 56.9%5,011,384 1,354,416 6,365,800 211,351 2,848,717 44.8%5,328,174 5,759,552 211,925 2,491,058 48.4%43.3% Total 35,071,597 5,305,631 40,377,228 3,231,422 25,182,844 62.4%33,964,162 4,293,942 38,258,104 1,974,423 19,407,351 50.7%33,394,473 34,401,715 1,819,090 18,177,841 46.8%52.8% GENERAL FUND CASH BALANCE REPORT July 8/23/2021 END OF MONTH CASH BALANCES 2008 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 January $3,761,366 2,717,342$ 2,548,924$ 3,317,483$ 2,556,108$ 3,030,949$ 2,798,256$ 4,109,412$ 4,360,809$ 4,416,485$ 5,320,169$ 6,803,191$ 8,113,654$ February $3,486,901 1,804,045$ 1,882,264$ 3,023,683$ 1,802,345$ 2,041,248$ 2,202,079$ 3,278,685$ 3,622,756$ 3,681,133$ 4,464,746$ 6,243,097$ 7,894,628$ March $2,898,116 1,691,583$ 1,934,629$ 2,347,678$ 1,654,411$ 2,108,155$ 2,384,301$ 3,289,638$ 3,759,875$ 3,580,887$ 4,861,100$ 6,359,340$ 7,292,627$ April $4,932,654 3,764,298$ 3,819,239$ 4,144,298$ 3,732,606$ 4,429,017$ 4,572,778$ 5,181,554$ 5,391,984$ 5,572,170$ 7,300,275$ 8,452,851$ 9,257,492$ May $4,816,082 3,623,704$ 3,850,878$ 4,045,216$ 3,747,009$ 4,421,127$ 4,622,123$ 5,174,859$ 5,455,638$ 5,330,488$ 7,124,392$ 7,105,615$ 8,972,934$ June $4,785,927 3,554,636$ 4,081,060$ 3,980,389$ 4,663,469$ 4,818,824$ 5,866,387$ 6,413,636$ 6,593,259$ 6,795,577$ 8,169,229$ 8,074,825$ 9,153,137$ July $4,308,238 2,978,751$ 3,732,809$ 3,396,868$ 3,873,932$ 3,736,091$ 5,087,286$ 5,610,102$ 5,806,710$ 6,177,104$ 8,112,936$ 7,785,971$ 9,350,267$ August $3,191,594 2,117,574$ 2,974,460$ 2,394,180$ 3,010,467$ 2,898,623$ 4,203,581$ 5,416,407$ 5,111,812$ 5,237,488$ 6,926,951$ 6,631,983$ September $2,986,861 1,596,637$ 2,312,554$ 1,734,730$ 2,217,696$ 2,118,250$ 3,742,452$ 4,710,400$ 4,724,294$ 4,511,047$ 5,850,565$ 5,829,324$ October $4,764,280 3,363,104$ 4,339,258$ 4,098,330$ 4,148,666$ 4,133,005$ 5,804,449$ 6,326,563$ 6,245,727$ 6,682,718$ 8,291,898$ 7,761,494$ November $4,063,841 3,339,559$ 4,236,934$ 3,781,830$ 3,878,581$ 3,795,871$ 5,043,942$ 5,519,658$ 6,098,807$ 6,804,203$ 7,781,753$ 9,799,671$ December $3,601,124 3,248,681$ 3,862,223$ 3,346,366$ 3,605,804$ 3,694,709$ 4,808,162$ 5,384,768$ 5,201,817$ 6,038,266$ 7,658,281$ 9,709,633$ REQUIRED RESERVE * In 2019, Resolution 41-19 changed the reserve to 15% of the GF Total Spending and eliminated the Revenue Stabilization Reserve - changes with appropriations throughout year 2008 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 Budg Total Reserve $1,528,008 $ 1,530,071 $ 1,666,150 $ 1,708,161 $ 1,786,000 $ 2,121,257 $ 2,140,726 $ 2,308,223 $ 2,589,184 $ 2,703,102 $ 3,281,222 $ 3,862,515 $ 3,589,298 15% GF Budgeted Expenditures *$1,528,008 $ 1,530,071 $ 1,566,150 $ 1,608,161 $ 1,646,000 $ 1,681,257 $ 1,700,726 $ 1,806,223 $ 1,863,184 $ 1,977,102 $ 3,281,222 $ 3,862,515 $ 3,709,786 Revenue Stabilization $ - $ - $ 100,000 $ 100,000 $ 140,000 $ 440,000 $ 440,000 $ 502,000 $ 726,000 $ 726,000 $ - $ - $ - Non-Reserve Cash Balance 3,288,074$ 2,093,633$ 2,184,728$ 2,337,055$ 1,961,009$ 2,299,870$ 2,481,397$ 2,866,637$ 2,866,454$ 2,627,387$ 3,843,170$ 3,243,100$ 5,383,636$ 2008 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 $0 $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000 $7,000,000 $8,000,000 $9,000,000 $10,000,000 January March May July September November General Fund Cash Balance $0 $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000 $7,000,000 $8,000,000 $9,000,000 $10,000,000 2008 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 Budg Reserve and Cash Balance Composition 15% GF Budgeted Expenditures *Revenue Stabilization Non-Reserve Cash Balance July 7 July 7/20/2021 2021 General Fund Treasurer 001-250-000 Sales 313.11 Special Purpose 313.15 MONTHLY SALES TAX RECEIPTS General Fund Treasurer 001-250-000 Sales 313.11 Special Purpose 313.15RevenueCumulativeCumulative Year End3 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 2017-19 2021 2021 Expected expected Projection Over/UnderJanuary154,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 7.3%271,090 326,695 $55,605 120.51%$4,487,768 763,837$ 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 9.0%334,584 380,545 $45,961 116.77%$4,348,400 624,469$ 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 6.6%246,799 291,915 $45,116 117.21%$4,364,692 640,761$ 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 6.3%232,925 308,631 $75,706 120.49%$4,486,929 762,998$ 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 7.9%293,968 391,264 $97,297 123.18%$4,586,996 863,065$ 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 7.1%266,051 359,215 $93,164 125.99%$4,691,933 968,002$ 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 8.5%315,192 395,282 $80,089 128.88%$4,799,585 1,075,654$ 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 9.6%356,971 - -$356,971 99.27% 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 9.5%352,134 - -$352,134 72.32% 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 9.5%354,695 - -$354,695 45.86% 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 9.9%367,856 - -$367,856 22.63% 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 8.9%331,664 - -$331,664 0.00% 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 2,453,548 100.0%$3,723,931 $2,453,548ytd 1,228,135 1,368,163 1,327,378 1,302,232 1,211,966 1,047,803 1,102,464 1,025,213 1,325,629 1,214,695 1,325,608 1,451,643 1,574,065 1,679,158 1,891,067 1,994,654 2,453,548 1,960,610 2,453,548 ytd change 11.40%-2.98%-1.89%-6.93%-13.55%5.22%-7.01%29.30%-8.37%9.13%9.51%8.43%6.68%12.62%5.48%23.01%25.14%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%Special Purp./Public Safety Tax Cumulative Cumulative Year EndActual3 yr avg.Projection Actual Over/Under % of projection200520062007200820092010201120122013201420152016201720182019202020212018-20 2021 2021 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 7.5%76,430 89,951 $13,521 117.69%$1,201,368 180,585$ February 61,899 70,678 67,508 73,364 83,521 93,242 90,853 94,690 101,181 104,630 9.3%94,876 104,630 $9,754 110.28%$1,125,725 104,942$ March 40,604 56,106 49,782 50,931 62,285 61,183 66,479 70,614 72,888 80,801 6.8%69,482 80,801 $11,319 116.29%$1,187,077 166,294$ April 43,155 51,054 47,573 52,541 59,481 59,911 63,784 65,310 69,887 83,697 6.5%65,842 83,697 $17,855 127.12%$1,297,603 276,820$ May 51,908 58,324 56,012 62,613 74,233 78,716 84,357 88,754 75,138 107,326 8.0%82,144 107,326 $25,182 130.66%$1,333,710 312,927$ June 45,930 46,797 50,067 48,647 58,717 65,832 65,229 75,141 77,429 68,693 99,946 7.2%73,215 99,946 $26,731 136.51%$1,393,477 372,694$ July 55,488 49,385 68,295 54,074 56,793 69,908 73,136 81,117 89,815 86,275 107,036 8.3%85,109 107,036 $21,927 125.76%$1,283,772 262,989$ August 59,578 56,220 56,063 68,712 76,734 87,275 89,679 97,261 107,514 94,459 9.7%99,015 - -$99,015 0.00% September 55,746 54,902 61,455 64,622 72,022 77,854 77,534 97,036 94,733 96,212 9.3%95,292 - -$95,292 0.00% October 59,692 61,120 64,400 64,152 73,903 82,028 82,991 95,473 97,187 101,038 9.5%97,183 - -$97,183 0.00% November 58,107 60,952 64,915 71,491 77,947 89,596 90,736 98,020 105,075 102,364 9.9%101,075 - -$101,075 0.00% December 46,767 49,281 52,177 59,043 62,263 66,133 69,582 83,431 93,783 67,940 7.9%81,120 - -$81,120 0.00% TOTAL 381,308 621,440 704,453 701,993 769,039 876,170 903,099 999,945 1,064,140 1,020,826 673,387 100.0%1,020,783 673,387 ytd 101,418 338,965 405,443 373,973 406,170 473,285 492,577 528,724 565,848 558,813 673,387 547,098 $673,387ytd change 19.61%-7.76%8.61%16.52%4.08%7.34%7.02%-1.24%20.50%23.08%over (under) ytd expectedannual % 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.3 yr avg.Projection Actual Over/Under % of projectionSales Tax 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2017-19 2021 2021 Expected expected Projection Over/UnderGeneral & Option 1,228,135 1,368,163 1,327,378 1,302,232 1,211,966 1,047,803 1,102,464 1,025,213 1,325,629 1,214,695 1,325,608 1,451,643 1,574,065 1,679,158 1,891,067 1,994,654 2,453,548 1,960,610 2,453,548 - 4,586,996 762,998$ Special Purpose - - - - - - 101,418 338,965 405,443 373,973 406,170 473,285 492,577 528,724 565,848 558,813 673,387 547,098 673,387 - $1,333,710 276,820 G&O and SP Sal 1,228,135 1,368,163 1,327,378 1,302,232 1,211,966 1,047,803 1,203,882 1,364,178 1,731,072 1,588,668 1,731,778 1,924,928 2,066,642 2,207,882 2,456,915 2,553,467 3,126,935 2,507,707 3,126,935 - 5,920,707 1,039,818 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,744,714 4,744,714 4,744,714 - - - 500,000 1,000,000 1,500,000 2,000,000 2,500,000 3,000,000 3,500,000 4,000,000 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 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 2021 - 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 Sales Tax and Special Purpose Sales Tax YTD, Actual Total and 2020 Budget Special PurposeYTD General &Optional YTD Full Year TotalActual w/ 2020Budget July 2021 - 100,000 200,000 300,000 400,000 500,000 600,000 1 2 3 4 5 6 7 8 9 10 11 12 2021 Monthly Actual Revenue & Budgeted Share Actual 2021 Expected 2021 -$500,000 $500,000 $1,500,000 $2,500,000 $3,500,000 $4,500,000 $5,500,000 1 2 3 4 5 6 7 8 9 10 11 12 2021 Cumulative YTD Actual & Budget Expected by Month YTD Actual Year EndProjectedOver/UnderBudget YTD Budget $0.00 July Report R03.4 Run Date: 08/23/2021 Sales Tax CATEGORY ANALYSIS BY CODE 1600, 1601, 1650, 1651, 1603, 1604 Jefferson County & City of Port Townsend Current Period: 202105 Cash Basis, Revenue Amounts Current Period Year to Date Category Name This Year Last Year % Chg This Year Last Year % Chg Last 12 Months 00 16,927 11,108 52.4 104,090 71,423 45.7 199,064 11 Agriculture, Forestry, Fishing and Hunting 321 618 -48.0 2,895 3,103 -6.7 4,774 21 Mining, Quarrying, and Oil and Gas Extraction 922 919 0.3 11,102 3,969 179.7 19,373 22 Utilities 112 72 54.7 1,029 735 40.0 2,217 23 Construction 90,441 87,459 3.4 601,229 587,464 2.3 1,099,150 31 Manufacturing 1,236 1,568 -21.2 12,097 14,503 -16.6 21,767 32 Manufacturing 1,236 1,468 -15.8 14,189 15,156 -6.4 -6,301 33 Manufacturing 3,677 2,174 69.1 27,489 27,866 -1.4 42,145 42 Wholesale Trade 22,605 16,793 34.6 137,302 119,680 14.7 229,602 44 Retail Trade 75,074 65,892 13.9 462,049 348,553 32.6 815,821 45 Retail Trade 63,860 62,665 1.9 458,116 347,582 31.8 740,528 48 Transportation and Warehousing 1,161 705 64.6 7,796 4,530 72.1 11,705 49 Transportation and Warehousing 32 54 -42.0 399 199 100.7 761 51 Information 12,188 11,196 8.9 88,919 80,001 11.1 147,373 52 Finance and Insurance 1,434 1,398 2.6 10,698 7,894 35.5 18,322 53 Real Estate and Rental and Leasing 5,371 7,188 -25.3 41,966 34,169 22.8 73,228 54 Professional, Scientific, and Technical Services 28,659 6,966 311.4 59,379 33,295 78.3 79,503 55 Management of Companies and Enterprises 22 1 2.0 2,433 66 3.0 2,482 56 Administrative and Support and Waste Management an 24,976 23,941 4.3 174,376 125,797 38.6 295,861 61 Educational Services 164 226 -27.3 1,869 1,431 30.6 3,970 62 Health Care and Social Assistance 702 382 83.8 4,526 2,802 61.5 7,687 71 Arts, Entertainment, and Recreation 2,741 2,148 27.6 12,206 9,239 32.1 26,923 72 Accommodation and Food Services 31,111 12,269 153.6 150,705 107,660 40.0 289,653 81 Other Services (except Public Administration)8,911 5,928 50.3 53,787 38,746 38.8 86,775 92 Public Administration 692 189 266.0 8,750 4,751 84.2 12,064 TOTAL 27,685 Accounts 394,575 323,330 22.0 2,449,395 1,990,613 23.0 4,224,446 NOTE: YTD column includes returns from 202011 to 202105 This report only includes location(s) 1600, 1601, 1650, 16 Last 12 Months by Category -500K 0 500K 1M 1.5M Unknown Mining (except Oil and Gas) Textile Mills Merchant Wholesalers, Durable Goods Support Activities for Transportation Credit Intermediation and Related Activities Waste Management and Remediation Services Food Services and Drinking Places 7 2021 July 302-000-010 Capital Improvement fund, not other financing sources, transfer, appropriation$ Recent 2021 2021 % Budget Month Change 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 4 YR AVG Budget Actual Difference prior year January $78,294 $83,384 $72,424 $45,530 123,064$ 28,601$ 56,823$ 28,435$ 28,059$ 44,132$ 33,177$ 57,144$ 78,597$ 49,830$ 64,496 69,086 88,027 65,502 53,260 88,027 65.3%27.4% February $112,120 $74,250 $65,590 $45,612 10,730$ 22,594$ 66,268$ 30,745$ 18,846$ 26,888$ 48,279$ 51,148$ 47,854$ 65,067$ 51,891 84,560 103,671 62,343 50,691 103,671 104.5%22.6% March $92,812 $82,868 $58,766 $63,286 66,768$ 44,044$ 34,138$ 39,257$ 42,889$ 40,689$ 168,735$ 79,657$ 91,388$ 75,558$ 82,105 93,964 120,812 85,754 69,726 120,812 73.3%28.6% April $105,772 $83,776 $95,258 $105,272 20,838$ 54,965$ 21,847$ 35,754$ 60,839$ 55,546$ 61,766$ 77,161$ 78,523$ 102,480$ 89,657 78,860 138,647 87,380 71,048 138,647 95.1%75.8% May $124,210 $125,632 $86,666 $49,638 34,242$ 36,932$ 27,146$ 59,286$ 50,555$ 62,184$ 73,099$ 108,945$ 111,101$ 128,185$ 111,001 75,991 174,853 106,569 86,652 174,853 101.8%130.1% June $164,122 $137,630 $89,338 $54,812 30,788$ 35,648$ 37,194$ 44,068$ 63,205$ 71,373$ 118,836$ 241,046$ 147,551$ 147,514$ 104,991 205,638 192,025 151,424 123,122 192,025 56.0%-6.6% July $132,668 $117,584 $108,226 $57,890 43,154$ 34,393$ 36,658$ 28,856$ 57,623$ 67,722$ 110,603$ 105,451$ 105,582$ 108,763$ 136,683 160,738 194,625 127,942 104,029 194,625 87.1%21.1% August $133,848 $355,084 $92,362 $58,240 46,658$ 31,371$ 30,855$ 43,974$ 71,327$ 55,685$ 92,001$ 125,719$ 110,037$ 131,097$ 130,942 162,691 133,692 108,705 September $147,903 $104,040 $67,136 $39,174 47,520$ 46,444$ 37,641$ 54,626$ 67,050$ 71,552$ 219,697$ 95,883$ 181,336$ 117,652$ 105,075 211,718 153,945 125,173 October $203,764 $89,674 $100,551 $46,562 31,806$ 31,382$ 34,231$ 66,934$ 57,808$ 65,594$ 102,267$ 137,192$ 113,373$ 119,144$ 134,016 291,638 164,543 133,790 November $126,964 $99,990 $52,266 $22,654 54,154$ 31,746$ 33,220$ 67,226$ 127,615$ 41,510$ 66,034$ 75,151$ 119,897$ 96,368$ 110,009 127,705 113,495 92,282 December $97,838 $113,314 $46,605 $37,906 49,676$ 27,938$ 27,429$ 49,960$ 62,067$ 101,510$ 102,439$ 83,276$ 100,034$ 74,910$ 125,158 150,137 112,560 91,522 Total $1,520,315 $1,467,226 $935,188 $626,576 $559,398 $426,058 $443,450 $549,121 $707,883 $704,385 $1,196,934 $1,237,774 $1,285,270 $1,216,569 $1,246,024 $1,712,725 $1,012,661 1,365,147$ 1,110,000$ 1,012,661$ -8.8%37.5% YTD 809,998 705,124 576,268 422,040 329,584 257,177 280,074 266,401 322,016 368,534 614,496 720,552 660,594 677,397 640,824 768,836 1,012,661 686,913$ 558,528$ 1,012,661$ 81.3%20.0% YTD change -12.95%-18.27%-26.76%-21.91%-21.97%19.22%-4.88%20.88%14.45%66.74%17.26%-8.32%2.54%-5.40%19.98%31.71% Annual % chg -12.95%-18.27%-26.76%-21.91%-21.97%4.08%23.83%28.91%-0.49%69.93%3.41%3.84%-5.35%2.42%37.46% Actual Full Year or Budge $1,520,315 $1,467,226 $935,188 $626,576 $559,398 $426,058 $443,450 $549,121 $707,883 $704,385 $1,196,934 $1,237,774 $1,285,270 $1,216,569 $1,246,024 $1,712,725 $1,110,000 Total Sales Value for year incl City of PT 219,533,884 237,164,120 348,155,918 395,379,956 404,420,675 365,442,489 369,816,284 451,371,978 Jan 2019 7 sales>$500k Jul 2019 1@$3.3M, 16>$500k Jan 2020 9 sales>$500k July 2020 2 sales over $1M: $1.25M & $1.025M; and 16 sales>$500k Jan 2021 10 sales>$500k,1@$1.7M July 2021 28 sales >$500 with 6 sales >$1 million Feb 2019 1@$1M, 4 sales>$500k Aug 2019 2@$1.25M &1.2M, 12>$500k Feb 2020 1@1.2M & 6 sales>$500k Aug 2020 1 sales @$1.25M and 23 sales>$500k Feb 2021 13 sales>$500k,1@$2.05M,1@$1.25M Mar 2019 1@$1.4M, 6 sales>$500k Sep 2019 1@$1.25M & 1.425M, 11>$500k Mar 2020 1@1.025M & 10 sales>$500k Sep 2020 2@$2.1M and $1.253M; 29 sales>$500k Mar 2021 15 sales>$500k,2@$1.23 and $1.25M Apr 2019 9 sales>$500k Oct 2019 2@$1.475M and 1.5M, 6>$500k Apr 2020 8 sales>$500k Oct 2020 6>$1M (3.15, 2.7, 2.5, 1.7, 1.26, 1.08M); 33 sales>$500k Apr 2021 19 sales>$500k,2@$1.3 and 1@$1.2M May 2019 1@1.045M, 9 sales>$500k Nov 2019 2@$1.75M & 1.1M, 12>$500k May 2020 1@$1.3M and 6>$500k Nov 2020 1@$1.15M; 15 sales>$500k.May 2021 27 sales>$500k,1@$1.5 and 1@$1.225M Jun 2019 1@$2.36M & 1@ $1.275M, 7>$500k Dec 2019 1@$2.61, 4@$1+,10>$500k June 2020 3@ $9.9M, $1.07M & $1.375M;19 Dec 2020 2@$1.96M & $1.1M; 13 sales>$500k.June 2021 28 sales>$500k, 5@$1.0, 1.19, 1.35, 1.51 & 1.87 million 8/23/2021 $0 $200,000 $400,000 $600,000 $800,000 $1,000,000 $1,200,000 $1,400,000 $1,600,000 $1,800,000 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 Real Estate Excise Tax Collections -2005 to 2021 Fund 302 Capital Improvement Fund December November October September August July June May April March February January Actual Full Year or Budget 0 200,000 400,000 600,000 800,000 1,000,000 1,200,000 1,400,000 1,600,000 REET 2021 YTD Actual Total & Budget YTD Actual YTD Budget Projected Over/Under Budget 0 50,000 100,000 150,000 200,000 250,000 2021 Monthly Actual Revenue & Budgeted Share 2021 Actual Budget July July 2021 8/23/2021 4 yr avg *2021 2021 % Budget % Diff 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2017-20 Budget Actual Difference Prior Year 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 26,112 26,445 38,926 47.2%21.6% 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,649 44,205 45,296 2.5%32.9% 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 22,802 23,093 46,465 101.2%56.9% 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 24,154 24,462 43,464 77.7%49.2% 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 35,019 35,465 66,011 86.1%472.7% June 19,205 17,302 17,916 16,477 18,786 25,070 29,476 31,485 36,556 43,299 742 69,468 28,021 28,378 69,468 144.8%9263.8% 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 38,917 39,413 70,768 79.6%194.0% August 35,178 24,742 31,171 33,140 37,534 48,845 56,349 64,820 64,934 70,516 41,591 60,466 61,236 September 41,757 42,500 40,882 39,890 42,349 44,713 53,487 56,561 68,870 88,306 79,681 73,354 74,289 October 43,012 43,861 41,015 41,741 43,659 49,182 59,970 58,458 65,200 60,682 78,504 65,711 66,548 November 44,351 38,547 36,906 39,146 46,879 58,967 57,999 69,054 63,101 65,013 75,302 68,117 68,985 December 19,873 21,703 11,109 15,514 33,858 25,213 26,084 32,870 46,067 42,545 54,544 44,007 44,567 Full Year 321,231 293,344 273,796 295,200 335,825 386,107 449,148 507,868 542,805 579,805 490,842 380,398 530,330 537,087 380,398 YTD 137,060 121,991 112,713 125,769 131,546 159,187 195,259 226,104 234,632 252,743 161,219 380,398 218,675 221,461 380,398 71.8%136.0% 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 537,087 YTD Change 13.20%-7.61%11.58%4.59%21.01%22.66%15.80%3.77%7.72%-36.21%135.95% Annual % Change 0.24%-6.66%7.82%13.76%14.97%16.33%13.07%6.88%6.82%-15.34%$537,087 2021 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 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 December November October September August July June May April March February January 2021 HOTEL/MOTEL LODGING TAX -Fund 125 Includes Investment Interest 0 100,000 200,000 300,000 400,000 500,000 600,000 2021 YTD Actual and Budget YTD Actual YTD Budget Projected Over/Under Budget 0 10,000 20,000 30,000 40,000 50,000 60,000 70,000 80,000 2021 Monthly Actual and Budget 2021 Actual Budget July