cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
LBerry
Level 1

Date above the data column in reports

When I run reports such as a monthly P&L Standard report, the header for the column above the numbers which has the date shows Jun 1-30, 20. My board wants the date to show Jun 1-30, 2020 reflecting the full year.  Is there a way to fix this?  I currently am using QB Desktop Pro.  

1 Comment 1
Rejeil_O
QuickBooks Team

Date above the data column in reports

Hi there, @LBerry.

 

Let me step in and help you with your concern. In QuickBooks Desktop, you're not able to filter the date of the column since this is the default date header on that statement. However, you can export the report into excel and edit the report as a workaround.

 

You can follow these steps to export your report into excel:

 

You can save the report as Excel workbooks (.xlsx), CSV spreadsheet, or PDF's.

  1. Open the report you want to export.
  2. Select the Excel button at the top of the page.
  3. Choose Create New Worksheet to create a new Excel workbook. If you already have an existing workbook, you can update it with the data in the open report by clicking the Update Existing Worksheet. Locate the workbook on your computer by ticking the Browse button. Note: Please know that it will overwrite the existing workbook.
  4. (Optional) If you want to format your data in a specific way, click Advanced.
  5. Hit OK. Select the Export to open the report in Excel.

 

For more detailed information about exporting a report, you can read this article: Export reports as Excel workbooks in QuickBooks Desktop

 

In case you'll need help importing transactions, feel free to visit this article for the steps: Import and export data in QuickBooks Desktop

 

If you'll have additional questions, please don't hesitate to leave a message in the comment section. I'll be happier to help. Take care and have a wonderful day!

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up