Guides / Part XIV · Billing, invoice auditing and cost control

3PL Invoice Backup: Supporting Detail Files to Request

The backup files to request with each 3PL invoice: what each should hold for orders, shipping, storage, receiving and returns, and how to check them.

What backup files should I ask my 3PL for with each invoice, and what should each one contain so I can check the bill?

Supporting detail files, also called invoice backup, are the row-level records behind each 3PL invoice line. Request them with every invoice, for every fee type: orders and picks, shipments the 3PL bills, receipts, storage counts, returns, and labor or projects. Each row needs a reference, quantity, rate and amount, and the rows should add up to the invoice line.

Why supporting detail matters

A summary invoice shows a total for each fee, not the activity behind it. The detail lets you re-add the bill, check each rate against your rate card and match rows to your own orders and receipts.

Billing errors are usually process slips rather than intent: rates can change one line at a time, and a 3PL's billing system can lag the rate card. Some lines carry no quantity at all. About a quarter of observed DTC 3PL contracts with storage charges have at least one storage line with a dollar amount and no quantity, so the count has to come from the detail file.

What a supporting detail file is

Summary, line items and detail rows

The summary gives totals; each line item gives one fee with its quantity, rate and amount; the detail rows show the orders, packages, receipts, locations, returns or tasks behind each line. The file is also called invoice backup, billing backup, backup file, detail file, support file or transaction detail. See Anatomy of a 3PL invoice: summary, line items and supporting detail.

How 3PLs deliver it

Detail can arrive in four forms, and public sources show none of them as the norm:

  • One combined file. One 3PL attaches a CSV "with every invoice that shows a breakdown of every charge"[1].
  • A file per invoice line. One warehouse software product zips "a backup document for each line item"[2].
  • Portal views or exports. One 3PL's portal shows billing views for orders, purchase orders and ad hoc charges, with no storage view mentioned[3].
  • EDI. An X12 810 invoice works as backup only when each activity is its own line[4]; an X12 210 carries motor-carrier freight (LTL/FTL) charges, not warehouse fees[5].

See Invoice formats: PDF, spreadsheet, portal, EDI 210/810.

The detail files to request, fee by fee

Every fee type on your invoice needs its own detail, except flat fees, whose backup is the contract line.

Fee type Ask for One row per Fields beyond the basics What it lets you check
Order and pick fees, packaging, inserts Order-level fulfillment detail Order, or order and SKU Channel and 3PL order IDs, units, picks billed, box, inserts Picks against units shipped
Shipping the 3PL bills Shipment-level file Package Tracking number, service, zone, actual weight, declared dimensions, DIM and billed weight, base charge, each surcharge, any markup Surcharges the invoice shows only as a total
Carrier adjustments re-billed by the 3PL Adjustment detail Adjustment Original tracking number, reason, declared vs. carrier-measured dimensions and weight, amount, any 3PL fee Which shipment it belongs to
Receiving Receipt-level detail Receipt PO, ASN or receipt ID, date, billing unit, quantity, any surcharge Receipts against what you sent
Storage Storage detail for the count date, or each day if averaged Location, or SKU within a location Location ID and type, SKU, quantity, count date or method Space against your inventory snapshot
Returns Return-level detail Return RMA or order number, units, type or condition, any return postage Returns against returns received
Kitting, labor, projects, other accessorials Work-order detail and the approved quote Work order or task Work-order or quote reference, hours or units, rate, approver Work you approved
B2B orders and freight, if you ship wholesale B2B order detail and the freight bill Order or shipment PO, cartons or pallets picked, bill of lading, freight charge Case and pallet picks, and freight the 3PL bills
Monthly minimum The shortfall calculation Month Fees counted, their total, the minimum, the gap That a shortfall was due
Credits Credit detail Credit The invoice and line it reverses, reason That each credit was applied
Account and technology fees The contract line; for a per-order technology fee, the order count — — Amount matches the contract

Picks. Two pick structures are both common. When picks count per unit, the expected quantity depends on the structure. Where the order fee includes the first pick, additional picks should equal units shipped minus orders. Where a lower order fee comes with a pick fee on every unit, picks should equal units shipped. Some contracts count picks per line or SKU, and a kit can count as one pick or one per component, so check the contract's definition.

Shipping. The 3PL's shipment-level file is the backup for postage it bills, at carrier cost, marked up or on its own rate card. In about nine in ten of observed DTC 3PL contracts, small-parcel postage is on the 3PL's invoice. If you ship on your own carrier account, the carrier bills you, and its invoice and billing downloads are the backup, such as the documents and reports in FedEx Billing Online[10]. See Shipment-level cost data: why you need it and how to ask for it.

Adjustments. Most 3PLs pass carrier adjustments through on a later invoice, as separate lines or folded into regular shipping lines; some brands see none.

Storage. A SKU can occupy a pick and a reserve location at once, each billed under per-location or per-pallet pricing, so the detail should list both. For cubic-foot billing, ask for each SKU's dimensions; stored dimensions are more often too large than too small. Storage charged at receipt should carry the receipt reference. Square-foot storage is a fixed rate for an area allocated to you, full or not[14], so its backup is the area in your contract. See Verifying storage counts against inventory snapshots.

Fields every row should carry

Every row should let you find the activity in your records and recompute its amount:

  • Invoice number and billing period
  • Activity date
  • A reference you hold: channel order number, tracking number, PO, ASN (the advance shipping notice you send your 3PL before inbound stock arrives), RMA or work order
  • SKU, where the fee is per item
  • Fee name as the rate card writes it
  • Billing unit, quantity, rate and extended amount (quantity × rate)

Ask for a sortable CSV or XLSX, not a PDF of rows. One 3PL's help page warns that many reference fields in its file will be blank on many charges[1], so ask for the same references in every file. Open CSVs with the tracking-number column as text, or a spreadsheet can turn long numbers into scientific notation and drop digits. Bundle SKUs can also differ between your store and the 3PL's system, so ask which SKU each row shows.

How to request supporting detail

Ask in writing for a defined set of files with every invoice, then put the obligation in the contract.

  1. Send the fee-by-fee list above, or the checklist below.
  2. Ask for detail with every invoice, matching its invoice number and billing period, and for each invoice when there are several in a period.
  3. Set the timing. Ask for detail to arrive with the invoice, and for the dispute window to start when you receive the complete detail, not on the invoice date. A 30-day dispute window is common and 14 days is short. Some windows count from month-end; IWLA's standard terms for merchandise warehouses (2026 revision) count 30 days "from date of invoice" where a contract adopts them[6].
  4. Agree the file type and columns once, with notice before any change.
  5. Write it into the contract. Public companies file some of their contracts with the U.S. Securities and Exchange Commission (SEC), which publishes them, so a few 3PL contracts can be read in full. Two of them, both warehouse contracts, say nothing about what accompanies an invoice[12],[13]. See Data access, reporting obligations and format requirements.

A 3PL's billing system builds the invoice from activity data, and one software vendor tells 3PLs it should let them "trace any line item back to the specific warehouse activity that generated it"[7]. Most 3PLs can produce row-level detail from the same system that builds the invoice, and routine billing detail is usually included in what you pay. Custom reports can carry a fee, so agree their price before signing.

Worked example: tying the detail to an invoice (illustrative)

In this illustrative month, the detail file comes up $847.60 short of the invoice: $250.00 is expected, and $597.60 needs an answer from the 3PL.

Terms (illustrative, not market rates): $1.75 per order including the first pick, $0.40 per additional pick, $0.55 packaging per order, $12 per pallet received, $20 per pallet stored, $3.50 per return, $45 per project hour, a $250 account fee, a $2,500 monthly minimum on fulfillment fees, and postage billed at carrier cost with no markup.

The month: 2,000 orders with 3,000 units, one package each, 8 pallets received, 40 pallets stored, 60 returns and 6 project hours.

Invoice line Invoice amount Detail rows Detail total Gap
Order fee (2,000 × $1.75) $3,500.00 2,000 $3,500.00 $0.00
Additional picks (1,000 × $0.40) $400.00 650 $400.00 $0.00
Packaging (2,000 × $0.55) $1,100.00 2,000 $1,100.00 $0.00
Receiving (8 × $12) $96.00 3 $96.00 $0.00
Storage (40 × $20) $800.00 40 $800.00 $0.00
Returns (60 × $3.50) $210.00 60 $210.00 $0.00
Projects (6 × $45) $270.00 0 $0.00 $270.00
Account fee $250.00 0 $0.00 $250.00
Postage (2,000 packages) $16,000.00 1,960 $15,672.40 $327.60
Total $22,626.00 $21,778.40 $847.60

Run three spreadsheet checks:

  1. Do the rows add up to each line and to the total? One 3PL tells its clients to sum the charged-amount column for this[1]. Here, $22,626.00 − $21,778.40 = $847.60. The $250 account fee has no rows by design; its backup is the contract. That leaves $327.60 + $270.00 = $597.60.
  2. Does quantity × rate equal the amount on each row? An order with three extra units should show 3 × $0.40 = $1.20. Postage rows carry carrier charges instead.
  3. Does each row carry a reference you can find? Matching the shipment file's order numbers to your 2,000 shipped orders shows which 40 packages have no rows.

Two findings go back to the 3PL: 40 packages ($327.60 of postage) have no shipment rows, and the projects line has no work-order rows, so ask for both. Under the other pick structure, the detail would show 3,000 picks, not 1,000. Fulfillment fees clear the illustrative $2,500 minimum whether or not packaging counts ($3,900 or $5,000), so no shortfall line is due. The audit steps that follow are in How to audit a 3PL invoice, step by step.

What good looks like

Good supporting detail lets you rebuild the invoice yourself:

  • Detail for every fee type, with every invoice, for the same period and invoice number
  • A sortable file whose rows sum to each line and to the total
  • Quantity, rate and amount on every row, with fee names that match the rate card
  • A reference on every row that you can find in your own systems
  • Flat fees tied to a contract line, shortfalls shown as a calculation, and each credit tied to the invoice it reverses

Common mistakes and red flags

These gaps leave charges you can't check:

  • Paying from the PDF alone. Summary invoices without supporting files "force the client to trust numbers it cannot validate," as one consultant's contract checklist puts it[8].
  • Detail for some fees only, for example shipping only, with nothing behind storage, receiving or projects.
  • Detail that arrives late, after part of the dispute window has passed.
  • Rows without quantity or rate, so you can't recompute the amount.
  • Totals that differ from the invoice with no explanation.
  • Lump lines with no rows. About a third of observed DTC 3PL contracts with returns charges show returns as a single amount with no visible per-return or per-unit basis. Unless the contract sets a flat returns fee, ask for the return-level rows.

Questions to ask your 3PL

Copy these into an email to your 3PL.

  1. Can you send a detail file with every invoice, covering every fee type, for the same period?
  2. Will each row show quantity, rate, amount and an order, tracking, PO or work-order reference?
  3. Do the detail rows add up to the invoice total? If not, what's left out and why?
  4. Do my orders ship on your carrier accounts or mine, and for which services?
  5. How do carrier adjustments appear, and do they carry the original tracking number?
  6. For storage, which count date or method does the detail reflect, and does it list each location?
  7. Is there a fee for the detail file or for custom reports?
  8. How long do you keep billing detail, and can I export past periods?

Checklist: supporting detail request list

Copy into your request or contract exhibit:

  • Fulfillment: per order, with order numbers, units, picks, packaging
  • Shipping the 3PL bills: per package, with tracking, weights, dimensions, each charge
  • Carrier adjustments: original tracking number, declared and measured dimensions, amount
  • Receiving: per receipt, with PO or ASN, unit, quantity
  • Storage: per location, for the count date or each day averaged
  • Returns: per return, with RMA or order number, type
  • B2B and freight, if you ship wholesale: per order or shipment, with PO and bill of lading
  • Projects and accessorials: work-order reference, hours or units, approved quote
  • Minimum: the shortfall calculation; credits: the invoice each reverses
  • CSV or XLSX, same invoice number and period, sent with the invoice
  • Retention and export of past periods written into the contract

FAQ

Why doesn't my detail file match the invoice total?

In the invoices we review, a PDF and a detail file from the same 3PL don't always agree. Causes include a detail file for a different invoice or period, tax shown on one document but not the other, flat fees, shortfalls or manual charges with no detail rows, prior-period adjustments or credits included in only one, and a corrected or split invoice. Check too that the download is complete; per-row rounding can leave a few cents. Neither document wins by default: ask the 3PL which is its billing record, and get the difference explained before you approve that part of the bill.

Can a 3PL charge for supporting detail?

Custom report builds can carry a fee at some 3PLs, and standard reporting is typically covered by an account management or technology fee. The IWLA's standard terms (2026 revision) make "special stock statements" chargeable[6] but don't address routine billing backup.

What if my 3PL can't provide detail for a fee?

Ask for the next best record: the work order or quote for a project, a dated log with order or receipt references for an accessorial, or the count report for storage. If nothing exists, agree in writing how that charge will be evidenced in future.

How long should a 3PL keep billing detail?

Ask your 3PL to keep invoice detail for the whole contract term plus at least 12 months after it ends, and to export past periods on request. One 3PL's contract guide recommends at least 12 months[11]; non-3PL clause samples keep records three years after termination, or six years after final payment or termination, whichever is later[9].

Terms in this article