cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Community Explorer **

Does QuickBooks Online integrate with Microsoft Office 365 E3 plan / Azure?

 
5 Comments
QuickBooks Team

Hi hongraon456, I’m glad that you take time to ask about...

Hi hongraon456,

I’m glad that you take time to ask about Microsoft Office 365 E3 integration here.

Regardless of what of Microsoft Office you have, we can export reports to Excel, or import templates written in Word. However, we don’t have an option for direct integration.

In addition, we can bring your contacts in MS Outlook to QuickBooks Online through these steps:

  1. In Outlook/Outlook Express, Go to the File menu, and then click Import/Export
  2. Select Export to a file
  3. Select the option to export to Comma Separated Values (CSV) format. 
  4. Choose Contacts
  5. Specify a file name and location.  Click Next and then Finish.
  6. Using Excel, edit the CSV file to show a list of either your Customers or your Vendors/Suppliers and then save the CSV file.
  7. In QBO, go to the Gear Icon, under Tools, select Import Data.
  8. Choose Customers or Vendors/Suppliers as appropriate.
  9. Click Browse to locate and select the CSV file, and then click Open to select the file.  Click Next.
  10. Map your fields to QuickBooks Online fields.  Click Next.
  11. Make corrections if needed and click Import.

You can always get back to me if you have other questions about QuickBooks. Please use the comment section below. Thanks.

Experienced Member

Re: Hi hongraon456, I’m glad that you take time to ask about...

I have a client saying they are getting an error message when trying to export to Excel (office 365) from QBO? Says it's corrupt? Any suggestions for fixing this? They said they've done a repair and that isn't working.

QuickBooks Team

Re: Hi hongraon456, I’m glad that you take time to ask about...

Thank you for letting us know about this concern, @ktiesler027.

 

I’m here to help make sure you’re able to download your QuickBooks Online data successfully.

 

One possible you’re getting the error prompt “The file is corrupt and cannot be opened” is because of the Protective View setting of the Microsoft Excel installed in your device. Have you tried accessing your QuickBooks Online account via a different computer and export your data? If not yet, please do so.

 

On the other hand, let’s apply the following troubleshooting steps to ensure this is not browser-related.

  • Access your QuickBooks Online account via an incognito or private browser. Use either of the following shortcut keys:
    • Google Chrome, press CTRL  Shift N
    • Mozilla Firefox: press CTRL  Shift P
    • Internet Explorer: press CTRL  Shift P
    • Safari: press Command Shift N
  • If you’re able to download successfully and view your downloaded file, you may want to clear the cache and cookies of your regular web browsers and update the version of the Microsoft Excel installed in your computer.
  • You can also use the Browser Health Checkup Tool to check any issues with your browser’s health and its compatibility with QuickBooks Online.

If the issue persist, I suggest reaching out to our Customer Care team An agent will be able to look into your account and check on the error via a secured remote access session.

 

Please feel free to click the Reply button if you have follow-up questions about viewing your downloaded QuickBooks Online data. I’m always here to help.

Active Member

Re: Does QuickBooks Online integrate with Microsoft Office 365 E3 plan / Azure?

Is there a QB app within 365 for effort reporting / billing / time clock? 

Moderator

Re: Does QuickBooks Online integrate with Microsoft Office 365 E3 plan / Azure?

Thanks for joining the conversation, @blue2001,

 

Just like what my peer @JessT mentioned in his answer, QuickBooks will only allow exporting reports to Excel or importing Word templates. However, the direct integration between QBO and Office 365 is currently unavailable.

 

As an option, you can try checking our website to find compatible applications that work best for both programs. Here's how you can get there:

  1. Open this link: https://apps.intuit.com/app/apps/home
  2. Browse the applications using the search field.
  3. You can also choose the apps from the Categories section.

That should do it, @blue2001. Please let me know if you need further assistance with QuickBooks. You got me here to get things done for you. Have a good day!