Skip to main content
February 2, 2021
Question

AP detail. How do I setup this report to show each vendors invoice under their name and not by date?

  • February 2, 2021
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

February 2, 2021

Hi there, @userdon.

 

I'll share some clarification about running the A/P detail report.

 

Currently, we're unable to show the report to set it by the vendor. I know this will help a lot when you're able to spot it by name.

 

For now, I'd suggest customizing the Vendor Balance Detail report and filter some of its specifications, like showing All the paid and unpaid bills and setting the aging method to Report date. Then show its name.

 

This way, it will show the vendor's invoice under its name.

 

Here's how:

  1. Go to the Search icon.
  2. Type vendor balance and then select the Vendor Balance Detail report.
  3. Click the Customize button.
  4. Go to Filter and then set the Vendors and A/P Paid to show All.
  5. Click Aging and then tick Report date.
  6. Choose Run report.

 

Once done, click the mini Gear on the report. Uncheck the Date box and then check the Full Name box to show the invoices made under the vendor's name.

 

I've added a visual reference so you can see the output. I've changed the Report date and then Run report made for the following vendors last year.

 

 

To see more insights about creating specific financial statements, check out this resource: Customize reports in QuickBooks Online.

 

You can also keep the specified report by clicking the Save customization button for future use. Then run it under the Custom reports tab in the Reports menu.

 

If there's anything else you want to know about running reports in QuickBooks Online, feel free to post it here. I'll help you anytime. Have a good one!