cancel
Showing results for 
Search instead for 
Did you mean: 
julia7
Level 1

How do I create a report for a batch of vendor invoices I'm entering today so I can check against a control total? They have different dates & are for different vendors.

 
3 Comments 3
Alessandra_B
QuickBooks Team

How do I create a report for a batch of vendor invoices I'm entering today so I can check against a control total? They have different dates & are for different vendors.

Hey @julia7.

 

You can view and customize the Accounts Payable Aging Summary report to get the data you need. Let me show you how.

  1. On the left panel, click on Reports.
  2. Look for Accounts Payable Aging Summary on the search bar.
  3. Choose the Report period.
  4. Click on Run Report.

Also, you can view all transactions per customer by clicking on the total amount.

 

You can also view and customize other reports like the Unpaid Bills, and Bills and Applied Payments report.

 

Feel free to read this article for more information: How to Customize Reports?

 

If you have other concerns, please leave a comment below or post again. I'll be here to assist you. 

MickeyT1
Level 1

How do I create a report for a batch of vendor invoices I'm entering today so I can check against a control total? They have different dates & are for different vendors.

I agree that this would be amazingly helpful as a double-check.  I'd like it to include amounts and accounts assigned, and be able to run it for bills entered in a batch.

Catherine_B
QuickBooks Team

How do I create a report for a batch of vendor invoices I'm entering today so I can check against a control total? They have different dates & are for different vendors.

I can help you customize the report, MickeyT1.

 

Instead of the Accounts Payable Aging Summary report, you can run the Transaction List by Vendor report where you can filter to only show bills and which date you want to pull up. You can also customize it by adding the Account, Due Date, and Open Balance column and add columns for the transaction open balance. 

 

Let me show you how: 

 

  1. Click Reports and enter in the search field Transaction List by Vendor.
  2. At the upper-right, click Customize.
  3. Select the Report period or enter a custom date.
  4. Under Rows/Columns, you can click Change columns.
  5. Check the Due Date and Open Balance box and add columns according to the data you need.
  6. Under the Filter section, check Transactions Type and select Bills.
  7. Click A/P Paid and select Unpaid so you'll know that the bills within that date are still open and unpaid.
  8. Select Run report to refresh.

While the option to itemize what you entered in a bill, you'll have to manually open it to review. 

 

Feel free to use this article for your next step in handling reports such as saving a customized report, sending, or exporting them: Save custom reports.

 

Let me know if you have other questions so I can help you with them especially when running reports. I'm just around ready to assist you. Take care!

Need to get in touch?

Contact us