Please click below:
Documentation > GB migration and other tasks > BACS and Faster Payment files
STOP PRESS: Santander Connect Faster Payment #
Some customers have reported that Santander has now switched over to this new format.
- Setup > Report Definitions > Add…
- Group: Banking
- Template: GB BACS Santander Report
- Modify the settings fields by copying the text below and pasting into each of the settings.
This is the Standard payment import format, which is separate from the older Bacs payment import used by the GB BACS Santander template above. Every line carries 85 comma separated fields. A Bulk payment is made up of one debit record on the first line followed by one credit record for each worker, so the debit record goes in the Header and the credit record goes in the Row.
Name: GB Santander Connect FPS
Description: GB Santander Connect FPS
Header: One line:
,,,08,,,,,49,,,,{company.bankdetail.sort_code}{company.bankdetail.account_number},,,,,,{actual_t:%d%m%Y},,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Row: One line:
,,,09,,,,,,,,,,,,GBP,{pay_graph_results.net_pay:.2f},,,,,,,,{bankdetail.sort_code},,,,,,{bankdetail.account_number},,{bankdetail.account_name:.35},,,,49,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Trailer: Not used, delete all content
Filename: Santander_Connect.txt
Omit final newline: Tick
Be sure to copy each whole line including every trailing comma. All 85 fields must be present on every record, so the debit record ends with 66 commas and the credit record ends with 48. A record with the wrong number of fields is rejected.
The debit record carries the payment record type 08 in field 4, the debit account reference in field 9, the debit account as a 6 digit sort code followed by an 8 digit account number in field 13, and the payment date in field 19.
The credit record carries the payment record type 09 in field 4, the payment currency in field 16, the amount in field 17, the beneficiary sort code in field 25, the beneficiary account number in field 31, the beneficiary name in field 33 and the credit account reference in field 37.
Santander Connect accepts only the characters a-z, A-Z, 0-9, (, ), -, +, ', :, ?, /, . and space in the free format fields. A comma or an ampersand in an account name will cause the file to be rejected.
Then click Add
Paying a worker manually #
Sometimes, a worker must be paid differently than via the main bank file, for example if they need to be paid using a foreign currency. This can be done in one of two ways:
- If this is a one-off, you could just delete the line from the file before upload.
- It is recommended that you keep accurate records of such edits/deletions to avoid later confusion.
- If this is an on-going situation, you can use the payment method setting on the employee:
The payment method allows you to choose which banking ReportDefinition is responsible for paying this person. For example, in the case shown:
- The default value is All.
- If you only have one banking ReportDefinition, this a convenient default.
- Set it to None if you will handle the payment manually
- Or choose the “GB BACS Barclays” ReportDefinition name as an explicit third option.