cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
info1902
Level 1

I need to extract "descriptions" but not any report able to support

invoice list with descriptions
2 Comments 2
jamespaul
Moderator

I need to extract "descriptions" but not any report able to support

Hello, info1902.

 

I'm dropping by to help you extract your invoice list with descriptions. 

 

Some reports only display the Message on statement data (on the invoice) under the Memo/Description column. 

 

So, I take it that you're trying to extract the descriptions of the line items on the invoice. So, in this case, we'll want to use a report that shows associated line items. 

 

The best and closest report we can pull up is the Sales by Product/Service Detail report. By default, this shows all related sales from your customers, but we have the option to customise this to include only the invoices. 

 

Here are the steps: 

 

  1. Go to Reports.
  2. In the search box, type Sales by Product/Service Detail, then click the result.
  3. Click the Customise button.
  4. Make sure that the Memo/Description is enabled by expanding the Rows/Columns section, then checking Memo/Description
  5. Expand the Filter section. 
  6. Check Transaction Type, then select Invoice from the drop-down menu. 
  7. Hit Run report.

 

desc1.PNG

 

We also have the option to change how the invoices are grouped. Just select an option from the Group by drop-down menu. 

 

If you'd like to utilise other functions on the rest of the reports, check out this article: Customise reports in QuickBooks Online.

 

If you need to finalise your books after extracting the report, I'll share this guide with you on how to reconcile your accounts: Reconcile an account in QuickBooks Online

 

Do you need to pull up other reports? Or would you like some assistance with your entries? Fill me in with the details and I'll help you out again. 

Fiat Lux - ASIA
Level 15

I need to extract "descriptions" but not any report able to support