Contact

June 2026 · Shop Supplies & Consumables

Nothing on this line needs action this month.

Worth a review: customers take 62 days to pay and margin is 0.7 points under plan. Revenue is on plan.

Revenue this year

$3.8M

plan $3.8M · same months last year $3.6M

Margin this year

33.3%

plan 34.0% · −0.7pp

Owed to you · 62 days to pay

$1.4M

60 on unpaid invoices alone, leaving disputes out

Stock

$1.2M

86 days on hand · earns $2.12 per $1

Where these figures come from

What makes up the $1.4M owed to you

You can chase

Invoices you can chaseThe only part a collections call can move. $1.3M 92.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. $27.8k 2.0% 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. $72.1k 5.3% of what you are owed

$1,256,999.04 you can chase + $99,843.39 other balances = $1,356,842.43 owed to you ✓ ties to the cent, across 131 open items

Collection rate this month

82.4% within the limit

Most of what fell due was collected. Work the late invoices separately from disputes and the other balances a call will not clear.

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: $1.4M owed at the start of the month + $653.4k billed − $1.1M not yet due at month end.

How late the invoices you can chase are

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

Not yet due $1.1M
1–30 days late $110.5k
31–60 days $13.2k
61–90 days $8.2k
Over 90 days $33.1k

Cash tied up in stock: $1.2M

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

How long it has been on the shelf

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

Under 30 days $356.3k
31–60 days $275.6k
61–90 days $160.1k
3–6 months $196.4k
6–12 months $116.5k
Over a year $71.9k

By product group

Product group Stock Margin per $1 Older than 6 months
Storage & Bins $208.2k $2.05 12.0%
Janitorial Consumables $182.4k $2.17 13.2%
Adhesives & Sealants $179.9k $2.33 12.4%
Lubricants & Greases $170.9k $2.04 13.0%
Tape & Strapping $137.4k $2.31 18.3%
Shop Towels & Absorbents $129.8k $1.65 21.6%
Marking & Layout $102.0k $2.19 31.8%
Solvents & Cleaners $66.2k $2.16 13.7%

Open orders: $430.4k due to ship

All open orders $447.8k including lines past the date the customer asked for
With a confirmed delivery date 73.3% $328.2k of all open orders
Due to ship $430.4k confirmed or still awaiting a date; leaves out lines past their date

Left out: $17.4k 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 131 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.7%
  • Supplier's rebate program 5.3%

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