This is the working report, not a picture of one. Feel free to click around. Click any finding marked › to open the lines behind it, hover the charts for the figures, and try light and dark.

Kasterlee Industrial Supply

Month end pack · October 2026

Bearings, drives and fluid power. Six sites.

Prudeon
Generated 09 November 2026 at 18:18
Source: ERP company C, period 10 of 12
Built in 17 seconds

Where the year stands

Figures are year to date to the end of October 2026, read straight from the general ledger. Stock positions are the current position in the system, as at 08 November 2026.

Revenue, year to date
R 359.4m
-11.7% against budget
Gross margin
25.5%
-0.5% on last year
Operating profit
R 21.7m
6.0% of revenue
Stock on hand
R 79.2m
87 days of cover across 6 sites
Cash in dead stock
R 15.6m
84 lines, no sales in 12 months
Orders unfilled
R 982k
8 lines on zero with demand

What needs a decision

7 things in the data crossed a threshold worth a conversation. They are ordered by what they are costing, not by where they sit in the accounts. Each one opens to the lines behind it.

Critical
Consumables is selling below cost
Gross margin on Consumables is -8.0% year to date against 25.5% for the company. The group turned over R 22.2m and lost R 1.8m doing it. It was -7.9% at the same point last year.
Repricing or exiting the worst lines below recovers the gap. The lines are listed.
Show the 8 lines behind thisHide the detail
R 7.4m
to reach company margin
Stock codeDescriptionRevenueGross profit
C-00659Consumables item 00659R 3 120 720R -345 000
C-00655Consumables item 00655R 2 509 806R -291 153
C-00632Consumables item 00632R 2 594 106R -286 669
C-00681Consumables item 00681R 1 070 118R -179 770
C-00673Consumables item 00673R 1 161 839R -141 982
C-00653Consumables item 00653R 1 299 662R -118 374
C-00643Consumables item 00643R 1 666 670R -76 528
C-00642Consumables item 00642R 809 528R -64 399
Critical
Fasteners is selling below cost
Gross margin on Fasteners is -4.3% year to date against 25.5% for the company. The group turned over R 22.6m and lost R 965k doing it. It was -4.1% at the same point last year.
Repricing or exiting the worst lines below recovers the gap. The lines are listed.
Show the 8 lines behind thisHide the detail
R 6.7m
to reach company margin
Stock codeDescriptionRevenueGross profit
F-00458Fasteners item 00458R 6 548 572R -207 853
F-00486Fasteners item 00486R 1 432 052R -93 286
F-00438Fasteners item 00438R 807 216R -72 297
F-00452Fasteners item 00452R 2 209 871R -53 969
F-00422Fasteners item 00422R 1 175 029R -50 658
F-00476Fasteners item 00476R 814 738R -49 402
F-00431Fasteners item 00431R 1 138 227R -48 130
F-00475Fasteners item 00475R 545 389R -38 320
Critical
8 lines on zero with customers waiting
8 stock positions are on or below zero with 434 open orders against them, R 982k of ordered value unfilled. These are moving lines, not slow ones.
Several are held at another site. Check the transfer column before reordering.
Show the 8 lines behind thisHide the detail
R 982k
revenue held up
Stock codeDescriptionSiteOn back orderValueIn transitLead time
DC-00243Drive Components item 00243Main Plant Finished Goods10 821R 410 657011
DC-00243Drive Components item 00243Johannesburg DC8 443R 320 4122 75011
F-00451Fasteners item 00451Main Plant Finished Goods11 789R 101 268038
F-00451Fasteners item 00451Johannesburg DC11 680R 100 331038
E-00544Electrical item 00544Johannesburg DC545R 26 37846530
E-00544Electrical item 00544Main Plant Finished Goods444R 21 490030
HF-00045Hydraulic Fittings item 00045Johannesburg DC210R 1 22409
HF-00045Hydraulic Fittings item 00045Main Plant Finished Goods115R 67009
Needs attention
Durban DC holds 208 days of stock
Durban DC carries R 27.5m at cost, which is 208 days of cover against a 67 day median across the other sites. Holding it at the group median frees R 18.6m.
The largest holdings at this site are listed. Most are transferable.
Show the 10 lines behind thisHide the detail
R 18.6m
working capital tied up
Stock codeDescriptionValue heldDays cover
E-00501Electrical item 00501R 4 472 009194
DC-00319Drive Components item 00319R 919 469219
DC-00243Drive Components item 00243R 681 709223
F-00458Fasteners item 00458R 662 364224
HF-00031Hydraulic Fittings item 00031R 618 411277
E-00550Electrical item 00550R 595 517264
E-00517Electrical item 00517R 574 760292
P-00586Pneumatics item 00586R 465 177215
B-00220Bearings item 00220R 433 165191
HF-00102Hydraulic Fittings item 00102R 433 035202
Needs attention
Meridian Heavy Industries Pty Ltd is 18.5% of turnover
One account carries 18.5% of revenue year to date. The next largest is 2.1%. Losing it removes R 16.9m of gross profit.
Worth knowing the renewal date and who owns the relationship.
R 16.9m
gross profit at risk
Needs attention
R 15.6m sitting in lines that have not sold
84 stock codes, 12.0% of the catalogue, hold R 15.6m at cost with no invoice against them in 12 months. None of it is on the obsolescence provision.
The largest holdings are listed. Clearance or scrapping both beat holding.
Show the 15 lines behind thisHide the detail
R 15.6m
cash in dead stock
Stock codeDescriptionGroupValue heldSites
P-00609Pneumatics item 00609PNEUMATICSR 2 922 9156
P-00598Pneumatics item 00598PNEUMATICSR 1 032 4606
P-00588Pneumatics item 00588PNEUMATICSR 840 0406
B-00229Bearings item 00229BEARINGSR 796 8106
SAG-00351Seals And Gaskets item 00351SEALS AND GASKETSR 779 9726
HF-00103Hydraulic Fittings item 00103HYDRAULIC FITTINGSR 582 3076
HF-00066Hydraulic Fittings item 00066HYDRAULIC FITTINGSR 567 5746
HF-00018Hydraulic Fittings item 00018HYDRAULIC FITTINGSR 449 1596
HF-00009Hydraulic Fittings item 00009HYDRAULIC FITTINGSR 427 0696
B-00132Bearings item 00132BEARINGSR 416 6286
HF-00107Hydraulic Fittings item 00107HYDRAULIC FITTINGSR 350 6216
C-00698Consumables item 00698CONSUMABLESR 344 5966
DC-00306Drive Components item 00306DRIVE COMPONENTSR 301 1226
HF-00068Hydraulic Fittings item 00068HYDRAULIC FITTINGSR 299 3896
E-00525Electrical item 00525ELECTRICALR 290 0786
Watch
Revenue is 11.7% behind budget year to date
Turnover of R 359.4m against a budget of R 406.8m, a variance of R 47.4m.
-11.7%
against budget

Income statement

Built from stored period balances in the general ledger, not from re-aggregated transactions, so it agrees with what the ERP itself reports. Favourable variances are green whichever direction that is for the line.

MonthYear to date
R 000ActualBudgetVarianceActualBudgetVariance
Revenue49 41658 429-9 012359 359406 808-47 449
Cost of sales36 83342 831-5 998267 710288 966-21 256
Gross profit12 58315 597-3 01491 648117 842-26 193
Gross margin25.5%26.7%-1.2%25.5%29.0%-3.5%
Employment costs4 0714 606-53530 17332 878-2 705
Occupancy1 1681 380-2128 5079 296-789
Distribution1 7132 001-28912 73614 203-1 467
Operations707791-845 0565 453-397
Selling costs213640-4263 2374 348-1 111
Administration796934-1385 8896 304-414
Depreciation594692-974 3154 810-495
Total operating expenses9 26111 044-1 78369 91377 292-7 379
Operating profit3 3224 553-1 23121 73540 550-18 815
Operating margin6.7%7.8%-1.1%6.0%10.0%-3.9%
Finance costs9301 004-746 2406 517-277
Profit before tax2 3923 549-1 15715 49534 033-18 538

Revenue against plan

Twelve trading periods of the current financial year against budget and against the same months last year.

Revenue by month

Actual stops at October 2026, the last closed period. Hover any month for the three figures.

ActualBudgetLast year
R0mR15mR30mR45mR60mJanFebMarAprMayJunJulAugSepOctNovDecR49.4m

Where the margin comes from

Gross margin by product group and turnover by site, both year to date and both excluding freight and miscellaneous charge lines, which do not belong in a margin calculation.

Gross margin by product group

Year to date. Bars show gross margin percent.

Seals And Gaskets
37.3%
Hydraulic Fittings
36.0%
Pneumatics
30.1%
Drive Components
30.0%
Bearings
28.1%
Electrical
25.0%
Fasteners
-4.3%Loss
Consumables
-8.0%Loss

Company gross margin, 25.5%

Revenue by site

Year to date turnover, with each site's gross margin.

Main Plant Finished Goods
R 107.5m
Johannesburg DC
R 84.5m
Cape Town DC
R 63.0m
Durban DC
R 51.5m
Port Elizabeth Branch
R 30.4m
Bloemfontein Branch
R 22.5m

Customer concentration

Share of year to date turnover by account. Concentration is not a problem until it is the only problem.

Top accounts by share of revenue

Year to date. Bars show each account's percent of turnover.

Meridian Heavy Industries Pty Ltd
18.5%Concentrated
Anusha Distributors Group
2.1%
Nadia Industrial Group
1.8%
Marelize Plant Hire Pty Ltd
1.8%
Thabo Fabrication
1.8%
Nadia Mining Services
1.7%
Zanele Works Group
1.6%
Johan Distributors CC
1.5%
Zanele Agencies Pty Ltd
1.4%
Elsabe Agencies Group
1.4%

Stock health

Stock is the largest number on the balance sheet and the one with the least daily attention. Three views: where it is sitting, what is not moving, and what has run out.

Days of cover by site

Stock at cost over average daily cost of sales, trailing twelve months. Cost on both sides.

Durban DC
208 daysOverstocked
Bloemfontein Branch
84 days
Port Elizabeth Branch
68 days
Main Plant Finished Goods
66 days
Cape Town DC
64 days
Johannesburg DC
61 days

Median across the sites, 67 days

Largest holdings with no sales

No invoice in 12 months. Value at standard cost.

Stock codeDescriptionValue
P-00609Pneumatics item 00609R 2 922 915
P-00598Pneumatics item 00598R 1 032 460
P-00588Pneumatics item 00588R 840 040
B-00229Bearings item 00229R 796 810
SAG-00351Seals And Gaskets item 00351R 779 972
HF-00103Hydraulic Fittings item 00103R 582 307
HF-00066Hydraulic Fittings item 00066R 567 574
HF-00018Hydraulic Fittings item 00018R 449 159

On zero with orders waiting

On or below zero with open back orders against them.

Stock codeSiteBack orderValue
DC-00243Main Plant Finished Goods10 821R 410 657
DC-00243Johannesburg DC8 443R 320 412
F-00451Main Plant Finished Goods11 789R 101 268
F-00451Johannesburg DC11 680R 100 331
E-00544Johannesburg DC545R 26 378
E-00544Main Plant Finished Goods444R 21 490
HF-00045Johannesburg DC210R 1 224
HF-00045Main Plant Finished Goods115R 670

Does it tie

Three checks run every time the pack builds, and the result is printed whether it passes or not. A pack that cannot show the ledger agreeing with the sales ledger is an opinion.

✓
Ledger revenue against invoiced sales
agrees
✓
Ledger history closing against ledger transactions
agrees
✓
Stock in transit against open transfers
agrees