I use GNUCash for personal finance and need to find a way to export the balances of all of my accounts in one CSV or any spreadsheet file. Exporting Account Tree doesn't work, and exporting transactions in a painstakingly long process to get the balances of all accounts.
I'm looking for something like the following:
Account Balance Savings $144.32DR Bank Loan $50.00CR etc.
The closest I got was being able to export the Trial Balance, however in HTML format this report is not useful.
The GNUCash 3.6 release notes have the following which could be of some use:
Allow CSV export of grand total amounts from reports using the trep-engine.
But I don't know how to export the information that I want