OK - so I'm curious...

Just exactly how do the accountants expect the Excel spreadsheet to be laid out when they are asking for items that have a one (Ledger opening and closing balances) to many (GL Posted transactions) relationship?

I'd REALLY like to know. Nothing that is readable can be manipulated, and nothing that can be manipulated (imported, sorted, filered) will be readable.