Controls · Reverse logistics

Financial controls on material leaving the building

Scrap is where warehouse inventory quietly stops being inventory. Material goes into a container, paperwork moves it off the customer's books, a truck takes it away. Every step is a place where the paperwork and the physical reality can drift apart.

2 asset trackers per load
3 blocking gate checks
Derived status from timestamps
Confidential client & operation

Built for the scrap and recycling operation of a contract-logistics site, moving end-of-life material from the floor to third-party recyclers.

The problem

The chain ran on people remembering. A supervisor guessed which container was free. An analyst queried inventory and hand-typed a transfer document — the paperwork that moves material off the customer's books — then uploaded it manually to their portal. A placard was hand-written. A truck was audited at the gate against whatever was written down.

The gap that mattered had no owner at all: nothing stopped material being dropped into a container after its transfer paperwork was already filed. That inventory physically leaves the site and never appears on any document.

What we built

The full chain, automated and instrumented — container allocation verified against live inventory rather than guessed, transfer paperwork generated from actual on- hand quantities, automatic upload to the customer portal with the failure called out in red when it doesn't succeed, and printed placards carrying a scannable container code, load and pallet number, and captured weight.

Then the control that didn't exist before.

  • Closing a container freezes a per-item snapshot of its contents
  • A background job re-reads live inventory and alerts whenever anything was added after the paperwork was filed
  • The baseline re-arms after each alert, so it reports new drift rather than repeating itself
  • Material scrapped out of the wrong disposition bucket is flagged in the closing summary

At the gate

The truck audit is a hard stop. If any pallet assigned to the load wasn't physically scanned onto the truck, submission is blocked and leadership is emailed — checked in the browser, re-checked on the server, and alerted independently, so bypassing the interface still produces both a block and a notification.

Two asset trackers must be logged on specified pallets before a pickup can be confirmed, and the rule is enforced identically in every path that can confirm one. The system also holds three separate records of driver, truck, trailer and plate — what was ordered, what the vendor's confirmation said, and what was verified at the gate — for no reason other than to catch the mismatch.

Weight is captured once, at placard printing, and carried forward automatically. Where a single order spans several pallets, weight resolves by container rather than by order, because keying on the order number collapses every pallet to whichever placard was printed last.

The result

Status is derived from what actually happened — each milestone is a timestamp, and the stage is computed from them — so there is no status field to drift out of sync with reality. Stamping a milestone twice is harmless, which matters when several people work the same load.

The operation gained a control it had never had: material that leaves the building without appearing on the paperwork now generates an alert instead of a discrepancy someone finds later.

Built with

  • Python
  • SQL Server
  • Selenium WebDriver
  • Zebra ZPL
  • Scheduled reconciliation jobs

On the details we left out

Client, location, system names and volumes are withheld deliberately. We're happy to go deeper on architecture and approach on a call.

Services this draws on

Workload Optimization

Squeeze more throughput out of the hardware and licenses you already pay for.

See the service →

System Integration

Connect aging systems to modern APIs, data platforms, and SaaS tools.

See the service →

More projects

Product · Quality & compliance

Audits that can't be quietly passed

Customer-facing quality audits ran on paper and a survey tool. We built a configurable audit platform with scheduling, escalation, approvals — and a gate that blocks sign-off when the scan doesn't match.

Read the story →
Safety · Equipment control

Equipment that locks itself out when it fails inspection

Powered industrial trucks were signed out on a clipboard, and the fall-protection harness that some of them require was a separate honour system. We built a badge kiosk where the truck you pick decides the inspection you must pass — and which refuses to release anything that fails.

Read the story →
Access Control · Internal platform

Adding a permission shouldn't mean altering the user table

Access was a boolean column on the user record, so every new screen was a schema change. We replaced it with roles that map to screens, credential checks that verify a second person without elevating the first, and a suspension path that fails closed.

Read the story →

Got a system like this?

A free assessment gives you a clear picture and a prioritized plan — no commitment.

Book a free assessment