Shopify sales flow into UAE VAT-ready books through one repeatable chain: export, reconcile to the bank, split 5% VAT out of every sale, tag expenses with their recoverable input tax, and file a return the FTA accepts. Get the chain wrong once and the fixes cost more than the bookkeeping. Here is the complete 2026 workflow.
TL;DR
- Shopify reports show gross sales — UAE VAT books need net sales plus 5% output VAT.
- Reconcile every Shopify payout to its bank line before you code anything.
- Fees, shipping and refunds change VAT, and most DIY setups miss all three.
- Keep 5 years of records and 7 years of accounting books under Cabinet Decision 52/2017.
- When volume makes this a weekly chore, Finanshels runs the workflow for you.
Why this matters for Shopify sellers in the UAE
A Shopify store is a VAT machine with the paperwork turned off. The platform collects money, remits payouts and prints receipts, but it does not file anything with the Federal Tax Authority. You do. Under Article 48 of Federal Decree-Law No. 8 of 2017 every taxable person keeps accounting books for 5 years, and Article 51(8) extends tax records to 5 years from the end of the tax period to which they relate; Cabinet Decision No. 52 of 2017 adds 7 years for accounting books. (Federal Decree-Law 8/2017, uaelegislation.gov.ae; Cabinet Decision 52/2017, tax.gov.ae)
That record-keeping obligation only bites if the workflow behind it is clean. A store doing AED 500,000 a year on Shopify runs hundreds of orders through a dozen fee types, and each one changes the VAT figure. The workflow below takes roughly 30 minutes a week for a store at that size — and less time than one FTA audit finding.
Step 1: export Shopify data the right way
Every Monday (or daily in high season), export three reports from Shopify admin:
- Sales by product report — gross sales, discounts, returns.
- Payouts report — what actually hit the bank, net of fees.
- Tax report — VAT collected by rate and jurisdiction.
Use the date range that matches your payout cycle, not the calendar month. Shopify reports on order date; your bank account moves money on payout date. Books that mix the two will never reconcile.
Step 2: reconcile payouts to the bank before coding anything
Open the payouts report, then the bank feed. For each payout line:
- Match the payout amount to the bank transaction.
- Note the gross sales, fees and refunds that built that payout.
- Code the payout as a single cleared batch, not as individual orders.
This is the step DIY sellers skip, and it is the reason their VAT return never ties to their bank statement. The FTA does not ask what Shopify said; it asks what your books say and whether the bank agrees.
Step 3: split VAT out of every sale
UAE Shopify sellers charge 5% VAT on domestic sales. The platform shows gross amounts. Your books need both:
- Net revenue — the sale without VAT.
- Output VAT — 5% of domestic sales, owed to the FTA.
Zero-rated and out-of-scope sales (most exports) carry 0%, but they still belong in the books as revenue, not as a blank. Export sales with evidence of export keep the 0% treatment under Article 45 of the VAT law. Domestic sales without a valid VAT invoice still owe the 5%.
Step 4: tag expenses with recoverable input tax
Every Shopify fee, every ad spend, every shipping label is a potential input VAT recovery — if the tax invoice is valid. Tag each expense category with its VAT treatment:
- Marketing and app subscriptions — usually 5% recoverable.
- Shipping and fulfilment — 5% when the supplier is UAE-based.
- International tooling (US SaaS) — often no UAE VAT, nothing to recover.
Input tax follows the tax invoice under Article 59 of Federal Decree-Law 8/2017, not the platform's fee summary. No valid invoice, no recovery.
Step 5: build the return and file on EmaraTax
The VAT return (Form VAT201) pulls four numbers from your books: standard-rated supplies, zero-rated supplies, output VAT, recoverable input VAT. File through the FTA's EmaraTax portal by the 28th of the month after each tax period. Late filing costs AED 1,000 the first time, AED 2,000 for every repeat under Cabinet Decision 52/2017.
Before you hit submit, run the tie-out check: output VAT on the return equals output VAT in your books for the period, and net VAT paid equals the bank movement. Two numbers, five minutes, one audit saved.
What this looks like at volume
| Workflow stage | Manual (weekly) | Automated / outsourced |
|---|---|---|
| Shopify export | 20 min, error-prone | Scheduled import |
| Payout reconciliation | 30–60 min per week | Matched to bank feed automatically |
| VAT split per sale | Manual formula risk | Computed per order |
| Input VAT tagging | Memory and guesswork | Rule-based coding |
| Return filing | Quarterly scramble | Filed by the accountant |
At one or two payout cycles a week, the manual path holds. Past that it stops being bookkeeping and becomes a part-time job with penalty risk attached. Finanshels runs exactly this workflow for UAE Shopify sellers — export to filed return, with an FTA-ready audit trail behind every figure — as part of its VAT registration and filing and accounting and bookkeeping services.
FAQ
Does Shopify handle UAE VAT filing for me?
No. Shopify calculates and collects VAT on domestic sales, but the seller files the VAT return with the FTA. The platform's tax report is an input to your books, not a filing.
How long do I need to keep Shopify records for UAE VAT?
Five years for tax records under the VAT law, and seven years for accounting books under Cabinet Decision 52/2017. Export archives count — keep them alongside bank statements.
What happens if my Shopify books do not reconcile to my bank?
The FTA can disallow input VAT and assess output VAT on figures that cannot be evidenced. Fix the reconciliation before filing, not after an audit notice.
Can I recover the VAT on Shopify fees and apps?
Yes, when the supplier issues a valid UAE tax invoice showing 5% VAT. US-based SaaS tools often charge no UAE VAT, so there is nothing to recover on those.
How often should I do this workflow?
Weekly for stores with weekly payouts. Monthly is the minimum anyone should accept, because reconciling sixty payouts in one sitting is where errors hide.
One last thing
The most expensive mistake in this workflow is not a wrong rate — it is coding a Shopify payout as pure revenue. That one entry double-counts VAT, inflates revenue, and shows up in the FTA's risk scoring as a store that collected tax and never paid it. Reconcile payouts as batches, and the rest of the chain stays honest.
