Skip to content

Free download

UAE financial statement template — balance sheet, profit and loss and cash flow in one Excel file

Built for a company licensed in the UAE, not adapted from an American one. Formulas are already wired, the end-of-service provision is a standard line, and every legal requirement quoted inside cites the instrument and the date it was checked.

Where should we send it?

One field. The workbook downloads straight away and we email you a copy of the link so you can find it again.

We use it to send the file and, occasionally, something genuinely useful about UAE filing deadlines. No sales sequence.

You also get the companion guide — seven pages on which standard applies to you, what each line means, what an auditor asks for first, and how long you have to keep the file.

What is inside

Five tabs, and a reason for each of them

Start here

Two questions — revenue for the year, and whether you hold a free zone licence. Those answers decide which standard you report under and whether an audit applies at all.

Balance sheet

Non-current and current assets, equity, non-current and current liabilities. Carries the end-of-service provision, VAT payable and corporate tax payable as standard lines. Balance check at the foot.

Profit & loss

Revenue through to profit for the year, with gross profit, operating profit and profit before tax subtotalling themselves. Costs are entered as negatives so a mistyped sign shows up immediately.

Cash flow

Indirect method — operating, investing and financing, closing to cash at the end of the year. If it does not agree with the balance sheet, the difference is almost always a sign error.

Notes

The eight notes a UAE set of accounts is expected to carry, including related-party transactions — the note auditors query most and the one most often left blank.

Before you start

Three things that decide how your statements should look

Which standard applies to you

Article 4 of Ministerial Decision No. 114 of 2023 requires a taxable person to apply IFRS, and permits IFRS for SMEs where revenue does not exceed AED 50,000,000. Article 2 allows the cash basis below AED 3,000,000. That is why the workbook asks for your revenue before anything else — the answer changes what you are expected to produce. Checked 6 August 2026.

Whether an audit is required

Ministerial Decision No. 84 of 2025 requires audited financial statements where revenue exceeds AED 50,000,000 in the tax period, and for every Qualifying Free Zone Person regardless of revenue, for tax periods commencing on or after 1 January 2025. Free zones and lenders frequently ask beyond that, so confirm your own position rather than assuming the federal position is the whole of it. Checked 6 August 2026.

How long you keep it afterwards

Article 56 of Federal Decree-Law No. 47 of 2022 requires records to be kept for seven years after the end of the tax period. VAT records run to five years, and records relating to real estate to fifteen years under Article 71(2) of the VAT Executive Regulation. Keep the workbook and the documents behind it, not only the printed statements. Checked 6 August 2026.

What this workbook is not. It is a preparation aid. Velmont Crest Accounting provides accounting and bookkeeping support and does not act as a registered tax agent or a licensed auditor. The UAE legal requirements quoted inside are cited to the instrument and the date checked. The arrangement of the statements follows ordinary IFRS presentation convention — a sound starting point, not a certification that your finished accounts comply with any standard. Your auditor decides that.

Questions

What people ask before downloading

What is a financial statement template and what does this one include?

It is a pre-structured workbook you enter your own figures into. This one holds five tabs: a start page that asks your revenue and whether you hold a free zone licence, then a balance sheet, a profit and loss statement, a cash flow statement and a notes checklist. Totals are formulas, so they recalculate as you type, and a balance check flags the moment assets stop agreeing with equity and liabilities.

Which accounting standard should a UAE company use?

Article 4 of Ministerial Decision No. 114 of 2023 requires a taxable person to apply IFRS. A taxable person deriving revenue that does not exceed AED 50,000,000 may instead apply IFRS for SMEs. Article 2 of the same decision permits the cash basis below AED 3,000,000. The start tab of the workbook asks for your revenue for that reason. Checked 6 August 2026.

Why do most balance sheet templates not work for a UAE company?

Most of what is available online is American. It uses headings a UAE reader does not recognise, it says nothing about which standard applies to you, and it omits the provision for employees' end of service benefits entirely. That provision is a liability for a UAE employer under Federal Decree-Law No. 33 of 2021, and in practice it is the line an auditor asks about first. It is a standard line in this workbook.

Does my company need audited financial statements?

Ministerial Decision No. 84 of 2025 requires audited financial statements where a taxable person that is not a tax group derives revenue exceeding AED 50,000,000 in the tax period, and for every Qualifying Free Zone Person whatever its revenue. It applies to tax periods commencing on or after 1 January 2025. Separately, your free zone or your bank may ask for audited accounts as a condition of licence renewal or facility review, so confirm your own position. Checked 6 August 2026.

How long do I have to keep the finished statements?

Article 56 of Federal Decree-Law No. 47 of 2022 requires a taxable person to maintain all records and documents for seven years following the end of the tax period they relate to. VAT records run to five years, and records relating to real estate to fifteen years under Article 71(2) of the VAT Executive Regulation. Keep the workbook and the documents behind it, not just the printed statements. Checked 6 August 2026.

Can I use this workbook for my corporate tax return?

It helps you get there, but it is not the return. Corporate tax is charged at 0% on the portion of taxable income not exceeding AED 375,000 and 9% above that, under Cabinet Decision No. 116 of 2022. Taxable income is not the same figure as accounting profit — it starts from it and then applies the adjustments, exemptions and reliefs in the Corporate Tax Law. The workbook gives you the accounting profit reliably; the adjustments are a separate exercise.

Is the workbook locked?

Only the totals. Every input cell, label and note is editable, and the formula cells are protected so a number typed over a SUM cannot silently break the statement. The protection carries no password, so if you want to restructure a sheet you can unprotect it in two clicks. It is there to stop accidents, not to lock you out.

Is this an audit, or accounting advice?

Neither. It is a preparation aid. Velmont Crest Accounting provides accounting and bookkeeping support and does not act as a registered tax agent or a licensed auditor. The UAE legal requirements quoted in the workbook are cited to the instrument and the date checked. The arrangement of the statements follows ordinary IFRS presentation convention and is a sound starting point, not a certification that your finished statements comply with any standard — your auditor decides that.

Velmont Crest accounting advisor — Dubai SME engagement

Book a consultation

Free 30-minute call. Pressure-free.

Reply within 1 UAE business day · Data stored in UAE · Not shared