Skip to main content
January 10, 2024
Question

Assistance Needed with Discrepancy in Unpaid Bills and Vendor Balance Summary

  • January 10, 2024
  • 1 reply
  • 0 views

I am currently facing an issue with my vendor and customer list. The problem lies in the fact that the final amount of my unpaid bills and aging summary does not match my vendor balance summary. I have deducted some amounts, and while these funds are no longer reflected in the unpaid bills and aging reports, they still seem to be affecting my vendor balance summary. I have attached a printout of the reports for your reference. Could you please assist me in resolving this matter? Thank you.

1 reply

MariaSoledadG
January 10, 2024

Thanks for the screenshot. I'll help you sort this out, Mark. 

 

Once you open the Vendor Balance Summary report, it will automatically defaults to All under the Date option. Therefore, it's giving you a different total amount. Please check out the screenshot below:

 

 

 

Whereas, both reports have similar total amounts when you open the A/P Aging Summary and Unpaid Bills Detail report: I'll sjhow you how:

 

 

 

To ensure that your Vendor Balance Summary matches the total amount to both reports, you'll want to customize the Date field by selecting the Custom option. Then select the same date as you what you have with the other reports.

 

 

 

 

Furthermore, learn how you can customize your data by adding or deleting columns, removing information on the header and footer, and even personalize the fond and style of report. I've added this article for more details: Customize Reports In QuickBooks Desktop.

 

You can always get back to us if you have any questions with the display of your reports. Remember, we're here to make sure everything is covered.