Here is the work around I was given by QBO chat operator...

pull up the transaction report.

Afterwards, click  save customization.>> Click reports>> click custom reports>> click the drop down arrow>> export to excel.

This worked for me, hopefully it will help others until the issue is resolved.