TryfanTech
Back to case studies
Logistics / 3PL2025

Warehouse & Auto-Invoicing.

Weekly Excel invoicing → under a minute.

Weekly invoicing time
Under a minute
Before
Hours of Excel
Billing cadences supported
Per client
01·The problem

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.

02·The approach

What we built.

01

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.

02

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.

03

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.

04

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.

03·The outcome

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.

Stack·Excel → Scan-based WMS + per-client auto-invoicingSector·Logistics / 3PL
05·Contact

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
Based in the UK, working with businesses across the country