Contact

June 2026 · Hydraulics & Pneumatics

$618k of Accumulators stock has not sold in three months.

88% of it has been on the shelf for over six.

Revenue this year

$7.9M

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

Margin this year

30.9%

plan 28.5% · +2.4pp

Owed to you · 61 days to pay

$2.9M

60 on unpaid invoices alone, leaving disputes out

Stock

$4.1M

137 days on hand · earns $1.16 per $1

Where these figures come from

What makes up the $2.9M owed to you

You can chase

Invoices you can chaseThe only part a collections call can move. $2.8M 94.4% 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. $55.3k 1.9% 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. $109.7k 3.7% of what you are owed

$2,777,142.57 you can chase + $164,967.33 other balances = $2,942,109.90 owed to you ✓ ties to the cent, across 197 open items

Collection rate this month

77.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: $3.0M owed at the start of the month + $1.3M 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 $328.2k
31–60 days $50.2k
61–90 days $30.5k
Over 90 days $39.3k

Cash tied up in stock: $4.1M

Days of stock on hand 137d 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

How long it has been on the shelf

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

Under 30 days $793.3k
31–60 days $672.8k
61–90 days $373.7k
3–6 months $656.3k
6–12 months $703.2k
Over a year $932.3k

By product group

Product group Stock Margin per $1 Older than 6 months
Pneumatic Actuators $720.3k $1.19 15.6%
Accumulators $617.7k does not apply: nothing sold from this group in the last three months 88.1%
Gear & Piston Pumps $545.5k $1.30 25.0%
FRL & Air Preparation $444.3k $1.52 26.6%
Seals & Wear Rings $381.1k $1.15 43.3%
Hose & Crimp Fittings $374.9k $1.71 24.8%
Directional Valves $346.0k $1.18 46.0%
Manifolds & Sub-plates $268.6k $1.27 56.6%
Hydraulic Cylinders $235.4k $1.78 42.1%
Proportional Valves $197.8k $1.21 28.3%

Accumulators: nothing sold from this group in the last three months

Open orders: $1.1M due to ship

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

Left out: $63.3k on 4 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 197 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 95.0%
  • Follows the sales order 0.1%
  • Supplier's rebate program 3.7%
  • Product named on the claim 0.3%
  • Customer's buying mix 1.0%

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