Thank you, this is very helpful. My only issue with this report now, is that when i go to export to excel, the line breaks inbetween transaction numbers make this again not usable in a pivot table. 

Based on my reading, it seems like the best way to get a proxy trial balance that includes class is to download the PL and BS detail reports and exclude net income. These also come with terrible formatting for a data dump to excel. 

Do you know of a way to change report formats in QB so excel downloads work cleanly?