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

Can i exclude zero balances from the supplier balance detail report?

 
Solved
Best answer April 25, 2022

Accepted Solutions
Jovychris_A
Moderator

Can i exclude zero balances from the supplier balance detail report?

I can provide some steps to exclude zero balances from the Supplier Balance Detail report, @Havana.

 

You can start by customising the report and filtering the A/P Paid drop-down to Unpaid. In this manner, you'll only see open bill balances.

 

Let me show you how:

  1. From the Supplier Balance Detail report window, select Customise.
  2. Go to the Filter section.
  3. From the A/P Paid drop-down, select Unpaid.
  4. Once done, hit Run report.

 

Well done! You can also memorize this report by clicking the Save customisation button and save it. Then, you can just run this under the Custom reports tab in the Reports menu.

 

Additionally, I've included some articles that can help you with running reports. Especially when you want to send them to your email or export them to excel to include some data, filtering, and remove some columns:

 

 

Always remember you have us here if you other concerns about running reports. My peer and I will love to help you. Take care always!

View solution in original post

3 REPLIES 3
Ashleigh1
QuickBooks Team

Can i exclude zero balances from the supplier balance detail report?

Hello Havana, 

 

Welcome to the Community page, 

 

Yes you can if you are referring to transactions that were zeroed out. 

Havana
Level 1

Can i exclude zero balances from the supplier balance detail report?

Can you tell me how please?

Jovychris_A
Moderator

Can i exclude zero balances from the supplier balance detail report?

I can provide some steps to exclude zero balances from the Supplier Balance Detail report, @Havana.

 

You can start by customising the report and filtering the A/P Paid drop-down to Unpaid. In this manner, you'll only see open bill balances.

 

Let me show you how:

  1. From the Supplier Balance Detail report window, select Customise.
  2. Go to the Filter section.
  3. From the A/P Paid drop-down, select Unpaid.
  4. Once done, hit Run report.

 

Well done! You can also memorize this report by clicking the Save customisation button and save it. Then, you can just run this under the Custom reports tab in the Reports menu.

 

Additionally, I've included some articles that can help you with running reports. Especially when you want to send them to your email or export them to excel to include some data, filtering, and remove some columns:

 

 

Always remember you have us here if you other concerns about running reports. My peer and I will love to help you. Take care always!

Need to get in touch?

Contact us