You can define your own file content and layout using our custom export facility. This can also be used across multiple accounts using a custom date range.
To create a custom export profile choose the Data Export & File Repository menu from the Account Information tab. Then ‘Create Customised Data Export’.
You’ll need to complete the Data Export Information. Fields marked with an * are mandatory:
- Description, a unique name that you can assign to this export profile.
- File Name, a unique name assigned to the created file.
- File Format, this is the format of the file that you want to create. The options available include:
- Tab separated value. The fields within each record will be separated by tabs.
- Comma separated value. The fields within each record will be separated by commas.
- Semicolon separated value. The fields within each record will be separated by semicolons.
- Fixed length Value. The fields within each record are presented in a fixed length.
- Content, this field determines the content and fields available in the file. You can choose either a summary or detail report. You can also choose prior day, current day or both. The section on custom content availability illustrates the fields available per content type.
- Negative sign on amounts. This check box can choose to apply a negative sign on debit entries. This is an optional feature.
- Next, choose the accounts you require to be reported in the file. To choose multiple accounts simply tick the box on the left located next to each account.
- Choose the date range. Two options are available:
- Specify an actual date range using the calendar feature
- Choose from the options available under the relative date range.
- Some combinations of dates may not be appropriate to the content you’ve chosen. The service may prompt you to choose alternative options that are compatible.
With the Customised Export Profile you can define exactly which content you want. You can customise the position of this data relative to the format chosen.
You can define the exact content, choose the fields required and their relative position within the file. The fields available depend on the type of content chosen. A description of all available fields is detailed below.
Field Ref |
Field Name |
Field Value |
Description |
---|
1 |
Account number |
14n |
this is the bank account number of the account. |
2 |
Account name |
30a |
this is the code type and name of account product. |
3 |
Product sub type |
15a |
this is the category of account. |
4 |
Account currency |
3n |
this is the currency of the account |
5 |
Bank ID |
3a |
this will always be SAN (short name of holding bank of account). |
6 |
Bank name |
9a |
this will always be Santander (holding bank of account). |
7 |
Opening Ledger balance |
15n |
this is the opening ledger balance over the dates selected. |
8 |
Previous statement balance |
15n |
this is the previous balance before the dates selected. |
9 |
Closing balance |
15n |
this is the closing ledger balance over the dates selected |
10 |
Closing available balance |
15n |
this is the closing available balance over the dates selected. |
11 |
Cleared balance |
15n |
this is the available balance over the dates selected. |
12 |
Forecast balance |
15n |
this is only applicable when selecting a future period. |
13 |
Transaction description |
90a |
this is a combination of the transaction code and description. |
14 |
Transaction type |
3n |
this is the code of the transaction entry. |
15 |
Debit / Credit indicator |
1a |
this indicates if the transaction is a debit (D) or credit entry (C). |
16 |
Amount |
15n |
this is the value of the transaction. |
17 |
Customer reference |
30a |
this is the information applied to the transaction by the originator. |
18 |
Bank reference |
22a |
this is the transaction reference applied by the bank. |
19 |
Number of credits |
15n |
this is the total number of credits over the dates selected. |
20 |
Number of debits |
15n |
this is the total numbers of debits over the dates selected. |
21 |
Amount of credits |
15n |
this is the total value of credits over the dates selected. |
22 |
Amount of debits |
15n |
this is the total value of debits over the dates selected. |
23 |
Ledger date |
10a |
this is the date of the transaction entry in DD/MM/YYYY format |
24 |
Narrative |
90a |
this is the full narrative text applied to the transaction |
You can also specify an amount range. This will apply a filter to the value of transaction presented in the file and depends on the content type chosen.
Once you have defined the custom export profile, choose ‘Save’ to continue. You’ll then be asked to review the details before confirming. Choose ‘Confirm’ to finalise the export profile then choose ‘Return to Data Export Profiles’. To schedule the download of your export profile check the ‘Scheduling an Export Profile’ section.
As well as creating new customised export profiles you can edit and delete existing export profiles.