How to reconcile courier settlements with your orders
The short answer
Reconciling courier settlements means matching every line of the courier's settlement sheet and payout to an order in your store, then checking the amount the courier collected, the fees it deducted and the status it reports. Any line that does not match goes to a review list, and an order is marked paid in the store only when its payout matches what the order still owes.
What is a courier settlement?
When a courier delivers your parcels and collects payment from your customers, it later transfers that money to you after deducting its own fees. Alongside the transfer, the courier usually shares a settlement sheet: a file that lists each parcel, the amount collected, the fees deducted and the net amount paid out.
Reconciliation is the check between that sheet and your own order records. Its purpose is simple: every delivered order should appear in a settlement, every amount should be correct, and nothing should be marked paid before the money has actually been transferred.
Why do courier settlements and orders drift apart?
Settlements and orders come from two different systems, so they rarely line up on their own. Common reasons include:
- A parcel was delivered but is missing from the settlement sheet.
- The amount the courier collected differs from the order total, for example after a partial delivery or a price change agreed with the customer.
- The courier fee deducted differs from the fee you expected.
- The courier marks a parcel as returned, but it never arrived back at your warehouse.
- The courier's status and your store's status disagree.
- A delivered parcel has been waiting for settlement longer than your agreement with the courier allows.
How do you reconcile a courier settlement sheet, step by step?
The following procedure works whether you use a spreadsheet or a dedicated tool. The order of the steps matters, because each one depends on the one before it.
- Import the settlement sheet. Download the file from the courier's dashboard and load it as it is, without editing rows by hand. Keep the original file for your records.
- Match each line to an order. Use the courier's tracking number or your order reference as the key. Every line should find exactly one order, and every delivered order should find exactly one line.
- Raise mismatches for review instead of fixing them silently. Put each problem into a clear category: delivered but not in the settlement, amount mismatch, fee mismatch, courier says returned but not received, status conflict, or settlement delayed.
- Review payouts per parcel. For each parcel, look at three values side by side: what the courier collected, what it deducted in fees, and what is still expected to be transferred.
- Mark the order paid in your store only when the payout matches. If the transferred amount matches what the order still owes, update its payment status. If it does not, leave it open and keep it on the review list.
- Restrict access. Settlement and payout screens show money movements, so limit them to the people who handle finance.
How should you handle each type of mismatch?
Each review category points to a different follow-up. A parcel that is delivered but missing from the sheet often appears in a later settlement, so check it again after the next transfer before raising it with the courier. An amount or fee mismatch needs the courier's written breakdown for that parcel. A parcel the courier reports as returned but you never received should be checked against your returns log before you open a claim. Status conflicts and delayed settlements are best raised with your courier account manager in one batch, with tracking numbers attached.
The important rule is to record the problem and keep the order open. Editing the numbers to make a sheet balance hides the issue instead of solving it.
When should an order be marked paid in Shopify?
Shopify tracks payment separately from fulfilment through an order's financial status, which can take values such as pending, partially paid or paid. When the money arrives, the outstanding balance can be recorded by marking the order as paid.
For orders where the courier collects payment, the order should normally stay pending until the courier's transfer exists and the collected amount matches the outstanding balance in Shopify. Marking an order paid at delivery, before the money arrives, makes your Shopify reports look settled when they are not.
Who should have access to courier settlements?
Settlement data shows what the business earned, what it paid in fees and what it is still owed. Consider limiting it to the people who handle finance. Customer service and warehouse staff can do their work without seeing it, and a short access list makes the numbers easier to trust.
How Ora Dash handles courier settlements
Ora Dash, the operations system for e-commerce brands in Egypt, follows this same procedure. You upload the courier's settlement sheet, orders are marked as settled, and mismatches are raised for review in the categories above. A payouts view shows, for each parcel, what the courier collected, what it deducted and what is still expected, and the settlement details also appear inside each order. An order is marked paid in Shopify only when the courier's payout exists and the collected amount matches what Shopify shows as outstanding. Access to these screens is set per person, like every other screen. You can see it on your own orders by booking a demo.
Frequently asked questions
What is a courier settlement sheet?
It is a file the courier shares with each transfer. It lists every parcel included, the amount the courier collected, the fees it deducted and the net amount paid out to you.
How do I match courier payouts to Shopify orders?
Use the tracking number or order reference as the key, match each settlement line to exactly one order, then compare the collected amount, the fees and the net payout with what the order still owes in Shopify.
What should I do if a delivered order is missing from the settlement?
Keep the order open and flag it as delivered but not in the settlement. Check it again after the next transfer, and if it is still missing, raise it with the courier using the tracking number.
Should I mark an order paid when it is delivered?
No. Delivery confirms the customer received the parcel, not that the money reached you. Mark the order paid in Shopify only when the courier's payout exists and the amount matches the outstanding balance.
Who on my team should see courier settlements?
The people who handle finance. Other roles can do their work without access to money movements.
Can Ora Dash reconcile courier settlements?
Yes. Ora Dash lets you upload the courier's settlement sheet, raises mismatches for review, shows per-parcel payouts, and marks an order paid in Shopify only when the payout matches. Access is set per person, like every other screen.
One operations system runs everything after the order.
Book a demo