Loading...
HomeMy WebLinkAbout2020-07_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 Revenue Report July 2020 Revenue  General Fund at $13,169,679 – 59.8% of the 2020 budget year to date which is 2.5% less than last year. Property tax collections are on track. The second sheet shows general fund revenue charts showing 2015-2020 year to date detail and percentage of full year collections. 2020 is shown as a percentage of our adopted budget.  Other Funds at $19,407,351– 52.8% of 2020 budget year to date.  General Fund Cash Balance - $7,785,971 at the end of July which includes the $3.526 million budgeted reserve. This is slightly less than the amount for this time last year. This reserve amount increased $134,575 to address second quarter expenditure appropriations.  General Sales Tax Receipts - $409,818 which includes $86,275 for Special Purpose in July 2020. General & Optional Sales tax is up from last year and 8% over budget for the month. It’s holding at 12.75% over budget for 2020 YTD. Special Purpose was less than last year but at budget. Cumulatively they’re $11,000 over this month last year, 12% over budget for the month and 9.68% over for YTD. The charts show the revenue per month back to 2005.  REET Receipts - Fund 302 - $160,738 in July, which is 51% over budget and 17.6% over this month last year. Year to Date, REET Collections are 22.8% over budget and 20% over 2019 YTD. Two sales were over $1 million, one in Chimacum and another in Port Ludlow. There were 16 sales in unincorporated Jefferson County in July with selling prices between $500,000 and $1 million.  Hotel/Motel Lodging Tax – Fund 125 - $24,074 in July. This puts it 42% under budget for the month and half what was collected this month last year. Year to date is 29.2% under budget and 36.2% less than YTD in 2019. 2020 7 July Jefferson County Treasurer 4-Aug-2020 General Fund REVENUE NAME BARS BUDGET QTRLY AMENDED JUL Y-T-D Y-T-D BUDGET Quarterly AMENDED ACTUAL JUL Y-T-D Y-T-D BUDGET ACTUAL JUL Y-T-D Y-T-D *2020 Approp Budget 2020 2020 2020 %2019 Approp Budget 2019 2019 2019 2019 %2018 2018 2018 2018 % of Actual Property Tax 1 311.10 8,290,037 8,290,037 77,380 4,741,584 57.2%8,021,323 8,021,323 7,992,860 30,911 4,605,400 57.4%7,850,027 7,805,908 36,075 4,459,181 57.1% Diverted Road Prop Tax 1 311.20 720,000 720,000 8,072 421,367 58.5%720,000 720,000 720,000 2,701 416,773 57.9%720,000 720,000 3,466 412,719 57.3% Sales Tax 1 313.11 3,326,609 3,326,609 323,542 1,994,654 60.0%3,204,826 192,869 3,397,695 3,601,761 308,592 1,891,067 55.7%3,040,000 3,195,259 262,489 1,679,158 52.6% special purpose 313.15 1,045,244 1,045,244 86,275 558,813 53.5%1,006,979 55,384 1,062,363 1,064,119 89,815 565,828 53.3%955,428 999,945 81,117 528,724 52.9% Local Criminal Justice 1 313.71 422,650 422,650 35,734 232,638 55.0%407,177 22,395 429,572 442,239 37,388 235,113 54.7%380,070 417,655 33,908 220,996 52.9% Leasehold Excise Tax 3 317.20 66,801 66,801 0 38,725 58.0%66,801 66,801 75,500 - 37,130 55.6%62,000 65,642 - 31,549 48.1% Private Harvest Tax - TAV 2 317.40.10/.20 339,599 339,599 0 137,325 40.4%339,599 339,599 363,246 - 259,278 76.3%335,000 537,635 - 309,599 57.6% P.I.L.T. (incl DNR)4332.15.23/336.02.31 1,015,150 1,015,150 0 1,572,825 154.9%1,015,136 537,328 1,552,464 1,553,455 - 1,537,328 99.0%1,867,988 1,850,941 - 1,833,818 99.1% P.U.D. Privilege Tax 4 335.00.91 386,555 386,555 398,063 398,063 103.0%375,296 375,296 385,397 385,397 385,397 102.7%323,420 393,491 393,491 393,491 100.0% Crim Just Hi Crime/DUI/Asst 5 336.06.10/51 451,770 451,770 136,952 385,846 85.4%438,612 438,612 336,086 124,450 333,709 76.1%463,500 425,438 104,569 320,837 75.4% Marijuana Enforcement/Excise 6 336.06.41/42 52,548 52,548 0 24,461 46.5%51,017 51,017 170,903 - 24,224 47.5%24,720 63,962 - 39,588 61.9% Liquor Excise Tax 8 336.06.94 48,267 48,267 16,676 43,836 90.8%47,321 47,321 51,439 11,553 37,729 79.7%41,536 47,254 10,673 34,380 72.8% Liquor Profit 6 336.06.95 90,650 90,650 0 41,687 46.0%88,873 88,873 83,623 - 41,936 47.2%90,203 84,066 - 42,130 50.1% Treasurer Invest & Other Fees 1 341.42.15-20/50 35,830 35,830 1,249 18,666 52.1%35,000 35,000 43,596 2,499 23,191 66.3%16,290 42,753 2,193 29,397 68.8% Treas. Collection Fees (REET)3 341.42.31/32/33 87,175 87,175 8,179 39,982 45.9%87,175 87,175 85,234 9,191 45,734 52.5%80,000 83,290 7,350 46,978 56.4% Penalties on delinquent taxes 1 359.40.10/.20 119,757 119,757 15,983 85,041 71.0%117,409 117,409 113,976 5,351 75,048 63.9%133,332 98,079 9,937 68,363 69.7% Investment Income 1 361.11 713,000 713,000 12,054 239,945 33.7%349,847 600,000 949,847 1,028,831 81,477 758,898 79.9%230,000 534,468 72,344 293,098 54.8% Interest on delinquent taxes 1 361.40.10 192,316 192,316 19,674 163,771 85.2%188,545 188,545 224,004 6,893 135,254 71.7%210,000 197,154 17,363 130,250 66.1% Interfund Chg Svc-Cost Alloc 3 362.50.00.180/0671 339,521 339,521 9,736 29,207 8.6%329,632 329,632 232,066 9,575 28,985 8.8%328,526 409,407 11,104 206,731 50.5% DNR Timber & DNRTimbTrust 2 1 395.1.1/335.02.33 250,000 250,000 1,743 202,705 81.1%250,000 250,000 500,000 352,075 14,202 328,974 65.8%250,000 330,761 2,277 8,200 2.5% Transfer in 1 397.00 3,000 24,074 27,074 0 25,572 94.5%8,000 8,000 21,798 - 20,298 253.7%3,000 42,992 - 19,194 44.6% Miscellaneous 1341.43/341.81/361.40.00/361.40.30/362.50.1/369.81/369.9 27,784 27,784 816 7,849 28.3%13,631 13,631 111,997 1,396 9,639 70.7%11,900 43,811 863 5,440 12.4% Assessor 1 001-010-000 8,300 8,300 17 3,845 46.3%8,300 8,300 9,642 60 3,904 47.0%8,700 8,542 46 4,031 47.2% Auditor-Recording Fees 1 341.21.10 69,495 69,495 9,910 50,136 72.1%70,510 70,510 69,039 6,165 35,860 50.9%72,063 70,227 6,169 41,423 59.0% Auditor-M.V. License Fees 1341.48+/336.00.93 246,440 16,370 262,810 13,756 165,948 63.1%229,257 229,257 302,603 17,178 147,136 64.2%232,703 234,383 18,069 136,476 58.2% Auditor-Other Revenue 1 35,330 35,330 1,749 13,784 39.0%42,450 42,450 35,127 2,580 20,529 48.4%26,605 34,184 3,726 20,326 59.5% Elections 1 001-021-000 116,110 116,110 6,521 309,648 266.7%130,160 130,160 161,606 5,258 103,962 79.9%159,722 101,546 3,598 93,388 92.0% Clerk 1 001-020-000 149,591 149,591 12,223 77,970 52.1%152,506 152,506 149,436 10,040 84,916 55.7%170,768 181,580 16,550 103,992 57.3% County Administrator 1 001-059-000 438,600 438,600 0 4,000 0.9%4,260 (560) 3,700 4,260 - 4,260 115.1%4,260 4,260 - 4,260 100.0% Commissioners 1 001-060-000 8,000 8,000 1,017 5,298 66.2%8,000 8,000 7,843 726 4,189 52.4%8,000 8,522 776 5,097 59.8% Safety & Security 1 001-067-000 75,538 75,538 0 67,399 89.2%70,604 70,604 36,232 - 28,578 40.5%64,959 44,082 - 30,414 69.0% Community Services 1 001-068-000 4,155 4,155 932 2,911 70.1%4,005 4,005 3,987 16,968 18,990 474.2%6,900 4,180 40 1,407 33.7% District Court 1 001-080-000 644,505 644,505 103,566 285,511 44.3%636,823 (612) 636,211 682,644 35,880 360,947 56.7%603,032 674,579 43,337 397,137 58.9% Juvenile Service 1 001-110-000 279,284 279,284 22,329 151,063 54.1%298,727 (13,500) 285,227 243,744 24,116 134,260 47.1%259,676 288,710 7,716 155,969 54.0% Prosecuting Attorney 1 001-150-000 320,633 320,633 15,540 88,513 27.6%148,916 16,789 165,705 257,902 43,651 139,783 84.4%178,690 110,543 26,439 77,288 69.9% Coroner 1 001-151-000 25,348 25,348 0 7,958 31.4%25,348 25,348 18,324 - 11,924 47.0%25,348 32,723 - 18,140 55.4% Sheriff 1 001-180-000 794,303 154,500 948,803 59,236 484,662 51.1%561,174 483,436 1,044,610 1,141,545 146,425 646,338 61.9%625,969 618,527 13,823 303,112 49.0% Superior Court 1 001-240-000 59,421 59,421 440 7,500 12.6%60,912 109 61,021 50,414 1,020 7,720 12.7%60,822 51,520 - 26,043 50.5% Non Departmental 1 001-270-000 35,568 481,500 517,068 60 38,973 7.5%50,437 25,000 75,437 39,722 420 34,572 45.8%50,447 32,802 - 32,802 100.0% TOTAL CURRENT EXPENSE REVENUE 21,334,884 676,444 22,011,328 1,399,423 13,169,679 59.8%19,664,588 2,168,638 21,833,226 22,268,272 1,431,876 13,584,799 62.2%19,975,604 20,890,820 1,189,506 12,565,125 60.1% * Revenue Schedule 1 monthly, 2 Feb/May/Aug/Nov, 3 Feb/Apr/Jun/Aug/Oct/Dec, 4 Jun 5 Jan/Apr/Jul/Oct 6 Mar/Jun/Sep/Dec 7 Nov 8 Var REFUND EXPEND CY/PRIOR excluded 388/89 0 212.12 27,115 0 6865.4 14,301 0 367.24 15,374 July 2020 GENERAL FUND REVENUE 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Property Tax 3,929,615 4,033,323 3,963,540 4,047,965 4,137,371 4,228,173 4,301,556 4,373,103 4,459,181 4,605,400 4,741,584 Diverted Road Prop Tax 405,542 408,627 409,576 411,326 413,207 424,673 415,508 415,545 412,719 416,773 421,367 Sales Tax 1,047,802 1,102,464 1,025,213 1,325,627 1,214,695 1,325,608 1,451,643 1,574,065 1,679,158 1,891,067 1,994,654 special purpose 0 101,418 338,964 392,913 373,974 406,170 473,285 492,577 528,724 565,828 558,813 Local Criminal Justice 141,533 149,396 142,505 163,965 155,857 168,253 196,702 203,944 220,996 235,113 232,638 Leasehold Excise Tax 26,698 29,779 28,565 28,739 35,978 31,722 29,729 34,549 31,549 37,130 38,725 Private Harvest Tax 64,114 124,315 203,716 272,552 325,648 366,366 183,394 171,790 309,599 259,278 137,325 P.I.L.T. (incl DNR)397,957 486,246 641,300 1,283,164 1,330,422 1,253,823 1,422,312 1,390,772 1,833,818 1,537,328 1,572,825 P.U.D. Privilege Tax 50,666 16,788 31,380 32,775 225,457 370,446 318,107 314,148 393,491 385,397 398,063 Crim Just Hi Crime/DUI/Asst 250,761 241,639 248,813 278,952 347,828 359,931 367,324 327,664 320,837 333,709 385,846 Marijuana Enforcement/Excise 0 0 0 0 0 - 25,568 11,354 39,588 24,224 24,461 Liquor Excise Tax 27,662 28,998 31,873 0 9,683 11,894 30,739 32,161 34,380 37,729 43,836 Liquor Profit 36,094 35,925 53,297 42,426 42,354 42,582 42,439 42,310 42,130 41,936 41,687 Treasurer Invest & Other Fees 3,156 2,802 1,992 2,081 1,467 2,263 5,544 22,573 29,397 23,191 18,666 Treas. Collection Fees (REET)15,669 17,023 17,710 20,891 24,471 40,475 49,611 50,530 46,978 45,734 39,982 Penalties on delinquent taxes 49,251 80,864 65,059 71,373 84,115 71,913 72,121 62,008 68,363 75,048 85,041 Investment Income 39,963 26,578 21,434 -4,318 -400 15,184 66,394 249,994 293,098 758,898 239,945 Interest on delinquent taxes 84,088 129,357 118,078 125,765 135,059 139,526 140,839 126,259 130,250 135,254 163,771 Interfund Chg Svc-Cost Alloc 0 0 0 39,051 0 26,255 26,537 30,577 206,731 28,985 29,207 DNR Timber 37,173 403,304 212,836 65,299 204,722 356,803 224,129 4,884 8,200 328,974 202,705 Transfer in 0 0 0 0 0 5,000 21,687 19,546 19,194 20,298 25,572 Miscellaneous 227,634 148,185 20,896 35,451 24,684 22,496 15,701 4,000 5,440 9,639 7,849 Assessor 992 781 793 153,893 10,495 504 4,345 6,288 4,031 3,904 3,845 Auditor-Recording Fees 36,473 36,827 40,311 46,431 32,499 41,774 41,593 42,760 41,423 35,860 50,136 Auditor-M.V. License Fees 95,375 93,067 92,871 99,551 99,506 98,039 133,358 141,636 136,476 147,136 165,948 Auditor-Other Revenue 20,203 18,374 17,383 21,875 20,728 42,126 17,997 17,690 20,326 20,529 13,784 Elections 99,023 59,231 54,954 31,757 72,842 55,146 151,935 55,987 93,388 103,962 309,648 Clerk 118,391 112,281 116,248 121,067 123,442 121,812 111,616 98,059 103,992 84,916 77,970 County Administrator 0 0 0 0 0 - - - 4,260 4,260 4,000 Commissioners 5,781 4,226 9,189 5,835 4,311 5,016 4,841 5,086 5,097 4,189 5,298 Safety & Security 54,795 28,415 32,088 38,633 28,735 15,003 27,802 39,790 30,414 28,578 67,399 Community Services 0 4,428 839 4,215 3,124 3,241 2,822 2,077 1,407 18,990 2,911 District Court 303,132 350,554 361,508 364,001 360,816 376,797 363,352 349,401 397,137 360,947 285,511 Juvenile Service 166,083 165,242 114,904 195,235 168,424 147,521 150,644 162,184 155,969 134,260 151,063 Prosecuting Attorney 176,195 183,462 120,745 81,283 90,852 152,122 82,347 100,249 77,288 139,783 88,513 Coroner 2,320 7,480 3,480 6,380 3,480 3,480 8,340 24,610 18,140 11,924 7,958 Sheriff 582,678 540,125 396,159 405,436 265,132 351,887 343,782 351,348 303,112 646,338 484,662 Superior Court 16,976 4,840 3,000 4,844 3,000 4,500 15,321 46,660 26,043 7,720 7,500 Non Departmental 0 0 0 0 0 - 10 10 32,802 34,572 38,973 TOTAL CURRENT EXPENSE 8,513,795 9,176,364 8,941,219 10,216,433 10,373,977 11,088,523 11,340,973 11,398,187 12,565,125 13,584,799 13,169,679 TOTAL CURRENT EXPENSE ACTUAL/2020 BUDGET 15198876 16349133 15531592 16964139 17374434.53 18,950,211 19,247,467 19,181,590 20,890,820 19,975,604 22,011,328 YTD % of Full Year Actual/2020 Budget 56.0%56.1%57.6%60.2%59.7%58.5%58.9%59.4%60.1%68.0%59.8% 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 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 56.0%56.1%57.6%60.2%59.7%58.5%58.9%59.4%60.1% 68.0% 59.8% 0.0% 20.0% 40.0% 60.0% 80.0% 100.0% 120.0% 0 5,000,000 10,000,000 15,000,000 20,000,000 25,000,000 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 GENERAL FUND YTD AND FULL YEAR ACTUAL/2020 BUDGET TOTAL CURRENT EXPENSE TOTAL CURRENT EXPENSE ACTUAL/2020 BUDGET YTD % of Full Year Actual/2020 Budget OTHER FUNDS REVENUE REPORT 2020 3 year view July 7 8/6/2020 FUND Fund #Orig Budget Budget Amended BDGT Jul YTD YTD Orig Budget Budget Amended BDGT Jul YTD YTD ACTUAL Jul YTD YTD 2020 Amendment 2020 2020 2020 %2019 Amendment 2019 2019 2019 %2019 2018 2018 % SPECIAL REVENUE Elections CARES Act 103 - 153,422 153,422 29 165,338 n/a HAVA 3 Grant 104 - 123,419 123,419 123,419 123,419 n/a Auditor's O & M 105 77,900 77,900 55,363 70,324 90.3%80,480 80,480 47,120 59,529 74.0%76,912 51,260 64,578 84.0% Court Facilitator 106 4,500 4,500 220 1,540 34.2%4,100 4,100 480 2,940 71.7%4,820 400 2,940 61.0% Boating Safety 107 50,000 50,000 - 30,384 60.8%48,500 1,638 50,138 18,053 50,138 100.0%47,887 - 30,607 63.9% WSU Cooperative 108 532,762 (69,310) 463,452 24,996 237,989 51.4%416,215 52,707 468,922 1,834 175,058 37.3%556,121 31,101 333,049 59.9% Noxious Weed 109 217,717 (23,700) 194,017 1,575 108,072 55.7%141,217 119,599 260,816 893 104,720 40.2% 4-H After School 113 Moved to Fund 108 - 47,600 47,600 16,468 61,200 128.6%37,750 5,500 37,750 100.0% JeffComCap 119 119 206,640 206,640 17,220 120,540 58.3%204,000 204,000 17,000 119,000 58.3%264,695 22,058 154,406 58.3% Crime Victim's Svc 120 81,543 81,543 31,891 83,557 102.5%140,813 140,813 35,120 90,405 64.2%113,502 5,764 59,256 52.2% Grant Mgmt 123 150,000 132,517 282,517 13,452 64,749 22.9%150,000 150,000 - 48,346 32.2%101,793 - 67,983 66.8% Hotel-Motel 125 521,444 521,444 24,074 161,219 30.9%500,500 500,500 48,748 252,743 50.5%542,805 44,445 234,632 43.2% Jeff Co Public Health 127 4,994,011 4,994,011 327,592 3,079,070 61.7%4,422,082 229,547 4,651,629 382,564 2,850,079 61.3%4,606,955 692,218 2,804,185 60.9% Water Quality 128 1,307,279 1,307,279 64,219 677,986 51.9%1,163,949 1,163,949 13,847 571,341 49.1%969,155 27,709 592,879 61.2% Water Quality Land Acq 129 115,000 115,000 - - 0.0%234,448 40,552 275,000 - - 0.0%132,825 - 0.0% Mental Health 130 50,289 50,289 457 29,367 58.4%47,637 47,637 253 29,847 62.7%50,132 220 27,545 54.9% Chem Dep Mnt Hlth tx 131 553,433 553,433 48,893 319,042 57.6%527,003 527,003 56,776 328,354 62.3%573,509 46,515 303,731 53.0% Drug Fund 135 13,850 13,850 336 5,032 36.3%12,249 12,249 473 4,513 36.8%14,395 809 7,990 55.5% Law Library 140 16,081 16,081 817 9,236 57.4%10,927 10,927 882 5,260 48.1%9,915 825 5,795 58.4% Trial Court Imprvmnt 141 23,000 23,000 - 14,168 61.6%23,000 23,000 5,703 17,103 74.4%23,201 5,798 17,403 75.0% Community Develpmnt 143 1,657,637 76,000 1,733,637 95,007 883,277 50.9%1,731,920 80,930 1,812,850 91,017 873,669 48.2%1,476,187 123,603 775,079 52.5% Federal Forest Title III 147 21,000 21,000 392 18,223 - - 230 20,420 20,164 18,796 19,368 96.1% Jeff Co Affrdbl Hsg 148 45,131 103,780 148,911 12,121 52,092 35.0%48,000 48,000 4,656 26,998 56.2%310,493 31,594 159,879 51.5% Homeless Housing Fund 149 272,874 19,234 292,108 38,317 199,169 68.2%315,000 272,282 587,282 27,998 163,083 27.8% Treasurer's O & M 150 54,650 54,650 1,141 14,223 26.0%47,624 47,624 1,493 15,320 32.2%46,224 8,586 22,374 48.4% REET technology 151 13,816 13,816 1,391 7,740 56.0%15,690 15,690 1,468 8,376 53.4%16,175 1,519 9,364 57.9% Veteran's Relief 155 65,510 65,510 744 48,424 73.9%64,975 25,015 89,990 426 48,717 54.1%105,484 343 45,366 43.0% Park & Rec 174 684,549 (9,023) 675,526 2,290 287,720 42.6%669,649 669,649 7,275 325,715 48.6%674,760 10,129 324,466 48.1% County Park Imprvmnt 175 171,625 31,360 202,985 18,809 56,292 27.7%184,125 (24,000) 160,125 15,596 134,479 84.0%155,581 14,213 112,352 72.2% Post Harvest Timber Mgmt Rsv178 - - 27 86 50 50 18 128 255.1% County Roads 180 8,801,630 409,379 9,211,009 222,574 4,619,417 50.2%8,938,628 (6,707) 8,931,921 417,521 5,064,574 56.7%8,929,361 329,608 4,561,154 51.1% Facilities Mgmt *507 eff 7/1/2020183 1,169,335 1,169,335 98,776 719,636 61.5%1,065,393 1,065,393 80,444 643,044 60.4%1,121,480 89,578 662,279 59.1% County Fair 199 280,000 515 280,515 41,272 142,906 50.9%252,937 31,840 127,659 50.5% Total Special Revenue 21,873,206 670,237 22,543,443 1,102,693 11,918,574 52.9%21,535,774 792,078 22,327,852 1,335,626 12,238,006 54.8%21,235,218 1,562,591 11,564,068 57.8% OTHER FUNDS REVENUE REPORT 2019 3 year view FUND Orig Budget Amended BDGT Jul YTD YTD Orig Budget Amended BDGT Jul YTD YTD YTD Jul YTD YTD 2020 2020 2020 2020 %2019 2019 2019 2019 %2018 2018 2,018 % CAPITAL IMPROVEMENT Const/Renovation 301 363,826 363,826 1,894 50,625 13.9%518,500 518,500 1,862 225,568 43.5%110,679 - 16,117 1.6% Capital Improvement 302 1,156,313 1,000,000 2,156,313 160,738 1,768,836 82.0%1,072,125 1,072,125 136,683 640,824 59.8%1,264,506 108,763 677,397 63.1% Public Infrastructure 306 565,000 565,000 44,652 294,458 52.1%510,100 510,100 48,476 306,187 60.0%536,758 43,755 284,102 62.9% Conservation Futures 308 271,860 271,860 4,651 161,259 59.3%258,841 258,841 2,734 166,321 64.3%284,064 2,225 151,705 63.4% Total CAP IMP 2,356,999 1,000,000 3,356,999 211,934 2,275,179 67.8%2,359,566 - 2,359,566 189,755 1,338,901 56.7%2,196,007 154,744 1,129,320 40.9% ENTERPRISE Solid Waste 401 3,718,073 3,718,073 356,283 2,204,799 59.3%3,336,196 300,117 3,636,313 337,112 2,194,497 60.3%3,680,126 460,917 2,018,664 60.1% Solid Waste Post Clos 402 - - 11 238 - - 101 696 979 89 517 344.5% Solid Waste Eqpt Res 403 15,000 15,000 224 4,718 31.5%8,000 8,000 1,801 12,377 154.7%15,780 1,401 8,086 202.1% Yard Waste Educ Fnd 404 7,000 7,000 10 31 0.4%6,800 6,800 19 131 1.9%5,765 11 57 1.0% Tri Area Sewer 405 982,500 23,087 1,005,587 1,987 155,094 15.4%234,500 69,132 303,632 1,337 45,082 14.8%42,268 1,096 6,956 2.7% Total ENTERPRISE 4,722,573 23,087 4,745,660 358,515 2,364,881 49.8%3,585,496 369,249 3,954,745 340,369 2,252,783 57.0%3,744,918 463,513 2,034,280 56.1% INTERNAL SERVICE Equipment Rental 501 2,617,745 18,883 2,636,628 192,183 1,216,854 46.2%2,421,684 717,803 3,139,487 206,135 1,293,912 41.2%2,950,721 227,661 1,145,721 46.7% Risk Management 502 150,000 150,000 529 529 0.4%215,000 215,000 - 0 0.0%27,431 - - 0.0% Benefit Reserve 505 275,000 275,000 21,918 229,627 83.5%208,000 208,000 22,566 173,877 83.6%239,489 20,575 161,145 77.5% Information Services 506 1,968,639 1,076,937 3,045,576 371,278 1,401,707 46.0%1,901,855 295,210 2,197,065 100,863 1,023,270 46.6%2,004,180 407,267 1,402,575 64.3% Facilities Mgmt eff 7/1/2020 507 - - - 1,065,393 1,065,393 80,444 643,044 60.4%1,121,480 89,578 662,279 59.1% Total INT SERV 5,011,384 1,095,820 6,107,204 585,908 2,848,717 46.6%4,746,539 1,013,013 5,759,552 329,564 2,491,058 43.3%5,221,821 655,503 2,709,442 53.6% Total 33,964,162 2,789,144 36,753,306 2,259,051 19,407,351 52.8%32,227,375 2,174,340 34,401,715 2,195,314 18,320,747 53.3%32,397,965 2,836,351 17,437,110 55.4% GENERAL FUND CASH BALANCE REPORT 8/6/2020 END OF MONTH CASH BALANCES 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 January 2,548,924$ 3,317,483$ 2,556,108$ 3,030,949$ 2,798,256$ 4,109,412$ 4,360,809$ 4,416,485$ 5,320,169$ 6,803,191$ February 1,882,264$ 3,023,683$ 1,802,345$ 2,041,248$ 2,202,079$ 3,278,685$ 3,622,756$ 3,681,133$ 4,464,746$ 6,243,097$ March 1,934,629$ 2,347,678$ 1,654,411$ 2,108,155$ 2,384,301$ 3,289,638$ 3,759,875$ 3,580,887$ 4,861,100$ 6,359,340$ April 3,819,239$ 4,144,298$ 3,732,606$ 4,429,017$ 4,572,778$ 5,181,554$ 5,391,984$ 5,572,170$ 7,300,275$ 8,452,851$ May 3,850,878$ 4,045,216$ 3,747,009$ 4,421,127$ 4,622,123$ 5,174,859$ 5,455,638$ 5,330,488$ 7,124,392$ 7,105,615$ June 4,081,060$ 3,980,389$ 4,663,469$ 4,818,824$ 5,866,387$ 6,413,636$ 6,593,259$ 6,795,577$ 8,169,229$ 8,074,825$ July 3,732,809$ 3,396,868$ 3,873,932$ 3,736,091$ 5,087,286$ 5,610,102$ 5,806,710$ 6,177,104$ 8,112,936$ 7,785,971$ August 2,974,460$ 2,394,180$ 3,010,467$ 2,898,623$ 4,203,581$ 5,416,407$ 5,111,812$ 5,237,488$ 6,926,951$ September 2,312,554$ 1,734,730$ 2,217,696$ 2,118,250$ 3,742,452$ 4,710,400$ 4,724,294$ 4,511,047$ 5,850,565$ October 4,339,258$ 4,098,330$ 4,148,666$ 4,133,005$ 5,804,449$ 6,326,563$ 6,245,727$ 6,682,718$ 8,291,898$ November 4,236,934$ 3,781,830$ 3,878,581$ 3,795,871$ 5,043,942$ 5,519,658$ 6,098,807$ 6,804,203$ 7,781,753$ December 3,862,223$ 3,346,366$ 3,605,804$ 3,694,709$ 4,808,162$ 5,384,768$ 5,201,817$ 6,038,266$ 7,658,281$ REQUIRED RESERVE ** (includes 10% of total expenditures and revenue stabilization reserve) 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Budg Total Reserve $ 1,666,150 $ 1,708,161 $ 1,786,000 $ 2,121,257 $ 2,140,726 $ 2,308,223 $ 2,589,184 $ 2,703,102 $ 3,281,222 $ 3,526,713 15% GF Budgeted Expenditures * $ 1,566,150 $ 1,608,161 $ 1,646,000 $ 1,681,257 $ 1,700,726 $ 1,806,223 $ 1,863,184 $ 1,977,102 $ 3,281,222 $ 3,526,713 Revenue Stabilization $ 100,000 $ 100,000 $ 140,000 $ 440,000 $ 440,000 $ 502,000 $ 726,000 $ 726,000 n/a n/a * In 2019, Resolution 41-19 changed the reserve to 15% of the GF Total Spending and eliminated the Revenue Stabilization Reserve - changes with appropriations throughout year $- $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000 $7,000,000 $8,000,000 $9,000,000 January February March April May June July August September October November December General Fund Cash Balance 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 7 July 8/4/2020 General Fund Treasurer 001-250-000 Sales 313.11 Special Purpose 313.15 MONTHLY SALES TAX RECEIPTS Revenue Cumulative Cumulative Year End 3 yr. avg Expected Actual Over/Under % of projection 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2017-19 2020 2020 Expected expected Projection Over/Under January 154,373 180,283 156,597 207,318 152,937 133,849 137,774 137,615 177,776 176,956 163,811 185,292 185,505 207,899 258,313 303,235 6.7%224,122 303,235 $79,114 135.30%$4,500,882 $1,174,273February224,687 244,043 249,049 206,809 219,448 215,617 201,110 206,281 227,634 218,000 239,784 263,305 310,729 279,301 314,528 355,834 9.4%311,072 355,834 $44,762 123.15%$4,096,584 $769,975March142,119 161,270 157,709 170,679 177,252 122,153 136,282 115,959 194,619 156,957 164,393 194,466 189,576 206,999 241,958 251,543 6.6%219,588 251,543 $31,956 120.65%$4,013,416 $686,807 April 156,731 170,147 181,390 162,253 148,592 131,100 127,885 124,117 174,718 154,216 167,550 181,384 193,862 202,532 209,415 249,173 6.3%208,334 249,173 $40,839 120.42%$4,005,909 $679,300 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 8.4%280,693 267,758 -$12,935 114.77%$3,818,015 $491,406June 164,380 165,275 175,802 167,706 172,947 133,593 154,669 133,909 166,750 156,362 196,231 196,762 208,349 248,506 263,069 243,568 7.4%247,577 243,568 -$4,009 107.94%$3,590,720 $264,111July187,091 235,150 199,236 174,881 159,276 136,373 166,276 155,881 188,957 174,130 185,889 204,143 236,448 262,489 308,592 323,542 8.3%277,705 323,542 $45,838 108.24%$3,600,762 $274,153August220,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 9.9%329,733 - -$329,733 80.66% 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 9.0%298,735 - -$298,735 58.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 9.4%312,531 - -$312,531 38.68% November 253,367 234,710 263,159 239,855 213,651 200,463 180,293 206,475 220,843 231,070 240,812 293,377 279,959 311,101 363,975 9.9%328,431 - -$328,431 20.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 8.7%288,089 - -$288,089 0.00% TTL 2,311,638 2,469,708 2,453,909 2,410,507 2,137,279 1,918,151 1,968,790 2,047,153 2,348,673 2,300,936 2,486,611 2,738,244 2,876,339 3,195,259 3,601,761 1,994,654 100.0%$3,326,609 $1,994,654 -$1,331,955 $3,590,720 $264,111 ytd 1,228,135 1,368,163 1,327,378 1,302,232 1,211,966 1,047,803 1,102,464 1,025,213 1,325,629 1,214,695 1,325,608 1,451,643 1,574,065 1,679,158 1,891,067 1,994,654 1,769,090 1,994,654 (1,331,955) ytd change 11.40%-2.98%-1.89%-6.93%-13.55%5.22%-7.01%29.30%-8.37%9.13%9.51%8.43%6.68%12.62%5.48%12.75%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% Special Purp./Public Safety Tax Cumulative Cumulative Year EndActual3 yr avg.Projection Actual Over/Under % of projection20052006200720082009201020112012201320142015201620172018201920202017-19 2020 2020 Expected expected Projection Over/Under January 45,217 50,919 50,377 51,210 58,026 61,161 66,993 79,236 84,751 7.0%73,057 84,751 $11,695 116.01%$1,212,562 $167,318 February 61,899 70,678 67,508 73,364 83,521 93,242 90,853 94,690 101,181 9.4%98,207 101,181 $2,973 103.03%$1,076,892 $31,648 March 40,604 56,106 49,782 50,931 62,285 61,183 66,479 70,614 72,888 6.7%69,846 72,888 $3,042 104.35%$1,090,764 $45,520April43,155 51,054 47,573 52,541 59,481 59,911 63,784 65,310 69,887 6.4%66,580 69,887 $3,306 104.97%$1,097,151 $51,907May51,908 58,324 56,012 62,613 74,233 78,716 84,357 88,754 75,138 8.5%88,710 75,138 -$13,572 84.70%$885,324 -$159,920 June 45,930 46,797 50,067 48,647 58,717 65,832 65,229 75,141 77,429 68,693 7.3%76,724 68,693 -$8,031 89.53%$935,839 -$109,405 July 55,488 49,385 68,295 54,074 56,793 69,908 73,136 81,117 89,815 86,275 8.2%85,977 86,275 $298 100.35%$1,048,866 $3,622August59,578 56,220 56,063 68,712 76,734 87,275 89,679 97,261 107,514 9.9%103,727 - September 55,746 54,902 61,455 64,622 72,022 77,854 77,534 97,036 94,733 9.1%94,867 - October 59,692 61,120 64,400 64,152 73,903 82,028 82,991 95,473 97,187 9.3%97,103 - November 58,107 60,952 64,915 71,491 77,947 89,596 90,736 98,020 105,075 9.9%103,507 - December 46,767 49,281 52,177 59,043 62,263 66,133 69,582 83,431 93,783 8.3%86,938 - TOTAL 381,308 621,440 704,453 701,993 769,039 876,170 903,099 999,945 1,064,140 558,813 100.0%1,045,244 558,813 (289) 935,839 (109,405) ytd 101,418 338,965 405,443 373,973 406,170 473,285 492,577 528,724 565,848 558,813 559,102 $558,813 -$289 ytd change 19.61%-7.76%8.61%16.52%4.08%7.34%7.02%-1.24%-0.05%over (under) ytd expected annual % chg.62.98%13.36%-0.35%9.55%13.93%3.07%10.72%6.42% Sales Tax receipts are for the approximate timeframe of two months prior depending on the business reporting schedules.3 yr avg.Projection Actual Over/Under % of projectionSales Tax 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2017-19 2020 2020 Expected expected Projection Over/Under General & Optional YTD1,228,135 1,368,163 1,327,378 1,302,232 1,211,966 1,047,803 1,203,882 1,364,178 1,731,072 1,588,668 1,731,778 1,924,928 2,066,642 2,207,882 2,456,915 2,553,467 #VALUE!2,328,192 2,553,467 (1,332,244) 3,590,720 264,111 Special Purpose YTD - - - - - - 101,418 338,965 405,443 373,973 406,170 473,285 492,577 528,724 565,848 558,813 559,102 558,813 (289) 935,839 (109,405) G&O and SP Sales Tax YTD1,228,135 1,368,163 1,327,378 1,302,232 1,211,966 1,047,803 1,305,300 1,703,143 2,136,515 1,962,642 2,137,947 2,398,212 2,559,219 2,736,606 3,022,762 3,112,280 #VALUE!2,887,294 3,112,280 (1,332,533) 4,526,560 154,707 Full Year Total Actual w/ 2020 Budget2,311,638 2,469,708 2,453,909 2,410,507 2,137,279 1,918,151 2,350,098 2,668,593 3,053,126 3,002,929 3,255,650 3,614,414 3,779,438 4,195,203 4,665,900 4,371,853 2,553,467 4,371,853 - - MONTHLY SALES TAX GENERAL & OPTIONAL AND SPECIAL PURPOSE Revenue Cumulative Cumulative Year End 3 yr. avg Expected Actual Over/Under % of projection 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2017-19 2020 2020 Expected expected ProjectionYear End Projected Over/Under Budget January 154,373 180,283 156,597 207,318 152,937 133,849 137,774 182,832 228,695 227,333 215,021 243,317 246,667 274,892 337,549 387,987 8.9%297,178 387,987 $90,808 130.56%$5,713,443 $1,341,590 February 224,687 244,043 249,049 206,809 219,448 215,617 201,110 268,180 298,312 285,508 313,148 346,826 403,971 370,154 409,218 457,015 12.2%409,279 457,015 $47,736 111.66%$5,173,476 $801,623 March 142,119 161,270 157,709 170,679 177,252 122,153 136,282 156,563 250,725 206,739 215,324 256,751 250,759 273,478 312,572 324,431 8.7%289,434 324,431 $34,997 112.09%$5,104,180 $732,327April156,731 170,147 181,390 162,253 148,592 131,100 127,885 167,272 225,772 201,789 220,090 240,865 253,772 266,316 274,725 319,060 8.2%274,914 319,060 $44,145 116.06%$5,103,060 $731,207May198,754 211,995 207,595 212,586 181,514 175,118 178,468 203,359 253,499 234,086 270,564 300,523 328,312 355,788 383,945 342,896 11.0%369,403 342,896 -$26,507 92.82%$4,703,340 $331,487 June 164,380 165,275 175,802 167,706 172,947 133,593 200,599 180,706 216,817 205,010 254,948 262,594 273,577 323,647 340,499 312,261 9.7%324,301 312,261 -$12,040 96.29%$4,526,560 $154,707 July 187,091 235,150 199,236 174,881 159,276 136,373 221,764 205,266 257,252 228,204 242,682 274,051 309,584 343,606 398,407 409,818 10.9%363,682 409,818 $46,136 112.69%$4,649,628 $277,775August220,873 241,022 250,665 244,562 199,901 184,345 246,710 248,822 275,646 307,496 334,103 363,584 383,632 406,836 462,808 - 13.0%433,460 - September 211,602 211,286 200,636 213,505 187,214 173,733 225,125 297,214 260,334 276,640 299,788 325,230 318,859 404,786 414,342 - 11.8%393,602 - October 213,751 244,393 214,468 212,410 168,681 161,452 242,654 265,078 278,972 272,408 313,293 336,030 350,255 402,305 431,890 - 12.2%409,634 - November 253,367 234,710 263,159 239,855 213,651 200,463 238,400 267,427 285,758 302,561 318,760 382,973 370,695 409,120 469,051 - 12.9%431,938 - December 183,910 170,134 197,603 197,943 155,866 150,355 193,327 225,874 221,344 255,155 257,928 281,670 289,354 364,274 430,895 - 11.2%375,028 - TTL 2,311,638 2,469,708 2,453,909 2,410,507 2,137,279 1,918,151 2,350,098 2,668,593 3,053,126 3,002,929 3,255,650 3,614,414 3,779,438 4,195,203 4,665,900 2,553,467 109.6%$4,371,853 $2,553,467 ytd 1,228,135 1,368,163 1,327,378 1,302,232 1,211,966 1,047,803 1,203,882 1,364,178 1,731,072 1,588,668 1,731,778 1,924,928 2,066,642 2,207,882 2,456,915 2,553,467 2,328,192 2,553,467 ytd change 11.40%-2.98%-1.89%-6.93%-13.55%14.90%13.31%26.89%-8.23%9.01%11.15%7.36%6.83%11.28%3.93%9.68%over (under) ytd expectedannual % chg.6.84%-0.64%-1.77%-11.33%-10.25%22.52%13.55%14.41%-1.64%8.42%11.02%4.57%11.00%11.22% - 500,000 1,000,000 1,500,000 2,000,000 2,500,000 3,000,000 3,500,000 4,000,000 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 GENERAL & OPTIONAL SALES TAX RECEIPTS BY MONTH AND YEAR (Does not include Special Purpose/Public Safety Tax) June 2020 December November October September August July June May April March February January - 500,000 1,000,000 1,500,000 2,000,000 2,500,000 3,000,000 3,500,000 4,000,000 4,500,000 5,000,000 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Sales Tax and Special Purpose Sales Tax YTD, Actual Total and 2020 Budget June 2020 Special PurposeYTD General & Optional YTD Full Year Total Actual w/ 2020 Budget - 50,000 100,000 150,000 200,000 250,000 300,000 350,000 400,000 450,000 500,000 1 2 3 4 5 6 7 8 9 10 11 12 2020 Monthly Actual Revenue & Budgeted Share Actual 2020 Expected 2020 -$500,000 $500,000 $1,500,000 $2,500,000 $3,500,000 $4,500,000 $5,500,000 1 2 3 4 5 6 7 8 9 10 11 12 2020 Cumulative YTD Actual & Budget Expected by Month Year End Projected Over/Under Budget YTD Budget YTD Actual $0.00 7 July 302-000-010 Capital Improvement fund, not other financing sources, transfer, appropriation Recent 2020 % Budget Month Change 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 4 YR AVG Budget Difference prior year January $78,294 $83,384 $72,424 $45,530 123,064$ 28,601$ 56,823$ 28,435$ 28,059$ 44,132$ 33,177$ 57,144$ 78,597$ 49,830$ 64,496 69,086 62,517 57,998 19.1%7.1% February $112,120 $74,250 $65,590 $45,612 10,730$ 22,594$ 66,268$ 30,745$ 18,846$ 26,888$ 48,279$ 51,148$ 47,854$ 65,067$ 51,891 84,560 53,990 50,087 68.8%63.0% March $92,812 $82,868 $58,766 $63,286 66,768$ 44,044$ 34,138$ 39,257$ 42,889$ 40,689$ 168,735$ 79,657$ 91,388$ 75,558$ 82,105 93,964 82,177 76,237 23.3%14.4% April $105,772 $83,776 $95,258 $105,272 20,838$ 54,965$ 21,847$ 35,754$ 60,839$ 55,546$ 61,766$ 77,161$ 78,523$ 102,480$ 89,657 78,860 86,955 80,670 -2.2%-12.0% May $124,210 $125,632 $86,666 $49,638 34,242$ 36,932$ 27,146$ 59,286$ 50,555$ 62,184$ 73,099$ 108,945$ 111,101$ 128,185$ 111,001 75,991 114,808 106,509 -28.7%-31.5% June $164,122 $137,630 $89,338 $54,812 30,788$ 35,648$ 37,194$ 44,068$ 63,205$ 71,373$ 118,836$ 241,046$ 147,551$ 147,514$ 104,991 205,638 160,276 148,690 38.3%95.9% July $132,668 $117,584 $108,226 $57,890 43,154$ 34,393$ 36,658$ 28,856$ 57,623$ 67,722$ 110,603$ 105,451$ 105,582$ 108,763$ 136,683 160,738 114,120 105,871 51.8%17.6% August $133,848 $355,084 $92,362 $58,240 46,658$ 31,371$ 30,855$ 43,974$ 71,327$ 55,685$ 92,001$ 125,719$ 110,037$ 131,097$ 130,942 124,449 115,453 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 124,986 115,952 October $203,764 $89,674 $100,551 $46,562 31,806$ 31,382$ 34,231$ 66,934$ 57,808$ 65,594$ 102,267$ 137,192$ 113,373$ 119,144$ 134,016 125,931 116,828 November $126,964 $99,990 $52,266 $22,654 54,154$ 31,746$ 33,220$ 67,226$ 127,615$ 41,510$ 66,034$ 75,151$ 119,897$ 96,368$ 110,009 100,356 93,102 December $97,838 $113,314 $46,605 $37,906 49,676$ 27,938$ 27,429$ 49,960$ 62,067$ 101,510$ 102,439$ 83,276$ 100,034$ 74,910$ 125,158 95,845 88,917 Total $1,520,315 $1,467,226 $935,188 $626,576 $559,398 $426,058 $443,450 $549,121 $707,883 $704,385 $1,196,934 $1,237,774 $1,285,270 $1,216,569 $1,246,024 $768,836 1,246,409$ 1,156,313$ -33.5%-38.3% YTD 809,998 705,124 576,268 422,040 329,584 $187,136 280,074 266,401 322,016 368,534 614,496 720,552 660,594 677,397 640,824 768,836 674,842$ 626,061$ 22.8%20.0% YTD change -12.95%-18.27%-26.76%-21.91%-43.22%10.20%-4.88%20.88%14.45%66.74%17.26%-8.32%2.54%-5.40%19.98% Annual % chg -12.95%-18.27%-26.76%-21.91%4.08%23.83%28.91%-0.49%69.93%3.41%3.84%-5.35%2.42% Actual Full Year or Budget $1,520,315 $1,467,226 $935,188 $626,576 $559,398 $426,058 $443,450 $549,121 $707,883 $704,385 $1,196,934 $1,237,774 $1,285,270 $1,216,569 $1,246,024 $1,156,313 Total Sales Value for year incl City of PT 219,533,884 237,164,120 348,155,918 395,379,956 404,420,675 365,442,489 369,816,284 Jan 2019 7 sales>$500k Jul 2019 1@$3.3M, 16>$500k Jan 2020 9 sales>$500k July 2020 2 sales over $1M: $1.25M & $1.025M; and 16 sales>$500k Feb 2019 1@$1M, 4 sales>$500k Aug 2019 2@$1.25M &1.2M, 12>$500k Feb 2020 1@1.2M & 6 sales>$500k 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 Apr 2019 9 sales>$500k Oct 2019 2@$1.475M and 1.5M, 6>$500k Apr 2020 8 sales>$500k May 2019 1@1.045M, 9 sales>$500k Nov 2019 2@$1.75M & 1.1M, 12>$500k May 2020 1@$1.3M and 6>$500k Jun 2019 1@$2.36M & 1@ $1.275M, 7>$500k Dec 2019 1@$2.61, 4@$1+,10>$500k June 2020 3 sales over $1M: $9.9M, $1.07M & $1.375M; and 19 sales>$500k 8/6/2020 $0 $200,000 $400,000 $600,000 $800,000 $1,000,000 $1,200,000 $1,400,000 $1,600,000 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Real Estate Excise Tax Collections -2005 to Present Fund 302 Capital Improvement Fund June 2020 December November October September August July June May April March February January Actual Full Year or Budget $0 $200,000 $400,000 $600,000 $800,000 $1,000,000 $1,200,000 $1,400,000 REET YTD, Actual Total and 2020 Budget YTD Actual YTD Budget 0 50,000 100,000 150,000 200,000 250,000 2020 Monthly Actual Revenue & Budgeted Share 2020 Actual Budget July 8/4/2020 4 yr avg *2020 2020 % Budget % Diff 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2016-19 Budget Actual Difference Prior Year January 16,089 11,507 12,045 8,863 13,575 17,051 18,473 19,394 23,177 29,854 32,023 22,725 22,792 32,023 40.5%7.3% February 27,998 25,532 23,188 38,274 30,356 36,141 51,077 53,093 46,226 41,186 34,092 47,895 48,037 34,092 -29.0%-17.2% March 22,623 12,406 7,271 11,203 12,715 14,345 14,554 16,889 19,419 25,281 29,621 19,035 19,092 29,621 55.2%17.2% April 11,344 10,791 14,950 11,430 12,427 14,983 18,530 20,901 23,749 22,829 29,140 21,502 21,566 29,140 35.1%27.6% May 19,646 25,142 17,142 18,010 19,151 23,886 29,462 45,943 41,061 41,546 11,527 39,503 39,620 11,527 -70.9%-72.3% June 19,205 17,302 17,916 16,477 18,786 25,070 29,476 31,485 36,556 43,299 742 35,204 35,308 742 -97.9%-98.3% July 20,155 19,311 20,201 21,512 24,536 27,711 33,687 38,400 44,445 48,748 24,074 41,320 41,442 24,074 -41.9%-50.6% August 35,178 24,742 31,171 33,140 37,534 48,845 56,349 64,820 64,934 70,516 64,155 64,345 September 41,757 42,500 40,882 39,890 42,349 44,713 53,487 56,561 68,870 88,306 66,806 67,004 October 43,012 43,861 41,015 41,741 43,659 49,182 59,970 58,458 65,200 60,682 61,077 61,258 November 44,351 38,547 36,906 39,146 46,879 58,967 57,999 69,054 63,101 65,013 63,792 63,980 December 19,873 21,703 11,109 15,514 33,858 25,213 26,084 32,870 46,067 42,545 36,892 37,001 Full Year 321,231 293,344 273,796 295,200 335,825 386,107 449,148 507,868 542,805 579,805 161,219 519,906 521,444 161,219 YTD 137,060 121,991 112,713 125,769 131,546 159,187 195,259 226,104 234,632 252,743 161,219 227,185 227,857 161,219 -29.2%-36.2% Full Year Actual/2020 Budget321,231 293,344 273,796 295,200 335,825 386,107 449,148 507,868 542,805 579,805 521,444 YTD Change 15.70%-7.61%11.58%4.59%21.01%22.66%15.80%3.77%7.72%-36.21% Annual % Change 0.24%-6.66%7.82%13.76%14.97%16.33%13.07%6.88%6.82%$521,444 2020 Budget 2% Basic RCW 67.28.181(1).RCW 67.28.180 2% Special RCW 67.28.181(1).11% Total sales tax paid on a lodging charges for periods of less than 30 consecutive days Revenue reflects 2% "basic" as a credit against 6.5% state sales tax, 2% "special" tax levied locally, interest on amounts held at DOR until disbursement, and 1% Admin fee from DOR. Revenue is reported one month after reporting to DOR. It typically reflects collections for activity from two months prior to distribution. Some businesses may report quarterly or annually. 0 100,000 200,000 300,000 400,000 500,000 600,000 700,000 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 December November October September August July June May April March February January Full Year Actual/2020 Budget $0 $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 2020 YTD Actual and Budget YTD Actual YTD Budget 0 10,000 20,000 30,000 40,000 50,000 60,000 70,000 80,000 2020 Monthly Actual and Budget 2020 Actual Budget