Skip to main content
February 12, 2024
Question

Is it possible to export the invoices including the line items into Excel?

  • February 12, 2024
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

February 12, 2024

You can use the exporter tool

https://get.transactionpro.com/qbo

 

JenoP
February 12, 2024

Thanks for joining us here in the Community, Mohammad. I appreciate you reaching out about exporting invoices to Excel with line item details.

 

For now, exporting the Invoices to Excel will not include the line details. 

 

As a workaround, you can run the Sales by Customer Detail report. Then, customize this report to only show the desired invoices before exporting it to Excel. This will provide the invoice header information and line item details in Excel for further analysis.

 

Let me show you how: 

 

  1. Go to the Reports menu and look for Sales by Customer Detail in the Search bar.
  2. Select the report to open it. 
  3. Click Filter in the upper-right-hand corner. 
  4. Select Transaction Type under FilterEquals under Operation, then Invoice under Value

 

 

 

Once you have the report, click Export/Print and then select Export to Excel

 

For additional resources, here are a couple of resources about exporting data out of QBO:

 

 

The QuickBooks Community is always available if you need more help or have additional questions, Mohammad. The QuickBooks Support team is also ready to assist to make sure everything is taken care of.

April 3, 2024

What if I have information on my invoices that doesn't have a item code?  For example a description of the work done was put under description and then the service lines below.  The report is only pulling those lines with a code.