cancel
Showing results for 
Search instead for 
Did you mean: 
charris70
Level 1

Quickbooks 2019 and Office 365 Compatibility

I recently upgraded to Office 365.  Since this upgrade I cannot run EFile State SUI downloads from the payroll center.  When I run the process, I receive an error in Excel stating "The file format and extension of State_SUI.xlt don't match.  The file could be corrupted or unsafe.  Unless you trust its source, don't open it.  Do you want to open it anyway?".  When I select yes, and proceed with the Add-Ins Interview, I receive workbook format errors.  In other words, the SUI report being generated from QB is not formatted correctly to be read by Office 365 Excel.  Is Office 365 not compatible with QuickBooks?

1 Comment 1
Rasa-LilaM
QuickBooks Team

Quickbooks 2019 and Office 365 Compatibility

I’m glad to see in the QuickBooks Community, charris70.

 

Let me help you get around the error so you can smoothly e-file the state unemployment worksheet.


The first thing to do is save the tax form worksheet on your desktop. I’ll guide you through the detailed steps.

 

Here’s how:

 

  1. Open the tax form worksheet.
  2. Click on the File button.
  3. Select Save as.
  4. Navigate to the Desktop folder in the Save File window.
  5. Enter the file name.
  6. In the Save as type section, make sure to select Excel Workbook.
  7. Click on Save.


Once done, let’s set your Excel Office 365 as the default spreadsheet program. Let me walk you through the process:

  1. First, open the .xlsx file/tax form worksheet.
  2. Select Open with Excel 365.
  3. Then click on Choose another app.
  4. Click on Excel 365, and mark the box for Always use this app to open .xlsx files.
  5. Select OK.

I've added a link that will help you E-file State tax form and e-pay State tax liability.

 

That's it. After performing the resolution steps, you can successfully e-file the tax form worksheet.

 

Stay in touch if you have additional questions about processing tax forms in QuickBooks. I'll be glad to lend a helping hand. Have a great day ahead.

Need to get in touch?

Contact us