cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want an expert to help you set up your QuickBooks Online? Find out how: Click here
martijn
Level 1

What is the best way to connect quickbooks to excel

best way to export data to excel 
2 Comments 2
4Gal
Level 11

What is the best way to connect quickbooks to excel

Do you need to export transactions or report?

 

ChristineJoieR
QuickBooks Team

What is the best way to connect quickbooks to excel

Hello there, martijn. I'm here to guarantee the successful export of all your transactions, ensuring they can be seamlessly imported into your new version of QuickBooks.

 

QuickBooks Online provides a straightforward method for transferring entries, allowing you to download and import them at your convenience.

 

To achieve this, you can export your reports and lists into individual Excel files, conveniently bundled in a zip format through a single process. It's important to set the date filter to cover year-to-date transactions. 

 

Here's a step-by-step guide:

 

  1. Go to the Gear icon.
  2. From the Tools, select Export Data.
  3. On the Reports tab, set the date field.
  4. Add items from the Reports/Lists tabs by toggling the slider.
  5. Press Export to Excel.

 

It's important to note that exporting non-posting transactions and attachments requires a separate process, as they are not included in the standard lists. To guide you through this, you can refer to the instructions outlined in this article: "Export reports, lists, and more."

 

Additionally, do you need data that isn’t found in basic reports? You can create custom reports to get the data that matters to you.

 

By following these steps, you surely get rolling. Let me know if you still need further assistance with the exporting method. I’ll always be here to assist you.