QB Enterprise Report Format Problem

Toonces · ‎February 26, 2020

Using QB Enterprise, we've noticed that some reports include an extra blank column on the left.

The extra blank column creates a shift of the column data one column to the right when we download the report into Excel. The column headers are not matching the data.

In the Excel example above, one can see what we are experiencing. ALL the data in the columns have shifted to the right one column. We have unchecked the (Left Margin) choice in the customize columns and the problem persists. When we download the QB report to the CSV format, the problem persists.

How to we remove this extra blank column from QB reports? Thanks!

Anna S · ‎February 26, 2020

Hello, @Toonces.

When exporting reports, the columns can sometimes be a little off like you mentioned above. I suggest deleting the blank column and moving all the headers over one to get the report information aligned correctly. This will get rid of the empty column and align all of your reports correctly. You may also want to reach out to the Microsoft Support Team or our QuickBooks Desktop Support Team to get the excel sheet formatted correctly.

Please feel free to comment below if you have any other questions. Have a wonderful Wednesday!

Toonces · ‎February 27, 2020

The plan was to import the CSV file into MS Access, run some queries, and then generate a report. Having to do more prep editing of the file compounds the pain and aggravation of the QB shortfall in not having custom calculated fields within the QB ENT environment.

We'll keep trying different QB reports, add columns, and test the CSV download. We've noticed that some reports do NOT have the leading empty columns.

Topics

Training

Community

Resources

QB Enterprise Report Format Problem

QB Enterprise Report Format Problem

QB Enterprise Report Format Problem

Need to get in touch?