Bank files #
A bank file pays employees. Each pay run generates the file automatically, and you upload it to your bank. paiyroll® generates BACS and Faster Payment files in the format of many UK banks.
The Add bank file tool adds a bank file report to a company in your bank's format. You do not copy or type text.
If your bank is not in the list, the tool starts your report from a default template. You then create your own bank file template. The bank file reference tells you how.
Before you start #
- Find which file your bank uses, for example BACS or Faster Payments. Your bank can tell you.
- One bank can have more than one format. The format can be different for each bank account of the company, or for each type of online banking. Your bank can tell you which format the company's account uses.
- Make sure the company has its bank details: sort code, account number, account name and reference. The file pays from this account. See Company address, bank and tax details.
- If your bank uses the reference, make sure that it is in the company bank details. For example, the Modulr Payment file format puts the reference in each payment, and Modulr rejects a file without it.
- Make sure each employee has their bank details.
paiyroll® can generate files in these formats:
| Bank | Formats |
|---|---|
| Alicia | Alicia Bank CSV text file |
| Bank of Scotland | Bank of Scotland (Faster Payments) |
| Barclays | Barclays, Barclays SIF |
| Bottomline | Bottomline PTX |
| Cashbacs | Cashbacs |
| Coutts | Coutts (Faster Payments) |
| HSBC | HSBC BACS Standard 18 (Faster Payments) – single date serial number, HSBC BACS Standard 18 (Faster Payments) – unique serial numbers, HSBC BACS Standard 18 (BACS 3-day Payments) – unique serial numbers |
| Lloyds | Lloyds TXT, Lloyds BACS CSV, Lloyds Faster Payments (FPS) CSV |
| Metro Bank | Metro Bank CSV text file |
| Modulr | Modulr Payment file |
| Monzo | Monzo Bank CSV text file |
| NatWest | NatWest Ad Hoc Bulk payment file, NatWest CSV DAT file |
| RBS | RBS Bankline Standard domestic bulk list CSV file |
| Revolut | Revolut Bank CSV text file |
| Santander | Santander, Santander Connect Faster payment |
| Silicon Valley Bank | Silicon Valley Bank |
| SmarterPay | SmarterPay |
| Starling | Starling Bank CSV file |
| Telleroo | Telleroo custom pay run file |
If your bank is not in the table, contact Support.
Run the Add bank file tool #
- In the bar at the top of the page, select the company.
- Click Setup > Report Definitions.
- Click Tools > Add bank file (or Setup > All Tools, and then Run for Company add bank file). The tool opens at the Bank step.
- For Bank file format, select your bank's format. If your bank is not in the list, select My bank is not listed.
- Click Next. The Check step opens. If you selected My bank is not listed, the Your bank step opens.
- If you selected My bank is not listed, do steps 7 and 8. If not, go to step 9.
- For The name of your bank, enter your bank's name. The report gets the name GB BACS and your bank's name.
- For The kind of file your bank takes, select A CSV file or A fixed-width text file. Then click Check. The Check step opens. In a CSV file, there is a comma between the values, and letters do not change. In a fixed-width text file, each value has a fixed position on the line, and letters change to uppercase.
- Read the summary. Nothing changes until you click Add.
- Click Add. The Added step shows Report added and the name of the new report.
The summary before Add has these lines:
| Line | What it means |
|---|---|
| Company | The company which gets the report. |
| Bank file format | The format you selected. |
| Report template | The template the report starts from. |
| Report to add | The name of the new report. |
| Filename | The name of the file each pay run generates. |
| Replace in the report | Words which you must change to your own before the first pay run, for example, YourCompanyNumber. This line shows only when the format has them. |
The company has a bank file report. The next pay run generates the bank file. To see the report, click Report definitions.
If your bank uses two formats, for example BACS and Faster Payments, do the steps again for the second format.
Complete the report for a bank which is not in the list #
If you select My bank is not listed, the summary shows the warning This bank file is not complete. This is because the report generates a file in the format of Santander (fixed-width) or Lloyds (CSV), and your bank can reject it.
- Click Setup > Report Definitions, and then open the report.
- Change the Header template, Row template and Trailer template to your bank's format. The bank file reference gives the fields you can use.
- Click Update.
Send your bank's file specification to Support. We can then add your bank to the list.
Troubleshooting #
The bank rejects the file because it has no payment reference #
You see this when you upload the file to your bank. For example, Modulr does not accept a file without a payment reference.
Cause: The company bank details have no Reference. Some formats, for example Modulr Payment file, put the Reference in each payment as the payment reference. If the Reference is empty, the payment reference is empty.
Remedy:
- Add the Reference to the company bank details. See Company address, bank and tax details.
- Run the report again, and upload the new file to your bank.
An employee is not in the file #
The report results show each employee who is not in the file, with the cause.
Cause 1: The employee has no bank details, or some of their bank details are empty.
Remedy: Add the employee's bank details. Then run the report again.
Cause 2: The employee's net pay is zero or less. The file pays only a net pay above zero.
Remedy: Examine the employee's pay in the pay run.
Cause 3: The employee's Payment method names a different bank file.
Remedy: See Multiple bank files.
Next steps #
- Multiple bank files: pay some employees from one file and some from a different file.
- Bank file reference: each format, and the fields for your own template.