Reconcile a US fulfilment invoice with order and parcel records
Match actual charges to the agreed billing units and operating records before deciding whether a difference needs correction.
Reviewed 2026-10-08 · 4 min readChoose the report and period you are checking
A storefront report and a fulfilment invoice can describe different activity. An archived seller discussion raises concern about platform profit figures and supplier bills, but the explanation in that post should not be applied to every current Shopify report.
Shopify currently distinguishes product profit reports, which use recorded product costs, from market and order margin reports whose listed metrics include shipping costs, duties and import taxes. Check the report definition and the data available in your account before deciding that an expense is absent.
For the invoice check, fix the period, currency, provider and agreed rate-card version. Record whether the bill groups activity by receipt, dispatch or another contract event. Keep taxes and currency conversion separate where they apply. This operational reconciliation does not replace the accounting treatment used for your business.
Match the charge to its own billing unit
Use the unit in the agreement: an order, an additional picked item, a parcel, an inbound carton or a storage period. Keep the operating record appropriate to that unit. A single order may generate several parcels, while receiving and storage charges may have no customer order at all.
Retain the invoice line identifier, relevant operation reference, agreed unit, observed quantity, applicable rate and billed amount. Where the provider groups activity, request the supporting detail needed to reconcile that group. If evidence is missing, leave the line unresolved rather than assuming the charge is zero or wrong.
Keep replacements and credits connected
A replacement parcel needs its own dispatch reference linked to the original order. Record the merchant instruction and the reason for the new movement. Check whether its handling and transport have been charged separately, included elsewhere or credited under the applicable terms.
Keep refunds, credit notes and warehouse stock decisions in their own records. Customer payment may change before a parcel arrives or before a provider issues a credit. When the posting periods differ, explain the timing and retain the reference for the later adjustment. Avoid subtracting the same credit in both the current bill and a previous reconciliation.
Work through an invented invoice
The following USD amounts and rates are invented solely to demonstrate the method. They are not Jeton prices, carrier prices or a market benchmark. In this example, the agreement has no minimum or separate taxes. The ordinary parcel line is expected to cover 100 shipments; two replacement parcels are priced in their own line.
| Charge | Recorded basis | Expected | Billed |
|---|---|---|---|
| Order handling | 100 orders × 1.00 | 100.00 | 100.00 |
| Additional item picks | 20 picks × 0.25 | 5.00 | 5.00 |
| Packing materials | 100 parcels × 0.30 | 30.00 | 30.00 |
| Ordinary transport | 100 parcels × 4.00 | 400.00 | 416.00 |
| Inbound receiving | 10 cartons × 2.00 | 20.00 | 20.00 |
| Storage | Agreed illustrative period charge | 50.00 | 50.00 |
| Replacement work and transport | 2 approved replacements × 5.00 | 10.00 | 10.00 |
| Credit note | One identified credit | -6.00 | -6.00 |
| Total | 609.00 | 625.00 |
Investigate the difference before assigning a cause
The example leaves a USD 16 difference on ordinary transport. Request the parcel references and the provider calculation for that line. It might relate to missing operating records, a different billing period, an agreed adjustment or an incorrect quantity. The difference alone does not establish overbilling.
Record the provider response, supporting references and the decision for each unresolved line. If a correction is agreed, connect the revised invoice or credit to the original charge. If the charge is explained, update the operating evidence and retain that explanation for the next period.
Review the complete workflow
At the next invoice review, check whether the same reference or field is missing again. Improve the order, parcel or warehouse handover that creates the gap, and keep responsibility for that record explicit. Compare future bills with the same agreed scope so changes in workload remain visible.
For a fulfilment scope discussion with Jeton Express, bring your workload, charging units and anonymised examples of the records you need. Confirm the applicable reporting and billing arrangements before commissioning new work.
Carry the findings into the recurring service review
Use the same account, period and reference definitions when reviewing recurring work with the shipping or warehouse team. Name the owner of the operating records and the owner of the invoice response. A consolidated charge may need its underlying event list; an account-level fee may need the agreed billing period rather than a parcel number.
Record approved changes to packaging, additional handling or shipment scope with their effective date and authorising contact. Connect a charge for that work to the approval and actual operation. If a fee description or billing unit has changed, compare the old and new definitions before judging the difference in totals.
At the next review, distinguish explained lines, agreed corrections and questions still awaiting evidence. Link a credit or replacement invoice to its original line and retain the closing decision. Keep an action owner and agreed follow-up date for missing records so the same gap does not pass into the next billing cycle.