Vendor bills and associated check number Report Needed

It's glad to see you, @report hack. I'd be glad to help you run a report that'll show you the important details that you need.

We can pull up the Transaction List by Vendor report and then customize the report with the details you want to show on that specific report.

To pull up Transaction List by Vendor report, here's how:
 

1. Go to the Reports menu and search for Transaction List by Vendor then, click the report to open.
2. You may filter the date range if needed.
3. Select Customize.
4. Once done customizing your report, click Run Report to save changes.

Another report you can pull up is the Bills and Applied Payments report. You can follow the same process as you run and customize the Transaction List by Vendor report. For more details about filtering reports, you can refer to this article: Customize reports in QuickBooks Online.

If you want to export the reports and lists into individual Excel files in a zip format all at once, see this article: Export reports, lists, and other data from QuickBooks Online.

Please don't hesitate to post a reply if you have any clarification on the process or if you have any other concerns. I'll be here for you. Have a pleasant day ahead!

Thanks - yet when I run this report and filter, the vendor payment appears in one row and vendor bill(s) in the next row so I can't use v-lookup on the bill # and have it return the check # and date of payment.  Is there a report that does this in QBO?.  

The bill payment screen does show the check payment and the description field  includes the invoice #.  However, when trying to run this in custom reports, the description field is not populating. Is there a way to run a report with the header row as:

Vendor Name     Invoice #       Due Date       AP status         Bill payment #           date paid

Hello there, report hack.

I can share some information about running and customizing reports in QuickBooks Online (QBO). 

When you run a report in QuickBooks Online (QBO) and set the header in the report., it'll gather all the data or information on your account for all dates. It can cover two or more years or right when you have started the account. It'll also consider other filters that you set in the report.

Check out this article for more information on how to set the filters of your report based on your needs: Customize reports in QuickBooks Online.

To save the current customization you have to run the same report in the future with ease. See this article for further guidance: Memorize reports in QuickBooks Online. That will guide you on how to find, run, export to excel, and edit/delete it. 

Don't hold back to drop a comment below if you have any other questions or concerns about reports. I’ll be here to help. Take care always!

Has there been any update on how to get the bill payment (check)# on the same line as the bill information?

I recognize the need to see your bill payment or check on the same line of your bill information, @Accounting_01. Let me help you with that.

To start with, if you're referring to the bill itself, you can generate the Transaction List by Vendor report and include the Date, Transaction Type, Num, Posting, Memo/Description, Account, Amount, Vendor, Location, or any other relevant bill information in the Rows/Columns section. Then, you can filter the report to include the Bill Payment (Check) so that it will appear on the same line as your billing information.

Here's how:

1. Go to the left navigation panel and select Reports.
2. In the search section or find report by name, type Transaction List by Vendor and click it.
3. Select the option Switch to Classic View and click Customize.
4. Filter the correct Report Period and click the Change columns option.
5. Check the boxes for Vendor, Location, Ship Via, Delivery Address, or any other relevant bill information.
6. Select the Filter option and click the drop-down button of Transaction type. Then, choose Bill Payment (Check). You can also add the other transaction type.
7. Then, select the correct Account, Vendor, Location, Number, and Amount.
8. Verify the details and select Run Report.

I'll also provide these articles to help you make the most of your financial reports:

• Customize reports.
• Memorize reports.

If you have further concerns about getting the bill payment on the same line as the bill information or referring to something else, please mention me in the comment section, @Accounting_01. I'm here to assist in any way possible.

@Clark_B 

That absolutely did not work at all!

The check number is still not present. Why can't I simply choose this from under the expense tab? You all have that blocked out for some reason that makes no sense to me. 

I'll provide clarification regarding the Check number, bill and the bill payment placement inside QuickBooks Online (QBO), @Accounting_01.

Before anything else, know we want to ensure we're on the same page. Looking at the screenshot provided, do you want to add the Check number as a new column inside the report? If so, know the option you're trying to access is unavailable since the Num column inside the report also works as the check number for those transactions.

Additionally, the Bill and the Bill payment (Check) are two different types of transactions inside the program. Thus, they won't appear in the same line inside the Expenses tab on the left navigational bar. If you wish to send a feature request to our Product Development Team, we'll outline the steps to get you going:

1. Access your QuickBooks Online company.
2. On the top right-corner, click the Gear icon.
3. Select Feedback and then enter your comments or product suggestions.
4. Once ready, click Next to submit feedback.

Moreover, we're providing these articles to help you handle bills and other expenses inside QBO:

• Enter and manage bills and bill payments in QuickBooks Online
• Enter and manage expenses in QuickBooks Online

If you're referring to something else, please don't hesitate to visit us or comment below. This way, we can get back to you as soon as possible and provide the details needed.

@Kurt_M 

Thank you for the response! It would be very helpful for all in the accounting profession to see payment information that ties to the bill on a report. Managing data in the system is one thing but having the information readily available in a report tying the data together is another.

Thank you for your assistance.