Moving QuickBooks data into UAE tax-ready books is a mapping exercise before it is a migration: export the chart of accounts, open items, customers, vendors and balances, re-map them to IFRS and UAE corporate tax requirements, align VAT return periods, and lock a 7-year record archive. Do it in that order and the first return filed from the new books reconciles to the old ledger without surprises.
Export the right things first
A migration that starts with the trial balance usually has to start again. Export in this order: (1) the chart of accounts with balances, (2) open invoices and bills with dates, (3) customer and vendor masters, (4) fixed-asset register with depreciation, (5) historical transactions for the periods still inside the record-keeping window, and (6) the closing trial balance for the cut-over date.
Re-map for IFRS and corporate tax
The UAE requires financial statements prepared under IFRS — or IFRS for SMEs where revenue is AED 50 million or less — so the imported chart of accounts must support the disclosures tax returns and audits ask for: revenue by stream, related-party balances, qualifying income categories for free zone entities, and deductible versus non-deductible expense buckets. A US-style QuickBooks chart rarely maps one-to-one; plan a mapping table before import, not after.
Align the tax calendar to the new books
- VAT return periods continue on their existing quarters — the migrated opening position must reconcile to the last filed return, line by line.
- Corporate tax period follows the financial year; opening balances must tie to the prior-year taxable income computation.
- Accounting basis: revenue up to AED 3 million may use the cash basis (Ministerial Decision No. 114 of 2023); above it, accrual IFRS applies.
- Record retention: corporate tax records are kept 7 years from the end of the tax period and VAT records 5 years — the migrated archive must be complete from day one, because a partial history cannot be back-filled later.
E-invoicing changes the destination
Under Ministerial Decision No. 244 of 2025 as amended by Ministerial Resolution No. 66 of 2026, businesses with revenue of AED 50 million or more appoint an accredited service provider by 30 October 2026 and issue e-invoices from 1 January 2027; smaller businesses follow by 31 March 2027 / 1 July 2027. Migrate into a system that can connect to an accredited service provider, or plan a second migration within months.
The migration checklist
| Step | What moves | Why it matters for tax |
|---|---|---|
| 1. Chart of accounts mapping | Old COA → IFRS/CT-aligned COA | Supports return disclosures and audit |
| 2. Open items | Open invoices, bills, credits | VAT and CT timing in the first period |
| 3. Masters | Customers, vendors, TRNs | Valid tax invoices; input VAT recovery |
| 4. Fixed assets | Register + accumulated depreciation | CT cost basis and depreciation policy |
| 5. History | Prior-period transactions | 7-year retention; audit defence |
| 6. Cut-over trial balance | Closing balances, tied to last filed VAT/CT | First-period reconciliation |
Frequently asked questions
Can I migrate mid-year or should I wait for year-end? Mid-year works if the cut-over trial balance ties to the last filed VAT return; year-end is cleaner but leaves tax work running on the old ledger.
Do I lose VAT history in a migration? No — VAT records are part of the 5-year retention obligation, so the historical transactions and returns move with the archive.
Should the chart of accounts change during migration? Yes, if the old one cannot produce IFRS statements or the disclosures the corporate tax return needs — mapping once is cheaper than remapping under audit pressure.
What proves the migration worked? A cut-over trial balance that agrees to the prior ledger to the dirham, and a first VAT return that reconciles to the migrated opening position.
Planning a migration before the e-invoicing deadline? Finanshels' bookkeeping team runs QuickBooks-to-UAE migrations with a mapped chart of accounts and a tie-out certificate.
Finanshels is an FTA Registered Tax Agency and is not affiliated with the FTA.
