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

Report Needed

Hi!  I'm looking to create a report.  We invoice our customers and do not receive payment for an extended period of time.  I have an agreement with many of my vendors that they receive payment when I receive payment from the items I purchased from them. 

 

Can anyone tell me how to create a report that shows unpaid invoices and gives a detailed list of items that were included on each invoice as well as the vendor name the item was purchased from, item name and price?

1 Comment 1
MichelleBh
Moderator

Report Needed

I'll ensure that you'll be able to get the data that you're looking for, @JLP227. You came to the right place for a response.

 

It's my pleasure to tell you how to create a report with the information you want. To accomplish your task in QuickBooks, you can produce a Custom Transaction Detailed Report

 

Follow these instructions:

 

  1. Go to the Reports menu on the upper right pane. 
  2. Select Custom Reports and pick Transaction Detail
  3. Click the Customize Report button. 
  4. In the Display section, check all the necessary columns you want to show in the report. 
  5. Go to the Filters window and choose the following: 

 

  • Item - pick All or selected items. 
  • Transaction Type- select Invoices
  • Name- choose the appropriate customer/vendor
  • Paid Status- hit Open 

 

      6. If the invoice has various items, they will appear in the list one at a time.

 

Check out this link for more details on customization: Customize reports in QuickBooks Desktop.

 

When you receive the funds, don't forget to record them in QuickBooks and deposit it in your bank. After that, reconcile it to ensure your books are always accurate. 

 

Browse the following articles for more information on managing vendor transactions, setting preferences, combining reports, and related subjects:

 

 

I can show you another guide or overview if you have other questions about your account. Feel free to leave a comment below, and the support is just a pole away. Be safe always. 

Need to get in touch?

Contact us