CYBER MONDAY SALE 70% OFF QuickBooks for 3 months*   Ends 12/5

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks. Explore QuickBooks Payroll

Reply to message

View discussion in a popup

Replying to:
MariaSoledadG
QuickBooks Team

Reply to message

Let me provide some information about the extra row beneath each Expense Account line, JM952.

 

Generally, once you have already marked the Except zero Amounts check box, the display should be fine and should not show an extra row when printing the report. You'll want to export your report in Excel. This way, once there are issues when printing the report, you'll be able to edit it from there. To export a report, follow the steps below:

  1. In QuickBooks, go to the Reports menu and select Reports Center.
  2. Find and open any report.
  3. Select the Excel on the toolbar. You can also select Print or Email to save the report as a PDF.
    Save,
  4. To create a new Excel workbook, select Create New Worksheet. If you want to update an existing workbook with the data in the open report, select Update Existing Worksheet. Select Browse and then find the workbook on your computer. Keep in mind, this overwrites the existing workbook.
  5. If you want to format the data a specific way, select Advanced. This is optional.
    Note: The report must have less than 256 columns.

    If you see a message that says your report has too many columns, select Advanced. Select and uncheck the Space between columns checkbox, then select OK.

    You can also save your report as a CSV instead of an Excel workbook and have more columns.

  6. When you’re ready to export, select OK. To open the report in Excel, you can also select Export.

For more QuickBooks Desktop help articles, you can visit this link for more information.

 

Feel free to let us know if you need assistance with printing a report. As always, we're here to give our best shot to cover up all your concerns. 

Need to get in touch?

Contact us