Module 14: Reports & Financial Analytics¶
The Reports module (/reports) delivers financial accounting statements, statutory tax return reports, and multi-dimensional operational analytics.
🎯 Key Reports Directory¶
1. Financial Statements¶
- Profit & Loss (P&L):
- Operating Income, Cost of Goods Sold (COGS), Gross Profit, Operating Expenses, and Net Profit.
- Comparative period options (Month-over-Month, Quarter-over-Quarter, Year-over-Year).
- Balance Sheet:
- Assets (Current & Non-Current), Liabilities (Current & Long-Term), and Equity.
- Verifies equation:
Assets = Liabilities + Equity. - Trial Balance:
- List of all GL accounts with opening balances, debit movements, credit movements, and closing balances.
2. UAE Tax & Statutory Reports¶
- UAE VAT Return (FTA VAT201 Format):
- Box 1 (Standard Rated Supplies): Taxable sales in Dubai, Abu Dhabi, and Northern Emirates @ 5% VAT.
- Box 2 (Zero-Rated Supplies): Exports and zero-rated sales.
- Box 3 (Exempt Supplies): Financial and exempt revenue.
- Box 9 (Standard Rated Expenses): Purchases & Input VAT recoverable @ 5%.
- Box 12 (Net VAT Payable / Reclaimable):
Output VAT (Box 8) - Input VAT (Box 11).
3. Operational & Commercial Analytics¶
- Sales Analysis: Breakdown by Customer, Salesperson, Product Category, or Region.
- Purchase Analysis: Procurement spend by Vendor and Expense Category.
- Inventory Valuation: Current stock valuation on hand calculated via moving average costing.
💡 Step-by-Step Instructions¶
Generating the UAE VAT 201 Tax Return¶
- Open Reports → VAT Return Report (
/reports). - Select tax period (e.g. Q1 2026: Jan 1 - Mar 31).
- Click Generate Report.
- Review Box 1 (Standard Rated Sales) and Box 9 (Standard Rated Purchases).
- Click Export to Excel or Download PDF to use for filing your return on the EmaraTax FTA portal!