Contact

June 2026 · Fasteners & Fittings

Margin is 1.8 points under plan this year.

That is $147k on sales already booked.

Revenue this year

$8.1M

plan $8.1M · same months last year $7.6M

Margin this year

34.7%

plan 36.5% · −1.8pp

Owed to you · 64 days to pay

$3.0M

63 on unpaid invoices alone, leaving disputes out

Stock

$2.8M

97 days on hand · earns $1.92 per $1

Where these figures come from

What makes up the $3.0M owed to you

You can chase

Invoices you can chaseThe only part a collections call can move. $2.8M 95.2% of what you are owed

A collections call will not clear these

Deductions customers are disputingThe part of an invoice a customer short-paid and disputes. Settling the claim clears it; a collections call will not. $43.0k 1.4% of what you are owed
Rebates suppliers owe youOwed by a supplier, not a customer, so purchasing collects it and it is left out of days to pay. $98.7k 3.3% of what you are owed

$2,838,751.72 you can chase + $141,662.96 other balances = $2,980,414.68 owed to you ✓ ties to the cent, across 179 open items

Collection rate this month

71.0% below 80%: review

A real share of what fell due is still unpaid. Make sure each large late account has an owner and a date.

Collection rate is the share of what fell due this month that was actually collected. Below 80% needs review, below 70% needs action.

What fell due: $2.8M owed at the start of the month + $1.4M billed − $2.3M not yet due at month end.

How late the invoices you can chase are

Days past the due date, out of $2.8M you can chase.

Not yet due $2.3M
1–30 days late $372.4k
31–60 days $98.5k
61–90 days $0
Over 90 days $55.9k

Cash tied up in stock: $2.8M

Days of stock on hand 97d at the last 12 months' cost of sales
Margin earned per $1 of stock (GMROI) $1.92 review below $1.50, act below $1.00

How long it has been on the shelf

Time since it arrived, out of $2.8M in stock.

Under 30 days $525.0k
31–60 days $444.2k
61–90 days $372.9k
3–6 months $514.5k
6–12 months $562.1k
Over a year $373.5k

By product group

Product group Stock Margin per $1 Older than 6 months
Stainless Fasteners $891.7k $1.90 42.7%
Steel Pipe Fittings $345.6k $1.45 37.7%
Rivets & Blind Fasteners $326.9k $2.44 17.3%
Brass Pipe Fittings $260.7k $1.79 30.4%
Structural Bolting $189.8k $2.10 29.6%
Threaded Rod & Studs $150.3k $2.53 17.8%
Washers & Retaining Rings $149.5k $1.86 45.7%
Tube Fittings & Ferrules $145.6k $1.87 36.3%
Hex Cap Screws $130.0k $1.57 25.2%
Socket Head Fasteners $115.6k $1.85 26.4%
Anchors & Concrete Fixings $86.6k $1.72 24.7%

Open orders: $1.2M due to ship

All open orders $1.2M including lines past the date the customer asked for
With a confirmed delivery date 50.2% $606.0k of all open orders
Due to ship $1.2M confirmed or still awaiting a date; leaves out lines past their date

Left out: $20.1k on 1 line past the date the customer asked for and still open. Each needs a call: ship it, agree a new date, or close it.

Needs your input

Rebates earned vs received

To compare rebates earned with rebates received, we need each program's terms, start and end dates and claim status. Your purchasing manager keeps these today.

Kept today by your purchasing manager.

How the figures tie

  • Each kind of balance adds up to what you are owed, to the cent checked
  • The late buckets add up to the invoices you can chase, to the cent checked
  • The stock age buckets add up to stock held, to the cent checked

Checked across 179 ledger rows, as of June 30, 2026.

Sales need no rule: each invoice line carries a product, and its product group belongs to one line. What is owed is held per invoice, so each dollar owed was placed like this:

  • Follows the invoice 96.2%
  • Follows the sales order under 0.1%
  • Supplier's rebate program 3.3%
  • Product named on the claim 0.1%
  • Customer's buying mix 0.4%

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.

Start with last month's pack Next: the invoices