Share:

The opening payment — three outcomes, and what each is worth

First instalment of the recurring series · 14,715 agreements opened 2025-07-02 → 2026-11-17 · every figure age-matched, with its own n
Missed — never recovered
37.5%
Missed — back within 10 days
9.8%
Paid first time
52.7%
A recovered miss is worth this much of a clean payer, by day 365
84%

The split

6,964 of 14,715 agreements (47.3%) miss the opening instalment. Of those, 1,442 (20.7%) are back within 10 days.

Opening instalmentAgreementsShare of allBanked by day 365Mediann with 365 days behind it
Missed — never recovered5,5225,522 37.5%$207$01,631
Missed — recovered within 10 days1,4421,442 9.8%$1,152$850297
Paid first time7,7517,751 52.7%$1,376$1,1042,019

What happens to the ones we recover inside 10 days

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 atMissed, never recoveredRecovered ≤10dPaid first timeMiss as % of paidRecovered as % of paidn (paid)
Day 30$16$270$2656%102%7,378
Day 60$45$390$39911%98%6,947
Day 90$74$489$53814%91%6,436
Day 120$95$584$65914%89%5,941
Day 150$113$661$76415%86%5,463
Day 180$135$731$87715%83%4,974
Day 270$184$957$1,17816%81%3,527
Day 365$207$1,152$1,37615%84%2,019

Row detail is in the CSV, never on this page — agreements.csv.

Average banked per agreement, by day

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 instalmentAgreementsby day 30by day 60by day 90by day 120by day 150by day 180by day 270by day 365
Missed — never recovered5,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 days1,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 time7,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

The same, excluding the opening payment itself

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 instalmentAgreementsby day 30by day 60by day 90by day 120by day 150by day 180by day 270by day 365
Missed — never recovered5,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 days1,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 time7,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

Split by how old the account is

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 openedAgreementsPaid first timeday 30day 60day 90day 120day 150day 180day 270day 365Readable
2026-1131653.5%————————too young
2026-1084552.1%$164———————to day 30
2026-0990451.2%$176$251——————to day 60
2026-0897252.1%$161$257$383—————to day 90
2026-0794756.3%$149$250$338$413————to day 120
2026-0699251.0%$189$254$338$409$465———to day 150
2026-0582249.3%$140$232$316$391$453$559——to day 180
2026-041,02252.3%$186$251$334$409$479$545——to day 180
2026-0392456.8%$158$263$351$439$510$572——to day 180
2026-0282456.7%$282$382$479$543$615$656$871—to day 270
2026-0184952.8%$167$343$422$497$537$609$774—to day 270
2025-1288653.2%$144$256$373$425$495$565$737—to day 270
2025-1187653.7%$201$258$355$474$521$598$782$840to day 365
2025-1093551.9%$150$249$341$428$510$587$779$887to day 365
2025-0993050.3%$186$243$325$408$478$550$725$840to day 365
2025-0880650.9%$159$257$347$425$498$570$763$885to day 365
2025-0786552.1%$151$256$363$449$529$601$796$912to day 365

The same, grouped into age bands

Anything under three months is shown but should not be read as an outcome — it has barely started.

Account ageOpening instalmentShare of bandby day 30by day 60by day 90by day 120by day 150by day 180by day 270by day 365
Under 3 months (too young to read)Missed — never recovered988 37.9%$14 n 694$32 n 364——————
Under 3 months (too young to read)Missed — recovered within 10 days279 10.7%$250 n 210$359 n 116——————
Under 3 months (too young to read)Paid first time1,337 51.3%$257 n 964$365 n 533——————
3 to 6 monthsMissed — never recovered997 36.0%$13 n 997$38 n 997$61 n 997$78 n 713$91 n 396———
3 to 6 monthsMissed — recovered within 10 days308 11.1%$257 n 308$366 n 308$461 n 308$566 n 209$647 n 117———
3 to 6 monthsPaid first time1,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 monthsMissed — never recovered1,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 monthsMissed — recovered within 10 days558 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 monthsPaid first time2,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 olderMissed — never recovered1,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 olderMissed — recovered within 10 days297 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 olderPaid first time2,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

Every opening month, so you can see it is not one odd cohort

Month openedAgreementsMissed, never recoveredRecovered ≤10dPaid first time
2025-07865349 40.3%65 7.5%451 52.1%
2025-08806328 40.7%68 8.4%410 50.9%
2025-09930387 41.6%75 8.1%468 50.3%
2025-10935388 41.5%62 6.6%485 51.9%
2025-11876346 39.5%60 6.8%470 53.7%
2025-12886330 37.2%85 9.6%471 53.2%
2026-01849304 35.8%97 11.4%448 52.8%
2026-02824261 31.7%96 11.7%467 56.7%
2026-03924290 31.4%109 11.8%525 56.8%
2026-041,022393 38.5%95 9.3%534 52.3%
2026-05822342 41.6%75 9.1%405 49.3%
2026-06992356 35.9%130 13.1%506 51.0%
2026-07947316 33.4%98 10.3%533 56.3%
2026-08972357 36.7%109 11.2%506 52.1%
2026-09904342 37.8%99 11.0%463 51.2%
2026-10845306 36.2%99 11.7%440 52.1%
2026-11316127 40.2%20 6.3%169 53.5%

By city

CityAgreementsMissed, never recoveredRecovered ≤10dPaid first timeAvg banked by day 365
Texas4,2721,780 41.7%404 9.5%2,088 48.9%$851 n 1,283
New York2,6381,091 41.4%223 8.5%1,324 50.2%$802 n 973
Florida2,619908 34.7%246 9.4%1,465 55.9%$1,032 n 503
Nashville1,852625 33.7%215 11.6%1,012 54.6%$831 n 506
Chicago1,818655 36.0%196 10.8%967 53.2%$880 n 251
Boston1,516463 30.5%158 10.4%895 59.0%$984 n 431

How this is built

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.