EU Sales list for Finland

This article provides information about the European Union (EU) sales list report for Finland. The Finnish EU sales list report contains information about the sale of goods and services for reporting in text format. The following fields are included on the Finnish EU sales list report:

  • EU sales list header:
    • Date and time of the report creation
    • Information about the software
    • Company VAT ID without country/region code
    • Reporting period
    • Lines number
  • EU sales list lines:
    • Customer VAT ID
    • Sum of all item invoices by customer
    • Sum of all service invoices by customer
    • Sum of triangular trade by customer
    • Line number

Setup

For general setup information, see EU Sales list reporting.

Note

The value from the Tax registration number field on the Tax registration FastTab of the Legal entities page is used in the .xlsx file for the EU sales list report.

Set up information about the company

Create a registration type, and assign it to the VAT ID registration category for Finland and all the countries or regions that your company does business with, as described in Registration IDs.

  1. In Microsoft Dynamics 365 Finance, go to Organization administration > Organizations > Legal entities.

  2. In the grid, select your company.

  3. On the Action Pane, select Registration IDs.

  4. On the Registration ID FastTab, select Add.

  5. On the Overview tab, in the Registration type field, select the registration type that you created.

  6. Enter your company's value-added tax (VAT) ID.

  7. Optional: On the General tab, in the General section, change the period that the VAT ID is used for.

  8. Close the page.

    Note

    If the Routing number field in the Codes section of the Bank account information FastTab or the VAT exempt number export field in the Intrastat section of the Foreign trade and logistics FastTab is set (that is, it isn't blank), the value (primarily the value of the Routing number field) will be used, instead of the VAT ID that you created in step 6, in the .txt file for the EU sales list report.

Import Electronic reporting configurations

  • In Microsoft Dynamics Lifecycle Services (LCS), import the latest versions of the following Electronic reporting (ER) configurations for the EU sales list:
    • EU Sales list model
    • EU Sales list by columns report
    • EU Sales list by rows report
    • EU Sales list (FI)

For more information, see Download Electronic reporting configurations from Lifecycle Services.

Set up foreign trade parameters

  1. In Finance, go to Tax > Setup > Foreign trade > Foreign trade parameters.
  2. On the EU sales list tab, set the Report cash discount option to Yes if a cash discount should be included in the value when a transaction is included in the EU sales list.
  3. On the Electronic reporting FastTab, in the File format mapping field, select EU Sales list (FI).
  4. In the Report format mapping field, select EU Sales list by rows report or EU Sales list by columns report.
  5. On the Country/region properties tab, select New, and specify the following information:
    • In the Country/region column, select FIN.
    • In the Country/region type column, select Domestic.
  6. List all the countries or regions that your company does business with. For each country that is part of the EU, in the Country/region type field, select EU.

Work with the EU sales list

For general information about the types of transactions that are included in the EU sales list, and how to generate the EU sales list report and close the EU sales list reporting period, see EU Sales list reporting.

Generate the EU sales list report

  1. Go to Tax > Declarations > Foreign trade > EU sales list.

  2. Transfer transactions.

  3. On the Action Pane, select Reporting.

  4. In the EU sales list reporting dialog box, on the Parameters FastTab, set the following fields.

    Field Description
    Reporting period Select Monthly.
    From date Select the start date for the report.
    Generate file Set this option to Yes to generate a .txt file for your EU sales list report.
    File name Enter the name of the .txt file.
    Generate report Set this option to Yes to generate an .xlsx file for your EU sales list report.
    Report file name Enter the name of the .xlsx file.
  5. Select OK, and review the generated reports.

Example

For information about how to create a general setup, create postings, and transfer transactions by using the DEMF legal entity for Finland, see Example for generic EU Sales list. However, for this example, create FI111222999 as the company's VAT ID.

Create an EU sales list report

  1. Go to Tax > Declarations > Foreign trade > EU sales list.

  2. On the Action Pane, select Reporting.

  3. In the EU sales list reporting dialog box, on the Parameters FastTab, set the following fields:

    • In the Reporting period field, select Monthly.
    • In the From date field, select 8/1/2021 (August 1, 2021).
  4. Select OK, and review the report in text format that is generated. The following tables show the values on the example report.

    EU sales list header

    Field Value Comment
    000 VSRALVYV The file indicator.
    198 14092021181209 The date and time when the report was created (September 14, 2021, at 18:12:09 in this example).
    048 Microsoft Dynamics Ax The software.
    014 #######-#_AX The software ID.
    010 111222999 The company VAT ID without the country/region code.
    052 8 The reporting month.
    053 2021 The reporting year.
    001 2 The number of lines.

    EU sales list lines

    Field Line 1 value Lina 2 value Comment
    102 SE ES The country/region code.
    103 100200300400 12345678 The customer VAT ID without the country/region code.
    210 0 120 The sum of all item invoices by customer.
    211 240 0 The sum of all service invoices by customer.
    212 0 0 The sum of triangular trade by customer.
    009 1 2 The line number.
    999 1 The end of file identifier.
  5. Review the report in Excel format that is generated.

    EUSL report for Finland in Excel format.