cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Created with Sketch. The QuickBooks Community will be unavailable for approximately 1 hour beginning at 10:00 PM PDT on Wednesday, August 14th for database maintenance. All community forums will be unavailable during maintenance but feel free to browse our Support articles for help in the interim.
FairHousingFM
Level 2

Exported Excel report drops trailing zeros

When I export a Tax Forms Worksheet to Excel 2016 from QuickBooks Desktop 2018, the resulting Excel spreadsheet drops trailing zeros.  For example, if wages are 330.00, the actual cell value is 330, not 330.00.  However, WA state requires that the actual cell value in imported spreadsheets include the trailing zeros.  I've tried custom formatting and copying as text values without success.  Any suggestions?

3 Comments 3
Anna S
QuickBooks Team

Exported Excel report drops trailing zeros

Good evening, @FairHousingFM.

 

I want to ensure you get the support you need.

 

Reaching out to the Community is an excellent start because our experts and Community Members are very knowledgable with QuickBooks Products. However, when it comes to exporting your Tax Form Worksheet to Excel, I suggest calling the Microsoft Support Team. They have the tools to better assist you with formatting your Excel sheet. You can find their number with a quick Google search.

 

Thank you for being part of the QuickBooks family. Wishing you continued success now and in the future!

BigRedConsulting
Community Champion

Exported Excel report drops trailing zeros

QuickBooks does not create a spreadsheet in Excel that you can submit directly to WA state.

 

What is it you're trying to do?  What report are you running from the QB menu?

FairHousingFM
Level 2

Exported Excel report drops trailing zeros

I use the Tax Form Worksheets under More Payroll Reports in Excel and request a State Wage Listing for the prior quarter in which I then delete extraneous rows and column to create a csv file.  I've subsequently been told that you can't open the csv file before uploading the file - do all editing in the excel file, save as a csv file and upload without ever opening the csv file.  I haven't been able to test this yet, but will try next quarter.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us