Share this content
9

Bank payment file from Xero

How do I make a payment file from Xero to upload into RBS Bankline

Didn't find your answer?

I have recently moved from Sage 50 to Xero. I used to be able to export my month end payment run into a .txt file and upload straight into RBS Bankline. Xero only exports to .csv or BACS. BACS isn't a good option for me so that leaves me with .csv. Bankline will not accept the file when I try to upload it and says I need to import only .txt.  I have called the Bankline helpline and the rep I spoke with told me that it does accept .csv and sent me a 75 page document on how to create it. I'm still none the wiser. I have just had to enter my month end payments manually and it is not something I want to do again. Xero support are of no help. I can't be the only person using Xero who banks with RBS or NatWest and needs to do this. Can anyone give me any advice or share a template?

Thank you.

Replies (9)

Please login or register to join the discussion.

avatar
By Cloudcounter
28th Jul 2020 09:50

Xero have a relatively new facility for paying bills using Transferwise which obviates the need to upload a file to your bank. There is a charge for this, but quite possibly less than RBS would charge you.

Thanks (1)
Replying to Cloudcounter:
avatar
By lemonjellyfish
03rd Aug 2020 12:49

Thanks for the info, I will have a look at that.

Thanks (0)
avatar
By cbp99
28th Jul 2020 11:03

Am no expert, so this is just a guess, but can you not save the csv as txt?

Thanks (1)
Replying to cbp99:
avatar
By lemonjellyfish
03rd Aug 2020 12:49

Hi, tried this but it doesn't work. The .txt file that was produced from Sage had loads of commas (place fillers??) When I save the .csv as .txt it doesn't have those.

Thanks (0)
avatar
By lemonjellyfish
03rd Aug 2020 12:47

Thanks, it was the relationship manager who passed me on. I got the vibe that I shouldn't have been bothering him with it in the first place.

Thanks (0)
avatar
By louised
03rd Aug 2020 14:33

Does it work if you right click the csv and tell it to open in notepad? then you can save it as txt

Thanks (0)
Share this content

Related posts