Report showing vendor bills and paid date

kshaw0531 · ‎July 12, 2022

I've been spinning my wheels for quite some time so I'm hoping someone can help.

I'm looking for a report that lists all vendor bills for a specific vendor with the paid date using at least the following columns:

Vendor, Bill #, Bill Date, Paid Date, Open Balance

I've tried using many variations of the Transaction Detail Report, but every time I add the Paid Date column, it comes up blank, regardless of the transaction types I choose in the filter.

Rose-A · ‎July 12, 2022

I'm here to help ensure you're able to generate the report you need in QuickBooks Desktop, kshaw0531.

For now, showing the Paid Date details is unavailable in QuickBooks Desktop.

As a way around, you might want to include the Bill Pmt-Check on the report to show the paid date under the Date column or you can export the report into Excel and add manually add the Paid Date information from there. See the sample screenshot.

To help you manage your transactions in QuickBooks Desktop, check this write-up: Expenses and vendors. This will provide you links on how to handle expenses as well as other vendor-related tasks in QuickBooks.

I'm here to provide further assistance whenever you need one, so please let me know if there's anything else I can help you with. Have a great day, kshaw0531!

View solution in original post

Rose-A · ‎July 12, 2022

I'm here to help ensure you're able to generate the report you need in QuickBooks Desktop, kshaw0531.

For now, showing the Paid Date details is unavailable in QuickBooks Desktop.

As a way around, you might want to include the Bill Pmt-Check on the report to show the paid date under the Date column or you can export the report into Excel and add manually add the Paid Date information from there. See the sample screenshot.

To help you manage your transactions in QuickBooks Desktop, check this write-up: Expenses and vendors. This will provide you links on how to handle expenses as well as other vendor-related tasks in QuickBooks.

I'm here to provide further assistance whenever you need one, so please let me know if there's anything else I can help you with. Have a great day, kshaw0531!

BigRedConsulting · ‎July 12, 2022

I don't think there is a way to do it in QuickBooks using the built in report writer.

The Paid Date field is a weird little field that appears to be calculated at report time, but only for one or two specific reports, one being the Customers & Receivables Average Days to Pay report. And it only seems to be calculated for transactions that impact the A/R account like Invoices and Payments. If the report is modified to show A/P transactions, they field doesn't populate.

I tried different things and don't see a good solution within QuickBooks. I could write a custom report for you that would show the requested fields using your QuickBooks data. If interested, create a support request on our site mentioning the case: BRC - home

kshaw0531 · ‎July 14, 2022

Thank you both for your response. I was afraid that was the case. I did a lot of extra manual work in Excel to populate the Paid Date field. I would think this would be an easy fix for Intuit to do and probably a popular one as well. I'll put in a product suggestion. Thanks!

Topics

Training

Community

Resources

Report showing vendor bills and paid date