Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowThanks 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:
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.
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.
I'd be glad to assist you with your concern, Allseason.
To proceed, I need to clarify whether you are trying to import invoices or if the Sales by Customer Detail report is not pulling the necessary information.
Additional information will help me narrow down the causes of this problem and provide an accurate resolution.
I'll be patiently waiting for your response. Stay safe!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here