Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2023-04_APR_Treasurer_RevenueReports
JEFFERSON COUNTY TREASURER PO Box 571, Port Townsend WA 98368 Email: TreasurerStaff@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 April 2023 Revenue Report • General Fund at $9,745,983 – 39.8% of the annual budget. The second sheet shows general fund revenue charts showing 2015-2023 detail and percentage of actual full year collections. • Other Funds at $14,326,334 – 25.7% of annual budget. Funds are grouped at the top by fund type, and YTD percentages are provided. The graph on the second page shows the full year and YTD percentage lines. • General Fund Cash Balance - $9,347,020 at end of month which includes $3,906,731 for the 15% of expenditure reserve. Note that with property taxes due in April, we have one of our two peak balances for the year, and cash amounts cover expenditures until our next tax due date in October. Our 15% recommended reserve is slightly under the 60 day Cash Balance Sufficiency benchmark (16.44%) that the Washington State Auditor’s Financial Intelligence Tool recommends. • General Sales Tax Receipts - $377,962 General and Optional Sales Tax and $104,345 for Special Purpose this month. Cumulatively, this is 4.4% over YTD budget and 9.7% over YTD for last year. • Sales Tax by Sector: Positive percentages are increases over last year to date, negative are decreases. Color shading is white for zero, green for positive and red for negative. Sales Tax Revenue by Sector Unincorp Jefferson County City of Port Townsend All Sales YTD 8% 14% RETAIL YTD 2% 5% CONSTRUCTION YTD 14% 49% ACCOMMODATION & FOOD SERVICES YTD 76% 30% • REET Receipts - Fund 302 - $92,481 for the month which is 16.6% under budget for the month and 31% less than what it was this month last year. Year to Date it’s 23% under budget and 40% less than last year. We had two sales over $1 million in unincorporated Jefferson County, both in Port Ludlow tax area. This is one fewer than this month last year. Current projection is $406,000 under budget, but it’s a smaller shortage than earlier in the year. • Excise Detail – shows the Excise paid in the city and unincorporated Jefferson County, and the detailed transactions. • Hotel/Motel Lodging Tax – Fund 125 - $145,748 for the month. This is 260% over budget for the month and 109% over budget YTD. This is 75.9% more than 2022 YTD. Year-end projection is $700k over budget, but we’ll see how it goes as we get further in the year. 2023 4 April Jefferson County Treasurer 19-May-2023 Jefferson County Treasurer REVENUE NAME BUDGET AMENDED APR Y-T-D Y-T-D ACTUAL APR Y-T-D Y-T-D BUDGET AMENDED ACTUAL MAR Y-T-D Y-T-D Revenue Department/Detail *Fund.Dept Account-Object Info 2023 ANNUAL & QTRLY Approp Budget 2023 2023 2023 % of Amended Budget 2022 2022 2022 % of Amended Budget 2021 ANNUAL & QTRLY Approp Budget 2021 2021 2021 2021 % of ACTUALAssessor1001.010 All 8,300 8,300 49 1,942 23.4%8,503 0 2,115 25.5%8,300 0 8,300 7,851 1,765 1,892 24.1%Auditor-Recording Fees 1 001.020 AU34121-341012 77,124 77,124 3,527 14,849 19.3%71,178 5,959 25,981 36.3%69,495 0 69,495 105,988 9,599 38,443 36.3%Auditor-M.V. License Fees 1 001.020 AU34148-341047; AU33600-341054 306,907 306,907 41,480 126,162 41.1%344,478 51,215 129,762 46.1%246,440 16,370 262,810 343,107 16,485 130,654 38.1%Auditor-Other Revenue 1 001.020 Other 14,094 14,094 1,468 5,279 37.5%16,751 980 5,740 15.8%35,330 0 35,330 65,584 3,123 50,109 76.4%Elections 1 001.021 All 237,745 237,745 4,651 59,347 25.0%247,862 1,157 196,170 92.6%161,195 73,000 234,195 151,025 1,574 55,047 36.4%Clerk 1 001.050 All 115,853 115,853 17,539 62,661 54.1%304,098 110,427 134,825 41.8%141,663 132,485 274,148 120,109 8,432 39,735 33.1%County Administrator 1 001.059 All 4,142 4,142 0 4,142 100.0%4,142 0 4,142 108.7%3,700 300 4,000 4,000 3,700 4,000 100.0%Commissioners 1 001.060 All 8,489 8,489 407 1,630 19.2%7,811 634 2,780 33.7%8,000 0 8,000 11,056 1,053 3,970 35.9%Board of Equalization 001.061 All 0 0 0 0 0 0 0Civil Service Commission 001.062 All 0 0 0 0 0 0 0Planning Commission 001.063 All 0 0 0 0 0 0 0Safety & Security/Emergency Mg 1 001.067 All 63,872 63,872 3,945 3,945 6.2%106,845 47,092 62,489 61.7%75,538 22,811 98,349 200,798 0 38,642 19.2% Community Services 1 001.068 All 603 603 51 5,404 896.1%3,405 220 334 3.2%4,172 0 4,172 3,165 46 594 18.8% District Court 1 001.080 All 575,834 (70,000)505,834 23,735 153,774 30.4%547,241 54,005 235,056 38.7%655,380 (15,630)639,750 543,608 40,624 151,946 28.0% Juvenile Service 1 001.110 All 357,483 357,483 60,026 101,752 28.5%347,658 7,049 72,887 22.6%278,783 23,447 302,230 290,150 43,863 115,232 39.7%Prosecuting Attorney 1 001.150 All 232,831 232,831 10,236 79,250 34.0%312,012.48 14,637 113,948 46.8%236,251 0 236,251 254,425.40 12,517 91,277.35 35.9%Coroner 1 001.151 All 35,409 35,409 0 7,800 22.0%14,400 0 6,000 17.3%25,348 0 25,348 15,255 0 8,400 55.1% Sheriff 1 001.180 All 390,498 169,597 560,095 (6,361)178,910 31.9%538,697 57,716 158,677 22.8%577,054 439,517 1,016,571 864,119 171,242 238,543 27.6% Superior Court 1 001.240 All 79,419 (70,000)9,419 0 4,580 48.6%33,858 4,059 4,059 6.8%59,547 (412)59,135 23,584 4,940 5,736 24.3% Therapeutic Courts Case Mgmt 1 001.245 All 200,000 200,000 10,908 10,908 10,908 Property Tax 1 001.250 311000 8,824,286 8,824,286 2,879,181 4,010,799 45.5%8,497,709 2,853,238 3,978,880 46.4%8,538,738 (133,567)8,405,171 8,329,356 608,614 4,069,799 48.9% Diverted Road Prop Tax 1 001.250 311001 620,000 620,000 204,351 284,763 45.9%670,000 221,562 312,619 46.7%720,000 0 720,000 723,544 54,444 348,297 48.1% Sales Tax 1 001.250 313002 5,233,290 5,233,290 377,962 1,565,886 29.9%4,959,143 333,775 1,436,451 28.2%3,453,021 270,910 3,723,931 4,482,583 291,915 1,307,786 29.2% special purpose 1 001.250 313007 1,303,286 1,303,286 104,345 452,432 34.7%1,401,133 95,308 403,437 32.1%1,084,963 (64,180)1,020,783 1,243,276 80,801 359,079 28.9%Local Criminal Justice 1 001.250 313008 543,288 435,396 42,766 184,486 42.4%579,362 39,191 166,405 38.2%438,710 (3,314)435,396 517,744 33,769 150,131 29.0%Leasehold Excise Tax 3 001.250 317000 87,061 87,061 776 27,693 31.8%90,234 861 27,105 31.8%66,801 12,297 79,098 83,175 0 22,111 26.6%Private Harvest Tax - TAV 2 001.250 317100 & 317101 339,599 339,599 0 144,100 42.4%374,794 0 87,818 25.9%339,599 0 339,599 257,725 0 38,911 15.1%P.I.L.T. (incl DNR)4 001.250 332000, 1,765,762 1,765,762 0 0 0.0%1,754,183 0 0 0.0%1,035,150 623,245 1,658,395 1,659,288 0 26,490 1.6%P.U.D. Privilege Tax 4 001.250 001.250.60.33502.335001.422,305 422,305 0 436,839 103.4%412,849 0 412,849 100.7%398,151 11,789 409,940 398,969 0 0 0.0%Crim Just Hi Crime/DUI/Asst 5 001.250 336005, 336007 494,400 494,400 115,263 230,432 46.6%525,429 147,170 294,343 61.3%465,324 (5,324)460,000 566,448 0 273,681 48.3%Marijuana Excise 6 001.250 336006, 336012 46,923 46,923 0 15,453 32.9%63,990 0 14,567 32.0%54,124 (3,604)50,520 51,022 11,027 11,027 21.6%Liquor Excise Tax 8 001.250 336008.00 71,904 71,904 18,944 35,795 49.8%71,118 18,903 35,766 50.7%49,233 9,464 58,697 69,397 0 34,875 50.3%Liquor Profit 6 001.250 336009.00 86,671 86,671 0 20,987 24.2%83,894 0 20,964 24.7%92,463 (7,294)85,169 83,256 20,826 20,826 25.0%Treasurer Invest & Other Fees 1 001.250 341058, 341086-088, 341107-110 25,523 25,523 6,071 26,932 105.5%29,545 3,974 7,271 28.5%35,830 (11,213)24,617 36,478 1,625 8,149 22.3%Treas. Collection Fees (REET)3 001.250 341084, 85, 89 111,142 111,142 5,380 18,228 16.4%127,574 8,411 30,245 27.2%87,175 (11,870)75,305 125,174 6,510 27,934 22.3%Penalties on delinquent taxes 1 001.250 357012.00 120,000 120,000 5,954 20,601 17.2%88,534 12,157 48,326 31.6%122,152 6,119 128,271 133,011 13,867 51,834 39.0%Investment Income 1 001.250 361100.00 600,000 600,000 606,460 1,106,791 184.5%736,484 14,138 28,764 112.1%727,260 (305,372)421,888 483,972 3,010 29,324 6.1%Interest on delinquent taxes 1 001.250 361105.00 200,000 200,000 20,770 79,708 39.9%236,884 24,324 74,821 29.5%196,162 30,454 226,616 269,863 34,224 102,810 38.1%Interfund Chg Svc-Cost Alloc 3 001.250 362513, 362520 265,062 265,062 11,780 23,561 8.9%275,661 0 21,176 8.2%349,707 (98,445)251,262 251,959 0 19,923 7.9%DNR Timber & DNRTimbTrust 2 1 001.250 362600, 05, 10, 335041 499,211 499,211 0 141,618 28.4%180,395 0 38,061 35.6%250,000 0 250,000 24,782 0 0 0.0%Transfer in 1 001.250 397000, 151, 505 41,297 41,297 0 753 1.8%93,219.81 7,431 17,841 43.2%3,000 82,000 85,000 122,880.74 750 3,243.40 2.6%Miscellaneous *1 001.250 001.250.60.33602.336231. 001 250 60 36140 361105 15,084 15,084 1,989 8,851 58.7%35,000 492 1,881 16.8%27,784 (10,919)16,865 144,725 1,237 2,997 2.1%Non Departmental 1 001.270 All 32,387 32,387 765 86,941 268.4%129,928 979 70,295 184.5%36,990 0 36,990 131,909 1,339 51,691 39.2% TOTAL CURRENT EXPENSE REVENUE 24,257,084 229,597 24,486,681 4,574,418 9,745,983 39.8%24,326,007 4,137,068 8,684,849 37.1%18,572,337 391,176 18,963,513 23,194,359 1,163,960 7,935,137 34.2% * 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 VarAPPROPRIATIONS - Q1 RES 20-22, Q2 RES 31-22, Q3 RES 45-22 , Q4 RES 72-22 REFLECTEDREFUND EXPEND CY/PRIOR excl 0 7,519 24,040 171.49 1,946 0 29,643 276.03 11,164 *July 2021 LE & CJ One Time Cost 001.250.60.33602.336231.0 0 0 125,339 0 April2023 GENERAL FUND REVENUE 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023Property Tax 3,277,465 3,183,987 3,164,797 3,179,755 3,454,858 3,383,663 3,427,707 3,351,073 3,732,852 3,925,012 3,862,374 4,069,799 3,978,880 4,010,799Diverted Road Prop Tax 335,312 318,276 323,428 318,549 341,145 336,039 327,560 312,082 340,986 349,419 334,809 348,297 312,619 284,763Sales Tax 602,718 603,051 583,972 774,747 706,129 735,538 824,447 879,672 896,731 1,024,215 1,159,785 1,307,786 1,436,451 1,565,886 special purpose 0 0 190,874 228,758 215,240 228,046 263,312 275,497 288,110 309,850 328,707 359,079 403,437 452,432Local Criminal Justice 80,603 82,373 80,866 95,268 89,581 94,343 109,453 113,623 120,442 128,649 137,342 150,131 166,405 184,486Leasehold Excise Tax 15,253 17,486 15,158 14,792 19,159 16,459 16,069 18,293 14,908 18,641 21,815 22,111 27,105 27,693Private Harvest Tax 9,988 33,944 96,224 107,813 171,828 215,544 72,085 80,745 186,243 119,439 94,932 38,911 87,818 144,100P.I.L.T. (incl DNR)0 0 0 0 0 - - - - - - 26,490 0 0P.U.D. Privilege Tax 0 0 0 0 0 - - - - - - 0 412,849 436,839Crim Just Hi Crime/DUI/Asst 171,704 157,935 165,348 164,182 229,700 232,313 257,512 219,545 211,980 209,259 248,894 273,681 294,343 230,432Marijuana Enforcement/Excise 0 0 0 0 0 - 12,784 5,676 27,251 12,113 12,231 11,027 14,567 15,453Liquor Excise Tax 18,791 19,427 20,536 0 6,851 8,488 21,411 22,491 23,707 26,177 27,160 34,875 35,766 35,795Liquor Profit 19,955 17,033 13,705 21,213 21,177 21,291 21,220 21,155 21,065 20,968 20,844 20,826 20,964 20,987Treasurer Invest & Other Fees 1,791 1,544 1,052 1,197 839 1,152 2,679 14,507 12,711 14,852 13,721 8,149 7,271 26,932Treas. Collection Fees (REET)8,203 10,499 8,435 10,116 11,026 19,732 19,429 26,378 21,726 21,057 20,209 27,934 30,245 18,228Penalties on delinquent taxes 28,935 46,862 38,973 39,978 42,839 43,676 39,762 31,971 36,719 49,981 41,774 51,834 48,326 20,601Investment Income 30,545 24,004 18,477 -6,243 4,027 13,135 26,684 154,333 138,694 554,552 194,769 29,324 28,764 1,106,791Interest on delinquent taxes 37,816 67,303 58,926 56,763 64,282 72,257 70,286 53,143 60,091 76,759 63,774 102,810 74,821 79,708Interfund Chg Svc-Cost Alloc 0 0 0 39,051 0 8,752 - 19,800 195,627 19,150 19,471 19,923 21,176 23,561DNR Timber 904 145,570 157,906 6,390 181,336 257,487 212,153 - 3,780 260,732 146,897 0 38,061 141,618Transfer in 0 0 0 0 0 2,500 20,937 6,569 7,232 3,154 24,822 3,243 17,841 753Miscellaneous13,967 11,933 14,185 22,814 17,338 7,774 9,212 2,051 3,215 6,147 5,097 2,997 1,881 8,851Assessor50037763225910,308 369 2,175 2,190 1,993 2,040 2,073 1,892 2,115 1,942Auditor-Recording Fees 22,075 22,261 22,523 27,038 17,120 22,312 21,202 24,377 22,701 18,153 25,184 38,443 25,981 14,849Auditor-M.V. License Fees 47,204 46,106 45,139 50,306 49,682 48,623 85,628 90,620 84,207 96,947 117,254 130,654 129,762 126,162Auditor-Other Revenue 12,462 8,555 11,965 12,815 14,418 33,008 10,766 10,614 10,702 12,316 9,356 50,109 5,740 5,279Elections40,930 59,207 44,843 30,244 54,952 51,559 67,399 24,075 64,020 98,588 222,908 55,047 196,170 59,347Clerk70,502 63,568 64,493 69,666 75,916 74,207 62,691 60,614 55,532 44,398 48,930 39,735 134,825 62,661County Administrator 0 0 0 0 0 - - - 4,260 4,260 4,000 4,000 4,142 4,142Commissioners2,791 2,926 2,609 3,307 2,238 2,699 2,504 2,907 2,787 2,126 2,672 3,970 2,780 1,630Safety & Security 22,412 8,075 27,794 9,979 12,535 10,229 15,403 17,886 30,414 17,380 - 38,642 62,489 3,945Community Services 0 4,296 696 132 2,042 2,756 2,196 1,944 1,276 1,953 1,945 594 334 5,404District Court 168,599 177,506 161,251 173,089 189,409 172,764 175,251 148,873 151,845 150,753 136,645 151,946 235,056 153,774Juvenile Service 82,319 103,565 78,241 127,689 110,145 85,494 82,751 86,274 87,728 74,171 84,071 115,232 72,887 101,752Prosecuting Attorney 100,520 101,254 88,119 62,080 64,572 104,457 57,945 70,694 32,553 32,959 52,861 91,277 113,948 79,250Coroner2,320 7,480 3,480 6,380 3,480 3,480 8,340 24,610 18,140 11,924 7,958 8,400 235,056 153,774Sheriff362,653 390,638 247,283 130,380 169,221 189,632 249,735 156,597 102,387 359,329 272,851 238,543 158,677 178,910Superior Court 0 3,000 3,000 3,000 3,000 4,500 9,911 4,500 11,840 6,260 6,180 5,736 4,059 4,580Therapeutic Courts Case Mgmt 10,908Non Departmental 0 0 0 0 0 - 10 10 32,802 34,152 36,234 51,691 70,295 86,941TOTAL CURRENT EXPENSE 5,589,237 5,740,041 5,754,930 5,781,507 6,356,394 6,504,276 6,608,610 6,335,392 7,059,256 8,117,833 7,810,547 7,935,137 8,684,849 9,745,983TOTAL CURRENT EXPENSE ACTUAL/2023 BUDGET 15198876 16349133 15531592 16964139 17374434.53 18,950,211 19,240,977 19,181,590 20,890,820 22,268,272 24,666,543 23,194,359 24,326,007 24,486,681 YTD % of Full Year Actual/2022 Budget 36.8%35.1%37.1%34.1%36.6%34.3%34.3%33.0%33.8%36.5%31.7%34.2%35.7%39.8% 0 2,500,000 5,000,000 7,500,000 10,000,000 12,500,000 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 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 2023 15198876 16349133 15531592 16964139 17374434.53 18,950,211 19,240,977 19,181,590 20,890,820 22,268,272 24,666,543 23,194,359 24,326,007 24,486,681 36.8%35.1%37.1%34.1%36.6%34.3%34.3%33.0%33.8%36.5% 31.7%34.2%35.7% 39.8% 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 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 TOTAL CURRENT EXPENSE ACTUAL/2023 BUDGET TOTAL CURRENT EXPENSE TOTAL CURRENT EXPENSE ACTUAL/2023 BUDGET YTD % of Full Year Actual/2022 Budget April 2023 April OTHER FUNDS REVENUE REPORT 2023 Prepared by Jefferson County Treasurer 3 year view April 4 5/19/2023 Budget Appropriations reflected, Res 18-23 FUND Fund #Orig Budget Budget Amended BDGT Apr YTD YTD ACTUAL YTD YTD ACTUAL YTD YTD Revenue by Fund Type 2023 Amendment 2023 2023 2023 %2022 2022 %2021 2021 % SPECIAL REVENUE 103-199 28,360,948 38,260 28,389,748 3,373,696 9,082,385 32.0%31,294,333 8,100,289 25.9%25,780,431 8,842,331 34.4% DEBT SERVICE 200-299 - 0 - 6 23 434,825 1 0.0%- - CAPITAL IMPROVEMENT 300-399 3,898,066 0 3,898,066 243,786 699,064 17.9%5,174,478 2,355,273 45.5%4,068,574 769,347 30.5% ENTERPRISE 400-499 15,433,475 1,000,000 16,433,475 563,006 2,127,249 12.9%5,603,562 1,913,220 34.1%5,151,011 1,511,038 29.4% INTERNAL SERVICE 500-599 7,016,996 63,002 7,079,998 925,328 2,419,613 34.2%7,322,591 2,514,818 34.3%7,010,482 2,264,513 33.2% Total 54,709,485 1,101,262 55,801,287 5,105,823 14,328,334 25.7%49,829,791 14,883,601 29.9%42,010,498 13,387,230 33.3% Elections CARES Act 103 - - - - n/a - - n/a 6 5.26 n/aHAVA 3 Grant 104 - - 331 1,308 n/a 1,519 67 n/a 122 42.82 n/a Auditor's O & M 105 338,338 338,338 1,726 7,105 2.1%93,447 9,863 10.6%150,567 13,753.42 12.0% Court Facilitator 106 5,000 5,000 500 1,840 36.8%4,660 1,535 32.9%3,820 1,040.00 38.2%Boating Safety 107 44,500 44,500 - 3,750 8.4%29,311 3,863 13.2%48,454 14,934.41 33.6% WSU Cooperative (w/4H historical)108 492,738 88,800 581,538 23,084 135,226 23.3%462,621 127,885 27.6%372,854 106,212.95 24.9% Noxious Weed 109 194,017 194,017 44,364 89,778 46.3%197,990 88,250 44.6%232,892 101,629.36 52.3%JeffComCap 119 119 288,000 288,000 26,182 104,727 36.4%276,600 92,200 33.3%276,600 69,150.00 25.0% Crime Victim's Svc 120 81,543 81,543 1,878 31,257 38.3%96,753 54,111 55.9%103,427 47,583.14 58.4% Grant Mgmt 123 2,042,000 2,042,000 30,227 174,529 8.5%4,974,726 26,670 0.5%3,380,490 141,521.78 4.1% Hotel-Motel 125 655,000 655,000 145,748 333,104 50.9%843,505 217,082 25.7%802,738 197,017.80 36.7% H&HS Site Abatement 126 - - - - - - - Jeff Co Public Health 127 6,528,760 (60,000)6,468,760 655,622 2,473,185 38.2%7,741,461 2,345,554 30.3%5,902,647 2,177,016.43 41.3% Water Quality 128 862,791 862,791 146,919 368,789 42.7%1,022,533 427,279 41.8%1,471,427 662,707.12 48.6% Water Quality Land Acq 129 345,000 345,000 - - 0.0%- - - - 0.0% Mental Health 130 51,732 51,732 16,665 24,854 48.0%52,505 23,808 45.3%50,076 23,843.65 46.1% Chem Dep Mnt Hlth tx 131 768,777 768,777 59,207 255,410 33.2%801,399 230,442 28.8%711,230 205,721.58 32.3%JC Inmate Commissary 134 39,000 39,000 2,224 7,932 20.3%13,252 3,592 27.1%13,729 4,907.28 12.6% Drug Fund 135 600 600 120 229 38.1%(1,749) (1,933) 110.5%714 463.11 3.3% Law Library 140 16,418 16,418 648 3,808 23.2%11,889 5,574 46.9%12,848 7,287.64 44.4%Trial Court Imprvmnt 141 23,690 23,690 - 5,619 23.7%22,682 11,342 50.0%28,316 14,158.00 59.8% Community Develpmnt 143 1,878,160 1,878,160 99,055 595,395 31.7%2,123,712 646,812 30.5%2,219,243 948,400.96 47.8% Federal Forest Title III 147 20,500 20,500 21,516 23,482 114.5%23,298 20,412 87.6%16,041 15,928.78 75.9%Jeff Co Affrdbl Hsg 148 687,350 687,350 61,388 290,539 42.3%941,594 264,186 28.1%585,495 54,922.21 9.7% Homeless Housing Fund 149 245,500 245,500 16,249 102,288 41.7%340,427 106,592 31.3%508,681 145,302.62 34.5% Treasurer's O & M 150 57,700 57,700 634 1,722 3.0%7,315 927 12.7%60,617 1,276.86 1.9%REET technology 151 14,000 14,000 977 3,396 24.3%14,956 5,069 33.9%22,149 5,514.99 41.2%Veteran's Relief 155 67,172 67,172 17,528 32,455 48.3%77,084 31,400 40.7%70,676 44,022.94 66.7%Water Pollution Cntrl 160 - - - n/a 15,835 - 0.0%36,279 36,278.64 n/aPark & Rec 174 862,059 862,059 2,869 218,522 25.3%857,313 193,828 22.6%743,313 184,922.50 28.0% County Park Imprvmnt 175 168,450 168,450 976 976 0.6%145,416 3,629 2.5%178,690 6,372.00 3.9% Post Harvest Timber Mgmt Rsv 178 - 40 150 n/a 168 7 4.1%17 2.87 n/a County Roads 180 11,582,153 11,582,153 1,997,019 3,791,009 32.7%10,102,093 3,160,244 31.3%7,776,276 3,610,389.89 40.8% Jeff Co Emergency Rd Rsrv Fund 181 - - - - 19 2 Flood/Storm Water Mgmt 185 - - - - - - Brinnon Flood Control 186 - 9,460 - - - - - Quilcene Flood Control 187 - - - - - - RID Bonds 202 - - - - 0 0 Debt Service 204 - - 6 23 434,825 1 Const/Renovation 301 1,182,341 1,182,341 2,292 4,583 0.4%1,033,238 1,029,119 99.6%717,229 4,377 1.0% Capital Improvement 302 1,793,875 1,793,875 92,481 304,365 17.0%2,025,623 510,106 25.2%2,120,750 451,158 39.0%HJC Park Jump 304 - - 192 823 1,082,381 479,413 44.3%318,327 - 0.0% Public Infrastructure 306 651,500 651,500 57,840 246,880 37.9%743,680 210,538 28.3%646,864 187,752 33.1% Conservation Futures 308 270,350 270,350 90,982 142,413 52.7%289,556 126,097 43.5%265,403 126,060 47.0%Solid Waste 401 4,115,940 4,115,940 376,408 1,535,722 37.3%4,277,820 1,363,993 31.9%4,209,822 1,305,222 35.6% Solid Waste Post Clos 402 100 100 108 409 n/a 520 23 4.4%39 15 n/a Solid Waste Eqpt Res 403 2,000 2,000 3,674 13,846 692.3%14,999 613 4.1%914 342 2.3%Yard Waste Educ Fnd 404 8,000 8,000 32 120 1.5%5,819 6 0.1%7,681 2 0.0% Tri Area Sewer 405 11,307,435 1,000,000 12,307,435 182,784 577,152 4.7%1,304,404 548,585 42.1%932,555 205,458 14.2% Equipment Rental 501 3,094,690 3,094,690 235,162 757,721 24.5%3,060,433 709,486 23.2%3,134,281 673,246 23.6% Risk Management 502 150,000 150,000 - - 0.0%- - - - 0.0% Benefit Reserve 505 290,600 290,600 35,796 136,795 47.1%408,536 129,674 31.7%266,084 101,692 37.0% Information Services 506 2,127,979 63,002 2,190,981 541,559 1,073,323 49.0%2,549,633 1,241,935 48.7%2,334,012 1,033,957 45.2% Facilities Mgmt eff 6/21 507 1,353,727 1,353,727 112,812 451,774 33.4%1,303,990 433,722 33.3%1,276,105 455,619 36.2% April 2023 Other Fund Revenue - Year to Date April 4OTHER FUND REVENUE BY Fund #2015 2016 2017 2018 2019 2020 2021 2022 2023SPECIAL REVENUE 103-199 5,494,686 6,608,400 6,686,253 6,299,419 7,276,600 7,080,223 8,842,331 8,100,289 9,082,385 DEBT SERVICE 200-299 - - - - - - - 1 23 CAPITAL IMPROVEMENT 300-399 565,993 798,642 1,048,447 573,900 788,648 678,708 769,347 2,355,273 699,064 ENTERPRISE 400-499 933,466 911,487 1,044,870 1,059,025 1,193,063 1,141,289 1,511,038 1,913,220 2,127,249 INTERNAL SERVICE 500-599 1,745,390 1,738,870 1,785,523 2,050,816 2,090,430 2,137,135 2,264,513 2,514,818 2,419,613 TOTAL OTHER FUNDS 8,739,534 10,057,398 10,565,093 9,983,159 11,348,740 11,037,355 13,387,230 14,883,601 14,328,334 FULL YEAR/CY BUDGET 30,318,676 31,352,497 31,654,217 32,145,027 33,096,381 34,837,866 42,010,498 49,829,791 54,709,485 YTD % OF FY/CY BUDGET 28.8%32.1%33.4%31.1%34.3%31.7%31.9%29.9%26.2%OTHER FUND REVENUE BY Fund #2015 2016 2017 2018 2019 2020 2021 2022 2023Elections CARES Act 103 - - - - - - 5 - - HAVA 3 Grant 104 - - - - - - 43 67 1,308 Auditor's O & M 105 8,043 7,692 8,642 8,443 7,652 9,398 13,753 9,863 7,105 Court Facilitator 106 2,063 1,980 2,120 1,720 1,640 1,020 1,040 1,535 1,840 Boating Safety 107 18,420 24,200 15,458 15,607 17,085 15,384 14,934 3,863 3,750 WSU Cooperative (w/4H histo 108 99,602 212,623 181,778 231,103 146,793 135,476 106,213 127,885 135,226 Noxious Weed 109 - - - - 84,186 89,503 101,629 88,250 89,778 JeffComCap 119 119 91,837 91,597 85,072 88,232 68,000 68,880 69,150 92,200 104,727 Crime Victim's Svc 120 22,718 17,847 27,589 29,185 49,559 12,924 47,583 54,111 31,257 Grant Mgmt 123 12,569 61,457 44,074 50,937 45,377 38,047 141,522 26,670 174,529 Hotel-Motel 125 82,520 102,634 110,276 112,570 119,150 124,876 197,018 217,082 333,104 H&HS Site Abatement 126 - - - - - - - - - Jeff Co Public Health 127 1,209,335 1,562,978 1,487,842 1,402,234 1,649,915 1,702,334 2,177,016 2,345,554 2,473,185 Water Quality 128 321,552 369,532 348,960 358,872 361,924 391,180 662,707 427,279 368,789 Water Quality Land Acq 129 - - - - - - - - - Mental Health 130 22,065 21,366 19,881 22,604 24,743 23,686 23,844 23,808 24,854 Chem Dep Mnt Hlth tx 131 129,993 150,456 156,525 165,588 176,701 188,431 205,722 230,442 255,410 JC Inmate Commissary 134 - - - - - - 4,907 3,592 7,932 Drug Fund 135 4,877 4,428 4,235 4,628 3,241 1,928 463 (1,933) 229 Law Library 140 3,831 3,100 3,150 3,427 3,006 7,444 7,288 5,574 3,808 Trial Court Imprvmnt 141 11,348 11,236 5,863 11,605 11,400 14,168 14,158 11,342 5,619 Community Develpmnt 143 454,517 495,633 444,052 403,872 417,326 419,713 948,401 646,812 595,395 Federal Forest Title III 147 21 21,710 153 359 19,757 17,702 15,929 20,412 23,482 Jeff Co Affrdbl Hsg 148 72,308 71,188 79,478 76,282 13,659 21,393 54,922 264,186 290,539 Homeless Housing Fund 149 - - - - 82,891 101,733 145,303 106,592 102,288 Treasurer's O & M 150 4,823 4,413 1,687 5,107 2,586 4,835 1,277 927 1,722 REET technology 151 4,308 4,669 4,812 4,887 4,203 4,364 5,515 5,069 3,396 Veteran's Relief 155 37,819 37,569 36,609 40,046 43,019 42,322 44,023 31,400 32,455 Water Pollution Cntrl 160 1,418 10,315 - - - - 36,279 - - Park & Rec 174 191,424 136,764 172,591 161,730 162,490 144,985 184,923 193,828 218,522 County Park Imprvmnt 175 1,867 2,370 1,332 2,283 10,840 3,317 6,372 3,629 976 Post Harvest Timber Mgmt Rs 178 - - - - 72 49 3 7 150 County Roads 180 2,685,404 3,180,643 3,444,074 3,098,101 3,749,386 3,495,132 3,610,390 3,160,244 3,791,009 Jeff Co Emergency Rd Rsrv F 181 - - - - - - - 2 - Flood/Storm Water Mgmt 185 - - - - - - - - - Brinnon Flood Control 186 - - - - - - - - - Quilcene Flood Control 187 - - - - - - - - - RID Bonds 202 - - - - - - - 0 - Debt Service 204 - - - - - - - 1 23 Const/Renovation 301 22,150 285,634 501,755 3,617 197,264 48,732 4,377 1,029,119 4,583 Capital Improvement 302 311,958 265,110 296,361 292,935 288,148 326,470 451,158 510,106 304,365 HJC Park Jump 304 - - - - - - - 479,413 823 Public Infrastructure 306 118,128 137,140 144,219 154,701 167,863 175,192 187,752 210,538 246,880 Conservation Futures 308 113,757 110,757 106,113 122,648 135,373 128,315 126,060 126,097 142,413 Solid Waste 401 932,980 910,070 1,040,120 1,050,907 1,144,813 1,133,790 1,305,222 1,363,993 1,535,722 Solid Waste Post Clos 402 30 79 166 266 394 196 15 23 409 Solid Waste Eqpt Res 403 226 649 2,322 4,150 7,012 3,878 342 613 13,846 Yard Waste Educ Fnd 404 3 11 8 28 74 17 2 6 120 Tri Area Sewer 405 227 678 2,254 3,672 40,770 3,408 205,458 548,585 577,152 Equipment Rental 501 552,440 499,399 541,012 582,463 695,851 638,573 673,246 709,486 757,721 Risk Management 502 - 178 - - - - - - - Benefit Reserve 505 83,877 86,738 87,437 92,536 100,704 154,779 101,692 129,674 136,795 Information Services 506 768,519 731,684 810,617 987,696 909,190 918,540 1,033,957 1,241,935 1,073,323 Facilities Mgmt eff 6/21 507 340,554 420,870 346,457 388,122 384,685 425,243 455,619 433,722 451,774 50.0% 60.0% 70.0% 80.0% 90.0% 100.0% (5,000,000) 5,000,000 15,000,000 25,000,000 35,000,000 45,000,000 55,000,000 2015 2016 2017 2018 2019 2020 2021 2022 2023 OTHER FUND REVENUE BY TYPEINTERNAL SERVICE500-599 ENTERPRISE 400-499 CAPITALIMPROVEMENT300-399 DEBT SERVICE 200-299 SPECIAL REVENUE103-199 TOTAL OTHERFUNDS FULL YEAR/CYBUDGET YTD % OF FY/CYBUDGET - 5,000,000 10,000,000 15,000,000 20,000,000 25,000,000 30,000,000 2015 2016 2017 2018 2019 2020 2021 2022 2023 OTHER FUND REVENUE BY FUND Facilities Mgmt eff 6/21 Information Services Benefit Reserve Risk Management Equipment Rental Tri Area Sewer Yard Waste Educ Fnd Solid Waste Eqpt Res Solid Waste Post Clos Solid Waste Conservation Futures Public Infrastructure HJC Park Jump Capital Improvement Const/Renovation Debt Service RID Bonds Quilcene Flood Control Brinnon Flood Control Flood/Storm Water Mgmt Jeff Co Emergency Rd Rsrv Fund County Roads Post Harvest Timber Mgmt Rsv County Park Imprvmnt Park & Rec Water Pollution Cntrl Veteran's Relief REET technology Treasurer's O & M Homeless Housing Fund Jeff Co Affrdbl Hsg Federal Forest Title III Community Develpmnt Trial Court Imprvmnt Law Library Drug Fund JC Inmate Commissary Chem Dep Mnt Hlth tx Mental Health Water Quality Land Acq Water Quality Jeff Co Public Health H&HS Site Abatement Hotel-Motel Grant Mgmt Crime Victim's Svc JeffComCap 119 Noxious Weed WSU Cooperative (w/4H historical) Boating Safety Court Facilitator Auditor's O & M HAVA 3 Grant Elections CARES Act GENERAL FUND CASH BALANCE REPORT April 5/22/2023 END OF MONTH CASH BALANCES 2008 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 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$ 7,593,140$ 7,065,714$ 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$ 5,616,337$ 6,597,055$ 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$ 6,517,369$ 6,963,369$ 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$ 8,801,638$ 9,347,020$ 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$ 8,570,220$ 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$ 10,082,081$ 9,593,296$ 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,312,713$ 9,062,286$ 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,345,143$ 8,247,770$ September $2,986,861 1,596,637$ 2,312,554$ 1,734,730$ 2,217,696$ 2,118,250$ 3,742,452$ 4,710,400$ 4,724,294$ 4,511,047$ 5,850,565$ 5,829,324$ 7,775,786$ 7,593,055$ 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$ 8,938,894$ 8,925,753$ 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$ 8,525,829$ 8,415,851$ 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$ 8,011,624$ 8,098,994$ 13th Month 8,011,624$ 6,736,342$ 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 2022 2023 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,996,889 $ 4,067,663 $ 3,906,731 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,996,889 $ 4,067,663 $ 3,906,731 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,973,494$ 2,668,679$ 5,440,288$ 200820102011201220132014201520162017201820192020202120222023 $0 $2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 $12,000,000 January March May July September November 13th Month General Fund Cash Balance $0 $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000 $7,000,000 $8,000,000 $9,000,000 $10,000,000 2008 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023Budg Reserve and Cash Balance Composition 15% GF Budgeted Expenditures *Revenue Stabilization Non-Reserve Cash Balance April 4 April 5/19/2023 2023 General Fund Treasurer 001.250 Sales 31311 Special Purpose 31315 9 MONTHLY SALES TAX RECEIPTS Revenue Cumulative Cumulative 3 yr. avg Expected Actual Over/Under % of 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2020-2022 2023 2023 Expected expected ProjectionJanuary154,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 354,280 393,215 7.4%389,774 393,215 $3,441 100.88%$5,279,490February224,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 398,029 412,586 8.6%449,256 412,586 -$33,229 96.04%$5,026,031March142,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 350,367 382,123 6.8%353,978 382,123 -$8,526 99.57%$5,210,986April156,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 333,775 377,962 6.7%353,089 377,962 $53,018 101.28%$5,300,273May198,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 429,025 8.2%430,895 - 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 401,566 7.6%397,749 - 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 416,750 8.6%449,717 - 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 467,081 9.5%497,835 - September 211,602 211,286 200,636 213,505 187,214 173,733 169,379 242,312 198,879 212,018 227,766 247,376 241,325 307,750 319,609 372,118 395,639 432,971 9.1%475,520 - 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 402,815 451,872 9.2%483,112 - 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 428,588 487,075 9.7%508,771 - 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 360,336 436,352 8.5%443,593 - 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 4,482,583 4,959,143 1,565,886 100.0%$5,233,290 $1,565,886ytd 677,910 755,743 744,745 747,059 698,229 602,719 603,051 583,972 774,747 706,129 735,538 824,447 879,672 896,731 1,024,215 1,159,785 1,307,786 1,436,451 1,565,886 1,546,097 1,565,886 19,789 ytd change 11.48%-1.46%0.31%-6.54%-13.68%0.06%-3.16%32.67%-8.86%4.16%12.09%6.70%1.94%14.22%13.24%12.76%9.84%9.01%1.28%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%18.81%10.63%Cumulative Cumulative Special Purp./Public Safety Tax 3 yr avg.Projection Actual Over/Under % of20052006200720082009201020112012201320142015201620172018201920202021202220232019-21 2023 2023 Expected expected Projection January 45,217 50,919 50,377 51,210 58,026 61,161 66,993 79,236 84,751 89,951 99,009 121,134 7.5%97,326 121,134 $23,808 124.46%$1,622,092February61,899 70,678 67,508 73,364 83,521 93,242 90,853 94,690 101,181 104,630 113,672 120,428 8.7%113,602 120,428 $6,826 114.52%$1,492,566March40,604 56,106 49,782 50,931 62,285 61,183 66,479 70,614 72,888 80,801 95,448 106,525 6.8%88,588 106,525 $17,937 116.22%$1,514,630April43,155 51,054 47,573 52,541 59,481 59,911 63,784 65,310 69,887 83,697 95,308 104,345 6.8%88,501 104,345 $15,844 116.60%$1,519,642May51,908 58,324 56,012 62,613 74,233 78,716 84,357 88,754 75,138 107,326 119,872 8.2%107,505 - June 45,930 46,797 50,067 48,647 58,717 65,832 65,229 75,141 77,429 68,693 99,946 110,725 7.6%99,336 - July 55,488 49,385 68,295 54,074 56,793 69,908 73,136 81,117 89,815 86,275 107,036 115,043 8.4%109,644 - August 59,578 56,220 56,063 68,712 76,734 87,275 89,679 97,261 107,514 94,459 123,789 129,406 9.5%123,619 - September 55,746 54,902 61,455 64,622 72,022 77,854 77,534 97,036 94,733 96,212 112,903 124,207 9.1%118,523 - October 59,692 61,120 64,400 64,152 73,903 82,028 82,991 95,473 97,187 101,038 111,516 139,292 9.6%125,109 - November 58,107 60,952 64,915 71,491 77,947 89,596 90,736 98,020 105,075 102,364 120,031 140,213 9.9%128,936 - December 46,767 49,281 52,177 59,043 62,263 66,133 69,582 83,431 93,783 67,940 101,650 118,938 7.9%102,595 - TOTAL 381,308 621,440 704,453 701,993 769,039 876,170 903,099 999,945 1,064,140 1,020,826 1,243,276 1,401,133 452,432 100.0%1,303,286 452,432 ytd 0 190,875 228,757 215,240 228,046 263,312 275,497 288,110 309,850 328,707 359,079 403,437 452,432 388,018 $452,432ytd change 19.85%-5.91%5.95%15.46%4.63%4.58%7.55%6.09%9.24%12.35%12.14%16.60%over (under) ytd expectedannual % chg.62.98%13.36%-0.35%9.55%13.93%3.07%10.72%6.42%-4.07%21.79%12.70% Sales Tax receipts are for the approximate timeframe of two months prior depending on the business reporting schedules.3 yr. avg YTD Budget YTD Actual Over/Under % of Year End Sales Tax 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2020-2022 2023 2023 Expected expected Projection General & Option 677,910 755,743 744,745 747,059 698,229 602,719 603,051 583,972 774,747 706,129 735,538 824,447 879,672 896,731 1,024,215 1,159,785 1,307,786 1,436,451 1,565,886 1,546,097 1,565,886 19,789 101.3%$5,300,273Special Purpose - - - - - - - 190,875 228,757 215,240 228,046 263,312 275,497 288,110 309,850 328,707 359,079 403,437 452,432 388,018 452,432 64,414 116.6%$1,519,642G&O and SP Sal 677,910 755,743 744,745 747,059 698,229 602,719 603,051 774,847 1,003,504 921,369 963,583 1,087,759 1,155,168 1,184,841 1,334,064 1,488,492 1,666,865 1,839,888 2,018,317 1,934,114 2,018,317 84,203 104.4%6,819,915 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,793,593 5,725,858 6,355,574 6,355,574 6,536,576 ytd change 11.5%-1.5%0.3%-6.5%-13.7%0.1%28.5%29.5%-8.2%4.6%12.9%6.2%2.6%12.6%11.6%12.0%10.4%9.7%4.4%over (under) ytd expectedannual % chg.6.8%-0.6%-1.8%-11.3%-10.3%22.5%13.6%14.4%-1.6%8.4%11.0%4.6%11.0%11.2%2.7%19.4%11.1% - 1,000,000 2,000,000 3,000,000 4,000,000 5,000,000 6,000,000 20 0 5 20 0 6 20 0 7 20 0 8 20 0 9 20 1 0 20 1 1 20 1 2 20 1 3 20 1 4 20 1 5 20 1 6 20 1 7 20 1 8 20 1 9 20 2 0 20 2 1 20 2 2 20 2 3 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 2023 0 1000000 2000000 3000000 4000000 5000000 6000000 20 0520 06 20 07 20 0820 09 20 1020 11 20 12 20 1320 14 20 1520 16 20 17 20 1820 19 20 2020 21 20 22 20 23 Sales Tax and Special Purpose Sales Tax YTD, Actual Total and 2023 Budget Special PurposeYTD General &Optional YTD April 2023 514,349 533,013 488,648 482,307 ------ -- - 100,000 200,000 300,000 400,000 500,000 600,000 700,000 1 2 3 4 5 6 7 8 9 10 11 12 2023 Monthly Actual Revenue & Budgeted Share $365,007 $(17,979)$189,040 $283,339 -$500,000 $500,000 $1,500,000 $2,500,000 $3,500,000 $4,500,000 $5,500,000 $6,500,000 $7,500,000 2023 Cumulative YTD Actual & Budget Expected by Month April $0.00 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 Chg23Construction88,202 81,282 9%382,337 336,723 14%45,614 42%1,285,355 Construction 7,100 6,820 4%38,411 25,790 49%12,621 60%114,536 31, 32, 33 Manufacturing 7,830 4,858 61%35,263 33,778 4%1,485 1%107,342 Manufacturing 908 602 51%3,741 3,236 16%505 2%12,664 42 Wholesale Trade 21,711 17,260 26%85,402 74,088 15%11,314 10%250,172 Wholesale Trade 2,928 3,641 -20%13,206 12,092 9%1,114 5%38,25444, 45 Retail Trade 115,412 106,366 9%477,585 467,686 2%9,899 9%1,491,428 Retail Trade 14,435 13,221 9%67,245 64,075 5%3,170 15%208,23348, 49 Transportation & Warehousing 946 1,282 -26%4,145 4,911 -16%(766)-1%10,439 Transportation and Warehousing 284 205 39%794 565 41%229 1%4,987 51 Information 10,306 8,832 17%42,310 45,698 -7%(3,388)-3%130,464 Information 1,151 985 17%4,841 4,294 13%547 3%14,219 52 Finance & Insurance 1,724 1,134 52%12,796 4,381 192%8,415 8%24,944 Finance and Insurance 192 260 -26%2,546 1,308 95%1,238 6%5,76153Real Estate, Rental & Leasing 3,674 4,146 -11%17,039 21,509 -21%(4,470)-4%68,935 Real Estate and Rental and Leasing 394 354 11%1,337 2,213 -40%(876)-4%4,96854Professional, Scientific & Technical Services 9,085 8,180 11%30,828 24,120 28%6,708 6%81,627 Professional, Scientific, and Technical Services 628 1,033 -39%3,256 3,120 4%136 1%11,086 56 Admin & Support, Waste Mgmt & Remediation Svcs 20,929 23,564 -11%103,840 100,803 3%3,037 3%338,662 Admin & Support, Waste Mgmt & Remediation Sv 1,871 1,539 22%7,837 6,850 14%987 5%24,111 61 Educational Services 92 220 -58%1,082 973 11%109 0%4,888 Educational Services 31 44 -30%243 511 -52%(268)-1%72662Health Care and Social Assistance 98 89 10%417 500 -17%(83)0%1,867 Health Care and Social Assistance 594 329 81%2,423 1,852 31%571 3%6,50671Arts, Entertainment & Recreation 1,361 994 37%5,368 4,490 20%878 1%27,406 Arts, Entertainment, and Recreation 230 260 -12%1,031 788 31%243 1%4,612 72 Accommodation & Food Services 34,117 16,242 110%106,807 60,711 76%46,096 43%358,555 Accommodation and Food Services 4,857 4,012 21%19,607 15,095 30%4,512 21%79,182 55, 81, 92 Public Administration & Other Services 6,096 6,350 -4%28,003 29,186 -4%(1,183)-1%88,804 Public Administration & Other Services 1,625 2,650 -39%6,201 8,471 -27%(2,270)-11%19,979 0 Unclassified 12,771 14,635 -13%45,559 67,020 -32%(21,461)-20%225,965 Natural Resources, Utilities & Unclassified 435 850 -49%1,267 2,683 -53%(1,416)-7%9,22711Agriculture, Forestry, Fishing & Hunting 841 393 114%1,784 3,138 -43%(1,354)-1%7,209 City of Port Townsend Totals 37,664 36,805 2%173,986 152,943 14%21,043 100%559,051 21 Mining, Quarrying, Oil & Gas Extraction 951 1,038 -8%4,383 3,333 32%1,050 1%14,189 Totals for Jefferson County and City of PT added together equal the total sales tax revenue received by Jefferson Co. 22 Utilities 4,151 107 3779%6,929 450 1440%6,479 6%11,248 NAICS & SIC Identification Tools page https://www.naics.com/search/Jefferson County, WA Totals 340,298 296,972 15%1,391,877 1,283,498 8%108,379 100%4,529,499 $377,962.00 Calculated General & Optional Sales Tax Revenue to Jefferson County for this period Last 12 Months Current Period: 202302 Cash Basis, Revenue Amounts Jefferson County Year to DateCurrent Period Last 12 Months NAICS CODE Current Period Year to Date 9%61%26%9% -26% 17%52% -11% 11% -11% 10%37%110% -4%-13% 114% -8% 3779% -50% 450% 950% 1450% 1950% 2450% 2950% 3450% 3950% 4450% -150,000 -100,000 -50,000 0 50,000 100,000 150,000 Jefferson County Amounts and Percentage Change from last year This Year Last Year % Chg Current Period: 202302 Cash Basis, Revenue Amounts 4% 51% -20% 9% 39%17% -26% 11% -39% 22% -30% 81% -12% 21% -39% -100% -50% 0% 50% 100% 150% 200% 250% 300% 350% -50,000 -40,000 -30,000 -20,000 -10,000 0 10,000 20,000 30,000 40,000 50,000 City of PT Amounts and Percentage Change from last year This Year Last Year % Chg Current Period: 202302 Cash Basis, Revenue 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 … Educational Services Health 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 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 ExtractionUtilities Unincorporated Jefferson County, WA Sales Tax by Sector For February 2023 with Distribution in April 2023 4 2023 April 302.000 Capital Improvement fund, not other financing sources, transfer, appropriation$ Recent 2023 % Budget Month Change projection 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 4 YR AVG Budget Difference prior year Projection d Over/Under 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 98,647 52,079 80,064 80,308 -35.2%-47.2%$1,131,406 (618,594)$ 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 102,747 49,140 85,717 85,979 -42.8%-52.2%$1,061,988 (688,012)$ 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 173,818 110,665 117,675 118,033 -6.2%-36.3%$1,300,191 (449,809)$ 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 134,888 92,481 110,513 110,850 -16.6%-31.4%$1,343,778 (406,222)$ 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 193,208 138,763 139,186 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 194,646 174,325 174,856 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 207,020 174,767 175,299 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 179,197 194,563 195,156 September $147,903 $104,040 $67,136 $39,174 47,520$ 46,444$ 37,641$ 54,626$ 67,050$ 71,552$ 219,697$ 95,883$ 181,336$ 117,652$ 105,075 211,718 192,392 168,568 169,438 169,955 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 242,114 170,496 209,566 210,205 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 144,089 120,228 125,508 125,890 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 142,371 237,466 163,783 164,282 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 $2,039,050 $1,980,929 $304,365 1,744,682 1,750,000$ -82.6% YTD 388,998 324,278 292,038 259,700 221,400 150,204 179,076 134,191 150,633 167,255 311,958 265,110 296,361 292,935 288,148 326,470 451,158 510,100 304,365 393,969$ 395,170$ -23.0%-40.3% YTD change -16.64%-9.94%-11.07%-14.75%-32.16%19.22%-25.06%12.25%11.03%86.52%-15.02%11.79%-1.16%-1.63%13.30%38.19%13.06%-40.33% Annual % chg -16.64%-9.94%-11.07%-14.75%-32.16%4.08%23.83%28.91%-0.49%69.93%3.41%3.84%-1.71%2.42%37.46%19.05%-2.85% 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 $2,039,050 $1,980,929 $1,750,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 586,691,234 585,916,431 Unicorporated Jefferson County 155,466,572 161,146,595 246,434,374 273,419,377 255,274,752 248,190,092 248,379,035 339,058,010 413,458,596 397,008,194 City of PT 64,067,311 76,017,525 101,721,544 121,960,579 149,145,923 117,252,396 121,437,249 112,313,968 173,232,638 188,908,237 Annual % chg 8.03%46.80%13.56%2.29%-9.64%1.20%22.05%29.98%-0.13% Jan 2021 10 sales>$500k,1@$1.7M July 2021 28 sales >$500 with 6 sales >$1 million Jan 2022 17 sales>$500k,2>$1.0M July 2022 4>$1.0M Jan 2023 0>1.0M Feb 2021 13 sales>$500k,1@$2.05M,1@$1.25M Aug 2021 45 sales >$500 with 8 sales >$1 million Feb 2022 17 sales>$500k,4>$1.0M August 2022 1>$1.0M Feb 2023 0>1.0M Mar 2021 15 sales>$500k,2@$1.23 and $1.25M Sep 2021 31 sales >$500 with 5 sales >$1 million Mar 2022 6 sales>$1.0M Sept 2022 4>$1.0M Mar 2023 4>1.0M Apr 2021 19 sales>$500k,2@$1.3 and 1@$1.2M Oct 2021 43 sales >$500 with 8 sales >$1 million Apr 2022 3>$1.0M Oct 2022 9>$1.0M Apr 2023 2>1.0M May 2021 27 sales>$500k,1@$1.5 and 1@$1.225M Nov 2021 27 sales >$500 with 4 sales >$1 million May 2022 8>$1.0M Nov 2022 5>$1.0M June 2021 28 sales>$500k, 5>$1.0 million Dec 2021 23 sales >$500 w/ 4 sales >$1 million June 2022 10>$1.0M (w 2>$2M)Dec 2022 7>$1.0M w 1>$10M 5/19/2023 $0 $500,000 $1,000,000 $1,500,000 $2,000,000 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 Real Estate Excise Tax Collections -2005 to 2023 Fund 302 Capital Improvement Fund December November October September August July June May April March February January Actual Full Year orBudget $(618,594)$(688,012) $(449,809)$(406,222) -750,000 -250,000 250,000 750,000 1,250,000 1,750,000 REET 2023 YTD Actual Total & Budget YTD Actual YTD Budget Projected Over/Under Budget 52,079 49,140 110,665 92,481 0 0 0 0 0 0 0 00 50,000 100,000 150,000 200,000 250,000 2023 Monthly Actual Revenue & Budgeted Share 2023 Actual Budget April Excise Detail - Jefferson County From 4/1/2023 to 4/30/2023 PACS DATA PIVOT TABLE DataRow Labels Sum of Local Paid Sum of 1% of Local Sum of Local minus 1%Sum of Loc Int City of Port Townsend, Fund 654 0110 35,312.21$ 353.12$ 34,959.09$ -$ 0111 23,030.00$ 230.30$ 22,799.70$ -$ 0151 -$ -$ -$ -$ 0211 12,397.50$ 123.98$ 12,273.53$ -$ 0221 -$ -$ -$ -$ 0222 1,425.00$ 14.25$ 1,410.75$ -$ 0231 44,831.78$ 448.32$ 44,383.46$ -$ 0320 1,875.00$ 18.75$ 1,856.25$ -$ 0321 -$ -$ -$ -$ 0323 1,345.00$ 13.45$ 1,331.55$ -$ 0324 -$ -$ -$ -$ 0440 1,400.00$ 14.00$ 1,386.00$ -$ 0441 3,600.00$ 36.00$ 3,564.00$ 4.35$ 0502 909.00$ 9.09$ 899.91$ -$ 0571 -$ -$ -$ -$ 0601 10.00$ 0.10$ 9.90$ -$ 0691 475.00$ 4.75$ 470.25$ -$ 0781 2,112.50$ 21.13$ 2,091.38$ -$ (blank) Total Jefferson County Grand Total 128,722.99$ 1,287.23$ 127,435.76$ 4.35$ Unincorporated Jefferson County, 302 93,410.78$ 934.11$ 92,476.67$ 4.35$ City of Port Townsend, Fund 654 35,312.21$ 353.12$ 34,959.09$ -$ STATE PROCESSED REET /AUDIT DISTRIBUTIONUnincorporated Jefferson County, 302 City of Port Townsend, Fund 654 MUNIS GENERAL LEDGER 001.250.60.34142.341084.Treas Fee 1%1,287.25$ 127,435.76$ 302.000.44.31834.318000.Actual County Dist 46,238.36$ 302.000.44.31835.318001.Actual County Dist 46,238.29$ 654.600.85.31834.318002.Actual City Dist 17,479.57$ 654.600.85.31835.318004.Actual City Dist 17,479.52$ Variance Munis-PACS due to rounding at transaction level***(0.02)$ 0.02$ Total Jefferson County Unincorporated Jefferson County, 302 92,476.65$ City of Port Townsend, Fund 654 34,959.09$ ***Distribution amounts will be slightly off since admin fees gets calculated with each transaction, not as a whole City of PT 0110PT Unicorp 0111 Chimacum 0203 Nordland & Chimacum 0211Port Ludlow 0231 Quilcene 0321 Quilcene 0323Forks0502 Sequim 0781Brinnon0441 REET Excise Bal Date Sale Date Total Paid Type Geo ID Area Sale Price Taxable State Paid Local Paid ST Int Loc Int Penalty Tech Proc Ov/Undr 1% of Local Local minus 1% 22559 140696 04/04/2023 02/27/2023 10.00 R 021202034 0211 0.00 49,000.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22573 140685 04/04/2023 03/24/2023 10,505.40 R 001292011 0111 643,000.00 775,131.00 7,285.40 3,215.00 0.00 0.00 0.00 5.00 0.00 0.00 32.15$ 3,182.85$ 22574 140686 04/04/2023 03/23/2023 18,640.00 R 991600601 0110 1,100,000.00 970,913.00 13,135.00 5,500.00 0.00 0.00 0.00 5.00 0.00 0.00 55.00$ 5,445.00$ 22575 140687 04/04/2023 03/27/2023 11,075.00 R 957312706 0110 675,000.00 599,170.00 7,695.00 3,375.00 0.00 0.00 0.00 5.00 0.00 0.00 33.75$ 3,341.25$ 22576 140688 04/04/2023 03/23/2023 6,565.00 R 821061003 0231 410,000.00 275,340.00 4,510.00 2,050.00 0.00 0.00 0.00 5.00 0.00 0.00 20.50$ 2,029.50$ 22578 140690 04/04/2023 03/24/2023 10.00 R *502291003 0441 0.00 706,714.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22579 140691 04/04/2023 03/27/2023 10.00 R 821351025 0231 0.00 502,326.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22580 140692 04/05/2023 03/29/2023 10.00 R 901314002 0151 0.00 492,382.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22581 140693 04/05/2023 03/30/2023 10.00 R 901314002 0151 0.00 492,382.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22582 140694 04/05/2023 03/22/2023 10,541.00 R 965000282 0111 645,000.00 485,784.00 7,311.00 3,225.00 0.00 0.00 0.00 5.00 0.00 0.00 32.25$ 3,192.75$ 22583 140695 04/03/2023 08/09/2022 10.00 R 990700082 0231 0.00 364,523.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22584 140697 04/06/2023 03/28/2023 10,825.80 R 948318506 0110 661,000.00 346,829.00 7,515.80 3,305.00 0.00 0.00 0.00 5.00 0.00 0.00 33.05$ 3,271.95$ 22585 140699 04/04/2023 01/19/2023 10.00 R 702133018 0324 0.00 66,885.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22586 140700 04/04/2023 01/19/2023 10.00 R 956100027 0324 0.00 113,090.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22587 140698 04/06/2023 03/23/2023 6,717.00 R 962114409 0211 419,500.00 369,938.00 4,614.50 2,097.50 0.00 0.00 0.00 5.00 0.00 0.00 20.98$ 2,076.53$ 22588 140701 04/06/2023 04/04/2023 2,885.00 R 980700522 0441 180,000.00 94,209.00 1,980.00 900.00 0.00 0.00 0.00 5.00 0.00 0.00 9.00$ 891.00$ 22589 140702 04/04/2023 04/03/2023 10.00 R 801044006 0211 0.00 154,316.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22590 140703 04/06/2023 04/04/2023 10.00 R 969500010 0231 0.00 524,569.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22591 140704 04/04/2023 04/04/2023 10.00 R *965702802 0110 0.00 1,773,715.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22592 140705 04/04/2023 04/04/2023 10.00 R 901201011 0151 0.00 45,049.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22593 140706 04/04/2023 04/04/2023 10.00 R *902243022 0211 0.00 544,070.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22594 140707 04/07/2023 04/03/2023 645.00 R 990700086 0231 40,000.00 60,000.00 440.00 200.00 0.00 0.00 0.00 5.00 0.00 0.00 2.00$ 198.00$ 22595 140708 04/06/2023 03/30/2023 965.00 MH 930806018 0211 60,000.00 38,765.00 660.00 300.00 0.00 0.00 0.00 5.00 0.00 0.00 3.00$ 297.00$ 22596 140709 04/10/2023 04/03/2023 7,989.00 R 990700087 0231 499,000.00 387,949.00 5,489.00 2,495.00 0.00 0.00 0.00 5.00 0.00 0.00 24.95$ 2,470.05$ 22597 140710 04/06/2023 04/04/2023 10.00 R *957306503 0110 0.00 890,353.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22598 140711 04/06/2023 04/06/2023 10.00 R 965700902 0110 0.00 708,162.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22599 140712 04/06/2023 04/06/2023 10.00 R 965700902 0110 0.00 708,162.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22600 140713 04/10/2023 04/01/2022 10.00 R 901112041 0211 0.00 71,010.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22601 140714 04/11/2023 03/28/2023 33.80 R 951000210 0502 1,800.00 313,188.00 19.80 9.00 0.00 0.00 0.00 5.00 0.00 0.00 0.09$ 8.91$ 22602 140715 04/11/2023 04/04/2023 2,325.00 R 962110402 0211 145,000.00 25,000.00 1,595.00 725.00 0.00 0.00 0.00 5.00 0.00 0.00 7.25$ 717.75$ 22603 140716 04/11/2023 03/30/2023 4,005.00 R *931401902 0110 250,000.00 200,000.00 2,750.00 1,250.00 0.00 0.00 0.00 5.00 0.00 0.00 12.50$ 1,237.50$ 22604 140717 04/11/2023 04/07/2023 10.00 R *821343026 0231 0.00 2,702,439.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22605 140718 04/11/2023 04/07/2023 10.00 R 933800402 0110 0.00 503,153.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22606 140719 04/11/2023 04/07/2023 10.00 R 933800402 0110 0.00 503,153.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22607 140720 04/11/2023 04/07/2023 10.00 R *821343026 0231 0.00 2,702,439.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22608 140721 04/11/2023 04/03/2023 4,405.00 R 988600014 0441 275,000.00 191,519.00 3,025.00 1,375.00 0.00 0.00 0.00 5.00 0.00 0.00 13.75$ 1,361.25$ 22609 140722 04/12/2023 04/03/2023 11,075.00 R 921042021 0211 675,000.00 561,216.00 7,695.00 3,375.00 0.00 0.00 0.00 5.00 0.00 0.00 33.75$ 3,341.25$ 22610 140723 04/10/2023 04/04/2023 4,565.00 R 701105012 0222 285,000.00 248,970.00 3,135.00 1,425.00 0.00 0.00 0.00 5.00 0.00 0.00 14.25$ 1,410.75$ 22611 140727 04/10/2023 01/19/2023 10.00 R 939900023 0111 0.00 273,745.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22612 140724 04/10/2023 04/10/2023 29.00 R 965202311 0111 1,500.00 1,500.00 16.50 7.50 0.00 0.00 0.00 5.00 0.00 0.00 0.08$ 7.43$ 22613 140728 04/10/2023 04/06/2023 10.00 R 921182007 0211 0.00 501,047.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22614 140725 04/12/2023 04/04/2023 9,117.00 R 995500053 0231 565,000.00 670,713.00 6,287.00 2,825.00 0.00 0.00 0.00 5.00 0.00 0.00 28.25$ 2,796.75$ 22615 140726 04/10/2023 03/28/2023 10.00 R 701294015 0321 0.00 140,501.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22616 140729 04/12/2023 04/05/2023 18,017.00 R 978900012 0231 1,065,000.00 870,874.00 12,687.00 5,325.00 0.00 0.00 0.00 5.00 0.00 0.00 53.25$ 5,271.75$ 22617 140730 04/13/2023 03/14/2023 4,245.00 R *961808808 0211 265,000.00 186,476.00 2,915.00 1,325.00 0.00 0.00 0.00 5.00 0.00 0.00 13.25$ 1,311.75$ 22618 140731 04/13/2023 04/04/2023 12,410.00 R 946100012 0111 750,000.00 608,550.00 8,655.00 3,750.00 0.00 0.00 0.00 5.00 0.00 0.00 37.50$ 3,712.50$ 22619 140741 04/12/2023 02/24/2023 10.00 R 988801706 0110 0.00 200,000.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22620 140734 04/11/2023 03/31/2023 405.00 R 001333051 0111 25,000.00 521,551.00 275.00 125.00 0.00 0.00 0.00 5.00 0.00 0.00 1.25$ 123.75$ 22621 140733 04/11/2023 04/06/2023 37.00 R 979503207 0601 2,000.00 1,200.00 22.00 10.00 0.00 0.00 0.00 5.00 0.00 0.00 0.10$ 9.90$ 22622 140732 04/13/2023 04/10/2023 2,389.00 R 721093029 0231 149,000.00 87,635.00 1,639.00 745.00 0.00 0.00 0.00 5.00 0.00 0.00 7.45$ 737.55$ 22623 140735 04/13/2023 03/31/2023 10.00 R 931900053 0231 0.00 599,567.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22624 140736 04/11/2023 04/05/2023 10.00 R 801044006 0211 0.00 154,316.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22625 140737 04/13/2023 04/11/2023 10.00 R 957901501 0110 0.00 966,023.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22626 140738 04/14/2023 03/24/2023 2,405.00 R 994200005 0211 150,000.00 30,000.00 1,650.00 750.00 0.00 0.00 0.00 5.00 0.00 0.00 7.50$ 742.50$ 22627 140739 04/14/2023 04/07/2023 7,605.00 R 933302503 0110 475,000.00 362,118.00 5,225.00 2,375.00 0.00 0.00 0.00 5.00 0.00 0.00 23.75$ 2,351.25$ 22628 140740 04/14/2023 04/05/2023 2,229.00 R 601112007 0323 139,000.00 76,800.00 1,529.00 695.00 0.00 0.00 0.00 5.00 0.00 0.00 6.95$ 688.05$ 22629 140742 04/14/2023 04/10/2023 11,253.00 R 821334004 0231 685,000.00 527,590.00 7,823.00 3,425.00 0.00 0.00 0.00 5.00 0.00 0.00 34.25$ 3,390.75$ 22630 140743 04/14/2023 04/06/2023 3,445.00 R *966900144 0440 215,000.00 312,416.00 2,365.00 1,075.00 0.00 0.00 0.00 5.00 0.00 0.00 10.75$ 1,064.25$ 22632 140744 04/12/2023 04/12/2023 10.00 MH 930806022 0211 0.00 13,218.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22633 140745 04/14/2023 04/12/2023 9,295.00 R 946800605 0110 575,000.00 563,270.00 6,415.00 2,875.00 0.00 0.00 0.00 5.00 0.00 0.00 28.75$ 2,846.25$ 22634 140746 04/17/2023 04/11/2023 10.00 R 938400527 0111 0.00 948,945.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22635 140747 04/17/2023 04/11/2023 10.00 R 938400527 0111 0.00 948,945.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22636 140748 04/17/2023 04/06/2023 1,653.00 R 948314803 0110 103,000.00 120,000.00 1,133.00 515.00 0.00 0.00 0.00 5.00 0.00 0.00 5.15$ 509.85$ 22637 140749 04/17/2023 04/06/2023 10,272.22 R 998500077 0231 629,900.00 561,870.00 7,117.72 3,149.50 0.00 0.00 0.00 5.00 0.00 0.00 31.50$ 3,118.01$ 22638 140750 04/17/2023 04/11/2023 12,499.00 R 964700072 0111 755,000.00 501,525.00 8,719.00 3,775.00 0.00 0.00 0.00 5.00 0.00 0.00 37.75$ 3,737.25$ 22639 140751 04/13/2023 11/22/2022 10.00 R 602341050 0440 0.00 219,144.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22640 140752 04/14/2023 04/07/2023 10.00 R *602344005 0440 0.00 127,235.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22641 140753 04/18/2023 04/12/2023 1,605.00 R *502311010 0441 100,000.00 57,132.00 1,100.00 500.00 0.00 0.00 0.00 5.00 0.00 0.00 5.00$ 495.00$ 22642 140754 04/18/2023 04/10/2023 11,431.00 R 965000129 0111 695,000.00 632,584.00 7,951.00 3,475.00 0.00 0.00 0.00 5.00 0.00 0.00 34.75$ 3,440.25$ 22643 140755 04/18/2023 04/10/2023 8,405.00 R 988300723 0110 525,000.00 106,800.00 5,775.00 2,625.00 0.00 0.00 0.00 5.00 0.00 0.00 26.25$ 2,598.75$ 22644 140756 04/18/2023 04/07/2023 2,085.00 R 601273020 0323 130,000.00 40,125.00 1,430.00 650.00 0.00 0.00 0.00 5.00 0.00 0.00 6.50$ 643.50$ 22645 140757 04/18/2023 04/12/2023 8,743.00 R 990603234 0231 544,000.00 80,000.00 6,018.20 2,720.00 0.00 0.00 0.00 5.00 0.00 -0.20 27.20$ 2,692.80$ 22647 140758 04/18/2023 04/13/2023 21,861.80 R 821355047 0231 1,281,000.00 1,069,861.00 15,451.80 6,405.00 0.00 0.00 0.00 5.00 0.00 0.00 64.05$ 6,340.95$ 22648 140759 04/18/2023 03/13/2023 3,845.00 R 901024088 0211 240,000.00 128,829.00 2,640.00 1,200.00 0.00 0.00 0.00 5.00 0.00 0.00 12.00$ 1,188.00$ 22649 140760 04/18/2023 03/28/2023 6,837.00 R 940500034 0111 427,000.00 286,694.00 4,697.00 2,135.00 0.00 0.00 0.00 5.00 0.00 0.00 21.35$ 2,113.65$ 22650 140761 04/18/2023 04/12/2023 1,045.00 R 966900105 0440 65,000.00 182,099.00 715.00 325.00 0.00 0.00 0.00 5.00 0.00 0.00 3.25$ 321.75$ 22651 140762 04/18/2023 04/07/2023 9,162.91 R 935400017 0231 567,579.00 393,148.00 6,320.01 2,837.90 0.00 0.00 0.00 5.00 0.00 0.00 28.38$ 2,809.52$ 22652 140763 04/27/2023 03/22/2023 10.00 R *996400707 0211 0.00 308,133.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22653 140764 04/18/2023 04/10/2023 2,181.00 R *971100326 0441 136,000.00 213,910.00 1,496.00 680.00 0.00 0.00 0.00 5.00 0.00 0.00 6.80$ 673.20$ 22655 140765 04/18/2023 04/04/2023 6,680.00 R 937200401 0320 375,000.00 304,768.00 4,800.00 1,875.00 0.00 0.00 0.00 5.00 0.00 0.00 18.75$ 1,856.25$ 22656 140766 04/19/2023 04/10/2023 2,885.00 R *412061010 0502 180,000.00 94,126.00 1,980.00 900.00 0.00 0.00 0.00 5.00 0.00 0.00 9.00$ 891.00$ 22657 140767 04/17/2023 03/29/2023 10.00 R 901172004 0151 0.00 719,943.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22658 140768 04/17/2023 07/01/2022 10.00 R 802363018 0324 0.00 68,100.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22659 140769 04/17/2023 06/24/2022 10.00 R 802363018 0324 0.00 68,100.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22660 140770 04/20/2023 04/07/2023 8,672.00 R 941400009 0111 540,000.00 374,910.00 5,967.00 2,700.00 0.00 0.00 0.00 5.00 0.00 0.00 27.00$ 2,673.00$ 22661 140771 04/20/2023 04/06/2023 10.00 R 941500035 0111 0.00 138,578.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22662 140772 04/18/2023 04/18/2023 2,005.00 R 961805509 0211 125,000.00 78,294.00 1,375.00 625.00 0.00 0.00 0.00 5.00 0.00 0.00 6.25$ 618.75$ 22663 140773 04/20/2023 04/18/2023 11,777.07 R 996300042 0110 714,442.00 90,000.00 8,199.86 3,572.21 0.00 0.00 0.00 5.00 0.00 0.00 35.72$ 3,536.49$ 22664 140774 04/18/2023 03/26/2020 130.16 R *602352001 0441 6,000.00 267,668.00 66.00 30.00 5.61 4.35 19.20 5.00 0.00 0.00 0.30$ 29.70$ 22665 140775 04/18/2023 04/17/2023 10.00 MH 992906016 0110 0.00 4,356.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22666 140776 04/18/2023 04/06/2023 10.00 R 001294019 0111 0.00 252,327.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22667 140777 04/19/2023 04/18/2023 10.00 R 951903815 0110 0.00 467,756.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22668 140797 04/25/2023 04/14/2023 10.00 R *001091002 0110 0.00 1,350,294.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22669 140778 04/21/2023 04/14/2023 1,525.00 R 712064033 0691 95,000.00 66,444.00 1,045.00 475.00 0.00 0.00 0.00 5.00 0.00 0.00 4.75$ 470.25$ 22670 140779 04/21/2023 04/10/2023 6,765.00 R 002284016 0781 422,500.00 235,718.00 4,647.50 2,112.50 0.00 0.00 0.00 5.00 0.00 0.00 21.13$ 2,091.38$ 22671 140780 04/19/2023 04/19/2023 85.00 R 821081027 0231 5,000.00 5,000.00 55.00 25.00 0.00 0.00 0.00 5.00 0.00 0.00 0.25$ 24.75$ 22672 140781 04/19/2023 05/22/2020 10.00 R 932200731 0111 0.00 270,146.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22673 140782 04/24/2023 04/12/2023 10,541.00 R 985800201 0110 645,000.00 423,536.00 7,311.00 3,225.00 0.00 0.00 0.00 5.00 0.00 0.00 32.25$ 3,192.75$ 22674 140783 04/24/2023 04/12/2023 7,045.00 R 990300109 0231 440,000.00 353,800.00 4,840.00 2,200.00 0.00 0.00 0.00 5.00 0.00 0.00 22.00$ 2,178.00$ 22675 140784 04/24/2023 03/27/2023 101.00 R 981901620 0441 6,000.00 14,000.00 66.00 30.00 0.00 0.00 0.00 5.00 0.00 0.00 0.30$ 29.70$ 22676 140785 04/21/2023 04/20/2023 10.00 R *974100104 0110 0.00 1,811,633.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22677 140786 04/21/2023 04/19/2022 10.00 R *901021013 0211 0.00 65,000.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22678 140787 04/25/2023 04/13/2023 3,429.00 R 972903302 0110 214,000.00 120,750.00 2,354.00 1,070.00 0.00 0.00 0.00 5.00 0.00 0.00 10.70$ 1,059.30$ 22679 140791 04/21/2023 04/13/2023 10.00 R 412192011 0571 0.00 9,000.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22680 140788 04/25/2023 04/13/2023 13,567.00 R 989711202 0110 815,000.00 641,490.00 9,487.00 4,075.00 0.00 0.00 0.00 5.00 0.00 0.00 40.75$ 4,034.25$ 22681 140789 04/21/2023 04/05/2023 10.00 R 412192006 0571 0.00 75,259.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22682 140790 04/21/2023 04/08/2023 277.00 R *981901419 0441 17,000.00 46,000.00 187.00 85.00 0.00 0.00 0.00 5.00 0.00 0.00 0.85$ 84.15$ 22683 140792 04/24/2023 03/30/2023 10.00 R 021282010 0211 0.00 1,199,910.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22684 140793 04/24/2023 04/24/2023 10.00 R 801213004 0221 0.00 139,142.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22685 140794 04/26/2023 03/30/2023 10.00 R *938100320 0111 0.00 1,151,731.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22686 140795 04/25/2023 04/02/2023 10.00 R 938100318 0111 0.00 1,076,489.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22687 140796 04/25/2023 04/20/2023 10.00 R 502304012 0441 0.00 97,932.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22688 140798 04/25/2023 04/20/2023 10.00 R 984601001 0110 0.00 1,732,167.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22689 140799 04/27/2023 04/18/2023 4,885.00 R 999100063 0110 305,000.00 223,866.00 3,355.00 1,525.00 0.00 0.00 0.00 5.00 0.00 0.00 15.25$ 1,509.75$ 22690 140800 04/27/2023 04/17/2023 10,538.77 R 990400159 0231 644,875.00 42,000.00 7,309.40 3,224.38 0.00 0.00 0.00 5.00 0.00 -0.01 32.24$ 3,192.14$ 22691 140801 04/27/2023 03/31/2023 10.00 R 969000002 0231 0.00 527,425.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22692 140802 04/26/2023 02/23/2023 10.00 R 989100030 0211 0.00 176,396.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22693 140803 04/28/2023 04/19/2023 16,788.80 R 978802028 0231 996,000.00 904,678.00 11,803.80 4,980.00 0.00 0.00 0.00 5.00 0.00 0.00 49.80$ 4,930.20$ 22694 140804 04/28/2023 04/20/2023 10.00 R 951400008 0231 0.00 520,758.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22695 140805 04/28/2023 04/21/2023 7,125.00 R 990400338 0231 445,000.00 318,975.00 4,895.00 2,225.00 0.00 0.00 0.00 5.00 0.00 0.00 22.25$ 2,202.75$ 22696 140806 04/27/2023 04/27/2023 85.00 MH 992906016 0110 5,000.00 4,356.00 55.00 25.00 0.00 0.00 0.00 5.00 0.00 0.00 0.25$ 24.75$ 22698 140808 04/28/2023 04/06/2023 6,405.00 R 921073011 0211 400,000.00 470,254.00 4,400.00 2,000.00 0.00 0.00 0.00 5.00 0.00 0.00 20.00$ 1,980.00$ 22699 140809 04/28/2023 04/23/2023 10.00 R 964601601 0441 0.00 337,377.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22706 140816 04/28/2023 04/27/2023 10.00 R *957306503 0110 0.00 840,853.00 0.00 0.00 0.00 0.00 0.00 5.00 5.00 0.00 -$ -$ 22707 140817 04/28/2023 04/26/2023 1,997.00 MH 978706002 0111 124,500.00 72,225.00 1,369.50 622.50 0.00 0.00 0.00 5.00 0.00 0.00 6.23$ 616.28$ 4 April 2023 5/19/2023 4 yr avg *2023 2023 % Budget % Diff Projection 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2018-21 Budget Actual Difference Prior Year Projection +/- EOY Bdgt 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 39,532 41,422 27,620 34,845 41,422 18.9%6.4%$778,614 123,614$ 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,552 55,082 30,735 38,775 55,082 42.1%21.6%$858,594 203,594$ 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 40,951 73,832 29,259 36,913 73,832 100.0%58.9%$1,009,376 354,376$ 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 55,711 145,748 32,079 40,471 145,748 260.1%235.3%$1,371,055 716,055$ 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 61,311 34,712 43,793 716,055$ June 19,205 17,302 17,916 16,477 18,786 25,070 29,476 31,485 36,556 43,299 742 69,468 64,789 33,750 42,579 716,055$ 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 83,704 44,636 56,313 716,055$ 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 100,707 56,851 71,722 716,055$ September 41,757 42,500 40,882 39,890 42,349 44,713 53,487 56,561 68,870 88,306 79,681 90,656 114,776 71,278 89,924 716,055$ October 43,012 43,861 41,015 41,741 43,659 49,182 59,970 58,458 65,200 60,682 78,504 67,952 48,371 48,707 61,448 716,055$ November 44,351 38,547 36,906 39,146 46,879 58,967 57,999 69,054 63,101 65,013 75,302 102,485 89,963 66,937 84,448 716,055$ December 19,873 21,703 11,109 15,514 33,858 25,213 26,084 32,870 46,067 42,545 54,544 53,129 62,804 42,619 53,768 716,055$ Full Year 321,231 293,344 273,796 295,200 335,825 386,107 449,148 507,868 542,805 579,805 490,842 779,723 806,169 316,084 519,183 655,000 316,084 YTD 78,054 60,236 57,454 69,770 69,073 82,520 102,634 110,276 112,570 119,150 124,876 174,150 179,746 316,084 119,693 151,004 316,084 109.3%75.9% Full Year Actual/20 321,231 293,344 273,796 295,200 335,825 386,107 449,148 507,868 542,805 579,805 490,842 779,723 806,169 650,000 YTD Change 1.08%-4.62%21.44%-1.00%19.47%24.37%7.45%2.08%5.84%4.81%39.46%3.21%75.85% Annual % Change 0.24%-6.66%7.82%13.76%14.97%16.33%13.07%6.88%6.82%-15.34%58.85%3.39%$655,000 2023 Budget 2% Basic RCW 67.28.1RCW 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 800,000 900,000 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 December November October September August July June May April March February January 2023 SPECIAL HOTEL/MOTEL & TRANSIENT RENTAL SALES TAX -Fund 125 Includes Investment Interest 0 100,000 200,000 300,000 400,000 500,000 600,000 700,000 800,000 2023 YTD Actual and Budget YTD Actual YTD Budget Projected Over/Under Budget 0 20,000 40,000 60,000 80,000 100,000 120,000 140,000 160,000 2023 Monthly Actual and Budget 2022 Actual Budget April