Share:

Sales & Payments

Every finance agreement in the CRM Debtor Ledger — what was sold, how many payments actually landed against it, and what is still owed. 62,466 agreements across all studios, shoots from 2019 to 2026. Payment counts come from each booking's own finance schedule, so they are not capped at 12.

Agreements
62,466
Sale value
$164.33M
Finance written
$132.68M
Collected
$56.31M
Credits / write-offs
$21.87M
Outstanding
$54.51M
Payments taken
235,752
Declines
241,369
Card details are not on this report yet. Neither the Debtor Ledger nor the finance schedules carry a card, so the card columns in the CSV are present but empty. Filling them needs the CRM's recurring/card-on-file export (the one shown on the 12 Aug call) or a Square customer sweep. When wired they will show brand, last 4 and expiry only — not the full card number, and never the 3-digit security code, which must not be retained after a payment is authorised.
Three things the CRM data does that you should know before reading the tables.

1 — 75 mis-keyed plan lengths. Somebody typed the dollar amount into Number of Payments: A1595860 claims 500,000 payments against $1,000 of finance, and the rest follow the same tell (the count equals the finance figure). That is 0.1% of the book, but it held 543,115 of 1,099,336 raw planned payments — more than half. Anything above 60 is excluded from the "payments planned" column and from Plan vs delivered, and flagged plan_length_suspect in the CSV. Everything else about those agreements still counts.

2 — 347 agreements have no plan length recorded at all (0.6%). Same treatment: out of the planned column, in everywhere else.

3 — 939 agreements collected a negative amount ($-437,842 in total): money that went back out as a refund or reversal after the finance was written. That is the ledger's own figure, not an error, and it is why the "None" row on the payments tab shows collected below zero.

Every agreement, by city

Payments taken is counted against payments planned, so the percentage reads as "how much of the plan actually ran". Declines are shown against total attempts.

CityAgreementsSale value Finance writtenPayments planned Payments takenDeclines CollectedCollected %Outstanding
Florida 9,241 $25.20M $20.03M 78,811 37,111 46.9% 40,662 52.3% $9.66M 48.2% $7.30M
Orlando 1,224 $3.61M $2.92M 13,549 2,113 15.6% 1,952 48.0% $458,125 15.7% $2.32M
New York 23,046 $62.54M $51.19M 189,658 83,476 43.6% 89,950 51.9% $22.70M 44.4% $16.42M
Dallas 6,373 $16.62M $13.54M 62,217 25,944 41.6% 23,866 47.9% $5.40M 39.9% $6.80M
Houston 5,727 $15.08M $12.14M 53,271 21,274 39.9% 21,058 49.7% $4.64M 38.2% $6.31M
Boston 4,246 $10.51M $8.04M 38,446 19,497 50.5% 14,901 43.3% $3.80M 47.3% $3.64M
Nashville 3,021 $7.40M $6.05M 30,393 11,280 37.1% 11,827 51.2% $2.17M 35.9% $3.64M
Chicago 1,999 $5.14M $4.04M 20,757 5,496 26.5% 5,939 51.9% $1.04M 25.8% $2.86M
Atlanta 7,589 $18.21M $14.73M 69,119 29,561 42.6% 31,214 51.4% $6.44M 43.7% $5.21M
TOTAL 62,466 $164.33M $132.68M 556,221 235,752 42.2% 241,369 50.6% $56.31M 42.4% $54.51M

By year of sale

An agreement belongs to the year of its shoot — the day the finance was written. Recent years collect less simply because their plans are still running.

YearAgreementsSale value Finance writtenPayments planned Payments takenDeclines CollectedCollected %Outstanding
2026 9,661 $26.70M $21.52M 100,149 20,201 20.1% 19,495 49.1% $4.07M 18.9% $16.45M
2025 10,986 $28.56M $22.98M 106,256 48,358 45.5% 59,211 55.0% $9.83M 42.8% $11.75M
2024 11,053 $26.89M $21.30M 100,263 52,491 52.3% 45,241 46.3% $10.57M 49.6% $8.94M
2023 9,669 $25.19M $20.47M 86,916 40,772 46.4% 29,682 42.1% $9.61M 47.0% $5.96M
2022 8,164 $24.20M $19.90M 66,946 27,945 41.3% 22,940 45.1% $8.47M 42.6% $4.98M
2021 7,361 $21.43M $17.57M 56,833 25,075 44.0% 31,489 55.7% $8.47M 48.2% $4.31M
2020 3,093 $7.15M $5.63M 21,593 11,362 52.3% 15,341 57.5% $3.29M 58.5% $1.29M
2019 2,479 $4.20M $3.32M 17,265 9,548 53.9% 17,970 65.3% $1.99M 60.0% $834,569
TOTAL 62,466 $164.33M $132.68M 556,221 235,752 42.2% 241,369 50.6% $56.31M 42.4% $54.51M

How many payments landed

The count Neil asked for, as a distribution. 16,880 agreements (27.0%) never made a single finance payment after the deposit.

Payments landedAgreementsFinance written Share of bookCollectedOutstanding Collected %Avg payments
None 16,880 27.0% $36.35M 27.4% $-365,269 $27.34M -1.0% 0.0
1 10,838 17.4% $22.02M 16.6% $6.25M $11.64M 28.4% 1.0
2 6,211 9.9% $12.24M 9.2% $4.56M $5.62M 37.3% 2.0
3–5 10,762 17.2% $21.41M 16.1% $11.30M $7.04M 52.8% 3.8
6–9 8,261 13.2% $17.97M 13.5% $13.60M $2.41M 75.7% 7.3
10–11 5,278 8.4% $12.17M 9.2% $11.24M $301,506 92.4% 10.2
12+ 4,236 6.8% $10.52M 7.9% $9.72M $160,295 92.4% 13.5

What the plan was written for vs what landed

Read the first two columns together: a 10-payment plan averaging 3.4 taken is a 10-payment plan that mostly did not run.

Payments the plan was written forAgreements Avg payments takenPaid in full Finance writtenCollected Collected %Outstanding
1 3,221 1.3 2,194 68.1% $4.59M $2.30M 50.1% $1.41M
2 2,181 1.6 1,494 68.5% $2.24M $1.27M 56.9% $551,847
3 2,375 2.1 1,646 69.3% $3.20M $1.92M 60.0% $655,267
4 2,396 2.4 1,420 59.3% $2.67M $1.48M 55.2% $698,910
5 1,452 2.8 862 59.4% $2.13M $1.14M 53.4% $585,725
6 5,343 3.1 3,177 59.5% $9.10M $4.73M 52.0% $2.57M
7 1,262 3.2 786 62.3% $3.40M $1.44M 42.4% $901,079
8 2,363 3.9 1,259 53.3% $4.36M $2.14M 49.1% $1.41M
9 1,289 4.0 738 57.3% $3.04M $1.22M 40.0% $940,992
10 16,441 4.6 6,874 41.8% $37.43M $16.88M 45.1% $16.28M
11 254 5.3 139 54.7% $640,464 $306,264 47.8% $200,668
12+ 23,467 4.3 8,996 38.3% $59.32M $21.22M 35.8% $28.15M

Still owing

34,714 agreements carry a balance — $54.75M outstanding. This is the chase list in aggregate; the row-level detail is in the CSV.

CityAgreementsSale value Finance writtenPayments planned Payments takenDeclines CollectedCollected %Outstanding
Florida 4,577 $13.10M $10.66M 42,558 12,728 29.8% 29,171 69.6% $2.71M 25.4% $7.35M
Orlando 1,163 $3.44M $2.81M 13,098 2,010 15.3% 1,923 48.9% $408,322 14.5% $2.32M
New York 10,542 $29.00M $24.28M 97,211 28,603 29.2% 62,622 68.6% $5.98M 24.6% $16.54M
Dallas 4,250 $11.30M $9.35M 42,486 11,561 27.1% 19,469 62.7% $2.17M 23.3% $6.81M
Houston 3,837 $10.17M $8.35M 37,412 9,081 24.3% 17,698 66.1% $1.70M 20.4% $6.32M
Boston 2,507 $6.41M $5.05M 24,098 6,876 28.5% 11,442 62.5% $1.22M 24.2% $3.65M
Nashville 2,332 $5.74M $4.77M 24,236 6,003 24.8% 10,399 63.4% $1.04M 21.8% $3.64M
Chicago 1,769 $4.66M $3.69M 19,018 4,229 22.2% 5,661 57.2% $760,625 20.6% $2.86M
Atlanta 3,737 $8.86M $7.35M 35,900 9,463 26.3% 21,279 69.2% $1.55M 21.1% $5.25M
TOTAL 34,714 $92.68M $76.30M 336,017 90,554 26.8% 179,664 66.5% $17.55M 23.0% $54.75M

Still owing, by payments made

Payments landedAgreementsFinance written Share of bookCollectedOutstanding Collected %Avg payments
None 13,334 38.4% $28.17M 36.9% $-125,345 $27.35M -0.4% 0.0
1 6,214 17.9% $13.50M 17.7% $1.22M $11.67M 9.0% 1.0
2 3,425 9.9% $7.59M 9.9% $1.38M $5.68M 18.2% 2.0
3–5 5,612 16.2% $12.38M 16.2% $4.36M $7.10M 35.3% 3.8
6–9 3,818 11.0% $8.77M 11.5% $5.66M $2.45M 64.5% 7.3
10–11 1,050 3.0% $2.56M 3.4% $2.05M $315,611 80.3% 10.5
12+ 1,261 3.6% $3.33M 4.4% $3.00M $183,709 89.9% 13.6

Sources: Reports/finance_cohort/ledger.json (CRM Debtor Ledger) and Reports/finance_cohort/schedules.json (per-booking finance schedules). 21 agreements have no schedule and fall back to the ledger's own payment count, which caps at 12 — they are flagged payment_count_source=ledger in the CSV. Full row-level detail (62,466 rows — carries customer names and phones, so it needs the access key): Studio1_Sales_Payments.csv.