Time and date status on excel export

Elaine C · ‎November 29, 2021

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.

Rubielyn_J · ‎November 30, 2021

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:

Open the report.
Choose the Excel drop-down and select Create New Worksheet.
Click the Advanced button.
Enable the button next to the On printed report and screen.
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

Rubielyn_J · ‎November 30, 2021

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:

Open the report.
Choose the Excel drop-down and select Create New Worksheet.
Click the Advanced button.
Enable the button next to the On printed report and screen.
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 · ‎November 30, 2021

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 · ‎December 03, 2021

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 · ‎December 06, 2021

Hi thank you @Rubielyn_J all good. It works.

Topics

Training

Community

Resources

Time and date status on excel export