Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
January 30, 2026
Solved

Can I export the details of a customer's invoice into excel? I have an invoice w/multiple lines. Would like to export to send to a client to upload into their QB

  • January 30, 2026
  • 1 reply
  • 194 views
No text available
Best answer by ArnoldJohn_C

It’s a pleasure to have you here in the Community, Dawn. You are most welcome.
 

Yes, you can export invoice details to Excel using the Sales by Customer Detail report. However, the exported file will need to be reformatted to match QuickBooks Online’s (QBO) CSV import template before your client can upload it into their QuickBooks. The export from reports doesn’t directly match the import format, so some manual CSV formatting is required.
 

To begin, export the invoice details to Excel by following the steps below:
 

  1. Go to the Reports section and open the Sales by Customer Detail report.
  2. Click Customize and under Filter, set Transaction Type to Invoices, and add a filter for the specific Customer.
  3. Adjust the Report period and add any additional columns you need under Columns.
  4. Click the Export icon beside the Print Icon and select Export to Excel.
     

After exporting, format the data using these steps to match QuickBooks Online’s import requirements:
 

  1. Open the exported Excel file. Remove any extra headers, subtotals, or unnecessary formatting.
  2. To get a sample of QuickBooks Online’s required format, go to the Gear icon and proceed to Import Data, select Invoices, then select Download sample CSV or Download import guide.
  3. Use this sample as a guide to organize your data. Make sure all Customer and Products and Services names in your file exactly match those in your client's QuickBooks , as they must already exist in their account.
  4. Save your file as a CSV.
     

Once your client decides to import, complete the process by following these steps:
 

  1. In QuickBooks Online, go to the Gear icon, select Import Data, then choose Invoices.
  2. Upload your formatted CSV file and map the columns to the appropriate fields.
  3. Review your data and proceed with the import.


If you or your client is planning to import multiple invoices moving forward, or need tips on how to properly map the fields during import, you can visit this helpful article for more detailed guidance: Import multiple invoices at once.
 

Feel free to reach out and let us know how it goes. We're always here to help.

1 reply

QuickBooks Team
January 30, 2026

It’s a pleasure to have you here in the Community, Dawn. You are most welcome.
 

Yes, you can export invoice details to Excel using the Sales by Customer Detail report. However, the exported file will need to be reformatted to match QuickBooks Online’s (QBO) CSV import template before your client can upload it into their QuickBooks. The export from reports doesn’t directly match the import format, so some manual CSV formatting is required.
 

To begin, export the invoice details to Excel by following the steps below:
 

  1. Go to the Reports section and open the Sales by Customer Detail report.
  2. Click Customize and under Filter, set Transaction Type to Invoices, and add a filter for the specific Customer.
  3. Adjust the Report period and add any additional columns you need under Columns.
  4. Click the Export icon beside the Print Icon and select Export to Excel.
     

After exporting, format the data using these steps to match QuickBooks Online’s import requirements:
 

  1. Open the exported Excel file. Remove any extra headers, subtotals, or unnecessary formatting.
  2. To get a sample of QuickBooks Online’s required format, go to the Gear icon and proceed to Import Data, select Invoices, then select Download sample CSV or Download import guide.
  3. Use this sample as a guide to organize your data. Make sure all Customer and Products and Services names in your file exactly match those in your client's QuickBooks , as they must already exist in their account.
  4. Save your file as a CSV.
     

Once your client decides to import, complete the process by following these steps:
 

  1. In QuickBooks Online, go to the Gear icon, select Import Data, then choose Invoices.
  2. Upload your formatted CSV file and map the columns to the appropriate fields.
  3. Review your data and proceed with the import.


If you or your client is planning to import multiple invoices moving forward, or need tips on how to properly map the fields during import, you can visit this helpful article for more detailed guidance: Import multiple invoices at once.
 

Feel free to reach out and let us know how it goes. We're always here to help.