Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2020-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 Revenue Report September 2020 Revenue General Fund at $15,277,007 – 69.4% of the 2020 budget year to date which is similar to previous years. Property tax collections are on track. The second sheet shows general fund revenue charts showing 2015-2020 year to date detail and percentage of actual full year collections. 2020 is shown as a percentage of our adopted budget. Other Funds at $22,664,216– 67.1% of 2020 budget year to date which is 3-5% lower than previous years. General Fund Cash Balance - $5,829,323.64 at the end of September which includes the $3.526 million budgeted reserve. This is slightly less than the amount for this time last year. General Sales Tax Receipts - $468,330 which includes $96,212 for Special Purpose in September 2020. General & Optional Sales tax is $52,000 over this month last year and 20% over budget for the month. It’s holding at 13% over budget for 2020 YTD. Special Purpose is very similar to last year and 2.4% less than 2019 YTD. Cumulatively they’re 3.9% over budget for the month and 9.8% over for YTD. The charts show the revenue per month back to 2005. Sales Tax Data: Sales tax composition by category reflects funds receipted in September for business reporting in July. Total taxable sales in June was $113.8 million, and the amount collected for General & Optional was 16% more than this period last year. Construction and Retail are a lot higher than this month last year. Accommodations and Food Service are 23% down for the month and 33% down year to date. Overall, 2020 YTD is 6% over 2019 YTD collections. REET Receipts - Fund 302 - $211,718 in September which is twice what it was this month last year and 83% over budget for the month. Year to Date REET Collections are 33% over budget and 30% over 2019 YTD. One residential sale on Ebb Tide Ct in Port Ludlow was 2.1 million, and one on Juan De Fuca Rd sold for $1.253 million. There were 29 sales in unincorporated Jefferson County in September with selling prices between $500,000 and $1 million. In the City, the Baker Block Building sold for $6.8 million. Hotel/Motel Lodging Tax – Fund 125 - $79,681 in September with $282,492 YTD. This puts it 18.9% over budget for the month and 9.8% less than what was collected this month last year. Year to date is 21.4% under budget and 31.4% less than 2019 YTD. One reason for Page | 2 the higher collections this month could be attributed to the extension allowed for some to file sales tax until July due to the pandemic. 2020 9 September Jefferson County Treasurer 10-Sep-2020 General Fund REVENUE NAME BARS BUDGET QTRLY AMENDED SEP Y-T-D Y-T-D BUDGET Quarterly AMENDED ACTUAL SEP Y-T-D Y-T-D BUDGET ACTUAL SEP Y-T-D Y-T-D *2020 Approp Budget 2020 2020 2020 %2019 Approp Budget 2019 2019 2019 2019 % of Actual 2018 2018 2018 2018 % of Actual Property Tax 1 311.10 8,290,037 8,290,037 158,949 4,960,167 59.8%8,021,323 8,021,323 7,992,860 147,719 4,806,692 60.1%7,850,027 7,805,908 151,258 4,660,319 59.7% Diverted Road Prop Tax 1 311.20 720,000 720,000 14,440 441,494 61.3%720,000 720,000 720,000 13,044 435,008 60.4%720,000 720,000 13,383 430,671 59.8% Sales Tax 1 313.11 3,326,609 3,326,609 372,118 2,715,110 81.6%3,204,826 192,869 3,397,695 3,601,761 319,609 2,565,970 71.2%3,040,000 3,195,259 307,750 2,296,483 71.9% special purpose 313.15 1,045,244 1,045,244 96,212 749,484 71.7%1,006,979 55,384 1,062,363 1,064,119 94,733 768,075 72.2%955,428 999,945 97,036 723,021 72.3% Local Criminal Justice 1 313.71 422,650 422,650 41,292 313,510 74.2%407,177 22,395 429,572 442,239 39,394 319,136 72.2%380,070 417,655 40,861 302,199 72.4% Leasehold Excise Tax 3 317.20 66,801 66,801 - 59,895 89.7%66,801 66,801 75,500 - 56,297 74.6%62,000 65,642 - 48,627 74.1% Private Harvest Tax - TAV 2 317.40.10/.20 339,599 339,599 - 209,039 61.6%339,599 339,599 363,246 - 349,118 96.1%335,000 537,635 - 379,277 70.5% P.I.L.T. (incl DNR)4332.15.23/336.02.31 1,015,150 1,015,150 - 1,572,825 154.9%1,015,136 537,328 1,552,464 1,553,455 - 1,537,328 99.0%1,867,988 1,850,941 - 1,833,818 99.1% P.U.D. Privilege Tax 4 335.00.91 386,555 386,555 - 398,063 103.0%375,296 375,296 385,397 - 385,397 100.0%323,420 393,491 - 393,491 100.0% Crim Just Hi Crime/DUI/Asst 5 336.06.10/51 451,770 451,770 - 385,846 85.4%438,612 438,612 336,086 - 333,709 99.3%463,500 425,438 - 320,837 75.4% Marijuana Enforcement/Excise 6 336.06.41/42 52,548 52,548 11,088 35,549 67.6%51,017 51,017 170,903 12,294 36,518 21.4%24,720 63,962 12,187 51,775 80.9% Liquor Excise Tax 8 336.06.94 48,267 48,267 - 43,836 90.8%47,321 47,321 51,439 - 37,729 73.3%41,536 47,254 - 34,380 72.8% Liquor Profit 6 336.06.95 90,650 90,650 20,826 62,513 69.0%88,873 88,873 83,623 20,844 62,779 75.1%90,203 84,066 20,968 63,098 75.1% Treasurer Invest & Other Fees 1 341.42.15-20/50 35,830 35,830 626 19,787 55.2%35,000 35,000 43,596 2,378 28,039 64.3%16,290 42,753 2,254 35,510 83.1% Treas. Collection Fees (REET)3 341.42.31/32/33 87,175 87,175 14,721 63,131 72.4%87,175 87,175 85,234 6,757 62,009 72.8%80,000 83,290 7,711 63,295 76.0% Penalties on delinquent taxes 1 359.40.10/.20 119,757 119,757 5,543 97,505 81.4%117,409 117,409 113,976 3,496 84,739 74.3%133,332 98,079 3,766 76,610 78.1% Investment Income 1 361.11 713,000 713,000 3,340 348,616 48.9%349,847 600,000 949,847 1,028,831 59,096 896,183 87.1%230,000 534,468 55,502 386,758 72.4% Interest on delinquent taxes 1 361.40.10 192,316 192,316 9,851 185,818 96.6%188,545 188,545 224,004 6,741 163,388 72.9%210,000 197,154 14,730 151,515 76.9% Interfund Chg Svc-Cost Alloc 3 362.50.00.180/0671 339,521 339,521 - 29,207 8.6%329,632 329,632 232,066 - 28,985 12.5%328,526 409,407 - 206,731 50.5% DNR Timber & DNRTimbTrust 2 1 395.1.1/335.02.33 250,000 250,000 42,702 256,790 102.7%250,000 250,000 500,000 352,075 - 330,417 93.8%250,000 330,761 116,213 160,930 48.7% Transfer in 1 397.00 3,000 24,074 27,074 - 26,322 97.2%8,000 8,000 21,798 - 21,048 96.6%3,000 42,992 10,233 30,177 70.2% Miscellaneous 1341.43/341.81/361.40.00/361.40.30/362.50.1/369.81/369.9 27,784 27,784 732 9,835 35.4%13,631 13,631 111,997 1,184 12,687 11.3%11,900 43,811 956 12,925 29.5% Assessor 1 001-010-000 8,300 8,300 - 5,729 69.0%8,300 8,300 9,642 115 5,847 60.6%8,700 8,542 53 5,894 69.0% Auditor-Recording Fees 1 341.21.10 69,495 69,495 8,809 66,850 96.2%70,510 70,510 69,039 5,893 48,205 69.8%72,063 70,227 5,557 53,404 76.0% Auditor-M.V. License Fees 1341.48+/336.00.93 246,440 16,370 262,810 17,698 238,466 90.7%229,257 229,257 302,603 15,629 226,144 74.7%232,703 234,383 12,914 201,492 86.0% Auditor-Other Revenue 1 35,330 35,330 2,542 18,144 51.4%42,450 42,450 35,127 2,959 26,892 76.6%26,605 34,184 2,441 26,184 76.6% Elections 1 001-021-000 116,110 116,110 - 309,648 266.7%130,160 130,160 161,606 1 103,964 64.3%159,722 101,546 5,147 98,536 97.0% Clerk 1 001-020-000 149,591 149,591 18,982 108,371 72.4%152,506 152,506 149,436 17,750 118,249 79.1%170,768 181,580 9,911 130,070 71.6% County Administrator 1 001-059-000 438,600 438,600 - 4,000 0.9%4,260 (560) 3,700 4,260 - 4,260 100.0%4,260 4,260 - 4,260 100.0% Commissioners 1 001-060-000 8,000 8,000 1,014 7,216 90.2%8,000 8,000 7,843 666 5,582 71.2%8,000 8,522 624 6,526 76.6% Safety & Security 1 001-067-000 75,538 75,538 - 67,399 89.2%70,604 70,604 36,232 - 28,578 78.9%64,959 44,082 - 41,545 94.2% Community Services 1 001-068-000 4,155 4,155 46 2,996 72.1%4,005 4,005 3,987 17 3,084 77.4%6,900 4,180 46 3,273 78.3% District Court 1 001-080-000 644,505 644,505 33,000 349,798 54.3%636,823 (612) 636,211 682,644 84,156 485,285 71.1%603,032 674,579 37,597 529,017 78.4% Juvenile Service 1 001-110-000 279,284 279,284 30,003 249,155 89.2%298,727 (13,500) 285,227 243,744 7,574 173,448 71.2%259,676 288,710 14,788 198,622 68.8% Prosecuting Attorney 1 001-150-000 320,633 320,633 31,559 132,589 41.4%148,916 16,789 165,705 257,902 7,958 172,746 67.0%178,690 110,543 (11,959) 76,576 69.3% Coroner 1 001-151-000 25,348 25,348 - 13,958 55.1%25,348 25,348 18,324 - 18,324 100.0%25,348 32,723 - 32,723 100.0% Sheriff 1 001-180-000 794,303 154,500 948,803 86,682 624,771 65.8%561,174 483,436 1,044,610 1,141,545 125,111 801,488 70.2%625,969 618,527 74,179 460,772 74.5% Superior Court 1 001-240-000 59,421 59,421 220 7,958 13.4%60,912 109 61,021 50,414 620 8,560 17.0%60,822 51,520 - 37,764 73.3% Non Departmental 1 001-261/270-000 35,568 481,500 517,068 23,517 85,617 16.6%50,437 25,000 75,437 39,722 30 35,882 90.3%50,447 32,802 - 32,802 100.0% TOTAL CURRENT EXPENSE REVENUE 21,334,884 676,444 22,011,328 1,046,514 15,277,007 69.4%19,664,588 2,168,638 21,833,226 22,268,272 995,766 15,587,785 70.0%19,975,604 20,890,820 1,006,108 14,601,908 69.9% * 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 excluded 388/89 0 9,233 36,879 0 34 29,806 0 1,288 (111,173) September 2020 GENERAL FUND REVENUE 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020Property 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 Diverted 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 Sales 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 special purpose 0 216,742 450,086 522,663 507,308 554,926 638,413 659,790 723,021 768,075 749,484 Local Criminal Justice 189,065 197,222 189,125 218,109 211,597 230,104 265,166 273,880 302,199 319,136 313,510 Leasehold Excise Tax 38,163 42,042 40,542 44,375 48,417 44,462 44,666 50,748 48,627 56,297 59,895 Private Harvest Tax 90,580 218,466 254,250 324,269 358,822 366,366 252,332 311,003 379,277 349,118 209,039 P.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 P.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 Crim 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 Marijuana Enforcement/Excise 0 0 0 0 0 12,784 31,244 16,324 51,775 36,518 35,549 Liquor Excise Tax 27,662 28,998 31,873 0 9,683 11,894 30,739 32,161 34,380 37,729 43,836 Liquor Profit 53,347 50,328 74,510 63,603 63,645 63,801 63,594 63,375 63,098 62,779 62,513 Treasurer 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 Treas. 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 Penalties 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 Investment Income 153,172 95,139 41,562 12,073 20,930 49,142 641,605 317,048 386,758 896,183 348,616 Interest 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 Interfund Chg Svc-Cost Alloc 248,999 0 0 39,051 0 26,255 26,537 30,577 206,731 28,985 29,207 DNR Timber 71,208 554,407 220,747 69,974 254,282 415,464 296,001 94,176 160,930 330,417 256,790 Transfer in 0 0 0 0 0 5,000 45,691 38,087 30,177 21,048 26,322 Miscellaneous 231,871 155,519 24,222 41,907 25,717 281,276 16,462 5,613 12,925 12,687 9,835 Assessor 1,206 960 3,026 240,479 12,743 640 6,160 8,173 5,894 5,847 5,729 Auditor-Recording Fees 48,355 47,399 52,290 58,724 42,015 54,345 53,616 54,610 53,404 48,205 66,850 Auditor-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 Auditor-Other Revenue 25,294 24,884 24,291 25,592 25,436 72,388 23,446 22,392 26,184 26,892 18,144 Elections 116,237 83,948 71,369 57,487 76,021 68,673 153,467 114,205 98,536 103,964 309,648 Clerk 152,087 154,932 157,782 158,932 157,754 156,069 147,081 134,514 130,070 118,249 108,371 County Administrator 0 0 0 0 0 - - - 4,260 4,260 4,000 Commissioners 7,304 5,617 10,716 7,440 5,571 6,555 6,310 6,500 6,526 5,582 7,216 Safety & Security 54,795 28,415 63,022 47,289 28,735 58,473 58,168 55,509 41,545 28,578 67,399 Community Services 0 4,502 943 4,307 3,198 3,361 6,318 3,885 3,273 3,084 2,996 District Court 402,225 480,828 454,674 448,535 437,218 500,392 487,689 466,196 529,017 485,285 349,798 Juvenile Service 188,323 195,703 138,272 221,208 192,088 178,430 183,635 196,071 198,622 173,448 249,155 Prosecuting Attorney 229,663 222,307 152,792 119,476 117,722 180,064 100,109 125,797 76,576 172,746 132,589 Coroner 4,640 14,080 6,380 11,032 6,380 11,140 8,340 24,610 32,723 18,324 13,958 Sheriff 694,934 758,826 495,025 454,090 354,161 429,046 474,379 440,703 460,772 801,488 624,771 Superior Court 19,976 6,439 3,000 5,344 3,000 4,718 20,732 67,739 37,764 8,560 7,958 Non Departmental 0 0 0 0 0 - 10 10 32,802 35,882 85,617 TOTAL 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 TOTAL 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 22,011,328 YTD % of Full Year Actual/2020 Budget 65.8%66.5%66.5%69.0%67.7%67.9%70.7%69.1%69.9%70.0%69.4% 0 2,000,000 4,000,000 6,000,000 8,000,000 10,000,000 12,000,000 14,000,000 16,000,000 18,000,000 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 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 2020 65.8%66.5%66.5%69.0%67.7%67.9%70.7%69.1%69.9%70.0%69.4% 0.0% 20.0% 40.0% 60.0% 80.0% 100.0% 120.0% 0 5,000,000 10,000,000 15,000,000 20,000,000 25,000,000 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 GENERAL FUND YTD AND FULL YEAR ACTUAL/2020 BUDGET TOTAL CURRENT EXPENSE TOTAL CURRENT EXPENSE ACTUAL/2020 BUDGET YTD % of Full Year Actual/2020 Budget September OTHER FUNDS REVENUE REPORT 2020 3 year view September 9 10/26/2020 FUND Fund #Orig Budget Budget Amended BDGT Sep YTD YTD ACTUAL Amended BDGT Sep YTD ACTUAL YTD AMEND BUDGET YTD ACTUAL Sep YTD YTD 2020 Amendment 2020 2020 2020 %2019 2019 2019 2019 2019 - %2019 - %2018 2018 2018 % SPECIAL REVENUE Elections CARES Act 103 - 153,422 153,422 23 153,485 n/a HAVA 3 Grant 104 - 123,419 123,419 29 123,457 n/a Auditor's O & M 105 77,900 77,900 3,515 76,946 98.8%72,512 80,480 2,346 64,426 88.8%80.1%76,912 2,261 69,648 90.6% Court Facilitator 106 4,500 4,500 440 2,280 50.7%4,300 4,100 180 3,400 79.1%82.9%4,820 360 3,720 77.2% Boating Safety 107 50,000 50,000 - 30,384 60.8%50,138 50,138 - 50,138 100.0%100.0%47,887 - 47,451 99.1% WSU Cooperative 108 532,762 (69,310) 463,452 1,511 359,938 77.7%352,814 468,922 853 289,629 82.1%61.8%556,121 64,268 400,459 72.0% Noxious Weed 109 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 - 49,508 47,600 8 62,708 126.7%131.7%37,750 - 37,750 100.0% JeffComCap 119 119 206,640 206,640 17,220 154,980 75.0%204,000 204,000 17,000 153,000 75.0%75.0%264,695 33,907 210,371 79.5% Crime Victim's Svc 120 81,543 81,543 4,346 90,114 110.5%127,920 140,813 2,771 96,699 75.6%68.7%113,502 20,997 82,362 72.6% Grant Mgmt 123 150,000 132,517 282,517 - 64,749 22.9%119,570 150,000 79,852 66.8%53.2%101,793 3,488 82,211 80.8% Hotel-Motel 125 521,444 521,444 79,681 281,430 54.0%579,805 500,500 88,306 411,565 71.0%82.2%542,805 68,870 368,436 67.9% Jeff Co Public Health 127 4,994,011 4,994,011 292,830 3,922,943 78.6%4,758,462 4,651,629 176,219 3,494,554 73.4%75.1%4,606,955 255,247 3,549,938 77.1% Water Quality 128 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%969,155 50,609 731,517 75.5% Water Quality Land Acq 129 115,000 115,000 - - 0.0%160,179 275,000 160,179 160,179 100.0%58.2%132,825 - 0.0% Mental Health 130 50,289 50,289 1,133 31,388 62.4%50,299 47,637 851 31,585 62.8%66.3%50,132 1,462 30,197 60.2% Chem Dep Mnt Hlth tx 131 553,433 553,433 56,498 429,696 77.6%612,026 527,003 53,953 443,429 72.5%84.1%573,509 56,054 415,126 72.4% Drug Fund 135 13,850 13,850 146 5,523 39.9%5,982 12,249 415 5,091 85.1%41.6%14,395 626 10,196 70.8% Law Library 140 16,081 16,081 670 10,586 65.8%9,149 10,927 722 6,701 73.2%61.3%9,915 822 7,483 75.5% Trial Court Imprvmnt 141 23,000 23,000 - 21,252 92.4%22,806 23,000 - 17,103 75.0%74.4%23,201 - 17,403 75.0% Community Develpmnt 143 1,657,637 76,000 1,733,637 115,636 1,238,050 71.4%1,635,441 1,812,850 84,932 1,227,522 75.1%67.7%1,476,187 77,886 1,080,776 73.2% Federal Forest Title III 147 21,000 21,000 28 17,933 21,440 - 217 20,872 97.4%20,164 159 19,656 97.5% Jeff Co Affrdbl Hsg 148 45,131 103,780 148,911 12,465 75,595 50.8%50,363 48,000 4,217 35,856 71.2%74.7%310,493 27,575 222,218 71.6% Homeless Housing Fund 149 272,874 19,234 292,108 37,165 268,700 92.0%304,747 587,282 25,284 216,331 71.0%36.8% Treasurer's O & M 150 54,650 54,650 7 14,239 26.1%49,566 47,624 105 22,871 46.1%48.0%46,224 54 25,075 54.2% REET technology 151 13,816 13,816 1,375 10,664 77.2%15,250 15,690 1,373 11,303 74.1%72.0%16,175 1,428 12,366 76.4% Veteran's Relief 155 65,510 65,510 1,167 50,259 76.7%95,103 89,990 999 50,779 53.4%56.4%105,484 1,586 49,985 47.4% Park & Rec 174 684,549 (9,023) 675,526 1,465 427,744 63.3%665,738 669,649 14,646 484,984 72.8%72.4%674,760 25,471 492,663 73.0% County Park Imprvmnt 175 171,625 31,360 202,985 10,076 90,141 44.4%185,875 160,125 5,848 156,656 84.3%97.8%155,581 6,906 136,150 87.5% Post Harvest Timber Mgmt Rsv178 - - 2 65 209 50 17 164 78.4%327.1% County Roads 180 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%8,929,361 536,454 6,096,022 68.3% Facilities Mgmt *507 eff 7/1/2020183 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%1,121,480 89,578 849,681 75.8% Total Special Revenue 21,873,206 670,237 22,543,443 1,127,971 15,081,577 66.9%21,003,015 22,327,852 1,125,908 15,544,710 75.3%69.6%21,235,218 1,326,066 15,270,557 76.3% FUND Orig Budget Amended BDGT Sep YTD YTD YTD Amended BDGT Sep YTD YTD YTD Sep YTD YTD 2020 2020 2020 2020 %2019 2019 2019 2019 %2018 2018 2,018 % CAPITAL IMPROVEMENT Const/Renovation 301 363,826 363,826 - 58,625 16.1%773,299 518,500 11,368 260,995 33.8%50.3%110,679 24,254 40,371 4.0% Capital Improvement 302 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%1,264,506 117,652 926,146 86.3% Public Infrastructure 306 565,000 565,000 55,739 399,720 70.7%572,302 510,100 50,941 414,587 72.4%81.3%536,758 52,383 388,230 86.0% Conservation Futures 308 271,860 271,860 6,158 170,277 62.6%280,835 258,841 5,818 178,261 63.5%68.9%284,064 8,899 174,978 73.1% Total CAP IMP 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%2,196,007 203,189 1,529,725 55.3% OTHER FUNDS REVENUE REPORT 2020 3 year view ENTERPRISE Solid Waste 401 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%3,680,126 329,690 2,733,970 81.4% Solid Waste Post Clos 402 - - 7 255 1,094 - 87 876 80.1%979 90 697 464.4% Solid Waste Eqpt Res 403 15,000 15,000 144 5,046 33.6%19,648 8,000 1,543 15,582 79.3%194.8%15,780 1,412 10,921 273.0% Yard Waste Educ Fnd 404 7,000 7,000 1 23 0.3%209 6,800 18 167 80.1%2.5%5,765 11 80 1.4% Tri Area Sewer 405 982,500 23,087 1,005,587 121 153,581 15.3%303,778 303,632 1,251 200,776 66.1%66.1%42,268 1,159 9,265 3.6% Total ENTERPRISE 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%3,744,918 332,361 2,754,932 76.0% INTERNAL SERVICE Equipment Rental 501 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%2,950,721 240,860 1,624,501 66.3% Risk Management 502 150,000 150,000 44,549 45,079 30.1%38,522 215,000 - 0 0.0%0.0%27,431 758 27,431 12.8% Benefit Reserve 505 275,000 275,000 17,566 268,331 97.6%257,890 208,000 18,628 213,941 83.0%102.9%239,489 17,389 197,578 95.0% Information Services 506 1,968,639 1,076,937 3,045,576 41,178 1,572,980 51.6%2,116,237 2,197,065 6,092 1,373,585 64.9%62.5%2,004,180 51,233 1,461,463 67.0% Total INT SERV 5,011,384 1,095,820 6,107,204 309,761 3,703,393 60.6%5,328,174 5,759,552 200,355 3,677,376 64.9%63.8%5,221,821 310,240 3,310,973 65.5% Total 33,964,162 2,789,144 36,753,306 2,120,508 24,664,216 67.1%33,394,473 34,401,715 1,847,686 24,105,564 69.0%70.1%32,397,965 2,171,856 22,866,187 72.7% GENERAL FUND CASH BALANCE REPORT 10/4/2020 END OF MONTH CASH BALANCES 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 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$ 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$ 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$ 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$ REQUIRED RESERVE ** (includes 10% of total expenditures and revenue stabilization reserve) 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 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,526,713 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,526,713 Revenue Stabilization $ 100,000 $ 100,000 $ 140,000 $ 440,000 $ 440,000 $ 502,000 $ 726,000 $ 726,000 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 $- $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 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 9 September 9/2/2020 2020 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 2017-19 2020 2020 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 6.7%224,122 303,235 $79,114 135.30%$4,500,882 $1,174,273February224,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.4%311,072 355,834 $44,762 123.15%$4,096,584 $769,975March142,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%219,588 251,543 $31,956 120.65%$4,013,416 $686,807 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%208,334 249,173 $40,839 120.42%$4,005,909 $679,300May198,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 8.4%280,693 267,758 -$12,935 114.77%$3,818,015 $491,406June 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.4%247,577 243,568 -$4,009 107.94%$3,590,720 $264,111July187,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.3%277,705 323,542 $45,838 108.24%$3,600,762 $274,153 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.9%329,733 348,337 $18,604 106.57%$3,545,250 $218,641 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.0%298,735 372,118 $73,383 108.43%$3,606,945 $280,336October213,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 9.4%312,531 - -$312,531 87.81% 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 9.9%328,431 - -$328,431 67.48% 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 8.7%288,089 - -$288,089 46.26% 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 2,715,110 100.0%$3,326,609 $2,715,110ytd 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 2,397,558 2,715,110 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%13.24%over (under) ytd expected annual % chg.6.84%-0.64%-1.77%-11.33%-10.25%2.64%3.98%14.73%-2.03%8.07%10.12%5.04%11.09%12.72% Special Purp./Public Safety Tax Cumulative Cumulative Year End Actual 3 yr avg.Projection Actual Over/Under % of projection 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2017-19 2020 2020 Expected expected Projection Over/Under January 45,217 50,919 50,377 51,210 58,026 61,161 66,993 79,236 84,751 7.0%73,057 84,751 $11,695 116.01%$1,212,562 $167,318 February 61,899 70,678 67,508 73,364 83,521 93,242 90,853 94,690 101,181 9.4%98,207 101,181 $2,973 103.03%$1,076,892 $31,648March40,604 56,106 49,782 50,931 62,285 61,183 66,479 70,614 72,888 6.7%69,846 72,888 $3,042 104.35%$1,090,764 $45,520April43,155 51,054 47,573 52,541 59,481 59,911 63,784 65,310 69,887 6.4%66,580 69,887 $3,306 104.97%$1,097,151 $51,907May51,908 58,324 56,012 62,613 74,233 78,716 84,357 88,754 75,138 8.5%88,710 75,138 -$13,572 84.70%$885,324 -$159,920 June 45,930 46,797 50,067 48,647 58,717 65,832 65,229 75,141 77,429 68,693 7.3%76,724 68,693 -$8,031 89.53%$935,839 -$109,405July55,488 49,385 68,295 54,074 56,793 69,908 73,136 81,117 89,815 86,275 8.2%85,977 86,275 $298 100.35%$1,048,866 $3,622August59,578 56,220 56,063 68,712 76,734 87,275 89,679 97,261 107,514 94,459 9.9%103,727 94,459 -$9,268 91.07%$951,853 -$93,391September55,746 54,902 61,455 64,622 72,022 77,854 77,534 97,036 94,733 96,212 9.1%94,867 96,212 $1,345 101.42%$1,060,065 $14,821 October 59,692 61,120 64,400 64,152 73,903 82,028 82,991 95,473 97,187 9.3%97,103 - -$97,103 0.00% November 58,107 60,952 64,915 71,491 77,947 89,596 90,736 98,020 105,075 9.9%103,507 - -$103,507 0.00% December 46,767 49,281 52,177 59,043 62,263 66,133 69,582 83,431 93,783 8.3%86,938 - -$86,938 0.00% TOTAL 381,308 621,440 704,453 701,993 769,039 876,170 903,099 999,945 1,064,140 749,484 100.0%1,045,244 749,484 ytd 216,742 450,087 522,961 507,307 554,926 638,413 659,790 723,021 768,095 749,484 757,695 $749,484 ytd change 16.19%-2.99%9.39%15.04%3.35%9.58%6.23%-2.42%-1.08%over (under) ytd expectedannual % chg.62.98%13.36%-0.35%9.55%13.93%3.07%10.72%6.42% 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 projection Sales Tax 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2017-19 2020 2020 Expected expected Projection Over/Under General & Optional YTD1,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 #VALUE!2,397,558 3,464,594 - - - Special Purpose YTD - - - - - - 216,742 450,087 522,961 507,307 554,926 638,413 659,790 723,021 768,095 749,484 757,695 749,484 - - - G&O and SP Sales Tax YTD1,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 #VALUE!3,155,254 4,214,077 - - - Full Year Total Actual w/ 2020 Budget2,311,638 2,469,708 2,453,909 2,410,507 2,137,279 1,918,151 2,350,098 2,668,593 3,053,126 3,002,929 3,255,650 3,614,414 3,779,438 4,195,203 4,665,900 4,371,853 3,464,594 4,371,853 - - MONTHLY SALES TAX GENERAL & OPTIONAL AND SPECIAL PURPOSE Revenue Cumulative Cumulative Year End 3 yr. avg Expected Actual Over/Under % of projection 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2017-19 2020 2020 Expected expected ProjectionYear End Projected Over/Under Budget 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 8.9%297,178 387,987 $90,808 130.56%$5,713,443 $1,341,590 February 224,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 12.2%409,279 457,015 $47,736 111.66%$5,173,476 $801,623March142,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 8.7%289,434 324,431 $34,997 112.09%$5,104,180 $732,327April156,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 8.2%274,914 319,060 $44,145 116.06%$5,103,060 $731,207 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 11.0%369,403 342,896 -$26,507 92.82%$4,703,340 $331,487 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 9.7%324,301 312,261 -$12,040 96.29%$4,526,560 $154,707July187,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 10.9%363,682 409,818 $46,136 112.69%$4,649,628 $277,775August220,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 13.0%433,460 442,796 $9,337 102.15%$4,497,103 $125,250 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 11.8%393,602 468,330 $74,728 118.99%$4,667,010 $295,157 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 - 12.2%409,634 - 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 - 12.9%431,938 - 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 - 11.2%375,028 - TTL 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 3,464,594 109.6%$4,371,853 $3,464,594 ytd 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 3,155,254 3,464,594 ytd change 9.63%-2.30%-1.03%-9.16%-12.08%19.19%13.99%18.68%-4.16%8.88%10.49%5.95%9.04%10.42%3.92%9.80%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% - 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 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 2020 - 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 Sales Tax and Special Purpose Sales Tax YTD, Actual Total and 2020 Budget Special Purpose YTD General & Optional YTD Full Year Total Actual w/ 2020Budget September 2020 - 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 2020 Expected 2020 -$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 Year End Projected Over/UnderBudget YTD Budget YTD Actual $0.00 September 5/7/2020 Sales Tax 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 General & Optional YTD 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 Special Purpose YTD - - - - - - 216,742 450,087 522,961 507,307 554,926 638,413 659,790 723,021 768,095 749,484 G&O and SP Sales Tax YTD 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 Full Year Total: 2020 is YTD Actual & 2020 Budget2,311,638 2,469,708 2,453,909 2,410,507 2,137,279 1,918,151 2,350,098 2,668,593 3,053,126 3,002,929 3,255,650 3,614,414 3,779,438 4,195,203 4,665,900 4,681,193 - 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 Sales Tax Total Received YTD General & Optional YTD Special Purpose YTD 2020 - 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 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 Budget 2020SeptemberSeptember CATEGORY ANALYSIS BY CODE 1600, 1650 Jefferson County Run Date: 08/10/2020 Current Period: 202005 Cash Basis, Revenue Amounts Current Period: 202007 Cash Basis, Revenue Amounts $113,830,751 This Year Last Year % Chg This Year Last Year % Chg Last 12 Months Unclassified 14,388 12,989 11 114,049 110,310 3 158,968 Agriculture, Forestry, Fishing and Hunting 142 694 (80)4,063 5,883 (31)5,854 Mining, Quarrying, and Oil and Gas Extraction -113 461 (125)5,092 4,229 20 7,069 Utilities 42 631 (93)1,016 2,706 (62)2,119 Construction 100,401 82,111 22 777,921 691,147 13 1,114,984 Manufacturing 6,916 9,419 (59)73,555 68,978 18 100,097 Wholesale Trade 16,890 16,868 0 154,754 160,188 (3)206,706 Retail Trade 146,479 104,646 77 962,925 827,344 33 1,269,909 Transportation and Warehousing 746 1,518 121 6,311 10,608 (34)9,192 Information 11,901 10,891 9 104,036 96,732 8 137,879 Finance and Insurance 1,352 1,758 (23)10,916 11,232 (3)15,015 Real Estate and Rental and Leasing 5,726 5,577 3 47,748 44,570 7 66,969 Professional, Scientific, and Technical Services 3,402 4,222 (19)41,925 51,682 (19)54,590 Admin & Support, Waste Mgmt & Remediation Svcs 23,248 16,284 43 174,742 144,756 21 224,071 Educational Services 180 129 40 1,849 2,550 (27)4,050 Health Care and Social Assistance 510 566 (10)3,909 4,457 (12)4,933 Arts, Entertainment, and Recreation 4,023 5,452 (26)14,855 20,637 (28)25,279 Accommodation and Food Services 28,966 37,739 (23)156,941 235,160 (33)260,022 Other Services (except Public Administration)6,487 5,742 (40)52,362 60,592 901 71,241 Public Administration 433 1,912 (77)6,142 12,209 (50)11,952 Totals 372,118 319,609 16 2,715,110 2,565,970 6 3,750,901 Current Period Year to Date Unclassified, 14,388, 4% Agriculture, Forestry, Fishing and Hunting, 142, 0% Mining, Quarrying, and Oil and Gas Extraction, - 113, 0% Utilities, 42, 0% Construction, 100,401, 27% Manufacturing, 6,916, 2% Wholesale Trade, 16,890, 5% Retail Trade, 146,479, 39% Transportation and Warehousing, 746, 0% Information, 11,901, 3% Finance and Insurance, 1,352, 0% Real Estate and Rental and Leasing, 5,726, 2% Professional, Scientific, and Technical Services, 3,402, 1% Admin & Support, Waste Mgmt & Remediation Svcs, 23,248, 6% Educational Services, 180, 0% Health Care and Social Assistance, 510, 0% Arts, Entertainment, and Recreation, 4,023, 1% Accommodation and Food Services, 28,966, 8% Other Services (except Public Administration), 6,487, 2% Current Period This Year, Total Taxable Sales Unclassified Agriculture, Forestry, Fishing and Hunting Mining, Quarrying, and Oil and Gas Extraction Utilities 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 Other Services (except Public Administration) July 2020 Sales Data $113,830,751 11 (80) (125) (93) 22 (59) 0 77 121 9 (23) 3 (19) 43 40 (10) (26)(23) (40) (150) (100) (50) 0 50 100 150 -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 Period: 9 September 302-000-010 Capital Improvement fund, not other financing sources, transfer, appropriation Recent 2020 % Budget Month Change 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 4 YR AVG Budget 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 62,517 57,998 19.1%7.1% 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 53,990 50,087 68.8%63.0% 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 82,177 76,237 23.3%14.4% 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 86,955 80,670 -2.2%-12.0% 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 114,808 106,509 -28.7%-31.5% 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 160,276 148,690 38.3%95.9% 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 114,120 105,871 51.8%17.6% 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 124,449 115,453 40.9%24.2% 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 124,986 115,952 82.6%101.5% 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 125,931 116,828 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 100,356 93,102 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 95,845 88,917 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,143,245 1,246,409$ 1,156,313$ -1.1%-8.2% YTD 1,091,749 1,164,248 735,766 519,454 423,762 $187,136 348,570 365,001 460,393 495,771 926,194 942,154 951,966 926,146 876,841 1,143,245 924,277$ 857,466$ 33.3%30.4% YTD change 6.64%-36.80%-29.40%-18.42%-55.84%10.20%4.71%26.13%7.68%86.82%1.72%1.04%-2.71%-5.32%30.38% Annual % chg 6.64%-36.80%-29.40%-18.42%4.08%23.83%28.91%-0.49%69.93%3.41%3.84%-5.35%2.42% Actual Full Year or Budget $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,156,313 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 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 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 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 Jun 2019 1@$2.36M & 1@ $1.275M, 7>$500k Dec 2019 1@$2.61, 4@$1+,10>$500k June 2020 3 sales over $1M: $9.9M, $1.07M & $1.375M; and 19 sales>$500k 10/4/2020 $0 $200,000 $400,000 $600,000 $800,000 $1,000,000 $1,200,000 $1,400,000 $1,600,000 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Real Estate Excise Tax Collections -2005 to 2020 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 REET YTD, Actual Total and 2020 Budget YTD Actual YTD Budget 0 50,000 100,000 150,000 200,000 250,000 2020 Monthly Actual Revenue & Budgeted Share 2020 Actual Budget September September 10/4/2020 4 yr avg *2020 2020 % Budget % Diff 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2016-19 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 22,725 22,792 32,023 40.5%7.3% February 27,998 25,532 23,188 38,274 30,356 36,141 51,077 53,093 46,226 41,186 34,092 47,895 48,037 34,092 -29.0%-17.2% March 22,623 12,406 7,271 11,203 12,715 14,345 14,554 16,889 19,419 25,281 29,621 19,035 19,092 29,621 55.2%17.2% April 11,344 10,791 14,950 11,430 12,427 14,983 18,530 20,901 23,749 22,829 29,140 21,502 21,566 29,140 35.1%27.6% May 19,646 25,142 17,142 18,010 19,151 23,886 29,462 45,943 41,061 41,546 11,527 39,503 39,620 11,527 -70.9%-72.3% June 19,205 17,302 17,916 16,477 18,786 25,070 29,476 31,485 36,556 43,299 742 35,204 35,308 742 -97.9%-98.3% July 20,155 19,311 20,201 21,512 24,536 27,711 33,687 38,400 44,445 48,748 24,074 41,320 41,442 24,074 -41.9%-50.6% August 35,178 24,742 31,171 33,140 37,534 48,845 56,349 64,820 64,934 70,516 41,591 64,155 64,345 41,591 -35.4%-41.0% September 41,757 42,500 40,882 39,890 42,349 44,713 53,487 56,561 68,870 88,306 79,681 66,806 67,004 79,681 18.9%-9.8% October 43,012 43,861 41,015 41,741 43,659 49,182 59,970 58,458 65,200 60,682 61,077 61,258 November 44,351 38,547 36,906 39,146 46,879 58,967 57,999 69,054 63,101 65,013 63,792 63,980 December 19,873 21,703 11,109 15,514 33,858 25,213 26,084 32,870 46,067 42,545 36,892 37,001 Full Year 321,231 293,344 273,796 295,200 335,825 386,107 449,148 507,868 542,805 579,805 282,492 519,906 521,444 282,492 YTD 213,995 189,233 184,766 198,799 211,429 252,746 305,095 347,485 368,436 411,565 282,492 358,145 359,205 282,492 -21.4%-31.4% Full Year Actual/2020 Budget321,231 293,344 273,796 295,200 335,825 386,107 449,148 507,868 542,805 579,805 521,444 YTD Change 15.70%-2.36%7.60%6.35%19.54%20.71%13.89%6.03%11.71%-31.36% Annual % Change 0.24%-6.66%7.82%13.76%14.97%16.33%13.07%6.88%6.82%$521,444 2020 Budget 2% Basic RCW 67.28.181(1).RCW 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 December November October September August July June May April March February January Full Year Actual/2020 Budget $0 $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 2020 YTD Actual and Budget YTD Actual YTD Budget 0 20,000 40,000 60,000 80,000 100,000 2020 Monthly Actual and Budget 2020 Actual Budget September