I needed to come up with a way of exporting this, as we are migrating accounting systems and wanted to import the TBs by class - this works for PL only (BS would have to be run from the beginning of your balance sheet...). 

follow these steps: 

1. Report---> my accountant----> "transaction detail by account" (I switch to classic view).

2. Enter the period you want for the TB (remember PL needs to be from the start of the financial period to the date you want the TB as at).

3. click the settings wheel and have only the following ticked: debits, credits, class, and account number. (untick everything else).

4. Then export this data to excel, highlight all and unmerge.

5. filter for "totals" and delete all these rows

6. Then copy down the GL codes into the blank cells - if you follow this formula step here it takes 2 seconds!

https://www.excelcampus.com/functions/fill-down-blank-cells/

7. I would then tidy up the data by copying and pasting values, then filtering on both debits and credits at the same time and delete any rows with nil in the the columns. 

8. Then simply do a pivot on the nominal code and the class in tabular formatting -- you will have a TB by class, this way. 

Formatting takes about 5-10mins. 

You can double check everything by doing sumifs to the normal TB report. Again, I have just done this for the PL codes--- the BS codes were taken from just the TB report. 

Hope this helps!! TIP: if you're going to be doing loads of these (we had to do 4 years worth) then I would format the report in quickbooks then save it to your custom reports so you're only having to change the date each time you run it.