Caet Collection Spreadsheet: every account, what happened, and the plan
21,252 rows across 5 tabs · 21,077 joined to the CRM finance schedule (99.2%) · sheet exported Oct 31, 2026 · CRM schedules read Oct 16, 2026–Oct 29, 2026 · debt GHL read Oct 30, 2026
Sent to Monterey
17,344
$30.88M outstanding
Never paid one instalment
48.2%
of the accounts placed: deposit, then nothing
First miss → Monterey
253 days
median, 2026 placements (2023: 159)
Reduced, then placed anyway
1,220
$1.39M written off first
Silent + not paying at day 70
9.2%
paid anything in the next 90 days
The day-70 rule today
1,812
$3.29M would go to Monterey
What happens to the accounts on Caet’s sheet today, from the CRM payment history, the date each went to Monterey and the debt GHL texts. Typical figures are medians. Nothing on this tab is a proposal.
1. How many paid?
Where it sits
Accounts
Paid at least one monthly payment
Monthly payments made
Paid in total, deposit included
Total paid by the group
PIF'D (settled)
2,837
2,82999.7%
5
$1,500
$4.64M
On a reduction plan
159
15798.7%
7
$1,295
$223k
Offer still open
218
10749.1%
0
$500
$156k
Offer expired
32
825.0%
0
$418
$23k
In collections (Monterey)
17,343
9,23453.2%
1
$500
$13.34M
Accounts sent to Monterey: monthly payments made before they went
Monthly payments made
Accounts
Paid us in total
None, deposit only
8,10946.8%
$3.13M
1-2
5,21230.1%
$3.98M
3-5
2,50014.4%
$3.20M
6-11
1,3747.9%
$2.71M
12 or more
1480.9%
$327k
2. What were the reductions?
Where it sits
Had a reduction
Size of the reduction
Offer on the sheet
Offer as % of what they owed
Paid after the reduction
Missed after the reduction
PIF'D (settled)
2,70495.3%
$1,000
$700
54%
$350
0
On a reduction plan
15698.1%
$750
$600
33%
$308
2
Offer still open
20.9%
$1,600
$800
34%
$300
13
Offer expired
00.0%
—
$400
34%
—
—
In collections (Monterey)
2,16412.5%
$1,000
—
—
$0
3
2,045 settled accounts paid within a day of the reduction.
1,220 accounts in collections were given a reduction BEFORE they went to Monterey ($1.39M written off) and went anyway; the typical one paid $150 after it and missed 4 more payments. The “Had a reduction” column above also counts reductions keyed after the account was placed.
3. How long until they went to collections?
Where it sits
Sale to first miss (days)
First miss to reduction (days)
First miss to Monterey (days)
Sale to Monterey (days)
PIF'D (settled)
61
191
—
—
On a reduction plan
53
234
—
—
Offer still open
38
129
—
—
Offer expired
35
—
—
—
In collections (Monterey)
38
163
189
254
First missed payment to Monterey
Time taken
Accounts
Owed
Within 90 days
1701.1%
$345k
91-180 days
7,05944.8%
$13.14M
181-365 days
5,80736.9%
$10.24M
Over a year
2,72217.3%
$4.70M
By year placed, the typical gap went from 159 days (2023) to 253 (2026). See the Road to Monterey tab.
4. How many times did they miss?
Where it sits
Missed payments
6-11 misses
12+ misses
Miss, pay, miss loops
Went round 3+ times
PIF'D (settled)
7
1,31846.5%
48817.2%
2
1,04636.9%
On a reduction plan
11
7748.4%
6339.6%
4
10666.7%
Offer still open
9
12758.3%
5525.2%
1
198.7%
Offer expired
7
1856.3%
412.5%
1
26.3%
In collections (Monterey)
5
6,09335.1%
1,5559.0%
1
1,79210.3%
A loop is a run of missed payments ended by a payment. Three loops means missed, paid, missed, paid, missed again.
5. Do they reply to us?
Where it sits
In the debt GHL
Ever texted or called back
Texts we sent
PIF'D (settled)
328
19960.7%
7
On a reduction plan
136
10174.3%
12
Offer still open
216
11854.6%
11
Offer expired
32
1650.0%
9
In collections (Monterey)
3,271
1,47345.0%
9
The debt GHL started in May 2025, so most accounts placed before then have no text history. Money recorded as “Paid to Monterey”: $755k on 747 accounts, and nothing since 31 Jul 2026.
The proposal: chase for 70 days, then Monterey. One short deal for anyone who answers.
Built from what the 21,252 accounts on Caet’s sheet actually did, and from 12,415 people in the debt GHL since May 14, 2025. Every number is linked to the tab that measures it. Nothing here has been switched on.
When
What
Why: the evidence
Day 0 - 70
Chase
The desk and the text sequence work the account: first text the day after the miss, calls from the collectors. 85.5% of everyone who ever replies does so inside the first week, and 95.2% inside 70 days, so this window is where the conversation happens or does not.
Day 70
The Monterey test
No reply to anything we sent AND no payment in the last 70 days → place with Monterey. Silence alone is not enough. 957 people were silent but still paying at day 70, and 50.4% of them paid again in the next 90 days ($151 each). Of the 2,935 who were silent and paying nothing, only 9.2% paid anything in the next 90 days ($27 each). Today that rule picks 1,812 accounts, $3.29M.
They reach out
Offer 1 - settle today
Lead with a one-payment settlement taken on the call. Half of everything in PIF'D (49.9%) settled in one payment and 2,045 paid on the day of the reduction itself. The money is on the table in that conversation or it is not.
They reach out
Offer 2 - a short fixed plan
If they cannot settle today: a plan with a fixed end, three payments at most, inside 90 days, first one taken on the call, card on file. The PIF'D accounts that paid over time took a median of 180 days and 5 payments. That length is where the missing happens.
On a plan
One miss ends the deal
A missed payment on a reduced plan voids the reduction: the full balance comes back, the customer gets one text saying so, and if nothing lands in 7 days it goes to Monterey. No second reduction. Today 67 of 156 live plans have missed 3+ times since their reduction. 1,220 accounts were reduced and still went to Monterey ($1.39M written off for nothing).
Already at Monterey
Refer them back
Someone already placed who gets in touch is Monterey's account. They pay Monterey, we do not cut a second deal. Needs Neil's decision. Monterey has keyed back $755k on 747 of these accounts, and nothing has been keyed back since 31 Jul 2026, so the reconciliation needs fixing first.
What it replaces
Accounts reach Monterey a median 253 days after their first miss (2026 placements), up from 159 in 2023. The 70-day rule takes roughly 183 days off that.
The 2026 placements missed a median 7 times before going, and 17.1% went round the miss-then-pay loop 3+ times (2023: 6.8%). That is the month-after-month pattern, and it is getting worse.
Live reduction plans: 156, a median 5 months in, median 35% of the reduced amount collected, 25 flagged DELINQUENT on the sheet.
A payment after a miss is always a person: a collector, or the customer answering a text. Nothing retries a failed card. So the “silent but paid” group is customers paying on their own or their scheduled instalment landing, not the system trying again.
When do people reply? (everyone texted 160+ days ago, n = 8,759)
Clock = the first text the debt GHL sent them. 58.4% replied at some point inside 160 days. Of those, this is how fast:
By
Replied (share of everyone)
Share of those who ever reply
Day 1
3,08935.3%
60.4%
Day 3
4,23848.4%
82.9%
Day 7
4,36949.9%
85.5%
Day 14
4,42950.6%
86.7%
Day 30
4,59852.5%
90.0%
Day 45
4,71753.9%
92.3%
Day 60
4,79954.8%
93.9%
Day 70
4,86755.6%
95.2%
Day 90
4,92356.2%
96.3%
Day 120
5,01357.2%
98.1%
Day 160
5,11158.4%
100.0%
What happens after day 70: everyone texted 160+ days ago (n = 8,759), split by what they had done by day 70
At day 70
People
Paid anything, next 90 days
Cash, next 90 days
Per person
Replied later
Ever placed
Silent, paid nothing
2,93533.5%
2709.2%
$79k
$27
1715.8%
1,62855.5%
Silent, but paid something
95710.9%
48250.4%
$145k
$151
737.6%
15616.3%
Replied, paid nothing
2,39427.3%
39116.3%
$115k
$48
—
1,06644.5%
Replied and paid
2,47328.2%
1,40156.7%
$495k
$200
—
25010.1%
Silence at day 70 is almost final for replies: only 5.8% of the silent, non-paying group ever answer in the following 90 days.
Silence is not the same as not paying. The silent-but-paying group brings in $151 a head over the next 90 days, against $27 for the silent non-payers. That is why the rule has two halves.
For scale: Monterey has keyed back $755k across 17,344 placed accounts on this sheet, about $44 an account over its whole life, as keyed back (whether that is before or after their fee is not on the line).
Who the rule would pick today
First text 70+ days ago · never replied · nothing paid in the last 70 days · owes over $10 · not already placed. 1,812 accounts, $3.29M. Kept back by the payment half of the rule: 391 silent accounts that paid inside the last 70 days. The working list, rebuilt every morning with names and holds for Caet's open deals: https://reports.iconicbyai.com/day-70.
Days since first text
Accounts
Owed
Median owed
70-100 days
230
$469k
$2,167
101-160 days
387
$745k
$2,042
161-270 days
543
$1.01M
$1,883
271+ days
652
$1.07M
$1,610
Every placement on the sheet, by the year it went to Monterey
15,785 of the 17,344 IN COLLECTIONS rows carry the CRM’s collection date (91.0%). Days are medians.
Placed
Accounts
First miss → placed (days)
Sale → placed (days)
Misses before
Never paid an instalment
3+ miss-then-pay cycles
Paid before (median)
Owed (median)
Owed (total)
2022
1,732
435
480
10
91853.0%
1377.9%
$480
$2,050
$3.42M
2023
3,078
159
220
4
1,74256.6%
2086.8%
$450
$2,125
$6.29M
2024
3,218
162
215
4
1,56948.8%
2297.1%
$465
$1,750
$5.50M
2025
5,092
180
242
5
2,30145.2%
55310.9%
$550
$1,760
$8.55M
2026(to date)
2,665
253
315
7
1,08240.6%
45617.1%
$615
$1,833
$4.71M
How long from the first miss to Monterey
First miss → placed
Accounts
Median misses
Owed
0-70 days
560.4%
1
$108k
71-90 days
1140.7%
2
$237k
91-120 days
4032.6%
3
$780k
121-180 days
6,65642.2%
4
$12.36M
181-365 days
5,80736.8%
6
$10.24M
over a year
2,72217.2%
11
$4.70M
How many instalments they paid before going
Instalments paid
Accounts
Paid us in total
Owed
Median days first miss → placed
0 - deposit only
7,61248.2%
$2.97M
$15.36M
173
1-2
4,68329.7%
$3.37M
$8.55M
206
3-5
2,20514.0%
$2.73M
$3.20M
275
6-11
1,1847.5%
$2.30M
$1.22M
338
12 or more
1010.6%
$211k
$147k
385
1,220 were given a reduction before they were placed: $1.39M of credits, then a median 4 more misses before they went anyway.
Paid to us after the placement date (CRM lines dated after it): $114k. Keyed back as “Paid to Monterey”: $755k on 747 accounts.
PIF’D: everyone who settled, by the year of their reduction
2,704 settled accounts carry a reduction on the CRM schedule. 49.9% settled in a single payment after the reduction, and 2,045 paid within a day of it. The 1,355 who paid over time took a median 5 payments across 180 days, missing a median 2 along the way.
Reduced in
Settled
Owed at the offer
Reduction given
Collected
Median cut (% of owed)
Settled in one payment
First miss → reduction (days)
2019
10
$6,918
$4,803
$2,115
50%
220.0%
-17
2020
85
$103k
$74k
$29k
58%
4552.9%
247
2021
138
$169k
$129k
$39k
63%
7856.5%
323
2022
472
$842k
$656k
$181k
73%
26856.8%
286
2023
673
$1.17M
$804k
$366k
57%
26739.7%
142
2024
593
$812k
$454k
$356k
50%
22537.9%
145
2025
577
$722k
$372k
$346k
50%
33658.2%
190
2026
156
$164k
$77k
$86k
40%
12882.1%
309
Live reduction plans: how they have paid since the reduction
159 on a plan (156 with the credit on the CRM schedule). $181k agreed, $75k in, $107k still to come. 25 are marked DELINQUENT on the sheet.
Misses since the reduction
Plans
Agreed
Collected
Still to come
Months on the plan (median)
None
4126.3%
$43k
$12k
$32k
1
1-2
4830.8%
$53k
$17k
$36k
3
3-5
3119.9%
$38k
$17k
$21k
7
6 or more
3623.1%
$43k
$29k
$14k
15
Open and expired offers
218 offers are open: $425k owed, $144k offered off, $281k if all accept. 50.9% never paid an instalment and 54.1% have ever replied to a text. 42 are TEXT DND.
32 expired: $54k owed, 50.0% ever replied.
Who never pays a single instalment, and the card they were billed on
Every financed sale from 15 Sep 2024 to 31 Jul 2026, not just the sheet: 20,233 agreements, so every one has had 90+ days to make a first payment. 5,029 (24.9%) never paid an instalment after the deposit, and they still owe $10.59M. The card is the one we bill, identified by its BIN (first six digits). Chime means a card issued by The Bancorp Bank or Stride Bank, the two banks behind Chime cards. A few other apps use them too, so read it as “almost certainly Chime”.
App-bank cards are 18.3% of sales but 38.0% of everyone who never pays. On an app-bank card 51.5% never pay; on an ordinary bank debit card 20.0%; on a credit card 11.6%.
Chime: 48.6% never pay (620 of 1,276, $1.18M owed). Cash App is worse still at 56.1%.
What differs is how the bank says no. On Chime never-payers’ cards the top reasons are over the card’s limit (38.2%), not enough money (16.9%), the card blocking this kind of charge (12.4%) and the account being closed (10.3%). On ordinary debit cards half the declines give no reason at all. The limit decline on app-bank cards did not get rarer at smaller amounts when we tested it on 21 Sep 2026, so a smaller or weekly charge is unlikely to get round it. Most never-payers’ cards had worked in person for the deposit (Chime 58.2%, bank debit 65.3%), so that is not a Chime signal.
The deposit matters as much as the card. On an app-bank card, a deposit under 15% of the package never pays 58.1% of the time; an ordinary card with 25%+ down, 9.1%.
Chime is not getting worse. Compared at the same age (nothing paid in the first 60 days), Chime runs at 58–72% every quarter with no trend, and the Chime share of sales holds around 5–8%. An earlier version of this page said the rate was rising. That came from comparing old sales, which had longer to pay, with new ones.
By the card we bill
Card
Sales
Never paid an instalment
Owed by never-payers
Card worked in person first
Monthly charges tried (median)
Sent to Monterey
Chime
1,2766.3%
62048.6%
$1.18M
36158.2%
5
37961.1%
Cash App
1,6368.1%
91756.1%
$1.73M
50655.2%
5
53958.8%
Green Dot
1961.0%
11558.7%
$207k
4740.9%
6
6758.3%
Pathward / Netspend
1300.6%
5340.8%
$110k
3566.0%
5
3871.7%
Varo
420.2%
3173.8%
$60k
1754.8%
5
2167.7%
Other app bank
4302.1%
17340.2%
$345k
10963.0%
5
9253.2%
Credit card
4,20220.8%
48711.6%
$1.19M
33669.0%
5
29059.5%
Bank debit
11,70457.8%
2,34020.0%
$5.17M
1,52865.3%
5
1,41060.3%
No card seen
6173.0%
29347.5%
$597k
00.0%
—
15151.5%
By quarter of sale
Sold
Sales
Never paid (all)
Chime share
Chime never paid
Chime: nothing in 60 days
App-bank share
App-bank never paid
App bank: nothing in 60 days
2024 Q3
537
11220.9%
213.9%
838.1%
1361.9%
7614.2%
3140.8%
4761.8%
2024 Q4
2,418
49620.5%
1164.8%
5547.4%
7766.4%
37115.3%
17446.9%
23864.2%
2025 Q1
2,747
60622.1%
1605.8%
7446.3%
9358.1%
47117.1%
23449.7%
28460.3%
2025 Q2
2,745
70125.5%
2027.4%
9446.5%
13064.4%
51618.8%
27152.5%
34566.9%
2025 Q3
2,695
69625.8%
1917.1%
9549.7%
13771.7%
54820.3%
27650.4%
39672.3%
2025 Q4
2,596
62424.0%
1596.1%
6842.8%
9257.9%
51820.0%
25849.8%
32963.5%
2026 Q1
2,745
65723.9%
1726.3%
9052.3%
10862.8%
53419.5%
27351.1%
32661.0%
2026 Q2
2,794
82529.5%
2047.3%
10752.5%
12661.8%
52318.7%
29656.6%
34165.2%
2026 Q3(to 31 Jul)
956
31232.6%
515.3%
2956.9%
3160.8%
15316.0%
9662.7%
10367.3%
Read the “nothing in 60 days” columns for the trend. They compare every quarter at the same age. “Never paid” looks worse for recent quarters only because older sales have had longer to pay eventually.
Deposit size × card
Deposit as % of package
Sales
App-bank: never paid
Chime: never paid
Ordinary card: never paid
Under 15%
7,971
1,10558.1%
37255.1%
1,45125.0%
15-25%
7,470
66548.8%
21345.4%
99316.8%
25% or more
4,792
13931.2%
3526.5%
3839.1%
Why their monthly charges failed (share of declines on never-payers’ cards)
Bank’s reason
Chime
Cash App
Bank debit
Over the card’s limit
38.2%
52.7%
33.4%
Declined, no reason
20.4%
20.7%
49.9%
Not enough money
16.9%
0.0%
6.4%
Card blocks this kind of charge
12.4%
24.2%
4.9%
Account closed / invalid
10.3%
0.0%
2.3%
Expired
1.1%
0.9%
0.8%
Issuer instalment error
0.4%
1.4%
0.1%
Expiry date wrong
0.3%
0.0%
0.0%
Card number fails
0.0%
0.2%
2.3%
By city
City
Sales
Never paid
App-bank share
App-bank never paid
Chime never paid
New York
4,639
1,17825.4%
78316.9%
39951.0%
13547.5%
Houston
2,957
87229.5%
62821.2%
36658.3%
9652.7%
Dallas
2,956
83628.3%
64621.9%
36155.9%
11754.4%
Nashville
2,577
61023.7%
64325.0%
30847.9%
10745.7%
Florida
2,394
46819.5%
24410.2%
11446.7%
3445.9%
Boston
2,309
40917.7%
33614.6%
12737.8%
4537.2%
Chicago
1,515
40526.7%
28418.7%
14852.1%
5750.0%
Orlando
754
21929.0%
14619.4%
8658.9%
2955.8%
Atlanta
132
3224.2%
00.0%
0—
0—
Never paid vs paid at least once
Never paid
Paid at least once
Accounts
5,029
15,204
Median package
$3,000
$3,000
Median deposit
$350
$450
Median deposit as % of package
14%
18%
Billed on an app-bank card
38.0%
11.8%
...of which Chime
12.3%
4.3%
Billed on a credit card
9.7%
24.4%
Ever texted or called back (of those in the debt GHL)
47.6%
63.2%
Sent to Monterey
59.4%
21.2%
Still owed
$10.59M
$14.76M
Per-account card, issuer and whether the card worked in person are in the laptop CSV and on the /day-70 list, where you can filter by card. Sources: card_attempts.jsonl (every Square card attempt since Sep 2024, deduped on payment id), the recurring invoice cache (invoice title = CRM ref → Square customer), the BIN issuer feed, and the CRM finance schedules.
The sheet, tab by tab
Tab
Rows
On the CRM
Package
Outstanding
Reduction offered
Collected
IN COLLECTIONS (Monterey)
17,344
17,343100.0%
$43.26M
$30.88M
—
—
PIF'D (settled)
2,861
2,83799.2%
$7.37M
$4.15M
$2.67M
$1.46M
REDUCTIONS - on a plan
159
159100.0%
$455k
$277k
$97k
$75k
REDUCTIONS - offer open
218
218100.0%
$580k
$425k
$144k
—
Expired Reductions
32
32100.0%
$78k
$54k
$18k
—
PRE-MARCH 2020
638
48876.5%
$1.23M
$839k
$101k
—
What each group did, from the CRM finance schedule
A miss is a declined instalment on the schedule. A cycle is a run of misses that ended when money landed. Three cycles means they missed, paid, missed, paid, missed again. Cash includes the deposit and is net of chargebacks and refunds.
Tab
Accounts
Never paid an instalment
Instalments paid (median)
Misses (median)
Cycles (median)
3+ cycles
Paid us in total
Sale → first miss (days)
Ever replied to a text
IN COLLECTIONS (Monterey)
17,343
8,10946.8%
1
5
1
1,79210.3%
$13.34M
38
1,4738.5%
PIF'D (settled)
2,837
80.3%
5
7
2
1,04636.9%
$4.64M
61
1997.0%
REDUCTIONS - on a plan
159
21.3%
7
11
4
10666.7%
$223k
53
10163.5%
REDUCTIONS - offer open
218
11150.9%
0
9
1
198.7%
$156k
38
11854.1%
Expired Reductions
32
2475.0%
0
7
1
26.3%
$23k
35
1650.0%
PRE-MARCH 2020
488
19339.5%
1
22
1
6813.9%
$295k
48
00.0%
23 references sit on two tabs at once (moved without being deleted). Each row is counted where it sits, so tab totals match the sheet.
Decisions needed before any of this is switched on
Question
Detail
Clock start
Is day 0 the first text (what this page measures) or the first missed payment? The first text lands about a day after the miss today, so they barely differ for new misses. They differ a lot for the old book, where the first text came months after the miss.
The settle-today discount
How deep? The sheet’s offers have moved from a median 73% off (2022) to 40% off (2026). /reduction-recovery found cuts under 25% of the balance return $0.74 per $1 given up, against $0.08 for 75-99%. We have never tested a fixed small discount for paying on the day, so its take-up is UNKNOWN.
Plan length
Three payments in 90 days is a proposal, not a measured optimum. No short-plan cohort exists to measure it against. UNKNOWN until tried, ideally with a control arm on today’s open-ended plans.
The live plans
What happens to the 159 accounts already on a reduction plan ($107k still to come, median 35% done)? Grandfather them, or put the one-miss rule on them from the next due date?
The open offers
218 offers are open and 32 have expired. Under the new rule an expired offer with no reply and no payment goes straight to Monterey.
Who places
Placing is a human click today (the CRM’s “Confirm collection”). The day-70 list can be produced daily. Who presses the button, and does Caet review it first?
Monterey reconciliation
Nothing has been keyed back as “Paid to Monterey” since 31 Jul 2026, so we cannot measure what placing earns until that is fixed.
The population and its status: the tab each account sits on, the offer, the collected amount, notes
Oct 31, 2026
CRM finance schedule per booking
Every payment, missed instalment and reduction, each with its own date. Joined on the order reference: 99.2% match
Oct 16, 2026 (median) – Oct 29, 2026
CRM collections flag
collected = Y and the collection date: the day the account was placed with Monterey
29 Oct 2026
Debt GHL (US Debt Collection)
Card → contact → every SMS in and out. Card company name = the order reference
Oct 30, 2026
Miss = a declined instalment on the CRM schedule. Cycle = a run of misses ended by a payment. Instalment = a finance payment after the deposit.
Reply = any inbound SMS in the debt GHL. The 70-day test runs on everyone with a card there, not just the sheet: the sheet only holds people who already reached Caet or Monterey, so it cannot say what silence predicts.
The CRM schedules are a snapshot read mostly on 16 Oct, so payments in the last two weeks are not all in. That slightly overstates silence-and-no-payment for the newest accounts in the day-70 queue.
Per-account detail: Reports/caet_sheet/accounts.csv on the laptop (refs only, gitignored).
Rebuild: re-export the sheet to Reports/caet_sheet/caet.xlsx, then node scripts/reports/report_caet_sheet.js.