Accountio / Templates / UAE Corporate Tax / Corporate tax calculation

UAE corporate tax calculation template in Excel

Take a UAE resident company from its accounting profit to taxable income and the corporate tax payable, with the interest limit, loss relief and the due date worked out for you. This UAE corporate tax calculation template is one Excel workbook with the computation, article by article, and a short guide.

Middle East and Africa
$19
In the pack
UAE Corporate Tax pack
Files
5, Word and Excel
Buy the pack · $19
Global library · 110 packs

Get this pack and 109 more for $99

UAE Corporate Tax · this packAML complianceCharity accountsEstate administrationMTD for Income TaxP11D and payrollingUK SRS readinessReference lettersCarbon reduction plan+ 101 more

What the workbook looks like

Corporate tax calculation template
What the workbook coversSection or row in the workbook
The company and the period
✓
Company, Tax period, Tax period end dateThe details the due date is worked out from
Small Business Relief
✓
Small Business Relief elected for this period?Yes sets taxable income to nil for the period
Accounting profit
✓
A. Accounting profitNet profit or loss before tax in the standalone financial statements
Exempt income
✓
B. Less exempt income and unrealised itemsUAE dividends, participating interests, exempt foreign permanent establishments and unrealised gains or losses under the realisation election
Non-deductible items
✓
C. Add back non-deductible itemsFines, donations, bribes, distributions, corporate tax, recoverable VAT, foreign tax, costs not wholly for the business, and connected person and transfer pricing adjustments
Entertainment
✓
Entertainment added back: 50%Half of entertainment for customers, shareholders, suppliers and business partners
The interest limit
✓
D. Interest limitation (Art 30)Tax EBITDA, net interest allowed and interest disallowed to carry forward
Tax losses
✓
E. Tax losses (Arts 37 and 39)Losses used up to 75% of taxable income, and losses carried forward
Tax and due date
✓
F. Corporate taxTaxable income, the 0% and 9% bands, tax payable and the return and payment date
Missing entries flagged
✓
ChecksA missing period end, an unanswered relief question or a negative entertainment figure
Guide
✓
How to useThe steps by article, the rate, the deadline and a note on free zone companies

When you need it

UAE corporate tax applies to financial years starting on or after 1 June 2023. Taxable income starts from accounting income, the net profit or loss before tax, adjusted for exempt income and non-deductible items. Taxable income up to AED 375,000 is taxed at 0% and the rest at 9%, and the return and the tax are both due within 9 months of the end of the tax period. Use the workbook when:

  • You are preparing a UAE company's corporate tax return
  • You need the tax charge for the year-end accounts
  • Net interest is above AED 12 million and the interest limit may apply
  • The company has tax losses brought forward
  • You are deciding whether to elect Small Business Relief for the period

How to use the UAE corporate tax calculation template

  1. Enter the company and the period. Overwrite the [Example] figures, then enter the tax period end date. The due date fills in nine months later.
  2. Start from accounting profit. Enter the net profit or loss before tax from the standalone financial statements, then the exempt income and any unrealised items.
  3. Add back the non-deductible items. Fill in each line that applies and the total entertainment spend. The sheet adds back half of it.
  4. Enter interest and losses. Net interest, depreciation and amortisation, and tax losses brought forward. The sheet applies the interest limit and the 75% cap.
  5. Read the tax and clear the checks. Corporate tax payable and the due date show in section F. Clear every message under Checks before you file.

Questions

What is the UAE corporate tax rate?

0% on taxable income up to AED 375,000 and 9% on taxable income above that. A Qualifying Free Zone Person pays 0% on its qualifying income.

When is the UAE corporate tax return due?

Within 9 months of the end of the tax period, and the tax is due by the same date. For a year ending 31 December, that is 30 September.

How does the UAE interest limit work?

Net interest expenditure up to AED 12 million is deductible in full. Above that, the deductible amount is the greater of 30% of adjusted EBITDA and AED 12 million. Interest disallowed can be carried forward for 10 tax periods.

How much of a tax loss can be used in one year?

Up to 75% of taxable income for the period before loss relief. The rest of the loss carries forward.

How much entertainment is deductible?

50% of entertainment, amusement and recreation spend on customers, shareholders, suppliers and other business partners.

Who can elect Small Business Relief?

A resident person whose revenue is AED 3 million or less in the tax period and every earlier period. The threshold applies to tax periods ending on or before 31 December 2029. The pack's Small Business Relief test checks it.

Also in the UAE Corporate Tax pack

Small business relief testFree zone qualifying income testTransfer pricing disclosure workbook

See the whole pack →

Who it's for

Finance teams of UAE mainland and free zone companies, and practices that prepare corporate tax returns.

Last checked

Checked against Federal Decree-Law No. 47 of 2022 as amended, Cabinet Decision No. 116 of 2022, the Small Business Relief decisions and the Federal Tax Authority's interest deduction guide in November 2026.