Thanks for joining the thread, ao12.

I know how important it is for your to get the unformatted General Ledger transaction in QuickBooks Online. However, this option is unavailable.

All exported data is compliant with QuickBooks standards. I understand that you can easily use the pivot feature in Excel to obtain the information you require without the pre-formatted data.

For the time being, you can continue to manipulate or customize the data from QuickBooks since this is the only way to use the pivot tables in Excel.

You can refer to this article for more information on exporting data in QuickBooks Online: Export reports, lists, and other data from QuickBooks Online.

Also, you can customize the look of your report by changing the layout or filtering to show only the information you need. For a comprehensive guide, see this link: Customize reports in QuickBooks Online.

Let me know if you need anything else by adding any details below. We're always here to help you.