Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
VAT report based on payment is the basic report needed in few countries. Where to generate it in OpenERP v7 ?
It appears to be hidden in account.view_account_vat_declaration.
<!--- <field name="based_on"/>--> <!-- the option based_on 'payment' is probably not fully compliant with what the users understand with that term. So, currently, it's seems better to remove it from the view to avoid further problems -->
Is this feature lacking in OpenERP 7 ?
OpenERP does not support yet VAT on payments if you use bank statements. But it can easily be handled if you record your bank statement in journals directly rather than the bank statement view.
Here is how most countries handle VAT on payments:
When doing an invoice (e.g. in Belgium, 21%):
401 Receivables 121 700 Income Account 100 44585 TVA Ã rÃ©gulariser 21
When registering a partial payment:
401 Receivables 121 550 Bank Account 121 44585 TVA Ã rÃ©gulariser 21 44574 TVA collectÃ©e 21
So, you have to define two taxes. (one for the invoice, one for the payment)
Please note that it's not related at all with the reconciliation process. If you receive a payment without having done the invoice (or an invoice is sent but not reconciled, or if the payment is partial), you still have to pay the VAT you received from your customer.
So, the implementation in OpenERP is quite simple: just add a Tax many2one field in the bank statement line.
If someone does such an implementation, we would like to integrate it in trunk, as part of the core modules (and we need a configuration checkbox to activate this feature.)
I am reviving this thread on how to generate a VAT tax report based on payments in OpenERP v7, because it is now something mandatory in Belgium since Jan. 2014 for services.
I have been using OpenERP v5 for a number of years, and there, I can choose between creating the report either based on Invoices or on Payments. Up until now, I was generating the report based on Invoices, and now I started generating it based on Payments. In version 5, again, it works somewhat. Indeed, invoices that have received a payment are taken into account in the report, but in the period of the invoice, not that of the payment, which is wrong.
Eg : Invoice issued Jan. 15, paid Mar. 15 - Should be on the March tax report, which it isn't. It is present on the Jan. report if, and only if, it is paid. That is wrong.
I am experimenting with OpenERP v7. In this version, when is this option going to be available? It is now mandatory for us in BE -- ie: for services, vat exigibility is based on payments; for delivery of goods, vat exigibility is now based on either date of delivery or date of payment (whichever comes first).
About This Community
This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 2/12/13, 1:34 PM|
|Seen: 7692 times|
|Last updated: 3/16/15, 8:10 AM|