HomeMy WebLinkAboutDocumentation_Regular_Tab 15_9/8/2022Agenda Item #15.
Regular Council
STAFF MEMO
Meeting: Regular Council - Sep 08 2022
Staff Contact: James Trube, Fire Chief Department: Fire
RESOLUTION 28-22, A RESOLUTION OF THE VILLAGE COUNCIL OF THE VILLAGE OF
TEQUESTA, FLORIDA, AUTHORIZING THE WRITE-OFF OF UNCOLLECTABLE EMS TRANSPORT
FEES AS IDENTIFIED IN THE ATTACHED "EXHIBIT A", AND AUTHORIZING THE VILLAGE
MANAGER TO PROCEED ON BEHALF OF THE VILLAGE; PROVIDING AN EFFECTIVE DATE; AND
FOR OTHER PURPOSES.
Please find attached Resolution 28-22 which allows for the Village of Tequesta to write off uncollectable
EMS transport fees (dates ranging from 2016 — FY 2020 including some expected uncollectible
amounts going into the current year) from Accounts Receivable Fire Transportation (Acct # 001-000-
115.210) as identified in Exhibit A. These write offs are primarily due to patients being deceased,
bankrupt or currently in collections. The suggested total write off amount is $122,680.51.
This document and any attachments may be reproduced upon request in an alternative format by completing
our Accessibility Feedback Form, sending an e-mail to the Village Clerk or calling 561-768-0443.
PROJECT NAME: EMS Write
off
Proposed:
N/A
PROJECTED TOTAL: N/A
BUDGET: N/A - Balance Sheet ENCUMBERED: N/A
Adjustment
Projected Remaining:
N/A
POTENTIAL MOTION / DIRECTION REQUESTED." -
Approve write off of uncollectable EMS Transport Fees
ATTACHMENTS: W
Memo - EMS Write off of uncollectable accounts
Resolution 28-22 - WRITE OFF OF UNCOLLECTABLE EMS TRANSPORT FEES -RESOLUTION
2022
FY2022 EMS Write-off Exhibit A
Page 141 of 537
Agenda Item #15.
Village of Tequesta
Department of Fire -Rescue Services
357 Tequesta Drive
Tequesta, FL 33469
alp
IRS
James Trube, Fire Chief
To: Village Mayor and Council Me bers,
From. James Trube Fire Chief
Date: August 10, 2022
Re: Resolution 28-22- Write off uncollectable EMS Transport Fees
561-768-0500
www.tequesta.org
Please find attached Resolution 28-22 which allows for the Village of Tequesta to write
off uncollectable EMS transport fees (dates ranging from 2016 — FY 2020 including
some expected uncollectible amounts going into the current year) from Accounts
Receivable Fire Transportation (Acct # 001 -000-115.210) as identified in Exhibit A.
These write offs are primarily due to patients being deceased, bankrupt or currently in
collections. The suggested total write off amount is $122,680.51.
Vice -Mayor Kyle Stone Mayor Molly Young Council Member Frank D'Ambra III
Council Member Laurie Brandon Council Member Aaron Johnson
Village Manager Jeremy Allen Page 142 of 537
Agenda Item #15.
RESOLUTION NO.28-22
A RESOLUTION OF THE VILLAGE COUNCIL OF THE VILLAGE OF
TEQUESTA, FLORIDA, AUTHORIZING THE WRITE-OFF OF
UNCOLLECTABLE EMS TRANSPORT FEES AS IDENTIFIED IN THE
ATTACHED "EXHIBIT A", AND AUTHORIZING THE VILLAGE
MANAGER TO PROCEED ON BEHALF OF THE VILLAGE;
PROVIDING AN EFFECTIVE DATE; AND FOR OTHER PURPOSES.
WHEREAS, the Village of Tequesta has on its books numerous delinquent accounts for
past due EMS transports and are still maintained as available revenue on the accounts receivable
ledgers of the Village; and,
WHEREAS, the Village of Tequesta has attempted collection of EMS transportation fees
of specific accounts totaling $122,680.51, 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;
and,
WHEREAS, Fire Department submit, at least annually, a request for Bad Debt Write -Off
for the Council approval by resolution;
WHEREAS, 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;
NOW, THEREFORE, BE IT RESOLVED BY THE VILLAGE COUNCIL OF THE
VILLAGE OF TEQUESTA, PALM BEACH COUNTY, FLORIDA, AS FOLLOWS:
Section 1 Resolution No. 28-22 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;
Section 2 This Resolution shall become effective immediately upon passage.
Page 143 of 537
Agenda Item #15. Village of Tequesta
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
1197
2/27/2016
297.89
Uncollectible, other
2
EMS Transport
Fire
1940
11/25/2017
534.33
Uncollectible, other
31
EMS Transport
Fire
1242
1/15/2018
0.89
Small insurance balance
4
EMS Transport
Fire
2027
2/5/2018
461.83
Uncollectible, other
5
EMS Transport
Fire
1441
2/16/2018 - 12/12/2018
370.33
Uncollectible, In collections
6
EMS Transport
Fire
2111
4/10/2018
460.38
Uncollectible, other
7
EMS Transport
Fire
1273
5/7/2018 - 5/10/2019
916.41
Uncollectible, other
81
EMS Transport
Fire
2187
5/27/2018
455.30
Uncollectible, other
9
EMS Transport
Fire
2262
8/4/2018
462.55
Uncollectible, other
10
EMS Transport
Fire
2263
8/10/2018
455.30
Uncollectible, other
111
EMS Transport
Fire
2250
9/15/2018
463.28
Uncollectible, other
12
EMS Transport
Fire
2333
10/3/2018
81.22
Uncollectible, other
13
EMS Transport
Fire
2330
10/9/2018 - 1/2/2020
1893.90
Uncollectible, In collections
141
EMS Transport
Fire
2395
11/30/2018
458.93
Uncollectible, other
15
EMS Transport
Fire
2409
12/7/2018
467.63
Uncollectible, other
161
EMS Transport
Fire
2470
1/11/2019
350.00
Uncollectible, In collections
17
EMS Transport
Fire
2450
1/12/2019
257.30
Uncollectible, other
18
EMS Transport
Fire
2755
1/16/2019 - 2/7/2022
3293.70
Uncollectible, In collections
191
EMS Transport
Fire
181
1/22/2019 - 1/11/2021
2080.08
Uncollectible, In collections
20
EMS Transport
Fire
1596
1/24/2019 - 12/25/2019
254.22
Uncollectible, other
211
EMS Transport
Fire
2541
1/26/2019
454.58
Uncollectible, other
22
EMS Transport
Fire
2608
3/11/2019
553.18
Uncollectible, other
23
EMS Transport
Fire
2616
4/27/2019
479.95
Uncollectible, In collections
241
EMS Transport
Fire
2636
5/22/2019
463.28
Uncollectible, other
25
EMS Transport
Fire
2661
5/29/2019 - 10/17/2019
284.45
Uncollectible, In collections
261
EMS Transport
Fire
2685
6/17/2019
474.88
Uncollectible, other
27
EMS Transport
Fire
2703
6/24/2019
455.30
Uncollectible, other
28
EMS Transport
Fire
2702
6/24/2019
266.03
Uncollectible, other
291
EMS Transport
Fire
2717
7/24/2019
671.00
Uncollectible, other
30
EMS Transport
Fire
2718
7/30/2019
534.00
Uncollectible, other
311
EMS Transport
Fire
2734
8/19/2019
529.00
Uncollectible, other
32
EMS Transport
Fire
2739
8/21/2019
504.00
Uncollectible, In collections
33
EMS Transport
Fire
1073
9/11/2019
534.00
Uncollectible, deceased
341
EMS Transport
Fire
2767
9/20/2019 - 10/4/2019
2006.00
Uncollectible, deceased
35
EMS Transport
Fire
2820
10/3/2019
528.00
Uncollectible, In collections
361
EMS Transport
Fire
2822
10/3/2019
136.25
Uncollectible, deceased
37
EMS Transport
Fire
2786
10/4/2019 - 10/9/2019
563.00
Uncollectible, deceased
38
EMS Transport
Fire
2793
10/5/2019
485.00
Uncollectible, other
391
EMS Transport
Fire
2816
10/6/2019
530.00
Uncollectible, In collections
40
EMS Transport
Fire
2819
10/6/2019
463.00
Uncollectible, other
411
EMS Transport
Fire
248
10/9/2019
536.00
Uncollectible, In collections
42
EMS Transport
Fire
2814
10/9/2019 - 1/8/2020
685.00
Uncollectible, In collections
43
EMS Transport
Fire
1 806
10/11/2019 - 8/30/2021
1875.00
Uncollectible, In collections
441
EMS Transport
Fire
1 2798
10/20/2019
60.00
Uncollectible, In collections
Page 144 of 537
Agenda Item #15. Village of Tequesta
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
M46IMSS
EMS Transport
Fire
2805
10/21/2019
4.35
Small insurance balance
Transport
Fire
2800
10/23/2019
471.00
Uncollectible, Indigent
471
EMS Transport
Fire
2803
11/1/2019
80.80
Uncollectible, other
48
EMS Transport
Fire
2801
11/2/2019
530.00
Uncollectible, In collections
491
EMS Transport
Fire
2824
11/7/2019
525.00
Uncollectible, other
50
EMS Transport
Fire
2826
11/8/2019 - 4/19/2020
1059.00
Uncollectible, In collections
51
EMS Transport
Fire
2815
11/10/2019 - 6/29/2020
242.82
Uncollectible, deceased
521
EMS Transport
Fire
2828
11/11/2019
531.00
Uncollectible, other
53
EMS Transport
Fire
1041
11/11/2019 - 12/25/2020
1710.00
Uncollectible, In collections
541
EMS Transport
Fire
2830
11/13/2019
250.00
Uncollectible, In collections
55
EMS Transport
Fire
2849
11/14/2019
469.00
Uncollectible, deceased
56
EMS Transport
Fire
2835
11/16/2019
95.30
Uncollectible, In collections
57
EMS Transport
Fire
2845
11/17/2019 - 1/10/2020
367.43
Uncollectible, deceased
581
EMS Transport
Fire
2838
11/18/2019
536.00
Uncollectible, In collections
59
EMS Transport
Fire
2563
11/19/2019
536.00
Uncollectible, In collections
60
EMS Transport
Fire
224
11/24/2019
543.00
Uncollectible, other
61
EMS Transport
Fire
2853
11/25/2019
536.00
Uncollectible, other
62
EMS Transport
Fire
2868
11/26/2019
531.00
Uncollectible, In collections
631
EMS Transport
Fire
2839
11/27/2019
265.00
Uncollectible, In collections
64
EMS Transport
Fire
2867
11/29/2019
530.00
Uncollectible, In collections
65
EMS Transport
Fire
2852
11/30/2019
2.02
Small insurance balance
661
EMS Transport
Fire
2561
12/1/2019
59.51
Uncollectible, In collections
67
EMS Transport
Fire
2857
12/9/2019
533.00
Uncollectible, In collections
681
EMS Transport
Fire
2883
12/10/2019 - 1/3/2020
1062.00
Uncollectible, In collections
69
EMS Transport
Fire
2865
12/11/2019 - 10/4/2020
1420.80
Uncollectible, deceased
70
EMS Transport
Fire
2863
12/11/2019 - 8/8/2020
1055.00
Uncollectible, In collections
711
EMS Transport
Fire
2864
12/11/2019
533.00
Uncollectible, In collections
72
EMS Transport
Fire
1918
12/12/2019 - 12/24/2019
1007.00
Uncollectible, deceased
731
EMS Transport
Fire
2933
12/14/2019
533.00
Uncollectible, other
74
EMS Transport
Fire
2870
12/14/2019
150.00
Uncollectible, In collections
75
EMS Transport
Fire
1295
12/15/2019
536.00
Uncollectible, other
761
EMS Transport
Fire
1623
12/16/2019
481.00
Uncollectible, In collections
77
EMS Transport
Fire
763
12/16/2019
536.00
Uncollectible, other
781
EMS Transport
Fire
2888
12/20/2019 - 6/7/2020
730.00
Uncollectible, deceased
79
EMS Transport
Fire
2897
12/20/2019
250.00
Uncollectible, In collections
80
EMS Transport
Fire
2904
12/22/2019 - 5/23/2020
1523.00
Uncollectible, In collections
811
EMS Transport
Fire
2553
12/23/2019 - 12/30/2019
500.00
Uncollectible, other
82
EMS Transport
Fire
2893
12/23/2019
529.00
Uncollectible, In collections
83
EMS Transport
Fire
2871
12/27/2019 - 9/22/2020
450.00
Uncollectible, In collections
841
EMS Transport
Fire
2872
12/27/2019
537.00
Uncollectible, In collections
85
EMS Transport
Fire
547
12/29/2019
230.00
Uncollectible, In collections
86
EMS Transport
Fire
1820
1/1/2020 - 1/6/2020
656.43
Uncollectible, In collections
87
EMS Transport
Fire
2886
1/2/2020 - 3/19/2021
960.00
Uncollectible, deceased
881
EMS Transport
I Fire
1 2885
1/3/2020
491.00
Uncollectible, In collections
Page 145 of 537
Agenda Item #15. Village of Tequesta
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
89
EMS Transport
Fire
2934
1/3/2020
381.87
Uncollectible, In collections
90
EMS Transport
Fire
2648
1/4/2020 - 2/3/2020
1068.00
Uncollectible, In collections
911
EMS Transport
Fire
2950
1/5/2020
467.00
Uncollectible, In collections
92
EMS Transport
Fire
993
1/5/2020
93.50
Uncollectible, In collections
931
EMS Transport
Fire
3028
1/5/2020
532.00
Uncollectible, other
94
EMS Transport
Fire
2903
1/6/2020
246.49
Uncollectible, other
95
EMS Transport
Fire
456
1/8/2020 - 2/3/2021
1169.00
Uncollectible, deceased
961
EMS Transport
Fire
2908
1/8/2020
400.00
Uncollectible, In collections
97
EMS Transport
Fire
2911
1/12/2020
95.78
Uncollectible, other
981
EMS Transport
Fire
2802
1/13/2020 - 2/29/2020
1472.00
Uncollectible, deceased
99
EMS Transport
Fire
2921
1/16/2020
94.56
Uncollectible, other
100
EMS Transport
Fire
41
1/16/2020
572.00
Uncollectible, In collections
1011
EMS Transport
Fire
2928
1/19/2020
533.00
Uncollectible, In collections
102
EMS Transport
Fire
2922
1/19/2020 - 1/17/2022
1471.09
Uncollectible, In collections
1031
EMS Transport
Fire
2914
1/20/2020
474.00
Uncollectible, other
104
EMS Transport
Fire
2915
1/21/2020
250.00
Uncollectible, In collections
105
EMS Transport
Fire
2920
1/22/2020
535.00
Uncollectible, In collections
1061
EMS Transport
Fire
2916
1/24/2020
473.00
Uncollectible, other
107
EMS Transport
Fire
2919
1/26/2020
375.20
Uncollectible, In collections
108
EMS Transport
Fire
882
1/27/2020 - 12/10/2021
567.00
Uncollectible, deceased
1091
EMS Transport
Fire
932
1/29/2020 - 9/19/2020
343.93
Uncollectible, In collections
110
EMS Transport
Fire
2932
1/29/2020
240.00
Uncollectible, In collections
111
EMS Transport
Fire
1544
1/31/2020
95.78
Uncollectible, deceased
1121
EMS Transport
Fire
2949
1/31/2020
536.00
Uncollectible, In collections
113
EMS Transport
Fire
2941
2/2/2020
538.00
Uncollectible, In collections
1141
EMS Transport
Fire
3171
2/2/2020
0.01
Small insurance balance
115
EMS Transport
Fire
2937
2/2/2020
575.00
Uncollectible, In collections
116
EMS Transport
Fire
579
2/3/2020
94.56
Uncollectible, In collections
1171
EMS Transport
Fire
2792
2/3/2020
469.00
Uncollectible, other
118
EMS Transport
Fire
2936
2/4/2020
469.00
Uncollectible, In collections
119
EMS Transport
Fire
2943
2/10/2020
530.00
Uncollectible, other
1201
EMS Transport
Fire
2971
2/11/2020
305.43
Uncollectible, In collections
121
EMS Transport
Fire
2952
2/15/2020
536.00
Uncollectible, other
122
EMS Transport
Fire
2960
2/16/2020
359.00
Uncollectible, In collections
1231
EMS Transport
Fire
958
2/17/2020 - 3/30/2020
175.17
Uncollectible, In collections
124
EMS Transport
Fire
2958
2/18/2020
25.00
Uncollectible, In collections
125
EMS Transport
Fire
3038
2/20/2020
527.00
Uncollectible, In collections
1261
EMS Transport
Fire
2967
2/23/2020
150.00
Uncollectible, In collections
127
EMS Transport
Fire
2025
2/23/2020
533.00
Uncollectible, other
129
EMS Transport
Fire
2975
2/27/2020
118.48
Uncollectible, other
1311
EMS Transport
Fire
3003
3/3/2020
91.20
Uncollectible, other
132
EMS Transport
Fire
1925
3/3/2020
0.01
Small insurance balance
133
EMS Transport
Fire
2983
3/14/2020
0.01
Small insurance balance
134
EMS Transport
Fire
3033
5/8/2020
0.51
Small insurance balance
Page 146 of 537
Agenda Item #15. Village of Tequesta
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
135
EMS Transport
Fire
3048
6/2/2020
53.10
Uncollectible, In collections
136
EMS Transport
Fire
3209
2/27/2020
629.00
Uncollectible, In collections
1371
EMS Transport
Fire
3029
2/28/2020
590.00
Uncollectible, other
138
EMS Transport
Fire
3003
3/3/2020
91.20
Uncollectible, other
1391
EMS Transport
Fire
2994
3/10/2020
191.40
Uncollectible, In collections
140
EMS Transport
Fire
2991
3/11/2020
465.00
Uncollectible, In collections
141
EMS Transport
Fire
2988
3/14/2020
161.15
Uncollectible, In collections
1421
EMS Transport
Fire
1249
3/17/2020
96.08
Uncollectible, In collections
143
EMS Transport
Fire
2989
3/17/2020
534.00
Uncollectible, In collections
144
EMS Transport
Fire
2990
3/17/2020
530.00
Uncollectible, In collections
1451
EMS Transport
Fire
3000
3/18/2020
537.00
Uncollectible, In collections
146
EMS Transport
Fire
2995
3/19/2020
528.00
Uncollectible, In collections
147
EMS Transport
Fire
2172
3/20/2020 - 3/2/2021
720.00
Uncollectible, deceased
1481
EMS Transport
Fire
3018
3/24/2020
540.00
Uncollectible, In collections
149
EMS Transport
Fire
3008
3/24/2020 - 6/4/2020
445.00
Uncollectible, In collections
150
EMS Transport
Fire
1663
3/31/2020 - 12/18/2020
1200.00
Uncollectible, other
1511
EMS Transport
Fire
3012
4/2/2020
464.00
Uncollectible, In collections
152
EMS Transport
Fire
2900
4/7/2020
471.00
Uncollectible, other
153
EMS Transport
Fire
3020
4/10/2020
466.00
Uncollectible, other
1541
EMS Transport
Fire
3206
4/10/2020
528.00
Uncollectible, In collections
155
EMS Transport
Fire
3010
4/11/2020
472.00
Uncollectible, In collections
1561
EMS Transport
Fire
70
4/12/2020
734.00
Uncollectible, other
157
EMS Transport
Fire
179
4/13/2020 - 12/14/2020
958.00
Uncollectible, deceased
158
EMS Transport
Fire
3204
4/13/2020
55.66
Uncollectible, In collections
1591
EMS Transport
Fire
3026
4/15/2020
463.00
Uncollectible, In collections
160
EMS Transport
Fire
3023
4/15/2020
528.00
Uncollectible, In collections
1611
EMS Transport
Fire
2308
4/15/2020
538.00
Uncollectible, other
162
EMS Transport
Fire
3021
4/17/2020
545.00
Uncollectible, other
163
EMS Transport
Fire
2711
4/18/2020 - 6/8/2021
330.00
Uncollectible, In collections
1641
EMS Transport
Fire
2747
4/18/2020
95.78
Uncollectible, deceased
165
EMS Transport
Fire
3024
4/18/2020
547.00
Uncollectible, other
1661
EMS Transport
Fire
3030
4/20/2020
544.00
Uncollectible, other
167
EMS Transport
Fire
3031
4/20/2020
555.00
Uncollectible, other
168
EMS Transport
Fire
619
4/23/2020
471.00
Uncollectible, other
1691
EMS Transport
Fire
3059
4/24/2020
306.38
Uncollectible, In collections
170
EMS Transport
Fire
3080
4/25/2020
530.00
Uncollectible, In collections
171
EMS Transport
Fire
3084
4/28/2020
270.00
Uncollectible, deceased
1721
EMS Transport
Fire
3200
4/29/2020
528.00
Uncollectible, In collections
173
EMS Transport
Fire
3199
4/29/2020
531.00
Uncollectible, other
174
EMS Transport
Fire
3098
4/29/2020
93.20
Uncollectible, In collections
1751
EMS Transport
Fire
3053
5/3/2020
729.00
Uncollectible, In collections
176
EMS Transport
Fire
1001
5/9/2020
531.00
Uncollectible, other
177
EMS Transport
Fire
3057
5/12/2020
531.00
Uncollectible, Indigent
1781
EMS Transport
I Fire
1 3082
5/13/2020
240.00
Uncollectible, In collections
Page 147 of 537
Agenda Item #15. Village of Tequesta
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
179
EMS Transport
Fire
3035
5/14/2020
469.00
Uncollectible, other
180
EMS Transport
Fire
3032
5/14/2020
435.00
Uncollectible, In collections
1811
EMS Transport
Fire
3087
5/15/2020
536.00
Uncollectible, In collections
182
EMS Transport
Fire
3079
5/17/2020 - 8/10/2020
241.09
Uncollectible, In collections
1831
EMS Transport
Fire
3149
5/19/2020
468.00
Uncollectible, In collections
184
EMS Transport
Fire
2527
5/19/2020 - 3/1/2021
1619.20
Uncollectible, In collections
185
EMS Transport
Fire
3145
5/20/2020
478.00
Uncollectible, In collections
1861
EMS Transport
Fire
3040
5/20/2020
225.00
Uncollectible, In collections
187
EMS Transport
Fire
3049
5/21/2020
528.00
Uncollectible, In collections
188
EMS Transport
Fire
3142
5/22/2020
277.72
Uncollectible, In collections
1891
EMS Transport
Fire
426
5/23/2020
469.00
Uncollectible, other
190
EMS Transport
Fire
3055
5/24/2020
571.00
Uncollectible, In collections
191
EMS Transport
Fire
3119
5/28/2020
95.01
Uncollectible, deceased
1921
EMS Transport
Fire
3091
5/30/2020
204.24
Uncollectible, In collections
193
EMS Transport
Fire
3177
5/31/2020
0.55
Small insurance balance
194
EMS Transport
Fire
3042
6/1/2020
532.00
Uncollectible, In collections
1951
EMS Transport
Fire
3044
6/2/2020
530.00
Uncollectible, In collections
196
EMS Transport
Fire
3054
6/2/2020
58.53
Uncollectible, In collections
197
EMS Transport
Fire
3048
6/2/2020
53.10
Uncollectible, In collections
1981
EMS Transport
Fire
3051
6/2/2020
57.81
Uncollectible, In collections
199
EMS Transport
Fire
3046
6/4/2020 - 6/21/2020
540.00
Uncollectible, In collections
200
EMS Transport
Fire
1819
6/8/2020
94.86
Uncollectible, In collections
2011
EMS Transport
Fire
1064
6/8/2020
465.00
Uncollectible, other
202
EMS Transport
Fire
3064
6/11/2020
95.93
Uncollectible, In collections
203
EMS Transport
Fire
2554
6/13/2020 - 8/30/2020
193.07
Uncollectible, deceased
2041
EMS Transport
Fire
3207
6/15/2020
240.00
Uncollectible, In collections
205
EMS Transport
Fire
2365
6/16/2020
96.84
Uncollectible, other
2061
EMS Transport
Fire
3097
6/18/2020
373.00
Uncollectible, In collections
207
EMS Transport
Fire
3093
6/24/2020
94.56
Uncollectible, In collections
208
EMS Transport
Fire
3089
6/26/2020
532.00
Uncollectible, In collections
209
EMS Transport
Fire
2827
6/28/2020
240.00
Uncollectible, In collections
210
EMS Transport
Fire
3085
6/29/2020
81.53
Uncollectible, In collections
2111
EMS Transport
Fire
3102
6/29/2020
240.00
Uncollectible, deceased
212
EMS Transport
Fire
3075
7/4/2020
157.02
Uncollectible, In collections
213
EMS Transport
Fire
3144
7/6/2020
240.00
Uncollectible, In collections
2141
EMS Transport
Fire
1387
7/6/2020
250.00
Uncollectible, In collections
215
EMS Transport
Fire
3109
7/9/2020
530.00
Uncollectible, In collections
216
EMS Transport
Fire
3094
7/14/2020
524.31
Uncollectible, deceased
2171
EMS Transport
Fire
3111
7/15/2020
524.00
Uncollectible, In collections
218
EMS Transport
Fire
209
7/16/2020
95.78
Uncollectible, other
219
EMS Transport
Fire
2040
7/23/2020
93.80
Uncollectible, In collections
2201
EMS Transport
Fire
3172
7/24/2020
532.00
Uncollectible, In collections
221
EMS Transport
Fire
3113
7/27/2020
467.00
Uncollectible, In collections
2221
EMS Transport
I Fire
1 2590
7/31/2020 - 5/3/2021
1 648.06
Uncollectible, deceased
Page 148 of 537
Agenda Item #15. Village of Tequesta
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
223
EMS Transport
Fire
1414
8/1/2020
94.10
Uncollectible, other
224
EMS Transport
Fire
3107
8/2/2020
529.00
Uncollectible, In collections
2251
EMS Transport
Fire
3123
8/3/2020
107.20
Uncollectible, In collections
226
EMS Transport
Fire
3122
8/3/2020
240.00
Uncollectible, deceased
227
EMS Transport
Fire
3127
8/6/2020
540.00
Uncollectible, other
2281
EMS Transport
Fire
3137
8/10/2020
652.00
Uncollectible, In collections
229
EMS Transport
Fire
1546
8/13/2020
250.00
Uncollectible, deceased
2301
EMS Transport
Fire
2719
8/15/2020 - 10/31/2020
450.00
Uncollectible, In collections
231
EMS Transport
Fire
3152
8/15/2020
150.00
Uncollectible, In collections
232
EMS Transport
Fire
3151
8/15/2020
58.53
Uncollectible, In collections
2331
EMS Transport
Fire
3154
8/19/2020
240.00
Uncollectible, deceased
234
EMS Transport
Fire
3165
8/24/2020
471.00
Uncollectible, In collections
235
EMS Transport
Fire
2752
8/26/2020 - 3/13/2021
4007.40
Uncollectible, deceased
2361
EMS Transport
Fire
1817
8/27/2020
240.00
Uncollectible, In collections
237
EMS Transport
Fire
3161
8/28/2020
532.00
Uncollectible, In collections
238
EMS Transport
Fire
3160
8/28/2020
107.20
Uncollectible, In collections
2391
EMS Transport
Fire
3159
8/30/2020
164.94
Uncollectible, In collections
240
EMS Transport
Fire
2483
9/3/2020
96.08
Uncollectible, In collections
2411
EMS Transport
Fire
3157
9/4/2020
240.00
Uncollectible, In collections
242
EMS Transport
Fire
3193
9/4/2020
105.80
Uncollectible, In collections
243
EMS Transport
Fire
3170
9/6/2020
526.00
Uncollectible, In collections
2441
EMS Transport
Fire
3169
9/6/2020
587.80
Uncollectible, other
245
EMS Transport
Fire
3188
9/7/2020
92.12
Uncollectible, In collections
246
EMS Transport
Fire
3187
9/7/2020
96.80
Uncollectible, In collections
2471
EMS Transport
Fire
3214
9/10/2020
471.00
Uncollectible, other
248
EMS Transport
Fire
1452
9/11/2020
95.93
Uncollectible, In collections
249
EMS Transport
Fire
2049
9/11/2020
710.80
Uncollectible, deceased
2501
EMS Transport
Fire
3174
9/17/2020
714.40
Uncollectible, In collections
251
EMS Transport
Fire
3182
9/18/2020
240.00
Uncollectible, In collections
252
EMS Transport
Fire
3192
9/19/2020
3.25
Small insurance balance
2531
EMS Transport
Fire
3186
9/20/2020
150.00
Uncollectible, In collections
254
EMS Transport
Fire
2205
9/21/2020
240.00
Uncollectible, deceased
255
EMS Transport
Fire
3181
9/22/2020
330.08
Uncollectible, In collections
2561
EMS Transport
Fire
3196
9/22/2020
649.60
Uncollectible, In collections
257
EMS Transport
Fire
3198
9/27/2020 - 9/29/2020
1407.20
Uncollectible, In collections
258
EMS Transport
Fire
1 3215
9/29/2020
703.60
Uncollectible, In collections
2591
EMS Transport
Fire
3201
9/30/2020 - 12/31/2020
177.31
Uncollectible, In collections
(TOTAL: I $122,680.51�
Page 149 of 537
Agenda Item #15. Village of Tequesta
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
SUMMARY - Explanations
Explanations for Write-offs
Write-off Balance
Small insurance balance
11.60
Uncollectible, deceased
21,172.51
Uncollectible, In collections
69,501.55
Uncollectible, Indigent
1,002.00
Uncollectible, other
30,992.85
Grand Total
122, 680.51
SUMMARY - Dates of Service
ig Service Dates for Write-offs
r
Write-off Balance
or to FY 2019/20
22,225.12
FY 2019/20
100,455.39
Grand Total
122, 680.51
***
*** Generally the "uncollectible, other" are claims that were not paid by the insurance for
one reason or another and have since gone beyond appeal timeframes. Small insurance
balances occur when the insurance inexplicably pays just under the full allowable amount.
Page 150 of 537