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 ReferenceField NameField ValueField Description
1Date & Time16adate and time stamp of export
Record
1Account ID14nAccount sort code and number
2Account Alias34aAccount alias
3CCY3nAccount currency
4Real time balance18aLatest ledger balance of account
5Real time available balance18aLatest 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 ReferenceField NameField ValueField Description
1Sort code6nAccount sort code
2Account number8nAccount number
3Account type30aAccount product type
4Account alias34aAccount alias
5Currency3nAccount currency
6BIC14aBank identification code of account
7Last Statement Date10n (dd/mm/yyyy)Date of last account statement
8IBAN34aInternational bank identification code of account
Record
1Date10n (dd/mm/yyyy)Date transaction was posted
2Narrative90aTransaction description
3Transaction Type30aTransaction code and description
4Debit18aDebit indicator with transaction value
5Credit18aCredit indicator with transaction value
6Current Balance18aLedger 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 ReferenceField NameField ValueField Description
1Account type30aAccount product type
2Nickname34aAccount alias
3Account ID17nAccount sort code and number
4Description30aAccount product code
5Balance15nCurrent account balance
6Bank name9aAlways “SANTANDER”
7Bank ID3aAlways “SAN”
Record
1blank--
2Posted Date10n (dd/mm/yyyy)Date transaction was posted
3Description90aTransaction description
4Amount15nTransaction value
5Currency3aTransaction currency
6Transaction Reference Number30aOriginator reference
7FI Transaction Reference30aBank's Transaction Reference
8Payee30aBlank (for future use)
9Transaction Code3nTransaction code
10Server ID30aBlank (for future use)
11SIC Code30aBlank (for future use)
12Type38aTransaction code and description
13Credit / Debit6aCredit or Debit indicator
14Origination Date10n (dd/mm/yyyy)Date transaction was originated
15Available Date10n (dd/mm/yyyy)Date funds were available
16Original Amount15nOriginal transaction value
17Original Currency3nOriginal 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 RefField NameField ValueDescription
1Account number14nthis is the bank account number of the account.
2Account name30athis is the code type and name of account product.
3Product sub type15athis is the category of account.
4Account currency3nthis is the currency of the account
5Bank ID3athis will always be SAN (short name of holding bank of account).
6Bank name9athis will always be Santander (holding bank of account).
7Opening Ledger balance15nthis is the opening ledger balance over the dates selected.
8Previous statement balance15nthis is the previous balance before the dates selected.
9Closing balance15nthis is the closing ledger balance over the dates selected
10Closing available balance15nthis is the closing available balance over the dates selected.
11Cleared balance15nthis is the available balance over the dates selected.
12Forecast balance15nthis is only applicable when selecting a future period.
13Transaction description90athis is a combination of the transaction code and description.
14Transaction type3nthis is the code of the transaction entry.
15Debit / Credit indicator1athis indicates if the transaction is a debit (D) or credit entry (C).
16Amount15nthis is the value of the transaction.
17Customer reference30athis is the information applied to the transaction by the originator.
18Bank reference22athis is the transaction reference applied by the bank.
19Number of credits15nthis is the total number of credits over the dates selected.
20Number of debits15nthis is the total numbers of debits over the dates selected.
21Amount of credits15nthis is the total value of credits over the dates selected.
22Amount of debits15nthis is the total value of debits over the dates selected.
23Ledger date10athis is the date of the transaction entry in  DD/MM/YYYY format
24Narrative90athis 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
PaperImageWhere to find them
C 1234Payment by cheque with serial number 1234On your Statements under Transaction Description

 

Cheques deposited
PaperImageWhere to find them
DepositCheque Deposit xxx
Where xxx=individual deposit document reference
On your Statements under Transaction Description

 

Transaction type
ESA typePaperImageWhere to find them
Santander StandardNV264
 
NP114
 
Transaction Type Data within your Electronic Statement Arrangement (ESA)
APACs Standard1511
Old Giro Standard260242
SWIFT StandardCHKMSC

 

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