Import custom fees through Excel

Any type of fees, taxes or other types of transactions can be imported through Excel by navigating to Custom fees in the fee type menu.

From the page below, we can download an Excel template that can be used for importing fees.

You can also download the file template below.

Now, what should we think about when we enter information into the Excel sheet?

Well, first off we have to make sure that we are entering one row for each transaction dimension so one row for trade and one for settle. Below we have entered one fee transaction for each dimension for account 10001188 of 100 SEK each with trade date, settlement date and value date on the first of February. When we import the file the Fee Manager will check so that we have not entered both trade, settle and value dates on the same transaction since they have to be separated with different transaction types. Settlement date and value date could be entered on the same transaction though.

If we try to import this file the Fee Manager will alert us to the fact that 100 SEK will be removed from accounts but not deposited into another account. The general idea with charging fees is that the customer BFS account would be debited and those funds will then be credited to the house fee account or another user of the system that could be a financial advisor. Let's have a look at the error message that will result from importing the file.

We can still process this import by checking the box titled "Override validation" but instead we are going to add transactions to deposit 50 SEK of the fee to a financial advisor and 50 SEK to the house fee account.

Now lets try the import file again.

Everything is validated correctly and we can click on the "Create Fees in BFS"-button.