Skip to main content
R
report hack
July 6, 2022
Question

Vendor bills and associated check number Report Needed

  • July 6, 2022
  • 2 replies
  • 0 views

Does anyone know a way to match the vendor bill to the check number in QBO.  We need a report by row that lists the vendor name, invoice #, date, due date, AP status and check number .  The bills and applied payments come on two separate lines and it is cumbersome to adjust everything in excel.  I want to reconcile vendor statements using Vlookup in excel (looking up the vendor invoice number and returning the check number).  Can't seem to make this work.  Any ideas would be appreciated. 

2 replies

G
GebelAlainaM
July 7, 2022

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!

R
report hackAuthor
July 8, 2022
Original commenter did not share additional details
R
report hackAuthor
July 8, 2022

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

D
DebSheenD
July 8, 2022

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!

Terms & ConditionsAccessibility statement