Export Invoices from QuickBooks to Excel

Getting your invoices out of QuickBooks and into Excel sounds like it should be one button, and sometimes it is. Other times you click Export, open the file, and find a flat list of invoice numbers and totals with none of the line-item detail you actually needed. The right method depends on which version of QuickBooks you run, whether you want a simple list or full line items, and how many invoices you are pulling.

This guide covers every practical way to export invoices from QuickBooks Online and QuickBooks Desktop to Excel: the Sales list export, the report exports that include line items, the row limits to watch for, and the fastest route when the invoices you need in a spreadsheet are PDFs from vendors rather than transactions already inside QuickBooks.

Can you export invoices from QuickBooks to Excel?

Yes. QuickBooks Online exports invoices to Excel two ways: from the Sales list under Sales, then All Sales filtered to Invoices, using the export icon above the table, or from a report like Invoice List or Sales by Customer Detail. QuickBooks Desktop exports the same data through its report screens. The list export gives invoice-level rows; for full line items you need a detail report.

Which method you choose comes down to two questions: do you need just the invoice header data (number, customer, date, total) or the individual line items, and are you on QuickBooks Online or Desktop? The sections below match each situation to the cleanest export.

How to export invoices from QuickBooks Online to Excel

The fastest export in QuickBooks Online is straight from the Sales list. Go to Sales in the left menu, choose All Sales, then set the Type filter to Invoices. Add a date range or a specific customer if you only want part of the list. Above the table on the right, click the export icon (an arrow pointing up out of a tray) and choose Export to Excel. QuickBooks downloads an .xlsx file with one row per invoice.

What the Sales list export includes

The Sales list export gives you invoice-level columns: date, invoice number, customer, due date, balance, total, and status. It is perfect for an aging review, a quick revenue tally, or sending a list of open invoices to a client. What it does not include is the line items inside each invoice, so if you need quantities, products, and per-line amounts, use a detail report instead.

How to export invoices with line items from QuickBooks Online

QuickBooks Online has no single button that exports an invoice with all its line items, so use the Sales by Customer Detail report. Go to Reports, open Sales by Customer Detail, click Customize, set Transaction Type to Invoices under Filter, pick your date range, and add the columns you want. Click the export icon and choose Export to Excel, and each line item lands on its own row.

The Invoice List report

For a cleaner header-level list with more control than the Sales screen gives you, open Reports and search for Invoice List. Customize the period, customers, and columns, then use the Export drop-down and select Export to Excel. This report is the better choice when you want a tidy list of invoices with a consistent set of columns rather than the detail-heavy customer report.

How to export invoices from QuickBooks Desktop to Excel

QuickBooks Desktop exports invoices through its report screens, not the transaction list. Open Reports, run a report that shows your invoices (for example Sales by Customer Detail or a customized transaction detail report filtered to invoices), then click the Excel button at the top of the report and choose Create New Worksheet. Desktop sends the data straight into a new Excel workbook or a CSV file.

One thing to know up front: IIF files cannot export transactions like invoices, bills, or payments, so do not reach for IIF when you want invoice data in a spreadsheet. IIF is built for lists such as your chart of accounts and customers, not transactions. Stick with the report-to-Excel path for invoices.

How many invoices can you export at once?

QuickBooks Desktop caps a CSV export at 32,770 rows and an .xls export at 65,536 rows, the legacy Excel sheet limit. If a report runs past those limits, split the export into smaller date ranges, monthly or quarterly, and stack the files afterward. QuickBooks Online has no fixed published row cap on report exports, but very large reports load slowly, so date-range chunks help there too.

If you regularly bump into these limits, exporting in monthly batches is the standard workaround. It also keeps each file small enough to open and check quickly, which matters when you are reconciling or handing data to a client.

Why won't my QuickBooks invoice export open correctly in Excel?

The usual culprits are a missing Excel install, a stale browser session, or a report still set to a screen layout. In QuickBooks Desktop, the Excel button needs a working copy of Excel on the same machine. In QuickBooks Online, if the export icon is missing, refresh the page or switch browsers, since an expired session hides the button. Always export from the report or list view, not from an open single invoice.

If numbers arrive as text or dates look wrong after export, it is usually Excel's regional formatting, not QuickBooks. Set the affected columns to Number or Date format, and use the US month/day/year date format so the values sort and calculate correctly.

How to get vendor invoices into a spreadsheet, not just QuickBooks invoices

Exporting works for invoices already recorded in QuickBooks. The harder problem is the stack of vendor invoices that arrive as PDFs, scans, and email attachments and were never keyed in. QuickBooks cannot read those files directly, so the data has to be extracted first. That is the inverse task: turning an external invoice document into clean spreadsheet rows you can then review or import.

An AI invoice data extraction tool handles that in one step. Upload a PDF, scan, or phone photo and the model reads the vendor, invoice number, dates, every line item, tax, and total, then writes them into a clean Excel or CSV file. Unlike the QuickBooks line-item export, which only works on transactions already inside the system, this works on any supplier document. See the invoice to Excel converter for the full workflow, or the invoice PDF to Excel converter when your files are all PDFs. If you would rather see the field-by-field method first, our walkthrough on how to extract invoice data to Excel covers which columns to pull and how to lay them out.

How to put the extracted invoices back into QuickBooks

Once vendor invoices are extracted into a spreadsheet, you can import them into QuickBooks rather than retyping each one. QuickBooks Online imports invoices from CSV or Excel under Settings, Import data, Invoices, with the customer or vendor and the product or service needing to exist first. Our walkthrough on importing invoices into QuickBooks covers the exact columns, date format, and batch limits, and the guide to converting a PDF invoice to Excel shows the extraction step in detail. Because most accounting imports expect a delimited file rather than a workbook, an invoice PDF to CSV converter gets you the exact upload format QuickBooks asks for.

The full loop for a bookkeeper closing the month often spans more than one document type. When it is time to reconcile, the bank side of the close usually means pulling statements into a spreadsheet too, which a bank statement to Excel converter handles the same way. And if your invoices arrive as email attachments rather than downloads, it helps to capture the data straight from incoming email with mailparse.ai before it ever reaches a folder.

Frequently asked questions

Can I export a single invoice from QuickBooks to Excel?

Not directly with its line items. QuickBooks Online lets you print or save one invoice as a PDF, but there is no built-in button to export a single invoice with every line into Excel. To get line-level detail for one invoice, run the Sales by Customer Detail report filtered to that customer and transaction type, then export to Excel. For a quick header-level list, the Sales screen export is faster.

Does QuickBooks export invoice line items or just totals?

The Sales list export gives totals and header fields only, one row per invoice. To get line items, products, quantities, and per-line amounts, you have to run a detail report such as Sales by Customer Detail and export that. This is the single most common surprise people hit when exporting invoices, so choose the report path whenever line-level detail matters.

Can I export overdue or unpaid invoices from QuickBooks?

Yes. In QuickBooks Online, filter the All Sales list to Invoices and set the status to Open or Overdue before exporting, or run the Open Invoices report and export that to Excel. The exported file then contains only the unpaid or past-due invoices, which is the list most teams want for collections and aging analysis.

Is exporting from QuickBooks the same as backing up my data?

No. An Excel export is a snapshot of selected transactions for analysis or sharing, not a full backup. It does not preserve links, attachments, or the ability to restore your company file. For a true backup, use QuickBooks Desktop's backup company file feature or QuickBooks Online's export of all data, and keep the Excel files as working copies rather than your system of record.