Share:

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 sitsAccountsPaid at least one monthly paymentMonthly payments madePaid in total, deposit includedTotal paid by the group
PIF'D (settled)2,8372,829 99.7%5$1,500$4.64M
On a reduction plan159157 98.7%7$1,295$223k
Offer still open218107 49.1%0$500$156k
Offer expired328 25.0%0$418$23k
In collections (Monterey)17,3439,234 53.2%1$500$13.34M

Accounts sent to Monterey: monthly payments made before they went

Monthly payments madeAccountsPaid us in total
None, deposit only8,109 46.8%$3.13M
1-25,212 30.1%$3.98M
3-52,500 14.4%$3.20M
6-111,374 7.9%$2.71M
12 or more148 0.9%$327k

2. What were the reductions?

Where it sitsHad a reductionSize of the reductionOffer on the sheetOffer as % of what they owedPaid after the reductionMissed after the reduction
PIF'D (settled)2,704 95.3%$1,000$70054%$3500
On a reduction plan156 98.1%$750$60033%$3082
Offer still open2 0.9%$1,600$80034%$30013
Offer expired0 0.0%—$40034%——
In collections (Monterey)2,164 12.5%$1,000——$03

3. How long until they went to collections?

Where it sitsSale to first miss (days)First miss to reduction (days)First miss to Monterey (days)Sale to Monterey (days)
PIF'D (settled)61191——
On a reduction plan53234——
Offer still open38129——
Offer expired35———
In collections (Monterey)38163189254

First missed payment to Monterey

Time takenAccountsOwed
Within 90 days170 1.1%$345k
91-180 days7,059 44.8%$13.14M
181-365 days5,807 36.9%$10.24M
Over a year2,722 17.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 sitsMissed payments6-11 misses12+ missesMiss, pay, miss loopsWent round 3+ times
PIF'D (settled)71,318 46.5%488 17.2%21,046 36.9%
On a reduction plan1177 48.4%63 39.6%4106 66.7%
Offer still open9127 58.3%55 25.2%119 8.7%
Offer expired718 56.3%4 12.5%12 6.3%
In collections (Monterey)56,093 35.1%1,555 9.0%11,792 10.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 sitsIn the debt GHLEver texted or called backTexts we sent
PIF'D (settled)328199 60.7%7
On a reduction plan136101 74.3%12
Offer still open216118 54.6%11
Offer expired3216 50.0%9
In collections (Monterey)3,2711,473 45.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.

WhenWhatWhy: the evidence
Day 0 - 70ChaseThe 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 70The Monterey testNo 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 outOffer 1 - settle todayLead 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 outOffer 2 - a short fixed planIf 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 planOne miss ends the dealA 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 MontereyRefer them backSomeone 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

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:

ByReplied (share of everyone)Share of those who ever reply
Day 13,089 35.3%60.4%
Day 34,238 48.4%82.9%
Day 74,369 49.9%85.5%
Day 144,429 50.6%86.7%
Day 304,598 52.5%90.0%
Day 454,717 53.9%92.3%
Day 604,799 54.8%93.9%
Day 704,867 55.6%95.2%
Day 904,923 56.2%96.3%
Day 1205,013 57.2%98.1%
Day 1605,111 58.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 70PeoplePaid anything, next 90 daysCash, next 90 daysPer personReplied laterEver placed
Silent, paid nothing2,935 33.5%270 9.2%$79k$27171 5.8%1,628 55.5%
Silent, but paid something957 10.9%482 50.4%$145k$15173 7.6%156 16.3%
Replied, paid nothing2,394 27.3%391 16.3%$115k$48—1,066 44.5%
Replied and paid2,473 28.2%1,401 56.7%$495k$200—250 10.1%

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 textAccountsOwedMedian owed
70-100 days230$469k$2,167
101-160 days387$745k$2,042
161-270 days543$1.01M$1,883
271+ days652$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.

PlacedAccountsFirst miss → placed (days)Sale → placed (days)Misses beforeNever paid an instalment3+ miss-then-pay cyclesPaid before (median)Owed (median)Owed (total)
20221,73243548010918 53.0%137 7.9%$480$2,050$3.42M
20233,07815922041,742 56.6%208 6.8%$450$2,125$6.29M
20243,21816221541,569 48.8%229 7.1%$465$1,750$5.50M
20255,09218024252,301 45.2%553 10.9%$550$1,760$8.55M
2026 (to date)2,66525331571,082 40.6%456 17.1%$615$1,833$4.71M

How long from the first miss to Monterey

First miss → placedAccountsMedian missesOwed
0-70 days56 0.4%1$108k
71-90 days114 0.7%2$237k
91-120 days403 2.6%3$780k
121-180 days6,656 42.2%4$12.36M
181-365 days5,807 36.8%6$10.24M
over a year2,722 17.2%11$4.70M

How many instalments they paid before going

Instalments paidAccountsPaid us in totalOwedMedian days first miss → placed
0 - deposit only7,612 48.2%$2.97M$15.36M173
1-24,683 29.7%$3.37M$8.55M206
3-52,205 14.0%$2.73M$3.20M275
6-111,184 7.5%$2.30M$1.22M338
12 or more101 0.6%$211k$147k385

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 inSettledOwed at the offerReduction givenCollectedMedian cut (% of owed)Settled in one paymentFirst miss → reduction (days)
201910$6,918$4,803$2,11550%2 20.0%-17
202085$103k$74k$29k58%45 52.9%247
2021138$169k$129k$39k63%78 56.5%323
2022472$842k$656k$181k73%268 56.8%286
2023673$1.17M$804k$366k57%267 39.7%142
2024593$812k$454k$356k50%225 37.9%145
2025577$722k$372k$346k50%336 58.2%190
2026156$164k$77k$86k40%128 82.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 reductionPlansAgreedCollectedStill to comeMonths on the plan (median)
None41 26.3%$43k$12k$32k1
1-248 30.8%$53k$17k$36k3
3-531 19.9%$38k$17k$21k7
6 or more36 23.1%$43k$29k$14k15

Open and expired offers

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”.

By the card we bill

CardSalesNever paid an instalmentOwed by never-payersCard worked in person firstMonthly charges tried (median)Sent to Monterey
Chime1,276 6.3%620 48.6%$1.18M361 58.2%5379 61.1%
Cash App1,636 8.1%917 56.1%$1.73M506 55.2%5539 58.8%
Green Dot196 1.0%115 58.7%$207k47 40.9%667 58.3%
Pathward / Netspend130 0.6%53 40.8%$110k35 66.0%538 71.7%
Varo42 0.2%31 73.8%$60k17 54.8%521 67.7%
Other app bank430 2.1%173 40.2%$345k109 63.0%592 53.2%
Credit card4,202 20.8%487 11.6%$1.19M336 69.0%5290 59.5%
Bank debit11,704 57.8%2,340 20.0%$5.17M1,528 65.3%51,410 60.3%
No card seen617 3.0%293 47.5%$597k0 0.0%—151 51.5%

By quarter of sale

SoldSalesNever paid (all)Chime shareChime never paidChime: nothing in 60 daysApp-bank shareApp-bank never paidApp bank: nothing in 60 days
2024 Q3537112 20.9%21 3.9%8 38.1%13 61.9%76 14.2%31 40.8%47 61.8%
2024 Q42,418496 20.5%116 4.8%55 47.4%77 66.4%371 15.3%174 46.9%238 64.2%
2025 Q12,747606 22.1%160 5.8%74 46.3%93 58.1%471 17.1%234 49.7%284 60.3%
2025 Q22,745701 25.5%202 7.4%94 46.5%130 64.4%516 18.8%271 52.5%345 66.9%
2025 Q32,695696 25.8%191 7.1%95 49.7%137 71.7%548 20.3%276 50.4%396 72.3%
2025 Q42,596624 24.0%159 6.1%68 42.8%92 57.9%518 20.0%258 49.8%329 63.5%
2026 Q12,745657 23.9%172 6.3%90 52.3%108 62.8%534 19.5%273 51.1%326 61.0%
2026 Q22,794825 29.5%204 7.3%107 52.5%126 61.8%523 18.7%296 56.6%341 65.2%
2026 Q3 (to 31 Jul)956312 32.6%51 5.3%29 56.9%31 60.8%153 16.0%96 62.7%103 67.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 packageSalesApp-bank: never paidChime: never paidOrdinary card: never paid
Under 15%7,9711,105 58.1%372 55.1%1,451 25.0%
15-25%7,470665 48.8%213 45.4%993 16.8%
25% or more4,792139 31.2%35 26.5%383 9.1%

Why their monthly charges failed (share of declines on never-payers’ cards)

Bank’s reasonChimeCash AppBank debit
Over the card’s limit38.2%52.7%33.4%
Declined, no reason20.4%20.7%49.9%
Not enough money16.9%0.0%6.4%
Card blocks this kind of charge12.4%24.2%4.9%
Account closed / invalid10.3%0.0%2.3%
Expired1.1%0.9%0.8%
Issuer instalment error0.4%1.4%0.1%
Expiry date wrong0.3%0.0%0.0%
Card number fails0.0%0.2%2.3%

By city

CitySalesNever paidApp-bank shareApp-bank never paidChime never paid
New York4,6391,178 25.4%783 16.9%399 51.0%135 47.5%
Houston2,957872 29.5%628 21.2%366 58.3%96 52.7%
Dallas2,956836 28.3%646 21.9%361 55.9%117 54.4%
Nashville2,577610 23.7%643 25.0%308 47.9%107 45.7%
Florida2,394468 19.5%244 10.2%114 46.7%34 45.9%
Boston2,309409 17.7%336 14.6%127 37.8%45 37.2%
Chicago1,515405 26.7%284 18.7%148 52.1%57 50.0%
Orlando754219 29.0%146 19.4%86 58.9%29 55.8%
Atlanta13232 24.2%0 0.0%0 —0 —

Never paid vs paid at least once

Never paidPaid at least once
Accounts5,02915,204
Median package$3,000$3,000
Median deposit$350$450
Median deposit as % of package14%18%
Billed on an app-bank card38.0%11.8%
...of which Chime12.3%4.3%
Billed on a credit card9.7%24.4%
Ever texted or called back (of those in the debt GHL)47.6%63.2%
Sent to Monterey59.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

TabRowsOn the CRMPackageOutstandingReduction offeredCollected
IN COLLECTIONS (Monterey)17,34417,343 100.0%$43.26M$30.88M——
PIF'D (settled)2,8612,837 99.2%$7.37M$4.15M$2.67M$1.46M
REDUCTIONS - on a plan159159 100.0%$455k$277k$97k$75k
REDUCTIONS - offer open218218 100.0%$580k$425k$144k—
Expired Reductions3232 100.0%$78k$54k$18k—
PRE-MARCH 2020638488 76.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.

TabAccountsNever paid an instalmentInstalments paid (median)Misses (median)Cycles (median)3+ cyclesPaid us in totalSale → first miss (days)Ever replied to a text
IN COLLECTIONS (Monterey)17,3438,109 46.8%1511,792 10.3%$13.34M381,473 8.5%
PIF'D (settled)2,8378 0.3%5721,046 36.9%$4.64M61199 7.0%
REDUCTIONS - on a plan1592 1.3%7114106 66.7%$223k53101 63.5%
REDUCTIONS - offer open218111 50.9%09119 8.7%$156k38118 54.1%
Expired Reductions3224 75.0%0712 6.3%$23k3516 50.0%
PRE-MARCH 2020488193 39.5%122168 13.9%$295k480 0.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

QuestionDetail
Clock startIs 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 discountHow 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 lengthThree 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 plansWhat 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 offers218 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 placesPlacing 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 reconciliationNothing has been keyed back as “Paid to Monterey” since 31 Jul 2026, so we cannot measure what placing earns until that is fixed.

Sources and definitions

SourceWhat it givesAs at
Caet Collection Spreadsheet (Drive, owner studio1.collections)The population and its status: the tab each account sits on, the offer, the collected amount, notesOct 31, 2026
CRM finance schedule per bookingEvery payment, missed instalment and reduction, each with its own date. Joined on the order reference: 99.2% matchOct 16, 2026 (median) – Oct 29, 2026
CRM collections flagcollected = Y and the collection date: the day the account was placed with Monterey29 Oct 2026
Debt GHL (US Debt Collection)Card → contact → every SMS in and out. Card company name = the order referenceOct 30, 2026