Desktop Vendor Open Balance Accuracy

When running the Vendor Open Balance report, it will display your current open bills instead of the open bills at a specific time. This is because the Paid filter depends on the current status of the bill. To work around this, you can set the Paid Status filter to "Either" instead of "Open." Then, you can add the "Paid" and "Paid Date" columns to track your transactions more effectively. I'll guide you through the process.

1. Open your QuickBooks Desktop company.
2. From the Vendor Balance Detail report, click Customize Report. 
3. Add checkmarks to the 'Paid' and 'Paid Date' columns.
   
   
    
4. Click the Filters tab and enter Paid Status from the field.
   
   
    
5. Select Either, then hit OK. 

See the sample screenshot below of what the report should look like.

To learn more about personalizing your report, check out this article: Customize reports in QuickBooks Desktop.

Moreover, the idea of tracking an open bill for a specified period is also crucial to any business. Thus, I recommend sending feedback to our product developers team. They can review which parts of the program need enhancements and consider adding them to future updates. Here's how:

1. Go to the Help menu.
2. Select Send Feedback Online then choose Product Suggestion.
3. Enter your suggestion.
4. Click Send Feedback.

In case there's information you want to add to your report that is not available within QuickBooks, you can also export it to Excel. From there, you can personalize your data further manually.

The Community team is always around if you have more questions or need help in handling vendor transactions in QuickBooks. Just let us know in the comments below. 

Hi Nicole_N,

• Paid Date Column - neither your or my report shows a date in this column

Please also be aware that some payments include several invoices.  Your example shows one-to-one. One check for one invoice.

Thanks for getting back and sharing some updates on your concern, @GoforitRichard. Let me share some insights about the feature limitation on the Paid date column in QuickBooks Desktop (QBDT).

The concept of monitoring an outstanding bill for a set period is essential for any business. Therefore, I suggest providing feedback to our product development team. They can evaluate which aspects of the software require improvements and possibly incorporate them into future updates.

Here's how:

1. Click on the Gear icon.
2. Under Profile, select Feedback.
3. Enter your suggestions.
4. Then hit Submit.

In case there's information you want to add to your report that is not available within QuickBooks, you can also export it to Excel. From there, you can personalize your data further manually.

After everything is set, you can visit this article to help you with the Reconciliation workflow: Learn the reconciliation workflow in QuickBooks. 

In the meantime, if any other concerns arise or if you have additional questions about handling vendor transactions in QBDT, please don't hesitate to add a reply below. I'm here to ensure you'll receive the help needed.

Hi QuickBooks Team,

With all due respect, if you work for QuickBooks and I address an issue, you the QuickBooks Team member should internally report the issue not a user who pays for the service.

Richard