Hey Accounts63,

Can i clarify something, you've said you'd like a report consisting of suppliers paid by bacs on a given date, this will be exported then used to pay suppliers? I'm reading that as a conflict, the report will show suppliers paid, which you'll use to pay the suppliers - aren't they already paid?

Are you trying to get a BACS spreadsheet to upload to your bank to initialise and use the banks features to make all the payments to the suppliers? Have you already marked the bills as paid on QB?

Do each of your payment transactions have the Sort Code and Account Number referenced on it, whether that is the Bill, Expense or Bill Payment? If you do, do you have that in the Memo/Description section?

I can't think of an existing report, I'm thinking you could use the Transaction List by supplier - then filter this to only show the transactions you want it to. As long as the Sort Code, Account number is on the Memo or Description of the transaction, this can show. You can add columns for Account, for memo and description. You can filter this to bring up paid or unpaid transactions, or both.

If i'm along the right lines, great! If i'm not, please correct me :)