Excise Tax Audit File Report

The Excise Tax Audit File is an official FAF-format file exported from the system that contains all excise tax transactions and excise inventory movements within a specified time period, in accordance with the official requirements of the UAE Federal Tax Authority (FTA). This article explains how to access and export this report.

Before You Begin

• Your account’s country must be set to United Arab Emirates.
• The UAE E-Invoicing app must be activated for this report to appear.
• At least one excise product must be defined in the system.
• There must be recorded excise inventory movements within the specified period.
• You must have permission to view tax audit reports.

Steps to View the Report

• From the main menu, click Reports.
• Navigate to the Sales Reports section.
• Navigate to the Tax Audit Reports section.
• Click on Excise Tax Audit File.

Steps to Generate and Export the File

• Set the start date of the required time period.
• Set the end date of the required time period.
• Click the Run Report button.
• Click the Download FAF File button — the system will automatically generate and download the Excise Tax FAF file to your device.

Contents of the Exported File

The Excise Tax Audit File includes several interlinked tables in accordance with the FTA’s official format:

Excise Transaction Data Table Contains all excise product tax transactions within the specified time period, including data from invoices, sales returns, credit notes, and debit notes related to excise products.

Inventory Movements Table (Stock File) Contains a complete record of excise goods inventory movements, including the following fields:

• Warehouse ID – The identifier of the warehouse where the movement occurred.
• Product Code – The excise product number.
• Excise Tax Rate – The tax rate applied to the product.
• Transaction Type – The type of inventory movement, such as import, transfer, sale, or production.
• Movement Details – A description of the inventory movement.
• Transfer ID – The inventory transaction number or associated dispatch order.
• Movement Date – The date the inventory movement was executed.
• Tax Payment Date – The date excise tax was paid.
• Customs Duty Status – Whether the goods are duty-paid or duty-suspended.
• Inventory Adjustment – Details of any write-offs, losses, or adjustments.
• Goods Location – The physical location of the excise goods.

The Stock File table is automatically generated within the FAF file. If there are no excise inventory movements during the specified period, the table will appear with only a header and footer row and no data.

Notes

• This section only appears if the UAE E-Invoicing app is activated.
• The FAF file export option is no longer available from the Invoices screen — it is now exclusively accessible from this section under Reports.
• The exported file does not include any VAT data. To obtain the VAT audit file, refer to: VAT Audit File Report.
• Make sure to select the correct time period before exporting the file to ensure the audit data is complete.
• The exported file is built strictly according to the official Excise FAF format approved by the FTA, including all required fields in their correct order.