We have a number of clients who pay us by Direct Debit.  Once a month we would input the collection amounts in to Barclays BIB manually and have continued to do this in Barclays.net but a the quantity of customers paying by Direct Debit increases the time to do this does too, not to mention the possibility of an error.

Barclays.net appears to have an import function but no guidance on how it should be used or how to build the file to import.  Is there a report which can be run in Sage will give me a spreadsheet which can be imported into the Barclays.net templates each month? 

I appreciate that there will be some populating of sage with bank and DD collection references etc. at the start but long term I am hoping that this can be done and will save hours of manual input each month.

Thanks

Leon