Export and Print Intrastat Reports

Note

In the 2022 release wave 2, Business Central had a redesigned Intrastat experience with enhanced features. Learn more about new Intrastat experince at the Set Up Intrastat Reporting article. This article describes the previous functionality and it can only be used if you haven't upgraded your Business Central and are using some old versions.

The new Intrastat feature will be enabled automatically as of the 2024 wave 2 release while the old Intrastat feature will be deprecated.

Intrastat reporting is required throughout the European Union (EU) and must follow local requirements, such as specific formats and files. All companies in the EU must report their trade with other EU countries/regions. The movement of goods must be reported to the statistics authorities (Statistisches Bundesamt) every month, and a report must be delivered to the tax authorities.

For Intrastat reporting, you must provide paper reports and files, which must be in ASCII format for Germany. Business Central includes reports and batch jobs that generate all of the information that must be sent to the German tax authorities. This information automatically includes both receipt and delivery of goods. The Intrastat file contains information from the lines in the Intrastat journal.

To print the German Intrastat checklist

  1. Choose the Lightbulb that opens the Tell Me feature. icon, enter Intrastat Journals, and then choose the related link.

  2. In the Batch Name field, select the required journal batch name.

  3. Choose the Checklist Report action.

  4. On the Intrastat - Checklist DE page, on the Options FastTab, select the Show Intrastat Journal Lines check box.

    Important

    If you clear the Show Intrastat Journal Lines check box, the report displays only the information that must be reported to the tax authorities, and not the lines in the journal.

  5. Optionally, on the Intrastat Jnl. Batch FastTab, select the appropriate filters.

  6. Optionally, on the Intrastat Jnl. Line FastTab, select the appropriate filters.

  7. Choose the Print button to print the Intrastat checklist or choose the Preview button to view it on the screen.

To print the German Intrastat form

  1. Choose the Lightbulb that opens the Tell Me feature. icon, enter Intrastat Journals, and then choose the related link.
  2. In the Batch Name field, select the required journal batch name.
  3. Choose the Form action.
  4. Optionally, on the Intrastat Jnl. Batch FastTab, select the appropriate filters.
  5. Optionally, on the Intrastat Jnl. Line FastTab, select the appropriate filters.
  6. Choose the Print button to print the Intrastat checklist or choose the Preview button to view it on the screen.

To export Intrastat information to a disk

  1. Choose the Lightbulb that opens the Tell Me feature. icon, enter Intrastat Journals, and then choose the related link.

  2. In the Batch Name field, select the required journal batch name.

  3. Choose the Make Diskette action.

  4. On the Options FastTab, in the Path field, enter the full path and the name of the file to which you want to write the information.

    Optionally, on the Intrastat Jnl. Batch FastTab, select the appropriate filters.

  5. To export the file, choose the OK button.

The Intrastat information is exported, and you can either save the data to a file, or you can open the file in the appropriate program.

When the file is exported, the Reported check box on the Intrastat Jnl. Batches page will be selected, and the Internal Ref. No. field on every entry in the journal will be filled in. You can manually change the contents of the field. For example, you can make changes when you need to run the report again. For more information, see Intrastat Jnl. Batch.

See also

VAT Reporting
Report VAT to Tax Authorities Export and Print Intrastat Reports
Germany Local Functionality
Set Up Intrastat Reporting

Find free e-learning modules for Business Central here