RBS Bankline - Bulk BACS
The Royal Bank of Scotland provide a Bulk service so that frequent payments can be made in batches rather than one-at-a-time.
This requires two export files:
Bulk List - this file contains the transfer information, and needs to be transmitted to your bank to setup the bulk service.
Bulk List Payment - this file will contain the amounts that are to be paid and must be transmitted to your bank for each pay run.
It is important that you check with your bank to find out how often they require the Bulk List file to be transmitted. It will be produced with every payment list.
Creating the BACS export file
Select Transactions >> Reports >> BACS Export to create the BACS file.
Make sure RBS Bankline - Bulk is selected.
Click the Print icon to create the export file.
You will be prompted to enter the date on which the payments will be credited.
Also on this prompt window, you must enter the Payment Template Name.
Important: Even though you may only have to transmit the template file once, you must ensure that the correct Payment Template Name is entered every time you create an export file. The Payment Template Name will be included in the Bulk Payment List and will be matched to the correct template by the Bank.
Formats:
Bulk List
,,,06,T,bulklistname,N,,,,,,debitaccount,,,,,,,,,,,,,,,,,,,,,,,,referenceforben,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,07,,,,TEST1,,,,,,,,,,,,,,,,,400515,,,,,,00201191,,PAYEEONE,,,,EMPE1,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,07,,,,TEST2,,,,,,,,,,,,,,,,,203253,,,,,,91990100,,PAYEETWO,,,,EMPE2,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Bulk List Payment
,,,06,,bulklistname,,,,,,,debitaccount,,,,,,payment date,,,,,,,,,,,,,,,,,,referenceforben,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,07,,,,TEST1,,,,,,,,GBP,0.01,,,,,,,,400515,,,,,,00201191,,PAYEEONE,,,,EMPE1,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,07,,,,TEST2,,,,,,,,GBP,0.02,,,,,,,,203253,,,,,,91990100,,PAYEETWO,,,,EMPE2,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Notes:
Bulk List
The first line contains your bank details and references.
06 denotes Bulk List Debit
debitaccount is Sort Code and Account Number
The subsequent lines contain bank details and references for your Payees.
07 denotes Bulk List Credit
Bulk List Payment
The first line contains your bank details and references and the payment date.
The subsequent lines contain bank details and references for your Payees and the amount they are to be paid.
GBP denotes payment is in sterling.