Standard Import/Export (Data Export)

Overview

The Swedish Standard Import/Export (SIE) reports are used by the Swedish tax authorities to audit a company's books. This form is not filed but requested when an audit is to start. The purpose of the report is to show details of account balances. It also shows the opening and closing of balance sheet accounts and balances of the profit and loss accounts.

In order to satisfy statutory requirements for Sweden, BPM provides an SIE file format that runs via the Workspace Client. The SIE-file format is used for sending accounting data between the company, the accountant, and the auditor. SIE is a tagged text file format, not XML.

The report uses a pre-defined filter called P&L Accounts to filter accounts into the report query.

Report Workspace

Country reports share the same workspace layout. For information on the fields and actions available in the report workspace, refer to Workspace Layout.

Navigation

To open the report workspace, select Reporting » Country Reports » Sweden » Standard Import/Export (Data Export).

Selection Criteria Dialog Box

Click the Generate Report action to open the selection criteria dialog box. This table describes the parameters you can define for the report.

Dialog Box Fields

Field	Description	Mandatory
Company No.	Restricts to only show accounts on the selected company. Accepts single value.	Yes
Chart of Accounts Type	Restricts to only show accounts on the selected Charts of Account Type. Accepts single value.
Year/Period	Restricts account transactions based on the specified period.
Reporting Structure Name	Search field that shows the list of the reporting structure available. Allows you to select the reporting structure name (for example, SIE).	Yes
Number of Previous Years	Shows comparative years. If the user selects "0" then only the current year will be shown If the user selects "1" it will shows current and previous year and so on.	Yes

File Type

Note: You must choose at least one file type.

Field	Description	Mandatory
SIE 1	Uses SIE 1 file type for the data export.
SIE 4	Uses SIE 4 file type for the data export.

Account Information

Field	Description	Mandatory
Exclude All Accounts Without Balances	Excludes accounts with zero balances.	No

Verification Item

Field	Description	Mandatory
Use Maconomy Transaction Number	Select this to replace the sequence with the Maconomy transaction number. Otherwise, the report uses combined sequence numbers in the #VER field by default.	No

Tax Number Report

Field	Description	Mandatory
Company Tax No.	This field displays the tax number associated with the company entered in the Company No. field.
Include All Company On Tax Number	The report can include data for multiple companies that use the same company tax number. Select the checkbox to consolidate accounting information into one file.	No

Dimensions for SIE 4

Field	Description	Mandatory
Include Dimensions for SIE 4 (32 Dimensions)	Enables users to include the #DIM, #UNDERDIM and #OBJEKT Includes: Customer No. Vendor No. Employee No. Job No. Activity No. Task Name Asset No. Item No. Location Name Entity Name Project Name Purpose Name Spec.1 - 10 Local Spec. 1 - 10	No

Selection Criteria Dialog Box Actions

Action	Description
Next	If applicable, click this for more prompts.
Back	Click this to return to the previous prompts.
Cancel	Click this to close the dialog box.
Ok	Click this to generate the report. If applicable, click Ok to close the dialog box.

Generate the Report

To generate the report:

Go to Reporting » Country Reports » Sweden » Standard Import/Export (Data Export).
Click Generate Report to open the Selection Criteria dialog box.
Fill in the mandatory fields for the report:
- In the Company No. field, enter or search for the company you want to report on.
- Specify the Year/Period duration to include in the report.
- Select the Reporting Structure Name.
- Enter the Number of Previous Years to include in the report.
- Choose a File Type to use.
  If needed, enter other selection criteria (optional) for the report.
Click Ok to start generating the report.
A notification dialog box displays to let you know that the background task for the report has been created. Click Ok.

Note: Deltek recommends that you generate reports one at a time to avoid overwriting data. Wait for Maconomy to finish generating one report then immediately retrieve the data export to ensure you are getting the correct information.

View Background Task

To view the associated background task for your report:

Select the Background Tasks tab.
Click the Refresh icon to update the Execution Status.
While running the report, the Execution Status displays as "Pending". Once complete, it changes to "Succeeded ".

Download Report

To download the data export:

Select the Statutory Report Retrieval tab.
Select the row of the report you want to view, then choose one of the following methods:
- Click the icon under the Download File to download a .zip package containing the report.
  Or
- Click the Download icon located outside the table. In the dialog box, specify the parameters for the data export (file extension, file name and number of rows), then click Ok.
The data export is downloaded to the default download folder on your device.

Submit the Report

Not applicable for this report.

Report Description

Universes

The data export is based on the following universe:

Finance Universe
System Universe

Export Fields and Descriptions

The SIE report exports the following information in two SIE file formats:

Year-end balance (SIE 1)
All recorded transactions and vouchers (SIE 4 and 4i)

The report is created as an SE file. The name of the file is based on the file type (“1” for SIE 1 and “4” for SIE 4). For every header, it will create a line.

Note: The header information is from the company specified in the Company No. field.

Field	Description	SIE Type 1	SIE Type 4
Flag Items
#FLAGGA	Flag item that specifies whether the file has been received by the recipient	Compulsory	Compulsory
#FORMAT	The character set that is used	Compulsory	Compulsory
#SIETYP	The type of SIE format the file follows	Optional	Compulsory
#ORGNR	CIN of the exported company	Optional	Optional
#PROGRAM	The program that generated the file	Compulsory	Compulsory
#GEN	When and who generated the file. Dates are specified using the YYYYMMDD format	Compulsory	Compulsory
#FNAMN	Complete name of the exported company	Compulsory	Compulsory
#ADRESS	Company address information	Optional	Optional
Identification Item
#RAR	Financial year from which the exported data is retrieved	Compulsory Items for both current and previous financial years are to be present. Previous year items can be omitted where these figures are not available.	4I - Optional 4E - Compulsory Items for both current and previous financial years are to be present. Previous year items can be omitted where these figures are not available.
Chart of Accounts Information
#KONTO	Account information	Compulsory	4I - Optional 4E - Compulsory
#SRU	RSV code for standardized accounts extract	Compulsory	Optional
#DIM	Dimension	Not Applicable	Optional
#UNDERDIM	Sub-dimension	Not Applicable	Optional
#OBJEKT	Object	Not Applicable	Optional
Balance Items/Verification Items
#IB	Opening balance for balance sheet account	Compulsory Items for both current and previous financial years are to be present. Previous year items can be omitted where these figures are not available.	4I - Not Applicable 4E - Compulsory Items for both current and previous financial years are to be present. Previous year items can be omitted where these figures are not available.
#UB	Closing balance for balance sheet account	Compulsory Items for both current and previous financial years are to be present. Previous year items can be omitted where these figures are not available.	4I - Not Applicable 4E - Compulsory Items for both current and previous financial years are to be present. Previous year items can be omitted where these figures are not available.
#RES	Balance item for a profit and loss account	Compulsory Items for both current and previous financial years are to be present. Previous year items can be omitted where these figures are not available.	4I - Not Applicable 4E - Compulsory Items for both current and previous financial years are to be present. Previous year items can be omitted where these figures are not available.
#VER	Verification item	Not Applicable	Optional
#TRANS	Transaction item	Not Applicable	Optional

Limitations

Background Task Not Cancelled

In some cases where a Background Task is canceled, the report still attempts to generate and complete the data export. This can cause performance issues especially when run on a system with a large amount of data.

Insufficient System Memory

When running the SIE report, your system must have at least 10 GB of free memory, otherwise, it fails to retrieve the next page when the amount of data is large. For example, 10GB of free memory is required to run 1.2m data at 50k per page.

If you run the SIE report to include millions of data, you must adjust the offset to 100k up to 500k. Keep in mind that 100k~500k offset cannot be applied if system memory is below 10GB. Additionally, make sure the settings in CMC for the SIE report are all set.

Incorrect Fields Due to Running the Report Consecutively

There is an issue when running the report two times or more in a row, such as accidentally clicking the Generate Report button twice or clicking the Generate Report button too soon (while a report is still being generated due to a large amount of data). This can result in incorrect or missing fields in the report. It is recommended to give ample time for a report to finish before generating a new one.

Admin Setup

Maconomy Setup

Note: You must have System Administrator rights to configure some of these settings, such as the Reference Workspaces.

The Finance universe of BPM Reporting uses reporting structures to structure and filter accounts. Sweden's BPM reports require the setup of reporting structures.

Please contact your Customer Success Manager if you require assistance in reporting structures.

Create a Reporting Structure

The reporting structure determines the format of account headers and subtotals of the report.

To create a reporting structure:

Part 1: Create Option List

Go to Setup » System Setup » Option Lists.
Click + New Option List to open the Create Option List dialog box.
In the Option List No. field, enter Finance.
(Optional) Provide a description for the option list.
Click Create Option List.
On the Options table, click the Add icon.
In the Name and Description fields, enter how you want to identify and describe the option, for example:
- Name — SIE
Click Save.

Part 2: Create Reporting Structure

Go to Reference Workspaces » Set-Up » Reporting » Reporting Structures.
Click + New Reporting Structure to open the Create Reporting Structure dialog box.
Provide a Name and Description, select a Type (or dimension), and input the following settings:
- Option List — Finance
- Selected Value — SIE
  
  Note: Select the values entered in the Create Option List section.
Click Create Reporting Structure.
(Optional) Insert group headers and subgroup headers to provide the desired account structure, and you can also include a small subset of accounts. The reporting structure works as a filter on accounts in addition to providing a hierarchical structure. Click Save.
Note: Headers for the groupings are restricted to three digits similar to Swedish tax authority codes.

Dimension Setup for Transactions

Note the following behavior that occurs for #TRANS and #VER for transactions under the following scenarios:

Scenario 1: Not Using Updated localspec1 in Transaction

The following behavior will occur when you change the setup in the dimension after creating a transaction but don't use the updated localspec1:

If no checkbox is selected, the transactions of the specific Fiscal Period are shown.
If the localspec1 checkbox was selected, then #TRANS and #VER are blank.

Scenario 2: Using Updated localspec1 in Transaction

The following behavior will occur if you create a transaction using the updated localspec1:

Regardless if the checkbox is selected, #TRANS and #VER will be shown for a specific Fiscal Period.

Email Notification Setup

Configure Maconomy to send an email notification when it successfully generates a data export or encounters an error while running the report. The email specifies the report name, other information such as the report's format (if any), as well as the date and time the export is created. The alert is sent to the email address associated with the user who initiates the report. For reports with errors, the message points to the maconomy.log file for details.

To set up the email server and sender:

Open the Extension.ini file. It is located in the <Path to Maconomy installation>\CouplingService\Configuration\Settings folder.
Configure the email server and sender:
- Locate mailserver.address and change the value to smtp.deltek.com:25.
  Note: The email server can also be set via the Web Client. Go to Setup » System Setup » System Parameters » Mail Port and Server workspace and use the Server and Mail Port parameters.
- Locate email.from.default and provide an email address for the From field of the email.
Save the file.
Restart the Coupling Service to apply the changes.

Adjust the Pagination Size of Data

SIE pagination size can be adjusted depending on memory capacity. The default pagination size is 20000, and you can set this to your preferred value up to 100000.

To adjust the default pagination:

Go to the Extension.ini file (<Path to Maconomy installation>\CouplingService\Configuration\Settings\extension.ini).
Add the following line:
filepath.sieoffset = <Page size>
Enter the preferred page size, within a range of 20000 to 100000.
Save the file.
Restart the Coupling Service to apply the changes.

Note: If the page size is set to 100000 and SIE fails to generate a report, the next threshold is 50000. Typically, SIE triggers an error within the first 30 minutes if system resources cannot accommodate the page size configured.

External Setup