Share:

First payments — the first instalment of the recurring series

Three matched 08-01 → 10-31 windows across all six Square accounts · the RECURRING book only — studio deposits and studio-sale payments are excluded outright · 12 months of lookback on every window
First instalments, 2026-08-01 → 2026-10-31
2,722
Banked on first instalments
$410,022
Average first instalment
$220
First instalment failed
48.2%

Lookback warning. 2025 needs history back to 2024-08-01; 2024 needs history back to 2023-08-01, but the oldest charge on disk is 2025-01-01. Those windows count some returning customers as new, so their new-account count is OVERSTATED. Re-run once the backfill reaches 2023-08-01.

INCOMPLETE — do not read the 2025 or 2024 column yet. 5 of 6 trading locations have no charges at all before 2025-01-01, so the 2023–24 backfill has not finished. Everything before 2025 is UNDERSTATED, and unevenly by city. Missing: boston/L3TZS37RCY0QY, florida/D22KRWPAJQ3EE, nashville/LR0G5P980H0KE, newyork/F29PDT5T9ZPB7, texas/LE6G3FYRFNVFB. Re-run pull_square_backfill_2024.js, then rebuild this report.

The three windows side by side

Same calendar range each year: 08-01 → 10-31. Every window gets exactly 12 months of prior visibility before it, so a customer only counts as new if we saw nothing from them in the preceding year. Percentage rows compare in points, count and money rows in %.

Measure2026
2026-08-01 → 2026-10-31
2025
2025-08-01 → 2025-10-31
2024
2024-08-01 → 2024-10-31
vs last yrvs 2 yr
First instalments attempted2,7222,6710+1.9%—
  — like-for-like (studios open in all three windows)000——
First instalment went through51.8%51.0%0.0%+0.7pp+51.8pp
Money banked on first instalments$410,022$404,263$0+1.4%—
Average first instalment$220$236$0-6.9%—
Median first instalment$204$221$0-7.5%—
Paid again within 30 days7.6%9.7%0.0%-2.1pp+7.6pp
All recurring charges in the window30,97023,8480+29.9%—
First instalments as a share of all recurring charges8.8%11.2%0.0%-2.4pp+8.8pp

Not every studio existed in all three windows. Boston, Chicago, Florida, Nashville, New York, Texas each have a studio that opened after 2024-10-31 (6 locations), so part of the headline growth is estate, not demand. The like-for-like row above counts only the 0 studios trading in all three windows: 2026 0 · 2025 0 · 2024 0.

Row-level detail is in the CSV, never on this page — new_accounts.csv.

First instalments by Square account

All six Square merchant accounts. “1st charge OK” is the share whose very first attempt went through rather than failing and needing a retry.

City2026 1st instalments2026 banked2026 1st OK2025 1st instalments2025 banked2025 1st OK2024 1st instalments2024 banked2024 1st OK1st instalments vs last yr
Texas746 27.4%$92,83145.8%856 32.0%$139,79447.1%0 0.0%$00.0%-12.9%
Florida666 24.5%$104,18353.0%316 11.8%$52,08654.4%0 0.0%$00.0%+110.8%
Chicago370 13.6%$58,80455.7%207 7.7%$28,28354.1%0 0.0%$00.0%+78.7%
New York326 12.0%$56,93346.9%650 24.3%$89,96348.6%0 0.0%$00.0%-49.8%
Nashville309 11.4%$44,78657.6%358 13.4%$52,48553.9%0 0.0%$00.0%-13.7%
Boston305 11.2%$52,48558.0%284 10.6%$41,65158.8%0 0.0%$00.0%+7.4%
TOTAL2,722$410,02251.8%2,671$404,26351.0%0$00.0%+1.9%

How big is the first instalment

Banded on the first charge we actually banked. An account whose first charge never went through at all is in the counts but contributes no value.

First payment size2026 1st instalments2026 banked2026 1st OK2025 1st instalments2025 banked2025 1st OK2024 1st instalments2024 banked2024 1st OK1st instalments vs last yr
Under $100398 14.6%$25,09076.9%259 9.7%$17,11080.3%0 0.0%$00.0%+53.7%
$100 – $249860 31.6%$153,87074.0%791 29.6%$146,13979.1%0 0.0%$00.0%+8.7%
$250 – $499564 20.7%$164,55077.1%620 23.2%$181,73079.8%0 0.0%$00.0%-9.0%
$500 – $99916 0.6%$9,81287.5%18 0.7%$12,60466.7%0 0.0%$00.0%-11.1%
$1,000 – $1,99914 0.5%$17,75071.4%16 0.6%$23,730100.0%0 0.0%$00.0%-12.5%
$2,000 – $4,99914 0.5%$38,95057.1%9 0.3%$22,95066.7%0 0.0%$00.0%+55.6%
Never banked856 31.4%$00.0%958 35.9%$00.0%0 0.0%$00.0%-10.6%
TOTAL2,722$410,02251.8%2,671$404,26351.0%0$00.0%+1.9%

Card brand on the first instalment

Brand2026 1st instalments2026 banked2026 1st OK2025 1st instalments2025 banked2025 1st OK2024 1st instalments2024 banked2024 1st OK1st instalments vs last yr
VISA1,837 67.5%$273,40649.2%1,818 68.1%$267,26847.7%0 0.0%$00.0%+1.0%
MASTERCARD709 26.0%$104,62255.1%742 27.8%$116,63055.7%0 0.0%$00.0%-4.4%
DISCOVER121 4.4%$19,97357.0%58 2.2%$9,89969.0%0 0.0%$00.0%+108.6%
AMERICAN_EXPRESS54 2.0%$11,74983.3%49 1.8%$9,66979.6%0 0.0%$00.0%+10.2%
UNKNOWN1 0.0%$271100.0%4 0.1%$797100.0%0 0.0%$00.0%-75.0%
TOTAL2,722$410,02251.8%2,671$404,26351.0%0$00.0%+1.9%

How the first instalment was taken

KEYED and CONTACTLESS are someone standing in the studio. ON_FILE is a stored card charged later.

Entry method2026 1st instalments2026 banked2026 1st OK2025 1st instalments2025 banked2025 1st OK2024 1st instalments2024 banked2024 1st OK1st instalments vs last yr
ON_FILE2,655 97.5%$377,56750.8%2,615 97.9%$373,93150.1%0 0.0%$00.0%+1.5%
KEYED66 2.4%$32,18489.4%52 1.9%$29,53592.3%0 0.0%$00.0%+26.9%
UNKNOWN1 0.0%$271100.0%4 0.1%$797100.0%0 0.0%$00.0%-75.0%
TOTAL2,722$410,02251.8%2,671$404,26351.0%0$00.0%+1.9%

Debit vs credit is not in this dataset — the daily pull keeps the brand but discards card_type. That split is being built separately at /card-types.

When the first instalment fails

The issuer’s own reason on the first charge an account ever attempted. These are the worst declines we take — the customer has no payment history with us to fall back on.

Why the very first charge failed202620252024
TRANSACTION_LIMIT660 50.3%778 59.5%0 0.0%
GENERIC_DECLINE288 21.9%360 27.5%0 0.0%
INSUFFICIENT_FUNDS197 15.0%80 6.1%0 0.0%
CARDHOLDER_INSUFFICIENT_PERMISSIONS130 9.9%65 5.0%0 0.0%
INVALID_ACCOUNT15 1.1%18 1.4%0 0.0%
CARD_EXPIRED10 0.8%5 0.4%0 0.0%
PAN_FAILURE6 0.5%2 0.2%0 0.0%
ISSUER_INSTALLMENT_ERROR5 0.4%0 0.0%0 0.0%
PAYMENT_LIMIT_EXCEEDED1 0.1%0 0.0%0 0.0%
CVV_FAILURE1 0.1%0 0.0%0 0.0%
TOTAL failed first charges1,3131,3080

Every month in all three windows

MonthWindowNew accountsBankedAvg first payment1st charge OK
2026-082026973$160,226$16552.0%
2026-092026904$136,980$15251.2%
2026-102026845$112,815$13452.1%
2025-082025806$134,825$16750.9%
2025-092025930$138,205$14950.3%
2025-102025935$131,233$14051.9%

How this is built

A first payment here is the first instalment of the recurring series. Neil, 2 Sep 2026: “i dont mean the first card payment in the studio. i mean the first of the recurring series. discount the payment in the studio completely.” So the deposit and the studio-sale payment taken on the day are excluded outright — they are a different event with a different failure mode (someone at a till with a card in hand, versus a stored card charged a month later with nobody present). An agreement is counted in a window if its earliest RECURRING charge in [window start − 12 months, window end] falls inside the window.

Which locations count. Every city has one 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 is named Recurring NYC, and an exact match on “Recurring” silently drops the biggest city.

Is 12 months long enough? Measured, not assumed: on the newest window, stretching the lookback from 12 months to 36 (the full depth on disk) reclassifies 1 agreement out of 2,912 — 0.03%. A customer resuming a recurring plan after a year of complete silence is effectively nonexistent, so the 12-month test is not a compromise here, it is exact.

Why the lookback is fixed at 12 months. If 2026 got three years of lookback and 2024 got one, 2024 would show more new accounts purely because we cannot see far enough back to disqualify a returning customer. Equal lookback makes the three counts comparable by construction.

Paid again within 30 days is measured only on accounts that actually have 30 days of visible runway behind them. An account opened a fortnight before the data ends cannot show a 30-day follow-on, and leaving it in the denominator would drag the newest window down for a calendar reason rather than a business one.

Inputs. square_attempts.jsonl (2025-01-01 → now, the daily incremental pull) plus square_attempts_pre2025.jsonl (2023-06-01 → 2025-01-01, backfilled for this report because the canonical file does not reach 2024). 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), 0 before 2023-08-01, 16,722 with no customer id (cannot be tied to an account, so excluded), 102,043 studio deposits / studio-sale / office charges discarded, leaving 196,344 recurring charges spanning 2025-01-01 → 2026-11-17.

The 2023–2024 backfill file is missing. The two older windows cannot be trusted until pull_square_backfill_2024.js has run.