Loading...
HomeMy WebLinkAbout2021-01_January_RevenueReportsJEFFERSON 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 January 2021 Revenue Report • General Fund at $907,951 – 4.4% of the 2021 budget year to date. The second sheet shows general fund revenue charts showing 2015-2021 year to date detail and percentage of actual full year collections. 2021 is shown as a percentage of our adopted and amended budget. • Other Funds at $2,187,775– 6.1% of 2020 budget year to date which is slightly higher than previous years. • General Fund Cash Balance - $8.1 million at the end of January which includes the $3.3 million budgeted reserve. The reserve equals 15% of the final approved budget expenditures. • General Sales Tax Receipts - $416,647 which includes $89,951 for Special Purpose in January 2021. Cumulatively, this is almost 20% over budget for the month. • Sales Tax by Sector: Sales tax composition by category reflects funds receipted in November for January distribution. The amount collected for General & Optional was 8% more than this period last year for the county and 3% over for the City of Port Townsend. • REET Receipts - Fund 302 - $150,137 in January which is 65% over budget and 27% over what it was this month last year. We had a total of 10 sales over $500,000 with a residence in Quilcene selling for $1.7 million. • Hotel/Motel Lodging Tax – Fund 125 - $38,926 in January. This puts it 47% over budget for the month and 21.6% over what was collected this month last year. 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. 2021 1 January Jefferson County Treasurer 10-Feb-2021 Jefferson County Treasurer REVENUE NAME BARS BUDGET AMENDED JAN Y-T-D Y-T-D BUDGET QTRLY AMENDED ACTUAL JAN Y-T-D Y-T-D ACTUAL JAN Y-T-D Y-T-D *2021 ANNUAL & QTRLY Approp Budget 2021 2021 2021 % of 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 20,844 20,844 0.2%8,290,037 268,714 8,558,751 8,148,279 24,127 24,127 0.3%7,992,860 21,986 21,986 0.3% Diverted Road Prop Tax 1 311.20 720,000 0 720,000 2,102 2,102 0.3%720,000 720,000 720,000 2,607 2,607 0.4%720,000 1,957 1,957 0.3% Sales Tax 1 313.11 3,453,021 270,910 3,723,931 326,695 326,695 8.8%3,326,609 3,326,609 3,772,767 303,235 303,235 8.0%3,601,761 258,313 258,313 7.2% special purpose 313.15 1,084,963 (64,180)1,020,783 89,951 89,951 8.8%1,045,244 1,045,244 1,020,826 84,751 84,751 8.3%1,064,119 79,236 79,236 7.4% Local Criminal Justice 1 313.71 438,710 (3,314)435,396 37,461 37,461 8.6%422,650 422,650 427,244 35,267 35,267 8.3%442,239 32,881 32,881 7.4% Leasehold Excise Tax 3 317.20 66,801 12,297 79,098 0 0 0.0%66,801 66,801 79,122 - 0 0.0%75,500 - 0 0.0% Private Harvest Tax - TAV 2 317.40.10/.20 339,599 0 339,599 0 0 0.0%339,599 339,599 281,066 - 0 0.0%363,246 - 0 0.0% P.I.L.T. (incl DNR)4 332.15.23/336.02.31 1,035,150 0 1,035,150 0 0 0.0%1,015,150 1,015,150 1,588,729 - 0 0.0%1,553,455 - 0 0.0% P.U.D. Privilege Tax 4 335.00.91 398,151 11,789 409,940 0 0 0.0%386,555 386,555 398,063 - 0 0.0%385,397 - 0 0.0% Crim Just Hi Crime/DUI/Asst 5 336.06.10/51 465,324 (5,324)460,000 136,856 136,856 29.8%451,770 451,770 522,693 124,447 124,447 23.8%336,086 104,627 104,627 31.1% Marijuana Excise 6 336.06.41/42 54,124 (3,604)50,520 0 0 0.0%52,548 52,548 46,636 - 0 0.0%170,903 - 0 0.0% Liquor Excise Tax 8 336.06.94 49,233 9,464 58,697 16,178 16,178 27.6%48,267 48,267 61,396 12,459 12,459 20.3%51,439 11,710 11,710 22.8% Liquor Profit 6 336.06.95 92,463 (7,294)85,169 0 0 0.0%90,650 90,650 83,340 - 0 0.0%83,623 - 0 0.0% Treasurer Invest & Other Fees 1 341.42.15-20/50 35,830 (11,213)24,617 749 749 3.0%35,830 35,830 32,773 2,525 2,525 7.7%43,596 2,795 2,795 6.4% Treas. Collection Fees (REET)3 341.42.31/32/33 87,175 (11,870)75,305 5,543 5,543 7.4%87,175 87,175 92,802 4,726 4,726 5.1%85,234 4,238 4,238 5.0% Penalties on delinquent taxes 1 359.40.10/.20 122,152 6,119 128,271 12,700 12,700 9.9%119,757 119,757 128,759 15,516 15,516 12.1%113,976 13,123 13,123 11.5% Investment Income 1 361.11 727,260 (305,372)421,888 16,795 16,795 4.0%713,000 713,000 380,191 66,916 66,916 17.6%1,028,831 71,370 71,370 6.9% Interest on delinquent taxes 1 361.40.10 196,162 30,454 226,616 16,296 16,296 7.2%192,316 192,316 244,045 13,148 13,148 5.4%224,004 10,846 10,846 4.8% Interfund Chg Svc-Cost Alloc 3 362.50.00.180/0671 349,707 (98,445)251,262 9,962 9,962 4.0%339,521 339,521 243,461 0 0.0%232,066 9,575 9,575 4.1% DNR Timber & DNRTimbTrust 2 1 395.1.1/335.02.33 250,000 0 250,000 0 0.0%250,000 250,000 525,780 11,342 11,342 2.2%352,075 115,763 115,763 32.9% Transfer in 1 397.00 3,000 7,000 10,000 0 0 0.0%3,000 24,074 27,074 36,847 0 0.0%21,798 - 0 0.0% Miscellaneous *1 50.1/369.81/369.9 27,784 (10,919)16,865 702 702 4.2%27,784 27,784 62,869 1,081 1,081 1.7%111,997 2,145 2,145 1.9% Assessor 1 001-010-000 8,300 0 8,300 0 0 0.0%8,300 8,300 7,943 106 106 1.3%9,642 24 24 0.2% Auditor-Recording Fees 1 341.21.10 69,495 0 69,495 10,244 10,244 14.7%69,495 69,495 95,307 5,737 5,737 6.0%69,039 4,145 4,145 6.0% Auditor-M.V. License Fees 1341.48+/336.00.93 246,440 16,370 262,810 15,320 15,320 5.8%246,440 16,370 262,810 322,944 16,815 16,815 5.2%302,603 12,158 12,158 4.0% Auditor-Other Revenue 1 35,330 0 35,330 35,860 35,860 101.5%35,330 5,696 41,026 29,104 3,523 3,523 12.1%35,127 4,002 4,002 11.4% Elections 1 001-021-000 161,195 48,000 209,195 24,609 24,609 11.8%116,110 116,110 326,422 64,847 64,847 19.9%161,606 11,169 11,169 6.9% Clerk 1 001-020-000 141,663 (17,798)123,865 10,514 10,514 8.5%149,591 149,591 144,678 12,676 12,676 8.8%149,436 13,776 13,776 9.2% County Administrator 1 001-059-000 3,700 0 3,700 0 0 0.0%438,600 438,600 4,000 - 0 0.0%4,260 - 0 0.0% Commissioners 1 001-060-000 8,000 0 8,000 967 967 12.1%8,000 8,000 10,230 654 654 6.4%7,843 503 503 6.4% Safety & Security 1 001-067-000 75,538 22,811 98,349 0 0 0.0%75,538 75,538 67,399 - 0 0.0%36,232 17,380 17,380 48.0% Community Services 1 001-068-000 4,172 0 4,172 34 34 0.8%4,155 4,155 3,867 11 11 0.3%3,987 993 993 24.9% District Court 1 001-080-000 655,380 (17,300)638,080 42,188 42,188 6.6%644,505 644,505 579,650 38,597 38,597 6.7%682,644 34,180 34,180 5.0% Juvenile Service 1 001-110-000 278,783 3,147 281,930 20,507 20,507 7.3%279,284 279,284 314,628 26,366 26,366 8.4%243,744 14,168 14,168 5.8% Prosecuting Attorney 1 001-150-000 236,251 0 236,251 17,101 17,101 7.2%320,633 88,000 408,633 237,412 - 0 0.0%257,902 7,190 7,190 2.8% Coroner 1 001-151-000 25,348 0 25,348 0 0 0.0%25,348 25,348 13,958 7,958 7,958 57.0%18,324 - 0 0.0% Sheriff 1 001-180-000 577,054 (200,000)377,054 23,596 23,596 6.3%794,303 263,000 1,057,303 942,051 7,160 7,160 0.8%1,141,545 10,446 10,446 0.9% Superior Court 1 001-240-000 59,547 0 59,547 280 280 0.5%59,421 59,421 41,617 220 220 0.5%50,414 - 0 0.0% Non Departmental 1 001-261/270-000 36,990 0 36,990 13,898 13,898 37.6%35,568 2,448,500 2,484,068 2,627,644 36,144 36,144 1.4%39,722 34,152 34,152 86.0% TOTAL CURRENT EXPENSE REVENUE 21,158,533 (451,839)20,706,694 907,951 907,951 4.4%21,334,884 3,114,354 24,449,238 24,666,543 922,963 922,963 3.7%22,268,272 904,852 904,852 4.1% * 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 exclude 388/89 0 5,992 5,992 0 52,695 3,375 3,375 0 0 January2021 GENERAL FUND REVENUE 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021Property Tax 9,000 13,605 15,307 11,633 22,629 22,126 12,049 16,489 20,847 21,986 24,127 20,844Diverted Road Prop Tax 1,050 1,553 1,633 1,318 2,630 11,167 1,318 1,804 1,871 1,957 2,607 2,102Sales Tax 133,849 137,774 137,615 177,776 176,956 163,811 185,292 185,505 207,899 258,313 303,235 326,695 special purpose 0 0 45,217 50,919 50,376 51,210 58,026 61,161 66,993 79,236 84,751 89,951Local Criminal Justice 17,418 19,149 18,952 21,270 21,243 21,127 24,298 25,334 28,043 32,881 35,267 37,461Leasehold Excise Tax 0 0 0 0 0 - - - - - - 0Private Harvest Tax 0 0 0 0 0 - - - - - - 0P.I.L.T. (incl DNR)0 0 0 0 0 - - - - - - 0P.U.D. Privilege Tax 0 0 0 0 0 - - - - - - 0Crim Just Hi Crime/DUI/Asst 85,839 78,990 82,684 80,725 114,893 116,154 128,762 109,769 108,130 104,627 124,447 136,856Marijuana Enforcement/Excise 0 0 0 0 0 - - - - - - 0Liquor Excise Tax 9,000 9,380 9,726 0 5,123 3,637 9,372 10,241 10,819 11,710 12,459 16,178Liquor Profit 0 0 0 0 0 - - - - - - 0Treasurer Invest & Other Fees 486 417 274 378 248 245 496 5,700 2,252 2,795 2,525 749Treas. Collection Fees (REET)1,539 3,119 2,031 2,013 2,568 2,928 4,054 5,197 4,701 4,238 4,726 5,543Penalties on delinquent taxes 6,312 8,222 8,968 7,303 11,960 12,484 5,764 8,220 12,066 13,123 15,516 12,700Investment Income 4,200 2,462 1,855 -732 -1,219 (859) 745 13,370 44,659 71,370 66,916 16,795Interest on delinquent taxes 5,091 8,369 7,328 7,163 10,440 11,380 3,107 8,809 14,270 10,846 13,148 16,296Interfund Chg Svc-Cost Alloc 0 0 0 39,051 0 8,752 - 9,022 186,331 9,575 - 9,962DNR Timber 0 12,650 0 3,337 0 88,158 104,625 - 448 115,763 11,342 0Transfer in 0 0 0 0 0 - - - - - - 0Miscellaneous1,854 1,471 1,446 7,201 4,516 1,615 625 344 884 2,145 1,081 702Assessor0135134169,879 29 155 171 37 24 106 0Auditor-Recording Fees 4,995 6,281 5,581 6,562 4,220 4,545 5,389 6,254 5,740 4,145 5,737 10,244Auditor-M.V. License Fees 9,628 10,026 9,497 10,631 10,932 10,346 10,597 10,842 11,451 12,158 16,815 15,320Auditor-Other Revenue 2,618 1,722 2,074 5,357 6,848 2,533 2,241 2,982 2,781 4,002 3,523 35,860Elections3,603 5,953 2,187 43 5,103 - 32,115 - 34,408 11,169 64,847 24,609Clerk19,946 14,818 14,366 18,762 59,544 14,359 16,029 16,675 20,817 13,776 12,676 10,514County Administrator 0 0 0 0 0 - - - - - - 0Commissioners622815646784568562 603 742 696 503 654 967Safety & Security 0 0 14,460 9,979 0 - 1,450 - 12,345 17,380 - 0Community Services 0 86 23 46 713 1,739 29 23 63 993 11 34District Court 37,033 34,686 32,513 40,966 29,937 35,734 34,114 30,107 33,403 34,180 38,597 42,188Juvenile Service 18,339 37,299 3,826 36,901 15,653 4,057 20,193 14,911 18,261 14,168 26,366 20,507Prosecuting Attorney 11,518 35,161 37,476 25,050 24,224 52,099 6,792 7,241 7,087 7,190 - 17,101Coroner00000- - - - - 7,958 0Sheriff154,376 168,834 18,646 12,213 23,287 5,444 7,170 57,694 59,195 10,446 7,160 23,596Superior Court 0 0 0 0 0 - - - 250 - 220 280Non Departmental 0 0 0 0 0 - 10 10 32,802 34,152 36,144 13,898TOTAL CURRENT EXPENSE 538,316 612,977 474,465 576,665 613,270 645,382 675,417 608,618 949,547 904,852 922,963 907,951TOTAL CURRENT EXPENSE ACTUAL/2020 BUDGET 15198876 16349133 15531592 16964139 17374434.53 18,950,211 19,232,390 19,181,590 20,890,820 22,268,272 24,666,543 20,706,694 YTD % of Full Year Actual/2021 Budget 3.5%3.7%3.1%3.4%3.5%3.4%3.5%3.2%4.5%4.1%3.7%4.4% 0 100,000 200,000 300,000 400,000 500,000 600,000 700,000 800,000 900,000 1,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 3.5%3.7%3.1%3.4%3.5%3.4%3.5%3.2%4.5%4.1%3.7%4.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 January2021 January OTHER FUNDS REVENUE REPORT 2021 3 year view January 1 1/14/2021 FUND Fund #Orig Budget Budget Amended BDGT Jan YTD YTD Orig Budget Budget Amended BDGT Jan YTD YTD ACTUAL Amended BDGT Jan 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 - - - - n/a - 153,422 153,422 - n/a HAVA 3 Grant 104 - - - - n/a - 123,419 123,419 - n/a Auditor's O & M 105 77,900 77,900 3,360 3,360 4.3%77,900 566 78,466 2,307 2,307 2.9%72,512 80,480 1,799 1,799 2.5%2.2% Court Facilitator 106 4,000 (1,280) 2,720 260 260 9.6%4,500 4,500 260 260 5.8%4,300 4,100 320 320 7.4%7.8% Boating Safety 107 50,000 (5,500) 44,500 - - 0.0%50,000 50,000 - - 0.0%50,138 50,138 - - 0.0%0.0% WSU Cooperative 108 401,431 23,467 424,898 23,793 23,793 5.6%532,762 (53,107) 479,655 14,372 14,372 3.0%352,814 468,922 1,363 1,363 0.4%0.3% Noxious Weed 109 203,717 (200) 203,517 596 596 0.3%217,717 (23,700) 194,017 619 619 0.3%198,125 260,816 600 600 0.3%0.2% 4-H After School 113 Moved to Fund 108 - Moved to Fund 108 - 49,508 47,600 - - 0.0%0.0% JeffComCap 119 119 276,600 276,600 17,220 17,220 6.2%206,640 206,640 17,000 17,000 8.2%204,000 204,000 17,000 17,000 8.3%8.3% Crime Victim's Svc 120 81,543 81,543 2,690 2,690 3.3%81,543 81,543 2,452 2,452 3.0%127,920 140,813 23,804 23,804 18.6%16.9% Grant Mgmt 123 150,000 132,517 282,517 52,329 52,329 18.5%150,000 251,680 401,680 12,055 12,055 3.0%119,570 150,000 16,956 16,956 14.2%11.3% Hotel-Motel 125 537,087 537,087 38,926 38,926 7.2%521,444 521,444 32,023 32,023 6.1%579,805 500,500 29,854 29,854 5.1%6.0% Jeff Co Public Health 127 4,820,115 79,415 4,899,530 406,191 406,191 8.3%4,994,011 697,569 5,691,580 425,858 425,858 7.5%4,758,462 4,651,629 383,280 383,280 8.1%8.2% Water Quality 128 1,365,704 (2,227) 1,363,477 28,226 28,226 2.1%1,307,279 1,307,279 28,181 28,181 2.2%1,025,077 1,163,949 4,166 4,166 0.4%0.4% 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 120 120 0.2%50,289 50,289 197 197 0.4%50,299 47,637 717 717 1.4%1.5% Chem Dep Mnt Hlth tx 131 561,734 (26,465) 535,269 51,332 51,332 9.6%553,433 553,433 48,386 48,386 8.7%612,026 527,003 45,163 45,163 7.4%8.6% JC Inmate Commissary 134 41,500 (2,500) 39,000 897 897 Drug Fund 135 14,240 14,240 129 129 0.9%13,850 13,850 376 376 2.7%5,982 12,249 729 729 12.2%5.9% Law Library 140 11,591 4,827 16,418 524 524 3.2%16,081 16,081 730 730 4.5%9,149 10,927 640 640 7.0%5.9% Trial Court Imprvmnt 141 23,690 23,690 - - 0.0%23,000 23,000 7,084 7,084 30.8%22,806 23,000 - - 0.0%0.0% Community Develpmnt 143 1,505,632 155,394 1,661,026 96,797 96,797 5.8%1,657,637 155,230 1,812,867 68,943 68,943 3.8%1,635,441 1,812,850 50,245 50,245 3.1%2.8% Federal Forest Title III 147 21,000 21,000 - - 21,000 21,000 170 170 21,440 - 188 188 0.9% Jeff Co Affrdbl Hsg 148 45,582 45,582 11,559 11,559 25.4%45,131 103,780 148,911 4,125 4,125 2.8%50,363 48,000 3,001 3,001 6.0%6.3% Homeless Housing Fund 149 275,603 145,000 420,603 35,779 35,779 8.5%272,874 187,319 460,193 24,803 24,803 5.4%304,747 587,282 18,947 18,947 6.2%3.2% Treasurer's O & M 150 55,750 (1,000) 54,750 6 6 0.0%54,650 54,650 2,277 2,277 4.2%49,566 47,624 100 100 0.2%0.2% REET technology 151 13,401 13,401 1,457 1,457 10.9%13,816 13,816 1,204 1,204 8.7%15,250 15,690 1,080 1,080 7.1%6.9% Veteran's Relief 155 66,050 66,050 122 122 0.2%65,510 65,510 332 332 0.5%95,103 89,990 842 842 0.9%0.9% Park & Rec 174 698,883 (71,731) 627,152 504 504 0.1%684,549 (9,023) 675,526 2,356 2,356 0.3%665,738 669,649 1,497 1,497 0.2%0.2% County Park Imprvmnt 175 208,500 (47,000) 161,500 - - 0.0%171,625 31,360 202,985 - - 0.0%185,875 160,125 - - 0.0%0.0% Post Harvest Timber Mgm 178 8,375 8,375 - - - - 14 14 209 50 18 18 8.5%35.3% County Roads 180 8,985,491 (191,661) 8,793,830 181,192 181,192 2.1%8,801,630 409,379 9,211,009 258,942 258,942 2.8%8,166,809 8,931,921 458,225 458,225 5.6%5.1% Facilities Mgmt 183 1,209,958 47,285 1,257,243 110,973 110,973 8.8%1,169,335 1,169,335 102,070 102,070 8.7%1,111,711 1,065,393 16,191 16,191 1.5%1.5% Total Special Revenue 21,876,781 323,341 22,200,122 1,064,980 1,064,980 4.8%21,873,206 1,916,439 23,789,645 1,057,133 1,057,133 4.4%21,003,015 22,327,852 1,076,726 1,076,726 1.5%4.8% CAPITAL IMPROVEMENT Const/Renovation 301 415,233 415,233 1,938 1,938 0.5%363,826 363,826 34,477 34,477 9.5%773,299 518,500 1,863 1,863 0.2%0.4% Capital Improvement 302 1,155,500 1,155,500 88,027 88,027 7.6%1,156,313 1,000,000 2,156,313 69,086 69,086 3.2%1,246,025 1,072,125 64,496 64,496 5.2%6.0% Public Infrastructure 306 567,500 567,500 46,644 46,644 8.2%565,000 565,000 45,302 45,302 8.0%572,302 510,100 42,923 42,923 7.5%8.4% Conservation Futures 308 274,280 (5,980) 268,300 637 637 0.2%271,860 271,860 1,970 1,970 0.7%280,835 258,841 5,147 5,147 1.8%2.0% Total CAP IMP 2,412,513 (5,980) 2,406,533 137,246 137,246 5.7%2,356,999 1,000,000 3,356,999 150,835 150,835 4.5%2,872,460 2,359,566 114,428 114,428 7.5%4.8% 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 Jan YTD YTD Orig Budget Amended BDGT Jan YTD YTD YTD Amended BDGT Jan YTD YTD ENTERPRISE Solid Waste 401 3,670,759 3,670,759 308,098 308,098 8.4%3,718,073 3,718,073 287,312 287,312 7.7%3,866,094 3,636,313 288,809 288,809 7.5%7.9% Solid Waste Post Clos 402 38,686 38,686 4 4 - - 63 63 1,094 - 101 101 9.2% Solid Waste Eqpt Res 403 936,055 936,055 101 101 0.0%15,000 15,000 1,250 1,250 8.3%19,648 8,000 1,790 1,790 9.1%22.4% Yard Waste Educ Fnd 404 10,915 10,915 - - 0.0%7,000 7,000 5 5 0.1%209 6,800 18 18 8.7%0.3% Tri Area Sewer 405 1,064,500 381,192 1,445,692 93,487 93,487 6.5%982,500 23,087 1,005,587 878 878 0.1%303,778 303,632 1,342 1,342 0.4%0.4% Total ENTERPRISE 5,720,915 381,192 6,102,107 401,689 401,689 6.6%4,722,573 23,087 4,745,660 289,508 289,508 6.1%4,190,823 3,954,745 292,060 292,060 8.7%7.4% INTERNAL SERVICE Equipment Rental 501 2,681,971 167,202 2,849,173 61,794 61,794 2.2%2,617,745 18,883 2,636,628 54,155 54,155 2.1%2,915,525 3,139,487 85,924 85,924 2.9%2.7% Risk Management 502 150,000 150,000 - - 0.0%150,000 150,000 - - 0.0%38,522 215,000 - 0 0.0%0.0% Benefit Reserve 505 275,000 275,000 27,487 27,487 10.0%275,000 275,000 78,924 78,924 28.7%257,890 208,000 24,569 24,569 9.5%11.8% Information Services 506 1,954,417 31,579 1,985,996 494,579 494,579 24.9%1,968,639 1,335,533 3,304,172 482,834 482,834 14.6%2,116,237 2,197,065 62,157 62,157 2.9%2.8% Total INT SERV 5,061,388 198,781 5,260,169 583,860 583,860 11.1%5,011,384 1,354,416 6,365,800 615,913 615,913 9.7%5,328,174 5,759,552 172,651 172,651 2.9%3.0% Total 35,071,597 897,334 35,968,931 2,187,775 2,187,775 6.1%33,964,162 4,293,942 38,258,104 2,113,389 2,113,389 5.5%33,394,473 34,401,715 1,655,864 1,655,864 3.2%4.8% GENERAL FUND CASH BALANCE REPORT 2/16/2021 END OF MONTH CASH BALANCES 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 January 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 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$ March 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$ April 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$ May 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$ June 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$ July 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$ August 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,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,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,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,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 ** (includes 10% of total expenditures and revenue stabilization reserve) 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 Budg Total Reserve $ 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,306,665 15% GF Budgeted Expenditures * $ 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,862,515 Revenue Stabilization $ 100,000 $ 100,000 $ 140,000 $ 440,000 $ 440,000 $ 502,000 $ 726,000 $ 726,000 n/a n/a n/a * 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 $- $2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 $12,000,000 January February March April May June July August September October November December General Fund Cash Balance 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 1 January 2/16/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 9.0%334,584 - -$334,584 53.94% 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 6.6%246,799 - -$246,799 38.32% 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 6.3%232,925 - -$232,925 30.10% 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 7.9%293,968 - -$293,968 23.68% 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 7.1%266,051 - -$266,051 0.00% 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 8.5%315,192 - -$315,192 0.00% 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 0.00% 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 0.00% 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 0.00% 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 0.00% 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 326,695 100.0%$3,723,931 $326,695ytd 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 271,090 326,695 ytd change 16.78%-13.14%32.39%-26.23%-12.48%2.93%-0.12%29.18%-0.46%-7.43%13.11%0.12%12.07%24.25%17.39%7.74%20.51%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 9.3%94,876 - -$94,876 0.00%$0 March 40,604 56,106 49,782 50,931 62,285 61,183 66,479 70,614 72,888 6.8%69,482 - -$69,482 0.00%$0 April 43,155 51,054 47,573 52,541 59,481 59,911 63,784 65,310 69,887 6.5%65,842 - -$65,842 0.00%$0 May 51,908 58,324 56,012 62,613 74,233 78,716 84,357 88,754 75,138 8.0%82,144 - -$82,144 0.00%$0 June 45,930 46,797 50,067 48,647 58,717 65,832 65,229 75,141 77,429 68,693 7.2%73,215 - -$73,215 0.00%$0 July 55,488 49,385 68,295 54,074 56,793 69,908 73,136 81,117 89,815 86,275 8.3%85,109 - -$85,109 0.00%$0 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%$0 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%$0 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%$0 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%$0 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%$0 TOTAL 381,308 621,440 704,453 701,993 769,039 876,170 903,099 999,945 1,064,140 1,020,826 89,951 100.0%1,020,783 89,951 ytd 0 45,217 50,919 50,377 51,210 58,026 61,161 66,993 79,236 84,751 89,951 76,430 $89,951ytd change 12.61%-1.06%1.65%13.31%5.40%9.54%18.27%6.96%6.14%17.69%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 2020 2021 Expected expected Projection Over/UnderGeneral & Option 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 271,090 416,647 - - - Special Purpose Y - - - - - - - 45,217 50,919 50,377 51,210 58,026 61,161 66,993 79,236 84,751 89,951 76,430 89,951 - - - G&O and SP Sal 154,373 180,283 156,597 207,318 152,937 133,849 137,774 182,832 228,695 227,333 215,021 243,317 246,667 274,892 337,549 387,987 416,647 347,521 506,598 - - - Full Year Total Ac 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 - - MONTHLY SALES TAX GENERAL & OPTIONAL AND SPECIAL PURPOSE 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 2018-20 2021 2021 Expected expected Projection rojected Over/U January 154,373 180,283 156,597 207,318 152,937 133,849 137,774 182,832 228,695 227,333 215,021 243,317 246,667 274,892 337,549 387,987 416,647 7.3%347,521 416,647 $69,126 119.89%$5,689,137 $944,423February224,687 244,043 249,049 206,809 219,448 215,617 201,110 268,180 298,312 285,508 313,148 346,826 403,971 370,154 409,218 457,015 - 9.1%429,460 - -$429,460 0.00%#VALUE!March 142,119 161,270 157,709 170,679 177,252 122,153 136,282 156,563 250,725 206,739 215,324 256,751 250,759 273,478 312,572 324,431 - 6.7%316,281 - -$316,281 0.00%#VALUE!April 156,731 170,147 181,390 162,253 148,592 131,100 127,885 167,272 225,772 201,789 220,090 240,865 253,772 266,316 274,725 319,060 - 6.3%298,767 - -$298,767 0.00%#VALUE!May 198,754 211,995 207,595 212,586 181,514 175,118 178,468 203,359 253,499 234,086 270,564 300,523 328,312 355,788 383,945 342,896 - 7.9%376,112 - -$376,112 0.00%#VALUE!June 164,380 165,275 175,802 167,706 172,947 133,593 200,599 180,706 216,817 205,010 254,948 262,594 273,577 323,647 340,499 312,261 - 7.2%339,266 - -$339,266 0.00%#VALUE!July 187,091 235,150 199,236 174,881 159,276 136,373 221,764 205,266 257,252 228,204 242,682 274,051 309,584 343,606 398,407 409,818 - 8.4%400,301 - -$400,301 0.00%#VALUE!August 220,873 241,022 250,665 244,562 199,901 184,345 246,710 248,822 275,646 307,496 334,103 363,584 383,632 406,836 462,808 442,796 - 9.6%455,987 - -$455,987 0.00%#VALUE!September 211,602 211,286 200,636 213,505 187,214 173,733 225,125 297,214 260,334 276,640 299,788 325,230 318,859 404,786 414,342 468,330 - 9.4%447,426 - -$447,426 0.00%#VALUE!October 213,751 244,393 214,468 212,410 168,681 161,452 242,654 265,078 278,972 272,408 313,293 336,030 350,255 402,305 431,890 466,248 - 9.5%451,879 - -$451,879 0.00%#VALUE!November 253,367 234,710 263,159 239,855 213,651 200,463 238,400 267,427 285,758 302,561 318,760 382,973 370,695 409,120 469,051 471,390 - 9.9%468,931 - -$468,931 0.00%#VALUE!December 183,910 170,134 197,603 197,943 155,866 150,355 193,327 225,874 221,344 255,155 257,928 281,670 289,354 364,274 430,895 391,361 - 8.7%412,784 - -$412,784 0.00%$0 -$4,744,714TTL2,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 416,647 100.0%$4,744,714 $416,647ytd 154,373 180,283 156,597 207,318 152,937 133,849 137,774 182,832 228,695 227,333 215,021 243,317 246,667 274,892 337,549 387,987 416,647 347,521 416,647 ytd change 16.78%-13.14%32.39%-26.23%-12.48%2.93%32.70%25.08%-0.60%-5.42%13.16%1.38%11.44%22.79%14.94%7.39%19.89%over (under) ytd expectedannual % chg.6.84%-0.64%-1.77%-11.33%-10.25%22.52%13.55%14.41%-1.64%8.42%11.02%4.57%11.00%11.22%2.74% - 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 January 2021 - 50,000 100,000 150,000 200,000 250,000 300,000 350,000 400,000 450,000 500,000 1 2 3 4 5 6 7 8 9 10 11 12 2020 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 2020 Cumulative YTD Actual & Budget Expected by Month YTD Actual Year EndProjectedOver/UnderBudgetYTD Budget $0.00 January 5/7/2020 Sales Tax 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 General & Optional YTD 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 Special Purpose YTD - - - - - - - 45,217 50,919 50,377 51,210 58,026 61,161 66,993 79,236 84,751 G&O and SP Sales Tax YTD 154,373 180,283 156,597 207,318 152,937 133,849 137,774 182,832 228,695 227,333 215,021 243,317 246,667 274,892 337,549 387,987 Full Year Total: 2020 is YTD Actua 2,311,638 2,469,708 2,453,909 2,410,507 2,137,279 1,918,151 2,350,098 2,668,593 3,053,126 3,002,929 3,255,650 3,614,414 3,779,438 4,195,203 4,665,900 4,793,593 - 50,000 100,000 150,000 200,000 250,000 300,000 350,000 400,000 450,000 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 Sales Tax Total Received YTD General & Optional YTD Special Purpose YTD 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 20 Sales Tax Per Year YTD and Full Year General & Optional YTD Special Purpose YTD G&O and SP Sales Tax YTD Full Year Total: 2020 is YTD Actual & 2020 B January January 2021 City of Port Townsend This Year Last Year % Chg This Year Last Year % Chg $ Chg % Tot Chg This Year Last Year % Chg This Year Last Year % Chg $ Chg % Tot Chg Construction 93,539 102,199 (8)93,539 102,199 (8)(8,660)-38.57%1,025,948 Construction 4,871 3,666 33 4,871 3,666 33 1,205 5.37%52,035Manufacturing6,534 5,503 51 6,534 5,503 19 1,032 4.60%67,156 Manufacturing 657 1,556 (150)657 1,556 (58)(898)-4.00%-6,482 Wholesale Trade 15,280 13,149 16 15,280 13,149 16 2,131 9.49%186,930 Wholesale Trade 2,197 2,566 (14)2,197 2,566 (14)(368)-1.64%26,783 Retail Trade 105,704 78,356 70 105,704 78,356 35 27,348 121.81%1,195,013 Retail Trade 15,201 13,927 20 15,201 13,927 9 1,274 5.67%167,863Transportation & Warehousing 908 884 126 908 884 3 24 0.11%7,321 Transportation and Warehousing 108 33 488 108 33 231 75 0.33%1,779Information10,056 9,879 2 10,056 9,879 2 177 0.79%127,125 Information 974 887 10 974 887 10 86 0.38%11,354 Finance & Insurance 1,367 1,112 23 1,367 1,112 23 255 1.14%12,920 Finance and Insurance 278 262 6 278 262 6 16 0.07%3,417 Real Estate, Rental & Leasing 4,590 5,522 (17)4,590 5,522 (17)(932)-4.15%59,096 Real Estate and Rental and Leasing 376 307 23 376 307 23 69 0.31%5,599Professional, Scientific & Technical Services 3,941 5,211 (24)3,941 5,211 (24)(1,271)-5.66%43,477 Professional, Scientific, and Technical Services 423 544 (22)423 544 (22)(121)-0.54%8,771Admin & Support, Waste Mgmt & Remediation Svcs 20,822 14,506 44 20,822 14,506 44 6,317 28.13%237,226 Admin & Support, Waste Mgmt & Remediation Sv 1,517 1,119 36 1,517 1,119 36 398 1.77%16,782 Educational Services 227 88 159 227 88 159 139 0.62%3,075 Educational Services 33 31 5 33 31 5 2 0.01%598 Health Care and Social Assistance 79 32 147 79 32 147 47 0.21%1,830 Health Care and Social Assistance 428 195 119 428 195 119 233 1.04%4,411 Arts, Entertainment & Recreation 1,020 1,196 (15)1,020 1,196 (15)(176)-0.78%20,273 Arts, Entertainment, and Recreation 191 273 (30)191 273 (30)(82)-0.37%3,425Accommodation & Food Services 13,128 16,357 (20)13,128 16,357 (20)(3,229)-14.38%197,653 Accommodation and Food Services 3,013 4,100 (27)3,013 4,100 (27)(1,086)-4.84%44,639 Public Administration & Other Services 5,305 5,660 (79)5,305 5,660 (6)(355)-1.58%60,983 Public Administration & Other Services 2,030 1,861 (21)2,030 1,861 9 169 0.75%18,864 Unclassified 10,535 10,761 (2)10,535 10,761 (2)(226)-1.01%163,806 Natural Resources, Utilities & Unclassified 581 2 (48)1 2 (48)(1)0.00%45 Agriculture, Forestry, Fishing & Hunting 25 323 (92)25 323 (92)(298)-1.33%4,634 City of Port Townsend Totals 32,877 31,328 3 32,297 31,328 3 970 4.32%359,884Mining, Quarrying, Oil & Gas Extraction 668 509 31 668 509 31 159 0.71%12,389 Utilities 88 120 (27)88 120 (27)(32)-0.14%1,845 Jefferson County, WA Totals 293,818 271,366 8 293,818 271,366 8 22,452 100.00%3,428,700 Current Period Year to Date Last 12 Months Current Period: 202011 Cash Basis, Revenue Amounts Jefferson County Year to DateCurrent Period Last 12 Months (8) 51 16 70 126 2 23 (17)(24) 44 159 147 (15)(20) (79)(100) (50) 0 50 100 150 200 -150,000 -100,000 -50,000 0 50,000 100,000 150,000 2020 and 2019 Amounts and Percentage Change from last year This Year Last Year % Chg Current 33 (150) (14) 20 488 10 6 23 (22) 36 5 119 (30)(27)(21) (200) (100) 0 100 200 300 400 500 600 -50,000 -40,000 -30,000 -20,000 -10,000 0 10,000 20,000 30,000 40,000 50,000 2020 and 2019 Amounts and Percentage Change from last year This Year Last Year % Chg Current Construction Manufacturing Wholesale Trade Retail Trade Transportation and Warehousing Information Finance and Insurance Real Estate and Rental and Leasing Professional, Scientific, and Technical Services Admin & Support, Waste Mgmt & Remediation Svcs Educational ServicesHealth Care and Social Assistance Arts, Entertainment, and Recreation Accommodation and Food Services Public Administration & Other Services Natural Resources, Utilities & Unclassified City of Port Townsend, WA Total Taxable Sales Construction Manufacturing Wholesale Trade Retail Trade Transportation and Warehousing Information Finance and Insurance Real Estate and Rental and Leasing Professional, Scientific, and Technical Services Admin & Support, Waste Mgmt & Remediation Svcs Educational Services Health Care and Social Assistance Arts, Entertainment, and Recreation Accommodation and Food Services Public Administration & Other Services Natural Resources, Utilities & Unclassified Construction Manufacturing Wholesale Trade Retail Trade Transportation & Warehousing Information Finance & InsuranceReal Estate, Rental & Leasing Professional, Scientific & Technical Services Admin & Support, Waste Mgmt & Remediation Svcs Educational Services Health Care and Social Assistance Arts, Entertainment & RecreationAccommodation & Food ServicesPublic Administration & Other Services Unclassified Agriculture, Forestry, Fishing & Hunting Mining, Quarrying, Oil & Gas Extraction Utilities Construction Manufacturing Wholesale Trade Retail Trade Transportation & Warehousing Information Finance & Insurance Real Estate, Rental & Leasing Professional, Scientific & Technical Services Admin & Support, Waste Mgmt & Remediation Svcs Educational Services Health Care and Social Assistance Arts, Entertainment & Recreation Accommodation & Food Services Public Administration & Other Services Unclassified Agriculture, Forestry, Fishing & Hunting Mining, Quarrying, Oil & Gas Extraction Utilities Jefferson County, WA Total Taxable Sales Sales Tax by Sector For November 2020 with Distribution in January 2021 1 2020 January 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 62,343 50,691 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 85,754 69,726 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 87,380 71,048 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 106,569 86,652 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 151,424 123,122 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 127,942 104,029 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 $88,027 1,365,147$ 1,110,000$ 88,027$ -92.1%37.5% YTD 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%7.1% YTD change 6.50%-13.14%-37.13%170.29%-76.76%4.50%-49.96%-1.32%57.28%-24.82%72.24%37.54%-36.60%29.43%7.12%27.42% Annual % chg 6.50%-13.14%-37.13%170.29%-76.76%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 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 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 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 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. 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 >$500k Dec 2020 2@$1.96M & $1.1M; 13 sales>$500k. 2/16/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 REET 2021 YTD Actual Total & Budget YTD Actual YTD Budget 0 20,000 40,000 60,000 80,000 100,000 120,000 140,000 160,000 2021 Monthly Actual Revenue & Budgeted Share 2021 Actual Budget January January 2021 2/8/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 43,649 44,205 March 22,623 12,406 7,271 11,203 12,715 14,345 14,554 16,889 19,419 25,281 29,621 22,802 23,093 April 11,344 10,791 14,950 11,430 12,427 14,983 18,530 20,901 23,749 22,829 29,140 24,154 24,462 May 19,646 25,142 17,142 18,010 19,151 23,886 29,462 45,943 41,061 41,546 11,527 35,019 35,465 June 19,205 17,302 17,916 16,477 18,786 25,070 29,476 31,485 36,556 43,299 742 28,021 28,378 July 20,155 19,311 20,201 21,512 24,536 27,711 33,687 38,400 44,445 48,748 24,074 38,917 39,413 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 38,926 530,330 537,087 38,926 YTD 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% 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 7.22%4.68%-26.42%53.16%25.60%8.34%4.98%19.51%28.81%7.26%21.56% 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 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 January HOTEL-MOTEL REVENUE 1 January 2021 *** 2021 is YTD Actual plus budgeted remainder of year 1998 1999 2000 2001 2002 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021January6,047 15,702 14,839 14,173 15,054 23,014 13,009 13,236 9,908 15,742 16,089 10,732 11,507 12,045 8,863 13,575 17,051 18,473 19,394 23,177 29,854 32,023 38,926 February 4,987 9,370 14,953 15,988 22,474 19,563 21,042 19,678 22,155 29,461 27,998 21,729 25,532 23,188 38,274 30,356 36,141 51,077 53,093 46,226 41,186 34,092 44,205March6,502 9,973 9,552 12,547 13,694 9,311 11,586 12,354 11,250 10,723 22,623 9,838 12,406 7,271 11,203 12,715 14,345 14,554 16,889 19,419 25,281 29,621 23,093April5,272 8,642 13,169 13,934 13,220 16,704 8,587 14,078 14,334 11,702 11,344 11,934 10,791 14,950 11,430 12,427 14,983 18,530 20,901 23,749 22,829 29,140 24,462May7,063 15,466 15,349 17,692 15,112 16,585 11,482 19,604 19,879 20,360 19,646 19,561 25,142 17,142 18,010 19,151 23,886 29,462 45,943 41,061 41,546 11,527 35,465 June 8,054 11,729 21,021 18,464 13,443 18,218 10,145 18,640 18,954 18,853 19,205 19,650 17,302 17,916 16,477 18,786 25,070 29,476 31,485 36,556 43,299 742 28,378July12,517 17,222 20,739 21,245 13,618 16,276 27,584 19,451 20,546 23,514 20,155 14,326 19,311 20,201 21,512 24,536 27,711 33,687 38,400 44,445 48,748 24,074 39,413August15,839 30,016 31,288 25,444 32,509 30,719 30,585 34,443 36,034 37,302 35,178 36,076 24,742 31,171 33,140 37,534 48,845 56,349 64,820 64,934 70,516 41,591 61,236 September 14,322 32,758 35,138 37,063 27,842 30,977 30,966 34,701 39,236 41,768 41,757 40,208 42,500 40,882 39,890 42,349 44,713 53,487 56,561 68,870 88,306 79,681 74,289 October 19,863 33,671 37,802 35,994 21,948 15,635 36,840 30,420 40,711 42,480 43,012 46,548 43,861 41,015 41,741 43,659 49,182 59,970 58,458 65,200 60,682 78,504 66,548November32,288 38,816 39,069 35,492 35,316 44,483 46,577 49,067 46,989 44,786 44,351 43,285 38,547 36,906 39,146 46,879 58,967 57,999 69,054 63,101 65,013 75,302 68,985December18,901 20,782 21,451 22,776 12,733 33,992 18,623 20,872 21,914 21,753 19,873 18,741 21,703 11,109 15,514 33,858 25,213 26,084 32,870 46,067 42,545 54,544 44,567 Hotel-Motel YTD 6,047 15,702 14,839 14,173 15,054 23,014 13,009 13,236 9,908 15,742 16,089 10,732 11,507 12,045 8,863 13,575 17,051 18,473 19,394 23,177 29,854 32,023 38,926 Full Year Total: 2021 is YTD Actual & 2021 Budget 151,655 244,147 274,370 270,812 236,963 275,477 267,026 286,544 301,910 318,444 321,231 292,628 293,344 273,796 295,200 335,825 386,107 449,148 507,868 542,805 579,805 490,842 537,087 YTD Change 159.67%-5.50%-4.49%6.22%52.88%-43.47%1.74%-25.14%58.88%2.20%-33.30%7.22%4.68%-26.42%53.16%25.60%8.34%4.98%19.51%28.81%7.26%21.56% Annual % Change 60.99%12.38%-1.30%-12.50%16.25%-3.07%7.31%5.36%5.48%0.88%-8.90%0.24%-6.66%7.82%13.76%14.97%16.33%13.07%6.88%6.82%-15.34%9.42% 0 5,000 10,000 15,000 20,000 25,000 30,000 35,000 40,000 45,000 19981999200020012002200420052006200720082009201020112012201320142015201620172018201920202021Hotel-Motel YTD 2021 January 0 100,000 200,000 300,000 400,000 500,000 600,000 700,000 19981999200020012002200420052006200720082009201020112012201320142015201620172018201920202021Hotel-Motel Per Year: YTD and Full Year Hotel-Motel YTD Full Year Total: 2021 is YTD Actual & 2021 Budget