Detail GL export data

It would be nice to export detail GL information without all the added headers and page breaks from FENXT. I would say most people exporting to excel are not doing so for a nice formatted report, but to manipulate the information. Also, when I do export the detail GL, half of the time the date and reference are not on the same line as the Debit/Credit. Perhaps this could be tweaked as well.

  • Carrie Duesenberg
  • Aug 8 2016
  • Implemented
  • Attach files
  • Deleted User commented
    21 Nov, 2017 05:49pm

    Hi everyone! It's been out for quite a while now, but I wanted to post back and let you know that the "Export excel data" option is available when exporting reports from NXT and strips out a lot of the extra "noise" around repeated page headers, footers, numbers, etc. I hope it meets your needs, but please let us know if you have any feedback!

  • Jennifer Kurtz commented
    10 Aug, 2017 09:09pm

    It would be great if the GL would allow for width beyond a page.  Currently if I try to include both a project and grant, each line takes up 2 lines which makes it difficult to review.  Same for JE reports.

  • Deleted User commented
    26 Oct, 2016 06:06pm

    Thanks, Steve. Would you be able to email me a screenshot so I can see exactly what you're referring to? 


  • Steve Harris commented
    26 Oct, 2016 12:14pm

    I noticed that this has been implemented but is not quite ready for prime time. I ran an income statement which uses the VCO and opted to export Excel data. Column headings appear once as expected and subtotals have been removed. However, row headers and total line headers are still included requiring that I still manipulate the data before I can use it, e.g. I need to sort on GL account number and then remove the group of headers that result. However that doesn't work because the export still contains merged cells. 

  • Deleted User commented
    9 Aug, 2016 02:01am

    Thanks for sharing! We're actually already planning to do this by adding a new "Export data" option to Excel. The goal is to strip out the additional headers, page breaks, and blank columns and make sure everything is formatting correctly. We hope to have it implemented in the next few weeks!