Accounting for Ecommerce
UAE 2026
How UAE ecommerce businesses and online retail stores post purchases & sales and reconcile marketplace payouts — across Amazon, Shopify, WooCommerce, and Zoho Books.
Open the flow Explore our Accounting Services ↗Where do you sell?
Purchase
Ordering from supplier
2.🔄 PO syncs here
AutomaticPO appears automatically. Accountant can see and track it.
1.Create Purchase Order
Manual·OperationsOperations creates a PO with SKUs, qty, prices, destination warehouse.
⚠️ SKU must match the marketplace listing, otherwise COGS posts zero on sale.
⚠️ Warehouse must match the marketplace-mapped warehouse (FBA / 3PL), otherwise stock count drifts.
1.Create Bill from PO
Manual·AccountantWhen vendor invoice arrives, accountant creates Bill from the existing PO — SKUs, quantities, prices, and destination warehouse all pre-populate. This is where stock and its cost are recorded for the first time.
2.🔄 Bill syncs here
AutomaticBill syncs to Zoho Inventory. Stock and unit cost now visible — mirrored from Books.
1.Allocate Landed Costs
Manual·AccountantAllocate freight, customs, insurance and other costs onto the inventory — its unit cost goes up to reflect the true landed cost.
2.🔄 Landed costs update unit costs
AutomaticUnit costs updated with allocated landed costs. Inventory Asset on the Balance Sheet reflects true cost.
Receiving
Supplier ships directly to Amazon FBA or your 3PL
1.Amazon receives stock
AutomaticAmazon owns receiving. Sellable units appear progressively during the Receiving status (not all at Closed). Stock in Amazon updates automatically as this happens.
1.3PL receives stock + Update Shopify
Manual·OperationsPhysical units arrive at the 3PL. Ops manually updates the stock count directly in Shopify admin to match the receive. If your 3PL offers a WMS→Shopify direct connector, this updates automatically — same as FBA.
1.3PL receives stock + Update WooCommerce
Manual·OperationsPhysical units arrive at the 3PL. Ops manually updates the stock count directly in WooCommerce admin to match the receive. If your 3PL offers a WMS→WooCommerce direct connector (ShipStation, ShipBob, etc.), this updates automatically — same as FBA.
Sales & Returns
Customer orders or returns items
3.Invoice created
AutomaticInvoice auto-created from the Sales Order. Revenue and COGS post here. Stock decrements at Invoice creation and syncs back to Zoho Inventory. Same accounting outcome for Amazon, Shopify, and WooCommerce.
2.Sales Order created
AutomaticOrder syncs as a Sales Order (SO) under the marketplace-mapped warehouse, then auto-converts to Invoice. Trigger: Amazon — instant on order; Shopify & WooCommerce — when the 3PL marks the order shipped, via Zoho Inventory’s “Auto-convert SO on Shipment” rule.
1.Customer orders on Amazon
AutomaticOrder placed on Amazon.
1.Customer orders on Shopify
AutomaticOrder placed on Shopify. SO created under the 3PL warehouse; 3PL ships physically.
1.Customer orders on WooCommerce
AutomaticOrder placed on WooCommerce. SO created under the 3PL warehouse (or your own warehouse if no 3PL). Same SO → Invoice flow as Shopify.
2.↩️ Create Credit Note
Manual·AccountantAccountant creates a Credit Note (CN) in Books and flips on the “Sales Return” toggle. That single toggle does three things: restocks inventory, reverses revenue, reverses COGS. Source data comes from each platform’s own return record (see right). Newer Zoho versions support refund auto-sync for Shopify/Woo — confirm during setup; if enabled, this row becomes auto.
3.↩️ Sales Return created
AutomaticSales Return mirrored from Books. Stock restored on paper in the marketplace-mapped warehouse (FBA / 3PL).
1.↩️ Customer returns
AutomaticAmazon processes return + refund automatically. Source for accountant: Amazon Return Report (or Settlement Report). Does not auto-sync to Zoho.
1.↩️ Customer returns
AutomaticShopify processes return + refund automatically. Source for accountant: Shopify Refunds Report. Does not auto-sync to Zoho without Flow setup.
1.↩️ Customer returns
AutomaticWooCommerce records the refund in the order log automatically when processed via admin or gateway. Source for accountant: WooCommerce admin order log (full SKU-level detail). Does not auto-sync to Zoho without Flow setup.
Reconciliation
Reconcile the bank & platform statements against Bills & Invoices.
2.Reconcile platform settlement → Books
Manual·AccountantWalk through each platform payout line by line. Revenue → match to auto-created Invoices (from the Phase 3 sync). Refunds → match to Credit Notes (catch up any missing CN per Phase 3). Fees (referral, fulfillment, storage, ad, transaction, processing, gateway) → match to platform Bills. Net transfer → categorize as own account transfer.
1.Download Amazon Settlement Report
Manual·AccountantDownload CSV/PDF from Seller Central. Itemizes revenue, refunds (incl. restocking fees), fees (referral, FBA, storage, ads), and net biweekly transfer.
1.Download Shopify Payout Report
Manual·AccountantDownload from Shopify admin. Contains sales, refunds, processing fees, and net periodic transfer. 3PL fees come as a separate invoice from the 3PL.
1.Download payment gateway payout report (Stripe / PayPal / Telr / Network International — depends on gateway)
Manual·AccountantDownload from the gateway dashboard. Contains sales, refunds, gateway fees, and net transfer. 3PL fees come as a separate invoice. Multi-gateway shops reconcile each gateway separately.
3.Adjust inventory asset
Manual·AccountantPost stock adjustments for variances reported by ops (shrinkage, damage, lost). Inventory Asset goes up or down, with the matching entry to a shrinkage / damage expense account.
2.Compare stock counts
Manual·OperationsCompare Zoho per-warehouse counts vs marketplace + Download 3PL stock reports. Flag variances for the accountant to adjust.
1.Download Amazon Inventory Reports
Manual·OperationsPull Manage FBA Inventory + Inventory Ledger reports — source of truth for FBA stock counts.
1.Download 3PL stock report
Manual·OperationsPull stock report from the 3PL provider — source of truth for 3PL warehouse counts.
1.Download 3PL stock report
Manual·OperationsPull stock report from the 3PL provider — source of truth for 3PL warehouse counts.
1.Reconcile bank, acquiring and corporate card statements
Manual·AccountantPull bank, acquiring and corporate card statements. Match lines that have a matching Bill in Books — supplier bill payments (clearing AP from Phase 1). Categorize everything else: platform cash-outs to the bank, payroll & employee compensation, reimbursements, corporate card or petty cash expenses, owner withdrawals, bank fees. Catches anything missed elsewhere.
Tax & Reporting
Filing taxes and closing out the books
1.File VAT & CT
Manual·AccountantVAT (quarterly): 5% charged on UAE sales (0% on exports outside GCC). Import VAT due on goods entering the UAE. Reverse Charge on Amazon/Shopify fees billed from abroad — you self-charge 5% and reclaim 5%, net cash impact zero, but still reportable on the filing. Corporate Tax (annual): 9% on taxable profit above AED 375,000. 0% rate available via Small Business Relief (revenue ≤ AED 3M) or Qualifying Free Zone Person status for free-zone sellers on qualifying income. All data consolidates in Zoho Books for FTA filing.
1.Prepare P&L, Balance Sheet, Cash Flow + Inventory Valuation
Manual·AccountantP&L: revenue by channel, COGS with landed costs, gross margin analysis. Balance Sheet: inventory asset, AR, AP, cash position. Cash Flow: operating / investing / financing — the early-warning signal when your P&L says you’re profitable but your bank account says otherwise.
Purchase
Ordering from supplier
2.🔄 PO syncs here
AutomaticPO appears automatically. Accountant can see and track it.
1.Create Purchase Order
Manual·OperationsOperations creates a PO with SKUs, qty, prices, destination warehouse.
⚠️ SKU must match the marketplace listing, otherwise COGS posts zero on sale.
⚠️ Warehouse must match the marketplace-mapped warehouse (FBA / 3PL), otherwise stock count drifts.
1.Create Bill from PO
Manual·AccountantWhen vendor invoice arrives, accountant creates Bill from the existing PO — SKUs, quantities, prices, and destination warehouse all pre-populate. This is where stock and its cost are recorded for the first time.
2.🔄 Bill syncs here
AutomaticBill syncs to Zoho Inventory. Stock and unit cost now visible — mirrored from Books.
1.Allocate Landed Costs
Manual·AccountantAllocate freight, customs, insurance and other costs onto the inventory — its unit cost goes up to reflect the true landed cost.
2.🔄 Landed costs update unit costs
AutomaticUnit costs updated with allocated landed costs. Inventory Asset on the Balance Sheet reflects true cost.
Receiving
Supplier ships directly to Amazon FBA or your 3PL
1.Amazon receives stock
AutomaticAmazon owns receiving. Sellable units appear progressively during the Receiving status (not all at Closed). Stock in Amazon updates automatically as this happens.
1.3PL receives stock + Update Shopify
Manual·OperationsPhysical units arrive at the 3PL. Ops manually updates the stock count directly in Shopify admin to match the receive. If your 3PL offers a WMS→Shopify direct connector, this updates automatically — same as FBA.
1.3PL receives stock + Update WooCommerce
Manual·OperationsPhysical units arrive at the 3PL. Ops manually updates the stock count directly in WooCommerce admin to match the receive. If your 3PL offers a WMS→WooCommerce direct connector (ShipStation, ShipBob, etc.), this updates automatically — same as FBA.
Sales & Returns
Customer orders or returns items
3.Invoice created
AutomaticInvoice auto-created from the Sales Order. Revenue and COGS post here. Stock decrements at Invoice creation and syncs back to Zoho Inventory. Same accounting outcome for Amazon, Shopify, and WooCommerce.
2.Sales Order created
AutomaticOrder syncs as a Sales Order (SO) under the marketplace-mapped warehouse, then auto-converts to Invoice. Trigger: Amazon — instant on order; Shopify & WooCommerce — when the 3PL marks the order shipped, via Zoho Inventory’s “Auto-convert SO on Shipment” rule.
1.Customer orders on Amazon
AutomaticOrder placed on Amazon.
1.Customer orders on Shopify
AutomaticOrder placed on Shopify. SO created under the 3PL warehouse; 3PL ships physically.
1.Customer orders on WooCommerce
AutomaticOrder placed on WooCommerce. SO created under the 3PL warehouse (or your own warehouse if no 3PL). Same SO → Invoice flow as Shopify.
2.↩️ Create Credit Note
Manual·AccountantAccountant creates a Credit Note (CN) in Books and flips on the “Sales Return” toggle. That single toggle does three things: restocks inventory, reverses revenue, reverses COGS. Source data comes from each platform’s own return record (see right). Newer Zoho versions support refund auto-sync for Shopify/Woo — confirm during setup; if enabled, this row becomes auto.
3.↩️ Sales Return created
AutomaticSales Return mirrored from Books. Stock restored on paper in the marketplace-mapped warehouse (FBA / 3PL).
1.↩️ Customer returns
AutomaticAmazon processes return + refund automatically. Source for accountant: Amazon Return Report (or Settlement Report). Does not auto-sync to Zoho.
1.↩️ Customer returns
AutomaticShopify processes return + refund automatically. Source for accountant: Shopify Refunds Report. Does not auto-sync to Zoho without Flow setup.
1.↩️ Customer returns
AutomaticWooCommerce records the refund in the order log automatically when processed via admin or gateway. Source for accountant: WooCommerce admin order log (full SKU-level detail). Does not auto-sync to Zoho without Flow setup.
Reconciliation
Reconcile the bank & platform statements against Bills & Invoices.
2.Reconcile platform settlement → Books
Manual·AccountantWalk through each platform payout line by line. Revenue → match to auto-created Invoices (from the Phase 3 sync). Refunds → match to Credit Notes (catch up any missing CN per Phase 3). Fees (referral, fulfillment, storage, ad, transaction, processing, gateway) → match to platform Bills. Net transfer → categorize as own account transfer.
1.Download Amazon Settlement Report
Manual·AccountantDownload CSV/PDF from Seller Central. Itemizes revenue, refunds (incl. restocking fees), fees (referral, FBA, storage, ads), and net biweekly transfer.
1.Download Shopify Payout Report
Manual·AccountantDownload from Shopify admin. Contains sales, refunds, processing fees, and net periodic transfer. 3PL fees come as a separate invoice from the 3PL.
1.Download payment gateway payout report (Stripe / PayPal / Telr / Network International — depends on gateway)
Manual·AccountantDownload from the gateway dashboard. Contains sales, refunds, gateway fees, and net transfer. 3PL fees come as a separate invoice. Multi-gateway shops reconcile each gateway separately.
3.Adjust inventory asset
Manual·AccountantPost stock adjustments for variances reported by ops (shrinkage, damage, lost). Inventory Asset goes up or down, with the matching entry to a shrinkage / damage expense account.
2.Compare stock counts
Manual·OperationsCompare Zoho per-warehouse counts vs marketplace + Download 3PL stock reports. Flag variances for the accountant to adjust.
1.Download Amazon Inventory Reports
Manual·OperationsPull Manage FBA Inventory + Inventory Ledger reports — source of truth for FBA stock counts.
1.Download 3PL stock report
Manual·OperationsPull stock report from the 3PL provider — source of truth for 3PL warehouse counts.
1.Download 3PL stock report
Manual·OperationsPull stock report from the 3PL provider — source of truth for 3PL warehouse counts.
1.Reconcile bank, acquiring and corporate card statements
Manual·AccountantPull bank, acquiring and corporate card statements. Match lines that have a matching Bill in Books — supplier bill payments (clearing AP from Phase 1). Categorize everything else: platform cash-outs to the bank, payroll & employee compensation, reimbursements, corporate card or petty cash expenses, owner withdrawals, bank fees. Catches anything missed elsewhere.
Tax & Reporting
Filing taxes and closing out the books
1.File VAT & CT
Manual·AccountantVAT (quarterly): 5% charged on UAE sales (0% on exports outside GCC). Import VAT due on goods entering the UAE. Reverse Charge on Amazon/Shopify fees billed from abroad — you self-charge 5% and reclaim 5%, net cash impact zero, but still reportable on the filing. Corporate Tax (annual): 9% on taxable profit above AED 375,000. 0% rate available via Small Business Relief (revenue ≤ AED 3M) or Qualifying Free Zone Person status for free-zone sellers on qualifying income. All data consolidates in Zoho Books for FTA filing.
1.Prepare P&L, Balance Sheet, Cash Flow + Inventory Valuation
Manual·AccountantP&L: revenue by channel, COGS with landed costs, gross margin analysis. Balance Sheet: inventory asset, AR, AP, cash position. Cash Flow: operating / investing / financing — the early-warning signal when your P&L says you’re profitable but your bank account says otherwise.
🔧 One-time setup — flip these once, then forget
Three Zoho settings to flip:
1. Stock-count sync: OFF in both directions. Source of truth is wherever stock physically lives — FBA, 3PL, or your own warehouse. If Zoho pushes a combined total to a marketplace, you’ll oversell. Exception: WooCommerce without a 3PL — Zoho IS the source of truth, so turn Zoho → Woo push ON.
2. Order-event sync: ON. This is what auto-creates an Invoice for every customer order — the engine of the whole flow.
3. Auto-convert SO on Shipment: ON. Set in Zoho Inventory → Preferences → Sales Orders. Makes stock decrement at the right moment.
One warehouse mapping per platform:
• Amazon FBA → create an “FBA Warehouse” in Zoho, map it in the Amazon integration. Skip the “Mark as FBA” item flag.
• Shopify + 3PL → create a “3PL Warehouse”, map it to your Shopify location.
• WooCommerce → “3PL Warehouse” if you use a 3PL, otherwise your own warehouse.
Frequently Asked Questions
How do you do accounting for an ecommerce business in the UAE?
Ecommerce accounting tracks four moving parts: inventory (purchases, landed cost, stock at FBA/3PL), sales (each order posting an Invoice with revenue + COGS), returns (CNs that reverse revenue and restock), and reconciliation (settlements/payouts → AED bank deposit). All four feed UAE VAT filings and the monthly P&L.
How are Amazon FBA fees recorded in accounting?
FBA fees come itemised in the Settlement Report biweekly: referral, fulfilment, storage, advertising, reimbursements. Record as separate expense lines at reconciliation. The settlement nets fees against revenue for the bank transfer line — match net to AED deposit.
How do you reconcile a marketplace settlement report?
Tie out four lines: Revenue → auto-invoices, Refunds → CNs, Fees → expenses, Net transfer → AED bank deposit. Amazon biweekly, Shopify per payout, Woo per gateway payout. Reconcile every cycle.
How are returns and refunds posted?
Create a Credit Note with Sales Return ON — reverses revenue, reverses COGS, restocks unit. Source: Amazon Return Report / Shopify Refunds Report / Woo admin order log. None auto-syncs without Zoho Flow.
How is UAE VAT handled on Amazon and Shopify fees billed from abroad?
Amazon and Shopify invoice fees from outside the UAE (Luxembourg / Ireland / US) → Reverse Charge Mechanism. Self-assess 5% Output VAT, recover same as Input VAT — net cash impact zero, but reportable.
What inventory costing method should an ecommerce business use?
FIFO for UAE ecommerce — IFRS-compliant, audit-friendly, captures landed cost per shipment lot. Each Bill creates a cost lot, landed costs adjust it, FIFO COGS posts at Invoice creation. Set once at item level — switching later is painful.
Need help with accounting for your ecommerce business?
Skrooge runs accounting & tax for UAE ecommerce sellers — Dubai, Abu Dhabi, and free zones — setting up the books, inventory and marketplace reconciliation is part of the service.