Skip to content
TAQNIX
Odoo ModulesWordPress PluginsWordPress ThemesShopify ThemesApp TemplatesScripts & UtilitiesBlogSell on TAQNIX
ModuleOdooNew

Accounting Pro GCC VAT Returns for Odoo 19 Community – UAE VAT 201 and KSA VAT Return Worksheets, FTA Audit File (FAF), Reconciliation, PDF and Excel

UAE VAT 201 and KSA VAT return worksheets from your posted journal items inside Accounting Pro: boxes by emirate, reverse charge and imports, review and filing workflow with an audit log, reconciliation with the general ledger, transactions per box, FTA Audit File export, PDF and Excel. Arabic included.

No reviews yet0 salesby TAQNIXUpdated Oct 29, 2026

Description

VAT returns inside Accounting Pro

Accounting Pro GCC VAT Returns prepares the UAE VAT 201 and the KSA VAT return from your posted journal items in Odoo 19 Community, checks them against the general ledger, keeps every return with a review and filing workflow, and exports the UAE FTA Audit File (FAF). What it produces is a worksheet: the return itself is submitted by you on EmaraTax or the ZATCA portal. The module never files anything and never connects to the FTA or ZATCA.

The VAT 201 boxes, from your journal items

Map once

  • VAT Tax Mapping proposes a VAT return code for every tax you use: from the tax grids of Odoo's UAE and Saudi localizations, the reverse charge repartition, the names (English and Arabic) and the rates
  • A code you choose by hand is never changed; running the wizard again changes nothing
  • Emirate on every invoice and bill (default from the settings) for boxes 1a to 1g; a tax made for one emirate wins; supplies without an emirate are shown apart, never dropped
  • Customs permit number on import bills, written in the FAF
Every return against the ledger

Prepare, review, file

  • UAE VAT 201 boxes 1a to 14 and KSA boxes 1 to 16, computed from the posted journal items: credit notes, price-included taxes, groups of taxes, tax on tax, reverse charge on both sides, imports, cash basis taxes when paid, non-recoverable VAT
  • Returns with the states draft, computed, reviewed, filed: corrections need a reason, a correction after the review sends the return back, a filed return cannot change until a VAT manager reopens it with a reason
  • You record the filing reference and date given by the portal; every step is in a log nobody can edit
Compute, review, record the filing

Check

  • VAT Return report in the Accounting Pro screen: the boxes in English and Arabic, any period, comparison with previous periods, a saved return with its corrections, click any figure for its journal items
  • Reconciliation with the general ledger: output and input VAT of the boxes against the balances of the VAT accounts, and the journal items behind any difference
  • VAT Transactions Detail: the documents behind every box with the partner TRN, and the business documents without a valid TRN
  • PDF worksheet with the TRN, the filing reference, a declaration and signature boxes; Excel with real numbers
  • FTA Audit File (layout FAFv1.0.0 of the FTA): checks before the export, then a comma separated file of the company, purchase, supply and general ledger tables, logged with its SHA-256
  • TRN format checks, a VAT payable card on the Accounting Dashboard
Every tax gets its box

What is verified, and what is not

  • Checked against the FTA documents: the VAT 201 boxes 1a to 14 and their rounding (VAT Returns User Guide 2021, EmaraTax manual 2022) and the FAF layout FAFv1.0.0 (requirements document 2017, still the published version)
  • KSA: box numbers and English labels checked against the ZATCA portal guide (July 2026); not verified: the formulas of boxes 13 and 16, the rounding and the Arabic labels of the KSA boxes
  • The KSA Adjustment column holds VAT amounts while the ZATCA portal asks for values of sales or purchases: same net VAT, but convert before you type (said on the screen, the PDF and the Excel file)
  • Not verified either: the UAE law changes in force from 2026, the optional row of field names in the FAF and the code OS for out-of-scope supplies (the FTA defines none)
  • It is an accounting tool, not tax advice: check every figure against the current FTA or ZATCA rules before you file
The FAF, checked before export

What it does not do

  • No filing, no connection to EmaraTax or ZATCA, no e-invoicing (no Peppol, no ZATCA XML or QR code)
  • No VAT payment or settlement entry, no penalties, no due-date reminders; filing does not set Odoo's tax lock date
  • One return per company: Odoo branch companies and VAT groups are not added together (a warning names the branches)
  • The return is in the company currency: a company not in AED or SAR gets a warning, not a conversion
  • A line with two VAT taxes coded for the same box counts its base once for each tax: a warning lists such items
  • Very large FAF exports (close to a million ledger lines) are built in memory: export shorter periods
From the books to the portal

Accurate

One engine gives the boxes of the saved returns, both reports, the dashboard card and the tests. Each box is rounded and the totals add up the rounded boxes, so the form adds up on paper. A filed return keeps its figures even if the journal items or the box definitions change later; the report warns when the journal items changed.

A worksheet to sign and keep

Tested

114 automated tests of the add-on (641 with those of Accounting Pro): every UAE box worked out by hand and tied to raw SQL, drill-downs that reproduce every cell, the KSA boxes, the workflow and its locks, the FAF listings and ledger tied to the journal items, hostile texts in the FAF, access rights and several companies.

Everything a GCC VAT return needs

Documented

Illustrated guide in English and Arabic and an Arabic translation of the whole add-on.

What's included

  • taqnix_accounting_pro_gcc_vat.zip: the Odoo 19 module (with Arabic translation)
  • Illustrated documentation in English and Arabic (HTML and PDF)
  • Automated tests, licence file (OPL-1) and changelog

Requirements

Odoo 19.0 with Accounting Pro (taqnix_accounting_pro) 19.0.1.0.2 or later

What's in the download

The files in the archive you can download after you buy.

  • Full source code
  • Documentation
  • Installation guide
  • Automated tests
  • Licence file
  • Changelog

Customer reviews

Write a review

No reviews yet. Bought this item? Be the first to review it.

Usage

Install and use it in a few lines.

company = env["res.company"].search([("name", "=", "Atlas Trading LLC (UAE)")])
engine = env["taqnix.acc.engine"].with_company(company)     # the VAT reports are Accounting Pro reports: same engine, same access rights

# the VAT Return worksheet of the third quarter (live figures of the posted journal items), with the reconciliation
options = {"date": {"preset": "custom", "from": "2026-07-01", "to": "2026-09-30"}, "extra": {"reconcile": True}}
table = engine.get_table("vat_return", options)
for row in table["rows"]:
    print(row["type"], [cell.get("text") for cell in row["cells"]][:5])   # account ['1a', 'Standard rated supplies in Abu Dhabi', ..., '173,330.00', '8,666.50']

# the saved returns: state, net VAT and the difference with the general ledger
for ret in env["taqnix.accv.return"].search([("company_id", "=", company.id)], order="date_from"):
    print(ret.name, ret.state, ret.net_due, ret.recon_difference, ret.filing_reference)   # VAT 201 Q2 2026 filed 11978.9 0.0 230002139584470

Documentation

Setup, settings and troubleshooting, written by the author.

Open the documentation

Changelog

Every release, newest first.

v1.0.0

1.0.0 – Initial release

  • UAE VAT 201 (boxes 1a to 14, standard-rated supplies by emirate) and KSA VAT return (boxes 1 to 16) computed from the posted journal items: credit notes, price-included taxes, groups, tax on tax, reverse charge, imports, cash basis, non-recoverable VAT
  • Tax mapping wizard reading the tax grids of the Odoo UAE and Saudi localizations, VAT codes on taxes, emirate and customs permit number on documents
  • Returns with draft, computed, reviewed and filed states, corrections with a reason, filing reference recorded by hand, reopen with a reason, an audit log
  • VAT Return and VAT Transactions Detail in the Accounting Pro screen, PDF worksheet with declaration and signature boxes, Excel; reconciliation with the general ledger
  • FTA Audit File (FAFv1.0.0) export with checks and an export log (SHA-256), TRN checks, VAT payable dashboard card, Arabic translation and right-to-left screens

Frequently asked questions

What do I need to install it?

Odoo 19 (Community or Enterprise) with Accounting Pro (taqnix_accounting_pro) version 19.0.1.0.2 or later already installed: this is an add-on of Accounting Pro and it does not work without it. Your company must use the UAE VAT 201 or the KSA VAT return form (set in the settings), and your taxes need a VAT return code (the mapping wizard proposes them). The Odoo UAE or Saudi localization is not required; when it is installed, the wizard reads its tax grids.

Does it file my VAT return or send e-invoices?

No. It prepares a worksheet: you copy the figures into EmaraTax or the ZATCA portal yourself, then record the filing reference and date in the return. It never connects to the FTA or ZATCA, and it does not create e-invoices (no Peppol, no ZATCA XML or QR code). Marking a return as filed does not set Odoo's tax lock date.

Is the layout verified against the official rules?

The UAE VAT 201 boxes 1a to 14 and their rounding were checked against the FTA VAT Returns User Guide (2021) and the EmaraTax manual (2022), and the FAF layout FAFv1.0.0 against the FTA requirements document (2017, still the published version). For Saudi Arabia, the box numbers and English labels follow the ZATCA portal guide (July 2026); the formulas of boxes 13 and 16, the rounding and the Arabic KSA labels are not verified. The KSA Adjustment column shows VAT amounts while the portal asks for values of sales or purchases: convert before you type. It is an accounting tool, not tax advice: check every figure against the current official rules before filing.

How are the boxes computed?

From the posted journal items dated in the period, in the company currency, with the rules of the Accounting Pro Tax Report: credit notes negative, price-included taxes, groups of taxes, tax on tax, cash basis taxes when the invoice is paid. Reverse charge and imports appear on both sides (VAT due and VAT recovered); VAT you cannot recover is left out of the recoverable boxes. Each box is rounded and the totals add up the rounded boxes. Click any figure to see its journal items.

How do I know the return agrees with my books?

Each return and the VAT Return report compare the output and input VAT of the boxes with the balances of the VAT accounts of the coded taxes for the same dates. A difference (a VAT settlement entry dated in the period, an entry typed on a VAT account, a tax without code) is shown with the journal items behind it, never hidden.

What is the FTA Audit File export?

For a UAE company and a date range, it first checks the data (company TRN, AED rates, unbalanced entries, taxes and partners without codes or TRNs), then writes the comma separated file of the FTA layout FAFv1.0.0: company information, purchase listing, supply listing and general ledger. Each export is logged with its user, period, row counts and SHA-256. The optional row of field names and the code OS for out-of-scope supplies are not part of the FTA document: leave the row off for the file you give to the FTA.

What does it not do?

No filing, no e-invoicing, no VAT payment or settlement entry, no penalties or due-date reminders. One return per company: Odoo branch companies and VAT groups are not added together (a warning names the branches). A company not in AED or SAR gets a warning, not a conversion. A line with two VAT taxes coded for the same box counts its base once for each tax (a warning lists such items). Very large FAF exports should be split into shorter periods.

Who can do what?

Accountants (GCC VAT Returns: user, given with Show Full Accounting Features) prepare, compute, correct and review returns. Accounting administrators (GCC VAT Returns: manager) map the taxes, edit the box definitions, mark returns as filed, reopen them, export the FAF and change the settings. A user with only the Accounting Pro reports group opens the two reports. Every user sees only the returns of the companies they have access to, and nobody can change or delete the logs.

Is it available in Arabic?

Yes. The add-on, its guide and its screens come in English and Arabic; the worksheet shows the box labels in both languages, and the screen, the PDF and the Excel file work right to left.

More from TAQNIX

  • App templateNew

    Taqnix POS Terminal – Offline-First Point of Sale PWA for Odoo 19: Next.js Source Code with Restaurant Tables, Kitchen Tickets, Loyalty and Arabic

    A point of sale for Odoo 19 that runs in the browser as an installable app and keeps selling when the network is gone: every order is saved on the device first and sent to Odoo once, with the same call Odoo's own POS uses. Variants and combos, split payments, receipts with barcode and QR, restaurant tables and kitchen tickets, dashboard, stock lookup, layaway, loyalty, English and Arabic. Full Next.js source code; no Odoo module to install.

    by TAQNIX
    No reviews yet
    Sales:0$399.00
  • ModuleNew

    UAE E-Invoicing (PINT AE) for Odoo 19 Community – PINT AE XML for Your ASP, Readiness Checks, UBL XSD and Schematron Validation, E-Invoice Outbox

    Prepare UAE e-invoices and credit notes in the PINT AE format (Peppol PINT AE Billing 1.0.4, UBL 2.1) for your Accredited Service Provider: TIN, TRN and tax categories, readiness checks per invoice and per batch, validation against the official XSD and Schematron, an outbox with statuses, a log and XML / ZIP export. It does not send anything. Arabic included.

    by TAQNIX
    No reviews yet
    Sales:0$149.00
  • PluginNew

    AI Support Reply Drafts for WooCommerce – Order-Aware Customer Reply Drafts with Fact Checks

    Draft replies to customer messages on the WooCommerce order screen with your AI model, from the order facts and your own shop texts only. Missing facts become [CHECK] placeholders; nothing is sent without a click and a confirmation.

    by TAQNIX
    No reviews yet
    Sales:0$49.00
  • PluginNew

    AI Product Recommender and Bundles for WooCommerce – Related Products, Complete the Look & Add All to Cart

    Related products and “complete the look” bundles ranked by AI meaning similarity and what your customers bought together, with Add all to cart, a preview with the reasons, pins and exclusions.

    by TAQNIX
    No reviews yet
    Sales:0$49.00

Similar items

  • ModuleNew

    UAE E-Invoicing (PINT AE) for Odoo 19 Community – PINT AE XML for Your ASP, Readiness Checks, UBL XSD and Schematron Validation, E-Invoice Outbox

    Prepare UAE e-invoices and credit notes in the PINT AE format (Peppol PINT AE Billing 1.0.4, UBL 2.1) for your Accredited Service Provider: TIN, TRN and tax categories, readiness checks per invoice and per batch, validation against the official XSD and Schematron, an outbox with statuses, a log and XML / ZIP export. It does not send anything. Arabic included.

    by TAQNIX
    No reviews yet
    Sales:0$149.00
  • ModuleNew

    Accounting Pro Group Consolidation for Odoo 19 Community – Multi-Company Consolidated Balance Sheet and P&L, Intercompany Elimination, Currency Translation, Non-Controlling Interest, PDF and Excel

    Consolidate the companies of one Odoo database inside Accounting Pro: currency translation with a translation reserve, intercompany elimination with visible differences, investment elimination with goodwill, non-controlling interests, runs that lock, five reports on screen, PDF and Excel. The method and its simplifications are listed. Arabic included.

    by TAQNIX
    No reviews yet
    Sales:0$199.00
  • ModuleNew

    Accounting Pro Closing for Odoo 19 Community – Month-End Close Checklist, Lock Dates, Year-End Closing Entry and Profit Appropriation, Close Status in PDF and Excel

    Month-end and year-end close inside Accounting Pro: a close checklist with automatic checks, lock dates set the way Odoo supports with an audit log, the year-end closing entry and its reversal, profit appropriation with the statutory reserve percentages as settings (for UAE or Saudi rules), and a Close Status report on screen, in PDF and in Excel. Arabic included.

    by TAQNIX
    No reviews yet
    Sales:0$99.00
  • ModuleNew

    Accounting Pro Management Reports for Odoo 19 Community – Profitability by Customer, Product and Salesperson, Executive Summary, Rolling 13-Month Profit and Loss, Customer Concentration

    Gross profit and margin by customer, product and salesperson that tie to the Profit and Loss, a one-page executive summary with traffic lights, a rolling 13-month profit and loss and customer concentration inside Accounting Pro, on screen, in PDF and in Excel. Arabic included.

    by TAQNIX
    No reviews yet
    Sales:0$99.00