Pre-configuration
Before generating models, it is essential to correctly configure the tax environment:
Activate the country
Go to Accounting > Configuration > Settings and select "Spain" as the tax country.
Spanish chart of accounts
Make sure Odoo is using the Spanish chart of accounts (PGCE or PGCE SME)
Types of tax
Odoo already includes standard configurations for VAT and IRPF (21%, 10%, 4%, 15% withholdings, etc.)
Invoice registration with VAT or IRPF
Odoo automatically calculates taxes based on the lines of the invoice.
When creating a customer invoice (Accounting > Customers > Invoices), choose the product with VAT included.
In the case of suppliers, ensure that the invoices correctly include the taxes so that Odoo can generate the models properly.
For IRPF withholdings, mark the corresponding negative tax on the line
Bank reconciliation
So that Odoo has complete accounting
Reconcile the movements to accurately reflect collections and payments
This is important for correctly calculating the accrued and supported VAT, as the reconciliation of invoices allows us to verify and close them.
Generate tax reports
Once you have everything accounted for, you can generate the tax models
Form 303 (VAT) Access Accounting > Tax Returns > VAT Report
Choose the quarterly period and click on "Generate".
Odoo will show the breakdown of VAT paid (purchases) and charged (sales).
You can export the model as a PDF or generate a file compatible with the AEAT Electronic Headquarters.
Form 111 (Personal Income Tax Withholdings) Access Accounting > Reports > Personal Income Tax Withholdings
You can export or copy the data to submit it manually on the Tax Office website.
Odoo automatically sums the withholdings applied to invoices for freelancers.
It is important to have in our accounting records the accounting entries for the payrolls that will be reported in this model.
Form 115 – (Withholdings for rentals) Access Accounting > Reports
Rental invoices with withholding automatically generate the necessary data.
Odoo calculates the bases, withheld amounts, and totals to be paid.
Form 190 (Annual Summary of Personal Income Tax)
This report is automatically generated with the accumulated withholdings for the year.
You can review it from the same section or install a specific module if you need the electronic file.
Form 347 – Transactions with third parties. Access Accounting > Reports > (you may need to install a specific module)
This model reports on transactions with suppliers or clients that exceed €3,005.06 annually.
The system groups transactions by quarter and allows you to review or export the data.
Export and submission
Odoo does not submit directly to the AEAT, but it provides you with all the information ready to:
Copy values on the AEAT website.
Export PDFs or Excel files with summarized data and use XML files (if you have a module that allows it) for electronic submission.
Our final recommendations
Close the accounting entries before generating reports.
Check for duplicates or accounting errors that may alter the calculations.
For electronic filing, consider extra modules (such as AEAT XML) or tools like SII if you are required to do so.
More than 50,000 companies use Odoo
to grow their business.
Join us to make your company a better place.