cancel
Showing results for 
Search instead for 
Did you mean: 
Elaine C
Level 2

Time and date status on excel export

Hello.  Can someone advise whereabout to turn on the time and date feature on the top right corner of an excel report that is exported from Quickbooks?  The same report reflects time and date status when it is in Quickbooks but not when exported.  Thank you.

 

 

Solved
Best answer November 30, 2021

Best Answers
Rubielyn_J
QuickBooks Team

Time and date status on excel export

I've got your back to ensure that the time and date of the report will reflect when exported to an Excel file, @Elaine C.

 

We can use the Advanced feature when trying to export a statement. This way, the report header will appear in your Excel data. 

 

Here's how:

 

  1. Open the report. 
  2. Choose the Excel drop-down and select Create New Worksheet.
  3. Click the Advanced button.
  4. Enable the button next to the On printed report and screen.
  5. Lastly, click OK.



 

In addition to that, let me share these links to help you manage your reports in QuickBooks Desktop: 

 

 

Keep in touch if you need additional help handling various statements in QuickBooks. I'm always around to assist you. Have a great day!

View solution in original post

4 Comments 4
Rubielyn_J
QuickBooks Team

Time and date status on excel export

I've got your back to ensure that the time and date of the report will reflect when exported to an Excel file, @Elaine C.

 

We can use the Advanced feature when trying to export a statement. This way, the report header will appear in your Excel data. 

 

Here's how:

 

  1. Open the report. 
  2. Choose the Excel drop-down and select Create New Worksheet.
  3. Click the Advanced button.
  4. Enable the button next to the On printed report and screen.
  5. Lastly, click OK.



 

In addition to that, let me share these links to help you manage your reports in QuickBooks Desktop: 

 

 

Keep in touch if you need additional help handling various statements in QuickBooks. I'm always around to assist you. Have a great day!

BigRedConsulting
Community Champion

Time and date status on excel export

If visible on your report in QuickBooks, the date and time are always sent to Excel, either in the page header area or on the worksheet itself, depending report header setting.

 

If your goal is to be sure this data is included in the report spreadsheet file or to see it when printing the report, either option will work.

Rubielyn_J
QuickBooks Team

Time and date status on excel export

Hi, @Elaine C.

 

Hope you’re doing great. I wanted to see how everything is going about the exporting report concern you had the other day. Was it resolved? Do you need any additional help or clarification? If you do, just let me know. I’d be happy to help you at any time.

 

Looking forward to your reply. Have a pleasant day ahead!

Elaine C
Level 2

Time and date status on excel export

Hi thank you @Rubielyn_J  all good.  It works.

Need to get in touch?

Contact us