How to Export Reports from QuickBooks Online to Excel

To export a report from QuickBooks Online to Excel, open the report, use the report’s export option, save the file, and open it in Excel to confirm the data came through. This guide covers report exports only. It does not cover list exports or transaction-detail exports, which use different screens and options.

Before you export

Make sure you are signed into the correct QuickBooks Online company and that the report you want is already open on the screen. The export option appears on the report page, so if you are still on a menu or dashboard, you will not see it.

Before you start, check these basics:

• You are in the right company file.
• The exact report you want is open.
• You can see the report toolbar or action menu near the top of the report.

Export the report to Excel

1. On the open report, find the export option in the report toolbar. In QuickBooks Online, it is usually labeled Export or Export to Excel.

2. Select the Excel export option. QuickBooks will generate a spreadsheet file version of the report.

3. If QuickBooks asks you to choose a file format, choose the Excel format it provides. Use the Excel option, not a different export type unless you specifically need that format.

4. Save the downloaded file to a folder you can find again, such as Downloads or your accounting folder. If your browser asks whether to open or save the file, save it first so you know the download completed.

5. Wait for the file download to finish before closing the browser or moving to the next task.

Open the file and check the result

Open the downloaded file in Excel, not in a browser preview or another app that may show it differently. The workbook should open as a spreadsheet with the report data in rows and columns.

Check these items right away:

• The column headings match the report you exported.
• The numbers and date range match what you saw in QuickBooks Online.
• The total lines and visible detail look right for the report type you chose.

If you exported a summary report, expect summary totals rather than every transaction line. If the file opens correctly and the figures match, the export worked.

If the export looks wrong

If the spreadsheet looks different from the on-screen report, check the file in Excel first. Some layout changes are normal during export, especially if the report uses special formatting, narrow columns, or grouped sections.

Start with these checks:

• Confirm you opened the file in Excel, not a different spreadsheet app with its own formatting rules.
• Compare the exported file’s date range, filters, and accounting basis with the report you had open in QuickBooks Online.
• Look for hidden columns, wrapped text, or columns that need resizing.
• Make sure you exported the same report, not a similar one with a different name or filter set.

If columns are missing, go back to the report in QuickBooks Online and confirm the report itself includes them before exporting again. If the layout is still not usable, export the report again and then clean it up in Excel by adjusting column widths or formatting. Do not assume the numbers are wrong just because the layout shifted; often the data is there, only the formatting changed.

Exporting a report vs. exporting a list or transaction detail

A report export gives you the report that is on screen. A list or transaction-detail export gives you records from a list or activity view, and that is a different process.

Use a report export when you need:

• A summary report such as profit and loss or balance sheet.
• The same grouped layout you see on the report screen.
• A spreadsheet copy of the report output.

Use a different export path when you need:

• Each invoice, payment, bill, or expense line.
• Item-level detail instead of grouped totals.
• Supporting detail for a specific account, customer, or date range.

If you only need summarized numbers, the report export is the right tool. If you need every transaction behind the totals, open the detailed report or the relevant transaction list first, then export that instead.

Conclusion

When the export works, you will have a file you can open in Excel, and the numbers, dates, and headings will match the report you exported from QuickBooks Online.