Check your 3PL invoice.
A 3PL invoice audit checks billed charges against your agreement and warehouse records. Use this free workbook to compare rates and quantities, check monthly minimums, and reconcile the lines to your invoice total.
Download the audit workbookFree. Download it without signing up.
What to check
What did they charge you for?
Get the itemized invoice, your current agreement, and the warehouse activity for the same period. A per-order rate and a per-item rate can produce very different bills.
Receiving
Match billed hours, units, cartons, or pallets to receiving records. Check included time and when extra handling starts.
Receiving report, labor log, appointment record, and the receiving section of your rate card.
Storage
Check the space type, measurement date, and billing interval. Convert pallet-days and pallet-months before comparing charges.
Daily occupancy or inventory report, location types, storage rate, and proration rule.
Picking and packing
Check whether the rate applies per order, line, or unit. Account for included picks, wholesale handling, and special product fees.
Shipped order detail, item counts, packaging usage, and the applicable rate tier.
Returns and projects
Match charges to completed returns or approved work. Check whether the fee covers each item, each return, or each hour.
Completed return records, approved work order, labor detail, and agreed pricing.
Postage and accessorials
Match the shipment, weight, zone, and surcharge to the carrier record. Apply the markup allowed by your agreement.
Carrier charge detail, tracking number, adjustment record, and markup terms.
Monthly minimums
Confirm which services count toward the minimum and which billing period applies. Calculate the shortfall once for that period.
Minimum-spend clause, eligible charges for the full period, and the billed top-up.
Using the workbook
Work through one invoice first.
Start with the itemized invoice and work through the charges line by line. The workbook has separate tabs for service charges and monthly minimums, plus a summary, checklist, and worked examples. Use USD throughout.
1
Enter each service-charge line
Use a unique key that includes the 3PL, invoice, and line reference. Keep the monthly minimum top-up for the Minimums tab.
2
Calculate the expected charge
For simple charges, enter the verified quantity and agreed rate. For tiers, allowances, proration, or percentage fees, choose Manual amount and record your calculation source.
3
Check the whole billing period
Confirm which charges count toward a minimum. Enter the eligible spend for the full period, then compare the expected shortfall with the billed top-up.
4
Reconcile the invoice total
Enter the invoice total, then the total of taxes, credits, and charges you left out of the audit. Enter credits as negative amounts. Account for any remaining difference and finish the row checks before using the totals.
Monthly minimums
A $1,500 minimum can mean a $200 charge.
Suppose your minimum is $1,500 and the services that count toward it total $1,300. The expected top-up is $200. Adding another $1,500 would charge the minimum on top of the services it was meant to cover.
- Agreed minimum
- $1,500
- Eligible spend
- $1,300
- Expected top-up
- $200
This calculation applies to a minimum-spend top-up. A fixed monthly service fee or a per-event minimum may work differently. Check the clause before choosing the calculation.
Questioning a charge
Send the line reference and the calculation.
Give your 3PL the invoice line, your calculation, and the records supporting it. Check the agreement and warehouse activity before asking for a credit. Use this email to put the question in writing.
Open the billing query template
Subject: Billing questions — invoice [invoice number] Hello [name], We checked invoice [invoice number] against our agreement and warehouse records and have questions about these lines: [Line reference]: billed [amount]. Our calculation is [verified quantity] × [agreed rate] = [expected amount], a difference of [amount]. The rate is in [agreement section or rate-card reference]. We checked the quantity against [activity report and period]. We have attached both, along with the invoice detail. Can you check the quantities and rates used for these lines? If the calculation above is correct, please issue a credit for [amount]. Thank you, [name] [company] Replace the bracketed fields and check every calculation before sending. For tiered pricing or monthly minimums, include the full calculation rather than the quantity × rate line.
Frequently asked questions
Is the 3PL invoice audit workbook free?
Yes. Download it without entering an email address or creating an account. It includes 200 service-charge rows, 50 minimum-spend checks, an audit checklist, and worked examples.
How does the workbook calculate a billing difference?
For a unit-rate charge, it multiplies your verified quantity by your agreed rate and rounds to cents. It subtracts that expected charge from the billed amount. A positive difference means the invoice is higher than your calculation and needs review.
Can it check storage tiers, postage, or percentage fees?
Yes. Choose Manual amount, calculate the expected charge from your agreement and warehouse records, and enter it with the source references. Use this for tiered rates, included allowances, proration, percentage fees, and per-event minimums.
How should I check a monthly minimum?
Use the Minimums tab. Enter the agreed minimum, verified eligible spend for the full period, and billed top-up. The expected top-up is the minimum less eligible spend, with a floor of zero. Keep that top-up out of Invoice audit so it is counted once.
Where do taxes and credit notes go?
Leave credit notes and charges you are not checking out of the service-charge table. Add them up and enter the total in the summary’s excluded amount, with credits entered as negative amounts. The summary checks that these amounts, audited service charges, and minimum top-ups add up to the invoice total. Use USD throughout.
Does a difference mean the 3PL owes me a credit?
Check the agreement and warehouse records with your 3PL first. A difference can come from an incorrect charge, a missing record, or a term you have not accounted for. Request a credit once you have confirmed the charge is wrong.
The records behind the invoice
Keep orders and fulfillment records connected.
Find the order, shipment, and inventory movement behind a charge. Explore those records in CommerceOS, or read the guide to your full cost per order.