Import

This section lets you import transaction data into the TRS Manager application from Bricknode Broker. 

There are two ways of importing data:

1. From Bricknode Broker

2. From Excel import

Open

Import from Bricknode Broker

Every day deals and transfers need to be imported from Bricknode so that the TRS Manager application has all transactions that should be reported. This is done by pressing the button "Import Data" on the tab "Import from Bricknode Broker" tab.

Open

The imported transactions can now be viewed in the transaction list, read more in the section Transactions.

Import through Excel file

Transactions can also be imported through an Excel file. This is mainly used for those who don´t have a Bricknode Broker instance but still need to report TRS to FSA.

First, you need to download the template file which can be done by pressing the button "Download Excel Template" on the "Excel Template" section on the "Excel Import" tab.

Fill the Excel file with transactions according to the format in the template file.

Use the section "Beskrivning" for information about how to populate the different values in the file.

When all transactions are entered in the Excel file, upload it by choosing how the transactions in the file should be handled if they have already been imported. There are two options:

• Mark old transactions as duplicates: The transactions that have been imported earlier (if they are the same as the ones in the file) should be marked as duplicates.

• Mark new transactions as duplicates: The transactions imported now (if they already exist in TRS Manager) should be marked as duplicates.

Press "Choose File..." and then "Import" to import the transactions from Excel.

A message is displayed when the import is finished. The imported transactions can now be viewed in the transactions list, see more in the section Transactions.