Payroll Bankline Payment File

Welcome to the Community, pamelaTW.

I'll share some information to help you in importing your payroll bankline payment file into QuickBooks Online.

You can currently import payment files in BACS format using QuickBooks. The error may have been caused by downloading a bank-specific format from Natwest Bankline. To fix this, I advise contacting Natwest bank to resolve this as the error you encountered was caused by a file format that isn't supported by QuickBooks.

Once you have the supported file format, please follow these steps to import them:

1. From the left menu, select Payroll.
2. Click the Pay Runs tab, then enter the pay period you need.
3. In the Actions tab, select Download Payment File.
4. Click the Payment File settings, then locate the payment file to use.
5. Follow the on-screen instruction to complete the process.

I've also included the following article to help you if you need to adjust the pay schedule in QuickBooks Online: Edit your company pay schedule in QuickBooks Online Standard Payroll.

If you need anything else, let us know. We're always available to help you.

Hello,

Thank you for your swift response. I have not downloaded anything from Natwest, I went through the steps detailed to create my payment file.

Payroll > Payroll Settings > Payment Settings

I then entered my bank account details and select the file format NatWest BankLine CSV payment file.

When I had completed the payment run, I clicked the Downloand Payment File link and saved the export as a .csv.

When I import the .csv to bankline it says the format is not valid. I contacted BankLine who requested I save the export as .txt and retry the upload. This was when I got the error in my screenshot regarding missing or invalid information.

Please can you help me fix this?

Thank you

Hi pamelaTW, thanks for getting back to us with that information - we currently only offer CSV format payment files for Natwest Bankline - are you saving as a text file on Excel using a Windows or Mac device?