cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
May Dare
Level 1

Bacs payments for purchase ledger

Can you please assist in creating Payment Report showing supplier name, bank accounts, amounts and reference. that can the be exported to BACs for payment.
Quickbooks not having a bacs payment option for suppliers is a financial control weakness.

Solved
Best answer March 06, 2019

Accepted Solutions
AldrinS
QuickBooks Team

Bacs payments for purchase ledger

Hi there, May Dare.

 

Allow me to chime in for a moment and provide additional clarification regarding this matter.

 

As my colleague Amanda G mentioned, a report that has all of this information is unavailable at this time. However, you could pull up the Supplier Contact List and Supplier Balance Summary reports and customise them with columns that'll show the information you need.

 

The instructions below will guide you through the entire process:

 

To pull up and customise reports in QuickBooks

  1. Click Reports in the left navigation menu.
  2. Search for Supplier Balance Detail and select it.
  3. Click the Customise button.
  4. Select Rows/Columns, then Change columns.
  5. Check all the relevant columns that you want to see on the report.
  6. Click Run report, then repeat these steps for the other report.

If you still prefer to speak with someone over the phone, please contact our dedicated Support Team by clicking this link. It'll route you to our webpage where you can get their hotline number. This team has special tools like screen sharing and guide you through the step-by-step process on how to customise these reports.

 

Let me know how it goes, I'm here to ensure your success. Thanks for coming to the Community, I'll keep an eye out for your response.

View solution in original post

5 REPLIES 5
Amanda G
QuickBooks Team

Bacs payments for purchase ledger

Hello,

 

At this moment in time we don't have a report with that information available. You may be able to run an open supplier report and customise this.

 

Thank you.

May Dare
Level 1

Bacs payments for purchase ledger

Can you please contact me to assist in customising the open supplier report. This issue was raised by our auditors and its seen as a major weakness more so when compared to other products like Sage 50

AldrinS
QuickBooks Team

Bacs payments for purchase ledger

Hi there, May Dare.

 

Allow me to chime in for a moment and provide additional clarification regarding this matter.

 

As my colleague Amanda G mentioned, a report that has all of this information is unavailable at this time. However, you could pull up the Supplier Contact List and Supplier Balance Summary reports and customise them with columns that'll show the information you need.

 

The instructions below will guide you through the entire process:

 

To pull up and customise reports in QuickBooks

  1. Click Reports in the left navigation menu.
  2. Search for Supplier Balance Detail and select it.
  3. Click the Customise button.
  4. Select Rows/Columns, then Change columns.
  5. Check all the relevant columns that you want to see on the report.
  6. Click Run report, then repeat these steps for the other report.

If you still prefer to speak with someone over the phone, please contact our dedicated Support Team by clicking this link. It'll route you to our webpage where you can get their hotline number. This team has special tools like screen sharing and guide you through the step-by-step process on how to customise these reports.

 

Let me know how it goes, I'm here to ensure your success. Thanks for coming to the Community, I'll keep an eye out for your response.

CLP417
Level 2

Bacs payments for purchase ledger

HI

I want to print off a bank payments report

I have added bank sort code, bank ac etc as customised fields

 

Next - how can I add these to a report for printing?

 

Thanks

Ashleigh1
QuickBooks Team

Bacs payments for purchase ledger

Hello CLP417, thanks for posting on this thread, so no not really, it all depends on what report you are looking at but custom fields can only be added as a column on some sales reports, not expense ones. 

Need to get in touch?

Contact us