Visma Net
SIE import (GL40101S)
This topic gives you information about the elements that you find in this window in Visma Net, such as fields, field values, buttons, and check boxes.
SIE format is an interface that includes:
• Exchange of data between accounting software
• Import of data from pre-systems such as invoicing and payroll
• Export of accounting data for financial statement and tax return software
Element | Description |
---|---|
File name |
Select the SIE file to import. Click button Upload and browse for the file. |
Check box | Description |
---|---|
Vouchers |
Select this check box to import transactions. |
Incoming balance |
Select the check box incoming balance and choose a transaction code (voucher number series), and the system creates a batch with incoming balances for the first date of the first year. |
Workbook ID | Select the workbook ID from which incoming balance is to be imported from. |
Trans. code |
Select the check box incoming balance and choose a transaction code (voucher number series), and the system creates a batch with incoming balances for the first date of the first year. |
SRU codes |
Select this check box to import the codes used for tax purposes in Sweden to the chart of accounts. |
Subaccounts |
Select this check box to import subaccounts from transactions. This is valid if also the vouchers check box is selected. |
Column | Description |
---|---|
Import all vouchers |
Select this check box to import all vouchers in the SIE file. If this check box is not selected, set from and to date to filter what vouchers to import. |
From |
If the Import all vouchers check box is not selected, set from and to dates to filter which vouchers to import. |
To | If the Import all vouchers check box is not selected, set from and to dates to filter which vouchers to import. |
Column | Description |
---|---|
Create VAT transaction |
Select this check box to activate VAT handling for the imported transactions and to have them included in the VAT import. When the transactions are imported and visible in the Journal transactions (GL301000) window, the check box Create tax trans. is also selected for the batch there. |
Skip VAT amount validation |
Select this check box to allow differences in calculation of tax amount based on taxable amount. The transactions are imported as in the SIE file even though there are VAT calculation differences. |
When there is an error, the SIE import is interrupted. The cause of the error must be fixed and the SIE import can be done again after this.
Column | Description |
---|---|
Key value |
The key value of the error. |
Type |
The type of the error. |
Message |
The error message. |
Check box | Description |
---|---|
Move the chosen series to one series |
When this is selected, the chosen series will be moved to one series in the file. |
Split voucher on different dates |
When this is selected, the voucher will be split on different dates. |
Place the series ID and voucher number in front of the voucher text |
When this is selected, the series ID and voucher number will be placed in front of the text field on the voucher lines. |
New series ID |
Enter the ID of the series to which the chosen series will be moved. |
Column | Description |
---|---|
Import |
The target of the SIE import (not in use with workbooks). |
SIE series ID |
The ID of the series to which the import is done. |
Trans. code |
The code of the imported transaction. |
Workbook ID |
The target of the SIE import. The feature set General ledger workbooks needs to be activated the Enable/disable functionalities (CS100000) window before you can select a workbook as a target for SIE import. |
Check box | Description |
---|---|
Import only used subaccounts |
When this is selected, only subaccounts used in balances or transactions registered in the SIE file, are imported to the subaccount register. All subaccounts from the SIE file are imported to the subaccount table if the check box is not selected. |
Update subaccount name from import file |
Select this check box to use the account description in the SIE import file to update the account description in chart of accounts. |
Column | Description |
---|---|
Import |
Select this check box if you want to import the details on the line. |
SIE dimension |
Select the SIE dimension for the export. |
Description |
The description of the dimension. |
Segment ID |
Select segment ID to use in Visma Net for each SIE dimension in the file. |
Segment description |
The description of the selected segment ID. |
The Selection section
Check box | Description |
---|---|
Import only used accounts |
When this is selected, only accounts used in balances or transactions registered in the SIE file, are imported to the account register. All accounts from the SIE file are imported to the account table if the check box is not selected. |
Update account name from import file |
Select this check box to use the account description in the SIE import file to update the account description in chart of accounts. |
Update SRU codes |
Select this check box to update SRU codes in column Public code 1 in the chart of accounts according to the SIE import file. |
This is used to automate the VAT handling for SIE import: For international transactions (sales/purchases) with zero VAT and reversed VAT.
Column | Description |
---|---|
Account |
When the account selected here is used or encountered in a SIE import file, the VAT ID selected in the VAT ID field will be added to the transaction with the account. |
Posting type |
Select the posting type to be used on the account. |
VAT ID |
The VAT ID to be used in he import. |
Generate extra VAT line |
When this is selected, the SIE import creates an extra VAT line which facilitates the processing of international transactions. |
Extra line account |
If the Generate extra VAT line box is selected, the extra line account ID is mandatory. |