Skip to main content
Jul 3, 2022 9:55 AM UTC
Question

QBO Exporting files to Excel and Auto Outline and Auto Filter

Hi

QBO Exporting files to Excel and Auto Outline and Auto Filter

In Desktop - easy to export to excel with the auto outline and auto filter

In QBO - this doesnt seem to work for all transaction reports, I can get the PL BS type reports to work but not a nominal ledger.

I have tried different browsers , I have tried copy and paste from the exported excel file and nothing works.

Can anyone help - I have a 15 cos with the audits coming up and a lot of long reports.

 

Thanks

CLP

4 replies

Fiat Lux - ASIA
Jul 3, 2022 11:33 AM UTC

QBO offers limited reporting capabilities compared to QBD. Consider having a BI app to integrate with QBO as a workaround.

Jul 3, 2022 12:17 PM UTC

Hi there, CLP417.

 

I believe this is a duplicate post and my colleague already answered and gave you the details. Check out this link for more info: https://quickbooks.intuit.com/learn-support/en-us/reports-and-accounting/re-export-from-qb-online-to-excel-with-formulas-esp-transaction/01/1108992/highlight/true#M161539

 

Let us know in the comment below if you still have other question about reports in QuickBooks. I'll be around if you need help. Have a great day!

CLP417Author
Jul 3, 2022 3:28 PM UTC

What is a BI app?

Fiat Lux - ASIA
Jul 3, 2022 5:29 PM UTC

Business Intelligent app. Like this one

https://go.zoho.com/LcV