Import of amavat® file (*.csv) - error validation

To upload sales data for amavat®, use the amavat® file (*.csv):

1. Save the file to disk.

2. Go to the amavat® application to the “Data Panel” tab and the “Integration Data” section.

3. Next to the amavat® Integration Data, click the “Upload Data” button.

4. Click “Select File” and select the saved file from your computer.

5. Click “Upload File” to properly upload the file to the amavat® application.

This process may take several minutes, depending on the size of the file.

If the uploaded file is incorrect, a data validator will be run.

Errors will appear in a red box and the data loading process will be marked "Load Failed"

To see the full list of errors - download the report by clicking on the red button.

The first column of the report will show an error message.

In the next step, correct the file that was previously uploaded and upload it again to the application by clicking the “Upload data” button again.
Note that the validation may occur several times (it depends on the number of errors the file contains). The system verifies one type of error each time. The type of error is described in the first column in the file.

Correcting the file will be successful if a “Data ready” message is received and the validation is displayed in green.
Also after receiving a positive validation, a list will appear on the left side of the window with a summary of the value in net amount per country:

We will obtain detailed information in the consolidated report, which can be downloaded from the “VAT Reports” section.
This stage gives us the opportunity to accept the data with the button in the upper right corner “Confirm Data”.

When you click to accept the data, the following message will appear before the data is validated:

In addition to the errors shown, there will be warnings (marked in yellow) to show that the data is acceptable, but should be verified each time before approving the data.

Detailed alert data will be available in the report under the yellow button.