Skip to main content

Subscription and redemption report for SEB

File format is specified by SEB and the specification document is available from SEB by request.This report is used to report subscription and redemption transactions for SEB. The report itself is a CSV file containing detailed information of each of the reported transaction.

You run the report against fund portfolio(s). The system looks for the securities linked to the portfolios and reports all matching transactions for those securities on the selected report date. 

Generate the report in FA Back

To generate a report in FA Back, open the Report window and select "SEB Subscriptions and Redemptions (CSV)" from the report list. Choose the fund portfolio, report date, and "CSV" as a file format. For more detailed instructions on how to generate reports, see Report window.

Define the report package(s)

Since many of the report selections are the same every time, you can make the reporting more efficient by creating a report package. With the package you don't need to set the parameters anymore, just run the package and you're done. To create a package:

  1. Open the new report window: New → New report.

  2. Select SEB Subscriptions and Redemptions (CSV) from the list on the left.

  3. Fill in the report parameters on the right:

    • Customer, Group, Portfolio: Fund portfolios to include.

    • Report date: NAV date/Trade date. Use one of the dynamic selections, such as “D0: Current day” or “D1: Previous day”.

    • File format: CSV.

    • Output type: One report (background).

    • Folder name: outbound/SEBSubscriptionRedemption. Enter it if you want to send the report to SEB automatically.

  4. Click Save as a new report package.

  5. Give the package a descriptive name, such as SubscriptionRedemption Fund company A and (optionally) share it with others.

As the reporting is done on fund company level, you should create a package for each fund company you need to report for. If you create several report packages, make sure they have the same File format, Output type and Folder name. Give each package a unique and descriptive name.

Report content

Column name



Value source

Fund name


Security → Name

Fund ID


Fund ID = Business ID.

Security → Share class settings → Reporting → Fund business ID



12 characters consisting of both letters and numbers.

Security → ISIN code

Trade date


Example (2020-11-03)

Trade date = NAV date.

Transaction → Transaction date

Order date and time


Example (2020-11-03 11:00)

Date and time when the subscription/redemption order was received by the fund company.

If there is a linked trade order, then

Transaction's linked order → Transaction date + Trade time

and else

Transaction → Transaction date + Trade time

Settlement date and time


Example (2020-11-03 11:00)

Date and time when the payment was executed.

If the transaction has payment date set, then

Transaction → Payment date + "13:00:00"


Transaction → Settlement date + "13:00:00"

Transaction type


Subscription; Redemption; Other.

Transaction type, Other (if type does not match Subscription or Redemption)



Decimal separator is comma (,)

Example: -16884,72

Transaction amount. Gross amounts should be reported for both Subscriptions and Redemptions. Should be negative amount for Redemptions.

Transaction → Unit price * Amount * Type.AmountEffect



Decimal separator is comma (,)

Example: 16884,72

If applicable: positive. If not applicable: 0.

Transaction → Fee1 + Fee2



Currency code

Example: EUR

Currency in which transaction is settled.

Security → Currency → Code

Share price/NAV rate


Decimal separator is comma (,)

Example: 16884,72

Fund’s share price.

Transaction → Unit price



Decimal separator is comma (,)

Example: -16884,72

The number of units. Should be negative amount for Redemptions.

Transaction → Amount * Type.AmountEffect

Trade identifier

Text / Number

The reference that identifies transaction

Transaction → Id

Trade details


Additional information to identify transaction.

Transaction → External ID