Bad debt provision — Q3 2026 sales

For Mike, Martin and Leanne · rates locked 2026-11-05 · CRM debtor ledger, payments to 2026-11-04

Book this: allowance
$3,296,256
62.5% of today's balance $5,275,115
Not expected to be collected
$3,595,750
57.9% of $6,213,897 financed
Elena's sheet
$3,091,384
Mike's P&L had $3,275,538

1. One figure for the business: 58% of the money financed

$3,595,750 of the $6,213,897 financed is not expected to be collected. $299,494 of that has already been credited on these sales (refunds, discounts, write-offs) and is already off the balance. Allowance to book: $3,296,256.

2. One figure per city

CityRate (of financed)FinancedNot collectedCredits postedAllowance to bookMike's P&LElena
Florida (incl. Orlando)57%$1,588,719$911,654−$74,292$837,363$792,210$750,622
Texas (Dallas + Houston)61%$1,661,390$1,013,234−$110,525$902,709$913,765$875,232
Boston55%$746,545$409,724−$34,150$375,574$362,099$321,372
Chicago59%$759,036$447,503−$16,550$430,953$417,689$402,421
New York57%$837,938$476,072−$55,477$420,594$448,404$424,160
Nashville54%$620,269$337,563−$8,500$329,063$341,372$317,577
TOTAL58%$6,213,897$3,595,750−$299,494$3,296,256$3,275,538$3,091,384

3. Most accurate: rate by city and the deposit taken on the day (of the money financed)

Deposit as % of saleFloridaTexasBostonChicagoNew YorkNashvilleAll cities
Under 15%66%68%64%69%65%62%66%
15–20%53%55%51%56%52%49%53%
20–30%46%48%44%49%45%42%46%
30–50%34%36%32%37%33%30%34%
50% or more26%28%24%29%25%22%26%

How to use it

Full workings: https://reports.iconicbyai.com/bad-debt-provision · Web version: https://reports.iconicbyai.com/bad-debt-summary