Skip to content

How to Export from QuickBooks to Excel

Export from Quickbooks to Excel

In this post, you’ll learn how to export data from QuickBooks to Excel. All editions and versions of the accounting software enable you to export data data to excel or CSV files, which can be accessed and edited through any spreadsheet program. But there is a limitation on the type of data that you can export using the built-in utilities. You can ofcourse export customer vendor and payroll details. Further, you can export items – inventory, non-inventory, tax, etc. And to get filtered data out of QuickBooks, you can create and then export Reports in excel format.

In this post, you’ll learn how to export from QuickBooks to Excel.

User Navigation

Export Excel from QuickBooks Desktop

Let’s start with the desktop edition of the accounting software provided by Intuit. Since the online and desktop version have completely different user interfaces, users need to follow a different set of steps to export the data.

1. Steps to export customer list from QuickBooks Desktop to Excel:

  1. Log into QuickBooks company file as an admin.
  2. Go to the Customer/Vendor/Payroll center.
  3. Click on the Excel drop down option, and then choose one of these two options:
    1. Export Customer/Vendor/Employee list: this option enables you to export data for employees, vendors, and customers. Data that can be exported includes name, contact information, etc about the items.
    2. Export transactions: this option enables you to export invoices and bills from QuickBooks to Excel.
  4. Choose one of the two options in the Export window:
    1. Create a new worksheet: QuickBooks desktop creates a new excel file with the selected data.
    2. Update an existing worksheet: QuickBooks updates an existing Excel worksheet with the data selected by the user.
  5. Click on Export after checking your preferences.

2. Steps to export items from QuickBooks desktop to Excel:

  1. Log into QuickBooks company file as an admin.
  2. Click on Lists from the main menu.
  3. Choose Item list.
  4. Click on the Excel dropdown option, then select Export all items.
  5. Choose one of the two options in the Export window:
    1. Create a new worksheet: QuickBooks desktop creates a new excel file with the selected data.
    2. Update an existing worksheet: QuickBooks updates an existing Excel worksheet with the data selected by the user.
  6. Click on Export after verifying your preferences.

Report data that can be exported from QuickBooks Desktop to Excel includes:

  • Data filtered for the report
  • Calculations, totals, subtotals and formula used in the report
  • Labels that describe the items in each of the rows
  • Report headers and footers

3. Steps to export a report from QuickBooks Desktop to excel:

  1. Log into QuickBooks company file as an admin.
  2. Launch the report that you want to export.
  3. At the top of the report, click on the Excel drop-down option.
  4. Choose one of the two options in the Export window:
    1. Create a new worksheet: QuickBooks desktop creates a new excel file with the selected data.
    2. Update an existing worksheet: QuickBooks updates an existing Excel worksheet with the data selected by the user.
  5. Select your next options for the report in the Send Report to Excel window.
  6. Click on Advanced to access additional options in QuickBooks Desktop for data export.
  7. Click on Ok, then on Export.
  8. Launch the exported Excel file with the MS Excel or another spreadsheet program to make the required changes.

Note: you may have to ensure that On Printed reports and screen option is enabled in the Printing options section if the data you exported lacks header information.


Export invoices from QuickBooks to Excel

While QuickBooks desktop has no utility to directly export invoices, you can create a report and then export the report to get invoice data out of QuickBooks. So that’s exactly the process that I’ve elaborated below. First, I’ll guide you to create a customer report with transactions. Then I’ll provide the steps to export the invoices data from the report to Excel.

1. Steps to export invoices from QuickBooks to Excel:

  1. From the Customers menu, click on Customer Center.
  2. Click on the Transactions tab.
  3. Choose Invoices and apply the various filters to narrow down your search.
  4. Click on Run Reports once you’re sure that you’ve included all the invoices data that you want to export to excel.
  5. At the top of the invoices report, click on the Excel drop-down option.
  6. Choose one of the two options in the Export window:
    1. Create a new worksheet: QuickBooks desktop creates a new excel file with the selected data.
    2. Update an existing worksheet: QuickBooks updates an existing Excel worksheet with the data selected by the user.
  7. Select your next options for the invoices report in the Send Report to Excel window.
  8. Click on Advanced to access additional options in QuickBooks Desktop for data export.
  9. Click on Ok, then on Export.
  10. Use MS Excel or another spreadsheet program to launch the Exported Excel file that contains the invoices data.

Export item list from quickbooks to excel

1. Steps to export items from QuickBooks desktop to Excel:

  1. Log into QuickBooks company file as an admin.
  2. Click on Lists from the main menu.
  3. Choose Item list.
  4. Click on the Excel dropdown option, then select Export all items.
  5. Choose one of the two options in the Export window:
    1. Create a new worksheet: QuickBooks desktop creates a new excel file with the selected data.
    2. Update an existing worksheet: QuickBooks updates an existing Excel worksheet with the data selected by the user.
  6. Click on Export after verifying your preferences.

Export 1099 from quickbooks to excel

While QuickBooks lacks the ability to directly export 1099 data, you can still rely on the workaround I’ve mentioned below. Basically, you can run a custom report for transactions. By filtering the transactions on the basis of 1099 transactions, you can easily separate the 1099 data from the rest of the data.

1. Steps to export 1099 from QuickBooks Desktop to Excel:

  1. From the Customers menu, click on Customer Center.
  2. Click on the Transactions tab.
  3. Choose Invoices and Filter the transactions by Vendor.
  4. Choose only the 1099 vendors.
  5. Click on Run Reports after going through the preferences and ensuring that you’ve applied the filter for 1099 vendors.
  6. At the top of the transactions report, click on the Excel drop-down option.
  7. Choose one of the two options in the Export window:
    1. Create a new worksheet: QuickBooks desktop creates a new excel file with the 1099 data.
    2. Update an existing worksheet: QuickBooks updates an existing Excel worksheet with the 1099 data.
  8. Click on Ok, then on Export.
  9. Use MS Excel or another spreadsheet program to launch the Exported Excel file that contains the 1099 data.

Export estimate from quickbooks to excel

To export an estimate from QuickBooks Desktop to Excel, you’ve to first convert the estimate into an invoice. Then you can create a report for the invoice type and export it to excel.

However, this can be a very long and tedious process. For further help, get in touch with our data migration experts.

Export transactions from quickbooks to excel

Steps to export transactions from QuickBooks to excel are similar to those of invoices. Use the steps given below to export your transaction data from QuickBooks desktop to excel:

  1. From the Customers menu, click on Customer Center.
  2. Click on the Transactions tab.
  3. Choose Invoices and apply the various filters to narrow down your search.
  4. Click on Run Reports once you’re sure that you’ve included all the transactions that you want to export to excel.
  5. At the top of the transactions report, click on the Excel drop-down option.
  6. Choose one of the two options in the Export window:
    1. Create a new worksheet: QuickBooks desktop creates a new excel file with the selected data.
    2. Update an existing worksheet: QuickBooks updates an existing Excel worksheet with the data selected by the user.
  7. Select your next options for the transactions report in the Send Report to Excel window.
  8. Click on Advanced to access additional options in QuickBooks Desktop for data export.
  9. Click on Ok, then on Export.
  10. Use MS Excel or another spreadsheet program to launch the Exported Excel file that contains the transactions data.

Export customer list from QuickBooks to Excel

You can export a customer list from QuickBooks Desktop to excel with a few simple steps. Once you visit the customer center, you can export the entire list or choose specific customers and export data related to them.

Steps to export customer list from QuickBooks Desktop to Excel:

  1. Log into QuickBooks company file as an admin.
  2. Go to the Customer center.
  3. Click on the Excel drop down option, and then choose Export customer list.
  4. Choose one of the two options in the Export window:
    1. Create a new worksheet: QuickBooks desktop creates a new excel file with the customer data.
    2. Update an existing worksheet: QuickBooks updates an existing Excel worksheet with the customer data selected by the user.
  5. Click on Export after checking your preferences.

Export trial balance from quickbooks to excel

Trial balance shows the debit and credit balances of each ledger account. It is often used to create a balance sheet, one of the three essential financial statements. When you create a trial balance, you can export its data from QuickBooks Desktop to Excel.

Steps to export a report from QuickBooks Desktop to excel:

  1. Log into QuickBooks company file as an admin.
  2. Click on Reports from the main menu.
  3. Choose Accountant & Taxes.
  4. Click on Trial Balance from the available reports.
  5. Choose the Customize Report option to apply filters to the data.
  6. At the top of the  trial balance report, click on the Excel drop-down option.
  7. Choose one of the two options in the Export window:
    1. Create a new worksheet: QuickBooks desktop creates a new excel file with the trial balance data.
    2. Update an existing worksheet: QuickBooks updates an existing Excel worksheet with the trial balance data selected by the user.
  8. Select your next options for the report in the Send Report to Excel window.
  9. Click on Advanced to access additional options in QuickBooks Desktop for data export.
  10. Click on Ok, then on Export.
  11. Use MS Excel or another spreadsheet program to access the Excel file containing the trial balance data.

Export journal entries from quickbooks to excel

Journal entries are used to record transactions. These entries are then summarized in a general ledger so that the user can use the general ledger to create various types of financial statements. As journal entries record transactions, the steps to export them are similar to those of transactions.

Steps to export journal entries from QuickBooks desktop to excel:

  1. From the Customers menu, click on Customer Center.
  2. Click on the Transactions tab.
  3. Choose Invoices and apply the various filters to narrow down your search.
  4. Click on Run Reports once you’re sure that you’ve included all the journal entries that you want to export to excel.
  5. At the top of the transaction or journal entries report, click on the Excel drop-down option.
  6. Choose one of the two options in the Export window:
    1. Create a new worksheet: QuickBooks desktop creates a new excel file with the chosen journal entries data.
    2. Update an existing worksheet: QuickBooks updates an existing Excel worksheet with the journal entries data selected by the user.
  7. Select your next options for the journal entries report in the Send Report to Excel window.
  8. Click on Advanced to access additional options in QuickBooks Desktop for journal entry export.
  9. Click on Ok, then on Export.
  10. Use MS Excel or another spreadsheet program to launch the Exported Excel file that contains the journal entries.

Export chart of account from quickbooks to excel

As the chart of accounts simply lists all of the accounts present in a company file, you can export the chart of accounts as a list. The exported file will contain the names of all the accounts along with the information that you chose to specifically include in the report.

Steps to export the chart of accounts from QuickBooks Desktop to Excel:

  1. Go to Lists from the main menu.
  2. Click on Chart of Accounts.
  3. Choose the Reports dropdown menu from the bottom bar.
  4. Click on Account Listing.
  5. From the top bar, choose Excel.
  6. Choose one of the two options in the Export window:
    1. Create a new worksheet: QuickBooks desktop creates a new excel file with the chart of accounts data.
    2. Update an existing worksheet: QuickBooks updates an existing Excel worksheet with the chart of accounts data.

Note: you can choose a different report if you want a different set of data exported from Quickbooks Desktop.

Export vendor list from quickbooks to excel

You can export a vendor list, which contains details such as name, contact information, and balances of specific vendors, from QuickBooks desktop to Excel.

Steps to export vendor list from QuickBooks Desktop to Excel:

  1. Log into QuickBooks company file as an admin.
  2. Go to the Vendor center.
  3. Click on the Excel drop down option, and then choose Export vendor list.
  4. Choose one of the two options in the Export window:
    1. Create a new worksheet: QuickBooks desktop creates a new excel file with the vendor data.
    2. Update an existing worksheet: QuickBooks updates an existing Excel worksheet with the vendor data selected by the user.
  5. Click on Export after checking your preferences.

Export report from QuickBooks to Excel

Report data that can be exported from QuickBooks Desktop to Excel includes:

  • Data filtered for the report
  • Calculations, totals, subtotals and formula used in the report
  • Labels that describe the items in each of the rows
  • Report headers and footers

Steps to export a report from QuickBooks Desktop to excel:

  1. Log into QuickBooks company file as an admin.
  2. Launch the report that you want to export.
  3. At the top of the report, click on the Excel drop-down option.
  4. Choose one of the two options in the Export window:
    1. Create a new worksheet: QuickBooks desktop creates a new excel file with the selected data.
    2. Update an existing worksheet: QuickBooks updates an existing Excel worksheet with the data selected by the user.
  5. Select your next options for the report in the Send Report to Excel window.
  6. Click on Advanced to access additional options in QuickBooks Desktop for data export.
  7. Click on Ok, then on Export.
  8. Launch the exported Excel file with the MS Excel or another spreadsheet program to make the required changes.

Note: you may have to ensure that On Printed reports and screen option is enabled in the Printing options section if the data you exported lacks header information.

Export W2 from quickbooks to excel

Since W-2 form data is payroll data, you can export it by creating a payroll report. You’ve to select the correct type of report to get the data in the desired format.

Steps to export W2 form from QuickBooks to Excel:

  1. From the main menu, click on Reports.
  2. Click on Employees & Payroll.
  3. Choose the tax form report that you want to export, W2 in this case.
  4. When the report appears on your screen, click on the Export option on the top right corner of the screen.
  5. Choose Excel as the format you want to export the data in.
  6. Choose the location to which you want the file saved, and choose the Save option.

You can apply filters while creating the report or later when you open the exported file using Excel. While QuickBooks desktop has inbuilt filters, Excel doesn’t.

Export addresses from quickbooks to excel

In QuickBooks Desktop, you can store addresses for each customer and vendor. So depending on the addresses that you’re trying to export from QuickBooks, you need to choose to export either the customer data or the vendor data.

Steps to export addresses from QuickBooks Desktop to Excel:

  1. Log into QuickBooks company file as an admin.
  2. Go to the Customer or Vendor center.
    Note: the choice depends on the addresses that you’re trying to export. If you want to export addresses for customers, then choose Customer center, and vice-versa.
  3. Click on the Excel drop down option, and then choose Export customer/vendor list.
  4. Choose one of the two options in the Export window:
    1. Create a new worksheet: QuickBooks desktop creates a new excel file with the vendor or customer data.
    2. Update an existing worksheet: QuickBooks updates an existing Excel worksheet with the vendor or customer data selected by the user.
  5. Click on Export after checking your preferences.

Kindly ensure that you’ve selected addresses as one of the data types that you’re exporting for the list. If you deliberately deselect the addresses option, the data won’t appear in the exported excel file.

Export check register from quickbooks to excel

Most users need to rely on the print feature to export check register data from QuickBooks desktop to Excel. The print option enables the users to export the data in “Comma Delimited File”, which can be accessed using Microsoft Excel. Users can then save the data in excel format.

Steps to export check register from QuickBooks Desktop to Excel:

  1. From the edit menu, click on Use Register.
  2. Choose the Check Register whose data you want to export. Click on Ok.
  3. Choose the Print option.
  4. Choose the desired date range for the data.
  5. Choose the File option.
  6. Choose “Comma Delimited File
  7. Click on Print, and choose a local directory for storing the file.
  8. Click on Save.
  9. Open the export file using Microsoft Excel.
  10. Click on File, then choose Save as
  11. Choose Excel as the format and click on Save.

Export general ledger from QuickBooks to Excel

If you want to export all the general ledger accounts, then you can simply export all the transactions to Excel. However, if you want to filter transactions by a particular account before exporting them, then you should follow this method, which enables you to export the transactions related to general ledger accounts of your choice.

Steps to export general ledger from QuickBooks to Excel:

  1. From the main menu, click on Reports.
  2. Click on the Reports Center.
  3. Choose the report you created to filter transactions by general ledger accounts.
  4. Click on Excel from the toolbar on top of the report.
  5. Click on Create New Worksheet.
    Note: QuickBooks will export reports with less than 256 columns. If your report has more columns than the prescribed limit, then consider adding more filters or moving transactions associated with one account at a time.
  6. Choose Ok, then Export.

Export work order from quickbooks to excel

To streamline work and schedule, you can create work orders in QuickBooks desktop. While QuickBooks lacks the feature to create a work order directly, it still enables you to have reasonable workarounds to create such documents and reports.

Steps to export work order from QuickBooks Desktop to Excel:

  1. Go to the Edit menu and choose Preferences.
  2. Choose the Sales & Customers tab.
  3. Click on Enable Sales Orders, then Ok.
  4. Choose Sales Orders from the Dashboard or Home screen.
  5. Go to the Formatting tab, then choose Manage Templates.
  6. Click on the Custom Sales Order option.
  7. Click on Copy so that QuickBooks can create a duplicate of the template.
  8. Input a new name for the template, then click on Ok.
  9. Choose the Additional Customization option to alter the filters applied in the template.
  10. From the Header tab, alter the title to Work Order.
  11. Input all the necessary information to create the work order.
  12. Click on the Export icon on top of the report.
  13. Choose Export to Excel.
  14. Select the local directory to which you want to save the Excel file containing the reports data.

Export email list from quickbooks to excel

In QuickBooks Desktops, you can save the contact information for your customers and vendors. The contact information including email addresses can be exported from QuickBooks to Excel using the inbuilt utilities.

Steps to export email list from QuickBooks to Excel:

  1. Choose Reports from the main menu.
  2. Click on Customers & Receivables or Vendors & Payables.
  3. Click on the Customer/Vendor Phone list.
  4. Choose Customize Report.
  5. Choose Email as one of the fields to be included in the exported excel file.
  6. Click on Excel from the toolbar above the Report.
  7. Click on Save.

Export inventory from quickbooks to excel

You can export items, such as inventory and non-inventory items, from QuickBooks Desktop to Excel. 

Steps to export inventory items from QuickBooks to Excel:

  1. Log into QuickBooks company file as an admin.
  2. Click on Lists from the main menu.
  3. Choose Inventory Item list.
  4. Click on the Excel dropdown option, then select Export all items.
  5. Choose one of the two options in the Export window:
    1. Create a new worksheet: QuickBooks desktop creates a new excel file with the inventory item list.
    2. Update an existing worksheet: QuickBooks updates an existing Excel worksheet with the inventory item data.
  6. Click on Export after verifying your preferences.

Export purchase orders from quickbooks to excel

You cannot export a purchase order directly from QuickBooks to Excel. However, you can filter inventory items in QuickBooks and then export the inventory list to Excel. You can use this list to create a purchase order manually outside QuickBooks.

If you need to export purchase orders from QuickBooks to Excel, then get in touch with our data migration experts.

Export sales order from quickbooks to excel

You cannot export a Sales order directly from QuickBooks to Excel. However, you can filter inventory items in QuickBooks and then export the inventory list to Excel. You can use this list to create a sales order manually outside QuickBooks.

If you need to export sales orders from QuickBooks to Excel, then get in touch with our data migration experts.

An export balance sheet from quickbooks to excel

Balance sheet is a financial statement that you can create using the transactions stored in QuickBooks desktop. You can choose the transactions for a specific date period, and then export those transactions to excel. You can then use the data to create a balance sheet in excel.

Another easy way is to create a balance sheet report in QuickBooks desktop, then export the report in Excel format.

Steps to export balance sheet from QuickBooks to Excel:

  1. Go to Reports from the main menu.
  2. Click on Company & Financial.
  3. Choose Balance Sheet Detail.
  4. From the top toolbar, choose Excel.
  5. Choose a location and then click on Save.

Export bank transactions from quickbooks to excel

You can export bank transactions directly from your bank account. However, if that’s not an option for you, then you can filter the transactions in QuickBooks so that you get a list of transactions associated with a particular bank account. You can then export these transactions.

Steps to export bank transactions from QuickBooks Desktop to Excel:

  1. From the Customers menu, click on Customer Center.
  2. Click on the Transactions tab.
  3. Choose Invoices and apply the various filters to narrow down your search. Choose the bank account as a filter to ensure that only transactions associated with that account are exported.
  4. Click on Run Reports once you’re sure that you’ve included all the transactions that you want to export to excel.
  5. At the top of the transactions report, click on the Excel drop-down option.
  6. Choose one of the two options in the Export window:
    1. Create a new worksheet: QuickBooks desktop creates a new excel file with the selected data.
    2. Update an existing worksheet: QuickBooks updates an existing Excel worksheet with the data selected by the user.
  7. Select your next options for the transactions report in the Send Report to Excel window.
  8. Click on Advanced to access additional options in QuickBooks Desktop for data export.
  9. Click on Ok, then on Export.
  10. Use MS Excel or another spreadsheet program to launch the Exported Excel file that contains the transactions data.

Export data from QuickBooks Mac to Excel

QuickBooks Desktop for Mac also has the ability to export your data in excel format. You can use MS Excel or the Apple Numbers software to access the exported files on your Mac.

Steps to export reports from QuickBooks Mac to Excel:

  1. From the main menu, click on Reports.
  2. Open or create the report that you want to export as an Excel file.
  3. Choose Export.
  4. When the Excel file opens up, click on File.
  5. Choose Save As, then select a location to save the file.

You can change the default app to open excel files. And you can even update an exported file with new data.

Import Excel from QuickBooks Online

Export customer data to Excel

QuickBooks online offers two different ways to export customer data to Excel. You can either use the customer menu or the reports menu to export your data, but the information included in the exported file differs on the basis of the method you choose.

Steps using customer page to export customer data from QuickBooks online to Excel:

  1. Click on the Get paid & pay menu.
  2. Choose Customers.
  3. Choose Export to Excel icon.
  4. Click on Print and save the data in excel format.

The reports option gives you more control over the type of data to include in the exported file. Using various filters available in QUickBooks online, you can narrow down on the data that you need to export.

Steps using reports page to export customer data from QuickBooks online to excel:

  1. From the Business overview menu, click on Reports.
  2. Click on the Customer Contact List from the Sales and Customers section. Follow these steps to modify your selection.
    1. Click on Customize.
    2. Click on Change columns from the Rows/Columns dropdown menus.
    3. Click on Run report after you’ve made all the changes to the report preferences.
    4. Click on Save customization if you want to store the settings and use them later for other reports.
  3. Click on the Export icon and choose Export to Excel.

Export reports to Excel from QuickBooks online

After generating a report, you can export the data included in the report in excel format. By doing so, you can use the data in other programs.

Steps to export reports from QuickBooks online to excel:

  1. From the dashboard, click on Business overview.
  2. Click on Reports.
  3. Choose the report that you want to export.
    Tip: you can use the search options to find specific reports in QuickBooks online.
  4. Click on the Export icon on top of the report.
  5. Choose Export to Excel.
  6. Select the local directory to which you want to save the Excel file containing the reports data.

Export employee data to Excel from QuickBooks online

To export employee or payroll data from QuickBooks online to excel, you can first create the report for the type of information you want to export. You can then use the export feature to export the report data in excel format.

Types of payroll and employee reports available in QuickBooks online

Steps to export employee data from QuickBooks online to Excel:

  1. From the dashboard, click on Business overview.
  2. Click on Reports, then Standard.
  3. Choose one of the employee or payroll reports.
    Tip: you can use the search options to find specific employee or payroll reports in QuickBooks online.
  4. Click on the Export icon on top of the payroll or employee report.
  5. Choose Export to Excel.

Select the local directory to which you want to save the Excel file containing the payroll or employee data.

Speak to A Specialist about QuickBooks Software

Headache🥺. Huh, Save time & money with QuickBooks Support 24×7 @ +1/, we provide assistance to those who face problems while using QuickBooks (Support all U.S. & Canada Editions)

--- Support - We provide solutions for the following QuickBooks (Pro, Premier, Accountant, Enterprise, Payroll, Cloud) ---

  • Error Support
  • Data Import
  • Data Conversion
  • Payment Solutions
  • Upgradation
  • Payroll Support
  • Data Export
  • Software Integration
  • QuickBooks Printer Support
  • Complete QuickBooks Solutions
  • Tax-Related Issues
  • Data Damage Recovery
  • Installation, Activation Help
  • QuickBooks Windows Support


Disclaimer : We are a third party agency working on providing authentic support and full fledged services for for accounting software QuickBooks 2018 version. It is one of… Read more

Phone

+1800-892-1352