Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2021-09_Sept_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 September 2021 Revenue Report • General Fund at $16,492,152 – 75.3% 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. • Other Funds at $29,622,872– 73.4% of 2021 budget year to date which is a lot higher than previous years. • General Fund Cash Balance - $7.8 million at the end of September which includes the 3.7 million reserve. • General Sales Tax Receipts - $508,542 which includes $112,903 for Special Purpose in September 2021. Cumulatively, this is 23% over budget year to date. If it holds we’re forecasted for about $1.25 million over budget for the year. • Sales Tax by Sector: Sales tax composition by category reflects funds receipted in July for September distribution for all of Jefferson County including the City of Port Townsend. • REET Receipts - Fund 302 - $192,392 in September which is 53% over budget for the month and 9% less than what it was this month last year. We had a total of 31 sales over $500,000 with five properties selling in unincorporated Jefferson County for over $1 million ranging from $1 million to $1.675 million. If it holds, the projection is to come in $1.5 million over the original 2021 budget. • Hotel/Motel Lodging Tax – Fund 125 - $90,656 in September. This puts it 22% over budget for the month. Year to date, revenue is 97% over budget. The calculated projection is to end the year $300,000 over budget, but I think it will be more like $200,000 over budget since the amount over budget is getting closer to the monthly projection each month (compare June at 144% over budget compared to 22% over this month. 2021 9 September Jefferson County Treasurer 15-Oct-2021 Jefferson County Treasurer REVENUE NAME BARS BUDGET AMENDED SEP Y-T-D Y-T-D Y-T-D BUDGET QTRLY AMENDED ACTUAL SEP Y-T-D Y-T-D ACTUAL SEP Y-T-D Y-T-D *2021 ANNUAL & QTRLY Approp Budget 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 149,524 5,087,659 60.5%(3,317,512)8,290,037 268,714 8,558,751 8,148,279 158,949 4,960,167 60.9%7,992,860 147,719 4,806,692 60.1%Diverted Road Prop Tax 1 311.20 720,000 0 720,000 12,975 443,586 61.6%(276,414)720,000 720,000 720,000 14,440 441,494 61.3%720,000 13,044 435,008 60.4%Sales Tax 1 313.11 3,453,021 270,910 3,723,931 395,639 3,290,843 88.4%(433,088)3,326,609 3,326,609 3,772,767 372,118 2,715,110 72.0%3,601,761 319,609 2,565,970 71.2% special purpose 313.15 1,084,963 (64,180)1,020,783 112,903 910,079 89.2%(110,704)1,045,244 1,045,244 1,020,826 96,212 749,484 73.4%1,064,119 94,733 768,075 72.2%Local Criminal Justice 1 313.71 438,710 (3,314)435,396 47,419 380,114 87.3%(55,282)422,650 422,650 427,244 41,292 313,510 73.4%442,239 39,394 319,136 72.2%Leasehold Excise Tax 3 317.20 66,801 12,297 79,098 1,043 64,597 81.7%(14,501)66,801 66,801 79,122 - 59,895 75.7%75,500 - 56,297 74.6% Private Harvest Tax - TAV 2 317.40.10/.20 339,599 0 339,599 - 184,561 54.3%(155,038)339,599 339,599 281,066 - 209,039 74.4%363,246 - 349,118 96.1%P.I.L.T. (incl DNR)4 332.15.23/336.02.31 1,035,150 623,245 1,658,395 - 1,643,245 99.1%(15,150)1,015,150 1,015,150 1,588,729 - 1,572,825 99.0%1,553,455 - 1,537,328 99.0% P.U.D. Privilege Tax 4 335.00.91 398,151 11,789 409,940 - 398,969 97.3%(10,971)386,555 386,555 398,063 - 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 - 420,091 91.3%(39,909)451,770 451,770 522,693 - 385,846 73.8%336,086 - 333,709 99.3% Marijuana Excise 6 336.06.41/42 54,124 (3,604)50,520 14,442 36,495 72.2%(14,025)52,548 52,548 46,636 11,088 35,549 76.2%170,903 12,294 36,518 21.4% Liquor Excise Tax 8 336.06.94 49,233 9,464 58,697 - 50,907 86.7%(7,791)48,267 48,267 61,396 - 43,836 71.4%51,439 - 37,729 73.3%Liquor Profit 6 336.06.95 92,463 (7,294)85,169 20,640 62,292 73.1%(22,877)90,650 90,650 83,340 20,826 62,513 75.0%83,623 20,844 62,779 75.1%Treasurer Invest & Other Fees 1 341.42.15-20/50 35,830 (11,213)24,617 579 12,139 49.3%(12,478)35,830 35,830 32,773 626 19,787 60.4%43,596 2,378 28,039 64.3% Treas. Collection Fees (REET)3 341.42.31/32/33 87,175 (11,870)75,305 12,531 94,162 125.0%18,857 87,175 87,175 92,802 14,721 63,131 68.0%85,234 6,757 62,009 72.8%Penalties on delinquent taxes 1 359.40.10/.20 122,152 6,119 128,271 4,006 91,259 71.1%(37,012)119,757 119,757 128,759 5,543 97,505 75.7%113,976 3,496 84,739 74.3%Investment Income 1 361.11 727,260 (305,372)421,888 - 226,302 53.6%(195,586)713,000 713,000 380,191 3,340 348,616 91.7%1,028,831 59,096 896,183 87.1% Interest on delinquent taxes 1 361.40.10 196,162 30,454 226,616 245,525 433,573 191.3%206,957 192,316 192,316 244,045 9,851 185,818 76.1%224,004 6,741 163,388 72.9%Interfund Chg Svc-Cost Alloc 3 362.50.00.180/0671 349,707 (98,445)251,262 7,078 38,900 15.5%(212,362)339,521 339,521 243,461 - 29,207 12.0%232,066 - 28,985 12.5%DNR Timber & DNRTimbTrust 2 1 395.1.1/335.02.33 250,000 0 250,000 - 24,591 9.8%(225,409)250,000 250,000 525,780 42,702 256,790 48.8%352,075 - 330,417 93.8% Transfer in 1 397.00 3,000 7,000 10,000 59,825 90,597 906.0%80,597 3,000 24,074 27,074 36,847 - 26,322 71.4%21,798 - 21,048 96.6%Miscellaneous *10.30/362.50.1/369.81/369.9 27,784 (10,919)16,865 770 132,567 786.0%115,702 27,784 27,784 62,869 732 9,835 15.6%111,997 1,184 12,687 11.3%Assessor 1 001-010-000 8,300 0 8,300 2 5,531 66.6%(2,769)8,300 8,300 7,943 - 5,729 72.1%9,642 115 5,847 60.6%Auditor-Recording Fees 1 341.21.10 69,495 0 69,495 16,338 91,173 131.2%21,678 69,495 69,495 95,307 8,809 66,850 70.1%69,039 5,893 48,205 69.8%Auditor-M.V. License Fees 1 341.48+/336.00.93 246,440 16,370 262,810 8,695 256,716 97.7%(6,094)246,440 16,370 262,810 322,944 17,698 238,466 73.8%302,603 15,629 226,144 74.7% Auditor-Other Revenue 1 35,330 0 35,330 1,977 60,237 170.5%24,907 35,330 5,696 41,026 29,104 2,542 18,144 62.3%35,127 2,959 26,892 76.6%Elections 1 001-021-000 161,195 73,000 234,195 36,897 92,457 39.5%(141,738)116,110 116,110 326,422 - 309,648 94.9%161,606 1 103,964 64.3%Clerk 1 001-050-000 141,663 (17,798)123,865 8,545 92,060 74.3%(31,805)149,591 149,591 144,678 18,982 108,371 74.9%149,436 17,750 118,249 79.1% County Administrator 1 001-059-000 3,700 300 4,000 - 4,000 100.0%0 438,600 438,600 4,000 - 4,000 100.0%4,260 - 4,260 100.0%Commissioners 1 001-060-000 8,000 0 8,000 923 8,678 108.5%678 8,000 8,000 10,230 1,014 7,216 70.5%7,843 666 5,582 71.2%Safety & Security/Emergency Mg 1 001-067-000 75,538 22,811 98,349 122,377 171,869 174.8%73,520 75,538 75,538 67,399 - 67,399 100.0%36,232 - 28,578 78.9% Community Services 1 001-068-000 4,172 0 4,172 29 3,068 73.5%(1,104)4,155 4,155 3,867 46 2,996 77.5%3,987 17 3,084 77.4%District Court 1 001-080-000 655,380 (17,300)638,080 32,720 343,373 53.8%(294,707)644,505 644,505 579,650 33,000 349,798 60.3%682,644 84,156 485,285 71.1%Juvenile Service 1 001-110-000 278,783 3,147 281,930 14,780 216,260 76.7%(65,670)279,284 279,284 314,628 30,003 249,155 79.2%243,744 7,574 173,448 71.2% Prosecuting Attorney 1 001-150-000 236,251 0 236,251 8,320 188,496.90 79.8%(47,754)320,633 88,000 408,633 237,412 31,559 132,589 55.8%257,902 7,958 172,746 67.0%Coroner 1 001-151-000 25,348 0 25,348 - 15,255 60.2%(10,093)25,348 25,348 13,958 - 13,958 100.0%18,324 - 18,324 100.0% Sheriff 1 001-180-000 577,054 344,609 921,663 150,110 678,453 73.6%(243,210)794,303 263,000 1,057,303 942,051 86,682 624,771 66.3%1,141,545 125,111 801,488 70.2% Superior Court 1 001-240-000 59,547 0 59,547 220 17,443 29.3%(42,104)59,421 59,421 41,617 220 7,958 19.1%50,414 620 8,560 17.0% Non Departmental 1 001-261/270-000 36,990 0 36,990 795 129,554 350.2%92,564 35,568 2,448,500 2,484,068 2,627,644 23,517 85,617 3.3%39,722 30 35,882 90.3% TOTAL CURRENT EXPENSE REVENUE 21,158,533 741,315 21,899,848 1,487,627 16,492,152 75.3%(5,407,696)21,334,884 3,114,354 24,449,238 24,666,543 1,046,514 15,277,007 61.9%22,268,272 995,766 15,587,785 70.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 (9,607)7,556 0 52,695 9,233 36,879 34 29,806 *July 2021 LE & CJ One Time Cost 125,339 September2021 GENERAL FUND REVENUE 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021Property Tax 4,112,969 4,245,893 4,179,043 4,337,921 4,359,584 4,417,193 4,494,533 4,563,803 4,660,319 4,806,692 4,960,167 5,087,659Diverted Road Prop Tax 424,863 430,238 432,129 439,360 435,714 443,460 433,795 433,121 430,671 435,008 441,494 443,586Sales Tax 1,405,880 1,458,975 1,460,127 1,744,159 1,665,498 1,810,743 1,975,327 2,109,343 2,296,483 2,565,970 2,715,110 3,290,843 special purpose 0 216,742 450,086 522,663 507,308 554,926 638,413 659,790 723,021 768,075 749,484 910,079Local Criminal Justice 189,065 197,222 189,125 218,109 211,597 230,104 265,166 273,880 302,199 319,136 313,510 380,114Leasehold Excise Tax 38,163 42,042 40,542 44,375 48,417 44,462 44,666 50,748 48,627 56,297 59,895 64,597Private Harvest Tax 90,580 218,466 254,250 324,269 358,822 366,366 252,332 311,003 379,277 349,118 209,039 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,643,245P.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 12,784 31,244 16,324 51,775 36,518 35,549 36,495Liquor 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 53,347 50,328 74,510 63,603 63,645 63,801 63,594 63,375 63,098 62,779 62,513 62,292Treasurer Invest & Other Fees 5,027 4,178 3,334 2,997 1,928 2,957 8,119 26,369 35,510 28,039 19,787 12,139Treas. Collection Fees (REET)20,711 20,982 23,938 29,611 32,384 55,621 64,152 66,655 63,295 62,009 63,131 94,162Penalties on delinquent taxes 57,653 102,190 82,676 84,785 98,418 79,968 81,625 69,113 76,610 84,739 97,505 91,259Investment Income 153,172 95,139 41,562 12,073 20,930 49,142 641,605 317,048 386,758 896,183 348,616 226,302Interest on delinquent taxes 99,759 163,388 150,884 150,691 173,645 153,357 157,887 138,025 151,515 163,388 185,818 433,573Interfund Chg Svc-Cost Alloc 248,999 0 0 39,051 0 26,255 26,537 30,577 206,731 28,985 29,207 38,900DNR Timber 71,208 554,407 220,747 69,974 254,282 415,464 296,001 94,176 160,930 330,417 256,790 24,591Transfer in 0 0 0 0 0 5,000 45,691 38,087 30,177 21,048 26,322 90,597Miscellaneous231,871 155,519 24,222 41,907 25,717 281,276 16,462 5,613 12,925 12,687 9,835 132,567Assessor1,206 960 3,026 240,479 12,743 640 6,160 8,173 5,894 5,847 5,729 5,531Auditor-Recording Fees 48,355 47,399 52,290 58,724 42,015 54,345 53,616 54,610 53,404 48,205 66,850 91,173Auditor-M.V. License Fees 123,462 119,525 121,030 126,126 126,517 124,973 200,163 207,781 201,492 226,144 238,466 256,716Auditor-Other Revenue 25,294 24,884 24,291 25,592 25,436 72,388 23,446 22,392 26,184 26,892 18,144 60,237Elections116,237 83,948 71,369 57,487 76,021 68,673 153,467 114,205 98,536 103,964 309,648 92,457Clerk152,087 154,932 157,782 158,932 157,754 156,069 147,081 134,514 130,070 118,249 108,371 92,060County Administrator 0 0 0 0 0 - - - 4,260 4,260 4,000 4,000Commissioners7,304 5,617 10,716 7,440 5,571 6,555 6,310 6,500 6,526 5,582 7,216 8,678Safety & Security 54,795 28,415 63,022 47,289 28,735 58,473 58,168 55,509 41,545 28,578 67,399 171,869Community Services 0 4,502 943 4,307 3,198 3,361 6,318 3,885 3,273 3,084 2,996 3,068District Court 402,225 480,828 454,674 448,535 437,218 500,392 487,689 466,196 529,017 485,285 349,798 343,373Juvenile Service 188,323 195,703 138,272 221,208 192,088 178,430 183,635 196,071 198,622 173,448 249,155 216,260Prosecuting Attorney 229,663 222,307 152,792 119,476 117,722 180,064 100,109 125,797 76,576 172,746 132,589 188,497Coroner4,640 14,080 6,380 11,032 6,380 11,140 8,340 24,610 32,723 18,324 13,958 15,255Sheriff694,934 758,826 495,025 454,090 354,161 429,046 474,379 440,703 460,772 801,488 624,771 678,453Superior Court 19,976 6,439 3,000 5,344 3,000 4,718 20,732 67,739 37,764 8,560 7,958 17,443Non Departmental 0 0 0 0 0 - 10 10 32,802 35,882 85,617 129,554TOTAL CURRENT EXPENSE 9,998,814 10,877,745 10,335,153 11,706,500 11,759,838 12,858,239 13,605,258 13,260,488 14,601,908 15,587,785 15,277,007 16,492,152TOTAL CURRENT EXPENSE ACTUAL/2020 BUDGET 15198876 16349133 15531592 16964139 17374434.53 18,950,211 19,248,227 19,181,590 20,890,820 22,268,272 24,666,543 21,899,848 YTD % of Full Year Actual/2021 Budget 65.8%66.5%66.5%69.0%67.7%67.9%70.7%69.1%69.9%70.0%61.9%75.3% 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 18,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 65.8%66.5%66.5%69.0%67.7%67.9%70.7%69.1%69.9%70.0% 61.9% 75.3% 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 September2021 September OTHER FUNDS REVENUE REPORT 2021 3 year view September 9 10/18/2021 FUND Fund #Orig Budget Budget Amended BDGT Sep YTD YTD Orig Budget Budget Amended BDGT Sep YTD YTD ACTUAL Amended BDGT Sep 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 - - - 5.64 n/a - 153,422 153,422 23 153,485 n/a HAVA 3 Grant 104 - - 8 97.43 n/a - 123,419 123,419 29 123,457 n/a Auditor's O & M 105 77,900 77,900 3,251 105,216.77 135.1%77,900 566 78,466 3,515 76,946 98.1%72,512 80,480 2,346 64,426 88.8%80.1% Court Facilitator 106 4,000 (1,280) 2,720 240 2,520.00 92.6%4,500 4,500 440 2,280 50.7%4,300 4,100 180 3,400 79.1%82.9% Boating Safety 107 50,000 (5,500) 44,500 - 33,553.03 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 - 252,624.92 59.2%532,762 (53,107) 479,655 1,511 359,938 75.0%352,814 468,922 853 289,629 82.1%61.8% Noxious Weed 109 203,717 (5,000) 198,717 46,227 187,622.97 94.4%217,717 (23,700) 194,017 2,550 111,855 57.7%198,125 260,816 2,230 112,007 56.5%42.9% 4-H After School 113 Moved to Fund 108 - Moved to Fund 108 - 49,508 47,600 8 62,708 126.7%131.7% JeffComCap 119 119 276,600 276,600 23,050 207,450.00 75.0%206,640 206,640 17,220 154,980 75.0%204,000 204,000 17,000 153,000 75.0%75.0% Crime Victim's Svc 120 81,543 81,543 799 77,066.56 94.5%81,543 81,543 4,346 90,114 110.5%127,920 140,813 2,771 96,699 75.6%68.7% Grant Mgmt 123 150,000 3,261,793 3,411,793 6,056 3,372,964.59 98.9%150,000 251,680 401,680 - 64,749 16.1%119,570 150,000 79,852 66.8%53.2% Hotel-Motel 125 537,087 537,087 90,666 579,182.58 107.8%521,444 521,444 79,681 281,430 54.0%579,805 500,500 88,306 411,565 71.0%82.2% Jeff Co Public Health 127 4,820,115 79,415 4,899,530 348,836 4,569,971.82 93.3%4,994,011 697,569 5,691,580 292,830 3,922,943 68.9%4,758,462 4,651,629 176,219 3,494,554 73.4%75.1% Water Quality 128 1,365,704 (2,227) 1,363,477 165,217 1,126,475.19 82.6%1,307,279 1,307,279 70,848 797,804 61.0%1,025,077 1,163,949 97,292 751,401 73.3%64.6% 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 160,179 160,179 100.0%58.2% Mental Health 130 51,732 51,732 866 30,835.45 59.6%50,289 50,289 1,133 31,388 62.4%50,299 47,637 851 31,585 62.8%66.3% Chem Dep Mnt Hlth tx 131 561,734 (26,465) 535,269 64,896 520,616.08 97.3%553,433 553,433 56,498 429,696 77.6%612,026 527,003 53,953 443,429 72.5%84.1% JC Inmate Commissary 134 41,500 (2,500) 39,000 1,184 10,749.99 Drug Fund 135 14,240 14,240 93 978.95 6.9%13,850 13,850 146 5,523 39.9%5,982 12,249 415 5,091 85.1%41.6% Law Library 140 11,591 4,827 16,418 640 10,925.89 66.5%16,081 16,081 670 10,586 65.8%9,149 10,927 722 6,701 73.2%61.3% Trial Court Imprvmnt 141 23,690 23,690 - 21,237.00 89.6%23,000 23,000 - 21,252 92.4%22,806 23,000 - 17,103 75.0%74.4% Community Develpmnt 143 1,505,632 479,114 1,984,746 100,403 1,760,304.18 88.7%1,657,637 155,230 1,812,867 115,636 1,238,050 68.3%1,635,441 1,812,850 84,932 1,227,522 75.1%67.7% Federal Forest Title III 147 21,000 21,000 11 16,004.82 21,000 21,000 28 17,933 21,440 - 217 20,872 97.4% Jeff Co Affrdbl Hsg 148 45,582 520,048 565,630 77,499 359,848.84 63.6%45,131 103,780 148,911 12,465 75,595 50.8%50,363 48,000 4,217 35,856 71.2%74.7% Homeless Housing Fund 149 275,603 145,000 420,603 42,452 396,827.11 94.3%272,874 187,319 460,193 37,165 268,700 58.4%304,747 587,282 25,284 216,331 71.0%36.8% Treasurer's O & M 150 55,750 (1,000) 54,750 3 14,118.49 25.8%54,650 54,650 7 14,239 26.1%49,566 47,624 105 22,871 46.1%48.0% REET technology 151 13,401 13,401 1,642 13,756.27 102.7%13,816 13,816 1,375 10,664 77.2%15,250 15,690 1,373 11,303 74.1%72.0% Veteran's Relief 155 66,050 66,050 886 51,165.45 77.5%65,510 65,510 1,167 50,259 76.7%95,103 89,990 999 50,779 53.4%56.4% Water Pollution Cntrl 160 - - - - 36,278.64 - - - - - Park & Rec 174 698,883 (37,881) 661,002 1,575 575,695.50 87.1%684,549 (9,023) 675,526 1,465 427,744 63.3%665,738 669,649 14,646 484,984 72.8%72.4% County Park Imprvmnt 175 208,500 (47,000) 161,500 8,053 105,126.58 65.1%171,625 31,360 202,985 10,076 90,141 44.4%185,875 160,125 5,848 156,656 84.3%97.8% Post Harvest Timber Mgm 178 8,375 8,375 8 14.45 - - 2 65 209 50 17 164 78.4%327.1% County Roads 180 8,985,491 (146,585) 8,838,906 293,330 5,474,176.66 61.9%8,801,630 409,379 9,211,009 317,883 5,576,651 60.5%8,166,809 8,931,921 253,625 5,980,271 73.2%67.0% Facilities Mgmt to 507 183 1,209,958 47,285 1,257,243 - 0.0%1,169,335 1,169,335 99,314 919,668 78.6%1,111,711 1,065,393 88,783 837,403 75.3%78.6% Total Special Revenue 21,876,781 4,372,531 26,249,312 1,277,882 19,913,309 75.9%21,873,206 1,916,439 23,789,645 1,127,971 15,081,577 63.4%21,003,015 22,327,852 1,083,371 15,278,479 75.3%68.4% CAPITAL IMPROVEMENT Const/Renovation 301 415,233 415,233 - 285,853 68.8%363,826 363,826 - 58,625 16.1%773,299 518,500 11,368 260,995 33.8%50.3% Capital Improvement 302 1,155,500 1,155,500 237,892 1,555,976 134.7%1,156,313 1,000,000 2,156,313 258,031 2,189,558 101.5%1,246,025 1,072,125 105,075 876,842 70.4%81.8% HJC Park Jump 304 - 57,630 57,630 - 57,630 100.0% Public Infrastructure 306 567,500 567,500 59,088 473,251 83.4%565,000 565,000 55,739 399,720 70.7%572,302 510,100 50,941 414,587 72.4%81.3% Conservation Futures 308 274,280 (5,980) 268,300 4,634 163,314 60.9%271,860 271,860 6,158 170,277 62.6%280,835 258,841 5,818 178,261 63.5%68.9% Total CAP IMP 2,412,513 51,650 2,464,163 301,613 2,536,025 102.9%2,356,999 1,000,000 3,356,999 319,928 2,818,180 83.9%2,872,460 2,359,566 173,202 1,730,685 72.4%73.3% 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 Sep YTD YTD Orig Budget Amended BDGT Sep YTD YTD YTD Amended BDGT Sep YTD YTD ENTERPRISE Solid Waste 401 3,670,759 3,670,759 210,802 2,959,516 80.6%3,718,073 3,718,073 362,575 2,902,161 78.1%3,866,094 3,636,313 345,323 2,935,391 75.9%80.7% Solid Waste Post Clos 402 38,686 38,686 3 31 - - 7 255 1,094 - 87 876 80.1% Solid Waste Eqpt Res 403 936,055 936,055 64 711 0.1%15,000 15,000 144 5,046 33.6%19,648 8,000 1,543 15,582 79.3%194.8% Yard Waste Educ Fnd 404 10,915 10,915 0 4 0.0%7,000 7,000 1 23 0.3%209 6,800 18 167 80.1%2.5% Tri Area Sewer 405 1,064,500 381,192 1,445,692 25 605,304 41.9%982,500 23,087 1,005,587 121 153,581 15.3%303,778 303,632 1,251 200,776 66.1%66.1% Total ENTERPRISE 5,720,915 381,192 6,102,107 210,894 3,565,566 58.4%4,722,573 23,087 4,745,660 362,849 3,061,066 64.5%4,190,823 3,954,745 348,222 3,152,793 80.1%79.7% INTERNAL SERVICE Equipment Rental 501 2,681,971 167,202 2,849,173 197,264 1,681,905 59.0%2,617,745 18,883 2,636,628 206,467 1,817,003 68.9%2,915,525 3,139,487 175,636 2,089,850 71.7%66.6% Risk Management 502 150,000 150,000 - - 0.0%150,000 150,000 44,549 45,079 30.1%38,522 215,000 - 0 0.0%0.0% Benefit Reserve 505 275,000 275,000 20,302 216,656 78.8%275,000 275,000 17,566 268,331 97.6%257,890 208,000 18,628 213,941 83.0%102.9% Information Services 506 1,954,417 333,056 2,287,473 925 1,709,411 74.7%1,968,639 1,335,533 3,304,172 41,178 1,572,980 47.6%2,116,237 2,197,065 6,092 1,373,585 64.9%62.5% Facilities Mgmt eff 6/21 507 1,209,958 47,285 1,257,243 97,613 963,757 76.7%Facilities Mgmt eff 6/1/2021 Total INT SERV 5,061,388 500,258 5,561,646 218,490 3,607,973 64.9%5,011,384 1,354,416 6,365,800 309,761 3,703,393 58.2%5,328,174 5,759,552 200,355 3,677,376 64.9%63.8% Total 35,071,597 5,305,631 40,377,228 2,008,879 29,622,872 73.4%33,964,162 4,293,942 38,258,104 2,120,508 24,664,216 64.5%33,394,473 34,401,715 1,805,150 23,839,332 69.0%69.3% GENERAL FUND CASH BALANCE REPORT September 10/18/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$ 8,374,952$ 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$ 7,807,276$ 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,709,786 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$ 4,097,490$ 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 2008 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021Budg Reserve and Cash Balance Composition 15% GF Budgeted Expenditures *Revenue Stabilization Non-Reserve Cash Balance September 9 September 10/18/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.15 Revenue Cumulative Cumulative 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 441,657 9.6%356,971 441,657 $84,686 129.41%$4,819,277 1,095,346$ 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 9.5%352,134 395,639 $43,504 125.17%$4,661,168 937,237$ 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 96.76% 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 70.56% 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 47.48% 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 3,290,843 100.0%$3,723,931 $3,290,843ytd 1,660,610 1,820,471 1,778,679 1,760,299 1,599,081 1,405,881 1,458,975 1,460,127 1,744,091 1,665,497 1,810,743 1,975,327 2,109,343 2,296,483 2,565,970 2,715,110 3,290,843 2,669,715 3,290,843 621,128 ytd change 9.63%-2.30%-1.03%-9.16%-12.08%3.78%0.08%19.45%-4.51%8.72%9.09%6.78%8.87%11.73%5.81%21.20%23.27%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 123,789 9.7%99,015 123,789 $24,774 125.02%$1,276,183 255,400$ September 55,746 54,902 61,455 64,622 72,022 77,854 77,534 97,036 94,733 96,212 112,903 9.3%95,292 112,903 $17,612 118.48%$1,209,445 188,662$ 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 910,079 100.0%1,020,783 910,079 ytd 216,742 450,087 522,961 507,307 554,926 638,413 659,790 723,021 768,095 749,484 910,079 741,404 $910,079ytd change 16.19%-2.99%9.39%15.04%3.35%9.58%6.23%-2.42%21.43%22.75%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,660,610 1,820,471 1,778,679 1,760,299 1,599,081 1,405,881 1,458,975 1,460,127 1,744,091 1,665,497 1,810,743 1,975,327 2,109,343 2,296,483 2,565,970 2,715,110 3,290,843 2,669,715 3,290,843 621,128 4,661,168 937,237$ Special Purpose - - - - - - 216,742 450,087 522,961 507,307 554,926 638,413 659,790 723,021 768,095 749,484 910,079 741,404 910,079 - $1,209,445 188,662 G&O and SP Sal 1,660,610 1,820,471 1,778,679 1,760,299 1,599,081 1,405,881 1,675,717 1,910,214 2,267,052 2,172,805 2,365,669 2,613,741 2,769,133 3,019,504 3,334,065 3,464,594 4,200,923 3,411,120 4,200,923 621,128 5,870,614 1,125,900 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 September 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 September CATEGORY ANALYSIS BY CODE Report R03.4 1600, 1650, 1603, 1604 Jefferson County Run Date: 10/18/2021 Sales Tax Current Period: 202107 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 22,871 13,522 69.1 141,668 108,677 30.4 197,022 11 Agriculture, Forestry, Fishing and Hunting 425 140 203.1 4,098 3,968 3.3 5,036 21 Mining, Quarrying, and Oil and Gas Extraction 725 -113 -739.3 12,926 5,090 154.0 20,067 22 Utilities 69 40 73.6 1,359 998 36.1 2,238 23 Construction 86,498 97,069 -10.9 772,909 741,412 4.2 1,066,051 31 Manufacturing 3,441 1,387 148.1 19,263 16,704 15.3 24,605 32 Manufacturing 2,038 2,145 -5.0 17,451 12,659 37.8 12,288 33 Manufacturing 1,559 2,142 -27.2 30,086 31,597 -4.8 35,808 42 Wholesale Trade 18,012 14,214 26.7 152,899 134,765 13.5 202,959 44 Retail Trade 67,179 82,413 -18.5 529,201 428,763 23.4 701,309 45 Retail Trade 58,974 48,446 21.7 532,788 412,467 29.2 686,601 48 Transportation and Warehousing 453 577 -21.4 6,947 5,235 32.7 8,644 49 Transportation and Warehousing 10 58 -83.4 298 305 -2.0 358 51 Information 9,310 10,988 -15.3 105,490 95,722 10.2 136,954 52 Finance and Insurance 453 1,034 -56.1 10,615 8,549 24.2 14,732 53 Real Estate and Rental and Leasing 5,813 5,362 8.4 53,637 43,882 22.2 69,808 54 Professional, Scientific, and Technical Services 4,552 2,790 63.1 62,511 35,226 77.5 71,818 55 Management of Companies and Enterprises 227 0 54.0 4,645 66 6.0 4,693 56 Administrative and Support and Waste Management an 22,319 21,825 2.3 212,680 162,771 30.7 280,775 61 Educational Services 216 134 60.7 2,491 1,524 63.4 3,902 62 Health Care and Social Assistance 100 163 -38.5 1,688 1,284 31.5 2,190 71 Arts, Entertainment, and Recreation 4,395 3,619 21.4 17,984 12,512 43.7 25,857 72 Accommodation and Food Services 33,948 24,714 37.4 191,872 127,142 50.9 265,612 81 Other Services (except Public Administration)7,034 5,071 38.7 58,809 40,815 44.1 73,842 92 Public Administration 344 379 -9.2 8,792 4,291 104.9 9,764 TOTAL 14,997 Accounts 350,965 338,120 3.8 2,953,107 2,436,424 21.2 3,922,931 NOTE: YTD column includes returns from 202011 to 202107 This report only includes location(s) 1600, 1650, 1603, 16 Last 12 Months by Category 0 250K 500K 750K 1M 1.25M Unknown Mining (except Oil and Gas) Textile Mills Merchant Wholesalers, Durable Goods Support Activities for Transportation Telecommunications Rental and Leasing Services Waste Management and Remediation Services Food Services and Drinking Places 9 2021 September 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 305,424 133,692 108,705 305,424 181.0%87.7% 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 192,392 153,945 125,173 192,392 53.7%-9.1% 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,510,476 1,365,147$ 1,110,000$ 1,510,476$ 36.1%37.5% YTD 1,091,749 1,164,248 735,766 519,454 423,762 334,992 348,570 365,001 460,393 495,771 926,194 942,154 951,966 926,146 876,841 1,143,245 1,510,476 974,550$ 792,406$ 1,510,476$ 90.6%30.4% YTD change 6.64%-36.80%-29.40%-18.42%-20.95%19.22%4.71%26.13%7.68%86.82%1.72%1.04%-2.71%-5.32%30.38%32.12% Annual % chg 6.64%-36.80%-29.40%-18.42%-20.95%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 Aug 2021 45 sales >$500 with 8 sales >$1 million 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 Sep 2021 31 sales >$500 with 5 sales >$1 million 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 10/18/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 300,000 350,000 2021 Monthly Actual Revenue & Budgeted Share 2021 Actual Budget September September 2021 10/18/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 85,104 60,466 61,236 85,104 39.0%104.6% 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 73,354 74,289 90,656 22.0%13.8% 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 556,158 530,330 537,087 556,158 YTD 213,995 189,233 184,766 198,799 211,429 252,746 305,095 347,485 368,436 411,565 282,492 556,158 352,495 356,986 556,158 55.8%96.9% 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%-2.36%7.60%6.35%19.54%20.71%13.89%6.03%11.71%-31.36%96.88% 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 20,000 40,000 60,000 80,000 100,000 2021 Monthly Actual and Budget 2021 Actual Budget September