Accounting reports
On this page
Accounting - United Arab Emirates builds every report from your posted journal entries. Drafts are never included. Open the Reports tab and pick a report from the row at the top.
Available reports#
| Report | What it shows |
|---|---|
| Trial balance | Each account with its opening balance, debits, credits and closing balance for a period. |
| General ledger | Every posted line on one account, with a running balance. |
| Profit and loss | Revenue, cost of revenue and expenses for a period, with gross, operating and net profit. |
| Balance sheet | Assets, liabilities and equity on a date. |
| VAT return (UAE VAT201) | The boxes of the FTA VAT return for a period. |
| Corporate tax (UAE) | A working estimate of UAE corporate tax for a financial year, from accounting profit to tax payable. |
| Aged receivables | What customers owe, by how overdue it is. |
| Aged payables | What you owe suppliers, by how overdue it is. |
| Stock valuation | The value of the stock on hand on a date, product by product. |
Trial balance#
Pick the period with From and To. The report lists each account with Code, Account, Opening, Debit, Credit and Closing, and shows Balanced when total debits equal total credits.
General ledger#
Pick an account and a period. You see the Opening balance, then each line with its Date, Entry, Reference, Label, Debit, Credit and Balance, and the totals.
Profit and loss#
Pick the period. The report groups accounts under revenue, cost of revenue, operating expenses, depreciation and other income and expenses, then shows Gross profit, Operating profit and Net profit.
Tick Compare with to add a Comparison column for an earlier period.
Balance sheet#
Pick the As of date. The report shows Assets, Liabilities and Equity, with Total assets and Total liabilities and equity. Profit not yet closed shows under Current year earnings.
Set a Comparison date to add a comparison column.
VAT return#
The VAT return (UAE VAT201) report fills the boxes of the FTA VAT return from the VAT on your posted invoices, bills and entries.
- Open AccountingReportsVAT return (UAE VAT201).
- Click a quarter button, or set From and To. If your fiscal year does not end with a calendar quarter, fiscal quarters are offered too.
- Read each Box with its Amount and VAT amount. Box 14 is the payable tax for the period.
- Click EmaraTax worksheet to download an Excel file laid out box by box, with your TRN and the tax period, rounded to fils. Each row says whether you type it into EmaraTax, whether the FTA pre-fills it (boxes 2 and 6) or whether EmaraTax calculates it (boxes 8 and 11 to 14).
- Use the figures to file your return on EmaraTax. Enter any adjustments for boxes 1 and 9 (such as bad debt relief) and answer box 15 (refund request) there.
- When the return is filed, click Close VAT period.
Corporate tax#
The Corporate tax (UAE) report starts from the accounting profit of the period and applies the main adjustments of Federal Decree-Law No. 47 of 2022:
| Line | Rule |
|---|---|
| Add: 50% of entertainment | Half of the expense on accounts set to Entertainment is not deductible (Article 32). |
| Add: expenses that are not deductible | Accounts set to Not deductible, such as fines, donations to bodies that are not Qualifying Public Benefit Entities and corporate tax itself (Article 33). |
| Less: exempt income | Accounts set to Exempt income, such as qualifying dividends (Articles 22 and 23). |
| Add: interest above the limit | Net interest above the higher of AED 12 million and 30% of tax EBITDA (Article 30, Ministerial Decision No. 126 of 2023). |
| Less: tax losses used | Up to 75% of taxable income, from the amount you type in Tax losses brought forward (Article 37). |
| Taxed at 0% and 9% | 0% on the first AED 375,000 of taxable income and 9% above it (Cabinet Decision No. 116 of 2022). |
- Open AccountingReportsCorporate tax (UAE). The period starts on your last closed financial year.
- Type your Tax losses brought forward (AED) if you have any.
- Tick Elect Small Business Relief if you elect it on your return. It applies when revenue is AED 3,000,000 or less and the period is from June 2023 to December 2029 (Ministerial Decision No. 73 of 2023, extended by Ministerial Decision No. 131 of 2026). Qualifying Free Zone Persons and members of multinational groups cannot elect it.
- Print it or export it to Excel, CSV or PDF.
Each account has a Corporate tax treatment in AccountingConfigurationChart of accounts. The UAE chart sets Bar & Restaurant to Entertainment, Gifts & Donations and Income Tax to Not deductible, Bank Finance & Loan Charges to Interest expense and Interest Revenue to Interest income. Change them to match your business.
All stores#
Each store keeps its own books: its own chart of accounts, journals, entry numbers, taxes, lock dates and opening balances. Nothing is shared between stores. Company owners and admins can still see the books side by side.
- Open AccountingReports.
- In Books of, pick All stores, or one of your other stores with Accounting switched on.
- Pick Profit and loss, Balance sheet, Trial balance or Corporate tax (UAE).
The report has one column per store and a Total column. Accounts with the same code and name are added up on one line. When stores keep their books in different currencies, amounts are never converted: you get a total column for each currency instead, for example Total AED and Total USD.
In the combined corporate tax report, store columns show each store before Small Business Relief and tax losses, and the total applies them and the AED 375,000 band once for the company.
Aged receivables and payables#
Pick the As of date. Each customer or supplier is listed with the amount Not due and the amounts 1-30, 31-60, 61-90, 91-120 days overdue and Older, plus a Total.
Stock valuation#
Pick the date in Value on. The report lists each product and variant with its SKU, Category, Costing method, On hand, Unit cost and Value, and the Total stock value.
Under Check against the books, Kartlo compares the Stock value from valuation layers with the Stock accounts in the books and shows any Difference.
Click a product to see its valuation layers. See Inventory costing.
Print and export#
Most reports have an export menu to download the report as Excel, CSV or PDF, with the period in the file. The profit and loss, balance sheet, VAT return, corporate tax and all-stores reports also have Print or save as PDF.