Santander Connect Help Centre

Our online help centre is always here when you need it.

Exporting Account Data

Account and balance data can be exported in a number of standard and customisable reports. These include the following;
  • Scheduled statements
  • Basic balance reports
  • Basic account activity reports
  • Advanced account activity reports
  • File repository services (Connect Plus only)
Scheduled statements

An online copy of your paper statements can be found in ‘account information’ under ‘scheduled statements.’ These can be exported in PDF format for reconciliation outside of the Santander Connect service.

Paperless statements

You can opt to ‘go paperless’ and only receive statements online from the scheduled statements screens.

Basic balance reports

Basic balance information can be exported in CSV or PDF formats from the ‘account balances ‘screens This shows your real time current and available balances for each of your accounts

To export a basic balance export please follow the instructions below:

  • Step 1: Navigate to the ‘Account information’ tab and select ‘Account balances.’
  • Step 2: At the bottom of the screen select ‘Export PDF’ or ‘Export CSV’

The file layout for a CSV basic balance report is below;

Header
Field Reference Field Name Field Value Field Description
1 Date & Time 16a date and time stamp of export
Record
1 Account ID 14n Account sort code and number
2 Account Alias 34a Account alias
3 CCY 3n Account currency
4 Real time balance 18a Latest ledger balance of account
5 Real time available balance 18a Latest available balance of account

An example basic balance report can be found here.

Basic account activity reports

A basic summary of your recent account activity and transactions can be exported in CSV or PDF format from the ‘account activity’ screens

To export a basic summary of your recent account activity and transactions please follow the instructions below:

  • Step 1: Navigate to the ‘Account information’ tab and select ‘Account Activity.’
  • Step 2: Select or search for an account.
  • Step 3: At the bottom of the account activity screen select ‘Export PDF’ or ‘Export CSV’

The file layout for a CSV account activity report is below:

Header
Field Reference Field Name Field Value Field Description
1 Sort code 6n Account sort code
2 Account number 8n Account number
3 Account type 30a Account product type
4 Account alias 34a Account alias
5 Currency 3n Account currency
6 BIC 14a Bank identification code of account
7 Last Statement Date 10n (dd/mm/yyyy) Date of last account statement
8 IBAN 34a International bank identification code of account
Record
1 Date 10n (dd/mm/yyyy) Date transaction was posted
2 Narrative 90a Transaction description
3 Transaction Type 30a Transaction code and description
4 Debit 18a Debit indicator with transaction value
5 Credit 18a Credit indicator with transaction value
6 Current Balance 18a Ledger balance after transaction posting

An example basic account activity report can be found here.

Advanced account activity reports

An advanced account activity report containing all of your recent account activity and transactions can be exported in CSV or PDF format from the ‘search transactions’ screens

To export an advanced account activity report of your recent account activity and transactions please follow the instructions below:

  • Step 1: Navigate to the ‘Account information’ tab and select ‘Account Activity.’
  • Step 2: Select or search for an account.
  • Step 3: At the bottom of the account activity screen select ‘Search for transactions’
  • Step 4: Enter the search criteria and press ‘Search
  • Step 4: At the bottom of the transaction search screen select ‘Export PDF’ or ‘Export CSV’

The file layout for a CSV advanced account activity report is below:

Header
Field Reference Field Name Field Value Field Description
1 Account type 30a Account product type
2 Nickname 34a Account alias
3 Account ID 17n Account sort code and number
4 Description 30a Account product code
5 Balance 15n Current account balance
6 Bank name 9a Always “SANTANDER”
7 Bank ID 3a Always “SAN”
Record
1 blank - -
2 Posted Date 10n (dd/mm/yyyy) Date transaction was posted
3 Description 90a Transaction description
4 Amount 15n Transaction value
5 Currency 3a Transaction currency
6 Transaction Reference Number 30a Originator reference
7 FI Transaction Reference 30a Bank's Transaction Reference
8 Payee 30a Blank (for future use)
9 Transaction Code 3n Transaction code
10 Server ID 30a Blank (for future use)
11 SIC Code 30a Blank (for future use)
12 Type 38a Transaction code and description
13 Credit / Debit 6a Credit or Debit indicator
14 Origination Date 10n (dd/mm/yyyy) Date transaction was originated
15 Available Date 10n (dd/mm/yyyy) Date funds were available
16 Original Amount 15n Original transaction value
17 Original Currency 3n Original transaction currency

An example advanced account activity report can be found here.

File Repository & scheduling services (Connect plus Only)

The file repository provides a range of more advanced data export facilities that offer a convenient and flexible way to obtain balance and transaction data to meet your reconciliation needs.

Once exported, these data files can be used in your own accounting and enterprise software.

To access these services you will need to be assigned the appropriate access by your Administrator. These services include

Standard Exports

You can export data using a variety of industry standard file formats (e.g. BAI, MT940 and MT942) across multiple accounts and define your own date range.  These reports can be created in the industry standard file formats below;

  • MT940
  • MT942
  • BAI 2
  • QIF
  • Quicken
  • MS Money
  • QuickBooks
  • Lotus statements / transactions
  • More available on request. Please speak to your relationship director.
Custom Exports

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, select the Data Export & File Repository menu from the Account Information header menu. Then select the option Create Customised Data Export. 

You will need to complete the Data Export Information, fields marked with an * are mandatory:

  1. Description, a unique name that you can assign to this export profile.
  2. File Name, a unique name assigned to the created file.
  3. File Format, this is the format of the file that you want to create. The options available include:
    1. Tab separated value, the fields within each record will be separated by tabs.
    2. Comma separated value, the fields within each record will be separated by commas.
    3. Semicolon separated value, the fields within each record will be separated by semicolons.
    4. Fixed length Value, the fields within each record are presented in a fixed length.
  4. Content, this field determines the content and fields available in the file. You can select from prior days summary, prior days detail, current day summary, current day detail, both days summary and both days detail. The section on custom content availability illustrates the fields available per content type.
  5. Negative sign on amounts, this check box can selected to apply a negative sign on debit entries in the data file generated.  This is an optional feature.

Next, select the accounts you require to be reported in the file. To select single or multiple accounts simply tick the box on the left located next to each account. For additional accounts to be added that are not listed, use the navigation buttons to review additional account listings.

Select the date range over which you require the data in the file to cover. Two options are available:

  1. Specify an actual date range using the calendar feature
  2. Choose from the options available under the relative date range.

Please note that some combinations of dates may not be appropriate to the content selected and the service may prompt you to select alternative options that are compatible.

With the Customised Export Profile, you have the option to define exactly which content you require in the data file and the position of this data relative to the format selected. Select the Customised Data Export button to access this feature.

You can define the exact content by choosing the fields required and their relative position in the file with additional options to sort by specific fields . The fields available depend on the type of content chosen, a description of all available fields are 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 which will apply a specific filter to the value of transaction entries presented in the file. This depends on the content type chosen.

Once you have defined the custom export profile, select Save to continue. You will then be asked to review the details specified before confirming. Select Confirm to finalise the export profile then select Return to Data Export Profiles. To schedule the download of your newly created Export Profile please refer to the section Scheduling an Export Profile.

As well as creating new Customised Export Profiles, you can also edit and delete existing export profiles under the Action column in the Data Export Profile menu.

Online Scheduler

Automatically schedule your data files for download at a time and date that aligns with your company’s reconciliation activities. This puts you in control of obtaining account data – scheduling the download in advance of when it’s needed.

The online scheduler can be used to schedule reports to be generated at the following times;

  • 02:00am
  • 06:00am
  • 07:30am
  • 09:30am
  • 10:30am
  • 12:00 Midday
  • 13:30pm
  • 15:30pm
  • 17:30pm
  • 19:30pm
  • 23:30pm

Once generated reports can be viewed and downloaded from the file repository

File Repository

A dedicated file repository portal that centralises all of your data files in one convenient place following their creation – this houses all your standard export files, custom export files and electronic statement arrangements. Here you can access and download all the data files you have created.

Electronic Statement Arrangements (ESA)

Electronic Statement Arrangements is a service whereby unique statement files are automatically produced (as part of File Transfer and Bill Payment services) in our core system and are made available through the files repository for download at a prescribed frequency.

Electronic Statement Arrangements can be delivered in a variety of formats. Please contact your relationship manager for more information.

Common specifications include;

Other formats are available. Please contact your relationship manager for more information.

How do I use the file repository?

The file repository contains all the data files you have scheduled for delivery and from here you can download the file. You can filter the data file by category, or by default, view all the data file that are available to you. 

The fields listed include the following details:

  • File Name, this is the name of the file you defined in the standard or custom export profile. For Electronic Statement Arrangements (Electronic Statements and Bill Payment files) - this is the unique arrangement number
  • Category, this is the type of Data File (Standard Data Export, Custom Data Export, Electronic Statements and Bill Payment).
  • Date/Time available, this is the date and time that the data file was made available in the file repository for download (as per your data export schedule or prescribed electronic statement arrangement). 
  • File Size, this is the size of the data file generated, presented in kilobytes (KB).
  • Status, this is the current status of the data file generated – Downloaded (file already downloaded) or Available (awaiting download).

You can select ‘Download ‘to access the data file and save it to your computer. You can also select ‘View Download History ‘to review when the file was last downloaded and by which user.

Please note: All data files will be available for collection in the file repository for up to 56 Days.

Paper vs image cheque references and transaction codes

As part of cheque imaging we are introducing new transaction codes on Electronic Statement Arrangements, as well as new text descriptions on statements.

These will run in parallel with existing transaction codes for paper cheque deposits and will start to be seen from the end of September. You may wish to update your systems to recognise the new code(s).

Cheques Issued
Paper Image Where to find them
C 1234 Payment by cheque with serial number 1234 On your Statements under Transaction Description

 

Cheques deposited
Paper Image Where to find them
Deposit Cheque Deposit xxx
Where xxx=individual deposit document reference
On your Statements under Transaction Description

 

Transaction type
ESA type Paper Image Where to find them
Santander Standard NV264
 
NP114
 
Transaction Type Data within your Electronic Statement Arrangement (ESA)
APACs Standard 15 11
Old Giro Standard 260 242
SWIFT Standard CHK MSC

 

Protecting your money - Financial Services Compensation Scheme (Opens in a new window)