You may be done with your project by now, but you can do this in seconds with a 3rd party app.

QuickBooks does not have a Trial Balance that separates out the expenses by class name.

The Trial Balance is not in one column where Debits are Positive and Credits are Negative.

The account numbers are embedded with the account name.

This makes data analysis clunky and time-consuming.

I am an accountant who wrote a utility called TBX Trial Balance Exporter back in 2004, which gives you these options. I don't see any sign that the T/B will be changed in Desktop.

Here is a link to the QuickBooks Desktop App page: Enjoy!

https://desktop.apps.com/apps/167772/tbx-trial-balance-exporter#!overview