Skip to main content
C
chelsea.donnelly
July 9, 2024
Question

Can I get a list of all unpaid bills & supplier credits on a given date, without QBO applying supplier credits to bills?

  • July 9, 2024
  • 1 reply
  • 0 views
I'm trying to run a list of all bills and supplier credits that were outstanding on 30 June 2024. However, when I run the Aged Payable Detail report, it lumps some bills and supplier credits together. 

For example - I know that the following invoices were outstanding at 30 June, all to the same supplier: 
 - Bill 1 dated 24/5/2024 for $493.80
 - Bill 2 dated 1/6/2024 for $275.55
 - Bill 3 dated 1/6/2024 for $115.40
 - Bill 4 dated 2/6/2024 for $312.31
 - Bill 5 dated 3/6/2024 for $1,747.05
 - Credit dated 5/6/2024 for -$1,406.95
TOTAL $1,537.16 outstanding. 

When I run the Aged Payable debtors report, it doesn't list each one separately. Instead it only shows me: 
 - Bill 5 dated 3/6/2024 for $1,747.05 with an open balance of $1,537.16. 

The total value outstanding is correct, but each bill is for a different project so I need a report that will list them out separately. Has anyone found a way to fix this? 

1 reply

I
IntuitSheila
July 9, 2024

Hi Chelsea,

 

There are different reports available in QuickBooks Online to view supplier transaction list. You can try to run Expenses by Supplier Summary report and Transaction List by Supplier. Here's how to:

 

  1. Click on the Reports tab.
  2. On the search box type in Expenses by Supplier Summary.
  3. Select a Report period and Accounting method.
  4. Click on Run report.
  5. Select the total amount for a specific supplier to be routed to the Transaction Report and totals.
  6. Click on Back to report summary and repeat the same process to view other suppliers transaction list.
  7. From the Reports page, you can also search Transaction List by Supplier report and click on Customise report to add Filters, Rows and Columns.

Another area you can check is by going to your Expenses tab section. 

 

  1. Click on the Expenses tab.
  2. Select Suppliers and click the supplier name.
  3. Under Transaction List click on Filter to customise date range.
  4. Click on Apply
  5. Click on the Export to excel icon to view and export report.

 

Check this link to learn more about Customising reports in QuickBooks Online.

 

Post again in the Community if you have other questions about reports in QuickBooks Online.

C
chelsea.donnellyAuthor
July 11, 2024

Hi,

Thanks for the reply.  

What I need is a list of all bills and supplier credits that remain unpaid on the 30 June 2024. 

The 'Expenses by Supplier' report gave me a list of all bills and supplier credits, but is there a way that I can filter this to only show the transactions that were still outstanding on 30 June 2024? And is there a way it will list all transactions individually, and not summarized by supplier? 

Thanks 

Chelsea 

I
IntuitSheila
July 11, 2024

Hi Chelsea,

 

When running the Transaction List by Supplier, you can click on Customise button to add Rows/Columns and Filters to show Unpaid bills and show the open balance. Let me guide you how:

 

  1. Click on the Transaction List by Supplier.
  2. Click on Customise.
  3. Set a Customise date to show transactions for a specific period.
  4. Click on Row/sColumns to add Open Balance.
  5. Click on Filter and tick box for A/P Paid and select Unpaid only.
  6. Click on Run report.

Another report you can run in the Unpaid Bills report.

 

  1. Click on Reports tab.
  2. Search Unpaid bills.
  3. Click on Customise and click on Filter.
  4. Tick Supplier box and on the file select the specific supplier name.
  5. Click on Run report.

If you still need help running report, I recommend also contacting our Customer Care Team. That way, they can check your account version and see the possible reports available.

 

Post again in the Community if you need help with QBO report. 

 

Terms & ConditionsAccessibility statement