- Day-to-day banking
Day-to-day banking
Our day-to-day banking services cover everything you need to run your company finances, from accepting credit card payments to paying your bills.
- Finance
Finance
At Santander, we understand that to expand your operation you need access to finance. Here you’ll find a range of options suited to short and long-term needs.
- International trade
International
We’re focused on bringing a fresh perspective to businesses with ambitions to grow beyond traditional markets.
Our extensive local networks and knowledge around the world means we’re ideally placed to support your international trade plans. Let us help you uncover the path to international success.
- Sectors expertise
Sector expertise
Our sector specialists are here to help you prosper.
We understand the complexity and evolving needs of businesses in a wide range of industries. Our experts will work with you to help turn your aspirations into reality.
Insight & events
Read the latest Santander news, market developments and insights, as well as register your interest to attend our events held across the UK.
Santander Connect Help Centre
Our online help centre is always here when you need it.
Exporting Account Data
- Scheduled statements
- Basic balance reports
- Basic account activity reports
- Advanced account activity reports
- File repository services (Connect Plus only)
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.
You can opt to ‘go paperless’ and only receive statements online from the scheduled statements screens.
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.
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.
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.
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
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;
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:
- 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 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.
- 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:
- Specify an actual date range using the calendar feature
- 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.
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
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 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.
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.
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 mid August. 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 CHK | NP114 MSC | Transaction Type Data within your Electronic Statement Arrangement (ESA) |
| APACs Standard | 15 | 11 | |
| Old Giro Standard | 260 | 242 | |
