Create Export Profile

The Create Export Profile page allows you to specify the format and search criteria for a new export.

Description

A short description of the export file

File Name

The name of the export file

File Format

The file format for the data export

These formats are available:

  • BAI II
  • QuickBooks
  • SWIFT
  • Comma Separated
  • Semicolon Separated
  • Tab Separated

Clicking Select reveals the rest of the fields on the page, which vary based on this selection.

Content

The type of information in the file

If you selected BAII or QuickBooks, the options are as follows:

  • Current Day – The report includes data up to and including today.
  • Prior Day – The report includes data up to and including the prior business day.

If you selected the SWIFT file format, the options are as follows:

  • MT940 – Customer Statement Message (daily customer statement)
  • MT941 – Balance Report (intraday balance advice)
  • MT942 – Interim Transaction Report (intraday transaction advice)

If you selected a comma-, semicolon-, or tab-separated file format, the options are as follows:

  • Current Day – The report includes data up to and including today.
  • Current Day Detail Only – The report includes only transactions up to and including today.
  • Current Day Summary Only – The report includes only balances up to and including today.
  • Prior Day – The report includes data up to and including the prior business day.
  • Prior Day Detail Only – The report includes only transactions up to and including the prior business day.
  • Prior Day Summary Only – The report includes only balances up to and including the prior business day.
  • Wire Confirmation Detail – The report includes detailed data about all incoming and outbound wire debits and credits.
  • Wire Confirmation Summary – The report includes a summary of the data about all incoming and outbound wire debits and credits.
Accounts

One or multiple accounts for the report, selected from a list

Date Range OR Relative Date Range

The date range for the export profile

The options are as follows:

  • Absolute – From the calendar, the user selects a specific beginning (From) date and end (To) date. Dates use the dd/mm/yyyy format.
  • Relative – The user selects an option from a list of predefined, date ranges that are based on when the export is executed, for example, Beginning of current month to Today. Relative dates enable the reuse of an export. Therefore they can be saved as part of an export profile.

To go to the next page in the sequence, click Continue.

If you chose a character-delimited (Comma, Semicolon, or Tab Separated) file format, the Select Comma/Semi-Colon/Tab Separated Columns page appears. Select Comma/Semicolon/Tab Separated Columns)

If you chose the BAI II, Quickbooks, or SWIFT file format, the Select File Format Data page appears. For details, see Select File Format Data.

Parent topic: Manage Export Profiles