SIE import (GL40101S)

This topic provides information about the elements in this window in Visma Net, such as fields, field values, buttons, and check boxes.

• 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

The window toolbar

Import SIE file

Click this to execute the import of the SIE file.

The top part

The Select the file to import section

File name

Select the SIE file to import. Click button Upload and browse for the file.

The Import type section

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.

The Selection of vouchers to import section

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.

The VAT handling section

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.

The Messages section

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.

Key value

The key value of the error.

Type

The type of the error.

Message

The error message.

The Series tab

The Selection section

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.

The table

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.

The Subaccounts tab

The Update information section

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.

The table

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 Accounts and SRU codes tab

The Selection section

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.

The VAT settings tab

This is used to automate the VAT handling for SIE import: For international transactions (sales/purchases) with zero VAT and reversed VAT.

The table

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.

Related pages

Concepts

• General ledger windows - overview