Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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?
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!
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?
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here