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:
Open the new report window: New → New report.
Select SEB Subscriptions and Redemptions (CSV) from the list on the left.
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.
Click Save as a new report package.
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 |