How to calculate form 347 in Odoo AEAT

In the following video, we will explain and share how to prepare, create, and review the Odoo Community OCA model 347, which you can download from ​ GITHUB Remember that if you have an Odoo Enterprise Odoo.SH or On-Premise version, you can install it on the server at no cost.

This Odoo Model 347 manual is based on the calculation of the Spanish Tax Agency's Form 347, which quickly and easily identifies customers and suppliers whose total invoices (base amount + VAT) exceed €3,000 during the previous fiscal year. This information can then be quickly and easily shared with all our customers and suppliers for their review. 

We'll also see how to prevent customers or suppliers who shouldn't be declared on form 347 from being excluded from their contact record or invoice, simplifying tax preparation in future years. It's important to remember that all customers, creditors, and suppliers in Odoo must always have the correct name, province, and tax identification number (NIF) to avoid errors on form 347. 

Once our model 347 has been validated, we can generate the AEAT file to send to the Tax Office and forget about this tax until next year, something that is usually tedious but very easy to complete and validate with Odoo.

If you are Contaldia customer remember that we calculate and send your Odoo Form 347 to reduce errors and ensure you file your taxes on time and correctly with your Odoo.

If you want to create and verify VAT form 347 using an Excel spreadsheet, either because you have some invoices in a previous program or because you want to verify the data that appears in Odoo Enterprise, you can follow this tutorial to create a form 347 with your Odoo VAT spreadsheet in Excel.