Loading...
HomeMy WebLinkAbout2021-08_August_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 August 2021 Revenue Report • General Fund at $15,003,144 – 68.5% of the 2021 budget year to date which is higher than previous years. The second sheet shows general fund revenue charts showing 2015-2021 year to date detail and percentage of actual full year collections. Second Quarter appropriations are reflected in the budget. • Other Funds at $27,789,904– 68.8,% of 2021 budget year to date which is a lot higher than previous years. Budget appropriations are reflected, and fund 123 for Grant Management was adjusted for ARPA funds received of $3.157 million. • General Fund Cash Balance - $8.375 million at the end of August which includes the 3.7 million reserve. • General Sales Tax Receipts - $565,446 which includes $123,789 for Special Purpose in August 2021. Cumulatively, this is 24% over budget year to date. If it holds we’re forecasted for about $1.35 million over budget for the year. • Sales Tax by Sector: Sales tax composition by category reflects funds receipted in June for August distribution for all of Jefferson County including the City of Port Townsend. • REET Receipts - Fund 302 - $305,424 in August which is 181% over budget and 87% over what it was this month last year. We had a total of 45 sales over $500,000 with eight properties selling in unincorporated Jefferson County for over $1 million. The top two sales totaling $15 million were designated forest land on the west end. If it holds, the projection is to come in $1.5 million over the original 2021 budget. • Hotel/Motel Lodging Tax – Fund 125 - $85,104 in August. This puts it 39% over budget for the month. Year to date, revenue is 129% over budget, and if it holds, the projection is to end the year $347,000 over budget. 2021 8 August Jefferson County Treasurer 22-Sep-2021 Jefferson County Treasurer REVENUE NAME BARS BUDGET AMENDED AUG Y-T-D Y-T-D Y-T-D BUDGET QTRLY AMENDED ACTUAL AUG Y-T-D Y-T-D ACTUAL AUG Y-T-D Y-T-D *2021 ANNUAL & QTRLY Approp Budget 2021 2021 2021 % of Amended Budget Over/Under Amended Budget 2020 Approp Budget 2020 2020 2020 2020 % of Actual 2019 2019 2019 % of ActualProperty Tax 1 311.10 8,538,738 (133,567)8,405,171 55,998 4,938,135 58.8%(3,467,036)8,290,037 268,714 8,558,751 8,148,279 59,634 4,801,218 58.9%7,992,860 53,574 4,658,973 58.3%Diverted Road Prop Tax 1 311.20 720,000 0 720,000 5,038 430,611 59.8%(289,389)720,000 720,000 720,000 5,687 427,054 59.3%720,000 5,191 421,964 58.6%Sales Tax 1 313.11 3,453,021 270,910 3,723,931 441,657 2,895,205 77.7%(828,726)3,326,609 3,326,609 3,772,767 348,337 2,342,991 62.1%3,601,761 355,294 2,246,361 62.4% special purpose 313.15 1,084,963 (64,180)1,020,783 123,789 797,176 78.1%(223,607)1,045,244 1,045,244 1,020,826 94,459 653,272 64.0%1,064,119 107,514 673,342 63.3%Local Criminal Justice 1 313.71 438,710 (3,314)435,396 51,143 332,695 76.4%(102,701)422,650 422,650 427,244 39,580 272,218 63.7%442,239 44,629 279,742 63.3%Leasehold Excise Tax 3 317.20 66,801 12,297 79,098 20,271 63,554 80.3%(15,544)66,801 66,801 79,122 21,170 59,895 75.7%75,500 19,167 56,297 74.6%Private Harvest Tax - TAV 2 317.40.10/.20 339,599 0 339,599 0 184,561 54.3%(155,038)339,599 339,599 281,066 71,714 209,039 74.4%363,246 89,840 349,118 96.1%P.I.L.T. (incl DNR)4 332.15.23/336.02.31 1,035,150 623,245 1,658,395 (26,490)1,643,245 99.1%(15,150)1,015,150 1,015,150 1,588,729 - 1,572,825 99.0%1,553,455 - 1,537,328 99.0%P.U.D. Privilege Tax 4 335.00.91 398,151 11,789 409,940 0 398,969 97.3%(10,971)386,555 386,555 398,063 - 398,063 100.0%385,397 - 385,397 100.0%Crim Just Hi Crime/DUI/Asst 5 336.06.10/51 465,324 (5,324)460,000 0 420,091 91.3%(39,909)451,770 451,770 522,693 - 385,846 73.8%336,086 - 333,709 99.3% Marijuana Excise 6 336.06.41/42 54,124 (3,604)50,520 0 22,054 43.7%(28,466)52,548 52,548 46,636 - 24,461 52.4%170,903 - 24,224 14.2%Liquor Excise Tax 8 336.06.94 49,233 9,464 58,697 0 50,907 86.7%(7,791)48,267 48,267 61,396 - 43,836 71.4%51,439 - 37,729 73.3% Liquor Profit 6 336.06.95 92,463 (7,294)85,169 0 41,652 48.9%(43,517)90,650 90,650 83,340 - 41,687 50.0%83,623 - 41,936 50.1%Treasurer Invest & Other Fees 1 341.42.15-20/50 35,830 (11,213)24,617 1,051 11,560 47.0%(13,057)35,830 35,830 32,773 495 19,160 58.5%43,596 2,469 25,660 58.9% Treas. Collection Fees (REET)3 341.42.31/32/33 87,175 (11,870)75,305 16,321 81,631 108.4%6,326 87,175 87,175 92,802 8,428 48,410 52.2%85,234 9,518 55,252 64.8%Penalties on delinquent taxes 1 359.40.10/.20 122,152 6,119 128,271 6,062 87,252 68.0%(41,019)119,757 119,757 128,759 6,921 91,961 71.4%113,976 6,195 81,243 71.3% Investment Income 1 361.11 727,260 (305,372)421,888 114,798 226,302 53.6%(195,586)713,000 713,000 380,191 105,331 345,277 90.8%1,028,831 78,189 837,087 81.4%Interest on delinquent taxes 1 361.40.10 196,162 30,454 226,616 10,147 188,048 83.0%(38,568)192,316 192,316 244,045 12,196 175,967 72.1%224,004 21,394 156,648 69.9% Interfund Chg Svc-Cost Alloc 3 362.50.00.180/0671 349,707 (98,445)251,262 0 31,822 12.7%(219,440)339,521 339,521 243,461 - 29,207 12.0%232,066 - 28,985 12.5%DNR Timber & DNRTimbTrust 2 1 395.1.1/335.02.33 250,000 0 250,000 2,801 24,591 9.8%(225,409)250,000 250,000 525,780 11,382 214,087 40.7%352,075 1,443 330,417 93.8%Transfer in 1 397.00 3,000 7,000 10,000 750 30,772 307.7%20,772 3,000 24,074 27,074 36,847 750 26,322 71.4%21,798 750 21,048 96.6%Miscellaneous *10.30/362.50.1/369.81/369.9 27,784 (10,919)16,865 1,129 131,797 781.5%114,932 27,784 27,784 62,869 1,254 9,103 14.5%111,997 1,864 11,503 10.3%Assessor 1 001-010-000 8,300 0 8,300 1,777 5,529 66.6%(2,771)8,300 8,300 7,943 1,884 5,729 72.1%9,642 1,828 5,732 59.5%Auditor-Recording Fees 1 341.21.10 69,495 0 69,495 8,513 74,835 107.7%5,340 69,495 69,495 95,307 7,905 58,041 60.9%69,039 6,452 42,312 61.3%Auditor-M.V. License Fees 1 341.48+/336.00.93 246,440 16,370 262,810 19,876 248,020 94.4%(14,790)246,440 16,370 262,810 322,944 54,820 220,768 68.4%302,603 63,379 210,515 69.6%Auditor-Other Revenue 1 35,330 0 35,330 1,419 58,260 164.9%22,930 35,330 5,696 41,026 29,104 1,817 15,602 53.6%35,127 3,404 23,933 68.1%Elections 1 001-021-000 161,195 73,000 234,195 0 55,560 23.7%(178,635)116,110 116,110 326,422 0 309,648 94.9%161,606 - 103,962 64.3%Clerk 1 001-050-000 141,663 (17,798)123,865 9,557 83,515 67.4%(40,350)149,591 149,591 144,678 11,420 89,390 61.8%149,436 15,583 100,499 67.3%County Administrator 1 001-059-000 3,700 300 4,000 0 4,000 100.0%0 438,600 438,600 4,000 0 4,000 100.0%4,260 - 4,260 100.0%Commissioners 1 001-060-000 8,000 0 8,000 874 7,755 96.9%(245)8,000 8,000 10,230 904 6,202 60.6%7,843 727 4,916 62.7%Safety & Security/Emergency Mg 1 001-067-000 75,538 22,811 98,349 0 49,492 50.3%(48,857)75,538 75,538 67,399 0 67,399 100.0%36,232 - 28,578 78.9%Community Services 1 001-068-000 4,172 0 4,172 57 3,040 72.9%(1,132)4,155 4,155 3,867 40 2,951 76.3%3,987 (15,923) 3,067 76.9%District Court 1 001-080-000 655,380 (17,300)638,080 36,102 310,653 48.7%(327,427)644,505 644,505 579,650 31,287 316,798 54.7%682,644 40,182 401,129 58.8%Juvenile Service 1 001-110-000 278,783 3,147 281,930 43,007 201,480 71.5%(80,450)279,284 279,284 314,628 68,089 219,152 69.7%243,744 31,613 165,873 68.1%Prosecuting Attorney 1 001-150-000 236,251 0 236,251 12,517 178,796 75.7%(57,455)320,633 88,000 408,633 237,412 12,517 101,030 42.6%257,902 25,005 164,788 63.9%Coroner 1 001-151-000 25,348 0 25,348 6,855 15,255 60.2%(10,093)25,348 25,348 13,958 6,000 13,958 100.0%18,324 6,400 18,324 100.0%Sheriff 1 001-180-000 577,054 344,609 921,663 72,231 528,343 57.3%(393,320)794,303 263,000 1,057,303 942,051 53,427 538,089 57.1%1,141,545 30,039 676,377 59.3% Superior Court 1 001-240-000 59,547 0 59,547 0 17,223 28.9%(42,324)59,421 59,421 41,617 238 7,738 18.6%50,414 220 7,940 15.7% Non Departmental 1 001-261/270-000 36,990 0 36,990 76,254 128,759 348.1%91,769 35,568 2,448,500 2,484,068 2,627,644 23,127 62,100 2.4%39,722 1,280 35,852 90.3% TOTAL CURRENT EXPENSE REVENUE 21,158,533 741,315 21,899,848 1,113,504 15,003,144 68.5%(6,896,704)21,334,884 3,114,354 24,449,238 24,666,543 1,060,814 14,230,493 57.7%22,268,272 1,007,220 14,592,019 65.5% * Revenue Schedule 1 monthly , 2 Feb/May/Aug/Nov, 3 Feb/Apr/Jun/Aug/Oct/Dec, 4 Jun 5 Jan/Apr/Jul/Oct 6 Mar/Jun/Sep/Dec 7 Nov 8 Var REFUND EXPEND CY/PRIOR excl 388/89 0 (733)17,164 0 52,695 531 27,645 15,471 29,772 *July 2021 LE & CJ One Time Cost 125,339 August2021 GENERAL FUND REVENUE 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021Property Tax 3,966,338 4,073,940 4,016,093 4,098,054 4,190,900 4,261,692 4,350,081 4,423,830 4,509,061 4,658,973 4,801,218 4,938,135Diverted Road Prop Tax 409,369 412,733 414,709 415,866 418,550 427,668 420,216 420,267 417,288 421,964 427,054 430,611Sales Tax 1,232,147 1,289,596 1,217,815 1,545,280 1,453,480 1,582,977 1,727,952 1,868,018 1,988,733 2,246,361 2,342,991 2,895,205 special purpose 0 160,996 395,184 461,207 442,686 482,904 560,560 582,256 625,985 673,342 653,272 797,176Local Criminal Justice 166,053 173,988 166,089 192,380 184,517 200,118 232,864 241,615 261,338 279,742 272,218 332,695Leasehold Excise Tax 38,163 42,042 40,542 44,375 48,417 44,462 44,666 50,748 48,627 56,297 59,895 63,554Private Harvest Tax 90,580 218,466 254,250 324,269 358,822 366,366 252,332 311,003 379,277 349,118 209,039 184,561P.I.L.T. (incl DNR)397,957 486,246 641,300 1,283,164 1,330,422 1,253,823 1,422,312 1,390,772 1,833,818 1,537,328 1,572,825 1,643,245P.U.D. Privilege Tax 50,666 16,788 31,380 32,775 225,457 370,446 318,107 314,148 393,491 385,397 398,063 398,969Crim Just Hi Crime/DUI/Asst 250,761 241,639 248,813 278,952 347,828 359,931 367,324 327,664 320,837 333,709 385,846 420,091Marijuana Enforcement/Excise 0 0 0 0 0 - 25,568 11,354 39,588 24,224 24,461 22,054Liquor Excise Tax 27,662 28,998 31,873 0 9,683 11,894 30,739 32,161 34,380 37,729 43,836 50,907Liquor Profit 36,094 35,925 53,297 42,426 42,354 42,582 42,439 42,310 42,130 41,936 41,687 41,652Treasurer Invest & Other Fees 4,408 3,794 2,992 2,749 1,703 2,604 6,858 24,461 33,256 25,660 19,160 11,560Treas. Collection Fees (REET)18,243 18,801 21,018 25,340 28,366 46,951 57,423 58,015 55,584 55,252 48,410 81,631Penalties on delinquent taxes 54,083 87,856 73,083 81,252 91,226 76,435 78,457 65,994 72,844 81,243 91,961 87,252Investment Income 136,584 77,490 41,991 13,344 16,891 34,928 611,048 270,868 331,255 837,087 345,277 226,302Interest on delinquent taxes 93,477 139,956 134,227 143,990 160,785 147,428 152,594 132,572 136,785 156,648 175,967 188,048Interfund Chg Svc-Cost Alloc 0 0 0 39,051 0 26,255 26,537 30,577 206,731 28,985 29,207 31,822DNR Timber 53,523 502,789 219,885 68,321 253,529 365,227 257,543 94,176 44,717 330,417 214,087 24,591Transfer in 0 0 0 0 0 5,000 22,437 20,296 19,944 21,048 26,322 30,772Miscellaneous227,634 153,274 22,097 39,813 25,216 25,749 15,993 5,024 11,969 11,503 9,103 131,797Assessor1,185 826 2,936 228,791 10,495 619 6,135 8,129 5,840 5,732 5,729 5,529Auditor-Recording Fees 41,875 42,274 46,802 53,419 37,227 47,780 48,209 48,264 47,848 42,312 58,041 74,835Auditor-M.V. License Fees 109,833 108,200 108,527 113,839 113,565 112,105 185,420 160,401 188,578 210,515 220,768 248,020Auditor-Other Revenue 23,005 23,095 21,682 23,733 23,727 69,191 20,417 20,348 23,743 23,933 15,602 58,260Elections112,964 61,374 57,758 46,785 72,862 56,721 151,935 55,987 93,388 103,962 309,648 55,560Clerk132,796 130,203 137,645 139,394 140,665 142,750 131,291 120,444 120,160 100,499 89,390 83,515County Administrator 0 0 0 0 0 - - - 4,260 4,260 4,000 4,000Commissioners6,515 4,970 10,075 6,745 4,972 5,773 5,670 5,772 5,902 4,916 6,202 7,755Safety & Security 54,795 28,415 34,015 38,633 28,735 30,334 52,836 47,355 41,545 28,578 67,399 49,492Community Services 0 4,445 914 4,261 3,147 3,292 2,857 3,857 3,228 3,067 2,951 3,040District Court 359,812 436,902 410,676 408,875 396,287 460,147 450,185 432,362 491,420 401,129 316,798 310,653Juvenile Service 166,083 171,077 133,209 216,760 171,625 162,240 169,014 183,907 183,834 165,873 219,152 201,480Prosecuting Attorney 199,704 196,158 134,120 113,151 111,207 167,110 93,198 118,699 88,534 164,788 101,030 178,796Coroner4,640 14,080 6,380 11,032 3,480 11,140 8,340 24,610 32,723 18,324 13,958 15,255Sheriff650,540 630,631 417,419 448,074 340,739 372,982 417,361 436,531 386,593 676,377 538,089 528,343Superior Court 19,976 5,329 3,000 4,844 3,000 4,532 20,732 67,739 37,764 7,940 7,738 17,223Non Departmental 0 0 0 0 0 - 10 10 32,802 35,852 62,100 128,759TOTAL CURRENT EXPENSE 9,137,465 10,023,296 9,551,796 10,990,944 11,092,564 11,782,155 12,787,660 12,452,543 13,595,799 14,592,019 14,230,493 15,003,144TOTAL CURRENT EXPENSE ACTUAL/2020 BUDGET 15198876 16349133 15531592 16964139 17374434.53 18,950,211 19,247,758 19,181,590 20,890,820 22,268,272 24,666,543 21,899,848 YTD % of Full Year Actual/2021 Budget 60.1%61.3%61.5%64.8%63.8%62.2%66.4%64.9%65.1%65.5%57.7%68.5% 0 2,000,000 4,000,000 6,000,000 8,000,000 10,000,000 12,000,000 14,000,000 16,000,000 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 GENERAL FUND REVENUE YTD Non Departmental Superior Court Sheriff Coroner Prosecuting Attorney Juvenile Service District Court Community Services Safety & Security Commissioners County Administrator Clerk Elections Auditor-Other Revenue Auditor-M.V. License Fees Auditor-Recording Fees Assessor Miscellaneous Transfer in DNR Timber Interfund Chg Svc-Cost Alloc Interest on delinquent taxes Investment Income Penalties on delinquent taxes Treas. Collection Fees (REET) Treasurer Invest & Other Fees Liquor Profit Liquor Excise Tax Marijuana Enforcement/Excise Crim Just Hi Crime/DUI/Asst P.U.D. Privilege Tax P.I.L.T. (incl DNR) Private Harvest Tax Leasehold Excise Tax Local Criminal Justice special purpose Sales Tax Diverted Road Prop Tax Property Tax 2021 60.1%61.3%61.5%64.8%63.8%62.2% 66.4%64.9%65.1%65.5% 57.7% 68.5% 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 August2021 August OTHER FUNDS REVENUE REPORT 2021 3 year view August 8 9/27/2021 FUND Fund #Orig Budget Budget Amended BDGT Aug YTD YTD Orig Budget Budget Amended BDGT Jun YTD YTD ACTUAL Amended BDGT Jun YTD ACTUAL YTD AMEND BUDGET YTD 2021 Amendment 2021 2021 2021 %2020 Amendment 2020 2020 2020 %2019 2019 2019 2019 %% SPECIAL REVENUE Elections CARES Act 103 - - - 5.64 n/a - 153,422 153,422 153,422 153,462 n/a HAVA 3 Grant 104 - - 24 89.41 n/a - 123,419 123,419 - 123,428 n/a Auditor's O & M 105 77,900 77,900 3,083 101,965.81 130.9%77,900 566 78,466 3,074 73,431 93.6%72,512 80,480 2,304 62,080 85.6%77.1% Court Facilitator 106 4,000 (1,280) 2,720 420 2,280.00 83.8%4,500 4,500 220 1,840 40.9%4,300 4,100 500 3,220 74.9%78.5% Boating Safety 107 50,000 (5,500) 44,500 - 33,553.03 75.4%50,000 50,000 - 30,384 60.8%50,138 50,138 - 50,138 100.0%100.0% WSU Cooperative 108 401,431 25,487 426,918 51,014 252,624.92 59.2%532,762 (53,107) 479,655 4,011 358,427 74.7%352,814 468,922 1,947 288,776 81.8%61.6% Noxious Weed 109 203,717 (5,000) 198,717 1,053 141,395.71 71.2%217,717 (23,700) 194,017 2,462 109,305 56.3%198,125 260,816 1,763 109,777 55.4%42.1% 4-H After School 113 Moved to Fund 108 - Moved to Fund 108 - 49,508 47,600 12,000 62,700 126.6%131.7% JeffComCap 119 119 276,600 276,600 23,050 184,400.00 66.7%206,640 206,640 17,220 137,760 66.7%204,000 204,000 17,000 136,000 66.7%66.7% Crime Victim's Svc 120 81,543 81,543 2,559 76,267.36 93.5%81,543 81,543 1,737 85,768 105.2%127,920 140,813 418 93,928 73.4%66.7% Grant Mgmt 123 150,000 3,261,793 3,411,793 - 3,366,908.10 98.7%150,000 251,680 401,680 - 64,749 16.1%119,570 150,000 - 79,852 66.8%53.2% Hotel-Motel 125 537,087 537,087 85,252 488,516.71 91.0%521,444 521,444 742 201,749 38.7%579,805 500,500 43,299 323,259 55.8%64.6% Jeff Co Public Health 127 4,820,115 79,415 4,899,530 702,988 4,221,136.09 86.2%4,994,011 697,569 5,691,580 342,105 3,630,113 63.8%4,758,462 4,651,629 338,140 3,318,335 69.7%71.3% Water Quality 128 1,365,704 (2,227) 1,363,477 119,928 961,258.38 70.5%1,307,279 1,307,279 117,433 726,956 55.6%1,025,077 1,163,949 75,384 654,109 63.8%56.2% 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 452 29,969.63 57.9%50,289 50,289 960 30,255 60.2%50,299 47,637 366 30,734 61.1%64.5% Chem Dep Mnt Hlth tx 131 561,734 (26,465) 535,269 69,992 455,720.25 85.1%553,433 553,433 38,748 373,198 67.4%612,026 527,003 44,296 389,476 63.6%73.9% JC Inmate Commissary 134 41,500 (2,500) 39,000 542 9,566.40 Drug Fund 135 14,240 14,240 24 886.22 6.2%13,850 13,850 2,600 5,378 38.8%5,982 12,249 197 4,675 78.2%38.2% Law Library 140 11,591 4,827 16,418 858 10,285.88 62.7%16,081 16,081 575 9,915 61.7%9,149 10,927 591 5,979 65.4%54.7% Trial Court Imprvmnt 141 23,690 23,690 7,079 21,237.00 89.6%23,000 23,000 - 21,252 92.4%22,806 23,000 - 17,103 75.0%74.4% Community Develpmnt 143 1,505,632 479,114 1,984,746 231,394 1,659,901.58 83.6%1,657,637 155,230 1,812,867 139,690 1,122,413 61.9%1,635,441 1,812,850 104,529 1,142,589 69.9%63.0% Federal Forest Title III 147 21,000 21,000 35 15,993.43 21,000 21,000 54 17,904 21,440 - 236 20,655 96.3% Jeff Co Affrdbl Hsg 148 45,582 520,048 565,630 83,084 282,349.93 49.9%45,131 103,780 148,911 9,501 63,130 42.4%50,363 48,000 4,174 31,638 62.8%65.9% Homeless Housing Fund 149 275,603 145,000 420,603 63,614 354,374.74 84.3%272,874 187,319 460,193 32,506 231,534 50.3%304,747 587,282 25,303 191,047 62.7%32.5% Treasurer's O & M 150 55,750 (1,000) 54,750 329 14,115.23 25.8%54,650 54,650 4,033 14,233 26.0%49,566 47,624 6,049 22,766 45.9%47.8% REET technology 151 13,401 13,401 1,713 188,025.65 1403.1%13,816 13,816 1,073 9,289 67.2%15,250 15,690 1,378 9,930 65.1%63.3% Veteran's Relief 155 66,050 66,050 486 50,279.66 76.1%65,510 65,510 984 49,092 74.9%95,103 89,990 558 49,780 52.3%55.3% Water Pollution Cntrl 160 - - - - 36,278.64 - - - - - Park & Rec 174 698,883 (37,881) 661,002 238,293 574,120.50 86.9%684,549 (9,023) 675,526 (610) 426,279 63.1%665,738 669,649 7,552 470,338 70.6%70.2% County Park Imprvmnt 175 208,500 (47,000) 161,500 46,224 97,073.83 60.1%171,625 31,360 202,985 2,661 80,065 39.4%185,875 160,125 100,074 150,808 81.1%94.2% Post Harvest Timber Mgmt Rsv178 8,375 8,375 2 6.88 - - 4 63 209 50 19 146 70.1%292.5% County Roads 180 8,985,491 (146,585) 8,838,906 426,367 5,180,846.70 58.6%8,801,630 409,379 9,211,009 357,621 5,258,768 57.1%8,166,809 8,931,921 203,613 5,726,647 70.1%64.1% Facilities Mgmt to 507 183 1,209,958 47,285 1,257,243 - 0.0%1,169,335 1,169,335 96,936 820,353 70.2%1,111,711 1,065,393 88,783 748,621 67.3%70.3% Total Special Revenue 21,876,781 4,372,531 26,249,312 2,159,833 18,811,338 71.7%21,873,206 1,916,439 23,789,645 1,176,338 13,953,606 58.7%21,003,015 22,327,852 1,080,474 14,195,107 67.3%63.6% CAPITAL IMPROVEMENT Const/Renovation 301 415,233 415,233 - 285,853 68.8%363,826 363,826 - 58,625 16.1%773,299 518,500 26,442 249,627 32.3%48.1% Capital Improvement 302 1,155,500 1,155,500 305,424 1,318,085 114.1%1,156,313 1,000,000 2,156,313 205,638 1,931,527 89.6%1,246,025 1,072,125 104,991 771,767 61.9%72.0% HJC Park Jump 304 - 57,630 57,630 57,630 57,630 100.0% Public Infrastructure 306 567,500 567,500 63,614 414,163 73.0%565,000 565,000 35,328 343,981 60.9%572,302 510,100 42,095 363,646 63.5%71.3% Conservation Futures 308 274,280 (5,980) 268,300 2,533 158,680 59.1%271,860 271,860 5,365 164,118 60.4%280,835 258,841 3,334 172,443 61.4%66.6% Total CAP IMP 2,412,513 51,650 2,464,163 429,201 2,234,412 90.7%2,356,999 1,000,000 3,356,999 246,331 2,498,252 74.4%2,872,460 2,359,566 176,863 1,557,483 63.5%66.0% 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 Aug YTD YTD Orig Budget Amended BDGT Jun YTD YTD YTD Amended BDGT Jun YTD YTD ENTERPRISE Solid Waste 401 3,670,759 3,670,759 345,229 2,748,714 74.9%3,718,073 3,718,073 339,885 2,539,586 68.3%3,866,094 3,636,313 346,478 2,590,068 67.0%71.2% Solid Waste Post Clos 402 38,686 38,686 9 28 - - 13 248 1,094 - 99 789 72.2% Solid Waste Eqpt Res 403 936,055 936,055 195 647 0.1%15,000 15,000 258 4,903 32.7%19,648 8,000 1,757 14,039 71.5%175.5% Yard Waste Educ Fnd 404 10,915 10,915 0 4 0.0%7,000 7,000 1 23 0.3%209 6,800 19 150 71.6%2.2% Tri Area Sewer 405 1,064,500 381,192 1,445,692 75 605,279 41.9%982,500 23,087 1,005,587 246 153,459 15.3%303,778 303,632 1,476 199,525 65.7%65.7% Total ENTERPRISE 5,720,915 381,192 6,102,107 345,507 3,354,672 55.0%4,722,573 23,087 4,745,660 340,403 2,698,218 56.9%4,190,823 3,954,745 349,830 2,804,571 71.6%70.9% INTERNAL SERVICE Equipment Rental 501 2,681,971 167,202 2,849,173 197,238 1,484,641 52.1%2,617,745 18,883 2,636,628 185,741 1,610,536 61.1%2,915,525 3,139,487 181,402 1,914,215 65.7%61.0% Risk Management 502 150,000 150,000 - - 0.0%150,000 150,000 - 529 0.4%38,522 215,000 - 0 0.0%0.0% Benefit Reserve 505 275,000 275,000 22,128 196,355 71.4%275,000 275,000 22,627 250,765 91.2%257,890 208,000 25,293 195,313 75.7%93.9% Information Services 506 1,954,417 333,056 2,287,473 6,723 1,708,486 74.7%1,968,639 1,335,533 3,304,172 2,983 1,531,802 46.4%2,116,237 2,197,065 5,230 1,367,494 64.6%62.2% Facilities Mgmt eff 6/21 507 1,209,958 47,285 1,257,243 117,325 866,144 68.9%Facilities Mgmt eff 6/1/2021 Total INT SERV 5,061,388 500,258 5,561,646 226,089 3,389,482 60.9%5,011,384 1,354,416 6,365,800 211,351 3,393,632 53.3%5,328,174 5,759,552 211,925 3,477,021 64.6%60.4% Total 35,071,597 5,305,631 40,377,228 3,160,630 27,789,904 68.8%33,964,162 4,293,942 38,258,104 1,974,423 22,543,708 58.9%33,394,473 34,401,715 1,819,090 22,034,182 65.3%64.0% GENERAL FUND CASH BALANCE REPORT August 9/27/2021 END OF MONTH CASH BALANCES 2008 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 January $3,761,366 2,717,342$ 2,548,924$ 3,317,483$ 2,556,108$ 3,030,949$ 2,798,256$ 4,109,412$ 4,360,809$ 4,416,485$ 5,320,169$ 6,803,191$ 8,113,654$ February $3,486,901 1,804,045$ 1,882,264$ 3,023,683$ 1,802,345$ 2,041,248$ 2,202,079$ 3,278,685$ 3,622,756$ 3,681,133$ 4,464,746$ 6,243,097$ 7,894,628$ March $2,898,116 1,691,583$ 1,934,629$ 2,347,678$ 1,654,411$ 2,108,155$ 2,384,301$ 3,289,638$ 3,759,875$ 3,580,887$ 4,861,100$ 6,359,340$ 7,292,627$ April $4,932,654 3,764,298$ 3,819,239$ 4,144,298$ 3,732,606$ 4,429,017$ 4,572,778$ 5,181,554$ 5,391,984$ 5,572,170$ 7,300,275$ 8,452,851$ 9,257,492$ May $4,816,082 3,623,704$ 3,850,878$ 4,045,216$ 3,747,009$ 4,421,127$ 4,622,123$ 5,174,859$ 5,455,638$ 5,330,488$ 7,124,392$ 7,105,615$ 8,972,934$ June $4,785,927 3,554,636$ 4,081,060$ 3,980,389$ 4,663,469$ 4,818,824$ 5,866,387$ 6,413,636$ 6,593,259$ 6,795,577$ 8,169,229$ 8,074,825$ 9,153,137$ July $4,308,238 2,978,751$ 3,732,809$ 3,396,868$ 3,873,932$ 3,736,091$ 5,087,286$ 5,610,102$ 5,806,710$ 6,177,104$ 8,112,936$ 7,785,971$ 9,350,267$ August $3,191,594 2,117,574$ 2,974,460$ 2,394,180$ 3,010,467$ 2,898,623$ 4,203,581$ 5,416,407$ 5,111,812$ 5,237,488$ 6,926,951$ 6,631,983$ 8,374,952$ September $2,986,861 1,596,637$ 2,312,554$ 1,734,730$ 2,217,696$ 2,118,250$ 3,742,452$ 4,710,400$ 4,724,294$ 4,511,047$ 5,850,565$ 5,829,324$ October $4,764,280 3,363,104$ 4,339,258$ 4,098,330$ 4,148,666$ 4,133,005$ 5,804,449$ 6,326,563$ 6,245,727$ 6,682,718$ 8,291,898$ 7,761,494$ November $4,063,841 3,339,559$ 4,236,934$ 3,781,830$ 3,878,581$ 3,795,871$ 5,043,942$ 5,519,658$ 6,098,807$ 6,804,203$ 7,781,753$ 9,799,671$ December $3,601,124 3,248,681$ 3,862,223$ 3,346,366$ 3,605,804$ 3,694,709$ 4,808,162$ 5,384,768$ 5,201,817$ 6,038,266$ 7,658,281$ 9,709,633$ REQUIRED RESERVE * In 2019, Resolution 41-19 changed the reserve to 15% of the GF Total Spending and eliminated the Revenue Stabilization Reserve - changes with appropriations throughout year 2008 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 Budg Total Reserve $1,528,008 $ 1,530,071 $ 1,666,150 $ 1,708,161 $ 1,786,000 $ 2,121,257 $ 2,140,726 $ 2,308,223 $ 2,589,184 $ 2,703,102 $ 3,281,222 $ 3,862,515 $ 3,589,298 15% GF Budgeted Expenditures *$1,528,008 $ 1,530,071 $ 1,566,150 $ 1,608,161 $ 1,646,000 $ 1,681,257 $ 1,700,726 $ 1,806,223 $ 1,863,184 $ 1,977,102 $ 3,281,222 $ 3,862,515 $ 3,709,786 Revenue Stabilization $ - $ - $ 100,000 $ 100,000 $ 140,000 $ 440,000 $ 440,000 $ 502,000 $ 726,000 $ 726,000 $ - $ - $ - Non-Reserve Cash Balance 3,288,074$ 2,093,633$ 2,184,728$ 2,337,055$ 1,961,009$ 2,299,870$ 2,481,397$ 2,866,637$ 2,866,454$ 2,627,387$ 3,843,170$ 3,243,100$ 4,785,655$ 2008 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 $0 $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000 $7,000,000 $8,000,000 $9,000,000 $10,000,000 January March May July September November General Fund Cash Balance $0 $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000 $7,000,000 $8,000,000 $9,000,000 2008 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021Budg Reserve and Cash Balance Composition 15% GF Budgeted Expenditures *Revenue Stabilization Non-Reserve Cash Balance August 8 August 9/22/2021 2021 General Fund Treasurer 001-250-000 Sales 313.11 Special Purpose 313.15 MONTHLY SALES TAX RECEIPTS General Fund Treasurer 001-250-000 Sales 313.11 Special Purpose 313.15 Revenue Cumulative Cumulative Year End3 yr. avg Expected Actual Over/Under % of projection 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2017-19 2021 2021 Expected expected Projection Over/UnderJanuary154,373 180,283 156,597 207,318 152,937 133,849 137,774 137,615 177,776 176,956 163,811 185,292 185,505 207,899 258,313 303,235 326,695 7.3%271,090 326,695 $55,605 120.51%$4,487,768 763,837$ February 224,687 244,043 249,049 206,809 219,448 215,617 201,110 206,281 227,634 218,000 239,784 263,305 310,729 279,301 314,528 355,834 380,545 9.0%334,584 380,545 $45,961 116.77%$4,348,400 624,469$ March 142,119 161,270 157,709 170,679 177,252 122,153 136,282 115,959 194,619 156,957 164,393 194,466 189,576 206,999 241,958 251,543 291,915 6.6%246,799 291,915 $45,116 117.21%$4,364,692 640,761$ April 156,731 170,147 181,390 162,253 148,592 131,100 127,885 124,117 174,718 154,216 167,550 181,384 193,862 202,532 209,415 249,173 308,631 6.3%232,925 308,631 $75,706 120.49%$4,486,929 762,998$ May 198,754 211,995 207,595 212,586 181,514 175,118 178,468 151,451 195,175 178,074 207,951 226,291 249,596 271,431 295,191 267,758 391,264 7.9%293,968 391,264 $97,297 123.18%$4,586,996 863,065$ June 164,380 165,275 175,802 167,706 172,947 133,593 154,669 133,909 166,750 156,362 196,231 196,762 208,349 248,506 263,069 243,568 359,215 7.1%266,051 359,215 $93,164 125.99%$4,691,933 968,002$ July 187,091 235,150 199,236 174,881 159,276 136,373 166,276 155,881 188,957 174,130 185,889 204,143 236,448 262,489 308,592 323,542 395,282 8.5%315,192 395,282 $80,089 128.88%$4,799,585 1,075,654$ August 220,873 241,022 250,665 244,562 199,901 184,345 187,132 192,602 219,583 238,784 257,369 276,309 293,953 309,575 355,294 348,337 441,657 9.6%356,971 441,657 $84,686 129.41%$4,819,277 1,095,346$ September 211,602 211,286 200,636 213,505 187,214 173,733 169,379 242,312 198,879 212,018 227,766 247,376 241,325 307,750 319,609 372,118 9.5%352,134 - -$352,134 100.20% 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 72.71% 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 47.91% 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 25.05% TTL 2,311,638 2,469,708 2,453,909 2,410,507 2,137,279 1,918,151 1,968,790 2,047,153 2,348,673 2,300,936 2,486,611 2,738,244 2,876,339 3,195,259 3,601,761 3,772,767 2,895,205 100.0%$3,723,931 $2,895,205ytd 1,449,008 1,609,185 1,578,043 1,546,794 1,411,867 1,232,148 1,289,596 1,217,815 1,545,212 1,453,479 1,582,977 1,727,952 1,868,018 1,988,733 2,246,361 2,342,991 2,895,205 2,317,581 2,895,205 577,624 ytd change 11.05%-1.94%-1.98%-8.72%-12.73%4.66%-5.57%26.88%-5.94%8.91%9.16%8.11%6.46%12.95%4.30%23.57%24.92%over (under) ytd expectedannual % chg.6.84%-0.64%-1.77%-11.33%-10.25%2.64%3.98%14.73%-2.03%8.07%10.12%5.04%11.09%12.72%4.75%Special Purp./Public Safety Tax Cumulative Cumulative Year EndActual3 yr avg.Projection Actual Over/Under % of projection200520062007200820092010201120122013201420152016201720182019202020212018-20 2021 2021 Expected expected Projection Over/Under January 45,217 50,919 50,377 51,210 58,026 61,161 66,993 79,236 84,751 89,951 7.5%76,430 89,951 $13,521 117.69%$1,201,368 180,585$ February 61,899 70,678 67,508 73,364 83,521 93,242 90,853 94,690 101,181 104,630 9.3%94,876 104,630 $9,754 110.28%$1,125,725 104,942$ March 40,604 56,106 49,782 50,931 62,285 61,183 66,479 70,614 72,888 80,801 6.8%69,482 80,801 $11,319 116.29%$1,187,077 166,294$ April 43,155 51,054 47,573 52,541 59,481 59,911 63,784 65,310 69,887 83,697 6.5%65,842 83,697 $17,855 127.12%$1,297,603 276,820$ May 51,908 58,324 56,012 62,613 74,233 78,716 84,357 88,754 75,138 107,326 8.0%82,144 107,326 $25,182 130.66%$1,333,710 312,927$ June 45,930 46,797 50,067 48,647 58,717 65,832 65,229 75,141 77,429 68,693 99,946 7.2%73,215 99,946 $26,731 136.51%$1,393,477 372,694$ July 55,488 49,385 68,295 54,074 56,793 69,908 73,136 81,117 89,815 86,275 107,036 8.3%85,109 107,036 $21,927 125.76%$1,283,772 262,989$ August 59,578 56,220 56,063 68,712 76,734 87,275 89,679 97,261 107,514 94,459 123,789 9.7%99,015 123,789 $24,774 125.02%$1,276,183 255,400$ September 55,746 54,902 61,455 64,622 72,022 77,854 77,534 97,036 94,733 96,212 9.3%95,292 - -$95,292 0.00% October 59,692 61,120 64,400 64,152 73,903 82,028 82,991 95,473 97,187 101,038 9.5%97,183 - -$97,183 0.00% November 58,107 60,952 64,915 71,491 77,947 89,596 90,736 98,020 105,075 102,364 9.9%101,075 - -$101,075 0.00% December 46,767 49,281 52,177 59,043 62,263 66,133 69,582 83,431 93,783 67,940 7.9%81,120 - -$81,120 0.00% TOTAL 381,308 621,440 704,453 701,993 769,039 876,170 903,099 999,945 1,064,140 1,020,826 797,176 100.0%1,020,783 797,176 ytd 160,996 395,185 461,506 442,685 482,904 560,560 582,256 625,985 673,362 653,272 797,176 646,113 $797,176 151,063 ytd change 16.78%-4.08%9.09%16.08%3.87%7.51%7.57%-2.98%22.03%23.38%over (under) ytd expectedannual % chg.62.98%13.36%-0.35%9.55%13.93%3.07%10.72%6.42%-4.07% Sales Tax receipts are for the approximate timeframe of two months prior depending on the business reporting schedules.3 yr avg.Projection Actual Over/Under % of projectionSales Tax 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2017-19 2021 2021 Expected expected Projection Over/Under General & Option 1,449,008 1,609,185 1,578,043 1,546,794 1,411,867 1,232,148 1,289,596 1,217,815 1,545,212 1,453,479 1,582,977 1,727,952 1,868,018 1,988,733 2,246,361 2,342,991 2,895,205 2,317,581 2,895,205 577,624 4,819,277 1,095,346$ Special Purpose - - - - - - 160,996 395,185 461,506 442,685 482,904 560,560 582,256 625,985 673,362 653,272 797,176 646,113 797,176 151,063 $1,276,183 255,400 G&O and SP Sal 1,449,008 1,609,185 1,578,043 1,546,794 1,411,867 1,232,148 1,450,592 1,613,000 2,006,718 1,896,164 2,065,881 2,288,511 2,450,274 2,614,718 2,919,723 2,996,263 3,692,381 2,963,694 3,692,381 728,687 6,095,460 1,350,746 Full Year Total A 2,311,638 2,469,708 2,453,909 2,410,507 2,137,279 1,918,151 2,350,098 2,668,593 3,053,126 3,002,929 3,255,650 3,614,414 3,779,438 4,195,203 4,665,900 4,744,714 4,744,714 4,744,714 - - - 500,000 1,000,000 1,500,000 2,000,000 2,500,000 3,000,000 3,500,000 4,000,000 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 GENERAL & OPTIONAL SALES TAX RECEIPTS BY MONTH AND YEAR (Does not include Special Purpose/Public Safety Tax) December November October September August July June May April March February January 2021 - 500,000 1,000,000 1,500,000 2,000,000 2,500,000 3,000,000 3,500,000 4,000,000 4,500,000 5,000,000 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 Sales Tax and Special Purpose Sales Tax YTD, Actual Total and 2020 Budget Special PurposeYTD General &Optional YTD Full Year TotalActual w/ 2020Budget August 2021 - 100,000 200,000 300,000 400,000 500,000 600,000 1 2 3 4 5 6 7 8 9 10 11 12 2021 Monthly Actual Revenue & Budgeted Share Actual 2021 Expected 2021 -$500,000 $500,000 $1,500,000 $2,500,000 $3,500,000 $4,500,000 $5,500,000 1 2 3 4 5 6 7 8 9 10 11 12 2021 Cumulative YTD Actual & Budget Expected by Month YTD Actual Year EndProjectedOver/UnderBudget YTD Budget $0.00 August CATEGORY ANALYSIS BY CODE Report R03.4 1600, 1650, 1603, 1604 Jefferson County Run Date: 09/27/2021 Sales Tax Current Period: 202106 Cash Basis, Revenue Amounts Current Period Year to Date Category Name This Year Last Year % Chg This Year Last Year % Chg Last 12 Months 00 16,720 25,036 -33.2 120,811 96,459 25.2 190,749 11 Agriculture, Forestry, Fishing and Hunting 837 793 5.5 3,731 3,896 -4.2 4,818 21 Mining, Quarrying, and Oil and Gas Extraction 1,118 1,236 -9.6 12,220 5,206 134.7 19,255 22 Utilities 275 239 15.4 1,304 974 33.9 2,254 23 Construction 126,401 89,924 40.6 727,630 677,387 7.4 1,135,627 31 Manufacturing 5,109 2,205 131.7 17,206 16,709 3.0 24,671 32 Manufacturing 3,980 2,706 47.1 18,197 17,878 1.8 -4,985 33 Manufacturing 4,490 4,959 -9.5 31,979 32,825 -2.6 41,676 42 Wholesale Trade 18,084 18,135 -0.3 155,385 137,815 12.7 229,551 44 Retail Trade 75,556 61,682 22.5 537,628 410,235 31.1 829,721 45 Retail Trade 68,006 57,098 19.1 526,133 404,703 30.0 751,482 48 Transportation and Warehousing 1,301 660 97.2 9,097 5,190 75.3 12,346 49 Transportation and Warehousing 56 175 -67.8 456 374 21.8 642 51 Information 15,259 12,292 24.1 104,178 92,293 12.9 150,341 52 Finance and Insurance 1,587 1,269 25.1 12,285 9,162 34.1 18,640 53 Real Estate and Rental and Leasing 8,551 7,256 17.8 50,518 41,425 21.9 74,523 54 Professional, Scientific, and Technical Services 6,064 5,072 19.6 65,443 38,366 70.6 80,496 55 Management of Companies and Enterprises 1,985 0 0 4,418 66 6.0 4,467 56 Administrative and Support and Waste Management an 29,377 25,682 14.4 203,725 151,463 34.5 299,514 61 Educational Services 710 238 197.7 2,579 1,669 54.5 4,442 62 Health Care and Social Assistance 803 599 34.2 5,329 3,401 56.7 7,892 71 Arts, Entertainment, and Recreation 3,910 1,577 147.9 16,084 10,792 49.0 29,184 72 Accommodation and Food Services 40,016 20,834 92.1 190,721 128,493 48.4 308,836 81 Other Services (except Public Administration)9,723 6,999 38.9 63,509 45,744 38.8 89,499 92 Public Administration 1,306 958 36.4 10,056 5,708 76.2 12,413 TOTAL 28,155 Accounts 441,227 347,622 26.9 2,890,622 2,338,235 23.6 4,318,051 NOTE: YTD column includes returns from 202011 to 202106 This report only includes location(s) 1600, 1601, 1650, 16 Last 12 Months by Category -500K 0 500K 1M 1.5M Unknown Mining (except Oil and Gas) Textile Mills Merchant Wholesalers, Durable Goods Support Activities for Transportation Credit Intermediation and Related Activities Waste Management and Remediation Services Food Services and Drinking Places 8 2021 August 302-000-010 Capital Improvement fund, not other financing sources, transfer, appropriation$ Recent 2021 2021 % Budget Month Change 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 4 YR AVG Budget Actual Difference prior year January $78,294 $83,384 $72,424 $45,530 123,064$ 28,601$ 56,823$ 28,435$ 28,059$ 44,132$ 33,177$ 57,144$ 78,597$ 49,830$ 64,496 69,086 88,027 65,502 53,260 88,027 65.3%27.4% February $112,120 $74,250 $65,590 $45,612 10,730$ 22,594$ 66,268$ 30,745$ 18,846$ 26,888$ 48,279$ 51,148$ 47,854$ 65,067$ 51,891 84,560 103,671 62,343 50,691 103,671 104.5%22.6% March $92,812 $82,868 $58,766 $63,286 66,768$ 44,044$ 34,138$ 39,257$ 42,889$ 40,689$ 168,735$ 79,657$ 91,388$ 75,558$ 82,105 93,964 120,812 85,754 69,726 120,812 73.3%28.6% April $105,772 $83,776 $95,258 $105,272 20,838$ 54,965$ 21,847$ 35,754$ 60,839$ 55,546$ 61,766$ 77,161$ 78,523$ 102,480$ 89,657 78,860 138,647 87,380 71,048 138,647 95.1%75.8% May $124,210 $125,632 $86,666 $49,638 34,242$ 36,932$ 27,146$ 59,286$ 50,555$ 62,184$ 73,099$ 108,945$ 111,101$ 128,185$ 111,001 75,991 174,853 106,569 86,652 174,853 101.8%130.1% June $164,122 $137,630 $89,338 $54,812 30,788$ 35,648$ 37,194$ 44,068$ 63,205$ 71,373$ 118,836$ 241,046$ 147,551$ 147,514$ 104,991 205,638 192,025 151,424 123,122 192,025 56.0%-6.6% July $132,668 $117,584 $108,226 $57,890 43,154$ 34,393$ 36,658$ 28,856$ 57,623$ 67,722$ 110,603$ 105,451$ 105,582$ 108,763$ 136,683 160,738 194,625 127,942 104,029 194,625 87.1%21.1% August $133,848 $355,084 $92,362 $58,240 46,658$ 31,371$ 30,855$ 43,974$ 71,327$ 55,685$ 92,001$ 125,719$ 110,037$ 131,097$ 130,942 162,691 305,424 133,692 108,705 305,424 181.0%87.7% September $147,903 $104,040 $67,136 $39,174 47,520$ 46,444$ 37,641$ 54,626$ 67,050$ 71,552$ 219,697$ 95,883$ 181,336$ 117,652$ 105,075 211,718 153,945 125,173 October $203,764 $89,674 $100,551 $46,562 31,806$ 31,382$ 34,231$ 66,934$ 57,808$ 65,594$ 102,267$ 137,192$ 113,373$ 119,144$ 134,016 291,638 164,543 133,790 November $126,964 $99,990 $52,266 $22,654 54,154$ 31,746$ 33,220$ 67,226$ 127,615$ 41,510$ 66,034$ 75,151$ 119,897$ 96,368$ 110,009 127,705 113,495 92,282 December $97,838 $113,314 $46,605 $37,906 49,676$ 27,938$ 27,429$ 49,960$ 62,067$ 101,510$ 102,439$ 83,276$ 100,034$ 74,910$ 125,158 150,137 112,560 91,522 Total $1,520,315 $1,467,226 $935,188 $626,576 $559,398 $426,058 $443,450 $549,121 $707,883 $704,385 $1,196,934 $1,237,774 $1,285,270 $1,216,569 $1,246,024 $1,712,725 $1,318,085 1,365,147$ 1,110,000$ 1,318,085$ 18.7%37.5% YTD 943,846 1,060,208 668,630 480,280 376,242 288,548 310,929 310,375 393,343 424,219 706,497 846,272 770,631 808,495 771,766 931,527 1,318,085 820,605$ 667,233$ 1,318,085$ 97.5%20.7% YTD change 12.33%-36.93%-28.17%-21.66%-23.31%19.22%-0.18%26.73%7.85%66.54%19.78%-8.94%4.91%-4.54%20.70%41.50% Annual % chg 12.33%-36.93%-28.17%-21.66%-23.31%4.08%23.83%28.91%-0.49%69.93%3.41%3.84%-5.35%2.42%37.46% Actual Full Year or Budge $1,520,315 $1,467,226 $935,188 $626,576 $559,398 $426,058 $443,450 $549,121 $707,883 $704,385 $1,196,934 $1,237,774 $1,285,270 $1,216,569 $1,246,024 $1,712,725 $1,110,000 Total Sales Value for year incl City of PT 219,533,884 237,164,120 348,155,918 395,379,956 404,420,675 365,442,489 369,816,284 451,371,978 Jan 2019 7 sales>$500k Jul 2019 1@$3.3M, 16>$500k Jan 2020 9 sales>$500k July 2020 2 sales over $1M: $1.25M & $1.025M; and 16 sales>$500k Jan 2021 10 sales>$500k,1@$1.7M July 2021 28 sales >$500 with 6 sales >$1 million Feb 2019 1@$1M, 4 sales>$500k Aug 2019 2@$1.25M &1.2M, 12>$500k Feb 2020 1@1.2M & 6 sales>$500k Aug 2020 1 sales @$1.25M and 23 sales>$500k Feb 2021 13 sales>$500k,1@$2.05M,1@$1.25M Aug 2021 45 sales >$500 with 8 sales >$1 million Mar 2019 1@$1.4M, 6 sales>$500k Sep 2019 1@$1.25M & 1.425M, 11>$500k Mar 2020 1@1.025M & 10 sales>$500k Sep 2020 2@$2.1M and $1.253M; 29 sales>$500k Mar 2021 15 sales>$500k,2@$1.23 and $1.25M Apr 2019 9 sales>$500k Oct 2019 2@$1.475M and 1.5M, 6>$500k Apr 2020 8 sales>$500k Oct 2020 6>$1M (3.15, 2.7, 2.5, 1.7, 1.26, 1.08M); 33 sales>$500k Apr 2021 19 sales>$500k,2@$1.3 and 1@$1.2M May 2019 1@1.045M, 9 sales>$500k Nov 2019 2@$1.75M & 1.1M, 12>$500k May 2020 1@$1.3M and 6>$500k Nov 2020 1@$1.15M; 15 sales>$500k.May 2021 27 sales>$500k,1@$1.5 and 1@$1.225M Jun 2019 1@$2.36M & 1@ $1.275M, 7>$500k Dec 2019 1@$2.61, 4@$1+,10>$500k June 2020 3@ $9.9M, $1.07M & $1.375M;19 Dec 2020 2@$1.96M & $1.1M; 13 sales>$500k.June 2021 28 sales>$500k, 5@$1.0, 1.19, 1.35, 1.51 & 1.87 million 9/27/2021 $0 $200,000 $400,000 $600,000 $800,000 $1,000,000 $1,200,000 $1,400,000 $1,600,000 $1,800,000 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 Real Estate Excise Tax Collections -2005 to 2021 Fund 302 Capital Improvement Fund December November October September August July June May April March February January Actual Full Year or Budget 0 200,000 400,000 600,000 800,000 1,000,000 1,200,000 1,400,000 1,600,000 REET 2021 YTD Actual Total & Budget YTD Actual YTD Budget Projected Over/Under Budget 0 50,000 100,000 150,000 200,000 250,000 300,000 350,000 2021 Monthly Actual Revenue & Budgeted Share 2021 Actual Budget August August 2021 9/22/2021 4 yr avg *2021 2021 % Budget % Diff 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2017-20 Budget Actual Difference Prior Year January 16,089 11,507 12,045 8,863 13,575 17,051 18,473 19,394 23,177 29,854 32,023 38,926 26,112 26,445 38,926 47.2%21.6% February 27,998 25,532 23,188 38,274 30,356 36,141 51,077 53,093 46,226 41,186 34,092 45,296 43,649 44,205 45,296 2.5%32.9% March 22,623 12,406 7,271 11,203 12,715 14,345 14,554 16,889 19,419 25,281 29,621 46,465 22,802 23,093 46,465 101.2%56.9% April 11,344 10,791 14,950 11,430 12,427 14,983 18,530 20,901 23,749 22,829 29,140 43,464 24,154 24,462 43,464 77.7%49.2% May 19,646 25,142 17,142 18,010 19,151 23,886 29,462 45,943 41,061 41,546 11,527 66,011 35,019 35,465 66,011 86.1%472.7% June 19,205 17,302 17,916 16,477 18,786 25,070 29,476 31,485 36,556 43,299 742 69,468 28,021 28,378 69,468 144.8%9263.8% July 20,155 19,311 20,201 21,512 24,536 27,711 33,687 38,400 44,445 48,748 24,074 70,768 38,917 39,413 70,768 79.6%194.0% August 35,178 24,742 31,171 33,140 37,534 48,845 56,349 64,820 64,934 70,516 41,591 85,104 60,466 61,236 85,104 39.0%104.6% September 41,757 42,500 40,882 39,890 42,349 44,713 53,487 56,561 68,870 88,306 79,681 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 465,502 530,330 537,087 465,502 YTD 172,238 146,733 143,884 158,909 169,080 208,032 251,608 290,924 299,567 323,259 202,811 465,502 279,140 282,697 465,502 64.7%129.5% Full Year Actual/20 321,231 293,344 273,796 295,200 335,825 386,107 449,148 507,868 542,805 579,805 490,842 537,087 YTD Change 13.20%-1.94%10.44%6.40%23.04%20.95%15.63%2.97%7.91%-37.26%129.53% Annual % Change 0.24%-6.66%7.82%13.76%14.97%16.33%13.07%6.88%6.82%-15.34%$537,087 2021 Budget 2% Basic RCW 67.28.18RCW 67.28.180 2% Special RCW 67.28.181(1).11% Total sales tax paid on a lodging charges for periods of less than 30 consecutive days Revenue reflects 2% "basic" as a credit against 6.5% state sales tax, 2% "special" tax levied locally, interest on amounts held at DOR until disbursement, and 1% Admin fee from DOR. Revenue is reported one month after reporting to DOR. It typically reflects collections for activity from two months prior to distribution. Some businesses may report quarterly or annually. 0 100,000 200,000 300,000 400,000 500,000 600,000 700,000 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 December November October September August July June May April March February January 2021 HOTEL/MOTEL LODGING TAX -Fund 125 Includes Investment Interest 0 100,000 200,000 300,000 400,000 500,000 600,000 2021 YTD Actual and Budget YTD Actual YTD Budget Projected Over/Under Budget 0 20,000 40,000 60,000 80,000 100,000 2021 Monthly Actual and Budget 2021 Actual Budget August