Share:

Instalment recovery — what a missed first or second instalment costs

The RECURRING book only — studio deposits and studio-sale payments are excluded outright · age-matched at fixed horizons, every cell states its n · agreements opened 2023-12-01 → 2026-11-17 · data on disk 2025-01-01 → 2026-11-17
Agreements in the cohort
25,767
Opening charge missed
47.0%
Missed openings banked within 10 days
18.7%
365-day gap per agreement
$845
1 · What do we collect from the people who miss the first instalment, and those who don’t?
Over 365 days from the opening charge, an agreement whose first instalment failed banks $355 on average (median $0, n = 7,064) against $1,199 (median $944, n = 7,912) where it went through — 30% of the paid group, a gap of $845 per agreement. 48.6% of the missed group bank something after the opening charge against 84.7% of the paid group.
2 · The same split on the second instalment
Measured the same way from the second instalment: a failed second banks $290 in the next 365 days (median $0, n = 6,061) against $1,123 where it went through (median $883, n = 7,128) — 26% of the paid group.
3 · How many missed first instalments do we get back inside ten days?
Of 12,010 missed opening charges with ten days of runway behind them, 2,243 (18.7%) are banked within ten days — $571,074. It is front-loaded: day 1 alone brings back 1,009 (8.4% of the population, 45% of everything the ten days ever return), day 3 is at 69%, and by day 7 92% of it is in. Days 8–10 add only 182 more. Push the window out and the returns keep coming but slowly — 25.3% by day 30, 42.0% by day 90, and 47.8% ever.

Which miss tells you more about the agreement

Same agreements, same measurement window (365 days from the opening charge), n = 13,974 — only the variable we split on changes, so the two separations are directly comparable. Splitting on the first instalment opens a gap of $889 per agreement (30% of the paid group); splitting on the second opens $940 (26%). The SECOND instalment is the sharper signal.

Split the same agreements on…GroupnMean collected in 365 daysMedian collectedInstalments bankedBanked anything after the opening charge
The FIRST instalmentFailed6,653$377$621.9051.6%
The FIRST instalmentPaid7,321$1,266$1,0216.1991.5%
The SECOND instalmentFailed6,468$338$291.7440.6%
The SECOND instalmentPaid7,506$1,277$1,0446.23100.0%

Row-level detail is in the CSVs, never on this page — agreements.csv (one row per agreement, with the horizons already computed) and recovery_curve.csv.

Collected within N days of the opening charge — missed vs banked

Money banked in the window that starts on the opening charge, including that charge itself when it went through. An agreement only enters a horizon if it has that many days of visible runway behind it (opening date + N ≤ 2026-11-17), which is why n shrinks as the horizon lengthens — that shrinkage is the age-matching doing its job. Paid again is the share that banked at least one charge after the opening attempt.

Horizonn — opening missedn — opening paidMean collected — opening missedMean collected — opening paidFailed ÷ paidMedian — opening missedMedian — opening paidPaid again — opening missedPaid again — opening paidInstalments banked — opening missedInstalments banked — opening paid
30 days11,74613,267$66$2660.25×$0$23825.3%20.0%0.281.21
60 days11,30812,829$123$4280.29×$0$39037.1%76.1%0.562.00
90 days10,85912,335$161$5410.30×$0$49542.0%80.0%0.752.55
180 days9,56210,873$255$8550.30×$0$72948.1%83.9%1.244.07
365 days7,0647,912$355$1,1990.30×$0$94448.6%84.7%1.795.80

The control — take the opening charge out of both sides

For the missed group the opening charge banks nothing by construction, so part of the gap above is arithmetic rather than behaviour. This strips the opening charge out of both groups and asks only what came in afterwards. The gap survives it, which is what makes the finding behavioural: a missed opening charge is not one lost payment, it is a different agreement.

Horizonn — opening missedn — opening paidMean banked after — opening missedMean banked after — opening paidFailed ÷ paidMedian after — opening missedMedian after — opening paid
30 days11,74613,267$66$451.46×$0$0
60 days11,30812,829$123$2070.59×$0$196
90 days10,85912,335$161$3200.50×$0$283
180 days9,56210,873$255$6340.40×$0$520
365 days7,0647,912$355$9760.36×$0$735

The same split, month by month — 180-day horizon

So you can see it is not one odd month carrying the whole finding. Each row is the agreements that opened in that month and have 180 days of runway behind them.

Agreement openedFailed (n, % of month)Paid (n)Mean collected — failedMean collected — paidFailed ÷ paidPaid again — failedPaid again — paid
2025-012,987 48.2%3,216$245$8040.30×48.2%85.7%
2025-02403 41.7%564$295$8530.35×51.9%82.8%
2025-03400 41.0%575$314$9350.34×47.8%81.2%
2025-04495 47.9%539$264$8600.31×45.7%83.5%
2025-05421 44.1%533$275$8660.32×50.6%82.6%
2025-06438 48.9%457$252$8660.29×44.7%81.0%
2025-07419 47.3%466$264$9040.29×44.9%83.9%
2025-08396 49.1%410$251$8790.29×49.0%82.9%
2025-09462 49.7%468$239$8570.28×44.8%83.1%
2025-10450 48.1%485$215$9320.23×45.3%82.7%
2025-11406 46.3%470$223$9220.24×45.3%85.7%
2025-12415 46.8%471$254$8390.30×49.9%85.4%
2026-01401 47.2%448$312$8760.36×53.1%84.8%
2026-02357 43.3%468$308$9220.33×54.3%83.5%
2026-03399 43.2%525$249$8180.30×51.1%81.3%
2026-04488 47.7%534$217$8440.26×44.3%83.9%
2026-05225 48.0%244$259$8480.31×48.9%82.0%
TOTAL9,56210,873$255$8550.30×48.1%83.9%

Collected within N days of the second instalment — missed vs banked

Anchored on the second charge and its date, so the runway test moves with it. Only the 23,543 agreements that ever got a second attempt are in here — 2,224 never did, and they are counted separately in the combination table below rather than being folded in.

Horizonn — second missedn — second paidMean collected — second missedMean collected — second paidFailed ÷ paidMedian — second missedMedian — second paidPaid again — second missedPaid again — second paidInstalments banked — second missedInstalments banked — second paid
30 days10,37312,366$45$2830.16×$0$24518.1%31.6%0.211.33
60 days9,95411,899$83$4160.20×$0$38727.6%76.2%0.401.98
90 days9,58011,398$116$5460.21×$0$49632.8%80.7%0.572.62
180 days8,34410,064$195$8390.23×$0$72039.1%84.5%0.984.06
365 days6,0617,128$290$1,1230.26×$0$88340.7%85.5%1.525.52

The control — take the second charge out of both sides

Horizonn — second missedn — second paidMean banked after — second missedMean banked after — second paidFailed ÷ paidMedian after — second missedMedian after — second paid
30 days10,37312,366$45$690.65×$0$0
60 days9,95411,899$83$2020.41×$0$195
90 days9,58011,398$116$3320.35×$0$287
180 days8,34410,064$195$6230.31×$0$520
365 days6,0617,128$290$9060.32×$0$675

The combination is what predicts the book — 365 days from the opening charge

All four cells of the 2×2, plus the two agreements-we-never-re-attempted rows. Everything is measured over the same window from the same anchor, so the rows are comparable.

First instalment → second instalmentAgreements (n, share of book)Mean collected in 365 daysMedian collectedInstalments bankedBanked anything after the opening chargeTotal collected
Paid → paid5,515 36.8%$1,426$1,2356.94100.0%$7,865,691
Paid → failed1,806 12.1%$776$4423.9265.6%$1,401,432
Failed → paid1,991 13.3%$865$5854.26100.0%$1,722,001
Failed → failed4,662 31.1%$168$00.8930.9%$783,105
Paid → no second attempt591 3.9%$374$2201.000.0%$221,298
Failed → no second attempt411 2.7%$0$00.000.0%$0
TOTAL14,976$801$4373.9167.7%$11,993,527

The same combinations at 180 days

First instalment → second instalmentAgreements (n, share of book)Mean collected in 180 daysMedian collectedInstalments bankedBanked anything after the opening chargeTotal collected
Paid → paid7,606 37.2%$1,008$9754.8699.8%$7,665,722
Paid → failed2,439 11.9%$543$3252.6662.7%$1,323,976
Failed → paid2,812 13.8%$627$4463.00100.0%$1,763,221
Failed → failed6,305 30.9%$108$00.5428.3%$679,736
Paid → no second attempt828 4.1%$373$2211.000.0%$309,121
Failed → no second attempt445 2.2%$0$00.000.0%$0
TOTAL20,435$575$3442.7567.1%$11,741,775

Of the opening charges that miss, what comes back day by day

Population: 12,010 agreements whose opening charge failed and which have at least ten days of runway behind them. “Recovered” means a recurring charge for that customer was banked after the failed attempt — a same-day retry counts as day 1.

Day after the missed opening chargeRecovered that dayRecovered by this day (n, % of 12,010)Money banked by this dayStill unrecovered
Day 11,0091,009 8.4%$284,89911,001
Day 23181,327 11.0%$361,23510,683
Day 32161,543 12.8%$405,11810,467
Day 41851,728 14.4%$449,52810,282
Day 51261,854 15.4%$481,03510,156
Day 61101,964 16.4%$504,38610,046
Day 7972,061 17.2%$524,9779,949
Day 8782,139 17.8%$543,1029,871
Day 9502,189 18.2%$554,2239,821
Day 10542,243 18.7%$571,0749,767

Where it flattens: day 1 brings back 1,009, day 2 adds 318, day 3 adds 216. Measured against everything the ten-day window ever returns: day 1 is 45% of it, day 3 is 69%, day 5 is 83%, and day 7 is the first day past 90% — 92%. Days 8–10 together contribute 182 more recoveries (1.5% of the population). A 7-day chase window captures 92% of what a ten-day one would.

And after day 10

Each horizon has its own population, because a longer horizon needs more runway. The n column is that population, not a subset of the ten-day one.

HorizonMissed opening charges with this much runway (n)Recovered by then (n, %)
Within 15 days11,9782,492 20.8%
Within 20 days11,8652,610 22.0%
Within 30 days11,7462,969 25.3%
Within 60 days11,3084,190 37.1%
Within 90 days10,8594,556 42.0%
Within 180 days9,5624,596 48.1%
Ever, however long it took12,1145,785 47.8%

Split by why the opening charge was declined

This is where the action is. A limit or a funds decline is a timing problem and comes back on its own; a dead card is a data problem and never does, however long you chase it.

Why the opening charge was declinedMissed opening charges (n)Recovered by day 3Recovered by day 10Recovered by day 30n with 365d runwayMean collected in 365 daysBanked anything at all
TRANSACTION_LIMIT6,660829 12.4%1,245 18.7%1,703 26.0%4,080$36953.9%
GENERIC_DECLINE3,564453 12.7%616 17.3%801 22.9%2,443$32739.5%
INSUFFICIENT_FUNDS884139 15.7%213 24.1%260 30.9%247$44758.7%
CARDHOLDER_INSUFFICIENT_PERMISSIONS63681 12.7%113 17.8%133 21.7%123$30635.0%
CARD_EXPIRED8920 22.5%25 28.1%33 38.4%73$33047.9%
INVALID_ACCOUNT8710 11.5%13 14.9%17 20.5%33$21327.3%
PAN_FAILURE758 10.7%12 16.0%16 21.3%62$31953.2%
ISSUER_INSTALLMENT_ERROR80 0.0%0 0.0%0 0.0%1$00.0%
ADDRESS_VERIFICATION_FAILURE32 66.7%3 100.0%3 100.0%2$330100.0%
EXPIRATION_FAILURE10 0.0%0 0.0%0 0.0%0——
INSUFFICIENT_PERMISSIONS10 0.0%1 100.0%1 100.0%0——
PAYMENT_LIMIT_EXCEEDED10 0.0%1 100.0%1 100.0%0——
CVV_FAILURE11 100.0%1 100.0%1 100.0%0——
TOTAL12,01012.8%18.7%25.3%

Every Square account

All six merchant accounts, agreements opened 2023-12-01 onwards. The 365-day columns use only the agreements with 365 days of runway, so their n is smaller than the agreements-opened column — that is the age-matching, not a data gap.

Square accountAgreements openedOpening charge missedn failed with 365d runwayn paid with 365d runwayMean collected 365d — opening missedMean collected 365d — opening paidFailed ÷ paidRecovered within 10 days
Texas7,8804,007 50.9%2,4782,398$316$1,1590.27×665 16.7%
New York6,0722,967 48.9%2,1602,245$356$1,1970.30×494 16.7%
Florida4,2071,815 43.1%8821,207$405$1,2570.32×355 19.7%
Boston2,9501,191 40.4%7481,115$418$1,1310.37×255 21.6%
Nashville2,8401,283 45.2%681811$367$1,3040.28×282 22.3%
Chicago1,818851 46.8%115136$298$1,3720.22×192 23.1%
TOTAL25,76747.0%7,0647,912$355$1,1990.30×18.7%

A studio that opened recently has almost no 365-day runway. Chicago’s first recurring charge is 2025-08-14, so hardly any of its agreements are a year old yet and its 365-day columns are thin or empty — an em-dash means nobody qualifies, not that they paid nothing. Read Chicago on the agreements-opened, missed-opening and 10-day columns, which have no runway requirement.

What the issuer said on the opening charge, and what happened next

Same table as the recovery tab, kept here so the reason cut can be sorted and read on its own. Sort on “Recovered by day 10” to see which misses chase themselves and which need a new card before anything else is worth doing.

Why the opening charge was declinedMissed opening charges (n)Recovered by day 3Recovered by day 10Recovered by day 30n with 365d runwayMean collected in 365 daysBanked anything at all
TRANSACTION_LIMIT6,660829 12.4%1,245 18.7%1,703 26.0%4,080$36953.9%
GENERIC_DECLINE3,564453 12.7%616 17.3%801 22.9%2,443$32739.5%
INSUFFICIENT_FUNDS884139 15.7%213 24.1%260 30.9%247$44758.7%
CARDHOLDER_INSUFFICIENT_PERMISSIONS63681 12.7%113 17.8%133 21.7%123$30635.0%
CARD_EXPIRED8920 22.5%25 28.1%33 38.4%73$33047.9%
INVALID_ACCOUNT8710 11.5%13 14.9%17 20.5%33$21327.3%
PAN_FAILURE758 10.7%12 16.0%16 21.3%62$31953.2%
ISSUER_INSTALLMENT_ERROR80 0.0%0 0.0%0 0.0%1$00.0%
ADDRESS_VERIFICATION_FAILURE32 66.7%3 100.0%3 100.0%2$330100.0%
EXPIRATION_FAILURE10 0.0%0 0.0%0 0.0%0——
INSUFFICIENT_PERMISSIONS10 0.0%1 100.0%1 100.0%0——
PAYMENT_LIMIT_EXCEEDED10 0.0%1 100.0%1 100.0%0——
CVV_FAILURE11 100.0%1 100.0%1 100.0%0——
TOTAL12,01012.8%18.7%25.3%

Card brand on the missed opening charge

BrandMissed opening charges (n)Recovered by day 10n with 365d runwayMean collected in 365 days
VISA8,5301,589 18.6%5,049$337
MASTERCARD3,031552 18.2%1,822$381
DISCOVER31976 23.8%109$685
AMERICAN_EXPRESS13026 20.0%84$419

How this is built

The recurring book only. A sale is a deposit or studio-sale taken at the till on the day, then a finance agreement charged monthly against a stored card. Two different events, two different failure modes. This report is entirely about the second: the recurring location, matched on the location NAME with /^Recurring/i (the canonical rule in lib/square.js). The prefix match is required rather than an exact compare because New York’s location is called Recurring NYC, and an exact match on “Recurring” silently drops the biggest city. Deposits, studio sales and office charges are excluded outright — 116,441 rows dropped on this run.

An agreement is a customer’s run of recurring charges. A new one opens on a charge with no recurring charge from that customer in the preceding 12 months — the same test /first-payments settled. The first instalment is that opening charge; the second instalment is the next attempt after it inside the same agreement. Charges belong to the agreement that was open when they landed, so a customer who comes back years later never has their old plan’s money counted against the new one.

Failed means the attempt carries status: FAILED; paid means COMPLETED. Where an opening attempt failed and a retry the same day went through, the agreement is in the failed group (the first attempt by timestamp is what decides it) and the retry shows up as a day-1 recovery.

Age-matching — the whole methodological point. An agreement opened in Dec 2023 has had nearly three years to pay; one opened three weeks ago has had three weeks. Comparing raw lifetime collected between the two groups measures the calendar, not behaviour. So every figure here is collected within N days of an anchor charge, and an agreement only enters a horizon if it has N days of visible runway behind it — anchor date + N ≤ 2026-11-17, the newest charge on disk. Horizons: 30 / 60 / 90 / 180 / 365 days. Every cell states its n, and the n shrinks as the horizon lengthens because fewer agreements are old enough to qualify.

Per-agreement figures only. Mean and median collected, share that ever bank again, instalments banked. A raw total across groups of different sizes would say nothing, so totals appear only where the group size is stated beside them.

Why the cohort starts 2023-12-01. The data begins 2025-01-01, so a charge in that first month has no prior visibility and mid-series charges get misread as agreement openings — 1,790 apparent openings in 2023-06 against a ~600/month baseline either side. Starting the cohort at 2023-12-01 gives every agreement in it at least six months of prior visibility. 0 earlier agreement openings are excluded.

What six months of lookback costs, measured rather than assumed. Over 2026-01-01 → 2026-11-17, where a full 12 months of prior history genuinely exists, the number of agreement openings found is: 3 months of lookback 9,815, 6 months 9,464, 12 months 9,415, 24 months 9,411, 36 months 9,411. Six months over-counts by 0.5% against twelve, and twelve over-counts by 0.0% against the full depth on disk. A customer resuming a recurring plan after a year of silence is effectively nonexistent, so 12 months is not a compromise and 6 months at the cohort edge is a rounding error.

Inputs. square_attempts.jsonl (2025-01-01 → now, the daily incremental pull) plus square_attempts_pre2025.jsonl (2023-06-01 → 2025-01-01, the backfill). Both are /v2/payments looped per location — that endpoint returns the default location only otherwise. No Square or CRM call is made at report time.

Read this run: 329,951 raw lines → 315,109 unique payment ids (14,842 repeat lines dropped), 116,441 studio deposit / studio-sale / office charges discarded, 2,324 recurring charges with no customer id excluded because they cannot be tied to an agreement (1.2% of the recurring book — see the caveat below), leaving 196,344 recurring charges spanning 2025-01-01 → 2026-11-17, which resolve to 25,767 agreements, 25,767 of them in the cohort.

The one caveat worth knowing. The 2,324 excluded no-customer-id rows are not a random slice: 2,323 of them (100.0%) are declines and only 1 were banked, for $1 in total — so they cannot move a single collected figure on this page. They are concentrated in the older data (2025: 1,317, 2026: 1,007). Where one of them was genuinely an agreement’s opening attempt, that agreement is credited with a later, successful charge as its opening and lands in the paid group while behaving like a failed one. That drags the paid group’s average down, so the gap reported here is if anything an understatement — it cannot be an artefact of this exclusion.

Every n on the page. Cohort 25,767 · opening charge missed 12,114 · opening charge paid 13,653 · ever got a second attempt 23,543 · 365d runway from the opening charge 14,976 (missed 7,064, paid 7,912) · 365d runway from the second 13,189 (missed 6,061, paid 7,128) · 10-day recovery population 12,010 · first-vs-second prediction cohort 13,974.