Fulfillment invoice reconciliation: a step-by-step method
Reconciliation6 min read
Reconciling a fulfillment invoice means proving each line three ways: against the rate card you signed, against what the warehouse actually did for you that month, and against the months before. Most billing errors show up in exactly one of the three, which is why checking the arithmetic on the invoice alone finds so little. This is the order we use at WareAudit, with the data each step needs.
Three comparisons, not one
An invoice can add up perfectly and still be wrong. A pick fee is wrong if it is above the rate card; a storage line is wrong if it bills more pallets than you had in the building; a receiving charge deserves a question if it is far above what receiving has cost in every earlier month. None of these errors is visible inside the invoice. Each one needs a second document to compare against, and the three documents are different.
| Comparison | What it catches | WareAudit checks |
|---|---|---|
| Invoice against contract | Rates above the rate card, surcharges that were never in the quote, credits promised and not applied, free receiving hours billed at full rate, peak fees outside the window | R4, R2, R5, R7, R8 |
| Invoice against activity | Duplicate lines, orders picked or shipped twice, labels above your zone and weight rates | R1, R14, R15 |
| Invoice against history | Charge types that did not appear on earlier invoices, fee spikes over baseline, cost per order drifting up, spend below the monthly minimum, card surcharges | R3, R13, R9, R10, R11 |
What to export before you start
Reconciliation is mostly collection. Once the five exports below are on your desk, the comparisons take less time than finding the files did. Pull them for the invoice month and for the two months before it: a baseline of two earlier months is what makes the history comparison meaningful.
| Export | Where it comes from | Which comparison needs it |
|---|---|---|
| Invoice lines as CSV, not the PDF summary | Your 3PL billing portal. The PDF groups charges by category; the CSV carries one row per charge with order or SKU references | All three |
| Rate card with effective dates | The signed agreement and every repricing email since. Keep the dates: a rate change mid-month explains a line that otherwise looks wrong | Contract |
| Orders shipped in the month | Your store or order management export: order ID, ship date, units, weight, destination | Activity |
| Inventory on hand by location | The warehouse system inventory report on the snapshot date your 3PL bills storage from | Activity |
| The two previous invoices | Same portal. They set the baseline for spikes, trends and unused minimums | History |
Step by step
- 1Match the invoice header to the contract: legal entity, contract or quote reference, billing period, currency. A new entity name or a new period length is the moment charge names tend to change too.
- 2Sort the CSV by charge description and list every distinct charge type. Mark each one as in the rate card, in a later email, or unexplained, and put the unexplained ones in the letter. A charge type that did not appear on your earlier invoices is check R3 in our reports.
- 3For every charge type in the rate card, compare the unit price on the invoice with the contract price. Where the CSV has no unit price, divide amount by quantity. Anything above the contract rate is R4; a recurring surcharge that the quote never mentioned is R2.
- 4Look for the same service on the same order, on the same day and for the same amount, billed twice: that is R1. An order shipped twice, visible when its shipments together carry more units than were ordered, is R14; that check needs the units ordered and shipped on each row.
- 5Compare the storage quantity on the invoice with your own inventory report for the snapshot date; that comparison is yours to make. Compare the storage rate with the rate card: above it is R4. For shipping, compare each label with the rate for its zone and weight; above the rate is R15.
- 6Put the three months side by side by charge type. A fee that jumped against its own baseline is R13; cost per order that drifts up while volume holds is R9; spend below the monthly minimum you agreed is R10, which the report shows as savings rather than a dispute because the 3PL is within the contract; a card surcharge you could avoid by paying by bank transfer is R11.
- 7Check the credits. Anything promised in email that is not on the invoice is R5. Free receiving hours charged at full rate without a credit line are R7. Peak surcharges outside the window your contract names are R8.
- 8Write it down with line references. One finding, one paragraph: the line, the contract figure, the arithmetic, the amount. The reader on the other side should be able to check it without opening your spreadsheet.
Writing to your 3PL
Agreements often set a window for billing disputes, and the window runs from the day the fee is invoiced or charged, or from the day the invoice arrives, not from the day you notice the error. ShipMonk requires written notice within 30 days of a usage fee being invoiced or charged and says it will not review requests received later; carrier and third-party fees are outside that clause. Flexport's Payment Terms and Conditions require any dispute of freight or accessorial charges in writing within 30 days of receiving the invoice; whether that clause reaches fulfillment charges is a question for your account team, and until it is answered in writing, 30 days from receipt is the safe assumption. If your contract names a window, reconcile every invoice inside it, which in practice means the week it arrives. How to dispute a 3PL invoice covers the letter itself.
How WareAudit runs the same steps
WareAudit reads ShipBob through its REST API and ShipHero through its GraphQL API; any other 3PL works through a CSV upload of the invoice export, up to 25 MB per file, about 70,000 lines. It asks for three invoices so the history comparison has a baseline, runs the checks in the table above, and lists in the report every check it could not run because the data did not carry what that check needs. Each finding cites the invoice lines; the findings marked as disputes come with a letter you can send as written or edit, and savings findings are reported without one. The sample report shows the format; the checks list has the full set. Not legal or accounting advice.
Sources
- The WareAudit checks named in this article are the ones on the checks list and in the report templates, as of 2026-11-02; the three-invoice baseline and the CSV limits are stated in the FAQ on the home page, which also says that WareAudit reads from the 3PL account and never writes to it.
- ShipMonk Terms of Service, Fulfillment Services Agreement (U.S.), section 6.5 Usage Fee Disputes: written notice within 30 days of the fee being invoiced or charged, carrier and third-party fees excluded. shipmonk.com/terms-of-service, read 2026-11-02.
- Flexport Payment Terms and Conditions, flexport.com/terms-and-conditions/payment-terms-and-conditions: freight or accessorial charges must be contested in writing by email within 30 days of receipt of the invoice. Read 2026-11-02.
- No price figures are used in this article.