E-Commerce Accounting in the UAE: Reconciling Sales
How UAE online sellers account for website and marketplace sales, gateway payouts, cash on delivery, returns, VAT and inventory, and reconcile it all.
Editorial disclosure: Pyalm publishes and maintains the products and free tools discussed on this site. Regulatory statements are linked to primary sources where applicable. No independent professional review is claimed unless a reviewer is explicitly named.
Online selling creates accounting problems that offline shops don't have: money arrives later and net of fees, from several channels, with returns and cash-on-delivery that couriers hold for days. If you only record what lands in the bank, your revenue, VAT and stock will all be wrong.
Why e-commerce books drift
- A gateway or marketplace pays out weekly or fortnightly, netting commissions, shipping and refunds.
- COD is collected by the courier and remitted in batches.
- Returns reverse revenue (and VAT) in a later period.
- Stock exists in your warehouse, at a fulfilment centre and in transit.
- Customers can be in the UAE, in the GCC or further afield, with different VAT treatment.
Record the sale, then the money
Always record two separate things:
- The sale when the order is fulfilled: Dr Receivable from channel/gateway (gross) / Cr Sales / Cr VAT payable.
- The settlement when the money arrives: Dr Bank (net) / Dr Fees and commissions / Cr Receivable from channel.
This keeps gross revenue and channel cost visible, which is how you learn whether a marketplace actually makes money.
Reconciling each channel
For every payout:
- Download the settlement report (orders, refunds, fees, adjustments, reserves).
- Check that it totals to the bank deposit.
- Match each order in the report to the order in your system.
- Post fees as expenses (with input VAT if you hold a valid tax invoice from the platform).
- Investigate unmatched items — missing orders, unexplained deductions.
The Bank Reconciliation Tool can match a settlement export against your ledger by amount and date. Clean messy exports with the CSV ⇄ JSON Converter and the Bank Statement Converter.
Cash on delivery
COD creates a receivable from the courier until they remit. Track it by order and by remittance batch; couriers often deduct COD fees and delay payment. Chase differences — it's a common source of silent loss. Use an ageing view: AR ageing guide.
Returns and refunds
- Issue a credit note for each return rather than editing the original invoice — see credit note vs debit note.
- Reverse VAT and COGS and return the stock to inventory (or write it off if unsellable).
- Watch the return rate by channel and product.
VAT
Sales to UAE customers are generally standard-rated at 5%. Exports and sales to other countries may be zero-rated if conditions and evidence are met — see zero-rated vs exempt supplies. Where a marketplace is involved, determine who is the supplier for VAT purposes in each case; the rules can be subtle, so take advice.
Inventory and COGS
Track cost per unit including freight and duty (landed cost), and decide on a costing method — see FIFO vs LIFO vs weighted average. Count stock regularly, including units at fulfilment centres, and reconcile to the ledger. Use the Reorder Point Calculator to avoid stock-outs.
Metrics worth tracking
- Gross margin per channel, after fees, shipping and returns.
- Contribution margin per order.
- Customer acquisition cost — CAC Calculator — against margin.
- Return rate, COD failure rate, days to payout.
Systems
Many sellers outgrow spreadsheets quickly — see when spreadsheets stop being enough. Pyalm Books combines invoicing, inventory, purchases, banking and reconciliation and VAT reporting on one double-entry ledger, free during beta. If you're building or improving the store itself, see e-commerce website development in the UAE and our UAE e-commerce Google Shopping case study.
Rules and thresholds change. Confirm the current position with the Federal Tax Authority (tax.gov.ae) or a qualified adviser before you file or pay.