Bad debt provision: what we actually collect on financed sales
Of every dollar financed (sale minus deposit), how much comes in over time, split by the deposit taken up front, by year sold, kids v adults and city, and the provision that follows. As at 2026-11-17 (newest payment on the CRM schedules). 62,267 agreements since 2019.
Provision on Q3 2026 (Jul–Sep) financed
$3,594,868 57.9%
Mike's P&L calculated bad debt
$3,275,538 52.7%
Difference
+$319,330
Collected by month 12, 2024 v 2025
45.1% → 40.3%
Provision by deposit
66% under 15% · 27% 50%+
Provision rate by deposit % of sale
Collection has mostly stopped by about month 24. The rate starts from what 2024 sales have collected to date (the latest year that has mostly played out; it ties to the “Collected to date” column elsewhere on this page), then takes off the slip 2025 shows against 2024 at month 12 in the same band. Provision = 100% minus what we expect to collect. Applied to the money financed in Q3 2026 (Jul–Sep).
Deposit % of sale
2024 collected to date
2024 by m12
2025 by m12
Slip (pts)
Expect to collect
Provision
Q3 2026 (Jul–Sep) financed
Provision $
Under 15%
37.3%
32.9%
29.6%
−3.3
34.0%
66%
$3,746,402
$2,477,67560.3% of Q3
15–20%
50.6%
45.6%
42.0%
−3.6
47.0%
53%
$838,134
$447,44113.5% of Q3
20–30%
57.3%
52.5%
48.7%
−3.8
53.5%
47%
$1,109,430
$507,58817.9% of Q3
30–50%
69.6%
65.4%
61.3%
−4.1
65.5%
34%
$316,498
$109,0505.1% of Q3
50% or more
79.2%
76.9%
71.0%
−5.9
73.3%
27%
$200,984
$53,1143.2% of Q3
TOTAL
57.9%
$6,211,447
$3,594,868
60% of the money financed in Q3 2026 (Jul–Sep) had a deposit under 15% of the sale, the band that loses the most. That is why a flat 50–55% comes out low. 2025 sales are still young, so if they keep slipping after month 12 these rates are too kind; re-check once 2025 reaches month 18–24.
What to book against today’s balance
The provision above is everything not expected to be collected of the money financed, credits included. Q3 2026 (Jul–Sep) sales already carry $311,649 of credits, which are already off the balance. The allowance to book against today’s balance of $5,168,537 is $3,283,219 (63.5% of it). Elena’s per-contract sheet, which works on the balance the same way, comes to $3,091,384.
The same rates on recent quarters
Quarter sold
Agreements
Financed
Deposit under 15%
Provision %
Provision $
Q1 2025
2,800
$5,908,070
40.5%
54.4%
$3,214,585
Q2 2025
2,797
$5,956,754
43.0%
54.7%
$3,256,631
Q3 2025
2,738
$5,611,087
47.0%
55.6%
$3,122,093
Q4 2025
2,638
$5,503,829
51.7%
56.4%
$3,105,654
Q1 2026
2,782
$6,341,610
59.1%
57.8%
$3,666,812
Q2 2026
2,835
$6,334,161
57.4%
57.3%
$3,631,107
Q3 2026
2,766
$6,211,447
60.3%
57.9%
$3,594,868
The provision % moves with the deposit mix: a quarter with more low-deposit sales needs a bigger provision on the same rates.
With and without Monterey
Money Monterey collects on accounts we send them is keyed back into the CRM as “Paid to Monterey”, so the rates above count it as collected. It is 0.94% of the money financed to date in the under-15% band. Counting only what we collect ourselves, the Q3 2026 (Jul–Sep) provision is $3,649,392 (58.8%) instead of $3,594,868: $54,524 more.
Deposit % of sale
2024 collected to date
of which Monterey
Without Monterey
Provision with Monterey
Without Monterey
Q3 2026 (Jul–Sep) $ with
Q3 2026 (Jul–Sep) $ without
Difference
Under 15%
37.3%
0.94%
36.4%
66%
67%
$2,477,675
$2,511,078
+$33,403
15–20%
50.6%
1.19%
49.4%
53%
54%
$447,441
$454,492
+$7,050
20–30%
57.3%
0.99%
56.3%
47%
47%
$507,588
$517,511
+$9,924
30–50%
69.6%
0.78%
68.8%
34%
35%
$109,050
$111,514
+$2,464
50% or more
79.2%
0.23%
79.0%
27%
27%
$53,114
$54,797
+$1,683
TOTAL
57.9%
58.8%
$3,594,868
$3,649,392
+$54,524
Whether “Paid to Monterey” is what they collected before or after their fee is not known. If it is before the fee, the “with Monterey” figures count Monterey’s cut as ours, and the true provision sits a little above the “with” column. The rate used above stays the “with” one.
Q3 2026 (Jul–Sep): by city, against Mike’s P&L
Mike’s figure is a flat rate per city times “Total financed”. Ours applies the deposit-band rates to each agreement, adjusted for how well that city collects (below). Financed totals are shown side by side as the check that both count the same money. Only $9,699 was actually written off in the Q3 books.
City
Financed (CRM)
Financed (Mike)
Deposit under 15%
Mike rate
Mike $
Our rate
Our $
Difference
Florida
$1,588,719
$1,584,419
59%
50.0%
$792,210
57.4%
$911,654
+$119,445
Texas
$1,658,940
$1,661,390
65%
55.0%
$913,765
61.0%
$1,012,352
+$98,588
Boston
$746,545
$746,595
56%
48.5%
$362,099
54.9%
$409,724
+$47,625
Chicago
$759,036
$759,435
53%
55.0%
$417,689
59.0%
$447,503
+$29,814
New York
$837,938
$838,138
61%
53.5%
$448,404
56.8%
$476,072
+$27,668
Nashville
$620,269
$620,676
62%
55.0%
$341,372
54.4%
$337,563
−$3,809
TOTAL
$6,211,447
$6,210,653
60%
52.7%
$3,275,538
57.9%
$3,594,868
+$319,330
City adjustment
Each city’s own collection against what the company deposit-band rates predict for that city’s own deposit mix. The difference is added to every band’s expected collection in that city, so a city that has always collected better than its mix gets a smaller provision, and one that collects worse gets a bigger one.
City
Measured on
Agreements
Actually collected
Band rates predict for its mix
Adjustment (pts)
Provision Under 15%
Provision 15–20%
Provision 20–30%
Provision 30–50%
Provision 50% or more
Florida
2024 sales, to date
1,329
53.2%
53.3%
−0.1
66%
53%
47%
34%
27%
Texas
2024 sales, to date
3,173
49.4%
51.5%
−2.2
68%
55%
49%
36%
29%
Boston
2024 sales, to date
1,222
59.5%
57.3%
+2.2
64%
51%
45%
32%
25%
Chicago
2025 sales at month 12
417
39.7%
41.8%
−2.1
68%
55%
49%
36%
29%
New York
2024 sales, to date
3,056
50.0%
49.2%
+0.8
65%
52%
46%
33%
26%
Nashville
2024 sales, to date
450
53.3%
49.1%
+4.2
62%
49%
43%
30%
23%
Florida includes Orlando (Mike’s Florida LLC covers both; Orlando is too young to measure on its own); Texas is Dallas + Houston. Chicago has no 2024 sales, so it is measured at month 12 on 2025 sales against the 2025 band rates at month 12.
Each city’s own collection, 2024 and 2025 sales
Group
Agreements
Financed
m1
m3
m6
m9
m12
m18
m24
m36
m48
Collected to date
of which Monterey
Credited / written off
Still owed
Florida · 2024
1,329
$2.65M
4.4
16.5
30.1
40.6
48.2
51.6
52.6
53.2%
1.31%
9.9%
37.0%
Florida · 2025
1,440
$3.29M
2.4
14.1
27.0
37.7
44.5
48.5
47.3%
0.20%
7.5%
45.2%
Texas · 2024
3,173
$6.17M
3.6
15.4
28.5
38.5
44.6
48.1
49.5
49.4%
0.98%
7.7%
42.9%
Texas · 2025
3,356
$7.22M
3.1
13.0
23.1
31.4
36.6
40.4
38.8%
0.26%
5.5%
55.7%
Boston · 2024
1,222
$2.20M
5.2
20.5
36.9
48.4
55.3
58.7
59.8
59.5%
0.72%
9.1%
31.4%
Boston · 2025
1,326
$2.47M
3.6
15.6
30.2
41.8
49.1
50.5
52.4%
0.46%
6.2%
41.5%
Chicago · 2025
589
$1.21M
1.7
12.1
25.2
35.0
39.7
42.0%
0.25%
4.1%
53.8%
New York · 2024
3,056
$6.34M
3.7
14.8
28.0
38.5
45.3
48.9
49.8
50.0%
0.99%
8.4%
41.6%
New York · 2025
2,848
$5.95M
3.2
12.9
23.8
32.7
38.7
44.2
41.3%
0.42%
6.7%
52.0%
Nashville · 2024
450
$0.88M
3.7
17.2
32.9
43.7
49.8
52.3
52.3
53.3%
0.74%
5.5%
41.3%
Nashville · 2025
1,414
$2.84M
3.4
13.9
25.5
35.0
41.0
45.3
42.9%
0.22%
5.2%
51.9%
Is it getting better or worse?
Worse. By month 12, 2025 sales had collected 40.3% of the money financed, against 45.1% for 2024: down 4.8 points. On 2024’s deposit mix 2025 would read 43.1%, so 2.7 points is the mix (more sales on small deposits) and 2.0 points is people paying less in the same band.
By year sold
Group
Agreements
Financed
m1
m3
m6
m9
m12
m18
m24
m36
m48
Collected to date
of which Monterey
Credited / written off
Still owed
2019
2,463
$3.32M
14.6
30.8
44.2
51.1
55.5
58.2
59.3
59.8
59.8
59.9%
0.07%
14.9%
25.2%
2020
3,048
$5.63M
14.5
31.1
44.9
51.2
54.5
56.6
57.2
57.6
58.0
58.3%
0.77%
18.7%
23.1%
2021
7,321
$17.57M
9.7
23.5
35.0
41.1
44.4
46.7
47.3
47.7
47.9
48.1%
1.24%
27.3%
24.6%
2022
8,148
$19.90M
8.5
20.9
30.8
36.6
40.0
41.7
42.1
42.4
42.5
42.6%
1.11%
32.4%
25.1%
2023
9,641
$20.47M
7.6
20.1
31.4
38.5
43.3
46.0
46.5
46.4
46.9%
1.03%
24.0%
29.1%
2024
11,042
$21.30M
4.0
15.7
28.8
38.7
45.1
48.5
49.2
49.6%
0.99%
8.4%
42.0%
2025
10,973
$22.98M
3.0
13.5
25.0
34.4
40.3
44.6
42.8%
0.31%
6.1%
51.1%
2026
9,631
$21.52M
2.8
12.0
22.3
34.1
18.9%
0.02%
4.7%
76.4%
By half-year, 2023 on
Group
Agreements
Financed
m1
m3
m6
m9
m12
m18
m24
m36
m48
Collected to date
of which Monterey
Credited / written off
Still owed
2023 H1
4,676
$10.70M
8.6
21.1
31.4
37.6
42.0
44.3
44.9
45.3
45.4%
1.05%
27.0%
27.7%
2023 H2
4,965
$9.77M
6.4
18.9
31.4
39.5
44.8
47.8
48.3
48.0
48.6%
1.00%
20.7%
30.7%
2024 H1
5,707
$11.06M
4.4
15.7
28.0
37.5
44.3
48.1
48.7
49.2%
1.03%
9.1%
41.8%
2024 H2
5,335
$10.24M
3.6
15.7
29.8
40.1
45.9
49.0
50.0
50.2%
0.95%
7.7%
42.2%
2025 H1
5,597
$11.86M
3.3
14.1
25.3
34.6
40.5
44.6
44.4%
0.47%
7.1%
48.4%
2025 H2
5,376
$11.11M
2.8
12.8
24.8
34.1
40.1
41.0%
0.14%
4.9%
54.1%
2026 H1
5,617
$12.68M
3.0
12.2
22.3
34.1
26.0%
0.03%
4.9%
69.1%
2026 H2
4,014
$8.84M
2.3
11.4
8.7%
0.00%
4.4%
86.9%
Faded cells: fewer than three-quarters of that group’s money has reached that age yet, so the figure rests on its oldest sales only. The fall at month 6 is bigger than at month 12 partly because plans got longer (more 12-payment plans, smaller instalments), which spreads the same money out; compare years at month 12 or later.
2026 so far v the same months of earlier years
Every cell compares the same calendar months at the same age. At m1 that is every 2026 month that has had a full month since it ended; by m9 only the oldest months qualify, and the earlier years are cut to those same months. The row “on 2025’s deposit mix” is 2026 re-weighted to last year’s deposit bands: the gap between it and 2026 is the deposit mix, the gap between it and 2025 is people paying differently.
Sold in
m1
m3
m6
m9
2024
4.0
15.5
27.2
36.1
2025
3.1
13.8
26.6
40.9
2026
2.9
12.1
22.4
35.4
2026 on 2025’s deposit mix
3.1
12.8
23.9
38.0
2026 v 2025 (points)
-0.2
-1.7
-4.2
-5.5
Months counted
Jan–Sep
Jan–Jul
Jan–Apr
Jan
Adults only (kids taken out of every year)
Sold in
m1
m3
m6
m9
2024 adults
4.0
15.5
27.2
36.1
2025 adults
3.1
13.8
26.6
40.9
2026 adults
2.8
12.1
22.4
35.3
By deposit band, 2025 v 2026
Sold in
m1
m3
m6
m9
Under 15% · 2025
2.4
10.2
19.1
30.2
Under 15% · 2026
2.3
9.9
18.2
28.6
15–20% · 2025
2.9
14.0
27.4
45.5
15–20% · 2026
2.3
11.5
22.6
33.5
20–30% · 2025
3.4
16.0
31.4
43.6
20–30% · 2026
4.0
15.8
29.0
44.7
30–50% · 2025
6.0
23.8
41.1
62.9
30–50% · 2026
5.0
18.6
34.0
58.6
50% or more · 2025
7.7
27.5
50.6
68.5
50% or more · 2026
6.3
22.1
41.2
68.8
Provision on Jan–Oct sales, same deposit-band rates
Year
Agreements
Financed
Deposit under 15%
Provision %
Provision $
2024
9,489
$18,042,902
28.0%
52.1%
$9,401,590
2025
9,231
$19,277,327
43.5%
54.9%
$10,586,592
2026
9,229
$20,676,450
58.3%
57.5%
$11,891,638
The last 4 months (Jul–Oct 2026) v the same 4 months before
The newest sales, so only the early stages exist: m1 counts the months that have had a full month since they ended, m3 only the oldest. The months used are in the bottom row of the first table.
Sold in
m1
m3
2024
3.3
14.2
2025
2.7
12.0
2026
2.6
11.6
2026 on 2025’s deposit mix
2.9
12.9
2026 v 2025 (points)
-0.2
-0.5
Months counted
Jul–Sep
Jul
Adults only (kids taken out of every year)
Sold in
m1
m3
2024 adults
3.3
14.2
2025 adults
2.7
12.0
2026 adults
2.3
11.0
By deposit band, 2025 v 2026
Sold in
m1
m3
Under 15% · 2025
2.2
9.1
Under 15% · 2026
1.8
9.4
15–20% · 2025
2.3
11.9
15–20% · 2026
2.0
9.5
20–30% · 2025
3.1
13.5
20–30% · 2026
4.6
17.5
30–50% · 2025
5.3
21.8
30–50% · 2026
4.1
19.8
50% or more · 2025
6.9
26.7
50% or more · 2026
6.8
23.4
Provision on Jul–Oct sales, same deposit-band rates
Year
Agreements
Financed
Deposit under 15%
Provision %
Provision $
2024
3,782
$6,987,539
27.3%
52.0%
$3,634,604
2025
3,634
$7,412,503
46.3%
55.5%
$4,115,376
2026
3,612
$8,000,679
58.5%
57.4%
$4,593,719
Deposit % of sale: sales from 2022 to 2024
The bigger the deposit as a share of the sale, the more of the rest gets paid. The deposit is chosen by the customer, so it marks who could pay; it sorts a sale into its group for the provision, but asking for a bigger deposit does not by itself buy the better rate.
Group
Agreements
Financed
m1
m3
m6
m9
m12
m18
m24
m36
m48
Collected to date
of which Monterey
Credited / written off
Still owed
Under 10%
264
$0.82M
6.7
11.7
14.8
17.5
19.3
20.1
20.5
21.1
22.4
20.6%
0.10%
59.4%
20.0%
10–15%
10,952
$30.18M
4.6
14.4
23.6
29.9
34.0
36.5
37.1
37.5
36.8
37.5%
1.02%
26.8%
35.6%
15–20%
4,944
$9.27M
5.8
17.8
29.8
38.4
43.6
46.6
47.1
46.7
44.3
47.8%
1.24%
17.7%
34.5%
20–30%
8,856
$16.86M
7.8
22.3
36.7
46.6
52.7
55.7
56.2
58.2
55.7
56.7%
1.07%
13.6%
29.7%
30–50%
2,408
$3.02M
14.0
33.4
49.8
58.5
64.2
66.3
67.0
67.0
66.4
67.1%
0.82%
13.9%
19.0%
50% or more
1,407
$1.51M
25.2
51.2
64.7
71.2
74.1
74.9
74.7
74.8
73.4
75.8%
0.91%
11.8%
12.5%
Same bands, year by year (m6 / m12 / m24)
Deposit % of sale
2022 m6
2022 m12
2022 m24
2023 m6
2023 m12
2023 m24
2024 m6
2024 m12
2024 m24
2025 m6
2025 m12
2025 m24
2026 m6
2026 m12
2026 m24
Under 15%
24.4
33.5
35.8
24.1
34.7
38.0
20.0
31.9
35.7
18.6
29.6
17.8
15–20%
30.9
41.3
43.7
33.0
45.9
49.7
27.0
43.6
47.5
26.1
42.0
22.7
20–30%
44.5
54.1
55.9
40.6
55.6
58.9
32.1
50.9
54.9
30.2
48.7
29.3
30–50%
57.7
65.2
66.2
52.9
65.8
68.1
42.5
62.1
66.3
38.1
61.3
33.1
50% or more
69.2
71.9
71.9
66.9
76.2
77.4
58.8
74.0
74.7
46.2
71.0
41.5
Share of the money financed in each band
Year sold
Under 15%
15–20%
20–30%
30–50%
50% or more
Financed
2022
64.7%
12.6%
16.8%
3.5%
2.4%
$19.90M
2023
57.8%
13.4%
21.0%
5.4%
2.5%
$20.47M
2024
29.6%
18.9%
43.3%
5.8%
2.5%
$21.30M
2025
45.4%
17.5%
29.5%
4.8%
2.8%
$22.98M
2026
58.4%
13.4%
19.4%
5.4%
3.5%
$21.52M
Under-15% deposits went from about a third of the money financed in 2024 to well over half in 2026. That drift alone lowers what the book collects, even if nobody in a band pays any worse.
Kids v adults
Kids only became a real line of sales in 2026-04; the oldest kids agreement is 8 months old. So there is no lifetime figure for kids yet. Compared with adults sold in the same months, at the same age:
Group
Agreements
Financed
m1
m3
m6
m9
m12
m18
m24
m36
m48
Collected to date
of which Monterey
Credited / written off
Still owed
Kids (sold 2026-04 on)
1,881
$4.50M
3.0
12.1
20.8
13.4%
0.00%
5.2%
81.5%
Adults, same months
4,947
$10.62M
2.4
11.0
19.7
13.9%
0.00%
4.6%
81.5%
Within each deposit band
Group
Agreements
Financed
m1
m3
m6
m9
m12
m18
m24
m36
m48
Collected to date
of which Monterey
Credited / written off
Still owed
Kids · Under 15%
831
$2.46M
1.9
9.2
15.5
10.2%
0.00%
4.4%
85.4%
Adults · Under 15%
2,296
$6.32M
1.9
8.8
15.0
11.0%
0.00%
4.6%
84.4%
Kids · 15–20%
279
$0.55M
1.9
11.3
27.7
13.2%
0.00%
4.7%
82.0%
Adults · 15–20%
876
$1.48M
2.3
11.4
21.9
14.9%
0.00%
4.1%
81.0%
Kids · 20–30%
455
$1.04M
5.5
16.6
22.4
17.7%
0.00%
6.8%
75.4%
Adults · 20–30%
1,102
$1.90M
2.9
14.8
27.5
18.2%
0.00%
4.2%
77.6%
Kids · 30–50%
161
$0.25M
3.1
16.5
19.2%
0.00%
4.7%
76.1%
Adults · 30–50%
402
$0.59M
3.7
16.8
25.5
20.6%
0.00%
6.9%
72.5%
Kids · 50% or more
155
$0.21M
5.6
24.1
22.8%
0.00%
7.2%
69.9%
Adults · 50% or more
271
$0.35M
6.0
21.6
40.7
26.6%
0.00%
5.4%
68.0%
Kids = the lead code (KIDSXP/KIDSX/KDX/KPX/KX, optional R, …KIDS, …3AB), same rule as /collection-curve. On this basis (share of the money financed) kids and adults are level so far; /collection-curve shows kids ahead because it measures the whole sale including the deposit. Use the same deposit-band rates for kids until they reach month 12.
Plan length: sales from 2022 to 2024
Shorter plans collect more of the balance. Plan length moves with deposit and sale size, so it is shown for context, not as a separate provision group.
Group
Agreements
Financed
m1
m3
m6
m9
m12
m18
m24
m36
m48
Collected to date
of which Monterey
Credited / written off
Still owed
1 payment
1,725
$2.61M
30.6
42.5
47.0
49.3
50.7
51.3
51.7
51.3
49.5
51.9%
0.96%
22.8%
25.3%
2–6
6,404
$9.60M
11.5
32.4
45.8
49.5
50.8
51.6
52.0
51.3
48.3
52.3%
1.07%
21.9%
25.9%
7–10
10,224
$23.28M
4.4
15.9
28.9
38.9
44.0
46.3
46.9
44.2
41.7
47.5%
1.13%
17.7%
34.9%
11–12
10,252
$25.61M
4.4
14.0
24.1
31.8
38.1
41.8
42.2
40.4
37.8
42.9%
0.97%
24.1%
33.0%
13+
226
$0.58M
8.1
19.0
30.1
36.8
41.0
43.9
44.1
45.1
51.3
44.8%
0.69%
25.1%
30.1%
Monterey: what it adds
Accounts sent to Monterey stop being billed in Square, so Monterey money is not in the Square recurring (back-end) figures. It reaches this page only through the CRM, where it is keyed as “Paid to Monterey” (counted in collected) and Monterey settlements, bankruptcies and write-offs (counted in credited / written off). Accounts placed with Monterey that have not paid stay in still owed. All told, Monterey has brought in $980,183, 1.74% of everything collected on finance. 18,371 agreements are placed, owing $32.87M of the $54.55M still owed.
By year sold
Year sold
Agreements
Financed
Paid to Monterey (% of financed)
Monterey credits (% of financed)
Placed with Monterey (% of agreements)
Placed and still owed (% of still owed)
2019
2,463
$3.32M
$2,2230.07%
$2,3800.07%
291.2%
$0.02M1.8%
2020
3,048
$5.63M
$43,2380.77%
$22,9830.41%
53117.4%
$0.86M66.5%
2021
7,321
$17.57M
$217,0471.24%
$43,2810.25%
1,85325.3%
$3.79M87.6%
2022
8,148
$19.90M
$221,6011.11%
$54,6980.27%
2,29928.2%
$4.65M93.1%
2023
9,641
$20.47M
$210,3251.03%
$39,8520.19%
3,41435.4%
$5.76M96.7%
2024
11,042
$21.30M
$211,3400.99%
$34,5520.16%
5,55950.3%
$8.75M97.9%
2025
10,973
$22.98M
$70,9980.31%
$24,4760.11%
4,20138.3%
$7.86M66.9%
2026
9,631
$21.52M
$3,4120.02%
$3,5500.02%
4855.0%
$1.18M7.2%
Recent years show little because accounts reach Monterey a year or more after the sale, and Monterey takes time to collect.
By month, 2025 on
Month
Paid to Monterey (keyed that month)
Monterey credits
Accounts placed
2026-11part month
$0
$7,228
13
2026-10
$21,410
$9,230
365
2026-09
$30,447
$16,195
462
2026-08
$27,838
$6,482
365
2026-07
$29,495
$2,101
354
2026-06
$35,895
$4,665
284
2026-05
$30,440
$2,697
263
2026-04
$13,252
$11,780
233
2026-03
$24,428
$3,638
176
2026-02
$22,621
$2,780
165
2026-01
$17,731
$745
473
2025-12
$18,974
$1,598
538
2025-11
$12,574
$4,465
468
2025-10
$10,223
$1,894
525
2025-09
$19,937
$0
518
2025-08
$28,016
$7,250
397
2025-07
$23,826
$7,960
500
2025-06
$27,988
$1,785
443
2025-05
$19,427
$3,019
513
2025-04
$17,659
$6,303
424
2025-03
$31,319
$6,071
497
2025-02
$11,077
$8,801
377
2025-01
$17,658
$1,975
460
“Keyed that month” is the date the payment was entered in the CRM, which can lag the date Monterey took the money. Placements are the CRM collections flag’s date. Whether “Paid to Monterey” is before or after Monterey’s fee is not known.
What a deal is really worth, by the deposit taken on the day: 2024 sales
Worth = the deposit taken on the day plus everything collected on the finance since (to date, Monterey included). 2024 is the latest year whose sales have mostly played out, so these are real money, not a forecast. “Collected later per $1 of deposit” is how much more came in for every dollar taken on the day.
By deposit as a % of the sale
Deposit on the day
Deals
Avg sale
Avg deposit
Avg financed
Avg collected since
Worth per deal
Worth as % of sale
Never collected per deal
Collected later per $1 of deposit
Under 10%
38
$2,395
$65
$2,330
$274
$339
14.1%
$2,056
$4.21
10–15%
2,874
$2,452
$292
$2,160
$788
$1,080
44.0%
$1,372
$2.69
15–20%
2,012
$2,388
$388
$2,000
$967
$1,355
56.7%
$1,033
$2.49
20–30%
4,675
$2,534
$562
$1,972
$1,098
$1,660
65.5%
$874
$1.95
30–50%
951
$2,019
$730
$1,289
$857
$1,587
78.6%
$432
$1.17
50% or more
492
$2,405
$1,324
$1,081
$823
$2,147
89.3%
$258
$0.62
TOTAL financed deals
11,042
$2,435
$507
$1,929
$958
$1,464
60.1%
$971
$1.89
By deposit in dollars
Deposit on the day
Deals
Avg sale
Avg deposit
Avg financed
Avg collected since
Worth per deal
Worth as % of sale
Never collected per deal
Collected later per $1 of deposit
Under $100
617
$461
$61
$400
$147
$208
45.2%
$252
$2.40
$100–249
2,246
$905
$152
$753
$310
$461
51.0%
$444
$2.04
$250–499
3,867
$2,514
$368
$2,146
$896
$1,264
50.3%
$1,251
$2.43
$500–999
3,031
$3,318
$690
$2,628
$1,421
$2,111
63.6%
$1,208
$2.06
$1,000–1,999
1,068
$3,712
$1,166
$2,546
$1,624
$2,790
75.2%
$922
$1.39
$2,000 or more
213
$3,894
$2,150
$1,745
$1,322
$3,472
89.1%
$423
$0.62
TOTAL financed deals
11,042
$2,435
$507
$1,929
$958
$1,464
60.1%
$971
$1.89
The deposit is chosen by the customer, so a big deposit marks someone who could pay; asking for a bigger deposit does not by itself make the rest come in. 2024 sales are still paying a little, so worth will creep up slightly. Groups under 30 deals are left out.
Is a deal worth less than it used to be? Worth by month 12, % of sale
The same measure at the same age (deposit plus collected within 12 months of the shoot), so younger years can be compared fairly.
Deposit % of sale
2022
2023
2024
2025
2026
Under 10%
24.1%
21.4%
13.8%
10–15%
42.0%
43.0%
40.2%
38.0%
15–20%
50.8%
54.7%
52.7%
51.4%
20–30%
65.3%
66.0%
61.8%
60.3%
30–50%
77.9%
78.1%
75.8%
75.3%
50% or more
87.5%
89.4%
88.3%
86.7%
TOTAL
50.6%
53.9%
56.5%
52.0%
Faded: fewer than three-quarters of that group’s money has reached month 12 yet. Blank: under 30 deals.
Elena’s bad debt calculation against ours: Q3 2026 (Jul–Sep)
Elena: $3,233,987. Ours (deposit-band rates): $3,594,868. Mike’s P&L: $3,275,538. The methods differ in what the rate is applied to. Elena applies her rate to the balance still owed, so money already paid since the sale (up to four months of instalments) is taken out first. Ours applies a rate to the whole amount financed, and that rate already allows for those early payments. To compare like with like, both are shown as a % of the money financed.
Group
Financed (CRM)
Still owed today (CRM)
Balance Elena used
Elena rate (on balance)
Elena $ (% of financed)
Ours $ (% of financed)
Ours v Elena
Studio 1 (Florida)
$562,399
$461,027
$488,045
56.8%
$277,06149.3%
$315,87156.2%
+$38,810
Orlando
$1,026,320
$855,565
$911,295
54.7%
$498,55748.6%
$595,78358.1%
+$97,226
Dallas
$682,735
$565,234
$593,051
67.7%
$401,74558.8%
$397,66258.2%
−$4,083
Houston
$976,205
$812,327
$853,440
62.1%
$529,78254.3%
$614,69063.0%
+$84,908
Boston
$746,545
$612,529
$648,713
52.1%
$338,25345.3%
$409,72454.9%
+$71,471
Chicago
$759,036
$642,178
$668,004
60.2%
$402,42153.0%
$447,50359.0%
+$45,082
New York
$837,938
$690,454
$713,458
64.2%
$457,76654.6%
$476,07256.8%
+$18,306
Nashville
$620,269
$529,222
$562,851
58.3%
$328,40352.9%
$337,56354.4%
+$9,160
TOTAL
$6,211,447
$5,168,537
$5,438,857
59.5%
$3,233,98752.1%
$3,594,86857.9%
+$360,881
By month sold
Group
Financed (CRM)
Still owed today (CRM)
Balance Elena used
Elena rate (on balance)
Elena $ (% of financed)
Ours $ (% of financed)
Ours v Elena
Jul 2026
$2,246,882
$1,783,921
$1,859,377
62.7%
$1,166,40951.9%
$1,315,57958.6%
+$149,171
Aug 2026
$2,187,800
$1,812,864
$1,908,923
59.3%
$1,132,33551.8%
$1,260,08457.6%
+$127,749
Sep 2026
$1,776,766
$1,571,752
$1,670,558
56.0%
$935,24352.6%
$1,019,20457.4%
+$83,961
TOTAL
$6,211,447
$5,168,537
$5,438,857
59.5%
$3,233,98752.1%
$3,594,86857.9%
+$360,881
Every city and month
Group
Financed (CRM)
Still owed today (CRM)
Balance Elena used
Elena rate (on balance)
Elena $ (% of financed)
Ours $ (% of financed)
Ours v Elena
Studio 1 · Jul
$233,920
$187,011
$194,828
59.7%
$116,31249.7%
$131,64756.3%
+$15,335
Studio 1 · Aug
$164,130
$133,692
$139,730
59.9%
$83,69851.0%
$90,73655.3%
+$7,037
Studio 1 · Sep
$164,349
$140,324
$153,487
50.2%
$77,05146.9%
$93,48956.9%
+$16,438
Orlando · Jul
$375,560
$297,386
$312,600
57.1%
$178,49547.5%
$223,82659.6%
+$45,331
Orlando · Aug
$390,288
$320,932
$345,657
55.7%
$192,53149.3%
$221,24156.7%
+$28,710
Orlando · Sep
$260,472
$237,247
$253,037
50.4%
$127,53149.0%
$150,71657.9%
+$23,186
Dallas · Jul
$246,552
$180,900
$189,806
67.1%
$127,36051.7%
$143,68858.3%
+$16,328
Dallas · Aug
$216,217
$187,407
$195,726
70.0%
$137,00863.4%
$125,68158.1%
−$11,327
Dallas · Sep
$219,967
$196,928
$207,518
66.2%
$137,37762.5%
$128,29458.3%
−$9,083
Houston · Jul
$337,955
$268,483
$285,855
67.6%
$193,23857.2%
$217,00164.2%
+$23,764
Houston · Aug
$326,810
$263,515
$278,075
59.6%
$165,73250.7%
$208,27563.7%
+$42,543
Houston · Sep
$311,440
$280,330
$289,511
59.0%
$170,81154.8%
$189,41360.8%
+$18,602
Boston · Jul
$266,800
$208,821
$219,316
60.0%
$131,58949.3%
$150,76156.5%
+$19,172
Boston · Aug
$292,260
$238,266
$253,551
51.2%
$129,81844.4%
$155,97153.4%
+$26,153
Boston · Sep
$187,485
$165,442
$175,847
43.7%
$76,84541.0%
$102,99154.9%
+$26,146
Chicago · Jul
$248,314
$200,293
$203,078
63.5%
$128,95551.9%
$149,71760.3%
+$20,762
Chicago · Aug
$275,147
$230,651
$237,754
57.5%
$136,70949.7%
$158,29557.5%
+$21,586
Chicago · Sep
$235,575
$211,234
$227,172
60.2%
$136,75858.1%
$139,49259.2%
+$2,734
New York · Jul
$329,892
$271,712
$274,600
66.6%
$182,88455.4%
$186,32556.5%
+$3,441
New York · Aug
$309,363
$255,473
$264,964
64.3%
$170,37255.1%
$180,32858.3%
+$9,957
New York · Sep
$198,683
$163,270
$173,894
60.1%
$104,51152.6%
$109,41855.1%
+$4,908
Nashville · Jul
$207,889
$169,317
$179,294
60.0%
$107,57651.7%
$112,61554.2%
+$5,039
Nashville · Aug
$213,585
$182,928
$193,466
60.2%
$116,46654.5%
$119,55756.0%
+$3,091
Nashville · Sep
$198,795
$176,978
$190,091
54.9%
$104,36052.5%
$105,39153.0%
+$1,031
TOTAL
$6,211,447
$5,168,537
$5,438,857
59.5%
$3,233,98752.1%
$3,594,86857.9%
+$360,881
Balance Elena used = her loss divided by her rate. Compare it with still owed today from the CRM: where they match, she used the same balances; where hers is higher, she took the balance at an earlier date. Her figures are typed in from her doc, not re-read each day.
Locked quarter-end rates
The page rebuilds every day, so the live rates move a little each time. The books need one rate per quarter. On the first build after a quarter ends, the rates are locked for that quarter and its sales are provisioned at them from then on. Sales in the quarter still running use the live rates until it closes. How often: new sales are provisioned every month at the current rates; the rates are re-set every quarter-end; the base year moves on once a year, when the next year’s sales have mostly reached month 24.
Quarter
Locked on
Payments to
Based on
Financed
Provision (locked)
Provision $
At today’s live rates
2026-Q3
2026-11-05
2026-11-04
2024 less 2025 slip
$6,211,447
57.9%
$3,594,868
58.0%
Rates locked for 2026-Q3: by city and deposit on the day
Deposit % of sale
Florida
Texas
Boston
Chicago
New York
Nashville
No city (e.g. Atlanta)
Under 15%
66%
68%
64%
69%
65%
62%
66%
15–20%
53%
55%
51%
56%
52%
49%
53%
20–30%
46%
48%
44%
49%
45%
42%
46%
30–50%
34%
36%
32%
37%
33%
30%
34%
50% or more
26%
28%
24%
29%
25%
22%
26%
Locks are kept in data/bad_debt_rates_locked.json in the repository and are never rewritten by the daily build. The first lock (2026-Q3) was set on 2026-11-05, after that quarter ended, from the rates on that day.
Check against what actually happened
For each past quarter: the rates this method would have set at that quarter-end, using only payments made by then, applied to that quarter’s sales, against what those sales have not collected by today. Close to zero means the method gets it right. Plus means it set aside more than was lost; minus means less.
Quarter sold
Agreements
Financed
Rates based on
Provision then
Not collected by today
of which still owed
Avg months since sale
Provision v outcome (pts)
2022-Q1
1,575
$4.19M
2019 less 2020 slip
$1,909,49245.6%
$2,325,60655.5%
23.4%
57
−9.9
2022-Q2
1,315
$3.54M
2019 less 2020 slip
$1,615,54845.7%
$2,209,44762.4%
24.2%
54
−16.8
2022-Q3
1,403
$3.66M
2019 less 2020 slip
$1,683,60546.0%
$2,128,89558.1%
21.9%
51
−12.2
2022-Q4
1,284
$3.16M
2020 less 2021 slip
$1,674,77153.0%
$1,777,41956.3%
24.3%
48
−3.3
2023-Q1
1,696
$4.20M
2020 less 2021 slip
$2,236,10953.3%
$2,310,75255.0%
24.8%
45
−1.8
2023-Q2
1,795
$4.19M
2020 less 2021 slip
$2,229,35853.2%
$2,228,60553.2%
28.0%
42
+0.0
2023-Q3
1,982
$4.09M
2020 less 2021 slip
$1,999,99348.9%
$2,039,00849.8%
27.2%
39
−1.0
2023-Q4
1,999
$3.94M
2021 less 2022 slip
$1,984,57950.4%
$1,991,87950.6%
32.1%
36
−0.2
2024-Q1
2,268
$4.43M
2021 less 2022 slip
$2,077,35546.9%
$2,141,86548.3%
37.9%
33
−1.5
2024-Q2
2,186
$4.32M
2021 less 2022 slip
$2,081,21148.2%
$2,029,70747.0%
39.2%
30
+1.2
2024-Q3
2,403
$4.59M
2022 less 2023 slip
$2,230,42948.6%
$2,196,39847.8%
39.8%
27
+0.7
2024-Q4
2,373
$4.90M
2022 less 2023 slip
$2,520,71051.5%
$2,466,12150.4%
43.2%
24
+1.1
By city, all those quarters together
City
Financed
Provision then
Not collected by today
Provision v outcome (pts)
Florida
$7.72M
$3,646,59147.2%
$3,810,13749.3%
−2.1
Texas
$12.53M
$6,313,97350.4%
$6,415,23551.2%
−0.8
Boston
$3.40M
$1,377,07840.5%
$1,317,70738.8%
+1.7
New York
$24.67M
$12,434,52550.4%
$13,891,04956.3%
−5.9
Nashville
$0.88M
$470,99453.5%
$411,57546.7%
+6.7
“Not collected by today” includes money still owed, some of which will still come in, so the final loss will be a little lower than shown, most of all for the youngest quarters. Six P&L cities only. Check on the rebuild: at today’s date it lands 0.0 points above the live rates on Q3 2026 (Jul–Sep) sales (it uses the payment schedule for collected-to-date, the live rates use the ledger).
How it’s worked out
Financed = sale minus deposit on each CRM agreement (Debtor Ledger), $50 or more. Same as “Total financed” on Mike’s P&L: Q3 2026 (Jul–Sep) reads $6,211,447 here against $6,210,653 on his sheet.
Collected = every dated payment on the CRM payment schedule, net of refunds and chargebacks (they post as negative payments). Ties to the ledger’s own paid total: $56,232,124 v $56,277,376 (-0.08%).
m12 = collected within 12 months (12 × 30.4 days) of the shoot date. A cell only counts agreements that have reached that age; it is blank under 30 agreements.
Locked rates: each quarter’s rates are locked on the first build after it ends (data/bad_debt_rates_locked.json); that quarter’s sales use the locked rates from then on.
Monterey: “Paid to Monterey” lines are payments, so they are inside collected and every mN figure; the “of which Monterey” column shows how much. Placements come from the CRM collections flag.
Credited / written off and still owed are the ledger’s credits and balance today. Both are money not collected.
Provision rate: what 2024 sales have collected to date per deposit band (the latest year with three-quarters of its money past 24 months; six P&L cities only; until 5 Nov 2026 this used the month-24 figure and included Atlanta, whose 2024 sales collected about 37% and dragged every rate down by about 1 point), less the drop 2025 shows against 2024 at month 12 in that band, rounded to a whole %. Recomputed on every daily build, so it moves as new years settle.
Mike’s figures are typed in from his sheet (“Director — IES Consolidated P&L — July–September 2026”, shared 4 Nov 2026), not re-read each day.
No collector or system ever retries a failed payment automatically; money that comes in late is a person (collector or customer) acting. These are outcomes, not levers.