Account activity report

The account activity report endpoint contains details regarding all activity on the account, within a selected date range.

It is available in CSV and JSON formats. There is currently a limitation of 50,000 payments per report in this version. If you need a report for more than 50,000 payments on your account, a paginated endpoint is available, see below.

The MT940 is following SWIFT reporting standards:

{1:F01A1111111111}{2:O940XXXXXXXXXXXXN}{3:{108:XXXXXXXXX}}{4: Header
:25: Account id (IBAN)
:28C: Statement number, unique for each statement
:60F: Opening balance: C/DYYMMDDCCYAMOUNT
:61: Transaction: VD, TD, D/C ,AMOUNT ,TYPE ,BC Connect unique reference
:86: Transaction Information: counterpart name, counterparty address, counterparty account, remitter information line 1,2,3,4
:62F: Closing balance: C/DYYMMDDCCYAMOUNT

Parameters in account activity report request

Parameter	Required	Description
FromTransactionDate	Mandatory	Format: ISO 8601 \| YYYY-MM-DD. Specify from which transaction date the report should be generated.
ToTransactionDate	Mandatory	Format: ISO 8601 \| YYYY-MM-DD. Specify until which transaction date the report should be generated.
AccountId	Optional	Specify Id of the account on which activities have been booked. It is possible to send comma separated list of GUIDs. Format: comma (,) separated string
IncludeVIBAN	Optional	By requesting this additional property on CSV format report returns an additional column with the VIBAN (DK representation) used in the instruction.
PropertiesIncluded	Optional	Specify properties to include in the reconciliation report results. By default we will include all properties except for paymentId & lastChangedTimestamp that can be added to the array. See below table for all properties of the report.
PropertiesExcluded	Optional	Specifies properties to exclude from the reconciliation report results. By default we will include all properties. To get all available properties, send an empty exclude properties.
IncludeProperties	Deprecated
ExcludeProperties	Deprecated

Properties of the account activity report

Name	Type	Example	Description
Transaction Date	Date mm/dd/yy	3/25/2019	What date was the transaction made
Value Date	Date mm/dd/yy	3/25/2019	Value date of the transaction
Credit	Decimal (22,2)	100	The credit amount
Debit	Decimal (22,2)	3728.58	The debit amount
Balance	Decimal (22,2)	366993.58	Running account balance including current transaction
Reference Number	Text (16)	010F30xx90840001	BC Connect reference number, unique identifier for processed transactions
Description	Text (16)	Incoming Payment	Type of transaction (Incoming, Outgoing, Own Payment)
Payment Details	Text (150)	Information for beneficiary	Line 1 of payment details (Remitter information line 1). Reference is propagated to beneficiary.
Beneficiary/Remitter 1	Text (35)	IBAN	Counterparty account IBAN
Beneficiary/Remitter 2	Text (35)	Loaners Inc	Counter party name
VIBAN* optional column	Text (35)	DK VIBAN	DK representation of VIBAN used in the transaction. If no VIBAN is used, blank

Additional fields (only on request)

Name	Type	Example	Description
StatusReasonCode
StatusReasonDescription

The account activity paged report will further include the below properties:

Name	Type	Example	Description
Customer Name	Text (105)	BC Connect	The client name associated with the account(s)
Account Number	Text (18)	DKXXX000000012345	The account number holding the transactions displayed
Account Currency	Text (3)	USD	Currency of the account
Report Date	Date	Apr 9, 2019	The date the report was generated

The account activity report is available as MT940, following SWIFT reporting standards:

{1:F01A1111111111}{2:O940XXXXXXXXXXXXN}{3:{108:XXXXXXXXX}}{4: Header

:25: Account id (IBAN)

:28C: Statement number, unique for each statement

:60F: Opening balance: C/DYYMMDDCCYAMOUNT

:61: Transaction: VD, TD, D/C ,AMOUNT ,TYPE ,BC Connect unique reference

:86: Transaction Information: counterpart name, counterparty address, counterparty account, remitter information line 1,2,3,4

:62F: Closing balance: C/DYYMMDDCCYAMOUNT

Paged account activity report

The account activity report is available in a paginated version to allow a larger number of rows to be included in the report. Content of the file remains unchanged and above specification can be used.

Parameters in paged account activity report request

Parameter	Required	Description
FromTransactionDate	Mandatory	Format: ISO 8601 \| YYYY-MM-DD. Specify from which transaction date the report should be generated.
ToTransactionDate	Mandatory	Format: ISO 8601 \| YYYY-MM-DD. Specify until which transaction date the report should be generated.
AccountId	Optional	Specify Id of the account on which activities have been booked. It is possible to send comma separated list of GUIDs. Format: comma (,) separated string
PageNumber	Mandatory	Integer, specify a valid page number (1 to n)
PageSize	Mandatory	Integer, any positive value may be specified however values above an internal maximum value will be reset to the max allowed value.
IncludeVIBAN	Optional	By requesting this additional property on CSV,PDF format report returns an additional column with the VIBAN (DK representation) used in the instruction.
PropertiesIncluded	Optional	Specify properties to include in the account activity report results. By default we will include all properties except for paymentId & lastChangedTimestamp that can be added to the array. See below table for all properties of the report.
PropertiesExcluded	Optional	Specifies properties to exclude from the account activity report results. By default we will include all properties. To get all available properties, send an empty exclude properties.
IncludeProperties	Deprecated
ExcludeProperties	Deprecated

Properties of the paged account activity report are same as that of the account activity report.