Statement Lines with taxes


(Sergi Almacellas Abellana) #1

Hi,

I’ve found that our bank creates the following lines on the statement:

  • COMISION: 1€
  • TAX COMISSION: 0.21€

This is related to their services but it does not encode any invoice for it.

Currently I see no way to create the tax lines from the bank statement, so I’m wondering how other people is entering this information in tryton?

It is right to create a invoice for the statement line even if you have not received any legal document for it?
Should we extend the statement module to allow to set the tax lines when the invoice field is empty?

Any comments will be appreciated.


(Cédric Krier) #2

I guess the statement is considered as an invoice.

I think this is wrong because it would require to have almost a full invoice form on the line. For example, you need to be able to specify the accounting date.

So for me, the solution is the create a move template for this kind of cost. And to call it when reconciling the statement.
Maybe we could have a mechanism on the reconciliation wizard to reconcile lines using a specific template instead of the write-off journal.


(Richard PALO) #3

We have similar in France, at least for some banks.

Normally, an invoice can only be created if there is a legally established invoice communicated… by definition.

We receive a monthly invoice listing the VAT and non VAT subjected charges and commissions including a booking date for each which are the same dates found on the bank statement.

Currently we book the statement lines ex-VAT charges and commissions directly to the appropriate account (typically 6278 or 6616 in the French plan) and, when VAT is involved, add a line booking the VAT directly to 44566x. The invoice is kept with the statement.

Nevertheless we are considering, for audit purposes, booking the full invoice and, consequently, the statement move(s) to the bank’s supplier account - then manually reconciling on a monthly basis…
unfortunately it seems impossible to select invoices for [partial] payments in the invoice selection wizard invoked during statement data entry (neither multiple statement lines for one invoice as in this case, nor for multiple invoices per statement line which happens upon occasion as well).


(Cédric Krier) #4

It is possible but only if the amount of the statement line is less or equal to remaining amount to pay on the invoice (and if the invoice is posted).

But reconciliation on the statement will always be limited to simple case. For full featured reconciliation, the wizard must be used.


(Cédric Krier) #5

Another option would be to allow to define a move template on the statement line. So when the statement is posted it will create the templated move and reconcile the matching lines.


(Sergi Almacellas Abellana) #6

I like this idea, but then we should launch the create move wizard to ask the parameters of each move.

Not sure if this will be difficult to understand by the end user, specially when multiple templates are used on the same statement.


(Cédric Krier) #7

No, I think such template should be marked as available for statement line and so they should use only keywords that will be filled by the statement line.


(Richard PALO) #8

Ah yes, I see. Thanks. For the monthly statements/invoices the cumulated total will always be paid such that cash basis TVA will be okay.