6,964 of 14,715 agreements (47.3%) miss the opening instalment. Of those, 1,442 (20.7%) are back within 10 days.
| Opening instalment | Agreements | Share of all | Banked by day 365 | Median | n with 365 days behind it |
|---|---|---|---|---|---|
| Missed — never recovered | 5,522 | 5,522 37.5% | $207 | $0 | 1,631 |
| Missed — recovered within 10 days | 1,442 | 1,442 9.8% | $1,152 | $850 | 297 |
| Paid first time | 7,751 | 7,751 52.7% | $1,376 | $1,104 | 2,019 |
This is the question the whole page exists for. By day 365 a recovered miss banks $1,152 (n = 297) against $1,376 for an agreement that paid first time (n = 2,019) and $207 for one we never got back (n = 1,631). So catching the miss inside 10 days is worth $945 per agreement against letting it go, and recovers 84% of a clean payer.
| Measured at | Missed, never recovered | Recovered ≤10d | Paid first time | Miss as % of paid | Recovered as % of paid | n (paid) |
|---|---|---|---|---|---|---|
| Day 30 | $16 | $270 | $265 | 6% | 102% | 7,378 |
| Day 60 | $45 | $390 | $399 | 11% | 98% | 6,947 |
| Day 90 | $74 | $489 | $538 | 14% | 91% | 6,436 |
| Day 120 | $95 | $584 | $659 | 14% | 89% | 5,941 |
| Day 150 | $113 | $661 | $764 | 15% | 86% | 5,463 |
| Day 180 | $135 | $731 | $877 | 15% | 83% | 4,974 |
| Day 270 | $184 | $957 | $1,178 | 16% | 81% | 3,527 |
| Day 365 | $207 | $1,152 | $1,376 | 15% | 84% | 2,019 |
Row detail is in the CSV, never on this page — agreements.csv.
This is the scale that lets young accounts count. An agreement only appears in a column it has actually lived long enough to fill — an account opened three weeks ago is in the day-30 column and nowhere else. Nothing is thrown away for being incomplete, and nothing is counted at 365 days as though it had collected nothing. Each cell prints its own n, and a cell with fewer than 25 agreements is left blank rather than shown as noise.
| Opening instalment | Agreements | by day 30 | by day 60 | by day 90 | by day 120 | by day 150 | by day 180 | by day 270 | by day 365 |
|---|---|---|---|---|---|---|---|---|---|
| Missed — never recovered | 5,522 | $16 med $0 · n 5,228 | $45 med $0 · n 4,898 | $74 med $0 · n 4,545 | $95 med $0 · n 4,250 | $113 med $0 · n 3,933 | $135 med $0 · n 3,556 | $184 med $0 · n 2,601 | $207 med $0 · n 1,631 |
| Missed — recovered within 10 days | 1,442 | $270 med $220 · n 1,373 | $390 med $296 · n 1,279 | $489 med $350 · n 1,169 | $584 med $433 · n 1,064 | $661 med $494 · n 972 | $731 med $530 · n 861 | $957 med $662 · n 576 | $1,152 med $850 · n 297 |
| Paid first time | 7,751 | $265 med $229 · n 7,378 | $399 med $350 · n 6,947 | $538 med $488 · n 6,436 | $659 med $580 · n 5,941 | $764 med $646 · n 5,463 | $877 med $735 · n 4,974 | $1,178 med $950 · n 3,527 | $1,376 med $1,104 · n 2,019 |
A clean payer starts one instalment ahead by definition. Strip the opening charge out of all three groups and what is left is purely what happened afterwards — if the gap survives here, it is behaviour and not arithmetic.
| Opening instalment | Agreements | by day 30 | by day 60 | by day 90 | by day 120 | by day 150 | by day 180 | by day 270 | by day 365 |
|---|---|---|---|---|---|---|---|---|---|
| Missed — never recovered | 5,522 | $16 med $0 · n 5,228 | $45 med $0 · n 4,898 | $74 med $0 · n 4,545 | $95 med $0 · n 4,250 | $113 med $0 · n 3,933 | $135 med $0 · n 3,556 | $184 med $0 · n 2,601 | $207 med $0 · n 1,631 |
| Missed — recovered within 10 days | 1,442 | $270 med $220 · n 1,373 | $390 med $296 · n 1,279 | $489 med $350 · n 1,169 | $584 med $433 · n 1,064 | $661 med $494 · n 972 | $731 med $530 · n 861 | $957 med $662 · n 576 | $1,152 med $850 · n 297 |
| Paid first time | 7,751 | $43 med $0 · n 7,378 | $177 med $165 · n 6,947 | $315 med $266 · n 6,436 | $436 med $358 · n 5,941 | $542 med $441 · n 5,463 | $653 med $525 · n 4,974 | $951 med $758 · n 3,527 | $1,143 med $897 · n 2,019 |
A band like “under six months” mixes a five-month-old April cohort with a two-week-old September one and tells you nothing about either. So this is every opening month against the horizons it has actually reached — average banked per agreement, blank where that month has not lived long enough or has fewer than 25 agreements at that horizon. The last column says how far each cohort can honestly be read.
| Month opened | Agreements | Paid first time | day 30 | day 60 | day 90 | day 120 | day 150 | day 180 | day 270 | day 365 | Readable |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2026-11 | 316 | 53.5% | — | — | — | — | — | — | — | — | too young |
| 2026-10 | 845 | 52.1% | $164 | — | — | — | — | — | — | — | to day 30 |
| 2026-09 | 904 | 51.2% | $176 | $251 | — | — | — | — | — | — | to day 60 |
| 2026-08 | 972 | 52.1% | $161 | $257 | $383 | — | — | — | — | — | to day 90 |
| 2026-07 | 947 | 56.3% | $149 | $250 | $338 | $413 | — | — | — | — | to day 120 |
| 2026-06 | 992 | 51.0% | $189 | $254 | $338 | $409 | $465 | — | — | — | to day 150 |
| 2026-05 | 822 | 49.3% | $140 | $232 | $316 | $391 | $453 | $559 | — | — | to day 180 |
| 2026-04 | 1,022 | 52.3% | $186 | $251 | $334 | $409 | $479 | $545 | — | — | to day 180 |
| 2026-03 | 924 | 56.8% | $158 | $263 | $351 | $439 | $510 | $572 | — | — | to day 180 |
| 2026-02 | 824 | 56.7% | $282 | $382 | $479 | $543 | $615 | $656 | $871 | — | to day 270 |
| 2026-01 | 849 | 52.8% | $167 | $343 | $422 | $497 | $537 | $609 | $774 | — | to day 270 |
| 2025-12 | 886 | 53.2% | $144 | $256 | $373 | $425 | $495 | $565 | $737 | — | to day 270 |
| 2025-11 | 876 | 53.7% | $201 | $258 | $355 | $474 | $521 | $598 | $782 | $840 | to day 365 |
| 2025-10 | 935 | 51.9% | $150 | $249 | $341 | $428 | $510 | $587 | $779 | $887 | to day 365 |
| 2025-09 | 930 | 50.3% | $186 | $243 | $325 | $408 | $478 | $550 | $725 | $840 | to day 365 |
| 2025-08 | 806 | 50.9% | $159 | $257 | $347 | $425 | $498 | $570 | $763 | $885 | to day 365 |
| 2025-07 | 865 | 52.1% | $151 | $256 | $363 | $449 | $529 | $601 | $796 | $912 | to day 365 |
Anything under three months is shown but should not be read as an outcome — it has barely started.
| Account age | Opening instalment | Share of band | by day 30 | by day 60 | by day 90 | by day 120 | by day 150 | by day 180 | by day 270 | by day 365 |
|---|---|---|---|---|---|---|---|---|---|---|
| Under 3 months (too young to read) | Missed — never recovered | 988 37.9% | $14 n 694 | $32 n 364 | — | — | — | — | — | — |
| Under 3 months (too young to read) | Missed — recovered within 10 days | 279 10.7% | $250 n 210 | $359 n 116 | — | — | — | — | — | — |
| Under 3 months (too young to read) | Paid first time | 1,337 51.3% | $257 n 964 | $365 n 533 | — | — | — | — | — | — |
| 3 to 6 months | Missed — never recovered | 997 36.0% | $13 n 997 | $38 n 997 | $61 n 997 | $78 n 713 | $91 n 396 | — | — | — |
| 3 to 6 months | Missed — recovered within 10 days | 308 11.1% | $257 n 308 | $366 n 308 | $461 n 308 | $566 n 209 | $647 n 117 | — | — | — |
| 3 to 6 months | Paid first time | 1,465 52.9% | $247 n 1,465 | $372 n 1,465 | $500 n 1,465 | $596 n 992 | $671 n 514 | $922 n 25 | — | — |
| 6 to 12 months | Missed — never recovered | 1,906 35.3% | $21 n 1,906 | $56 n 1,906 | $84 n 1,906 | $104 n 1,906 | $120 n 1,906 | $138 n 1,906 | $200 n 970 | — |
| 6 to 12 months | Missed — recovered within 10 days | 558 10.3% | $267 n 558 | $386 n 558 | $479 n 558 | $557 n 558 | $625 n 558 | $689 n 558 | $889 n 279 | — |
| 6 to 12 months | Paid first time | 2,930 54.3% | $277 n 2,930 | $423 n 2,930 | $558 n 2,930 | $671 n 2,930 | $766 n 2,930 | $861 n 2,930 | $1,150 n 1,508 | — |
| 1 year or older | Missed — never recovered | 1,631 41.3% | $14 n 1,631 | $41 n 1,631 | $70 n 1,631 | $92 n 1,631 | $112 n 1,631 | $133 n 1,631 | $175 n 1,631 | $207 n 1,631 |
| 1 year or older | Missed — recovered within 10 days | 297 7.5% | $307 n 297 | $433 n 297 | $541 n 297 | $647 n 297 | $734 n 297 | $814 n 297 | $1,021 n 297 | $1,152 n 297 |
| 1 year or older | Paid first time | 2,019 51.2% | $265 n 2,019 | $393 n 2,019 | $535 n 2,019 | $671 n 2,019 | $785 n 2,019 | $900 n 2,019 | $1,200 n 2,019 | $1,376 n 2,019 |
| Month opened | Agreements | Missed, never recovered | Recovered ≤10d | Paid first time |
|---|---|---|---|---|
| 2025-07 | 865 | 349 40.3% | 65 7.5% | 451 52.1% |
| 2025-08 | 806 | 328 40.7% | 68 8.4% | 410 50.9% |
| 2025-09 | 930 | 387 41.6% | 75 8.1% | 468 50.3% |
| 2025-10 | 935 | 388 41.5% | 62 6.6% | 485 51.9% |
| 2025-11 | 876 | 346 39.5% | 60 6.8% | 470 53.7% |
| 2025-12 | 886 | 330 37.2% | 85 9.6% | 471 53.2% |
| 2026-01 | 849 | 304 35.8% | 97 11.4% | 448 52.8% |
| 2026-02 | 824 | 261 31.7% | 96 11.7% | 467 56.7% |
| 2026-03 | 924 | 290 31.4% | 109 11.8% | 525 56.8% |
| 2026-04 | 1,022 | 393 38.5% | 95 9.3% | 534 52.3% |
| 2026-05 | 822 | 342 41.6% | 75 9.1% | 405 49.3% |
| 2026-06 | 992 | 356 35.9% | 130 13.1% | 506 51.0% |
| 2026-07 | 947 | 316 33.4% | 98 10.3% | 533 56.3% |
| 2026-08 | 972 | 357 36.7% | 109 11.2% | 506 52.1% |
| 2026-09 | 904 | 342 37.8% | 99 11.0% | 463 51.2% |
| 2026-10 | 845 | 306 36.2% | 99 11.7% | 440 52.1% |
| 2026-11 | 316 | 127 40.2% | 20 6.3% | 169 53.5% |
| City | Agreements | Missed, never recovered | Recovered ≤10d | Paid first time | Avg banked by day 365 |
|---|---|---|---|---|---|
| Texas | 4,272 | 1,780 41.7% | 404 9.5% | 2,088 48.9% | $851 n 1,283 |
| New York | 2,638 | 1,091 41.4% | 223 8.5% | 1,324 50.2% | $802 n 973 |
| Florida | 2,619 | 908 34.7% | 246 9.4% | 1,465 55.9% | $1,032 n 503 |
| Nashville | 1,852 | 625 33.7% | 215 11.6% | 1,012 54.6% | $831 n 506 |
| Chicago | 1,818 | 655 36.0% | 196 10.8% | 967 53.2% | $880 n 251 |
| Boston | 1,516 | 463 30.5% | 158 10.4% | 895 59.0% | $984 n 431 |
The opening instalment is a customer’s first charge on the RECURRING book. Studio deposits and studio-sale payments are excluded outright — a card handed over at a till is a different event from a stored card charged a month later with nobody present.
The three groups. Paid first time = the opening charge completed. Recovered = it failed but money was banked within 10 days. Never recovered = it failed and nothing came in inside that window — note this does not mean the agreement never paid again, only that the opening miss was not caught quickly.
Age-matching is the whole method. Collection is counted from each agreement’s own opening date, and an agreement enters a horizon only if it has that many days of runway behind it. Without this, a young account looks like a total loss at 365 days when in truth the 365th day has not happened yet — and every recent cohort would drag the averages down.
Lookback 6 months. A charge only counts as an opening if nothing was seen from that customer in the preceding 6 months, so the earliest opening this report can judge is 2025-07-02.
Why not the CRM finance schedule. schedules.json was fetched 2026-08-07 and its newest line is 2026-08-06, so it cannot see the youngest accounts at all — the opposite of what was asked for. It also files refunds and chargebacks as payment_debit rows (“Refund” 996, “Chargeback” 1,571), so a naive sum counts money going out as money collected. Square is current to 2026-11-17 and cleanly typed.
Read this run: 329,951 raw lines, 14,842 repeat payment ids dropped, 116,441 non-recurring charges excluded, 2,324 with no customer id — leaving 196,344 recurring charges spanning 2025-01-01 → 2026-11-17, and 14,715 judgeable openings.