VAT Codes Table

该文档是已过时的旧文档

The most complete and up-to-date documentation is the one of Banana Accounting Plus: Try it now

In this article

The VAT Code table setup allows the definition of all the parameters that are necessary to manage the transactions with VAT. The setup refers to:

  • VAT due or recoverable
  • Transaction amount recorded as net, gross, or VAT amount at 100% (Customs VAT)
  • Freely definable applicable VAT rates
  • Freely definable account in which VAT must be recorded
  • Special rounding off for each code
  • Definable grouping and totaling method

The VAT Codes table has a Base view and a Complete view (see the table hereunder). The difference between the two is the fact that the Complete view presents several columns that are not available in the Base view. These columns serve to accommodate some specific options.  

Calculation modality

The parameters indicated in the VAT Codes table are being used to calculate the VAT of the individual transactions. The parameters established in VAT Codes table cannot be changed in the transactions. This modality guarantees that the VAT calculations are correct and uniform.

Please note: if the values of a VAT Code, which has already been used in the transactions, are being modified, the changes are not active immediately; in this case it is necessary to activate the Recheck accounting command (Account1 menu -> Recheck accounting). When the VAT Codes table is being modified, the program invites the user to execute a complete recalculation as a precaution. 

Detailed description of the columns

In the following columns, insert the following data:

  • Group: a code or number that identifies the group to which the code belongs. In the example we have inserted 1 for the sales, 2 for the purchases, T for the total. 
  • VAT Code: the code to identify and carry forward the VAT code in the transactions.  
  • Description: a text for the description of the VAT Code or the group.  
  • Gr: code of the "Group" in which the row has to be added.
  • Gr1: code for additional groupings.
  • Gr2: code for additional groupings.
  • Due VAT
    If the word Yes is being inserted, this means that the VAT is at debit (due to the State)   
    If the cell is empty, this means that the VAT is at credit (recoverable) 
  • Amount type: indicates how the software considers the transaction amount:
    0 (or empty cell) with VAT/sales tax (the transaction amount is considered VAT included) 
    1 = without VAT/Sales tax;
    2 = VAT amount (the transaction amount is considered the VAT amount) 
  • % VAT: VAT code percentage 
  • VAT% on gross: is usually being left empty. In special cases, the word "Yes" has to be inserted only if the VAT percentage has to be applied on the gross amount (VAT included) and not on the taxable amount. 
  • VAT account: the account on which the calculated VAT is being automatically.
    In the File and Accounting properties (File menu), a general account, that will be used as the VAT account, can be defined.
    It is also possible to set up a specific account for every individual VAT code.
  • Round Min: minimum value for rounding, to use only in particular cases. By preference, the rounding indicated in the basic data of the accounting (f.i. minimum rounding value 0.05) is being used.
  • Don't warn: there are particular transactions that the software could interpret as mistaken, but which, in reality, are correct. In order to avoid that the software signals error messages, insert the word Yes for the code that is concerned. 

When the transactions with VAT are inserted, by applying the VAT Code in the VAT Code column, the software calculates automatically all the amounts related to the VAT and transfers them in the VAT account.   

Adding a new percentage 

When a new percentage is added, a new row has to be added; in the new row, insert the data of the new VAT code with the new percentage, while paying attention to insert the correct grouping. Don't change a code that has already been used in the transactions.   

Groupings

By creating groups with multiple totaling levels, the user can obtain the totals that are necessary for the VAT declaration.   
In the VAT report, by activating the option Use own grouping scheme, the software calculates the totals exactly as indicated in the sequence of the indicated groupings in the VAT Codes table. 
The groupings are being used to obtain totals for groups of transactions, for example, the totals for all exportations or importations. 

 

Related document: Import VAT codes

 

help_id
accounting::vatcodes