I am a QB desktop user and need to modify the trial balance report. I want to use the raw data contained in the trial balance report to be the underlying data in a financial model. I need the individual rows where the account and debit/credit information is contained to include at a minimum Class, but date would also be helpful.

What other reports have QB users found to be helpful for downloading historical financial data and loading it into a projection model?

One suggestion I found online suggested running the IS & BS detail reports and combining them to get a trial balance proxy with class. The issue i'm running into with this is the report formatting when I export to excel. There's too many rows and columns with subtotals that make rolling this into a pivot table impossible.