cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
pankhaniaco
Level 1
posted
‎March 23, 2021 06:46 AM
last updated ‎March 23, 2021 6:46 AM

How can you generate a supplier balance year end report (like Dec 2020), to show bill amounts which were paid in the following year?

As the Biils are already paid in the current year, when you generate a supplier balance report till Dec 2020, it does not show the complete total owed till that date. This is why the accounta payable in the trial balance as at 31/12/2020 is different from the Supplier Balance report at the same date...
Reply
1 Comment 1
ReymondO
QuickBooks Team
QuickBooks Team
‎March 23, 2021 09:34 AM

How can you generate a supplier balance year end report (like Dec 2020), to show bill amounts which were paid in the following year?

Hey there, @pankhaniaco.

 

The Supplier Balance Summary report will only show your remaining balances for each supplier. This is why it isn't showing the bill amount you were paid last year.

 

However, you can run the Transaction List by Supplier report to generate this data in QuickBooks Online. This way, you can the payments you've made for each supplier. Here's how:

 

  1. Go to Reports and run the Transaction List by Supplier report.
  2. Filter its Report period to the Last Financial Year. 
  3. Click Run report.

transaction list by supplier.PNG

Additionally, you can customise your reports to have a better look at your transaction data. You can also memorise them to save their customizations.

 

Let me know how else I can help you with QuickBooks by adding a comment below. I'm more than happy to lend a helping hand. Keep safe!

Reply