Share:

Bad debt provision: Q3 2026 (Jul–Sep)

For Mike, Martin and Leanne. From the CRM debtor ledger, payments to 2026-11-17. Rates locked for 2026-Q3 on 2026-11-05. Provision = share of the money financed (sale minus deposit) that we do not expect to collect.

Book this: allowance on today’s balance
$3,283,219 63.5% of balance
Not expected to be collected (incl. credits)
$3,594,868 57.9% of financed
Elena (6 Nov sheet)
$3,091,384
Mike’s P&L
$3,275,538

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

Applied to $6,211,447 financed that is $3,594,868 not expected to be collected. $311,649 of that has already been credited on these sales (refunds, discounts, write-offs), so it is already off the balance. The allowance to book against today’s balance of $5,168,537 is $3,283,219.

2. One figure per city

CityProvisionFinancedNot collected $Credits already postedAllowance to bookMike’s P&L $Elena $
Florida incl. Orlando57%$1,588,719$911,654−$80,817$830,838$792,210$750,622
Texas Dallas + Houston61%$1,658,940$1,012,352−$111,525$900,827$913,765$875,232
Boston55%$746,545$409,724−$34,150$375,574$362,099$321,372
Chicago59%$759,036$447,503−$17,180$430,323$417,689$402,421
New York57%$837,938$476,072−$58,477$417,594$448,404$424,160
Nashville54%$620,269$337,563−$9,500$328,063$341,372$317,577
TOTAL58%$6,211,447$3,594,868−$311,649$3,283,219$3,275,538$3,091,384

3. By city and the deposit taken on the day (the most accurate)

Deposit % 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%

Which to use

How the rates are set

How often

Does it work?

Rebuilt as it would have been set at each past quarter-end and compared with what those sales have not collected by today: from 2023 on it lands within 1.8 points every quarter. In 2022 it was 3–17 points too low, because the rates then came from 2019–2020 sales, before the economy turned. That is why the rates are re-set every quarter and not left alone.

Full workings, every table and the check: https://reports.iconicbyai.com/bad-debt-provision