cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want an expert to help you set up your QuickBooks Online? Find out how: Click here
khuramtiles-gmai
Level 1

Urgent: Discrepancy in Supplier Balance Reports (Account Name: ABC)

Here's the situation:

I have an ABC supplier with an opening balance of -1,200 rupees entered on April 30, 2024.
The "Transaction List by Supplier" report accurately reflects both the opening balance and a subsequent expense transaction of 3,500,000 rupees for supplier ABC dated May 13, 2024.
However, the "Vendor Balance Detail" report only shows the opening balance of -1,200 rupees and does not reflect the 3,500,000 rupees expense transaction.
Troubleshooting Steps Taken:

I have verified the report date range and ensured no filters are applied that might exclude the expense transaction.
I have refreshed the report and re-entered the opening balance information (for verification).
I have reviewed the report customization options and confirmed all transaction types are included.
Request for Assistance:

I kindly request your assistance in investigating this issue and ensuring both reports accurately reflect the complete transaction history for supplier ABC. This includes the opening balance and the recent expense transaction.

Additional Information:

QBO Version : Plus
Thank you for your time and support in resolving this matter.
1 Comment 1
MariaSoledadG
QuickBooks Team

Urgent: Discrepancy in Supplier Balance Reports (Account Name: ABC)

Let me provide some details as to why both reports are showing differently, Khuram.

 

A  Vendor Balance Details report will only show your unpaid bills and the total amount you owe each. On the other hand, the Transaction List by Supplier provides a list of all transactions associated with a vendor, including journal entries. That is one of the reasons why the Vendor Balance Detail doesn't reflect the 3,500,000 rupees and shows a different amount.

 

You can choose to run other supplier or vendor reports that provide the right data for your business. Check out this article so you'll know the reports that are included in your subscription: Reports Included in your QuickBooks Online Subscription.

 

Additionally, create custom reports in QuickBooks using modern view. Consider reading this article for more details: Customise Reports in QuickBooks Online Using Modern View.

 

If you need further assistance with running reports or any other concerns vendor, post your comment below so we can get back to you. Have a great day ahead for the rest of the day!