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
