Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
August 16, 2021
Question

Management Reports - export to Excel

  • August 16, 2021
  • 9 replies
  • 17 views

I create Management Reports for clients on a monthly basis.  One client wants a one specific report in the Management Report in Excel format - is there a way to have this generated automatically with the others?  Or do I have to manually do this every month?

9 replies

QuickBooks Team
August 16, 2021

I've got your back, KariBeebeLLC.

 

I'm here to share some details about customizing and exporting Management reports in QuickBooks Online.

 

As of now, we can only export Management reports via PDF or DOCX. As a workaround, I'd suggest running specific standard reports. I'd recommend checking the reports listed below to ensure you'll get the data your client likes to see.

 

Company Overview

  • Balance Sheet
  • Profit and Loss

Sales Performance

  • Accounts receivable aging detail
  • Sales by Customer Summary

Expense Performance

  • Accounts payable aging detail
  • Expense by Vendor Summary

 

Once you've selected a report, you can customize it to filter the details needed. Then, click on Save customization to easily access it in the future. After that, you can now export the report.

To easily access the report in the following months, you can go to the Custom reports tab. From them, you can click the drop-down menu under Action to export the report.

 

Also, you can submit feedback to our Product Development team to add the ability to export your Management report via Excel. Doing so improves your experience with QuickBooks.

 

Additionally, I encourage memorizing your reports in QuickBooks Online. This way, you'll be able to easily access the current customized settings. 

 

Feel free to comment down below if you have any other concerns or questions about managing reports. I'm always glad to help in any way I can.

KariBeebeAuthor
August 18, 2021

Thank you for the reply - I should have been more clear.  I run a Management report - which is a collection of reports that I have put together.  I want one report of the collection of reports to be in xslx format when run.  Possible? 

Fiat Lux - ASIA
Level 14
August 17, 2021

@KariBeebe 

Utilize a BI app as a workaround.

KariBeebeAuthor
August 18, 2021

Can you be more specific on what a BI app is and what it does?  Thank you.

Fiat Lux - ASIA
Level 14
April 27, 2023

Yes--this takes a ton of time.  That's why we've reviewed your management reports...and dismissed them as not suited for purpose.  And your excel report formatting is ugly and unprofessional. We need to spend 20 minutes just making them look like something issued by a professional and not put together by a 16 year old taking a bookkeeping class.

 

Can anyone suggest a BI tool created by actual accountants?


@CFOSecrets 

Explore this one

https://go.zoho.com/M5c