QuickBooks Setup for UAE Businesses
How to configure company settings, VAT, chart of accounts, bank feeds, invoicing, and monthly processes the right way
Quick Summary: A good QuickBooks setup for a UAE business starts with the right company file, VAT and TRN details, a chart of accounts that matches how you earn and spend, and bank feeds that are reconciled every month. Mistakes made in the first week, such as wrong VAT codes, a messy opening balance, or a copied foreign chart of accounts, tend to follow you for years. This guide walks through the setup step by step, with a checklist and the errors to avoid.
QuickBooks is one of the most widely used accounting tools by small and medium UAE businesses, from consultants and trading companies to online stores and service firms. It is flexible and fast to start, which is both its strength and its risk: you can be invoicing in an hour, but a rushed setup can leave you with wrong VAT, inconsistent categories, and reports you cannot trust.
UAE businesses have specific needs: 5% VAT with a Tax Registration Number (TRN), Arabic and English invoice requirements for tax invoices, AED as the base currency with foreign currency transactions, Corporate Tax records, and audit expectations. A QuickBooks file set up without these in mind often needs to be cleaned up before the first VAT return.
Below we explain how to set up QuickBooks for a UAE business properly, whether you are starting fresh or migrating from spreadsheets or another system. Our accounting and bookkeeping services team does QuickBooks setup, clean-up, and ongoing bookkeeping for UAE companies.
Want QuickBooks set up correctly for UAE VAT and Corporate Tax from day one? Talk to our team.
Table of Contents
- Before You Start: Choose the Right Version and Plan
- Step-by-Step QuickBooks Setup for the UAE
- Company Information and Base Settings
- VAT Setup: TRN, Tax Codes and Invoices
- Chart of Accounts Design
- Opening Balances and Migration
- Bank Feeds and Reconciliation
- Customers, Suppliers, Products and Invoicing
- Corporate Tax, E-invoicing and Audit Readiness
- Monthly Routine After Setup
- Common Setup Mistakes
- Frequently Asked Questions
1. Before You Start: Choose the Right Version and Plan
- Check that the QuickBooks version you choose supports UAE VAT, TRN, AED, and the tax invoice format you need
- Choose a plan based on users, number of bank accounts, inventory needs, and reporting requirements
- Decide who will have access: owner, bookkeeper, accountant, and any staff who issue invoices
- Decide whether you need inventory, project, or class tracking, since these affect setup
- Gather your documents: trade licence, TRN certificate, bank details, opening trial balance, and customer and supplier lists
Please verify before relying on this: QuickBooks regional versions, plan names, features, and pricing change from time to time. Confirm what your plan supports for UAE VAT and invoicing on the QuickBooks website or with an accountant before you subscribe.
2. Step-by-Step QuickBooks Setup for the UAE
Step 1: Create the company file
Enter the legal name, address, and contact details exactly as on the trade licence, and set the country to the UAE.
Step 2: Set base currency and financial year
Use AED as the home currency and set the financial year start to match your accounts and licence.
Step 3: Configure VAT and TRN
Turn on VAT, enter the TRN, choose the filing frequency, and set up tax codes.
Step 4: Build the chart of accounts
Customise the default chart to fit your business and reporting.
Step 5: Load opening balances
Enter the opening trial balance, customer and supplier balances, and inventory.
Step 6: Connect bank accounts
Link bank and card accounts, set rules, and reconcile to the start date.
Step 7: Set up customers, suppliers and products
Import lists, set payment terms, tax defaults, and invoice templates.
Step 8: Test and train
Run test transactions, check reports, and train users before going live.
3. Company Information and Base Settings
| Setting | What to enter |
|---|---|
| Legal and trade name | As shown on the trade licence |
| Address and contact | Registered address and business contact details used on invoices |
| Home currency | AED |
| Financial year | Matches your accounting period and licence requirements |
| Accounting method | Accrual basis, in line with IFRS |
| Foreign currency | Enable if you buy or sell in USD, EUR, or other currencies |
| Users and roles | Limit access based on job role |
4. VAT Setup: TRN, Tax Codes and Invoices
🔢 TRN
Enter your Tax Registration Number so it shows on tax invoices and credit notes.
🏷️ Tax Codes
Set up standard-rated, zero-rated, exempt, out-of-scope, and reverse charge codes as needed.
🧾 Invoice Template
Make sure tax invoices include the fields required under UAE VAT rules.
📅 Filing Period
Match the VAT period to what the FTA assigned to you.
- Assign a default tax code to each product, service, and expense account where possible
- Use separate codes for zero-rated exports and for imports with reverse charge
- Check that credit notes carry the same VAT treatment as the original invoice
- Run a test VAT report and compare it with a manual calculation before the first return
Please verify before relying on this: Required fields on tax invoices and credit notes, and e-invoicing requirements, are set by the Federal Tax Authority and are changing. Check the current rules and timelines before finalising your invoice template. Our tax services team can confirm what applies to you.
5. Chart of Accounts Design
Good chart of accounts
- Reflects how your business earns and spends
- Separates revenue streams and key costs
- Uses clearing accounts for gateways, COD, and payroll
- Supports VAT and Corporate Tax reporting
- Stays simple enough to maintain
Poor chart of accounts
- Copied from another country's template
- Hundreds of unused accounts
- One "sales" and one "expenses" account for everything
- No clear place for owner transactions or loans
- Hard to reconcile to audit and tax figures
| Business type | Typical additions |
|---|---|
| Trading and retail | Inventory, cost of goods sold by category, freight and duty, shrinkage |
| Services and consulting | Revenue by service line, work in progress, subcontractors |
| E-commerce | Revenue by channel, marketplace fees, gateway and COD clearing; see our guide to bookkeeping for e-commerce businesses |
| Freight and logistics | Job-based revenue and costs, disbursements, agent balances; see bookkeeping for freight forwarding businesses |
| Construction and contracting | Contract revenue, retention, work in progress; see bookkeeping for the construction industry |
Want a chart of accounts designed for your business and UAE reporting? Our team can build it with you.
6. Opening Balances and Migration
- Choose a clean start date, ideally the start of a month or financial year
- Enter an opening trial balance that agrees to your last closed accounts or audited figures
- Load unpaid customer invoices and supplier bills individually, not as a single total, so ageing works
- Enter inventory quantities and values at the start date, supported by a stock count
- Bring in fixed assets with cost and accumulated depreciation
- Reconcile bank accounts to the statement balance at the start date
- Keep a copy of the old records and a migration reconciliation for your auditor
7. Bank Feeds and Reconciliation
- Connect each bank and card account, or upload statements if a live feed is not available for your bank
- Create rules for recurring items such as rent, payroll, and bank charges
- Reconcile every account monthly, and weekly for high-volume businesses
- Use clearing accounts for payment gateways, marketplaces, and COD, and clear them as payouts arrive
- Never force a reconciliation difference into an expense account without investigating
8. Customers, Suppliers, Products and Invoicing
| Area | Setup tips |
|---|---|
| Customers | Record legal name, TRN where applicable, address, payment terms, and default tax code |
| Suppliers | Record TRN, payment terms, and default expense account and VAT code |
| Products and services | Set income account, tax code, and, for stock items, cost and quantity tracking |
| Invoice template | Include the details required for a tax invoice and your branding |
| Payment terms and reminders | Set standard terms and automated reminders to speed up collection |
9. Corporate Tax, E-invoicing and Audit Readiness
- Keep accounts on an accrual basis, in line with IFRS, so Corporate Tax computations start from reliable numbers
- Separate non-deductible items, owner and related-party transactions, and dividends in the chart of accounts
- Retain invoices, contracts, and bank records for the legally required period
- Check that your invoicing set-up can follow UAE e-invoicing requirements as they apply to your business
- Keep an audit trail: avoid deleting transactions, and lock closed periods
- Prepare supporting schedules for your auditor, such as bank reconciliations, ageing, and fixed assets
Please verify before relying on this: UAE e-invoicing rollout dates, scope, and technical requirements have been announced in phases and may change. Confirm the current timeline for your business, and whether QuickBooks or an add-on will support it, before relying on any date. See also our audit and assurance services.
An organised file also makes audits faster; see our guides to the retail business audit services, e-commerce fulfillment audit, and e-commerce platform financial audit.
10. Monthly Routine After Setup
Categorise transactions
Review bank feed items and apply rules and VAT codes.
Reconcile accounts
Reconcile all banks, cards, and clearing accounts.
Review receivables and payables
Check ageing, chase customers, and schedule supplier payments.
Post adjustments
Accruals, prepayments, depreciation, and payroll entries.
Check VAT
Run the VAT report and review exceptions before filing.
Close and report
Lock the period and review profit and loss, balance sheet, and cash.
11. Common Setup Mistakes
- Not entering the TRN or tax codes correctly before issuing invoices
- Using a default chart of accounts built for another country
- Loading opening balances as lump sums instead of invoice-level detail
- Letting bank feed transactions auto-categorise without review
- Ignoring foreign currency settings, so exchange differences are mixed into other accounts
- Giving every user full access to the file
- Leaving the file without monthly reconciliation until VAT or audit time
If you are still forming the company, our business setup team, the guide to launching a business without visiting Dubai, and the document preparation checklist for business setup will help you collect the records you need before opening the QuickBooks file.
Frequently Asked Questions
Can QuickBooks be used for UAE VAT?
Yes, QuickBooks can be set up for UAE VAT with your TRN, tax codes, and VAT reports, but you should confirm that your plan and version support UAE VAT and the tax invoice details you need, and check the VAT report against your records before filing.
How do I set up QuickBooks for a new UAE company?
Create the company file with your licence details, set AED as the home currency, enable VAT with your TRN, build a suitable chart of accounts, load opening balances, connect your bank accounts, and set up customers, suppliers, and products before issuing invoices.
What chart of accounts should I use in QuickBooks for the UAE?
Use a chart that reflects your business model, with separate revenue and cost accounts, clearing accounts for gateways and COD, and clear places for VAT, owner, and related-party transactions. Avoid copying a template built for another country.
Can I move from Excel or another system to QuickBooks mid-year?
Yes. Choose a clean cut-off date, enter an opening trial balance that agrees to your last closed accounts, load open invoices and bills individually, reconcile your bank accounts to the start date, and keep a migration reconciliation for your auditor.
Is QuickBooks enough for Corporate Tax and audit in the UAE?
QuickBooks can support Corporate Tax and audit if it is set up and maintained properly on an accrual basis with reconciled accounts and good records. The software does not guarantee compliance, so keep supporting documents and get professional review.
Ready for a clean QuickBooks setup that is VAT-ready and audit-ready? Let's get it done properly.
