Contact

June 2026 · Bearings & Power Transmission

Petrick Steel Products now takes 85 days to pay, up from 66 a year ago.

$1.1M of the $4.2M you can chase on this line sits with that one customer.

Revenue this year

$11.5M

plan $11.3M · same months last year $11.2M

Margin this year

24.7%

plan 26.0% · −1.3pp

Owed to you · 66 days to pay

$4.4M

64 on unpaid invoices alone, leaving disputes out

Stock

$4.9M

106 days on hand · earns $1.16 per $1

Where these figures come from

What makes up the $4.4M owed to you

You can chase

Invoices you can chaseThe only part a collections call can move. $4.2M 94.6% 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. $76.7k 1.7% 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. $160.8k 3.6% of what you are owed

$4,192,320.69 you can chase + $237,550.21 other balances = $4,429,870.90 owed to you ✓ ties to the cent, across 177 open items

Collection rate this month

73.8% 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: $4.5M owed at the start of the month + $1.9M billed − $3.4M not yet due at month end.

How late the invoices you can chase are

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

Not yet due $3.4M
1–30 days late $568.8k
31–60 days $106.6k
61–90 days $15.8k
Over 90 days $101.7k

Cash tied up in stock: $4.9M

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

2 product groups earn back less than $1 of margin per $1 of stock, $1.1M held

Legacy Bearing Housings $0.54 per $1 $857.8k held 66.3% older than six months

Also under $1: Pillow Blocks $0.97

How long it has been on the shelf

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

Under 30 days $657.1k
31–60 days $584.5k
61–90 days $547.4k
3–6 months $867.4k
6–12 months $1.2M
Over a year $1.0M

By product group

Product group Stock Margin per $1 Older than 6 months
Legacy Bearing Housings $857.8k $0.54 66.3%
Linear Guides $747.5k $1.02 35.9%
Gear Reducers $464.2k $1.11 35.5%
Mounted Ball Bearings $394.9k $1.23 35.9%
Roller Chain & Sprockets $388.7k $1.31 33.1%
V-Belts & Sheaves $352.5k $1.79 47.2%
Timing Belt Drives $352.1k $1.28 62.8%
Shaft Couplings $347.5k $1.83 42.3%
Tapered Roller Bearings $328.7k $1.35 38.9%
Pillow Blocks $264.3k $0.97 56.1%
Spherical Roller Bearings $184.8k $1.28 34.0%
Cam Followers $175.4k $1.36 32.2%

Open orders: $1.6M due to ship

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

Left out: $17.8k on 2 lines 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 177 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 94.6%
  • Follows the sales order 0.1%
  • Supplier's rebate program 3.6%
  • Product named on the claim 0.5%
  • Customer's buying mix 0.5%
  • Branch's main line 0.7%

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