Xero - beautiful accounting software

Xero Business Community

Xero Business Community

Hi everyone, Come on over to the new discussions in Xero Central. It’s a more intuitive way to connect and chat all things business with one another. Ask questions, dish out answers, and get involved.

You can still view topics in the Xero Business Community to see all the useful knowledge that’s been shared there; and you can restart conversations you feel have been of huge value to you on Xero Central.

If you have brilliant ideas for innovations, you can keep on adding feature requests in the Xero Business Community, and voting on existing requests. There’s more in store, as we come up with the best way to take on your thoughts and share developments
Community > Feature Requests >

Unable to analyse General Ledger in Excel without cleansing data

Started by Cindy Chan in Feature Requests | Idea

At this moment, when the Export Detail General Ledger to Excel, the account code is the first line, the opening balance in the second line and then the transaction detail is in the third line, etc which is unable to be analyse to any meaningful for anyone without cleansing the data.

Can I suggest when it press the button to Excel to be the following columns will be appeared .
First line Account code, date, type, transaction, reference, debit, credit, GST and YTD Balance on the column header
The transactions detail is the second line.

These ways -any user can pick up this excel file without cleansing the data, they can be using the filter function, creating table, Pivot Table or Pivot Query, etc. They can do the real job.

That will be great for users.