FinOps handbook

Building blocks of a Partner team

FinOps Software List

Finance processes

Compliance and tax

Explore

Payments Process

Bulk payments

Payment Solutions

Being able to make bulk payments can save a significant amount of time, particularly for payroll and weekly supplier payments.

The table below details how to create import files for a selection of banks. Each one requires a slightly different format. Be sure to follow the format exactly to avoid any errors!

If you are not able to make bulk payments on your bank account, you may opt for a

payment solution⁠

instead.

Creating bulk payments

Creating bulk payments

Bank

Import file

Resources

Natwest

⁠

Template Natwest Payment file

⁠

Import file layout

⁠

Lloyds

⁠

Template Lloyds Payment file

⁠

Import guide

⁠

Barclays

⁠

Template Barclays.net payment file

⁠

Bulk Payments User guide

⁠

Bank of Scotland

⁠

Template Bank of Scotland

⁠

File formats

⁠

SVB

⁠

Template SVB Payment File

⁠

Creating templates

⁠

Santander

Template to create in net banking and export in CSV

⁠

Making payments

⁠

Instructions for creating an importable file (For more than 25 payments)

⁠

Making payments (less than 25 payments)

⁠

There are no rows in this table

Count

⁠

Creating a CSV from Xero

By creating a CSV file from Xero you are able to export all the information required to create a payment file. Be sure that Xero is set up correctly and all supplier information is correct!

Steps

Open supplier bill in Xero

Click on supplier contact

Fill out the below details

Email address of supplier

Batch payments

Bank account number (8 digit)

Bank account name (Supplier's name)

Details (sort code without dash, e.g 101010)

Go back to Awaiting payment

Select the bills that need by bulk paid

Click on Batch payment

Select payment date, Bank account, Details and Narrative

Select Make payment

Export batch file in CSV

Click on Option and do remove & redo (This is required as supplier payments will be discussed with client and they will decide which supplier they want to pay based on cashflow, we are only using this process to download the bank data to prepare payment file for FBP)

Copy across bank account, sort code, supplier name and amount to supplier payment file template.

Once payment is made, Reconcile supplier payment and send remittance advice to supplier from Xero.

Loom

⁠

https://www.loom.com/share/19aa0b0db0714457ab776d6f12cb9e8f⁠

⁠

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.