Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.

Reply to message

View discussion in a popup

Replying to:
ChristieAnn
QuickBooks Team

Reply to message

Welcome back to the QuickBooks Community, Carlyle. I'll be sharing details on how exporting reports works in QuickBooks Desktop. Then, ensure you can perform an alternative way to achieve your goal.

 

QuickBooks Desktop shows reports based on a set of instructions known as a Report set. Through this set of instructions, information is extracted from the data file and shown as a set of transaction lines. The report set determines which lines of which transactions are included in the report. However, when you export the report to Excel, some details, like columns and formulas may differ.

 

Those formulas that you've seen after exporting are the columns that have figures that came from within the same report to come up with the correct amount. Then, those details exported to the column as a number are the value of the data. With this, making the exported data so you can view it all as a formula is currently unavailable.

 

For now, you'll have to check all the amounts inside QuickBooks so you can confirm where they coming from. Also, to view the full details of the transactions.

 

Lastly, you may refer to this article to see steps on how you can memorize reports in QuickBooks so the same settings of the customized report are available for future use: Create, access and modify memorized reports.

 

You can drop me a comment below if you have any other questions besides exporting reports in QBDT. I'll be happy to help you some more, Carlyle. Stay safe!

Need to get in touch?

Contact us