Learn how to export reports to Excel from QuickBooks Desktop.
Want to take your reports out of QuickBooks and analyze them in Microsoft Excel? You can export reports as Excel workbooks (.xlsx), CSV spreadsheets, or PDFs. We’ll show you how.
In this article, you'll learn how to:
- Export a report as Excel in QuickBooks
- Generate Excel-based payroll reports
- Get updated reports while working in Excel
- Enable Macro Settings in Excel
Export a report as Excel in QuickBooks
Any report in QuickBooks can be exported to Excel.
QuickBooks Desktop for Windows
- Go to Reports, then Reports Centre.
- Find and double-click the report you want to export.
- Select the Excel ▼dropdown, then Create New Worksheet or Update Existing Worksheet.
- If you see a message that says your report has too many columns, select Advanced, then uncheck the Space between columns checkbox. Select OK.
- When you’re ready to export, select OK.
Generate Excel-based payroll reports
Excel-based payroll reports contain data that is only available in Excel. The following are the Excel-based payroll reports available in QuickBooks Desktop for Windows.
- Payroll Summary
- Payroll Item detail
- Payroll Detail Review
- Payroll transactions by payee
- Payroll transaction detail
- Payroll Liability Balances
- Payroll Item listing
- Employee Earnings summary
- TD1 Review List
- T4 Summary
- PD7A Summary
- Relevé 1 Summary
- Remittance Report
- Employee Contact List
- Employee Withholding
- Vacation Summary
Get updated reports while working in Excel
After you export, you can get the latest version of the report from QuickBooks while you're in Excel.
| Important: The first time you update a report from Excel, make sure QuickBooks Desktop is open. This sets your preferences and permissions. After that, you can update reports from Excel even if QuickBooks is closed. |
- In Microsoft Excel, go to the QuickBooks tab. Excel adds this automatically the first time you export a report.
- Select Update Report to get the latest version of the report from QuickBooks.
Enable Macro Settings in Excel
Macros are small programs that run inside Microsoft Excel. They allow you to automate repetitive tasks and perform complex calculations on your data without having to do it manually.
If there is a security warning and an Enable Content button
- Select Enable Content.
If there isn't an Enable Content button
- Select File, then Options.
- Select Trust Centre, then Trust Centre Settings.
- Select Macro Settings, then Disable all macros with notification.
- Select OK twice to save the settings.
- Close and re-launch the workbook from QuickBooks Desktop.