Consolidated Tax Report

Overview

The Consolidated Tax Report in DIGITZ ERP provides a complete summary of Input VAT, Output VAT, and the net VAT payable or refundable for a selected period.
It combines all tax movements from purchases, sales, expenses, returns, and adjustments into a single UAE-compliant structure.

This report also supports Emirate-wise VAT segmentation, aligning with the requirements of the UAE Federal Tax Authority (FTA) VAT return format.
It acts as the final reference point before submitting VAT to the FTA Portal.

---

Purpose

The purpose of the Consolidated Tax Report is to:

• Present a unified, period-wise summary of Input and Output VAT.
• Provide a UAE VAT compliant format including Emirate-wise VAT breakdown.
• Show the net VAT position (Payable or Refundable).
• Support tax reconciliation and filing accuracy.
• Enable auditors and finance teams to validate tax numbers at a consolidated level.
• Ensure transparency across all tax-impacting transactions.

---

How It Works

The Consolidated Tax Report automatically compiles VAT values from:

• Input Tax Report (Purchase Invoice, Expense Entry, etc.)
• Output Tax Report (Sales Invoice, Service Invoice, etc.)
• VAT Adjustments
• Returns and reversals (Sales Returns, Purchase Returns)
• Tax Ledger movements

The system processes the following:

1. Gathers all taxable transactions within the selected date range.
2. Aggregates taxable amounts and VAT amounts from all inward and outward supplies.
3. Categorises the data by VAT type (Input/Output).
4. Applies Emirate-wise classification using customer/supplier branch or address.
5. Computes net VAT liability.
6. Presents a consolidated and FTA-friendly summary.

---

Key Fields Displayed

The Consolidated Tax Report includes:

Input Tax Section

• Total Taxable Purchases
• Total Input VAT
• Adjustments related to inward supplies

Output Tax Section

• Total Taxable Sales
• Total Output VAT
• Adjustments related to outward supplies

Net VAT Position

• Net VAT Payable = Output VAT – Input VAT
• Or Net VAT Refundable (if Input > Output)

Emirate-wise VAT Breakdown

For each Emirate:

• Taxable Amount
• VAT Amount
• VAT Rate Applied

Emirates included:

• Dubai
• Abu Dhabi
• Sharjah
• Ajman
• Fujairah
• Ras Al Khaimah
• Umm Al Quwain

Additional Details

• Reporting period
• Company branch
• VAT accounts considered
• Adjustment notes (if any)

---

Report Output Structure

The report is typically displayed in three major sections:

1. VAT Summary (Top Section)

Provides high-level totals of Input VAT, Output VAT, and Net VAT.

2. Detailed Emirate-wise Summary

Each emirate is shown with:

• Taxable revenue/supplies
• Corresponding VAT amount
• Totals aggregated across all sales/purchase documents

This aligns with the UAE VAT return requirements.

3. Input vs Output Comparison Table

Shows summary values and highlights net tax payable.

---

Usage & Benefits

The Consolidated Tax Report is used for:

• Preparing monthly or quarterly UAE VAT return submissions.
• Verifying final VAT numbers before filing.
• Ensuring Emirate-wise VAT calculation accuracy.
• Providing management with high-level VAT exposure for the period.
• Supporting internal tax audits and financial reviews.
• Matching taxes across the Input and Output summaries.

This report is the final and most critical component of DIGITZ ERP’s Taxation MIS reporting suite.