Reconcile COD From Multiple Couriers in the UAE: Step by Step

To reconcile COD from multiple couriers in the UAE, start from your own order list, not from the courier statements. Match every cash-on-delivery order to its courier status, then to the cash the courier says it collected, then to the amount that landed in your bank after fees. Anything that does not match goes on an exceptions list with an owner and a date.

This guide gives you a repeatable process, a table for partial deliveries and returns, a fee-check template and a monthly checklist.

What do you need before you start?

You need three records for the same period. If one is missing, you cannot close the month.

Also keep each courier's contract or rate card at hand. COD terms are usually set per account, so your settlement window, COD fee and return charges may differ from another merchant's. Aramex's plans page, for example, lists COD remittance as a feature but gives no timing. The timing sits in your agreement.

Settlement times quoted online range from a few business days to a month. That spread is why you should write your own due date for each courier in a simple table and use that.

How do you reconcile COD from multiple couriers in the UAE?

Follow these seven steps, one courier at a time, then roll the results into one summary.

1. Freeze the period. Pick a cut-off, such as orders handed to couriers between the 1st and 7th. Use the same cut-off for every courier so the numbers compare.
2. Export your COD orders. Filter to cash-on-delivery only. Keep order ID, AWB, courier, and the amount the customer should pay.
3. Add the courier status. Pull each courier's report and attach a status to every AWB. Use a fixed list: delivered, failed, refused, reattempt, cancelled, returned. Fulfillor makes the useful point that "delivered" is not the same as "reconciled". A delivered order is only reconciled once the cash is matched.
4. Match cash collected to order value. For each delivered order, compare the courier's collected amount to your expected amount. Flag any difference, even AED 1.
5. Match the statement to the bank. Gross COD on the statement, minus listed deductions, should equal the net payout. Then check that the net payout equals the bank credit.
6. Check the due date. Compare the payment date with the settlement window in your contract. Mark each item as on time, overdue or not yet due.
7. Log exceptions and close. Every unmatched line gets a reason, an owner and a follow-up date. Close the period only when exceptions are either resolved or carried forward on a named list.

Core2Plus describes the same logic as four matches: delivered against courier confirmation, cash against order value, remittance against cash less fees, and failed deliveries against returned stock. It also suggests a COD clearing account with a sub-account for each courier. That is an accounting practice, so confirm the setup with your accountant.

A worked example

Say you use three couriers and, in one week, Courier A reports 50 delivered COD orders worth AED 10,000 in total. Its statement shows gross COD of AED 10,000, fees of AED 600 and a net payout of AED 9,400. Your bank shows AED 9,300.

Step 5 catches it. The statement and the bank differ by AED 100. You raise that with Courier A, with the statement number, and put it on the exceptions list. All figures here are made up to show the method.

How do you handle partial deliveries, refusals and returns?

Give each outcome its own rule, so the same case is treated the same way every time.

Two rules prevent most disputes:

• Change the expected amount, not the statement. If a customer keeps only one item, record the new expected amount with the reason. The statement should then match your corrected figure.
• Match returns to stock. A refused order should show up as stock returned. If the courier reports it as returned and nothing arrives, that is a stock problem, not only a cash problem.

Fulfillor also separates a known order with the wrong amount from an unknown reference. Treat them differently. The first is usually a collection error. The second might be a typo, another sales channel or a courier mistake.

What fees do couriers deduct, and how do you check them?

Couriers usually deduct their fees from the COD they owe you, so the payout is lower than the cash collected. Public sources describe flat per-order fees, percentage fees or both, but the real figures vary by contract. Check your own rate card.

Build a deduction check with these columns for each statement:

Recalculate the fee for a sample of lines, or for every line if volumes are small. Any deduction you cannot trace to your rate card is an exception.

Do not confuse buyer fees with courier fees

If you sell on noon or Amazon.ae, you will see COD charges that are not your courier's fee. noon's help page lists a carrier charge for COD of AED 12 in the UAE, included in the buyer's checkout total, and a COD order limit of AED 6,500. Amazon.ae's Cash on Delivery page lists a non-refundable AED 10 COD fee for buyers. Both are buyer-facing charges. They are not the fee your own courier deducts from your remittance.

Also check how each marketplace order is settled. Orders where the marketplace handles delivery and cash reach you through its payout, not through a courier statement you contracted. Look at your seller account to see which route applies, and keep those orders out of your courier reconciliation.

For VAT treatment of courier fees and how long to keep records, check tax.gov.ae or ask your accountant. Do not rely on a blog for that.

What mistakes break COD reconciliation most often?

• Starting from the courier statement. You only see what the courier chooses to report. Start from your orders.
• One spreadsheet tab per courier with different columns. Use one template with the same columns for every courier.
• No due date. Without a settlement date per courier, you cannot tell late from normal.
• Netting fees silently. Booking only the net payout as sales hides your real courier cost. Record gross COD and fees separately.
• Waiting for month-end. Small gaps grow and become harder to prove. A weekly pass on each courier is easier than a monthly clean-up.
• Ignoring disputed amounts. Keep a list of items that have been raised with a courier, with dates and replies, so nothing is forgotten.

What should a monthly COD reconciliation checklist include?

Use this at month-end, after your weekly passes.

1. Every COD order in the month has a final status: delivered, refused, returned, cancelled or still open.
2. Each courier's gross COD, deductions and net payout match its statements.
3. Each statement's net payout matches a bank credit.
4. Every payment is marked on time, overdue or not yet due, against that courier's contract.
5. Overdue amounts have been raised in writing with the courier.
6. Returned and refused orders are matched to stock received.
7. Deductions are traced to the rate card, and unexplained ones are disputed.
8. Marketplace orders are checked against marketplace payouts, separately from courier COD.
9. The exceptions list has an owner and a date for each item.
10. A one-page summary shows, per courier: COD collected, fees, net received, outstanding.

The summary is the page to share with your finance lead or accountant. It also shows you which courier is slowest to pay or most often wrong.

When does software help?

Spreadsheets work for one courier and a few dozen orders a week. With several couriers, different statement formats and daily orders, the manual matching starts to take more time than the decisions do.

Quickship's Last Mile Aggregator is a software module that brings multiple couriers into one dashboard and supports COD reconciliation. It is technology only. Quickship does not deliver parcels or hold your cash, and your couriers still pay you under your own contracts. Whatever tool you use, the method above stays the same: orders first, then status, cash, fees and bank.