Total revenue — every sale, and what happened to the money
40,014 sales since Jan 2024 · $101,656,242 booked · financed AND paid in full ·
built 2026-11-17T19:04:39.476Z
Revenue booked
$101,656,242
Banked on the day
$35,912,898 35.3%
Finance collected
$24,373,290 24.0%
Total banked
$60,286,188 59.3%
Written off
$4,182,350 4.1%
Still owed
$37,150,774 36.5%
Every month of sales — all revenue, not just the financed part
What this is. One row per month of sales. Everything sold that month, what has been banked against it, and what is still out.
How it is worked out. Sales and prices come from the CRM daily sales report; deposits are its Total Deposit column. Instalments are the dated payment lines on each booking’s finance schedule, matched by Reference. Written off and still owed come from the Debtor Ledger. Revenue = banked + written off + overdue + not yet due, and the Check column proves it on every row.
Watch out. This tab counts every sale including ones of $300 or less. The Deposit and KIDS X tabs exclude those.
This is the one report that includes customers who paid in full on the day. They never create a
finance agreement, so they are absent from the Debtor Ledger and from
/finance-cohort entirely —
8,983 sales worth $19,563,998 since Jan 2024.
Here the denominator is all revenue booked and the clock starts at day 1 with the deposit already in.
Check proves each row adds up: banked + written off + still owed must equal revenue booked.
Faded rows are under 12 months old and have not had time to pay out.
Month of sale
Sales
Paid in full
Revenue booked
Banked on the day
Finance collected
TOTAL BANKED
Still live (not due yet)
Overdue
Written off
Age (mo)
Check
Jan 2024
1,238
303 24.5%
$2,921,321
$1,166,23439.9%
$853,10929.2%
$2,019,34469.1%
$2070.0%
$695,58123.8%
$207,1957.1%
33
ok
Feb 2024
1,196
275 23.0%
$2,847,559
$1,076,82037.8%
$868,12130.5%
$1,944,94068.3%
$00.0%
$721,98025.4%
$183,5216.4%
32
$-2,883
Mar 2024
1,323
270 20.4%
$3,282,240
$1,128,16434.4%
$1,007,94630.7%
$2,136,11065.1%
$1,9040.1%
$957,12629.2%
$186,3685.7%
31
ok
Apr 2024
1,208
264 21.9%
$2,960,795
$1,041,81835.2%
$919,53531.1%
$1,961,35366.2%
$00.0%
$839,71728.4%
$158,5335.4%
30
ok
May 2024
1,202
287 23.9%
$2,851,730
$1,084,53238.0%
$888,55531.2%
$1,973,08769.2%
$00.0%
$737,24025.9%
$140,8374.9%
29
ok
Jun 2024
1,167
288 24.7%
$2,738,119
$1,052,13338.4%
$885,78232.4%
$1,937,91570.8%
$00.0%
$677,37224.7%
$125,3894.6%
28
$-2,556
Jul 2024
1,170
268 22.9%
$2,652,115
$952,67935.9%
$876,21433.0%
$1,828,89369.0%
$90.0%
$679,87725.6%
$140,7685.3%
27
$2,568
Aug 2024
1,218
287 23.6%
$2,738,180
$1,011,51936.9%
$835,43430.5%
$1,846,95367.5%
$5900.0%
$763,42027.9%
$127,1614.6%
26
ok
Sep 2024
1,195
290 24.3%
$2,789,528
$1,011,41436.3%
$925,91533.2%
$1,937,33069.5%
$00.0%
$700,86125.1%
$149,7945.4%
25
$1,544
Oct 2024
1,130
242 21.4%
$2,662,736
$902,85133.9%
$867,27332.6%
$1,770,12366.5%
$00.0%
$761,36628.6%
$131,1614.9%
24
ok
Nov 2024
1,050
248 23.6%
$2,620,698
$932,54135.6%
$833,94331.8%
$1,766,48467.4%
$3680.0%
$721,64427.5%
$130,2685.0%
23
$1,934
Dec 2024
923
184 19.9%
$2,321,045
$750,57932.3%
$764,87033.0%
$1,515,44965.3%
$2,5160.1%
$697,69530.1%
$102,8274.4%
22
$2,557
Jan 2025
1,045
218 20.9%
$2,561,048
$848,99233.2%
$889,59534.7%
$1,738,58767.9%
$1,5000.1%
$702,15127.4%
$112,5474.4%
21
$6,263
Feb 2025
1,142
221 19.4%
$3,003,291
$963,83332.1%
$952,43631.7%
$1,916,26963.8%
$00.0%
$925,20130.8%
$159,4375.3%
20
$2,384
Mar 2025
1,264
231 18.3%
$3,213,827
$1,056,89332.9%
$922,12228.7%
$1,979,01461.6%
$00.0%
$1,061,46233.0%
$169,3325.3%
19
$4,019
Apr 2025
1,116
177 15.9%
$2,880,321
$879,17630.5%
$871,88330.3%
$1,751,05860.8%
$1130.0%
$994,64534.5%
$132,2614.6%
18
$2,245
May 2025
1,129
194 17.2%
$2,886,906
$877,44230.4%
$802,28727.8%
$1,679,72958.2%
$1650.0%
$1,069,54037.0%
$137,5354.8%
17
ok
Jun 2025
1,062
180 16.9%
$2,849,535
$908,43031.9%
$809,00428.4%
$1,717,43460.3%
$5980.0%
$995,16234.9%
$136,8004.8%
16
ok
Jul 2025
1,012
192 19.0%
$2,557,060
$844,58233.0%
$724,47428.3%
$1,569,05661.4%
$00.0%
$886,39234.7%
$102,1104.0%
15
ok
Aug 2025
1,219
244 20.0%
$3,106,042
$1,047,30833.7%
$836,55626.9%
$1,883,86460.7%
$1,9600.1%
$1,106,44335.6%
$114,4883.7%
14
ok
Sep 2025
1,100
199 18.1%
$2,666,709
$819,92430.7%
$779,10829.2%
$1,599,03260.0%
$1,2060.0%
$989,20037.1%
$75,4492.8%
13
$1,822
Oct 2025
1,137
255 22.4%
$2,867,779
$1,069,00837.3%
$777,50427.1%
$1,846,51264.4%
$6250.0%
$953,05033.2%
$67,8422.4%
12
ok
Nov 2025
1,117
215 19.2%
$2,926,193
$980,22733.5%
$786,08326.9%
$1,766,31060.4%
$8,1150.3%
$1,049,38235.9%
$103,4583.5%
11
ok
Dec 2025
1,043
241 23.1%
$2,757,877
$1,001,54636.3%
$643,39223.3%
$1,644,93859.6%
$107,5623.9%
$923,52533.5%
$82,0423.0%
10
ok
Jan 2026
1,129
299 26.5%
$3,049,939
$1,135,20837.2%
$727,10323.8%
$1,862,31161.1%
$216,1007.1%
$862,00628.3%
$109,6463.6%
9
ok
Feb 2026
1,162
265 22.8%
$3,168,601
$1,122,82835.4%
$642,15120.3%
$1,764,97955.7%
$399,43812.6%
$941,12629.7%
$63,7232.0%
8
ok
Mar 2026
1,293
286 22.1%
$3,542,272
$1,165,98032.9%
$615,71517.4%
$1,781,69550.3%
$642,33018.1%
$1,009,60528.5%
$108,7723.1%
7
ok
Apr 2026
1,080
225 20.8%
$2,993,405
$1,035,82134.6%
$430,98414.4%
$1,466,80549.0%
$691,35123.1%
$747,55025.0%
$87,8152.9%
6
ok
May 2026
1,353
365 27.0%
$3,611,684
$1,377,21938.1%
$469,48113.0%
$1,846,70051.1%
$952,25426.4%
$706,74319.6%
$106,0062.9%
5
ok
Jun 2026
1,282
348 27.1%
$3,449,863
$1,317,61138.2%
$405,38111.8%
$1,722,99249.9%
$1,061,12430.8%
$525,33515.2%
$140,5664.1%
4
ok
Jul 2026
1,317
363 27.6%
$3,602,009
$1,358,89237.7%
$339,4559.4%
$1,698,34747.1%
$1,324,56236.8%
$457,88512.7%
$121,3273.4%
3
ok
Aug 2026
1,282
323 25.2%
$3,432,109
$1,247,14936.3%
$251,0157.3%
$1,498,16343.7%
$1,465,63042.7%
$345,82410.1%
$122,5423.6%
2
ok
Sep 2026
1,055
283 26.8%
$2,765,453
$995,63336.0%
$136,0894.9%
$1,131,72240.9%
$1,347,40648.7%
$218,6957.9%
$67,7802.5%
1
ok
Oct 2026
1,119
311 27.8%
$2,984,593
$1,203,09640.3%
$34,3481.2%
$1,237,44541.5%
$1,534,55851.4%
$141,0904.7%
$71,7002.4%
0
ok
Nov 2026
536
142 26.5%
$1,393,663
$544,82039.1%
$4260.0%
$545,24639.1%
$821,23158.9%
$21,8361.6%
$5,3500.4%
part month
ok
TOTAL
40,014
8,98322.4%
$101,656,242
$35,912,89835.3%
$24,373,29024.0%
$60,286,18859.3%
$10,583,42210.4%
$26,587,72626.2%
$4,182,3504.1%
What every column means, and where the number comes from
Month of sale
CRM daily sales report
The month the sale was made. Every figure on the row belongs to the customers who bought that month, however long ago that was — so a row never changes because of what happened in a later month.
Sales
daily sales report, row count
How many sales were made. Anything at or below $300 is excluded everywhere on this page.
Paid in full
Total Deposit ≥ Package Price
Customers who handed over the whole price on the day and never created a finance agreement. They are invisible to the Debtor Ledger, which is why /finance-cohort cannot see them.
Revenue booked
sum of Package Price
The full value of what was sold that month, whether it has been paid or not. This is the denominator for every percentage on the row.
Banked on the day
sum of Total Deposit
Money taken at the point of sale — deposit, or the whole price for a paid-in-full customer. This is cash you already have.
Finance collected
booking payment schedules
Instalments actually taken since, added up from the dated payment lines on each booking. Declined attempts are not counted; chargebacks and refunds are subtracted.
TOTAL BANKED
day 1 + finance collected
Everything in the bank from that month's sales. The percentage is of revenue booked, so it answers "how much of what we sold have we actually got".
Still live (not due yet)
ledger balance, split by term
Money owed whose instalment has not fallen due yet. Worked out per contract from its first due date and the number of payments. A recent month is mostly this, and that is normal, not failure.
Overdue
balance less still-live
Money that was due and did not arrive. This is the number to read on recent months, not "still owed".
Complete months since the sale. Used to pick the right comparison; the part-elapsed current month never counts.
Check
arithmetic proof
Revenue booked minus banked, written off, overdue and still-live. Should read ok. A few hundred dollars is the CRM rounding each contract to the cent; thousands would mean a contract is being double counted or dropped.
How we are doing compared with how we used to
What this is. The share of all revenue that has been banked, quarter by quarter, so recent quarters can be compared with older ones fairly.
How it is worked out. Each quarter is measured at a matched age: a column only appears once every month in that quarter has that many complete months behind it. That is why the recent quarters have fewer columns rather than worse-looking numbers.
Watch out. The Latest column is NOT comparable across rows — an old quarter has had years and a new one has had weeks. Compare down a single column instead. Ad spend is advertising only — no payroll, no studio costs, no contractors — so “collected per $1” is a marketing return, NOT whether the business made money. And the spend feed stopped after 2026 Q1 when the cost logins lapsed, which is why the newest quarters read “no data” rather than zero.
Share of all revenue booked that has been banked, measured at a matched age so nothing is
flattered by extra time. A column only appears once every month in that period is old enough for it.
Period
Sales
Paid in full
Avg sale
On day 1
by month 3
by month 6
by month 12
by month 18
by month 24
Latest
Collected to date $
Still live
Overdue
Ad spend
Collected per $1 ad spend
2024 Q1
3,757
22.6%
$2,409
37.2%
45.4%
53.3%
63.8%
66.6%
67.1%
67.4%
$6,100,394
0.0%
26.2%
no data
—
2024 Q2
3,577
23.5%
$2,390
37.2%
45.8%
54.5%
65.8%
68.1%
68.5%
68.7%
$5,872,355
0.0%
26.4%
no data
—
2024 Q3
3,583
23.6%
$2,283
36.4%
45.1%
54.1%
65.7%
67.8%
68.5%
68.6%
$5,613,175
0.0%
26.2%
no data
—
2024 Q4
3,103
21.7%
$2,451
34.0%
43.0%
52.1%
63.6%
65.8%
—
66.4%
$5,052,057
0.0%
28.7%
no data
—
2025 Q1
3,451
19.4%
$2,544
32.7%
41.1%
49.7%
61.2%
63.7%
—
64.2%
$5,633,870
0.0%
30.6%
no data
—
2025 Q2
3,307
16.7%
$2,606
30.9%
38.7%
46.5%
57.1%
—
—
59.7%
$5,148,221
0.0%
35.5%
no data
—
2025 Q3
3,331
19.1%
$2,501
32.6%
40.0%
47.8%
59.0%
—
—
60.6%
$5,051,951
0.0%
35.8%
no data
—
2025 Q4
3,297
21.6%
$2,594
35.7%
42.9%
50.8%
—
—
—
61.5%
$5,257,759
1.4%
34.2%
no data
—
2026 Q1
3,584
23.7%
$2,723
35.1%
42.1%
49.3%
—
—
—
55.4%
$5,408,986
12.9%
28.8%
no data
—
2026 Q2
3,715
25.2%
$2,707
37.1%
43.2%
—
—
—
—
50.1%
$5,036,496
26.9%
19.7%
no data
—
2026 Q3
3,654
26.5%
$2,682
36.8%
—
—
—
—
—
44.2%
$4,328,232
42.2%
10.4%
no data
—
2026 Q4
1,655
27.4%
$2,645
39.9%
—
—
—
—
—
40.7%
$1,782,691
53.8%
3.7%
no data
—
The same thing per city
New York
Period
Sales
Paid in full
Avg sale
On day 1
by month 3
by month 6
by month 12
by month 18
by month 24
Latest
Collected to date $
Still live
Overdue
Ad spend
Collected per $1 ad spend
2024 Q1
928
23.6%
$2,331
32.7%
41.1%
49.6%
61.5%
65.2%
65.8%
66.1%
$1,429,009
0.0%
26.9%
no data
—
2024 Q2
1,007
21.1%
$2,388
31.1%
39.6%
49.0%
62.1%
64.8%
65.3%
65.6%
$1,578,715
0.0%
29.3%
no data
—
2024 Q3
1,006
21.9%
$2,343
30.6%
39.5%
49.4%
63.2%
65.3%
66.0%
66.1%
$1,558,601
0.0%
28.0%
no data
—
2024 Q4
860
14.7%
$2,502
26.0%
35.6%
45.7%
59.1%
61.5%
—
62.1%
$1,336,755
0.0%
32.5%
no data
—
2025 Q1
943
13.9%
$2,420
24.7%
33.6%
42.8%
55.3%
58.1%
—
58.9%
$1,343,799
0.1%
35.5%
no data
—
2025 Q2
897
16.6%
$2,444
27.3%
35.4%
43.8%
55.1%
—
—
58.2%
$1,275,118
0.0%
37.3%
no data
—
2025 Q3
799
18.8%
$2,393
30.1%
37.4%
44.9%
55.1%
—
—
57.1%
$1,091,370
0.1%
39.1%
no data
—
2025 Q4
742
19.8%
$2,531
30.9%
37.5%
45.3%
—
—
—
56.4%
$1,058,528
1.1%
37.1%
no data
—
2026 Q1
577
25.1%
$2,592
31.8%
38.4%
45.3%
—
—
—
51.3%
$767,388
11.8%
33.3%
no data
—
2026 Q2
521
25.0%
$2,603
31.4%
37.7%
—
—
—
—
44.7%
$605,757
29.1%
22.4%
no data
—
2026 Q3
458
28.4%
$2,888
36.8%
—
—
—
—
—
43.4%
$574,557
42.1%
10.1%
no data
—
2026 Q4
252
29.0%
$2,399
37.6%
—
—
—
—
—
37.7%
$227,711
58.8%
2.6%
no data
—
Dallas
Period
Sales
Paid in full
Avg sale
On day 1
by month 3
by month 6
by month 12
by month 18
by month 24
Latest
Collected to date $
Still live
Overdue
Ad spend
Collected per $1 ad spend
2024 Q1
540
16.7%
$2,599
32.3%
40.7%
48.9%
60.1%
62.7%
63.0%
63.4%
$889,425
0.0%
29.1%
no data
—
2024 Q2
498
19.9%
$2,488
34.5%
43.7%
53.3%
65.6%
68.3%
68.5%
68.6%
$850,572
0.0%
27.2%
no data
—
2024 Q3
527
14.4%
$2,428
27.0%
37.1%
47.7%
61.6%
64.7%
65.6%
65.8%
$841,588
0.0%
28.6%
no data
—
2024 Q4
436
21.1%
$2,460
33.5%
41.8%
50.4%
60.2%
62.4%
—
63.2%
$677,710
0.0%
32.4%
no data
—
2025 Q1
537
15.1%
$2,722
29.1%
36.8%
44.6%
55.0%
57.8%
—
58.4%
$853,544
0.0%
35.1%
no data
—
2025 Q2
448
14.7%
$2,734
27.6%
34.1%
40.9%
49.7%
—
—
52.0%
$636,395
0.0%
43.7%
no data
—
2025 Q3
548
13.9%
$2,714
27.3%
34.4%
41.2%
52.3%
—
—
54.3%
$807,814
0.1%
42.4%
no data
—
2025 Q4
506
21.5%
$2,773
37.8%
44.5%
51.0%
—
—
—
59.5%
$834,150
0.9%
37.0%
no data
—
2026 Q1
547
29.1%
$2,897
40.2%
46.1%
52.6%
—
—
—
58.4%
$926,011
11.4%
28.5%
no data
—
2026 Q2
524
34.5%
$2,821
47.9%
53.0%
—
—
—
—
58.9%
$870,067
19.4%
18.6%
no data
—
2026 Q3
470
33.6%
$2,572
43.9%
—
—
—
—
—
49.9%
$603,324
33.8%
12.7%
no data
—
2026 Q4
219
33.3%
$2,825
48.6%
—
—
—
—
—
49.1%
$303,834
46.2%
3.9%
no data
—
Houston
Period
Sales
Paid in full
Avg sale
On day 1
by month 3
by month 6
by month 12
by month 18
by month 24
Latest
Collected to date $
Still live
Overdue
Ad spend
Collected per $1 ad spend
2024 Q1
520
20.8%
$2,520
41.8%
49.5%
57.8%
69.2%
72.5%
72.9%
73.2%
$959,722
0.0%
22.4%
no data
—
2024 Q2
460
25.7%
$2,578
44.3%
53.0%
60.6%
70.3%
72.0%
72.3%
72.4%
$858,634
0.0%
23.6%
no data
—
2024 Q3
464
20.7%
$2,352
41.0%
47.9%
55.9%
66.2%
67.8%
68.7%
68.8%
$751,299
0.0%
27.0%
no data
—
2024 Q4
449
20.3%
$2,502
38.7%
46.7%
54.2%
63.7%
65.2%
—
66.1%
$742,547
0.0%
29.4%
no data
—
2025 Q1
484
20.2%
$2,643
36.8%
45.4%
53.6%
63.8%
65.4%
—
65.6%
$838,852
0.0%
30.8%
no data
—
2025 Q2
523
15.3%
$2,703
33.7%
41.6%
47.8%
56.1%
—
—
58.3%
$824,420
0.0%
37.3%
no data
—
2025 Q3
490
16.5%
$2,482
31.8%
39.8%
47.3%
58.9%
—
—
60.5%
$735,436
0.0%
36.1%
no data
—
2025 Q4
437
17.4%
$2,604
33.2%
40.9%
49.0%
—
—
—
58.7%
$668,432
1.6%
38.3%
no data
—
2026 Q1
493
21.1%
$2,826
31.5%
38.8%
46.3%
—
—
—
52.5%
$731,345
15.2%
28.2%
no data
—
2026 Q2
467
16.1%
$2,781
27.4%
34.7%
—
—
—
—
42.2%
$547,716
33.0%
21.1%
no data
—
2026 Q3
444
13.7%
$2,910
24.6%
—
—
—
—
—
32.0%
$413,528
51.8%
10.9%
no data
—
2026 Q4
172
23.3%
$3,084
37.1%
—
—
—
—
—
37.8%
$200,717
54.9%
3.5%
no data
—
Florida
Period
Sales
Paid in full
Avg sale
On day 1
by month 3
by month 6
by month 12
by month 18
by month 24
Latest
Collected to date $
Still live
Overdue
Ad spend
Collected per $1 ad spend
2024 Q1
555
34.1%
$2,273
46.9%
54.5%
62.0%
72.4%
75.3%
75.9%
76.1%
$959,607
0.0%
17.7%
no data
—
2024 Q2
547
33.8%
$2,224
43.1%
51.9%
60.1%
72.4%
74.6%
75.0%
75.2%
$914,823
0.0%
19.2%
no data
—
2024 Q3
497
37.6%
$2,331
46.8%
53.9%
60.9%
70.1%
71.9%
72.4%
72.4%
$838,705
0.0%
22.4%
no data
—
2024 Q4
407
27.8%
$2,731
39.0%
47.2%
55.8%
66.6%
68.9%
—
69.6%
$773,309
0.2%
24.2%
no data
—
2025 Q1
542
22.3%
$2,778
35.9%
44.4%
53.1%
65.8%
68.4%
—
68.7%
$1,033,933
0.0%
25.5%
no data
—
2025 Q2
512
20.1%
$2,817
35.6%
43.5%
51.8%
62.7%
—
—
65.0%
$937,276
0.0%
29.2%
no data
—
2025 Q3
443
27.1%
$2,865
42.8%
49.5%
57.1%
67.3%
—
—
68.4%
$868,355
0.0%
27.1%
no data
—
2025 Q4
415
31.6%
$2,975
44.8%
51.6%
59.3%
—
—
—
69.2%
$854,653
1.3%
27.1%
no data
—
2026 Q1
407
28.0%
$2,937
40.4%
48.3%
55.8%
—
—
—
62.2%
$743,579
9.4%
25.0%
no data
—
2026 Q2
410
32.9%
$2,877
42.9%
49.1%
—
—
—
—
56.3%
$664,185
23.8%
17.2%
no data
—
2026 Q3
392
41.1%
$2,773
48.3%
—
—
—
—
—
54.1%
$588,249
33.8%
8.6%
no data
—
2026 Q4
139
38.8%
$2,851
45.2%
—
—
—
—
—
45.8%
$181,473
48.5%
1.9%
no data
—
Boston
Period
Sales
Paid in full
Avg sale
On day 1
by month 3
by month 6
by month 12
by month 18
by month 24
Latest
Collected to date $
Still live
Overdue
Ad spend
Collected per $1 ad spend
2024 Q1
453
30.7%
$2,512
48.0%
58.0%
66.6%
76.7%
78.2%
78.5%
78.6%
$893,870
0.0%
15.6%
no data
—
2024 Q2
387
30.7%
$2,417
47.2%
57.1%
66.9%
77.3%
79.1%
79.3%
79.4%
$743,126
0.0%
15.4%
no data
—
2024 Q3
408
27.0%
$2,317
42.8%
52.6%
63.1%
75.9%
78.1%
78.7%
78.8%
$744,793
0.0%
16.7%
no data
—
2024 Q4
377
26.0%
$2,338
36.5%
46.7%
56.2%
68.1%
70.9%
—
71.6%
$630,617
0.0%
23.8%
no data
—
2025 Q1
499
27.1%
$2,360
40.1%
47.9%
56.9%
67.7%
70.6%
—
70.9%
$835,164
0.0%
23.6%
no data
—
2025 Q2
500
17.2%
$2,409
33.4%
41.8%
51.1%
64.9%
—
—
68.2%
$821,836
0.0%
27.0%
no data
—
2025 Q3
358
23.7%
$2,137
36.0%
45.2%
55.4%
70.1%
—
—
71.9%
$550,012
0.0%
27.3%
no data
—
2025 Q4
311
24.4%
$2,438
37.8%
46.0%
55.7%
—
—
—
68.5%
$519,079
1.8%
26.7%
no data
—
2026 Q1
330
23.9%
$2,689
36.3%
43.1%
51.1%
—
—
—
58.1%
$515,384
11.0%
27.3%
no data
—
2026 Q2
349
24.1%
$2,515
39.7%
46.2%
—
—
—
—
54.1%
$474,520
23.5%
17.3%
no data
—
2026 Q3
430
26.5%
$2,575
32.6%
—
—
—
—
—
41.6%
$460,177
44.7%
10.7%
no data
—
2026 Q4
201
28.4%
$2,459
34.7%
—
—
—
—
—
36.0%
$177,861
58.1%
3.5%
no data
—
Nashville
Period
Sales
Paid in full
Avg sale
On day 1
by month 3
by month 6
by month 12
by month 18
by month 24
Latest
Collected to date $
Still live
Overdue
Ad spend
Collected per $1 ad spend
2024 Q3
158
31.6%
$2,361
43.3%
51.1%
59.1%
68.8%
70.0%
71.0%
71.1%
$265,217
0.0%
24.7%
no data
—
2024 Q4
461
26.7%
$2,349
38.3%
47.5%
56.8%
69.8%
71.5%
—
72.0%
$779,738
0.0%
25.0%
no data
—
2025 Q1
446
23.3%
$2,403
37.2%
45.5%
53.8%
65.4%
67.5%
—
68.0%
$728,577
0.0%
28.9%
no data
—
2025 Q2
427
15.7%
$2,667
29.5%
36.9%
44.8%
55.1%
—
—
57.3%
$653,177
0.0%
38.1%
no data
—
2025 Q3
432
16.2%
$2,499
33.4%
41.1%
49.4%
60.4%
—
—
61.6%
$665,217
0.1%
34.6%
no data
—
2025 Q4
403
16.1%
$2,290
30.7%
38.7%
46.9%
—
—
—
59.2%
$545,909
1.9%
36.4%
no data
—
2026 Q1
422
16.6%
$2,598
32.8%
41.7%
49.1%
—
—
—
56.1%
$614,808
14.5%
27.3%
no data
—
2026 Q2
421
23.5%
$2,393
34.5%
41.0%
—
—
—
—
48.4%
$487,378
28.6%
21.5%
no data
—
2026 Q3
407
23.3%
$2,370
35.8%
—
—
—
—
—
44.2%
$426,429
42.9%
11.9%
no data
—
2026 Q4
195
23.6%
$2,535
36.2%
—
—
—
—
—
37.5%
$185,169
54.2%
7.6%
no data
—
Chicago
Period
Sales
Paid in full
Avg sale
On day 1
by month 3
by month 6
by month 12
by month 18
by month 24
Latest
Collected to date $
Still live
Overdue
Ad spend
Collected per $1 ad spend
2025 Q3
261
20.3%
$2,301
27.4%
34.2%
41.9%
53.6%
—
—
55.6%
$333,748
0.0%
39.8%
no data
—
2025 Q4
483
22.2%
$2,520
36.1%
43.3%
52.2%
—
—
—
63.8%
$777,010
1.4%
32.9%
no data
—
2026 Q1
554
24.4%
$2,367
33.3%
40.0%
47.0%
—
—
—
53.2%
$698,176
13.4%
30.9%
no data
—
2026 Q2
521
24.8%
$2,622
37.8%
43.2%
—
—
—
—
50.0%
$682,713
28.0%
19.7%
no data
—
2026 Q3
511
29.0%
$2,426
38.9%
—
—
—
—
—
47.0%
$582,007
42.3%
9.3%
no data
—
2026 Q4
252
22.2%
$2,345
41.3%
—
—
—
—
—
42.3%
$249,729
54.1%
3.0%
no data
—
Orlando
Period
Sales
Paid in full
Avg sale
On day 1
by month 3
by month 6
by month 12
by month 18
by month 24
Latest
Collected to date $
Still live
Overdue
Ad spend
Collected per $1 ad spend
2026 Q1
254
17.3%
$3,139
34.2%
40.9%
47.4%
—
—
—
51.7%
$412,295
18.1%
28.3%
no data
—
2026 Q2
502
20.9%
$2,971
35.0%
41.2%
—
—
—
—
47.2%
$704,160
29.3%
19.1%
no data
—
2026 Q3
542
18.8%
$2,911
35.0%
—
—
—
—
—
43.1%
$679,960
44.6%
9.7%
no data
—
2026 Q4
225
24.0%
$2,884
38.4%
—
—
—
—
—
39.5%
$256,197
54.9%
3.8%
no data
—
Atlanta
Period
Sales
Paid in full
Avg sale
On day 1
by month 3
by month 6
by month 12
by month 18
by month 24
Latest
Collected to date $
Still live
Overdue
Ad spend
Collected per $1 ad spend
2024 Q1
761
13.5%
$2,333
29.5%
36.9%
43.0%
50.9%
53.4%
54.0%
54.6%
$968,761
0.1%
38.8%
no data
—
2024 Q2
678
15.6%
$2,314
32.7%
40.2%
47.3%
56.1%
58.5%
58.8%
59.1%
$926,486
0.0%
35.4%
no data
—
2024 Q3
523
20.3%
$1,865
36.3%
45.8%
52.7%
60.3%
62.2%
62.7%
62.8%
$612,974
0.0%
32.3%
no data
—
2024 Q4
113
27.4%
$1,605
34.2%
46.0%
54.6%
60.9%
61.4%
61.4%
61.4%
$111,380
0.2%
30.2%
no data
—
Which way is it going?
What this is. The share of each month’s revenue that had been banked by every point in its life — day 1, then by month 2, 3, 4 and so on to month 12 — plotted against the month of sale. Twelve lines rather than four, so a recent month appears on as many of them as it has actually lived.
How it is worked out. A raw “% collected” line would be worthless: an old month has had two years to collect and a new one three weeks, so it would slope downwards whatever the business did. Every line here is age-matched — each point answers “how much of that month’s revenue was in the bank by month N”. Sales over $300, all cities, paid-in-full included.
Watch out. Each line stops where cohorts run out of runway, so the fan gets shorter as you go down it — the month-12 line ends in Aug 2025, while day 1 runs to last month. The long lines are still measuring 2025 and cannot yet see what the short ones show.
■ Day 1 (month 1)■ By month 2■ By month 3■ By month 4■ By month 5■ By month 6■ By month 7■ By month 8■ By month 9■ By month 10■ By month 11■ By month 12
Up, down or sideways
The average of the last six readable months against the six before them, at every age.
Anything inside half a point is called sideways rather than dressed up as a direction. The short ages carry the most
recent data; the long ones are still reading 2025, which is why they disagree.
Measured at
Previous 6 months
Last 6 months
Change
Verdict
Day 1 (month 1)
35.4%
38.1%
+2.7pp
UP
By month 2
39.4%
40.3%
+0.9pp
UP
By month 3
42.4%
42.5%
+0.2pp
SIDEWAYS
By month 4
45.0%
44.9%
-0.1pp
SIDEWAYS
By month 5
46.9%
47.4%
+0.5pp
UP
By month 6
48.6%
49.3%
+0.7pp
UP
By month 7
50.3%
51.1%
+0.8pp
UP
By month 8
51.5%
54.1%
+2.6pp
UP
By month 9
53.6%
56.3%
+2.7pp
UP
By month 10
55.8%
58.0%
+2.2pp
UP
By month 11
58.3%
58.9%
+0.6pp
UP
By month 12
60.1%
59.6%
-0.5pp
SIDEWAYS
The same thing in money
What this is. Identical fan, but the actual dollars banked from each month’s sales rather than the share. The dashed grey line is the revenue written that month, so the gap between it and the top line is what has not arrived yet.
How it is worked out. Same age-matching — each point is "how much money from that month was in the bank by month N". Nothing is adjusted for inflation or for the month being bigger.
Watch out. This is the chart that answers “are we collecting more money”, and it can point the OPPOSITE way to the percentage chart above. A smaller share of a much bigger month is more money. Both are true; they answer different questions.
- - Revenue written■ Day 1 (month 1)■ By month 2■ By month 3■ By month 4■ By month 5■ By month 6■ By month 7■ By month 8■ By month 9■ By month 10■ By month 11■ By month 12
Up, down or sideways — on the money
Measured at
Previous 6 months
Last 6 months
Change
Verdict
Day 1 (month 1)
$1,087,159
$1,261,482
+16.0%
UP
By month 2
$1,200,592
$1,338,474
+11.5%
UP
By month 3
$1,233,661
$1,464,910
+18.7%
UP
By month 4
$1,303,687
$1,526,952
+17.1%
UP
By month 5
$1,319,045
$1,563,768
+18.6%
UP
By month 6
$1,377,151
$1,570,126
+14.0%
UP
By month 7
$1,418,686
$1,567,101
+10.5%
UP
By month 8
$1,454,309
$1,645,063
+13.1%
UP
By month 9
$1,562,479
$1,637,491
+4.8%
UP
By month 10
$1,616,528
$1,678,840
+3.9%
UP
By month 11
$1,688,431
$1,657,946
-1.8%
DOWN
By month 12
$1,684,197
$1,686,607
+0.1%
SIDEWAYS
1. Average payment taken per sale, each month
What this is. The average cash actually taken on the day, per sale, for every sale over $300. The grey line is the average sale value alongside it, so you can see whether more cash is coming from bigger tickets or from taking a bigger slice of the same ticket.
How it is worked out. Money banked on the day that month, divided by the number of sales. No age-matching needed — the deposit is known the moment the sale is made. The current part-month is excluded.
Watch out. A paid-in-full customer contributes their whole price here, so this line moves with the paid-in-full rate as much as with deposit size.
■ Avg cash taken on the day■ Avg sale value
Last six months $1,012 against $945 for the six before — +7.0%.
2. What share of people pay in full
What this is. The percentage of that month’s sales where the customer handed over the whole price on the day and never took finance.
How it is worked out. Sales whose deposit covers the full price, over all sales that month. Sales over $300 only — including the small ones puts this line about 15 points too high, because nearly every $67 add-on is technically paid in full.
Watch out. This is the single line that explains the recovery. It bottoms in spring 2025 and climbs from there.
■ Paid in full, % of sales
Last six months 26.9% against 22.4% for the six before — +20.0%.
3. Paid-in-full money, each month
What this is. The total value of the sales paid in full that month, and below it the average ticket of those sales.
How it is worked out. Sum and mean of the price on every sale whose deposit covered it. This money carries no collection risk at all — it is banked the day it is sold.
Watch out. Watch the average ticket against the share above. If the share rises while the ticket falls, you are discounting to get people to pay outright. If both hold, you are not.
■ Paid-in-full total
■ Average paid-in-full sale
Last six months $746,555 against $599,908 for the six before — +24.4%.
Down through 2025, bottomed in May, and rising now. Every line makes the same U.
Day one fell from 40.5% in Jan 2024 to 30.7% in May 2025 and is back to 38.3%. By month 3: 47.9% to
37.9% and back to 44.5%. By month 6: 55.5% to 45.5% and back to 52.5%.
The month-12 line still reads DOWN only because its newest readable month is Aug 2025 — it is measuring the trough,
not the present. It should turn as the 2026 cohorts mature.
Month by month — every month's own collection pattern
What this is. One row per month of sales, and one column per month of its life. Each cell is the share of that month’s total revenue banked in that month. Read a column straight down and you see the trend at that exact age, with nothing distorted by some months having had longer.
How it is worked out. Denominator is the whole SALE, so paid-in-full customers are included — which is the difference from the same grid on /finance-cohort, where the denominator is finance only. The $300 floor applies. Month 1 is the month of the sale and includes the deposit, which is why it dwarfs every other cell. Dots mean that month has not reached that age yet, not a zero.
Watch out. The AVERAGE row uses settled months only — a two-month-old row has no month 9 to contribute, so including it would drag the later columns down.
The violet cells have not happened. Any month a cell has not lived through yet is filled
with the rate the three most recent months that HAVE reached that age actually achieved — deliberately
today’s performance rather than a long-run average, so if collections move the forecast moves with them.
Collected to date is what has actually arrived, at whatever stage that month has reached — the Age column
tells you which stage. Forecast total is where it ends up if things carry on exactly as they are now. It is capped
at the revenue booked, so nothing can be forecast to pay more than it owes.
Month of sale
Sale value
1
2
3
4
5
6
7
8
9
10
11
12
After 12
Collected to date $
Collected to date %
Forecast total $
Forecast total %
Age (mo)
Jan 2024
$2,921,321
40.45%
4.19%
3.22%
3.06%
2.49%
2.13%
2.09%
1.84%
1.77%
1.49%
1.43%
1.16%
2.76%
$2,019,294
69.1%
$2,019,294
69.1%
33
Feb 2024
$2,847,559
38.47%
4.06%
3.45%
3.01%
2.59%
2.30%
2.19%
2.03%
1.99%
1.82%
1.54%
1.30%
2.36%
$1,944,940
68.3%
$1,944,940
68.3%
32
Mar 2024
$3,282,240
35.08%
4.14%
3.55%
2.79%
2.60%
2.52%
2.17%
2.10%
1.90%
1.69%
1.68%
1.28%
2.46%
$2,136,110
65.1%
$2,136,110
65.1%
31
Apr 2024
$2,960,795
35.83%
4.36%
3.31%
2.87%
2.66%
2.57%
2.40%
2.05%
1.85%
1.85%
1.50%
1.41%
2.33%
$1,961,253
66.2%
$1,961,253
66.2%
30
May 2024
$2,851,730
38.59%
4.43%
3.70%
3.07%
2.87%
2.68%
2.43%
2.17%
2.06%
1.81%
1.81%
0.90%
1.91%
$1,972,987
69.2%
$1,972,987
69.2%
29
Jun 2024
$2,738,119
39.00%
4.59%
3.78%
3.25%
3.10%
2.90%
2.58%
2.23%
2.08%
2.06%
1.90%
0.90%
1.81%
$1,937,915
70.8%
$1,937,915
70.8%
28
Jul 2024
$2,652,115
36.09%
4.51%
3.52%
3.38%
3.05%
2.80%
2.86%
2.46%
2.22%
1.99%
1.95%
0.92%
2.47%
$1,828,735
69.0%
$1,828,735
69.0%
27
Aug 2024
$2,738,180
37.24%
4.45%
3.73%
3.36%
2.97%
2.61%
2.29%
2.18%
1.95%
1.78%
1.60%
0.76%
1.82%
$1,846,953
67.5%
$1,846,953
67.5%
26
Sep 2024
$2,789,528
36.92%
5.03%
3.70%
3.10%
2.91%
2.82%
2.65%
2.36%
2.01%
2.07%
1.89%
0.98%
2.27%
$1,936,374
69.4%
$1,936,374
69.4%
25
Oct 2024
$2,662,736
34.71%
4.71%
3.52%
3.55%
2.91%
2.88%
2.57%
2.22%
2.20%
2.00%
1.67%
0.91%
2.01%
$1,769,947
66.5%
$1,769,947
66.5%
24
Nov 2024
$2,620,698
36.13%
4.56%
3.97%
3.19%
2.97%
2.58%
2.38%
2.06%
2.03%
2.00%
1.61%
0.89%
2.34%
$1,766,267
67.4%
$1,766,267
67.4%
23
Dec 2024
$2,321,045
32.80%
4.58%
3.90%
3.43%
2.93%
2.80%
2.53%
2.36%
2.34%
1.98%
1.95%
1.01%
1.94%
$1,515,123
65.3%
$1,515,123
65.3%
22
Jan 2025
$2,561,048
33.61%
4.39%
4.12%
3.64%
2.83%
2.69%
2.57%
2.80%
2.33%
2.40%
2.00%
1.05%
2.48%
$1,737,838
67.9%
$1,737,838
67.9%
21
Feb 2025
$3,003,291
32.44%
4.57%
3.94%
3.31%
2.98%
2.68%
2.43%
2.20%
2.14%
1.81%
1.77%
0.88%
1.99%
$1,915,569
63.8%
$1,915,569
63.8%
20
Mar 2025
$3,213,827
33.28%
3.97%
3.14%
2.76%
2.71%
2.27%
2.16%
2.30%
1.85%
1.75%
1.53%
0.94%
2.07%
$1,978,024
61.5%
$1,978,024
61.5%
19
Apr 2025
$2,880,321
31.22%
4.28%
3.53%
3.02%
2.63%
2.41%
2.28%
2.26%
1.97%
1.87%
1.71%
0.92%
1.82%
$1,749,202
60.7%
$1,749,202
60.7%
18
May 2025
$2,886,906
30.71%
3.87%
3.30%
2.72%
2.52%
2.38%
2.18%
1.84%
1.85%
1.68%
1.64%
0.95%
1.80%
$1,676,941
58.1%
$1,676,941
58.1%
17
Jun 2025
$2,849,535
32.01%
3.78%
3.40%
2.94%
2.61%
2.24%
2.19%
2.04%
1.95%
1.71%
1.83%
1.02%
1.78%
$1,712,922
60.1%
$1,712,922
60.1%
16
Jul 2025
$2,557,060
33.55%
3.81%
3.14%
2.78%
2.40%
2.32%
2.22%
2.31%
2.07%
1.83%
1.70%
1.05%
1.27%
$1,567,041
61.3%
$1,567,041
61.3%
15
Aug 2025
$3,106,042
34.25%
3.73%
3.11%
2.41%
2.52%
2.33%
2.01%
1.95%
2.00%
1.82%
1.62%
1.24%
1.63%
$1,879,881
60.5%
$1,902,409
61.2%
14
Sep 2025
$2,666,709
30.99%
3.94%
3.34%
3.18%
2.80%
2.66%
2.51%
2.37%
2.28%
1.87%
1.74%
1.01%
1.63%
$1,592,526
59.7%
$1,621,253
60.8%
13
Oct 2025
$2,867,779
37.85%
3.33%
3.21%
2.90%
2.55%
2.51%
2.32%
2.09%
1.97%
1.88%
1.51%
1.13%
1.63%
$1,839,827
64.2%
$1,879,938
65.6%
12
Nov 2025
$2,926,193
34.11%
3.95%
3.23%
2.95%
2.53%
2.53%
2.22%
2.08%
1.91%
1.69%
1.55%
1.10%
1.63%
$1,750,843
59.8%
$1,798,593
61.5%
11
Dec 2025
$2,757,877
36.51%
3.21%
3.20%
3.04%
2.59%
2.26%
1.98%
1.93%
1.56%
1.42%
1.40%
1.08%
1.63%
$1,629,357
59.1%
$1,704,188
61.8%
10
Jan 2026
$3,049,939
37.88%
3.64%
3.24%
2.71%
2.58%
2.42%
2.30%
1.72%
2.00%
1.70%
1.48%
1.08%
1.63%
$1,835,363
60.2%
$1,963,399
64.4%
9
Feb 2026
$3,168,601
35.92%
3.66%
3.08%
2.79%
2.31%
2.18%
1.80%
1.62%
1.54%
1.61%
1.48%
1.08%
1.63%
$1,739,321
54.9%
$1,923,211
60.7%
8
Mar 2026
$3,542,272
33.23%
3.27%
2.92%
2.43%
2.11%
1.95%
1.87%
1.69%
1.70%
1.61%
1.48%
1.08%
1.63%
$1,752,726
49.5%
$2,018,663
57.0%
7
Apr 2026
$2,993,405
34.98%
2.62%
2.59%
2.34%
2.09%
1.74%
1.64%
1.68%
1.70%
1.61%
1.48%
1.08%
1.63%
$1,437,404
48.0%
$1,712,298
57.2%
6
May 2026
$3,611,684
38.51%
3.25%
2.68%
2.19%
1.99%
1.84%
1.78%
1.68%
1.70%
1.61%
1.48%
1.08%
1.63%
$1,822,665
50.5%
$2,218,529
61.4%
5
Jun 2026
$3,449,863
38.75%
3.24%
2.64%
2.36%
2.10%
1.85%
1.78%
1.68%
1.70%
1.61%
1.48%
1.08%
1.63%
$1,693,440
49.1%
$2,135,434
61.9%
4
Jul 2026
$3,602,009
38.05%
3.19%
2.67%
2.20%
2.06%
1.85%
1.78%
1.68%
1.70%
1.61%
1.48%
1.08%
1.63%
$1,660,883
46.1%
$2,196,564
61.0%
3
Aug 2026
$3,432,109
36.78%
3.10%
2.75%
2.25%
2.06%
1.85%
1.78%
1.68%
1.70%
1.61%
1.48%
1.08%
1.63%
$1,463,222
42.6%
$2,050,781
59.8%
2
Sep 2026
$2,765,453
36.11%
3.45%
2.68%
2.25%
2.06%
1.85%
1.78%
1.68%
1.70%
1.61%
1.48%
1.08%
1.63%
$1,093,880
39.6%
$1,641,540
59.4%
1
Oct 2026
$2,984,593
40.53%
3.23%
2.68%
2.25%
2.06%
1.85%
1.78%
1.68%
1.70%
1.61%
1.48%
1.08%
1.63%
$1,209,638
40.5%
$1,897,163
63.6%
0
AVERAGE(settled months)
$61,978,583
35.07%
4.23%
3.52%
3.06%
2.75%
2.54%
2.35%
2.18%
2.03%
1.86%
1.70%
1.03%
1.88%
$40,318,536
65.1%
ALL MONTHS(excl. the part month)
$100,262,579
$59,374,412
59.2%
$63,942,684
63.8%
Does the deposit predict whether they pay?
What this is. Every sale banded by how big a deposit was taken, then followed forward to see what share of the sale came back. It tests the theory that the customers who pay in full are the good ones, leaving a weaker book behind on finance.
How it is worked out. Deposit divided by sale price puts each sale in a band. Every band is then measured at a matched 12 complete months, so no band is flattered by having had longer. Deposit comes from the CRM daily sales report; the instalments are the dated payment lines on each booking schedule. Sales of $300 or less are excluded — 10,039 of them, 21.6% of the count but 0.7% of the value, averaging $67.
Watch out. Correlation, not proof of cause. A customer who can put 33% down is probably better off to begin with, so the deposit may be a symptom of who they are rather than the reason they pay.
Deposit taken
Sales
Avg sale
Deposit % of sale
Finance collected by m12
TOTAL banked by m12
Still owed
Under 10%
77
$2,389
3.2%
13.8%
16.5%
41.7%
10–15%
6,940
$2,533
11.9%
30.3%
38.6%
52.1%
15–20%
4,036
$2,322
16.3%
42.5%
51.8%
38.9%
20–25%
5,300
$2,754
20.9%
47.0%
58.1%
32.4%
25–33%
2,438
$2,611
26.8%
56.9%
68.4%
22.7%
33–50%
1,102
$2,397
37.8%
62.9%
76.9%
16.0%
50–99%
935
$2,687
54.7%
71.8%
87.2%
8.6%
Paid in full
5,532
$2,105
100.0%
0.0%
100.0%
0.0%
The deposit predicts payment almost perfectly — and the mix has moved the wrong way.
A 10–15% deposit returns 30.4% of its finance in the first year; a 20–25% deposit returns 47.3%.
Half the 10–15% book is still outstanding at twelve months against a third of the 20–25% book. Meanwhile the
10–15% band has grown from 14.9% of sales in 2024 Q1 to 27.9%, and 20–25% has collapsed from
20.2% to 7.7%. Applying each band's proven rate to both mixes, that drift costs about
1.9 points of revenue, roughly $758k a year — smaller than it looks only because paid-in-full rose at the
same time and those bank everything.
How the deposit mix has drifted
What this is. The share of sales landing in each deposit band, quarter by quarter.
How it is worked out. Count of sales in each band divided by all sales that quarter, sales over $300 only. No maturity filter — this is about what was sold, not what came back.
Quarter
Sales
Under 10%
10–15%
15–20%
20–25%
25–33%
33–50%
50–99%
Paid in full
2024 Q1
3,757
0.3%
18.1%
11.6%
27.6%
11.1%
4.8%
3.9%
22.6%
2024 Q2
3,577
0.4%
20.0%
15.2%
23.1%
9.0%
4.8%
4.0%
23.5%
2024 Q3
3,583
0.3%
17.3%
14.3%
26.3%
10.8%
4.4%
3.1%
23.6%
2024 Q4
3,103
0.3%
27.5%
16.7%
18.8%
8.4%
3.6%
2.8%
21.7%
2025 Q1
3,451
0.2%
30.8%
17.0%
16.9%
8.8%
3.7%
3.2%
19.4%
2025 Q2
3,307
0.2%
33.1%
18.0%
16.8%
8.0%
3.7%
3.7%
16.7%
2025 Q3
3,331
0.3%
34.6%
15.1%
14.5%
8.8%
4.1%
3.6%
19.1%
2025 Q4
3,297
0.4%
35.9%
14.2%
11.3%
8.5%
4.1%
4.0%
21.6%
2026 Q1
3,584
0.5%
37.6%
12.7%
8.9%
8.5%
3.8%
4.3%
23.7%
2026 Q2
3,715
0.2%
34.9%
12.7%
8.3%
9.2%
4.8%
4.6%
25.2%
2026 Q3
3,654
0.2%
35.9%
13.2%
7.7%
7.6%
4.6%
4.3%
26.5%
2026 Q4
1,655
0.2%
31.4%
12.4%
7.9%
10.3%
4.6%
5.9%
27.4%
KIDS X — is it making a difference?
What this is. KIDS X sales over the last six complete months, against adult sales over the same months, measured at the same ages.
How it is worked out. KIDS X is any marketing code containing KIDSX. Adults are every sale whose code contains no KIDS at all — the older plain #CITYKIDS codes are a different product and are excluded from both sides. Window is May 2026 to Oct 2026, sales over $300. Each row only counts sales with that many complete months behind them.
Watch out. KIDS X barely existed before May 2026 — 54 sales in April, then 395, 458 and 391. Anything measured at four months or more is only the April pilot batch and is too small to read, which is why those rows are not shown.
Measured at
KIDS X
Adults
Gap
Sales
Avg sale
Paid in full
Day 1
Instalments
Banked
Sales
Avg sale
Paid in full
Day 1
Instalments
Banked
Banked
2 months
1,964
$2,816
34.2%
42.7%
3.6%
46.3%
4,317
$2,619
23.3%
34.7%
3.6%
38.3%
+8.0pp
3 months
1,654
$2,829
34.3%
42.6%
6.2%
48.8%
3,573
$2,629
23.2%
35.1%
6.4%
41.5%
+7.3pp
4 months
1,246
$2,846
34.2%
42.4%
8.2%
50.6%
2,699
$2,628
24.0%
35.8%
8.7%
44.6%
+6.0pp
6 months
395
$2,874
36.7%
42.9%
10.9%
53.8%
952
$2,581
22.8%
35.8%
13.0%
48.9%
+4.9pp
First and second instalment — did they actually start paying?
What this is. Of the customers who took finance, the share who made their first instalment, and the share who made a second.
How it is worked out. Paid-in-full customers are excluded — they have no instalments to make. First payment = at least one instalment landed by month 2; second = at least two by month 3. The first instalment falls due a median of 31 days after the sale, so month 2 is its first real chance. Both are measured in a fixed window, so an old quarter that has had two years cannot beat a new one simply by having had longer.
Watch out. A quarter only appears once every month in it has reached that window, which is why the newest quarters are blank rather than low.
Quarter
Adults
KIDS X
Financed
Made 1st
Made 2nd
Financed
Made 1st
Made 2nd
2024 Q1
2,909
68.7%
52.8%
—
—
—
2024 Q2
2,738
68.7%
52.9%
—
—
—
2024 Q3
2,738
66.7%
51.2%
—
—
—
2024 Q4
2,429
69.5%
52.5%
—
—
—
2025 Q1
2,781
67.7%
52.0%
—
—
—
2025 Q2
2,756
64.1%
46.8%
—
—
—
2025 Q3
2,672
62.0%
45.8%
—
—
—
2025 Q4
2,557
65.9%
51.8%
—
—
—
2026 Q1
2,630
68.8%
51.9%
—
—
—
2026 Q2
2,145
64.4%
48.9%
602
68.3%
52.7%
2026 Q3
1,383
63.2%
47.5%
529
67.7%
53.8%
2026 Q4
0
—
—
0
—
—
Ahead on cash, level or slightly behind on payment. KIDS X banks about
6 points more of the sale in the first two to three months. Every bit of that is money taken on the day:
a third pay in full against a fifth of adults, and the deposit runs about 41% of the sale against 34%.
Look at the instalment columns and the picture reverses — of the finance actually written, KIDS X customers have
paid slightly less than adults by the same age. They close harder; they do not pay better.
Lost payments — written off, and still owed
What this is. Money booked as revenue that has not arrived: cancelled outright, or still outstanding.
How it is worked out. Written off is Credits Applied on the Debtor Ledger. Still owed is its Balance Outstanding, split into instalments not yet due and genuinely overdue using each contract’s first due date and planned term.
Watch out. A young quarter always looks bad here because most of its money has not fallen due yet. Read the Overdue column, not Still owed.
Written off is debt cancelled outright and gone. Still owed is the balance outstanding —
some of it will arrive, and on the settled cohorts most of what is still owed at 24 months never does. Both are shown
against total revenue booked, so a paid-in-full customer correctly dilutes them.
Period
Sales
Revenue booked
Written off
Still owed
Not banked
2024 Q1
3,757
$9,051,119
$577,0856.4%
$2,372,37326.2%
$2,949,45832.6%
2024 Q2
3,577
$8,550,644
$424,7585.0%
$2,250,13026.3%
$2,674,88931.3%
2024 Q3
3,583
$8,179,823
$417,7235.1%
$2,142,11526.2%
$2,559,83831.3%
2024 Q4
3,103
$7,604,479
$364,2564.8%
$2,179,90628.7%
$2,544,16233.5%
2025 Q1
3,451
$8,778,166
$441,3165.0%
$2,687,94130.6%
$3,129,25735.6%
2025 Q2
3,307
$8,616,762
$406,5974.7%
$3,058,93635.5%
$3,465,53340.2%
2025 Q3
3,331
$8,329,811
$292,0473.5%
$2,984,29835.8%
$3,276,34539.3%
2025 Q4
3,297
$8,551,849
$253,3423.0%
$3,041,50635.6%
$3,294,84838.5%
2026 Q1
3,584
$9,760,812
$282,1412.9%
$4,070,50441.7%
$4,352,64444.6%
2026 Q2
3,715
$10,054,951
$334,3873.3%
$4,684,35346.6%
$5,018,73949.9%
2026 Q3
3,654
$9,799,571
$311,6493.2%
$5,159,99652.7%
$5,471,64555.8%
2026 Q4
1,655
$4,378,256
$77,0501.8%
$2,518,71557.5%
$2,595,76559.3%
Month by month
Month of sale
Sales
Paid in full
Revenue booked
Banked on the day
Finance collected
TOTAL BANKED
Still live (not due yet)
Overdue
Written off
Age (mo)
Check
Jan 2024
1,238
303 24.5%
$2,921,321
$1,166,23439.9%
$853,10929.2%
$2,019,34469.1%
$2070.0%
$695,58123.8%
$207,1957.1%
33
ok
Feb 2024
1,196
275 23.0%
$2,847,559
$1,076,82037.8%
$868,12130.5%
$1,944,94068.3%
$00.0%
$721,98025.4%
$183,5216.4%
32
$-2,883
Mar 2024
1,323
270 20.4%
$3,282,240
$1,128,16434.4%
$1,007,94630.7%
$2,136,11065.1%
$1,9040.1%
$957,12629.2%
$186,3685.7%
31
ok
Apr 2024
1,208
264 21.9%
$2,960,795
$1,041,81835.2%
$919,53531.1%
$1,961,35366.2%
$00.0%
$839,71728.4%
$158,5335.4%
30
ok
May 2024
1,202
287 23.9%
$2,851,730
$1,084,53238.0%
$888,55531.2%
$1,973,08769.2%
$00.0%
$737,24025.9%
$140,8374.9%
29
ok
Jun 2024
1,167
288 24.7%
$2,738,119
$1,052,13338.4%
$885,78232.4%
$1,937,91570.8%
$00.0%
$677,37224.7%
$125,3894.6%
28
$-2,556
Jul 2024
1,170
268 22.9%
$2,652,115
$952,67935.9%
$876,21433.0%
$1,828,89369.0%
$90.0%
$679,87725.6%
$140,7685.3%
27
$2,568
Aug 2024
1,218
287 23.6%
$2,738,180
$1,011,51936.9%
$835,43430.5%
$1,846,95367.5%
$5900.0%
$763,42027.9%
$127,1614.6%
26
ok
Sep 2024
1,195
290 24.3%
$2,789,528
$1,011,41436.3%
$925,91533.2%
$1,937,33069.5%
$00.0%
$700,86125.1%
$149,7945.4%
25
$1,544
Oct 2024
1,130
242 21.4%
$2,662,736
$902,85133.9%
$867,27332.6%
$1,770,12366.5%
$00.0%
$761,36628.6%
$131,1614.9%
24
ok
Nov 2024
1,050
248 23.6%
$2,620,698
$932,54135.6%
$833,94331.8%
$1,766,48467.4%
$3680.0%
$721,64427.5%
$130,2685.0%
23
$1,934
Dec 2024
923
184 19.9%
$2,321,045
$750,57932.3%
$764,87033.0%
$1,515,44965.3%
$2,5160.1%
$697,69530.1%
$102,8274.4%
22
$2,557
Jan 2025
1,045
218 20.9%
$2,561,048
$848,99233.2%
$889,59534.7%
$1,738,58767.9%
$1,5000.1%
$702,15127.4%
$112,5474.4%
21
$6,263
Feb 2025
1,142
221 19.4%
$3,003,291
$963,83332.1%
$952,43631.7%
$1,916,26963.8%
$00.0%
$925,20130.8%
$159,4375.3%
20
$2,384
Mar 2025
1,264
231 18.3%
$3,213,827
$1,056,89332.9%
$922,12228.7%
$1,979,01461.6%
$00.0%
$1,061,46233.0%
$169,3325.3%
19
$4,019
Apr 2025
1,116
177 15.9%
$2,880,321
$879,17630.5%
$871,88330.3%
$1,751,05860.8%
$1130.0%
$994,64534.5%
$132,2614.6%
18
$2,245
May 2025
1,129
194 17.2%
$2,886,906
$877,44230.4%
$802,28727.8%
$1,679,72958.2%
$1650.0%
$1,069,54037.0%
$137,5354.8%
17
ok
Jun 2025
1,062
180 16.9%
$2,849,535
$908,43031.9%
$809,00428.4%
$1,717,43460.3%
$5980.0%
$995,16234.9%
$136,8004.8%
16
ok
Jul 2025
1,012
192 19.0%
$2,557,060
$844,58233.0%
$724,47428.3%
$1,569,05661.4%
$00.0%
$886,39234.7%
$102,1104.0%
15
ok
Aug 2025
1,219
244 20.0%
$3,106,042
$1,047,30833.7%
$836,55626.9%
$1,883,86460.7%
$1,9600.1%
$1,106,44335.6%
$114,4883.7%
14
ok
Sep 2025
1,100
199 18.1%
$2,666,709
$819,92430.7%
$779,10829.2%
$1,599,03260.0%
$1,2060.0%
$989,20037.1%
$75,4492.8%
13
$1,822
Oct 2025
1,137
255 22.4%
$2,867,779
$1,069,00837.3%
$777,50427.1%
$1,846,51264.4%
$6250.0%
$953,05033.2%
$67,8422.4%
12
ok
Nov 2025
1,117
215 19.2%
$2,926,193
$980,22733.5%
$786,08326.9%
$1,766,31060.4%
$8,1150.3%
$1,049,38235.9%
$103,4583.5%
11
ok
Dec 2025
1,043
241 23.1%
$2,757,877
$1,001,54636.3%
$643,39223.3%
$1,644,93859.6%
$107,5623.9%
$923,52533.5%
$82,0423.0%
10
ok
Jan 2026
1,129
299 26.5%
$3,049,939
$1,135,20837.2%
$727,10323.8%
$1,862,31161.1%
$216,1007.1%
$862,00628.3%
$109,6463.6%
9
ok
Feb 2026
1,162
265 22.8%
$3,168,601
$1,122,82835.4%
$642,15120.3%
$1,764,97955.7%
$399,43812.6%
$941,12629.7%
$63,7232.0%
8
ok
Mar 2026
1,293
286 22.1%
$3,542,272
$1,165,98032.9%
$615,71517.4%
$1,781,69550.3%
$642,33018.1%
$1,009,60528.5%
$108,7723.1%
7
ok
Apr 2026
1,080
225 20.8%
$2,993,405
$1,035,82134.6%
$430,98414.4%
$1,466,80549.0%
$691,35123.1%
$747,55025.0%
$87,8152.9%
6
ok
May 2026
1,353
365 27.0%
$3,611,684
$1,377,21938.1%
$469,48113.0%
$1,846,70051.1%
$952,25426.4%
$706,74319.6%
$106,0062.9%
5
ok
Jun 2026
1,282
348 27.1%
$3,449,863
$1,317,61138.2%
$405,38111.8%
$1,722,99249.9%
$1,061,12430.8%
$525,33515.2%
$140,5664.1%
4
ok
Jul 2026
1,317
363 27.6%
$3,602,009
$1,358,89237.7%
$339,4559.4%
$1,698,34747.1%
$1,324,56236.8%
$457,88512.7%
$121,3273.4%
3
ok
Aug 2026
1,282
323 25.2%
$3,432,109
$1,247,14936.3%
$251,0157.3%
$1,498,16343.7%
$1,465,63042.7%
$345,82410.1%
$122,5423.6%
2
ok
Sep 2026
1,055
283 26.8%
$2,765,453
$995,63336.0%
$136,0894.9%
$1,131,72240.9%
$1,347,40648.7%
$218,6957.9%
$67,7802.5%
1
ok
Oct 2026
1,119
311 27.8%
$2,984,593
$1,203,09640.3%
$34,3481.2%
$1,237,44541.5%
$1,534,55851.4%
$141,0904.7%
$71,7002.4%
0
ok
Nov 2026
536
142 26.5%
$1,393,663
$544,82039.1%
$4260.0%
$545,24639.1%
$821,23158.9%
$21,8361.6%
$5,3500.4%
part month
ok
TOTAL
40,014
8,98322.4%
$101,656,242
$35,912,89835.3%
$24,373,29024.0%
$60,286,18859.3%
$10,583,42210.4%
$26,587,72626.2%
$4,182,3504.1%
New York — 8,990 sales, $22,119,340 booked
1,832 of them (20.4%) paid in full on the day, worth $3,197,913.
Month of sale
Sales
Paid in full
Revenue booked
Banked on the day
Finance collected
TOTAL BANKED
Still live (not due yet)
Overdue
Written off
Age (mo)
Check
Jan 2024
300
78 26.0%
$691,971
$244,93935.4%
$229,38233.1%
$474,32268.5%
$00.0%
$159,40623.0%
$58,8598.5%
33
$-615
Feb 2024
306
76 24.8%
$674,859
$223,51433.1%
$210,04431.1%
$433,55864.2%
$00.0%
$197,46529.3%
$45,0576.7%
32
$-1,221
Mar 2024
322
65 20.2%
$795,998
$238,87330.0%
$282,25735.5%
$521,13065.5%
$00.0%
$225,56228.3%
$49,4096.2%
31
ok
Apr 2024
317
71 22.4%
$773,321
$248,14232.1%
$247,15832.0%
$495,30064.0%
$00.0%
$237,16130.7%
$40,9385.3%
30
ok
May 2024
363
76 20.9%
$838,858
$265,43331.6%
$288,99834.5%
$554,43166.1%
$00.0%
$239,01228.5%
$45,7825.5%
29
ok
Jun 2024
327
65 19.9%
$792,791
$233,88229.5%
$295,10237.2%
$528,98466.7%
$00.0%
$227,89128.7%
$36,3884.6%
28
$-472
Jul 2024
339
78 23.0%
$793,144
$239,36130.2%
$296,37237.4%
$535,73367.5%
$00.0%
$210,87726.6%
$46,6135.9%
27
ok
Aug 2024
358
77 21.5%
$823,056
$249,46030.3%
$267,63032.5%
$517,09062.8%
$00.0%
$258,96331.5%
$47,0755.7%
26
ok
Sep 2024
309
65 21.0%
$740,396
$232,81231.4%
$272,96736.9%
$505,77868.3%
$00.0%
$188,94825.5%
$46,3276.3%
25
$-657
Oct 2024
321
54 16.8%
$787,445
$225,05428.6%
$265,94233.8%
$490,99662.4%
$00.0%
$256,71432.6%
$39,9705.1%
24
ok
Nov 2024
281
42 14.9%
$716,276
$186,92626.1%
$265,44937.1%
$452,37563.2%
$00.0%
$225,45631.5%
$38,8115.4%
23
$-365
Dec 2024
258
30 11.6%
$647,820
$146,90422.7%
$246,48138.0%
$393,38560.7%
$00.0%
$216,33733.4%
$38,4605.9%
22
$-362
Jan 2025
298
44 14.8%
$689,152
$161,28423.4%
$276,59240.1%
$437,87663.5%
$1,5000.2%
$217,37331.5%
$32,3824.7%
21
ok
Feb 2025
319
46 14.4%
$805,092
$209,10826.0%
$276,51234.3%
$485,62060.3%
$00.0%
$278,37434.6%
$41,1795.1%
20
ok
Mar 2025
326
41 12.6%
$787,843
$192,88324.5%
$227,42028.9%
$420,30353.3%
$00.0%
$314,51639.9%
$53,0896.7%
19
ok
Apr 2025
302
40 13.2%
$772,322
$192,03724.9%
$266,33234.5%
$458,36959.3%
$00.0%
$285,00536.9%
$28,9613.7%
18
ok
May 2025
310
52 16.8%
$713,347
$185,66726.0%
$208,22929.2%
$393,89655.2%
$00.0%
$274,32538.5%
$45,1996.3%
17
ok
Jun 2025
285
57 20.0%
$706,816
$221,36931.3%
$201,48428.5%
$422,85359.8%
$00.0%
$257,63736.5%
$26,3613.7%
16
ok
Jul 2025
255
46 18.0%
$602,818
$179,78729.8%
$162,86427.0%
$342,65156.8%
$00.0%
$238,51339.6%
$21,7203.6%
15
ok
Aug 2025
300
65 21.7%
$736,746
$235,70432.0%
$189,45625.7%
$425,16057.7%
$00.0%
$282,40638.3%
$29,1694.0%
14
ok
Sep 2025
244
39 16.0%
$572,268
$160,41028.0%
$163,15028.5%
$323,56056.5%
$9730.2%
$226,81939.6%
$20,7633.6%
13
ok
Oct 2025
261
46 17.6%
$614,798
$197,15532.1%
$176,76928.8%
$373,92460.8%
$00.0%
$229,06137.3%
$11,8781.9%
12
ok
Nov 2025
273
54 19.8%
$704,985
$219,36431.1%
$171,45924.3%
$390,82255.4%
$5890.1%
$261,62837.1%
$52,0667.4%
11
ok
Dec 2025
208
47 22.6%
$558,520
$162,96629.2%
$130,81523.4%
$293,78152.6%
$20,4293.7%
$207,01237.1%
$37,3106.7%
10
ok
Jan 2026
222
55 24.8%
$557,497
$168,75330.3%
$148,36526.6%
$317,11856.9%
$40,2377.2%
$177,00831.8%
$23,1634.2%
9
ok
Feb 2026
160
32 20.0%
$404,197
$119,39229.5%
$70,65717.5%
$190,04947.0%
$56,06913.9%
$145,57136.0%
$12,5153.1%
8
ok
Mar 2026
195
58 29.7%
$533,696
$187,54335.1%
$72,67913.6%
$260,22248.8%
$80,31315.0%
$175,07432.8%
$18,1503.4%
7
ok
Apr 2026
179
40 22.3%
$472,019
$120,31325.5%
$71,37115.1%
$191,68440.6%
$119,11325.2%
$142,77430.2%
$18,4503.9%
6
ok
May 2026
177
42 23.7%
$459,217
$153,21833.4%
$63,46013.8%
$216,67847.2%
$133,71829.1%
$93,67520.4%
$15,1503.3%
5
ok
Jun 2026
165
48 29.1%
$424,948
$152,64135.9%
$44,75410.5%
$197,39546.5%
$141,62533.3%
$67,19315.8%
$18,7354.4%
4
ok
Jul 2026
171
42 24.6%
$505,471
$176,97935.0%
$39,3537.8%
$216,33242.8%
$199,02939.4%
$72,13314.3%
$18,0273.6%
3
ok
Aug 2026
166
42 25.3%
$475,646
$166,83335.1%
$31,2406.6%
$198,07341.6%
$208,61943.9%
$46,6049.8%
$22,3504.7%
2
ok
Sep 2026
121
46 38.0%
$341,521
$142,83841.8%
$17,3135.1%
$160,15146.9%
$148,60643.5%
$14,6644.3%
$18,1005.3%
1
ok
Oct 2026
163
48 29.4%
$383,925
$148,69538.7%
$2,1030.5%
$150,79839.3%
$217,78556.7%
$12,5923.3%
$2,8000.7%
0
ok
Nov 2026
89
25 28.1%
$220,561
$78,56335.6%
$-1,650-0.7%
$76,91334.9%
$137,51862.3%
$3,0311.4%
$3,1001.4%
part month
ok
TOTAL
8,990
1,83220.4%
$22,119,340
$6,668,80130.1%
$6,178,50727.9%
$12,847,30858.1%
$1,506,1216.8%
$6,666,78030.1%
$1,104,3055.0%
Then vs now
Period
Sales
Paid in full
Avg sale
On day 1
by month 3
by month 6
by month 12
by month 18
by month 24
Latest
Collected to date $
Still live
Overdue
Ad spend
Collected per $1 ad spend
2024 Q1
928
23.6%
$2,331
32.7%
41.1%
49.6%
61.5%
65.2%
65.8%
66.1%
$1,429,009
0.0%
26.9%
no data
—
2024 Q2
1,007
21.1%
$2,388
31.1%
39.6%
49.0%
62.1%
64.8%
65.3%
65.6%
$1,578,715
0.0%
29.3%
no data
—
2024 Q3
1,006
21.9%
$2,343
30.6%
39.5%
49.4%
63.2%
65.3%
66.0%
66.1%
$1,558,601
0.0%
28.0%
no data
—
2024 Q4
860
14.7%
$2,502
26.0%
35.6%
45.7%
59.1%
61.5%
—
62.1%
$1,336,755
0.0%
32.5%
no data
—
2025 Q1
943
13.9%
$2,420
24.7%
33.6%
42.8%
55.3%
58.1%
—
58.9%
$1,343,799
0.1%
35.5%
no data
—
2025 Q2
897
16.6%
$2,444
27.3%
35.4%
43.8%
55.1%
—
—
58.2%
$1,275,118
0.0%
37.3%
no data
—
2025 Q3
799
18.8%
$2,393
30.1%
37.4%
44.9%
55.1%
—
—
57.1%
$1,091,370
0.1%
39.1%
no data
—
2025 Q4
742
19.8%
$2,531
30.9%
37.5%
45.3%
—
—
—
56.4%
$1,058,528
1.1%
37.1%
no data
—
2026 Q1
577
25.1%
$2,592
31.8%
38.4%
45.3%
—
—
—
51.3%
$767,388
11.8%
33.3%
no data
—
2026 Q2
521
25.0%
$2,603
31.4%
37.7%
—
—
—
—
44.7%
$605,757
29.1%
22.4%
no data
—
2026 Q3
458
28.4%
$2,888
36.8%
—
—
—
—
—
43.4%
$574,557
42.1%
10.1%
no data
—
2026 Q4
252
29.0%
$2,399
37.6%
—
—
—
—
—
37.7%
$227,711
58.8%
2.6%
no data
—
Month by month — New York's own collection pattern
What this is. The same grid as the Month by month tab, but only New York. One row per month of sales, one column per month of its life, each cell the share of that month’s total revenue banked then.
How it is worked out. Denominator is the whole SALE, so paid-in-full customers are in it. The $300 floor applies. Month 1 includes the deposit. The violet forecast cells use New York’s OWN last three months at each age, not the group’s — so a city that collects differently forecasts differently.
Watch out. A smaller city has fewer sales behind each cell, so a single large sale moves a number that the group-level grid would smooth out.
Month of sale
Sale value
1
2
3
4
5
6
7
8
9
10
11
12
After 12
Collected to date $
Collected to date %
Forecast total $
Forecast total %
Age (mo)
Jan 2024
$691,971
35.81%
5.02%
3.11%
3.19%
2.72%
2.42%
2.38%
1.91%
2.08%
1.61%
1.75%
1.44%
3.60%
$474,272
68.5%
$474,272
68.5%
33
Feb 2024
$674,859
33.36%
4.08%
3.24%
3.09%
2.49%
2.49%
2.08%
2.10%
2.26%
2.25%
1.49%
1.37%
2.56%
$433,558
64.2%
$433,558
64.2%
32
Mar 2024
$795,998
30.22%
4.82%
3.81%
3.06%
3.28%
2.94%
2.62%
2.58%
2.10%
1.83%
1.91%
1.59%
3.26%
$521,130
65.5%
$521,130
65.5%
31
Apr 2024
$773,321
32.65%
3.92%
3.07%
2.96%
2.47%
2.44%
2.37%
2.22%
1.89%
2.08%
1.61%
1.86%
3.07%
$495,200
64.0%
$495,200
64.0%
30
May 2024
$838,858
32.51%
4.65%
3.98%
3.27%
2.95%
3.08%
2.32%
2.37%
2.36%
1.93%
2.01%
1.15%
2.37%
$554,331
66.1%
$554,331
66.1%
29
Jun 2024
$792,791
29.62%
4.51%
3.78%
3.92%
3.62%
3.46%
3.13%
2.70%
2.82%
2.86%
2.51%
1.07%
2.02%
$528,984
66.7%
$528,984
66.7%
28
Jul 2024
$793,144
30.47%
4.26%
3.68%
3.64%
3.36%
3.19%
3.49%
2.90%
2.48%
2.53%
2.84%
1.02%
3.00%
$535,575
67.5%
$535,575
67.5%
27
Aug 2024
$823,056
30.40%
5.17%
3.99%
3.64%
3.09%
3.05%
2.48%
2.32%
1.81%
2.14%
1.88%
0.69%
1.45%
$517,090
62.8%
$517,090
62.8%
26
Sep 2024
$740,396
31.47%
4.93%
4.07%
3.44%
3.24%
3.24%
3.23%
2.72%
2.91%
2.43%
2.58%
1.01%
2.52%
$505,199
68.2%
$505,199
68.2%
25
Oct 2024
$787,445
28.64%
5.22%
3.66%
3.48%
3.12%
3.10%
2.82%
2.29%
2.36%
2.42%
1.89%
0.88%
1.88%
$490,996
62.4%
$490,996
62.4%
24
Nov 2024
$716,276
27.00%
5.10%
4.23%
3.58%
3.57%
3.20%
2.89%
2.57%
2.20%
2.32%
2.12%
1.02%
2.45%
$452,158
63.1%
$452,158
63.1%
23
Dec 2024
$647,820
22.85%
5.50%
4.13%
3.83%
3.06%
3.35%
2.73%
2.91%
2.88%
2.40%
2.29%
1.53%
2.23%
$393,385
60.7%
$393,385
60.7%
22
Jan 2025
$689,152
23.83%
4.41%
5.33%
3.83%
3.24%
3.13%
3.16%
3.35%
2.35%
2.48%
2.24%
1.54%
3.23%
$437,555
63.5%
$437,555
63.5%
21
Feb 2025
$805,092
26.14%
5.28%
4.07%
3.68%
3.07%
2.81%
2.56%
2.37%
2.29%
1.88%
2.10%
1.08%
2.12%
$485,520
60.3%
$485,520
60.3%
20
Mar 2025
$787,843
25.02%
4.06%
2.75%
3.13%
2.74%
1.85%
2.18%
2.52%
1.72%
1.63%
1.51%
1.13%
2.26%
$419,987
53.3%
$419,987
53.3%
19
Apr 2025
$772,322
25.36%
5.13%
4.08%
3.76%
2.38%
2.80%
2.49%
2.37%
2.08%
2.12%
1.91%
1.21%
2.55%
$457,775
59.3%
$457,775
59.3%
18
May 2025
$713,347
26.14%
3.47%
3.68%
2.99%
2.84%
2.39%
1.99%
1.98%
2.22%
1.88%
1.80%
1.18%
1.96%
$393,603
55.2%
$393,603
55.2%
17
Jun 2025
$706,816
31.55%
3.99%
2.87%
2.75%
2.94%
2.27%
2.34%
1.87%
1.96%
1.83%
1.94%
0.86%
1.95%
$422,188
59.7%
$422,188
59.7%
16
Jul 2025
$602,818
30.24%
3.40%
2.90%
2.81%
2.40%
2.51%
2.27%
1.76%
1.70%
1.76%
1.77%
0.87%
1.52%
$341,811
56.7%
$341,811
56.7%
15
Aug 2025
$736,746
32.41%
4.13%
2.81%
2.47%
2.05%
2.57%
2.03%
1.82%
1.82%
1.59%
1.53%
0.80%
1.83%
$424,178
57.6%
$431,047
58.5%
14
Sep 2025
$572,268
28.07%
4.49%
3.18%
2.86%
2.80%
2.32%
2.59%
2.13%
1.75%
1.67%
1.65%
1.12%
1.83%
$321,032
56.1%
$325,871
56.9%
13
Oct 2025
$614,798
32.58%
3.33%
3.28%
2.88%
2.47%
2.64%
2.31%
2.24%
2.19%
2.18%
1.70%
1.41%
1.83%
$371,978
60.5%
$381,257
62.0%
12
Nov 2025
$704,985
31.26%
3.76%
2.93%
2.96%
2.18%
1.91%
1.83%
1.67%
1.83%
2.00%
1.28%
1.18%
1.83%
$386,376
54.8%
$399,248
56.6%
11
Dec 2025
$558,520
29.10%
2.93%
3.12%
3.10%
2.92%
2.26%
2.01%
2.28%
1.56%
1.29%
1.30%
1.24%
1.83%
$289,761
51.9%
$306,864
54.9%
10
Jan 2026
$557,497
30.26%
4.48%
3.80%
3.01%
3.09%
2.62%
2.87%
2.07%
1.89%
1.82%
1.42%
1.24%
1.83%
$311,632
55.9%
$336,642
60.4%
9
Feb 2026
$404,197
29.65%
2.87%
2.89%
2.98%
1.99%
1.96%
1.39%
1.50%
1.34%
1.73%
1.42%
1.24%
1.83%
$188,225
46.6%
$213,332
52.8%
8
Mar 2026
$533,696
35.68%
2.63%
2.10%
1.99%
1.57%
1.61%
1.60%
1.31%
1.62%
1.73%
1.42%
1.24%
1.83%
$258,775
48.5%
$300,595
56.3%
7
Apr 2026
$472,019
26.42%
2.51%
2.72%
2.41%
2.11%
1.47%
1.45%
1.64%
1.62%
1.73%
1.42%
1.24%
1.83%
$184,462
39.1%
$229,211
48.6%
6
May 2026
$459,217
33.33%
3.10%
3.13%
2.52%
2.16%
2.22%
1.49%
1.64%
1.62%
1.73%
1.42%
1.24%
1.83%
$213,395
46.5%
$263,756
57.4%
5
Jun 2026
$424,948
37.39%
2.45%
2.71%
2.00%
1.78%
1.75%
1.49%
1.64%
1.62%
1.73%
1.42%
1.24%
1.83%
$196,852
46.3%
$250,911
59.0%
4
Jul 2026
$505,471
35.64%
2.79%
2.66%
1.13%
2.02%
1.75%
1.49%
1.64%
1.62%
1.73%
1.42%
1.24%
1.83%
$213,395
42.2%
$287,913
57.0%
3
Aug 2026
$475,646
35.29%
3.06%
2.20%
1.85%
2.02%
1.75%
1.49%
1.64%
1.62%
1.73%
1.42%
1.24%
1.83%
$192,883
40.6%
$271,823
57.1%
2
Sep 2026
$341,521
41.68%
3.60%
2.52%
1.85%
2.02%
1.75%
1.49%
1.64%
1.62%
1.73%
1.42%
1.24%
1.83%
$154,664
45.3%
$219,945
64.4%
1
Oct 2026
$383,925
38.85%
3.09%
2.52%
1.85%
2.02%
1.75%
1.49%
1.64%
1.62%
1.73%
1.42%
1.24%
1.83%
$149,145
38.8%
$234,413
61.1%
0
AVERAGE(settled months)
$16,077,137
29.39%
4.52%
3.64%
3.30%
2.92%
2.80%
2.57%
2.37%
2.20%
2.09%
1.97%
1.17%
2.22%
$9,987,292
62.1%
ALL MONTHS(excl. the part month)
$21,898,779
$12,717,067
58.1%
$13,371,172
61.1%
Dallas — 5,800 sales, $15,461,739 booked
1,260 of them (21.7%) paid in full on the day, worth $3,182,828.
Month of sale
Sales
Paid in full
Revenue booked
Banked on the day
Finance collected
TOTAL BANKED
Still live (not due yet)
Overdue
Written off
Age (mo)
Check
Jan 2024
180
43 23.9%
$482,189
$200,65741.6%
$132,22927.4%
$332,88669.0%
$2070.0%
$111,57823.1%
$37,9477.9%
33
$-429
Feb 2024
161
21 13.0%
$390,481
$107,77027.6%
$128,91433.0%
$236,68460.6%
$00.0%
$120,21330.8%
$33,4938.6%
32
ok
Mar 2024
199
26 13.1%
$530,614
$145,20327.4%
$174,65232.9%
$319,85560.3%
$00.0%
$175,94933.2%
$34,4256.5%
31
$386
Apr 2024
174
35 20.1%
$461,950
$149,87032.4%
$151,18832.7%
$301,05865.2%
$00.0%
$144,16731.2%
$16,6033.6%
30
ok
May 2024
156
35 22.4%
$395,235
$150,88038.2%
$128,77432.6%
$279,65470.8%
$00.0%
$99,40325.2%
$16,1774.1%
29
ok
Jun 2024
168
29 17.3%
$381,830
$126,22533.1%
$143,63537.6%
$269,86070.7%
$00.0%
$93,80524.6%
$20,5975.4%
28
$-2,432
Jul 2024
177
26 14.7%
$413,808
$103,87025.1%
$172,99941.8%
$276,86966.9%
$00.0%
$107,05425.9%
$28,4666.9%
27
$1,419
Aug 2024
194
26 13.4%
$471,550
$131,95528.0%
$174,98337.1%
$306,93865.1%
$5900.1%
$150,53031.9%
$13,2642.8%
26
ok
Sep 2024
156
24 15.4%
$394,300
$109,47527.8%
$148,30737.6%
$257,78265.4%
$00.0%
$108,57927.5%
$27,5957.0%
25
$344
Oct 2024
151
32 21.2%
$391,700
$132,99534.0%
$118,71730.3%
$251,71264.3%
$00.0%
$118,60930.3%
$22,2625.7%
24
$-883
Nov 2024
146
30 20.5%
$349,266
$118,27133.9%
$104,68430.0%
$222,95563.8%
$00.0%
$112,11632.1%
$13,9324.0%
23
$263
Dec 2024
139
30 21.6%
$331,692
$108,25732.6%
$94,78728.6%
$203,04461.2%
$00.0%
$116,39635.1%
$12,1293.7%
22
ok
Jan 2025
145
26 17.9%
$365,600
$117,92532.3%
$134,48436.8%
$252,40969.0%
$00.0%
$91,17324.9%
$19,7535.4%
21
$2,264
Feb 2025
183
20 10.9%
$502,848
$118,10023.5%
$140,88128.0%
$258,98151.5%
$00.0%
$200,20239.8%
$42,6368.5%
20
$1,029
Mar 2025
209
35 16.7%
$593,459
$188,68931.8%
$153,46625.9%
$342,15457.7%
$00.0%
$222,02737.4%
$28,6004.8%
19
$678
Apr 2025
162
26 16.0%
$426,100
$125,56029.5%
$110,48925.9%
$236,04955.4%
$00.0%
$171,92140.3%
$18,0404.2%
18
ok
May 2025
131
17 13.0%
$374,775
$94,48325.2%
$94,25325.1%
$188,73650.4%
$00.0%
$169,95245.3%
$16,1754.3%
17
ok
Jun 2025
155
23 14.8%
$423,810
$118,30027.9%
$93,31022.0%
$211,61049.9%
$00.0%
$193,01345.5%
$19,2204.5%
16
ok
Jul 2025
158
16 10.1%
$433,575
$105,57824.4%
$119,42127.5%
$224,99951.9%
$00.0%
$189,30143.7%
$19,3254.5%
15
ok
Aug 2025
199
37 18.6%
$526,525
$165,89231.5%
$128,94724.5%
$294,83956.0%
$9580.2%
$209,31139.8%
$21,4794.1%
14
ok
Sep 2025
191
23 12.0%
$527,290
$134,39425.5%
$153,58229.1%
$287,97654.6%
$00.0%
$232,29544.1%
$7,0651.3%
13
ok
Oct 2025
175
32 18.3%
$464,884
$173,16537.2%
$109,24223.5%
$282,40760.7%
$1500.0%
$169,43436.4%
$12,9402.8%
12
ok
Nov 2025
168
33 19.6%
$475,814
$168,70935.5%
$99,88621.0%
$268,59556.4%
$1,3040.3%
$197,34541.5%
$9,4182.0%
11
$-847
Dec 2025
163
44 27.0%
$462,250
$188,88940.9%
$94,25920.4%
$283,14861.3%
$11,0442.4%
$152,45333.0%
$15,7543.4%
10
ok
Jan 2026
168
47 28.0%
$475,959
$194,79940.9%
$105,59122.2%
$300,39063.1%
$33,8997.1%
$130,80827.5%
$10,9502.3%
9
ok
Feb 2026
187
56 29.9%
$546,914
$226,01541.3%
$99,97418.3%
$325,98959.6%
$58,94210.8%
$153,03828.0%
$8,9451.6%
8
ok
Mar 2026
192
56 29.2%
$561,963
$215,50238.3%
$84,13015.0%
$299,63253.3%
$87,58415.6%
$167,24729.8%
$7,5001.3%
7
ok
Apr 2026
141
43 30.5%
$446,530
$220,36349.4%
$55,31912.4%
$275,68261.7%
$70,27215.7%
$92,77720.8%
$7,8541.8%
6
ok
May 2026
194
72 37.1%
$513,620
$239,88746.7%
$57,97411.3%
$297,86158.0%
$99,94219.5%
$96,04718.7%
$19,7753.9%
5
ok
Jun 2026
189
66 34.9%
$517,799
$248,02047.9%
$48,5059.4%
$296,52557.3%
$116,76722.6%
$86,76216.8%
$17,7503.4%
4
ok
Jul 2026
170
60 35.3%
$458,500
$212,74946.4%
$35,2187.7%
$247,96754.1%
$115,23025.1%
$65,15914.2%
$30,1506.6%
3
ok
Aug 2026
150
49 32.7%
$362,980
$148,13840.8%
$22,6186.2%
$170,75647.0%
$132,97536.6%
$53,24914.7%
$6,0001.7%
2
ok
Sep 2026
150
49 32.7%
$387,279
$169,45843.8%
$15,1443.9%
$184,60147.7%
$160,30241.4%
$34,8769.0%
$7,5501.9%
1
ok
Oct 2026
158
50 31.6%
$459,350
$220,73748.1%
$3,1470.7%
$223,88448.7%
$211,12046.0%
$19,3964.2%
$5,0001.1%
0
ok
Nov 2026
61
23 37.7%
$159,300
$79,95050.2%
$00.0%
$79,95050.2%
$74,60046.8%
$4,7503.0%
$00.0%
part month
ok
TOTAL
5,800
1,26021.7%
$15,461,739
$5,460,72935.3%
$3,633,70523.5%
$9,094,43458.8%
$1,175,8877.6%
$4,560,93529.5%
$628,7704.1%
Then vs now
Period
Sales
Paid in full
Avg sale
On day 1
by month 3
by month 6
by month 12
by month 18
by month 24
Latest
Collected to date $
Still live
Overdue
Ad spend
Collected per $1 ad spend
2024 Q1
540
16.7%
$2,599
32.3%
40.7%
48.9%
60.1%
62.7%
63.0%
63.4%
$889,425
0.0%
29.1%
no data
—
2024 Q2
498
19.9%
$2,488
34.5%
43.7%
53.3%
65.6%
68.3%
68.5%
68.6%
$850,572
0.0%
27.2%
no data
—
2024 Q3
527
14.4%
$2,428
27.0%
37.1%
47.7%
61.6%
64.7%
65.6%
65.8%
$841,588
0.0%
28.6%
no data
—
2024 Q4
436
21.1%
$2,460
33.5%
41.8%
50.4%
60.2%
62.4%
—
63.2%
$677,710
0.0%
32.4%
no data
—
2025 Q1
537
15.1%
$2,722
29.1%
36.8%
44.6%
55.0%
57.8%
—
58.4%
$853,544
0.0%
35.1%
no data
—
2025 Q2
448
14.7%
$2,734
27.6%
34.1%
40.9%
49.7%
—
—
52.0%
$636,395
0.0%
43.7%
no data
—
2025 Q3
548
13.9%
$2,714
27.3%
34.4%
41.2%
52.3%
—
—
54.3%
$807,814
0.1%
42.4%
no data
—
2025 Q4
506
21.5%
$2,773
37.8%
44.5%
51.0%
—
—
—
59.5%
$834,150
0.9%
37.0%
no data
—
2026 Q1
547
29.1%
$2,897
40.2%
46.1%
52.6%
—
—
—
58.4%
$926,011
11.4%
28.5%
no data
—
2026 Q2
524
34.5%
$2,821
47.9%
53.0%
—
—
—
—
58.9%
$870,067
19.4%
18.6%
no data
—
2026 Q3
470
33.6%
$2,572
43.9%
—
—
—
—
—
49.9%
$603,324
33.8%
12.7%
no data
—
2026 Q4
219
33.3%
$2,825
48.6%
—
—
—
—
—
49.1%
$303,834
46.2%
3.9%
no data
—
Month by month — Dallas's own collection pattern
What this is. The same grid as the Month by month tab, but only Dallas. One row per month of sales, one column per month of its life, each cell the share of that month’s total revenue banked then.
How it is worked out. Denominator is the whole SALE, so paid-in-full customers are in it. The $300 floor applies. Month 1 includes the deposit. The violet forecast cells use Dallas’s OWN last three months at each age, not the group’s — so a city that collects differently forecasts differently.
Watch out. A smaller city has fewer sales behind each cell, so a single large sale moves a number that the group-level grid would smooth out.
Month of sale
Sale value
1
2
3
4
5
6
7
8
9
10
11
12
After 12
Collected to date $
Collected to date %
Forecast total $
Forecast total %
Age (mo)
Jan 2024
$482,189
42.42%
4.01%
3.13%
2.78%
2.14%
2.05%
1.74%
1.81%
1.95%
1.64%
1.46%
1.28%
1.60%
$332,886
69.0%
$332,886
69.0%
33
Feb 2024
$390,481
28.13%
4.49%
3.86%
3.27%
3.33%
2.56%
2.61%
2.13%
1.85%
1.76%
2.08%
1.41%
2.14%
$236,684
60.6%
$236,684
60.6%
32
Mar 2024
$530,614
27.42%
4.87%
3.53%
2.91%
2.98%
2.76%
2.22%
2.43%
1.98%
1.77%
2.09%
1.44%
2.57%
$319,855
60.3%
$319,855
60.3%
31
Apr 2024
$461,950
33.02%
4.56%
3.57%
3.34%
2.55%
2.35%
2.53%
2.14%
2.00%
1.89%
1.54%
1.35%
3.29%
$301,058
65.2%
$301,058
65.2%
30
May 2024
$395,235
38.71%
5.12%
3.59%
3.15%
3.12%
3.17%
3.09%
1.81%
1.82%
1.89%
2.45%
0.91%
1.29%
$279,654
70.8%
$279,654
70.8%
29
Jun 2024
$381,830
32.99%
5.71%
4.20%
3.93%
3.57%
3.78%
3.07%
3.21%
2.69%
2.05%
1.60%
1.18%
1.78%
$269,860
70.7%
$269,860
70.7%
28
Jul 2024
$413,808
25.74%
6.25%
4.12%
4.31%
3.62%
3.49%
3.59%
3.10%
2.90%
2.19%
2.12%
1.45%
3.03%
$276,869
66.9%
$276,869
66.9%
27
Aug 2024
$471,550
29.00%
4.52%
4.16%
3.61%
3.54%
3.27%
2.58%
2.80%
2.29%
2.14%
2.02%
1.18%
2.33%
$306,938
65.1%
$306,938
65.1%
26
Sep 2024
$394,300
29.08%
4.43%
3.98%
3.45%
3.64%
2.89%
3.30%
2.41%
2.07%
2.45%
1.76%
1.19%
3.57%
$257,617
65.3%
$257,617
65.3%
25
Oct 2024
$391,700
33.69%
4.65%
3.32%
3.51%
2.64%
3.27%
2.11%
2.35%
1.78%
1.73%
1.27%
0.74%
2.37%
$251,712
64.3%
$251,712
64.3%
24
Nov 2024
$349,266
34.59%
4.80%
3.50%
3.29%
2.68%
2.35%
2.15%
1.39%
1.95%
1.59%
1.21%
0.83%
2.84%
$222,955
63.8%
$222,955
63.8%
23
Dec 2024
$331,692
33.72%
3.80%
3.16%
3.17%
2.75%
2.20%
2.47%
1.99%
1.92%
1.66%
1.36%
0.83%
1.38%
$203,014
61.2%
$203,014
61.2%
22
Jan 2025
$365,600
33.22%
4.13%
3.97%
3.62%
3.56%
2.44%
2.85%
2.88%
2.50%
2.90%
2.24%
1.48%
2.13%
$252,086
69.0%
$252,086
69.0%
21
Feb 2025
$502,848
24.41%
3.96%
3.36%
2.43%
2.93%
1.92%
2.16%
1.81%
1.75%
1.31%
1.10%
0.99%
2.55%
$258,896
51.5%
$258,896
51.5%
20
Mar 2025
$593,459
32.31%
3.17%
2.92%
2.62%
2.54%
1.80%
1.71%
1.90%
1.56%
1.36%
1.26%
1.05%
2.29%
$342,076
57.6%
$342,076
57.6%
19
Apr 2025
$426,100
30.20%
3.46%
2.82%
2.24%
2.56%
2.01%
1.93%
2.71%
1.75%
1.67%
1.32%
1.10%
0.55%
$235,942
55.4%
$235,942
55.4%
18
May 2025
$374,775
25.83%
3.95%
2.18%
2.69%
2.08%
2.67%
1.50%
1.59%
1.41%
1.35%
1.34%
0.92%
1.98%
$187,719
50.1%
$187,719
50.1%
17
Jun 2025
$423,810
27.91%
3.03%
2.78%
2.61%
1.99%
1.46%
1.39%
1.63%
1.23%
1.17%
1.29%
1.04%
1.58%
$210,752
49.7%
$210,752
49.7%
16
Jul 2025
$433,575
25.09%
3.37%
2.72%
2.67%
2.06%
1.95%
2.35%
2.26%
1.85%
1.76%
1.35%
1.39%
1.94%
$224,381
51.8%
$224,381
51.8%
15
Aug 2025
$526,525
32.03%
3.54%
2.72%
1.87%
1.90%
2.11%
1.76%
2.32%
1.63%
1.60%
1.55%
1.12%
1.83%
$294,472
55.9%
$299,213
56.8%
14
Sep 2025
$527,290
25.93%
3.81%
3.34%
2.83%
2.56%
2.49%
2.30%
2.47%
2.27%
2.08%
1.78%
1.36%
1.83%
$286,847
54.4%
$294,033
55.8%
13
Oct 2025
$464,884
37.36%
3.27%
3.15%
2.10%
2.37%
2.23%
1.97%
1.77%
1.53%
1.70%
1.14%
0.85%
1.83%
$281,308
60.5%
$288,702
62.1%
12
Nov 2025
$475,814
36.78%
3.40%
2.65%
2.38%
1.84%
1.66%
1.81%
1.28%
1.42%
0.88%
1.24%
0.74%
1.83%
$266,862
56.1%
$275,555
57.9%
11
Dec 2025
$462,250
40.67%
3.07%
3.34%
2.36%
2.33%
2.10%
1.71%
1.51%
1.13%
1.34%
1.26%
1.00%
1.83%
$281,132
60.8%
$294,188
63.6%
10
Jan 2026
$475,959
42.11%
3.37%
2.83%
2.19%
2.49%
2.13%
2.28%
1.46%
1.64%
1.67%
1.21%
1.00%
1.83%
$295,910
62.2%
$315,131
66.2%
9
Feb 2026
$546,914
41.55%
3.30%
2.25%
2.36%
1.91%
2.26%
1.78%
1.71%
1.59%
1.30%
1.21%
1.00%
1.83%
$321,049
58.7%
$350,221
64.0%
8
Mar 2026
$561,963
38.53%
1.99%
2.64%
2.46%
2.35%
1.52%
1.76%
1.37%
1.46%
1.30%
1.21%
1.00%
1.83%
$295,687
52.6%
$333,891
59.4%
7
Apr 2026
$446,530
49.99%
2.61%
2.02%
2.03%
1.82%
1.31%
1.43%
1.51%
1.46%
1.30%
1.21%
1.00%
1.83%
$273,307
61.2%
$310,424
69.5%
6
May 2026
$513,620
46.79%
2.68%
2.41%
2.14%
1.80%
1.78%
1.67%
1.51%
1.46%
1.30%
1.21%
1.00%
1.83%
$295,875
57.6%
$347,155
67.6%
5
Jun 2026
$517,799
47.98%
2.78%
2.01%
2.22%
1.59%
1.55%
1.67%
1.51%
1.46%
1.30%
1.21%
1.00%
1.83%
$292,989
56.6%
$352,696
68.1%
4
Jul 2026
$458,500
46.38%
2.48%
2.12%
2.15%
1.73%
1.55%
1.67%
1.51%
1.46%
1.30%
1.21%
1.00%
1.83%
$243,649
53.1%
$304,468
66.4%
3
Aug 2026
$362,980
40.95%
2.48%
2.63%
2.17%
1.73%
1.55%
1.67%
1.51%
1.46%
1.30%
1.21%
1.00%
1.83%
$167,178
46.1%
$223,206
61.5%
2
Sep 2026
$387,279
44.21%
2.62%
2.22%
2.17%
1.73%
1.55%
1.67%
1.51%
1.46%
1.30%
1.21%
1.00%
1.83%
$181,384
46.8%
$249,746
64.5%
1
Oct 2026
$459,350
48.06%
2.53%
2.22%
2.17%
1.73%
1.55%
1.67%
1.51%
1.46%
1.30%
1.21%
1.00%
1.83%
$220,756
48.1%
$313,456
68.2%
0
AVERAGE(settled months)
$9,633,481
30.95%
4.18%
3.35%
2.98%
2.75%
2.48%
2.30%
2.22%
1.93%
1.79%
1.60%
1.15%
1.93%
$5,839,455
60.6%
ALL MONTHS(excl. the part month)
$15,302,439
$8,969,358
58.6%
$9,578,237
62.6%
Houston — 5,403 sales, $14,272,660 booked
1,028 of them (19.0%) paid in full on the day, worth $2,697,461.
Month of sale
Sales
Paid in full
Revenue booked
Banked on the day
Finance collected
TOTAL BANKED
Still live (not due yet)
Overdue
Written off
Age (mo)
Check
Jan 2024
172
33 19.2%
$392,579
$158,45540.4%
$129,18332.9%
$287,63873.3%
$00.0%
$89,15122.7%
$15,5524.0%
33
$238
Feb 2024
177
37 20.9%
$466,314
$192,79341.3%
$153,40232.9%
$346,19574.2%
$00.0%
$99,15721.3%
$20,9934.5%
32
ok
Mar 2024
171
38 22.2%
$451,520
$195,92543.4%
$129,96428.8%
$325,88972.2%
$00.0%
$105,33523.3%
$20,3934.5%
31
ok
Apr 2024
163
47 28.8%
$404,455
$194,72248.1%
$102,97625.5%
$297,69873.6%
$00.0%
$94,80523.4%
$11,8882.9%
30
ok
May 2024
154
31 20.1%
$422,045
$167,67439.7%
$119,97928.4%
$287,65368.2%
$00.0%
$112,23026.6%
$21,3615.1%
29
$802
Jun 2024
143
40 28.0%
$359,460
$162,86245.3%
$110,42230.7%
$273,28476.0%
$00.0%
$73,00220.3%
$12,8303.6%
28
$344
Jul 2024
128
32 25.0%
$322,885
$139,47943.2%
$88,57227.4%
$228,05170.6%
$00.0%
$76,44923.7%
$17,5455.4%
27
$840
Aug 2024
181
29 16.0%
$414,975
$154,84537.3%
$118,25328.5%
$273,09865.8%
$00.0%
$120,76629.1%
$21,1205.1%
26
ok
Sep 2024
155
35 22.6%
$353,600
$152,88043.2%
$97,27027.5%
$250,15070.7%
$00.0%
$97,62427.6%
$5,6701.6%
25
ok
Oct 2024
150
25 16.7%
$359,525
$128,51035.7%
$104,65429.1%
$233,16464.9%
$00.0%
$115,51732.1%
$10,8443.0%
24
ok
Nov 2024
141
35 24.8%
$357,930
$155,78043.5%
$96,12026.9%
$251,90070.4%
$00.0%
$82,03422.9%
$23,3686.5%
23
$629
Dec 2024
158
31 19.6%
$405,825
$150,78037.2%
$106,70426.3%
$257,48463.4%
$00.0%
$132,64332.7%
$15,1803.7%
22
$519
Jan 2025
142
29 20.4%
$390,500
$141,13636.1%
$121,29231.1%
$262,42867.2%
$00.0%
$118,72430.4%
$10,2802.6%
21
$-932
Feb 2025
168
35 20.8%
$459,625
$171,58037.3%
$138,30930.1%
$309,88967.4%
$00.0%
$130,27528.3%
$20,1804.4%
20
$-720
Mar 2025
174
34 19.5%
$428,899
$157,52936.7%
$109,00525.4%
$266,53462.1%
$00.0%
$145,09433.8%
$17,2304.0%
19
ok
Apr 2025
172
32 18.6%
$456,650
$158,41034.7%
$108,29623.7%
$266,70658.4%
$00.0%
$173,09237.9%
$16,8003.7%
18
ok
May 2025
177
24 13.6%
$464,200
$159,20534.3%
$116,66925.1%
$275,87459.4%
$00.0%
$171,48736.9%
$17,0103.7%
17
ok
Jun 2025
174
24 13.8%
$493,000
$158,83632.2%
$123,00425.0%
$281,84057.2%
$5980.1%
$183,01537.1%
$27,8925.7%
16
$-345
Jul 2025
161
29 18.0%
$420,949
$141,43933.6%
$117,14327.8%
$258,58261.4%
$00.0%
$144,96634.4%
$17,7614.2%
15
$-361
Aug 2025
176
28 15.9%
$446,125
$139,69531.3%
$128,48728.8%
$268,18260.1%
$00.0%
$166,60737.3%
$11,8202.6%
14
$-484
Sep 2025
153
24 15.7%
$349,245
$105,92530.3%
$102,74729.4%
$208,67259.7%
$00.0%
$127,39836.5%
$13,1753.8%
13
ok
Oct 2025
151
31 20.5%
$421,800
$167,71539.8%
$92,15521.8%
$259,87061.6%
$2500.1%
$159,73037.9%
$1,9500.5%
12
ok
Nov 2025
125
15 12.0%
$319,275
$93,57529.3%
$102,81632.2%
$196,39161.5%
$1,4480.5%
$115,17436.1%
$6,2752.0%
11
ok
Dec 2025
161
30 18.6%
$396,875
$116,54529.4%
$95,62524.1%
$212,17053.5%
$16,8714.3%
$161,28340.6%
$6,5501.7%
10
ok
Jan 2026
142
42 29.6%
$414,025
$153,58037.1%
$94,71822.9%
$248,29860.0%
$39,4759.5%
$113,38627.4%
$12,8673.1%
9
ok
Feb 2026
167
36 21.6%
$452,100
$157,02034.7%
$85,81319.0%
$242,83353.7%
$58,65513.0%
$134,55129.8%
$16,0673.6%
8
ok
Mar 2026
184
26 14.1%
$526,875
$128,05524.3%
$112,16021.3%
$240,21545.6%
$114,00621.6%
$144,78027.5%
$27,8755.3%
7
ok
Apr 2026
142
19 13.4%
$378,375
$96,97025.6%
$61,33316.2%
$158,30341.8%
$109,23428.9%
$98,48826.0%
$12,3503.3%
6
ok
May 2026
172
27 15.7%
$495,775
$138,63228.0%
$67,13013.5%
$205,76241.5%
$161,72232.6%
$112,89122.8%
$15,4003.1%
5
ok
Jun 2026
153
29 19.0%
$424,624
$120,68428.4%
$62,96714.8%
$183,65143.3%
$157,95437.2%
$63,11914.9%
$19,9004.7%
4
ok
Jul 2026
152
17 11.2%
$444,325
$107,17024.1%
$46,54710.5%
$153,71734.6%
$203,14345.7%
$64,78914.6%
$22,6755.1%
3
ok
Aug 2026
151
22 14.6%
$439,355
$113,34525.8%
$32,5707.4%
$145,91533.2%
$221,27250.4%
$41,7179.5%
$30,4506.9%
2
ok
Sep 2026
141
22 15.6%
$408,425
$97,98524.0%
$15,9103.9%
$113,89527.9%
$245,37560.1%
$34,4558.4%
$14,7003.6%
1
ok
Oct 2026
119
26 21.8%
$372,550
$134,00036.0%
$3,5871.0%
$137,58736.9%
$196,74852.8%
$18,4154.9%
$19,8005.3%
0
ok
Nov 2026
53
14 26.4%
$157,975
$63,00039.9%
$1300.1%
$63,13040.0%
$94,57459.9%
$2710.2%
$00.0%
part month
ok
TOTAL
5,403
1,02819.0%
$14,272,660
$4,976,73634.9%
$3,295,91223.1%
$8,272,64858.0%
$1,621,32611.4%
$3,822,42126.8%
$555,7503.9%
Then vs now
Period
Sales
Paid in full
Avg sale
On day 1
by month 3
by month 6
by month 12
by month 18
by month 24
Latest
Collected to date $
Still live
Overdue
Ad spend
Collected per $1 ad spend
2024 Q1
520
20.8%
$2,520
41.8%
49.5%
57.8%
69.2%
72.5%
72.9%
73.2%
$959,722
0.0%
22.4%
no data
—
2024 Q2
460
25.7%
$2,578
44.3%
53.0%
60.6%
70.3%
72.0%
72.3%
72.4%
$858,634
0.0%
23.6%
no data
—
2024 Q3
464
20.7%
$2,352
41.0%
47.9%
55.9%
66.2%
67.8%
68.7%
68.8%
$751,299
0.0%
27.0%
no data
—
2024 Q4
449
20.3%
$2,502
38.7%
46.7%
54.2%
63.7%
65.2%
—
66.1%
$742,547
0.0%
29.4%
no data
—
2025 Q1
484
20.2%
$2,643
36.8%
45.4%
53.6%
63.8%
65.4%
—
65.6%
$838,852
0.0%
30.8%
no data
—
2025 Q2
523
15.3%
$2,703
33.7%
41.6%
47.8%
56.1%
—
—
58.3%
$824,420
0.0%
37.3%
no data
—
2025 Q3
490
16.5%
$2,482
31.8%
39.8%
47.3%
58.9%
—
—
60.5%
$735,436
0.0%
36.1%
no data
—
2025 Q4
437
17.4%
$2,604
33.2%
40.9%
49.0%
—
—
—
58.7%
$668,432
1.6%
38.3%
no data
—
2026 Q1
493
21.1%
$2,826
31.5%
38.8%
46.3%
—
—
—
52.5%
$731,345
15.2%
28.2%
no data
—
2026 Q2
467
16.1%
$2,781
27.4%
34.7%
—
—
—
—
42.2%
$547,716
33.0%
21.1%
no data
—
2026 Q3
444
13.7%
$2,910
24.6%
—
—
—
—
—
32.0%
$413,528
51.8%
10.9%
no data
—
2026 Q4
172
23.3%
$3,084
37.1%
—
—
—
—
—
37.8%
$200,717
54.9%
3.5%
no data
—
Month by month — Houston's own collection pattern
What this is. The same grid as the Month by month tab, but only Houston. One row per month of sales, one column per month of its life, each cell the share of that month’s total revenue banked then.
How it is worked out. Denominator is the whole SALE, so paid-in-full customers are in it. The $300 floor applies. Month 1 includes the deposit. The violet forecast cells use Houston’s OWN last three months at each age, not the group’s — so a city that collects differently forecasts differently.
Watch out. A smaller city has fewer sales behind each cell, so a single large sale moves a number that the group-level grid would smooth out.
Month of sale
Sale value
1
2
3
4
5
6
7
8
9
10
11
12
After 12
Collected to date $
Collected to date %
Forecast total $
Forecast total %
Age (mo)
Jan 2024
$392,579
40.64%
3.51%
3.23%
3.13%
3.09%
2.31%
2.33%
2.08%
2.56%
1.74%
1.81%
1.40%
4.01%
$287,638
73.3%
$287,638
73.3%
33
Feb 2024
$466,314
41.82%
3.36%
3.78%
2.85%
2.54%
2.82%
2.45%
2.14%
2.32%
2.27%
1.61%
1.79%
2.89%
$346,195
74.2%
$346,195
74.2%
32
Mar 2024
$451,520
44.48%
3.53%
3.90%
3.10%
2.38%
2.56%
2.07%
1.98%
2.19%
1.56%
1.33%
0.87%
1.41%
$325,889
72.2%
$325,889
72.2%
31
Apr 2024
$404,455
48.55%
4.56%
3.16%
1.85%
2.68%
2.22%
2.32%
1.65%
1.57%
1.14%
1.06%
0.90%
1.02%
$297,698
73.6%
$297,698
73.6%
30
May 2024
$422,045
40.22%
4.39%
3.94%
2.61%
2.83%
2.19%
2.55%
1.98%
1.85%
1.70%
1.22%
0.79%
1.38%
$287,653
68.2%
$287,653
68.2%
29
Jun 2024
$359,460
45.52%
5.05%
4.13%
2.77%
3.20%
2.53%
2.03%
1.94%
1.91%
2.04%
1.84%
0.66%
2.00%
$273,284
76.0%
$273,284
76.0%
28
Jul 2024
$322,885
43.21%
4.18%
3.01%
2.69%
2.84%
2.45%
1.93%
2.33%
2.05%
1.41%
1.14%
0.54%
2.35%
$228,051
70.6%
$228,051
70.6%
27
Aug 2024
$414,975
37.31%
3.57%
3.17%
3.10%
3.09%
2.08%
1.94%
1.79%
2.28%
2.13%
1.55%
0.76%
2.63%
$273,098
65.8%
$273,098
65.8%
26
Sep 2024
$353,600
43.35%
3.65%
3.27%
2.49%
2.54%
2.64%
2.65%
2.27%
1.83%
1.67%
1.62%
0.79%
1.50%
$250,150
70.7%
$250,150
70.7%
25
Oct 2024
$359,525
37.42%
4.16%
2.97%
2.88%
2.68%
1.95%
1.94%
2.37%
1.87%
1.81%
1.41%
0.80%
2.34%
$232,987
64.8%
$232,987
64.8%
24
Nov 2024
$357,930
43.94%
3.32%
4.16%
2.73%
2.60%
2.16%
1.82%
1.56%
2.02%
1.63%
1.41%
0.80%
1.57%
$251,900
70.4%
$251,900
70.4%
23
Dec 2024
$405,825
37.38%
3.00%
3.93%
2.84%
2.55%
2.25%
1.92%
1.68%
1.75%
1.44%
1.71%
0.61%
2.14%
$257,431
63.4%
$257,431
63.4%
22
Jan 2025
$390,500
36.20%
4.42%
4.28%
4.13%
2.74%
2.43%
1.96%
3.14%
2.08%
2.01%
1.74%
0.40%
1.08%
$262,428
67.2%
$262,428
67.2%
21
Feb 2025
$459,625
37.33%
4.82%
4.65%
3.53%
2.81%
2.55%
2.13%
1.91%
2.02%
2.07%
1.64%
0.88%
0.86%
$309,689
67.4%
$309,689
67.4%
20
Mar 2025
$428,899
37.02%
4.42%
3.02%
2.03%
2.25%
2.12%
2.06%
1.71%
1.41%
1.46%
1.38%
0.62%
1.72%
$266,432
62.1%
$266,432
62.1%
19
Apr 2025
$456,650
35.29%
3.91%
2.77%
2.31%
1.90%
1.78%
1.92%
1.46%
1.75%
1.22%
1.35%
0.36%
1.27%
$266,512
58.4%
$266,512
58.4%
18
May 2025
$464,200
35.12%
3.88%
3.51%
2.02%
2.30%
1.76%
1.98%
1.45%
1.38%
1.23%
1.28%
0.72%
1.85%
$275,469
59.3%
$275,469
59.3%
17
Jun 2025
$493,000
32.49%
3.66%
4.25%
2.36%
2.26%
1.82%
2.20%
1.78%
2.07%
1.01%
1.47%
0.40%
0.94%
$280,765
57.0%
$280,765
57.0%
16
Jul 2025
$420,949
33.74%
4.44%
2.95%
2.92%
1.86%
2.06%
1.88%
2.41%
2.10%
1.98%
1.88%
0.83%
1.33%
$258,334
61.4%
$258,334
61.4%
15
Aug 2025
$446,125
32.07%
4.19%
3.51%
2.45%
2.75%
2.16%
2.01%
2.25%
2.78%
1.64%
1.36%
1.40%
1.37%
$267,617
60.0%
$269,440
60.4%
14
Sep 2025
$349,245
30.22%
4.12%
3.77%
3.20%
2.65%
2.87%
2.67%
2.25%
2.63%
2.16%
1.51%
1.02%
1.37%
$207,622
59.4%
$210,584
60.3%
13
Oct 2025
$421,800
41.09%
2.95%
3.10%
2.40%
2.25%
1.97%
2.01%
1.38%
1.29%
1.16%
1.09%
0.73%
1.37%
$259,670
61.6%
$265,236
62.9%
12
Nov 2025
$319,275
29.59%
4.27%
3.50%
3.48%
3.60%
2.92%
2.16%
3.45%
1.87%
2.25%
2.34%
1.43%
1.37%
$194,374
60.9%
$198,738
62.2%
11
Dec 2025
$396,875
30.33%
3.43%
3.21%
3.40%
2.50%
2.25%
1.91%
1.83%
1.43%
1.37%
1.20%
1.03%
1.37%
$209,773
52.9%
$219,279
55.3%
10
Jan 2026
$414,025
37.42%
2.48%
3.38%
2.97%
2.09%
2.16%
2.13%
1.99%
2.62%
1.69%
1.48%
1.03%
1.37%
$243,958
58.9%
$260,005
62.8%
9
Feb 2026
$452,100
35.16%
3.10%
2.97%
3.35%
2.29%
1.98%
1.49%
1.36%
1.32%
1.73%
1.48%
1.03%
1.37%
$239,687
53.0%
$265,052
58.6%
8
Mar 2026
$526,875
24.94%
4.26%
4.12%
3.20%
2.07%
2.25%
1.66%
2.12%
1.78%
1.73%
1.48%
1.03%
1.37%
$235,101
44.6%
$274,037
52.0%
7
Apr 2026
$378,375
26.00%
2.66%
3.69%
2.44%
2.23%
1.76%
1.71%
1.84%
1.78%
1.73%
1.48%
1.03%
1.37%
$153,255
40.5%
$188,169
49.7%
6
May 2026
$495,775
28.23%
3.30%
3.22%
2.10%
1.72%
1.97%
1.62%
1.84%
1.78%
1.73%
1.48%
1.03%
1.37%
$200,982
40.5%
$254,762
51.4%
5
Jun 2026
$424,624
29.27%
4.50%
3.10%
2.83%
2.26%
2.02%
1.62%
1.84%
1.78%
1.73%
1.48%
1.03%
1.37%
$178,180
42.0%
$232,824
54.8%
4
Jul 2026
$444,325
24.54%
3.33%
2.65%
3.00%
2.05%
2.02%
1.62%
1.84%
1.78%
1.73%
1.48%
1.03%
1.37%
$148,933
33.5%
$215,206
48.4%
3
Aug 2026
$439,355
26.04%
2.57%
3.15%
2.62%
2.05%
2.02%
1.62%
1.84%
1.78%
1.73%
1.48%
1.03%
1.37%
$139,559
31.8%
$216,592
49.3%
2
Sep 2026
$408,425
24.01%
2.98%
2.97%
2.62%
2.05%
2.02%
1.62%
1.84%
1.78%
1.73%
1.48%
1.03%
1.37%
$110,237
27.0%
$193,961
47.5%
1
Oct 2026
$372,550
36.21%
2.96%
2.97%
2.62%
2.05%
2.02%
1.62%
1.84%
1.78%
1.73%
1.48%
1.03%
1.37%
$134,914
36.2%
$222,318
59.7%
0
AVERAGE(settled months)
$9,042,106
38.67%
3.95%
3.58%
2.73%
2.56%
2.25%
2.12%
1.96%
1.98%
1.65%
1.47%
0.83%
1.61%
$5,970,780
66.0%
ALL MONTHS(excl. the part month)
$14,114,685
$8,155,466
57.8%
$8,733,680
61.9%
Florida — 5,266 sales, $14,058,044 booked
1,613 of them (30.6%) paid in full on the day, worth $3,565,918.
Month of sale
Sales
Paid in full
Revenue booked
Banked on the day
Finance collected
TOTAL BANKED
Still live (not due yet)
Overdue
Written off
Age (mo)
Check
Jan 2024
186
75 40.3%
$409,945
$209,75851.2%
$107,60126.2%
$317,35977.4%
$00.0%
$64,19115.7%
$28,4286.9%
33
ok
Feb 2024
153
56 36.6%
$360,729
$187,72952.0%
$107,68729.9%
$295,41681.9%
$00.0%
$41,96011.6%
$23,5906.5%
32
$-237
Mar 2024
216
58 26.9%
$490,959
$194,64439.6%
$152,18731.0%
$346,83170.6%
$00.0%
$117,70524.0%
$25,5675.2%
31
$856
Apr 2024
188
47 25.0%
$416,660
$140,69533.8%
$155,72637.4%
$296,42171.1%
$00.0%
$91,15521.9%
$27,7676.7%
30
$1,317
May 2024
163
61 37.4%
$372,718
$177,72847.7%
$103,36027.7%
$281,08875.4%
$00.0%
$72,06419.3%
$19,3585.2%
29
$208
Jun 2024
196
77 39.3%
$427,251
$205,63748.1%
$131,67730.8%
$337,31478.9%
$00.0%
$70,96416.6%
$18,6024.4%
28
$371
Jul 2024
163
69 42.3%
$378,709
$192,52950.8%
$92,91424.5%
$285,44375.4%
$00.0%
$71,51818.9%
$21,3435.6%
27
$405
Aug 2024
179
72 40.2%
$402,008
$199,76849.7%
$98,39724.5%
$298,16574.2%
$00.0%
$86,65021.6%
$16,1584.0%
26
$1,035
Sep 2024
155
46 29.7%
$377,630
$150,05939.7%
$105,03727.8%
$255,09667.6%
$00.0%
$100,91226.7%
$19,4505.2%
25
$2,172
Oct 2024
125
42 33.6%
$326,970
$143,23043.8%
$90,39527.6%
$233,62571.5%
$00.0%
$69,83321.4%
$21,8406.7%
24
$1,673
Nov 2024
147
39 26.5%
$391,920
$145,49637.1%
$131,51133.6%
$277,00770.7%
$00.0%
$93,69723.9%
$19,4705.0%
23
$1,746
Dec 2024
135
32 23.7%
$392,498
$144,95836.9%
$117,72030.0%
$262,67866.9%
$2,5160.6%
$105,30826.8%
$19,6865.0%
22
$2,310
Jan 2025
194
47 24.2%
$535,120
$210,30039.3%
$159,54529.8%
$369,84569.1%
$00.0%
$131,01024.5%
$29,2895.5%
21
$4,976
Feb 2025
157
36 22.9%
$430,549
$135,36931.4%
$166,88638.8%
$302,25570.2%
$00.0%
$105,29824.5%
$21,1384.9%
20
$1,858
Mar 2025
191
38 19.9%
$540,147
$194,42136.0%
$167,41331.0%
$361,83467.0%
$00.0%
$147,26327.3%
$27,4715.1%
19
$3,579
Apr 2025
160
31 19.4%
$438,780
$165,56837.7%
$133,28330.4%
$298,85168.1%
$00.0%
$108,44624.7%
$29,3146.7%
18
$2,169
May 2025
191
47 24.6%
$522,569
$197,72637.8%
$131,07425.1%
$328,80062.9%
$00.0%
$165,14731.6%
$28,3845.4%
17
ok
Jun 2025
161
25 15.5%
$480,876
$149,91231.2%
$159,71433.2%
$309,62664.4%
$00.0%
$147,16230.6%
$24,1205.0%
16
ok
Jul 2025
164
37 22.6%
$460,380
$173,02737.6%
$130,43228.3%
$303,45965.9%
$00.0%
$131,77628.6%
$25,1455.5%
15
ok
Aug 2025
149
40 26.8%
$461,265
$207,35545.0%
$115,86825.1%
$323,22370.1%
$00.0%
$118,43225.7%
$19,6824.3%
14
ok
Sep 2025
130
43 33.1%
$347,449
$162,43946.8%
$79,23422.8%
$241,67369.6%
$00.0%
$93,50126.9%
$12,2753.5%
13
ok
Oct 2025
158
50 31.6%
$473,397
$224,82747.5%
$107,88822.8%
$332,71570.3%
$00.0%
$121,82425.7%
$18,9084.0%
12
ok
Nov 2025
133
36 27.1%
$376,500
$151,73540.3%
$113,98130.3%
$265,71670.6%
$2,7030.7%
$104,43127.7%
$3,7001.0%
11
ok
Dec 2025
124
45 36.3%
$384,541
$176,91846.0%
$79,30420.6%
$256,22266.6%
$12,7513.3%
$108,00628.1%
$7,5632.0%
10
ok
Jan 2026
159
38 23.9%
$487,251
$191,25639.3%
$117,59224.1%
$308,84863.4%
$18,8783.9%
$134,12627.5%
$25,4005.2%
9
ok
Feb 2026
110
31 28.2%
$329,290
$134,80540.9%
$76,57023.3%
$211,37564.2%
$32,5799.9%
$80,43224.4%
$4,9041.5%
8
ok
Mar 2026
138
45 32.6%
$378,910
$156,33341.3%
$67,02317.7%
$223,35658.9%
$60,42615.9%
$84,69922.4%
$10,4352.8%
7
ok
Apr 2026
103
23 22.3%
$309,460
$104,15633.7%
$55,69418.0%
$159,85051.7%
$67,86721.9%
$72,69323.5%
$9,0502.9%
6
ok
May 2026
148
51 34.5%
$430,627
$202,11046.9%
$56,92713.2%
$259,03760.2%
$93,77121.8%
$69,77016.2%
$8,0501.9%
5
ok
Jun 2026
159
61 38.4%
$439,420
$199,65245.4%
$45,64710.4%
$245,29955.8%
$118,91427.1%
$60,97913.9%
$14,2793.2%
4
ok
Jul 2026
171
75 43.9%
$465,844
$231,57449.7%
$36,5847.9%
$268,15857.6%
$139,82730.0%
$47,53410.2%
$10,3252.2%
3
ok
Aug 2026
116
47 40.5%
$327,282
$163,58250.0%
$14,7744.5%
$178,35654.5%
$104,69432.0%
$28,7078.8%
$15,5254.7%
2
ok
Sep 2026
105
39 37.1%
$294,050
$130,27644.3%
$11,4593.9%
$141,73548.2%
$122,48241.7%
$17,3335.9%
$12,5504.3%
1
ok
Oct 2026
91
40 44.0%
$251,777
$113,29245.0%
$2,2220.9%
$115,51445.9%
$116,08546.1%
$7,3292.9%
$12,9005.1%
0
ok
Nov 2026
48
14 29.2%
$144,563
$65,95945.6%
$00.0%
$65,95945.6%
$76,16552.7%
$1890.1%
$2,2501.6%
part month
ok
TOTAL
5,266
1,61330.6%
$14,058,044
$5,934,82442.2%
$3,423,32424.4%
$9,358,14866.6%
$969,6576.9%
$3,072,04321.9%
$633,9164.5%
Then vs now
Period
Sales
Paid in full
Avg sale
On day 1
by month 3
by month 6
by month 12
by month 18
by month 24
Latest
Collected to date $
Still live
Overdue
Ad spend
Collected per $1 ad spend
2024 Q1
555
34.1%
$2,273
46.9%
54.5%
62.0%
72.4%
75.3%
75.9%
76.1%
$959,607
0.0%
17.7%
no data
—
2024 Q2
547
33.8%
$2,224
43.1%
51.9%
60.1%
72.4%
74.6%
75.0%
75.2%
$914,823
0.0%
19.2%
no data
—
2024 Q3
497
37.6%
$2,331
46.8%
53.9%
60.9%
70.1%
71.9%
72.4%
72.4%
$838,705
0.0%
22.4%
no data
—
2024 Q4
407
27.8%
$2,731
39.0%
47.2%
55.8%
66.6%
68.9%
—
69.6%
$773,309
0.2%
24.2%
no data
—
2025 Q1
542
22.3%
$2,778
35.9%
44.4%
53.1%
65.8%
68.4%
—
68.7%
$1,033,933
0.0%
25.5%
no data
—
2025 Q2
512
20.1%
$2,817
35.6%
43.5%
51.8%
62.7%
—
—
65.0%
$937,276
0.0%
29.2%
no data
—
2025 Q3
443
27.1%
$2,865
42.8%
49.5%
57.1%
67.3%
—
—
68.4%
$868,355
0.0%
27.1%
no data
—
2025 Q4
415
31.6%
$2,975
44.8%
51.6%
59.3%
—
—
—
69.2%
$854,653
1.3%
27.1%
no data
—
2026 Q1
407
28.0%
$2,937
40.4%
48.3%
55.8%
—
—
—
62.2%
$743,579
9.4%
25.0%
no data
—
2026 Q2
410
32.9%
$2,877
42.9%
49.1%
—
—
—
—
56.3%
$664,185
23.8%
17.2%
no data
—
2026 Q3
392
41.1%
$2,773
48.3%
—
—
—
—
—
54.1%
$588,249
33.8%
8.6%
no data
—
2026 Q4
139
38.8%
$2,851
45.2%
—
—
—
—
—
45.8%
$181,473
48.5%
1.9%
no data
—
Month by month — Florida's own collection pattern
What this is. The same grid as the Month by month tab, but only Florida. One row per month of sales, one column per month of its life, each cell the share of that month’s total revenue banked then.
How it is worked out. Denominator is the whole SALE, so paid-in-full customers are in it. The $300 floor applies. Month 1 includes the deposit. The violet forecast cells use Florida’s OWN last three months at each age, not the group’s — so a city that collects differently forecasts differently.
Watch out. A smaller city has fewer sales behind each cell, so a single large sale moves a number that the group-level grid would smooth out.
Month of sale
Sale value
1
2
3
4
5
6
7
8
9
10
11
12
After 12
Collected to date $
Collected to date %
Forecast total $
Forecast total %
Age (mo)
Jan 2024
$409,945
51.42%
3.14%
2.49%
2.97%
2.65%
2.00%
2.36%
2.01%
1.44%
1.18%
1.05%
1.12%
2.75%
$317,359
77.4%
$317,359
77.4%
33
Feb 2024
$360,729
52.42%
3.94%
3.29%
2.99%
2.03%
1.90%
2.09%
2.20%
2.19%
1.69%
1.49%
1.65%
2.29%
$295,416
81.9%
$295,416
81.9%
32
Mar 2024
$490,959
40.88%
4.11%
3.61%
2.75%
2.42%
2.67%
2.08%
1.96%
1.88%
1.78%
1.72%
1.42%
2.06%
$346,831
70.6%
$346,831
70.6%
31
Apr 2024
$416,660
34.24%
5.18%
3.29%
3.09%
2.90%
3.27%
2.91%
2.55%
2.31%
2.70%
2.22%
1.91%
2.45%
$296,421
71.1%
$296,421
71.1%
30
May 2024
$372,718
48.02%
4.13%
2.92%
2.47%
2.15%
2.28%
2.27%
2.06%
2.21%
2.08%
2.02%
0.70%
1.40%
$281,088
75.4%
$281,088
75.4%
29
Jun 2024
$427,251
50.18%
3.92%
3.88%
2.75%
2.73%
2.96%
2.78%
1.92%
1.80%
1.72%
1.72%
1.06%
1.19%
$337,314
78.9%
$337,314
78.9%
28
Jul 2024
$378,709
50.51%
3.55%
2.53%
2.40%
2.27%
2.14%
2.24%
2.11%
1.98%
1.45%
1.33%
0.84%
1.19%
$285,443
75.4%
$285,443
75.4%
27
Aug 2024
$402,008
49.81%
3.83%
3.74%
2.84%
2.27%
2.01%
1.91%
1.49%
1.60%
1.07%
1.30%
0.59%
1.54%
$298,165
74.2%
$298,165
74.2%
26
Sep 2024
$377,630
40.89%
4.01%
2.50%
3.12%
1.88%
2.26%
1.99%
2.57%
1.03%
1.57%
1.75%
0.88%
2.28%
$255,096
67.6%
$255,096
67.6%
25
Oct 2024
$326,970
43.84%
4.18%
3.36%
2.72%
2.71%
2.32%
3.09%
1.28%
1.61%
1.59%
1.54%
0.77%
1.94%
$233,625
71.5%
$233,625
71.5%
24
Nov 2024
$391,920
37.18%
5.13%
3.79%
3.28%
2.85%
2.92%
2.23%
2.15%
2.20%
1.78%
1.64%
1.56%
2.89%
$277,007
70.7%
$277,007
70.7%
23
Dec 2024
$392,498
36.93%
4.25%
3.60%
3.26%
2.97%
2.57%
2.32%
1.83%
1.89%
2.10%
1.84%
0.87%
1.66%
$262,434
66.9%
$262,434
66.9%
22
Jan 2025
$535,120
39.75%
4.24%
2.99%
3.06%
1.80%
2.41%
2.24%
2.01%
2.43%
2.42%
1.87%
0.75%
2.33%
$369,825
69.1%
$369,825
69.1%
21
Feb 2025
$430,549
31.75%
5.16%
4.47%
4.10%
3.40%
3.84%
3.10%
2.97%
3.02%
2.43%
2.64%
0.73%
1.85%
$302,255
70.2%
$302,255
70.2%
20
Mar 2025
$540,147
36.02%
4.41%
3.72%
2.46%
3.01%
2.66%
2.38%
2.55%
1.96%
2.38%
1.74%
1.02%
1.93%
$361,684
67.0%
$361,684
67.0%
19
Apr 2025
$438,780
39.81%
3.54%
3.31%
3.28%
2.65%
2.53%
2.27%
2.37%
2.12%
1.86%
1.91%
0.57%
1.45%
$298,676
68.1%
$298,676
68.1%
18
May 2025
$522,569
38.03%
3.58%
3.33%
2.78%
1.87%
2.56%
1.80%
1.69%
1.96%
1.40%
1.58%
0.58%
1.42%
$328,463
62.9%
$328,463
62.9%
17
Jun 2025
$480,876
31.17%
4.13%
3.90%
3.33%
3.13%
2.74%
2.45%
2.55%
2.25%
2.27%
2.07%
1.05%
2.32%
$308,952
64.2%
$308,952
64.2%
16
Jul 2025
$460,380
38.22%
3.76%
3.29%
2.63%
2.52%
2.33%
1.99%
2.53%
2.37%
1.81%
1.83%
1.11%
0.88%
$303,459
65.9%
$303,459
65.9%
15
Aug 2025
$461,265
45.21%
3.11%
3.36%
2.49%
2.84%
2.32%
1.71%
1.59%
1.86%
1.83%
1.48%
1.13%
1.55%
$323,030
70.0%
$328,313
71.2%
14
Sep 2025
$347,449
46.75%
2.89%
2.67%
2.70%
2.40%
2.41%
2.22%
1.94%
2.50%
0.98%
1.10%
0.44%
1.55%
$241,203
69.4%
$245,655
70.7%
13
Oct 2025
$473,397
47.85%
3.04%
2.74%
2.74%
2.17%
2.12%
1.99%
1.75%
1.81%
1.55%
1.30%
0.81%
1.55%
$332,318
70.2%
$339,242
71.7%
12
Nov 2025
$376,500
40.77%
3.92%
3.74%
3.01%
3.23%
3.15%
2.84%
2.35%
2.28%
1.83%
2.01%
1.12%
1.55%
$264,559
70.3%
$270,382
71.8%
11
Dec 2025
$384,541
46.36%
2.92%
2.90%
3.09%
1.86%
1.91%
1.46%
1.66%
1.37%
1.36%
1.20%
0.80%
1.55%
$254,143
66.1%
$263,164
68.4%
10
Jan 2026
$487,251
41.17%
3.93%
3.13%
2.68%
2.06%
2.68%
1.80%
1.35%
2.41%
1.49%
1.48%
0.80%
1.55%
$305,499
62.7%
$324,159
66.5%
9
Feb 2026
$329,290
42.26%
3.62%
2.85%
2.91%
3.38%
2.29%
1.95%
1.82%
1.75%
1.55%
1.48%
0.80%
1.55%
$206,897
62.8%
$224,623
68.2%
8
Mar 2026
$378,910
41.41%
3.71%
3.01%
2.31%
2.22%
1.99%
1.86%
1.45%
1.89%
1.55%
1.48%
0.80%
1.55%
$219,651
58.0%
$247,225
65.2%
7
Apr 2026
$309,460
34.06%
3.38%
3.35%
2.30%
2.84%
2.14%
2.47%
1.51%
1.89%
1.55%
1.48%
0.80%
1.55%
$156,409
50.5%
$183,607
59.3%
6
May 2026
$430,627
47.32%
3.85%
2.37%
1.84%
2.56%
1.73%
2.07%
1.51%
1.89%
1.55%
1.48%
0.80%
1.55%
$256,961
59.7%
$303,744
70.5%
5
Jun 2026
$439,420
45.52%
2.83%
2.19%
2.10%
2.02%
1.93%
2.07%
1.51%
1.89%
1.55%
1.48%
0.80%
1.55%
$240,168
54.7%
$296,399
67.5%
4
Jul 2026
$465,844
50.67%
2.63%
1.88%
1.42%
2.43%
1.93%
2.07%
1.51%
1.89%
1.55%
1.48%
0.80%
1.55%
$263,643
56.6%
$334,576
71.8%
3
Aug 2026
$327,282
49.82%
1.79%
2.00%
1.78%
2.43%
1.93%
2.07%
1.51%
1.89%
1.55%
1.48%
0.80%
1.55%
$175,429
53.6%
$231,079
70.6%
2
Sep 2026
$294,050
44.03%
2.53%
2.02%
1.78%
2.43%
1.93%
2.07%
1.51%
1.89%
1.55%
1.48%
0.80%
1.55%
$136,926
46.6%
$192,871
65.6%
1
Oct 2026
$251,777
45.00%
2.35%
2.02%
1.78%
2.43%
1.93%
2.07%
1.51%
1.89%
1.55%
1.48%
0.80%
1.55%
$113,292
45.0%
$167,110
66.4%
0
AVERAGE(settled months)
$9,438,529
41.93%
3.97%
3.33%
2.92%
2.53%
2.52%
2.28%
2.10%
2.03%
1.83%
1.70%
0.98%
1.66%
$6,658,724
70.5%
ALL MONTHS(excl. the part month)
$13,913,481
$9,249,641
66.5%
$9,732,487
70.0%
Boston — 4,603 sales, $11,172,073 booked
1,182 of them (25.7%) paid in full on the day, worth $2,316,641.
Month of sale
Sales
Paid in full
Revenue booked
Banked on the day
Finance collected
TOTAL BANKED
Still live (not due yet)
Overdue
Written off
Age (mo)
Check
Jan 2024
149
43 28.9%
$379,637
$193,99751.1%
$97,17325.6%
$291,17076.7%
$00.0%
$57,82715.2%
$30,6928.1%
33
ok
Feb 2024
139
48 34.5%
$363,601
$180,02149.5%
$112,74131.0%
$292,76280.5%
$00.0%
$50,66113.9%
$21,3195.9%
32
$-1,141
Mar 2024
165
48 29.1%
$394,669
$172,62443.7%
$137,31434.8%
$309,93878.5%
$00.0%
$69,07217.5%
$15,6824.0%
31
ok
Apr 2024
138
43 31.2%
$342,195
$158,47546.3%
$116,70934.1%
$275,18480.4%
$00.0%
$51,33615.0%
$15,7254.6%
30
ok
May 2024
128
43 33.6%
$314,642
$156,41149.7%
$94,07029.9%
$250,48179.6%
$00.0%
$48,13815.3%
$16,0885.1%
29
ok
Jun 2024
121
33 27.3%
$278,657
$126,54745.4%
$90,91332.6%
$217,46078.0%
$00.0%
$44,41415.9%
$16,8156.0%
28
ok
Jul 2024
149
34 22.8%
$316,951
$124,28939.2%
$123,14738.9%
$247,43678.1%
$90.0%
$56,23617.7%
$13,2834.2%
27
ok
Aug 2024
130
46 35.4%
$303,083
$160,25252.9%
$89,23929.4%
$249,49182.3%
$00.0%
$43,26314.3%
$10,3293.4%
26
ok
Sep 2024
129
30 23.3%
$325,199
$119,55836.8%
$128,30739.5%
$247,86576.2%
$00.0%
$58,69218.0%
$18,6425.7%
25
ok
Oct 2024
132
30 22.7%
$294,092
$102,10334.7%
$110,59037.6%
$212,69372.3%
$00.0%
$67,69323.0%
$13,8884.7%
24
$-182
Nov 2024
146
42 28.8%
$354,441
$131,66837.1%
$109,63230.9%
$241,30068.1%
$00.0%
$94,29526.6%
$19,1765.4%
23
$-330
Dec 2024
99
26 26.3%
$232,820
$88,24337.9%
$88,38138.0%
$176,62475.9%
$00.0%
$48,14820.7%
$8,0753.5%
22
ok
Jan 2025
137
43 31.4%
$250,488
$99,02639.5%
$81,88132.7%
$180,90772.2%
$00.0%
$59,04523.6%
$10,5484.2%
21
ok
Feb 2025
169
48 28.4%
$452,273
$192,63442.6%
$129,75228.7%
$322,38671.3%
$00.0%
$101,82822.5%
$27,7626.1%
20
$297
Mar 2025
193
44 22.8%
$474,799
$180,91438.1%
$150,95731.8%
$331,87169.9%
$00.0%
$117,25924.7%
$25,8775.5%
19
ok
Apr 2025
175
31 17.7%
$428,557
$142,48733.2%
$146,35634.2%
$288,84367.4%
$1130.0%
$119,78928.0%
$19,8634.6%
18
ok
May 2025
175
32 18.3%
$412,316
$136,82733.2%
$135,49932.9%
$272,32666.0%
$1650.0%
$126,43330.7%
$13,4023.3%
17
ok
Jun 2025
150
23 15.3%
$363,709
$122,50933.7%
$138,15938.0%
$260,66871.7%
$00.0%
$78,45921.6%
$24,5876.8%
16
ok
Jul 2025
140
34 24.3%
$285,148
$114,50340.2%
$102,04135.8%
$216,54475.9%
$00.0%
$65,66423.0%
$2,9581.0%
15
ok
Aug 2025
118
30 25.4%
$265,425
$97,28036.7%
$94,88735.7%
$192,16772.4%
$00.0%
$71,40526.9%
$1,8750.7%
14
ok
Sep 2025
100
21 21.0%
$214,470
$63,64529.7%
$77,65636.2%
$141,30165.9%
$00.0%
$71,44733.3%
$1,7540.8%
13
ok
Oct 2025
90
34 37.8%
$180,999
$70,70939.1%
$67,01637.0%
$137,72576.1%
$00.0%
$36,98520.4%
$6,3003.5%
12
ok
Nov 2025
116
23 19.8%
$310,128
$117,61837.9%
$92,03429.7%
$209,65267.6%
$00.0%
$90,05129.0%
$10,4253.4%
11
ok
Dec 2025
105
19 18.1%
$266,975
$98,29836.8%
$73,40327.5%
$171,70164.3%
$13,5085.1%
$75,23128.2%
$6,5382.4%
10
ok
Jan 2026
119
30 25.2%
$344,552
$139,25540.4%
$77,24122.4%
$216,49662.8%
$21,3806.2%
$92,15626.7%
$14,5204.2%
9
ok
Feb 2026
119
32 26.9%
$286,669
$108,71037.9%
$59,23820.7%
$167,94958.6%
$32,18711.2%
$82,57728.8%
$4,6061.6%
8
$-650
Mar 2026
92
17 18.5%
$256,186
$73,83628.8%
$57,10322.3%
$130,93951.1%
$44,45817.4%
$67,35226.3%
$13,4375.2%
7
ok
Apr 2026
99
20 20.2%
$254,232
$106,10641.7%
$41,57816.4%
$147,68458.1%
$45,96418.1%
$50,68419.9%
$9,9003.9%
6
ok
May 2026
118
37 31.4%
$296,234
$130,47744.0%
$35,25211.9%
$165,72955.9%
$63,26421.4%
$51,54017.4%
$15,7005.3%
5
ok
Jun 2026
132
27 20.5%
$327,341
$112,09934.2%
$49,00815.0%
$161,10749.2%
$97,12729.7%
$49,30715.1%
$19,8006.0%
4
ok
Jul 2026
165
52 31.5%
$423,036
$157,23637.2%
$40,0799.5%
$197,31546.6%
$154,01936.4%
$54,50212.9%
$17,2004.1%
3
ok
Aug 2026
155
33 21.3%
$412,966
$118,90628.8%
$42,09410.2%
$161,00039.0%
$198,12448.0%
$42,09310.2%
$11,7502.8%
2
ok
Sep 2026
110
29 26.4%
$271,304
$85,21931.4%
$16,6436.1%
$101,86237.5%
$142,92252.7%
$21,3707.9%
$5,2001.9%
1
ok
Oct 2026
135
36 26.7%
$345,965
$117,14633.9%
$6,2511.8%
$123,39735.7%
$198,14757.3%
$12,7713.7%
$11,6503.4%
0
ok
Nov 2026
66
21 31.8%
$148,314
$54,46436.7%
$00.0%
$54,46436.7%
$89,20460.1%
$4,6463.1%
$00.0%
part month
ok
TOTAL
4,603
1,18225.7%
$11,172,073
$4,354,09239.0%
$3,012,34727.0%
$7,366,43965.9%
$1,100,5899.9%
$2,232,37020.0%
$475,3664.3%
Then vs now
Period
Sales
Paid in full
Avg sale
On day 1
by month 3
by month 6
by month 12
by month 18
by month 24
Latest
Collected to date $
Still live
Overdue
Ad spend
Collected per $1 ad spend
2024 Q1
453
30.7%
$2,512
48.0%
58.0%
66.6%
76.7%
78.2%
78.5%
78.6%
$893,870
0.0%
15.6%
no data
—
2024 Q2
387
30.7%
$2,417
47.2%
57.1%
66.9%
77.3%
79.1%
79.3%
79.4%
$743,126
0.0%
15.4%
no data
—
2024 Q3
408
27.0%
$2,317
42.8%
52.6%
63.1%
75.9%
78.1%
78.7%
78.8%
$744,793
0.0%
16.7%
no data
—
2024 Q4
377
26.0%
$2,338
36.5%
46.7%
56.2%
68.1%
70.9%
—
71.6%
$630,617
0.0%
23.8%
no data
—
2025 Q1
499
27.1%
$2,360
40.1%
47.9%
56.9%
67.7%
70.6%
—
70.9%
$835,164
0.0%
23.6%
no data
—
2025 Q2
500
17.2%
$2,409
33.4%
41.8%
51.1%
64.9%
—
—
68.2%
$821,836
0.0%
27.0%
no data
—
2025 Q3
358
23.7%
$2,137
36.0%
45.2%
55.4%
70.1%
—
—
71.9%
$550,012
0.0%
27.3%
no data
—
2025 Q4
311
24.4%
$2,438
37.8%
46.0%
55.7%
—
—
—
68.5%
$519,079
1.8%
26.7%
no data
—
2026 Q1
330
23.9%
$2,689
36.3%
43.1%
51.1%
—
—
—
58.1%
$515,384
11.0%
27.3%
no data
—
2026 Q2
349
24.1%
$2,515
39.7%
46.2%
—
—
—
—
54.1%
$474,520
23.5%
17.3%
no data
—
2026 Q3
430
26.5%
$2,575
32.6%
—
—
—
—
—
41.6%
$460,177
44.7%
10.7%
no data
—
2026 Q4
201
28.4%
$2,459
34.7%
—
—
—
—
—
36.0%
$177,861
58.1%
3.5%
no data
—
Month by month — Boston's own collection pattern
What this is. The same grid as the Month by month tab, but only Boston. One row per month of sales, one column per month of its life, each cell the share of that month’s total revenue banked then.
How it is worked out. Denominator is the whole SALE, so paid-in-full customers are in it. The $300 floor applies. Month 1 includes the deposit. The violet forecast cells use Boston’s OWN last three months at each age, not the group’s — so a city that collects differently forecasts differently.
Watch out. A smaller city has fewer sales behind each cell, so a single large sale moves a number that the group-level grid would smooth out.
Month of sale
Sale value
1
2
3
4
5
6
7
8
9
10
11
12
After 12
Collected to date $
Collected to date %
Forecast total $
Forecast total %
Age (mo)
Jan 2024
$379,637
52.73%
3.70%
2.85%
3.43%
2.12%
2.14%
1.95%
1.65%
1.29%
1.27%
1.10%
0.53%
1.61%
$291,170
76.7%
$291,170
76.7%
33
Feb 2024
$363,601
51.17%
4.70%
4.41%
3.84%
3.17%
1.86%
2.15%
2.20%
2.02%
1.48%
1.27%
0.44%
1.61%
$292,762
80.5%
$292,762
80.5%
32
Mar 2024
$394,669
45.82%
4.39%
4.57%
3.37%
2.99%
2.67%
2.23%
2.74%
2.24%
2.21%
2.01%
1.43%
0.93%
$309,938
78.5%
$309,938
78.5%
31
Apr 2024
$342,195
47.83%
4.76%
3.74%
3.64%
3.89%
2.96%
2.72%
2.09%
2.01%
2.10%
1.41%
0.98%
1.36%
$275,184
80.4%
$275,184
80.4%
30
May 2024
$314,642
50.45%
4.42%
3.67%
3.84%
3.27%
2.70%
2.26%
1.89%
1.77%
1.60%
1.08%
0.96%
0.91%
$250,481
79.6%
$250,481
79.6%
29
Jun 2024
$278,657
46.52%
5.65%
4.19%
3.40%
3.11%
2.61%
1.99%
2.26%
1.56%
1.65%
2.06%
0.75%
1.72%
$217,460
78.0%
$217,460
78.0%
28
Jul 2024
$316,951
39.25%
5.26%
5.19%
4.46%
3.92%
3.45%
3.11%
2.67%
2.46%
2.66%
2.12%
0.97%
1.65%
$247,436
78.1%
$247,436
78.1%
27
Aug 2024
$303,083
52.71%
4.61%
3.30%
2.96%
2.97%
2.22%
2.46%
2.43%
2.52%
1.69%
1.49%
0.75%
1.42%
$249,491
82.3%
$249,491
82.3%
26
Sep 2024
$325,199
37.39%
6.35%
4.24%
3.70%
3.54%
3.99%
2.81%
2.53%
2.18%
2.15%
1.95%
1.52%
2.58%
$247,653
76.2%
$247,653
76.2%
25
Oct 2024
$294,092
35.70%
4.97%
3.64%
3.91%
3.18%
3.40%
3.09%
2.43%
3.14%
2.05%
2.03%
1.46%
2.23%
$212,693
72.3%
$212,693
72.3%
24
Nov 2024
$354,441
37.19%
4.52%
4.11%
2.96%
2.86%
2.15%
1.91%
2.18%
1.78%
2.44%
1.40%
0.44%
3.72%
$241,300
68.1%
$241,300
68.1%
23
Dec 2024
$232,820
39.86%
6.67%
4.64%
4.01%
3.08%
3.37%
2.40%
2.74%
2.16%
1.57%
1.87%
0.94%
1.73%
$176,624
75.9%
$176,624
75.9%
22
Jan 2025
$250,488
40.20%
4.08%
3.99%
3.79%
2.65%
2.54%
2.04%
1.95%
2.13%
2.06%
1.37%
1.00%
3.53%
$180,907
72.2%
$180,907
72.2%
21
Feb 2025
$452,273
43.02%
3.69%
3.17%
3.00%
3.00%
2.51%
1.95%
1.96%
1.70%
1.48%
1.29%
1.00%
2.68%
$322,121
71.2%
$322,121
71.2%
20
Mar 2025
$474,799
38.69%
3.70%
3.47%
3.33%
3.03%
3.16%
2.24%
2.52%
2.32%
2.24%
1.85%
0.97%
1.76%
$331,776
69.9%
$331,776
69.9%
19
Apr 2025
$428,557
33.52%
4.63%
4.14%
2.55%
3.19%
2.68%
2.43%
2.59%
2.22%
2.49%
2.11%
1.34%
2.78%
$288,375
67.3%
$288,375
67.3%
18
May 2025
$412,316
33.20%
4.49%
3.53%
2.71%
3.28%
2.56%
3.16%
2.36%
2.03%
2.16%
1.85%
1.19%
2.42%
$271,589
65.9%
$271,589
65.9%
17
Jun 2025
$363,709
33.78%
4.28%
3.93%
4.54%
3.23%
3.36%
3.00%
3.00%
2.71%
2.69%
2.21%
2.07%
2.06%
$259,850
71.4%
$259,850
71.4%
16
Jul 2025
$285,148
40.79%
5.21%
3.78%
3.33%
3.38%
2.88%
3.03%
3.17%
3.20%
2.34%
1.84%
1.07%
0.58%
$216,544
75.9%
$216,544
75.9%
15
Aug 2025
$265,425
38.01%
4.05%
3.86%
3.11%
3.44%
2.39%
3.29%
2.42%
2.15%
1.71%
1.95%
3.44%
1.80%
$191,510
72.2%
$192,623
72.6%
14
Sep 2025
$214,470
29.82%
4.32%
3.96%
5.21%
3.83%
3.46%
3.22%
3.21%
2.51%
2.34%
2.39%
0.84%
1.80%
$141,206
65.8%
$144,066
67.2%
13
Oct 2025
$180,999
39.33%
4.62%
3.81%
4.96%
3.52%
3.06%
3.12%
3.12%
2.43%
2.13%
1.90%
2.63%
1.80%
$137,192
75.8%
$139,926
77.3%
12
Nov 2025
$310,128
39.25%
3.78%
3.60%
2.96%
2.52%
2.74%
2.54%
2.58%
2.29%
1.94%
1.60%
1.27%
1.80%
$208,001
67.1%
$213,597
68.9%
11
Dec 2025
$266,975
37.15%
3.84%
3.08%
4.17%
3.42%
2.49%
1.95%
2.28%
2.04%
1.61%
1.77%
1.49%
1.80%
$170,326
63.8%
$179,117
67.1%
10
Jan 2026
$344,552
40.66%
3.44%
2.74%
2.56%
3.18%
2.49%
2.33%
1.73%
1.68%
1.55%
1.73%
1.49%
1.80%
$214,835
62.4%
$232,155
67.4%
9
Feb 2026
$286,669
38.74%
3.69%
2.84%
2.81%
2.36%
2.28%
2.13%
1.45%
1.42%
1.70%
1.73%
1.49%
1.80%
$165,496
57.7%
$184,773
64.5%
8
Mar 2026
$256,186
29.24%
3.28%
3.13%
2.84%
2.73%
2.82%
2.32%
2.69%
1.71%
1.70%
1.73%
1.49%
1.80%
$125,687
49.1%
$147,288
57.5%
7
Apr 2026
$254,232
41.85%
2.78%
2.58%
2.33%
2.35%
2.89%
1.96%
1.92%
1.71%
1.70%
1.73%
1.49%
1.80%
$144,256
56.7%
$170,567
67.1%
6
May 2026
$296,234
44.14%
2.87%
2.82%
2.45%
1.60%
1.28%
2.14%
1.92%
1.71%
1.70%
1.73%
1.49%
1.80%
$163,421
55.2%
$200,408
67.7%
5
Jun 2026
$327,341
34.25%
3.88%
3.99%
2.85%
3.07%
2.28%
2.14%
1.92%
1.71%
1.70%
1.73%
1.49%
1.80%
$157,226
48.0%
$205,556
62.8%
4
Jul 2026
$423,036
36.97%
3.00%
3.18%
2.56%
2.36%
2.28%
2.14%
1.92%
1.71%
1.70%
1.73%
1.49%
1.80%
$193,351
45.7%
$265,812
62.8%
3
Aug 2026
$412,966
30.12%
3.81%
3.43%
2.62%
2.36%
2.28%
2.14%
1.92%
1.71%
1.70%
1.73%
1.49%
1.80%
$154,297
37.4%
$235,857
57.1%
2
Sep 2026
$271,304
31.91%
3.88%
3.50%
2.62%
2.36%
2.28%
2.14%
1.92%
1.71%
1.70%
1.73%
1.49%
1.80%
$97,113
35.8%
$160,180
59.0%
1
Oct 2026
$345,965
34.55%
3.52%
3.50%
2.62%
2.36%
2.28%
2.14%
1.92%
1.71%
1.70%
1.73%
1.49%
1.80%
$119,541
34.6%
$212,134
61.3%
0
AVERAGE(settled months)
$7,228,171
41.36%
4.61%
3.89%
3.54%
3.18%
2.79%
2.53%
2.42%
2.18%
2.03%
1.73%
1.17%
1.87%
$5,357,142
74.1%
ALL MONTHS(excl. the part month)
$11,023,759
$7,266,815
65.9%
$7,801,474
70.8%
Nashville — 3,772 sales, $9,231,426 booked
789 of them (20.9%) paid in full on the day, worth $1,834,279.
Month of sale
Sales
Paid in full
Revenue booked
Banked on the day
Finance collected
TOTAL BANKED
Still live (not due yet)
Overdue
Written off
Age (mo)
Check
Sep 2024
158
50 31.6%
$373,079
$161,36943.3%
$103,84827.8%
$265,21771.1%
$00.0%
$92,30924.7%
$16,0154.3%
25
$-462
Oct 2024
171
36 21.1%
$385,965
$129,24833.5%
$142,72237.0%
$271,96970.5%
$00.0%
$101,12826.2%
$13,1073.4%
24
$-240
Nov 2024
156
52 33.3%
$386,495
$174,05545.0%
$111,47828.8%
$285,53373.9%
$00.0%
$91,18023.6%
$9,7862.5%
23
ok
Dec 2024
134
35 26.1%
$310,390
$111,43735.9%
$110,79835.7%
$222,23571.6%
$00.0%
$78,86325.4%
$9,2983.0%
22
ok
Jan 2025
129
29 22.5%
$330,188
$119,32136.1%
$115,80135.1%
$235,12271.2%
$00.0%
$84,82525.7%
$10,2953.1%
21
ok
Feb 2025
146
36 24.7%
$352,904
$137,04238.8%
$100,09628.4%
$237,13867.2%
$00.0%
$109,22431.0%
$6,5421.9%
20
ok
Mar 2025
171
39 22.8%
$388,680
$142,45736.7%
$113,86129.3%
$256,31865.9%
$00.0%
$115,30329.7%
$17,0654.4%
19
ok
Apr 2025
145
17 11.7%
$357,912
$95,11426.6%
$107,12829.9%
$202,24256.5%
$00.0%
$136,39238.1%
$19,2835.4%
18
ok
May 2025
145
22 15.2%
$399,699
$103,53425.9%
$116,56429.2%
$220,09855.1%
$00.0%
$162,19540.6%
$17,3654.3%
17
ok
Jun 2025
137
28 20.4%
$381,324
$137,50436.1%
$93,33324.5%
$230,83760.5%
$00.0%
$135,87635.6%
$14,6203.8%
16
ok
Jul 2025
134
30 22.4%
$354,190
$130,24836.8%
$92,57226.1%
$222,82062.9%
$00.0%
$116,17232.8%
$15,2004.3%
15
ok
Aug 2025
164
21 12.8%
$410,206
$131,33132.0%
$111,59027.2%
$242,92159.2%
$1,0010.2%
$150,44936.7%
$15,8363.9%
14
ok
Sep 2025
134
19 14.2%
$315,139
$98,68831.3%
$100,78732.0%
$199,47563.3%
$00.0%
$106,74033.9%
$7,1262.3%
13
$1,798
Oct 2025
136
28 20.6%
$314,209
$112,95435.9%
$103,61133.0%
$216,56568.9%
$00.0%
$90,93928.9%
$6,7652.2%
12
ok
Nov 2025
136
21 15.4%
$300,750
$76,99525.6%
$81,20927.0%
$158,20452.6%
$1,1250.4%
$129,85743.2%
$11,5753.8%
11
ok
Dec 2025
131
16 12.2%
$307,754
$93,59430.4%
$77,54625.2%
$171,14055.6%
$16,6015.4%
$114,81137.3%
$5,2281.7%
10
ok
Jan 2026
133
25 18.8%
$354,705
$139,27539.3%
$81,40122.9%
$220,67662.2%
$28,8488.1%
$96,18527.1%
$9,0002.5%
9
ok
Feb 2026
160
23 14.4%
$427,125
$124,36929.1%
$119,18227.9%
$243,55157.0%
$64,30815.1%
$113,27026.5%
$6,0001.4%
8
ok
Mar 2026
129
22 17.1%
$314,450
$96,31530.6%
$54,26517.3%
$150,58047.9%
$66,33721.1%
$89,88428.6%
$7,6502.4%
7
ok
Apr 2026
118
17 14.4%
$292,815
$88,59930.3%
$42,65414.6%
$131,25344.8%
$68,68423.5%
$84,42328.8%
$8,4562.9%
6
ok
May 2026
168
42 25.0%
$367,350
$115,23031.4%
$58,10815.8%
$173,33847.2%
$115,29031.4%
$75,27720.5%
$3,4500.9%
5
ok
Jun 2026
135
40 29.6%
$347,390
$143,41541.3%
$39,37211.3%
$182,78752.6%
$104,49730.1%
$57,28116.5%
$2,8250.8%
4
ok
Jul 2026
136
34 25.0%
$316,362
$108,06634.2%
$34,07210.8%
$142,13844.9%
$132,40541.9%
$37,31911.8%
$4,5001.4%
3
ok
Aug 2026
144
34 23.6%
$341,425
$128,26537.6%
$28,0868.2%
$156,35145.8%
$150,02443.9%
$32,5509.5%
$2,5000.7%
2
ok
Sep 2026
127
27 21.3%
$306,650
$108,68035.4%
$19,2606.3%
$127,94041.7%
$131,06842.7%
$45,14214.7%
$2,5000.8%
1
ok
Oct 2026
126
34 27.0%
$317,100
$127,25540.1%
$6,0581.9%
$133,31342.0%
$147,15946.4%
$33,02810.4%
$3,6001.1%
0
ok
Nov 2026
69
12 17.4%
$177,170
$51,56029.1%
$2960.2%
$51,85629.3%
$120,74868.2%
$4,5672.6%
$00.0%
part month
ok
TOTAL
3,772
78920.9%
$9,231,426
$3,185,92034.5%
$2,165,69823.5%
$5,351,61758.0%
$1,148,09412.4%
$2,485,19026.9%
$245,5872.7%
Then vs now
Period
Sales
Paid in full
Avg sale
On day 1
by month 3
by month 6
by month 12
by month 18
by month 24
Latest
Collected to date $
Still live
Overdue
Ad spend
Collected per $1 ad spend
2024 Q3
158
31.6%
$2,361
43.3%
51.1%
59.1%
68.8%
70.0%
71.0%
71.1%
$265,217
0.0%
24.7%
no data
—
2024 Q4
461
26.7%
$2,349
38.3%
47.5%
56.8%
69.8%
71.5%
—
72.0%
$779,738
0.0%
25.0%
no data
—
2025 Q1
446
23.3%
$2,403
37.2%
45.5%
53.8%
65.4%
67.5%
—
68.0%
$728,577
0.0%
28.9%
no data
—
2025 Q2
427
15.7%
$2,667
29.5%
36.9%
44.8%
55.1%
—
—
57.3%
$653,177
0.0%
38.1%
no data
—
2025 Q3
432
16.2%
$2,499
33.4%
41.1%
49.4%
60.4%
—
—
61.6%
$665,217
0.1%
34.6%
no data
—
2025 Q4
403
16.1%
$2,290
30.7%
38.7%
46.9%
—
—
—
59.2%
$545,909
1.9%
36.4%
no data
—
2026 Q1
422
16.6%
$2,598
32.8%
41.7%
49.1%
—
—
—
56.1%
$614,808
14.5%
27.3%
no data
—
2026 Q2
421
23.5%
$2,393
34.5%
41.0%
—
—
—
—
48.4%
$487,378
28.6%
21.5%
no data
—
2026 Q3
407
23.3%
$2,370
35.8%
—
—
—
—
—
44.2%
$426,429
42.9%
11.9%
no data
—
2026 Q4
195
23.6%
$2,535
36.2%
—
—
—
—
—
37.5%
$185,169
54.2%
7.6%
no data
—
Month by month — Nashville's own collection pattern
What this is. The same grid as the Month by month tab, but only Nashville. One row per month of sales, one column per month of its life, each cell the share of that month’s total revenue banked then.
How it is worked out. Denominator is the whole SALE, so paid-in-full customers are in it. The $300 floor applies. Month 1 includes the deposit. The violet forecast cells use Nashville’s OWN last three months at each age, not the group’s — so a city that collects differently forecasts differently.
Watch out. A smaller city has fewer sales behind each cell, so a single large sale moves a number that the group-level grid would smooth out.
Month of sale
Sale value
1
2
3
4
5
6
7
8
9
10
11
12
After 12
Collected to date $
Collected to date %
Forecast total $
Forecast total %
Age (mo)
Sep 2024
$373,079
43.44%
3.88%
3.83%
2.69%
2.82%
2.47%
2.07%
1.79%
1.66%
1.91%
1.36%
0.86%
1.58%
$265,217
71.1%
$265,217
71.1%
25
Oct 2024
$385,965
34.89%
4.64%
4.02%
5.09%
2.93%
2.75%
2.71%
2.65%
2.55%
2.24%
2.03%
1.17%
2.05%
$271,969
70.5%
$271,969
70.5%
24
Nov 2024
$386,495
45.50%
4.26%
4.01%
2.94%
2.83%
2.14%
2.87%
2.10%
1.99%
1.93%
1.43%
0.66%
0.86%
$285,533
73.9%
$285,533
73.9%
23
Dec 2024
$310,390
36.07%
4.43%
3.97%
3.44%
3.18%
2.86%
3.33%
2.92%
3.10%
2.27%
2.40%
0.88%
2.18%
$222,235
71.6%
$222,235
71.6%
22
Jan 2025
$330,188
36.44%
5.10%
3.50%
3.54%
3.11%
2.94%
2.66%
3.05%
2.42%
2.37%
2.19%
0.80%
2.38%
$235,037
71.2%
$235,037
71.2%
21
Feb 2025
$352,904
39.17%
3.89%
3.91%
2.81%
2.58%
2.44%
2.71%
2.12%
2.02%
1.63%
1.73%
0.31%
1.65%
$237,088
67.2%
$237,088
67.2%
20
Mar 2025
$388,680
37.00%
4.26%
3.20%
2.73%
2.62%
2.38%
2.55%
2.48%
2.29%
1.45%
1.49%
0.58%
2.31%
$256,068
65.9%
$256,068
65.9%
19
Apr 2025
$357,912
26.62%
4.38%
3.71%
3.49%
3.46%
2.41%
2.57%
1.95%
1.77%
1.64%
1.50%
0.70%
1.74%
$201,922
56.4%
$201,922
56.4%
18
May 2025
$399,699
26.22%
4.23%
3.14%
3.03%
2.71%
2.38%
2.86%
1.94%
1.82%
2.05%
1.91%
1.06%
1.17%
$220,098
55.1%
$220,098
55.1%
17
Jun 2025
$381,324
36.15%
3.47%
2.84%
2.36%
1.86%
1.91%
1.71%
1.59%
1.47%
1.39%
1.98%
1.02%
1.82%
$230,415
60.4%
$230,415
60.4%
16
Jul 2025
$354,190
37.42%
3.24%
3.59%
2.47%
2.49%
2.31%
2.04%
2.22%
1.63%
1.46%
1.48%
1.11%
1.03%
$222,512
62.8%
$222,512
62.8%
15
Aug 2025
$410,206
32.19%
3.84%
3.32%
2.67%
3.09%
2.44%
1.91%
1.65%
2.14%
2.09%
2.03%
0.76%
1.34%
$241,802
58.9%
$243,707
59.4%
14
Sep 2025
$315,139
32.31%
3.95%
3.45%
3.60%
3.21%
2.95%
2.50%
2.50%
2.70%
2.02%
2.08%
0.79%
1.34%
$198,612
63.0%
$201,267
63.9%
13
Oct 2025
$314,209
37.04%
3.83%
3.20%
3.45%
2.79%
3.03%
2.84%
2.49%
2.20%
2.22%
2.21%
1.37%
1.34%
$215,106
68.5%
$217,871
69.3%
12
Nov 2025
$300,750
26.04%
5.57%
2.63%
2.79%
2.27%
2.29%
2.26%
1.96%
1.89%
1.47%
1.45%
1.19%
1.34%
$155,732
51.8%
$159,775
53.1%
11
Dec 2025
$307,754
30.56%
3.64%
3.23%
3.34%
2.42%
2.35%
2.65%
2.12%
1.83%
1.36%
1.55%
1.12%
1.34%
$169,410
55.0%
$176,990
57.5%
10
Jan 2026
$354,705
39.42%
3.61%
3.33%
2.52%
2.14%
1.99%
2.13%
1.75%
1.93%
2.09%
1.74%
1.12%
1.34%
$216,056
60.9%
$230,971
65.1%
9
Feb 2026
$427,125
29.57%
5.65%
5.42%
3.50%
2.60%
2.86%
2.50%
1.72%
1.96%
1.66%
1.74%
1.12%
1.34%
$238,204
55.8%
$263,259
61.6%
8
Mar 2026
$314,450
30.97%
4.45%
2.46%
2.08%
2.20%
1.85%
1.69%
1.59%
1.91%
1.66%
1.74%
1.12%
1.34%
$148,705
47.3%
$173,163
55.1%
7
Apr 2026
$292,815
30.28%
2.90%
2.50%
2.41%
2.15%
2.07%
1.58%
1.69%
1.91%
1.66%
1.74%
1.12%
1.34%
$128,513
43.9%
$156,239
53.4%
6
May 2026
$367,350
32.21%
3.68%
2.93%
2.40%
2.06%
2.86%
1.99%
1.69%
1.91%
1.66%
1.74%
1.12%
1.34%
$169,530
46.1%
$211,626
57.6%
5
Jun 2026
$347,390
42.22%
2.96%
2.73%
1.95%
1.80%
2.30%
1.99%
1.69%
1.91%
1.66%
1.74%
1.12%
1.34%
$179,491
51.7%
$227,278
65.4%
4
Jul 2026
$316,362
34.25%
3.12%
2.70%
3.15%
2.00%
2.30%
1.99%
1.69%
1.91%
1.66%
1.74%
1.12%
1.34%
$136,707
43.2%
$186,554
59.0%
3
Aug 2026
$341,425
38.29%
3.48%
2.71%
2.48%
2.00%
2.30%
1.99%
1.69%
1.91%
1.66%
1.74%
1.12%
1.34%
$151,875
44.5%
$214,132
62.7%
2
Sep 2026
$306,650
35.57%
4.30%
2.71%
2.48%
2.00%
2.30%
1.99%
1.69%
1.91%
1.66%
1.74%
1.12%
1.34%
$122,264
39.9%
$186,501
60.8%
1
Oct 2026
$317,100
40.70%
3.62%
2.71%
2.48%
2.00%
2.30%
1.99%
1.69%
1.91%
1.66%
1.74%
1.12%
1.34%
$129,045
40.7%
$206,958
65.3%
0
AVERAGE(settled months)
$5,060,380
35.72%
4.10%
3.54%
3.15%
2.82%
2.51%
2.51%
2.22%
2.11%
1.89%
1.83%
0.86%
1.48%
$3,308,490
65.4%
ALL MONTHS(excl. the part month)
$9,054,256
$5,249,143
58.0%
$5,738,145
63.4%
Chicago — 2,582 sales, $6,325,507 booked
628 of them (24.3%) paid in full on the day, worth $1,184,005.
Month of sale
Sales
Paid in full
Revenue booked
Banked on the day
Finance collected
TOTAL BANKED
Still live (not due yet)
Overdue
Written off
Age (mo)
Check
Aug 2025
113
23 20.4%
$259,750
$70,05127.0%
$67,32125.9%
$137,37252.9%
$00.0%
$107,83241.5%
$14,6255.6%
14
ok
Sep 2025
148
30 20.3%
$340,848
$94,42327.7%
$101,95329.9%
$196,37657.6%
$2330.1%
$130,99938.4%
$13,2913.9%
13
ok
Oct 2025
166
34 20.5%
$397,692
$122,48330.8%
$120,82230.4%
$243,30561.2%
$2250.1%
$145,07736.5%
$9,1002.3%
12
ok
Nov 2025
166
33 19.9%
$438,741
$152,23134.7%
$124,69828.4%
$276,92963.1%
$9450.2%
$150,89634.4%
$9,9992.3%
11
ok
Dec 2025
151
40 26.5%
$380,962
$164,33543.1%
$92,44024.3%
$256,77567.4%
$16,3584.3%
$104,72927.5%
$3,1000.8%
10
ok
Jan 2026
186
62 33.3%
$415,950
$148,29035.7%
$102,19624.6%
$250,48660.2%
$33,3858.0%
$118,33728.4%
$13,7463.3%
9
ok
Feb 2026
156
34 21.8%
$381,106
$122,41232.1%
$72,92419.1%
$195,33651.3%
$48,91412.8%
$128,37033.7%
$8,4872.2%
8
ok
Mar 2026
212
39 18.4%
$514,137
$166,09232.3%
$86,26216.8%
$252,35449.1%
$93,02818.1%
$158,31330.8%
$10,4502.0%
7
ok
Apr 2026
187
44 23.5%
$517,324
$193,87437.5%
$60,15911.6%
$254,03249.1%
$126,98624.5%
$124,22224.0%
$12,0932.3%
6
ok
May 2026
175
44 25.1%
$462,701
$168,88136.5%
$60,19413.0%
$229,07549.5%
$132,13828.6%
$96,11720.8%
$5,3711.2%
5
ok
Jun 2026
159
41 25.8%
$385,807
$153,19439.7%
$46,41212.0%
$199,60651.7%
$122,76531.8%
$48,08612.5%
$15,4004.0%
4
ok
Jul 2026
156
41 26.3%
$387,581
$139,78836.1%
$42,42710.9%
$182,21547.0%
$150,56838.8%
$49,40412.7%
$5,4501.4%
3
ok
Aug 2026
196
65 33.2%
$479,745
$205,45842.8%
$36,6927.6%
$242,15050.5%
$186,32338.8%
$43,7239.1%
$7,5501.6%
2
ok
Sep 2026
159
42 26.4%
$372,257
$137,50736.9%
$20,1365.4%
$157,64342.3%
$187,67950.4%
$22,7556.1%
$4,1801.1%
1
ok
Oct 2026
168
41 24.4%
$405,777
$176,65743.5%
$5,4481.3%
$182,10544.9%
$202,11149.8%
$17,6114.3%
$3,9501.0%
0
ok
Nov 2026
84
15 17.9%
$185,130
$67,62436.5%
$00.0%
$67,62436.5%
$117,50663.5%
$00.0%
$00.0%
part month
ok
TOTAL
2,582
62824.3%
$6,325,507
$2,283,29936.1%
$1,040,08416.4%
$3,323,38352.5%
$1,419,16422.4%
$1,446,47122.9%
$136,7932.2%
Then vs now
Period
Sales
Paid in full
Avg sale
On day 1
by month 3
by month 6
by month 12
by month 18
by month 24
Latest
Collected to date $
Still live
Overdue
Ad spend
Collected per $1 ad spend
2025 Q3
261
20.3%
$2,301
27.4%
34.2%
41.9%
53.6%
—
—
55.6%
$333,748
0.0%
39.8%
no data
—
2025 Q4
483
22.2%
$2,520
36.1%
43.3%
52.2%
—
—
—
63.8%
$777,010
1.4%
32.9%
no data
—
2026 Q1
554
24.4%
$2,367
33.3%
40.0%
47.0%
—
—
—
53.2%
$698,176
13.4%
30.9%
no data
—
2026 Q2
521
24.8%
$2,622
37.8%
43.2%
—
—
—
—
50.0%
$682,713
28.0%
19.7%
no data
—
2026 Q3
511
29.0%
$2,426
38.9%
—
—
—
—
—
47.0%
$582,007
42.3%
9.3%
no data
—
2026 Q4
252
22.2%
$2,345
41.3%
—
—
—
—
—
42.3%
$249,729
54.1%
3.0%
no data
—
Month by month — Chicago's own collection pattern
What this is. The same grid as the Month by month tab, but only Chicago. One row per month of sales, one column per month of its life, each cell the share of that month’s total revenue banked then.
How it is worked out. Denominator is the whole SALE, so paid-in-full customers are in it. The $300 floor applies. Month 1 includes the deposit. The violet forecast cells use Chicago’s OWN last three months at each age, not the group’s — so a city that collects differently forecasts differently.
Watch out. A smaller city has fewer sales behind each cell, so a single large sale moves a number that the group-level grid would smooth out.
Month of sale
Sale value
1
2
3
4
5
6
7
8
9
10
11
12
After 12
Collected to date $
Collected to date %
Forecast total $
Forecast total %
Age (mo)
Aug 2025
$259,750
27.64%
2.74%
2.55%
2.03%
2.35%
2.17%
1.81%
1.71%
1.76%
2.95%
1.67%
1.11%
0.00%
$137,272
52.8%
$137,272
52.8%
14
Sep 2025
$340,848
28.00%
3.86%
3.36%
3.04%
2.71%
2.78%
2.43%
2.56%
2.02%
2.08%
1.98%
1.18%
0.00%
$196,005
57.5%
$196,005
57.5%
13
Oct 2025
$397,692
31.20%
3.17%
3.57%
3.22%
3.04%
2.99%
2.67%
2.62%
2.64%
2.40%
1.58%
0.96%
0.00%
$242,255
60.9%
$242,255
60.9%
12
Nov 2025
$438,741
35.27%
3.63%
3.82%
3.21%
2.65%
3.66%
2.57%
2.07%
2.03%
1.49%
1.36%
0.90%
0.00%
$274,939
62.7%
$274,939
62.7%
11
Dec 2025
$380,962
43.18%
3.05%
3.46%
2.30%
2.79%
2.58%
2.31%
1.88%
1.88%
1.74%
1.72%
1.00%
0.00%
$254,813
66.9%
$258,626
67.9%
10
Jan 2026
$415,950
36.28%
3.81%
3.27%
2.96%
2.96%
2.74%
2.39%
1.66%
1.81%
1.61%
1.54%
1.00%
0.00%
$247,473
59.5%
$258,060
62.0%
9
Feb 2026
$381,106
32.93%
3.45%
2.80%
2.29%
2.01%
1.88%
1.81%
1.90%
1.63%
1.61%
1.54%
1.00%
0.00%
$193,206
50.7%
$209,029
54.8%
8
Mar 2026
$514,137
32.49%
3.03%
2.38%
2.14%
1.91%
2.13%
2.14%
1.91%
1.77%
1.61%
1.54%
1.00%
0.00%
$247,415
48.1%
$277,883
54.0%
7
Apr 2026
$517,324
37.70%
2.02%
1.68%
2.53%
1.77%
1.52%
1.37%
1.83%
1.77%
1.61%
1.54%
1.00%
0.00%
$251,324
48.6%
$291,430
56.3%
6
May 2026
$462,701
37.04%
2.97%
3.01%
2.17%
1.85%
1.51%
1.77%
1.83%
1.77%
1.61%
1.54%
1.00%
0.00%
$224,596
48.5%
$268,648
58.1%
5
Jun 2026
$385,807
39.73%
3.19%
2.76%
2.75%
2.54%
1.72%
1.77%
1.83%
1.77%
1.61%
1.54%
1.00%
0.00%
$196,626
51.0%
$240,011
62.2%
4
Jul 2026
$387,581
36.25%
3.76%
3.19%
2.37%
2.01%
1.72%
1.77%
1.83%
1.77%
1.61%
1.54%
1.00%
0.00%
$176,584
45.6%
$227,965
58.8%
3
Aug 2026
$479,745
43.78%
3.90%
2.31%
2.41%
2.01%
1.72%
1.77%
1.83%
1.77%
1.61%
1.54%
1.00%
0.00%
$239,799
50.0%
$314,976
65.7%
2
Sep 2026
$372,257
37.07%
3.41%
2.72%
2.41%
2.01%
1.72%
1.77%
1.83%
1.77%
1.61%
1.54%
1.00%
0.00%
$150,683
40.5%
$219,132
58.9%
1
Oct 2026
$405,777
43.67%
3.71%
2.72%
2.41%
2.01%
1.72%
1.77%
1.83%
1.77%
1.61%
1.54%
1.00%
0.00%
$177,211
43.7%
$266,865
65.8%
0
AVERAGE(settled months)
$998,290
29.18%
3.30%
3.23%
2.85%
2.75%
2.70%
2.36%
2.37%
2.20%
2.43%
1.74%
1.07%
0.58%
$577,053
57.8%
ALL MONTHS(excl. the part month)
$6,140,377
$3,210,200
52.3%
$3,736,889
60.9%
Orlando — 1,523 sales, $4,514,965 booked
305 of them (20.0%) paid in full on the day, worth $905,030.
Month of sale
Sales
Paid in full
Revenue booked
Banked on the day
Finance collected
TOTAL BANKED
Still live (not due yet)
Overdue
Written off
Age (mo)
Check
Feb 2026
103
21 20.4%
$341,200
$130,10538.1%
$57,79216.9%
$187,89755.1%
$47,78514.0%
$103,31730.3%
$2,2000.6%
8
ok
Mar 2026
151
23 15.2%
$456,055
$142,30431.2%
$82,09318.0%
$224,39749.2%
$96,17921.1%
$122,25626.8%
$13,2752.9%
7
ok
Apr 2026
111
19 17.1%
$322,650
$105,44032.7%
$42,87713.3%
$148,31746.0%
$83,23125.8%
$81,48925.3%
$9,6633.0%
6
ok
May 2026
201
50 24.9%
$586,160
$228,78439.0%
$70,43512.0%
$299,21951.0%
$152,40926.0%
$111,42719.0%
$23,1103.9%
5
ok
Jun 2026
190
36 18.9%
$582,534
$187,90632.3%
$68,71811.8%
$256,62444.1%
$201,47534.6%
$92,60915.9%
$31,8775.5%
4
ok
Jul 2026
196
42 21.4%
$600,890
$225,33037.5%
$65,17410.8%
$290,50448.3%
$230,34238.3%
$67,04411.2%
$13,0002.2%
3
ok
Aug 2026
204
31 15.2%
$592,710
$202,62234.2%
$42,9407.2%
$245,56241.4%
$263,60044.5%
$57,1829.6%
$26,4174.5%
2
ok
Sep 2026
142
29 20.4%
$383,967
$123,67032.2%
$20,2255.3%
$143,89537.5%
$208,97254.4%
$28,1007.3%
$3,0000.8%
1
ok
Oct 2026
159
36 22.6%
$448,149
$165,31536.9%
$5,5321.2%
$170,84738.1%
$245,40354.8%
$19,9494.5%
$12,0002.7%
0
ok
Nov 2026
66
18 27.3%
$200,650
$83,70041.7%
$1,6500.8%
$85,35042.5%
$110,91755.3%
$4,3832.2%
$00.0%
part month
ok
TOTAL
1,523
30520.0%
$4,514,965
$1,595,17635.3%
$457,43610.1%
$2,052,61245.5%
$1,640,31336.3%
$687,75615.2%
$134,5413.0%
Then vs now
Period
Sales
Paid in full
Avg sale
On day 1
by month 3
by month 6
by month 12
by month 18
by month 24
Latest
Collected to date $
Still live
Overdue
Ad spend
Collected per $1 ad spend
2026 Q1
254
17.3%
$3,139
34.2%
40.9%
47.4%
—
—
—
51.7%
$412,295
18.1%
28.3%
no data
—
2026 Q2
502
20.9%
$2,971
35.0%
41.2%
—
—
—
—
47.2%
$704,160
29.3%
19.1%
no data
—
2026 Q3
542
18.8%
$2,911
35.0%
—
—
—
—
—
43.1%
$679,960
44.6%
9.7%
no data
—
2026 Q4
225
24.0%
$2,884
38.4%
—
—
—
—
—
39.5%
$256,197
54.9%
3.8%
no data
—
Month by month — Orlando's own collection pattern
What this is. The same grid as the Month by month tab, but only Orlando. One row per month of sales, one column per month of its life, each cell the share of that month’s total revenue banked then.
How it is worked out. Denominator is the whole SALE, so paid-in-full customers are in it. The $300 floor applies. Month 1 includes the deposit. The violet forecast cells use Orlando’s OWN last three months at each age, not the group’s — so a city that collects differently forecasts differently.
Watch out. A smaller city has fewer sales behind each cell, so a single large sale moves a number that the group-level grid would smooth out.
Month of sale
Sale value
1
2
3
4
5
6
7
8
9
10
11
12
After 12
Collected to date $
Collected to date %
Forecast total $
Forecast total %
Age (mo)
Feb 2026
$341,200
38.13%
3.66%
2.56%
2.05%
2.28%
1.87%
1.42%
1.47%
1.24%
0.00%
0.00%
0.00%
0.00%
$186,556
54.7%
$186,556
54.7%
8
Mar 2026
$456,055
31.27%
3.55%
3.58%
2.44%
2.25%
1.88%
2.15%
1.50%
1.24%
0.00%
0.00%
0.00%
0.00%
$221,707
48.6%
$227,340
49.8%
7
Apr 2026
$322,650
32.66%
2.63%
2.76%
2.20%
1.84%
1.53%
1.60%
1.48%
1.24%
0.00%
0.00%
0.00%
0.00%
$145,877
45.2%
$154,651
47.9%
6
May 2026
$586,160
39.80%
3.53%
1.86%
2.04%
2.12%
1.47%
1.77%
1.48%
1.24%
0.00%
0.00%
0.00%
0.00%
$297,906
50.8%
$324,208
55.3%
5
Jun 2026
$582,534
33.13%
3.44%
2.25%
2.34%
2.08%
1.62%
1.77%
1.48%
1.24%
0.00%
0.00%
0.00%
0.00%
$251,909
43.2%
$287,495
49.4%
4
Jul 2026
$600,890
37.88%
4.22%
2.99%
2.28%
2.04%
1.62%
1.77%
1.48%
1.24%
0.00%
0.00%
0.00%
0.00%
$284,621
47.4%
$333,601
55.5%
3
Aug 2026
$592,710
34.30%
3.27%
3.30%
2.22%
2.04%
1.62%
1.77%
1.48%
1.24%
0.00%
0.00%
0.00%
0.00%
$242,203
40.9%
$303,678
51.2%
2
Sep 2026
$383,967
32.23%
4.39%
2.85%
2.22%
2.04%
1.62%
1.77%
1.48%
1.24%
0.00%
0.00%
0.00%
0.00%
$140,610
36.6%
$191,370
49.8%
1
Oct 2026
$448,149
36.98%
3.90%
2.85%
2.22%
2.04%
1.62%
1.77%
1.48%
1.24%
0.00%
0.00%
0.00%
0.00%
$165,735
37.0%
$242,476
54.1%
0
AVERAGE(settled months)
$0
NaN%
NaN%
NaN%
NaN%
NaN%
NaN%
NaN%
NaN%
NaN%
NaN%
NaN%
NaN%
NaN%
$0
NaN%
ALL MONTHS(excl. the part month)
$4,314,315
$1,937,124
44.9%
$2,251,374
52.2%
Atlanta — 2,075 sales, $4,500,489 booked
346 of them (16.7%) paid in full on the day, worth $679,924.
Month of sale
Sales
Paid in full
Revenue booked
Banked on the day
Finance collected
TOTAL BANKED
Still live (not due yet)
Overdue
Written off
Age (mo)
Check
Jan 2024
251
31 12.4%
$565,000
$158,42828.0%
$157,54127.9%
$315,96955.9%
$00.0%
$213,42837.8%
$35,7186.3%
33
ok
Feb 2024
260
37 14.2%
$591,575
$184,99331.3%
$155,33226.3%
$340,32557.5%
$00.0%
$212,52335.9%
$39,0706.6%
32
$-343
Mar 2024
250
35 14.0%
$618,480
$180,89529.2%
$131,57221.3%
$312,46750.5%
$1,9040.3%
$263,50342.6%
$40,8926.6%
31
ok
Apr 2024
228
21 9.2%
$562,214
$149,91426.7%
$145,77925.9%
$295,69352.6%
$00.0%
$221,09239.3%
$45,6128.1%
30
ok
May 2024
238
41 17.2%
$508,232
$166,40632.7%
$153,37330.2%
$319,77962.9%
$00.0%
$166,39332.7%
$22,0724.3%
29
ok
Jun 2024
212
44 20.8%
$498,130
$196,97939.5%
$114,03422.9%
$311,01462.4%
$00.0%
$167,29533.6%
$20,1584.0%
28
$-336
Jul 2024
214
29 13.6%
$426,618
$153,15235.9%
$102,20924.0%
$255,36159.9%
$00.0%
$157,74437.0%
$13,5183.2%
27
ok
Aug 2024
176
37 21.0%
$323,508
$115,23935.6%
$86,93226.9%
$202,17162.5%
$00.0%
$103,24931.9%
$19,2155.9%
26
$-1,127
Sep 2024
133
40 30.1%
$225,324
$85,26237.8%
$70,18031.1%
$155,44269.0%
$00.0%
$53,79623.9%
$16,0957.1%
25
ok
Oct 2024
80
23 28.7%
$117,039
$41,71135.6%
$34,25429.3%
$75,96564.9%
$00.0%
$31,87127.2%
$9,2507.9%
24
ok
Nov 2024
33
8 24.2%
$64,370
$20,34531.6%
$15,06923.4%
$35,41455.0%
$3680.6%
$22,86735.5%
$5,7258.9%
23
ok
TOTAL
2,075
34616.7%
$4,500,489
$1,453,32332.3%
$1,166,27725.9%
$2,619,60058.2%
$2,2720.1%
$1,613,76135.9%
$267,3235.9%
Then vs now
Period
Sales
Paid in full
Avg sale
On day 1
by month 3
by month 6
by month 12
by month 18
by month 24
Latest
Collected to date $
Still live
Overdue
Ad spend
Collected per $1 ad spend
2024 Q1
761
13.5%
$2,333
29.5%
36.9%
43.0%
50.9%
53.4%
54.0%
54.6%
$968,761
0.1%
38.8%
no data
—
2024 Q2
678
15.6%
$2,314
32.7%
40.2%
47.3%
56.1%
58.5%
58.8%
59.1%
$926,486
0.0%
35.4%
no data
—
2024 Q3
523
20.3%
$1,865
36.3%
45.8%
52.7%
60.3%
62.2%
62.7%
62.8%
$612,974
0.0%
32.3%
no data
—
2024 Q4
113
27.4%
$1,605
34.2%
46.0%
54.6%
60.9%
61.4%
61.4%
61.4%
$111,380
0.2%
30.2%
no data
—
Month by month — Atlanta's own collection pattern
What this is. The same grid as the Month by month tab, but only Atlanta. One row per month of sales, one column per month of its life, each cell the share of that month’s total revenue banked then.
How it is worked out. Denominator is the whole SALE, so paid-in-full customers are in it. The $300 floor applies. Month 1 includes the deposit. The violet forecast cells use Atlanta’s OWN last three months at each age, not the group’s — so a city that collects differently forecasts differently.
Watch out. A smaller city has fewer sales behind each cell, so a single large sale moves a number that the group-level grid would smooth out.