Share:

Missed chases — the recovery list

Every finance customer who missed a payment and was never handed over, because /chase-daily cut anyone the hand-over ledger had ever seen. Recurring instalments only. Built 2026-11-17 15:36 UTC · 2026-10-11 to 2026-11-14 · hand-over records from the laptop copy (Supabase unavailable).
People never handed over
173
deduped — each person appears once
Past due on them
$180,046
their latest past-due balance
Missed payments
173
person-days — 1.00 each
Days computed exactly
22
2026-10-11 → 2026-11-14
Days we cannot list
0
nothing outstanding

Recurring only. Every row here comes from the per-day chase files, which are collapseToCustomers(day).filter(bucket === 'Finance' && !cleared) — and Finance means the Square location name starts with Recurring. A card failing at the studio counter is a sale that did not go through, not arrears, and it is not on this page. Checked: 0 of the 3,727 source rows were studio sales, deposits or office declines, and 0 of the 173 rows in the download are anything other than Finance arrears (0 owe nothing).

What went wrong. A day's hand-over file used to cut everyone the ledger had ever recorded, and the ledger has no time limit — so the customers who fail every cycle were handed over once and then dropped forever. On 31 August that cut 684 of 877 people and Hamad received 193 names. The cut rule was fixed on 3 Sep 2026; this page is the backlog it left behind.

How a person counts as handed over. They appear in the laptop's daily CSV, or Render's copy of it, or a weekly window file the ledger actually records as sent. Matching is Square customer id, then last-10-digit phone, then lowercased email — the same three keys the ledger uses. Where two copies of a day disagree, the larger hand-over wins, so this list under-claims rather than sending anyone a second call.

Download the recovery list — 173 people, one row each

One row per person, biggest debt first, with Days missed and Times missed added to the usual chase columns. Somebody who missed on three different days is one row, not three.

Every day

Of the 3,727 people who missed a recurring payment across the days we can check, 3,554 were handed over and 173 were not.

DayMissed a paymentHanded over Never handed overPast due missedWhere the hand-over came from
Sat, 14 Nov 110 89 21 19.1% $17,927 daily file (laptop) 89
Fri, 13 Nov 147 119 28 19.0% $29,828 daily file (laptop) 119
Thu, 12 Nov 126 101 25 19.8% $26,652 daily file (laptop) 101
Wed, 11 Nov 87 66 21 24.1% $34,692 daily file (laptop) 66
Tue, 10 Nov 190 146 44 23.2% $38,590 daily file (laptop) 146
Mon, 9 Nov 111 93 18 16.2% $15,602 daily file (laptop) 93
Sun, 8 Nov 77 61 16 20.8% $16,754 daily file (laptop) 61
Wed, 28 Oct 299 299 0 0.0% — daily file (laptop) 299
Tue, 27 Oct 166 166 0 0.0% — daily file (laptop) 166
Mon, 26 Oct 132 132 0 0.0% — daily file (laptop) 132
Sun, 25 Oct 201 201 0 0.0% — daily file (laptop) 201
Sat, 24 Oct 173 173 0 0.0% — daily file (laptop) 173
Fri, 23 Oct 144 144 0 0.0% — daily file (laptop) 144
Thu, 22 Oct 170 170 0 0.0% — daily file (laptop) 170
Wed, 21 Oct 142 142 0 0.0% — daily file (laptop) 142
Tue, 20 Oct 270 270 0 0.0% — daily file (laptop) 270
Fri, 16 Oct 188 188 0 0.0% — daily file (laptop) 188
Thu, 15 Oct 508 508 0 0.0% — daily file (laptop) 508
Wed, 14 Oct 121 121 0 0.0% — daily file (laptop) 121
Tue, 13 Oct 138 138 0 0.0% — daily file (laptop) 138
Mon, 12 Oct 138 138 0 0.0% — daily file (laptop) 138
Sun, 11 Oct 89 89 0 0.0% — daily file (laptop) 89
By city
CityPeoplePast dueMissed payments
Texas 46 26.6% $60,230 33.5% 46
New York 41 23.7% $44,773 24.9% 41
Florida 28 16.2% $26,647 14.8% 28
Boston 23 13.3% $20,551 11.4% 23
Nashville 18 10.4% $20,039 11.1% 18
Chicago 17 9.8% $7,805 4.3% 17
TOTAL173 $180,046 173
How many times each person was missed

The whole point of the fix: these are the repeat missers the old rule was designed to suppress.

Missed and not handed overPeoplePast due
once 173 100.0% $180,046 100.0%
Coverage — what this page can and cannot tell you
PeriodWhat existsVerdict
2026-10-11 – 2026-11-14 a per-day uncut list and a per-day hand-over file for every one of the 22 days computed exactly. This is where every person in the download came from
2026-11-17 (today) nothing yet, by design not a gap. Square's recurring charges land through the afternoon, so /chase-daily never cuts today — today's missers are handed over tomorrow morning, under the fixed rule
Cross-check — the same days counted a second way

The per-day files are one route to "who missed a recurring payment that day". The rolling declines.json pull is an independent one. It counts every recurring decliner, including people who have since cleared, so it should be the larger of the two. A day with people in the file but not in the pull would mean the two disagree, and that is what the last column watches for.

DayFrom declines.jsonFrom the per-day fileIn the file only
Wed, 11 Nov 95 87 agree
Thu, 12 Nov 135 126 agree
Fri, 13 Nov 152 147 agree
Sat, 14 Nov 112 110 agree