expenses by vendor detail report in quickbooks desktop app

Once you have the data ready, export both reports to Excel using the Excel button at the top of the report.

Choose Multiple Transaction Types and pick the bill payment and checks or other transactions you need.

In the Filter search box, enter and select Transaction Type.

Click the Customize Report button at the top and update the Report Date Range.

Select Transaction List by Vendor from the result.

From the Reports menu select Vendors & Payables.

Then export it to Excel and combine the information manually there. Therefore, the system is unable to pull the information in there.Īs a workaround, you may pull up another report that shows bill payments and checks. If you're referring to the columns Check # and Paid Date having blank data, consider that this report you're pulling up involves transactions without these fields.

This means that, the data you see on every report is derived from the details of its source transaction. I can share a few insights about this report and its columns, follows the Sources and Targets concept to build company and financial reports.

Expenses by vendor detail report in quickbooks desktop app