June 2026 · All product lines
Start with Bearings & Power Transmission and Fasteners & Fittings.
Bearings & Power Transmission: customers take 66 days to pay. Fasteners & Fittings: customers take 64 days to pay.
Product lines, June 2026
Worst first: most flags, then slowest to pay. A flag is a figure past a review or action limit. Open a line for the detail. Arrows show the trend: revenue and margin compare April to June with January to March; days to pay compares with April.
| Product line | Flags | Revenue YTD | Margin | Margin vs plan | Days to pay (DSO) | Over 90 days late 1 | Owed to you | Order book |
|---|---|---|---|---|---|---|---|---|
| Bearings & Power Transmission | 2 | $11.5M▲+ | 24.7%▼− | −1.3pp | 66d▼− | 2.4% | $4.4M | $1.7M |
| Fasteners & Fittings | 2 | $8.1M▲+ | 34.7%▲+ | −1.8pp | 64d→= | 2.0% | $3.0M | $1.2M |
| Shop Supplies & Consumables | 2 | $3.8M→= | 33.3%▲+ | −0.7pp | 62d▼− | 2.6% | $1.4M | $447.8k |
| Safety & PPE | 2 | $7.3M▼− | 23.6%▲+ | −0.4pp | 60d▲+ | 2.4% | $2.4M | $870.5k |
| Hydraulics & Pneumatics | 1 | $7.9M▲+ | 30.9%▲+ | +2.4pp | 61d▼− | 1.4% | $2.9M | $1.1M |
| Cutting Tools & Abrasives | 0 | $9.2M▼− | 29.0%▲+ | +1.0pp | 59d▼− | 4.5% | $3.1M | $1.2M |
| Not on a product line 2.7% of sales: freight and new items with no product group yet | does not apply: no limits apply to this row | $1.3M→= | 17.8%▲+ | does not apply: freight and new items have no plan to compare with | does not apply: freight and unmatched payments are not a customer paying late | does not apply: no invoices to chase sit here | $51.3k | $0 |
| Hartlen Industrial Supply Co. | 1 | $49.1M→= | 28.5%▲+ | does not apply: the plan is set per product line; compare each line above | 61d▼− | 2.5% | $17.3M | $6.6M |
Revenue YTD: 6 product lines $47,795,498.73 + not on a line $1,308,440.26 = company sales $49,103,938.99 ties to the cent
Owed to you: 6 product lines $17,227,956.81 + not on a line $51,289.84 = company total owed $17,279,246.65 ties to the cent
Every sale on a product line got there from its product group. What is owed on a line follows the invoices behind it. Left out of both: $199,000.11 of stock moved between your own branches this year, billed internally and not a sale.
The limits behind the flags
These limits are examples; yours would replace them. Set your own on the sample review and watch the lines re-rank.
Margin vs plan
Fine: +0.0pp or better Review: −2.0pp to +0.0pp Act: worse than −2.0pp
Any slip under plan is worth a look. More than 2 points under plan needs action.
Days to pay (DSO)
Fine: under 60d Review: 60d to 90d Act: over 90d
What customers owe, against the last three months of sales. Past 60 days needs review, past 90 needs action.
Over 90 days late
Fine: under 5.0% Review: 5.0% to 10.0% Act: over 10.0%
Some late debt is normal. Above 5% of the invoices you can chase needs review, above 10% needs action.
- 1
Over 90 days late counts only invoices you can chase, by days past the due date. Counting from the invoice date would show every Net 60 customer as late while it pays on time.
Your month, built like this
Send me last month's pack. Get it back automated.
Send the exports your system already produces and the pack your team built from them. You get an automated version with the same numbers, tying to the cent, and you check it against your own before you commit to anything.