Odoo Help

Welcome!

This community 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.

4

How to generate VAT report based on payment ?

vat
By
Julius
on 2/12/13, 1:34 PM 6,044 views

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 ?

4
eLBati
On 2/13/13, 3:28 AM

This feature lacks in OpenERP.

The account_vat_on_payment module should handle the VAT on payment treatment, in general. See the how-to

It works on 6.1, for now.

When translating V7 I see strings about VAT based on payments. Did you checked V7?

Altınkaya Elektronik Cihaz Kutuları imalat Ticaret ltd sti, Ahmet Altinisik
on 2/14/13, 5:55 AM

Not in depth. But reading the cited comment "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", I think not much has been done.

eLBati
on 2/14/13, 6:01 AM

See also the funding campaign for v7 version at http://igg.me/at/openerp-7-account-vat-on-payment/x/2728973

eLBati
on 4/5/13, 6:51 PM

Lorenzo, you should not do a funding campaign based on this as its not a good implementation. (a big hack that does not reflect the way you have to handle VAT on payments in most countries). Check my answer bellow for more info.

Fabien Pinckaers (fp)
on 4/6/13, 8:14 AM

I would not use the proposed above modules as they don't handle accounting entries legally. 1/ you must post invoice entries when you receive the invoice, not when it's paid (in the real CoA, not in a shadow one), 2/ VAT on payments must work for partial payments or payments without invoices. 3/ It does not produce the right accounting entries.

Fabien Pinckaers (fp)
on 4/6/13, 8:37 AM

See my comments below

eLBati
on 4/8/13, 3:39 PM
3

Fabien Pinckaers (fp)

--Fabien Pinckaers (fp)--
6598
| 6 8 8
fsdsdfsdf, Belgium
--Fabien Pinckaers (fp)--

Odoo Founder & CEO

Fabien Pinckaers (fp)
On 4/6/13, 8:29 AM

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.)

In France, The VAT on payment is a fiscal option that has to be validated by the tax authorities - at the creation time of the company in most cases - as it is considered as a derogation to the standard VAT system.

AD LIBITOM, michel Guénard
on 4/6/13, 9:31 AM

"you must post invoice entries when you receive the invoice, not when it's paid"

Actually, under certain treatments, you don't post entries at invoice confirmation. Check the Swiss accounting law at admin.ch Anyway, our module is configurable, so, if you want to post entries in the real CoA, it's just matter of configuration.

eLBati
on 4/7/13, 7:30 PM

That is indeed the Italian case, where you usually record real entries when confirming invoice (our how-to was addressed to Swiss customers mainly).

"VAT on payments must work for partial payments or payments without invoices"

Our module does.

"It does not produce the right accounting entries"

Well, we still have to agree on what "right accounting entries" means.

eLBati
on 4/7/13, 7:31 PM

"So, the implementation in OpenERP is quite simple: just add a Tax many2one field in the bank statement line"

I think this implementation can't cover every use case. We described 7 examples. Again, "shadow" accounts were used for Swiss accounting: read 'TVA à régulariser' instead of 'VAT (shadow)' and so on. How can you compute VAT amount if one bank statement pays several invoices with foreign currency, with different currency rates and even with discount?

eLBati
on 4/7/13, 7:32 PM

Moreover, if you only use bank statements, how can you correctly record VAT entries when you receive cash payments?

The main value of our module is in the computation part, more than in the used accounts, as they are configurable.

eLBati
on 4/7/13, 7:32 PM

Hello Lorenzo, in Poland we only treat VAT specially regarding vat on payment, so this should look as Fabien has shown in his example. Is it possible to configure your modules to not make additional moves on non-tax accounts, only for taxes? (I guess just cutting out some lines out of your code?)

Krzysztof Matusik
on 12/3/13, 7:23 PM

Hello, just want to let you know that a new version of the module, also handling bank statements, is available at https://github.com/OCA/account-payment/pull/54

eLBati
on 5/2/16, 2:36 AM
0
Fred Saunier
On 3/4/14, 8:46 AM

Hi,

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).

Thank you,

Fred

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 2/12/13, 1:34 PM
Seen: 6044 times
Last updated: 3/16/15, 8:10 AM