How to view the tax summary and VAT by market

What is it for?

The tax summary shows, for the period you choose, the taxable amount and the tax of sales and purchases, line by line per VAT rate. It is used to check the amounts before the VAT settlement and the return. The VAT summary by market splits the same movements into Mainland, EU and Outside EU, with VAT charged and deductible VAT in separate columns.

When to use it?

• To see quickly how much VAT there is per rate in the month, the quarter or the year.
• To check what feeds the VAT settlement and the periodic VAT return.
• To separate Mainland operations from EU and non-EU ones (summary by market).
• Do not use it to submit amounts to the AT: what you submit is the periodic return. The summary is a reading for checking.

Where to find it?

• Tax summary: Accounting › Review › Taxes and treasury › Tax summary. The screen is called Tax Recap (the menu and the title do not match).
• VAT summary by market and Tax report: they are in Accounting › Review › Taxes and treasury, but they only appear with developer mode active (add ?debug=1 to the Odoo address). Without that mode, the menu does not show them. Proven with the Accountant profile: with ?debug=1 the VAT summary by market item appears in Review and opens the summary.

Before you start

• Your profile is Accountant. With it you do steps 1 to 5 of this article, including the export. Step 6 (summary by market) is optional: only people with developer mode (?debug=1 in the address) see it, and the Accountant profile can also turn it on.
• The period's sales and purchase invoices are confirmed. To also see draft invoices, tick Include drafts.
• The example uses Empresa Demonstração, Lda, in the year 2026.

How to use it

1. Open Accounting › Review › Taxes and treasury › Tax summary. By default, it opens the year 2026 (01/01/2026 – 31/12/2026). At the top, Month, Quarter and Year change the unit; the list next to them chooses the period (for example 4.º trimestre 2026) and the arrows move to the next or previous one.
2. Read the two main lines. Sales shows one line per rate: in the example 13 % (taxable amount €281.20, tax €36.56), 23 % (€33,892.30, €7,795.24) and 6 % (€1,159.50, €69.57). Purchases shows VAT at 23 %, the lines 23% AUT construção, 23% EU S and 23% EX S (reverse-charge operations) and the Retenção IRS 23% — trabalho independente (art. 151.º) (Personal Income Tax (IRS) withholding for self-employed work), with the rate -23 % and the tax -€667.00.
3. Click the arrow of a line (for example 23% of sales) to see the documents behind it: each with the Date, the Partner, the Taxable amount and the Tax.
4. Click More filters to refine: the dates From and until, Include drafts, Default period (This month, Previous quarter, Current VAT period, Previous VAT period…), Unfold all, Companies and Journals.
5. To keep the result, click Export PDF (it creates Empresa_Demonstracao_Lda_Recapitulativo_de_Imposto_2026-01-01_2026-12-31.pdf, with the company header and the issue date and user) or Export and choose Export XLSX, Export CSV (PT format) or Print.
6. Optional step, for people with developer mode. To see VAT by market, open the VAT summary by market. In Sales (VAT charged) and in Purchases (deductible VAT), each market (Mainland, EU, Outside EU) is split by rate and by Goods and Services, with the columns Taxable amount, VAT on sales and Deductible VAT. At the end, the Balance (charged - deductible): €1,462.52 in the example.

Expected result

• The summary shows, per rate, the taxable amount and the tax of the period, with a Grand total. In the 2026 example: taxable amount €74,260.87 and tax €13,673.22.
• The PDF repeats the table on screen (checked: same amounts, 1 page).
• The summary by market matches the tax summary, with one difference that can be explained: the tax summary does not show the 0 % lines. In the example, sales in the market summary have a taxable amount of €38,393.00 and in the tax summary €35,333.00; the difference, €3,060.00, is the 0 % sales (€2,100.00 in the Mainland and €960.00 outside the EU). In purchases, the €1,200.00 at 0 % (no product) explain the difference between the market summary (€37,227.87) and the VAT lines of the tax summary (€36,027.87, before withholding).
• This article creates no journal entries: it is a lookup.

Pending validation by a certified accountant: how to read the reverse-charge lines (in the tax summary they have €0.00 tax; in the market summary, VAT charged and deductible VAT appear side by side, €881.56 each, in the EU) and the inclusion of the IRS withholding, as taxable amount and tax, in the grand total of the summary.

Important notes

• The summary does not show what has no tax. Lines at 0 % and exemptions do not appear. For the full picture, use the summary by market.
• The grand total adds sales and purchases. The Grand total (€74,260.87 taxable amount and €13,673.22 tax) adds everything, including the IRS withholding. The product put the line Retenção IRS 23% — trabalho independente (art. 151.º) in this table, in the purchases section, because the withholding is a tax on the supplier bill, but it is not VAT: a “VAT” summary therefore shows amounts that are not VAT. Do not read the total as the VAT payable: the VAT payable comes from the settlement.
• Drafts. They are only included if you tick Include drafts; an amount that changes when you tick the box points to invoices still to confirm.
• Tax report (generic variant): do not use it for checking for now. It opens with the options Generic Tax report, Group by: Account > Tax, Group by: Tax > Account and Periodic VAT Return, but in the demo none of them shows lines. Use the summary.

Common problems

In an empty company, the summary only has the total at zero

• Symptom: in the company Empresa Teste Filial, which has no journal entries, the 2026 Tax summary only shows the Grand total line with €0.00 taxable amount and €0.00 tax, with no Sales or Purchases.
• What to do: nothing, if the company has not posted anything yet. Confirm that you chose the right company in the company selector at the top. Note: Empresa Teste Portugal is not empty (it has invoices in 2026).

The chosen period appears empty

• Symptom: the table only has Grand total €0.00 €0.00 (for example, in the year 2027 of the demo).
• Cause: there are no confirmed invoices in that period.
• What to do: confirm the period and the company (More filters › Companies) and tick Include drafts to see invoices still to be confirmed.

The amounts in the summary by market and the tax summary do not match

• Cause: the tax summary does not show the 0 % lines or the market; the summary by market shows them.
• What to do: add the 0 % lines of the market summary to the taxable amount of the tax summary (see “Expected result”). If there is still a difference, open the Periodic VAT return support (Accounting › Review › Taxes and treasury) and look for the document in question.

I do not see the VAT summary by market in the menu

• Cause: the menu only appears with developer mode active.
• What to do: open Odoo with ?debug=1 in the address and go back to Accounting › Review › Taxes and treasury.