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.
plan_length_suspect in the CSV. Everything else about those agreements still counts.
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.
| City | Agreements | Sale value | Finance written | Payments planned | Payments taken | Declines | Collected | Collected % | 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 |
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.
| Year | Agreements | Sale value | Finance written | Payments planned | Payments taken | Declines | Collected | Collected % | 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 |
The count Neil asked for, as a distribution. 16,880 agreements (27.0%) never made a single finance payment after the deposit.
| Payments landed | Agreements | Finance written | Share of book | Collected | Outstanding | 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 |
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 for | Agreements | Avg payments taken | Paid in full | Finance written | Collected | 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 |
34,714 agreements carry a balance — $54.75M outstanding. This is the chase list in aggregate; the row-level detail is in the CSV.
| City | Agreements | Sale value | Finance written | Payments planned | Payments taken | Declines | Collected | Collected % | 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 |
| Payments landed | Agreements | Finance written | Share of book | Collected | Outstanding | 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.