eCommerce ERP Consultant, UAE

Cash at the door as a receivable, not a mystery

When a customer pays the driver, the sale is not finished. The courier holds your money until its next remittance, deducts delivery and collection charges, and sends a statement that may cover hundreds of parcels. Meanwhile some parcels were refused, some customers were unreachable and some orders were part-delivered. If the ERP treats the order as paid on dispatch, the books overstate cash. If it waits for a spreadsheet from operations, the books lag by weeks.

I design cash on delivery as a receivable from the courier. When the courier confirms delivery, the customer's balance moves to the courier's account. The remittance statement then posts the cash received, the courier's charges and any shortfalls, and leaves a clear list of what is still outstanding. Aging by courier shows who is slow to pay.

A few rules make this work:

• Delivery status comes from the courier feed, not from manual updates.
• Refused and returned parcels reverse the receivable and bring stock back after inspection.
• Charges for failed attempts are booked as delivery cost against the order.
• Differences between collected and remitted cash are investigated within an agreed period.

This sits alongside the stock handling covered on my Zoho Inventory page for the UAE, which deals with returning parcels to the shelf.

Card, wallet and pay-later settlements

Prepaid orders bring their own reconciliation work. A payment gateway settles card and wallet payments in batches, net of its fees and of any refunds processed since the last batch. A pay-later provider usually pays the merchant the order value minus its charge and then collects instalments from the shopper itself. A marketplace pays out on its own cycle after commission, fulfillment and advertising charges. Each of these arrives in the bank as one figure.

I set up a clearing account for each gateway, provider and marketplace. Orders post the gross sale and VAT into it. The settlement file posts fees, refunds, chargebacks and holds. The bank receipt clears the remainder. Anything left in the account is a specific question, not a general mismatch.

Refund routing matters here. A refund on a card order goes back through the gateway. A refund on a cash order is often paid by bank transfer or as store credit. A refund on a pay-later order has to be raised with the provider. I define each route, who approves it and how it posts, and I test them during UAT with real settlement files from your providers.

Once settlements reconcile cleanly, finance can compare the true cost of each payment method, which often changes how strongly a brand promotes prepaid checkout.

VAT, invoices and selling across the GCC

Online sales in the UAE generally carry VAT like other sales, and delivery charges, discounts, store credit and marketplace fees each have VAT implications that your tax advisor should confirm. Customer-facing tax invoices often need Arabic alongside English. Tax rulings are outside my scope; my part is an ERP that carries the right tax codes, prints compliant bilingual documents as your advisor specifies, and posts marketplace fee invoices with their input VAT.

National e-invoicing is also coming to the Emirates, and its scope and timing for different types of business should be checked with your advisor. During selection, press vendors on their plans for high-volume consumer sales under that program, not just business invoices.

Many UAE brands also ship to other GCC countries. Cross-border orders can involve customs declarations, duties collected from the customer or absorbed by the seller, and tax registration questions in the destination country. Your advisor and logistics provider should define the obligations. The ERP needs to record destination country, duty paid, who bore it and the courier's cross-border charges, so margin on export orders is visible.

Entity structure matters too. Brands often operate through a free zone or mainland company, and which entity sells to which customers can affect licensing and tax. My UAE ERP consultant page covers entity and tax design for the wider business.

Margin per delivered order and the cost of returns

In a market where a share of cash orders are refused or undeliverable, the margin on an order placed is not the margin on an order delivered. A refused parcel costs outbound delivery, sometimes a return trip, handling and repacking, and the advertising that produced the order. None of that shows in the storefront's sales report.

I define margin per delivered order as an agreed calculation:

1. Net sale value after discounts, store credit and refunds.
2. Less the cost of goods landed in the UAE, with freight, duty and clearing charges on imports.
3. Less delivery cost, including failed attempts and returns allocated to the order.
4. Less gateway, pay-later and marketplace fees.
5. Less an allocated share of ad spend on Meta, Snapchat, Google and marketplace ads.

When this calculation runs from ERP data, the business can see which delivery zones, products and campaigns create expensive failures. Some brands respond by asking for prepayment in certain zones or for certain order values; others change their confirmation calls. Those are commercial decisions, but they need reliable numbers.

The ad spend layer links directly to my paid marketing work: campaigns can be judged on delivered, paid orders rather than on clicks or checkout events.

Customer data, consumer rules and choosing a platform

The UAE has federal laws on consumer protection, electronic commerce and personal data protection that affect how online sellers present prices, handle returns and process customer information. Your legal advisor should define the obligations. In the design, I limit who can see customer addresses and phone numbers, keep marketing consent on the customer record and avoid exporting personal data to uncontrolled spreadsheets.

A typical UAE starting point is a hosted storefront, marketplace seller portals, courier portals and an accounting package fed by monthly journals. When comparing what comes next, I score platforms on order volume, courier and gateway integration, settlement import, Arabic document output, multi-entity support and reporting, using scripted demos built from your real cases.

Migration covers product masters with Arabic names, open orders, cash still with couriers, gateway and marketplace balances awaiting payout, store credit owed to customers and a count of stock in each location. I plan go-live away from Ramadan, Eid, White Friday and year-end sale periods.

Sessions run remotely on Gulf Standard Time in your working week. The UAE hub, my ERP integration service and the eCommerce industry page cover related topics.