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

Format

Description

Value source

Fund name

Text

Security → Name

Fund ID

Number/Text

Fund ID = Business ID.

Security → Share class settings → Reporting → Fund business ID

ISIN

Text

12 characters consisting of both letters and numbers.

Security → ISIN code

Trade date

Date (YYYY-MM-DD)

Example (2020-11-03)

Trade date = NAV date.

Transaction → Transaction date

Order date and time

Date (YYYY-MM-DD HH:MM)

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

Date (YYYY-MM-DD HH:MM)

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"

else

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

Transaction type

Text

Subscription; Redemption; Other.

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

Amount

Number

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

Fee

Number

Decimal separator is comma (,)

Example: 16884,72

If applicable: positive. If not applicable: 0.

Transaction → Fee1 + Fee2

Currency

Text

Currency code

Example: EUR

Currency in which transaction is settled.

Security → Currency → Code

Share price/NAV rate

Number

Decimal separator is comma (,)

Example: 16884,72

Fund’s share price.

Transaction → Unit price

Units

Number

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

Text

Additional information to identify transaction.

Transaction → External ID