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.
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.
| Day | Missed a payment | Handed over | Never handed over | Past due missed | Where 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 |
| City | People | Past due | Missed 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 |
| TOTAL | 173 | $180,046 | 173 |
The whole point of the fix: these are the repeat missers the old rule was designed to suppress.
| Missed and not handed over | People | Past due |
|---|---|---|
| once | 173 100.0% | $180,046 100.0% |
| Period | What exists | Verdict |
|---|---|---|
| 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 |
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.
| Day | From declines.json | From the per-day file | In 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 |