This extension allows you to:

• Create the Netherlands VAT Statement form preview.
• Create a report with the annual overview of the VAT periods
• Update your VAT table

Installing the extension

Before being able to use the extension for the creation of the VAT reports, the following steps must be taken:

    Install or update Banana Accounting Plus on your computer and subscribe to the Advanced Plan.
    Install the extension BTW Nederland [BETA]:
        Menu Extensions → Manage Extensions.
        Select Nederland in the country field.
        Select Online → Productivity.
        Select from the list BTW Nederland.
        Click on the Install button on the right.

Once installed, the extension is available under the menu item Extensions, which is only visible in an accounting with VAT.

Setting the data

Before you begin, you must set up some parameters of the accounting file, which are necessary for the transmission of VAT data.

File properties

In the File menu → File properties (Basic data), insert:

• The name of your company
• The Address
• Your VAT Number

This information is displayed at the top of the reports.

Update the VAT table

If you have an outdated version of the VAT Codes table with the current rates, you need to update your VAT table. To know if your table is outdated, check whether there are groups in the Gr1 column of your VAT table, these groups correspond to those on the Official vat form.

Generate reports

The reports are created following the structure of the official VAT declaration form for the Netherlands, VAT codes that are not included in the standard ones are not taken into account by the extensions.

• Generate the VAT Statement form
• Generate the VAT Annual overview
• Update the VAT table

Rounding Differences

In the VAT form, the amounts of the groups can be rounded to the nearest whole number for benefit, this is already done automatically in reports. At the bottom of the statement, a control section has been added to show the VAT total in the accounting and the difference between the VAT total in the accounting and the rounded VAT total in the statement.

Data transmission

From 1 January 2022, the  VAT declaration for the Netherlands can be made on the new portal Mijn Belastingdienst Zakelijk.

Complete the official Online form by copying the data from the report printed in Banana accounting. You can save and print the file using the icons at the top of the report.

Messages

• VAT code without Gr1. Each vat code must have a group assigned in the Gr1 column, if you see this message, check in your VAT codes table that all codes have a group assigned. After this message has been displayed the report will still be created, but with the risk that some information will be missing.
• The VAT codes table is already updated to the last version. Your VAT codes table already has all the groups in the Gr1 column up to date, in this case no changes are made to your table.

Export naar de Nederlandse Auditfile

• Deze BananaApp exporteert de boekhoudingsgegevens naar een Nederlands Auditfile bestand in een XAF formaat.
• Het is nog een Beta Versie.
• We ontvangen daarom ook graag uw terugkoppeling.
• Het is belangrijk voor ons om te weten of u de app gebruikt heeft en of deze goed werkt.
• Deze BananaApp is ontwikkeld als open source software.
  Source en licentie zijn te vinden in de GitHub repository
  Terugkoppeling en ideeën zijn welkom.

De Auditfile App installeren en gebruiken

1. Download en installeer de Banana 9.0.4
2. Open het programma Banana en uw boekhoudbestand
3. Menu Apps -> Apps beheren...
4. Kies taal nl en Land Netherlands
5. Kies de NL Auditfile Financiëel (BETA) app
6. Klik Installeren
   
   
    
7. Bevestig de installatie
   
   

Boekhoudbestand voorbereiding

• Open uw boekhoudbestand in Banana Boekhouding en ga via menu Bestand naar Bestands- en boekhoudingseigenschappen.
• Vul in de tab Adres het adres en de bedrijfsinformatie helemaal in.
  Opgelet! Bij het invullen van het veld "land", niet meer als 2 letters invullen: vul òf de code van het land in (NL) òf laat het veld leeg. Indien u meer dan twee letters in dit veld invult geeft het programma een foutmelding.
  
  
   
• Vul in de tab Boekhouding de begin- en einddatum van de boekhouding in.
  
  
   
• In Banana, ga naar Programmaopties via het Extra menu en selecteer het tabblad Geavanceerd.
  Voeg de "xaf" bestandsextensie in in het veld Extensies van bestanden die veilig worden geacht.
  

De BananaApps "Auditfile" gebruiken

• Open uw boekhoudingsbestand in Banana Boekhouding.
• Controleer uw boekhouding met het commando Boekhouding controleren... van het menu Rapporten.
• Via Menu Apps: voer de BananaApps "NL Auditfile Financiëel (BETA) " uit.
• In het eerste dialoogvenster, voer de gewenste periode voor de auditfile in en bevestig deze.
• Selecteer de map op uw computer waar u de XML output wenst op te slaan.
  De App maakt standaard een bestand aan met de begin en eindddatum van de periode, bijvoorbeeld "auditfile_nl_20180101_20181231.xaf".
• De boekhoudingsgegevens worden geëxporteerd naar het bestand dat u hebt aangegeven.
• Geef aan of u het aangemaakte bestand onmiddelijk wenst te bekijken of niet.
  
  

Resources

• Downloadable voorbeeld .ac2 file
• Auditfile script

Video: Standard Audit File Reader (3:43)

Big advantages for accountants:

• Access to and display of the data from the SAF-T file.
• Accounting data on the computers of the auditors.
• Save time to do the audit.
• Work faster.
• Improves efficiency.

The current "Import Netherland's Audit File" extension is in Beta version. Changes may be made in the future.
We kindly ask our users to cooperate with us to improve the app.

The BananaApp offers the possibility to import the following data from the SAF-T file into Banana accounting:

• Company Information
• General ledger accounts.
• Customer accounts.
• Supplier accounts.
• Transactions.
• VAT codes

To use this app and import the data correctly, it is necessary to follow the following steps:

1. Install Banana accounting Plus (required Advanced version ).
2. Install the extension "Import Netherland's Audit File [BETA]".
3. Select the menu Item Tools and choose the command Create file from external data.
4. Select the .xml audit file.
5. Check the accounting  and save the .ac2 file.

See how the SAF-T Reader work

If you don't have any audit file and you want to see how the SAF-T Reader  work, we make available some test file you can experiment with.

• Netherland SAF-T example file (.xml)

Company Information

The extension retrieves the company data present in the audit file and automatically inserts them into the properties of the accounting file. you can view them from the File->File and accounting properties menu.

Accounts

When the extension is run, the script retrieves the following data from the audit file:

• Ledger accounts
• Account number
• Description
• Opening and Current balance
• Customer and supplier accounts
• Description
• BClass
• Address

All the requested data is then inserted into the Accounts table  Accounts are imported on top of the table , while customers and suppliers are entered at the end.

Use views to display the different fields in the table that interest you, such as the Address view with all the information about customers and suppliers.

Transactions

Imported transactions are grouped by number.  The number of each transaction can be seen in the "Doc" column.

• Date: date of the transaction
• Doc: document number (rows with the same doc number belong to the same transaction)
• Description: description of the transaction
• Debit Account: debit account of the transaction
• Credit Account: credit account of the transaction
• Amount: amount of the transaction
• Vat Code: Used in the registration, is imported inside two square brackets '[]' so that the code remains only figurative, since the vat has already been calculated in the registration. for more information see the page dedicated to VAT Management.

Vat Codes

VAT codes are entered in the 'VAT Codes' table so that they can be used in the records.

• Vat Code: The code identifying the type of rate.
• Description: The description of the rate.
• %Vat: The VAT rate.

For more information on how the vat table works, please visit the page VAT Codes Table.

After import

When the import processes are finished, the accountant can use the chart of accounts, the transactions, the accounting properties and finally all the functions of Banana accounting to help him do his job.

References

• Softwarepakketen.nl audit file

Standard Audit File Reader

• see Standard Audit File Reader documentation.

Feedback and contacts

The SAF-T Reader is a new product. We welcome any feedback on how to improve it or to provide extensions that could make auditing and analytics more easy.

Kindly contact our costumer service specifying "audit file" and the country extension you are using.  Also briefly indicate your question or suggestion.

This import extension allows you to import ING Bank transactions into Banana. You can install the extension from the menu Extensions->Manage Extensions.

Requirements for use

• Banana accounting Plus with the Advanced Plan.
• ING Bank also provide files with standard format ISO20022, to import files with this format you can install the relative Import extension for ISO20022 Camt 052, 053, 054, wich is available also with the Professional plan. Unfortunately, these formats do not always provide satisfactory information for accounting purposes; depending on the bank, the data included may be incomplete or missing. We therefore recommend using specific *.csv files whenever possible.

Export procedure

Export your banking transactions in *.csv format by accessing your online bank account.

• Open the accounts section and select the account for which you want to export movements.
• Export your account movements by choosing the *.csv format.
• Save the file on your computer. It is advisable to save the file in a place where you can easily find it later.

Import procedure

• Via the Actions → Import to accounting → select Import transactions box
• Choose the extension to be used, in this case 'ING Bank - Import bank account statement (*.csv)'.
• With the Browse button, choose the file from which to import the transactions.
• Press OK Button.

For more details see Import transactions page.

Error Messages

• Unrecognised *.csv file format: The format of the *.csv file you are trying to import does not match any of the formats associated with this filter:
  • Check that you have chosen the correct file.
  • If the file you have chosen is correct, it may be that our filter requires updating.

• This extension requires Banana Accounting+ Advanced: You are trying to use the extension with a licence other than the one requested, please upgrade to the Advanced Plan to be able to use the functionality of this filter.

Send feedback

It may happen that the format of the *.csv file is updated and as a result the filter no longer functions correctly. Send us feedback and attach an example file (*.csv) with the new format and we will proceed to update the filter.

The updated version of the filter can be found on the following page: ING Bank - Import bank account statement (*.csv)