The URL can be used to link to this page

Home My WebLink AboutDocumentation_Regular_Tab 13_9/10/2020Agenda Item #13. Regular Council STAFF MEMO Meeting: Regular Council - Sep 10 2020 Staff Contact: James Trube, Fire Chief Department: Fire Resolution 30-20, A RESOLUTION OF THE VILLAGE COUNCIL OF THE VILLAGE OF TEQUESTA, FLORIDA, AUTHORIZING THE WRITE-OFF OF UNCOLLECTABLE EMS TRANSPORT USER FEES AS IDENTIFIED IN THE ATTACHED "EXHIBIT A", AMENDING AND INCREASING THE FISCAL YEAR 2017/2018 GENERAL FUND #001 BUDGET BY APPROPRIATING FUND BALANCE IN AN AMOUNT EQUAL TO THE AMOUNT IDENTIFIED IN THE ATTACHED "EXHIBIT All TO FUND BAD DEBT AND AUTHORIZING THE VILLAGE MANAGER TO PROCEED ON BEHALF OF THE VILLAGE A RESOLUTION OF THE VILLAGE COUNCIL OF THE VILLAGE OF TEQUESTA, FLORIDA, AUTHORIZING THE WRITE-OFF OF UNCOLLECTABLE EMS TRANSPORT USER FEES AS IDENTIFIED IN THE ATTACHED "EXHIBIT A", AMENDING AND INCREASING THE FISCAL YEAR 2017/2018 GENERAL FUND #001 BUDGET BY APPROPRIATING FUND BALANCE IN AN AMOUNT EQUAL TO THE AMOUNT IDENTIFIED IN THE ATTACHED "EXHIBIT All TO FUND BAD DEBT AND AUTHORIZING THE VILLAGE MANAGER TO PROCEED ON BEHALF OF THE VILLAGE; PROVIDING AN EFFECTIVE DATE; AND FOR OTHER PURPOSES. Resolution 30-20 Exhibit A.ada RESOLUTION 30-20.ada Page 814 of 852 Agenda Item #13. Village ofTecluesta RESOLUTION 30-20 EXHIBIT'A' Accounts Receivable to be Written -Off Selected By: Dates of Service for FY 10/2013 - 9/2014, 10/2014 - 9/2015, 10/2015 - 9/2016 FINANCIAL CLASS: Uncollectible Type of Debt Owed Dept Patient Acct # Dates of Service Current Balance Write-off Reason for Write-off 1 EMS Transport Fire 1587 2/4/2017 265.00 Uncollectible, In collections 2 EMSTransport Fire 1677 4/13/2017 78.84 Uncollectible, other 3 EMS Transport Fire 1 1723 5/19/2017 457.48 Uncollectible, In collections 4 EMSTransport Fire 1278 6/2/2017 460.38 Uncollectible, Deceased 5 EMS Transport Fire 1735 6/11/2017 31.64 Uncollectible, In collections 6 EMSTransport Fire 1758 6/19/2017 646.75 Uncollectible, other 7 EMS Transport Fire 1752 6/24/2017 250.00 Uncollectible, In collections 8 EMS Transport Fire 1500 6/24/2017 131.53 Uncollectible, In collections 9 EMSTransport Fire 1771 6/27/2017 453.13 Uncollectible, In collections 10 EMS Transport Fire 1772 6/28/2017 466.18 Uncollectible, In collections 11 EMS Transport Fire 1773 6/30/2017, 8/25/2018 909.88 Uncollectible, In collections 12 EMSTransport Fire 1774 6/30/2017 507.51 Uncollectible, Deceased 13 EMS Transport Fire 1775 6/30/2017 456.75 Uncollectible, In collections 14 EMS Transport Fire 1778 7/1/2017 91.50 Uncollectible, In collections 15 EMS Transport Fire 1485 7/1/2017 25.00 Uncollectible, In collections 16 EMS Transport Fire 1779 7/3/2017 452.40 Uncollectible, In collections 17 EMS Transport Fire 1789 7/21/2017 150.00 Uncollectible, In collections 18 EMS Transport Fire 1781 7/10/2017 461.83 Uncollectible, In collections 19 EMS Transport Fire 1792 7/13/2017 350.00 Uncollectible, In collections 20 EMSTransport Fire 851 8/27/2018 457.48 Uncollectible, Indigent 21 EMSTransport Fire 593 7/17/2017; 8/11/2017; 9/4/2017 750.00 Uncollectible, Deceased 22 EMS Transport Fire 1801 7/19/2017 464.73 Uncollectible, In collections 23 EMS Transport Fire 1803 7/24/2017; 10/19/2017 410.00 Uncollectible, In collections 24 EMSTransport Fire 1865 7/26/2017 459.65 Uncollectible, other 25 EMS Transport Fire 1805 7/27/2017 459.65 Uncollectible, In collections 26 EMSTransport Fire 1807 7/28/2017 471.25 Uncollectible, In collections 27 EMSTransport Fire 1201 7/28/2017, 10/25/2017, 1/15/2019 750.00 Uncollectible, Deceased 28 EMSTransport Fire 1817 7/30/2017 250.00 Uncollectible, In collections 29 EMSTransport Fire 1804 8/1/2017, 9/18/2017 300.00 Uncollectible, In collections 30 EMS Transport Fire 1826 8/2/2017 457.48 Uncollectible, In collections 31 EMSTransport Fire 1288 8/2/2017 454.58 Uncollectible, other 32 EMS Transport Fire 1824 8/3/2017 458.93 Uncollectible, In collections 33 EMSTransport Fire 1825 8/3/2017 91.79 Uncollectible, other 34 EMS Transport Fire 1819 8/6/2017 91.64 Uncollectible, In collections 35 EMSTransport Fire 1862 8/7/2017 91.64 Uncollectible, other 36 EMS Transport Fire 1831 8/9/2017 100.00 Uncollectible, In collections 37 EMS Transport Fire 1822 8/11/2017 458.20 Uncollectible, In collections 38 EMSTransport Fire 844 8/15/2017 458.20 Uncollectible, Deceased 39 EMS Transport Fire 1636 8/17/2017 - 7/25/2018 2761.54 Uncollectible, other 40 EMSTransport Fire 1090 1/9/2016 171.75 Village employee 41 EMS Transport Fire 227 8/24/2017 - 8/5/2018 413.65 Uncollectible, In collections 42 EMS Transport Fire 1840 8/24/2017 456.03 Uncollectible, In collections 43 EMSTransport Fire 1721 9/5/2017 461.83 Uncollectible, other 44 EMS Transport Fire 1869 9/11/2017 458.93 Uncollectible, In collections 45 EMSTransport Fire 1873 9/11/2017 458.20 Uncollectible, other 46 EMS Transport Fire 1034 9/11/2017 460.38 Uncollectible, In collections 47 EMSTransport Fire 1875 9/11/2017 473.43 Uncollectible, other 48 EMS Transport Fire 806 6/12/2015 - 6/4/2018 1236.83 Uncollectible, In collections 49 EMS Transport Fire 1848 9/15/2017 79.28 Uncollectible, In collections 50 EMSTransport Fire 1850 9/15/2017 460.38 Uncollectible, other 51 EMS Transport Fire 1921 9/16/2017, 6/9/2018 305.99 Uncollectible, In collections 52 EMSTransport Fire 1857 9/24/2017 202.54 Uncollectible, other 53 EMSTransport Fire 1868 9/28/2017 18.39 Uncollectible, In collections 54 EMSTransport Fire 1602 9/28/2017 460.38 Uncollectible, other 55 EMSTransport Fire 1832 9/28/2017, 9/6/2018, 9/8/2018 705.00 Uncollectible, In collections "Village Mgr aware Page 815 of 852 Agenda Item #13. Village ofTecluesta RESOLUTION 30-20 EXHIBIT'A' Accounts Receivable to be Written -Off Selected By: Dates of Service for FY 10/2013 - 9/2014, 10/2014 - 9/2015, 10/2015 - 9/2016 FINANCIAL CLASS: Uncollectible 56 EMSTransport Fire 737 10/1/2017 250.00 Uncollectible, Deceased 57 EMSTransport Fire 1915 10/3/2017 45.39 Uncollectible, In collections 58 EMSTransport Fire 1871 10/4/2017, 8/31/2018 297.85 Uncollectible, In collections 59 EMSTransport Fire 991 10/6/2017 460.38 Uncollectible, Deceased 60 EMSTransport Fire 288 10/8/2017 461.10 Uncollectible, other 61 EMS Transport Fire 1917 10/8/2017 66.89 Uncollectible, In collections 62 EMS Transport Fire 1881 10/11/2017 456.87 Uncollectible, In collections 63 EMSTransport Fire 1903 10/13/2017 439.35 Uncollectible, other 64 EMSTransport Fire 1455 10/13/2017, 4/9/2018, 8/2/2018 1379.68 Uncollectible, Deceased 65 EMS Transport Fire 1722 5/14/2017 - 1/23/2018 3751.24 Uncollectible, In collections 66 EMS Transport Fire 1887 10/16/2017 453.13 Uncollectible, In collections 67 EMS Transport Fire 1879 10/18/2017 - 1/23/2019 911.33 Uncollectible, In collections 68 EMSTransport Fire 1759 10/20/2017 255.27 Uncollectible, other 69 EMSTransport Fire 1888 10/22/2017 191.82 Uncollectible, other 70 EMS Transport Fire 1452 10/28/2017, 12/17/2017 500.00 Uncollectible, In collections 71 EMSTransport Fire 1988 10/28/2017 469.08 Uncollectible, other 72 EMSTransport Fire 1816 11/30/2017 460.38 Uncollectible, other 73 EMSTransport Fire 1890 10/30/2017 460.38 Uncollectible, other 74 EMSTransport Fire 2034 11/8/2017 92.66 Uncollectible, other 75 EMS Transport Fire 1503 11/11/2017 464.00 Uncollectible, In collections 76 EMSTransport Fire 1904 11/12/2017 201.96 Uncollectible, other 77 EMS Transport Fire 1938 11/13/2017 455.30 Uncollectible, In collections 78 EMS Transport Fire 1934 11/20/2017 454.58 Uncollectible, In collections 79 EMS Transport Fire 1922 11/21/2017 133.86 Uncollectible, In collections 80 EMSTransport Fire 1816 11/23/2017 460.38 Uncollectible, other 81 EMSTransport Fire 1929 11/24/2017 308.43 Uncollectible, other 82 EMS Transport Fire 1927 11/24/2017 112.56 Uncollectible, In collections 83 EMSTransport Fire 1931 11/26/2017 26.67 Uncollectible, foreigner 84 EMSTransport Fire 1933 11/27/2017 203.99 Uncollectible, other 85 EMS Transport Fire 1935 11/28/2017, 11/30/2017 100.00 Uncollectible, In collections 86 EMS Transport Fire 1936 12/4/2017 456.75 Uncollectible, In collections 87 EMS Transport Fire 1937 12/4/2017 455.30 Uncollectible, In collections 88 EMSTransport Fire 1946 12/5/2017 453.13 Uncollectible, In collections 89 EMSTransport Fire 1952 12/11/2017, 4/12/2018 500.00 Uncollectible, Deceased 90 EMS Transport Fire 1957 12/15/2017 - 8/21/2018 157.89 Uncollectible, In collections 91 EMS Transport Fire 1960 12/16/2017 466.18 Uncollectible, In collections 92 EMS Transport Fire 1041 12/19/2017 250.00 Uncollectible, In collections 93 EMS Transport Fire 1964 12/20/2017 115.64 Uncollectible, In collections 94 EMSTransport Fire 1961 12/22/2017 458.93 Uncollectible, other 95 EMS Transport Fire 1726 12/23/2017 466.90 Uncollectible, In collections 96 EMS Transport Fire 1958 12/23/2017 463.28 Uncollectible, In collections 97 EMSTransport Fire 1993 12/24/2017 271.10 Uncollectible, other 98 EMSTransport Fire 1962 12/25/2017 150.00 Uncollectible, Deceased 99 EMS Transport Fire 1974 12/27/2017 460.38 Uncollectible, In collections 100 EMS Transport Fire 1975 12/27/2017 457.48 Uncollectible, In collections 101 EMS Transport Fire 1695 1/1/2018 1.47 Small insurance balance 102 EMS Transport Fire 1747 1/1/2018 0.90 Small insurance balance 103 EMS Transport Fire 1924 11/24/2017 - 3/31/2018 1.45 Small insurance balance 104 EMS Transport Fire 318 1/24/2018 1.46 Small insurance balance 105 EMS Transport Fire 1032 1/7/2018 0.90 Small insurance balance 106 EMSTransport Fire 759 1/8/2018 0.89 Small insurance balance 107 EMSTransport Fire 1997 1/8/2018, 3/7/2018 100.00 Uncollectible, In collections 108 EMSTransport Fire 2010 1/9/2018 92.22 Uncollectible, Deceased 109 EMS Transport Fire 1983 1/9/2018 461.83 Uncollectible, In collections 110 EMS Transport Fire 1996 1/11/2018 457.48 Uncollectible, In collections 111 EMS Transport Fire 2011 1/11/2018 250.00 Uncollectible, In collections 112 EMSTransport Fire 2024 1/13/2018 265.00 Uncollectible, In collections 113 EMSTransport Fire 1994 1/18/2018 458.93 Uncollectible, In collections 114 EMS Transport Fire 2006 1/21/2018 1.46 Small insurance balance R116 EMS Transport Fire 2004 1/22/2018 455.30 Uncollectible, In collections EMSTransport Fire 2003 1/22/2018 225.341 Uncollectible,other Page 816 of 852 Agenda Item #13. Village ofTecluesta RESOLUTION 30-20 EXHIBIT'A' Accounts Receivable to be Written -Off Selected By: Dates of Service for FY 10/2013 - 9/2014, 10/2014 - 9/2015, 10/2015 - 9/2016 FINANCIAL CLASS: Uncollectible 117 EMS Transport Fire 443 1/24/2018 0.89 Small insurance balance 118 EMS Transport Fire 318 1/24/2018 1.46 Small insurance balance 119 EMS Transport Fire 2007 1/24/2018 1.45 Small insurance balance 120 EMSTransport Fire 2009 1/24/2018 470.53 Uncollectible, other 121 EMS Transport Fire 2012 1/27/2018 0.89 Small insurance balance 122 EMS Transport Fire 2015 2/2/2018 226.79 Uncollectible, other 123 EMS Transport Fire 1550 12/28/2017, 2/2/2018 917.86 Uncollectible, Deceased 124 EMS Transport Fire 2033 2/14/2018 457.48 Uncollectible, In collections 125 EMS Transport Fire 620 2/10/2018 470.53 Uncollectible, In collections 126 EMS Transport Fire 2040 2/15/2018 458.93 Uncollectible, other 127 EMS Transport Fire 613 12/6/2017 - 12/26/2018 2233.47 Uncollectible, In collections 129 EMS Transport Fire 2075 2/18/2018 467.63 Uncollectible, In collections 131 EMS Transport Fire 2042 2/21/2018 129.21 Uncollectible, In collections 132 EMS Transport Fire 2058 2/22/2018 533.60 Uncollectible, other 133 EMS Transport Fire 2067 2/22/2018 253.06 Uncollectible, other 134 EMS Transport Fire 2052 2/23/2018 456.18 Uncollectible, In collections 135 EMS Transport Fire 2048 2/24/2018 458.20 Uncollectible, In collections 136 EMS Transport Fire 1473 2/24/2018 250.00 Uncollectible, In collections 137 EMS Transport Fire 1229 2/25/2018 92.08 Uncollectible, other 138 EMS Transport Fire 2053 2/26/2018 354.49 Uncollectible, In collections 140 EMS Transport Fire 2041 2/27/2018 456.03 Uncollectible, In collections 141 EMS Transport Fire 2059 2/28/2018 - 9/26/2018 500.00 Uncollectible, In collections 142 EMS Transport Fire 2054 3/1/2018 100.00 Uncollectible, In collections 143 EMS Transport Fire 2069 3/4/2018 - 5/19/2018 929.65 Uncollectible, Deceased 144 EMS Transport Fire 2070 3/5/2018 458.20 Uncollectible, In collections 145 EMS Transport Fire 2077 3/8/2018 91.06 Uncollectible, In collections 146 EMS Transport Fire 2071 3/8/2018 456.03 Uncollectible, In collections 147 EMS Transport Fire 1918 3/11/2018 35.34 Uncollectible, Deceased 148 EMS Transport Fire 2081 3/12/2018 442.98 Uncollectible, In collections 149 EMS Transport Fire 2086 3/16/2018 265.00 Uncollectible, In collections 150 EMS Transport Fire 2123 3/20/2018 265.00 Uncollectible, In collections 151 EMS Transport Fire 2095 3/21/2018 15.66 Uncollectible, In collections 152 EMS Transport Fire 2089 3/22/2018 455.30 Uncollectible, In collections 153 EMS Transport Fire 248 3/27/2018 461.10 Uncollectible, In collections 154 EMS Transport Fire 2134 3/30/2018 556.80 Uncollectible, In collections 155 EMS Transport Fire 932 3/9/2018 - 3/31/2018 99.56 Uncollectible, In collections 156 EMS Transport Fire 230 4/3/2018 93.09 Uncollectible, other 159 EMS Transport Fire 1104 4/7/2018 461.10 Uncollectible, In collections 160 EMS Transport Fire 1863 4/8/2018 - 4/21/2018 275.79 Uncollectible, Deceased 161 EMS Transport Fire 723 4/8/2018 461.10 Uncollectible, other 162 EMS Transport IFire 2109 4/10/2018 91.50 Uncollectible, other 163 EMS Transport Fire 2116 4/15/2018 455.30 Uncollectible, In collections 164 EMS Transport Fire 2113 4/15/2018 117.91 Uncollectible, In collections 165 EMS Transport Fire 2117 4/18/2018 250.00 Uncollectible, other 166 EMS Transport Fire 2145 4/21/2018 100.00 Uncollectible, In collections 168 EMS Transport Fire 2163 5/1/2018 461.83 Uncollectible, In collections 169 EMS Transport Fire 2175 5/2/2018 440.08 Uncollectible, other 170 EMS Transport Fire 71 5/12/2018 0.46 Small insurance balance 171 EMS Transport Fire 1280 5/14/2018 67.94 Uncollectible, other 173 EMS Transport Fire 1264 5/21/2018 5.22 Small insurance balance 174 EMS Transport Fire 2063 5/25/2018 - 2/5/2019 275.08 Uncollectible, Deceased 175 EMS Transport Fire 2194 5/29/2018 300.00 Uncollectible, In collections 176 EMS Transport Fire 2193 5/30/2018 452.40 Uncollectible, In collections 177 EMS Transport Fire 2197 6/1/2018 450.83 Uncollectible, In collections 178 EMS Transport Fire 2207 6/12/2018 455.30 Uncollectible, In collections 179 EMS Transport Fire 2238 6/20/2018 456.75 Uncollectible, In collections 181 EMS Transport Fire 2183 6/21/2018 93.38 Uncollectible, other 182 EMS Transport Fire 2241 6/22/2018 250.00 Uncollectible, In collections 183 EMS Transport Fire 2243 6/22/2018 458.93 Uncollectible, In collections 184 EMS Transport Fire 1529 6/24/2018 4.49 Uncollectible, In collections 185 EMS Transport Fire 2219 7/3/2018 455.30 Uncollectible, In collections 187 EMS Transport Fire 1 2272 7/20/2018 1 461.83 Uncollectible, In collections ** recent bills To here: 51,587.95 Page 817 of 852 Agenda Item #13. Village ofTecluesta RESOLUTION 30-20 EXHIBIT'A' Accounts Receivable to be Written -Off Selected By: Dates of Service for FY 10/2013 - 9/2014, 10/2014 - 9/2015, 10/2015 - 9/2016 FINANCIAL CLASS: Uncollectible 188 EMS Transport Fire 2260 7/23/2018 438.63 Uncollectible, In collections 189 EMSTransport Fire 2276 7/25/2018 89.90 Uncollectible, Deceased 192 EMS Transport Fire 2255 8/5/2018 642.40 Uncollectible, In collections 193 EMS Transport Fire 2256 8/5/2018 462.55 Uncollectible, In collections 194 EMS Transport Fire 2267 8/9/2018 460.38 Uncollectible, In collections 195 EMS Transport Fire 2270 8/12/2018 49.78 Uncollectible, In collections 196 EMS Transport Fire 2329 8/16/2018 175.00 Uncollectible, In collections 197 EMS Transport Fire 521 8/19/2018 79.19 Uncollectible, In collections 198 EMS Transport Fire 2273 8/20/2018 458.20 Uncollectible, In collections 199 EMS Transport Fire 2301 8/27/2018 298.07 Uncollectible, In collections 200 EMS Transport Fire 2303 8/31/2018 90.92 Uncollectible, In collections 202 EMSTransport Fire 2322 9/18/2018 91.93 Uncollectible ,other 203 EMS Transport Fire 2330 9/28/2018 4.47 Small insurance balance 204 EMS Transport Fire 2328 9/30/2018 200.00 Uncollectible, In collections TOTAL: $71,107.14 Page 818 of 852 Agenda Item #13. RESOLUTION NO. 30-20 A RESOLUTION OF THE VILLAGE COUNCIL OF THE VILLAGE OF TEQUESTA, FLORIDA, AUTHORIZING THE WRITE-OFF OF UNCOLLECTABLE EMS TRANSPORT USER FEES AS IDENTIFIED IN THE ATTACHED "EXHIBIT A", AMENDING AND INCREASING THE FISCAL YEAR 2017/2018 GENERAL FUND #001 BUDGET BY APPROPRIATING FUND BALANCE IN AN AMOUNT EQUAL TO THE AMOUNT IDENTIFIED IN THE ATTACHED "EXHIBIT A" TO FUND BAD DEBT AND AUTHORIZING THE VILLAGE MANAGER TO PROCEED ON BEHALF OF THE VILLAGE; PROVIDING AN EFFECTIVE DATE; AND FOR OTHER PURPOSES. WHEREAS, Tequesta Fire Rescue responds to more than 1200 calls for service each year and transports approximately 700 distressed patients to local hospitals to receive emergency care. Tequesta Fire Rescue enjoys an 82% collection fee rate, meaning 82% of our transport billable is collected. A majority of ambulance transportation fees are paid by a patient's medical insurance, or by the patient directly; WHEREAS, the majority of uncollected charges involve: Patients who are unable to pay the cost of the service; Patients who provide an unverifiable local address or bad address; Patients who have moved and left no forwarding address; Patients who fail to meet their co -pay to the Village after their insurance makes the transport payment; Patients who have a large insurance deductible and are unable to pay that deductible; Patients who provide Medicare coverage as primary insurance and as a result, we are required to accept as paid in full; WHEREAS, to the greatest extent possible, the Village prefers to ask those who use the ambulance service to pay for it. When patients cannot afford to pay EMS fees, property owners must cover the expense in the form of property taxes. The write-off of the uncollectable accounts listed in "Exhibit A" is authorized solely to facilitate the keeping of the books of account of the Village, and under no circumstances shall any write-off be deemed to constitute a relinquishment or abandonment by the Village of any such account or claim, and nothing shall be deemed or construed to prevent the Village from collecting or enforcing payment of any such account or claim at any time. Write-offs are a standard accepted accounting practice and not debt forgiveness; WHEREAS, the Village of Tequesta has attempted collection of EMS user fees of specific accounts totaling $71,107.14, as listed on the attached "Exhibit A" and as generated by the Fire Department's EMS software and has determined these accounts to be uncollectable; WHEREAS, the Village is appropriating fund balance to fund the write-off of the uncollectable accounts, therefore the transaction will be recorded in General Fund 9001 as follows: Page 819 of 852 Agenda Item #13. Dr. 001-192-549.397 Bad Debt Expense $71,107.14 NOW, THEREFORE, BE IT RESOLVED BY THE VILLAGE COUNCIL OF THE VILLAGE OF TEQUESTA, PALM BEACH COUNTY, FLORIDA, AS FOLLOWS: Section 1 Resolution No. 30-20 is hereby approved authorizing the write-off of uncollectable EMS transportation fee accounts as listed in "Exhibit A" to facilitate the keeping of the books of account of the Village and appropriating fund balance to fund bad debt expense in Department 192, Fire Control; Section 2 This Resolution shall become effective immediately upon passage. Page 820 of 852