Report Trade with Customers and Vendors in Blacklist Countries-Regions

You must submit a periodic report of transactions with customers and vendors in certain countries/regions that the Italian government has identified in a blacklist. The blacklist communication report must be submitted to the Italian Revenue Agency to help prevent VAT fraud. Transactions that are subject to blacklist reporting include the following:

  • Purchases of goods or services
  • Sales of goods or services

On a monthly or quarterly basis, you must generate the blacklist communication report for transactions with countries/regions that have privileged taxation and send it to the Italian Revenue Agency. The Italian Revenue Agency decides which countries/regions are included on the blacklist. You can view or change countries/regions on the blacklist by using the Countries/Regions page. The periodic report includes only transactions that have an amount above a certain threshold. The threshold amount calculation is applied at the document level. For more information, see the Italian Revenue Agency.

Before you can submit the periodic report, you must set up Business Central.

To update the relevant countries/regions

  1. Choose the Search for Page or Report icon, enter Countries/Regions, and then choose the related link.

  2. Choose the relevant country/region, and then select the Blacklisted check box.

    Note

    You may not be able to see the Blacklisted field. In that case, you must add it to the view.

  3. Enter the Foreign Country/Region Code for the blacklisted country/region.

For a list of relevant countries/regions and codes, see the Italian Revenue Agency.

To specify the current threshold amount

  1. Choose the Search for Page or Report icon, enter VAT Posting Setup, and then choose the related link.

  2. On the VAT Posting Setup page, choose the Blacklist Comm. Amount action.

  3. On the Blacklist Comm. Amounts page, fill in the fields as described in the following table.

    Field Description
    Name Specifies the name of the template, Blacklist.
    Description Specifies a description of the template, Blacklist Communication.
    Form ID Specifies the page where you set up the list of transactions for the blacklist communication, 12110.
    VAT Statement Report ID Specifies the report that prints the list of transactions for the blacklist communication, 12128.
    VAT Stat. Export Report ID Specifies the report that exports the list of transactions for the blacklist communication, 12129.
  4. Optional. Select the VAT Statement template, and then choose the Statement Names action. You can provide the template with a name and description. Otherwise, the template will have the name Default when you access it on the Blacklist Communication page.

Creating the List of Transactions

Depending on the size and type of company, you must generate and submit a report of transactions with vendors in blacklisted countries/regions on a monthly or quarterly basis. A suggested mapping of transactions to Business Central accounts is provided in the following procedure, based on Spesometro 2013.

To set up the template to create the list of Blacklist transactions

  1. Choose the Search for Page or Report icon, enter Blacklist Communication, and then choose the related link.

  2. In the Name field, select the relevant VAT statement name.

  3. Fill in the lines with the relevant information as described in the following table.

    Field Description Data Type
    Row No. Specify a row number. To enable correct filtering, we recommend that you number rows as follows: 1001..1006, and so forth. Code
    Description Enter a description of the line. You can enter up to a maximum of 50 characters.

    The types of transactions that you are required to report include the sales and purchase of goods and services. These transactions can be taxable, non-taxable, or exempt. Also subject to reporting are invoices for transactions that are not subject to VAT.

    Finally, you must also include information for credit note transactions.
    Text
    Type Specify the Type of the account that the blacklist report will include, for example, VAT Entry Totaling. Option
    Blacklist Country/Region Transaction Select the check box to include information from VAT entries that originate with a person or organization that has their residence in a blacklist country/region. In general, only select the check box when the Type of the line is VAT Entry Totaling.

    If the check box is not selected, Business Central only retrieves non-blacklist items.
    Boolean
    Gen. Posting Type Select a posting type. For the blacklist communication report, you can choose any of the options, but typical choices are one of the following:

    Sale

    Purchase

    If you leave the field blank, Business Central will only return VAT Statement lines that have this field blank as well.

    If you choose the Type VAT Entry Totaling, then in this field, you can only choose among Purchase, Sale, and Settlement.
    Option
    EU Service Specify whether the entry total represents sales of services to other EU countries/regions. Boolean
    Document Type Specify a document type. You can choose any of the options, but typical choices are one of the following:

    Invoice

    Credit Memo

    If you leave the field blank, then Business Central returns all document types.
    Option
    Refers To Period Specify what period the documents refer to. When you export data and you have not specified a date, the setting in this field is ignored.

    If you have leave this field blank, then Business Central returns those entries that have this field blank as well. In addition, it returns those entries that are without reverse sales for VAT Entry Totaling.
    Option
    VAT Bus. Posting Group Specify a VAT Business Posting Group. Fill in this field when the Type of the line is VAT Entry Totaling.

    If you leave this field blank, then Business Central returns entries with any specified group.
    Code
    VAT Prod. Posting Group Specify a VAT Product Posting Group. Fill in this field when the Type of the line is VAT Entry Totaling.

    If you leave this field blank, then Business Central returns entries with any specified group.
    Code
    Amount Type Specify the type of the Amount that is being reported. Options include:

    Base

    Amount

    If you leave this field blank, then Business Central returns no information.
    Option
    Row Totaling Specify which rows are to be totaled. For example, you can enter 1001..1006 to total those rows. Text
    Round Factor Specify a rounding factor that is used to round the VAT entry amounts. Option
    Calculate with Specify whether to calculate the amount with a sign or the opposite sign. Option
    Print Specify if you want to print information from the line. Boolean
    Print with Specify whether to include the sign of the amount when you print. Option
    Blacklisted Comm. Field Specify the field that the VAT totaling should map to in the file to be exported. Valid entries are limited to what is defined in the Spesometro 2013: BL003001 – BL008002. Important: The Blacklisted Comm. field can contain only the currently required field names that are specified by Spesometro. If you specify another field name, Business Central account fields to the same Blacklist Comm. Field value, the export of the data will be the sum of those lines. The printout will list each line. Code
    New Page Specify if you want to insert a new page after the line when you print the information. Boolean

The printed report includes all transactions that meet threshold requirements. It does not include those transactions that do not.

To create and print the list of transactions

  1. Choose the Search for Page or Report icon, enter Blacklist Communication, and then choose the related link.

  2. In the Name field, select the relevant VAT statement name.

  3. Fill in the lines with the relevant information. See the procedure for setting up the Blacklist template.

  4. Choose the Print action.

  5. Optionally, on the VAT Statement Line FastTab, set the relevant filters.

  6. On the Options FastTab, fill in the fields as described in the following table.

    Field Description
    Starting Date Optional. Enter the start date for the blacklist report, which is based on the date that the operations occurred.
    Ending Date Enter the end date for the blacklist report.
    Include VAT Entries Specify if the list of transactions must include open or closed VAT entries or both open and closed VAT entries.
    Include VAT Entries Specify if the list of transactions must include VAT entries that are in the specified VAT period or must also include VAT entries that are from previous periods.
    VAT Period Enter the time that defines the VAT period for the blacklist report.
    Source Type Optional. Enter the source type of the blacklist transactions. The options include Customer and Vendor. If nothing is selected, both groups are included.
    Source No. If you choose a Source Type, then enter the identification number of the source transaction. If nothing is entered, then all vendors or customers are included.
    Name Read-only. Specifies the name of the organization.
  7. Choose the Print button to print the report, or choose the Preview button to view the results.

    Note

    The printed report includes all transactions that meet threshold requirements. It does not include those transactions that do not.

To preview and export the list of transactions

  1. Choose the Search for Page or Report icon, enter Blacklist Communication, and then choose the related link.

  2. In the Name field, select the relevant VAT statement name.

  3. Fill in the lines with the relevant information. See the procedure for setting up the Blacklist template.

  4. On the Navigate tab, choose the Preview action. You can review the information to make sure that your mappings have provided you with the information that you expected.

  5. Choose the OK button to close the page

  6. Choose the Export action.

  7. Optionally, on the VAT Statement Line FastTab, set the relevant filters.

  8. On the Options FastTab, fill in the fields as described in the following table.

    Field Description
    Starting Date Enter the start date for the blacklist report.
    Ending Date Enter the end date for the blacklist report.
    Include VAT Entries Specify if the list of transactions must include open or closed VAT entries or both open and closed VAT entries.
    Include VAT Entries Specify if the list of transactions must include VAT entries that are in the specified VAT period or must also include VAT entries that are from previous periods.
    VAT Period Enter the time that defines the VAT period for the blacklist report.
    Communication Type Enter the communication type for the blacklist export. The options include , Corrective and Cancellation.

    If you enter Corrective, then a full report will be generated for the specified period, but you have the option to overwrite a previously submitted report.

    If you enter Cancellation, then you have to provide the values from the previously generated report and a new report will be generated.

    You enter information about the corrective or cancellation action in the Substitution Data group. Fill in the following fields, using information that was that was provided by the Italian Revenue Agency (IVA) in its communication with you when you originally submitted your blacklist report:

    - Substitution Report No.
    - Substitution Doc. No.
    Period Type Specify if the report is monthly or quarterly.
  9. Choose the OK button.

    Note

    The exported file includes those transactions that are above the current threshold amount.

You can now submit the list of transactions to the Italian Revenue Agency. If you have more than 1500 records, multiple files will be exported.

See Also

Italian VAT