The bills of lading that ate our August

In late August 2024, our office manager flagged a discrepancy between our outbound logs and a particular customer's receiving system. The discrepancy was about 1.4% of their year-to-date receipts, which sounds tiny but represented something north of $40,000 in disputed invoicing. By the end of September we'd reconciled it. The project consumed roughly forty staff-days. Here's what we learned.

Where the discrepancy came from

Our BOL format used a slightly different code system for triple-wall versus heavy-double-wall than the customer's receiving system did. For most of the year, the codes matched closely enough that the customer's system absorbed the variance. Then a new receiving lead came in mid-summer, started doing stricter matching, and the codes that had previously absorbed cleanly started rejecting.

Neither system was wrong. They were just slightly different vocabularies for the same physical objects.

The forty days

Reconciling forty thousand dollars across nine months of shipments meant pulling every BOL by hand, matching each to the customer's receiving record, and assigning each variance to one of three buckets: code translation issue, actual quantity miss, or honest mistake on either side. The buckets ended up roughly 78%, 19%, and 3% of the total.

We refunded the actual mistakes immediately, even before reconciliation finished. The translation issues we worked through with the customer's procurement lead — a process that involved redesigning our BOL output format for that specific customer.

Why standardization is hard

There's no single industry-standard code for corrugated wall constructions. Different ERPs use different abbreviations, and translating between them is the kind of work that nobody owns until the discrepancy gets big enough to force the issue. A vendor with twenty customers has twenty different translation tables.

We now maintain a per-customer translation table for BOL output. It's a small operational tax. It's a much smaller tax than the forty days were.

The bigger lesson

Most disputes between vendors and customers aren't about quality or price. They're about paperwork mismatches. Investing in matching paperwork formats early is much cheaper than reconciling later. We learned this loudly in the summer of 2024.