Exporting files to import into a bank such as Nat West Bankline

Question asked by Janet Stevenson 9 years ago

Hi All,

I read somewhere a comment by someone (stupidly I didn't note the name) that they had a way of exporting from Clear Books to import to online banking. I didn't go into it at the time because I was in the middle of something but today with half an hour to spare I decided to go back and look for the item. Now of course I can't find it and am beginning to think I must have been dreaming. I have payment runs of over 30 different payees at various times of the month. I need to be able to export these in a format which will be acceptable by Nat West Bankline to import directly into the bank. As there is a place in the setup for every supplier's bank details one would think that this could be done. Anyone out there have any tips to do this please. It will save me hours of time and negate errors in keying data as well.

Write reply3

3 Replies

Hi Janet,

You may be thinking of the option to export Unpaid Bills (BACS). If so you can access it by navigating to Tools > Export and choosing that option from the dropdown list.

https://s3-eu-west-1.amazonaws.com/uploads-eu.hipchat.com/36185/2561547/2KScHuLRkJFk3Uh/upload.png

It creates a file of the following format (the bank account details are absent because they were not filled in for these contacts):

https://s3-eu-west-1.amazonaws.com/uploads-eu.hipchat.com/36185/2561547/CQQVGeWHgB3ikoL/upload.png

I hope this helps.

Best answer
9 years ago

I know there's an option to export payroll to Bankline (never used it myself) but i've not noticed anything for general supplier payments if that's what you're looking for.

9 years ago

I don't use the payroll as it is too limited for the majority of my clients, but we do export through Sage Pay to the banks its a wonderful invention and saves hours of time and the possibility of paying the wrong people or the wrong amount, if it can be done through payroll here then there must be a way to do it thought the purchase ledger as with Sage 50 or Tas Books.

9 years ago

Hi Janet,

You may be thinking of the option to export Unpaid Bills (BACS). If so you can access it by navigating to Tools > Export and choosing that option from the dropdown list.

https://s3-eu-west-1.amazonaws.com/uploads-eu.hipchat.com/36185/2561547/2KScHuLRkJFk3Uh/upload.png

It creates a file of the following format (the bank account details are absent because they were not filled in for these contacts):

https://s3-eu-west-1.amazonaws.com/uploads-eu.hipchat.com/36185/2561547/CQQVGeWHgB3ikoL/upload.png

I hope this helps.

Best answer
9 years ago

Reply to this question

Attach images by dragging and dropping or upload
 

Your comments will be public and can be answered by anyone in the Clear Books community.

Find out what we do and who we are

Apps

Company

Social