Working with statutory Reports
To import and export data for electronic tax reporting or other necessary documents, you can configure statutory reports in Business Central. This functionality allows you to configure a list of reports whose data needs to be stored or provided to tax authorities in electronic reporting format.
Getting Started with statutory Reports
Before getting started with statutory reports, you need to perform some configurations.
Configuring the Statutory Report Setup Page
First, configure the settings on the Statutory Report Setup page. Follow these steps:
- Click the
button to open the Search function and enter Statutory Report Setup. Click on the corresponding link. - Fill in the following fields:
| Field | Description |
|---|---|
| Group End Separator | Specify a set of characters that act as the separator between blocks in the electronic report. |
| Fragment End Separator | Specify a set of characters that act as the separator between segments in the electronic report. |
| File End Separator | Specify a set of characters that indicate the end of the file in the electronic report. |
| Dflt. XML File Name Elem. Name | Specify the name of the XML element that will be used to generate the electronic file name. |
| Report Export Log Nos | Specify the number series to be used for generating entries in the export journal. |
| Report Data Nos | Specify the number series to be used for generating entries in the report data list. |
Configuring Format Versions
Next, you need to define and configure format versions for the reports. Follow these steps:
- Click the button to open the Search function and enter Format Versions. Click on the corresponding link.
- Fill in the following fields:
| Field | Description |
|---|---|
| Code | Specify the code for the format version. |
| Report Description | Specify the name of the report for which the format is being configured. |
| Report Type | Specify the type of the report being configured: either Accounting or Tax. |
| XML File Schema | Enter the XML schema file name after importing it. |
| XML File Name Element | Specify the name of the XML element to be used for generating the file name. This can be automatically filled with the value from the XML File Element Name Standard field. |
| Version No. | Specify the version number of the format. |
| Usage Starting Date | Specify the date when the format version starts to be used. |
| Usage First Reporting Period | Specify the first reporting period for which the format version is used. |
| Usage Ending Date | Specify the date when the format version stops being used. |
| Comment | Enter any additional comments or information about the format version in this field. |
After defining the format version list, you need to upload their XML schemas. To do this, click Import XML Schema while being on the row of the respective format and upload the file from your computer.
Whenever there is a change in the tax declaration or accounting report form, or when the format of its submission changes, you need to configure a new entry for the new format version. The old format versions are required for generating correction reports for previous periods.
Definition of Report List
On the Statutory Reports page, you need to define a list of reports that need to be stored and submitted to the tax authorities. To do this, follow these steps:
- Click the button to open the Search function and enter Statutory Reports to access the corresponding link.
- Fill in the fields listed below:
| Field | Description |
|---|---|
| Code | Specify the report code. |
| Description | Provide the report name. |
| Format Version Code | Select the appropriate version from the configured format versions. If an XML schema is defined for the selected format, XML element rows will be generated. |
| Header | Set this option if this row is a group name for the reports. |
| Report Type | Specify the report type - Accounting, Tax. |
| Sender No. | Specify the code of the employee responsible for submitting the report to the tax authority. |
| Active | Check this option if this report is active in the current period. It is recommended to create a new row for a new version of the report and mark it as Active. The flag should be removed for the old version of the report. It is recommended to keep old versions of reports to be able to generate revised reports for previous periods. |
| Ending Date | Specify the date when this report expires. |
Setting up the Structure of a Statutory Report
The configuration of Statutory reports consists of the following steps:
- Setting up the list of tables for the Statutory report.
- Configuring the table structure.
- Establishing the link between tabular data and internal data sources.
- Configuring XML element rows.
Setting up the List of Tables for the Statutory Report
Each report can be represented in the form of tables with indicators. To define the list of tables and their configuration, go to the Statutory Reports page, click on the corresponding report, and select Related > Setup > Tables. On the Statutory Report Tables page, fill in the following fields:
| Field | Description |
|---|---|
| Code | Specify the table code. |
| Description | Specify the table description. |
| Scalable Table | Check this option if the table is expandable, i.e., it contains a pre-determined unknown number of rows. |
| Vertical Table | Check this option if the table is vertical, i.e., the table rows are arranged in multiple rows of a single column. Otherwise, a vertical table fully replicates the properties of an expandable table. |
| Multipage Table | Check this option if the table spans multiple pages. |
| Page Indicator Text | Specify the text that serves as a page indicator for a multipage table. If the Multipage Table flag is set, this field is mandatory. |
| Page Indic. Requisite Row Code | Specify an individual indicator that serves as the current table indicator for a multipage expandable table. |
| Page Indication for XML | Specify the XML element(s) used as a grouping indicator when generating XML format file data. |
| Table Indicator Text | Specify the text that serves as an additional indicator for a multipage table in case the text specified in the Page Indicator Text field is insufficient for identification. |
| Parent Table Code | Specify the parent table code if the table has continuation on multiple pages. |
| Int. Source Type | Specify the internal source type for reports that retrieve data from other modules in the system. Available option: Financial Report. |
| Int. Source Code | Specify the code of the internal data source. If the source type is a financial report, provide the code of the financial report whose data will be used for preparing the Statutory report. |
Configuring Table Structure
Each table consists of rows, columns, and individual indicators. To create or edit rows and columns of the table, you can click on Rows or Columns, respectively.
Clicking on Rows will open the Table Rows page, where the following fields are filled:
| Field | Description |
|---|---|
| Description | Specifies the description of the table row. The field value will be used in automatic code generation of indicators and when viewing report data. |
| Requisites Group Name | Selects the indicator group from the structure of the electronic file that includes indicators of the current table row. This information will be used for automatic code generation of indicators in a specific block and linking the electronic file format to the table structure. |
| Inserted Requisite | Specifies if an indicator is inputted from the current row. This means that initially the indicator is not present in the report template and is entered into the report by the organization based on disclosure requirements. During the indicator code generation procedure, a separate code is formed for the inputted indicator's name. |
| Bold | Checked if the current row should be displayed in bold font on the view form. |
Note For an expandable table, only the first row is displayed on the Table Rows page.
Note
For the correct recalculation (using the Recalculate data function) of the generated report data, it is recommended to create the rows of the statutory report table identical to the rows of the financial report, including technical rows.
Clicking on Columns will open the Table Columns page, where the following fields are filled:
| Field | Description |
|---|---|
| Column Header | Specifies the column header. The field value will be used in automatic code generation of indicators. |
| Column No. | Specifies the column number in the table. The field value will be used in automatic code generation of indicators. |
Clicking on Individual Requisites will open the Table Individual Requisites page, where the following fields are filled:
| Field | Description |
|---|---|
| Description | Specifies the description of the individual indicator. |
| Row Code | Specifies the report row code, if any. The field value will be used in automatic code generation of indicators. |
| Column No. | Specifies the column number. |
| Requisites Group Name | Selects the indicator group code from the structure of the electronic file that includes the individual indicator. This information will be used for automatic code generation of indicators in a specific block and linking the electronic file format to the table structure. |
| Bold | Checked if the current individual indicator should be displayed in bold font on the view form. |
| Int. Data Source Cell Mapping | This field indicates the correspondence between the Statutory report indicator and the internal data source. |
Configuring the Link between Tabular Data and Internal Data Sources
To generate Statutory reports based on internal data sources (financial report), you need to define an internal data source for each table on the Statutory Report Tables page.
The financial report serves as the internal data source for the Statutory report. On the Statutory Report Tables page, specify the type and code of the internal data source for each table in the corresponding Internal Data Source Type and Internal Data Source Code fields.
Note: If the corresponding financial report is not available in the system, you can create it by clicking Actions > Functions > Create Account Report on the Statutory Report Tables page. The structure of the financial report will match the configured structure of the Statutory report.
To establish the link between the Statutory report data and the internal data source, use the Update Internal Data Source Link function by clicking Actions > Functions > Update Internal Data Source Link. This will automatically link the first rows/columns of the Statutory report table with the first rows/columns of the specified data source.
Note: When using the Update Internal Data Source Link function, all existing configurations will be deleted. Use this function with caution if any manual changes have been made to the automatic configurations.
Review or edit the established data link by clicking Related > Table > Internal Data Source Mapping.
To view or edit detailed information about the correspondence, click 
within the respective table field. The
following fields will be displayed in the opened window:
| Field | Description |
|---|---|
| Row Code | Code of the Statutory report row linked to the internal data source. |
| Table Code | Code of the Statutory report table linked to the internal data source. |
| Table Row Description | Name of the Statutory report row. |
| Table Column Header | Header of the Statutory report column. |
| Internal Data Source Type | Type of the internal data source. Editable field to specify a different source type for individual indicators. |
| Internal Data Source Code | Code of the internal data source corresponding to the selected type. Editable field if you need to configure an individual indicator. |
| Internal Data Source Row Description | Name of the internal data source row. Changeable value by selecting from available rows of the internal data source. |
| Internal Data Source Column Header | Header of the internal data source column. Changeable value by selecting from available columns of the internal data source. |
Setting XML Element Rows
Configure XML elements for the Statutory report after their automatic creation. Go to the XML Element Rows page by clicking the corresponding button on the Statutory Reports page.
The order of elements on this page is important and must match the order defined in the template. Otherwise, some data may be excluded from the overall XML output, and the file may not be accepted by the tax authority.
On the page, fill in and configure the necessary fields:
| Field | Description |
|---|---|
| Element Name | This field specifies the name of the XML schema element. |
| Element Type | This field indicates the type of the element. Possible values: Complex, Simple, and Attribute. Complex means that the element has nested XML elements; Simple means a regular XML element, and Attribute means that the XML element is an attribute of another element. |
| Description | This field provides a detailed description of the XML element. |
| Data Type | This field specifies the data type of the XML element. It is filled only for Simple and Attribute element types. Possible values: Empty - assigned to non-attribute components, Text - the value of this XML element will be exported as text, Integer - the value of the XML element will be exported as an integer, Decimal - the value of the XML element will be exported as a decimal number with a dot as a separator, Date - the value of the XML element will be exported as a date, the format of which is specified in the XML Export Date Format field. |
| Link Type | This field indicates the link type used in generating XML schema elements for different report structure variants. Possible values: Value - always specified for regular elements, i.e., elements with Simple and Attribute types, Table - can be specified for elements with Complex type. It is used for generating nodes for any report table. For an expandable table, it means that each row will correspond to a new node. For a vertical table, a node will be created only for the row where the current value in the Page Indicator for XML field matches. For a regular table, only one node will be created. This link type must be specified for an expandable or multi-page table that does not have subordinate tables and is not subordinate itself. The Grouping link type can be specified for elements with Complex type. This value is specified next to the node in which data grouping should be performed. For example, this link type is specified for a node associated with a grouping table. This node must have subordinate nodes associated with other tables subordinate to the main table. In this case, the grouping indicator for the main and subordinate tables must match (the Page Indicator for XML field). |
| Source Type | This field indicates the source type used to generate the element's value. Possible values: Expression - the value of the element is sourced from an expression set on the XML Element Expression Rows page, Constant - the value of the element is a constant value specified in the Value field, Table Data - the value of the element is sourced from the table data with the code specified in the Table Code field at the intersection of the row and column specified in the Linked Row Number and Linked Column Number fields respectively, Individual Element - the value of the element is sourced from the table data with the code specified in the Table Code field and the row specified in the Linked Row Number field (the Linked Column Number field is always left empty for individual indicators), Inserted Element - the value of the element is the name of an inserted element in the table with the code specified in the Table Code field and the row specified in the Linked Row Number field. The value in the Linked Column Number field must be manually set to 10000. When automatic codes are generated for indicators located at the intersection of table rows and columns and marked as inserted, the field value is set to Inserted Element. |
| Value | This field specifies the value of the element when the Source Type is set to Constant. |
| Table Code | This field specifies the table code when the Source Type is set to Table Data, Individual Element, or Inserted Element. |
| Row Link No. | This field specifies the row number when the Source Type is set to Table Data, Individual Element, or Inserted Element. |
| Column Link No. | This field specifies the column number when the Source Type is set to Table Data. For Individual Element and Inserted Element, this field is always left empty. |
| XML Export Date Format | This field specifies the date format when the Data Type is set to Date. |
Generating Data for Statutory Report, Viewing, Editing, and Importing
After configuring the table structure and indicators for the Statutory report, you can generate its data, which can then be viewed and imported into an electronic file for submission to the tax authorities.
To generate the Statutory report, you need to select the desired report and click on Create Report Data. In the opened window, you need to fill in the following fields:
| Field | Description |
|---|---|
| Data Description | Specifies the data description. By default, it is filled with the description of the selected report. |
| Creation Date | Specifies the report creation date. |
| Progressive Total | Indicates whether the report data is generated as a cumulative total: 3 months, 6 months, 9 months, or a year. |
| Periodicity | Specifies the reporting frequency. |
| Accounting Period | Specifies the tax period depending on the selected values in the Cumulative Total and Frequency fields. The Period Type field will be automatically calculated based on the specified value. |
| Period Type | Specifies the tax period type. It can be entered manually or automatically filled when the Frequency field is filled. Possible values: 1 - month, 2 - quarter, 3 - 6 months, 4 - 9 months, 5 - year. |
| Start Period Date | Displays the start date of the period based on the selected tax period. |
| End Period Date | Displays the end date of the period based on the selected tax period. |
| Amount Measure | Specifies the unit of measurement for the report data (units, hundreds, thousands). |
| Document Type | Specifies the document type: primary or correction. |
| Correction Number | Specifies the correction number if the document type is Correction. |
The generated report data can be viewed or edited.
Editing the Report Data Header
To edit certain fields of the report data header, you need to click on Manage > Edit on the Report Data List page for the desired report. The Report Data Card page will open with the following fields:
| Field | Description |
|---|---|
| No. | Displays the sequential number of the report data. Automatically assigned based on the configured series of numbers on the Statutory Reports Settings page. |
| Description | Displays the description of the report data. |
| Date Filter | Displays the report period in date filter format. |
| Status | Displays the status of the report data. The Open status is assigned immediately after importing the data. The Released status can be set by clicking the Release button. Data with this status cannot be edited. The Submitted status is automatically assigned after exporting the electronic file. |
| Period | Specifies the reporting period. |
| Document Type | Displays the code of the document type. |
| Correction Number | Displays the correction number if it is a correction report. |
| Amount Measure | Specifies the unit of measurement for the report sums. |
| Period Type | Specifies the period type. |
| Period No. | Specifies the period number. |
| No. in Year | Specifies the sequential number of the report in the year. The value is automatically generated as follows: the number of the previous report in the reporting year +1. The value of this field is part of the Document Identifier indicator and is present in the name of the reporting electronic |
Editing Report Data
On the Report Data Card page, by clicking on Overview, you can view or edit the report data on the Statutory Report Data Overview form. The following information will be displayed in the opened window:
- No. - sequential number of the report data header.
- Description - description of the report data.
- Table Code - code of the current table. You can select a different table to view its indicators.
- Show Only Changed Values - you can toggle this switch to display only changed values.
From the same Statutory Report Data Overview form, by clicking on Show Data, you can view the indicators generated based on the internal data source. On the Statutory Report Data Subform page, you can modify the sum values. To recalculate the generated data with the changes made, click Actions > Recalculate the Data. All changes will be saved in the Statutory Report Change Log.
Note:
To be able to modify or delete a Statutory report table, the report data must not be generated. You can delete report data on the Report Data List page.
If necessary, you can update the report data by clicking the Update Report Data button on the Report Data List or Report Data Card pages.
Exporting Report Data to an Electronic File
You can export the report data to an XML file. To do this, click on Export Electronic File on the Report Data List page.
Information about the performed exports and the generated files is stored in the export register. To view the log, click on the Export Log button on the Statutory Reports page.
Useful Links
Preparing financial statements using account schedules and financial statement categories