How to audit a 3PL invoice: match every charge to the work
Match 3PL invoice lines to contracted rates and warehouse records. A worked reconciliation shows how monthly minimums change the credit, with an evidence checklist for resolving discrepancies.
Audit a 3PL invoice by matching each charge to three things: the agreed rate, the billable activity and evidence that the activity occurred. Recalculate minimums and credits after correcting individual lines. Otherwise, the apparent error can be larger than the amount actually owed back.
Start with one complete billing period and a repeatable reconciliation sheet. The useful result is a list of explainable differences, with records attached and a clear next action for each.
Collect the documents that define the bill
Save the signed rate card, later amendments, the detailed invoice export and the contract terms governing billing and disputes. Record each rate’s effective date. An older spreadsheet may be accurate for last month and wrong for this one.
Request the warehouse activity records behind the invoice: fulfilled orders and shipments, picked quantities, receiving events, return processing, storage measurements, special projects and shipping adjustments. Include approved credits that have not yet appeared on an invoice.
Agree on the period boundary and time zone. An order received on the final evening of the month might ship the next morning; the contract’s billable event determines which period it belongs in. A late carrier adjustment may legitimately relate to an earlier shipment.
If the billing definitions are unclear, use our 3PL quote comparison guide to identify the terms that need clarification. An invoice audit applies those agreed definitions to actual activity.
Build one line of evidence for each charge
Use these columns in your reconciliation sheet:
| Field | What to record |
|---|---|
| Invoice reference | Invoice number and line or charge ID |
| Activity reference | Order, shipment, receipt, return or project ID |
| Billable event | The event and date that trigger the charge |
| Rate basis | Per order, additional unit, hour, pallet-day or another agreed unit |
| Expected quantity and rate | Reconstructed from records and the effective rate card |
| Billed amount and expected amount | Both in the same currency, before tax |
| Difference and evidence | Amount requiring explanation and the supporting record |
| Resolution | Owner, response date and credit reference if approved |
Preserve the original exports. Do calculations in a separate working copy so both parties can reproduce the result.
Use stable IDs when joining records. One ecommerce order can have two shipments, and one receiving appointment can contain several purchase orders. Matching on date and total alone can create false duplicates.
Check the unit before checking the price
The arithmetic may be right while the quantity means the wrong thing. Work through each charge family:
- Order and pick fees: Determine what the base fee includes. If it includes the first unit, separate total units from additional units. Check how kits, multiple units of one SKU and split shipments are defined.
- Packaging: Match the charged material to the pack record. Confirm whether standard materials are included or billed separately.
- Receiving: Reconcile appointment, receipt and labour records. Review approval requirements for extra handling and rework. Better inbound shipment records make this easier.
- Storage: Use the agreed measurement method. A month-end pallet count, daily occupied space and a monthly average are different billing bases. Check partial-period treatment rather than assuming it.
- Returns and projects: Match completed work to the agreed unit and any required authorization. A return label being created does not prove that inspection or repacking occurred.
- Transportation: Match charges and adjustments to shipment IDs. Apply the contract’s carrier-charge or markup method; use carrier documents when that method requires them.
Flag an unexplained item for clarification. A second fee is not automatically a duplicate if it represents a separate, agreed service.
A worked invoice: why the minimum changes the credit
Here is a fictional monthly invoice in Canadian dollars, excluding tax. None of these figures represents 247 Fulfillment pricing.
Assume the contract has a $3,000 monthly minimum covering only base fulfillment, additional units, receiving and returns. Packaging, storage and transportation are outside that minimum. The customer also has an approved $75 credit unrelated to the minimum, payable on this invoice.
| Charge | Billed | Corrected from records |
|---|---|---|
| Base fulfillment: 1,000 orders × $2.20 | $2,200 | $2,200 |
| Additional units: billed 700; recorded 600 × $0.45 | $315 | $270 |
| Cartons: 1,000 × $0.65 | $650 | $650 |
| Storage: billed 45; recorded 40 pallet-months × $18 | $810 | $720 |
| Receiving: billed 8; recorded 6 approved hours × $45 | $360 | $270 |
| Returns: 30 × $3.50 | $105 | $105 |
| Minimum top-up | $20 | $155 |
| Transportation | $11,940 | $11,940 |
| Approved credit | $0 | −$75 |
| Total before tax | $16,400 | $16,235 |
The original minimum-eligible charges total $2,980, so the billed top-up is $20. Correcting additional units and receiving lowers those eligible charges to $2,845. The top-up therefore rises to $155.
The $45 additional-unit correction and $90 receiving correction are absorbed by the minimum. The $90 storage correction and missing $75 credit reduce the total by $165. Claiming every line reduction without recalculating the top-up would overstate this invoice’s reduction by $135.
Your contract may define minimums differently. Check eligible categories, whether minimums apply by facility or account, and how credits interact with them. Preserve the corrected activity counts even when the current minimum absorbs the difference; they affect your operating records and future comparisons.
Raise a discrepancy the billing team can resolve
Send a short evidence package: the relevant contract clause, invoice line, underlying IDs and your calculation. Separate confirmed arithmetic errors from questions about missing documentation.
For the example above, the request could read: “Please review invoice INV-EXAMPLE. Our reconciliation shows a $90 storage difference and an unapplied $75 approved credit. We also corrected eligible receiving and additional-unit quantities, then recalculated the minimum. The resulting pre-tax difference is $165. Supporting records and calculations are attached.”
Follow the agreement’s dispute process and response deadlines. Confirm how disputed amounts should be handled while the review is open. Keep “requested,” “approved” and “applied” credits separate; an approval email is not an invoice adjustment.
Make next month easier
Maintain an exception log by cause: outdated rate, quantity mismatch, missing authorization, unmatched shipping adjustment or missing credit. Check that each resolved issue stays resolved on the next invoice.
Track both recovered dollars and recurring causes. A minimum may absorb a billing correction this month, but repeated receiving rework or unnecessary split shipments still deserves an operational fix. Review the cost of split shipments when those charges recur.
Before a new fulfillment relationship begins, ask what activity exports will support the monthly bill. For a conversation with 247 Fulfillment, bring a sample order profile and the billing detail you need to reconcile. Clear records make the relationship easier to manage from the first invoice.
