Skip to main content
A
acc1
January 21, 2020
Solved

Does Quickbooks have the facility to export supplier payments into natwest bankline, directly?

  • January 21, 2020
  • 1 reply
  • 0 views
Original commenter did not share additional details
Best answer by GeorgiaC

I am also looking for this facility - I found the export bill payments list, but I'd need a way to include the bank account details of the supplier to be paid. Could this be added to the report so it shows supplier name, supplier sort code and supplier bank account number?


Hi BRS Sandie, 

 

Thanks for joining in on this thread, at the moment there's no way to input the supplier payment details onto this report, though we agree it would be a really useful feature to have to allow you to create the file you need. If you have a couple of minutes spare, please leave feedback for this by going to the Cogwheel > Feedback within your account, this way it'll be submitted directly to our developers who're able to review and implement such changes. 👩‍💻

1 reply

A
Ashleigh1
January 21, 2020

Hi Acc1,

 

Unfortunately their is no facility within QuickBooks to export supplier payments into natwest bankline, directly.

 

D
d-laxman
April 23, 2020

I have the same question, so put it another way, is it possible to output a payment file formatted for import into bankline?

I have attached the published standard for imputing payment files if that helps.

RenjolynC
RenjolynC
April 23, 2020

Hello there, d-laxman.

 

You can run a supplier report and export the payment information. To do that, run a Transaction List by Supplier and customise this report to only show the bill payments.

 

Here's how:

 

  1. Go to Reports on the left panel.
  2. Type Transaction List by Supplier in the search field.
  3. Select the Report period and click the Customise button.
  4. Click Filter and choose Bill Payment (Cheque) from the Transaction Type drop-down list.
  5. Hit the Run report button.
  6. Click the Export icon and select Export to Excel.

 

Here's a sample screenshot for reference: 

 

I'm also sharing this article for more details on what information you can export from QuickBooks Online: Export reports, lists, and more.

 

Feel free to leave a comment on this thread if you have any other questions or concerns. Take care.

    Terms & ConditionsAccessibility statement