Why not use a standard WMS off the shelf?

Off-the-shelf WMS products handle inventory movement well, but the per-client billing rules — different rate cards, storage windows, and cadences — are usually weak or require expensive custom modules. For a 3PL running multiple clients on different agreements, that's where the work actually is. The custom build kept the inventory ledger simple and made the billing rule engine the centrepiece, which matched how this business actually makes money.

How much manual work does this actually remove?

Two manual processes collapse into one automated flow. Before: warehouse staff logged every pallet movement into Excel during the day; at month-end, accounts then reconciled those Excel sheets against stock-on-hand to work out what to bill each client, then typed the invoice numbers up separately. Two teams, two records, hours of effort, and the inevitable mismatches between what the warehouse did and what accounts billed for. After: the warehouse scan is the record. The same ledger that tracks pallets in and out is the source the invoicing engine reads from. There is no second documentation step and no reconciliation, because there is only one set of numbers. Stock comes in, the operator scans it, and at month-end the invoice is generated from those scans directly — usually in under a minute.

Can a small 3PL operator get this kind of system on a small budget?

The full build is a serious investment, but the principle scales down. The cheapest version is a scan-based inventory ledger plus a simple per-client billing config — not the multi-rule engine described in this case study. We can usually scope a tighter MVP that takes weeks of Excel pain off the operator's plate without rebuilding everything at once. Worth a 30-minute call to figure out where the hours are actually going.

Back to case studies

Logistics / 3PL · 2025

Warehouse & Auto-Invoicing.

Weekly Excel invoicing → under a minute.

Weekly invoicing time

Under a minute

Before

Hours of Excel

Billing cadences supported

Per client

What wasn't working.

The operation was tracking inventory across multiple clients in a growing set of Excel workbooks. Pallets moved in and out, rates differed per client, storage durations mattered for billing — and the spreadsheet was the single source of truth. It stopped being trustworthy at some volume. Invoicing melted into rework: numbers were wrong, corrections were manual, clients queried charges.

Every addition to the business — a new client, a new service, a different billing cadence — made the spreadsheet more fragile.

What we built.

Scan in, scan out

Staff scan pallets in and out from a phone or iPad. Every movement carries client, location, and timestamp. No more typing into Excel; the ledger updates itself.

Per-client billing rules

Each client has its own rate card, storage rules, and billing cadence — weekly, monthly, per-event. The system applies them automatically; the operator reviews and sends.

Invoices in one click

What used to be hours of Excel reconciliation is now a single action: pick a client, pick a period, generate. The draft invoice matches the movement ledger exactly.

Built to grow

New services — value-add storage, cross-docking, returns — slot in without rebuilding. The operator's roadmap for the next two years is reflected in how the data model is shaped.

What changed.

Invoicing a client's period now takes under a minute where it used to consume hours. Queries and corrections have dropped sharply because the numbers come straight from the scan ledger, not from manual re-entry.

More usefully, the operator can onboard a new client without adding administrative overhead. The billing rules for that client are captured once and then the system runs them.

Logistics / 3PL · Excel → Scan-based WMS + per-client auto-invoicing

Got something like this you want built?

Start a project

Frequently asked questions.

Why not use a standard WMS off the shelf?
Off-the-shelf WMS products handle inventory movement well, but the per-client billing rules — different rate cards, storage windows, and cadences — are usually weak or require expensive custom modules. For a 3PL running multiple clients on different agreements, that's where the work actually is. The custom build kept the inventory ledger simple and made the billing rule engine the centrepiece, which matched how this business actually makes money.
How much manual work does this actually remove?
Two manual processes collapse into one automated flow. Before: warehouse staff logged every pallet movement into Excel during the day; at month-end, accounts then reconciled those Excel sheets against stock-on-hand to work out what to bill each client, then typed the invoice numbers up separately. Two teams, two records, hours of effort, and the inevitable mismatches between what the warehouse did and what accounts billed for. After: the warehouse scan is the record. The same ledger that tracks pallets in and out is the source the invoicing engine reads from. There is no second documentation step and no reconciliation, because there is only one set of numbers. Stock comes in, the operator scans it, and at month-end the invoice is generated from those scans directly — usually in under a minute.
Can a small 3PL operator get this kind of system on a small budget?
The full build is a serious investment, but the principle scales down. The cheapest version is a scan-based inventory ledger plus a simple per-client billing config — not the multi-rule engine described in this case study. We can usually scope a tighter MVP that takes weeks of Excel pain off the operator's plate without rebuilding everything at once. Worth a 30-minute call to figure out where the hours are actually going.

Need something like this built.

If this case study sounds like the kind of problem you have, here's where we'd start.

Let's talk.

Tell us what you're trying to do. We'll reply within one working day. If we're not the right team for it, we'll say so.

→Reply in one working day

→First call is free — no pitch

→If we're not the right fit, we'll say so

Prefer email?hello@tryfantech.com

Based in the UK, working with businesses across the country