Skip to main content

Published by LanePilot

The Warehouse Workup From dock to stock: worked examples from realistic LTL operations.

Issue 14ReceivingThree-Way MatchVendor Chargebacks

Why a Supplier Invoice Matched the PO and Not the Two Receipts

The purchase order and the supplier invoice agreed to the dollar. Only the receiving record, kept line by line across two deliveries, could show the $614 that was billed and never accepted.

By Aaron Brown, Founder & CEO · Reviewed by Aaron Brown · Published · 5 min read

The operation in this walkthrough is illustrative, built to reflect a typical small or mid-sized manufacturer, distributor or warehouse: Thornbeck Panel Works, a 62-person maker of electrical enclosures and control panels, running a 48,000 square foot plant and about 95 inbound purchase orders a month. The workflow and the arithmetic are real. The company and its vendor, Ravelsey Metal Supply, are not.

The three-way match is the standard answer to how you reconcile a purchase order receipt and supplier invoice. Here is one purchase order that passes it on paper and still carries $614 nobody owes.

One purchase order, two deliveries

PO 5208 goes to Ravelsey Metal Supply for two lines:

  • Line 1: 150 galvanized back panels at $34.00 = $5,100.00
  • Line 2: 90 gland plates at $38.50 = $3,465.00
  • PO total: $8,565.00

The first delivery is four pallets, and the bill of lading says four. The receiver counts the pieces on the dock: 141 back panels, not 150, and 50 gland plates, with the balance of line 2 to follow. The pallet count matches the bill of lading, so the receiver signs the delivery receipt clean. That is correct. The 9 missing panels are a vendor loading problem, not a carrier one.

Five days later the second delivery arrives: one pallet, 40 gland plates, and nothing more for line 1, which the vendor closes short. Eight have bent flanges. The cartons show no outside damage and the plates were packed loose, so the receiver reads it as the vendor's packing. The receiver records 32 good and 8 damaged, with a reason, instead of shelving all 40.

What each document proves

  • The purchase order proves what was agreed: 150 panels and 90 plates.
  • The receiving record proves what was actually accepted, line by line, cumulatively across both deliveries: 141 panels, and 50 plus 32 = 82 plates.
  • The supplier invoice proves only what the vendor says is owed: the full $8,565.00.
  • The delivery receipt is the carrier's document. It proves handling units handed over, five pallets across two deliveries, and it governs a carrier claim. It carries no per-line quantity and is not the evidence for a vendor chargeback.

Now run the match. The PO total and the invoice total agree to the cent, and a total-only comparison never looks at quantity. The receipt leg is not one document here, it is two, and neither delivery matches anything on its own. Only their sum, 141 panels and 82 plates, shows the 9 panels and 8 plates billed and never accepted. Adding up that leg is the part a person has to do.

The arithmetic

  • Billed: 150 x $34.00 = $5,100.00 and 90 x $38.50 = $3,465.00, total $8,565.00
  • Accepted: 141 x $34.00 = $4,794.00 and 82 x $38.50 = $3,157.00, total $7,951.00
  • Short: 9 panels x $34.00 = $306.00
  • Damaged: 8 plates x $38.50 = $308.00
  • Vendor chargeback: $306.00 + $308.00 = $614.00, which is $8,565.00 minus $7,951.00, or 7.2 percent of the order

One chargeback covers both, itemized at the PO's unit cost.

The same case with only two clean receipts

Take away the line-level record and keep two clean-signed delivery receipts. The signature forecloses a carrier claim, and nothing here was a carrier failure anyway. The vendor side is where it hurts. Pallets are all the receipts show, so the chargeback has no evidence of what arrived, and the vendor can point to an invoice that matches the PO. Raising it from memory and a packing slip is a weaker position, and no recovery is guaranteed either way.

The fix

Receive each delivery line by line, record over, short and damaged with a reason, and let the second delivery open a new receipt against the same PO line. Warehouse Essentials, $79 a month or the 37-day free trial with no card required, includes this: "Receive remaining" opens a new receipt on the same line instead of rewriting the first, cumulative received and outstanding show per PO line, and each delivery stays in receipt history. The 8 damaged plates post to inventory in damaged status, stop counting as available stock, and carry the reason on the movement history.

LanePilot does not audit inbound freight invoices automatically; that audit engine runs on outbound freight. On inbound, cost is entered manually, and recovery runs through the discrepancy captured at receiving. The vendor chargeback letter, drafted from that discrepancy and itemized against the PO's unit cost, needs LanePilot Warehouse at $119 a month, an add-on to any freight plan including Free. You send it. LanePilot prepares the paperwork; it does not contact your carrier or your vendor on your behalf.

Run this on your own dock

One. Pick a PO that was received in two deliveries and add up the accepted quantity per line. Compare it to the invoice quantity, not the invoice total.

Two. Ask who signs what. The delivery receipt gets signed or noted at the tailgate. Nobody counts or signs against the purchase order.

Three. Pull last month's paid supplier invoices against POs that were received in more than one delivery. See whether anyone compared the accepted quantity per line before accounts payable paid. A total-only check would have passed every one of them.

On a PO that arrived in two deliveries, the match is only as good as the addition nobody checks.

The operation described is illustrative. Purchase order and receiving records are demonstration data.

LanePilot

Ready to put this into practice?

Free quote credits to start. No credit card required.

Start free →