New VAT percentages and new VAT form

In the new Banana Accounting Plus version of you will find the updated VAT codes table and the new VAT reports to be submitted:

• Swiss VAT tax report - effective method
• Swiss VAT tax report - Flat tax rate method
• Electronic XML VAT tax report - transmission to the VAT Authority

We advise you to immediately switch to Banana Accounting Plus and take advantage of the many new features.

As of 01.01.2018, new reduced VAT rates have come into force, according to the September 24th 2017 vote.

Banana Accounting 8 doesn't prepare the VAT report for the 4th Quarter 2017 and for those of the year 2018.

From Banana Accounting 9, the new facsimile of the official VAT form can be obtained automatically. Those who are in possession of an earlier version can update the VAT-codes table with the new codes and rates, but can only create the VAT report and not the facsimile of the official VAT form. We therefore strongly advise you to update to Banana Accounting 9, specifically prepared for the transition to the 2018 VAT rates.

The accounting templates available on our website already contain the new VAT codes, with both the rates before and after the 2017 vote.

How to update your VAT Codes table with the new rates

We recommend that you do this at the beginning of 2018, before you start entering your 2018 transactions.
To update the VAT Codes table of your accounting file, proceed as follows:

• Download and save this file -> VAT_Codes_2018
• Open your accounting file
• From the Account1 menu, choose the Import into accounting command and then select VAT Codes.
  
  
   

• Using the Browse button, choose the path were you saved the file you downloaded -> VAT rates 2018
• Confirm with the OK button.
• A dialog window will appear were you can choose between two options:
  • Add new codes and new groups
    To be used when maintaining some of your own VAT codes. In this case, the program adds the new VAT codes while leaving the existing ones unchanged.
  • Replace all rows
    To be used if you do not need to keep the existing VAT Codes table.
    In this case, the VAT Codes table is completely replaced with the new table from the downloaded file.
    
    

• Check your accounting file
  From the Account1 menu choose the Check accounting... command.
  If in your transactions there are VAT codes not present in the VAT Codes table, you need to enter the missing VAT codes or replace the existing ones with the ones from the new VAT Codes table.
  In order to speed up this operation you can use the Find and replace command from the Data menu.

Flat VAT rate

For the Flat VAT rate method, from 2018 new VAT rates will be applicable.
We recommend updating the VAT Codes table, replacing all the codes as described above.

• If you use the end of the period VAT calculation method (without splitting the VAT amount in the transactions), you must enter the new VAT rate when proceeding with the VAT report.
  
  
   
• If you however split the VAT amount for each transaction, you need to change your VAT Codes table entering the new rate.

For more information please visit the Swiss VAT tax report - Flat tax rate method page.

New forms for the VAT return

Banana Accounting Plus automatically prepares the VAT returns and the electronic transmission to the VAT Authority. This is not possible in Banana Accounting 8.  In the new Banana Accounting Plus version, there are extensions to prepare in an easy and quick way:

• Swiss VAT tax report - effective method
• Swiss VAT tax report - Flat tax rate method
• Electronic XML VAT tax report - transmission to the VAT Authority

We advise you to immediately switch to Banana Accounting Plus and take advantage of the many new features.

Content not available in English.
This content is available in German, French and Italian.

With the system of the VAT on cash received, there is no provision for entering transactions on the clients/suppliers accounts, for the expenses and income are being entered at the moment the payment is made or received. Only at that moment, the VAT code is being entered. However, in spite of this rule, it is still possible to enter the issued and received invoices by using the cost centers.

Procedure:

• Insert the clients' and suppliers' accounts as cost center CC3, defined with the semicolon in two different groupings, one for clients, another one for suppliers.

Entering the invoices of clients and suppliers
 

For the issued and received invoices:

1. Position yourself in the Transactions table, Cost centers view;
2. Enter the date, the document number and the invoice number in the respective columns;
3. Enter the description;
4. Enter the amount of the issued or received invoice in the Amount column, the Debit and Credit columns have to remain empty.
5. Enter the cost or profit center in the CC3 column: in positive when it concerns an invoice issued to a client; preceded by the minus sign (in negative)  when it is an invoice received from a supplier.

When the payment for an invoice is received or made:

1. Position yourself in the Transactions table, Cost centers view;
2. Enter the date, the document number and the invoice number in the respective columns;
3. Enter the description;
4. If it concerns a payment received, enter a liquidity account in the Debit column and a revenue account in the Credit column;
   When it's about a payment that has been made, enter an expense account in the Debit column and a liquidity account in the Credit column;
5. Enter the amount;
6. Enter the appropriate VAT code;
7. Enter the cost or profit center in the CC3 column, preceded by the minus sign (in negative) when it is a payment received (customer) and in positive when it concerns a payment made to a supplier.

In the Account card of the cost center, the transactions of the customer or supplier are being displayed.

Related documents

• Cost and Profit Centers
• Membership list

Alle intercommunautaire verwervingen (EU) dienen te worden opgenomen in uw boekhouding en in uw BTW aangifte.

Te gebruiken codes

In de tabel BTW-codes zijn er specifieke codes die gebruikt moeten worden voor intercommunautaire verwervingen:

• twee codes voor de aankoop van de goederen of de prestatie zelf, ICP21 (21%) en ICP6 (6%).
• twee codes voor de verwerking van de BTW, IG21-1 en IG6-1

Deze codes hebben als bedragtype het type 1, waarbij het ingevoerde transactiebedrag het netto bedrag is (exclusief BTW)

In detail:

• De ICP21 code berekent een credit bedrag.
  Het is belangrijk om hier in de kolom Niet waarschuwen (BTW-Codes) "Ja" in te voeren, anders verschijnt er een waarschuwingsboodschap.
• De IG21-1 code berekent een debet bedrag.

Het invoeren van transacties

De transactie moet in twee rijen ingevoerd worden:

In de eerste rij:

• Voer het rekeningnummer in voor de in het buitenland verworven prestatie (Debet kolom), een kas- of bankrekening of een leveranciers-rekening (Credit kolom), het netto faktuurbedrag (Bedrag kolom) en de ICP21 code (BTW-code kolom)

In de tweede rij:

• Voer het rekeningnummer in voor de Hulprekening bij boeken ICP (810) , zowel in de Debet als in de Credit kolom, hetzelfde bedrag als in de eerste rij, nl. 1000,- EUR (Bedrag kolom) en de IG21-1 code in de BTW-code kolom voor de verwerking van de verhaalbare BTW.

Contant betaalde BTW bij import

Voor de administratie van de bij de douane betaalde, terug te krijgen BTW, moet de gebruiker het volgende doen:

In de BTW-codes tabel moet een BTW-code met bedragtype 2 voorkomen waarmee het BTW bedrag op 100% geboekt kan worden

Opmerking: In de BTW-codes tabel kunnen nieuwe codes toegevoegd worden. Als het nodig is BTW terug te krijgen bij de douane, voor de BTW van 21%, kan men een nieuwe code toevoegen, bijvoorbeeld D21-2 met bedragtype 2 en 21% als percentage.

Voer in de Transactiestabel het contante bedrag in credit, het betaalde BTW bedrag en de overeenkomstige BTW-code in.

Het programma berekent het BTW bedrag op 100% zonder dat er een verschil in de boekingen ontstaat.

BTW betaald bij import door de transporteur

De procedure is hetzelfde als in het vorige geval, behalve dat de transacties over meerdere rijen plaatsvinden omdat op het moment dat de factuur van de transporteur betaald wordt de verzendingskosten en de invoerrechten meengenomen moeten worden.

Voorbeeld:

Betaling van de factuur van de transporteur voor een totaal van € 359: € 150 voor de invoerrechten en verzendkosten en € 209 voor BTW vooruitbetaald bij de douane.

There are two methods, established by the Federal Tax Administration, for the collection of the Value Added Tax (VAT):

• Method according to the issued invoices - the determination of the VAT amount takes place at the moment the suppliers' invoices are received and the clients' invoices are issued.
• Method according to the cash received - the determination of the VAT takes place at the moment that received payments for invoices or the payment of invoices appear. All those subject to VAT that manage the accounting operations with this method (after receiving the authorization from the office in charge), need to comply with the following regulations:

1. During the accounting period, clients and suppliers should not be entered.
2. The income/expenses need to be entered at the moment the payment is being registered.
3. The VAT code needs to be inserted on the same row as the income or expenses account.

Practical example showing how to enter transactions during the year

Note:
If you want to equally manage customers/suppliers, you can use the cost centers. In this case, the clients/suppliers management remains separated from the Balance Sheet.

As for the transitory assets or liabilities (invoices issued for income/expenses, but not yet received or paid), only at the end of the year, carrying forward of the outstanding invoices of suppliers and clients is allowed. These issues are defined by the VAT regulations (Wegleitung 2001 zur Mehrwertsteuer, Z 964, Seite 219).

Starting from here, we present you one of the possible solutions:

Transitory assets or liabilities es at the end of the year
At the end of the year, in order to exactly establish the profit or the loss of the accounting year, one needs to enter the transitory assets or liabilities:

• Expenses and income that refer to received and issued invoices at the end of the year, including outstanding projects, that will be paid and received in the following year.

In this case, pay attention to not insert the expenses and income with the VAT code, for in the VAT report, the recoverable VAT and the VAT due have to be shown in the VAT report of the first quarter of the next year.

In order to establish just the part of the expenses and the income (so without VAT) and entering the transaction correctly, one has to:

In the Assets and Liabilities

• In the Assets, open the account "Open client accounts"
• In the Liabilities, open the account "VAT on open client accounts"
• In the Liabilities, open the account "Open supplier accounts"
• In the Assets, open the account "VAT on open supplier accounts"

In the expenses and income

• In the expenses, open the account "Expenses for open supplier accounts"
• In the income, open the account "Income for open client invoices"

In order to enter the transaction of the suppliers on 31.12....., one has to make an entry on several rows:

• Enter in debit on the account "Expenses for open supplier accounts" the expense without VAT, without VAT code
• Enter in debit, on the account "VAT on open supplier accounts" the recoverable VAT amount
• Enter in credit, on the account "Open supplier accounts" the total amount (VAT included)

In the following year on 01.01..... the preceding operation needs to be closed, so the transaction is as follows:

• Enter in debit, on the account "Open suppliers accounts" the total amount (VAT included)  
• Enter in credit, the expense without VAT, without VAT code
• Enter in credit, on the account "VAT on open supplier accounts" the recoverable VAT amount

At the moment the supplier's invoice is getting paid, the user has to enter the transaction as shown in the example at the beginning of this page, by inserting the VAT code as usual.

For the transitory client invoices, the same procedure is being applied, but by entering on the preconfigured accounts related to the open client accounts.

New forms for the VAT return

Banana Accounting Plus automatically prepares the VAT returns and the electronic transmission to the VAT Authority. This is not possible in Banana Accounting 8.  In the new Banana Accounting Plus version, there are extensions to prepare in an easy and quick way:

• Swiss VAT tax report - effective method
• Swiss VAT tax report - Flat tax rate method
• Electronic XML VAT tax report - transmission to the VAT Authority

We advise you to immediately switch to Banana Accounting Plus and take advantage of the many new features.

Content not available in English.
This content is available in German, French and Italian.

New forms for the VAT return

Banana Accounting Plus automatically prepares the VAT returns and the electronic transmission to the VAT Authority. This is not possible in Banana Accounting 8.  In the new Banana Accounting Plus version, there are extensions to prepare in an easy and quick way:

• Swiss VAT tax report - effective method
• Swiss VAT tax report - Flat tax rate method
• Electronic XML VAT tax report - transmission to the VAT Authority

We advise you to immediately switch to Banana Accounting Plus and take advantage of the many new features.