Payment advice report for a vendor

Hi there, AND2021.

Welcome back to the QuickBooks Community. I'll share steps to ensure you'll see a report that shows what you need. I suggest running the Vendor Balance Detail report and customize it. This way, you're able to edit or make any changes to the report to show the bill that will be paid and a calculated discount.

Here's how:

1. Click the Reports menu at the top.
2. Choose Vendor & Payables.
3. Select Vendor Balance Detail.
4. Click the Customize button and go to the Display and Filter tab. Then, choose specific details that you want to view on the report.
5. Click OK to save the changes.

For additional information on how you can customize the data, add or delete columns, add or remove information on the header/footer, and even personalize the font and style of the report, you can click this article: Customize reports in QuickBooks Desktop.

Please refer to this article to see steps on how you can create a journal entry or use discounts to write off vendor balances: Write off customer and vendor balances.

We’ll be here whenever you need help. Just visit us here, and I’ll make sure it will be taken care of. Keep safe.

I am not able to include a column for the discount date.

Thanks for getting back on this thread, AND2021.

We can run and customize the Bills by Due Date report to add the terms column. This will serve as the discount date column in QuickBooks Desktop.

Here's how:

1. Go to the Reports menu and then choose Industry Specific.
2. Select Retail Reports.
3. Choose Bills by Due Date.
4. Click Customize Report.
5. On the Search Columns field, type in terms, then place a checkmark in the box.
6. Choose the Filter tab.
7. On the Search Filter, type in terms, then click it.
8. Once done, click OK.

For further guidance, please see this article: Customize Reports.

You can also memorize reports in QuickBooks. This helps you saved the current customized settings for easy access in the future.

I'll be glad to help you again if you have more questions about running reports. Please get back to his thread to share your questions or concerns.

Has QuickBooks come up with a report that shows unpaid bills and allows a column to show discount date?

It would be nice to have a report that shows all unpaid bills due, but then also shows which bills will get a discount if paid by a certain date. 

Other accounting programs do this easily.  I can't believe QuickBooks wouldn't offer this.

I appreciate you for joining the thread, @Jessie05.

I can see how the feature to run a report that shows all unpaid bills due and bills that gets a discount if paid by a specific date would be helpful for you. Currently, this isn't available in QuickBooks Desktop. In the meantime, it's best to put your suggestions regarding this option to our product developer. Here's how:

1. Go to the Help menu in the upper-right corner.
2. Select Send Feedback Online and click Product Suggestion.
3. Type your suggestion.
4.  Click Send Feedback to submit.

You may visit this article to learn how to customize any report you can generate: Customize reports in QuickBooks Desktop.

The Community always welcomes you for further inquiries. Have a great day ahead!