From this window, you tell QuickBooks how to export a report to Excel. You can:
Create a new Excel worksheet (in a new or existing workbook)
In a new workbook:
Select in new workbook.
Click the Export button.
Save the report in Excel if you plan to update or use it later.
In an existing workbook:
Select in existing workbook.
Click the Browse button and locate the Excel workbook.
Click the Export button. QuickBooks creates a new worksheet in the selected workbook.
Update or replace an existing worksheet
Select Update an existing worksheet to update an existing worksheet with data from this report. Or select Replace an existing worksheet to overwrite an existing worksheet. The existing worksheet should be based on the same report you already sent to and saved in Excel.
Select either Update an existing worksheet or Replace an existing worksheet.
Click the Select a sheet drop-down arrow and select the worksheet you want to update or replace.
When you update an existing worksheet, QuickBooks preserves your formatting and many other changes you might have made, including:
Renamed column and row headings
Formatting changes such as font colors and size
New columns and rows you inserted
Most Excel formulas you updated or created
Important: You should send the same report you used to create the Excel report you want to update. Don't add columns or change the structure of the report. Only the report data should change, based on new or changed transactions, or a different date range. The report must be sent from the same company file.
If QuickBooks uncovers formulas that are missing data or can't be updated for other reasons, you'll see an alert page with instructions on how to proceed. You can choose to accept the changes or adjust your formulas to work with the new report.
In some cases, QuickBooks might not understand why you created certain formulas in specific locations. In those cases, QuickBooks will make adjustments, which you can review and correct, if necessary.
Send it to a comma separated values (.csv) file
Click the Advanced button to turn various Microsoft Excel features on or off.