Vat Number

This article explains in detail how the relation VAT number import file works. Please be advised that reading the relation VAT number data should only be done after the general relation data has already been imported into Qbil-Trade. The relation VAT number template file has columns that are generated based on relation data. Without this relation data, Qbil-Trade is not able to link the VAT number data to the correct relation.

For general guidelines on importing root data, please refer to the step-by-step instructions in the article.

  • Select the “VAT-number” in the drop-down.
The download and upload of a root data template
  • Download the template using the “Download Excel template” button. You can start adding your data to the downloaded template.

Column legend #

Following is the column legend of the relation VAT number template.

  • company_name: This is a drop-down menu where you need to indicate to which company the VAT number relates. You can add more than VAT numbers to a relation.
  • country: This is a drop-down menu where you select the country of the VAT registration number.
  • vatNumber: This is the VAT number of the relation for the country selected in the “country” field.
What are your feelings
Updated on November 12, 2024
Table Of Contents

FAQ'S

Accounts and Financial

  • Unable to find invoice for export in current month

    Invoices are displayed on the export screen in a particular month. The month of the invoice is taken from the invoice date and not from another date, such as the due date.

    The invoice date is therefore leading in terms of month for export periods. For example: Invoice date 22-05-2022 and due date 15-06-2022. This invoice will appear in the export under the month May.