THECreditor List FREE TOOL · FROM FILE 001: JOANN
Free download for anyone who sells on credit

Don't end up on someone's creditor list.

The free calculator that shows how much of your business is riding on each customer, so you see the risk before one of them goes bust.

Free. Works in Excel and Google Sheets. You'll also get new episodes by email. Unsubscribe any time.

The calculator's Exposure Dashboard, showing $359,950 owed in total and one example customer holding 51.3%, flagged over the limit.
EXHIBIT A · the dashboard Free
ENTRY 1
WHY THIS EXISTS

Joann paid its suppliers in full. Ten months later, it didn't.

In March 2024, Joann went bankrupt and paid its suppliers every cent. So they kept shipping, on credit. In January 2025 it filed again, and this time suppliers were looking at zero to one percent.

The biggest unpaid supplier wasn't a bank or a giant. It was a small crochet-kit company that had been on Shark Tank.

LineCreditorOwed
1Low Tech Toy Club, LLC (The Woobles)$7,462,470.58
2SVP Sewing Brands LLC$5,209,124.72
3Federal Express Corporation$4,383,525.25

SOURCE: Joann Inc. voluntary petition, Official Form 204, Bankr. D. Del. case 25-10068, filed Jan 15, 2025.

Nobody plans to become a customer's number one unsecured creditor. This calculator is how you make sure you don't.

ENTRY 2
YOUR NUMBER

One number tells you how exposed you are.

Your exposure number is what one customer owes you, divided by everything you're owed. If that customer goes bust, it's the share of your money at risk. The calculator works it out for every customer and flags anyone over the limit you set.

Biggest customer owes you$184,500
÷ Everything you're owed$359,950
Exposure51.3%
Over limit

Example figures from the sample data. Your limit is up to you; 20% is a common starting point.

ENTRY 3
WHAT'S INSIDE

Five tabs. Fill in the yellow cells, and it does the rest.

TabWhat it does for you
CustomersEvery customer's share of what you're owed, flagged OVER LIMIT, WATCH or OK. Also tracks late payers and how much of each credit limit is used.
DashboardTotal owed, your biggest customer, everyone over your limit and a chart of your top 10.
After a BankruptcyA 12-step checklist for resetting terms with a customer that has just come out of bankruptcy.
20-Day WindowIf a customer files for US Chapter 11, log your deliveries and see which landed in the 20 days before the filing.
SettingsSet your own limit and warning level once. Every tab updates.
ENTRY 4
WHO IT'S FOR

If you ship now and get paid later, it's for you.

Suppliers and wholesalers selling to retailers
Manufacturers with a few big accounts
Agencies and studios on 30 to 60 day terms
Freelancers with one client paying most of the bills
ENTRY 5
CLOSING BALANCE

Get the free calculator.

Free. Excel and Google Sheets. Unsubscribe any time.