Profit & Loss budget vs actual not exporting formulas to excel

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!

I figured it out.  If you export a report where the columns are collapsed, the exported columns with the totals in them are calculated from columns that are not exported, so the formula can't export.  So in these cases, excel will export the number instead of the formula (it really doesn't need to do that for the $ over budget and % over budget columns, since they are calculated based on the totals columns, but for whatever reason it exports the number there too). 

SO TO SOLVE IT you have to export the report with the columns expanded and then hide the columns you don't want in your exported report.  Kind of a pain in the butt, unfortunately.