Get 50% OFF QuickBooks for 3 months*

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
FairHousingFM
Level 2

How to remove leading dates from Desktop reports

Report Date.jpgI want to export a file with data to create an Excel pivot table that I will update monthly.  I have figured out how to remove header information.  Does anyone know how, in QuickBooks, I can remove the first line in the report showing the report dates?  

1 Comment 1
jamespaul
Moderator

How to remove leading dates from Desktop reports

Hello, FairHousingFM. 

 

I appreciate the screenshot and details. I'll give a brief overview about the line header information. 

 

The line with the report dates will always show on the report view in QuickBooks. One way to remove it is to export the data to Excel, then manually delete the row (it is exported as a single row type). 

 

After exporting it to Excel, simply right-click on the line then select Delete row

 

deleterow21.PNG

 

For reference about customizing the reports in QuickBooks, you can read this article: Customize reports in QuickBooks Desktop.

 

We have other articles to help you achieve your tasks in QuickBooks. Feel free to browse them in the QuickBooks Desktop articles list page. 

 

I'm always available and ready to help you out. Please let know if there's anything else you'd like to take care of in QuickBooks. 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us